{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["別紙１","4月","5月","6月","7月","8月","9月","10月","11月","12月","1月","2月","3月","記載例1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"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":26,"n_cols":37,"rows_kept":26,"cut":false,"hidden":false,"merged":[[20,26,20,27],[21,26,21,27],[22,26,22,27],[11,20,11,25],[12,20,12,25],[13,20,13,25],[14,20,14,25],[15,20,15,25],[16,20,16,25],[17,20,17,25],[11,26,11,27],[12,26,12,27],[13,26,13,27],[14,26,14,27],[15,26,15,27],[16,26,16,27],[17,26,17,27],[18,26,18,27],[19,26,19,27],[11,15,11,17],[11,18,11,19],[11,0,11,3],[3,22,3,25],[20,0,20,3],[19,0,19,3],[18,0,18,3],[18,4,18,6],[18,7,18,9],[18,10,18,11],[18,12,18,14],[18,15,18,17],[18,18,18,19],[17,0,17,3],[17,4,17,6],[17,7,17,9],[17,10,17,11],[11,10,11,11],[11,4,11,6],[11,7,11,9],[17,18,17,19],[14,4,14,6],[20,12,20,14],[20,15,20,17],[20,18,20,19],[19,4,19,6],[19,7,19,9],[19,10,19,11],[19,12,19,14],[19,15,19,17],[18,20,18,25],[19,20,19,25],[24,4,24,6],[24,12,24,14],[24,7,24,11],[24,15,24,19],[21,15,21,17],[20,20,20,25],[21,20,21,25],[19,18,19,19],[20,4,20,6],[20,7,20,9],[20,10,20,11],[23,20,23,21],[24,20,24,21],[22,20,22,25],[21,4,21,6],[21,7,21,9],[11,12,11,14],[25,0,38,27],[23,4,23,6],[23,7,23,9],[23,10,23,11],[23,12,23,14],[23,15,23,17],[23,18,23,19],[23,0,24,3],[21,18,21,19],[22,0,22,3],[22,4,22,6],[22,7,22,9],[22,10,22,11],[22,12,22,14],[22,15,22,17],[22,18,22,19],[21,10,21,11],[21,12,21,14],[14,15,14,17],[14,18,14,19],[17,12,17,14],[17,15,17,17],[15,18,15,19],[16,4,16,6],[16,7,16,9],[16,10,16,11],[16,12,16,14],[16,15,16,17],[16,18,16,19],[15,0,15,3],[15,4,15,6],[15,7,15,9],[15,10,15,11],[15,12,15,14],[15,15,15,17],[16,0,16,3],[1,0,1,27],[4,0,4,3],[4,4,4,14],[4,16,4,17],[4,22,4,23],[5,0,5,3],[9,12,9,19],[10,4,10,6],[10,7,10,9],[10,10,10,11],[10,12,10,14],[10,15,10,17],[10,18,10,19],[3,26,3,27],[8,0,8,3],[9,0,10,3],[9,4,9,11],[5,4,5,27],[6,4,6,27],[7,4,7,27],[8,4,8,27],[9,20,10,25],[9,26,10,27],[24,22,24,27],[23,22,23,27],[11,32,22,32],[6,0,6,3],[7,0,7,3],[12,0,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[12,15,12,17],[12,18,12,19],[13,0,13,3],[13,4,13,6],[13,7,13,9],[13,10,13,11],[13,12,13,14],[13,15,13,17],[13,18,13,19],[14,0,14,3],[14,7,14,9],[14,10,14,11],[14,12,14,14],[21,0,21,3]]}
["様式１"]
["閉 所 計 画 ・ 閉 所 実 績 書"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"対象年度",null,null,2024,null,null,null,"年度"]
["提 出 日",null,null,null,"令和7年4月31日"]
["工 事 名",null,null,null,"●●●●●●●●工事"]
["受 注 者",null,null,null,"○○○○〇工業(株)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"４週６休"]
["工　　期",null,null,null,"令和７年４月17日～令和８年３月15日",null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"４週８休"]
["月　別",null,null,null,"計画",null,null,null,null,null,null,null,"実績",null,null,null,null,null,null,null,"備　考\n（対象外の期間等）",null,null,null,null,null,"月単位",null,null,null,null,null,"シミュレーション表"]
[null,null,null,null,"閉所日数",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":"'4月'!A6:B6","v":"令6年4月"},null,null,null,{"$f":"'4月'!C39","v":0},null,null,{"$f":"'4月'!C40","v":0},null,null,{"$f":"'4月'!C41","v":"対象外"},null,{"$f":"'4月'!D39","v":0},null,null,{"$f":"'4月'!D40","v":0},null,null,{"$f":"'4月'!D41","v":"対象外"},null,"４月は準備期間",null,null,null,null,null,{"$f":"'4月'!F44","v":"－"},null,null,null,null,null,"月毎",{"$f":"A12","v":"令6年4月"},{"$f":"ROUNDUP(AK12*AJ12,0)","v":0},{"$f":"H12","v":0},{"$f":"IF(AK11=\"４週６休\",0.214,IF(AK11=\"４週７休\",0.254,IF(AK11=\"４週８休\",0.285)))","v":0.28499999999999998}]
[{"$f":"'5月'!A6:B6","v":"令6年5月"},null,null,null,{"$f":"'5月'!C40","v":7},null,null,{"$f":"'5月'!C41","v":24},null,null,{"$f":"'5月'!C42","v":0.29166666666666669},null,{"$f":"'5月'!D40","v":7},null,null,{"$f":"'5月'!D41","v":24},null,null,{"$f":"'5月'!D42","v":0.29166666666666669},null,"5/8 現場着手日",null,null,null,null,null,{"$f":"'5月'!F45","v":"◎"},null,null,null,null,null,null,{"$f":"A13","v":"令6年5月"},{"$f":"ROUNDUP(AK13*AJ13,0)","v":7},{"$f":"H13","v":24},{"$f":"AK12","v":0.28499999999999998}]
[{"$f":"'6月'!A6:B6","v":"令6年6月"},null,null,null,{"$f":"'6月'!C39","v":9},null,null,{"$f":"'6月'!C40","v":30},null,null,{"$f":"'6月'!C41","v":0.3},null,{"$f":"'6月'!D39","v":10},null,null,{"$f":"'6月'!D40","v":30},null,null,{"$f":"'6月'!D41","v":0.33333333333333331},null,null,null,null,null,null,null,{"$f":"'6月'!F44","v":"◎"},null,null,null,null,null,null,"令6年6月",9,30,{"$f":"AK13","v":0.28499999999999998}]
[{"$f":"'7月'!A6:B6","v":"令6年7月"},null,null,null,{"$f":"'7月'!C40","v":10},null,null,{"$f":"'7月'!C41","v":31},null,null,{"$f":"'7月'!C42","v":0.32258064516129031},null,{"$f":"'7月'!D40","v":10},null,null,{"$f":"'7月'!D41","v":31},null,null,{"$f":"'7月'!D42","v":0.32258064516129031},null,null,null,null,null,null,null,{"$f":"'7月'!F45","v":"◎"},null,null,null,null,null,null,"令6年7月",9,31,0.28499999999999998]
[{"$f":"'8月'!A6:B6","v":"令6年8月"},null,null,null,{"$f":"'8月'!C40","v":9},null,null,{"$f":"'8月'!C41","v":27},null,null,{"$f":"'8月'!C42","v":0.33333333333333331},null,{"$f":"'8月'!D40","v":9},null,null,{"$f":"'8月'!D41","v":27},null,null,{"$f":"'8月'!D42","v":0.33333333333333331},null,"夏季休暇４日を除く",null,null,null,null,null,{"$f":"'8月'!F45","v":"◎"},null,null,null,null,null,null,"令6年8月",8,27,0.28499999999999998]
[{"$f":"'9月'!A6:B6","v":"令6年9月"},null,null,null,{"$f":"'9月'!C39","v":9},null,null,{"$f":"'9月'!C40","v":30},null,null,{"$f":"'9月'!C41","v":0.3},null,{"$f":"'9月'!D39","v":9},null,null,{"$f":"'9月'!D40","v":30},null,null,{"$f":"'9月'!D41","v":0.3},null,null,null,null,null,null,null,{"$f":"'9月'!F44","v":"◎"},null,null,null,null,null,null,"令6年9月",9,30,0.28499999999999998]
[{"$f":"'10月'!A6:B6","v":"令6年10月"},null,null,null,{"$f":"'10月'!C40","v":9},null,null,{"$f":"'10月'!C41","v":31},null,null,{"$f":"'10月'!C42","v":0.29032258064516131},null,{"$f":"'10月'!D40","v":9},null,null,{"$f":"'10月'!D41","v":31},null,null,{"$f":"'10月'!D42","v":0.29032258064516131},null,null,null,null,null,null,null,{"$f":"'10月'!F45","v":"◎"},null,null,null,null,null,null,"令6年10月",9,31,0.28499999999999998]
[{"$f":"'11月'!A6:B6","v":"令6年11月"},null,null,null,{"$f":"'11月'!C39","v":11},null,null,{"$f":"'11月'!C40","v":30},null,null,{"$f":"'11月'!C41","v":0.36666666666666664},null,{"$f":"'11月'!D39","v":11},null,null,{"$f":"'11月'!D40","v":30},null,null,{"$f":"'11月'!D41","v":0.36666666666666664},null,null,null,null,null,null,null,{"$f":"'11月'!F44","v":"◎"},null,null,null,null,null,null,"令6年11月",9,30,0.28499999999999998]
[{"$f":"'12月'!A6:B6","v":"令6年12月"},null,null,null,{"$f":"'12月'!C40","v":9},null,null,{"$f":"'12月'!C41","v":28},null,null,{"$f":"'12月'!C42","v":0.32142857142857145},null,{"$f":"'12月'!D40","v":9},null,null,{"$f":"'12月'!D41","v":28},null,null,{"$f":"'12月'!D42","v":0.32142857142857145},null,"年末休暇３日を除く",null,null,null,null,null,{"$f":"'12月'!F45","v":"◎"},null,null,null,null,null,null,"令6年12月",8,28,0.28499999999999998]
[{"$f":"'1月'!A6:B6","v":"令7年1月"},null,null,null,{"$f":"'1月'!C40","v":8},null,null,{"$f":"'1月'!C41","v":27},null,null,{"$f":"'1月'!C42","v":0.29629629629629628},null,{"$f":"'1月'!D40","v":8},null,null,{"$f":"'1月'!D41","v":27},null,null,{"$f":"'1月'!D42","v":0.29629629629629628},null,"年始休暇４日を除く",null,null,null,null,null,{"$f":"'1月'!F45","v":"◎"},null,null,null,null,null,null,"令7年1月",8,27,0.28499999999999998]
[{"$f":"'2月'!A6:B6","v":"令7年2月"},null,null,null,{"$f":"'2月'!C38","v":9},null,null,{"$f":"'2月'!C39","v":28},null,null,{"$f":"'2月'!C40","v":0.32142857142857145},null,{"$f":"'2月'!D38","v":7},null,null,{"$f":"'2月'!D39","v":28},null,null,{"$f":"'2月'!D40","v":0.25},null,null,null,null,null,null,null,{"$f":"'2月'!F43","v":"×"},null,{"$f":"COUNTIF(AA12:AB23,\"－\")","v":1},null,null,null,null,"令7年2月",8,28,0.28499999999999998]
[{"$f":"'3月'!A6:B6","v":"令7年3月"},null,null,null,{"$f":"'3月'!C40","v":7},null,null,{"$f":"'3月'!C41","v":15},null,null,{"$f":"'3月'!C42","v":0.46666666666666667},null,{"$f":"'3月'!D40","v":5},null,null,{"$f":"'3月'!D41","v":15},null,null,{"$f":"'3月'!D42","v":0.33333333333333331},null,"3/15 現場施工完了",null,null,null,null,null,{"$f":"'3月'!F45","v":"◎"},null,{"$f":"COUNTIF(AA12:AB23,\"×\")","v":1},null,null,null,null,"令7年3月",5,15,0.28499999999999998]
["累　計",null,null,null,{"$f":"SUM(E12:G23)","v":97},null,null,{"$f":"SUM(H12:J23)","v":301},null,null,{"$f":"E24/H24","v":0.32225913621262459},null,{"$f":"SUM(M13:M23)","v":94},null,null,{"$f":"SUM(P12:R23)","v":301},null,null,{"$f":"M24/P24","v":0.3122923588039867},null,"月単位",null,{"$f":"IF(AC22=12,\"\",IF(AC23>=1,\"未\",\"★達成\"))","v":"未"},null,null,null,null,null,null,null,null,null,"累計","通年",86,{"$f":"SUM(AJ12:AJ23)","v":301},{"$f":"AK23","v":0.28499999999999998}]
[null,null,null,null,"計画",null,null,{"$f":"IF(K24>=28.5%,\"４週８休\",\"未達成\")","v":"４週８休"},null,null,null,null,"実績",null,null,{"$f":"IF(S24>=28.5%,\"４週８休\",\"未達成\")","v":"４週８休"},null,null,null,null,"通期",null,{"$f":"IF(P25=\"４週８休\",\"★達成\",\"未\")","v":"★達成"}]
["【作成要領】\n（１）確保工事に取り組む場合、受注者は、施工計画時の週休２日を確保した工程表に基づき、\n      対象期間内の閉所日、対象日を監督員と協議し決定する。\n（２）閉所日、対象日の計画決定後、月ごとの別シート(以降、別シート)に予定を入力し「閉所計画・\n　　　閉所実績書」(以降、「本書」)を作成する。\n（３）閉所計画作成後、本書に別シートを添付し監督員に提出する\n（４）着手日以降、別シートの閉所実施日欄への入力を進め、本書と併せ、毎月監督員に提出する。\n      なお、計画と異なった場合は「現場閉所計画と現場閉所実績に差異がある場合等に記載」の欄\n      に、理由を記載する。\n"]

{"sheet":"4月","index":1,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,0,1,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[42,2,42,4],[41,2,41,4],[38,4,38,5],[6,5,7,5],[2,1,2,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":30}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B38,\"土\")+COUNTIF(B9:B38,\"日\")","v":8}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.26666666666666666}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令6年4月"},null,null,null,null,null,null,"年",{"$f":"別紙１!W4","v":2024},{"$f":"DATE(I6,I7,1)","v":"2024-04-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",4]
[]
[{"$f":"DATE(I6,I7,1)","v":"2024-04-01"},{"$f":"TEXT(A9,\"aaa\")","v":"月"},"－","－"]
[{"$f":"A9+1","v":"2024-04-02"},{"$f":"TEXT(A10,\"aaa\")","v":"火"},"－","－",null,null,null,"リスト"]
[{"$f":"A10+1","v":"2024-04-03"},"水","－","－",null,null,null,"閉所","〇"]
["2024-04-04","木","－","－",null,null,null,"現場休息","●"]
["2024-04-05","金","－","－",null,null,null,"振替閉所","◎"]
["2024-04-06","土","－","－",null,null,null,"対象外","－"]
["2024-04-07","日","－","－",null,null,null,"雨天等","天"]
["2024-04-08","月","－","－"]
["2024-04-09","火","－","－"]
["2024-04-10","水","－","－"]
["2024-04-11","木","－","－"]
["2024-04-12","金","－","－"]
["2024-04-13","土","－","－"]
["2024-04-14","日","－","－"]
["2024-04-15","月","－","－"]
["2024-04-16","火","－","－"]
["2024-04-17","水","－","－","契約着工日"]
["2024-04-18","木","－","－","対象期間外（現場施工着手前）"]
["2024-04-19","金","－","－","対象期間外（現場施工着手前）"]
["2024-04-20","土","－","－","対象期間外（現場施工着手前）"]
["2024-04-21","日","－","－","対象期間外（現場施工着手前）"]
["2024-04-22","月","－","－","対象期間外（現場施工着手前）"]
["2024-04-23","火","－","－","対象期間外（現場施工着手前）"]
["2024-04-24","水","－","－","対象期間外（現場施工着手前）"]
["2024-04-25","木","－","－","対象期間外（現場施工着手前）"]
["2024-04-26","金","－","－","対象期間外（現場施工着手前）"]
["2024-04-27","土","－","－","対象期間外（現場施工着手前）"]
["2024-04-28","日","－","－","対象期間外（現場施工着手前）"]
["2024-04-29","月","－","－","対象期間外（現場施工着手前）","祝日"]
[{"$f":"A37+1","v":"2024-04-30"},"火","－","－","対象期間外（現場施工着手前）"]
["閉所日数",null,{"$f":"COUNTIF(C9:C38,\"〇\")+COUNTIF(C9:C38,\"◎\")+COUNTIF(C9:C38,\"天\")+COUNTIF(C9:C38,\"●\")","v":0},{"$f":"COUNTIF(D9:D38,\"〇\")+COUNTIF(D9:D38,\"◎\")+COUNTIF(D9:D38,\"天\")+COUNTIF(D9:D38,\"●\")","v":0}]
["対象日数",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C38,\"－\")","v":0},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D38,\"－\")","v":0}]
["閉所率",null,{"$f":"IF(C40<>0,C39/C40,\"対象外\")","v":"対象外"},{"$f":"IF(D40<>0,D39/D40,\"対象外\")","v":"対象外"},null,{"$f":"IF(D41=\"対象外\",\"対象外\",IF(D41>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"対象外"}]
["土日数",0,{"$f":"IF(D41<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":""}]
["土日率",{"$f":"IF(F41<>\"対象外\",IF(L4<0.285,L4,\"\"),\"\")","v":""},{"$f":"IF(B43<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":""},null,null,{"$f":"IF(L4<0.285,IF(F41=\"対象外\",\"\",IF(B43<0.285,IF(B42<=D39,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":""}]
[null,null,null,null,"達成の判定",{"$f":"IF(F41=\"対象外\",\"－\",IF(OR(F41=\"閉所率で達成\",F43=\"土日数で達成\"),\"◎\",\"×\"))","v":"－"}]

{"sheet":"5月","index":2,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[43,2,43,4],[42,2,42,4],[6,5,7,5],[2,1,2,4],[1,0,1,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":31}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B39,\"土\")+COUNTIF(B9:B39,\"日\")","v":8}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.25806451612903225}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令6年5月"},null,null,null,null,null,null,"年",{"$f":"'4月'!I6","v":2024},{"$f":"DATE(I6,I7,1)","v":"2024-05-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",5]
[]
[{"$f":"DATE(I6,I7,1)","v":"2024-05-01"},{"$f":"TEXT(A9,\"aaa\")","v":"水"},"－","－","対象期間外（現場施工着手前）"]
[{"$f":"A9+1","v":"2024-05-02"},{"$f":"TEXT(A10,\"aaa\")","v":"木"},"－","－","対象期間外（現場施工着手前）",null,null,"凡例"]
[{"$f":"A10+1","v":"2024-05-03"},"金","－","－","対象期間外（現場施工着手前）","祝日",null,"閉所","〇"]
["2024-05-04","土","－","－","対象期間外（現場施工着手前）","祝日",null,"現場休息","●"]
["2024-05-05","日","－","－","対象期間外（現場施工着手前）","祝日",null,"振替閉所","◎"]
["2024-05-06","月","－","－","対象期間外（現場施工着手前）","祝日",null,"対象外","－"]
["2024-05-07","火","－","－","対象期間外（現場施工着手前）",null,null,"雨天等","天"]
["2024-05-08","水",null,null,"着手日"]
["2024-05-09","木"]
["2024-05-10","金","〇","〇"]
["2024-05-11","土","〇","〇"]
["2024-05-12","日"]
["2024-05-13","月"]
["2024-05-14","火"]
["2024-05-15","水"]
["2024-05-16","木"]
["2024-05-17","金","〇","〇"]
["2024-05-18","土","〇","〇"]
["2024-05-19","日"]
["2024-05-20","月"]
["2024-05-21","火"]
["2024-05-22","水"]
["2024-05-23","木"]
["2024-05-24","金","〇","〇"]
["2024-05-25","土","〇","〇"]
["2024-05-26","日"]
["2024-05-27","月"]
["2024-05-28","火"]
["2024-05-29","水"]
["2024-05-30","木"]
["2024-05-31","金","〇","〇"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C39,\"〇\")+COUNTIF(C9:C39,\"◎\")+COUNTIF(C9:C39,\"天\")+COUNTIF(C9:C39,\"●\")","v":7},{"$f":"COUNTIF(D9:D39,\"〇\")+COUNTIF(D9:D39,\"◎\")+COUNTIF(D9:D39,\"天\")+COUNTIF(D9:D39,\"●\")","v":7}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C39,\"－\")","v":24},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D39,\"－\")","v":24}]
["閉所率",null,{"$f":"IF(C41<>0,C40/C41,\"対象外\")","v":0.29166666666666669},{"$f":"IF(D41<>0,D40/D41,\"対象外\")","v":0.29166666666666669},null,{"$f":"IF(D42=\"対象外\",\"対象外\",IF(D42>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"閉所率で達成"}]
["土日数",7,{"$f":"IF(D42<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":"※対象期間内の土日数を入力してください（手入力)"}]
["土日率",{"$f":"IF(F42<>\"対象外\",IF(L4<0.285,L4,\"\"),\"\")","v":0.25806451612903225},{"$f":"IF(B44<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":"※28.5%未満なので土日数で計算となります。"},null,null,{"$f":"IF(L5<0.285,IF(F42=\"対象外\",\"\",IF(B44<0.285,IF(B43<=D40,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":"土日数で達成"}]
[null,null,null,null,"達成の判定",{"$f":"IF(F42=\"対象外\",\"－\",IF(OR(F42=\"閉所率で達成\",F44=\"土日数で達成\"),\"◎\",\"×\"))","v":"◎"}]

{"sheet":"6月","index":3,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[41,2,41,4],[42,2,42,4],[6,5,7,5],[1,0,1,4],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[2,1,2,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":30}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B38,\"土\")+COUNTIF(B9:B38,\"日\")","v":10}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.33333333333333331}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令6年6月"},null,null,null,null,null,null,"年",{"$f":"別紙１!W4","v":2024},{"$f":"DATE(I6,I7,1)","v":"2024-06-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",6]
[]
[{"$f":"DATE(I6,I7,1)","v":"2024-06-01"},{"$f":"TEXT(A9,\"aaa\")","v":"土"},"〇","〇"]
[{"$f":"A9+1","v":"2024-06-02"},{"$f":"TEXT(A10,\"aaa\")","v":"日"},null,null,null,null,null,"リスト"]
[{"$f":"A10+1","v":"2024-06-03"},"月",null,null,null,null,null,"閉所","〇"]
["2024-06-04","火",null,null,null,null,null,"現場休息","●"]
["2024-06-05","水",null,null,null,null,null,"振替閉所","◎"]
["2024-06-06","木",null,null,null,null,null,"対象外","－"]
["2024-06-07","金","〇","〇",null,null,null,"雨天等","天"]
["2024-06-08","土","〇","〇"]
["2024-06-09","日"]
["2024-06-10","月"]
["2024-06-11","火"]
["2024-06-12","水"]
["2024-06-13","木"]
["2024-06-14","金"]
["2024-06-15","土","〇","〇"]
["2024-06-16","日","〇",null,"地元との協議により作業実施"]
["2024-06-17","月",null,"◎","６月16日の振替閉所"]
["2024-06-18","火"]
["2024-06-19","水"]
["2024-06-20","木"]
["2024-06-21","金","〇","〇"]
["2024-06-22","土","〇","〇"]
["2024-06-23","日",null,"天","雨天により閉所（監督職員に連絡済）"]
["2024-06-24","月"]
["2024-06-25","火"]
["2024-06-26","水"]
["2024-06-27","木"]
["2024-06-28","金","〇","〇"]
["2024-06-29","土","〇","〇"]
[{"$f":"A37+1","v":"2024-06-30"},"日"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C38,\"〇\")+COUNTIF(C9:C38,\"◎\")+COUNTIF(C9:C38,\"天\")+COUNTIF(C9:C38,\"●\")","v":9},{"$f":"COUNTIF(D9:D38,\"〇\")+COUNTIF(D9:D38,\"◎\")+COUNTIF(D9:D38,\"天\")+COUNTIF(D9:D38,\"●\")","v":10}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C38,\"－\")","v":30},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D38,\"－\")","v":30}]
["閉所率",null,{"$f":"IF(C40<>0,C39/C40,\"対象外\")","v":0.3},{"$f":"IF(D40<>0,D39/D40,\"対象外\")","v":0.33333333333333331},null,{"$f":"IF(D41=\"対象外\",\"対象外\",IF(D41>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"閉所率で達成"}]
["土日数",9,{"$f":"IF(D41<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":""}]
["土日率",{"$f":"IF(F41<>\"対象外\",IF(L4<0.285,L4,\"\"),\"\")","v":""},{"$f":"IF(B43<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":""},null,null,{"$f":"IF(L4<0.285,IF(F41=\"対象外\",\"\",IF(B43<0.285,IF(B42<=D39,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":""}]
[null,null,null,null,"達成の判定",{"$f":"IF(F41=\"対象外\",\"－\",IF(OR(F41=\"閉所率で達成\",F43=\"土日数で達成\"),\"◎\",\"×\"))","v":"◎"}]

{"sheet":"7月","index":4,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,2,42,4],[43,2,43,4],[6,5,7,5],[2,1,2,4],[1,0,1,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":31}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B39,\"土\")+COUNTIF(B9:B39,\"日\")","v":8}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.25806451612903225}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令6年7月"},null,null,null,null,null,null,"年",{"$f":"別紙１!W4","v":2024},{"$f":"DATE(I6,I7,1)","v":"2024-07-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",7]
[]
[{"$f":"DATE(I6,I7,1)","v":"2024-07-01"},{"$f":"TEXT(A9,\"aaa\")","v":"月"}]
[{"$f":"A9+1","v":"2024-07-02"},{"$f":"TEXT(A10,\"aaa\")","v":"火"},null,null,null,null,null,"凡例"]
[{"$f":"A10+1","v":"2024-07-03"},"水",null,null,null,null,null,"閉所","〇"]
["2024-07-04","木",null,null,null,null,null,"現場休息","●"]
["2024-07-05","金","〇","〇",null,null,null,"振替閉所","◎"]
["2024-07-06","土","〇","〇",null,null,null,"対象外","－"]
["2024-07-07","日",null,"天","雨天により閉所（監督職員に連絡済）",null,null,"雨天等","天"]
["2024-07-08","月",null,"天","雨天により閉所（監督職員に連絡済）"]
["2024-07-09","火"]
["2024-07-10","水"]
["2024-07-11","木"]
["2024-07-12","金","〇",null,"７月７日休工の振替作業"]
["2024-07-13","土","〇","〇"]
["2024-07-14","日","〇","〇"]
["2024-07-15","月"]
["2024-07-16","火"]
["2024-07-17","水"]
["2024-07-18","木"]
["2024-07-19","金","〇",null,"７月８日休工の振替作業"]
["2024-07-20","土","〇","〇"]
["2024-07-21","日","〇","〇",null,"祝日"]
["2024-07-22","月"]
["2024-07-23","火"]
["2024-07-24","水"]
["2024-07-25","木"]
["2024-07-26","金","〇","〇"]
["2024-07-27","土","〇","〇"]
["2024-07-28","日"]
["2024-07-29","月"]
["2024-07-30","火"]
["2024-07-31","水"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C39,\"〇\")+COUNTIF(C9:C39,\"◎\")+COUNTIF(C9:C39,\"天\")+COUNTIF(C9:C39,\"●\")","v":10},{"$f":"COUNTIF(D9:D39,\"〇\")+COUNTIF(D9:D39,\"◎\")+COUNTIF(D9:D39,\"天\")+COUNTIF(D9:D39,\"●\")","v":10}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C39,\"－\")","v":31},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D39,\"－\")","v":31}]
["閉所率",null,{"$f":"IF(C41<>0,C40/C41,\"対象外\")","v":0.32258064516129031},{"$f":"IF(D41<>0,D40/D41,\"対象外\")","v":0.32258064516129031},null,{"$f":"IF(D42=\"対象外\",\"対象外\",IF(D42>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"閉所率で達成"}]
["土日数",8,{"$f":"IF(D42<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":"※対象期間内の土日数を入力してください（手入力)"}]
["土日率",{"$f":"IF(F42<>\"対象外\",IF(L4<0.285,L4,\"\"),\"\")","v":0.25806451612903225},{"$f":"IF(B44<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":"※28.5%未満なので土日数で計算となります。"},null,null,{"$f":"IF(L5<0.285,IF(F42=\"対象外\",\"\",IF(B44<0.285,IF(B43<=D40,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":"土日数で達成"}]
[null,null,null,null,"達成の判定",{"$f":"IF(F42=\"対象外\",\"－\",IF(OR(F42=\"閉所率で達成\",F44=\"土日数で達成\"),\"◎\",\"×\"))","v":"◎"}]

{"sheet":"8月","index":5,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,2,42,4],[43,2,43,4],[6,5,7,5],[2,1,2,4],[1,0,1,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":31}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B39,\"土\")+COUNTIF(B9:B39,\"日\")","v":9}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.29032258064516131}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令6年8月"},null,null,null,null,null,null,"年",{"$f":"別紙１!W4","v":2024},{"$f":"DATE(I6,I7,1)","v":"2024-08-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",8]
[]
[{"$f":"DATE(I6,I7,1)","v":"2024-08-01"},{"$f":"TEXT(A9,\"aaa\")","v":"木"}]
[{"$f":"A9+1","v":"2024-08-02"},{"$f":"TEXT(A10,\"aaa\")","v":"金"},"〇","〇",null,null,null,"凡例"]
[{"$f":"A10+1","v":"2024-08-03"},"土","〇","〇",null,null,null,"閉所","〇"]
["2024-08-04","日",null,null,null,null,null,"現場休息","●"]
["2024-08-05","月",null,null,null,null,null,"振替閉所","◎"]
["2024-08-06","火",null,null,null,null,null,"対象外","－"]
["2024-08-07","水",null,null,null,null,null,"雨天等","天"]
["2024-08-08","木"]
["2024-08-09","金"]
["2024-08-10","土","〇","〇"]
["2024-08-11","日","〇","〇",null,"祝日"]
["2024-08-12","月"]
["2024-08-13","火","－","－","対象期間外（夏季休暇）"]
["2024-08-14","水","－","－","対象期間外（夏季休暇）"]
["2024-08-15","木","－","－","対象期間外（夏季休暇）"]
["2024-08-16","金","－","－","対象期間外（夏季休暇）"]
["2024-08-17","土","〇","〇"]
["2024-08-18","日"]
["2024-08-19","月"]
["2024-08-20","火"]
["2024-08-21","水"]
["2024-08-22","木"]
["2024-08-23","金","〇","〇"]
["2024-08-24","土","〇","〇"]
["2024-08-25","日"]
["2024-08-26","月"]
["2024-08-27","火"]
["2024-08-28","水"]
["2024-08-29","木"]
["2024-08-30","金","〇","〇"]
["2024-08-31","土","〇","〇"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C39,\"〇\")+COUNTIF(C9:C39,\"◎\")+COUNTIF(C9:C39,\"天\")+COUNTIF(C9:C39,\"●\")","v":9},{"$f":"COUNTIF(D9:D39,\"〇\")+COUNTIF(D9:D39,\"◎\")+COUNTIF(D9:D39,\"天\")+COUNTIF(D9:D39,\"●\")","v":9}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C39,\"－\")","v":27},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D39,\"－\")","v":27}]
["閉所率",null,{"$f":"IF(C41<>0,C40/C41,\"対象外\")","v":0.33333333333333331},{"$f":"IF(D41<>0,D40/D41,\"対象外\")","v":0.33333333333333331},null,{"$f":"IF(D42=\"対象外\",\"対象外\",IF(D42>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"閉所率で達成"}]
["土日数",10,{"$f":"IF(D42<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":""}]
["土日率",{"$f":"IF(F42<>\"対象外\",IF(L4<0.285,L4,\"\"),\"\")","v":""},{"$f":"IF(B44<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":""},null,null,{"$f":"IF(L5<0.285,IF(F42=\"対象外\",\"\",IF(B44<0.285,IF(B43<=D40,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":""}]
[null,null,null,null,"達成の判定",{"$f":"IF(F42=\"対象外\",\"－\",IF(OR(F42=\"閉所率で達成\",F44=\"土日数で達成\"),\"◎\",\"×\"))","v":"◎"}]

{"sheet":"9月","index":6,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[41,2,41,4],[42,2,42,4],[6,5,7,5],[2,1,2,4],[1,0,1,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":30}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B38,\"土\")+COUNTIF(B9:B38,\"日\")","v":9}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.3}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令6年9月"},null,null,null,null,null,null,"年",{"$f":"別紙１!W4","v":2024},{"$f":"DATE(I6,I7,1)","v":"2024-09-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",9]
[]
[{"$f":"DATE(I6,I7,1)","v":"2024-09-01"},{"$f":"TEXT(A9,\"aaa\")","v":"日"}]
[{"$f":"A9+1","v":"2024-09-02"},{"$f":"TEXT(A10,\"aaa\")","v":"月"},null,null,null,null,null,"リスト"]
[{"$f":"A10+1","v":"2024-09-03"},"火",null,null,null,null,null,"閉所","〇"]
["2024-09-04","水",null,null,null,null,null,"現場休息","●"]
["2024-09-05","木",null,null,null,null,null,"振替閉所","◎"]
["2024-09-06","金","〇","〇",null,null,null,"対象外","－"]
["2024-09-07","土","〇","〇",null,null,null,"雨天等","天"]
["2024-09-08","日"]
["2024-09-09","月"]
["2024-09-10","火"]
["2024-09-11","水"]
["2024-09-12","木"]
["2024-09-13","金","〇","〇"]
["2024-09-14","土","〇","〇"]
["2024-09-15","日"]
["2024-09-16","月",null,null,null,"祝日"]
["2024-09-17","火"]
["2024-09-18","水"]
["2024-09-19","木"]
["2024-09-20","金","〇","〇"]
["2024-09-21","土","〇","〇"]
["2024-09-22","日"]
["2024-09-23","月","〇","〇",null,"祝日"]
["2024-09-24","火"]
["2024-09-25","水"]
["2024-09-26","木"]
["2024-09-27","金","〇","〇"]
["2024-09-28","土","〇","〇"]
["2024-09-29","日"]
[{"$f":"A37+1","v":"2024-09-30"},"月"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C38,\"〇\")+COUNTIF(C9:C38,\"◎\")+COUNTIF(C9:C38,\"天\")+COUNTIF(C9:C38,\"●\")","v":9},{"$f":"COUNTIF(D9:D38,\"〇\")+COUNTIF(D9:D38,\"◎\")+COUNTIF(D9:D38,\"天\")+COUNTIF(D9:D38,\"●\")","v":9}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C38,\"－\")","v":30},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D38,\"－\")","v":30}]
["閉所率",null,{"$f":"IF(C40<>0,C39/C40,\"対象外\")","v":0.3},{"$f":"IF(D40<>0,D39/D40,\"対象外\")","v":0.3},null,{"$f":"IF(D41=\"対象外\",\"対象外\",IF(D41>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"閉所率で達成"}]
["土日数",8,{"$f":"IF(D41<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":""}]
["土日率",{"$f":"IF(F41<>\"対象外\",IF(L4<0.285,L4,\"\"),\"\")","v":""},{"$f":"IF(B43<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":""},null,null,{"$f":"IF(L4<0.285,IF(F41=\"対象外\",\"\",IF(B43<0.285,IF(B42<=D39,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":""}]
[null,null,null,null,"達成の判定",{"$f":"IF(F41=\"対象外\",\"－\",IF(OR(F41=\"閉所率で達成\",F43=\"土日数で達成\"),\"◎\",\"×\"))","v":"◎"}]

{"sheet":"10月","index":7,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,2,42,4],[43,2,43,4],[6,5,7,5],[2,1,2,4],[1,0,1,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":31}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B39,\"土\")+COUNTIF(B9:B39,\"日\")","v":8}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.25806451612903225}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令6年10月"},null,null,null,null,null,null,"年",{"$f":"別紙１!W4","v":2024},{"$f":"DATE(I6,I7,1)","v":"2024-10-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",10]
[]
[{"$f":"DATE(I6,I7,1)","v":"2024-10-01"},{"$f":"TEXT(A9,\"aaa\")","v":"火"}]
[{"$f":"A9+1","v":"2024-10-02"},{"$f":"TEXT(A10,\"aaa\")","v":"水"},null,null,null,null,null,"凡例"]
[{"$f":"A10+1","v":"2024-10-03"},"木",null,null,null,null,null,"閉所","〇"]
["2024-10-04","金","〇","〇",null,null,null,"現場休息","●"]
["2024-10-05","土","〇","〇",null,null,null,"振替閉所","◎"]
["2024-10-06","日",null,null,null,null,null,"対象外","－"]
["2024-10-07","月",null,null,null,null,null,"雨天等","天"]
["2024-10-08","火"]
["2024-10-09","水"]
["2024-10-10","木"]
["2024-10-11","金","〇","〇"]
["2024-10-12","土","〇","〇"]
["2024-10-13","日","〇","〇",null,"祝日"]
["2024-10-14","月"]
["2024-10-15","火"]
["2024-10-16","水"]
["2024-10-17","木"]
["2024-10-18","金","〇","〇"]
["2024-10-19","土","〇","〇"]
["2024-10-20","日"]
["2024-10-21","月"]
["2024-10-22","火"]
["2024-10-23","水"]
["2024-10-24","木"]
["2024-10-25","金","〇","〇"]
["2024-10-26","土","〇","〇"]
["2024-10-27","日"]
["2024-10-28","月"]
["2024-10-29","火"]
["2024-10-30","水"]
["2024-10-31","木"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C39,\"〇\")+COUNTIF(C9:C39,\"◎\")+COUNTIF(C9:C39,\"天\")+COUNTIF(C9:C39,\"●\")","v":9},{"$f":"COUNTIF(D9:D39,\"〇\")+COUNTIF(D9:D39,\"◎\")+COUNTIF(D9:D39,\"天\")+COUNTIF(D9:D39,\"●\")","v":9}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C39,\"－\")","v":31},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D39,\"－\")","v":31}]
["閉所率",null,{"$f":"IF(C41<>0,C40/C41,\"対象外\")","v":0.29032258064516131},{"$f":"IF(D41<>0,D40/D41,\"対象外\")","v":0.29032258064516131},null,{"$f":"IF(D42=\"対象外\",\"対象外\",IF(D42>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"閉所率で達成"}]
["土日数",8,{"$f":"IF(D42<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":"※対象期間内の土日数を入力してください（手入力)"}]
["土日率",{"$f":"IF(F42<>\"対象外\",IF(L4<0.285,L4,\"\"),\"\")","v":0.25806451612903225},{"$f":"IF(B44<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":"※28.5%未満なので土日数で計算となります。"},null,null,{"$f":"IF(L5<0.285,IF(F42=\"対象外\",\"\",IF(B44<0.285,IF(B43<=D40,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":"土日数で達成"}]
[null,null,null,null,"達成の判定",{"$f":"IF(F42=\"対象外\",\"－\",IF(OR(F42=\"閉所率で達成\",F44=\"土日数で達成\"),\"◎\",\"×\"))","v":"◎"}]

{"sheet":"11月","index":8,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[41,2,41,4],[42,2,42,4],[6,5,7,5],[2,1,2,4],[1,0,1,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":30}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B38,\"土\")+COUNTIF(B9:B38,\"日\")","v":9}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.3}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令6年11月"},null,null,null,null,null,null,"年",{"$f":"別紙１!W4","v":2024},{"$f":"DATE(I6,I7,1)","v":"2024-11-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",11]
[]
[{"$f":"DATE(I6,I7,1)","v":"2024-11-01"},{"$f":"TEXT(A9,\"aaa\")","v":"金"},"〇","〇"]
[{"$f":"A9+1","v":"2024-11-02"},{"$f":"TEXT(A10,\"aaa\")","v":"土"},"〇","〇",null,null,null,"リスト"]
[{"$f":"A10+1","v":"2024-11-03"},"日","〇","〇",null,"祝日",null,"閉所","〇"]
["2024-11-04","月",null,null,null,null,null,"現場休息","●"]
["2024-11-05","火",null,null,null,null,null,"振替閉所","◎"]
["2024-11-06","水",null,null,null,null,null,"対象外","－"]
["2024-11-07","木",null,null,null,null,null,"雨天等","天"]
["2024-11-08","金","〇","〇"]
["2024-11-09","土","〇","〇"]
["2024-11-10","日"]
["2024-11-11","月"]
["2024-11-12","火"]
["2024-11-13","水"]
["2024-11-14","木"]
["2024-11-15","金","〇","〇"]
["2024-11-16","土","〇","〇"]
["2024-11-17","日"]
["2024-11-18","月"]
["2024-11-19","火"]
["2024-11-20","水"]
["2024-11-21","木"]
["2024-11-22","金","〇","〇"]
["2024-11-23","土","〇","〇"]
["2024-11-24","日","〇","〇",null,"祝日"]
["2024-11-25","月"]
["2024-11-26","火"]
["2024-11-27","水"]
["2024-11-28","木"]
["2024-11-29","金"]
[{"$f":"A37+1","v":"2024-11-30"},"土","〇","〇"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C38,\"〇\")+COUNTIF(C9:C38,\"◎\")+COUNTIF(C9:C38,\"天\")+COUNTIF(C9:C38,\"●\")","v":11},{"$f":"COUNTIF(D9:D38,\"〇\")+COUNTIF(D9:D38,\"◎\")+COUNTIF(D9:D38,\"天\")+COUNTIF(D9:D38,\"●\")","v":11}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C38,\"－\")","v":30},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D38,\"－\")","v":30}]
["閉所率",null,{"$f":"IF(C40<>0,C39/C40,\"対象外\")","v":0.36666666666666664},{"$f":"IF(D40<>0,D39/D40,\"対象外\")","v":0.36666666666666664},null,{"$f":"IF(D41=\"対象外\",\"対象外\",IF(D41>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"閉所率で達成"}]
["土日数",10,{"$f":"IF(D41<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":""}]
["土日率",{"$f":"IF(F41<>\"対象外\",IF(L4<0.285,L4,\"\"),\"\")","v":""},{"$f":"IF(B43<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":""},null,null,{"$f":"IF(L4<0.285,IF(F41=\"対象外\",\"\",IF(B43<0.285,IF(B42<=D39,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":""}]
[null,null,null,null,"達成の判定",{"$f":"IF(F41=\"対象外\",\"－\",IF(OR(F41=\"閉所率で達成\",F43=\"土日数で達成\"),\"◎\",\"×\"))","v":"◎"}]

{"sheet":"12月","index":9,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,2,42,4],[43,2,43,4],[6,5,7,5],[2,1,2,4],[1,0,1,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":31}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B39,\"土\")+COUNTIF(B9:B39,\"日\")","v":9}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.29032258064516131}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令6年12月"},null,null,null,null,null,null,"年",{"$f":"別紙１!W4","v":2024},{"$f":"DATE(I6,I7,1)","v":"2024-12-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",12]
[]
[{"$f":"DATE(I6,I7,1)","v":"2024-12-01"},{"$f":"TEXT(A9,\"aaa\")","v":"日"},"〇","〇"]
[{"$f":"A9+1","v":"2024-12-02"},{"$f":"TEXT(A10,\"aaa\")","v":"月"},null,null,null,null,null,"凡例"]
[{"$f":"A10+1","v":"2024-12-03"},"火",null,null,null,null,null,"閉所","〇"]
["2024-12-04","水",null,null,null,null,null,"現場休息","●"]
["2024-12-05","木",null,null,null,null,null,"振替閉所","◎"]
["2024-12-06","金","〇","〇",null,null,null,"対象外","－"]
["2024-12-07","土","〇","〇",null,null,null,"雨天等","天"]
["2024-12-08","日"]
["2024-12-09","月"]
["2024-12-10","火"]
["2024-12-11","水"]
["2024-12-12","木"]
["2024-12-13","金","〇","〇"]
["2024-12-14","土","〇","〇"]
["2024-12-15","日"]
["2024-12-16","月"]
["2024-12-17","火"]
["2024-12-18","水"]
["2024-12-19","木"]
["2024-12-20","金","〇","〇"]
["2024-12-21","土","〇","〇"]
["2024-12-22","日"]
["2024-12-23","月"]
["2024-12-24","火"]
["2024-12-25","水"]
["2024-12-26","木"]
["2024-12-27","金","〇","〇"]
["2024-12-28","土","〇","〇"]
["2024-12-29","日","－","－","対象期間外（年末年始休暇）"]
["2024-12-30","月","－","－","対象期間外（年末年始休暇）"]
["2024-12-31","火","－","－","対象期間外（年末年始休暇）"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C39,\"〇\")+COUNTIF(C9:C39,\"◎\")+COUNTIF(C9:C39,\"天\")+COUNTIF(C9:C39,\"●\")","v":9},{"$f":"COUNTIF(D9:D39,\"〇\")+COUNTIF(D9:D39,\"◎\")+COUNTIF(D9:D39,\"天\")+COUNTIF(D9:D39,\"●\")","v":9}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C39,\"－\")","v":28},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D39,\"－\")","v":28}]
["閉所率",null,{"$f":"IF(C41<>0,C40/C41,\"対象外\")","v":0.32142857142857145},{"$f":"IF(D41<>0,D40/D41,\"対象外\")","v":0.32142857142857145},null,{"$f":"IF(D42=\"対象外\",\"対象外\",IF(D42>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"閉所率で達成"}]
["土日数",8,{"$f":"IF(D42<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":""}]
["土日率",{"$f":"IF(F42<>\"対象外\",IF(L4<0.285,L4,\"\"),\"\")","v":""},{"$f":"IF(B44<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":""},null,null,{"$f":"IF(L4<0.285,IF(F42=\"対象外\",\"\",IF(B44<0.285,IF(B43<=D40,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":""}]
[null,null,null,null,"達成の判定",{"$f":"IF(F42=\"対象外\",\"－\",IF(OR(F42=\"閉所率で達成\",F44=\"土日数で達成\"),\"◎\",\"×\"))","v":"◎"}]

{"sheet":"1月","index":10,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,2,42,4],[43,2,43,4],[6,5,7,5],[2,1,2,4],[1,0,1,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":31}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B39,\"土\")+COUNTIF(B9:B39,\"日\")","v":8}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.25806451612903225}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令7年1月"},null,null,null,null,null,null,"年",{"$f":"別紙１!W4+1","v":2025},{"$f":"DATE(I6,I7,1)","v":"2025-01-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",1]
[]
[{"$f":"DATE(I6,I7,1)","v":"2025-01-01"},{"$f":"TEXT(A9,\"aaa\")","v":"水"},"－","－","対象期間外（年末年始休暇）","祝日"]
[{"$f":"A9+1","v":"2025-01-02"},{"$f":"TEXT(A10,\"aaa\")","v":"木"},"－","－","対象期間外（年末年始休暇）",null,null,"凡例"]
[{"$f":"A10+1","v":"2025-01-03"},"金","－","－","対象期間外（年末年始休暇）",null,null,"閉所","〇"]
["2025-01-04","土","－","－","対象期間外（年末年始休暇）",null,null,"現場休息","●"]
["2025-01-05","日","〇","〇",null,null,null,"振替閉所","◎"]
["2025-01-06","月",null,null,null,null,null,"対象外","－"]
["2025-01-07","火",null,null,null,null,null,"雨天等","天"]
["2025-01-08","水"]
["2025-01-09","木"]
["2025-01-10","金"]
["2025-01-11","土","〇","〇"]
["2025-01-12","日","〇","〇"]
["2025-01-13","月","〇","〇",null,"祝日"]
["2025-01-14","火"]
["2025-01-15","水"]
["2025-01-16","木"]
["2025-01-17","金"]
["2025-01-18","土","〇","〇"]
["2025-01-19","日","〇","〇"]
["2025-01-20","月"]
["2025-01-21","火"]
["2025-01-22","水"]
["2025-01-23","木"]
["2025-01-24","金"]
["2025-01-25","土","〇","〇"]
["2025-01-26","日","〇","〇"]
["2025-01-27","月"]
["2025-01-28","火"]
["2025-01-29","水"]
["2025-01-30","木"]
["2025-01-31","金"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C39,\"〇\")+COUNTIF(C9:C39,\"◎\")+COUNTIF(C9:C39,\"天\")+COUNTIF(C9:C39,\"●\")","v":8},{"$f":"COUNTIF(D9:D39,\"〇\")+COUNTIF(D9:D39,\"◎\")+COUNTIF(D9:D39,\"天\")+COUNTIF(D9:D39,\"●\")","v":8}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C39,\"－\")","v":27},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D39,\"－\")","v":27}]
["閉所率",null,{"$f":"IF(C41<>0,C40/C41,\"対象外\")","v":0.29629629629629628},{"$f":"IF(D41<>0,D40/D41,\"対象外\")","v":0.29629629629629628},null,{"$f":"IF(D42=\"対象外\",\"対象外\",IF(D42>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"閉所率で達成"}]
["土日数",7,{"$f":"IF(D42<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":"※対象期間内の土日数を入力してください（手入力)"}]
["土日率",{"$f":"IF(F42<>\"対象外\",IF(L4<0.285,L4,\"\"),\"\")","v":0.25806451612903225},{"$f":"IF(B44<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":"※28.5%未満なので土日数で計算となります。"},null,null,{"$f":"IF(L4<0.285,IF(F42=\"対象外\",\"\",IF(B44<0.285,IF(B43<=D40,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":"土日数で達成"}]
[null,null,null,null,"達成の判定",{"$f":"IF(F42=\"対象外\",\"－\",IF(OR(F42=\"閉所率で達成\",F44=\"土日数で達成\"),\"◎\",\"×\"))","v":"◎"}]

{"sheet":"2月","index":11,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[40,2,40,4],[41,2,41,4],[6,5,7,5],[1,0,1,4],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[2,1,2,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":28}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B37,\"土\")+COUNTIF(B9:B37,\"日\")","v":9}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.32142857142857145}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令7年2月"},null,null,null,null,null,null,"年",{"$f":"'1月'!I6","v":2025},{"$f":"DATE(I6,I7,1)","v":"2025-02-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",2]
[]
[{"$f":"DATE(I6,I7,1)","v":"2025-02-01"},{"$f":"TEXT(A9,\"aaa\")","v":"土"},"〇","〇"]
[{"$f":"A9+1","v":"2025-02-02"},{"$f":"TEXT(A10,\"aaa\")","v":"日"},null,null,null,null,null,"リスト"]
[{"$f":"A10+1","v":"2025-02-03"},"月",null,null,null,null,null,"閉所","〇"]
["2025-02-04","火",null,null,null,null,null,"現場休息","●"]
["2025-02-05","水",null,null,null,null,null,"振替閉所","◎"]
["2025-02-06","木",null,null,null,null,null,"対象外","－"]
["2025-02-07","金","〇","〇",null,null,null,"雨天等","天"]
["2025-02-08","土","〇","〇"]
["2025-02-09","日"]
["2025-02-10","月"]
["2025-02-11","火",null,null,null,"祝日"]
["2025-02-12","水"]
["2025-02-13","木"]
["2025-02-14","金","〇",null,"残工事対応のため開所"]
["2025-02-15","土","〇","〇"]
["2025-02-16","日","〇","〇"]
["2025-02-17","月"]
["2025-02-18","火"]
["2025-02-19","水"]
["2025-02-20","木"]
["2025-02-21","金","〇",null,"残工事対応のため開所"]
["2025-02-22","土","〇","〇"]
["2025-02-23","日"]
["2025-02-24","月"]
["2025-02-25","火"]
["2025-02-26","水"]
["2025-02-27","木"]
["2025-02-28","金","〇","〇"]
[{"$f":"A36+1","v":"2025-03-01"},"土"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C37,\"〇\")+COUNTIF(C9:C37,\"◎\")+COUNTIF(C9:C37,\"天\")+COUNTIF(C9:C37,\"●\")","v":9},{"$f":"COUNTIF(D9:D37,\"〇\")+COUNTIF(D9:D37,\"◎\")+COUNTIF(D9:D37,\"天\")+COUNTIF(D9:D37,\"●\")","v":7}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C37,\"－\")","v":28},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D37,\"－\")","v":28}]
["閉所率",null,{"$f":"IF(C39<>0,C38/C39,\"対象外\")","v":0.32142857142857145},{"$f":"IF(D39<>0,D38/D39,\"対象外\")","v":0.25},null,{"$f":"IF(D40=\"対象外\",\"対象外\",IF(D40>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"閉所率未達成"}]
["土日数",9,{"$f":"IF(D40<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":""}]
["土日率",{"$f":"IF(F40<>\"対象外\",IF(L4<0.285,L4,\"\"),\"\")","v":""},{"$f":"IF(B42<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":""},null,null,{"$f":"IF(L4<0.285,IF(F40=\"対象外\",\"\",IF(B42<0.285,IF(B41<=D38,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":""}]
[null,null,null,null,"達成の判定",{"$f":"IF(F40=\"対象外\",\"－\",IF(OR(F40=\"閉所率で達成\",F42=\"土日数で達成\"),\"◎\",\"×\"))","v":"×"}]

{"sheet":"3月","index":12,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,2,42,4],[43,2,43,4],[6,5,7,5],[3,1,3,4],[4,1,4,4],[5,0,5,1],[1,0,1,4],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[2,1,2,4]]}
[]
["   現場閉所実績書(月別シート)",null,null,null,null,null,null,null,null,null,"月日数",{"$f":"DAY(EOMONTH(J6,0))","v":31}]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"},null,null,null,null,null,null,null,null,"土日数",{"$f":"COUNTIF(B9:B38,\"土\")+COUNTIF(B9:B38,\"日\")","v":10}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"},null,null,null,null,null,null,null,null,"土日率",{"$f":"L3/L2","v":0.32258064516129031}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令7年3月"},null,null,null,null,null,null,"年",{"$f":"'2月'!I6","v":2025},{"$f":"DATE(I6,I7,1)","v":"2025-03-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",3]
[]
[{"$f":"DATE(I6,I7,1)","v":"2025-03-01"},{"$f":"TEXT(A9,\"aaa\")","v":"土"},"〇",null,"残工事対応のため開所"]
[{"$f":"A9+1","v":"2025-03-02"},{"$f":"TEXT(A10,\"aaa\")","v":"日"},null,null,null,null,null,"凡例"]
[{"$f":"A10+1","v":"2025-03-03"},"月",null,null,null,null,null,"閉所","〇"]
["2025-03-04","火",null,null,null,null,null,"現場休息","●"]
["2025-03-05","水",null,null,null,null,null,"振替閉所","◎"]
["2025-03-06","木",null,null,null,null,null,"対象外","－"]
["2025-03-07","金","〇",null,"残工事対応のため開所",null,null,"雨天等","天"]
["2025-03-08","土","〇","〇"]
["2025-03-09","日","〇","〇"]
["2025-03-10","月","〇","〇"]
["2025-03-11","火"]
["2025-03-12","水"]
["2025-03-13","木"]
["2025-03-14","金","〇","〇"]
["2025-03-15","土","〇","〇","施工完了日"]
["2025-03-16","日","－","－"]
["2025-03-17","月","－","－"]
["2025-03-18","火","－","－"]
["2025-03-19","水","－","－"]
["2025-03-20","木","－","－",null,"祝日"]
["2025-03-21","金","－","－"]
["2025-03-22","土","－","－"]
["2025-03-23","日","－","－"]
["2025-03-24","月","－","－"]
["2025-03-25","火","－","－"]
["2025-03-26","水","－","－"]
["2025-03-27","木","－","－"]
["2025-03-28","金","－","－"]
["2025-03-29","土","－","－"]
["2025-03-30","日","－","－"]
["2025-03-31","月","－","－"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C39,\"〇\")+COUNTIF(C9:C39,\"◎\")+COUNTIF(C9:C39,\"天\")+COUNTIF(C9:C39,\"●\")","v":7},{"$f":"COUNTIF(D9:D39,\"〇\")+COUNTIF(D9:D39,\"◎\")+COUNTIF(D9:D39,\"天\")+COUNTIF(D9:D39,\"●\")","v":5}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C39,\"－\")","v":15},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D39,\"－\")","v":15}]
["閉所率",null,{"$f":"IF(C41<>0,C40/C41,\"対象外\")","v":0.46666666666666667},{"$f":"IF(D41<>0,D40/D41,\"対象外\")","v":0.33333333333333331},null,{"$f":"IF(D42=\"対象外\",\"対象外\",IF(D42>=28.5%,\"閉所率で達成\",\"閉所率未達成\"))","v":"閉所率で達成"}]
["土日数",5,{"$f":"IF(D42<>\"対象外\",IF(L4<0.285,\"※対象期間内の土日数を入力してください（手入力)\",\"\"),\"\")","v":""}]
["土日率",{"$f":"IF(L4<0.285,L4,\"\")","v":""},{"$f":"IF(B44<0.285,\"※28.5%未満なので土日数で計算となります。\",\"\")","v":""},null,null,{"$f":"IF(L4<0.285,IF(F42=\"対象外\",\"\",IF(B44<0.285,IF(B43<=D40,\"土日数で達成\",\"土日数未達成\"),\"\")),\"\")","v":""}]
[null,null,null,null,"達成の判定",{"$f":"IF(F42=\"対象外\",\"－\",IF(OR(F42=\"閉所率で達成\",F44=\"土日数で達成\"),\"◎\",\"×\"))","v":"◎"}]

{"sheet":"記載例1","index":13,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[6,5,7,5],[1,0,1,4],[3,1,3,4],[4,1,4,4],[5,0,5,1],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[2,1,2,4]]}
[]
["現場閉所実績書"]
["工事名：",{"$f":"別紙１!E6","v":"●●●●●●●●工事"}]
["受注者名：",{"$f":"別紙１!E7","v":"○○○○〇工業(株)"}]
["工　　期：",{"$f":"別紙１!E8","v":"令和７年４月17日～令和８年３月15日"},null,null,null,null,null,"年月入力欄"]
[{"$f":"TEXT(J6,\"gge\")&\"年\"&TEXT(J6,\"m\")&\"月\"","v":"令5年8月"},null,null,null,null,null,null,"年",2023,{"$f":"DATE(I6,I7,1)","v":"2023-08-01"}]
["月日","曜日","現場閉所\n計画日","現場閉所\n実施日","現場閉所計画と現場閉所実績に\n差異がある場合等に記載","祝祭日記入",null,"月",8]
[]
[{"$f":"DATE(I6,I7,1)","v":"2023-08-01"},{"$f":"TEXT(A9,\"aaa\")","v":"火"},"－","－"]
[{"$f":"A9+1","v":"2023-08-02"},{"$f":"TEXT(A10,\"aaa\")","v":"水"},"－","－",null,null,null,"凡例"]
[{"$f":"A10+1","v":"2023-08-03"},"木","－","－",null,null,null,"閉所","〇"]
["2023-08-04","金","－","－","契約着工日",null,null,"振替閉所","◎"]
["2023-08-05","土","－","－","対象期間外（現場施工着手前）",null,null,"対象外","－"]
["2023-08-06","日","－","－","　　　　　〃",null,null,"雨天等","天"]
["2023-08-07","月","－","－","　　　　　〃"]
["2023-08-08","火","－","－"]
["2023-08-09","水","－","－"]
["2023-08-10","木","－","－",null,"山の日"]
["2023-08-11","金","－","－","対象期間外（現場施工着手前）"]
["2023-08-12","土","－","－","夏季休暇"]
["2023-08-13","日","－","－","　 〃"]
["2023-08-14","月","－","－","　 〃"]
["2023-08-15","火","－","－"]
["2023-08-16","水","－","－"]
["2023-08-17","木",null,null,"現場施工着手日"]
["2023-08-18","金"]
["2023-08-19","土",null,"天","雨天により休工（監督職員に連絡済）"]
["2023-08-20","日"]
["2023-08-21","月"]
["2023-08-22","火","〇","〇"]
["2023-08-23","水","〇","〇"]
["2023-08-24","木"]
["2023-08-25","金"]
["2023-08-26","土"]
["2023-08-27","日",null,"◎","8月29日の振替休日"]
["2023-08-28","月"]
["2023-08-29","火","〇",null,"地元との協議により作業"]
["2023-08-30","水","〇","〇"]
["2023-08-31","木"]
["現場閉所日数",null,{"$f":"COUNTIF(C9:C39,\"〇\")+COUNTIF(C9:C39,\"◎\")+COUNTIF(C9:C39,\"天\")+COUNTIF(C9:C39,\"他\")","v":4},{"$f":"COUNTIF(D9:D39,\"〇\")+COUNTIF(D9:D39,\"◎\")+COUNTIF(D9:D39,\"天\")+COUNTIF(D9:D39,\"他\")","v":5}]
["対象期間",null,{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(C9:C39,\"－\")","v":15},{"$f":"DAY(EOMONTH(J6,0))-COUNTIF(D9:D39,\"－\")","v":15}]
["閉所率",null,{"$f":"C40/C41","v":0.26666666666666666},{"$f":"D40/D41","v":0.33333333333333331}]