{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Personal Money Tracker","Monthly Summary","Chart Data"],"not_rendered":{"charts":2,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Personal Money Tracker","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[8,3,8,6],[19,1,20,1],[21,1,23,1]]}
[null,"Personal Money Tracker"]
[]
[{"$nulls":3},"Cash Summary"]
[{"$nulls":3},"Account","Starting Cash","Spending Total","Cash Remaining"]
[{"$nulls":3},"Checking",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(CashSpent[Account],\"=\" &CashSummaryTable[[#This Row],[Account]],CashSpent[Amount])","v":{"v":428,"d":"428.00"}},{"$f":"CashSummaryTable[[#This Row],[Starting Cash]]-CashSummaryTable[[#This Row],[Spending Total]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"Savings",{"v":500,"d":"500.00"},{"$f":"SUMIF(CashSpent[Account],\"=\" &CashSummaryTable[[#This Row],[Account]],CashSpent[Amount])","v":{"v":450,"d":"450.00"}},{"$f":"CashSummaryTable[[#This Row],[Starting Cash]]-CashSummaryTable[[#This Row],[Spending Total]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"Other",{"v":200,"d":"200.00"},{"$f":"SUMIF(CashSpent[Account],\"=\" &CashSummaryTable[[#This Row],[Account]],CashSpent[Amount])","v":{"v":30,"d":"30.00"}},{"$f":"CashSummaryTable[[#This Row],[Starting Cash]]-CashSummaryTable[[#This Row],[Spending Total]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,CashSummaryTable[Starting Cash])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[Spending Total])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[Cash Remaining])","v":{"v":2792,"d":"2792.00"}}]
[]
[{"$nulls":3},"Cash I've spent"]
[{"$nulls":3},"Date","Description","Amount","Account"]
[{"$nulls":3},"2012-01-04","ATM withdrawal",{"v":40,"d":"40.00"},"Checking"]
[{"$nulls":3},"2012-01-05","Lunch",{"v":5,"d":"5.00"},"Checking"]
[{"$nulls":3},"2012-01-06","Car payment",{"v":230,"d":"230.00"},"Savings"]
[{"$nulls":3},"2012-02-03","Electricity payment",{"v":70,"d":"70.00"},"Checking"]
[{"$nulls":3},"2012-02-07","Dinner",{"v":53,"d":"53.00"},"Checking"]
[{"$nulls":3},"2012-03-01","Cash withdrawal",{"v":100,"d":"100.00"},"Savings"]
[{"$nulls":3},"2012-03-06","Car payment",{"v":230,"d":"230.00"},"Checking"]
[{"$nulls":3},"2012-04-06","Electricity payment",{"v":70,"d":"70.00"},"Savings"]
[null,"Cash\nRemaining:",null,"2012-04-20","ATM withdrawal",{"v":30,"d":"30.00"},"Checking"]
[{"$nulls":3},"2012-05-03","ATM withdrawal",{"v":50,"d":"50.00"},"Savings"]
[null,{"$f":"CashSummaryTable[[#Totals],[Cash Remaining]]/CashSummaryTable[[#Totals],[Starting Cash]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-10","ATM withdrawal",{"v":30,"d":"30.00"},"Other"]

{"sheet":"Monthly Summary","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Monthly Summary"]
[null,"Account Summary"]
{"$rows_empty":13}
[null,"Spending Summary"]
[null,"Details"]
[null,null,"Checking","Savings","Other","Grand Total"]
[null,"Jan",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"Feb",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"Mar",{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},null,{"v":330,"d":"330.00"}]
[null,"Car payment",{"v":230,"d":"230.00"},null,null,{"v":230,"d":"230.00"}]
[null,"Cash withdrawal",null,{"v":100,"d":"100.00"},null,{"v":100,"d":"100.00"}]
[null,"Apr",{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},null,{"v":100,"d":"100.00"}]
[null,"May",null,{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"Grand Total",{"v":428,"d":"428.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":908,"d":"908.00"}]

{"sheet":"Chart Data","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"PivotChart Data"]
[null,"This PivotTable is the data source for the Account Summary PivotChart on the Monthly Summary sheet"]
[null,"Sum of Amount","Column Labels"]
[null,"Row Labels","Checking","Savings","Other","Grand Total"]
[null,"Jan",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"Feb",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"Mar",{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},null,{"v":330,"d":"330.00"}]
[null,"Apr",{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},null,{"v":100,"d":"100.00"}]
[null,"May",null,{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"Grand Total",{"v":428,"d":"428.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":908,"d":"908.00"}]