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

{"sheet":"仪表板","index":0,"n_rows":21,"n_cols":16,"rows_kept":21,"merged":[[5,2,5,3],[8,9,8,10],[9,9,9,10],[10,9,10,10]]}
[]
[null,null,"半月家庭预算",{"$nulls":12},"仪表板"]
[]
[]
[]
[null,null,{"$f":"CHOOSE(MonthNumber,\"一月\",\"二月\",\"三月\",\"四月\",\"五月\",\"六月\",\"七月\",\"八月\",\"九月\",\"十月\",\"十一月\",\"十二月\")","v":"八月"},null,8,{"$nulls":5},2012]
[]
[]
[null,null,"月度总计","月度总计",{"$nulls":5},"年度总计",null,"年度总计"]
[null,null,"收入","支出",{"$f":"SUMIF(支出[日期],\"<=\"&下旬,支出[金额])-SUMIF(支出[日期],\"<\"&上旬,支出[金额])","v":{"v":0,"d":"$0"}},{"$nulls":4},"收入",null,"支出",{"$f":"SUM(IF(YEAR(支出[日期])=K6,支出[金额]))","v":{"v":102420,"d":"$102,420"}}]
[null,null,"支出","收入",{"$f":"SUMIF(收入[日期],\"<=\"&下旬,收入[金额])-SUMIF(收入[日期],\"<\"&上旬,收入[金额])","v":{"v":0,"d":"$0"}},{"$nulls":4},"支出",null,"收入",{"$f":"SUM(IF(YEAR(收入[日期])=K6,收入[金额]))","v":{"v":127000,"d":"$127,000"}}]
[]
[]
[]
[]
[]
[{"$nulls":3},"一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月"]
[null,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":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"}},{"$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,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":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"}},{"$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,null,"支出 1-15",{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtMiddle,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtStart)","v":{"v":10750,"d":"¥10,750.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtStart)","v":{"v":55000,"d":"¥55,000.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtStart)","v":{"v":16750,"d":"¥16,750.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtStart)","v":{"v":19170,"d":"¥19,170.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtStart)","v":{"v":0,"d":"¥0.00"}}]
[null,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":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":10750,"d":"¥10,750.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":53500,"d":"¥53,500.00"}},{"$f":"SUMIFS(支出[金额],支出[日期],\"<=\"&DtEnd,支出[日期],\">=\"&DtMiddle+1)","v":{"v":16000,"d":"¥16,000.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":1,"n_rows":40,"n_cols":10,"rows_kept":40}
[]
[null,null,"半月家庭预算",{"$nulls":6},"收入和支出"]
[]
[]
[]
[null,null,"收入",{"$nulls":3},"支出"]
[]
[null,null,"日期","说明","金额",null,"日期","类别","说明","金额"]
[null,null,{"$f":"NOW()-14","v":"2012-11-27T10:45:38.470"},"David 的薪水",{"v":13000,"d":"¥13,000.00"},null,{"$f":"NOW()-7","v":"2012-12-04T10:45:38.470"},"家庭","抵押",{"v":10000,"d":"¥10,000.00"}]
[null,null,{"$f":"NOW()-14","v":"2012-11-27T10:45:38.470"},"Pat 的薪水",{"v":13000,"d":"¥13,000.00"},null,{"$f":"NOW()-7","v":"2012-12-04T10:45:38.470"},"家庭","电费",{"v":1000,"d":"¥1,000.00"}]
[null,null,{"$f":"NOW()-28","v":"2012-11-13T10:45:38.470"},"David 的薪水",{"v":15000,"d":"¥15,000.00"},null,"2012-12-04T10:45:38.470","家庭","水费/排污费",{"v":500,"d":"¥500.00"}]
[null,null,"2012-11-13T10:45:38.470","Pat 的薪水",{"v":16000,"d":"¥16,000.00"},null,"2012-12-04T10:45:38.470","家庭","垃圾费",{"v":250,"d":"¥250.00"}]
[null,null,{"$f":"NOW()-42","v":"2012-10-30T10:45:38.470"},"David 的薪水",{"v":13000,"d":"¥13,000.00"},null,"2012-12-04T10:45:38.470","家庭","移动电话",{"v":1000,"d":"¥1,000.00"}]
[null,null,"2012-10-30T10:45:38.470","Pat 的薪水",{"v":13000,"d":"¥13,000.00"},null,"2012-12-04T10:45:38.470","家庭","家庭电话",{"v":300,"d":"¥300.00"}]
[null,null,{"$f":"NOW()-56","v":"2012-10-16T10:45:38.470"},"David 的薪水",{"v":15000,"d":"¥15,000.00"},null,"2012-12-04T10:45:38.470","家庭","网费",{"v":500,"d":"¥500.00"}]
[null,null,"2012-10-16T10:45:38.470","Pat 的薪水",{"v":16000,"d":"¥16,000.00"},null,"2012-12-04T10:45:38.470","家庭","电视费",{"v":500,"d":"¥500.00"}]
[null,null,{"$f":"NOW()-70","v":"2012-10-02T10:45:38.470"},"David 的薪水",{"v":13000,"d":"¥13,000.00"},null,"2012-12-04T10:45:38.470","家庭","维护/修理",{"v":250,"d":"¥250.00"}]
[{"$nulls":6},{"$f":"NOW()-8","v":"2012-12-03T10:45:38.470"},"家庭","信用卡 1 ",{"v":1000,"d":"¥1,000.00"}]
[{"$nulls":6},{"$f":"NOW()-9","v":"2012-12-02T10:45:38.470"},"娱乐支出","电影",{"v":370,"d":"¥370.00"}]
[{"$nulls":6},{"$f":"NOW()-10","v":"2012-12-01T10:45:38.470"},"饮食","日用杂货",{"v":3500,"d":"¥3,500.00"}]
[{"$nulls":6},{"$f":"NOW()-11","v":"2012-11-30T10:45:38.470"},"饮食","在外就餐",{"v":750,"d":"¥750.00"}]
[{"$nulls":6},{"$f":"NOW()-12","v":"2012-11-29T10:45:38.470"},"儿童","午餐费",{"v":1500,"d":"¥1,500.00"}]
[{"$nulls":6},{"$f":"NOW()-13","v":"2012-11-28T10:45:38.470"},"投资帐户","储蓄",{"v":2500,"d":"¥2,500.00"}]
[{"$nulls":6},{"$f":"NOW()-14","v":"2012-11-27T10:45:38.470"},"投资帐户","投资帐户",{"v":2500,"d":"¥2,500.00"}]
[{"$nulls":6},{"$f":"NOW()-15","v":"2012-11-26T10:45:38.470"},"个人","健康/健身俱乐部",{"v":1000,"d":"¥1,000.00"}]
[{"$nulls":6},{"$f":"NOW()-16","v":"2012-11-25T10:45:38.470"},"宠物","饮食",{"v":500,"d":"¥500.00"}]
[{"$nulls":6},{"$f":"NOW()-20","v":"2012-11-21T10:45:38.470"},"宠物","毛发清洁梳理",{"v":500,"d":"¥500.00"}]
[{"$nulls":6},{"$f":"NOW()-20","v":"2012-11-21T10:45:38.470"},"宠物","其他",{"v":500,"d":"¥500.00"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-11-16T10:45:38.470"},"交通","汽车 1 付款 ",{"v":3000,"d":"¥3,000.00"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-11-16T10:45:38.470"},"交通","汽车 2 付款 ",{"v":3500,"d":"¥3,500.00"}]
[{"$nulls":6},{"$f":"NOW()-25","v":"2012-11-16T10:45:38.470"},"交通","汽车保险",{"v":500,"d":"¥500.00"}]
[{"$nulls":6},{"$f":"NOW()-30","v":"2012-11-11T10:45:38.470"},"交通","燃油",{"v":500,"d":"¥500.00"}]
[{"$nulls":6},{"$f":"NOW()-31","v":"2012-11-10T10:45:38.470"},"交通","燃油",{"v":250,"d":"¥250.00"}]
[{"$nulls":6},{"$f":"NOW()-42","v":"2012-10-30T10:45:38.470"},"交通","维护/修理",{"v":1500,"d":"¥1,500.00"}]
[{"$nulls":6},{"$f":"NOW()-45","v":"2012-10-27T10:45:38.470"},"家庭","抵押",{"v":50000,"d":"¥50,000.00"}]
[{"$nulls":6},{"$f":"NOW()-50","v":"2012-10-22T10:45:38.470"},"家庭","用品",{"v":2000,"d":"¥2,000.00"}]
[{"$nulls":6},{"$f":"NOW()-65","v":"2012-10-07T10:45:38.470"},"家庭","家庭电话",{"v":1000,"d":"¥1,000.00"}]
[{"$nulls":6},{"$f":"NOW()-70","v":"2012-10-02T10:45:38.470"},"家庭","垃圾费",{"v":500,"d":"¥500.00"}]
[{"$nulls":6},{"$f":"NOW()-75","v":"2012-09-27T10:45:38.470"},"家庭","抵押",{"v":10000,"d":"¥10,000.00"}]
[{"$nulls":6},{"$f":"NOW()-78","v":"2012-09-24T10:45:38.470"},"娱乐支出","电影",{"v":750,"d":"¥750.00"}]

{"sheet":"预算报表","index":2,"n_rows":41,"n_cols":8,"rows_kept":41}
[]
[null,null,"半月家庭预算",{"$nulls":4},"预算报表"]
{"$rows_empty":10}
[null,null,"支出",null,null,"类别总计"]
[]
[null,null,"说明","求和项:金额"]
[null,null,"汽车 1 付款 ",{"v":3000,"d":"¥3,000"}]
[null,null,"汽车 2 付款 ",{"v":3500,"d":"¥3,500"}]
[null,null,"汽车保险",{"v":500,"d":"¥500"}]
[null,null,"电费",{"v":1000,"d":"¥1,000"}]
[null,null,"信用卡 1 ",{"v":1000,"d":"¥1,000"}]
[null,null,"在外就餐",{"v":750,"d":"¥750"}]
[null,null,"移动电话",{"v":1000,"d":"¥1,000"}]
[null,null,"饮食",{"v":500,"d":"¥500"}]
[null,null,"燃油",{"v":750,"d":"¥750"}]
[null,null,"垃圾费",{"v":750,"d":"¥750"}]
[null,null,"日用杂货",{"v":3500,"d":"¥3,500"}]
[null,null,"毛发清洁梳理",{"v":500,"d":"¥500"}]
[null,null,"健康/健身俱乐部",{"v":1000,"d":"¥1,000"}]
[null,null,"家庭电话",{"v":1300,"d":"¥1,300"}]
[null,null,"网费",{"v":500,"d":"¥500"}]
[null,null,"投资帐户",{"v":2500,"d":"¥2,500"}]
[null,null,"午餐费",{"v":1500,"d":"¥1,500"}]
[null,null,"维护/修理",{"v":1750,"d":"¥1,750"}]
[null,null,"抵押",{"v":70000,"d":"¥70,000"}]
[null,null,"电影",{"v":1120,"d":"¥1,120"}]
[null,null,"电视费",{"v":500,"d":"¥500"}]
[null,null,"储蓄",{"v":2500,"d":"¥2,500"}]
[null,null,"其他",{"v":500,"d":"¥500"}]
[null,null,"水费/排污费",{"v":500,"d":"¥500"}]
[null,null,"用品",{"v":2000,"d":"¥2,000"}]
[null,null,"总计",{"v":102420,"d":"¥102,420"}]

{"sheet":"数据列表","index":3,"n_rows":20,"n_cols":14,"rows_kept":20}
[]
[null,null,"半月家庭预算",{"$nulls":10},"数据列表"]
[]
[]
[null,null,"设置         下方的类别数据用以填充支出和收入工作表上支出表中的下拉列表。修改每个类别下方的类别名称或说明以更新列表。"]
[]
[null,null,"家庭","娱乐支出","饮食","礼品/捐赠","儿童","投资帐户","医疗","其他","个人","宠物","法定税","交通"]
[null,null,"抵押","电影","日用杂货","慈善 1","衣服","个人退休金帐户 (IRA)","医生/门诊","其他","服装","饮食","个人所得税","汽车 1 付款 "]
[null,null,"电费","视频/电影","在外就餐","慈善 2","玩具/游戏","储蓄","保险","组织会费","头发/指甲护理","用品","省/市/自治区","汽车 2 付款 "]
[null,null,"水费/排污费","音乐",null,"慈善 3","午餐费","支票帐户",null,null,"干洗","医疗","当地","汽车保险"]
[null,null,"垃圾费","音乐会/剧院",null,"礼品","会费/费用","退休",null,null,"健康/健身俱乐部","毛发清洁梳理","其他","执照/注册"]
[null,null,"移动电话","运动",null,null,"学校用品","投资帐户",null,null,"购物","其他","律师费","燃油"]
[null,null,"家庭电话","其他",null,null,"其他","学院",null,null,"其他",null,"子女抚养费","维护/修理"]
[null,null,"网费",{"$nulls":3},"洗衣物","贷款",{"$nulls":4},"赡养费","公共交通"]
[null,null,"电视费",{"$nulls":4},"学生贷款",{"$nulls":4},"其他"]
[null,null,"维护/修理"]
[null,null,"用品"]
[null,null,"有线/网费/电话"]
[null,null,"信用卡 1 "]
[null,null,"信用卡 2 "]

{"sheet":"类别透视表","index":4,"n_rows":16,"n_cols":14,"rows_kept":16,"hidden":true}
[]
[null,null,"半月家庭预算",{"$nulls":10},"类别透视"]
[]
[]
[null,"此数据透视表是预算报表中类别总计数据透视图的数据源。 "]
[]
[null,null,"行标签","求和项:金额"]
[null,null,"儿童",1500]
[null,null,"娱乐支出",1120]
[null,null,"饮食",4250]
[null,null,"家庭",78800]
[null,null,"投资帐户",5000]
[null,null,"个人",1000]
[null,null,"宠物",1500]
[null,null,"交通",9250]
[null,null,"总计",{"v":102420,"d":"¥102,420"}]