{"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(用掉的現金[帳戶],\"=\" &現金摘要表[[#This Row],[帳戶]],用掉的現金[金額])","v":{"v":428,"d":"428.00"}},{"$f":"現金摘要表[[#This Row],[期初現金]]-現金摘要表[[#This Row],[總開銷]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"儲蓄",{"v":500,"d":"500.00"},{"$f":"SUMIF(用掉的現金[帳戶],\"=\" &現金摘要表[[#This Row],[帳戶]],用掉的現金[金額])","v":{"v":450,"d":"450.00"}},{"$f":"現金摘要表[[#This Row],[期初現金]]-現金摘要表[[#This Row],[總開銷]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"其他",{"v":200,"d":"200.00"},{"$f":"SUMIF(用掉的現金[帳戶],\"=\" &現金摘要表[[#This Row],[帳戶]],用掉的現金[金額])","v":{"v":30,"d":"30.00"}},{"$f":"現金摘要表[[#This Row],[期初現金]]-現金摘要表[[#This Row],[總開銷]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3}," 合計 ",{"$f":"SUBTOTAL(109,現金摘要表[期初現金])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,現金摘要表[總開銷])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,現金摘要表[現金餘額])","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,"現金\n餘額：",null,"2012-04-20","ATM 提款 ",{"v":30,"d":"30.00"},"活期存款"]
[{"$nulls":3},"2012-05-03","ATM 提款 ",{"v":50,"d":"50.00"},"儲蓄"]
[null,{"$f":"現金摘要表[[#Totals],[現金餘額]]/現金摘要表[[#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月",45,null,230,275]
[null,"2月",123,null,null,123]
[null,"3月",230,null,100,330]
[null,"現金提領 ",null,null,100,100]
[null,"車貸 ",230,null,null,230]
[null,"4月",30,null,70,100]
[null,"5月",null,30,50,80]
[null,"總計",428,30,450,908]

{"sheet":"表格資料","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"樞紐分析表資料"]
[null,"此樞紐分析表為 [每月摘要] 工作表的 [帳戶摘要] 樞紐分析表之資料來源"]
[null,"合計 / 金額","欄標籤"]
[null,"列標籤","活期存款","其他","儲蓄","總計"]
[null,"1月",{"v":45,"d":"45.00"},null,{"v":230,"d":"230.00"},{"v":275,"d":"275.00"}]
[null,"2月",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"3月",{"v":230,"d":"230.00"},null,{"v":100,"d":"100.00"},{"v":330,"d":"330.00"}]
[null,"4月",{"v":30,"d":"30.00"},null,{"v":70,"d":"70.00"},{"v":100,"d":"100.00"}]
[null,"5月",null,{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},{"v":80,"d":"80.00"}]
[null,"總計",{"v":428,"d":"428.00"},{"v":30,"d":"30.00"},{"v":450,"d":"450.00"},{"v":908,"d":"908.00"}]