{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["용역 원가계산서","1. 직선보간법(설계용역비 산출)","2. 추가인증업무비용","3. 손해배상공제금액 산출"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":16,"defined_names":4733,"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":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,3],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3]]}
["용역비 원가계산서"]
[]
[]
["□ 용역명 : 경기도 대표도서관 건립사업 기본 및 실시설계 용역"]
["구 분","설계금액","산출기준","비고"]
[]
["□ 실시설계비",{"$f":"B8+B9","v":3878799485}]
["1. 경기도 대표도서관",{"$f":"'1. 직선보간법(설계용역비 산출)'!O24","v":3021898000},{"$f":"'1. 직선보간법(설계용역비 산출)'!B17&\"%\"","v":"5.174%"}]
["2. 추가인증업무비용",{"$f":"'2. 추가인증업무비용'!I20","v":856901485}]
["□ 손해배상공제료",{"$f":"B12","v":8073962.9545499999}]
[" 2. 손해배상공제료"]
["   - 실시설계",{"$f":"'3. 손해배상공제금액 산출'!M19","v":8073962.9545499999},"실시설계비 * 요율","손해배상공제요율"]
[]
["□ 공 급 가 액",{"$f":"B10+B7","v":3886873447.9545498}]
["□ 부  가  세",{"$f":"B14*0.1","v":388687344.79545498}]
[]
["□ 공 급 가 액 + 부  가  세",{"$f":"B14+B15","v":4275560792.7500048}]
[]
["설계용역비",{"$f":"ROUNDDOWN(B17,-6)","v":4275000000},"백만원미만절사"]

{"sheet":"1. 직선보간법(설계용역비 산출)","index":1,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,11,4,14],[11,12,11,13],[12,6,12,7],[12,12,12,13],[0,0,0,15],[8,5,8,16],[9,9,9,10],[9,12,9,13],[3,6,3,7],[3,11,3,14],[4,6,4,7],[23,0,23,2],[23,3,23,5],[23,7,23,8],[4,0,4,2],[21,0,21,16],[17,11,17,14],[15,9,15,10],[16,5,16,16],[15,6,15,7],[17,7,17,9],[13,6,13,7],[13,12,13,15],[20,11,20,14],[6,0,6,16],[7,6,7,7],[7,9,7,10],[32,1,32,11],[28,10,28,11],[29,10,30,11],[29,12,30,12],[30,1,30,3],[30,4,30,5],[30,6,30,7],[28,1,28,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[29,1,29,3],[29,4,29,5],[29,6,29,7],[29,8,30,9]]}
[" 설계비 산출내역(직선보간법)"]
[]
["□ 추정공사비"]
["  ○ 총공사비(부가가치세 제외) :",{"$nulls":5},64246000000,null,"÷",1.1000000000000001,"=",{"$f":"TRUNC(G4/J4,-3)","v":58405454000},null,null,null,"원"]
["    - 경기도 대표도서관",{"$nulls":5},{"$f":"G4","v":64246000000},null,"÷",1.1000000000000001,"=",58405454000,null,null,null,"원"]
[]
["    - 경기도 대표도서관  === > 설계비 요율 : 직선보간법(3종 복잡 상급 적용)"]
[{"$nulls":5},"(","x",null,"-","x2",null,") *","(","y1","-","y2",")"]
[null,"y","=","y1","-"," -------------------------------------------------------------------------------------------------------------------------------------------"]
[{"$nulls":9},"x1",null,"-","x2"]
[]
[null,"※","y :","기본 및 실시설계요율",{"$nulls":5},"y1 :","작은금액요율 :",null,5.19]
[null,null,"x :","당  해  금  액 :",null,null,{"$f":"L5","v":58405454000},null,null,"y2 :","큰 금 액 요 율 :",null,5.0999999999999996]
[null,null,"x1 :","큰    금     액 :",null,null,100000000000,null,null,"x2 :","작  은  금  액 :",null,50000000000]
[]
[{"$nulls":5},"(",{"$f":"G13","v":58405454000},null,"-",{"$f":"M14","v":50000000000},null,") *","(",{"$f":"M12","v":5.19},"-",{"$f":"M13","v":5.0999999999999996},")"]
[null,{"$f":"TRUNC(D17-(((G16-J16)*(N16-P16)/(H18-L18))),3)","v":5.1740000000000004},"=",{"$f":"M12","v":5.19},"-"," -------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"(적용요율)",{"$nulls":5},{"$f":"G14","v":100000000000},null,null,"-",{"$f":"M14","v":50000000000}]
[]
[]
["□ 설계금액",{"$nulls":8}," ",null," "]
[" ○ 설계금액  =  추정가격(부가가치세 제외)  x  설계요율"]
["   <기본 및 실시설계 설계>"]
["경기도 대표도서관",null,null,{"$f":"L5","v":58405454000},null,null,"(원)   ×",{"$f":"B17","v":5.1740000000000004},null,"(%)"," ×",1,"=",null,{"$f":"TRUNC(D24*H24/100*L24,-3)","v":3021898000},"원"]

{"sheet":"2. 추가인증업무비용","index":2,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,4,2,5],[2,6,2,7],[14,4,14,5],[15,1,15,2],[15,4,15,5],[12,4,12,5],[2,8,2,9],[2,10,2,11],[3,12,4,12],[4,6,4,7],[13,4,13,5],[21,4,21,5],[19,11,19,12],[6,1,6,12],[8,4,8,5],[3,1,3,3],[3,4,3,5],[3,6,3,7],[3,8,4,9],[3,10,4,11],[4,1,4,3],[4,4,4,5],[16,4,16,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[17,4,17,5]]}
["□ 각종 인증에 따른 추가업무비용"]
[{"$nulls":12},"단위 : 원"]
[null,"구   분",null,null,"계 획",null,"업무대가",null,"적용률",null,"추가업무비용",null,"비 고"]
[null,"1. 녹색건축물물 인증",null,null,"최우수",null,9.5000000000000001E-2,null,{"$f":"G4+G5/2","v":0.13250000000000001},null,{"$f":"I4*'1. 직선보간법(설계용역비 산출)'!O24","v":400401485}]
[null,"2. 에너지효율등급 인증",null,null,"1등급",null,7.4999999999999997E-2]
[]
[null,"* 추가설계대가 요율 = A + 1/2 B = 9.5 + 7.5/2 = 13.25%\n  A : 친환경건축물, 지능형건축물, 에너지효율등급 인증관련 설계 추가요율 중 최상위값 = 9.5%\n  B : 친환경건축물, 지능형건축물, 에너지효율등급 인증관련 설계 추가요율 중 차상위값 = 7.5%\n  C : 친환경건축물, 지능형건축물, 에너지효율등급 인증관련 설계 추가요율 중 최하위값 = 7.0%"]
[]
[null,"3. 지열시험천공",null,":",22000000,null,"원","(견적가, VAT제외)"]
[null,"4. 지반조사",null,":",25000000,null,"원","(견적가, VAT제외)"]
[null,"5. 설계안전성검토",null,":",9500000,null,"원","(견적가, VAT제외)"]
[null,"6. 에너지절약계획서",null,":",7000000,null,"원","(견적가, VAT제외)"]
[null,"7. BF 인증",null,":",15000000,null,"원","(견적가, VAT제외)"]
[null,"8. 제로에너지인증",null,":",17000000,null,"원","(견적가, VAT제외)"]
[null,"9. 성능위주설계",null,":",40000000,null,"원","(견적가, VAT제외)"]
[null,"10. 사전재난영향성 검토",null,":",90000000,null,"원","(견적가, VAT제외)"]
[null,"11. 입찰안내서 작성",null,":",20000000,null,"원","(견적가, VAT제외)"]
[null,"12. BIM 설계",null,":",211000000,null,"원","(견적가, VAT제외)"]
[]
[null,"※ 추가 인증업무비용",{"$nulls":6},{"$f":"K4+SUM(E9:F18)","v":856901485},"원"]

{"sheet":"3. 손해배상공제금액 산출","index":3,"n_rows":19,"n_cols":43,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,13,3,17],[17,1,17,6],[17,8,17,10],[17,14,17,16],[17,20,17,24],[15,20,15,24],[16,20,16,24],[13,1,13,6],[13,8,13,10],[13,14,13,16],[13,20,13,24],[14,1,14,6],[14,8,14,10],[14,14,14,16],[14,20,14,24],[8,21,8,23],[18,1,18,11],[18,12,18,17],[15,1,15,6],[15,8,15,10],[15,14,15,16],[16,1,16,6],[16,8,16,10],[16,14,16,16],[9,42,9,47],[10,6,10,11],[10,12,10,17],[10,18,10,23],[10,24,10,29],[10,30,10,35],[10,36,10,41],[9,24,9,26],[9,27,9,29],[9,30,9,32],[9,33,9,35],[9,36,9,38],[9,39,9,41],[9,18,9,20],[9,21,9,23],[9,0,9,5],[9,6,9,8],[9,9,9,11],[9,12,9,14],[9,15,9,17],[8,6,8,8],[8,9,8,11],[8,12,8,14],[8,15,8,17],[8,18,8,20],[7,36,7,41],[8,24,8,26],[8,27,8,29],[8,30,8,32],[8,33,8,35],[8,36,8,38],[8,39,8,41],[1,0,1,47],[4,13,4,17],[4,26,4,29],[5,0,8,5],[5,6,5,47],[6,6,7,11],[6,12,6,17],[6,18,6,23],[6,24,6,29],[6,30,6,35],[6,36,6,41],[6,42,8,47],[7,12,7,17],[7,18,7,23],[7,24,7,29],[7,30,7,35]]}
[]
["손해배상공제요율"]
[]
["■","기본 및 실시설계용역",{"$nulls":6},"(","순계약금액",null,null,null,{"$f":"'용역 원가계산서'!B7","v":3878799485},{"$nulls":4},"원)"]
["■","실시설계용역(용역비의 50%)",{"$nulls":6},"(","순계약금액",null,null,null,{"$f":"'용역 원가계산서'!B7*50%","v":1939399742.5},{"$nulls":4},"원)",null,null,"(","용역기간",null,null,null,"11개월",null,null,null,")"]
["구 분",{"$nulls":5},"용역금액(계약금액)"]
[{"$nulls":6},"5억원 이하",{"$nulls":5},"5억원 초과",{"$nulls":5},"10억원 초과",{"$nulls":5},"20억원 초과",{"$nulls":5},"30억원 초과",{"$nulls":5},"50억원 초과",{"$nulls":5},"표준공사기간"]
[{"$nulls":12},"10억원 이하",{"$nulls":5},"20억원 이하",{"$nulls":5},"30억원 이하",{"$nulls":5},"50억원 이하",{"$nulls":5},"구득요율 적용"]
[{"$nulls":6},"기본요율",null,null,"가산요율",null,null,"기본요율",null,null,"가산요율",null,null,"기본요율",null,null,"가산요율",null,null,"기본요율",null,null,"가산요율",null,null,"기본요율",null,null,"가산요율"]
["관람집회시설공사",{"$nulls":5},0.432,null,null,6.9000000000000006E-2,null,null,0.42,null,null,6.8000000000000005E-2,null,null,0.40600000000000003,null,null,6.5000000000000002E-2,null,null,0.39400000000000002,null,null,6.3E-2,null,null,0.38200000000000001,null,null,6.2E-2,{"$nulls":8},"3년"]
[{"$nulls":6},500000000,{"$nulls":5},500000000,{"$nulls":5},{"$f":"N5-G11-M11","v":939399742.5},{"$nulls":5},{"$f":"N5-S11-M11-G11","v":0}]
["■ 공제료 계산"]
["(산식)",null,null,"순계약금액 × { 기본요율 ＋ ( 표준담보기간초과일수/365)}"]
[null,{"$f":"G11","v":500000000},{"$nulls":5},"×{",{"$f":"G10","v":0.432},null,null,"＋(",0,"÷","365 ) }",{"$nulls":4},"=",{"$f":"B14*I14%","v":2160000}]
[null,{"$f":"M11","v":500000000},{"$nulls":5},"×(",{"$f":"M10","v":0.42},null,null,"＋(",0,"÷","365 ) }",{"$nulls":4},"=",{"$f":"B15*I15%","v":2100000}]
[null,{"$f":"S11","v":939399742.5},{"$nulls":5},"×(",{"$f":"S10","v":0.40600000000000003},null,null,"＋(",0,"÷","365 ) }",{"$nulls":4},"=",{"$f":"B16*I16%","v":3813962.9545500004}]
[null,{"$f":"Y11","v":0},{"$nulls":5},"×(",{"$f":"Y10","v":0.39400000000000002},null,null,"＋(",0,"÷","365 ) }",{"$nulls":4},"=",{"$f":"B17*I17%","v":0}]
[null,{"$f":"AE11","v":0},{"$nulls":5},"×(",{"$f":"AE10","v":0.38200000000000001},null,null,"＋(",0,"÷","365 ) }",{"$nulls":4},"=",{"$f":"B18*I18%","v":0}]
[null,"계 금 액",{"$nulls":10},{"$f":"SUM(U14:X18)","v":8073962.9545499999}]