{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["自動計算表","水道R1.10改定","下水R5.4改定"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"自動計算表","index":0,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,0,23,1],[22,0,22,1],[11,0,15,0],[1,0,1,2],[2,0,10,0],[20,0,20,1],[19,0,19,1]]}
["◆水道料金表",null,null,"　（1か月当たり、税込）",null,"以下の項目に入力すると、水道料金と下水道使用料が計算できます。"]
["区　分",null,null,"金額（円）"]
["固　定　料　金",null,"口径　　13mm",1231.9999999999998,null,"◎毎月検針地区の場合"]
[null,null,"口径　　20mm",2288,null,"口径選択",null,"←　水道メーターの口径を選択してください。"]
[null,null,"口径　　25mm",2398,null,"ご使用水量",null,"←　半角英数の整数で入力してください。"]
[null,"5m3","口径　　30mm",7282.0000000000009,null,"下水道有無",null,"←　下水道の有無を選択してください。"]
[null,null,"口径　　40mm",28204.000000000004,null,"▼計算結果（税込、1か月当たり）"]
[null,"まで","口径　　50mm",55880.000000000007,null,"水道料金",{"$f":"IF(G5=\"\",\"\",ROUNDDOWN(VLOOKUP($G$4,$C$3:$D$11,2)+IF(G5<5,0,IF(G5<10,(G5-5)*$D$12,IF(G5<20,$D$12*5+$D$13*(G5-10),IF(G5<30,$D$12*5+$D$13*10+$D$14*(G5-20),IF(G5<100,$D$12*5+$D$13*10+$D$14*10+$D$15*(G5-30),$D$12*5+$D$13*10+$D$14*10+$D$15*70+$D$16*(G5-100)))))),0))","v":""}]
[null,null,"口径　　75mm",56980.000000000007,null,"下水道使用料",{"$f":"IF(G6=\"有\",ROUNDDOWN($D$21+IF(G5<5,0,IF(G5<10,(G5-5)*$D$22,IF(G5<20,$D$22*5+$D$23*(G5-10),IF(G5<30,$D$22*5+$D$23*10+$D$24*(G5-20),IF(G5<100,$D$22*5+$D$23*10+$D$24*10+$D$25*(G5-30),$D$22*5+$D$23*10+$D$24*10+$D$25*70+$D$26*(G5-100)))))),0),\"\")","v":""}]
[null,null,"口径　100mm",177100,null,"合計金額",{"$f":"IF(G5=\"\",\"\",SUM(G8:G9))","v":""}]
[null,null,"口径　150mm",180070]
["従量料金",null,"6～10m3",56.099999999999994]
[null,"1m3","11～20m3",171.6,null,"◎隔月検針地区の場合"]
[null,null,"21～30m3",183.70000000000002,null,"口径選択",null,"←　水道メーターの口径を選択してください。"]
[null,"当たり","31～100m3",212.29999999999998,null,"ご使用水量",null,"←　半角英数の整数で入力してください。"]
[null,null,"101m3以上",258.5,null,"下水道有無",null,"←　下水道の有無を選択してください。"]
[null,null,null,null,null,"▼計算結果（税込、2か月当たり）"]
[null,null,null,null,null,"水道料金",{"$f":"IF(G15=\"\",\"\",ROUNDDOWN(VLOOKUP($G$14,$C$3:$D$11,2)+IF(ROUNDDOWN(G15/2,0)<5,0,IF(ROUNDDOWN(G15/2,0)<10,(ROUNDDOWN(G15/2,0)-5)*$D$12,IF(ROUNDDOWN(G15/2,0)<20,$D$12*5+$D$13*(ROUNDDOWN(G15/2,0)-10),IF(ROUNDDOWN(G15/2,0)<30,$D$12*5+$D$13*10+$D$14*(ROUNDDOWN(G15/2,0)-20),IF(ROUNDDOWN(G15/2,0)<100,$D$12*5+$D$13*10+$D$14*10+$D$15*(ROUNDDOWN(G15/2,0)-30),$D$12*5+$D$13*10+$D$14*10+$D$15*70+$D$16*(ROUNDDOWN(G15/2,0)-100)))))),0)+ROUNDDOWN(VLOOKUP($G$14,$C$3:$D$11,2)+IF(G15-ROUNDDOWN(G15/2,0)<5,0,IF(G15-ROUNDDOWN(G15/2,0)<10,(G15-ROUNDDOWN(G15/2,0)-5)*$D$12,IF(G15-ROUNDDOWN(G15/2,0)<20,$D$12*5+$D$13*(G15-ROUNDDOWN(G15/2,0)-10),IF(G15-ROUNDDOWN(G15/2,0)<30,$D$12*5+$D$13*10+$D$14*(G15-ROUNDDOWN(G15/2,0)-20),IF(G15-ROUNDDOWN(G15/2,0)<100,$D$12*5+$D$13*10+$D$14*10+$D$15*(G15-ROUNDDOWN(G15/2,0)-30),$D$12*5+$D$13*10+$D$14*10+$D$15*70+$D$16*(G15-ROUNDDOWN(G15/2,0)-100)))))),0))","v":""}]
["◆下水道・排水施設使用料料金表",null,null,"　（1か月当たり、税込）",null,"下水道使用料",{"$f":"IF(G16=\"有\",ROUNDDOWN($D$21+IF(ROUNDDOWN(G15/2,0)<5,0,IF(ROUNDDOWN(G15/2,0)<10,(ROUNDDOWN(G15/2,0)-5)*$D$22,IF(ROUNDDOWN(G15/2,0)<20,$D$22*5+$D$23*(ROUNDDOWN(G15/2,0)-10),IF(ROUNDDOWN(G15/2,0)<30,$D$22*5+$D$23*10+$D$24*(ROUNDDOWN(G15/2,0)-20),IF(ROUNDDOWN(G15/2,0)<100,$D$22*5+$D$23*10+$D$24*10+$D$25*(ROUNDDOWN(G15/2,0)-30),$D$22*5+$D$23*10+$D$24*10+$D$25*70+$D$26*(ROUNDDOWN(G15/2,0)-100)))))),0)+ROUNDDOWN($D$21+IF(G15-ROUNDDOWN(G15/2,0)<5,0,IF(G15-ROUNDDOWN(G15/2,0)<10,(G15-ROUNDDOWN(G15/2,0)-5)*$D$22,IF(G15-ROUNDDOWN(G15/2,0)<20,$D$22*5+$D$23*(G15-ROUNDDOWN(G15/2,0)-10),IF(G15-ROUNDDOWN(G15/2,0)<30,$D$22*5+$D$23*10+$D$24*(G15-ROUNDDOWN(G15/2,0)-20),IF(G15-ROUNDDOWN(G15/2,0)<100,$D$22*5+$D$23*10+$D$24*10+$D$25*(G15-ROUNDDOWN(G15/2,0)-30),$D$22*5+$D$23*10+$D$24*10+$D$25*70+$D$26*(G15-ROUNDDOWN(G15/2,0)-100)))))),0),\"\")","v":""}]
["区　分",null,"汚水量","金額（円）",null,"合計金額",{"$f":"IF(G15=\"\",\"\",SUM(G18:G19))","v":""}]
["基本使用料",null,"5m3まで",1669.8]
[null,null,"6～10m3",86.9]
["超過使用料",null,"11～20m3",210.1,null,"（注意）"]
["（1m3当たり)",null,"21～30m3",238.7,null,"積雪等の理由でメーター指針が確認できない場合は、使用量を概算で認定し、"]
[null,null,"31～100m3",284.89999999999998,null,"指針が確認できた月に、認定期間を遡って料金を計算し直し精算します。"]
[null,null,"101m3以上",346.5,null,"この場合、上記計算結果と異なる場合があります。"]

{"sheet":"水道R1.10改定","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"下水R5.4改定","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}