{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["표지","개정이력","AGENT 일정","서버구매 비용(할인 전)"],"not_rendered":{"images":1,"external_links":2,"defined_names":41},"read":"whole","date_system":"1900"}

{"sheet":"표지","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"merged":[[2,1,2,10],[5,1,5,10],[8,0,8,11],[10,0,10,11]]}
[]
[]
[null,"ITN AGENT 개발 사업"]
[]
[]
[null,"WBS"]
[]
[]
[]
[]
["2024. 11. 04."]

{"sheet":"개정이력","index":1,"n_rows":5,"n_cols":4,"rows_kept":5,"merged":[[2,0,2,3]]}
["사업명",null,null,{"$f":"표지!B6","v":"WBS"}]
[]
["개정 이력"]
["버전","작성일","내용","작성자"]
[{"v":1,"d":"1.0"},"2024.11.04","최초작성","이호영"]

{"sheet":"AGENT 일정","index":2,"n_rows":46,"n_cols":74,"rows_kept":46,"merged":[[0,0,0,12],[4,0,6,8],[4,9,4,11],[4,13,4,22],[4,23,4,47],[4,48,4,70],[5,9,5,11],[6,9,6,11],[7,4,7,5],[9,15,37,15],[9,21,37,21],[39,15,41,15],[39,21,41,21],[43,15,45,15],[43,21,45,21]]}
["AGENT 일정"]
[]
[]
[]
[{"$nulls":9},"월별",null,null,"D1","11월",{"$nulls":9},"11월",{"$nulls":24},"12월"]
[{"$nulls":9},"요일",null,null,"D2","목","금",null,"월","화","수","목","금",null,"월","화",null,"수","목","금","월","화",null,"수","목","금","월","화",null,"수","목","금","월","화",null,"수","목","금","월","화","수","목","금","월","화",null,"수","목","금","월","화",null,"수","목","금","월","화",null,"목","금","월","화","수",null,"목","금"]
[{"$nulls":9},"일별",null,null,"D2","1900-01-19","1900-01-20",null,"1900-01-23","1900-01-24","1900-01-25","1900-01-26","1900-01-27",null,"1900-01-30",1,null,4,5,6,7,8,null,11,"1900-01-12","1900-01-13","1900-01-14","1900-01-15",null,"1900-01-18","1900-01-19","1900-01-20","1900-01-21","1900-01-22",null,"1900-01-25","1900-01-26","1900-01-27","1900-01-28","1900-01-29",2,3,4,5,6,null,9,10,11,12,13,null,16,17,18,19,20,null,23,24,25,26,27,null,30,31]
["NO","단계","요구사항 ID","Activity","Task",null,"Task 속성","자원","진행상태","계획시작일","계획종료일","기간(일)","계획진척률"]
[1,"1000. 프리랜서",{"$nulls":6},{"$f":"IF(AND(M9>0%,M9<100%),\"진행 중\",IF(M9=0%,\"작업 대기\",\"작업 완료\"))","v":"작업 대기"},null,null,{"$f":"SUM(L10:L14)","v":15},{"$f":"AVERAGE(M11,M13)","v":{"v":0,"d":"0%"}}]
[2,null,null,"실행파일"]
[3,{"$nulls":3},"리눅스, 윈도우 실행 파일 및 폴더 구조",null,"작업","프리랜서","작업 대기","2024-11-11","2024-11-19",{"$f":"IF(OR(ISBLANK($J11), ISBLANK($K11)),\"\",NETWORKDAYS($J11,$K11))","v":7},{"v":0,"d":"0%"}]
[4,null,null,"산출물"]
[5,{"$nulls":3},"산출물 수정",null,"작업","프리랜서",{"$f":"IF(AND(M13>0%,M13<100%),\"진행 중\",IF(M13=0%,\"작업 대기\",\"작업 완료\"))","v":"작업 대기"},"2024-11-20","2024-11-29",{"$f":"IF(OR(ISBLANK($J13), ISBLANK($K13)),\"\",NETWORKDAYS($J13,$K13))","v":8},{"v":0,"d":"0%"}]
[6]
[7,"2000. 서버",{"$nulls":6},{"$f":"IF(AND(M15>0%,M15<100%),\"진행 중\",IF(M15=0%,\"개발 대기\",\"개발 완료\"))","v":"개발 대기"},null,null,{"$f":"SUM(L17:L30)","v":15},{"$f":"AVERAGE(M17,M19,M28)","v":{"v":0,"d":"0%"}}]
[8,null,null,"구매"]
[9,{"$nulls":3},"서버 구매 - 2대(core : 4, ram : 8G ), 1대(core : 8, ram : 16G ), 웹 x 2, agent x 1",null,"개발",null,{"$f":"IF(AND(M17>0%,M17<100%),\"진행 중\",IF(M17=0%,\"작업 대기\",\"작업 완료\"))","v":"작업 대기"},"2024-11-11","2024-11-11",{"$f":"IF(OR(ISBLANK($J17), ISBLANK($K17)),\"\",NETWORKDAYS($J17,$K17))","v":1},{"v":0,"d":"0%"}]
[10]
[11,null,null,"환경셋팅",null,null,"작업","이준호",{"$f":"IF(AND(M19>0%,M19<100%),\"진행 중\",IF(M19=0%,\"작업 대기\",\"작업 완료\"))","v":"작업 대기"},"2024-11-12","2024-11-22",9,{"v":0,"d":"0%"}]
[12,{"$nulls":3},"WEB, WAS 2중화"]
[13,{"$nulls":3},"Load Balancer 설치 및 셋팅"]
[14,{"$nulls":3},"Clustering 셋팅"]
[15,{"$nulls":3},"Agent 설치"]
[16,{"$nulls":3},"전송사 Agent 설치"]
[17,{"$nulls":3},"DB 셋팅"]
[{"$nulls":4},"CI/CD 설정"]
[18]
[19,null,null,"테스트",null,null,"작업","이호영, 이준호",{"$f":"IF(AND(M28>0%,M28<100%),\"진행 중\",IF(M28=0%,\"작업 대기\",\"작업 완료\"))","v":"작업 대기"},"2024-11-25","2024-11-29",{"$f":"IF(OR(ISBLANK($J28), ISBLANK($K28)),\"\",NETWORKDAYS($J28,$K28))","v":5},{"v":0,"d":"0%"}]
[20,{"$nulls":3},"WEB, WAS 2중화 테스트"]
[21,{"$nulls":3},"Agent 발송 테스트"]
[22]
[24,"3000. WEB 구축",{"$nulls":9},{"$f":"SUM(L34,L37)","v":5},{"$f":"AVERAGE(M37)","v":{"v":0,"d":"0%"}}]
[27,null,null,"이관"]
[{"$nulls":4},"문자온 프로젝트 이관",null,"작업","이호영",{"$f":"IF(AND(M34>0%,M34<100%),\"진행 중\",IF(M34=0%,\"작업 대기\",\"작업 완료\"))","v":"작업 대기"},"2024-11-11","2024-11-11",{"$f":"IF(OR(ISBLANK($J34), ISBLANK($K34)),\"\",NETWORKDAYS($J34,$K34))","v":1},{"v":0,"d":"0%"}]
[]
[{"$nulls":3},"추가 기능"]
[28,{"$nulls":3},"관리자 - agent 회원 메뉴",null,"작업","이호영",{"$f":"IF(AND(M37>0%,M37<100%),\"진행 중\",IF(M37=0%,\"작업 대기\",\"작업 완료\"))","v":"작업 대기"},"2024-11-12","2024-11-15",{"$f":"IF(OR(ISBLANK($J37), ISBLANK($K37)),\"\",NETWORKDAYS($J37,$K37))","v":4},{"v":0,"d":"0%"}]
[29]
[43,"4000. DB",{"$nulls":9},{"$f":"SUM(L41)","v":1},{"$f":"AVERAGE(M41)","v":{"v":0,"d":"0%"}}]
[44,null,null,"데이터 초기화"]
[45,{"$nulls":3},"기존 문자온 DB 초기화 하여 이관",null,"작업","이호영",{"$f":"IF(AND(M41>0%,M41<100%),\"진행 중\",IF(M41=0%,\"개발 대기\",\"개발 완료\"))","v":"개발 대기"},"2024-11-18","2024-11-18",{"$f":"IF(OR(ISBLANK($J41), ISBLANK($K41)),\"\",NETWORKDAYS($J41,$K41))","v":1},{"v":0,"d":"0%"}]
[51]
[43,"5000. 사이트 내재화",{"$nulls":9},{"$f":"SUM(L45)","v":110},{"$f":"AVERAGE(M45)","v":{"v":0,"d":"0%"}}]
[44,null,null,"분석 및 기능 파악"]
[45,{"$nulls":3},"기존 코드 파악 및 프로세스 전파",null,"작업","이호영",{"$f":"IF(AND(M45>0%,M45<100%),\"진행 중\",IF(M45=0%,\"개발 대기\",\"개발 완료\"))","v":"개발 대기"},"2024-11-11","2025-04-11",{"$f":"IF(OR(ISBLANK($J45), ISBLANK($K45)),\"\",NETWORKDAYS($J45,$K45))","v":110},{"v":0,"d":"0%"}]
[51]

{"sheet":"서버구매 비용(할인 전)","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"merged":[[1,1,1,4],[3,1,7,1],[4,2,7,2],[8,1,8,3],[10,1,14,1],[11,2,14,2],[15,1,15,3]]}
[]
[null,"agent 가비아 서버 구매 사양 및 가격(할인 전)"]
[null,"구분","구성",null,"가격(원)"]
[null,"web/was","서버","제품명 : basic\ncpu : 4 vCore\n메모리 : 8GB\nhdd : 100GB\n공인IP : 1개",{"v":215000,"d":"215,000"}]
[null,null,"부가서비스","블록스토리지 : 300GB",{"v":51000,"d":"51,000"}]
[{"$nulls":3},"이미지 백업 : 1식",{"v":10000,"d":"10,000"}]
[{"$nulls":3},"클라우드 백업 : 100GB",{"v":30000,"d":"30,000"}]
[{"$nulls":3},"매니지드서비스 : 1식",{"v":100000,"d":"100,000"}]
[null,"합계",null,null,{"$f":"SUM(E4:E8)","v":{"v":406000,"d":"406,000"}}]
[]
[null,"agent","서버","제품명 : basic\ncpu : 8 vCore\n메모리 : 16GB\nhdd : 100GB\n공인IP : 1개",{"v":311000,"d":"311,000"}]
[null,null,"부가서비스","블록스토리지 : 300GB",{"v":51000,"d":"51,000"}]
[{"$nulls":3},"이미지 백업 : 1식",{"v":10000,"d":"10,000"}]
[{"$nulls":3},"클라우드 백업 : 100GB",{"v":30000,"d":"30,000"}]
[{"$nulls":3},"매니지드서비스 : 1식",{"v":100000,"d":"100,000"}]
[null,"합계",null,null,{"$f":"SUM(E11:E15)","v":{"v":502000,"d":"502,000"}}]