{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["更新履歴","関連就業規則","基本設定","記入用紙","提出用原紙","祝日一覧","202012"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":2,"defined_names":72,"comments":1,"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":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Date","Ver","追加修正箇所","概要","詳細"]
["2004-05-07","1.00","新規作成","新規作成"]
["2004-05-24","1.01","機能追加","代休消化時間算出"]
[null,null,null,"当月標準出勤日数算出","標準出勤日数 = 当月日数 - 公休日"]
["2007-12-14","1.02","計算式修正","勤務証明書、時間外休日欄(休日=休日-深夜)"]
["2009-04-15","2.00","機能追加","・遅刻、早退の加算、提出用原紙への反映","※種別 ： 遅刻は１（○）、早退は０（●）があるもののみ計算し提出用原紙に反映"]
["2009-04-16","2.00","ボタン追加","提出用証明書作成","ボタン押下で自動的に提出用の勤務表を作成します"]
["2009-04-16","2.00","ボタン追加","記入用紙翌月更新","ボタン押下で自動的に記入用紙の項目をクリアし、翌月に更新します"]
["2009-04-17","2.00","関連就業規則追加"]
["2020-10-15","3.00","計算式修正","記入用紙\n欠勤・勤怠種別の計算式に所定休日を追加","公休以外に所定休日を追加\n例えば、参画先のプロジェクト休や常駐先の創立記念日で休みなど、土日祝日以外での休みが発生したとき（祝日一覧には乗らない、急遽の休みに対応）"]

{"sheet":"関連就業規則","index":1,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,0,20,28]]}
[]
[null,"就業規則"]
[]
[null,"１４",null,null,"終業時間",null,null,null,null,"始業時間は9時00分、終業時間18時00分を標準終業時間とする"]
[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,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,null,null,null,"②","毎土曜日"]
[null,null,null,null,null,null,null,null,null,null,"③","国民の休日"]
[null,null,null,null,null,null,null,null,null,null,"④","年末年始"]
[]
[]
[]
[]
["09/04/17現在　再掲載　就業規則より抜粋"]
["※Wordのオブジェクトをそのまま貼り付けていますので確認に際はオブジェクトをカーソル合わせ、ダブルクリックするとスクロールするようになります。"]

{"sheet":"基本設定","index":2,"n_rows":49,"n_cols":48,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,11,2,15],[2,16,2,20],[3,11,3,15],[3,16,3,20],[27,9,28,11],[28,33,28,34],[5,6,5,10],[28,25,28,26],[28,21,28,22],[28,31,28,32],[27,15,28,17],[27,12,28,14],[2,6,2,10],[3,6,3,10],[4,6,4,10],[22,52,22,53],[28,41,28,42],[28,39,28,40],[28,47,28,48],[28,43,28,44],[27,21,27,48],[28,37,28,38],[27,18,28,20],[28,45,28,46],[29,37,29,38],[28,29,28,30],[28,23,28,24],[29,33,29,34],[29,35,29,36],[29,29,29,30],[29,23,29,24],[29,31,29,32],[20,46,20,47],[28,27,28,28],[28,35,28,36],[6,1,6,5],[6,6,6,10],[7,1,7,5],[7,6,7,10],[18,44,18,45],[29,27,29,28],[30,27,30,28],[29,47,29,48],[29,45,29,46],[29,41,29,42],[29,43,29,44],[29,39,29,40],[30,47,30,48],[30,45,30,46],[30,29,30,30],[30,31,30,32],[30,33,30,34],[30,37,30,38],[30,43,30,44],[30,35,30,36],[30,39,30,40],[30,41,30,42],[29,12,29,14],[29,2,29,8],[29,25,29,26],[29,15,29,17],[30,21,30,22],[30,23,30,24],[30,25,30,26],[29,21,29,22],[29,18,29,20],[31,25,31,26],[30,18,30,20],[30,15,30,17],[32,18,32,20],[32,2,32,8],[32,9,32,11],[32,12,32,14],[32,15,32,17],[31,2,31,8],[31,9,31,11],[31,18,31,20],[31,12,31,14],[31,15,31,17],[31,27,31,28],[31,21,31,22],[31,29,31,30],[31,45,31,46],[31,35,31,36],[31,37,31,38],[31,39,31,40],[31,41,31,42],[32,47,32,48],[32,45,32,46],[32,35,32,36],[32,37,32,38],[32,43,32,44],[31,47,31,48],[31,43,31,44],[32,25,32,26],[32,29,32,30],[32,41,32,42],[32,39,32,40],[31,31,31,32],[31,33,31,34],[32,31,32,32],[32,33,32,34],[31,23,31,24],[34,12,34,14],[34,15,34,17],[33,29,33,30],[34,21,34,22],[34,23,34,24],[34,27,34,28],[34,29,34,30],[33,12,33,14],[33,15,33,17],[33,21,33,22],[34,43,34,44],[35,27,35,28],[33,39,33,40],[33,41,33,42],[33,18,33,20],[33,25,33,26],[33,27,33,28],[33,23,33,24],[33,37,33,38],[33,33,33,34],[33,31,33,32],[34,18,34,20],[35,25,35,26],[35,18,35,20],[34,25,34,26],[35,21,35,22],[35,35,35,36],[32,23,32,24],[32,21,32,22],[34,47,34,48],[34,31,34,32],[33,45,33,46],[33,47,33,48],[33,43,33,44],[33,35,33,36],[32,27,32,28],[35,23,35,24],[34,33,34,34],[35,37,35,38],[35,29,35,30],[34,45,34,46],[34,41,34,42],[34,35,34,36],[34,37,34,38],[34,39,34,40],[35,15,35,17],[36,25,36,26],[38,12,38,14],[36,29,36,30],[35,39,35,40],[36,12,36,14],[36,15,36,17],[35,31,35,32],[35,33,35,34],[36,27,36,28],[37,33,37,34],[36,31,36,32],[38,27,38,28],[38,21,38,22],[36,21,36,22],[38,31,38,32],[38,29,38,30],[36,18,36,20],[36,23,36,24],[36,33,36,34],[36,35,36,36],[35,47,35,48],[36,41,36,42],[36,39,36,40],[35,43,35,44],[35,45,35,46],[37,47,37,48],[35,41,35,42],[37,45,37,46],[36,47,36,48],[36,45,36,46],[37,23,37,24],[37,31,37,32],[37,21,37,22],[37,27,37,28],[37,29,37,30],[37,12,37,14],[37,25,37,26],[36,43,36,44],[37,39,37,40],[37,41,37,42],[37,43,37,44],[37,37,37,38],[37,35,37,36],[36,37,36,38],[38,41,38,42],[39,27,39,28],[39,31,39,32],[38,2,38,8],[38,15,38,17],[38,25,38,26],[38,23,38,24],[38,9,38,11],[39,39,39,40],[39,41,39,42],[39,12,39,14],[39,15,39,17],[39,25,39,26],[39,21,39,22],[39,23,39,24],[38,18,38,20],[39,18,39,20],[38,45,38,46],[38,39,38,40],[38,37,38,38],[39,43,39,44],[39,29,39,30],[38,35,38,36],[38,33,38,34],[41,47,41,48],[41,45,41,46],[39,47,39,48],[38,43,38,44],[40,47,40,48],[40,43,40,44],[40,45,40,46],[38,47,38,48],[39,45,39,46],[40,37,40,38],[41,37,41,38],[39,33,39,34],[39,35,39,36],[41,33,41,34],[41,35,41,36],[39,37,39,38],[40,41,40,42],[41,43,41,44],[41,25,41,26],[40,27,40,28],[40,25,40,26],[41,41,41,42],[40,31,40,32],[40,33,40,34],[41,31,41,32],[40,39,40,40],[41,39,41,40],[40,35,40,36],[42,2,42,8],[42,9,42,11],[42,12,42,14],[42,15,42,17],[41,23,41,24],[42,21,42,22],[42,33,42,34],[41,18,41,20],[41,2,41,8],[41,9,41,11],[41,12,41,14],[41,15,41,17],[40,2,40,8],[40,9,40,11],[41,21,41,22],[41,27,41,28],[41,29,41,30],[40,12,40,14],[40,15,40,17],[40,23,40,24],[40,29,40,30],[40,21,40,22],[42,29,42,30],[42,43,42,44],[42,23,42,24],[43,31,43,32],[42,47,42,48],[42,45,42,46],[42,37,42,38],[42,39,42,40],[43,27,43,28],[43,29,43,30],[43,25,43,26],[42,35,42,36],[42,31,42,32],[43,33,43,34],[43,45,43,46],[43,35,43,36],[43,37,43,38],[43,39,43,40],[43,41,43,42],[43,43,43,44],[42,25,42,26],[42,27,42,28],[42,41,42,42],[45,47,45,48],[45,27,45,28],[45,29,45,30],[44,29,44,30],[43,12,43,14],[43,21,43,22],[43,23,43,24],[44,2,44,8],[44,9,44,11],[44,12,44,14],[44,15,44,17],[44,21,44,22],[43,15,43,17],[44,18,44,20],[43,47,43,48],[46,23,46,24],[47,2,47,8],[47,9,47,11],[47,45,47,46],[44,47,44,48],[44,41,44,42],[45,2,45,8],[45,9,45,11],[45,12,45,14],[45,15,45,17],[44,25,44,26],[44,23,44,24],[45,23,45,24],[45,25,45,26],[44,45,44,46],[45,43,45,44],[45,45,45,46],[45,31,45,32],[45,39,45,40],[44,35,44,36],[44,37,44,38],[44,43,44,44],[45,41,45,42],[44,39,44,40],[48,23,48,24],[48,2,48,8],[48,9,48,11],[48,12,48,14],[48,15,48,17],[47,23,47,24],[48,39,48,40],[48,41,48,42],[48,25,48,26],[48,27,48,28],[48,35,48,36],[48,33,48,34],[48,31,48,32],[48,29,48,30],[48,21,48,22],[48,43,48,44],[48,45,48,46],[47,47,47,48],[47,43,47,44],[48,47,48,48],[47,25,47,26],[46,35,46,36],[46,37,46,38],[47,37,47,38],[46,25,46,26],[46,29,46,30],[46,27,46,28],[46,39,46,40],[46,41,46,42],[46,47,46,48],[48,37,48,38],[46,45,46,46],[45,33,45,34],[45,35,45,36],[45,37,45,38],[44,31,44,32],[44,33,44,34],[46,43,46,44],[47,27,47,28],[47,35,47,36],[46,33,46,34],[47,33,47,34],[46,31,46,32],[47,31,47,32],[47,29,47,30],[47,39,47,40],[47,41,47,42],[44,27,44,28],[48,18,48,20],[40,18,40,20],[47,21,47,22],[43,2,43,8],[43,9,43,11],[45,21,45,22],[47,12,47,14],[47,15,47,17],[37,18,37,20],[46,2,46,8],[46,9,46,11],[46,12,46,14],[46,15,46,17],[46,21,46,22],[46,18,46,20],[39,2,39,8],[39,9,39,11],[37,2,37,8],[37,9,37,11],[2,1,2,5],[3,1,3,5],[4,1,4,5],[29,9,29,11],[47,18,47,20],[36,9,36,11],[45,18,45,20],[37,15,37,17],[43,18,43,20],[42,18,42,20],[5,1,5,5],[33,2,33,8],[33,9,33,11],[36,2,36,8],[35,2,35,8],[35,9,35,11],[34,2,34,8],[34,9,34,11],[27,1,28,1],[27,2,28,8],[30,2,30,8],[30,9,30,11],[30,12,30,14],[35,12,35,14]]}
[]
[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,"勤務先A"]
[null,"深夜時間帯開始",null,null,null,null,"22:00:00",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":"IF(Y5<>\"\",$BH$38,\"\")","v":""}]
[null,"深夜時間帯終了",null,null,null,null,"05:00:00"]
[null,"標準勤務地",null,null,null,null,2]
[null,"勤務表Version",null,null,null,null,2]
[]
[]
[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,null,null,null,null,"年",null,null,"月"]
[null,1,1]
[null,2]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"＊","内部機能は未完成です。"]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,9]
[null,10]
[null,11]
[null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[null,"■","勤務地作業時間一覧"]
[null,"#","会社名",null,null,null,null,null,null,"開始時間",null,null,"終了時間",null,null,"作業時間",null,null,"Flex",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,1,"M's Computer",null,null,null,null,null,null,"09:00:00",null,null,"18:00:00",null,null,{"$f":"IF(OR(J30=\"\",M30=\"\"),0,IF(ROUNDUP(M30*96,0)/96>ROUNDUP(J30*96,0)/96,((ROUNDUP(M30*96,0)/96)-(ROUNDUP(J30*96,0)/96))*24,\"ＮＧ\"))\n-IF(AND(J30<V30,M30>V30),IF(X30=\"\",0,X30/60),0)\n-IF(AND(J30<Z30,M30>Z30),IF(X30=\"\",0,AB30/60),0)\n-IF(AND(J30<AD30,M30>AD30),IF(X30=\"\",0,AF30/60),0)\n-IF(AND(J30<AH30,M30>AH30),IF(X30=\"\",0,AJ30/60),0)\n-IF(AND(J30<AL30,M30>AL30),IF(X30=\"\",0,AN30/60),0)\n-IF(AND(J30<AP30,M30>AP30),IF(X30=\"\",0,AR30/60),0)\n-IF(AND(J30<AT30,M30>AT30),IF(X30=\"\",0,AW30/60),0)","v":8},null,null,null,null,null,"12:00:00",null,60]
[null,2,"勤務先A",null,null,null,null,null,null,"09:30:00",null,null,"18:30:00",null,null,{"$f":"IF(OR(J31=\"\",M31=\"\"),0,IF(ROUNDUP(M31*96,0)/96>ROUNDUP(J31*96,0)/96,((ROUNDUP(M31*96,0)/96)-(ROUNDUP(J31*96,0)/96))*24,\"ＮＧ\"))\n-IF(AND(J31<V31,M31>V31),IF(X31=\"\",0,X31/60),0)\n-IF(AND(J31<Z31,M31>Z31),IF(X31=\"\",0,AB31/60),0)\n-IF(AND(J31<AD31,M31>AD31),IF(X31=\"\",0,AF31/60),0)\n-IF(AND(J31<AH31,M31>AH31),IF(X31=\"\",0,AJ31/60),0)\n-IF(AND(J31<AL31,M31>AL31),IF(X31=\"\",0,AN31/60),0)\n-IF(AND(J31<AP31,M31>AP31),IF(X31=\"\",0,AR31/60),0)\n-IF(AND(J31<AT31,M31>AT31),IF(X31=\"\",0,AW31/60),0)","v":7.5000000000000018},null,null,"10:00:00",null,null,"12:00:00",null,60,null,"18:00:00",null,30,null,"22:00:00",null,30,null,"02:00:00",null,30,null,"05:00:00",null,180]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,0,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,1.3125,null,90]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"記入用紙","index":3,"n_rows":54,"n_cols":80,"rows_kept":54,"cut":false,"hidden":false,"merged":[[29,58,29,70],[34,58,34,70],[29,73,29,74],[27,73,27,74],[34,73,34,74],[30,43,30,44],[27,45,27,57],[31,58,31,70],[28,43,28,44],[27,58,27,70],[28,58,28,70],[33,71,33,72],[29,71,29,72],[31,45,31,57],[30,45,30,57],[30,73,30,74],[29,45,29,57],[31,73,31,74],[31,43,31,44],[18,73,18,74],[28,73,28,74],[27,43,27,44],[29,43,29,44],[28,45,28,57],[30,71,30,72],[31,71,31,72],[30,58,30,70],[40,67,40,73],[33,73,33,74],[32,73,32,74],[32,45,32,57],[33,45,33,57],[36,59,36,65],[37,59,40,65],[36,67,36,73],[37,67,37,73],[36,56,38,57],[34,71,34,72],[28,71,28,72],[27,71,27,72],[32,58,32,70],[33,58,33,70],[32,71,32,72],[16,71,16,72],[19,71,19,72],[18,71,18,72],[26,58,26,70],[24,58,24,70],[18,58,18,70],[16,58,16,70],[17,71,17,72],[14,58,14,70],[25,58,25,70],[23,58,23,70],[19,45,19,57],[14,45,14,57],[13,45,13,57],[12,58,12,70],[15,58,15,70],[17,58,17,70],[13,58,13,70],[12,45,12,57],[15,45,15,57],[18,45,18,57],[17,45,17,57],[16,45,16,57],[0,58,3,70],[4,58,4,70],[5,58,5,70],[16,37,16,38],[18,37,18,38],[9,37,9,38],[10,37,10,38],[14,37,14,38],[9,41,9,42],[16,39,16,40],[16,41,16,42],[9,39,9,40],[12,37,12,38],[0,45,3,57],[4,39,4,40],[15,39,15,40],[14,39,14,40],[12,39,12,40],[10,39,10,40],[11,39,11,40],[13,39,13,40],[11,58,11,70],[11,45,11,57],[16,43,16,44],[19,73,19,74],[20,71,20,72],[23,45,23,57],[25,73,25,74],[26,73,26,74],[26,71,26,72],[25,71,25,72],[24,37,24,38],[23,41,23,42],[23,37,23,38],[23,39,23,40],[24,39,24,40],[24,41,24,42],[25,39,25,40],[26,37,26,38],[26,41,26,42],[25,41,25,42],[26,39,26,40],[25,37,25,38],[25,43,25,44],[19,58,19,70],[22,45,22,57],[22,58,22,70],[21,45,21,57],[21,71,21,72],[22,71,22,72],[22,75,22,76],[22,73,22,74],[24,73,24,74],[26,43,26,44],[25,45,25,57],[26,45,26,57],[20,73,20,74],[21,73,21,74],[23,43,23,44],[22,43,22,44],[20,58,20,70],[20,45,20,57],[23,73,23,74],[25,77,25,78],[26,77,26,78],[23,77,23,78],[22,41,22,42],[24,45,24,57],[24,43,24,44],[24,71,24,72],[23,71,23,72],[18,75,18,76],[15,75,15,76],[18,77,18,78],[19,75,19,76],[17,75,17,76],[14,77,14,78],[27,77,27,78],[23,75,23,76],[26,75,26,76],[24,75,24,76],[24,77,24,78],[25,75,25,76],[34,75,34,76],[27,75,27,76],[28,75,28,76],[29,75,29,76],[30,75,30,76],[33,75,33,76],[32,75,32,76],[31,75,31,76],[0,77,3,78],[0,75,3,76],[4,75,4,76],[5,75,5,76],[4,77,4,78],[5,77,5,78],[34,77,34,78],[28,77,28,78],[29,77,29,78],[30,77,30,78],[31,77,31,78],[32,77,32,78],[33,77,33,78],[7,75,7,76],[8,75,8,76],[13,77,13,78],[19,24,19,25],[19,26,19,27],[25,24,25,25],[6,77,6,78],[6,75,6,76],[20,75,20,76],[21,58,21,70],[21,75,21,76],[16,75,16,76],[11,75,11,76],[12,73,12,74],[17,73,17,74],[16,73,16,74],[19,31,19,32],[19,39,19,40],[21,39,21,40],[22,39,22,40],[20,39,20,40],[22,37,22,38],[23,33,23,34],[24,33,24,34],[6,45,6,57],[6,35,6,36],[15,73,15,74],[26,24,26,25],[22,31,22,32],[20,24,20,25],[22,24,22,25],[21,26,21,27],[23,26,23,27],[23,29,23,30],[23,31,23,32],[23,24,23,25],[24,24,24,25],[24,31,24,32],[21,24,21,25],[27,24,27,25],[27,29,27,30],[42,29,42,35],[29,31,29,32],[34,33,34,34],[32,35,32,36],[29,35,29,36],[28,29,28,30],[41,29,41,35],[36,26,36,28],[39,26,39,28],[40,29,40,35],[33,26,33,27],[34,31,34,32],[31,35,31,36],[34,29,34,30],[34,26,34,27],[39,29,39,35],[36,29,36,35],[37,29,37,35],[35,29,35,35],[37,26,37,28],[29,33,29,34],[31,33,31,34],[30,33,30,34],[29,29,29,30],[30,29,30,30],[32,37,32,38],[30,35,30,36],[33,35,33,36],[42,36,42,38],[29,41,29,42],[27,41,27,42],[31,41,31,42],[29,37,29,38],[29,39,29,40],[28,37,28,38],[27,37,27,38],[30,41,30,42],[31,37,31,38],[31,39,31,40],[30,39,30,40],[30,37,30,38],[28,39,28,40],[28,41,28,42],[27,39,27,40],[8,37,8,38],[5,31,5,32],[6,26,6,27],[7,26,7,27],[5,45,5,57],[9,29,9,30],[8,29,8,30],[8,31,8,32],[7,33,7,34],[6,33,6,34],[7,35,7,36],[7,71,7,72],[14,71,14,72],[11,73,11,74],[15,71,15,72],[11,71,11,72],[12,71,12,72],[13,71,13,72],[10,71,10,72],[0,73,3,74],[13,73,13,74],[4,73,4,74],[10,73,10,74],[8,73,8,74],[9,73,9,74],[9,71,9,72],[5,73,5,74],[6,73,6,74],[7,73,7,74],[6,71,6,72],[8,71,8,72],[0,71,3,72],[4,71,4,72],[5,71,5,72],[0,8,0,12],[1,2,1,12],[2,11,3,12],[0,39,3,40],[0,43,3,44],[2,2,3,10],[0,3,0,4],[0,0,0,2],[0,5,0,7],[0,20,0,22],[5,29,5,30],[9,26,9,27],[4,24,4,25],[5,24,5,25],[12,24,12,25],[11,24,11,25],[7,24,7,25],[6,24,6,25],[10,24,10,25],[9,24,9,25],[8,26,8,27],[6,29,6,30],[7,29,7,30],[9,11,9,12],[6,3,6,10],[6,11,6,12],[7,11,7,12],[7,3,7,10],[9,3,9,10],[8,11,8,12],[8,3,8,10],[12,3,12,10],[14,3,14,10],[15,3,15,10],[10,11,10,12],[11,11,11,12],[13,11,13,12],[12,11,12,12],[13,3,13,10],[4,3,4,10],[5,3,5,10],[4,11,4,12],[10,3,10,10],[11,3,11,10],[5,11,5,12],[16,11,16,12],[14,11,14,12],[22,11,22,12],[24,11,24,12],[27,11,27,12],[25,11,25,12],[17,3,17,10],[19,3,19,10],[24,3,24,10],[21,3,21,10],[18,11,18,12],[16,3,16,10],[18,3,18,10],[17,11,17,12],[15,11,15,12],[34,3,34,10],[30,3,30,10],[31,3,31,10],[32,3,32,10],[33,3,33,10],[33,11,33,12],[27,3,27,10],[19,11,19,12],[21,11,21,12],[22,3,22,10],[23,3,23,10],[28,11,28,12],[29,3,29,10],[28,3,28,10],[23,11,23,12],[20,11,20,12],[29,11,29,12],[26,3,26,10],[26,11,26,12],[25,3,25,10],[20,3,20,10],[5,26,5,27],[10,26,10,27],[4,41,4,42],[1,23,2,23],[0,24,3,25],[0,26,3,27],[0,28,0,30],[2,29,2,30],[3,29,3,30],[1,29,1,30],[4,33,4,34],[4,31,4,32],[9,31,9,32],[4,29,4,30],[4,26,4,27],[0,41,3,42],[0,37,3,38],[0,35,3,36],[0,31,3,32],[0,33,3,34],[4,35,4,36],[4,37,4,38],[5,33,5,34],[8,24,8,25],[5,35,5,36],[6,37,6,38],[6,39,6,40],[18,33,18,34],[5,37,5,38],[8,35,8,36],[10,35,10,36],[13,35,13,36],[16,29,16,30],[7,31,7,32],[6,31,6,32],[7,37,7,38],[16,35,16,36],[8,33,8,34],[17,35,17,36],[9,35,9,36],[13,37,13,38],[15,37,15,38],[11,37,11,38],[11,35,11,36],[9,33,9,34],[15,35,15,36],[14,35,14,36],[12,35,12,36],[12,26,12,27],[11,26,11,27],[16,33,16,34],[17,33,17,34],[14,33,14,34],[11,33,11,34],[15,29,15,30],[11,31,11,32],[12,31,12,32],[15,31,15,32],[13,31,13,32],[12,33,12,34],[12,29,12,30],[13,29,13,30],[13,26,13,27],[10,33,10,34],[10,29,10,30],[15,33,15,34],[14,29,14,30],[17,31,17,32],[14,31,14,32],[13,33,13,34],[11,29,11,30],[17,29,17,30],[16,31,16,32],[10,31,10,32],[14,26,14,27],[17,24,17,25],[13,24,13,25],[15,24,15,25],[16,24,16,25],[16,26,16,27],[15,26,15,27],[18,24,18,25],[17,26,17,27],[14,24,14,25],[19,29,19,30],[20,26,20,27],[22,29,22,30],[17,39,17,40],[17,37,17,38],[18,39,18,40],[19,37,19,38],[20,37,20,38],[18,29,18,30],[18,31,18,32],[18,35,18,36],[21,29,21,30],[21,31,21,32],[22,26,22,27],[19,35,19,36],[20,35,20,36],[20,31,20,32],[19,33,19,34],[20,33,20,34],[20,29,20,30],[21,37,21,38],[21,33,21,34],[21,35,21,36],[18,26,18,27],[24,35,24,36],[24,29,24,30],[24,26,24,27],[23,35,23,36],[22,35,22,36],[22,33,22,34],[27,26,27,27],[25,26,25,27],[26,26,26,27],[26,29,26,30],[26,33,26,34],[27,31,27,32],[27,33,27,34],[28,35,28,36],[25,29,25,30],[26,31,26,32],[28,33,28,34],[26,35,26,36],[25,35,25,36],[25,33,25,34],[25,31,25,32],[27,35,27,36],[28,26,28,27],[28,31,28,32],[31,29,31,30],[32,11,32,12],[29,24,29,25],[28,24,28,25],[32,24,32,25],[29,26,29,27],[30,26,30,27],[31,26,31,27],[32,29,32,30],[32,31,32,32],[33,33,33,34],[30,11,30,12],[31,11,31,12],[30,24,30,25],[33,31,33,32],[31,24,31,25],[32,26,32,27],[30,31,30,32],[31,31,31,32],[33,24,33,25],[32,33,32,34],[40,26,40,28],[41,20,41,25],[42,17,42,19],[38,20,38,25],[38,17,38,19],[37,17,37,19],[36,17,36,19],[34,24,34,25],[35,20,35,25],[36,20,36,25],[37,20,37,25],[42,20,42,25],[40,17,40,19],[42,11,42,16],[38,11,38,16],[32,41,32,42],[32,43,32,44],[32,39,32,40],[33,37,33,38],[38,29,38,35],[33,41,33,42],[33,39,33,40],[33,43,33,44],[33,29,33,30],[39,39,39,42],[34,11,34,12],[35,11,35,16],[35,17,35,19],[35,26,35,28],[35,36,35,38],[34,37,34,38],[34,35,34,36],[38,26,38,28],[39,17,39,19],[40,20,40,25],[39,20,39,25],[42,26,42,28],[35,39,35,44],[36,11,36,16],[35,45,35,57],[34,43,34,44],[34,41,34,42],[34,39,34,40],[34,45,34,57],[41,36,41,38],[38,36,38,38],[37,36,37,38],[36,36,36,38],[40,36,40,38],[40,39,40,57],[39,36,39,38],[36,45,38,55],[39,43,39,57],[41,39,41,57],[36,39,38,44],[41,11,41,16],[41,17,41,19],[40,11,40,16],[37,11,37,16],[39,11,39,16],[41,26,41,28],[46,55,49,57],[44,46,44,57],[45,46,45,48],[45,49,45,51],[45,52,45,54],[45,55,45,57],[46,46,49,48],[46,49,49,51],[46,52,49,54],[42,39,42,57],[12,43,12,44],[12,41,12,42],[6,43,6,44],[8,43,8,44],[7,43,7,44],[6,41,6,42],[9,43,9,44],[8,39,8,40],[7,41,7,42],[20,41,20,42],[17,43,17,44],[14,43,14,44],[21,41,21,42],[18,41,18,42],[19,41,19,42],[20,43,20,44],[19,43,19,44],[18,43,18,44],[21,43,21,44],[13,41,13,42],[15,43,15,44],[14,41,14,42],[15,41,15,42],[7,39,7,40],[5,39,5,40],[6,58,6,70],[7,58,7,70],[8,45,8,57],[9,58,9,70],[8,58,8,70],[9,45,9,57],[4,43,4,44],[4,45,4,57],[5,41,5,42],[7,45,7,57],[8,41,8,42],[5,43,5,44],[17,41,17,42],[13,43,13,44],[9,77,9,78],[10,75,10,76],[16,79,16,91],[11,79,11,91],[14,75,14,76],[15,77,15,78],[14,79,14,91],[10,77,10,78],[12,77,12,78],[12,79,12,91],[10,58,10,70],[11,41,11,42],[10,41,10,42],[10,45,10,57],[11,43,11,44],[10,43,10,44],[14,73,14,74],[11,77,11,78],[9,75,9,76],[12,75,12,76],[13,75,13,76],[17,77,17,78],[0,79,3,91],[4,79,4,91],[5,79,5,91],[6,79,6,91],[7,79,7,91],[9,79,9,91],[22,77,22,78],[20,77,20,78],[16,77,16,78],[21,77,21,78],[8,79,8,91],[10,79,10,91],[15,79,15,91],[19,79,19,91],[20,79,20,91],[13,79,13,91],[7,77,7,78],[8,77,8,78],[19,77,19,78],[34,79,34,91],[27,79,27,91],[28,79,28,91],[29,79,29,91],[30,79,30,91],[31,79,31,91],[33,79,33,91],[17,79,17,91],[18,79,18,91],[22,79,22,91],[23,79,23,91],[21,79,21,91],[32,79,32,91],[26,79,26,91],[24,79,24,91],[25,79,25,91]]}
[2021,null,null,"年",null,1,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,"勤怠　種別",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,"15分"]
["付","日",null,null,null,null,null,null,null,null,null,null,null,"勤","勤","勤","休","日","半","半","日","半","半","日",null,null,null,null,"別","単位"]
[1,{"$f":"IF(A5<>\"\",DATE($A$1,$F$1,A5),\"\")","v":44197},{"$f":"IF(OR(AND(WEEKDAY(B5)<>1,WEEKDAY(B5)<>7), AND(Y5<>\"\",OR(WEEKDAY(B5)=1,WEEKDAY(B5)=7))),$BP$38,\"\")","v":2},{"$f":"IF(C5=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C5))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X5<>\"\",0, IF(C5=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C5)))","v":0},null,{"$f":"IF(AND(Y5<>\"\",O5<>1),1,\"\")","v":""},{"$f":"IF(AND(Y5<>\"\",X5<>\"\"),1,\"\")","v":""},{"$f":"IF(AND(N5<>1,O5<>1,WEEKDAY(B5)<>1,WEEKDAY(B5)<>7,CB5=\"\",X5<>1),IF(AND(C5<>\"\",X5=\"\",Y5=\"\",COUNTIF(Q5:W5, 1)),\"\",1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND(WEEKDAY(B5)<>1,WEEKDAY(B5)<>7),IF(CB5=\"\",\"\",0),1)","v":0},null,null,null,null,null,null,null,{"$f":"IF(IF(OR(Y5=\"\",AA5=\"\"),0,IF(ROUNDDOWN(AA5*96,0)/96>ROUNDUP(Y5*96,0)/96,((ROUNDDOWN(AA5*96,0)/96)-(ROUNDUP(Y5*96,0)/96))*24,\"ＮＧ\"))=0,\"\",IF(OR(Y5=\"\",AA5=\"\"),0,IF(ROUNDDOWN(AA5*96,0)/96>ROUNDUP(Y5*96,0)/96,((ROUNDDOWN(AA5*96,0)/96)-(ROUNDUP(Y5*96,0)/96))*24,\"ＮＧ\")))","v":""},null,{"$f":" IF(AND(C5<>\"\",Y5<>\"\",AF5>L5),(INDEX(基本設定!$X$30:$X$49,C5)/60),0)","v":0},null,null,null,{"$f":"IF(AF5=\"\",\"\",AF5-AH5-AJ5)","v":""},null,{"$f":"IF(AF5=\"\",\"\",IF((AL5-L5)>0,AL5-L5,\"\"))","v":""},null,null,null,{"$f":"IF(ROUNDUP(AA5*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA5*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP5)","v":0},null,{"$f":"IF(Y5<>\"\",$BH$38,\"\")","v":""},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(O5=1,\"休出\",\"\")\n&IF(P5=1,\"欠勤\",\"\")\n&IF(Q5=1,\"特休\", \"\")\n&IF(COUNTIF(R5:T5,1),\"有休\", \"\")\n&IF(COUNTIF(U5:W5,1),\"代休\",\"\")\n&IF(AC5=\"\",\"\",IF(AC5=1,\"遅刻\",IF(AC5=0,\"早退\")))\n&IF(AND(O5<>1,P5<>1,X5=1,BG5<>\"\"),\"所定休日\", \"\")","v":""},null,{"$f":"IF(X5<>\"\",,IF(L5=\"\",0,L5))","v":0},null,{"$f":"IF(X5=\"\",\"\",AL5)","v":""},null,{"$f":"IF(X5=\"\",\"\",AR5)","v":0},null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A5,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A5,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":"元旦"}]
[2,{"$f":"IF(A6<>\"\",DATE($A$1,$F$1,A6),\"\")","v":44198},{"$f":"IF(OR(AND(WEEKDAY(B6)<>1,WEEKDAY(B6)<>7), AND(Y6<>\"\",OR(WEEKDAY(B6)=1,WEEKDAY(B6)=7))),$BP$38,\"\")","v":""},{"$f":"IF(C6=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C6))","v":""},null,null,null,null,null,null,null,{"$f":"IF(X6<>\"\",0, IF(C6=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C6)))","v":0},null,"",{"$f":"IF(AND(Y6<>\"\",X6<>\"\"),1,\"\")","v":""},{"$f":"IF(AND(N6<>1,O6<>1,WEEKDAY(B6)<>1,WEEKDAY(B6)<>7,CB6=\"\",X6<>1),IF(AND(C6<>\"\",X6=\"\",Y6=\"\",COUNTIF(Q6:W6, 1)),\"\",1),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND(WEEKDAY(B6)<>1,WEEKDAY(B6)<>7),IF(CB6=\"\",\"\",0),1)","v":1},null,null,null,null,null,null,null,{"$f":"IF(IF(OR(Y6=\"\",AA6=\"\"),0,IF(ROUNDDOWN(AA6*96,0)/96>ROUNDUP(Y6*96,0)/96,((ROUNDDOWN(AA6*96,0)/96)-(ROUNDUP(Y6*96,0)/96))*24,\"ＮＧ\"))=0,\"\",IF(OR(Y6=\"\",AA6=\"\"),0,IF(ROUNDDOWN(AA6*96,0)/96>ROUNDUP(Y6*96,0)/96,((ROUNDDOWN(AA6*96,0)/96)-(ROUNDUP(Y6*96,0)/96))*24,\"ＮＧ\")))","v":""},null,{"$f":" IF(AND(C6<>\"\",Y6<>\"\",AF6>L6),(INDEX(基本設定!$X$30:$X$49,C6)/60),0)","v":0},null,null,null,{"$f":"IF(AF6=\"\",\"\",AF6-AH6-AJ6)","v":""},null,"",null,null,null,{"$f":"IF(ROUNDUP(AA6*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA6*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP6)","v":0},null,{"$f":"IF(Y6<>\"\",$BH$38,\"\")","v":""},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(O6=1,\"休出\",\"\")\n&IF(P6=1,\"欠勤\",\"\")\n&IF(Q6=1,\"特休\", \"\")\n&IF(COUNTIF(R6:T6,1),\"有休\", \"\")\n&IF(COUNTIF(U6:W6,1),\"代休\",\"\")\n&IF(AC6=\"\",\"\",IF(AC6=1,\"遅刻\",IF(AC6=0,\"早退\")))\n&IF(AND(O6<>1,P6<>1,X6=1,BG6<>\"\"),\"所定休日\", \"\")","v":""},null,{"$f":"IF(X6<>\"\",,IF(L6=\"\",0,L6))","v":0},null,"",null,0,null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A6,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A6,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":"年始休暇"}]
[3,44199,"",{"$f":"IF(C7=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C7))","v":""},null,null,null,null,null,null,null,{"$f":"IF(X7<>\"\",0, IF(C7=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C7)))","v":0},null,"","","",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"IF(IF(OR(Y7=\"\",AA7=\"\"),0,IF(ROUNDDOWN(AA7*96,0)/96>ROUNDUP(Y7*96,0)/96,((ROUNDDOWN(AA7*96,0)/96)-(ROUNDUP(Y7*96,0)/96))*24,\"ＮＧ\"))=0,\"\",IF(OR(Y7=\"\",AA7=\"\"),0,IF(ROUNDDOWN(AA7*96,0)/96>ROUNDUP(Y7*96,0)/96,((ROUNDDOWN(AA7*96,0)/96)-(ROUNDUP(Y7*96,0)/96))*24,\"ＮＧ\")))","v":""},null,{"$f":" IF(AND(C7<>\"\",Y7<>\"\",AF7>L7),(INDEX(基本設定!$X$30:$X$49,C7)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA7*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA7*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP7)","v":0},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,0,null,"",null,0,null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A7,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A7,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":"年始休暇"}]
[4,44200,2,{"$f":"IF(C8=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C8))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X8<>\"\",0, IF(C8=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C8)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,{"$f":"IF(IF(OR(Y8=\"\",AA8=\"\"),0,IF(ROUNDDOWN(AA8*96,0)/96>ROUNDUP(Y8*96,0)/96,((ROUNDDOWN(AA8*96,0)/96)-(ROUNDUP(Y8*96,0)/96))*24,\"ＮＧ\"))=0,\"\",IF(OR(Y8=\"\",AA8=\"\"),0,IF(ROUNDDOWN(AA8*96,0)/96>ROUNDUP(Y8*96,0)/96,((ROUNDDOWN(AA8*96,0)/96)-(ROUNDUP(Y8*96,0)/96))*24,\"ＮＧ\")))","v":""},null,{"$f":" IF(AND(C8<>\"\",Y8<>\"\",AF8>L8),(INDEX(基本設定!$X$30:$X$49,C8)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA8*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA8*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP8)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A8,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A8,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[5,44201,2,{"$f":"IF(C9=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C9))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X9<>\"\",0, IF(C9=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C9)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,{"$f":"IF(IF(OR(Y9=\"\",AA9=\"\"),0,IF(ROUNDDOWN(AA9*96,0)/96>ROUNDUP(Y9*96,0)/96,((ROUNDDOWN(AA9*96,0)/96)-(ROUNDUP(Y9*96,0)/96))*24,\"ＮＧ\"))=0,\"\",IF(OR(Y9=\"\",AA9=\"\"),0,IF(ROUNDDOWN(AA9*96,0)/96>ROUNDUP(Y9*96,0)/96,((ROUNDDOWN(AA9*96,0)/96)-(ROUNDUP(Y9*96,0)/96))*24,\"ＮＧ\")))","v":""},null,{"$f":" IF(AND(C9<>\"\",Y9<>\"\",AF9>L9),(INDEX(基本設定!$X$30:$X$49,C9)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA9*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA9*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP9)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A9,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A9,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[6,44202,2,{"$f":"IF(C10=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C10))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X10<>\"\",0, IF(C10=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C10)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,{"$f":"IF(IF(OR(Y10=\"\",AA10=\"\"),0,IF(ROUNDDOWN(AA10*96,0)/96>ROUNDUP(Y10*96,0)/96,((ROUNDDOWN(AA10*96,0)/96)-(ROUNDUP(Y10*96,0)/96))*24,\"ＮＧ\"))=0,\"\",IF(OR(Y10=\"\",AA10=\"\"),0,IF(ROUNDDOWN(AA10*96,0)/96>ROUNDUP(Y10*96,0)/96,((ROUNDDOWN(AA10*96,0)/96)-(ROUNDUP(Y10*96,0)/96))*24,\"ＮＧ\")))","v":""},null,{"$f":" IF(AND(C10<>\"\",Y10<>\"\",AF10>L10),(INDEX(基本設定!$X$30:$X$49,C10)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA10*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA10*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP10)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A10,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A10,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[7,44203,2,{"$f":"IF(C11=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C11))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X11<>\"\",0, IF(C11=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C11)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C11<>\"\",Y11<>\"\",AF11>L11),(INDEX(基本設定!$X$30:$X$49,C11)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA11*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA11*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP11)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A11,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A11,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[8,44204,2,{"$f":"IF(C12=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C12))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X12<>\"\",0, IF(C12=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C12)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C12<>\"\",Y12<>\"\",AF12>L12),(INDEX(基本設定!$X$30:$X$49,C12)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA12*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA12*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP12)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A12,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A12,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[9,44205,"",{"$f":"IF(C13=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C13))","v":""},null,null,null,null,null,null,null,{"$f":"IF(X13<>\"\",0, IF(C13=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C13)))","v":0},null,"","","",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"IF(IF(OR(Y13=\"\",AA13=\"\"),0,IF(ROUNDDOWN(AA13*96,0)/96>ROUNDUP(Y13*96,0)/96,((ROUNDDOWN(AA13*96,0)/96)-(ROUNDUP(Y13*96,0)/96))*24,\"ＮＧ\"))=0,\"\",IF(OR(Y13=\"\",AA13=\"\"),0,IF(ROUNDDOWN(AA13*96,0)/96>ROUNDUP(Y13*96,0)/96,((ROUNDDOWN(AA13*96,0)/96)-(ROUNDUP(Y13*96,0)/96))*24,\"ＮＧ\")))","v":""},null,{"$f":" IF(AND(C13<>\"\",Y13<>\"\",AF13>L13),(INDEX(基本設定!$X$30:$X$49,C13)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA13*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA13*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP13)","v":0},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,0,null,"",null,0,null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A13,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A13,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[10,44206,"",{"$f":"IF(C14=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C14))","v":""},null,null,null,null,null,null,null,{"$f":"IF(X14<>\"\",0, IF(C14=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C14)))","v":0},null,"","","",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C14<>\"\",Y14<>\"\",AF14>L14),(INDEX(基本設定!$X$30:$X$49,C14)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA14*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA14*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP14)","v":0},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,0,null,"",null,0,null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A14,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A14,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[11,44207,2,{"$f":"IF(C15=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C15))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X15<>\"\",0, IF(C15=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C15)))","v":0},null,"","","",null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C15<>\"\",Y15<>\"\",AF15>L15),(INDEX(基本設定!$X$30:$X$49,C15)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA15*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA15*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP15)","v":0},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,0,null,"",null,0,null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A15,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A15,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":"成人の日"}]
[12,44208,2,{"$f":"IF(C16=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C16))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X16<>\"\",0, IF(C16=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C16)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C16<>\"\",Y16<>\"\",AF16>L16),(INDEX(基本設定!$X$30:$X$49,C16)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA16*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA16*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP16)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A16,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A16,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[13,44209,2,{"$f":"IF(C17=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C17))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X17<>\"\",0, IF(C17=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C17)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C17<>\"\",Y17<>\"\",AF17>L17),(INDEX(基本設定!$X$30:$X$49,C17)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA17*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA17*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP17)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A17,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A17,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[14,44210,2,{"$f":"IF(C18=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C18))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X18<>\"\",0, IF(C18=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C18)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C18<>\"\",Y18<>\"\",AF18>L18),(INDEX(基本設定!$X$30:$X$49,C18)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA18*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA18*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP18)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A18,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A18,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[15,44211,2,{"$f":"IF(C19=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C19))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X19<>\"\",0, IF(C19=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C19)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C19<>\"\",Y19<>\"\",AF19>L19),(INDEX(基本設定!$X$30:$X$49,C19)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA19*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA19*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP19)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A19,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A19,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[16,44212,"",{"$f":"IF(C20=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C20))","v":""},null,null,null,null,null,null,null,{"$f":"IF(X20<>\"\",0, IF(C20=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C20)))","v":0},null,"","","",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"IF(IF(OR(Y20=\"\",AA20=\"\"),0,IF(ROUNDDOWN(AA20*96,0)/96>ROUNDUP(Y20*96,0)/96,((ROUNDDOWN(AA20*96,0)/96)-(ROUNDUP(Y20*96,0)/96))*24,\"ＮＧ\"))=0,\"\",IF(OR(Y20=\"\",AA20=\"\"),0,IF(ROUNDDOWN(AA20*96,0)/96>ROUNDUP(Y20*96,0)/96,((ROUNDDOWN(AA20*96,0)/96)-(ROUNDUP(Y20*96,0)/96))*24,\"ＮＧ\")))","v":""},null,{"$f":" IF(AND(C20<>\"\",Y20<>\"\",AF20>L20),(INDEX(基本設定!$X$30:$X$49,C20)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA20*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA20*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP20)","v":0},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,0,null,"",null,0,null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A20,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A20,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[17,44213,"",{"$f":"IF(C21=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C21))","v":""},null,null,null,null,null,null,null,{"$f":"IF(X21<>\"\",0, IF(C21=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C21)))","v":0},null,"","","",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"IF(IF(OR(Y21=\"\",AA21=\"\"),0,IF(ROUNDDOWN(AA21*96,0)/96>ROUNDUP(Y21*96,0)/96,((ROUNDDOWN(AA21*96,0)/96)-(ROUNDUP(Y21*96,0)/96))*24,\"ＮＧ\"))=0,\"\",IF(OR(Y21=\"\",AA21=\"\"),0,IF(ROUNDDOWN(AA21*96,0)/96>ROUNDUP(Y21*96,0)/96,((ROUNDDOWN(AA21*96,0)/96)-(ROUNDUP(Y21*96,0)/96))*24,\"ＮＧ\")))","v":""},null,{"$f":" IF(AND(C21<>\"\",Y21<>\"\",AF21>L21),(INDEX(基本設定!$X$30:$X$49,C21)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA21*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA21*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP21)","v":0},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,0,null,"",null,0,null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A21,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A21,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[18,44214,2,{"$f":"IF(C22=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C22))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X22<>\"\",0, IF(C22=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C22)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C22<>\"\",Y22<>\"\",AF22>L22),(INDEX(基本設定!$X$30:$X$49,C22)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA22*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA22*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP22)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A22,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A22,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[19,44215,2,{"$f":"IF(C23=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C23))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X23<>\"\",0, IF(C23=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C23)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C23<>\"\",Y23<>\"\",AF23>L23),(INDEX(基本設定!$X$30:$X$49,C23)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA23*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA23*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP23)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A23,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A23,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[20,44216,2,{"$f":"IF(C24=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C24))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X24<>\"\",0, IF(C24=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C24)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C24<>\"\",Y24<>\"\",AF24>L24),(INDEX(基本設定!$X$30:$X$49,C24)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA24*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA24*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP24)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A24,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A24,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[21,44217,2,{"$f":"IF(C25=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C25))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X25<>\"\",0, IF(C25=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C25)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C25<>\"\",Y25<>\"\",AF25>L25),(INDEX(基本設定!$X$30:$X$49,C25)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA25*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA25*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP25)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A25,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A25,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[22,44218,2,{"$f":"IF(C26=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C26))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X26<>\"\",0, IF(C26=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C26)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C26<>\"\",Y26<>\"\",AF26>L26),(INDEX(基本設定!$X$30:$X$49,C26)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA26*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA26*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP26)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A26,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A26,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[23,44219,"",{"$f":"IF(C27=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C27))","v":""},null,null,null,null,null,null,null,{"$f":"IF(X27<>\"\",0, IF(C27=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C27)))","v":0},null,"","","",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C27<>\"\",Y27<>\"\",AF27>L27),(INDEX(基本設定!$X$30:$X$49,C27)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA27*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA27*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP27)","v":0},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,0,null,"",null,0,null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A27,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A27,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[24,44220,"",{"$f":"IF(C28=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C28))","v":""},null,null,null,null,null,null,null,{"$f":"IF(X28<>\"\",0, IF(C28=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C28)))","v":0},null,"","","",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C28<>\"\",Y28<>\"\",AF28>L28),(INDEX(基本設定!$X$30:$X$49,C28)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA28*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA28*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP28)","v":0},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,0,null,"",null,0,null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A28,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A28,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[25,44221,2,{"$f":"IF(C29=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C29))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X29<>\"\",0, IF(C29=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C29)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C29<>\"\",Y29<>\"\",AF29>L29),(INDEX(基本設定!$X$30:$X$49,C29)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA29*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA29*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP29)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A29,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A29,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[26,44222,2,{"$f":"IF(C30=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C30))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X30<>\"\",0, IF(C30=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C30)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C30<>\"\",Y30<>\"\",AF30>L30),(INDEX(基本設定!$X$30:$X$49,C30)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA30*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA30*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP30)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A30,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A30,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[27,44223,2,{"$f":"IF(C31=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C31))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X31<>\"\",0, IF(C31=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C31)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C31<>\"\",Y31<>\"\",AF31>L31),(INDEX(基本設定!$X$30:$X$49,C31)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA31*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA31*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP31)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A31,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A31,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[28,44224,2,{"$f":"IF(C32=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C32))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X32<>\"\",0, IF(C32=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C32)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C32<>\"\",Y32<>\"\",AF32>L32),(INDEX(基本設定!$X$30:$X$49,C32)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA32*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA32*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP32)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A32,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A32,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[29,44225,2,{"$f":"IF(C33=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C33))","v":"勤務先A"},null,null,null,null,null,null,null,{"$f":"IF(X33<>\"\",0, IF(C33=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C33)))","v":7.5000000000000018},null,"","",1,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C33<>\"\",Y33<>\"\",AF33>L33),(INDEX(基本設定!$X$30:$X$49,C33)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA33*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA33*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP33)","v":0},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,7.5000000000000018,null,"",null,"",null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A33,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A33,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[30,44226,"",{"$f":"IF(C34=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C34))","v":""},null,null,null,null,null,null,null,{"$f":"IF(X34<>\"\",0, IF(C34=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C34)))","v":0},null,"","","",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C34<>\"\",Y34<>\"\",AF34>L34),(INDEX(基本設定!$X$30:$X$49,C34)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA34*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA34*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP34)","v":0},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,0,null,"",null,0,null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A34,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A34,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[31,44227,"",{"$f":"IF(C35=\"\",\"\",INDEX(基本設定!$C$30:$C$49,$C$1+C35))","v":""},null,null,null,null,null,null,null,{"$f":"IF(X35<>\"\",0, IF(C35=\"\",\"\",INDEX(基本設定!$P$30:$P$49,C35)))","v":0},null,"","","",null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,"",null,{"$f":" IF(AND(C35<>\"\",Y35<>\"\",AF35>L35),(INDEX(基本設定!$X$30:$X$49,C35)/60),0)","v":0},null,null,null,"",null,"",null,null,null,{"$f":"IF(ROUNDUP(AA35*96,0)<ROUNDUP(基本設定!$G$5*96,0),0,(((ROUNDUP(AA35*96,0)/96)-(ROUNDUP(基本設定!$G$5*96,0)/96))*24)-AP35)","v":0},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,0,null,"",null,0,null,{"$f":"IF(ISERROR(VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A35,\"00\"),祝日一覧!$A$2:$B$23,2,0)),\"\",VLOOKUP(TEXT($F$1,\"00\")&\"/\"&TEXT($A35,\"00\"),祝日一覧!$A$2:$B$23,2,0))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"前月有給繰越日数",null,null,null,null,null,30,null,null,"当月欠勤日数",null,null,null,null,null,{"$f":"SUM(P5:P35)","v":19},null,null,"当月作業超過総時間",null,null,null,null,null,null,{"$f":"SUM(AN5:AN35)-SUM(AP5:AP35)-R39","v":0},null,null,"所　　属",null,null,null,null,null,"氏　　　　　　　　名"]
[null,null,null,null,null,null,null,null,null,null,null,"当月有給取得日数",null,null,null,null,null,{"$f":"COUNTA(R5:R35) + (COUNTA(S5:T35)*0.5)","v":0},null,null,"当月遅刻早退回数",null,null,null,null,null,{"$f":"(COUNTIF(AC5:AC35,\"0\")+COUNTIF(AC5:AC35,\"1\"))","v":0},null,null,"普通残業時間",null,null,null,null,null,null,{"$f":"SUM(AN5:AN35)-SUM(AP5:AP35)-SUM(AR5:AR35)-SUM(BX5:BX35)","v":0},null,null,{"$f":"基本設定!G4","v":"株式会社エムズ"},null,null,null,null,null,{"$f":"基本設定!G3","v":"市ヶ谷 エムズ"},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":"COUNTA(U5:U35)+(COUNTA(V5:W35)*0.5)","v":0},null,null,"当月遅刻早退時間",null,null,null,null,null,{"$f":"(SUMIF(AC5:AC35,\"0\",AD5:AD35) + SUMIF(AC5:AC35,\"1\",AD5:AD35))/4","v":0},null,null,"深夜残業時間",null,null,null,null,null,null,{"$f":"SUM(AR5:AS35)-SUM(BZ5:CA35)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"○○プロジェクト\n製造・単体試験",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,"当月代休消化時間",null,null,null,null,null,{"$f":"R38*INDEX(基本設定!$P$30:$P$49,$BP$38)","v":0},null,null,"当月有給･半休時間",null,null,null,null,null,{"$f":"SUM(Z6:Z44)+IF(SUM(AC6:AC45)<AL17,0,AL17)","v":0},null,null,"休日出勤日数",null,null,null,null,null,null,{"$f":"SUM(O5:O35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"当月特休取得日数",null,null,null,null,null,{"$f":"SUM(Q5:Q35)","v":0},null,null,"当月作業日数",null,null,null,null,null,{"$f":"COUNTA(A5:A35)-(COUNTA(A5:A35)-COUNTA(C5:C35))","v":31},null,null,"休日総作業時間",null,null,null,null,null,null,{"$f":"SUM(BX5:BY35)-R39","v":0},null,null,"特記事項："]
[null,null,null,null,null,null,null,null,null,null,null,"当月標準出勤日数",null,null,null,null,null,{"$f":"COUNTA(A5:A35)-COUNTA(X5:X35)","v":0},null,null,"当月作業時間",null,null,null,null,null,{"$f":"SUM(AF5:AG35)","v":0},null,null,"休日普通勤務時間",null,null,null,null,null,null,{"$f":"SUM(BX5:BY35)-SUM(BZ5:CA35)-R39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"当月標準作業時間",null,null,null,null,null,{"$f":"SUM(BV4:BW34)","v":142.50000000000003},null,null,"当月実作業時間",null,null,null,null,null,{"$f":"SUM(AL5:AM35)-SUM(AP5:AQ35)","v":0},null,null,"休日深夜勤務時間",null,null,null,null,null,null,{"$f":"SUM(BZ4:CA34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"有休残日数",null,null,null,null,null,{"$f":"R36 - COUNTA(R5:R35) + (COUNTA(S5:T35)*0.5)","v":30}]
[]
[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,null,"承　認"]
[]
[]
[]
[]
[]
[]
[null,null,"※公休日の種別 ： 基本は自動入力。手動の場合は、祝祭日は０（祝）公休日または所定休日は１（休）入力。"]
[null,null,"※遅刻・早退の種別 ： 遅刻は１（○）、早退は０（●）。"]
[null,null,"※特休・生休の種別 ： 特休は１（○）、生休は０（●）。"]

{"sheet":"提出用原紙","index":4,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,10,52,11],[51,10,51,11],[47,10,47,11],[48,10,48,11],[49,10,49,11],[50,10,50,11],[4,3,4,4],[5,3,5,4],[1,4,1,6],[41,12,41,15],[7,5,8,5],[40,12,40,15],[39,12,39,15],[38,12,38,15],[37,12,37,15],[36,12,36,15],[4,5,4,7],[5,5,5,7],[49,7,49,8],[50,7,50,8],[48,7,48,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8]]}
[]
[null,null,null,null,{"$f":" 記入用紙!A1 &  \" 年 \"  &  記入用紙!F1 & \" 月度勤務証明書\"","v":"2021 年 1 月度勤務証明書"}]
[]
[]
[null,{"$f":" \"所属 ： \"","v":"所属 ： "},null,{"$f":"基本設定!G4","v":"株式会社エムズ"},null,{"$f":" \"業務名 ： \" & 基本設定!Q3","v":"業務名 ： ○○プロジェクト"}]
[null,{"$f":" \"氏名 ： \" & 基本設定!G3","v":"氏名 ： 市ヶ谷 エムズ"},null,{"$f":"基本設定!G3","v":"市ヶ谷 エムズ"},null,{"$f":"\"作業場所 ： \" & 基本設定!Q4","v":"作業場所 ： 勤務先A"}]
[]
[null,"日","曜","作  業  時  間",null,"作　業　内　容　記　入　欄\nお　よ　び　勤　怠　理　由","作  業","精  算","時  間  外",null,"遅刻\n早退"]
[null,"付","日","  自","  至",null,"時間数","時間数","休  日","深  夜","時間"]
["",1,{"$f":"IF(記入用紙!B5<>\"\",記入用紙!B5,\"\")","v":44197},{"$f":"記入用紙!Y5","v":"00:00:00"},{"$f":"記入用紙!AA5","v":"00:00:00"},{"$f":"IF(記入用紙!CB5<>\"\",(\"【\"&記入用紙!CB5&\"】\"),\"\")&記入用紙!AT5&IF(AND(記入用紙!BT5<>\"\",記入用紙!BG5<>\"\"),CHAR(10)&\"【\"&記入用紙!BT5&\"】\"&記入用紙!BG5,\"\")","v":"【元旦】"},{"$f":"IF(D10<>0, 記入用紙!AF5-記入用紙!AH5-記入用紙!AJ5-記入用紙!AP5,0)","v":0},{"$f":"IF(G10-記入用紙!BV5-SUM(I10:J10)>0,G10-記入用紙!BV5-SUM(I10:J10),0)","v":0},{"$f":"IF(記入用紙!BX5<>\"\", IF(J10<>\"\",  記入用紙!BX5-J10,記入用紙!BX5),\"\")","v":""},{"$f":"記入用紙!AR5","v":0},{"$f":"IF(AND(OR(記入用紙!$AC5=0,記入用紙!$AC5=1), 記入用紙!$AC5<>\"\"),記入用紙!$AD5/4,\"\")","v":""},null,"","",""]
["",2,{"$f":"IF(記入用紙!B6<>\"\",記入用紙!B6,\"\")","v":44198},{"$f":"記入用紙!Y6","v":"00:00:00"},{"$f":"記入用紙!AA6","v":"00:00:00"},{"$f":"IF(記入用紙!CB6<>\"\",(\"【\"&記入用紙!CB6&\"】\"),\"\")&記入用紙!AT6&IF(AND(記入用紙!BT6<>\"\",記入用紙!BG6<>\"\"),CHAR(10)&\"【\"&記入用紙!BT6&\"】\"&記入用紙!BG6,\"\")","v":"【年始休暇】"},{"$f":"IF(D11<>0, 記入用紙!AF6-記入用紙!AH6-記入用紙!AJ6-記入用紙!AP6,0)","v":0},{"$f":"IF(G11-記入用紙!BV6-SUM(I11:J11)>0,G11-記入用紙!BV6-SUM(I11:J11),0)","v":0},{"$f":"IF(記入用紙!BX6<>\"\", IF(J11<>\"\",  記入用紙!BX6-J11,記入用紙!BX6),\"\")","v":""},{"$f":"記入用紙!AR6","v":0},{"$f":"IF(AND(OR(記入用紙!$AC6=0,記入用紙!$AC6=1), 記入用紙!$AC6<>\"\"),記入用紙!$AD6/4,\"\")","v":""},null,"","",""]
["",3,{"$f":"IF(記入用紙!B7<>\"\",記入用紙!B7,\"\")","v":44199},{"$f":"記入用紙!Y7","v":"00:00:00"},{"$f":"記入用紙!AA7","v":"00:00:00"},{"$f":"IF(記入用紙!CB7<>\"\",(\"【\"&記入用紙!CB7&\"】\"),\"\")&記入用紙!AT7&IF(AND(記入用紙!BT7<>\"\",記入用紙!BG7<>\"\"),CHAR(10)&\"【\"&記入用紙!BT7&\"】\"&記入用紙!BG7,\"\")","v":"【年始休暇】"},{"$f":"IF(D12<>0, 記入用紙!AF7-記入用紙!AH7-記入用紙!AJ7-記入用紙!AP7,0)","v":0},{"$f":"IF(G12-記入用紙!BV7-SUM(I12:J12)>0,G12-記入用紙!BV7-SUM(I12:J12),0)","v":0},{"$f":"IF(記入用紙!BX7<>\"\", IF(J12<>\"\",  記入用紙!BX7-J12,記入用紙!BX7),\"\")","v":""},{"$f":"記入用紙!AR7","v":0},{"$f":"IF(AND(OR(記入用紙!$AC7=0,記入用紙!$AC7=1), 記入用紙!$AC7<>\"\"),記入用紙!$AD7/4,\"\")","v":""},null,"","",""]
["",4,{"$f":"IF(記入用紙!B8<>\"\",記入用紙!B8,\"\")","v":44200},{"$f":"記入用紙!Y8","v":"00:00:00"},{"$f":"記入用紙!AA8","v":"00:00:00"},{"$f":"IF(記入用紙!CB8<>\"\",(\"【\"&記入用紙!CB8&\"】\"),\"\")&記入用紙!AT8&IF(AND(記入用紙!BT8<>\"\",記入用紙!BG8<>\"\"),CHAR(10)&\"【\"&記入用紙!BT8&\"】\"&記入用紙!BG8,\"\")","v":""},{"$f":"IF(D13<>0, 記入用紙!AF8-記入用紙!AH8-記入用紙!AJ8-記入用紙!AP8,0)","v":0},{"$f":"IF(G13-記入用紙!BV8-SUM(I13:J13)>0,G13-記入用紙!BV8-SUM(I13:J13),0)","v":0},{"$f":"IF(記入用紙!BX8<>\"\", IF(J13<>\"\",  記入用紙!BX8-J13,記入用紙!BX8),\"\")","v":""},{"$f":"記入用紙!AR8","v":0},{"$f":"IF(AND(OR(記入用紙!$AC8=0,記入用紙!$AC8=1), 記入用紙!$AC8<>\"\"),記入用紙!$AD8/4,\"\")","v":""},null,"","",""]
["",5,{"$f":"IF(記入用紙!B9<>\"\",記入用紙!B9,\"\")","v":44201},{"$f":"記入用紙!Y9","v":"00:00:00"},{"$f":"記入用紙!AA9","v":"00:00:00"},{"$f":"IF(記入用紙!CB9<>\"\",(\"【\"&記入用紙!CB9&\"】\"),\"\")&記入用紙!AT9&IF(AND(記入用紙!BT9<>\"\",記入用紙!BG9<>\"\"),CHAR(10)&\"【\"&記入用紙!BT9&\"】\"&記入用紙!BG9,\"\")","v":""},{"$f":"IF(D14<>0, 記入用紙!AF9-記入用紙!AH9-記入用紙!AJ9-記入用紙!AP9,0)","v":0},{"$f":"IF(G14-記入用紙!BV9-SUM(I14:J14)>0,G14-記入用紙!BV9-SUM(I14:J14),0)","v":0},{"$f":"IF(記入用紙!BX9<>\"\", IF(J14<>\"\",  記入用紙!BX9-J14,記入用紙!BX9),\"\")","v":""},{"$f":"記入用紙!AR9","v":0},{"$f":"IF(AND(OR(記入用紙!$AC9=0,記入用紙!$AC9=1), 記入用紙!$AC9<>\"\"),記入用紙!$AD9/4,\"\")","v":""},null,"","",""]
["",6,{"$f":"IF(記入用紙!B10<>\"\",記入用紙!B10,\"\")","v":44202},{"$f":"記入用紙!Y10","v":"00:00:00"},{"$f":"記入用紙!AA10","v":"00:00:00"},{"$f":"IF(記入用紙!CB10<>\"\",(\"【\"&記入用紙!CB10&\"】\"),\"\")&記入用紙!AT10&IF(AND(記入用紙!BT10<>\"\",記入用紙!BG10<>\"\"),CHAR(10)&\"【\"&記入用紙!BT10&\"】\"&記入用紙!BG10,\"\")","v":""},{"$f":"IF(D15<>0, 記入用紙!AF10-記入用紙!AH10-記入用紙!AJ10-記入用紙!AP10,0)","v":0},{"$f":"IF(G15-記入用紙!BV10-SUM(I15:J15)>0,G15-記入用紙!BV10-SUM(I15:J15),0)","v":0},{"$f":"IF(記入用紙!BX10<>\"\", IF(J15<>\"\",  記入用紙!BX10-J15,記入用紙!BX10),\"\")","v":""},{"$f":"記入用紙!AR10","v":0},{"$f":"IF(AND(OR(記入用紙!$AC10=0,記入用紙!$AC10=1), 記入用紙!$AC10<>\"\"),記入用紙!$AD10/4,\"\")","v":""},null,"","",""]
["",7,{"$f":"IF(記入用紙!B11<>\"\",記入用紙!B11,\"\")","v":44203},{"$f":"記入用紙!Y11","v":"00:00:00"},{"$f":"記入用紙!AA11","v":"00:00:00"},{"$f":"IF(記入用紙!CB11<>\"\",(\"【\"&記入用紙!CB11&\"】\"),\"\")&記入用紙!AT11&IF(AND(記入用紙!BT11<>\"\",記入用紙!BG11<>\"\"),CHAR(10)&\"【\"&記入用紙!BT11&\"】\"&記入用紙!BG11,\"\")","v":""},{"$f":"IF(D16<>0, 記入用紙!AF11-記入用紙!AH11-記入用紙!AJ11-記入用紙!AP11,0)","v":0},{"$f":"IF(G16-記入用紙!BV11-SUM(I16:J16)>0,G16-記入用紙!BV11-SUM(I16:J16),0)","v":0},{"$f":"IF(記入用紙!BX11<>\"\", IF(J16<>\"\",  記入用紙!BX11-J16,記入用紙!BX11),\"\")","v":""},{"$f":"記入用紙!AR11","v":0},{"$f":"IF(AND(OR(記入用紙!$AC11=0,記入用紙!$AC11=1), 記入用紙!$AC11<>\"\"),記入用紙!$AD11/4,\"\")","v":""},null,"","",""]
["",8,{"$f":"IF(記入用紙!B12<>\"\",記入用紙!B12,\"\")","v":44204},{"$f":"記入用紙!Y12","v":"00:00:00"},{"$f":"記入用紙!AA12","v":"00:00:00"},{"$f":"IF(記入用紙!CB12<>\"\",(\"【\"&記入用紙!CB12&\"】\"),\"\")&記入用紙!AT12&IF(AND(記入用紙!BT12<>\"\",記入用紙!BG12<>\"\"),CHAR(10)&\"【\"&記入用紙!BT12&\"】\"&記入用紙!BG12,\"\")","v":""},{"$f":"IF(D17<>0, 記入用紙!AF12-記入用紙!AH12-記入用紙!AJ12-記入用紙!AP12,0)","v":0},{"$f":"IF(G17-記入用紙!BV12-SUM(I17:J17)>0,G17-記入用紙!BV12-SUM(I17:J17),0)","v":0},{"$f":"IF(記入用紙!BX12<>\"\", IF(J17<>\"\",  記入用紙!BX12-J17,記入用紙!BX12),\"\")","v":""},{"$f":"記入用紙!AR12","v":0},{"$f":"IF(AND(OR(記入用紙!$AC12=0,記入用紙!$AC12=1), 記入用紙!$AC12<>\"\"),記入用紙!$AD12/4,\"\")","v":""},null,null,null,""]
["",9,{"$f":"IF(記入用紙!B13<>\"\",記入用紙!B13,\"\")","v":44205},{"$f":"記入用紙!Y13","v":"00:00:00"},{"$f":"記入用紙!AA13","v":"00:00:00"},{"$f":"IF(記入用紙!CB13<>\"\",(\"【\"&記入用紙!CB13&\"】\"),\"\")&記入用紙!AT13&IF(AND(記入用紙!BT13<>\"\",記入用紙!BG13<>\"\"),CHAR(10)&\"【\"&記入用紙!BT13&\"】\"&記入用紙!BG13,\"\")","v":""},{"$f":"IF(D18<>0, 記入用紙!AF13-記入用紙!AH13-記入用紙!AJ13-記入用紙!AP13,0)","v":0},{"$f":"IF(G18-記入用紙!BV13-SUM(I18:J18)>0,G18-記入用紙!BV13-SUM(I18:J18),0)","v":0},{"$f":"IF(記入用紙!BX13<>\"\", IF(J18<>\"\",  記入用紙!BX13-J18,記入用紙!BX13),\"\")","v":""},{"$f":"記入用紙!AR13","v":0},{"$f":"IF(AND(OR(記入用紙!$AC13=0,記入用紙!$AC13=1), 記入用紙!$AC13<>\"\"),記入用紙!$AD13/4,\"\")","v":""},null,null,null,""]
["",10,{"$f":"IF(記入用紙!B14<>\"\",記入用紙!B14,\"\")","v":44206},{"$f":"記入用紙!Y14","v":"00:00:00"},{"$f":"記入用紙!AA14","v":"00:00:00"},{"$f":"IF(記入用紙!CB14<>\"\",(\"【\"&記入用紙!CB14&\"】\"),\"\")&記入用紙!AT14&IF(AND(記入用紙!BT14<>\"\",記入用紙!BG14<>\"\"),CHAR(10)&\"【\"&記入用紙!BT14&\"】\"&記入用紙!BG14,\"\")","v":""},{"$f":"IF(D19<>0, 記入用紙!AF14-記入用紙!AH14-記入用紙!AJ14-記入用紙!AP14,0)","v":0},{"$f":"IF(G19-記入用紙!BV14-SUM(I19:J19)>0,G19-記入用紙!BV14-SUM(I19:J19),0)","v":0},{"$f":"IF(記入用紙!BX14<>\"\", IF(J19<>\"\",  記入用紙!BX14-J19,記入用紙!BX14),\"\")","v":""},{"$f":"記入用紙!AR14","v":0},{"$f":"IF(AND(OR(記入用紙!$AC14=0,記入用紙!$AC14=1), 記入用紙!$AC14<>\"\"),記入用紙!$AD14/4,\"\")","v":""},null,null,null,""]
["",11,{"$f":"IF(記入用紙!B15<>\"\",記入用紙!B15,\"\")","v":44207},{"$f":"記入用紙!Y15","v":"00:00:00"},{"$f":"記入用紙!AA15","v":"00:00:00"},{"$f":"IF(記入用紙!CB15<>\"\",(\"【\"&記入用紙!CB15&\"】\"),\"\")&記入用紙!AT15&IF(AND(記入用紙!BT15<>\"\",記入用紙!BG15<>\"\"),CHAR(10)&\"【\"&記入用紙!BT15&\"】\"&記入用紙!BG15,\"\")","v":"【成人の日】"},{"$f":"IF(D20<>0, 記入用紙!AF15-記入用紙!AH15-記入用紙!AJ15-記入用紙!AP15,0)","v":0},{"$f":"IF(G20-記入用紙!BV15-SUM(I20:J20)>0,G20-記入用紙!BV15-SUM(I20:J20),0)","v":0},{"$f":"IF(記入用紙!BX15<>\"\", IF(J20<>\"\",  記入用紙!BX15-J20,記入用紙!BX15),\"\")","v":""},{"$f":"記入用紙!AR15","v":0},{"$f":"IF(AND(OR(記入用紙!$AC15=0,記入用紙!$AC15=1), 記入用紙!$AC15<>\"\"),記入用紙!$AD15/4,\"\")","v":""},null,null,null,""]
["",12,{"$f":"IF(記入用紙!B16<>\"\",記入用紙!B16,\"\")","v":44208},{"$f":"記入用紙!Y16","v":"00:00:00"},{"$f":"記入用紙!AA16","v":"00:00:00"},{"$f":"IF(記入用紙!CB16<>\"\",(\"【\"&記入用紙!CB16&\"】\"),\"\")&記入用紙!AT16&IF(AND(記入用紙!BT16<>\"\",記入用紙!BG16<>\"\"),CHAR(10)&\"【\"&記入用紙!BT16&\"】\"&記入用紙!BG16,\"\")","v":""},{"$f":"IF(D21<>0, 記入用紙!AF16-記入用紙!AH16-記入用紙!AJ16-記入用紙!AP16,0)","v":0},{"$f":"IF(G21-記入用紙!BV16-SUM(I21:J21)>0,G21-記入用紙!BV16-SUM(I21:J21),0)","v":0},{"$f":"IF(記入用紙!BX16<>\"\", IF(J21<>\"\",  記入用紙!BX16-J21,記入用紙!BX16),\"\")","v":""},{"$f":"記入用紙!AR16","v":0},{"$f":"IF(AND(OR(記入用紙!$AC16=0,記入用紙!$AC16=1), 記入用紙!$AC16<>\"\"),記入用紙!$AD16/4,\"\")","v":""}]
["",13,{"$f":"IF(記入用紙!B17<>\"\",記入用紙!B17,\"\")","v":44209},{"$f":"記入用紙!Y17","v":"00:00:00"},{"$f":"記入用紙!AA17","v":"00:00:00"},{"$f":"IF(記入用紙!CB17<>\"\",(\"【\"&記入用紙!CB17&\"】\"),\"\")&記入用紙!AT17&IF(AND(記入用紙!BT17<>\"\",記入用紙!BG17<>\"\"),CHAR(10)&\"【\"&記入用紙!BT17&\"】\"&記入用紙!BG17,\"\")","v":""},{"$f":"IF(D22<>0, 記入用紙!AF17-記入用紙!AH17-記入用紙!AJ17-記入用紙!AP17,0)","v":0},{"$f":"IF(G22-記入用紙!BV17-SUM(I22:J22)>0,G22-記入用紙!BV17-SUM(I22:J22),0)","v":0},{"$f":"IF(記入用紙!BX17<>\"\", IF(J22<>\"\",  記入用紙!BX17-J22,記入用紙!BX17),\"\")","v":""},{"$f":"記入用紙!AR17","v":0},{"$f":"IF(AND(OR(記入用紙!$AC17=0,記入用紙!$AC17=1), 記入用紙!$AC17<>\"\"),記入用紙!$AD17/4,\"\")","v":""}]
["",14,{"$f":"IF(記入用紙!B18<>\"\",記入用紙!B18,\"\")","v":44210},{"$f":"記入用紙!Y18","v":"00:00:00"},{"$f":"記入用紙!AA18","v":"00:00:00"},{"$f":"IF(記入用紙!CB18<>\"\",(\"【\"&記入用紙!CB18&\"】\"),\"\")&記入用紙!AT18&IF(AND(記入用紙!BT18<>\"\",記入用紙!BG18<>\"\"),CHAR(10)&\"【\"&記入用紙!BT18&\"】\"&記入用紙!BG18,\"\")","v":""},{"$f":"IF(D23<>0, 記入用紙!AF18-記入用紙!AH18-記入用紙!AJ18-記入用紙!AP18,0)","v":0},{"$f":"IF(G23-記入用紙!BV18-SUM(I23:J23)>0,G23-記入用紙!BV18-SUM(I23:J23),0)","v":0},{"$f":"IF(記入用紙!BX18<>\"\", IF(J23<>\"\",  記入用紙!BX18-J23,記入用紙!BX18),\"\")","v":""},{"$f":"記入用紙!AR18","v":0},{"$f":"IF(AND(OR(記入用紙!$AC18=0,記入用紙!$AC18=1), 記入用紙!$AC18<>\"\"),記入用紙!$AD18/4,\"\")","v":""}]
["",15,{"$f":"IF(記入用紙!B19<>\"\",記入用紙!B19,\"\")","v":44211},{"$f":"記入用紙!Y19","v":"00:00:00"},{"$f":"記入用紙!AA19","v":"00:00:00"},{"$f":"IF(記入用紙!CB19<>\"\",(\"【\"&記入用紙!CB19&\"】\"),\"\")&記入用紙!AT19&IF(AND(記入用紙!BT19<>\"\",記入用紙!BG19<>\"\"),CHAR(10)&\"【\"&記入用紙!BT19&\"】\"&記入用紙!BG19,\"\")","v":""},{"$f":"IF(D24<>0, 記入用紙!AF19-記入用紙!AH19-記入用紙!AJ19-記入用紙!AP19,0)","v":0},{"$f":"IF(G24-記入用紙!BV19-SUM(I24:J24)>0,G24-記入用紙!BV19-SUM(I24:J24),0)","v":0},{"$f":"IF(記入用紙!BX19<>\"\", IF(J24<>\"\",  記入用紙!BX19-J24,記入用紙!BX19),\"\")","v":""},{"$f":"記入用紙!AR19","v":0},{"$f":"IF(AND(OR(記入用紙!$AC19=0,記入用紙!$AC19=1), 記入用紙!$AC19<>\"\"),記入用紙!$AD19/4,\"\")","v":""}]
["",16,{"$f":"IF(記入用紙!B20<>\"\",記入用紙!B20,\"\")","v":44212},{"$f":"記入用紙!Y20","v":"00:00:00"},{"$f":"記入用紙!AA20","v":"00:00:00"},{"$f":"IF(記入用紙!CB20<>\"\",(\"【\"&記入用紙!CB20&\"】\"),\"\")&記入用紙!AT20&IF(AND(記入用紙!BT20<>\"\",記入用紙!BG20<>\"\"),CHAR(10)&\"【\"&記入用紙!BT20&\"】\"&記入用紙!BG20,\"\")","v":""},{"$f":"IF(D25<>0, 記入用紙!AF20-記入用紙!AH20-記入用紙!AJ20-記入用紙!AP20,0)","v":0},{"$f":"IF(G25-記入用紙!BV20-SUM(I25:J25)>0,G25-記入用紙!BV20-SUM(I25:J25),0)","v":0},{"$f":"IF(記入用紙!BX20<>\"\", IF(J25<>\"\",  記入用紙!BX20-J25,記入用紙!BX20),\"\")","v":""},{"$f":"記入用紙!AR20","v":0},{"$f":"IF(AND(OR(記入用紙!$AC20=0,記入用紙!$AC20=1), 記入用紙!$AC20<>\"\"),記入用紙!$AD20/4,\"\")","v":""}]
["",17,{"$f":"IF(記入用紙!B21<>\"\",記入用紙!B21,\"\")","v":44213},{"$f":"記入用紙!Y21","v":"00:00:00"},{"$f":"記入用紙!AA21","v":"00:00:00"},{"$f":"IF(記入用紙!CB21<>\"\",(\"【\"&記入用紙!CB21&\"】\"),\"\")&記入用紙!AT21&IF(AND(記入用紙!BT21<>\"\",記入用紙!BG21<>\"\"),CHAR(10)&\"【\"&記入用紙!BT21&\"】\"&記入用紙!BG21,\"\")","v":""},{"$f":"IF(D26<>0, 記入用紙!AF21-記入用紙!AH21-記入用紙!AJ21-記入用紙!AP21,0)","v":0},{"$f":"IF(G26-記入用紙!BV21-SUM(I26:J26)>0,G26-記入用紙!BV21-SUM(I26:J26),0)","v":0},{"$f":"IF(記入用紙!BX21<>\"\", IF(J26<>\"\",  記入用紙!BX21-J26,記入用紙!BX21),\"\")","v":""},{"$f":"記入用紙!AR21","v":0},{"$f":"IF(AND(OR(記入用紙!$AC21=0,記入用紙!$AC21=1), 記入用紙!$AC21<>\"\"),記入用紙!$AD21/4,\"\")","v":""}]
["",18,{"$f":"IF(記入用紙!B22<>\"\",記入用紙!B22,\"\")","v":44214},{"$f":"記入用紙!Y22","v":"00:00:00"},{"$f":"記入用紙!AA22","v":"00:00:00"},{"$f":"IF(記入用紙!CB22<>\"\",(\"【\"&記入用紙!CB22&\"】\"),\"\")&記入用紙!AT22&IF(AND(記入用紙!BT22<>\"\",記入用紙!BG22<>\"\"),CHAR(10)&\"【\"&記入用紙!BT22&\"】\"&記入用紙!BG22,\"\")","v":""},{"$f":"IF(D27<>0, 記入用紙!AF22-記入用紙!AH22-記入用紙!AJ22-記入用紙!AP22,0)","v":0},{"$f":"IF(G27-記入用紙!BV22-SUM(I27:J27)>0,G27-記入用紙!BV22-SUM(I27:J27),0)","v":0},{"$f":"IF(記入用紙!BX22<>\"\", IF(J27<>\"\",  記入用紙!BX22-J27,記入用紙!BX22),\"\")","v":""},{"$f":"記入用紙!AR22","v":0},{"$f":"IF(AND(OR(記入用紙!$AC22=0,記入用紙!$AC22=1), 記入用紙!$AC22<>\"\"),記入用紙!$AD22/4,\"\")","v":""}]
["",19,{"$f":"IF(記入用紙!B23<>\"\",記入用紙!B23,\"\")","v":44215},{"$f":"記入用紙!Y23","v":"00:00:00"},{"$f":"記入用紙!AA23","v":"00:00:00"},{"$f":"IF(記入用紙!CB23<>\"\",(\"【\"&記入用紙!CB23&\"】\"),\"\")&記入用紙!AT23&IF(AND(記入用紙!BT23<>\"\",記入用紙!BG23<>\"\"),CHAR(10)&\"【\"&記入用紙!BT23&\"】\"&記入用紙!BG23,\"\")","v":""},{"$f":"IF(D28<>0, 記入用紙!AF23-記入用紙!AH23-記入用紙!AJ23-記入用紙!AP23,0)","v":0},{"$f":"IF(G28-記入用紙!BV23-SUM(I28:J28)>0,G28-記入用紙!BV23-SUM(I28:J28),0)","v":0},{"$f":"IF(記入用紙!BX23<>\"\", IF(J28<>\"\",  記入用紙!BX23-J28,記入用紙!BX23),\"\")","v":""},{"$f":"記入用紙!AR23","v":0},{"$f":"IF(AND(OR(記入用紙!$AC23=0,記入用紙!$AC23=1), 記入用紙!$AC23<>\"\"),記入用紙!$AD23/4,\"\")","v":""}]
["",20,{"$f":"IF(記入用紙!B24<>\"\",記入用紙!B24,\"\")","v":44216},{"$f":"記入用紙!Y24","v":"00:00:00"},{"$f":"記入用紙!AA24","v":"00:00:00"},{"$f":"IF(記入用紙!CB24<>\"\",(\"【\"&記入用紙!CB24&\"】\"),\"\")&記入用紙!AT24&IF(AND(記入用紙!BT24<>\"\",記入用紙!BG24<>\"\"),CHAR(10)&\"【\"&記入用紙!BT24&\"】\"&記入用紙!BG24,\"\")","v":""},{"$f":"IF(D29<>0, 記入用紙!AF24-記入用紙!AH24-記入用紙!AJ24-記入用紙!AP24,0)","v":0},{"$f":"IF(G29-記入用紙!BV24-SUM(I29:J29)>0,G29-記入用紙!BV24-SUM(I29:J29),0)","v":0},{"$f":"IF(記入用紙!BX24<>\"\", IF(J29<>\"\",  記入用紙!BX24-J29,記入用紙!BX24),\"\")","v":""},{"$f":"記入用紙!AR24","v":0},{"$f":"IF(AND(OR(記入用紙!$AC24=0,記入用紙!$AC24=1), 記入用紙!$AC24<>\"\"),記入用紙!$AD24/4,\"\")","v":""}]
["",21,{"$f":"IF(記入用紙!B25<>\"\",記入用紙!B25,\"\")","v":44217},{"$f":"記入用紙!Y25","v":"00:00:00"},{"$f":"記入用紙!AA25","v":"00:00:00"},{"$f":"IF(記入用紙!CB25<>\"\",(\"【\"&記入用紙!CB25&\"】\"),\"\")&記入用紙!AT25&IF(AND(記入用紙!BT25<>\"\",記入用紙!BG25<>\"\"),CHAR(10)&\"【\"&記入用紙!BT25&\"】\"&記入用紙!BG25,\"\")","v":""},{"$f":"IF(D30<>0, 記入用紙!AF25-記入用紙!AH25-記入用紙!AJ25-記入用紙!AP25,0)","v":0},{"$f":"IF(G30-記入用紙!BV25-SUM(I30:J30)>0,G30-記入用紙!BV25-SUM(I30:J30),0)","v":0},{"$f":"IF(記入用紙!BX25<>\"\", IF(J30<>\"\",  記入用紙!BX25-J30,記入用紙!BX25),\"\")","v":""},{"$f":"記入用紙!AR25","v":0},{"$f":"IF(AND(OR(記入用紙!$AC25=0,記入用紙!$AC25=1), 記入用紙!$AC25<>\"\"),記入用紙!$AD25/4,\"\")","v":""}]
["",22,{"$f":"IF(記入用紙!B26<>\"\",記入用紙!B26,\"\")","v":44218},{"$f":"記入用紙!Y26","v":"00:00:00"},{"$f":"記入用紙!AA26","v":"00:00:00"},{"$f":"IF(記入用紙!CB26<>\"\",(\"【\"&記入用紙!CB26&\"】\"),\"\")&記入用紙!AT26&IF(AND(記入用紙!BT26<>\"\",記入用紙!BG26<>\"\"),CHAR(10)&\"【\"&記入用紙!BT26&\"】\"&記入用紙!BG26,\"\")","v":""},{"$f":"IF(D31<>0, 記入用紙!AF26-記入用紙!AH26-記入用紙!AJ26-記入用紙!AP26,0)","v":0},{"$f":"IF(G31-記入用紙!BV26-SUM(I31:J31)>0,G31-記入用紙!BV26-SUM(I31:J31),0)","v":0},{"$f":"IF(記入用紙!BX26<>\"\", IF(J31<>\"\",  記入用紙!BX26-J31,記入用紙!BX26),\"\")","v":""},{"$f":"記入用紙!AR26","v":0},{"$f":"IF(AND(OR(記入用紙!$AC26=0,記入用紙!$AC26=1), 記入用紙!$AC26<>\"\"),記入用紙!$AD26/4,\"\")","v":""}]
["",23,{"$f":"IF(記入用紙!B27<>\"\",記入用紙!B27,\"\")","v":44219},{"$f":"記入用紙!Y27","v":"00:00:00"},{"$f":"記入用紙!AA27","v":"00:00:00"},{"$f":"IF(記入用紙!CB27<>\"\",(\"【\"&記入用紙!CB27&\"】\"),\"\")&記入用紙!AT27&IF(AND(記入用紙!BT27<>\"\",記入用紙!BG27<>\"\"),CHAR(10)&\"【\"&記入用紙!BT27&\"】\"&記入用紙!BG27,\"\")","v":""},{"$f":"IF(D32<>0, 記入用紙!AF27-記入用紙!AH27-記入用紙!AJ27-記入用紙!AP27,0)","v":0},{"$f":"IF(G32-記入用紙!BV27-SUM(I32:J32)>0,G32-記入用紙!BV27-SUM(I32:J32),0)","v":0},{"$f":"IF(記入用紙!BX27<>\"\", IF(J32<>\"\",  記入用紙!BX27-J32,記入用紙!BX27),\"\")","v":""},{"$f":"記入用紙!AR27","v":0},{"$f":"IF(AND(OR(記入用紙!$AC27=0,記入用紙!$AC27=1), 記入用紙!$AC27<>\"\"),記入用紙!$AD27/4,\"\")","v":""}]
["",24,{"$f":"IF(記入用紙!B28<>\"\",記入用紙!B28,\"\")","v":44220},{"$f":"記入用紙!Y28","v":"00:00:00"},{"$f":"記入用紙!AA28","v":"00:00:00"},{"$f":"IF(記入用紙!CB28<>\"\",(\"【\"&記入用紙!CB28&\"】\"),\"\")&記入用紙!AT28&IF(AND(記入用紙!BT28<>\"\",記入用紙!BG28<>\"\"),CHAR(10)&\"【\"&記入用紙!BT28&\"】\"&記入用紙!BG28,\"\")","v":""},{"$f":"IF(D33<>0, 記入用紙!AF28-記入用紙!AH28-記入用紙!AJ28-記入用紙!AP28,0)","v":0},{"$f":"IF(G33-記入用紙!BV28-SUM(I33:J33)>0,G33-記入用紙!BV28-SUM(I33:J33),0)","v":0},{"$f":"IF(記入用紙!BX28<>\"\", IF(J33<>\"\",  記入用紙!BX28-J33,記入用紙!BX28),\"\")","v":""},{"$f":"記入用紙!AR28","v":0},{"$f":"IF(AND(OR(記入用紙!$AC28=0,記入用紙!$AC28=1), 記入用紙!$AC28<>\"\"),記入用紙!$AD28/4,\"\")","v":""}]
["",25,{"$f":"IF(記入用紙!B29<>\"\",記入用紙!B29,\"\")","v":44221},{"$f":"記入用紙!Y29","v":"00:00:00"},{"$f":"記入用紙!AA29","v":"00:00:00"},{"$f":"IF(記入用紙!CB29<>\"\",(\"【\"&記入用紙!CB29&\"】\"),\"\")&記入用紙!AT29&IF(AND(記入用紙!BT29<>\"\",記入用紙!BG29<>\"\"),CHAR(10)&\"【\"&記入用紙!BT29&\"】\"&記入用紙!BG29,\"\")","v":""},{"$f":"IF(D34<>0, 記入用紙!AF29-記入用紙!AH29-記入用紙!AJ29-記入用紙!AP29,0)","v":0},{"$f":"IF(G34-記入用紙!BV29-SUM(I34:J34)>0,G34-記入用紙!BV29-SUM(I34:J34),0)","v":0},{"$f":"IF(記入用紙!BX29<>\"\", IF(J34<>\"\",  記入用紙!BX29-J34,記入用紙!BX29),\"\")","v":""},{"$f":"記入用紙!AR29","v":0},{"$f":"IF(AND(OR(記入用紙!$AC29=0,記入用紙!$AC29=1), 記入用紙!$AC29<>\"\"),記入用紙!$AD29/4,\"\")","v":""}]
["",26,{"$f":"IF(記入用紙!B30<>\"\",記入用紙!B30,\"\")","v":44222},{"$f":"記入用紙!Y30","v":"00:00:00"},{"$f":"記入用紙!AA30","v":"00:00:00"},{"$f":"IF(記入用紙!CB30<>\"\",(\"【\"&記入用紙!CB30&\"】\"),\"\")&記入用紙!AT30&IF(AND(記入用紙!BT30<>\"\",記入用紙!BG30<>\"\"),CHAR(10)&\"【\"&記入用紙!BT30&\"】\"&記入用紙!BG30,\"\")","v":""},{"$f":"IF(D35<>0, 記入用紙!AF30-記入用紙!AH30-記入用紙!AJ30-記入用紙!AP30,0)","v":0},{"$f":"IF(G35-記入用紙!BV30-SUM(I35:J35)>0,G35-記入用紙!BV30-SUM(I35:J35),0)","v":0},{"$f":"IF(記入用紙!BX30<>\"\", IF(J35<>\"\",  記入用紙!BX30-J35,記入用紙!BX30),\"\")","v":""},{"$f":"記入用紙!AR30","v":0},{"$f":"IF(AND(OR(記入用紙!$AC30=0,記入用紙!$AC30=1), 記入用紙!$AC30<>\"\"),記入用紙!$AD30/4,\"\")","v":""}]
["",27,{"$f":"IF(記入用紙!B31<>\"\",記入用紙!B31,\"\")","v":44223},{"$f":"記入用紙!Y31","v":"00:00:00"},{"$f":"記入用紙!AA31","v":"00:00:00"},{"$f":"IF(記入用紙!CB31<>\"\",(\"【\"&記入用紙!CB31&\"】\"),\"\")&記入用紙!AT31&IF(AND(記入用紙!BT31<>\"\",記入用紙!BG31<>\"\"),CHAR(10)&\"【\"&記入用紙!BT31&\"】\"&記入用紙!BG31,\"\")","v":""},{"$f":"IF(D36<>0, 記入用紙!AF31-記入用紙!AH31-記入用紙!AJ31-記入用紙!AP31,0)","v":0},{"$f":"IF(G36-記入用紙!BV31-SUM(I36:J36)>0,G36-記入用紙!BV31-SUM(I36:J36),0)","v":0},{"$f":"IF(記入用紙!BX31<>\"\", IF(J36<>\"\",  記入用紙!BX31-J36,記入用紙!BX31),\"\")","v":""},{"$f":"記入用紙!AR31","v":0},{"$f":"IF(AND(OR(記入用紙!$AC31=0,記入用紙!$AC31=1), 記入用紙!$AC31<>\"\"),記入用紙!$AD31/4,\"\")","v":""}]
["",28,{"$f":"IF(記入用紙!B32<>\"\",記入用紙!B32,\"\")","v":44224},{"$f":"記入用紙!Y32","v":"00:00:00"},{"$f":"記入用紙!AA32","v":"00:00:00"},{"$f":"IF(記入用紙!CB32<>\"\",(\"【\"&記入用紙!CB32&\"】\"),\"\")&記入用紙!AT32&IF(AND(記入用紙!BT32<>\"\",記入用紙!BG32<>\"\"),CHAR(10)&\"【\"&記入用紙!BT32&\"】\"&記入用紙!BG32,\"\")","v":""},{"$f":"IF(D37<>0, 記入用紙!AF32-記入用紙!AH32-記入用紙!AJ32-記入用紙!AP32,0)","v":0},{"$f":"IF(G37-記入用紙!BV32-SUM(I37:J37)>0,G37-記入用紙!BV32-SUM(I37:J37),0)","v":0},{"$f":"IF(記入用紙!BX32<>\"\", IF(J37<>\"\",  記入用紙!BX32-J37,記入用紙!BX32),\"\")","v":""},{"$f":"記入用紙!AR32","v":0},{"$f":"IF(AND(OR(記入用紙!$AC32=0,記入用紙!$AC32=1), 記入用紙!$AC32<>\"\"),記入用紙!$AD32/4,\"\")","v":""},null,"代休消化時間",null,null,null,{"$f":"記入用紙!R39","v":0}]
[null,{"$f":"IF(記入用紙!B33<>\"\",29,\"\")","v":29},{"$f":"IF(記入用紙!B33<>\"\",記入用紙!B33,\"\")","v":44225},{"$f":"記入用紙!Y33","v":"00:00:00"},{"$f":"記入用紙!AA33","v":"00:00:00"},{"$f":"IF(記入用紙!CB33<>\"\",(\"【\"&記入用紙!CB33&\"】\"),\"\")&記入用紙!AT33&IF(AND(記入用紙!BT33<>\"\",記入用紙!BG33<>\"\"),CHAR(10)&\"【\"&記入用紙!BT33&\"】\"&記入用紙!BG33,\"\")","v":""},{"$f":"IF(D38<>0, 記入用紙!AF33-記入用紙!AH33-記入用紙!AJ33-記入用紙!AP33,0)","v":0},{"$f":"IF(G38-記入用紙!BV33-SUM(I38:J38)>0,G38-記入用紙!BV33-SUM(I38:J38),0)","v":0},{"$f":"IF(記入用紙!BX33<>\"\", IF(J38<>\"\",  記入用紙!BX33-J38,記入用紙!BX33),\"\")","v":""},{"$f":"記入用紙!AR33","v":0},{"$f":"IF(AND(OR(記入用紙!$AC33=0,記入用紙!$AC33=1), 記入用紙!$AC33<>\"\"),記入用紙!$AD33/4,\"\")","v":""},null,"時間外",null,null,null,{"$f":"H41","v":0}]
[null,{"$f":"IF(記入用紙!B34<>\"\",30,\"\")","v":30},{"$f":"IF(記入用紙!B34<>\"\",記入用紙!B34,\"\")","v":44226},{"$f":"記入用紙!Y34","v":"00:00:00"},{"$f":"記入用紙!AA34","v":"00:00:00"},{"$f":"IF(記入用紙!CB34<>\"\",(\"【\"&記入用紙!CB34&\"】\"),\"\")&記入用紙!AT34&IF(AND(記入用紙!BT34<>\"\",記入用紙!BG34<>\"\"),CHAR(10)&\"【\"&記入用紙!BT34&\"】\"&記入用紙!BG34,\"\")","v":""},{"$f":"IF(D39<>0, 記入用紙!AF34-記入用紙!AH34-記入用紙!AJ34-記入用紙!AP34,0)","v":0},{"$f":"IF(G39-記入用紙!BV34-SUM(I39:J39)>0,G39-記入用紙!BV34-SUM(I39:J39),0)","v":0},{"$f":"IF(記入用紙!BX34<>\"\", IF(J39<>\"\",  記入用紙!BX34-J39,記入用紙!BX34),\"\")","v":""},{"$f":"記入用紙!AR34","v":0},{"$f":"IF(AND(OR(記入用紙!$AC34=0,記入用紙!$AC34=1), 記入用紙!$AC34<>\"\"),記入用紙!$AD34/4,\"\")","v":""},null,"深夜",null,null,null,{"$f":"J41-Q41","v":0}]
["",{"$f":"IF(記入用紙!B35<>\"\",31,\"\")","v":31},{"$f":"IF(記入用紙!B35<>\"\",記入用紙!B35,\"\")","v":44227},{"$f":"記入用紙!Y35","v":"00:00:00"},{"$f":"記入用紙!AA35","v":"00:00:00"},{"$f":"IF(記入用紙!CB35<>\"\",(\"【\"&記入用紙!CB35&\"】\"),\"\")&記入用紙!AT35&IF(AND(記入用紙!BT35<>\"\",記入用紙!BG35<>\"\"),CHAR(10)&\"【\"&記入用紙!BT35&\"】\"&記入用紙!BG35,\"\")","v":""},{"$f":"IF(D40<>0, 記入用紙!AF35-記入用紙!AH35-記入用紙!AJ35-記入用紙!AP35,0)","v":0},{"$f":"IF(G40-記入用紙!BV35-SUM(I40:J40)>0,G40-記入用紙!BV35-SUM(I40:J40),0)","v":0},{"$f":"IF(記入用紙!BX35<>\"\", IF(J40<>\"\",  記入用紙!BX35-J40,記入用紙!BX35),\"\")","v":""},{"$f":"記入用紙!AR35","v":0},{"$f":"IF(AND(OR(記入用紙!$AC35=0,記入用紙!$AC35=1), 記入用紙!$AC35<>\"\"),記入用紙!$AD35/4,\"\")","v":""},null,"休日\n(休日- 休日深夜-代休)",null,null,null,{"$f":"I41-Q37","v":0}]
[null,"合           計",null,null,null,null,{"$f":"SUM(G10:G40)","v":0},{"$f":"SUM(H10:H40)","v":0},{"$f":"SUM(I10:I40)","v":0},{"$f":"SUM(J10:J40)","v":0},{"$f":"IF(AND(OR(記入用紙!$AC36=0,記入用紙!$AC36=1), 記入用紙!$AC36<>\"\"),記入用紙!$AD36/4,\"\")","v":""},null,"休日深夜",null,null,null,{"$f":"記入用紙!AK43","v":0}]
[null,{"$f":"\"遅刻早退回数：  \" &  記入用紙!AA37 & \" 回\"","v":"遅刻早退回数：  0 回"},null,null,null,{"$f":"\"  遅刻早退時間：  \" & 記入用紙!AA38&\" 時間\"","v":"  遅刻早退時間：  0 時間"},"普通残業時間： ",null,{"$f":"H41","v":0},null,null,null,"残業時間総数",null,null,null,{"$f":"SUM(Q38:Q41)","v":0}]
[null,{"$f":"\"当月有休取得日数：  \" &  記入用紙!R37 & \" 日\"","v":"当月有休取得日数：  0 日"},null,null,null,{"$f":"\"  有給休暇残日数：  \" & 記入用紙!R43&\" 日\"","v":"  有給休暇残日数：  30 日"}]
[]
[null,null,null,null,null,null,"基本給"]
[null,null,null,null,null,null,"基本時給"]
[null,null,null,null,null,null,"清算",{"$f":"Q42","v":0},null,"倍率"]
[null,null,null,null,null,null,"普通",{"$f":"Q38","v":0},null,1.25,{"$f":"(H45*J48*H48)/176","v":0}]
[null,null,null,null,null,null,"深夜",{"$f":"Q39","v":0},null,1.5,{"$f":"(H46*J49*H49)/176","v":0}]
[null,null,null,null,null,null,"休出",{"$f":"Q40","v":0},null,1.35,{"$f":"(H47*J50*H50)/176","v":0}]
[null,null,null,null,null,null,"休日深夜",{"$f":"Q41","v":0},null,1.6,{"$f":"(H48*J51*H51)/176","v":0}]
[null,null,null,null,null,null,null,null,null,"残業",{"$f":"ROUNDUP(SUM(K48:K51),0)","v":0}]
[null,null,null,null,null,null,null,null,null,"総額",{"$f":"ROUNDUP(H45+K52,0)","v":0}]

{"sheet":"祝日一覧","index":5,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["祝日",null,"※令和3年祝日一覧"]
["01/01","元旦"]
["01/02","年始休暇"]
["01/03","年始休暇"]
["01/11","成人の日"]
["02/11","建国記念の日"]
["02/23","天皇誕生日"]
["03/20","春分の日"]
["04/29","昭和の日"]
["05/03","憲法記念日"]
["05/04","みどりの日"]
["05/05","こどもの日"]
["07/22","海の日"]
["07/23","スポーツの日"]
["08/08","山の日"]
["08/09","山の日振替休日"]
["09/20","敬老の日"]
["09/23","秋分の日"]
["11/03","文化の日"]
["11/23","勤労感謝の日"]
["12/29","年末休暇"]
["12/30","年末休暇"]
["12/31","大晦日"]

{"sheet":"202012","index":6,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[52,10,52,11],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[47,10,47,11],[48,7,48,8],[48,10,48,11],[49,7,49,8],[49,10,49,11],[50,7,50,8],[50,10,50,11],[51,10,51,11],[41,12,41,15],[1,4,1,6],[4,3,4,4],[4,5,4,7],[5,3,5,4],[5,5,5,7],[7,5,8,5],[36,12,36,15],[37,12,37,15],[38,12,38,15],[39,12,39,15],[40,12,40,15]]}
[]
[null,null,null,null,"2020 年 12 月度勤務証明書"]
[]
[]
[null,"所属 ： ",null,"株式会社エムズ",null,"業務名 ： 社内業務"]
[null,"氏名 ： 中村 通弘",null,"中村 通弘",null,"作業場所 ： 市ヶ谷　ソフト開発センター"]
[]
[null,"日","曜","作  業  時  間",null,"作　業　内　容　記　入　欄\nお　よ　び　勤　怠　理　由","作  業","精  算","時  間  外",null,"遅刻\n早退"]
[null,"付","日","  自","  至",null,"時間数","時間数","休  日","深  夜","時間"]
["",1,44166,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,"",null,"","",""]
["",2,44167,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,"",null,"","",""]
["",3,44168,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,"",null,"","",""]
["",4,44169,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,"",null,"","",""]
["",5,44170,"00:00:00","00:00:00","",0,0,"",0,"",null,"","",""]
["",6,44171,"00:00:00","00:00:00","",0,0,"",0,"",null,"","",""]
["",7,44172,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,"",null,"","",""]
["",8,44173,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,"",null,null,null,""]
["",9,44174,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,"",null,null,null,""]
["",10,44175,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,"",null,null,null,""]
["",11,44176,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,"",null,null,null,""]
["",12,44177,"00:00:00","00:00:00","",0,0,"",0,""]
["",13,44178,"00:00:00","00:00:00","",0,0,"",0,""]
["",14,44179,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,""]
["",15,44180,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,""]
["",16,44181,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,""]
["",17,44182,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,""]
["",18,44183,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,""]
["",19,44184,"00:00:00","00:00:00","",0,0,"",0,""]
["",20,44185,"00:00:00","00:00:00","",0,0,"",0,""]
["",21,44186,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,""]
["",22,44187,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,""]
["",23,44188,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,""]
["",24,44189,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,""]
["",25,44190,"09:00:00","18:00:00","市ヶ谷ソフト開発センター社内業務（在宅）",8,0,"",0,""]
["",26,44191,"00:00:00","00:00:00","",0,0,"",0,""]
["",27,44192,"00:00:00","00:00:00","",0,0,"",0,""]
["",28,44193,"08:00:00","17:00:00","Pythonエンジニア基礎試験受験",8.0000000000000018,1.7763568394002505E-15,"",0,"",null,"代休消化時間",null,null,null,0]
[null,29,44194,"00:00:00","00:00:00","【年末休暇】",0,0,"",0,"",null,"時間外",null,null,null,1.7763568394002505E-15]
[null,30,44195,"00:00:00","00:00:00","【年末休暇】",0,0,"",0,"",null,"深夜",null,null,null,0]
["",31,44196,"00:00:00","00:00:00","【大晦日】",0,0,"",0,"",null,"休日\n(休日- 休日深夜-代休)",null,null,null,0]
[null,"合           計",null,null,null,null,160,1.7763568394002505E-15,0,0,"",null,"休日深夜",null,null,null,0]
[null,"遅刻早退回数：  0 回",null,null,null,"  遅刻早退時間：  0 時間","普通残業時間： ",null,1.7763568394002505E-15,null,null,null,"残業時間総数",null,null,null,1.7763568394002505E-15]
[null,"当月有休取得日数：  0 日",null,null,null,"  有給休暇残日数：  33.5 日"]