{"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,"现金\n剩余:"]
[]
[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":37,"n_cols":6,"rows_kept":37,"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,"车贷",null,{"v":230,"d":"230.00"},null,{"v":230,"d":"230.00"}]
[null,"午餐",{"v":5,"d":"5.00"},null,null,{"v":5,"d":"5.00"}]
[null,"May",{"v":123,"d":"123.00"},{"v":100,"d":"100.00"},null,{"v":223,"d":"223.00"}]
[null,"付电费",{"v":70,"d":"70.00"},null,null,{"v":70,"d":"70.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,"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,"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"}]