{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["원가계산","내역서"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":216,"defined_names":8902,"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":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,6],[2,1,2,3],[3,1,23,1],[3,2,6,2],[7,2,9,2],[10,2,23,2],[1,3,1,4],[35,1,35,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3]]}
[null,"공 사 원 가 계 산 서"]
[null,"공사명 : ",null,"부천대학교 어울림마당 환경개선 조경공사"]
[null,"비        목",null,null,"금      액","구        성        비","비      고"]
["A1","순\n공\n사\n원\n가","재\n료\n비","직  접  재  료  비",null,""]
["A2",null,null,"간  접  재  료  비",null,""]
["A3",null,null,"작업설, 부산물(△)",null,"",""]
["AS",null,null,"[ 소          계 ]",null,"",""]
["B1",null,"노\n무\n비","직  접  노  무  비",null,"",""]
["B2",null,null,"간  접  노  무  비",null,"직접노무비 * 13.8% 이하"]
["BS",null,null,"[ 소          계 ]",null,""]
["C1",null,"경\n\n비","운    반    비",null,""]
["C2",null,null,"기   계    경   비",null,""]
["C4",null,null,"산  재  보  험  료",null,"노무비 * 3.70%"]
["C5",null,null,"고  용  보  험  료",null,"노무비 * 1.01%"]
["C6",null,null,"국민  건강  보험료",1689745,"직접노무비 * 3.495%","고정값"]
["C7",null,null,"국민  연금  보험료",2175637,"직접노무비 * 4.5%","고정값"]
["CB",null,null,"노인장기요양보험료",207331,"건강보험료 * 12.27%","고정값"]
["C8",null,null,"퇴직  공제  부금비",1111992,"직접노무비 * 2.3%","고정값"]
["CA",null,null,"산업안전보건관리비",3937881,"(재료비＋직노)×1.85% ","고정값"]
["CH",null,null,"환  경  보  전  비",null,"(재료비+직노+기계경비) * 0.3%"]
["CG",null,null,"기   타    경   비",null,"(재료비+노무비) * 7.6% 이하"]
["CK",null,null,"하도급지급보증수수료",null,"(재료비+직노+기계경비) * 0.081%"]
["CL",null,null,"건설기계대여금지급보증서발급수수료",null,"(재료비+직노+기계경비) * 0.18%"]
["CS",null,null,"[ 소          계 ]",null,""]
["S1","        계",null,null,null,""]
["D1","일  반  관  리  비",null,null,null,"계 * 6.0% 이하"]
["D2","이              윤",null,null,null,"(노무비+경비+일반관리비) * 15.0% 이하"]
["D4","폐기물 처리비",null,null,null,"",""]
[null,"폐  기  물  처  리  비"]
["D9","공   급    가   액",null,null,null,"",""]
["DB","부  가  가  치  세",null,null,null,"공급가액 * 10%",""]
["DH","도      급      액",null,null,null,"",""]
["DJ","관  급  자  재  비(도 급 자)",null,null,null,""]
[null,"관  급  자  재  비(관 급 자)"]
[null,"조  달  수  수  료"]
["S2","총   공   사    비",null,null,null,""]
[{"$nulls":5},6]

{"sheet":"내역서","index":1,"n_rows":117,"n_cols":25,"rows_kept":117,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,10,1,11],[1,12,2,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]]}
["내역서"]
["공 종 명","규 격","수량","단위","합    계","","재 료 비","","노 무 비","","경    비","","비 고"]
["","","",null,"단 가","금 액","단 가","금 액","단 가","금 액","단 가","금 액","",{"$nulls":5},"할 증","화폐변환","OP값","EQ","LA","MA","금액계상"]
["■ 부천대학교 어울림마당 재조성계획 실시설계","",1,"식",null,{"$f":"H4+J4+L4","v":98267265},null,{"$f":"TRUNC(H5+H6+H7+H8+H10+H11+H12+H13+H14+H15+H16+H17+H18+H19+H20+H21+H23+H24+H26,0)","v":0},null,{"$f":"TRUNC(J5+J6+J7+J8+J10+J11+J12+J13+J14+J15+J16+J17+J18+J19+J20+J21+J23+J24+J26,0)","v":6689949},null,{"$f":"TRUNC(L5+L6+L7+L8+L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+L20+L21+L23+L24+L26,0)","v":91577316},"","","A00"]
["   1. 철거/이설공사","",1,"식",{"$f":"G5+I5+K5","v":0},0,{"$f":"H37","v":0},{"$f":"TRUNC(G5*C5,0)","v":0},{"$f":"J37","v":0},{"$f":"TRUNC(I5*C5,0)","v":0},{"$f":"L37","v":0},{"$f":"TRUNC(K5*C5,0)","v":0},"","",null,"10","","A05"]
["   2. 식재공사","",1,"식",0,0,{"$f":"H58","v":0},{"$f":"TRUNC(G6*C6,0)","v":0},{"$f":"J58","v":0},{"$f":"TRUNC(I6*C6,0)","v":0},{"$f":"L58","v":0},{"$f":"TRUNC(K6*C6,0)","v":0},"","",null,"20","","A10"]
["   3. 시설물공사","",1,"식",0,0,{"$f":"H97","v":0},{"$f":"TRUNC(G7*C7,0)","v":0},{"$f":"J97","v":0},{"$f":"TRUNC(I7*C7,0)","v":0},{"$f":"L97","v":0},{"$f":"TRUNC(K7*C7,0)","v":0},"","",null,"25","","A15"]
["   4. 포장공사","",1,"식",0,0,{"$f":"H108","v":0},{"$f":"TRUNC(G8*C8,0)","v":0},{"$f":"J108","v":0},{"$f":"TRUNC(I8*C8,0)","v":0},{"$f":"L108","v":0},{"$f":"TRUNC(K8*C8,0)","v":0},"","",null,"30","","A20"]
["   직  접  공  사  비","",1,"식",0,226732735,null,176660775,null,48477897,null,1594063,"","",null,"50","*","F",{"$nulls":5},"MA=MA(4,0,30)\r\nLA=LA(4,0,30)\r\nEQ=EQ(4,0,30)\r\n"]
["   1) 간접노무비","직노×13.8%",1,"식",0,6689949,null,0,null,6689949,null,0,"","",null,"60","","F",{"$nulls":5},"LA=LA(50)*0.138\r\n"]
["   2) 산재보험료","(직노＋간노)×3.70%",1,"식",0,2041210,null,0,null,0,null,2041210,"","",null,"70","","F",{"$nulls":5},"EQ=LA(50,60)*0.0370\r\n"]
["   3) 고용보험료","(직노＋간노)×1.01%",1,"식",0,557195,null,0,null,0,null,557195,"","",null,"80","","F",{"$nulls":5},"EQ=LA(50,60)*0.0101\r\n"]
["   4) 건강보험료","직노×3.495%",1,"식",0,1694302,null,0,null,0,null,1694302,"","",null,"90","","F",{"$nulls":5},"eq=la(50)*0.03495\r\n"]
["   5) 연금보험료","직노×4.5%",1,"식",0,2181505,null,0,null,0,null,2181505,"","",null,"100","","F",{"$nulls":5},"eq=la(50)*0.045\r\n"]
["   6) 노인장기요양보험료","건보×12.27%",1,"식",0,207890,null,0,null,0,null,207890,"","",null,"110","","F",{"$nulls":5},"EQ=EQ(90)*0.1227\r\n"]
["   7) 건설하도급대금지급보증서발급수수료","(재＋직노+산출경비)×0.081%",1,"식",0,183653,null,0,null,0,null,183653,"","",null,"120","","F",{"$nulls":5},"EQ=TOT(50)*0.00081\r\n"]
["   8) 건설기계대여대금 지급보증서 발급금액","(재＋직노+산출경비)×0.18%",1,"식",0,408118,null,0,null,0,null,408118,"","",null,"130","","F",{"$nulls":5},"EQ=TOT(50)*0.0018\r\n"]
["   9) 퇴직공제부금비","직노×2.3%",1,"식",0,1114991,null,0,null,0,null,1114991,"","",null,"140","","F",{"$nulls":5},"eq=la(50)*0.023\r\n"]
["   10) 산업안전보건관리비","(재＋직노)×1.85%",1,"식",3939717,4165065,null,0,null,0,null,4165065,"","",null,"150","","F",{"$nulls":5},"EQ=(LA(50)+MA(50))*0.0185\r\n"]
["   11) 환경보전비","(재＋직노+산출경비)×0.3%",1,"식",0,680198,null,0,null,0,null,680198,"","",null,"160","","F",{"$nulls":5},"EQ=TOT(50)*0.003\r\n"]
["   12) 기타경비","(재＋노)×7.6%",1,"식",0,17618975,null,0,null,0,null,17618975,"","",null,"170","","F",{"$nulls":5},"EQ=(MA(50)+LA(50,60))*0.076\r\n"]
["   소    계","",1,"식",0,264275786,null,176660775,null,55167846,null,32447165,"","",null,"180","*","F",{"$nulls":5},"MA=MA(50,0,170)\r\nLA=LA(50,0,170)\r\nEQ=EQ(50,0,170)\r\n"]
["   13) 일반관리비","소계×6.0%",1,"식",0,15856547,null,0,null,0,null,15856547,"","",null,"190","","F",{"$nulls":5},"EQ=TOT(180)*0.06\r\n"]
["   14) 이윤","(계1+일반관리비－재)×15.0%",1,"식",0,15322213,null,0,null,0,null,15322213,"","",null,"200","","F",{"$nulls":5},"EQ=(TOT(180)+TOT(190)-MA(50))*0.15  -218372/1.1"]
["   공  급  가  액","",1,"식",0,295454546,null,176660775,null,55167846,null,63625925,"","",null,"280","*","F",{"$nulls":5},"MA=MA(180,0,200)\r\nLA=LA(180,0,200)\r\nEQ=EQ(180,0,200)\r\n"]
["   15) 부가가치세","10%",1,"식",0,29545454,null,0,null,0,null,29545454,"","",null,"290","","F",{"$nulls":5},"EQ=TOT(280)*0.10\r\n"]
["   도  급  금  액","",1,"식",0,325000000,null,176660775,null,55167846,null,93171379,"","",null,"300","*","F",{"$nulls":5},"MA=MA(280,0,290)\r\nLA=LA(280,0,290)\r\nEQ=EQ(280,0,290)\r\n"]
["   ","",null,"",0,0,null,0,null,0,null,0,"","",null,"310","",""]
["   ","",null,"",0,0,null,0,null,0,null,0,"","",null,"320","",""]
["   ","",null,"",0,0,null,0,null,0,null,0,"","",null,"350","S",""]
["■ 어울림마당 환경개선","",1,"식",{"$nulls":9},"","A01"]
["   1. 철거/이설공사","",1,"식",{"$nulls":9},"",null,"10","","A05"]
["   2. 식재공사","",1,"식",{"$nulls":9},"",null,"15","","A10"]
["   3. 시설물공사","",1,"식",{"$nulls":9},"",null,"17","","A15"]
["   4. 포장공사","",1,"식",{"$nulls":9},"",null,"18","","A20"]
["   ","",null,"",{"$nulls":9},"",null,"80","S",""]
["1. 철거/이설공사","",1,"식",{"$nulls":9},"","A05"]
["   1) 시설물","",null,"",{"$nulls":9},"",null,"100","",""]
["   목재데크(철거)","A=620.9㎡",1,"식",{"$nulls":9},"",null,"110","","TR-S-01",null,"T"]
["   목재앉음벽(철거)","H450",50,"m",{"$nulls":9},"",null,"120","","TR-S-02",null,"T"]
["   파고라(철거)","8200x2800xH2910",3,"개소",{"$nulls":9},"",null,"130","","TR-S-03",null,"T"]
["   야외테이블(철거)","1780x1600xH730",9,"개소",{"$nulls":9},"",null,"140","","TR-S-04",null,"T"]
["   잡관목제거","녹지대",200,"㎡",{"$nulls":9},"",null,"170","","TR-1000",null,"T"]
["   소계","",null,"",{"$nulls":9},"",null,"371","",""]
["   ","",null,"",{"$nulls":9},"",null,"415","S",""]
["   2) 폐기물상차","",null,"",{"$nulls":9},"",null,"425","",""]
["   파쇄물 집적 및 상차","(0.7㎥ B.H)",78,"M3",{"$nulls":9},"",null,"435","","YD0400075",null,"F"]
["   소계","",null,"",{"$nulls":9},"",null,"475","",""]
["   ","",null,"",{"$nulls":9},"",null,"485","S",""]
["   3) 이설","",null,"",{"$nulls":9},"",null,"1860","",""]
["   등의자(이설)","1650x630x930",23,"개소",{"$nulls":9},"",null,"1870","","TR-S-140",null,"T"]
["   등의자(재설치)","1650x630x930",23,"개소",{"$nulls":9},"",null,"1875","","TR-S-141",null,"T"]
["   휴지통(이설)","H1300",5,"개소",{"$nulls":9},"",null,"1890","","TR-S-160",null,"T"]
["   휴지통(재설치)","H1300",5,"개소",{"$nulls":9},"",null,"1895","","TR-S-161",null,"T"]
["   수국 이식 (가식-정식)","관목 (H0.8~1.1) 운반300m기준",160,"주",{"$nulls":9},"",null,"1905","","TR-ES-H91K",null,"T"]
["   소계","",null,"",{"$nulls":9},"",null,"2745","",""]
["   ","",null,"",{"$nulls":9},"",null,"2746","S",""]
["2. 식재공사","",1,"식",{"$nulls":9},"","A10"]
["   1) 식재","",null,"",{"$nulls":9},"",null,"100","",""]
["   개회나무(다간)","H3.5xW1.2xR8",4,"주",{"$nulls":9},"",null,"110","","TR-2000",null,"T"]
["   붉은꽃산사나무","H2.5xR6",5,"주",{"$nulls":9},"",null,"120","","TR-2001",null,"T"]
["   덜꿩나무","H2.5xW1.5",2,"주",{"$nulls":9},"",null,"130","","TR-2101",null,"T"]
["   말채(미드윈터파이어)","H0.6xW0.4",13,"주",{"$nulls":9},"",null,"140","","TR-2102",null,"T"]
["   목수국(라임라이트)","H0.8xW0.4x6치포트",23,"주",{"$nulls":9},"",null,"150","","TR-2103",null,"T"]
["   목수국(매직컬캔들)","H1.0xW0.6",9,"주",{"$nulls":9},"",null,"160","","TR-2104",null,"T"]
["   목수국(매직컬파이어)","H0.7xW0.3",12,"주",{"$nulls":9},"",null,"170","","TR-2105",null,"T"]
["   붓들레아(화이트프로퓨전)","H0.5x6치포트x다간",15,"주",{"$nulls":9},"",null,"180","","TR-2106",null,"T"]
["   산앵도나무","H1.0xW0.6",11,"주",{"$nulls":9},"",null,"190","","TR-2107",null,"T"]
["   삼색조팝","H0.4xW0.4x6치포트",19,"주",{"$nulls":9},"",null,"200","","TR-2108",null,"T"]
["   자엽병꽃나무","H1.0xW0.5x24cm포트",6,"주",{"$nulls":9},"",null,"210","","TR-2109",null,"T"]
["   자엽중산국수나무","H1.0xW0.5x24cm포트",5,"주",{"$nulls":9},"",null,"220","","TR-2110",null,"T"]
["   장미조팝","H1.0xW0.5x24cm포트",6,"주",{"$nulls":9},"",null,"230","","TR-2111",null,"T"]
["   화이트셀릭스","H2.5xR8",3,"주",{"$nulls":9},"",null,"240","","TR-2112",null,"T"]
["   회양목","H0.3xW0.3",850,"주",{"$nulls":9},"",null,"260","","TR-3001",null,"T"]
["   산철쭉","H0.3xW0.3",610,"주",{"$nulls":9},"",null,"280","","TR-3002",null,"T"]
["   영산홍","H0.3xW0.3",470,"주",{"$nulls":9},"",null,"290","","TR-3003",null,"T"]
["   소계","",null,"",{"$nulls":9},"",null,"551","",""]
["   ","",null,"",{"$nulls":9},"",null,"595","S",""]
["   2) 지피","",null,"",{"$nulls":9},"",null,"1970","",""]
["   가우라","4치포트",240,"본",{"$nulls":9},"",null,"1980","","TR-GC001",null,"T"]
["   꽃잔디(레드킹)","4치포트",2890,"본",{"$nulls":9},"",null,"1990","","TR-GC002",null,"T"]
["   돌단풍","3치포트",330,"본",{"$nulls":9},"",null,"2000","","TR-GC003",null,"T"]
["   맥문동","3치포트",310,"본",{"$nulls":9},"",null,"2010","","TR-GC004",null,"T"]
["   무늬억새","4치포트",230,"본",{"$nulls":9},"",null,"2020","","TR-GC006",null,"T"]
["   사초(에버골드)","4치포트",60,"본",{"$nulls":9},"",null,"2030","","TR-GC007",null,"T"]
["   수크령","3치포트",580,"본",{"$nulls":9},"",null,"2040","","TR-GC008",null,"T"]
["   수호초","4치포트",530,"본",{"$nulls":9},"",null,"2050","","TR-GC009",null,"T"]
["   아스타","3치포트",180,"본",{"$nulls":9},"",null,"2060","","TR-GC010",null,"T"]
["   아주가","3치포트",260,"본",{"$nulls":9},"",null,"2070","","TR-GC011",null,"T"]
["   옥잠화","4치포트",470,"본",{"$nulls":9},"",null,"2080","","TR-GC012",null,"T"]
["   원추리","3치포트",150,"본",{"$nulls":9},"",null,"2090","","TR-GC015",null,"T"]
["   홍띠","3치포트",200,"본",{"$nulls":9},"",null,"2100","","TR-GC016",null,"T"]
["   잔디","평떼,0.3x0.3x0.03",150,"㎡",{"$nulls":9},"",null,"2230","","TV-JD03",null,"T"]
["   토양환토","양질토",200,"㎡",{"$nulls":9},"",null,"2862","","SN8-NJJ-1FF",null,"T"]
["   소계","",null,"",{"$nulls":9},"",null,"2895","",""]
["   ","",null,"",{"$nulls":9},"",null,"2896","S",""]
["3. 시설물공사","",1,"식",{"$nulls":9},"","A15"]
["   1) 시설물","",null,"",{"$nulls":9},"",null,"2","",""]
["   앉음벽","H450",34,"m",{"$nulls":9},"",null,"12","","TR-S-1001",null,"T"]
["   야외테이블","1650x1950xH740",12,"개소",{"$nulls":9},"",null,"22","","TR-S-1002",null,"T"]
["   소계","",null,"",{"$nulls":9},"",null,"212","",""]
["   ","",null,"",{"$nulls":9},"",null,"222","S",""]
["   2) 조명","",null,"",{"$nulls":9},"",null,"765","",""]
["   상징조형물","L4500xH900",1,"개소",{"$nulls":9},"",null,"775","","MP-1011"]
["   디자인벤치","2200x600xH2105",4,"개소",{"$nulls":9},"",null,"785","","MP-1012"]
["   소계","",null,"",{"$nulls":9},"",null,"1105","",""]
["   ","",null,"",{"$nulls":9},"",null,"1115","S",""]
["4. 포장공사","",1,"식",{"$nulls":9},"","A20"]
["   블록포장","T60",297,"㎡",{"$nulls":9},"",null,"40","","H-KE3-3011",null,"T"]
["   화강석판석포장","T30, 황색계",163,"㎡",{"$nulls":9},"",null,"50","","H-KE3-3012",null,"T"]
["   디딤돌놓기","T80*Ø500",22,"ea",{"$nulls":9},"",null,"60","","H-KE3-3013",null,"T"]
["   경계엣지","H90",130,"m",{"$nulls":9},"",null,"70","","P-2006",null,"T"]
["   ","",null,"",{"$nulls":9},"",null,"970","S",""]
["5. 폐기물처리비","",1,"식",{"$nulls":9},"","A25"]
["   건설폐재류","처리비",84,"TON",{"$nulls":9},"",null,"10","*","GM009"]
["   건설폐기물(혼합폐기물)","처리비",1,"TON",{"$nulls":9},"",null,"20","*","GM0091"]
["   폐목재","처리비",6,"TON",{"$nulls":9},"",null,"30","*","GM0092"]