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

{"sheet":"ダッシュボード","index":0,"n_rows":16,"n_cols":8,"rows_kept":16}
[]
[null,"ダッシュボード",{"$nulls":4},"純資産の概要"," "]
{"$rows_empty":8}
[null,{"$f":"NetWorth","v":{"v":15960000,"d":"¥15,960,000"}},null,{"$f":"TotalAssets","v":{"v":38080000,"d":"¥38,080,000"}},null,null,{"$f":"TotalLiabilites","v":{"v":22120000,"d":"¥22,120,000"}}]
[null,"純資産",null,"資産合計",null,null,"負債合計"]
[{"$nulls":3},"現金",null,null,"無担保"]
[{"$nulls":3},"投資",null,null,"担保付き"]
[{"$nulls":3},"退職金"]
[{"$nulls":3},"個人資産"]

{"sheet":"資産","index":1,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[11,1,12,1],[13,1,14,1],[13,2,13,4],[13,6,13,8],[23,2,23,4],[23,6,23,8]]}
[]
[null,"資産",{"$nulls":5},"純資産の概要",null," "]
[]
[null,null," ","現金","金額",null," ","個人資産","金額"]
[{"$nulls":3},"手元現金",{"v":200000,"d":"200,000"},null,null,"主たる住居",{"v":23300000,"d":"23,300,000"}]
[{"$nulls":3},"当座預金",{"v":250000,"d":"250,000"},null,null,"別邸"]
[{"$nulls":3},"普通預金",{"v":400000,"d":"400,000"},null,null,"収集品"]
[{"$nulls":3},"マネー マーケット アカウント",{"v":330000,"d":"330,000"},null,null,"自動車",{"v":3200000,"d":"3,200,000"}]
[{"$nulls":3},"マネー マーケット ファンド アカウント",{"v":700000,"d":"700,000"},null,null,"家具",{"v":1000000,"d":"1,000,000"}]
[{"$nulls":3},"定期預金証書",{"$nulls":3},"毛皮や宝石"]
[{"$nulls":3},"米国 短期国債",{"$nulls":3},"その他の資産",{"v":150000,"d":"150,000"}]
[null,{"$f":"TotalAssets","v":{"v":38080000,"d":"¥38,080,000"}},null,"生命保険の解約払戻金",{"v":2450000,"d":"2,450,000"}]
[{"$nulls":3},"小計",{"$f":"SUBTOTAL(109,tblCash[金額])","v":{"v":4330000,"d":"4,330,000"}},null,null,"小計",{"$f":"SUBTOTAL(109,tblPersonal[金額])","v":{"v":27650000,"d":"27,650,000"}}]
[null,"資産合計"]
[]
[null,null," ","投資","金額",null," ","その他の資産","金額"]
[{"$nulls":3},"株式",{"v":1500000,"d":"1,500,000"},null,null,"年金"]
[{"$nulls":3},"債券",{"$nulls":3},"個人退職年金"]
[{"$nulls":3},"投資信託",{"$nulls":3},"自営業者年金"]
[{"$nulls":3},"パートナーシップ持ち分",{"$nulls":3},"401K",{"v":4600000,"d":"4,600,000"}]
[{"$nulls":3},"その他の投資",{"$nulls":3},"簡易小企業被用者年金"]
[{"$nulls":7},"従業員持ち株"]
[{"$nulls":3},"小計",{"$f":"SUBTOTAL(109,tblInvestments[金額])","v":{"v":1500000,"d":"1,500,000"}},null,null,"小計",{"$f":"SUBTOTAL(109,tblRetirement[金額])","v":{"v":4600000,"d":"4,600,000"}}]

{"sheet":"負債","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"負債",{"$nulls":5},"純資産の概要",null," "]
[]
[null,null," ","無担保","残高",null," ","担保付き","残高"]
[{"$nulls":3},"クレジット カード",{"v":120000,"d":"120,000"},null,null,"自動車ローン",{"v":1450000,"d":"1,450,000"}]
[{"$nulls":3},"掛売残高",{"v":300000,"d":"300,000"},null,null,"RV 車ローン"]
[{"$nulls":3},"学生ローン",{"v":1750000,"d":"1,750,000"},null,null,"家電ローン"]
[{"$nulls":3},"離婚扶助料",{"$nulls":3},"住宅ローン",{"v":14400000,"d":"14,400,000"}]
[{"$nulls":3},"養育費",{"$nulls":3},"住宅担保ローン",{"v":2100000,"d":"2,100,000"}]
[{"$nulls":3},"税金",{"v":800000,"d":"800,000"},null,null,"その他のローン"]
[{"$nulls":3},"その他",{"v":600000,"d":"600,000"},null,null,"税金",{"v":400000,"d":"400,000"}]
[null,{"$f":"TotalLiabilites","v":{"v":22120000,"d":"¥22,120,000"}},{"$nulls":5},"その他",{"v":200000,"d":"200,000"}]
[{"$nulls":3},"小計",{"$f":"SUBTOTAL(109,tblUnsecured[残高])","v":{"v":3570000,"d":"3,570,000"}},null,null,"小計",{"$f":"SUBTOTAL(109,tblSecured[残高])","v":{"v":18550000,"d":"18,550,000"}}]
[null,"負債合計"]

{"sheet":"計算","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"hidden":true}
[]
[null,"*** このシートは非表示にしてください ***"]
{"$rows_empty":8}
[null,"現金",{"$f":"SUM(tblCash[金額])","v":{"v":4330000,"d":"¥4,330,000"}}]
[null,{"$f":"tblInvestments[[#Headers],[投資]]","v":"投資"},{"$f":"SUM(tblInvestments[金額])","v":{"v":1500000,"d":"¥1,500,000"}}]
[null,{"$f":"tblRetirement[[#Headers],[その他の資産]]","v":"その他の資産"},{"$f":"SUM(tblRetirement[金額])","v":{"v":4600000,"d":"¥4,600,000"}}]
[null,"個人",{"$f":"SUM(tblPersonal[金額])","v":{"v":27650000,"d":"¥27,650,000"}}]
[null,"資産合計",{"$f":"SUM(tblCash[金額],tblInvestments[金額],tblRetirement[金額],tblPersonal[金額])","v":{"v":38080000,"d":"¥38,080,000"}}]
[]
[]
[null,{"$f":"tblUnsecured[[#Headers],[無担保]]","v":"無担保"},{"$f":"SUM(tblUnsecured[残高])","v":{"v":3570000,"d":"¥3,570,000"}}]
[null,{"$f":"tblSecured[[#Headers],[担保付き]]","v":"担保付き"},{"$f":"SUM(tblSecured[残高])","v":{"v":18550000,"d":"¥18,550,000"}}]
[null,"負債合計",{"$f":"SUM(tblUnsecured[残高],tblSecured[残高])","v":{"v":22120000,"d":"¥22,120,000"}}]
[]
[]
[null,"純資産",{"$f":"C15-C20","v":{"v":15960000,"d":"¥15,960,000"}}]