{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["감리비 산출내역","전기산출서","전기-요율","전기-손해배상"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":234,"defined_names":4857,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,0,2,1],[0,0,0,7],[3,0,3,1]]}
["신탄진권역 복합문화커뮤니티센터 감리용역"]
[]
["분       야",null,"산출비용","상주/비상주","등급","투입개월","투입일수","비고"]
["전기",null,{"$f":"전기산출서!E26","v":223264000},"상주:비상주 (9:1)","고급",21,"18인/월"]

{"sheet":"전기산출서","index":1,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,10],[2,1,2,2],[2,3,2,6],[2,8,2,10],[3,1,3,2],[3,4,3,6],[4,1,4,2],[4,5,4,6],[5,1,7,1],[5,4,5,6],[5,8,5,10],[6,4,6,6],[6,8,6,10],[7,4,7,6],[7,8,7,10],[8,1,10,1],[8,3,8,4],[8,5,8,6],[8,7,10,7],[8,10,10,10],[12,8,12,10],[13,1,15,1],[13,4,13,6],[14,4,14,6],[14,7,15,7],[15,4,15,6],[11,1,12,1],[11,3,11,6],[11,7,12,7],[11,8,11,10],[12,4,12,6],[16,1,16,2],[16,4,16,6],[17,1,17,2],[17,4,17,6],[18,1,18,2],[18,4,18,6],[24,1,24,2],[24,4,24,6],[25,1,25,2],[25,4,25,6],[19,1,19,2],[19,4,19,6],[21,1,21,2],[21,4,21,6],[23,1,23,2],[23,4,23,6]]}
[null,"전기 감리용역비 산출서"]
[null,"[용역명] ","신탄권역 복합문화 커뮤니센터 전기공사 감리용역 "]
[null,"구    분",null,"산    출    기    초",null,null,null,"관련근거\n(전력기술관리법)","비     고"]
[null,"공          종",null,null,"보통공종",null,null," 운영요령 [별표3]"]
[null,"책임감리원등급",null,"①","고급감리원",{"$f":"IF(전기산출서!E5=\"특급감리원\",'전기-요율'!C32,IF(전기산출서!E5=\"고급감리원\",'전기-요율'!C33,IF(전기산출서!E5=\"중급감리원\",'전기-요율'!C34,IF(전기산출서!E5=\"초급감리원\",'전기-요율'!C35))))","v":242820},null," 시행령 제22조제2항 [별표3]","10억 미만 중급감리원 이상"]
[null,"감리대상\n공 사 비","소  계","②",{"$f":"E7+E8","v":1948563000},null,null," 운영요령 [제2조]"," 부가가치세 미포함"]
[null,null,"도  급",null,{"$f":"ROUNDDOWN((H7/1.1*1),-3)","v":1672957000},null,null,1840252734,{"$f":"SUM(H7:H8)","v":2850808704}]
[null,null,"관  급",null,{"$f":"ROUNDDOWN((H8/1.1*1*I8),-3)","v":275606000},null,null,1010555970,0.3]
[null,"감 리 원\n배치기준","구  분","공사비",null,"요율(인×월)",null," 운영요령 [별표2]",{"$nulls":4},"②","③"]
[null,null,"직  하","③",{"$f":"MIN(M10:M13)","v":1000000000},"⑤",{"$f":"IF(E4=\"단순공종\",VLOOKUP(E10,'전기-요율'!H6:K35,2),IF(E4=\"보통공종\",VLOOKUP(E10,'전기-요율'!H6:K35,3),IF(E4=\"복잡공종\",VLOOKUP(E10,'전기-요율'!H6:K35,4))))","v":10.8},{"$nulls":5},{"$f":"IF(E6<'전기-요율'!H6,'전기-요율'!H6,IF(E6<'전기-요율'!H7,'전기-요율'!H6,IF(E6<'전기-요율'!H8,'전기-요율'!H7,IF(E6<'전기-요율'!H9,'전기-요율'!H8,IF(E6<'전기-요율'!H10,'전기-요율'!H9,\nIF(E6<'전기-요율'!H11,'전기-요율'!H10,IF(E6<'전기-요율'!H12,'전기-요율'!H11,IF(E6<'전기-요율'!H13,'전기-요율'!H12))))))))","v":false},{"$f":"IF(E6<'전기-요율'!H6,'전기-요율'!H6,IF(E6<'전기-요율'!H7,'전기-요율'!H7,IF(E6<'전기-요율'!H8,'전기-요율'!H8:H9,IF(E6<'전기-요율'!H9,'전기-요율'!H9,IF(E6<'전기-요율'!H10,'전기-요율'!H10,\nIF(E6<'전기-요율'!H11,'전기-요율'!H11,IF(E6<'전기-요율'!H12,'전기-요율'!H12,IF(E6<'전기-요율'!H13,'전기-요율'!H13))))))))","v":false}]
[null,null,"직  상","④",{"$f":"MIN(N10:N13)","v":2000000000},"⑥",{"$f":"IF(E4=\"단순공종\",VLOOKUP(E11,'전기-요율'!H6:K35,2),IF(E4=\"보통공종\",VLOOKUP(E11,'전기-요율'!H6:K35,3),IF(E4=\"복잡공종\",VLOOKUP(E11,'전기-요율'!H6:K35,4))))","v":18.399999999999999},{"$nulls":5},{"$f":"IF(E6<'전기-요율'!H14,'전기-요율'!H13,IF(E6<'전기-요율'!H15,'전기-요율'!H14,IF(E6<'전기-요율'!H16,'전기-요율'!H15,IF(E6<'전기-요율'!H17,'전기-요율'!H16,IF(E6<'전기-요율'!H18,'전기-요율'!H17,\nIF(E6<'전기-요율'!H19,'전기-요율'!H18,IF(E6<'전기-요율'!H20,'전기-요율'!H19,IF(E6<'전기-요율'!H21,'전기-요율'!H20))))))))","v":false},{"$f":"IF(E6<'전기-요율'!H14,'전기-요율'!H14,IF(E6<'전기-요율'!H15,'전기-요율'!H15,IF(E6<'전기-요율'!H16,'전기-요율'!H16,IF(E6<'전기-요율'!H17,'전기-요율'!H17,IF(E6<'전기-요율'!H18,'전기-요율'!H18,\nIF(E6<'전기-요율'!H19,'전기-요율'!H19,IF(E6<'전기-요율'!H20,'전기-요율'!H20,IF(E6<'전기-요율'!H21,'전기-요율'!H21))))))))","v":false}]
[null,"배치인원","계산식","Y = ⑤ - { (②-③) × (⑤-⑥) } ÷ (④-③)",null,null,null," 운영요령 [별표2]"," 직선보간법",null,null,null,{"$f":"IF(E6<'전기-요율'!H22,'전기-요율'!H21,IF(E6<'전기-요율'!H23,'전기-요율'!H22,IF(E6<'전기-요율'!H24,'전기-요율'!H23,IF(E6<'전기-요율'!H25,'전기-요율'!H24,IF(E6<'전기-요율'!H26,'전기-요율'!H25,\nIF(E6<'전기-요율'!H27,'전기-요율'!H26,IF(E6<'전기-요율'!H28,'전기-요율'!H27,IF(E6<'전기-요율'!H29,'전기-요율'!H28))))))))","v":1000000000},{"$f":"IF(E6<'전기-요율'!H22,'전기-요율'!H22,IF(E6<'전기-요율'!H23,'전기-요율'!H23,IF(E6<'전기-요율'!H24,'전기-요율'!H24,IF(E6<'전기-요율'!H25,'전기-요율'!H25,IF(E6<'전기-요율'!H26,'전기-요율'!H26,\nIF(E6<'전기-요율'!H27,'전기-요율'!H27,IF(E6<'전기-요율'!H28,'전기-요율'!H28,IF(E6<'전기-요율'!H29,'전기-요율'!H29))))))))","v":2000000000}]
[null,null,"적  용","⑦",{"$f":"ROUNDDOWN((G10-((E6-E10)*(G10-G11))/(E11-E10))/1,1)","v":18},null,null,null," 소수점이하 버림",null,null,null,{"$f":"IF(E6<'전기-요율'!H30,'전기-요율'!H29,IF(E6<'전기-요율'!H31,'전기-요율'!H30,IF(E6<'전기-요율'!H32,'전기-요율'!H31,IF(E6<'전기-요율'!H33,'전기-요율'!H32,IF(E6<'전기-요율'!H34,'전기-요율'!H33,\nIF(E6<'전기-요율'!H35,'전기-요율'!H34))))))","v":5000000000},{"$f":"IF(E6<'전기-요율'!H30,'전기-요율'!H30,IF(E6<'전기-요율'!H31,'전기-요율'!H31,IF(E6<'전기-요율'!H32,'전기-요율'!H32,IF(E6<'전기-요율'!H33,'전기-요율'!H33,IF(E6<'전기-요율'!H34,'전기-요율'!H34,\nIF(E6<'전기-요율'!H35,'전기-요율'!H35))))))","v":7000000000}]
[null,"직접인건비","소   계","⑧",{"$f":"IF(E5=\"특급감리원\",INT('전기-요율'!C32*전기산출서!E13*K14),IF(E5=\"고급감리원\",INT('전기-요율'!C33*전기산출서!E13*K14),IF(E5=\"중급감리원\",INT('전기-요율'!C34*전기산출서!E13*K14),IF(E5=\"초급감리원\",INT('전기-요율'!C35*전기산출서!E13*K14)))))","v":96156720},null,null," 운영요령 [제26조]"," ① ×","⑦ ×",22]
[null,null,"상  주",null,{"$f":"E14-E16","v":86541048},null,null," 운영요령 [제25조]\n 비상주(고급감리원 이상)"," ⑧ ×",0.9]
[null,null,"비상주",null,{"$f":"INT(E14*J16)","v":9615672},null,null,null," ⑧ ×",0.1]
[null,"제경비",null,"⑨",{"$f":"INT(E14*J17)","v":105772392},null,null," 운영요령 [제28조]"," ⑧ ×",1.1000000000000001]
[null,"기술료",null,"⑩",{"$f":"(E14+E17)*K18","v":0},null,null," 운영요령 [제29조]"," ⑧ ＋"]
[null,"산출감리용역비",null,"⑪",{"$f":"E14+E17+E18","v":201929112},null,null,null," ⑧ ＋ ⑨ +  ⑩"]
[null,"감리용역비조정",null,"⑫",{"$f":"ROUNDDOWN(E19*J20,-3)","v":201929000},null,null," 천원이하 절사"," ⑪ ×",1]
[]
[null,"손해배상공제료",null,"⑬",{"$f":"ROUNDDOWN(E20*J22,-3)","v":1039000},null,null,"전력기술관리법 손해배상공제요율  \n건축물 등의 전기설비 0.515%"," ⑫ ×",5.1500000000000001E-3]
[]
[null,"공급가액",null,"⑭",{"$f":"E20+E22","v":202968000},null,null,null," ⑫  +  ⑬"]
[null,"부가가치세",null,"⑮",{"$f":"INT(E24*J25)","v":20296800},null,null,null," ⑭ ×",0.1]
[null,"감리용역비",null,null,{"$f":"ROUNDDOWN(SUM(E24:G25),-3)","v":223264000},null,null,null," ⑬ ＋ ⑭","천원이하 절사"]

{"sheet":"전기-요율","index":2,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,10],[2,7,2,10],[3,1,4,1],[3,2,3,5],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[24,1,24,5],[26,1,26,5],[29,1,30,1],[29,2,29,5],[30,2,30,3],[30,4,30,5],[34,2,34,3],[34,4,34,5],[35,7,35,10],[31,2,31,3],[31,4,31,5],[32,2,32,3],[32,4,32,5],[33,2,33,3],[33,4,33,5]]}
[]
[null,"[별표 1] 전력시설물공사 설계 및 설계감리 요율(제18조제2항관련)",{"$nulls":5},"[별표 2] 전력시설물공사 감리원배치기준(제25조제1항관련)"]
[{"$nulls":7},"단위 : 감리원수(인×월)"]
[null,"                요율\n 공사비","요율 (%)",{"$nulls":4}," 공사비(원)","단순공종","보통공종","복잡공종"]
[null,null,"기본설계","실시설계","설계감리","    계"]
[null,"2,000만원까지",3.79,11.38,1.89,{"$f":"SUM(C6:E6)","v":17.060000000000002},null,{"$f":"0.05*100000000","v":5000000},0.17,0.18,0.2]
[null,"3,000만원까지",3.07,9.19,1.53,13.79,null,{"$f":"0.1*100000000","v":10000000},0.28000000000000003,0.31,0.34]
[null,"5,000만원까지",2.14,6.42,1.07,9.6300000000000008,null,{"$f":"0.2*100000000","v":20000000},0.48,0.53,0.59]
[null,"1억원까지",2.0099999999999998,6.01,1,9.02,null,{"$f":"0.3*100000000","v":30000000},0.66,0.73,0.8]
[null,"2억원까지",1.6,4.8,0.8,7.2,null,{"$f":"0.4*100000000","v":40000000},0.82,0.9,1]
[null,"3억원까지",1.46,4.38,0.73,6.57,null,{"$f":"0.5*100000000","v":50000000},1,1.1000000000000001,1.2]
[null,"5억원까지",1.33,3.97,0.66,5.9600000000000009,null,{"$f":"0.6*100000000","v":60000000},1.1000000000000001,1.2,1.4]
[null,"10억원까지",1.17,3.51,0.57999999999999996,5.26,null,{"$f":"0.7*100000000","v":70000000},1.3,1.4,1.5]
[null,"20억원까지",1.08,3.22,0.54,4.8400000000000007,null,{"$f":"0.8*100000000","v":80000000},1.4,1.5,1.7]
[null,"30억원까지",1.04,3.11,0.52,4.67,null,{"$f":"0.9*100000000","v":90000000},1.5,1.7,1.9]
[null,"50억원까지",1.02,3.06,0.51,4.59,null,{"$f":"1*100000000","v":100000000},1.7,1.8,2]
[null,"100억원까지",0.99,2.98,0.49,4.46,null,{"$f":"2*100000000","v":200000000},2.8,3.1,3.4]
[null,"200억원까지",0.96,2.89,0.48,4.33,null,{"$f":"3*100000000","v":300000000},3.9,4.3,4.7]
[null,"300억원까지",0.95,2.87,0.47,4.29,null,{"$f":"4*100000000","v":400000000},4.8,5.3,5.9]
[null,"500억원까지",0.94,2.81,0.46,4.21,null,{"$f":"5*100000000","v":500000000},5.7,6.3,7]
[null,"1,000억원까지",0.92,2.77,0.45,4.1399999999999997,null,{"$f":"6*100000000","v":600000000},6.6,7.3,8]
[null,"2,000억원까지",0.91,2.72,0.44,4.07,null,{"$f":"7*100000000","v":700000000},7.4,8.1999999999999993,9]
[null,"3,000억원까지",0.9,2.67,0.43,4,null,{"$f":"8*100000000","v":800000000},8.1999999999999993,9.1,10]
[null,"5,000억원까지",0.89,2.64,0.42,3.95,null,{"$f":"9*100000000","v":900000000},9,10,11]
[null,"※ 실시설계만 발주시 실시설계요율(%)×1.3배 적용",{"$nulls":5},{"$f":"10*100000000","v":1000000000},9.6999999999999993,10.8,11.9]
[{"$nulls":7},{"$f":"20*100000000","v":2000000000},16.600000000000001,18.399999999999999,20.3]
[{"$nulls":7},{"$f":"30*100000000","v":3000000000},22.6,25.2,27.7]
[null,"※ 2021년도 감리원 임금(한국전기기술인협회)",{"$nulls":5},{"$f":"40*100000000","v":4000000000},28.3,31.4,34.5]
[{"$nulls":5},"2021.01.01",null,{"$f":"50*100000000","v":5000000000},33.5,37.299999999999997,41]
[null,"구분","2020년도 감리원 임금",{"$nulls":4},{"$f":"70*100000000","v":7000000000},43.4,48.3,53.1]
[null,null,"일임금액",null,"환산비(Si)",null,null,{"$f":"100*100000000","v":10000000000},57.2,63.5,69.900000000000006]
[null,"특급감리원",288765,null,{"$f":"ROUND(C32/C33,2)","v":1.19},null,null,{"$f":"200*100000000","v":20000000000},97.4,108.2,119]
[null,"고급감리원",242820,null,{"$f":"ROUND(C33/C33,2)","v":1},null,null,{"$f":"300*100000000","v":30000000000},133,147.80000000000001,162.6]
[null,"중급감리원",219050,null,{"$f":"ROUND(C34/C33,2)","v":0.9},null,null,{"$f":"400*100000000","v":40000000000},166,184.4,202.9]
[null,"초급감리원",199763,null,{"$f":"ROUND(C35/C33,2)","v":0.82},null,null,{"$f":"500*100000000","v":50000000000},197,218.9,240.8]
[{"$nulls":7},"※ 고급감리원기준, 소수점이하 둘째자리 반올림"]

{"sheet":"전기-손해배상","index":3,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,8,6,11],[3,0,5,0],[3,1,3,10],[3,11,5,11],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,9,4,10]]}
[]
["감리용역 손해배상공제요율표 (2020.07.01 개정)"]
[]
[null,"용역금액(계약금액)",{"$nulls":9},"표준\n공사\n기간\n(년)"]
[null,"5억원이하",null,"5억원초과\n10억원이하",null,"10억원초과\n20억원이하",null,"20억원초과\n30억원이하",null,"20억원초과\n30억원이하"]
[null,"기본(%)","가산(%)","기본(%)","가산(%)","기본(%)","가산(%)","기본(%)","가산(%)","기본(%)","가산(%)"]
["□ 전기감리부문",{"$nulls":7},"출처: 한국전력기술인협회(2020.07.01 개정)"]
["발전설비",0.83799999999999997,0.13400000000000001,0.81299999999999994,0.129,0.78800000000000003,0.126,0.76300000000000001,0.122,0.73799999999999999,0.11799999999999999,3]
["송전설비",0.58699999999999997,9.4E-2,0.56899999999999995,9.0999999999999998E-2,0.55100000000000005,8.7999999999999995E-2,0.53400000000000003,8.5000000000000006E-2,0.51600000000000001,8.3000000000000004E-2,2]
["변전설비",0.58699999999999997,9.4E-2,0.56899999999999995,9.0999999999999998E-2,0.55100000000000005,8.7999999999999995E-2,0.53400000000000003,8.5000000000000006E-2,0.51600000000000001,8.3000000000000004E-2,2]
["배전설비",0.58699999999999997,9.4E-2,0.56899999999999995,9.0999999999999998E-2,0.55100000000000005,8.7999999999999995E-2,0.53400000000000003,8.5000000000000006E-2,0.51600000000000001,8.3000000000000004E-2,2]
["건축물 등의 전기설비",0.56499999999999995,0.09,0.54900000000000004,8.6999999999999994E-2,0.53200000000000003,8.5000000000000006E-2,0.51500000000000001,8.3000000000000004E-2,0.498,0.08,3]
["공항.항만 전기설비",0.80100000000000005,0.128,0.77800000000000002,0.124,0.753,0.12,0.73,0.11700000000000001,0.70499999999999996,0.113,4]
["지하철공사",0.98399999999999999,0.157,0.95399999999999996,0.152,0.92500000000000004,0.14799999999999999,0.89500000000000002,0.14299999999999999,0.86599999999999999,0.13800000000000001,4]
["기타 전기설비",0.58399999999999996,9.0999999999999998E-2,0.56699999999999995,8.7999999999999995E-2,0.55000000000000004,8.5999999999999993E-2,0.53300000000000003,8.3000000000000004E-2,0.51800000000000002,0.08,1]
["터널.댐.교량",0.98399999999999999,0.157,0.95399999999999996,0.152,0.92500000000000004,0.14799999999999999,8.5000000000000006E-2,0.14299999999999999,0.86599999999999999,0.13800000000000001,4]
["전기철도 및 철도신호공사",0.629,0.1,0.60899999999999999,9.7000000000000003E-2,0.59199999999999997,9.5000000000000001E-2,0.57299999999999995,9.1999999999999998E-2,0.55300000000000005,8.7999999999999995E-2,3]
["관람집회시설공사",0.47199999999999998,7.4999999999999997E-2,0.45800000000000002,7.2999999999999995E-2,0.44400000000000001,7.0000000000000007E-2,0.43,6.9000000000000006E-2,0.41599999999999998,6.6000000000000003E-2,3]
["전시시설공사",0.47199999999999998,7.4999999999999997E-2,0.45800000000000002,7.2999999999999995E-2,0.44400000000000001,7.0000000000000007E-2,0.43,6.9000000000000006E-2,0.41599999999999998,6.6000000000000003E-2,2]
["공용청사건설공사",0.56499999999999995,0.09,0.54900000000000004,8.6999999999999994E-2,0.53200000000000003,8.5000000000000006E-2,0.51500000000000001,8.3000000000000004E-2,0.498,0.08,3]
["도로",0.70799999999999996,0.113,0.68600000000000005,0.109,0.66500000000000004,0.106,0.64400000000000002,0.10199999999999999,0.622,0.1,3]