{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Teacher’s List"," List Data"],"not_rendered":{"external_links":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Teacher’s List","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[0,1,0,2],[0,4,0,8],[2,9,6,9]]}
[null,"Teacher’s List",null,"List Data","Colour Legend for Status is in this cell: Not started is normal style, In Progress is R=91 G=133 B=49, Due Today is R=118 G=88 B=0, On Hold is R=109 G=66 B=111, Completed is Strikethrough, Cancelled is R=191 G=191 B=191 and Overdue is R=191 G=33 B=28."]
[null,"ITEM","CATEGORY","START DATE","DUE DATE","DAYS REMAINING","STATUS","NOTES"]
[null,"Clean drawers","Office",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,6)","v":"2018-04-06"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,16)","v":"2018-04-16"},{"$f":"IFERROR(IF(COUNT(List[[#This Row],[START DATE]]:List[[#This Row],[DUE DATE]])<>2,\"\",IF(OR(List[[#This Row],[STATUS]]=\"Completed\",List[[#This Row],[STATUS]]=\"Cancelled\",List[[#This Row],[STATUS]]=\"On Hold\"),\"\",List[[#This Row],[DUE DATE]]-TODAY())),\"\")","v":""},"Completed",null,null,"Status slicer is in this cell. To filter list by Status, select a status from the slicer. Press and hold CTRL to select multiple options."]
[null,"Order stickers","Supplies",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,11)","v":"2018-04-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"IFERROR(IF(COUNT(List[[#This Row],[START DATE]]:List[[#This Row],[DUE DATE]])<>2,\"\",IF(OR(List[[#This Row],[STATUS]]=\"Completed\",List[[#This Row],[STATUS]]=\"Cancelled\",List[[#This Row],[STATUS]]=\"On Hold\"),\"\",List[[#This Row],[DUE DATE]]-TODAY())),\"\")","v":""},"Completed"]
[null,"Floors mopped and waxed","Other",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()-1),DAY(TODAY())-25)","v":"2018-04-15"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"IFERROR(IF(COUNT(List[[#This Row],[START DATE]]:List[[#This Row],[DUE DATE]])<>2,\"\",IF(OR(List[[#This Row],[STATUS]]=\"Completed\",List[[#This Row],[STATUS]]=\"Cancelled\",List[[#This Row],[STATUS]]=\"On Hold\"),\"\",List[[#This Row],[DUE DATE]]-TODAY())),\"\")","v":""},"Completed"]
[null,"Name labels created","Supplies",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,1)","v":"2018-04-01"},{"$f":"IFERROR(IF(COUNT(List[[#This Row],[START DATE]]:List[[#This Row],[DUE DATE]])<>2,\"\",IF(OR(List[[#This Row],[STATUS]]=\"Completed\",List[[#This Row],[STATUS]]=\"Cancelled\",List[[#This Row],[STATUS]]=\"On Hold\"),\"\",List[[#This Row],[DUE DATE]]-TODAY())),\"\")","v":""},"On Hold"]
[null,"Mark half-term’s projects","Assessments",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"TODAY()-5","v":"2018-05-05"},{"$f":"IFERROR(IF(COUNT(List[[#This Row],[START DATE]]:List[[#This Row],[DUE DATE]])<>2,\"\",IF(OR(List[[#This Row],[STATUS]]=\"Completed\",List[[#This Row],[STATUS]]=\"Cancelled\",List[[#This Row],[STATUS]]=\"On Hold\"),\"\",List[[#This Row],[DUE DATE]]-TODAY())),\"\")","v":-5},"Overdue"]
[null,"Email Reminder for Permission Slips","Phone calls",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2018-05-01"},{"$f":"TODAY()","v":"2018-05-10"},{"$f":"IFERROR(IF(COUNT(List[[#This Row],[START DATE]]:List[[#This Row],[DUE DATE]])<>2,\"\",IF(OR(List[[#This Row],[STATUS]]=\"Completed\",List[[#This Row],[STATUS]]=\"Cancelled\",List[[#This Row],[STATUS]]=\"On Hold\"),\"\",List[[#This Row],[DUE DATE]]-TODAY())),\"\")","v":""},"Cancelled"]
[null,"Mark oral presentations","Office",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),7)","v":"2018-05-07"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),17)","v":"2018-05-17"},{"$f":"IFERROR(IF(COUNT(List[[#This Row],[START DATE]]:List[[#This Row],[DUE DATE]])<>2,\"\",IF(OR(List[[#This Row],[STATUS]]=\"Completed\",List[[#This Row],[STATUS]]=\"Cancelled\",List[[#This Row],[STATUS]]=\"On Hold\"),\"\",List[[#This Row],[DUE DATE]]-TODAY())),\"\")","v":7},"In Progress"]
[null,"Sharpen pencils","Supplies",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),11)","v":"2018-05-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),10)","v":"2018-05-10"},{"$f":"IFERROR(IF(COUNT(List[[#This Row],[START DATE]]:List[[#This Row],[DUE DATE]])<>2,\"\",IF(OR(List[[#This Row],[STATUS]]=\"Completed\",List[[#This Row],[STATUS]]=\"Cancelled\",List[[#This Row],[STATUS]]=\"On Hold\"),\"\",List[[#This Row],[DUE DATE]]-TODAY())),\"\")","v":0},"In Progress"]

{"sheet":" List Data","index":1,"n_rows":13,"n_cols":3,"rows_kept":13}
[null,"List Data","Teacher’s List"]
[null,"Category"]
[null,"Office"]
[null,"Supplies"]
[null,"Things to buy"]
[null,"Phone calls"]
[null,"New ideas"]
[null,"Assessments"]
[null,"Team"]
[null,"Interventions"]
[null,"Computer"]
[null,"Personal"]
[null,"Other"]