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

{"sheet":"Monthly Family Budget","index":0,"n_rows":68,"n_cols":17,"rows_kept":68,"merged":[[0,1,0,7],[2,1,2,2],[2,6,2,7],[7,19,7,20],[8,6,8,7],[10,16,10,17],[13,19,13,20],[16,16,16,17],[18,1,18,4],[29,1,29,4],[36,1,36,4],[42,1,42,4],[54,1,54,4],[61,1,61,4]]}
[]
[]
[null,"Total Projected Cost",null,"Total Actual Cost","Total Difference",null,"Projected Monthly Income"]
[null,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":3941,"d":"$3,941"}},{"$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":4034,"d":"$4,034"}},{"$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":-93,"d":"($93)"}},null,"Income 1",{"v":1500,"d":"$1,500"}]
[{"$nulls":6},"Income 2",{"v":1200,"d":"$1,200"}]
[null,"Housing","Projected Cost","Actual Cost","Difference",null,"Extra income",{"v":300,"d":"$300"}]
[null,"Second mortgage or rent",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Total monthly income",{"$f":"SUM(H4:H6)","v":{"v":3000,"d":"$3,000"}}]
[null,"Supplies",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Other",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Actual Monthly Income",{"$nulls":3},"  "]
[null,"Water and sewer",{"v":8,"d":"$8"},{"v":8,"d":"$8"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Income 1",{"v":4000,"d":"$4,000"}]
[null,"Waste removal",{"v":10,"d":"$10"},{"v":10,"d":"$10"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Income 2",{"v":1200,"d":"$1,200"}]
[null,"Maintenance or repairs",{"v":23,"d":"$23"},{"v":23,"d":"$23"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Extra income",{"v":300,"d":"$300"}]
[null,"Gas",{"v":22,"d":"$22"},{"v":35,"d":"$35"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":-13,"d":"-$13"}},null,"Total monthly income",{"$f":"SUM(H10:H12)","v":{"v":5500,"d":"$5,500"}}]
[null,"Cable",{"v":34,"d":"$34"},{"v":34,"d":"$34"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Phone",{"v":120,"d":"$120"},{"v":120,"d":"$120"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Projected balance\n",{"$f":"SUM(H7-C4)","v":{"v":-941,"d":"($941)"}}]
[null,"Electricity",{"v":44,"d":"$44"},{"v":44,"d":"$44"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Actual balance",{"$f":"SUM(H13-D4)","v":{"v":1466,"d":"$1,466"}}]
[null,"Mortgage or rent",{"v":1100,"d":"$1,100"},{"v":1100,"d":"$1,100"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Difference",{"$f":"SUM(H16-H15)","v":{"v":2407,"d":"$2,407"}}]
[null,"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":1361,"d":"$1,361"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":1374,"d":"$1,374"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":-13,"d":"($13)"}}]
[]
[null,"Transportation","Projected Cost","Actual Cost","Difference",null,"Entertainment","Projected Cost","Actual Cost","Difference"]
[null,"Vehicle 1 payment",{"v":350,"d":"$350"},{"v":350,"d":"$350"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Video/DVD",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Vehicle 2 payment",{"v":200,"d":"$200"},{"v":200,"d":"$200"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"CDs",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Bus/taxi fare",{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Movies",{"v":50,"d":"$50"},{"v":50,"d":"$50"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Fuel",{"v":60,"d":"$60"},{"v":60,"d":"$60"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Concerts",{"v":300,"d":"$300"},{"v":300,"d":"$300"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},{"$nulls":5},"housing",1300]
[null,"Insurance",{"v":50,"d":"$50"},{"v":50,"d":"$50"},{"$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"}},{"$nulls":5},"transportation",800]
[null,"Maintenance",{"v":20,"d":"$20"},{"v":0,"d":"$0"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":20,"d":"$20"}},null,"Live theater",{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},{"$nulls":5},"insurance",500]
[null,"Licensing",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"}},{"$nulls":5},"food",700]
[null,"Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":450,"d":"$450"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":450,"d":"$450"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}},{"$nulls":5},"children",500]
[null,"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":780,"d":"$780"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":760,"d":"$760"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":20,"d":"$20"}},{"$nulls":10},"entertainment",500]
[{"$nulls":6},"Gifts and Donations","Projected Cost","Actual Cost","Difference",{"$nulls":5},"gifts",400]
[null,"Insurance","Projected Cost","Actual Cost","Difference",null,"Charity 1",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},{"$nulls":5},"pets",800]
[null,"Home",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"}},{"$nulls":5},"personal care",200]
[null,"Health",{"v":50,"d":"$50"},{"v":50,"d":"$50"},{"$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"}},{"$nulls":5},"savings",500]
[null,"Life",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"}}]
[null,"Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":50,"d":"$50"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":50,"d":"$50"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}},null,"Pets","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Food",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Food","Projected Cost","Actual Cost","Difference",null,"Medical",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Groceries",{"v":200,"d":"$200"},{"v":300,"d":"$300"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":-100,"d":"-$100"}},null,"Grooming",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Dining out",{"v":500,"d":"$500"},{"v":200,"d":"$200"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":300,"d":"$300"}},null,"Toys",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"}},null,"Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":700,"d":"$700"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":500,"d":"$500"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":200,"d":"$200"}},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"}}]
[]
[null,"Children","Projected Cost","Actual Cost","Difference",null,"Personal Care","Projected Cost","Actual Cost","Difference"]
[null,"Medical",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"}}]
[null,"Clothing",{"v":200,"d":"$200"},{"v":200,"d":"$200"},{"$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"}}]
[null,"School tuition",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Clothing",{"v":100,"d":"$100"},{"v":400,"d":"$400"},{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":-300,"d":"-$300"}}]
[null,"School supplies",{"v":200,"d":"$200"},{"v":200,"d":"$200"},{"$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"}}]
[null,"Organization dues or fees",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"}}]
[null,"Lunch money",{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"$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"}}]
[null,"Child care",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"}}]
[null,"Toys/games",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":100,"d":"$100"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":400,"d":"$400"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":-300,"d":"($300)"}}]
[null,"Other",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,[Projected Cost])","v":{"v":500,"d":"$500"}},{"$f":"SUBTOTAL(109,[Actual Cost])","v":{"v":500,"d":"$500"}},{"$f":"SUBTOTAL(109,[Difference])","v":{"v":0,"d":"$0"}},null,"Loans","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Personal",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Legal","Projected Cost","Actual Cost","Difference",null,"Student",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Attorney",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"}}]
[null,"Alimony",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"}}]
[null,"Payments",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"}}]
[null,"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"}}]
[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"}},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"}}]
[]
[null,"Savings/Investments","Projected Cost","Actual Cost","Difference",null,"Taxes","Projected Cost","Actual Cost","Difference"]
[null,"Retirement account",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"}}]
[null,"Investment account",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"}}]
[null,"College",null,null,{"$f":"[Projected Cost]-[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Local",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"}},null,"Other",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"}},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"}}]