{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["変更内容","入力フォーム","地図貼付","修繕依頼書","原紙"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"変更内容","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["変更内容"]
["Ver","日付","内容"]
[1.1000000000000001,"2023-08-23","変更周知・運用開始"]
[2.1,"2023-08-25","VBA印刷　修正"]
[2.2000000000000002,"2023-09-22","文言　修正"]
[2.2000000000000002,"2023-09-26","文言　修正"]
[3.1,"2023-12-18","公道撤去　→　出水不良　に変更(R6～）"]
[3.1,"2023-12-18","鉛管　→　PP１層交換　に変更(R6～）"]
[3.2,"2023-12-20","特記事項に　有無を記載"]
[3.3,"2024-01-17","止水栓不良　→　公道止水栓不良　に変更"]
[3.3,"2024-01-17","修繕内容その他欄　書式変更"]
[3.4,"2024-05-30","現地明示をなくし、すべて写真提出に変更"]

{"sheet":"入力フォーム","index":1,"n_rows":29,"n_cols":25,"rows_kept":29,"cut":false,"hidden":false,"merged":[[16,13,22,14],[7,14,7,15],[8,14,8,15],[9,14,9,15],[10,14,10,15],[11,14,11,15],[12,13,13,15],[5,13,6,13],[15,13,15,14],[5,14,6,15],[4,1,4,2],[4,4,4,6],[0,0,0,9],[11,5,11,7],[11,1,11,4],[15,0,17,0],[8,8,8,9],[9,8,9,9],[6,8,6,9],[2,1,2,4],[17,1,17,9],[23,0,24,0],[19,1,19,2],[15,1,15,9],[16,1,16,9],[24,2,24,3],[23,4,23,5],[24,4,24,5],[23,6,23,7],[24,6,24,7],[23,8,23,9],[24,8,24,9],[21,1,21,9],[26,4,26,9],[26,1,26,2],[13,10,14,12],[15,10,16,12],[6,1,6,7],[8,1,8,5],[9,1,9,5],[8,6,8,7],[9,6,9,7],[23,2,23,3],[24,10,24,12],[13,6,13,9],[13,1,13,4],[14,1,14,4]]}
["修繕依頼書　入力フォーム"]
[]
["依頼日"]
[]
["水道番号",null,null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"✔","確認ボタン押し後、下記内容確認し✔してください"]
["施工場所",null,null,null,null,null,null,null,null,null,"←号地等ある場合は記入"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"施工日希望日は、３週間後以降（希望日に添えない場合がある）を了承した",null,null,{"$f":"IF(N8=\"✔\",1,\"\")","v":""}]
["依頼業者",null,null,null,null,null,"連絡先",null,null,null,null,null,null,null,"修繕施工日決定後、他工事との調整は依頼業者が行うことを了承した",null,null,{"$f":"IF(N9=\"✔\",1,\"\")","v":""}]
["担当者",null,null,null,null,null,"携帯",null,null,null,null,null,null,null,"施工業者以外の理由で延期の場合は改めて日程を取り直すことを了承した",null,null,{"$f":"IF(N10=\"✔\",1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"施工箇所を現地明示(スプレー等）　した写真を添付した",null,null,{"$f":"IF(N11=\"✔\",1,\"\")","v":""}]
["修繕内容",null,null,null,null,null,null,null,{"$f":"IF(B12=\"その他\",\"←その他の場合は記入\",\"\")","v":""},null,null,null,null,null,"舗装本復旧が重複する場合は、依頼業者にて調整（水道局含）することを了承した",null,null,{"$f":"IF(N12=\"✔\",1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R13=5,\"印刷できます\",\"上記すべての項目を確認し✔してください\")","v":"上記すべての項目を確認し✔してください"},null,null,null,{"$f":"SUM(R8:R12)","v":0}]
["施工希望日",null,null,null,null,"～",null,null,null,null,"←希望がある場合は\n　 依頼日より３週間後以降"]
[null,{"$f":"IF(B14=\"\",\"\",IF((B14-B3)>20,\"\",\"↑↑ ２１日以上で入力 ↑↑\"))","v":""}]
["連絡事項",null,null,null,null,null,null,null,null,null,"←連絡事項がある場合は入力\n　 本復旧重複あり　等",null,null,{"$f":"IF(R13=5,\"印刷ボタン\",\"\")","v":""},null,"すべての項目が確認されると、印刷ボタンを押すことが出てきます"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B16=\"\",0,1)","v":0},{"$f":"K18+K19+K20","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B17=\"\",0,1)","v":0}]
["公道連絡",null,null,null,null,null,null,null,null,null,{"$f":"IF(B18=\"\",0,1)","v":0},null,null,null,null,null,null,"公道止水栓不良","あ　り","現地明示","必要","東部","A",1,"✔"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PP1層布設替","な　し","写真添付","不要","西部","B",2]
["修繕箇所","現地明示（スプレー等）した写真を添付してください",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"出水不良",null,null,null,null,"C",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"その他",null,null,null,null,"D",4]
["他工事の予定","ガス","NTT",null,"下水",null,"その他",null,{"$f":"IF(G25=\"あ　り\",\"その他あり\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"E",5]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G25=\"あ　り\",\"←他企業名を記入\",\"\")","v":""},null,null,null,{"$f":"IF(B25=\"あ　り\",1,0)","v":0},{"$f":"IF(C25=\"あ　り\",1,0)","v":0},{"$f":"IF(E25=\"あ　り\",1,0)","v":0},{"$f":"IF(G25=\"あ　り\",1,0)","v":0},{"$f":"SUM(N25:R25)","v":0},null,null,null,"F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G"]
["修繕跡舗装本復旧",null,null,null,{"$f":"IF(B27=\"必要\",\"他工事と重複の場合は調整してください\",IF(B27=\"不要\",\"水道局は仮復旧のみ。本復旧はしません\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I"]
["住宅地図",null,null,"-",null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J"]

{"sheet":"地図貼付","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["地図貼付"]
[null,"黄色が見えなくなるように（少し大きめの方がよい）"]

{"sheet":"修繕依頼書","index":3,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[42,23,43,23],[42,24,43,26],[40,12,40,14],[40,6,40,8],[40,9,40,11],[40,21,41,22],[42,21,43,22],[0,16,0,19],[2,0,2,26],[7,0,7,2],[8,0,8,2],[7,3,7,26],[8,3,8,26],[4,19,4,26],[9,0,9,2],[10,0,10,2],[10,7,10,13],[9,3,9,13],[9,18,9,26],[10,18,10,26],[12,0,12,2],[12,4,12,7],[12,10,12,13],[12,16,12,19],[14,0,17,2],[14,4,14,7],[14,16,14,19],[14,10,14,13],[15,3,15,5],[15,7,15,24],[12,22,12,24],[14,14,14,15],[14,21,14,25],[19,5,19,6],[22,5,22,6],[16,4,16,26],[17,4,17,26],[19,0,19,2],[22,0,22,2],[19,10,19,13],[22,21,22,26],[19,16,19,24],[32,0,32,1],[39,0,39,26],[40,0,43,2],[44,0,47,2],[44,3,44,26],[45,3,45,26],[46,3,46,26],[47,3,47,26],[40,23,41,23],[40,3,40,5],[40,24,41,26],[41,3,42,5],[41,6,42,20],[43,3,43,20],[40,15,40,17],[40,18,40,20],[25,0,25,2],[25,10,25,26],[28,0,28,1],[30,0,30,26],[28,14,28,15],[28,19,28,26],[25,5,25,6]]}
["(Ver.3.4)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"給水係受付",null,null,null,null,null,"No."]
[]
["修　　繕　　依　　頼　　書"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"依頼日",null,null,{"$f":"入力フォーム!B3","v":"00:00:00"}]
["明石市公営企業管理者　様"]
[]
["水道番号",null,null,{"$f":"入力フォーム!B5&\"    ―    \"&入力フォーム!E5","v":"    ―    "}]
["施工場所",null,null,{"$f":"入力フォーム!B7&IF(入力フォーム!I7=\"\",\"\",\"　　（\"&入力フォーム!I7&\"）\")","v":""}]
["依頼業者",null,null,{"$f":"入力フォーム!B9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"連絡先",null,{"$f":"入力フォーム!I9","v":"00:00:00"}]
["担当者",null,null,null,"氏　名",null,null,{"$f":"入力フォーム!B10","v":"00:00:00"},null,null,null,null,null,null,null,null,"携帯電話",null,{"$f":"入力フォーム!I10","v":0}]
[]
["修繕内容",null,null,null,"公道止水栓不良",null,null,null,null,null,"PP1層布設替",null,null,null,null,null,"出水不良",null,null,null,null,null,"その他"]
[]
["連絡事項",null,null,null,"施工希望日",null,null,null,null,null,{"$f":"IF(入力フォーム!B14=\"\",\"\",入力フォーム!B14)","v":""},null,null,null,null,null,{"$f":"IF(入力フォーム!G14=\"\",\"\",入力フォーム!G14)","v":""},null,null,null,null,{"$f":"IF(入力フォーム!B12=\"その他\",\"( \"&入力フォーム!F12&\" )\",\"(                     )\")","v":"(                     )"}]
[null,null,null,{"$f":"IF(入力フォーム!L18=0,\"なし\",\"有\")","v":"なし"},null,null,null,{"$f":"IF(入力フォーム!B16=\"\",\"\",入力フォーム!B16)","v":""}]
[null,null,null,null,{"$f":"IF(入力フォーム!B17=\"\",\"\",入力フォーム!B17)","v":""}]
[null,null,null,null,{"$f":"IF(入力フォーム!B18=\"\",\"\",入力フォーム!B18)","v":""}]
[]
["公道連絡",null,null,null,"有","・",null,"無",null,null,"修繕箇所.",null,null,null,null,null,"現地明示の写真を添付"]
[]
[]
["他工事の予定",null,null,null,"有","・",null,"無",null,null,"ガス",null,null,"NTT",null,null,"下水",null,null,"その他",null,{"$f":"IF(入力フォーム!G25=\"あ　り\",入力フォーム!I25,\"\")","v":""}]
[]
[]
["修繕跡舗装本復旧",null,null,null,"必要","・",null,"不要",null,null,{"$f":"IF(入力フォーム!B27=\"\",\"\",IF(入力フォーム!B27=\"必要\",\"他工事と復旧範囲が重複する場合は依頼業者にて調整すること\",\"水道局は仮舗装のみで完了とする。舗装本復旧は行いません\"))","v":""}]
[]
[]
["付近見取図",null,"※住宅地図に赤で図示",null,null,null,null,null,null,null,null,null,null,"東部","・",null,"西部",null,null,{"$f":"\"P　\"&入力フォーム!C29&\"　 － 　\"&入力フォーム!E29&\"　 －　 \"&入力フォーム!G29","v":"P　　 － 　　 －　 "}]
[]
[]
[]
["注意事項",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"確認"]
[null,"※１　施工希望日は、申請日から３週間後以降で記入（希望日に添えない場合があります）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(入力フォーム!N8=\"\",\"\",入力フォーム!N8)","v":""}]
[null,"※２　修繕施工日が決定次第、依頼業者にて他工事業者と日程調整を行うこと",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(入力フォーム!N9=\"\",\"\",入力フォーム!N9)","v":""}]
[null,"　　当日、他工事が原因で修繕ができない場合は、改めての日程調整となります（２週間後以降）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(入力フォーム!N10=\"\",\"\",入力フォーム!N10)","v":""}]
[null,"※3　施工箇所を現地明示（スプレー等）した写真添付を添付すること",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(入力フォーム!N11=\"\",\"\",入力フォーム!N11)","v":""}]
[null,"※４　舗装本復旧で他工事と重複する場合は、依頼業者にて業者間の調整を行うこと（水道局含）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(入力フォーム!N12=\"\",\"\",入力フォーム!N12)","v":""}]
[]
["　　-・-　　-・-　　-・-　　ここから下は記入しないでください（局・組合記入）　　-・-　　-・-　　-・-"]
["施工業者",null,null,"エスアンドエム",null,null,"奥乃組",null,null,"河合建設",null,null,"中原建設工業",null,null,"その他",null,null,null,null,null,"発注日",null,"/"]
[null,null,null,"（その他）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"依頼業者\n連絡日",null,"/"]
[]
["連絡事項",null,null,"舗装本復旧【必要】の場合は、施工業者にて復旧手配書を作成し提出すること"]

{"sheet":"原紙","index":4,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,0,8,2],[8,3,8,26],[0,16,0,19],[2,0,2,26],[4,19,4,26],[7,0,7,2],[7,3,7,26],[9,0,9,2],[9,3,9,13],[9,18,9,26],[10,0,10,2],[10,7,10,13],[10,18,10,26],[12,0,12,2],[12,4,12,7],[12,10,12,13],[12,16,12,19],[12,22,12,24],[14,21,14,25],[15,4,15,26],[16,4,16,26],[17,4,17,26],[19,0,19,2],[19,5,19,6],[19,10,19,13],[14,0,17,2],[14,4,14,7],[14,10,14,13],[14,14,14,15],[14,16,14,19],[19,16,19,24],[39,0,39,26],[22,0,22,2],[22,5,22,6],[22,21,22,26],[25,0,25,2],[25,5,25,6],[25,10,25,26],[28,0,28,1],[28,14,28,15],[28,19,28,26],[30,0,30,26],[32,0,32,1],[40,0,43,2],[40,3,40,5],[40,6,40,8],[40,9,40,11],[40,12,40,14],[40,18,40,20],[40,21,41,22],[40,23,41,23],[40,24,41,26],[41,3,42,5],[41,6,42,20],[42,21,43,22],[42,23,43,23],[42,24,43,26],[43,3,43,20],[40,15,40,17],[44,0,47,2],[44,3,44,26],[45,3,45,26],[46,3,46,26],[47,3,47,26]]}
["(Ver.3.4)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"給水係受付",null,null,null,null,null,"No."]
[]
["修　　繕　　依　　頼　　書"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"依頼日",null,null,"　　　年　　　月　　　日"]
["明石市公営企業管理者　様"]
[]
["水道番号",null,null," ― "]
["施工場所"]
["依頼業者",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"連絡先"]
["担当者",null,null,null,"氏　名",null,null,null,null,null,null,null,null,null,null,null,"携帯電話"]
[]
["修繕内容",null,null,null,"公道止水栓不良",null,null,null,null,null,"PP1層布設替",null,null,null,null,null,"出水不良",null,null,null,null,null,"その他"]
[]
["連絡事項",null,null,null,"施工希望日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(                   )"]
[null,null,null,null,"  有 ･ 無"]
[null,null,null,null,{"$f":"IF(入力フォーム!B17=\"\",\"\",入力フォーム!B17)","v":""}]
[null,null,null,null,{"$f":"IF(入力フォーム!B18=\"\",\"\",入力フォーム!B18)","v":""}]
[]
["公道連絡",null,null,null,"有","・",null,"無",null,null,"修繕箇所.",null,null,null,null,null,"現地明示の写真を添付"]
[]
[]
["他工事の予定",null,null,null,"有","・",null,"無",null,null,"ガス",null,null,"NTT",null,null,"下水",null,null,"その他",null,{"$f":"IF(入力フォーム!G25=\"あ　り\",入力フォーム!I25,\"\")","v":""}]
[]
[]
["修繕跡舗装本復旧",null,null,null,"必要","・",null,"不要",null,null,{"$f":"IF(入力フォーム!B27=\"\",\"\",IF(入力フォーム!B27=\"必要\",\"他工事と復旧範囲が重複する場合は依頼業者にて調整すること\",\"水道局は仮舗装のみで完了とする。舗装本復旧は行いません\"))","v":""}]
[]
[]
["付近見取図",null,"※住宅地図に赤で図示",null,null,null,null,null,null,null,null,null,null,"東部","・",null,"西部",null,null,"P　　　　 － 　　　　　 －　 "]
[]
[]
[]
["注意事項",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"確認"]
[null,"※１　施工希望日は、申請日から３週間後以降で記入（希望日に添えない場合があります）"]
[null,"※２　修繕施工日が決定次第、依頼業者にて他工事業者と日程調整を行うこと"]
[null,"　　当日、他工事が原因で修繕ができない場合は、改めての日程調整となります（２週間後以降）"]
[null,"※3　施工箇所を現地明示（スプレー等）した写真添付を添付すること"]
[null,"※４　舗装本復旧が他工事と重複する場合は、依頼業者にて業者間の調整を行うこと（水道局含）"]
[]
["　　-・-　　-・-　　-・-　　ここから下は記入しないでください（局・組合記入）　　-・-　　-・-　　-・-"]
["施工業者",null,null,"エスアンドエム",null,null,"奥乃組",null,null,"河合建設",null,null,"中原建設工業",null,null,"その他",null,null,null,null,null,"発注日"]
[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,"舗装本復旧【必要】の場合は、施工業者にて復旧手配書を作成し提出すること"]