{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["个人资金跟踪器","每月摘要","图表数据"],"not_rendered":{"charts":2,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"个人资金跟踪器","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,"个人资金跟踪器"]
[]
[{"$nulls":3},"现金摘要"]
[{"$nulls":3},"帐户","起始现金","支出总计","剩余现金"]
[{"$nulls":3},"支票帐户 ",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(CashSpent[帐户],\"=\" &CashSummaryTable[[#This Row],[帐户]],CashSpent[金额])","v":{"v":428,"d":"428.00"}},{"$f":"CashSummaryTable[[#This Row],[起始现金]]-CashSummaryTable[[#This Row],[支出总计]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"储蓄帐户 ",{"v":500,"d":"500.00"},{"$f":"SUMIF(CashSpent[帐户],\"=\" &CashSummaryTable[[#This Row],[帐户]],CashSpent[金额])","v":{"v":450,"d":"450.00"}},{"$f":"CashSummaryTable[[#This Row],[起始现金]]-CashSummaryTable[[#This Row],[支出总计]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"其他 ",{"v":200,"d":"200.00"},{"$f":"SUMIF(CashSpent[帐户],\"=\" &CashSummaryTable[[#This Row],[帐户]],CashSpent[金额])","v":{"v":30,"d":"30.00"}},{"$f":"CashSummaryTable[[#This Row],[起始现金]]-CashSummaryTable[[#This Row],[支出总计]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3}," 总计  ",{"$f":"SUBTOTAL(109,CashSummaryTable[起始现金])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[支出总计])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[剩余现金])","v":{"v":2792,"d":"2792.00"}}]
[]
[{"$nulls":3},"已支付的现金"]
[{"$nulls":3},"日期","说明","金额","帐户"]
[{"$nulls":3},"2012-01-04","ATM 取款 ",{"v":40,"d":"40.00"},"支票帐户 "]
[{"$nulls":3},"2012-01-05","午餐 ",{"v":5,"d":"5.00"},"支票帐户 "]
[{"$nulls":3},"2012-01-06","车贷 ",{"v":230,"d":"230.00"},"储蓄帐户 "]
[{"$nulls":3},"2012-02-03","电子支付 ",{"v":70,"d":"70.00"},"支票帐户 "]
[{"$nulls":3},"2012-02-07","晚餐 ",{"v":53,"d":"53.00"},"支票帐户 "]
[{"$nulls":3},"2012-03-01","提取现金 ",{"v":100,"d":"100.00"},"储蓄帐户 "]
[{"$nulls":3},"2012-03-06","车贷 ",{"v":230,"d":"230.00"},"支票帐户 "]
[{"$nulls":3},"2012-04-06","电子支付 ",{"v":70,"d":"70.00"},"储蓄帐户 "]
[null,"剩余现金：",null,"2012-04-20","ATM 取款 ",{"v":30,"d":"30.00"},"支票帐户 "]
[{"$nulls":3},"2012-05-03","ATM 取款 ",{"v":50,"d":"50.00"},"储蓄帐户 "]
[null,{"$f":"CashSummaryTable[[#Totals],[剩余现金]]/CashSummaryTable[[#Totals],[起始现金]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-10","ATM 取款 ",{"v":30,"d":"30.00"},"其他 "]

{"sheet":"每月摘要","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"每月摘要"]
[null,"帐户摘要"]
{"$rows_empty":13}
[null,"支出摘要"]
[null,"求和项:金额"]
[null,null,"储蓄帐户 ","其他 ","支票帐户 ","总计"]
[null,"1月",230,null,45,275]
[null,"2月",null,null,123,123]
[null,"3月"]
[null,"车贷 ",null,null,230,230]
[null,"提取现金 ",100,null,null,100]
[null,"4月",70,null,30,100]
[null,"5月",50,30,null,80]
[null,"总计",450,30,428,908]

{"sheet":"图表数据","index":2,"n_rows":6,"n_cols":4,"rows_kept":6}
[null,"数据透视图数据"]
[null,"此数据透视表是“每月摘要”工作表上的“帐户摘要”数据透视图的数据源"]
[null,"求和项:金额","列标签"]
[null,"行标签","其他 ","总计"]
[null,"5月",{"v":30,"d":"30.00"},{"v":30,"d":"30.00"}]
[null,"总计",{"v":30,"d":"30.00"},{"v":30,"d":"30.00"}]