{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["ProjectSchedule","About"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"ProjectSchedule","index":0,"n_rows":33,"n_cols":64,"rows_kept":33,"merged":[[2,2,2,3],[2,4,2,5],[3,2,3,3],[3,8,3,14],[3,15,3,21],[3,22,3,28],[3,29,3,35],[3,36,3,42],[3,43,3,49],[3,50,3,56],[3,57,3,63],[4,1,4,6]]}
["Create a project schedule in this worksheet.\nEnter the title of this project in cell B1. \nInformation about how to use this worksheet, including instructions for screen readers and the author of this workbook, is in the About worksheet.\nContinue navigating down column A to hear further instructions.","PROJECT TITLE",{"$nulls":6},"SIMPLE GANTT CHART by Vertex42.com"]
["Enter the company name in cell B2.","Company Name",{"$nulls":6},"https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html"]
["Enter the name of the project lead in cell B3. Enter the project start date in cell E3. The project start label is in cell C3.","Project Lead","Project Start:",null,{"$f":"TODAY()","v":"2019-03-27"}]
["The display week in cell E4 represents the starting week to display in the project schedule in cell I4. The project start date is considered Week 1. To change the display week, simply enter a new week number in cell E4.\nThe starting date for each week, starting with the display week from cell E4, starts in cell I4 and is automatically calculated. There are 8 weeks represented in this view from cell I4 to cell BF4.\nYou should not modify these cells.\nThe display week label is in cell C4.",null,"Display Week:",null,1,{"$nulls":3},{"$f":"I5","v":"2019-03-25"},{"$nulls":6},{"$f":"P5","v":"2019-04-01"},{"$nulls":6},{"$f":"W5","v":"2019-04-08"},{"$nulls":6},{"$f":"AD5","v":"2019-04-15"},{"$nulls":6},{"$f":"AK5","v":"2019-04-22"},{"$nulls":6},{"$f":"AR5","v":"2019-04-29"},{"$nulls":6},{"$f":"AY5","v":"2019-05-06"},{"$nulls":6},{"$f":"BF5","v":"2019-05-13"}]
["Cells I5 to BL5 contain the day number for the week represented in the cell block above each date cell and are automatically calculated.\nYou should not modify these cells.\nToday’s date is outlined in red (hex #AD3815) from today’s date on row 5 throughout the entire date column to the end of the project schedule.",{"$nulls":7},{"$f":"Project_Start-WEEKDAY(Project_Start,1)+2+7*(Display_Week-1)","v":"2019-03-25"},{"$f":"I5+1","v":"2019-03-26"},{"$f":"J5+1","v":"2019-03-27"},"2019-03-28","2019-03-29","2019-03-30","2019-03-31",{"$f":"O5+1","v":"2019-04-01"},{"$f":"P5+1","v":"2019-04-02"},"2019-04-03","2019-04-04","2019-04-05","2019-04-06","2019-04-07",{"$f":"V5+1","v":"2019-04-08"},{"$f":"W5+1","v":"2019-04-09"},"2019-04-10","2019-04-11","2019-04-12","2019-04-13","2019-04-14",{"$f":"AC5+1","v":"2019-04-15"},{"$f":"AD5+1","v":"2019-04-16"},"2019-04-17","2019-04-18","2019-04-19","2019-04-20","2019-04-21",{"$f":"AJ5+1","v":"2019-04-22"},{"$f":"AK5+1","v":"2019-04-23"},"2019-04-24","2019-04-25","2019-04-26","2019-04-27","2019-04-28",{"$f":"AQ5+1","v":"2019-04-29"},{"$f":"AR5+1","v":"2019-04-30"},"2019-05-01","2019-05-02","2019-05-03","2019-05-04","2019-05-05",{"$f":"AX5+1","v":"2019-05-06"},{"$f":"AY5+1","v":"2019-05-07"},{"$f":"AZ5+1","v":"2019-05-08"},"2019-05-09","2019-05-10","2019-05-11","2019-05-12",{"$f":"BE5+1","v":"2019-05-13"},{"$f":"BF5+1","v":"2019-05-14"},{"$f":"BG5+1","v":"2019-05-15"},"2019-05-16","2019-05-17","2019-05-18","2019-05-19"]
["This row contains headers for the project schedule that follows below them. \nNavigate from B6 to BL6 to hear the content. The first letter of each day of the week for the date above that heading starts in cell I6 and continues to cell BL6.\nAll project timeline graphing is automatically generated based on the start and end dates entered, using conditional formats.\nDo not modify content in cells within columns after column I starting with cell I7.","TASK","ASSIGNED\nTO","PROGRESS","START","END",null,"DAYS",{"$f":"LEFT(TEXT(I5,\"ddd\"),1)","v":"M"},{"$f":"LEFT(TEXT(J5,\"ddd\"),1)","v":"T"},"W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S","M",{"$f":"LEFT(TEXT(AS5,\"ddd\"),1)","v":"T"},"W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F","S","S"]
["Do not delete this row. This row is hidden to preserve a formula that is used to highlight the current day within the project schedule. ",{"$nulls":6},{"$f":"IF(OR(ISBLANK(task_start),ISBLANK(task_end)),\"\",task_end-task_start+1)","v":""}]
["Cell B8 contains the phase 1 sample title. \nEnter a new title in cell B8.\nEnter a name to assign the phase to, if this applies to your project, in cell C8.\nEnter the progress for the entire phase, if this applies to your project, in cell D8.\nEnter the start and end dates for the entire phase, if this applies to your project, in cells E8 and F8. \nThe Gantt chart will automatically fill in the appropriate dates and shade according to the progress entered.\nTo delete the phase and work only from tasks, simply delete this row.","Phase 1 Title",{"$nulls":5},{"$f":"IF(OR(ISBLANK(task_start),ISBLANK(task_end)),\"\",task_end-task_start+1)","v":""}]
["Cell B9 contains the sample task “Task 1”. \nEnter a new task name in cell B9.\nEnter a person to assign the task to in cell C9.\nEnter the progress of the task in cell D9. A progress bar appears in the cell and is shaded according to the number in the cell. For example, 50 per cent progress would shade half of the cell.\nEnter the task start date in cell E9.\nEnter the task end date in cell E9.\nA status bar shaded for the dates entered appears in blocks from cell I9 to BL9. ","Task 1","Name",{"v":0.5,"d":"50%"},{"$f":"Project_Start","v":"2019-03-27"},{"$f":"E9+3","v":"2019-03-30"},null,4]
["Rows 10 to 13 repeat the pattern from row 9. \nRepeat the instructions from cell A9 for all task rows in this worksheet. Overwrite any sample data.\nA sample of another phase starts in cell A14. \nContinue entering tasks in cells A10 to A13 or go to cell A14 to learn more.","Task 2",null,{"v":0.6,"d":"60%"},{"$f":"F9","v":"2019-03-30"},{"$f":"E10+2","v":"2019-04-01"},null,3]
[null,"Task 3",null,{"v":0.5,"d":"50%"},{"$f":"F10","v":"2019-04-01"},{"$f":"E11+4","v":"2019-04-05"},null,5]
[null,"Task 4",null,{"v":0.25,"d":"25%"},{"$f":"F11","v":"2019-04-05"},{"$f":"E12+5","v":"2019-04-10"},null,6]
[null,"Task 5",null,null,{"$f":"E10+1","v":"2019-03-31"},{"$f":"E13+2","v":"2019-04-02"},null,3]
["The cell to the right contains the phase 2 sample title. \nYou can create a new phase at any time within column B. This project schedule does not require phases. To remove the phase, simply delete the row.\nTo create a new phase block in this row, enter a new title in the cell to the right.\nTo continue adding tasks to the phase above, enter a new row above this one and fill in the task data according to cell A9’s instructions.\nUpdate the phase details in the cell to the right based on cell A8’s instructions.\nContinue navigating down column A cells to learn more.\nIf you haven’t added any new rows in this worksheet, you will find that two additional sample phase blocks have been created for you in cells B20 and B26. Otherwise, navigate through the column A cells to find the additional blocks. \nRepeat the instructions from cells A8 and A9 whenever you need to.","Phase 2 Title",{"$nulls":5},""]
[null,"Task 1",null,{"v":0.5,"d":"50%"},{"$f":"E13+1","v":"2019-04-01"},{"$f":"E15+4","v":"2019-04-05"},null,5]
[null,"Task 2",null,{"v":0.5,"d":"50%"},{"$f":"E15+2","v":"2019-04-03"},{"$f":"E16+5","v":"2019-04-08"},null,6]
[null,"Task 3",null,null,{"$f":"F16","v":"2019-04-08"},{"$f":"E17+3","v":"2019-04-11"},null,4]
[null,"Task 4",null,null,{"$f":"E17","v":"2019-04-08"},{"$f":"E18+2","v":"2019-04-10"},null,3]
[null,"Task 5",null,null,{"$f":"E18","v":"2019-04-08"},{"$f":"E19+3","v":"2019-04-11"},null,4]
["Sample phase title block","Phase 3 Title",{"$nulls":5},""]
[null,"Task 1",null,null,{"$f":"E9+15","v":"2019-04-11"},{"$f":"E21+5","v":"2019-04-16"},null,6]
[null,"Task 2",null,null,{"$f":"F21+1","v":"2019-04-17"},{"$f":"E22+4","v":"2019-04-21"},null,5]
[null,"Task 3",null,null,{"$f":"E22+5","v":"2019-04-22"},{"$f":"E23+5","v":"2019-04-27"},null,6]
[null,"Task 4",null,null,{"$f":"F23+1","v":"2019-04-28"},{"$f":"E24+4","v":"2019-05-02"},null,5]
[null,"Task 5",null,null,{"$f":"E23","v":"2019-04-22"},{"$f":"E25+4","v":"2019-04-26"},null,5]
["Sample phase title block","Phase 4 Title",{"$nulls":5},""]
[null,"Task 1",null,null,"date","date",null,{"$error":"#VALUE!"}]
[null,"Task 2",null,null,"date","date",null,{"$error":"#VALUE!"}]
[null,"Task 3",null,null,"date","date",null,{"$error":"#VALUE!"}]
[null,"Task 4",null,null,"date","date",null,{"$error":"#VALUE!"}]
[null,"Task 5",null,null,"date","date",null,{"$error":"#VALUE!"}]
["This is an empty row",{"$nulls":6},""]
["This row marks the end of the project schedule. DO NOT enter anything in this row. \nInsert new rows ABOVE this one to continue working on your project schedule.","Insert new rows ABOVE this one",{"$nulls":5},""]

{"sheet":"About","index":1,"n_rows":16,"n_cols":1,"rows_kept":16}
[]
["SIMPLE GANTT CHART by Vertex42.com"]
["https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html"]
["About this template"]
["This template provides a simple way to create a Gantt chart to help visualise and track your project. Simply enter your tasks and start and end dates – no formulas are required. The bars in the Gantt chart represent the duration of the tasks and are displayed using conditional formatting. Insert new tasks by inserting new rows."]
["Guide for screen readers"]
["There are 2 worksheets in this workbook. \n\nProjectSchedule\nAbout\n\nThe instructions for each worksheet are in the A column starting in cell A1 of each worksheet. They are written with hidden text. Each step guides you to the information in that row. Each subsequent step continues in cell A2, A3 and so on, unless otherwise explicitly directed. For example, instruction text might say “continue to cell A6” for the next step. \n\nThis hidden text will not print.\n\nTo remove these instructions from the worksheet, simply delete column A."]
["Additional help"]
["Click on the link below to visit vertex42.com and learn more about how to use this template, such as how to calculate days and workdays, create task dependencies, change the colours of the bars, add a scroll bar to make it easier to change the display week, extend the date range displayed in the chart etc."]
["How to use the simple Gantt chart"]
["More project management templates"]
["Visit Vertex42.com to download other project management templates, including different types of project schedules, Gantt charts, tasks lists etc."]
["Project management templates"]
["About Vertex42"]
["Vertex42.com provides over 300 professionally designed spreadsheet templates for business, home and education – most of which are free to download. Their collection includes a variety of calendars, planners and schedules as well as personal finance spreadsheets for budgeting, debt reduction and loan amortisation."]
["Businesses will find invoices, timesheets, inventory trackers, financial statements and project planning templates. Teachers and students will find resources such as timetables, mark books and registers. Organise your family life with meal planners, checklists and exercise logs. Each template is thoroughly researched, refined and improved over time through feedback from thousands of users."]