{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Monthly Family Budget"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":"Monthly Family Budget","index":0,"n_rows":82,"n_cols":10,"rows_kept":82,"cut":false,"hidden":false,"merged":[[1,1,1,7],[22,6,22,9],[53,6,53,9],[3,6,3,7],[9,6,9,7],[15,6,15,7],[2,1,2,7]]}
[]
[null,"Monthly Budget"]
[]
[null,"Summary ","Total\nProjected Cost","Total\nActual Cost","Total\nDifference",null,"Projected Monthly Income Source"]
[null,null,{"$f":"Housing[[#Totals],[Projected\nCost]]+Transportation[[#Totals],[Projected\nCost]]+Insurance[[#Totals],[Projected\nCost]]+Food[[#Totals],[Projected\nCost]]+Children[[#Totals],[Projected\nCost]]+Legal[[#Totals],[Projected\nCost]]+Savings[[#Totals],[Projected\nCost]]+Loans[[#Totals],[Projected\nCost]]+Entertainment[[#Totals],[Projected\nCost]]+Taxes[[#Totals],[Projected \nCost]]+PersonalCare[[#Totals],[Projected\nCost]]+Pets[[#Totals],[Projected\nCost]]+Gifts[[#Totals],[Projected\nCost]]","v":0},{"$f":"Housing[[#Totals],[Actual\nCost]]+Transportation[[#Totals],[Actual\nCost]]+Insurance[[#Totals],[Actual\nCost]]+Food[[#Totals],[Actual\nCost]]+Children[[#Totals],[Actual\nCost]]+Legal[[#Totals],[Actual\nCost]]+Savings[[#Totals],[Actual\nCost]]+Loans[[#Totals],[Actual\nCost]]+Entertainment[[#Totals],[Actual\nCost]]+Taxes[[#Totals],[Actual \nCost]]+PersonalCare[[#Totals],[Actual\nCost]]+Pets[[#Totals],[Actual\nCost]]+Gifts[[#Totals],[Actual\nCost]]","v":0},{"$f":"Housing[[#Totals],[Difference]]+Transportation[[#Totals],[Difference]]+Insurance[[#Totals],[Difference]]+Food[[#Totals],[Difference]]+Children[[#Totals],[Difference]]+Legal[[#Totals],[Difference]]+Savings[[#Totals],[Difference]]+Loans[[#Totals],[Difference]]+Entertainment[[#Totals],[Difference]]+Taxes[[#Totals],[Difference]]+PersonalCare[[#Totals],[Difference]]+Pets[[#Totals],[Difference]]+Gifts[[#Totals],[Difference]]","v":0},null,"Income 1",0]
[null,null,null,null,null,null,"Income 2",0]
[null,null,null,null,null,null,"Extra income",0]
[null,"Housing",null,null,null,null,"Total monthly income",{"$f":"SUM(H5:H7)","v":0}]
[null,"Housing","Projected\nCost","Actual\nCost","Difference"]
[null,"Mortgage or rent",0,0,{"$f":"Housing[[#This Row],[Projected\nCost]]-Housing[[#This Row],[Actual\nCost]]","v":0},null,"Actual Monthly Income Source"]
[null,"Second mortgage or rent",0,0,{"$f":"Housing[[#This Row],[Projected\nCost]]-Housing[[#This Row],[Actual\nCost]]","v":0},null,"Income 1",0]
[null,"Phone",0,0,{"$f":"Housing[[#This Row],[Projected\nCost]]-Housing[[#This Row],[Actual\nCost]]","v":0},null,"Income 2",0]
[null,"Electricity",0,0,{"$f":"Housing[[#This Row],[Projected\nCost]]-Housing[[#This Row],[Actual\nCost]]","v":0},null,"Extra income",0]
[null,"Gas",0,0,{"$f":"Housing[[#This Row],[Projected\nCost]]-Housing[[#This Row],[Actual\nCost]]","v":0},null,"Total monthly income",{"$f":"SUM(H11:H13)","v":0}]
[null,"Water and sewer",0,0,{"$f":"Housing[[#This Row],[Projected\nCost]]-Housing[[#This Row],[Actual\nCost]]","v":0}]
[null,"Cable",0,0,{"$f":"Housing[[#This Row],[Projected\nCost]]-Housing[[#This Row],[Actual\nCost]]","v":0},null,"Balance"]
[null,"Waste removal",0,0,{"$f":"Housing[[#This Row],[Projected\nCost]]-Housing[[#This Row],[Actual\nCost]]","v":0},null,"Projected balance",{"$f":"SUM(H8-'Monthly Family Budget'!$C$5:$C$5)","v":0}]
[null,"Maintenance or repairs",0,0,{"$f":"Housing[[#This Row],[Projected\nCost]]-Housing[[#This Row],[Actual\nCost]]","v":0},null,"Actual balance",{"$f":"SUM(H14-D5)","v":0}]
[null,"Supplies",0,0,{"$f":"Housing[[#This Row],[Projected\nCost]]-Housing[[#This Row],[Actual\nCost]]","v":0},null,"Difference",{"$f":"SUM(H18-H17)","v":0}]
[null,"Other",0,0,{"$f":"Housing[[#This Row],[Projected\nCost]]-Housing[[#This Row],[Actual\nCost]]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Housing[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,Housing[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,Housing[Difference])","v":0}]
[]
[null,"Transportation",null,null,null,null,"Loans"]
[null,"Column1","Projected\nCost","Actual\nCost","Difference",null,"Loans","Projected\nCost","Actual\nCost","Difference"]
[null,"Vehicle 1 payment",null,null,{"$f":"Transportation[[#This Row],[Projected\nCost]]-Transportation[[#This Row],[Actual\nCost]]","v":0},null,"Personal",null,null,{"$f":"Loans[[#This Row],[Projected\nCost]]-Loans[[#This Row],[Actual\nCost]]","v":0}]
[null,"Vehicle 2 payment",null,null,{"$f":"Transportation[[#This Row],[Projected\nCost]]-Transportation[[#This Row],[Actual\nCost]]","v":0},null,"Student",null,null,{"$f":"Loans[[#This Row],[Projected\nCost]]-Loans[[#This Row],[Actual\nCost]]","v":0}]
[null,"Bus/taxi fare",null,null,{"$f":"Transportation[[#This Row],[Projected\nCost]]-Transportation[[#This Row],[Actual\nCost]]","v":0},null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected\nCost]]-Loans[[#This Row],[Actual\nCost]]","v":0}]
[null,"Insurance",null,null,{"$f":"Transportation[[#This Row],[Projected\nCost]]-Transportation[[#This Row],[Actual\nCost]]","v":0},null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected\nCost]]-Loans[[#This Row],[Actual\nCost]]","v":0}]
[null,"Licensing",null,null,{"$f":"Transportation[[#This Row],[Projected\nCost]]-Transportation[[#This Row],[Actual\nCost]]","v":0},null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected\nCost]]-Loans[[#This Row],[Actual\nCost]]","v":0}]
[null,"Fuel",null,null,{"$f":"Transportation[[#This Row],[Projected\nCost]]-Transportation[[#This Row],[Actual\nCost]]","v":0},null,"Other",null,null,{"$f":"Loans[[#This Row],[Projected\nCost]]-Loans[[#This Row],[Actual\nCost]]","v":0}]
[null,"Maintenance",null,null,{"$f":"Transportation[[#This Row],[Projected\nCost]]-Transportation[[#This Row],[Actual\nCost]]","v":0},null,"Total",{"$f":"SUBTOTAL(109,Loans[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,Loans[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,Loans[Difference])","v":0}]
[null,"Other",null,null,{"$f":"Transportation[[#This Row],[Projected\nCost]]-Transportation[[#This Row],[Actual\nCost]]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Transportation[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,Transportation[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,Transportation[Difference])","v":0}]
[]
[null,"Insurance",null,null,null,null,"Entertainment"]
[null,"Insurance","Projected\nCost","Actual\nCost","Difference",null,"Entertainment","Projected\nCost","Actual\nCost","Difference"]
[null,"Home",null,null,{"$f":"Insurance[[#This Row],[Projected\nCost]]-Insurance[[#This Row],[Actual\nCost]]","v":0},null,"Video/DVD",null,null,{"$f":"Entertainment[[#This Row],[Projected\nCost]]-Entertainment[[#This Row],[Actual\nCost]]","v":0}]
[null,"Health",null,null,{"$f":"Insurance[[#This Row],[Projected\nCost]]-Insurance[[#This Row],[Actual\nCost]]","v":0},null,"CDs",null,null,{"$f":"Entertainment[[#This Row],[Projected\nCost]]-Entertainment[[#This Row],[Actual\nCost]]","v":0}]
[null,"Life",null,null,{"$f":"Insurance[[#This Row],[Projected\nCost]]-Insurance[[#This Row],[Actual\nCost]]","v":0},null,"Movies",null,null,{"$f":"Entertainment[[#This Row],[Projected\nCost]]-Entertainment[[#This Row],[Actual\nCost]]","v":0}]
[null,"Other",null,null,{"$f":"Insurance[[#This Row],[Projected\nCost]]-Insurance[[#This Row],[Actual\nCost]]","v":0},null,"Concerts",null,null,{"$f":"Entertainment[[#This Row],[Projected\nCost]]-Entertainment[[#This Row],[Actual\nCost]]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Insurance[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,Insurance[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,Insurance[Difference])","v":0},null,"Sporting events",null,null,{"$f":"Entertainment[[#This Row],[Projected\nCost]]-Entertainment[[#This Row],[Actual\nCost]]","v":0}]
[null,null,null,null,null,null,"Live theater",null,null,{"$f":"Entertainment[[#This Row],[Projected\nCost]]-Entertainment[[#This Row],[Actual\nCost]]","v":0}]
[null,null,null,null,null,null,"Other",null,null,{"$f":"Entertainment[[#This Row],[Projected\nCost]]-Entertainment[[#This Row],[Actual\nCost]]","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUBTOTAL(109,Entertainment[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,Entertainment[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,Entertainment[Difference])","v":0}]
[]
[null,"Food",null,null,null,null,"Taxes"]
[null,"Column1","Projected\nCost","Actual\nCost","Difference",null,"Taxes","Projected \nCost","Actual \nCost","Difference"]
[null,"Groceries",null,null,{"$f":"Food[[#This Row],[Projected\nCost]]-Food[[#This Row],[Actual\nCost]]","v":0},null,"Federal",null,null,{"$f":"Taxes[[#This Row],[Projected \nCost]]-Taxes[[#This Row],[Actual \nCost]]","v":0}]
[null,"Dining out",null,null,{"$f":"Food[[#This Row],[Projected\nCost]]-Food[[#This Row],[Actual\nCost]]","v":0},null,"State",null,null,{"$f":"Taxes[[#This Row],[Projected \nCost]]-Taxes[[#This Row],[Actual \nCost]]","v":0}]
[null,"Other",null,null,{"$f":"Food[[#This Row],[Projected\nCost]]-Food[[#This Row],[Actual\nCost]]","v":0},null,"Local",null,null,{"$f":"Taxes[[#This Row],[Projected \nCost]]-Taxes[[#This Row],[Actual \nCost]]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Food[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,Food[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,Food[Difference])","v":0},null,"Other",null,null,{"$f":"Taxes[[#This Row],[Projected \nCost]]-Taxes[[#This Row],[Actual \nCost]]","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUBTOTAL(109,Taxes[Projected \nCost])","v":0},{"$f":"SUBTOTAL(109,Taxes[Actual \nCost])","v":0},{"$f":"SUBTOTAL(109,Taxes[Difference])","v":0}]
[]
[null,"Children",null,null,null,null,"Personal Care"]
[null,"Children","Projected\nCost","Actual\nCost","Difference",null,"Personal Care","Projected\nCost","Actual\nCost","Difference"]
[null,"Medical",null,null,{"$f":"Children[[#This Row],[Projected\nCost]]-Children[[#This Row],[Actual\nCost]]","v":0},null,"Medical",null,null,{"$f":"PersonalCare[[#This Row],[Projected\nCost]]-PersonalCare[[#This Row],[Actual\nCost]]","v":0}]
[null,"Clothing",null,null,{"$f":"Children[[#This Row],[Projected\nCost]]-Children[[#This Row],[Actual\nCost]]","v":0},null,"Hair/nails",null,null,{"$f":"PersonalCare[[#This Row],[Projected\nCost]]-PersonalCare[[#This Row],[Actual\nCost]]","v":0}]
[null,"School tuition",null,null,{"$f":"Children[[#This Row],[Projected\nCost]]-Children[[#This Row],[Actual\nCost]]","v":0},null,"Clothing",null,null,{"$f":"PersonalCare[[#This Row],[Projected\nCost]]-PersonalCare[[#This Row],[Actual\nCost]]","v":0}]
[null,"School supplies",null,null,{"$f":"Children[[#This Row],[Projected\nCost]]-Children[[#This Row],[Actual\nCost]]","v":0},null,"Dry cleaning",null,null,{"$f":"PersonalCare[[#This Row],[Projected\nCost]]-PersonalCare[[#This Row],[Actual\nCost]]","v":0}]
[null,"Organization dues/fees",null,null,{"$f":"Children[[#This Row],[Projected\nCost]]-Children[[#This Row],[Actual\nCost]]","v":0},null,"Health club",null,null,{"$f":"PersonalCare[[#This Row],[Projected\nCost]]-PersonalCare[[#This Row],[Actual\nCost]]","v":0}]
[null,"Lunch money",null,null,{"$f":"Children[[#This Row],[Projected\nCost]]-Children[[#This Row],[Actual\nCost]]","v":0},null,"Organization dues/fees",null,null,{"$f":"PersonalCare[[#This Row],[Projected\nCost]]-PersonalCare[[#This Row],[Actual\nCost]]","v":0}]
[null,"Child care",null,null,{"$f":"Children[[#This Row],[Projected\nCost]]-Children[[#This Row],[Actual\nCost]]","v":0},null,"Other",null,null,{"$f":"PersonalCare[[#This Row],[Projected\nCost]]-PersonalCare[[#This Row],[Actual\nCost]]","v":0}]
[null,"Toys/games",null,null,{"$f":"Children[[#This Row],[Projected\nCost]]-Children[[#This Row],[Actual\nCost]]","v":0},null,"Total",{"$f":"SUBTOTAL(109,PersonalCare[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,PersonalCare[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,PersonalCare[Difference])","v":0}]
[null,"Other",null,null,{"$f":"Children[[#This Row],[Projected\nCost]]-Children[[#This Row],[Actual\nCost]]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Children[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,Children[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,Children[Difference])","v":0}]
[]
[null,"Legal",null,null,null,null,"Pets"]
[null,"Legal","Projected\nCost","Actual\nCost","Difference",null,"Pets","Projected\nCost","Actual\nCost","Difference"]
[null,"Attorney",null,null,{"$f":"Legal[[#This Row],[Projected\nCost]]-Legal[[#This Row],[Actual\nCost]]","v":0},null,"Food",null,null,{"$f":"Pets[[#This Row],[Projected\nCost]]-Pets[[#This Row],[Actual\nCost]]","v":0}]
[null,"Alimony",null,null,{"$f":"Legal[[#This Row],[Projected\nCost]]-Legal[[#This Row],[Actual\nCost]]","v":0},null,"Medical",null,null,{"$f":"Pets[[#This Row],[Projected\nCost]]-Pets[[#This Row],[Actual\nCost]]","v":0}]
[null,"Payments",null,null,{"$f":"Legal[[#This Row],[Projected\nCost]]-Legal[[#This Row],[Actual\nCost]]","v":0},null,"Grooming",null,null,{"$f":"Pets[[#This Row],[Projected\nCost]]-Pets[[#This Row],[Actual\nCost]]","v":0}]
[null,"Other",null,null,{"$f":"Legal[[#This Row],[Projected\nCost]]-Legal[[#This Row],[Actual\nCost]]","v":0},null,"Toys",null,null,{"$f":"Pets[[#This Row],[Projected\nCost]]-Pets[[#This Row],[Actual\nCost]]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Legal[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,Legal[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,Legal[Difference])","v":0},null,"Other",null,null,{"$f":"Pets[[#This Row],[Projected\nCost]]-Pets[[#This Row],[Actual\nCost]]","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUBTOTAL(109,Pets[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,Pets[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,Pets[Difference])","v":0}]
[]
[null,"Savings/Investments",null,null,null,null,"Gifts and Donations"]
[null,"Savings/Investments","Projected\nCost","Actual\nCost","Difference",null,"Gifts and Donations","Projected\nCost","Actual\nCost","Difference"]
[null,"Retirement account",null,null,{"$f":"Savings[[#This Row],[Projected\nCost]]-Savings[[#This Row],[Actual\nCost]]","v":0},null,"Charity 1",null,null,{"$f":"Gifts[[#This Row],[Projected\nCost]]-Gifts[[#This Row],[Actual\nCost]]","v":0}]
[null,"Investment account",null,null,{"$f":"Savings[[#This Row],[Projected\nCost]]-Savings[[#This Row],[Actual\nCost]]","v":0},null,"Charity 2",null,null,{"$f":"Gifts[[#This Row],[Projected\nCost]]-Gifts[[#This Row],[Actual\nCost]]","v":0}]
[null,"College",null,null,{"$f":"Savings[[#This Row],[Projected\nCost]]-Savings[[#This Row],[Actual\nCost]]","v":0},null,"Charity 3",null,null,{"$f":"Gifts[[#This Row],[Projected\nCost]]-Gifts[[#This Row],[Actual\nCost]]","v":0}]
[null,"Other",null,null,{"$f":"Savings[[#This Row],[Projected\nCost]]-Savings[[#This Row],[Actual\nCost]]","v":0},null,"Total",{"$f":"SUBTOTAL(109,Gifts[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,Gifts[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,Gifts[Difference])","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Savings[Projected\nCost])","v":0},{"$f":"SUBTOTAL(109,Savings[Actual\nCost])","v":0},{"$f":"SUBTOTAL(109,Savings[Difference])","v":0}]