{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["個人用マネー管理ツール","月単位の概要","グラフ データ"],"not_rendered":{"charts":2,"defined_names":5,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"個人用マネー管理ツール","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[7,3,7,6],[19,1,20,1],[21,1,23,1]]}
["個人用マネー管理ツール"]
[]
[{"$nulls":3},"現金概要"]
[{"$nulls":3},"口座","開始現金","支出合計","現金残高"]
[{"$nulls":3},"当座",{"v":300000,"d":"300,000"},{"$f":"SUMIF(CashSpentTable[口座],\"=\" &CashSummaryTable[[#This Row],[口座]],CashSpentTable[金額])","v":{"v":47800,"d":"47,800"}},{"$f":"CashSummaryTable[[#This Row],[開始現金]]-CashSummaryTable[[#This Row],[支出合計]]","v":{"v":252200,"d":"252,200"}}]
[{"$nulls":3},"貯蓄",{"v":50000,"d":"50,000"},{"$f":"SUMIF(CashSpentTable[口座],\"=\" &CashSummaryTable[[#This Row],[口座]],CashSpentTable[金額])","v":{"v":45000,"d":"45,000"}},{"$f":"CashSummaryTable[[#This Row],[開始現金]]-CashSummaryTable[[#This Row],[支出合計]]","v":{"v":5000,"d":"5,000"}}]
[{"$nulls":3}," 合計 ",{"$f":"SUBTOTAL(109,CashSummaryTable[開始現金])","v":{"v":350000,"d":"350,000"}},{"$f":"SUBTOTAL(109,CashSummaryTable[支出合計])","v":{"v":92800,"d":"92,800"}},{"$f":"SUBTOTAL(109,CashSummaryTable[現金残高])","v":{"v":257200,"d":"257,200"}}]
[]
[{"$nulls":3},"使った現金"]
[{"$nulls":3},"日付","内容","金額","口座"]
[{"$nulls":3},"2012-01-04","ATM 引き出し",{"v":4000,"d":"4,000 "},"当座"]
[{"$nulls":3},"2012-01-05","ランチ",{"v":500,"d":"500 "},"当座"]
[{"$nulls":3},"2012-01-06","自動車ローン",{"v":23000,"d":"23,000 "},"貯蓄"]
[{"$nulls":3},"2012-02-03","電気代",{"v":7000,"d":"7,000 "},"当座"]
[{"$nulls":3},"2012-02-07","外食",{"v":5300,"d":"5,300 "},"当座"]
[{"$nulls":3},"2012-03-01","現金引き出し",{"v":10000,"d":"10,000 "},"貯蓄"]
[{"$nulls":3},"2012-03-06","自動車ローン",{"v":23000,"d":"23,000 "},"当座"]
[{"$nulls":3},"2012-04-06","電気代",{"v":7000,"d":"7,000 "},"貯蓄"]
[{"$nulls":3},"2012-04-20","ATM 引き出し",{"v":3000,"d":"3,000 "},"当座"]
[null,"現金残高:",null,"2012-05-03","ATM 引き出し",{"v":5000,"d":"5,000 "},"貯蓄"]
[{"$nulls":3},"2012-05-10","ATM 引き出し",{"v":3000,"d":"3,000 "},"当座"]
[null,{"$f":"CashSummaryTable[[#Totals],[現金残高]]/CashSummaryTable[[#Totals],[開始現金]]","v":{"v":0.7348571428571429,"d":"73%"}},null,"2012-05-15","ATM 引き出し",{"v":2000,"d":"2,000 "},"当座"]

{"sheet":"月単位の概要","index":1,"n_rows":30,"n_cols":5,"rows_kept":30}
[null,"月単位の概要"]
[null,"口座の概要"]
{"$rows_empty":17}
[null,"支出の概要"]
[null,"合計金額"]
[null,null,"貯蓄","当座","総計"]
[null,"1",{"v":23000,"d":"23,000"},{"v":4500,"d":"4,500"},{"v":27500,"d":"27,500"}]
[null,"2 ",null,{"v":12300,"d":"12,300"},{"v":12300,"d":"12,300"}]
[null,"3 ",{"v":10000,"d":"10,000"},{"v":23000,"d":"23,000"},{"v":33000,"d":"33,000"}]
[null,"現金引き出し",{"v":10000,"d":"10,000"},null,{"v":10000,"d":"10,000"}]
[null,"自動車ローン",null,{"v":23000,"d":"23,000"},{"v":23000,"d":"23,000"}]
[null,"4",{"v":7000,"d":"7,000"},{"v":3000,"d":"3,000"},{"v":10000,"d":"10,000"}]
[null,"5",{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":10000,"d":"10,000"}]
[null,"総計",{"v":45000,"d":"45,000"},{"v":47800,"d":"47,800"},{"v":92800,"d":"92,800"}]

{"sheet":"グラフ データ","index":2,"n_rows":10,"n_cols":4,"rows_kept":10}
["このピボットテーブルは、\"月単位の概要\" シートの \"口座の概要\" ピボットグラフのデータ ソースです"]
[]
["合計金額","列ラベル"]
["行ラベル","貯蓄","当座","総計"]
["1",{"v":23000,"d":"23,000"},{"v":4500,"d":"4,500"},{"v":27500,"d":"27,500"}]
["2",null,{"v":12300,"d":"12,300"},{"v":12300,"d":"12,300"}]
["3",{"v":10000,"d":"10,000"},{"v":23000,"d":"23,000"},{"v":33000,"d":"33,000"}]
["4",{"v":7000,"d":"7,000"},{"v":3000,"d":"3,000"},{"v":10000,"d":"10,000"}]
["5",{"v":5000,"d":"5,000"},{"v":5000,"d":"5,000"},{"v":10000,"d":"10,000"}]
["総計",{"v":45000,"d":"45,000"},{"v":47800,"d":"47,800"},{"v":92800,"d":"92,800"}]