{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["儀表板","支出記錄","個人支出資料"],"not_rendered":{"charts":1,"images":1,"defined_names":5,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"儀表板","index":0,"n_rows":3,"n_cols":6,"rows_kept":3,"merged":[[0,2,0,4],[1,1,1,5],[2,1,2,2],[2,3,2,4]]}
[null,null,"個人支出儀表板",null,null,"移至 [支出記錄] >"]
[null,"此儲存格為依類別和月份顯示支出的樞紐分析圖。下方的儲存格 B3、D3 和 F3 為依據日期、類別和子類別來篩選支出的交叉分析篩選器。"]
[null,"此儲存格為依據日期來篩選表格資料的交叉分析篩選器。",null,"此儲存格為依據類別來篩選表格資料的交叉分析篩選器。",null,"此儲存格為依據子類別來篩選表格資料的交叉分析篩選器。"]

{"sheet":"支出記錄","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,1,0,3]]}
[null,"支出記錄",{"$nulls":3},"< 移至 [儀表板]"]
[null,"日期","類別","子類別","金額","附註"]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2019-03-02"},"住宅","網際網路",{"v":29,"d":"NT$29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2019-03-02"},"住宅","室內電話",{"v":39,"d":"NT$39.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"住宅","電費",{"v":62,"d":"NT$62.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"娛樂","健身房",{"v":29,"d":"NT$29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"日常","衣物",{"v":42,"d":"NT$42.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"交通","地鐵月票",{"v":21,"d":"NT$21.00"},"三月月票"]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"交通","油資",{"v":54,"d":"NT$54.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"日常","理髮",{"v":12,"d":"NT$12.00"}]
[null,"2019-04-02","日常","茶/咖啡",{"v":12,"d":"NT$12.00"}]
[null,"2019-04-02","日常","甜點 / 糖果",{"v":2.75,"d":"NT$2.75"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"住宅","網際網路",{"v":29,"d":"NT$29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"住宅","室內電話",{"v":39,"d":"NT$39.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"住宅","電費",{"v":62,"d":"NT$62.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"日常","隱形眼鏡",{"v":29,"d":"NT$29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"日常","衣物",{"v":42,"d":"NT$42.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"交通","地鐵月票",{"v":21,"d":"NT$21.00"},"四月月票"]
[null,{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2019-05-01"},"交通","油資",{"v":54,"d":"NT$54.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2019-06-01"},"日常","理髮",{"v":12,"d":"NT$12.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),7,1)","v":"2019-07-01"},"娛樂","電影院",{"v":21,"d":"NT$21.00"},"經典電影之夜"]
[null,{"$f":"DATE(YEAR(TODAY()),8,1)","v":"2019-08-01"},"日常","甜點 / 糖果",{"v":2.75,"d":"NT$2.75"}]

{"sheet":"個人支出資料","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"hidden":true,"merged":[[0,1,0,6],[1,1,1,6]]}
[null,"個人支出資料"]
[null,"下方的樞紐分析表提供 [儀表板] 中 [個人支出] 樞紐分析圖的資料來源。您所做的任何變更都可能修改樞紐分析圖的視覺外觀或造成錯誤。"]
[null,"加總 - 金額","欄標籤"]
[null,"列標籤","日常","交通","住宅","娛樂","總計"]
[null,"3月",42,21,130,29,222]
[null,"4月",97.75,75,130,null,302.75]
[null,"5月",null,54,null,null,54]
[null,"6月",12,{"$nulls":3},12]
[null,"7月",{"$nulls":3},21,21]
[null,"8月",2.75,{"$nulls":3},2.75]
[null,"總計",154.5,150,260,50,614.5]