{"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"},"29-JAN","12-FEB","26-FEB","11-MAR","25-MAR","08-APR","22-APR","06-MAY","20-MAY","03-JUN","17-JUN","01-JUL","15-JUL","29-JUL","12-AUG","26-AUG"]
[null,null,{"$f":"UPPER(TEXT(H2,\"[$-411]mmmmd日\"))","v":"1月1日"},{"$f":"TEXT(C4+DayInterval,\"[$-411]mmmmd日\")","v":"1月15日"},{"$f":"UPPER(TEXT(D4+DayInterval,\"[$-411]mmmmd日\"))","v":"1月29日"},{"$f":"UPPER(TEXT(E4+DayInterval,\"[$-411]mmmmd日\"))","v":"2月12日"},{"$f":"UPPER(TEXT(F4+DayInterval,\"[$-411]mmmmd日\"))","v":"2月26日"},{"$f":"UPPER(TEXT(G4+DayInterval,\"[$-411]mmmmd日\"))","v":"3月11日"},{"$f":"UPPER(TEXT(H4+DayInterval,\"[$-411]mmmmd日\"))","v":"3月25日"},{"$f":"UPPER(TEXT(I4+DayInterval,\"[$-411]mmmmd日\"))","v":"4月8日"},{"$f":"UPPER(TEXT(J4+DayInterval,\"[$-411]mmmmd日\"))","v":"4月22日"},{"$f":"UPPER(TEXT(K4+DayInterval,\"[$-411]mmmmd日\"))","v":"5月6日"},{"$f":"UPPER(TEXT(L4+DayInterval,\"[$-411]mmmmd日\"))","v":"5月20日"},{"$f":"UPPER(TEXT(M4+DayInterval,\"[$-411]mmmmd日\"))","v":"6月3日"},{"$f":"UPPER(TEXT(N4+DayInterval,\"[$-411]mmmmd日\"))","v":"6月17日"},{"$f":"UPPER(TEXT(O4+DayInterval,\"[$-411]mmmmd日\"))","v":"7月1日"},{"$f":"UPPER(TEXT(P4+DayInterval,\"[$-411]mmmmd日\"))","v":"7月15日"},{"$f":"UPPER(TEXT(Q4+DayInterval,\"[$-411]mmmmd日\"))","v":"7月29日"},{"$f":"UPPER(TEXT(R4+DayInterval,\"[$-411]mmmmd日\"))","v":"8月12日"},{"$f":"UPPER(TEXT(S4+DayInterval,\"[$-411]mmmmd日\"))","v":"8月26日"},"合計","傾向"]
[null,"純利益",{"$f":"IncomeTable[[#Totals],[Week 1]]-ExpensesTable[[#Totals],[Week 1]]","v":{"v":175000,"d":"¥175,000"}},{"$f":"IncomeTable[[#Totals],[Week 2]]-ExpensesTable[[#Totals],[Week 2]]","v":{"v":223600,"d":"¥223,600"}},{"$f":"IncomeTable[[#Totals],[Week 3]]-ExpensesTable[[#Totals],[Week 3]]","v":{"v":144200,"d":"¥144,200"}},{"$f":"IncomeTable[[#Totals],[Week 4]]-ExpensesTable[[#Totals],[Week 4]]","v":{"v":225300,"d":"¥225,300"}},{"$f":"IncomeTable[[#Totals],[Week 5]]-ExpensesTable[[#Totals],[Week 5]]","v":{"v":153300,"d":"¥153,300"}},{"$f":"IncomeTable[[#Totals],[Week 6]]-ExpensesTable[[#Totals],[Week 6]]","v":{"v":108600,"d":"¥108,600"}},{"$f":"IncomeTable[[#Totals],[Week 7]]-ExpensesTable[[#Totals],[Week 7]]","v":{"v":159400,"d":"¥159,400"}},{"$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 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":1189400,"d":"¥1,189,400"}}]
[]
["収入"]
[null,"収入項目 1",{"v":300000,"d":"¥300,000"},{"v":350000,"d":"¥350,000"},{"v":297800,"d":"¥297,800"},{"v":338400,"d":"¥338,400"},{"v":285800,"d":"¥285,800"},{"v":280900,"d":"¥280,900"},{"v":322000,"d":"¥322,000"},{"$nulls":11},{"$f":"SUM(IncomeTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":2174900,"d":"¥2,174,900"}}]
[null,"収入項目 2",{"v":115000,"d":"115,000 "},{"v":120000,"d":"120,000 "},{"v":114400,"d":"114,400 "},{"v":140000,"d":"140,000 "},{"v":135800,"d":"135,800 "},{"v":115400,"d":"115,400 "},{"v":124500,"d":"124,500 "},{"$nulls":11},{"$f":"SUM(IncomeTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":865100,"d":"865,100 "}}]
[null,"収入項目 3",{"v":30000,"d":"30,000 "},{"v":35000,"d":"35,000 "},{"v":39200,"d":"39,200 "},{"v":32600,"d":"32,600 "},{"v":38100,"d":"38,100 "},{"v":36400,"d":"36,400 "},{"v":31500,"d":"31,500 "},{"$nulls":11},{"$f":"SUM(IncomeTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":242800,"d":"242,800 "}}]
[null,"総収入",{"$f":"SUBTOTAL(109,IncomeTable[Week 1])","v":{"v":445000,"d":"¥445,000"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 2])","v":{"v":505000,"d":"¥505,000"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 3])","v":{"v":451400,"d":"¥451,400"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 4])","v":{"v":511000,"d":"¥511,000"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 5])","v":{"v":459700,"d":"¥459,700"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 6])","v":{"v":432700,"d":"¥432,700"}},{"$f":"SUBTOTAL(109,IncomeTable[Week 7])","v":{"v":478000,"d":"¥478,000"}},{"$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":3282800,"d":"¥3,282,800"}}]
[]
["支出"]
[null,"給与",{"v":150000,"d":"¥150,000"},{"v":157700,"d":"¥157,700"},{"v":182300,"d":"¥182,300"},{"v":152900,"d":"¥152,900"},{"v":175900,"d":"¥175,900"},{"v":194700,"d":"¥194,700"},{"v":187500,"d":"¥187,500"},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":1201000,"d":"¥1,201,000"}}]
[null,"賃借料",{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":700000,"d":"700,000 "}}]
[null,"電気",{"v":4000,"d":"4,000 "},{"v":4300,"d":"4,300 "},{"v":4000,"d":"4,000 "},{"v":4200,"d":"4,200 "},{"v":4500,"d":"4,500 "},{"v":4000,"d":"4,000 "},{"v":4200,"d":"4,200 "},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":29200,"d":"29,200 "}}]
[null,"電話",{"v":1200,"d":"1,200 "},{"v":1100,"d":"1,100 "},{"v":1300,"d":"1,300 "},{"v":1400,"d":"1,400 "},{"v":1100,"d":"1,100 "},{"v":1500,"d":"1,500 "},{"v":1500,"d":"1,500 "},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":9100,"d":"9,100 "}}]
[null,"インターネット",{"v":1500,"d":"1,500 "},{"v":1500,"d":"1,500 "},{"v":1500,"d":"1,500 "},{"v":1500,"d":"1,500 "},{"v":1500,"d":"1,500 "},{"v":1500,"d":"1,500 "},{"v":1500,"d":"1,500 "},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":10500,"d":"10,500 "}}]
[null,"水道",{"v":1100,"d":"1,100 "},{"v":1000,"d":"1,000 "},{"v":1300,"d":"1,300 "},{"v":1000,"d":"1,000 "},{"v":1300,"d":"1,300 "},{"v":1000,"d":"1,000 "},{"v":1200,"d":"1,200 "},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":7900,"d":"7,900 "}}]
[null,"ガス",{"v":2300,"d":"2,300 "},{"v":2700,"d":"2,700 "},{"v":2600,"d":"2,600 "},{"v":2700,"d":"2,700 "},{"v":2200,"d":"2,200 "},{"v":2900,"d":"2,900 "},{"v":2100,"d":"2,100 "},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":17500,"d":"17,500 "}}]
[null,"廃棄物の撤去",{"v":400,"d":"400 "},{"v":400,"d":"400 "},{"v":400,"d":"400 "},{"v":400,"d":"400 "},{"v":400,"d":"400 "},{"v":400,"d":"400 "},{"v":400,"d":"400 "},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":2800,"d":"2,800 "}}]
[null,"ケーブル TV",{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":7000,"d":"7,000 "}}]
[null,"事務用品",{"v":2500,"d":"2,500 "},{"v":5700,"d":"5,700 "},{"v":6800,"d":"6,800 "},{"v":14600,"d":"14,600 "},{"v":12500,"d":"12,500 "},{"v":11100,"d":"11,100 "},{"v":13200,"d":"13,200 "},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":66400,"d":"66,400 "}}]
[null,"保険",{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"$nulls":11},{"$f":"SUM(ExpensesTable[[#This Row],[Week 1]:[Week 18]])","v":{"v":42000,"d":"42,000 "}}]
[null,"総支出",{"$f":"SUBTOTAL(109,ExpensesTable[Week 1])","v":{"v":270000,"d":"¥270,000"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 2])","v":{"v":281400,"d":"¥281,400"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 3])","v":{"v":307200,"d":"¥307,200"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 4])","v":{"v":285700,"d":"¥285,700"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 5])","v":{"v":306400,"d":"¥306,400"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 6])","v":{"v":324100,"d":"¥324,100"}},{"$f":"SUBTOTAL(109,ExpensesTable[Week 7])","v":{"v":318600,"d":"¥318,600"}},{"$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":2093400,"d":"¥2,093,400"}}]