{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Summary","Expense"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":10,"n_cols":15,"rows_kept":10,"merged":[[0,1,0,2]]}
[null,"Personal budget"]
[null,null,"Jan","Feb","March","April","May","June","July","Aug","Sept","Oct","Nov","Dec","Year"]
[null,"Total expenses",{"$f":"Expenses[[#Totals],[Jan]]","v":{"v":0,"d":"$0"}},{"$f":"Expenses[[#Totals],[Feb]]","v":{"v":0,"d":"$0"}},{"$f":"Expenses[[#Totals],[March]]","v":{"v":0,"d":"$0"}},{"$f":"Expenses[[#Totals],[April]]","v":{"v":0,"d":"$0"}},{"$f":"Expenses[[#Totals],[May]]","v":{"v":0,"d":"$0"}},{"$f":"Expenses[[#Totals],[June]]","v":{"v":0,"d":"$0"}},{"$f":"Expenses[[#Totals],[July]]","v":{"v":0,"d":"$0"}},{"$f":"Expenses[[#Totals],[Aug]]","v":{"v":0,"d":"$0"}},{"$f":"Expenses[[#Totals],[Sept]]","v":{"v":0,"d":"$0"}},{"$f":"Expenses[[#Totals],[Oct]]","v":{"v":0,"d":"$0"}},{"$f":"Expenses[[#Totals],[Nov]]","v":{"v":0,"d":"$0"}},{"$f":"Expenses[[#Totals],[Dec]]","v":{"v":0,"d":"$0"}},{"$f":"SUM(C3:N3)","v":{"v":0,"d":"$0"}}]
[null,"Cash short/extra",{"$f":"SUM(Income[[#Totals],[Jan]]-C3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(Income[[#Totals],[Feb]]-D3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(Income[[#Totals],[March]]-E3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(Income[[#Totals],[April]]-F3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(Income[[#Totals],[May]]-G3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(Income[[#Totals],[June]]-H3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(Income[[#Totals],[July]]-I3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(Income[[#Totals],[Aug]]-J3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(Income[[#Totals],[Sept]]-K3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(Income[[#Totals],[Oct]]-L3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(Income[[#Totals],[Nov]]-M3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(Income[[#Totals],[Dec]]-N3)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C4:N4)","v":{"v":0,"d":"$0"}}]
[null,"Income"]
[null,"Category","Jan","Feb","March","April","May","June","July","Aug","Sept","Oct","Nov","Dec","Year"]
[null,"Wages",{"$nulls":12},{"$f":"SUM(Income[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0"}}]
[null,"Interest/dividends",{"$nulls":12},{"$f":"SUM(Income[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0"}}]
[null,"Miscellaneous",{"$nulls":12},{"$f":"SUM(Income[[#This Row],[Jan]:[Dec]])","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Income[Jan])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[Feb])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[March])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[April])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[May])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[June])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[July])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[Aug])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[Sept])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[Oct])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[Nov])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[Dec])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Income[Year])","v":{"v":0,"d":"$0"}}]

{"sheet":"Expense","index":1,"n_rows":12,"n_cols":16,"rows_kept":12,"merged":[[0,1,0,2]]}
[null,"Personal budget"]
[null,"Expenses"]
[null,"Category","Sub category","Jan","Feb","March","April","May","June","July","Aug","Sept","Oct","Nov","Dec","Year"]
[null,"Home","Mortgage/rent",{"$nulls":12},{"$f":"SUM(Expense!$D4:$O4)","v":{"v":0,"d":"$0"}}]
[null,"Daily living","Groceries ",{"$nulls":12},{"$f":"SUM(Expense!$D5:$O5)","v":{"v":0,"d":"$0"}}]
[null,"Transportation","Gas/fuel",{"$nulls":12},{"$f":"SUM(Expense!$D6:$O6)","v":{"v":0,"d":"$0"}}]
[null,"Entertainment","Cable TV",{"$nulls":12},{"$f":"SUM(Expense!$D7:$O7)","v":{"v":0,"d":"$0"}}]
[null,"Health","Health club dues",{"$nulls":12},{"$f":"SUM(Expense!$D8:$O8)","v":{"v":0,"d":"$0"}}]
[null,"Vacations","Plane fare",{"$nulls":12},{"$f":"SUM(Expense!$D9:$O9)","v":{"v":0,"d":"$0"}}]
[null,"Recreation","Gym fees",{"$nulls":12},{"$f":"SUM(Expense!$D10:$O10)","v":{"v":0,"d":"$0"}}]
[null,"Dues/Subscription","Magazines",{"$nulls":12},{"$f":"SUM(Expense!$D11:$O11)","v":{"v":0,"d":"$0"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Expenses[Jan])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[Feb])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[March])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[April])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[May])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[June])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[July])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[Aug])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[Sept])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[Oct])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[Nov])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[Dec])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Expenses[Year])","v":{"v":0,"d":"$0"}}]