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

{"sheet":"Holiday Budget Planner","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"merged":[[1,1,1,9],[2,1,2,3],[3,1,3,3],[3,6,3,9],[4,1,4,3],[5,1,5,3],[7,1,7,4],[11,6,11,9],[16,1,16,4],[17,1,17,4],[21,6,21,9],[22,6,22,9],[26,1,26,4],[27,1,27,4]]}
[]
[null,"Holiday Budget Planner"]
[]
[null,"HOLIDAY BUDGET",null,null,{"$f":"SUM(Gifts[Budget],Packaging[Budget],(Travel[Budget],(Meals[Budget],(Entertainment[Budget],Misc[Budget]))))","v":{"v":750,"d":"$750.00"}},null,"Holiday Meals"]
[null,"ACTUAL SPENT",null,null,{"$f":"SUM((Gifts[Actual],(Packaging[Actual],(Travel[Actual],(Meals[Actual],(Entertainment[Actual],(Misc[Actual])))))))","v":{"v":820,"d":"$820.00"}},null,"Item","Budget","Actual","Difference"]
[null,"DIFFERENCE (over/under budget)",null,null,{"$f":"SUM(E4-E5)","v":{"v":-70,"d":"($70.00)"}},null,"Groceries",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},"Libations",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Gifts",{"$nulls":4},"Decorations",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Item","Budget","Actual","Difference",null,"Other (tab in last column of this row to add row)",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Family",{"v":500,"d":"$500.00"},{"v":495,"d":"$495.00"},{"$f":"[Budget]-[Actual]","v":{"v":5,"d":"$5.00"}},null,"Total",{"$f":"SUBTOTAL(109,[Budget])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Actual])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0.00"}}]
[null,"Friends",{"v":250,"d":"$250.00"},{"v":325,"d":"$325.00"},{"$f":"[Budget]-[Actual]","v":{"v":-75,"d":"-$75.00"}}]
[null,"Co-workers",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}},null,"Entertainment"]
[null,"Teachers, nannies, babysitters, etc.",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}},null,"Item","Budget","Actual","Difference"]
[null,"Charitable donations",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}},null,"Party help (bartender, caterer, cleaners, etc.)",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Other (tab in last column of this row to add row)",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}},null,"Decorations",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,[Budget])","v":{"v":750,"d":"$750.00"}},{"$f":"SUBTOTAL(109,[Actual])","v":{"v":820,"d":"$820.00"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":-70,"d":"-$70.00"}},null,"Food and beverages",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},"Clothing",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Packaging",{"$nulls":4},"Tickets",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Item","Budget","Actual","Difference",null,"Dinners out",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Gift wrap",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}},null,"Other (tab in last column of this row to add row)",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Tags",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}},null,"Total",{"$f":"SUBTOTAL(109,[Budget])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Actual])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0.00"}}]
[null,"Supplies (ribbon, tape, etc.)",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Boxes",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}},null,"Miscellaneous"]
[null,"Postage",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}},null,"Item","Budget","Actual","Difference"]
[null,"Other (tab in last column of this row to add row)",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}},null,"Holiday photos",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,[Budget])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Actual])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0.00"}},null,"Gas ",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},"Other (tab in last column of this row to add row)",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Travel",{"$nulls":4},"Total",{"$f":"SUBTOTAL(109,[Budget])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Actual])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0.00"}}]
[null,"Item","Budget","Actual","Difference"]
[null,"Airfare",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Lodging",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Transportation",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Other (tab in last column of this row to add row)",null,null,{"$f":"[Budget]-[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,[Budget])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Actual])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0.00"}}]