{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Holiday budget planner"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Holiday budget planner","index":0,"n_rows":34,"n_cols":17,"rows_kept":34,"merged":[[0,2,5,7],[2,10,2,11],[8,2,8,5],[8,10,8,13],[17,2,17,5],[17,10,17,13],[27,2,27,5],[27,10,27,13]]}
[null,null,"Holiday budget \nplanner",{"$nulls":13}," "]
[]
[{"$nulls":10},"HOLIDAY BUDGET",null,null,{"$f":"SUM(Gifts[Budget],Packaging[Budget],Travel[Budget],Meals[Budget],Entertainment[Budget],Miscellaneous[Budget])","v":{"v":750,"d":"$750.00"}}]
[{"$nulls":10},"ACTUAL SPENT",null,null,{"$f":"SUM(Gifts[Actual],Packaging[Actual],Travel[Actual],Meals[Actual],Entertainment[Actual],Miscellaneous[Actual])","v":{"v":820,"d":"$820.00"}}]
[]
[{"$nulls":10},"DIFFERENCE (over/under budget)",null,null,{"$f":"SUM(N3-N4)","v":{"v":-70,"d":"($70.00)"}}]
[]
[]
[null,null,"GIFTS",{"$nulls":7},"HOLIDAY MEALS"]
[null,null,"Item","Budget","Actual","Difference",{"$nulls":4},"Item","Budget","Actual","Difference"]
[null,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":4},"Groceries",null,null,{"$f":"Meals[[#This Row],[Budget]]-Meals[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,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":4},"Libations",null,null,{"$f":"Meals[[#This Row],[Budget]]-Meals[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,null,"Co-workers",null,null,{"$f":"Gifts[[#This Row],[Budget]]-Gifts[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Decorations",null,null,{"$f":"Meals[[#This Row],[Budget]]-Meals[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,null,"Teachers, nannies, babysitters, etc.",null,null,{"$f":"Gifts[[#This Row],[Budget]]-Gifts[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Other",null,null,{"$f":"Meals[[#This Row],[Budget]]-Meals[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,null,"Charitable donations",null,null,{"$f":"Gifts[[#This Row],[Budget]]-Gifts[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Other",null,null,{"$f":"Meals[[#This Row],[Budget]]-Meals[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,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"}},{"$nulls":4},"Other",null,null,{"$f":"Meals[[#This Row],[Budget]]-Meals[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,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"}},{"$nulls":4},"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,null,"PACKAGING",{"$nulls":7},"ENTERTAINMENT"]
[null,null,"Item","Budget","Actual","Difference",{"$nulls":4},"Item","Budget","Actual","Difference"]
[null,null,"Gift wrap",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Party help (bartender, caterer, cleaners, etc.)",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,null,"Tags",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Decorations",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,null,"Supplies (ribbon, tape, etc.)",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Food and beverages",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,null,"Boxes",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Clothing",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,null,"Postage",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Tickets",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,null,"Other",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Dinners out",null,null,{"$f":"Entertainment[[#This Row],[Budget]]-Entertainment[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,null,"Other",null,null,{"$f":"Packaging[[#This Row],[Budget]]-Packaging[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"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"}}]
[null,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":4},"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,null,"TRAVEL",{"$nulls":7},"MISCELLANEOUS"]
[null,null,"Item","Budget","Actual","Difference",{"$nulls":4},"Item","Budget","Actual","Difference"]
[null,null,"Airfare",null,null,{"$f":"Travel[[#This Row],[Budget]]-Travel[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Holiday photos",null,null,{"$f":"Miscellaneous[[#This Row],[Budget]]-Miscellaneous[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,null,"Lodging",null,null,{"$f":"Travel[[#This Row],[Budget]]-Travel[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Gas ",null,null,{"$f":"Miscellaneous[[#This Row],[Budget]]-Miscellaneous[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,null,"Transportation",null,null,{"$f":"Travel[[#This Row],[Budget]]-Travel[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}},{"$nulls":4},"Other",null,null,{"$f":"Miscellaneous[[#This Row],[Budget]]-Miscellaneous[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,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":4},"Other",null,null,{"$f":"Miscellaneous[[#This Row],[Budget]]-Miscellaneous[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,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"}},{"$nulls":4},"Total",{"$f":"SUBTOTAL(109,Miscellaneous[Budget])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Miscellaneous[Actual])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Miscellaneous[Difference])","v":{"v":0,"d":"$0.00"}}]