{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["开始","仪表板","支出和收入","预算报表","数据列表","类别数据透视表"],"not_rendered":{"charts":3,"defined_names":23,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"开始","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"关于模板"]
[null,"使用此模板可创建半月家庭预算。"]
[null,"“仪表板”工作表包含显示每月和每年总计的图表以及显示每两周收入和支出的表格。"]
[null,"在“数据列表”工作表中输入类别，在“收入和支出”工作表中输入值。"]
[null,"刷新“预算报表”工作表中的数据透视表。"]
[null,"注释："]
[null,"所有工作表的 A 列中均提供了额外的说明。此文本已被有意隐藏。若要删除文本，请选择 A 列，然后选择“删除”。 "]
[null,"若要了解有关表格的详细信息，请在表格内按 Shift + F10，选择“表格”选项，然后选择“替换文本”。对于数据透视表，请在表格内按 SHIFT+F10，选择“数据透视表”选项，然后选择“替换文本”选项卡。"]

{"sheet":"仪表板","index":1,"n_rows":12,"n_cols":15,"rows_kept":12,"merged":[[0,1,0,13],[1,2,1,7]]}
["在此工作表中为每月和每年总计以及每两周收入和支出创建一个仪表板。有关如何使用此工作表的有用说明位于此列的单元格中。此工作簿的标题位于右侧单元格中，工作表标题位于单元格 O1 中。","半月家庭预算",{"$nulls":12},"仪表板"]
["选择单元格 C2 中的滑块可更改右侧单元格中的月份，如需更改单元格 I2 中的年份，请选择单元格 J2 中的滑块。",{"$f":"CHOOSE(MonthNumber,\"一月\",\"二月\",\"三月\",\"四月\",\"五月\",\"六月\",\"七月\",\"八月\",\"九月\",\"十月\",\"十一月\",\"十二月\")","v":"十二月"},12,{"$nulls":5},{"$f":"YEAR(TODAY())","v":2022}]
["“月度总计”标签位于右侧单元格中，“年度总计”标签位于单元格 I3 中。","月度总计",{"$nulls":6},"年度总计"]
["比较月收入总计和每月支出总计的条形图位于单元格 C4 中，比较年收入总计与年支出总计的条形图位于单元格 J4 中。下一条说明位于单元格 A8 中。","收入",null,{"$f":"MonthlyExpendituresTotals","v":{"v":0,"d":"¥0"}},{"$nulls":4},"收入",null,null,{"$f":"AnnualExpendituresTotals","v":{"v":10742,"d":"¥10,742"}}]
[null,"支出",null,{"$f":"MonthlyIncomeTotals","v":{"v":0,"d":"¥0"}},{"$nulls":4},"支出",null,null,{"$f":"AnnualIncomeTotals","v":{"v":13200,"d":"¥13,200"}}]
[]
[]
["从右侧单元格开始的仪表板表将会自动更新。","类别","1月","2月","3月","4月","5月","6月","7月","8月","9月","10月","11月","12月","迷你图"]
[null,"收入 1-15",{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":1300,"d":"¥1,300.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":2600,"d":"¥2,600.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":2600,"d":"¥2,600.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtMiddle,收入[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}}]
[null,"收入 16（月末）",{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":3100,"d":"¥3,100.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":3100,"d":"¥3,100.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":500,"d":"¥500.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(收入[金额],收入[日期],\"<=\"&DtEnd,收入[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}}]
[null,"支出 1-15",{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":1150,"d":"¥1,150.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":5225,"d":"¥5,225.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":3242,"d":"¥3,242.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle+1,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}}]
[null,"支出 16（月末）",{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":75,"d":"¥75.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":200,"d":"¥200.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":900,"d":"¥900.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":500,"d":"¥500.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":0,"d":"¥0.00"}}]

{"sheet":"支出和收入","index":2,"n_rows":36,"n_cols":9,"rows_kept":36,"merged":[[0,1,0,6],[0,7,0,8]]}
["在此工作表中创建收入和支出列表。有关如何使用此工作表的有用说明位于此列的单元格中。工作簿的标题位于右侧单元格中，工作表标题位于单元格 H1 中。",{"$f":"Semi_Monthly_Home_Budget_Title","v":"半月家庭预算"},{"$nulls":5},"收入和支出"]
["“收入”标签位于右侧单元格中，“支出”标签位于单元格 F2 中。","收入",{"$nulls":3},"支出"]
["在“收入”表中从右侧单元格开始输入详细信息，在“支出”表中从单元格 F3 开始输入。","日期","说明","金额",null,"日期","类别","说明","金额"]
[null,{"$f":"TODAY()","v":"2022-05-16"},"奖金",{"v":500,"d":"¥500.00"},null,{"$f":"TODAY()","v":"2022-05-16"},"医疗","保险",{"v":500,"d":"¥500.00"}]
[null,{"$f":"TODAY()-14","v":"2022-05-02"},"David 的工资",{"v":1300,"d":"¥1,300.00"},null,{"$f":"TODAY()-7","v":"2022-05-09"},"家庭","抵押贷款",{"v":1000,"d":"¥1,000.00"}]
[null,{"$f":"TODAY()-14","v":"2022-05-02"},"Pat 的工资",{"v":1300,"d":"¥1,300.00"},null,"2022-05-09","家庭","电费",{"v":100,"d":"¥100.00"}]
[null,{"$f":"TODAY()-28","v":"2022-04-18"},"David 的工资",{"v":1500,"d":"¥1,500.00"},null,"2022-05-09","家庭","水费/排污费",{"v":50,"d":"¥50.00"}]
[null,{"$f":"TODAY()-28","v":"2022-04-18"},"Pat 的工资",{"v":1600,"d":"¥1,600.00"},null,"2022-05-09","家庭","垃圾费",{"v":25,"d":"¥25.00"}]
[null,{"$f":"TODAY()-42","v":"2022-04-04"},"David 的工资",{"v":1300,"d":"¥1,300.00"},null,"2022-05-09","家庭","移动电话",{"v":100,"d":"¥100.00"}]
[null,{"$f":"TODAY()-42","v":"2022-04-04"},"Pat 的工资",{"v":1300,"d":"¥1,300.00"},null,"2022-05-09","家庭","移动电话",{"v":30,"d":"¥30.00"}]
[null,{"$f":"TODAY()-56","v":"2022-03-21"},"David 的工资",{"v":1500,"d":"¥1,500.00"},null,"2022-05-09","家庭","抵押贷款",{"v":50,"d":"¥50.00"}]
[null,{"$f":"TODAY()-56","v":"2022-03-21"},"Pat 的工资",{"v":1600,"d":"¥1,600.00"},null,"2022-05-09","家庭","移动电话",{"v":50,"d":"¥50.00"}]
[null,{"$f":"TODAY()-70","v":"2022-03-07"},"David 的工资",{"v":1300,"d":"¥1,300.00"},null,{"$f":"TODAY()-7","v":"2022-05-09"},"家庭","移动电话",{"v":25,"d":"¥25.00"}]
[{"$nulls":5},{"$f":"TODAY()-8","v":"2022-05-08"},"家庭","电费",{"v":100,"d":"¥100.00"}]
[{"$nulls":5},{"$f":"TODAY()-9","v":"2022-05-07"},"娱乐","电影",{"v":37,"d":"¥37.00"}]
[{"$nulls":5},{"$f":"TODAY()-10","v":"2022-05-06"},"食品","日用杂货",{"v":350,"d":"¥350.00"}]
[{"$nulls":5},{"$f":"TODAY()-11","v":"2022-05-05"},"食品","外出就餐",{"v":75,"d":"¥75.00"}]
[{"$nulls":5},{"$f":"TODAY()-12","v":"2022-05-04"},"育儿","餐费",{"v":150,"d":"¥150.00"}]
[{"$nulls":5},{"$f":"TODAY()-13","v":"2022-05-03"},"投资帐户","存款",{"v":250,"d":"¥250.00"}]
[{"$nulls":5},{"$f":"TODAY()-14","v":"2022-05-02"},"投资帐户","投资帐户",{"v":250,"d":"¥250.00"}]
[{"$nulls":5},{"$f":"TODAY()-15","v":"2022-05-01"},"个人","健康/健身俱乐部",{"v":100,"d":"¥100.00"}]
[{"$nulls":5},{"$f":"TODAY()-16","v":"2022-04-30"},"宠物","食品",{"v":50,"d":"¥50.00"}]
[{"$nulls":5},{"$f":"TODAY()-20","v":"2022-04-26"},"宠物","美容",{"v":50,"d":"¥50.00"}]
[{"$nulls":5},{"$f":"TODAY()-20","v":"2022-04-26"},"宠物","其他",{"v":50,"d":"¥50.00"}]
[{"$nulls":5},{"$f":"TODAY()-25","v":"2022-04-21"},"交通","汽车 1 付款 ",{"v":300,"d":"¥300.00"}]
[{"$nulls":5},{"$f":"TODAY()-25","v":"2022-04-21"},"交通","汽车 2 付款 ",{"v":350,"d":"¥350.00"}]
[{"$nulls":5},{"$f":"TODAY()-25","v":"2022-04-21"},"交通","车险",{"v":50,"d":"¥50.00"}]
[{"$nulls":5},{"$f":"TODAY()-30","v":"2022-04-16"},"交通","燃油",{"v":50,"d":"¥50.00"}]
[{"$nulls":5},{"$f":"TODAY()-31","v":"2022-04-15"},"交通","燃油",{"v":25,"d":"¥25.00"}]
[{"$nulls":5},{"$f":"TODAY()-42","v":"2022-04-04"},"交通","汽车 2 付款 ",{"v":150,"d":"¥150.00"}]
[{"$nulls":5},{"$f":"TODAY()-45","v":"2022-04-01"},"家庭","抵押贷款",{"v":5000,"d":"¥5,000.00"}]
[{"$nulls":5},{"$f":"TODAY()-50","v":"2022-03-27"},"家庭","电费",{"v":200,"d":"¥200.00"}]
[{"$nulls":5},{"$f":"TODAY()-65","v":"2022-03-12"},"家庭","移动电话",{"v":100,"d":"¥100.00"}]
[{"$nulls":5},{"$f":"TODAY()-70","v":"2022-03-07"},"家庭","垃圾费",{"v":50,"d":"¥50.00"}]
[{"$nulls":5},{"$f":"TODAY()-75","v":"2022-03-02"},"家庭","抵押贷款",{"v":1000,"d":"¥1,000.00"}]
[{"$nulls":5},{"$f":"TODAY()-78","v":"2022-02-27"},"娱乐","电影",{"v":75,"d":"¥75.00"}]

{"sheet":"预算报表","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[0,1,0,4],[1,1,1,3],[4,3,4,5]]}
["在此工作表中创建预算报表。有关如何使用此工作表的有用说明位于此列的单元格中。工作簿的标题位于右侧单元格中，工作表标题位于单元格 F1 中。",{"$f":"Semi_Monthly_Home_Budget_Title","v":"半月家庭预算"},{"$nulls":3},"预算报表"]
["选择“年”、“季度”、“月”或“日”，然后使用右侧单元格中的滑块获取选定期间的“支出”数据透视表。用于筛选数据透视表数据的“类别”切片器位于单元格 E2 中，“说明”切片器位于单元格 F2 中。","要筛选的日程表位于此单元格中。",null,null,"基于“类别”筛选数据透视表数据的切片器位于此单元格中。","基于“说明”筛选数据透视表数据的切片器位于此单元格中。"]
["提示位于右侧单元格中。","在“支出”数据透视表中按 Shift+F10，然后选择“刷新”以更新此工作表上的数据，或者在“分析”选项卡下选择“刷新”。"]
["“支出”标签位于右侧单元格中。","支出"]
["数据透视表从右侧单元格开始显示支出。“类别总计”标签位于单元格 D4 中。","行标签","金额总和","类别总计"]
["比较每个类别总计的饼图位于单元格 D6 中。","汽车 1 付款 ",{"v":300,"d":"¥300.00"}]
[null,"汽车 2 付款 ",{"v":500,"d":"¥500.00"}]
[null,"保险",{"v":500,"d":"¥500.00"}]
[null,"餐费",{"v":150,"d":"¥150.00"}]
[null,"车险",{"v":50,"d":"¥50.00"}]
[null,"存款",{"v":250,"d":"¥250.00"}]
[null,"抵押贷款",{"v":7050,"d":"¥7,050.00"}]
[null,"电费",{"v":400,"d":"¥400.00"}]
[null,"电影",{"v":112,"d":"¥112.00"}]
[null,"健康/健身俱乐部",{"v":100,"d":"¥100.00"}]
[null,"垃圾费",{"v":75,"d":"¥75.00"}]
[null,"美容",{"v":50,"d":"¥50.00"}]
[null,"其他",{"v":50,"d":"¥50.00"}]
[null,"燃油",{"v":75,"d":"¥75.00"}]
[null,"日用杂货",{"v":350,"d":"¥350.00"}]
[null,"食品",{"v":50,"d":"¥50.00"}]
[null,"水费/排污费",{"v":50,"d":"¥50.00"}]
[null,"投资帐户",{"v":250,"d":"¥250.00"}]
[null,"外出就餐",{"v":75,"d":"¥75.00"}]
[null,"移动电话",{"v":305,"d":"¥305.00"}]
[null,"总计",{"v":10742,"d":"¥10,742.00"}]

{"sheet":"数据列表","index":4,"n_rows":8,"n_cols":13,"rows_kept":8,"merged":[[0,1,0,11]]}
["在此工作表中输入类别数据，以填充“支出与收入”工作表上“支出”表格中的下拉列表。修改类别名称或每个类别下方的说明以更新列表。有关如何使用此工作表的有用说明位于此列的单元格中。工作簿的标题位于右侧单元格中，工作表标题位于单元格 M1 中。",{"$f":"Semi_Monthly_Home_Budget_Title","v":"半月家庭预算"},{"$nulls":10},"数据列表"]
["提示位于右侧单元格中。","设置         下面的类别数据用于填充“支出与收入”表上“支出”表格中下拉列表的类别。修改类别名称或每个类别下方的说明以更新列表。"]
["从右侧单元格开始，在表格的每个类别下方输入或修改类别名称或说明。","家庭","娱乐","食品","礼品/捐赠","育儿","投资帐户","医疗","其他","个人","宠物","税费/法务费","交通"]
[null,"抵押贷款","电影","日用杂货","慈善 1","服装","IRA","医生/医师","其他","服装","食品","国税","汽车 1 付款 "]
[null,"电费","视频/电影","外出就餐","慈善 2","玩具/游戏","存款","保险","组织会费","美发/美甲","日用品","省/市/自治区税","汽车 2 付款 "]
[null,"水费/排污费","音乐",null,"慈善 3","餐费","支票",null,null,"干洗","医疗","地税","车险"]
[null,"垃圾费","音乐会/戏剧",null,"礼品","会费/费用","养老金",null,null,"健康/健身俱乐部","美容","其他","许可/注册"]
[null,"移动电话","体育活动",null,null,"学校用品","投资帐户",null,null,"购物","其他","律师费","燃油"]

{"sheet":"类别数据透视表","index":5,"n_rows":13,"n_cols":13,"rows_kept":13,"hidden":true}
[null,"半月家庭预算",{"$nulls":10},"类别透视表"]
[null,"此数据透视表是预算报表上的类别总计数据透视图的数据源。 "]
[null,"行标签","金额总和"]
[null,"宠物",{"v":150,"d":"¥150"}]
[null,"个人",{"v":100,"d":"¥100"}]
[null,"家庭",{"v":7880,"d":"¥7,880"}]
[null,"交通",{"v":925,"d":"¥925"}]
[null,"投资帐户",{"v":500,"d":"¥500"}]
[null,"医疗",{"v":500,"d":"¥500"}]
[null,"娱乐",{"v":112,"d":"¥112"}]
[null,"育儿",{"v":150,"d":"¥150"}]
[null,"食品",{"v":425,"d":"¥425"}]
[null,"总计",{"v":10742,"d":"¥10,742"}]