{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["List Entry","Holiday List","List Info"],"not_rendered":{"charts":1,"defined_names":9,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"List Entry","index":0,"n_rows":18,"n_cols":8,"rows_kept":18}
[]
[null,"List Entry"]
[]
[null,"FOR","GIFT CATEGORY","GIFT","COST","PURCHASED","DELIVERY STATUS","WRAPPED STATUS"]
[null,"Bill","Family gift","Toy train",{"v":26,"d":"$26.00"},"Purchased","Arrived","Wrapped"]
[null,"Jenny","General gift","Socks",{"v":23,"d":"$23.00"},"Purchased","Arrived","Wrapped"]
[null,"Brian","General gift","Puzzle",{"v":16,"d":"$16.00"},"Purchased","Arrived","Unwrapped"]
[null,"Suzanne","General gift","Scrapbooking materials",{"v":14,"d":"$14.00"},"Purchased","In-Transit","Unwrapped"]
[null,"Marty","General gift","Xbox game",{"v":49,"d":"$49.00"},"Purchased","In-Transit","Unwrapped"]
[null,"Mark","General gift","Shirt",{"v":37,"d":"$37.00"},"Not purchased","In-Transit","Unwrapped"]
[null,"Bill","Family gift","Xbox Gold Card",{"v":39,"d":"$39.00"},"Purchased","In-Transit","Unwrapped"]
[null,"Adam","General gift","Sweater",{"v":39,"d":"$39.00"},"Purchased","In-Transit","Unwrapped"]
[null,"Jenny","General gift","Doll house",{"v":36,"d":"$36.00"},"Purchased","In-Transit","Unwrapped"]
[null,"Brian","General gift","Bicycle",{"v":29,"d":"$29.00"},"Not purchased"]
[null,"Suzanne","General gift","Photo album",{"v":30,"d":"$30.00"},"Purchased"]
[null,"Marty","General gift","Gift card",{"v":32,"d":"$32.00"},"Not purchased"]
[null,"Mark","General gift","Socks",{"v":46,"d":"$46.00"},"Not purchased"]
[null,"Bill","General gift","Safety glasses",{"v":10,"d":"$10.00"},"Not purchased"]

{"sheet":"Holiday List","index":1,"n_rows":53,"n_cols":3,"rows_kept":53}
[]
[null,"Holiday List 2012"]
[]
[]
[null,"TOTALS"]
[]
[null,"SPENT TO DATE",{"$f":"SUMIF(GiftData[PURCHASED],\"Purchased\",GiftData[COST])","v":{"v":272,"d":"$272.00"}}]
[null,"COST ALLOCATION",{"$f":"SUM(GiftData[COST])","v":{"v":426,"d":"$426.00"}}]
[null,"DIFFERENCE",{"$f":"C8-C7","v":{"v":154,"d":"$154.00"}}]
[]
[]
[]
[null,"BREAKDOWN"]
[null,null,"Gift Cost"]
[null,"Adam",{"v":39,"d":"$39.00"}]
[null,"Purchased"]
[null,"Sweater",{"v":39,"d":"$39.00"}]
[]
[null,"Bill",{"v":75,"d":"$75.00"}]
[null,"Purchased"]
[null,"Toy train",{"v":26,"d":"$26.00"}]
[null,"Xbox Gold Card",{"v":39,"d":"$39.00"}]
[null,"Not purchased"]
[null,"Safety glasses",{"v":10,"d":"$10.00"}]
[]
[null,"Brian",{"v":45,"d":"$45.00"}]
[null,"Purchased"]
[null,"Puzzle",{"v":16,"d":"$16.00"}]
[null,"Not purchased"]
[null,"Bicycle",{"v":29,"d":"$29.00"}]
[]
[null,"Jenny",{"v":59,"d":"$59.00"}]
[null,"Purchased"]
[null,"Socks",{"v":23,"d":"$23.00"}]
[null,"Doll house",{"v":36,"d":"$36.00"}]
[]
[null,"Mark",{"v":83,"d":"$83.00"}]
[null,"Not purchased"]
[null,"Socks",{"v":46,"d":"$46.00"}]
[null,"Shirt",{"v":37,"d":"$37.00"}]
[]
[null,"Marty",{"v":81,"d":"$81.00"}]
[null,"Purchased"]
[null,"Xbox game",{"v":49,"d":"$49.00"}]
[null,"Not purchased"]
[null,"Gift card",{"v":32,"d":"$32.00"}]
[]
[null,"Suzanne",{"v":44,"d":"$44.00"}]
[null,"Purchased"]
[null,"Scrapbooking materials",{"v":14,"d":"$14.00"}]
[null,"Photo album",{"v":30,"d":"$30.00"}]
[]
[null,"Grand Total",{"v":426,"d":"$426.00"}]

{"sheet":"List Info","index":2,"n_rows":11,"n_cols":6,"rows_kept":11}
[]
[null,"List Info"]
[]
[null,"BUDGET",null,"PEOPLE",null,"GIFT CATEGORIES"]
[null,{"v":500,"d":"$500.00"},null,"Adam",null,"Stocking stuffer"]
[{"$nulls":3},"Jenny",null,"General gift"]
[{"$nulls":3},"Brian",null,"Spouse gift"]
[{"$nulls":3},"Suzanne",null,"Family gift"]
[{"$nulls":3},"Marty",null,"Special gift"]
[{"$nulls":3},"Mark"]
[{"$nulls":3},"Bill"]