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

{"sheet":"Personal Monthly Budget","index":0,"n_rows":64,"n_cols":10,"rows_kept":64,"merged":[[1,1,1,9],[2,1,2,9],[4,1,6,1],[4,2,4,3],[4,6,5,8],[4,9,5,9],[5,2,5,3],[6,2,6,3],[6,6,7,8],[6,9,7,9],[7,1,9,1],[7,2,7,3],[8,2,8,3],[8,6,9,8],[8,9,9,9],[9,2,9,3],[22,6,22,9],[23,1,23,4],[31,6,31,9],[33,1,33,4],[38,6,38,9],[40,1,40,4],[44,6,44,9],[46,1,46,4],[50,6,50,9],[54,1,54,4],[57,6,57,9],[58,6,59,8],[58,9,59,9],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9]]}
[]
[null,"Personal Monthly Budget"]
[]
[]
[null,"PROJECTED MONTHLY INCOME","Income 1",null,{"v":2500,"d":"$2,500"},null,"PROJECTED BALANCE (Projected income minus expenses)",null,null,{"$f":"E7-J59","v":{"v":940,"d":"$940"}}]
[null,null,"Extra income",null,{"v":500,"d":"$500"}]
[null,null,"Total monthly income",null,{"$f":"SUM(E5:E6)","v":{"v":3000,"d":"$3,000"}},null,"ACTUAL BALANCE (Actual income minus expenses)",null,null,{"$f":"E10-J61","v":{"v":960,"d":"$960"}}]
[null,"ACTUAL MONTHLY INCOME","Income 1",null,{"v":2500,"d":"$2,500"}]
[null,null,"Extra income",null,{"v":500,"d":"$500"},null,"DIFFERENCE (Actual minus projected)",null,null,{"$f":"J7-J5","v":{"v":20,"d":"$20"}}]
[null,null,"Total monthly income",null,{"$f":"SUM(E8:E9)","v":{"v":3000,"d":"$3,000"}}]
[]
[null,"HOUSING","Projected Cost","Actual Cost","Difference",null,"ENTERTAINMENT","Projected Cost","Actual Cost","Difference"]
[null,"Mortgage or rent",{"v":1500,"d":"$1,500"},{"v":1400,"d":"$1,400"},{"$f":"Table1[Projected Cost]-Table1[Actual Cost]","v":{"v":100,"d":"$100"}},null,"Video/DVD",{"v":0,"d":"$0"},{"v":50,"d":"$50"},{"$f":"Table2[Projected Cost]-Table2[Actual Cost]","v":{"v":-50,"d":"-$50"}}]
[null,"Phone",{"v":60,"d":"$60"},{"v":100,"d":"$100"},{"$f":"Table1[Projected Cost]-Table1[Actual Cost]","v":{"v":-40,"d":"-$40"}},null,"CDs",null,null,{"$f":"Table2[Projected Cost]-Table2[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Electricity",{"v":50,"d":"$50"},{"v":60,"d":"$60"},{"$f":"Table1[Projected Cost]-Table1[Actual Cost]","v":{"v":-10,"d":"-$10"}},null,"Movies",null,null,{"$f":"Table2[Projected Cost]-Table2[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Gas",{"v":200,"d":"$200"},{"v":180,"d":"$180"},{"$f":"Table1[Projected Cost]-Table1[Actual Cost]","v":{"v":20,"d":"$20"}},null,"Concerts",null,null,{"$f":"Table2[Projected Cost]-Table2[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Water and sewer",null,null,{"$f":"Table1[Projected Cost]-Table1[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Sporting events",null,null,{"$f":"Table2[Projected Cost]-Table2[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Cable",null,null,{"$f":"Table1[Projected Cost]-Table1[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Live theater",null,null,{"$f":"Table2[Projected Cost]-Table2[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Waste removal",null,null,{"$f":"Table1[Projected Cost]-Table1[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Other",null,null,{"$f":"Table2[Projected Cost]-Table2[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Maintenance or repairs",null,null,{"$f":"Table1[Projected Cost]-Table1[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Other",null,null,{"$f":"Table2[Projected Cost]-Table2[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Supplies",null,null,{"$f":"Table1[Projected Cost]-Table1[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Other",null,null,{"$f":"Table2[Projected Cost]-Table2[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Other",null,null,{"$f":"Table1[Projected Cost]-Table1[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,Table2[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table2[Actual Cost])","v":{"v":50,"d":"$50"}},{"$f":"SUBTOTAL(109,Table2[Difference])","v":{"v":-50,"d":"-$50"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Table1[Projected Cost])","v":{"v":1810,"d":"$1,810"}},{"$f":"SUBTOTAL(109,Table1[Actual Cost])","v":{"v":1740,"d":"$1,740"}},{"$f":"SUBTOTAL(109,Table1[Difference])","v":{"v":70,"d":"$70"}}]
[{"$nulls":6},"LOANS","Projected Cost","Actual Cost","Difference"]
[null,"TRANSPORTATION","Projected Cost","Actual Cost","Difference",null,"Personal",null,null,{"$f":"Table8[Projected Cost]-Table8[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Vehicle payment",{"v":250,"d":"$250"},{"v":250,"d":"$250"},{"$f":"Table3[Projected Cost]-Table3[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Student",null,null,{"$f":"Table8[Projected Cost]-Table8[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Bus/taxi fare",null,null,{"$f":"Table3[Projected Cost]-Table3[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Credit card",null,null,{"$f":"Table8[Projected Cost]-Table8[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Insurance",null,null,{"$f":"Table3[Projected Cost]-Table3[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Credit card",null,null,{"$f":"Table8[Projected Cost]-Table8[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Licensing",null,null,{"$f":"Table3[Projected Cost]-Table3[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Credit card",null,null,{"$f":"Table8[Projected Cost]-Table8[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Fuel",null,null,{"$f":"Table3[Projected Cost]-Table3[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Other",null,null,{"$f":"Table8[Projected Cost]-Table8[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Maintenance",null,null,{"$f":"Table3[Projected Cost]-Table3[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,Table8[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table8[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table8[Difference])","v":{"v":0,"d":"$0"}}]
[null,"Other",null,null,{"$f":"Table3[Projected Cost]-Table3[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Table3[Projected Cost])","v":{"v":250,"d":"$250"}},{"$f":"SUBTOTAL(109,Table3[Actual Cost])","v":{"v":250,"d":"$250"}},{"$f":"SUBTOTAL(109,Table3[Difference])","v":{"v":0,"d":"$0"}},null,"TAXES","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Federal",null,null,{"$f":"Table9[Projected Cost]-Table9[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"INSURANCE","Projected Cost","Actual Cost","Difference",null,"State",null,null,{"$f":"Table9[Projected Cost]-Table9[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Home",null,null,{"$f":"Table4[Projected Cost]-Table4[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Local",null,null,{"$f":"Table9[Projected Cost]-Table9[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Health",null,null,{"$f":"Table4[Projected Cost]-Table4[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Other",null,null,{"$f":"Table9[Projected Cost]-Table9[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Life",null,null,{"$f":"Table4[Projected Cost]-Table4[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,Table9[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table9[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table9[Difference])","v":{"v":0,"d":"$0"}}]
[null,"Other",null,null,{"$f":"Table4[Projected Cost]-Table4[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Table4[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table4[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table4[Difference])","v":{"v":0,"d":"$0"}},null,"SAVINGS OR INVESTMENTS","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Retirement account",null,null,{"$f":"Table10[Projected Cost]-Table10[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"FOOD","Projected Cost","Actual Cost","Difference",null,"Investment account",null,null,{"$f":"Table10[Projected Cost]-Table10[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Groceries",null,null,{"$f":"Table5[Projected Cost]-Table5[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Other",null,null,{"$f":"Table10[Projected Cost]-Table10[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Dining out",null,null,{"$f":"Table5[Projected Cost]-Table5[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,Table10[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table10[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table10[Difference])","v":{"v":0,"d":"$0"}}]
[null,"Other",null,null,{"$f":"Table5[Projected Cost]-Table5[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Table5[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table5[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table5[Difference])","v":{"v":0,"d":"$0"}},null,"GIFTS AND DONATIONS","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Charity 1",null,null,{"$f":"Table11[Projected Cost]-Table11[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"PETS","Projected Cost","Actual Cost","Difference",null,"Charity 2",null,null,{"$f":"Table11[Projected Cost]-Table11[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Food",null,null,{"$f":"Table6[Projected Cost]-Table6[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Charity 3",null,null,{"$f":"Table11[Projected Cost]-Table11[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Medical",null,null,{"$f":"Table6[Projected Cost]-Table6[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,Table11[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table11[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table11[Difference])","v":{"v":0,"d":"$0"}}]
[null,"Grooming",null,null,{"$f":"Table6[Projected Cost]-Table6[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Toys",null,null,{"$f":"Table6[Projected Cost]-Table6[Actual Cost]","v":{"v":0,"d":"$0"}},null,"LEGAL","Projected Cost","Actual Cost","Difference"]
[null,"Other",null,null,{"$f":"Table6[Projected Cost]-Table6[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Attorney",null,null,{"$f":"Table12[Projected Cost]-Table12[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Table6[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table6[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table6[Difference])","v":{"v":0,"d":"$0"}},null,"Alimony",null,null,{"$f":"Table12[Projected Cost]-Table12[Actual Cost]","v":{"v":0,"d":"$0"}}]
[{"$nulls":6},"Payments on lien or judgment",null,null,{"$f":"Table12[Projected Cost]-Table12[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"PERSONAL CARE","Projected Cost","Actual Cost","Difference",null,"Other",null,null,{"$f":"Table12[Projected Cost]-Table12[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Medical",null,null,{"$f":"Table7[Projected Cost]-Table7[Actual Cost]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,Table12[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table12[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table12[Difference])","v":{"v":0,"d":"$0"}}]
[null,"Hair/nails",null,null,{"$f":"Table7[Projected Cost]-Table7[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Clothing",null,null,{"$f":"Table7[Projected Cost]-Table7[Actual Cost]","v":{"v":0,"d":"$0"}},null,"TOTAL PROJECTED COST",null,null,{"$f":"SUM(C23,C33,C40,C46,C54,C64,H22,H31,H38,H44,H50,H57)","v":{"v":2060,"d":"$2,060"}}]
[null,"Dry cleaning",null,null,{"$f":"Table7[Projected Cost]-Table7[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Health club",null,null,{"$f":"Table7[Projected Cost]-Table7[Actual Cost]","v":{"v":0,"d":"$0"}},null,"TOTAL ACTUAL COST",null,null,{"$f":"SUM(D23,D33,D40,D46,D54,D64,I22,I31,I38,I44,I50,I57)","v":{"v":2040,"d":"$2,040"}}]
[null,"Organization dues or fees",null,null,{"$f":"Table7[Projected Cost]-Table7[Actual Cost]","v":{"v":0,"d":"$0"}}]
[null,"Other",null,null,{"$f":"Table7[Projected Cost]-Table7[Actual Cost]","v":{"v":0,"d":"$0"}},null,"TOTAL DIFFERENCE",null,null,{"$f":"SUM(E23,E33,E40,E46,E54,E64,J22,J31,J38,J44,J50,J57)","v":{"v":20,"d":"$20"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Table7[Projected Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table7[Actual Cost])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Table7[Difference])","v":{"v":0,"d":"$0"}}]