{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["年次有給休暇管理簿（一覧）","年次有給休暇管理簿","使用条件及び免責事項"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"年次有給休暇管理簿（一覧）","index":0,"n_rows":7,"n_cols":32,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,23,5,24],[5,14,5,15],[5,11,5,12],[5,6,5,7],[5,21,5,22],[2,2,2,5],[4,9,4,10],[4,18,4,19],[4,25,4,28],[4,6,4,7],[4,21,4,22],[4,23,4,24],[4,11,4,15],[2,9,2,15]]}
["年次有給休暇管理簿（一覧）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-12-26"}]
[]
[null,null,"：本一覧を各従業員の年次有給休暇管理簿の情報で更新します。\n 各従業員の年次有給休暇管理簿は、全て同じフォルダーに入れてください。",null,null,null,null,null,null,"：本一覧に表示されている各従業員の次年度の年次有給休暇管理簿を作成します。\n 開いている「年次有給休暇管理簿」は全て閉じてください。"]
[]
["No","従業員番号","部門","役職","氏名","有給休暇取得アラート","取得日数",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,"１日の\n所定労働時間","時間単位年休１日の時間数","時間単位年休の単位時間","時間単位年休の日数"]
[{"$f":"HYPERLINK(AD7,1)","v":1}]

{"sheet":"年次有給休暇管理簿","index":1,"n_rows":73,"n_cols":25,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,0,0,1],[0,2,0,3],[0,19,0,20],[1,19,1,20],[2,0,2,3],[2,4,2,6],[2,7,2,9],[2,11,2,14],[2,15,2,18],[2,19,2,20],[7,13,7,16],[7,17,7,20],[7,21,7,22],[8,0,8,1],[8,3,8,4],[8,17,8,20],[4,19,4,20],[5,4,5,5],[5,7,5,8],[5,13,5,14],[5,15,5,16],[7,0,7,2],[7,3,7,5],[7,6,7,7],[7,8,7,9],[7,11,7,12],[9,18,9,19],[10,0,10,1],[10,2,10,3],[10,4,10,6],[10,7,10,8],[10,9,10,10],[10,13,10,14],[10,15,10,16],[10,19,10,20],[11,22,12,22],[11,23,12,23],[11,24,12,24],[12,4,12,5],[13,0,14,1],[13,2,14,3],[13,4,13,5],[13,7,14,8],[13,11,14,11],[13,12,14,12],[11,13,12,14],[11,15,12,16],[11,17,12,17],[11,18,12,18],[11,19,12,20],[11,21,12,21],[11,0,12,1],[11,2,12,3],[11,4,11,5],[11,7,12,8],[11,11,12,11],[11,12,12,12],[13,22,14,22],[13,23,14,23],[15,0,16,1],[15,2,16,3],[15,4,15,5],[15,7,16,8],[15,11,16,11],[15,12,16,12],[13,13,14,14],[13,15,14,16],[13,17,14,17],[16,4,16,5],[15,13,16,14],[15,15,16,16],[15,17,16,17],[13,24,14,24],[14,4,14,5],[13,18,14,18],[13,19,14,20],[13,21,14,21],[15,22,16,22],[15,23,16,23],[15,24,16,24],[15,18,16,18],[15,19,16,20],[15,21,16,21],[19,0,20,1],[19,2,20,3],[19,4,19,5],[19,7,20,8],[19,11,20,11],[19,12,20,12],[17,13,18,14],[17,15,18,16],[17,17,18,17],[17,0,18,1],[17,2,18,3],[17,4,17,5],[17,7,18,8],[17,11,18,11],[17,12,18,12],[18,4,18,5],[17,19,18,20],[17,21,18,21],[19,22,20,22],[19,23,20,23],[19,24,20,24],[20,4,20,5],[19,18,20,18],[19,19,20,20],[19,21,20,21],[17,22,18,22],[17,23,18,23],[17,24,18,24],[17,18,18,18],[21,2,22,3],[21,4,21,5],[21,7,22,8],[21,11,22,11],[21,12,22,12],[19,13,20,14],[19,15,20,16],[19,17,20,17],[23,13,24,14],[23,15,24,16],[23,17,24,17],[21,22,22,22],[21,23,22,23],[21,24,22,24],[22,4,22,5],[23,0,24,1],[23,2,24,3],[23,4,23,5],[23,7,24,8],[23,11,24,11],[23,12,24,12],[21,13,22,14],[21,15,22,16],[21,17,22,17],[21,18,22,18],[21,19,22,20],[21,21,22,21],[23,22,24,22],[23,23,24,23],[23,24,24,24],[24,4,24,5],[23,18,24,18],[23,19,24,20],[23,21,24,21],[21,0,22,1],[25,23,26,23],[25,24,26,24],[26,4,26,5],[27,0,28,1],[27,2,28,3],[27,4,27,5],[27,7,28,8],[27,11,28,11],[27,12,28,12],[25,13,26,14],[25,15,26,16],[25,17,26,17],[25,18,26,18],[25,19,26,20],[25,21,26,21],[27,22,28,22],[27,23,28,23],[27,24,28,24],[28,4,28,5],[27,18,28,18],[27,19,28,20],[27,21,28,21],[25,0,26,1],[25,2,26,3],[29,4,29,5],[29,7,30,8],[29,11,30,11],[29,12,30,12],[27,13,28,14],[27,15,28,16],[27,17,28,17],[25,22,26,22],[25,4,25,5],[25,7,26,8],[25,11,26,11],[25,12,26,12],[29,22,30,22],[29,23,30,23],[29,24,30,24],[30,4,30,5],[31,0,32,1],[31,2,32,3],[31,4,31,5],[31,7,32,8],[31,11,32,11],[31,12,32,12],[29,13,30,14],[29,15,30,16],[29,17,30,17],[29,18,30,18],[29,19,30,20],[29,21,30,21],[31,22,32,22],[31,23,32,23],[31,24,32,24],[32,4,32,5],[31,18,32,18],[31,19,32,20],[31,21,32,21],[29,0,30,1],[29,2,30,3],[33,2,34,3],[33,4,33,5],[33,7,34,8],[33,11,34,11],[33,12,34,12],[31,13,32,14],[31,15,32,16],[31,17,32,17],[35,13,36,14],[35,15,36,16],[35,17,36,17],[33,22,34,22],[33,23,34,23],[33,24,34,24],[34,4,34,5],[35,0,36,1],[35,2,36,3],[35,4,35,5],[35,7,36,8],[35,11,36,11],[35,12,36,12],[33,13,34,14],[33,15,34,16],[33,17,34,17],[33,18,34,18],[33,19,34,20],[33,21,34,21],[35,22,36,22],[35,23,36,23],[35,24,36,24],[36,4,36,5],[35,18,36,18],[35,19,36,20],[35,21,36,21],[33,0,34,1],[37,23,38,23],[37,24,38,24],[38,4,38,5],[39,0,40,1],[39,2,40,3],[39,4,39,5],[39,7,40,8],[39,11,40,11],[39,12,40,12],[37,13,38,14],[37,15,38,16],[37,17,38,17],[37,18,38,18],[37,19,38,20],[37,21,38,21],[39,22,40,22],[39,23,40,23],[39,24,40,24],[40,4,40,5],[39,18,40,18],[39,19,40,20],[39,21,40,21],[37,0,38,1],[37,2,38,3],[41,4,41,5],[41,7,42,8],[41,11,42,11],[41,12,42,12],[39,13,40,14],[39,15,40,16],[39,17,40,17],[37,22,38,22],[37,4,37,5],[37,7,38,8],[37,11,38,11],[37,12,38,12],[41,22,42,22],[41,23,42,23],[41,24,42,24],[42,4,42,5],[43,0,44,1],[43,2,44,3],[43,4,43,5],[43,7,44,8],[43,11,44,11],[43,12,44,12],[41,13,42,14],[41,15,42,16],[41,17,42,17],[41,18,42,18],[41,19,42,20],[41,21,42,21],[43,22,44,22],[43,23,44,23],[43,24,44,24],[44,4,44,5],[43,18,44,18],[43,19,44,20],[43,21,44,21],[41,0,42,1],[41,2,42,3],[45,2,46,3],[45,4,45,5],[45,7,46,8],[45,11,46,11],[45,12,46,12],[43,13,44,14],[43,15,44,16],[43,17,44,17],[47,13,48,14],[47,15,48,16],[47,17,48,17],[45,22,46,22],[45,23,46,23],[45,24,46,24],[46,4,46,5],[47,0,48,1],[47,2,48,3],[47,4,47,5],[47,7,48,8],[47,11,48,11],[47,12,48,12],[45,13,46,14],[45,15,46,16],[45,17,46,17],[45,18,46,18],[45,19,46,20],[45,21,46,21],[47,22,48,22],[47,23,48,23],[47,24,48,24],[48,4,48,5],[47,18,48,18],[47,19,48,20],[47,21,48,21],[45,0,46,1],[49,23,50,23],[49,24,50,24],[50,4,50,5],[51,0,52,1],[51,2,52,3],[51,4,51,5],[51,7,52,8],[51,11,52,11],[51,12,52,12],[49,13,50,14],[49,15,50,16],[49,17,50,17],[49,18,50,18],[49,19,50,20],[49,21,50,21],[51,22,52,22],[51,23,52,23],[51,24,52,24],[52,4,52,5],[51,18,52,18],[51,19,52,20],[51,21,52,21],[49,0,50,1],[49,2,50,3],[53,4,53,5],[53,7,54,8],[53,11,54,11],[53,12,54,12],[51,13,52,14],[51,15,52,16],[51,17,52,17],[49,22,50,22],[49,4,49,5],[49,7,50,8],[49,11,50,11],[49,12,50,12],[53,22,54,22],[53,23,54,23],[53,24,54,24],[54,4,54,5],[55,0,56,1],[55,2,56,3],[55,4,55,5],[55,7,56,8],[55,11,56,11],[55,12,56,12],[53,13,54,14],[53,15,54,16],[53,17,54,17],[53,18,54,18],[53,19,54,20],[53,21,54,21],[55,22,56,22],[55,23,56,23],[55,24,56,24],[56,4,56,5],[55,18,56,18],[55,19,56,20],[55,21,56,21],[53,0,54,1],[53,2,54,3],[57,2,58,3],[57,4,57,5],[57,7,58,8],[57,11,58,11],[57,12,58,12],[55,13,56,14],[55,15,56,16],[55,17,56,17],[59,13,60,14],[59,15,60,16],[59,17,60,17],[57,22,58,22],[57,23,58,23],[57,24,58,24],[58,4,58,5],[59,0,60,1],[59,2,60,3],[59,4,59,5],[59,7,60,8],[59,11,60,11],[59,12,60,12],[57,13,58,14],[57,15,58,16],[57,17,58,17],[57,18,58,18],[57,19,58,20],[57,21,58,21],[59,22,60,22],[59,23,60,23],[59,24,60,24],[60,4,60,5],[59,18,60,18],[59,19,60,20],[59,21,60,21],[57,0,58,1],[61,23,62,23],[61,24,62,24],[62,4,62,5],[63,0,64,1],[63,2,64,3],[63,4,63,5],[63,7,64,8],[63,11,64,11],[63,12,64,12],[61,13,62,14],[61,15,62,16],[61,17,62,17],[61,18,62,18],[61,19,62,20],[61,21,62,21],[63,22,64,22],[63,23,64,23],[63,24,64,24],[64,4,64,5],[63,18,64,18],[63,19,64,20],[63,21,64,21],[61,0,62,1],[61,2,62,3],[65,4,65,5],[65,7,66,8],[65,11,66,11],[65,12,66,12],[63,13,64,14],[63,15,64,16],[63,17,64,17],[61,22,62,22],[61,4,61,5],[61,7,62,8],[61,11,62,11],[61,12,62,12],[65,22,66,22],[65,23,66,23],[65,24,66,24],[66,4,66,5],[67,0,68,1],[67,2,68,3],[67,4,67,5],[67,7,68,8],[67,11,68,11],[67,12,68,12],[65,13,66,14],[65,15,66,16],[65,17,66,17],[65,18,66,18],[65,19,66,20],[65,21,66,21],[67,22,68,22],[67,23,68,23],[67,24,68,24],[68,4,68,5],[67,18,68,18],[67,19,68,20],[67,21,68,21],[65,0,66,1],[65,2,66,3],[71,17,72,17],[71,18,72,18],[69,0,70,1],[69,2,70,3],[69,4,69,5],[69,7,70,8],[69,11,70,11],[69,12,70,12],[67,13,68,14],[67,15,68,16],[67,17,68,17],[71,19,72,20],[71,21,72,21],[69,22,70,22],[69,23,70,23],[69,24,70,24],[70,4,70,5],[71,0,72,1],[71,2,72,3],[71,4,71,5],[71,7,72,8],[71,11,72,11],[71,12,72,12],[69,13,70,14],[69,15,70,16],[69,17,70,17],[69,18,70,18],[69,19,70,20],[69,21,70,21],[71,22,72,22],[71,23,72,23],[71,24,72,24],[72,4,72,5],[71,13,72,14],[71,15,72,16]]}
["従業員番号：",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年度分",{"$f":"TODAY()","v":"2019-12-26"},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":"IF(H6-5>0,H6-5,0)","v":0},{"$f":"SUMIF(C12:D952,\"計画的付与\",L12:L952)","v":0},{"$f":"(YEAR(T3-1)-YEAR(P3))*12+MONTH(T3-1)-MONTH(P3)+IF(DAY(T3-1)>=DAY(P3),1,0)+12","v":{"$error":"#NUM!"}}]
[]
["前年度繰越分",null,null,null,"今年度付与日数",null,null,"合計日数",null,null,null,"取得日数",null,"残日数",null,null,null,"次回繰越日数",null,"時季指定可能日数",null,"使用日数計","使用時間数計","時季指定日数"]
[null,"日",null,"時間",null,null,"日",{"$f":"SUM(A6,E6)","v":0},null,{"$f":"C6","v":0},null,{"$f":"SUM(L12:L952)","v":0},{"$f":"SUM(M12:M952)","v":0},{"$f":"IF(N12=\"\",H6,INDIRECT(\"N\"&COUNT(N$12:N$9962)*2+10))","v":0},null,{"$f":"IF(P12=\"\",J6,INDIRECT(\"P\"&COUNT(P$12:P$9962)*2+10))","v":0},null,{"$f":"IF(X9,IF(V6>=E6,0,IF(W6>0,E6-V6-1,E6-V6)),IF((P6-W9)>=0,N6-V9,N6-V9-1))","v":0},{"$f":"IF(X9,IF(W6>0,D9-W6,0),IF(P6>=W9,P6-W9,P6+D9-W9))","v":0},{"$f":"IF(X6-L6>0,X6-L6,0)","v":0},{"$f":"IFERROR(IF(AND(L9>=10,E6>=10,P3>=DATE(2019,4,1),DATEDIF(P3,T3,\"M\")<12),ROUNDUP(X3/12*5,0),IF(AND(E6>=10,T3>=DATE(2019,4,1)),5,0)),0)","v":0},{"$f":"IF(J6-P6<0,H6-N6-1,H6-N6)","v":0},{"$f":"IF(J6-P6<0,D9-P6+J6,J6-P6)","v":0},{"$f":"IFERROR(IF(AND(L9>=10,E6>=10,P3>=DATE(2019,4,1),DATEDIF(P3,T3,\"M\")<12),ROUNDUP(X3/12*5,0)-N9,IF(AND(E6>=10,T3>=DATE(2019,4,1)),5,0)),0)","v":0}]
[]
["１日の所定労働時間",null,null,"時間単位年休１日の時間数",null,null,"時間単位年休の単位時間",null,"時間単位年休の日数",null,null,"前年度付与日数",null,"前年度取得日数",null,null,null,"インフォメーション",null,null,null,"次年度時効日数",null,"チェック"]
[null,null,"時間",{"$f":"ROUNDUP(A9,0)","v":0},null,"時間",null,"時間",null,"日",null,null,"日",null,"日",null,"時間",{"$f":"IF($M$6>$D$9*$I$9,\"時間単位年休の日数を超えています！\",IF(W3>V3,\"計画的付与できる日数を超えています！\",IF(T6<>0,IF(E6<10,TEXT(DATE(YEAR(P3)+1,MONTH(P3),DAY(P3)-1),\"yyyy年m月d日\")&\"までに\"&T6&\"日取得してください！\",TEXT(DATE(YEAR(T3)+1,MONTH(T3),DAY(T3)-1),\"yyyy年m月d日\")&\"までに\"&T6&\"日取得してください！\"),\"\")))","v":""},null,null,null,{"$f":"IF(A6-V6<=0,0,IF(C6-W6>=0,A6-V6,A6-V6-1))","v":0},{"$f":"IF(A6-V6>0,IF(C6-W6>=0,C6-W6,C6+D9-W6),IF(AND(A6-V6=0,C6-W6>=0),C6-W6,0))","v":0},false]
[]
["請求日",null,"指定区分",null,"休暇期間",null,null,"（半休の場合）\n休暇時間帯",null,"（時間単位年休の場合）\n休暇時間",null,"使用\n日数","使用\n時間数","残\n日数",null,"残\n時間数",null,"取消","所属長","備考",null,"日数","半休\n時間","時間","使用日数\n累計"]
[null,null,null,null,null,null,"から",null,null,null,"時から",{"$f":"IF(OR(R12=\"取消\",X12<>\"\"),\"\",IF(W12<>\"\",W12,V12))","v":""},{"$f":"IF(R12=\"取消\",\"\",IF(X12=\"\",\"\",IF(X12>$D$9,\"!ERROR!\",IF(X12/$G$9=INT(X12/$G$9),X12,\"!ERROR!\"))))","v":""},{"$f":"IF(E13=\"\",\"\",IF(AND(L12=\"\",M12=\"\"),H6,IF(M12=\"\",H6-L12,IF((J6-M12)>=0,H6,H6-1))))","v":""},null,{"$f":"IF(E13=\"\",\"\",IF(M12=\"\",J6,IF((J6-M12)>=0,J6-M12,J6+$D$9-M12)))","v":""},null,null,null,null,null,{"$f":"IF(E13=\"\",\"\",IF(AND(C12=\"時季指定\",DATEDIF(E12,E13,\"d\")+1+Y10>$X$6),\"!ERROR!\",DATEDIF(E12,E13,\"d\")+1))","v":""},{"$f":"IF(AND(C12=\"時季指定\",H12=\"半休\",0.5+Y10>$X$6),\"!ERROR!\",IF(H12=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J13=\"\",\"\",IF(OR(C12=\"時季指定\",C12=\"計画的付与\"),\"!ERROR!\",J13-J12))","v":""},{"$f":"IF(L12=\"\",0,L12)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から",{"$f":"IF(OR(R14=\"取消\",X14<>\"\"),\"\",IF(W14<>\"\",W14,V14))","v":""},{"$f":"IF(R14=\"取消\",\"\",IF(X14=\"\",\"\",IF(X14>$D$9,\"!ERROR!\",IF(X14/$G$9=INT(X14/$G$9),X14,\"!ERROR!\"))))","v":""},{"$f":"IF(E15=\"\",\"\",IF(AND(L14=\"\",M14=\"\"),N12,IF(M14=\"\",N12-L14,IF((P12-M14)>=0,N12,N12-1))))","v":""},null,{"$f":"IF(E15=\"\",\"\",IF(M14=\"\",P12,IF((P12-M14)>=0,P12-M14,P12+$D$9-M14)))","v":""},null,null,null,null,null,{"$f":"IF(E15=\"\",\"\",IF(AND(C14=\"時季指定\",DATEDIF(E14,E15,\"d\")+1+Y12>$X$6),\"!ERROR!\",DATEDIF(E14,E15,\"d\")+1))","v":""},{"$f":"IF(AND(C14=\"時季指定\",H14=\"半休\",0.5+Y12>$X$6),\"!ERROR!\",IF(H14=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J15=\"\",\"\",IF(OR(C14=\"時季指定\",C14=\"計画的付与\"),\"!ERROR!\",J15-J14))","v":""},{"$f":"IF(L14=\"\",Y12,Y12+L14)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から",{"$f":"IF(OR(R16=\"取消\",X16<>\"\"),\"\",IF(W16<>\"\",W16,V16))","v":""},{"$f":"IF(R16=\"取消\",\"\",IF(X16=\"\",\"\",IF(X16>$D$9,\"!ERROR!\",IF(X16/$G$9=INT(X16/$G$9),X16,\"!ERROR!\"))))","v":""},{"$f":"IF(E17=\"\",\"\",IF(AND(L16=\"\",M16=\"\"),N14,IF(M16=\"\",N14-L16,IF((P14-M16)>=0,N14,N14-1))))","v":""},null,{"$f":"IF(E17=\"\",\"\",IF(M16=\"\",P14,IF((P14-M16)>=0,P14-M16,P14+$D$9-M16)))","v":""},null,null,null,null,null,{"$f":"IF(E17=\"\",\"\",IF(AND(C16=\"時季指定\",DATEDIF(E16,E17,\"d\")+1+Y14>$X$6),\"!ERROR!\",DATEDIF(E16,E17,\"d\")+1))","v":""},{"$f":"IF(AND(C16=\"時季指定\",H16=\"半休\",0.5+Y14>$X$6),\"!ERROR!\",IF(H16=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J17=\"\",\"\",IF(OR(C16=\"時季指定\",C16=\"計画的付与\"),\"!ERROR!\",J17-J16))","v":""},{"$f":"IF(L16=\"\",Y14,Y14+L16)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から",{"$f":"IF(OR(R18=\"取消\",X18<>\"\"),\"\",IF(W18<>\"\",W18,V18))","v":""},{"$f":"IF(R18=\"取消\",\"\",IF(X18=\"\",\"\",IF(X18>$D$9,\"!ERROR!\",IF(X18/$G$9=INT(X18/$G$9),X18,\"!ERROR!\"))))","v":""},{"$f":"IF(E19=\"\",\"\",IF(AND(L18=\"\",M18=\"\"),N16,IF(M18=\"\",N16-L18,IF((P16-M18)>=0,N16,N16-1))))","v":""},null,{"$f":"IF(E19=\"\",\"\",IF(M18=\"\",P16,IF((P16-M18)>=0,P16-M18,P16+$D$9-M18)))","v":""},null,null,null,null,null,{"$f":"IF(E19=\"\",\"\",IF(AND(C18=\"時季指定\",DATEDIF(E18,E19,\"d\")+1+Y16>$X$6),\"!ERROR!\",DATEDIF(E18,E19,\"d\")+1))","v":""},{"$f":"IF(AND(C18=\"時季指定\",H18=\"半休\",0.5+Y16>$X$6),\"!ERROR!\",IF(H18=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J19=\"\",\"\",IF(OR(C18=\"時季指定\",C18=\"計画的付与\"),\"!ERROR!\",J19-J18))","v":""},{"$f":"IF(L18=\"\",Y16,Y16+L18)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から",{"$f":"IF(OR(R20=\"取消\",X20<>\"\"),\"\",IF(W20<>\"\",W20,V20))","v":""},{"$f":"IF(R20=\"取消\",\"\",IF(X20=\"\",\"\",IF(X20>$D$9,\"!ERROR!\",IF(X20/$G$9=INT(X20/$G$9),X20,\"!ERROR!\"))))","v":""},{"$f":"IF(E21=\"\",\"\",IF(AND(L20=\"\",M20=\"\"),N18,IF(M20=\"\",N18-L20,IF((P18-M20)>=0,N18,N18-1))))","v":""},null,{"$f":"IF(E21=\"\",\"\",IF(M20=\"\",P18,IF((P18-M20)>=0,P18-M20,P18+$D$9-M20)))","v":""},null,null,null,null,null,{"$f":"IF(E21=\"\",\"\",IF(AND(C20=\"時季指定\",DATEDIF(E20,E21,\"d\")+1+Y18>$X$6),\"!ERROR!\",DATEDIF(E20,E21,\"d\")+1))","v":""},{"$f":"IF(AND(C20=\"時季指定\",H20=\"半休\",0.5+Y18>$X$6),\"!ERROR!\",IF(H20=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J21=\"\",\"\",IF(OR(C20=\"時季指定\",C20=\"計画的付与\"),\"!ERROR!\",J21-J20))","v":""},{"$f":"IF(L20=\"\",Y18,Y18+L20)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R22=\"取消\",\"\",IF(X22=\"\",\"\",IF(X22>$D$9,\"!ERROR!\",IF(X22/$G$9=INT(X22/$G$9),X22,\"!ERROR!\"))))","v":""},{"$f":"IF(E23=\"\",\"\",IF(AND(L22=\"\",M22=\"\"),N20,IF(M22=\"\",N20-L22,IF((P20-M22)>=0,N20,N20-1))))","v":""},null,{"$f":"IF(E23=\"\",\"\",IF(M22=\"\",P20,IF((P20-M22)>=0,P20-M22,P20+$D$9-M22)))","v":""},null,null,null,null,null,{"$f":"IF(E23=\"\",\"\",IF(AND(C22=\"時季指定\",DATEDIF(E22,E23,\"d\")+1+Y20>$X$6),\"!ERROR!\",DATEDIF(E22,E23,\"d\")+1))","v":""},{"$f":"IF(AND(C22=\"時季指定\",H22=\"半休\",0.5+Y20>$X$6),\"!ERROR!\",IF(H22=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J23=\"\",\"\",IF(OR(C22=\"時季指定\",C22=\"計画的付与\"),\"!ERROR!\",J23-J22))","v":""},{"$f":"IF(L22=\"\",Y20,Y20+L22)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R24=\"取消\",\"\",IF(X24=\"\",\"\",IF(X24>$D$9,\"!ERROR!\",IF(X24/$G$9=INT(X24/$G$9),X24,\"!ERROR!\"))))","v":""},{"$f":"IF(E25=\"\",\"\",IF(AND(L24=\"\",M24=\"\"),N22,IF(M24=\"\",N22-L24,IF((P22-M24)>=0,N22,N22-1))))","v":""},null,{"$f":"IF(E25=\"\",\"\",IF(M24=\"\",P22,IF((P22-M24)>=0,P22-M24,P22+$D$9-M24)))","v":""},null,null,null,null,null,{"$f":"IF(E25=\"\",\"\",IF(AND(C24=\"時季指定\",DATEDIF(E24,E25,\"d\")+1+Y22>$X$6),\"!ERROR!\",DATEDIF(E24,E25,\"d\")+1))","v":""},{"$f":"IF(AND(C24=\"時季指定\",H24=\"半休\",0.5+Y22>$X$6),\"!ERROR!\",IF(H24=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J25=\"\",\"\",IF(OR(C24=\"時季指定\",C24=\"計画的付与\"),\"!ERROR!\",J25-J24))","v":""},{"$f":"IF(L24=\"\",Y22,Y22+L24)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R26=\"取消\",\"\",IF(X26=\"\",\"\",IF(X26>$D$9,\"!ERROR!\",IF(X26/$G$9=INT(X26/$G$9),X26,\"!ERROR!\"))))","v":""},{"$f":"IF(E27=\"\",\"\",IF(AND(L26=\"\",M26=\"\"),N24,IF(M26=\"\",N24-L26,IF((P24-M26)>=0,N24,N24-1))))","v":""},null,{"$f":"IF(E27=\"\",\"\",IF(M26=\"\",P24,IF((P24-M26)>=0,P24-M26,P24+$D$9-M26)))","v":""},null,null,null,null,null,{"$f":"IF(E27=\"\",\"\",IF(AND(C26=\"時季指定\",DATEDIF(E26,E27,\"d\")+1+Y24>$X$6),\"!ERROR!\",DATEDIF(E26,E27,\"d\")+1))","v":""},{"$f":"IF(AND(C26=\"時季指定\",H26=\"半休\",0.5+Y24>$X$6),\"!ERROR!\",IF(H26=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J27=\"\",\"\",IF(OR(C26=\"時季指定\",C26=\"計画的付与\"),\"!ERROR!\",J27-J26))","v":""},{"$f":"IF(L26=\"\",Y24,Y24+L26)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R28=\"取消\",\"\",IF(X28=\"\",\"\",IF(X28>$D$9,\"!ERROR!\",IF(X28/$G$9=INT(X28/$G$9),X28,\"!ERROR!\"))))","v":""},{"$f":"IF(E29=\"\",\"\",IF(AND(L28=\"\",M28=\"\"),N26,IF(M28=\"\",N26-L28,IF((P26-M28)>=0,N26,N26-1))))","v":""},null,{"$f":"IF(E29=\"\",\"\",IF(M28=\"\",P26,IF((P26-M28)>=0,P26-M28,P26+$D$9-M28)))","v":""},null,null,null,null,null,{"$f":"IF(E29=\"\",\"\",IF(AND(C28=\"時季指定\",DATEDIF(E28,E29,\"d\")+1+Y26>$X$6),\"!ERROR!\",DATEDIF(E28,E29,\"d\")+1))","v":""},{"$f":"IF(AND(C28=\"時季指定\",H28=\"半休\",0.5+Y26>$X$6),\"!ERROR!\",IF(H28=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J29=\"\",\"\",IF(OR(C28=\"時季指定\",C28=\"計画的付与\"),\"!ERROR!\",J29-J28))","v":""},{"$f":"IF(L28=\"\",Y26,Y26+L28)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R30=\"取消\",\"\",IF(X30=\"\",\"\",IF(X30>$D$9,\"!ERROR!\",IF(X30/$G$9=INT(X30/$G$9),X30,\"!ERROR!\"))))","v":""},{"$f":"IF(E31=\"\",\"\",IF(AND(L30=\"\",M30=\"\"),N28,IF(M30=\"\",N28-L30,IF((P28-M30)>=0,N28,N28-1))))","v":""},null,{"$f":"IF(E31=\"\",\"\",IF(M30=\"\",P28,IF((P28-M30)>=0,P28-M30,P28+$D$9-M30)))","v":""},null,null,null,null,null,{"$f":"IF(E31=\"\",\"\",IF(AND(C30=\"時季指定\",DATEDIF(E30,E31,\"d\")+1+Y28>$X$6),\"!ERROR!\",DATEDIF(E30,E31,\"d\")+1))","v":""},{"$f":"IF(AND(C30=\"時季指定\",H30=\"半休\",0.5+Y28>$X$6),\"!ERROR!\",IF(H30=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J31=\"\",\"\",IF(OR(C30=\"時季指定\",C30=\"計画的付与\"),\"!ERROR!\",J31-J30))","v":""},{"$f":"IF(L30=\"\",Y28,Y28+L30)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R32=\"取消\",\"\",IF(X32=\"\",\"\",IF(X32>$D$9,\"!ERROR!\",IF(X32/$G$9=INT(X32/$G$9),X32,\"!ERROR!\"))))","v":""},{"$f":"IF(E33=\"\",\"\",IF(AND(L32=\"\",M32=\"\"),N30,IF(M32=\"\",N30-L32,IF((P30-M32)>=0,N30,N30-1))))","v":""},null,{"$f":"IF(E33=\"\",\"\",IF(M32=\"\",P30,IF((P30-M32)>=0,P30-M32,P30+$D$9-M32)))","v":""},null,null,null,null,null,{"$f":"IF(E33=\"\",\"\",IF(AND(C32=\"時季指定\",DATEDIF(E32,E33,\"d\")+1+Y30>$X$6),\"!ERROR!\",DATEDIF(E32,E33,\"d\")+1))","v":""},{"$f":"IF(AND(C32=\"時季指定\",H32=\"半休\",0.5+Y30>$X$6),\"!ERROR!\",IF(H32=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J33=\"\",\"\",IF(OR(C32=\"時季指定\",C32=\"計画的付与\"),\"!ERROR!\",J33-J32))","v":""},{"$f":"IF(L32=\"\",Y30,Y30+L32)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R34=\"取消\",\"\",IF(X34=\"\",\"\",IF(X34>$D$9,\"!ERROR!\",IF(X34/$G$9=INT(X34/$G$9),X34,\"!ERROR!\"))))","v":""},{"$f":"IF(E35=\"\",\"\",IF(AND(L34=\"\",M34=\"\"),N32,IF(M34=\"\",N32-L34,IF((P32-M34)>=0,N32,N32-1))))","v":""},null,{"$f":"IF(E35=\"\",\"\",IF(M34=\"\",P32,IF((P32-M34)>=0,P32-M34,P32+$D$9-M34)))","v":""},null,null,null,null,null,{"$f":"IF(E35=\"\",\"\",IF(AND(C34=\"時季指定\",DATEDIF(E34,E35,\"d\")+1+Y32>$X$6),\"!ERROR!\",DATEDIF(E34,E35,\"d\")+1))","v":""},{"$f":"IF(AND(C34=\"時季指定\",H34=\"半休\",0.5+Y32>$X$6),\"!ERROR!\",IF(H34=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J35=\"\",\"\",IF(OR(C34=\"時季指定\",C34=\"計画的付与\"),\"!ERROR!\",J35-J34))","v":""},{"$f":"IF(L34=\"\",Y32,Y32+L34)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R36=\"取消\",\"\",IF(X36=\"\",\"\",IF(X36>$D$9,\"!ERROR!\",IF(X36/$G$9=INT(X36/$G$9),X36,\"!ERROR!\"))))","v":""},{"$f":"IF(E37=\"\",\"\",IF(AND(L36=\"\",M36=\"\"),N34,IF(M36=\"\",N34-L36,IF((P34-M36)>=0,N34,N34-1))))","v":""},null,{"$f":"IF(E37=\"\",\"\",IF(M36=\"\",P34,IF((P34-M36)>=0,P34-M36,P34+$D$9-M36)))","v":""},null,null,null,null,null,{"$f":"IF(E37=\"\",\"\",IF(AND(C36=\"時季指定\",DATEDIF(E36,E37,\"d\")+1+Y34>$X$6),\"!ERROR!\",DATEDIF(E36,E37,\"d\")+1))","v":""},{"$f":"IF(AND(C36=\"時季指定\",H36=\"半休\",0.5+Y34>$X$6),\"!ERROR!\",IF(H36=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J37=\"\",\"\",IF(OR(C36=\"時季指定\",C36=\"計画的付与\"),\"!ERROR!\",J37-J36))","v":""},{"$f":"IF(L36=\"\",Y34,Y34+L36)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R38=\"取消\",\"\",IF(X38=\"\",\"\",IF(X38>$D$9,\"!ERROR!\",IF(X38/$G$9=INT(X38/$G$9),X38,\"!ERROR!\"))))","v":""},{"$f":"IF(E39=\"\",\"\",IF(AND(L38=\"\",M38=\"\"),N36,IF(M38=\"\",N36-L38,IF((P36-M38)>=0,N36,N36-1))))","v":""},null,{"$f":"IF(E39=\"\",\"\",IF(M38=\"\",P36,IF((P36-M38)>=0,P36-M38,P36+$D$9-M38)))","v":""},null,null,null,null,null,{"$f":"IF(E39=\"\",\"\",IF(AND(C38=\"時季指定\",DATEDIF(E38,E39,\"d\")+1+Y36>$X$6),\"!ERROR!\",DATEDIF(E38,E39,\"d\")+1))","v":""},{"$f":"IF(AND(C38=\"時季指定\",H38=\"半休\",0.5+Y36>$X$6),\"!ERROR!\",IF(H38=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J39=\"\",\"\",IF(OR(C38=\"時季指定\",C38=\"計画的付与\"),\"!ERROR!\",J39-J38))","v":""},{"$f":"IF(L38=\"\",Y36,Y36+L38)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R40=\"取消\",\"\",IF(X40=\"\",\"\",IF(X40>$D$9,\"!ERROR!\",IF(X40/$G$9=INT(X40/$G$9),X40,\"!ERROR!\"))))","v":""},{"$f":"IF(E41=\"\",\"\",IF(AND(L40=\"\",M40=\"\"),N38,IF(M40=\"\",N38-L40,IF((P38-M40)>=0,N38,N38-1))))","v":""},null,{"$f":"IF(E41=\"\",\"\",IF(M40=\"\",P38,IF((P38-M40)>=0,P38-M40,P38+$D$9-M40)))","v":""},null,null,null,null,null,{"$f":"IF(E41=\"\",\"\",IF(AND(C40=\"時季指定\",DATEDIF(E40,E41,\"d\")+1+Y38>$X$6),\"!ERROR!\",DATEDIF(E40,E41,\"d\")+1))","v":""},{"$f":"IF(AND(C40=\"時季指定\",H40=\"半休\",0.5+Y38>$X$6),\"!ERROR!\",IF(H40=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J41=\"\",\"\",IF(OR(C40=\"時季指定\",C40=\"計画的付与\"),\"!ERROR!\",J41-J40))","v":""},{"$f":"IF(L40=\"\",Y38,Y38+L40)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R42=\"取消\",\"\",IF(X42=\"\",\"\",IF(X42>$D$9,\"!ERROR!\",IF(X42/$G$9=INT(X42/$G$9),X42,\"!ERROR!\"))))","v":""},{"$f":"IF(E43=\"\",\"\",IF(AND(L42=\"\",M42=\"\"),N40,IF(M42=\"\",N40-L42,IF((P40-M42)>=0,N40,N40-1))))","v":""},null,{"$f":"IF(E43=\"\",\"\",IF(M42=\"\",P40,IF((P40-M42)>=0,P40-M42,P40+$D$9-M42)))","v":""},null,null,null,null,null,{"$f":"IF(E43=\"\",\"\",IF(AND(C42=\"時季指定\",DATEDIF(E42,E43,\"d\")+1+Y40>$X$6),\"!ERROR!\",DATEDIF(E42,E43,\"d\")+1))","v":""},{"$f":"IF(AND(C42=\"時季指定\",H42=\"半休\",0.5+Y40>$X$6),\"!ERROR!\",IF(H42=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J43=\"\",\"\",IF(OR(C42=\"時季指定\",C42=\"計画的付与\"),\"!ERROR!\",J43-J42))","v":""},{"$f":"IF(L42=\"\",Y40,Y40+L42)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R44=\"取消\",\"\",IF(X44=\"\",\"\",IF(X44>$D$9,\"!ERROR!\",IF(X44/$G$9=INT(X44/$G$9),X44,\"!ERROR!\"))))","v":""},{"$f":"IF(E45=\"\",\"\",IF(AND(L44=\"\",M44=\"\"),N42,IF(M44=\"\",N42-L44,IF((P42-M44)>=0,N42,N42-1))))","v":""},null,{"$f":"IF(E45=\"\",\"\",IF(M44=\"\",P42,IF((P42-M44)>=0,P42-M44,P42+$D$9-M44)))","v":""},null,null,null,null,null,{"$f":"IF(E45=\"\",\"\",IF(AND(C44=\"時季指定\",DATEDIF(E44,E45,\"d\")+1+Y42>$X$6),\"!ERROR!\",DATEDIF(E44,E45,\"d\")+1))","v":""},{"$f":"IF(AND(C44=\"時季指定\",H44=\"半休\",0.5+Y42>$X$6),\"!ERROR!\",IF(H44=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J45=\"\",\"\",IF(OR(C44=\"時季指定\",C44=\"計画的付与\"),\"!ERROR!\",J45-J44))","v":""},{"$f":"IF(L44=\"\",Y42,Y42+L44)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R46=\"取消\",\"\",IF(X46=\"\",\"\",IF(X46>$D$9,\"!ERROR!\",IF(X46/$G$9=INT(X46/$G$9),X46,\"!ERROR!\"))))","v":""},{"$f":"IF(E47=\"\",\"\",IF(AND(L46=\"\",M46=\"\"),N44,IF(M46=\"\",N44-L46,IF((P44-M46)>=0,N44,N44-1))))","v":""},null,{"$f":"IF(E47=\"\",\"\",IF(M46=\"\",P44,IF((P44-M46)>=0,P44-M46,P44+$D$9-M46)))","v":""},null,null,null,null,null,{"$f":"IF(E47=\"\",\"\",IF(AND(C46=\"時季指定\",DATEDIF(E46,E47,\"d\")+1+Y44>$X$6),\"!ERROR!\",DATEDIF(E46,E47,\"d\")+1))","v":""},{"$f":"IF(AND(C46=\"時季指定\",H46=\"半休\",0.5+Y44>$X$6),\"!ERROR!\",IF(H46=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J47=\"\",\"\",IF(OR(C46=\"時季指定\",C46=\"計画的付与\"),\"!ERROR!\",J47-J46))","v":""},{"$f":"IF(L46=\"\",Y44,Y44+L46)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R48=\"取消\",\"\",IF(X48=\"\",\"\",IF(X48>$D$9,\"!ERROR!\",IF(X48/$G$9=INT(X48/$G$9),X48,\"!ERROR!\"))))","v":""},{"$f":"IF(E49=\"\",\"\",IF(AND(L48=\"\",M48=\"\"),N46,IF(M48=\"\",N46-L48,IF((P46-M48)>=0,N46,N46-1))))","v":""},null,{"$f":"IF(E49=\"\",\"\",IF(M48=\"\",P46,IF((P46-M48)>=0,P46-M48,P46+$D$9-M48)))","v":""},null,null,null,null,null,{"$f":"IF(E49=\"\",\"\",IF(AND(C48=\"時季指定\",DATEDIF(E48,E49,\"d\")+1+Y46>$X$6),\"!ERROR!\",DATEDIF(E48,E49,\"d\")+1))","v":""},{"$f":"IF(AND(C48=\"時季指定\",H48=\"半休\",0.5+Y46>$X$6),\"!ERROR!\",IF(H48=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J49=\"\",\"\",IF(OR(C48=\"時季指定\",C48=\"計画的付与\"),\"!ERROR!\",J49-J48))","v":""},{"$f":"IF(L48=\"\",Y46,Y46+L48)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R50=\"取消\",\"\",IF(X50=\"\",\"\",IF(X50>$D$9,\"!ERROR!\",IF(X50/$G$9=INT(X50/$G$9),X50,\"!ERROR!\"))))","v":""},{"$f":"IF(E51=\"\",\"\",IF(AND(L50=\"\",M50=\"\"),N48,IF(M50=\"\",N48-L50,IF((P48-M50)>=0,N48,N48-1))))","v":""},null,{"$f":"IF(E51=\"\",\"\",IF(M50=\"\",P48,IF((P48-M50)>=0,P48-M50,P48+$D$9-M50)))","v":""},null,null,null,null,null,{"$f":"IF(E51=\"\",\"\",IF(AND(C50=\"時季指定\",DATEDIF(E50,E51,\"d\")+1+Y48>$X$6),\"!ERROR!\",DATEDIF(E50,E51,\"d\")+1))","v":""},{"$f":"IF(AND(C50=\"時季指定\",H50=\"半休\",0.5+Y48>$X$6),\"!ERROR!\",IF(H50=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J51=\"\",\"\",IF(OR(C50=\"時季指定\",C50=\"計画的付与\"),\"!ERROR!\",J51-J50))","v":""},{"$f":"IF(L50=\"\",Y48,Y48+L50)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R52=\"取消\",\"\",IF(X52=\"\",\"\",IF(X52>$D$9,\"!ERROR!\",IF(X52/$G$9=INT(X52/$G$9),X52,\"!ERROR!\"))))","v":""},{"$f":"IF(E53=\"\",\"\",IF(AND(L52=\"\",M52=\"\"),N50,IF(M52=\"\",N50-L52,IF((P50-M52)>=0,N50,N50-1))))","v":""},null,{"$f":"IF(E53=\"\",\"\",IF(M52=\"\",P50,IF((P50-M52)>=0,P50-M52,P50+$D$9-M52)))","v":""},null,null,null,null,null,{"$f":"IF(E53=\"\",\"\",IF(AND(C52=\"時季指定\",DATEDIF(E52,E53,\"d\")+1+Y50>$X$6),\"!ERROR!\",DATEDIF(E52,E53,\"d\")+1))","v":""},{"$f":"IF(AND(C52=\"時季指定\",H52=\"半休\",0.5+Y50>$X$6),\"!ERROR!\",IF(H52=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J53=\"\",\"\",IF(OR(C52=\"時季指定\",C52=\"計画的付与\"),\"!ERROR!\",J53-J52))","v":""},{"$f":"IF(L52=\"\",Y50,Y50+L52)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R54=\"取消\",\"\",IF(X54=\"\",\"\",IF(X54>$D$9,\"!ERROR!\",IF(X54/$G$9=INT(X54/$G$9),X54,\"!ERROR!\"))))","v":""},{"$f":"IF(E55=\"\",\"\",IF(AND(L54=\"\",M54=\"\"),N52,IF(M54=\"\",N52-L54,IF((P52-M54)>=0,N52,N52-1))))","v":""},null,{"$f":"IF(E55=\"\",\"\",IF(M54=\"\",P52,IF((P52-M54)>=0,P52-M54,P52+$D$9-M54)))","v":""},null,null,null,null,null,{"$f":"IF(E55=\"\",\"\",IF(AND(C54=\"時季指定\",DATEDIF(E54,E55,\"d\")+1+Y52>$X$6),\"!ERROR!\",DATEDIF(E54,E55,\"d\")+1))","v":""},{"$f":"IF(AND(C54=\"時季指定\",H54=\"半休\",0.5+Y52>$X$6),\"!ERROR!\",IF(H54=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J55=\"\",\"\",IF(OR(C54=\"時季指定\",C54=\"計画的付与\"),\"!ERROR!\",J55-J54))","v":""},{"$f":"IF(L54=\"\",Y52,Y52+L54)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R56=\"取消\",\"\",IF(X56=\"\",\"\",IF(X56>$D$9,\"!ERROR!\",IF(X56/$G$9=INT(X56/$G$9),X56,\"!ERROR!\"))))","v":""},{"$f":"IF(E57=\"\",\"\",IF(AND(L56=\"\",M56=\"\"),N54,IF(M56=\"\",N54-L56,IF((P54-M56)>=0,N54,N54-1))))","v":""},null,{"$f":"IF(E57=\"\",\"\",IF(M56=\"\",P54,IF((P54-M56)>=0,P54-M56,P54+$D$9-M56)))","v":""},null,null,null,null,null,{"$f":"IF(E57=\"\",\"\",IF(AND(C56=\"時季指定\",DATEDIF(E56,E57,\"d\")+1+Y54>$X$6),\"!ERROR!\",DATEDIF(E56,E57,\"d\")+1))","v":""},{"$f":"IF(AND(C56=\"時季指定\",H56=\"半休\",0.5+Y54>$X$6),\"!ERROR!\",IF(H56=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J57=\"\",\"\",IF(OR(C56=\"時季指定\",C56=\"計画的付与\"),\"!ERROR!\",J57-J56))","v":""},{"$f":"IF(L56=\"\",Y54,Y54+L56)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R58=\"取消\",\"\",IF(X58=\"\",\"\",IF(X58>$D$9,\"!ERROR!\",IF(X58/$G$9=INT(X58/$G$9),X58,\"!ERROR!\"))))","v":""},{"$f":"IF(E59=\"\",\"\",IF(AND(L58=\"\",M58=\"\"),N56,IF(M58=\"\",N56-L58,IF((P56-M58)>=0,N56,N56-1))))","v":""},null,{"$f":"IF(E59=\"\",\"\",IF(M58=\"\",P56,IF((P56-M58)>=0,P56-M58,P56+$D$9-M58)))","v":""},null,null,null,null,null,{"$f":"IF(E59=\"\",\"\",IF(AND(C58=\"時季指定\",DATEDIF(E58,E59,\"d\")+1+Y56>$X$6),\"!ERROR!\",DATEDIF(E58,E59,\"d\")+1))","v":""},{"$f":"IF(AND(C58=\"時季指定\",H58=\"半休\",0.5+Y56>$X$6),\"!ERROR!\",IF(H58=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J59=\"\",\"\",IF(OR(C58=\"時季指定\",C58=\"計画的付与\"),\"!ERROR!\",J59-J58))","v":""},{"$f":"IF(L58=\"\",Y56,Y56+L58)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R60=\"取消\",\"\",IF(X60=\"\",\"\",IF(X60>$D$9,\"!ERROR!\",IF(X60/$G$9=INT(X60/$G$9),X60,\"!ERROR!\"))))","v":""},{"$f":"IF(E61=\"\",\"\",IF(AND(L60=\"\",M60=\"\"),N58,IF(M60=\"\",N58-L60,IF((P58-M60)>=0,N58,N58-1))))","v":""},null,{"$f":"IF(E61=\"\",\"\",IF(M60=\"\",P58,IF((P58-M60)>=0,P58-M60,P58+$D$9-M60)))","v":""},null,null,null,null,null,{"$f":"IF(E61=\"\",\"\",IF(AND(C60=\"時季指定\",DATEDIF(E60,E61,\"d\")+1+Y58>$X$6),\"!ERROR!\",DATEDIF(E60,E61,\"d\")+1))","v":""},{"$f":"IF(AND(C60=\"時季指定\",H60=\"半休\",0.5+Y58>$X$6),\"!ERROR!\",IF(H60=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J61=\"\",\"\",IF(OR(C60=\"時季指定\",C60=\"計画的付与\"),\"!ERROR!\",J61-J60))","v":""},{"$f":"IF(L60=\"\",Y58,Y58+L60)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R62=\"取消\",\"\",IF(X62=\"\",\"\",IF(X62>$D$9,\"!ERROR!\",IF(X62/$G$9=INT(X62/$G$9),X62,\"!ERROR!\"))))","v":""},{"$f":"IF(E63=\"\",\"\",IF(AND(L62=\"\",M62=\"\"),N60,IF(M62=\"\",N60-L62,IF((P60-M62)>=0,N60,N60-1))))","v":""},null,{"$f":"IF(E63=\"\",\"\",IF(M62=\"\",P60,IF((P60-M62)>=0,P60-M62,P60+$D$9-M62)))","v":""},null,null,null,null,null,{"$f":"IF(E63=\"\",\"\",IF(AND(C62=\"時季指定\",DATEDIF(E62,E63,\"d\")+1+Y60>$X$6),\"!ERROR!\",DATEDIF(E62,E63,\"d\")+1))","v":""},{"$f":"IF(AND(C62=\"時季指定\",H62=\"半休\",0.5+Y60>$X$6),\"!ERROR!\",IF(H62=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J63=\"\",\"\",IF(OR(C62=\"時季指定\",C62=\"計画的付与\"),\"!ERROR!\",J63-J62))","v":""},{"$f":"IF(L62=\"\",Y60,Y60+L62)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R64=\"取消\",\"\",IF(X64=\"\",\"\",IF(X64>$D$9,\"!ERROR!\",IF(X64/$G$9=INT(X64/$G$9),X64,\"!ERROR!\"))))","v":""},{"$f":"IF(E65=\"\",\"\",IF(AND(L64=\"\",M64=\"\"),N62,IF(M64=\"\",N62-L64,IF((P62-M64)>=0,N62,N62-1))))","v":""},null,{"$f":"IF(E65=\"\",\"\",IF(M64=\"\",P62,IF((P62-M64)>=0,P62-M64,P62+$D$9-M64)))","v":""},null,null,null,null,null,{"$f":"IF(E65=\"\",\"\",IF(AND(C64=\"時季指定\",DATEDIF(E64,E65,\"d\")+1+Y62>$X$6),\"!ERROR!\",DATEDIF(E64,E65,\"d\")+1))","v":""},{"$f":"IF(AND(C64=\"時季指定\",H64=\"半休\",0.5+Y62>$X$6),\"!ERROR!\",IF(H64=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J65=\"\",\"\",IF(OR(C64=\"時季指定\",C64=\"計画的付与\"),\"!ERROR!\",J65-J64))","v":""},{"$f":"IF(L64=\"\",Y62,Y62+L64)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R66=\"取消\",\"\",IF(X66=\"\",\"\",IF(X66>$D$9,\"!ERROR!\",IF(X66/$G$9=INT(X66/$G$9),X66,\"!ERROR!\"))))","v":""},{"$f":"IF(E67=\"\",\"\",IF(AND(L66=\"\",M66=\"\"),N64,IF(M66=\"\",N64-L66,IF((P64-M66)>=0,N64,N64-1))))","v":""},null,{"$f":"IF(E67=\"\",\"\",IF(M66=\"\",P64,IF((P64-M66)>=0,P64-M66,P64+$D$9-M66)))","v":""},null,null,null,null,null,{"$f":"IF(E67=\"\",\"\",IF(AND(C66=\"時季指定\",DATEDIF(E66,E67,\"d\")+1+Y64>$X$6),\"!ERROR!\",DATEDIF(E66,E67,\"d\")+1))","v":""},{"$f":"IF(AND(C66=\"時季指定\",H66=\"半休\",0.5+Y64>$X$6),\"!ERROR!\",IF(H66=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J67=\"\",\"\",IF(OR(C66=\"時季指定\",C66=\"計画的付与\"),\"!ERROR!\",J67-J66))","v":""},{"$f":"IF(L66=\"\",Y64,Y64+L66)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R68=\"取消\",\"\",IF(X68=\"\",\"\",IF(X68>$D$9,\"!ERROR!\",IF(X68/$G$9=INT(X68/$G$9),X68,\"!ERROR!\"))))","v":""},{"$f":"IF(E69=\"\",\"\",IF(AND(L68=\"\",M68=\"\"),N66,IF(M68=\"\",N66-L68,IF((P66-M68)>=0,N66,N66-1))))","v":""},null,{"$f":"IF(E69=\"\",\"\",IF(M68=\"\",P66,IF((P66-M68)>=0,P66-M68,P66+$D$9-M68)))","v":""},null,null,null,null,null,{"$f":"IF(E69=\"\",\"\",IF(AND(C68=\"時季指定\",DATEDIF(E68,E69,\"d\")+1+Y66>$X$6),\"!ERROR!\",DATEDIF(E68,E69,\"d\")+1))","v":""},{"$f":"IF(AND(C68=\"時季指定\",H68=\"半休\",0.5+Y66>$X$6),\"!ERROR!\",IF(H68=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J69=\"\",\"\",IF(OR(C68=\"時季指定\",C68=\"計画的付与\"),\"!ERROR!\",J69-J68))","v":""},{"$f":"IF(L68=\"\",Y66,Y66+L68)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R70=\"取消\",\"\",IF(X70=\"\",\"\",IF(X70>$D$9,\"!ERROR!\",IF(X70/$G$9=INT(X70/$G$9),X70,\"!ERROR!\"))))","v":""},{"$f":"IF(E71=\"\",\"\",IF(AND(L70=\"\",M70=\"\"),N68,IF(M70=\"\",N68-L70,IF((P68-M70)>=0,N68,N68-1))))","v":""},null,{"$f":"IF(E71=\"\",\"\",IF(M70=\"\",P68,IF((P68-M70)>=0,P68-M70,P68+$D$9-M70)))","v":""},null,null,null,null,null,{"$f":"IF(E71=\"\",\"\",IF(AND(C70=\"時季指定\",DATEDIF(E70,E71,\"d\")+1+Y68>$X$6),\"!ERROR!\",DATEDIF(E70,E71,\"d\")+1))","v":""},{"$f":"IF(AND(C70=\"時季指定\",H70=\"半休\",0.5+Y68>$X$6),\"!ERROR!\",IF(H70=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J71=\"\",\"\",IF(OR(C70=\"時季指定\",C70=\"計画的付与\"),\"!ERROR!\",J71-J70))","v":""},{"$f":"IF(L70=\"\",Y68,Y68+L70)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]
[null,null,null,null,null,null,"から",null,null,null,"時から","",{"$f":"IF(R72=\"取消\",\"\",IF(X72=\"\",\"\",IF(X72>$D$9,\"!ERROR!\",IF(X72/$G$9=INT(X72/$G$9),X72,\"!ERROR!\"))))","v":""},{"$f":"IF(E73=\"\",\"\",IF(AND(L72=\"\",M72=\"\"),N70,IF(M72=\"\",N70-L72,IF((P70-M72)>=0,N70,N70-1))))","v":""},null,{"$f":"IF(E73=\"\",\"\",IF(M72=\"\",P70,IF((P70-M72)>=0,P70-M72,P70+$D$9-M72)))","v":""},null,null,null,null,null,{"$f":"IF(E73=\"\",\"\",IF(AND(C72=\"時季指定\",DATEDIF(E72,E73,\"d\")+1+Y70>$X$6),\"!ERROR!\",DATEDIF(E72,E73,\"d\")+1))","v":""},{"$f":"IF(AND(C72=\"時季指定\",H72=\"半休\",0.5+Y70>$X$6),\"!ERROR!\",IF(H72=\"半休\",0.5,\"\"))","v":""},{"$f":"IF(J73=\"\",\"\",IF(OR(C72=\"時季指定\",C72=\"計画的付与\"),\"!ERROR!\",J73-J72))","v":""},{"$f":"IF(L72=\"\",Y70,Y70+L72)","v":0}]
[null,null,null,null,null,null,"まで",null,null,null,"時まで"]

{"sheet":"使用条件及び免責事項","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["使用条件及び免責事項"]
[]
["・年次有給休暇管理簿（一覧）（以下、「本ツール」という。）の有償再頒布を禁じます。"]
["・本ツールは無償で提供されますが、何の欠陥も無いという無制限の保証を行うものではありません。"]
["・本ツールを使用することによって生じるいかなる問題や損害について、全国社会保険労務士会連合会はその責を負いません。"]
["・本ツールのご利用はご自身の責任において行ってください。"]
[]
["©全国社会保険労務士会連合会"]
["2019-10-15","Ver. 1.1"]