{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["別紙１","参考様式"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"別紙１","index":0,"n_rows":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":false,"merged":[[53,8,54,8],[53,9,54,9],[53,10,54,10],[49,8,50,8],[49,9,50,9],[49,10,50,10],[51,8,52,8],[51,9,52,9],[51,10,52,10],[45,8,46,8],[45,9,46,9],[45,10,46,10],[47,8,48,8],[47,9,48,9],[47,10,48,10],[2,3,2,10],[3,3,3,9],[4,3,4,9],[5,3,5,5],[7,8,7,10],[9,10,10,10],[11,8,12,8],[11,9,12,9],[11,10,12,10],[13,8,14,8],[13,9,14,9],[13,10,14,10],[9,8,10,8],[9,9,10,9],[15,8,16,8],[15,9,16,9],[15,10,16,10],[17,8,18,8],[17,9,18,9],[17,10,18,10],[19,8,20,8],[19,9,20,9],[19,10,20,10],[21,8,22,8],[21,9,22,9],[21,10,22,10],[23,8,24,8],[23,9,24,9],[23,10,24,10],[25,8,26,8],[25,9,26,9],[25,10,26,10],[27,8,28,8],[27,9,28,9],[27,10,28,10],[29,1,29,7],[33,8,33,10],[31,8,31,10],[38,3,38,10],[39,3,39,9],[40,3,40,9],[41,3,41,5],[43,8,43,10],[55,8,56,8],[55,9,56,9],[55,10,56,10],[57,8,58,8],[57,9,58,9],[57,10,58,10],[59,8,60,8],[59,9,60,9],[59,10,60,10],[61,8,62,8],[61,9,62,9],[61,10,62,10],[69,8,69,10],[63,8,64,8],[63,9,64,9],[63,10,64,10],[65,1,65,7],[67,8,67,10]]}
[]
[null,"（参考）「週休２日取得率」、「休工割合」の算出方法 ①"]
[null,null,"工事名：","○○○○工事"]
[null,null,"工　期：","令和○年○月○日～令和○年○月○日"]
[null,null,"受注者：","○○建設"]
[null,null,"施工開始日：","2023-08-01"]
[]
[null,"　（□：工事実施日）",null,null,null,null,null,null,"週休２日取得率（工事成績評定：要領 第５条）　、　休工割合（経費の補正：要領 第６条）"]
[null,"日","月","火","水","木","金","土","日数","休工日数","備　　考"]
[null,{"$f":"D6-(WEEKDAY(D6)-1)","v":"2023-07-30"},{"$f":"+B10+1","v":"2023-07-31"},{"$f":"+C10+1","v":"2023-08-01"},"2023-08-02","2023-08-03","2023-08-04","2023-08-05",{"$f":"_xlfn.IFS(D11=\"施工開始日\",\"－\",E11=\"施工開始日\",\"－\",F11=\"施工開始日\",\"－\",G11=\"施工開始日\",\"－\",H11=\"施工開始日\",\"－\",B11=\"施工開始日\",COUNTIFS(B11:H11,\"<>対象外\",B11:H11,\"<>不稼働日\",B11:H11,\"<>夏季休暇\",B11:H11,\"<>年末年始休暇\"),C11=\"施工開始日\",COUNTIFS(B11:H11,\"<>対象外\",B11:H11,\"<>不稼働日\",B11:H11,\"<>夏季休暇\",B11:H11,\"<>年末年始休暇\"),B11=\"施工完了日\",\"－\",C11=\"施工完了日\",\"－\",D11=\"施工完了日\",\"－\",E11=\"施工完了日\",\"－\",F11=\"施工完了日\",\"－\",G11=\"施工完了日\",COUNTIFS(B11:H11,\"<>対象外\",B11:H11,\"<>不稼働日\",B11:H11,\"<>夏季休暇\",B11:H11,\"<>年末年始休暇\"),H11=\"施工完了日\",COUNTIFS(B11:H11,\"<>対象外\",B11:H11,\"<>不稼働日\",B11:H11,\"<>夏季休暇\",B11:H11,\"<>年末年始休暇\"))","v":"－"},{"$f":"IF(I10=\"－\",\"－\",COUNTIFS(B11:H11,\"*休工*\"))","v":"－"},"施工開始日が火～土曜日の場合、施工開始日を含む週を対象期間から除く。\nまた、施工開始日が月曜日の場合は、施工開始日を前日の日曜日とする。"]
[null,null,null,"施工開始日","□","□","□","休工"]
[null,{"$f":"+H10+1","v":"2023-08-06"},{"$f":"+B12+1","v":"2023-08-07"},{"$f":"+C12+1","v":"2023-08-08"},"2023-08-09","2023-08-10","2023-08-11","2023-08-12",{"$f":"+COUNTIFS(B13:H13,\"<>対象外\",B13:H13,\"<>不稼働日\",B13:H13,\"<>夏季休暇\",B13:H13,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B13:H13,\"*休工*\")","v":3}]
[null,"休工","□","□","□","□","休日休工","休工"]
[null,{"$f":"+H12+1","v":"2023-08-13"},{"$f":"+B14+1","v":"2023-08-14"},"2023-08-15","2023-08-16","2023-08-17","2023-08-18","2023-08-19",{"$f":"+COUNTIFS(B15:H15,\"<>対象外\",B15:H15,\"<>不稼働日\",B15:H15,\"<>夏季休暇\",B15:H15,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B15:H15,\"*休工*\")","v":2}]
[null,"□","□","振替休工","□","□","□","休工"]
[null,{"$f":"+H14+1","v":"2023-08-20"},{"$f":"+B16+1","v":"2023-08-21"},"2023-08-22","2023-08-23","2023-08-24","2023-08-25","2023-08-26",{"$f":"+COUNTIFS(B17:H17,\"<>対象外\",B17:H17,\"<>不稼働日\",B17:H17,\"<>夏季休暇\",B17:H17,\"<>年末年始休暇\")","v":4},{"$f":"+COUNTIFS(B17:H17,\"*休工*\")","v":1},"夏季休暇（３日間）は非対象期間とする。"]
[null,"休工","□","□","□","夏季休暇","夏季休暇","夏季休暇"]
[null,{"$f":"+H16+1","v":"2023-08-27"},{"$f":"+B18+1","v":"2023-08-28"},{"$f":"+C18+1","v":"2023-08-29"},"2023-08-30","2023-08-31","2023-09-01","2023-09-02",{"$f":"+COUNTIFS(B19:H19,\"<>対象外\",B19:H19,\"<>不稼働日\",B19:H19,\"<>夏季休暇\",B19:H19,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B19:H19,\"*休工*\")","v":1}]
[null,"□","□","□","□","□","□","休工"]
[null,{"$f":"H18+1","v":"2023-09-03"},{"$f":"+B20+1","v":"2023-09-04"},{"$f":"+C20+1","v":"2023-09-05"},"2023-09-06","2023-09-07","2023-09-08","2023-09-09",{"$f":"+COUNTIFS(B21:H21,\"<>対象外\",B21:H21,\"<>不稼働日\",B21:H21,\"<>夏季休暇\",B21:H21,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B21:H21,\"*休工*\")","v":4},"天候（降雨・積雪等）による休工は、休工としてカウントする。"]
[null,"休工","□","振替休工","□","天候休工","□","休工"]
[null,{"$f":"H20+1","v":"2023-09-10"},{"$f":"+B22+1","v":"2023-09-11"},{"$f":"+C22+1","v":"2023-09-12"},"2023-09-13","2023-09-14","2023-09-15","2023-09-16",{"$f":"+COUNTIFS(B23:H23,\"<>対象外\",B23:H23,\"<>不稼働日\",B23:H23,\"<>夏季休暇\",B23:H23,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B23:H23,\"*休工*\")","v":2},"天候（降雨・積雪等）による振替休工は、休工としてカウントする。"]
[null,"休工","□","□","□","□","天候休工","□"]
[null,{"$f":"H22+1","v":"2023-09-17"},{"$f":"+B24+1","v":"2023-09-18"},{"$f":"+C24+1","v":"2023-09-19"},"2023-09-20","2023-09-21","2023-09-22","2023-09-23",{"$f":"+COUNTIFS(B25:H25,\"<>対象外\",B25:H25,\"<>不稼働日\",B25:H25,\"<>夏季休暇\",B25:H25,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B25:H25,\"*休工*\")","v":3}]
[null,"休工","□","□","□","□","休日休工","休工"]
[null,{"$f":"H24+1","v":"2023-09-24"},{"$f":"+B26+1","v":"2023-09-25"},{"$f":"+C26+1","v":"2023-09-26"},"2023-09-27","2023-09-28","2023-09-29","2023-09-30",{"$f":"+COUNTIFS(B27:H27,\"<>対象外\",B27:H27,\"<>不稼働日\",B27:H27,\"<>夏季休暇\",B27:H27,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B27:H27,\"*休工*\")","v":2}]
[null,"休工","□","□","□","□","□","休工"]
[null,{"$f":"H26+1","v":"2023-10-01"},{"$f":"+B28+1","v":"2023-10-02"},"2023-10-03","2023-10-04","2023-10-05","2023-10-06","2023-10-07",{"$f":"_xlfn.IFS(D29=\"施工開始日\",\"－\",E29=\"施工開始日\",\"－\",F29=\"施工開始日\",\"－\",G29=\"施工開始日\",\"－\",H29=\"施工開始日\",\"－\",B29=\"施工開始日\",COUNTIFS(B29:H29,\"<>対象外\",B29:H29,\"<>不稼働日\",B29:H29,\"<>夏季休暇\",B29:H29,\"<>年末年始休暇\"),C29=\"施工開始日\",COUNTIFS(B29:H29,\"<>対象外\",B29:H29,\"<>不稼働日\",B29:H29,\"<>夏季休暇\",B29:H29,\"<>年末年始休暇\"),B29=\"施工完了日\",\"－\",C29=\"施工完了日\",\"－\",D29=\"施工完了日\",\"－\",E29=\"施工完了日\",\"－\",F29=\"施工完了日\",\"－\",G29=\"施工完了日\",COUNTIFS(B29:H29,\"<>対象外\",B29:H29,\"<>不稼働日\",B29:H29,\"<>夏季休暇\",B29:H29,\"<>年末年始休暇\"),H29=\"施工完了日\",COUNTIFS(B29:H29,\"<>対象外\",B29:H29,\"<>不稼働日\",B29:H29,\"<>夏季休暇\",B29:H29,\"<>年末年始休暇\"))","v":"－"},{"$f":"IF(I28=\"－\",\"－\",COUNTIFS(B29:H29,\"*休工*\"))","v":"－"},"施工完了日が日～木曜日の場合、施工完了日を含む週を対象期間から除く。\nまた、施工完了日が金曜日の場合は、施工完了日を翌日の土曜日とする。"]
[null,"休工","□","□","□","施工完了日"]
[null,"計",null,null,null,null,null,null,{"$f":"SUM(I10:I29)","v":53},{"$f":"SUM(J10:J29)","v":18},{"$f":"IF(H34>=28.5%,\"工事成績評価対象、経費補正対象(4週8休以上)\",IF(H34>=25%,\"工事成績評価対象外、経費補正対象(4週7休以上4週8休未満)\",IF(H34>=21.4%,\"工事成績評価対象外、経費補正対象(4週6休以上4週7休未満)\",\"工事成績評価対象外、経費補正対象外\")))","v":"工事成績評価対象、経費補正対象(4週8休以上)"}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(J30/I30,3)","v":0.33900000000000002}]
[null,"工事成績評価対象",null,{"$f":"+I30","v":53},"÷",{"$f":"+J30","v":18},"=",{"$f":"ROUNDDOWN(F32/D32,3)","v":0.33900000000000002},{"$f":"IF(H32>=28.5%,\"　評価対象\",\"　評価対象外\")","v":"　評価対象"}]
[]
[null,"経費補正対象",null,{"$f":"+I30","v":53},"÷",{"$f":"+J30","v":18},"=",{"$f":"ROUNDDOWN(F34/D34,3)","v":0.33900000000000002},{"$f":"IF(H34>=28.5%,\"　4週8休以上\",IF(H34>=25%,\"　4週7休以上4週8休未満\",IF(H34>=21.4%,\"　4週6休以上4週7休未満\",\"　4週6休未満(経費補正対象外)\")))","v":"　4週8休以上"}]
[]
[]
[]
[null,"（参考）「週休２日取得率」、「休工割合」の算出方法 ②"]
[null,null,"工事名：","○○○○工事"]
[null,null,"工　期：","令和○年○月○日～令和○年○月○日"]
[null,null,"受注者：","○○建設"]
[null,null,"施工開始日：","2023-11-28"]
[]
[null,"　（□：工事実施日）",null,null,null,null,null,null,"週休２日取得率（工事成績評定：要領 第５条）　、　休工割合（経費の補正：要領 第６条）"]
[null,"日","月","火","水","木","金","土","日数","休工日数","備　　考"]
[null,{"$f":"D42-(WEEKDAY(D42)-1)","v":"2023-11-26"},{"$f":"+B46+1","v":"2023-11-27"},{"$f":"+C46+1","v":"2023-11-28"},"2023-11-29","2023-11-30","2023-12-01","2023-12-02",{"$f":"_xlfn.IFS(D47=\"施工開始日\",\"－\",E47=\"施工開始日\",\"－\",F47=\"施工開始日\",\"－\",G47=\"施工開始日\",\"－\",H47=\"施工開始日\",\"－\",B47=\"施工開始日\",COUNTIFS(B47:H47,\"<>対象外\",B47:H47,\"<>不稼働日\",B47:H47,\"<>夏季休暇\",B47:H47,\"<>年末年始休暇\"),C47=\"施工開始日\",COUNTIFS(B47:H47,\"<>対象外\",B47:H47,\"<>不稼働日\",B47:H47,\"<>夏季休暇\",B47:H47,\"<>年末年始休暇\"),B47=\"施工完了日\",\"－\",C47=\"施工完了日\",\"－\",D47=\"施工完了日\",\"－\",E47=\"施工完了日\",\"－\",F47=\"施工完了日\",\"－\",G47=\"施工完了日\",COUNTIFS(B47:H47,\"<>対象外\",B47:H47,\"<>不稼働日\",B47:H47,\"<>夏季休暇\",B47:H47,\"<>年末年始休暇\"),H47=\"施工完了日\",COUNTIFS(B47:H47,\"<>対象外\",B47:H47,\"<>不稼働日\",B47:H47,\"<>夏季休暇\",B47:H47,\"<>年末年始休暇\"))","v":7},{"$f":"IF(I46=\"－\",\"－\",COUNTIFS(B47:H47,\"*休工*\"))","v":2},"施工開始日が火～土曜日の場合、施工開始日を含む週を対象期間から除く。\nまた、施工開始日が月曜日の場合は、施工開始日を前日の日曜日とする。"]
[null,"休工","施工開始日","□","□","□","□","休工"]
[null,{"$f":"+H46+1","v":"2023-12-03"},{"$f":"+B48+1","v":"2023-12-04"},{"$f":"+C48+1","v":"2023-12-05"},"2023-12-06","2023-12-07","2023-12-08","2023-12-09",{"$f":"+COUNTIFS(B49:H49,\"<>対象外\",B49:H49,\"<>不稼働日\",B49:H49,\"<>夏季休暇\",B49:H49,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B49:H49,\"*休工*\")","v":2}]
[null,"休工","□","□","□","□","□","休工"]
[null,{"$f":"+H48+1","v":"2023-12-10"},{"$f":"+B50+1","v":"2023-12-11"},"2023-12-12","2023-12-13","2023-12-14","2023-12-15","2023-12-16",{"$f":"+COUNTIFS(B51:H51,\"<>対象外\",B51:H51,\"<>不稼働日\",B51:H51,\"<>夏季休暇\",B51:H51,\"<>年末年始休暇\")","v":1},{"$f":"+COUNTIFS(B51:H51,\"*休工*\")","v":1},"天候（降雨・積雪等）以外の理由により休工する場合は、不稼働期間としてカウントしない。"]
[null,"休工","不稼働日","不稼働日","不稼働日","不稼働日","不稼働日","不稼働日"]
[null,{"$f":"+H50+1","v":"2023-12-17"},{"$f":"+B52+1","v":"2023-12-18"},"2023-12-19","2023-12-20","2023-12-21","2023-12-22","2023-12-23",{"$f":"+COUNTIFS(B53:H53,\"<>対象外\",B53:H53,\"<>不稼働日\",B53:H53,\"<>夏季休暇\",B53:H53,\"<>年末年始休暇\")","v":4},{"$f":"+COUNTIFS(B53:H53,\"*休工*\")","v":1},"天候（降雨・積雪等）以外の理由により休工する場合は、不稼働期間としてカウントしない。"]
[null,"不稼働日","不稼働日","不稼働日","□","□","□","休工"]
[null,{"$f":"+H52+1","v":"2023-12-24"},{"$f":"+B54+1","v":"2023-12-25"},{"$f":"+C54+1","v":"2023-12-26"},"2023-12-27","2023-12-28","2023-12-29","2023-12-30",{"$f":"+COUNTIFS(B55:H55,\"<>対象外\",B55:H55,\"<>不稼働日\",B55:H55,\"<>夏季休暇\",B55:H55,\"<>年末年始休暇\")","v":3},{"$f":"+COUNTIFS(B55:H55,\"*休工*\")","v":1},"年末年始休暇（６日間）は非対象期間とする。"]
[null,"休工","□","□","年末年始休暇","年末年始休暇","年末年始休暇","年末年始休暇"]
[null,{"$f":"H54+1","v":"2023-12-31"},{"$f":"+B56+1","v":"2024-01-01"},{"$f":"+C56+1","v":"2024-01-02"},"2024-01-03","2024-01-04","2024-01-05","2024-01-06",{"$f":"+COUNTIFS(B57:H57,\"<>対象外\",B57:H57,\"<>不稼働日\",B57:H57,\"<>夏季休暇\",B57:H57,\"<>年末年始休暇\")","v":5},{"$f":"+COUNTIFS(B57:H57,\"*休工*\")","v":2},"年末年始休暇として６日間を超える場合は、カウントする。"]
[null,"年末年始休暇","年末年始休暇","休工","休工","□","□","□"]
[null,{"$f":"H56+1","v":"2024-01-07"},{"$f":"+B58+1","v":"2024-01-08"},{"$f":"+C58+1","v":"2024-01-09"},"2024-01-10","2024-01-11","2024-01-12","2024-01-13",{"$f":"+COUNTIFS(B59:H59,\"<>対象外\",B59:H59,\"<>不稼働日\",B59:H59,\"<>夏季休暇\",B59:H59,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B59:H59,\"*休工*\")","v":2}]
[null,"休工","休日休工","□","□","□","□","□"]
[null,{"$f":"H58+1","v":"2024-01-14"},{"$f":"+B60+1","v":"2024-01-15"},{"$f":"+C60+1","v":"2024-01-16"},"2024-01-17","2024-01-18","2024-01-19","2024-01-20",{"$f":"+COUNTIFS(B61:H61,\"<>対象外\",B61:H61,\"<>不稼働日\",B61:H61,\"<>夏季休暇\",B61:H61,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B61:H61,\"*休工*\")","v":2},"天候（降雨・積雪等）による休工は、休工としてカウントする。"]
[null,"休工","□","□","□","天候休工","□","□"]
[null,{"$f":"H60+1","v":"2024-01-21"},{"$f":"+B62+1","v":"2024-01-22"},{"$f":"+C62+1","v":"2024-01-23"},"2024-01-24","2024-01-25","2024-01-26","2024-01-27",{"$f":"+COUNTIFS(B63:H63,\"<>対象外\",B63:H63,\"<>不稼働日\",B63:H63,\"<>夏季休暇\",B63:H63,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B63:H63,\"*休工*\")","v":0}]
[null,"□","□","□","□","□","□","□"]
[null,{"$f":"H62+1","v":"2024-01-28"},{"$f":"+B64+1","v":"2024-01-29"},"2024-01-30","2024-01-31","2024-02-01","2024-02-02","2024-02-03",{"$f":"_xlfn.IFS(D65=\"施工開始日\",\"－\",E65=\"施工開始日\",\"－\",F65=\"施工開始日\",\"－\",G65=\"施工開始日\",\"－\",H65=\"施工開始日\",\"－\",B65=\"施工開始日\",COUNTIFS(B65:H65,\"<>対象外\",B65:H65,\"<>不稼働日\",B65:H65,\"<>夏季休暇\",B65:H65,\"<>年末年始休暇\"),C65=\"施工開始日\",COUNTIFS(B65:H65,\"<>対象外\",B65:H65,\"<>不稼働日\",B65:H65,\"<>夏季休暇\",B65:H65,\"<>年末年始休暇\"),B65=\"施工完了日\",\"－\",C65=\"施工完了日\",\"－\",D65=\"施工完了日\",\"－\",E65=\"施工完了日\",\"－\",F65=\"施工完了日\",\"－\",G65=\"施工完了日\",COUNTIFS(B65:H65,\"<>対象外\",B65:H65,\"<>不稼働日\",B65:H65,\"<>夏季休暇\",B65:H65,\"<>年末年始休暇\"),H65=\"施工完了日\",COUNTIFS(B65:H65,\"<>対象外\",B65:H65,\"<>不稼働日\",B65:H65,\"<>夏季休暇\",B65:H65,\"<>年末年始休暇\"))","v":"－"},{"$f":"IF(I64=\"－\",\"－\",COUNTIFS(B65:H65,\"*休工*\"))","v":"－"},"施工完了日が日～木曜日の場合、施工完了日を含む週を対象期間から除く。\nまた、施工完了日が金曜日の場合は、施工完了日を翌日の土曜日とする。"]
[null,"休工","□","□","□","施工完了日"]
[null,"計",null,null,null,null,null,null,{"$f":"SUM(I46:I65)","v":48},{"$f":"SUM(J46:J65)","v":13},{"$f":"IF(H70>=28.5%,\"工事成績評価対象、経費補正対象(4週8休以上)\",IF(H70>=25%,\"工事成績評価対象外、経費補正対象(4週7休以上4週8休未満)\",IF(H70>=21.4%,\"工事成績評価対象外、経費補正対象(4週6休以上4週7休未満)\",\"工事成績評価対象外、経費補正対象外\")))","v":"工事成績評価対象外、経費補正対象(4週7休以上4週8休未満)"}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(J66/I66,3)","v":0.27}]
[null,"工事成績評価対象",null,{"$f":"+I66","v":48},"÷",{"$f":"+J66","v":13},"=",{"$f":"ROUNDDOWN(F68/D68,3)","v":0.27},{"$f":"IF(H68>=28.5%,\"　評価対象\",\"　評価対象外\")","v":"　評価対象外"}]
[]
[null,"経費補正対象",null,{"$f":"+I66","v":48},"÷",{"$f":"+J66","v":13},"=",{"$f":"ROUNDDOWN(F70/D70,3)","v":0.27},{"$f":"IF(H70>=28.5%,\"　4週8休以上\",IF(H70>=25%,\"　4週7休以上4週8休未満\",IF(H70>=21.4%,\"　4週6休以上4週7休未満\",\"　4週6休未満(経費補正対象外)\")))","v":"　4週7休以上4週8休未満"}]

{"sheet":"参考様式","index":1,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,8,20,10],[22,8,22,10],[12,8,13,8],[12,9,13,9],[12,10,13,10],[14,9,15,9],[14,10,15,10],[3,3,3,9],[2,3,2,9],[1,3,1,10],[4,3,4,5],[18,1,18,7],[14,8,15,8],[16,8,17,8],[16,9,17,9],[16,10,17,10],[6,8,6,10],[8,8,9,8],[8,9,9,9],[8,10,9,10],[10,8,11,8],[10,9,11,9],[10,10,11,10]]}
[]
[null,null,"工事名：","○○○○工事"]
[null,null,"工　期：","令和○年○月○日～令和○年○月○日"]
[null,null,"受注者：","○○建設"]
[null,null,"施工開始日：","2024-01-15"]
[]
[null,"　（□：工事実施日）",null,null,null,null,null,null,"週休２日取得率（工事成績評定：要領 第５条）　、　休工割合（経費の補正：要領 第６条）"]
[null,"日","月","火","水","木","金","土","日数","休工日数","備　　考"]
[null,{"$f":"D5-(WEEKDAY(D5)-1)","v":"2024-01-14"},{"$f":"+B9+1","v":"2024-01-15"},{"$f":"+C9+1","v":"2024-01-16"},"2024-01-17","2024-01-18","2024-01-19","2024-01-20",{"$f":"_xlfn.IFS(D10=\"施工開始日\",\"－\",E10=\"施工開始日\",\"－\",F10=\"施工開始日\",\"－\",G10=\"施工開始日\",\"－\",H10=\"施工開始日\",\"－\",B10=\"施工開始日\",COUNTIFS(B10:H10,\"<>対象外\",B10:H10,\"<>不稼働日\",B10:H10,\"<>夏季休暇\",B10:H10,\"<>年末年始休暇\"),C10=\"施工開始日\",COUNTIFS(B10:H10,\"<>対象外\",B10:H10,\"<>不稼働日\",B10:H10,\"<>夏季休暇\",B10:H10,\"<>年末年始休暇\"),B10=\"施工完了日\",\"－\",C10=\"施工完了日\",\"－\",D10=\"施工完了日\",\"－\",E10=\"施工完了日\",\"－\",F10=\"施工完了日\",\"－\",G10=\"施工完了日\",COUNTIFS(B10:H10,\"<>対象外\",B10:H10,\"<>不稼働日\",B10:H10,\"<>夏季休暇\",B10:H10,\"<>年末年始休暇\"),H10=\"施工完了日\",COUNTIFS(B10:H10,\"<>対象外\",B10:H10,\"<>不稼働日\",B10:H10,\"<>夏季休暇\",B10:H10,\"<>年末年始休暇\"))","v":7},{"$f":"IF(I9=\"－\",\"－\",COUNTIFS(B10:H10,\"*休工*\"))","v":2}]
[null,null,"施工開始日","□","休工","□","□","休工"]
[null,{"$f":"+H9+1","v":"2024-01-21"},{"$f":"+B11+1","v":"2024-01-22"},{"$f":"+C11+1","v":"2024-01-23"},"2024-01-24","2024-01-25","2024-01-26","2024-01-27",{"$f":"+COUNTIFS(B12:H12,\"<>対象外\",B12:H12,\"<>不稼働日\",B12:H12,\"<>夏季休暇\",B12:H12,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B12:H12,\"*休工*\")","v":3}]
[null,"休工","□","天候休工","□","□","□","休工"]
[null,{"$f":"+H11+1","v":"2024-01-28"},{"$f":"+B13+1","v":"2024-01-29"},"2024-01-30","2024-01-31","2024-02-01","2024-02-02","2024-02-03",{"$f":"+COUNTIFS(B14:H14,\"<>対象外\",B14:H14,\"<>不稼働日\",B14:H14,\"<>夏季休暇\",B14:H14,\"<>年末年始休暇\")","v":6},{"$f":"+COUNTIFS(B14:H14,\"*休工*\")","v":2}]
[null,"休工","□","対象外","□","天候休工","□","□"]
[null,{"$f":"+H13+1","v":"2024-02-04"},{"$f":"+B15+1","v":"2024-02-05"},"2024-02-06","2024-02-07","2024-02-08","2024-02-09","2024-02-10",{"$f":"+COUNTIFS(B16:H16,\"<>対象外\",B16:H16,\"<>不稼働日\",B16:H16,\"<>夏季休暇\",B16:H16,\"<>年末年始休暇\")","v":7},{"$f":"+COUNTIFS(B16:H16,\"*休工*\")","v":2}]
[null,"休工","□","□","□","□","□","休工"]
[null,{"$f":"H15+1","v":"2024-02-11"},{"$f":"+B17+1","v":"2024-02-12"},"2024-02-13","2024-02-14","2024-02-15","2024-02-16","2024-02-17",{"$f":"_xlfn.IFS(D18=\"施工開始日\",\"－\",E18=\"施工開始日\",\"－\",F18=\"施工開始日\",\"－\",G18=\"施工開始日\",\"－\",H18=\"施工開始日\",\"－\",B18=\"施工開始日\",COUNTIFS(B18:H18,\"<>対象外\",B18:H18,\"<>不稼働日\",B18:H18,\"<>夏季休暇\",B18:H18,\"<>年末年始休暇\"),C18=\"施工開始日\",COUNTIFS(B18:H18,\"<>対象外\",B18:H18,\"<>不稼働日\",B18:H18,\"<>夏季休暇\",B18:H18,\"<>年末年始休暇\"),B18=\"施工完了日\",\"－\",C18=\"施工完了日\",\"－\",D18=\"施工完了日\",\"－\",E18=\"施工完了日\",\"－\",F18=\"施工完了日\",\"－\",G18=\"施工完了日\",COUNTIFS(B18:H18,\"<>対象外\",B18:H18,\"<>不稼働日\",B18:H18,\"<>夏季休暇\",B18:H18,\"<>年末年始休暇\"),H18=\"施工完了日\",COUNTIFS(B18:H18,\"<>対象外\",B18:H18,\"<>不稼働日\",B18:H18,\"<>夏季休暇\",B18:H18,\"<>年末年始休暇\"))","v":7},{"$f":"_xlfn.IFS(I17=\"－\",\"－\",AND(I17<>\"－\",G18=\"施工完了日\"),COUNTIFS(B18:H18,\"*休工*\")+1,AND(I17<>\"－\",H18=\"施工完了日\"),COUNTIFS(B18:H18,\"*休工*\"))","v":2}]
[null,"休工","□","□","□","□","施工完了日"]
[null,"計",null,null,null,null,null,null,{"$f":"SUM(I9:I18)","v":34},{"$f":"SUM(J9:J18)","v":11},{"$f":"IF(H23>=28.5%,\"工事成績評価対象、経費補正対象(4週8休以上)\",IF(H23>=25%,\"工事成績評価対象外、経費補正対象(4週7休以上4週8休未満)\",IF(H23>=21.4%,\"工事成績評価対象外、経費補正対象(4週6休以上4週7休未満)\",\"工事成績評価対象外、経費補正対象外\")))","v":"工事成績評価対象、経費補正対象(4週8休以上)"}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(J19/I19,3)","v":0.32300000000000001}]
[null,"工事成績評価対象",null,{"$f":"+I19","v":34},"÷",{"$f":"+J19","v":11},"=",{"$f":"ROUNDDOWN(F21/D21,3)","v":0.32300000000000001},{"$f":"IF(H21>=28.5%,\"　評価対象\",\"　評価対象外\")","v":"　評価対象"}]
[]
[null,"経費補正対象",null,{"$f":"+I19","v":34},"÷",{"$f":"+J19","v":11},"=",{"$f":"ROUNDDOWN(F23/D23,3)","v":0.32300000000000001},{"$f":"IF(H23>=28.5%,\"　4週8休以上\",IF(H23>=25%,\"　4週7休以上4週8休未満\",IF(H23>=21.4%,\"　4週6休以上4週7休未満\",\"　4週6休未満(経費補正対象外)\")))","v":"　4週8休以上"}]