{"text_format":"2","workbook":"xlsx","n_sheets":12,"sheets":["참여업체현황","참여감리원 명단","자기평가서","가.개인별 경력 및 실적목록","가.해당분야 경력","가.직무분야 실적","가.교육 및 감리자격 현황","나.유사용역사업 수행실적","다.신용도","라.기술개발 및 투자실적","마.업무중첩도","바.교체빈도"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":37,"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":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[11,1,11,6],[12,1,12,6],[13,1,13,6],[0,1,0,6],[2,5,2,6],[2,4,3,4],[2,3,3,3],[2,2,3,2],[2,1,3,1]]}
[null,"참여업체 현황"]
[{"$nulls":5},"공고일","2013-10-04"]
[null,"업 체 명","주    소","대표자","지분율\n(%)","면허사항"]
[{"$nulls":5},"종합감리\n전문회사","토목감리\n전문회사"]
[null,"A사","00시00동00번지","홍길동",0.4,"o"]
[null,"B사","00시00동00번지","홍삼둥",0.3,"o"]
[null,"C사","00시00동00번지","홍사덩",0.1,"o"]
[null,"D사","00시00동00번지","홍모셩",0.1,"o"]
[null,"E사","00시00동00번지","홍둥성",0.1,"o"]
[]
[null,"※ 작성유의사항"]
[null,"1. 빨강색으로 표시된 곳만 수정 입력하고 추가사항 있을시\n   \"셀 복사 → 복사한 셀 삽입\"을 통하여 기재하며, 계산식이 연동되었는지 확인한다."]
[null,"2. 공고일에 맞도록 날짜 수정 기입한다"]
[null,"3. 5개 업체 컨소시엄 기준으로 작성한 산정표 이므로\n   만약 3개 업체 컨소시엄으로 참여시 필요없는 셀은 삭제한다(수식 오류 수정 필요)"]

{"sheet":"참여감리원 명단","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,1,9,1],[2,10,3,10],[0,1,0,10],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,7,2,8],[2,9,3,9]]}
[null,"참여감리원 명단(등급)"]
[]
[null,"구분","분야\n(등급)","성명","기술\n자격명","주민번호","나이","학력",null,"소속","비고"]
[{"$nulls":6},"(만 00세)","최종학력\n(학위)","졸업/\n취득일"]
[null,"책임\n감리원","토목분야\n(수석감리사)","홍길일","토목시공기술사","000-000",0,"석사","00-00-00","00엔지니어링"]
[null,"보조\n감리원","토목분야\n(감리사)","홍길이","토목시공기술사","00-00",0,"학사","00-00-00","00기술단"]
[null,"기술\n지원\n감리원","토목분야\n(수석감리사)","홍길삼","도로및공항기술사","00-00",0,"학사","00-00-00","00기술단","도로및공항"]
[null,null,"토목분야\n(수석감리사)","홍길사","토질및기초기술사","00-00",0,"학사","00-00-00","00엔지니어링","토질및기초"]
[null,null,"토목분야\n(수석감리사)","홍길오","토목구조기술사","00-00",0,"학사","00-00-00","00감리단","토목구조"]
[null,null,"토목분야\n(수석감리사)","홍길육","상하수도기술사","00-00",0,"학사","00-00-00","00엔지니어링","상하수도"]

{"sheet":"자기평가서","index":2,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[39,1,41,1],[39,3,39,4],[40,3,40,4],[41,2,41,4],[37,1,37,4],[31,3,31,4],[32,3,32,4],[31,1,33,1],[33,2,33,4],[34,1,36,1],[36,2,36,4],[35,3,35,4],[34,3,34,4],[30,2,30,4],[28,1,30,1],[28,3,28,4],[29,3,29,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[24,1,27,1],[3,2,10,2],[10,3,10,4],[0,1,0,7],[22,2,22,4],[27,2,27,4],[3,1,22,1],[11,2,16,2],[13,3,14,3],[17,2,21,2],[19,3,20,3],[16,3,16,4],[21,3,21,4],[2,3,2,4],[5,3,6,3],[7,3,8,3]]}
[null,"자기 평가서"]
[]
[null,"항목","세부항목","평가내용",null,"배점","평점","비고"]
[null,"가.참여\n감리원\n[50]","(1)책임\n감리원\n[25]","(가)등급","300억,1년,수석감리사","적.부","적"]
[null,null,null,"(나)해당분야경력","해당분야100%,\n그외60%",9,{"$f":"'가.개인별 경력 및 실적목록'!F5","v":"9"}]
[null,null,null,"(다)직무분야실적","설계",3,{"$f":"'가.개인별 경력 및 실적목록'!H5","v":"3"}]
[{"$nulls":4},"시공 등",6,{"$f":"'가.개인별 경력 및 실적목록'!J5","v":"6"}]
[null,null,null,"(라)교육훈련","교육훈련",0.5,{"$f":"'가.교육 및 감리자격 현황'!I5","v":"0.5"}]
[{"$nulls":4},"기술자격",0.5,{"$f":"'가.교육 및 감리자격 현황'!I21","v":"0.5"}]
[null,null,null,"(마)면접(발표)","0점 표기",6,0]
[null,null,null,"소계",null,{"$f":"SUM(F4:F10)","v":25},{"$f":"G5+G6+G7+G8+G9+G10","v":19}]
[null,null,"(2)보조\n감리원\n[25]","(가)등급","감리사 이상","적.부"]
[null,null,null,"(나)해당분야경력","해당분야100%,\n그외60%",9,{"$f":"'가.개인별 경력 및 실적목록'!F6","v":"6.3"}]
[null,null,null,"(다)직무분야실적","설계",2,{"$f":"'가.개인별 경력 및 실적목록'!H6","v":"2"}]
[{"$nulls":4},"시공 등",3,{"$f":"'가.개인별 경력 및 실적목록'!J6","v":"3.0"}]
[null,null,null,"(라)교육훈련","교육훈련",1,{"$f":"'가.교육 및 감리자격 현황'!I7","v":"1"}]
[null,null,null,"소계",null,{"$f":"SUM(F12:F16)","v":15},{"$f":"G13+G14+G15+G16","v":12.3}]
[null,null,"(3)기술\n지원\n감리원\n[25]","(가)등급","수석감리사 : 3\n감리사 이하 : 2",3,{"$f":"'가.교육 및 감리자격 현황'!I23","v":3}]
[null,null,null,"(나)해당분야경력","해당분야100%,\n그외60%",6,{"$f":"('가.개인별 경력 및 실적목록'!F7+'가.개인별 경력 및 실적목록'!F8+'가.개인별 경력 및 실적목록'!F9+'가.개인별 경력 및 실적목록'!F10)/4","v":4.3499999999999996}]
[null,null,null,"(라)교육훈련","교육훈련",0.5,{"$f":"'가.교육 및 감리자격 현황'!I17","v":0.5}]
[{"$nulls":4},"기술자격(기술사)",0.5,{"$f":"'가.교육 및 감리자격 현황'!I22","v":"0.5"}]
[null,null,null,"소계",null,{"$f":"SUM(F18:F21)","v":10},{"$f":"G18+G19+G20+G21","v":8.35}]
[null,null,"소계",null,null,{"$f":"F11+F17+F22","v":50},{"$f":"G11+G17+G22","v":39.65}]
[null,"나. 유사\n용역\n수행실적\n[10]","(1)감리\n전문\n회사\n실적","업체별 수행실적금액 합산하여 평가\n(최근 3년간)",null,10,{"$f":"'나.유사용역사업 수행실적'!J10","v":"6"}]
[null,"다. 신용도\n[15]","(1)입찰\n참가\n제한\n업무정지","감리전문회사(0.2점 감점/월)\n참여감리원(0.2점 감점/월)",null,7,{"$f":"F25-다.신용도!G7","v":6.4}]
[null,null,"(2)부실\n벌점","감리전문회사\n참여감리원",null,5,{"$f":"F26-다.신용도!G13","v":2}]
[null,null,"(3)재정\n상태\n건실도","신용평가등급\n(업체평점×지분율의 합)",null,3,{"$f":"다.신용도!G17","v":2.67}]
[null,null,"소계",null,null,{"$f":"SUM(F25:F27)","v":15},{"$f":"G25+G26+G27","v":11.07}]
[null,"라. 기술\n개발\n및 투자\n실적\n[10]","(1)개발\n실적","건설신기술, 특허, 실용신안",null,3,{"$f":"'라.기술개발 및 투자실적'!H9","v":3}]
[null,null,"(2)투자\n실적","3년간 \n기술개발투자실적/건설부문총매출액",null,7,{"$f":"'라.기술개발 및 투자실적'!N106","v":"6.4"}]
[null,null,"소계",null,null,{"$f":"SUM(F29:F30)","v":10},{"$f":"G29+G30","v":9.4}]
[null,"마. 업무\n중첩도\n[5]","(1)상주\n감리원","책임감리원2, 보조감리원1",null,3,{"$f":"마.업무중첩도!F8","v":3}]
[null,null,"(2)기술\n지원\n감리원","10개이상 중복배치시 0점",null,2,{"$f":"마.업무중첩도!F25","v":2}]
[null,null,"소계",null,null,{"$f":"SUM(F32:F33)","v":5},{"$f":"G32+G33","v":5}]
[null,"바. 교체\n빈도","(1)감리\n전문\n회사","1년간 현장배치된 감리원수 교체빈도율",null,5,{"$f":"바.교체빈도!J13","v":"4.5"}]
[null,null,"(2)참여\n감리원","0.25점/회 감점",null,5,{"$f":"바.교체빈도!H25","v":4.45}]
[null,null,"소계",null,null,{"$f":"SUM(F35:F36)","v":10},{"$f":"G35+G36","v":8.9499999999999993}]
[null,"계",null,null,null,{"$f":"F23+F24+F28+F31+F34+F37","v":100},{"$f":"G23+G24+G28+G31+G34+G37","v":80.070000000000007}]
[]
[null,"가감점\n 평가기준","가점","공사비 절감기여 감리원"]
[null,null,"감점","부패행위 관련자"]
[null,null,"계"]

{"sheet":"가.개인별 경력 및 실적목록","index":3,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,1,10,1],[2,4,2,5],[2,6,2,9],[0,1,0,9],[2,1,3,1],[2,2,3,2],[2,3,3,3]]}
[null,"참여감리원 개인별 경력 및 실적목록"]
[]
[null,"구분","분야\n(등급)","성명","해당분야 경력(년)",null,"직무분야실적(년)"]
[{"$nulls":4},"보조감리원은(월)","점수","설계 등(년)","점수","시공 등(년)","점수"]
[null,{"$f":"'참여감리원 명단'!B5","v":"책임\n감리원"},null,{"$f":"'참여감리원 명단'!D5","v":"홍길일"},{"$f":"'가.해당분야 경력'!E17/365","v":22.375890410958903},{"$f":"IF(E5>=13,\"9\",IF(E5>=11,\"8.1\", IF(E5>=9,\"7.2\", IF(E5>=7,\"6.3\", IF(E5<7,\"5.4\")))))","v":"9"},{"$f":"('가.직무분야 실적'!D7+'가.직무분야 실적'!D19)/365","v":66.049315068493144},{"$f":"IF(G5>=15,\"3\",IF(G5>=13,\"2.7\", IF(G5>=11,\"2.4\", IF(G5>=9,\"2.1\", IF(G5<9,\"1.8\")))))","v":"3"},{"$f":"('가.직무분야 실적'!D19)/365","v":33.024657534246572},{"$f":"IF(I5>=7,\"6\",IF(I5>=5,\"5.4\", IF(I5>=3,\"4.8\", IF(I5>=2,\"4.2\", IF(I5<2,\"6.3\")))))","v":"6"}]
[null,{"$f":"'참여감리원 명단'!B6","v":"보조\n감리원"},null,{"$f":"'참여감리원 명단'!D6","v":"홍길이"},{"$f":"'가.해당분야 경력'!E36/30.5","v":32.059016393442619},{"$f":"IF(E6>=48,\"9\",IF(E6>=42,\"8.1\", IF(E6>=36,\"7.2\", IF(E6>=30,\"6.3\", IF(E6<30,\"5.4\")))))","v":"6.3"},{"$f":"('가.직무분야 실적'!D37+'가.직무분야 실적'!D49)/365","v":66.049315068493144},{"$f":"IF(G6>=10,\"2\",IF(G6>=8,\"1.8\", IF(G6>=6,\"1.6\", IF(G6>=4,\"1.4\", IF(G6<4,\"1.2\")))))","v":"2"},{"$f":"('가.직무분야 실적'!D49)/365","v":33.024657534246572},{"$f":"IF(I6>=4,\"3.0\",IF(I6>=3,\"2.7\", IF(I6>=2,\"2.4\",IF(I6<2,\"2.1\"))))","v":"3.0"}]
[null,{"$f":"'참여감리원 명단'!B7:B10","v":"기술\n지원\n감리원"},"도로및 공항",{"$f":"'참여감리원 명단'!D7","v":"홍길삼"},{"$f":"'가.해당분야 경력'!E57/365","v":12.483287671232876},{"$f":"IF(E7>=13,\"6\",IF(E7>=11,\"5.4\", IF(E7>=9,\"4.8\", IF(E7>=7,\"4.2\", IF(E7<7,\"3.6\")))))","v":"5.4"},"-","-","-","-"]
[null,null,"토질 및 기초",{"$f":"'참여감리원 명단'!D8","v":"홍길사"},{"$f":"'가.해당분야 경력'!E78/365","v":10.018082191780822},{"$f":"IF(E8>=13,\"6\",IF(E8>=11,\"5.4\", IF(E8>=9,\"4.8\", IF(E8>=7,\"4.2\", IF(E8<7,\"3.6\")))))","v":"4.8"},"-","-","-","-"]
[null,null,"토목구조",{"$f":"'참여감리원 명단'!D9","v":"홍길오"},{"$f":"'가.해당분야 경력'!E99/365","v":5.3249315068493148},{"$f":"IF(E9>=13,\"6\",IF(E9>=11,\"5.4\", IF(E9>=9,\"4.8\", IF(E9>=7,\"4.2\", IF(E9<7,\"3.6\")))))","v":"3.6"},"-","-","-","-"]
[null,null,"상하수도",{"$f":"'참여감리원 명단'!D10","v":"홍길육"},{"$f":"'가.해당분야 경력'!E120/365","v":4.8016438356164377},{"$f":"IF(E10>=13,\"6\",IF(E10>=11,\"5.4\", IF(E10>=9,\"4.8\", IF(E10>=7,\"4.2\", IF(E10<7,\"3.6\")))))","v":"3.6"},"-","-","-","-"]
[null,null,"계",null,null,{"$f":"ROUND((F7+F8+F9+F10)/4,2)","v":4.3499999999999996}]

{"sheet":"가.해당분야 경력","index":4,"n_rows":128,"n_cols":11,"rows_kept":128,"cut":false,"hidden":false,"merged":[[126,1,126,2],[127,1,127,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[22,1,22,2],[24,1,24,2],[23,1,23,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[41,1,41,2],[40,1,40,2],[42,1,42,2],[43,1,43,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[40,4,40,5],[61,4,61,5],[82,4,82,5],[103,4,103,5],[52,5,52,6],[94,5,94,6],[115,5,115,6],[4,6,5,6],[121,1,121,2],[63,1,63,2],[64,1,64,2],[79,1,79,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[53,1,53,10],[54,1,55,2],[54,6,55,6],[54,7,54,9],[54,10,55,10],[73,5,73,6],[75,1,76,2],[75,6,76,6],[75,7,75,9],[75,10,76,10],[74,1,74,10],[62,1,62,2],[56,4,56,5],[57,1,57,2],[57,4,57,5],[54,3,54,5],[75,3,75,5],[120,4,120,5],[125,1,125,2],[119,4,119,5],[120,1,120,2],[117,1,118,2],[117,6,118,6],[117,7,117,9],[117,10,118,10],[116,1,116,10],[117,3,117,5],[122,1,122,2],[123,1,123,2],[124,1,124,2],[124,4,124,5],[105,1,105,2],[106,1,106,2],[104,1,104,2],[98,4,98,5],[99,1,99,2],[99,4,99,5],[100,1,100,2],[101,1,101,2],[102,1,102,2],[103,1,103,2],[96,1,97,2],[96,6,97,6],[96,7,96,9],[96,10,97,10],[95,1,95,10],[84,1,84,2],[85,1,85,2],[83,1,83,2],[77,4,77,5],[78,1,78,2],[78,4,78,5],[96,3,96,5],[35,4,35,5],[36,1,36,2],[36,4,36,5],[32,1,32,10],[33,1,34,2],[33,6,34,6],[33,7,33,9],[33,10,34,10],[10,1,10,10],[14,3,14,5],[33,3,33,5],[0,1,0,10],[17,4,17,5],[21,4,21,5],[21,1,21,2],[17,1,17,2],[6,1,6,2],[4,10,5,10],[4,7,4,9],[16,4,16,5],[13,1,13,10],[14,1,15,2],[14,6,15,6],[14,7,14,9],[14,10,15,10],[3,1,3,10],[4,1,5,2],[4,3,4,5]]}
[null,"책임감리원 등급판정"]
[]
[null,"○","책임감리원",null,{"$f":"'참여감리원 명단'!D5","v":"홍길일"}]
[null,"경력사항"]
[null,"사업명",null,"공사개요(면적, 금액)",null,null,"근무형태\n 및 직책","참여당시",null,null,"발주처"]
[null,null,null,"면적,금액등","(참여기간)","(일수)",null,"소속회사","등급","직위"]
[null,"00부지조성공사",null,"면적 400,000","94.10.10~09.10.09",5479,"상주/보조","00엔지니어링","수석감리사","과장","00시"]
[]
[]
[]
[null,"참여감리원 개인별 해당분야 경력"]
[]
[null,"○","책임감리원",null,{"$f":"'참여감리원 명단'!D5","v":"홍길일"}]
[null,"경력사항"]
[null,"사업명",null,"공사개요(면적, 금액)",null,null,"근무형태\n 및 직책","참여당시",null,null,"발주처"]
[null,null,null,"면적,금액등","(참여기간)","(일수)",null,"소속회사","등급","직위"]
[null,"합계","총00건",null,{"$f":"E18+E22","v":8167.2}]
[null,"100%계",null,null,{"$f":"SUM(F19:F21)","v":6597}]
[null,"00부지조성공사",null,"면적 : 20,000,000㎡","94.10.10~09.10.09",1540,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",2642,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",2415,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"60%계",null,null,{"$f":"SUM(F23:F25)*0.6","v":1570.2}]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",1530,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00관거정비공사",null,"D100, 5.6km","12.10.10~13.01.03",87,"상주/책임","00엔지니어링","감리사보","과장","00시"]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",1000,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[]
[]
[]
[]
[]
[]
[null,"○",{"$f":"'참여감리원 명단'!B6","v":"보조\n감리원"},null,{"$f":"'참여감리원 명단'!D6","v":"홍길이"}]
[null,"경력사항"]
[null,"사업명",null,"공사개요(면적, 금액)",null,null,"근무형태\n 및 직책","참여당시",null,null,"발주처"]
[{"$nulls":4},"(참여기간)","(일수)",null,"소속회사","등급","직위"]
[null,"합계","총00건",null,{"$f":"E37+E41","v":977.8}]
[null,"100%계",null,null,{"$f":"SUM(F38:F40)","v":598}]
[null,"00부지조성공사",null,"면적 : 20,000,000㎡","94.10.10~09.10.09",124,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",221,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",253,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"60%계",null,null,{"$f":"SUM(F42:F44)*0.6","v":379.8}]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",245,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00관거정비공사",null,"D100, 5.6km","12.10.10~13.01.03",134,"상주/책임","00엔지니어링","감리사보","과장","00시"]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",254,"상주/보조","00엔지니어링","감리사보","과장","00시"]
{"$rows_empty":8}
[null,"○",{"$f":"'참여감리원 명단'!B7","v":"기술\n지원\n감리원"},null,{"$f":"'참여감리원 명단'!D7","v":"홍길삼"},{"$f":"'가.개인별 경력 및 실적목록'!C7","v":"도로및 공항"}]
[null,"경력사항"]
[null,"사업명",null,"공사개요(면적, 금액)",null,null,"근무형태\n 및 직책","참여당시",null,null,"발주처"]
[{"$nulls":4},"(참여기간)","(일수)",null,"소속회사","등급","직위"]
[null,"합계","총00건",null,{"$f":"E58+E62","v":4556.3999999999996}]
[null,"100%계",null,null,{"$f":"SUM(F59:F61)","v":3081}]
[null,"00부지조성공사",null,"면적 : 20,000,000㎡","94.10.10~09.10.09",2543,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",212,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",326,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"60%계",null,null,{"$f":"SUM(F63:F65)*0.6","v":1475.3999999999999}]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",2143,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00관거정비공사",null,"D100, 5.6km","12.10.10~13.01.03",81,"상주/책임","00엔지니어링","감리사보","과장","00시"]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",235,"상주/보조","00엔지니어링","감리사보","과장","00시"]
{"$rows_empty":8}
[null,"○",{"$f":"'참여감리원 명단'!B7","v":"기술\n지원\n감리원"},null,{"$f":"'참여감리원 명단'!D8","v":"홍길사"},{"$f":"'가.개인별 경력 및 실적목록'!C8","v":"토질 및 기초"}]
[null,"경력사항"]
[null,"사업명",null,"공사개요(면적, 금액)",null,null,"근무형태\n 및 직책","참여당시",null,null,"발주처"]
[{"$nulls":4},"(참여기간)","(일수)",null,"소속회사","등급","직위"]
[null,"합계","총00건",null,{"$f":"E79+E83","v":3656.6}]
[null,"100%계",null,null,{"$f":"SUM(F80:F82)","v":2855}]
[null,"00부지조성공사",null,"면적 : 20,000,000㎡","94.10.10~09.10.09",258,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",2356,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",241,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"60%계",null,null,{"$f":"SUM(F84:F86)*0.6","v":801.6}]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",546,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00관거정비공사",null,"D100, 5.6km","12.10.10~13.01.03",254,"상주/책임","00엔지니어링","감리사보","과장","00시"]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",536,"상주/보조","00엔지니어링","감리사보","과장","00시"]
{"$rows_empty":8}
[null,"○",{"$f":"'참여감리원 명단'!B7","v":"기술\n지원\n감리원"},null,{"$f":"'참여감리원 명단'!D9","v":"홍길오"},{"$f":"'가.개인별 경력 및 실적목록'!C9","v":"토목구조"}]
[null,"경력사항"]
[null,"사업명",null,"공사개요(면적, 금액)",null,null,"근무형태\n 및 직책","참여당시",null,null,"발주처"]
[{"$nulls":4},"(참여기간)","(일수)",null,"소속회사","등급","직위"]
[null,"합계","총00건",null,{"$f":"E100+E104","v":1943.6}]
[null,"100%계",null,null,{"$f":"SUM(F101:F103)","v":1409}]
[null,"00부지조성공사",null,"면적 : 20,000,000㎡","94.10.10~09.10.09",513,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",358,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",538,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"60%계",null,null,{"$f":"SUM(F105:F107)*0.6","v":534.6}]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",234,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00관거정비공사",null,"D100, 5.6km","12.10.10~13.01.03",125,"상주/책임","00엔지니어링","감리사보","과장","00시"]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",532,"상주/보조","00엔지니어링","감리사보","과장","00시"]
{"$rows_empty":8}
[null,"○",{"$f":"'참여감리원 명단'!B7","v":"기술\n지원\n감리원"},null,{"$f":"'참여감리원 명단'!D10","v":"홍길육"},{"$f":"'가.개인별 경력 및 실적목록'!C10","v":"상하수도"}]
[null,"경력사항"]
[null,"사업명",null,"공사개요(면적, 금액)",null,null,"근무형태\n 및 직책","참여당시",null,null,"발주처"]
[{"$nulls":4},"(참여기간)","(일수)",null,"소속회사","등급","직위"]
[null,"합계","총00건",null,{"$f":"E121+E125","v":1752.6}]
[null,"100%계",null,null,{"$f":"SUM(F122:F124)","v":1053}]
[null,"00부지조성공사",null,"면적 : 20,000,000㎡","94.10.10~09.10.09",251,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",534,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00부지조성공사",null,"면적 : 1,000,000㎡","09.10.10~12.10.09",268,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"60%계",null,null,{"$f":"SUM(F126:F128)*0.6","v":699.6}]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",248,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[null,"00관거정비공사",null,"D100, 5.6km","12.10.10~13.01.03",653,"상주/책임","00엔지니어링","감리사보","과장","00시"]
[null,"00도로확장공사",null,"2-4차로확장, 1.4km","09.10.10~12.10.09",265,"상주/보조","00엔지니어링","감리사보","과장","00시"]

{"sheet":"가.직무분야 실적","index":5,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,0,50,1],[37,0,37,1],[38,0,38,1],[46,8,47,8],[46,0,47,1],[46,2,47,2],[46,4,47,4],[46,5,46,7],[43,0,43,1],[44,0,44,1],[16,2,17,2],[16,4,17,4],[16,5,16,7],[16,8,17,8],[49,0,49,1],[34,2,35,2],[34,4,35,4],[34,5,34,7],[34,8,35,8],[34,0,35,1],[25,0,25,1],[26,0,26,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[0,0,0,8],[19,0,19,1],[7,0,7,1],[8,0,8,1],[20,0,20,1],[16,0,17,1],[4,0,5,1],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,2,5,2],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[56,0,56,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[55,0,55,1]]}
["참여감리원 개인별 직무분야 실적"]
[]
["○ 책임감리원 ",null,{"$f":"'가.해당분야 경력'!E3","v":"홍길일"}]
["  - 직무분야 실적<설계>"]
["사업명",null,"(참여기간)","실적","근무형태\n 및 직책","참여당시",null,null,"발주처"]
[null,null,null,"(일수)",null,"소속회사","등급","직위"]
["계","총00건","-",{"$f":"SUM(D8:D15)","v":12054},"-","-","-","-","-"]
["00부지조성공사",null,"94.10.10~09.10.09",5479,"상주/보조","00엔지니어링","감리사보","과장","00시"]
["00부지조성공사",null,"09.10.10~12.10.09",6575,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[]
[]
[]
[]
[]
[]
["  - 직무분야 실적<시공 등>"]
["사업명",null,"(참여기간)","실적","근무형태\n 및 직책","참여당시",null,null,"발주처"]
[null,null,null,"(일수)",null,"소속회사","등급","직위"]
["계","총00건","-",{"$f":"SUM(D20:D27)","v":12054},"-","-","-","-","-"]
["00부지조성공사",null,"94.10.10~09.10.09",5479,"상주/보조","00엔지니어링","감리사보","과장","00시"]
["00부지조성공사",null,"09.10.10~12.10.09",6575,"상주/보조","00엔지니어링","감리사보","과장","00시"]
{"$rows_empty":11}
["○ 보조감리원",null,{"$f":"'가.해당분야 경력'!E32","v":"홍길이"}]
["  - 직무분야 실적<설계>"]
["사업명",null,"(참여기간)","실적","근무형태\n 및 직책","참여당시",null,null,"발주처"]
[null,null,null,"(일수)",null,"소속회사","등급","직위"]
["계","총00건","-",{"$f":"SUM(D38:D45)","v":12054},"-","-","-","-","-"]
["00부지조성공사",null,"94.10.10~09.10.09",5479,"상주/보조","00엔지니어링","감리사보","과장","00시"]
["00부지조성공사",null,"09.10.10~12.10.09",6575,"상주/보조","00엔지니어링","감리사보","과장","00시"]
[]
[]
[]
[]
[]
[]
["  - 직무분야 실적<시공 등>"]
["사업명",null,"(참여기간)","실적","근무형태\n 및 직책","참여당시",null,null,"발주처"]
[null,null,null,"(일수)",null,"소속회사","등급","직위"]
["계","총00건","-",{"$f":"SUM(D50:D57)","v":12054},"-","-","-","-","-"]
["00부지조성공사",null,"94.10.10~09.10.09",5479,"상주/보조","00엔지니어링","감리사보","과장","00시"]
["00부지조성공사",null,"09.10.10~12.10.09",6575,"상주/보조","00엔지니어링","감리사보","과장","00시"]

{"sheet":"가.교육 및 감리자격 현황","index":6,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[22,8,25,8],[22,1,22,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[23,1,23,2],[20,1,20,2],[21,1,21,2],[20,3,20,4],[21,3,21,4],[14,8,15,8],[19,1,19,2],[19,3,19,4],[14,2,15,2],[14,7,15,7],[14,3,15,3],[8,1,16,1],[10,8,11,8],[12,8,13,8],[12,7,13,7],[12,3,13,3],[12,2,13,2],[0,1,0,8],[3,1,3,2],[4,7,5,7],[6,7,7,7],[8,7,9,7],[4,1,7,1],[4,2,5,2],[6,2,7,2],[4,8,5,8],[6,8,7,8],[8,8,9,8],[10,2,11,2],[8,2,9,2],[10,7,11,7],[4,3,5,3],[6,3,7,3],[8,3,9,3],[10,3,11,3]]}
[null,"교육이수 실적 및 감리자격 현황"]
[]
[null,"가. 교육훈련"]
[null,"구분",null,"성명","교육과정명","교육기관","교육기간","기간","점수"]
[null,"상주\n감리원","책임\n감리원",{"$f":"'참여감리원 명단'!D5","v":"홍길일"},"전문1","건설기술교육원","11.11.11~ 11.11.16",2,{"$f":"IF(H5>=2,\"0.5\",IF(H5=0,\"0\",IF(H5<2,\"0.3\")))","v":"0.5"},null,0]
[{"$nulls":4},"전문2","건설기술교육원","11.11.19~ 11.11.123",null,null,null,1]
[null,null,"보조\n감리원",{"$f":"'참여감리원 명단'!D6","v":"홍길이"},"전문1","건설기술교육원","11.11.11~ 11.11.16",2,{"$f":"IF(H7>=2,\"1\",IF(H7=0,\"0\",IF(H7<2,\"0.5\")))","v":"1"},null,2]
[{"$nulls":4},"전문2","건설기술교육원","11.11.19~ 11.11.123"]
[null,"기술\n지원\n감리원","도로및\n공항",{"$f":"'참여감리원 명단'!D7","v":"홍길삼"},"전문1","건설기술교육원","11.11.11~ 11.11.16",2,{"$f":"IF(H9>=2,\"0.5\",IF(H9=0,\"0\",IF(H9<2,\"0.3\")))","v":"0.5"}]
[{"$nulls":4},"전문2","건설기술교육원","11.11.19~ 11.11.123"]
[null,null,"토질및\n기초",{"$f":"'참여감리원 명단'!D8","v":"홍길사"},"전문1","건설기술교육원","11.11.11~ 11.11.16",2,{"$f":"IF(H11>=2,\"0.5\",IF(H11=0,\"0\",IF(H11<2,\"0.3\")))","v":"0.5"}]
[{"$nulls":4},"전문2","건설기술교육원","11.11.19~ 11.11.123"]
[null,null,"토목\n구조",{"$f":"'참여감리원 명단'!D9","v":"홍길오"},"전문1","건설기술교육원","11.11.11~ 11.11.16",2,{"$f":"IF(H13>=2,\"0.5\",IF(H13=0,\"0\",IF(H13<2,\"0.3\")))","v":"0.5"}]
[{"$nulls":4},"전문2","건설기술교육원","11.11.19~ 11.11.123"]
[null,null,"상\n하수도",{"$f":"'참여감리원 명단'!D10","v":"홍길육"},"전문1","건설기술교육원","11.11.11~ 11.11.16",2,{"$f":"IF(H15>=2,\"0.5\",IF(H15=0,\"0\",IF(H15<2,\"0.3\")))","v":"0.5"}]
[{"$nulls":4},"전문2","건설기술교육원","11.11.19~ 11.11.123"]
[{"$nulls":8},{"$f":"ROUND((I9+I11+I13+I15)/4,2)","v":0.5}]
[]
[null,"나.  책임감리원 및 기술지원감리원 기술자격 현황"]
[null,"구분",null,"자격증\n(또는 등급)",null,"분야","비고","-","점수"]
[null,"상주감리원\n(책임감리원)",null,"기술사",null,"토목시공","-",null,{"$f":"IF(D21=\"기술사\",\"0.5\",IF(D21=\"기사\",\"0.3\",IF(D21=\"산업기사\",\"0.1\")))","v":"0.5"},null,"기술사","수석감리사","수석감리사"]
[null,"기술지원감리원\n(자격증평가)",null,"기술사",null,"토질 및 기초","-",null,{"$f":"IF(D22=\"기술사\",\"0.5\",IF(D22=\"기사\",\"0.3\",IF(D22=\"산업기사\",\"0.1\")))","v":"0.5"},null,"기사","감리사이하","감리사"]
[null,"기술지원감리원",null,"수석감리사",null,"도로및 공항",{"$f":"IF(D23=\"수석감리사\",\"3\",IF(D23=\"감리사이하\",\"2\"))","v":"3"},null,{"$f":"ROUND((G23+G24+G25+G26)/4,2)","v":3},null,"산업기사",null,"감리사보"]
[null,"기술지원감리원",null,"수석감리사",null,"토질 및 기초",{"$f":"IF(D24=\"수석감리사\",\"3\",IF(D24=\"감리사이하\",\"2\"))","v":"3"}]
[null,"기술지원감리원",null,"수석감리사",null,"토목구조",{"$f":"IF(D25=\"수석감리사\",\"3\",IF(D25=\"감리사이하\",\"2\"))","v":"3"},null,null,null,"없음"]
[null,"기술지원감리원",null,"수석감리사",null,"상하수도",{"$f":"IF(D26=\"수석감리사\",\"3\",IF(D26=\"감리사이하\",\"2\"))","v":"3"}]

{"sheet":"나.유사용역사업 수행실적","index":7,"n_rows":100,"n_cols":14,"rows_kept":100,"cut":false,"hidden":false,"merged":[[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,4,63,4],[62,5,63,5],[62,9,63,9],[63,6,63,7],[60,1,61,1],[60,2,61,2],[60,3,61,3],[60,4,61,4],[60,5,61,5],[60,9,61,9],[61,6,61,7],[53,1,54,1],[49,6,49,7],[44,9,45,9],[55,5,56,5],[55,9,56,9],[56,6,56,7],[57,1,58,1],[57,2,58,2],[57,3,58,3],[57,4,58,4],[57,5,58,5],[57,9,58,9],[58,6,58,7],[55,1,56,1],[55,2,56,2],[55,3,56,3],[55,4,56,4],[44,1,45,1],[44,2,45,2],[44,3,45,3],[44,4,45,4],[44,5,45,5],[45,6,45,7],[49,1,50,1],[42,1,43,1],[42,2,43,2],[42,3,43,3],[42,4,43,4],[42,5,43,5],[42,9,43,9],[39,1,40,1],[39,2,40,2],[39,3,40,3],[43,6,43,7],[37,1,38,1],[37,2,38,2],[37,3,38,3],[37,4,38,4],[37,5,38,5],[37,9,38,9],[38,6,38,7],[39,4,40,4],[39,5,40,5],[39,9,40,9],[40,6,40,7],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[22,6,22,7],[35,1,36,1],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[25,6,25,7],[26,1,27,1],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[27,6,27,7],[31,1,32,1],[31,2,32,2],[31,3,32,3],[36,6,36,7],[24,1,25,1],[24,2,25,2],[13,1,14,1],[17,1,18,1],[13,6,13,7],[17,2,18,2],[17,3,18,3],[17,4,18,4],[0,1,0,10],[9,3,9,5],[19,1,20,1],[13,10,14,10],[17,10,18,10],[19,10,20,10],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[19,9,20,9],[17,9,18,9],[13,3,14,3],[17,5,18,5],[18,6,18,7],[19,2,20,2],[13,2,14,2],[31,6,31,7],[53,2,54,2],[53,3,54,3],[53,4,54,4],[53,5,54,5],[53,9,54,9],[54,6,54,7],[21,10,22,10],[21,9,22,9],[19,3,20,3],[19,4,20,4],[19,5,20,5],[20,6,20,7],[24,9,25,9],[26,9,27,9],[35,9,36,9],[24,3,25,3],[24,4,25,4],[24,5,25,5],[49,2,50,2],[49,3,50,3],[31,10,32,10],[49,10,50,10],[35,10,36,10],[37,10,38,10],[39,10,40,10],[53,10,54,10],[55,10,56,10],[57,10,58,10],[89,10,90,10],[75,10,76,10],[76,6,76,7],[78,1,79,1],[78,2,79,2],[78,3,79,3],[78,4,79,4],[78,5,79,5],[78,9,79,9],[80,1,81,1],[80,2,81,2],[80,3,81,3],[80,4,81,4],[80,5,81,5],[80,9,81,9],[81,6,81,7],[79,6,79,7],[75,2,76,2],[75,3,76,3],[75,4,76,4],[75,5,76,5],[75,9,76,9],[67,10,68,10],[71,10,72,10],[73,1,74,1],[73,2,74,2],[73,3,74,3],[73,4,74,4],[73,5,74,5],[73,9,74,9],[73,10,74,10],[74,6,74,7],[67,1,68,1],[67,2,68,2],[67,3,68,3],[67,6,67,7],[71,1,72,1],[71,2,72,2],[71,3,72,3],[71,4,72,4],[71,5,72,5],[71,9,72,9],[72,6,72,7],[85,10,86,10],[91,1,92,1],[91,2,92,2],[91,3,92,3],[91,4,92,4],[91,5,92,5],[91,9,92,9],[91,10,92,10],[92,6,92,7],[85,1,86,1],[85,2,86,2],[85,3,86,3],[85,6,85,7],[89,1,90,1],[89,2,90,2],[89,3,90,3],[89,4,90,4],[89,5,90,5],[89,9,90,9],[90,6,90,7],[75,1,76,1],[98,1,99,1],[98,2,99,2],[98,3,99,3],[98,4,99,4],[98,5,99,5],[98,9,99,9],[99,6,99,7],[93,10,94,10],[94,6,94,7],[96,1,97,1],[96,2,97,2],[96,3,97,3],[96,4,97,4],[96,5,97,5],[96,9,97,9],[97,6,97,7],[93,1,94,1],[93,2,94,2],[93,3,94,3],[93,4,94,4],[93,5,94,5],[93,9,94,9]]}
[null,"유사용역사업 수행실적"]
[{"$nulls":9},"산정시작일",{"$f":"K3-365*3","v":"2010-10-05"}]
[{"$nulls":9},"공고일",{"$f":"참여업체현황!G2","v":"2013-10-04"}]
[null,"구분","업체명","적용금액\n(A, 천원)",null,null,"참여지분율\n(B, %)","수행실적\n(A×B, 천원)","수행실적\n(억원)","평가점수"]
[null,1,{"$f":"참여업체현황!B5","v":"A사"},{"$f":"J16","v":2633346.8136207862},null,null,{"$f":"참여업체현황!E5","v":0.4},{"$f":"D5*G5","v":1053338.7254483146}]
[null,2,{"$f":"참여업체현황!B6","v":"B사"},{"$f":"J34","v":2633346.8136207862},null,null,{"$f":"참여업체현황!E6","v":0.3},{"$f":"D6*G6","v":790004.04408623581}]
[null,3,{"$f":"참여업체현황!B7","v":"C사"},{"$f":"J52","v":2633346.8136207862},null,null,{"$f":"참여업체현황!E7","v":0.1},263334.68136207864]
[null,4,{"$f":"참여업체현황!B8","v":"D사"},{"$f":"J70","v":2633346.8136207862},null,null,{"$f":"참여업체현황!E8","v":0.1},263334.68136207864]
[null,5,{"$f":"참여업체현황!B9","v":"E사"},{"$f":"J88","v":2633346.8136207862},null,null,{"$f":"참여업체현황!E9","v":0.1},263334.68136207864]
[null,null,"계",{"$nulls":4},{"$f":"SUM(H5:H9)","v":2633346.8136207862},{"$f":"H10/100000","v":26.333468136207863},{"$f":"IF(I10>=60,\"10\",IF(I10>=50,\"9\", IF(I10>=40,\"8\", IF(I10>=30,\"7\", IF(I10<30,\"6\")))))","v":"6"}]
[]
[]
[null,"○",{"$f":"참여업체현황!B5","v":"A사"}]
[null,"구분","용역명","발주처","준공(계약)\n금액(천원)","도급비율\n(%)","전체사업기간(일)\n(C )",null,"해당기간\n(일)","적용금액\n(천원)","비고"]
[{"$nulls":4},"(A)","(B)","시작","종료","(D)","(A×B×D/C)"]
[null,"합계",null,"총00건",{"$nulls":5},{"$f":"J17+J24","v":2633346.8136207862}]
[null,"해당\n분야",1,{"$nulls":6},{"$f":"SUM(J18:J23)*100%","v":2114677.3749513477},null,null,"산정시작 앞","공고일 뒤"]
[null,1,"000부지조성공사\n감리용역","00공사",1000000,1,"2011-10-02","2013-10-01",null,{"$f":"E18*F18*I19/G19","v":1000000},"완료"]
[{"$nulls":6},{"$f":"IF(H18-G18=0,\" \",IF(H18-G18>0,H18-G18+1))","v":731},null,{"$f":"G19-M19-N19","v":731},null,null,null,{"$f":"IF($K$2-G18<=0, \"0\",IF($K$2-G18>0, $K$2-G18))","v":"0"},{"$f":"IF(H18-$K$3<=0, \"0\",IF(H18-$K$3>0, H18-$K$3))","v":"0"}]
[null,2,"000부지조성공사\n감리용역","00공사",1000000,0.5,"2010-01-03","2016-01-01",null,{"$f":"E20*F20*I21/G21","v":250228.3105022831},"진행"]
[{"$nulls":6},{"$f":"IF(H20-G20=0,\" \",IF(H20-G20>0,H20-G20+1))","v":2190},null,{"$f":"G21-M21-N21","v":1096},null,null,null,{"$f":"IF($K$2-G20<=0, \"0\",IF($K$2-G20>0, $K$2-G20))","v":275},{"$f":"IF(H20-$K$3<=0, \"0\",IF(H20-$K$3>0, H20-$K$3))","v":819}]
[null,3,"000부지조성공사\n감리용역","00공사",2000000,0.7,"2009-10-02","2012-05-20",null,{"$f":"E22*F22*I23/G23","v":864449.06444906443},"완료"]
[{"$nulls":6},{"$f":"IF(H22-G22=0,\" \",IF(H22-G22>0,H22-G22+1))","v":962},null,{"$f":"G23-M23-N23","v":594},null,null,null,{"$f":"IF($K$2-G22<=0, \"0\",IF($K$2-G22>0, $K$2-G22))","v":368},{"$f":"IF(H22-$K$3<=0, \"0\",IF(H22-$K$3>0, H22-$K$3))","v":"0"}]
[null,"기타\n분야",0.6,{"$nulls":6},{"$f":"SUM(J25:J28)*60%","v":518669.43866943865}]
[null,1,"000도로확장공사\n감리용역","00시",1000000,0.8,"2009-10-02","2012-05-20",null,{"$f":"E25*F25*I26/G26","v":493970.89397089399}]
[{"$nulls":6},{"$f":"IF(H25-G25=0,\" \",IF(H25-G25>0,H25-G25+1))","v":962},null,{"$f":"G26-M26-N26","v":594},null,null,null,{"$f":"IF($K$2-G25<=0, \"0\",IF($K$2-G25>0, $K$2-G25))","v":368},{"$f":"IF(H25-$K$3<=0, \"0\",IF(H25-$K$3>0, H25-$K$3))","v":"0"}]
[null,2,"000도로확장공사\n감리용역","00시",1200000,0.5,"2009-10-02","2012-05-20",null,{"$f":"E27*F27*I28/G28","v":370478.1704781705}]
[{"$nulls":6},{"$f":"IF(H27-G27=0,\" \",IF(H27-G27>0,H27-G27+1))","v":962},null,{"$f":"G28-M28-N28","v":594},null,null,null,{"$f":"IF($K$2-G27<=0, \"0\",IF($K$2-G27>0, $K$2-G27))","v":368},{"$f":"IF(H27-$K$3<=0, \"0\",IF(H27-$K$3>0, H27-$K$3))","v":"0"}]
[]
[]
[null,"○",{"$f":"참여업체현황!B6","v":"B사"}]
[null,"구분","용역명","발주처","준공(계약)\n금액(천원)","도급비율\n(%)","전체사업기간(일)\n(C )",null,"해당기간\n(일)","적용금액\n(천원)","비고"]
[{"$nulls":4},"(A)","(B)","시작","종료","(D)","(A×B×D/C)"]
[null,"합계",null,"총00건",{"$nulls":5},{"$f":"J35+J42","v":2633346.8136207862}]
[null,"해당\n분야",1,{"$nulls":6},{"$f":"SUM(J36:J41)*100%","v":2114677.3749513477},null,null,"산정시작 앞","공고일 뒤"]
[null,1,"000부지조성공사\n감리용역","00공사",1000000,1,"2011-10-02","2013-10-01",null,{"$f":"E36*F36*I37/G37","v":1000000},"완료"]
[{"$nulls":6},{"$f":"IF(H36-G36=0,\" \",IF(H36-G36>0,H36-G36+1))","v":731},null,{"$f":"G37-M37-N37","v":731},null,null,null,{"$f":"IF($K$2-G36<=0, \"0\",IF($K$2-G36>0, $K$2-G36))","v":"0"},{"$f":"IF(H36-$K$3<=0, \"0\",IF(H36-$K$3>0, H36-$K$3))","v":"0"}]
[null,2,"000부지조성공사\n감리용역","00공사",1000000,0.5,"2010-01-03","2016-01-01",null,{"$f":"E38*F38*I39/G39","v":250228.3105022831},"진행"]
[{"$nulls":6},{"$f":"IF(H38-G38=0,\" \",IF(H38-G38>0,H38-G38+1))","v":2190},null,{"$f":"G39-M39-N39","v":1096},null,null,null,{"$f":"IF($K$2-G38<=0, \"0\",IF($K$2-G38>0, $K$2-G38))","v":275},{"$f":"IF(H38-$K$3<=0, \"0\",IF(H38-$K$3>0, H38-$K$3))","v":819}]
[null,3,"000부지조성공사\n감리용역","00공사",2000000,0.7,"2009-10-02","2012-05-20",null,{"$f":"E40*F40*I41/G41","v":864449.06444906443},"완료"]
[{"$nulls":6},{"$f":"IF(H40-G40=0,\" \",IF(H40-G40>0,H40-G40+1))","v":962},null,{"$f":"G41-M41-N41","v":594},null,null,null,{"$f":"IF($K$2-G40<=0, \"0\",IF($K$2-G40>0, $K$2-G40))","v":368},{"$f":"IF(H40-$K$3<=0, \"0\",IF(H40-$K$3>0, H40-$K$3))","v":"0"}]
[null,"기타\n분야",0.6,{"$nulls":6},{"$f":"SUM(J43:J46)*60%","v":518669.43866943865}]
[null,1,"000도로확장공사\n감리용역","00시",1000000,0.8,"2009-10-02","2012-05-20",null,{"$f":"E43*F43*I44/G44","v":493970.89397089399}]
[{"$nulls":6},{"$f":"IF(H43-G43=0,\" \",IF(H43-G43>0,H43-G43+1))","v":962},null,{"$f":"G44-M44-N44","v":594},null,null,null,{"$f":"IF($K$2-G43<=0, \"0\",IF($K$2-G43>0, $K$2-G43))","v":368},{"$f":"IF(H43-$K$3<=0, \"0\",IF(H43-$K$3>0, H43-$K$3))","v":"0"}]
[null,2,"000도로확장공사\n감리용역","00시",1200000,0.5,"2009-10-02","2012-05-20",null,{"$f":"E45*F45*I46/G46","v":370478.1704781705}]
[{"$nulls":6},{"$f":"IF(H45-G45=0,\" \",IF(H45-G45>0,H45-G45+1))","v":962},null,{"$f":"G46-M46-N46","v":594},null,null,null,{"$f":"IF($K$2-G45<=0, \"0\",IF($K$2-G45>0, $K$2-G45))","v":368},{"$f":"IF(H45-$K$3<=0, \"0\",IF(H45-$K$3>0, H45-$K$3))","v":"0"}]
[]
[]
[null,"○",{"$f":"참여업체현황!B7","v":"C사"}]
[null,"구분","용역명","발주처","준공(계약)\n금액(천원)","도급비율\n(%)","전체사업기간(일)\n(C )",null,"해당기간\n(일)","적용금액\n(천원)","비고"]
[{"$nulls":4},"(A)","(B)","시작","종료","(D)","(A×B×D/C)"]
[null,"합계",null,"총00건",{"$nulls":5},{"$f":"J53+J60","v":2633346.8136207862}]
[null,"해당\n분야",1,{"$nulls":6},{"$f":"SUM(J54:J59)*100%","v":2114677.3749513477},null,null,"산정시작 앞","공고일 뒤"]
[null,1,"000부지조성공사\n감리용역","00공사",1000000,1,"2011-10-02","2013-10-01",null,{"$f":"E54*F54*I55/G55","v":1000000},"완료"]
[{"$nulls":6},{"$f":"IF(H54-G54=0,\" \",IF(H54-G54>0,H54-G54+1))","v":731},null,{"$f":"G55-M55-N55","v":731},null,null,null,{"$f":"IF($K$2-G54<=0, \"0\",IF($K$2-G54>0, $K$2-G54))","v":"0"},{"$f":"IF(H54-$K$3<=0, \"0\",IF(H54-$K$3>0, H54-$K$3))","v":"0"}]
[null,2,"000부지조성공사\n감리용역","00공사",1000000,0.5,"2010-01-03","2016-01-01",null,{"$f":"E56*F56*I57/G57","v":250228.3105022831},"진행"]
[{"$nulls":6},{"$f":"IF(H56-G56=0,\" \",IF(H56-G56>0,H56-G56+1))","v":2190},null,{"$f":"G57-M57-N57","v":1096},null,null,null,{"$f":"IF($K$2-G56<=0, \"0\",IF($K$2-G56>0, $K$2-G56))","v":275},{"$f":"IF(H56-$K$3<=0, \"0\",IF(H56-$K$3>0, H56-$K$3))","v":819}]
[null,3,"000부지조성공사\n감리용역","00공사",2000000,0.7,"2009-10-02","2012-05-20",null,{"$f":"E58*F58*I59/G59","v":864449.06444906443},"완료"]
[{"$nulls":6},{"$f":"IF(H58-G58=0,\" \",IF(H58-G58>0,H58-G58+1))","v":962},null,{"$f":"G59-M59-N59","v":594},null,null,null,{"$f":"IF($K$2-G58<=0, \"0\",IF($K$2-G58>0, $K$2-G58))","v":368},{"$f":"IF(H58-$K$3<=0, \"0\",IF(H58-$K$3>0, H58-$K$3))","v":"0"}]
[null,"기타\n분야",0.6,{"$nulls":6},{"$f":"SUM(J61:J64)*60%","v":518669.43866943865}]
[null,1,"000도로확장공사\n감리용역","00시",1000000,0.8,"2009-10-02","2012-05-20",null,{"$f":"E61*F61*I62/G62","v":493970.89397089399}]
[{"$nulls":6},{"$f":"IF(H61-G61=0,\" \",IF(H61-G61>0,H61-G61+1))","v":962},null,{"$f":"G62-M62-N62","v":594},null,null,null,{"$f":"IF($K$2-G61<=0, \"0\",IF($K$2-G61>0, $K$2-G61))","v":368},{"$f":"IF(H61-$K$3<=0, \"0\",IF(H61-$K$3>0, H61-$K$3))","v":"0"}]
[null,2,"000도로확장공사\n감리용역","00시",1200000,0.5,"2009-10-02","2012-05-20",null,{"$f":"E63*F63*I64/G64","v":370478.1704781705}]
[{"$nulls":6},{"$f":"IF(H63-G63=0,\" \",IF(H63-G63>0,H63-G63+1))","v":962},null,{"$f":"G64-M64-N64","v":594},null,null,null,{"$f":"IF($K$2-G63<=0, \"0\",IF($K$2-G63>0, $K$2-G63))","v":368},{"$f":"IF(H63-$K$3<=0, \"0\",IF(H63-$K$3>0, H63-$K$3))","v":"0"}]
[]
[]
[null,"○",{"$f":"참여업체현황!B8","v":"D사"}]
[null,"구분","용역명","발주처","준공(계약)\n금액(천원)","도급비율\n(%)","전체사업기간(일)\n(C )",null,"해당기간\n(일)","적용금액\n(천원)","비고"]
[{"$nulls":4},"(A)","(B)","시작","종료","(D)","(A×B×D/C)"]
[null,"합계",null,"총00건",{"$nulls":5},{"$f":"J71+J78","v":2633346.8136207862}]
[null,"해당\n분야",1,{"$nulls":6},{"$f":"SUM(J72:J77)*100%","v":2114677.3749513477},null,null,"산정시작 앞","공고일 뒤"]
[null,1,"000부지조성공사\n감리용역","00공사",1000000,1,"2011-10-02","2013-10-01",null,{"$f":"E72*F72*I73/G73","v":1000000},"완료"]
[{"$nulls":6},{"$f":"IF(H72-G72=0,\" \",IF(H72-G72>0,H72-G72+1))","v":731},null,{"$f":"G73-M73-N73","v":731},null,null,null,{"$f":"IF($K$2-G72<=0, \"0\",IF($K$2-G72>0, $K$2-G72))","v":"0"},{"$f":"IF(H72-$K$3<=0, \"0\",IF(H72-$K$3>0, H72-$K$3))","v":"0"}]
[null,2,"000부지조성공사\n감리용역","00공사",1000000,0.5,"2010-01-03","2016-01-01",null,{"$f":"E74*F74*I75/G75","v":250228.3105022831},"진행"]
[{"$nulls":6},{"$f":"IF(H74-G74=0,\" \",IF(H74-G74>0,H74-G74+1))","v":2190},null,{"$f":"G75-M75-N75","v":1096},null,null,null,{"$f":"IF($K$2-G74<=0, \"0\",IF($K$2-G74>0, $K$2-G74))","v":275},{"$f":"IF(H74-$K$3<=0, \"0\",IF(H74-$K$3>0, H74-$K$3))","v":819}]
[null,3,"000부지조성공사\n감리용역","00공사",2000000,0.7,"2009-10-02","2012-05-20",null,{"$f":"E76*F76*I77/G77","v":864449.06444906443},"완료"]
[{"$nulls":6},{"$f":"IF(H76-G76=0,\" \",IF(H76-G76>0,H76-G76+1))","v":962},null,{"$f":"G77-M77-N77","v":594},null,null,null,{"$f":"IF($K$2-G76<=0, \"0\",IF($K$2-G76>0, $K$2-G76))","v":368},{"$f":"IF(H76-$K$3<=0, \"0\",IF(H76-$K$3>0, H76-$K$3))","v":"0"}]
[null,"기타\n분야",0.6,{"$nulls":6},{"$f":"SUM(J79:J82)*60%","v":518669.43866943865}]
[null,1,"000도로확장공사\n감리용역","00시",1000000,0.8,"2009-10-02","2012-05-20",null,{"$f":"E79*F79*I80/G80","v":493970.89397089399}]
[{"$nulls":6},{"$f":"IF(H79-G79=0,\" \",IF(H79-G79>0,H79-G79+1))","v":962},null,{"$f":"G80-M80-N80","v":594},null,null,null,{"$f":"IF($K$2-G79<=0, \"0\",IF($K$2-G79>0, $K$2-G79))","v":368},{"$f":"IF(H79-$K$3<=0, \"0\",IF(H79-$K$3>0, H79-$K$3))","v":"0"}]
[null,2,"000도로확장공사\n감리용역","00시",1200000,0.5,"2009-10-02","2012-05-20",null,{"$f":"E81*F81*I82/G82","v":370478.1704781705}]
[{"$nulls":6},{"$f":"IF(H81-G81=0,\" \",IF(H81-G81>0,H81-G81+1))","v":962},null,{"$f":"G82-M82-N82","v":594},null,null,null,{"$f":"IF($K$2-G81<=0, \"0\",IF($K$2-G81>0, $K$2-G81))","v":368},{"$f":"IF(H81-$K$3<=0, \"0\",IF(H81-$K$3>0, H81-$K$3))","v":"0"}]
[]
[]
[null,"○",{"$f":"참여업체현황!B9","v":"E사"}]
[null,"구분","용역명","발주처","준공(계약)\n금액(천원)","도급비율\n(%)","전체사업기간(일)\n(C )",null,"해당기간\n(일)","적용금액\n(천원)","비고"]
[{"$nulls":4},"(A)","(B)","시작","종료","(D)","(A×B×D/C)"]
[null,"합계",null,"총00건",{"$nulls":5},{"$f":"J89+J96","v":2633346.8136207862}]
[null,"해당\n분야",1,{"$nulls":6},{"$f":"SUM(J90:J95)*100%","v":2114677.3749513477},null,null,"산정시작 앞","공고일 뒤"]
[null,1,"000부지조성공사\n감리용역","00공사",1000000,1,"2011-10-02","2013-10-01",null,{"$f":"E90*F90*I91/G91","v":1000000},"완료"]
[{"$nulls":6},{"$f":"IF(H90-G90=0,\" \",IF(H90-G90>0,H90-G90+1))","v":731},null,{"$f":"G91-M91-N91","v":731},null,null,null,{"$f":"IF($K$2-G90<=0, \"0\",IF($K$2-G90>0, $K$2-G90))","v":"0"},{"$f":"IF(H90-$K$3<=0, \"0\",IF(H90-$K$3>0, H90-$K$3))","v":"0"}]
[null,2,"000부지조성공사\n감리용역","00공사",1000000,0.5,"2010-01-03","2016-01-01",null,{"$f":"E92*F92*I93/G93","v":250228.3105022831},"진행"]
[{"$nulls":6},{"$f":"IF(H92-G92=0,\" \",IF(H92-G92>0,H92-G92+1))","v":2190},null,{"$f":"G93-M93-N93","v":1096},null,null,null,{"$f":"IF($K$2-G92<=0, \"0\",IF($K$2-G92>0, $K$2-G92))","v":275},{"$f":"IF(H92-$K$3<=0, \"0\",IF(H92-$K$3>0, H92-$K$3))","v":819}]
[null,3,"000부지조성공사\n감리용역","00공사",2000000,0.7,"2009-10-02","2012-05-20",null,{"$f":"E94*F94*I95/G95","v":864449.06444906443},"완료"]
[{"$nulls":6},{"$f":"IF(H94-G94=0,\" \",IF(H94-G94>0,H94-G94+1))","v":962},null,{"$f":"G95-M95-N95","v":594},null,null,null,{"$f":"IF($K$2-G94<=0, \"0\",IF($K$2-G94>0, $K$2-G94))","v":368},{"$f":"IF(H94-$K$3<=0, \"0\",IF(H94-$K$3>0, H94-$K$3))","v":"0"}]
[null,"기타\n분야",0.6,{"$nulls":6},{"$f":"SUM(J97:J100)*60%","v":518669.43866943865}]
[null,1,"000도로확장공사\n감리용역","00시",1000000,0.8,"2009-10-02","2012-05-20",null,{"$f":"E97*F97*I98/G98","v":493970.89397089399}]
[{"$nulls":6},{"$f":"IF(H97-G97=0,\" \",IF(H97-G97>0,H97-G97+1))","v":962},null,{"$f":"G98-M98-N98","v":594},null,null,null,{"$f":"IF($K$2-G97<=0, \"0\",IF($K$2-G97>0, $K$2-G97))","v":368},{"$f":"IF(H97-$K$3<=0, \"0\",IF(H97-$K$3>0, H97-$K$3))","v":"0"}]
[null,2,"000도로확장공사\n감리용역","00시",1200000,0.5,"2009-10-02","2012-05-20",null,{"$f":"E99*F99*I100/G100","v":370478.1704781705}]
[{"$nulls":6},{"$f":"IF(H99-G99=0,\" \",IF(H99-G99>0,H99-G99+1))","v":962},null,{"$f":"G100-M100-N100","v":594},null,null,null,{"$f":"IF($K$2-G99<=0, \"0\",IF($K$2-G99>0, $K$2-G99))","v":368},{"$f":"IF(H99-$K$3<=0, \"0\",IF(H99-$K$3>0, H99-$K$3))","v":"0"}]

{"sheet":"다.신용도","index":8,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,7],[20,9,22,9],[23,9,25,9],[16,6,20,6],[9,3,9,4],[15,9,19,9],[10,3,10,4],[11,3,11,4]]}
[null,"신용도"]
[]
[null,"가. 입찰참가제한 또는 업무정지기간"]
[null,"회사명\n(또는 성명)","업무정지 및\n 제제기간","기간(월)","조치기관명","사유요약","점수","비고"]
[null,"00엔지니어링","2014.01.01~2014.03.01",2,"00공사",0,{"$f":"D5*0.2","v":0.4}]
[null,0,"2014.01.01~2014.03.01",1,"00시",0,{"$f":"D6*0.2","v":0.2}]
[null,"합계",{"$nulls":4},{"$f":"SUM(G5:G6)","v":0.60000000000000009}]
[]
[null,"나. 부실벌점"]
[null,"회사명\n(또는 성명)","부실벌점","해당감리",null,"사유","점수","비고"]
[null,"00엔지니어링",3,null,null,null,3]
[]
[null,"합계",{"$nulls":4},{"$f":"SUM(G11:G12)","v":3}]
[]
[null,"다. 재정상태건실도",{"$nulls":7},"점 수","회사채의\n신용평가등급","기업어음의\n신용평가등급","기업 신용평가등급"]
[null,"회사명","신용평가등급","평가점수\n(A)","지분율\n(B, %)","환산점수\n(A×B)","평가합계","비고",null,3,"AAA","-","(회사채에 대한 신용평가등급\nAAA에 준하는 등급) "]
[null,{"$f":"참여업체현황!B5","v":"A사"},"AA+",3,{"$f":"참여업체현황!E5","v":0.4},{"$f":"D17*E17","v":1.2000000000000002},{"$f":"ROUND(SUM(F17:F21),2)","v":2.67},"회사채",null,null,"AA+,\nAA0,\nAA-","A1","(회사채에 대한 신용평가등급 AA＋, AA0, AA-에 준하는 등급)"]
[null,{"$f":"참여업체현황!B6","v":"B사"},"BBB+",2.7,{"$f":"참여업체현황!E6","v":0.3},{"$f":"D18*E18","v":0.81},null,"회사채",null,null,"A+","A2+","(회사채에 대한 신용평가등급 A＋에 준하는 등급)"]
[null,{"$f":"참여업체현황!B7","v":"C사"},"BB+",2.4,{"$f":"참여업체현황!E7","v":0.1},0.24,null,"회사채",null,null,"A0","A20","(회사채에 대한 신용평가등급 A0에 준하는 등급)"]
[null,{"$f":"참여업체현황!B8","v":"D사"},"CCC+",2.1,{"$f":"참여업체현황!E8","v":0.1},0.21000000000000002,null,"회사채",null,null,"A-","A2-","(회사채에 대한 신용평가등급 A-에 준하는 등급)"]
[null,{"$f":"참여업체현황!B9","v":"E사"},"CCC+",2.1,{"$f":"참여업체현황!E9","v":0.1},0.21000000000000002,null,"회사채",null,2.7,"BBB+","A3+","(회사채에 대한 신용평가등급 BBB＋에 준하는 등급)"]
[{"$nulls":10},"BBB0","A30","(회사채에 대한 신용평가등급 BBB0에 준하는 등급)"]
[{"$nulls":10},"BBB-","A3-","(회사채에 대한 신용평가등급 BBB-에 준하는 등급)"]
[{"$nulls":9},2.4,"BB+, BB0","B+","(회사채에 대한 신용평가등급 BB＋, BB0에 준하는 등급)"]
[{"$nulls":10},"BB-","B0","(회사채에 대한 신용평가등급 BB-에 준하는 등급)"]
[{"$nulls":10},"B+, B0, B-","B-","(회사채에 대한 신용평가등급 B＋, B0, B-에 준하는 등급)"]
[{"$nulls":9},2.1,"CCC+이하","C 이하","(회사채에 대한 신용평가등급 CCC＋ 이하에 준하는 등급)"]

{"sheet":"라.기술개발 및 투자실적","index":9,"n_rows":106,"n_cols":25,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,1,0,10],[13,1,16,1],[17,1,20,1],[11,15,11,16],[28,15,28,16],[45,15,45,16],[62,15,62,16],[79,15,79,16],[105,1,105,2],[28,5,29,5],[28,6,28,7],[11,6,11,7],[11,9,11,10],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[21,1,24,1],[25,1,25,11],[16,2,16,11],[24,2,24,11],[20,2,20,11],[47,1,50,1],[50,2,50,11],[51,1,54,1],[54,2,54,11],[55,1,58,1],[58,2,58,11],[42,1,42,11],[45,1,46,1],[45,2,46,2],[45,3,46,3],[45,4,46,4],[45,5,46,5],[45,6,45,7],[45,9,45,10],[59,1,59,11],[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,4,63,4],[62,5,63,5],[62,6,62,7],[62,9,62,10],[62,11,63,11],[79,2,80,2],[79,3,80,3],[79,4,80,4],[79,5,80,5],[79,6,79,7],[79,9,79,10],[64,1,67,1],[67,2,67,11],[68,1,71,1],[71,2,71,11],[72,1,75,1],[75,2,75,11],[2,1,2,3],[2,4,2,5],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[3,4,3,5],[4,4,4,5],[11,13,12,13],[28,11,29,11],[28,12,29,12],[28,13,29,13],[45,11,46,11],[45,12,46,12],[45,13,46,13],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,1,8,5],[11,11,12,11],[11,12,12,12],[28,9,28,10],[30,1,33,1],[33,2,33,11],[34,1,37,1],[37,2,37,11],[38,1,41,1],[41,2,41,11],[28,1,29,1],[28,2,29,2],[28,3,29,3],[28,4,29,4],[97,13,98,13],[102,3,102,4],[103,3,103,4],[97,3,98,4],[99,3,99,4],[100,3,100,4],[101,3,101,4],[62,12,63,12],[62,13,63,13],[79,11,80,11],[79,12,80,12],[79,13,80,13],[97,5,97,6],[97,7,97,8],[97,9,97,10],[93,1,93,11],[81,1,84,1],[84,2,84,11],[85,1,88,1],[88,2,88,11],[89,1,92,1],[92,2,92,11],[76,1,76,11],[79,1,80,1],[103,11,103,12],[104,11,104,12],[97,1,98,2],[99,1,99,2],[100,1,100,2],[101,1,101,2],[102,1,102,2],[103,1,103,2],[104,1,104,2],[97,11,98,12],[99,11,99,12],[100,11,100,12],[101,11,101,12],[102,11,102,12]]}
[null,"기술개발 및 투자실적",{"$nulls":13},"신기술",1,0.9,0.8,0.7,0.6,"구분","5년미만","5년이상\n10년미만","10년이상\n20년미만"]
[null,"가. 개발실적",{"$nulls":13},"실적\n(건)","5이상","5미만\n4이상","4미만\n3이상","3미만\n2이상","2미만\n1이상","특허",1,0.8,0.6]
[null,"업체명",null,null,"참여지분율",null,"각업체별\n점수","적용점수","비고",{"$nulls":6},"실적금액\n(억원)","20이상","20미만","18미만\n16이상","16미만\n14이상","14미만\n12이상","실용신안",1,0.8,0]
[null,{"$f":"참여업체현황!B5","v":"A사"},null,null,{"$f":"참여업체현황!E5","v":0.4},null,{"$f":"N26","v":"3"},{"$f":"E4*G4","v":1.2000000000000002}]
[null,{"$f":"참여업체현황!B6","v":"B사"},null,null,{"$f":"참여업체현황!E6","v":0.3},null,{"$f":"N43","v":"3"},{"$f":"E5*G5","v":0.89999999999999991}]
[null,{"$f":"참여업체현황!B7","v":"C사"},null,null,{"$f":"참여업체현황!E7","v":0.1},null,{"$f":"N60","v":"3"},0.30000000000000004]
[null,{"$f":"참여업체현황!B8","v":"D사"},null,null,{"$f":"참여업체현황!E8","v":0.1},null,{"$f":"N77","v":"3"},0.30000000000000004]
[null,{"$f":"참여업체현황!B9","v":"E사"},null,null,{"$f":"참여업체현황!E9","v":0.1},null,{"$f":"N94","v":"3"},0.30000000000000004]
[null,"합계",{"$nulls":5},{"$f":"SUM(H4:H8)","v":3}]
[]
[null,"○",{"$f":"B4","v":"A사"},{"$nulls":9},{"$f":"참여업체현황!F2","v":"공고일"},{"$f":"참여업체현황!G2","v":"2013-10-04"}]
[null,"구분","연번","명칭","지정번호","출원자\n수","보호기간\n또는 출원일",null,"경과기간","사용실적",null,"가중치","점수","비고",null,"가중치"]
[{"$nulls":6},"(시작)","(종료)","(년)","(건)","(금액,억원)",{"$nulls":4},"건수","금액"]
[null,"건설\n신기술",1,0,"000-00",1,"2010-10-02","2014-10-01",null,6,22,{"$f":"IF(P14>=Q14, P14,Q14)","v":"1"},{"$f":"IF(L14=0,0,L14/F14)","v":1},null,null,{"$f":"IF(J14<1, \" \", IF(J14>=5,\"1\", IF(J14>=4, \"0.9\", IF(J14>=3, \"0.8\", IF(J14>=2,\"0.7\", IF(J14>=1,\"0.6\"))))))","v":"1"},{"$f":"IF(K14<12, \" \", IF(K14>=20,\"1\", IF(K14>=18, \"0.9\", IF(K14>=16, \"0.8\", IF(K14>=14,\"0.7\", IF(K14>=12,\"0.6\"))))))","v":"1"}]
[null,null,2,0,"000-00",3,"2010-10-02","2014-10-01",null,2,17,{"$f":"IF(P15>=Q15, P15,Q15)","v":"0.8"},{"$f":"IF(L15=0,0,L15/F15)","v":0.26666666666666666},null,null,{"$f":"IF(J15<1, \" \", IF(J15>=5,\"1\", IF(J15>=4, \"0.9\", IF(J15>=3, \"0.8\", IF(J15>=2,\"0.7\", IF(J15>=1,\"0.6\"))))))","v":"0.7"},{"$f":"IF(K15<12, \" \", IF(K15>=20,\"1\", IF(K15>=18, \"0.9\", IF(K15>=16, \"0.8\", IF(K15>=14,\"0.7\", IF(K15>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,3,0,"000-00",5,"2010-10-02","2014-10-01",null,1,13,{"$f":"IF(P16>=Q16, P16,Q16)","v":"0.6"},0.12,null,null,{"$f":"IF(J16<1, \" \", IF(J16>=5,\"1\", IF(J16>=4, \"0.9\", IF(J16>=3, \"0.8\", IF(J16>=2,\"0.7\", IF(J16>=1,\"0.6\"))))))","v":"0.6"},{"$f":"IF(K16<12, \" \", IF(K16>=20,\"1\", IF(K16>=18, \"0.9\", IF(K16>=16, \"0.8\", IF(K16>=14,\"0.7\", IF(K16>=12,\"0.6\"))))))","v":"0.6"}]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M14:M16)","v":1.3866666666666667}]
[null,"특허",1,0,"000-000",4,"1995-01-02","-",{"$f":"($N$11-G18+1)/365","v":18.769863013698629},"-","-",{"$f":"IF(I18<5,100%,IF(I18<10,80%,IF(I18<20,60%,IF(I18>=20,0))))","v":0.6},{"$f":"IF(L18=0,0,L18/F18)","v":0.15}]
[null,null,2,0,"000-000",1,"2011-11-12","-",{"$f":"($N$11-G19+1)/365","v":1.8986301369863015},"-","-",{"$f":"IF(I19<5,100%,IF(I19<10,80%,IF(I19<20,60%,IF(I19>=20,0))))","v":1},{"$f":"IF(L19=0,0,L19/F19)","v":1}]
[null,null,3,0,"000-000",2,"2010-09-10","-",{"$f":"($N$11-G20+1)/365","v":3.0712328767123287},"-","-",{"$f":"IF(I20<5,100%,IF(I20<10,80%,IF(I20<20,60%,IF(I20>=20,0))))","v":1},{"$f":"IF(L20=0,0,L20/F20)","v":0.5}]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M18:M20)","v":1.65}]
[null,"실용\n신안",1,0,"000-000",3,"2008-01-02","-",{"$f":"($N$11-G22+1)/365","v":5.7616438356164386},"-","-",{"$f":"IF(I22<5,100%,IF(I22<10,80%,IF(I22>=10,0)))","v":0.8},{"$f":"IF(L22=0,0,L22/F22)","v":0.26666666666666666}]
[null,null,2,0,"000-000",5,"2004-01-10",null,{"$f":"($N$11-G23+1)/365","v":9.742465753424657},null,null,{"$f":"IF(I23<5,100%,IF(I23<10,80%,IF(I23>=10,0)))","v":0.8},{"$f":"IF(L23=0,0,L23/F23)","v":0.16}]
[null,null,3,0,"000-000",3,"2010-01-01",null,{"$f":"($N$11-G24+1)/365","v":3.7616438356164386},null,null,1,0.33333333333333331]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M22:M24)","v":0.76}]
[null,"합계",{"$nulls":10},{"$f":"ROUND(M17+M21+M25,2)","v":3.8},{"$f":"IF(M26<=3,M26,IF(M26>3,\"3\"))","v":"3"}]
[]
[null,"○",{"$f":"B5","v":"B사"}]
[null,"구분","연번","명칭","지정번호","출원자\n수","보호기간\n또는 출원일",null,"경과기간","사용실적",null,"가중치","점수","비고",null,"가중치"]
[{"$nulls":6},"(시작)","(종료)","(년)","(건)","(금액,억원)",{"$nulls":4},"건수","금액"]
[null,"건설\n신기술",1,0,"000-00",1,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P31>=Q31, P31,Q31)","v":"0.9"},{"$f":"IF(L31=0,0,L31/F31)","v":0.9},null,null,{"$f":"IF(J31<1, \" \", IF(J31>=5,\"1\", IF(J31>=4, \"0.9\", IF(J31>=3, \"0.8\", IF(J31>=2,\"0.7\", IF(J31>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K31<12, \" \", IF(K31>=20,\"1\", IF(K31>=18, \"0.9\", IF(K31>=16, \"0.8\", IF(K31>=14,\"0.7\", IF(K31>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,2,0,"000-00",5,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P32>=Q32, P32,Q32)","v":"0.9"},{"$f":"IF(L32=0,0,L32/F32)","v":0.18},null,null,{"$f":"IF(J32<1, \" \", IF(J32>=5,\"1\", IF(J32>=4, \"0.9\", IF(J32>=3, \"0.8\", IF(J32>=2,\"0.7\", IF(J32>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K32<12, \" \", IF(K32>=20,\"1\", IF(K32>=18, \"0.9\", IF(K32>=16, \"0.8\", IF(K32>=14,\"0.7\", IF(K32>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,3,0,"000-00",4,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P33>=Q33, P33,Q33)","v":"0.9"},0.22500000000000001,null,null,{"$f":"IF(J33<1, \" \", IF(J33>=5,\"1\", IF(J33>=4, \"0.9\", IF(J33>=3, \"0.8\", IF(J33>=2,\"0.7\", IF(J33>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K33<12, \" \", IF(K33>=20,\"1\", IF(K33>=18, \"0.9\", IF(K33>=16, \"0.8\", IF(K33>=14,\"0.7\", IF(K33>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M31:M33)","v":1.3050000000000002}]
[null,"특허",1,0,"000-000",2,"1995-01-02","-",{"$f":"($N$11-G35+1)/365","v":18.769863013698629},"-","-",{"$f":"IF(I35<5,100%,IF(I35<10,80%,IF(I35<20,60%,IF(I35>=20,0))))","v":0.6},{"$f":"IF(L35=0,0,L35/F35)","v":0.3}]
[null,null,2,0,"000-000",1,"2011-11-12","-",{"$f":"($N$11-G36+1)/365","v":1.8986301369863015},"-","-",{"$f":"IF(I36<5,100%,IF(I36<10,80%,IF(I36<20,60%,IF(I36>=20,0))))","v":1},{"$f":"IF(L36=0,0,L36/F36)","v":1}]
[null,null,3,0,"000-000",2,"2010-09-10","-",{"$f":"($N$11-G37+1)/365","v":3.0712328767123287},"-","-",{"$f":"IF(I37<5,100%,IF(I37<10,80%,IF(I37<20,60%,IF(I37>=20,0))))","v":1},{"$f":"IF(L37=0,0,L37/F37)","v":0.5}]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M35:M37)","v":1.8}]
[null,"실용\n신안",1,0,"000-000",2,"2008-01-02","-",{"$f":"($N$11-G39+1)/365","v":5.7616438356164386},"-","-",{"$f":"IF(I39<5,100%,IF(I39<10,80%,IF(I39>=10,0)))","v":0.8},{"$f":"IF(L39=0,0,L39/F39)","v":0.4}]
[null,null,2,0,"000-000",1,"2011-11-12",null,{"$f":"($N$11-G40+1)/365","v":1.8986301369863015},null,null,{"$f":"IF(I40<5,100%,IF(I40<10,80%,IF(I40>=10,0)))","v":1},{"$f":"IF(L40=0,0,L40/F40)","v":1}]
[null,null,3,0,"000-000",2,"2010-09-10",null,{"$f":"($N$11-G41+1)/365","v":3.0712328767123287},null,null,1,0.5]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M39:M41)","v":1.9}]
[null,"합계",{"$nulls":10},{"$f":"ROUND(M34+M38+M42,2)","v":5.01},{"$f":"IF(M43<=3,M43,IF(M43>3,\"3\"))","v":"3"}]
[]
[null,"○",{"$f":"B6","v":"C사"}]
[null,"구분","연번","명칭","지정번호","출원자\n수","보호기간\n또는 출원일",null,"경과기간","사용실적",null,"가중치","점수","비고",null,"가중치"]
[{"$nulls":6},"(시작)","(종료)","(년)","(건)","(금액,억원)",{"$nulls":4},"건수","금액"]
[null,"건설\n신기술",1,0,"000-00",2,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P48>=Q48, P48,Q48)","v":"0.9"},{"$f":"IF(L48=0,0,L48/F48)","v":0.45},null,null,{"$f":"IF(J48<1, \" \", IF(J48>=5,\"1\", IF(J48>=4, \"0.9\", IF(J48>=3, \"0.8\", IF(J48>=2,\"0.7\", IF(J48>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K48<12, \" \", IF(K48>=20,\"1\", IF(K48>=18, \"0.9\", IF(K48>=16, \"0.8\", IF(K48>=14,\"0.7\", IF(K48>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,2,0,"000-00",5,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P49>=Q49, P49,Q49)","v":"0.9"},{"$f":"IF(L49=0,0,L49/F49)","v":0.18},null,null,{"$f":"IF(J49<1, \" \", IF(J49>=5,\"1\", IF(J49>=4, \"0.9\", IF(J49>=3, \"0.8\", IF(J49>=2,\"0.7\", IF(J49>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K49<12, \" \", IF(K49>=20,\"1\", IF(K49>=18, \"0.9\", IF(K49>=16, \"0.8\", IF(K49>=14,\"0.7\", IF(K49>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,3,0,"000-00",1,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P50>=Q50, P50,Q50)","v":"0.9"},0.9,null,null,{"$f":"IF(J50<1, \" \", IF(J50>=5,\"1\", IF(J50>=4, \"0.9\", IF(J50>=3, \"0.8\", IF(J50>=2,\"0.7\", IF(J50>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K50<12, \" \", IF(K50>=20,\"1\", IF(K50>=18, \"0.9\", IF(K50>=16, \"0.8\", IF(K50>=14,\"0.7\", IF(K50>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M48:M50)","v":1.53}]
[null,"특허",1,0,"000-000",2,"1995-01-02","-",{"$f":"($N$11-G52+1)/365","v":18.769863013698629},"-","-",{"$f":"IF(I52<5,100%,IF(I52<10,80%,IF(I52<20,60%,IF(I52>=20,0))))","v":0.6},{"$f":"IF(L52=0,0,L52/F52)","v":0.3}]
[null,null,2,0,"000-000",1,"2011-11-12","-",{"$f":"($N$11-G53+1)/365","v":1.8986301369863015},"-","-",{"$f":"IF(I53<5,100%,IF(I53<10,80%,IF(I53<20,60%,IF(I53>=20,0))))","v":1},{"$f":"IF(L53=0,0,L53/F53)","v":1}]
[null,null,3,0,"000-000",2,"2010-09-10","-",{"$f":"($N$11-G54+1)/365","v":3.0712328767123287},"-","-",{"$f":"IF(I54<5,100%,IF(I54<10,80%,IF(I54<20,60%,IF(I54>=20,0))))","v":1},{"$f":"IF(L54=0,0,L54/F54)","v":0.5}]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M52:M54)","v":1.8}]
[null,"실용\n신안",1,0,"000-000",2,"2008-01-02","-",{"$f":"($N$11-G56+1)/365","v":5.7616438356164386},"-","-",{"$f":"IF(I56<5,100%,IF(I56<10,80%,IF(I56>=10,0)))","v":0.8},{"$f":"IF(L56=0,0,L56/F56)","v":0.4}]
[null,null,2,0,"000-000",1,"2011-11-12",null,{"$f":"($N$11-G57+1)/365","v":1.8986301369863015},null,null,{"$f":"IF(I57<5,100%,IF(I57<10,80%,IF(I57>=10,0)))","v":1},{"$f":"IF(L57=0,0,L57/F57)","v":1}]
[null,null,3,0,"000-000",2,"2010-09-10",null,{"$f":"($N$11-G58+1)/365","v":3.0712328767123287},null,null,1,0.5]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M56:M58)","v":1.9}]
[null,"합계",{"$nulls":10},{"$f":"ROUND(M51+M55+M59,2)","v":5.23},{"$f":"IF(M60<=3,M60,IF(M60>3,\"3\"))","v":"3"}]
[]
[null,"○",{"$f":"B7","v":"D사"}]
[null,"구분","연번","명칭","지정번호","출원자\n수","보호기간\n또는 출원일",null,"경과기간","사용실적",null,"가중치","점수","비고",null,"가중치"]
[{"$nulls":6},"(시작)","(종료)","(년)","(건)","(금액,억원)",{"$nulls":4},"건수","금액"]
[null,"건설\n신기술",1,0,"000-00",1,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P65>=Q65, P65,Q65)","v":"0.9"},{"$f":"IF(L65=0,0,L65/F65)","v":0.9},null,null,{"$f":"IF(J65<1, \" \", IF(J65>=5,\"1\", IF(J65>=4, \"0.9\", IF(J65>=3, \"0.8\", IF(J65>=2,\"0.7\", IF(J65>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K65<12, \" \", IF(K65>=20,\"1\", IF(K65>=18, \"0.9\", IF(K65>=16, \"0.8\", IF(K65>=14,\"0.7\", IF(K65>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,2,0,"000-00",2,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P66>=Q66, P66,Q66)","v":"0.9"},{"$f":"IF(L66=0,0,L66/F66)","v":0.45},null,null,{"$f":"IF(J66<1, \" \", IF(J66>=5,\"1\", IF(J66>=4, \"0.9\", IF(J66>=3, \"0.8\", IF(J66>=2,\"0.7\", IF(J66>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K66<12, \" \", IF(K66>=20,\"1\", IF(K66>=18, \"0.9\", IF(K66>=16, \"0.8\", IF(K66>=14,\"0.7\", IF(K66>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,3,0,"000-00",7,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P67>=Q67, P67,Q67)","v":"0.9"},0.12857142857142859,null,null,{"$f":"IF(J67<1, \" \", IF(J67>=5,\"1\", IF(J67>=4, \"0.9\", IF(J67>=3, \"0.8\", IF(J67>=2,\"0.7\", IF(J67>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K67<12, \" \", IF(K67>=20,\"1\", IF(K67>=18, \"0.9\", IF(K67>=16, \"0.8\", IF(K67>=14,\"0.7\", IF(K67>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M65:M67)","v":1.4785714285714286}]
[null,"특허",1,0,"000-000",2,"1995-01-02","-",{"$f":"($N$11-G69+1)/365","v":18.769863013698629},"-","-",{"$f":"IF(I69<5,100%,IF(I69<10,80%,IF(I69<20,60%,IF(I69>=20,0))))","v":0.6},{"$f":"IF(L69=0,0,L69/F69)","v":0.3}]
[null,null,2,0,"000-000",1,"2011-11-12","-",{"$f":"($N$11-G70+1)/365","v":1.8986301369863015},"-","-",{"$f":"IF(I70<5,100%,IF(I70<10,80%,IF(I70<20,60%,IF(I70>=20,0))))","v":1},{"$f":"IF(L70=0,0,L70/F70)","v":1}]
[null,null,3,0,"000-000",2,"2010-09-10","-",{"$f":"($N$11-G71+1)/365","v":3.0712328767123287},"-","-",{"$f":"IF(I71<5,100%,IF(I71<10,80%,IF(I71<20,60%,IF(I71>=20,0))))","v":1},{"$f":"IF(L71=0,0,L71/F71)","v":0.5}]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M69:M71)","v":1.8}]
[null,"실용\n신안",1,0,"000-000",2,"2008-01-02","-",{"$f":"($N$11-G73+1)/365","v":5.7616438356164386},"-","-",{"$f":"IF(I73<5,100%,IF(I73<10,80%,IF(I73>=10,0)))","v":0.8},{"$f":"IF(L73=0,0,L73/F73)","v":0.4}]
[null,null,2,0,"000-000",1,"2011-11-12",null,{"$f":"($N$11-G74+1)/365","v":1.8986301369863015},null,null,{"$f":"IF(I74<5,100%,IF(I74<10,80%,IF(I74>=10,0)))","v":1},{"$f":"IF(L74=0,0,L74/F74)","v":1}]
[null,null,3,0,"000-000",2,"2010-09-10",null,{"$f":"($N$11-G75+1)/365","v":3.0712328767123287},null,null,1,0.5]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M73:M75)","v":1.9}]
[null,"합계",{"$nulls":10},{"$f":"ROUND(M68+M72+M76,2)","v":5.18},{"$f":"IF(M77<=3,M77,IF(M77>3,\"3\"))","v":"3"}]
[]
[null,"○",{"$f":"B8","v":"E사"}]
[null,"구분","연번","명칭","지정번호","출원자\n수","보호기간\n또는 출원일",null,"경과기간","사용실적",null,"가중치","점수","비고",null,"가중치"]
[{"$nulls":6},"(시작)","(종료)","(년)","(건)","(금액,억원)",{"$nulls":4},"건수","금액"]
[null,"건설\n신기술",1,0,"000-00",1,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P82>=Q82, P82,Q82)","v":"0.9"},{"$f":"IF(L82=0,0,L82/F82)","v":0.9},null,null,{"$f":"IF(J82<1, \" \", IF(J82>=5,\"1\", IF(J82>=4, \"0.9\", IF(J82>=3, \"0.8\", IF(J82>=2,\"0.7\", IF(J82>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K82<12, \" \", IF(K82>=20,\"1\", IF(K82>=18, \"0.9\", IF(K82>=16, \"0.8\", IF(K82>=14,\"0.7\", IF(K82>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,2,0,"000-00",3,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P83>=Q83, P83,Q83)","v":"0.9"},{"$f":"IF(L83=0,0,L83/F83)","v":0.3},null,null,{"$f":"IF(J83<1, \" \", IF(J83>=5,\"1\", IF(J83>=4, \"0.9\", IF(J83>=3, \"0.8\", IF(J83>=2,\"0.7\", IF(J83>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K83<12, \" \", IF(K83>=20,\"1\", IF(K83>=18, \"0.9\", IF(K83>=16, \"0.8\", IF(K83>=14,\"0.7\", IF(K83>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,3,0,"000-00",2,"2010-10-02","2014-10-01",null,4,17,{"$f":"IF(P84>=Q84, P84,Q84)","v":"0.9"},0.45,null,null,{"$f":"IF(J84<1, \" \", IF(J84>=5,\"1\", IF(J84>=4, \"0.9\", IF(J84>=3, \"0.8\", IF(J84>=2,\"0.7\", IF(J84>=1,\"0.6\"))))))","v":"0.9"},{"$f":"IF(K84<12, \" \", IF(K84>=20,\"1\", IF(K84>=18, \"0.9\", IF(K84>=16, \"0.8\", IF(K84>=14,\"0.7\", IF(K84>=12,\"0.6\"))))))","v":"0.8"}]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M82:M84)","v":1.65}]
[null,"특허",1,0,"000-000",2,"1995-01-02","-",{"$f":"($N$11-G86+1)/365","v":18.769863013698629},"-","-",{"$f":"IF(I86<5,100%,IF(I86<10,80%,IF(I86<20,60%,IF(I86>=20,0))))","v":0.6},{"$f":"IF(L86=0,0,L86/F86)","v":0.3}]
[null,null,2,0,"000-00",3,"2010-10-02","-",{"$f":"($N$11-G87+1)/365","v":3.010958904109589},"-","-",{"$f":"IF(I87<5,100%,IF(I87<10,80%,IF(I87<20,60%,IF(I87>=20,0))))","v":1},{"$f":"IF(L87=0,0,L87/F87)","v":0.33333333333333331}]
[null,null,3,0,"000-00",2,"2010-10-02","-",{"$f":"($N$11-G88+1)/365","v":3.010958904109589},"-","-",{"$f":"IF(I88<5,100%,IF(I88<10,80%,IF(I88<20,60%,IF(I88>=20,0))))","v":1},{"$f":"IF(L88=0,0,L88/F88)","v":0.5}]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M86:M88)","v":1.1333333333333333}]
[null,"실용\n신안",1,0,"000-000",2,"2008-01-02","-",{"$f":"($N$11-G90+1)/365","v":5.7616438356164386},"-","-",{"$f":"IF(I90<5,100%,IF(I90<10,80%,IF(I90>=10,0)))","v":0.8},{"$f":"IF(L90=0,0,L90/F90)","v":0.4}]
[null,null,2,0,"000-00",3,"2010-10-02",null,{"$f":"($N$11-G91+1)/365","v":3.010958904109589},null,null,{"$f":"IF(I91<5,100%,IF(I91<10,80%,IF(I91>=10,0)))","v":1},{"$f":"IF(L91=0,0,L91/F91)","v":0.33333333333333331}]
[null,null,3,0,"000-00",2,"2010-10-02",null,{"$f":"($N$11-G92+1)/365","v":3.010958904109589},null,null,1,0.5]
[null,null,"소계",{"$nulls":9},{"$f":"SUM(M90:M92)","v":1.2333333333333334}]
[null,"합계",{"$nulls":10},{"$f":"ROUND(M85+M89+M93,2)","v":4.0199999999999996},{"$f":"IF(M94<=3,M94,IF(M94>3,\"3\"))","v":"3"}]
[]
[]
[null,"나. 투자실적",{"$nulls":10},"(단위:","백만원)"]
[null,"업체명",null,"참여지분율",null,"1년차",null,"2년차",null,"3년차",null,"(A1+A2+A3)\n/(B1+B2+B3)",null,"적용점수"]
[{"$nulls":5},"A1","B1","A2","B2","A3","B3"]
[null,{"$f":"B4","v":"A사"},null,{"$f":"E4","v":0.4},null,2,200,3,100,7,300,{"$f":"(F100+H100+J100)/(G100+I100+K100)","v":0.02},null,{"$f":"D100*L100","v":8.0000000000000002E-3}]
[null,{"$f":"B5","v":"B사"},null,{"$f":"E5","v":0.3},null,3,300,4,200,8,400,{"$f":"(F101+H101+J101)/(G101+I101+K101)","v":1.6666666666666666E-2},null,{"$f":"D101*L101","v":5.0000000000000001E-3}]
[null,"C사",null,0.1,null,4,400,5,300,9,500,{"$f":"(F102+H102+J102)/(G102+I102+K102)","v":1.4999999999999999E-2},null,1.5E-3]
[null,"D사",null,0.1,null,5,500,6,400,10,100,{"$f":"(F103+H103+J103)/(G103+I103+K103)","v":2.1000000000000001E-2},null,2.1000000000000003E-3]
[null,"E사",null,0.1,null,6,600,7,500,11,200,{"$f":"(F104+H104+J104)/(G104+I104+K104)","v":1.8461538461538463E-2},null,1.8461538461538463E-3]
[null,"합계",{"$nulls":11},{"$f":"ROUND(SUM(N100:N104),4)","v":1.84E-2}]
[null,"점수",{"$nulls":11},{"$f":"IF(N105>=3%,\"7\",IF(N105>=2.5%,\"6.8\", IF(N105>=2%,\"6.6\", IF(N105>=1.5%,\"6.4\", IF(N105>=1%,\"6.2\",\"6\")))))","v":"6.4"}]

{"sheet":"마.업무중첩도","index":10,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,24,2],[3,3,3,4],[0,1,0,7],[1,1,1,7],[3,1,4,1],[3,2,4,2],[3,5,4,5],[3,6,4,6],[8,6,23,6],[8,5,11,5],[8,1,23,1],[8,2,11,2],[7,1,7,2],[12,2,15,2],[16,2,19,2],[20,2,23,2]]}
[null,"업무중첩도"]
[null,"(현재수행중인 용역 현황)"]
[]
[null,"구분","성명","현장배치현황",null,"점수","비고"]
[null,null,null,"현장명","용역기간"]
[null,{"$f":"'참여감리원 명단'!B5","v":"책임\n감리원"},{"$f":"'참여감리원 명단'!D5","v":"홍길일"},"없음","-",2]
[null,{"$f":"'참여감리원 명단'!B6","v":"보조\n감리원"},{"$f":"'참여감리원 명단'!D6","v":"홍길이"},"없음","-",1]
[null,"계",null,null,null,{"$f":"SUM(F6:F7)","v":3}]
[null,{"$f":"'참여감리원 명단'!B7","v":"기술\n지원\n감리원"},{"$f":"'참여감리원 명단'!D7","v":"홍길삼"},null,null,2,"10개이상 중복배치시 : 0점"]
[]
[]
[]
[null,null,{"$f":"'참여감리원 명단'!D8","v":"홍길사"},null,null,2]
[]
[]
[]
[null,null,{"$f":"'참여감리원 명단'!D9","v":"홍길오"},null,null,2]
[]
[]
[]
[null,null,{"$f":"'참여감리원 명단'!D10","v":"홍길육"}]
[]
[]
[{"$nulls":5},2]
[null,"계",null,null,null,{"$f":"(F9+F13+F17+F24)/4","v":2}]

{"sheet":"바.교체빈도","index":11,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[19,1,22,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[0,1,0,10],[3,1,5,1],[3,9,5,9],[3,5,3,8],[3,2,3,4],[4,5,5,5],[4,6,4,7]]}
[null,"최근 1년간 참여감리원의 교체빈도"]
[]
[null,"○ 감리전문회사"]
[null,"업체명","회사소속 감리원수",null,null,"교체건수",null,null,null,"교체빈도율\n(%)"]
[null,null,"상주","기술지원","계","상주감리원","기술지원감리원"]
[{"$nulls":7},"환산(5건→1건)","계"]
[null,{"$f":"참여업체현황!B5","v":"A사"},264,111,{"$f":"C7+D7/5","v":286.2},1,0,{"$f":"G7/5","v":0},{"$f":"F7+H7","v":1},{"$f":"I7/E7","v":3.4940600978336828E-3}]
[null,{"$f":"참여업체현황!B6","v":"B사"},110,42,{"$f":"C8+D8/5","v":118.4},2,1,{"$f":"G8/5","v":0.2},{"$f":"F8+H8","v":2.2000000000000002},{"$f":"I8/E8","v":1.8581081081081082E-2}]
[null,{"$f":"참여업체현황!B7","v":"C사"},210,90,228,1,4,0.8,1.8,7.8947368421052634E-3]
[null,{"$f":"참여업체현황!B8","v":"D사"},250,115,273,2,5,1,3,1.098901098901099E-2]
[null,{"$f":"참여업체현황!B9","v":"E사"},240,98,259.60000000000002,3,6,1.2,4.2,1.6178736517719568E-2]
[null,"계",{"$nulls":7},{"$f":"ROUND(SUM(J7:J11),4)","v":5.7099999999999998E-2}]
[null,"점수",{"$nulls":7},{"$f":"IF(J12<5%,\"5\", IF(J12<10%, \"4.5\", IF(J12<15%, \"4\", IF(J12<20%, \"3\", \"0\"))))","v":"4.5"}]
[]
[]
[null,"○ 참여감리원"]
[null,"등급","성명","용역명","발주기관","참여구분\n(상주,기술지원)","교체건수","감점","비고"]
[null,{"$f":"'참여감리원 명단'!B5","v":"책임\n감리원"},{"$f":"'참여감리원 명단'!D5","v":"홍길일"},"00감리용역","00시","상주",1,{"$f":"G18*0.25","v":0.25}]
[null,{"$f":"'참여감리원 명단'!B6","v":"보조\n감리원"},{"$f":"'참여감리원 명단'!D6","v":"홍길이"},"00감리용역","00청","상주",0,{"$f":"G19*0.25","v":0}]
[null,{"$f":"'참여감리원 명단'!B7","v":"기술\n지원\n감리원"},{"$f":"'참여감리원 명단'!D7","v":"홍길삼"},"00감리용역","00공사","상주",0,{"$f":"G20*0.1","v":0}]
[null,null,{"$f":"'참여감리원 명단'!D8","v":"홍길사"},"00감리용역","00시","비상주",0,{"$f":"G21*0.1","v":0}]
[null,null,{"$f":"'참여감리원 명단'!D9","v":"홍길오"},"00감리용역","00청","비상주",1,0.1]
[null,null,{"$f":"'참여감리원 명단'!D10","v":"홍길육"},"00감리용역","00공사","상주",2,0.2]
[null,"합계",{"$nulls":5},{"$f":"SUM(H18:H23)","v":0.55000000000000004}]
[null,"점수",{"$nulls":5},{"$f":"5-H24","v":4.45}]