{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["(R3.10-)水道料金計算表","date"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":18,"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":"(R3.10-)水道料金計算表","index":0,"n_rows":106,"n_cols":22,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,0,0,22],[1,8,2,9],[2,1,3,3],[3,14,8,14],[3,16,3,18],[4,17,4,18],[5,2,5,4],[6,12,6,13],[10,8,10,9],[12,8,13,9],[13,14,21,14],[13,15,20,15],[13,16,13,18],[14,17,14,18],[15,12,15,13],[23,17,23,18],[28,8,29,9],[29,1,30,3],[30,14,35,14],[30,16,30,19],[31,17,31,18],[33,2,33,5],[33,12,33,13],[37,8,37,9],[39,8,40,9],[19,1,19,2],[19,8,19,9],[22,1,23,5],[22,6,23,9],[40,16,40,18],[41,17,41,18],[42,8,42,9],[42,12,42,13],[44,12,44,13],[40,14,48,14],[40,15,47,15],[46,8,46,9],[59,14,63,14],[59,16,59,18],[60,2,60,4],[60,12,60,13],[60,17,60,18],[49,1,50,5],[49,6,50,9],[50,17,50,18],[55,8,56,9],[56,1,57,3],[67,16,67,18],[68,17,68,18],[69,8,69,9],[69,12,69,13],[69,17,69,18],[76,1,77,5],[76,6,77,9],[82,8,83,9],[83,1,84,3],[86,14,90,14],[64,8,64,9],[66,8,67,9],[67,14,72,14],[67,15,70,15],[73,8,73,9],[86,16,86,18],[87,12,87,13],[87,17,87,18],[88,17,88,18],[103,1,104,5],[103,6,104,9],[86,2,86,4],[86,15,89,15],[105,17,105,18],[91,8,91,9],[94,8,95,9],[95,14,103,14],[95,15,102,15],[95,16,95,18],[96,17,96,18],[97,12,97,13],[101,8,101,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,60,{"$f":"IF(D12<Q6,D12*U5,Q5*U5)","v":1200}]
[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",110,{"$f":"IF($D$12<Q7,IF($D$12<Q5,0,($D$12-Q5)*U6),(S6-Q5)*U6)","v":2200}]
[null,null,null,null,null,null,null,null,null,"水量料金(B)",{"$f":"SUM(V5:V11)","v":3400},null,"⇒",null,null,null,{"$f":"IF($D$10=1,21,41)","v":41},"～",{"$f":"IF($D$10=1,30,60)","v":60},"m3",205,{"$f":"IF($D$12<Q8,IF($D$12<Q7,0,($D$12-S6)*U7),(S7-S6)*U7)","v":0}]
[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",215,{"$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":564},null,null,null,null,null,{"$f":"IF($D$10=1,101,201)","v":201},"～",{"$f":"IF($D$10=1,3000,6000)","v":6000},"m3",230,{"$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",240,{"$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":6204},"D",null,null,null,null,{"$f":"IF($D$10=1,10001,20001)","v":20001},"m3以上",null,null,190,{"$f":"IF($D$12>S10,(D12-S10)*U11,0)","v":0}]
[null,"使用水量",null,40,"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,765,1530)","v":1530},{"$f":"IF(D15=\"あり\",U15,0)","v":1530}]
[null,null,null,null,null,null,null,null,null,"下水道使用料(E)",{"$f":"SUM(V15:V24)","v":4830},null,"⇒",null,null,null,{"$f":"IF($D$10=1,6,11)","v":11},"～",{"$f":"IF($D$10=1,10,20)","v":20},"m3",85,{"$f":"IF(D15=\"あり\",IF($D$12<Q17,IF($D$12<Q15,0,($D$12-Q15)*U16),(S16-Q15)*U16),0)","v":850}]
[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",115,{"$f":"IF(D15=\"あり\",IF($D$12<Q18,IF($D$12<Q17,0,($D$12-S16)*U17),(S17-S16)*U17),0)","v":1150}]
[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":483},null,null,null,null,null,{"$f":"IF($D$10=1,16,31)","v":31},"～",{"$f":"IF($D$10=1,30,60)","v":60},"m3",130,{"$f":"IF(D15=\"あり\",IF($D$12<Q19,IF($D$12<Q18,0,($D$12-S17)*U18),(S18-S17)*U18),0)","v":1300}]
[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",180,{"$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":5313},"G",null,null,null,null,{"$f":"IF($D$10=1,101,201)","v":201},"～",{"$f":"IF($D$10=1,500,1000)","v":1000},"m3",190,{"$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",205,{"$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",215,{"$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":11517},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",235,{"$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,240,{"$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":2040},null,null,null,null,null,{"$f":"IF(D42=1,10*E40,20*E40)","v":20},"m3まで",null,null,60,{"$f":"IF($D$44<Q33,(D44*U32),Q32*U32)","v":1200}]
[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":21},"～",{"$f":"IF(D42=1,20*E40,40*E40)","v":40},"m3",110,{"$f":"IF($D$44<Q34,IF($D$44<Q33,0,(D44-Q32)*U33),(S33-Q32)*U33)","v":0}]
[null,null,"（入力値）",null,null,null,null,null,null,"水量料金(B)",{"$f":"SUM(V32:V38)","v":1200},null,"⇒",null,null,null,{"$f":"IF($D$42=1,(20*$E$40)+1,(40*$E$40)+1)","v":41},"～",{"$f":"IF(D42=1,30*E40,60*E40)","v":60},"m3",205,{"$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":61},"～",{"$f":"IF(D42=1,100*E40,200*E40)","v":200},"m3",215,{"$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":324},null,null,null,null,null,{"$f":"IF($D$42=1,(100*$E$40)+1,(200*$E$40)+1)","v":201},"～",{"$f":"IF(D42=1,3000*E40,6000*E40)","v":6000},"m3",230,{"$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":6001},"～",{"$f":"IF(D42=1,10000*E40,20000*E40)","v":20000},"m3",240,{"$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":3564},"D",null,null,null,null,{"$f":"IF(D42=1,(10000*E40)+1,(20000*E40)+1)","v":20001},"m3以上",null,null,190,{"$f":"IF($D$44>S37,(D44-S37)*U38,0)","v":0}]
[]
[null,"装置数",null,1,{"$f":"IF(D38=\"ワンルーム\",ROUNDDOWN(D40/3.3,0),D40)","v":1},"戸",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":10},"m3まで",null,null,{"$f":"IF($D$42=1,645,1290)*E40","v":1290},{"$f":"IF(D46=\"あり\",U42,0)","v":1290}]
[null,null,null,null,null,null,null,null,"下水道使用料(E)",null,{"$f":"SUM(V42:V51)","v":2140},null,"⇒",null,null,null,{"$f":"IF($D$42=1,(5*$E$40)+1,(10*$E$40)+1)","v":11},"～",{"$f":"IF($D$42=1,(10*$E$40),(20*$E$40))","v":20},"m3",85,{"$f":"IF(D46=\"あり\",IF($D$44<Q44,IF($D$44<Q42,0,(D44-Q42)*U43),(S43-Q42)*U43),0)","v":850}]
[null,"親メータ使用水量",null,20,"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":21},"～",{"$f":"IF($D$42=1,15*$E$40,30*$E$40)","v":30},"m3",115,{"$f":"IF(D46=\"あり\",IF($D$44<Q45,IF($D$44<Q44,0,($D$44-S43)*U44),(S44-S43)*U44),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(K43*date!G17,0)","v":214},null,null,null,null,null,{"$f":"IF($D$42=1,(15*$E$40)+1,(30*$E$40)+1)","v":31},"～",{"$f":"IF($D$42=1,30*$E$40,60*$E$40)","v":60},"m3",130,{"$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":61},"～",{"$f":"IF($D$42=1,100*$E$40,200*$E$40)","v":200},"m3",180,{"$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":2354},"G",null,null,null,null,{"$f":"IF($D$42=1,(100*$E$40)+1,(200*$E$40)+1)","v":201},"～",{"$f":"IF($D$42=1,500*$E$40,1000*$E$40)","v":1000},"m3",190,{"$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":1001},"～",{"$f":"IF($D$42=1,1000*$E$40,2000*$E$40)","v":2000},"m3",205,{"$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":2001},"～",{"$f":"IF($D$42=1,5000*$E$40,10000*$E$40)","v":10000},"m3",215,{"$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":5918},null,null,null,null,null,null,null,null,null,{"$f":"IF($D$42=1,(5000*$E$40)+1,(10000*$E$40)+1)","v":10001},"～",{"$f":"IF($D$42=1,10000*$E$40,20000*$E$40)","v":20000},"m3",235,{"$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":20001},"m3以上",null,null,240,{"$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,80,{"$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,10500,21000)","v":21000},{"$f":"IF(D69=\"あり\",IF($D$67<Q69,U69,U69),0)","v":21000}]
[null,null,null,null,null,null,null,null,"下水道使用料(E)",null,{"$f":"IF(D69=\"なし\",0,SUM(V69:V70))","v":21000},null,"⇒",null,null,null,{"$f":"IF($D$65=1,300+1,600+1)","v":601},"m3以上",null,null,40,{"$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":2100}]
[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":23100},"G"]
[]
[]
[null,"上下水道料金合計(D+G)",null,null,null,null,{"$f":"SUM(K65,K74)","v":38280}]
[]
[]
[]
[]
[]
[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*765","v":765},{"$f":"IF(D95=\"あり\",IF($D$93<Q98,U97,U97),0)","v":765}]
[null,null,null,null,null,null,null,null,null,"下水道使用料(E)",{"$f":"SUM(V97:V106)","v":765},null,"⇒",null,null,null,{"$f":"($D$91*5)+1","v":6},"～",{"$f":"$D$91*10","v":10},"m3",85,{"$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",115,{"$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":76},null,null,null,null,null,{"$f":"($D$91*15)+1","v":16},"～",{"$f":"$D$91*30","v":30},"m3",130,{"$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",180,{"$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":841},"G",null,null,null,null,{"$f":"($D$91*100)+1","v":101},"～",{"$f":"$D$91*500","v":500},"m3",190,{"$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",205,{"$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":2073},null,null,null,null,null,null,null,null,null,{"$f":"($D$91*1000)+1","v":1001},"～",{"$f":"$D$91*5000","v":5000},"m3",215,{"$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",235,{"$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,240,{"$f":"IF($D$93>S105,(D93-S105)*U106,0)","v":0}]

{"sheet":"date","index":1,"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,"あり",-62700,null,"甲",null,"乙"]
[null,13,null,13,189200,null,"なし",0,null,"なし",0,"なし",0]
[null,20,null,20,189200,null,null,null,null,13,66000,13,176000]
[null,25,null,25,239800,null,null,null,null,20,115500,20,308000]
[null,30,null,40,578600,null,"口径変更（舗装道）",null,null,25,198000,25,528000]
[null,40,null,50,798600,null,"あり",-105600,null,40,825000,40,2200000]
[null,50,null,75,1647800,null,"なし",0,null,50,2475000,50,6600000]
[null,75,null,100,2016300,null,null,null,null,75,4950000,75,13200000]
[null,100,null,150,3426500,null,"口径3",null,null,100,9900000,100,26400000]
[null,150,null,200,5824500,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,316800,null,"消費税",null,null,"準備料金1"]
[null,20,null,20,316800,null,0.1,null,null,"口径","単価"]
[null,25,null,25,377300,null,null,null,null,13,1010]
[null,40,null,40,1007600,null,null,null,null,20,1120]
[null,50,null,50,1170400,null,"先行分岐",null,null,25,2400]
[null,75,null,75,2294600,null,5500,null,null,30,4300]
[null,100,null,100,2702700,null,null,null,null,40,11000]
[null,150,null,150,4593600,null,null,null,null,50,50000]
[null,200,null,200,7807800,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～25",-74800,-100980,{"$f":"E35/2","v":-37400},{"$f":"F35/2","v":-50490}]
[null,20,null,"40～75",-198000,-267300,{"$f":"E36/2","v":-99000},{"$f":"F36/2","v":-133650}]
[null,25,null,"100以上",-240900,-325215,-120450,{"$f":"F37/2","v":-162607.5}]
[null,40]
[null,50]
[null,75,null,"検査手数料"]
[null,100,null,"新設・建て替え",9600]
[null,150,null,"増設・先行分岐",2600]
[null,200]
[]
[null,null,null,"撤去分分岐プール額（全口径同一）"]
[null,null,null,"昼/夜別","砂利道","舗装道"]
[null,null,null,"昼間",44000,77000]
[null,null,null,"夜間",59400,103950]