{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["To-do-list","Chart data","How to use this template"],"not_rendered":{"charts":1,"images":5,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"To-do-list","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"merged":[[0,1,0,5],[2,7,11,7]]}
[null,{"$f":"CONCATENATE(\"To-Do List for \", 'How to use this template'!D3)","v":"To-Do List for Name"},{"$nulls":5},"Summary"]
[{"$nulls":6},"Items due:"]
[null,"Project","Description","Due Date","Priority","Status",null,"Bar chart showing number of tasks due for today, tomorrow and this week."]
[null,"Learn Excel","Learn Excel Tables",{"$f":"TODAY()","v":"2018-06-07"},"High","Pending","Clustered bar chart depicting pending items and due time is in this cell."]
[null,"Learn Excel","Learn Excel Sparklines",{"$f":"TODAY()+1","v":"2018-06-08"},"High","Pending"]
[null,"Learn Excel","Learn Excel Conditional Formatting",{"$f":"TODAY()+1","v":"2018-06-08"},"High","Pending"]

{"sheet":"Chart data","index":1,"n_rows":3,"n_cols":3,"rows_kept":3,"hidden":true,"merged":[[0,0,0,2]]}
["Chart data: Do not delete the rows below"]
["This week","Tomorrow","Today"]
[{"$f":"SUM(IF(Todolist[Due Date]>=(TODAY()-WEEKDAY(TODAY(),2)+1),IF(Todolist[Due Date]<(TODAY()-WEEKDAY(TODAY(),2)+1+7),1,0),0))","v":3},{"$f":"COUNTIF(Todolist[Due Date],TODAY()+1)","v":2},{"$f":"COUNTIF(Todolist[Due Date],TODAY())","v":1}]

{"sheet":"How to use this template","index":2,"n_rows":9,"n_cols":4,"rows_kept":9}
[]
[null,null,"Follow the steps below to work with your to do list:"]
[null,"1)","To personalise your to-do list, enter a name in the cell on the right:","Name"]
[null,"2)","On the To-do list sheet, in the Excel table, enter project details for each of your projects."]
[null,"3)","In the Priority and Status columns, you can use the arrow to select from predefined entries."]
[null,"4)","To add a new row at the end of the table, select the last cell in the last row, and then press TAB.\nTip:\nYou can also start typing in the first cell of the row below the table."]
[null,"5)","To insert a row in the table, hold down Shift and press F10 on the row that you want to insert a row above. Now, select Insert, and then select Table rows above.\nTip:\nYou can also insert a new column this way, but you’ll have to make adjustments to the line border for a proper fit. You can drag the lines to the location you want."]
[null,"6)","If the dates you enter fall on the current day, the next day or within the same week, the entries will be shown in the chart."]
[null,null,"Note: \nThe row and column headings are not displayed on the To-do list sheet. If column widths need to be adjusted, you can temporarily display the headings (View tab, Show group, Headings checkbox). "]