{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["指南","每年现金流","每月现金流","每日汇总","收入","支出","自由支配","存款"],"not_rendered":{"charts":4,"defined_names":34},"read":"whole","date_system":"1900"}

{"sheet":"指南","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5]]}
[{"$nulls":6},"指南","收入"]
[null,"个人现金流"]
[null,"此工作簿包含每年、每月和每天的现金流工作表。选择最适合你的现金流类型，或者试用所有类型，帮助深入了解个人现金流。"]
[]
[null,"每年现金流",null,"每月现金流",null,"每日现金流"]
[null,"输入各个领域的每年现金流。查看每月细分以及对比情况，最重要的是年度和月度数据中的损益。",null,"输入每月现金流量或者估算剩余月份的流量，以查看该年和每月的预计现金流量。",null,"输入预估的每日现金流量，并查看估算的月度和年度总计。使用该工作表来了解你一个月或一年中的日常消费习惯。"]

{"sheet":"每年现金流","index":1,"n_rows":6,"n_cols":15,"rows_kept":6,"merged":[[0,1,0,5],[0,7,0,8],[1,1,1,2],[1,3,1,5],[1,6,1,15],[2,1,2,3],[2,5,2,7],[2,9,2,11],[2,13,2,15],[3,2,3,3],[3,6,3,7],[3,10,3,11],[3,14,3,15],[4,1,4,3],[4,5,4,7],[4,9,4,11],[4,13,4,15],[5,2,5,3],[5,6,5,7],[5,10,5,11],[5,14,5,15]]}
[null,"个人现金流",{"$nulls":4},"指南","每年现金流",null,"每月现金流"]
[null,"到目前为止的总现金流：",null,{"$f":"到目前为止的年度现金流","v":{"v":39750,"d":"¥39,750.00"}},null,null,"这是年度估算值。若要查看年度金额与每月估算值，请使用此工作表。使用其他工作表添加每日项目。"]
[null,"收入汇总",{"$nulls":3},"支出汇总",{"$nulls":3},"自由支配汇总",{"$nulls":3},"存款汇总"]
[null,"每年总计：",{"$f":"收入!C10","v":{"v":125000,"d":"¥125,000.00"}},null,null,"每年总计：",{"$f":"支出[[#Totals],[每年  ]]","v":{"v":49000,"d":"¥49,000.00"}},null,null,"每年总计：",{"$f":"自由支配[[#Totals],[每年  ]]","v":{"v":13250,"d":"¥13,250.00"}},null,null,"每年总计：",{"$f":"存款[[#Totals],[每年  ]]","v":{"v":23000,"d":"¥23,000.00"}}]
[null,"此单元格中的饼图显示不同来源的收入。",{"$nulls":3},"此单元格中的饼图显示各项支出。",{"$nulls":3},"此单元格中的饼图显示自由支配性支出。",{"$nulls":3},"此单元格中的饼图显示存款和投资。"]
[null,"每月总计：",{"$f":"收入!D10","v":{"v":10416.666666666668,"d":"¥10,416.67"}},null,null,"每月总计：",{"$f":"支出[[#Totals],[每月 ]]","v":{"v":4083.333333333333,"d":"¥4,083.33"}},null,null,"每月总计：",{"$f":"自由支配[[#Totals],[每月 ]]","v":{"v":1104.1666666666665,"d":"¥1,104.17"}},null,null,"每月总计：",{"$f":"存款!D9","v":{"v":1916.6666666666667,"d":"¥1,916.67"}}]

{"sheet":"每月现金流","index":2,"n_rows":47,"n_cols":16,"rows_kept":47,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[1,5,1,15],[47,1,47,15]]}
[null,"个人现金流",{"$nulls":5},"指南","每年现金流","每月现金流","每日汇总"]
[null,"每月现金流总计：",null,{"$f":"到目前为止的月度现金流","v":{"v":18380,"d":"¥18,380.00"}},null,"注意：对于日常项目，请估算每月的金额/价值，并将该值放在相应的月份列中。"]
[null,"类型","说明","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","汇总"]
[null,"收入","薪酬",{"v":7500,"d":"¥7,500.00"},{"v":7500,"d":"¥7,500.00"},{"v":7500,"d":"¥7,500.00"},{"v":7500,"d":"¥7,500.00"},{"v":7500,"d":"¥7,500.00"},{"v":7500,"d":"¥7,500.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":45000,"d":"¥45,000.00"}}]
[null,"收入","佣金/奖金",{"v":400,"d":"¥400.00"},{"v":400,"d":"¥400.00"},{"v":500,"d":"¥500.00"},{"v":200,"d":"¥200.00"},{"v":0,"d":"¥0.00"},{"v":600,"d":"¥600.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":2100,"d":"¥2,100.00"}}]
[null,"收入","其他 1",{"v":2500,"d":"¥2,500.00"},{"v":2500,"d":"¥2,500.00"},{"v":2500,"d":"¥2,500.00"},{"v":2500,"d":"¥2,500.00"},{"v":2500,"d":"¥2,500.00"},{"v":2500,"d":"¥2,500.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":15000,"d":"¥15,000.00"}}]
[null,"收入","其他 2",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,"收入","其他 3",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,"收入","其他 4",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,"支出","联邦/SS/医疗保险",{"v":1250,"d":"¥1,250.00"},{"v":1250,"d":"¥1,250.00"},{"v":1250,"d":"¥1,250.00"},{"v":1250,"d":"¥1,250.00"},{"v":1250,"d":"¥1,250.00"},{"v":1250,"d":"¥1,250.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":7500,"d":"¥7,500.00"}}]
[null,"支出","州所得税",{"v":208.33333333333334,"d":"¥208.33"},{"v":208.33333333333334,"d":"¥208.33"},{"v":208.33333333333334,"d":"¥208.33"},{"v":208.33333333333334,"d":"¥208.33"},{"v":208.33333333333334,"d":"¥208.33"},{"v":208.33333333333334,"d":"¥208.33"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":1250,"d":"¥1,250.00"}}]
[null,"支出","车辆税/费用",{"v":16.666666666666668,"d":"¥16.67"},{"v":16.666666666666668,"d":"¥16.67"},{"v":16.666666666666668,"d":"¥16.67"},{"v":16.666666666666668,"d":"¥16.67"},{"v":16.666666666666668,"d":"¥16.67"},{"v":16.666666666666668,"d":"¥16.67"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":100.00000000000001,"d":"¥100.00"}}]
[null,"支出","汽车还款",{"v":333.3333333333333,"d":"¥333.33"},{"v":333.3333333333333,"d":"¥333.33"},{"v":333.3333333333333,"d":"¥333.33"},{"v":333.3333333333333,"d":"¥333.33"},{"v":333.3333333333333,"d":"¥333.33"},{"v":333.3333333333333,"d":"¥333.33"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":1999.9999999999998,"d":"¥2,000.00"}}]
[null,"支出","按揭费用/租金",{"v":1250,"d":"¥1,250.00"},{"v":1250,"d":"¥1,250.00"},{"v":1250,"d":"¥1,250.00"},{"v":1250,"d":"¥1,250.00"},{"v":1250,"d":"¥1,250.00"},{"v":1250,"d":"¥1,250.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":7500,"d":"¥7,500.00"}}]
[null,"支出","保险",{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":150,"d":"¥150.00"}}]
[null,"支出","电费",{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":600,"d":"¥600.00"}}]
[null,"支出","燃气",{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":300,"d":"¥300.00"}}]
[null,"支出","水费",{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":300,"d":"¥300.00"}}]
[null,"支出","排污费",{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":150,"d":"¥150.00"}}]
[null,"支出","垃圾费",{"v":12.5,"d":"¥12.50"},{"v":12.5,"d":"¥12.50"},{"v":12.5,"d":"¥12.50"},{"v":12.5,"d":"¥12.50"},{"v":12.5,"d":"¥12.50"},{"v":12.5,"d":"¥12.50"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":75,"d":"¥75.00"}}]
[null,"支出","电话",{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":300,"d":"¥300.00"}}]
[null,"支出","上网",{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":300,"d":"¥300.00"}}]
[null,"支出","人寿保险费/残疾保险费",{"v":125,"d":"¥125.00"},{"v":125,"d":"¥125.00"},{"v":125,"d":"¥125.00"},{"v":125,"d":"¥125.00"},{"v":125,"d":"¥125.00"},{"v":125,"d":"¥125.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":750,"d":"¥750.00"}}]
[null,"支出","食物",{"v":400,"d":"¥400.00"},{"v":500,"d":"¥500.00"},{"v":450,"d":"¥450.00"},{"v":400,"d":"¥400.00"},{"v":450,"d":"¥450.00"},{"v":425,"d":"¥425.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":2625,"d":"¥2,625.00"}}]
[null,"支出","服装",{"v":50,"d":"¥50.00"},{"v":75,"d":"¥75.00"},{"v":100,"d":"¥100.00"},{"v":75,"d":"¥75.00"},{"v":125,"d":"¥125.00"},{"v":75,"d":"¥75.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":500,"d":"¥500.00"}}]
[null,"支出","医疗/牙齿/处方",{"v":50,"d":"¥50.00"},{"v":10,"d":"¥10.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":20,"d":"¥20.00"},{"v":70,"d":"¥70.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":200,"d":"¥200.00"}}]
[null,"支出","公交",{"v":30,"d":"¥30.00"},{"v":30,"d":"¥30.00"},{"v":30,"d":"¥30.00"},{"v":20,"d":"¥20.00"},{"v":30,"d":"¥30.00"},{"v":30,"d":"¥30.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":170,"d":"¥170.00"}}]
[null,"支出","其他 2",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,"支出","其他 3",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,"支出","其他 4",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,"自由支配","就餐",{"v":50,"d":"¥50.00"},{"v":150,"d":"¥150.00"},{"v":100,"d":"¥100.00"},{"v":50,"d":"¥50.00"},{"v":150,"d":"¥150.00"},{"v":100,"d":"¥100.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":600,"d":"¥600.00"}}]
[null,"自由支配","礼品",{"v":25,"d":"¥25.00"},{"v":75,"d":"¥75.00"},{"v":50,"d":"¥50.00"},{"v":25,"d":"¥25.00"},{"v":75,"d":"¥75.00"},{"v":50,"d":"¥50.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":300,"d":"¥300.00"}}]
[null,"自由支配","旅行",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":1000,"d":"¥1,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":1000,"d":"¥1,000.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":2000,"d":"¥2,000.00"}}]
[null,"自由支配","娱乐",{"v":50,"d":"¥50.00"},{"v":150,"d":"¥150.00"},{"v":100,"d":"¥100.00"},{"v":50,"d":"¥50.00"},{"v":150,"d":"¥150.00"},{"v":100,"d":"¥100.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":600,"d":"¥600.00"}}]
[null,"自由支配","个人护理",{"v":15,"d":"¥15.00"},{"v":25,"d":"¥25.00"},{"v":35,"d":"¥35.00"},{"v":15,"d":"¥15.00"},{"v":25,"d":"¥25.00"},{"v":35,"d":"¥35.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":150,"d":"¥150.00"}}]
[null,"自由支配","购物",{"v":100,"d":"¥100.00"},{"v":200,"d":"¥200.00"},{"v":150,"d":"¥150.00"},{"v":175,"d":"¥175.00"},{"v":150,"d":"¥150.00"},{"v":175,"d":"¥175.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":950,"d":"¥950.00"}}]
[null,"自由支配","慈善",{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":300,"d":"¥300.00"}}]
[null,"自由支配","俱乐部/会员",{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":150,"d":"¥150.00"}}]
[null,"自由支配","住房改善",{"v":400,"d":"¥400.00"},{"v":400,"d":"¥400.00"},{"v":400,"d":"¥400.00"},{"v":400,"d":"¥400.00"},{"v":400,"d":"¥400.00"},{"v":400,"d":"¥400.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":2400,"d":"¥2,400.00"}}]
[null,"自由支配","其他 1",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,"自由支配","其他 2",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,"存款","现金储备",{"v":416.6666666666667,"d":"¥416.67"},{"v":416.6666666666667,"d":"¥416.67"},{"v":416.6666666666667,"d":"¥416.67"},{"v":416.6666666666667,"d":"¥416.67"},{"v":416.6666666666667,"d":"¥416.67"},{"v":416.6666666666667,"d":"¥416.67"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":2500,"d":"¥2,500.00"}}]
[null,"存款","401(k)/等",{"v":1000,"d":"¥1,000.00"},{"v":1000,"d":"¥1,000.00"},{"v":1000,"d":"¥1,000.00"},{"v":1000,"d":"¥1,000.00"},{"v":1000,"d":"¥1,000.00"},{"v":1000,"d":"¥1,000.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":6000,"d":"¥6,000.00"}}]
[null,"存款","存款/投资帐户",{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":3000,"d":"¥3,000.00"}}]
[null,"存款","其他 1",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,"存款","其他 2",{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"$nulls":6},{"$f":"SUM(每月[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null," 汇总",null,{"$f":"SUMIF(每月[类型],\"收入\",每月[1 月])-SUMIF(每月[类型],\"<>收入\",每月[1 月])","v":{"v":3692.5,"d":"¥3,692.50"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[2 月])-SUMIF(每月[类型],\"<>收入\",每月[2 月])","v":{"v":3247.5,"d":"¥3,247.50"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[3 月])-SUMIF(每月[类型],\"<>收入\",每月[3 月])","v":{"v":2522.5,"d":"¥2,522.50"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[4 月])-SUMIF(每月[类型],\"<>收入\",每月[4 月])","v":{"v":3427.5,"d":"¥3,427.50"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[5 月])-SUMIF(每月[类型],\"<>收入\",每月[5 月])","v":{"v":2887.5,"d":"¥2,887.50"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[6 月])-SUMIF(每月[类型],\"<>收入\",每月[6 月])","v":{"v":2602.5,"d":"¥2,602.50"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[7 月])-SUMIF(每月[类型],\"<>收入\",每月[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[8 月])-SUMIF(每月[类型],\"<>收入\",每月[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[9 月])-SUMIF(每月[类型],\"<>收入\",每月[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[10 月])-SUMIF(每月[类型],\"<>收入\",每月[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[11 月])-SUMIF(每月[类型],\"<>收入\",每月[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[12 月])-SUMIF(每月[类型],\"<>收入\",每月[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIF(每月[类型],\"收入\",每月[汇总])-SUMIF(每月[类型],\"<>收入\",每月[汇总])","v":{"v":18380,"d":"¥18,380.00"}}]

{"sheet":"每日汇总","index":3,"n_rows":53,"n_cols":9,"rows_kept":53,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,1,12]]}
[null,"个人现金流",{"$nulls":3},"指南","每月现金流","每日汇总","收入"]
[null,"可用现金总额：",null,{"$f":"每日现金流","v":{"v":577.8399999999999,"d":"¥577.84"}},null,"注意：若要将日常项目添加到表中，请估算它们的每月金额/值，并将该值放在相应的月份列中。"]
[null,"每日汇总"]
[null,"总计","每日","每月","每年 "]
[null,"收入",{"$f":"SUMIF(每日[类型],$B5,每日[每日])","v":{"v":342.47,"d":"¥342.47"}},{"$f":"SUMIF(每日[类型],$B5,每日[每月])","v":{"v":10416.795833333334,"d":"¥10,416.80"}},{"$f":"SUMIF(每日[类型],$B5,每日[每年])","v":{"v":125001.55000000002,"d":"¥125,001.55"}}]
[null,"支出",{"$f":"SUMIF(每日[类型],$B6,每日[每日])","v":{"v":136.05999999999997,"d":"¥136.06"}},{"$f":"SUMIF(每日[类型],$B6,每日[每月])","v":{"v":4138.491666666667,"d":"¥4,138.49"}},{"$f":"SUMIF(每日[类型],$B6,每日[每年])","v":{"v":49661.899999999994,"d":"¥49,661.90"}}]
[null,"自由支配",{"$f":"SUMIF(每日[类型],$B7,每日[每日])","v":{"v":36.29,"d":"¥36.29"}},{"$f":"SUMIF(每日[类型],$B7,每日[每月])","v":{"v":1103.8208333333334,"d":"¥1,103.82"}},{"$f":"SUMIF(每日[类型],$B7,每日[每年])","v":{"v":13245.849999999999,"d":"¥13,245.85"}}]
[null,"存款",{"$f":"SUMIF(每日[类型],$B8,每日[每日])","v":{"v":63.019999999999996,"d":"¥63.02"}},{"$f":"SUMIF(每日[类型],$B8,每日[每月])","v":{"v":1916.8583333333333,"d":"¥1,916.86"}},{"$f":"SUMIF(每日[类型],$B8,每日[每年])","v":{"v":23002.300000000003,"d":"¥23,002.30"}}]
[null,"类型","说明","每日","每月","每年"]
[null,"收入","薪酬",{"v":246.58,"d":"¥246.58"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":7500.141666666667,"d":"¥7,500.14"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":90001.70000000001,"d":"¥90,001.70"}}]
[null,"收入","佣金/奖金",{"v":13.7,"d":"¥13.70"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":416.7083333333333,"d":"¥416.71"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":5000.5,"d":"¥5,000.50"}}]
[null,"收入","其他 1",{"v":82.19,"d":"¥82.19"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":2499.945833333333,"d":"¥2,499.95"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":29999.35,"d":"¥29,999.35"}}]
[null,"收入","其他 2",{"v":0,"d":"¥0.00"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":0,"d":"¥0.00"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":0,"d":"¥0.00"}}]
[null,"收入","其他 3",{"v":0,"d":"¥0.00"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":0,"d":"¥0.00"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":0,"d":"¥0.00"}}]
[null,"收入","其他 4",{"v":0,"d":"¥0.00"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":0,"d":"¥0.00"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":0,"d":"¥0.00"}}]
[null,"支出","联邦/SS/医疗保险",{"v":41.1,"d":"¥41.10"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":1250.125,"d":"¥1,250.13"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":15001.5,"d":"¥15,001.50"}}]
[null,"支出","州所得税",{"v":6.85,"d":"¥6.85"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":208.35416666666666,"d":"¥208.35"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":2500.25,"d":"¥2,500.25"}}]
[null,"支出","车辆税/费用",{"v":0.55,"d":"¥0.55"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":16.729166666666668,"d":"¥16.73"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":200.75000000000003,"d":"¥200.75"}}]
[null,"支出","汽车还款",{"v":10.96,"d":"¥10.96"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":333.3666666666667,"d":"¥333.37"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":4000.4,"d":"¥4,000.40"}}]
[null,"支出","按揭费用/租金",{"v":41.1,"d":"¥41.10"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":1250.125,"d":"¥1,250.13"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":15001.5,"d":"¥15,001.50"}}]
[null,"支出","保险",{"v":0.68,"d":"¥0.68"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":20.683333333333334,"d":"¥20.68"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":248.20000000000002,"d":"¥248.20"}}]
[null,"支出","电费",{"v":3.29,"d":"¥3.29"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":100.07083333333333,"d":"¥100.07"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":1200.85,"d":"¥1,200.85"}}]
[null,"支出","燃气",{"v":1.64,"d":"¥1.64"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":49.883333333333326,"d":"¥49.88"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":598.5999999999999,"d":"¥598.60"}}]
[null,"支出","水费",{"v":1.64,"d":"¥1.64"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":49.883333333333326,"d":"¥49.88"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":598.5999999999999,"d":"¥598.60"}}]
[null,"支出","排污费",{"v":0.82,"d":"¥0.82"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":24.941666666666663,"d":"¥24.94"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":299.29999999999995,"d":"¥299.30"}}]
[null,"支出","垃圾费",{"v":0.41,"d":"¥0.41"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":12.470833333333331,"d":"¥12.47"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":149.64999999999998,"d":"¥149.65"}}]
[null,"支出","电话",{"v":1.64,"d":"¥1.64"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":49.883333333333326,"d":"¥49.88"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":598.5999999999999,"d":"¥598.60"}}]
[null,"支出","上网",{"v":1.64,"d":"¥1.64"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":49.883333333333326,"d":"¥49.88"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":598.5999999999999,"d":"¥598.60"}}]
[null,"支出","人寿保险费/残疾保险费",{"v":4.11,"d":"¥4.11"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":125.0125,"d":"¥125.01"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":1500.15,"d":"¥1,500.15"}}]
[null,"支出","食物",{"v":13.7,"d":"¥13.70"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":416.7083333333333,"d":"¥416.71"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":5000.5,"d":"¥5,000.50"}}]
[null,"支出","服装",{"v":3.29,"d":"¥3.29"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":100.07083333333333,"d":"¥100.07"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":1200.85,"d":"¥1,200.85"}}]
[null,"支出","医疗/牙齿/处方",{"v":1.64,"d":"¥1.64"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":49.883333333333326,"d":"¥49.88"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":598.5999999999999,"d":"¥598.60"}}]
[null,"支出","公交",{"v":1,"d":"¥1.00"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":30.416666666666668,"d":"¥30.42"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":365,"d":"¥365.00"}}]
[null,"支出","其他 2",{"v":0,"d":"¥0.00"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":0,"d":"¥0.00"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":0,"d":"¥0.00"}}]
[null,"支出","其他 3",{"v":0,"d":"¥0.00"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":0,"d":"¥0.00"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":0,"d":"¥0.00"}}]
[null,"支出","其他 4",{"v":0,"d":"¥0.00"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":0,"d":"¥0.00"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":0,"d":"¥0.00"}}]
[null,"自由支配","就餐",{"v":3.29,"d":"¥3.29"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":100.07083333333333,"d":"¥100.07"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":1200.85,"d":"¥1,200.85"}}]
[null,"自由支配","礼品",{"v":1.64,"d":"¥1.64"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":49.883333333333326,"d":"¥49.88"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":598.5999999999999,"d":"¥598.60"}}]
[null,"自由支配","旅行",{"v":6.16,"d":"¥6.16"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":187.36666666666667,"d":"¥187.37"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":2248.4,"d":"¥2,248.40"}}]
[null,"自由支配","娱乐",{"v":3.29,"d":"¥3.29"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":100.07083333333333,"d":"¥100.07"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":1200.85,"d":"¥1,200.85"}}]
[null,"自由支配","个人护理",{"v":0.82,"d":"¥0.82"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":24.941666666666663,"d":"¥24.94"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":299.29999999999995,"d":"¥299.30"}}]
[null,"自由支配","购物",{"v":5.48,"d":"¥5.48"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":166.68333333333334,"d":"¥166.68"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":2000.2,"d":"¥2,000.20"}}]
[null,"自由支配","慈善",{"v":1.64,"d":"¥1.64"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":49.883333333333326,"d":"¥49.88"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":598.5999999999999,"d":"¥598.60"}}]
[null,"自由支配","俱乐部/会员",{"v":0.82,"d":"¥0.82"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":24.941666666666663,"d":"¥24.94"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":299.29999999999995,"d":"¥299.30"}}]
[null,"自由支配","住房改善",{"v":13.15,"d":"¥13.15"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":399.9791666666667,"d":"¥399.98"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":4799.75,"d":"¥4,799.75"}}]
[null,"自由支配","其他 1",{"v":0,"d":"¥0.00"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":0,"d":"¥0.00"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":0,"d":"¥0.00"}}]
[null,"自由支配","其他 2",{"v":0,"d":"¥0.00"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":0,"d":"¥0.00"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":0,"d":"¥0.00"}}]
[null,"存款","现金储备",{"v":13.7,"d":"¥13.70"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":416.7083333333333,"d":"¥416.71"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":5000.5,"d":"¥5,000.50"}}]
[null,"存款","401(k)/等",{"v":32.88,"d":"¥32.88"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":1000.1,"d":"¥1,000.10"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":12001.2,"d":"¥12,001.20"}}]
[null,"存款","存款/投资帐户",{"v":16.44,"d":"¥16.44"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":500.05,"d":"¥500.05"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":6000.6,"d":"¥6,000.60"}}]
[null,"存款","其他 1",{"v":0,"d":"¥0.00"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":0,"d":"¥0.00"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":0,"d":"¥0.00"}}]
[null,"存款","其他 2",{"v":0,"d":"¥0.00"},{"$f":"每日[[#This Row],[每年]]/12","v":{"v":0,"d":"¥0.00"}},{"$f":"每日[[#This Row],[每日]]*365","v":{"v":0,"d":"¥0.00"}}]
[null," 汇总 ",null,{"$f":"SUMIF(每日[类型],\"收入\",每日[每日])-SUMIF(每日[类型],\"<>收入\",每日[每日])","v":{"v":107.10000000000014,"d":"¥107.10"}},{"$f":"SUMIF(每日[类型],\"收入\",每日[每月])-SUMIF(每日[类型],\"<>收入\",每日[每月])","v":{"v":3257.625,"d":"¥3,257.63"}},{"$f":"SUMIF(每日[类型],\"收入\",每日[每年])-SUMIF(每日[类型],\"<>收入\",每日[每年])","v":{"v":39091.500000000015,"d":"¥39,091.50"}}]

{"sheet":"收入","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"个人现金流",{"$nulls":3},"指南","每日汇总","收入","支出"]
[null,"到目前为止的总现金流：",null,{"$f":"到目前为止的年度现金流","v":{"v":39750,"d":"¥39,750.00"}},null,"这是年度估算值。若要查看年度金额与每月估算值，请使用此工作表\n若要将日常项目添加到表中，请估算它们每年的金额/值，并将该值放在“每年”列中。"]
[null,"收入","每年  ","每月 "]
[null,"薪酬",{"v":90000,"d":"¥90,000.00"},{"$f":"收入[[#This Row],[每年  ]]/12","v":{"v":7500,"d":"¥7,500.00"}}]
[null,"佣金/奖金",{"v":5000,"d":"¥5,000.00"},{"$f":"收入[[#This Row],[每年  ]]/12","v":{"v":416.6666666666667,"d":"¥416.67"}}]
[null,"其他 1",{"v":30000,"d":"¥30,000.00"},{"$f":"收入[[#This Row],[每年  ]]/12","v":{"v":2500,"d":"¥2,500.00"}}]
[null,"其他 2",null,{"$f":"收入[[#This Row],[每年  ]]/12","v":{"v":0,"d":"¥0.00"}}]
[null,"其他 3",null,{"$f":"收入[[#This Row],[每年  ]]/12","v":{"v":0,"d":"¥0.00"}}]
[null,"其他 4",null,{"$f":"收入[[#This Row],[每年  ]]/12","v":{"v":0,"d":"¥0.00"}}]
[null," 汇总",{"$f":"SUBTOTAL(109,收入[[每年  ]])","v":{"v":125000,"d":"¥125,000.00"}},{"$f":"SUBTOTAL(109,收入[[每月 ]])","v":{"v":10416.666666666668,"d":"¥10,416.67"}}]

{"sheet":"支出","index":5,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"个人现金流",{"$nulls":3},"指南","收入","支出","自由支配"]
[null,"到目前为止的总现金流：",null,{"$f":"到目前为止的年度现金流","v":{"v":39750,"d":"¥39,750.00"}},null,"这是年度估算值。若要查看年度金额与每月估算值，请使用此工作表\n若要将日常项目添加到表中，请估算它们每年的金额/值，并将该值放在“每年”列中。"]
[null,"支出","每年  ","每月 "]
[null,"联邦/SS/医疗保险",{"v":15000,"d":"¥15,000.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":1250,"d":"¥1,250.00"}}]
[null,"州所得税",{"v":2500,"d":"¥2,500.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":208.33333333333334,"d":"¥208.33"}}]
[null,"车辆税/费用",{"v":200,"d":"¥200.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":16.666666666666668,"d":"¥16.67"}}]
[null,"汽车还款",{"v":4000,"d":"¥4,000.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":333.3333333333333,"d":"¥333.33"}}]
[null,"按揭费用/租金",{"v":15000,"d":"¥15,000.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":1250,"d":"¥1,250.00"}}]
[null,"保险",{"v":250,"d":"¥250.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":20.833333333333332,"d":"¥20.83"}}]
[null,"电费",{"v":1200,"d":"¥1,200.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":100,"d":"¥100.00"}}]
[null,"燃气",{"v":600,"d":"¥600.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":50,"d":"¥50.00"}}]
[null,"水费/排污费",{"v":600,"d":"¥600.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":50,"d":"¥50.00"}}]
[null,"垃圾费",{"v":150,"d":"¥150.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":12.5,"d":"¥12.50"}}]
[null,"电话",{"v":600,"d":"¥600.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":50,"d":"¥50.00"}}]
[null,"上网",{"v":600,"d":"¥600.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":50,"d":"¥50.00"}}]
[null,"人寿保险费/残疾保险费",{"v":1500,"d":"¥1,500.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":125,"d":"¥125.00"}}]
[null,"食物",{"v":5000,"d":"¥5,000.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":416.6666666666667,"d":"¥416.67"}}]
[null,"服装",{"v":1200,"d":"¥1,200.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":100,"d":"¥100.00"}}]
[null,"医疗/牙齿/处方",{"v":600,"d":"¥600.00"},{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":50,"d":"¥50.00"}}]
[null,"其他 1",null,{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":0,"d":"¥0.00"}}]
[null,"其他 2",null,{"$f":"支出[[#This Row],[每年  ]]/12","v":{"v":0,"d":"¥0.00"}}]
[null," 汇总",{"$f":"SUBTOTAL(109,支出[[每年  ]])","v":{"v":49000,"d":"¥49,000.00"}},{"$f":"SUBTOTAL(109,支出[[每月 ]])","v":{"v":4083.333333333333,"d":"¥4,083.33"}}]

{"sheet":"自由支配","index":6,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"个人现金流",{"$nulls":3},"指南","支出","自由支配","存款"]
[null,"到目前为止的总现金流：",null,{"$f":"到目前为止的年度现金流","v":{"v":39750,"d":"¥39,750.00"}},null,"这是年度估算值。若要查看年度金额与每月估算值，请使用此工作表\n若要将日常项目添加到表中，请估算它们每年的金额/值，并将该值放在“每年”列中。"]
[null,"自由支配性支出","每年  ","每月 "]
[null,"就餐",{"v":1200,"d":"¥1,200.00"},{"$f":"自由支配[[#This Row],[每年  ]]/12","v":{"v":100,"d":"¥100.00"}}]
[null,"礼品",{"v":600,"d":"¥600.00"},{"$f":"自由支配[[#This Row],[每年  ]]/12","v":{"v":50,"d":"¥50.00"}}]
[null,"旅行",{"v":2250,"d":"¥2,250.00"},{"$f":"自由支配[[#This Row],[每年  ]]/12","v":{"v":187.5,"d":"¥187.50"}}]
[null,"娱乐",{"v":1200,"d":"¥1,200.00"},{"$f":"自由支配[[#This Row],[每年  ]]/12","v":{"v":100,"d":"¥100.00"}}]
[null,"个人护理",{"v":300,"d":"¥300.00"},{"$f":"自由支配[[#This Row],[每年  ]]/12","v":{"v":25,"d":"¥25.00"}}]
[null,"购物",{"v":2000,"d":"¥2,000.00"},{"$f":"自由支配[[#This Row],[每年  ]]/12","v":{"v":166.66666666666666,"d":"¥166.67"}}]
[null,"慈善",{"v":600,"d":"¥600.00"},{"$f":"自由支配[[#This Row],[每年  ]]/12","v":{"v":50,"d":"¥50.00"}}]
[null,"俱乐部/会员",{"v":300,"d":"¥300.00"},{"$f":"自由支配[[#This Row],[每年  ]]/12","v":{"v":25,"d":"¥25.00"}}]
[null,"住房改善",{"v":4800,"d":"¥4,800.00"},{"$f":"自由支配[[#This Row],[每年  ]]/12","v":{"v":400,"d":"¥400.00"}}]
[null,"其他 1",null,{"$f":"自由支配[[#This Row],[每年  ]]/12","v":{"v":0,"d":"¥0.00"}}]
[null,"其他 2",null,{"$f":"自由支配[[#This Row],[每年  ]]/12","v":{"v":0,"d":"¥0.00"}}]
[null," 汇总",{"$f":"SUBTOTAL(109,自由支配[[每年  ]])","v":{"v":13250,"d":"¥13,250.00"}},{"$f":"SUBTOTAL(109,自由支配[[每月 ]])","v":{"v":1104.1666666666665,"d":"¥1,104.17"}}]

{"sheet":"存款","index":7,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"个人现金流",{"$nulls":3},"指南","自由支配","存款"]
[null,"到目前为止的总现金流：",null,{"$f":"到目前为止的年度现金流","v":{"v":39750,"d":"¥39,750.00"}},null,"这是年度估算值。若要查看年度金额与每月估算值，请使用此工作表\n若要将日常项目添加到表中，请估算它们每年的金额/值，并将该值放在“每年”列中。"]
[null,"存款","每年  ","每月 "]
[null,"现金储备",{"v":5000,"d":"¥5,000.00"},{"$f":"存款[[#This Row],[每年  ]]/12","v":{"v":416.6666666666667,"d":"¥416.67"}}]
[null,"401(k)/等",{"v":12000,"d":"¥12,000.00"},{"$f":"存款[[#This Row],[每年  ]]/12","v":{"v":1000,"d":"¥1,000.00"}}]
[null,"存款/投资",{"v":6000,"d":"¥6,000.00"},{"$f":"存款[[#This Row],[每年  ]]/12","v":{"v":500,"d":"¥500.00"}}]
[null,"其他 1",null,{"$f":"存款[[#This Row],[每年  ]]/12","v":{"v":0,"d":"¥0.00"}}]
[null,"其他 2",null,{"$f":"存款[[#This Row],[每年  ]]/12","v":{"v":0,"d":"¥0.00"}}]
[null," 汇总",{"$f":"SUBTOTAL(109,存款[[每年  ]])","v":{"v":23000,"d":"¥23,000.00"}},{"$f":"SUBTOTAL(109,存款[[每月 ]])","v":{"v":1916.6666666666667,"d":"¥1,916.67"}}]