{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Personal net worth","Assets","Debt"],"not_rendered":{"charts":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Personal net worth","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},"Cash and Cash Equivalent",{"$f":"SUMIF(TBL_Assets[Category],'Personal net worth'!M1,TBL_Assets[Value])+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":"Cash and Cash Equivalent"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(5,$O$1:$O$5,0),2),2)","v":42500},null,"Total Assets",{"$f":"SUM(TBL_Assets[Value])","v":1923500}]
[{"$nulls":12},"Properties",{"$f":"SUMIF(TBL_Assets[Category],'Personal net worth'!M2,TBL_Assets[Value])+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":"Retirement Savings"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(4,$O$1:$O$5,0),2),2)","v":98000},null,"Total Debts",{"$f":"SUM(TBL_Debts[Value])","v":652500}]
[null,null,"PERSONAL NET WORTH",{"$nulls":3},"ASSETS VS DEBT",{"$nulls":5},"Investments",{"$f":"SUMIF(TBL_Assets[Category],'Personal net worth'!M3,TBL_Assets[Value])+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":"Life Insurance"},{"$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},"Retirement Savings",{"$f":"SUMIF(TBL_Assets[Category],'Personal net worth'!M4,TBL_Assets[Value])+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":"Investments"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(2,$O$1:$O$5,0),2),2)","v":475000}]
[{"$nulls":3},"Total assets",{"$f":"SUM(TBL_Assets[Value])","v":{"v":1923500,"d":"$ 1,923,500"}},{"$nulls":7},"Life Insurance",{"$f":"SUMIF(TBL_Assets[Category],'Personal net worth'!M5,TBL_Assets[Value])+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":"Properties"},{"$f":"ROUND(INDEX($M$1:$N$5,MATCH(1,$O$1:$O$5,0),2),2)","v":1205000}]
[]
[{"$nulls":3},"Total debt",{"$f":"SUM(TBL_Debts[Value])","v":{"v":652500,"d":"$ 652,500"}}]
[]
[null,null,"SUMMARY OF ASSETS"]
[]
[{"$nulls":7},{"$f":"Q5","v":"Properties"},{"$f":"R5","v":{"v":1205000,"d":"$ 1,205,000"}}]
[]
[{"$nulls":7},{"$f":"Q4","v":"Investments"},{"$f":"R4","v":{"v":475000,"d":"$ 475,000"}}]
[]
[{"$nulls":7},{"$f":"Q3","v":"Life Insurance"},{"$f":"R3","v":{"v":103000,"d":"$ 103,000"}}]
[]
[{"$nulls":7},{"$f":"Q2","v":"Retirement Savings"},{"$f":"R2","v":{"v":98000,"d":"$ 98,000"}}]
[]
[{"$nulls":7},{"$f":"Q1","v":"Cash and Cash Equivalent"},{"$f":"R1","v":{"v":42500,"d":"$ 42,500"}}]

{"sheet":"Assets","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[1,1,1,3]]}
[{"$nulls":4}," "]
[null,"ASSETS"]
[null,"Category","Item","Value"]
[null,"Properties","Home",{"v":560000,"d":"$560,000.00"}]
[null,"Properties","Other",{"v":255000,"d":"$255,000.00"}]
[null,"Retirement Savings","Retirement accounts",{"v":98000,"d":"$98,000.00"}]
[null,"Investments","Stocks",{"v":53000,"d":"$53,000.00"}]
[null,"Investments","Bonds",{"v":25000,"d":"$25,000.00"}]
[null,"Investments","Mutual funds",{"v":33000,"d":"$33,000.00"}]
[null,"Investments","CDs",{"v":74000,"d":"$74,000.00"}]
[null,"Investments","Bullion",{"v":20000,"d":"$20,000.00"}]
[null,"Investments","Trust funds",{"v":250000,"d":"$250,000.00"}]
[null,"Life Insurance","Health savings account",{"v":18000,"d":"$18,000.00"}]
[null,"Life Insurance","Face value of life insurance policy",{"v":85000,"d":"$85,000.00"}]
[null,"Investments","Other",{"v":20000,"d":"$20,000.00"}]
[null,"Cash and Cash Equivalent","Checking accounts",{"v":35500,"d":"$35,500.00"}]
[null,"Cash and Cash Equivalent","Savings accounts",{"v":5000,"d":"$5,000.00"}]
[null,"Cash and Cash Equivalent","Other",{"v":2000,"d":"$2,000.00"}]
[null,"Properties","Cars",{"v":55000,"d":"$55,000.00"}]
[null,"Properties","Other vehicles",{"v":85000,"d":"$85,000.00"}]
[null,"Properties","Furnishings",{"v":100000,"d":"$100,000.00"}]
[null,"Properties","Collectibles",{"v":50000,"d":"$50,000.00"}]
[null,"Properties","Jewelry",{"v":60000,"d":"$60,000.00"}]
[null,"Properties","Other luxury goods",{"v":40000,"d":"$40,000.00"}]

{"sheet":"Debt","index":2,"n_rows":13,"n_cols":4,"rows_kept":13}
[{"$nulls":3}," "]
[null,"DEBT"]
[null,"Category","Value"]
[null,"Mortgages",{"v":400000,"d":"$400,000.00"}]
[null,"Home equity loans",{"v":50000,"d":"$50,000.00"}]
[null,"Car loans",{"v":30000,"d":"$30,000.00"}]
[null,"Personal loans",{"v":12500,"d":"$12,500.00"}]
[null,"Credit cards",{"v":65000,"d":"$65,000.00"}]
[null,"Student loans",{"v":10000,"d":"$10,000.00"}]
[null,"Loans against investments",{"v":20000,"d":"$20,000.00"}]
[null,"Life insurance loans",{"v":5000,"d":"$5,000.00"}]
[null,"Other installment loans",{"v":10000,"d":"$10,000.00"}]
[null,"Other debts",{"v":50000,"d":"$50,000.00"}]