{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["GanttChart","Calender","option","Language","help"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"GanttChart","index":0,"n_rows":101,"n_cols":28,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,4,0,13],[2,3,2,25],[1,3,1,25],[3,3,4,3],[3,4,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,25,4,25],[3,24,4,24],[3,23,4,23],[3,20,3,22],[3,17,3,19]]}
["2024-04-01",1,10,"no","title",null,null,null,null,null,null,null,null,null,"budge","start_date","end_date","days","complete_days","progress_rate","t_days","t_complete_days","t_progress_rate","manager","complete_rate","comment"]
["2025-02-26",3,331,"□ SAMPLE Project Schedule Management"]
[null,null,null,"(2024.00.00. ㅇㅇㅇㅇ팀)"]
[null,null,null,"No","과제명",null,null,null,null,null,null,null,null,null,"예산","시작일","종료일","업무량(누적일수)",null,null,"기간진행현황",null,null,"담당자","이행율\n(집접입력)","비고"," 2024년"," 2025년"]
["좌표정보","그룹","level",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"일수","완료일","진행율","일수","완료일","진행율"]
[null,"G",1,"1","분석",null,null,null,null,null,null,null,null,null,null,"2024-04-01","2024-05-06",44,44,1,24,24,1,null,0.25]
[null,"G",2,"1.1",null,"업무분석",null,null,null,null,null,null,null,null,null,"2024-04-01","2024-04-13",12,12,1,9,9,1,null,0.79166666666666663]
[null,null,3,"1.1.1",null,null,"인터뷰 결과서 작성",null,null,null,null,null,null,null,null,"2024-04-01","2024-04-07",5,5,1,5,5,1,null,0.5]
[null,null,3,"1.1.2",null,null,"요구사항 정의서 작성",null,null,null,null,null,null,null,null,"2024-04-03","2024-04-13",7,7,1,7,7,1,null,1]
[null,"G",2,"1.2",null,"데이터분석",null,null,null,null,null,null,null,null,null,"2024-04-12","2024-04-24",11,11,1,9,9,1,null,0.13636363636363635]
[null,null,3,"1.2.1",null,null,"ERD(논리) 작성",null,null,null,null,null,null,null,null,"2024-04-12","2024-04-18",5,5,1,5,5,1,null,0]
[null,null,3,"1.2.2",null,null,"자료사전(분석) 작성",null,null,null,null,null,null,null,null,"2024-04-17","2024-04-24",6,6,1,6,6,1,null,0.25]
[null,"G",2,"1.3",null,"시스템분석",null,null,null,null,null,null,null,null,null,"2024-04-24","2024-05-04",8,8,1,8,8,1,null,0]
[null,null,3,"1.3.1",null,null,"현행 시스템분석 작성",null,null,null,null,null,null,null,null,"2024-04-24","2024-04-28",3,3,1,3,3,1]
[null,null,3,"1.3.2",null,null,"보안계획서 작성",null,null,null,null,null,null,null,null,"2024-04-28","2024-05-04",5,5,1,5,5,1]
[null,"G",2,"1.4",null,"단계말 검토",null,null,null,null,null,null,null,null,null,"2024-04-17","2024-05-06",13,13,1,13,13,1,null,0]
[null,null,3,"1.4.1",null,null,"요구사항 추적표(분석)",null,null,null,null,null,null,null,null,"2024-04-17","2024-05-06",13,13,1,13,13,1]
[null,"G",1,"2","설계",null,null,null,null,null,null,null,null,null,null,"2024-04-24","2024-06-30",230,230,1,46,46,1,null,0]
[null,"G",2,"2.1",null,"구조설계",null,null,null,null,null,null,null,null,null,"2024-04-24","2024-05-15",30,30,1,14,14,1,null,0]
[null,null,3,"2.1.1",null,null,"개발환경셋팅",null,null,null,null,null,null,null,null,"2024-04-28","2024-05-04",5,5,1,5,5,1]
[null,null,3,"2.1.2",null,null,"아키텍처설계서 작성",null,null,null,null,null,null,null,null,"2024-04-28","2024-05-15",11,11,1,11,11,1]
[null,null,3,"2.1.3",null,null,"개발가이드 작성",null,null,null,null,null,null,null,null,"2024-04-24","2024-05-15",14,14,1,14,14,1]
[null,"G",2,"2.2",null,"화면설계",null,null,null,null,null,null,null,null,null,"2024-05-01","2024-05-24",24,24,1,16,16,1,null,0]
[null,null,3,"2.2.1",null,null,"메뉴구조도 작성",null,null,null,null,null,null,null,null,"2024-05-01","2024-05-10",7,7,1,7,7,1]
[null,null,3,"2.2.2",null,null,"화면목록 작성",null,null,null,null,null,null,null,null,"2024-05-01","2024-05-24",16,16,1,16,16,1]
[null,null,3,"2.2.3",null,null,"화면설계서 작성",null,null,null,null,null,null,null,null,"2024-05-04","2024-05-07",1,1,1,1,1,1]
[null,"G",2,"2.3",null,"업무설계",null,null,null,null,null,null,null,null,null,"2024-05-24","2024-06-05",72,72,1,9,9,1,null,0]
[null,null,3,"2.3.1",null,null,"패키정의",null,null,null,null,null,null,null,null,"2024-05-24","2024-06-05",9,9,1,9,9,1]
[null,null,3,"2.3.2",null,null,"프로그램목록(온라인) 정의",null,null,null,null,null,null,null,null,"2024-05-24","2024-06-05",9,9,1,9,9,1]
[null,null,3,"2.3.3",null,null,"시스템인터페이스목록 작성",null,null,null,null,null,null,null,null,"2024-05-24","2024-06-05",9,9,1,9,9,1]
[null,null,3,"2.3.4",null,null,"시스템인터페이스정의서 작성",null,null,null,null,null,null,null,null,"2024-05-24","2024-06-05",9,9,1,9,9,1]
[null,null,3,"2.3.5",null,null,"프로그램명세서 작성",null,null,null,null,null,null,null,null,"2024-05-24","2024-06-05",9,9,1,9,9,1]
[null,null,3,"2.3.6",null,null,"배치JOB목록 작성",null,null,null,null,null,null,null,null,"2024-05-24","2024-06-05",9,9,1,9,9,1]
[null,null,3,"2.3.7",null,null,"배치JOB정의서 작성",null,null,null,null,null,null,null,null,"2024-05-24","2024-06-05",9,9,1,9,9,1]
[null,null,3,"2.3.8",null,null,"프로그램목록(배치) 작성",null,null,null,null,null,null,null,null,"2024-05-24","2024-06-05",9,9,1,9,9,1]
[null,"G",2,"2.4",null,"데이터설계",null,null,null,null,null,null,null,null,null,"2024-06-01","2024-06-20",42,42,1,14,14,1,null,0]
[null,null,3,"2.4.1",null,null,"ERD(물리) 작성",null,null,null,null,null,null,null,null,"2024-06-01","2024-06-20",14,14,1,14,14,1]
[null,null,3,"2.4.2",null,null,"테이블목록 작성",null,null,null,null,null,null,null,null,"2024-06-01","2024-06-20",14,14,1,14,14,1]
[null,null,3,"2.4.3",null,null,"테이블정의서 작성",null,null,null,null,null,null,null,null,"2024-06-01","2024-06-20",14,14,1,14,14,1]
[null,"G",2,"2.5",null,"테스트 설계",null,null,null,null,null,null,null,null,null,"2024-06-05","2024-06-24",42,42,1,14,14,1,null,0]
[null,null,3,"2.5.1",null,null,"통합테스트시나리오 작성",null,null,null,null,null,null,null,null,"2024-06-05","2024-06-24",14,14,1,14,14,1]
[null,null,3,"2.5.2",null,null,"테스트계획서 작성",null,null,null,null,null,null,null,null,"2024-06-05","2024-06-24",14,14,1,14,14,1]
[null,null,3,"2.5.3",null,null,"단위테스트정의서 작성",null,null,null,null,null,null,null,null,"2024-06-05","2024-06-24",14,14,1,14,14,1]
[null,"G",2,"2.6",null,"단계말 검토",null,null,null,null,null,null,null,null,null,"2024-06-01","2024-06-30",20,20,1,20,20,1,null,0]
[null,null,3,"2.6.1",null,null,"요구사항추적표(설계)",null,null,null,null,null,null,null,null,"2024-06-01","2024-06-30",20,20,1,20,20,1]
[null,"G",1,"3","개발",null,null,null,null,null,null,null,null,null,null,"2024-07-01","2024-10-20",331,331,1,80,80,1,null,0]
[null,"G",2,"3.1",null,"화면개발",null,null,null,null,null,null,null,null,null,"2024-07-01","2024-07-30",88,88,1,22,22,1,null,0]
[null,null,3,"3.1.1",null,null,"디자인가이드정의",null,null,null,null,null,null,null,null,"2024-07-01","2024-07-30",22,22,1,22,22,1]
[null,null,3,"3.1.2",null,null,"화면디자인",null,null,null,null,null,null,null,null,"2024-07-01","2024-07-30",22,22,1,22,22,1]
[null,null,3,"3.1.3",null,null,"퍼블리싱가이드 정의",null,null,null,null,null,null,null,null,"2024-07-01","2024-07-30",22,22,1,22,22,1]
[null,null,3,"3.1.4",null,null,"화면퍼블리싱",null,null,null,null,null,null,null,null,"2024-07-01","2024-07-30",22,22,1,22,22,1]
[null,"G",2,"3.2",null,"클라이언트 개발",null,null,null,null,null,null,null,null,null,"2024-08-01","2024-09-30",86,86,1,43,43,1,null,0]
[null,null,3,"3.2.1",null,null,"공통(클라이언트)",null,null,null,null,null,null,null,null,"2024-08-01","2024-09-30",43,43,1,43,43,1]
[null,null,3,"3.2.2",null,null,"업무개발(클라이언트)",null,null,null,null,null,null,null,null,"2024-08-01","2024-09-30",43,43,1,43,43,1]
[null,"G",2,"3.3",null,"서버 개발",null,null,null,null,null,null,null,null,null,"2024-08-01","2024-09-30",129,129,1,43,43,1,null,0]
[null,null,3,"3.3.1",null,null,"공통(서버)",null,null,null,null,null,null,null,null,"2024-08-01","2024-09-30",43,43,1,43,43,1]
[null,null,3,"3.3.2",null,null,"업무 개발(서버)",null,null,null,null,null,null,null,null,"2024-08-01","2024-09-30",43,43,1,43,43,1]
[null,null,3,"3.3.3",null,null,"통합관리자 개발",null,null,null,null,null,null,null,null,"2024-08-01","2024-09-30",43,43,1,43,43,1]
[null,"G",2,"3.4",null,"단위테스트 실시",null,null,null,null,null,null,null,null,null,"2024-10-01","2024-10-20",14,14,1,14,14,1,null,0]
[null,null,3,"3.4.1",null,null,"단위테스트 수행",null,null,null,null,null,null,null,null,"2024-10-01","2024-10-20",14,14,1,14,14,1]
[null,"G",2,"3.5",null,"단계말 검토",null,null,null,null,null,null,null,null,null,"2024-10-01","2024-10-20",14,14,1,14,14,1,null,0]
[null,null,3,"3.5.1",null,null,"요구사항추적표(개발)",null,null,null,null,null,null,null,null,"2024-10-01","2024-10-20",14,14,1,14,14,1]
[null,"G",1,"4","테스트",null,null,null,null,null,null,null,null,null,null,"2024-10-20","2024-11-10",96,96,1,15,15,1,null,0]
[null,"G",2,"4.1",null,"통합테스트",null,null,null,null,null,null,null,null,null,"2024-10-20","2024-11-10",30,30,1,15,15,1,null,0]
[null,null,3,"4.1.1",null,null,"통합테스트시나리오(결과)",null,null,null,null,null,null,null,null,"2024-10-20","2024-11-10",15,15,1,15,15,1]
[null,null,3,"4.1.2",null,null,"통합테스트결과서",null,null,null,null,null,null,null,null,"2024-10-20","2024-11-10",15,15,1,15,15,1]
[null,"G",2,"4.2",null,"성능테스트",null,null,null,null,null,null,null,null,null,"2024-10-20","2024-11-10",30,30,1,15,15,1,null,0]
[null,null,3,"4.2.1",null,null,"성능테스트계획",null,null,null,null,null,null,null,null,"2024-10-20","2024-11-10",15,15,1,15,15,1]
[null,null,3,"4.2.2",null,null,"성틍테스트결과서",null,null,null,null,null,null,null,null,"2024-10-20","2024-11-10",15,15,1,15,15,1]
[null,"G",2,"4.3",null,"인수테스트",null,null,null,null,null,null,null,null,null,"2024-10-20","2024-11-10",30,30,1,15,15,1,null,0]
[null,null,3,"4.3.1",null,null,"인수테스트시나리오(결과)",null,null,null,null,null,null,null,null,"2024-10-20","2024-11-10",15,15,1,15,15,1]
[null,null,3,"4.3.2",null,null,"인수테스트결과서",null,null,null,null,null,null,null,null,"2024-10-20","2024-11-10",15,15,1,15,15,1]
[null,"G",2,"4.4",null,"단계말 검토",null,null,null,null,null,null,null,null,null,"2024-11-01","2024-11-10",6,6,1,6,6,1,null,0]
[null,null,3,"4.4.1",null,null,"요구사항추적표(테스트)",null,null,null,null,null,null,null,null,"2024-11-01","2024-11-10",6,6,1,6,6,1]
[null,"G",1,"5","이행",null,null,null,null,null,null,null,null,null,null,"2024-11-11","2024-12-05",109,109,1,19,19,1,null,0]
[null,"G",2,"5.1",null,"상용환경구축",null,null,null,null,null,null,null,null,null,"2024-11-11","2024-11-30",105,105,1,15,15,1,null,0]
[null,null,3,"5.1.1",null,null,"이행계획수립",null,null,null,null,null,null,null,null,"2024-11-11","2024-11-30",15,15,1,15,15,1]
[null,null,3,"5.1.2",null,null,"서버구축",null,null,null,null,null,null,null,null,"2024-11-11","2024-11-30",15,15,1,15,15,1]
[null,null,3,"5.1.3",null,null,"DB구축",null,null,null,null,null,null,null,null,"2024-11-11","2024-11-30",15,15,1,15,15,1]
[null,null,3,"5.1.4",null,null,"S/W설치",null,null,null,null,null,null,null,null,"2024-11-11","2024-11-30",15,15,1,15,15,1]
[null,null,3,"5.1.5",null,null,"DB마이그레이선",null,null,null,null,null,null,null,null,"2024-11-11","2024-11-30",15,15,1,15,15,1]
[null,null,3,"5.1.6",null,null,"PKG설치",null,null,null,null,null,null,null,null,"2024-11-11","2024-11-30",15,15,1,15,15,1]
[null,null,3,"5.1.7",null,null,"앱릴리즈",null,null,null,null,null,null,null,null,"2024-11-11","2024-11-30",15,15,1,15,15,1]
[null,"G",2,"5.2",null,"오픈",null,null,null,null,null,null,null,null,null,"2024-12-01","2024-12-05",4,4,1,4,4,1,null,0]
[null,null,3,"5.2.1",null,null,"서비스오픈",null,null,null,null,null,null,null,null,"2024-12-01","2024-12-05",4,4,1,4,4,1]
[null,"G",1,"6","안정화",null,null,null,null,null,null,null,null,null,null,"2024-12-01","2025-02-26",105,91,0.8666666666666667,63,49,0.77777777777777779,null,0]
[null,"G",2,"6.1",null,"서비스 운영 및 안정화",null,null,null,null,null,null,null,null,null,"2024-12-01","2025-02-26",105,91,0.8666666666666667,63,49,0.77777777777777779,null,0]
[null,null,3,"6.1.1",null,null,"사용자매뉴얼 작성",null,null,null,null,null,null,null,null,"2024-12-01","2024-12-05",4,4,1,4,4,1]
[null,null,3,"6.1.2",null,null,"운영자매뉴얼 작성",null,null,null,null,null,null,null,null,"2024-12-01","2024-12-31",22,22,1,22,22,1]
[null,null,3,"6.1.3",null,null,"안정화지원(모니터링 및 업무지원)",null,null,null,null,null,null,null,null,"2024-12-23","2025-01-31",30,30,1,30,30,1]
[null,null,3,"6.1.4",null,null,"인수인계 실시",null,null,null,null,null,null,null,null,"2024-12-20","2025-02-26",49,35,0.7142857142857143,49,35,0.7142857142857143]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]

{"sheet":"Calender","index":1,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,1,3],[1,5,1,8]]}
[]
["공휴일 정보관리(자동으로 생성)-공공데이터",null,null,null,null,"공휴일 정보관리(수기입력)"]
[null,null,"시작일 :","2024-04-03"]
[4,null,"종료일 :","2024-05-06",null,0]
["날짜","내용","휴일여부","요일",null,"날짜","내용","휴일여부","요일"]
["2024-04-10","국회의원선거","Y","수"]
["2024-05-05","어린이날","Y","일"]
["2024-05-06","대체공휴일(어린이날)","Y","월"]
["2024-05-15","부처님오신날","Y","수"]

{"sheet":"option","index":2,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["임시데이터 저장"]
["데이터명","데이터값","설명"]
["Version","v1.39"]
["ShowLine","Y","금일 날짜선을 보여줄지 여부"]
["GraphType","Y","Y,H,Q,M,W,D 중 1개(그래프 리본버튼 클릭시 셋팅)"]
["CurCellPos",28,"현재 일자 스크롤을 위한 날짜 저장"]
["전체시작일","2024-04-01","그래프 Redraw(updateData)시 자동으로 셋팅"]
["전체종료일","2025-02-26","그래프 Redraw(updateData)시 자동으로 셋팅"]
["공휴일조회키","GvjP2ed8s5KYm5jxqG0UON5rZ30wfH%2BRZo1eCrQT92CpjzYd5AB735rbsvrronMTsuYlhKWjSQXVC7jlS50r8Q%3D%3D","공공데이터 api Key 1년마다 갱신 필요"]
["isUpdatedDate","F","시작, 종료일자가 변경될시 T"]
["isUpdatedData","F","이외의 데이터가 변경될시 T"]
["ShowBar1",1,"입력 진행율 표시여부"]
["ShowBar2",0,"기간 진행율 표시여부"]
["GroupBarColor1Level",16776960,"RGB값 가운데 Space가 없도록 셋팅"]
["GroupBarColorMidLevel",65280,"RGB값 가운데 Space가 없도록 셋팅"]
["GroupBarColorNode",14540253,"RGB값 가운데 Space가 없도록 셋팅"]
["isVisibleBarTitle",0,"간트 바 오른쪽에 제목표시 여부"]
["isVisibleBarTerm",0,"간트 바 오른쪽에 기간표시 여부"]
["isVisibleBarEndDate",0,"간트 바 오른쪽에 종료일 표시여부"]
["UseDatepicker","N","날짜선택시 날짜선택 창 사용여부"]
["업무량컬럼보기",1,"3개컬럼"]
["기간진행현황컬럼보기",1,"3개컬럼"]
["MaxColPos",31]
["MaxDataPos",91]
["posTodayLine","1138.6,84,1138.6,1580"]

{"sheet":"Language","index":3,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["구분","ko","en"]
["no","No","No"]
["title","과제명","Assignment"]
["budge","예산","Budge"]
["start_date","시작일","Start Date"]
["end_date","종료일","End Date"]
["days","일수","Days"]
["complete_days","완료일","Complete\nDays"]
["progress_rate","진행율","Progress\nRate"]
["t_days","일수","Days"]
["t_complete_days","완료일","Complete\nDays"]
["t_progress_rate","진행율","Progress\nRate"]
["manager","담당자","Manager"]
["complete_rate","이행율\n(집접입력)","Complete\nRate"]
["comment","비고","Comment"]
["cb1","연도별 보기","Yearly View"]
["cb2","반기별 보기","Semiyearly View"]
["cb3","분기별 보기","Quarterly View"]
["cb4","월별 보기","Monthly View"]
["cb5","주별 보기","Weekly View"]
["cb6","일별 보기","Daily View"]
["tBtn1","날짜선 보기","Show Today Line"]
["tBtn2","오늘로 이동","Scroll Today"]
["tBtn3","달력 사용하기","Use DatePicker"]
["Btn20","프린트 영역설정","Set Print Area"]
["Btn21","데이터 가져오기","Update From File"]
["Btn22","공휴일 조회","Refresh Holiday"]
["Btn23","최신버전체크","Check Version"]
["Btn24","홈페이지","About"]
["Btn2","입력이행율 보기","Show Complete Rate"]
["Btn3","기간진행율 보기","Show Progress Rate"]
["Btn4","1레벨그룹색상","1Level Group Color"]
["Btn5","그룹색상","Group Color"]
["Btn6","단말색상","End Node Color"]
["Btn7","과제명 보기","Show Assignment"]
["Btn8","기간 보기","Show Term"]
["Btn9","종료일 보기","Show End Date"]
["aBtn1","업무량 보기","Workload"]
["aBtn2","기간진행현황 보기","Progress Status"]

{"sheet":"help","index":4,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,1,12,8],[4,1,6,8],[9,1,9,8],[8,1,8,8],[1,1,1,8],[2,1,2,8]]}
[]
[null,"ExcelGantt v1.0"]
[]
[]
[null,"프로젝트 일정관리를 Gantt차트로 표시하는 프로그램입니다. 현재는 할일과 일정을 기준으로 그래프를 표시하고 간단한 기능들만 제공하고 있으나 점차 기능을 개선할 예정임\n\n"]
[]
[]
[]
[null,"다운로드 주소"]
[null,"https://juhpark.tistory.com/45"]
[]
[]
[null,"사용법"]
[null,"1. 단위업무명, 시작, 종료 일자 등 파란색 타이틀 만 입력"]
[null,"2. 상단 ExcelGantt 리본메뉴의 Year, Quarter, Month, Day 를 눌러 원하는 그래프 표시"]
[null,"3. Show Line을 클릭하면, 현재 일자에 해당하는 세로 점섬이 표시"]
[null,"4. Month, Day 그래프에서 Scroll Today를 클릭하면 오늘 날짜 근처로 이동"]
[null,"5. 왼쪽 그룹화 버튼을 클릭하여 원하는 레벨로 그래프를 표시"]