{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["仪表板","费用记录","个人费用数据"],"not_rendered":{"charts":1,"images":1,"defined_names":4,"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":"¥29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2019-03-02"},"住房","座机",{"v":39,"d":"¥39.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"住房","电费",{"v":62,"d":"¥62.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"娱乐费用","健身",{"v":29,"d":"¥29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"日常费用","服装",{"v":42,"d":"¥42.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"交通费用","地铁票",{"v":21,"d":"¥21.00"},"3 月地铁票"]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"交通费用","油费",{"v":54,"d":"¥54.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"日常费用","理发",{"v":12,"d":"¥12.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"日常费用","茶/咖啡",{"v":12,"d":"¥12.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"日常费用","甜食/糖果",{"v":2.75,"d":"¥2.75"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"住房","上网",{"v":29,"d":"¥29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"住房","座机",{"v":39,"d":"¥39.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"住房","电费",{"v":62,"d":"¥62.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"日常费用","隐形眼镜",{"v":29,"d":"¥29.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"日常费用","服装",{"v":42,"d":"¥42.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"交通费用","地铁票",{"v":21,"d":"¥21.00"},"4 月地铁票"]
[null,{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2019-05-01"},"交通费用","油费",{"v":54,"d":"¥54.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2019-06-01"},"日常费用","理发",{"v":12,"d":"¥12.00"}]
[null,{"$f":"DATE(YEAR(TODAY()),7,1)","v":"2019-07-01"},"娱乐费用","电影",{"v":21,"d":"¥21.00"},"经典电影之夜"]
[null,{"$f":"DATE(YEAR(TODAY()),8,1)","v":"2019-08-01"},"日常费用","甜食/糖果",{"v":2.75,"d":"¥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月",21,42,29,130,222]
[null,"4月",75,97.75,null,130,302.75]
[null,"5月",54,{"$nulls":3},54]
[null,"6月",null,12,null,null,12]
[null,"7月",null,null,21,null,21]
[null,"8月",null,2.75,null,null,2.75]
[null,"总计",150,154.5,50,260,614.5]