{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["총공사비 2백(세대), 1백(공용) 이하","총공사비 2백(세대), 1백(공용) 초과"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"총공사비 2백(세대), 1백(공용) 이하","index":0,"n_rows":23,"n_cols":13,"rows_kept":23,"merged":[[0,0,0,14],[3,0,3,6],[3,8,3,14],[14,0,14,6],[14,8,14,14]]}
["(붙임2) 노후 옥내급수관 개선 지원 공사비 지원 기준"]
["※ 세대에 지원되는 지원금은 세대당 최대 2백만원(공용배관의 경우 1백만원)과 공사비의 95% 중 낮은 금액으로 지원한다.(실무지침 p.4, 10 참조)"]
["<<세대내배관 개선: 총 공사비가 2,105천원 이하인 경우>>"]
["(1) (광역: 세대내배관 개선) 총 공사비의 95%가 2,000천원 이하인 경우",{"$nulls":7},"(1) (기초: 세대내배관 개선) 총 공사비의 95%가 2,000천원 이하인 경우"]
["※ 노란색셀에 총공사비용(2,105천원보다 작은 금액)을 입력하여 부담액 계산",{"$nulls":7},"※ 노란색셀에 총공사비용(2,105천원보다 작은 금액)을 입력하여 부담액 계산"]
[null,{"v":2100000,"d":"2,100,000"},0.95,{"$f":"B6*C6","v":{"v":1995000,"d":"1,995,000"}},{"$nulls":5},{"v":2104000,"d":"2,104,000"},0.95,{"$f":"J6*K6","v":{"v":1998800,"d":"1,998,800"}}]
["구분",null,null,"부담액","부담률",{"$nulls":3},"구분",null,null,"부담액","부담률"]
["국비부담액",{"$f":"B6","v":{"v":2100000,"d":"2,100,000"}},0.3,{"$f":"B8*C8","v":{"v":630000,"d":"630,000"}},{"$f":"D8/$D$12","v":{"v":0.3,"d":"30.0%"}},{"$nulls":3},"국비부담액",{"$f":"J6","v":{"v":2104000,"d":"2,104,000"}},0.6,{"$f":"J8*K8","v":{"v":1262400,"d":"1,262,400"}},{"$f":"L8/$L$12","v":{"v":0.6,"d":"60.0%"}}]
["지방비부담액",{"$f":"B6","v":{"v":2100000,"d":"2,100,000"}},0.65,{"$f":"B9*C9","v":{"v":1365000,"d":"1,365,000"}},{"$f":"D9/$D$12","v":{"v":0.65,"d":"65.0%"}},{"$nulls":3},"지방비부담액",{"$f":"J6","v":{"v":2104000,"d":"2,104,000"}},0.35,{"$f":"J9*K9","v":{"v":736400,"d":"736,400"}},{"$f":"L9/$L$12","v":{"v":0.35,"d":"35.0%"}}]
["국비+지방비",null,null,{"$f":"SUM(D8:D9)","v":{"v":1995000,"d":"1,995,000"}},{"$nulls":4},"국비+지방비",null,null,{"$f":"SUM(L8:L9)","v":{"v":1998800,"d":"1,998,800"}}]
["자부담액",{"$f":"B6","v":{"v":2100000,"d":"2,100,000"}},0.05,{"$f":"B11*C11","v":{"v":105000,"d":"105,000"}},{"$f":"D11/$D$12","v":{"v":0.05,"d":"5.0%"}},{"$nulls":3},"자부담액",{"$f":"J6","v":{"v":2104000,"d":"2,104,000"}},0.05,{"v":105200,"d":"105,200"},{"v":0.05,"d":"5.0%"}]
["총계",null,null,{"$f":"D8+D9+D11","v":{"v":2100000,"d":"2,100,000"}},{"$f":"D12/$D$12","v":{"v":1,"d":"100.0%"}},{"$nulls":3},"총계",null,null,{"$f":"L8+L9+L11","v":{"v":2104000,"d":"2,104,000"}},{"v":1,"d":"100.0%"}]
[]
["<<공용배관 개선: 총 공사비가 1,053천원 이하인 경우>>"]
["(2) (광역: 공용배관 개선) 총 공사비의 95%가 1,000천원 이하인 경우",{"$nulls":7},"(2) (기초: 공용배관 개선) 총 공사비의 95%가 1,000천원 이하인 경우"]
["※ 노란색셀에 총 공사세대와 세대당 공사비용(1,053천원보다 작은 금액)을 입력하여 부담액 계산",{"$nulls":7},"※ 노란색셀에 총 공사세대와 세대당 공사비용(1,053천원보다 작은 금액)을 입력하여 부담액 계산"]
[{"v":1,"d":"1세대"},{"v":1052000,"d":"1,052,000"},0.95,{"$f":"A17*B17*C17","v":{"v":999400,"d":"999,400"}},{"$nulls":4},{"v":1,"d":"1세대"},{"v":1052000,"d":"1,052,000"},0.95,{"$f":"I17*J17*K17","v":{"v":999400,"d":"999,400"}}]
["구분",null,null,"부담액","부담률",{"$nulls":3},"구분",null,null,"부담액","부담률"]
["국비부담액",{"$f":"B17","v":{"v":1052000,"d":"1,052,000"}},0.3,{"$f":"A17*B19*C19","v":{"v":315600,"d":"315,600"}},{"$f":"D19/$D$23","v":{"v":0.3,"d":"30.0%"}},{"$nulls":3},"국비부담액",{"$f":"J17","v":{"v":1052000,"d":"1,052,000"}},0.6,{"$f":"I17*J19*K19","v":{"v":631200,"d":"631,200"}},{"$f":"L19/$L$23","v":{"v":0.6,"d":"60.0%"}}]
["지방비부담액",{"$f":"B17","v":{"v":1052000,"d":"1,052,000"}},0.65,{"$f":"A17*B20*C20","v":{"v":683800,"d":"683,800"}},{"$f":"D20/$D$23","v":{"v":0.65,"d":"65.0%"}},{"$nulls":3},"지방비부담액",{"$f":"J17","v":{"v":1052000,"d":"1,052,000"}},0.35,{"$f":"I17*J20*K20","v":{"v":368200,"d":"368,200"}},{"$f":"L20/$L$23","v":{"v":0.35,"d":"35.0%"}}]
["국비+지방비",null,null,{"$f":"SUM(D19:D20)","v":{"v":999400,"d":"999,400"}},{"$nulls":4},"국비+지방비",null,null,{"$f":"SUM(L19:L20)","v":{"v":999400,"d":"999,400"}}]
["자부담액",{"$f":"B17","v":{"v":1052000,"d":"1,052,000"}},0.05,{"$f":"A17*B22*C22","v":{"v":52600,"d":"52,600"}},{"v":0.05,"d":"5.0%"},{"$nulls":3},"자부담액",{"$f":"J17","v":{"v":1052000,"d":"1,052,000"}},0.05,{"$f":"I17*J22*K22","v":{"v":52600,"d":"52,600"}},{"v":0.05,"d":"5.0%"}]
["총계",null,null,{"$f":"D19+D20+D22","v":{"v":1052000,"d":"1,052,000"}},{"v":1,"d":"100.0%"},{"$nulls":3},"총계",null,null,{"$f":"L19+L20+L22","v":{"v":1052000,"d":"1,052,000"}},{"v":1,"d":"100.0%"}]

{"sheet":"총공사비 2백(세대), 1백(공용) 초과","index":1,"n_rows":26,"n_cols":13,"rows_kept":26,"merged":[[0,0,0,14],[3,0,3,6],[3,8,3,14],[10,0,12,0],[10,8,12,8],[16,0,16,6],[16,8,16,14],[23,0,24,0],[23,8,24,8]]}
["(붙임2) 노후 옥내급수관 개선 지원 공사비 지원 기준"]
["※ 세대에 지원되는 지원금은 세대당 최대 2백만원(공용배관의 경우 1백만원)과 공사비의 95% 중 낮은 금액으로 지원한다.(실무지침 p.4, 10 참조)"]
["<<세대내배관 개선: 총 공사비가 2,105천원을 초과하는 경우>>"]
["(1) (광역: 세대내배관 개선) 총 공사비의 95%가 2,000천원 초과하는 경우",{"$nulls":7},"(1) (기초: 세대내배관 개선) 총 공사비의 95%가 2,000천원 초과하는 경우"]
["※ 노란색셀에 총공사비용(2,105천원보다 큰 금액)을 입력하여 부담액 계산",{"$nulls":7},"※ 노란색셀에 총공사비용(2,105천원보다 큰 금액)을 입력하여 부담액 계산"]
[null,{"v":2106000,"d":"2,106,000"},0.95,{"$f":"B6*C6","v":{"v":2000700,"d":"2,000,700"}},{"$nulls":5},{"v":2106000,"d":"2,106,000"},0.95,{"$f":"J6*K6","v":{"v":2000700,"d":"2,000,700"}}]
["구분",null,null,"부담액","부담률",{"$nulls":3},"구분",null,null,"부담액","부담률"]
["국비부담액",null,null,{"$f":"2000000*30/95","v":{"v":631578.947368421,"d":"631,579"}},{"$f":"D8/$D$14","v":{"v":0.29989503673714196,"d":"30.0%"}},{"$nulls":3},"국비부담액",null,null,{"$f":"2000000*60/95","v":{"v":1263157.894736842,"d":"1,263,158"}},{"$f":"L8/$L$14","v":{"v":0.5997900734742839,"d":"60.0%"}}]
["지방비부담액",null,null,{"$f":"2000000*65/95","v":{"v":1368421.0526315789,"d":"1,368,421"}},{"$f":"D9/$D$14","v":{"v":0.649772579597141,"d":"65.0%"}},{"$nulls":3},"지방비부담액",null,null,{"$f":"2000000*35/95","v":{"v":736842.1052631579,"d":"736,842"}},{"$f":"L9/$L$14","v":{"v":0.349877542859999,"d":"35.0%"}}]
["국비+지방비",null,null,{"$f":"SUM(D8:D9)","v":{"v":2000000,"d":"2,000,000"}},{"$nulls":4},"국비+지방비",null,null,{"$f":"SUM(L8:L9)","v":{"v":2000000,"d":"2,000,000"}}]
["자부담액",{"$f":"B6","v":{"v":2106000,"d":"2,106,000"}},0.05,{"$f":"B11*C11","v":{"v":105300,"d":"105,300"}},{"$nulls":4},"자부담액",{"$f":"J6","v":{"v":2106000,"d":"2,106,000"}},0.05,{"$f":"J11*K11","v":{"v":105300,"d":"105,300"}}]
[null,{"$f":"B11","v":{"v":2106000,"d":"2,106,000"}},0.95,{"$f":"B12*C12-2000000","v":700},{"$nulls":5},{"$f":"J11","v":{"v":2106000,"d":"2,106,000"}},0.95,{"$f":"J12*K12-2000000","v":700}]
[{"$nulls":3},{"$f":"SUM(D11:D12)","v":{"v":106000,"d":"106,000"}},{"$f":"D13/$D$14","v":{"v":0.050332383665717,"d":"5.0%"}},{"$nulls":6},{"$f":"SUM(L11:L12)","v":{"v":106000,"d":"106,000"}},{"$f":"L13/$L$14","v":{"v":0.050332383665717,"d":"5.0%"}}]
["총계",null,null,{"$f":"D8+D9+D13","v":{"v":2106000,"d":"2,106,000"}},{"$f":"D14/$D$14","v":{"v":1,"d":"100.0%"}},{"$nulls":3},"총계",null,null,{"$f":"L8+L9+L13","v":{"v":2106000,"d":"2,106,000"}},{"$f":"L14/$L$14","v":{"v":1,"d":"100.0%"}}]
[]
["<<공용배관 개선: 총 공사비가 1,053천원을 초과하는 경우>>"]
["(2) (광역: 공용배관 개선) 총 공사비의 95%가 1,000천원 초과하는 경우",{"$nulls":7},"(2) (기초: 공용배관 개선) 총 공사비의 95%가 1,000천원 초과하는 경우"]
["※ 노란색셀에 총 공사세대와 세대당 공사비용(1,053천원보다 큰 금액)을 입력하여 부담액 계산",{"$nulls":7},"※ 노란색셀에 총 공사세대와 세대당 공사비용(1,053천원보다 큰 금액)을 입력하여 부담액 계산"]
[{"v":1,"d":"1세대"},{"v":1055000,"d":"1,055,000"},0.95,{"$f":"A19*B19*C19","v":{"v":1002250,"d":"1,002,250"}},{"$nulls":4},{"v":1,"d":"1세대"},{"v":1055000,"d":"1,055,000"},0.95,{"$f":"I19*J19*K19","v":{"v":1002250,"d":"1,002,250"}}]
["구분",null,null,"부담액","부담률",{"$nulls":3},"구분",null,null,"부담액","부담률"]
["국비부담액",null,null,{"$f":"A19*(1000000*30/95)","v":{"v":315789.4736842105,"d":"315,789"}},{"$f":"D21/$D$26","v":{"v":0.2993265153404839,"d":"29.9%"}},{"$nulls":3},"국비부담액",null,null,{"$f":"I19*(1000000*60/95)","v":{"v":631578.947368421,"d":"631,579"}},{"$f":"L21/$L$26","v":{"v":0.5986530306809678,"d":"59.9%"}}]
["지방비부담액",null,null,{"$f":"A19*(1000000*65/95)","v":{"v":684210.5263157894,"d":"684,211"}},{"$f":"D22/$D$26","v":{"v":0.6485407832377151,"d":"64.9%"}},{"$nulls":3},"지방비부담액",null,null,{"$f":"I19*(1000000*35/95)","v":{"v":368421.05263157893,"d":"368,421"}},{"$f":"L22/$L$26","v":{"v":0.3492142678972312,"d":"34.9%"}}]
["국비+지방비",null,null,{"$f":"SUM(D21:D22)","v":{"v":1000000,"d":"1,000,000"}},{"$nulls":4},"국비+지방비",null,null,{"$f":"SUM(L21:L22)","v":{"v":1000000,"d":"1,000,000"}}]
["자부담액",{"v":1000000,"d":"1,000,000"},null,{"$f":"(A19*B19)-(A19*B24)","v":{"v":55000,"d":"55,000"}},{"$nulls":4},"자부담액",{"v":1000000,"d":"1,000,000"},null,{"$f":"(I19*J19)-(I19*J24)","v":{"v":55000,"d":"55,000"}}]
[{"$nulls":3},{"$f":"SUM(D24:D24)","v":{"v":55000,"d":"55,000"}},{"$f":"D25/$D$26","v":{"v":0.052132701421800945,"d":"5.2%"}},{"$nulls":6},{"$f":"SUM(L24:L24)","v":{"v":55000,"d":"55,000"}},{"$f":"L25/$L$26","v":{"v":0.052132701421800945,"d":"5.2%"}}]
["총계",null,null,{"$f":"D21+D22+D25","v":{"v":1055000,"d":"1,055,000"}},{"$f":"D26/$D$26","v":{"v":1,"d":"100.0%"}},{"$nulls":3},"총계",null,null,{"$f":"L21+L22+L25","v":{"v":1055000,"d":"1,055,000"}},{"$f":"L26/$L$26","v":{"v":1,"d":"100.0%"}}]