{"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]]}
[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,"Math","Textbooks",{"v":1,"d":"1 "},1,{"v":55,"d":"$55.00"},1,{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":{"v":55,"d":"$55.00"}}]
[null,"English","Textbooks",{"v":1,"d":"1 "},1,null,null,{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":0}]
[null,"Backpack","Supplies",{"v":1,"d":"1 "},null,{"v":30,"d":"$30.00"},null,{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":{"v":30,"d":"$30.00"}}]
[null,"Calculator","Supplies",{"v":1,"d":"1 "},{"$nulls":3},{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":0}]
[null,"Highlighters","Supplies",{"v":3,"d":"3 "},{"$nulls":3},{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":0}]
[null,"Uniform","Clothes",{"v":2,"d":"2 "},1,{"v":100,"d":"$100.00"},null,{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":{"v":200,"d":"$200.00"}}]
[null,"Shirt, button-up","Clothes",{"v":4,"d":"4 "},{"$nulls":3},{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":0}]
[null,"Shirt, t-shirts","Clothes",{"v":5,"d":"5 "},{"$nulls":3},{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":0}]
[null,"Shorts","Clothes",{"v":2,"d":"2 "},{"$nulls":3},{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":0}]
[null,"Sneakers","Clothes",{"v":2,"d":"2 "},1,null,null,{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":0}]
[null,"Socks","Clothes",{"v":10,"d":"10 "},{"$nulls":3},{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":0}]
[null,"Spring jacket","Clothes",{"v":1,"d":"1 "},1,{"v":80,"d":"$80.00"},null,{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":{"v":80,"d":"$80.00"}}]
[null,"Sweaters","Clothes",{"v":1,"d":"1 "},{"$nulls":3},{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":0}]
[null,"Sweatshirts","Clothes",{"v":1,"d":"1 "},{"$nulls":3},{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":0}]
[null,"Underwear","Clothes",{"v":10,"d":"10 "},{"$nulls":3},{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[Cost]], \"\")","v":0}]
[null,"Winter jacket","Clothes",{"v":1,"d":"1 "},1,null,null,{"$f":"IFERROR(Checklist[[#This Row],[Qty]]*Checklist[[#This Row],[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[[#This Row],[Category]]), \"\")","v":{"v":280,"d":"$280.00"}}]
[null,"Supplies",{"$f":"IFERROR(SUMIFS(Checklist[Total cost],Checklist[Category],Category[[#This Row],[Category]]), \"\")","v":{"v":30,"d":"$30.00"}}]
[null,"Textbooks",{"$f":"IFERROR(SUMIFS(Checklist[Total cost],Checklist[Category],Category[[#This Row],[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 and visual exam if needed"]
[null,null,"Verify all required immunizations"]
[null,null,"Obtain note with dosage instructions for all required medications from physician"]
[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 memorize your home phone, work phone, and home address"]
[null,null,"Arrange transportation, designate a safe meeting spot, and practice the routine"]
[null,null,"If walking, practice the route to and from school with your child a few times"]
[null,null,"If carpooling, introduce your child to all carpool drivers"]
[null,null,"If riding the 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 upper right or press ALT and then press “Z” followed by “S”. Save the file to OneDrive and send the link to your friends."]
[null,"Name","Email","Shared?"]
[null,"Nikola Janu","nikola@example.com","Yes"]
[null,"Robert Anic","robert@example.com","No"]