{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Shopping List","Budget Breakdown","To Do List","Share List"],"not_rendered":{"charts":2,"images":2,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Shopping List","index":0,"n_rows":25,"n_cols":8,"rows_kept":25,"merged":[[2,1,2,7],[3,1,3,2],[4,4,6,7]]}
[null,"Back To School","Planner"]
[]
[null,"Track your shopping progress against the budget category amounts entered in Budget Breakdown."]
[null,"Budget Summary",null,null,{"$f":"\"Purchasing Progress (\"&COUNTIFS(Checklist[Bought], \">0\")&\" of \"&COUNTIFS(Checklist[To Buy], \">0\")&\")\"","v":"Purchasing Progress (1 of 6)"}]
[null,"Budget",{"v":1500,"d":"£1,500.00"},null,{"$f":"IFERROR(COUNTIFS(Checklist[To Buy],\">0\",Checklist[Bought],\">0\")/SumItemsToBuy,0)","v":{"v":0.16666666666666666,"d":"17%"}}]
[null,"Shopping List Total",{"$f":"IFERROR(SUM(ChecklistTotal), \"\")","v":{"v":365,"d":"£365.00"}}]
[null,"Remaining Cash",{"$f":"IFERROR(C5-C6, \"\")","v":{"v":1135,"d":"£1,135.00"}}]
[null,"Shopping List"]
[null,"Item","Category","Qty","To Buy","Cost","Bought","Total Cost"]
[null,"Maths","Text Books",{"v":1,"d":"1 "},1,{"v":55,"d":"£55.00"},1,{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":{"v":55,"d":"£55.00"}}]
[null,"English","Text Books",{"v":1,"d":"1 "},1,null,null,{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]
[null,"Backpack","Supplies",{"v":1,"d":"1 "},null,{"v":30,"d":"£30.00"},null,{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":{"v":30,"d":"£30.00"}}]
[null,"Calculator","Supplies",{"v":1,"d":"1 "},{"$nulls":3},{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]
[null,"Highlighters","Supplies",{"v":3,"d":"3 "},{"$nulls":3},{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]
[null,"Uniform","Clothes",{"v":2,"d":"2 "},1,{"v":100,"d":"£100.00"},null,{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":{"v":200,"d":"£200.00"}}]
[null,"Shirts","Clothes",{"v":4,"d":"4 "},{"$nulls":3},{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]
[null,"T-shirts","Clothes",{"v":5,"d":"5 "},{"$nulls":3},{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]
[null,"Shorts","Clothes",{"v":2,"d":"2 "},{"$nulls":3},{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]
[null,"Trainers","Clothes",{"v":2,"d":"2 "},1,null,null,{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]
[null,"Socks","Clothes",{"v":10,"d":"10 "},{"$nulls":3},{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]
[null,"Spring jacket","Clothes",{"v":1,"d":"1 "},1,{"v":80,"d":"£80.00"},null,{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":{"v":80,"d":"£80.00"}}]
[null,"Jumpers","Clothes",{"v":1,"d":"1 "},{"$nulls":3},{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]
[null,"Sweatshirts","Clothes",{"v":1,"d":"1 "},{"$nulls":3},{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]
[null,"Underwear","Clothes",{"v":10,"d":"10 "},{"$nulls":3},{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]
[null,"Winter jacket","Clothes",{"v":1,"d":"1 "},1,null,null,{"$f":"IFERROR(Checklist[Qty]*Checklist[Cost], \"\")","v":0}]

{"sheet":"Budget Breakdown","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,"Budget Breakdown"]
[null,"Add categories and budget amounts to track against in your Shopping List."]
[null,"Category","Total Cost"]
[null,"Clothes",{"$f":"IFERROR(SUMIFS(Checklist[Total Cost],Checklist[Category],Category[Category]), \"\")","v":{"v":280,"d":"£280.00"}}]
[null,"Supplies",{"$f":"IFERROR(SUMIFS(Checklist[Total Cost],Checklist[Category],Category[Category]), \"\")","v":{"v":30,"d":"£30.00"}}]
[null,"Text Books",{"$f":"IFERROR(SUMIFS(Checklist[Total Cost],Checklist[Category],Category[Category]), \"\")","v":{"v":55,"d":"£55.00"}}]

{"sheet":"To Do List","index":2,"n_rows":22,"n_cols":3,"rows_kept":22}
[null,"To Do List"]
[null,"Track all the activities you need to get done before school starts."]
[null,"Done","Task"]
[null,"x","Complete all registration forms"]
[null,null,"Schedule school physical examination and sight test if needed"]
[null,null,"Verify all required immunisations"]
[null,null,"Obtain note with dosage instructions for all required medications from doctor"]
[null,null,"Review school dress code"]
[null,null,"Obtain a list of school supplies"]
[null,null,"Meet the teacher"]
[null,null,"Determine teacher's preferred communication method (phone, email, written note)"]
[null,null,"Tour the school with your child"]
[null,null,"Help your child memorise your home and work phone numbers and home address"]
[null,null,"Arrange transport, designate a safe meeting spot and practise the routine"]
[null,null,"If walking, practise the route to and from school with your child a few times"]
[null,null,"If car-sharing, introduce your child to all of the drivers"]
[null,null,"If going by bus, determine times and bus stops"]
[null,null,"Arrange for child care / after-school care"]
[null,null,"Plan a menu for breakfasts, school snacks, packed lunches and after-school snacks"]
[null,null,"Determine homework location and schedule"]
[null,null,"Establish a bedtime routine at least two weeks before school starts"]
[null,null,"Prepare a calendar of all school events and activities"]

{"sheet":"Share List","index":3,"n_rows":4,"n_cols":5,"rows_kept":4}
[null,"Share List",null,null,"Share this list with others so they can contribute. Select Share in the top right or press ALT then YU. Save the file to OneDrive and send the link to your friends."]
[null,"Name","Email Address","Shared?"]
[null,"Person 1","someone@email.com","Yes"]
[null,"Person 2","someone@email.com","No"]