{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["한전불입금"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":73,"n_cols":31,"rows_kept":73,"cut":false,"hidden":false,"merged":[[64,4,64,8],[65,4,65,8],[66,4,66,8],[52,4,52,8],[55,4,55,8],[60,4,60,8],[58,3,61,3],[58,4,58,8],[59,4,59,8],[61,4,61,8],[62,4,62,8],[44,17,45,17],[49,4,50,8],[54,3,57,3],[54,4,54,8],[56,4,56,8],[57,4,57,8],[51,4,51,8],[38,4,38,8],[39,4,39,8],[40,3,42,3],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,3,50,3],[43,4,43,8],[44,4,48,8],[24,4,24,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[32,3,37,3],[32,4,32,8],[33,4,33,8],[34,4,34,8],[35,4,35,8],[36,4,36,8],[37,4,37,8],[28,3,31,3],[28,4,28,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[13,4,13,8],[15,3,17,3],[15,4,17,8],[15,17,23,23],[18,3,19,3],[18,4,19,8],[20,4,20,8],[22,3,23,3],[22,4,23,8],[7,3,9,3],[7,4,7,8],[7,17,12,22],[8,4,8,8],[9,4,9,8],[10,3,12,3],[10,4,10,8],[11,4,11,8],[12,4,12,8],[5,4,5,8],[1,1,1,14],[2,1,2,9],[3,10,3,11],[4,1,4,9],[4,14,4,15]]}
[]
[null,"한전불입금",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"수전용량","발전기용량 KW","태양광","저압가공","저압지중","고압가공","고압지중","구자"]
[null,{"$f":"\"[공사명] \"&#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,"2018년",null,null,null,0,0,null,null,null,"1",null,1]
[null,null,"  ▪ 수전전압:",null,{"$f":"IF(($X$3+$Y$3)>=1,\"22,900[V]\",IF(($V$3+$W$3)>=1,\"600[V]\",IF(($V$3+$W$3+$X$3+$Y$3)=0,0)))","v":"22,900[V]"},null,"▪ 수전용량:",null,{"$f":"$S$3&\"[KW] \"","v":"0[KW] "},{"$f":"IF(Z3=1,0,IF(Z3=2,$Z$3&\"[구좌수전]\"))","v":0},"  ▪ 발전기용량:",null,{"$f":"$T$3&\"[KW]\"","v":"0[KW]"},null,null,null,null,null,"* 거리공사비 및 첨가거리 공사는 직접 입력해야함",null,null,null,null,null,null,"발전기단독",null,null,{"$f":"IF(OR(AND((X3+Y3)>=1,S3>300)),\"1\",\"0\")","v":"0"},{"$f":"IF(OR(AND((X3+Y3)>=1,S3<=300)),\"1\",\"0\")","v":"1"},{"$f":"IF(($T$3>10000),1,IF(($T$3<=10000),0))","v":0}]
[null,"  구               분",null,null,null,null,null,null,null,null,"기본금액","단위","수량","합  계","비 고",null,null,null,"* 구자는 1구자 기준임 2구자시 숫자1을 2로 변경해야함",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND((X3+Y3)>=1,S3<1000)),\"1\",\"0\")","v":"1"},{"$f":"IF(OR(AND((X3+Y3)>=1,S3=0)),\"1\",\"0\")","v":"1"},{"$f":"IF(($T$3>50000),1,IF(($T$3<=50000),0))","v":0}]
[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,{"$f":"IF(($X$3+$Y$3)>=1,(IF(($S$3<300),0,IF(($S$3>300),$S$3,IF(($S$3<1000),0)))),IF(($X$3+$Y$3)<1,0))","v":0},{"$f":"IF(($X$3+$Y$3)>=1,(IF(($S$3>1000),$S$3-1000,IF(($S$3<100000),0))),IF(($X$3+$Y$3)<1,0))","v":0},{"$f":"IF(($T$3>50000),1,IF(($T$3<=50000),0))","v":0}]
[null,null,"1) 기본공사비 (부가가치세 불포함)",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,{"$f":"IF(($X$3+$Y$3)>=1,(IF(($S$3>=1000),1000,IF(($S$3<100000),0))),IF(($X$3+$Y$3)<1,0))","v":0},null,{"$f":"IF(($T$3>100000),1,IF(($T$3<=100000),0))","v":0}]
[null,null,null,"가공공급","매 1계약에 대하여 계약전력 5kW까지",null,null,null,null,"저압",220000,"건당",{"$f":"IF(ISTEXT($V$3),INT(1),IF(ISBLANK($V$3),0))","v":0},{"$f":"K8*M8","v":0},null,null,null,"* 저입인입 경우 기본 5kW 제외하고 적용.\n * 예) 신청용량 30kW 경우 25kW만 적용.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($T$3>50000),1,IF(($T$3<=50000),0))","v":0}]
[null,null,null,null,"계약전력 5kW 초과분의 매 1kW에 대하여",null,null,null,null,"저압",86000,"kW",{"$f":"IF(ISTEXT($V$3),INT($S$3-5),IF(ISBLANK($V$3),0))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($T$3<=300),0,IF($T$3>300,1))","v":0},{"$f":"IF(($T$3>500),1,IF(($T$3<=500),0))","v":0},{"$f":"IF(($T$3>100000),1,IF(($T$3<=100000),0))","v":0}]
[null,null,null,null,"신증설 계약전력 매 1kW에 대하여",null,null,null,null,"고압 또는 특별고압",17000,"kW",{"$f":"(IF(ISTEXT($X$3),INT($S$3),IF(ISBLANK($X$3),0)))*Z3","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($T$3<=50000),1,IF($T$3>50000,0))","v":1},{"$f":"IF(($T$3>1000),1,IF(($T$3<=1000),0))","v":0},{"$f":"IF(($U$3>20),1,IF(($U$3<=20),0))","v":0}]
[null,null,null,"지중공급","매 1계약에 대하여 계약전력 5kW까지",null,null,null,null,"저압",421000,"건당",{"$f":"IF(ISTEXT($W$3),INT(1),IF(ISBLANK($W$3),0))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($T$3>1000),1,IF(($T$3<=1000),0))","v":0},{"$f":"IF(($T$3>5000),1,IF(($T$3<=5000),0))","v":0},{"$f":"IF(($U$3>100),1,IF(($U$3<=100),0))","v":0}]
[null,null,null,null,"계약전력 5kW 초과분의 매 1kW에 대하여",null,null,null,null,"저압",98000,"kW",{"$f":"(IF(ISTEXT($W$3),INT($S$3-5),IF(ISBLANK($W$3),0)))*Z3","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($T$3>5000),1,IF(($T$3<=5000),0))","v":0},{"$f":"IF(($T$3>10000),1,IF(($T$3<=10000),0))","v":0},{"$f":"IF(($U$3>100),1,IF(($U$3<=100),0))","v":0}]
[null,null,null,null,"신증설 계약전력 매 1kW에 대하여",null,null,null,null,"고압 또는 특별고압",35000,"kW",{"$f":"(IF(ISTEXT($Y$3),INT($S$3),IF(ISBLANK($Y$3),0)))*Z3","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"IF(($U$3>100),1,IF(($U$3<=100),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"소계",null,{"$f":"SUM(N8:N13)","v":0},null,null,null,"* 표를 사용하여 금액산정 하더라도 한전 및 안전공사에 재확인할것",null,null,null,null,null,null,null,null,null,null,{"$f":"Z5+AC13","v":1}]
[null,null,"2) 거리공사비 (부가가치세 불포함)"]
[null,null,null,"가공공급","기본거리를 초과하는 신설                      거리 매 1m에 대하여",null,null,null,null,"저압 단상",39000,"M",null,{"$f":"K16*M16","v":0},null,null,null,"* 기본거리(가공: 200m, 지중: 50m)를 초과하는 경우 거리공사비 별도로 추가됨."]
[null,null,null,null,null,null,null,null,null,"저압 삼상",43000,"M",null,{"$f":"K17*M17","v":0}]
[null,null,null,null,null,null,null,null,null,"고압 또는 특별고압",43000,"M",null,{"$f":"K18*M18","v":0}]
[null,null,null,"지중공급","기본거리를 초과하는 신설                  거리 매 1m에 대하여",null,null,null,null,"저압",60000,"M",null,{"$f":"K19*M19","v":0}]
[null,null,null,null,null,null,null,null,null,"고압 또는 특별고압",110000,"M",null,{"$f":"K20*M20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"소계",null,{"$f":"SUM(N16:N20)","v":0}]
[null,null,"3) 첨가거리공사비 (부가가치세 불포함)"]
[null,null,null,"가공공급","기본거리를 초과하는 첨가                  거리 매 1m에 대하여 ",null,null,null,null,"저압",5000,"M",null,{"$f":"K23*M23","v":0}]
[null,null,null,null,null,null,null,null,null,"고압 또는 특별고압",10000,"M",null,{"$f":"K24*M24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"소계",null,{"$f":"SUM(N23:N24)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"합계",null,{"$f":"N14+N21+N25","v":0}]
[null,"2.사용전검사비"]
[null,null,"1) 수용설비"]
[null,null,null,"기본료","저압",null,null,null,null,"기본료",94000,"건당",{"$f":"IF((V3+W3)>=1,1,IF((V3+W3)<1,0))","v":0},{"$f":"K29*M29","v":0}]
[null,null,null,null,"고압 300kW까지",null,null,null,null,"기본료",298000,"건당",null,0]
[null,null,null,null,"고압 300kW초과",null,null,null,null,"기본료",559000,"건당",{"$f":"IF((AC4+AC5)=2,1,IF((AC4+AC5)<2,0))","v":0},0]
[null,null,null,null,"고압 1,000kW이상",null,null,null,null,"기본료",678000,"건당",{"$f":"IF(OR(AND(($X$3+$Y$3)>=1,$S$3>=1000)),1,0)","v":0},0]
[null,null,null,"kW당 요금","저압",null,null,null,null,"kW당",391,"kW",{"$f":"IF(($V$3+$W$3)>=1,$S$3,IF(($V$3+$W$3)<1,0))","v":0},0,null,null,null,"* 구내배전설비 검사시는 기본료에 Kw당 요금의 2배합산적용."]
[null,null,null,null,"고압 300kW까지",null,null,null,null,"kW당",660,"kW",{"$f":"IF(($X$3+$Y$3)>=1,(IF(($S$3<=300),$S$3,IF(($S$3>300),0))),IF(($X$3+$Y$3)<1,0))","v":0},0,null,null,null,"*구내배전설비 검사는 총부하 1,000kVA임."]
[null,null,null,null,"고압 300kW초과",null,null,null,null,"kW당",315,"kW",{"$f":"IF(AC6>=1000,0,IF(AC6<1000,AC6))","v":0},0]
[null,null,null,null,"고압 1,000kW까지",null,null,null,null,"kW당",268,"kW",{"$f":"IF(AD6>99000,0,IF(AD6<=99000,AC7))","v":0},{"$f":"K36*M36*2","v":0},{"$f":"IF(($S$3>=1000),\"X2\",IF(($S$3<1000),0))","v":0}]
[null,null,null,null,"고압 1,001~100,000kW까지",null,null,null,null,"kW당",152,"kW",{"$f":"IF(AD6>99000,0,IF(AD6<=99000,AD6))","v":0},{"$f":"K37*M37*2","v":0},{"$f":"IF(($S$3>=1000),\"X2\",IF(($S$3<1000),0))","v":0}]
[null,null,null,null,"고압 100,000kW초과",null,null,null,null,"kW당",32,"kW",{"$f":"IF(($X$3+$Y$3)>=1,(IF(($S$3<=100000),0,IF(($S$3>100000),$S$3))),IF(($X$3+$Y$3)<1,0))","v":0},{"$f":"K38*M38*2","v":0},{"$f":"IF(($S$3>=1000),\"X2\",IF(($S$3<1000),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"소계",null,{"$f":"SUM(N29:N38)","v":0}]
[null,null,"2) 발전기공사"]
[null,null,null,"기본료","용량 300kW까지",null,null,null,null,"기본료",88000,"건당",{"$f":"IF(AC14=2,IF($T$3<=300,1,IF($T$3>300,0)),IF(AC14=1,0))","v":0},{"$f":"K41*M41","v":0},null,null,null,"* 수용설비 기본료 적용시 발전설비는 기본료는 제외임."]
[null,null,null,null,"용량 300kW초과",null,null,null,null,"기본료",293000,"건당",{"$f":"IF(AC14=2,IF(($AC$9+$AC$10)=2,1,IF(($AC$9+$AC$10)<2,0)),IF(AC14=1,0))","v":0},0,null,null,null,"(예: 발전기 100KW+150KW+450KW+600KW (총용량 1,300KW) 4대 경우)"]
[null,null,null,null,"용량 50,000kW초과",null,null,null,null,"기본료",3804000,"건당",{"$f":"IF(AC14=2,IF((T3>50000),1,IF((T3<=50000),0)),IF(AC14=1,0))","v":0},0,null,null,null,null,"KW","금액","KW","금액","KW","금액","KW","금액","총합계"]
[null,null,null,"kW당 요금","용량 300kW까지",null,null,null,null,null,203,"kW",{"$f":"IF(($T$3<=300),$T$3,IF($S$3>300,0))","v":0},0,null,null,null," 용량 300KW까지",null,{"$f":"$K$44*S44","v":0},null,{"$f":"$K$44*U44","v":0},null,{"$f":"$K$44*W44","v":0},null,{"$f":"$K$44*Y44","v":0},{"$f":"+Z44+X44+V44+T44","v":0}]
[null,null,null,null,"용량 300kW초과",null,null,null,null,"500kW까지",177,"kW",{"$f":"IF(T3>50000,0,IF($T$3<=300,0,IF($T$3>500,500,IF(AND($T$3>300,$T$3<=500),$T$3))))","v":0},0,null,null,null,"용량 300KW초과",500,{"$f":"$K$45*S45","v":88500},500,{"$f":"$K$45*U45","v":88500},null,{"$f":"$K$45*W45","v":0},null,{"$f":"$K$45*Y45","v":0},{"$f":"+Z45+X45+V45+T45","v":177000}]
[null,null,null,null,null,null,null,null,null,"501~1,000kW까지",109,"kW",{"$f":"IF(T3>50000,0,IF($T$3<=500,0,IF($T$3>1000,500,IF(AND($T$3>500,$T$3<=1000),$T$3-500))))","v":0},0,null,null,null,null,null,{"$f":"$K$46*S46","v":0},null,{"$f":"$K$46*U46","v":0},null,{"$f":"$K$46*W46","v":0},null,{"$f":"$K$46*Y46","v":0},{"$f":"+Z46+X46+V46+T46","v":0}]
[null,null,null,null,null,null,null,null,null,"1,001~5,000kW까지",86,"kW",{"$f":"IF(T3>50000,0,IF($T$3<=1000,0,IF($T$3>5000,4000,IF(AND($T$3>1000,$T$3<=5000),$T$3-1000))))","v":0},0,null,null,null,"합계",null,{"$f":"SUM(T44:T46)","v":88500},null,{"$f":"SUM(V44:V46)","v":88500},null,{"$f":"SUM(X44:X46)","v":0},null,{"$f":"SUM(Z44:Z46)","v":0},{"$f":"SUM(AA44:AA46)","v":177000}]
[null,null,null,null,null,null,null,null,null,"5,001~10,000kW까지",47,"kW",{"$f":"IF(T3>50000,0,IF($T$3<=5000,0,IF($T$3>10000,5000,IF(AND($T$3>5000,$T$3<=10000),$T$3-5000))))","v":0},0]
[null,null,null,null,null,null,null,null,null,"10,000kW초과",7,"kW",{"$f":"IF(T3>50000,0,IF($T$3<=10000,0,IF($T$3>50000,40000,IF(AND($T$3>10000,$T$3<=500000),$T$3-10000))))","v":0},0]
[null,null,null,null,"용량 50,000kW초과",null,null,null,null,"10,0000kW까지",34,"kW",{"$f":"IF($T$3>=100000,100000,IF($T$3<=50000,0,IF(AND($T$3>50000,$T$3<=1000000),$T$3)))","v":0},0]
[null,null,null,null,null,null,null,null,null,"10,0000kW초과",18,"kW",{"$f":"IF(T3<=100000,0,IF(T3>100000,T3-100000))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"소계",null,{"$f":"SUM(N41:N51)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"합계",null,{"$f":"N39+N52","v":0}]
[null,null,"3) 태양광발전설비"]
[null,null,null,"기본료","용량 20kW까지",null,null,null,null,"기본료",81300,"건당",null,{"$f":"K55*M55","v":0},null,null,null,"* 10KW까지 안전검사 수수료 제외."]
[null,null,null,null,"용량 20kW초과",null,null,null,null,"기본료",138000,"건당",null,{"$f":"K56*M56","v":0},null,null,null,"* 10KW까지 안전검사 수수료 제외."]
[null,null,null,null,"용량 500kW까지",null,null,null,null,"기본료",239600,"건당",null,0]
[null,null,null,null,"용량 500kW초과",null,null,null,null,"기본료",351900,"건당",null,0,null,null,null,"* 사용전검사비는 모두 적용."]
[null,null,null,"kW당 요금","용량 20kW까지",null,null,null,null,null,292,"kW",{"$f":"IF(($U$3<=20),$U$3,IF(($U$3>20),0))","v":0},0]
[null,null,null,null,"용량 20kW초과",null,null,null,null,null,611,"kW",{"$f":"IF(($AE$10+$AE$11)=2,0,IF(($AE$10+$AE$11)=0,0,IF(($AE$10+$AE$11)=1,$U$3)))","v":0},0]
[null,null,null,null,"용량 500kW까지",null,null,null,null,null,426,"kW",{"$f":"IF(($U$3>100),$U$3,IF(($U$3<=100),0))","v":0},{"$f":"K61*M61","v":0}]
[null,null,null,null,"용량 500kW초과",null,null,null,null,null,349,"kW",{"$f":"IF(($U$3>100),$U$3,IF(($U$3<=100),0))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"합계",null,{"$f":"SUM(N55:N62)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"합계(1+2)",null,"원",null,{"$f":"N26+N53+N63","v":0}]
[null,null,null,null,null,null,null,null,null,"부가가치세",0.1,"원",null,{"$f":"N65*10%","v":0}]
[null,null,null,null,null,null,null,null,null,"총계",null,"원",null,{"$f":"N65+N66","v":0}]
[]
[]
[null,null,null,"자료출처:","한국전기안전공사협회 http://www.kesco.or.kr(사용전검사비)"]
[null,null,null," ","한국전력공사 http://cis.kepco.co.kr (한전불입금)"]
[]
[null,null,null,null,"사용전검사비"]