{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["①事業体特性の評価","②維持管理情報・業務の項目別評価と総合評価","総合評価","リンク","維持管理情報･総合評価グラフ"],"not_rendered":{"charts":7,"images":6,"macros":1,"external_links":0,"defined_names":4,"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":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,3,6,3],[5,4,6,4],[3,3,4,3],[5,0,6,0],[5,1,6,1],[5,2,6,2]]}
[]
[]
[]
["１．事業体特性の評価方法（レーダーチャートの作成）",null,null,"↓入力"]
[]
["番号","業務指標名（PI）","ＰＩ算定式","PI値","評価点\n（レーダーチャート）"]
[]
[2007,"配水管延長密度","配水管延長 /給水区域面積　（ｋｍ/ｋｍ２）",null,{"$f":"IF(D8<3.7,1,IF(D8<5.9,2,IF(D8<9.3,3,IF(D8<17.1,4,5))))","v":1}]
[2103,"経年化管路率","（法定耐用年数を超えた管路延長/管路総延長）×100　（％）",null,{"$f":"IF(D9=0,5,IF(D9<=3.4,4,IF(D9<=7.9,3,IF(D9<=14.6,2,1))))","v":5}]
[3002,"経常収支比率","[（営業収益+営業外収益）/（営業費用+営業外費用）］×100　　（％）",null,{"$f":"IF(D10<103.2,1,IF(D10<109,2,IF(D10<115.6,3,IF(D10<132.6,4,5))))","v":1}]
[2104,"管路の更新率","（更新された管路延長 /管路総延長）×100　（％）",null,{"$f":"IF(D11=0,1,IF(D11<0.39,2,IF(D11<0.72,3,IF(D11<1.21,4,5))))","v":1}]
[3018,"有収率","（有収水量/給水量）×100　（％）",null,{"$f":"IF(D12<81.1,1,IF(D12<87.1,2,IF(D12<92.1,3,IF(D12<97,4,5))))","v":1}]
[]
[]
[null,"　　　　　　　　　　　　　　　事業体特性の評価基準（ＰＩ－評価の関係）"]

{"sheet":"②維持管理情報・業務の項目別評価と総合評価","index":1,"n_rows":140,"n_cols":19,"rows_kept":140,"cut":false,"hidden":false,"merged":[[27,2,42,2],[27,4,31,4],[32,4,37,4],[38,4,42,4],[43,2,43,15],[111,2,111,15],[110,2,110,15],[139,2,139,15],[1,2,1,15],[2,7,2,10],[2,11,2,15],[3,2,17,2],[3,4,5,4],[6,4,8,4],[9,4,11,4],[12,4,14,4],[15,4,17,4],[25,2,25,15],[26,7,26,10],[26,11,26,15]]}
[]
[null,null,"維持管理情報に関する評価"]
[null,null,"項目の分類","NO",null,"項目","施設の\n有無　注5）","台帳や記録簿の\n有無",null,null,null,"台帳や記録簿の管理・活用状況（複数回答可）",null,null,null,null,null,"合計"]
[null,null,"維持管理情報",1,"図面及び台帳（1）","管路図面　注1）",null,"　無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している　注3）",1,{"$f":"SUMIF(リンク!F4,TRUE,I4)+SUMIF(リンク!G4,TRUE,K4)+SUMIF(リンク!H4,TRUE,M4)+SUMIF(リンク!I4,TRUE,O4)+SUMIF(リンク!J4,TRUE,Q4)","v":0}]
[null,null,null,2,null,"弁栓台帳　注2）",null,"　無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F5,TRUE,I5)+SUMIF(リンク!G5,TRUE,K5)+SUMIF(リンク!H5,TRUE,M5)+SUMIF(リンク!I5,TRUE,O5)+SUMIF(リンク!J5,TRUE,Q5)","v":0}]
[null,null,null,3,null,"管路台帳",null,"  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F6,TRUE,I6)+SUMIF(リンク!G6,TRUE,K6)+SUMIF(リンク!H6,TRUE,M6)+SUMIF(リンク!I6,TRUE,O6)+SUMIF(リンク!J6,TRUE,Q6)","v":0}]
[null,null,null,4,"図面及び台帳（2）","水管橋・橋梁添架管台帳","　　  無","  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F7,TRUE,I7)+SUMIF(リンク!G7,TRUE,K7)+SUMIF(リンク!H7,TRUE,M7)+SUMIF(リンク!I7,TRUE,O7)+SUMIF(リンク!J7,TRUE,Q7)","v":0}]
[null,null,null,5,null,"電気防食設備台帳","　　  無","  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F8,TRUE,I8)+SUMIF(リンク!G8,TRUE,K8)+SUMIF(リンク!H8,TRUE,M8)+SUMIF(リンク!I8,TRUE,O8)+SUMIF(リンク!J8,TRUE,Q8)","v":0}]
[null,null,null,6,null,"震災対策用貯水施設台帳","　　  無","  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F9,TRUE,I9)+SUMIF(リンク!G9,TRUE,K9)+SUMIF(リンク!H9,TRUE,M9)+SUMIF(リンク!I9,TRUE,O9)+SUMIF(リンク!J9,TRUE,Q9)","v":0}]
[null,null,null,7,"事故対応情報録","応急給水",null,"  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F10,TRUE,I10)+SUMIF(リンク!G10,TRUE,K10)+SUMIF(リンク!H10,TRUE,M10)+SUMIF(リンク!I10,TRUE,O10)+SUMIF(リンク!J10,TRUE,Q10)","v":0}]
[null,null,null,8,null,"備蓄資機材一覧",null,"  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F11,TRUE,I11)+SUMIF(リンク!G11,TRUE,K11)+SUMIF(リンク!H11,TRUE,M11)+SUMIF(リンク!I11,TRUE,O11)+SUMIF(リンク!J11,TRUE,Q11)","v":0}]
[null,null,null,9,null,"緊急輸送道路","      無","　無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F12,TRUE,I12)+SUMIF(リンク!G12,TRUE,K12)+SUMIF(リンク!H12,TRUE,M12)+SUMIF(リンク!I12,TRUE,O12)+SUMIF(リンク!J12,TRUE,Q12)","v":0}]
[null,null,null,10,"運転記録　注4）","水質調査記録",null,"  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F13,TRUE,I13)+SUMIF(リンク!G13,TRUE,K13)+SUMIF(リンク!H13,TRUE,M13)+SUMIF(リンク!I13,TRUE,O13)+SUMIF(リンク!J13,TRUE,Q13)","v":0}]
[null,null,null,11,null,"水量調査記録",null,"  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F14,TRUE,I14)+SUMIF(リンク!G14,TRUE,K14)+SUMIF(リンク!H14,TRUE,M14)+SUMIF(リンク!I14,TRUE,O14)+SUMIF(リンク!J14,TRUE,Q14)","v":0}]
[null,null,null,12,null,"水圧調査記録",null,"  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F15,TRUE,I15)+SUMIF(リンク!G15,TRUE,K15)+SUMIF(リンク!H15,TRUE,M15)+SUMIF(リンク!I15,TRUE,O15)+SUMIF(リンク!J15,TRUE,Q15)","v":0}]
[null,null,null,13,"保全記録","事故対応等の記録",null,"  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F16,TRUE,I16)+SUMIF(リンク!G16,TRUE,K16)+SUMIF(リンク!H16,TRUE,M16)+SUMIF(リンク!I16,TRUE,O16)+SUMIF(リンク!J16,TRUE,Q16)","v":0}]
[null,null,null,14,null,"日常及び定期点検の記録",null,"  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F17,TRUE,I17)+SUMIF(リンク!G17,TRUE,K17)+SUMIF(リンク!H17,TRUE,M17)+SUMIF(リンク!I17,TRUE,O17)+SUMIF(リンク!J17,TRUE,Q17)","v":0}]
[null,null,null,15,null,"詳細調査の記録",null,"  無",0,"　有",2,"　 電子化されている",1,"　　記録の保管、データ更新を実施",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F18,TRUE,I18)+SUMIF(リンク!G18,TRUE,K18)+SUMIF(リンク!H18,TRUE,M18)+SUMIF(リンク!I18,TRUE,O18)+SUMIF(リンク!J18,TRUE,Q18)","v":0},{"$f":"SUM(R4:R18)","v":0}]
[]
[null,null,"　注1）配管図、詳細図、工事完成図等の図面を示す。"]
[null,null,"　注2）水理、水質、事故・苦情、埋設環境、社会的情報、占用許可関係等の情報を記載した台帳を示す。一つでも当てはまる場合は、「あり」で回答。"]
[null,null,"　　　　　（例）マッピングシステムで、管路図があり、事故履歴が属性としてある場合は、「管路図面」「管路台帳」ともに「あり」で回答。"]
[null,null,"　注3）情報活用とは、収集したデータを点検・修繕計画や更新計画策定に活用するものである。"]
[null,null,"　注4）業務の実施状況の小分類で、該当するものが一つでもあればチェックする。"]
[]
[null,null,"維持管理業務に関する評価"]
[null,null,"項目の分類","NO",null,"項目","施設の\n有無　注5）","実施状況の有無",null,null,null,"記録簿の活用状況（複数回答可）",null,null,null,null,null,"合計"]
[null,null,"維持管理業務",1,"事故対応等","事故対応",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F19,TRUE,I28)+SUMIF(リンク!G19,TRUE,K28)+SUMIF(リンク!H19,TRUE,M28)+SUMIF(リンク!I19,TRUE,O28)+SUMIF(リンク!J19,TRUE,Q28)","v":0}]
[null,null,null,2,null,"修繕工事",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F20,TRUE,I29)+SUMIF(リンク!G20,TRUE,K29)+SUMIF(リンク!H20,TRUE,M29)+SUMIF(リンク!I20,TRUE,O29)+SUMIF(リンク!J20,TRUE,Q29)","v":0}]
[null,null,null,3,null,"応急給水",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F21,TRUE,I30)+SUMIF(リンク!G21,TRUE,K30)+SUMIF(リンク!H21,TRUE,M30)+SUMIF(リンク!I21,TRUE,O30)+SUMIF(リンク!J21,TRUE,Q30)","v":0}]
[null,null,null,4,null,"利用者対応",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F22,TRUE,I31)+SUMIF(リンク!G22,TRUE,K31)+SUMIF(リンク!H22,TRUE,M31)+SUMIF(リンク!I22,TRUE,O31)+SUMIF(リンク!J22,TRUE,Q31)","v":0}]
[null,null,null,5,null,"他工事立会",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F23,TRUE,I32)+SUMIF(リンク!G23,TRUE,K32)+SUMIF(リンク!H23,TRUE,M32)+SUMIF(リンク!I23,TRUE,O32)+SUMIF(リンク!J23,TRUE,Q32)","v":0}]
[null,null,null,6,"日常及び定期点検","弁栓類点検",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F24,TRUE,I33)+SUMIF(リンク!G24,TRUE,K33)+SUMIF(リンク!H24,TRUE,M33)+SUMIF(リンク!I24,TRUE,O33)+SUMIF(リンク!J24,TRUE,Q33)","v":0}]
[null,null,null,7,null,"弁室・弁きょう等点検",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F25,TRUE,I34)+SUMIF(リンク!G25,TRUE,K34)+SUMIF(リンク!H25,TRUE,M34)+SUMIF(リンク!I25,TRUE,O34)+SUMIF(リンク!J25,TRUE,Q34)","v":0}]
[null,null,null,8,null,"水管橋等点検","　　  無","　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F26,TRUE,I35)+SUMIF(リンク!G26,TRUE,K35)+SUMIF(リンク!H26,TRUE,M35)+SUMIF(リンク!I26,TRUE,O35)+SUMIF(リンク!J26,TRUE,Q35)","v":0}]
[null,null,null,9,null,"電気防食設備の点検","　　  無","　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F27,TRUE,I36)+SUMIF(リンク!G27,TRUE,K36)+SUMIF(リンク!H27,TRUE,M36)+SUMIF(リンク!I27,TRUE,O36)+SUMIF(リンク!J27,TRUE,Q36)","v":0}]
[null,null,null,10,null,"震災対策用貯水施設の点検","　　  無","　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F28,TRUE,I37)+SUMIF(リンク!G28,TRUE,K37)+SUMIF(リンク!H28,TRUE,M37)+SUMIF(リンク!I28,TRUE,O37)+SUMIF(リンク!J28,TRUE,Q37)","v":0}]
[null,null,null,11,null,"管路パトロール",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F29,TRUE,I38)+SUMIF(リンク!G29,TRUE,K38)+SUMIF(リンク!H29,TRUE,M38)+SUMIF(リンク!I29,TRUE,O38)+SUMIF(リンク!J29,TRUE,Q38)","v":0}]
[null,null,null,12,"詳細調査","漏水調査",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F30,TRUE,I39)+SUMIF(リンク!G30,TRUE,K39)+SUMIF(リンク!H30,TRUE,M39)+SUMIF(リンク!I30,TRUE,O39)+SUMIF(リンク!J30,TRUE,Q39)","v":0}]
[null,null,null,13,null,"水量・水圧・水質調査",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F31,TRUE,I40)+SUMIF(リンク!G31,TRUE,K40)+SUMIF(リンク!H31,TRUE,M40)+SUMIF(リンク!I31,TRUE,O40)+SUMIF(リンク!J31,TRUE,Q40)","v":0}]
[null,null,null,14,null,"洗浄作業　注6）",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F32,TRUE,I41)+SUMIF(リンク!G32,TRUE,K41)+SUMIF(リンク!H32,TRUE,M41)+SUMIF(リンク!I32,TRUE,O41)+SUMIF(リンク!J32,TRUE,Q41)","v":0}]
[null,null,null,15,null,"管体腐食度調査　注7）",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F33,TRUE,I42)+SUMIF(リンク!G33,TRUE,K42)+SUMIF(リンク!H33,TRUE,M42)+SUMIF(リンク!I33,TRUE,O42)+SUMIF(リンク!J33,TRUE,Q42)","v":0}]
[null,null,null,16,null,"管内調査",null,"　  無",0,"　有",2,"　 マニュアルあり",1,"　　管理記録を保管している",1,"　　情報活用している",1,{"$f":"SUMIF(リンク!F34,TRUE,I43)+SUMIF(リンク!G34,TRUE,K43)+SUMIF(リンク!H34,TRUE,M43)+SUMIF(リンク!I34,TRUE,O43)+SUMIF(リンク!J34,TRUE,Q43)","v":0},{"$f":"SUM(R28:R43)","v":0}]
[]
[null,null,"注5）該当する施設が無い場合のみチェックする。"]
[null,null,"注6）工事後の洗管や管内の夾雑物除去のための洗浄作業を示す。"]
[null,null,"注7）埋設環境調査において、土質調査もしくは、管体調査を示す。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"維持管理情報・業務の項目別評価と総合評価"]
[null,null,"事業体特性の評価"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"業務の実施状況"]

{"sheet":"総合評価","index":2,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":true,"merged":[[1,3,1,4],[2,1,16,1],[2,3,4,3],[5,3,7,3],[8,3,10,3],[11,3,13,3],[14,3,16,3],[37,1,37,6],[38,1,38,6],[17,1,17,6],[18,1,18,6],[20,3,20,4],[21,1,36,1],[21,3,25,3],[26,3,31,3],[32,3,36,3]]}
[]
[null,"項目の分類","NO","項目",null,"合計（a）","重要度（ｂ）\n※重み付け","評価\n（a）×（b）"]
[null,"維持管理情報",1,"図面及び台帳（1）","図面台帳",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R4","v":0},15,{"$f":"F3*G3","v":0}]
[null,null,2,null,"弁栓台帳",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R5","v":0},11,{"$f":"F4*G4","v":0}]
[null,null,3,null,"管路台帳",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R6","v":0},9,0]
[null,null,4,"図面及び台帳（2）","水管橋・橋梁添架管台帳",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R7","v":0},6,0]
[null,null,5,null,"電気防食設備台帳",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R8","v":0},4,0]
[null,null,6,null,"震災対策用貯水施設台帳",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R9","v":0},4,0]
[null,null,7,"事故対応情報録","応急給水",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R10","v":0},6,0]
[null,null,8,null,"備蓄資機材一覧",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R11","v":0},6,0]
[null,null,9,null,"緊急輸送道路",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R12","v":0},3,0]
[null,null,10,"運転記録","水質調査記録",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R13","v":0},6,0]
[null,null,11,null,"水量調査記録",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R14","v":0},5,0]
[null,null,12,null,"水圧調査記録",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R15","v":0},5,0]
[null,null,13,"保全記録","事故対応等の記録",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R16","v":0},8,0]
[null,null,14,null,"日常及び定期点検の記録",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R17","v":0},7,0]
[null,null,15,null,"詳細調査の記録",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R18","v":0},5,0]
[null,"合計（500点満点）",null,null,null,null,null,{"$f":"SUM(H3:H17)","v":0}]
[null,"総合評価点（d）＝（ｃ）/5（100点満点）",null,null,null,null,null,{"$f":"H18/5","v":0}]
[]
[null,"項目の分類","NO","項目",null,"合計（a）","重要度（ｂ）\n※重み付け","評価\n（a）×（b）"]
[null,"維持管理業務",1,"事故対応等","事故対応",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R28","v":0},13,{"$f":"F22*G22","v":0}]
[null,null,2,null,"修繕工事（漏水事故情報）",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R29","v":0},9,{"$f":"F23*G23","v":0}]
[null,null,3,null,"応急給水",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R30","v":0},9,0]
[null,null,4,null,"利用者対応",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R31","v":0},9,0]
[null,null,5,null,"他工事立会",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R32","v":0},5,0]
[null,null,6,"日常及び定期点検","弁栓類点検",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R33","v":0},10,0]
[null,null,7,null,"弁室・弁きょう等点検",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R34","v":0},5,0]
[null,null,8,null,"水管橋等点検",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R35","v":0},5,0]
[null,null,9,null,"電気防食設備の点検",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R36","v":0},5,0]
[null,null,10,null,"震災対策用貯水施設の点検",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R37","v":0},5,0]
[null,null,11,null,"管路パトロール",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R38","v":0},3,0]
[null,null,12,"詳細調査","漏水調査",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R39","v":0},7,0]
[null,null,13,null,"水量・水圧・水質調査",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R40","v":0},6,0]
[null,null,14,null,"洗浄作業",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R41","v":0},4,0]
[null,null,15,null,"管体腐食度調査",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R42","v":0},3,0]
[null,null,16,null,"管内調査",{"$f":"②維持管理情報・業務の項目別評価と総合評価!R43","v":0},2,0]
[null,"合計（500点満点）",null,null,null,null,null,{"$f":"SUM(H22:H37)","v":0}]
[null,"総合評価点（d）＝（ｃ）/5（100点満点）",null,null,null,null,null,{"$f":"H38/5","v":0}]

{"sheet":"リンク","index":3,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":true,"merged":[[2,3,2,4],[3,1,33,1],[3,3,5,3],[6,3,8,3],[9,3,11,3],[12,3,14,3],[15,3,17,3],[18,3,22,3],[23,3,28,3],[29,3,33,3]]}
[]
[null,null,null,null,null,"（1）","（2）","（3）","（4）","（5）"]
[null,"項目の分類","NO","項目"]
[null,"維持管理の取り組み状況の実態把握",1,"図面及び台帳（1）","図面台帳",{"$f":"IF(K4=1,TRUE,FALSE)","v":true},{"$f":"IF(K4=2,TRUE,FALSE)","v":false},false,false,false,1]
[null,null,2,null,"弁栓台帳",{"$f":"IF(K5=1,TRUE,FALSE)","v":true},{"$f":"IF(K5=2,TRUE,FALSE)","v":false},false,false,false,1]
[null,null,3,null,"管路台帳",true,false,false,false,false,1]
[null,null,4,"図面及び台帳（2）","水管橋・橋梁添架管台帳",true,false,false,false,false,1]
[null,null,5,null,"電気防食設備台帳",true,false,false,false,false,1]
[null,null,6,null,"震災対策用貯水施設台帳",true,false,false,false,false,1]
[null,null,7,"事故対応情報録","応急給水",true,false,false,false,false,1]
[null,null,8,null,"備蓄資機材一覧",true,false,false,false,false,1]
[null,null,9,null,"緊急輸送道路",true,false,false,false,false,1]
[null,null,10,"運転記録","水質調査記録",true,false,false,false,false,1]
[null,null,11,null,"水量調査記録",true,false,false,false,false,1]
[null,null,12,null,"水圧調査記録",true,false,false,false,false,1]
[null,null,13,"保全記録","事故対応等の記録",true,false,false,false,false,1]
[null,null,14,null,"日常及び定期点検の記録",true,false,false,false,false,1]
[null,null,15,null,"詳細調査の記録",true,false,false,false,false,1]
[null,null,16,"事故対応等","事故対応",true,false,false,false,false,1]
[null,null,17,null,"修繕工事（漏水事故情報）",true,false,false,false,false,1]
[null,null,18,null,"応急給水",true,false,false,false,false,1]
[null,null,19,null,"利用者対応",true,false,false,false,false,1]
[null,null,20,null,"他工事立会",true,false,false,false,false,1]
[null,null,21,"日常及び定期点検","弁栓類点検",true,false,false,false,false,1]
[null,null,22,null,"弁室・弁きょう等点検",true,false,false,false,false,1]
[null,null,23,null,"水管橋等点検",true,false,false,false,false,1]
[null,null,24,null,"電気防食設備の点検",true,false,false,false,false,1]
[null,null,25,null,"震災対策用貯水施設の点検",true,false,false,false,false,1]
[null,null,26,null,"管路パトロール",true,false,false,false,false,1]
[null,null,27,"詳細調査","漏水調査",true,false,false,false,false,1]
[null,null,28,null,"水量・水圧・水質調査",true,false,false,false,false,1]
[null,null,29,null,"洗浄作業",true,false,false,false,false,1]
[null,null,30,null,"管体腐食度調査",true,false,false,false,false,1]
[null,null,31,null,"管内調査",true,false,false,false,false,1]

{"sheet":"維持管理情報･総合評価グラフ","index":4,"n_rows":105,"n_cols":26,"rows_kept":105,"cut":false,"hidden":true,"merged":[[22,2,26,2],[3,2,5,2],[6,2,8,2],[9,2,11,2],[12,2,14,2],[15,2,17,2],[27,2,32,2],[33,2,37,2],[40,0,40,2],[41,0,42,1],[41,2,42,2],[63,3,64,3],[63,4,64,4],[65,0,69,1],[41,4,42,4],[43,0,45,1],[46,0,48,1],[49,0,51,1],[52,0,54,1],[55,0,57,1],[41,3,42,3],[70,0,75,1],[76,0,80,1],[62,0,62,2],[63,0,64,1],[63,2,64,2]]}
[]
[null,null,"表１．情報の管理状態"]
[null,null,"中分類","小分類","満点",null,"A ","B","C","D","E","F","G","H","L","O","M","R","I","N","P","Q","S","T","J","K"]
[null,null,"図面及び台帳 (1)","管路図面",5,null,5,5,4,5,5,5,5,5,5,5,5,4,5,5,4,5,5,3,5,5]
[null,null,null,"弁栓台帳",5,null,4,4,3,5,4,5,5,5,5,5,0,0,0,0,3,5,5,0,5,5]
[null,null,null,"管路台帳",5,null,5,5,4,5,5,5,5,5,5,5,4,0,5,4,0,0,5,3,5,5]
[null,null,"図面及び台帳 (2)","水管橋・橋梁添架管台帳",5,null,5,4,0,4,5,5,5,0,5,5,0,2,4,0,0,0,4,0,5,5]
[null,null,null,"電気防食設備台帳",5,null,5,0,0,2,5,5,3,2,5,null,0,0,null,null,null,0,null,0,5,2]
[null,null,null,"震災対策用貯水施設台帳",5,null,5,0,0,4,5,null,5,5,5,5,null,0,null,null,0,3,null,3,0]
[null,null,"事故対応情報","応急給水地点",5,null,4,5,0,5,4,5,5,4,3,4,0,3,0,0,3,3,4,5,3,3]
[null,null,null,"備蓄資機材一覧",5,null,5,5,5,5,4,5,4,5,5,5,0,4,3,3,3,3,4,4,4,4]
[null,null,null,"緊急輸送道路",5,null,5,5,0,4,4,4,3,0,2,0,0,0,0,0,null,null,null,0,null,3]
[null,null,"運転記録","水質調査記録",5,null,5,5,4,5,5,5,4,5,5,5,5,4,3,5,3,4,5,4,5,4]
[null,null,null,"水量調査記録",5,null,5,5,0,5,5,5,4,5,4,5,5,4,3,5,3,4,5,4,5,0]
[null,null,null,"水圧調査記録",5,null,5,5,4,5,5,5,4,3,5,5,5,4,3,5,0,4,5,4,5,0]
[null,null,"保全記録","事故対応等の記録",5,null,5,5,5,5,5,5,5,5,5,5,3,3,3,4,2,5,4,4,4,4]
[null,null,null,"日常及び定期点検の記録",5,null,5,5,3,5,5,5,5,5,5,5,3,3,3,0,2,4,4,4,4,4]
[null,null,null,"詳細調査の記録",5,null,5,5,4,5,5,5,5,5,5,5,4,4,2,4,2,4,5,4,5,5]
[null,null,null,null,{"$f":"SUM(E4:E18)","v":75},null,{"$f":"SUM(G4:G18)","v":73},63,36,69,71,69,67,59,{"$f":"SUM(O4:O18)","v":69},{"$f":"SUM(P4:P18)","v":64},{"$f":"SUM(Q4:Q18)","v":34},{"$f":"SUM(R4:R18)","v":35},{"$f":"SUM(S4:S18)","v":34},35,25,44,55,42,{"$f":"SUM(Y4:Y18)","v":60},{"$f":"SUM(Z4:Z18)","v":49}]
[]
[null,null,"表２．業務の実施状況"]
[null,null,"中分類","小分類","満点",null,"A ","B","C","D","E","F","G","H","L","O","M","R","I","N","P","Q","S","T","J","K"]
[null,null,"事故対応等","事故対応",5,null,5,5,5,5,5,5,5,2,5,5,3,4,5,3,3,4,4,4,5,5]
[null,null,null,"修繕工事",5,null,5,4,4,5,5,5,5,5,5,5,3,3,5,3,3,4,4,4,5,5]
[null,null,null,"応急給水",5,null,5,4,4,3,5,5,5,4,4,5,2,4,4,2,3,4,5,2,5,4]
[null,null,null,"利用者対応",5,null,5,3,2,5,4,4,4,2,2,4,2,3,2,3,2,4,4,3,0,0]
[null,null,null,"他工事立会",5,null,5,4,2,4,5,4,4,3,4,5,2,2,2,3,3,4,4,4,5,2]
[null,null,"日常及び定期点検","弁栓類点検",5,null,5,5,3,5,5,5,5,3,0,5,0,2,3,0,2,0,0,0,5,5]
[null,null,null,"弁室・弁きょう等点検",5,null,5,5,3,5,5,4,5,2,0,5,0,2,2,0,2,0,4,0,5,5]
[null,null,null,"水管橋等点検",5,null,5,5,3,5,5,5,5,4,0,5,0,3,4,0,0,0,4,0,5,3]
[null,null,null,"電気防食設備の点検",5,null,5,4,3,2,5,4,3,4,4,null,4,3,null,null,null,0,null,0,4,2]
[null,null,null,"震災対策用貯水施設の点検",5,null,5,5,0,5,5,null,5,5,2,5,null,0,null,null,0,3,null,4,0]
[null,null,null,"管路パトロール",5,null,5,5,3,4,5,5,5,3,0,5,0,3,0,0,0,0,4,3,5,4]
[null,null,"詳細調査","漏水調査",5,null,5,5,4,4,3,5,5,5,2,5,5,3,3,5,3,0,5,4,0,0]
[null,null,null,"水量・水圧・水質調査",5,null,5,4,3,5,5,4,4,4,4,4,0,3,3,3,3,3,4,4,4,4]
[null,null,null,"洗浄作業",5,null,5,5,3,5,5,4,4,3,3,5,0,0,0,0,3,0,4,2,4,4]
[null,null,null,"管体腐食度調査",5,null,5,4,0,5,5,5,4,4,3,0,0,0,0,0,0,3,0,0,0,5]
[null,null,null,"管内調査",5,null,5,0,0,0,5,4,3,0,0,0,0,0,0,0,0,0,0,0,4,0]
[null,null,null,null,{"$f":"SUM(E23:E38)","v":80},null,{"$f":"SUM(G23:G38)","v":80},67,42,67,77,68,71,53,38,63,21,35,33,22,27,29,46,34,56,48]
[]
["【重みづけ後の点数（情報の管理状態）】"]
["中分類",null,"小分類","重み付け\n100点満点","満点",null,"A ","B","C","D","E","F","G","H","L","O","M","R","I","N","P","Q","S","T","J","K"]
[null,null,null,null,null,null,"重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後","重み付け後"]
["図面及び台帳 (1)",null,"管路図面",15,{"$f":"D44*E4","v":75},null,{"$f":"G4*$D44","v":75},75,60,75,75,75,75,75,75,75,75,60,75,75,60,75,75,45,75,75]
[null,null,"弁栓台帳",11,{"$f":"D45*E5","v":55},null,44,44,33,55,44,55,55,55,55,55,0,0,0,0,33,55,55,0,55,55]
[null,null,"管路台帳",9,45,null,45,45,36,45,45,45,45,45,45,45,36,0,45,36,0,0,45,27,45,45]
["図面及び台帳 (2)",null,"水管橋・橋梁添架管台帳",6,30,null,30,24,0,24,30,30,30,0,30,30,0,12,24,0,0,0,24,0,30,30]
[null,null,"電気防食設備台帳",4,20,null,20,0,0,8,20,20,12,8,20,0,0,0,0,0,0,0,0,0,20,8]
[null,null,"震災対策用貯水施設台帳",4,20,null,20,0,0,16,20,0,20,20,20,20,0,0,0,0,0,12,0,12,0,0]
["事故対応情報",null,"応急給水地点",6,30,null,24,30,0,30,24,30,30,24,18,24,0,18,0,0,18,18,24,30,18,18]
[null,null,"備蓄資機材一覧",6,30,null,30,30,30,30,24,30,24,30,30,30,0,24,18,18,18,18,24,24,24,24]
[null,null,"緊急輸送道路",3,15,null,15,15,0,12,12,12,9,0,6,0,0,0,0,0,0,0,0,0,0,9]
["運転記録",null,"水質調査記録",6,30,null,30,30,24,30,30,30,24,30,30,30,30,24,18,30,18,24,30,24,30,24]
[null,null,"水量調査記録",5,25,null,25,25,0,25,25,25,20,25,20,25,25,20,15,25,15,20,25,20,25,0]
[null,null,"水圧調査記録",5,25,null,25,25,20,25,25,25,20,15,25,25,25,20,15,25,0,20,25,20,25,0]
["保全記録",null,"事故対応等の記録",8,40,null,40,40,40,40,40,40,40,40,40,40,24,24,24,32,16,{"$f":"V16*$D56","v":40},32,32,32,32]
[null,null,"日常及び定期点検の記録",7,35,null,{"$f":"G17*$D57","v":35},35,21,35,35,35,35,35,35,35,21,21,21,0,14,28,28,28,28,28]
[null,null,"詳細調査の記録",5,25,null,25,25,20,25,25,25,25,25,25,25,20,20,10,20,10,20,25,20,25,25]
[]
[null,null,null,{"$f":"SUM(D44:D58)","v":100},{"$f":"SUM(E44:E58)","v":500},null,{"$f":"SUM(G44:G58)","v":483},{"$f":"SUM(H44:H58)","v":443},284,475,474,477,464,427,{"$f":"SUM(O44:O58)","v":474},{"$f":"SUM(P44:P58)","v":459},{"$f":"SUM(Q44:Q58)","v":256},{"$f":"SUM(R44:R58)","v":243},265,261,202,330,412,282,{"$f":"SUM(Y44:Y58)","v":432},{"$f":"SUM(Z44:Z58)","v":373}]
[]
[]
["【重みづけ後の点数（業務の実施状況）】"]
["中分類",null,"小分類","重み付け\n100点満点","満点",null,"A ","B","C","D","E","F","G","H","L","O","M","R","I","N","P","Q","S","T","J","K"]
[null,null,null,null,null,null,"重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）","重み付け後\n（a'×b'）"]
["事故対応等",null,"事故対応",13,{"$f":"D66*E23","v":65},null,{"$f":"G23*$D66","v":65},65,65,65,65,65,65,26,65,65,39,52,65,39,39,52,52,52,65,65]
[null,null,"修繕工事",9,45,null,45,36,36,45,45,45,45,45,45,45,27,27,45,27,27,36,36,36,45,45]
[null,null,"応急給水",9,45,null,45,36,36,27,45,45,45,36,36,45,18,36,36,18,27,36,45,18,45,36]
[null,null,"利用者対応",9,45,null,45,27,18,45,36,36,36,18,18,36,18,27,18,27,18,36,36,27,0,0]
[null,null,"他工事立会",5,25,null,25,20,10,20,25,20,20,15,20,25,10,10,10,15,15,20,20,20,25,10]
["日常及び定期点検",null,"弁栓類点検",10,50,null,50,50,30,50,50,50,50,30,0,50,0,20,30,0,20,0,0,0,50,50]
[null,null,"弁室・弁きょう等点検",5,25,null,25,25,15,25,25,20,25,10,0,25,0,10,10,0,10,0,20,0,25,25]
[null,null,"水管橋等点検",5,25,null,25,25,15,25,25,25,25,20,0,25,0,15,20,0,0,0,20,0,25,15]
[null,null,"電気防食設備の点検",5,25,null,25,20,15,10,25,20,15,20,20,0,20,15,0,0,0,0,0,0,20,10]
[null,null,"震災対策用貯水施設の点検",5,25,null,25,25,0,25,25,0,25,25,10,25,0,0,0,0,0,15,0,20,0,0]
[null,null,"管路パトロール",3,15,null,15,15,9,12,15,15,15,9,0,15,0,9,0,0,0,0,12,9,15,12]
["詳細調査",null,"漏水調査",7,35,null,35,35,28,28,21,35,35,35,14,35,35,21,21,35,21,0,35,28,0,0]
[null,null,"水量・水圧・水質調査",6,30,null,30,24,18,30,30,24,24,24,24,24,0,18,18,18,18,{"$f":"V35*$D78","v":18},24,24,24,24]
[null,null,"洗浄作業",4,20,null,{"$f":"G36*$D79","v":20},20,12,20,20,16,16,12,12,20,0,0,0,0,12,0,16,8,16,16]
[null,null,"管体腐食度調査",3,15,null,15,12,0,15,15,15,12,12,9,0,0,0,0,0,0,9,0,0,0,15]
[null,null,"管内調査",2,10,null,10,0,0,0,10,8,6,0,0,0,0,0,0,0,0,0,0,0,8,0]
[]
[null,null,null,{"$f":"SUM(D66:D81)","v":100},{"$f":"SUM(E66:E81)","v":500},null,{"$f":"SUM(G66:G81)","v":500},{"$f":"SUM(H66:H81)","v":435},307,442,477,439,459,337,{"$f":"SUM(O66:O81)","v":273},{"$f":"SUM(P66:P81)","v":435},{"$f":"SUM(Q66:Q81)","v":167},{"$f":"SUM(R66:R81)","v":260},273,179,207,222,316,242,{"$f":"SUM(Y66:Y81)","v":363},{"$f":"SUM(Z66:Z81)","v":323}]
[]
[null,null,null,null,"【合計点】"]
[null,null,null,null,"重みづけなし",null,"A ","B","C","D","E","F","G","H","L","O","M","R","I","N","P","Q","S","T","J","K"]
[null,null,null,null,"情報",null,{"$f":"G19","v":73},{"$f":"H19","v":63},36,69,71,69,67,59,69,64,34,35,34,35,25,44,55,42,60,49]
[null,null,null,null,"業務",null,{"$f":"G39","v":80},{"$f":"H39","v":67},42,67,77,68,71,53,38,63,21,35,33,22,27,29,46,34,56,48]
[]
[null,null,null,null,"重みづけあり",null,"A ","B","C","D","E","F","G","H","L","O","M","R","I","N","P","Q","S","T","J","K"]
[null,null,null,null,"情報",null,{"$f":"G60","v":483},{"$f":"H60","v":443},284,475,474,477,464,427,474,459,256,243,265,261,202,330,412,282,432,373]
[null,null,null,null,"業務",null,{"$f":"G83","v":500},{"$f":"H83","v":435},307,442,477,439,459,337,273,435,167,260,273,179,207,222,316,242,363,323]
[]
[null,null,null,null,"【合計点】"]
[null,null,null,null,"重みづけなし（100点満点）",null,"A ","B","C","D","E","F","G","H","L","O","M","R","I","N","P","Q","S","T","J","K"]
[null,null,null,null,"情報",null,{"$f":"G87*100/$E$19","v":97.333333333333329},{"$f":"H87*100/$E$19","v":84},48,92,94.666666666666671,92,89.333333333333329,78.666666666666671,92,85.333333333333329,45.333333333333336,46.666666666666664,45.333333333333336,46.666666666666664,33.333333333333336,58.666666666666664,73.333333333333329,56,80,65.333333333333329]
[null,null,null,null,"業務",null,{"$f":"G88*100/$E$39","v":100},{"$f":"H88*100/$E$39","v":83.75},52.5,83.75,96.25,85,88.75,66.25,47.5,78.75,26.25,43.75,41.25,27.5,33.75,36.25,57.5,42.5,70,60]
[]
[]
[null,null,null,null,null,"あなたの総合評価","給水人口100万人以上の例",null,null,null,null,null,null,"給水人口25万人以上100万人未満の例",null,null,"給水人口10万人以上25万人未満の例",null,"給水人口10万人未満の例",null,null,null,null,null,"用水供給の例"]
[null,null,"給水人口100万人以上",null,"重みづけあり（100点満点）","あたなの総合評価","A ","B","C","D","E","F","G","H","L","O","M","R","I","N","P","Q","S","T","J","K"]
[null,null,"給水人口25万人以上～100万人未満",null,"情報の管理状態",{"$f":"総合評価!H19","v":0},96.6,88.6,56.8,95,94.8,95.4,92.8,85.4,94.8,91.8,51.2,48.6,53,52.2,40.4,66,82.4,56.4,86.4,74.599999999999994]
[null,null,"給水人口10万人以上～25万人未満",null,"業務の管理状態",{"$f":"総合評価!H39","v":0},100,87,61.4,88.4,95.4,87.8,91.8,67.400000000000006,54.6,87,33.4,52,54.6,35.799999999999997,41.4,44.4,63.2,48.4,72.599999999999994,64.599999999999994]
[null,null,"給水人口10万人未満"]
[null,null,"用水供給"]