{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["工作表1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"工作表1","index":0,"n_rows":28,"n_cols":44,"rows_kept":28,"cut":false,"hidden":false,"merged":[[13,24,13,25],[21,9,21,22],[24,9,24,22],[3,9,3,11],[23,9,23,22],[22,24,22,25],[0,1,0,28],[2,6,2,8],[2,9,2,11],[3,4,3,8],[1,1,1,28],[27,23,27,26],[19,3,24,5],[27,1,27,22],[19,6,20,8],[24,24,24,25],[6,3,15,5],[12,9,12,22],[15,6,15,22],[9,6,11,8],[22,9,22,22],[13,9,13,22]]}
[null,"公教人員因延長病假致無考績者之年終獎金發給比例試算器（113.2.2 版）"]
[null,"【程式設計：審計部臺北市審計處人事室 高明賢 kau0914@ms23.hinet.net】"]
[null,null,null,null,null,null,"身分別：",null,null,"公務人員"]
[null,null,null,null,"核發年終獎金年度：",null,null,null,null,112,null,null,"年",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J3=\"教師\",DATE(J4-1+1911,8,1),DATE(J4+1911,1,1))","v":"2023-01-01"},null,null,{"$f":"IF(J3=\"教師\",DATE(J4+1911,7,31),DATE(J4+1911,12,31))","v":"2023-12-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AO10:AO12)","v":"2023-05-11"}]
[]
[null,null,null,{"$f":"IF(J3=\"公務人員\",J4&\"年度請延長病假之月數\",J4-1&\"學年度請延長病假之月數\")","v":"112年度請延長病假之月數"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"中間完整月數",null,null,"始日","始月是否為整月","始月畸零天數","末日","末月是否為整月",null,"末月畸零天數"]
[null,null,null,null,null,null,"延長病假：",null,null,112,"年",2,"月",1,"日","至",112,"年",5,"月",11,"日","共",{"$f":"AI10+AM10+AP10","v":3},"月",{"$f":"AN10+AR10","v":11},"日",null,null,null,null,null,null,null,{"$f":"IF(J10=0,0,IF(AND(J10=Q10,L10=S10),0,(Q10*12+S10-1)-(J10*12+L10)))","v":2},null,null,{"$f":"DATE(J10+1911,L10,N10)","v":"2023-02-01"},{"$f":"IF(J10=0,0,IF(N10=1,1,0))","v":1},{"$f":"IF(J10=0,0,IF(AM10=1,0,DAY(EOMONTH(AL10,0))-N10+1))","v":0},{"$f":"DATE(Q10+1911,S10,U10)","v":"2023-05-11"},{"$f":"IF(J10=0,0,IF(U10=DAY(EOMONTH(AO10,0)),1,0))","v":0},null,{"$f":"IF(J10=0,0,IF(AP10=1,0,U10))","v":11}]
[null,null,null,null,null,null,null,null,null,null,"年",null,"月",null,"日","至",null,"年",null,"月",null,"日","共",{"$f":"AI11+AM11+AP11","v":0},"月",{"$f":"AN11+AR11","v":0},"日",null,null,null,null,null,null,null,{"$f":"IF(J11=0,0,IF(AND(J11=Q11,L11=S11),0,(Q11*12+S11-1)-(J11*12+L11)))","v":0},null,null,{"$f":"DATE(J11+1911,L11,N11)","v":"1910-11-30"},{"$f":"IF(J11=0,0,IF(N11=1,1,0))","v":0},{"$f":"IF(J11=0,0,IF(AM11=1,0,DAY(EOMONTH(AL11,0))-N11+1))","v":0},{"$f":"DATE(Q11+1911,S11,U11)","v":"1910-11-30"},{"$f":"IF(J11=0,0,IF(U11=DAY(EOMONTH(AO11,0)),1,0))","v":0},null,{"$f":"IF(J11=0,0,IF(AP11=1,0,U11))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"年",null,"月",null,"日","至",null,"年",null,"月",null,"日","共",0,"月",0,"日",null,null,null,null,null,null,null,0,null,null,"1910-11-30",0,0,"1910-11-30",0,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"D7&\"，共：\"","v":"112年度請延長病假之月數，共："},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X10:X12)+INT((Z10+Z11+Z12)/30)","v":3},"月",{"$f":"MOD(Z10+Z11+Z12,30)","v":11},"日"]
[null,null,null,null,null,null,null,null,null,"以：",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X13","v":3},"個月計(A)"]
[]
[null,null,null,null,null,null,"事假、病假、延長病假合計：",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X13","v":3},"月",{"$f":"Z13","v":11},"日"]
[]
[]
[]
[null,null,null,{"$f":"IF(J3=\"公務人員\",J4&\"年度留職停薪之月數\",J4&\"年度留職停薪之月數\")","v":"112年度留職停薪之月數"},null,null,"留職停薪：",null,null,112,"年",5,"月",12,"日","至",112,"年",10,"月",5,"日","共",{"$f":"AI20+AM20+AP20","v":4},"月",{"$f":"AN20+AR20","v":25},"日",null,null,null,"起月",null,null,null,{"$f":"IF(J20=0,0,IF(AND(J20=Q20,L20=S20),0,(Q20*12+S20-1)-(J20*12+L20)))","v":4},null,null,{"$f":"DATE(J20+1911,L20,N20)","v":"2023-05-12"},{"$f":"IF(J20=0,0,IF(N20=1,1,0))","v":0},{"$f":"IF(J20=0,0,IF(AM20=1,0,DAY(EOMONTH(AL20,0))-N20+1))","v":20},{"$f":"DATE(Q20+1911,S20,U20)","v":"2023-10-05"},{"$f":"IF(J20=0,0,IF(U20=DAY(EOMONTH(AO20,0)),1,0))","v":0},null,{"$f":"IF(J20=0,0,IF(AP20=1,0,U20))","v":5}]
[null,null,null,null,null,null,null,null,null,null,"年",null,"月",null,"日","至",null,"年",null,"月",null,"日","共",{"$f":"AI21+AM21+AP21","v":0},"月",{"$f":"AN21+AR21","v":0},"日",null,null,null,"起月",null,null,null,{"$f":"IF(J21=0,0,IF(AND(J21=Q21,L21=S21),0,(Q21*12+S21-1)-(J21*12+L21)))","v":0},null,null,"1910-11-30",0,0,"1910-11-30",0,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"J4&\"年度留職停薪之月數，共：\"","v":"112年度留職停薪之月數，共："},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X20:X21)+INT((Z20+Z21)/30)","v":4},"月",{"$f":"MOD(Z20+Z21,30)","v":25},"日"]
[null,null,null,null,null,null,null,null,null,"以：",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X22","v":4},"個月計"]
[null,null,null,null,null,null,null,null,null,{"$f":"J4&\"年度扣除留職停薪之在職月數，共：\"","v":"112年度扣除留職停薪之在職月數，共："},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z23=0,12-X23,12-X23-1)","v":8},"個月計(B)"]
[]
[]
[]
[null,{"$f":"J4&\"年應發給之年終獎金月數比例 = (B-A) /12）：\"","v":"112年應發給之年終獎金月數比例 = (B-A) /12）："},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X24-X14&\"/12\"","v":"5/12"}]