{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["开始","预算圆环","数据"],"not_rendered":{"charts":1,"defined_names":5},"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":23,"n_cols":7,"rows_kept":23,"merged":[[0,1,0,2],[0,3,0,6]]}
[null,"预算圆环",null,"使用此模板填写表格。此图将根据每月收入绘制每月支出图表。它还将计算百分比以显示你将节省/已节省多少钱。"]
[null,"每月\n收入",{"$nulls":4},"存款\n金额"]
[null,{"v":5738,"d":"¥5,738"},{"$nulls":4},{"$f":"存款","v":{"v":2777,"d":"¥2,777"}}]
[{"$nulls":6},"计算值\n自动"]
[]
[null,"费用","类别","金额","频率","每月金额","占总数的百分比"]
[null,"保险","交通",{"v":300,"d":"¥300"},"每 6 个月",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":50,"d":"¥50"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.00871383757406762,"d":"¥0"}}]
[null,"燃气","交通",{"v":25,"d":"¥25"},"每周",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"¥100"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.01742767514813524,"d":"¥0"}}]
[null,"车贷","交通",{"v":200,"d":"¥200"},"每月",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":200,"d":"¥200"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.03485535029627048,"d":"¥0"}}]
[null,"抵押贷款","住房",{"v":1600,"d":"¥1,600"},"每月",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":1600,"d":"¥1,600"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.27884280237016384,"d":"¥0"}}]
[null,"有线电视费","住房",{"v":60,"d":"¥60"},"每月",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"¥60"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.010456605088881143,"d":"¥0"}}]
[null,"电影之夜","娱乐",{"v":70,"d":"¥70"},"每月",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"¥70"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.012199372603694667,"d":"¥0"}}]
[null,"运动鞋","杂项费",{"v":300,"d":"¥300"},"年度",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":25,"d":"¥25"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.00435691878703381,"d":"¥0"}}]
[null,"狗粮","杂项费",{"v":60,"d":"¥60"},"每月",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"¥60"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.010456605088881143,"d":"¥0"}}]
[null,"宠物保险","杂项费",{"v":70,"d":"¥70"},"年度",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":6,"d":"¥6"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":1.0456605088881143E-3,"d":"¥0"}}]
[null,"日用杂货","食品",{"v":100,"d":"¥100"},"每周",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":400,"d":"¥400"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.06971070059254096,"d":"¥0"}}]
[null,"咖啡","食品",{"v":25,"d":"¥25"},"每周",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"¥100"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.01742767514813524,"d":"¥0"}}]
[null,"登山装备","娱乐",{"v":170,"d":"¥170"},"年度",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":14,"d":"¥14"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":2.4398745207389336E-3,"d":"¥0"}}]
[null,"健身俱乐部会员费","杂项费",{"v":60,"d":"¥60"},"每月",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"¥60"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.010456605088881143,"d":"¥0"}}]
[null,"耳机","娱乐",{"v":50,"d":"¥50"},"年度",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":4,"d":"¥4"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":6.9710700592540956E-4,"d":"¥0"}}]
[null,"理发","杂项费",{"v":70,"d":"¥70"},"每月",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"¥70"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.012199372603694667,"d":"¥0"}}]
[null,"视频游戏","娱乐",{"v":100,"d":"¥100"},"每月",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"¥100"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":0.01742767514813524,"d":"¥0"}}]
[null,"衣服","杂项费",{"v":500,"d":"¥500"},"年度",{"$f":"IF(费用[[#This Row],[金额]]>0,IF(费用[[#This Row],[频率]]<>\"\",ROUND(IF(费用[[#This Row],[频率]]=\"每月\",费用[金额],IF(费用[[#This Row],[频率]]=\"每周\",费用[[#This Row],[金额]]*4,IF(费用[[#This Row],[频率]]=\"每季度\",费用[[#This Row],[金额]]/3,IF(费用[[#This Row],[频率]]=\"每 6 个月\",费用[[#This Row],[金额]]/6,IF(费用[[#This Row],[频率]]=\"年度\",费用[[#This Row],[金额]]/12,IF(费用[[#This Row],[频率]]=\"每隔一周\",费用[[#This Row],[金额]]*2,IF(费用[[#This Row],[频率]]=\"每隔一个月\",费用[[#This Row],[金额]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":42,"d":"¥42"}},{"$f":"IF(费用[[#This Row],[每月金额]]<>\"\",费用[[#This Row],[每月金额]]/收入,\"\")","v":{"v":7.3196235622168E-3,"d":"¥0"}}]

{"sheet":"数据","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"hidden":true}
["此工作表应继续保持隐藏状态"]
["类别","各类别金额","总计百分比","频率","存款"]
["住房",{"$f":"IF(SUMIF(费用[类别],\"住房\",费用[每月金额])>0,SUMIF(费用[类别],\"住房\",费用[每月金额]),NA())","v":{"v":1660,"d":"¥1,660"}},{"$f":"IF(B3>0,B3/收入,\"\")","v":{"v":0.289299407459045,"d":"¥0"}},"每周",{"$f":"收入-SUM(费用[每月金额])","v":{"v":2777,"d":"¥2,777"}}]
["娱乐",{"$f":"IF(SUMIF(费用[类别],\"娱乐\",费用[每月金额])>0,SUMIF(费用[类别],\"娱乐\",费用[每月金额]),NA())","v":{"v":188,"d":"¥188"}},{"v":0.03276402927849425,"d":"¥0"},"每月"]
["交通",{"$f":"IF(SUMIF(费用[类别],\"交通\",费用[每月金额])>0,SUMIF(费用[类别],\"交通\",费用[每月金额]),NA())","v":{"v":350,"d":"¥350"}},{"v":0.06099686301847333,"d":"¥0"},"每季度"]
["食品",{"$f":"IF(SUMIF(费用[类别],\"食品\",费用[每月金额])>0,SUMIF(费用[类别],\"食品\",费用[每月金额]),NA())","v":{"v":500,"d":"¥500"}},{"v":0.08713837574067619,"d":"¥0"},"每 6 个月"]
["杂项费",{"$f":"IF(SUMIF(费用[类别],\"杂项费\",费用[每月金额])>0,SUMIF(费用[类别],\"杂项费\",费用[每月金额]),NA())","v":{"v":263,"d":"¥263"}},{"v":0.04583478563959568,"d":"¥0"},"年度"]
["存款",{"$f":"IF(E3>0,E3,NA())","v":{"v":2777,"d":"¥2,777"}},{"v":0.4839665388637156,"d":"¥0"},"每隔一周"]
[{"$nulls":3},"每隔一个月"]
[null,"汇总：",{"$f":"SUM(C3:C8)","v":{"v":1,"d":"¥1"}}]