{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["용역 원가계산서","1. 신사옥_직선보간법(설계용역비 산출)","2. 신사옥_추가업무비용","3. 복합시설관_직선보간법(설계용역비 산출)","4. 복합시설관_추가업무비용"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":16,"defined_names":11060,"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":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,0,20,3],[0,0,0,3],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3]]}
["용역비 원가계산서"]
[]
[]
["□ 용역명 : 경기도시공사 융복합센터(신사옥, 복합시설관) 계획 및 중간설계 용역"]
["구 분","설계금액","산출기준","비고"]
[]
["□ 신사옥",{"$f":"B8+B9","v":2068486237.5}]
["1. 계획 및 중간설계비",{"$f":"'1. 신사옥_직선보간법(설계용역비 산출)'!O25","v":1604245000},"3.904% * 60%(계획 및 중간설계)"]
["2. 추가업무비용",{"$f":"'2. 신사옥_추가업무비용'!I20","v":464241237.5}]
["□ 복합시설관",{"$f":"B11+B12","v":844375135}]
["1. 계획 및 중간설계비",{"$f":"'3. 복합시설관_직선보간법(설계용역비 산출)'!O25","v":630754000},"4.025% * 60%(계획 및 중간설계)"]
["2. 추가업무비용",{"$f":"'4. 복합시설관_추가업무비용'!I19","v":213621135}]
[]
["□ 공 급 가 액",{"$f":"B10+B7","v":2912861372.5}]
["□ 부  가  세",{"$f":"B14*0.1","v":291286137.25}]
[]
["□ 공 급 가 액 + 부  가  세",{"$f":"B14+B15","v":3204147509.75}]
[]
["설계용역비",{"$f":"ROUNDDOWN(B17,-6)","v":3204000000},"백만원 미만절사"]
[]
["※ 본 용역의 과업범위는 기본설계 용역(계획 및 중간설계)으로\n    건설기술진흥법 시행령 제50조 2항 2호에 의거 손해배상공제보험 가입대상이 아님"]

{"sheet":"1. 신사옥_직선보간법(설계용역비 산출)","index":1,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[[5,11,5,14],[12,12,12,13],[13,6,13,7],[13,12,13,13],[0,0,0,15],[9,5,9,16],[10,9,10,10],[10,12,10,13],[4,6,4,7],[5,6,5,7],[24,0,24,2],[24,3,24,5],[24,7,24,8],[5,0,5,2],[22,0,22,16],[18,11,18,14],[16,9,16,10],[17,5,17,16],[16,6,16,7],[18,7,18,9],[14,6,14,7],[14,12,14,15],[21,11,21,14],[7,0,7,16],[8,6,8,7],[8,9,8,10],[26,12,26,13],[33,1,33,11],[29,10,29,11],[30,10,31,11],[30,12,31,12],[31,1,31,3],[31,4,31,5],[31,6,31,7],[29,1,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[30,1,30,3],[30,4,30,5],[30,6,30,7],[30,8,31,9]]}
[" 설계비 산출내역(직선보간법)"]
[]
["□ 추정공사비"]
[]
["  ○ 추정가격(부가가치세 제외) :"]
["    - 신사옥",{"$nulls":5},75336000000,null,"÷",1.1000000000000001,"=",{"$f":"TRUNC(G6/J6,-3)","v":68487272000},null,null,null,"원"]
[]
["    - 신사옥  === > 설계비 요율 : 직선보간법(2종 보통 상급 적용)"]
[{"$nulls":5},"(","x",null,"-","x2",null,") *","(","y1","-","y2",")"]
[null,"y","=","y1","-"," -------------------------------------------------------------------------------------------------------------------------------------------"]
[{"$nulls":9},"x1",null,"-","x2"]
[]
[null,"※","y :","기본 및 실시설계요율",{"$nulls":5},"y1 :","작은금액요율 :",null,3.93]
[null,null,"x :","당  해  금  액 :",null,null,{"$f":"L6","v":68487272000},null,null,"y2 :","큰 금 액 요 율 :",null,3.86]
[null,null,"x1 :","큰    금     액 :",null,null,100000000000,null,null,"x2 :","작  은  금  액 :",null,50000000000]
[]
[{"$nulls":5},"(",{"$f":"G14","v":68487272000},null,"-",{"$f":"M15","v":50000000000},null,") *","(",{"$f":"M13","v":3.93},"-",{"$f":"M14","v":3.86},")"]
[null,{"$f":"TRUNC(D18-(((G17-J17)*(N17-P17)/(H19-L19))),3)","v":3.9039999999999999},"=",{"$f":"M13","v":3.93},"-"," -------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"(적용요율)",{"$nulls":5},{"$f":"G15","v":100000000000},null,null,"-",{"$f":"M15","v":50000000000}]
[]
[]
["□ 설계금액",{"$nulls":8}," ",null," "]
[" ○ 설계금액  =  추정가격(부가가치세 제외)  x  설계요율  x  업무비율"]
["   <계획 및 중간 설계>"]
["신사옥",null,null,{"$f":"L6","v":68487272000},null,null,"(원)   ×",{"$f":"B18","v":3.9039999999999999},null,"(%)"," ×",0.6,"=",null,{"$f":"TRUNC(D25*H25/100*L25,-3)","v":1604245000},"원"]
[]
[{"$nulls":12},"기본 및 실시설계 용역 비용산정",null,{"$f":"D25*4.686%","v":3209313565.9200001}]

{"sheet":"2. 신사옥_추가업무비용","index":2,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,8,2,9],[2,10,2,11],[3,12,4,12],[4,6,4,7],[2,1,2,3],[2,4,2,5],[2,6,2,7],[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],[9,4,9,5],[10,4,10,5],[19,11,19,12],[6,1,6,12],[11,4,11,5],[15,4,15,5],[12,4,12,5],[13,4,13,5],[17,4,17,5],[16,4,16,5],[8,4,8,5],[14,1,14,2],[14,4,14,5]]}
["□ 각종 인증에 따른 추가업무비용"]
[{"$nulls":12},"단위 : 원"]
[null,"구   분",null,null,"계 획",null,"업무대가",null,"적용률",null,"추가업무비용",null,"비 고"]
[null,"1. 녹색건축물물 인증",null,null,"우수등급",null,0.09,null,{"$f":"G4+G5/2","v":0.1275},null,{"$f":"I4*'1. 신사옥_직선보간법(설계용역비 산출)'!O25","v":204541237.5}]
[null,"2. 에너지효율등급 인증",null,null,"1등급",null,7.4999999999999997E-2]
[]
[null,"* 추가설계대가 요율 = A + 1/2 B = 9.0 + 7.5/2 = 12.75%\n  A : 친환경건축물, 지능형건축물, 에너지효율등급 인증관련 설계 추가요율 중 최상위값 = 9.0%\n  B : 친환경건축물, 지능형건축물, 에너지효율등급 인증관련 설계 추가요율 중 차상위값 = 7.5%"]
[]
[null,"3. 지열시험천공",null,":",20000000,null,"원","(견적가, VAT제외)"]
[null,"4. 지반조사",null,":",27700000,null,"원","(견적가, VAT제외)"]
[null,"5. 설계안전성검토",null,":",10000000,null,"원","(견적가, VAT제외)"]
[null,"6.에너지절약계획서",null,":",6000000,null,"원","(견적가, VAT제외)"]
[null,"7. BF 인증",null,":",10000000,null,"원","(견적가, VAT제외)"]
[null,"8. 성능위주설계",null,":",45000000,null,"원","(견적가, VAT제외)"]
[null,"9. 사전재난영향성 검토",null,":",90000000,null,"원","(복합시설관 통합, 견적가, VAT제외)"]
[null,"10. 조감토 투시도 CG",null,":",9000000,null,"원","(견적가, VAT제외)"]
[null,"11. 모형제작",null,null,12000000,null,"원","(견적가, VAT제외)"]
[null,"12. 입찰안내서 작성",null,":",30000000,null,"원","(복합시설관 통합, 견적가, VAT제외)"]
[]
[null,"※ 추가 업무비용",{"$nulls":6},{"$f":"K4+E12+E13+E14+E16+E17+E18+E9+E10+E11+E15","v":464241237.5},"원"]
[]
[]
[]
[{"$nulls":8},{"$f":"E9+E10+E11+E12+E13+E14+E16+E17+E18","v":169700000}]

{"sheet":"3. 복합시설관_직선보간법(설계용역비 산출)","index":3,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,15],[12,12,12,13],[4,6,4,7],[5,0,5,2],[5,6,5,7],[5,11,5,14],[7,0,7,16],[8,6,8,7],[8,9,8,10],[9,5,9,16],[10,9,10,10],[10,12,10,13],[24,0,24,2],[24,3,24,5],[24,7,24,8],[13,6,13,7],[13,12,13,13],[14,6,14,7],[14,12,14,15],[16,6,16,7],[16,9,16,10],[17,5,17,16],[18,7,18,9],[18,11,18,14],[21,11,21,14],[22,0,22,16],[33,1,33,11],[30,1,30,3],[30,4,30,5],[30,6,30,7],[30,8,31,9],[30,10,31,11],[26,12,26,13],[30,12,31,12],[31,1,31,3],[31,4,31,5],[31,6,31,7],[29,1,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11]]}
[" 설계비 산출내역(직선보간법)"]
[]
["□ 추정공사비"]
[]
["  ○ 추정가격(부가가치세 제외) :"]
["    - 복합시설관",{"$nulls":5},28730000000,null,"÷",1.1000000000000001,"=",{"$f":"TRUNC(G6/J6,-3)","v":26118181000},null,null,null,"원"]
[]
["    - 복합시설관  === > 설계비 요율 : 직선보간법(2종 보통 상급 적용)"]
[{"$nulls":5},"(","x",null,"-","x2",null,") *","(","y1","-","y2",")"]
[null,"y","=","y1","-"," -------------------------------------------------------------------------------------------------------------------------------------------"]
[{"$nulls":9},"x1",null,"-","x2"]
[]
[null,"※","y :","기본 및 실시설계요율",{"$nulls":5},"y1 :","작은금액요율 :",null,4.01]
[null,null,"x :","당  해  금  액 :",null,null,{"$f":"L6","v":26118181000},null,null,"y2 :","큰 금 액 요 율 :",null,3.93]
[null,null,"x1 :","큰    금     액 :",null,null,50000000000,null,null,"x2 :","작  은  금  액 :",null,30000000000]
[]
[{"$nulls":5},"(",{"$f":"G14","v":26118181000},null,"-",{"$f":"M15","v":30000000000},null,") *","(",{"$f":"M13","v":4.01},"-",{"$f":"M14","v":3.93},")"]
[null,{"$f":"TRUNC(D18-(((G17-J17)*(N17-P17)/(H19-L19))),3)","v":4.0250000000000004},"=",{"$f":"M13","v":4.01},"-"," -------------------------------------------------------------------------------------------------------------------------------------------"]
[null,"(적용요율)",{"$nulls":5},{"$f":"G15","v":50000000000},null,null,"-",{"$f":"M15","v":30000000000}]
[]
[]
["□ 설계금액",{"$nulls":8}," ",null," "]
[" ○ 설계금액  =  추정가격(부가가치세 제외)  x  설계요율  x  업무비율"]
["   <계획 및 중간 설계>"]
["복합시설관",null,null,{"$f":"L6","v":26118181000},null,null,"(원)   ×",{"$f":"B18","v":4.0250000000000004},null,"(%)"," ×",0.6,"=",null,{"$f":"TRUNC(D25*H25/100*L25,-3)","v":630754000},"원"]
[]
[{"$nulls":12},"기본 및 실시설계용역 비용산정",null,{"$f":"D25*4.826%","v":1260463415.0599999}]

{"sheet":"4. 복합시설관_추가업무비용","index":4,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,12,4,12],[6,1,6,12],[8,4,8,5],[16,4,16,5],[2,8,2,9],[2,10,2,11],[10,4,10,5],[3,8,4,9],[3,10,4,11],[18,11,18,12],[2,1,2,3],[2,4,2,5],[2,6,2,7],[11,4,11,5],[4,1,4,3],[4,4,4,5],[4,6,4,7],[3,1,3,3],[3,4,3,5],[3,6,3,7],[13,4,13,5],[14,4,14,5],[12,4,12,5],[9,4,9,5],[15,4,15,5]]}
["□ 각종 인증에 따른 추가업무비용"]
[{"$nulls":12},"단위 : 원"]
[null,"구   분",null,null,"계 획",null,"업무대가",null,"적용률",null,"추가업무비용",null,"비 고"]
[null,"1. 녹색건축물물 인증",null,null,"우수등급",null,0.09,null,{"$f":"G4+G5/2","v":0.1275},null,{"$f":"I4*'3. 복합시설관_직선보간법(설계용역비 산출)'!O25","v":80421135}]
[null,"2. 에너지효율등급 인증",null,null,"1등급",null,7.4999999999999997E-2]
[]
[null,"* 추가설계대가 요율 = A + 1/2 B = 9.0 + 7.5/2 = 12.75%\n  A : 친환경건축물, 지능형건축물, 에너지효율등급 인증관련 설계 추가요율 중 최상위값 = 9.0%\n  B : 친환경건축물, 지능형건축물, 에너지효율등급 인증관련 설계 추가요율 중 차상위값 = 7.5%"]
[]
[null,"3. 지열시험천공",null,":",20000000,null,"원","(견적가, VAT제외)"]
[null,"4. 지반조사",null,":",25200000,null,"원","(견적가, VAT제외)"]
[null,"5. 설계안전성검토",null,":",9000000,null,"원","(견적가, VAT제외)"]
[null,"6.에너지절약계획서",null,":",5000000,null,"원","(견적가, VAT제외)"]
[null,"7. BF 인증",null,":",9000000,null,"원","(견적가, VAT제외)"]
[null,"8. 성능위주설계",null,":",45000000,null,"원","(견적가, VAT제외)"]
[null,"9. 조감토 투시도 CG",null,":",7000000,null,"원","(견적가, VAT제외)"]
[null,"10. 모형제작",null,null,13000000,null,"원","(견적가, VAT제외)"]
[null,"11. 입찰안내서 작성",null,":",0,null,"원","(복합시설관 통합, 견적가, VAT제외)"]
[]
[null,"※ 추가 업무비용",{"$nulls":6},{"$f":"K4+E12+E13+E14+E15+E16+E17+E9+E10+E11","v":213621135},"원"]
[]
[]
[{"$nulls":8},{"$f":"SUM(E9:F17)","v":133200000}]