{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Christmas Budget Planner"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Christmas Budget Planner","index":0,"n_rows":37,"n_cols":12,"rows_kept":37,"merged":[[1,1,7,4],[9,1,9,4],[9,8,9,11],[19,1,19,4],[19,8,19,11],[30,1,30,4],[30,8,30,11]]}
[]
[null,"Christmas budget Planner"]
[]
[{"$nulls":8},"CHRISTMAS BUDGET",null,{"$f":"SUM(Gifts[Budget],Packaging[Budget],(Travel[Budget],(Meals[Budget],(Entertainment[Budget],Misc.[Budget]))))","v":{"v":750,"d":"£750.00"}}]
[{"$nulls":8},"ACTUAL SPENT",null,{"$f":"SUM((Gifts[Actual],(Packaging[Actual],(Travel[Actual],(Meals[Actual],(Entertainment[Actual],(Misc.[Actual])))))))","v":{"v":820,"d":"£820.00"}}]
[]
[{"$nulls":8},"DIFFERENCE (over/under budget)",null,{"$f":"SUM(K4-K5)","v":{"v":-70,"d":"-£70.00"}}]
[]
[]
[null,"Presents",{"$nulls":6},"Christmas Meals"]
[null,"Item","Budget","Actual","Difference",{"$nulls":3},"Item","Budget","Actual","Difference"]
[null,"Family",{"v":500,"d":"£500.00"},{"v":495,"d":"£495.00"},{"$f":"Gifts[[#This Row],[Budget]]-Gifts[[#This Row],[Actual]]","v":{"v":5,"d":"£5.00"}},{"$nulls":3},"Food and drink",null,null,{"$f":"Meals[[#This Row],[Budget]]-Meals[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Friends",{"v":250,"d":"£250.00"},{"v":325,"d":"£325.00"},{"$f":"Gifts[[#This Row],[Budget]]-Gifts[[#This Row],[Actual]]","v":{"v":-75,"d":"-£75.00"}},{"$nulls":3},"Libations",null,null,{"$f":"Meals[[#This Row],[Budget]]-Meals[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Colleagues",null,null,{"$f":"Gifts[[#This Row],[Budget]]-Gifts[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Decorations",null,null,{"$f":"Meals[[#This Row],[Budget]]-Meals[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Teachers, nannies, babysitters etc.",null,null,{"$f":"Gifts[[#This Row],[Budget]]-Gifts[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Other (tab in last column of this row to add row)",null,null,{"$f":"Meals[[#This Row],[Budget]]-Meals[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Charitable donations",null,null,{"$f":"Gifts[[#This Row],[Budget]]-Gifts[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,Meals[Budget])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,Meals[Actual])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,Meals[Difference])","v":{"v":0,"d":"£0.00"}}]
[null,"Other (tab in last column of this row to add row)",null,null,{"$f":"Gifts[[#This Row],[Budget]]-Gifts[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Gifts[Budget])","v":{"v":750,"d":"£750.00"}},{"$f":"SUBTOTAL(109,Gifts[Actual])","v":{"v":820,"d":"£820.00"}},{"$f":"SUBTOTAL(109,Gifts[Difference])","v":{"v":-70,"d":"-£70.00"}}]
[]
[null,"Packaging",{"$nulls":6},"Entertainment"]
[null,"Item","Budget","Actual","Difference",{"$nulls":3},"Item","Budget","Actual","Difference"]
[null,"Wrapping paper",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Party help (bartender, caterer, cleaners etc.)",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Tags",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Decorations",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Supplies (ribbon, tape etc.)",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Food and beverages",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Boxes",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Clothing",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Postage",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Tickets",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Other (tab in last column of this row to add row)",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Dinners out",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Packaging[Budget])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,Packaging[Actual])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,Packaging[Difference])","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Other (tab in last column of this row to add row)",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":8},"Total",{"$f":"SUBTOTAL(109,Entertainment[Budget])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,Entertainment[Actual])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,Entertainment[Difference])","v":{"v":0,"d":"£0.00"}}]
[]
[null,"Travel",{"$nulls":6},"Miscellaneous"]
[null,"Item","Budget","Actual","Difference",{"$nulls":3},"Item","Budget","Actual","Difference"]
[null,"Airfare",null,null,{"$f":"Travel[[#This Row],[Budget]]-Travel[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Christmas photos",null,null,{"$f":"Misc.[[#This Row],[Budget]]-Misc.[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Lodging",null,null,{"$f":"Travel[[#This Row],[Budget]]-Travel[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Gas ",null,null,{"$f":"Misc.[[#This Row],[Budget]]-Misc.[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Transport",null,null,{"$f":"Travel[[#This Row],[Budget]]-Travel[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Other (tab in last column of this row to add row)",null,null,{"$f":"Misc.[[#This Row],[Budget]]-Misc.[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}}]
[null,"Other (tab in last column of this row to add row)",null,null,{"$f":"Travel[[#This Row],[Budget]]-Travel[[#This Row],[Actual]]","v":{"v":0,"d":"£0.00"}},{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,Misc.[Budget])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,Misc.[Actual])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,Misc.[Difference])","v":{"v":0,"d":"£0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Travel[Budget])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,Travel[Actual])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,Travel[Difference])","v":{"v":0,"d":"£0.00"}}]