{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Chart data","Gantt Chart","Dynamic Chart Data Hidden","About"],"not_rendered":{"charts":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Chart data","index":0,"n_rows":26,"n_cols":11,"rows_kept":26,"merged":[[1,1,1,2]]}
["Create a Date Tracking Gantt Chart in this worksheet.\nThe title of this worksheet is in cell B1. \nInformation about how to use this worksheet, including instructions for screen readers, is in the About worksheet.\nContinue navigating down column A for further instructions.","Date Tracking Gantt Chart"]
["Select option Yes in cell D2 if you want to highlight today’s date in the Gantt Chart worksheet. \nSelect option No in cell D2 if you do not want to highlight today’s date in the Gantt Chart worksheet.\nIn Cell D2, select ALT+Arrow Down for options.","Track today’s date?",null,"Yes"]
["Milestones header for the milestone table is in cell B3.\nTasks header for the tasks table is in cell G3.","Milestones",{"$nulls":4},"Tasks"]
["Information about the columns in the milestone table are in this row from cells B4 to E4.\nInformation about the columns in the tasks table are in this row from cells G4 to J4.","This column should be ordered sequentially.","The position column, charts milestones within the task chart.","Enter the date for a milestone in this column.","Enter a milestone description in this column. These descriptions will appear in the chart.",null,"This column should be ordered sequentially.","Enter the start date for each task below. For best results sort this column in ascending order.","Enter the end date for each task or activity below, in this column.","Enter tasks and/or activities in this column.","Auto-calculated column used for charting the duration of each task. Do not delete or modify."]
["Milestone table headers are in cells B5 to E5. Tasks table headers are in cells G5 to K5.\nMilestone sample data is in cells B6 to E17. \nTasks sample data is in cells G6 to J17.\nThe next instruction is in cell A21.","No.","Position","date","Milestone",null,"No.","Start Date","End Date","Task","Duration in days"]
[null,1,1,{"$f":"Start_Date+10","v":"2018-08-25"},"Milestone 1",null,1,{"$f":"TODAY()-1","v":"2018-08-15"},{"$f":"Tasks[[#This Row],[Start Date]]+1","v":"2018-08-16"},"Activity 1",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":2}]
[null,2,1,{"$f":"TODAY()+25","v":"2018-09-10"},"Milestone 2",null,2,{"$f":"TODAY()","v":"2018-08-16"},{"$f":"Tasks[[#This Row],[Start Date]]+1","v":"2018-08-17"},"Activity 2",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":2}]
[null,3,1,{"$f":"TODAY()+35","v":"2018-09-20"},"Milestone 3",null,3,{"$f":"TODAY()","v":"2018-08-16"},{"$f":"Tasks[[#This Row],[Start Date]]+5","v":"2018-08-21"},"Activity 3",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":6}]
[null,4,1,{"$f":"TODAY()+45","v":"2018-09-30"},"Milestone 4",null,4,{"$f":"TODAY()+1","v":"2018-08-17"},{"$f":"Tasks[[#This Row],[Start Date]]+7","v":"2018-08-24"},"Activity 4",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":8}]
[null,5,1,{"$f":"TODAY()+60","v":"2018-10-15"},"Milestone 5",null,5,{"$f":"TODAY()+8","v":"2018-08-24"},{"$f":"Tasks[[#This Row],[Start Date]]+10","v":"2018-09-03"},"Activity 5",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":11}]
[null,6,1,{"$f":"TODAY()+70","v":"2018-10-25"},"Milestone 6",null,6,{"$f":"TODAY()+12","v":"2018-08-28"},{"$f":"Tasks[[#This Row],[Start Date]]+30","v":"2018-09-27"},"Activity 6",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":31}]
[{"$nulls":6},7,{"$f":"TODAY()+15","v":"2018-08-31"},{"$f":"Tasks[[#This Row],[Start Date]]+15","v":"2018-09-15"},"Activity 7",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":16}]
[{"$nulls":6},8,{"$f":"TODAY()+25","v":"2018-09-10"},{"$f":"Tasks[[#This Row],[Start Date]]+5","v":"2018-09-15"},"Activity 8",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":6}]
[{"$nulls":6},9,{"$f":"TODAY()+34","v":"2018-09-19"},{"$f":"Tasks[[#This Row],[Start Date]]+2","v":"2018-09-21"},"Activity 9",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":3}]
[{"$nulls":6},10,{"$f":"TODAY()+40","v":"2018-09-25"},{"$f":"Tasks[[#This Row],[Start Date]]+30","v":"2018-10-25"},"Activity 10",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":31}]
[{"$nulls":6},11,{"$f":"TODAY()+42","v":"2018-09-27"},{"$f":"Tasks[[#This Row],[Start Date]]+23","v":"2018-10-20"},"Activity 11",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":24}]
[{"$nulls":6},12,{"$f":"TODAY()+50","v":"2018-10-05"},{"$f":"Tasks[[#This Row],[Start Date]]+5","v":"2018-10-10"},"Activity 12",{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":6}]
[{"$nulls":10},{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":""}]
[{"$nulls":10},{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":""}]
[{"$nulls":10},{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":""}]
["To add more Milestones, add a new row above this one.\nNote, the default number of milestones to chart is 15. Adding new milestones requires a change in the hidden worksheet. See the About worksheet cell A9 for more information.\nThe next instruction is in cell A26.","To add more Milestones, add a new row above this one.",{"$nulls":8},{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":""}]
[{"$nulls":10},{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":""}]
[{"$nulls":10},{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":""}]
[{"$nulls":10},{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":""}]
[{"$nulls":10},{"$f":"IFERROR(IF(LEN(Tasks[[#This Row],[Start Date]])=0,\"\",(INT(Tasks[[#This Row],[End Date]])-INT(Tasks[[#This Row],[Start Date]]))-(INT(Tasks[[#This Row],[Start Date]])-INT(Tasks[[#This Row],[Start Date]]))+1),\"\")","v":""}]
["A note is in cell G26.\nThis is the last instruction in this worksheet.",{"$nulls":5},"To add more Tasks, add a new row above this one."]

{"sheet":"Gantt Chart","index":1,"n_rows":1,"n_cols":1,"rows_kept":1}
["Gantt Chart showing Today, milestones and tasks within a date range is in this worksheet. \nA scrollbar is in row 1 from cells B1 to R1 and increments the date range showing future milestones.\nThe chart is drawn within cells B2 to R3.\nThis is the last instruction in this worksheet."]

{"sheet":"Dynamic Chart Data Hidden","index":2,"n_rows":32,"n_cols":10,"rows_kept":32,"hidden":true}
["Title of this worksheet is in cell B1.","Dynamic Chart data, Do NOT edit or delete this worksheet!"]
["Table title is in cells B2 and C2.",{"$f":"IF(TODAY()>=MIN(DynamicTaskData[Start date]),\"Today\",\"\")","v":"Today"},"highlight"]
["Table heading is in cells B3 and C3. These coordinates create the Today highlight in the chart.\nThe first column marks the day, the second indicates to draw the line that highlights today.\nThe first column date may change so the chart date range stays readable as the dates progress, however, a y co-ord of 0 indicates that no line has been drawn.\nDo not modify or delete this content or the charting may break. To no longer highlight Today’s date, simply select “no” in the Chart Data worksheet in cell D2.\nThe next instruction is in cell A7.","today highlight x co-ord","y co-ord"]
[null,{"$f":"IFERROR(IF(TODAY()<MIN(DynamicTaskData[Start date]),MIN($B$11,MIN(DynamicTaskData[Start date])),TODAY()),TODAY())","v":"2018-08-16"},{"$f":"IFERROR(IF(Track_Today=\"Yes\",IF(TODAY()<MIN(DynamicTaskData[Start date]),0,9),0),0)","v":9}]
[null,{"$f":"IFERROR(IF(TODAY()<MIN(DynamicTaskData[Start date]),MIN($B$11,MIN(DynamicTaskData[Start date])),TODAY()),TODAY())","v":"2018-08-16"},{"$f":"IFERROR(IF(Track_Today=\"Yes\",IF(TODAY()<MIN(DynamicTaskData[Start date]),0,9),0),0)","v":9}]
[]
["Table heading is in cell B7.\nThe scrolling increment in cell B8 represents the data graphed and visually appearing in the Gantt Chart at any one time. \nScrolling with the scroll bar at the top of the chart in row 1 of the Gantt Chart worksheet will increment this number.\nThe charting works best with single increments.\nThe next instruction is in cell A10.","scroll increment"]
[null,0]
[]
["Table heading is in cell B10 and D10.\nThe Charting Range helps select the appropriate range of tasks and milestones. Do not modify these fields.\nThe ageoff number keeps the chart readable by ageing tasks from the range and only plotting those that are within the range. Do not modify this number.\nThe next instruction is in cell A14.\n\n","Charting range",null,"ageoff"]
[null,{"$f":"IFERROR(IF(ScrollingIncrement[scroll increment]=0,Start_Date,IF(Start_Date+ScrollingIncrement[scroll increment]*15<End_Date,Start_Date+ScrollingIncrement[scroll increment]*15,End_Date-1)),\"\")","v":"2018-08-15"},null,45]
[null,{"$f":"IFERROR(IF($B$11+15<End_Date,$B$11+15,End_Date),\"\")","v":"2018-08-30"}]
[]
["Table heading for Dynamic Milestone Data is in cells B14 to E14. A note is in cell F14.\nThis table creates the Gantt Chart in the Gantt Chart worksheet, plotting 7 milestones at a time.\nThe data in this chart is auto-generated based on the content in the table above. \nDo not edit or delete this table or its contents.\nThe next instruction is in cell A17.","Tasks","Start date","Task duration in days","position","<-- this table creates the gantt chart, plotting 7 milestones at a time"]
[null,{"$f":"IFERROR(IF(LEN(OFFSET('Chart data'!$H6,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET('Chart data'!$I6,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET('Chart data'!$H6,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET('Chart data'!$G6,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 1"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET('Chart data'!$G6,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2018-08-15"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND('Chart data'!$H6<=$B$12,'Chart data'!$I6>=$B$12),ABS(OFFSET('Chart data'!$H6,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET('Chart data'!$K6,ScrollingIncrement[scroll increment],0,1,1))),\"\")","v":2},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,\"\",8),\"\")","v":8}]
[null,{"$f":"IFERROR(IF(LEN(OFFSET('Chart data'!$H7,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET('Chart data'!$I7,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET('Chart data'!$H7,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET('Chart data'!$G7,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 2"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET('Chart data'!$G7,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2018-08-16"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND('Chart data'!$H7<=$B$12,'Chart data'!$I7>=$B$12),ABS(OFFSET('Chart data'!$H7,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET('Chart data'!$K7,ScrollingIncrement[scroll increment],0,1,1))),\"\")","v":2},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,\"\",7),\"\")","v":7},null,"Milestone charting"]
["Cells G15 to I15 contain table headings for Dynamic Milestone Data. \nData in this table may appear blank, dates may appear to be incorrect, do not fill in, edit, delete or otherwise modify this data or you risk overwriting formulas and breaking the chart graphing capability.\nThe table allows for 15 milestones to be charted. To chart more than 15, simply expand the table to accommodate your number. Remember, only add the milestones in the Chart Data worksheet. Do not add any content to this table.\nA note is in cell J15.\nThe next instruction is in cell A32.",{"$f":"IFERROR(IF(LEN(OFFSET('Chart data'!$H8,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET('Chart data'!$I8,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET('Chart data'!$H8,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET('Chart data'!$G8,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 3"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET('Chart data'!$G8,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2018-08-16"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND('Chart data'!$H8<=$B$12,'Chart data'!$I8>=$B$12),ABS(OFFSET('Chart data'!$H8,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET('Chart data'!$K8,ScrollingIncrement[scroll increment],0,1,1))),\"\")","v":6},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,\"\",6),\"\")","v":6},null,"Milestones","Date","Baseline","<-- this table creates the milestone markers in the gantt chart, plotting only those milestones that fit in the range of dates shown – up to 15 milestones"]
[null,{"$f":"IFERROR(IF(LEN(OFFSET('Chart data'!$H9,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET('Chart data'!$I9,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET('Chart data'!$H9,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET('Chart data'!$G9,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 4"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET('Chart data'!$G9,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2018-08-17"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND('Chart data'!$H9<=$B$12,'Chart data'!$I9>=$B$12),ABS(OFFSET('Chart data'!$H9,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET('Chart data'!$K9,ScrollingIncrement[scroll increment],0,1,1))),\"\")","v":8},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,\"\",5),\"\")","v":5},null,{"$f":"IFERROR(IF(LEN('Chart data'!D6)=0,\"\",IF(AND('Chart data'!D6<=$B$12,'Chart data'!D6>=$B$11-$D$11),'Chart data'!E6,\"\")),\"\")","v":"Milestone 1"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D6),2)","v":"2018-08-25"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C6),\"\")","v":1}]
[null,{"$f":"IFERROR(IF(LEN(OFFSET('Chart data'!$H10,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET('Chart data'!$I10,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET('Chart data'!$H10,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET('Chart data'!$G10,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 5"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET('Chart data'!$G10,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2018-08-24"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND('Chart data'!$H10<=$B$12,'Chart data'!$I10>=$B$12),ABS(OFFSET('Chart data'!$H10,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET('Chart data'!$K10,ScrollingIncrement[scroll increment],0,1,1))),\"\")","v":7},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,\"\",4),\"\")","v":4},null,{"$f":"IFERROR(IF(LEN('Chart data'!D7)=0,\"\",IF(AND('Chart data'!D7<=$B$12,'Chart data'!D7>=$B$11-$D$11),'Chart data'!E7,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D7),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C7),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(LEN(OFFSET('Chart data'!$H11,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET('Chart data'!$I11,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET('Chart data'!$H11,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET('Chart data'!$G11,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 6"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET('Chart data'!$G11,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2018-08-28"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND('Chart data'!$H11<=$B$12,'Chart data'!$I11>=$B$12),ABS(OFFSET('Chart data'!$H11,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET('Chart data'!$K11,ScrollingIncrement[scroll increment],0,1,1))),\"\")","v":3},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,\"\",3),\"\")","v":3},null,{"$f":"IFERROR(IF(LEN('Chart data'!D8)=0,\"\",IF(AND('Chart data'!D8<=$B$12,'Chart data'!D8>=$B$11-$D$11),'Chart data'!E8,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D8),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C8),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(LEN(OFFSET('Chart data'!$H12,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET('Chart data'!$I12,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET('Chart data'!$H12,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET('Chart data'!$G12,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 7"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET('Chart data'!$G12,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2018-08-31"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND('Chart data'!$H12<=$B$12,'Chart data'!$I12>=$B$12),ABS(OFFSET('Chart data'!$H12,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET('Chart data'!$K12,ScrollingIncrement[scroll increment],0,1,1))),\"\")","v":16},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,\"\",2),\"\")","v":2},null,{"$f":"IFERROR(IF(LEN('Chart data'!D9)=0,\"\",IF(AND('Chart data'!D9<=$B$12,'Chart data'!D9>=$B$11-$D$11),'Chart data'!E9,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D9),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C9),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN('Chart data'!D10)=0,\"\",IF(AND('Chart data'!D10<=$B$12,'Chart data'!D10>=$B$11-$D$11),'Chart data'!E10,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D10),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C10),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN('Chart data'!D11)=0,\"\",IF(AND('Chart data'!D11<=$B$12,'Chart data'!D11>=$B$11-$D$11),'Chart data'!E11,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D11),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C11),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN('Chart data'!D12)=0,\"\",IF(AND('Chart data'!D12<=$B$12,'Chart data'!D12>=$B$11-$D$11),'Chart data'!E12,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D12),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C12),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN('Chart data'!D13)=0,\"\",IF(AND('Chart data'!D13<=$B$12,'Chart data'!D13>=$B$11-$D$11),'Chart data'!E13,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D13),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C13),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN('Chart data'!D14)=0,\"\",IF(AND('Chart data'!D14<=$B$12,'Chart data'!D14>=$B$11-$D$11),'Chart data'!E14,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D14),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C14),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN('Chart data'!D15)=0,\"\",IF(AND('Chart data'!D15<=$B$12,'Chart data'!D15>=$B$11-$D$11),'Chart data'!E15,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D15),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C15),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN('Chart data'!D16)=0,\"\",IF(AND('Chart data'!D16<=$B$12,'Chart data'!D16>=$B$11-$D$11),'Chart data'!E16,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D16),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C16),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN('Chart data'!D17)=0,\"\",IF(AND('Chart data'!D17<=$B$12,'Chart data'!D17>=$B$11-$D$11),'Chart data'!E17,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D17),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C17),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN('Chart data'!D18)=0,\"\",IF(AND('Chart data'!D18<=$B$12,'Chart data'!D18>=$B$11-$D$11),'Chart data'!E18,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D18),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C18),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN('Chart data'!D19)=0,\"\",IF(AND('Chart data'!D19<=$B$12,'Chart data'!D19>=$B$11-$D$11),'Chart data'!E19,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D19),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C19),\"\")","v":""}]
["A note is in cell J32.\nThis is the last instruction in this worksheet.",{"$nulls":5},{"$f":"IFERROR(IF(LEN('Chart data'!D20)=0,\"\",IF(AND('Chart data'!D20<=$B$12,'Chart data'!D20>=$B$11-$D$11),'Chart data'!E20,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,'Chart data'!$D20),2)","v":"2018-08-30"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",'Chart data'!$C20),\"\")","v":""},"<--To chart more than 15 milestones, simply expand this table and enter new entries in the Milestone table in the Chart Data worksheet.\n"]

{"sheet":"About","index":3,"n_rows":11,"n_cols":1,"rows_kept":11}
["About this workbook"]
["Enter milestone and task information in the Chart Data worksheet. To chart milestones along the timeline, enter 0 in the No. column, then update the label position to be “below” to avoid overlapping labels.\n\nThe position column in the milestone table charts milestones within the task chart either on the same row or in stacked rows. To chart them on the same row, enter the same number in this column for each milestone. To chart them on different rows, enter different numbers. Sample data charts all milestones along the row position of 2.\n"]
["Guide for screen readers"]
["\nThere are 4 worksheets in this workbook. \n\nChart Data\nGantt Chart\nDynamic Chart Data (Hidden)\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\nHidden text will not print.\nTo remove these instructions from any worksheet, simply delete column A.\n"]
["Dynamic Chart Data (Hidden)"]
["\nDo not delete or modify content in the Hidden worksheet. Doing so could compromise the integrity of the Gantt Charting.\n\nData may appear blank, dates may appear to be incorrect, do not fill in, edit, delete or otherwise modify the data or you risk overwriting formulas and breaking the chart graphing capability.\n\nThe DynamicMilestone table allows for 15 milestones to be charted. To chart more than 15, simply expand the table to accommodate your number. Remember, only add the actual milestone data in the Chart Data worksheet.\n"]
["Tips"]
["\nBy default, milestones are charted on row 1 of the Gantt Chart using the Position column in the Chart Data worksheet, starting in cell C5. To chart milestones on different rows, simply change the number. \n"]
["The default setting is to highlight today’s date in the Gantt Chart. To no longer highlight Today’s date, simply select “no” in the Chart Data worksheet in cell D2.\n"]
["The Gantt Chart date timeline is charted with a gap of 5 dates between them. To change this, select the timeline in the Gantt Chart worksheet and select Format Axis. Change the Major unit from 5 to 1 or 10, for example. \n"]
["This is the last instruction in this worksheet."]