{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["水道料金等計算","0.5ヶ月料金計算","1ヶ月料金計算","2ヶ月料金計算","0.5ヶ月料金計算（大口径）","1ヶ月料金計算（大口径）","2ヶ月料金計算（大口径）"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,1,7,2],[8,1,8,2],[9,1,9,2],[0,2,0,3],[10,0,11,4],[1,0,1,4],[5,0,6,4]]}
[null,null,"西播磨水道企業団　水道料金計算表（２か月計算）"]
["　お住まいの地区、口径を選択し、使用水量を入力して計算ボタンを押してください。\n　２か月分の水道料金、下水道使用料（参考）が表示されます。"]
[null,"✓","地区(相生、揖保川町、御津町）"]
[null,"✓","口径（㎜）"]
[null,"✓","使用水量（㎥）"]
[]
[]
[null,"上水道料金",null,{"$f":"IF(OR(D3=\"\",D4=\"\",D5=\"\",'2ヶ月料金計算'!C6=\"\",'2ヶ月料金計算（大口径）'!C6=\"\"),\"\",IF(D4=1,'2ヶ月料金計算'!C16,IF(D4=2,'2ヶ月料金計算'!C18,IF(D4=3,'2ヶ月料金計算'!C20,IF(D4=4,'2ヶ月料金計算（大口径）'!C16,IF(D4=5,'2ヶ月料金計算（大口径）'!C18,IF(D4=6,'2ヶ月料金計算（大口径）'!C20,IF(D4=7,'2ヶ月料金計算（大口径）'!C22,IF(D4=8,'2ヶ月料金計算（大口径）'!C24)))))))))","v":""}]
[null,"下水道使用量（参考）",null,{"$f":"IF(D8=\"\",\"\",IF(D3=1,'2ヶ月料金計算'!F16,'2ヶ月料金計算'!F17))","v":""}]
[null,"合計（参考）",null,{"$f":"IF(D8=\"\",\"\",D8+D9)","v":""}]
["\n　ご注意\n　※１　この水道料金計算表は､２か月分の水道料金等になります｡使用開始が月の途中など特別な計算が適用\n　　　されるお客さまは、西播磨水道企業団営業課までお問合せください。　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　\n　※２　下水道使用料の詳細については､相生市又はたつの市にお問合せください。\n　※３　令和４年４月１日からの相生市下水道使用料改定後の計算表です。\n"]

{"sheet":"0.5ヶ月料金計算","index":1,"n_rows":53,"n_cols":34,"rows_kept":53,"cut":false,"hidden":true,"merged":[[53,32,53,33],[54,14,54,16],[54,23,54,25],[50,32,50,33],[51,26,53,26],[51,29,51,30],[51,32,51,33],[52,32,52,33],[52,14,52,16],[52,23,52,25],[52,29,52,30],[53,14,53,16],[53,23,53,25],[53,29,53,30],[39,14,39,16],[39,23,39,25],[40,14,40,16],[40,23,40,25],[36,26,38,26],[37,14,37,16],[37,23,37,25],[38,14,38,16],[38,23,38,25],[27,30,29,34],[35,29,35,30],[35,32,35,33],[42,17,50,17],[42,26,50,26],[44,27,44,29],[44,30,44,34],[45,27,47,29],[38,32,38,33],[36,29,36,30],[36,32,36,33],[37,29,37,30],[37,32,37,33],[38,29,38,30],[45,30,47,34],[50,29,50,30],[24,26,35,26],[18,32,18,33],[19,1,20,1],[19,2,20,3],[20,14,20,16],[20,23,20,25],[20,29,20,30],[20,32,20,33],[21,1,22,1],[21,2,22,3],[22,14,22,16],[22,23,22,25],[24,17,35,17],[26,27,26,29],[26,30,26,34],[27,27,29,29],[15,1,16,1],[15,2,16,3],[16,26,20,26],[16,29,16,30],[16,32,16,33],[17,1,18,1],[17,2,18,3],[18,14,18,16],[18,23,18,25],[18,29,18,30],[5,32,5,33],[7,7,10,7],[13,4,13,7],[14,2,14,3],[14,4,14,5],[14,6,14,7],[14,29,14,30],[14,32,14,33],[5,29,5,30],[2,0,2,1],[3,2,4,6],[3,17,14,17],[3,26,14,26],[5,2,10,6]]}
[]
[null,null,null,null,null,null,null,null,"（水道料金）"]
[null,null,null,null,null,null,null,"税率",null,"従量料金計算"]
[{"$f":"C6","v":25},null,"水量を入力してください。",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,null,null,null,null,null,null,{"$f":"C6","v":25},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L5","v":0},"㎥",null,null,null,null,null,"基本料金"]
[null,null,25,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"口径","単価","1ケ月",null,"0.5ヶ月","２ケ月"]
[null,null,null,null,null,null,null,null,5,"6～10",43,{"$f":"K7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(L5>=10,I7,IF(L5>5,L5-5,0))","v":5},{"$f":"L7*O7","v":236.50000000000003},"円",null,"6～10",43,{"$f":"T7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(U5>=10,I7,IF(U5>5,U5-5,0))","v":0},{"$f":"U7*X7","v":0},"円",null,"13mm",543,{"$f":"AC7*(1+$H$4/100)","v":597.30000000000007},"円",{"$f":"INT(AD7/2)","v":298},{"$f":"INT(AD7*2)","v":1194},"円"]
[null,null,null,null,null,null,null,"㎥",10,"11～20",90,{"$f":"K8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(L5>=20,I8,IF(L5>10,L5-10,0))","v":10},{"$f":"L8*O8","v":990.00000000000011},"円",null,"11～20",90,{"$f":"T8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(U5>=20,I8,IF(U5>10,U5-10,0))","v":0},{"$f":"U8*X8","v":0},"円",null,"20mm",714,{"$f":"AC8*(1+$H$4/100)","v":785.40000000000009},"円",{"$f":"INT(AD8/2)","v":392},{"$f":"INT(AD8*2)","v":1570},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",129,141.9,"円","×",{"$f":"IF(L5>=30,I9,IF(L5>20,L5-20,0))","v":5},709.5,"円",null,"21～30",129,141.9,"円","×",{"$f":"IF(U5>=30,I9,IF(U5>20,U5-20,0))","v":0},{"$f":"U9*X9","v":0},"円",null,"25mm",1581,1739.1000000000001,"円",869,{"$f":"INT(AD9*2)","v":3478},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(L5>=50,I10,IF(L5>30,L5-30,0))","v":0},0,"円",null,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(U5>=50,I10,IF(U5>30,U5-30,0))","v":0},{"$f":"U10*X10","v":0},"円",null,"40mm",3752,4127.2000000000007,"円",2063,{"$f":"INT(AD10*2)","v":8254},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(L5>=100,I11,IF(L5>50,L5-50,0))","v":0},0,"円",null,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(U5>=100,I11,IF(U5>50,U5-50,0))","v":0},0,"円",null,"50mm",6952,7647.2000000000007,"円",3823,15294,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",214,235.4,"円","×",{"$f":"IF(L5>=200,I12,IF(L5>100,L5-100,0))","v":0},0,"円",null,"101～200",214,235.4,"円","×",{"$f":"IF(U5>=200,I12,IF(U5>100,U5-100,0))","v":0},0,"円",null,"75mm",17114,18825.400000000001,"円",9412,37650,"円"]
[null,null,null,null,null,null,null,null,null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(L5>=200,L5-200,0)","v":0},0,"円",null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(U5>=200,U5-200,0)","v":0},0,"円",null,"100mm",34114,37525.4,"円",18762,75050,"円"]
[null,"0.5ケ月計算",null,null,"※水量以外のセルへの入力や消去はしないでください。",null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P7:P13)","v":1936.0000000000002},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y7:Y13)","v":0},"円",null,"300mm",526276,578903.60000000009,"円",289451,1157807,"円"]
[null,null,"水道料金",null,"下水道使用料",null,"合　  計"]
[null,"13mm",{"$f":"P16","v":2234},null,"相",{"$f":"O38","v":4375},"相",{"$f":"C16+F16","v":6609},null,null,null,null,null,13,null,{"$f":"INT(P14+AF7)","v":2234},null,null,null,null,null,null,13,null,{"$f":"INT(Y14+AD7)","v":597}]
[null,null,null,null,"た",{"$f":"O53","v":3300},"た",{"$f":"C16+F17","v":5534},null,null,null,null,null,20,null,{"$f":"INT(P14+AF8)","v":2328},null,null,null,null,null,null,20,null,{"$f":"INT(Y14+AD8)","v":785}]
[null,"20mm",{"$f":"P17","v":2328},null,"相",{"$f":"O38","v":4375},"相",{"$f":"C18+F18","v":6703},null,null,null,null,null,25,null,{"$f":"INT(P14+AF9)","v":2805},null,null,null,null,null,null,25,null,{"$f":"INT(Y14+AD9)","v":1739}]
[null,null,null,null,"た",{"$f":"O53","v":3300},"た",{"$f":"C18+F19","v":5628},null,null,null,null,null,40,{"$f":"INT(P14+AD10)","v":6063},null,null,null,null,null,null,null,40,{"$f":"INT(Y14+AD10)","v":4127}]
[null,"25mm",{"$f":"P18","v":2805},null,"相",{"$f":"O38","v":4375},"相",{"$f":"C20+F20","v":7180},null,null,null,null,null,50,null,{"$f":"INT(P14+AD11)","v":9583},null,null,null,null,null,null,50,null,{"$f":"INT(Y14+AD11)","v":7647}]
[null,null,null,null,"た",{"$f":"O53","v":3300},"た",{"$f":"C20+F21","v":6105},null,null,null,null,null,75,{"$f":"INT(P14+AD12)","v":20761},null,null,null,null,null,null,null,75,{"$f":"INT(Y14+AD12)","v":18825}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,{"$f":"INT(P14+AD13)","v":39461},null,null,null,null,null,null,100,null,{"$f":"INT(Y14+AD13)","v":37525}]
[null,null,null,null,null,null,null,null,"（相生下水）",null,null,null,null,300,{"$f":"INT(P14+AD14)","v":580839},null,null,null,null,null,null,null,300,{"$f":"INT(Y14+AD14)","v":578903}]
[null,null,null,null,null,null,null,null,null,"従量料金計算"]
[null,null,null,null,null,null,null,null,null,"１ケ月目",null,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":"C6","v":25},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L26","v":0},"㎥",null,null,null,null,null,"基本料金","単価",1173]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,5,"6～10",42,{"$f":"K28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(L26>=10,I28,IF(L26>5,L26-5,0))","v":5},{"$f":"L28*O28","v":231},"円",null,"6～10",42,{"$f":"T28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(U26>=10,I28,IF(U26>5,U26-5,0))","v":0},{"$f":"U28*X28","v":0},"円",null,{"$f":"AD26*(1+$H$4/100)","v":1290.3000000000002},null,null,{"$f":"AB28*2","v":2580.6000000000004}]
[null,null,null,null,null,null,null,null,10,"11～20",159,{"$f":"K29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(L26>=20,I29,IF(L26>10,L26-10,0))","v":10},{"$f":"L29*O29","v":1749},"円",null,"11～20",159,{"$f":"T29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(U26>=20,I29,IF(U26>10,U26-10,0))","v":0},{"$f":"U29*X29","v":0},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(L26>=30,I30,IF(L26>20,L26-20,0))","v":5},{"$f":"L30*O30","v":1105.5},"円",null,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(U26>=30,I30,IF(U26>20,U26-20,0))","v":0},{"$f":"U30*X30","v":0},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(L26>=50,I31,IF(L26>30,L26-30,0))","v":0},0,"円",null,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(U26>=50,I31,IF(U26>30,U26-30,0))","v":0},{"$f":"U31*X31","v":0},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",245,269.5,"円","×",{"$f":"IF(L26>=100,I32,IF(L26>50,L26-50,0))","v":0},0,"円",null,"51～100",245,269.5,"円","×",{"$f":"IF(U26>=100,I32,IF(U26>50,U26-50,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(L26>=200,I33,IF(L26>100,L26-100,0))","v":0},0,"円",null,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(U26>=200,I33,IF(U26>100,U26-100,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,200,"201～",276,303.60000000000002,"円","×",{"$f":"IF(L26>=200,L26-200,0)","v":0},0,"円",null,"201～",276,303.60000000000002,"円","×",{"$f":"IF(U26>=200,U26-200,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P28:P34)","v":3085.5},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y28:Y34)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P35+AB28)","v":4375},null,null,null,null,null,null,null,null,{"$f":"INT(Y35+AB28)","v":1290}]
[]
[]
[null,null,null,null,null,null,null,null,"（たつの下水）",null,null,null,null,25,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,"従量料金計算"]
[null,null,null,null,null,null,null,null,null,"１ケ月目",null,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":"C6","v":25},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L44","v":0},"㎥",null,null,null,null,null,"基本料金","単価",900]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,10,"11～20",130,{"$f":"K46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(L44>=20,I46,IF(L44>10,L44-10,0))","v":10},{"$f":"L46*O46","v":1430},"円",null,"11～20",130,{"$f":"T46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(U44>=20,I46,IF(U44>10,U44-10,0))","v":0},{"$f":"U46*X46","v":0},"円",null,{"$f":"AD44*(1+$H$4/100)","v":990.00000000000011},null,null,{"$f":"AB46*2","v":1980.0000000000002}]
[null,null,null,null,null,null,null,null,20,"21～40",160,{"$f":"K47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(L44>=40,I47,IF(L44>20,L44-20,0))","v":5},{"$f":"L47*O47","v":880},"円",null,"21～40",160,{"$f":"T47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(U44>=40,I47,IF(U44>20,U44-20,0))","v":0},{"$f":"U47*X47","v":0},"円"]
[null,null,null,null,null,null,null,null,60,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(L44>=100,I48,IF(L44>40,L44-40,0))","v":0},{"$f":"L48*O48","v":0},"円",null,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(U44>=100,I48,IF(U44>40,U44-40,0))","v":0},{"$f":"U48*X48","v":0},"円"]
[null,null,null,null,null,null,null,null,null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(L44>=100,L44-100,0)","v":0},0,"円",null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(U44>=100,U44-100,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P46:P49)","v":2310},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y46:Y49)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P50+AB46)","v":3300},null,null,null,null,null,null,null,null,{"$f":"INT(Y50+AB46)","v":990}]

{"sheet":"1ヶ月料金計算","index":2,"n_rows":53,"n_cols":33,"rows_kept":53,"cut":false,"hidden":true,"merged":[[2,0,2,1],[3,2,4,6],[3,17,14,17],[3,26,14,26],[5,2,10,6],[5,31,5,32],[7,7,10,7],[13,4,13,7],[14,2,14,3],[14,4,14,5],[14,6,14,7],[14,29,14,30],[14,31,14,32],[5,29,5,30],[15,1,16,1],[15,2,16,3],[16,26,20,26],[16,29,16,30],[16,31,16,32],[17,1,18,1],[17,2,18,3],[18,14,18,16],[18,23,18,25],[18,29,18,30],[24,26,35,26],[18,31,18,32],[19,1,20,1],[19,2,20,3],[20,14,20,16],[20,23,20,25],[20,29,20,30],[20,31,20,32],[21,1,22,1],[21,2,22,3],[22,14,22,16],[22,23,22,25],[24,17,35,17],[26,27,26,29],[26,30,26,33],[27,27,29,29],[27,30,29,33],[35,29,35,30],[35,31,35,32],[42,17,50,17],[42,26,50,26],[44,27,44,29],[44,30,44,33],[45,27,47,29],[38,31,38,32],[36,29,36,30],[36,31,36,32],[37,29,37,30],[37,31,37,32],[38,29,38,30],[45,30,47,33],[50,29,50,30],[39,14,39,16],[39,23,39,25],[40,14,40,16],[40,23,40,25],[36,26,38,26],[37,14,37,16],[37,23,37,25],[38,14,38,16],[38,23,38,25],[53,31,53,32],[54,14,54,16],[54,23,54,25],[50,31,50,32],[51,26,53,26],[51,29,51,30],[51,31,51,32],[52,31,52,32],[52,14,52,16],[52,23,52,25],[52,29,52,30],[53,14,53,16],[53,23,53,25],[53,29,53,30]]}
[]
[null,null,null,null,null,null,null,null,"（水道料金）"]
[null,null,null,null,null,null,null,"税率",null,"従量料金計算"]
[{"$f":"C6","v":25},null,"水量を入力してください。",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,null,null,null,null,null,null,{"$f":"C6","v":25},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L5","v":0},"㎥",null,null,null,null,null,"基本料金"]
[null,null,25,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"口径","単価","1ケ月",null,"２ケ月"]
[null,null,null,null,null,null,null,null,5,"6～10",43,{"$f":"K7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(L5>=10,I7,IF(L5>5,L5-5,0))","v":5},{"$f":"L7*O7","v":236.50000000000003},"円",null,"6～10",43,{"$f":"T7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(U5>=10,I7,IF(U5>5,U5-5,0))","v":0},{"$f":"U7*X7","v":0},"円",null,"13mm",543,{"$f":"AC7*(1+$H$4/100)","v":597.30000000000007},"円",{"$f":"INT(AD7*2)","v":1194},"円"]
[null,null,null,null,null,null,null,"㎥",10,"11～20",90,{"$f":"K8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(L5>=20,I8,IF(L5>10,L5-10,0))","v":10},{"$f":"L8*O8","v":990.00000000000011},"円",null,"11～20",90,{"$f":"T8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(U5>=20,I8,IF(U5>10,U5-10,0))","v":0},{"$f":"U8*X8","v":0},"円",null,"20mm",714,{"$f":"AC8*(1+$H$4/100)","v":785.40000000000009},"円",{"$f":"INT(AD8*2)","v":1570},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",129,141.9,"円","×",{"$f":"IF(L5>=30,I9,IF(L5>20,L5-20,0))","v":5},709.5,"円",null,"21～30",129,141.9,"円","×",{"$f":"IF(U5>=30,I9,IF(U5>20,U5-20,0))","v":0},{"$f":"U9*X9","v":0},"円",null,"25mm",1581,1739.1000000000001,"円",{"$f":"INT(AD9*2)","v":3478},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(L5>=50,I10,IF(L5>30,L5-30,0))","v":0},0,"円",null,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(U5>=50,I10,IF(U5>30,U5-30,0))","v":0},{"$f":"U10*X10","v":0},"円",null,"40mm",3752,4127.2000000000007,"円",{"$f":"INT(AD10*2)","v":8254},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(L5>=100,I11,IF(L5>50,L5-50,0))","v":0},0,"円",null,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(U5>=100,I11,IF(U5>50,U5-50,0))","v":0},0,"円",null,"50mm",6952,7647.2000000000007,"円",15294,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",214,235.4,"円","×",{"$f":"IF(L5>=200,I12,IF(L5>100,L5-100,0))","v":0},0,"円",null,"101～200",214,235.4,"円","×",{"$f":"IF(U5>=200,I12,IF(U5>100,U5-100,0))","v":0},0,"円",null,"75mm",17114,18825.400000000001,"円",37650,"円"]
[null,null,null,null,null,null,null,null,null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(L5>=200,L5-200,0)","v":0},0,"円",null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(U5>=200,U5-200,0)","v":0},0,"円",null,"100mm",34114,37525.4,"円",75050,"円"]
[null,"1ケ月計算",null,null,"※水量以外のセルへの入力や消去はしないでください。",null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P7:P13)","v":1936.0000000000002},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y7:Y13)","v":0},"円",null,"300mm",526276,578903.60000000009,"円",1157807,"円"]
[null,null,"水道料金",null,"下水道使用料",null,"合　  計"]
[null,"13mm",{"$f":"P16","v":2533},null,"相",{"$f":"O38","v":4375},"相",{"$f":"C16+F16","v":6908},null,null,null,null,null,13,null,{"$f":"INT(P14+AD7)","v":2533},null,null,null,null,null,null,13,null,{"$f":"INT(Y14+AD7)","v":597}]
[null,null,null,null,"た",{"$f":"O53","v":3300},"た",{"$f":"C16+F17","v":5833},null,null,null,null,null,20,null,{"$f":"INT(P14+AD8)","v":2721},null,null,null,null,null,null,20,null,{"$f":"INT(Y14+AD8)","v":785}]
[null,"20mm",{"$f":"P17","v":2721},null,"相",{"$f":"O38","v":4375},"相",{"$f":"C18+F18","v":7096},null,null,null,null,null,25,null,{"$f":"INT(P14+AD9)","v":3675},null,null,null,null,null,null,25,null,{"$f":"INT(Y14+AD9)","v":1739}]
[null,null,null,null,"た",{"$f":"O53","v":3300},"た",{"$f":"C18+F19","v":6021},null,null,null,null,null,40,{"$f":"INT(P14+AD10)","v":6063},null,null,null,null,null,null,null,40,{"$f":"INT(Y14+AD10)","v":4127}]
[null,"25mm",{"$f":"P18","v":3675},null,"相",{"$f":"O38","v":4375},"相",{"$f":"C20+F20","v":8050},null,null,null,null,null,50,null,{"$f":"INT(P14+AD11)","v":9583},null,null,null,null,null,null,50,null,{"$f":"INT(Y14+AD11)","v":7647}]
[null,null,null,null,"た",{"$f":"O53","v":3300},"た",{"$f":"C20+F21","v":6975},null,null,null,null,null,75,{"$f":"INT(P14+AD12)","v":20761},null,null,null,null,null,null,null,75,{"$f":"INT(Y14+AD12)","v":18825}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,{"$f":"INT(P14+AD13)","v":39461},null,null,null,null,null,null,100,null,{"$f":"INT(Y14+AD13)","v":37525}]
[null,null,null,null,null,null,null,null,"（相生下水）",null,null,null,null,300,{"$f":"INT(P14+AD14)","v":580839},null,null,null,null,null,null,null,300,{"$f":"INT(Y14+AD14)","v":578903}]
[null,null,null,null,null,null,null,null,null,"従量料金計算"]
[null,null,null,null,null,null,null,null,null,"１ケ月目",null,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":"C6","v":25},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L26","v":0},"㎥",null,null,null,null,null,"基本料金","単価",1173]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,5,"6～10",42,{"$f":"K28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(L26>=10,I28,IF(L26>5,L26-5,0))","v":5},{"$f":"L28*O28","v":231},"円",null,"6～10",42,{"$f":"T28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(U26>=10,I28,IF(U26>5,U26-5,0))","v":0},{"$f":"U28*X28","v":0},"円",null,{"$f":"AD26*(1+$H$4/100)","v":1290.3000000000002},null,null,{"$f":"AB28*2","v":2580.6000000000004}]
[null,null,null,null,null,null,null,null,10,"11～20",159,{"$f":"K29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(L26>=20,I29,IF(L26>10,L26-10,0))","v":10},{"$f":"L29*O29","v":1749},"円",null,"11～20",159,{"$f":"T29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(U26>=20,I29,IF(U26>10,U26-10,0))","v":0},{"$f":"U29*X29","v":0},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(L26>=30,I30,IF(L26>20,L26-20,0))","v":5},{"$f":"L30*O30","v":1105.5},"円",null,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(U26>=30,I30,IF(U26>20,U26-20,0))","v":0},{"$f":"U30*X30","v":0},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(L26>=50,I31,IF(L26>30,L26-30,0))","v":0},0,"円",null,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(U26>=50,I31,IF(U26>30,U26-30,0))","v":0},{"$f":"U31*X31","v":0},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",245,269.5,"円","×",{"$f":"IF(L26>=100,I32,IF(L26>50,L26-50,0))","v":0},0,"円",null,"51～100",245,269.5,"円","×",{"$f":"IF(U26>=100,I32,IF(U26>50,U26-50,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(L26>=200,I33,IF(L26>100,L26-100,0))","v":0},0,"円",null,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(U26>=200,I33,IF(U26>100,U26-100,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,200,"201～",276,303.60000000000002,"円","×",{"$f":"IF(L26>=200,L26-200,0)","v":0},0,"円",null,"201～",276,303.60000000000002,"円","×",{"$f":"IF(U26>=200,U26-200,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P28:P34)","v":3085.5},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y28:Y34)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P35+AB28)","v":4375},null,null,null,null,null,null,null,null,{"$f":"INT(Y35+AB28)","v":1290}]
[]
[]
[null,null,null,null,null,null,null,null,"（たつの下水）",null,null,null,null,25,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,"従量料金計算"]
[null,null,null,null,null,null,null,null,null,"１ケ月目",null,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":"C6","v":25},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L44","v":0},"㎥",null,null,null,null,null,"基本料金","単価",900]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,10,"11～20",130,{"$f":"K46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(L44>=20,I46,IF(L44>10,L44-10,0))","v":10},{"$f":"L46*O46","v":1430},"円",null,"11～20",130,{"$f":"T46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(U44>=20,I46,IF(U44>10,U44-10,0))","v":0},{"$f":"U46*X46","v":0},"円",null,{"$f":"AD44*(1+$H$4/100)","v":990.00000000000011},null,null,{"$f":"AB46*2","v":1980.0000000000002}]
[null,null,null,null,null,null,null,null,20,"21～40",160,{"$f":"K47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(L44>=40,I47,IF(L44>20,L44-20,0))","v":5},{"$f":"L47*O47","v":880},"円",null,"21～40",160,{"$f":"T47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(U44>=40,I47,IF(U44>20,U44-20,0))","v":0},{"$f":"U47*X47","v":0},"円"]
[null,null,null,null,null,null,null,null,60,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(L44>=100,I48,IF(L44>40,L44-40,0))","v":0},{"$f":"L48*O48","v":0},"円",null,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(U44>=100,I48,IF(U44>40,U44-40,0))","v":0},{"$f":"U48*X48","v":0},"円"]
[null,null,null,null,null,null,null,null,null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(L44>=100,L44-100,0)","v":0},0,"円",null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(U44>=100,U44-100,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P46:P49)","v":2310},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y46:Y49)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P50+AB46)","v":3300},null,null,null,null,null,null,null,null,{"$f":"INT(Y50+AB46)","v":990}]

{"sheet":"2ヶ月料金計算","index":3,"n_rows":53,"n_cols":35,"rows_kept":53,"cut":false,"hidden":true,"merged":[[2,0,2,1],[3,2,4,6],[3,17,14,17],[3,26,14,26],[5,2,10,6],[5,31,5,32],[7,7,10,7],[13,4,13,7],[14,2,14,3],[14,4,14,5],[14,6,14,7],[14,29,14,30],[14,31,14,32],[5,29,5,30],[15,1,16,1],[15,2,16,3],[16,26,20,26],[16,29,16,30],[16,31,16,32],[17,1,18,1],[17,2,18,3],[18,14,18,16],[18,23,18,25],[18,29,18,30],[24,26,35,26],[18,31,18,32],[19,1,20,1],[19,2,20,3],[20,14,20,16],[20,23,20,25],[20,29,20,30],[20,31,20,32],[21,1,22,1],[21,2,22,3],[22,14,22,16],[22,23,22,25],[24,17,35,17],[26,27,26,29],[26,30,26,33],[27,27,29,29],[27,30,29,33],[35,29,35,30],[35,31,35,32],[42,17,50,17],[42,26,50,26],[44,27,44,29],[44,30,44,33],[45,27,47,29],[38,31,38,32],[36,29,36,30],[36,31,36,32],[37,29,37,30],[37,31,37,32],[38,29,38,30],[45,30,47,33],[50,29,50,30],[39,14,39,16],[39,23,39,25],[40,14,40,16],[40,23,40,25],[36,26,38,26],[37,14,37,16],[37,23,37,25],[38,14,38,16],[38,23,38,25],[53,31,53,32],[54,14,54,16],[54,23,54,25],[50,31,50,32],[51,26,53,26],[51,29,51,30],[51,31,51,32],[52,31,52,32],[52,14,52,16],[52,23,52,25],[52,29,52,30],[53,14,53,16],[53,23,53,25],[53,29,53,30]]}
[]
[null,null,null,null,null,null,null,null,"（水道料金）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　　 相生市"]
[null,null,null,null,null,null,null,"税率",null,"従量料金計算",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":"C6","v":0},null,"水量を入力してください。",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,null,null,null,null,null,null,{"$f":"ROUNDDOWN(A4/2,0)","v":0},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L5","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,null,null,"口径","単価","1ケ月",null,"２ケ月"]
[null,null,null,null,null,null,null,null,5,"6～10",43,{"$f":"K7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(L5>=10,I7,IF(L5>5,L5-5,0))","v":0},{"$f":"L7*O7","v":0},"円",null,"6～10",43,{"$f":"T7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(U5>=10,I7,IF(U5>5,U5-5,0))","v":0},{"$f":"U7*X7","v":0},"円",null,"　　 13mm",543,{"$f":"AC7*(1+$H$4/100)","v":597.30000000000007},"円",{"$f":"INT(AD7*2)","v":1194},"円"]
[null,null,null,null,null,null,null,"㎥",10,"11～20",90,{"$f":"K8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(L5>=20,I8,IF(L5>10,L5-10,0))","v":0},{"$f":"L8*O8","v":0},"円",null,"11～20",90,{"$f":"T8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(U5>=20,I8,IF(U5>10,U5-10,0))","v":0},{"$f":"U8*X8","v":0},"円",null,"　　 20mm",714,{"$f":"AC8*(1+$H$4/100)","v":785.40000000000009},"円",{"$f":"INT(AD8*2)","v":1570},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",129,141.9,"円","×",{"$f":"IF(L5>=30,I9,IF(L5>20,L5-20,0))","v":0},0,"円",null,"21～30",129,141.9,"円","×",{"$f":"IF(U5>=30,I9,IF(U5>20,U5-20,0))","v":0},{"$f":"U9*X9","v":0},"円",null,"　　 25mm",1581,1739.1000000000001,"円",{"$f":"INT(AD9*2)","v":3478},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(L5>=50,I10,IF(L5>30,L5-30,0))","v":0},0,"円",null,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(U5>=50,I10,IF(U5>30,U5-30,0))","v":0},{"$f":"U10*X10","v":0},"円",null,"　　 40mm",3752,4127.2000000000007,"円",{"$f":"INT(AD10*2)","v":8254},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(L5>=100,I11,IF(L5>50,L5-50,0))","v":0},0,"円",null,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(U5>=100,I11,IF(U5>50,U5-50,0))","v":0},0,"円",null,"　　 50mm",6952,7647.2000000000007,"円",15294,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",214,235.4,"円","×",{"$f":"IF(L5>=200,I12,IF(L5>100,L5-100,0))","v":0},0,"円",null,"101～200",214,235.4,"円","×",{"$f":"IF(U5>=200,I12,IF(U5>100,U5-100,0))","v":0},0,"円",null,"　　 75mm",17114,18825.400000000001,"円",37650,"円"]
[null,null,null,null,null,null,null,null,null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(L5>=200,L5-200,0)","v":0},0,"円",null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(U5>=200,U5-200,0)","v":0},0,"円",null,"　　 100mm",34114,37525.4,"円",75050,"円"]
[null,"２ケ月計算",null,null,"※水量以外のセルへの入力や消去はしないでください。",null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P7:P13)","v":0},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y7:Y13)","v":0},"円",null,"　　 300mm",526276,578903.60000000009,"円",1157807,"円"]
[null,null,"水道料金",null,"下水道使用料",null,"合　  計"]
[null,"13mm",{"$f":"P16+Y16","v":1194},null,"相",{"$f":"O38+X38","v":2580},"相",{"$f":"C16+F16","v":3774},null,null,null,null,null,13,null,{"$f":"INT(P14+AD7)","v":597},null,null,null,null,null,null,13,null,{"$f":"INT(Y14+AD7)","v":597}]
[null,null,null,null,"た",{"$f":"O53+X53","v":1980},"た",{"$f":"C16+F17","v":3174},null,null,null,null,null,20,null,{"$f":"INT(P14+AD8)","v":785},null,null,null,null,null,null,20,null,{"$f":"INT(Y14+AD8)","v":785}]
[null,"20mm",{"$f":"P17+Y17","v":1570},null,"相",{"$f":"O38+X38","v":2580},"相",{"$f":"C18+F18","v":4150},null,null,null,null,null,25,null,{"$f":"INT(P14+AD9)","v":1739},null,null,null,null,null,null,25,null,{"$f":"INT(Y14+AD9)","v":1739}]
[null,null,null,null,"た",{"$f":"O53+X53","v":1980},"た",{"$f":"C18+F19","v":3550},null,null,null,null,null,40,{"$f":"INT(P14+AD10)","v":4127},null,null,null,null,null,null,null,40,{"$f":"INT(Y14+AD10)","v":4127}]
[null,"25mm",{"$f":"P18+Y18","v":3478},null,"相",{"$f":"O38+X38","v":2580},"相",{"$f":"C20+F20","v":6058},null,null,null,null,null,50,null,{"$f":"INT(P14+AD11)","v":7647},null,null,null,null,null,null,50,null,{"$f":"INT(Y14+AD11)","v":7647}]
[null,null,null,null,"た",{"$f":"O53+X53","v":1980},"た",{"$f":"C20+F21","v":5458},null,null,null,null,null,75,{"$f":"INT(P14+AD12)","v":18825},null,null,null,null,null,null,null,75,{"$f":"INT(Y14+AD12)","v":18825}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,{"$f":"INT(P14+AD13)","v":37525},null,null,null,null,null,null,100,null,{"$f":"INT(Y14+AD13)","v":37525}]
[null,null,null,null,null,null,null,null,"（相生下水）",null,null,null,null,300,{"$f":"INT(P14+AD14)","v":578903},null,null,null,null,null,null,null,300,{"$f":"INT(Y14+AD14)","v":578903}]
[null,null,null,null,null,null,null,null,null,"従量料金計算"]
[null,null,null,null,null,null,null,null,null,"１ケ月目",null,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":"ROUNDDOWN(A4/2,0)","v":0},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L26","v":0},"㎥",null,null,null,null,null,"基本料金","単価",1173]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,5,"6～10",42,{"$f":"K28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(L26>=10,I28,IF(L26>5,L26-5,0))","v":0},{"$f":"L28*O28","v":0},"円",null,"6～10",42,{"$f":"T28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(U26>=10,I28,IF(U26>5,U26-5,0))","v":0},{"$f":"U28*X28","v":0},"円",null,{"$f":"AD26*(1+$H$4/100)","v":1290.3000000000002},null,null,{"$f":"AB28*2","v":2580.6000000000004}]
[null,null,null,null,null,null,null,null,10,"11～20",159,{"$f":"K29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(L26>=20,I29,IF(L26>10,L26-10,0))","v":0},{"$f":"L29*O29","v":0},"円",null,"11～20",159,{"$f":"T29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(U26>=20,I29,IF(U26>10,U26-10,0))","v":0},{"$f":"U29*X29","v":0},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(L26>=30,I30,IF(L26>20,L26-20,0))","v":0},{"$f":"L30*O30","v":0},"円",null,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(U26>=30,I30,IF(U26>20,U26-20,0))","v":0},{"$f":"U30*X30","v":0},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(L26>=50,I31,IF(L26>30,L26-30,0))","v":0},0,"円",null,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(U26>=50,I31,IF(U26>30,U26-30,0))","v":0},{"$f":"U31*X31","v":0},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",245,269.5,"円","×",{"$f":"IF(L26>=100,I32,IF(L26>50,L26-50,0))","v":0},0,"円",null,"51～100",245,269.5,"円","×",{"$f":"IF(U26>=100,I32,IF(U26>50,U26-50,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(L26>=200,I33,IF(L26>100,L26-100,0))","v":0},0,"円",null,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(U26>=200,I33,IF(U26>100,U26-100,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,200,"201～",276,303.60000000000002,"円","×",{"$f":"IF(L26>=200,L26-200,0)","v":0},0,"円",null,"201～",276,303.60000000000002,"円","×",{"$f":"IF(U26>=200,U26-200,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P28:P34)","v":0},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y28:Y34)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P35+AB28)","v":1290},null,null,null,null,null,null,null,null,{"$f":"INT(Y35+AB28)","v":1290}]
[]
[]
[null,null,null,null,null,null,null,null,"（たつの下水）",null,null,null,null,25,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,"従量料金計算"]
[null,null,null,null,null,null,null,null,null,"１ケ月目",null,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":"ROUNDDOWN(A4/2,0)","v":0},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L44","v":0},"㎥",null,null,null,null,null,"基本料金","単価",900]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,10,"11～20",130,{"$f":"K46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(L44>=20,I46,IF(L44>10,L44-10,0))","v":0},{"$f":"L46*O46","v":0},"円",null,"11～20",130,{"$f":"T46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(U44>=20,I46,IF(U44>10,U44-10,0))","v":0},{"$f":"U46*X46","v":0},"円",null,{"$f":"AD44*(1+$H$4/100)","v":990.00000000000011},null,null,{"$f":"AB46*2","v":1980.0000000000002}]
[null,null,null,null,null,null,null,null,20,"21～40",160,{"$f":"K47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(L44>=40,I47,IF(L44>20,L44-20,0))","v":0},{"$f":"L47*O47","v":0},"円",null,"21～40",160,{"$f":"T47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(U44>=40,I47,IF(U44>20,U44-20,0))","v":0},{"$f":"U47*X47","v":0},"円"]
[null,null,null,null,null,null,null,null,60,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(L44>=100,I48,IF(L44>40,L44-40,0))","v":0},{"$f":"L48*O48","v":0},"円",null,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(U44>=100,I48,IF(U44>40,U44-40,0))","v":0},{"$f":"U48*X48","v":0},"円"]
[null,null,null,null,null,null,null,null,null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(L44>=100,L44-100,0)","v":0},0,"円",null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(U44>=100,U44-100,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P46:P49)","v":0},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y46:Y49)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P50+AB46)","v":990},null,null,null,null,null,null,null,null,{"$f":"INT(Y50+AB46)","v":990}]

{"sheet":"0.5ヶ月料金計算（大口径）","index":4,"n_rows":53,"n_cols":34,"rows_kept":53,"cut":false,"hidden":true,"merged":[[54,14,54,16],[54,23,54,25],[52,14,52,16],[52,23,52,25],[52,29,52,30],[51,26,53,26],[51,29,51,30],[51,32,51,33],[52,32,52,33],[53,14,53,16],[53,23,53,25],[53,29,53,30],[53,32,53,33],[38,32,38,33],[39,14,39,16],[39,23,39,25],[40,14,40,16],[40,23,40,25],[36,26,38,26],[36,29,36,30],[36,32,36,33],[37,14,37,16],[37,23,37,25],[37,29,37,30],[37,32,37,33],[38,14,38,16],[38,23,38,25],[38,29,38,30],[42,17,50,17],[42,26,50,26],[44,27,44,29],[44,30,44,34],[45,27,47,29],[45,30,47,34],[50,29,50,30],[50,32,50,33],[23,1,24,1],[23,2,24,3],[24,17,35,17],[24,26,35,26],[26,27,26,29],[26,30,26,34],[27,27,29,29],[27,30,29,34],[35,29,35,30],[35,32,35,33],[20,23,20,25],[20,29,20,30],[20,32,20,33],[21,1,22,1],[21,2,22,3],[21,14,21,16],[21,23,21,25],[22,14,22,16],[22,23,22,25],[15,1,16,1],[15,2,16,3],[16,26,20,26],[16,29,16,30],[16,32,16,33],[17,1,18,1],[17,2,18,3],[18,14,18,16],[18,23,18,25],[18,29,18,30],[18,32,18,33],[19,1,20,1],[19,2,20,3],[19,14,19,16],[19,23,19,25],[20,14,20,16],[5,32,5,33],[7,7,10,7],[13,4,13,7],[14,2,14,3],[14,4,14,5],[14,6,14,7],[14,29,14,30],[14,32,14,33],[5,29,5,30],[2,0,2,1],[3,2,4,6],[3,17,14,17],[3,26,14,26],[5,2,10,6]]}
[]
[null,null,null,null,null,null,null,null,"（水道料金）"]
[null,null,null,null,null,null,null,"税率",null,"従量料金計算"]
[{"$f":"C6","v":25},null,"水量を入力してください。",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,null,null,null,null,null,null,{"$f":"A4","v":25},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L5","v":0},"㎥",null,null,null,null,null,"基本料金"]
[null,null,25,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"口径","単価","1ケ月",null,"0.5ヶ月","２ケ月"]
[null,null,null,null,null,null,null,null,10,"6～10",43,{"$f":"K7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(L5>=10,I7,IF(L5>0,L5-0,0))","v":10},{"$f":"L7*O7","v":473.00000000000006},"円",null,"6～10",43,{"$f":"T7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(U5>=10,I7,IF(U5>0,U5-0,0))","v":0},{"$f":"U7*X7","v":0},"円",null,"13mm",543,{"$f":"AC7*(1+$H$4/100)","v":597.30000000000007},"円",{"$f":"INT(AD7/2)","v":298},{"$f":"INT(AD7*2)","v":1194},"円"]
[null,null,null,null,null,null,null,"㎥",10,"11～20",90,{"$f":"K8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(L5>=20,I8,IF(L5>10,L5-10,0))","v":10},{"$f":"L8*O8","v":990.00000000000011},"円",null,"11～20",90,{"$f":"T8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(U5>=20,I8,IF(U5>10,U5-10,0))","v":0},{"$f":"U8*X8","v":0},"円",null,"20mm",714,{"$f":"AC8*(1+$H$4/100)","v":785.40000000000009},"円",{"$f":"INT(AD8/2)","v":392},{"$f":"INT(AD8*2)","v":1570},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",129,141.9,"円","×",{"$f":"IF(L5>=30,I9,IF(L5>20,L5-20,0))","v":5},709.5,"円",null,"21～30",129,141.9,"円","×",{"$f":"IF(U5>=30,I9,IF(U5>20,U5-20,0))","v":0},{"$f":"U9*X9","v":0},"円",null,"25mm",1581,1739.1000000000001,"円",869,{"$f":"INT(AD9*2)","v":3478},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(L5>=50,I10,IF(L5>30,L5-30,0))","v":0},0,"円",null,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(U5>=50,I10,IF(U5>30,U5-30,0))","v":0},{"$f":"U10*X10","v":0},"円",null,"40mm",3752,4127.2000000000007,"円",2063,{"$f":"INT(AD10*2)","v":8254},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(L5>=100,I11,IF(L5>50,L5-50,0))","v":0},0,"円",null,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(U5>=100,I11,IF(U5>50,U5-50,0))","v":0},0,"円",null,"50mm",6952,7647.2000000000007,"円",3823,15294,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",214,235.4,"円","×",{"$f":"IF(L5>=200,I12,IF(L5>100,L5-100,0))","v":0},0,"円",null,"101～200",214,235.4,"円","×",{"$f":"IF(U5>=200,I12,IF(U5>100,U5-100,0))","v":0},0,"円",null,"75mm",17114,18825.400000000001,"円",9412,37650,"円"]
[null,null,null,null,null,null,null,null,null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(L5>=200,L5-200,0)","v":0},0,"円",null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(U5>=200,U5-200,0)","v":0},0,"円",null,"100mm",34114,37525.4,"円",18762,75050,"円"]
[null,"0.5ケ月計算",null,null,"※水量以外のセルへの入力や消去はしないでください。",null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P7:P13)","v":2172.5},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y7:Y13)","v":0},"円",null,"300mm",526276,578903.60000000009,"円",289451,1157807,"円"]
[null,null,"水道料金",null,"下水道使用料",null,"合　  計"]
[null,"40mm",{"$f":"O19","v":4235},null,"相",{"$f":"$O$38","v":4375},"相",{"$f":"C16+F16","v":8610},null,null,null,null,null,13,null,{"$f":"INT(P14+AD7)","v":2769},null,null,null,null,null,null,13,null,{"$f":"INT(Y14+AD7)","v":597}]
[null,null,null,null,"た",{"$f":"$O$53","v":3300},"た",{"$f":"C16+F17","v":7535},null,null,null,null,null,20,null,{"$f":"INT(P14+AD8)","v":2957},null,null,null,null,null,null,20,null,{"$f":"INT(Y14+AD8)","v":785}]
[null,"50mm",{"$f":"O20","v":5995},null,"相",{"$f":"$O$38","v":4375},"相",{"$f":"C18+F18","v":10370},null,null,null,null,null,25,null,{"$f":"INT(P14+AD9)","v":3911},null,null,null,null,null,null,25,null,{"$f":"INT(Y14+AD9)","v":1739}]
[null,null,null,null,"た",{"$f":"$O$53","v":3300},"た",{"$f":"C18+F19","v":9295},null,null,null,null,null,40,{"$f":"INT(P14+AF10)","v":4235},null,null,null,null,null,null,null,40,{"$f":"INT(Y14+AD10)","v":4127}]
[null,"75mm",{"$f":"O21","v":11584},null,"相",{"$f":"$O$38","v":4375},"相",{"$f":"C20+F20","v":15959},null,null,null,null,null,50,{"$f":"INT(P14+AF11)","v":5995},null,null,null,null,null,null,null,50,{"$f":"INT(Y14+AD11)","v":7647}]
[null,null,null,null,"た",{"$f":"$O$53","v":3300},"た",{"$f":"C20+F21","v":14884},null,null,null,null,null,75,{"$f":"INT(P14+AF12)","v":11584},null,null,null,null,null,null,null,75,{"$f":"INT(Y14+AD12)","v":18825}]
[null,"100mm",{"$f":"O22","v":20934},null,"相",{"$f":"$O$38","v":4375},"相",{"$f":"C22+F22","v":25309},null,null,null,null,null,100,{"$f":"INT(P14+AF13)","v":20934},null,null,null,null,null,null,null,100,{"$f":"INT(Y14+AD13)","v":37525}]
[null,null,null,null,"た",{"$f":"$O$53","v":3300},"た",{"$f":"C22+F23","v":24234},"（相生下水）",null,null,null,null,300,{"$f":"INT(P14+AF14)","v":291623},null,null,null,null,null,null,null,300,{"$f":"INT(Y14+AD14)","v":578903}]
[null,"300mm",{"$f":"O23","v":291623},null,"相",{"$f":"$O$38","v":4375},"相",{"$f":"C24+F24","v":295998},null,"従量料金計算"]
[null,null,null,null,"た",{"$f":"$O$53","v":3300},"た",{"$f":"C24+F25","v":294923},null,"１ケ月目",null,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":"A4","v":25},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L26","v":0},"㎥",null,null,null,null,null,"基本料金","単価",1173]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,5,"6～10",42,{"$f":"K28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(L26>=10,I28,IF(L26>5,L26-5,0))","v":5},{"$f":"L28*O28","v":231},"円",null,"6～10",42,{"$f":"T28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(U26>=10,I28,IF(U26>5,U26-5,0))","v":0},{"$f":"U28*X28","v":0},"円",null,{"$f":"AD26*(1+$H$4/100)","v":1290.3000000000002},null,null,{"$f":"AB28*2","v":2580.6000000000004}]
[null,null,null,null,null,null,null,null,10,"11～20",159,{"$f":"K29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(L26>=20,I29,IF(L26>10,L26-10,0))","v":10},{"$f":"L29*O29","v":1749},"円",null,"11～20",159,{"$f":"T29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(U26>=20,I29,IF(U26>10,U26-10,0))","v":0},{"$f":"U29*X29","v":0},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(L26>=30,I30,IF(L26>20,L26-20,0))","v":5},{"$f":"L30*O30","v":1105.5},"円",null,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(U26>=30,I30,IF(U26>20,U26-20,0))","v":0},{"$f":"U30*X30","v":0},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(L26>=50,I31,IF(L26>30,L26-30,0))","v":0},0,"円",null,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(U26>=50,I31,IF(U26>30,U26-30,0))","v":0},{"$f":"U31*X31","v":0},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",245,269.5,"円","×",{"$f":"IF(L26>=100,I32,IF(L26>50,L26-50,0))","v":0},0,"円",null,"51～100",245,269.5,"円","×",{"$f":"IF(U26>=100,I32,IF(U26>50,U26-50,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(L26>=200,I33,IF(L26>100,L26-100,0))","v":0},0,"円",null,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(U26>=200,I33,IF(U26>100,U26-100,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,200,"201～",276,303.60000000000002,"円","×",{"$f":"IF(L26>=200,L26-200,0)","v":0},0,"円",null,"201～",276,303.60000000000002,"円","×",{"$f":"IF(U26>=200,U26-200,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P28:P34)","v":3085.5},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y28:Y34)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P35+AB28)","v":4375},null,null,null,null,null,null,null,null,{"$f":"INT(Y35+AB28)","v":1290}]
[]
[]
[null,null,null,null,null,null,null,null,"（たつの下水）",null,null,null,null,25,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,"従量料金計算"]
[null,null,null,null,null,null,null,null,null,"１ケ月目",null,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":"A4","v":25},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L44","v":0},"㎥",null,null,null,null,null,"基本料金","単価",900]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,10,"11～20",130,{"$f":"K46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(L44>=20,I46,IF(L44>10,L44-10,0))","v":10},{"$f":"L46*O46","v":1430},"円",null,"11～20",130,{"$f":"T46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(U44>=20,I46,IF(U44>10,U44-10,0))","v":0},{"$f":"U46*X46","v":0},"円",null,{"$f":"AD44*(1+$H$4/100)","v":990.00000000000011},null,null,{"$f":"AB46*2","v":1980.0000000000002}]
[null,null,null,null,null,null,null,null,20,"21～40",160,{"$f":"K47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(L44>=40,I47,IF(L44>20,L44-20,0))","v":5},{"$f":"L47*O47","v":880},"円",null,"21～40",160,{"$f":"T47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(U44>=40,I47,IF(U44>20,U44-20,0))","v":0},{"$f":"U47*X47","v":0},"円"]
[null,null,null,null,null,null,null,null,60,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(L44>=100,I48,IF(L44>40,L44-40,0))","v":0},{"$f":"L48*O48","v":0},"円",null,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(U44>=100,I48,IF(U44>40,U44-40,0))","v":0},{"$f":"U48*X48","v":0},"円"]
[null,null,null,null,null,null,null,null,null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(L44>=100,L44-100,0)","v":0},0,"円",null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(U44>=100,U44-100,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P46:P49)","v":2310},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y46:Y49)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P50+AB46)","v":3300},null,null,null,null,null,null,null,null,{"$f":"INT(Y50+AB46)","v":990}]

{"sheet":"1ヶ月料金計算（大口径）","index":5,"n_rows":53,"n_cols":33,"rows_kept":53,"cut":false,"hidden":true,"merged":[[2,0,2,1],[3,2,4,6],[3,17,14,17],[3,26,14,26],[5,2,10,6],[5,31,5,32],[7,7,10,7],[13,4,13,7],[14,2,14,3],[14,4,14,5],[14,6,14,7],[14,29,14,30],[14,31,14,32],[5,29,5,30],[15,1,16,1],[15,2,16,3],[16,26,20,26],[16,29,16,30],[16,31,16,32],[17,1,18,1],[17,2,18,3],[18,14,18,16],[18,23,18,25],[18,29,18,30],[18,31,18,32],[19,1,20,1],[19,2,20,3],[19,14,19,16],[19,23,19,25],[20,14,20,16],[20,23,20,25],[20,29,20,30],[20,31,20,32],[21,1,22,1],[21,2,22,3],[21,14,21,16],[21,23,21,25],[22,14,22,16],[22,23,22,25],[26,30,26,33],[27,27,29,29],[27,30,29,33],[35,29,35,30],[35,31,35,32],[23,1,24,1],[23,2,24,3],[24,17,35,17],[24,26,35,26],[26,27,26,29],[42,17,50,17],[42,26,50,26],[44,27,44,29],[44,30,44,33],[45,27,47,29],[45,30,47,33],[50,29,50,30],[50,31,50,32],[38,31,38,32],[39,14,39,16],[39,23,39,25],[40,14,40,16],[40,23,40,25],[36,26,38,26],[36,29,36,30],[36,31,36,32],[37,14,37,16],[37,23,37,25],[37,29,37,30],[37,31,37,32],[38,14,38,16],[38,23,38,25],[38,29,38,30],[51,31,51,32],[52,31,52,32],[53,14,53,16],[53,23,53,25],[53,29,53,30],[53,31,53,32],[54,14,54,16],[54,23,54,25],[52,14,52,16],[52,23,52,25],[52,29,52,30],[51,26,53,26],[51,29,51,30]]}
[]
[null,null,null,null,null,null,null,null,"（水道料金）"]
[null,null,null,null,null,null,null,"税率",null,"従量料金計算"]
[{"$f":"C6","v":0},null,"水量を入力してください。",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,null,null,null,null,null,null,{"$f":"A4","v":0},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L5","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,null,null,"口径","単価","1ケ月",null,"２ケ月"]
[null,null,null,null,null,null,null,null,10,"6～10",43,{"$f":"K7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(L5>=10,I7,IF(L5>0,L5-0,0))","v":0},{"$f":"L7*O7","v":0},"円",null,"6～10",43,{"$f":"T7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(U5>=10,I7,IF(U5>0,U5-0,0))","v":0},{"$f":"U7*X7","v":0},"円",null,"13mm",543,{"$f":"AC7*(1+$H$4/100)","v":597.30000000000007},"円",{"$f":"INT(AD7*2)","v":1194},"円"]
[null,null,null,null,null,null,null,"㎥",10,"11～20",90,{"$f":"K8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(L5>=20,I8,IF(L5>10,L5-10,0))","v":0},{"$f":"L8*O8","v":0},"円",null,"11～20",90,{"$f":"T8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(U5>=20,I8,IF(U5>10,U5-10,0))","v":0},{"$f":"U8*X8","v":0},"円",null,"20mm",714,{"$f":"AC8*(1+$H$4/100)","v":785.40000000000009},"円",{"$f":"INT(AD8*2)","v":1570},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",129,141.9,"円","×",{"$f":"IF(L5>=30,I9,IF(L5>20,L5-20,0))","v":0},0,"円",null,"21～30",129,141.9,"円","×",{"$f":"IF(U5>=30,I9,IF(U5>20,U5-20,0))","v":0},{"$f":"U9*X9","v":0},"円",null,"25mm",1581,1739.1000000000001,"円",{"$f":"INT(AD9*2)","v":3478},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(L5>=50,I10,IF(L5>30,L5-30,0))","v":0},0,"円",null,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(U5>=50,I10,IF(U5>30,U5-30,0))","v":0},{"$f":"U10*X10","v":0},"円",null,"40mm",3752,4127.2000000000007,"円",{"$f":"INT(AD10*2)","v":8254},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(L5>=100,I11,IF(L5>50,L5-50,0))","v":0},0,"円",null,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(U5>=100,I11,IF(U5>50,U5-50,0))","v":0},0,"円",null,"50mm",6952,7647.2000000000007,"円",15294,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",214,235.4,"円","×",{"$f":"IF(L5>=200,I12,IF(L5>100,L5-100,0))","v":0},0,"円",null,"101～200",214,235.4,"円","×",{"$f":"IF(U5>=200,I12,IF(U5>100,U5-100,0))","v":0},0,"円",null,"75mm",17114,18825.400000000001,"円",37650,"円"]
[null,null,null,null,null,null,null,null,null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(L5>=200,L5-200,0)","v":0},0,"円",null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(U5>=200,U5-200,0)","v":0},0,"円",null,"100mm",34114,37525.4,"円",75050,"円"]
[null,"1ケ月計算",null,null,"※水量以外のセルへの入力や消去はしないでください。",null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P7:P13)","v":0},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y7:Y13)","v":0},"円",null,"300mm",526276,578903.60000000009,"円",1157807,"円"]
[null,null,"水道料金",null,"下水道使用料",null,"合　  計"]
[null,"40mm",{"$f":"O19","v":4127},null,"相",{"$f":"$O$38","v":1290},"相",{"$f":"C16+F16","v":5417},null,null,null,null,null,13,null,{"$f":"INT(P14+AD7)","v":597},null,null,null,null,null,null,13,null,{"$f":"INT(Y14+AD7)","v":597}]
[null,null,null,null,"た",{"$f":"$O$53","v":990},"た",{"$f":"C16+F17","v":5117},null,null,null,null,null,20,null,{"$f":"INT(P14+AD8)","v":785},null,null,null,null,null,null,20,null,{"$f":"INT(Y14+AD8)","v":785}]
[null,"50mm",{"$f":"O20","v":7647},null,"相",{"$f":"$O$38","v":1290},"相",{"$f":"C18+F18","v":8937},null,null,null,null,null,25,null,{"$f":"INT(P14+AD9)","v":1739},null,null,null,null,null,null,25,null,{"$f":"INT(Y14+AD9)","v":1739}]
[null,null,null,null,"た",{"$f":"$O$53","v":990},"た",{"$f":"C18+F19","v":8637},null,null,null,null,null,40,{"$f":"INT(P14+AD10)","v":4127},null,null,null,null,null,null,null,40,{"$f":"INT(Y14+AD10)","v":4127}]
[null,"75mm",{"$f":"O21","v":18825},null,"相",{"$f":"$O$38","v":1290},"相",{"$f":"C20+F20","v":20115},null,null,null,null,null,50,{"$f":"INT(P14+AD11)","v":7647},null,null,null,null,null,null,null,50,{"$f":"INT(Y14+AD11)","v":7647}]
[null,null,null,null,"た",{"$f":"$O$53","v":990},"た",{"$f":"C20+F21","v":19815},null,null,null,null,null,75,{"$f":"INT(P14+AD12)","v":18825},null,null,null,null,null,null,null,75,{"$f":"INT(Y14+AD12)","v":18825}]
[null,"100mm",{"$f":"O22","v":37525},null,"相",{"$f":"$O$38","v":1290},"相",{"$f":"C22+F22","v":38815},null,null,null,null,null,100,{"$f":"INT(P14+AD13)","v":37525},null,null,null,null,null,null,null,100,{"$f":"INT(Y14+AD13)","v":37525}]
[null,null,null,null,"た",{"$f":"$O$53","v":990},"た",{"$f":"C22+F23","v":38515},"（相生下水）",null,null,null,null,300,{"$f":"INT(P14+AD14)","v":578903},null,null,null,null,null,null,null,300,{"$f":"INT(Y14+AD14)","v":578903}]
[null,"300mm",{"$f":"O23","v":578903},null,"相",{"$f":"$O$38","v":1290},"相",{"$f":"C24+F24","v":580193},null,"従量料金計算"]
[null,null,null,null,"た",{"$f":"$O$53","v":990},"た",{"$f":"C24+F25","v":579893},null,"１ケ月目",null,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":"A4","v":0},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L26","v":0},"㎥",null,null,null,null,null,"基本料金","単価",1173]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,5,"6～10",42,{"$f":"K28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(L26>=10,I28,IF(L26>5,L26-5,0))","v":0},{"$f":"L28*O28","v":0},"円",null,"6～10",42,{"$f":"T28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(U26>=10,I28,IF(U26>5,U26-5,0))","v":0},{"$f":"U28*X28","v":0},"円",null,{"$f":"AD26*(1+$H$4/100)","v":1290.3000000000002},null,null,{"$f":"AB28*2","v":2580.6000000000004}]
[null,null,null,null,null,null,null,null,10,"11～20",159,{"$f":"K29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(L26>=20,I29,IF(L26>10,L26-10,0))","v":0},{"$f":"L29*O29","v":0},"円",null,"11～20",159,{"$f":"T29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(U26>=20,I29,IF(U26>10,U26-10,0))","v":0},{"$f":"U29*X29","v":0},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(L26>=30,I30,IF(L26>20,L26-20,0))","v":0},{"$f":"L30*O30","v":0},"円",null,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(U26>=30,I30,IF(U26>20,U26-20,0))","v":0},{"$f":"U30*X30","v":0},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(L26>=50,I31,IF(L26>30,L26-30,0))","v":0},0,"円",null,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(U26>=50,I31,IF(U26>30,U26-30,0))","v":0},{"$f":"U31*X31","v":0},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",245,269.5,"円","×",{"$f":"IF(L26>=100,I32,IF(L26>50,L26-50,0))","v":0},0,"円",null,"51～100",245,269.5,"円","×",{"$f":"IF(U26>=100,I32,IF(U26>50,U26-50,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(L26>=200,I33,IF(L26>100,L26-100,0))","v":0},0,"円",null,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(U26>=200,I33,IF(U26>100,U26-100,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,200,"201～",276,303.60000000000002,"円","×",{"$f":"IF(L26>=200,L26-200,0)","v":0},0,"円",null,"201～",276,303.60000000000002,"円","×",{"$f":"IF(U26>=200,U26-200,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P28:P34)","v":0},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y28:Y34)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P35+AB28)","v":1290},null,null,null,null,null,null,null,null,{"$f":"INT(Y35+AB28)","v":1290}]
[]
[]
[null,null,null,null,null,null,null,null,"（たつの下水）",null,null,null,null,25,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,"従量料金計算"]
[null,null,null,null,null,null,null,null,null,"１ケ月目",null,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":"A4","v":0},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L44","v":0},"㎥",null,null,null,null,null,"基本料金","単価",900]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,10,"11～20",130,{"$f":"K46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(L44>=20,I46,IF(L44>10,L44-10,0))","v":0},{"$f":"L46*O46","v":0},"円",null,"11～20",130,{"$f":"T46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(U44>=20,I46,IF(U44>10,U44-10,0))","v":0},{"$f":"U46*X46","v":0},"円",null,{"$f":"AD44*(1+$H$4/100)","v":990.00000000000011},null,null,{"$f":"AB46*2","v":1980.0000000000002}]
[null,null,null,null,null,null,null,null,20,"21～40",160,{"$f":"K47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(L44>=40,I47,IF(L44>20,L44-20,0))","v":0},{"$f":"L47*O47","v":0},"円",null,"21～40",160,{"$f":"T47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(U44>=40,I47,IF(U44>20,U44-20,0))","v":0},{"$f":"U47*X47","v":0},"円"]
[null,null,null,null,null,null,null,null,60,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(L44>=100,I48,IF(L44>40,L44-40,0))","v":0},{"$f":"L48*O48","v":0},"円",null,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(U44>=100,I48,IF(U44>40,U44-40,0))","v":0},{"$f":"U48*X48","v":0},"円"]
[null,null,null,null,null,null,null,null,null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(L44>=100,L44-100,0)","v":0},0,"円",null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(U44>=100,U44-100,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P46:P49)","v":0},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y46:Y49)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P50+AB46)","v":990},null,null,null,null,null,null,null,null,{"$f":"INT(Y50+AB46)","v":990}]

{"sheet":"2ヶ月料金計算（大口径）","index":6,"n_rows":53,"n_cols":33,"rows_kept":53,"cut":false,"hidden":true,"merged":[[21,23,21,25],[19,14,19,16],[21,14,21,16],[54,14,54,16],[54,23,54,25],[52,14,52,16],[52,23,52,25],[53,14,53,16],[53,23,53,25],[42,17,50,17],[52,29,52,30],[51,26,53,26],[51,29,51,30],[51,31,51,32],[52,31,52,32],[53,29,53,30],[53,31,53,32],[38,31,38,32],[39,14,39,16],[39,23,39,25],[40,14,40,16],[40,23,40,25],[36,26,38,26],[36,29,36,30],[36,31,36,32],[37,14,37,16],[37,23,37,25],[37,29,37,30],[37,31,37,32],[38,14,38,16],[38,23,38,25],[38,29,38,30],[42,26,50,26],[44,27,44,29],[44,30,44,33],[45,27,47,29],[45,30,47,33],[50,29,50,30],[50,31,50,32],[26,30,26,33],[27,27,29,29],[27,30,29,33],[35,29,35,30],[35,31,35,32],[24,26,35,26],[18,31,18,32],[19,1,20,1],[19,2,20,3],[20,14,20,16],[20,23,20,25],[20,29,20,30],[20,31,20,32],[23,1,24,1],[23,2,24,3],[21,1,22,1],[21,2,22,3],[22,14,22,16],[22,23,22,25],[24,17,35,17],[26,27,26,29],[15,1,16,1],[15,2,16,3],[16,26,20,26],[16,29,16,30],[16,31,16,32],[17,1,18,1],[17,2,18,3],[18,14,18,16],[18,23,18,25],[18,29,18,30],[19,23,19,25],[5,31,5,32],[7,7,10,7],[13,4,13,7],[14,2,14,3],[14,4,14,5],[14,6,14,7],[14,29,14,30],[14,31,14,32],[5,29,5,30],[2,0,2,1],[3,2,4,6],[3,17,14,17],[3,26,14,26],[5,2,10,6]]}
[]
[null,null,null,null,null,null,null,null,"（水道料金）"]
[null,null,null,null,null,null,null,"税率",null,"従量料金計算"]
[{"$f":"C6","v":0},null,"水量を入力してください。",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,null,null,null,null,null,null,{"$f":"ROUNDDOWN(A4/2,0)","v":0},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L5","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,null,null,"口径","単価","1ケ月",null,"２ケ月"]
[null,null,null,null,null,null,null,null,10,"6～10",43,{"$f":"K7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(L5>=10,I7,IF(L5>0,L5-0,0))","v":0},{"$f":"L7*O7","v":0},"円",null,"6～10",43,{"$f":"T7*(1+$H$4/100)","v":47.300000000000004},"円","×",{"$f":"IF(U5>=10,I7,IF(U5>0,U5-0,0))","v":0},{"$f":"U7*X7","v":0},"円",null,"13mm",543,{"$f":"AC7*(1+$H$4/100)","v":597.30000000000007},"円",{"$f":"INT(AD7*2)","v":1194},"円"]
[null,null,null,null,null,null,null,"㎥",10,"11～20",90,{"$f":"K8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(L5>=20,I8,IF(L5>10,L5-10,0))","v":0},{"$f":"L8*O8","v":0},"円",null,"11～20",90,{"$f":"T8*(1+$H$4/100)","v":99.000000000000014},"円","×",{"$f":"IF(U5>=20,I8,IF(U5>10,U5-10,0))","v":0},{"$f":"U8*X8","v":0},"円",null,"20mm",714,{"$f":"AC8*(1+$H$4/100)","v":785.40000000000009},"円",{"$f":"INT(AD8*2)","v":1570},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",129,141.9,"円","×",{"$f":"IF(L5>=30,I9,IF(L5>20,L5-20,0))","v":0},0,"円",null,"21～30",129,141.9,"円","×",{"$f":"IF(U5>=30,I9,IF(U5>20,U5-20,0))","v":0},{"$f":"U9*X9","v":0},"円",null,"25mm",1581,1739.1000000000001,"円",{"$f":"INT(AD9*2)","v":3478},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(L5>=50,I10,IF(L5>30,L5-30,0))","v":0},0,"円",null,"31～50",157,172.70000000000002,"円","×",{"$f":"IF(U5>=50,I10,IF(U5>30,U5-30,0))","v":0},{"$f":"U10*X10","v":0},"円",null,"40mm",3752,4127.2000000000007,"円",{"$f":"INT(AD10*2)","v":8254},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(L5>=100,I11,IF(L5>50,L5-50,0))","v":0},0,"円",null,"51～100",186,204.60000000000002,"円","×",{"$f":"IF(U5>=100,I11,IF(U5>50,U5-50,0))","v":0},0,"円",null,"50mm",6952,7647.2000000000007,"円",15294,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",214,235.4,"円","×",{"$f":"IF(L5>=200,I12,IF(L5>100,L5-100,0))","v":0},0,"円",null,"101～200",214,235.4,"円","×",{"$f":"IF(U5>=200,I12,IF(U5>100,U5-100,0))","v":0},0,"円",null,"75mm",17114,18825.400000000001,"円",37650,"円"]
[null,null,null,null,null,null,null,null,null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(L5>=200,L5-200,0)","v":0},0,"円",null,"201～",224,246.40000000000003,"円","×",{"$f":"IF(U5>=200,U5-200,0)","v":0},0,"円",null,"100mm",34114,37525.4,"円",75050,"円"]
[null,"２ケ月計算",null,null,"※水量以外のセルへの入力や消去はしないでください。",null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P7:P13)","v":0},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y7:Y13)","v":0},"円",null,"300mm",526276,578903.60000000009,"円",1157807,"円"]
[null,null,"水道料金",null,"下水道使用料",null,"合　  計"]
[null,"40mm",{"$f":"O19+X19","v":8254},null,"相",{"$f":"$O$38+$X$38","v":2580},"相",{"$f":"C16+F16","v":10834},null,null,null,null,null,13,null,{"$f":"INT(P14+AD7)","v":597},null,null,null,null,null,null,13,null,{"$f":"INT(Y14+AD7)","v":597}]
[null,null,null,null,"た",{"$f":"$O$53+$X$53","v":1980},"た",{"$f":"C16+F17","v":10234},null,null,null,null,null,20,null,{"$f":"INT(P14+AD8)","v":785},null,null,null,null,null,null,20,null,{"$f":"INT(Y14+AD8)","v":785}]
[null,"50mm",{"$f":"O20+X20","v":15294},null,"相",{"$f":"$O$38+$X$38","v":2580},"相",{"$f":"C18+F18","v":17874},null,null,null,null,null,25,null,{"$f":"INT(P14+AD9)","v":1739},null,null,null,null,null,null,25,null,{"$f":"INT(Y14+AD9)","v":1739}]
[null,null,null,null,"た",{"$f":"$O$53+$X$53","v":1980},"た",{"$f":"C18+F19","v":17274},null,null,null,null,null,40,{"$f":"INT(P14+AD10)","v":4127},null,null,null,null,null,null,null,40,{"$f":"INT(Y14+AD10)","v":4127}]
[null,"75mm",{"$f":"O21+X21","v":37650},null,"相",{"$f":"$O$38+$X$38","v":2580},"相",{"$f":"C20+F20","v":40230},null,null,null,null,null,50,{"$f":"INT(P14+AD11)","v":7647},null,null,null,null,null,null,null,50,{"$f":"INT(Y14+AD11)","v":7647}]
[null,null,null,null,"た",{"$f":"$O$53+$X$53","v":1980},"た",{"$f":"C20+F21","v":39630},null,null,null,null,null,75,{"$f":"INT(P14+AD12)","v":18825},null,null,null,null,null,null,null,75,{"$f":"INT(Y14+AD12)","v":18825}]
[null,"100mm",{"$f":"O22+X22","v":75050},null,"相",{"$f":"$O$38+$X$38","v":2580},"相",{"$f":"C22+F22","v":77630},null,null,null,null,null,100,{"$f":"INT(P14+AD13)","v":37525},null,null,null,null,null,null,null,100,{"$f":"INT(Y14+AD13)","v":37525}]
[null,null,null,null,"た",{"$f":"$O$53+$X$53","v":1980},"た",{"$f":"C22+F23","v":77030},"（相生下水）",null,null,null,null,300,{"$f":"INT(P14+AD14)","v":578903},null,null,null,null,null,null,null,300,{"$f":"INT(Y14+AD14)","v":578903}]
[null,"300mm",{"$f":"O23+X23","v":1157806},null,"相",{"$f":"$O$38+$X$38","v":2580},"相",{"$f":"C24+F24","v":1160386},null,"従量料金計算"]
[null,null,null,null,"た",{"$f":"$O$53+$X$53","v":1980},"た",{"$f":"C24+F25","v":1159786},null,"１ケ月目",null,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":"ROUNDDOWN(A4/2,0)","v":0},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L26","v":0},"㎥",null,null,null,null,null,"基本料金","単価",1173]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,5,"6～10",42,{"$f":"K28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(L26>=10,I28,IF(L26>5,L26-5,0))","v":0},{"$f":"L28*O28","v":0},"円",null,"6～10",42,{"$f":"T28*(1+$H$4/100)","v":46.2},"円","×",{"$f":"IF(U26>=10,I28,IF(U26>5,U26-5,0))","v":0},{"$f":"U28*X28","v":0},"円",null,{"$f":"AD26*(1+$H$4/100)","v":1290.3000000000002},null,null,{"$f":"AB28*2","v":2580.6000000000004}]
[null,null,null,null,null,null,null,null,10,"11～20",159,{"$f":"K29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(L26>=20,I29,IF(L26>10,L26-10,0))","v":0},{"$f":"L29*O29","v":0},"円",null,"11～20",159,{"$f":"T29*(1+$H$4/100)","v":174.9},"円","×",{"$f":"IF(U26>=20,I29,IF(U26>10,U26-10,0))","v":0},{"$f":"U29*X29","v":0},"円"]
[null,null,null,null,null,null,null,null,10,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(L26>=30,I30,IF(L26>20,L26-20,0))","v":0},{"$f":"L30*O30","v":0},"円",null,"21～30",201,221.10000000000002,"円","×",{"$f":"IF(U26>=30,I30,IF(U26>20,U26-20,0))","v":0},{"$f":"U30*X30","v":0},"円"]
[null,null,null,null,null,null,null,null,20,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(L26>=50,I31,IF(L26>30,L26-30,0))","v":0},0,"円",null,"31～50",224,246.40000000000003,"円","×",{"$f":"IF(U26>=50,I31,IF(U26>30,U26-30,0))","v":0},{"$f":"U31*X31","v":0},"円"]
[null,null,null,null,null,null,null,null,50,"51～100",245,269.5,"円","×",{"$f":"IF(L26>=100,I32,IF(L26>50,L26-50,0))","v":0},0,"円",null,"51～100",245,269.5,"円","×",{"$f":"IF(U26>=100,I32,IF(U26>50,U26-50,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,100,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(L26>=200,I33,IF(L26>100,L26-100,0))","v":0},0,"円",null,"101～200",266,292.60000000000002,"円","×",{"$f":"IF(U26>=200,I33,IF(U26>100,U26-100,0))","v":0},0,"円"]
[null,null,null,null,null,null,null,null,200,"201～",276,303.60000000000002,"円","×",{"$f":"IF(L26>=200,L26-200,0)","v":0},0,"円",null,"201～",276,303.60000000000002,"円","×",{"$f":"IF(U26>=200,U26-200,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P28:P34)","v":0},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y28:Y34)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P35+AB28)","v":1290},null,null,null,null,null,null,null,null,{"$f":"INT(Y35+AB28)","v":1290}]
[]
[]
[null,null,null,null,null,null,null,null,"（たつの下水）",null,null,null,null,25,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,"従量料金計算"]
[null,null,null,null,null,null,null,null,null,"１ケ月目",null,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":"ROUNDDOWN(A4/2,0)","v":0},"㎥",null,null,null,null,null,null,null,{"$f":"A4-L44","v":0},"㎥",null,null,null,null,null,"基本料金","単価",900]
[null,null,null,null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,null,"単価","税込み単価",null,null,null,null,null,null,"1ケ月（円）",null,null,"2ケ月（円）"]
[null,null,null,null,null,null,null,null,10,"11～20",130,{"$f":"K46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(L44>=20,I46,IF(L44>10,L44-10,0))","v":0},{"$f":"L46*O46","v":0},"円",null,"11～20",130,{"$f":"T46*(1+$H$4/100)","v":143},"円","×",{"$f":"IF(U44>=20,I46,IF(U44>10,U44-10,0))","v":0},{"$f":"U46*X46","v":0},"円",null,{"$f":"AD44*(1+$H$4/100)","v":990.00000000000011},null,null,{"$f":"AB46*2","v":1980.0000000000002}]
[null,null,null,null,null,null,null,null,20,"21～40",160,{"$f":"K47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(L44>=40,I47,IF(L44>20,L44-20,0))","v":0},{"$f":"L47*O47","v":0},"円",null,"21～40",160,{"$f":"T47*(1+$H$4/100)","v":176},"円","×",{"$f":"IF(U44>=40,I47,IF(U44>20,U44-20,0))","v":0},{"$f":"U47*X47","v":0},"円"]
[null,null,null,null,null,null,null,null,60,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(L44>=100,I48,IF(L44>40,L44-40,0))","v":0},{"$f":"L48*O48","v":0},"円",null,"41～100",200,220.00000000000003,"円","×",{"$f":"IF(U44>=100,I48,IF(U44>40,U44-40,0))","v":0},{"$f":"U48*X48","v":0},"円"]
[null,null,null,null,null,null,null,null,null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(L44>=100,L44-100,0)","v":0},0,"円",null,"101～",220,242.00000000000003,"円","×",{"$f":"IF(U44>=100,U44-100,0)","v":0},0,"円"]
[null,null,null,null,null,null,null,null,null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(P46:P49)","v":0},"円",null,"(㎥)",null,null,null,null,"計",{"$f":"SUM(Y46:Y49)","v":0},"円"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INT(P50+AB46)","v":990},null,null,null,null,null,null,null,null,{"$f":"INT(Y50+AB46)","v":990}]