{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Personal Net Worth","Assets","Debts"],"not_rendered":{"charts":2,"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Personal Net Worth","index":0,"n_rows":21,"n_cols":25,"rows_kept":21,"merged":[[3,2,4,7]]}
[{"$nulls":14}," "]
[{"$nulls":16},"Cash and Cash Equivalent",{"$f":"SUMIF(TBL_Assets[Category],'Personal Net Worth'!Q2,TBL_Assets[Value])+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":"Cash and Cash Equivalent"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(5,$S$2:$S$6,0),2),2)","v":42500},null,"Total Assets",{"$f":"SUM(TBL_Assets[Value])","v":1923500}]
[null,null," PERSONAL NET WORTH",{"$nulls":13},"Properties",{"$f":"SUMIF(TBL_Assets[Category],'Personal Net Worth'!Q3,TBL_Assets[Value])+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":"Retirement Savings"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(4,$S$2:$S$6,0),2),2)","v":98000},null,"Total Debts",{"$f":"SUM(TBL_Debts[Value])","v":652500}]
[null,null,{"$f":"F6-F8","v":{"v":1271000,"d":"£1,271,000"}},{"$nulls":6},"ASSETS vs DEBTS",{"$nulls":6},"Investments",{"$f":"SUMIF(TBL_Assets[Category],'Personal Net Worth'!Q4,TBL_Assets[Value])+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":"Life Insurance"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(3,$S$2:$S$6,0),2),2)","v":103000}]
[{"$nulls":16},"Retirement Savings",{"$f":"SUMIF(TBL_Assets[Category],'Personal Net Worth'!Q5,TBL_Assets[Value])+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":"Investments"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(2,$S$2:$S$6,0),2),2)","v":475000}]
[{"$nulls":4},"Total Assets",{"$f":"SUM(TBL_Assets[Value])","v":{"v":1923500,"d":"£1,923,500"}},{"$nulls":10},"Life Insurance",{"$f":"SUMIF(TBL_Assets[Category],'Personal Net Worth'!Q6,TBL_Assets[Value])+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":"Properties"},{"$f":"ROUND(INDEX($Q$2:$R$6,MATCH(1,$S$2:$S$6,0),2),2)","v":1205000}]
[]
[{"$nulls":4},"Total Debts",{"$f":"SUM(TBL_Debts[Value])","v":{"v":652500,"d":"£652,500"}}]
[]
[]
[]
[{"$nulls":3},"SUMMARY OF ASSETS"]
[{"$nulls":10},{"$f":"U6","v":"Properties"},{"$f":"V6","v":{"v":1205000,"d":"£1,205,000"}}]
[]
[{"$nulls":10},{"$f":"U5","v":"Investments"},{"$f":"V5","v":{"v":475000,"d":"£475,000"}}]
[]
[{"$nulls":10},{"$f":"U4","v":"Life Insurance"},{"$f":"V4","v":{"v":103000,"d":"£103,000"}}]
[]
[{"$nulls":10},{"$f":"U3","v":"Retirement Savings"},{"$f":"V3","v":{"v":98000,"d":"£98,000"}}]
[]
[{"$nulls":10},{"$f":"U2","v":"Cash and Cash Equivalent"},{"$f":"V2","v":{"v":42500,"d":"£42,500"}}]

{"sheet":"Assets","index":1,"n_rows":25,"n_cols":5,"rows_kept":25}
[{"$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":"Debts","index":2,"n_rows":14,"n_cols":4,"rows_kept":14}
[{"$nulls":3}," "]
[null,"DEBTS"]
[]
[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 instalment loans",{"v":10000,"d":"£10,000.00"}]
[null,"Other debts",{"v":50000,"d":"£50,000.00"}]