{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["年次休暇","年次加算"],"read":"whole","date_system":"1900"}

{"sheet":"年次休暇","index":0,"n_rows":26,"n_cols":35,"rows_kept":26,"merged":[[2,0,3,0],[4,0,5,0],[6,0,7,0],[8,0,9,0],[10,0,11,0],[12,0,13,0],[14,0,15,0],[16,0,17,0],[18,0,19,0],[20,0,21,0],[22,0,23,0],[24,0,25,0]]}
[]
[null,null,"繰越",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"残り"]
["1月","日数",{"$nulls":32},{"$f":"IF(C4<SUM(D4:AH4),IF(AND(MINUTE(SUM(D4:AH4))=MINUTE(C4),MOD(HOUR(SUM(D4:AH4)-C4),8)=0),C3-SUM(D3:AH3)+年次加算!AG4-INT((HOUR(SUM(D4:AH4)-C4))/8),C3-SUM(D3:AH3)+年次加算!AG4-INT(1+HOUR(SUM(D4:AH4)-C4)/8)),C3-SUM(D3:AH3)+年次加算!AG4)","v":0}]
[null,"時間",{"$nulls":32},{"$f":"IF((C4<SUM(D4:AH4)),IF(AND(MINUTE(SUM(D4:AH4))=MINUTE(C4),MOD(HOUR(SUM(D4:AH4)-C4),8)=0),INT((HOUR(SUM(D4:AH4)-C4))/8)*TIME(8,0,0)+C4-SUM(D4:AH4),INT(1+HOUR(SUM(D4:AH4)-C4)/8)*TIME(8,0,0)+C4-SUM(D4:AH4)),C4-SUM(D4:AH4))","v":"00:00:00"}]
["2月","日数",{"$f":"AI3","v":0},{"$nulls":31},{"$f":"IF(C6<SUM(D6:AH6),IF(AND(MINUTE(SUM(D6:AH6))=MINUTE(C6),MOD(HOUR(SUM(D6:AH6)-C6),8)=0),C5-SUM(D5:AH5)+年次加算!AG5-INT((HOUR(SUM(D6:AH6)-C6))/8),C5-SUM(D5:AH5)+年次加算!AG5-INT(1+HOUR(SUM(D6:AH6)-C6)/8)),C5-SUM(D5:AH5)+年次加算!AG5)","v":0}]
[null,"時間","00:00:00",{"$nulls":31},{"$f":"IF((C6<SUM(D6:AH6)),IF(AND(MINUTE(SUM(D6:AH6))=MINUTE(C6),MOD(HOUR(SUM(D6:AH6)-C6),8)=0),INT((HOUR(SUM(D6:AH6)-C6))/8)*TIME(8,0,0)+C6-SUM(D6:AH6),INT(1+HOUR(SUM(D6:AH6)-C6)/8)*TIME(8,0,0)+C6-SUM(D6:AH6)),C6-SUM(D6:AH6))","v":"00:00:00"}]
["3月","日数",0,{"$nulls":31},{"$f":"IF(C8<SUM(D8:AH8),IF(AND(MINUTE(SUM(D8:AH8))=MINUTE(C8),MOD(HOUR(SUM(D8:AH8)-C8),8)=0),C7-SUM(D7:AH7)+年次加算!AG6-INT((HOUR(SUM(D8:AH8)-C8))/8),C7-SUM(D7:AH7)+年次加算!AG6-INT(1+HOUR(SUM(D8:AH8)-C8)/8)),C7-SUM(D7:AH7)+年次加算!AG6)","v":0}]
[null,"時間","00:00:00",{"$nulls":31},{"$f":"IF((C8<SUM(D8:AH8)),IF(AND(MINUTE(SUM(D8:AH8))=MINUTE(C8),MOD(HOUR(SUM(D8:AH8)-C8),8)=0),INT((HOUR(SUM(D8:AH8)-C8))/8)*TIME(8,0,0)+C8-SUM(D8:AH8),INT(1+HOUR(SUM(D8:AH8)-C8)/8)*TIME(8,0,0)+C8-SUM(D8:AH8)),C8-SUM(D8:AH8))","v":"00:00:00"}]
["4月","日数",0,{"$nulls":31},{"$f":"IF(C10<SUM(D10:AH10),IF(AND(MINUTE(SUM(D10:AH10))=MINUTE(C10),MOD(HOUR(SUM(D10:AH10)-C10),8)=0),C9-SUM(D9:AH9)+年次加算!AG7-INT((HOUR(SUM(D10:AH10)-C10))/8),C9-SUM(D9:AH9)+年次加算!AG7-INT(1+HOUR(SUM(D10:AH10)-C10)/8)),C9-SUM(D9:AH9)+年次加算!AG7)","v":0}]
[null,"時間","00:00:00",{"$nulls":31},{"$f":"IF((C10<SUM(D10:AH10)),IF(AND(MINUTE(SUM(D10:AH10))=MINUTE(C10),MOD(HOUR(SUM(D10:AH10)-C10),8)=0),INT((HOUR(SUM(D10:AH10)-C10))/8)*TIME(8,0,0)+C10-SUM(D10:AH10),INT(1+HOUR(SUM(D10:AH10)-C10)/8)*TIME(8,0,0)+C10-SUM(D10:AH10)),C10-SUM(D10:AH10))","v":"00:00:00"}]
["5月","日数",0,{"$nulls":31},{"$f":"IF(C12<SUM(D12:AH12),IF(AND(MINUTE(SUM(D12:AH12))=MINUTE(C12),MOD(HOUR(SUM(D12:AH12)-C12),8)=0),C11-SUM(D11:AH11)+年次加算!AG8-INT((HOUR(SUM(D12:AH12)-C12))/8),C11-SUM(D11:AH11)+年次加算!AG8-INT(1+HOUR(SUM(D12:AH12)-C12)/8)),C11-SUM(D11:AH11)+年次加算!AG8)","v":0}]
[null,"時間","00:00:00",{"$nulls":31},{"$f":"IF((C12<SUM(D12:AH12)),IF(AND(MINUTE(SUM(D12:AH12))=MINUTE(C12),MOD(HOUR(SUM(D12:AH12)-C12),8)=0),INT((HOUR(SUM(D12:AH12)-C12))/8)*TIME(8,0,0)+C12-SUM(D12:AH12),INT(1+HOUR(SUM(D12:AH12)-C12)/8)*TIME(8,0,0)+C12-SUM(D12:AH12)),C12-SUM(D12:AH12))","v":"00:00:00"}]
["6月","日数",0,{"$nulls":31},{"$f":"IF(C14<SUM(D14:AH14),IF(AND(MINUTE(SUM(D14:AH14))=MINUTE(C14),MOD(HOUR(SUM(D14:AH14)-C14),8)=0),C13-SUM(D13:AH13)+年次加算!AG9-INT((HOUR(SUM(D14:AH14)-C14))/8),C13-SUM(D13:AH13)+年次加算!AG9-INT(1+HOUR(SUM(D14:AH14)-C14)/8)),C13-SUM(D13:AH13)+年次加算!AG9)","v":0}]
[null,"時間","00:00:00",{"$nulls":31},{"$f":"IF((C14<SUM(D14:AH14)),IF(AND(MINUTE(SUM(D14:AH14))=MINUTE(C14),MOD(HOUR(SUM(D14:AH14)-C14),8)=0),INT((HOUR(SUM(D14:AH14)-C14))/8)*TIME(8,0,0)+C14-SUM(D14:AH14),INT(1+HOUR(SUM(D14:AH14)-C14)/8)*TIME(8,0,0)+C14-SUM(D14:AH14)),C14-SUM(D14:AH14))","v":"00:00:00"}]
["7月","日数",0,{"$nulls":31},{"$f":"IF(C16<SUM(D16:AH16),IF(AND(MINUTE(SUM(D16:AH16))=MINUTE(C16),MOD(HOUR(SUM(D16:AH16)-C16),8)=0),C15-SUM(D15:AH15)+年次加算!AG10-INT((HOUR(SUM(D16:AH16)-C16))/8),C15-SUM(D15:AH15)+年次加算!AG10-INT(1+HOUR(SUM(D16:AH16)-C16)/8)),C15-SUM(D15:AH15)+年次加算!AG10)","v":0}]
[null,"時間","00:00:00",{"$nulls":31},{"$f":"IF((C16<SUM(D16:AH16)),IF(AND(MINUTE(SUM(D16:AH16))=MINUTE(C16),MOD(HOUR(SUM(D16:AH16)-C16),8)=0),INT((HOUR(SUM(D16:AH16)-C16))/8)*TIME(8,0,0)+C16-SUM(D16:AH16),INT(1+HOUR(SUM(D16:AH16)-C16)/8)*TIME(8,0,0)+C16-SUM(D16:AH16)),C16-SUM(D16:AH16))","v":"00:00:00"}]
["8月","日数",0,{"$nulls":31},{"$f":"IF(C18<SUM(D18:AH18),IF(AND(MINUTE(SUM(D18:AH18))=MINUTE(C18),MOD(HOUR(SUM(D18:AH18)-C18),8)=0),C17-SUM(D17:AH17)+年次加算!AG11-INT((HOUR(SUM(D18:AH18)-C18))/8),C17-SUM(D17:AH17)+年次加算!AG11-INT(1+HOUR(SUM(D18:AH18)-C18)/8)),C17-SUM(D17:AH17)+年次加算!AG11)","v":0}]
[null,"時間","00:00:00",{"$nulls":31},{"$f":"IF((C18<SUM(D18:AH18)),IF(AND(MINUTE(SUM(D18:AH18))=MINUTE(C18),MOD(HOUR(SUM(D18:AH18)-C18),8)=0),INT((HOUR(SUM(D18:AH18)-C18))/8)*TIME(8,0,0)+C18-SUM(D18:AH18),INT(1+HOUR(SUM(D18:AH18)-C18)/8)*TIME(8,0,0)+C18-SUM(D18:AH18)),C18-SUM(D18:AH18))","v":"00:00:00"}]
["9月","日数",0,{"$nulls":31},{"$f":"IF(C20<SUM(D20:AH20),IF(AND(MINUTE(SUM(D20:AH20))=MINUTE(C20),MOD(HOUR(SUM(D20:AH20)-C20),8)=0),C19-SUM(D19:AH19)+年次加算!AG12-INT((HOUR(SUM(D20:AH20)-C20))/8),C19-SUM(D19:AH19)+年次加算!AG12-INT(1+HOUR(SUM(D20:AH20)-C20)/8)),C19-SUM(D19:AH19)+年次加算!AG12)","v":0}]
[null,"時間","00:00:00",{"$nulls":31},{"$f":"IF((C20<SUM(D20:AH20)),IF(AND(MINUTE(SUM(D20:AH20))=MINUTE(C20),MOD(HOUR(SUM(D20:AH20)-C20),8)=0),INT((HOUR(SUM(D20:AH20)-C20))/8)*TIME(8,0,0)+C20-SUM(D20:AH20),INT(1+HOUR(SUM(D20:AH20)-C20)/8)*TIME(8,0,0)+C20-SUM(D20:AH20)),C20-SUM(D20:AH20))","v":"00:00:00"}]
["10月","日数",0,{"$nulls":31},{"$f":"IF(C22<SUM(D22:AH22),IF(AND(MINUTE(SUM(D22:AH22))=MINUTE(C22),MOD(HOUR(SUM(D22:AH22)-C22),8)=0),C21-SUM(D21:AH21)+年次加算!AG13-INT((HOUR(SUM(D22:AH22)-C22))/8),C21-SUM(D21:AH21)+年次加算!AG13-INT(1+HOUR(SUM(D22:AH22)-C22)/8)),C21-SUM(D21:AH21)+年次加算!AG13)","v":0}]
[null,"時間","00:00:00",{"$nulls":31},{"$f":"IF((C22<SUM(D22:AH22)),IF(AND(MINUTE(SUM(D22:AH22))=MINUTE(C22),MOD(HOUR(SUM(D22:AH22)-C22),8)=0),INT((HOUR(SUM(D22:AH22)-C22))/8)*TIME(8,0,0)+C22-SUM(D22:AH22),INT(1+HOUR(SUM(D22:AH22)-C22)/8)*TIME(8,0,0)+C22-SUM(D22:AH22)),C22-SUM(D22:AH22))","v":"00:00:00"}]
["11月","日数",0,{"$nulls":31},{"$f":"IF(C24<SUM(D24:AH24),IF(AND(MINUTE(SUM(D24:AH24))=MINUTE(C24),MOD(HOUR(SUM(D24:AH24)-C24),8)=0),C23-SUM(D23:AH23)+年次加算!AG14-INT((HOUR(SUM(D24:AH24)-C24))/8),C23-SUM(D23:AH23)+年次加算!AG14-INT(1+HOUR(SUM(D24:AH24)-C24)/8)),C23-SUM(D23:AH23)+年次加算!AG14)","v":0}]
[null,"時間","00:00:00",{"$nulls":31},{"$f":"IF((C24<SUM(D24:AH24)),IF(AND(MINUTE(SUM(D24:AH24))=MINUTE(C24),MOD(HOUR(SUM(D24:AH24)-C24),8)=0),INT((HOUR(SUM(D24:AH24)-C24))/8)*TIME(8,0,0)+C24-SUM(D24:AH24),INT(1+HOUR(SUM(D24:AH24)-C24)/8)*TIME(8,0,0)+C24-SUM(D24:AH24)),C24-SUM(D24:AH24))","v":"00:00:00"}]
["12月","日数",0,{"$nulls":31},{"$f":"IF(C26<SUM(D26:AH26),IF(AND(MINUTE(SUM(D26:AH26))=MINUTE(C26),MOD(HOUR(SUM(D26:AH26)-C26),8)=0),C25-SUM(D25:AH25)+年次加算!AG15-INT((HOUR(SUM(D26:AH26)-C26))/8),C25-SUM(D25:AH25)+年次加算!AG15-INT(1+HOUR(SUM(D26:AH26)-C26)/8)),C25-SUM(D25:AH25)+年次加算!AG15)","v":0}]
[null,"時間","00:00:00",{"$nulls":31},{"$f":"IF((C26<SUM(D26:AH26)),IF(AND(MINUTE(SUM(D26:AH26))=MINUTE(C26),MOD(HOUR(SUM(D26:AH26)-C26),8)=0),INT((HOUR(SUM(D26:AH26)-C26))/8)*TIME(8,0,0)+C26-SUM(D26:AH26),INT(1+HOUR(SUM(D26:AH26)-C26)/8)*TIME(8,0,0)+C26-SUM(D26:AH26)),C26-SUM(D26:AH26))","v":"00:00:00"}]

{"sheet":"年次加算","index":1,"n_rows":15,"n_cols":33,"rows_kept":15,"merged":[[0,32,2,32]]}
[2019,{"$nulls":31},"今日までの年次の加算日数"]
[]
["月",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[1,{"$nulls":31},{"$f":"IF($A$1=YEAR(TODAY()),IF(MONTH(TODAY())=A4,SUM(OFFSET(B4,0,0,1,DAY(TODAY()))),IF(MONTH(TODAY())>A4,SUM(B4:AF4),0)),SUM(B4:AF4))","v":0}]
[2,{"$nulls":31},{"$f":"IF($A$1=YEAR(TODAY()),IF(MONTH(TODAY())=A5,SUM(OFFSET(B5,0,0,1,DAY(TODAY()))),IF(MONTH(TODAY())>A5,SUM(B5:AF5),0)),SUM(B5:AF5))","v":0}]
[3,{"$nulls":31},0]
[4,{"$nulls":31},0]
[5,{"$nulls":31},0]
[6,{"$nulls":31},0]
[7,{"$nulls":31},0]
[8,{"$nulls":31},0]
[9,{"$nulls":31},0]
[10,{"$nulls":31},0]
[11,{"$nulls":31},0]
[12,{"$nulls":31},0]