{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["聯絡我","勞基法1071121","勞基法施行細則1080214","問題","到職日後強制進位至整數","官方算法_到職日前四捨五入到小數第二位","到職日後四捨五入進位至整數","員工資料整理區","特休試算","統計表","Sheet1"],"not_rendered":{"images":1,"macros":1,"defined_names":5,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"聯絡我","index":0,"n_rows":10,"n_cols":20,"rows_kept":10,"merged":[[0,2,0,11],[4,13,4,18],[9,13,9,18]]}
[null,"網址:","https://www.gisin.com.tw/"]
[]
[]
[]
[{"$nulls":13},"選擇特休試算方式"]
[{"$nulls":19},"<<特休試算方式按官方算法, 會有小數"]
[{"$nulls":19},"<<年度特休天數整數化_方式一"]
[{"$nulls":19},"<<年度特休天數整數化_方式二"]
[{"$nulls":19},"<<可以貼上公司所有員工到職日等資料進行試算"]
[{"$nulls":13},"點擊進入試算"]

{"sheet":"勞基法1071121","index":1,"n_rows":670,"n_cols":2,"rows_kept":670,"merged":[[324,0,340,0]]}
[null,"法規名稱：勞動基準法 英"]
[null,"修正日期：民國 107 年 11 月 21 日"]
[null,"法規類別：行政 ＞ 勞動部 ＞ 勞動條件及就業平等目"]
[null,"第 一 章 總則"]
[null,"第 1 條"]
[{"$f":"IF(LEFT(B5,1)=\"第\",B5,\"\")","v":"第 1 條"},"為規定勞動條件最低標準，保障勞工權益，加強勞雇關係，促進社會與經"]
[{"$f":"IF(LEFT(B6,1)=\"第\",B6,\"\")","v":""},"濟發展，特制定本法；本法未規定者，適用其他法律之規定。"]
["","雇主與勞工所訂勞動條件，不得低於本法所定之最低標準。"]
["","第 2 條"]
["第 2 條","本法用辭定義如左："]
["","一、勞工：謂受雇主僱用從事工作獲致工資者。"]
["","二、雇主：謂僱用勞工之事業主、事業經營之負責人或代表事業主處理有"]
["","關勞工事務之人。"]
["","三、工資：謂勞工因工作而獲得之報酬；包括工資、薪金及按計時、計日"]
["","、計月、計件以現金或實物等方式給付之獎金、津貼及其他任何名義"]
["","之經常性給與均屬之。"]
["","四、平均工資：謂計算事由發生之當日前六個月內所得工資總額除以該期"]
["","間之總日數所得之金額。工作未滿六個月者，謂工作期間所得工資總"]
["","額除以工作期間之總日數所得之金額。工資按工作日數、時數或論件"]
["","計算者，其依上述方式計算之平均工資，如少於該期內工資總額除以"]
["","實際工作日數所得金額百分之六十者，以百分之六十計。"]
["","五、事業單位：謂適用本法各業僱用勞工從事工作之機構。"]
["","六、勞動契約：謂約定勞雇關係之契約。"]
["","第 3 條"]
["第 3 條","本法於左列各業適用之："]
["","一、農、林、漁、牧業。"]
["","二、礦業及土石採取業。"]
["","三、製造業。"]
["","四、營造業。"]
["","五、水電、煤氣業。"]
["","六、運輸、倉儲及通信業。"]
["","七、大眾傳播業。"]
["","八、其他經中央主管機關指定之事業。"]
["","依前項第八款指定時，得就事業之部分工作場所或工作者指定適用。"]
["","本法適用於一切勞雇關係。但因經營型態、管理制度及工作特性等因素適"]
["","用本法確有窒礙難行者，並經中央主管機關指定公告之行業或工作者，不"]
["","適用之。"]
["","前項因窒礙難行而不適用本法者，不得逾第一項第一款至第七款以外勞工"]
["","總數五分之一。"]
["","第 4 條"]
["第 4 條","本法所稱主管機關：在中央為勞動部；在直轄市為直轄市政府；在縣（市"]
["","）為縣（市）政府。"]
["","第 5 條"]
["第 5 條","雇主不得以強暴、脅迫、拘禁或其他非法之方法，強制勞工從事勞動。"]
["","第 6 條"]
["第 6 條","任何人不得介入他人之勞動契約，抽取不法利益。"]
["","第 7 條"]
["第 7 條","雇主應置備勞工名卡，登記勞工之姓名、性別、出生年月日、本籍、教育"]
["","程度、住址、身分證統一號碼、到職年月日、工資、勞工保險投保日期、"]
["","獎懲、傷病及其他必要事項。"]
["","前項勞工名卡，應保管至勞工離職後五年。"]
["","第 8 條"]
["第 8 條","雇主對於僱用之勞工，應預防職業上災害，建立適當之工作環境及福利設"]
["","施。其有關安全衛生及福利事項，依有關法律之規定。"]
["","第 二 章 勞動契約"]
[null,"第 9 條"]
["第 9 條","勞動契約，分為定期契約及不定期契約。臨時性、短期性、季節性及特定"]
["","性工作得為定期契約；有繼續性工作應為不定期契約。"]
["","定期契約屆滿後，有左列情形之一者，視為不定期契約："]
["","一、勞工繼續工作而雇主不即表示反對意思者。"]
["","二、雖經另訂新約，惟其前後勞動契約之工作期間超過九十日，前後契約"]
["","間斷期間未超過三十日者。"]
["","前項規定於特定性或季節性之定期工作不適用之。"]
["","第 9-1 條"]
["第 9-1 條","未符合下列規定者，雇主不得與勞工為離職後競業禁止之約定："]
["","一、雇主有應受保護之正當營業利益。"]
["","二、勞工擔任之職位或職務，能接觸或使用雇主之營業秘密。"]
["","三、競業禁止之期間、區域、職業活動之範圍及就業對象，未逾合理範疇"]
["","。"]
["","四、雇主對勞工因不從事競業行為所受損失有合理補償。"]
[{"$f":"IF(LEFT(B70,1)=\"第\",B70,\"\")","v":""},"前項第四款所定合理補償，不包括勞工於工作期間所受領之給付。"]
["","違反第一項各款規定之一者，其約定無效。"]
["","離職後競業禁止之期間，最長不得逾二年。逾二年者，縮短為二年。"]
["","第 10 條"]
["第 10 條","定期契約屆滿後或不定期契約因故停止履行後，未滿三個月而訂定新約或"]
["","繼續履行原約時，勞工前後工作年資，應合併計算。"]
["","第 10-1 條"]
["第 10-1 條","雇主調動勞工工作，不得違反勞動契約之約定，並應符合下列原則："]
["","一、基於企業經營上所必須，且不得有不當動機及目的。但法律另有規定"]
["","者，從其規定。"]
["","二、對勞工之工資及其他勞動條件，未作不利之變更。"]
["","三、調動後工作為勞工體能及技術可勝任。"]
["","四、調動工作地點過遠，雇主應予以必要之協助。"]
["","五、考量勞工及其家庭之生活利益。"]
["","第 11 條"]
["第 11 條","非有左列情事之一者，雇主不得預告勞工終止勞動契約："]
["","一、歇業或轉讓時。"]
["","二、虧損或業務緊縮時。"]
["","三、不可抗力暫停工作在一個月以上時。"]
["","四、業務性質變更，有減少勞工之必要，又無適當工作可供安置時。"]
["","五、勞工對於所擔任之工作確不能勝任時。"]
["","第 12 條"]
["第 12 條","勞工有左列情形之一者，雇主得不經預告終止契約："]
["","一、於訂立勞動契約時為虛偽意思表示，使雇主誤信而有受損害之虞者。"]
["","二、對於雇主、雇主家屬、雇主代理人或其他共同工作之勞工，實施暴行"]
["","或有重大侮辱之行為者。"]
["","三、受有期徒刑以上刑之宣告確定，而未諭知緩刑或未准易科罰金者。"]
["","四、違反勞動契約或工作規則，情節重大者。"]
["","五、故意損耗機器、工具、原料、產品，或其他雇主所有物品，或故意洩"]
["","漏雇主技術上、營業上之秘密，致雇主受有損害者。"]
["","六、無正當理由繼續曠工三日，或一個月內曠工達六日者。"]
["","雇主依前項第一款、第二款及第四款至第六款規定終止契約者，應自知悉"]
["","其情形之日起，三十日內為之。"]
["","第 13 條"]
["第 13 條","勞工在第五十條規定之停止工作期間或第五十九條規定之醫療期間，雇主"]
["","不得終止契約。但雇主因天災、事變或其他不可抗力致事業不能繼續，經"]
["","報主管機關核定者，不在此限。"]
["","第 14 條"]
["第 14 條","有下列情形之一者，勞工得不經預告終止契約："]
["","一、雇主於訂立勞動契約時為虛偽之意思表示，使勞工誤信而有受損害之"]
["","虞者。"]
["","二、雇主、雇主家屬、雇主代理人對於勞工，實施暴行或有重大侮辱之行"]
["","為者。"]
["","三、契約所訂之工作，對於勞工健康有危害之虞，經通知雇主改善而無效"]
["","果者。"]
["","四、雇主、雇主代理人或其他勞工患有法定傳染病，對共同工作之勞工有"]
["","傳染之虞，且重大危害其健康者。"]
["","五、雇主不依勞動契約給付工作報酬，或對於按件計酬之勞工不供給充分"]
["","之工作者。"]
["","六、雇主違反勞動契約或勞工法令，致有損害勞工權益之虞者。"]
["","勞工依前項第一款、第六款規定終止契約者，應自知悉其情形之日起，三"]
["","十日內為之。但雇主有前項第六款所定情形者，勞工得於知悉損害結果之"]
["","日起，三十日內為之。"]
["","有第一項第二款或第四款情形，雇主已將該代理人間之契約終止，或患有"]
["","法定傳染病者依衛生法規已接受治療時，勞工不得終止契約。"]
["","第十七條規定於本條終止契約準用之。"]
["第十七條規定於本條終止契約準用之。","第 15 條"]
["第 15 條","特定性定期契約期限逾三年者，於屆滿三年後，勞工得終止契約。但應於"]
["","三十日前預告雇主。"]
["","不定期契約，勞工終止契約時，應準用第十六條第一項規定期間預告雇主"]
["","。"]
["","第 15-1 條"]
["第 15-1 條","未符合下列規定之一，雇主不得與勞工為最低服務年限之約定："]
["","一、雇主為勞工進行專業技術培訓，並提供該項培訓費用者。"]
[{"$f":"IF(LEFT(B134,1)=\"第\",B134,\"\")","v":""},"二、雇主為使勞工遵守最低服務年限之約定，提供其合理補償者。"]
["","前項最低服務年限之約定，應就下列事項綜合考量，不得逾合理範圍："]
["","一、雇主為勞工進行專業技術培訓之期間及成本。"]
["","二、從事相同或類似職務之勞工，其人力替補可能性。"]
["","三、雇主提供勞工補償之額度及範圍。"]
["","四、其他影響最低服務年限合理性之事項。"]
["","違反前二項規定者，其約定無效。"]
["","勞動契約因不可歸責於勞工之事由而於最低服務年限屆滿前終止者，勞工"]
["","不負違反最低服務年限約定或返還訓練費用之責任。"]
["","第 16 條"]
["第 16 條","雇主依第十一條或第十三條但書規定終止勞動契約者，其預告期間依左列"]
["","各款之規定："]
["","一、繼續工作三個月以上一年未滿者，於十日前預告之。"]
["","二、繼續工作一年以上三年未滿者，於二十日前預告之。"]
["","三、繼續工作三年以上者，於三十日前預告之。"]
["","勞工於接到前項預告後，為另謀工作得於工作時間請假外出。其請假時數"]
["","，每星期不得超過二日之工作時間，請假期間之工資照給。"]
["","雇主未依第一項規定期間預告而終止契約者，應給付預告期間之工資。"]
["","第 17 條"]
["第 17 條","雇主依前條終止勞動契約者，應依下列規定發給勞工資遣費："]
["","一、在同一雇主之事業單位繼續工作，每滿一年發給相當於一個月平均工"]
["","資之資遣費。"]
["","二、依前款計算之剩餘月數，或工作未滿一年者，以比例計給之。未滿一"]
["","個月者以一個月計。"]
["","前項所定資遣費，雇主應於終止勞動契約三十日內發給。"]
["","第 18 條"]
["第 18 條","有左列情形之一者，勞工不得向雇主請求加發預告期間工資及資遣費："]
["","一、依第十二條或第十五條規定終止勞動契約者。"]
["","二、定期勞動契約期滿離職者。"]
["","第 19 條"]
["第 19 條","勞動契約終止時，勞工如請求發給服務證明書，雇主或其代理人不得拒絕"]
["","。"]
["","第 20 條"]
["第 20 條","事業單位改組或轉讓時，除新舊雇主商定留用之勞工外，其餘勞工應依第"]
["","十六條規定期間預告終止契約，並應依第十七條規定發給勞工資遣費。其"]
["","留用勞工之工作年資，應由新雇主繼續予以承認。"]
["","第 三 章 工資"]
[null,"第 21 條"]
["第 21 條","工資由勞雇雙方議定之。但不得低於基本工資。"]
["","前項基本工資，由中央主管機關設基本工資審議委員會擬訂後，報請行政"]
["","院核定之。"]
["","前項基本工資審議委員會之組織及其審議程序等事項，由中央主管機關另"]
["","以辦法定之。"]
["","第 22 條"]
["第 22 條","工資之給付，應以法定通用貨幣為之。但基於習慣或業務性質，得於勞動"]
["","契約內訂明一部以實物給付之。工資之一部以實物給付時，其實物之作價"]
["","應公平合理，並適合勞工及其家屬之需要。"]
["","工資應全額直接給付勞工。但法令另有規定或勞雇雙方另有約定者，不在"]
["","此限。"]
["","第 23 條"]
["第 23 條","工資之給付，除當事人有特別約定或按月預付者外，每月至少定期發給二"]
["","次，並應提供工資各項目計算方式明細；按件計酬者亦同。"]
["","雇主應置備勞工工資清冊，將發放工資、工資各項目計算方式明細、工資"]
["","總額等事項記入。工資清冊應保存五年。"]
["","第 24 條"]
["第 24 條","雇主延長勞工工作時間者，其延長工作時間之工資，依下列標準加給："]
["","一、延長工作時間在二小時以內者，按平日每小時工資額加給三分之一以"]
["","上。"]
["","二、再延長工作時間在二小時以內者，按平日每小時工資額加給三分之二"]
["","以上。"]
["","三、依第三十二條第四項規定，延長工作時間者，按平日每小時工資額加"]
["","倍發給。"]
["","雇主使勞工於第三十六條所定休息日工作，工作時間在二小時以內者，其"]
["","工資按平日每小時工資額另再加給一又三分之一以上；工作二小時後再繼"]
[{"$f":"IF(LEFT(B198,1)=\"第\",B198,\"\")","v":""},"續工作者，按平日每小時工資額另再加給一又三分之二以上。"]
["","第 25 條"]
["第 25 條","雇主對勞工不得因性別而有差別之待遇。工作相同、效率相同者，給付同"]
["","等之工資。"]
["","第 26 條"]
["第 26 條","雇主不得預扣勞工工資作為違約金或賠償費用。"]
["","第 27 條"]
["第 27 條","雇主不按期給付工資者，主管機關得限期令其給付。"]
["","第 28 條"]
["第 28 條","雇主有歇業、清算或宣告破產之情事時，勞工之下列債權受償順序與第一"]
["","順位抵押權、質權或留置權所擔保之債權相同，按其債權比例受清償；未"]
["","獲清償部分，有最優先受清償之權："]
["","一、本於勞動契約所積欠之工資未滿六個月部分。"]
["","二、雇主未依本法給付之退休金。"]
["","三、雇主未依本法或勞工退休金條例給付之資遣費。"]
["","雇主應按其當月僱用勞工投保薪資總額及規定之費率，繳納一定數額之積"]
["","欠工資墊償基金，作為墊償下列各款之用："]
["","一、前項第一款積欠之工資數額。"]
["","二、前項第二款與第三款積欠之退休金及資遣費，其合計數額以六個月平"]
["","均工資為限。"]
["","積欠工資墊償基金，累積至一定金額後，應降低費率或暫停收繳。"]
["","第二項費率，由中央主管機關於萬分之十五範圍內擬訂，報請行政院核定"]
[null,"之。"]
["","雇主積欠之工資、退休金及資遣費，經勞工請求未獲清償者，由積欠工資"]
["","墊償基金依第二項規定墊償之；雇主應於規定期限內，將墊款償還積欠工"]
["","資墊償基金。"]
["","積欠工資墊償基金，由中央主管機關設管理委員會管理之。基金之收繳有"]
["","關業務，得由中央主管機關，委託勞工保險機構辦理之。基金墊償程序、"]
["","收繳與管理辦法、第三項之一定金額及管理委員會組織規程，由中央主管"]
["","機關定之。"]
["","第 29 條"]
["第 29 條","事業單位於營業年度終了結算，如有盈餘，除繳納稅捐、彌補虧損及提列"]
["","股息、公積金外，對於全年工作並無過失之勞工，應給與獎金或分配紅利"]
["","。"]
["","第 四 章 工作時間、休息、休假"]
[null,"第 30 條"]
["第 30 條","勞工正常工作時間，每日不得超過八小時，每週不得超過四十小時。"]
["","前項正常工作時間，雇主經工會同意，如事業單位無工會者，經勞資會議"]
["","同意後，得將其二週內二日之正常工作時數，分配於其他工作日。其分配"]
["","於其他工作日之時數，每日不得超過二小時。但每週工作總時數不得超過"]
["","四十八小時。"]
["","第一項正常工作時間，雇主經工會同意，如事業單位無工會者，經勞資會"]
[null,"議同意後，得將八週內之正常工作時數加以分配。但每日正常工作時間不"]
["","得超過八小時，每週工作總時數不得超過四十八小時。"]
["","前二項規定，僅適用於經中央主管機關指定之行業。"]
["","雇主應置備勞工出勤紀錄，並保存五年。"]
["","前項出勤紀錄，應逐日記載勞工出勤情形至分鐘為止。勞工向雇主申請其"]
["","出勤紀錄副本或影本時，雇主不得拒絕。"]
["","雇主不得以第一項正常工作時間之修正，作為減少勞工工資之事由。"]
["","第一項至第三項及第三十條之一之正常工作時間，雇主得視勞工照顧家庭"]
[null,"成員需要，允許勞工於不變更每日正常工作時數下，在一小時範圍內，彈"]
["","性調整工作開始及終止之時間。"]
["","第 30-1 條"]
["第 30-1 條","中央主管機關指定之行業，雇主經工會同意，如事業單位無工會者，經勞"]
["","資會議同意後，其工作時間得依下列原則變更："]
["","一、四週內正常工作時數分配於其他工作日之時數，每日不得超過二小時"]
["","，不受前條第二項至第四項規定之限制。"]
["","二、當日正常工作時間達十小時者，其延長之工作時間不得超過二小時。"]
["","三、女性勞工，除妊娠或哺乳期間者外，於夜間工作，不受第四十九條第"]
["","一項之限制。但雇主應提供必要之安全衛生設施。"]
["","依中華民國八十五年十二月二十七日修正施行前第三條規定適用本法之行"]
["","業，除第一項第一款之農、林、漁、牧業外，均不適用前項規定。"]
["","第 31 條"]
["第 31 條","在坑道或隧道內工作之勞工，以入坑口時起至出坑口時止為工作時間。"]
[{"$f":"IF(LEFT(B262,1)=\"第\",B262,\"\")","v":""},"第 32 條"]
["第 32 條","雇主有使勞工在正常工作時間以外工作之必要者，雇主經工會同意，如事"]
["","業單位無工會者，經勞資會議同意後，得將工作時間延長之。"]
["","前項雇主延長勞工之工作時間連同正常工作時間，一日不得超過十二小時"]
["","；延長之工作時間，一個月不得超過四十六小時，但雇主經工會同意，如"]
["","事業單位無工會者，經勞資會議同意後，延長之工作時間，一個月不得超"]
["","過五十四小時，每三個月不得超過一百三十八小時。"]
["","雇主僱用勞工人數在三十人以上，依前項但書規定延長勞工工作時間者，"]
["","應報當地主管機關備查。"]
["","因天災、事變或突發事件，雇主有使勞工在正常工作時間以外工作之必要"]
["","者，得將工作時間延長之。但應於延長開始後二十四小時內通知工會；無"]
["","工會組織者，應報當地主管機關備查。延長之工作時間，雇主應於事後補"]
["","給勞工以適當之休息。"]
["","在坑內工作之勞工，其工作時間不得延長。但以監視為主之工作，或有前"]
["","項所定之情形者，不在此限。"]
["","第 32-1 條"]
["第 32-1 條","雇主依第三十二條第一項及第二項規定使勞工延長工作時間，或使勞工於"]
["","第三十六條所定休息日工作後，依勞工意願選擇補休並經雇主同意者，應"]
[null,"依勞工工作之時數計算補休時數。"]
["","前項之補休，其補休期限由勞雇雙方協商；補休期限屆期或契約終止未補"]
["","休之時數，應依延長工作時間或休息日工作當日之工資計算標準發給工資"]
["","；未發給工資者，依違反第二十四條規定論處。"]
["","第 33 條"]
["第 33 條","第三條所列事業，除製造業及礦業外，因公眾之生活便利或其他特殊原因"]
[null,"，有調整第三十條、第三十二條所定之正常工作時間及延長工作時間之必"]
["","要者，得由當地主管機關會商目的事業主管機關及工會，就必要之限度內"]
["","以命令調整之。"]
["","第 34 條"]
["第 34 條","勞工工作採輪班制者，其工作班次，每週更換一次。但經勞工同意者不在"]
["","此限。"]
["","依前項更換班次時，至少應有連續十一小時之休息時間。但因工作特性或"]
["","特殊原因，經中央目的事業主管機關商請中央主管機關公告者，得變更休"]
["","息時間不少於連續八小時。"]
["","雇主依前項但書規定變更休息時間者，應經工會同意，如事業單位無工會"]
["","者，經勞資會議同意後，始得為之。雇主僱用勞工人數在三十人以上者，"]
["","應報當地主管機關備查。"]
["","第 35 條"]
["第 35 條","勞工繼續工作四小時，至少應有三十分鐘之休息。但實行輪班制或其工作"]
["","有連續性或緊急性者，雇主得在工作時間內，另行調配其休息時間。"]
["","第 36 條"]
["第 36 條","勞工每七日中應有二日之休息，其中一日為例假，一日為休息日。"]
["","雇主有下列情形之一，不受前項規定之限制："]
["","一、依第三十條第二項規定變更正常工作時間者，勞工每七日中至少應有"]
["","一日之例假，每二週內之例假及休息日至少應有四日。"]
["","二、依第三十條第三項規定變更正常工作時間者，勞工每七日中至少應有"]
["","一日之例假，每八週內之例假及休息日至少應有十六日。"]
["","三、依第三十條之一規定變更正常工作時間者，勞工每二週內至少應有二"]
["","日之例假，每四週內之例假及休息日至少應有八日。"]
["","雇主使勞工於休息日工作之時間，計入第三十二條第二項所定延長工作時"]
["","間總數。但因天災、事變或突發事件，雇主有使勞工於休息日工作之必要"]
["","者，其工作時數不受第三十二條第二項規定之限制。"]
["","經中央目的事業主管機關同意，且經中央主管機關指定之行業，雇主得將"]
["","第一項、第二項第一款及第二款所定之例假，於每七日之週期內調整之。"]
[null,"前項所定例假之調整，應經工會同意，如事業單位無工會者，經勞資會議"]
["","同意後，始得為之。雇主僱用勞工人數在三十人以上者，應報當地主管機"]
["","關備查。"]
["","第 37 條"]
["第 37 條","內政部所定應放假之紀念日、節日、勞動節及其他中央主管機關指定應放"]
["","假日，均應休假。"]
["","中華民國一百零五年十二月六日修正之前項規定，自一百零六年一月一日"]
["","施行。"]
["","勞基法第 38 條"]
["","勞工在同一雇主或事業單位，繼續工作滿一定期間者，應依下列規定給予"]
[null,"特別休假："]
[null,"一、六個月以上一年未滿者，三日。"]
[null,"二、一年以上二年未滿者，七日。"]
[null,"三、二年以上三年未滿者，十日。"]
[null,"四、三年以上五年未滿者，每年十四日。"]
[null,"五、五年以上十年未滿者，每年十五日。"]
[null,"六、十年以上者，每一年加給一日，加至三十日為止。"]
[null,"前項之特別休假期日，由勞工排定之。但雇主基於企業經營上之急迫需求"]
[null,"或勞工因個人因素，得與他方協商調整。"]
[null,"雇主應於勞工符合第一項所定之特別休假條件時，告知勞工依前二項規定"]
[null,"排定特別休假。"]
[null,"勞工之特別休假，因年度終結或契約終止而未休之日數，雇主應發給工資"]
[null,"。但年度終結未休之日數，經勞雇雙方協商遞延至次一年度實施者，於次"]
[null,"一年度終結或契約終止仍未休之日數，雇主應發給工資。"]
[null,"雇主應將勞工每年特別休假之期日及未休之日數所發給之工資數額，記載"]
[null,"於第二十三條所定之勞工工資清冊，並每年定期將其內容以書面通知勞工"]
[{"$f":"IF(LEFT(#REF!,1)=\"第\",#REF!,\"\")","v":{"$error":"#REF!"}},"勞工依本條主張權利時，雇主如認為其權利不存在，應負舉證責任。"]
[{"$f":"IF(LEFT(B342,1)=\"第\",B342,\"\")","v":""},"第 39 條"]
["第 39 條","第三十六條所定之例假、休息日、第三十七條所定之休假及第三十八條所"]
[null,"定之特別休假，工資應由雇主照給。雇主經徵得勞工同意於休假日工作者"]
["","，工資應加倍發給。因季節性關係有趕工必要，經勞工或工會同意照常工"]
["","作者，亦同。"]
["","第 40 條"]
["第 40 條","因天災、事變或突發事件，雇主認有繼續工作之必要時，得停止第三十六"]
["","條至第三十八條所定勞工之假期。但停止假期之工資，應加倍發給，並應"]
["","於事後補假休息。"]
["","前項停止勞工假期，應於事後二十四小時內，詳述理由，報請當地主管機"]
["","關核備。"]
["","第 41 條"]
["第 41 條","公用事業之勞工，當地主管機關認有必要時，得停止第三十八條所定之特"]
["","別休假。假期內之工資應由雇主加倍發給。"]
["","第 42 條"]
["第 42 條","勞工因健康或其他正當理由，不能接受正常工作時間以外之工作者，雇主"]
["","不得強制其工作。"]
["","第 43 條"]
["第 43 條","勞工因婚、喪、疾病或其他正當事由得請假；請假應給之假期及事假以外"]
["","期間內工資給付之最低標準，由中央主管機關定之。"]
["","第 五 章 童工、女工"]
[null,"第 44 條"]
["第 44 條","十五歲以上未滿十六歲之受僱從事工作者，為童工。"]
["","童工及十六歲以上未滿十八歲之人，不得從事危險性或有害性之工作。"]
["","第 45 條"]
["第 45 條","雇主不得僱用未滿十五歲之人從事工作。但國民中學畢業或經主管機關認"]
["","定其工作性質及環境無礙其身心健康而許可者，不在此限。"]
["","前項受僱之人，準用童工保護之規定。"]
["","第一項工作性質及環境無礙其身心健康之認定基準、審查程序及其他應遵"]
[null,"行事項之辦法，由中央主管機關依勞工年齡、工作性質及受國民義務教育"]
["","之時間等因素定之。"]
["","未滿十五歲之人透過他人取得工作為第三人提供勞務，或直接為他人提供"]
["","勞務取得報酬未具勞僱關係者，準用前項及童工保護之規定。"]
["","第 46 條"]
["第 46 條","未滿十八歲之人受僱從事工作者，雇主應置備其法定代理人同意書及其年"]
["","齡證明文件。"]
["","第 47 條"]
["第 47 條","童工每日之工作時間不得超過八小時，每週之工作時間不得超過四十小時"]
["","，例假日不得工作。"]
["","第 48 條"]
["第 48 條","童工不得於午後八時至翌晨六時之時間內工作。"]
["","第 49 條"]
["第 49 條","雇主不得使女工於午後十時至翌晨六時之時間內工作。但雇主經工會同意"]
["","，如事業單位無工會者，經勞資會議同意後，且符合下列各款規定者，不"]
["","在此限："]
["","一、提供必要之安全衛生設施。"]
["","二、無大眾運輸工具可資運用時，提供交通工具或安排女工宿舍。"]
[{"$f":"IF(LEFT(B389,1)=\"第\",B389,\"\")","v":""},"前項第一款所稱必要之安全衛生設施，其標準由中央主管機關定之。但雇"]
["","主與勞工約定之安全衛生設施優於本法者，從其約定。"]
["","女工因健康或其他正當理由，不能於午後十時至翌晨六時之時間內工作者"]
["","，雇主不得強制其工作。"]
["","第一項規定，於因天災、事變或突發事件，雇主必須使女工於午後十時至"]
[null,"翌晨六時之時間內工作時，不適用之。"]
[null,"第一項但書及前項規定，於妊娠或哺乳期間之女工，不適用之。"]
[null,"第 50 條"]
["第 50 條","女工分娩前後，應停止工作，給予產假八星期；妊娠三個月以上流產者，"]
["","應停止工作，給予產假四星期。"]
["","前項女工受僱工作在六個月以上者，停止工作期間工資照給；未滿六個月"]
["","者減半發給。"]
["","第 51 條"]
["第 51 條","女工在妊娠期間，如有較為輕易之工作，得申請改調，雇主不得拒絕，並"]
["","不得減少其工資。"]
["","第 52 條"]
["第 52 條","子女未滿一歲須女工親自哺乳者，於第三十五條規定之休息時間外，雇主"]
["","應每日另給哺乳時間二次，每次以三十分鐘為度。"]
["","前項哺乳時間，視為工作時間。"]
["","第 六 章 退休"]
[null,"第 53 條"]
["第 53 條","勞工有下列情形之一，得自請退休："]
["","一、工作十五年以上年滿五十五歲者。"]
["","二、工作二十五年以上者。"]
["","三、工作十年以上年滿六十歲者。"]
["","第 54 條"]
["第 54 條","勞工非有下列情形之一，雇主不得強制其退休："]
["","一、年滿六十五歲者。"]
["","二、身心障礙不堪勝任工作者。"]
["","前項第一款所規定之年齡，對於擔任具有危險、堅強體力等特殊性質之工"]
["","作者，得由事業單位報請中央主管機關予以調整。但不得少於五十五歲。"]
["","第 55 條"]
["第 55 條","勞工退休金之給與標準如下："]
["","一、按其工作年資，每滿一年給與兩個基數。但超過十五年之工作年資，"]
["","每滿一年給與一個基數，最高總數以四十五個基數為限。未滿半年者"]
["","以半年計；滿半年者以一年計。"]
["","二、依第五十四條第一項第二款規定，強制退休之勞工，其身心障礙係因"]
["","執行職務所致者，依前款規定加給百分之二十。"]
["","前項第一款退休金基數之標準，係指核准退休時一個月平均工資。"]
["","第一項所定退休金，雇主應於勞工退休之日起三十日內給付，如無法一次"]
[null,"發給時，得報經主管機關核定後，分期給付。本法施行前，事業單位原定"]
["","退休標準優於本法者，從其規定。"]
["","第 56 條"]
["第 56 條","雇主應依勞工每月薪資總額百分之二至百分之十五範圍內，按月提撥勞工"]
["","退休準備金，專戶存儲，並不得作為讓與、扣押、抵銷或擔保之標的；其"]
["","提撥之比率、程序及管理等事項之辦法，由中央主管機關擬訂，報請行政"]
["","院核定之。"]
["","雇主應於每年年度終了前，估算前項勞工退休準備金專戶餘額，該餘額不"]
["","足給付次一年度內預估成就第五十三條或第五十四條第一項第一款退休條"]
["","件之勞工，依前條計算之退休金數額者，雇主應於次年度三月底前一次提"]
["","撥其差額，並送事業單位勞工退休準備金監督委員會審議。"]
["","第一項雇主按月提撥之勞工退休準備金匯集為勞工退休基金，由中央主管"]
[null,"機關設勞工退休基金監理委員會管理之；其組織、會議及其他相關事項，"]
["","由中央主管機關定之。"]
["","前項基金之收支、保管及運用，由中央主管機關會同財政部委託金融機構"]
["","辦理。最低收益不得低於當地銀行二年定期存款利率之收益；如有虧損，"]
["","由國庫補足之。基金之收支、保管及運用辦法，由中央主管機關擬訂，報"]
["","請行政院核定之。"]
["","雇主所提撥勞工退休準備金，應由勞工與雇主共同組織勞工退休準備金監"]
["","督委員會監督之。委員會中勞工代表人數不得少於三分之二；其組織準則"]
["","，由中央主管機關定之。"]
["","雇主按月提撥之勞工退休準備金比率之擬訂或調整，應經事業單位勞工退"]
["","休準備金監督委員會審議通過，並報請當地主管機關核定。"]
["","金融機構辦理核貸業務，需查核該事業單位勞工退休準備金提撥狀況之必"]
[{"$f":"IF(LEFT(B453,1)=\"第\",B453,\"\")","v":""},"要資料時，得請當地主管機關提供。"]
["","金融機構依前項取得之資料，應負保密義務，並確實辦理資料安全稽核作"]
["","業。"]
["","前二項有關勞工退休準備金必要資料之內容、範圍、申請程序及其他應遵"]
["","行事項之辦法，由中央主管機關會商金融監督管理委員會定之。"]
["","第 57 條"]
["第 57 條","勞工工作年資以服務同一事業者為限。但受同一雇主調動之工作年資，及"]
["","依第二十條規定應由新雇主繼續予以承認之年資，應予併計。"]
["","第 58 條"]
["第 58 條","勞工請領退休金之權利，自退休之次月起，因五年間不行使而消滅。"]
["","勞工請領退休金之權利，不得讓與、抵銷、扣押或供擔保。"]
["","勞工依本法規定請領勞工退休金者，得檢具證明文件，於金融機構開立專"]
["","戶，專供存入勞工退休金之用。"]
["","前項專戶內之存款，不得作為抵銷、扣押、供擔保或強制執行之標的。"]
["","第 七 章 職業災害補償"]
[null,"第 59 條"]
["第 59 條","勞工因遭遇職業災害而致死亡、失能、傷害或疾病時，雇主應依下列規定"]
["","予以補償。但如同一事故，依勞工保險條例或其他法令規定，已由雇主支"]
["","付費用補償者，雇主得予以抵充之："]
["","一、勞工受傷或罹患職業病時，雇主應補償其必需之醫療費用。職業病之"]
["","種類及其醫療範圍，依勞工保險條例有關之規定。"]
["","二、勞工在醫療中不能工作時，雇主應按其原領工資數額予以補償。但醫"]
["","療期間屆滿二年仍未能痊癒，經指定之醫院診斷，審定為喪失原有工"]
["","作能力，且不合第三款之失能給付標準者，雇主得一次給付四十個月"]
["","之平均工資後，免除此項工資補償責任。"]
["","三、勞工經治療終止後，經指定之醫院診斷，審定其遺存障害者，雇主應"]
["","按其平均工資及其失能程度，一次給予失能補償。失能補償標準，依"]
["","勞工保險條例有關之規定。"]
["","四、勞工遭遇職業傷害或罹患職業病而死亡時，雇主除給與五個月平均工"]
["","資之喪葬費外，並應一次給與其遺屬四十個月平均工資之死亡補償。"]
["","其遺屬受領死亡補償之順位如下："]
["","（一）配偶及子女。"]
["","（二）父母。"]
["","（三）祖父母。"]
["","（四）孫子女。"]
["","（五）兄弟姐妹。"]
["","第 60 條"]
["第 60 條","雇主依前條規定給付之補償金額，得抵充就同一事故所生損害之賠償金額"]
["","。"]
["","第 61 條"]
["第 61 條","第五十九條之受領補償權，自得受領之日起，因二年間不行使而消滅。"]
[null,"受領補償之權利，不因勞工之離職而受影響，且不得讓與、抵銷、扣押或"]
["","供擔保。"]
["","勞工或其遺屬依本法規定受領職業災害補償金者，得檢具證明文件，於金"]
["","融機構開立專戶，專供存入職業災害補償金之用。"]
["","前項專戶內之存款，不得作為抵銷、扣押、供擔保或強制執行之標的。"]
["","第 62 條"]
["第 62 條","事業單位以其事業招人承攬，如有再承攬時，承攬人或中間承攬人，就各"]
["","該承攬部分所使用之勞工，均應與最後承攬人，連帶負本章所定雇主應負"]
["","職業災害補償之責任。"]
["","事業單位或承攬人或中間承攬人，為前項之災害補償時，就其所補償之部"]
["","分，得向最後承攬人求償。"]
["","第 63 條"]
["第 63 條","承攬人或再承攬人工作場所，在原事業單位工作場所範圍內，或為原事業"]
["","單位提供者，原事業單位應督促承攬人或再承攬人，對其所僱用勞工之勞"]
["","動條件應符合有關法令之規定。"]
["","事業單位違背勞工安全衛生法有關對於承攬人、再承攬人應負責任之規定"]
["","，致承攬人或再承攬人所僱用之勞工發生職業災害時，應與該承攬人、再"]
["","承攬人負連帶補償責任。"]
["","第 八 章 技術生"]
[null,"第 64 條"]
["第 64 條","雇主不得招收未滿十五歲之人為技術生。但國民中學畢業者，不在此限。"]
["","稱技術生者，指依中央主管機關規定之技術生訓練職類中以學習技能為目"]
["","的，依本章之規定而接受雇主訓練之人。"]
[{"$f":"IF(LEFT(B517,1)=\"第\",B517,\"\")","v":""},"本章規定，於事業單位之養成工、見習生、建教合作班之學生及其他與技"]
["","術生性質相類之人，準用之。"]
["","第 65 條"]
["第 65 條","雇主招收技術生時，須與技術生簽訂書面訓練契約一式三份，訂明訓練項"]
["","目、訓練期限、膳宿負擔、生活津貼、相關教學、勞工保險、結業證明、"]
["","契約生效與解除之條件及其他有關雙方權利、義務事項，由當事人分執，"]
["","並送主管機關備案。"]
["","前項技術生如為未成年人，其訓練契約，應得法定代理人之允許。"]
["","第 66 條"]
["第 66 條","雇主不得向技術生收取有關訓練費用。"]
["","第 67 條"]
["第 67 條","技術生訓練期滿，雇主得留用之，並應與同等工作之勞工享受同等之待遇"]
["","。雇主如於技術生訓練契約內訂明留用期間，應不得超過其訓練期間。"]
["","第 68 條"]
["第 68 條","技術生人數，不得超過勞工人數四分之一。勞工人數不滿四人者，以四人"]
["","計。"]
["","第 69 條"]
["第 69 條","本法第四章工作時間、休息、休假，第五章童工、女工，第七章災害補償"]
["","及其他勞工保險等有關規定，於技術生準用之。"]
["","技術生災害補償所採薪資計算之標準，不得低於基本工資。"]
["","第 九 章 工作規則"]
[null,"第 70 條"]
["第 70 條","雇主僱用勞工人數在三十人以上者，應依其事業性質，就左列事項訂立工"]
["","作規則，報請主管機關核備後並公開揭示之："]
["","一、工作時間、休息、休假、國定紀念日、特別休假及繼續性工作之輪班"]
["","方法。"]
["","二、工資之標準、計算方法及發放日期。"]
["","三、延長工作時間。"]
["","四、津貼及獎金。"]
["","五、應遵守之紀律。"]
["","六、考勤、請假、獎懲及升遷。"]
["","七、受僱、解僱、資遣、離職及退休。"]
["","八、災害傷病補償及撫卹。"]
["","九、福利措施。"]
["","十、勞雇雙方應遵守勞工安全衛生規定。"]
["","十一、勞雇雙方溝通意見加強合作之方法。"]
["","十二、其他。"]
["","第 71 條"]
["第 71 條","工作規則，違反法令之強制或禁止規定或其他有關該事業適用之團體協約"]
["","規定者，無效。"]
["","第 十 章 監督與檢查"]
[null,"第 72 條"]
["第 72 條","中央主管機關，為貫徹本法及其他勞工法令之執行，設勞工檢查機構或授"]
["","權直轄市主管機關專設檢查機構辦理之；直轄市、縣（市）主管機關於必"]
["","要時，亦得派員實施檢查。"]
["","前項勞工檢查機構之組織，由中央主管機關定之。"]
["","第 73 條"]
["第 73 條","檢查員執行職務，應出示檢查證，各事業單位不得拒絕。事業單位拒絕檢"]
["","查時，檢查員得會同當地主管機關或警察機關強制檢查之。"]
["","檢查員執行職務，得就本法規定事項，要求事業單位提出必要之報告、紀"]
["","錄、帳冊及有關文件或書面說明。如需抽取物料、樣品或資料時，應事先"]
["","通知雇主或其代理人並掣給收據。"]
["","第 74 條"]
["第 74 條","勞工發現事業單位違反本法及其他勞工法令規定時，得向雇主、主管機關"]
["","或檢查機構申訴。"]
["","雇主不得因勞工為前項申訴，而予以解僱、降調、減薪、損害其依法令、"]
["","契約或習慣上所應享有之權益，或其他不利之處分。"]
["","雇主為前項行為之一者，無效。"]
["","主管機關或檢查機構於接獲第一項申訴後，應為必要之調查，並於六十日"]
["","內將處理情形，以書面通知勞工。"]
["","主管機關或檢查機構應對申訴人身分資料嚴守秘密，不得洩漏足以識別其"]
["","身分之資訊。"]
["","違反前項規定者，除公務員應依法追究刑事與行政責任外，對因此受有損"]
["","害之勞工，應負損害賠償責任。"]
[{"$f":"IF(LEFT(B581,1)=\"第\",B581,\"\")","v":""},"主管機關受理檢舉案件之保密及其他應遵行事項之辦法，由中央主管機關"]
["","定之。"]
["","第 十一 章 罰則"]
[null,"第 75 條"]
["第 75 條","違反第五條規定者，處五年以下有期徒刑、拘役或科或併科新臺幣七十五"]
["","萬元以下罰金。"]
["","第 76 條"]
["第 76 條","違反第六條規定者，處三年以下有期徒刑、拘役或科或併科新臺幣四十五"]
["","萬元以下罰金。"]
["","第 77 條"]
["第 77 條","違反第四十二條、第四十四條第二項、第四十五條第一項、第四十七條、"]
["","第四十八條、第四十九條第三項或第六十四條第一項規定者，處六個月以"]
[null,"下有期徒刑、拘役或科或併科新臺幣三十萬元以下罰金。"]
["","第 78 條"]
["第 78 條","未依第十七條、第五十五條規定之標準或期限給付者，處新臺幣三十萬元"]
["","以上一百五十萬元以下罰鍰，並限期令其給付，屆期未給付者，應按次處"]
["","罰。"]
["","違反第十三條、第二十六條、第五十條、第五十一條或第五十六條第二項"]
["","規定者，處新臺幣九萬元以上四十五萬元以下罰鍰。"]
["","第 79 條"]
["第 79 條","有下列各款規定行為之一者，處新臺幣二萬元以上一百萬元以下罰鍰："]
["","一、違反第二十一條第一項、第二十二條至第二十五條、第三十條第一項"]
["","至第三項、第六項、第七項、第三十二條、第三十四條至第四十一條"]
["","、第四十九條第一項或第五十九條規定。"]
["","二、違反主管機關依第二十七條限期給付工資或第三十三條調整工作時間"]
["","之命令。"]
["","三、違反中央主管機關依第四十三條所定假期或事假以外期間內工資給付"]
["","之最低標準。"]
["","違反第三十條第五項或第四十九條第五項規定者，處新臺幣九萬元以上四"]
["","十五萬元以下罰鍰。"]
["","違反第七條、第九條第一項、第十六條、第十九條、第二十八條第二項、"]
["","第四十六條、第五十六條第一項、第六十五條第一項、第六十六條至第六"]
[null,"十八條、第七十條或第七十四條第二項規定者，處新臺幣二萬元以上三十"]
["","萬元以下罰鍰。"]
["","有前三項規定行為之一者，主管機關得依事業規模、違反人數或違反情節"]
["","，加重其罰鍰至法定罰鍰最高額二分之一。"]
["","第 79-1 條"]
["第 79-1 條","違反第四十五條第二項、第四項、第六十四條第三項及第六十九條第一項"]
["","準用規定之處罰，適用本法罰則章規定。"]
["","第 80 條"]
["第 80 條","拒絕、規避或阻撓勞工檢查員依法執行職務者，處新臺幣三萬元以上十五"]
["","萬元以下罰鍰。"]
["","第 80-1 條"]
["第 80-1 條","違反本法經主管機關處以罰鍰者，主管機關應公布其事業單位或事業主之"]
["","名稱、負責人姓名，並限期令其改善；屆期未改善者，應按次處罰。"]
["","主管機關裁處罰鍰，得審酌與違反行為有關之勞工人數、累計違法次數或"]
["","未依法給付之金額，為量罰輕重之標準。"]
["","第 81 條"]
["第 81 條","法人之代表人、法人或自然人之代理人、受僱人或其他從業人員，因執行"]
["","業務違反本法規定，除依本章規定處罰行為人外，對該法人或自然人並應"]
["","處以各該條所定之罰金或罰鍰。但法人之代表人或自然人對於違反之發生"]
["","，已盡力為防止行為者，不在此限。"]
["","法人之代表人或自然人教唆或縱容為違反之行為者，以行為人論。"]
["","第 82 條"]
["第 82 條","本法所定之罰鍰，經主管機關催繳，仍不繳納時，得移送法院強制執行。"]
["","第 十二 章 附則"]
[null,"第 83 條"]
["第 83 條","為協調勞資關係，促進勞資合作，提高工作效率，事業單位應舉辦勞資會"]
["","議。其辦法由中央主管機關會同經濟部訂定，並報行政院核定。"]
["","第 84 條"]
["第 84 條","公務員兼具勞工身分者，其有關任（派）免、薪資、獎懲、退休、撫卹及"]
["","保險（含職業災害）等事項，應適用公務員法令之規定。但其他所定勞動"]
["","條件優於本法規定者，從其規定。"]
["","第 84-1 條"]
[{"$f":"IF(LEFT(B645,1)=\"第\",B645,\"\")","v":"第 84-1 條"},"經中央主管機關核定公告之下列工作者，得由勞雇雙方另行約定，工作時"]
["","間、例假、休假、女性夜間工作，並報請當地主管機關核備，不受第三十"]
["","條、第三十二條、第三十六條、第三十七條、第四十九條規定之限制。"]
["","一、監督、管理人員或責任制專業人員。"]
["","二、監視性或間歇性之工作。"]
["","三、其他性質特殊之工作。"]
["","前項約定應以書面為之，並應參考本法所定之基準且不得損及勞工之健康"]
["","及福祉。"]
["","第 84-2 條"]
["第 84-2 條","勞工工作年資自受僱之日起算，適用本法前之工作年資，其資遣費及退休"]
["","金給與標準，依其當時應適用之法令規定計算；當時無法令可資適用者，"]
["","依各該事業單位自訂之規定或勞雇雙方之協商計算之。適用本法後之工作"]
["","年資，其資遣費及退休金給與標準，依第十七條及第五十五條規定計算。"]
["","第 85 條"]
["第 85 條","本法施行細則，由中央主管機關擬定，報請行政院核定。"]
["","第 86 條"]
["第 86 條","本法自公布日施行。"]
["","本法中華民國八十九年六月二十八日修正公布之第三十條第一項及第二項"]
["","，自九十年一月一日施行；一百零四年二月四日修正公布之第二十八條第"]
["","一項，自公布後八個月施行；一百零四年六月三日修正公布之條文，自一"]
["","百零五年一月一日施行；一百零五年十二月二十一日修正公布之第三十四"]
["","條第二項施行日期，由行政院定之、第三十七條及第三十八條，自一百零"]
["","六年一月一日施行。"]
["","本法中華民國一百零七年一月十日修正之條文，自一百零七年三月一日施"]
["","行。"]

{"sheet":"勞基法施行細則1080214","index":2,"n_rows":358,"n_cols":2,"rows_kept":358,"merged":[[161,0,170,0],[172,0,180,0],[192,0,202,0],[204,0,217,0]]}
[null,"法規名稱：勞動基準法施行細則 英"]
[null,"修正日期：民國 108 年 02 月 14 日"]
[null,"法規類別：行政 ＞ 勞動部 ＞ 勞動條件及就業平等目"]
[]
[null,"第 一 章 總則"]
[null,"第 1 條"]
["第 1 條","本細則依勞動基準法(以下簡稱本法)第八十五條規定訂定之。"]
["","第 2 條"]
["第 2 條","依本法第二條第四款計算平均工資時，下列各款期日或期間均不計入："]
["","一、發生計算事由之當日。"]
["","二、因職業災害尚在醫療中者。"]
["","三、依本法第五十條第二項減半發給工資者。"]
["","四、雇主因天災、事變或其他不可抗力而不能繼續其事業，致勞工未能工"]
["","作者。"]
["","五、依勞工請假規則請普通傷病假者。"]
["","六、依性別工作平等法請生理假、產假、家庭照顧假或安胎休養，致減少"]
["","工資者。"]
["","七、留職停薪者。"]
["","第 3 條"]
["第 3 條","本法第三條第一項第一款至第七款所列各業，適用中華民國行業標準分類"]
["","之規定。"]
["","第 4 條"]
["第 4 條","本法第三條第一項第八款所稱中央主管機關指定之事業及第三項所稱適用"]
["","本法確有窒礙難行者，係指中央主管機關依中華民國行業標準分類之規定"]
["","指定者，並得僅指定各行業中之一部分。"]
["","第 4-1 條"]
["第 4-1 條","（刪除）"]
["","第 5 條"]
["第 5 條","勞工工作年資以服務同一事業單位為限，並自受僱當日起算。"]
["","適用本法前已在同一事業單位工作之年資合併計算。"]
["","第 二 章 勞動契約"]
[null,"第 6 條"]
["第 6 條","本法第九條第一項所稱臨時性、短期性、季節性及特定性工作，依左列規"]
["","定認定之："]
["","一、臨時性工作：係指無法預期之非繼續性工作，其工作期間在六個月以"]
["","內者。"]
["","二、短期性工作：係指可預期於六個月內完成之非繼續性工作。"]
["","三、季節性工作：係指受季節性原料、材料來源或市場銷售影響之非繼續"]
["","性工作，其工作期間在九個月以內者。"]
["","四、特定性工作：係指可在特定期間完成之非繼續性工作。其工作期間超"]
["","過一年者，應報請主管機關核備。"]
["","第 7 條"]
["第 7 條","勞動契約應依本法有關規定約定下列事項："]
["","一、工作場所及應從事之工作。"]
["","二、工作開始與終止之時間、休息時間、休假、例假、休息日、請假及輪"]
["","班制之換班。"]
["","三、工資之議定、調整、計算、結算與給付之日期及方法。"]
["","四、勞動契約之訂定、終止及退休。"]
["","五、資遣費、退休金、其他津貼及獎金。"]
["","六、勞工應負擔之膳宿費及工作用具費。"]
["","七、安全衛生。"]
["","八、勞工教育及訓練。"]
["","九、福利。"]
["","十、災害補償及一般傷病補助。"]
["","十一、應遵守之紀律。"]
["","十二、獎懲。"]
["","十三、其他勞資權利義務有關事項。"]
["","第 7-1 條"]
["第 7-1 條","離職後競業禁止之約定，應以書面為之，且應詳細記載本法第九條之一第"]
["","一項第三款及第四款規定之內容，並由雇主與勞工簽章，各執一份。"]
["","第 7-2 條"]
["第 7-2 條","本法第九條之一第一項第三款所為之約定未逾合理範疇，應符合下列規定"]
["","："]
["","一、競業禁止之期間，不得逾越雇主欲保護之營業秘密或技術資訊之生命"]
["","週期，且最長不得逾二年。"]
["","二、競業禁止之區域，應以原雇主實際營業活動之範圍為限。"]
["","三、競業禁止之職業活動範圍，應具體明確，且與勞工原職業活動範圍相"]
["","同或類似。"]
["","四、競業禁止之就業對象，應具體明確，並以與原雇主之營業活動相同或"]
["","類似，且有競爭關係者為限。"]
["","第 7-3 條"]
["第 7-3 條","本法第九條之一第一項第四款所定之合理補償，應就下列事項綜合考量："]
["","一、每月補償金額不低於勞工離職時一個月平均工資百分之五十。"]
["","二、補償金額足以維持勞工離職後競業禁止期間之生活所需。"]
["","三、補償金額與勞工遵守競業禁止之期間、區域、職業活動範圍及就業對"]
["","象之範疇所受損失相當。"]
["","四、其他與判斷補償基準合理性有關之事項。"]
["","前項合理補償，應約定離職後一次預為給付或按月給付。"]
["","第 8 條"]
["第 8 條","（刪除）"]
["","第 9 條"]
["第 9 條","依本法終止勞動契約時，雇主應即結清工資給付勞工。"]
["","第 三 章 工資"]
[null,"第 10 條"]
["第 10 條","本法第二條第三款所稱之其他任何名義之經常性給與係指左列各款以外之"]
["","給與。"]
["","一、紅利。"]
["","二、獎金：指年終獎金、競賽獎金、研究發明獎金、特殊功績獎金、久任"]
["","獎金、節約燃料物料獎金及其他非經常性獎金。"]
["","三、春節、端午節、中秋節給與之節金。"]
["","四、醫療補助費、勞工及其子女教育補助費。"]
["","五、勞工直接受自顧客之服務費。"]
["","六、婚喪喜慶由雇主致送之賀禮、慰問金或奠儀等。"]
["","七、職業災害補償費。"]
["","八、勞工保險及雇主以勞工為被保險人加入商業保險支付之保險費。"]
["","九、差旅費、差旅津貼及交際費。"]
["","十、工作服、作業用品及其代金。"]
["","十一、其他經中央主管機關會同中央目的事業主管機關指定者。"]
["","第 11 條"]
["第 11 條","本法第二十一條所稱基本工資，指勞工在正常工作時間內所得之報酬。不"]
["","包括延長工作時間之工資與休息日、休假日及例假工作加給之工資。"]
["","第 12 條"]
["第 12 條","採計件工資之勞工所得基本工資，以每日工作八小時之生產額或工作量換"]
["","算之。"]
["","第 13 條"]
["第 13 條","勞工工作時間每日少於八小時者，除工作規則、勞動契約另有約定或另有"]
["","法令規定者外，其基本工資得按工作時間比例計算之。"]
["","第 14 條"]
["第 14 條","（刪除）"]
["","第 14-1 條"]
["第 14-1 條","本法第二十三條所定工資各項目計算方式明細，應包括下列事項："]
["","一、勞雇雙方議定之工資總額。"]
["","二、工資各項目之給付金額。"]
["","三、依法令規定或勞雇雙方約定，得扣除項目之金額。"]
["","四、實際發給之金額。"]
["","雇主提供之前項明細，得以紙本、電子資料傳輸方式或其他勞工可隨時取"]
["","得及得列印之資料為之。"]
["","第 15 條"]
["第 15 條","本法第二十八條第一項第一款所定積欠之工資，以雇主於歇業、清算或宣"]
["","告破產前六個月內所積欠者為限。"]
["","第 16 條"]
["第 16 條","勞工死亡時，雇主應即結清其工資給付其遺屬。"]
["","前項受領工資之順位準用本法第五十九條第四款之規定。"]
["","第 四 章 工作時間、休息、休假"]
[null,"第 17 條"]
["第 17 條","本法第三十條所稱正常工作時間跨越二曆日者，其工作時間應合併計算。"]
["","第 18 條"]
["第 18 條","勞工因出差或其他原因於事業場所外從事工作致不易計算工作時間者，以"]
["","平時之工作時間為其工作時間。但其實際工作時間經證明者，不在此限。"]
["","第 19 條"]
["第 19 條","勞工於同一事業單位或同一雇主所屬不同事業場所工作時，應將在各該場"]
["","所之工作時間合併計算，並加計往來於事業場所間所必要之交通時間。"]
["","第 20 條"]
["第 20 條","雇主有下列情形之一者，應即公告周知："]
["","一、依本法第三十條第二項、第三項或第三十條之一第一項第一款規定變"]
["","更勞工正常工作時間。"]
["","二、依本法第三十條之一第一項第二款或第三十二條第一項、第二項、第"]
["","四項規定延長勞工工作時間。"]
["","三、依本法第三十四條第二項但書規定變更勞工更換班次時之休息時間。"]
["","四、依本法第三十六條第二項或第四項規定調整勞工例假或休息日。"]
["","第 20-1 條"]
["第 20-1 條","本法所定雇主延長勞工工作之時間如下："]
["","一、每日工作時間超過八小時或每週工作總時數超過四十小時之部分。但"]
["","依本法第三十條第二項、第三項或第三十條之一第一項第一款變更工"]
["","作時間者，為超過變更後工作時間之部分。"]
["","二、勞工於本法第三十六條所定休息日工作之時間。"]
["","第 21 條"]
["第 21 條","本法第三十條第五項所定出勤紀錄，包括以簽到簿、出勤卡、刷卡機、門"]
["","禁卡、生物特徵辨識系統、電腦出勤紀錄系統或其他可資覈實記載出勤時"]
["","間工具所為之紀錄。"]
["","前項出勤紀錄，雇主因勞動檢查之需要或勞工向其申請時，應以書面方式"]
["","提出。"]
["","第 22 條"]
["第 22 條","本法第三十二條第二項但書所定每三個月，以每連續三個月為一週期，依"]
["","曆計算，以勞雇雙方約定之起迄日期認定之。"]
["","本法第三十二條第五項但書所定坑內監視為主之工作範圍如下："]
["","一、從事排水機之監視工作。"]
["","二、從事壓風機或冷卻設備之監視工作。"]
["","三、從事安全警報裝置之監視工作。"]
["","四、從事生產或營建施工之紀錄及監視工作。"]
["","第 22-1 條"]
["第 22-1 條","本法第三十二條第三項、第三十四條第三項及第三十六條第五項所定雇主"]
[null,"僱用勞工人數，以同一雇主僱用適用本法之勞工人數計算，包括分支機構"]
[null,"之僱用人數。"]
[null,"本法第三十二條第三項、第三十四條第三項及第三十六條第五項所定當地"]
[null,"主管機關，為雇主之主事務所、主營業所或公務所所在地之直轄市政府或"]
[null,"縣（市）政府。"]
[null,"本法第三十二條第三項、第三十四條第三項及第三十六條第五項所定應報"]
[null,"備查，雇主至遲應於開始實施延長工作時間、變更休息時間或調整例假之"]
[null,"前一日為之。但因天災、事變或突發事件不及報備查者，應於原因消滅後"]
[null,"二十四小時內敘明理由為之。"]
["","第 22-2 條"]
["第 22-2 條","本法第三十二條之一所定補休，應依勞工延長工作時間或休息日工作事實"]
[null,"發生時間先後順序補休。補休之期限逾依第二十四條第二項所約定年度之"]
[null,"末日者，以該日為期限之末日。"]
[null,"前項補休期限屆期或契約終止時，發給工資之期限如下："]
[null,"一、補休期限屆期：於契約約定之工資給付日發給或於補休期限屆期後三"]
[null,"十日內發給。"]
[null,"二、契約終止：依第九條規定發給。"]
[null,"勞工依本法第三十二條之一主張權利時，雇主如認為其權利不存在，應負"]
[null,"舉證責任。"]
["","第 22-3 條"]
["第 22-3 條","本法第三十六條第一項、第二項第一款及第二款所定之例假，以每七日為"]
["","一週期，依曆計算。雇主除依同條第四項及第五項規定調整者外，不得使"]
["","勞工連續工作逾六日。"]
["","第 23 條"]
["第 23 條","（刪除）"]
["","第 23-1 條"]
["第 23-1 條","本法第三十七條所定休假遇本法第三十六條所定例假及休息日者，應予補"]
["","假。但不包括本法第三十七條指定應放假之日。"]
["","前項補假期日，由勞雇雙方協商排定之。"]
["","勞基法施行細則第 24 條"]
["第 24 條","勞工於符合本法第三十八條第一項所定之特別休假條件時，取得特別休假"]
[null,"之權利；其計算特別休假之工作年資，應依第五條之規定。"]
[null,"依本法第三十八條第一項規定給予之特別休假日數，勞工得於勞雇雙方協"]
[null,"商之下列期間內，行使特別休假權利："]
[null,"一、以勞工受僱當日起算，每一週年之期間。但其工作六個月以上一年未"]
[null,"滿者，為取得特別休假權利後六個月之期間。"]
[null,"二、每年一月一日至十二月三十一日之期間。"]
[null,"三、教育單位之學年度、事業單位之會計年度或勞雇雙方約定年度之期間"]
[null,"。"]
[null,"雇主依本法第三十八條第三項規定告知勞工排定特別休假，應於勞工符合"]
[null,"特別休假條件之日起三十日內為之。"]
["","第 24-1 條"]
["第 24-1 條","本法第三十八條第四項所定年度終結，為前條第二項期間屆滿之日。"]
[null,"本法第三十八條第四項所定雇主應發給工資，依下列規定辦理："]
[null,"一、發給工資之基準："]
[null,"（一）按勞工未休畢之特別休假日數，乘以其一日工資計發。"]
[null,"（二）前目所定一日工資，為勞工之特別休假於年度終結或契約終止前一"]
[null,"日之正常工作時間所得之工資。其為計月者，為年度終結或契約終"]
[null,"止前最近一個月正常工作時間所得之工資除以三十所得之金額。"]
[null,"（三）勞雇雙方依本法第三十八條第四項但書規定協商遞延至次一年度實"]
[null,"施者，按原特別休假年度終結時應發給工資之基準計發。"]
[null,"二、發給工資之期限："]
[null,"（一）年度終結：於契約約定之工資給付日發給或於年度終結後三十日內發給。"]
[null,"（二）契約終止：依第九條規定發給。"]
[null,"勞雇雙方依本法第三十八條第四項但書規定協商遞延至次一年度實施者，"]
[null,"其遞延之日數，於次一年度請休特別休假時，優先扣除。"]
["","第 24-2 條"]
["第 24-2 條","本法第三十八條第五項所定每年定期發給之書面通知，依下列規定辦理："]
["","一、雇主應於前條第二項第二款所定發給工資之期限前發給。"]
["","二、書面通知，得以紙本、電子資料傳輸方式或其他勞工可隨時取得及得"]
["","列印之資料為之。"]
["","第 24-3 條"]
["第 24-3 條","本法第三十九條所定休假日，為本法第三十七條所定休假及第三十八條所"]
["","定特別休假。"]
["","第 五 章 童工、女工"]
[null,"第 25 條"]
["第 25 條","本法第四十四條第二項所定危險性或有害性之工作，依職業安全衛生有關"]
["","法令之規定。"]
["","第 26 條"]
["第 26 條","雇主對依本法第五十條第一項請產假之女工，得要求其提出證明文件。"]
["","第 六 章 退休"]
[null,"第 27 條"]
["第 27 條","本法第五十三條第一款、第五十四條第一項第一款及同條第二項但書規定"]
["","之年齡，應以戶籍記載為準。"]
["","第 28 條"]
["第 28 條","（刪除）"]
["","第 29 條"]
["第 29 條","本法第五十五條第三項所定雇主得報經主管機關核定分期給付勞工退休金"]
["","之情形如下："]
["","一、依法提撥之退休準備金不敷支付。"]
["","二、事業之經營或財務確有困難。"]
["","第 29-1 條"]
["第 29-1 條","本法第五十六條第二項規定之退休金數額，按本法第五十五條第一項之給"]
["","與標準，依下列規定估算："]
["","一、勞工人數：為估算當年度終了時適用本法或勞工退休金條例第十一條"]
["","第一項保留本法工作年資之在職勞工，且預估於次一年度內成就本法"]
[null,"第五十三條或第五十四條第一項第一款退休條件者。"]
["第五十三條或第五十四條第一項第一款退休條件者。","二、工作年資：自適用本法之日起算至估算當年度之次一年度終了或選擇"]
["","適用勞工退休金條例前一日止。"]
["","三、平均工資：為估算當年度終了之一個月平均工資。"]
["","前項數額以元為單位，角以下四捨五入。"]
["","第 七 章 職業災害補償"]
[null,"第 30 條"]
["第 30 條","雇主依本法第五十九條第二款補償勞工之工資，應於發給工資之日給與。"]
["","第 31 條"]
["第 31 條","本法第五十九條第二款所稱原領工資，係指該勞工遭遇職業災害前一日正"]
["","常工作時間所得之工資。其為計月者，以遭遇職業災害前最近一個月正常"]
["","工作時間所得之工資除以三十所得之金額，為其一日之工資。"]
["","罹患職業病者依前項規定計算所得金額低於平均工資者，以平均工資為準"]
["","。"]
["","第 32 條"]
["第 32 條","依本法第五十九條第二款但書規定給付之補償，雇主應於決定後十五日內"]
["","給與。在未給與前雇主仍應繼續為同款前段規定之補償。"]
["","第 33 條"]
["第 33 條","雇主依本法第五十九條第四款給與勞工之喪葬費應於死亡後三日內，死亡"]
["","補償應於死亡後十五日內給付。"]
["","第 34 條"]
["第 34 條","本法第五十九條所定同一事故，依勞工保險條例或其他法令規定，已由雇"]
["","主支付費用補償者，雇主得予以抵充之。但支付之費用如由勞工與雇主共"]
["","同負擔者，其補償之抵充按雇主負擔之比例計算。"]
["","第 34-1 條"]
["第 34-1 條","勞工因遭遇職業災害而致死亡或失能時，雇主已依勞工保險條例規定為其"]
["","投保，並經保險人核定為職業災害保險事故者，雇主依本法第五十九條規"]
["","定給予之補償，以勞工之平均工資與平均投保薪資之差額，依本法第五十"]
["","九條第三款及第四款規定標準計算之。"]
["","第 八 章 技術生"]
[null,"第 35 條"]
["第 35 條","雇主不得使技術生從事家事、雜役及其他非學習技能為目的之工作。但從"]
["","事事業場所內之清潔整頓，器具工具及機械之清理者不在此限。"]
["","第 36 條"]
["第 36 條","技術生之工作時間應包括學科時間。"]
["","第 九 章 工作規則"]
[null,"第 37 條"]
["第 37 條","雇主於僱用勞工人數滿三十人時應即訂立工作規則，並於三十日內報請當"]
["","地主管機關核備。"]
["","本法第七十條所定雇主僱用勞工人數，依第二十二條之一第一項規定計算"]
["","。"]
["","工作規則應依據法令、勞資協議或管理制度變更情形適時修正，修正後並"]
["","依第一項程序報請核備。"]
["","主管機關認為有必要時，得通知雇主修訂前項工作規則。"]
["","第 38 條"]
["第 38 條","工作規則經主管機關核備後，雇主應即於事業場所內公告並印發各勞工。"]
["","第 39 條"]
["第 39 條","雇主認有必要時，得分別就本法第七十條各款另訂單項工作規則。"]
["","第 40 條"]
["第 40 條","事業單位之事業場所分散各地者，雇主得訂立適用於其事業單位全部勞工"]
["","之工作規則或適用於該事業場所之工作規則。"]
["","第 十 章 監督及檢查"]
[null,"第 41 條"]
["第 41 條","中央主管機關應每年定期發布次年度勞工檢查方針。"]
["","檢查機構應依前項檢查方針分別擬定各該機構之勞工檢查計畫，並於檢查"]
["","方針發布之日起五十日內報請中央主管機關核定後，依該檢查計畫實施檢"]
["","查。"]
["","第 42 條"]
["第 42 條","勞工檢查機構檢查員之任用、訓練、服務，除適用公務員法令之規定外，"]
["","由中央主管機關定之。"]
["","第 43 條"]
["第 43 條","檢查員對事業單位實施檢查時，得通知事業單位之雇主、雇主代理人、勞"]
["","工或有關人員提供必要文件或作必要之說明。"]
["","第 44 條"]
["第 44 條","檢查員檢查後，應將檢查結果向事業單位作必要之說明，並報告檢查機構"]
["","。"]
["","檢查機構認為事業單位有違反法令規定時，應依法處理。"]
["","第 45 條"]
["第 45 條","事業單位對檢查結果有異議時，應於通知送達後十日內向檢查機構以書面"]
["","提出。"]
["","第 46 條"]
["第 46 條","本法第七十四條第一項規定之申訴得以口頭或書面為之。"]
["","第 47 條"]
["第 47 條","雇主對前條之申訴事項，應即查明，如有違反法令規定情事應即改正，並"]
["","將結果通知申訴人。"]
["","第 48 條"]
["第 48 條","（刪除）"]
["","第 49 條"]
["第 49 條","（刪除）"]
["","第 十一 章 附則"]
[null,"第 50 條"]
["第 50 條","本法第八十四條所稱公務員兼具勞工身分者，係指依各項公務員人事法令"]
["","任用、派用、聘用、遴用而於本法第三條所定各業從事工作獲致薪資之人"]
["","員。所稱其他所定勞動條件，係指工作時間、休息、休假、安全衛生、福"]
["","利、加班費等而言。"]
["","第 50-1 條"]
["第 50-1 條","本法第八十四條之一第一項第一款、第二款所稱監督、管理人員、責任制"]
["","專業人員、監視性或間歇性工作，依左列規定："]
["","一、監督、管理人員：係指受雇主僱用，負責事業之經營及管理工作，並"]
["","對一般勞工之受僱、解僱或勞動條件具有決定權力之主管級人員。"]
["","二、責任制專業人員：係指以專門知識或技術完成一定任務並負責其成敗"]
["","之工作者。"]
["","三、監視性工作：係指於一定場所以監視為主之工作。"]
["","四、間歇性工作：係指工作本身以間歇性之方式進行者。"]
["","第 50-2 條"]
["第 50-2 條","雇主依本法第八十四條之一規定將其與勞工之書面約定報請當地主管機關"]
["","核備時，其內容應包括職稱、工作項目、工作權責或工作性質、工作時間"]
["","、例假、休假、女性夜間工作等有關事項。"]
["","第 50-3 條"]
["第 50-3 條","勞工因終止勞動契約或發生職業災害所生爭議，提起給付工資、資遣費、"]
["","退休金、職業災害補償或確認僱傭關係存在之訴訟，得向中央主管機關申"]
["","請扶助。"]
["","前項扶助業務，中央主管機關得委託民間團體辦理。"]
["","第 50-4 條"]
["第 50-4 條","本法第二十八條第二項中華民國一百零四年二月六日修正生效前，雇主有"]
["","清算或宣告破產之情事，於修正生效後，尚未清算完結或破產終結者，勞"]
["","工對於該雇主所積欠之退休金及資遣費，得於同條第二項第二款規定之數"]
["","額內，依同條第五項規定申請墊償。"]
["","第 51 條"]
["第 51 條","本細則自發布日施行。"]

{"sheet":"問題","index":3,"n_rows":12,"n_cols":2,"rows_kept":12}
[null,"依勞基法第38條給予特別休假  曆年制方式行使特別休假<<施行細則第24條"]
[null,"現今，沒休完要決算工資，如有零頭時數沒休完，也没給工資如何處理？"]
[null,"有零頭特休天數如何休?? 會不會變成沒休完或結清特休工資不足呢??"]
[]
[null,"勞檢如何看待？"]
[null,"未來勞檢重點 換算後有無給足假"]
[null,"勞動條件及就業平等司司長謝倩蒨表示，勞基法規定都是以任職滿多久就有多少天特休"]
[]
[null,"離職時如何決算？"]
[null,"例如， 7/1到職，滿2年 前後離職，如 6/30離職與7/2離職，特休結算工資天數一樣嗎?"]
[]
[null,"年度開始可以把大部分特休休完嗎??"]

{"sheet":"到職日後強制進位至整數","index":4,"n_rows":31,"n_cols":40,"rows_kept":31,"merged":[[0,5,0,10],[0,12,0,14],[0,23,0,24],[0,29,0,30],[0,32,0,33],[0,38,1,39],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,17,1,24],[1,25,1,26],[1,27,1,30],[1,31,1,35],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,12,2,14],[2,17,2,18],[2,19,2,20],[2,21,2,22],[2,23,2,24],[2,25,2,26],[2,27,2,28],[2,29,2,30],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,12,3,14],[3,17,3,18],[3,19,3,20],[3,21,3,22],[3,23,3,24],[3,25,3,26],[3,27,3,28],[3,29,3,30],[4,7,4,8],[4,9,4,10],[4,19,4,24],[6,21,6,24],[6,27,6,28],[8,6,8,7],[8,11,8,12],[8,13,8,14],[8,16,8,17],[8,18,8,19],[8,23,8,24],[8,25,8,26],[8,29,8,30],[9,11,9,12],[9,13,9,14],[9,22,9,24],[9,25,9,26],[11,6,11,7],[11,9,11,12],[11,13,11,14],[11,15,11,17],[11,18,11,19],[11,21,11,24],[11,25,11,26],[11,27,11,29],[12,9,12,10],[12,15,12,16],[12,21,12,22],[12,27,12,28],[14,6,14,8],[14,18,14,20],[15,21,15,22],[16,13,16,14],[16,22,16,24],[19,9,19,10],[19,13,19,14],[19,17,19,18],[19,21,19,22],[19,25,19,26],[19,29,19,30],[20,5,20,6],[20,7,20,8],[21,5,21,7],[21,8,21,9],[21,10,21,13],[21,14,21,17],[21,18,21,21],[21,22,21,25],[21,26,21,29],[21,30,21,31],[22,5,22,7],[22,8,22,9],[22,10,22,13],[22,14,22,17],[22,18,22,21],[22,22,22,25],[22,26,22,29],[22,30,22,31],[23,6,23,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,15],[24,16,24,17],[24,18,24,19],[24,20,24,21],[24,22,24,23],[24,24,24,25],[24,26,24,27],[24,28,24,29],[24,30,24,31],[25,5,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[25,16,25,17],[25,18,25,19],[25,20,25,21],[25,22,25,23],[25,24,25,25],[25,26,25,27],[25,28,25,29],[25,30,25,31],[26,6,26,7],[26,8,26,11],[26,12,26,15],[26,16,26,19],[26,20,26,23],[26,24,26,27],[26,28,26,31],[27,5,27,7],[27,8,27,11],[27,12,27,15],[27,16,27,19],[27,20,27,23],[27,24,27,27],[27,28,27,31],[28,5,28,7],[28,8,28,11],[28,12,28,15],[28,16,28,19],[28,20,28,23],[28,24,28,27],[28,28,28,31],[29,8,29,9],[29,10,29,11],[29,12,29,13],[29,14,29,15],[29,16,29,17],[29,18,29,19],[29,20,29,21],[29,22,29,23],[29,24,29,25],[29,26,29,27],[29,28,29,29],[29,30,29,31],[30,10,30,11],[30,14,30,15],[30,18,30,19],[30,22,30,23],[30,26,30,27],[30,30,30,31]]}
[{"$nulls":5},"輸入到職日<年 月 日",{"$nulls":6},"輸入特休給假年度",{"$nulls":9},"原始",{"$f":"IF(OR(V4=0,J4=0),0,ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4),特休表,2,0)*$T4,5))+IF(OR(V4=0,J4=0),0,VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)-ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)*$T4,5))","v":30},{"$nulls":4},"原始",{"$f":"IF(OR(V4=0,J4=0),0,ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4),特休表,2,0)*$T4,5))+IF(OR(V4=0,J4=0),0,VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)-ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)*$T4,5))","v":30},null,"原始",{"$f":"IF(F2<M2-1,0,1)*ROUND(3-3*IF((MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6>=1,1,(MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6),4)","v":{"v":0,"d":"0.00000"}},{"$nulls":5},"滿半年有特休\n到職日期間"]
[null,null,"到職","特休",null,{"v":80,"d":"80年"},null,{"v":3,"d":"3月"},null,{"v":20,"d":"20日"},null,null,{"v":109,"d":"109年"},{"v":12,"d":"12月"},{"v":31,"d":"31日"},null,null,"按比例試算(四捨五入至小數第二位)",{"$nulls":7},"A+B+C",null,"天數整數化試算(強制進位至整數)",{"$nulls":3},"滿半年(未滿一年期間)"]
[null,null,"年資","日數",null,"留職停薪天數",null,"到職日",null,"年資_年",null,null,"年資計算日期",{"$nulls":4},"得特休_X+C",null,"特休比例",null,"到職周年",null,"年度特休_X",null,"曆年年度",null,"到職日前_A",null,"到職日後_B",null,{"$f":"$M$2&\"年度\"","v":"109年度"},{"$f":"$M$2&\"年 1/1前 \"","v":"109年 1/1前 "},{"$f":"$M$2&\"年 1/1後\"","v":"109年 1/1後"},{"$f":"$M$2+1&\" 年前\"","v":"110 年前"},{"$f":"$M$2+1&\"   年後\"","v":"110   年後"},null,null,{"$f":"DATE($M$2+1911-1,1,1)","v":"2019-01-01"},{"$f":"DATE($M$2+1911,1,1)","v":"2020-01-01"}]
[null,null,0,0,{"$nulls":3},{"$f":"DATE(F2+1911,H2,J2)+F4","v":"1991-03-20"},null,{"$f":"IF(OR($H4=0,$H4>$M$4),0,DATEDIF($H4+$G4,$M$4+1,\"Y\"))","v":28},null,null,"2019-12-31",{"$nulls":4},{"$f":"X4+AF4","v":{"v":30,"d":"30.00"}},null,{"$f":"1-(MONTH(H4)-1+(DAY(H4)-1)/DAY(EOMONTH((H4-1),0)))/12","v":{"v":0.782258064516129,"d":"0.782"}},null,{"$f":"IF($H4=0,0,DATEDIF($H4+$G4,DATE(M2+1911,MONTH(H4),DAY(H4)),\"Y\"))","v":29},null,{"$f":"IF(OR(V4=0,J4=0),0,ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4),特休表,2,0)*$T4,2))+IF(OR(V4=0,J4=0),0,VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)-ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)*$T4,2))","v":{"v":30,"d":"30.00"}},null,{"$f":"IF(H4=0,0,AB4+AD4+AF4)","v":30},null,{"$f":"IF(V4=0,0,VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)-ROUNDUP(VLOOKUP(IF(($V4-1)>$J$5,$J$5,($V4-1)),特休表,2,0)*$T4,0))","v":6},null,{"$f":"ROUNDUP(VLOOKUP(($V$4),特休表,2)*T4,0)","v":24},null,{"$f":"IF(AND(H4>=$AM$4,H4<=$AN$3),3,AH4+AI4)","v":0},{"$f":"IF(AH4=0,0,3-$AH$4)","v":0},{"$f":"IF(AND($H$4>$AM$3,$H$4<$AM$4),ROUND(3*(MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6,2),0)","v":0},{"$f":"IF(AND($H4>$AN$3,$H4<$AN$4),3-ROUND(3*(MONTH($H4)-1+(DAY($H4)-1)/DAY(EOMONTH(($H4-1),0)))/6,2),0)","v":0},{"$f":"IF($AI4=0,0,3-$AI4)","v":0},null,null,{"$f":"DATE($M$2+1911-1,7,1)","v":"2019-07-01"},{"$f":"DATE($M$2+1911,7,1)","v":"2020-07-01"}]
[null,null,0.5,3,{"$nulls":3},"特休最大年資",null,24,{"$nulls":8},{"$f":"T4","v":{"v":0.782258064516129,"d":"0.782"}},{"$f":"\"=(1- (\"&MONTH(H4)-1&\"+\"&(DAY(H4)-1)&\"/\"&DAY(EOMONTH((H4-1),0))&\")\"&\"/12)\"","v":"=(1- (2+19/31)/12)"},{"$nulls":5},"以到職日後的比例為主計算特休天數<<強制進位到整數"]
[null,null,1,7,{"$nulls":15},"為到職日至12/31的比例",{"$nulls":5},"到職日前的比例是滿周年天數減到職日後天數",{"$nulls":5},"滿半年比例=",{"$f":"\"(\"&MONTH(H4)-1&\"+\"&(DAY(H4)-1)&\"/\"&DAY(EOMONTH((H4-1),0))&\")\"&\"/6\"","v":"(2+19/31)/6"}]
[null,null,2,10,{"$nulls":4},{"$f":"1-(MONTH(H4)-1+(DAY(H4)-1)/DAY(EOMONTH((H4-1),0)))/12","v":{"v":0.782258064516129,"d":"0.782"}},{"$f":"\"=(1- (\"&MONTH(H4)-1&\"+\"&(DAY(H4)-1)&\"/\"&DAY(EOMONTH((H4-1),0))&\")\"&\"/12)\"","v":"=(1- (2+19/31)/12)"},{"$nulls":3},{"$f":"(MONTH(H4)-1+(DAY(H4)-1)/DAY(EOMONTH((H4-1),0)))/12","v":0.21774193548387097},{"$f":"\"= (\"&MONTH(H4)-1&\"+\"&(DAY(H4)-1)&\"/\"&DAY(EOMONTH((H4-1),0))&\")\"&\"/12)\"","v":"= (2+19/31)/12)"},{"$nulls":3},{"$f":"(MONTH(H4)-1+(DAY(H4)-1)/DAY(EOMONTH((H4-1),0)))/12","v":{"v":0.21774193548387097,"d":"0.218"}},{"$f":"\"= (\"&MONTH(H4)-1&\"+\"&(DAY(H4)-1)&\"/\"&DAY(EOMONTH((H4-1),0))&\")\"&\"/12)\"","v":"= (2+19/31)/12)"},null,"為到職日至12/31的比例",{"$nulls":9},"1/1至到職日比例=",{"$f":"(MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6","v":{"v":0.43548387096774194,"d":"0.44"}}]
[null,null,3,14]
[null,null,4,14,null,null,{"$f":"DATE(YEAR(N10)-1,H2,J2)","v":"2019-03-20"},{"$nulls":4},{"$f":"DATE($M$2+1911-1,12,31)","v":"2019-12-31"},null,{"$f":"N10","v":"2020-01-01"},null,null,{"$f":"DATE(YEAR($G$12)+1,MONTH($H$4),DAY($H$4))-1","v":"2020-03-19"},null,{"$f":"DATE(YEAR(N10),H2,J2)","v":"2020-03-20"},{"$nulls":4},"年度末",null,"年度初",{"$nulls":3},{"$f":"DATE(YEAR(N10)+1,H2,J2)","v":"2021-03-20"}]
[null,null,5,15,null,null,"到職周年",null,"到職日後",null,null,"年度初",null,{"$f":"J12+1","v":"2020-01-01"},null,"到職日前",null,null,"到職周年",null,"到職日後",null,{"$f":"V12","v":"2020-12-31"},null,null,{"$f":"W10+1","v":"2021-01-01"},null,"到職日前",null,null,"到職周年"]
[null,null,6,15,null,null,{"$f":"IF(V4=0,0,V4-1)","v":28},"年",{"$nulls":4},{"$f":"IF(V4=0,0,VLOOKUP(($V$4-1),特休表,2))","v":30},"天",{"$nulls":4},{"$f":"V4","v":29},"年",{"$nulls":4},{"$f":"VLOOKUP(($V$4),特休表,2)","v":30},"天"]
[null,null,7,15,null,null,{"$f":"DATE($M$2+1911-1,MONTH($H$4),DAY($H$4))","v":"2019-03-20"},null,null,{"$f":"DATE($M$2+1911-1,12,31)","v":"2019-12-31"},{"$nulls":3},{"$f":"N10","v":"2020-01-01"},null,{"$f":"DATE(YEAR($G$12)+1,MONTH($H$4),DAY($H$4))-1","v":"2020-03-19"},null,null,{"$f":"P12+1","v":"2020-03-20"},null,null,{"$f":"DATE(YEAR($J$12)+1,12,31)","v":"2020-12-31"},{"$nulls":3},{"$f":"V12+1","v":"2021-01-01"},null,{"$f":"DATE(YEAR($G$12)+2,MONTH($H$4),DAY($H$4))-1","v":"2021-03-19"}]
[null,null,8,15,{"$nulls":4},"比例",{"$f":"$T$4","v":{"v":0.782258064516129,"d":"0.782"}},{"$nulls":4},"比例",{"$f":"(1-$J$13)","v":{"v":0.217741935483871,"d":"0.218"}},{"$nulls":4},"比例",{"$f":"$T$4","v":{"v":0.782258064516129,"d":"0.782"}},{"$nulls":4},"比例",{"$f":"(1-$J$13)","v":{"v":0.217741935483871,"d":"0.218"}}]
[null,null,9,15,{"$nulls":3},"特休",{"$f":"M11","v":30},"x",{"$f":"J13","v":{"v":0.782258064516129,"d":"0.782"}},"=",{"$f":"I14*K14","v":{"v":23.467741935483872,"d":"23.468"}},null,"特休",{"$f":"M11","v":30},"-",{"$f":"K15","v":24},null,"特休",{"$f":"Y11","v":30},"x",{"$f":"V13","v":{"v":0.782258064516129,"d":"0.782"}},"=",{"$f":"U14*W14","v":{"v":23.467741935483872,"d":"23.468"}},null,"特休",{"$f":"Y11","v":30},"-",{"$f":"W15","v":24}]
[null,null,10,16,null,null,"(強制進位)",null,null,"=",{"$f":"ROUNDUP(I14*K14,0)","v":24},{"$nulls":3},"=",{"$f":"M11-K15","v":6},null,null,"強制進位至整數",null,null,"=",{"$f":"ROUNDUP(U14*W14,0)","v":24},{"$nulls":3},"=",{"$f":"AB14-AD14","v":6}]
[null,null,11,17,{"$nulls":5},"強制進位至整數",{"$nulls":6},"=",{"$f":"P15","v":6},"+",{"$f":"W15","v":24},"=",{"$f":"P15+W15","v":30},null,"天"]
[null,null,12,18,{"$nulls":5},"使其為整數",{"$nulls":3},{"$f":"N10","v":"2020-01-01"},null,null,"曆年制年度特休天數",{"$nulls":5},{"$f":"W10","v":"2020-12-31"}]
[null,null,13,19,null,null,"◎上述試算程式未計算滿半年3天的部分"]
[null,null,14,20]
[null,null,15,21,{"$nulls":5},{"$f":"I$27","v":107},{"$nulls":3},{"$f":"M27","v":108},{"$nulls":3},{"$f":"Q27","v":109},{"$nulls":3},{"$f":"U27","v":110},{"$nulls":3},{"$f":"Y27","v":111},{"$nulls":3},{"$f":"AC27","v":112}]
[null,null,16,22,null,"到職日",null,{"$f":"$H$4","v":"1991-03-20"},null,{"$f":"K21-1","v":"2018-03-19"},{"$f":"DATE(I27+1911,$H$2,$J$2)","v":"2018-03-20"},null,null,{"$f":"O21-1","v":"2019-03-19"},{"$f":"DATE(M27+1911,$H$2,$J$2)","v":"2019-03-20"},null,null,{"$f":"S21-1","v":"2020-03-19"},{"$f":"DATE(Q27+1911,$H$2,$J$2)","v":"2020-03-20"},null,null,{"$f":"W21-1","v":"2021-03-19"},{"$f":"DATE(U27+1911,$H$2,$J$2)","v":"2021-03-20"},null,null,{"$f":"AA21-1","v":"2022-03-19"},{"$f":"DATE(Y27+1911,$H$2,$J$2)","v":"2022-03-20"},null,null,{"$f":"AE21-1","v":"2023-03-19"},{"$f":"DATE(AC27+1911,$H$2,$J$2)","v":"2023-03-20"}]
[null,null,17,23,null,"周年制年度",null,null,{"$f":"IF((K22-1)<0,0,K22-1)","v":{"v":26,"d":"滿26周年期間"}},null,{"$f":"I27-(YEAR($H$4)-1911)","v":{"v":27,"d":"滿27周年期間"}},{"$nulls":3},{"$f":"M27-(YEAR($H$4)-1911)","v":{"v":28,"d":"滿28周年期間"}},{"$nulls":3},{"$f":"Q27-(YEAR($H$4)-1911)","v":{"v":29,"d":"滿29周年期間"}},{"$nulls":3},{"$f":"U27-(YEAR($H$4)-1911)","v":{"v":30,"d":"滿30周年期間"}},{"$nulls":3},{"$f":"Y27-(YEAR($H$4)-1911)","v":{"v":31,"d":"滿31周年期間"}},{"$nulls":3},{"$f":"AA22+1","v":{"v":32,"d":"滿32周年期間"}}]
[null,null,18,24,null,"周年制天數",null,null,{"$f":"IF(ISNA(VLOOKUP((K$22-1),特休表,2,0)),0,VLOOKUP((K$22-1),特休表,2,0))","v":30},null,{"$f":"IF(ISNA(VLOOKUP(K$22,特休表,2,0)),0,VLOOKUP(K$22,特休表,2,0))","v":30},{"$nulls":3},{"$f":"IF(ISNA(VLOOKUP(O$22,特休表,2,0)),0,VLOOKUP(O$22,特休表,2,0))","v":30},{"$nulls":3},{"$f":"VLOOKUP(S$22,特休表,2,0)","v":30},{"$nulls":3},{"$f":"VLOOKUP(W$22,特休表,2,0)","v":30},{"$nulls":3},{"$f":"VLOOKUP(AA$22,特休表,2,0)","v":30},{"$nulls":3},{"$f":"VLOOKUP((AA22+1),特休表,2,0)","v":30}]
[null,null,19,25,null,null,"日期",null,{"$f":"DATE(I27+1911,1,1)","v":"2018-01-01"},{"$f":"J21","v":"2018-03-19"},{"$f":"K21","v":"2018-03-20"},{"$f":"DATE(I27+1911,12,31)","v":"2018-12-31"},{"$f":"DATE(M27+1911,1,1)","v":"2019-01-01"},{"$f":"N21","v":"2019-03-19"},{"$f":"O21","v":"2019-03-20"},{"$f":"DATE(M27+1911,12,31)","v":"2019-12-31"},{"$f":"DATE(Q27+1911,1,1)","v":"2020-01-01"},{"$f":"R21","v":"2020-03-19"},{"$f":"S21","v":"2020-03-20"},{"$f":"DATE(Q27+1911,12,31)","v":"2020-12-31"},{"$f":"DATE(U27+1911,1,1)","v":"2021-01-01"},{"$f":"V21","v":"2021-03-19"},{"$f":"W21","v":"2021-03-20"},{"$f":"DATE(U27+1911,12,31)","v":"2021-12-31"},{"$f":"DATE(Y27+1911,1,1)","v":"2022-01-01"},{"$f":"Z21","v":"2022-03-19"},{"$f":"AA21","v":"2022-03-20"},{"$f":"DATE(Y27+1911,12,31)","v":"2022-12-31"},{"$f":"DATE(AC27+1911,1,1)","v":"2023-01-01"},{"$f":"AD21","v":"2023-03-19"},{"$f":"AE21","v":"2023-03-20"},{"$f":"DATE(AC27+1911,12,31)","v":"2023-12-31"}]
[null,null,20,26,{"$nulls":3},"比例",{"$f":"1-$T$4","v":{"v":0.217741935483871,"d":"0.218"}},null,{"$f":"$T$4","v":{"v":0.782258064516129,"d":"0.782"}},null,{"$f":"1-$T$4","v":{"v":0.217741935483871,"d":"0.218"}},null,{"$f":"$T$4","v":{"v":0.782258064516129,"d":"0.782"}},null,{"$f":"1-$T$4","v":{"v":0.217741935483871,"d":"0.218"}},null,{"$f":"$T$4","v":{"v":0.782258064516129,"d":"0.782"}},null,{"$f":"1-$T$4","v":{"v":0.217741935483871,"d":"0.218"}},null,{"$f":"$T$4","v":{"v":0.782258064516129,"d":"0.782"}},null,{"$f":"1-$T$4","v":{"v":0.217741935483871,"d":"0.218"}},null,{"$f":"$T$4","v":{"v":0.782258064516129,"d":"0.782"}},null,{"$f":"1-$T$4","v":{"v":0.217741935483871,"d":"0.218"}},null,{"$f":"$T$4","v":{"v":0.782258064516129,"d":"0.782"}}]
[null,null,21,27,null,"曆年制比例天數",null,null,{"$f":"IF(ISNA(I23-ROUNDUP(I23*(1-I25),0)),0,I23-ROUNDUP(I23*(1-I25),0))","v":6},null,{"$f":"IF(ISNA(ROUNDUP(K23*K25,0)),0,ROUNDUP(K23*K25,0))","v":24},null,{"$f":"K23-K26","v":6},null,{"$f":"ROUNDUP(O23*O25,0)","v":24},null,{"$f":"O23-O26","v":6},null,{"$f":"ROUNDUP(S23*S25,0)","v":24},null,{"$f":"S23-S26","v":6},null,{"$f":"ROUNDUP(W23*W25,0)","v":24},null,{"$f":"W23-W26","v":6},null,{"$f":"ROUNDUP(AA23*AA25,0)","v":24},null,{"$f":"AA23-AA26","v":6},null,{"$f":"ROUNDUP(AE23*AE25,0)","v":24}]
[null,null,22,28,null,null,"曆年制年度",null,{"$f":"M2-2","v":107},{"$nulls":3},{"$f":"I27+1","v":108},{"$nulls":3},{"$f":"M27+1","v":109},{"$nulls":3},{"$f":"Q27+1","v":110},{"$nulls":3},{"$f":"U27+1","v":111},{"$nulls":3},{"$f":"Y27+1","v":112}]
[null,null,23,29,null,"曆年制天數",null,null,{"$f":"I26+K26","v":30},{"$nulls":3},{"$f":"M26+O26","v":30},{"$nulls":3},{"$f":"Q26+S26","v":30},{"$nulls":3},{"$f":"U26+W26","v":30},{"$nulls":3},{"$f":"Y26+AA26","v":30},{"$nulls":3},{"$f":"AC26+AE26","v":30}]
[null,null,24,30,null,"曆年制年度",null,null,{"$f":"I27-$F$2","v":27},{"$nulls":3},{"$f":"M27-$F$2","v":28},{"$nulls":3},{"$f":"Q27-$F$2","v":29},{"$nulls":3},{"$f":"U27-$F$2","v":30},{"$nulls":3},{"$f":"Y27-$F$2","v":31},{"$nulls":3},{"$f":"AC27-$F$2","v":32}]
[null,null,25,30,{"$nulls":4},"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後"]
[{"$nulls":10},"強制進位至整數",{"$nulls":3},{"$f":"$K$31","v":"強制進位至整數"},{"$nulls":3},{"$f":"$K$31","v":"強制進位至整數"},{"$nulls":3},{"$f":"$K$31","v":"強制進位至整數"},{"$nulls":3},{"$f":"$K$31","v":"強制進位至整數"},{"$nulls":3},{"$f":"$K$31","v":"強制進位至整數"}]

{"sheet":"官方算法_到職日前四捨五入到小數第二位","index":5,"n_rows":51,"n_cols":40,"rows_kept":51,"merged":[[0,5,0,10],[0,12,0,14],[0,38,1,39],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,19,1,24],[1,25,1,26],[1,27,1,30],[1,31,1,35],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,12,2,14],[2,17,2,18],[2,19,2,20],[2,21,2,22],[2,23,2,24],[2,25,2,26],[2,27,2,28],[2,29,2,30],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,12,3,14],[3,17,3,18],[3,19,3,20],[3,21,3,22],[3,23,3,24],[3,25,3,26],[3,27,3,28],[3,29,3,30],[4,7,4,8],[4,9,4,10],[4,15,4,16],[4,19,4,20],[5,19,5,21],[6,13,6,17],[6,18,6,24],[8,8,8,10],[8,11,8,12],[8,13,8,14],[8,23,8,24],[8,25,8,26],[9,11,9,12],[9,13,9,14],[9,22,9,24],[9,25,9,26],[11,6,11,7],[11,9,11,12],[11,13,11,14],[11,18,11,19],[11,21,11,24],[11,25,11,26],[11,27,11,29],[12,9,12,10],[12,15,12,16],[12,21,12,22],[12,27,12,28],[13,6,13,7],[13,22,13,23],[14,9,14,10],[14,15,14,16],[14,20,14,21],[14,23,14,24],[14,27,14,28],[17,9,17,10],[17,13,17,14],[17,17,17,18],[17,21,17,22],[17,25,17,26],[17,29,17,30],[18,5,18,6],[18,7,18,8],[19,5,19,7],[19,10,19,13],[19,14,19,17],[19,18,19,21],[19,22,19,25],[19,26,19,29],[20,5,20,7],[20,8,20,9],[20,10,20,13],[20,14,20,17],[20,18,20,21],[20,22,20,25],[20,26,20,29],[20,30,20,31],[21,6,21,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17],[22,18,22,19],[22,20,22,21],[22,22,22,23],[22,24,22,25],[22,26,22,27],[22,28,22,29],[22,30,22,31],[23,5,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[23,16,23,17],[23,18,23,19],[23,20,23,21],[23,22,23,23],[23,24,23,25],[23,26,23,27],[23,28,23,29],[23,30,23,31],[24,6,24,7],[24,8,24,11],[24,12,24,15],[24,16,24,19],[24,20,24,23],[24,24,24,27],[24,28,24,31],[25,5,25,7],[25,8,25,11],[25,12,25,15],[25,16,25,19],[25,20,25,23],[25,24,25,27],[25,28,25,31],[26,5,26,7],[26,8,26,11],[26,12,26,15],[26,16,26,19],[26,20,26,23],[26,24,26,27],[26,28,26,31]]}
[{"$nulls":5},"輸入到職日<年 月 日",{"$nulls":6},"輸入特休給假年度",{"$nulls":13},"原始",{"$f":"VLOOKUP(IF(($V4-1)>$J$5,$J$5,($V4-1)),特休表,2,0)*$T4","v":15},null,"原始",{"$f":"VLOOKUP(($V$4),特休表,2)-VLOOKUP(($V$4),特休表,2)*T4","v":15},"原始",{"$f":"IF(F2<M2-1,0,1)*ROUND(3-3*IF((MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6>=1,1,(MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6),4)","v":0},{"$nulls":5},"滿半年有特休\n到職日期間"]
[null,null,"到職","特休",null,{"v":80,"d":"80年"},null,{"v":7,"d":"7月"},null,{"v":1,"d":"1日"},null,null,109,12,31,{"$nulls":4},"按比例",{"$nulls":5},"A+B+C",null,"天數試算(四捨五入至小數第二位)",{"$nulls":3},"滿半年(未滿一年期間)"]
[null,null,"年資","日數",null,"留職停薪",null,"到職日",{"$nulls":4},"年資計算日期",{"$nulls":4},"得特休_X+C",null,"特休比例",null,"到職周年",null,"年度特休_X",null,"曆年年度",null,"到職日前_A",null,"到職日後_B",null,{"$f":"$M$2&\"年度\"","v":"109年度"},{"$f":"$M$2&\"年 1/1前 \"","v":"109年 1/1前 "},{"$f":"$M$2&\"年 1/1後\"","v":"109年 1/1後"},{"$f":"$M$2+1&\" 年前\"","v":"110 年前"},{"$f":"$M$2+1&\"   年後\"","v":"110   年後"},null,null,{"$f":"DATE($M$2+1911-1,1,1)","v":"2019-01-01"},{"$f":"DATE($M$2+1911,1,1)","v":"2020-01-01"}]
[null,null,0,0,{"$nulls":3},{"$f":"DATE(F2+1911,H2,J2)+F4","v":"1991-07-01"},null,{"$f":"IF(OR($H4=0,$H4>$M$4),0,DATEDIF($H4+$G4,$M$4+1,\"Y\"))","v":29},null,null,{"$f":"DATE($M$2+11,$N$2,$O$2)","v":"2020-12-31"},{"$nulls":4},{"$f":"$AF$4+$X$4","v":{"v":30,"d":"30.00"}},null,{"$f":"(MONTH(H4)-1+(DAY(H4)-1)/DAY(EOMONTH((H4-1),0)))/12","v":{"v":0.5,"d":"0.500"}},null,{"$f":"IF($H4=0,0,DATEDIF($H4+$G4,DATE(M2+1911,MONTH(H4),DAY(H4)),\"Y\"))","v":29},null,{"$f":"IF(OR(V4=0,J4=0),0,VLOOKUP(IF($V4>$J$5,$J$5,$V4),特休,2,0)-ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4),特休,2,0)*$T4,2))+IF(OR(V4=0,J4=0),0,ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休,2,0)*$T4,2))","v":{"v":30,"d":"30.00"}},null,{"$f":"AD4+AB4+AF4","v":{"v":30,"d":"30.00"}},null,{"$f":"ROUND(VLOOKUP(IF(($V4-1)>$J$5,$J$5,($V4-1)),特休表,2,0)*$T4,2)","v":{"v":15,"d":"15.00"}},null,{"$f":"VLOOKUP(($V$4),特休表,2)-ROUND(VLOOKUP(($V$4),特休表,2)*T4,2)","v":{"v":15,"d":"15.00"}},null,{"$f":"IF(AND(H4>=$AM$4,H4<=$AN$3),3,AH4+AI4)","v":0},{"$f":"IF(AH4=0,0,3-$AH$4)","v":0},{"$f":"IF(AND($H$4>$AM$3,$H$4<$AM$4),ROUND(3*(MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6,2),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(AND($H4>$AN$3,$H4<$AN$4),3-ROUND(3*(MONTH($H4)-1+(DAY($H4)-1)/DAY(EOMONTH(($H4-1),0)))/6,2),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF($AI4=0,0,3-$AI4)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"DATE($M$2+1911-1,7,1)","v":"2019-07-01"},{"$f":"DATE($M$2+1911,7,1)","v":"2020-07-01"}]
[null,null,0.5,3,{"$nulls":3},"特休最大年資",null,24,{"$nulls":5},"滿半年",{"$nulls":3},{"$f":"\"=(\"&MONTH(H4)-1&\"+\"&(DAY(H4)-1)&\"/\"&DAY(EOMONTH((H4-1),0))&\")\"&\"/12\"","v":"=(6+0/30)/12"},{"$nulls":4},"(到職日前四使五入至小數第二位)","以到職日前的比例為主計算特休天數"]
[null,null,1,7,{"$nulls":15},"1/1~到職日前一日",{"$nulls":5},"到職日後的比例是滿周年天數減到職日前天數",{"$nulls":5},"滿半年比例=",{"$f":"\"(\"&MONTH(H4)-1&\"+\"&(DAY(H4)-1)&\"/\"&DAY(EOMONTH((H4-1),0))&\")\"&\"/6\"","v":"(6+0/30)/6"}]
[null,null,2,10,{"$nulls":27},"1/1至到職日比例=",{"$f":"(MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6","v":{"v":1,"d":"1.00"}}]
[null,null,3,14,{"$nulls":9},"2019-01-01",{"$nulls":3},"2019-05-14",{"$nulls":6},"2019-12-31"]
[null,null,4,14,{"$nulls":7},"年度末",null,"年度初",null,"2019-05-01",{"$nulls":5},"2019-06-06",null,"年度末",null,"年度初"]
[null,null,5,15,null,null,"到職周年",null,"到職日後",null,null,"年度初",null,{"$f":"J12+1","v":"2020-01-01"},null,"到職日前",null,null,"到職周年",null,"到職日後",null,{"$f":"V12","v":"2020-12-31"},null,null,{"$f":"W10+1","v":"2021-01-01"},null,"到職日前",null,null,"到職周年"]
[null,null,6,15,null,null,{"$f":"IF(V4=0,0,V4-1)","v":28},"年",{"$nulls":4},{"$f":"IF(V4=0,0,VLOOKUP(($V$4-1),特休,2))","v":30},"天",{"$nulls":4},{"$f":"V4","v":29},"年",{"$nulls":4},{"$f":"VLOOKUP(($V$4),特休,2)","v":30},"天"]
[null,null,7,15,null,null,{"$f":"DATE($M$2+1911-1,MONTH($H$4),DAY($H$4))","v":"2019-07-01"},null,null,{"$f":"DATE($M$2+1911-1,12,31)","v":"2019-12-31"},{"$nulls":3},{"$f":"N10","v":"2020-01-01"},{"$nulls":3},{"$f":"DATE(YEAR($G$12)+1,MONTH($H$4),DAY($H$4)-1)","v":"2020-06-30"},{"$f":"R12+1","v":"2020-07-01"},null,null,{"$f":"DATE(YEAR($J$12)+1,12,31)","v":"2020-12-31"},{"$nulls":3},{"$f":"V12+1","v":"2021-01-01"},null,{"$f":"DATE(YEAR($G$12)+2,MONTH($H$4),DAY($H$4)-1)","v":"2021-06-30"}]
[null,null,8,15,{"$nulls":4},"比例",{"$f":"1-$T$4","v":{"v":0.5,"d":"0.500"}},{"$nulls":4},"比例",{"$f":"$T$4","v":{"v":0.5,"d":"0.500"}},{"$nulls":4},"比例",{"$f":"1-AB13","v":{"v":0.5,"d":"0.500"}},{"$nulls":4},"比例",{"$f":"$T$4","v":{"v":0.5,"d":"0.500"}}]
[null,null,9,15,null,null,"滿一年",null,"特休",{"$f":"M11","v":30},"－",{"$f":"$P$15","v":{"v":15,"d":"15.00"}},null,null,"特休",{"$f":"M11","v":30},"X",{"$f":"T4","v":{"v":0.5,"d":"0.500"}},null,"特休",{"$f":"Y11","v":30},"－",{"$f":"AB15","v":{"v":15,"d":"15.000"}},{"$nulls":3},"特休",{"$f":"Y11","v":30},"X",{"$f":"AB13","v":{"v":0.5,"d":"0.500"}}]
[null,null,10,16,{"$nulls":4},"=",{"$f":"J14-L14","v":{"v":15,"d":"15.00"}},{"$nulls":4},"=",{"$f":"ROUND(P14*R14,2)","v":{"v":15,"d":"15.00"}},null,null,"+",null,{"$f":"Y11-AB15","v":{"v":15,"d":"15.00"}},null,"=",{"$f":"P15+U15","v":{"v":30,"d":"30.00"}},null,null,"=",{"$f":"ROUND(AB14*AD14,2)","v":15}]
[null,null,11,17,{"$nulls":9},"小數捨去取第二位",{"$nulls":11},"小數捨去取第二位"]
[null,null,12,18,null,null,"◎上述試算程式未計算滿半年3天的部分"]
[null,null,13,19,{"$nulls":5},{"$f":"I$25","v":107},{"$nulls":3},{"$f":"M25","v":108},{"$nulls":3},{"$f":"Q25","v":109},{"$nulls":3},{"$f":"U25","v":110},{"$nulls":3},{"$f":"Y25","v":111},{"$nulls":3},{"$f":"AC25","v":112}]
[null,null,14,20,null,"到職日",null,{"$f":"$H$4","v":"1991-07-01"},null,{"$f":"K19-1","v":"2018-06-30"},{"$f":"DATE(I25+1911,$H$2,$J$2)","v":"2018-07-01"},null,null,{"$f":"O19-1","v":"2019-06-30"},{"$f":"DATE(M25+1911,$H$2,$J$2)","v":"2019-07-01"},null,null,{"$f":"S19-1","v":"2020-06-30"},{"$f":"DATE(Q25+1911,$H$2,$J$2)","v":"2020-07-01"},null,null,{"$f":"W19-1","v":"2021-06-30"},{"$f":"DATE(U25+1911,$H$2,$J$2)","v":"2021-07-01"},null,null,{"$f":"AA19-1","v":"2022-06-30"},{"$f":"DATE(Y25+1911,$H$2,$J$2)","v":"2022-07-01"},null,null,{"$f":"AE19-1","v":"2023-06-30"},{"$f":"DATE(AC25+1911,$H$2,$J$2)","v":"2023-07-01"}]
[null,null,15,21,null,"周年制年度",{"$nulls":4},{"$f":"I25-(YEAR($H$4)-1911)","v":{"v":27,"d":"滿27周年期間"}},{"$nulls":3},{"$f":"M25-(YEAR($H$4)-1911)","v":{"v":28,"d":"滿28周年期間"}},{"$nulls":3},{"$f":"Q25-(YEAR($H$4)-1911)","v":{"v":29,"d":"滿29周年期間"}},{"$nulls":3},{"$f":"U25-(YEAR($H$4)-1911)","v":{"v":30,"d":"滿30周年期間"}},{"$nulls":3},{"$f":"Y25-(YEAR($H$4)-1911)","v":{"v":31,"d":"滿31周年期間"}}]
[null,null,16,22,null,"周年制天數",null,null,{"$f":"VLOOKUP((K$20-1),特休表,2,0)","v":30},null,{"$f":"VLOOKUP(K$20,特休表,2,0)","v":30},{"$nulls":3},{"$f":"VLOOKUP(O$20,特休表,2,0)","v":30},{"$nulls":3},{"$f":"VLOOKUP(S$20,特休表,2,0)","v":30},{"$nulls":3},{"$f":"VLOOKUP(W$20,特休表,2,0)","v":30},{"$nulls":3},{"$f":"VLOOKUP(AA$20,特休表,2,0)","v":30},{"$nulls":3},{"$f":"VLOOKUP((AA20+1),特休表,2,0)","v":30}]
[null,null,17,23,null,null,"日期",null,{"$f":"DATE(I25+1911,1,1)","v":"2018-01-01"},{"$f":"J19","v":"2018-06-30"},{"$f":"K19","v":"2018-07-01"},{"$f":"DATE(I25+1911,12,31)","v":"2018-12-31"},{"$f":"DATE(M25+1911,1,1)","v":"2019-01-01"},{"$f":"N19","v":"2019-06-30"},{"$f":"O19","v":"2019-07-01"},{"$f":"DATE(M25+1911,12,31)","v":"2019-12-31"},{"$f":"DATE(Q25+1911,1,1)","v":"2020-01-01"},{"$f":"R19","v":"2020-06-30"},{"$f":"S19","v":"2020-07-01"},{"$f":"DATE(Q25+1911,12,31)","v":"2020-12-31"},{"$f":"DATE(U25+1911,1,1)","v":"2021-01-01"},{"$f":"V19","v":"2021-06-30"},{"$f":"W19","v":"2021-07-01"},{"$f":"DATE(U25+1911,12,31)","v":"2021-12-31"},{"$f":"DATE(Y25+1911,1,1)","v":"2022-01-01"},{"$f":"Z19","v":"2022-06-30"},{"$f":"AA19","v":"2022-07-01"},{"$f":"DATE(Y25+1911,12,31)","v":"2022-12-31"},{"$f":"DATE(AC25+1911,1,1)","v":"2023-01-01"},{"$f":"AD19","v":"2023-06-30"},{"$f":"AE19","v":"2023-07-01"},{"$f":"DATE(AC25+1911,12,31)","v":"2023-12-31"}]
[null,null,18,24,{"$nulls":3},"比例",{"$f":"$T$4","v":{"v":0.5,"d":"0.500"}},null,{"$f":"1-I23","v":{"v":0.5,"d":"0.500"}},null,{"$f":"$T$4","v":{"v":0.5,"d":"0.500"}},null,{"$f":"1-M23","v":{"v":0.5,"d":"0.500"}},null,{"$f":"$T$4","v":{"v":0.5,"d":"0.500"}},null,{"$f":"1-Q23","v":{"v":0.5,"d":"0.500"}},null,{"$f":"$T$4","v":{"v":0.5,"d":"0.500"}},null,{"$f":"1-U23","v":{"v":0.5,"d":"0.500"}},null,{"$f":"$T$4","v":{"v":0.5,"d":"0.500"}},null,{"$f":"1-Y23","v":{"v":0.5,"d":"0.500"}},null,{"$f":"$T$4","v":{"v":0.5,"d":"0.500"}},null,{"$f":"1-AC23","v":{"v":0.5,"d":"0.500"}}]
[null,null,19,25,null,"曆年制比例天數",null,null,{"$f":"ROUND(I21*I23,2)","v":15},null,{"$f":"K21-M24","v":15},null,{"$f":"ROUND(K21*M23,2)","v":15},null,{"$f":"O21-Q24","v":15},null,{"$f":"ROUND(O21*Q23,2)","v":15},null,{"$f":"S21-U24","v":15},null,{"$f":"ROUND(S21*U23,2)","v":15},null,{"$f":"W21-Y24","v":15},null,{"$f":"ROUND(W21*Y23,2)","v":15},null,{"$f":"AA21-AC24","v":15},null,{"$f":"ROUND(AA21*AC23,2)","v":15},null,{"$f":"VLOOKUP((AC$27),特休,2)-ROUND(VLOOKUP((AC$27),特休,2)*$T$4,2)","v":15}]
[null,null,20,26,null,null,"曆年制年度",null,{"$f":"M2-2","v":107},{"$nulls":3},{"$f":"I25+1","v":108},{"$nulls":3},{"$f":"M25+1","v":109},{"$nulls":3},{"$f":"Q25+1","v":110},{"$nulls":3},{"$f":"U25+1","v":111},{"$nulls":3},{"$f":"Y25+1","v":112}]
[null,null,21,27,null,"曆年制天數",null,null,{"$f":"I24+K24","v":30},{"$nulls":3},{"$f":"M24+O24","v":30},{"$nulls":3},{"$f":"Q24+S24","v":30},{"$nulls":3},{"$f":"U24+W24","v":30},{"$nulls":3},{"$f":"Y24+AA24","v":30},{"$nulls":3},{"$f":"AC24+AE24","v":30}]
[null,null,22,28,null,"曆年制年度",null,null,{"$f":"I25-$F$2","v":27},{"$nulls":3},{"$f":"M25-$F$2","v":28},{"$nulls":3},{"$f":"Q25-$F$2","v":29},{"$nulls":3},{"$f":"U25-$F$2","v":30},{"$nulls":3},{"$f":"Y25-$F$2","v":31},{"$nulls":3},{"$f":"AC25-$F$2","v":32}]
[null,null,23,29,{"$nulls":4},"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後"]
[null,null,24,30]
[null,null,25,30]
[null,null,26,30]
[null,null,27,30]
[null,null,28,30]
[null,null,29,30]
[null,null,30,30]
[null,null,31,30]
[null,null,32,30]
[null,null,33,30]
[null,null,34,30]
[null,null,35,30]
[null,null,36,30]
[null,null,37,30]
[null,null,38,30]
[null,null,39,30]
[null,null,40,30]
[null,null,41,30]
[null,null,42,30]
[null,null,43,30]
[null,null,44,30]
[null,null,45,30]
[null,null,46,30]

{"sheet":"到職日後四捨五入進位至整數","index":6,"n_rows":31,"n_cols":40,"rows_kept":31,"merged":[[0,5,0,10],[0,12,0,14],[0,38,1,39],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,17,1,24],[1,25,1,26],[1,27,1,30],[1,31,1,35],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,12,2,14],[2,17,2,18],[2,19,2,20],[2,21,2,22],[2,23,2,24],[2,25,2,26],[2,27,2,28],[2,29,2,30],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,12,3,14],[3,17,3,18],[3,19,3,20],[3,21,3,22],[3,23,3,24],[3,25,3,26],[3,27,3,28],[3,29,3,30],[4,7,4,8],[4,9,4,10],[4,19,4,24],[5,17,5,18],[6,23,6,26],[6,27,6,28],[8,6,8,7],[8,11,8,12],[8,13,8,14],[8,16,8,17],[8,18,8,19],[8,23,8,24],[8,25,8,26],[8,29,8,30],[9,11,9,12],[9,13,9,14],[9,22,9,24],[9,25,9,26],[11,6,11,7],[11,9,11,12],[11,13,11,14],[11,15,11,17],[11,18,11,19],[11,21,11,24],[11,25,11,26],[11,27,11,29],[12,9,12,10],[12,15,12,16],[12,21,12,22],[12,27,12,28],[14,6,14,8],[14,18,14,20],[15,21,15,22],[16,13,16,14],[16,22,16,24],[19,9,19,10],[19,13,19,14],[19,17,19,18],[19,21,19,22],[19,25,19,26],[19,29,19,30],[20,5,20,6],[20,7,20,8],[21,5,21,7],[21,8,21,9],[21,10,21,13],[21,14,21,17],[21,18,21,21],[21,22,21,25],[21,26,21,29],[21,30,21,31],[22,5,22,7],[22,8,22,9],[22,10,22,13],[22,14,22,17],[22,18,22,21],[22,22,22,25],[22,26,22,29],[22,30,22,31],[23,6,23,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,15],[24,16,24,17],[24,18,24,19],[24,20,24,21],[24,22,24,23],[24,24,24,25],[24,26,24,27],[24,28,24,29],[24,30,24,31],[25,5,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[25,16,25,17],[25,18,25,19],[25,20,25,21],[25,22,25,23],[25,24,25,25],[25,26,25,27],[25,28,25,29],[25,30,25,31],[26,6,26,7],[26,8,26,11],[26,12,26,15],[26,16,26,19],[26,20,26,23],[26,24,26,27],[26,28,26,31],[27,5,27,7],[27,8,27,11],[27,12,27,15],[27,16,27,19],[27,20,27,23],[27,24,27,27],[27,28,27,31],[28,5,28,7],[28,8,28,11],[28,12,28,15],[28,16,28,19],[28,20,28,23],[28,24,28,27],[28,28,28,31],[29,8,29,9],[29,10,29,11],[29,12,29,13],[29,14,29,15],[29,16,29,17],[29,18,29,19],[29,20,29,21],[29,22,29,23],[29,24,29,25],[29,26,29,27],[29,28,29,29],[29,30,29,31],[30,10,30,11],[30,14,30,15],[30,18,30,19],[30,22,30,23],[30,26,30,27],[30,30,30,31]]}
[{"$nulls":5},"輸入到職日<年 月 日",{"$nulls":6},"輸入特休給假年度",{"$nulls":9},"原始",{"$f":"IF(OR(V4=0,J4=0),0,ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4),特休表,2,0)*$T4,5))+IF(OR(V4=0,J4=0),0,VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)-ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)*$T4,5))","v":30},null,"原始",{"$f":"IF(OR(V4=0,J4=0),0,ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4),特休表,2,0)*$T4,5))+IF(OR(V4=0,J4=0),0,VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)-ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)*$T4,5))","v":30},"原始",{"$f":"IF(V4=0,0,VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)-VLOOKUP(IF(($V4-1)>$J$5,$J$5,($V4-1)),特休表,2,0)*$T4)","v":15.080645161290322},"原始",{"$f":"VLOOKUP(($V$4),特休表,2)*T4","v":14.919354838709678},"原始",{"$f":"IF(F2<M2-1,0,1)*ROUND(3-3*IF((MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6>=1,1,(MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6),4)","v":{"v":0,"d":"0.00000"}},{"$nulls":5},"滿半年有特休\n到職日期間"]
[null,null,"到職","特休",null,{"v":80,"d":"80年"},null,{"v":7,"d":"7月"},null,{"v":2,"d":"2日"},null,null,{"v":109,"d":"109年"},{"v":12,"d":"12月"},{"v":31,"d":"31日"},null,null,"按比例試算(四捨五入至小數第二位)",{"$nulls":7},"A+B+C",null,"天數整數化試算\n(四捨五入至整數)",{"$nulls":3},"滿半年(未滿一年期間)"]
[null,null,"年資","日數",null,"留職停薪天數",null,"到職日",null,"年資_年",null,null,"年資計算日期",{"$nulls":4},"得特休_X+C",null,"特休比例",null,"到職周年",null,"年度特休_X",null,"曆年年度",null,"到職日前_A",null,"到職日後_B",null,{"$f":"$M$2&\"年度\"","v":"109年度"},{"$f":"$M$2&\"年 1/1前 \"","v":"109年 1/1前 "},{"$f":"$M$2&\"年 1/1後\"","v":"109年 1/1後"},{"$f":"$M$2+1&\" 年前\"","v":"110 年前"},{"$f":"$M$2+1&\"   年後\"","v":"110   年後"},null,null,{"$f":"DATE($M$2+1911-1,1,1)","v":"2019-01-01"},{"$f":"DATE($M$2+1911,1,1)","v":"2020-01-01"}]
[null,null,0,0,{"$nulls":3},{"$f":"DATE(F2+1911,H2,J2)+F4","v":"1991-07-02"},null,{"$f":"IF(OR($H4=0,$H4>$M$4),0,DATEDIF($H4+$G4,$M$4+1,\"Y\"))","v":28},null,null,"2019-12-31",{"$nulls":4},{"$f":"X4+AF4","v":{"v":30,"d":"30.00"}},null,{"$f":"1-(MONTH(H4)-1+(DAY(H4)-1)/DAY(EOMONTH((H4-1),0)))/12","v":{"v":0.49731182795698925,"d":"0.497"}},null,{"$f":"IF($H4=0,0,DATEDIF($H4+$G4,DATE(M2+1911,MONTH(H4),DAY(H4)),\"Y\"))","v":29},null,{"$f":"IF(OR(V4=0,J4=0),0,ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4),特休表,2,0)*$T4,2))+IF(OR(V4=0,J4=0),0,VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)-ROUND(VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)*$T4,2))","v":{"v":30,"d":"30.00"}},null,{"$f":"IF(H4=0,0,AB4+AD4+AF4)","v":30},null,{"$f":"IF(V4=0,0,VLOOKUP(IF($V4>$J$5,$J$5,$V4-1),特休表,2,0)-ROUND(VLOOKUP(IF(($V4-1)>$J$5,$J$5,($V4-1)),特休表,2,0)*$T4,0))","v":15},null,{"$f":"ROUND(VLOOKUP(($V$4),特休表,2)*T4,0)","v":15},null,{"$f":"IF(AND(H4>=$AM$4,H4<=$AN$3),3,AH4+AI4)","v":0},{"$f":"IF(AH4=0,0,3-$AH$4)","v":0},{"$f":"IF(AND($H$4>$AM$3,$H$4<$AM$4),ROUND(3*(MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6,2),0)","v":0},{"$f":"IF(AND($H4>$AN$3,$H4<$AN$4),3-ROUND(3*(MONTH($H4)-1+(DAY($H4)-1)/DAY(EOMONTH(($H4-1),0)))/6,2),0)","v":0},{"$f":"IF($AI4=0,0,3-$AI4)","v":0},null,null,{"$f":"DATE($M$2+1911-1,7,1)","v":"2019-07-01"},{"$f":"DATE($M$2+1911,7,1)","v":"2020-07-01"}]
[null,null,0.5,3,{"$nulls":3},"特休最大年資",null,24,{"$nulls":9},{"$f":"\"=(1- (\"&MONTH(H4)-1&\"+\"&(DAY(H4)-1)&\"/\"&DAY(EOMONTH((H4-1),0))&\")\"&\"/12)\"","v":"=(1- (6+1/31)/12)"},{"$nulls":5},"以到職日後的比例為主計算特休天數<<四捨五入進位到整數"]
[null,null,1,7,{"$nulls":13},{"$f":"T4","v":{"v":0.49731182795698925,"d":"0.497"}},null,"為到職日至12/31的比例",{"$nulls":5},"到職日前的比例是滿周年天數減到職日後天數",{"$nulls":5},"滿半年比例=",{"$f":"\"(\"&MONTH(H4)-1&\"+\"&(DAY(H4)-1)&\"/\"&DAY(EOMONTH((H4-1),0))&\")\"&\"/6\"","v":"(6+1/31)/6"}]
[null,null,2,10,{"$nulls":27},"1/1至到職日比例=",{"$f":"(MONTH($H$4)-1+(DAY($H$4)-1)/DAY(EOMONTH(($H$4-1),0)))/6","v":{"v":1.0053763440860215,"d":"1.01"}}]
[null,null,3,14]
[null,null,4,14,null,null,{"$f":"DATE(YEAR(N10)-1,H2,J2)","v":"2019-07-02"},{"$nulls":4},{"$f":"DATE($M$2+1911-1,12,31)","v":"2019-12-31"},null,{"$f":"N10","v":"2020-01-01"},null,null,{"$f":"DATE(YEAR($G$12)+1,MONTH($H$4),DAY($H$4))-1","v":"2020-07-01"},null,{"$f":"DATE(YEAR(N10),H2,J2)","v":"2020-07-02"},{"$nulls":4},"年度末",null,"年度初",{"$nulls":3},{"$f":"DATE(YEAR(N10)+1,H2,J2)","v":"2021-07-02"}]
[null,null,5,15,null,null,"到職周年",null,"到職日後",null,null,"年度初",null,{"$f":"J12+1","v":"2020-01-01"},null,"到職日前",null,null,"到職周年",null,"到職日後",null,{"$f":"V12","v":"2020-12-31"},null,null,{"$f":"W10+1","v":"2021-01-01"},null,"到職日前",null,null,"到職周年"]
[null,null,6,15,null,null,{"$f":"IF(V4=0,0,V4-1)","v":28},"年",{"$nulls":4},{"$f":"IF(V4=0,0,VLOOKUP(($V$4-1),特休表,2))","v":30},"天",{"$nulls":4},{"$f":"V4","v":29},"年",{"$nulls":4},{"$f":"VLOOKUP(($V$4),特休表,2)","v":30},"天"]
[null,null,7,15,null,null,{"$f":"DATE($M$2+1911-1,MONTH($H$4),DAY($H$4))","v":"2019-07-02"},null,null,{"$f":"DATE($M$2+1911-1,12,31)","v":"2019-12-31"},{"$nulls":3},{"$f":"N10","v":"2020-01-01"},null,{"$f":"DATE(YEAR($G$12)+1,MONTH($H$4),DAY($H$4))-1","v":"2020-07-01"},null,null,{"$f":"P12+1","v":"2020-07-02"},null,null,{"$f":"DATE(YEAR($J$12)+1,12,31)","v":"2020-12-31"},{"$nulls":3},{"$f":"V12+1","v":"2021-01-01"},null,{"$f":"DATE(YEAR($G$12)+2,MONTH($H$4),DAY($H$4))-1","v":"2021-07-01"}]
[null,null,8,15,{"$nulls":4},"比例",{"$f":"$T$4","v":{"v":0.49731182795698925,"d":"0.497"}},{"$nulls":4},"比例",{"$f":"(1-$J$13)","v":{"v":0.5026881720430108,"d":"0.503"}},{"$nulls":4},"比例",{"$f":"$T$4","v":{"v":0.49731182795698925,"d":"0.497"}},{"$nulls":4},"比例",{"$f":"(1-$J$13)","v":{"v":0.5026881720430108,"d":"0.503"}}]
[null,null,9,15,{"$nulls":3},"特休",{"$f":"M11","v":30},"x",{"$f":"J13","v":{"v":0.49731182795698925,"d":"0.497"}},"=",{"$f":"I14*K14","v":{"v":14.919354838709678,"d":"14.919"}},null,"特休",{"$f":"M11","v":30},"-",{"$f":"K15","v":15},null,"特休",{"$f":"Y11","v":30},"x",{"$f":"V13","v":{"v":0.49731182795698925,"d":"0.497"}},"=",{"$f":"U14*W14","v":{"v":14.919354838709678,"d":"14.919"}},null,"特休",{"$f":"Y11","v":30},"-",{"$f":"W15","v":15}]
[null,null,10,16,null,null,"(四捨五入至整數)",null,null,"=",{"$f":"ROUND(I14*K14,0)","v":15},{"$nulls":3},"=",{"$f":"M11-K15","v":15},null,null,"(四捨五入至整數)",null,null,"=",{"$f":"ROUND(U14*W14,0)","v":15},{"$nulls":3},"=",{"$f":"AB14-AD14","v":15}]
[null,null,11,17,{"$nulls":5},"(四捨五入至整數)",{"$nulls":6},"=",{"$f":"P15","v":15},"+",{"$f":"W15","v":15},"=",{"$f":"P15+W15","v":30},null,"天"]
[null,null,12,18,{"$nulls":5},"使其為整數",{"$nulls":3},{"$f":"N10","v":"2020-01-01"},null,null,"曆年制年度特休天數",{"$nulls":5},{"$f":"W10","v":"2020-12-31"}]
[null,null,13,19,null,null,"◎上述試算程式未計算滿半年3天的部分"]
[null,null,14,20]
[null,null,15,21,{"$nulls":5},{"$f":"I$27","v":107},{"$nulls":3},{"$f":"M27","v":108},{"$nulls":3},{"$f":"Q27","v":109},{"$nulls":3},{"$f":"U27","v":110},{"$nulls":3},{"$f":"Y27","v":111},{"$nulls":3},{"$f":"AC27","v":112}]
[null,null,16,22,null,"到職日",null,{"$f":"$H$4","v":"1991-07-02"},null,{"$f":"K21-1","v":"2018-07-01"},{"$f":"DATE(I27+1911,$H$2,$J$2)","v":"2018-07-02"},null,null,{"$f":"O21-1","v":"2019-07-01"},{"$f":"DATE(M27+1911,$H$2,$J$2)","v":"2019-07-02"},null,null,{"$f":"S21-1","v":"2020-07-01"},{"$f":"DATE(Q27+1911,$H$2,$J$2)","v":"2020-07-02"},null,null,{"$f":"W21-1","v":"2021-07-01"},{"$f":"DATE(U27+1911,$H$2,$J$2)","v":"2021-07-02"},null,null,{"$f":"AA21-1","v":"2022-07-01"},{"$f":"DATE(Y27+1911,$H$2,$J$2)","v":"2022-07-02"},null,null,{"$f":"AE21-1","v":"2023-07-01"},{"$f":"DATE(AC27+1911,$H$2,$J$2)","v":"2023-07-02"}]
[null,null,17,23,null,"周年制年度",null,null,{"$f":"IF((K22-1)<0,0,K22-1)","v":{"v":26,"d":"滿26周年期間"}},null,{"$f":"I27-(YEAR($H$4)-1911)","v":{"v":27,"d":"滿27周年期間"}},{"$nulls":3},{"$f":"M27-(YEAR($H$4)-1911)","v":{"v":28,"d":"滿28周年期間"}},{"$nulls":3},{"$f":"Q27-(YEAR($H$4)-1911)","v":{"v":29,"d":"滿29周年期間"}},{"$nulls":3},{"$f":"U27-(YEAR($H$4)-1911)","v":{"v":30,"d":"滿30周年期間"}},{"$nulls":3},{"$f":"Y27-(YEAR($H$4)-1911)","v":{"v":31,"d":"滿31周年期間"}},{"$nulls":3},{"$f":"AA22+1","v":{"v":32,"d":"滿32周年期間"}}]
[null,null,18,24,null,"周年制天數",null,null,{"$f":"IF(ISNA(VLOOKUP((K$22-1),特休表,2,0)),0,VLOOKUP((K$22-1),特休表,2,0))","v":30},null,{"$f":"IF(ISNA(VLOOKUP(K$22,特休表,2,0)),0,VLOOKUP(K$22,特休表,2,0))","v":30},{"$nulls":3},{"$f":"IF(ISNA(VLOOKUP(O$22,特休表,2,0)),0,VLOOKUP(O$22,特休表,2,0))","v":30},{"$nulls":3},{"$f":"VLOOKUP(S$22,特休表,2,0)","v":30},{"$nulls":3},{"$f":"VLOOKUP(W$22,特休表,2,0)","v":30},{"$nulls":3},{"$f":"VLOOKUP(AA$22,特休表,2,0)","v":30},{"$nulls":3},{"$f":"VLOOKUP((AA22+1),特休表,2,0)","v":30}]
[null,null,19,25,null,null,"日期",null,{"$f":"DATE(I27+1911,1,1)","v":"2018-01-01"},{"$f":"J21","v":"2018-07-01"},{"$f":"K21","v":"2018-07-02"},{"$f":"DATE(I27+1911,12,31)","v":"2018-12-31"},{"$f":"DATE(M27+1911,1,1)","v":"2019-01-01"},{"$f":"N21","v":"2019-07-01"},{"$f":"O21","v":"2019-07-02"},{"$f":"DATE(M27+1911,12,31)","v":"2019-12-31"},{"$f":"DATE(Q27+1911,1,1)","v":"2020-01-01"},{"$f":"R21","v":"2020-07-01"},{"$f":"S21","v":"2020-07-02"},{"$f":"DATE(Q27+1911,12,31)","v":"2020-12-31"},{"$f":"DATE(U27+1911,1,1)","v":"2021-01-01"},{"$f":"V21","v":"2021-07-01"},{"$f":"W21","v":"2021-07-02"},{"$f":"DATE(U27+1911,12,31)","v":"2021-12-31"},{"$f":"DATE(Y27+1911,1,1)","v":"2022-01-01"},{"$f":"Z21","v":"2022-07-01"},{"$f":"AA21","v":"2022-07-02"},{"$f":"DATE(Y27+1911,12,31)","v":"2022-12-31"},{"$f":"DATE(AC27+1911,1,1)","v":"2023-01-01"},{"$f":"AD21","v":"2023-07-01"},{"$f":"AE21","v":"2023-07-02"},{"$f":"DATE(AC27+1911,12,31)","v":"2023-12-31"}]
[null,null,20,26,{"$nulls":3},"比例",{"$f":"1-$T$4","v":{"v":0.5026881720430108,"d":"0.503"}},null,{"$f":"$T$4","v":{"v":0.49731182795698925,"d":"0.497"}},null,{"$f":"1-$T$4","v":{"v":0.5026881720430108,"d":"0.503"}},null,{"$f":"$T$4","v":{"v":0.49731182795698925,"d":"0.497"}},null,{"$f":"1-$T$4","v":{"v":0.5026881720430108,"d":"0.503"}},null,{"$f":"$T$4","v":{"v":0.49731182795698925,"d":"0.497"}},null,{"$f":"1-$T$4","v":{"v":0.5026881720430108,"d":"0.503"}},null,{"$f":"$T$4","v":{"v":0.49731182795698925,"d":"0.497"}},null,{"$f":"1-$T$4","v":{"v":0.5026881720430108,"d":"0.503"}},null,{"$f":"$T$4","v":{"v":0.49731182795698925,"d":"0.497"}},null,{"$f":"1-$T$4","v":{"v":0.5026881720430108,"d":"0.503"}},null,{"$f":"$T$4","v":{"v":0.49731182795698925,"d":"0.497"}}]
[null,null,21,27,null,"曆年制比例天數",null,null,{"$f":"IF(ISNA(I23-ROUND(I23*(1-I25),0)),0,I23-ROUND(I23*(1-I25),0))","v":15},null,{"$f":"IF(ISNA(ROUND(K23*K25,0)),0,ROUND(K23*K25,0))","v":15},null,{"$f":"K23-K26","v":15},null,{"$f":"ROUND(O23*O25,0)","v":15},null,{"$f":"O23-O26","v":15},null,{"$f":"ROUND(S23*S25,0)","v":15},null,{"$f":"S23-S26","v":15},null,{"$f":"ROUND(W23*W25,0)","v":15},null,{"$f":"W23-W26","v":15},null,{"$f":"ROUND(AA23*AA25,0)","v":15},null,{"$f":"AA23-AA26","v":15},null,{"$f":"ROUND(AE23*AE25,0)","v":15}]
[null,null,22,28,null,null,"曆年制年度",null,{"$f":"M2-2","v":107},{"$nulls":3},{"$f":"I27+1","v":108},{"$nulls":3},{"$f":"M27+1","v":109},{"$nulls":3},{"$f":"Q27+1","v":110},{"$nulls":3},{"$f":"U27+1","v":111},{"$nulls":3},{"$f":"Y27+1","v":112}]
[null,null,23,29,null,"曆年制天數",null,null,{"$f":"I26+K26","v":30},{"$nulls":3},{"$f":"M26+O26","v":30},{"$nulls":3},{"$f":"Q26+S26","v":30},{"$nulls":3},{"$f":"U26+W26","v":30},{"$nulls":3},{"$f":"Y26+AA26","v":30},{"$nulls":3},{"$f":"AC26+AE26","v":30}]
[null,null,24,30,null,"曆年制年度",null,null,{"$f":"I27-$F$2","v":27},{"$nulls":3},{"$f":"M27-$F$2","v":28},{"$nulls":3},{"$f":"Q27-$F$2","v":29},{"$nulls":3},{"$f":"U27-$F$2","v":30},{"$nulls":3},{"$f":"Y27-$F$2","v":31},{"$nulls":3},{"$f":"AC27-$F$2","v":32}]
[null,null,25,30,{"$nulls":4},"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後",null,"到職日前",null,"到職日後"]
[{"$nulls":10},"(四捨五入至整數)",{"$nulls":3},{"$f":"$K$31","v":"(四捨五入至整數)"},{"$nulls":3},{"$f":"$K$31","v":"(四捨五入至整數)"},{"$nulls":3},{"$f":"$K$31","v":"(四捨五入至整數)"},{"$nulls":3},{"$f":"$K$31","v":"(四捨五入至整數)"},{"$nulls":3},{"$f":"$K$31","v":"(四捨五入至整數)"}]

{"sheet":"員工資料整理區","index":7,"n_rows":24,"n_cols":9,"rows_kept":24}
[]
[null,"員工編號","姓名","性別","公司","部門","職稱","留職停薪","到職日"]
[null,"NO01","姓名01",null,"碩銘","管理部",null,null,"2002-04-01"]
[null,"NO02","姓名02",null,"碩銘","管理部",null,null,"2004-09-07"]
[null,"NO03","姓名03",null,"碩銘","管理部",null,null,"2007-08-16"]
[null,"NO04","姓名04",null,"碩銘","管理部",null,null,"2013-07-01"]
[null,"NO05","姓名05",null,"碩銘","管理部",null,null,"2018-04-16"]
[null,"NO06","姓名06",null,"碩銘","管理部",null,null,"2019-09-16"]
[null,"NO07","姓名07",null,"碩銘","廠務",null,null,"2001-09-01"]
[null,"NO08","姓名08",null,"碩銘","廠務",null,null,"2001-09-01"]
[null,"NO09","姓名09",null,"碩銘","廠務",null,null,"2015-11-02"]
[null,"NO10","姓名10",null,"碩銘","廠務",null,null,"2016-08-15"]
[null,"NO11","姓名11",null,"碩銘","廠務",null,null,"2017-12-04"]
[null,"NO12","姓名12",null,"碩銘","廠務",null,null,"2006-06-20"]
[null,"NO13","姓名13",null,"碩銘","製造部",null,null,"2009-10-29"]
[null,"NO14","姓名14",null,"碩銘","製造部",null,null,"2019-09-16"]
[null,"NO15","姓名15",null,"碩銘","製造部",null,null,"2018-03-01"]
[null,"NO16","姓名16",null,"碩銘","製造部",null,null,"2018-05-14"]
[null,"NO17","姓名17",null,"碩銘","製造部",null,null,"2018-07-15"]
[null,"NO18","姓名18",null,"碩銘","製造部",null,null,"2019-03-05"]
[null,"NO19","姓名19",null,"碩銘","製造部",null,null,"2019-04-15"]
[null,"NO20","姓名20",null,"碩銘","製造部",null,null,"2020-01-06"]
[null,"NO21","姓名21",null,"碩銘","製造部",null,null,"2020-04-17"]
[null,"NO22","姓名22",null,"碩銘","製造部",null,null,"2020-06-18"]

{"sheet":"特休試算","index":8,"n_rows":59,"n_cols":36,"rows_kept":59,"merged":[[1,16,1,17],[4,14,4,15],[6,11,6,13],[7,0,7,3],[7,5,7,9],[7,14,7,15],[7,16,7,17],[7,26,8,26],[7,27,8,31],[8,0,8,3],[8,14,8,15],[8,16,9,16],[8,17,9,17],[8,18,8,21],[8,22,8,25],[9,34,9,35]]}
[{"$nulls":19},2,13,15]
[{"$nulls":11},"留職停薪",null,"到職日","到職周年","年資特休","特休比例",null,"滿半年","到職日前","到職日後","年度天數",null,"到職日前","到職日後","年度天數","輸入",{"$f":"$L$9&\"年度\"","v":"109年度"},{"$f":"\"年 1/1前 \"","v":"年 1/1前 "},{"$f":"\"年度 1/1後\"","v":"年度 1/1後"},{"$f":"$L$9+1&\"年度前\"","v":"110年度前"},{"$f":"$L$9+1&\"年度後\"","v":"110年度後"}]
[{"$nulls":12},"2020-03-20",{"$f":"M3+L3","v":"2020-03-20"},{"$f":"IF($N3=0,0,DATEDIF($N3+$L3,DATE($L$9+1911,MONTH(N3),DAY(N3))+$L3,\"Y\"))","v":0},{"$f":"IF(O3>24,30,VLOOKUP($O3,特休,2,0))","v":0},{"$f":"1-(MONTH(N3)-1+(DAY(N3)-1)/DAY(EOMONTH((N3-1),0)))/12","v":{"v":0.782258064516129,"d":"0.78"}},{"$f":"1-Q3","v":{"v":0.217741935483871,"d":"0.22"}},{"$f":"AB3","v":1.69},{"$f":"IF(O3=0,0,VLOOKUP(IF($O3>$N$5,$N$5,$O3-1),特休,2,0)-ROUNDUP(VLOOKUP(IF(($O3-1)>$N$5,$N$5,($O3-1)),特休,2,0)*$Q3,0))","v":0},{"$f":"ROUNDUP(IF($O3=0,0,VLOOKUP(IF($O3>$N$5,$N$5,$O3),特休,2,0)*$Q3),0)","v":0},{"$f":"$S3+$T3+$U3+$AA3","v":1.69},{"$f":"$AB3","v":1.69},{"$f":"IF(ISNA(VLOOKUP(IF($O3>$N$5,$N$5,$O3-1),特休,2,0)*(1-$Q3)),0,ROUND(VLOOKUP(IF($O3>$N$5,$N$5,$O3-1),特休,2,0)*(1-$Q3),2))","v":{"v":0,"d":"0.00"}},{"$f":"IF(ISNA(VLOOKUP(IF($O3>$N$5,$N$5,$O3),特休,2,0)*(1-$Q3)),0,VLOOKUP(IF($O3>$N$5,$N$5,$O3),特休,2,0)-ROUND(VLOOKUP(IF($O3>$N$5,$N$5,$O3),特休,2,0)*(1-$Q3),2))","v":{"v":0,"d":"0.00"}},{"$f":"$W3+$X3+$Y3+$AA3","v":1.69},null,{"$f":"IF(AND($N3>=$AI$12,$N3<=$AJ$11),3,AD3+AE3)","v":1.69},{"$f":"IF(AD3=0,0,3-AD3)","v":0},{"$f":"IF(AND($N3>$AI$11,$N3<$AI$12),ROUND(3*(MONTH($N3)-1+(DAY($N3)-1)/DAY(EOMONTH(($N3-1),0)))/6,2),0)","v":0},{"$f":"IF(AND($N3>$AJ$11,$N3<$AJ$12),3-ROUND(3*(MONTH($N3)-1+(DAY($N3)-1)/DAY(EOMONTH(($N3-1),0)))/6,2),0)","v":1.69},{"$f":"IF($AE3=0,0,3-$AE3)","v":1.31}]
[]
[{"$nulls":13},{"v":24,"d":"24.00"},"特休最大年資",{"$nulls":9},{"$f":"ROUNDUP((7 + 1/31 )/12 * 7,1)","v":4.199999999999999},{"$f":" (10 -ROUNDUP( (7 + 1/31 )/12 * 10,1))","v":4.1000000000000005}]
[]
["本試算程式版權屬於李金國顧問所有，歡迎轉載使用，但轉載時請註明出處",{"$nulls":10},"輸入試算年度",{"$nulls":8},"留停日數試算","開始日期","2001-06-01","結束日期","2001-07-31","留停天數",{"$f":"IF(OR(W7=0,Y7=0),0,Y7-W7+1)","v":61},"<<輸入日期試算留停天數"]
["如優於勞基法,輸入優於法規",{"$nulls":4},"https://www.gisin.com.tw/",{"$nulls":4},"試算日期","年","月","日","<<輸入試算年度",null,"特休比例",{"$nulls":9},"輸入後再按試算鈕","滿半年(未滿一年期間)"]
["的天數於 [增加] 欄位",{"$nulls":10},109,12,31,"周年制",null,"到職日\n至\n12/31","1/1至\n到職日\n前一日\n","曆年制試算(【到職日後】強制進位至整數)",{"$nulls":3},"曆年制試算_原始比例"]
["法定","到職","實際","增加",null,"員工編號","姓名","性別","公司","部門","職稱","留職停薪","到職日","到職日\n(留職)","到職周年","年資特休",null,null,"滿半年\nA","到職日前\nB","到職日後\nC","年度天數\nA+B+C+D","滿半年\nA","到職日前\nB","到職日後\nC","年度天數\nA+B+C+D","遞延 或\n已結清\nD",{"$f":"$L$9&\"年度\"","v":"109年度"},{"$f":"$L$9&\"年度 1/1前\"","v":"109年度 1/1前"},{"$f":"$L$9&\"年度 1/1後\"","v":"109年度 1/1後"},{"$f":"\"到職日後\"&$L$9+1&\"年度前\"","v":"到職日後110年度前"},{"$f":"$L$9+1&\"年度 1/1後\"","v":"110年度 1/1後"},null,null,"滿半年有特休\n到職日期間"]
["日數","年資","日數","日數",null,"NO01","姓名01",null,"碩銘","管理部",null,null,"2002-04-01","2002-04-01",18,24,0.75,0.25,0,5,18,23,{"v":0,"d":"0.00"},5.75,{"v":18,"d":"18.00"},23.75,null,0,0,0,0,0,null,null,{"$f":"DATE($L$9+1911-1,1,1)","v":"2019-01-01"},{"$f":"DATE(L9+1911,1,1)","v":"2020-01-01"}]
[0,0,0,null,null,"NO02","姓名02",null,"碩銘","管理部",null,null,"2004-09-07","2004-09-07",16,22,{"v":0.31666666666666676,"d":"0.32"},{"v":0.6833333333333332,"d":"0.68"},0,14,7,21,{"v":0,"d":"0.00"},14.35,{"v":6.970000000000001,"d":"6.97"},21.32,null,0,0,0,0,0,null,null,{"$f":"DATE($L$9+1911-1,7,1)","v":"2019-07-01"},{"$f":"DATE(L9+1911,7,1)","v":"2020-07-01"}]
[3,0.5,{"$f":"$A13+$D13","v":3},null,null,"NO03","姓名03",null,"碩銘","管理部",null,null,"2007-08-16","2007-08-16",13,19,{"v":0.3763440860215054,"d":"0.38"},{"v":0.6236559139784946,"d":"0.62"},0,11,8,19,{"v":0,"d":"0.00"},11.23,7.15,{"v":18.380000000000003,"d":"18.38"},null,0,0,0,0,0,{"$f":"IF(AND($N13>$AJ$11,$N13<$AJ$12),3-3*(MONTH($N13)-1+(DAY($N13)-1)/DAY(EOMONTH(($N13-1),0)))/6,0)","v":0}]
[7,1,{"$f":"$A14+$D14","v":7},null,null,"NO04","姓名04",null,"碩銘","管理部",null,null,"2013-07-01","2013-07-01",7,15,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},0,7,8,15,{"v":0,"d":"0.00"},{"v":7.5,"d":"7.50"},{"v":7.5,"d":"7.50"},{"v":15,"d":"15.00"},null,0,0,0,0,0]
[10,2,10,null,null,"NO05","姓名05",null,"碩銘","管理部",null,null,"2018-04-16","2018-04-16",2,10,{"v":0.7083333333333333,"d":"0.71"},{"v":0.29166666666666674,"d":"0.29"},0,2,8,10,{"v":0,"d":"0.00"},2.04,7.08,{"v":9.120000000000001,"d":"9.12"},null,0,0,0,0,0]
[14,3,14,null,null,"NO06","姓名06",null,"碩銘","管理部",null,null,"2019-09-16","2019-09-16",1,7,{"v":0.29166666666666663,"d":"0.29"},{"v":0.7083333333333334,"d":"0.71"},3,0,3,6,{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},2.04,5.04,null,3,0,0,0,0]
[14,4,14,null,null,"NO07","姓名07",null,"碩銘","廠務",null,null,"2001-09-01","2001-09-01",19,25,{"v":0.33333333333333337,"d":"0.33"},{"v":0.6666666666666666,"d":"0.67"},0,16,9,25,{"v":0,"d":"0.00"},{"v":16,"d":"16.00"},{"v":8.329999999999998,"d":"8.33"},24.33,null,0,0,0,0,0]
[15,5,15,null,null,"NO08","姓名08",null,"碩銘","廠務",null,null,"2001-09-01","2001-09-01",19,25,{"v":0.33333333333333337,"d":"0.33"},{"v":0.6666666666666666,"d":"0.67"},0,16,9,25,{"v":0,"d":"0.00"},{"v":16,"d":"16.00"},{"v":8.329999999999998,"d":"8.33"},24.33,null,0,0,0,0,0]
[15,6,15,null,null,"NO09","姓名09",null,"碩銘","廠務",null,null,"2015-11-02","2015-11-02",5,15,{"v":0.16388888888888886,"d":"0.16"},{"v":0.8361111111111111,"d":"0.84"},0,11,3,14,{"v":0,"d":"0.00"},11.71,{"v":2.460000000000001,"d":"2.46"},{"v":14.170000000000002,"d":"14.17"},null,0,0,0,0,0]
[15,7,15,null,null,"NO10","姓名10",null,"碩銘","廠務",null,null,"2016-08-15","2016-08-15",4,14,{"v":0.3790322580645161,"d":"0.38"},{"v":0.6209677419354839,"d":"0.62"},0,8,6,14,{"v":0,"d":"0.00"},8.69,{"v":5.3100000000000005,"d":"5.31"},{"v":14,"d":"14.00"},null,0,0,0,0,0]
[15,8,15,null,null,"NO11","姓名11",null,"碩銘","廠務",null,null,"2017-12-04","2017-12-04",3,14,{"v":0.07526881720430101,"d":"0.08"},{"v":0.924731182795699,"d":"0.92"},0,9,2,11,{"v":0,"d":"0.00"},9.25,{"v":1.0500000000000007,"d":"1.05"},{"v":10.3,"d":"10.30"},null,0,0,0,0,0]
[15,9,15,null,null,"NO12","姓名12",null,"碩銘","廠務",null,null,"2006-06-20","2006-06-20",14,20,{"v":0.5305555555555557,"d":"0.53"},{"v":0.46944444444444433,"d":"0.47"},0,8,11,19,{"v":0,"d":"0.00"},8.92,10.61,19.53,null,0,0,0,0,0]
[16,10,16,null,null,"NO13","姓名13",null,"碩銘","製造部",null,null,"2009-10-29","2009-10-29",11,17,{"v":0.174731182795699,"d":"0.17"},{"v":0.825268817204301,"d":"0.83"},0,13,3,16,{"v":0,"d":"0.00"},{"v":13.2,"d":"13.20"},{"v":2.9700000000000006,"d":"2.97"},16.17,null,0,0,0,0,0]
[17,11,17,null,null,"NO14","姓名14",null,"碩銘","製造部",null,null,"2019-09-16","2019-09-16",1,7,{"v":0.29166666666666663,"d":"0.29"},{"v":0.7083333333333334,"d":"0.71"},3,0,3,6,{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},2.04,5.04,null,3,0,0,0,0]
[18,12,18,null,null,"NO15","姓名15",null,"碩銘","製造部",null,null,"2018-03-01","2018-03-01",2,10,{"v":0.8333333333333334,"d":"0.83"},{"v":0.16666666666666663,"d":"0.17"},0,1,9,10,{"v":0,"d":"0.00"},1.17,8.33,{"v":9.5,"d":"9.50"},null,0,0,0,0,0]
[19,13,19,null,null,"NO16","姓名16",null,"碩銘","製造部",null,null,"2018-05-14","2018-05-14",2,10,{"v":0.631720430107527,"d":"0.63"},{"v":0.368279569892473,"d":"0.37"},0,2,7,9,{"v":0,"d":"0.00"},2.58,6.32,{"v":8.9,"d":"8.90"},null,0,0,0,0,0]
[20,14,20,null,null,"NO17","姓名17",null,"碩銘","製造部",null,null,"2018-07-15","2018-07-15",2,10,{"v":0.4623655913978495,"d":"0.46"},{"v":0.5376344086021505,"d":"0.54"},0,3,5,8,{"v":0,"d":"0.00"},3.76,4.62,{"v":8.379999999999999,"d":"8.38"},null,0,0,0,0,0]
[21,15,21,null,null,"NO18","姓名18",null,"碩銘","製造部",null,null,"2019-03-05","2019-03-05",1,7,{"v":0.8225806451612904,"d":"0.82"},{"v":0.17741935483870963,"d":"0.18"},1.06,0,6,7.0600000000000005,1.06,{"v":0,"d":"0.00"},5.76,6.82,null,1.06,1.94,1.06,0,0]
[22,16,22,null,null,"NO19","姓名19",null,"碩銘","製造部",null,null,"2019-04-15","2019-04-15",1,7,{"v":0.711111111111111,"d":"0.71"},{"v":0.288888888888889,"d":"0.29"},1.73,0,5,6.73,1.73,{"v":0,"d":"0.00"},4.98,{"v":6.710000000000001,"d":"6.71"},null,1.73,1.27,1.73,0,0]
[23,17,23,null,null,"NO20","姓名20",null,"碩銘","製造部",null,null,"2020-01-06","2020-01-06",0,0,{"v":0.9865591397849462,"d":"0.99"},{"v":0.013440860215053752,"d":"0.01"},2.92,0,0,2.92,2.92,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},2.92,null,2.92,0,0,2.92,0.08000000000000007]
[24,18,24,null,null,"NO21","姓名21",null,"碩銘","製造部",null,null,"2020-04-17","2020-04-17",0,0,{"v":0.7055555555555555,"d":"0.71"},{"v":0.2944444444444445,"d":"0.29"},1.23,0,0,1.23,1.23,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},1.23,null,1.23,0,0,1.23,1.77]
[25,19,25,null,null,"NO22","姓名22",null,"碩銘","製造部",null,null,"2020-06-18","2020-06-18",0,0,{"v":0.5361111111111112,"d":"0.54"},{"v":0.4638888888888888,"d":"0.46"},0.2200000000000002,0,0,0.2200000000000002,{"v":0.2200000000000002,"d":"0.22"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.2200000000000002,"d":"0.22"},null,0.2200000000000002,0,0,0.2200000000000002,2.78]
[26,20,26]
[27,21,27]
[28,22,28]
[29,23,29]
[30,24,30]
[30,25,30]
[30,26,30]
[30,27,30]
[30,28,30]
[30,29,30]
[30,30,30]
[30,31,30]
[30,32,30]
[30,33,30]
[30,34,30]
[30,35,30]
[30,36,30]
[30,37,30]
[30,38,30]
[30,39,30]
[30,40,30]
[30,41,30]
[30,42,30]
[30,43,30]
[30,44,30]
[30,45,30]
[30,46,30]

{"sheet":"統計表","index":9,"n_rows":61,"n_cols":28,"rows_kept":61,"merged":[[2,2,2,6],[2,11,2,12],[2,13,2,14],[2,23,3,23],[2,24,3,27],[3,11,3,12],[3,13,4,13],[3,14,4,14],[3,15,3,18],[3,19,3,22]]}
[]
[]
[null,null,"https://www.gisin.com.tw/",{"$nulls":4},"試算日期","年","月","日","<<輸入試算年度",null,"特休比例",{"$nulls":9},"輸入後再按試算鈕","滿半年(未滿一年期間)"]
[{"$nulls":8},108,12,31,"周年制",null,"到職日\n至\n12/31","1/1至\n到職日\n前一日\n","曆年制試算(【到職日後】四捨五入進位至整數)",{"$nulls":3},"曆年制試算_原始比例"]
[null,null,"員工編號","姓名","性別","公司","部門","職稱","留職停薪","到職日","到職日\n(留職)","到職周年","年資特休",null,null,"滿半年\nA","到職日前\nB","到職日後\nC","年度天數\nA+B+C+D","滿半年\nA","到職日前\nB","到職日後\nC","年度天數\nA+B+C+D","遞延 或\n已結清\nD","108年度","年度 1/1前 ","108年度 1/1後","到職日後109年度前"]
[null,null,"B0001","黃炳銘",{"$nulls":3},"董事長",null,"2012-05-01","2012-05-01",7,15,{"v":0.6666666666666667,"d":"0.67"},{"v":0.33333333333333326,"d":"0.33"},0,5,10,15,{"v":0,"d":"0.00"},{"v":5,"d":"5.00"},{"v":10,"d":"10.00"},{"v":15,"d":"15.00"},0,0,0,3,0]
[null,null,"B0002","邱見鴻",{"$nulls":3},"總經理",null,"2012-05-01","2012-05-01",7,15,{"v":0.6666666666666667,"d":"0.67"},{"v":0.33333333333333326,"d":"0.33"},0,5,10,15,{"v":0,"d":"0.00"},{"v":5,"d":"5.00"},{"v":10,"d":"10.00"},{"v":15,"d":"15.00"},0,0,0,3,0]
[null,null,"B0003","李世偉",{"$nulls":3},"協理",null,"2012-05-01","2012-05-01",7,15,{"v":0.6666666666666667,"d":"0.67"},{"v":0.33333333333333326,"d":"0.33"},0,5,10,15,{"v":0,"d":"0.00"},{"v":5,"d":"5.00"},{"v":10,"d":"10.00"},{"v":15,"d":"15.00"},null,0,0,3,0]
[null,null,"B0004","曹曼健",{"$nulls":3},"協理",null,"2012-05-01","2012-05-01",7,15,{"v":0.6666666666666667,"d":"0.67"},{"v":0.33333333333333326,"d":"0.33"},0,5,10,15,{"v":0,"d":"0.00"},{"v":5,"d":"5.00"},{"v":10,"d":"10.00"},{"v":15,"d":"15.00"},null,0,0,3,0]
[null,null,"B0005","葉宜君",{"$nulls":3},"副理",null,"2012-06-30","2012-06-30",7,15,{"v":0.5027777777777778,"d":"0.50"},{"v":0.49722222222222223,"d":"0.50"},0,7,8,15,{"v":0,"d":"0.00"},7.46,7.54,{"v":15,"d":"15.00"},null,0,0,3,0]
[null,null,"B0006","陳毅明",{"$nulls":3},"處長",null,"2012-12-01","2012-12-01",7,15,{"v":0.08333333333333337,"d":"0.08"},{"v":0.9166666666666666,"d":"0.92"},0,14,1,15,{"v":0,"d":"0.00"},13.75,1.25,{"v":15,"d":"15.00"},null,0,0,3,0]
[null,null,"B0007","余聖宏",{"$nulls":3},"副理",null,"2012-12-24","2012-12-24",7,15,{"v":0.021505376344086002,"d":"0.02"},{"v":0.978494623655914,"d":"0.98"},0,15,0,15,{"v":0,"d":"0.00"},14.68,{"v":0.3200000000000003,"d":"0.32"},{"v":15,"d":"15.00"},null,0,0,3,0]
[null,null,"B0015","劉俊賢",{"$nulls":3},"主任",null,"2012-12-17","2012-12-17",7,15,{"v":0.040322580645161366,"d":"0.04"},{"v":0.9596774193548386,"d":"0.96"},0,14,1,15,{"v":0,"d":"0.00"},{"v":14.4,"d":"14.40"},{"v":0.5999999999999996,"d":"0.60"},{"v":15,"d":"15.00"},null,0,0,3,0]
[null,null,"B0017","梁定康",{"$nulls":3},"經理",null,"2013-01-10","2013-01-10",6,15,{"v":0.9758064516129032,"d":"0.98"},{"v":0.024193548387096753,"d":"0.02"},0,0,15,15,{"v":0,"d":"0.00"},0.36,14.64,{"v":15,"d":"15.00"},null,0,0,3,0]
[null,null,"b0019","陳雅婷",{"$nulls":3},"財務部 主任",null,"2013-01-05","2013-01-05",6,15,{"v":0.989247311827957,"d":"0.99"},{"v":0.010752688172043001,"d":"0.01"},0,0,15,15,{"v":0,"d":"0.00"},0.16,14.84,{"v":15,"d":"15.00"},null,0,0,3,0]
[null,null,"B0021","朱博文",{"$nulls":3},"工務部 主任",null,"2013-02-18","2013-02-18",6,15,{"v":0.8660714285714286,"d":"0.87"},{"v":0.1339285714285714,"d":"0.13"},0,2,13,15,{"v":0,"d":"0.00"},2.01,12.99,{"v":15,"d":"15.00"},null,0,0,3,0]
[null,null,"B0029","徐坤鈺",{"$nulls":3},"處長",null,"2013-06-01","2013-06-01",6,15,{"v":0.5833333333333333,"d":"0.58"},{"v":0.41666666666666674,"d":"0.42"},0,6,9,15,{"v":0,"d":"0.00"},6.25,8.75,{"v":15,"d":"15.00"},null,0,0,3,0]
[null,null,"B0063","賴俊豪",{"$nulls":3},"機電部 主任",null,"2014-08-13","2014-08-13",5,15,{"v":0.3844086021505376,"d":"0.38"},{"v":0.6155913978494624,"d":"0.62"},0,9,6,15,{"v":0,"d":"0.00"},8.62,5.77,{"v":14.389999999999999,"d":"14.39"},null,0,0,3,0]
[null,null,"B0065","吳泓毅",{"$nulls":3},"主任",null,"2014-08-18","2014-08-18",5,15,{"v":0.3709677419354839,"d":"0.37"},{"v":0.6290322580645161,"d":"0.63"},0,9,6,15,{"v":0,"d":"0.00"},8.81,{"v":5.5600000000000005,"d":"5.56"},{"v":14.370000000000001,"d":"14.37"},null,0,0,3,0]
[null,null,"B0071","洪勢雄",{"$nulls":3},"主任",null,"2015-05-04","2015-05-04",4,14,{"v":0.6586021505376345,"d":"0.66"},{"v":0.3413978494623655,"d":"0.34"},0,5,9,14,{"v":0,"d":"0.00"},4.78,{"v":9.219999999999999,"d":"9.22"},{"v":14,"d":"14.00"},null,0,0,3,0]
[null,null,"B0076","鄭育閔",{"$nulls":3},"代主任",null,"2015-08-01","2015-08-01",4,14,{"v":0.41666666666666663,"d":"0.42"},{"v":0.5833333333333334,"d":"0.58"},0,8,6,14,{"v":0,"d":"0.00"},8.17,5.83,{"v":14,"d":"14.00"},null,0,0,3,0]
[null,null,"B0093","王雅儀",{"$nulls":3},"工務部 採發科 主任",null,"2016-07-04","2016-07-04",3,14,{"v":0.49193548387096775,"d":"0.49"},{"v":0.5080645161290323,"d":"0.51"},0,5,7,12,{"v":0,"d":"0.00"},5.08,6.89,{"v":11.969999999999999,"d":"11.97"},null,0,0,3,0]
[null,null,"B0096","賴進龍",{"$nulls":3},"機電部 代主任",null,"2016-09-01","2016-09-01",3,14,{"v":0.33333333333333337,"d":"0.33"},{"v":0.6666666666666666,"d":"0.67"},0,7,5,12,{"v":0,"d":"0.00"},6.67,4.67,11.34,null,0,0,3,0]
[null,null,"B0098","周祐全",{"$nulls":3},"副工程師",null,"2016-10-26","2016-10-26",3,14,{"v":0.18279569892473113,"d":"0.18"},{"v":0.8172043010752689,"d":"0.82"},0,8,3,11,{"v":0,"d":"0.00"},8.17,{"v":2.5600000000000005,"d":"2.56"},10.73,null,0,0,3,0]
[null,null,"B0106","吳振宇",{"$nulls":3},"副工程師",null,"2017-02-16","2017-02-16",2,10,{"v":0.8720238095238095,"d":"0.87"},{"v":0.12797619047619047,"d":"0.13"},0,1,9,10,{"v":0,"d":"0.00"},{"v":0.9,"d":"0.90"},8.72,{"v":9.620000000000001,"d":"9.62"},null,0,0,3,0]
[null,null,"B0109","林貝怡",{"$nulls":3},"管理部 二等專員",null,"2017-03-27","2017-03-27",2,10,{"v":0.7634408602150538,"d":"0.76"},{"v":0.23655913978494625,"d":"0.24"},0,2,8,10,{"v":0,"d":"0.00"},1.66,7.63,9.29,null,0,0,3,0]
[null,null,"B0113","陳和檍",{"$nulls":3},"機電部 規劃科代主任",null,"2017-07-03","2017-07-03",2,10,{"v":0.4946236559139785,"d":"0.49"},{"v":0.5053763440860215,"d":"0.51"},0,4,5,9,{"v":0,"d":"0.00"},3.54,4.95,8.49,null,0,0,3,0]
[null,null,"B0115","鄭雅云",{"$nulls":3},"工管科 二等專員",null,"2017-07-03","2017-07-03",2,10,{"v":0.4946236559139785,"d":"0.49"},{"v":0.5053763440860215,"d":"0.51"},0,4,5,9,{"v":0,"d":"0.00"},3.54,4.95,8.49,null,0,0,3,0]
[null,null,"B0116","李柏陞",{"$nulls":3},"助理工程師",null,"2017-08-15","2017-08-15",2,10,{"v":0.3790322580645161,"d":"0.38"},{"v":0.6209677419354839,"d":"0.62"},0,4,4,8,{"v":0,"d":"0.00"},4.35,3.79,8.14,null,0,0,3,0]
[null,null,"B0119","鍾岳霖",{"$nulls":3},"副工程師",null,"2017-11-01","2017-11-01",2,10,{"v":0.16666666666666663,"d":"0.17"},{"v":0.8333333333333334,"d":"0.83"},0,6,2,8,{"v":0,"d":"0.00"},5.83,1.67,{"v":7.5,"d":"7.50"},null,0,0,3,0]
[null,null,"B0132","林子揚",{"$nulls":3},"助理工程師",null,"2018-08-13","2018-08-13",1,7,{"v":0.3844086021505376,"d":"0.38"},{"v":0.6155913978494624,"d":"0.62"},3,0,3,6,{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":2.6900000000000004,"d":"2.69"},5.69,null,3,0,3,0]
[null,null,"B0137","顏睿呈",{"$nulls":3},"助理工程師",null,"2018-10-24","2018-10-24",1,7,{"v":0.18817204301075263,"d":"0.19"},{"v":0.8118279569892474,"d":"0.81"},3,0,1,4,{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":1.3200000000000003,"d":"1.32"},4.32,null,3,0,3,0]
[null,null,"B0139","呂婉萍",{"$nulls":3},"管理部 一等專員",null,"2018-11-19","2018-11-19",1,7,{"v":0.1166666666666667,"d":"0.12"},{"v":0.8833333333333333,"d":"0.88"},3,0,1,4,{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":0.8200000000000003,"d":"0.82"},{"v":3.8200000000000003,"d":"3.82"},null,3,0,3,0]
[null,null,"B0140","黃意云",{"$nulls":3},"機電部 一等專員",null,"2018-11-19","2018-11-19",1,7,{"v":0.1166666666666667,"d":"0.12"},{"v":0.8833333333333333,"d":"0.88"},3,0,1,4,{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":0.8200000000000003,"d":"0.82"},{"v":3.8200000000000003,"d":"3.82"},null,3,0,3,0]
[null,null,"B0149","謝明翰",{"$nulls":3},"助理工程師",null,"2019-03-25","2019-03-25",0,0,{"v":0.7688172043010753,"d":"0.77"},{"v":0.23118279569892475,"d":"0.23"},1.6,0,0,1.6,{"v":1.6,"d":"1.60"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1.6,"d":"1.60"},null,1.6,0,3,1.6]
[null,null,"B0152","黃祺佑",{"$nulls":3},"助理工程師",null,"2019-04-02","2019-04-02",0,0,{"v":0.7472222222222222,"d":"0.75"},{"v":0.25277777777777777,"d":"0.25"},1.5,0,0,1.5,{"v":1.5,"d":"1.50"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1.5,"d":"1.50"},null,1.5,0,3,1.5]
[null,null,"B0153","金瑞傑",{"$nulls":3},"助理工程師",null,"2019-04-01","2019-04-01",0,0,0.75,0.25,1.5,0,0,1.5,{"v":1.5,"d":"1.50"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":1.5,"d":"1.50"},null,1.5,0,3,1.5]
[null,null,"B0158","李奕霖",{"$nulls":3},"機電部 助理工程師",null,"2019-05-16","2019-05-16",0,0,{"v":0.6263440860215053,"d":"0.63"},{"v":0.37365591397849474,"d":"0.37"},0.8,0,0,0.8,{"v":0.8,"d":"0.80"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.8,"d":"0.80"},null,0.8,0,3,0.8]
[null,null,"B0160","羅殷御",{"$nulls":3},"副工程師",null,"2019-06-24","2019-06-24",0,0,{"v":0.5194444444444444,"d":"0.52"},{"v":0.4805555555555556,"d":"0.48"},0.1,0,0,0.1,{"v":0.1,"d":"0.10"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.1,"d":"0.10"},null,0.1,0,3,0.1]
[null,null,"B0162","陳怡頻",{"$nulls":3},"財務部 一等專員",null,"2019-07-01","2019-07-01",0,0,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0164","戴芷沂",{"$nulls":3},"財務部 一等專員",null,"2019-07-01","2019-07-01",0,0,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0165","李和霖",{"$nulls":3},"助理工程師",null,"2019-08-01","2019-08-01",0,0,{"v":0.41666666666666663,"d":"0.42"},{"v":0.5833333333333334,"d":"0.58"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0167","蔡承佑",{"$nulls":3},"機電部 助理工程師",null,"2019-08-01","2019-08-01",0,0,{"v":0.41666666666666663,"d":"0.42"},{"v":0.5833333333333334,"d":"0.58"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0170","吳俊男",{"$nulls":3},"襄理",null,"2019-08-15","2019-08-15",0,0,{"v":0.3790322580645161,"d":"0.38"},{"v":0.6209677419354839,"d":"0.62"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0171","王建智",{"$nulls":3},"信然-執行長",null,"2019-08-15","2019-08-15",0,0,{"v":0.3790322580645161,"d":"0.38"},{"v":0.6209677419354839,"d":"0.62"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0172","沈晉峰",{"$nulls":3},"信然-工務助理",null,"2019-08-15","2019-08-15",0,0,{"v":0.3790322580645161,"d":"0.38"},{"v":0.6209677419354839,"d":"0.62"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0173","林育薇",{"$nulls":3},"助理工程師",null,"2019-08-26","2019-08-26",0,0,{"v":0.34946236559139787,"d":"0.35"},{"v":0.6505376344086021,"d":"0.65"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0174","邢育寧",{"$nulls":3},"安衛助理工程師",null,"2019-09-02","2019-09-02",0,0,{"v":0.3305555555555556,"d":"0.33"},{"v":0.6694444444444444,"d":"0.67"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0175","朱峮佩",{"$nulls":3},"工務部 工管科 一等專員",null,"2019-09-06","2019-09-06",0,0,{"v":0.31944444444444453,"d":"0.32"},{"v":0.6805555555555555,"d":"0.68"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0008","蘇信宏",{"$nulls":3},"副理",null,"2019-09-16","2019-09-16",0,0,{"v":0.29166666666666663,"d":"0.29"},{"v":0.7083333333333334,"d":"0.71"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0178","范竣翔",{"$nulls":3},"助理工程師",null,"2019-09-23","2019-09-23",0,0,{"v":0.27222222222222225,"d":"0.27"},{"v":0.7277777777777777,"d":"0.73"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0179","劉淑玲",{"$nulls":3},"管理部 一等專員",null,"2019-09-25","2019-09-25",0,0,{"v":0.2666666666666666,"d":"0.27"},{"v":0.7333333333333334,"d":"0.73"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0180","林暉典",{"$nulls":3},"助理工程師",null,"2019-10-17","2019-10-17",0,0,{"v":0.206989247311828,"d":"0.21"},{"v":0.793010752688172,"d":"0.79"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0182","曾宏語",{"$nulls":3},"助理工程師",null,"2019-11-01","2019-11-01",0,0,{"v":0.16666666666666663,"d":"0.17"},{"v":0.8333333333333334,"d":"0.83"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0185","駱介文",{"$nulls":3},"機電部 助理工程師",null,"2019-11-01","2019-11-01",0,0,{"v":0.16666666666666663,"d":"0.17"},{"v":0.8333333333333334,"d":"0.83"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0186","王榮逢",{"$nulls":3},"機電部 助理工程師",null,"2019-11-01","2019-11-01",0,0,{"v":0.16666666666666663,"d":"0.17"},{"v":0.8333333333333334,"d":"0.83"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0187","施羿彤",{"$nulls":3},"規劃科 一等專員",null,"2019-11-21","2019-11-21",0,0,{"v":0.11111111111111116,"d":"0.11"},{"v":0.8888888888888888,"d":"0.89"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0188","陳姿蓉",{"$nulls":3},"信泰誠-協理",null,"2019-11-21","2019-11-21",0,0,{"v":0.11111111111111116,"d":"0.11"},{"v":0.8888888888888888,"d":"0.89"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0189","吳泰樺",{"$nulls":3},"機電部 副工程師",null,"2019-12-02","2019-12-02",0,0,{"v":0.08064516129032251,"d":"0.08"},{"v":0.9193548387096775,"d":"0.92"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0191","蔡冠宇",{"$nulls":3},"助理工程師",null,"2019-12-05","2019-12-05",0,0,{"v":0.07258064516129037,"d":"0.07"},{"v":0.9274193548387096,"d":"0.93"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]
[null,null,"B0192","黃文星",{"$nulls":3},"助理工程師",null,"2019-12-20","2019-12-20",0,0,{"v":0.032258064516129004,"d":"0.03"},{"v":0.967741935483871,"d":"0.97"},0,0,0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,0,0,3,0]

{"sheet":"Sheet1","index":10,"n_rows":5,"n_cols":2,"rows_kept":5}
[]
[null,"行使特別休假權利："]
["一、","以勞工受僱當日起算，每一週年之期間」，所謂「年度終結」，可由雙方協商「受僱當日起算之每一週年」為何"]
[null,"勞工申請留職停薪時，計算特休的「受僱當日」已然變動，其行使期間的「每一週年」自得有所不同"]
[null,"（例如：1月1日到職勞工，申請留職停薪1年6個月，其週年制特休規範之受僱當日會變動為7月1日，一週年為當年7月1日至翌年6月30日）。"]