{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["連合専用条件入力画面","上下水道料金計算","料金表","水道連合専用との比較表","下水道説明資料"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":38,"n_cols":26,"rows_kept":38,"cut":false,"hidden":false,"merged":[[25,13,25,14],[26,13,26,14],[27,13,27,14],[5,13,5,16],[7,13,7,14],[11,13,11,14],[14,13,14,14],[20,13,20,14],[21,13,21,14],[13,2,13,6],[9,2,9,6],[22,13,22,14],[20,1,20,3],[22,1,22,3],[24,1,24,3],[26,1,26,3],[1,5,2,13],[3,12,3,17],[17,2,17,4],[18,2,18,4],[4,13,4,16],[9,14,9,15],[13,14,13,15],[19,13,19,16],[3,2,3,7],[14,2,14,4],[15,2,15,4],[5,2,5,6],[7,2,7,6],[11,2,11,6]]}
[]
[null,null,null,null,null,"連合専用条件入力画面"]
[]
[null,null,"①～⑤の□に入力してください。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H17=1,\"消費税込みの料金\",IF(H17=2,\"消費税抜きの料金\",\"\"))","v":"消費税込みの料金"}]
[null,null,"①現在の水道料金算定の メーター口径は？",null,null,null,null,40,"㎜",null,null,null,null,"シュミレーションの結果"]
[]
[null,null,"②各部屋についている子メーター　 又は引込管の口径は？",null,null,null,null,20,"㎜",null,null,null,null,"現在の水道料金",null,null,{"$f":"IF(H17=1,ROUNDDOWN(Q23*1.1,0),IF(H17=2,Q23,\"\"))","v":88396}]
[]
[null,null,"③各部屋の世帯数は？",null,null,null,null,10,"部屋"]
[]
[null,null,"④前月の水道使用量は？",null,null,null,null,300,"㎥",null,null,null,null,"連合専用水道料金",null,null,{"$f":"IF(H17=1,ROUNDDOWN(Q28*1.1,0),IF(H17=2,Q28,\"\"))","v":67760}]
[]
[null,null,"⑤下水道は入っていますか？",null,null,null,null,1]
[null,null,"はいの場合・・・・・・1",null,null,null,null,null,null,null,null,null,null,"差　　　額",null,null,{"$f":"Q8-Q12","v":20636}]
[null,null,"いいえの場合・・・・・・2"]
[null,null,"⑥消費税込み料金を表示しますか？",null,null,null,null,1]
[null,null,"はいの場合・・・・・・1"]
[null,null,"いいえの場合・・・・・・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,{"$f":"上下水道料金計算!F61","v":59420}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"下水道料金",null,null,{"$f":"IF(H14=1,上下水道料金計算!F130,\"\")","v":20940}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"合　　　　計",null,null,{"$f":"SUM(Q21:Q22)","v":80360}]
[]
[null,null,null,null,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":"上下水道料金計算!F38","v":41200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"下水道料金",null,null,{"$f":"IF(H14=1,上下水道料金計算!F108,\"\")","v":20400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"合　　　　計",null,null,{"$f":"SUM(Q26:Q27)","v":61600}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"水道口径",null,"部屋の口径",null,"下水道の有無"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,13,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,20,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"75～100",null,"75～100"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,null,150]

{"sheet":"上下水道料金計算","index":1,"n_rows":130,"n_cols":18,"rows_kept":130,"cut":false,"hidden":false,"merged":[[77,9,77,11],[80,9,80,11],[83,9,83,11],[86,9,86,11],[71,5,71,6],[46,1,46,6],[24,0,25,0],[21,9,21,10],[39,0,39,6],[69,1,69,7],[0,1,0,7],[116,2,116,6],[118,3,118,4],[2,5,2,6],[9,9,9,11],[48,5,48,6],[93,2,93,6],[95,3,95,4],[62,0,62,6],[58,0,59,0],[60,3,60,4],[12,9,12,11],[15,9,15,11],[18,9,18,11],[35,0,36,0],[37,3,37,4]]}
[null,"上水道連合計算表"]
[]
[null,"口径",{"$f":"連合専用条件入力画面!$H$8","v":20},"世帯数",{"$f":"連合専用条件入力画面!$H$10","v":10},"前月使用水量",null,{"$f":"連合専用条件入力画面!$H$12","v":300}]
[]
[null,null,null,null,null,"基本水量"]
["連合の場合の基本水量",8,"×",{"$f":"$E$3","v":10},"＝",{"$f":"B6*D6","v":80}]
[null,"口径別"]
["基本料金",{"$f":"SUMIF(P29:R37,C3,R29:R37)","v":1370},"×",{"$f":"$E$3","v":10},"＝",{"$f":"B8*D8","v":13700}]
[]
["8㎥を超え30㎥まで","単価",{"$f":"IF($C$3>=30,料金表!G13,IF($C$3<=25,料金表!G13,\"\"))","v":125},null,null,null,null,null,null,{"$f":"CONCATENATE(B6*E3,\"㎥を超え\",C11*E3,\"㎥まで\")","v":"80㎥を超え300㎥まで"}]
[null,"水量",30,"×",{"$f":"$E$3","v":10},"＝",{"$f":"C11*E11","v":300},null,null,"MAX",{"$f":"G11-F6","v":220},{"$f":"K11*C10","v":27500}]
[]
["30㎥を超え50㎥まで","単価",{"$f":"IF($C$3>=30,料金表!H13,IF($C$3<=25,料金表!H13,\"\"))","v":145},null,null,null,null,null,null,{"$f":"CONCATENATE(TEXT(C11*$E$3,\"#,##0\"),\"㎥を超え\",TEXT(C14*$E$3,\"#,##0\"),\"㎥まで\")","v":"300㎥を超え500㎥まで"}]
[null,"水量",50,"×",{"$f":"$E$3","v":10},"＝",{"$f":"C14*E14","v":500},null,null,"MAX",{"$f":"G14-G11","v":200},{"$f":"K14*C13","v":29000}]
[]
["50㎥を超え100㎥まで","単価",{"$f":"IF($C$3>=30,料金表!I13,IF($C$3<=25,料金表!I13,\"\"))","v":170},null,null,null,null,null,null,{"$f":"CONCATENATE(TEXT(C14*$E$3,\"#,##0\"),\"㎥を超え\",TEXT(C17*$E$3,\"#,##0\"),\"㎥まで\")","v":"500㎥を超え1,000㎥まで"}]
[null,"水量",100,"×",{"$f":"$E$3","v":10},"＝",{"$f":"C17*E17","v":1000},null,null,"MAX",{"$f":"G17-G14","v":500},{"$f":"K17*C16","v":85000}]
[]
["100㎥を超え400㎥まで","単価",{"$f":"IF($C$3>=30,料金表!J13,IF($C$3<=25,料金表!J13,\"\"))","v":200},null,null,null,null,null,null,{"$f":"CONCATENATE(TEXT(C17*$E$3,\"#,##0\"),\"㎥を超え\",TEXT(C20*$E$3,\"#,##0\"),\"㎥まで\")","v":"1,000㎥を超え4,000㎥まで"}]
[null,"水量",400,"×",{"$f":"$E$3","v":10},"＝",{"$f":"C20*E20","v":4000},null,null,"MAX",{"$f":"G20-G17","v":3000},{"$f":"K20*C19","v":600000}]
[]
["400㎥を超えるもの","単価",{"$f":"IF($C$3>=30,料金表!K13,IF($C$3<=25,料金表!K13,\"\"))","v":240}]
[null,"水量",400]
[]
["0㎥を超え8㎥まで\n口径30㎜以上に適用","単価",{"$f":"IF($C$3>=30,料金表!F30,IF($C$3<=25,\"\",\"\"))","v":""}]
[null,"水量",8,"×",{"$f":"$E$3","v":10},"＝",{"$f":"C26*E26","v":80}]
[]
[null,"水量",null,"単価",null,"使用料金",null,null,null,null,null,null,null,null,null,"口径別","単位","基本料金"]
[{"$f":"CONCATENATE(0,\"㎥を超え\",8*$E$3,\"㎥まで基本料金\")","v":"0㎥を超え80㎥まで基本料金"},{"$f":"E3*8","v":80},"×",{"$f":"SUMIF(P29:R37,C3,R29:R37)","v":1370},"＝",{"$f":"IF(B29=\"\",\"\",$E$3*D29)","v":13700},"基本料金",null,null,null,null,null,null,null,null,13,"㎜",{"$f":"料金表!D6","v":840}]
[null,"超過水量",null,"単価"]
[{"$f":"CONCATENATE(TEXT(8*$E$3,\"#,##0\"),\"㎥を超え\",TEXT(30*$E$3,\"#,##0\"),\"㎥まで\")","v":"80㎥を超え300㎥まで"},{"$f":"IF($H$3>=G11,K11,IF(F6<$H$3,$H$3-F6,\"\"))","v":220},{"$f":"IF(B31=\"\",\"\",\"×\")","v":"×"},{"$f":"IF(B31=\"\",\"\",料金表!$G$13)","v":125},{"$f":"IF(B31=\"\",\"\",\"＝\")","v":"＝"},{"$f":"IF(B31=\"\",\"\",B31*D31)","v":27500},null,null,null,null,null,null,null,null,null,20,"㎜",{"$f":"料金表!D7","v":1370}]
[{"$f":"CONCATENATE(TEXT(30*$E$3,\"#,##0\"),\"㎥を超え\",TEXT(50*$E$3,\"#,##0\"),\"㎥まで\")","v":"300㎥を超え500㎥まで"},{"$f":"IF($H$3>=G14,K14,IF(H3<=G11,\"\",H3-G11))","v":""},{"$f":"IF(B32=\"\",\"\",\"×\")","v":""},{"$f":"IF(B32=\"\",\"\",料金表!$H$13)","v":""},{"$f":"IF(B32=\"\",\"\",\"＝\")","v":""},{"$f":"IF(B32=\"\",\"\",B32*D32)","v":""},null,null,null,null,null,null,null,null,null,25,"㎜",{"$f":"料金表!D8","v":1890}]
[{"$f":"CONCATENATE(TEXT(50*$E$3,\"#,##0\"),\"㎥を超え\",TEXT(100*$E$3,\"#,##0\"),\"㎥まで\")","v":"500㎥を超え1,000㎥まで"},{"$f":"IF($H$3>=G17,K17,IF(H3<=G14,\"\",H3-G14))","v":""},"",{"$f":"IF(B33=\"\",\"\",料金表!$I$13)","v":""},"","",null,null,null,null,null,null,null,null,null,30,"㎜",{"$f":"料金表!D9","v":2180}]
[{"$f":"CONCATENATE(TEXT(100*$E$3,\"#,##0\"),\"㎥を超え\",TEXT(400*$E$3,\"#,##0\"),\"㎥まで\")","v":"1,000㎥を超え4,000㎥まで"},{"$f":"IF($H$3>=G20,K20,IF(H3<=G17,\"\",H3-G17))","v":""},"",{"$f":"IF(B34=\"\",\"\",料金表!$J$13)","v":""},"","",null,null,null,null,null,null,null,null,null,40,"㎜",{"$f":"料金表!D10","v":4390}]
[{"$f":"CONCATENATE(TEXT(400*$E$3,\"#,##0\"),\"㎥を超えるもの\")","v":"4,000㎥を超えるもの"},{"$f":"IF(H3>G20,H3-G20,\"\")","v":""},"",{"$f":"IF(B35=\"\",\"\",料金表!$K$13)","v":""},"","",null,null,null,null,null,null,null,null,null,50,"㎜",{"$f":"料金表!D11","v":7270}]
[{"$f":"CONCATENATE(\"0㎥を超え\",F6,\"㎥まで　　　　　　　　　\",\"口径30㎜以上に適用\")","v":"0㎥を超え80㎥まで　　　　　　　　　口径30㎜以上に適用"},{"$f":"IF($C$3<=25,\"\",IF($H$3<=F6,$H$3,8*E3))","v":""},{"$f":"IF(B36=\"\",\"\",\"×\")","v":""},{"$f":"IF(B36=\"\",\"\",110)","v":""},"","",null,null,null,null,null,null,null,null,null,"75～100","㎜",{"$f":"料金表!D12","v":16500}]
[null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,150,"㎜",{"$f":"料金表!D13","v":63750}]
["合計使用水量",{"$f":"F6+SUM(B31:B35)","v":300},null,"使用料金合計＝",null,{"$f":"SUM(F29:F37)","v":41200}]
[]
["※0㎥を越え８㎥までの水量表示がある場合は合計使用水量の中に含まれています。"]
[]
[]
[]
[]
[]
[]
[null,"通常の水道料金計算表"]
[]
[null,"口径",{"$f":"連合専用条件入力画面!$H$6","v":40},"世帯数",{"$f":"連合専用条件入力画面!$H$10","v":10},"前月使用水量",null,{"$f":"連合専用条件入力画面!$H$12","v":300}]
[]
[null,"水量",null,"単価",null,"使用料金"]
[{"$f":"CONCATENATE(0,\"㎥を超え\",8,\"㎥まで基本料金\")","v":"0㎥を超え8㎥まで基本料金"},{"$f":"8","v":8},"×",{"$f":"SUMIF(P29:R37,C49,R29:R37)","v":4390},"＝",{"$f":"IF(B52=\"\",\"\",D52*1)","v":4390},"基本料金"]
[null,"超過水量",null,"単価"]
[{"$f":"CONCATENATE(8,\"㎥を超え\",30,\"㎥まで\")","v":"8㎥を超え30㎥まで"},{"$f":"IF($H$49>=30,22,IF(8<$H$49,$H$49-8,\"\"))","v":22},{"$f":"IF(B54=\"\",\"\",\"×\")","v":"×"},{"$f":"IF(B54=\"\",\"\",料金表!$G$13)","v":125},{"$f":"IF(B54=\"\",\"\",\"＝\")","v":"＝"},{"$f":"IF(B54=\"\",\"\",B54*D54)","v":2750}]
[{"$f":"CONCATENATE(30,\"㎥を超え\",50,\"㎥まで\")","v":"30㎥を超え50㎥まで"},{"$f":"IF($H$49>=50,20,IF(30<$H$49,H49-30,\"\"))","v":20},"×",{"$f":"IF(B55=\"\",\"\",料金表!$H$13)","v":145},"＝",{"$f":"IF(B55=\"\",\"\",B55*D55)","v":2900}]
[{"$f":"CONCATENATE(50,\"㎥を超え\",100,\"㎥まで\")","v":"50㎥を超え100㎥まで"},{"$f":"IF($H$49>=100,50,IF(50<$H$49,H49-50,\"\"))","v":50},"×",{"$f":"IF(B56=\"\",\"\",料金表!$I$13)","v":170},"＝",8500]
[{"$f":"CONCATENATE(100,\"㎥を超え\",400,\"㎥まで\")","v":"100㎥を超え400㎥まで"},{"$f":"IF($H$49>=400,300,IF(100<$H$49,H49-100,\"\"))","v":200},"×",{"$f":"IF(B57=\"\",\"\",料金表!$J$13)","v":200},"＝",40000]
[{"$f":"CONCATENATE(400,\"㎥を超えるもの\")","v":"400㎥を超えるもの"},{"$f":"IF($H$49>=400,H49-400,IF(400<$H$49,H49-400,\"\"))","v":""},"",{"$f":"IF(B58=\"\",\"\",料金表!$K$13)","v":""},"",""]
["0㎥を超え8㎥まで\n口径30㎜以上に適用",{"$f":"IF(C49<=25,\"\",IF($H$3<=8,$H$3,8))","v":8},{"$f":"IF(B59=\"\",\"\",\"×\")","v":"×"},{"$f":"IF(B59=\"\",\"\",110)","v":110},{"$f":"IF(B59=\"\",\"\",\"＝\")","v":"＝"},880]
[]
["合計使用水量",{"$f":"B6+SUM(B54:B58)","v":300},null,"使用料金合計＝",null,{"$f":"SUM(F52:F60)","v":59420}]
[]
["※0㎥を越え８㎥までの水量表示がある場合は合計使用水量の中に含まれています。"]
[]
[]
[]
[]
[]
[]
[null,"下水道連合計算表"]
[]
[null,"口径",{"$f":"連合専用条件入力画面!$H$8","v":20},"世帯数",{"$f":"連合専用条件入力画面!$H$10","v":10},"前月使用水量",null,{"$f":"連合専用条件入力画面!$H$12","v":300}]
[]
["連合の場合の基本水量",{"$f":"料金表!O6","v":8},"×",{"$f":"$E$3","v":10},"＝",{"$f":"B74*D74","v":80}]
[null,"口径別"]
["基本料金",500,"×",{"$f":"$E$3","v":10},"＝",{"$f":"B76*D76","v":5000}]
[]
[{"$f":"CONCATENATE($F$74,\"㎥を超え\",上下水道料金計算!$G$79,\"㎥まで\")","v":"80㎥を超え300㎥まで"},"単価",{"$f":"料金表!S7","v":70},null,null,null,null,null,null,"50㎥を超え150㎥まで"]
[null,"水量",{"$f":"料金表!Q7","v":30},"×",{"$f":"$E$3","v":10},"＝",{"$f":"C79*E79","v":300},null,null,"MAX",{"$f":"G79-F74","v":220},{"$f":"K79*C78","v":15400}]
[]
[{"$f":"CONCATENATE($G$79,\"㎥を超え\",$G$82,\"㎥まで\")","v":"300㎥を超え500㎥まで"},"単価",{"$f":"料金表!S8","v":70},null,null,null,null,null,null,"150㎥を超え250㎥まで"]
[null,"水量",{"$f":"料金表!Q8","v":50},"×",{"$f":"$E$3","v":10},"＝",{"$f":"C82*E82","v":500},null,null,"MAX",{"$f":"G82-G79","v":200},{"$f":"K82*C81","v":14000}]
[]
[{"$f":"CONCATENATE($G$82,\"㎥を超え\",$G$85,\"㎥まで\")","v":"500㎥を超え1000㎥まで"},"単価",{"$f":"料金表!S9","v":70},null,null,null,null,null,null,"250㎥を超え500㎥まで"]
[null,"水量",{"$f":"料金表!Q9","v":100},"×",{"$f":"$E$3","v":10},"＝",{"$f":"C85*E85","v":1000},null,null,"MAX",{"$f":"G85-G82","v":500},{"$f":"K85*C84","v":35000}]
[]
[{"$f":"CONCATENATE($G$82,\"㎥を超え\",$G$88,\"㎥まで\")","v":"500㎥を超え4000㎥まで"},"単価",{"$f":"料金表!S10","v":70},null,null,null,null,null,null,"250㎥を超え2000㎥まで"]
[null,"水量",{"$f":"料金表!Q10","v":400},"×",{"$f":"$E$3","v":10},"＝",{"$f":"C88*E88","v":4000},null,null,"MAX",{"$f":"G88-G85","v":3000},{"$f":"K88*C87","v":210000}]
[{"$f":"CONCATENATE(料金表!$O$11,\"㎥を超えるもの\")","v":"400㎥を超えるもの"},"単価",{"$f":"料金表!S11","v":70}]
[null,"水量",{"$f":"料金表!O11*D74","v":4000}]
[]
[]
[]
[null,null,"下水道連合専用料金計算書"]
[]
[null,"世帯数",{"$f":"E49","v":10},"前月使用水量",null,{"$f":"H49","v":300}]
[null,null,null,null,null,"基本水量"]
["連合の場合の基本使用水量",{"$f":"料金表!O6","v":8},"×",{"$f":"C96","v":10},"＝",{"$f":"B98*D98","v":80}]
[]
[null,"水量",null,"単価",null,"使用料金","備　　考"]
[{"$f":"CONCATENATE(\"0㎥を越え\",F98,\"㎥まで基本水量\")","v":"0㎥を越え80㎥まで基本水量"},null,null,500,"＝",{"$f":"D98*D101","v":5000}]
[null,"超過水量",null,"単価"]
[{"$f":"CONCATENATE(F74,\"㎥を超え\",G79,\"㎥まで\")","v":"80㎥を超え300㎥まで"},{"$f":"IF($H$72>=G79,K79,IF(F74<H72,$H$72-F74,\"\"))","v":220},{"$f":"IF(B103=\"\",\"\",\"×\")","v":"×"},{"$f":"IF(B103=\"\",\"\",料金表!S7)","v":70},{"$f":"IF(B103=\"\",\"\",\"＝\")","v":"＝"},{"$f":"IF(B103=\"\",\"\",B103*D103)","v":15400}]
[{"$f":"CONCATENATE(G79,\"㎥を超え\",G82,\"㎥まで\")","v":"300㎥を超え500㎥まで"},{"$f":"IF($H$72>=G82,K82,IF($H$72<G79,\"\",$H$72-G79))","v":0},"×",{"$f":"IF(B104=\"\",\"\",料金表!S8)","v":70},"＝",{"$f":"IF(B104=\"\",\"\",B104*D104)","v":0}]
[{"$f":"CONCATENATE(G82,\"㎥を超え\",G85,\"㎥まで\")","v":"500㎥を超え1000㎥まで"},{"$f":"IF($H$72>=G85,K85,IF($H$72<=G82,\"\",$H$72-G82))","v":""},"",{"$f":"IF(B105=\"\",\"\",料金表!S9)","v":""},"",""]
[{"$f":"CONCATENATE(G85,\"㎥を超え\",G88,\"㎥まで\")","v":"1000㎥を超え4000㎥まで"},{"$f":"IF($H$72>=G88,K88,IF($H$72<G85,\"\",$H$72-G85))","v":""},"",{"$f":"IF(B106=\"\",\"\",料金表!S10)","v":""},"",""]
[{"$f":"CONCATENATE(G88,\"㎥を超えるもの\")","v":"4000㎥を超えるもの"},{"$f":"IF($H$72>=G88,$H$72-G88,\"\")","v":""},"",{"$f":"IF(B107=\"\",\"\",料金表!S11)","v":""},{"$f":"IF(B107=\"\",\"\",\"＝\")","v":""},{"$f":"IF(B107=\"\",\"\",B107*D107)","v":""}]
["水量",{"$f":"SUM(B103:B107)+F98","v":300},null,null,"合計",{"$f":"SUM(F103:F107)+F101","v":20400}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"下水道通常の料金計算書"]
[]
[null,"世帯数",{"$f":"連合専用条件入力画面!H10","v":10},"前月使用水量",null,{"$f":"連合専用条件入力画面!H12","v":300}]
[]
[null,"水量",null,"単価",null,"使用料金","備　　考"]
[{"$f":"CONCATENATE(\"0㎥を越え\",B74,\"㎥まで基本水量\")","v":"0㎥を越え8㎥まで基本水量"},8,null,500,"＝",{"$f":"D122","v":500}]
[null,"超過水量",null,"単価"]
[{"$f":"CONCATENATE(TEXT(料金表!O7,\"#,##0\"),\"㎥を超え\",TEXT(料金表!Q7,\"#,##0\"),\"㎥まで\")","v":"8㎥を超え30㎥まで"},{"$f":"IF($F$119>=料金表!Q7,料金表!Q7-料金表!O7,IF($F$119<=料金表!O6,\"\",$F$119-料金表!O6))","v":22},{"$f":"IF(B124=\"\",\"\",\"×\")","v":"×"},{"$f":"IF(B124=\"\",\"\",料金表!S7)","v":70},{"$f":"IF(B124=\"\",\"\",\"=\")","v":"="},{"$f":"IF(B124=\"\",\"\",B124*D124)","v":1540}]
[{"$f":"CONCATENATE(TEXT(料金表!O8,\"#,##0\"),\"㎥を超え\",TEXT(料金表!Q8,\"#,##0\"),\"㎥まで\")","v":"30㎥を超え50㎥まで"},{"$f":"IF($F$119>=料金表!Q8,料金表!Q8-料金表!O8,IF($F$119<=料金表!O8,\"\",$F$119-料金表!O8))","v":20},{"$f":"IF(B125=\"\",\"\",\"×\")","v":"×"},{"$f":"IF(B125=\"\",\"\",料金表!S8)","v":70},{"$f":"IF(B125=\"\",\"\",\"=\")","v":"="},{"$f":"IF(B125=\"\",\"\",B125*D125)","v":1400}]
[{"$f":"CONCATENATE(TEXT(料金表!O9,\"#,##0\"),\"㎥を超え\",TEXT(料金表!Q9,\"#,##0\"),\"㎥まで\")","v":"50㎥を超え100㎥まで"},{"$f":"IF($F$119>=料金表!Q9,料金表!Q9-料金表!O9,IF($F$119<=料金表!O9,\"\",$F$119-料金表!O9))","v":50},"×",{"$f":"IF(B126=\"\",\"\",料金表!S9)","v":70},"=",3500]
[{"$f":"CONCATENATE(TEXT(料金表!O10,\"#,##0\"),\"㎥を超え\",TEXT(料金表!Q10,\"#,##0\"),\"㎥まで\")","v":"100㎥を超え400㎥まで"},{"$f":"IF($F$119>=料金表!Q10,料金表!Q10-料金表!O10,IF($F$119<=料金表!O10,\"\",$F$119-料金表!O10))","v":200},"×",{"$f":"IF(B127=\"\",\"\",料金表!S10)","v":70},"=",14000]
[{"$f":"CONCATENATE(TEXT(料金表!O11,\"#,##0\"),\"㎥を超えるもの\")","v":"400㎥を超えるもの"},{"$f":"IF($H$72>=料金表!O11,上下水道料金計算!F119-料金表!O11,\"\")","v":""},{"$f":"IF(B128=\"\",\"\",\"×\")","v":""},{"$f":"IF(B128=\"\",\"\",料金表!S11)","v":""},{"$f":"IF(B128=\"\",\"\",\"=\")","v":""},{"$f":"IF(B128=\"\",\"\",B128*D128)","v":""}]
[]
["水量",{"$f":"SUM(B124:B129)+10","v":302},null,null,"合計",{"$f":"SUM(F122:F129)","v":20940}]

{"sheet":"料金表","index":2,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":false,"merged":[[5,8,10,8],[5,9,10,9],[5,10,10,10],[2,13,2,17],[15,1,15,10],[2,2,2,6],[12,3,12,4],[13,2,13,4],[14,2,14,4],[5,5,10,5],[13,5,13,10],[14,5,14,10],[4,3,4,4],[5,4,7,4],[4,5,4,10],[10,3,10,4],[11,14,11,17],[6,12,10,12],[6,13,10,13],[10,14,10,17],[4,14,4,17],[5,14,5,17],[6,16,6,17],[7,16,7,17],[8,16,8,17],[9,16,9,17],[11,12,11,13],[5,0,13,0],[5,1,12,1],[8,3,8,4],[9,3,9,4],[17,0,17,7],[5,6,10,6],[5,7,10,7],[11,3,11,4]]}
[]
[]
[null,null,"上水道料金表",null,null,null,null,null,null,null,null,null,null,"下水道料金表"]
[]
["種別","用途別","メーター\n口径","基本料金\n(１ヶ月につき)",null,"超過料金",null,null,null,null,null,null,"用途別","メーター\n口径","水量",null,null,null,"料金"]
["専用\n給水\n装置","一般用",13,840,"使用\n水量\n8㎥まで","使用水量0㎥を超え8㎥まで口径30㎜以上に適用","使用水量8㎥を超え30㎥まで","使用水量30㎥を超え50㎥まで","使用水量50㎥を超え100㎥まで","使用水量100㎥を超え400㎥まで","使用水量400㎥を超を超えるもの",null,"一般用","基本料金",8,null,null,null,500]
[null,null,20,1370,null,null,null,null,null,null,null,null,null,null,{"$f":"O6","v":8},"を超え",30,null,70]
[null,null,25,1890,null,null,null,null,null,null,null,null,null,null,{"$f":"Q7","v":30},"を超え",50,null,70]
[null,null,30,2180,null,null,null,null,null,null,null,null,null,null,{"$f":"Q8","v":50},"を超え",100,null,70]
[null,null,40,4390,null,null,null,null,null,null,null,null,null,null,{"$f":"Q9","v":100},"を超え",400,null,70]
[null,null,50,7270,null,null,null,null,null,null,null,null,null,null,400,null,null,null,70]
[null,null,"75㎜～\n１00㎜含む",16500,null,"1㎥\nにつき"]
[null,null,150,63750,null,110,125,145,170,200,240]
[null,"臨時用","1㎥につき450　円",null,null,null,null,null,null,null,null,null,"※連合の新規の申請の場合は、工務係"]
["私設消\n火栓","演習用","1個1回3分毎に800円"]
["連合専用\n給水装置","1戸(世帯)につき基本料金は、設置メーター又は引込み管口径による。この場合の料金算定の基礎となる使用量は、各戸均等に使用したものとする。"]
[]
["上記金額は、税抜きです・消費税をかけ、端数については、切捨てる。"]

{"sheet":"水道連合専用との比較表","index":3,"n_rows":40,"n_cols":19,"rows_kept":40,"cut":false,"hidden":false,"merged":[[24,1,24,4],[25,1,25,4],[28,1,28,4],[39,1,39,5],[27,1,27,5],[26,1,26,4],[1,2,1,7],[1,12,1,17],[10,12,10,16],[37,11,37,13],[13,1,13,3],[15,1,15,8],[3,1,3,5],[5,1,5,4],[7,1,7,4],[9,1,9,7],[13,4,13,5],[17,1,18,2],[23,1,23,4],[20,11,20,14],[22,11,22,14],[23,11,23,14],[30,11,30,14],[13,11,13,14],[14,11,14,14],[16,11,16,14],[17,11,17,14],[19,11,19,14],[26,11,26,14]]}
[]
[null,null,"連合の計算について(上水道)",null,null,null,null,null,null,null,null,null,"通常の計算について(上水道)"]
[]
[null,{"$f":"CONCATENATE(\"口径\",連合専用条件入力画面!H8,\"㎜　\",連合専用条件入力画面!H10,\"世帯　使用水量　\",連合専用条件入力画面!H12,\"㎥の場合\")","v":"口径20㎜　10世帯　使用水量　300㎥の場合"},null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"口径　\",上下水道料金計算!C49,\"㎜　\",上下水道料金計算!E3,\"世帯　使用水量　\",上下水道料金計算!H3,\"㎥の場合\")","v":"口径　40㎜　10世帯　使用水量　300㎥の場合"}]
[]
[null,{"$f":"CONCATENATE(\"連合\",上下水道料金計算!C3,\"㎜の\",連合専用条件入力画面!H10,\"世帯の基本料金・水量\")","v":"連合20㎜の10世帯の基本料金・水量"},null,null,null,null,null,null,null,null,null,"基本料金・水量は"]
[]
[null,{"$f":"CONCATENATE(\"上下水道使用量計算　　\",8,\"㎥×\",連合専用条件入力画面!H10,\"世帯＝\",8*連合専用条件入力画面!H10,\"㎥\")","v":"上下水道使用量計算　　8㎥×10世帯＝80㎥"},null,null,null,null,null,null,null,null,null,"○基本水量は、8㎥まで",null,null,null,null,null,"金　　額","水　　量"]
[]
[null,{"$f":"CONCATENATE(\"上下水道使用料金計算　　\",TEXT(上下水道料金計算!B8,\"#,##0\"),\"円(税抜き)　×　\",連合専用条件入力画面!H10,\"世帯＝\",TEXT(上下水道料金計算!F8,\"#,##0\"),\"(税抜き)\")","v":"上下水道使用料金計算　　1,370円(税抜き)　×　10世帯＝13,700(税抜き)"},null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"○基本料金は、\",TEXT(上下水道料金計算!D52,\"#,##0\"),\"円(税抜き)\")","v":"○基本料金は、4,390円(税抜き)"},null,null,null,null,null,{"$f":"上下水道料金計算!D52","v":4390},8]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"※0㎥～8㎥までは、同額　\",TEXT(R10,\"#,##0\"),\"円(税抜き)\")","v":"※0㎥～8㎥までは、同額　4,390円(税抜き)"}]
[null,{"$f":"CONCATENATE(連合専用条件入力画面!H10*8,\"㎥までは、\",TEXT(上下水道料金計算!B8*上下水道料金計算!D8,\"#,##0\"),\"円\")","v":"80㎥までは、13,700円"},null,null,{"$f":"CONCATENATE(\"※0㎥～\",上下水道料金計算!F6,\"㎥までは、同額\",TEXT(上下水道料金計算!F8*1.08,\"#,##0\"),\"円(税込額)\")","v":"※0㎥～80㎥までは、同額14,796円(税込額)"}]
[null,null,null,null,null,null,null,null,null,null,null,"重量料金"]
[null,{"$f":"CONCATENATE(上下水道料金計算!H3,\"㎥－\",上下水道料金計算!F6,\"㎥＝\",上下水道料金計算!H3-上下水道料金計算!F6,\"㎥\")","v":"300㎥－80㎥＝220㎥"},null,null,{"$f":"CONCATENATE(\"のこりの\",上下水道料金計算!H3-上下水道料金計算!F6,\"㎥は\")","v":"のこりの220㎥は"},null,null,null,null,null,null,{"$f":"上下水道料金計算!A54","v":"8㎥を超え30㎥まで"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(上下水道料金計算!B54,\"㎥　×　\",上下水道料金計算!D54,\"円　＝　\",TEXT(上下水道料金計算!F54,\"#,##0\"),\"円(税抜き) \")","v":"22㎥　×　125円　＝　2,750円(税抜き) "},null,null,null,null,null,{"$f":"上下水道料金計算!F54","v":2750},{"$f":"上下水道料金計算!B54","v":22}]
[null,{"$f":"CONCATENATE(\"通常の従量料金は、\",8,\"㎥を越え\",30,\"㎥までは １㎥につき\",料金表!G13,\"円なので\")","v":"通常の従量料金は、8㎥を越え30㎥までは １㎥につき125円なので"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"上下水道料金計算!A55","v":"30㎥を超え50㎥まで"}]
[null,"連合の場合は、",null,{"$f":"CONCATENATE(上下水道料金計算!B6,\"㎥\",\"×\",上下水道料金計算!D6,\"世帯＝\",上下水道料金計算!F6,\"㎥までは基本水量\")","v":"8㎥×10世帯＝80㎥までは基本水量"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(上下水道料金計算!B55,\"㎥　×　\",上下水道料金計算!D55,\"円　＝　\",TEXT(上下水道料金計算!F55,\"#,##0\"),\"円(税抜き)\")","v":"20㎥　×　145円　＝　2,900円(税抜き)"},null,null,null,null,null,{"$f":"上下水道料金計算!F55","v":2900},{"$f":"上下水道料金計算!B55","v":20}]
[null,null,null,{"$f":"CONCATENATE(上下水道料金計算!F6,\"㎥～\",\"(\",\"30㎥\",\"×\",上下水道料金計算!E3,\"世帯＝\",上下水道料金計算!C11*上下水道料金計算!E3,\"㎥)までは１㎥につき\",上下水道料金計算!C10,\"円となります。\")","v":"80㎥～(30㎥×10世帯＝300㎥)までは１㎥につき125円となります。"}]
[null,{"$f":"CONCATENATE(上下水道料金計算!C11*上下水道料金計算!E3,\"㎥までは、１㎥につき\",上下水道料金計算!C10,\"円の計算となります。\")","v":"300㎥までは、１㎥につき125円の計算となります。"},null,null,null,null,null,null,null,null,null,{"$f":"上下水道料金計算!A56","v":"50㎥を超え100㎥まで"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(上下水道料金計算!B56,\"㎥ ×　\",上下水道料金計算!D56,\"円\",\" ＝ \",TEXT(上下水道料金計算!F56,\"#,##0\"),\"円(税抜き)\")","v":"50㎥ ×　170円 ＝ 8,500円(税抜き)"},null,null,null,null,null,{"$f":"上下水道料金計算!F56","v":8500},{"$f":"上下水道料金計算!B56","v":50}]
[null,"よって",null,null,null,null,"金額","水量"]
[null,{"$f":"CONCATENATE(\"基本料金　＝\",\"基本水量(\",上下水道料金計算!F6,\"㎥)までは\",TEXT(上下水道料金計算!F8,\"#,##0\"),\"円(税抜き)\")","v":"基本料金　＝基本水量(80㎥)までは13,700円(税抜き)"},null,null,null,null,{"$f":"上下水道料金計算!F8","v":13700},{"$f":"上下水道料金計算!F6","v":80},null,null,null,{"$f":"上下水道料金計算!A57","v":"100㎥を超え400㎥まで"}]
[null,{"$f":"CONCATENATE(上下水道料金計算!F6,\"㎥を越える分＝\",上下水道料金計算!B31,\"㎥　×　\",上下水道料金計算!D31,\"円　＝\")","v":"80㎥を越える分＝220㎥　×　125円　＝"},null,null,null,null,{"$f":"IF(上下水道料金計算!B31=\"\",\"\",上下水道料金計算!B31*上下水道料金計算!D31)","v":27500},{"$f":"上下水道料金計算!B31","v":220},null,null,null,{"$f":"CONCATENATE(上下水道料金計算!B57,\"㎥　×　\",上下水道料金計算!D57,\"円　＝　\",TEXT(上下水道料金計算!F57,\"#,##0\"),\"円(税抜き)\")","v":"200㎥　×　200円　＝　40,000円(税抜き)"},null,null,null,null,null,{"$f":"上下水道料金計算!F57","v":40000},{"$f":"上下水道料金計算!B57","v":200}]
[null,{"$f":"IF(上下水道料金計算!B32=\"\",\"\",CONCATENATE(上下水道料金計算!G11,\"㎥を越える分＝\",上下水道料金計算!B32,\"㎥　×　\",上下水道料金計算!D32,\"円　＝\"))","v":""},null,null,null,null,{"$f":"IF(上下水道料金計算!F32<=0,\"\",上下水道料金計算!F32)","v":""},{"$f":"IF(上下水道料金計算!B32=\"\",\"\",上下水道料金計算!B32)","v":""}]
[null,{"$f":"IF(上下水道料金計算!B33=\"\",\"\",CONCATENATE(上下水道料金計算!G14,\"㎥を越える分＝\",上下水道料金計算!B33,\"㎥　×　\",上下水道料金計算!D33,\"円＝\"))","v":""},null,null,null,null,{"$f":"IF(上下水道料金計算!F33=\"\",\"\",上下水道料金計算!F33)","v":""},{"$f":"IF(上下水道料金計算!B34=\"\",\"\",上下水道料金計算!B33)","v":""},null,null,null,{"$f":"上下水道料金計算!A58","v":"400㎥を超えるもの"}]
[null,{"$f":"IF(上下水道料金計算!B34=\"\",\"\",CONCATENATE(上下水道料金計算!G17,\"㎥を越える分＝\",上下水道料金計算!B34,\"㎥　×　\",上下水道料金計算!D34,\"円＝\"))","v":""},null,null,null,null,{"$f":"IF(上下水道料金計算!F34=\"\",\"\",上下水道料金計算!F34)","v":""},{"$f":"IF(上下水道料金計算!B34=\"\",\"\",上下水道料金計算!B34)","v":""},null,null,null,{"$f":"CONCATENATE(上下水道料金計算!B58,\"㎥　×　\",上下水道料金計算!D58,\"円　＝　\",TEXT(上下水道料金計算!F58,\"#,##0\"),\"円(税抜き)\")","v":"㎥　×　円　＝　円(税抜き)"},null,null,null,null,null,{"$f":"上下水道料金計算!F58","v":""},{"$f":"上下水道料金計算!B58","v":""}]
[null,{"$f":"IF(上下水道料金計算!C3<=25,\"\",CONCATENATE(\"0㎥を超え\",上下水道料金計算!F6,\"㎥まで口径30㎜以上に従量料金の適用\"))","v":""}]
[null,{"$f":"IF(上下水道料金計算!C3<=25,\"\",CONCATENATE(上下水道料金計算!B36,\"㎥　×　\",料金表!F13,\"円　＝\"))","v":""},null,null,null,null,{"$f":"IF(B29=\"\",\"\",上下水道料金計算!F36)","v":""},{"$f":"IF(G29=\"\",\"\",H23)","v":""},null,null,null,{"$f":"IF(上下水道料金計算!C49<=25,\"\",\"0㎥を超え8㎥まで　口径30㎜以上に従量料金の適用\")","v":"0㎥を超え8㎥まで　口径30㎜以上に従量料金の適用"}]
[null,null,null,null,null,"合計",{"$f":"SUM(G23:G29)","v":41200},{"$f":"SUM(H23:H27)","v":300}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(上下水道料金計算!C49<=25,\"\",CONCATENATE(上下水道料金計算!B59,\"㎥　×　\",上下水道料金計算!D59,\"円　＝\"))","v":"8㎥　×　110円　＝"},null,null,null,null,null,{"$f":"IF(L31=\"\",\"\",上下水道料金計算!F59)","v":880},{"$f":"IF(R31=\"\",\"\",\"水量8㎥\")","v":"水量8㎥"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合　計",{"$f":"SUM(R10:R31)","v":59420},{"$f":"SUM(S10:S24)","v":300}]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(TEXT(G30,\"#,##0\"),\"円　×　1.10　＝\",TEXT((G30*1.1),\"#,##0.0\"),\"円\")","v":"41,200円　×　1.10　＝45,320.0円"},null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(TEXT(R32,\"#,##0\"),\"円　×　1.10　＝\",TEXT(R32*1.1,\"#,##0.0\"),\"円\")","v":"59,420円　×　1.10　＝65,362.0円"}]
[null,"端数は、切り捨てる。よって",null,null,{"$f":"ROUNDDOWN(G30*1.1,0)","v":45320},null,null,null,null,null,null,"端数は切り捨てる。よって",null,null,{"$f":"ROUNDDOWN(R32*1.1,0)","v":65362}]
[]
[null,{"$f":"CONCATENATE(\"口径　\",上下水道料金計算!C3,\"㎜　\",上下水道料金計算!E3,\"世帯　\",上下水道料金計算!H3,\"㎥の使用水量料金は\")","v":"口径　20㎜　10世帯　300㎥の使用水量料金は"},null,null,null,null,{"$f":"E38","v":45320},"となります。",null,null,null,{"$f":"CONCATENATE(\"口径\",上下水道料金計算!C49,\"㎜　\",上下水道料金計算!H49,\"㎥の使用水量料金は\")","v":"口径40㎜　300㎥の使用水量料金は"},null,null,null,{"$f":"O38","v":65362},"となります。"]

{"sheet":"下水道説明資料","index":4,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[[26,1,26,4],[34,11,34,13],[36,1,36,5],[27,1,27,4],[7,1,7,5],[23,1,23,4],[23,11,23,14],[24,1,24,4],[25,1,25,4],[26,11,26,14],[16,11,16,14],[17,1,18,2],[17,11,17,14],[19,11,19,14],[20,11,20,14],[22,11,22,14],[15,1,15,8],[1,2,1,7],[1,12,1,17],[3,1,3,5],[5,1,5,4],[9,1,9,7],[10,12,10,16],[13,1,13,3],[13,4,13,5],[13,11,13,14],[14,11,14,14]]}
[]
[null,null,"連合の計算について(下水道)",null,null,null,null,null,null,null,null,null,"通常の計算について(下水道)"]
[]
[null,{"$f":"CONCATENATE(連合専用条件入力画面!H10,\"世帯　使用水量　\",連合専用条件入力画面!H12,\"㎥の場合\")","v":"10世帯　使用水量　300㎥の場合"},null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(上下水道料金計算!E3,\"世帯　使用水量　\",上下水道料金計算!H3,\"㎥の場合\")","v":"10世帯　使用水量　300㎥の場合"}]
[]
[null,{"$f":"CONCATENATE(連合専用条件入力画面!H10,\"世帯の基本料金・水量\")","v":"10世帯の基本料金・水量"},null,null,null,null,null,null,null,null,null,"基本料金・水量は"]
[]
[null,{"$f":"CONCATENATE(\"下水道使用量計算　　\",上下水道料金計算!B74,\"㎥×\",連合専用条件入力画面!H10,\"世帯＝\",上下水道料金計算!B74*連合専用条件入力画面!H10,\"㎥\")","v":"下水道使用量計算　　8㎥×10世帯＝80㎥"},null,null,null,null,null,null,null,null,null,"○基本水量は、10㎥まで",null,null,null,null,null,"金　　額","水　　量"]
[]
[null,{"$f":"CONCATENATE(\"下水道使用料金計算　　\",TEXT(料金表!S6,\"#,##0\"),\"円(税抜き)　×　\",連合専用条件入力画面!H10,\"世帯＝\",TEXT(上下水道料金計算!F101,\"#,##0\"),\"(税抜き)\")","v":"下水道使用料金計算　　500円(税抜き)　×　10世帯＝5,000(税抜き)"},null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"○基本料金は、\",TEXT(料金表!S6,\"#,##0\"),\"円(税抜き)\")","v":"○基本料金は、500円(税抜き)"},null,null,null,null,null,{"$f":"上下水道料金計算!F122","v":500},{"$f":"上下水道料金計算!B74","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"※0㎥～\",上下水道料金計算!B74,\"㎥までは、同額　\",TEXT(料金表!S6,\"#,##0\"),\"円(税抜き)\")","v":"※0㎥～8㎥までは、同額　500円(税抜き)"}]
[null,{"$f":"CONCATENATE(連合専用条件入力画面!H10*10,\"㎥までは、\",TEXT(上下水道料金計算!F101,\"#,##0\"),\"円\")","v":"100㎥までは、5,000円"},null,null,{"$f":"CONCATENATE(\"※0㎥～\",上下水道料金計算!F98,\"㎥までは、同額\",TEXT(上下水道料金計算!F101*1.08,\"#,##0\"),\"円(税込額)\")","v":"※0㎥～80㎥までは、同額5,400円(税込額)"}]
[null,null,null,null,null,null,null,null,null,null,null,"重量料金"]
[null,{"$f":"CONCATENATE(上下水道料金計算!H3,\"㎥－\",上下水道料金計算!F98,\"㎥＝\",上下水道料金計算!H3-上下水道料金計算!F98,\"㎥\")","v":"300㎥－80㎥＝220㎥"},null,null,{"$f":"CONCATENATE(\"のこりの\",上下水道料金計算!H3-上下水道料金計算!F98,\"㎥は\")","v":"のこりの220㎥は"},null,null,null,null,null,null,{"$f":"IF(上下水道料金計算!B124=\"\",\"\",上下水道料金計算!A124)","v":"8㎥を超え30㎥まで"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(上下水道料金計算!B124=\"\",\"\",(CONCATENATE(上下水道料金計算!B124,\"㎥　×　\",上下水道料金計算!D124,\"円　＝　\",TEXT(上下水道料金計算!F124,\"#,##0\"),\"円(税抜き) \")))","v":"22㎥　×　70円　＝　1,540円(税抜き) "},null,null,null,null,null,{"$f":"上下水道料金計算!F124","v":1540},{"$f":"上下水道料金計算!B124","v":22}]
[null,{"$f":"CONCATENATE(\"通常の従量料金は、\",上下水道料金計算!B74,\"㎥を越え\",30,\"㎥までは １㎥につき\",料金表!S7,\"円だが\")","v":"通常の従量料金は、8㎥を越え30㎥までは １㎥につき70円だが"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(上下水道料金計算!B125=\"\",\"\",上下水道料金計算!A125)","v":"30㎥を超え50㎥まで"}]
[null,"連合の場合は、",null,{"$f":"CONCATENATE(上下水道料金計算!B98,\"㎥\",\"×\",上下水道料金計算!D6,\"世帯＝\",上下水道料金計算!F98,\"㎥までは基本水量\")","v":"8㎥×10世帯＝80㎥までは基本水量"},null,null,null,null,null,null,null,{"$f":"IF(上下水道料金計算!B125=\"\",\"\",(CONCATENATE(上下水道料金計算!B125,\"㎥　×　\",上下水道料金計算!D125,\"円　＝　\",TEXT(上下水道料金計算!F125,\"#,##0\"),\"円(税抜き)\")))","v":"20㎥　×　70円　＝　1,400円(税抜き)"},null,null,null,null,null,{"$f":"上下水道料金計算!F125","v":1400},{"$f":"上下水道料金計算!B125","v":20}]
[null,null,null,{"$f":"CONCATENATE(上下水道料金計算!F98,\"㎥～\",\"(\",\"30㎥\",\"×\",上下水道料金計算!E3,\"世帯＝\",上下水道料金計算!C11*上下水道料金計算!E3,\"㎥)までは１㎥につき\",料金表!S7,\"円となります。\")","v":"80㎥～(30㎥×10世帯＝300㎥)までは１㎥につき70円となります。"}]
[null,{"$f":"CONCATENATE(上下水道料金計算!C11*上下水道料金計算!E3,\"㎥までは、１㎥につき\",料金表!S7,\"円の計算となります。\")","v":"300㎥までは、１㎥につき70円の計算となります。"},null,null,null,null,null,null,null,null,null,{"$f":"IF(上下水道料金計算!B126=\"\",\"\",上下水道料金計算!A126)","v":"50㎥を超え100㎥まで"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(上下水道料金計算!B126=\"\",\"\",(CONCATENATE(上下水道料金計算!B126,\"㎥ ×　\",上下水道料金計算!D126,\"円\",\" ＝ \",TEXT(上下水道料金計算!F126,\"#,##0\"),\"円(税抜き)\")))","v":"50㎥ ×　70円 ＝ 3,500円(税抜き)"},null,null,null,null,null,{"$f":"上下水道料金計算!F126","v":3500},{"$f":"上下水道料金計算!B126","v":50}]
[null,"よって",null,null,null,null,"金額","水量"]
[null,{"$f":"CONCATENATE(\"基本料金　＝\",\"基本水量(\",上下水道料金計算!F98,\"㎥)までは\",TEXT(上下水道料金計算!F101,\"#,##0\"),\"円(税抜き)\")","v":"基本料金　＝基本水量(80㎥)までは5,000円(税抜き)"},null,null,null,null,{"$f":"上下水道料金計算!F101","v":5000},{"$f":"上下水道料金計算!F98","v":80},null,null,null,{"$f":"IF(上下水道料金計算!B127=\"\",\"\",上下水道料金計算!A127)","v":"100㎥を超え400㎥まで"}]
[null,{"$f":"IF(上下水道料金計算!B103=\"\",\"\",CONCATENATE(上下水道料金計算!A103,\"=\",上下水道料金計算!B103,\"㎥　×　\",上下水道料金計算!D103,\"円　＝\"))","v":"80㎥を超え300㎥まで=220㎥　×　70円　＝"},null,null,null,null,{"$f":"IF(B24=\"\",\"\",上下水道料金計算!B103*上下水道料金計算!D103)","v":15400},{"$f":"IF(上下水道料金計算!B103=\"\",\"\",上下水道料金計算!B103)","v":220},null,null,null,{"$f":"IF(上下水道料金計算!B127=\"\",\"\",CONCATENATE(上下水道料金計算!B127,\"㎥　×　\",上下水道料金計算!D127,\"円　＝　\",TEXT(上下水道料金計算!F127,\"#,##0\"),\"円(税抜き)\"))","v":"200㎥　×　70円　＝　14,000円(税抜き)"},null,null,null,null,null,{"$f":"上下水道料金計算!F127","v":14000},{"$f":"上下水道料金計算!B127","v":200}]
[null,{"$f":"IF(上下水道料金計算!B104=\"\",\"\",CONCATENATE(上下水道料金計算!A104,\"=\",上下水道料金計算!B32,\"㎥　×　\",料金表!S8,\"円　＝\"))","v":"300㎥を超え500㎥まで=㎥　×　70円　＝"},null,null,null,null,{"$f":"IF(B25=\"\",\"\",上下水道料金計算!B104*上下水道料金計算!D104)","v":0},{"$f":"IF(上下水道料金計算!B32=\"\",\"\",上下水道料金計算!B32)","v":""}]
[null,{"$f":"IF(上下水道料金計算!B105=\"\",\"\",CONCATENATE(上下水道料金計算!A105,\"=\",上下水道料金計算!B33,\"㎥　×　\",料金表!S9,\"円＝\"))","v":""},null,null,null,null,{"$f":"IF(B26=\"\",\"\",上下水道料金計算!B105*上下水道料金計算!D105)","v":""},{"$f":"上下水道料金計算!B105","v":""},null,null,null,{"$f":"IF(上下水道料金計算!B128=\"\",\"\",上下水道料金計算!A128)","v":""}]
[null,{"$f":"IF(上下水道料金計算!B106=\"\",\"\",CONCATENATE(上下水道料金計算!A106,\"=\",上下水道料金計算!B106,\"㎥　×　\",料金表!S10,\"円＝\"))","v":""},null,null,null,null,{"$f":"IF(B27=\"\",\"\",上下水道料金計算!B106*上下水道料金計算!D106)","v":""},{"$f":"上下水道料金計算!B106","v":""},null,null,null,{"$f":"IF(上下水道料金計算!B128=\"\",\"\",CONCATENATE(上下水道料金計算!B128,\"㎥　×　\",上下水道料金計算!D128,\"円　＝　\",TEXT(上下水道料金計算!F128,\"#,##0\"),\"円(税抜き)\"))","v":""},null,null,null,null,null,{"$f":"上下水道料金計算!F128","v":""},{"$f":"上下水道料金計算!B128","v":""}]
[null,{"$f":"IF(上下水道料金計算!B107=\"\",\"\",CONCATENATE(上下水道料金計算!A107,\"=\",上下水道料金計算!B35,\"㎥　×　\",料金表!S11,\"円＝\"))","v":""},null,null,null,null,{"$f":"IF(上下水道料金計算!B107=\"\",\"\",上下水道料金計算!F36)","v":""},{"$f":"IF(G28=\"\",\"\",H23)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合　計",{"$f":"SUM(R10:R27)","v":20940},{"$f":"SUM(S10:S27)","v":300}]
[null,null,null,null,null,"合計",{"$f":"SUM(G23:G28)","v":20400},{"$f":"SUM(H23:H27)","v":300}]
[]
[]
[]
[null,{"$f":"CONCATENATE(TEXT(G30,\"#,##0\"),\"円　×　1.10　＝\",TEXT((G30*1.1),\"#,##0.0\"),\"円\")","v":"20,400円　×　1.10　＝22,440.0円"},null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(TEXT(R29,\"#,##0\"),\"円　×　1.10　＝\",TEXT(R29*1.1,\"#,##0.0\"),\"円\")","v":"20,940円　×　1.10　＝23,034.0円"}]
[null,"端数は、切り捨てる。よって",null,null,{"$f":"ROUNDDOWN(G30*1.1,0)","v":22440},null,null,null,null,null,null,"端数は切り捨てる。よって",null,null,{"$f":"ROUNDDOWN(R29*1.1,0)","v":23034}]
[]
[null,{"$f":"CONCATENATE(,上下水道料金計算!E3,\"世帯　\",上下水道料金計算!H3,\"㎥の使用水量料金は\")","v":"10世帯　300㎥の使用水量料金は"},null,null,null,null,{"$f":"E35","v":22440},"となります。",null,null,null,{"$f":"CONCATENATE(,上下水道料金計算!H49,\"㎥の使用水量料金は\")","v":"300㎥の使用水量料金は"},null,null,null,{"$f":"O35","v":23034},"となります。"]