{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Gantt","About"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Gantt","index":0,"n_rows":34,"n_cols":64,"rows_kept":34,"merged":[[1,8,1,11],[1,13,1,16],[1,18,1,21],[1,23,1,26],[1,28,1,31],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,1,4,7]]}
["Create a Gantt Chart in this worksheet.\nEnter title of this project in cell B1. \nLegend title is in cell I1.\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},"Legend:"]
["Enter Company Name in cell B2.\nA legend is in cells I2 to AC2.","Company Name",{"$nulls":6},"On track",{"$nulls":4},"Low risk",{"$nulls":4},"Med risk",{"$nulls":4},"High risk",{"$nulls":4},"Unassigned"]
["Enter the name of the Project Lead in cell B3. Enter the Project Start date in cell F3 or allow the sample formula to find the smallest date value from the Gantt Data table.\nProject Start Date: label is in cell D3.","Project Lead",null,"Project Start Date:",null,{"$f":"IFERROR(IF(MIN(Milestones[Start])=0,TODAY(),MIN(Milestones[Start])),TODAY())","v":"2018-07-07"}]
["A Scrolling Increment is in cell F4. \nMonths for the dates in row 5 are displayed starting in cells I4 to cell BL4.\nDo not modify these cells. They are auto-updated based on the project start date in cell F3.",null,null,"Scrolling Increment:",null,0,null,null,{"$f":"TEXT(I5,\"mmmm\")","v":"July"},{"$nulls":6},{"$f":"IF(TEXT(P5,\"mmmm\")=I4,\"\",TEXT(P5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W5,\"mmmm\")=P4,TEXT(W5,\"mmmm\")=I4),\"\",TEXT(W5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD5,\"mmmm\")=W4,TEXT(AD5,\"mmmm\")=P4,TEXT(AD5,\"mmmm\")=I4),\"\",TEXT(AD5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK5,\"mmmm\")=AD4,TEXT(AK5,\"mmmm\")=W4,TEXT(AK5,\"mmmm\")=P4,TEXT(AK5,\"mmmm\")=I4),\"\",TEXT(AK5,\"mmmm\"))","v":"August"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR5,\"mmmm\")=AK4,TEXT(AR5,\"mmmm\")=AD4,TEXT(AR5,\"mmmm\")=W4,TEXT(AR5,\"mmmm\")=P4),\"\",TEXT(AR5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY5,\"mmmm\")=AR4,TEXT(AY5,\"mmmm\")=AK4,TEXT(AY5,\"mmmm\")=AD4,TEXT(AY5,\"mmmm\")=W4),\"\",TEXT(AY5,\"mmmm\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF5,\"mmmm\")=AY4,TEXT(BF5,\"mmmm\")=AR4,TEXT(BF5,\"mmmm\")=AK4,TEXT(BF5,\"mmmm\")=AD4),\"\",TEXT(BF5,\"mmmm\"))","v":""}]
["Cells I5 to BL5 contain the day number of the month for the Month represented in the cell block above each date cell and are auto-calculated.\nDo not modify these cells.\nToday’s date is outlined in Red (hex #AD3815) from today’s date in row 5 through the entire date column to the end of the project schedule.",{"$nulls":7},{"$f":"IFERROR(Project_Start+Scrolling_Increment,TODAY())","v":"2018-07-07"},{"$f":"I5+1","v":"2018-07-08"},{"$f":"J5+1","v":"2018-07-09"},"2018-07-10","2018-07-11","2018-07-12","2018-07-13",{"$f":"O5+1","v":"2018-07-14"},{"$f":"P5+1","v":"2018-07-15"},"2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20",{"$f":"V5+1","v":"2018-07-21"},{"$f":"W5+1","v":"2018-07-22"},"2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27",{"$f":"AC5+1","v":"2018-07-28"},{"$f":"AD5+1","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03",{"$f":"AJ5+1","v":"2018-08-04"},{"$f":"AK5+1","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10",{"$f":"AQ5+1","v":"2018-08-11"},{"$f":"AR5+1","v":"2018-08-12"},"2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17",{"$f":"AX5+1","v":"2018-08-18"},{"$f":"AY5+1","v":"2018-08-19"},{"$f":"AZ5+1","v":"2018-08-20"},"2018-08-21","2018-08-22","2018-08-23","2018-08-24",{"$f":"BE5+1","v":"2018-08-25"},{"$f":"BF5+1","v":"2018-08-26"},{"$f":"BG5+1","v":"2018-08-27"},"2018-08-28","2018-08-29","2018-08-30","2018-08-31"]
["A scrollbar is in cells I6 to BL6. The increment for paging through the data is defined as 2 pages at a time and can be configured in the settings for the control bar. \nTo jump forwards or backwards in the timeline, enter a value of 0 or higher in cell F4.\nA value of 0 takes you to the beginning of the chart."]
["This row contains headers for the project schedule that follows below them. \nNavigate from B7 to BL7 to hear the content. The first letter of each day of the week for the date above that heading, starts in cell I7 and continues to cell BL7.\nAll project timeline charting is auto-generated based on the category, start date and number of days entered in the Milestones table.","Milestone description","Category","Assigned To","Progress","Start","No. Days",null,{"$f":"LEFT(TEXT(I5,\"ddd\"),1)","v":"S"},{"$f":"LEFT(TEXT(J5,\"ddd\"),1)","v":"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","T","W","T","F","S",{"$f":"LEFT(TEXT(AS5,\"ddd\"),1)","v":"S"},"M","T","W","T","F","S","S","M","T","W","T","F","S","S","M","T","W","T","F"]
["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. "]
["Enter Project information starting in cell B9 to cell G9. \nSample data is in cells B9 to G33.\nEnter Milestone Description, select a Category from the drop-down list, assign someone to the item, enter the progress, start date and number of days for the task to start charting.\nThe next instruction is in cell A34.","Title 1",{"$nulls":6},{"$f":"IF(AND($C9=\"Goal\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"Milestone\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Goal\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"Milestone\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Goal\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"Milestone\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"Goal\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"Milestone\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"Task 1","Goal","Name",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2018-08-16"},3,null,{"$f":"IF(AND($C10=\"Goal\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"Milestone\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",2,2,2,"","","","","","","","","","","","",""]
[null,"Task 2","Milestone",null,null,{"$f":"TODAY()+5","v":"2018-08-21"},1,null,{"$f":"IF(AND($C11=\"Goal\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"Milestone\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",1,"","","","","","","","","",""]
[null,"Task 3","Low risk",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2018-08-13"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 4","Milestone",null,null,{"$f":"F10+20","v":"2018-09-05"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5","Med risk",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2018-08-22"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Title 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 1","High risk",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2018-08-22"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 2","On track",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2018-08-24"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 3","Low risk",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2018-08-29"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 4","Milestone",null,null,{"$f":"F18+2","v":"2018-08-31"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",1]
[null,"Task 5",{"$nulls":3},{"$f":"F19+1","v":"2018-09-01"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Title 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 1","On track",null,null,{"$f":"F10+15","v":"2018-08-31"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 2","Med risk",null,null,{"$f":"F22+3","v":"2018-09-03"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 3","On track",null,null,{"$f":"F23+15","v":"2018-09-18"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Goal\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"Milestone\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"Goal\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"Milestone\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"Task 4","Goal",null,null,{"$f":"F19+22","v":"2018-09-22"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"Goal\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"Milestone\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5","Low risk",null,null,{"$f":"F14","v":"2018-08-22"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Title 4",{"$nulls":6},{"$f":"IF(AND($C27=\"Goal\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"Milestone\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 1",{"$nulls":3},{"$f":"F25+3","v":"2018-09-25"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 3","Milestone",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Task 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["This is an empty row",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["This row marks the end of the Gantt milestone data. DO NOT enter anything in this row. \nTo add more items, insert new rows above this one.","To add more data, Insert new rows ABOVE this one"]

{"sheet":"About","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["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 description, select a category of Goal, Milestone, On Track, Low Risk, Med Risk, High Risk, Progress as a per cent of task completion, a Start Date and Number of days to complete the task. The Gantt chart fills in and is colour-coded to help distinguish the various categories. A scroll bar allows you to scroll through the timeline. Insert new tasks by inserting new rows.\n"]
["Guide for screen readers"]
["There are two worksheets in this workbook. \n\nGantt Chart\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."]
["This is the last instruction in this worksheet."]