{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Chart data","Infographic Timeline","About","Chart data hidden"],"read":"whole","date_system":"1900"}

{"sheet":"Chart data","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"merged":[[1,1,1,2]]}
["Create an infographic timeline by entering important milestones and activities 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.","Infographic Chart Data"]
["Select how to show dates in the chart  by selecting “Year” or “Day Month” in the drop-down list in cell D2.","Chart Milestones by Year, Day Month, or leave blank. Select an option on the right:",null,"Day Month"]
["Headings for the table Chart Data is in cells B3 through D3.","Date","Milestone title","Description or Activity"]
["Enter a milestone dates in cells B4 to B8. \nEnter milestone title in cells C4 to C8.\nEnter milestone description or activity in cells D4 to D8.\nThis is the last instruction in this worksheet.",{"$f":"TODAY()","v":"2018-06-27"},"Set benchmarks","Enter the description that describes what needs to be done during this phase. It can be an elaborate description of text or a list of activities."]
[null,{"$f":"B4+30","v":"2018-07-27"},"Run tests","This sample text is a list of tests to be done during this phase.\nTest 1\nTest 2\nTest 3"]
[null,{"$f":"B5+60","v":"2018-09-25"},"Review stats","Be creative with your own ideas and start creating your own infographic outline."]
[null,{"$f":"B6+90","v":"2018-12-24"},"Make changes","activity 1\nactivity 2\nactivity 3"]
[null,{"$f":"B7+120","v":"2019-04-23"},"Launch","Celebrate!"]
[]
[]
[null,{"$f":"TEXT(B4,\"mmm\")","v":"Jun"}]

{"sheet":"Infographic Timeline","index":1,"n_rows":1,"n_cols":1,"rows_kept":1}
["An Infographic Timeline is in this worksheet starting in cell B1. \n5 teardrop shapes with milestone titles above them and milestone dates within them are mapped along a curved line that charts the year from start to end. \nNext to each teardrop is a description or list of activities for each milestone or informational marker. \nTo modify the content in this worksheet, update the Chart Data table in the Chart Data worksheet.\nThere are no further instructions in this worksheet."]

{"sheet":"About","index":2,"n_rows":7,"n_cols":1,"rows_kept":7}
["About this workbook"]
["Guide for screen readers"]
["There are 4 worksheets in this workbook. \n\nInfographic Timeline\nChart data\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"]
["Helpful information"]
["This Infographic Timeline charts 5 significant milestones and their activities or descriptions on a timeline. To modify or add timelines, simply update the table in the Chart data worksheet. \n"]
["You can chart information by year or by day month values, or create a blank space to place an icon or text box. Simply select the method you want in Chart data worksheet cell D2.\n"]
["This is the last instruction in this worksheet."]

{"sheet":"Chart data hidden","index":3,"n_rows":7,"n_cols":5,"rows_kept":7,"hidden":true}
["Data in this worksheet is used for charting the date in day month format and for charting the year along the roadmap within the Infographic Timeline.\nDo not delete this worksheet. Modifying or deleting data will affect the integrity of the chart in the Infographic Timeline worksheet.","Chart data (Hidden) – Do NOT delete this worksheet"]
["Table headers are in cells B2 and D2.","Date",null,"Year"]
["The first date from the Chart data worksheet is in cell B3 and subsequent cells in that column.\nThe year in cell D3 represents the starting position year of the timeline.",{"$f":"IFERROR(IF(LEN('Chart data'!B4)=0,\"\",IF('Chart data'!$D$2=\"Year\",YEAR('Chart data'!B4),IF('Chart data'!$D$2=\"Blank\",\"\",DAY('Chart data'!B4)&\" \"&TEXT('Chart data'!B4,\"mmm\")))),\"\")","v":"27 Jun"},null,{"$f":"IFERROR(IF(LEN('Chart data'!B4)=0,\"\",YEAR('Chart data'!B4)),\"\")","v":2018},"<-- year for the starting position of the roadmap"]
["The year in cell D4 represents the middle position year of the timeline.",{"$f":"IFERROR(IF(LEN('Chart data'!B5)=0,\"\",IF('Chart data'!$D$2=\"Year\",YEAR('Chart data'!B5),IF('Chart data'!$D$2=\"Blank\",\"\",DAY('Chart data'!B5)&\" \"&TEXT('Chart data'!B5,\"mmm\")))),\"\")","v":"27 Jul"},null,{"$f":"IFERROR(IF(LEN('Chart data'!B4)=0,\"\",IF(YEAR('Chart data'!$B$6)=$D$3,$D$3,YEAR('Chart data'!$B$6))),\"\")","v":2018},"<-- 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"]
["The year in cell D5 represents the last position year of the timeline.\nThis is the last instruction in this worksheet.",{"$f":"IFERROR(IF(LEN('Chart data'!B6)=0,\"\",IF('Chart data'!$D$2=\"Year\",YEAR('Chart data'!B6),IF('Chart data'!$D$2=\"Blank\",\"\",DAY('Chart data'!B6)&\" \"&TEXT('Chart data'!B6,\"mmm\")))),\"\")","v":"25 Sep"},null,{"$f":"IFERROR(IF(LEN('Chart data'!B4)=0,\"\",IF(YEAR('Chart data'!$B$8)=$D$3,\"\",YEAR('Chart data'!$B$8))),\"\")","v":2019},"<-- 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"]
[null,{"$f":"IFERROR(IF(LEN('Chart data'!B7)=0,\"\",IF('Chart data'!$D$2=\"Year\",YEAR('Chart data'!B7),IF('Chart data'!$D$2=\"Blank\",\"\",DAY('Chart data'!B7)&\" \"&TEXT('Chart data'!B7,\"mmm\")))),\"\")","v":"24 Dec"}]
[null,{"$f":"IFERROR(IF(LEN('Chart data'!B8)=0,\"\",IF('Chart data'!$D$2=\"Year\",YEAR('Chart data'!B8),IF('Chart data'!$D$2=\"Blank\",\"\",DAY('Chart data'!B8)&\" \"&TEXT('Chart data'!B8,\"mmm\")))),\"\")","v":"23 Apr"}]