{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["开始","个人预算"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"开始","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"关于模板"]
[null,"使用此模板来维持月度预算和年度预算。"]
[null,"在相应的表中输入收入和支出来计算每个月和每年的现金短缺或盈余。"]
[null,"迷你图会在每个表中自动更新。"]
[null,"注意： "]
[null,"“个人预算”工作表的 A 列中提供了附加说明。并且此文本已被有意隐藏。若要删除文本，请选择 A 列，然后选择“删除”。若要取消隐藏文本，请选择 A 列，然后更改字体颜色。"]
[null,"若要了解有关表格的详细信息，请在表格内按 Shift + F10，选择“表格”选项，然后选择“替换文本”。"]

{"sheet":"个人预算","index":1,"n_rows":107,"n_cols":17,"rows_kept":107,"merged":[[1,1,1,3],[1,4,1,15],[27,2,27,16],[36,2,36,16],[43,2,43,16],[53,2,53,16],[62,2,62,16],[69,2,69,16],[79,2,79,16],[87,2,87,16],[95,2,95,16],[103,2,103,16]]}
["在此工作表中创建简单的个人预算。有关如何使用此工作表的有用说明位于此列的单元格中。向下移动箭头以开始了解。"]
["此工作表的标题位于右侧单元格中。在单元格 Q2 中输入年份。下一条指示位于单元格 A4 中。","个人预算",{"$nulls":14},{"$f":"YEAR(TODAY())","v":2019}]
[]
["标签位于单元格 C4 至 P4 中。",null,"收入","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份"]
["从收益表的单元格 C5 开始输入详细信息。下一条指示位于单元格 A11 中。",null,"收益","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"工资",{"v":2600,"d":"¥2,600.00"},{"v":2600,"d":"¥2,600.00"},{"v":2600,"d":"¥2,600.00"},{"$nulls":9},{"$f":"SUM(收益[[#This Row],[1 月]:[12 月]])","v":{"v":7800,"d":"¥7,800.00"}}]
[null,null,"利息/股息",{"v":649,"d":"¥649.00"},{"v":313,"d":"¥313.00"},{"v":664,"d":"¥664.00"},{"$nulls":9},{"$f":"SUM(收益[[#This Row],[1 月]:[12 月]])","v":{"v":1626,"d":"¥1,626.00"}}]
[null,null,"杂项",{"v":474,"d":"¥474.00"},{"v":643,"d":"¥643.00"},{"v":380,"d":"¥380.00"},{"$nulls":9},{"$f":"SUM(收益[[#This Row],[1 月]:[12 月]])","v":{"v":1497,"d":"¥1,497.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,收益[1 月])","v":{"v":3723,"d":"¥3,723.00"}},{"$f":"SUBTOTAL(109,收益[2 月])","v":{"v":3556,"d":"¥3,556.00"}},{"$f":"SUBTOTAL(109,收益[3 月])","v":{"v":3644,"d":"¥3,644.00"}},{"$f":"SUBTOTAL(109,收益[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,收益[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,收益[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,收益[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,收益[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,收益[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,收益[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,收益[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,收益[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,收益[年份])","v":{"v":10923,"d":"¥10,923.00"}}]
[]
["标签位于单元格 C11 至 P11 中。",null,"支出","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份"]
["从表的单元格 C12 开始输入家庭支出。下一条指示位于单元格 A20 中。",null,"住宅","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"抵押贷款",{"v":750,"d":"¥750.00"},{"v":750,"d":"¥750.00"},{"v":750,"d":"¥750.00"},{"$nulls":9},{"$f":"SUM(家庭[[#This Row],[1 月]:[12 月]])","v":{"v":2250,"d":"¥2,250.00"}}]
[null,null,"保险",{"$nulls":12},{"$f":"SUM(家庭[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"维修",null,null,{"v":75,"d":"¥75.00"},{"$nulls":9},{"$f":"SUM(家庭[[#This Row],[1 月]:[12 月]])","v":{"v":75,"d":"¥75.00"}}]
[null,null,"服务",{"v":35,"d":"¥35.00"},{"v":35,"d":"¥35.00"},{"v":35,"d":"¥35.00"},{"$nulls":9},{"$f":"SUM(家庭[[#This Row],[1 月]:[12 月]])","v":{"v":105,"d":"¥105.00"}}]
[null,null,"水电费",{"v":165,"d":"¥165.00"},{"v":165,"d":"¥165.00"},{"v":165,"d":"¥165.00"},{"$nulls":9},{"$f":"SUM(家庭[[#This Row],[1 月]:[12 月]])","v":{"v":495,"d":"¥495.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,家庭[1 月])","v":{"v":950,"d":"¥950.00"}},{"$f":"SUBTOTAL(109,家庭[2 月])","v":{"v":950,"d":"¥950.00"}},{"$f":"SUBTOTAL(109,家庭[3 月])","v":{"v":1025,"d":"¥1,025.00"}},{"$f":"SUBTOTAL(109,家庭[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,家庭[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,家庭[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,家庭[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,家庭[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,家庭[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,家庭[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,家庭[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,家庭[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,家庭[年份])","v":{"v":2925,"d":"¥2,925.00"}}]
[]
["从表的单元格 C20 开始输入每日支出。下一条指示位于单元格 A29 中。",null,"日常生活","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"日用杂货 ",{"v":191,"d":"¥191.00"},{"v":152,"d":"¥152.00"},{"v":145,"d":"¥145.00"},{"$nulls":9},{"$f":"SUM(日常[[#This Row],[1 月]:[12 月]])","v":{"v":488,"d":"¥488.00"}}]
[null,null,"儿童保育",{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"v":200,"d":"¥200.00"},{"$nulls":9},{"$f":"SUM(日常[[#This Row],[1 月]:[12 月]])","v":{"v":600,"d":"¥600.00"}}]
[null,null,"干洗",{"v":20,"d":"¥20.00"},null,{"v":20,"d":"¥20.00"},{"$nulls":9},{"$f":"SUM(日常[[#This Row],[1 月]:[12 月]])","v":{"v":40,"d":"¥40.00"}}]
[null,null,"外出就餐",{"v":55,"d":"¥55.00"},null,{"v":56,"d":"¥56.00"},{"$nulls":9},{"$f":"SUM(日常[[#This Row],[1 月]:[12 月]])","v":{"v":111,"d":"¥111.00"}}]
[null,null,"房屋清扫服务",{"v":25,"d":"¥25.00"},{"v":17,"d":"¥17.00"},{"v":7,"d":"¥7.00"},{"$nulls":9},{"$f":"SUM(日常[[#This Row],[1 月]:[12 月]])","v":{"v":49,"d":"¥49.00"}}]
[null,null,"遛狗",{"v":10,"d":"¥10.00"},{"v":5,"d":"¥5.00"},{"v":7,"d":"¥7.00"},{"$nulls":9},{"$f":"SUM(日常[[#This Row],[1 月]:[12 月]])","v":{"v":22,"d":"¥22.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,日常[1 月])","v":{"v":501,"d":"¥501.00"}},{"$f":"SUBTOTAL(109,日常[2 月])","v":{"v":374,"d":"¥374.00"}},{"$f":"SUBTOTAL(109,日常[3 月])","v":{"v":435,"d":"¥435.00"}},{"$f":"SUBTOTAL(109,日常[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,日常[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,日常[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,日常[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,日常[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,日常[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,日常[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,日常[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,日常[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,日常[年份])","v":{"v":1310,"d":"¥1,310.00"}}]
[]
["从表的单元格 C29 开始输入交通支出。下一条说明位于单元格 A38 中。",null,"交通","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"燃气/燃油",{"v":195,"d":"¥195.00"},{"v":125,"d":"¥125.00"},{"v":171,"d":"¥171.00"},{"$nulls":9},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":491,"d":"¥491.00"}}]
[null,null,"保险",{"v":165,"d":"¥165.00"},{"v":165,"d":"¥165.00"},{"v":165,"d":"¥165.00"},{"$nulls":9},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":495,"d":"¥495.00"}}]
[null,null,"修理费",{"$nulls":12},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"洗车/汽车美容服务",{"v":10,"d":"¥10.00"},{"$nulls":11},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":10,"d":"¥10.00"}}]
[null,null,"停车费",{"v":10,"d":"¥10.00"},{"v":40,"d":"¥40.00"},{"v":20,"d":"¥20.00"},{"$nulls":9},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":70,"d":"¥70.00"}}]
[null,null,"公共交通费",{"v":20,"d":"¥20.00"},{"v":40,"d":"¥40.00"},{"v":30,"d":"¥30.00"},{"$nulls":9},{"$f":"SUM(交通[[#This Row],[1 月]:[12 月]])","v":{"v":90,"d":"¥90.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,交通[1 月])","v":{"v":400,"d":"¥400.00"}},{"$f":"SUBTOTAL(109,交通[2 月])","v":{"v":370,"d":"¥370.00"}},{"$f":"SUBTOTAL(109,交通[3 月])","v":{"v":386,"d":"¥386.00"}},{"$f":"SUBTOTAL(109,交通[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,交通[年份])","v":{"v":1156,"d":"¥1,156.00"}}]
[]
["从表的单元格 C38 开始输入娱乐支出。下一条指示位于单元格 A45 中。",null,"娱乐","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"有线电视",{"v":85,"d":"¥85.00"},{"v":85,"d":"¥85.00"},{"v":85,"d":"¥85.00"},{"$nulls":9},{"$f":"SUM(娱乐[[#This Row],[1 月]:[12 月]])","v":{"v":255,"d":"¥255.00"}}]
[null,null,"录像/DVD 租赁",{"v":7,"d":"¥7.00"},{"v":8,"d":"¥8.00"},{"v":9,"d":"¥9.00"},{"$nulls":9},{"$f":"SUM(娱乐[[#This Row],[1 月]:[12 月]])","v":{"v":24,"d":"¥24.00"}}]
[null,null,"电影/戏剧",{"v":9,"d":"¥9.00"},{"v":5,"d":"¥5.00"},{"v":9,"d":"¥9.00"},{"$nulls":9},{"$f":"SUM(娱乐[[#This Row],[1 月]:[12 月]])","v":{"v":23,"d":"¥23.00"}}]
[null,null,"音乐会/俱乐部",{"v":5,"d":"¥5.00"},{"v":5,"d":"¥5.00"},{"v":7,"d":"¥7.00"},{"$nulls":9},{"$f":"SUM(娱乐[[#This Row],[1 月]:[12 月]])","v":{"v":17,"d":"¥17.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,娱乐[1 月])","v":{"v":106,"d":"¥106.00"}},{"$f":"SUBTOTAL(109,娱乐[2 月])","v":{"v":103,"d":"¥103.00"}},{"$f":"SUBTOTAL(109,娱乐[3 月])","v":{"v":110,"d":"¥110.00"}},{"$f":"SUBTOTAL(109,娱乐[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娱乐[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娱乐[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娱乐[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娱乐[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娱乐[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娱乐[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娱乐[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娱乐[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,娱乐[年份])","v":{"v":319,"d":"¥319.00"}}]
[]
["从表的单元格 C45 开始输入保健支出。下一条指示位于单元格 A55 中。",null,"保健","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"健身俱乐部会费",{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"},{"$nulls":9},{"$f":"SUM(保健[[#This Row],[1 月]:[12 月]])","v":{"v":150,"d":"¥150.00"}}]
[null,null,"保险",{"v":225,"d":"¥225.00"},{"v":225,"d":"¥225.00"},{"v":225,"d":"¥225.00"},{"$nulls":9},{"$f":"SUM(保健[[#This Row],[1 月]:[12 月]])","v":{"v":675,"d":"¥675.00"}}]
[null,null,"处方药费用",{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"},{"$nulls":9},{"$f":"SUM(保健[[#This Row],[1 月]:[12 月]])","v":{"v":300,"d":"¥300.00"}}]
[null,null,"非处方药费用",{"v":6,"d":"¥6.00"},{"v":2,"d":"¥2.00"},{"v":9,"d":"¥9.00"},{"$nulls":9},{"$f":"SUM(保健[[#This Row],[1 月]:[12 月]])","v":{"v":17,"d":"¥17.00"}}]
[null,null,"共同支付/现款支付",{"v":20,"d":"¥20.00"},null,{"v":41,"d":"¥41.00"},{"$nulls":9},{"$f":"SUM(保健[[#This Row],[1 月]:[12 月]])","v":{"v":61,"d":"¥61.00"}}]
[null,null,"兽医/宠物药品",{"v":4,"d":"¥4.00"},null,{"v":25,"d":"¥25.00"},{"$nulls":9},{"$f":"SUM(保健[[#This Row],[1 月]:[12 月]])","v":{"v":29,"d":"¥29.00"}}]
[null,null,"人寿保险",{"v":55,"d":"¥55.00"},{"v":55,"d":"¥55.00"},{"v":55,"d":"¥55.00"},{"$nulls":9},{"$f":"SUM(保健[[#This Row],[1 月]:[12 月]])","v":{"v":165,"d":"¥165.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,保健[1 月])","v":{"v":460,"d":"¥460.00"}},{"$f":"SUBTOTAL(109,保健[2 月])","v":{"v":432,"d":"¥432.00"}},{"$f":"SUBTOTAL(109,保健[3 月])","v":{"v":505,"d":"¥505.00"}},{"$f":"SUBTOTAL(109,保健[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,保健[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,保健[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,保健[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,保健[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,保健[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,保健[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,保健[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,保健[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,保健[年份])","v":{"v":1397,"d":"¥1,397.00"}}]
[]
["从表的单元格 C55 开始输入度假支出。下一条指示位于单元格 A64。",null,"度假","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"飞机票",null,{"v":485,"d":"¥485.00"},{"$nulls":10},{"$f":"SUM(度假[[#This Row],[1 月]:[12 月]])","v":{"v":485,"d":"¥485.00"}}]
[null,null,"住宿",null,{"v":245,"d":"¥245.00"},{"$nulls":10},{"$f":"SUM(度假[[#This Row],[1 月]:[12 月]])","v":{"v":245,"d":"¥245.00"}}]
[null,null,"食品",null,{"v":95,"d":"¥95.00"},{"$nulls":10},{"$f":"SUM(度假[[#This Row],[1 月]:[12 月]])","v":{"v":95,"d":"¥95.00"}}]
[null,null,"纪念品",{"$nulls":12},{"$f":"SUM(度假[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"宠物寄养",{"$nulls":12},{"$f":"SUM(度假[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"汽车租赁",null,{"v":85,"d":"¥85.00"},{"$nulls":10},{"$f":"SUM(度假[[#This Row],[1 月]:[12 月]])","v":{"v":85,"d":"¥85.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,度假[1 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,度假[2 月])","v":{"v":910,"d":"¥910.00"}},{"$f":"SUBTOTAL(109,度假[3 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,度假[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,度假[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,度假[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,度假[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,度假[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,度假[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,度假[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,度假[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,度假[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,度假[年份])","v":{"v":910,"d":"¥910.00"}}]
[]
["从表的单元格 C64 开始输入休闲支出。下一条指示位于单元格 A71 中。",null,"休闲","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"体育馆费用",{"$nulls":12},{"$f":"SUM(休闲[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"运动设备",{"$nulls":12},{"$f":"SUM(休闲[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"团体会费",{"$nulls":12},{"$f":"SUM(休闲[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"玩具/儿童用品",{"v":39,"d":"¥39.00"},{"v":33,"d":"¥33.00"},{"v":40,"d":"¥40.00"},{"$nulls":9},{"$f":"SUM(休闲[[#This Row],[1 月]:[12 月]])","v":{"v":112,"d":"¥112.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,休闲[1 月])","v":{"v":39,"d":"¥39.00"}},{"$f":"SUBTOTAL(109,休闲[2 月])","v":{"v":33,"d":"¥33.00"}},{"$f":"SUBTOTAL(109,休闲[3 月])","v":{"v":40,"d":"¥40.00"}},{"$f":"SUBTOTAL(109,休闲[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休闲[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休闲[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休闲[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休闲[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休闲[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休闲[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休闲[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休闲[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,休闲[年份])","v":{"v":112,"d":"¥112.00"}}]
[]
["从会费和订阅表的单元格 C71 开始输入支出。下一条指示位于单元格 A81 中。",null,"会费/订阅","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"杂志",{"$nulls":12},{"$f":"SUM(会费和订阅[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"报纸",{"$nulls":12},{"$f":"SUM(会费和订阅[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"Internet 费用",{"$nulls":12},{"$f":"SUM(会费和订阅[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"公共广播",{"$nulls":12},{"$f":"SUM(会费和订阅[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"公共电视",{"$nulls":12},{"$f":"SUM(会费和订阅[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"宗教组织",{"v":29,"d":"¥29.00"},{"v":18,"d":"¥18.00"},{"v":17,"d":"¥17.00"},{"$nulls":9},{"$f":"SUM(会费和订阅[[#This Row],[1 月]:[12 月]])","v":{"v":64,"d":"¥64.00"}}]
[null,null,"慈善",{"$nulls":12},{"$f":"SUM(会费和订阅[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,会费和订阅[1 月])","v":{"v":29,"d":"¥29.00"}},{"$f":"SUBTOTAL(109,会费和订阅[2 月])","v":{"v":18,"d":"¥18.00"}},{"$f":"SUBTOTAL(109,会费和订阅[3 月])","v":{"v":17,"d":"¥17.00"}},{"$f":"SUBTOTAL(109,会费和订阅[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会费和订阅[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会费和订阅[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会费和订阅[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会费和订阅[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会费和订阅[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会费和订阅[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会费和订阅[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会费和订阅[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,会费和订阅[年份])","v":{"v":64,"d":"¥64.00"}}]
[]
["从表的单元格 C81 开始输入个人支出。下一条指示位于单元格 A89 中。",null,"个人","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"服装",null,null,{"v":29,"d":"¥29.00"},{"$nulls":9},{"$f":"SUM(个人[[#This Row],[1 月]:[12 月]])","v":{"v":29,"d":"¥29.00"}}]
[null,null,"礼品",null,{"v":35,"d":"¥35.00"},{"$nulls":10},{"$f":"SUM(个人[[#This Row],[1 月]:[12 月]])","v":{"v":35,"d":"¥35.00"}}]
[null,null,"沙龙/理发",{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"$nulls":9},{"$f":"SUM(个人[[#This Row],[1 月]:[12 月]])","v":{"v":75,"d":"¥75.00"}}]
[null,null,"书籍",{"$nulls":12},{"$f":"SUM(个人[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"音乐（CD 等）",{"$nulls":12},{"$f":"SUM(个人[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,个人[1 月])","v":{"v":25,"d":"¥25.00"}},{"$f":"SUBTOTAL(109,个人[2 月])","v":{"v":60,"d":"¥60.00"}},{"$f":"SUBTOTAL(109,个人[3 月])","v":{"v":54,"d":"¥54.00"}},{"$f":"SUBTOTAL(109,个人[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,个人[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,个人[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,个人[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,个人[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,个人[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,个人[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,个人[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,个人[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,个人[年份])","v":{"v":139,"d":"¥139.00"}}]
[]
["从表的单元格 C89 开始输入债务。下一条指示位于单元格 A97 中。",null,"债务","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"长期存款",{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"v":25,"d":"¥25.00"},{"$nulls":9},{"$f":"SUM(财务[[#This Row],[1 月]:[12 月]])","v":{"v":75,"d":"¥75.00"}}]
[null,null,"退休金（401k 帐户，罗斯个人退休帐户）",{"v":45,"d":"¥45.00"},{"v":45,"d":"¥45.00"},{"v":45,"d":"¥45.00"},{"$nulls":9},{"$f":"SUM(财务[[#This Row],[1 月]:[12 月]])","v":{"v":135,"d":"¥135.00"}}]
[null,null,"信用卡付款",{"v":75,"d":"¥75.00"},{"v":75,"d":"¥75.00"},{"v":75,"d":"¥75.00"},{"$nulls":9},{"$f":"SUM(财务[[#This Row],[1 月]:[12 月]])","v":{"v":225,"d":"¥225.00"}}]
[null,null,"所得税（附加）",{"$nulls":12},{"$f":"SUM(财务[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"其他债务",{"v":32,"d":"¥32.00"},{"v":34,"d":"¥34.00"},{"v":1,"d":"¥1.00"},{"$nulls":9},{"$f":"SUM(财务[[#This Row],[1 月]:[12 月]])","v":{"v":67,"d":"¥67.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,财务[1 月])","v":{"v":177,"d":"¥177.00"}},{"$f":"SUBTOTAL(109,财务[2 月])","v":{"v":179,"d":"¥179.00"}},{"$f":"SUBTOTAL(109,财务[3 月])","v":{"v":146,"d":"¥146.00"}},{"$f":"SUBTOTAL(109,财务[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,财务[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,财务[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,财务[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,财务[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,财务[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,财务[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,财务[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,财务[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,财务[年份])","v":{"v":502,"d":"¥502.00"}}]
[]
["从表的单元格 C97 开始输入杂项支出。下一条指示位于单元格 A105 中。",null,"杂项支出","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"其他",{"$nulls":12},{"$f":"SUM(杂项[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"其他",{"$nulls":12},{"$f":"SUM(杂项[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"其他",{"$nulls":12},{"$f":"SUM(杂项[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"其他",{"$nulls":12},{"$f":"SUM(杂项[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"其他",{"$nulls":12},{"$f":"SUM(杂项[[#This Row],[1 月]:[12 月]])","v":{"v":0,"d":"¥0.00"}}]
[null,null,"汇总",{"$f":"SUBTOTAL(109,杂项[1 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[2 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[3 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[4 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[5 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[6 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[7 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[8 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[9 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[10 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[11 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[12 月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,杂项[年份])","v":{"v":0,"d":"¥0.00"}}]
[]
["从表的单元格 C105 开始自动计算总计。将自动计算每个月和全年的总支出以及现金短缺或盈余，并且迷你图会更新。",null,"总计","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年份","迷你图"]
[null,null,"总支出",{"$f":"SUM(杂项[[#Totals],[1 月]],财务[[#Totals],[1 月]],个人[[#Totals],[1 月]],会费和订阅[[#Totals],[1 月]],休闲[[#Totals],[1 月]],度假[[#Totals],[1 月]],保健[[#Totals],[1 月]],娱乐[[#Totals],[1 月]],交通[[#Totals],[1 月]],日常[[#Totals],[1 月]],家庭[[#Totals],[1 月]])","v":{"v":2687,"d":"¥2,687.00"}},{"$f":"SUM(杂项[[#Totals],[2 月]],财务[[#Totals],[2 月]],个人[[#Totals],[2 月]],会费和订阅[[#Totals],[2 月]],休闲[[#Totals],[2 月]],度假[[#Totals],[2 月]],保健[[#Totals],[2 月]],娱乐[[#Totals],[2 月]],交通[[#Totals],[2 月]],日常[[#Totals],[2 月]],家庭[[#Totals],[2 月]])","v":{"v":3429,"d":"¥3,429.00"}},{"$f":"SUM(杂项[[#Totals],[3 月]],财务[[#Totals],[3 月]],个人[[#Totals],[3 月]],会费和订阅[[#Totals],[3 月]],休闲[[#Totals],[3 月]],度假[[#Totals],[3 月]],保健[[#Totals],[3 月]],娱乐[[#Totals],[3 月]],交通[[#Totals],[3 月]],日常[[#Totals],[3 月]],家庭[[#Totals],[3 月]])","v":{"v":2718,"d":"¥2,718.00"}},{"$f":"SUM(杂项[[#Totals],[4 月]],财务[[#Totals],[4 月]],个人[[#Totals],[4 月]],会费和订阅[[#Totals],[4 月]],休闲[[#Totals],[4 月]],度假[[#Totals],[4 月]],保健[[#Totals],[4 月]],娱乐[[#Totals],[4 月]],交通[[#Totals],[4 月]],日常[[#Totals],[4 月]],家庭[[#Totals],[4 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[5 月]],财务[[#Totals],[5 月]],个人[[#Totals],[5 月]],会费和订阅[[#Totals],[5 月]],休闲[[#Totals],[5 月]],度假[[#Totals],[5 月]],保健[[#Totals],[5 月]],娱乐[[#Totals],[5 月]],交通[[#Totals],[5 月]],日常[[#Totals],[5 月]],家庭[[#Totals],[5 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[6 月]],财务[[#Totals],[6 月]],个人[[#Totals],[6 月]],会费和订阅[[#Totals],[6 月]],休闲[[#Totals],[6 月]],度假[[#Totals],[6 月]],保健[[#Totals],[6 月]],娱乐[[#Totals],[6 月]],交通[[#Totals],[6 月]],日常[[#Totals],[6 月]],家庭[[#Totals],[6 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[7 月]],财务[[#Totals],[7 月]],个人[[#Totals],[7 月]],会费和订阅[[#Totals],[7 月]],休闲[[#Totals],[7 月]],度假[[#Totals],[7 月]],保健[[#Totals],[7 月]],娱乐[[#Totals],[7 月]],交通[[#Totals],[7 月]],日常[[#Totals],[7 月]],家庭[[#Totals],[7 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[8 月]],财务[[#Totals],[8 月]],个人[[#Totals],[8 月]],会费和订阅[[#Totals],[8 月]],休闲[[#Totals],[8 月]],度假[[#Totals],[8 月]],保健[[#Totals],[8 月]],娱乐[[#Totals],[8 月]],交通[[#Totals],[8 月]],日常[[#Totals],[8 月]],家庭[[#Totals],[8 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[9 月]],财务[[#Totals],[9 月]],个人[[#Totals],[9 月]],会费和订阅[[#Totals],[9 月]],休闲[[#Totals],[9 月]],度假[[#Totals],[9 月]],保健[[#Totals],[9 月]],娱乐[[#Totals],[9 月]],交通[[#Totals],[9 月]],日常[[#Totals],[9 月]],家庭[[#Totals],[9 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[10 月]],财务[[#Totals],[10 月]],个人[[#Totals],[10 月]],会费和订阅[[#Totals],[10 月]],休闲[[#Totals],[10 月]],度假[[#Totals],[10 月]],保健[[#Totals],[10 月]],娱乐[[#Totals],[10 月]],交通[[#Totals],[10 月]],日常[[#Totals],[10 月]],家庭[[#Totals],[10 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[11 月]],财务[[#Totals],[11 月]],个人[[#Totals],[11 月]],会费和订阅[[#Totals],[11 月]],休闲[[#Totals],[11 月]],度假[[#Totals],[11 月]],保健[[#Totals],[11 月]],娱乐[[#Totals],[11 月]],交通[[#Totals],[11 月]],日常[[#Totals],[11 月]],家庭[[#Totals],[11 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[12 月]],财务[[#Totals],[12 月]],个人[[#Totals],[12 月]],会费和订阅[[#Totals],[12 月]],休闲[[#Totals],[12 月]],度假[[#Totals],[12 月]],保健[[#Totals],[12 月]],娱乐[[#Totals],[12 月]],交通[[#Totals],[12 月]],日常[[#Totals],[12 月]],家庭[[#Totals],[12 月]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUM(杂项[[#Totals],[年份]],财务[[#Totals],[年份]],个人[[#Totals],[年份]],会费和订阅[[#Totals],[年份]],休闲[[#Totals],[年份]],度假[[#Totals],[年份]],保健[[#Totals],[年份]],娱乐[[#Totals],[年份]],交通[[#Totals],[年份]],日常[[#Totals],[年份]],家庭[[#Totals],[年份]])","v":{"v":8834,"d":"¥8,834.00"}}]
[null,null,"现金短缺/盈余",{"$f":"收益[[#Totals],[1 月]]-D106","v":{"v":1036,"d":"¥1,036.00"}},{"$f":"收益[[#Totals],[2 月]]-E106","v":{"v":127,"d":"¥127.00"}},{"$f":"收益[[#Totals],[3 月]]-F106","v":{"v":926,"d":"¥926.00"}},{"$f":"收益[[#Totals],[4 月]]-G106","v":{"v":0,"d":"¥0.00"}},{"$f":"收益[[#Totals],[5 月]]-H106","v":{"v":0,"d":"¥0.00"}},{"$f":"收益[[#Totals],[6 月]]-I106","v":{"v":0,"d":"¥0.00"}},{"$f":"收益[[#Totals],[7 月]]-J106","v":{"v":0,"d":"¥0.00"}},{"$f":"收益[[#Totals],[8 月]]-K106","v":{"v":0,"d":"¥0.00"}},{"$f":"收益[[#Totals],[9 月]]-L106","v":{"v":0,"d":"¥0.00"}},{"$f":"收益[[#Totals],[10 月]]-M106","v":{"v":0,"d":"¥0.00"}},{"$f":"收益[[#Totals],[11 月]]-N106","v":{"v":0,"d":"¥0.00"}},{"$f":"收益[[#Totals],[12 月]]-O106","v":{"v":0,"d":"¥0.00"}},{"$f":"收益[[#Totals],[年份]]-P106","v":{"v":2089,"d":"¥2,089.00"}}]