{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["仪表板","预算","设置","图表数据"],"not_rendered":{"charts":2,"images":1,"defined_names":42},"read":"whole","date_system":"1900"}

{"sheet":"仪表板","index":0,"n_rows":13,"n_cols":14,"rows_kept":13,"merged":[[2,0,4,2],[6,0,8,2],[10,0,12,2]]}
[{"$nulls":13},{"$f":"BudgetName&\" 交互式预算\"","v":"孙荷佑一家 2012 年 交互式预算"}]
[]
[{"$f":"图表数据!C38","v":{"v":40000,"d":"¥40,000"}}]
[]
[{"$nulls":3},"收入"]
[]
[{"$f":"图表数据!C39","v":{"v":59330,"d":"¥59,330"}}]
[]
[{"$nulls":3},"支出"]
[]
[{"$f":"图表数据!D40& \"¥\"&图表数据!C40","v":"-¥19330"}]
[]
[{"$nulls":3},"现金流量"]

{"sheet":"预算","index":1,"n_rows":131,"n_cols":16,"rows_kept":131,"merged":[[18,1,18,13],[27,1,27,13],[36,1,36,13],[45,1,45,13],[54,1,54,13],[61,1,61,13],[68,1,68,13],[75,1,75,13],[82,1,82,13],[89,1,89,13],[96,1,96,13],[103,1,103,13],[110,1,110,13],[117,1,117,13],[124,1,124,13]]}
[null,null,"1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年","平均"]
[]
[]
[]
[null,"期初结余",10000]
[null,"总收入",{"$f":"SUM(tblIncome[1 月])","v":42220},{"$f":"SUM(tblIncome[2 月])","v":90330},{"$f":"SUM(tblIncome[3 月])","v":40000},{"$f":"SUM(tblIncome[4 月])","v":40450},{"$f":"SUM(tblIncome[5 月])","v":90000},{"$f":"SUM(tblIncome[6 月])","v":15250},{"$f":"SUM(tblIncome[7 月])","v":15000},{"$f":"SUM(tblIncome[8 月])","v":65000},{"$f":"SUM(tblIncome[9 月])","v":40000},{"$f":"SUM(tblIncome[10 月])","v":40000},{"$f":"SUM(tblIncome[11 月])","v":90000},{"$f":"SUM(tblIncome[12 月])","v":40000},{"$f":"SUM(tblIncome[年])","v":608250},{"$f":"O6/12","v":{"v":50687.5,"d":"50688"}}]
[null,"总支出",{"$f":"SUM(tblExpenseCategory_01[1 月],tblExpenseCategory_02[1 月],tblExpenseCategory_03[1 月],tblExpenseCategory_04[1 月],tblExpenseCategory_05[1 月],tblExpenseCategory_06[1 月],tblExpenseCategory_07[1 月],tblExpenseCategory_08[1 月],tblExpenseCategory_09[1 月],tblExpenseCategory_10[1 月],tblExpenseCategory_11[1 月],tblExpenseCategory_12[1 月],tblExpenseCategory_13[1 月],tblExpenseCategory_14[1 月],tblExpenseCategory_15[1 月])","v":79360},{"$f":"SUM(tblExpenseCategory_01[2 月],tblExpenseCategory_02[2 月],tblExpenseCategory_03[2 月],tblExpenseCategory_04[2 月],tblExpenseCategory_05[2 月],tblExpenseCategory_06[2 月],tblExpenseCategory_07[2 月],tblExpenseCategory_08[2 月],tblExpenseCategory_09[2 月],tblExpenseCategory_10[2 月],tblExpenseCategory_11[2 月],tblExpenseCategory_12[2 月],tblExpenseCategory_13[2 月],tblExpenseCategory_14[2 月],tblExpenseCategory_15[2 月])","v":52430},{"$f":"SUM(tblExpenseCategory_01[3 月],tblExpenseCategory_02[3 月],tblExpenseCategory_03[3 月],tblExpenseCategory_04[3 月],tblExpenseCategory_05[3 月],tblExpenseCategory_06[3 月],tblExpenseCategory_07[3 月],tblExpenseCategory_08[3 月],tblExpenseCategory_09[3 月],tblExpenseCategory_10[3 月],tblExpenseCategory_11[3 月],tblExpenseCategory_12[3 月],tblExpenseCategory_13[3 月],tblExpenseCategory_14[3 月],tblExpenseCategory_15[3 月])","v":59330},{"$f":"SUM(tblExpenseCategory_01[4 月],tblExpenseCategory_02[4 月],tblExpenseCategory_03[4 月],tblExpenseCategory_04[4 月],tblExpenseCategory_05[4 月],tblExpenseCategory_06[4 月],tblExpenseCategory_07[4 月],tblExpenseCategory_08[4 月],tblExpenseCategory_09[4 月],tblExpenseCategory_10[4 月],tblExpenseCategory_11[4 月],tblExpenseCategory_12[4 月],tblExpenseCategory_13[4 月],tblExpenseCategory_14[4 月],tblExpenseCategory_15[4 月])","v":58580},{"$f":"SUM(tblExpenseCategory_01[5 月],tblExpenseCategory_02[5 月],tblExpenseCategory_03[5 月],tblExpenseCategory_04[5 月],tblExpenseCategory_05[5 月],tblExpenseCategory_06[5 月],tblExpenseCategory_07[5 月],tblExpenseCategory_08[5 月],tblExpenseCategory_09[5 月],tblExpenseCategory_10[5 月],tblExpenseCategory_11[5 月],tblExpenseCategory_12[5 月],tblExpenseCategory_13[5 月],tblExpenseCategory_14[5 月],tblExpenseCategory_15[5 月])","v":54680},{"$f":"SUM(tblExpenseCategory_01[6 月],tblExpenseCategory_02[6 月],tblExpenseCategory_03[6 月],tblExpenseCategory_04[6 月],tblExpenseCategory_05[6 月],tblExpenseCategory_06[6 月],tblExpenseCategory_07[6 月],tblExpenseCategory_08[6 月],tblExpenseCategory_09[6 月],tblExpenseCategory_10[6 月],tblExpenseCategory_11[6 月],tblExpenseCategory_12[6 月],tblExpenseCategory_13[6 月],tblExpenseCategory_14[6 月],tblExpenseCategory_15[6 月])","v":51180},{"$f":"SUM(tblExpenseCategory_01[7 月],tblExpenseCategory_02[7 月],tblExpenseCategory_03[7 月],tblExpenseCategory_04[7 月],tblExpenseCategory_05[7 月],tblExpenseCategory_06[7 月],tblExpenseCategory_07[7 月],tblExpenseCategory_08[7 月],tblExpenseCategory_09[7 月],tblExpenseCategory_10[7 月],tblExpenseCategory_11[7 月],tblExpenseCategory_12[7 月],tblExpenseCategory_13[7 月],tblExpenseCategory_14[7 月],tblExpenseCategory_15[7 月])","v":57430},{"$f":"SUM(tblExpenseCategory_01[8 月],tblExpenseCategory_02[8 月],tblExpenseCategory_03[8 月],tblExpenseCategory_04[8 月],tblExpenseCategory_05[8 月],tblExpenseCategory_06[8 月],tblExpenseCategory_07[8 月],tblExpenseCategory_08[8 月],tblExpenseCategory_09[8 月],tblExpenseCategory_10[8 月],tblExpenseCategory_11[8 月],tblExpenseCategory_12[8 月],tblExpenseCategory_13[8 月],tblExpenseCategory_14[8 月],tblExpenseCategory_15[8 月])","v":53530},{"$f":"SUM(tblExpenseCategory_01[9 月],tblExpenseCategory_02[9 月],tblExpenseCategory_03[9 月],tblExpenseCategory_04[9 月],tblExpenseCategory_05[9 月],tblExpenseCategory_06[9 月],tblExpenseCategory_07[9 月],tblExpenseCategory_08[9 月],tblExpenseCategory_09[9 月],tblExpenseCategory_10[9 月],tblExpenseCategory_11[9 月],tblExpenseCategory_12[9 月],tblExpenseCategory_13[9 月],tblExpenseCategory_14[9 月],tblExpenseCategory_15[9 月])","v":59830},{"$f":"SUM(tblExpenseCategory_01[10 月],tblExpenseCategory_02[10 月],tblExpenseCategory_03[10 月],tblExpenseCategory_04[10 月],tblExpenseCategory_05[10 月],tblExpenseCategory_06[10 月],tblExpenseCategory_07[10 月],tblExpenseCategory_08[10 月],tblExpenseCategory_09[10 月],tblExpenseCategory_10[10 月],tblExpenseCategory_11[10 月],tblExpenseCategory_12[10 月],tblExpenseCategory_13[10 月],tblExpenseCategory_14[10 月],tblExpenseCategory_15[10 月])","v":59430},{"$f":"SUM(tblExpenseCategory_01[11 月],tblExpenseCategory_02[11 月],tblExpenseCategory_03[11 月],tblExpenseCategory_04[11 月],tblExpenseCategory_05[11 月],tblExpenseCategory_06[11 月],tblExpenseCategory_07[11 月],tblExpenseCategory_08[11 月],tblExpenseCategory_09[11 月],tblExpenseCategory_10[11 月],tblExpenseCategory_11[11 月],tblExpenseCategory_12[11 月],tblExpenseCategory_13[11 月],tblExpenseCategory_14[11 月],tblExpenseCategory_15[11 月])","v":50580},{"$f":"SUM(tblExpenseCategory_01[12 月],tblExpenseCategory_02[12 月],tblExpenseCategory_03[12 月],tblExpenseCategory_04[12 月],tblExpenseCategory_05[12 月],tblExpenseCategory_06[12 月],tblExpenseCategory_07[12 月],tblExpenseCategory_08[12 月],tblExpenseCategory_09[12 月],tblExpenseCategory_10[12 月],tblExpenseCategory_11[12 月],tblExpenseCategory_12[12 月],tblExpenseCategory_13[12 月],tblExpenseCategory_14[12 月],tblExpenseCategory_15[12 月])","v":49580},{"$f":"SUM(tblExpenseCategory_01[年],tblExpenseCategory_02[年],tblExpenseCategory_03[年],tblExpenseCategory_04[年],tblExpenseCategory_05[年],tblExpenseCategory_06[年],tblExpenseCategory_07[年],tblExpenseCategory_08[年],tblExpenseCategory_09[年],tblExpenseCategory_10[年],tblExpenseCategory_11[年],tblExpenseCategory_12[年],tblExpenseCategory_13[年],tblExpenseCategory_14[年],tblExpenseCategory_15[年])","v":685940},{"$f":"O7/12","v":{"v":57161.666666666664,"d":"57162"}}]
[null,"净收入",{"$f":"C6-C7","v":-37140},{"$f":"D6-D7","v":37900},-19330,-18130,35320,-35930,-42430,11470,-19830,-19430,39420,-9580,-77690,{"$f":"O8/12","v":{"v":-6474.166666666667,"d":"-6474"}}]
[null,"总现金流",{"$f":"C5+C6-C7","v":-27140},{"$f":"C9+D6-D7","v":10760},{"$f":"D9+E6-E7","v":-8570},-26700,8620,-27310,-69740,-58270,-78100,-97530,-58110,-67690]
[]
[]
[null,"收入"]
[null,"工资和消费",40000,40000,40000,40000,40000,10000,10000,10000,40000,40000,40000,40000,{"$f":"SUM(tblIncome[[#This Row],[1 月]:[12 月]])","v":390000},{"$f":"tblIncome[[#This Row],[年]]/12","v":32500}]
[null,"利息收入",2220,330,null,450,null,250,{"$nulls":6},{"$f":"SUM(tblIncome[[#This Row],[1 月]:[12 月]])","v":3250},{"$f":"tblIncome[[#This Row],[年]]/12","v":{"v":270.8333333333333,"d":"271"}}]
[null,"红利",null,50000,null,null,50000,null,null,50000,null,null,50000,null,{"$f":"SUM(tblIncome[[#This Row],[1 月]:[12 月]])","v":200000},{"$f":"tblIncome[[#This Row],[年]]/12","v":{"v":16666.666666666668,"d":"16667"}}]
[null,"还款/退款",{"$nulls":5},5000,5000,5000,{"$nulls":4},{"$f":"SUM(tblIncome[[#This Row],[1 月]:[12 月]])","v":15000},{"$f":"tblIncome[[#This Row],[年]]/12","v":1250}]
[null,"其他",{"$nulls":12},{"$f":"SUM(tblIncome[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblIncome[[#This Row],[年]]/12","v":0}]
[null,{"$f":"UPPER(B12&\" 总额\")","v":"收入 总额"},{"$f":"SUM(tblIncome[1 月])","v":42220},{"$f":"SUM(tblIncome[2 月])","v":90330},{"$f":"SUM(tblIncome[3 月])","v":40000},{"$f":"SUM(tblIncome[4 月])","v":40450},{"$f":"SUM(tblIncome[5 月])","v":90000},{"$f":"SUM(tblIncome[6 月])","v":15250},{"$f":"SUM(tblIncome[7 月])","v":15000},{"$f":"SUM(tblIncome[8 月])","v":65000},{"$f":"SUM(tblIncome[9 月])","v":40000},{"$f":"SUM(tblIncome[10 月])","v":40000},{"$f":"SUM(tblIncome[11 月])","v":90000},{"$f":"SUM(tblIncome[12 月])","v":40000},{"$f":"SUM(tblIncome[年])","v":608250},{"$f":"tblIncome[[#Totals],[年]]/12","v":{"v":50687.5,"d":"50688"}}]
[]
[]
[null,"住宅"]
[null,"押金/租金",8500,8500,8500,8500,8500,8500,8500,8500,8500,8500,9000,9000,{"$f":"SUM(tblExpenseCategory_01[[#This Row],[1 月]:[12 月]])","v":103000},{"$f":"tblExpenseCategory_01[[#This Row],[年]]/12","v":{"v":8583.333333333334,"d":"8583"}}]
[null,"电费",2000,2000,1750,1500,1500,1750,2250,2750,2000,1500,1500,1500,{"$f":"SUM(tblExpenseCategory_01[[#This Row],[1 月]:[12 月]])","v":22000},{"$f":"tblExpenseCategory_01[[#This Row],[年]]/12","v":{"v":1833.3333333333333,"d":"1833"}}]
[null,"电话",500,500,1000,1000,500,500,1000,1000,500,500,500,500,{"$f":"SUM(tblExpenseCategory_01[[#This Row],[1 月]:[12 月]])","v":8000},{"$f":"tblExpenseCategory_01[[#This Row],[年]]/12","v":{"v":666.6666666666666,"d":"667"}}]
[null,"有线/卫星电视",690,690,690,690,690,690,690,690,690,690,690,690,{"$f":"SUM(tblExpenseCategory_01[[#This Row],[1 月]:[12 月]])","v":8280},{"$f":"tblExpenseCategory_01[[#This Row],[年]]/12","v":690}]
[null,"网费",390,390,390,390,390,390,390,390,390,390,390,390,{"$f":"SUM(tblExpenseCategory_01[[#This Row],[1 月]:[12 月]])","v":4680},{"$f":"tblExpenseCategory_01[[#This Row],[年]]/12","v":390}]
[null,{"$f":"UPPER(B21&\" 总额\")","v":"住宅 总额"},{"$f":"SUM(tblExpenseCategory_01[1 月])","v":12080},{"$f":"SUM(tblExpenseCategory_01[2 月])","v":12080},{"$f":"SUM(tblExpenseCategory_01[3 月])","v":12330},{"$f":"SUM(tblExpenseCategory_01[4 月])","v":12080},{"$f":"SUM(tblExpenseCategory_01[5 月])","v":11580},{"$f":"SUM(tblExpenseCategory_01[6 月])","v":11830},{"$f":"SUM(tblExpenseCategory_01[7 月])","v":12830},{"$f":"SUM(tblExpenseCategory_01[8 月])","v":13330},{"$f":"SUM(tblExpenseCategory_01[9 月])","v":12080},{"$f":"SUM(tblExpenseCategory_01[10 月])","v":11580},{"$f":"SUM(tblExpenseCategory_01[11 月])","v":12080},{"$f":"SUM(tblExpenseCategory_01[12 月])","v":12080},{"$f":"SUM(tblExpenseCategory_01[年])","v":145960},{"$f":"tblExpenseCategory_01[[#Totals],[年]]/12","v":{"v":12163.333333333334,"d":"12163"}}]
[]
[]
[null,"日常生活"]
[null,"日用杂货",3450,2500,2000,4000,3500,2500,4000,3500,2500,4000,3500,2500,{"$f":"SUM(tblExpenseCategory_02[[#This Row],[1 月]:[12 月]])","v":37950},{"$f":"tblExpenseCategory_02[[#This Row],[年]]/12","v":{"v":3162.5,"d":"3163"}}]
[null,"服饰",3000,null,null,3000,null,null,3000,null,null,3000,null,null,{"$f":"SUM(tblExpenseCategory_02[[#This Row],[1 月]:[12 月]])","v":12000},{"$f":"tblExpenseCategory_02[[#This Row],[年]]/12","v":1000}]
[null,"在外就餐",1250,1250,3000,1250,1250,2000,1250,1250,1250,1250,1250,1250,{"$f":"SUM(tblExpenseCategory_02[[#This Row],[1 月]:[12 月]])","v":17500},{"$f":"tblExpenseCategory_02[[#This Row],[年]]/12","v":{"v":1458.3333333333333,"d":"1458"}}]
[null,"美容/理发",250,null,500,null,250,null,500,null,250,null,1000,null,{"$f":"SUM(tblExpenseCategory_02[[#This Row],[1 月]:[12 月]])","v":2750},{"$f":"tblExpenseCategory_02[[#This Row],[年]]/12","v":{"v":229.16666666666666,"d":"229"}}]
[null,"其他",{"$nulls":12},{"$f":"SUM(tblExpenseCategory_02[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_02[[#This Row],[年]]/12","v":0}]
[null,{"$f":"UPPER(B30&\" 总额\")","v":"日常生活 总额"},{"$f":"SUM(tblExpenseCategory_02[1 月])","v":7950},{"$f":"SUM(tblExpenseCategory_02[2 月])","v":3750},{"$f":"SUM(tblExpenseCategory_02[3 月])","v":5500},{"$f":"SUM(tblExpenseCategory_02[4 月])","v":8250},{"$f":"SUM(tblExpenseCategory_02[5 月])","v":5000},{"$f":"SUM(tblExpenseCategory_02[6 月])","v":4500},{"$f":"SUM(tblExpenseCategory_02[7 月])","v":8750},{"$f":"SUM(tblExpenseCategory_02[8 月])","v":4750},{"$f":"SUM(tblExpenseCategory_02[9 月])","v":4000},{"$f":"SUM(tblExpenseCategory_02[10 月])","v":8250},{"$f":"SUM(tblExpenseCategory_02[11 月])","v":5750},{"$f":"SUM(tblExpenseCategory_02[12 月])","v":3750},{"$f":"SUM(tblExpenseCategory_02[年])","v":70200},{"$f":"tblExpenseCategory_02[[#Totals],[年]]/12","v":5850}]
[]
[]
[null,"孩子"]
[null,"学校用品",1230,null,1000,{"$nulls":4},3450,{"$nulls":4},{"$f":"SUM(tblExpenseCategory_03[[#This Row],[1 月]:[12 月]])","v":5680},{"$f":"tblExpenseCategory_03[[#This Row],[年]]/12","v":{"v":473.3333333333333,"d":"473"}}]
[null,"服饰",null,1000,null,null,1000,{"$nulls":3},1000,null,null,1000,{"$f":"SUM(tblExpenseCategory_03[[#This Row],[1 月]:[12 月]])","v":4000},{"$f":"tblExpenseCategory_03[[#This Row],[年]]/12","v":{"v":333.3333333333333,"d":"333"}}]
[null,"学校午餐",500,500,500,500,500,500,null,null,500,500,500,500,{"$f":"SUM(tblExpenseCategory_03[[#This Row],[1 月]:[12 月]])","v":5000},{"$f":"tblExpenseCategory_03[[#This Row],[年]]/12","v":{"v":416.6666666666667,"d":"417"}}]
[null,"医疗",2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,{"$f":"SUM(tblExpenseCategory_03[[#This Row],[1 月]:[12 月]])","v":24000},{"$f":"tblExpenseCategory_03[[#This Row],[年]]/12","v":2000}]
[null,"其他",20000,1500,{"$nulls":3},2000,{"$nulls":3},1000,null,null,{"$f":"SUM(tblExpenseCategory_03[[#This Row],[1 月]:[12 月]])","v":24500},{"$f":"tblExpenseCategory_03[[#This Row],[年]]/12","v":{"v":2041.6666666666667,"d":"2042"}}]
[null,{"$f":"UPPER(B39&\" 总额\")","v":"孩子 总额"},{"$f":"SUM(tblExpenseCategory_03[1 月])","v":23730},{"$f":"SUM(tblExpenseCategory_03[2 月])","v":5000},{"$f":"SUM(tblExpenseCategory_03[3 月])","v":3500},{"$f":"SUM(tblExpenseCategory_03[4 月])","v":2500},{"$f":"SUM(tblExpenseCategory_03[5 月])","v":3500},{"$f":"SUM(tblExpenseCategory_03[6 月])","v":4500},{"$f":"SUM(tblExpenseCategory_03[7 月])","v":2000},{"$f":"SUM(tblExpenseCategory_03[8 月])","v":5450},{"$f":"SUM(tblExpenseCategory_03[9 月])","v":3500},{"$f":"SUM(tblExpenseCategory_03[10 月])","v":3500},{"$f":"SUM(tblExpenseCategory_03[11 月])","v":2500},{"$f":"SUM(tblExpenseCategory_03[12 月])","v":3500},{"$f":"SUM(tblExpenseCategory_03[年])","v":63180},{"$f":"tblExpenseCategory_03[[#Totals],[年]]/12","v":5265}]
[]
[]
[null,"交通"]
[null,"交通工具费用",6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,{"$f":"SUM(tblExpenseCategory_04[[#This Row],[1 月]:[12 月]])","v":72000},{"$f":"tblExpenseCategory_04[[#This Row],[年]]/12","v":6000}]
[null,"燃油",3250,3250,3250,3250,3250,5000,5000,5000,3250,3250,3250,3250,{"$f":"SUM(tblExpenseCategory_04[[#This Row],[1 月]:[12 月]])","v":44250},{"$f":"tblExpenseCategory_04[[#This Row],[年]]/12","v":{"v":3687.5,"d":"3688"}}]
[null,"修理",null,1000,null,1000,null,1000,null,1000,null,1000,null,null,{"$f":"SUM(tblExpenseCategory_04[[#This Row],[1 月]:[12 月]])","v":5000},{"$f":"tblExpenseCategory_04[[#This Row],[年]]/12","v":{"v":416.6666666666667,"d":"417"}}]
[null,"登记/许可证",1850,{"$nulls":7},2250,{"$nulls":3},{"$f":"SUM(tblExpenseCategory_04[[#This Row],[1 月]:[12 月]])","v":4100},{"$f":"tblExpenseCategory_04[[#This Row],[年]]/12","v":{"v":341.6666666666667,"d":"342"}}]
[null,"其他",{"$nulls":4},4000,{"$nulls":7},{"$f":"SUM(tblExpenseCategory_04[[#This Row],[1 月]:[12 月]])","v":4000},{"$f":"tblExpenseCategory_04[[#This Row],[年]]/12","v":{"v":333.3333333333333,"d":"333"}}]
[null,{"$f":"UPPER(B48&\" 总额\")","v":"交通 总额"},{"$f":"SUM(tblExpenseCategory_04[1 月])","v":11100},{"$f":"SUM(tblExpenseCategory_04[2 月])","v":10250},{"$f":"SUM(tblExpenseCategory_04[3 月])","v":9250},{"$f":"SUM(tblExpenseCategory_04[4 月])","v":10250},{"$f":"SUM(tblExpenseCategory_04[5 月])","v":13250},{"$f":"SUM(tblExpenseCategory_04[6 月])","v":12000},{"$f":"SUM(tblExpenseCategory_04[7 月])","v":11000},{"$f":"SUM(tblExpenseCategory_04[8 月])","v":12000},{"$f":"SUM(tblExpenseCategory_04[9 月])","v":11500},{"$f":"SUM(tblExpenseCategory_04[10 月])","v":10250},{"$f":"SUM(tblExpenseCategory_04[11 月])","v":9250},{"$f":"SUM(tblExpenseCategory_04[12 月])","v":9250},{"$f":"SUM(tblExpenseCategory_04[年])","v":129350},{"$f":"tblExpenseCategory_04[[#Totals],[年]]/12","v":{"v":10779.166666666666,"d":"10779"}}]
[]
[]
[null,"健康"]
[null,"医生/牙医",null,350,null,null,350,350,350,null,null,350,null,null,{"$f":"SUM(tblExpenseCategory_05[[#This Row],[1 月]:[12 月]])","v":1750},{"$f":"tblExpenseCategory_05[[#This Row],[年]]/12","v":{"v":145.83333333333334,"d":"146"}}]
[null,"药品",250,250,250,250,250,250,250,250,250,250,250,250,{"$f":"SUM(tblExpenseCategory_05[[#This Row],[1 月]:[12 月]])","v":3000},{"$f":"tblExpenseCategory_05[[#This Row],[年]]/12","v":250}]
[null,"其他",null,null,1500,{"$nulls":5},1500,{"$nulls":3},{"$f":"SUM(tblExpenseCategory_05[[#This Row],[1 月]:[12 月]])","v":3000},{"$f":"tblExpenseCategory_05[[#This Row],[年]]/12","v":250}]
[null,{"$f":"UPPER(B57&\" 总额\")","v":"健康 总额"},{"$f":"SUM(tblExpenseCategory_05[1 月])","v":250},{"$f":"SUM(tblExpenseCategory_05[2 月])","v":600},{"$f":"SUM(tblExpenseCategory_05[3 月])","v":1750},{"$f":"SUM(tblExpenseCategory_05[4 月])","v":250},{"$f":"SUM(tblExpenseCategory_05[5 月])","v":600},{"$f":"SUM(tblExpenseCategory_05[6 月])","v":600},{"$f":"SUM(tblExpenseCategory_05[7 月])","v":600},{"$f":"SUM(tblExpenseCategory_05[8 月])","v":250},{"$f":"SUM(tblExpenseCategory_05[9 月])","v":1750},{"$f":"SUM(tblExpenseCategory_05[10 月])","v":600},{"$f":"SUM(tblExpenseCategory_05[11 月])","v":250},{"$f":"SUM(tblExpenseCategory_05[12 月])","v":250},{"$f":"SUM(tblExpenseCategory_05[年])","v":7750},{"$f":"tblExpenseCategory_05[[#Totals],[年]]/12","v":{"v":645.8333333333334,"d":"646"}}]
[]
[]
[null,"保险"]
[null,"汽车",1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,{"$f":"SUM(tblExpenseCategory_06[[#This Row],[1 月]:[12 月]])","v":18000},{"$f":"tblExpenseCategory_06[[#This Row],[年]]/12","v":1500}]
[null,"健康",6750,6750,6750,6750,6750,6750,6750,6750,6750,6750,6750,6750,{"$f":"SUM(tblExpenseCategory_06[[#This Row],[1 月]:[12 月]])","v":81000},{"$f":"tblExpenseCategory_06[[#This Row],[年]]/12","v":6750}]
[null,"生活",1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,{"$f":"SUM(tblExpenseCategory_06[[#This Row],[1 月]:[12 月]])","v":18000},{"$f":"tblExpenseCategory_06[[#This Row],[年]]/12","v":1500}]
[null,{"$f":"UPPER(B64&\" 总额\")","v":"保险 总额"},{"$f":"SUM(tblExpenseCategory_06[1 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[2 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[3 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[4 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[5 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[6 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[7 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[8 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[9 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[10 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[11 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[12 月])","v":9750},{"$f":"SUM(tblExpenseCategory_06[年])","v":117000},{"$f":"tblExpenseCategory_06[[#Totals],[年]]/12","v":9750}]
[]
[]
[null,"教育"]
[null,"学费",null,null,4000,{"$nulls":5},4000,{"$nulls":3},{"$f":"SUM(tblExpenseCategory_07[[#This Row],[1 月]:[12 月]])","v":8000},{"$f":"tblExpenseCategory_07[[#This Row],[年]]/12","v":{"v":666.6666666666666,"d":"667"}}]
[null,"书籍",null,null,2250,{"$nulls":5},2250,{"$nulls":3},{"$f":"SUM(tblExpenseCategory_07[[#This Row],[1 月]:[12 月]])","v":4500},{"$f":"tblExpenseCategory_07[[#This Row],[年]]/12","v":375}]
[null,"其他",{"$nulls":12},{"$f":"SUM(tblExpenseCategory_07[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_07[[#This Row],[年]]/12","v":0}]
[null,{"$f":"UPPER(B71&\" 总额\")","v":"教育 总额"},{"$f":"SUM(tblExpenseCategory_07[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[3 月])","v":6250},{"$f":"SUM(tblExpenseCategory_07[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[9 月])","v":6250},{"$f":"SUM(tblExpenseCategory_07[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[年])","v":12500},{"$f":"tblExpenseCategory_07[[#Totals],[年]]/12","v":{"v":1041.6666666666667,"d":"1042"}}]
[]
[]
[null,"慈善"]
[null,"赠予的礼品",null,1000,{"$nulls":3},1000,{"$nulls":3},1000,null,null,{"$f":"SUM(tblExpenseCategory_08[[#This Row],[1 月]:[12 月]])","v":3000},{"$f":"tblExpenseCategory_08[[#This Row],[年]]/12","v":250}]
[null,"慈善捐赠",null,null,1000,null,1000,null,1000,null,1000,null,1000,null,{"$f":"SUM(tblExpenseCategory_08[[#This Row],[1 月]:[12 月]])","v":5000},{"$f":"tblExpenseCategory_08[[#This Row],[年]]/12","v":{"v":416.6666666666667,"d":"417"}}]
[null,"其他",{"$nulls":3},1000,{"$nulls":3},1000,{"$nulls":3},1000,{"$f":"SUM(tblExpenseCategory_08[[#This Row],[1 月]:[12 月]])","v":3000},{"$f":"tblExpenseCategory_08[[#This Row],[年]]/12","v":250}]
[null,{"$f":"UPPER(B78&\" 总额\")","v":"慈善 总额"},{"$f":"SUM(tblExpenseCategory_08[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_08[2 月])","v":1000},{"$f":"SUM(tblExpenseCategory_08[3 月])","v":1000},{"$f":"SUM(tblExpenseCategory_08[4 月])","v":1000},{"$f":"SUM(tblExpenseCategory_08[5 月])","v":1000},{"$f":"SUM(tblExpenseCategory_08[6 月])","v":1000},{"$f":"SUM(tblExpenseCategory_08[7 月])","v":1000},{"$f":"SUM(tblExpenseCategory_08[8 月])","v":1000},{"$f":"SUM(tblExpenseCategory_08[9 月])","v":1000},{"$f":"SUM(tblExpenseCategory_08[10 月])","v":1000},{"$f":"SUM(tblExpenseCategory_08[11 月])","v":1000},{"$f":"SUM(tblExpenseCategory_08[12 月])","v":1000},{"$f":"SUM(tblExpenseCategory_08[年])","v":11000},{"$f":"tblExpenseCategory_08[[#Totals],[年]]/12","v":{"v":916.6666666666666,"d":"917"}}]
[]
[]
[null,"储蓄"]
[null,"应急基金",1000,1000,1000,1000,1000,{"$nulls":3},1000,1000,1000,1000,{"$f":"SUM(tblExpenseCategory_09[[#This Row],[1 月]:[12 月]])","v":9000},{"$f":"tblExpenseCategory_09[[#This Row],[年]]/12","v":750}]
[null,"退休（401k，IRA）",5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,{"$f":"SUM(tblExpenseCategory_09[[#This Row],[1 月]:[12 月]])","v":60000},{"$f":"tblExpenseCategory_09[[#This Row],[年]]/12","v":5000}]
[null,"转帐储蓄",2000,2000,2000,2000,2000,{"$nulls":3},2000,2000,2000,2000,{"$f":"SUM(tblExpenseCategory_09[[#This Row],[1 月]:[12 月]])","v":18000},{"$f":"tblExpenseCategory_09[[#This Row],[年]]/12","v":1500}]
[null,{"$f":"UPPER(B85&\" 总额\")","v":"储蓄 总额"},{"$f":"SUM(tblExpenseCategory_09[1 月])","v":8000},{"$f":"SUM(tblExpenseCategory_09[2 月])","v":8000},{"$f":"SUM(tblExpenseCategory_09[3 月])","v":8000},{"$f":"SUM(tblExpenseCategory_09[4 月])","v":8000},{"$f":"SUM(tblExpenseCategory_09[5 月])","v":8000},{"$f":"SUM(tblExpenseCategory_09[6 月])","v":5000},{"$f":"SUM(tblExpenseCategory_09[7 月])","v":5000},{"$f":"SUM(tblExpenseCategory_09[8 月])","v":5000},{"$f":"SUM(tblExpenseCategory_09[9 月])","v":8000},{"$f":"SUM(tblExpenseCategory_09[10 月])","v":8000},{"$f":"SUM(tblExpenseCategory_09[11 月])","v":8000},{"$f":"SUM(tblExpenseCategory_09[12 月])","v":8000},{"$f":"SUM(tblExpenseCategory_09[年])","v":87000},{"$f":"tblExpenseCategory_09[[#Totals],[年]]/12","v":7250}]
[]
[]
[null,"债务"]
[null,"信用卡 1",1450,1450,1450,1450,1450,1450,1450,1450,1450,1450,1450,1450,{"$f":"SUM(tblExpenseCategory_10[[#This Row],[1 月]:[12 月]])","v":17400},{"$f":"tblExpenseCategory_10[[#This Row],[年]]/12","v":1450}]
[null,"联邦税",4500,null,null,4500,null,null,4500,null,null,4500,null,null,{"$f":"SUM(tblExpenseCategory_10[[#This Row],[1 月]:[12 月]])","v":18000},{"$f":"tblExpenseCategory_10[[#This Row],[年]]/12","v":1500}]
[null,"助学贷款",550,550,550,550,550,550,550,550,550,550,550,550,{"$f":"SUM(tblExpenseCategory_10[[#This Row],[1 月]:[12 月]])","v":6600},{"$f":"tblExpenseCategory_10[[#This Row],[年]]/12","v":550}]
[null,{"$f":"UPPER(B92&\" 总额\")","v":"债务 总额"},{"$f":"SUM(tblExpenseCategory_10[1 月])","v":6500},{"$f":"SUM(tblExpenseCategory_10[2 月])","v":2000},{"$f":"SUM(tblExpenseCategory_10[3 月])","v":2000},{"$f":"SUM(tblExpenseCategory_10[4 月])","v":6500},{"$f":"SUM(tblExpenseCategory_10[5 月])","v":2000},{"$f":"SUM(tblExpenseCategory_10[6 月])","v":2000},{"$f":"SUM(tblExpenseCategory_10[7 月])","v":6500},{"$f":"SUM(tblExpenseCategory_10[8 月])","v":2000},{"$f":"SUM(tblExpenseCategory_10[9 月])","v":2000},{"$f":"SUM(tblExpenseCategory_10[10 月])","v":6500},{"$f":"SUM(tblExpenseCategory_10[11 月])","v":2000},{"$f":"SUM(tblExpenseCategory_10[12 月])","v":2000},{"$f":"SUM(tblExpenseCategory_10[年])","v":42000},{"$f":"tblExpenseCategory_10[[#Totals],[年]]/12","v":3500}]
[]
[]
[null," "]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_11[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_11[[#This Row],[年]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_11[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_11[[#This Row],[年]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_11[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_11[[#This Row],[年]]/12","v":0}]
[null,{"$f":"UPPER(B99&\" 总额\")","v":"  总额"},{"$f":"SUM(tblExpenseCategory_11[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[3 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[9 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[年])","v":0},{"$f":"tblExpenseCategory_11[[#Totals],[年]]/12","v":0}]
[]
[]
[null," "]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_12[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_12[[#This Row],[年]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_12[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_12[[#This Row],[年]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_12[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_12[[#This Row],[年]]/12","v":0}]
[null,{"$f":"UPPER(B106&\" 总额\")","v":"  总额"},{"$f":"SUM(tblExpenseCategory_12[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[3 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[9 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[年])","v":0},{"$f":"tblExpenseCategory_12[[#Totals],[年]]/12","v":0}]
[]
[]
[null," "]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_13[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_13[[#This Row],[年]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_13[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_13[[#This Row],[年]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_13[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_13[[#This Row],[年]]/12","v":0}]
[null,{"$f":"UPPER(B113&\" 总额\")","v":"  总额"},{"$f":"SUM(tblExpenseCategory_13[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[3 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[9 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[年])","v":0},{"$f":"tblExpenseCategory_13[[#Totals],[年]]/12","v":0}]
[]
[]
[null," "]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_14[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_14[[#This Row],[年]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_14[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_14[[#This Row],[年]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_14[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_14[[#This Row],[年]]/12","v":0}]
[null,{"$f":"UPPER(B120&\" 总额\")","v":"  总额"},{"$f":"SUM(tblExpenseCategory_14[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[3 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[9 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[年])","v":0},{"$f":"tblExpenseCategory_14[[#Totals],[年]]/12","v":0}]
[]
[]
[null," "]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_15[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_15[[#This Row],[年]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_15[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_15[[#This Row],[年]]/12","v":0}]
[{"$nulls":14},{"$f":"SUM(tblExpenseCategory_15[[#This Row],[1 月]:[12 月]])","v":0},{"$f":"tblExpenseCategory_15[[#This Row],[年]]/12","v":0}]
[null,{"$f":"UPPER(B127&\" 总额\")","v":"  总额"},{"$f":"SUM(tblExpenseCategory_15[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[3 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[9 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[年])","v":0},{"$f":"tblExpenseCategory_15[[#Totals],[年]]/12","v":0}]

{"sheet":"设置","index":2,"n_rows":59,"n_cols":10,"rows_kept":59}
[null,"孙荷佑一家 2012 年"]
[null,"收入",null,"支出"]
[null,"工资和小费",null," "]
[null,"利息收入",null,"住宅",null,"住宅",null,"日常生活",null,"孩子"]
[null,"红利",null,"日常生活",null,"押金/租金",null,"日常生活",null,"医疗"]
[null,"收到的礼品",null,"孩子",null,"电费",null,"日用杂货",null,"服饰"]
[null,"还款/退款",null,"交通",null,"燃气/燃油",null,"个人用品",null,"学费"]
[null,"从储蓄转帐",null,"健康",null,"水费/污水处理费",null,"服饰",null,"学校午餐"]
[null,"其他",null,"保险",null,"电话",null,"清洁服务",null,"学校用品"]
[{"$nulls":3},"教育",null,"有线/卫星电视",null,"在外就餐",null,"婴儿照顾"]
[{"$nulls":3},"慈善",null,"网费",null,"干洗",null,"玩具/游戏"]
[{"$nulls":3},"储蓄",null,"家电",null,"美容/理发",null,"其他"]
[{"$nulls":3},"债务",null,"草坪/花园"]
[{"$nulls":3},"娱乐",null,"住宅用品"]
[{"$nulls":3},"宠物",null,"维修"]
[{"$nulls":3},"订阅",null,"改良"]
[{"$nulls":3},"假期",null,"其他"]
[{"$nulls":3},"杂项"]
[]
[{"$nulls":5},"交通",null,"健康",null,"保险"]
[{"$nulls":5},"交通工具费用",null,"医生/牙医",null,"汽车"]
[{"$nulls":5},"燃料",null,"药品",null,"健康"]
[{"$nulls":5},"公共汽车/出租车/火车票",null,"健康俱乐部会费",null,"住宅/租赁"]
[{"$nulls":5},"修理",null,"紧急",null,"生活"]
[{"$nulls":5},"登记/许可证",null,"其他",null,"其他"]
[{"$nulls":5},"其他"]
[]
[]
[{"$nulls":5},"教育",null,"慈善",null,"储蓄"]
[{"$nulls":5},"学费",null,"赠予的礼品",null,"应急基金"]
[{"$nulls":5},"书籍",null,"慈善捐赠",null,"转帐储蓄"]
[{"$nulls":5},"音乐课",null,"宗教捐赠",null,"退休（401k，ira）"]
[{"$nulls":5},"其他",null,"其他",null,"投资"]
[{"$nulls":9},"大学"]
[{"$nulls":9},"其他"]
[]
[]
[{"$nulls":5},"债务",null,"娱乐",null,"宠物"]
[{"$nulls":5},"助学贷款",null,"录像/DVD",null,"食品"]
[{"$nulls":5},"其他贷款",null,"音乐",null,"医疗"]
[{"$nulls":5},"信用卡 1",null,"游戏",null,"玩具/用品"]
[{"$nulls":5},"信用卡 2",null,"租赁",null,"其他"]
[{"$nulls":5},"信用卡 3",null,"电影/戏剧"]
[{"$nulls":5},"离婚赡养费/子女抚养费",null,"音乐会/演奏"]
[{"$nulls":5},"联邦税",null,"书籍"]
[{"$nulls":5},"物业税",null,"业余爱好"]
[{"$nulls":5},"省市自治区/地方税",null,"胶卷/照片"]
[{"$nulls":5},"管理费",null,"运动"]
[{"$nulls":5},"法律费用",null,"户外消遣"]
[{"$nulls":5},"其他",null,"玩具/小玩意"]
[{"$nulls":7},"其他"]
[]
[{"$nulls":5},"订阅",null,"假期",null,"杂项"]
[{"$nulls":5},"报纸",null,"旅游",null,"银行手续费"]
[{"$nulls":5},"杂志",null,"住宿",null,"邮资"]
[{"$nulls":5},"会费",null,"食品",null,"其他"]
[{"$nulls":5},"俱乐部会员",null,"租车"]
[{"$nulls":5},"其他",null,"娱乐"]
[{"$nulls":7},"其他"]

{"sheet":"图表数据","index":3,"n_rows":40,"n_cols":16,"rows_kept":40,"hidden":true}
[null,"*** 此工作表应保持为隐藏状态 ***"]
[]
[]
[null,"期间",3]
[]
[null,null,"1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年","平均"]
[null,{"$f":"LOWER(预算!#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(tblExpenseCategory_15[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[3 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[9 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_15[年])","v":0},{"$f":"SUM(tblExpenseCategory_15[平均])","v":0}]
[null,{"$f":"LOWER(预算!B120)","v":" "},{"$f":"SUM(tblExpenseCategory_14[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[3 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[9 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_14[年])","v":0},{"$f":"SUM(tblExpenseCategory_14[平均])","v":0}]
[null,{"$f":"LOWER(预算!B113)","v":" "},{"$f":"SUM(tblExpenseCategory_13[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[3 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[9 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_13[年])","v":0},{"$f":"SUM(tblExpenseCategory_13[平均])","v":0}]
[null,{"$f":"LOWER(预算!B106)","v":" "},{"$f":"SUM(tblExpenseCategory_12[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[3 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[9 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_12[年])","v":0},{"$f":"SUM(tblExpenseCategory_12[平均])","v":0}]
[null,{"$f":"LOWER(预算!B99)","v":" "},{"$f":"SUM(tblExpenseCategory_11[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[3 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[9 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_11[年])","v":0},{"$f":"SUM(tblExpenseCategory_11[平均])","v":0}]
[null,{"$f":"LOWER(预算!B92)","v":"债务"},{"$f":"SUM(tblExpenseCategory_10[1 月])","v":{"v":6500,"d":"6,500"}},{"$f":"SUM(tblExpenseCategory_10[2 月])","v":{"v":2000,"d":"2,000"}},{"$f":"SUM(tblExpenseCategory_10[3 月])","v":{"v":2000,"d":"2,000"}},{"$f":"SUM(tblExpenseCategory_10[4 月])","v":{"v":6500,"d":"6,500"}},{"$f":"SUM(tblExpenseCategory_10[5 月])","v":{"v":2000,"d":"2,000"}},{"$f":"SUM(tblExpenseCategory_10[6 月])","v":{"v":2000,"d":"2,000"}},{"$f":"SUM(tblExpenseCategory_10[7 月])","v":{"v":6500,"d":"6,500"}},{"$f":"SUM(tblExpenseCategory_10[8 月])","v":{"v":2000,"d":"2,000"}},{"$f":"SUM(tblExpenseCategory_10[9 月])","v":{"v":2000,"d":"2,000"}},{"$f":"SUM(tblExpenseCategory_10[10 月])","v":{"v":6500,"d":"6,500"}},{"$f":"SUM(tblExpenseCategory_10[11 月])","v":{"v":2000,"d":"2,000"}},{"$f":"SUM(tblExpenseCategory_10[12 月])","v":{"v":2000,"d":"2,000"}},{"$f":"SUM(tblExpenseCategory_10[年])","v":{"v":42000,"d":"42,000"}},{"$f":"SUM(tblExpenseCategory_10[平均])","v":{"v":3500,"d":"3,500"}}]
[null,{"$f":"LOWER(预算!B85)","v":"储蓄"},{"$f":"SUM(tblExpenseCategory_09[1 月])","v":{"v":8000,"d":"8,000"}},{"$f":"SUM(tblExpenseCategory_09[2 月])","v":{"v":8000,"d":"8,000"}},{"$f":"SUM(tblExpenseCategory_09[3 月])","v":{"v":8000,"d":"8,000"}},{"$f":"SUM(tblExpenseCategory_09[4 月])","v":{"v":8000,"d":"8,000"}},{"$f":"SUM(tblExpenseCategory_09[5 月])","v":{"v":8000,"d":"8,000"}},{"$f":"SUM(tblExpenseCategory_09[6 月])","v":{"v":5000,"d":"5,000"}},{"$f":"SUM(tblExpenseCategory_09[7 月])","v":{"v":5000,"d":"5,000"}},{"$f":"SUM(tblExpenseCategory_09[8 月])","v":{"v":5000,"d":"5,000"}},{"$f":"SUM(tblExpenseCategory_09[9 月])","v":{"v":8000,"d":"8,000"}},{"$f":"SUM(tblExpenseCategory_09[10 月])","v":{"v":8000,"d":"8,000"}},{"$f":"SUM(tblExpenseCategory_09[11 月])","v":{"v":8000,"d":"8,000"}},{"$f":"SUM(tblExpenseCategory_09[12 月])","v":{"v":8000,"d":"8,000"}},{"$f":"SUM(tblExpenseCategory_09[年])","v":{"v":87000,"d":"87,000"}},{"$f":"SUM(tblExpenseCategory_09[平均])","v":{"v":7250,"d":"7,250"}}]
[null,{"$f":"LOWER(预算!B78)","v":"慈善"},{"$f":"SUM(tblExpenseCategory_08[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_08[2 月])","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(tblExpenseCategory_08[3 月])","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(tblExpenseCategory_08[4 月])","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(tblExpenseCategory_08[5 月])","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(tblExpenseCategory_08[6 月])","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(tblExpenseCategory_08[7 月])","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(tblExpenseCategory_08[8 月])","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(tblExpenseCategory_08[9 月])","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(tblExpenseCategory_08[10 月])","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(tblExpenseCategory_08[11 月])","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(tblExpenseCategory_08[12 月])","v":{"v":1000,"d":"1,000"}},{"$f":"SUM(tblExpenseCategory_08[年])","v":{"v":11000,"d":"11,000"}},{"$f":"SUM(tblExpenseCategory_08[平均])","v":{"v":916.6666666666667,"d":"917"}}]
[null,{"$f":"LOWER(预算!B71)","v":"教育"},{"$f":"SUM(tblExpenseCategory_07[1 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[2 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[3 月])","v":{"v":6250,"d":"6,250"}},{"$f":"SUM(tblExpenseCategory_07[4 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[5 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[6 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[7 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[8 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[9 月])","v":{"v":6250,"d":"6,250"}},{"$f":"SUM(tblExpenseCategory_07[10 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[11 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[12 月])","v":0},{"$f":"SUM(tblExpenseCategory_07[年])","v":{"v":12500,"d":"12,500"}},{"$f":"SUM(tblExpenseCategory_07[平均])","v":{"v":1041.6666666666665,"d":"1,042"}}]
[null,{"$f":"LOWER(预算!B64)","v":"保险"},{"$f":"SUM(tblExpenseCategory_06[1 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[2 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[3 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[4 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[5 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[6 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[7 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[8 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[9 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[10 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[11 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[12 月])","v":{"v":9750,"d":"9,750"}},{"$f":"SUM(tblExpenseCategory_06[年])","v":{"v":117000,"d":"117,000"}},{"$f":"SUM(tblExpenseCategory_06[平均])","v":{"v":9750,"d":"9,750"}}]
[null,{"$f":"LOWER(预算!B57)","v":"健康"},{"$f":"SUM(tblExpenseCategory_05[1 月])","v":250},{"$f":"SUM(tblExpenseCategory_05[2 月])","v":600},{"$f":"SUM(tblExpenseCategory_05[3 月])","v":{"v":1750,"d":"1,750"}},{"$f":"SUM(tblExpenseCategory_05[4 月])","v":250},{"$f":"SUM(tblExpenseCategory_05[5 月])","v":600},{"$f":"SUM(tblExpenseCategory_05[6 月])","v":600},{"$f":"SUM(tblExpenseCategory_05[7 月])","v":600},{"$f":"SUM(tblExpenseCategory_05[8 月])","v":250},{"$f":"SUM(tblExpenseCategory_05[9 月])","v":{"v":1750,"d":"1,750"}},{"$f":"SUM(tblExpenseCategory_05[10 月])","v":600},{"$f":"SUM(tblExpenseCategory_05[11 月])","v":250},{"$f":"SUM(tblExpenseCategory_05[12 月])","v":250},{"$f":"SUM(tblExpenseCategory_05[年])","v":{"v":7750,"d":"7,750"}},{"$f":"SUM(tblExpenseCategory_05[平均])","v":{"v":645.8333333333334,"d":"646"}}]
[null,{"$f":"LOWER(预算!B48)","v":"交通"},{"$f":"SUM(tblExpenseCategory_04[1 月])","v":{"v":11100,"d":"11,100"}},{"$f":"SUM(tblExpenseCategory_04[2 月])","v":{"v":10250,"d":"10,250"}},{"$f":"SUM(tblExpenseCategory_04[3 月])","v":{"v":9250,"d":"9,250"}},{"$f":"SUM(tblExpenseCategory_04[4 月])","v":{"v":10250,"d":"10,250"}},{"$f":"SUM(tblExpenseCategory_04[5 月])","v":{"v":13250,"d":"13,250"}},{"$f":"SUM(tblExpenseCategory_04[6 月])","v":{"v":12000,"d":"12,000"}},{"$f":"SUM(tblExpenseCategory_04[7 月])","v":{"v":11000,"d":"11,000"}},{"$f":"SUM(tblExpenseCategory_04[8 月])","v":{"v":12000,"d":"12,000"}},{"$f":"SUM(tblExpenseCategory_04[9 月])","v":{"v":11500,"d":"11,500"}},{"$f":"SUM(tblExpenseCategory_04[10 月])","v":{"v":10250,"d":"10,250"}},{"$f":"SUM(tblExpenseCategory_04[11 月])","v":{"v":9250,"d":"9,250"}},{"$f":"SUM(tblExpenseCategory_04[12 月])","v":{"v":9250,"d":"9,250"}},{"$f":"SUM(tblExpenseCategory_04[年])","v":{"v":129350,"d":"129,350"}},{"$f":"SUM(tblExpenseCategory_04[平均])","v":{"v":10779.166666666666,"d":"10,779"}}]
[null,{"$f":"LOWER(预算!B39)","v":"孩子"},{"$f":"SUM(tblExpenseCategory_03[1 月])","v":{"v":23730,"d":"23,730"}},{"$f":"SUM(tblExpenseCategory_03[2 月])","v":{"v":5000,"d":"5,000"}},{"$f":"SUM(tblExpenseCategory_03[3 月])","v":{"v":3500,"d":"3,500"}},{"$f":"SUM(tblExpenseCategory_03[4 月])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_03[5 月])","v":{"v":3500,"d":"3,500"}},{"$f":"SUM(tblExpenseCategory_03[6 月])","v":{"v":4500,"d":"4,500"}},{"$f":"SUM(tblExpenseCategory_03[7 月])","v":{"v":2000,"d":"2,000"}},{"$f":"SUM(tblExpenseCategory_03[8 月])","v":{"v":5450,"d":"5,450"}},{"$f":"SUM(tblExpenseCategory_03[9 月])","v":{"v":3500,"d":"3,500"}},{"$f":"SUM(tblExpenseCategory_03[10 月])","v":{"v":3500,"d":"3,500"}},{"$f":"SUM(tblExpenseCategory_03[11 月])","v":{"v":2500,"d":"2,500"}},{"$f":"SUM(tblExpenseCategory_03[12 月])","v":{"v":3500,"d":"3,500"}},{"$f":"SUM(tblExpenseCategory_03[年])","v":{"v":63180,"d":"63,180"}},{"$f":"SUM(tblExpenseCategory_03[平均])","v":{"v":5265,"d":"5,265"}}]
[null,{"$f":"LOWER(预算!B30)","v":"日常生活"},{"$f":"SUM(tblExpenseCategory_02[1 月])","v":{"v":7950,"d":"7,950"}},{"$f":"SUM(tblExpenseCategory_02[2 月])","v":{"v":3750,"d":"3,750"}},{"$f":"SUM(tblExpenseCategory_02[3 月])","v":{"v":5500,"d":"5,500"}},{"$f":"SUM(tblExpenseCategory_02[4 月])","v":{"v":8250,"d":"8,250"}},{"$f":"SUM(tblExpenseCategory_02[5 月])","v":{"v":5000,"d":"5,000"}},{"$f":"SUM(tblExpenseCategory_02[6 月])","v":{"v":4500,"d":"4,500"}},{"$f":"SUM(tblExpenseCategory_02[7 月])","v":{"v":8750,"d":"8,750"}},{"$f":"SUM(tblExpenseCategory_02[8 月])","v":{"v":4750,"d":"4,750"}},{"$f":"SUM(tblExpenseCategory_02[9 月])","v":{"v":4000,"d":"4,000"}},{"$f":"SUM(tblExpenseCategory_02[10 月])","v":{"v":8250,"d":"8,250"}},{"$f":"SUM(tblExpenseCategory_02[11 月])","v":{"v":5750,"d":"5,750"}},{"$f":"SUM(tblExpenseCategory_02[12 月])","v":{"v":3750,"d":"3,750"}},{"$f":"SUM(tblExpenseCategory_02[年])","v":{"v":70200,"d":"70,200"}},{"$f":"SUM(tblExpenseCategory_02[平均])","v":{"v":5850,"d":"5,850"}}]
[null,{"$f":"LOWER(预算!B21)","v":"住宅"},{"$f":"SUM(tblExpenseCategory_01[1 月])","v":{"v":12080,"d":"12,080"}},{"$f":"SUM(tblExpenseCategory_01[2 月])","v":{"v":12080,"d":"12,080"}},{"$f":"SUM(tblExpenseCategory_01[3 月])","v":{"v":12330,"d":"12,330"}},{"$f":"SUM(tblExpenseCategory_01[4 月])","v":{"v":12080,"d":"12,080"}},{"$f":"SUM(tblExpenseCategory_01[5 月])","v":{"v":11580,"d":"11,580"}},{"$f":"SUM(tblExpenseCategory_01[6 月])","v":{"v":11830,"d":"11,830"}},{"$f":"SUM(tblExpenseCategory_01[7 月])","v":{"v":12830,"d":"12,830"}},{"$f":"SUM(tblExpenseCategory_01[8 月])","v":{"v":13330,"d":"13,330"}},{"$f":"SUM(tblExpenseCategory_01[9 月])","v":{"v":12080,"d":"12,080"}},{"$f":"SUM(tblExpenseCategory_01[10 月])","v":{"v":11580,"d":"11,580"}},{"$f":"SUM(tblExpenseCategory_01[11 月])","v":{"v":12080,"d":"12,080"}},{"$f":"SUM(tblExpenseCategory_01[12 月])","v":{"v":12080,"d":"12,080"}},{"$f":"SUM(tblExpenseCategory_01[年])","v":{"v":145960,"d":"145,960"}},{"$f":"SUM(tblExpenseCategory_01[平均])","v":{"v":12163.333333333334,"d":"12,163"}}]
[]
[]
[]
[]
[null,"累计现金流",{"$f":"SUM(预算!$C$8:C$8)","v":{"v":-37140,"d":"-37,140"}},{"$f":"SUM(预算!$C$8:D$8)","v":760},{"$f":"SUM(预算!$C$8:E$8)","v":{"v":-18570,"d":"-18,570"}},{"$f":"SUM(预算!$C$8:F$8)","v":{"v":-36700,"d":"-36,700"}},{"$f":"SUM(预算!$C$8:G$8)","v":{"v":-1380,"d":"-1,380"}},{"$f":"SUM(预算!$C$8:H$8)","v":{"v":-37310,"d":"-37,310"}},{"$f":"SUM(预算!$C$8:I$8)","v":{"v":-79740,"d":"-79,740"}},{"$f":"SUM(预算!$C$8:J$8)","v":{"v":-68270,"d":"-68,270"}},{"$f":"SUM(预算!$C$8:K$8)","v":{"v":-88100,"d":"-88,100"}},{"$f":"SUM(预算!$C$8:L$8)","v":{"v":-107530,"d":"-107,530"}},{"$f":"SUM(预算!$C$8:M$8)","v":{"v":-68110,"d":"-68,110"}},{"$f":"SUM(预算!$C$8:N$8)","v":{"v":-77690,"d":"-77,690"}},{"$f":"SUM(预算!$C$8:O$8)","v":{"v":-155380,"d":"-155,380"}}]
[]
[null,"年正现金流",{"$f":"IF(预算!C$8<0,NA(),IF(period+2<>COLUMN(预算!C$8),NA(),预算!C$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!D$8<0,NA(),IF(period+2<>COLUMN(预算!D$8),NA(),预算!D$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!E$8<0,NA(),IF(period+2<>COLUMN(预算!E$8),NA(),预算!E$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!F$8<0,NA(),IF(period+2<>COLUMN(预算!F$8),NA(),预算!F$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!G$8<0,NA(),IF(period+2<>COLUMN(预算!G$8),NA(),预算!G$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!H$8<0,NA(),IF(period+2<>COLUMN(预算!H$8),NA(),预算!H$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!I$8<0,NA(),IF(period+2<>COLUMN(预算!I$8),NA(),预算!I$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!J$8<0,NA(),IF(period+2<>COLUMN(预算!J$8),NA(),预算!J$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!K$8<0,NA(),IF(period+2<>COLUMN(预算!K$8),NA(),预算!K$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!L$8<0,NA(),IF(period+2<>COLUMN(预算!L$8),NA(),预算!L$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!M$8<0,NA(),IF(period+2<>COLUMN(预算!M$8),NA(),预算!M$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!N$8<0,NA(),IF(period+2<>COLUMN(预算!N$8),NA(),预算!N$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!O$8<0,NA(),IF(period+2<>COLUMN(预算!O$8),NA(),预算!O$8))","v":{"$error":"#N/A"}}]
[null,"年负现金流",{"$f":"IF(预算!C$8>=0,NA(),IF(period+2<>COLUMN(预算!C$8),NA(),预算!C$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!D$8>=0,NA(),IF(period+2<>COLUMN(预算!D$8),NA(),预算!D$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!E$8>=0,NA(),IF(period+2<>COLUMN(预算!E$8),NA(),预算!E$8))","v":{"v":-19330,"d":"-19,330"}},{"$f":"IF(预算!F$8>=0,NA(),IF(period+2<>COLUMN(预算!F$8),NA(),预算!F$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!G$8>=0,NA(),IF(period+2<>COLUMN(预算!G$8),NA(),预算!G$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!H$8>=0,NA(),IF(period+2<>COLUMN(预算!H$8),NA(),预算!H$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!I$8>=0,NA(),IF(period+2<>COLUMN(预算!I$8),NA(),预算!I$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!J$8>=0,NA(),IF(period+2<>COLUMN(预算!J$8),NA(),预算!J$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!K$8>=0,NA(),IF(period+2<>COLUMN(预算!K$8),NA(),预算!K$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!L$8>=0,NA(),IF(period+2<>COLUMN(预算!L$8),NA(),预算!L$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!M$8>=0,NA(),IF(period+2<>COLUMN(预算!M$8),NA(),预算!M$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!N$8>=0,NA(),IF(period+2<>COLUMN(预算!N$8),NA(),预算!N$8))","v":{"$error":"#N/A"}},{"$f":"IF(预算!O$8>=0,NA(),IF(period+2<>COLUMN(预算!O$8),NA(),预算!O$8))","v":{"$error":"#N/A"}}]
{"$rows_empty":7}
[null,{"$f":"LOWER(display_long_period)","v":"3 月"}]
[null,{"$f":"display_long_period & \"收入\"","v":"3 月收入"},{"$f":"INDEX(预算!$C$6:$P$6,,period)","v":{"v":40000,"d":"¥40,000"}}]
[null,{"$f":"display_long_period & \"支出: \" & TEXT(INDEX(预算!$C$7:$P$7,,period),\"$#,##0\")","v":"3 月支出: $59,330"},{"$f":"INDEX(预算!$C$7:$P$7,,period)","v":{"v":59330,"d":"¥59,330"}}]
[null,{"$f":"display_long_period & \"现金流\"","v":"3 月现金流"},{"$f":"ABS(INDEX(预算!$C$8:$P$8,,period))","v":{"v":19330,"d":"¥19,330"}},{"$f":"REPT(\"-\",INDEX(预算!$C$8:$P$8,,period)<0)","v":"-"}]