{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["個人淨值","資產","債務"],"not_rendered":{"charts":2,"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"個人淨值","index":0,"n_rows":21,"n_cols":25,"rows_kept":21,"merged":[[3,2,4,7]]}
[{"$nulls":14}," "]
[{"$nulls":16},"現金和現金等價物",{"$f":"SUMIF(TBL_資產[類別],個人淨值!Q2,TBL_資產[價值])+ROW(Q2)/10000","v":42500.0002},{"$f":"_xlfn.RANK.EQ(R2,$R$2:$R$6,0)","v":5},null,{"$f":"INDEX($Q$2:$R$6,MATCH(5,$S$2:$S$6,0),1)","v":"現金和現金等價物"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(5,$S$2:$S$6,0),2),2)","v":42500},null,"總資產",{"$f":"SUM(TBL_資產[價值])","v":1923500}]
[null,null," 個人淨值",{"$nulls":13},"財產",{"$f":"SUMIF(TBL_資產[類別],個人淨值!Q3,TBL_資產[價值])+ROW(Q3)/10000","v":1205000.0003},{"$f":"_xlfn.RANK.EQ(R3,$R$2:$R$6,0)","v":1},null,{"$f":"INDEX($Q$2:$R$6,MATCH(4,$S$2:$S$6,0),1)","v":"退休金"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(4,$S$2:$S$6,0),2),2)","v":98000},null,"總債務",{"$f":"SUM(TBL_債務[價值])","v":652500}]
[null,null,{"$f":"F6-F8","v":{"v":1271000,"d":"NT$1,271,000"}},{"$nulls":6},"資產與債務",{"$nulls":6},"投資",{"$f":"SUMIF(TBL_資產[類別],個人淨值!Q4,TBL_資產[價值])+ROW(Q4)/10000","v":475000.0004},{"$f":"_xlfn.RANK.EQ(R4,$R$2:$R$6,0)","v":2},null,{"$f":"INDEX($Q$2:$R$6,MATCH(3,$S$2:$S$6,0),1)","v":"壽險"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(3,$S$2:$S$6,0),2),2)","v":103000}]
[{"$nulls":16},"退休金",{"$f":"SUMIF(TBL_資產[類別],個人淨值!Q5,TBL_資產[價值])+ROW(Q5)/10000","v":98000.0005},{"$f":"_xlfn.RANK.EQ(R5,$R$2:$R$6,0)","v":4},null,{"$f":"INDEX($Q$2:$R$6,MATCH(2,$S$2:$S$6,0),1)","v":"投資"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(2,$S$2:$S$6,0),2),2)","v":475000}]
[{"$nulls":4},"總資產",{"$f":"SUM(TBL_資產[價值])","v":{"v":1923500,"d":"NT$1,923,500"}},{"$nulls":10},"壽險",{"$f":"SUMIF(TBL_資產[類別],個人淨值!Q6,TBL_資產[價值])+ROW(Q6)/10000","v":103000.0006},{"$f":"_xlfn.RANK.EQ(R6,$R$2:$R$6,0)","v":3},null,{"$f":"INDEX($Q$2:$R$6,MATCH(1,$S$2:$S$6,0),1)","v":"財產"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(1,$S$2:$S$6,0),2),2)","v":1205000}]
[]
[{"$nulls":4},"總債務",{"$f":"SUM(TBL_債務[價值])","v":{"v":652500,"d":"NT$652,500"}}]
[]
[]
[]
[{"$nulls":3},"資產摘要"]
[{"$nulls":10},{"$f":"U6","v":"財產"},{"$f":"V6","v":{"v":1205000,"d":"NT$1,205,000"}}]
[]
[{"$nulls":10},{"$f":"U5","v":"投資"},{"$f":"V5","v":{"v":475000,"d":"NT$475,000"}}]
[]
[{"$nulls":10},{"$f":"U4","v":"壽險"},{"$f":"V4","v":{"v":103000,"d":"NT$103,000"}}]
[]
[{"$nulls":10},{"$f":"U3","v":"退休金"},{"$f":"V3","v":{"v":98000,"d":"NT$98,000"}}]
[]
[{"$nulls":10},{"$f":"U2","v":"現金和現金等價物"},{"$f":"V2","v":{"v":42500,"d":"NT$42,500"}}]

{"sheet":"資產","index":1,"n_rows":25,"n_cols":5,"rows_kept":25}
[{"$nulls":4}," "]
[null,"資產"]
[]
[null,"類別","項目","價值"]
[null,"財產","住宅",{"v":560000,"d":"NT$560,000.00"}]
[null,"財產","其他",{"v":255000,"d":"NT$255,000.00"}]
[null,"退休金","退休帳戶",{"v":98000,"d":"NT$98,000.00"}]
[null,"投資","股票",{"v":53000,"d":"NT$53,000.00"}]
[null,"投資","債券",{"v":25000,"d":"NT$25,000.00"}]
[null,"投資","共同基金",{"v":33000,"d":"NT$33,000.00"}]
[null,"投資","定存單",{"v":74000,"d":"NT$74,000.00"}]
[null,"投資","金銀條塊",{"v":20000,"d":"NT$20,000.00"}]
[null,"投資","信託基金",{"v":250000,"d":"NT$250,000.00"}]
[null,"壽險","健康儲蓄帳戶",{"v":18000,"d":"NT$18,000.00"}]
[null,"壽險","人壽保險保單面值",{"v":85000,"d":"NT$85,000.00"}]
[null,"投資","其他",{"v":20000,"d":"NT$20,000.00"}]
[null,"現金和現金等價物","支票存款帳戶",{"v":35500,"d":"NT$35,500.00"}]
[null,"現金和現金等價物","儲蓄帳戶",{"v":5000,"d":"NT$5,000.00"}]
[null,"現金和現金等價物","其他",{"v":2000,"d":"NT$2,000.00"}]
[null,"財產","汽車",{"v":55000,"d":"NT$55,000.00"}]
[null,"財產","其他交通工具",{"v":85000,"d":"NT$85,000.00"}]
[null,"財產","傢俱",{"v":100000,"d":"NT$100,000.00"}]
[null,"財產","收藏品",{"v":50000,"d":"NT$50,000.00"}]
[null,"財產","珠寶",{"v":60000,"d":"NT$60,000.00"}]
[null,"財產","其他奢侈品",{"v":40000,"d":"NT$40,000.00"}]

{"sheet":"債務","index":2,"n_rows":14,"n_cols":4,"rows_kept":14}
[{"$nulls":3}," "]
[null,"債務"]
[]
[null,"類別","價值"]
[null,"抵押貸款",{"v":400000,"d":"NT$400,000.00"}]
[null,"房屋淨值貸款",{"v":50000,"d":"NT$50,000.00"}]
[null,"汽車貸款",{"v":30000,"d":"NT$30,000.00"}]
[null,"個人貸款",{"v":12500,"d":"NT$12,500.00"}]
[null,"信用卡",{"v":65000,"d":"NT$65,000.00"}]
[null,"助學貸款",{"v":10000,"d":"NT$10,000.00"}]
[null,"投資貸款",{"v":20000,"d":"NT$20,000.00"}]
[null,"人壽保險貸款",{"v":5000,"d":"NT$5,000.00"}]
[null,"其他分期償還貸款",{"v":10000,"d":"NT$10,000.00"}]
[null,"其他債務",{"v":50000,"d":"NT$50,000.00"}]