{"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"}]