{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["원가계산서"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":21,"defined_names":599,"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":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[19,4,19,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[13,4,13,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[9,4,9,6],[10,4,10,6],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,11,5],[12,4,12,5],[0,0,0,6],[1,0,1,6],[4,4,4,6],[5,4,5,6],[5,13,8,13],[6,4,6,6],[7,4,7,6],[8,4,8,6]]}
["원  가  계  산  서"]
["공사명 : 광명시흥 도시첨단산업단지 조성공사                                                                                       공사기간 : 48개월"]
["공종","명칭","단위","합계","재료비","노무비","경비"]
["가.","순공사비계","식",{"$f":"SUM(E4:G4)","v":18380071599},6364432084,7271953990,4743685525,{"$f":"F4/D26","v":0.25074330378046883},{"$f":"F4/$D$26*100","v":25.074330378046884}]
[null,"1. 간 접 노 무 비                                                               ","식",{"$f":"ROUNDDOWN($F$4*13.8/100,0)","v":1003529650},"직접노무비×13.8％                                  "]
[null,"2. 산 재 보 험 료                                                               ","식",{"$f":"ROUNDDOWN(($F$4+$D$5)*0.037,0)","v":306192894},"(직접노무비+간접노무비)×3.7％                                                                 "]
[null,"3. 고 용 보 험 료                                                               ","식",{"$f":"ROUNDDOWN(($F$4+$D$5)*0.0103,0)","v":85237481},"(직접노무비+간접노무비)×1.03％                                                         "]
[null,"4. 건 강 보 험 료                                                               ","식",{"$f":"ROUNDDOWN($F$4*0.0343,0)","v":249428021},"직접노무비×3.43％                                                         "]
[null,"5. 연 금 보 험 료                                                               ","식",{"$f":"ROUNDDOWN($F$4*0.045,0)","v":327237929},"직접노무비×4.5％                                                           "]
[null,"6. 노인장기요양보험료                                                           ","식",{"$f":"ROUNDDOWN($D$8*0.1152,0)","v":28734108},"건강보험료×11.52％                                                      "]
[null,"7. 퇴직공제부금                                                                 ","식",{"$f":"ROUNDDOWN($F$4*0.023,0)","v":167254941},"직접노무비×2.30％                                                                "]
[null,"8. 산업안전보건관리비                                                           ","식",{"$f":"IF(G12<G13,G12,G13)","v":322364166},"A) (직노+재료비+도급자관급)×1.97％ = ",null,{"$f":"ROUNDDOWN(($F$4+$E$4+(D27/1.1/1.0054))*0.0197,0)","v":411075176}]
[{"$nulls":4},"B) (직노+재료비)×1.97％ ×1.2 = ",null,{"$f":"ROUNDDOWN((($F$4+$E$4)*0.0197)*1.2,0)","v":322364166}]
[null,"9. 하도급대금지급보증서발급수수료                                              ","식",{"$f":"ROUNDDOWN($D$4*0,0)","v":0},"직접공사비×0.075％                                                           "]
[null,"9. 건설기계대여대금지급보증서발급                                               ","식",{"$f":"ROUNDDOWN($D$4*0.004,0)","v":73520286},"직접공사비×0.40％                                                             "]
[null,"10. 환경보전비                                                              ","식",{"$f":"ROUNDDOWN(D4*0.006,0)","v":110280429},"직접공사비×0.60％                                                             "]
[null,"11. 기  타  경  비                                                              ","식",{"$f":"ROUNDDOWN(($F$4+$D$5+$E$4)*0.103,0)","v":1507911319},"(직접노무비+간접노무비+재료비)*10.3％                                                                 ",null,null,null,{"$f":"D17/$D$26*100","v":5.1994094909561506}]
[null,"12. 품 질 관 리 비                                                              ","식",390210137]
[]
["나.","소  계","      ",{"$f":"SUM(D4:D19)","v":22951972960},"                                                                                ",null,null,{"$f":"D20/D4","v":1.2487423042056454}]
[null,"13. 일 반 관 리 비                                                              ","식",{"$f":"ROUNDDOWN(D20*0.055,0)","v":1262358512},"(나. 소계)×5.5％                                                             ",null,null,"이윤조정",{"$f":"D21/$D$26*100","v":4.3527220371518967}]
[null,"14. 이          윤                                                              ","식",{"$f":"ROUND(($D$20+$D$21-$E$4)*0.12,0)-H22","v":2141987712},"(다. 소계 + 일반관리비 - 재료비)*12.0％",null,null,215,{"$f":"D22/$D$26*100","v":7.3857600901026528}]
[null,"15. 안 전 관 리비      ","식",8760816,"안전관리계획작성비, 정기안전점검비"]
["다.","총원가(공급가액)",null,{"$f":"SUM(D20:D23)","v":26365080000}]
[null,"16.부가가치세","식",{"$f":"ROUNDDOWN((D24)*0.1,-3)","v":2636508000},"공급가액*10%"]
["라.","도급공사비","      ",{"$f":"SUM(D24:D25)","v":29001588000}]
[null,"17. 지 급 자 재 비(도급자설치분)                                                              ","식",7996360000,null,null,null,"도급자설치도"]
[null,"18. 지 급 자 재 비(관급자설치분)                                                              ","식",566050000]
["마.","지급자재소계","      ",{"$f":"D27+D28","v":8562410000}]
["바","총공사비","      ",{"$f":"D26+D29","v":37563998000},null,null,null,"제경비요율"]
{"$rows_empty":11}
[{"$nulls":7},"재료비"]
[null,null,null,"합    계",null,"노무비",null,"단  가","경    비"]
[null,null,null,"단  가","금   액","단  가","금   액",null,"단  가"]
[{"$nulls":4},98316537,null,6129270]
[{"$nulls":4},10155897,null,6129270,457.5,null,"금   액"]
[null,null,null,2336.3000000000002,10155897,1410,6129270,null,468.8,90198514]
[{"$nulls":9},2037874]
[{"$nulls":9},2037874]