{"text_format":"3","workbook":"xlsx","n_sheets":4,"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":[[0,1,1,5],[2,1,2,2],[2,3,2,4],[3,1,18,1],[19,1,20,1],[21,1,22,1]]}
[null,"個人理財追蹤工具"]
[{"$nulls":6},"支出現金 >"]
[{"$nulls":3},"現金摘要"]
[null,"這個儲存格是顯示可用現金百分比的直條圖。",null,"帳戶","起始現金","支出總計","剩餘現金"]
[{"$nulls":3},"支票",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(已花費現金[帳戶],\"=\" &現金摘要資料表[[#This Row],[帳戶]],已花費現金[金額])","v":{"v":496,"d":"496.00"}},{"$f":"現金摘要資料表[[#This Row],[起始現金]]-現金摘要資料表[[#This Row],[支出總計]]","v":{"v":2504,"d":"2504.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":976,"d":"976.00"}},{"$f":"SUBTOTAL(109,現金摘要資料表[剩餘現金])","v":{"v":2724,"d":"2724.00"}}]
{"$rows_empty":11}
[null,"現金剩餘："]
[]
[null,{"$f":"現金摘要資料表[[#Totals],[剩餘現金]]/現金摘要資料表[[#Totals],[起始現金]]","v":{"v":0.7362162162162162,"d":"74%"}}]

{"sheet":"支出現金","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,1,1,3],[2,1,2,2],[3,5,6,6],[7,5,14,6]]}
[null,"個人理財追蹤工具"]
[{"$nulls":4},"< 現金摘要","每月摘要 >"]
[null,"支出現金"]
[null,"日期","描述","金額","帳戶","此儲存格為依據 [帳戶類型] 來篩選表格資料的交叉分析篩選器。"]
[null,{"$f":"TODAY()+105","v":"2023-04-04"},"ATM 提款",{"v":40,"d":"40.00"},"支票"]
[null,{"$f":"TODAY()+106","v":"2023-04-05"},"午餐",{"v":5,"d":"5.00"},"支票"]
[null,{"$f":"TODAY()+107","v":"2023-04-06"},"車輛相關費用",{"v":230,"d":"230.00"},"儲蓄"]
[null,{"$f":"TODAY()+135","v":"2023-05-04"},"電費",{"v":70,"d":"70.00"},"支票","此儲存格為依據 [描述] 來篩選表格資料的交叉分析篩選器。"]
[null,{"$f":"TODAY()+139","v":"2023-05-08"},"晚餐",{"v":53,"d":"53.00"},"支票"]
[null,{"$f":"TODAY()+162","v":"2023-05-31"},"現金提款",{"v":100,"d":"100.00"},"儲蓄"]
[null,{"$f":"TODAY()+167","v":"2023-06-05"},"車輛相關費用",{"v":230,"d":"230.00"},"支票"]
[null,{"$f":"TODAY()+198","v":"2023-07-06"},"電費",{"v":70,"d":"70.00"},"儲蓄"]
[null,{"$f":"TODAY()+212","v":"2023-07-20"},"ATM 提款",{"v":30,"d":"30.00"},"支票"]
[null,{"$f":"TODAY()+225","v":"2023-08-02"},"ATM 提款",{"v":50,"d":"50.00"},"儲蓄"]
[null,{"$f":"TODAY()+232","v":"2023-08-09"},"ATM 提款",{"v":30,"d":"30.00"},"其他"]
[null,{"$f":"TODAY()+283","v":"2023-09-29"},"電費",{"v":68,"d":"68.00"},"支票"]

{"sheet":"每月摘要","index":2,"n_rows":38,"n_cols":6,"rows_kept":38,"merged":[[0,1,1,4],[2,1,2,5],[3,1,3,6],[4,1,16,4],[4,5,8,6],[9,5,16,6],[17,1,17,5]]}
[null,"每月摘要"]
[{"$nulls":5},"< 支出現金"]
[null,"若要更新這項資料，請先選取樞紐分析圖。按一下滑鼠右鍵以取得捷徑功能表。選取 [重新整理] 或 [全部重新整理] 來更新圖表。"]
[null,"帳戶摘要"]
[null,"這個儲存格是比較每個月的支票、儲蓄和其他帳戶的帳戶摘要直條圖。",{"$nulls":3},"此儲存格為依據 [帳戶類型] 來篩選圖表的交叉分析篩選器。"]
[]
[]
[]
[]
[{"$nulls":5},"此儲存格為依據 [描述] 來篩選圖表的交叉分析篩選器。"]
{"$rows_empty":7}
[null,"支出摘要"]
[null,"詳細資料"]
[null,null,"支票","儲蓄","其他","Grand Total"]
[null,"Apr",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"ATM 提款",{"v":40,"d":"40.00"},null,null,{"v":40,"d":"40.00"}]
[null,"午餐",{"v":5,"d":"5.00"},null,null,{"v":5,"d":"5.00"}]
[null,"車輛相關費用",null,{"v":230,"d":"230.00"},null,{"v":230,"d":"230.00"}]
[null,"May",{"v":123,"d":"123.00"},{"v":100,"d":"100.00"},null,{"v":223,"d":"223.00"}]
[null,"晚餐",{"v":53,"d":"53.00"},null,null,{"v":53,"d":"53.00"}]
[null,"現金提款",null,{"v":100,"d":"100.00"},null,{"v":100,"d":"100.00"}]
[null,"電費",{"v":70,"d":"70.00"},null,null,{"v":70,"d":"70.00"}]
[null,"Jun",{"v":230,"d":"230.00"},null,null,{"v":230,"d":"230.00"}]
[null,"車輛相關費用",{"v":230,"d":"230.00"},null,null,{"v":230,"d":"230.00"}]
[null,"Jul",{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},null,{"v":100,"d":"100.00"}]
[null,"ATM 提款",{"v":30,"d":"30.00"},null,null,{"v":30,"d":"30.00"}]
[null,"電費",null,{"v":70,"d":"70.00"},null,{"v":70,"d":"70.00"}]
[null,"Aug",null,{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"ATM 提款",null,{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"Sep",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"電費",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"Grand Total",{"v":496,"d":"496.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":976,"d":"976.00"}]

{"sheet":"圖表資料","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,0,2]]}
[null,"樞紐分析圖資料"]
[null,"此樞紐分析表是 [每月摘要] 工作表上的 [帳戶摘要樞紐分析圖] 的資料來源"]
[null,"加總 - 金額","Column Labels"]
[null,"Row Labels","支票","儲蓄","其他","Grand Total"]
[null,"Apr",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"May",{"v":123,"d":"123.00"},{"v":100,"d":"100.00"},null,{"v":223,"d":"223.00"}]
[null,"Jun",{"v":230,"d":"230.00"},null,null,{"v":230,"d":"230.00"}]
[null,"Jul",{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},null,{"v":100,"d":"100.00"}]
[null,"Aug",null,{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"Sep",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"Grand Total",{"v":496,"d":"496.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":976,"d":"976.00"}]