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

{"sheet":"Monthly Family Budget","index":0,"n_rows":68,"n_cols":9,"rows_kept":68,"merged":[[0,0,0,6],[2,0,2,1],[2,5,2,6],[8,5,8,6],[18,0,18,3],[27,5,27,8],[29,0,29,3],[36,0,36,3],[37,5,37,8],[42,0,42,3],[44,5,44,8],[54,0,54,3],[54,5,54,8],[61,0,61,3],[62,5,62,8]]}
["Monthly Family Budget"]
[]
["Total Projected Cost",null,"Total Actual Cost","Total Difference",null,"Projected Monthly Income"]
[null,{"$f":"Housing[[#Totals],[Projected Cost]]+Transportation[[#Totals],[Projected Cost]]+Insurance[[#Totals],[Projected Cost]]+Food[[#Totals],[Projected Cost]]+Children[[#Totals],[Projected Cost]]+Legal[[#Totals],[Projected Cost]]+Savings[[#Totals],[Projected Cost]]+Loans[[#Totals],[Projected Cost]]+Entertainment[[#Totals],[Projected Cost]]+Taxes[[#Totals],[Projected Cost]]+PersonalCare[[#Totals],[Projected Cost]]+Pets[[#Totals],[Projected Cost]]+Gifts[[#Totals],[Projected Cost]]","v":{"v":1203,"d":"$1,203"}},{"$f":"Housing[[#Totals],[Actual Cost]]+Transportation[[#Totals],[Actual Cost]]+Insurance[[#Totals],[Actual Cost]]+Food[[#Totals],[Actual Cost]]+Children[[#Totals],[Actual Cost]]+Legal[[#Totals],[Actual Cost]]+Savings[[#Totals],[Actual Cost]]+Loans[[#Totals],[Actual Cost]]+Entertainment[[#Totals],[Actual Cost]]+Taxes[[#Totals],[Actual Cost]]+PersonalCare[[#Totals],[Actual Cost]]+Pets[[#Totals],[Actual Cost]]+Gifts[[#Totals],[Actual Cost]]","v":{"v":1317,"d":"$1,317"}},{"$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":{"v":-114,"d":"($114)"}},null,"Income 1",{"v":4000,"d":"$4,000"}]
[{"$nulls":5},"Income 2",{"v":1200,"d":"$1,200"}]
["Housing","Projected Cost","Actual Cost","Difference",null,"Extra income",{"v":300,"d":"$300"}]
["Mortgage or rent",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Total monthly income",{"$f":"SUM(G4:G6)","v":{"v":5500,"d":"$5,500"}}]
["Second mortgage or rent",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Phone",{"v":62,"d":"$62"},{"v":100,"d":"$100"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":-38,"d":"-$38"}},null,"Actual Monthly Income"]
["Electricity",{"v":44,"d":"$44"},{"v":125,"d":"$125"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":-81,"d":"-$81"}},null,"Income 1",{"v":4000,"d":"$4,000"}]
["Gas",{"v":22,"d":"$22"},{"v":35,"d":"$35"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":-13,"d":"-$13"}},null,"Income 2",{"v":1200,"d":"$1,200"}]
["Water and sewer",{"v":8,"d":"$8"},{"v":8,"d":"$8"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Extra income",{"v":300,"d":"$300"}]
["Cable",{"v":34,"d":"$34"},{"v":39,"d":"$39"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":-5,"d":"-$5"}},null,"Total monthly income",{"$f":"SUM(G10:G12)","v":{"v":5500,"d":"$5,500"}}]
["Waste removal",{"v":10,"d":"$10"},{"v":10,"d":"$10"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Maintenance or repairs",{"v":23,"d":"$23"},{"v":0,"d":"$0"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":23,"d":"$23"}},null,"Projected balance\n",{"$f":"SUM(G7-B4)","v":{"v":4297,"d":"$4,297"}}]
["Supplies",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Actual balance",{"$f":"SUM(G13-C4)","v":{"v":4183,"d":"$4,183"}}]
["Other",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Difference",{"$f":"SUM(G16-G15)","v":{"v":-114,"d":"($114)"}}]
["Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":1203,"d":"$1,203"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":1317,"d":"$1,317"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":-114,"d":"($114)"}}]
[]
["Transportation","Projected Cost","Actual Cost","Difference",null,"Loans","Projected Cost","Actual Cost","Difference"]
["Vehicle 1 payment",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Personal",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Vehicle 2 payment",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Student",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Bus/taxi fare",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Credit card",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Insurance",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Credit card",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Licensing",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Credit card",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Fuel",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Maintenance",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}}]
["Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}},null,"Entertainment","Projected Cost","Actual Cost","Difference"]
[{"$nulls":5},"Video/DVD",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Insurance","Projected Cost","Actual Cost","Difference",null,"CDs",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Home",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Movies",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Health",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Concerts",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Life",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Sporting events",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Live theater",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}},null,"Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}}]
["Food","Projected Cost","Actual Cost","Difference"]
["Groceries",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Taxes","Projected Cost","Actual Cost","Difference"]
["Dining out",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Federal",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"State",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}},null,"Local",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Children","Projected Cost","Actual Cost","Difference",null,"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}}]
["Medical",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Clothing",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Personal Care","Projected Cost","Actual Cost","Difference"]
["School tuition",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Medical",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["School supplies",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Hair/nails",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Organization dues or fees",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Clothing",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Lunch money",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Dry cleaning",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Child care",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Health club",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Toys/games",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Organization dues/fees",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}}]
[]
["Legal","Projected Cost","Actual Cost","Difference",null,"Pets","Projected Cost","Actual Cost","Difference"]
["Attorney",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Food",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Alimony",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Medical",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Payments",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Grooming",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Toys",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}},null,"Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}}]
["Savings/Investments","Projected Cost","Actual Cost","Difference"]
["Retirement account",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Gifts and Donations","Projected Cost","Actual Cost","Difference"]
["Investment account",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Charity 1",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["College",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Charity 2",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Charity 3",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
["Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}}]