{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["총괄표","참여업체현황","1(1)참여기술자","1(2)참여기술자실적","2.유사용역","3.신용도","4(1)기술개발및투자실적","4(2)활용실적","4(3)R&D참여실적","5.업무중첩도"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":7,"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":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[7,2,7,3],[29,2,29,3],[8,2,8,3],[14,2,14,3],[18,2,18,3],[22,2,22,3],[25,2,25,3],[26,2,26,3],[32,2,32,3],[37,2,37,3],[30,2,30,3],[31,2,31,3],[33,2,33,3],[34,2,34,3],[40,2,40,3],[0,2,0,7],[35,2,35,3],[36,2,36,3],[38,2,38,3],[39,2,39,3],[6,2,6,3],[5,2,5,3],[27,2,27,3],[28,2,28,3]]}
[null,null,"사업수행능력 평가 총괄표"]
[]
[null,null,null,"용역명 : 남양주 진건지구  군진지 이설 조사설계용역",null,null,"입찰공고일     :","2010-11-12"]
[null,null,null,"추정용역비 :",340548000,"원"]
[]
[null,null,"구                분",null,"배  점","자기평가","확  인","비   고"]
[null,null,"총          계",null,{"$f":"E8+E26+E30+E33+E38+E41","v":101},{"$f":"F8+F26+F30+F33+F38+F41","v":21.479999999999997},{"$f":"G8+G26+G30+G33+G38+G41","v":2}]
[null,null,"1. 참여기술자",null,{"$f":"E9+E15+E19+E23","v":50},{"$f":"F9+F15+F19+F23","v":1.17},{"$f":"G9+G15+G19+G23","v":1}]
[null,null,"가. 사업책임기술자",null,{"$f":"SUM(E10:E14)","v":20},{"$f":"SUM(F10:F14)","v":0},{"$f":"SUM(G10:G14)","v":0}]
[null,null,null,"등급",{"$f":"'1(1)참여기술자'!D7","v":5},{"$f":"'1(1)참여기술자'!E7","v":0},{"$f":"'1(1)참여기술자'!F7","v":0}]
[null,null,null,"경력",{"$f":"'1(1)참여기술자'!D8","v":6},{"$f":"'1(1)참여기술자'!E8","v":0},{"$f":"'1(1)참여기술자'!F8","v":0}]
[null,null,null,"실적",{"$f":"'1(1)참여기술자'!D9","v":7},{"$f":"'1(1)참여기술자'!E9","v":0},{"$f":"'1(1)참여기술자'!F9","v":0}]
[null,null,null,"기술능력",{"$f":"'1(1)참여기술자'!D10","v":1},{"$f":"'1(1)참여기술자'!E10","v":"-"},{"$f":"'1(1)참여기술자'!F10","v":0}]
[null,null,null,"업무관리능력",{"$f":"'1(1)참여기술자'!D11","v":1},{"$f":"'1(1)참여기술자'!E11","v":"-"},{"$f":"'1(1)참여기술자'!F11","v":0}]
[null,null,"나. 분야별 책임기술자",null,{"$f":"SUM(E16:E18)","v":20},{"$f":"SUM(F16:F18)","v":0},{"$f":"SUM(G16:G18)","v":0}]
[null,null,null,"자격및 등급",{"$f":"'1(1)참여기술자'!D12","v":5},{"$f":"'1(1)참여기술자'!E12","v":0},{"$f":"'1(1)참여기술자'!F12","v":0}]
[null,null,null,"경력",{"$f":"'1(1)참여기술자'!D13","v":7},{"$f":"'1(1)참여기술자'!E13","v":0},{"$f":"'1(1)참여기술자'!F13","v":0}]
[null,null,null,"실적",{"$f":"'1(1)참여기술자'!D14","v":8},{"$f":"'1(1)참여기술자'!E14","v":0},{"$f":"'1(1)참여기술자'!F14","v":0}]
[null,null,"다. 분야별 참여기술자",null,{"$f":"SUM(E20:E22)","v":7.9999999999999982},{"$f":"SUM(F20:F22)","v":0},{"$f":"SUM(G20:G22)","v":0}]
[null,null,null,"자격및 등급",{"$f":"'1(1)참여기술자'!D27","v":1.9999999999999998},{"$f":"'1(1)참여기술자'!E27","v":0},{"$f":"'1(1)참여기술자'!F27","v":0}]
[null,null,null,"경력",{"$f":"'1(1)참여기술자'!D28","v":2.9999999999999991},{"$f":"'1(1)참여기술자'!E28","v":0},{"$f":"'1(1)참여기술자'!F28","v":0}]
[null,null,null,"실적",{"$f":"'1(1)참여기술자'!D29","v":2.9999999999999991},{"$f":"'1(1)참여기술자'!E29","v":0},{"$f":"'1(1)참여기술자'!F29","v":0}]
[null,null,"라. 참여기술자 교육훈련, 전차용역실적",null,{"$f":"SUM(E24:E25)","v":2},{"$f":"SUM(F24:F25)","v":1.17},{"$f":"SUM(G24:G25)","v":1}]
[null,null,null,"교육훈련",1,{"$f":"'1(1)참여기술자'!M6","v":0.17},{"$f":"'1(1)참여기술자'!N6","v":0}]
[null,null,null,"전차용역 수행실적",1,1,1,"만점처리"]
[null,null,"2. 유사용역 수행실적",null,{"$f":"SUM(E27:E29)","v":15},{"$f":"SUM(F27:F29)","v":1},{"$f":"SUM(G27:G29)","v":1}]
[null,null,"가. 실적",null,{"$f":"'2.유사용역'!G8","v":7},{"$f":"'2.유사용역'!H8","v":0},{"$f":"'2.유사용역'!I8","v":0}]
[null,null,"나. 금액",null,{"$f":"'2.유사용역'!J8","v":7},{"$f":"'2.유사용역'!K8","v":0},{"$f":"'2.유사용역'!L8","v":0}]
[null,null,"다. 전차용역 수행실적",null,1,1,1,"만점처리"]
[null,null,"3. 신용도",null,{"$f":"SUM(E31:E32)","v":10},{"$f":"SUM(F31:F32)","v":8.3999999999999986},{"$f":"SUM(G31:G32)","v":0}]
[null,null,"가. 입찰제한,업무정지,부실벌점",null,{"$f":"'3.신용도'!G8","v":7},{"$f":"'3.신용도'!H8","v":5.6},{"$f":"'3.신용도'!I8","v":0}]
[null,null,"나. 재정상태 건실도",null,3,{"$f":"'3.신용도'!K8","v":2.8},{"$f":"'3.신용도'!L8","v":0}]
[null,null,"4. 기술개발 및 투자실적",null,{"$f":"SUM(E34:E37)","v":15},{"$f":"SUM(F34:F37)","v":4.91},{"$f":"SUM(G34:G37)","v":0}]
[null,null,"가. 개발실적",null,{"$f":"'4(1)기술개발및투자실적'!G8","v":2},{"$f":"'4(1)기술개발및투자실적'!H8","v":1.32},{"$f":"'4(1)기술개발및투자실적'!I8","v":0}]
[null,null,"나. 투자실적",null,9,{"$f":"'4(1)기술개발및투자실적'!K68","v":0},{"$f":"'4(1)기술개발및투자실적'!L68","v":0}]
[null,null,"다. 활용실적",null,3,{"$f":"'4(2)활용실적'!G8","v":1.49},{"$f":"'4(2)활용실적'!H8","v":0}]
[null,null,"라.R&D 사업참여실적",null,{"$f":"'4(3)R&D참여실적'!G8","v":1},{"$f":"'4(3)R&D참여실적'!H8","v":2.1},{"$f":"'4(3)R&D참여실적'!I8","v":0}]
[null,null,"5. 업무중첩도",null,{"$f":"SUM(E39:E40)","v":10},{"$f":"SUM(F39:F40)","v":6},{"$f":"SUM(G39:G40)","v":0}]
[null,null,"가. 사업책임기술자",null,{"$f":"'5.업무중첩도'!E6","v":6},{"$f":"'5.업무중첩도'!F6","v":6},{"$f":"'5.업무중첩도'!G6","v":0}]
[null,null,"나. 분야별 책임기술자",null,{"$f":"'5.업무중첩도'!E11","v":3.9999999999999996},{"$f":"'5.업무중첩도'!F11","v":0},{"$f":"'5.업무중첩도'!G11","v":0}]
[null,null,"(가점) 해외설계 수행실적",null,1,{"$f":"SUM(F42:F43)","v":0},{"$f":"SUM(G42:G43)","v":0}]

{"sheet":"참여업체현황","index":1,"n_rows":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":false,"merged":[[4,3,5,3],[6,3,7,3],[8,3,9,3],[0,0,0,18],[2,4,3,4],[8,1,9,1],[2,5,2,18],[12,0,13,0],[12,1,13,1],[4,2,5,2],[6,2,7,2],[8,2,9,2],[12,2,13,2],[4,0,5,0],[4,1,5,1],[6,1,7,1],[8,0,9,0],[12,3,13,3],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[6,0,7,0],[10,3,11,3],[10,0,11,0],[10,1,11,1],[10,2,11,2]]}
["참여업체 현황"]
[]
["구  분","상  호","지분율","환산지분율","참여분야","보유면허"]
[{"$nulls":5},"건축사","토질\n및기초","토목\n구조","도로\n및공항","상하\n수도","건축\n구조","건축\n기계\n설비","도시\n계획","조경","측량","환경","전기","통신\n통신","소방"]
["공동","A건축사",0.4,{"$f":"ROUND(C5/(C5+C7+C9),4)","v":0.5},"참여분야",0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"보유면허",0,0,0,0,0,0,0,0,0,0,0]
["공동","B건축사",0.26,{"$f":"ROUND(C7/(C5+C7+C9),4)","v":0.32500000000000001},"참여분야",0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"보유면허",0,0,0,0,0,0,0,0,0,0,0]
["공동","C건축사",0.14000000000000001,{"$f":"ROUND(C9/(C5+C7+C9),4)","v":0.17499999999999999},"참여분야",0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"보유면허",0,0,0,0,0,0,0,0,0,0,0]
["분담","D전기,통신",0.16,"-","참여분야",{"$nulls":11},0,0]
[{"$nulls":4},"보유면허",{"$nulls":11},0,0]
["분담","E소방",0.04,"-","참여분야",{"$nulls":13},0]
[{"$nulls":4},"보유면허",{"$nulls":13},0]

{"sheet":"1(1)참여기술자","index":2,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[6,0,10,1],[6,6,10,6],[6,7,10,7],[11,6,13,6],[6,8,10,8],[6,9,10,9],[11,0,25,0],[20,1,22,1],[23,1,25,1],[23,9,25,9],[6,11,10,11],[6,12,10,12],[17,1,19,1],[11,8,13,8],[11,9,13,9],[11,12,13,12],[14,8,16,8],[17,12,19,12],[11,1,13,1],[14,1,16,1],[26,9,28,9],[26,6,28,6],[26,7,28,7],[11,7,13,7],[14,6,16,6],[14,7,16,7],[17,7,19,7],[17,8,19,8],[17,9,19,9],[14,9,16,9],[26,1,28,1],[26,0,40,0],[29,1,31,1],[35,1,37,1],[29,6,31,6],[29,7,31,7],[35,6,37,6],[35,7,37,7],[32,7,34,7],[38,7,40,7],[35,9,37,9],[35,12,37,12],[32,11,34,11],[32,9,34,9],[26,12,28,12],[29,8,31,8],[29,9,31,9],[32,8,34,8],[29,12,31,12],[29,11,31,11],[38,9,40,9],[38,12,40,12],[26,11,28,11],[32,12,34,12],[1,0,1,12],[20,6,22,6],[20,7,22,7],[20,8,22,8],[20,9,22,9],[20,12,22,12],[43,0,43,1],[44,0,44,1],[42,0,42,5],[32,6,34,6],[38,1,40,1],[32,1,34,1],[38,6,40,6],[38,8,40,8],[3,6,4,6],[23,6,25,6],[23,7,25,7],[23,8,25,8],[17,6,19,6],[3,7,4,7],[3,8,4,8],[35,8,37,8],[26,8,28,8],[11,11,13,11],[14,11,16,11],[17,11,19,11],[20,11,22,11],[23,11,25,11],[3,9,4,9],[3,11,3,12],[23,12,25,12],[23,10,25,10],[14,12,16,12],[46,0,46,1],[47,0,47,1],[5,0,5,2],[35,11,37,11],[38,11,40,11],[20,10,22,10],[26,10,28,10],[29,10,31,10],[32,10,34,10],[35,10,37,10],[3,0,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[38,10,40,10],[3,10,4,10],[6,10,10,10],[11,10,13,10],[14,10,16,10],[17,10,19,10]]}
[]
["1. 참여기술자"]
[]
["구   분",null,null,"배  점","자기\n평가","확  인","성  명","자  격","면허번호","경  력(년)","실적건수","교 육 실 적"]
[{"$nulls":11},"기  간","배  점"]
["총   계",null,null,"-","-","-","-","-","-","-","-","-",{"$f":"ROUND((M7+M15+M18+M21+M24+M30+M33+M36+M39)/9,2)","v":0.17}]
["사업책임기술자",null,"등급",5,null,null,null,"건축사",null,null,{"$f":"'1(2)참여기술자실적'!N6","v":0}]
[null,null,"경력",6]
[null,null,"실적",7]
[null,null,"기술능력",1,"-"]
[null,null,"업무관리\n능력",1,"-"]
["분야별\n책임\n기술자","총계","등급",{"$f":"ROUND(D15*$C$45+D18*$D$45+D21*$E$45+D24*$F$45,1)","v":5},{"$f":"ROUND(E15*$C$45+E18*$D$45+E21*$E$45+E24*$F$45,2)","v":0},0,"-","-","-","-","-","-","-"]
[null,null,"경력",{"$f":"ROUND(D16*$C$45+D19*$D$45+D22*$E$45+D25*$F$45,1)","v":7},0,0]
[null,null,"실적",{"$f":"ROUND(D17*$C$45+D20*$D$45+D23*$E$45+D26*$F$45,1)","v":8},0,0]
[null,"건축설계","등급",5,null,null,"(예시1)홍길동","건축사","00000000000",null,{"$f":"'1(2)참여기술자실적'!N14","v":0}]
[null,null,"경력",7]
[null,null,"실적",8]
[null,"토질 및 기초","등급",5,null,null,"(예시2)000","건축기술사","0000000000",null,{"$f":"'1(2)참여기술자실적'!N21","v":0}]
[null,null,"경력",7]
[null,null,"실적",8]
[null,"전기","등급",5,{"$nulls":6},{"$f":"'1(2)참여기술자실적'!N28","v":0}]
[null,null,"경력",7]
[null,null,"실적",8]
[null,"기계","등급",5,{"$nulls":6},{"$f":"'1(2)참여기술자실적'!N35","v":0}]
[null,null,"경력",7]
[null,null,"실적",8]
["분야별\n참여\n기술자","총계","등급",{"$f":"D30*$C$48+D33*$D$48+D36*$E$48+D39*$F$48","v":1.9999999999999998},0,0,"-","-","-","-","-","-","-"]
[null,null,"경력",2.9999999999999991,0,0]
[null,null,"실적",2.9999999999999991,0,0]
[null,"건축설계","등급",2,{"$nulls":6},{"$f":"'1(2)참여기술자실적'!N42","v":0},"2주",1]
[null,null,"경력",3]
[null,null,"실적",3]
[null,"도로 및 공항","등급",2,{"$nulls":6},{"$f":"'1(2)참여기술자실적'!N49","v":0},"1주",0.5]
[null,null,"경력",3]
[null,null,"실적",3]
[null,"통신","등급",2,{"$nulls":6},{"$f":"'1(2)참여기술자실적'!N56","v":0}]
[null,null,"경력",3]
[null,null,"실적",3]
[null,"소방","등급",2,{"$nulls":6},{"$f":"'1(2)참여기술자실적'!N63","v":0}]
[null,null,"경력",3]
[null,null,"실적",3]
[]
["* 분야별 가중치적용표"]
["책임기술자",null,"건축설계","토질\n및기초","전기","기계"]
["가중치",null,0.7,0.1,0.1,0.1]
[]
["참여기술자",null,"건축설계","도로\n및 공항","통신","소방"]
["가중치",null,0.7,0.1,0.1,0.1]

{"sheet":"1(2)참여기술자실적","index":3,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,0,1,13],[3,0,4,1],[3,3,4,3],[3,2,4,2],[3,7,3,9],[3,11,4,11],[3,13,4,13],[3,12,4,12],[56,1,61,1],[56,2,61,2],[62,1,62,2],[63,1,68,1],[63,2,68,2],[3,10,4,10],[3,4,4,4],[3,6,4,6],[49,1,54,1],[55,1,55,2],[21,1,26,1],[21,2,26,2],[6,2,12,2],[13,1,13,2],[14,1,19,1],[14,2,19,2],[35,1,40,1],[35,2,40,2],[42,2,47,2],[48,1,48,2],[41,1,41,2],[42,1,47,1],[49,2,54,2],[3,5,4,5],[5,0,12,1],[13,0,40,0],[41,0,68,0],[20,1,20,2],[27,1,27,2],[28,1,33,1],[28,2,33,2],[34,1,34,2]]}
[]
["1-2. 참여기술자(실적)"]
[]
["구   분",null,"성  명","용역명","발주처","소속사","담당업무","참여기간",null,null,"용역금액\n(원)","연면적\n(m2)","실적계수","실적건수"]
[{"$nulls":7},"참여시작일","종료일","기간(일)"]
["사업책임기술자",null,"-","-","-","-","-","-","-","-","-","-","-",{"$f":"SUM(N7:N13)","v":0}]
[{"$nulls":7},"2009-10-11","2010-10-12",{"$f":"I7-H7+1","v":367},null,null,{"$f":"ROUNDDOWN(L7/2000,4)","v":0}]
[{"$nulls":9},{"$f":"I8-H8+1","v":1},null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
["분야별\n책임\n기술자","합계",null,"-","-","-","-","-","-","-","-","-","-",{"$f":"SUM(N15:N20)","v":0}]
[null,"건축설계",{"$nulls":7},{"$f":"I15-H15+1","v":1},null,null,{"$f":"ROUNDDOWN(L15/2000,4)","v":0}]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[null,"합계",null,"-","-","-","-","-","-","-","-","-","-",{"$f":"SUM(N22:N27)","v":0}]
[null,"토질및기초",{"$nulls":7},{"$f":"I22-H22+1","v":1},null,null,{"$f":"ROUNDDOWN(K22/총괄표!$E$4,4)","v":0}]
[{"$nulls":9},1,null,null,{"$f":"ROUNDDOWN(K23/총괄표!$E$4,4)","v":0}]
[{"$nulls":9},1,null,null,{"$f":"ROUNDDOWN(K24/총괄표!$E$4,4)","v":0}]
[{"$nulls":9},1,null,null,{"$f":"ROUNDDOWN(K25/총괄표!$E$4,4)","v":0}]
[{"$nulls":9},1,null,null,{"$f":"ROUNDDOWN(K26/총괄표!$E$4,4)","v":0}]
[{"$nulls":9},1,null,null,{"$f":"ROUNDDOWN(K27/총괄표!$E$4,4)","v":0}]
[null,"합계",null,"-","-","-","-","-","-","-","-","-","-",{"$f":"SUM(N29:N34)","v":0}]
[null,"전기",{"$nulls":7},{"$f":"I29-H29+1","v":1},null,null,{"$f":"ROUNDDOWN(L29/2000,4)","v":0}]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[null,"합계",null,"-","-","-","-","-","-","-","-","-","-",{"$f":"SUM(N36:N41)","v":0}]
[null,"기계",{"$nulls":7},{"$f":"I36-H36+1","v":1},null,null,{"$f":"ROUNDDOWN(L36/2000,4)","v":0}]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
["분야별\n참여\n기술자","합계",null,"-","-","-","-","-","-","-","-","-","-",{"$f":"SUM(N43:N48)","v":0}]
[null,"건축설계",{"$nulls":7},{"$f":"I43-H43+1","v":1},null,null,{"$f":"ROUNDDOWN(L43/2000,4)","v":0}]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[null,"합계",null,"-","-","-","-","-","-","-","-","-","-",{"$f":"SUM(N50:N55)","v":0}]
[null,"도로 및 공항",{"$nulls":7},{"$f":"I50-H50+1","v":1},null,null,{"$f":"ROUNDDOWN(K50/총괄표!$E$4,4)","v":0}]
[{"$nulls":9},1,null,null,{"$f":"ROUNDDOWN(K51/총괄표!$E$4,4)","v":0}]
[{"$nulls":9},1,null,null,{"$f":"ROUNDDOWN(K52/총괄표!$E$4,4)","v":0}]
[{"$nulls":9},1,null,null,{"$f":"ROUNDDOWN(K53/총괄표!$E$4,4)","v":0}]
[{"$nulls":9},1,null,null,{"$f":"ROUNDDOWN(K54/총괄표!$E$4,4)","v":0}]
[{"$nulls":9},1,null,null,{"$f":"ROUNDDOWN(K55/총괄표!$E$4,4)","v":0}]
[null,"합계",null,"-","-","-","-","-","-","-","-","-","-",{"$f":"SUM(N57:N62)","v":0}]
[null,"통신",{"$nulls":7},{"$f":"I57-H57+1","v":1},null,null,{"$f":"ROUNDDOWN(L57/2000,4)","v":0}]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[null,"합계",null,"-","-","-","-","-","-","-","-","-","-",{"$f":"SUM(N64:N69)","v":0}]
[null,"소방",{"$nulls":7},{"$f":"I64-H64+1","v":1},null,null,{"$f":"ROUNDDOWN(L64/2000,4)","v":0}]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]
[{"$nulls":9},1,null,null,0]

{"sheet":"2.유사용역","index":4,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[[26,3,26,4],[27,3,27,4],[21,3,21,4],[22,3,22,4],[15,0,15,1],[12,6,12,7],[19,3,19,4],[20,3,20,4],[33,6,33,7],[36,0,36,1],[14,3,14,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[16,3,16,4],[15,3,15,4],[17,3,17,4],[18,3,18,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[35,3,35,4],[54,6,54,7],[57,0,57,1],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[66,3,66,4],[67,3,67,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[72,3,72,4],[7,0,7,1],[62,3,62,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[5,4,5,5],[5,12,6,12],[1,0,1,12],[5,2,6,2],[5,3,6,3],[5,0,6,1],[5,6,5,8],[5,9,5,11],[3,6,3,7],[3,0,3,1]]}
[]
["2. 유사용역수행실적"]
[]
["유사용역 총괄표"]
[]
["유사용역수행실적",null,"환산지분율","실적건수","금액",null,"실적점수",null,null,"금액점수",null,null,"비고"]
[{"$nulls":4},"합계금액","금액계수","배점","자기평가","확인","배점","자기평가","확인"]
["총   계",null,"-",{"$f":"ROUND(D9*C9+D10*C10+D11*C11,2)","v":3.7},{"$f":"E9*C9+E10*C10+E11*C11","v":2295900000},{"$f":"E8/총괄표!E4","v":6.7417808943232673},7,null,null,{"$f":"J9*$C9+$C10*J10+$C11*J11","v":7}]
[{"$f":"A13","v":"대 표 사"},{"$f":"B13","v":"A건축사"},{"$f":"참여업체현황!$D$5","v":0.5},{"$f":"O16","v":3.7},{"$f":"$K$16","v":2760000000},"-","-","-","-",7,"-","-"]
[{"$f":"A34","v":"공동도급사"},{"$f":"B34","v":"B건축사"},{"$f":"참여업체현황!$D$7","v":0.32500000000000001},{"$f":"O37","v":3.7},{"$f":"K37","v":1332000000},"-","-","-","-",7,"-","-"]
[{"$f":"A55","v":"공동도급사"},{"$f":"B55","v":"C건축사"},{"$f":"참여업체현황!$D$9","v":0.17499999999999999},{"$f":"O58","v":3.7},{"$f":"K58","v":2760000000},"-","-","-","-",7,"-","-"]
[]
["대 표 사",{"$f":"참여업체현황!B5","v":"A건축사"},null,"환산지분율",null,null,{"$f":"참여업체현황!$D$5","v":0.5}]
[]
["구분","용역명","발주청","용역기간",null,"용역/\n일괄입찰","준공금액\n(원)","지분율","설계요율","설계보상","실적금액","연면적\n(m2)","실적연면적\n(m2)","연면적\n계수","실적\n건수"]
["총   계",null,"-","-",null,"-","-","-","-","-",{"$f":"SUM(K17:K31)","v":2760000000},"-","-","-",{"$f":"SUM(O17:O31)","v":3.7}]
["기본설계","00군부대 이설공사 조사설계","00공사","2009/03~2010/07",null,"설계용역",1000000000,0.5,"-","-",{"$f":"G17*H17","v":500000000},3200,{"$f":"L17*H17","v":1600},{"$f":"ROUNDDOWN(M17/2000,2)","v":0.8},0.5]
["기본 및 실시설계","00 군부대 건설 일괄입찰","00공사","2009/03~2010/07",null,"일괄입찰",35000000000,"-",{"$f":"3.5%*80%","v":2.8000000000000004E-2},"-",{"$f":"G18*I18","v":980000000.00000012},7000,{"$f":"L18","v":7000},{"$f":"ROUNDDOWN(M18/2000,2)","v":3.5},2]
[null,null,"00공사","2009/03~2010/07",null,"설계보상",50000000000,"-",3.2000000000000001E-2,0.8,{"$f":"G19*I19*J19","v":1280000000},4000,{"$f":"L19","v":4000},{"$f":"ROUNDDOWN(M19*J19/2000,2)","v":1.6},{"$f":"1.5*J19","v":1.2000000000000002}]
{"$rows_empty":14}
["공동도급사",{"$f":"참여업체현황!B7","v":"B건축사"},null,"환산지분율",null,null,{"$f":"참여업체현황!$D$7","v":0.32500000000000001}]
[]
["구분","용역명","발주청","용역기간",null,"용역/\n일괄입찰","준공금액\n(원)","지분율","설계요율","설계보상","실적금액","연면적\n(m2)","실적연면적\n(m2)","연면적\n계수","실적\n건수"]
["총   계",null,"-","-",null,"-","-","-","-","-",{"$f":"SUM(K38:K52)","v":1332000000},"-","-","-",{"$f":"SUM(O38:O52)","v":3.7}]
["기본설계","00군부대 이설공사 조사설계","00공사","2009/03~2010/07",null,"설계용역",800000000,0.5,"-","-",{"$f":"G38*H38","v":400000000},3200,{"$f":"L38*H38","v":1600},{"$f":"ROUNDDOWN(M38/2000,2)","v":0.8},0.5]
["기본 및 실시설계","00 군부대 건설 일괄입찰","00공사","2009/03~2010/07",null,"일괄입찰",15000000000,"-",{"$f":"3.5%*80%","v":2.8000000000000004E-2},"-",{"$f":"G39*I39","v":420000000.00000006},7000,{"$f":"L39","v":7000},{"$f":"ROUNDDOWN(M39/2000,2)","v":3.5},2]
[null,null,"00공사","2009/03~2010/07",null,"설계보상",20000000000,"-",3.2000000000000001E-2,0.8,{"$f":"G40*I40*J40","v":512000000},4000,{"$f":"L40","v":4000},{"$f":"ROUNDDOWN(M40*J40/2000,2)","v":1.6},{"$f":"1.5*J40","v":1.2000000000000002}]
{"$rows_empty":14}
["공동도급사",{"$f":"참여업체현황!B9","v":"C건축사"},null,"환산지분율",null,null,{"$f":"참여업체현황!D9","v":0.17499999999999999}]
[]
["구분","용역명","발주청","용역기간",null,"용역/\n일괄입찰","준공금액\n(원)","지분율","설계요율","설계보상","실적금액","연면적\n(m2)","실적연면적\n(m2)","연면적\n계수","실적\n건수"]
["총   계",null,"-","-",null,"-","-","-","-","-",{"$f":"SUM(K59:K73)","v":2760000000},"-","-","-",{"$f":"SUM(O59:O73)","v":3.7}]
["기본설계","00군부대 이설공사 조사설계","00공사","2009/03~2010/07",null,"설계용역",1000000000,0.5,"-","-",{"$f":"G59*H59","v":500000000},3200,{"$f":"L59*H59","v":1600},{"$f":"ROUNDDOWN(M59/2000,2)","v":0.8},0.5]
["기본 및 실시설계","00 군부대 건설 일괄입찰","00공사","2009/03~2010/07",null,"일괄입찰",35000000000,"-",{"$f":"3.5%*80%","v":2.8000000000000004E-2},"-",{"$f":"G60*I60","v":980000000.00000012},7000,{"$f":"L60","v":7000},{"$f":"ROUNDDOWN(M60/2000,2)","v":3.5},2]
[null,null,"00공사","2009/03~2010/07",null,"설계보상",50000000000,"-",3.2000000000000001E-2,0.8,{"$f":"G61*I61*J61","v":1280000000},4000,{"$f":"L61","v":4000},{"$f":"ROUNDDOWN(M61*J61/2000,2)","v":1.6},{"$f":"1.5*J61","v":1.2000000000000002}]

{"sheet":"3.신용도","index":5,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[17,0,21,0],[28,0,32,0],[27,0,27,1],[3,0,3,1],[3,6,3,7],[15,6,15,7],[5,3,6,3],[5,4,6,4],[5,6,5,8],[7,0,7,1],[37,6,37,7],[39,0,43,0],[42,3,42,5],[43,3,43,5],[5,0,6,1],[31,3,31,5],[24,6,24,7],[26,6,26,7],[38,0,38,1],[35,6,35,7],[1,0,1,11],[5,5,6,5],[13,6,13,7],[16,0,16,1],[5,2,6,2],[5,9,5,11],[46,6,46,7],[46,0,46,1],[49,0,49,1],[48,6,48,7],[50,0,58,0],[58,3,58,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[26,3,26,5],[27,3,27,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[55,3,55,5],[56,3,56,5],[57,3,57,5],[32,3,32,5],[37,3,37,5],[38,3,38,5],[39,3,39,5],[40,3,40,5],[41,3,41,5],[51,3,51,5],[52,3,52,5],[53,3,53,5],[54,3,54,5],[48,3,48,5],[49,3,49,5],[50,3,50,5]]}
[]
["3. 신용도"]
[]
["신용도 총괄표"]
[]
["신용도",null,"환산지분율","입찰참가\n제한기간","기술자격 및\n업무정지기간","참여업체 및\n참여기술자\n누계부실벌점","입찰참가제한, 업무정지, 부실벌점등",null,null,"신용평가등급"]
[{"$nulls":6},"배점","자기평가","확인","신용평가등급","점수","확인"]
["총   계",null,"-",{"$f":"ROUNDUP(($C9*D9+$C10*D10+$C11*D11)/30,0)","v":6},{"$f":"ROUNDUP(I50/30,0)","v":1},{"$f":"ROUND(($C9*F9+$C10*F10+$C11*F11)+K50,2)","v":0},7,{"$f":"G8-0.2*(D8+E8)-F8","v":5.6},null,"-",{"$f":"ROUND(K9*C9+K10*C10+K11*C11,2)","v":2.8},{"$f":"ROUND($C9*L9+$C10*L10+$C11*L11,2)","v":0}]
[{"$f":"A14","v":"대 표 사"},{"$f":"B14","v":"A건축사"},{"$f":"참여업체현황!$D$5","v":0.5},{"$f":"I17","v":166},"-",{"$f":"K17","v":0},"-","-","-","회사채A-",3]
[{"$f":"A25","v":"공동도급사"},{"$f":"B25","v":"B건축사"},{"$f":"참여업체현황!$D$7","v":0.32500000000000001},{"$f":"I28","v":166},"-",{"$f":"K28","v":0},"-","-","-","기업어음A3+",2.7]
[{"$f":"A36","v":"공동도급사"},{"$f":"B36","v":"C건축사"},{"$f":"참여업체현황!$D$9","v":0.17499999999999999},{"$f":"I39","v":166},"-",{"$f":"K39","v":0},"-","-","-","회사채B-",2.4]
[]
[]
["대 표 사",{"$f":"참여업체현황!B5","v":"A건축사"},null,"환산지분율",null,null,{"$f":"참여업체현황!$D$5","v":0.5}]
[]
["구분","처분명칭","처분부과기관","처분사유",null,null,"입찰참가 제한기간",null,"기간\n(일)","누계평균\n부실벌점","부실점수","비고"]
["총   계",null,"-","-",null,null,"시작일","종료일",{"$f":"SUM(I18:I22)","v":166},null,null,"-"]
["입찰참가\n제한처분현황","00공사 건 000참가제한","00공사조사설계","000 건",null,null,"2009-12-10","2010-05-20",{"$f":"H18-G18+1","v":162},"-"]
[{"$nulls":8},{"$f":"H19-G19+1","v":1},"-"]
[{"$nulls":8},{"$f":"H20-G20+1","v":1},"-"]
[{"$nulls":8},{"$f":"H21-G21+1","v":1},"-"]
[{"$nulls":8},{"$f":"H22-G22+1","v":1},"-"]
[]
[]
["공동도급사",{"$f":"참여업체현황!B7","v":"B건축사"},null,"환산지분율",null,null,{"$f":"참여업체현황!$D$7","v":0.32500000000000001}]
[]
["구분","처분명칭","처분부과기관","처분사유",null,null,"입찰참가 제한기간",null,"기간\n(개월)","누계평균\n부실벌점","부실점수","비고"]
["총   계",null,"-","-",null,null,"시작일","종료일",{"$f":"SUM(I29:I33)","v":166},null,null,"-"]
["입찰참가\n제한처분현황","00공사 건 000참가제한","00공사조사설계","000 건",null,null,"2009-12-10","2010-05-20",{"$f":"H29-G29+1","v":162},"-"]
[{"$nulls":8},{"$f":"H30-G30+1","v":1},"-"]
[{"$nulls":8},{"$f":"H31-G31+1","v":1},"-"]
[{"$nulls":8},{"$f":"H32-G32+1","v":1},"-"]
[{"$nulls":8},{"$f":"H33-G33+1","v":1},"-"]
[]
[]
["공동도급사",{"$f":"참여업체현황!B9","v":"C건축사"},null,"환산지분율",null,null,{"$f":"참여업체현황!D9","v":0.17499999999999999}]
[]
["구분","처분명칭","처분부과기관","처분사유",null,null,"입찰참가 제한기간",null,"기간\n(개월)","누계평균\n부실벌점","부실점수","비고"]
["총   계",null,"-","-",null,null,"시작일","종료일",{"$f":"SUM(I40:I44)","v":166},null,null,"-"]
["입찰참가\n제한처분현황","00공사 건 000참가제한","00공사조사설계","000 건",null,null,"2009-12-10","2010-05-20",{"$f":"H40-G40+1","v":162},"-"]
[{"$nulls":8},{"$f":"H41-G41+1","v":1},"-"]
[{"$nulls":8},{"$f":"H42-G42+1","v":1},"-"]
[{"$nulls":8},{"$f":"H43-G43+1","v":1},"-"]
[{"$nulls":8},{"$f":"H44-G44+1","v":1},"-"]
[]
[]
["참여기술자 기술자격 및 업무정지, 부실벌점"]
[]
["구분","-","처분부과기관","처분사유",null,null,"기술자격 및 업무정지기간",null,"기간\n(일)","누계평균\n부실벌점","부실점수","비고"]
["총   계",null,"-","-",null,null,"시작일","종료일",{"$f":"SUM(I51:I59)","v":9},"-",{"$f":"SUM(K51:K59)","v":0},"-"]
["참여기술자 \n기술자격 및 \n업무정지 처분현황","사업책임기술자","홍길동",{"$nulls":5},{"$f":"H51-G51+1","v":1}]
[null,"분야별책임기술자",{"$nulls":6},{"$f":"H52-G52+1","v":1}]
[null,"분야별책임기술자",{"$nulls":6},1]
[null,"분야별책임기술자",{"$nulls":6},1]
[null,"분야별책임기술자",{"$nulls":6},1]
[null,"분야별참여기술자",{"$nulls":6},1]
[null,"분야별참여기술자",{"$nulls":6},1]
[null,"분야별참여기술자",{"$nulls":6},1]
[null,"분야별참여기술자",{"$nulls":6},1]

{"sheet":"4(1)기술개발및투자실적","index":6,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":false,"merged":[[37,0,39,0],[47,4,48,4],[47,3,48,3],[31,3,32,3],[31,4,32,4],[33,0,33,1],[40,0,42,0],[15,2,16,2],[15,6,15,9],[7,0,7,1],[15,5,16,5],[15,4,16,4],[15,3,16,3],[15,1,16,1],[65,9,66,9],[65,3,65,4],[65,5,65,6],[65,7,65,8],[5,0,6,1],[49,0,49,1],[47,6,47,9],[50,0,52,0],[5,3,6,3],[5,4,6,4],[67,0,67,1],[65,0,66,0],[65,1,66,1],[65,2,66,2],[17,0,17,1],[63,0,63,1],[31,0,32,0],[31,1,32,1],[31,2,32,2],[34,0,36,0],[1,0,1,11],[68,0,70,0],[65,10,65,11],[24,0,26,0],[21,0,23,0],[18,0,20,0],[5,5,6,5],[31,5,32,5],[31,6,31,9],[47,0,48,0],[3,0,3,1],[56,0,58,0],[5,2,6,2],[61,0,61,11],[53,0,55,0],[47,1,48,1],[47,2,48,2],[15,0,16,0],[47,5,48,5],[5,6,5,8]]}
[]
["4-1. 기술개발"]
[]
["기술개발 총계"]
[]
["신용도",null,"환산지분율","신기술","특허","실용신안","실적점수"]
[{"$nulls":6},"배점","자기평가","확인"]
["총   계",null,"-",{"$f":"$C9*D9+$C10*D10+$C11*D11","v":1},{"$f":"$C9*E9+$C10*E10+$C11*E11","v":0.32399999999999995},{"$f":"$C9*F9+$C10*F10+$C11*F11","v":0},{"$f":"$C9*G9+$C10*G10+$C11*G11","v":2},{"$f":"ROUND($C9*H9+$C10*H10+$C11*H11,2)","v":1.32},{"$f":"ROUND($C9*I9+$C10*I10+$C11*I11,2)","v":0}]
[{"$f":"A14","v":"대 표 사"},{"$f":"B14","v":"A건축사"},{"$f":"참여업체현황!$D$5","v":0.5},{"$f":"SUM(I19:I21)","v":1},{"$f":"SUM(I22:I24)","v":0.48},{"$f":"SUM(I25:I27)","v":0},{"$f":"H18","v":2},{"$f":"I18","v":1.48},{"$f":"J18","v":0}]
[{"$f":"A30","v":"공동도급사"},{"$f":"B30","v":"B건축사"},{"$f":"참여업체현황!$D$7","v":0.32500000000000001},{"$f":"SUM(I35:I37)","v":1},{"$f":"SUM(I38:I40)","v":0},{"$f":"SUM(I41:I43)","v":0},{"$f":"H34","v":2},{"$f":"I34","v":1},{"$f":"J34","v":0}]
[{"$f":"A46","v":"공동도급사"},{"$f":"B46","v":"C건축사"},{"$f":"참여업체현황!$D$9","v":0.17499999999999999},{"$f":"SUM(I51:I53)","v":1},{"$f":"SUM(I54:I56)","v":0.48},{"$f":"SUM(I57:I59)","v":0},{"$f":"H50","v":2},{"$f":"I50","v":1.48},{"$f":"J50","v":0}]
[]
[]
["대 표 사",{"$f":"참여업체현황!B5","v":"A건축사"},null,"환산지분율",null,{"$f":"참여업체현황!$D$5","v":0.5}]
[]
["구분","제목","등록청","지정번호","출원일","경과기간\n(년)","개발실적"]
[{"$nulls":6},"가중치","배점","자기평가","확인"]
["총   계",null,"-","-","-","-","-",2,{"$f":"ROUND(SUM(I19:I27),2)","v":1.48},{"$f":"SUM(J19:J27)","v":0}]
["건설신기술","00신기술","00청","00-000-000","2009-02-03",{"$f":"ROUNDDOWN((총괄표!$H$3-E19+1)/365,0)","v":1},1,1,{"$f":"ROUND(G19*H19,2)","v":1},"-"]
[{"$nulls":7},1,{"$f":"ROUND(G20*H20,2)","v":0},"-"]
[{"$nulls":7},1,0,"-"]
["건설기술에\n관한 특허",null,"00청","00-000-000","2004-02-01",{"$f":"ROUNDDOWN((총괄표!$H$3-E22+1)/365,0)","v":6},0.8,0.6,0.48,"-"]
[{"$nulls":7},0.6,0,"-"]
[{"$nulls":7},0.6,0,"-"]
["건설기술에\n관한 실용신안",{"$nulls":6},0.3,0,"-"]
[{"$nulls":7},0.3,0,"-"]
[{"$nulls":7},0.3,0,"-"]
[]
[]
["공동도급사",{"$f":"참여업체현황!B7","v":"B건축사"},null,"환산지분율",null,{"$f":"참여업체현황!$D$7","v":0.32500000000000001}]
[]
["구분","제목","등록청","지정번호","출원일","경과기간","개발실적"]
[{"$nulls":6},"가중치","배점","자기평가","확인"]
["총   계",null,"-","-","-","-","-",2,{"$f":"ROUND(SUM(I35:I43),2)","v":1},{"$f":"SUM(J35:J43)","v":0}]
["건설신기술","00신기술","00청","00-000-000","2009-02-03","1년9개월",1,1,{"$f":"ROUND(G35*H35,2)","v":1},"-"]
[{"$nulls":7},1,{"$f":"ROUND(G36*H36,2)","v":0},"-"]
[{"$nulls":7},1,0,"-"]
["건설기술에\n관한 특허",{"$nulls":6},0.6,0,"-"]
[{"$nulls":7},0.6,0,"-"]
[{"$nulls":7},0.6,0,"-"]
["건설기술에\n관한 실용신안",{"$nulls":6},0.3,0,"-"]
[{"$nulls":7},0.3,0,"-"]
[{"$nulls":7},0.3,0,"-"]
[]
[]
["공동도급사",{"$f":"참여업체현황!B9","v":"C건축사"},null,"환산지분율",null,{"$f":"참여업체현황!$D$9","v":0.17499999999999999}]
[]
["구분","제목","등록청","지정번호","출원일","경과기간","개발실적"]
[{"$nulls":6},"가중치","배점","자기평가","확인"]
["총   계",null,"-","-","-","-","-",2,{"$f":"ROUND(SUM(I51:I59),2)","v":1.48},{"$f":"SUM(J51:J59)","v":0}]
["건설신기술","00신기술","00청","00-000-000","2009-02-03","1년9개월",1,1,{"$f":"ROUND(G51*H51,2)","v":1},"-"]
[{"$nulls":7},1,{"$f":"ROUND(G52*H52,2)","v":0},"-"]
[{"$nulls":7},1,0,"-"]
["건설기술에\n관한 특허",null,"00청","00-000-000","0000-00-00","6년8개월",0.8,0.6,0.48,"-"]
[{"$nulls":7},0.6,0,"-"]
[{"$nulls":7},0.6,0,"-"]
["건설기술에\n관한 실용신안",{"$nulls":6},0.3,0,"-"]
[{"$nulls":7},0.3,0,"-"]
[{"$nulls":7},0.3,0,"-"]
[]
[]
["4-2. 투자실적"]
[]
["투자실적 총계"]
[]
["구분","업체명","환산지분율","1년차",null,"2년차",null,"3년차",null,"투자실적","투자실적"]
[null,null,null,"건설기술개발투자액","건설부문총매출액","건설기술개발투자액","건설부문총매출액","건설기술개발투자액","건설부문총매출액",null,"자기평가","확인"]
["총   계",null,"-","-","-","-","-","-","-",{"$f":"ROUND(J69*C69+J70*C70+J71*C71,4)","v":2.3400000000000001E-2},null,{"$f":"SUM(L69:L71)","v":0}]
["투자실적",{"$f":"참여업체현황!B5","v":"A건축사"},{"$f":"참여업체현황!D5","v":0.5},3.55,100,5,200,4,100,{"$f":"ROUND((ROUND(D69/E69,4)+ROUND(F69/G69,4)+ROUND(H69/I69,4))/3,4)","v":3.3500000000000002E-2},"-","-"]
[null,{"$f":"참여업체현황!B7","v":"B건축사"},{"$f":"참여업체현황!D7","v":0.32500000000000001},3,100,2,250,2,530,{"$f":"ROUND((ROUND(D70/E70,4)+ROUND(F70/G70,4)+ROUND(H70/I70,4))/3,4)","v":1.3899999999999999E-2},"-","-"]
[null,{"$f":"참여업체현황!B9","v":"C건축사"},{"$f":"참여업체현황!D9","v":0.17499999999999999},2,120,2,130,2,400,{"$f":"ROUND((ROUND(D71/E71,4)+ROUND(F71/G71,4)+ROUND(H71/I71,4))/3,4)","v":1.24E-2},"-","-"]

{"sheet":"4(2)활용실적","index":7,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[53,0,55,0],[56,0,58,0],[47,0,48,0],[47,1,48,1],[49,0,49,1],[50,0,52,0],[31,7,31,9],[31,6,32,6],[47,6,48,6],[47,7,47,9],[47,4,48,4],[31,4,32,4],[47,5,48,5],[31,5,32,5],[33,0,33,1],[34,0,36,0],[37,0,39,0],[40,0,42,0],[47,2,48,2],[47,3,48,3],[31,2,32,2],[31,3,32,3],[15,2,16,2],[15,3,16,3],[21,0,23,0],[24,0,26,0],[31,0,32,0],[31,1,32,1],[17,0,17,1],[18,0,20,0],[1,0,1,9],[3,0,3,1],[5,0,6,1],[5,2,6,2],[5,3,5,7],[7,0,7,1],[15,6,16,6],[15,7,15,9],[15,4,16,4],[15,5,16,5],[15,0,16,0],[15,1,16,1]]}
[]
["4-3. 활용실적"]
[]
["활용실적 총계"]
[]
["활용실적",null,"환산지분율","실적점수"]
[null,null,null,"신기술","특허","실용신안","자기평가","확인"]
["총   계",null,"-",{"$f":"$C9*D9+$C10*D10+$C11*D11","v":0.8},{"$f":"$C9*E9+$C10*E10+$C11*E11","v":0.48},{"$f":"$C9*F9+$C10*F10+$C11*F11","v":0.21000000000000002},{"$f":"ROUND($C9*G9+$C10*G10+$C11*G11,2)","v":1.49},{"$f":"$C9*H9+$C10*H10+$C11*H11","v":0}]
[{"$f":"A14","v":"대 표 사"},{"$f":"B14","v":"A건축사"},{"$f":"참여업체현황!$D$5","v":0.5},{"$f":"SUM(I19:I21)","v":0.8},{"$f":"SUM(I22:I24)","v":0.48},{"$f":"SUM(I25:I27)","v":0.21},{"$f":"I18","v":1.49}]
[{"$f":"A30","v":"공동도급사"},{"$f":"B30","v":"B건축사"},{"$f":"참여업체현황!$D$7","v":0.32500000000000001},{"$f":"SUM(I35:I37)","v":0.8},{"$f":"SUM(I38:I40)","v":0.48},{"$f":"SUM(I41:I43)","v":0.21},{"$f":"I34","v":1.49}]
[{"$f":"A46","v":"공동도급사"},{"$f":"B46","v":"C건축사"},{"$f":"참여업체현황!$D$9","v":0.17499999999999999},{"$f":"SUM(I51:I53)","v":0.8},{"$f":"SUM(I54:I56)","v":0.48},{"$f":"SUM(I57:I59)","v":0.21},{"$f":"I50","v":1.49}]
[]
[]
["대 표 사",{"$f":"참여업체현황!B5","v":"A건축사"},null,"환산지분율",null,{"$f":"참여업체현황!D5","v":0.5}]
[]
["구분","권리내용","권리권자","등록일자","경과기간\n(입찰공고일기준)","활용건수","활용금액\n(억원)","개발실적"]
[{"$nulls":7},"가중치","자기평가","확인"]
["총   계",null,"-","-","-","-","-","-",{"$f":"ROUND(SUM(I19:I27),2)","v":1.49},{"$f":"SUM(J19:J27)","v":0}]
["건설신기술","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D19+1)/365,0)","v":2},3,"15억",0.8,{"$f":"ROUND(H19*(1),2)","v":0.8},"-"]
[{"$nulls":8},{"$f":"ROUND(H20*(1),2)","v":0},"-"]
[{"$nulls":8},{"$f":"ROUND(H21*(1),2)","v":0},"-"]
["건설기술에\n관한 특허","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D22+1)/365,0)","v":2},3,"15억",0.8,{"$f":"ROUND(H22*(0.6),2)","v":0.48},"-"]
[{"$nulls":8},{"$f":"ROUND(H23*(0.6),2)","v":0},"-"]
[{"$nulls":8},{"$f":"ROUND(H24*(0.6),2)","v":0},"-"]
["건설기술에\n관한 실용신안","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D25+1)/365,0)","v":2},2,"13억",0.7,{"$f":"ROUND(H25*(0.3),2)","v":0.21},"-"]
[{"$nulls":8},{"$f":"ROUND(H26*(0.3),2)","v":0},"-"]
[{"$nulls":8},{"$f":"ROUND(H27*(0.3),2)","v":0},"-"]
[]
[]
["공동도급사",{"$f":"참여업체현황!B7","v":"B건축사"},null,"환산지분율",null,{"$f":"참여업체현황!D7","v":0.32500000000000001}]
[]
["구분","권리내용","권리권자","등록일자","경과기간\n(입찰공고일기준)","활용건수","활용금액\n(억원)","개발실적"]
[{"$nulls":7},"가중치","자기평가","확인"]
["총   계",null,"-","-","-","-","-","-",{"$f":"ROUND(SUM(I35:I43),2)","v":1.49},{"$f":"SUM(J35:J43)","v":0}]
["건설신기술","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D35+1)/365,0)","v":2},3,"15억",0.8,{"$f":"ROUND(H35*(1),2)","v":0.8},"-"]
[{"$nulls":8},{"$f":"ROUND(H36*(1),2)","v":0},"-"]
[{"$nulls":8},{"$f":"ROUND(H37*(1),2)","v":0},"-"]
["건설기술에\n관한 특허","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D38+1)/365,0)","v":2},3,"15억",0.8,{"$f":"ROUND(H38*(0.6),2)","v":0.48},"-"]
[{"$nulls":8},{"$f":"ROUND(H39*(0.6),2)","v":0},"-"]
[{"$nulls":8},{"$f":"ROUND(H40*(0.6),2)","v":0},"-"]
["건설기술에\n관한 실용신안","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D41+1)/365,0)","v":2},2,"13억",0.7,{"$f":"ROUND(H41*(0.3),2)","v":0.21},"-"]
[{"$nulls":8},{"$f":"ROUND(H42*(0.3),2)","v":0},"-"]
[{"$nulls":8},{"$f":"ROUND(H43*(0.3),2)","v":0},"-"]
[]
[]
["공동도급사",{"$f":"참여업체현황!B9","v":"C건축사"},null,"환산지분율",null,{"$f":"참여업체현황!D9","v":0.17499999999999999}]
[]
["구분","권리내용","권리권자","등록일자","경과기간\n(입찰공고일기준)","활용건수","활용금액\n(억원)","개발실적"]
[{"$nulls":7},"가중치","자기평가","확인"]
["총   계",null,"-","-","-","-","-","-",{"$f":"ROUND(SUM(I51:I59),2)","v":1.49},{"$f":"SUM(J51:J59)","v":0}]
["건설신기술","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D51+1)/365,0)","v":2},3,"15억",0.8,{"$f":"ROUND(H51*(1),2)","v":0.8},"-"]
[{"$nulls":8},{"$f":"ROUND(H52*(1),2)","v":0},"-"]
[{"$nulls":8},{"$f":"ROUND(H53*(1),2)","v":0},"-"]
["건설기술에\n관한 특허","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D54+1)/365,0)","v":2},3,"15억",0.8,{"$f":"ROUND(H54*(0.6),2)","v":0.48},"-"]
[{"$nulls":8},{"$f":"ROUND(H55*(0.6),2)","v":0},"-"]
[{"$nulls":8},{"$f":"ROUND(H56*(0.6),2)","v":0},"-"]
["건설기술에\n관한 실용신안","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D57+1)/365,0)","v":2},2,"13억",0.7,{"$f":"ROUND(H57*(0.3),2)","v":0.21},"-"]
[{"$nulls":8},{"$f":"ROUND(H58*(0.3),2)","v":0},"-"]
[{"$nulls":8},{"$f":"ROUND(H59*(0.3),2)","v":0},"-"]

{"sheet":"4(3)R&D참여실적","index":8,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[[7,0,7,1],[5,6,5,8],[5,3,6,3],[5,4,6,4],[5,5,6,5],[1,0,1,8],[3,0,3,1],[5,0,6,1],[5,2,6,2],[31,2,32,2],[31,3,32,3],[15,2,16,2],[15,3,16,3],[31,0,32,0],[31,1,32,1],[17,0,17,1],[18,0,20,0],[21,0,23,0],[24,0,26,0],[15,6,16,6],[15,7,15,8],[15,4,16,4],[15,5,16,5],[15,0,16,0],[15,1,16,1],[47,4,48,4],[47,5,48,5],[31,6,32,6],[31,7,31,8],[47,6,48,6],[47,7,47,8],[31,4,32,4],[31,5,32,5],[33,0,33,1],[34,0,36,0],[37,0,39,0],[40,0,42,0],[47,0,48,0],[47,1,48,1],[47,2,48,2],[47,3,48,3],[49,0,49,1],[50,0,52,0],[53,0,55,0],[56,0,58,0]]}
[]
["4-4. R&D사업 참여실적"]
[]
["R&D사업 참여실적 총계"]
[]
["R&D사업 참여실적",null,"환산지분율","주연구기관","협동연구기관","참여기업","실적점수"]
[{"$nulls":6},"배점","자기평가","확인"]
["총   계",null,"-",{"$f":"$C9*D9+$C10*D10+$C11*D11","v":1.2},0.60000000000000009,0.30000000000000004,1,{"$f":"ROUND($C9*H9+$C10*H10+$C11*H11,2)","v":2.1},0]
[{"$f":"A14","v":"대 표 사"},{"$f":"B14","v":"A건축사"},{"$f":"참여업체현황!$D$5","v":0.5},{"$f":"SUM(H19:H21)","v":1.7999999999999998},{"$f":"SUM(H22:H24)","v":1.2000000000000002},{"$f":"SUM(H25:H27)","v":0.60000000000000009},1,{"$f":"H18","v":3.6},{"$f":"I18","v":0}]
[{"$f":"A30","v":"공동도급사"},{"$f":"B30","v":"B건축사"},{"$f":"참여업체현황!$D$7","v":0.32500000000000001},{"$f":"SUM(H35:H37)","v":0.6},{"$f":"SUM(H38:H40)","v":0},{"$f":"SUM(H41:H43)","v":0},1,{"$f":"H34","v":0.6},{"$f":"I34","v":0}]
[{"$f":"A46","v":"공동도급사"},{"$f":"B30","v":"B건축사"},{"$f":"참여업체현황!$D$9","v":0.17499999999999999},{"$f":"SUM(H51:H53)","v":0.6},{"$f":"SUM(H54:H56)","v":0},{"$f":"SUM(H57:H59)","v":0},1,{"$f":"H50","v":0.6},{"$f":"I50","v":0}]
[]
[]
["대 표 사",{"$f":"참여업체현황!B5","v":"A건축사"},null,"환산지분율",null,{"$f":"참여업체현황!$D$5","v":0.5}]
[]
["구분","권리내용","권리권자","기준일","경과기간(년)\n(입찰공고일기준)","참여점수","참여금액\n(억원)","참여실적"]
[{"$nulls":7},"자기평가","확인"]
["총   계",null,"-","-","-","-","-",{"$f":"SUM(H19:H27)","v":3.6},{"$f":"SUM(I19:I27)","v":0}]
["주연구기관참여","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D19+1)/365,0)","v":2},0.6,"15억",{"$f":"F19","v":0.6}]
[{"$nulls":5},0.6,null,{"$f":"F20","v":0.6}]
[{"$nulls":5},0.6,null,0.6]
["협동연구기관참여","00신기술",null,null,null,0.4,null,0.4]
[{"$nulls":5},0.4,null,0.4]
[{"$nulls":5},0.4,null,0.4]
["참여기업으로참여","00신기술",null,null,null,0.2,null,0.2]
[{"$nulls":5},0.2,null,0.2]
[{"$nulls":5},0.2,null,0.2]
[]
[]
["공동도급사",{"$f":"참여업체현황!B7","v":"B건축사"},null,"환산지분율",null,{"$f":"참여업체현황!$D$7","v":0.32500000000000001}]
[]
["구분","권리내용","권리권자","기준일","경과기간(년)\n(입찰공고일기준)","참여점수","활용금액\n(억원)","참여실적"]
[{"$nulls":7},"자기평가","확인"]
["총   계",null,"-","-","-","-","-",{"$f":"SUM(H35:H43)","v":0.6},{"$f":"SUM(I35:I43)","v":0}]
["주연구기관참여","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D35+1)/365,0)","v":2},0.6,"15억",{"$f":"F35","v":0.6}]
[{"$nulls":7},{"$f":"F36","v":0}]
[{"$nulls":7},0]
["협동연구기관참여","00신기술",{"$nulls":5},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
["참여기업으로참여","00신기술",{"$nulls":5},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
[]
[]
["공동도급사",{"$f":"참여업체현황!B9","v":"C건축사"},null,"환산지분율",null,{"$f":"참여업체현황!$D$9","v":0.17499999999999999}]
[]
["구분","권리내용","권리권자","기준일","경과기간(년)\n(입찰공고일기준)","참여점수","활용금액\n(억원)","참여실적"]
[{"$nulls":7},"자기평가","확인"]
["총   계",null,"-","-","-","-","-",{"$f":"SUM(H51:H59)","v":0.6},{"$f":"SUM(I51:I59)","v":0}]
["주연구기관참여","00신기술","홍길동","2009-02-03",{"$f":"ROUNDUP((총괄표!$H$3-D51+1)/365,0)","v":2},0.6,"15억",{"$f":"F51","v":0.6}]
[{"$nulls":7},{"$f":"F52","v":0}]
[{"$nulls":7},0]
["협동연구기관참여","00신기술",{"$nulls":5},0]
[{"$nulls":7},0]
[{"$nulls":7},0]
["참여기업으로참여","00신기술",{"$nulls":5},0]
[{"$nulls":7},0]
[{"$nulls":7},0]

{"sheet":"5.업무중첩도","index":9,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,0,5,2],[1,0,1,14],[3,0,4,2],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[6,3,8,3],[3,14,4,14],[6,4,8,4],[6,5,8,5],[6,7,8,7],[6,6,8,6],[10,0,10,2],[3,13,4,13],[11,0,13,2],[11,4,13,4],[3,3,4,3],[11,5,13,5],[11,6,13,6],[6,0,8,2],[3,12,4,12],[3,10,3,11],[11,7,13,7],[17,0,19,2],[17,4,19,4],[17,5,19,5],[17,6,19,6],[17,7,19,7],[11,3,13,3],[14,3,16,3],[17,3,19,3],[14,0,16,2],[20,0,22,2],[20,4,22,4],[20,5,22,5],[20,6,22,6],[20,3,22,3],[14,7,16,7],[14,4,16,4],[14,5,16,5],[14,6,16,6],[20,7,22,7]]}
[]
["5. 업무중첩도"]
[]
["책임분야",null,null,"중첩기간\n(개월)","배  점","자기\n평가","확  인","성  명","용역명","계약금액","용역기간 중첩",null,"중첩기간(일)","발주청","기타"]
[{"$nulls":10},"입찰공고일(당해용역)","용역준공일"]
["책 임 기 술 자     총   계",null,null,"-",{"$f":"E7","v":6},{"$f":"F7","v":6},{"$f":"G7","v":0},"-","-","-","-","-","-","-","-"]
["사업책임기술자",null,null,{"$f":"ROUNDDOWN(SUM(M7:M9)/30,0)","v":14},6,6,null,"000","00설계","00,000","2009-03-05","2010-05-20",{"$f":"(L7-K7+1)","v":442}]
[]
[]
[]
["분야별책임기술자     총   계",null,null,"-",{"$f":"E12*'1(1)참여기술자'!$C$45+E15*'1(1)참여기술자'!$D$45+E18*'1(1)참여기술자'!$E$45+E21*'1(1)참여기술자'!$F$45","v":3.9999999999999996},{"$f":"ROUND(F12*'1(1)참여기술자'!$C$45+F15*'1(1)참여기술자'!$D$45+F18*'1(1)참여기술자'!$E$45+F21*'1(1)참여기술자'!$F$45,2)","v":0},{"$f":"ROUND(G12*'1(1)참여기술자'!$C$45+G15*'1(1)참여기술자'!$D$45+G18*'1(1)참여기술자'!$E$45+G21*'1(1)참여기술자'!$F$45,2)","v":0},"-","-","-","-",null,"-","-","-"]
["건축설계",null,null,{"$f":"SUM(M12:M14)/30","v":14.733333333333333},4,null,null,"홍길동","00설계","00,000","2009-03-05","2010-05-20",{"$f":"(L12-K12+1)","v":442},"00공사"]
[]
[]
["토질 및 기초",null,null,{"$f":"SUM(M15:M17)/30","v":0},4]
[]
[]
["전기",null,null,{"$f":"SUM(M18:M20)/30","v":0},4]
[]
[]
["기계",null,null,{"$f":"SUM(M21:M23)/30","v":0},4]