{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["家庭预算"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"家庭预算","index":0,"n_rows":28,"n_cols":16,"rows_kept":28,"merged":[[11,1,11,15]]}
[null,"史美萍一家预算"]
[null,"年：",2013]
[]
[null,"可用现金","一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月","年初至今总计","趋势"]
[null,"每月现金",{"$f":"tblIncome[[#Totals],[一月]]-tblExpenses[[#Totals],[一月]]","v":{"v":12200,"d":"¥12,200.00"}},{"$f":"tblIncome[[#Totals],[二月]]-tblExpenses[[#Totals],[二月]]","v":{"v":15870,"d":"¥15,870.00"}},{"$f":"tblIncome[[#Totals],[三月]]-tblExpenses[[#Totals],[三月]]","v":{"v":11740,"d":"¥11,740.00"}},{"$f":"tblIncome[[#Totals],[四月]]-tblExpenses[[#Totals],[四月]]","v":{"v":14450,"d":"¥14,450.00"}},{"$f":"tblIncome[[#Totals],[五月]]-tblExpenses[[#Totals],[五月]]","v":{"v":13910,"d":"¥13,910.00"}},{"$f":"tblIncome[[#Totals],[六月]]-tblExpenses[[#Totals],[六月]]","v":{"v":14340,"d":"¥14,340.00"}},{"$f":"tblIncome[[#Totals],[七月]]-tblExpenses[[#Totals],[七月]]","v":{"v":10850,"d":"¥10,850.00"}},{"$f":"tblIncome[[#Totals],[八月]]-tblExpenses[[#Totals],[八月]]","v":{"v":11810,"d":"¥11,810.00"}},{"$f":"tblIncome[[#Totals],[九月]]-tblExpenses[[#Totals],[九月]]","v":{"v":14450,"d":"¥14,450.00"}},{"$f":"tblIncome[[#Totals],[十月]]-tblExpenses[[#Totals],[十月]]","v":{"v":14660,"d":"¥14,660.00"}},{"$f":"tblIncome[[#Totals],[十一月]]-tblExpenses[[#Totals],[十一月]]","v":{"v":0,"d":"¥0.00"}},{"$f":"tblIncome[[#Totals],[十二月]]-tblExpenses[[#Totals],[十二月]]","v":{"v":0,"d":"¥0.00"}},{"$f":"tblIncome[[#Totals],[年初至今总计]]-tblExpenses[[#Totals],[年初至今总计]]","v":{"v":134280,"d":"¥134,280.00"}}]
[]
[null,"收入类型","一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月","年初至今总计","趋势"]
[null,"收入 1",{"v":40000,"d":"¥40,000.00"},{"v":44100,"d":"¥44,100.00"},{"v":40190,"d":"¥40,190.00"},{"v":42630,"d":"¥42,630.00"},{"v":41230,"d":"¥41,230.00"},{"v":43080,"d":"¥43,080.00"},{"v":41620,"d":"¥41,620.00"},{"v":41650,"d":"¥41,650.00"},{"v":42480,"d":"¥42,480.00"},{"v":43240,"d":"¥43,240.00"},null,null,{"$f":"SUM(tblIncome[[#This Row],[一月]:[十二月]])","v":{"v":420220,"d":"¥420,220.00"}}]
[null,"收入 2",{"v":2750,"d":"¥2,750.00"},{"v":2960,"d":"¥2,960.00"},{"v":2510,"d":"¥2,510.00"},{"v":2690,"d":"¥2,690.00"},{"v":2520,"d":"¥2,520.00"},{"v":2520,"d":"¥2,520.00"},{"v":2620,"d":"¥2,620.00"},{"v":2580,"d":"¥2,580.00"},{"v":2960,"d":"¥2,960.00"},{"v":2700,"d":"¥2,700.00"},null,null,{"$f":"SUM(tblIncome[[#This Row],[一月]:[十二月]])","v":{"v":26810,"d":"¥26,810.00"}}]
[null,"其他收入",{"v":5000,"d":"¥5,000.00"},{"v":5070,"d":"¥5,070.00"},{"v":5510,"d":"¥5,510.00"},{"v":5560,"d":"¥5,560.00"},{"v":5880,"d":"¥5,880.00"},{"v":5340,"d":"¥5,340.00"},{"v":5330,"d":"¥5,330.00"},{"v":5850,"d":"¥5,850.00"},{"v":5600,"d":"¥5,600.00"},{"v":5200,"d":"¥5,200.00"},null,null,{"$f":"SUM(tblIncome[[#This Row],[一月]:[十二月]])","v":{"v":54340,"d":"¥54,340.00"}}]
[null,"总收入",{"$f":"SUBTOTAL(109,tblIncome[一月])","v":{"v":47750,"d":"¥47,750.00"}},{"$f":"SUBTOTAL(109,tblIncome[二月])","v":{"v":52130,"d":"¥52,130.00"}},{"$f":"SUBTOTAL(109,tblIncome[三月])","v":{"v":48210,"d":"¥48,210.00"}},{"$f":"SUBTOTAL(109,tblIncome[四月])","v":{"v":50880,"d":"¥50,880.00"}},{"$f":"SUBTOTAL(109,tblIncome[五月])","v":{"v":49630,"d":"¥49,630.00"}},{"$f":"SUBTOTAL(109,tblIncome[六月])","v":{"v":50940,"d":"¥50,940.00"}},{"$f":"SUBTOTAL(109,tblIncome[七月])","v":{"v":49570,"d":"¥49,570.00"}},{"$f":"SUBTOTAL(109,tblIncome[八月])","v":{"v":50080,"d":"¥50,080.00"}},{"$f":"SUBTOTAL(109,tblIncome[九月])","v":{"v":51040,"d":"¥51,040.00"}},{"$f":"SUBTOTAL(109,tblIncome[十月])","v":{"v":51140,"d":"¥51,140.00"}},{"$f":"SUBTOTAL(109,tblIncome[十一月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,tblIncome[十二月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,tblIncome[年初至今总计])","v":{"v":501370,"d":"¥501,370.00"}}]
[]
[null,"支出","一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月","年初至今总计","趋势"]
[null,"住房",{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"},{"v":15000,"d":"¥15,000.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":150000,"d":"¥150,000.00"}}]
[null,"日用杂货",{"v":2500,"d":"¥2,500.00"},{"v":3310,"d":"¥3,310.00"},{"v":2990,"d":"¥2,990.00"},{"v":3330,"d":"¥3,330.00"},{"v":3240,"d":"¥3,240.00"},{"v":3130,"d":"¥3,130.00"},{"v":3380,"d":"¥3,380.00"},{"v":2250,"d":"¥2,250.00"},{"v":2580,"d":"¥2,580.00"},{"v":3220,"d":"¥3,220.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":29930,"d":"¥29,930.00"}}]
[null,"车贷",{"v":3450,"d":"¥3,450.00"},{"v":3450,"d":"¥3,450.00"},{"v":3450,"d":"¥3,450.00"},{"v":3450,"d":"¥3,450.00"},{"v":3450,"d":"¥3,450.00"},{"v":3450,"d":"¥3,450.00"},{"v":3450,"d":"¥3,450.00"},{"v":3450,"d":"¥3,450.00"},{"v":3450,"d":"¥3,450.00"},{"v":3450,"d":"¥3,450.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":34500,"d":"¥34,500.00"}}]
[null,"保险",{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},{"v":1200,"d":"¥1,200.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":12000,"d":"¥12,000.00"}}]
[null,"家庭电话",{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},{"v":500,"d":"¥500.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":5000,"d":"¥5,000.00"}}]
[null,"移动电话",{"v":720,"d":"¥720.00"},{"v":700,"d":"¥700.00"},{"v":800,"d":"¥800.00"},{"v":700,"d":"¥700.00"},{"v":750,"d":"¥750.00"},{"v":800,"d":"¥800.00"},{"v":900,"d":"¥900.00"},{"v":730,"d":"¥730.00"},{"v":750,"d":"¥750.00"},{"v":700,"d":"¥700.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":7550,"d":"¥7,550.00"}}]
[null,"有线电视",{"v":600,"d":"¥600.00"},{"v":630,"d":"¥630.00"},{"v":650,"d":"¥650.00"},{"v":600,"d":"¥600.00"},{"v":650,"d":"¥650.00"},{"v":600,"d":"¥600.00"},{"v":630,"d":"¥630.00"},{"v":600,"d":"¥600.00"},{"v":630,"d":"¥630.00"},{"v":600,"d":"¥600.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":6190,"d":"¥6,190.00"}}]
[null,"网费",{"v":450,"d":"¥450.00"},{"v":450,"d":"¥450.00"},{"v":450,"d":"¥450.00"},{"v":450,"d":"¥450.00"},{"v":450,"d":"¥450.00"},{"v":450,"d":"¥450.00"},{"v":450,"d":"¥450.00"},{"v":450,"d":"¥450.00"},{"v":450,"d":"¥450.00"},{"v":450,"d":"¥450.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":4500,"d":"¥4,500.00"}}]
[null,"电费",{"v":1550,"d":"¥1,550.00"},{"v":1550,"d":"¥1,550.00"},{"v":1580,"d":"¥1,580.00"},{"v":1600,"d":"¥1,600.00"},{"v":1650,"d":"¥1,650.00"},{"v":2000,"d":"¥2,000.00"},{"v":3400,"d":"¥3,400.00"},{"v":3500,"d":"¥3,500.00"},{"v":2400,"d":"¥2,400.00"},{"v":1800,"d":"¥1,800.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":21030,"d":"¥21,030.00"}}]
[null,"水费",{"v":350,"d":"¥350.00"},{"v":350,"d":"¥350.00"},{"v":370,"d":"¥370.00"},{"v":390,"d":"¥390.00"},{"v":450,"d":"¥450.00"},{"v":420,"d":"¥420.00"},{"v":420,"d":"¥420.00"},{"v":360,"d":"¥360.00"},{"v":380,"d":"¥380.00"},{"v":400,"d":"¥400.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":3890,"d":"¥3,890.00"}}]
[null,"燃气费",{"v":500,"d":"¥500.00"},{"v":450,"d":"¥450.00"},{"v":400,"d":"¥400.00"},{"v":400,"d":"¥400.00"},{"v":420,"d":"¥420.00"},{"v":500,"d":"¥500.00"},{"v":550,"d":"¥550.00"},{"v":400,"d":"¥400.00"},{"v":430,"d":"¥430.00"},{"v":300,"d":"¥300.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":4350,"d":"¥4,350.00"}}]
[null,"娱乐",{"v":1230,"d":"¥1,230.00"},{"v":920,"d":"¥920.00"},{"v":580,"d":"¥580.00"},{"v":1310,"d":"¥1,310.00"},{"v":460,"d":"¥460.00"},{"v":1050,"d":"¥1,050.00"},{"v":840,"d":"¥840.00"},{"v":1080,"d":"¥1,080.00"},{"v":1320,"d":"¥1,320.00"},{"v":1360,"d":"¥1,360.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":10150,"d":"¥10,150.00"}}]
[null,"学费",{"v":5500,"d":"¥5,500.00"},{"v":5500,"d":"¥5,500.00"},{"v":5500,"d":"¥5,500.00"},{"v":5500,"d":"¥5,500.00"},{"v":5500,"d":"¥5,500.00"},{"v":5500,"d":"¥5,500.00"},{"v":5500,"d":"¥5,500.00"},{"v":5500,"d":"¥5,500.00"},{"v":5500,"d":"¥5,500.00"},{"v":5500,"d":"¥5,500.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":55000,"d":"¥55,000.00"}}]
[null,"储蓄",{"v":2000,"d":"¥2,000.00"},{"v":2250,"d":"¥2,250.00"},{"v":3000,"d":"¥3,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},{"v":2500,"d":"¥2,500.00"},{"v":3250,"d":"¥3,250.00"},{"v":2000,"d":"¥2,000.00"},{"v":2000,"d":"¥2,000.00"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[一月]:[十二月]])","v":{"v":23000,"d":"¥23,000.00"}}]
[null,"总支出",{"$f":"SUBTOTAL(109,tblExpenses[一月])","v":{"v":35550,"d":"¥35,550.00"}},{"$f":"SUBTOTAL(109,tblExpenses[二月])","v":{"v":36260,"d":"¥36,260.00"}},{"$f":"SUBTOTAL(109,tblExpenses[三月])","v":{"v":36470,"d":"¥36,470.00"}},{"$f":"SUBTOTAL(109,tblExpenses[四月])","v":{"v":36430,"d":"¥36,430.00"}},{"$f":"SUBTOTAL(109,tblExpenses[五月])","v":{"v":35720,"d":"¥35,720.00"}},{"$f":"SUBTOTAL(109,tblExpenses[六月])","v":{"v":36600,"d":"¥36,600.00"}},{"$f":"SUBTOTAL(109,tblExpenses[七月])","v":{"v":38720,"d":"¥38,720.00"}},{"$f":"SUBTOTAL(109,tblExpenses[八月])","v":{"v":38270,"d":"¥38,270.00"}},{"$f":"SUBTOTAL(109,tblExpenses[九月])","v":{"v":36590,"d":"¥36,590.00"}},{"$f":"SUBTOTAL(109,tblExpenses[十月])","v":{"v":36480,"d":"¥36,480.00"}},{"$f":"SUBTOTAL(109,tblExpenses[十一月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,tblExpenses[十二月])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,tblExpenses[年初至今总计])","v":{"v":367090,"d":"¥367,090.00"}}]