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

{"sheet":"Budget Planner","index":0,"n_rows":136,"n_cols":7,"rows_kept":136,"merged":[[15,1,15,5],[22,1,22,5],[36,2,36,5],[47,2,47,5],[54,2,54,5],[60,2,60,5],[72,2,72,5],[80,2,80,5],[90,2,90,5],[100,2,100,5],[109,2,109,5],[116,2,116,5],[123,2,123,5],[129,2,129,5],[136,2,136,5]]}
[{"$nulls":6}," "]
[{"$nulls":6}," "]
[]
[]
[]
[{"$nulls":6}," "]
[]
[]
[{"$nulls":6}," "]
[]
[]
[null,"  ","Cash Flow","Projected","Actual","Variance"]
[null,null,"Total Income",{"$f":"SUM(Income[Projected])","v":{"v":5600,"d":"5,600"}},{"$f":"SUM(Income[Actual])","v":{"v":4700,"d":"4,700"}},{"$f":"SUM(Income[Variance])","v":-900}]
[null,null,"Total Expense",{"$f":"totalExpenseProjected","v":{"v":1195,"d":"1,195"}},{"$f":"totalExpenseActual","v":737},{"$f":"CashFlow[[#This Row],[Projected]]-CashFlow[[#This Row],[Actual]]","v":458}]
[null,null,"TOTAL CASH FLOW",{"$f":"D13-D14","v":{"v":4405,"d":"4,405"}},{"$f":"E13-E14","v":{"v":3963,"d":"3,963"}},{"$f":"CashFlow[[#This Row],[Actual]]-CashFlow[[#This Row],[Projected]]","v":-442}]
[]
[null," ","Monthly Income","Projected","Actual","Variance"]
[null,null,"Income 1",{"v":4000,"d":"4,000"},{"v":3000,"d":"3,000"},{"$f":"Income[[#This Row],[Actual]]-Income[[#This Row],[Projected]]","v":{"v":-1000,"d":"-1,000"}}]
[null,null,"Income 2",{"v":1300,"d":"1,300"},{"v":1400,"d":"1,400"},{"$f":"Income[[#This Row],[Actual]]-Income[[#This Row],[Projected]]","v":100}]
[null,null,"Extra income",300,300,{"$f":"Income[[#This Row],[Actual]]-Income[[#This Row],[Projected]]","v":0}]
[null,null,"Other",null,null,{"$f":"Income[[#This Row],[Actual]]-Income[[#This Row],[Projected]]","v":0}]
[null,null,"TOTAL INCOME",{"$f":"SUBTOTAL(109,Income[Projected])","v":{"v":5600,"d":"5,600"}},{"$f":"SUBTOTAL(109,Income[Actual])","v":{"v":4700,"d":"4,700"}},{"$f":"SUBTOTAL(109,Income[Variance])","v":-900}]
[]
[null,null,"Housing Expense","Projected","Actual","Variance"]
[null,null,"Mortgage or rent",{"v":1000,"d":"1,000"},500,{"$f":"Housing[[#This Row],[Projected]]-Housing[[#This Row],[Actual]]","v":500}]
[null,null,"Second mortgage or rent",0,0,{"$f":"Housing[[#This Row],[Projected]]-Housing[[#This Row],[Actual]]","v":0}]
[null,null,"Phone",54,100,{"$f":"Housing[[#This Row],[Projected]]-Housing[[#This Row],[Actual]]","v":-46}]
[null,null,"Electricity",44,56,{"$f":"Housing[[#This Row],[Projected]]-Housing[[#This Row],[Actual]]","v":-12}]
[null,null,"Gas",22,28,{"$f":"Housing[[#This Row],[Projected]]-Housing[[#This Row],[Actual]]","v":-6}]
[null,null,"Water and sewer",8,8,{"$f":"Housing[[#This Row],[Projected]]-Housing[[#This Row],[Actual]]","v":0}]
[null,null,"Cable",34,34,{"$f":"Housing[[#This Row],[Projected]]-Housing[[#This Row],[Actual]]","v":0}]
[null,null,"Waste removal",10,10,{"$f":"Housing[[#This Row],[Projected]]-Housing[[#This Row],[Actual]]","v":0}]
[null,null,"Maintenance or repairs",23,0,{"$f":"Housing[[#This Row],[Projected]]-Housing[[#This Row],[Actual]]","v":23}]
[null,null,"Supplies",0,0,{"$f":"Housing[[#This Row],[Projected]]-Housing[[#This Row],[Actual]]","v":0}]
[null,null,"Other",0,0,{"$f":"Housing[[#This Row],[Projected]]-Housing[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Housing[Projected])","v":{"v":1195,"d":"1,195"}},{"$f":"SUBTOTAL(109,Housing[Actual])","v":736},{"$f":"SUBTOTAL(109,Housing[Variance])","v":459}]
[]
[null,null,"Transportation","Projected","Actual","Variance"]
[null,null,"Vehicle 1 payment",null,1,{"$f":"Transportation[[#This Row],[Projected]]-Transportation[[#This Row],[Actual]]","v":-1}]
[null,null,"Vehicle 2 payment",null,null,{"$f":"Transportation[[#This Row],[Projected]]-Transportation[[#This Row],[Actual]]","v":0}]
[null,null,"Bus/taxi fare",null,null,{"$f":"Transportation[[#This Row],[Projected]]-Transportation[[#This Row],[Actual]]","v":0}]
[null,null,"Insurance",null,null,{"$f":"Transportation[[#This Row],[Projected]]-Transportation[[#This Row],[Actual]]","v":0}]
[null,null,"Licensing",null,null,{"$f":"Transportation[[#This Row],[Projected]]-Transportation[[#This Row],[Actual]]","v":0}]
[null,null,"Fuel",null,null,{"$f":"Transportation[[#This Row],[Projected]]-Transportation[[#This Row],[Actual]]","v":0}]
[null,null,"Maintenance",null,null,{"$f":"Transportation[[#This Row],[Projected]]-Transportation[[#This Row],[Actual]]","v":0}]
[null,null,"Other",null,null,{"$f":"Transportation[[#This Row],[Projected]]-Transportation[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Transportation[Projected])","v":0},{"$f":"SUBTOTAL(109,Transportation[Actual])","v":1},{"$f":"SUBTOTAL(109,Transportation[Variance])","v":-1}]
[]
[null,null,"Insurance","Projected","Actual","Variance"]
[null,null,"Home",null,null,{"$f":"Insurance[[#This Row],[Projected]]-Insurance[[#This Row],[Actual]]","v":0}]
[null,null,"Health",null,null,{"$f":"Insurance[[#This Row],[Projected]]-Insurance[[#This Row],[Actual]]","v":0}]
[null,null,"Life",null,null,{"$f":"Insurance[[#This Row],[Projected]]-Insurance[[#This Row],[Actual]]","v":0}]
[null,null,"Other",null,null,{"$f":"Insurance[[#This Row],[Projected]]-Insurance[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Insurance[Projected])","v":0},{"$f":"SUBTOTAL(109,Insurance[Actual])","v":0},{"$f":"SUBTOTAL(109,Insurance[Variance])","v":0}]
[]
[null,null,"Food","Projected","Actual","Variance"]
[null,null,"Groceries",null,null,{"$f":"Food[[#This Row],[Projected]]-Food[[#This Row],[Actual]]","v":0}]
[null,null,"Dining out",null,null,{"$f":"Food[[#This Row],[Projected]]-Food[[#This Row],[Actual]]","v":0}]
[null,null,"Other",null,null,{"$f":"Food[[#This Row],[Projected]]-Food[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Food[Projected])","v":0},{"$f":"SUBTOTAL(109,Food[Actual])","v":0},{"$f":"SUBTOTAL(109,Food[Variance])","v":0}]
[]
[null,null,"Children","Projected","Actual","Variance"]
[null,null,"Medical",null,null,{"$f":"Children[[#This Row],[Projected]]-Children[[#This Row],[Actual]]","v":0}]
[null,null,"Clothing",null,null,{"$f":"Children[[#This Row],[Projected]]-Children[[#This Row],[Actual]]","v":0}]
[null,null,"School tuition",null,null,{"$f":"Children[[#This Row],[Projected]]-Children[[#This Row],[Actual]]","v":0}]
[null,null,"School supplies",null,null,{"$f":"Children[[#This Row],[Projected]]-Children[[#This Row],[Actual]]","v":0}]
[null,null,"Organization dues or fees",null,null,{"$f":"Children[[#This Row],[Projected]]-Children[[#This Row],[Actual]]","v":0}]
[null,null,"Lunch money",null,null,{"$f":"Children[[#This Row],[Projected]]-Children[[#This Row],[Actual]]","v":0}]
[null,null,"Child care",null,null,{"$f":"Children[[#This Row],[Projected]]-Children[[#This Row],[Actual]]","v":0}]
[null,null,"Toys/games",null,null,{"$f":"Children[[#This Row],[Projected]]-Children[[#This Row],[Actual]]","v":0}]
[null,null,"Other",null,null,{"$f":"Children[[#This Row],[Projected]]-Children[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Children[Projected])","v":0},{"$f":"SUBTOTAL(109,Children[Actual])","v":0},{"$f":"SUBTOTAL(109,Children[Variance])","v":0}]
[]
[null,null,"Pets","Projected","Actual","Variance"]
[null,null,"Food",null,null,{"$f":"Pets[[#This Row],[Projected]]-Pets[[#This Row],[Actual]]","v":0}]
[null,null,"Medical",null,null,{"$f":"Pets[[#This Row],[Projected]]-Pets[[#This Row],[Actual]]","v":0}]
[null,null,"Grooming",null,null,{"$f":"Pets[[#This Row],[Projected]]-Pets[[#This Row],[Actual]]","v":0}]
[null,null,"Toys",null,null,{"$f":"Pets[[#This Row],[Projected]]-Pets[[#This Row],[Actual]]","v":0}]
[null,null,"Other",null,null,{"$f":"Pets[[#This Row],[Projected]]-Pets[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Pets[Projected])","v":0},{"$f":"SUBTOTAL(109,Pets[Actual])","v":0},{"$f":"SUBTOTAL(109,Pets[Variance])","v":0}]
[]
[null,null,"Personal Care","Projected","Actual","Variance"]
[null,null,"Medical",null,null,{"$f":"PersonalCare[[#This Row],[Projected]]-PersonalCare[[#This Row],[Actual]]","v":0}]
[null,null,"Hair/nails",null,null,{"$f":"PersonalCare[[#This Row],[Projected]]-PersonalCare[[#This Row],[Actual]]","v":0}]
[null,null,"Clothing",null,null,{"$f":"PersonalCare[[#This Row],[Projected]]-PersonalCare[[#This Row],[Actual]]","v":0}]
[null,null,"Dry cleaning",null,null,{"$f":"PersonalCare[[#This Row],[Projected]]-PersonalCare[[#This Row],[Actual]]","v":0}]
[null,null,"Health club",null,null,{"$f":"PersonalCare[[#This Row],[Projected]]-PersonalCare[[#This Row],[Actual]]","v":0}]
[null,null,"Organization dues or fees",null,null,{"$f":"PersonalCare[[#This Row],[Projected]]-PersonalCare[[#This Row],[Actual]]","v":0}]
[null,null,"Other",null,null,{"$f":"PersonalCare[[#This Row],[Projected]]-PersonalCare[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,PersonalCare[Projected])","v":0},{"$f":"SUBTOTAL(109,PersonalCare[Actual])","v":0},{"$f":"SUBTOTAL(109,PersonalCare[Variance])","v":0}]
[]
[null,null,"Entertainment","Projected","Actual","Variance"]
[null,null,"Video/DVD",null,null,{"$f":"Entertainment[[#This Row],[Projected]]-Entertainment[[#This Row],[Actual]]","v":0}]
[null,null,"CDs",null,null,{"$f":"Entertainment[[#This Row],[Projected]]-Entertainment[[#This Row],[Actual]]","v":0}]
[null,null,"Movies",null,null,{"$f":"Entertainment[[#This Row],[Projected]]-Entertainment[[#This Row],[Actual]]","v":0}]
[null,null,"Concerts",null,null,{"$f":"Entertainment[[#This Row],[Projected]]-Entertainment[[#This Row],[Actual]]","v":0}]
[null,null,"Sporting events",null,null,{"$f":"Entertainment[[#This Row],[Projected]]-Entertainment[[#This Row],[Actual]]","v":0}]
[null,null,"Live theater",null,null,{"$f":"Entertainment[[#This Row],[Projected]]-Entertainment[[#This Row],[Actual]]","v":0}]
[null,null,"Other",null,null,{"$f":"Entertainment[[#This Row],[Projected]]-Entertainment[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Entertainment[Projected])","v":0},{"$f":"SUBTOTAL(109,Entertainment[Actual])","v":0},{"$f":"SUBTOTAL(109,Entertainment[Variance])","v":0}]
[]
[null,null,"Loans","Projected","Actual","Variance"]
[null,null,"Personal",null,null,{"$f":"Loans[[#This Row],[Projected]]-Loans[[#This Row],[Actual]]","v":0}]
[null,null,"Student",null,null,{"$f":"Loans[[#This Row],[Projected]]-Loans[[#This Row],[Actual]]","v":0}]
[null,null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected]]-Loans[[#This Row],[Actual]]","v":0}]
[null,null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected]]-Loans[[#This Row],[Actual]]","v":0}]
[null,null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected]]-Loans[[#This Row],[Actual]]","v":0}]
[null,null,"Other",null,null,{"$f":"Loans[[#This Row],[Projected]]-Loans[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Loans[Projected])","v":0},{"$f":"SUBTOTAL(109,Loans[Actual])","v":0},{"$f":"SUBTOTAL(109,Loans[Variance])","v":0}]
[]
[null,null,"Taxes","Projected","Actual","Variance"]
[null,null,"Federal",null,null,{"$f":"Taxes[[#This Row],[Projected]]-Taxes[[#This Row],[Actual]]","v":0}]
[null,null,"State",null,null,{"$f":"Taxes[[#This Row],[Projected]]-Taxes[[#This Row],[Actual]]","v":0}]
[null,null,"Local",null,null,{"$f":"Taxes[[#This Row],[Projected]]-Taxes[[#This Row],[Actual]]","v":0}]
[null,null,"Other",null,null,{"$f":"Taxes[[#This Row],[Projected]]-Taxes[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Taxes[Projected])","v":0},{"$f":"SUBTOTAL(109,Taxes[Actual])","v":0},{"$f":"SUBTOTAL(109,Taxes[Variance])","v":0}]
[]
[null,null,"Savings or Investments","Projected","Actual","Variance"]
[null,null,"Retirement account",null,null,{"$f":"Savings[[#This Row],[Projected]]-Savings[[#This Row],[Actual]]","v":0}]
[null,null,"Investment account",null,null,{"$f":"Savings[[#This Row],[Projected]]-Savings[[#This Row],[Actual]]","v":0}]
[null,null,"College",null,null,{"$f":"Savings[[#This Row],[Projected]]-Savings[[#This Row],[Actual]]","v":0}]
[null,null,"Other",null,null,{"$f":"Savings[[#This Row],[Projected]]-Savings[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Savings[Projected])","v":0},{"$f":"SUBTOTAL(109,Savings[Actual])","v":0},{"$f":"SUBTOTAL(109,Savings[Variance])","v":0}]
[]
[null,null,"Gifts and Donations","Projected","Actual","Variance"]
[null,null,"Charity 1",null,null,{"$f":"Gifts[[#This Row],[Projected]]-Gifts[[#This Row],[Actual]]","v":0}]
[null,null,"Charity 2",null,null,{"$f":"Gifts[[#This Row],[Projected]]-Gifts[[#This Row],[Actual]]","v":0}]
[null,null,"Charity 3",null,null,{"$f":"Gifts[[#This Row],[Projected]]-Gifts[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Gifts[Projected])","v":0},{"$f":"SUBTOTAL(109,Gifts[Actual])","v":0},{"$f":"SUBTOTAL(109,Gifts[Variance])","v":0}]
[]
[null,null,"Legal","Projected","Actual","Variance"]
[null,null,"Attorney",null,null,{"$f":"Legal[[#This Row],[Projected]]-Legal[[#This Row],[Actual]]","v":0}]
[null,null,"Alimony",null,null,{"$f":"Legal[[#This Row],[Projected]]-Legal[[#This Row],[Actual]]","v":0}]
[null,null,"Payments on lien or judgment",null,null,{"$f":"Legal[[#This Row],[Projected]]-Legal[[#This Row],[Actual]]","v":0}]
[null,null,"Other",null,null,{"$f":"Legal[[#This Row],[Projected]]-Legal[[#This Row],[Actual]]","v":0}]
[null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,Legal[Projected])","v":0},{"$f":"SUBTOTAL(109,Legal[Actual])","v":0},{"$f":"SUBTOTAL(109,Legal[Variance])","v":0}]