{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["市納金計算表","水道料金計算表","市納金一覧","date"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":32,"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":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[22,1,22,8],[26,4,26,5],[1,1,1,7],[17,4,17,5],[3,13,3,14],[3,10,3,11],[14,9,15,9],[14,10,15,18],[10,11,12,12],[11,13,12,16],[8,4,8,5],[13,4,13,5],[15,4,15,5],[16,10,17,18],[33,11,34,13],[29,11,29,17],[26,11,26,17],[25,11,25,17],[19,2,20,4],[19,5,20,7],[27,11,27,17],[21,11,22,12],[23,11,23,12],[21,13,21,17],[22,13,22,15],[23,13,23,15],[22,16,22,17],[23,16,23,17],[24,11,24,17],[18,10,19,18]]}
[]
[null,"≪新設分分岐プール額計算表≫",null,null,null,null,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,"×","本数",1,"=",{"$f":"(VLOOKUP(L6,加入金甲,2,0)*O6)","v":66000},"a"]
[null,null,"道路形態","舗装道",null,null,{"$f":"VLOOKUP(D9,IF(D7=\"砂利道\",口径金額砂利道,口径金額舗装道),2,0)","v":6191900.0000000009}]
[null,null,null,null,null,null,null,null,null,"新設）","口径",20,"×","本数",1,"=",{"$f":"VLOOKUP(L8,加入金甲,2,0)*O8","v":115500},"b"]
[null,null,"口径",100,"⇒",null,{"$f":"IF(D11=\"あり\",G7*1.35,G7)","v":8359065.0000000019},"A"]
[]
[null,null,"夜間工事","あり",null,null,null,null,null,null,null,"加入金額\n（b-a）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q6>Q8,0,Q8-Q6)","v":49500}]
[]
[]
[null,null,null,null,null,null,null,null,null,"※","口径変更の場合、既設管の加入金を充当できるが、新設管の\n加入金を上回った額の還付は行わない。"]
[null,null,"先行分岐","なし","⇒",null,{"$f":"IF(D16=\"あり\",date!G21,0)","v":0},"B"]
[null,null,null,null,null,null,null,null,null,"※","分岐プール額及び加入金については消費税を含んだ額であり、\n工事検査手数料については非課税です。"]
[null,null,"本復旧軽減","自己都合","⇒",null,{"$f":"IF(D18=\"あり\",IF(D7=\"舗装道\",IF(D11=\"なし\",IF(D9<=40,date!E35,IF(AND(40<D9,D9<=50),date!E36,date!E36)),IF(D9<=40,date!F35,IF(AND(40<D9,D9<=50),date!F36,date!F36))),0),IF(D18=\"自己都合\",IF(D7=\"舗装道\",IF(D11=\"なし\",IF(D9<=25,date!G35,IF(AND(40<D9,D9<=50),date!G36,date!G36)),IF(D9<=40,date!H35,IF(AND(40<D9,D9<=50),date!H36,date!H36))),0),0))","v":-85388},"C"]
[null,null,null,null,null,null,null,null,null,"※","分岐プール額及び加入金の他に、工事検査手数料が必要です。\n（下記参照）"]
[null,null,"新設分分岐プール額\n(A+B+C)",null,null,{"$f":"SUM(G9,G14,G16,G18)","v":8273677.0000000019}]
[null,null,null,null,null,null,null,null,null,null,"　　工事検査手数料"]
[null,null,null,null,null,null,null,null,null,null,null,"給水管の\n呼 び 径",null,"給水装置工事又は私・共有管布設工事"]
[null,"≪撤去分分岐プール額計算表　1装置につき≫",null,null,null,null,null,null,null,null,null,null,null,"新設、全改造",null,null,"増設その他"]
[null,null,null,null,null,null,null,null,null,null,null,"全ての口径",null,19300,null,null,4300]
[null,null,"道路形態","舗装道",null,null,null,null,null,null,null,"（適用）"]
[null,null,null,null,null,null,null,null,null,null,null,"⑴　給水装置工事の中で、内部工事を伴わない先行分岐等の\n     工事検査手数料は、増設の基準を適用する。"]
[null,null,"夜間工事","なし","⇒",null,{"$f":"IF(AND(D25=\"砂利道\",D27=\"なし\"),date!E47,(IF(AND(D25=\"砂利道\",D27=\"あり\"),date!E48,IF(AND(D25=\"舗装道\",D27=\"なし\"),date!F47,IF(AND(D25=\"舗装道\",D27=\"あり\"),date!F48,0)))))","v":192500},null,null,null,null,"⑵　本表の工事検査手数料は、１件１工事２ｍ未満の私、共有\n     管及び修繕等の工事には適用しない。"]
[null,null,null,null,null,null,null,null,null,null,null,"⑶　再検査を必要とする場合については、再度、同額の手数料\n     を徴収する。"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"⑶　再検査を必要とする場合については、再度、同額の手数料を徴収する。"]

{"sheet":"水道料金計算表","index":1,"n_rows":106,"n_cols":22,"rows_kept":106,"cut":false,"hidden":true,"merged":[[33,2,33,5],[22,1,23,5],[49,1,50,5],[49,6,50,9],[82,8,83,9],[76,1,77,5],[94,8,95,9],[56,1,57,3],[67,15,70,15],[86,15,89,15],[67,14,72,14],[87,12,87,13],[55,8,56,9],[60,2,60,4],[76,6,77,9],[83,1,84,3],[19,8,19,9],[67,16,67,18],[69,17,69,18],[68,17,68,18],[59,16,59,18],[69,8,69,9],[46,8,46,9],[30,16,30,19],[23,17,23,18],[60,12,60,13],[69,12,69,13],[64,8,64,9],[66,8,67,9],[40,14,48,14],[42,8,42,9],[2,1,3,3],[29,1,30,3],[0,0,0,22],[28,8,29,9],[1,8,2,9],[12,8,13,9],[22,6,23,9],[5,2,5,4],[19,1,19,2],[6,12,6,13],[3,16,3,18],[10,8,10,9],[13,15,20,15],[15,12,15,13],[3,14,8,14],[13,16,13,18],[103,1,104,5],[95,14,103,14],[86,2,86,4],[97,12,97,13],[4,17,4,18],[40,16,40,18],[41,17,41,18],[33,12,33,13],[40,15,47,15],[44,12,44,13],[42,12,42,13],[37,8,37,9],[31,17,31,18],[14,17,14,18],[13,14,21,14],[95,16,95,18],[96,17,96,18],[39,8,40,9],[30,14,35,14],[50,17,50,18],[105,17,105,18],[59,14,63,14],[86,14,90,14],[73,8,73,9],[101,8,101,9],[103,6,104,9],[95,15,102,15],[86,16,86,18],[60,17,60,18],[87,17,87,18],[88,17,88,18],[91,8,91,9]]}
[" ≪料金計算表≫"]
[null,null,null,null,null,null,null,null,"水道料金"]
[null,"【一般用】"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"水量料金内訳",null,"使用水量",null,null,null,"単価","金額"]
[null,null,null,null,null,null,null,null,null,"準備料金(A)",{"$f":"(VLOOKUP(D8,準備料金,2,0))*D10","v":2240},null,null,null,null,null,{"$f":"IF($D$10=1,10,20)","v":20},"m3まで",null,null,65,{"$f":"IF(D12<Q6,D12*U5,Q5*U5)","v":1300}]
[null,null,"（入力値）",null,null,null,null,null,null,"+",null,null,null,null,null,null,{"$f":"IF($D$10=1,11,21)","v":21},"～",{"$f":"IF($D$10=1,20,40)","v":40},"m3",125,{"$f":"IF($D$12<Q7,IF($D$12<Q5,0,($D$12-Q5)*U6),(S6-Q5)*U6)","v":2500}]
[null,null,null,null,null,null,null,null,null,"水量料金(B)",{"$f":"SUM(V5:V11)","v":8200},null,"⇒",null,null,null,{"$f":"IF($D$10=1,21,41)","v":41},"～",{"$f":"IF($D$10=1,30,60)","v":60},"m3",220,{"$f":"IF($D$12<Q8,IF($D$12<Q7,0,($D$12-S6)*U7),(S7-S6)*U7)","v":4400}]
[null,"口径",null,20,"mm",null,null,null,null,"+",null,null,null,null,null,null,{"$f":"IF($D$10=1,31,61)","v":61},"～",{"$f":"IF($D$10=1,100,200)","v":200},"m3",230,{"$f":"IF($D$12<Q9,IF($D$12<Q8,0,($D$12-S7)*U8),(S8-S7)*U8)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"消費税 \"&DBCS(TEXT(date!$G$17*100,0))&\"％(C)\"","v":"消費税 １０％(C)"},{"$f":"ROUNDDOWN(SUM(K5,K7)*date!G17,0)","v":1044},null,null,null,null,null,{"$f":"IF($D$10=1,101,201)","v":201},"～",{"$f":"IF($D$10=1,3000,6000)","v":6000},"m3",245,{"$f":"IF($D$12<Q10,IF($D$12<Q9,0,($D$12-S8)*U9),(S9-S8)*U9)","v":0}]
[null,"使用月数",null,2,"ヵ月",null,null,null,null,"↓",null,null,null,null,null,null,{"$f":"IF($D$10=1,3001,6001)","v":6001},"～",{"$f":"IF($D$10=1,10000,20000)","v":20000},"m3",255,{"$f":"IF($D$12<Q11,IF($D$12<Q10,0,($D$12-S9)*U10),(S10-S9)*U10)","v":0}]
[null,null,null,null,null,null,null,null,"税込合計(A+B+C)",null,{"$f":"SUM(K5,K7,K9)","v":11484},"D",null,null,null,null,{"$f":"IF($D$10=1,10001,20001)","v":20001},"m3以上",null,null,200,{"$f":"IF($D$12>S10,(D12-S10)*U11,0)","v":0}]
[null,"使用水量",null,60,"m3"]
[null,null,null,null,null,null,null,null,"下水道使用料"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"下水道使用料内訳",null,"使用水量",null,null,null,"単価","金額"]
[null,"下水道接続",null,"あり",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$10=1,5,10)","v":10},"m3まで",null,null,{"$f":"IF(D10=1,640,1280)","v":1280},{"$f":"IF(D15=\"あり\",U15,0)","v":1280}]
[null,null,null,null,null,null,null,null,null,"下水道使用料(E)",{"$f":"SUM(V15:V24)","v":6230},null,"⇒",null,null,null,{"$f":"IF($D$10=1,6,11)","v":11},"～",{"$f":"IF($D$10=1,10,20)","v":20},"m3",70,{"$f":"IF(D15=\"あり\",IF($D$12<Q17,IF($D$12<Q15,0,($D$12-Q15)*U16),(S16-Q15)*U16),0)","v":700}]
[null,null,null,null,null,null,null,null,null,"+",null,null,null,null,null,null,{"$f":"IF($D$10=1,11,21)","v":21},"～",{"$f":"IF($D$10=1,15,30)","v":30},"m3",95,{"$f":"IF(D15=\"あり\",IF($D$12<Q18,IF($D$12<Q17,0,($D$12-S16)*U17),(S17-S16)*U17),0)","v":950}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"消費税 \"&DBCS(TEXT(date!$G$17*100,0))&\"％(F)\"","v":"消費税 １０％(F)"},{"$f":"ROUNDDOWN(K16*date!G17,0)","v":623},null,null,null,null,null,{"$f":"IF($D$10=1,16,31)","v":31},"～",{"$f":"IF($D$10=1,30,60)","v":60},"m3",110,{"$f":"IF(D15=\"あり\",IF($D$12<Q19,IF($D$12<Q18,0,($D$12-S17)*U18),(S18-S17)*U18),0)","v":3300}]
[null,null,null,null,null,null,null,null,null,"↓",null,null,null,null,null,null,{"$f":"IF($D$10=1,31,61)","v":61},"～",{"$f":"IF($D$10=1,100,200)","v":200},"m3",150,{"$f":"IF(D15=\"あり\",IF($D$12<Q20,IF($D$12<Q19,0,($D$12-S18)*U19),(S19-S18)*U19),0)","v":0}]
[null,null,null,null,null,null,null,null,"税込合計(E+F)",null,{"$f":"SUM(K16,K18)","v":6853},"G",null,null,null,null,{"$f":"IF($D$10=1,101,201)","v":201},"～",{"$f":"IF($D$10=1,500,1000)","v":1000},"m3",160,{"$f":"IF(D15=\"あり\",IF($D$12<Q21,IF($D$12<Q20,0,($D$12-S19)*U20),(S20-S19)*U20),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$10=1,501,1001)","v":1001},"～",{"$f":"IF($D$10=1,1000,2000)","v":2000},"m3",170,{"$f":"IF(D15=\"あり\",IF($D$12<Q22,IF($D$12<Q21,0,($D$12-S20)*U21),(S21-S20)*U21),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$10=1,1001,2001)","v":2001},"～",{"$f":"IF($D$10=1,5000,10000)","v":10000},"m3",180,{"$f":"IF(D15=\"あり\",IF($D$12<Q23,IF($D$12<Q22,0,($D$12-S21)*U22),(S22-S21)*U22),0)","v":0}]
[null,"上下水道料金合計(D+G)",null,null,null,null,{"$f":"SUM(K11,K20)","v":18337},null,null,null,null,null,null,null,null,null,{"$f":"IF($D$10=1,5001,10001)","v":10001},"～",{"$f":"IF($D$10=1,10000,20000)","v":20000},"m3",195,{"$f":"IF(D15=\"あり\",IF($D$12<Q24,IF($D$12<Q23,0,($D$12-S22)*U23),(S23-S22)*U23),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$10=1,10001,20001)","v":20001},"m3以上",null,null,200,{"$f":"IF($D$12>S23,(D12-S23)*U24,0)","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,"※　ワンルームは７戸以上からが集合家事対象。",null,null,null,null,null,null,null,"準備料金(A)",{"$f":"IF(D36=13,910,IF(D36=\"\",\"\",1020))*E40*D42","v":4080},null,null,null,null,null,{"$f":"IF(D42=1,10*E40,20*E40)","v":40},"m3まで",null,null,65,{"$f":"IF($D$44<Q33,(D44*U32),Q32*U32)","v":2600}]
[null,null,null,null,null,null,null,null,null,"+",null,null,null,null,null,null,{"$f":"IF($D$42=1,(10*$E$40)+1,(20*$E$40)+1)","v":41},"～",{"$f":"IF(D42=1,20*E40,40*E40)","v":80},"m3",125,{"$f":"IF($D$44<Q34,IF($D$44<Q33,0,(D44-Q32)*U33),(S33-Q32)*U33)","v":2500}]
[null,null,"（入力値）",null,null,null,null,null,null,"水量料金(B)",{"$f":"SUM(V32:V38)","v":5100},null,"⇒",null,null,null,{"$f":"IF($D$42=1,(20*$E$40)+1,(40*$E$40)+1)","v":81},"～",{"$f":"IF(D42=1,30*E40,60*E40)","v":120},"m3",220,{"$f":"IF($D$44<Q35,IF($D$44<Q34,0,($D$44-S33)*U34),(S34-S33)*U34)","v":0}]
[null,null,null,null,null,null,null,null,null,"+",null,null,null,null,null,null,{"$f":"IF($D$42=1,(30*$E$40)+1,(60*$E$40)+1)","v":121},"～",{"$f":"IF(D42=1,100*E40,200*E40)","v":400},"m3",230,{"$f":"IF($D$44<Q36,IF($D$44<Q35,0,($D$44-S34)*U35),(S35-S34)*U35)","v":0}]
[null,"子メータ口径",null,20,"mm",null,null,null,null,{"$f":"\"消費税 \"&DBCS(TEXT(date!$G$17*100,0))&\"％(C)\"","v":"消費税 １０％(C)"},{"$f":"ROUNDDOWN(SUM(K32,K34)*date!G17,0)","v":918},null,null,null,null,null,{"$f":"IF($D$42=1,(100*$E$40)+1,(200*$E$40)+1)","v":401},"～",{"$f":"IF(D42=1,3000*E40,6000*E40)","v":12000},"m3",245,{"$f":"IF($D$44<Q37,IF($D$44<Q36,0,($D$44-S35)*U36),(S36-S35)*U36)","v":0}]
[null,null,null,null,null,null,null,null,null,"↓",null,null,null,null,null,null,{"$f":"IF($D$42=1,(3000*$E$40)+1,(6000*$E$40)+1)","v":12001},"～",{"$f":"IF(D42=1,10000*E40,20000*E40)","v":40000},"m3",255,{"$f":"IF($D$44<Q38,IF($D$44<Q37,0,($D$44-S36)*U37),(S37-S36)*U37)","v":0}]
[null,"住戸形態",null,"ファミリー",null,null,null,null,"税込合計(A+B+C)",null,{"$f":"SUM(K32,K34,K36)","v":10098},"D",null,null,null,null,{"$f":"IF(D42=1,(10000*E40)+1,(20000*E40)+1)","v":40001},"m3以上",null,null,200,{"$f":"IF($D$44>S37,(D44-S37)*U38,0)","v":0}]
[]
[null,"装置数",null,2,{"$f":"IF(D38=\"ワンルーム\",ROUNDDOWN(D40/3.3,0),D40)","v":2},"戸",null,null,"下水道使用料"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"下水道使用料内訳",null,"使用水量",null,null,null,"単価","金額"]
[null,"使用月数",null,2,"ヵ月",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D42=1,5*E40,10*E40)","v":20},"m3まで",null,null,{"$f":"IF($D$42=1,540,1080)*E40","v":2160},{"$f":"IF(D46=\"あり\",U42,0)","v":2160}]
[null,null,null,null,null,null,null,null,"下水道使用料(E)",null,{"$f":"SUM(V42:V51)","v":5460},null,"⇒",null,null,null,{"$f":"IF($D$42=1,(5*$E$40)+1,(10*$E$40)+1)","v":21},"～",{"$f":"IF($D$42=1,(10*$E$40),(20*$E$40))","v":40},"m3",70,{"$f":"IF(D46=\"あり\",IF($D$44<Q44,IF($D$44<Q42,0,(D44-Q42)*U43),(S43-Q42)*U43),0)","v":1400}]
[null,"親メータ使用水量",null,60,"m3",null,null,null,null,"+",null,null,null,null,null,null,{"$f":"IF($D$42=1,(10*$E$40)+1,(20*$E$40)+1)","v":41},"～",{"$f":"IF($D$42=1,15*$E$40,30*$E$40)","v":60},"m3",95,{"$f":"IF(D46=\"あり\",IF($D$44<Q45,IF($D$44<Q44,0,($D$44-S43)*U44),(S44-S43)*U44),0)","v":1900}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"消費税 \"&DBCS(TEXT(date!$G$17*100,0))&\"％(F)\"","v":"消費税 １０％(F)"},{"$f":"ROUNDDOWN(K43*date!G17,0)","v":546},null,null,null,null,null,{"$f":"IF($D$42=1,(15*$E$40)+1,(30*$E$40)+1)","v":61},"～",{"$f":"IF($D$42=1,30*$E$40,60*$E$40)","v":120},"m3",110,{"$f":"IF(D46=\"あり\",IF($D$44<Q46,IF($D$44<Q45,0,($D$44-S44)*U45),(S45-S44)*U45),0)","v":0}]
[null,"下水道接続",null,"あり",null,null,null,null,null,"↓",null,null,null,null,null,null,{"$f":"IF($D$42=1,(30*$E$40)+1,(60*$E$40)+1)","v":121},"～",{"$f":"IF($D$42=1,100*$E$40,200*$E$40)","v":400},"m3",150,{"$f":"IF(D46=\"あり\",IF($D$44<Q47,IF($D$44<Q46,0,($D$44-S45)*U46),(S46-S45)*U46),0)","v":0}]
[null,null,null,null,null,null,null,null,"税込合計(E+F)",null,{"$f":"SUM(K43,K45)","v":6006},"G",null,null,null,null,{"$f":"IF($D$42=1,(100*$E$40)+1,(200*$E$40)+1)","v":401},"～",{"$f":"IF($D$42=1,500*$E$40,1000*$E$40)","v":2000},"m3",160,{"$f":"IF(D46=\"あり\",IF($D$44<Q48,IF($D$44<Q47,0,($D$44-S46)*U47),(S47-S46)*U47),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$42=1,(500*$E$40)+1,(1000*$E$40)+1)","v":2001},"～",{"$f":"IF($D$42=1,1000*$E$40,2000*$E$40)","v":4000},"m3",170,{"$f":"IF(D46=\"あり\",IF($D$44<Q49,IF($D$44<Q48,0,($D$44-S47)*U48),(S48-S47)*U48),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$42=1,(1000*$E$40)+1,(2000*$E$40)+1)","v":4001},"～",{"$f":"IF($D$42=1,5000*$E$40,10000*$E$40)","v":20000},"m3",180,{"$f":"IF(D46=\"あり\",IF($D$44<Q50,IF($D$44<Q49,0,($D$44-S48)*U49),(S49-S48)*U49),0)","v":0}]
[null,"上下水道料金合計(D+G)",null,null,null,null,{"$f":"SUM(K38,K47)","v":16104},null,null,null,null,null,null,null,null,null,{"$f":"IF($D$42=1,(5000*$E$40)+1,(10000*$E$40)+1)","v":20001},"～",{"$f":"IF($D$42=1,10000*$E$40,20000*$E$40)","v":40000},"m3",195,{"$f":"IF(D46=\"あり\",IF($D$44<Q51,IF($D$44<Q50,0,($D$44-S49)*U50),(S50-S49)*U50),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$42=1,(10000*$E$40)+1,(20000*$E$40)+1)","v":40001},"m3以上",null,null,200,{"$f":"IF($D$44>S50,(D44-S50)*U51,0)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"水道料金"]
[null,"【公衆浴場用】"]
[]
[null,null,null,null,null,null,null,null,null,"準備料金(A)",{"$f":"(VLOOKUP(D63,準備料金2,2,0))*D65","v":13800}]
[null,null,null,null,null,null,null,null,null,"+",null,null,null,null,"水量料金内訳",null,"使用水量",null,null,null,"単価","金額"]
[null,null,"（入力値）",null,null,null,null,null,null,"水量料金(B)",{"$f":"$V$61","v":0},null,"⇒",null,null,null,1,"m3につき",null,null,85,{"$f":"D67*U61","v":0}]
[null,null,null,null,null,null,null,null,null,"+"]
[null,"口径",null,"40以下","mm",null,null,null,null,{"$f":"\"消費税 \"&DBCS(TEXT(date!$G$17*100,0))&\"％(C)\"","v":"消費税 １０％(C)"},{"$f":"ROUNDDOWN(SUM(K59,K61)*date!G17,0)","v":1380}]
[null,null,null,null,null,null,null,null,null,"↓"]
[null,"使用月数",null,2,"ヵ月",null,null,null,"税込合計(A+B+C)",null,{"$f":"SUM(K59,K61,K63)","v":15180},"D"]
[]
[null,"使用水量",null,0,"m3",null,null,null,"下水道使用料"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"下水道使用料内訳",null,"使用水量",null,null,null,"単価","金額"]
[null,"下水道接続",null,"あり",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$65=1,300,600)","v":600},"m3まで",null,null,{"$f":"IF($D$65=1,9000,18000)","v":18000},{"$f":"IF(D69=\"あり\",IF($D$67<Q69,U69,U69),0)","v":18000}]
[null,null,null,null,null,null,null,null,"下水道使用料(E)",null,{"$f":"IF(D69=\"なし\",0,SUM(V69:V70))","v":18000},null,"⇒",null,null,null,{"$f":"IF($D$65=1,300+1,600+1)","v":601},"m3以上",null,null,35,{"$f":"IF(D69=\"あり\",IF($D$67>Q69,($D$67-Q69)*U70,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,"+"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"消費税 \"&DBCS(TEXT(date!$G$17*100,0))&\"％(F)\"","v":"消費税 １０％(F)"},{"$f":"ROUNDDOWN(K70*date!G17,0)","v":1800}]
[null,null,null,null,null,null,null,null,null,"↓"]
[null,null,null,null,null,null,null,null,"税込合計(E+F)",null,{"$f":"SUM(K70,K72)","v":19800},"G"]
[]
[]
[null,"上下水道料金合計(D+G)",null,null,null,null,{"$f":"SUM(K65,K74)","v":34980}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"水道料金"]
[null,"【特殊用】"]
[]
[null,null,null,null,null,null,null,null,null,"準備料金(A)",{"$f":"(VLOOKUP(D89,準備料金,2,0))*D91","v":1120}]
[null,null,"（入力値）",null,null,null,null,null,null,"+",null,null,null,null,"水量料金内訳",null,"使用水量",null,null,null,"単価","金額"]
[null,null,null,null,null,null,null,null,null,"水量料金(B)",{"$f":"SUM(V88:V89)","v":0},null,"⇒",null,null,null,{"$f":"D91*10","v":10},"m3まで",null,null,290,{"$f":"IF(D93<Q89,D93*U88,Q88*U88)","v":0}]
[null,"口径",null,20,"mm",null,null,null,null,"+",null,null,null,null,null,null,{"$f":"(D91*10)+1","v":11},"m3以上",null,null,440,{"$f":"IF(D93>Q88,(D93-Q88)*U89,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"消費税 \"&DBCS(TEXT(date!$G$17*100,0))&\"％(C)\"","v":"消費税 １０％(C)"},{"$f":"ROUNDDOWN(SUM(K86,K88)*date!G17,0)","v":112}]
[null,"使用月数",null,1,"ヵ月",null,null,null,null,"↓"]
[null,null,null,null,null,null,null,null,"税込合計(A+B+C)",null,{"$f":"SUM(K86,K88,K90)","v":1232},"D"]
[null,"使用水量",null,0,"m3"]
[]
[null,"下水道接続",null,"あり",null,null,null,null,"下水道使用料"]
[null,null,null,null,null,null,null,null,null,null,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":"D91*5","v":5},"m3まで",null,null,{"$f":"D91*640","v":640},{"$f":"IF(D95=\"あり\",IF($D$93<Q98,U97,U97),0)","v":640}]
[null,null,null,null,null,null,null,null,null,"下水道使用料(E)",{"$f":"SUM(V97:V106)","v":640},null,"⇒",null,null,null,{"$f":"($D$91*5)+1","v":6},"～",{"$f":"$D$91*10","v":10},"m3",70,{"$f":"IF(D95=\"あり\",IF($D$93<Q99,IF($D$93<Q97,0,($D$93-Q97)*U98),(S98-Q97)*U98),0)","v":0}]
[null,null,null,null,null,null,null,null,null,"+",null,null,null,null,null,null,{"$f":"($D$91*10)+1","v":11},"～",{"$f":"$D$91*15","v":15},"m3",95,{"$f":"IF(D95=\"あり\",IF($D$93<Q100,IF($D$93<Q99,0,($D$93-S98)*U99),(S99-S98)*U99),0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"消費税 \"&DBCS(TEXT(date!$G$17*100,0))&\"％(F)\"","v":"消費税 １０％(F)"},{"$f":"ROUNDDOWN(K98*date!G17,0)","v":64},null,null,null,null,null,{"$f":"($D$91*15)+1","v":16},"～",{"$f":"$D$91*30","v":30},"m3",110,{"$f":"IF(D95=\"あり\",IF($D$93<Q101,IF($D$93<Q100,0,($D$93-S99)*U100),(S100-S99)*U100),0)","v":0}]
[null,null,null,null,null,null,null,null,null,"↓",null,null,null,null,null,null,{"$f":"($D$91*30)+1","v":31},"～",{"$f":"$D$91*100","v":100},"m3",150,{"$f":"IF(D95=\"あり\",IF($D$93<Q102,IF($D$93<Q101,0,($D$93-S100)*U101),(S101-S100)*U101),0)","v":0}]
[null,null,null,null,null,null,null,null,"税込合計(E+F)",null,{"$f":"SUM(K98,K100)","v":704},"G",null,null,null,null,{"$f":"($D$91*100)+1","v":101},"～",{"$f":"$D$91*500","v":500},"m3",160,{"$f":"IF(D95=\"あり\",IF($D$93<Q103,IF($D$93<Q102,0,($D$93-S101)*U102),(S102-S101)*U102),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($D$91*500)+1","v":501},"～",{"$f":"$D$91*1000","v":1000},"m3",170,{"$f":"IF(D95=\"あり\",IF($D$93<Q104,IF($D$93<Q103,0,($D$93-S102)*U103),(S103-S102)*U103),0)","v":0}]
[null,"上下水道料金合計(D+G)",null,null,null,null,{"$f":"K92+K102","v":1936},null,null,null,null,null,null,null,null,null,{"$f":"($D$91*1000)+1","v":1001},"～",{"$f":"$D$91*5000","v":5000},"m3",180,{"$f":"IF(D95=\"あり\",IF($D$93<Q105,IF($D$93<Q104,0,($D$93-S103)*U104),(S104-S103)*U104),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($D$91*5000)+1","v":5001},"～",{"$f":"$D$91*10000","v":10000},"m3",195,{"$f":"IF(D95=\"あり\",IF($D$93<Q106,IF($D$93<Q105,0,($D$93-S104)*U105),(S105-S104)*U105),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"($D$91*10000)+1","v":10001},"m3以上",null,null,200,{"$f":"IF($D$93>S105,(D93-S105)*U106,0)","v":0}]

{"sheet":"市納金一覧","index":2,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,9,2,9],[1,10,1,11],[5,9,6,11],[7,9,8,11],[31,1,39,1],[9,9,10,11],[14,1,14,6],[20,1,30,1],[20,2,21,2],[20,3,21,3],[20,4,20,11],[13,1,13,6],[0,1,0,4],[1,1,2,1],[1,2,1,3],[1,4,2,4],[1,5,2,5]]}
[null,"（新設分分岐プール額）（消費税を含む）",null,null,null,null,null,null,"　　工事検査手数料　（非課税）"]
[null,"口径","基本額",null,"本復旧軽減\n（舗装道のみ　\n下段は自己都合の場合）","先行分岐",null,null,null,"給水管の呼び径","給水装置工事又は私・共有管布設工事"]
[null,null,"舗装道","砂利道",null,null,null,null,null,null,"新設、全改造","増設その他"]
[null,"13mm",{"$f":"date!E16","v":407000.00000000006},{"$f":"date!E4","v":242000.00000000003},null,null,null,null,null,"全ての口径",{"$f":"date!E41","v":19300},{"$f":"date!E42","v":4300}]
[null,"20mm",{"$f":"date!E17","v":407000.00000000006},{"$f":"date!E5","v":242000.00000000003},{"$f":"date!E35","v":-81400},null,null,null,null,"（適用）"]
[null,"25mm",{"$f":"date!E18","v":466400.00000000006},{"$f":"date!E6","v":297000},{"$f":"date!G35","v":-40700},null,null,null,null,"⑴　給水装置工事の中で、内部工事を伴わない先行分岐等の工事検査手数料は、増設の基準を適用する。"]
[null,"40mm",{"$f":"date!E19","v":1311200},{"$f":"date!E7","v":751300.00000000012}]
[null,"50mm",{"$f":"date!E20","v":4250400},{"$f":"date!E8","v":2898500.0000000005},null,{"$f":"date!G21","v":5500},null,null,null,"⑵　本表の工事検査手数料は、１件１工事２ｍ未満の私、共有管及び修繕等の工事には適用しない。"]
[null,"75mm",{"$f":"date!E21","v":5909200.0000000009},{"$f":"date!E9","v":4250400},{"$f":"date!E36","v":-126500}]
[null,"100mm",{"$f":"date!E22","v":6191900.0000000009},{"$f":"date!E10","v":4616700},{"$f":"date!G36","v":-63250},null,null,null,null,"⑶　再検査を必要とする場合については、再度、同額の手数料を徴収する。"]
[null,"150mm",{"$f":"date!E23","v":8549200},{"$f":"date!E11","v":6372300.0000000009}]
[null,"200mm",{"$f":"date!E24","v":17317300},{"$f":"date!E12","v":12929400.000000002}]
[null,"※　夜間工事を要する分岐プール額は35％増し（夜間工事での舗装本復旧軽減額も35％増し）"]
[null,"※　自己都合による舗装本復旧の軽減額は他の軽減事由の1/2となります。"]
[null,"（撤去分分岐プール額）（全口径同一　消費税を含む）　1装置につき"]
[null,null,"舗装道","砂利道","　　※　公道又は公道とみなされる場所で実撤去工事が施工されるとき"]
[null,"昼間",{"$f":"date!F47","v":192500},{"$f":"date!E47","v":110000},"　　※　舗装道での撤去は市で舗装本復旧を施工します。"]
[null,"夜間",{"$f":"date!F48","v":259875},{"$f":"date!E48","v":148500}]
[]
[null,"（加入金）（消費税を含む）"]
[null,"一般（甲新設）","口径","基本額","元口径"]
[null,null,null,null,"13mm","20mm","25mm","40mm","50mm","75mm","100mm","150mm"]
[null,null,"13mm",{"$f":"date!K5","v":66000}]
[null,null,"20mm",{"$f":"date!K6","v":115500},{"$f":"D24-$D$23","v":49500}]
[null,null,"25mm",{"$f":"date!K7","v":198000},{"$f":"D25-$D$23","v":132000},{"$f":"D25-$D$24","v":82500}]
[null,null,"40mm",{"$f":"date!K8","v":825000},759000,709500,{"$f":"D26-$D$25","v":627000}]
[null,null,"50mm",{"$f":"date!K9","v":2475000},2409000,2359500,2277000,{"$f":"D27-$D$26","v":1650000}]
[null,null,"75mm",{"$f":"date!K10","v":4950000},4884000,4834500,4752000,{"$f":"D28-$D$26","v":4125000},{"$f":"D28-$D$27","v":2475000}]
[null,null,"100mm",{"$f":"date!K11","v":9900000},9834000,9784500,9702000,{"$f":"D29-$D$26","v":9075000},{"$f":"D29-$D$27","v":7425000},{"$f":"D29-$D$28","v":4950000}]
[null,null,"150mm",{"$f":"date!K12","v":19800000},19734000,19684500,19602000,{"$f":"D30-$D$26","v":18975000},{"$f":"D30-$D$27","v":17325000},{"$f":"D30-$D$28","v":14850000},{"$f":"D30-$D$29","v":9900000}]
[null,null,"200mm",{"$f":"date!K13","v":39600000},39534000,39484500,39402000,{"$f":"D31-$D$26","v":38775000},{"$f":"D31-$D$27","v":37125000},{"$f":"D31-$D$28","v":34650000},{"$f":"D31-$D$29","v":29700000},{"$f":"D31-D30","v":19800000}]
[null,"生産用（乙新設）","13mm",{"$f":"date!M5","v":176000}]
[null,null,"20mm",{"$f":"date!M6","v":308000},{"$f":"D33-$D$32","v":132000}]
[null,null,"25mm",{"$f":"date!M7","v":528000},352000,{"$f":"D34-$D$33","v":220000}]
[null,null,"40mm",{"$f":"date!M8","v":2200000},2024000,{"$f":"D35-$D$33","v":1892000},{"$f":"D35-$D$34","v":1672000}]
[null,null,"50mm",{"$f":"date!M9","v":6600000},6424000,6292000,6072000,{"$f":"D36-$D$35","v":4400000}]
[null,null,"75mm",{"$f":"date!M10","v":13200000},13024000,12892000,12672000,{"$f":"D37-$D$35","v":11000000},{"$f":"D37-$D$36","v":6600000}]
[null,null,"100mm",{"$f":"date!M11","v":26400000},26224000,26092000,25872000,{"$f":"D38-$D$35","v":24200000},{"$f":"D38-$D$36","v":19800000},{"$f":"D38-$D$37","v":13200000}]
[null,null,"150mm",{"$f":"date!M12","v":52800000},52624000,52492000,52272000,{"$f":"D39-$D$35","v":50600000},{"$f":"D39-$D$36","v":46200000},{"$f":"D39-$D$37","v":39600000},{"$f":"D39-$D$38","v":26400000}]
[null,null,"200mm",{"$f":"date!M13","v":105600000},105424000,105292000,105072000,{"$f":"D40-$D$35","v":103400000},{"$f":"D40-$D$36","v":99000000},{"$f":"D40-$D$37","v":92400000},{"$f":"D40-$D$38","v":79200000},{"$f":"D40-D39","v":52800000}]

{"sheet":"date","index":3,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":true,"merged":[[2,11,2,12],[1,3,1,4],[13,3,13,4],[1,9,1,12],[32,3,32,5],[44,3,44,5],[39,3,39,4],[1,6,1,7],[6,6,6,7],[2,9,2,10],[32,6,32,7]]}
[]
[null,"口径1",null,"新設分分岐プール額",null,null,"口径変更（砂利道）",null,null,"加入金"]
[null,"なし",null,"口径","砂利道",null,"あり",0,null,"甲",null,"乙"]
[null,13,null,13,242000.00000000003,null,"なし",0,null,"なし",0,"なし",0]
[null,20,null,20,242000.00000000003,null,null,null,null,13,66000,13,176000]
[null,25,null,25,297000,null,null,null,null,20,115500,20,308000]
[null,30,null,40,751300.00000000012,null,"口径変更（舗装道）",null,null,25,198000,25,528000]
[null,40,null,50,2898500.0000000005,null,"あり",0,null,40,825000,40,2200000]
[null,50,null,75,4250400,null,"なし",0,null,50,2475000,50,6600000]
[null,75,null,100,4616700,null,null,null,null,75,4950000,75,13200000]
[null,100,null,150,6372300.0000000009,null,"口径3",null,null,100,9900000,100,26400000]
[null,150,null,200,12929400.000000002,null,"40以下",null,null,150,19800000,150,52800000]
[null,null,null,null,null,null,"50以上",null,null,200,39600000,200,105600000]
[null,null,null,"新設分分岐プール額"]
[null,"口径2",null,"口径","舗装道"]
[null,13,null,13,407000.00000000006,null,"消費税",null,null,"準備料金1"]
[null,20,null,20,407000.00000000006,null,0.1,null,null,"口径","単価"]
[null,25,null,25,466400.00000000006,null,null,null,null,13,1010]
[null,40,null,40,1311200,null,null,null,null,20,1120]
[null,50,null,50,4250400,null,"先行分岐",null,null,25,2400]
[null,75,null,75,5909200.0000000009,null,5500,null,null,30,4300]
[null,100,null,100,6191900.0000000009,null,null,null,null,40,11000]
[null,150,null,150,8549200,null,null,null,null,50,50000]
[null,200,null,200,17317300,null,null,null,null,75,115000]
[null,null,null,null,null,null,null,null,null,100,250000]
[null,null,null,null,null,null,null,null,null,150,500000]
[]
[null,"道路形態",null,"舗装道",null,"砂利道"]
[null,"砂利道",null,"あり",null,"なし"]
[null,"舗装道",null,"自己都合",null,null,null,null,null,"準備料金2"]
[null,null,null,"なし",null,null,null,null,null,"口径","単価"]
[null,null,null,null,null,null,null,null,null,"40以下",6900]
[null,"撤去口径",null,"本復旧軽減（舗装道のみ）",null,null,"自己都合での軽減",null,null,"50以上",30000]
[null,"なし",null,"分岐口径","単価（昼間）","単価（夜間）","単価（昼間）","単価（夜間）"]
[null,13,null,"13～40",-81400,-109890,{"$f":"E35/2","v":-40700},{"$f":"F35/2","v":-54945}]
[null,20,null,"50以上",-126500,-170775,{"$f":"E36/2","v":-63250},{"$f":"ROUNDUP(F36/2,0)","v":-85388}]
[null,25]
[null,40]
[null,50]
[null,75,null,"検査手数料"]
[null,100,null,"新設・建て替え",19300]
[null,150,null,"増設・先行分岐",4300]
[null,200]
[]
[null,null,null,"撤去分分岐プール額（全口径同一）"]
[null,null,null,"昼/夜別","砂利道","舗装道"]
[null,null,null,"昼間",110000,192500]
[null,null,null,"夜間",148500,259875]