{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["MES","MAIN","基本情報","入力情報(1)","入力情報(2)","メンテナンスレベル","プレビュー","マスター変更","参照表","取得金額計算","Master","Calc","経年故障率表","健全度","影響水量","損失額","修繕更新費用S1","修繕更新費用S2","修繕更新費用S3","修繕更新費用S4","修繕更新費用S5","出力まとめの表","系列の集計","設備費と運転費"],"not_rendered":{"charts":16,"images":46,"macros":1,"external_links":0,"defined_names":137,"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":"MES","index":0,"n_rows":283,"n_cols":12,"rows_kept":283,"cut":false,"hidden":false,"merged":[[1,11,1,13]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"メインメニューへ戻る"]
[]
[]
[]
[null,null,"★マクロを有効にしてファイルを開く方法★"]
[]
[]
[null,null,"　マクロを有効にしてファイルを開くことが出来ない場合、以下の設定をして下さい。。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"　【Excel2007の場合】"]
[]
[null,null,"<オフィス>ボタン（画面左上の丸いボタン)をクリックして、［Excelのオプション(I)］ボタンを"]
[null,null,"クリックします。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"画面左側の［セキュリティ センター］タグの［セキュリティ センターの設定(T)］を"]
[null,null,"クリックして下さい。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"画面左の［マクロの設定］タグを選択し、以下の項目をチェックして下さい。"]
[null,null,"・「すべてのマクロを有効にする（推奨しません。危険なコードが実行される可能性があります）(E)」"]
[null,null,"・「VBAプロジェクト オブジェクト モデルへのアクセスを信頼する(V)」"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"　【Excel2010/2013の場合】"]
[]
[]
[null,null,"メニューバーから　「ファイル」 の 「オプション」 をクリックします。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"『Excelのオプション』画面が表示されましたら、画面左側の「セキュリティ センター」を"]
[null,null,"クリックして、[セキュリティ センターの設定（Ｔ）]ボタンをクリックして下さい。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"『セキュリティ センター』画面が表示されましたら、画面左側の「メッセージ バー」をクリックして"]
[null,null,"「ActiveX コントロールやマクロなどのアクティブ コンテンツがブロックされた場合、すべての"]
[null,null,"アプリケーションにメッセージを表示する（Ｓ）｣をクリックして下さい。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"次に、画面左側の｢マクロの設定」をクリックして、「警告を表示してすべてのマクロを無効にする（Ｄ）」を"]
[null,null,"クリックして、［ＯＫ］ボタンで設定画面を閉じて下さい。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"以上の設定が完了しましたら本システムを開いた時に、画面上部に「セキュリティの警告」が表示され"]
[null,null,"ますので、[コンテンツの有効化]ボタンをクリックして下さい。"]

{"sheet":"MAIN","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[25,5,25,8],[27,5,27,8],[15,4,15,8],[11,4,11,8],[16,4,16,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Aqua10　共同研究第１研究委員会　"]
[]
[]
[]
[null,null,null,null,"作成年月：平成２３年10月　"]
[null,null,null,null,"改　　　訂：平成２６年 ３月　"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"※必ずマクロを有効にして作業してください。"]
[]
[null,null,null,null,null,"マクロを有効にするには．．．"]
[]
[]
[null,null,null,"本シミュレータを使って得られた結果について、著作者は一切の責任を負いません。"]
[null,null,null,"本シミュレータの改変、再配布を禁じます。"]

{"sheet":"基本情報","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[[9,6,9,8],[11,6,11,8],[12,6,12,8],[13,6,13,8]]}
[]
[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,"連絡先"]

{"sheet":"入力情報(1)","index":3,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":true,"merged":[[37,4,37,12],[32,7,32,8],[34,7,34,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[31,7,31,8],[33,7,33,8],[33,5,33,6],[29,7,29,8],[21,6,21,8],[22,7,22,8],[24,7,24,8],[23,7,23,8],[30,7,30,8],[29,5,29,6],[30,5,30,6],[25,7,25,8]]}
[]
[null,null,null,null,null,null,"入力情報（１）"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Ⅰ.浄水場の情報"]
[]
[null,null,null,null,null,null,null,null,"※：入力必須項目"]
[null,null,null,null,"1.","浄水場名"]
[null,null,null,"※","2.","現在の浄水量（日最大）"]
[null,null,null,null,null,"更新する場合の浄水量",null,{"$f":"IF('入力情報(2)'!H6<>\"\",'入力情報(2)'!H6,\"\")","v":""},null," 入力は次画面『入力情報(２)』にて行って下さい"]
[null,null,null,"※","3.","現在の給水人口"]
[null,null,null,"※","4.","給水原価"]
[null,null,null,null,"5.","原水種類"]
[null,null,null,"※","6.","浄水フロー"]
[null,null,null,"※","7.","粉末炭の有無"]
[null,null,null,null,null,"粉末炭平均注入率"]
[null,null,null,null,null,"粉末炭注入日数"]
[null,null,null,"※","8.","主要設備の最小系列数"]
[null,null,null,null,"9.","その系列名称"]
[null,null,null,null,null,"その他内容"]
[null,null,null,null,"10.","メンテナンスレベル",null,{"$f":"+メンテナンスレベル!G29","v":0}]
[]
[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,"※","11.","建築構造物",null,null,null,"千円"]
[null,null,null,"※","12.","土木構造物",null,null,null,"千円"]
[null,null,null,"※","13.","電気設備",null,null,null,"千円"]
[null,null,null,"※","14.","機械設備",null,null,null,"千円"]
[null,null,null,"※","15.","計装設備",null,null,null,"千円"]

{"sheet":"入力情報(2)","index":4,"n_rows":41,"n_cols":20,"rows_kept":41,"cut":false,"hidden":true,"merged":[[41,5,41,8],[36,0,36,2],[37,0,37,2],[39,0,39,2],[18,2,18,5],[40,0,40,2],[38,0,38,2],[19,2,21,3],[29,4,29,9],[19,8,19,9],[27,5,27,6],[6,6,6,7],[40,5,40,8],[36,5,36,8],[37,5,37,8],[38,5,38,8],[39,5,39,8],[21,8,21,9],[25,6,25,7],[17,8,17,9],[18,8,18,9],[20,8,20,9],[26,5,26,6]]}
[]
[null,null,null,null,null,null,"入力情報（２）"]
[]
[]
[null,null,null,"Ⅲ.浄水量の情報"]
[null,null,null,null,"16.","更新する場合の浄水量"]
[]
[null,null,null,"Ⅳ.推奨浄水プロセスの情報"]
[null,null,null,null,null,null,"原水レベル","原水レベル","浄水レベル"]
[null,null,null,null,null,null,"現状の原水水質","将来予想される原水水質","要求される浄水水質"]
[null,null,null,null,"17.","濁度",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(G11<>\"\",G12<>\"\",G13<>\"\",G14<>\"\"),1,0)","v":0}]
[null,null,null,null,"18.","TOC",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H11<>\"\",H12<>\"\",H13<>\"\",H14<>\"\"),1,0)","v":0}]
[null,null,null,null,"19.","カビ臭",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I11<>\"\",I12<>\"\",I13<>\"\",I14<>\"\"),1,0)","v":0}]
[null,null,null,null,"20.","THMFP"]
[null,null,null,null,"※「現状の原水水質」、「将来予想される原水水質」の”どちらか一方”もしくは”両方”入力して下さい。"]
[]
[null,null,null,null,"プロセス選定"]
[null,null,null,null,null,null,"原水レベル","浄水レベル","推奨プロセス"]
[null,null,"濁度",null,null,null,{"$f":"IF(ISERROR(Calc!D12),\"\",Calc!D12)","v":""},{"$f":"IF(ISERROR(Calc!E12),\"\",Calc!E12)","v":""},{"$f":"IF(ISERROR(Calc!F12),\"\",Calc!F12)","v":""}]
[null,null,"有機物",null,null,"TOC",{"$f":"IF(ISERROR(Calc!D13),\"\",Calc!D13)","v":""},{"$f":"IF(ISERROR(Calc!E13),\"\",Calc!E13)","v":""},{"$f":"IF(ISERROR(Calc!F13),\"\",Calc!F13)","v":""}]
[null,null,null,null,null,"カビ臭",{"$f":"IF(ISERROR(Calc!D14),\"\",Calc!D14)","v":""},{"$f":"IF(ISERROR(Calc!E14),\"\",Calc!E14)","v":""},{"$f":"IF(ISERROR(Calc!F14),\"\",Calc!F14)","v":""}]
[null,null,null,null,null,"THM",{"$f":"IF(ISERROR(Calc!D15),\"\",Calc!D15)","v":""},{"$f":"IF(ISERROR(Calc!E15),\"\",Calc!E15)","v":""},{"$f":"IF(ISERROR(Calc!F15),\"\",Calc!F15)","v":""}]
[]
[]
[null,null,null,null,"希望フロー",null,"※「推奨プロセス」を参考に入力下さい。"]
[null,null,null,null,"21.","希望フロー"]
[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,"シナリオ１\n 更新しない場合（修繕のみで対応）",null,null,null,null,null,null,null,null,null,null,null,null,null,true]
["■｢2.現在の浄水量｣ 又は ｢6.浄水\r\n　 フロー｣が未入力",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["■｢2.現在の浄水量｣ 又は ｢6.浄水\r\n　 フロー｣が未入力",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["■｢2.現在の浄水量｣ 又は ｢6.浄水\r\n　 フロー｣が未入力",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["■｢2.現在の浄水量｣ 又は ｢6.浄水\r\n　 フロー｣が未入力",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"メンテナンスレベル","index":5,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":true,"merged":[[28,6,28,7],[20,2,23,2],[20,7,23,7],[23,4,23,5],[24,2,27,2],[24,7,27,7],[12,2,15,2],[12,4,12,5],[12,7,15,7],[16,2,19,2],[16,7,19,7],[0,2,1,7],[3,3,3,5],[4,2,7,2],[4,7,7,7],[8,2,11,2],[8,7,11,7],[9,4,9,5]]}
[null,null,"メンテナンスレベルスコア評価基準"]
[]
[null,null,"最も近いと思われる評価レベルをチェックして下さい。全ての評価項目をチェックしないと、評価ポイントは有効となりません。"]
[null,null,"評価項目","評価レベル",null,null,"score","スコア"]
[null,null,"技術スタッフの充実度",null,"維持管理を行うための技術スタッフが必要十分数確保されている",null,100,{"$f":"IF(O5=1,100,IF(O5=2,80,IF(O5=3,40,IF(O5=4,20,0))))","v":0}]
[null,null,null,null,"維持管理を行うための技術スタッフがある程度確保されている",null,80]
[null,null,null,null,"維持管理を行うための技術スタッフが十分ではない。",null,40]
[null,null,null,null,"維持管理を行うための技術スタッフが明らかに不足している。",null,20]
[null,null,"予防保全への取り組み",null,"故障が発生する前に部品交換やオーバーホール等の必要な対応を行っている。",null,100,{"$f":"IF(O9=1,100,IF(O9=2,80,IF(O9=3,40,IF(O9=4,20,0))))","v":0}]
[null,null,null,null,"どちらかというと，故障が発生する前に部品交換やオーバーホール等の必要な対応を行っている。",null,80]
[null,null,null,null,"事故や故障が発生してからの対応がほとんどである。",null,40]
[null,null,null,null,"いつも事故や故障が発生してから対応している。対応が遅れる場合もある。",null,20]
[null,null,"マニュアルの充実度",null,"施設点検等に必要なマニュアルやチェックシートが充実している。また，内容も適宜更新されている。",null,100,{"$f":"IF(O13=1,100,IF(O13=2,80,IF(O13=3,40,IF(O13=4,20,0))))","v":0}]
[null,null,null,null,"施設点検等に必要なマニュアルやチェックシートがあるが，見直しを行う必要を感じている。",null,80]
[null,null,null,null,"施設点検等に必要なマニュアルを作成中，あるいは作成する必要性を認識している。",null,40]
[null,null,null,null,"施設点検等に必要なマニュアルがない。どのように作成したらよいかわからない。",null,20]
[null,null,"点検・修繕履歴の管理",null,"点検・修繕履歴を適切に管理し，過去の履歴から将来の施設整備計画を策定している。",null,100,{"$f":"IF(O17=1,100,IF(O17=2,80,IF(O17=3,40,IF(O17=4,20,0))))","v":0}]
[null,null,null,null,"点検・修繕履歴を管理しているが，管理面での課題もある。",null,80]
[null,null,null,null,"点検・修繕履歴をある程度は管理しているが，過去の履歴で逸散してしまったものも多い。",null,40]
[null,null,null,null,"点検・修繕履歴を適切を管理していない。過去の履歴もほとんどが逸散している。",null,20]
[null,null,"更新・修繕等の状況",null,"必要な修繕が確実に行われ，独自の基準に基づき施設が適切に更新されている。",null,100,{"$f":"IF(O21=1,100,IF(O21=2,80,IF(O21=3,40,IF(O21=4,20,0))))","v":0}]
[null,null,null,null,"必要に応じて修繕が行われ，施設更新もある程度実施されている。",null,80]
[null,null,null,null,"必要最低限の修繕が行われ，施設更新の明確な基準もない。",null,40]
[null,null,null,null,"必要な修繕も先送りされることが多く，法定耐用年数を大きく超えて施設運用がなされている。",null,20]
[null,null,"更新・修繕等に必要な予算",null,"更新・修繕等に必要な予算が確実に認められている。",null,100,{"$f":"IF(O25=1,100,IF(O25=2,80,IF(O25=3,40,IF(O25=4,20,0))))","v":0}]
[null,null,null,null,"更新・修繕等に必要な予算はほぼ認められている。",null,80]
[null,null,null,null,"更新・修繕に必要な予算は最低限度認められている。",null,40]
[null,null,null,null,"更新・修繕等に必要な予算がほとんど認められていない。",null,20]
[null,null,null,null,null,"評価ポイント",{"$f":"SUM(H5:H28)","v":0}]

{"sheet":"プレビュー","index":6,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":true,"merged":[[28,7,28,8],[45,6,45,7],[65,5,65,8],[61,5,61,8],[62,5,62,8],[63,5,63,8],[64,5,64,8],[71,1,71,12],[21,7,21,8],[18,6,18,8],[19,7,19,8],[25,7,25,8],[20,7,20,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[54,6,54,7],[26,7,26,8],[60,6,60,7],[30,7,30,8],[29,7,29,8],[27,7,27,8],[43,6,43,7]]}
[]
[]
[]
[]
[null,null,"入力データの確認 及び シミュレート実行"]
[]
[null,null,null,"　基本情報"]
[]
[null,null,null,null,null,"作成日",{"$f":"基本情報!G9","v":"00:00:00"}]
[null,null,null,null,null,"事業体名",{"$f":"基本情報!G10","v":0}]
[null,null,null,null,null,"所在地",{"$f":"IF(基本情報!G11<>\"\",\"〒\"&基本情報!G11,\"\")&\"　\"&基本情報!I11&基本情報!G12:I12","v":"　"}]
[null,null,null,null,null,"記入者",{"$f":"基本情報!G13","v":0}]
[null,null,null,null,null,"所属",{"$f":"基本情報!G14","v":0}]
[null,null,null,null,null,"連絡先",{"$f":"基本情報!G15","v":0}]
[]
[]
[null,null,null,"Ⅰ.浄水場の情報"]
[]
[null,null,null,null,"1.","浄水場名",{"$f":"'入力情報(1)'!G22","v":0}]
[null,null,null,null,"2.","現在の浄水量（日最大）",null,{"$f":"'入力情報(1)'!H23","v":0},null,"m3/d"]
[null,null,null,null,"3.","現在の給水人口",null,{"$f":"'入力情報(1)'!H25","v":0},null,"人"]
[null,null,null,null,"4.","給水原価",null,{"$f":"'入力情報(1)'!H26","v":0},null,"円/ｍ3"]
[null,null,null,null,"5.","原水種類",null,{"$f":"'入力情報(1)'!H27","v":0}]
[null,null,null,null,"6.","浄水フロー",null,{"$f":"'入力情報(1)'!H28","v":0}]
[null,null,null,null,"7.","粉末炭の有無",null,{"$f":"'入力情報(1)'!H29","v":0}]
[null,null,null,null,null,"粉末炭平均注入率",null,{"$f":"'入力情報(1)'!H30","v":0}]
[null,null,null,null,null,"粉末炭注入日数",null,{"$f":"'入力情報(1)'!H31","v":0}]
[null,null,null,null,"8.","主要設備の最小系列数",null,{"$f":"'入力情報(1)'!H32","v":0}]
[null,null,null,null,"9.","その系列名称",null,{"$f":"'入力情報(1)'!H33","v":0}]
[null,null,null,null,null,"その他内容",null,{"$f":"'入力情報(1)'!H34","v":0}]
[null,null,null,null,"10.","メンテナンスレベル",null,{"$f":"'入力情報(1)'!H35","v":0}]
[]
[]
[null,null,null,"Ⅱ.設備分類毎の情報"]
[]
[null,null,null,null,null,null,null,"建設(更新)年","取得金額"]
[null,null,null,null,"11.","建築構造物",null,{"$f":"'入力情報(1)'!H41","v":0},{"$f":"IF(AND(LEN('入力情報(1)'!I41)=1,'入力情報(1)'!I41=0),\"0\",'入力情報(1)'!I41)","v":0},"千円"]
[null,null,null,null,"12.","土木構造物",null,{"$f":"'入力情報(1)'!H42","v":0},{"$f":"IF(AND(LEN('入力情報(1)'!I42)=1,'入力情報(1)'!I42=0),\"0\",'入力情報(1)'!I42)","v":0},"千円"]
[null,null,null,null,"13.","電気設備",null,{"$f":"'入力情報(1)'!H43","v":0},{"$f":"IF(AND(LEN('入力情報(1)'!I43)=1,'入力情報(1)'!I43=0),\"0\",'入力情報(1)'!I43)","v":0},"千円"]
[null,null,null,null,"14.","機械設備",null,{"$f":"'入力情報(1)'!H44","v":0},{"$f":"IF(AND(LEN('入力情報(1)'!I44)=1,'入力情報(1)'!I44=0),\"0\",'入力情報(1)'!I44)","v":0},"千円"]
[null,null,null,null,"15.","計装設備",null,{"$f":"'入力情報(1)'!H45","v":0},{"$f":"IF(AND(LEN('入力情報(1)'!I45)=1,'入力情報(1)'!I45=0),\"0\",'入力情報(1)'!I45)","v":0},"千円"]
[]
[null,null,null,"Ⅲ.浄水量の情報"]
[]
[null,null,null,null,"16.","更新する場合の浄水量",null,{"$f":"+'入力情報(2)'!H6","v":0},"m3/d"]
[]
[null,null,null,"Ⅳ.推奨浄水プロセスの情報"]
[]
[null,null,null,null,null,null,{"$f":"'入力情報(2)'!G10","v":"現状の原水水質"},{"$f":"'入力情報(2)'!H10","v":"将来予想される原水水質"},{"$f":"'入力情報(2)'!I10","v":"要求される浄水水質"}]
[null,null,null,null,"17.","濁度",{"$f":"'入力情報(2)'!G11","v":0},{"$f":"'入力情報(2)'!H11","v":0},{"$f":"'入力情報(2)'!I11","v":0}]
[null,null,null,null,"18.","TOC",{"$f":"'入力情報(2)'!G12","v":0},{"$f":"'入力情報(2)'!H12","v":0},{"$f":"'入力情報(2)'!I12","v":0}]
[null,null,null,null,"19.","カビ臭",{"$f":"'入力情報(2)'!G13","v":0},{"$f":"'入力情報(2)'!H13","v":0},{"$f":"'入力情報(2)'!I13","v":0}]
[null,null,null,null,"20.","THMFP",{"$f":"'入力情報(2)'!G14","v":0},{"$f":"'入力情報(2)'!H14","v":0},{"$f":"'入力情報(2)'!I14","v":0}]
[]
[null,null,null,null,"21.","希望フロー",{"$f":"+'入力情報(2)'!G26","v":0}]
[null,null,null,null,null,"粉末炭平均注入率",null,{"$f":"+'入力情報(2)'!H27","v":0},"mg／ℓ"]
[null,null,null,null,null,"粉末炭注入日数",null,{"$f":"+'入力情報(2)'!H28","v":0},"日／年"]
[]
[null,null,null,"Ⅴ.シナリオの選択"]
[]
[null,null,null,null,"初回更新年：",null,"現状設備の更新時期での更新",null,"2012年"]
[null,null,null,null,null,"シナリオ１\n 更新しない場合（修繕のみで対応）"]
[null,null,null,null,{"$f":"IF(AND('入力情報(2)'!T38=TRUE,'入力情報(2)'!A38=\"\"),\"✓\",\"\")","v":""},"シナリオ２\n 現状と同じフロー・水量で更新、使用年数はメンテナンスレベルから算出"]
[null,null,null,null,{"$f":"IF(AND('入力情報(2)'!T39=TRUE,'入力情報(2)'!A39=\"\"),\"✓\",\"\")","v":""},"シナリオ３\n 希望フローで更新、水量は現状と同じ、使用年数はメンテナンスレベルから算出"]
[null,null,null,null,{"$f":"IF(AND('入力情報(2)'!T40=TRUE,'入力情報(2)'!A40=\"\"),\"✓\",\"\")","v":""},"シナリオ４\n 現状のフローで更新、水量は将来予測、使用年数はメンテナンスレベルから算出"]
[null,null,null,null,{"$f":"IF(AND('入力情報(2)'!T41=TRUE,'入力情報(2)'!A41=\"\"),\"✓\",\"\")","v":""},"シナリオ５\n 希望フローで更新、水量は将来予測、使用年数はメンテナンスレベルから算出"]
[]
[]
[]
[]
[]
[null,"シミュレーションを実行する前に入力情報の保存をお勧めします。"]
[]
[null,null,null,null,null,"■入力情報を保存する場合■"]
[null,null,null,null,null,"下記、フロッピー画像をクリックして下さい。"]

{"sheet":"マスター変更","index":7,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":true,"merged":[[1,0,1,7],[12,1,12,6],[14,1,14,6],[43,1,43,6]]}
[]
["マスター変更"]
[]
[]
[]
[null,"【修繕費】"]
[null,"修繕費補正係数",0.3,"*小数点第2位まで入力可"]
[]
[null,"【設備費】"]
[null,"設備費基準金額",159900,"万円"]
[]
[null,"マスターの変更がない場合"]
[null,"　浄水フロー「凝集＋沈澱＋急速ろ過」浄水量20,000m3/日を基準浄水場と想定し、\n　設備費基準金額は159,900万円（e-WaterⅡ研究成果）としています。"]
[null,"　※土木基礎工事、地盤改良工事、場内通路、場内管路工事は含みません。"]
[null,"　シミュレーション結果の内、更新費が予想と大きく異なる場合、この金額を変更して補正して下さい。"]
[]
[null,"【運転費】"]
[null,"１．変動費（電力、燃料、薬品費）"]
[null,"基準給水原価",180,"円/m3-浄水"]
[null,"変動費係数",0.1]
[null,"運転費単価の変動費分",{"$f":"C19*C20","v":18},"円/m3-浄水"]
[]
[null,"２．人件費"]
[null,"人件費①：浄水フローに『膜ろ過』を含まない場合"]
[null,"職員労務単価",30000,"円/人・日"]
[null,"職員数",16,"人/日"]
[null,"外注労務単価",22000,"円/人・日"]
[null,"外注者数",6,"人/日"]
[null,"職員労務費＋外注労務費",{"$f":"C25*C26+C27*C28","v":612000},"円/日-浄水場当たり"]
[null,"基準浄水場での浄水量当たりの人件費",{"$f":"C29/F30","v":30.6},"円/m3-浄水","浄水量",20000,"m3/日"]
[]
[null,"人件費②：浄水フローが『膜ろ過』を含む場合"]
[null,"職員労務単価",30000,"円/人・日"]
[null,"職員数",9,"人/日"]
[null,"外注労務単価",22000,"円/人・日"]
[null,"外注者数",10,"人/日"]
[null,"職員労務費＋外注労務費",{"$f":"C33*C34+C35*C36","v":490000},"円/日-浄水場当たり"]
[null,"基準浄水場での浄水量当たりの人件費",{"$f":"C37/F38","v":24.5},"円/m3-浄水","浄水量",20000,"m3/日"]
[]
[null,"マスターの変更がない場合"]
[null,"基準給水原価を180円/m3（水道統計全国平均　H23年度177円/m3の1の桁を切上）とし、"]
[null,"変動費（電力、燃料、薬品）係数を0.13（水道統計全国平均　費用構成比12.6%）としています。"]
[null,"膜ろ過を含まない浄水場の人件費については、基準給水原価×0.15"]
[null,"　（水道統計全国平均　H23年度費用構成比14.5%）としています。\n　膜ろ過を含む浄水場では、基準給水原価×0.13（想定値）としています。"]
[null,"シュミレーション結果の内、運転費が予想と大きく異なる場合、"]
[null,"　「基準給水原価」と「変動費係数」ないし「職員労務単価、職員数、外注労務単価、外注者数」と"]
[null,"　「浄水量」を変更してください。"]

{"sheet":"参照表","index":8,"n_rows":125,"n_cols":13,"rows_kept":125,"cut":false,"hidden":true,"merged":[[1,0,1,6]]}
[]
[{"$f":"+\"浄水フロー：\"&Cal浄水フロー","v":"浄水フロー：0"}]
[null,{"$f":"\"現在の浄水量（日最大）： \"&TEXT('入力情報(1)'!H23,\"#,###\")","v":"現在の浄水量（日最大）： "},"㎥/日",null,null,null,null,null,null,null,null,null,42]
[null,"　　　　　 規模\n建設(更新)年","土木構造物"]
[null,1900,55744]
[null,1901,55744]
[null,1902,55744]
[null,1903,55744]
[null,1904,55744]
[null,1905,55744]
[null,1906,55744]
[null,1907,55744]
[null,1908,55744]
[null,1909,55744]
[null,1910,55744]
[null,1911,55744]
[null,1912,55744]
[null,1913,55744]
[null,1914,55744]
[null,1915,55744]
[null,1916,55744]
[null,1917,55744]
[null,1918,55744]
[null,1919,55744]
[null,1920,55744]
[null,1921,55744]
[null,1922,55744]
[null,1923,55744]
[null,1924,55744]
[null,1925,55744]
[null,1926,55744]
[null,1927,55744]
[null,1928,55744]
[null,1929,55744]
[null,1930,55744]
[null,1931,55744]
[null,1932,55744]
[null,1933,55744]
[null,1934,55744]
[null,1935,55744]
[null,1936,55744]
[null,1937,55744]
[null,1938,55744]
[null,1939,55744]
[null,1940,55744]
[null,1941,55744]
[null,1942,55744]
[null,1943,55744]
[null,1944,55744]
[null,1945,55744]
[null,1946,55744]
[null,1947,55744]
[null,1948,55744]
[null,1949,55744]
[null,1950,55744]
[null,1951,55744]
[null,1952,59726]
[null,1953,64069]
[null,1954,64069]
[null,1955,64431]
[null,1956,71309]
[null,1957,75653]
[null,1958,73119]
[null,1959,74929]
[null,1960,79272]
[null,1961,87960]
[null,1962,91218]
[null,1963,93027]
[null,1964,96285]
[null,1965,99181]
[null,1966,105696]
[null,1967,111488]
[null,1968,115108]
[null,1969,123433]
[null,1970,132591]
[null,1971,135378]
[null,1972,143342]
[null,1973,183159]
[null,1974,222252]
[null,1975,224786]
[null,1976,240713]
[null,1977,253020]
[null,1978,270033]
[null,1979,293561]
[null,1980,319985]
[null,1981,323605]
[null,1982,324691]
[null,1983,323967]
[null,1984,329397]
[null,1985,328325]
[null,1986,324361]
[null,1987,326523]
[null,1988,332650]
[null,1989,348147]
[null,1990,360401]
[null,1991,370132]
[null,1992,374457]
[null,1993,373736]
[null,1994,374457]
[null,1995,375177]
[null,1996,374151]
[null,1997,377739]
[null,1998,371780]
[null,1999,367774]
[null,2000,368577]
[null,2001,361574]
[null,2002,358994]
[null,2003,363417]
[null,2004,369683]
[null,2005,376102]
[null,2006,382872]
[null,2007,394907]
[null,2008,417097]
[null,2009,397916]
[null,2010,399045]
[null,2011,379863]
[null,2012,376478,null,"┓　2012年の数値となっています。"]
[null,2013,376478,null,"┃"]
[null,2014,376478,null,"┃"]
[null,2015,376478,null,"┃"]
[null,2016,376478,null,"┃"]
[null,2017,376478,null,"┃"]
[null,2018,376478,null,"┃"]
[null,2019,376478,null,"┃"]
[null,2020,376478,null,"┛"]

{"sheet":"取得金額計算","index":9,"n_rows":125,"n_cols":14,"rows_kept":125,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,"(単位：千円)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,"　　　　　規模\n建設年","ﾃﾞﾌﾚｰﾀ","建築構造物","土木構造物","電気設備","機械設備","計装設備"]
[null,1900,{"$f":"+$C$56","v":0.14821508814064968},{"$f":"+$D$56","v":{"$error":"#N/A"}},{"$f":"+$E$56","v":{"$error":"#N/A"}},{"$f":"+$F$56","v":{"$error":"#N/A"}},{"$f":"+$G$56","v":{"$error":"#N/A"}},{"$f":"+$H$56","v":{"$error":"#N/A"}}]
[null,1901,{"$f":"+$C$56","v":0.14821508814064968},{"$f":"+$D$56","v":{"$error":"#N/A"}},{"$f":"+$E$56","v":{"$error":"#N/A"}},{"$f":"+$F$56","v":{"$error":"#N/A"}},{"$f":"+$G$56","v":{"$error":"#N/A"}},{"$f":"+$H$56","v":{"$error":"#N/A"}}]
[null,1902,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1903,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1904,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1905,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1906,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1907,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1908,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1909,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1910,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1911,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1912,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1913,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1914,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1915,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1916,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1917,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1918,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1919,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1920,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1921,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1922,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1923,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1924,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1925,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1926,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1927,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1928,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1929,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1930,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1931,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1932,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1933,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1934,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1935,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1936,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1937,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1938,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1939,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1940,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1941,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1942,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1943,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1944,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1945,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1946,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1947,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1948,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1949,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1950,0.14821508814064968,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1951,{"$f":"+Master!AE57/100","v":0.14821508814064968},{"$f":"ROUND((+Cal建築_浄水Flw*C56)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal土木_浄水Flw*C56)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal電気_浄水Flw*C56)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal機械_浄水Flw*C56)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal計装_浄水Flw*C56)/1000,0)","v":{"$error":"#N/A"}},null,"←"]
[null,1952,{"$f":"+Master!AE58/100","v":0.1588018801506961},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1953,{"$f":"+Master!AE59/100","v":0.17035110779801943},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1954,{"$f":"+Master!AE60/100","v":0.17035110779801943},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1955,{"$f":"+Master!AE61/100","v":0.17131354343529637},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1956,{"$f":"+Master!AE62/100","v":0.18959982054355834},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1957,{"$f":"+Master!AE63/100","v":0.2011490481908817},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1958,{"$f":"+Master!AE64/100","v":0.19441199872994308},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1959,{"$f":"+Master!AE65/100","v":0.19922417691632777},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1960,{"$f":"+Master!AE66/100","v":0.21077340456365118},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1961,{"$f":"+Master!AE67/100","v":0.23387185985829784},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1962,{"$f":"+Master!AE68/100","v":0.24253378059379035},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1963,{"$f":"+Master!AE69/100","v":0.24734595878017507},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1964,{"$f":"+Master!AE70/100","v":0.25600787951566761},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1965,{"$f":"+Master!AE71/100","v":0.26370736461388317},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1966,{"$f":"+Master!AE72/100","v":0.2810312060848682},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1967,{"$f":"+Master!AE73/100","v":0.29643017628129936},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1968,{"$f":"+Master!AE74/100","v":0.30605453265406884},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1969,{"$f":"+Master!AE75/100","v":0.32819055231143857},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1970,{"$f":"+Master!AE76/100","v":0.35254017393454534},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1971,{"$f":"+Master!AE77/100","v":0.35995092834157782},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1972,{"$f":"+Master!AE78/100","v":0.38112451236167055},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1973,{"$f":"+Master!AE79/100","v":0.48699243246213464},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1974,{"$f":"+Master!AE80/100","v":0.59093548128804474},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1975,{"$f":"+Master!AE81/100","v":0.5976725307489833},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1976,{"$f":"+Master!AE82/100","v":0.64001969878916909},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1977,{"$f":"+Master!AE83/100","v":0.67274251045658529},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1978,{"$f":"+Master!AE84/100","v":0.71797698540860155},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1979,{"$f":"+Master!AE85/100","v":0.78053530183160302},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1980,{"$f":"+Master!AE86/100","v":0.85079310335282032},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1981,{"$f":"+Master!AE87/100","v":0.8604174597255897},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1982,{"$f":"+Master!AE88/100","v":0.86330476663742062},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1983,{"$f":"+Master!AE89/100","v":0.86137989536286652},{"$f":"ROUND((+Cal建築_浄水Flw*C88)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal土木_浄水Flw*C88)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal電気_浄水Flw*C88)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal機械_浄水Flw*C88)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal計装_浄水Flw*C88)/1000,0)","v":{"$error":"#N/A"}}]
[null,1984,{"$f":"+Master!AE90/100","v":0.8758164299220208},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1985,{"$f":"+Master!AE91/100","v":0.87296805997122051},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1986,{"$f":"+Master!AE92/100","v":0.8624272820791421},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1987,{"$f":"+Master!AE93/100","v":0.86817679729300312},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1988,{"$f":"+Master!AE94/100","v":0.88446709039894245},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1989,{"$f":"+Master!AE95/100","v":0.92567194943161257},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1990,{"$f":"+Master!AE96/100","v":0.95825253564349122},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1991,{"$f":"+Master!AE97/100","v":0.98412535410586544},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1992,{"$f":"+Master!AE98/100","v":0.99562438453358737},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1993,{"$f":"+Master!AE99/100","v":0.99370787946230055},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1994,{"$f":"+Master!AE100/100","v":0.99562438453358737},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1995,{"$f":"+Master!AE101/100","v":0.99754088960487453},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1996,{"$f":"+Master!AE102/100","v":0.99481212411208886},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1997,{"$f":"+Master!AE103/100","v":1.0043522843598729},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1998,{"$f":"+Master!AE104/100","v":0.98850657315141943},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1999,{"$f":"+Master!AE105/100","v":0.97785635948937411},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2000,{"$f":"+Master!AE106/100","v":0.97999183340138829},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2001,{"$f":"+Master!AE107/100","v":0.96137198856676198},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2002,{"$f":"+Master!AE108/100","v":0.95451204573295234},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2003,{"$f":"+Master!AE109/100","v":0.9662719477337689},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2004,{"$f":"+Master!AE110/100","v":0.98293180890159249},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2005,{"$f":"+Master!AE111/100","v":1},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2006,{"$f":"+Master!AE112/100","v":1.018},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2007,{"$f":"+Master!AE113/100","v":1.05},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2008,{"$f":"+Master!AE114/100","v":1.109},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2009,{"$f":"+Master!AE115/100","v":1.0580000000000001},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2010,{"$f":"+Master!AE116/100","v":1.0609999999999999},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2011,{"$f":"+Master!AE117/100","v":1.01},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2012,{"$f":"+Master!AE118/100","v":1.0009999999999999},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,"←"]
[null,2013,{"$f":"+Master!AE119/100","v":1.0009999999999999},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2014,{"$f":"+Master!AE120/100","v":1.0009999999999999},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2015,{"$f":"+Master!AE121/100","v":1.0009999999999999},{"$f":"ROUND((+Cal建築_浄水Flw*C120)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal土木_浄水Flw*C120)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal電気_浄水Flw*C120)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal機械_浄水Flw*C120)/1000,0)","v":{"$error":"#N/A"}},{"$f":"ROUND((+Cal計装_浄水Flw*C120)/1000,0)","v":{"$error":"#N/A"}}]
[null,2016,{"$f":"+Master!AE122/100","v":1.0009999999999999},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2017,{"$f":"+Master!AE123/100","v":1.0009999999999999},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2018,{"$f":"+Master!AE124/100","v":1.0009999999999999},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2019,{"$f":"+Master!AE125/100","v":1.0009999999999999},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2020,{"$f":"+Master!AE126/100","v":1.0009999999999999},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Master","index":10,"n_rows":147,"n_cols":52,"rows_kept":147,"cut":false,"hidden":true,"merged":[[17,11,17,13]]}
[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,"{Select都道府県}",null,"{Select原水種類}",null,"{Select浄水フロー}",null,null,"{Select粉末炭}",null,"{Select主要設備系列数}",null,"{Selectその他系列名}",null,"{Selectメンテナンス}",null,null,null,"{Select建設年}",null,"{Select濁度G}","{SelectTocG}","{Selectカビ臭G}","{SelectThmfpG}",null,null,"{Rng耐用年数}",null,null,"{RngDef}",null,null,null,"{Mas原浄レベル}",null,null,null,null,null,null,"{Mas濁度除去プロセス}",null,null,null,null,null,null,null,null,"Userform表示","メンテナンスレベル",{"$f":"VLOOKUP(AY2,$AY$13:$AZ$27,2,FALSE)","v":"浄水施設に関してのメンテナンスレベルを自己採点して下さい。\nメンテナンスレベルスコアが高いほど電気設備、機械設備、\n計装設備の更新年数が法定耐用年数より延長するとして\nシミュレーションが行われます。\nまた、故障率が低くなります。\n未入力の場合、メンテナンスレベルスコア360点（中間点）で\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,1,2,3,4,5,6,null,1,2,3,4,null,null,null,null,null,null,null,"※｢ﾀｲﾄﾙ｣をｷｰとして、Vlookup参照"]
[null,"都道府県",null,"5.原水種類",null,"6.浄水フロー","分類No.",null,"7.粉末炭の有無",null,"8.主要設備の最小系列数",null,"9.その系列名称",null,"10.メンテナンスポイント",{"$f":"+メンテナンスレベル!G29","v":0},null,null,"建設(更新)年",null,"濁度","TOC","カビ臭","THMFP",null,null,null,"法定耐用年数",null,"（年度）","率",null,null,"Key(種類+項目+入力選択肢)","種類","項目","入力選択肢","レベル","ﾎﾟｲﾝﾄ",null,"Key(ﾌﾟﾛｾｽ+ﾌﾟﾛｾｽCode)","プロセス","ﾌﾟﾛｾｽCode","プロセス名"]
[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,"建築構造物",50,null,null,null,null,null,"原水レベル!濁度!0.1度以下","原水レベル","濁度","0.1度以下","低-1",20,null,"濁度除去プロセス!10","濁度除去プロセス",10,"不要",null,"{RngPrintWs}"]
[null,"北海道",null,"ダム放流水",null,"滅菌のみ",null,null,"有",null,1,null,"混和池",null,null,"延長係数(β)","故障率係数(γ)",null,"1950(昭和25)",null,"0.1度以下","1.0mg/L以下","1ng/L以下","0.015mg/L以下",null,null,"土木構造物",60,null,1900,14.811627808188923,null,null,"原水レベル!濁度!0.1度超～1.0度以下","原水レベル","濁度","0.1度超～1.0度以下","低",30,null,"濁度除去プロセス!11","濁度除去プロセス",11,"不要"]
[null,"青森県",null,"ダム水",null,"緩速ろ過",null,null,"無",null,2,null,"フロック形成池",null,"建築構造物",{"$f":"IF(P4>0,(0.4027*LN(P4)-1.0614),0.4027*LN(360)-1.0614)","v":1.3089340934649778},{"$f":"+事故率係数/RngEnchou建築","v":76.398040588340464},null,"1951(昭和26)",null,"0.1度超～1.0度以下","1.0mg/L超～1.5mg/L以下","1ng/L超～3ng/L以下","0.015mg/L超～0.04mg/L以下",null,null,"電気設備",20,null,1901,14.811627808188923,null,null,"原水レベル!濁度!1.0度超～5.0度以下","原水レベル","濁度","1.0度超～5.0度以下","中",40,null,"濁度除去プロセス!12","濁度除去プロセス",12,"不要",null,"基本情報","基本情報"]
[null,"岩手県",null,"表流水",null,"凝集+急速ろ過",3000,null,null,null,3,null,"沈澱池",null,"土木構造物",{"$f":"IF(P4>0,(0.4406*LN(P4)-1.247),0.4406*LN(360)-1.247)","v":1.3464174362569385},{"$f":"+事故率係数/RngEnchou土木","v":74.271171263201666},null,"1952(昭和27)",null,"1.0度超～5.0度以下","1.5mg/L超～2.5mg/L以下","3ng/L超～5ng/L以下","0.04mg/L超～0.07mg/L以下",null,null,"機械設備",15,null,1902,14.811627808188923,null,null,"原水レベル!濁度!5.0度超～800度以下","原水レベル","濁度","5.0度超～800度以下","高",50,null,"濁度除去プロセス!20","濁度除去プロセス",20,"不要",null,"入力情報(1)","入力情報(1)"]
[null,"宮城県",null,"湖沼水",null,"凝集+沈澱+急速ろ過",2100,null,null,null,4,null,"ろ過池",null,"電気設備",{"$f":"IF(P4>0,(0.3483*LN(P4)-0.7184),0.3483*LN(360)-0.7184)","v":1.3317300341540892},{"$f":"+事故率係数/RngEnchou電気","v":75.090294155241224},null,"1953(昭和28)",null,"5.0度超～800度以下","2.5mg/L超～3.5mg/L以下","5ng/L超～25ng/L以下","0.07mg/L超～0.14mg/L以下",null,null,"計装設備",10,null,1903,14.811627808188923,null,null,"原水レベル!濁度!800度超","原水レベル","濁度","800度超","高高",50,null,"濁度除去プロセス!21","濁度除去プロセス",21,"不要",null,"入力情報(2)","入力情報(2)"]
[null,"秋田県",null,"伏流水",null,"凝集+沈澱+粒状炭+急速ろ過",5100,null,null,null,5,null,"その他",null,"機械設備",{"$f":"IF(P4>0,(+ 0.2907*LN(P4)-0.3401),+ 0.2907*LN(360)-0.3401)","v":1.3709904419425603},{"$f":"+事故率係数/RngEnchou機械","v":72.939968755952606},null,"1954(昭和29)",null,"800度超","3.5mg/L超～8.1mg/L以下","25ng/L超～1000ng/L以下","0.14mg/L超",null,null,null,null,null,1904,14.811627808188923,null,null,"原水レベル!TOC!1.0mg/L以下","原水レベル","TOC","1.0mg/L以下","低-2",10,null,"濁度除去プロセス!22","濁度除去プロセス",22,"膜ろ過",null,"メンテナンスレベル","メンテナンスレベル"]
[null,"山形県",null,"浅井戸水",null,"凝集+沈澱+オゾン+粒状炭+急速ろ過",6100,null,null,null,6,null,null,null,"計装設備",{"$f":"IF(P4>0,(0.3239*LN(P4)-0.5728),0.3239*LN(360)-0.5728)","v":1.3337090957867057},{"$f":"+事故率係数/RngEnchou計装","v":74.978869317085739},null,"1955(昭和30)",null,null,"8.1mg/L超","1000ng/L超",null,null,null,null,null,null,1905,14.811627808188923,null,null,"原水レベル!TOC!1.0mg/L超～1.5mg/L以下","原水レベル","TOC","1.0mg/L超～1.5mg/L以下","低-1",20,null,"濁度除去プロセス!30","濁度除去プロセス",30,"不要",null,"プレビュー","プレビュー",null,null,null,"【項目説明】"]
[null,"福島県",null,"深井戸水",null,"その他",null,null,null,null,7,null,null,null,null,null,null,null,"1956(昭和31)",null,"■浄水レベル■",null,null,null,null,null,null,null,null,1906,14.811627808188923,null,null,"原水レベル!TOC!1.5mg/L超～2.5mg/L以下","原水レベル","TOC","1.5mg/L超～2.5mg/L以下","低",30,null,"濁度除去プロセス!31","濁度除去プロセス",31,"凝集＋急速ろ過",null,"健全度","健全度",null,null,"No.","項目名","コメント"]
[null,"茨城県",null,"湧水",null,"粉末炭+凝集+沈澱+急速ろ過",2110,null,null,null,8,null,null,null,"事故率係数(γ)",100,null,null,"1957(昭和32)",null,"濁度","TOC","カビ臭","THM",null,null,null,null,null,1907,14.811627808188923,null,null,"原水レベル!TOC!2.5mg/L超～3.5mg/L以下","原水レベル","TOC","2.5mg/L超～3.5mg/L以下","中",40,null,"濁度除去プロセス!32","濁度除去プロセス",32,"膜ろ過",null,"影響水量","影響水量",null,null,4,"給水原価","現状の給水原価を入力して下さい。仮の数値を入力する場合、\n水道統計（H17年度）では約180円/m3を参考にして下さい。"]
[null,"栃木県",null,"その他",null,null,null,null,null,null,"9以上",null,null,null,null,null,null,null,"1958(昭和33)",null,null,null,null,null,null,null,null,null,null,1908,14.811627808188923,null,null,"原水レベル!TOC!3.5mg/L超～8.1mg/L以下","原水レベル","TOC","3.5mg/L超～8.1mg/L以下","高",50,null,"濁度除去プロセス!40","濁度除去プロセス",40,"凝集＋急速ろ過",null,"損失額","損失額",null,null,5,"原水種類","シミュレーションには影響しませんので、未記入でも構いません。"]
[null,"群馬県",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1959(昭和34)",null,"（2.0度以下）","3.0mg/L以下","10ng/L以下","0.1mg/L以下",null,null,null,null,null,1909,14.811627808188923,null,null,"原水レベル!TOC!8.1mg/L超","原水レベル","TOC","8.1mg/L超","高高",50,null,"濁度除去プロセス!41","濁度除去プロセス",41,"凝集＋急速ろ過",null,"修繕＆更新(シナリオ１)","修繕更新費用S1",null,null,6,"浄水フロー","基本的な浄水プロセスの構成で浄水フローを示しています。\n現在の浄水フローに最も近い処理フローを選択して下さい。"]
[null,"埼玉県",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1960(昭和35)",null,"0.1度以下","1.5mg/L以下","3ng/L以下","0.04mg/L以下",null,null,null,null,null,1910,14.811627808188923,null,null,"原水レベル!カビ臭!1ng/L以下","原水レベル","カビ臭","1ng/L以下","低-2",10,null,"濁度除去プロセス!42","濁度除去プロセス",42,"膜ろ過",null,"修繕＆更新(シナリオ２)","修繕更新費用S2",null,null,7,"粉末炭の有無","粉末炭注入設備の有無を選択して下さい。\n水源事故対策としての設備の場合は“無”を選択する。"]
[null,"千葉県",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1961(昭和36)",null,"0.01度以下","1.0mg/L以下","1ng/L以下","0.015mg/L以下",null,null,null,null,null,1911,14.811627808188923,null,null,"原水レベル!カビ臭!1ng/L超～3ng/L以下","原水レベル","カビ臭","1ng/L超～3ng/L以下","低-1",20,null,"濁度除去プロセス!50","濁度除去プロセス",50,"凝集＋沈澱＋急速ろ過",null,"修繕＆更新(シナリオ３)","修繕更新費用S3",null,null,"7_a","粉末炭平均注入率","未入力の場合、平均注入率10mg/Lとして計算されます。"]
[null,"東京都",null,null,null,null,null,null,null,null,"Rng更新率表","更新率%",null,null,null,"Select更新年",null,null,"1962(昭和37)",null,null,null,null,null,null,null,null,null,null,1912,14.811627808188923,null,null,"原水レベル!カビ臭!3ng/L超～5ng/L以下","原水レベル","カビ臭","3ng/L超～5ng/L以下","低",30,null,"濁度除去プロセス!51","濁度除去プロセス",51,"凝集＋沈澱＋急速ろ過",null,"修繕＆更新(シナリオ４)","修繕更新費用S4",null,null,"7_b","粉末炭注入日数","未入力の場合、３６５日／年で計算されます。"]
[null,"神奈川県",null,null,null,null,null,null,null,null,"経過年数","機械","電気","経年",null,"更新年指定",null,null,"1963(昭和38)",null,null,null,null,null,null,null,null,null,null,1913,14.811627808188923,null,null,"原水レベル!カビ臭!5ng/L超～25ng/L以下","原水レベル","カビ臭","5ng/L超～25ng/L以下","中",40,null,"濁度除去プロセス!52","濁度除去プロセス",52,"凝集＋沈澱＋膜ろ過 or 凝集＋前ろ過＋膜ろ過",null,"修繕＆更新(シナリオ５)","修繕更新費用S5",null,null,8,"主要設備の最小系列数","影響水量と損失額の計算に使用します。\n系列数が多いほど、影響水量、損失額は低くなります。\n例えば、沈澱池２系列、ろ過池が４系列の場合には、\n２系列を選択します。"]
[null,"新潟県",null,null,null,"{Select推奨フロー}",null,null,null,null,0,7.3314899967639388E-2,8.6527443347448746E-2,0.31714428961980295,null,null,null,null,"1964(昭和39)",null,"{Select濁度J}","{SelectTocJ}","{Selectカビ臭J}","{SelectThmfpJ}",null,null,null,null,null,1914,14.811627808188923,null,null,"原水レベル!カビ臭!25ng/L超～1000ng/L以下","原水レベル","カビ臭","25ng/L超～1000ng/L以下","高",50,null,"TOC除去プロセス!100","TOC除去プロセス",100,"不要",null,"出力まとめの表","出力まとめの表",null,null,10,"メンテナンスレベル","浄水施設に関してのメンテナンスレベルを自己採点して下さい。\nメンテナンスレベルスコアが高いほど電気設備、機械設備、\n計装設備の更新年数が法定耐用年数より延長するとして\nシミュレーションが行われます。\nまた、故障率が低くなります。\n未入力の場合、メンテナンスレベルスコア360点（中間点）で\n延長係数が計算されます。"]
[null,"富山県",null,null,null,null,null,null,null,null,1,0.17326253936380356,0.20165547181812679,0.71042971730821169,null,"2011年",null,null,"1965(昭和40)",null,null,null,null,null,null,null,null,null,null,1915,14.811627808188923,null,null,"原水レベル!カビ臭!1000ng/L超","原水レベル","カビ臭","1000ng/L超","高高",50,null,"TOC除去プロセス!110","TOC除去プロセス",110,"不要",null,"系列の集計","系列の集計",null,null,"11_15","設備分類毎の情報","建設（更新）年は主要な設備、機材の取得年を入力して下さい。\n取得金額は主要なものとその他の設備、機材の金額を分かる\n範囲で合計して入力して下さい。\n取得金額が不明な場合、参照入力の金額を参照するかそのまま\n入力（取得データを「取得金額」に入力する）して下さい。"]
[null,"石川県",null,null,null,"21.希望フロー",null,null,null,null,2,0.30786694832571326,0.35317262378822789,1.1934630157980359,null,"2012年",null,null,"1966(昭和41)",null,null,null,null,null,null,null,null,null,null,1916,14.811627808188923,null,null,"原水レベル!THMFP!0.015mg/L以下","原水レベル","THMFP","0.015mg/L以下","低-1",20,null,"TOC除去プロセス!120","TOC除去プロセス",120,"不要",null,null,null,null,null,16,"更新する場合の浄水量","更新する場合の計画浄水量を入力して下さい。\nあるいは将来予想される給水人口から計画浄水量を\n入力して下さい。"]
[null,"福井県",null,null,null,null,null,null,null,null,3,0.48694917220769485,0.55041310988706804,1.7810396844177339,null,"2013年",null,null,"1967(昭和42)",null,null,null,null,null,null,null,null,null,null,1917,14.811627808188923,null,null,"原水レベル!THMFP!0.015mg/L超～0.04mg/L以下","原水レベル","THMFP","0.015mg/L超～0.04mg/L以下","低",30,null,"TOC除去プロセス!200","TOC除去プロセス",200,"不要",null,null,null,null,null,"-","プロセス選定","「水道技術研究センター　浄水技術ガイドライン2010　p.16～19」に\n記載されているプロセス選定表、基本システム選定表を参考としています。\nただし、”前ろ過”を含むプロセスはシミュレーションを簡略化するため除外しました。\nまた、シミュレータの都合上、原水レベルを低、中、高の3段階から低-2、低-1、中、高、高高の5段階に変更しました。"]
[null,"山梨県",null,null,null,"膜ろ過",1100,null,null,null,4,0.72231972195016403,0.80438395543915253,2.488937009750785,null,"2014年",null,null,"1968(昭和43)",null,null,null,null,null,null,null,null,null,null,1918,14.811627808188923,null,null,"原水レベル!THMFP!0.04mg/L超～0.07mg/L以下","原水レベル","THMFP","0.04mg/L超～0.07mg/L以下","中",40,null,"TOC除去プロセス!210","TOC除去プロセス",210,"不要",null,null,null,null,null,3,"現在の給水人口","計画給水人口を入力して下さい。"]
[null,"長野県",null,null,null,"凝集+膜ろ過",1200,null,null,null,5,1.0279231445433346,1.1278473951378256,3.3336209885221932,null,"2015年",null,null,"1969(昭和44)",null,null,null,null,null,null,null,null,null,null,1919,14.811627808188923,null,null,"原水レベル!THMFP!0.07mg/L超～0.14mg/L以下","原水レベル","THMFP","0.07mg/L超～0.14mg/L以下","高",50,null,"TOC除去プロセス!220","TOC除去プロセス",220,"凝集or粉末炭or粒状炭or（オゾン＋粒状炭）",null,null,null,null,null,"17_20","推奨浄水プロセスの情報","「水道技術研究センター　浄水技術ガイドライン2010　p.15」に\n記載されている原水レベルと浄水レベル区分となっています。"]
[null,"岐阜県",null,null,null,"凝集+沈澱+急速ろ過",2100,null,null,null,6,1.4199093241254903,1.5353403185114101,4.331864507218703,null,"2016年",null,null,"1970(昭和45)",null,null,null,null,null,null,null,null,null,null,1920,14.811627808188923,null,null,"原水レベル!THMFP!0.14mg/L超","原水レベル","THMFP","0.14mg/L超","高高",50,null,"TOC除去プロセス!300","TOC除去プロセス",300,"不要",null,null,null,null,null,19,"推奨浄水プロセスの情報：カビ臭","ジェオスミンと2-MIB濃度の合計値として下さい。\n\n「水道技術研究センター　浄水技術ガイドライン2010　p.15」に\n記載されている原水レベルと浄水レベル区分となっています。"]
[null,"静岡県",null,null,null,"粉末炭+凝集+沈澱+急速ろ過",2110,null,null,null,7,1.9166042757664128,2.0431120000358503,5.5002791688138588,null,"2017年",null,null,"1971(昭和46)",null,null,null,null,null,null,null,null,null,null,1921,14.811627808188923,null,null,"浄水レベル!濁度!（2.0度以下）","浄水レベル","濁度","（2.0度以下）","水質基準",0,null,"TOC除去プロセス!310","TOC除去プロセス",310,"凝集or粉末炭or粒状炭or（オゾン＋粒状炭）",null,null,null,null,null,9,"その系列名称","未記入でもかまいません。\n単に最小系列設備の名称を確認するものです。"]
[null,"愛知県",null,null,null,"凝集+沈澱+膜ろ過",2200,null,null,null,8,2.5383534052644534,2.6689622312245502,6.8547690143145621,null,"2018年",null,null,"1972(昭和47)",null,null,null,null,null,null,null,null,null,null,1922,14.811627808188923,null,null,"浄水レベル!濁度!0.1度以下","浄水レベル","濁度","0.1度以下","レベル１",1,null,"TOC除去プロセス!320","TOC除去プロセス",320,"凝集or粉末炭or粒状炭or（オゾン＋粒状炭）"]
[null,"三重県",null,null,null,"粉末炭+凝集+沈澱+膜ろ過",2210,null,null,null,9,3.3072130651941349,3.4319646107380377,8.4099207367370035,null,"2019年",null,null,"1973(昭和48)",null,null,null,null,null,null,null,null,null,null,1923,14.811627808188923,null,null,"浄水レベル!濁度!0.01度以下","浄水レベル","濁度","0.01度以下","レベル２",2,null,"TOC除去プロセス!400","TOC除去プロセス",400,"不要"]
[null,"滋賀県",null,null,null,"凝集+急速ろ過",3000,null,null,null,10,4.246472170368401,4.3520643394416627,10.17835139158902,null,"2020年",null,null,"1974(昭和49)",null,null,null,null,null,null,null,null,null,null,1924,14.811627808188923,null,null,"浄水レベル!TOC!3.0mg/L以下","浄水レベル","TOC","3.0mg/L以下","水質基準",0,null,"TOC除去プロセス!410","TOC除去プロセス",410,"粒状炭or（オゾン＋粒状炭）"]
[null,"京都府",null,null,null,"凝集+沈澱+粒状炭+急速ろ過",5100,null,null,null,11,5.3799948180511388,5.4495464451781874,12.170040553590919,null,"2021年",null,null,"1975(昭和50)",null,null,null,null,null,null,null,null,null,null,1925,14.811627808188923,null,null,"浄水レベル!TOC!1.5mg/L以下","浄水レベル","TOC","1.5mg/L以下","レベル１",1,null,"TOC除去プロセス!420","TOC除去プロセス",420,"粒状炭or（オゾン＋粒状炭）"]
[null,"大阪府",null,null,null,"凝集+沈澱+粒状炭+膜ろ過",5200,null,null,null,12,6.7313871145228452,6.7443787557641697,14.391678794653368,null,"2022年",null,null,"1976(昭和51)",null,null,null,null,null,null,null,null,null,null,1926,14.811627808188923,null,null,"浄水レベル!TOC!1.0mg/L以下","浄水レベル","TOC","1.0mg/L以下","レベル２",2,null,"TOC除去プロセス!500","TOC除去プロセス",500,"粉末炭"]
[null,"兵庫県",null,null,null,"凝集+沈澱+オゾン+粒状炭+急速ろ過",6100,null,null,null,13,8.3230061531257036,8.2554437444823332,16.846067711738495,null,"2023年",null,null,"1977(昭和52)",null,null,null,null,null,null,null,null,null,null,1927,14.811627808188923,null,null,"浄水レベル!カビ臭!10ng/L以下","浄水レベル","カビ臭","10ng/L以下","水質基準",0,null,"TOC除去プロセス!510","TOC除去プロセス",510,"粒状炭or（オゾン＋粒状炭）"]
[null,"奈良県",null,null,null,"凝集+沈澱+オゾン+粒状炭+膜ろ過",6200,null,null,null,14,10.174845302779092,9.9996839507511908,19.531608029251512,null,"2024年",null,null,"1978(昭和53)",null,null,null,null,null,null,null,null,null,null,1928,14.811627808188923,null,null,"浄水レベル!カビ臭!3ng/L以下","浄水レベル","カビ臭","3ng/L以下","レベル１",1,null,"TOC除去プロセス!520","TOC除去プロセス",520,"粒状炭or（オゾン＋粒状炭）"]
[null,"和歌山県",null,null,null,"粒状炭+膜ろ過",7100,null,null,null,15,12.303346243127773,11.9911961821681,22.44191117650449,null,"2025年",null,null,"1979(昭和54)",null,null,null,null,null,null,null,null,null,null,1929,14.811627808188923,null,null,"浄水レベル!カビ臭!1ng/L以下","浄水レベル","カビ臭","1ng/L以下","レベル２",2,null,"カビ臭除去プロセス!1000","カビ臭除去プロセス",1000,"不要"]
[null,"鳥取県",null,null,null,"凝集+粒状炭+膜ろ過",7200,null,null,null,16,14.720202830557753,14.240319136609591,25.565566009265158,null,"2026年",null,null,"1980(昭和55)",null,null,null,null,null,null,null,null,null,null,1930,14.811627808188923,null,null,"浄水レベル!THM!0.1mg/L以下","浄水レベル","THM","0.1mg/L以下","水質基準",0,null,"カビ臭除去プロセス!1100","カビ臭除去プロセス",1100,"不要"]
[null,"島根県",null,null,null,"オゾン+粒状炭+膜ろ過",7300,null,null,null,17,17.431233086865291,16.752766389416752,28.88608603219269,null,"2027年",null,null,"1981(昭和56)",null,null,null,null,null,null,null,null,null,null,1931,14.811627808188923,null,null,"浄水レベル!THM!0.04mg/L以下","浄水レベル","THM","0.04mg/L以下","レベル１",1,null,"カビ臭除去プロセス!1200","カビ臭除去プロセス",1200,"不要"]
[null,"岡山県",null,null,null,null,null,null,null,null,18,20.43540165267553,19.528860869300193,32.382053846422423,null,"2028年",null,null,"1982(昭和57)",null,null,null,null,null,null,null,null,null,null,1932,14.811627808188923,null,null,"浄水レベル!THM!0.015mg/L以下","浄水レベル","THM","0.015mg/L以下","レベル２",2,null,"カビ臭除去プロセス!2000","カビ臭除去プロセス",2000,"不要"]
[null,"広島県",null,null,null,null,null,null,null,null,19,23.724074555093488,22.562927172991298,36.027469083687869,null,"2029年",null,null,"1983(昭和58)",null,null,null,null,null,null,null,null,null,null,1933,14.811627808188923,null,null,null,null,null,null,null,null,null,"カビ臭除去プロセス!2100","カビ臭除去プロセス",2100,"不要"]
[null,"山口県",null,null,null,null,null,null,null,null,20,27.280580275093481,25.84289381483077,39.792294485564241,null,"2030年",null,null,"1984(昭和59)",null,null,null,null,null,null,null,null,null,null,1934,14.811627808188923,null,null,null,null,null,null,null,null,null,"カビ臭除去プロセス!2200","カビ臭除去プロセス",2200,"粉末炭"]
[null,"徳島県",null,null,null,null,null,null,null,null,21,31.080135773647982,29.350148640025459,43.643182881342341,null,"2031年",null,null,"1985(昭和60)",null,null,null,null,null,null,null,null,null,null,1935,14.811627808188923,null,null,null,null,null,null,null,null,null,"カビ臭除去プロセス!3000","カビ臭除去プロセス",3000,"不要"]
[null,"香川県",null,null,null,null,null,null,null,null,22,35.090174092970678,33.059677471319617,47.544356523045707,null,"2032年",null,null,"1986(昭和61)",null,null,null,null,null,null,null,null,null,null,1936,14.811627808188923,null,null,null,null,null,null,null,null,null,"カビ臭除去プロセス!3100","カビ臭除去プロセス",3100,"粉末炭"]
[null,"愛媛県",null,null,null,null,null,null,null,null,23,39.271082970332245,36.940499396949185,51.458600453512844,null,"2033年",null,null,"1987(昭和62)",null,null,null,null,null,null,null,null,null,null,1937,14.811627808188923,null,null,null,null,null,null,null,null,null,"カビ臭除去プロセス!3200","カビ臭除去プロセス",3200,"粉末炭"]
[null,"高知県",null,null,null,null,null,null,null,null,24,43.577333880823943,40.956393152684598,55.348324117916533,null,"2034年",null,null,"1988(昭和63)",null,null,null,null,null,null,null,null,null,null,1938,14.811627808188923,null,null,null,null,null,null,null,null,null,"カビ臭除去プロセス!4000","カビ臭除去プロセス",4000,"粉末炭"]
[null,"福岡県",null,null,null,null,null,null,null,null,25,47.958950843522622,45.066889332246021,59.176640906939198,null,"2035年",null,null,"1989(昭和64)",null,null,null,null,null,null,null,null,null,null,1939,14.811627808188923,null,null,null,null,null,null,null,null,null,"カビ臭除去プロセス!4100","カビ臭除去プロセス",4100,"粉末炭or粒状炭or（オゾン＋粒状炭）"]
[null,"佐賀県",null,null,null,null,null,null,null,null,26,52.363241141234127,49.228484380506934,62.908414125121212,null,"2036年",null,null,"1990(平成02)",null,null,null,null,null,null,null,null,null,null,1940,14.811627808188923,null,null,null,null,null,null,null,null,null,"カビ臭除去プロセス!4200","カビ臭除去プロセス",4200,"粒状炭or（オゾン＋粒状炭）"]
[null,"長崎県",null,null,null,null,null,null,null,null,27,56.736688600078274,53.396016179347527,66.511220112661277,null,"2037年",null,null,"1991(平成03)",null,null,null,null,null,null,null,null,null,null,1941,14.811627808188923,null,null,null,null,null,null,null,null,null,"カビ臭除去プロセス!5000","カビ臭除去プロセス",5000,"粉末炭or粒状炭or（オゾン＋粒状炭）"]
[null,"熊本県",null,null,null,null,null,null,null,null,28,61.026896512150749,57.524129031669816,69.956184722536548,null,"2038年",null,null,"1992(平成04)",null,null,null,null,null,null,null,null,null,null,1942,14.811627808188923,null,null,null,null,null,null,null,null,null,"カビ臭除去プロセス!5100","カビ臭除去プロセス",5100,"粒状炭or（オゾン＋粒状炭）"]
[null,"大分県",null,null,null,null,null,null,null,null,29,65.184463111455358,61.568749127313218,73.218657603747076,null,"2039年",null,null,"1993(平成05)",null,null,null,null,null,null,null,null,null,null,1943,14.811627808188923,null,null,null,null,null,null,null,null,null,"カビ臭除去プロセス!5200","カビ臭除去プロセス",5200,"粒状炭or（オゾン＋粒状炭）"]
[null,"宮崎県",null,null,null,null,null,null,null,null,30,69.164678179447719,65.48849078287941,76.278699077271014,null,"2040年",null,null,"1994(平成06)",null,null,null,null,null,null,null,null,null,null,1944,14.811627808188923,null,null,null,null,null,null,null,null,null,"THM除去プロセス!10000","THM除去プロセス",10000,"不要"]
[null,"鹿児島県",null,null,null,null,null,null,null,null,31,72.928944252314466,69.245918962399358,79.121365970418836,null,"2041年",null,null,"1995(平成07)",null,null,null,null,null,null,null,null,null,null,1945,14.811627808188923,null,null,null,null,null,null,null,null,null,"THM除去プロセス!11000","THM除去プロセス",11000,"不要"]
[null,"沖縄県",null,null,null,null,null,null,null,null,32,76.445848439043303,72.808604304079793,81.736794682957608,null,"2042年",null,null,"1996(平成08)",null,null,null,null,null,null,null,null,null,null,1946,14.811627808188923,null,null,null,null,null,null,null,null,null,"THM除去プロセス!12000","THM除去プロセス",12000,"不要"]
[null,null,null,null,null,null,null,null,null,null,33,79.691838676208704,76.1499220760425,84.120091096500133,null,"2043年",null,null,"1997(平成09)",null,null,null,null,null,null,null,null,null,null,1947,14.811627808188923,null,null,null,null,null,null,null,null,null,"THM除去プロセス!20000","THM除去プロセス",20000,"不要"]
[null,null,null,null,null,null,null,null,null,null,34,82.651488509357478,79.249564735413003,86.271046907593316,null,"2044年",null,null,"1998(平成10)",null,null,null,null,null,null,null,null,null,null,1948,14.811627808188923,null,null,null,null,null,null,null,null,null,"THM除去プロセス!21000","THM除去プロセス",21000,"不要"]
[null,null,null,null,null,null,null,null,null,null,35,85.317364248217288,82.093757405933559,88.19370993087594,null,"2045年",null,null,"1999(平成11)",null,null,null,null,null,null,null,null,null,null,1949,14.811627808188923,null,null,null,null,null,null,null,null,null,"THM除去プロセス!22000","THM除去プロセス",22000,"不要"]
[null,null,null,null,null,null,null,null,null,null,36,87.689534868504211,84.675184900877355,89.895841459782147,null,"2046年",null,null,"2000(平成12)",null,null,null,null,null,null,null,null,null,null,1950,14.811627808188923,null,null,null,null,null,null,null,null,null,"THM除去プロセス!30000","THM除去プロセス",30000,"不要"]
[null,null,null,null,null,null,null,null,null,null,37,89.774786129881377,86.99265630993095,91.388296700228594,null,"2047年",null,null,"2001(平成13)",null,null,null,null,null,null,null,null,null,null,1951,14.821508814064968,null,null,null,null,null,null,null,null,null,"THM除去プロセス!31000","THM除去プロセス",31000,"不要"]
[null,null,null,null,null,null,null,null,null,null,38,91.58561459054593,89.050547335848307,92.684364649204127,null,"2048年",null,null,"2002(平成14)",null,null,null,null,null,null,null,null,null,null,1952,15.88018801506961,null,null,null,null,null,null,null,null,null,"THM除去プロセス!32000","THM除去プロセス",32000,"粉末炭or（オゾン＋粒状炭）"]
[null,null,null,null,null,null,null,null,null,null,39,93.139083908364839,90.85807060386783,93.799101820821434,null,"2049年",null,null,"2003(平成15)",null,null,null,null,null,null,null,null,null,null,1953,17.035110779801943,null,null,null,null,null,null,null,null,null,"THM除去プロセス!40000","THM除去プロセス",40000,"不要"]
[null,null,null,null,null,null,null,null,null,null,40,94.455625239324405,92.428429629156966,94.748690333311743,null,"2050年",null,null,"2004(平成16)",null,null,null,null,null,null,null,null,null,null,1954,17.035110779801943,null,null,null,null,null,null,null,null,null,"THM除去プロセス!41000","THM除去プロセス",41000,"粉末炭or（オゾン＋粒状炭）"]
[null,null,null,null,null,null,null,null,null,null,41,95.557856603296415,93.777913033509478,95.549845573757793,null,"2051年",null,null,"2005(平成17)",null,null,null,null,null,null,null,null,null,null,1955,17.131354343529637,null,null,null,null,null,null,null,null,null,"THM除去プロセス!42000","THM除去プロセス",42000,"（オゾン＋粒状炭）"]
[null,null,null,null,null,null,null,null,null,null,42,96.469484236456083,94.924982385456531,96.21929251274716,null,"2052年",null,null,"2006(平成18)",null,null,null,null,null,null,null,null,null,null,1956,18.959982054355834,null,null,null,null,null,null,null,null,null,"THM除去プロセス!50000","THM除去プロセス",50000,"粉末炭"]
[null,null,null,null,null,null,null,null,null,null,43,97.214333935435235,95.889400455951105,96.773323300172095,null,"2053年",null,null,"2007(平成19)",null,null,null,null,null,null,null,null,null,null,1957,20.114904819088171,null,null,null,null,null,null,null,null,null,"THM除去プロセス!51000","THM除去プロセス",51000,"（オゾン＋粒状炭）"]
[null,null,null,null,null,null,null,null,null,null,44,97.815544026572084,96.691437702269937,97.227442532204662,null,"2054年",null,null,"2008(平成20)",null,null,null,null,null,null,null,null,null,null,1958,19.441199872994307,null,null,null,null,null,null,null,null,null,"THM除去プロセス!52000","THM除去プロセス",52000,"（オゾン＋粒状炭）"]
[null,null,null,null,null,null,null,null,null,null,45,98.294935522496246,97.351184468439655,97.596100943384045,null,"2055年",null,null,"2009(平成21)",null,null,null,null,null,null,null,null,null,null,1959,19.922417691632777]
[null,null,null,null,null,null,null,null,null,null,46,98.672560610229098,97.887985742586736,97.892513540124654,null,"2056年",null,null,"2010(平成22)",null,null,null,null,null,null,null,null,null,null,1960,21.077340456365118]
[null,null,null,null,null,null,null,null,null,null,47,98.966418802070677,98.320005233474731,98.128554526987173,null,"2057年",null,null,"2011(平成23)",null,null,null,null,null,null,null,null,null,null,1961,23.387185985829785]
[null,null,null,null,null,null,null,null,null,null,48,99.192321394099778,98.663916717741131,98.314718845147453,null,"2058年",null,null,"2012(平成24)",null,null,null,null,null,null,null,null,null,null,1962,24.253378059379035]
[null,null,null,null,null,null,null,null,null,null,49,99.363879433936319,98.934713532176147,98.460138705428776,null,"2059年",null,null,"2013(平成25)",null,null,null,null,null,null,null,null,null,null,1963,24.734595878017508]
[null,null,null,null,null,null,null,null,null,null,50,99.492587980536456,99.145621971844278,98.572643040887584,null,"2060年",null,null,"2014(平成26)",null,null,null,null,null,null,null,null,null,null,1964,25.600787951566762]
[null,null,null,null,null,null,null,null,null,null,51,99.587979583383827,99.308101220170798,98.658848158964176,null,"2061年",null,null,"2015(平成27)",null,null,null,null,null,null,null,null,null,null,1965,26.370736461388315]
[null,null,null,null,null,null,null,null,null,null,52,99.657822015689518,99.431911121840827,98.724268845904803,null,null,null,null,"2016(平成28)",null,null,null,null,null,null,null,null,null,null,1966,28.103120608486822]
[null,null,null,null,null,null,null,null,null,null,53,99.708338720528289,99.525229329982608,98.773440566561518,null,null,null,null,"2017(平成29)",null,null,null,null,null,null,null,null,null,null,1967,29.643017628129936]
[null,null,null,null,null,null,null,null,null,null,54,99.744434557966159,99.594800761303574,98.810045023501729,null,null,null,null,"2018(平成30)",null,null,null,null,null,null,null,null,null,null,1968,30.605453265406883]
[null,null,null,null,null,null,null,null,null,null,55,99.769913751598637,99.646104500669438,98.837033028822859,null,null,null,null,"2019(平成31)",null,null,null,null,null,null,null,null,null,null,1969,32.819055231143857]
[null,null,null,null,null,null,null,null,null,null,56,99.787681020930876,99.68352595293716,98.856740271419767,null,null,null,null,"2020(平成32)",null,null,null,null,null,null,null,null,null,null,1970,35.254017393454532]
[null,null,null,null,null,null,null,null,null,null,57,99.799920477670526,99.710524835503108,98.870993038737538,null,null,null,null,1950,null,null,null,null,null,null,null,null,null,null,1971,35.995092834157781]
[null,null,null,null,null,null,null,null,null,null,58,99.808249807249098,99.729792295985447,98.881202216931726,null,null,null,null,1951,null,null,null,null,null,null,null,null,null,null,1972,38.112451236167054]
[null,null,null,null,null,null,null,null,null,null,59,99.813849502615142,99.743392853109711,98.888444919153756,null,null,null,null,1952,null,null,null,null,null,null,null,null,null,null,1973,48.699243246213463]
[null,null,null,null,null,null,null,null,null,null,60,99.817568494279541,99.752888891370702,98.89353387557982,null,null,null,null,1953,null,null,null,null,null,null,null,null,null,null,1974,59.093548128804478]
[null,null,null,null,null,null,null,null,null,null,61,99.820008509065005,99.759447047439068,98.897075276463383,null,null,null,null,1954,null,null,null,null,null,null,null,null,null,null,1975,59.767253074898335]
[null,null,null,null,null,null,null,null,null,null,62,99.821589998009614,99.763927011957634,98.89951611868446,null,null,null,null,1955,null,null,null,null,null,null,null,null,null,null,1976,64.00196987891691]
[null,null,null,null,null,null,null,null,null,null,63,99.822602617569387,99.766954071308021,98.901182301225347,null,null,null,null,1956,null,null,null,null,null,null,null,null,null,null,1977,67.274251045658531]
[null,null,null,null,null,null,null,null,null,null,64,99.823243137890813,99.768977187531434,98.902308781803683,null,null,null,null,1957,null,null,null,null,null,null,null,null,null,null,1978,71.797698540860154]
[null,null,null,null,null,null,null,null,null,null,65,99.823643382934961,99.770314627397141,98.903063080043324,null,null,null,null,1958,null,null,null,null,null,null,null,null,null,null,1979,78.053530183160305]
[null,null,null,null,null,null,null,null,null,null,66,99.82389045603405,99.771189170523613,98.903563322716636,null,null,null,null,1959,null,null,null,null,null,null,null,null,null,null,1980,85.079310335282031]
[null,null,null,null,null,null,null,null,null,null,67,99.824041127638026,99.771754812631741,98.903891899319859,null,null,null,null,1960,null,null,null,null,null,null,null,null,null,null,1981,86.041745972558971]
[null,null,null,null,null,null,null,null,null,null,68,99.82413189794616,99.772116685288225,98.904105651617328,null,null,null,null,1961,null,null,null,null,null,null,null,null,null,null,1982,86.330476663742061]
[null,null,null,null,null,null,null,null,null,null,69,99.824185918950874,99.772345678885671,98.904243373580172,null,null,null,null,1962,null,null,null,null,null,null,null,null,null,null,1983,86.137989536286653]
[null,null,null,null,null,null,null,null,null,null,70,99.824217679496442,99.77248901130983,98.904331258401243,null,null,null,null,1963,null,null,null,null,null,null,null,null,null,null,1984,87.581642992202077]
[null,null,null,null,null,null,null,null,null,null,71,99.824236126239555,99.772577751240945,98.904386803123387,null,null,null,null,1964,null,null,null,null,null,null,null,null,null,null,1985,87.29680599712205]
[null,null,null,null,null,null,null,null,null,null,72,99.824246710436086,99.772632094698096,98.904421571945733,null,null,null,null,1965,null,null,null,null,null,null,null,null,null,null,1986,86.242728207914212]
[null,null,null,null,null,null,null,null,null,null,73,99.824252709763172,99.772665012359553,98.904443127312661,null,null,null,null,1966,null,null,null,null,null,null,null,null,null,null,1987,86.817679729300309]
[null,null,null,null,null,null,null,null,null,null,74,99.824256069100642,99.772684734961985,98.90445636277498,null,null,null,null,1967,null,null,null,null,null,null,null,null,null,null,1988,88.446709039894245]
[null,null,null,null,null,null,null,null,null,null,75,99.824257927380742,99.772696423306428,98.904464411759051,null,null,null,null,1968,null,null,null,null,null,null,null,null,null,null,1989,92.567194943161255]
[null,null,null,null,null,null,null,null,null,null,76,99.824258942869619,99.772703274958744,98.904469259744161,null,null,null,null,1969,null,null,null,null,null,null,null,null,null,null,1990,95.825253564349126]
[null,null,null,null,null,null,null,null,null,null,77,99.824259491077925,99.772707247708112,98.904472151753851,null,null,null,null,1970,null,null,null,null,null,null,null,null,null,null,1991,98.412535410586543]
[null,null,null,null,null,null,null,null,null,null,78,99.824259783440993,99.772709526163624,98.904473860417042,null,null,null,null,1971,null,null,null,null,null,null,null,null,null,null,1992,99.562438453358737]
[null,null,null,null,null,null,null,null,null,null,79,99.824259937471183,99.77271081870208,98.904474860259199,null,null,null,null,1972,null,null,null,null,null,null,null,null,null,null,1993,99.370787946230053]
[null,null,null,null,null,null,null,null,null,null,80,99.824260017638181,99.772711543972434,98.904475439720827,null,null,null,null,1973,null,null,null,null,null,null,null,null,null,null,1994,99.562438453358737]
[null,null,null,null,null,null,null,null,null,null,81,99.824260058856652,99.772711946513255,98.904475772331494,null,null,null,null,1974,null,null,null,null,null,null,null,null,null,null,1995,99.754088960487451]
[null,null,null,null,null,null,null,null,null,null,82,99.824260079792694,99.77271216750367,98.904475961420346,null,null,null,null,1975,null,null,null,null,null,null,null,null,null,null,1996,99.481212411208887]
[null,null,null,null,null,null,null,null,null,null,83,99.824260090297884,99.772712287506224,98.904476067887074,null,null,null,null,1976,null,null,null,null,null,null,null,null,null,null,1997,100.43522843598728]
[null,null,null,null,null,null,null,null,null,null,84,99.824260095505267,99.772712351961886,98.904476127258874,null,null,null,null,1977,null,null,null,null,null,null,null,null,null,null,1998,98.850657315141945]
[null,null,null,null,null,null,null,null,null,null,85,99.824260098055277,99.772712386205939,98.904476160050635,null,null,null,null,1978,null,null,null,null,null,null,null,null,null,null,1999,97.785635948937411]
[null,null,null,null,null,null,null,null,null,null,86,99.824260099288864,99.7727124042014,98.904476177988371,null,null,null,null,1979,null,null,null,null,null,null,null,null,null,null,2000,97.999183340138828]
[null,null,null,null,null,null,null,null,null,null,87,99.824260099878387,99.772712413555325,98.904476187706635,null,null,null,null,1980,null,null,null,null,null,null,null,null,null,null,2001,96.137198856676193]
[null,null,null,null,null,null,null,null,null,null,88,99.824260100156707,99.772712418364591,98.904476192921322,null,null,null,null,1981,null,null,null,null,null,null,null,null,null,null,2002,95.451204573295229]
[null,null,null,null,null,null,null,null,null,null,89,99.824260100286509,99.772712420810365,98.904476195692638,null,null,null,null,1982,null,null,null,null,null,null,null,null,null,null,2003,96.627194773376885]
[null,null,null,null,null,null,null,null,null,null,90,99.824260100346322,99.772712422040655,98.904476197151325,null,null,null,null,1983,null,null,null,null,null,null,null,null,null,null,2004,98.293180890159249]
[null,null,null,null,null,null,null,null,null,null,91,99.82426010037355,99.772712422652802,98.904476197911748,null,null,null,null,1984,null,null,null,null,null,null,null,null,null,null,2005,100]
[null,null,null,null,null,null,null,null,null,null,92,99.824260100385786,99.772712422954072,98.904476198304366,null,null,null,null,1985,null,null,null,null,null,null,null,null,null,null,2006,101.8]
[null,null,null,null,null,null,null,null,null,null,93,99.824260100391228,99.772712423100728,98.904476198505137,null,null,null,null,1986,null,null,null,null,null,null,null,null,null,null,2007,105]
[null,null,null,null,null,null,null,null,null,null,94,99.824260100393616,99.772712423171342,98.904476198606815,null,null,null,null,1987,null,null,null,null,null,null,null,null,null,null,2008,110.9]
[null,null,null,null,null,null,null,null,null,null,95,99.824260100394653,99.772712423204979,98.904476198657818,null,null,null,null,1988,null,null,null,null,null,null,null,null,null,null,2009,105.8]
[null,null,null,null,null,null,null,null,null,null,96,99.824260100395094,99.772712423220824,98.904476198683156,null,null,null,null,1989,null,null,null,null,null,null,null,null,null,null,2010,106.1]
[null,null,null,null,null,null,null,null,null,null,97,99.824260100395279,99.772712423228214,98.904476198695619,null,null,null,null,1990,null,null,null,null,null,null,null,null,null,null,2011,101]
[null,null,null,null,null,null,null,null,null,null,98,99.824260100395364,99.77271242323161,98.904476198701701,null,null,null,null,1991,null,null,null,null,null,null,null,null,null,null,2012,100.1]
[null,null,null,null,null,null,null,null,null,null,99,99.824260100395392,99.772712423233159,98.904476198704629,null,null,null,null,1992,null,null,null,null,null,null,null,null,null,null,2013,100.1]
[null,null,null,null,null,null,null,null,null,null,100,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,1993,null,null,null,null,null,null,null,null,null,null,2014,100.1]
[null,null,null,null,null,null,null,null,null,null,101,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,1994,null,null,null,null,null,null,null,null,null,null,2015,100.1]
[null,null,null,null,null,null,null,null,null,null,102,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,1995,null,null,null,null,null,null,null,null,null,null,2016,100.1]
[null,null,null,null,null,null,null,null,null,null,103,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,1996,null,null,null,null,null,null,null,null,null,null,2017,100.1]
[null,null,null,null,null,null,null,null,null,null,104,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,1997,null,null,null,null,null,null,null,null,null,null,2018,100.1]
[null,null,null,null,null,null,null,null,null,null,105,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,1998,null,null,null,null,null,null,null,null,null,null,2019,100.1]
[null,null,null,null,null,null,null,null,null,null,106,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,1999,null,null,null,null,null,null,null,null,null,null,2020,100.1]
[null,null,null,null,null,null,null,null,null,null,107,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2000]
[null,null,null,null,null,null,null,null,null,null,108,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2001]
[null,null,null,null,null,null,null,null,null,null,109,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2002]
[null,null,null,null,null,null,null,null,null,null,110,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2003]
[null,null,null,null,null,null,null,null,null,null,111,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2004]
[null,null,null,null,null,null,null,null,null,null,112,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2005]
[null,null,null,null,null,null,null,null,null,null,113,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2006]
[null,null,null,null,null,null,null,null,null,null,114,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2007]
[null,null,null,null,null,null,null,null,null,null,115,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2008]
[null,null,null,null,null,null,null,null,null,null,116,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2009]
[null,null,null,null,null,null,null,null,null,null,117,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2010]
[null,null,null,null,null,null,null,null,null,null,118,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2011]
[null,null,null,null,null,null,null,null,null,null,119,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2012]
[null,null,null,null,null,null,null,null,null,null,120,99.824260100395406,99.772712423233855,98.904476198706035,null,null,null,null,2013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]

{"sheet":"Calc","index":11,"n_rows":74,"n_cols":32,"rows_kept":74,"cut":false,"hidden":true,"merged":[[52,12,65,12],[23,12,27,12],[28,12,32,12],[42,12,45,12],[34,12,37,12],[38,12,41,12],[46,12,51,12]]}
[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":"COUNTIF($P$5:$P$68,P2)","v":7},"{RngSouiChk}"]
[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,"Key","原水レベル","浄水レベル","プロセス(原水ﾚﾍﾞﾙ+浄水ﾚﾍﾞﾙ*ｎ)",null,"推奨ﾌﾟﾛｾｽCode",null,null,null,null,null,null,"入力画面",null,"前回格納",null,null,null,null,null,null,null,null,null,null,"電気設備","機械設備","計装設備","最大影響水量","損失額"]
[null,"濁度",{"$f":"IF('入力情報(2)'!T12=1,+'入力情報(2)'!H9&\"!\"&'入力情報(2)'!F11&\"!\"&'入力情報(2)'!H11,IF('入力情報(2)'!T11=1,+'入力情報(2)'!G9&\"!\"&'入力情報(2)'!F11&\"!\"&'入力情報(2)'!G11,0))","v":0},{"$f":"VLOOKUP(C5,Mas原浄レベル,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C12,Mas原浄レベル,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"+D5+E5","v":{"$error":"#N/A"}},null,{"$f":"+B5&\"除去プロセス!\"&F5","v":{"$error":"#N/A"}},null,null,null,null,null,"作成日",{"$f":"プレビュー!G9","v":"00:00:00"},{"$f":"IF(O5=Q5,\"○\",\"×\")","v":"○"}]
[null,"TOC",{"$f":"IF('入力情報(2)'!T12=1,+'入力情報(2)'!H9&\"!\"&'入力情報(2)'!F12&\"!\"&'入力情報(2)'!H12,IF('入力情報(2)'!T11=1,+'入力情報(2)'!G9&\"!\"&'入力情報(2)'!F12&\"!\"&'入力情報(2)'!G12,0))","v":0},{"$f":"VLOOKUP(C6,Mas原浄レベル,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C13,Mas原浄レベル,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"(+D6+E6)*10","v":{"$error":"#N/A"}},null,{"$f":"+B6&\"除去プロセス!\"&F6","v":{"$error":"#N/A"}},null,"ｶｰｿﾙ移動設定",false,null,null,"事業体名",{"$f":"プレビュー!G10","v":0},"○"]
[null,"カビ臭",{"$f":"IF('入力情報(2)'!T12=1,+'入力情報(2)'!H9&\"!\"&'入力情報(2)'!F13&\"!\"&'入力情報(2)'!H13,IF('入力情報(2)'!T11=1,+'入力情報(2)'!G9&\"!\"&'入力情報(2)'!F13&\"!\"&'入力情報(2)'!G13,0))","v":0},{"$f":"VLOOKUP(C7,Mas原浄レベル,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C14,Mas原浄レベル,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"(+D7+E7)*100","v":{"$error":"#N/A"}},null,{"$f":"+B7&\"除去プロセス!\"&F7","v":{"$error":"#N/A"}},null,"移動方向",-4121,null,null,"所在地",{"$f":"プレビュー!G11","v":"　"},"×"]
[null,"THM",{"$f":"IF('入力情報(2)'!T12=1,+'入力情報(2)'!H9&\"!\"&'入力情報(2)'!F14&\"!\"&'入力情報(2)'!H14,IF('入力情報(2)'!T11=1,+'入力情報(2)'!G9&\"!\"&'入力情報(2)'!F14&\"!\"&'入力情報(2)'!G14,0))","v":0},{"$f":"VLOOKUP(C8,Mas原浄レベル,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C15,Mas原浄レベル,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"(+D8+E8)*1000","v":{"$error":"#N/A"}},null,{"$f":"+B8&\"除去プロセス!\"&F8","v":{"$error":"#N/A"}},null,null,null,null,null,"記入者",{"$f":"プレビュー!G12","v":0},"○"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"所属",{"$f":"プレビュー!G13","v":0},"○"]
[null,null,"プロセス選定",null,null,null,null,null,null,null,null,null,null,"連絡先",{"$f":"プレビュー!G14","v":0},"○"]
[null,null,"Key","原水レベル","浄水レベル","推奨プロセス",null,"■ﾘｽｸ損害額 影響水量■",null,null,null,null,null,"浄水場名",{"$f":"プレビュー!$G$19","v":0},"○"]
[null,"濁度",{"$f":"+'入力情報(2)'!I9&\"!\"&'入力情報(2)'!F11&\"!\"&'入力情報(2)'!I11","v":"浄水レベル!濁度!"},{"$f":"VLOOKUP(C5,Mas原浄レベル,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C12,Mas原浄レベル,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(H5,Mas濁度除去プロセス,4,FALSE)","v":{"$error":"#N/A"}},null,"機械故障率",0.20910000000000001,0.75580000000000003,0.24679999999999999,null,null,"現在の浄水量（日最大）",{"$f":"プレビュー!H20","v":0},"○"]
[null,"TOC",{"$f":"+'入力情報(2)'!I9&\"!\"&'入力情報(2)'!F12&\"!\"&'入力情報(2)'!I12","v":"浄水レベル!TOC!"},{"$f":"VLOOKUP(C6,Mas原浄レベル,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C13,Mas原浄レベル,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(H6,Mas濁度除去プロセス,4,FALSE)","v":{"$error":"#N/A"}},"{ProTOC}","電気故障率",0.2661,2.3485999999999998,2.2706,null,null,"現在の給水人口",{"$f":"プレビュー!H21","v":0},"○"]
[null,"カビ臭",{"$f":"+'入力情報(2)'!I9&\"!\"&'入力情報(2)'!F13&\"!\"&'入力情報(2)'!I13","v":"浄水レベル!カビ臭!"},{"$f":"VLOOKUP(C7,Mas原浄レベル,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C14,Mas原浄レベル,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(H7,Mas濁度除去プロセス,4,FALSE)","v":{"$error":"#N/A"}},"{ProKabi}","計装故障率",0.30580000000000002,1.9823,1.2911999999999999,null,null,"給水原価",{"$f":"プレビュー!H22","v":0},"○"]
[null,"THM",{"$f":"+'入力情報(2)'!I9&\"!\"&B15&\"!\"&'入力情報(2)'!I14","v":"浄水レベル!THM!"},{"$f":"VLOOKUP(C8,Mas原浄レベル,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C15,Mas原浄レベル,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(H8,Mas濁度除去プロセス,4,FALSE)","v":{"$error":"#N/A"}},"{ProTHM}",null,null,null,null,null,null,"原水種類",{"$f":"プレビュー!H23","v":0},"○"]
[null,null,null,null,null,null,null,"■影響水量■",null,null,null,null,null,"浄水フロー",{"$f":"プレビュー!H24","v":0},"○"]
[null,null,null,null,null,null,null,"ﾊﾞｯｸｱｯﾌﾟ率",0.6,"{RiskBackupPer}",null,null,null,"粉末炭の有無",{"$f":"プレビュー!H25","v":0},"○"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"粉末炭平均注入率",{"$f":"プレビュー!H26","v":0},"○"]
[null,null,null,null,null,null,null,"■被害額■",null,null,null,null,null,"粉末炭注入日数",{"$f":"プレビュー!H27","v":0},"○"]
[null,null,null,null,null,null,null,"給水人口に換算",0.3,"{RiskJinkou}",null,null,null,"主要設備の最小系列数",{"$f":"プレビュー!H28","v":0},"○"]
[null,null,null,null,"{CalSumFlg}",null,null,"1人1日当たりの給水量",3,"{RiskKyusui}",null,null,null,"その系列名称",{"$f":"プレビュー!H29","v":0},"○"]
[null,null,null,"系列の集計",null,null,null,"単価(統計数字)",7428,"{RiskTanka}",null,null,null,"その系入力",{"$f":"プレビュー!H30","v":0},"○"]
[null,null,null,null,null,null,null,"日数",5,"{RiskDay}",null,null,null,"メンテナンスレベル",{"$f":"プレビュー!H31","v":0},"○"]
[null,null,null,null,null,null,null,null,null,null,null,null,"建設(更新)年","建築構造物",{"$f":"プレビュー!H37","v":0},"○"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"土木構造物",{"$f":"プレビュー!H38","v":0},"○"]
[null,null,null,null,"{Cal浄水No}","現在の浄水ﾌﾛｰ","粉末炭",null,null,null,null,null,null,"電気設備",{"$f":"プレビュー!H39","v":0},"○"]
[null,null,null,"浄水ﾌﾛｰ分類No.",{"$f":"IF(ISERROR(VLOOKUP(Cal浄水フロー,Master!$F$6:$G$13,2,FALSE)),0,VLOOKUP(Cal浄水フロー,Master!$F$6:$G$13,2,FALSE))","v":0},{"$f":"IF(+'入力情報(1)'!H28=\"凝集+沈澱+急速ろ過\",G27&'入力情報(1)'!H28,+'入力情報(1)'!H28)","v":0},{"$f":"IF('入力情報(1)'!H29=\"有\",\"粉末炭+\",\"\")","v":""},null,null,null,null,null,null,"機械設備",{"$f":"プレビュー!H40","v":0},"○"]
[null,null,null,null,null,"{Cal浄水フロー}",null,null,null,null,null,null,null,"計装設備",{"$f":"プレビュー!H41","v":0},"○"]
[null,null,null,"■浄水フロー　設備費■",null,null,null,"■高度処理による便益■",null,null,null,null,"取得金額","建築構造物",{"$f":"プレビュー!I37","v":0},"○"]
[null,null,null,"電気",{"$f":"VLOOKUP(Cal浄水No,設備費と運転費!$B$20:$M$33,8,FALSE)*10000","v":{"$error":"#N/A"}},"{Cal電気_浄水Flw}",null,null,"浄水フロー","推奨フロー",null,null,null,"土木構造物",{"$f":"プレビュー!I38","v":0},"○"]
[null,null,null,"機械",{"$f":"VLOOKUP(Cal浄水No,設備費と運転費!$B$20:$M$33,9,FALSE)*10000","v":{"$error":"#N/A"}},"{Cal機械_浄水Flw}",null,"粉末炭",{"$f":"IF(ISERROR(FIND(H31,Cal浄水フロー)),0,FIND(H31,Cal浄水フロー))","v":0},{"$f":"IF(ISERROR(FIND(H31,Cal希望浄水フロー)),0,FIND(H31,Cal希望浄水フロー))","v":0},null,null,null,"電気設備",{"$f":"プレビュー!I39","v":0},"○"]
[null,null,null,"計装",{"$f":"VLOOKUP(Cal浄水No,設備費と運転費!$B$20:$M$33,10,FALSE)*10000","v":{"$error":"#N/A"}},"{Cal計装_浄水Flw}",null,"粒状炭",{"$f":"IF(ISERROR(FIND(H32,Cal浄水フロー)),0,FIND(H32,Cal浄水フロー))","v":0},{"$f":"IF(ISERROR(FIND(H32,Cal希望浄水フロー)),0,FIND(H32,Cal希望浄水フロー))","v":0},null,null,null,"機械設備",{"$f":"プレビュー!I40","v":0},"○"]
[null,null,null,"土木",{"$f":"VLOOKUP(Cal浄水No,設備費と運転費!$B$20:$M$33,11,FALSE)*10000","v":{"$error":"#N/A"}},"{Cal土木_浄水Flw}",null,"オゾン",{"$f":"IF(ISERROR(FIND(H33,Cal浄水フロー)),0,FIND(H33,Cal浄水フロー))","v":0},{"$f":"IF(ISERROR(FIND(H33,Cal希望浄水フロー)),0,FIND(H33,Cal希望浄水フロー))","v":0},null,null,null,"計装設備",{"$f":"プレビュー!I41","v":0},"○"]
[null,null,null,"建築",{"$f":"VLOOKUP(Cal浄水No,設備費と運転費!$B$20:$M$33,12,FALSE)*10000","v":{"$error":"#N/A"}},"{Cal建築_浄水Flw}",null,"高度処理判定",{"$f":"SUM(I31:I33)","v":0},{"$f":"SUM(J31:J33)","v":0},null,null,null,"更新する場合の浄水量",{"$f":"プレビュー!H45","v":0},"○"]
[null,null,null,"合計",{"$f":"SUM(E30:E34)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"現状の原水水質","濁度",{"$f":"プレビュー!G50","v":0},"○"]
[null,null,null,null,"{Cal希望浄水No}","推奨浄水ﾌﾛｰ","粉末炭",null,null,null,null,null,null,"TOC",{"$f":"プレビュー!G51","v":0},"○"]
[null,null,null,"浄水ﾌﾛｰ分類No.",{"$f":"IF(ISERROR(VLOOKUP(F37,Master!$F$24:$G$37,2,FALSE)),0,VLOOKUP(F37,Master!$F$24:$G$37,2,FALSE))","v":0},{"$f":"+'入力情報(2)'!G26","v":0},{"$f":"IF(Cal希望浄水フロー=0,\"\",IF(ISERROR(FIND(\"粉末炭\",Cal希望浄水フロー)),\"無\",\"有\"))","v":""},null,null,null,null,null,null,"カビ臭",{"$f":"プレビュー!G52","v":0},"○"]
[null,null,null,null,null,"{Cal希望浄水フロー}",null,null,null,null,null,null,null,"THMFP",{"$f":"プレビュー!G53","v":0},"○"]
[null,null,null,"■希望フロー　設備費■",null,null,null,"■ｸﾘﾌﾟﾄｽﾎﾟﾘｼﾞｳﾑによる便益(膜ろ過)■",null,null,null,null,"将来予想される原水水質","濁度",{"$f":"プレビュー!H50","v":0},"○"]
[null,null,null,"電気",{"$f":"VLOOKUP(Cal希望浄水No,設備費と運転費!$B$20:$M$33,8,FALSE)*10000","v":{"$error":"#N/A"}},"{Cal電気_希望Flw}",null,null,"浄水フロー","推奨フロー",null,null,null,"TOC",{"$f":"プレビュー!H51","v":0},"○"]
[null,null,null,"機械",{"$f":"VLOOKUP(Cal希望浄水No,設備費と運転費!$B$20:$M$33,9,FALSE)*10000","v":{"$error":"#N/A"}},"{Cal機械_希望Flw}",null,"膜ろ過",{"$f":"IF(ISERROR(FIND(H41,Cal浄水フロー)),0,FIND(H41,Cal浄水フロー))","v":0},{"$f":"IF(ISERROR(FIND(H41,Cal希望浄水フロー)),0,FIND(H41,Cal希望浄水フロー))","v":0},null,null,null,"カビ臭",{"$f":"プレビュー!H52","v":0},"○"]
[null,null,null,"計装",{"$f":"VLOOKUP(Cal希望浄水No,設備費と運転費!$B$20:$M$33,10,FALSE)*10000","v":{"$error":"#N/A"}},"{Cal計装_希望Flw}",null,null,null,null,null,null,null,"THMFP",{"$f":"プレビュー!H53","v":0},"○"]
[null,null,null,"土木",{"$f":"VLOOKUP(Cal希望浄水No,設備費と運転費!$B$20:$M$33,11,FALSE)*10000","v":{"$error":"#N/A"}},"{Cal土木_希望Flw}",null,null,null,null,null,null,"要求される浄水水質","濁度",{"$f":"プレビュー!I50","v":0},"○"]
[null,null,null,"建築",{"$f":"VLOOKUP(Cal希望浄水No,設備費と運転費!$B$20:$M$33,12,FALSE)*10000","v":{"$error":"#N/A"}},"{Cal建築_希望Flw}",null,null,null,null,null,null,null,"TOC",{"$f":"プレビュー!I51","v":0},"○"]
[null,null,null,"合計",{"$f":"SUM(E40:E44)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"カビ臭",{"$f":"プレビュー!I52","v":0},"○"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"THMFP",{"$f":"プレビュー!I53","v":0},"○"]
[null,null,null,null,null,null,null,null,null,null,null,null,"シナリオ選択","推奨フロー",{"$f":"プレビュー!G55","v":0},"○"]
[null,null,null,"■運転費原価■",null,null,null,"■粉末炭の運転費係数■",null,null,null,null,null,"シナリオ１",null,"○"]
[null,null,null,"希望フロー",{"$f":"VLOOKUP(Cal希望浄水No,設備費と運転費!$B$38:$J$51,9,FALSE)","v":{"$error":"#N/A"}},null,null,"粉末炭平均注入率",10," {CalFuntanPer}",null,null,null,"シナリオ２",{"$f":"プレビュー!E63","v":""},"○"]
[null,null,null,null,null,null,null,"粉末炭注入日数",365," {CalFuntanDay}",null,null,null,"シナリオ３",{"$f":"プレビュー!E64","v":""},"○"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"シナリオ４",{"$f":"プレビュー!E65","v":""},"○"]
[null,null,null,null,null,null,null,"■マスター変更既定値■",null,null,null,null,null,"シナリオ５",{"$f":"プレビュー!E66","v":""},"○"]
[null,null,null,null,null,null,null,"修繕費補正係数",0.3,null,null,null,"ﾏｽﾀｰ変更","修繕費補正係数",{"$f":"マスター変更!$C$7","v":0.3},"○",0.3]
[null,null,null,null,null,null,null,"【設備費】",null,null,null,null,null,"設備費基準金額",{"$f":"マスター変更!$C$10","v":159900},{"$f":"IF(O54=Q54,\"○\",\"×\")","v":"○"},159900]
[null,null,null,null,null,null,null,"設備費基準金額",159900,null,null,null,null,"基準給水原価",{"$f":"マスター変更!C19","v":180},"○",180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"変動費係数",{"$f":"マスター変更!C20","v":0.1},"×",0.13]
[null,null,null,null,null,null,null,"【運転費】",null,null,null,null,null,"職員労務単価",{"$f":"マスター変更!C25","v":30000},"○",30000]
[null,null,null,null,null,null,null,"１．変動費（電力、燃料、薬品費）",null,null,null,null,null,"職員数",{"$f":"マスター変更!C26","v":16},"○",16]
[null,null,null,null,null,null,null,"基準給水原価",180,null,null,null,null,"外注労務単価",{"$f":"マスター変更!C27","v":22000},"×",24000]
[null,null,null,null,null,null,null,"変動費係数",0.1,null,null,null,null,"外注者数",{"$f":"マスター変更!C28","v":6},"○",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"浄水量",{"$f":"マスター変更!F30","v":20000},"○",20000]
[null,null,null,null,null,null,null,"２．人件費",null,null,null,null,null,"職員労務単価",{"$f":"マスター変更!C33","v":30000},"○",30000]
[null,null,null,null,null,null,null,"人件費①：浄水フローに”膜ろ過”を含まない場合",null,null,null,null,null,"職員数",{"$f":"マスター変更!C34","v":9},"×",12]
[null,null,null,null,null,null,null,"職員労務単価",30000,null,null,null,null,"外注労務単価",{"$f":"マスター変更!C35","v":22000},"×",24000]
[null,null,null,null,null,null,null,"職員数",16,null,null,null,null,"外注者数",{"$f":"マスター変更!C36","v":10},"×",6]
[null,null,null,null,null,null,null,"外注労務単価",22000,"浄水量",null,null,null,"浄水量",{"$f":"マスター変更!F38","v":20000},"○",20000]
[null,null,null,null,null,null,null,"外注者数",6,20000,"m3/日",null,null,"次回更新",{"$f":"+プレビュー!G61","v":"現状設備の更新時期での更新"},"○","現状設備の更新時期での更新"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"次回更新年",{"$f":"+プレビュー!I61","v":"2012年"},"×",0]
[]
[null,null,null,null,null,null,null,"人件費②：浄水フローが”膜ろ過”を含む場合"]
[null,null,null,null,null,null,null,"職員労務単価",30000]
[null,null,null,null,null,null,null,"職員数",9]
[null,null,null,null,null,null,null,"外注労務単価",22000,"浄水量"]
[null,null,null,null,null,null,null,"外注者数",10,20000,"m3/日"]

{"sheet":"経年故障率表","index":12,"n_rows":197,"n_cols":21,"rows_kept":197,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"耐用年数","更新率","故障率",null,null,null,null,"耐用年数","更新率","故障率",null,null,null,null,"耐用年数","更新率","故障率"]
[null,null,null,null,{"$f":"+RngEnchou機械","v":1.3709904419425603},1.37,null,null,null,null,null,{"$f":"+RngEnchou電気","v":1.3317300341540892},1.33,null,null,null,null,null,{"$f":"+RngEnchou計装","v":1.3337090957867057},1.33]
[null,"(年)",null,{"$f":"+Master!AB8","v":15},{"$f":"ROUND(+D3*E2,0)","v":21},{"$f":"ROUND(+D3*F2,0)+1","v":22},null,null,"(年)",null,{"$f":"+Master!AB7","v":20},{"$f":"ROUND(+K3*L2,0)","v":27},{"$f":"ROUND(+K3*M2,0)+1","v":28},null,null,"(年)",null,{"$f":"+Master!AB9","v":10},{"$f":"ROUND(+R3*S2,0)","v":13},{"$f":"ROUND(+R3*T2,0)+1","v":14}]
[]
[]
[]
[]
[null,null,null,"■リスク損害額"]
[]
[]
[null,null,null,"経過","機械設備",null,null,null,null,null,"経過","電気設備",null,null,null,null,null,"経過","計装設備"]
[]
[null,"(年)",null,"年数","更新率","故障率及び\n修繕費係数","修繕実施",null,"(年)",null,"年数","更新率","故障率及び\n修繕費係数","修繕実施",null,"(年)",null,"年数","更新率","故障率及び\n修繕費係数","修繕実施"]
[null,{"$f":"+'入力情報(1)'!H44","v":0},{"$f":"B14+1","v":1},0,{"$f":"VLOOKUP(D14,Rng更新率表,2,FALSE)/$E$2/100","v":5.3475865129854079E-4},0,{"$f":"IF(F14<>0,\"修繕\",\"\")","v":""},null,{"$f":"+'入力情報(1)'!H43","v":0},null,0,{"$f":"VLOOKUP(K14,Rng更新率表,3,FALSE)/$L$2/100","v":6.4973711734608961E-4},0,{"$f":"IF(M14<>0,\"修繕\",\"\")","v":""},null,{"$f":"+'入力情報(1)'!H45","v":0},null,0,{"$f":"VLOOKUP(R14,Rng更新率表,4,FALSE)/$S$2/100","v":2.3779120246063198E-3},0,{"$f":"IF(T14<>0,\"修繕\",\"\")","v":""}]
[null,{"$f":"B14+1","v":1},2,{"$f":"D14+1","v":1},1.263776420777284E-3,0,"",null,{"$f":"I14+1","v":1},null,{"$f":"K14+1","v":1},1.5142368696837098E-3,0,"",null,{"$f":"P14+1","v":1},null,{"$f":"R14+1","v":1},5.326721693302657E-3,0,""]
[null,2,3,2,2.2455805591867998E-3,0,"",null,2,null,2,2.6519836207836377E-3,0,"",null,2,null,2,8.9484507496295981E-3,0,""]
[null,3,4,3,3.5518057406566245E-3,0,"",null,3,null,3,4.1330682328321053E-3,0,"",null,3,null,3,1.3354034174650089E-2,0,""]
[null,4,5,4,5.2685977950853334E-3,0,"",null,4,null,4,6.0401427827682409E-3,0,"",null,4,null,4,1.8661768279256228E-2,0,""]
[null,5,6,5,7.4976682046511379E-3,0,"",null,5,null,5,8.4690392663121904E-3,0,"",null,5,null,5,2.4995113245109973E-2,0,""]
[null,6,7,6,1.0356814173799904E-2,0,"",null,6,null,6,1.1528915614542355E-2,0,"",null,6,null,6,3.2479830278607319E-2,0,""]
[null,7,8,7,1.397970559919273E-2,0,"",null,7,null,7,1.5341788107479522E-2,0,"",null,7,null,7,4.1240471300598332E-2,0,""]
[null,8,9,8,1.8514741807155514E-2,0,"",null,8,null,8,2.0041315903188042E-2,0,"",null,8,null,8,5.1396283012310022E-2,0,""]
[null,9,10,9,2.4122801764453847E-2,0,"",null,9,null,9,2.5770723215069721E-2,0,"",null,9,null,9,6.3056634788685326E-2,0,""]
[null,10,11,10,3.0973754742969341E-2,0,"",null,10,null,10,3.2679779143121007E-2,0,"",null,10,null,10,7.6316127885333096E-2,0,""]
[null,11,12,11,3.9241665393583702E-2,0,"",null,11,null,11,4.0920804558107926E-2,0,"",null,11,null,11,9.1249588025132736E-2,0,""]
[null,12,13,12,4.9098716581751828E-2,0,"",null,12,null,12,5.0643738466469135E-2,0,"",null,12,null,12,0.10790718035977889,0,""]
[null,13,14,13,6.0707980876459011E-2,0,"",null,13,null,13,6.1990369915522446E-2,0,"",null,13,null,13,0.12630991094652183,0,""]
[null,14,15,14,7.4215289848135815E-2,0,"",null,14,null,14,7.5087920932135163E-2,0,"",null,14,null,14,0.14644578859777918,0,""]
[null,15,16,15,8.974056905674066E-2,0,"",null,15,null,15,9.0042244859220813E-2,0,"",null,15,null,15,0.16826691253287762,0,""]
[null,16,17,16,0.10736911345421676,0,"",null,16,null,16,0.10693097528325249,0,"",null,16,null,16,0.19168772328260214,0,""]
[null,17,18,17,0.12714335967336815,0,"",null,17,null,17,0.12579701560953424,0,"",null,17,null,17,0.21658460696898715,0,""]
[null,18,19,18,0.14905575580614955,0,"",null,18,null,18,0.14664279071925312,0,"",null,18,null,18,0.24279697835697406,0,""]
[null,19,20,19,0.17304332568124092,0,"",null,19,null,19,0.16942568384232018,0,"",null,19,null,0,2.3779120246063198E-3,0,""]
[null,20,21,20,0.19898446729095756,0,"",null,20,null,20,0.19405504983783065,0,"",null,20,null,1,5.326721693302657E-3,0,""]
[null,21,22,21,0.22669841322606488,0,"",null,21,null,21,0.22039112948795647,0,"",null,21,null,2,8.9484507496295981E-3,0,""]
[null,22,23,22,0.25594762019822187,0,"",null,22,null,22,0.24824609059987915,0,"",null,22,null,3,1.3354034174650089E-2,0,""]
[null,23,24,23,0.28644315648684565,0,"",null,23,null,23,0.27738729659584255,0,"",null,23,null,4,1.8661768279256228E-2,0,""]
[null,24,25,0,5.3475865129854079E-4,0,"",null,24,null,24,0.30754276093727939,0,"",null,24,null,5,2.4995113245109973E-2,0,""]
[null,25,26,1,1.263776420777284E-3,0,"",null,25,null,25,0.33840859766200565,0,"",null,25,null,6,3.2479830278607319E-2,0,""]
[null,26,27,2,2.2455805591867998E-3,0,"",null,26,null,26,0.36965813729489638,0,"",null,26,null,7,4.1240471300598332E-2,0,""]
[null,27,28,3,3.5518057406566245E-3,0,"",null,27,null,27,0.40095225616252256,0,"",null,27,null,8,5.1396283012310022E-2,0,""]
[null,28,29,4,5.2685977950853334E-3,0,"",null,28,null,28,0.4319503770012138,{"$f":"VLOOKUP(K42,Rng更新率表,3,FALSE)/$L$2/100","v":0.4319503770012138},"修繕",null,28,null,9,6.3056634788685326E-2,0,""]
[null,29,30,5,7.4976682046511379E-3,0,"",null,29,null,0,6.4973711734608961E-4,0,"",null,29,null,10,7.6316127885333096E-2,0,""]
[null,30,31,6,1.0356814173799904E-2,0,"",null,30,null,1,1.5142368696837098E-3,0,"",null,30,null,11,9.1249588025132736E-2,0,""]
[null,31,32,7,1.397970559919273E-2,0,"",null,31,null,2,2.6519836207836377E-3,0,"",null,31,null,12,0.10790718035977889,0,""]
[null,32,{"$f":"B46+1","v":33},8,{"$f":"VLOOKUP(D46,Rng更新率表,2,FALSE)/$E$2/100","v":1.8514741807155514E-2},0,{"$f":"IF(F46<>0,\"修繕\",\"\")","v":""},null,32,null,3,{"$f":"VLOOKUP(K46,Rng更新率表,3,FALSE)/$L$2/100","v":4.1330682328321053E-3},0,{"$f":"IF(M46<>0,\"修繕\",\"\")","v":""},null,32,null,13,{"$f":"VLOOKUP(R46,Rng更新率表,4,FALSE)/$S$2/100","v":0.12630991094652183},0,{"$f":"IF(T46<>0,\"修繕\",\"\")","v":""}]
[null,{"$f":"B46+1","v":33},34,{"$f":"D46+1","v":9},2.4122801764453847E-2,0,"",null,{"$f":"I46+1","v":33},null,{"$f":"K46+1","v":4},6.0401427827682409E-3,0,"",null,{"$f":"P46+1","v":33},null,0,2.3779120246063198E-3,0,""]
[null,34,35,10,3.0973754742969341E-2,0,"",null,34,null,5,8.4690392663121904E-3,0,"",null,34,null,{"$f":"R47+1","v":1},5.326721693302657E-3,0,""]
[null,35,36,11,3.9241665393583702E-2,0,"",null,35,null,6,1.1528915614542355E-2,0,"",null,35,null,2,8.9484507496295981E-3,0,""]
[null,36,37,12,4.9098716581751828E-2,0,"",null,36,null,7,1.5341788107479522E-2,0,"",null,36,null,3,1.3354034174650089E-2,0,""]
[null,37,38,13,6.0707980876459011E-2,0,"",null,37,null,8,2.0041315903188042E-2,0,"",null,37,null,4,1.8661768279256228E-2,0,""]
[null,38,39,14,7.4215289848135815E-2,0,"",null,38,null,9,2.5770723215069721E-2,0,"",null,38,null,5,2.4995113245109973E-2,0,""]
[null,39,40,15,8.974056905674066E-2,0,"",null,39,null,10,3.2679779143121007E-2,0,"",null,39,null,6,3.2479830278607319E-2,0,""]
[null,40,41,16,0.10736911345421676,0,"",null,40,null,11,4.0920804558107926E-2,0,"",null,40,null,7,4.1240471300598332E-2,0,""]
[null,41,42,17,0.12714335967336815,0,"",null,41,null,12,5.0643738466469135E-2,0,"",null,41,null,8,5.1396283012310022E-2,0,""]
[null,42,43,18,0.14905575580614955,0,"",null,42,null,13,6.1990369915522446E-2,0,"",null,42,null,9,6.3056634788685326E-2,0,""]
[null,43,44,19,0.17304332568124092,0,"",null,43,null,14,7.5087920932135163E-2,0,"",null,43,null,10,7.6316127885333096E-2,0,""]
[null,44,45,20,0.19898446729095756,0,"",null,44,null,15,9.0042244859220813E-2,0,"",null,44,null,11,9.1249588025132736E-2,0,""]
[null,45,46,21,0.22669841322606488,0,"",null,45,null,16,0.10693097528325249,0,"",null,45,null,12,0.10790718035977889,0,""]
[null,46,47,0,5.3475865129854079E-4,0,"",null,46,null,17,0.12579701560953424,0,"",null,46,null,13,0.12630991094652183,0,""]
[null,47,48,1,1.263776420777284E-3,0,"",null,47,null,18,0.14664279071925312,0,"",null,47,null,0,2.3779120246063198E-3,0,""]
[null,48,49,2,2.2455805591867998E-3,0,"",null,48,null,19,0.16942568384232018,0,"",null,48,null,1,5.326721693302657E-3,0,""]
[null,49,50,3,3.5518057406566245E-3,0,"",null,49,null,20,0.19405504983783065,0,"",null,49,null,2,8.9484507496295981E-3,0,""]
[null,50,51,4,5.2685977950853334E-3,0,"",null,50,null,21,0.22039112948795647,0,"",null,50,null,3,1.3354034174650089E-2,0,""]
[null,51,52,5,7.4976682046511379E-3,0,"",null,51,null,22,0.24824609059987915,0,"",null,51,null,4,1.8661768279256228E-2,0,""]
[null,52,53,6,1.0356814173799904E-2,0,"",null,52,null,23,0.27738729659584255,0,"",null,52,null,5,2.4995113245109973E-2,0,""]
[null,53,54,7,1.397970559919273E-2,0,"",null,53,null,24,0.30754276093727939,0,"",null,53,null,6,3.2479830278607319E-2,0,""]
[null,54,55,8,1.8514741807155514E-2,0,"",null,54,null,25,0.33840859766200565,0,"",null,54,null,7,4.1240471300598332E-2,0,""]
[null,55,56,9,2.4122801764453847E-2,0,"",null,55,null,26,0.36965813729489638,0,"",null,55,null,8,5.1396283012310022E-2,0,""]
[null,56,57,10,3.0973754742969341E-2,0,"",null,56,null,27,0.40095225616252256,0,"",null,56,null,9,6.3056634788685326E-2,0,""]
[null,57,58,11,3.9241665393583702E-2,0,"",null,57,null,28,0.4319503770012138,{"$f":"VLOOKUP(K71,Rng更新率表,3,FALSE)/$L$2/100","v":0.4319503770012138},"修繕",null,57,null,10,7.6316127885333096E-2,0,""]
[null,58,59,12,4.9098716581751828E-2,0,"",null,58,null,0,6.4973711734608961E-4,0,"",null,58,null,11,9.1249588025132736E-2,0,""]
[null,59,60,13,6.0707980876459011E-2,0,"",null,59,null,1,1.5142368696837098E-3,0,"",null,59,null,12,0.10790718035977889,0,""]
[null,60,61,14,7.4215289848135815E-2,0,"",null,60,null,2,2.6519836207836377E-3,0,"",null,60,null,13,0.12630991094652183,0,""]
[null,61,62,15,8.974056905674066E-2,0,"",null,61,null,3,4.1330682328321053E-3,0,"",null,61,null,0,2.3779120246063198E-3,0,""]
[null,62,63,16,0.10736911345421676,0,"",null,62,null,4,6.0401427827682409E-3,0,"",null,62,null,1,5.326721693302657E-3,0,""]
[null,63,64,17,0.12714335967336815,0,"",null,63,null,5,8.4690392663121904E-3,0,"",null,63,null,2,8.9484507496295981E-3,0,""]
[null,64,{"$f":"B78+1","v":65},18,{"$f":"VLOOKUP(D78,Rng更新率表,2,FALSE)/$E$2/100","v":0.14905575580614955},0,{"$f":"IF(F78<>0,\"修繕\",\"\")","v":""},null,64,null,6,{"$f":"VLOOKUP(K78,Rng更新率表,3,FALSE)/$L$2/100","v":1.1528915614542355E-2},0,{"$f":"IF(M78<>0,\"修繕\",\"\")","v":""},null,64,null,3,{"$f":"VLOOKUP(R78,Rng更新率表,4,FALSE)/$S$2/100","v":1.3354034174650089E-2},0,{"$f":"IF(T78<>0,\"修繕\",\"\")","v":""}]
[null,{"$f":"B78+1","v":65},66,{"$f":"D78+1","v":19},0.17304332568124092,0,"",null,{"$f":"I78+1","v":65},null,{"$f":"K78+1","v":7},1.5341788107479522E-2,0,"",null,{"$f":"P78+1","v":65},null,{"$f":"R78+1","v":4},1.8661768279256228E-2,0,""]
[null,66,67,20,0.19898446729095756,0,"",null,66,null,8,2.0041315903188042E-2,0,"",null,66,null,5,2.4995113245109973E-2,0,""]
[null,67,68,21,0.22669841322606488,0,"",null,67,null,9,2.5770723215069721E-2,0,"",null,67,null,6,3.2479830278607319E-2,0,""]
[null,68,69,0,5.3475865129854079E-4,0,"",null,68,null,10,3.2679779143121007E-2,0,"",null,68,null,7,4.1240471300598332E-2,0,""]
[null,69,70,1,1.263776420777284E-3,0,"",null,69,null,11,4.0920804558107926E-2,0,"",null,69,null,8,5.1396283012310022E-2,0,""]
[null,70,71,2,2.2455805591867998E-3,0,"",null,70,null,12,5.0643738466469135E-2,0,"",null,70,null,9,6.3056634788685326E-2,0,""]
[null,71,72,3,3.5518057406566245E-3,0,"",null,71,null,13,6.1990369915522446E-2,0,"",null,71,null,10,7.6316127885333096E-2,0,""]
[null,72,73,4,5.2685977950853334E-3,0,"",null,72,null,14,7.5087920932135163E-2,0,"",null,72,null,11,9.1249588025132736E-2,0,""]
[null,73,74,5,7.4976682046511379E-3,0,"",null,73,null,15,9.0042244859220813E-2,0,"",null,73,null,12,0.10790718035977889,0,""]
[null,74,75,6,1.0356814173799904E-2,0,"",null,74,null,16,0.10693097528325249,0,"",null,74,null,13,0.12630991094652183,0,""]
[null,75,76,7,1.397970559919273E-2,0,"",null,75,null,17,0.12579701560953424,0,"",null,75,null,0,2.3779120246063198E-3,0,""]
[null,76,77,8,1.8514741807155514E-2,0,"",null,76,null,18,0.14664279071925312,0,"",null,76,null,1,5.326721693302657E-3,0,""]
[null,77,78,9,2.4122801764453847E-2,0,"",null,77,null,19,0.16942568384232018,0,"",null,77,null,2,8.9484507496295981E-3,0,""]
[null,78,79,10,3.0973754742969341E-2,0,"",null,78,null,20,0.19405504983783065,0,"",null,78,null,3,1.3354034174650089E-2,0,""]
[null,79,80,11,3.9241665393583702E-2,0,"",null,79,null,21,0.22039112948795647,0,"",null,79,null,4,1.8661768279256228E-2,0,""]
[null,80,81,12,4.9098716581751828E-2,0,"",null,80,null,22,0.24824609059987915,0,"",null,80,null,5,2.4995113245109973E-2,0,""]
[null,81,82,13,6.0707980876459011E-2,0,"",null,81,null,23,0.27738729659584255,0,"",null,81,null,6,3.2479830278607319E-2,0,""]
[null,82,83,14,7.4215289848135815E-2,0,"",null,82,null,24,0.30754276093727939,0,"",null,82,null,7,4.1240471300598332E-2,0,""]
[null,83,84,15,8.974056905674066E-2,0,"",null,83,null,25,0.33840859766200565,0,"",null,83,null,8,5.1396283012310022E-2,0,""]
[null,84,85,16,0.10736911345421676,0,"",null,84,null,26,0.36965813729489638,0,"",null,84,null,9,6.3056634788685326E-2,0,""]
[null,85,86,17,0.12714335967336815,0,"",null,85,null,27,0.40095225616252256,0,"",null,85,null,10,7.6316127885333096E-2,0,""]
[null,86,87,18,0.14905575580614955,0,"",null,86,null,28,0.4319503770012138,{"$f":"VLOOKUP(K100,Rng更新率表,3,FALSE)/$L$2/100","v":0.4319503770012138},"修繕",null,86,null,11,9.1249588025132736E-2,0,""]
[null,87,88,19,0.17304332568124092,0,"",null,87,null,0,6.4973711734608961E-4,0,"",null,87,null,12,0.10790718035977889,0,""]
[null,88,89,20,0.19898446729095756,0,"",null,88,null,1,1.5142368696837098E-3,0,"",null,88,null,13,0.12630991094652183,0,""]
[null,89,90,21,0.22669841322606488,0,"",null,89,null,2,2.6519836207836377E-3,0,"",null,89,null,0,2.3779120246063198E-3,0,""]
[null,90,91,0,5.3475865129854079E-4,0,"",null,90,null,3,4.1330682328321053E-3,0,"",null,90,null,1,5.326721693302657E-3,0,""]
[null,91,92,1,1.263776420777284E-3,0,"",null,91,null,4,6.0401427827682409E-3,0,"",null,91,null,2,8.9484507496295981E-3,0,""]
[null,92,93,2,2.2455805591867998E-3,0,"",null,92,null,5,8.4690392663121904E-3,0,"",null,92,null,3,1.3354034174650089E-2,0,""]
[null,93,94,3,3.5518057406566245E-3,0,"",null,93,null,6,1.1528915614542355E-2,0,"",null,93,null,4,1.8661768279256228E-2,0,""]
[null,94,95,4,5.2685977950853334E-3,0,"",null,94,null,7,1.5341788107479522E-2,0,"",null,94,null,5,2.4995113245109973E-2,0,""]
[null,95,96,5,7.4976682046511379E-3,0,"",null,95,null,8,2.0041315903188042E-2,0,"",null,95,null,6,3.2479830278607319E-2,0,""]
[null,96,{"$f":"B110+1","v":97},6,{"$f":"VLOOKUP(D110,Rng更新率表,2,FALSE)/$E$2/100","v":1.0356814173799904E-2},0,{"$f":"IF(F110<>0,\"修繕\",\"\")","v":""},null,96,null,9,{"$f":"VLOOKUP(K110,Rng更新率表,3,FALSE)/$L$2/100","v":2.5770723215069721E-2},0,{"$f":"IF(M110<>0,\"修繕\",\"\")","v":""},null,96,null,7,{"$f":"VLOOKUP(R110,Rng更新率表,4,FALSE)/$S$2/100","v":4.1240471300598332E-2},0,{"$f":"IF(T110<>0,\"修繕\",\"\")","v":""}]
[null,{"$f":"B110+1","v":97},98,{"$f":"D110+1","v":7},1.397970559919273E-2,0,"",null,{"$f":"I110+1","v":97},null,{"$f":"K110+1","v":10},3.2679779143121007E-2,0,"",null,{"$f":"P110+1","v":97},null,{"$f":"R110+1","v":8},5.1396283012310022E-2,0,""]
[null,98,99,8,1.8514741807155514E-2,0,"",null,98,null,11,4.0920804558107926E-2,0,"",null,98,null,9,6.3056634788685326E-2,0,""]
[null,99,100,9,2.4122801764453847E-2,0,"",null,99,null,12,5.0643738466469135E-2,0,"",null,99,null,10,7.6316127885333096E-2,0,""]
[null,100,101,10,3.0973754742969341E-2,0,"",null,100,null,13,6.1990369915522446E-2,0,"",null,100,null,11,9.1249588025132736E-2,0,""]
[null,101,102,11,3.9241665393583702E-2,0,"",null,101,null,14,7.5087920932135163E-2,0,"",null,101,null,12,0.10790718035977889,0,""]
[null,102,103,12,4.9098716581751828E-2,0,"",null,102,null,15,9.0042244859220813E-2,0,"",null,102,null,13,0.12630991094652183,0,""]
[null,103,104,13,6.0707980876459011E-2,0,"",null,103,null,16,0.10693097528325249,0,"",null,103,null,0,2.3779120246063198E-3,0,""]
[null,104,105,14,7.4215289848135815E-2,0,"",null,104,null,17,0.12579701560953424,0,"",null,104,null,1,5.326721693302657E-3,0,""]
[null,105,106,15,8.974056905674066E-2,0,"",null,105,null,18,0.14664279071925312,0,"",null,105,null,2,8.9484507496295981E-3,0,""]
[null,106,107,16,0.10736911345421676,0,"",null,106,null,19,0.16942568384232018,0,"",null,106,null,3,1.3354034174650089E-2,0,""]
[null,107,108,17,0.12714335967336815,0,"",null,107,null,20,0.19405504983783065,0,"",null,107,null,4,1.8661768279256228E-2,0,""]
[null,108,109,18,0.14905575580614955,0,"",null,108,null,21,0.22039112948795647,0,"",null,108,null,5,2.4995113245109973E-2,0,""]
[null,109,110,19,0.17304332568124092,0,"",null,109,null,22,0.24824609059987915,0,"",null,109,null,6,3.2479830278607319E-2,0,""]
[null,110,111,20,0.19898446729095756,0,"",null,110,null,23,0.27738729659584255,0,"",null,110,null,7,4.1240471300598332E-2,0,""]
[null,111,112,21,0.22669841322606488,0,"",null,111,null,24,0.30754276093727939,0,"",null,111,null,8,5.1396283012310022E-2,0,""]
[null,112,{"$f":"B126+1","v":113},0,{"$f":"VLOOKUP(D126,Rng更新率表,2,FALSE)/$E$2/100","v":5.3475865129854079E-4},0,"",null,112,null,25,{"$f":"VLOOKUP(K126,Rng更新率表,3,FALSE)/$L$2/100","v":0.33840859766200565},0,"",null,112,null,9,{"$f":"VLOOKUP(R126,Rng更新率表,4,FALSE)/$S$2/100","v":6.3056634788685326E-2},0,""]
[null,113,114,1,1.263776420777284E-3,0,"",null,113,null,26,0.36965813729489638,0,"",null,113,null,10,7.6316127885333096E-2,0,""]
[null,114,115,2,2.2455805591867998E-3,0,"",null,114,null,27,0.40095225616252256,0,"",null,114,null,11,9.1249588025132736E-2,0,""]
[null,115,116,3,3.5518057406566245E-3,0,"",null,115,null,28,0.4319503770012138,{"$f":"VLOOKUP(K129,Rng更新率表,3,FALSE)/$L$2/100","v":0.4319503770012138},"修繕",null,115,null,12,0.10790718035977889,0,""]
[null,116,117,4,5.2685977950853334E-3,0,"",null,116,null,0,6.4973711734608961E-4,0,"",null,116,null,13,0.12630991094652183,0,""]
[null,117,118,5,7.4976682046511379E-3,0,"",null,117,null,1,1.5142368696837098E-3,0,"",null,117,null,0,2.3779120246063198E-3,0,""]
[null,118,119,6,1.0356814173799904E-2,0,"",null,118,null,2,2.6519836207836377E-3,0,"",null,118,null,1,5.326721693302657E-3,0,""]
[null,119,120,7,1.397970559919273E-2,0,"",null,119,null,3,4.1330682328321053E-3,0,"",null,119,null,2,8.9484507496295981E-3,0,""]
[null,120,121,8,1.8514741807155514E-2,0,"",null,120,null,4,6.0401427827682409E-3,0,"",null,120,null,3,1.3354034174650089E-2,0,""]
[null,121,122,9,2.4122801764453847E-2,0,"",null,121,null,5,8.4690392663121904E-3,0,"",null,121,null,4,1.8661768279256228E-2,0,""]
[null,122,123,10,3.0973754742969341E-2,0,"",null,122,null,6,1.1528915614542355E-2,0,"",null,122,null,5,2.4995113245109973E-2,0,""]
[null,123,124,11,3.9241665393583702E-2,0,"",null,123,null,7,1.5341788107479522E-2,0,"",null,123,null,6,3.2479830278607319E-2,0,""]
[null,124,125,12,4.9098716581751828E-2,0,"",null,124,null,8,2.0041315903188042E-2,0,"",null,124,null,7,4.1240471300598332E-2,0,""]
[null,125,126,13,6.0707980876459011E-2,0,"",null,125,null,9,2.5770723215069721E-2,0,"",null,125,null,8,5.1396283012310022E-2,0,""]
[null,126,127,14,7.4215289848135815E-2,0,"",null,126,null,10,3.2679779143121007E-2,0,"",null,126,null,9,6.3056634788685326E-2,0,""]
[null,127,128,15,8.974056905674066E-2,0,"",null,127,null,11,4.0920804558107926E-2,0,"",null,127,null,10,7.6316127885333096E-2,0,""]
[null,128,129,16,0.10736911345421676,0,{"$f":"IF(F142<>0,\"修繕\",\"\")","v":""},null,128,null,12,5.0643738466469135E-2,0,{"$f":"IF(M142<>0,\"修繕\",\"\")","v":""},null,128,null,11,9.1249588025132736E-2,0,{"$f":"IF(T142<>0,\"修繕\",\"\")","v":""}]
[null,129,130,{"$f":"D142+1","v":17},0.12714335967336815,0,"",null,129,null,{"$f":"K142+1","v":13},6.1990369915522446E-2,0,"",null,129,null,{"$f":"R142+1","v":12},0.10790718035977889,0,""]
[null,130,131,18,0.14905575580614955,0,"",null,130,null,14,7.5087920932135163E-2,0,"",null,130,null,13,0.12630991094652183,0,""]
[null,131,132,19,0.17304332568124092,0,"",null,131,null,15,9.0042244859220813E-2,0,"",null,131,null,0,2.3779120246063198E-3,0,""]
[null,132,133,20,0.19898446729095756,0,"",null,132,null,16,0.10693097528325249,0,"",null,132,null,1,5.326721693302657E-3,0,""]
[null,133,134,21,0.22669841322606488,0,"",null,133,null,17,0.12579701560953424,0,"",null,133,null,2,8.9484507496295981E-3,0,""]
[null,134,135,0,5.3475865129854079E-4,0,"",null,134,null,18,0.14664279071925312,0,"",null,134,null,3,1.3354034174650089E-2,0,""]
[null,135,136,1,1.263776420777284E-3,0,"",null,135,null,19,0.16942568384232018,0,"",null,135,null,4,1.8661768279256228E-2,0,""]
[null,136,137,2,2.2455805591867998E-3,0,"",null,136,null,20,0.19405504983783065,0,"",null,136,null,5,2.4995113245109973E-2,0,""]
[null,137,138,3,3.5518057406566245E-3,0,"",null,137,null,21,0.22039112948795647,0,"",null,137,null,6,3.2479830278607319E-2,0,""]
[null,138,139,4,5.2685977950853334E-3,0,"",null,138,null,22,0.24824609059987915,0,"",null,138,null,7,4.1240471300598332E-2,0,""]
[null,139,140,5,7.4976682046511379E-3,0,"",null,139,null,23,0.27738729659584255,0,"",null,139,null,8,5.1396283012310022E-2,0,""]
[null,140,141,6,1.0356814173799904E-2,0,"",null,140,null,24,0.30754276093727939,0,"",null,140,null,9,6.3056634788685326E-2,0,""]
[null,141,142,7,1.397970559919273E-2,0,"",null,141,null,25,0.33840859766200565,0,"",null,141,null,10,7.6316127885333096E-2,0,""]
[null,142,143,8,1.8514741807155514E-2,0,"",null,142,null,26,0.36965813729489638,0,"",null,142,null,11,9.1249588025132736E-2,0,""]
[null,143,144,9,2.4122801764453847E-2,0,"",null,143,null,27,0.40095225616252256,0,"",null,143,null,12,0.10790718035977889,0,""]
[null,144,145,10,3.0973754742969341E-2,0,"",null,144,null,28,0.4319503770012138,{"$f":"VLOOKUP(K158,Rng更新率表,3,FALSE)/$L$2/100","v":0.4319503770012138},"修繕",null,144,null,13,0.12630991094652183,0,""]
[null,145,146,11,3.9241665393583702E-2,0,"",null,145,null,0,6.4973711734608961E-4,0,"",null,145,null,0,2.3779120246063198E-3,0,""]
[null,146,147,12,4.9098716581751828E-2,0,"",null,146,null,1,1.5142368696837098E-3,0,"",null,146,null,1,5.326721693302657E-3,0,""]
[null,147,148,13,6.0707980876459011E-2,0,"",null,147,null,2,2.6519836207836377E-3,0,"",null,147,null,2,8.9484507496295981E-3,0,""]
[null,148,149,14,7.4215289848135815E-2,0,"",null,148,null,3,4.1330682328321053E-3,0,"",null,148,null,3,1.3354034174650089E-2,0,""]
[null,149,150,15,8.974056905674066E-2,0,"",null,149,null,4,6.0401427827682409E-3,0,"",null,149,null,4,1.8661768279256228E-2,0,""]
[null,150,151,16,0.10736911345421676,0,"",null,150,null,5,8.4690392663121904E-3,0,"",null,150,null,5,2.4995113245109973E-2,0,""]
[null,151,152,17,0.12714335967336815,0,"",null,151,null,6,1.1528915614542355E-2,0,"",null,151,null,6,3.2479830278607319E-2,0,""]
[null,152,153,18,0.14905575580614955,0,"",null,152,null,7,1.5341788107479522E-2,0,"",null,152,null,7,4.1240471300598332E-2,0,""]
[null,153,154,19,0.17304332568124092,0,"",null,153,null,8,2.0041315903188042E-2,0,"",null,153,null,8,5.1396283012310022E-2,0,""]
[null,154,155,20,0.19898446729095756,0,"",null,154,null,9,2.5770723215069721E-2,0,"",null,154,null,9,6.3056634788685326E-2,0,""]
[null,155,156,21,0.22669841322606488,0,"",null,155,null,10,3.2679779143121007E-2,0,"",null,155,null,10,7.6316127885333096E-2,0,""]
[null,156,157,0,5.3475865129854079E-4,0,"",null,156,null,11,4.0920804558107926E-2,0,"",null,156,null,11,9.1249588025132736E-2,0,""]
[null,157,158,1,1.263776420777284E-3,0,"",null,157,null,12,5.0643738466469135E-2,0,"",null,157,null,12,0.10790718035977889,0,""]
[null,158,159,2,2.2455805591867998E-3,0,"",null,158,null,13,6.1990369915522446E-2,0,"",null,158,null,13,0.12630991094652183,0,""]
[null,159,160,3,3.5518057406566245E-3,0,"",null,159,null,14,7.5087920932135163E-2,0,"",null,159,null,0,2.3779120246063198E-3,0,""]
[null,160,161,4,5.2685977950853334E-3,0,{"$f":"IF(F174<>0,\"修繕\",\"\")","v":""},null,160,null,15,9.0042244859220813E-2,0,{"$f":"IF(M174<>0,\"修繕\",\"\")","v":""},null,160,null,1,5.326721693302657E-3,0,{"$f":"IF(T174<>0,\"修繕\",\"\")","v":""}]
[null,{"$f":"B174+1","v":161},162,{"$f":"D174+1","v":5},7.4976682046511379E-3,0,"",null,{"$f":"I174+1","v":161},null,{"$f":"K174+1","v":16},0.10693097528325249,0,"",null,{"$f":"P174+1","v":161},null,{"$f":"R174+1","v":2},8.9484507496295981E-3,0,""]
[null,162,163,6,1.0356814173799904E-2,0,"",null,162,null,17,0.12579701560953424,0,"",null,162,null,3,1.3354034174650089E-2,0,""]
[null,163,164,7,1.397970559919273E-2,0,"",null,163,null,18,0.14664279071925312,0,"",null,163,null,4,1.8661768279256228E-2,0,""]
[null,164,165,8,1.8514741807155514E-2,0,"",null,164,null,19,0.16942568384232018,0,"",null,164,null,5,2.4995113245109973E-2,0,""]
[null,165,166,9,2.4122801764453847E-2,0,"",null,165,null,20,0.19405504983783065,0,"",null,165,null,6,3.2479830278607319E-2,0,""]
[null,166,167,10,3.0973754742969341E-2,0,"",null,166,null,21,0.22039112948795647,0,"",null,166,null,7,4.1240471300598332E-2,0,""]
[null,167,168,11,3.9241665393583702E-2,0,"",null,167,null,22,0.24824609059987915,0,"",null,167,null,8,5.1396283012310022E-2,0,""]
[null,168,169,12,4.9098716581751828E-2,0,"",null,168,null,23,0.27738729659584255,0,"",null,168,null,9,6.3056634788685326E-2,0,""]
[null,169,170,13,6.0707980876459011E-2,0,"",null,169,null,24,0.30754276093727939,0,"",null,169,null,10,7.6316127885333096E-2,0,""]
[null,170,171,14,7.4215289848135815E-2,0,"",null,170,null,25,0.33840859766200565,0,"",null,170,null,11,9.1249588025132736E-2,0,""]
[null,171,172,15,8.974056905674066E-2,0,"",null,171,null,26,0.36965813729489638,0,"",null,171,null,12,0.10790718035977889,0,""]
[null,172,173,16,0.10736911345421676,0,"",null,172,null,27,0.40095225616252256,0,"",null,172,null,13,0.12630991094652183,0,""]
[null,173,174,17,0.12714335967336815,0,"",null,173,null,28,0.4319503770012138,{"$f":"VLOOKUP(K187,Rng更新率表,3,FALSE)/$L$2/100","v":0.4319503770012138},"修繕",null,173,null,0,2.3779120246063198E-3,0,""]
[null,174,175,18,0.14905575580614955,0,"",null,174,null,0,6.4973711734608961E-4,0,"",null,174,null,1,5.326721693302657E-3,0,""]
[null,175,176,19,0.17304332568124092,0,"",null,175,null,1,1.5142368696837098E-3,0,"",null,175,null,2,8.9484507496295981E-3,0,""]
[null,176,{"$f":"B190+1","v":177},20,{"$f":"VLOOKUP(D190,Rng更新率表,2,FALSE)/$E$2/100","v":0.19898446729095756},0,"",null,176,null,2,{"$f":"VLOOKUP(K190,Rng更新率表,3,FALSE)/$L$2/100","v":2.6519836207836377E-3},0,"",null,176,null,3,{"$f":"VLOOKUP(R190,Rng更新率表,4,FALSE)/$S$2/100","v":1.3354034174650089E-2},0,""]
[null,177,178,21,0.22669841322606488,0,"",null,177,null,3,4.1330682328321053E-3,0,"",null,177,null,4,1.8661768279256228E-2,0,""]
[null,178,179,0,5.3475865129854079E-4,0,"",null,178,null,4,6.0401427827682409E-3,0,"",null,178,null,5,2.4995113245109973E-2,0,""]
[null,179,180,1,1.263776420777284E-3,0,"",null,179,null,5,8.4690392663121904E-3,0,"",null,179,null,6,3.2479830278607319E-2,0,""]
[null,180,181,2,2.2455805591867998E-3,0,"",null,180,null,6,1.1528915614542355E-2,0,"",null,180,null,7,4.1240471300598332E-2,0,""]
[null,181,182,3,3.5518057406566245E-3,0,"",null,181,null,7,1.5341788107479522E-2,0,"",null,181,null,8,5.1396283012310022E-2,0,""]
[null,182,183,4,5.2685977950853334E-3,0,"",null,182,null,8,2.0041315903188042E-2,0,"",null,182,null,9,6.3056634788685326E-2,0,""]
[null,183,184,5,7.4976682046511379E-3,0,"",null,183,null,9,2.5770723215069721E-2,0,"",null,183,null,10,7.6316127885333096E-2,0,""]

{"sheet":"健全度","index":13,"n_rows":62,"n_cols":24,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[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,"老朽化資産"]
[]
[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,"計装設備",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(C9=\"\",\"\",C9)","v":""},{"$f":"IF(D9=\"\",\"\",D9)","v":""},"","","","","","","",""]
[null,"健全資産",{"$f":"+C10+O10+C16+O16+C22","v":0},0,0,0,0,0,0,0,0,0]
[null,"経年化資産",0,0,0,0,0,0,0,0,0,0]
[null,"老朽化資産",0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"浄水施設更新シミュレーター　水道技術研究センター　2011年10月"]
[null,null,"本シミュレーションは、シナリオによって、どの程度の違いが生じるのかイメージするためのツールであり、計算結果は実際の数量、金額を表すものではありません。"]

{"sheet":"影響水量","index":14,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"■リスク　影響水量"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"単位：ｍ3／日"]
[null,null,"区　分",{"$f":"+Calc!AA5","v":0},{"$f":"Calc!AA10","v":0},{"$f":"Calc!AA15","v":0},{"$f":"Calc!AA20","v":0},{"$f":"Calc!AA25","v":0},{"$f":"Calc!AA30","v":0},{"$f":"Calc!AA35","v":0},{"$f":"Calc!AA40","v":0},{"$f":"Calc!AA45","v":0},{"$f":"Calc!AA50","v":0}]
[null,null,"電気設備",{"$f":"+Calc!AB5","v":0},{"$f":"Calc!AB10","v":0},{"$f":"Calc!AB15","v":0},{"$f":"Calc!AB20","v":0},{"$f":"Calc!AB25","v":0},{"$f":"Calc!AB30","v":0},{"$f":"Calc!AB35","v":0},{"$f":"Calc!AB40","v":0},{"$f":"Calc!AB45","v":0},{"$f":"Calc!AB50","v":0}]
[null,null,"機械設備",{"$f":"+Calc!AC5","v":0},{"$f":"Calc!AC10","v":0},{"$f":"Calc!AC15","v":0},{"$f":"Calc!AC20","v":0},{"$f":"Calc!AC25","v":0},{"$f":"Calc!AC30","v":0},{"$f":"Calc!AC35","v":0},{"$f":"Calc!AC40","v":0},{"$f":"Calc!AC45","v":0},{"$f":"Calc!AC50","v":0}]
[null,null,"計装設備",{"$f":"+Calc!AD5","v":0},{"$f":"Calc!AD10","v":0},{"$f":"Calc!AD15","v":0},{"$f":"Calc!AD20","v":0},{"$f":"Calc!AD25","v":0},{"$f":"Calc!AD30","v":0},{"$f":"Calc!AD35","v":0},{"$f":"Calc!AD40","v":0},{"$f":"Calc!AD45","v":0},{"$f":"Calc!AD50","v":0}]
[null,null,"影響水量",{"$f":"+Calc!AE5","v":0},{"$f":"Calc!AE10","v":0},{"$f":"Calc!AE15","v":0},{"$f":"Calc!AE20","v":0},{"$f":"Calc!AE25","v":0},{"$f":"Calc!AE30","v":0},{"$f":"Calc!AE35","v":0},{"$f":"Calc!AE40","v":0},{"$f":"Calc!AE45","v":0},{"$f":"Calc!AE50","v":0}]
[null,null,"浄水能力",{"$f":"+'入力情報(1)'!$H$23-影響水量!D16","v":0},{"$f":"+'入力情報(1)'!$H$23-影響水量!E16","v":0},{"$f":"+'入力情報(1)'!$H$23-影響水量!F16","v":0},{"$f":"+'入力情報(1)'!$H$23-影響水量!G16","v":0},{"$f":"+'入力情報(1)'!$H$23-影響水量!H16","v":0},{"$f":"+'入力情報(1)'!$H$23-影響水量!I16","v":0},{"$f":"+'入力情報(1)'!$H$23-影響水量!J16","v":0},{"$f":"+'入力情報(1)'!$H$23-影響水量!K16","v":0},{"$f":"+'入力情報(1)'!$H$23-影響水量!L16","v":0},{"$f":"+'入力情報(1)'!$H$23-影響水量!M16","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"浄水施設更新シミュレーター　水道技術研究センター　2011年10月"]
[null,null,"本シミュレーションは、シナリオによって、どの程度の違いが生じるのかイメージするためのツールであり、計算結果は実際の数量、金額を"]
[null,null,"表すものではありません。"]

{"sheet":"損失額","index":15,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"■リスク　損失額"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"単位：百万円"]
[null,null,"区　分",{"$f":"影響水量!D12","v":0},{"$f":"影響水量!E12","v":0},{"$f":"影響水量!F12","v":0},{"$f":"影響水量!G12","v":0},{"$f":"影響水量!H12","v":0},{"$f":"影響水量!I12","v":0},{"$f":"影響水量!J12","v":0},{"$f":"影響水量!K12","v":0},{"$f":"影響水量!L12","v":0},{"$f":"影響水量!M12","v":0}]
[null,null,"損失額",{"$f":"Calc!AF5","v":0},{"$f":"Calc!AF10","v":0},{"$f":"Calc!AF15","v":0},{"$f":"Calc!AF20","v":0},{"$f":"Calc!AF25","v":0},{"$f":"Calc!AF30","v":0},{"$f":"Calc!AF35","v":0},{"$f":"Calc!AF40","v":0},{"$f":"Calc!AF45","v":0},{"$f":"Calc!AF50","v":0}]
[null,null,"影響水量",{"$f":"影響水量!D16","v":0},{"$f":"影響水量!E16","v":0},{"$f":"影響水量!F16","v":0},{"$f":"影響水量!G16","v":0},{"$f":"影響水量!H16","v":0},{"$f":"影響水量!I16","v":0},{"$f":"影響水量!J16","v":0},{"$f":"影響水量!K16","v":0},{"$f":"影響水量!L16","v":0},{"$f":"影響水量!M16","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"浄水施設更新シミュレーター　水道技術研究センター　2011年10月"]
[null,null,"本シミュレーションは、シナリオによって、どの程度の違いが生じるのかイメージするためのツールであり、計算結果は実際の数量、金額を"]
[null,null,"表すものではありません。"]

{"sheet":"修繕更新費用S1","index":16,"n_rows":54,"n_cols":28,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[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,"区分","2064年～2068年","2069年～2073年","2074年～2078年","2079年～2083年","2084年～2088年","2089年～2093年","2094年～2098年","2099年～2103年","2104年～2108年","2109年～2113年"]
[null,null,"電気",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D16:M16)","v":0}]
[null,null,"機械",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D17:M17)","v":0}]
[null,null,"計装",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D18:M18)","v":0}]
[null,null,"計",{"$f":"SUM(D16:D18)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(D19:M19)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"浄水施設更新シミュレーター　水道技術研究センター　2011年10月"]
[null,null,"本シミュレーションは、シナリオによって、どの程度の違いが生じるのかイメージするためのツールであり、計算結果は実際の数量、金額を"]
[null,null,"表すものではありません。"]

{"sheet":"修繕更新費用S2","index":17,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":true,"merged":[[15,1,19,1],[20,1,22,1],[23,1,23,2],[15,18,19,18],[20,18,22,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"■修繕及び更新費用"]
[]
[null,null,null,"シナリオ２：","現在と同じフロー・水量で更新、使用年数はメンテナンスレベルから算出",null,null,null,null,null,null,null,null,null,null,null,null,null,"※51年～100年の表は、表示のみで印刷されません"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"単位：百万円",null,null,null,null,"【51年～100年】"]
[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":"SUM(D16:M16)","v":0},null,null,null,null,"更新費用","建築"]
[null,null,"土木",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"土木"]
[null,null,"電気",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"電気"]
[null,null,"機械",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"機械"]
[null,null,"計装",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"計装"]
[null,"修繕費用","電気",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"修繕費用","電気"]
[null,null,"機械",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"機械"]
[null,null,"計装",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"計装"]
[null,"計",null,{"$f":"SUM(D16:D23)","v":0},{"$f":"SUM(E16:E23)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(D24:M24)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"浄水施設更新シミュレーター　水道技術研究センター　2011年10月"]
[null,"本シミュレーションは、シナリオによって、どの程度の違いが生じるのかイメージするためのツールであり、計算結果は実際の数量、金額を"]
[null,"表すものではありません。"]
[null,"本シミュレータは浄水場の全面更新を行う前提で50年間の設備費、運転費を算出するものであるが、"]
[null,"土木、建築設備の実耐用年数が100年近くになる場合もあるため、条件によっては、土木、建築の更新が一度も発生しない計算結果となる。"]
[null,"そこで、51年～100年の計算結果（土木、建築の更新が1回は発生）を参考値として表示することとした。"]

{"sheet":"修繕更新費用S3","index":18,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":true,"merged":[[15,1,19,1],[20,1,22,1],[23,1,23,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[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":"SUM(D16:M16)","v":0}]
[null,null,"土木",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"電気",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"機械",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"計装",null,null,null,null,null,null,null,null,null,null,0]
[null,"修繕費用","電気",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"機械",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"計装",null,null,null,null,null,null,null,null,null,null,0]
[null,"計",null,{"$f":"SUM(D16:D23)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"浄水施設更新シミュレーター　水道技術研究センター　2011年10月"]
[null,"本シミュレーションは、シナリオによって、どの程度の違いが生じるのかイメージするためのツールであり、計算結果は実際の数量、金額を"]
[null,"表すものではありません。"]

{"sheet":"修繕更新費用S4","index":19,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":true,"merged":[[15,1,19,1],[20,1,22,1],[23,1,23,2],[15,18,19,18],[20,18,22,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"■修繕及び更新費用"]
[]
[null,null,null,"シナリオ４：","現状のフローで更新、水量は将来予測、使用年数はメンテナンスレベルから算出",null,null,null,null,null,null,null,null,null,null,null,null,null,"※51年～100年の表は、表示のみで印刷されません"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"単位：百万円",null,null,null,null,"【51年～100年】"]
[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":"SUM(D16:M16)","v":0},null,null,null,null,"更新費用","建築"]
[null,null,"土木",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"土木"]
[null,null,"電気",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"電気"]
[null,null,"機械",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"機械"]
[null,null,"計装",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"計装"]
[null,"修繕費用","電気",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,"修繕費用","電気"]
[null,null,"機械",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"機械"]
[null,null,"計装",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"計装"]
[null,"計",null,{"$f":"SUM(D16:D23)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"浄水施設更新シミュレーター　水道技術研究センター　2011年10月"]
[null,"本シミュレーションは、シナリオによって、どの程度の違いが生じるのかイメージするためのツールであり、計算結果は実際の数量、金額を"]
[null,"表すものではありません。"]
[null,"本シミュレータは浄水場の全面更新を行う前提で50年間の設備費、運転費を算出するものであるが、"]
[null,"土木、建築設備の実耐用年数が100年近くになる場合もあるため、条件によっては、土木、建築の更新が一度も発生しない計算結果となる。"]
[null,"そこで、51年～100年の計算結果（土木、建築の更新が1回は発生）を参考値として表示することとした。"]

{"sheet":"修繕更新費用S5","index":20,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":true,"merged":[[15,1,19,1],[20,1,22,1],[23,1,23,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[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":"SUM(D16:M16)","v":0}]
[null,null,"土木",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"電気",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"機械",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"計装",null,null,null,null,null,null,null,null,null,null,0]
[null,"修繕費用","電気",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"機械",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"計装",null,null,null,null,null,null,null,null,null,null,0]
[null,"計",null,{"$f":"SUM(D16:D23)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"浄水施設更新シミュレーター　水道技術研究センター　2011年10月"]
[null,"本シミュレーションは、シナリオによって、どの程度の違いが生じるのかイメージするためのツールであり、計算結果は実際の数量、金額を"]
[null,"表すものではありません。"]

{"sheet":"出力まとめの表","index":21,"n_rows":76,"n_cols":25,"rows_kept":76,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,{"$f":"+\"浄水場名：\"&'入力情報(1)'!G22","v":"浄水場名："}]
[null,null,null,"50年間の費用で比較"]
[null,null,null,"設備ごとの係数","建築構造物","土木構造物","電気設備","機械設備","計装設備"]
[null,null,null,"延長係数β",{"$f":"RngEnchou建築","v":1.3089340934649778},{"$f":"RngEnchou土木","v":1.3464174362569385},{"$f":"RngEnchou電気","v":1.3317300341540892},{"$f":"RngEnchou機械","v":1.3709904419425603},{"$f":"RngEnchou計装","v":1.3337090957867057}]
[]
[null,null,null,"シナリオの条件","シナリオ1\n（修繕のみ）","シナリオ２\n（現状と同じフロー・\n規模で更新）","シナリオ3\n（希望フロー・\n同じ規模で更新）","シナリオ4\n（現状と同じフロー・\n将来予測規模で更新）","シナリオ5\n（希望フロー・\n将来予測規模で更新）",null,null,null,null,null,null,null,null,null,null,"s","s",null,"s"]
[null,null,null,"実際の浄水量 m3/日",{"$f":"+'入力情報(1)'!H23","v":0},{"$f":"+'入力情報(1)'!H23","v":0},{"$f":"+'入力情報(1)'!H23","v":0},{"$f":"+'入力情報(2)'!H6","v":0},{"$f":"+'入力情報(2)'!H6","v":0},null,null,null,null,null,null,null,null,null,null,"シナリオ1","シナリオ２","シナリオ3","シナリオ4","シナリオ5"]
[null,null,null,"浄水フロー",{"$f":"IF(+'入力情報(1)'!H28=\"\",\"\",+'入力情報(1)'!H28)","v":""},{"$f":"IF(+'入力情報(1)'!H28=\"\",\"\",+'入力情報(1)'!H28)","v":""},{"$f":"IF(+'入力情報(2)'!G26=\"\",\"\",+'入力情報(2)'!G26)","v":""},{"$f":"IF(+'入力情報(1)'!H28=\"\",\"\",+'入力情報(1)'!H28)","v":""},{"$f":"IF(+'入力情報(2)'!G26=\"\",\"\",+'入力情報(2)'!G26)","v":""}]
[null,null,null,"粉末炭の有無",{"$f":"IF('入力情報(1)'!H29=\"\",\"\",'入力情報(1)'!H29)","v":""},{"$f":"IF('入力情報(1)'!H29=\"\",\"\",'入力情報(1)'!H29)","v":""},{"$f":"+Calc!G37","v":""},{"$f":"IF('入力情報(1)'!H29=\"\",\"\",'入力情報(1)'!H29)","v":""},{"$f":"+Calc!G37","v":""}]
[null,null,null,"修繕費",{"$f":"+T13/100000000","v":0},0,0,0,0,"億円",null,null,null,null,null,null,null,null,"修繕費",{"$f":"SUM(修繕更新費用S1!N19)","v":0},{"$f":"SUM(修繕更新費用S2!N21:N23)","v":0},{"$f":"SUM(修繕更新費用S3!N21:N23)","v":0},{"$f":"SUM(修繕更新費用S4!N21:N23)","v":0},{"$f":"SUM(修繕更新費用S5!N21:N23)","v":0}]
[null,null,null,"更新費",0,0,0,0,0,"億円",null,null,null,null,null,null,null,null,"更新費",0,{"$f":"SUM(修繕更新費用S2!N16:N20)","v":0},{"$f":"SUM(修繕更新費用S3!N16:N20)","v":0},{"$f":"SUM(修繕更新費用S4!N16:N20)","v":0},{"$f":"SUM(修繕更新費用S5!N16:N20)","v":0},"運転費１年単価"]
[null,null,null,"運転費（人件費込み）",{"$f":"+RngUnten1/100000000","v":0},{"$f":"+RngUnten2/100000000","v":0},{"$f":"+RngUnten3/100000000","v":0},{"$f":"+RngUnten4/100000000","v":0},{"$f":"+RngUnten5/100000000","v":0},"億円",null,null,null,null,null,null,null,null,"運転費（人件費込み）"]
[null,null,null,"小計１",{"$f":"SUM(E13:E15)","v":0},{"$f":"SUM(F13:F15)","v":0},{"$f":"SUM(G13:G15)","v":0},{"$f":"SUM(H13:H15)","v":0},{"$f":"SUM(I13:I15)","v":0},"億円",null,null,null,null,null,null,null,null,"小計１",{"$f":"SUM(T13:T15)","v":0},{"$f":"SUM(U13:U15)","v":0},{"$f":"SUM(V13:V15)","v":0},{"$f":"SUM(W13:W15)","v":0},{"$f":"SUM(X13:X15)","v":0}]
[]
[null,null,null,"リスク（損失額）\n年ごとの影響水量を損失額に換算したものを50年分計算",{"$f":"+T18/100000000","v":0},0,0,0,0,"億円",null,null,null,null,null,null,null,null,"リスク（損失額）",{"$f":"SUM(Calc!AF5:AF54)","v":0}]
[null,null,null,"高度処理による便益",0,0,{"$f":"+V19/100000000","v":0},0,{"$f":"+X19/100000000","v":0},"億円",null,null,null,null,null,null,null,null,"高度処理による便益",null,null,{"$f":"IF(プレビュー!E64=\"✓\",IF(AND(Calc!I34=0,Calc!J34>=1),+'入力情報(1)'!H23/0.34*0.128*33000*50*-1,0),0)","v":0},null,{"$f":"IF(プレビュー!E66=\"✓\",IF(AND(Calc!I34=0,Calc!J34>=1),+'入力情報(2)'!H6/0.34*0.128*33000*50*-1,0),0)","v":0}]
[null,null,null,"クリプトスポリジウム対策の便益",0,0,{"$f":"+V20/100000000","v":0},0,{"$f":"+X20/100000000","v":0},"億円",null,null,null,null,null,null,null,null,"クリプトスポリジウム対策の便益",null,null,{"$f":"IF(プレビュー!E64=\"✓\",IF(AND(Calc!I41=0,Calc!J41>=1),+'入力情報(1)'!H23/0.34*1.5*0.000001*10000000*50*-1,0),0)","v":0},null,{"$f":"IF(プレビュー!E66=\"✓\",IF(AND(Calc!I41=0,Calc!J41>=1),+'入力情報(2)'!H6/0.34*1.5*0.000001*10000000*50*-1,0),0)","v":0}]
[null,null,null,"小計2",{"$f":"+T21/100000000","v":0},{"$f":"+U21/100000000","v":0},{"$f":"+V21/100000000","v":0},{"$f":"+W21/100000000","v":0},{"$f":"+X21/100000000","v":0},"億円",null,null,null,null,null,null,null,null,"小計2",{"$f":"SUM(T18:T20)","v":0},{"$f":"SUM(U18:U20)","v":0},{"$f":"SUM(V18:V20)","v":0},{"$f":"SUM(W18:W20)","v":0},{"$f":"SUM(X18:X20)","v":0}]
[]
[null,null,null,"総計（小計１＋小計２）",{"$f":"+T23/100000000","v":0},{"$f":"+U23/100000000","v":0},{"$f":"+V23/100000000","v":0},{"$f":"+W23/100000000","v":0},{"$f":"+X23/100000000","v":0},"億円",null,null,null,null,null,null,null,null,"総計（小計１＋小計２）",{"$f":"+T16+T21","v":0},{"$f":"+U16+U21","v":0},{"$f":"+V16+V21","v":0},{"$f":"+W16+W21","v":0},{"$f":"+X16+X21","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"浄水施設更新シミュレーター　水道技術研究センター　2011年10月"]
[null,null,null,"本シミュレーションは、シナリオによって、どの程度の違いが生じるのかイメージするためのツールであり、計算結果は実際の数量、金額を"]
[null,null,null,"表すものではありません。"]

{"sheet":"系列の集計","index":22,"n_rows":102,"n_cols":19,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"←　合計のみを表示する"]
[]
[]
[null,null,null,"50年間の費用で比較"]
[null,null,null,"シナリオの条件","シナリオ1\n（修繕のみ）","シナリオ２\n（現状と同じフロー・\n規模で更新）","シナリオ3\n（希望フロー・\n同じ規模で更新）","シナリオ4\n（現状と同じフロー・\n将来予測規模で更新）","シナリオ5\n（希望フロー・\n将来予測規模で更新）"]
[null,null,null,"ｼﾅﾘｵ選択ｶｳﾝﾄ",{"$f":"COUNT(E10:E14)","v":0},{"$f":"COUNT(F10:F14)","v":0},{"$f":"COUNT(G10:G14)","v":0},{"$f":"COUNT(H10:H14)","v":0},{"$f":"COUNT(I10:I14)","v":0}]
[]
[null,null,null,"修繕費",{"$f":"SUM(E10:E14)","v":0},{"$f":"SUM(F10:F14)","v":0},{"$f":"SUM(G10:G14)","v":0},{"$f":"SUM(H10:H14)","v":0},{"$f":"SUM(I10:I14)","v":0},"億円",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":"COUNT(E10:I10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(E11:I11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(E12:I12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(E13:I13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(E14:I14)","v":0}]
[null,null,null,"更新費",{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F16:F20)","v":0},{"$f":"SUM(G16:G20)","v":0},{"$f":"SUM(H16:H20)","v":0},{"$f":"SUM(I16:I20)","v":0},"億円"]
[]
[]
[]
[]
[]
[null,null,null,"運転費（人件費込み）",{"$f":"SUM(E22:E26)","v":0},{"$f":"SUM(F22:F26)","v":0},{"$f":"SUM(G22:G26)","v":0},{"$f":"SUM(H22:H26)","v":0},{"$f":"SUM(I22:I26)","v":0},"億円"]
[]
[]
[]
[]
[]
[null,null,null,"小計１",{"$f":"+E9+E15+E21","v":0},{"$f":"+F9+F15+F21","v":0},{"$f":"+G9+G15+G21","v":0},{"$f":"+H9+H15+H21","v":0},{"$f":"+I9+I15+I21","v":0},"億円"]
[]
[null,null,null,"リスク（損失額）",{"$f":"SUM(E30:E34)","v":0},{"$f":"SUM(F30:F34)","v":0},{"$f":"SUM(G30:G34)","v":0},{"$f":"SUM(H30:H34)","v":0},{"$f":"SUM(I30:I34)","v":0},"億円"]
[]
[]
[]
[]
[]
[null,null,null,"高度処理による便益",{"$f":"SUM(E36:E40)","v":0},{"$f":"SUM(F36:F40)","v":0},{"$f":"SUM(G36:G40)","v":0},{"$f":"SUM(H36:H40)","v":0},{"$f":"SUM(I36:I40)","v":0},"億円"]
[]
[]
[]
[]
[]
[null,null,null,"クリプトスポリジウム対策の便益",{"$f":"SUM(E42:E46)","v":0},{"$f":"SUM(F42:F46)","v":0},{"$f":"SUM(G42:G46)","v":0},{"$f":"SUM(H42:H46)","v":0},{"$f":"SUM(I42:I46)","v":0},"億円"]
[]
[]
[]
[]
[]
[null,null,null,"小計2",{"$f":"+E29+E35+E41","v":0},{"$f":"+F29+F35+F41","v":0},{"$f":"+G29+G35+G41","v":0},{"$f":"+H29+H35+H41","v":0},{"$f":"+I29+I35+I41","v":0},"億円"]
[]
[null,null,null,"総計（小計１＋小計２）",{"$f":"+E27+E47","v":0},{"$f":"+F27+F47","v":0},{"$f":"+G27+G47","v":0},{"$f":"+H27+H47","v":0},{"$f":"+I27+I47","v":0},"億円"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"浄水施設更新シミュレーター　水道技術研究センター　2011年10月"]
[null,null,null,"本シミュレーションは、シナリオによって、どの程度の違いが生じるのかイメージするためのツールであり、計算結果は実際の数量、金額を"]
[null,null,null,"表すものではありません。"]

{"sheet":"設備費と運転費","index":23,"n_rows":55,"n_cols":20,"rows_kept":55,"cut":false,"hidden":true,"merged":[[18,2,18,3],[36,2,36,3],[3,5,4,5],[2,6,6,6]]}
[]
[null,"前提条件","分類No.2100（凝集・沈澱＋急速ろ過）、浄水量20,000m3/dを基準とする。"]
[null,"この時の","設備費基準額",159900,"万円/20000m3・d",null,"e-WaterⅡ最終報告書、pp.Ⅱ-201～Ⅱ-214より読みとったもの"]
[null,null,"設備費の規模係数k1",{"$f":"(3201-(0.01*D3))/(100000-20000)","v":2.0025000000000001E-2},null,"5,000m3/dから100,000m3/dの\n原単位の変化率\n＝2.0÷(100000-5000)",null,null,"No.2100のみ適用"]
[null,null,"設備費規模計算式の切片",{"$f":"3201-D4*100000","v":1198.5}]
[]
[null,null,"基準給水原価",170,"円/m3","マスターの変更がなければ180円/m3を基本とする。水道統計の全国平均180円/m3（H17年度）",null,"浄水処理分以外も含まれるが、内訳中のその他を加味しないことで相殺されると仮定"]
[]
[null,null,"変動費係数",0.13,null,"マスターの変更がなければ、給水原価の10%とする（水道統計H17年度全国平均）"]
[null,null,"運転費単価の変動費分\n（人件費を除く）",{"$f":"D7*D9","v":22.1},"円/m3","給水原価×変動費係数"]
[]
[null,null,"膜ろ過を含まない運転費単価\nの人件費分",{"$f":"D7*0.15","v":25.5},"円/m3","マスターの変更がなければ、給水原価×0.15で計算（水道統計H17年度全国平均）"]
[]
[null,null,"膜ろ過を含む運転費単価\nの人件費分",{"$f":"D7*0.12","v":20.399999999999999},"円/m3","マスターの変更がなければ、給水原価×0.12で計算（水道統計H17年度全国平均）"]
[null,"浄水量","現状もしくは将来予測",12000,"m3/d","\"002\"または\"016\"を転記",null,"金額補正係数",1]
[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,"e-WaterⅡの資料から、電気を水量変数の計算式で求め、膜ろ過以外は建築、計装、機械は各水量規模の平均値とした。"]
[null,"浄水フロー毎、入力浄水量における設備費の計算",null,null,null,null,null,null,null,null,null,null,null,"膜ろ過については建築、計装、土木を平均値とした。膜ろ過以外の場合の土木＝1-その他の合計、膜ろ過の場合の機械＝1-その他の合計とした。"]
[null,"分類No.","浄水フロー",null,"相対設備費\n20,000m3/d","相対設備費\n100,000m3/d","入力浄水量（D15）での相対設備費","浄水施設全体\n万円","電気\n万円","機械\n万円","計装\n万円","土木\n万円","建築\n万円","電気\n","機械\n","計装\n","土木\n","建築\n",null,"電気按分率の計算式の修正"]
[null,1100,"-","膜ろ過",1.374835,1.4997149999999999,{"$f":"$D$15*(F20-E20)/80000+(E20-(F20-E20)/80000*20000)","v":1.362347},{"$f":"$H$22*G20","v":196014.48636000001},{"$f":"$H20*N20","v":79973.910434880003},{"$f":"$H20*O20","v":84678.258107520014},1960.1448636000002,11760.869181600001,17641.303772399999,{"$f":"0.42-0.0012*((IF($D$15<2000,2000,$D$15)-2000)/1000)","v":0.40799999999999997},{"$f":"1-N20-P20-Q20-R20","v":0.43200000000000005},0.01,0.06,0.09,{"$f":"SUM(N20:R20)","v":1.0000000000000002},"修正なし"]
[null,1200,"凝集","膜ろ過",1.5176749999999999,1.6293200000000001,{"$f":"$D$15*(F21-E21)/80000+(E21-(F21-E21)/80000*20000)","v":1.5065104999999999},{"$f":"$H$22*G21","v":216756.73073999997},{"$f":"$H21*N21","v":86269.178834519975},91471.340372280014,2167.5673073999997,17340.538459199997,19508.105766599998,{"$f":"0.41-0.0012*(IF($D$15<2000,2000,$D$15)-2000)/1000","v":0.39799999999999996},0.42200000000000015,0.01,0.08,0.09,1,"修正なし"]
[null,2100,"凝集沈澱","急速ろ過",0.99987999999999999,0.99980999999999998,1,{"$f":"(D4*D15+D5)*100*I15","v":143880},45753.839999999989,64630.896000000001,1438.8,26301.26400000001,5755.2,{"$f":"IF(IF($D$15<2000,2000,$D$15)>44000,0.344-0.0026*(44000-2000)/1000,0.344-0.0026*(IF($D$15<2000,2000,$D$15)-2000)/1000)","v":0.31799999999999995},0.44919999999999999,0.01,0.18280000000000007,0.04,1,"浄水量>44000の場合、浄水量＝44000"]
[null,2110,"粉末炭+凝集沈殿","急速ろ過",1.196285,1.166445,{"$f":"$D$15*(F23-E23)/80000+(E23-(F23-E23)/80000*20000)","v":1.1992690000000001},{"$f":"$H$22*G23","v":172550.82372000001},52628.0012346,77647.870674000005,1725.5082372000002,28470.885913800004,12078.557660400002,{"$f":"IF(IF($D$15<2000,2000,$D$15)>44000,0.33-0.0025*(44000-2000)/1000,0.33-0.0025*(IF($D$15<2000,2000,$D$15)-2000)/1000)","v":0.30499999999999999},0.45,0.01,0.16500000000000001,7.0000000000000007E-2,1,"浄水量>44000の場合、浄水量＝44000"]
[null,2200,"凝集沈殿","膜ろ過",1.8569199999999999,2.018135,1.8407984999999998,264854.08817999996,97201.450362059986,114681.82018193998,2648.5408817999996,29133.949699799996,21188.327054399997,{"$f":"0.38-0.0013*(IF($D$15<2000,2000,$D$15)-2000)/1000","v":0.36699999999999999},0.433,0.01,0.11,0.08,1,"修正なし"]
[null,2210,"粉末炭+凝集沈殿","膜ろ過",2.0533250000000001,2.1847699999999999,2.0401805000000004,293541.17034000007,101858.78610798002,127103.32675722004,2935.4117034000005,35224.940440800005,26418.705330600005,{"$f":"0.36-0.0013*(IF($D$15<2000,2000,$D$15)-2000)/1000","v":0.34699999999999998},0.43300000000000005,0.01,0.12,0.09,1,"修正なし"]
[null,3000,"凝集","急速ろ過",0.66063499999999997,0.61099499999999995,0.66559900000000005,95766.384120000002,36391.225965600002,40221.8813304,957.66384120000009,13407.293776800001,4788.3192060000001,{"$f":"IF(IF($D$15<2000,2000,$D$15)>52000,0.41-0.003*(52000-2000)/1000,0.41-0.003*(IF($D$15<2000,2000,$D$15)-2000)/1000)","v":0.38},0.42,0.01,{"$f":"1-N26-O26-P26-R26","v":0.14000000000000001},0.05,1,"浄水量>52000の場合、浄水量＝52000"]
[null,5100,"凝集沈澱+粒状炭","急速ろ過",1.5890949999999999,1.795955,1.5684089999999999,225662.68691999998,72889.047875159988,112831.34345999999,2256.6268691999999,30915.788108040008,6769.8806075999992,{"$f":"IF(IF($D$15<2000,2000,$D$15)>44000,0.35-0.0027*(44000-2000)/1000,0.35-0.0027*(IF($D$15<2000,2000,$D$15)-2000)/1000)","v":0.32299999999999995},0.5,0.01,{"$f":"1-N27-O27-P27-R27","v":0.13700000000000004},0.03,1,"浄水量>44000の場合、浄水量＝44000"]
[null,5200,"凝集沈澱+粒状炭","膜ろ過",2.4461349999999999,2.8142800000000001,2.4093204999999998,346653.03353999997,125488.39814147999,166393.45609919998,3466.5303353999998,27038.936616120001,24265.712347799999,{"$f":"IF(IF($D$15<2000,2000,$D$15)>84000,0.38-0.0018*(84000-2000)/1000,0.38-0.0018*(IF($D$15<2000,2000,$D$15)-2000)/1000)","v":0.36199999999999999},0.48,0.01,7.8000000000000014E-2,7.0000000000000007E-2,1,"浄水量>84000の場合、浄水量＝84000"]
[null,6100,"凝集沈澱+オゾン+粒状炭","急速ろ過",2.089035,2.3884349999999999,2.0590949999999997,296262.58859999996,105469.48154159998,142206.04252799996,2962.6258859999998,33773.935100399998,11850.503543999999,{"$f":"IF(IF($D$15<2000,2000,$D$15)>58000,0.38-0.0024*(58000-2000)/1000,0.38-0.0024*(IF($D$15<2000,2000,$D$15)-2000)/1000)","v":0.35599999999999998},0.48,0.01,0.11400000000000002,0.04,1,"浄水量>58000の場合、浄水量＝58000"]
[null,6200,"凝集沈澱+オゾン+粒状炭","膜ろ過",2.946075,3.4067600000000002,2.9000064999999999,417252.93521999998,155635.34483705999,200281.40890559999,4172.5293522000002,27955.946659740002,29207.705465400002,{"$f":"IF(IF($D$15<2000,2000,$D$15)>94000,0.39-0.0017*(94000-2000)/1000,0.39-0.0017*(IF($D$15<2000,2000,$D$15)-2000)/1000)","v":0.373},0.48,0.01,6.7000000000000004E-2,7.0000000000000007E-2,1,"浄水量>94000の場合、浄水量＝94000"]
[null,7100,"粒状炭","膜ろ過",1.981905,2.2958600000000002,1.9505095000000001,280639.30686000001,110010.60828911999,134706.86729279999,2806.3930686000003,13470.686729280033,19644.751480200004,{"$f":"IF(IF($D$15<2000,2000,$D$15)>96000,0.41-0.0018*(96000-2000)/1000,0.41-0.0018*(IF($D$15<2000,2000,$D$15)-2000)/1000)","v":0.39199999999999996},0.48,0.01,4.8000000000000112E-2,7.0000000000000007E-2,1,"浄水量>96000の場合、浄水量＝96000"]
[null,7200,"凝集+粒状炭","膜ろ過",2.1068899999999999,2.425465,2.0750325000000003,298555.67610000004,117033.8250312,140321.16776700001,2985.5567610000003,17316.229213800034,20898.897327000006,{"$f":"IF(IF($D$15<2000,2000,$D$15)>96000,0.41-0.0018*(96000-2000)/1000,0.41-0.0018*(IF($D$15<2000,2000,$D$15)-2000)/1000)","v":0.39199999999999996},0.47,0.01,5.8000000000000107E-2,7.0000000000000007E-2,1,"浄水量>96000の場合、浄水量＝96000"]
[null,7300,"オゾン+粒状炭","膜ろ過",2.4639899999999999,2.8883399999999999,2.4215549999999997,348413.33339999994,140410.57336019995,163754.26669799996,3484.1333339999996,16375.426669799997,24388.933337999999,{"$f":"0.42-0.0017*(IF($D$15<2000,2000,$D$15)-2000)/1000","v":0.40299999999999997},0.47,0.01,4.7E-2,7.0000000000000007E-2,1,"修正なし"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"※2000㎥以下は2000㎥として計算。100000m3以上は対象外。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"※膜ろ過は電機・機械で変動、急ろ・粒状炭は土木・電機で変動させる。"]
[null,"浄水フロー毎、入力浄水量における運転費の計算"]
[null,"分類No.","浄水フロー",null,"相対運転費\n20,000m3/d","相対運転費\n100,000m3/d","入力浄水量（D15）での相対運転費","薬品、電力、消耗品費等 円/m3-浄水","粉炭係数を加味した薬品、電力、消耗品費等 円/m3-浄水","粉炭係数を加味した運転費＝（薬品+電力+消耗品等+人件費）　円/m3"]
[null,1100,"-","膜ろ過",2.2051259999999999,1.3297875000000001,{"$f":"$D$15*(F38-E38)/80000+(E38-(F38-E38)/80000*20000)","v":2.2926598499999997},{"$f":"$H$40*G38","v":50.667782684999999},{"$f":"H38","v":50.667782684999999},{"$f":"$D$14+I38","v":71.067782684999997}]
[null,1200,"凝集","膜ろ過",2.6153819999999999,1.7021280000000001,{"$f":"$D$15*(F39-E39)/80000+(E39-(F39-E39)/80000*20000)","v":2.7067074},{"$f":"$H$40*G39","v":59.818233540000001},{"$f":"H39","v":59.818233540000001},{"$f":"$D$14+I39","v":80.21823354}]
[null,2100,"凝集沈澱","急速ろ過",0.99999899999999997,1.0000002000000001,1,{"$f":"D10","v":22.1},22.1,{"$f":"$D$12+I40","v":47.6}]
[null,2110,"粉末炭+凝集沈殿","急速ろ過",5.1282000000000005,5.1595754999999999,{"$f":"$D$15*(F41-E41)/80000+(E41-(F41-E41)/80000*20000)","v":5.1250624500000006},{"$f":"$H$40*G41","v":113.26388014500002},{"$f":"(H41-H40)*$D$53+H40","v":22.1},{"$f":"$D$12+I41","v":47.6}]
[null,2200,"凝集沈殿","膜ろ過",2.6153819999999999,1.7553195000000001,2.7013882499999999,{"$f":"$H$40*G42","v":59.700680325},59.700680325,{"$f":"$D$14+I42","v":80.100680324999999}]
[null,2210,"粉末炭+凝集沈殿","膜ろ過",6.7692240000000004,5.9042565000000007,6.8557207499999997,151.511428575,{"$f":"(H43-H42)*$D$53+H42","v":59.700680325},{"$f":"$D$14+I43","v":80.100680324999999}]
[null,3000,"凝集","急速ろ過",0.97435800000000006,0.95744700000000005,0.9760491,21.570685110000003,21.570685110000003,{"$f":"$D$12+I44","v":47.070685109999999}]
[null,5100,"凝集沈澱+粒状炭","急速ろ過",2.30769,2.2872345000000003,2.3097355499999996,51.045155654999995,51.045155654999995,{"$f":"$D$12+I45","v":76.545155655000002}]
[null,5200,"凝集沈澱+粒状炭","膜ろ過",3.9487140000000003,3.0851070000000003,4.0350747,89.17515087000001,89.17515087000001,{"$f":"$D$14+I46","v":109.57515087000002}]
[null,6100,"凝集沈澱+オゾン+粒状炭","急速ろ過",5.999994,3.3510645000000001,6.2648869499999993,138.45400159499999,138.45400159499999,{"$f":"$D$12+I47","v":163.95400159499999}]
[null,6200,"凝集沈澱+オゾン+粒状炭","膜ろ過",5.5897380000000005,4.0957455000000005,5.7391372500000006,126.83493322500003,126.83493322500003,{"$f":"$D$14+I48","v":147.23493322500002}]
[null,7100,"粒状炭","膜ろ過",3.4871760000000003,2.6595750000000002,3.5699361000000001,78.895587810000009,78.895587810000009,{"$f":"$D$14+I49","v":99.295587810000001}]
[null,7200,"凝集+粒状炭","膜ろ過",3.8974320000000002,3.0851070000000003,3.9786645000000007,87.928485450000025,87.928485450000025,{"$f":"$D$14+I50","v":108.32848545000002}]
[null,7300,"オゾン+粒状炭","膜ろ過",5.1794820000000001,3.6702135,5.3304088500000004,117.80203558500001,117.80203558500001,{"$f":"$D$14+I51","v":138.202035585}]
[null,null,null,null,null,null,null,"水道統計より、電力、消耗品分は全国平均10%程度。給水原価基準値×0.1を浄水フローの違いによる人件費を除く変動費とした。","粉末炭分は、e-WaterⅡでは10mg/L×365日で計算。粉炭の有無のみ異なるフローでの変動分の差分を全額粉炭とした。この粉炭分に入力情報での（注入率/10）×（日数/365）を乗じた。","入力情報(1)の浄水フロー"]
[null,null,"粉末炭の運転費係数",0,null,null,null,"No.2100以外は基準浄水単価×入力浄水量相対運転費"]
[null,null,null," ｢21.希望ﾌﾛｰ｣で\"粉末炭\"を含んでいる場合"]
[null,null,null,"　｢平均注入率｣と｢注入日数｣で算出"]