{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Holiday budget","List entry","List info"],"not_rendered":{"charts":1,"images":5,"defined_names":14,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Holiday budget","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"merged":[[0,1,1,4],[2,1,2,2],[13,4,19,4]]}
[null,"Holiday shopping budget",{"$nulls":3},"TO LIST ENTRY >"]
[{"$nulls":5},"TO LIST INFO >"]
[null,"TOTALS",null,"Clustered bar chart showing Cost Allocation and Total Spent to Date amounts is in this cell."]
[null,"COST ALLOCATION",{"$f":"SUM(GiftData[COST])","v":{"v":377,"d":"$377.00"}}]
[null,"SPENT TO DATE",{"$f":"SUMIF(GiftData[PURCHASED],\"Purchased\",GiftData[COST])","v":{"v":233,"d":"$233.00"}}]
[null,"DIFFERENCE",{"$f":"C4-C5","v":{"v":144,"d":"$144.00"}}]
[{"$nulls":4},"Slicer to filter table data by Wrapped Status is in this cell.","Slicer to filter table data by Purchased is in this cell."]
[null,"BREAKDOWN",null,"Slicer to filter table data by For is in this cell."]
[null,null,"Gift Cost"]
[null,"Ana",{"v":59,"d":"$59.00"}]
[null,"Purchased"]
[null,"Socks",{"v":23,"d":"$23.00"}]
[null,"Dollhouse",{"v":36,"d":"$36.00"}]
[{"$nulls":4},"Slicer to filter table data by Delivery Status is in this cell.","Slicer to filter table data by Gift Category is in this cell."]
[null,"Avri",{"v":46,"d":"$46.00"}]
[null,"Not purchased"]
[null,"Socks",{"v":46,"d":"$46.00"}]
[]
[null,"Billie",{"v":118,"d":"$118.00"}]
[null,"Purchased"]
[null,"Video game",{"v":49,"d":"$49.00"}]
[null,"Not purchased"]
[null,"Shirt",{"v":37,"d":"$37.00"}]
[null,"Gift card",{"v":32,"d":"$32.00"}]
[]
[null,"Diego",{"v":45,"d":"$45.00"}]
[null,"Purchased"]
[null,"Puzzle",{"v":16,"d":"$16.00"}]
[null,"Not purchased"]
[null,"Bike",{"v":29,"d":"$29.00"}]
[]
[null,"Robin",{"v":44,"d":"$44.00"}]
[null,"Purchased"]
[null,"Photo album",{"v":30,"d":"$30.00"}]
[null,"Cooking utensils",{"v":14,"d":"$14.00"}]
[]
[null,"Yui",{"v":65,"d":"$65.00"}]
[null,"Purchased"]
[null,"Toy train",{"v":26,"d":"$26.00"}]
[null,"Sweater",{"v":39,"d":"$39.00"}]
[]
[null,"Grand Total",{"v":377,"d":"$377.00"}]

{"sheet":"List entry","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,1,1,3]]}
[null,"Shopping List",{"$nulls":5},"TO LIST INFO >"]
[{"$nulls":7},"< TO HOLIDAY BUDGET"]
[null,"FOR","GIFT CATEGORY","GIFT","COST","PURCHASED","DELIVERY STATUS","WRAPPED STATUS"]
[null,"Yui","Family gift","Toy train",{"v":26,"d":"$26.00"},"Purchased","Arrived","Wrapped"]
[null,"Ana","General gift","Socks",{"v":23,"d":"$23.00"},"Purchased","Arrived","Wrapped"]
[null,"Diego","General gift","Puzzle",{"v":16,"d":"$16.00"},"Purchased","Arrived","Unwrapped"]
[null,"Robin","General gift","Cooking utensils",{"v":14,"d":"$14.00"},"Purchased","In-transit","Unwrapped"]
[null,"Billie","General gift","Video game",{"v":49,"d":"$49.00"},"Purchased","In-transit","Unwrapped"]
[null,"Billie","General gift","Shirt",{"v":37,"d":"$37.00"},"Not purchased","In-transit","Unwrapped"]
[null,"Yui","General gift","Sweater",{"v":39,"d":"$39.00"},"Purchased","In-transit","Unwrapped"]
[null,"Ana","General gift","Dollhouse",{"v":36,"d":"$36.00"},"Purchased","Arrived","Unwrapped"]
[null,"Diego","General gift","Bike",{"v":29,"d":"$29.00"},"Not purchased"]
[null,"Robin","General gift","Photo album",{"v":30,"d":"$30.00"},"Purchased","Arrived"]
[null,"Billie","General gift","Gift card",{"v":32,"d":"$32.00"},"Not purchased"]
[null,"Avri","General gift","Socks",{"v":46,"d":"$46.00"},"Not purchased"]

{"sheet":"List info","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,1,1,1],[0,2,1,3]]}
[null,"List Info","String of lights is in this cell.",null,"< TO LIST ENTRY"]
[{"$nulls":4},"< TO HOLIDAY BUDGET"]
[null,"PEOPLE",null,"GIFT CATEGORIES"]
[null,"Yui",null,"Stocking stuffer"]
[null,"Ana",null,"General gift"]
[null,"Diego",null,"Spouse gift"]
[null,"Robin",null,"Family gift"]
[null,"Billie",null,"Special gift"]
[null,"Avri"]