{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["使い方・使用許諾","原則・1か月変形","（非表示・計算用）原則・1か月変形"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"comments":2,"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":67,"n_cols":8,"rows_kept":67,"cut":false,"hidden":false,"merged":[[39,4,39,5],[39,6,39,7],[41,4,43,4],[47,4,49,4],[44,4,46,4],[41,6,41,7],[42,6,42,7],[44,6,44,7],[45,6,45,7]]}
["このツールについて"]
["・労働基準法上の「時間外労働」「休日労働」「深夜労働」の時間数を計算するツールです。"]
["・変形労働時間制を導入していない場合と1か月単位変形労働時間制に対応しています。"]
["・バージョンの古いエクセルでは利用できない場合があります。"]
["・全ての勤怠状況において正しい時間計算を行うことを保証するものではありません。計算結果は自己責任でご利用ください。"]
[]
["使い方"]
["・計算条件と勤怠状況（勤務予定と勤務実績）を入力して「計算する」ボタンを押して下さい。"]
["・15行目が当月の初日です。A15セルに月の起算日を入力してください。"]
["・9～14行目は前月期間です。週が月をまたぐ場合に第1週目の週40時間超を計算したい場合に勤務実績を入力してください。"]
[]
["用語の説明"]
["番号","項目","説明"]
["①","所定労働時間","就業規則等で定めている1日の所定労働時間"]
["②","有給休暇時間","年次有給休暇や会社が定める有給の特別休暇を取得した時間（有給の不就労時間）"]
["③","実働時間","実際に就労した時間（＝⑱法定内労働＋⑧時間外労働＋④法定休日労働）"]
["④","法定休日労働時間","法定休日（0時～24時）の労働時間"]
["⑤","時間外労働時間（1日）","1日の法定労働時間を超える時間外労働時間"]
["⑥","時間外労働時間（週）","週の法定労働時間を超える時間外労働時間（⑤を除く）"]
["⑦","時間外労働時間（月）","月の法定労働時間を超える時間外労働時間（⑤⑥を除く）"]
["⑧","時間外労働時間（合計）","時間外労働時間（⑤～⑦の合計）"]
["⑨","時間外労働時間（60時間以下・勤務日）","⑧時間外労働のうち、月60時間以下で所定勤務日に行った時間"]
["⑩","時間外労働時間（60時間以下・所定休日）","⑧時間外労働のうち、月60時間以下で所定休日に行った時間"]
["⑪","時間外労働時間（60時間超・勤務日）","⑧時間外労働のうち、月60時間超で所定勤務日に行った時間"]
["⑫","時間外労働時間（60時間超・所定休日）","⑧時間外労働のうち、月60時間超で所定休日に行った時間"]
["⑬","深夜労働時間","深夜（22時～翌5時）の労働時間"]
["⑭","所定内労働時間","所定労働時間までの労働時間"]
["⑮","振替出勤","休日振替によって勤務した時間（⑧時間外労働と⑯所定外労働を除く）"]
["⑯","所定外労働時間","所定労働時間を超え法定労働時間までの労働時間（いわゆる法定内残業）"]
["⑰","所定休日労働時間","所定休日の労働時間（⑧時間外労働時間を除く）"]
["⑱","法定内労働時間（合計）","法定労働時間内の総労働時間（＝⑭所定内労働＋⑮振替出勤＋⑯所定外労働＋⑰所定休日労働）"]
["⑲","欠勤等時間","欠勤・遅刻・早退・無給の休暇などで通常賃金から控除する時間（無給の不就労時間）"]
["⑳","振替休日","振替休日（代休含む）の取得によって通常賃金から控除する時間"]
["㉑","100％賃金相殺時間","割増賃金の計算において100％部分を相殺して割増部分のみを支払う時間"]
["㉒","控除時間（合計）","控除時間の合計（＝⑲欠勤等時間＋⑳振替休日＋㉑100％賃金相殺時間）"]
["※⑭～㉒は有料版でのみ表示"]
[]
["その他"]
["・1か月単位変形労働時間制の月初や月末等で端数日がある週における週の法定労働時間は、「40（44）時間×端日数÷７」でみています。",null,null,null,"別表１　日をまたぐ勤務の時間計算"]
["・計算条件の「端数処理（切捨）」は、変形期間の法定労働時間を10進数で表示した場合の端数処理です。",null,null,null,"勤務区分",null,"計算方法"]
["（例）1か月単位変形労働時間制における変形期間（1か月間）の法定労働時間",null,null,null,"24時まで","24時以降","24時までの労働時間","24時以降の労働時間"]
["【端数処理なし】40時間×31日÷7＝177.14…時間（177:08）",null,null,null,"勤務日","勤務日","通算して所定内（外）労働又は時間外労働"]
["【第2位以下】 　40時間×31日÷7≒177.1時間（177:06）",null,null,null,null,"所定休日","通算して所定内（外）労働又は時間外労働"]
["【第1位以下】　 40時間×31日÷7≒177時間（177:00）",null,null,null,null,"法定休日","所定内（外）又は時間外","法定休日労働"]
["・一勤務が日をまたいだ場合の時間計算は別表１のとおり行っています。",null,null,null,"所定休日","勤務日","通算して所定休日労働又は時間外労働"]
["・下記の場合は、正しい時間計算を行えません。",null,null,null,null,"所定休日","通算して所定休日労働又は時間外労働"]
["(1)勤務終了が翌日の始業時刻を超える場合",null,null,null,null,"法定休日","所定休日労働又は時間外労働","法定休日労働"]
["(2)3交代勤務で休日を継続24時間としている場合",null,null,null,"法定休日","勤務日","法定休日労働","所定外労働又は時間外労働"]
["(3)その他、勤務状況が特殊である又は一般的とは言えない場合",null,null,null,null,"所定休日","法定休日労働","所定外労働又は時間外労働"]
[null,null,null,null,null,"法定休日","法定休日労働","法定休日労働"]
["使用許諾"]
["・当ツールの著作権及び知的所有権は、社会保険労務士事務所しのはら労働コンサルタントに帰属します。"]
["・当ツールの全部または一部の再配布、再使用許諾及び公開することを禁止します。"]
["・当ツールの利用により発生したトラブル・損失・損害については、一切責任を負いません。ご利用にあたっては自己責任でお願いします。"]
["・別料金にてカスタマイズを承ります。"]
[]
["作成・配付"]
["社会保険労務士事務所しのはら労働コンサルタント"]
["社会保険労務士　篠原宏治"]
["〒168-0062　東京都杉並区方南1-2-10-1F"]
["TEL","03-6300-4323"]
["FAX","03-6300-4324"]
["メール","mail@shlc.jp"]
[]
["元労働基準監督官による労務相談とエクセル業務効率化に強い社労士事務所です。"]
["労務相談、社会保険・労働保険手続き、給与計算のご依頼を随時受け付けております。"]
["お気軽にお問い合わせください。"]

{"sheet":"原則・1か月変形","index":1,"n_rows":47,"n_cols":28,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,23,4,28],[4,20,4,21],[3,5,3,6],[3,8,3,10],[3,11,3,12],[3,14,3,17],[3,20,3,21],[6,1,6,4],[6,5,6,6],[6,7,6,8],[6,19,6,22],[1,23,2,28],[2,5,2,6],[2,8,2,10],[2,11,2,12],[2,14,2,17],[1,5,1,6],[1,8,1,10],[1,11,1,12],[1,14,1,17],[1,20,2,21],[6,23,6,26],[6,9,6,17]]}
[null,null,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,"1:日 2:月 3:火 4:水 5:木 6:金 7:土",null,null,"労働時間制",null,"1か月変形","原則・1か月変形から選択",null,null,null,null,null,"入力可",null,null,"労基法第37条の割増賃金の対象となる時間"]
[null,null,null,null,null,"週締め日",null,{"$f":"IF(H2+6>7,H2-1,H2+6)","v":7},"週起算日から自動判定",null,null,"端数処理（切捨）",null,"第1位以下","月法定労働時間の端数処理"]
[null,null,null,null,null,"週法定労働時間",null,40,"40時間・44時間から選択",null,null,"月法定労働時間",null,{"$f":"O5/24+P5/24/60","v":7.375},"40（44）時間×暦日数÷7",null,null,null,null,null,"入力必須",null,null,"上記以外（有料版のみ）\n（給与や割増賃金の計算に使用する時間）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N2=\"原則\",0,ROUNDDOWN(COUNT(A15:A45)/7*H4,_xlfn.IFS(N3=\"なし\",99,N3=\"第1位以下\",0,N3=\"第2位以下\",1))/24)","v":7.375},{"$f":"LEFT(TEXT(N5,\"[h]:mm\"),3)","v":"177"},{"$f":"RIGHT(TEXT(N5,\"[h]:mm\"),2)","v":"00"},null,null,null,null,"入力不可"]
["勤怠状況",null,null,null,null,null,{"$f":"IF(AND(N2 = \"1か月変形\",G46>N4),\"月の所定労働時間が週平均40(44)時間を超えています。\",\"\")","v":""}]
[null,"集計用",null,null,null,"勤務予定",null,"振替",null,"勤務実績",null,null,null,null,null,null,null,null,null,"時間外労働",null,null,null,"時間外労働内訳"]
["年月日","週\n締日","月\n締日","週\n日数","期間日数","休日","所定\n労働時間","振替","振替後の所定\n労働時間","始業時刻","終業時刻","中抜時間\n(0～5時)","中抜時間\n(5～22時)","中抜時間\n(22～24時)","中抜時間\n(24～翌5時)","中抜時間\n(翌5時～)","有給休暇\n時間","実働時間","法定休日","時間外(日)","時間外\n(週)","時間外\n(月)","時間外\n(合計)","勤務日\n(60H以下)","所定休日\n(60H以下)","勤務日\n(60H超)","所定休日\n(60H超)","深夜"]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A9)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A10-1,TRUE,\"-\")","v":"-"},{"$f":"_xlfn.IFS(A9=\"-\",\"\",NOT(ISNUMBER(A10)),2,WEEKDAY(A9)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A9=\"-\",\"\",$A$15=$A9,\"\",DAY($A$15)=DAY(A9+1),DATEDIF($A$15,A9+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"\",A9=\"-\",\"\",ISTEXT(D8),1,ISTEXT(B8),D8+1,TRUE,1)","v":""},0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K9-J9-SUM(L9:P9)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A10)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A11-1,TRUE,\"-\")","v":"-"},{"$f":"_xlfn.IFS(A10=\"-\",\"\",NOT(ISNUMBER(A11)),2,WEEKDAY(A10)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A10=\"-\",\"\",$A$15=$A10,\"\",DAY($A$15)=DAY(A10+1),DATEDIF($A$15,A10+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"\",A10=\"-\",\"\",ISTEXT(D9),1,ISTEXT(B9),D9+1,TRUE,1)","v":""},0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A11)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A12-1,TRUE,\"-\")","v":"-"},{"$f":"_xlfn.IFS(A11=\"-\",\"\",NOT(ISNUMBER(A12)),2,WEEKDAY(A11)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A11=\"-\",\"\",$A$15=$A11,\"\",DAY($A$15)=DAY(A11+1),DATEDIF($A$15,A11+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"\",A11=\"-\",\"\",ISTEXT(D10),1,ISTEXT(B10),D10+1,TRUE,1)","v":""},0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A12)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A13-1,TRUE,\"-\")","v":"-"},{"$f":"_xlfn.IFS(A12=\"-\",\"\",NOT(ISNUMBER(A13)),2,WEEKDAY(A12)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A12=\"-\",\"\",$A$15=$A12,\"\",DAY($A$15)=DAY(A12+1),DATEDIF($A$15,A12+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A12=\"-\",\"\",ISTEXT(D11),1,ISTEXT(B11),D11+1,TRUE,1)","v":""},0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A13)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A14-1,TRUE,\"-\")","v":"-"},{"$f":"_xlfn.IFS(A13=\"-\",\"\",NOT(ISNUMBER(A14)),2,WEEKDAY(A13)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A13=\"-\",\"\",$A$15=$A13,\"\",DAY($A$15)=DAY(A13+1),DATEDIF($A$15,A13+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A13=\"-\",\"\",ISTEXT(D12),1,ISTEXT(B12),D12+1,TRUE,1)","v":""},0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS($N$2=\"1か月変形\",\"-\",15-ROW(A14)<=WEEKDAY($A$15)-$H$2+IF(WEEKDAY($A$15)-$H$2<0,7,0),A15-1,TRUE,\"-\")","v":"-"},{"$f":"_xlfn.IFS(A14=\"-\",\"\",NOT(ISNUMBER(A15)),2,WEEKDAY(A14)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A14=\"-\",\"\",$A$15=$A14,\"\",DAY($A$15)=DAY(A14+1),DATEDIF($A$15,A14+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A14=\"-\",\"\",ISTEXT(D13),1,ISTEXT(B13),D13+1,TRUE,1)","v":""},0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
["2024-05-01",{"$f":"_xlfn.IFS(A15=\"-\",\"\",NOT(ISNUMBER(A16)),2,WEEKDAY(A15)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A15=\"-\",\"\",$A$15=$A15,\"\",DAY($A$15)=DAY(A15+1),DATEDIF($A$15,A15+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A15)=15,N2=\"1か月変形\"),1,A15=\"-\",\"\",ISTEXT(D14),1,ISTEXT(B14),D14+1,TRUE,1)","v":1},{"$f":"_xlfn.IFS(A15=\"-\",\"\",ISTEXT(E14),1,TRUE,E14+1)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K15-J15-SUM(L15:P15)","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A15= \"-\",\"-\",DAY($A$15)=DAY(A15+1),\"-\",TRUE,A15+1)","v":"2024-05-02"},{"$f":"_xlfn.IFS(A16=\"-\",\"\",NOT(ISNUMBER(A17)),2,WEEKDAY(A16)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A16=\"-\",\"\",$A$15=$A16,\"\",DAY($A$15)=DAY(A16+1),DATEDIF($A$15,A16+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A16)=15,N3=\"1か月変形\"),1,A16=\"-\",\"\",ISTEXT(D15),1,ISTEXT(B15),D15+1,TRUE,1)","v":2},{"$f":"_xlfn.IFS(A16=\"-\",\"\",ISTEXT(E15),1,TRUE,E15+1)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A16= \"-\",\"-\",DAY($A$15)=DAY(A16+1),\"-\",TRUE,A16+1)","v":"2024-05-03"},{"$f":"_xlfn.IFS(A17=\"-\",\"\",NOT(ISNUMBER(A18)),2,WEEKDAY(A17)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A17=\"-\",\"\",$A$15=$A17,\"\",DAY($A$15)=DAY(A17+1),DATEDIF($A$15,A17+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A17)=15,N4=\"1か月変形\"),1,A17=\"-\",\"\",ISTEXT(D16),1,ISTEXT(B16),D16+1,TRUE,1)","v":3},{"$f":"_xlfn.IFS(A17=\"-\",\"\",ISTEXT(E16),1,TRUE,E16+1)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A17= \"-\",\"-\",DAY($A$15)=DAY(A17+1),\"-\",TRUE,A17+1)","v":"2024-05-04"},{"$f":"_xlfn.IFS(A18=\"-\",\"\",NOT(ISNUMBER(A19)),2,WEEKDAY(A18)=$H$3,1,TRUE,\"\")","v":1},{"$f":"_xlfn.IFS(A18=\"-\",\"\",$A$15=$A18,\"\",DAY($A$15)=DAY(A18+1),DATEDIF($A$15,A18+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A18)=15,N5=\"1か月変形\"),1,A18=\"-\",\"\",ISTEXT(D17),1,ISTEXT(B17),D17+1,TRUE,1)","v":4},{"$f":"_xlfn.IFS(A18=\"-\",\"\",ISTEXT(E17),1,TRUE,E17+1)","v":4},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A18= \"-\",\"-\",DAY($A$15)=DAY(A18+1),\"-\",TRUE,A18+1)","v":"2024-05-05"},{"$f":"_xlfn.IFS(A19=\"-\",\"\",NOT(ISNUMBER(A20)),2,WEEKDAY(A19)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A19=\"-\",\"\",$A$15=$A19,\"\",DAY($A$15)=DAY(A19+1),DATEDIF($A$15,A19+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A19)=15,N6=\"1か月変形\"),1,A19=\"-\",\"\",ISTEXT(D18),1,ISTEXT(B18),D18+1,TRUE,1)","v":1},{"$f":"_xlfn.IFS(A19=\"-\",\"\",ISTEXT(E18),1,TRUE,E18+1)","v":5},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A19= \"-\",\"-\",DAY($A$15)=DAY(A19+1),\"-\",TRUE,A19+1)","v":"2024-05-06"},{"$f":"_xlfn.IFS(A20=\"-\",\"\",NOT(ISNUMBER(A21)),2,WEEKDAY(A20)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A20=\"-\",\"\",$A$15=$A20,\"\",DAY($A$15)=DAY(A20+1),DATEDIF($A$15,A20+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A20)=15,N7=\"1か月変形\"),1,A20=\"-\",\"\",ISTEXT(D19),1,ISTEXT(B19),D19+1,TRUE,1)","v":2},{"$f":"_xlfn.IFS(A20=\"-\",\"\",ISTEXT(E19),1,TRUE,E19+1)","v":6},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A20= \"-\",\"-\",DAY($A$15)=DAY(A20+1),\"-\",TRUE,A20+1)","v":"2024-05-07"},{"$f":"_xlfn.IFS(A21=\"-\",\"\",NOT(ISNUMBER(A22)),2,WEEKDAY(A21)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A21=\"-\",\"\",$A$15=$A21,\"\",DAY($A$15)=DAY(A21+1),DATEDIF($A$15,A21+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A21)=15,N8=\"1か月変形\"),1,A21=\"-\",\"\",ISTEXT(D20),1,ISTEXT(B20),D20+1,TRUE,1)","v":3},{"$f":"_xlfn.IFS(A21=\"-\",\"\",ISTEXT(E20),1,TRUE,E20+1)","v":7},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A21= \"-\",\"-\",DAY($A$15)=DAY(A21+1),\"-\",TRUE,A21+1)","v":"2024-05-08"},{"$f":"_xlfn.IFS(A22=\"-\",\"\",NOT(ISNUMBER(A23)),2,WEEKDAY(A22)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A22=\"-\",\"\",$A$15=$A22,\"\",DAY($A$15)=DAY(A22+1),DATEDIF($A$15,A22+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A22)=15,N9=\"1か月変形\"),1,A22=\"-\",\"\",ISTEXT(D21),1,ISTEXT(B21),D21+1,TRUE,1)","v":4},{"$f":"_xlfn.IFS(A22=\"-\",\"\",ISTEXT(E21),1,TRUE,E21+1)","v":8},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A22= \"-\",\"-\",DAY($A$15)=DAY(A22+1),\"-\",TRUE,A22+1)","v":"2024-05-09"},{"$f":"_xlfn.IFS(A23=\"-\",\"\",NOT(ISNUMBER(A24)),2,WEEKDAY(A23)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A23=\"-\",\"\",$A$15=$A23,\"\",DAY($A$15)=DAY(A23+1),DATEDIF($A$15,A23+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A23)=15,N10=\"1か月変形\"),1,A23=\"-\",\"\",ISTEXT(D22),1,ISTEXT(B22),D22+1,TRUE,1)","v":5},{"$f":"_xlfn.IFS(A23=\"-\",\"\",ISTEXT(E22),1,TRUE,E22+1)","v":9},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A23= \"-\",\"-\",DAY($A$15)=DAY(A23+1),\"-\",TRUE,A23+1)","v":"2024-05-10"},{"$f":"_xlfn.IFS(A24=\"-\",\"\",NOT(ISNUMBER(A25)),2,WEEKDAY(A24)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A24=\"-\",\"\",$A$15=$A24,\"\",DAY($A$15)=DAY(A24+1),DATEDIF($A$15,A24+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A24)=15,N11=\"1か月変形\"),1,A24=\"-\",\"\",ISTEXT(D23),1,ISTEXT(B23),D23+1,TRUE,1)","v":6},{"$f":"_xlfn.IFS(A24=\"-\",\"\",ISTEXT(E23),1,TRUE,E23+1)","v":10},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A24= \"-\",\"-\",DAY($A$15)=DAY(A24+1),\"-\",TRUE,A24+1)","v":"2024-05-11"},{"$f":"_xlfn.IFS(A25=\"-\",\"\",NOT(ISNUMBER(A26)),2,WEEKDAY(A25)=$H$3,1,TRUE,\"\")","v":1},{"$f":"_xlfn.IFS(A25=\"-\",\"\",$A$15=$A25,\"\",DAY($A$15)=DAY(A25+1),DATEDIF($A$15,A25+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A25)=15,N12=\"1か月変形\"),1,A25=\"-\",\"\",ISTEXT(D24),1,ISTEXT(B24),D24+1,TRUE,1)","v":7},{"$f":"_xlfn.IFS(A25=\"-\",\"\",ISTEXT(E24),1,TRUE,E24+1)","v":11},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A25= \"-\",\"-\",DAY($A$15)=DAY(A25+1),\"-\",TRUE,A25+1)","v":"2024-05-12"},{"$f":"_xlfn.IFS(A26=\"-\",\"\",NOT(ISNUMBER(A27)),2,WEEKDAY(A26)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A26=\"-\",\"\",$A$15=$A26,\"\",DAY($A$15)=DAY(A26+1),DATEDIF($A$15,A26+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A26)=15,N13=\"1か月変形\"),1,A26=\"-\",\"\",ISTEXT(D25),1,ISTEXT(B25),D25+1,TRUE,1)","v":1},{"$f":"_xlfn.IFS(A26=\"-\",\"\",ISTEXT(E25),1,TRUE,E25+1)","v":12},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A26= \"-\",\"-\",DAY($A$15)=DAY(A26+1),\"-\",TRUE,A26+1)","v":"2024-05-13"},{"$f":"_xlfn.IFS(A27=\"-\",\"\",NOT(ISNUMBER(A28)),2,WEEKDAY(A27)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A27=\"-\",\"\",$A$15=$A27,\"\",DAY($A$15)=DAY(A27+1),DATEDIF($A$15,A27+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A27)=15,N14=\"1か月変形\"),1,A27=\"-\",\"\",ISTEXT(D26),1,ISTEXT(B26),D26+1,TRUE,1)","v":2},{"$f":"_xlfn.IFS(A27=\"-\",\"\",ISTEXT(E26),1,TRUE,E26+1)","v":13},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A27= \"-\",\"-\",DAY($A$15)=DAY(A27+1),\"-\",TRUE,A27+1)","v":"2024-05-14"},{"$f":"_xlfn.IFS(A28=\"-\",\"\",NOT(ISNUMBER(A29)),2,WEEKDAY(A28)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A28=\"-\",\"\",$A$15=$A28,\"\",DAY($A$15)=DAY(A28+1),DATEDIF($A$15,A28+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A28)=15,N15=\"1か月変形\"),1,A28=\"-\",\"\",ISTEXT(D27),1,ISTEXT(B27),D27+1,TRUE,1)","v":3},{"$f":"_xlfn.IFS(A28=\"-\",\"\",ISTEXT(E27),1,TRUE,E27+1)","v":14},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A28= \"-\",\"-\",DAY($A$15)=DAY(A28+1),\"-\",TRUE,A28+1)","v":"2024-05-15"},{"$f":"_xlfn.IFS(A29=\"-\",\"\",NOT(ISNUMBER(A30)),2,WEEKDAY(A29)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A29=\"-\",\"\",$A$15=$A29,\"\",DAY($A$15)=DAY(A29+1),DATEDIF($A$15,A29+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A29)=15,N16=\"1か月変形\"),1,A29=\"-\",\"\",ISTEXT(D28),1,ISTEXT(B28),D28+1,TRUE,1)","v":4},{"$f":"_xlfn.IFS(A29=\"-\",\"\",ISTEXT(E28),1,TRUE,E28+1)","v":15},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A29= \"-\",\"-\",DAY($A$15)=DAY(A29+1),\"-\",TRUE,A29+1)","v":"2024-05-16"},{"$f":"_xlfn.IFS(A30=\"-\",\"\",NOT(ISNUMBER(A31)),2,WEEKDAY(A30)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A30=\"-\",\"\",$A$15=$A30,\"\",DAY($A$15)=DAY(A30+1),DATEDIF($A$15,A30+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A30)=15,N17=\"1か月変形\"),1,A30=\"-\",\"\",ISTEXT(D29),1,ISTEXT(B29),D29+1,TRUE,1)","v":5},{"$f":"_xlfn.IFS(A30=\"-\",\"\",ISTEXT(E29),1,TRUE,E29+1)","v":16},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A30= \"-\",\"-\",DAY($A$15)=DAY(A30+1),\"-\",TRUE,A30+1)","v":"2024-05-17"},{"$f":"_xlfn.IFS(A31=\"-\",\"\",NOT(ISNUMBER(A32)),2,WEEKDAY(A31)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A31=\"-\",\"\",$A$15=$A31,\"\",DAY($A$15)=DAY(A31+1),DATEDIF($A$15,A31+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A31)=15,N18=\"1か月変形\"),1,A31=\"-\",\"\",ISTEXT(D30),1,ISTEXT(B30),D30+1,TRUE,1)","v":6},{"$f":"_xlfn.IFS(A31=\"-\",\"\",ISTEXT(E30),1,TRUE,E30+1)","v":17},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A31= \"-\",\"-\",DAY($A$15)=DAY(A31+1),\"-\",TRUE,A31+1)","v":"2024-05-18"},{"$f":"_xlfn.IFS(A32=\"-\",\"\",NOT(ISNUMBER(A33)),2,WEEKDAY(A32)=$H$3,1,TRUE,\"\")","v":1},{"$f":"_xlfn.IFS(A32=\"-\",\"\",$A$15=$A32,\"\",DAY($A$15)=DAY(A32+1),DATEDIF($A$15,A32+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A32)=15,N19=\"1か月変形\"),1,A32=\"-\",\"\",ISTEXT(D31),1,ISTEXT(B31),D31+1,TRUE,1)","v":7},{"$f":"_xlfn.IFS(A32=\"-\",\"\",ISTEXT(E31),1,TRUE,E31+1)","v":18},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A32= \"-\",\"-\",DAY($A$15)=DAY(A32+1),\"-\",TRUE,A32+1)","v":"2024-05-19"},{"$f":"_xlfn.IFS(A33=\"-\",\"\",NOT(ISNUMBER(A34)),2,WEEKDAY(A33)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A33=\"-\",\"\",$A$15=$A33,\"\",DAY($A$15)=DAY(A33+1),DATEDIF($A$15,A33+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A33)=15,N20=\"1か月変形\"),1,A33=\"-\",\"\",ISTEXT(D32),1,ISTEXT(B32),D32+1,TRUE,1)","v":1},{"$f":"_xlfn.IFS(A33=\"-\",\"\",ISTEXT(E32),1,TRUE,E32+1)","v":19},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A33= \"-\",\"-\",DAY($A$15)=DAY(A33+1),\"-\",TRUE,A33+1)","v":"2024-05-20"},{"$f":"_xlfn.IFS(A34=\"-\",\"\",NOT(ISNUMBER(A35)),2,WEEKDAY(A34)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A34=\"-\",\"\",$A$15=$A34,\"\",DAY($A$15)=DAY(A34+1),DATEDIF($A$15,A34+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A34)=15,N21=\"1か月変形\"),1,A34=\"-\",\"\",ISTEXT(D33),1,ISTEXT(B33),D33+1,TRUE,1)","v":2},{"$f":"_xlfn.IFS(A34=\"-\",\"\",ISTEXT(E33),1,TRUE,E33+1)","v":20},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A34= \"-\",\"-\",DAY($A$15)=DAY(A34+1),\"-\",TRUE,A34+1)","v":"2024-05-21"},{"$f":"_xlfn.IFS(A35=\"-\",\"\",NOT(ISNUMBER(A36)),2,WEEKDAY(A35)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A35=\"-\",\"\",$A$15=$A35,\"\",DAY($A$15)=DAY(A35+1),DATEDIF($A$15,A35+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A35)=15,N22=\"1か月変形\"),1,A35=\"-\",\"\",ISTEXT(D34),1,ISTEXT(B34),D34+1,TRUE,1)","v":3},{"$f":"_xlfn.IFS(A35=\"-\",\"\",ISTEXT(E34),1,TRUE,E34+1)","v":21},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A35= \"-\",\"-\",DAY($A$15)=DAY(A35+1),\"-\",TRUE,A35+1)","v":"2024-05-22"},{"$f":"_xlfn.IFS(A36=\"-\",\"\",NOT(ISNUMBER(A37)),2,WEEKDAY(A36)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A36=\"-\",\"\",$A$15=$A36,\"\",DAY($A$15)=DAY(A36+1),DATEDIF($A$15,A36+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A36)=15,N23=\"1か月変形\"),1,A36=\"-\",\"\",ISTEXT(D35),1,ISTEXT(B35),D35+1,TRUE,1)","v":4},{"$f":"_xlfn.IFS(A36=\"-\",\"\",ISTEXT(E35),1,TRUE,E35+1)","v":22},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A36= \"-\",\"-\",DAY($A$15)=DAY(A36+1),\"-\",TRUE,A36+1)","v":"2024-05-23"},{"$f":"_xlfn.IFS(A37=\"-\",\"\",NOT(ISNUMBER(A38)),2,WEEKDAY(A37)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A37=\"-\",\"\",$A$15=$A37,\"\",DAY($A$15)=DAY(A37+1),DATEDIF($A$15,A37+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A37)=15,N24=\"1か月変形\"),1,A37=\"-\",\"\",ISTEXT(D36),1,ISTEXT(B36),D36+1,TRUE,1)","v":5},{"$f":"_xlfn.IFS(A37=\"-\",\"\",ISTEXT(E36),1,TRUE,E36+1)","v":23},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A37= \"-\",\"-\",DAY($A$15)=DAY(A37+1),\"-\",TRUE,A37+1)","v":"2024-05-24"},{"$f":"_xlfn.IFS(A38=\"-\",\"\",NOT(ISNUMBER(A39)),2,WEEKDAY(A38)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A38=\"-\",\"\",$A$15=$A38,\"\",DAY($A$15)=DAY(A38+1),DATEDIF($A$15,A38+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A38)=15,N25=\"1か月変形\"),1,A38=\"-\",\"\",ISTEXT(D37),1,ISTEXT(B37),D37+1,TRUE,1)","v":6},{"$f":"_xlfn.IFS(A38=\"-\",\"\",ISTEXT(E37),1,TRUE,E37+1)","v":24},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A38= \"-\",\"-\",DAY($A$15)=DAY(A38+1),\"-\",TRUE,A38+1)","v":"2024-05-25"},{"$f":"_xlfn.IFS(A39=\"-\",\"\",NOT(ISNUMBER(A40)),2,WEEKDAY(A39)=$H$3,1,TRUE,\"\")","v":1},{"$f":"_xlfn.IFS(A39=\"-\",\"\",$A$15=$A39,\"\",DAY($A$15)=DAY(A39+1),DATEDIF($A$15,A39+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A39)=15,N26=\"1か月変形\"),1,A39=\"-\",\"\",ISTEXT(D38),1,ISTEXT(B38),D38+1,TRUE,1)","v":7},{"$f":"_xlfn.IFS(A39=\"-\",\"\",ISTEXT(E38),1,TRUE,E38+1)","v":25},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A39= \"-\",\"-\",DAY($A$15)=DAY(A39+1),\"-\",TRUE,A39+1)","v":"2024-05-26"},{"$f":"_xlfn.IFS(A40=\"-\",\"\",NOT(ISNUMBER(A41)),2,WEEKDAY(A40)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A40=\"-\",\"\",$A$15=$A40,\"\",DAY($A$15)=DAY(A40+1),DATEDIF($A$15,A40+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A40)=15,N27=\"1か月変形\"),1,A40=\"-\",\"\",ISTEXT(D39),1,ISTEXT(B39),D39+1,TRUE,1)","v":1},{"$f":"_xlfn.IFS(A40=\"-\",\"\",ISTEXT(E39),1,TRUE,E39+1)","v":26},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A40= \"-\",\"-\",DAY($A$15)=DAY(A40+1),\"-\",TRUE,A40+1)","v":"2024-05-27"},{"$f":"_xlfn.IFS(A41=\"-\",\"\",NOT(ISNUMBER(A42)),2,WEEKDAY(A41)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A41=\"-\",\"\",$A$15=$A41,\"\",DAY($A$15)=DAY(A41+1),DATEDIF($A$15,A41+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A41)=15,N28=\"1か月変形\"),1,A41=\"-\",\"\",ISTEXT(D40),1,ISTEXT(B40),D40+1,TRUE,1)","v":2},{"$f":"_xlfn.IFS(A41=\"-\",\"\",ISTEXT(E40),1,TRUE,E40+1)","v":27},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A41= \"-\",\"-\",DAY($A$15)=DAY(A41+1),\"-\",TRUE,A41+1)","v":"2024-05-28"},{"$f":"_xlfn.IFS(A42=\"-\",\"\",NOT(ISNUMBER(A43)),2,WEEKDAY(A42)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A42=\"-\",\"\",$A$15=$A42,\"\",DAY($A$15)=DAY(A42+1),DATEDIF($A$15,A42+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A42)=15,N29=\"1か月変形\"),1,A42=\"-\",\"\",ISTEXT(D41),1,ISTEXT(B41),D41+1,TRUE,1)","v":3},{"$f":"_xlfn.IFS(A42=\"-\",\"\",ISTEXT(E41),1,TRUE,E41+1)","v":28},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A42= \"-\",\"-\",DAY($A$15)=DAY(A42+1),\"-\",TRUE,A42+1)","v":"2024-05-29"},{"$f":"_xlfn.IFS(A43=\"-\",\"\",NOT(ISNUMBER(A44)),2,WEEKDAY(A43)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A43=\"-\",\"\",$A$15=$A43,\"\",DAY($A$15)=DAY(A43+1),DATEDIF($A$15,A43+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A43)=15,N30=\"1か月変形\"),1,A43=\"-\",\"\",ISTEXT(D42),1,ISTEXT(B42),D42+1,TRUE,1)","v":4},{"$f":"_xlfn.IFS(A43=\"-\",\"\",ISTEXT(E42),1,TRUE,E42+1)","v":29},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A43= \"-\",\"-\",DAY($A$15)=DAY(A43+1),\"-\",TRUE,A43+1)","v":"2024-05-30"},{"$f":"_xlfn.IFS(A44=\"-\",\"\",NOT(ISNUMBER(A45)),2,WEEKDAY(A44)=$H$3,1,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(A44=\"-\",\"\",$A$15=$A44,\"\",DAY($A$15)=DAY(A44+1),DATEDIF($A$15,A44+1,\"M\"),TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AND(ROW(A44)=15,N31=\"1か月変形\"),1,A44=\"-\",\"\",ISTEXT(D43),1,ISTEXT(B43),D43+1,TRUE,1)","v":5},{"$f":"_xlfn.IFS(A44=\"-\",\"\",ISTEXT(E43),1,TRUE,E43+1)","v":30},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"_xlfn.IFS(A44= \"-\",\"-\",DAY($A$15)=DAY(A44+1),\"-\",TRUE,A44+1)","v":"2024-05-31"},{"$f":"_xlfn.IFS(A45=\"-\",\"\",NOT(ISNUMBER(A46)),2,WEEKDAY(A45)=$H$3,1,TRUE,\"\")","v":2},{"$f":"_xlfn.IFS(A45=\"-\",\"\",$A$15=$A45,\"\",DAY($A$15)=DAY(A45+1),DATEDIF($A$15,A45+1,\"M\"),TRUE,\"\")","v":1},{"$f":"_xlfn.IFS(AND(ROW(A45)=15,N32=\"1か月変形\"),1,A45=\"-\",\"\",ISTEXT(D44),1,ISTEXT(B44),D44+1,TRUE,1)","v":6},{"$f":"_xlfn.IFS(A45=\"-\",\"\",ISTEXT(E44),1,TRUE,E44+1)","v":31},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
["合計",null,null,null,null,null,{"$f":"SUM(G15:G45)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q15:Q45)","v":0},{"$f":"SUM(R15:R45)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"①",null,null,null,null,null,null,null,null,null,"②","③","④","⑤","⑥","⑦","⑧","⑨","⑩","⑪","⑫","⑬"]

{"sheet":"（非表示・計算用）原則・1か月変形","index":2,"n_rows":47,"n_cols":53,"rows_kept":47,"cut":false,"hidden":true,"merged":[[6,37,6,41],[6,42,6,43],[6,44,6,48],[6,49,6,51],[6,28,6,32],[6,33,6,36],[6,1,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,17],[6,19,6,22],[3,5,3,6],[3,8,3,10],[3,11,3,12],[3,14,3,17],[6,23,6,26],[1,5,1,6],[1,8,1,10],[1,11,1,12],[1,14,1,17],[2,5,2,6],[2,8,2,10],[2,11,2,12],[2,14,2,17],[1,19,2,20],[3,19,3,20],[4,19,4,20],[1,22,2,27],[3,22,4,27]]}
[null,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,"1:日 2:月 3:火 4:水 5:木 6:金 7:土",null,null,"労働時間制",null,"1か月変形","原則・1か月変形から選択",null,null,null,null,"入力可",null,null,"労基法第37条の割増賃金の対象となる時間"]
[null,null,null,null,null,"週締め日",null,{"$f":"原則・1か月変形!H3","v":7},"週起算日から自動判定",null,null,"端数処理（切捨）",null,"第1位以下","月法定労働時間の端数処理"]
[null,null,null,null,null,"週法定労働時間",null,40,"40時間・44時間から選択",null,null,"月法定労働時間",null,{"$f":"O5/24+P5/24/60","v":7.375},"40（44）時間×暦日数÷7",null,null,null,null,"入力必須",null,null,"上記以外（給与や割増賃金の計算に使用する時間）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N2=\"原則\",0,ROUNDDOWN(COUNT(A15:A45)/7*H4,_xlfn.IFS(N3=\"なし\",99,N3=\"第1位以下\",0,N3=\"第2位以下\",1))/24)","v":7.375},{"$f":"LEFT(TEXT(N5,\"[h]:mm\"),3)","v":"177"},{"$f":"RIGHT(TEXT(N5,\"[h]:mm\"),2)","v":"00"},null,null,null,"入力不可"]
["勤怠状況",null,null,null,null,null,{"$f":"IF(AND(N2 = \"1か月変形\",G46>N4),\"月の所定労働時間が週平均40(44)時間を超えています。\",\"\")","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,"1日時間外",null,"週時間外",null,null,null,null,"月時間外",null,null,"60H"]
["年月日","週\n締日","月\n締日","週\n日数","期間日数","休日","所定\n労働時間","振替","振替後の所定\n労働時間","始業時刻","終業時刻","中抜時間\n(0～5時)","中抜時間\n(5～22時)","中抜時間\n(22～24時)","中抜時間\n(24～翌5時)","中抜時間\n(翌5時～)","有給休暇\n時間","実働時間","法定休日","時間外(日)","時間外\n(週)","時間外\n(月)","時間外\n(合計)","勤務日\n(60H以下)","所定休日\n(60H以下)","勤務日\n(60H超)","所定休日\n(60H超)","深夜","所定内","振替出勤","所定外","所定休日","法定内","欠勤等","振替休日","100％\n相殺","控除\n(合計)","実働時間\n(0～5時)","実働時間\n(5～22時)","実働時間\n(22～24時)","実働時間\n(24～翌5時)","実働時間\n(翌5時～)","法定休日\n以外","1日法定\n労働時間","週所定\n労働時間","週法定\n労働時間","法定休日\n以外\n(週計)","1日時間外(週計)","前日まで\n週時間外\n(週計)","法定休日以外\n(月計)","1日・週\n時間外\n(月計)","前日まで月時間外\n(月計)","時間外\n(累計)"]
["-",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K9-J9-SUM(L9:P9)","v":0},{"$f":"IF(AND(F9=\"法定\",H9<>\"振出\"),SUM(AL9:AN9),0)+IF(F10=\"法定\",AO9+AP9,0)","v":0},{"$f":"IF(MAX(0,AQ9-IF(AR9=0,8/24,AR9))<TIME(0,0,1),0,MAX(0,AQ9-IF(AR9=0,8/24,AR9)))","v":0},{"$f":"IF(IF($A9=\"-\",0,MAX(0,AU9-AV9-AW9-AT9))<TIME(0,0,1),0,IF($A9=\"-\",0,MAX(0,AU9-AV9-AW9-AT9)))","v":0},{"$f":"IF($N$2=\"原則\",0,MAX(0,AX9-AY9-AZ9-$N$4))","v":0},{"$f":"SUM(T9,U9,V9)","v":0},{"$f":"_xlfn.IFS(AND(F9=\"所定\",H9<>\"振出\"),0,BA9>60/24,W9-MIN(W9,BA9-60/24),TRUE,W9)","v":0},{"$f":"_xlfn.IFS(OR(F9<>\"所定\",H9=\"振出\"),0,BA9>60/24,W9-MIN(W9,BA9-60/24),TRUE,W9)","v":0},{"$f":"IF(AND(F9=\"所定\",H9<>\"振出\"),0,W9-X9)","v":0},{"$f":"IF(OR(F9<>\"所定\",H9=\"振出\"),0,W9-Y9)","v":0},{"$f":"SUM(AL9,AN9:AO9)","v":0},{"$f":"IF(G9=\"\",0,MIN(AG9,G9-Q9))","v":0},{"$f":"IF(H9=\"振出\",MIN(AG9,I9-Q9),0)","v":0},{"$f":"IF(AG9-AF9-AC9-AD9<TIME(0,0,1),0,AG9-AF9-AC9-AD9)","v":0},{"$f":"IF(IF(AND(F9=\"所定\",H9<>\"振出\"),MAX(0,AG9-AC9),0)<TIME(0,0,1),0,IF(AND(F9=\"所定\",H9<>\"振出\"),MAX(0,AG9-AC9),0))","v":0},{"$f":"IF(MAX(0,AQ9-W9)<TIME(0,0,1),0,MAX(0,AQ9-W9))","v":0},{"$f":"_xlfn.IFS(H9=\"振休\",0,R9<G9,MAX(0,G9-R9-Q9),TRUE,0)","v":0},{"$f":"IF(H9=\"振休\",MAX(0,G9-AG9-Q9),0)","v":0},{"$f":"IF(IF(G9=\"\",0,G9-Q9-AC9-AH9-AI9)<TIME(0,0,1),0,IF(G9=\"\",0,G9-Q9-AC9-AH9-AI9))","v":0},{"$f":"IF(MAX(0,G9-Q9-R9)+AJ9<TIME(0,0,1),0,MAX(0,G9-Q9-R9)+AJ9)","v":0},{"$f":"IF(J9=\"\",0,MAX(0,MIN(5/24,K9)-MAX(0,J9)-L9))","v":0},{"$f":"IF(J9=\"\",0,MAX(0,MIN(22/24,K9)-MAX(5/24,J9)-M9))","v":0},{"$f":"IF(J9=\"\",0,MAX(0,MIN(24/24,K9)-MAX(22/24,J9)-N9))","v":0},{"$f":"IF(J9=\"\",0,MAX(0,MIN(29/24,K9)-MAX(24/24,J9)-O9))","v":0},{"$f":"IF(J9=\"\",0,MAX(0,MIN(48/24,K9)-MAX(29/24,J9)-P9))","v":0},{"$f":"R9-S9","v":0},{"$f":"_xlfn.IFS(A9=\"-\",0,H9=\"振出\",IF($N$2=\"原則\",8/24,MAX(I9,8/24)),F9=\"法定\",0,TRUE,IF($N$2=\"原則\",8/24,MAX(G9,8/24)))","v":0},{"$f":"_xlfn.IFS(A9=\"-\",0,B9=\"\",AS10,TRUE,SUM(OFFSET(G9,D9*-1+1,0,D9,1)))","v":0},{"$f":"_xlfn.IFS(A9=\"-\",0,B9=\"\",AT10,$N$2=\"原則\",$H$4/24,TRUE,MAX(AS9,$H$4/24*D9/7))","v":0},{"$f":"IF(A9=\"-\",0,SUM(OFFSET(AQ9,D9*-1+1,0,D9,1)))","v":0},{"$f":"IF(A9=\"-\",0,SUM(OFFSET(T9,$D9*-1+1,0,D9,1)))","v":0},{"$f":"IF(OR($D9=1,A9=\"-\"),0,SUM(OFFSET(U9,D9*-1+1,0,D9-1,1)))","v":0},{"$f":"IF(A9=\"-\",0,SUM(AQ$9:AQ9))","v":0},{"$f":"IF(A9=\"-\",0,SUM(T$9:T9)+SUM(U$9:U9))","v":0},{"$f":"IF(ISTEXT(V8),0,SUM(V8:V$9))","v":0},{"$f":"_xlfn.IFS(ROW(BA9)<15,0,ISTEXT(BA8),W9,TRUE,BA8+W9)","v":0}]
["-",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(MAX(0,AQ10-IF(AR10=0,8/24,AR10))<TIME(0,0,1),0,MAX(0,AQ10-IF(AR10=0,8/24,AR10)))","v":0},{"$f":"IF(IF($A10=\"-\",0,MAX(0,AU10-AV10-AW10-AT10))<TIME(0,0,1),0,IF($A10=\"-\",0,MAX(0,AU10-AV10-AW10-AT10)))","v":0},{"$f":"IF($N$2=\"原則\",0,MAX(0,AX10-AY10-AZ10-$N$4))","v":0},{"$f":"SUM(T10,U10,V10)","v":0},0,0,0,0,{"$f":"SUM(AL10,AN10:AO10)","v":0},0,0,{"$f":"IF(AG10-AF10-AC10-AD10<TIME(0,0,1),0,AG10-AF10-AC10-AD10)","v":0},0,{"$f":"IF(MAX(0,AQ10-W10)<TIME(0,0,1),0,MAX(0,AQ10-W10))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(A10=\"-\",0,SUM(AQ$9:AQ10))","v":0},{"$f":"IF(A10=\"-\",0,SUM(T$9:T10)+SUM(U$9:U10))","v":0},{"$f":"IF(ISTEXT(V9),0,SUM(V9:V$9))","v":0},{"$f":"_xlfn.IFS(ROW(BA10)<15,0,ISTEXT(BA9),W10,TRUE,BA9+W10)","v":0}]
["-",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(A11=\"-\",0,SUM(AQ$9:AQ11))","v":0},{"$f":"IF(A11=\"-\",0,SUM(T$9:T11)+SUM(U$9:U11))","v":0},{"$f":"IF(ISTEXT(V10),0,SUM(V$9:V10))","v":0},0]
["-",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(A12=\"-\",0,SUM(AQ$9:AQ12))","v":0},{"$f":"IF(A12=\"-\",0,SUM(T$9:T12)+SUM(U$9:U12))","v":0},{"$f":"IF(ISTEXT(V11),0,SUM(V$9:V11))","v":0},0]
["-",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(A13=\"-\",0,SUM(AQ$9:AQ13))","v":0},{"$f":"IF(A13=\"-\",0,SUM(T$9:T13)+SUM(U$9:U13))","v":0},{"$f":"IF(ISTEXT(V12),0,SUM(V$9:V12))","v":0},0]
["-",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(A14=\"-\",0,SUM(AQ$9:AQ14))","v":0},{"$f":"IF(A14=\"-\",0,SUM(T$9:T14)+SUM(U$9:U14))","v":0},{"$f":"IF(ISTEXT(V13),0,SUM(V$9:V13))","v":0},0]
["2024-05-01",null,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K15-J15-SUM(L15:P15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,0.95238095238095244,0,0,0,{"$f":"IF(A15=\"-\",0,SUM(AQ$9:AQ15))","v":0},{"$f":"IF(A15=\"-\",0,SUM(T$9:T15)+SUM(U$9:U15))","v":0},{"$f":"IF(ISTEXT(V14),0,SUM(V$9:V14))","v":0},0]
["2024-05-02",null,null,2,2,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,0.95238095238095244,0,0,0,{"$f":"IF(A16=\"-\",0,SUM(AQ$9:AQ16))","v":0},{"$f":"IF(A16=\"-\",0,SUM(T$9:T16)+SUM(U$9:U16))","v":0},{"$f":"IF(ISTEXT(V15),0,SUM(V$9:V15))","v":0},0]
["2024-05-03",null,null,3,3,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,0.95238095238095244,0,0,0,{"$f":"IF(A17=\"-\",0,SUM(AQ$9:AQ17))","v":0},{"$f":"IF(A17=\"-\",0,SUM(T$9:T17)+SUM(U$9:U17))","v":0},{"$f":"IF(ISTEXT(V16),0,SUM(V$9:V16))","v":0},0]
["2024-05-04",1,null,4,4,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,0.95238095238095244,0,0,0,{"$f":"IF(A18=\"-\",0,SUM(AQ$9:AQ18))","v":0},{"$f":"IF(A18=\"-\",0,SUM(T$9:T18)+SUM(U$9:U18))","v":0},{"$f":"IF(ISTEXT(V17),0,SUM(V$9:V17))","v":0},0]
["2024-05-05",null,null,1,5,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A19=\"-\",0,SUM(AQ$9:AQ19))","v":0},{"$f":"IF(A19=\"-\",0,SUM(T$9:T19)+SUM(U$9:U19))","v":0},{"$f":"IF(ISTEXT(V18),0,SUM(V$9:V18))","v":0},0]
["2024-05-06",null,null,2,6,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A20=\"-\",0,SUM(AQ$9:AQ20))","v":0},{"$f":"IF(A20=\"-\",0,SUM(T$9:T20)+SUM(U$9:U20))","v":0},{"$f":"IF(ISTEXT(V19),0,SUM(V$9:V19))","v":0},0]
["2024-05-07",null,null,3,7,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A21=\"-\",0,SUM(AQ$9:AQ21))","v":0},{"$f":"IF(A21=\"-\",0,SUM(T$9:T21)+SUM(U$9:U21))","v":0},{"$f":"IF(ISTEXT(V20),0,SUM(V$9:V20))","v":0},0]
["2024-05-08",null,null,4,8,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A22=\"-\",0,SUM(AQ$9:AQ22))","v":0},{"$f":"IF(A22=\"-\",0,SUM(T$9:T22)+SUM(U$9:U22))","v":0},{"$f":"IF(ISTEXT(V21),0,SUM(V$9:V21))","v":0},0]
["2024-05-09",null,null,5,9,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A23=\"-\",0,SUM(AQ$9:AQ23))","v":0},{"$f":"IF(A23=\"-\",0,SUM(T$9:T23)+SUM(U$9:U23))","v":0},{"$f":"IF(ISTEXT(V22),0,SUM(V$9:V22))","v":0},0]
["2024-05-10",null,null,6,10,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A24=\"-\",0,SUM(AQ$9:AQ24))","v":0},{"$f":"IF(A24=\"-\",0,SUM(T$9:T24)+SUM(U$9:U24))","v":0},{"$f":"IF(ISTEXT(V23),0,SUM(V$9:V23))","v":0},0]
["2024-05-11",1,null,7,11,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A25=\"-\",0,SUM(AQ$9:AQ25))","v":0},{"$f":"IF(A25=\"-\",0,SUM(T$9:T25)+SUM(U$9:U25))","v":0},{"$f":"IF(ISTEXT(V24),0,SUM(V$9:V24))","v":0},0]
["2024-05-12",null,null,1,12,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A26=\"-\",0,SUM(AQ$9:AQ26))","v":0},{"$f":"IF(A26=\"-\",0,SUM(T$9:T26)+SUM(U$9:U26))","v":0},{"$f":"IF(ISTEXT(V25),0,SUM(V$9:V25))","v":0},0]
["2024-05-13",null,null,2,13,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A27=\"-\",0,SUM(AQ$9:AQ27))","v":0},{"$f":"IF(A27=\"-\",0,SUM(T$9:T27)+SUM(U$9:U27))","v":0},{"$f":"IF(ISTEXT(V26),0,SUM(V$9:V26))","v":0},0]
["2024-05-14",null,null,3,14,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A28=\"-\",0,SUM(AQ$9:AQ28))","v":0},{"$f":"IF(A28=\"-\",0,SUM(T$9:T28)+SUM(U$9:U28))","v":0},{"$f":"IF(ISTEXT(V27),0,SUM(V$9:V27))","v":0},0]
["2024-05-15",null,null,4,15,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A29=\"-\",0,SUM(AQ$9:AQ29))","v":0},{"$f":"IF(A29=\"-\",0,SUM(T$9:T29)+SUM(U$9:U29))","v":0},{"$f":"IF(ISTEXT(V28),0,SUM(V$9:V28))","v":0},0]
["2024-05-16",null,null,5,16,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A30=\"-\",0,SUM(AQ$9:AQ30))","v":0},{"$f":"IF(A30=\"-\",0,SUM(T$9:T30)+SUM(U$9:U30))","v":0},{"$f":"IF(ISTEXT(V29),0,SUM(V$9:V29))","v":0},0]
["2024-05-17",null,null,6,17,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A31=\"-\",0,SUM(AQ$9:AQ31))","v":0},{"$f":"IF(A31=\"-\",0,SUM(T$9:T31)+SUM(U$9:U31))","v":0},{"$f":"IF(ISTEXT(V30),0,SUM(V$9:V30))","v":0},0]
["2024-05-18",1,null,7,18,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A32=\"-\",0,SUM(AQ$9:AQ32))","v":0},{"$f":"IF(A32=\"-\",0,SUM(T$9:T32)+SUM(U$9:U32))","v":0},{"$f":"IF(ISTEXT(V31),0,SUM(V$9:V31))","v":0},0]
["2024-05-19",null,null,1,19,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A33=\"-\",0,SUM(AQ$9:AQ33))","v":0},{"$f":"IF(A33=\"-\",0,SUM(T$9:T33)+SUM(U$9:U33))","v":0},{"$f":"IF(ISTEXT(V32),0,SUM(V$9:V32))","v":0},0]
["2024-05-20",null,null,2,20,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A34=\"-\",0,SUM(AQ$9:AQ34))","v":0},{"$f":"IF(A34=\"-\",0,SUM(T$9:T34)+SUM(U$9:U34))","v":0},{"$f":"IF(ISTEXT(V33),0,SUM(V$9:V33))","v":0},0]
["2024-05-21",null,null,3,21,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A35=\"-\",0,SUM(AQ$9:AQ35))","v":0},{"$f":"IF(A35=\"-\",0,SUM(T$9:T35)+SUM(U$9:U35))","v":0},{"$f":"IF(ISTEXT(V34),0,SUM(V$9:V34))","v":0},0]
["2024-05-22",null,null,4,22,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A36=\"-\",0,SUM(AQ$9:AQ36))","v":0},{"$f":"IF(A36=\"-\",0,SUM(T$9:T36)+SUM(U$9:U36))","v":0},{"$f":"IF(ISTEXT(V35),0,SUM(V$9:V35))","v":0},0]
["2024-05-23",null,null,5,23,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A37=\"-\",0,SUM(AQ$9:AQ37))","v":0},{"$f":"IF(A37=\"-\",0,SUM(T$9:T37)+SUM(U$9:U37))","v":0},{"$f":"IF(ISTEXT(V36),0,SUM(V$9:V36))","v":0},0]
["2024-05-24",null,null,6,24,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A38=\"-\",0,SUM(AQ$9:AQ38))","v":0},{"$f":"IF(A38=\"-\",0,SUM(T$9:T38)+SUM(U$9:U38))","v":0},{"$f":"IF(ISTEXT(V37),0,SUM(V$9:V37))","v":0},0]
["2024-05-25",1,null,7,25,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.6666666666666667,0,0,0,{"$f":"IF(A39=\"-\",0,SUM(AQ$9:AQ39))","v":0},{"$f":"IF(A39=\"-\",0,SUM(T$9:T39)+SUM(U$9:U39))","v":0},{"$f":"IF(ISTEXT(V38),0,SUM(V$9:V38))","v":0},0]
["2024-05-26",null,null,1,26,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.4285714285714286,0,0,0,{"$f":"IF(A40=\"-\",0,SUM(AQ$9:AQ40))","v":0},{"$f":"IF(A40=\"-\",0,SUM(T$9:T40)+SUM(U$9:U40))","v":0},{"$f":"IF(ISTEXT(V39),0,SUM(V$9:V39))","v":0},0]
["2024-05-27",null,null,2,27,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.4285714285714286,0,0,0,{"$f":"IF(A41=\"-\",0,SUM(AQ$9:AQ41))","v":0},{"$f":"IF(A41=\"-\",0,SUM(T$9:T41)+SUM(U$9:U41))","v":0},{"$f":"IF(ISTEXT(V40),0,SUM(V$9:V40))","v":0},0]
["2024-05-28",null,null,3,28,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.4285714285714286,0,0,0,{"$f":"IF(A42=\"-\",0,SUM(AQ$9:AQ42))","v":0},{"$f":"IF(A42=\"-\",0,SUM(T$9:T42)+SUM(U$9:U42))","v":0},{"$f":"IF(ISTEXT(V41),0,SUM(V$9:V41))","v":0},0]
["2024-05-29",null,null,4,29,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.4285714285714286,0,0,0,{"$f":"IF(A43=\"-\",0,SUM(AQ$9:AQ43))","v":0},{"$f":"IF(A43=\"-\",0,SUM(T$9:T43)+SUM(U$9:U43))","v":0},{"$f":"IF(ISTEXT(V42),0,SUM(V$9:V42))","v":0},0]
["2024-05-30",null,null,5,30,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.4285714285714286,0,0,0,{"$f":"IF(A44=\"-\",0,SUM(AQ$9:AQ44))","v":0},{"$f":"IF(A44=\"-\",0,SUM(T$9:T44)+SUM(U$9:U44))","v":0},{"$f":"IF(ISTEXT(V43),0,SUM(V$9:V43))","v":0},0]
["2024-05-31",2,1,6,31,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.33333333333333331,0,1.4285714285714286,0,0,0,{"$f":"IF(A45=\"-\",0,SUM(AQ$9:AQ45))","v":0},{"$f":"IF(A45=\"-\",0,SUM(T$9:T45)+SUM(U$9:U45))","v":0},{"$f":"IF(ISTEXT(V44),0,SUM(V$9:V44))","v":0},0]
["合計",null,null,null,null,null,{"$f":"SUM(G15:G45)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q15:Q45)","v":0},{"$f":"SUM(R15:R45)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10.333333333333334,0,47.380952380952394,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"①",null,null,null,null,null,null,null,null,null,"②","③","④","⑤","⑥","⑦","⑧","⑨","⑩","⑪","⑫","⑬","⑭","⑮","⑯","⑰","⑱","⑲","⑳","㉑","㉒"]