{"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,"収支","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","現在までの合計","傾向"]
[null,"毎月の収支",{"$f":"tblIncome[[#Totals],[1 月]]-tblExpenses[[#Totals],[1 月]]","v":{"v":122000,"d":"¥122,000"}},{"$f":"tblIncome[[#Totals],[2 月]]-tblExpenses[[#Totals],[2 月]]","v":{"v":158700,"d":"¥158,700"}},{"$f":"tblIncome[[#Totals],[3 月]]-tblExpenses[[#Totals],[3 月]]","v":{"v":117400,"d":"¥117,400"}},{"$f":"tblIncome[[#Totals],[4 月]]-tblExpenses[[#Totals],[4 月]]","v":{"v":144500,"d":"¥144,500"}},{"$f":"tblIncome[[#Totals],[5 月]]-tblExpenses[[#Totals],[5 月]]","v":{"v":139100,"d":"¥139,100"}},{"$f":"tblIncome[[#Totals],[6 月]]-tblExpenses[[#Totals],[6 月]]","v":{"v":143400,"d":"¥143,400"}},{"$f":"tblIncome[[#Totals],[7 月]]-tblExpenses[[#Totals],[7 月]]","v":{"v":108500,"d":"¥108,500"}},{"$f":"tblIncome[[#Totals],[8 月]]-tblExpenses[[#Totals],[8 月]]","v":{"v":118100,"d":"¥118,100"}},{"$f":"tblIncome[[#Totals],[9 月]]-tblExpenses[[#Totals],[9 月]]","v":{"v":144500,"d":"¥144,500"}},{"$f":"tblIncome[[#Totals],[10 月]]-tblExpenses[[#Totals],[10 月]]","v":{"v":146600,"d":"¥146,600"}},{"$f":"tblIncome[[#Totals],[11 月]]-tblExpenses[[#Totals],[11 月]]","v":{"v":0,"d":"¥0"}},{"$f":"tblIncome[[#Totals],[12 月]]-tblExpenses[[#Totals],[12 月]]","v":{"v":0,"d":"¥0"}},{"$f":"tblIncome[[#Totals],[現在までの合計]]-tblExpenses[[#Totals],[現在までの合計]]","v":{"v":1342800,"d":"¥1,342,800"}}]
[]
[null,"収入の種類","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","現在までの合計","傾向"]
[null,"収入 1",{"v":400000,"d":"¥400,000"},{"v":441000,"d":"¥441,000"},{"v":401900,"d":"¥401,900"},{"v":426300,"d":"¥426,300"},{"v":412300,"d":"¥412,300"},{"v":430800,"d":"¥430,800"},{"v":416200,"d":"¥416,200"},{"v":416500,"d":"¥416,500"},{"v":424800,"d":"¥424,800"},{"v":432400,"d":"¥432,400"},null,null,{"$f":"SUM(tblIncome[[#This Row],[1 月]:[12 月]])","v":{"v":4202200,"d":"¥4,202,200"}}]
[null,"収入 2",{"v":27500,"d":"¥27,500"},{"v":29600,"d":"¥29,600"},{"v":25100,"d":"¥25,100"},{"v":26900,"d":"¥26,900"},{"v":25200,"d":"¥25,200"},{"v":25200,"d":"¥25,200"},{"v":26200,"d":"¥26,200"},{"v":25800,"d":"¥25,800"},{"v":29600,"d":"¥29,600"},{"v":27000,"d":"¥27,000"},null,null,{"$f":"SUM(tblIncome[[#This Row],[1 月]:[12 月]])","v":{"v":268100,"d":"¥268,100"}}]
[null,"その他の収入",{"v":50000,"d":"¥50,000"},{"v":50700,"d":"¥50,700"},{"v":55100,"d":"¥55,100"},{"v":55600,"d":"¥55,600"},{"v":58800,"d":"¥58,800"},{"v":53400,"d":"¥53,400"},{"v":53300,"d":"¥53,300"},{"v":58500,"d":"¥58,500"},{"v":56000,"d":"¥56,000"},{"v":52000,"d":"¥52,000"},null,null,{"$f":"SUM(tblIncome[[#This Row],[1 月]:[12 月]])","v":{"v":543400,"d":"¥543,400"}}]
[null,"総収入",{"$f":"SUBTOTAL(109,tblIncome[1 月])","v":{"v":477500,"d":"¥477,500"}},{"$f":"SUBTOTAL(109,tblIncome[2 月])","v":{"v":521300,"d":"¥521,300"}},{"$f":"SUBTOTAL(109,tblIncome[3 月])","v":{"v":482100,"d":"¥482,100"}},{"$f":"SUBTOTAL(109,tblIncome[4 月])","v":{"v":508800,"d":"¥508,800"}},{"$f":"SUBTOTAL(109,tblIncome[5 月])","v":{"v":496300,"d":"¥496,300"}},{"$f":"SUBTOTAL(109,tblIncome[6 月])","v":{"v":509400,"d":"¥509,400"}},{"$f":"SUBTOTAL(109,tblIncome[7 月])","v":{"v":495700,"d":"¥495,700"}},{"$f":"SUBTOTAL(109,tblIncome[8 月])","v":{"v":500800,"d":"¥500,800"}},{"$f":"SUBTOTAL(109,tblIncome[9 月])","v":{"v":510400,"d":"¥510,400"}},{"$f":"SUBTOTAL(109,tblIncome[10 月])","v":{"v":511400,"d":"¥511,400"}},{"$f":"SUBTOTAL(109,tblIncome[11 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,tblIncome[12 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,tblIncome[現在までの合計])","v":{"v":5013700,"d":"¥5,013,700"}}]
[]
[null,"支出","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","現在までの合計","傾向"]
[null,"住居費",{"v":150000,"d":"¥150,000"},{"v":150000,"d":"¥150,000"},{"v":150000,"d":"¥150,000"},{"v":150000,"d":"¥150,000"},{"v":150000,"d":"¥150,000"},{"v":150000,"d":"¥150,000"},{"v":150000,"d":"¥150,000"},{"v":150000,"d":"¥150,000"},{"v":150000,"d":"¥150,000"},{"v":150000,"d":"¥150,000"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":1500000,"d":"¥1,500,000"}}]
[null,"食料品",{"v":25000,"d":"¥25,000"},{"v":33100,"d":"¥33,100"},{"v":29900,"d":"¥29,900"},{"v":33300,"d":"¥33,300"},{"v":32400,"d":"¥32,400"},{"v":31300,"d":"¥31,300"},{"v":33800,"d":"¥33,800"},{"v":22500,"d":"¥22,500"},{"v":25800,"d":"¥25,800"},{"v":32200,"d":"¥32,200"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":299300,"d":"¥299,300"}}]
[null,"自動車ローン",{"v":34500,"d":"¥34,500"},{"v":34500,"d":"¥34,500"},{"v":34500,"d":"¥34,500"},{"v":34500,"d":"¥34,500"},{"v":34500,"d":"¥34,500"},{"v":34500,"d":"¥34,500"},{"v":34500,"d":"¥34,500"},{"v":34500,"d":"¥34,500"},{"v":34500,"d":"¥34,500"},{"v":34500,"d":"¥34,500"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":345000,"d":"¥345,000"}}]
[null,"保険料",{"v":12000,"d":"¥12,000"},{"v":12000,"d":"¥12,000"},{"v":12000,"d":"¥12,000"},{"v":12000,"d":"¥12,000"},{"v":12000,"d":"¥12,000"},{"v":12000,"d":"¥12,000"},{"v":12000,"d":"¥12,000"},{"v":12000,"d":"¥12,000"},{"v":12000,"d":"¥12,000"},{"v":12000,"d":"¥12,000"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":120000,"d":"¥120,000"}}]
[null,"自宅電話",{"v":5000,"d":"¥5,000"},{"v":5000,"d":"¥5,000"},{"v":5000,"d":"¥5,000"},{"v":5000,"d":"¥5,000"},{"v":5000,"d":"¥5,000"},{"v":5000,"d":"¥5,000"},{"v":5000,"d":"¥5,000"},{"v":5000,"d":"¥5,000"},{"v":5000,"d":"¥5,000"},{"v":5000,"d":"¥5,000"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":50000,"d":"¥50,000"}}]
[null,"携帯電話代",{"v":7200,"d":"¥7,200"},{"v":7000,"d":"¥7,000"},{"v":8000,"d":"¥8,000"},{"v":7000,"d":"¥7,000"},{"v":7500,"d":"¥7,500"},{"v":8000,"d":"¥8,000"},{"v":9000,"d":"¥9,000"},{"v":7300,"d":"¥7,300"},{"v":7500,"d":"¥7,500"},{"v":7000,"d":"¥7,000"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":75500,"d":"¥75,500"}}]
[null,"ケーブル TV",{"v":6000,"d":"¥6,000"},{"v":6300,"d":"¥6,300"},{"v":6500,"d":"¥6,500"},{"v":6000,"d":"¥6,000"},{"v":6500,"d":"¥6,500"},{"v":6000,"d":"¥6,000"},{"v":6300,"d":"¥6,300"},{"v":6000,"d":"¥6,000"},{"v":6300,"d":"¥6,300"},{"v":6000,"d":"¥6,000"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":61900,"d":"¥61,900"}}]
[null,"インターネット",{"v":4500,"d":"¥4,500"},{"v":4500,"d":"¥4,500"},{"v":4500,"d":"¥4,500"},{"v":4500,"d":"¥4,500"},{"v":4500,"d":"¥4,500"},{"v":4500,"d":"¥4,500"},{"v":4500,"d":"¥4,500"},{"v":4500,"d":"¥4,500"},{"v":4500,"d":"¥4,500"},{"v":4500,"d":"¥4,500"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":45000,"d":"¥45,000"}}]
[null,"電気",{"v":15500,"d":"¥15,500"},{"v":15500,"d":"¥15,500"},{"v":15800,"d":"¥15,800"},{"v":16000,"d":"¥16,000"},{"v":16500,"d":"¥16,500"},{"v":20000,"d":"¥20,000"},{"v":34000,"d":"¥34,000"},{"v":35000,"d":"¥35,000"},{"v":24000,"d":"¥24,000"},{"v":18000,"d":"¥18,000"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":210300,"d":"¥210,300"}}]
[null,"水道",{"v":3500,"d":"¥3,500"},{"v":3500,"d":"¥3,500"},{"v":3700,"d":"¥3,700"},{"v":3900,"d":"¥3,900"},{"v":4500,"d":"¥4,500"},{"v":4200,"d":"¥4,200"},{"v":4200,"d":"¥4,200"},{"v":3600,"d":"¥3,600"},{"v":3800,"d":"¥3,800"},{"v":4000,"d":"¥4,000"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":38900,"d":"¥38,900"}}]
[null,"ガス",{"v":5000,"d":"¥5,000"},{"v":4500,"d":"¥4,500"},{"v":4000,"d":"¥4,000"},{"v":4000,"d":"¥4,000"},{"v":4200,"d":"¥4,200"},{"v":5000,"d":"¥5,000"},{"v":5500,"d":"¥5,500"},{"v":4000,"d":"¥4,000"},{"v":4300,"d":"¥4,300"},{"v":3000,"d":"¥3,000"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":43500,"d":"¥43,500"}}]
[null,"娯楽費",{"v":12300,"d":"¥12,300"},{"v":9200,"d":"¥9,200"},{"v":5800,"d":"¥5,800"},{"v":13100,"d":"¥13,100"},{"v":4600,"d":"¥4,600"},{"v":10500,"d":"¥10,500"},{"v":8400,"d":"¥8,400"},{"v":10800,"d":"¥10,800"},{"v":13200,"d":"¥13,200"},{"v":13600,"d":"¥13,600"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":101500,"d":"¥101,500"}}]
[null,"教育費",{"v":55000,"d":"¥55,000"},{"v":55000,"d":"¥55,000"},{"v":55000,"d":"¥55,000"},{"v":55000,"d":"¥55,000"},{"v":55000,"d":"¥55,000"},{"v":55000,"d":"¥55,000"},{"v":55000,"d":"¥55,000"},{"v":55000,"d":"¥55,000"},{"v":55000,"d":"¥55,000"},{"v":55000,"d":"¥55,000"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":550000,"d":"¥550,000"}}]
[null,"貯蓄",{"v":20000,"d":"¥20,000"},{"v":22500,"d":"¥22,500"},{"v":30000,"d":"¥30,000"},{"v":20000,"d":"¥20,000"},{"v":20000,"d":"¥20,000"},{"v":20000,"d":"¥20,000"},{"v":25000,"d":"¥25,000"},{"v":32500,"d":"¥32,500"},{"v":20000,"d":"¥20,000"},{"v":20000,"d":"¥20,000"},null,null,{"$f":"SUM(tblExpenses[[#This Row],[1 月]:[12 月]])","v":{"v":230000,"d":"¥230,000"}}]
[null,"総支出",{"$f":"SUBTOTAL(109,tblExpenses[1 月])","v":{"v":355500,"d":"¥355,500"}},{"$f":"SUBTOTAL(109,tblExpenses[2 月])","v":{"v":362600,"d":"¥362,600"}},{"$f":"SUBTOTAL(109,tblExpenses[3 月])","v":{"v":364700,"d":"¥364,700"}},{"$f":"SUBTOTAL(109,tblExpenses[4 月])","v":{"v":364300,"d":"¥364,300"}},{"$f":"SUBTOTAL(109,tblExpenses[5 月])","v":{"v":357200,"d":"¥357,200"}},{"$f":"SUBTOTAL(109,tblExpenses[6 月])","v":{"v":366000,"d":"¥366,000"}},{"$f":"SUBTOTAL(109,tblExpenses[7 月])","v":{"v":387200,"d":"¥387,200"}},{"$f":"SUBTOTAL(109,tblExpenses[8 月])","v":{"v":382700,"d":"¥382,700"}},{"$f":"SUBTOTAL(109,tblExpenses[9 月])","v":{"v":365900,"d":"¥365,900"}},{"$f":"SUBTOTAL(109,tblExpenses[10 月])","v":{"v":364800,"d":"¥364,800"}},{"$f":"SUBTOTAL(109,tblExpenses[11 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,tblExpenses[12 月])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,tblExpenses[現在までの合計])","v":{"v":3670900,"d":"¥3,670,900"}}]