{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Personal Monthly Budget"],"not_rendered":{"charts":0,"images":0,"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":"Personal Monthly Budget","index":0,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":false,"merged":[[21,1,21,4],[31,1,31,4],[38,1,38,4],[20,6,20,9],[29,6,29,9],[36,6,36,9],[44,1,44,4],[55,6,55,9],[52,1,52,4],[42,6,42,9],[48,6,48,9],[0,1,0,9],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[5,1,7,1],[2,1,4,1],[2,2,2,3],[3,2,3,3],[7,6,7,8],[4,6,4,8],[2,7,2,8],[3,7,3,8],[5,7,5,8],[6,7,6,8]]}
[null,"Personal Monthly Budget"]
[]
[null,"PROJECTED MONTHLY INCOME","Income 1",null,2500,null,"TOTAL PROJECTED EXPENSE ","(Projected income minus expenses)",null,{"$f":"SUM(C21,C31,C38,C44,C52,C62,H20,H29,H36,H42,H48,H55)","v":2060}]
[null,null,"Extra income",null,500,null,"TOTAL ACTUAL EXPENSE ","(Actual income minus expenses)",null,{"$f":"SUM(D21,D31,D38,D44,D52,D62,I20,I29,I36,I42,I48,I55)","v":2040}]
[null,null,"Total monthly income",null,{"$f":"SUM(E3:E4)","v":3000},null,"Total Expense Difference",null,null,{"$f":"SUM(E21,E31,E38,E44,E52,E62,J20,J29,J36,J42,J48,J55)","v":20}]
[null,"ACTUAL MONTHLY INCOME","Income 1",null,2500,null,"PROJECTED BALANCE","(Projected income minus expenses)",null,{"$f":"E5-J3","v":940}]
[null,null,"Extra income",null,500,null,"ACTUAL BALANCE","(Actual income minus expenses)",null,{"$f":"E8-J4","v":960}]
[null,null,"Total monthly income",null,{"$f":"SUM(E6:E7)","v":3000},null,"BALANCE DIFFERENCE (Actual minus projected)",null,null,{"$f":"J7-J6","v":20}]
[]
[null,"HOUSING","Projected Cost","Actual Cost","Difference",null,"ENTERTAINMENT","Projected Cost","Actual Cost","Difference"]
[null,"Mortgage or rent",1500,1400,{"$f":"Housing[Projected Cost]-Housing[Actual Cost]","v":100},null,"Video/DVD",0,50,{"$f":"Entertainment[Projected Cost]-Entertainment[Actual Cost]","v":-50}]
[null,"Phone",60,100,{"$f":"Housing[Projected Cost]-Housing[Actual Cost]","v":-40},null,"CDs",null,null,{"$f":"Entertainment[Projected Cost]-Entertainment[Actual Cost]","v":0}]
[null,"Electricity",50,60,{"$f":"Housing[Projected Cost]-Housing[Actual Cost]","v":-10},null,"Movies",null,null,{"$f":"Entertainment[Projected Cost]-Entertainment[Actual Cost]","v":0}]
[null,"Gas",200,180,{"$f":"Housing[Projected Cost]-Housing[Actual Cost]","v":20},null,"Concerts",null,null,{"$f":"Entertainment[Projected Cost]-Entertainment[Actual Cost]","v":0}]
[null,"Water and sewer",null,null,{"$f":"Housing[Projected Cost]-Housing[Actual Cost]","v":0},null,"Sporting events",null,null,{"$f":"Entertainment[Projected Cost]-Entertainment[Actual Cost]","v":0}]
[null,"Cable",null,null,{"$f":"Housing[Projected Cost]-Housing[Actual Cost]","v":0},null,"Live theater",null,null,{"$f":"Entertainment[Projected Cost]-Entertainment[Actual Cost]","v":0}]
[null,"Waste removal",null,null,{"$f":"Housing[Projected Cost]-Housing[Actual Cost]","v":0},null,"Other",null,null,{"$f":"Entertainment[Projected Cost]-Entertainment[Actual Cost]","v":0}]
[null,"Maintenance or repairs",null,null,{"$f":"Housing[Projected Cost]-Housing[Actual Cost]","v":0},null,"Other",null,null,{"$f":"Entertainment[Projected Cost]-Entertainment[Actual Cost]","v":0}]
[null,"Supplies",null,null,{"$f":"Housing[Projected Cost]-Housing[Actual Cost]","v":0},null,"Other",null,null,{"$f":"Entertainment[Projected Cost]-Entertainment[Actual Cost]","v":0}]
[null,"Other",null,null,{"$f":"Housing[Projected Cost]-Housing[Actual Cost]","v":0},null,"Total",{"$f":"SUBTOTAL(109,Entertainment[Projected Cost])","v":0},{"$f":"SUBTOTAL(109,Entertainment[Actual Cost])","v":50},{"$f":"SUBTOTAL(109,Entertainment[Difference])","v":-50}]
[null,"Total",{"$f":"SUBTOTAL(109,Housing[Projected Cost])","v":1810},{"$f":"SUBTOTAL(109,Housing[Actual Cost])","v":1740},{"$f":"SUBTOTAL(109,Housing[Difference])","v":70}]
[null,null,null,null,null,null,"LOANS","Projected Cost","Actual Cost","Difference"]
[null,"TRANSPORTATION","Projected Cost","Actual Cost","Difference",null,"Personal",null,null,{"$f":"Loans[Projected Cost]-Loans[Actual Cost]","v":0}]
[null,"Vehicle payment",250,250,{"$f":"Transportation[Projected Cost]-Transportation[Actual Cost]","v":0},null,"Student",null,null,{"$f":"Loans[Projected Cost]-Loans[Actual Cost]","v":0}]
[null,"Bus/taxi fare",null,null,{"$f":"Transportation[Projected Cost]-Transportation[Actual Cost]","v":0},null,"Credit card",null,null,{"$f":"Loans[Projected Cost]-Loans[Actual Cost]","v":0}]
[null,"Insurance",null,null,{"$f":"Transportation[Projected Cost]-Transportation[Actual Cost]","v":0},null,"Credit card",null,null,{"$f":"Loans[Projected Cost]-Loans[Actual Cost]","v":0}]
[null,"Licensing",null,null,{"$f":"Transportation[Projected Cost]-Transportation[Actual Cost]","v":0},null,"Credit card",null,null,{"$f":"Loans[Projected Cost]-Loans[Actual Cost]","v":0}]
[null,"Fuel",null,null,{"$f":"Transportation[Projected Cost]-Transportation[Actual Cost]","v":0},null,"Other",null,null,{"$f":"Loans[Projected Cost]-Loans[Actual Cost]","v":0}]
[null,"Maintenance",null,null,{"$f":"Transportation[Projected Cost]-Transportation[Actual Cost]","v":0},null,"Total",{"$f":"SUBTOTAL(109,Loans[Projected Cost])","v":0},{"$f":"SUBTOTAL(109,Loans[Actual Cost])","v":0},{"$f":"SUBTOTAL(109,Loans[Difference])","v":0}]
[null,"Other",null,null,{"$f":"Transportation[Projected Cost]-Transportation[Actual Cost]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Transportation[Projected Cost])","v":250},{"$f":"SUBTOTAL(109,Transportation[Actual Cost])","v":250},{"$f":"SUBTOTAL(109,Transportation[Difference])","v":0},null,"TAXES","Projected Cost","Actual Cost","Difference"]
[null,null,null,null,null,null,"Federal",null,null,{"$f":"Taxes[Projected Cost]-Taxes[Actual Cost]","v":0}]
[null,"INSURANCE","Projected Cost","Actual Cost","Difference",null,"State",null,null,{"$f":"Taxes[Projected Cost]-Taxes[Actual Cost]","v":0}]
[null,"Home",null,null,{"$f":"Insurance[Projected Cost]-Insurance[Actual Cost]","v":0},null,"Local",null,null,{"$f":"Taxes[Projected Cost]-Taxes[Actual Cost]","v":0}]
[null,"Health",null,null,{"$f":"Insurance[Projected Cost]-Insurance[Actual Cost]","v":0},null,"Other",null,null,{"$f":"Taxes[Projected Cost]-Taxes[Actual Cost]","v":0}]
[null,"Life",null,null,{"$f":"Insurance[Projected Cost]-Insurance[Actual Cost]","v":0},null,"Total",{"$f":"SUBTOTAL(109,Taxes[Projected Cost])","v":0},{"$f":"SUBTOTAL(109,Taxes[Actual Cost])","v":0},{"$f":"SUBTOTAL(109,Taxes[Difference])","v":0}]
[null,"Other",null,null,{"$f":"Insurance[Projected Cost]-Insurance[Actual Cost]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Insurance[Projected Cost])","v":0},{"$f":"SUBTOTAL(109,Insurance[Actual Cost])","v":0},{"$f":"SUBTOTAL(109,Insurance[Difference])","v":0},null,"SAVINGS OR INVESTMENTS","Projected Cost","Actual Cost","Difference"]
[null,null,null,null,null,null,"Retirement account",null,null,{"$f":"SavingsOrInvestment[Projected Cost]-SavingsOrInvestment[Actual Cost]","v":0}]
[null,"FOOD","Projected Cost","Actual Cost","Difference",null,"Investment account",null,null,{"$f":"SavingsOrInvestment[Projected Cost]-SavingsOrInvestment[Actual Cost]","v":0}]
[null,"Groceries",null,null,{"$f":"Food[Projected Cost]-Food[Actual Cost]","v":0},null,"Other",null,null,{"$f":"SavingsOrInvestment[Projected Cost]-SavingsOrInvestment[Actual Cost]","v":0}]
[null,"Dining out",null,null,{"$f":"Food[Projected Cost]-Food[Actual Cost]","v":0},null,"Total",{"$f":"SUBTOTAL(109,SavingsOrInvestment[Projected Cost])","v":0},{"$f":"SUBTOTAL(109,SavingsOrInvestment[Actual Cost])","v":0},{"$f":"SUBTOTAL(109,SavingsOrInvestment[Difference])","v":0}]
[null,"Other",null,null,{"$f":"Food[Projected Cost]-Food[Actual Cost]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Food[Projected Cost])","v":0},{"$f":"SUBTOTAL(109,Food[Actual Cost])","v":0},{"$f":"SUBTOTAL(109,Food[Difference])","v":0},null,"GIFTS AND DONATIONS","Projected Cost","Actual Cost","Difference"]
[null,null,null,null,null,null,"Charity 1",null,null,{"$f":"GiftsAndDonations[Projected Cost]-GiftsAndDonations[Actual Cost]","v":0}]
[null,"PETS","Projected Cost","Actual Cost","Difference",null,"Charity 2",null,null,{"$f":"GiftsAndDonations[Projected Cost]-GiftsAndDonations[Actual Cost]","v":0}]
[null,"Food",null,null,{"$f":"Pets[Projected Cost]-Pets[Actual Cost]","v":0},null,"Charity 3",null,null,{"$f":"GiftsAndDonations[Projected Cost]-GiftsAndDonations[Actual Cost]","v":0}]
[null,"Medical",null,null,{"$f":"Pets[Projected Cost]-Pets[Actual Cost]","v":0},null,"Total",{"$f":"SUBTOTAL(109,GiftsAndDonations[Projected Cost])","v":0},{"$f":"SUBTOTAL(109,GiftsAndDonations[Actual Cost])","v":0},{"$f":"SUBTOTAL(109,GiftsAndDonations[Difference])","v":0}]
[null,"Grooming",null,null,{"$f":"Pets[Projected Cost]-Pets[Actual Cost]","v":0}]
[null,"Toys",null,null,{"$f":"Pets[Projected Cost]-Pets[Actual Cost]","v":0},null,"LEGAL","Projected Cost","Actual Cost","Difference"]
[null,"Other",null,null,{"$f":"Pets[Projected Cost]-Pets[Actual Cost]","v":0},null,"Attorney",null,null,{"$f":"Legal[Projected Cost]-Legal[Actual Cost]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Pets[Projected Cost])","v":0},{"$f":"SUBTOTAL(109,Pets[Actual Cost])","v":0},{"$f":"SUBTOTAL(109,Pets[Difference])","v":0},null,"Alimony",null,null,{"$f":"Legal[Projected Cost]-Legal[Actual Cost]","v":0}]
[null,null,null,null,null,null,"Payments on lien or judgment",null,null,{"$f":"Legal[Projected Cost]-Legal[Actual Cost]","v":0}]
[null,"PERSONAL CARE","Projected Cost","Actual Cost","Difference",null,"Other",null,null,{"$f":"Legal[Projected Cost]-Legal[Actual Cost]","v":0}]
[null,"Medical",null,null,{"$f":"PersonalCare[Projected Cost]-PersonalCare[Actual Cost]","v":0},null,"Total",{"$f":"SUBTOTAL(109,Legal[Projected Cost])","v":0},{"$f":"SUBTOTAL(109,Legal[Actual Cost])","v":0},{"$f":"SUBTOTAL(109,Legal[Difference])","v":0}]
[null,"Hair/nails",null,null,{"$f":"PersonalCare[Projected Cost]-PersonalCare[Actual Cost]","v":0}]
[null,"Clothing",null,null,{"$f":"PersonalCare[Projected Cost]-PersonalCare[Actual Cost]","v":0}]
[null,"Dry cleaning",null,null,{"$f":"PersonalCare[Projected Cost]-PersonalCare[Actual Cost]","v":0}]
[null,"Health club",null,null,{"$f":"PersonalCare[Projected Cost]-PersonalCare[Actual Cost]","v":0}]
[null,"Organization dues or fees",null,null,{"$f":"PersonalCare[Projected Cost]-PersonalCare[Actual Cost]","v":0}]
[null,"Other",null,null,{"$f":"PersonalCare[Projected Cost]-PersonalCare[Actual Cost]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,PersonalCare[Projected Cost])","v":0},{"$f":"SUBTOTAL(109,PersonalCare[Actual Cost])","v":0},{"$f":"SUBTOTAL(109,PersonalCare[Difference])","v":0}]