{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["ダッシュボード","資産","負債","計算"],"not_rendered":{"charts":4,"images":6,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"ダッシュボード","index":0,"n_rows":18,"n_cols":8,"rows_kept":18}
[]
[null,"ダッシュボード",{"$nulls":4},"純資産の概要"," "]
{"$rows_empty":8}
[null,{"$f":"純資産","v":{"v":166600,"d":"¥166,600"}},null,{"$f":"総資産","v":{"v":387800,"d":"¥387,800"}},null,null,{"$f":"負債総額","v":{"v":221200,"d":"¥221,200"}}]
[null,"純資産",null,"合計資産",null,null,"負債総額"]
[{"$nulls":3}," 現金",null,null," 無担保"]
[{"$nulls":3}," 投資",null,null," 担保付き"]
[{"$nulls":3}," 退職"]
[{"$nulls":3}," 個人"]
[]
[{"$nulls":3},"資産の表示 >",null,null,"負債の表示 >"]

{"sheet":"資産","index":1,"n_rows":23,"n_cols":11,"rows_kept":23,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"資産",{"$nulls":6},"純資産の概要",null," "]
[]
[{"$nulls":3}," ","現金","価格",null," ","個人","価格"]
[{"$nulls":4},"手持ちの現金",{"v":2000,"d":"2,000"},null,null,"プリンシパル レジデンス",{"v":233000,"d":"233,000"}]
[{"$nulls":4},"当座預金口座",{"v":2500,"d":"2,500"},null,null,"セカンド レジデンス"]
[{"$nulls":4},"普通預金口座",{"v":4000,"d":"4,000"},null,null,"収集品"]
[{"$nulls":4},"マネー マーケット アカウント",{"v":3300,"d":"3,300"},null,null,"自動車",{"v":32000,"d":"32,000"}]
[{"$nulls":4},"定期預金証書",{"v":14000,"d":"14,000"},null,null,"家財道具",{"v":10000,"d":"10,000"}]
[{"$nulls":4},"米国債券",{"$nulls":3},"毛皮と宝石"]
[{"$nulls":4},"生命保険の現金価値",{"v":24500,"d":"24,500"},null,null,"その他の資産 1",{"v":1500,"d":"1,500"}]
[null,{"$f":"総資産","v":{"v":387800,"d":"¥387,800"}},null,null,"その他の現金",{"$nulls":3},"その他の資産 2"]
[{"$nulls":4},"小計",{"$f":"SUBTOTAL(109,現金テーブル[価格])","v":{"v":50300,"d":"50,300"}},null,null,"小計",{"$f":"SUBTOTAL(109,個人テーブル[価格])","v":{"v":276500,"d":"276,500"}}]
[null,"合計資産"]
[]
[{"$nulls":3}," ","投資","価格",null," ","退職","価格"]
[null,"負債の表示 >",null,null,"株式",{"v":15000,"d":"15,000"},null,null,"年金"]
[null,"< ダッシュボードの表示",null,null,"債券",{"$nulls":3},"IRA 口座"]
[{"$nulls":4},"投信投資",{"$nulls":3},"KEOGH 口座"]
[{"$nulls":4},"パートナーシップへの関心",{"$nulls":3},"401k",{"v":46000,"d":"46,000"}]
[{"$nulls":4},"その他の投資 1",{"$nulls":3},"9 月"]
[{"$nulls":4},"その他の投資 2",{"$nulls":3},"その他の退職"]
[{"$nulls":4},"小計",{"$f":"SUBTOTAL(109,投資テーブル[価格])","v":{"v":15000,"d":"15,000"}},null,null,"小計",{"$f":"SUBTOTAL(109,退職テーブル[価格])","v":{"v":46000,"d":"46,000"}}]

{"sheet":"負債","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"負債",{"$nulls":6},"純資産の概要",null," "]
[]
[{"$nulls":3}," ","無担保","借金",null," ","担保付き","借金"]
[{"$nulls":4},"クレジット カード",{"v":1200,"d":"1,200"},null,null,"オート ローン",{"v":14500,"d":"14,500"}]
[{"$nulls":4},"掛売口座",{"v":3000,"d":"3,000"},null,null,"REC 自動車ローン"]
[{"$nulls":4},"学生ローン",{"v":17500,"d":"17,500"},null,null,"家電ローン"]
[{"$nulls":4},"慰謝料",{"$nulls":3},"住宅ローン",{"v":144000,"d":"144,000"}]
[{"$nulls":4},"養育費",{"$nulls":3},"住宅担保ローン",{"v":21000,"d":"21,000"}]
[{"$nulls":4},"納税義務",{"v":8000,"d":"8,000"},null,null,"納税義務"]
[{"$nulls":4},"その他の無担保 1",{"v":6000,"d":"6,000"},null,null,"その他の担保付き 1",{"v":4000,"d":"4,000"}]
[null,{"$f":"負債総額","v":{"v":221200,"d":"¥221,200"}},null,null,"その他の無担保 2",{"$nulls":3},"その他の担保付き 2",{"v":2000,"d":"2,000"}]
[{"$nulls":4},"小計",{"$f":"SUBTOTAL(109,無担保テーブル[借金])","v":{"v":35700,"d":"35,700"}},null,null,"小計",{"$f":"SUBTOTAL(109,担保付きテーブル[借金])","v":{"v":185500,"d":"185,500"}}]
[null,"負債総額"]
[]
[]
[null,"< 資産の表示"]
[null,"< ダッシュボードの表示"]

{"sheet":"計算","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"hidden":true}
[]
[null,"*** このシートは非表示のままにしておきます ***"]
{"$rows_empty":8}
[null,{"$f":"現金テーブル[[#Headers],[現金]]","v":"現金"},{"$f":"SUM(現金テーブル[価格])","v":{"v":50300,"d":"¥50,300"}}]
[null,{"$f":"投資テーブル[[#Headers],[投資]]","v":"投資"},{"$f":"SUM(投資テーブル[価格])","v":{"v":15000,"d":"¥15,000"}}]
[null,{"$f":"退職テーブル[[#Headers],[退職]]","v":"退職"},{"$f":"SUM(退職テーブル[価格])","v":{"v":46000,"d":"¥46,000"}}]
[null,{"$f":"個人テーブル[[#Headers],[個人]]","v":"個人"},{"$f":"SUM(個人テーブル[価格])","v":{"v":276500,"d":"¥276,500"}}]
[null,"総資産",{"$f":"SUM(現金テーブル[価格],投資テーブル[価格],退職テーブル[価格],個人テーブル[価格])","v":{"v":387800,"d":"¥387,800"}}]
[]
[]
[null,{"$f":"無担保テーブル[[#Headers],[無担保]]","v":"無担保"},{"$f":"SUM(無担保テーブル[借金])","v":{"v":35700,"d":"¥35,700"}}]
[null,{"$f":"担保付きテーブル[[#Headers],[担保付き]]","v":"担保付き"},{"$f":"SUM(担保付きテーブル[借金])","v":{"v":185500,"d":"¥185,500"}}]
[null,"負債総額",{"$f":"SUM(無担保テーブル[借金],担保付きテーブル[借金])","v":{"v":221200,"d":"¥221,200"}}]
[]
[]
[null,"純資産",{"$f":"C15-C20","v":{"v":166600,"d":"¥166,600"}}]