{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["18 个时段预算"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"18 个时段预算","index":0,"n_rows":26,"n_cols":22,"rows_kept":26,"merged":[[0,1,1,4],[1,8,1,9],[12,1,12,20],[26,1,26,21]]}
[null,"公司预算"]
[{"$nulls":6},"开始日期","2011-01-01","时段长度（天）",null,14,"结束日期",{"$f":"TEXT(T4,\"yyyy/mm/dd\")","v":"2012/08/26"}]
[]
[null,null,{"$f":"UPPER(TEXT(H2,\"dd-mmm\"))","v":"01-JAN"},{"$f":"UPPER(TEXT(C4+DayInterval,\"dd-mmm\"))","v":"15-JAN"},{"$f":"UPPER(TEXT(D4+DayInterval,\"dd-mmm\"))","v":"29-JAN"},{"$f":"UPPER(TEXT(E4+DayInterval,\"dd-mmm\"))","v":"12-FEB"},{"$f":"UPPER(TEXT(F4+DayInterval,\"dd-mmm\"))","v":"26-FEB"},{"$f":"UPPER(TEXT(G4+DayInterval,\"dd-mmm\"))","v":"11-MAR"},{"$f":"UPPER(TEXT(H4+DayInterval,\"dd-mmm\"))","v":"25-MAR"},{"$f":"UPPER(TEXT(I4+DayInterval,\"dd-mmm\"))","v":"08-APR"},{"$f":"UPPER(TEXT(J4+DayInterval,\"dd-mmm\"))","v":"22-APR"},{"$f":"UPPER(TEXT(K4+DayInterval,\"dd-mmm\"))","v":"06-MAY"},{"$f":"UPPER(TEXT(L4+DayInterval,\"dd-mmm\"))","v":"20-MAY"},{"$f":"UPPER(TEXT(M4+DayInterval,\"dd-mmm\"))","v":"03-JUN"},{"$f":"UPPER(TEXT(N4+DayInterval,\"dd-mmm\"))","v":"17-JUN"},{"$f":"UPPER(TEXT(O4+DayInterval,\"dd-mmm\"))","v":"01-JUL"},{"$f":"UPPER(TEXT(P4+DayInterval,\"dd-mmm\"))","v":"15-JUL"},{"$f":"UPPER(TEXT(Q4+DayInterval,\"dd-mmm\"))","v":"29-JUL"},{"$f":"UPPER(TEXT(R4+DayInterval,\"dd-mmm\"))","v":"12-AUG"},{"$f":"UPPER(TEXT(S4+DayInterval,\"dd-mmm\"))","v":"26-AUG"}]
[null,null,{"$f":"UPPER(TEXT(H2,\"[$-C04]mmm-dd\"))","v":"一月-01"},{"$f":"UPPER(TEXT(C4+DayInterval,\"[$-C04]mmm-dd\"))","v":"一月-15"},"一月-29","二月-12","二月-26","三月-11","三月-25","四月-08","四月-22","五月-06","五月-20","六月-03","六月-17","七月-01","七月-15","七月-29","八月-12","八月-26","总计 ","趋势"]
[null,"净收入",{"$f":"IncomeTable[[#Totals],[Week 1]]-ExpensesTable[[#Totals],[Week 1]]","v":{"v":17500,"d":"¥17,500"}},{"$f":"IncomeTable[[#Totals],[Week 2]]-ExpensesTable[[#Totals],[Week 2]]","v":{"v":22360,"d":"¥22,360"}},{"$f":"IncomeTable[[#Totals],[Week 3]]-ExpensesTable[[#Totals],[Week 3]]","v":{"v":14420,"d":"¥14,420"}},{"$f":"IncomeTable[[#Totals],[Week 4]]-ExpensesTable[[#Totals],[Week 4]]","v":{"v":22530,"d":"¥22,530"}},{"$f":"IncomeTable[[#Totals],[Week 5]]-ExpensesTable[[#Totals],[Week 5]]","v":{"v":15330,"d":"¥15,330"}},{"$f":"IncomeTable[[#Totals],[Week 6]]-ExpensesTable[[#Totals],[Week 6]]","v":{"v":10860,"d":"¥10,860"}},{"$f":"IncomeTable[[#Totals],[Week 7]]-ExpensesTable[[#Totals],[Week 7]]","v":{"v":15940,"d":"¥15,940"}},{"$f":"IncomeTable[[#Totals],[Week 8]]-ExpensesTable[[#Totals],[Week 8]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 9]]-ExpensesTable[[#Totals],[Week 9]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 10]]-ExpensesTable[[#Totals],[Week 10]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 11]]-ExpensesTable[[#Totals],[Week 11]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 12]]-ExpensesTable[[#Totals],[Week 12]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 13]]-ExpensesTable[[#Totals],[Week 13]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 14]]-ExpensesTable[[#Totals],[Week 14]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 15]]-ExpensesTable[[#Totals],[Week 15]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 16]]-ExpensesTable[[#Totals],[Week 16]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 17]]-ExpensesTable[[#Totals],[Week 17]]","v":0},{"$f":"IncomeTable[[#Totals],[Week 18]]-ExpensesTable[[#Totals],[Week 18]]","v":0},{"$f":"IncomeTable[[#Totals],[Total]]-ExpensesTable[[#Totals],[Total]]","v":{"v":118940,"d":"¥118,940"}}]
[]
["收入"]
[null,"收入项目 1",{"v":30000,"d":"¥30,000"},{"v":35000,"d":"¥35,000"},{"v":29780,"d":"¥29,780"},{"v":33840,"d":"¥33,840"},{"v":28580,"d":"¥28,580"},{"v":28090,"d":"¥28,090"},{"v":32200,"d":"¥32,200"},{"$nulls":11},{"$f":"SUM(IncomeTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":217490,"d":"¥217,490"}}]
[null,"收入项目 2",{"v":11500,"d":"11,500"},{"v":12000,"d":"12,000"},{"v":11440,"d":"11,440"},{"v":14000,"d":"14,000"},{"v":13580,"d":"13,580"},{"v":11540,"d":"11,540"},{"v":12450,"d":"12,450"},{"$nulls":11},{"$f":"SUM(IncomeTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":86510,"d":"¥86,510"}}]
[null,"收入项目 3",{"v":3000,"d":"3,000"},{"v":3500,"d":"3,500"},{"v":3920,"d":"3,920"},{"v":3260,"d":"3,260"},{"v":3810,"d":"3,810"},{"v":3640,"d":"3,640"},{"v":3150,"d":"3,150"},{"$nulls":11},{"$f":"SUM(IncomeTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":24280,"d":"¥24,280"}}]
[null,"总收入",{"$f":"SUBTOTAL(109,IncomeTable[Week 1])","v":{"v":44500,"d":"¥44,500"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 2])","v":{"v":50500,"d":"¥50,500"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 3])","v":{"v":45140,"d":"¥45,140"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 4])","v":{"v":51100,"d":"¥51,100"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 5])","v":{"v":45970,"d":"¥45,970"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 6])","v":{"v":43270,"d":"¥43,270"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 7])","v":{"v":47800,"d":"¥47,800"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 8])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 9])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 10])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 11])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 12])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 13])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 14])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 15])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 16])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 17])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Week 18])","v":0},{"$f":"SUBTOTAL(109,IncomeTable[Total])","v":{"v":328280,"d":"¥328,280"}}]
[]
["支出"]
[null,"工资",{"v":15000,"d":"¥15,000"},{"v":15770,"d":"¥15,770"},{"v":18230,"d":"¥18,230"},{"v":15290,"d":"¥15,290"},{"v":17590,"d":"¥17,590"},{"v":19470,"d":"¥19,470"},{"v":18750,"d":"¥18,750"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":120100,"d":"¥120,100"}}]
[null,"租金",{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"v":10000,"d":"10,000"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":70000,"d":"¥70,000"}}]
[null,"电费",400,430,400,420,450,400,420,{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":2920,"d":"¥2,920"}}]
[null,"电话费",120,110,130,140,110,150,150,{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":910,"d":"¥910"}}]
[null,"网费",150,150,150,150,150,150,150,{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":1050,"d":"¥1,050"}}]
[null,"水费",110,100,130,100,130,100,120,{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":790,"d":"¥790"}}]
[null,"煤气费",230,270,260,270,220,290,210,{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":1750,"d":"¥1,750"}}]
[null,"垃圾清理费",40,40,40,40,40,40,40,{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":280,"d":"¥280"}}]
[null,"有线电视",100,100,100,100,100,100,100,{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":700,"d":"¥700"}}]
[null,"办公用品费",250,570,680,{"v":1460,"d":"1,460"},{"v":1250,"d":"1,250"},{"v":1110,"d":"1,110"},{"v":1320,"d":"1,320"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":6640,"d":"¥6,640"}}]
[null,"保险费",600,600,600,600,600,600,600,{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":4200,"d":"¥4,200"}}]
[null,"总支出",{"$f":"SUBTOTAL(109,ExpensesTable[Week 1])","v":{"v":27000,"d":"¥27,000.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 2])","v":{"v":28140,"d":"¥28,140.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 3])","v":{"v":30720,"d":"¥30,720.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 4])","v":{"v":28570,"d":"¥28,570.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 5])","v":{"v":30640,"d":"¥30,640.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 6])","v":{"v":32410,"d":"¥32,410.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 7])","v":{"v":31860,"d":"¥31,860.00"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 8])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 9])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 10])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 11])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 12])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 13])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 14])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 15])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 16])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 17])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Week 18])","v":0},{"$f":"SUBTOTAL(109,ExpensesTable[Total])","v":{"v":209340,"d":"¥209,340.00"}}]