{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["원가","총괄표","내역서"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,0,25,2],[19,1,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[0,0,0,4],[2,0,2,1],[2,2,2,3],[3,0,3,1],[4,1,6,1],[7,1,9,1]]}
["원 가 계 산 서"]
[]
["공사명:",null,"[ 부천대학교 몽당도서관 창의복합 문화공간 전기공사 ]",null,"공사기간: 28일"]
["비 목",null,"구  분","금 액","구  성  비"," "]
[null,"재 료 비","직 접 재 료 비",null,null,null," "]
[null,null,"간 접 재 료 비"]
[" ",null,"( 소      계 )"]
["순","노 무 비","직 접 노 무 비"]
[null,null,"간 접 노 무 비",null,"(직접 노무비) * 13 %"]
[null,null,"( 소      계 )"]
[" ",null,"산 재 보 험 료",null,"(노무비) * 3.7 %"]
[null,null,"고 용 보 험 료",null,"(노무비) * 1.01 %"]
["공",null,"퇴 직 금 공 제",null,"(직접 노무비) * 2.3 %"]
[null,"경","안 전 관 리 비",null,"(재료+직노) * 2.93 %"]
[" ",null,"기  타  경  비",null,"(재료+노무) * 5.8 %"]
[null,null,"건 강 보 험 료",null,"(직접 노무비) * 3.495 %"]
[null,null,"연 금 보 험 료",null,"(직접 노무비) * 4.5 %"]
["사",null,"노인장기요양보험",null,"(건강 보험료) * 12.27 %"]
[null,null,"( 소      계 )"]
[null,"( 순 공 사 비 계 )"]
["일 반 관 리 비",null,null,null,"(재료+노무+경비) * 6 %"]
["이          윤",null,null,null,"(노무+경비+일반관리비) * 15 %"]
["( 총  원  가 )"]
["부 가 가 치 세"]
[" "]
["( 총      계 )"]

{"sheet":"총괄표","index":1,"n_rows":55,"n_cols":27,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,12,1,13],[1,15,2,15],[1,16,2,16],[3,3,3,16],[29,3,29,16],[0,3,0,16],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,1,8],[1,9,1,11]]}
["총줄수->","55",null,"[ 부천대학교 몽당도서관 창의복합 문화공간 전기공사 ]",{"$nulls":22},"연속견적가로형식"]
["번호","공종코드","…","공   종   명","규격","단위","수량","재료비",null,"노무비",null,null,"경비",null,null,"계","비고"]
[{"$nulls":7},"단가","금액","수량","단가","금액","단가","금액","단가"]
[null,"공종줄",null,"몽당도서관 2층 전기공사"]
[null,"01",null,"1.전기공사",null,"식",1,{"$nulls":9}," "]
{"$rows_empty":23}
[null,null,"Total","( 합       계 )",{"$nulls":4},{"$f":"TRUNC(SUM(I4:I28))","v":0},null,null,{"$f":"TRUNC(SUM(L4:L28))","v":0},null,{"$f":"TRUNC(SUM(N4:N28))","v":0},{"$f":"IF((H29+K29+M29)=0, \"\", (H29+K29+M29))","v":""},{"$f":"TRUNC(SUM(P4:P28))","v":0}]
[null,"공종줄",null,"1.전기공사"]
[null,"0101",null,"1-1.철거 및 간선공사",null,"식",1,{"$f":"내역서!I29","v":0},{"$f":"G31*H31","v":0},null,{"$f":"내역서!L29","v":0},{"$f":"G31*K31","v":0},{"$f":"내역서!N29","v":0},{"$f":"G31*M31","v":0},{"$f":"IF((H31+K31+M31)=0, \"\", (H31+K31+M31))","v":""},{"$f":"SUM(I31,L31,N31)","v":0}]
[null,"0102",null,"1-2.전등공사",null,"식",1,{"$f":"내역서!I66","v":0},{"$f":"G32*H32","v":0},null,{"$f":"내역서!L66","v":0},{"$f":"G32*K32","v":0},{"$f":"내역서!N66","v":0},{"$f":"G32*M32","v":0},{"$f":"IF((H32+K32+M32)=0, \"\", (H32+K32+M32))","v":""},{"$f":"SUM(I32,L32,N32)","v":0}]
[null,"0103",null,"1-3.전열공사",null,"식",1,{"$f":"내역서!I89","v":0},{"$f":"G33*H33","v":0},null,{"$f":"내역서!L89","v":0},{"$f":"G33*K33","v":0},{"$f":"내역서!N89","v":0},{"$f":"G33*M33","v":0},{"$f":"IF((H33+K33+M33)=0, \"\", (H33+K33+M33))","v":""},{"$f":"SUM(I33,L33,N33)","v":0}]
{"$rows_empty":21}
[null,"01","Total","( 합       계 )",{"$nulls":4},{"$f":"TRUNC(SUM(I30:I54))","v":0},null,null,{"$f":"TRUNC(SUM(L30:L54))","v":0},null,{"$f":"TRUNC(SUM(N30:N54))","v":0},{"$f":"IF((H55+K55+M55)=0, \"\", (H55+K55+M55))","v":""},{"$f":"TRUNC(SUM(P30:P54))","v":0}]

{"sheet":"내역서","index":2,"n_rows":89,"n_cols":17,"rows_kept":89,"cut":false,"hidden":false,"merged":[[67,3,67,16],[1,9,1,11],[1,12,1,13],[1,15,2,15],[1,16,2,16],[3,3,3,16],[30,3,30,16],[0,3,0,13],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,1,8]]}
["총줄수->","107",null,"[ 부천대학교 몽당도서관 창의복합 문화공간 전기공사 ]"]
["번호","공종코드","코드","명   칭","규   격","단위","수량","재료비",null,"노무비",null,null,"경비",null,null,"계","비고"]
[{"$nulls":7},"단가","금액","수량","단가","금액","단가","금액","단가"]
[null,"공종줄",null,"1.전기공사::1-1.철거 및 간선공사"]
["MM919414817","0101","391115ZZ701Z0004","철거",null,"식",1,{"$nulls":7},{"$f":"IF((H5+K5+M5)=0, \"\", (H5+K5+M5))","v":""},{"$f":"SUM(I5,L5,N5)","v":0}]
["56959000001","0101","E56959000001","분전반 LP-2A 속판교체",null,"면",1,{"$nulls":7},"",0]
["56959000002","0101","E56959000002","분전반 LP-2B 신설",null,"면",1,{"$nulls":7},"",0]
["56959000003","0101","E56959000003","분전반 P-3A 신설",null,"면",1,{"$nulls":7},"",0]
["59753017028","0101","3913170620174427","1종금속제가요전선관","54 mm 일반-방수","M",15]
["59753017026","0101","3913170620174425","1종금속제가요전선관","36 mm 일반-방수","M",20]
["59753017068","0101","3913170620174451","1종금속제가요전선관","커넥터, 54 mm 일반-방수","개",2]
["59753017066","0101","3913170620174449","1종금속제가요전선관","커넥터, 36 mm 일반-방수","개",2]
["59753857211","0101","3912130320174775","풀박스","600×600×300","개",1]
["E1450287509","0101","2612162920683889","폴리에틸렌 난연케이블","0.6/1kv F-CV 1C×50㎟","M",160]
["E1450287566","0101","2612162920683948","폴리에틸렌 난연케이블","0.6/1kv F-CV 4C×25㎟","M",20]
["E1450287565","0101","2612162920683947","폴리에틸렌 난연케이블","0.6/1kv F-CV 4C×16㎟","M",39]
["E1450287564","0101","2612162920683946","폴리에틸렌 난연케이블","0.6/1kv F-CV 4C×10㎟","M",15]
["E9400267009","0101","3912143221650914","압착단자","R형동선 나압착 50 ㎟","개",8]
["E9400267007","0101","3912143221650912","압착단자","R형동선 나압착 25 ㎟","개",16]
["E9400267006","0101","3912143221650911","압착단자","R형동선 나압착 16 ㎟","개",8]
["E9400267005","0101","3912143221650910","압착단자","R형동선 나압착 10 ㎟","개",8]
["E1450927208","0101","2612152420683701","접지용비닐절연전선(F-GV)","35㎟","M",40]
["A0500000000","0101","RENT000000000002","[ 배관 부속재 ]","전선관의 15 %","식",1]
["A0100000000","0101","RENT000000000003","[ 소모 잡자재 ]","전선, 전선관의 2 %","식",1]
["56900017016","0101","L001010101000075","노 무 비","내선전공","인",5]
["56900017076","0101","L001010101000078","노 무 비","저압케이블전공","인",10]
["A0300000000","0101","RENT000000000006","[ 공 구 손 료 ]","노무비의 3 %","식",1]
[]
[null,"합계줄",null,"( 합       계 )"]
[]
[null,"공종줄",null,"1.전기공사::1-2.전등공사"]
["59750897011","0102","3913170910034920","레이스웨이","BODY, 70 x 40","M",198]
["59750897041","0102","3913170910034923","레이스웨이","COVER, 70 x 40","M",198]
["59750897131","0102","3913170910034932","레이스웨이","수평 L ELBOW, 70 x 40","개",1]
["59750897131","0102","3913170910034932","레이스웨이","수평 T ELBOW, 70 x 40","개",3]
["MM404608480","0102","3912120310035833","레이스웨이","수평 + ELBOW, 70 x 40","개",3]
["59750897131","0102","3913170910034932","레이스웨이","HOR + ELBOW,, 70 x 40","개",2]
["59750897131","0102","3913170910034932","레이스웨이","수직 ELBOW, , 70 x 40","개",2]
["59753017023","0102","3913170620174422","1종금속제가요전선관","16 mm 일반-방수","M",552]
["59753017063","0102","3913170620174446","1종금속제가요전선관","커넥터, 16 mm 일반-방수","개",403]
["59753777102","0102","3912130610035778","스위치박스","1 개용 54 mm","개",9]
["59753777111","0102","3912130610035781","스위치박스","2 개용 54 mm","개",3]
["MM481669624","0102","2612162922076727","450/750V 내열비닐절연전선","HFIX 1.78mm(2.5㎟)","M",2100]
["59301517001","0102","3912998720170517","매입스위치","250V 1로1구","개",1]
["59301517002","0102","3912998720170518","매입스위치","250V 1로2구","개",3]
["59301517003","0102","3912998720170519","매입스위치","250V 1로3구","개",5]
["59301517004","0102","3912998720170520","매입스위치","250V 1로4구","개",3]
["MM700089002","0102","3910160520230002","라인조명","LED L:2,000","EA",8,{"$nulls":9},"관급자재"]
[null,null,null,"라인조명","LED L:1800","EA",18,{"$nulls":9},"관급자재"]
["MM700089002","0102","3910160520230002","라인조명","LED L:1,500","EA",8,{"$nulls":9},"관급자재"]
["MM700097001","0102","3910160520310001","매직보드 간접조명","LED BAR","M",6.07,{"$nulls":9},"관급자재"]
[null,null,null,"LED BAR","LED 12V 15W / 각 2줄","M",138.69999999999999,{"$nulls":9},"관급자재"]
[null,null,null,"평판등","LED 600*600","EA",13,{"$nulls":9},"관급자재"]
[null,null,null,"원형 매입등","원형 매입등","EA",48,{"$nulls":9},"관급자재"]
[null,null,null,"1구 사각 매입등",null,"EA",4,{"$nulls":9},"관급자재"]
[null,null,null,"라인등","LED 56W 4000K L: 1000","EA",16,{"$nulls":9},"관급자재"]
[null,null,null,"라인등","LED 23W 4000K L:1500","M",39,{"$nulls":9},"관급자재"]
[null,null,null,"2구매입등",null,"EA",11,{"$nulls":9},"관급자재"]
["MM700095004","0102","3910160520290004","LED 책상등",null,"개",68,{"$nulls":9},"관급자재"]
["56953100925","0102","EAB110520000","MDF재질 구멍따기","각종두께","개소",43]
["A0500000000","0102","RENT000000000002","[ 배관 부속재 ]","전선관의 15 %","식",1]
["A0100000000","0102","RENT000000000003","[ 소모 잡자재 ]","전선, 전선관의 2 %","식",1]
["56900017016","0102","L001010101000075","노 무 비","내선전공","인",82]
["A0300000000","0102","RENT000000000006","[ 공 구 손 료 ]","노무비의 3 %","식",1]
[]
[null,"합계줄",null,"( 합       계 )"]
[]
[null,"공종줄",null,"1.전기공사::1-3.전열공사"]
["59750897011","0103","3913170910034920","레이스웨이","BODY, 70 x 40","M",159]
["59750897041","0103","3913170910034923","레이스웨이","COVER, 70 x 40","M",159]
["59750897131","0103","3913170910034932","레이스웨이","수평 T ELBOW, 70 x 40","개",4]
["MM404608480","0103","3912120310035833","레이스웨이","수평 + ELBOW, 70 x 40","개",2]
["59750897131","0103","3913170910034932","레이스웨이","HOR + ELBOW,, 70 x 40","개",2]
["59750897131","0103","3913170910034932","레이스웨이","수직 ELBOW, , 70 x 40","개",2]
["59753017023","0103","3913170620174422","1종금속제가요전선관","16 mm 일반-방수","M",189]
["59753017063","0103","3913170620174446","1종금속제가요전선관","커넥터, 16 mm 일반-방수","개",252]
["EKK53000002","0103","EKK530000002","시스템박스","ACCESS FLOOR용 4구","개",4]
["EKK53000102","0103","EKK530001002","시스템박스","ACCESS FLOOR용 2구","개",18]
["MM300040259","0103","3912130610035785","스위치박스","승압용 54mm","개",44]
["E1450667003","0103","2612162922076728","450/750V 내열비닐절연전선","HFIX 2.25mm(4㎟)","M",1197]
["59350317205","0103","3912140620170849","콘센트","매입-접지형, 250V 1구","개",7]
["59350317206","0103","3912140620170850","콘센트","매입-접지형, 250V 2구","개",41]
["59350317206","0103","3912140620170850","콘센트+무선충전","250V 2구, 무 250V 2구","개",50,{"$nulls":9},"관급자재"]
["A0500000000","0103","RENT000000000002","[ 배관 부속재 ]","전선관의 15 %","식",1]
["A0100000000","0103","RENT000000000003","[ 소모 잡자재 ]","전선, 전선관의 2 %","식",1]
["56900017016","0103","L001010101000075","노 무 비","내선전공","인",48]
["A0300000000","0103","RENT000000000006","[ 공 구 손 료 ]","노무비의 3 %","식",1]
[]
[null,"합계줄",null,"( 합       계 )"]