{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["個人純資産","資産","負債"],"not_rendered":{"charts":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"個人純資産","index":0,"n_rows":19,"n_cols":21,"rows_kept":19,"merged":[[0,2,0,9],[2,2,2,4],[3,2,3,4],[8,2,8,4]]}
[{"$nulls":12},"現金および現金同等物",{"$f":"SUMIF(TBL_Assets[カテゴリ],個人純資産!M1,TBL_Assets[価値])+ROW(M1)/10000","v":42500.0001},{"$f":"_xlfn.RANK.EQ(N1,$N$1:$N$5,0)","v":5},null,{"$f":"INDEX($M$1:$N$5,MATCH(5,$O$1:$O$5,0),1)","v":"現金および現金同等物"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(5,$O$1:$O$5,0),2),2)","v":42500},null,"総資産",{"$f":"SUM(TBL_Assets[価値])","v":1923500}]
[{"$nulls":12},"財産",{"$f":"SUMIF(TBL_Assets[カテゴリ],個人純資産!M2,TBL_Assets[価値])+ROW(M2)/10000","v":1205000.0002},{"$f":"_xlfn.RANK.EQ(N2,$N$1:$N$5,0)","v":1},null,{"$f":"INDEX($M$1:$N$5,MATCH(4,$O$1:$O$5,0),1)","v":"退職後の貯蓄"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(4,$O$1:$O$5,0),2),2)","v":98000},null,"負債合計",{"$f":"SUM(TBL_Debts[値])","v":652500}]
[null,null,"個人純資産",{"$nulls":3},"資産と負債",{"$nulls":5},"投資",{"$f":"SUMIF(TBL_Assets[カテゴリ],個人純資産!M3,TBL_Assets[価値])+ROW(M3)/10000","v":475000.0003},{"$f":"_xlfn.RANK.EQ(N3,$N$1:$N$5,0)","v":2},null,{"$f":"INDEX($M$1:$N$5,MATCH(3,$O$1:$O$5,0),1)","v":"生命保険"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(3,$O$1:$O$5,0),2),2)","v":103000}]
[null,null,{"$f":"E5-E7","v":{"v":1271000,"d":"¥1,271,000"}},{"$nulls":9},"退職後の貯蓄",{"$f":"SUMIF(TBL_Assets[カテゴリ],個人純資産!M4,TBL_Assets[価値])+ROW(M4)/10000","v":98000.0004},{"$f":"_xlfn.RANK.EQ(N4,$N$1:$N$5,0)","v":4},null,{"$f":"INDEX($M$1:$N$5,MATCH(2,$O$1:$O$5,0),1)","v":"投資"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(2,$O$1:$O$5,0),2),2)","v":475000}]
[{"$nulls":3},"総資産",{"$f":"SUM(TBL_Assets[価値])","v":{"v":1923500,"d":"¥1,923,500"}},{"$nulls":7},"生命保険",{"$f":"SUMIF(TBL_Assets[カテゴリ],個人純資産!M5,TBL_Assets[価値])+ROW(M5)/10000","v":103000.0005},{"$f":"_xlfn.RANK.EQ(N5,$N$1:$N$5,0)","v":3},null,{"$f":"INDEX($M$1:$N$5,MATCH(1,$O$1:$O$5,0),1)","v":"財産"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(1,$O$1:$O$5,0),2),2)","v":1205000}]
[]
[{"$nulls":3},"負債合計",{"$f":"SUM(TBL_Debts[値])","v":{"v":652500,"d":"¥652,500"}}]
[]
[null,null,"資産の概要"]
[]
[{"$nulls":7},{"$f":"Q5","v":"財産"},{"$f":"R5","v":{"v":1205000,"d":"¥1,205,000"}}]
[]
[{"$nulls":7},{"$f":"Q4","v":"投資"},{"$f":"R4","v":{"v":475000,"d":"¥475,000"}}]
[]
[{"$nulls":7},{"$f":"Q3","v":"生命保険"},{"$f":"R3","v":{"v":103000,"d":"¥103,000"}}]
[]
[{"$nulls":7},{"$f":"Q2","v":"退職後の貯蓄"},{"$f":"R2","v":{"v":98000,"d":"¥98,000"}}]
[]
[{"$nulls":7},{"$f":"Q1","v":"現金および現金同等物"},{"$f":"R1","v":{"v":42500,"d":"¥42,500"}}]

{"sheet":"資産","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[1,1,1,3]]}
[{"$nulls":4}," "]
[null,"資産"]
[null,"カテゴリ","項目","価値"]
[null,"財産","住宅",{"v":560000,"d":"¥560,000.00"}]
[null,"財産","その他",{"v":255000,"d":"¥255,000.00"}]
[null,"退職後の貯蓄","年金口座",{"v":98000,"d":"¥98,000.00"}]
[null,"投資","株式",{"v":53000,"d":"¥53,000.00"}]
[null,"投資","債券",{"v":25000,"d":"¥25,000.00"}]
[null,"投資","投資信託",{"v":33000,"d":"¥33,000.00"}]
[null,"投資","CD",{"v":74000,"d":"¥74,000.00"}]
[null,"投資","地金",{"v":20000,"d":"¥20,000.00"}]
[null,"投資","信託基金",{"v":250000,"d":"¥250,000.00"}]
[null,"生命保険","医療貯蓄口座",{"v":18000,"d":"¥18,000.00"}]
[null,"生命保険","生命保険証券の額面価格",{"v":85000,"d":"¥85,000.00"}]
[null,"投資","その他",{"v":20000,"d":"¥20,000.00"}]
[null,"現金および現金同等物","当座預金口座",{"v":35500,"d":"¥35,500.00"}]
[null,"現金および現金同等物","普通預金口座",{"v":5000,"d":"¥5,000.00"}]
[null,"現金および現金同等物","その他",{"v":2000,"d":"¥2,000.00"}]
[null,"財産","自動車",{"v":55000,"d":"¥55,000.00"}]
[null,"財産","その他の車両",{"v":85000,"d":"¥85,000.00"}]
[null,"財産","備品",{"v":100000,"d":"¥100,000.00"}]
[null,"財産","収集品",{"v":50000,"d":"¥50,000.00"}]
[null,"財産","宝石類",{"v":60000,"d":"¥60,000.00"}]
[null,"財産","その他の高級品",{"v":40000,"d":"¥40,000.00"}]

{"sheet":"負債","index":2,"n_rows":13,"n_cols":4,"rows_kept":13}
[{"$nulls":3}," "]
[null,"負債"]
[null,"カテゴリ","値"]
[null,"抵当",{"v":400000,"d":"¥400,000.00"}]
[null,"住宅担保ローン",{"v":50000,"d":"¥50,000.00"}]
[null,"自動車ローン",{"v":30000,"d":"¥30,000.00"}]
[null,"個人ローン",{"v":12500,"d":"¥12,500.00"}]
[null,"クレジット カード",{"v":65000,"d":"¥65,000.00"}]
[null,"学生ローン",{"v":10000,"d":"¥10,000.00"}]
[null,"投資ローン",{"v":20000,"d":"¥20,000.00"}]
[null,"生命保険ローン",{"v":5000,"d":"¥5,000.00"}]
[null,"その他の分割ローン",{"v":10000,"d":"¥10,000.00"}]
[null,"その他の負債",{"v":50000,"d":"¥50,000.00"}]