{"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":1,"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":66,"n_cols":10,"rows_kept":66,"cut":false,"hidden":false,"merged":[[64,9,65,9],[64,6,65,8],[62,9,63,9],[62,6,63,8],[1,1,3,9],[9,2,9,3],[10,2,10,3],[11,2,11,3],[9,1,11,1],[5,1,7,1],[5,2,5,3],[6,2,6,3],[4,1,4,3],[7,6,8,8],[7,2,7,3],[5,9,6,9],[60,6,61,8],[9,9,11,9],[5,6,6,8],[60,9,61,9],[7,9,8,9],[9,6,11,8]]}
[]
[null,"Personal Monthly Budget"]
[]
[]
[]
[null,"PROJECTED MONTHLY INCOME","Income 1",null,4300,null,"PROJECTED BALANCE                                                       (Projected income minus expenses)",null,null,{"$f":"E8-J61","v":3405}]
[null,null,"Extra income",null,300]
[null,null,"Total monthly income",null,{"$f":"SUM(E6:E7)","v":4600},null,"ACTUAL BALANCE                                                               (Actual income minus expenses)",null,null,{"$f":"E12-J63","v":3064}]
[]
[null,"ACTUAL MONTHLY INCOME","Income 1",null,4000,null,"DIFFERENCE                                                                         (Actual minus projected)",null,null,{"$f":"J8-J6","v":-341}]
[null,null,"Extra income",null,300]
[null,null,"Total monthly income",null,{"$f":"SUM(E10:E11)","v":4300}]
[]
[null,"HOUSING","Projected Cost","Actual Cost","Difference",null,"ENTERTAINMENT","Projected Cost","Actual Cost","Difference"]
[null,"Mortgage or rent",1000,1000,{"$f":"C15-D15","v":0},null,"Video/DVD",null,null,{"$f":"H15-I15","v":0}]
[null,"Phone",54,100,-46,null,"CDs",null,null,0]
[null,"Electricity",44,56,-12,null,"Movies",null,null,0]
[null,"Gas",22,28,-6,null,"Concerts",null,null,0]
[null,"Water and sewer",8,8,0,null,"Sporting events",null,null,0]
[null,"Cable",34,34,0,null,"Live theater",null,null,0]
[null,"Waste removal",10,10,0,null,"Other",null,null,0]
[null,"Maintenance or repairs",23,0,23,null,"Other",null,null,0]
[null,"Supplies",0,0,0,null,"Other",null,null,0]
[null,"Other",0,0,0,null,"Subtotals",{"$f":"SUM(H15:H23)","v":0},{"$f":"SUM(I15:I23)","v":0},0]
[null,"Subtotals",{"$f":"SUM(C15:C24)","v":1195},{"$f":"SUM(D15:D24)","v":1236},{"$f":"SUM(E15:E24)","v":-41}]
[null,null,null,null,null,null,"LOANS","Projected Cost","Actual Cost","Difference"]
[null,"TRANSPORTATION","Projected Cost","Actual Cost","Difference",null,"Personal",null,null,{"$f":"H27-I27","v":0}]
[null,"Vehicle payment",null,null,{"$f":"C28-D28","v":0},null,"Student",null,null,0]
[null,"Bus/taxi fare",null,null,0,null,"Credit card",null,null,0]
[null,"Insurance",null,null,0,null,"Credit card",null,null,0]
[null,"Licensing",null,null,0,null,"Credit card",null,null,0]
[null,"Fuel",null,null,0,null,"Other",null,null,0]
[null,"Maintenance",null,null,0,null,"Subtotals",{"$f":"SUM(H27:H32)","v":0},{"$f":"SUM(I27:I32)","v":0},{"$f":"SUM(J27:J32)","v":0}]
[null,"Other",null,null,0]
[null,"Subtotals",{"$f":"SUM(C28:C34)","v":0},{"$f":"SUM(D28:D34)","v":0},{"$f":"SUM(E28:E34)","v":0},null,"TAXES","Projected Cost","Actual Cost","Difference"]
[null,null,null,null,null,null,"Federal",null,null,{"$f":"H36-I36","v":0}]
[null,"INSURANCE","Projected Cost","Actual Cost","Difference",null,"State",null,null,{"$f":"H37-I37","v":0}]
[null,"Home",null,null,{"$f":"C38-D38","v":0},null,"Local",null,null,{"$f":"H38-I38","v":0}]
[null,"Health",null,null,{"$f":"C39-D39","v":0},null,"Other",null,null,{"$f":"H39-I39","v":0}]
[null,"Life",null,null,{"$f":"C40-D40","v":0},null,"Subtotals",{"$f":"SUM(H36:H39)","v":0},{"$f":"SUM(I36:I39)","v":0},{"$f":"SUM(J36:J39)","v":0}]
[null,"Other",null,null,{"$f":"C41-D41","v":0}]
[null,"Subtotals",{"$f":"SUM(C38:C41)","v":0},{"$f":"SUM(D38:D41)","v":0},{"$f":"SUM(E38:E41)","v":0},null,"SAVINGS OR INVESTMENTS","Projected Cost","Actual Cost","Difference"]
[null,null,null,null,null,null,"Retirement account",null,null,{"$f":"H43-I43","v":0}]
[null,"FOOD","Projected Cost","Actual Cost","Difference",null,"Investment account",null,null,{"$f":"H44-I44","v":0}]
[null,"Groceries",null,null,{"$f":"C45-D45","v":0},null,"Other",null,null,{"$f":"H45-I45","v":0}]
[null,"Dining out",null,null,{"$f":"C46-D46","v":0},null,"Subtotals",{"$f":"SUM(H43:H45)","v":0},{"$f":"SUM(I43:I45)","v":0},{"$f":"SUM(J43:J45)","v":0}]
[null,"Other",null,null,{"$f":"C47-D47","v":0}]
[null,"Subtotals",{"$f":"SUM(C45:C47)","v":0},{"$f":"SUM(D45:D47)","v":0},{"$f":"SUM(E45:E47)","v":0},null,"GIFTS AND DONATIONS","Projected Cost","Actual Cost","Difference"]
[null,null,null,null,null,null,"Charity 1",null,null,{"$f":"H49-I49","v":0}]
[null,"PETS","Projected Cost","Actual Cost","Difference",null,"Charity 2",null,null,{"$f":"H50-I50","v":0}]
[null,"Food",null,null,{"$f":"C51-D51","v":0},null,"Charity 3",null,null,{"$f":"H51-I51","v":0}]
[null,"Medical",null,null,{"$f":"C52-D52","v":0},null,"Subtotals",{"$f":"SUM(H49:H51)","v":0},{"$f":"SUM(I49:I51)","v":0},{"$f":"SUM(J49:J51)","v":0}]
[null,"Grooming",null,null,{"$f":"C53-D53","v":0}]
[null,"Toys",null,null,{"$f":"C54-D54","v":0},null,"LEGAL","Projected Cost","Actual Cost","Difference"]
[null,"Other",null,null,{"$f":"C55-D55","v":0},null,"Attorney",null,null,{"$f":"H55-I55","v":0}]
[null,"Subtotals",{"$f":"SUM(C51:C55)","v":0},{"$f":"SUM(D51:D55)","v":0},{"$f":"SUM(E51:E55)","v":0},null,"Alimony",null,null,{"$f":"H56-I56","v":0}]
[null,null,null,null,null,null,"Payments on lien or judgment",null,null,{"$f":"H57-I57","v":0}]
[null,"PERSONAL CARE","Projected Cost","Actual Cost","Difference",null,"Other",null,null,{"$f":"H58-I58","v":0}]
[null,"Medical",null,null,{"$f":"C59-D59","v":0},null,"Subtotals",{"$f":"SUM(H55:H58)","v":0},{"$f":"SUM(I55:I58)","v":0},{"$f":"SUM(J55:J58)","v":0}]
[null,"Hair/nails",null,null,0]
[null,"Clothing",null,null,0,null,"TOTAL PROJECTED COST",null,null,{"$f":"SUM(C25,C35,C42,C48,C56,C66,H24,H33,H40,H46,H52,H59)","v":1195}]
[null,"Dry cleaning",null,null,0]
[null,"Health club",null,null,0,null,"TOTAL ACTUAL COST",null,null,{"$f":"SUM(D25,D35,D42,D48,D56,D66,I24,I33,I40,I46,I52,I59)","v":1236}]
[null,"Organization dues or fees",null,null,0]
[null,"Other",null,null,0,null,"TOTAL DIFFERENCE",null,null,{"$f":"SUM(E25,E35,E42,E48,E56,E66,J24,J33,J40,J46,J52,J59)","v":-41}]
[null,"Subtotals",{"$f":"SUM(C59:C65)","v":0},{"$f":"SUM(D59:D65)","v":0},{"$f":"SUM(E59:E65)","v":0}]