{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["About","Milestones","Roadmap","Chart data"],"not_rendered":{"charts":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"About","index":0,"n_rows":5,"n_cols":1,"rows_kept":5}
["About this workbook"]
["Guide for screen readers"]
["There are 4 worksheets in this workbook. \n\nMilestones\nRoadmap\nAbout\nChart 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 roadmap uses positions to chart  milestones and activites. Positions can be used to add weight to a milestone or activity. Simply adjust the values according to your weight preference. For example, milestone/activity 3 might have more weight than milestone/activity 2. To indicate this on the chart, simply make the Position value higher for milestone/activity 3 than for milestone/activity 2.  \n"]
["This is the last instruction in this worksheet."]

{"sheet":"Milestones","index":1,"n_rows":27,"n_cols":5,"rows_kept":27}
["Create a Roadmap by entering important milestones and activities in this worksheet.\nThe title of this worksheet is in cell C1. \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.",null,"Milestones"]
["Table headings are in cells C2 through E2. Use Sort & Filter options to sort or find specific entries.\nEnter Milestones with dates and set a position for charting the milestone, in the table starting in cell C3.\nColumn B has been hidden. The chart generated from this data using a scrollbar to view chuncks of the timeline. Column B helps determine which Milestones to chart when the scrollbar is incremented. \nWarning: Deleting or modifying column B contents may disrupt the integrity of the charting built into this workbook.","No.","Position","Date","Milestone"]
["Enter the Position for charting the date and milestone in cell C1. Enter a positive number between 1 and 3 to chart the milestone above the timeline. Enter a negative number between 1 and 3 to chart the milestone below the timeline.\nEnter the Date and Milestone or activity in column D and E within the table.\nRepeat this pattern for each new row in the table at right.\nSample data is provided in rows 3 through 26. Modify or delete sample content to create your own roadmap.\nContinue to cell A27 for the next instruction.",{"$f":"ROW($A1)","v":1},1,{"$f":"TODAY()","v":"2019-07-07"},"Start"]
[null,{"$f":"ROW($A2)","v":2},-2,{"$f":"D3+10","v":"2019-07-17"},"Problem Analysis\nactivity 1"]
[null,3,1,{"$f":"D4+20","v":"2019-08-06"},"Develop Business Case\nactivity 1\nactivity 2"]
[null,4,-1,{"$f":"D5+30","v":"2019-09-05"},"Review Presentation"]
[null,5,{"v":-0.5,"d":"-1"},{"$f":"D6+40","v":"2019-10-15"},"Exec Kickoff\nactivity 1\nactivity 2"]
[null,6,2,{"$f":"D7+50","v":"2019-12-04"},"Exec Alignment\nactivity 1\nactivity 2\nactivity 3"]
[null,7,{"v":0.5,"d":"1"},{"$f":"D8+60","v":"2020-02-02"},"Stakeholder Buy In"]
[null,8,-1,{"$f":"D9+70","v":"2020-04-12"},"Resource Selection"]
[null,9,{"v":0.5,"d":"1"},{"$f":"D10+80","v":"2020-07-01"},"Team Creation\nactivity 1 "]
[null,10,-2,{"$f":"D11+90","v":"2020-09-29"},"Team Kickoff\nactivity 1 \nactivity 2\nactivity 3\nactivity 4"]
[null,11,3,{"$f":"D12+100","v":"2021-01-07"},"Start Data Collection"]
[null,12,-1,{"$f":"D13+90","v":"2021-04-07"},"Data Analysis"]
[null,13,1,{"$f":"D14+80","v":"2021-06-26"},"Design"]
[null,14,1,{"$f":"D15+70","v":"2021-09-04"},"Proof of Concept"]
[null,15,-3,{"$f":"D16+60","v":"2021-11-03"},"Test & Analysis"]
[null,16,-2,{"$f":"D17+50","v":"2021-12-23"},"Redesign"]
[null,17,2,{"$f":"D18+40","v":"2022-02-01"},"Redevelop"]
[null,18,-1,{"$f":"D19+30","v":"2022-03-03"},"Test & Analysis"]
[null,19,1,{"$f":"D20+20","v":"2022-03-23"},"Redesign"]
[null,20,-3,{"$f":"D21+10","v":"2022-04-02"},"Redevelop"]
[null,21,2,{"$f":"D22+20","v":"2022-04-22"},"Final Test"]
[null,22,1,{"$f":"D23+30","v":"2022-05-22"},"Beta Test"]
[null,23,-3,{"$f":"D24+40","v":"2022-07-01"},"Review"]
[null,24,-2,{"$f":"D25+50","v":"2022-08-20"},"Release to Marketing"]
["To add more rows to the Roadmap Milestones table, simply insert a new row above this one.\nThere are no further instructions in this worksheet.",null,"To add more milestones, insert new rows above this line."]

{"sheet":"Roadmap","index":2,"n_rows":3,"n_cols":4,"rows_kept":3}
["A chart displaying the milestones from Milestones worksheet is in this worksheet. \nYears are indicated in cells B2, C2, and D2 and have the style Heading 3 applied.\n10  milestones are charted at a time. \nUse the scroll bar in cells B4 through D4 to navigate through the roadmap.\nTimeline years are in cells B3 through D3.\nThere are no further instructions in this worksheet."]
[]
[null,{"$f":"'Chart data'!B20","v":2019},{"$f":"'Chart data'!B21","v":""},{"$f":"'Chart data'!B22","v":2020}]

{"sheet":"Chart data","index":3,"n_rows":26,"n_cols":4,"rows_kept":26,"hidden":true}
["Data for creating the dynamic charting is in this worksheet. Do not delete this worksheet!\nDeleting this worksheet could compromise the dynamic capability of the workbook.","Do not delete this worksheet!"]
["Title for the table is in cell B2.","Dynamic Chart content"]
["Table headings are in cells B3 through D3. \nThis table is auto updated based on the content entered in the Milestones worksheet.\nWarning: Modifying or deleting content in this table could compromise the dynamic update capability of the Roadmap chart in the Roadmap worksheet.\nContinue to cell A15 for the next instruction.","Date","Events","Position"]
[null,{"$f":"IFERROR(IF(LEN(Milestones!D3)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B3+$B$17,3)),\"\")","v":"2019-07-07"},{"$f":"IFERROR(IF(LEN(Milestones!E3)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B3+$B$17,4)),\"\")","v":"Start"},{"$f":"IFERROR(INDEX(RoadmapMilestones[],Milestones!$B3+$B$17,2),\"\")","v":1}]
[null,{"$f":"IFERROR(IF(LEN(Milestones!D4)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B4+$B$17,3)),\"\")","v":"2019-07-17"},{"$f":"IFERROR(IF(LEN(Milestones!E4)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B4+$B$17,4)),\"\")","v":"Problem Analysis\nactivity 1"},{"$f":"IFERROR(INDEX(RoadmapMilestones[],Milestones!$B4+$B$17,2),\"\")","v":-2}]
[null,{"$f":"IFERROR(IF(LEN(Milestones!D5)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B5+$B$17,3)),\"\")","v":"2019-08-06"},{"$f":"IFERROR(IF(LEN(Milestones!E5)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B5+$B$17,4)),\"\")","v":"Develop Business Case\nactivity 1\nactivity 2"},{"$f":"IFERROR(INDEX(RoadmapMilestones[],Milestones!$B5+$B$17,2),\"\")","v":1}]
[null,{"$f":"IFERROR(IF(LEN(Milestones!D6)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B6+$B$17,3)),\"\")","v":"2019-09-05"},{"$f":"IFERROR(IF(LEN(Milestones!E6)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B6+$B$17,4)),\"\")","v":"Review Presentation"},{"$f":"IFERROR(INDEX(RoadmapMilestones[],Milestones!$B6+$B$17,2),\"\")","v":-1}]
[null,{"$f":"IFERROR(IF(LEN(Milestones!D7)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B7+$B$17,3)),\"\")","v":"2019-10-15"},{"$f":"IFERROR(IF(LEN(Milestones!E7)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B7+$B$17,4)),\"\")","v":"Exec Kickoff\nactivity 1\nactivity 2"},{"$f":"IFERROR(INDEX(RoadmapMilestones[],Milestones!$B7+$B$17,2),\"\")","v":-0.5}]
[null,{"$f":"IFERROR(IF(LEN(Milestones!D8)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B8+$B$17,3)),\"\")","v":"2019-12-04"},{"$f":"IFERROR(IF(LEN(Milestones!E8)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B8+$B$17,4)),\"\")","v":"Exec Alignment\nactivity 1\nactivity 2\nactivity 3"},{"$f":"IFERROR(INDEX(RoadmapMilestones[],Milestones!$B8+$B$17,2),\"\")","v":2}]
[null,{"$f":"IFERROR(IF(LEN(Milestones!D9)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B9+$B$17,3)),\"\")","v":"2020-02-02"},{"$f":"IFERROR(IF(LEN(Milestones!E9)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B9+$B$17,4)),\"\")","v":"Stakeholder Buy In"},{"$f":"IFERROR(INDEX(RoadmapMilestones[],Milestones!$B9+$B$17,2),\"\")","v":0.5}]
[null,{"$f":"IFERROR(IF(LEN(Milestones!D10)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B10+$B$17,3)),\"\")","v":"2020-04-12"},{"$f":"IFERROR(IF(LEN(Milestones!E10)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B10+$B$17,4)),\"\")","v":"Resource Selection"},{"$f":"IFERROR(INDEX(RoadmapMilestones[],Milestones!$B10+$B$17,2),\"\")","v":-1}]
[null,{"$f":"IFERROR(IF(LEN(Milestones!D11)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B11+$B$17,3)),\"\")","v":"2020-07-01"},{"$f":"IFERROR(IF(LEN(Milestones!E11)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B11+$B$17,4)),\"\")","v":"Team Creation\nactivity 1 "},{"$f":"IFERROR(INDEX(RoadmapMilestones[],Milestones!$B11+$B$17,2),\"\")","v":0.5}]
[null,{"$f":"IFERROR(IF(LEN(Milestones!D12)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B12+$B$17,3)),\"\")","v":"2020-09-29"},{"$f":"IFERROR(IF(LEN(Milestones!E12)=0,\"\",INDEX(RoadmapMilestones[],Milestones!$B12+$B$17,4)),\"\")","v":"Team Kickoff\nactivity 1 \nactivity 2\nactivity 3\nactivity 4"},{"$f":"IFERROR(INDEX(RoadmapMilestones[],Milestones!$B12+$B$17,2),\"\")","v":-2}]
[]
["The ability to scroll through the roadmap is done with the help of an increment value. The title for this ability is in cell B15.\nA table with a header and a single value is in cells B16 and B17.\nContinue to cell A19 for the next instruction.","Scrolling capability"]
[null,"Row Increment"]
[null,0]
[]
["The Roadmap chart plots the years for the timeline. To do this, the years must be captured from the Milestone List. \nThe title for this section is \"Year\" in cell  B19. \nThe year values are auto generated in cells C20 through C22.\nWarning: Deleting or modifying these years could change the charting accuracy of the Roadmap chart.\nContinue to cell A24 for the next instruction.","Year"]
[null,{"$f":"IFERROR(YEAR(B4),\"\")","v":2019},"<-- year for the starting position of the roadmap"]
[null,{"$f":"IFERROR(IF(YEAR($B$9)=$B$20,\"\",YEAR($B$9)),\"\")","v":""},"<-- year for the middle period of the roadmap, note, this may be blank if it's the same year as the starting position of the roadmap"]
[null,{"$f":"IFERROR(IF(YEAR($B$13)=$B$20,\"\",YEAR($B$13)),\"\")","v":2020},"<-- year for the last position of the roadmap, note, this may be blank if it's the same year as the starting position of the roadmap"]
[]
["Donut markers in the Roadmap chart contain dates from the dynamic chart content in this worksheet. The dates are First date in cell C24, Middle date in cell C25, and last date in cell C26.\nThere are no further instructions in this worksheet.","First date",{"$f":"B4","v":"2019-07-07"}]
[null,"Middle date",{"$f":"B9","v":"2019-12-04"}]
[null,"Last date",{"$f":"B13","v":"2020-09-29"}]