{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["원가계산서","공종별집계표","공종별내역서"," 공사설정 ","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":15,"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":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,1,1,4],[1,5,1,6],[2,1,2,3],[3,1,19,1],[3,2,6,2],[7,2,9,2],[10,2,19,2],[27,1,27,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3]]}
[null,"공 사 원 가 계 산 서"]
[null,"공사명 : 평촌공업지역 스마트플랫폼 신축공사(통신)"]
[null,"비        목",null,null,"금      액","구        성        비","비      고"]
["A1","순   공   사   원   가","재   료   비","직  접  재  료  비",null,"",""]
["A2",null,null,"간  접  재  료  비",null,"",""]
["A3",null,null,"작업설, 부산물(△)",null,"",""]
["AS",null,null,"[ 소          계 ]",null,"",""]
["B1",null,"노   무   비","직  접  노  무  비",null,"",""]
["B2",null,null,"간  접  노  무  비",null,"직접노무비 * 12.2%",""]
["BS",null,null,"[ 소          계 ]",null,"",""]
["C2",null,"경        비","경              비",null,"",""]
["C4",null,null,"산  재  보  험  료",null,"노무비 * 3.7%",""]
["C5",null,null,"고  용  보  험  료",null,"노무비 * 1.01%",""]
["C6",null,null,"국민  건강  보험료",null,"직접노무비 * 3.545%",""]
["C7",null,null,"국민  연금  보험료",null,"직접노무비 * 4.5%",""]
["C8",null,null,"퇴직  공제  부금비",null,"직접노무비 * 2.3%"]
["CA",null,null,"산업안전보건관리비",null,"(재료비+직노+관급자재비) * 2.93%",""]
["CB",null,null,"노인장기요양보험료",null,"건강보험료 * 12.81%",""]
["CG",null,null,"기   타    경   비",null,"(재료비+노무비) * 5.8%",""]
["CS",null,null,"[ 소          계 ]",null,"",""]
["S1","        계",null,null,null,"",""]
["D1","일  반  관  리  비",null,null,null,"계 * 6%",""]
["D2","이              윤",null,null,null,"(노무비+경비+일반관리비) * 15%",""]
["D9","공   급    가   액",null,null,null,"",""]
["DB","부  가  가  치  세",null,null,null,"공급가액 * 10%",""]
["DH","도      급      액",null,null,null,"",""]
[null,"관  급  자  재  비"]
["S2","총   공   사    비",null,null,null,"",""]

{"sheet":"공종별집계표","index":1,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,18,3,18],[2,19,3,19],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,17,3,17]]}
["공 종 별 집 계 표"]
["공사명 : 평촌공업지역 스마트플랫폼 신축공사(통신)"]
["품      명","규      격","단위","수량","재  료  비",null,"노  무  비",null,"경      비",null,"합      계",null,"비  고","공종코드","변수","상위공종","공종구분","공종레벨","공종소계","원가계산서 연결금액"]
[{"$nulls":4},"단  가","금  액","단  가","금  액","단  가","금  액","단  가","금  액"]
["01  평촌공업지역스마트플랫폼신축통신공사(1차공사분)","","",1,{"$nulls":9},"01","","","",1,""]
["0101  통신공사","","",1,{"$nulls":9},"0101","","01","",2,""]
["010101  정보통신인입공사","","",1,{"$nulls":9},"010101","","0101","",3,""]
["010102  정보통신간선공사","","",1,{"$nulls":9},"010102","","0101","",3,""]
["010103  정보통신설비공사","","",1,{"$nulls":9},"010103","","0101","",3,""]
["010104  CCTV설비공사","","",1,{"$nulls":9},"010104","","0101","",3,""]
{"$rows_empty":16}
["[ 합           계 ]"]

{"sheet":"공종별내역서","index":2,"n_rows":99,"n_cols":48,"rows_kept":99,"cut":false,"hidden":false,"merged":[[1,18,2,18],[0,0,0,12],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,2,12],[1,13,2,13],[1,14,2,14],[1,15,2,15],[1,16,2,16],[1,17,2,17],[1,30,2,30],[1,19,2,19],[1,20,2,20],[1,21,2,21],[1,22,2,22],[1,23,2,23],[1,24,2,24],[1,25,2,25],[1,26,2,26],[1,27,2,27],[1,28,2,28],[1,29,2,29],[1,42,2,42],[1,31,2,31],[1,32,2,32],[1,33,2,33],[1,34,2,34],[1,35,2,35],[1,36,2,36],[1,37,2,37],[1,38,2,38],[1,39,2,39],[1,40,2,40],[1,41,2,41],[1,43,2,43],[1,44,2,44],[1,45,2,45],[1,46,2,46],[1,47,2,47]]}
["공사명 : 평촌공업지역 스마트플랫폼 신축공사(통신)"]
["품      명","규      격","단위","수량","재  료  비",null,"노  무  비",null,"경      비",null,"합      계",null,"비  고","품목코드","변수","설정","공종코드","일위","단산","자재","손료적용","손료저장","적용율","JUK1","JUK2","JUK3","JUK4","JUK5","JUK6","JUK7","JUK8","JUK9","JUK10","JUK11","JUK12","JUK13","JUK14","JUK15","JUK16","JUK17","JUK18","JUK19","JUK20","자재구분","공종구분","공종레벨","공종+자재","고유번호"]
[{"$nulls":4},"단  가","금  액","단  가","금  액","단  가","금  액","단  가","금  액"]
["010101  정보통신인입공사","",{"$nulls":14},"010101"]
["핸드홀","수공1호","조",2,{"$nulls":9},"51B8B2A128448979F155F81A89A3EB","","","010101","T","F","F",{"$nulls":23},"","",null,"01010151B8B2A128448979F155F81A89A3EB",4]
["통신핸드홀카바-1호","주철각형(1120*680*132)","조",2,{"$nulls":9},"51B8B2A128448979F155F81A89A2C4","","","010101","T","F","F",{"$nulls":23},"","",null,"01010151B8B2A128448979F155F81A89A2C4",5]
["풀박스","풀박스, 100*100*100mm","개",3,{"$nulls":9},"51B8B2A128448979F155F81A89A13D","","","010101","T","F","F",{"$nulls":23},"","",null,"01010151B8B2A128448979F155F81A89A13D",6]
["터파기/토사","보통, 굴삭기 0.7m3 90%, 인력10%","M3",15,{"$nulls":9},"511FA2112A40BD7FF0C9EC1A62BAE8","","","010101","F","T","F",{"$nulls":23},"","",null,"010101511FA2112A40BD7FF0C9EC1A62BAE8",7]
["되메우기/토사, 두께 10cm","보통, 굴삭기 0.7m3+플레이트콤팩터 1.5ton+인력 10%","M3",15,{"$nulls":9},"511FA211274B4C7DD1E972268E5F42","","","010101","F","T","F",{"$nulls":23},"","",null,"010101511FA211274B4C7DD1E972268E5F42",8]
["경질비닐PVC전선관-매입","HI, 36mm","M",21,{"$nulls":9},"51763291224F257FC621BA97094E07","","","010101","T","F","F",{"$nulls":23},"","",null,"01010151763291224F257FC621BA97094E07",9]
["폴리에틸렌전선관-매입","PE, 36㎜","M",180,{"$nulls":9},"51763291224F257FC474E70DEDCBA6","","","010101","T","F","F",{"$nulls":23},"","",null,"01010151763291224F257FC474E70DEDCBA6",10]
["난연 비닐절연접지용전선(F-GV)-관내","0.6/1kv, 16㎟","M",12,{"$nulls":9},"51763291224F1B785EDEA7327E8EE0","","","010101","T","F","F",{"$nulls":23},"","",null,"01010151763291224F1B785EDEA7327E8EE0",11]
["파상형경질폴리에틸렌전선관-지중포설","30㎜","M",12,{"$nulls":9},"506962D121432371DEB5702F147944","","","010101","T","F","F",{"$nulls":23},"","",null,"010101506962D121432371DEB5702F147944",12]
["접지봉 타설","길이 1~2m*3본 연결","개",1,{"$nulls":9},"5069F2C12D40A37F3262C4F7B71034","","","010101","T","F","F",{"$nulls":23},"","",null,"0101015069F2C12D40A37F3262C4F7B71034",13]
["경고테이프 포설","통신용","M",60,{"$nulls":9},"51763291224F637A9D21E84D59D55A","","","010101","T","F","F",{"$nulls":23},"","",null,"01010151763291224F637A9D21E84D59D55A",48]
["관로밀폐기","36C","개",4,{"$nulls":9},"508E42F1254F207FBBEF190D8B8D5F","","","010101","T","F","F",{"$nulls":23},"","",null,"010101508E42F1254F207FBBEF190D8B8D5F",54]
{"$rows_empty":10}
["[ 합           계 ]",{"$nulls":12},"TOTAL"]
["010102  정보통신간선공사","",{"$nulls":14},"010102"]
["LAP외피광케이블","SM 9/125, 4C","M",5,{"$nulls":9},"50690241284C9D7BCFC2AFB3997A22","","","010102","T","F","F",{"$nulls":23},"","",null,"01010250690241284C9D7BCFC2AFB3997A22",55]
["메시형케이블트레이","MS STRAIGHT, EPC 200*100*5∮","M",4.3574999999999999,{"$nulls":9},"51B8B2A128448979F155F81A89AEF5","","","010102","T","F","F",{"$nulls":23},"","",null,"01010251B8B2A128448979F155F81A89AEF5",19]
["동축케이블","TV수신용동축케이블, 고발포동축케이블, 7C-HFBT","M",10.75,{"$nulls":9},"508E42F1254F207FBBEF190D8B8D5C","","","010102","T","F","F",{"$nulls":23},"","",null,"010102508E42F1254F207FBBEF190D8B8D5C",45]
["네트워크케이블","UTP Cat. 6, 4P","M",115.5625,{"$nulls":9},"51B8B2A128448979F155F81A89A598","","","010102","T","F","F",{"$nulls":23},"","",null,"01010251B8B2A128448979F155F81A89A598",16]
["MDF RACK","","대",1,{"$nulls":9},"508E42F1254F207FBBEF190D8B8D59","","","010102","T","F","F",{"$nulls":23},"","",null,"010102508E42F1254F207FBBEF190D8B8D59",20]
["CATV 증폭기함","400x300","면",2,{"$nulls":9},"508E42F1254F207FBBEF190D8B8D5A","","","010102","T","F","F",{"$nulls":23},"","",null,"010102508E42F1254F207FBBEF190D8B8D5A",21]
["되메우기/토사, 두께 10cm","보통, 굴삭기 0.7m3+플레이트콤팩터 1.5ton+인력 10%","M3",5,{"$nulls":9},"511FA211274B4C7DD1E972268E5F42","","","010102","F","T","F",{"$nulls":23},"","",null,"010102511FA211274B4C7DD1E972268E5F42",40]
["터파기/토사","보통, 굴삭기 0.7m3 90%, 인력10%","M3",5,{"$nulls":9},"511FA2112A40BD7FF0C9EC1A62BAE8","","","010102","F","T","F",{"$nulls":23},"","",null,"010102511FA2112A40BD7FF0C9EC1A62BAE8",49]
["중간단자함","구내단자함, 100회선, 연강","면",1,{"$nulls":9},"508E42F1254F207FBBEF190D8B8D5E","","","010102","T","F","F",{"$nulls":23},"","",null,"010102508E42F1254F207FBBEF190D8B8D5E",47]
["전화기용배선반프레임","구내단자함, 중간단자함, 10회선, 연강","대",1,{"$nulls":9},"51B8B2A128448979F155F81A8880BC","","","010102","T","F","F",{"$nulls":23},"","",null,"01010251B8B2A128448979F155F81A8880BC",17]
["중간단자함","구내단자함, 50회선, 연강","면",1,{"$nulls":9},"508E42F1254F207FBBEF190D8B8D5D","","","010102","T","F","F",{"$nulls":23},"","",null,"010102508E42F1254F207FBBEF190D8B8D5D",46]
["전화기용배선반프레임","구내단자함, 중간단자함, 30회선, 연강","대",1,{"$nulls":9},"51B8B2A128448979F155F81A888143","","","010102","T","F","F",{"$nulls":23},"","",null,"01010251B8B2A128448979F155F81A888143",18]
{"$rows_empty":10}
["[ 합           계 ]",{"$nulls":12},"TOTAL"]
["010103  정보통신설비공사","",{"$nulls":14},"010103"]
["합성수지제가요전선관-노출","HI-LEX-PF(난연성), 16㎜","M",184,{"$nulls":9},"51763291224F257FC51B52661B74CA","","","010103","T","F","F",{"$nulls":23},"","",null,"01010351763291224F257FC51B52661B74CA",29]
["폴리에틸렌전선관-매입","PE, 36㎜","M",40,{"$nulls":9},"51763291224F257FC474E70DEDCBA6","","","010103","T","F","F",{"$nulls":23},"","",null,"01010351763291224F257FC474E70DEDCBA6",30]
["콘센트박스-매입","1개용, 54mm","개",12,{"$nulls":9},"506972F127434871C5DFB696978CD6","","","010103","T","F","F",{"$nulls":23},"","",null,"010103506972F127434871C5DFB696978CD6",31]
["옥외광섬유케이블","LAP외피광케이블, 광케이블, SM 9/125, 8C","M",24.72,{"$nulls":9},"51B8B2A128448979F155F81A89A4F2","","","010103","T","F","F",{"$nulls":23},"","",null,"01010351B8B2A128448979F155F81A89A4F2",24]
["동축케이블","TV수신용동축케이블, 고발포동축케이블, 5C-HFBT","M",98.9,{"$nulls":9},"51B8B2A128448979F155F81A89A6BF","","","010103","T","F","F",{"$nulls":23},"","",null,"01010351B8B2A128448979F155F81A89A6BF",23]
["네트워크케이블","UTP Cat. 6, 4P","M",197.8,{"$nulls":9},"51B8B2A128448979F155F81A89A598","","","010103","T","F","F",{"$nulls":23},"","",null,"01010351B8B2A128448979F155F81A89A598",26]
["리셉터클","콘센트, TV유닛, 1방","개",6,{"$nulls":9},"51B8B2A128448979F155F81A89A017","","","010103","T","F","F",{"$nulls":23},"","",null,"01010351B8B2A128448979F155F81A89A017",27]
["리셉터클","콘센트, 전화용, MODULAR 8P 2구","개",6,{"$nulls":9},"51B8B2A128448979F155F81A89AF9C","","","010103","T","F","F",{"$nulls":23},"","",null,"01010351B8B2A128448979F155F81A89AF9C",28]
{"$rows_empty":14}
["[ 합           계 ]",{"$nulls":12},"TOTAL"]
["010104  CCTV설비공사","",{"$nulls":14},"010104"]
["터파기/토사","보통, 굴삭기 0.7m3 90%, 인력10%","M3",5,{"$nulls":9},"511FA2112A40BD7FF0C9EC1A62BAE8","","","010104","F","T","F",{"$nulls":23},"","",null,"010104511FA2112A40BD7FF0C9EC1A62BAE8",39]
["경고테이프 포설","통신용","M",30,{"$nulls":9},"51763291224F637A9D21E84D59D55A","","","010104","T","F","F",{"$nulls":23},"","",null,"01010451763291224F637A9D21E84D59D55A",33]
["되메우기/토사, 두께 10cm","보통, 굴삭기 0.7m3+플레이트콤팩터 1.5ton+인력 10%","M3",5,{"$nulls":9},"511FA211274B4C7DD1E972268E5F42","","","010104","F","T","F",{"$nulls":23},"","",null,"010104511FA211274B4C7DD1E972268E5F42",53]
["폴리에틸렌전선관-매입","PE, 36㎜","M",30,{"$nulls":9},"506972F1274375764B6AC8B3E04E7E","","","010104","T","F","F",{"$nulls":23},"","",null,"010104506972F1274375764B6AC8B3E04E7E",52]
["1종금속제가요전선관-노출","16mm, 비방수","M",71,{"$nulls":9},"506972F1274375764B6D9FE69E6C14","","","010104","T","F","F",{"$nulls":23},"","",null,"010104506972F1274375764B6D9FE69E6C14",36]
["네트워크케이블","UTP Cat. 6, 4P","M",196.72499999999999,{"$nulls":9},"51B8B2A128448979F155F81A89A598","","","010104","T","F","F",{"$nulls":23},"","",null,"01010451B8B2A128448979F155F81A89A598",34]
["1종금속제가요전선관-노출","22mm, 비방수","M",20,{"$nulls":9},"506972F1274375764B6D9FE69E6B0D","","","010104","T","F","F",{"$nulls":23},"","",null,"010104506972F1274375764B6D9FE69E6B0D",37]
["1종금속제가요전선관-노출","고장력방수, 16mm","M",2,{"$nulls":9},"506972F1274375764B6D995D9264DC","","","010104","T","F","F",{"$nulls":23},"","",null,"010104506972F1274375764B6D995D9264DC",38]
{"$rows_empty":14}
["[ 합           계 ]",{"$nulls":12},"TOTAL"]

{"sheet":" 공사설정 ","index":3,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["이 Sheet는 수정하지 마십시요"]
["공사구분","D","타이틀"]
["확정내역","원내역"]
["자재단가적용",5]
["경비단가적용",5]
["품목코드형식","XXXX-XXXX-XXXXXXXXX"]
["내역금액소수점처리","C",1]
["일위대가내역소수점처리","C",2]
["단가명","조달청가격","거래가격","유통물가","조사가격1","조사가격2","TTTTT"]
["환율",1267,0,0]
["시간당작업량","R",4]
["1회 사이클시간","R",4]
["시간당 작업사이클","R",3]
["일반변수","R",5]
["시간당 노임산출 계수","A","1/8*16/12*25/20","1/8*16/12*25/20","1/8*16/12*25/20",1]
["재료비 할증 계수",1.1100000000000001,1.1200000000000001]
["노무비 할증 계수",1,1.5,1.1599999999999999,1.6,1.6,1.6,1.94,1.94,1.94,1,1,1]
["경비 할증 계수",1.25,1.071]
["내역,일위대가 품명,규격,단위 따로적용"]
["내역단가 소수점처리","C",1]
["코드","공종구분명","원가비목코드"]
[1,"작 업 부 산 물","A3"]
[2,"운    반    비","C1"]
[3,"관 급 자 재 비","DJ"]
[4,"사 급 자 재 비","D3"]
[5,"외    자    재",""]
[6,"...",""]
[7,"...",""]
[8,"...",""]
[9,"...",""]

{"sheet":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}