{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["BUDGET - Current","PIVOT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":67,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BUDGET - Current","index":0,"n_rows":98,"n_cols":8,"rows_kept":98,"cut":false,"hidden":false,"merged":[[0,2,0,7],[1,5,1,7],[15,0,15,1],[1,0,2,1],[1,2,1,4],[3,0,3,1],[10,0,10,1]]}
[null,null,"After creating a new budget, simply follow each step by clicking on the buttons to the left.\n\nNOTE: Only edit shaded budget values.  Once step 4 is completed, the program will automatically input all actual income/expeditures into the appropriate cell and calculate your budget variances."]
["CATEGORY",null,"TEMPLATE (DO NOT DELETE)",null,null,"2011-01-01"]
[null,null,"BUDGETED","ACTUAL","VARIANCE","BUDGETED","ACTUAL","VARIANCE"]
["INCOME"]
[null,"Paycheck (Net of Tax)",3200,0,{"$f":"D5-C5","v":-3200},0,0,{"$f":"G5-F5","v":0}]
[null,"Income - Miscellaneous",300,0,{"$f":"D6-C6","v":-300},0,0,{"$f":"G6-F6","v":0}]
[null,"Reimbursements",200,0,{"$f":"D7-C7","v":-200},0,0,{"$f":"G7-F7","v":0}]
[null,"Transfer From Savings / Emergency Cash",0,0,{"$f":"D8-C8","v":0},0,0,{"$f":"G8-F8","v":0}]
[null,"Total Monthly Infow",{"$f":"SUM(C5:C8)","v":3700},{"$f":"SUM(D5:D8)","v":0},{"$f":"D9-C9","v":-3700},{"$f":"SUM(F5:F8)","v":0},{"$f":"SUM(G5:G8)","v":0},{"$f":"G9-F9","v":0}]
[]
["SAVINGS"]
["SAVINGS"]
[null,"Savings",120,0,{"$f":"C13-D13","v":120},0,0,{"$f":"F13-G13","v":0}]
[null,"TOTAL SAVINGS",{"$f":"SUM(C12:C13)","v":120},0,120,{"$f":"SUM(F12:F13)","v":0},0,0]
[]
["VARIABLE EXPENSES"]
["CHARITY"]
[null,"Tithing (10% of Gross)",{"$f":"0.1*(C5*1.08)","v":345.6},0,{"$f":"C18-D18","v":345.6},{"$f":"0.1*(F5*1.08)","v":0},0,{"$f":"F18-G18","v":0}]
[null,"Fast Offerings",25,0,{"$f":"C19-D19","v":25},0,0,{"$f":"F19-G19","v":0}]
[null,"Miscellaneous Charity",0,0,0,0,0,0]
["GROCERIES"]
[null,"Groceries - Food",280,0,280,0,0,{"$f":"F22-G22","v":0}]
[null,"Vitamins",160,0,160,0,0,0]
[null,"Personal Care",20,0,20,0,0,0]
[null,"Clothing",0,0,0,0,0,0]
[null,"Household",10,0,10,0,0,0]
[null,"Shipping / Mail",0,0,{"$f":"C27-D27","v":0},0,0,{"$f":"F27-G27","v":0}]
[null,"Miscellaneous - Groceries",0,0,0,0,0,0]
["CHILDREN"]
[null,"Allowance",5,0,{"$f":"C30-D30","v":5},0,0,{"$f":"F30-G30","v":0}]
[null,"Preschool",60,0,60,0,0,{"$f":"F31-G31","v":0}]
[null,"Baby Supplies (Diapers/Wipes)",50,0,50,0,0,0]
[null,"Books",0,0,0,0,0,0]
[null,"Toys",0,0,{"$f":"C34-D34","v":0},0,0,{"$f":"F34-G34","v":0}]
[null,"Clothing - Children",10,0,10,0,0,0]
[null,"Miscellaneous - Children"]
["AUTO"]
[null,"Fuel",60,0,60,0,0,{"$f":"F38-G38","v":0}]
[null,"Maintenance",0,0,0,0,0,0]
[null,"Taxes",0,0,0,0,0,0]
["UTILITIES"]
[null,"Gas",0,0,0,0,0,{"$f":"F42-G42","v":0}]
[null,"Electricity",39,0,39,0,0,0]
[null,"Water/Garbage/Sewer/Laundry",20,0,20,0,0,0]
["MEDICAL"]
[null,"Pharmacy/Drugs",0,0,0,0,0,{"$f":"F46-G46","v":0}]
[null,"Doctor",0,0,0,0,0,0]
[null,"Maternity",0,0,0,0,0,0]
[null,"Dentist",0,0,0,0,0,{"$f":"F49-G49","v":0}]
[null,"Vision",0,0,0,0,0,0]
["DEBT",null,null,0,0,null,0,0]
[null,"CC Payment in Excess of Crrnt Mnth Expndtrs",0,0,0,0,0,0]
[null,"CC Payoff",0,0,0,0,0,0]
[null,"Deloitte Diner's Card Payoff",0,0,{"$f":"C54-D54","v":0},0,0,{"$f":"F54-G54","v":0}]
["PERSONAL / FAMILY"]
[null,"Hair",0,0,0,0,0,{"$f":"F56-G56","v":0}]
[null,"Mothering Needs",0,0,0,0,0,0]
[null,"Gifts",0,0,0,0,0,0]
[null,"Family Entertainment",20,0,20,0,0,0]
[null,"Date Night",20,0,20,0,0,0]
[null,"Books",0,0,{"$f":"C61-D61","v":0},0,0,{"$f":"F61-G61","v":0}]
[null,"HIS",0,0,0,0,0,0]
[null,"Computer/software Needs",0,0,0,0,0,0]
[null,"Office Supplies",0,0,{"$f":"C64-D64","v":0},0,0,{"$f":"F64-G64","v":0}]
[null,"Health & Fitness",0,0,0,0,0,0]
[null,"Racquetball Expenses",0,0,0,0,0,{"$f":"F66-G66","v":0}]
[null,"HERS",0,0,0,0,0,0]
[null,"Eat-out Food",0,0,0,0,0,0]
["SCHOOL"]
[null,"Tuition",0,0,0,0,0,{"$f":"F70-G70","v":0}]
[null,"Textbooks/printing",0,0,0,0,0,0]
[null,"CPA Exam",0,0,0,0,0,0]
["VACATION"]
[null,"Vacation",0,0,0,0,0,{"$f":"F74-G74","v":0}]
[null,"Air Travel",0,0,{"$f":"C75-D75","v":0},0,0,{"$f":"F75-G75","v":0}]
[null,"Camping",0,0,0,0,0,0]
["FINANCE PENALTIES"]
[null,"Miscellaneous Fees",0,0,0,0,0,{"$f":"F78-G78","v":0}]
[null,"VARIABLE EXPENSES-Sub Total",{"$f":"SUM(C18:C78)","v":1124.5999999999999},{"$f":"SUM(D17:D78)","v":0},{"$f":"C79-D79","v":1124.5999999999999},{"$f":"SUM(F18:F78)","v":0},{"$f":"SUM(G17:G78)","v":0},{"$f":"F79-G79","v":0}]
[null,"TOTAL VARIABLE (SAVINGS + COSTS)",{"$f":"C14+C79","v":1244.5999999999999},{"$f":"D14+D79","v":0},{"$f":"C80-D80","v":1244.5999999999999},{"$f":"F14+F79","v":0},{"$f":"G14+G79","v":0},{"$f":"F80-G80","v":0}]
[null,"Funds Available for FIXED COSTS",{"$f":"C9-C80","v":2455.4},{"$f":"D5-D80","v":0},{"$f":"D81-C81","v":-2455.4},{"$f":"F5-F80","v":0},{"$f":"G5-G80","v":0},{"$f":"G81-F81","v":0}]
[]
[null,"FIXED COSTS"]
["AUTO"]
[null,"Car Payment",0,0,{"$f":"C85-D85","v":0},0,0,{"$f":"F85-G85","v":0}]
[null,"Auto Insurance",78.39,0,{"$f":"C86-D86","v":78.39},0,0,{"$f":"F86-G86","v":0}]
["HOUSING",null,null,null,0,null,null,0]
[null,"Mortgage/Rent",634,0,634,0,0,0]
[null,"Storage Space",69,0,{"$f":"C89-D89","v":69},0,0,{"$f":"F89-G89","v":0}]
["INTERNET/PHONE",null,null,null,0,null,null,0]
[null,"Phone",96,0,96,0,0,0]
[null,"Internet",41.99,0,41.99,0,0,0]
["INSURANCES",null,null,null,0,null,null,0]
[null,"Health",0,0,0,0,0,0]
[null,"Life",23.37,0,23.37,0,0,0]
[null,"TOTAL FIXED COSTS",{"$f":"SUM(C84:C95)","v":942.75},{"$f":"SUM(D84:D95)","v":0},{"$f":"C96-D96","v":942.75},{"$f":"SUM(F84:F95)","v":0},{"$f":"SUM(G84:G95)","v":0},{"$f":"F96-G96","v":0}]
[null,"TOTAL COSTS",{"$f":"C96+C80","v":2187.35},{"$f":"D96+D80","v":0},{"$f":"C97-D97","v":2187.35},{"$f":"F96+F80","v":0},{"$f":"G96+G80","v":0},{"$f":"F97-G97","v":0}]
[null,"EXCESS OF INCOME/(EXPENSES)",{"$f":"C81-C96","v":1512.65},{"$f":"D81-D96","v":0},{"$f":"D98-C98","v":-1512.65},{"$f":"F81-F96","v":0},{"$f":"G81-G96","v":0},{"$f":"G98-F98","v":0}]

{"sheet":"PIVOT","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}