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

{"sheet":"Scholarship Budget Planner","index":0,"n_rows":32,"n_cols":12,"rows_kept":32,"merged":[[1,1,5,4],[2,8,2,9],[3,8,3,9],[4,8,4,9],[6,1,6,4],[6,8,6,11],[15,1,15,4],[15,8,15,11],[25,1,25,4],[25,8,25,11]]}
["Enter Budget and Actual expenses incurred on each category in respective tables in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started. "]
["Title of this worksheet is in cell at right.","Scholarship Budget \nPlanner"]
["Holiday Budget is auto calculated in cell K3.",{"$nulls":7},"SCHOLARSHIP BUDGET",null,{"$f":"SUM(Gifts[Budget],Packaging[Budget],(Travel[Budget],(Meals[Budget],(Entertainment[Budget],Miscellaneous[Budget]))))","v":{"v":750,"d":"$750.00"}}]
["Actual Spent is auto calculated in cell K4.",{"$nulls":7},"ACTUAL SPENT",null,{"$f":"SUM((Gifts[Actual],(Packaging[Actual],(Travel[Actual],(Meals[Actual],(Entertainment[Actual],(Miscellaneous[Actual])))))))","v":{"v":820,"d":"$820.00"}}]
["Difference is auto calculated in cell K5. Next instruction is in cell A7.",{"$nulls":7},"DIFFERENCE (over/under budget)",null,{"$f":"SUM(K3-K4)","v":{"v":-70,"d":"($70.00)"}}]
[]
["Gifts label is in cell at right and Holiday Meals label in cell I7.","College",{"$nulls":6},"Food"]
["Enter expenses on Gifts in table starting in cell at right and on Meals in table starting in cell I8. Next instruction is in cell A16.","Item","Budget","Actual","Difference",{"$nulls":3},"Item","Budget","Actual","Difference"]
[null,"Tuition fee",{"v":500,"d":"$500.00"},{"v":495,"d":"$495.00"},{"$f":"Gifts[Budget]-Gifts[Actual]","v":{"v":5,"d":"$5.00"}},{"$nulls":3},"Groceries",null,null,{"$f":"Meals[Budget]-Meals[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Insurance",{"v":250,"d":"$250.00"},{"v":325,"d":"$325.00"},{"$f":"Gifts[Budget]-Gifts[Actual]","v":{"v":-75,"d":"-$75.00"}},{"$nulls":3},"Beverages",null,null,{"$f":"Meals[Budget]-Meals[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Private lessons",null,null,{"$f":"Gifts[Budget]-Gifts[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Fast food",null,null,{"$f":"Meals[Budget]-Meals[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Computer and tech",null,null,{"$f":"Gifts[Budget]-Gifts[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Other (tab in last column of this row to add row)",null,null,{"$f":"Meals[Budget]-Meals[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Rent fee",null,null,{"$f":"Gifts[Budget]-Gifts[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[Budget]-Gifts[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"}}]
["Packaging label is in cell at right and Entertainment label in cell I16.","Living expenses",{"$nulls":6},"Entertainment"]
["Enter expenses on Packaging in table starting in cell at right and on Entertainment in table starting in cell I17. Next instruction is in cell A26.","Item","Budget","Actual","Difference",{"$nulls":3},"Item","Budget","Actual","Difference"]
[null,"Medical expenses",null,null,{"$f":"Packaging[Budget]-Packaging[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Party",null,null,{"$f":"Entertainment[Budget]-Entertainment[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Laundry",null,null,{"$f":"Packaging[Budget]-Packaging[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Cinema",null,null,{"$f":"Entertainment[Budget]-Entertainment[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Cable/internet/cell phone",null,null,{"$f":"Packaging[Budget]-Packaging[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Theatre",null,null,{"$f":"Entertainment[Budget]-Entertainment[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Cosmetics",null,null,{"$f":"Packaging[Budget]-Packaging[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Concert",null,null,{"$f":"Entertainment[Budget]-Entertainment[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Clothers",null,null,{"$f":"Packaging[Budget]-Packaging[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Sports",null,null,{"$f":"Entertainment[Budget]-Entertainment[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Other (tab in last column of this row to add row)",null,null,{"$f":"Packaging[Budget]-Packaging[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Dinners out",null,null,{"$f":"Entertainment[Budget]-Entertainment[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[Budget]-Entertainment[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"}}]
["Travel label is in cell at right and Miscellaneous label in cell I26.","Studying",{"$nulls":6},"Miscellaneous"]
["Enter expenses on Travel in table starting in cell at right and Miscellaneous expenses in table starting in cell I27.","Item","Budget","Actual","Difference",{"$nulls":3},"Item","Budget","Actual","Difference"]
[null,"Books",null,null,{"$f":"Travel[Budget]-Travel[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Gifts",null,null,{"$f":"Miscellaneous[Budget]-Miscellaneous[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Stationery",null,null,{"$f":"Travel[Budget]-Travel[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Gas ",null,null,{"$f":"Miscellaneous[Budget]-Miscellaneous[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Learning materials",null,null,{"$f":"Travel[Budget]-Travel[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"Other (tab in last column of this row to add row)",null,null,{"$f":"Miscellaneous[Budget]-Miscellaneous[Actual]","v":{"v":0,"d":"$0.00"}}]
[null,"Other (tab in last column of this row to add row)",null,null,{"$f":"Travel[Budget]-Travel[Actual]","v":{"v":0,"d":"$0.00"}},{"$nulls":3},"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"}}]
[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"}}]