{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Summary","Income and Expenses"],"not_rendered":{"images":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,1,0,4],[0,5,5,5],[1,1,1,4],[2,1,2,3],[3,2,3,3]]}
[null,"Monthly Budget Summary",{"$nulls":3},"Having difficulty planning your budget? Use this monthly budget calculator to help you identify your monthly income and expenses. Add new categories you want to track to the budget summary table or modify those that have been added to fit your needs. Then, enter all of your income and expenses for a single month in the monthly income and expenses table and assign each item a category. When you enter an amount, the associated category in the budget summary table will be summarized automatically."]
[null,"[ENTER MONTH]"]
[null,{"$f":"CONCATENATE(\"Under/Over: \"&TEXT(UnderOver,\"$#,##0.00_);[Red]($#,##0.00)\"))","v":"Under/Over: $928.00 "}]
[null,null,"Budget Summary"]
[null,null,"Category","Total"]
[null,null,"Income",{"$f":"SUMIF(Register[Category],\"=\" &Categories[[#This Row],[Category]],Register[Amount])","v":{"v":4500,"d":"4,500.00"}}]
[null,null,"Housing",{"$f":"SUMIF(Register[Category],\"=\" &Categories[[#This Row],[Category]],Register[Amount])","v":{"v":1410,"d":"1,410.00"}}]
[null,null,"Utilities",{"$f":"SUMIF(Register[Category],\"=\" &Categories[[#This Row],[Category]],Register[Amount])","v":{"v":73,"d":"73.00"}}]
[null,null,"Groceries",{"$f":"SUMIF(Register[Category],\"=\" &Categories[[#This Row],[Category]],Register[Amount])","v":{"v":220,"d":"220.00"}}]
[null,null,"Insurance",{"$f":"SUMIF(Register[Category],\"=\" &Categories[[#This Row],[Category]],Register[Amount])","v":{"v":180,"d":"180.00"}}]
[null,null,"Phone",{"$f":"SUMIF(Register[Category],\"=\" &Categories[[#This Row],[Category]],Register[Amount])","v":{"v":104,"d":"104.00"}}]
[null,null,"Credit Cards",{"$f":"SUMIF(Register[Category],\"=\" &Categories[[#This Row],[Category]],Register[Amount])","v":{"v":315,"d":"315.00"}}]
[null,null,"School",{"$f":"SUMIF(Register[Category],\"=\" &Categories[[#This Row],[Category]],Register[Amount])","v":{"v":1063,"d":"1,063.00"}}]
[null,null,"Savings",{"$f":"SUMIF(Register[Category],\"=\" &Categories[[#This Row],[Category]],Register[Amount])","v":{"v":100,"d":"100.00"}}]
[null,null,"Entertainment",{"$f":"SUMIF(Register[Category],\"=\" &Categories[[#This Row],[Category]],Register[Amount])","v":{"v":107,"d":"107.00"}}]
[null,null,"Other",{"$f":"SUMIF(Register[Category],\"=\" &Categories[[#This Row],[Category]],Register[Amount])","v":{"v":0,"d":"0.00"}}]

{"sheet":"Income and Expenses","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[0,1,0,5],[1,1,1,5]]}
[null,{"$f":"Budget_Title","v":"Monthly Budget Summary"}]
[null,"Income and Expenses"]
[null,"Category","Description","Amount","Notes"]
[null,"Income","Pat's paycheck",{"v":1250,"d":"$1,250.00"}]
[null,"School","School registration",{"v":225,"d":"$225.00"}]
[null,"Utilities","Electricity & gas",{"v":73,"d":"$73.00"}]
[null,"School","School supplies",{"v":38,"d":"$38.00"}]
[null,"Groceries","Grocery store",{"v":40,"d":"$40.00"}]
[null,"Entertainment","Southridge video",{"v":7,"d":"$7.00"}]
[null,"Phone","The phone company",{"v":24,"d":"$24.00"},"Jesse's cell phone"]
[null,"Income","John's paycheck",{"v":2000,"d":"$2,000.00"}]
[null,"Housing","Woodgrove Bank",{"v":1000,"d":"$1,000.00"},"Mortgage"]
[null,"Housing","Home insurance",{"v":210,"d":"$210.00"},"Home insurance"]
[null,"School","School of Fine Art",{"v":800,"d":"$800.00"},"Tuition"]
[null,"Credit Cards","Woodgrove Bank",{"v":75,"d":"$75.00"},"Pat's card"]
[null,"Savings","Woodgrove Bank",{"v":100,"d":"$100.00"}]
[null,"Phone","Consolidated messenger",{"v":80,"d":"$80.00"},"Pat's cell phone"]
[null,"Income","Pat's paycheck",{"v":1250,"d":"$1,250.00"}]
[null,"Housing","Woodgrove Bank",{"v":200,"d":"$200.00"},"Property taxes"]
[null,"Insurance","Auto insurance",{"v":180,"d":"$180.00"},"Auto insurance"]
[null,"Groceries","Grocery store",{"v":180,"d":"$180.00"}]
[null,"Credit Cards","Woodgrove Bank",{"v":240,"d":"$240.00"},"Jesse's Card"]
[null,"Entertainment","Dinner & movie",{"v":100,"d":"$100.00"}]