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

{"sheet":"About","index":0,"n_rows":11,"n_cols":1,"rows_kept":11}
["About this workbook"]
["Enter milestone and task information in the Milestones and Tasks worksheets.  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 5 worksheets in this workbook:\nAbout\nMilestones\nTasks\nGantt Chart\nDynamic Chart Data (Hidden)\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 through 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."]

{"sheet":"Milestones","index":1,"n_rows":26,"n_cols":5,"rows_kept":26}
["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"]
["Information about the columns in the milestone table are in this row from cells B4 through E4.\nInformation about the columns in the tasks table are in this row from cells G4 through 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."]
["Milestone table headers are in cells B5 through E5. Tasks table headers are in cells G5 through J5.\nMilestone sample data is in cells B6 through E11. \nTasks sample data is in cells G6 through J17.\nThe next instruction is in cell A21.","No.","Position","Date","Milestone"]
[null,1,1,{"$f":"Start_Date+10","v":"2024-01-19"},"Milestone 1"]
[null,2,1,{"$f":"TODAY()+25","v":"2024-02-04"},"Milestone 2"]
[null,3,1,{"$f":"TODAY()+35","v":"2024-02-14"},"Milestone 3"]
[null,4,1,{"$f":"TODAY()+45","v":"2024-02-24"},"Milestone 4"]
[null,5,1,{"$f":"TODAY()+60","v":"2024-03-10"},"Milestone 5"]
[null,6,1,{"$f":"TODAY()+70","v":"2024-03-20"},"Milestone 6"]
{"$rows_empty":9}
["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."]
[]
[]
[]
[]
["A note is in cell G26.\nThis is the last instruction in this worksheet."]

{"sheet":"Tasks","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
["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"]
[]
["Milestones header for the milestone table is in cell B3.\nTasks header for the tasks table is in cell G3.","Tasks"]
[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."]
[null,"No.","Start Date","End Date","Task","Duration in days"]
[null,1,{"$f":"TODAY()-1","v":"2024-01-09"},{"$f":"Tasks[[#This Row],[Start Date]]+1","v":"2024-01-10"},"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":{"v":2,"d":"2 "}}]
[null,2,{"$f":"TODAY()","v":"2024-01-10"},{"$f":"Tasks[[#This Row],[Start Date]]+1","v":"2024-01-11"},"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":{"v":2,"d":"2 "}}]
[null,3,{"$f":"TODAY()","v":"2024-01-10"},{"$f":"Tasks[[#This Row],[Start Date]]+5","v":"2024-01-15"},"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":{"v":6,"d":"6 "}}]
[null,4,{"$f":"TODAY()+1","v":"2024-01-11"},{"$f":"Tasks[[#This Row],[Start Date]]+7","v":"2024-01-18"},"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":{"v":8,"d":"8 "}}]
[null,5,{"$f":"TODAY()+8","v":"2024-01-18"},{"$f":"Tasks[[#This Row],[Start Date]]+10","v":"2024-01-28"},"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":{"v":11,"d":"11 "}}]
[null,6,{"$f":"TODAY()+12","v":"2024-01-22"},{"$f":"Tasks[[#This Row],[Start Date]]+30","v":"2024-02-21"},"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":{"v":31,"d":"31 "}}]
[null,7,{"$f":"TODAY()+15","v":"2024-01-25"},{"$f":"Tasks[[#This Row],[Start Date]]+15","v":"2024-02-09"},"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":{"v":16,"d":"16 "}}]
[null,8,{"$f":"TODAY()+25","v":"2024-02-04"},{"$f":"Tasks[[#This Row],[Start Date]]+5","v":"2024-02-09"},"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":{"v":6,"d":"6 "}}]
[null,9,{"$f":"TODAY()+34","v":"2024-02-13"},{"$f":"Tasks[[#This Row],[Start Date]]+2","v":"2024-02-15"},"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":{"v":3,"d":"3 "}}]
[null,10,{"$f":"TODAY()+40","v":"2024-02-19"},{"$f":"Tasks[[#This Row],[Start Date]]+30","v":"2024-03-20"},"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":{"v":31,"d":"31 "}}]
[null,11,{"$f":"TODAY()+42","v":"2024-02-21"},{"$f":"Tasks[[#This Row],[Start Date]]+23","v":"2024-03-15"},"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":{"v":24,"d":"24 "}}]
[null,12,{"$f":"TODAY()+50","v":"2024-02-29"},{"$f":"Tasks[[#This Row],[Start Date]]+5","v":"2024-03-05"},"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":{"v":6,"d":"6 "}}]
[{"$nulls":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":""}]
[{"$nulls":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":""}]
[{"$nulls":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":""}]
[{"$nulls":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":""}]
[{"$nulls":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":""}]
[{"$nulls":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":""}]
[{"$nulls":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":""}]
[{"$nulls":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":""}]
[null,"To add more Tasks, add a new row above this one."]

{"sheet":"Gantt Chart","index":3,"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 through R1 and increments the date range showing future milestones.\nThe chart is drawn within cells B2 through R3.\nThis is the last instruction in this worksheet."]

{"sheet":"Dynamic Chart Data Hidden","index":4,"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 no line is 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":"2024-01-10"},{"$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":"2024-01-10"},{"$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 instructin 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 aging 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":"2024-01-09"},null,45]
[null,{"$f":"IFERROR(IF($B$11+15<End_Date,$B$11+15,End_Date),\"\")","v":"2024-01-24"}]
[]
["Table heading for Dynamic Milestone Data is in cells B14 through 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(Tasks!$C6,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET(Tasks!$D6,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET(Tasks!$C6,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET(Tasks!$B6,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 1"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET(Tasks!$B6,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2024-01-09"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND(Tasks!$C6<=$B$12,Tasks!$D6>=$B$12),ABS(OFFSET(Tasks!$C6,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET(Tasks!$F6,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(Tasks!$C7,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET(Tasks!$D7,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET(Tasks!$C7,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET(Tasks!$B7,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 2"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET(Tasks!$B7,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2024-01-10"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND(Tasks!$C7<=$B$12,Tasks!$D7>=$B$12),ABS(OFFSET(Tasks!$C7,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET(Tasks!$F7,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 trhrough 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 insruction is in cell A32.",{"$f":"IFERROR(IF(LEN(OFFSET(Tasks!$C8,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET(Tasks!$D8,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET(Tasks!$C8,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET(Tasks!$B8,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 3"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET(Tasks!$B8,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2024-01-10"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND(Tasks!$C8<=$B$12,Tasks!$D8>=$B$12),ABS(OFFSET(Tasks!$C8,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET(Tasks!$F8,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(Tasks!$C9,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET(Tasks!$D9,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET(Tasks!$C9,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET(Tasks!$B9,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 4"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET(Tasks!$B9,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2024-01-11"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND(Tasks!$C9<=$B$12,Tasks!$D9>=$B$12),ABS(OFFSET(Tasks!$C9,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET(Tasks!$F9,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(Milestones!D6)=0,\"\",IF(AND(Milestones!D6<=$B$12,Milestones!D6>=$B$11-$D$11),Milestones!E6,\"\")),\"\")","v":"Milestone 1"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D6),2)","v":"2024-01-19"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C6),\"\")","v":1}]
[null,{"$f":"IFERROR(IF(LEN(OFFSET(Tasks!$C10,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET(Tasks!$D10,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET(Tasks!$C10,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET(Tasks!$B10,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 5"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET(Tasks!$B10,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2024-01-18"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND(Tasks!$C10<=$B$12,Tasks!$D10>=$B$12),ABS(OFFSET(Tasks!$C10,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET(Tasks!$F10,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(Milestones!D7)=0,\"\",IF(AND(Milestones!D7<=$B$12,Milestones!D7>=$B$11-$D$11),Milestones!E7,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D7),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C7),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(LEN(OFFSET(Tasks!$C11,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET(Tasks!$D11,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET(Tasks!$C11,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET(Tasks!$B11,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 6"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET(Tasks!$B11,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2024-01-22"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND(Tasks!$C11<=$B$12,Tasks!$D11>=$B$12),ABS(OFFSET(Tasks!$C11,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET(Tasks!$F11,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(Milestones!D8)=0,\"\",IF(AND(Milestones!D8<=$B$12,Milestones!D8>=$B$11-$D$11),Milestones!E8,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D8),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C8),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(LEN(OFFSET(Tasks!$C12,ScrollingIncrement[scroll increment],0,1,1))=0,\"\",IF(OR(OFFSET(Tasks!$D12,ScrollingIncrement[scroll increment],0,1,1)<=$B$12,OFFSET(Tasks!$C12,ScrollingIncrement[scroll increment],0,1,1)>=($B$11-$D$11)),INDEX(Tasks[],OFFSET(Tasks!$B12,ScrollingIncrement[scroll increment],0,1,1),4),\"\")),\"\")","v":"Activity 7"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,$B$11,INDEX(Tasks[],OFFSET(Tasks!$B12,ScrollingIncrement[scroll increment],0,1,1),2)),\"\")","v":"2024-01-25"},{"$f":"IFERROR(IF(LEN(DynamicTaskData[[#This Row],[Tasks]])=0,0,IF(AND(Tasks!$C12<=$B$12,Tasks!$D12>=$B$12),ABS(OFFSET(Tasks!$C12,ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET(Tasks!$F12,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(Milestones!D9)=0,\"\",IF(AND(Milestones!D9<=$B$12,Milestones!D9>=$B$11-$D$11),Milestones!E9,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D9),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C9),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN(Milestones!D10)=0,\"\",IF(AND(Milestones!D10<=$B$12,Milestones!D10>=$B$11-$D$11),Milestones!E10,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D10),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C10),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN(Milestones!D11)=0,\"\",IF(AND(Milestones!D11<=$B$12,Milestones!D11>=$B$11-$D$11),Milestones!E11,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D11),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C11),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN(Milestones!D12)=0,\"\",IF(AND(Milestones!D12<=$B$12,Milestones!D12>=$B$11-$D$11),Milestones!E12,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D12),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C12),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN(Milestones!D13)=0,\"\",IF(AND(Milestones!D13<=$B$12,Milestones!D13>=$B$11-$D$11),Milestones!E13,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D13),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C13),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN(Milestones!D14)=0,\"\",IF(AND(Milestones!D14<=$B$12,Milestones!D14>=$B$11-$D$11),Milestones!E14,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D14),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C14),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN(Milestones!D15)=0,\"\",IF(AND(Milestones!D15<=$B$12,Milestones!D15>=$B$11-$D$11),Milestones!E15,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D15),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C15),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN(Milestones!D16)=0,\"\",IF(AND(Milestones!D16<=$B$12,Milestones!D16>=$B$11-$D$11),Milestones!E16,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D16),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C16),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN(Milestones!D17)=0,\"\",IF(AND(Milestones!D17<=$B$12,Milestones!D17>=$B$11-$D$11),Milestones!E17,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D17),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C17),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN(Milestones!D18)=0,\"\",IF(AND(Milestones!D18<=$B$12,Milestones!D18>=$B$11-$D$11),Milestones!E18,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D18),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C18),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(LEN(Milestones!D19)=0,\"\",IF(AND(Milestones!D19<=$B$12,Milestones!D19>=$B$11-$D$11),Milestones!E19,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D19),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$C19),\"\")","v":""}]
["A note is in cell J32.\nThis is the last instruction in this worksheet.",{"$nulls":5},{"$f":"IFERROR(IF(LEN(Milestones!D20)=0,\"\",IF(AND(Milestones!D20<=$B$12,Milestones!D20>=$B$11-$D$11),Milestones!E20,\"\")),\"\")","v":""},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,$B$12,Milestones!$D20),2)","v":"2024-01-24"},{"$f":"IFERROR(IF(LEN(DynamicMilestoneData[[#This Row],[Milestones]])=0,\"\",Milestones!$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"]