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

{"sheet":"Project Tracker","index":0,"n_rows":22,"n_cols":7,"rows_kept":22}
["Create a Project Tracker 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.","Project Tracker"]
["The Start date can be manually input in cell D2, or use the template's sample formula to find the smallest date in the milestone column from the milestone table below.",null,"Start date:",{"$f":"IFERROR(IF(MIN(Milestones[Start Date])=0,TODAY(),MIN(Milestones[Start Date])),TODAY())","v":"2021-11-13"}]
["The End date can be manually input in cell D3, or use the template's sample formula to find the largest date in the milestone column from the milestone table below.",null,"End date:",{"$f":"IFERROR(IF(MAX(Milestones[End Date])=0,TODAY(),MAX(Milestones[End Date])),TODAY())","v":"2022-06-11"}]
["Information about the milestone table columns is in cells B4 through G4.","Enter a sequential set of numbers in the column below.","Enter the start date for the milestone or activity in the column below.","Enter the end date for the milestone or activity in the column below","Enter the milestone and/or activity description in the column below. This description will appear in the Project Chart.","Auto calculated. The data below, under this column, is used for charting the milestones and activities.","Auto calculated. Duration of each task "]
["Table headings are in cells B5 through G5. \nThere are two hidden columns: The Start on day and Task Duration columns  in cells F5 and G5 are auto calculated and used for creating the Gantt Chart in the Gantt Chart worksheet. \nSample data is in cells B6 through E21. \nThe next instruction is in cell A22.","Position","Start Date","End Date","Milestone/Activity","Start on Day","Task Duration"]
[null,1,{"$f":"TODAY()-10","v":"2021-12-03"},{"$f":"Milestones[[#This Row],[Start Date]]+10","v":"2021-12-13"},"Start",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C6)-INT($C$6)),\"\")","v":{"v":0,"d":"0 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":11,"d":"11 "}}]
[null,2,{"$f":"TODAY()+5","v":"2021-12-18"},{"$f":"Milestones[[#This Row],[Start Date]]+15","v":"2022-01-02"},{"$f":"\"Activity\"&\" \"&ROW($A2)","v":"Activity 2"},{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C7)-INT($C$6)),\"\")","v":{"v":15,"d":"15 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":16,"d":"16 "}}]
[null,3,{"$f":"TODAY()-30","v":"2021-11-13"},{"$f":"Milestones[[#This Row],[Start Date]]+152","v":"2022-04-14"},{"$f":"\"Activity\"&\" \"&ROW($A3)","v":"Activity 3"},{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C8)-INT($C$6)),\"\")","v":{"v":-20,"d":"(20)"}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":153,"d":"153 "}}]
[null,4,{"$f":"TODAY()+2","v":"2021-12-15"},{"$f":"Milestones[[#This Row],[Start Date]]+150","v":"2022-05-14"},"Activity 4",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C9)-INT($C$6)),\"\")","v":{"v":12,"d":"12 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":151,"d":"151 "}}]
[null,5,{"$f":"TODAY()+15","v":"2021-12-28"},{"$f":"Milestones[[#This Row],[Start Date]]+14","v":"2022-01-11"},"Activity 5",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C10)-INT($C$6)),\"\")","v":{"v":25,"d":"25 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":15,"d":"15 "}}]
[null,6,{"$f":"TODAY()+30","v":"2022-01-12"},{"$f":"Milestones[[#This Row],[Start Date]]+45","v":"2022-02-26"},"Activity 6",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C11)-INT($C$6)),\"\")","v":{"v":40,"d":"40 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":46,"d":"46 "}}]
[null,7,{"$f":"TODAY()+45","v":"2022-01-27"},{"$f":"Milestones[[#This Row],[Start Date]]+56","v":"2022-03-24"},"Activity 7",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C12)-INT($C$6)),\"\")","v":{"v":55,"d":"55 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":57,"d":"57 "}}]
[null,8,{"$f":"TODAY()+60","v":"2022-02-11"},{"$f":"Milestones[[#This Row],[Start Date]]+30","v":"2022-03-13"},"Activity 8",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C13)-INT($C$6)),\"\")","v":{"v":70,"d":"70 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":31,"d":"31 "}}]
[null,9,{"$f":"TODAY()+37","v":"2022-01-19"},{"$f":"Milestones[[#This Row],[Start Date]]+22","v":"2022-02-10"},"Activity 9",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C14)-INT($C$6)),\"\")","v":{"v":47,"d":"47 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":23,"d":"23 "}}]
[null,10,{"$f":"TODAY()-20","v":"2021-11-23"},{"$f":"Milestones[[#This Row],[Start Date]]+160","v":"2022-05-02"},"Activity 10",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C15)-INT($C$6)),\"\")","v":{"v":-10,"d":"(10)"}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":161,"d":"161 "}}]
[null,11,{"$f":"TODAY()+20","v":"2022-01-02"},{"$f":"Milestones[[#This Row],[Start Date]]+65","v":"2022-03-08"},"Activity 11",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C16)-INT($C$6)),\"\")","v":{"v":30,"d":"30 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":66,"d":"66 "}}]
[null,12,{"$f":"TODAY()+70","v":"2022-02-21"},{"$f":"Milestones[[#This Row],[Start Date]]+67","v":"2022-04-29"},"Activity 12",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C17)-INT($C$6)),\"\")","v":{"v":80,"d":"80 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":68,"d":"68 "}}]
[null,13,{"$f":"TODAY()+90","v":"2022-03-13"},{"$f":"Milestones[[#This Row],[Start Date]]+14","v":"2022-03-27"},"Activity 13",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C18)-INT($C$6)),\"\")","v":{"v":100,"d":"100 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":15,"d":"15 "}}]
[null,14,{"$f":"TODAY()+100","v":"2022-03-23"},{"$f":"Milestones[[#This Row],[Start Date]]+3","v":"2022-03-26"},"Activity 14",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C19)-INT($C$6)),\"\")","v":{"v":110,"d":"110 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":4,"d":"4 "}}]
[null,15,{"$f":"TODAY()+50","v":"2022-02-01"},{"$f":"Milestones[[#This Row],[Start Date]]+130","v":"2022-06-11"},"Activity 15",{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C20)-INT($C$6)),\"\")","v":{"v":60,"d":"60 "}},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":{"v":131,"d":"131 "}}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(LEN(Milestones[[#This Row],[Start Date]])=0,LEN(Milestones[[#This Row],[End Date]])=0),\"\",INT(C21)-INT($C$6)),\"\")","v":""},{"$f":"IFERROR(IF(Milestones[[#This Row],[Start on Day]]=0,DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1,IF(LEN(Milestones[[#This Row],[Start on Day]])=0,\"\",DATEDIF(Milestones[[#This Row],[Start Date]],Milestones[[#This Row],[End Date]],\"d\")+1)),0)","v":""}]
["To add more milestones/activities, insert new rows above this line.\nThis is the last instruction in this worksheet.","To add more  Milestones/Activities, insert new rows above this line"]

{"sheet":"Project Chart","index":1,"n_rows":1,"n_cols":1,"rows_kept":1}
["Gantt chart with a scrollbar is in this worksheet. \nScrollbar starts in cell B29.\nThis is the last instruction in this worksheet."]

{"sheet":"About","index":2,"n_rows":6,"n_cols":1,"rows_kept":6}
["About this workbook"]
["\nEnter your data in the Project Tracker worksheet, then scroll through a visual representation of your timeline in the Project Chart worksheet. \n"]
["The position column in the Project Tracker worksheet, allows you to chart milestones and activities on separate lines. You could, for instance have two milestones/activities that start on the same day and run in parallel. They would overlap in the chart if they had the same position value. Provide two unique values to chart on separate lines. Try it!\n\nAs the chart concludes, you may notice markers with no text and no duration set at a specific timeline. As the last milestone scrolls off the chart these markers indicate the end of the milestones in the Project Tracker to chart. Simple scroll back or to the beginning to see the chartable milestones.\n"]
["Guide for screen readers"]
["There are 4 worksheets in this workbook. \n\nProject Tracker\nProject Chart\nAbout\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.\n\nTo remove these instructions from any worksheet, simply delete column A.\n"]
["This is the last instruction in this worksheet."]

{"sheet":"Dynamic Chart Data Hidden","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"hidden":true}
["Title of this worksheet is in cell B1.","Dynamic Chart Data"]
["Horizontal scrolling increment heading is in cell B2.\nTo manually increment the data, enter a new value in cell B3.\nThe scrolling page auto updates when the scrollbar is paged forward or backwards in the Gantt Chart worksheet.","horizontal scrolling increment"]
["Auto updated Gantt Chart scrolling value is in cell B3.",0]
["Table title is in cell B4.","Dynamic Data Table"]
["Table headings are in cells B5 through E5. \nA note is in cell F5.\nThis table will chart up to 5 milestones at one time. \nDo not modify or delete this worksheet or its contents.","milestone","date","Start on Day","duration","<--chart up to 5 milestones at a time"]
[null,{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$E6,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B6+$B$3,4)),\"\")","v":"Start"},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$C6,$B$3,0,1,1))=0,End_Date,INDEX(Milestones[],'Project Tracker'!$B6+$B$3,2)),\"\")","v":"2021-12-03"},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$F6,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B6+$B$3,5)),\"\")","v":0},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$G6,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B6+$B$3,6)),\"\")","v":11}]
[null,{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$E7,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B7+$B$3,4)),\"\")","v":"Activity 2"},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$C7,$B$3,0,1,1))=0,End_Date,INDEX(Milestones[],'Project Tracker'!$B7+$B$3,2)),\"\")","v":"2021-12-18"},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$F7,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B7+$B$3,5)),\"\")","v":15},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$G7,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B7+$B$3,6)),\"\")","v":16}]
[null,{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$E8,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B8+$B$3,4)),\"\")","v":"Activity 3"},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$C8,$B$3,0,1,1))=0,End_Date,INDEX(Milestones[],'Project Tracker'!$B8+$B$3,2)),\"\")","v":"2021-11-13"},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$F8,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B8+$B$3,5)),\"\")","v":-20},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$G8,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B8+$B$3,6)),\"\")","v":153}]
[null,{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$E9,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B9+$B$3,4)),\"\")","v":"Activity 4"},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$C9,$B$3,0,1,1))=0,End_Date,INDEX(Milestones[],'Project Tracker'!$B9+$B$3,2)),\"\")","v":"2021-12-15"},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$F9,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B9+$B$3,5)),\"\")","v":12},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$G9,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B9+$B$3,6)),\"\")","v":151}]
[null,{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$E10,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B10+$B$3,4)),\"\")","v":"Activity 5"},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$C10,$B$3,0,1,1))=0,End_Date,INDEX(Milestones[],'Project Tracker'!$B10+$B$3,2)),\"\")","v":"2021-12-28"},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$F10,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B10+$B$3,5)),\"\")","v":25},{"$f":"IFERROR(IF(LEN(OFFSET('Project Tracker'!$G10,$B$3,0,1,1))=0,\"\",INDEX(Milestones[],'Project Tracker'!$B10+$B$3,6)),\"\")","v":15}]