{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Dashboard","Assets","Liabilities","calculations"],"not_rendered":{"charts":4,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Dashboard","index":0,"n_rows":16,"n_cols":8,"rows_kept":16}
[]
[null,"DASHBOARD",{"$nulls":4},"NET WORTH SUMMARY"," "]
{"$rows_empty":8}
[null,{"$f":"NetWorth","v":{"v":159600,"d":"$159,600"}},null,{"$f":"TotalAssets","v":{"v":380800,"d":"$380,800"}},null,null,{"$f":"TotalLiabilites","v":{"v":221200,"d":"$221,200"}}]
[null,"NET WORTH",null,"TOTAL ASSETS",null,null,"TOTAL LIABILITIES"]
[{"$nulls":3},"CASH",null,null,"UNSECURED"]
[{"$nulls":3},"INVESTMENTS",null,null,"SECURED"]
[{"$nulls":3},"RETIREMENT"]
[{"$nulls":3},"PERSONAL"]

{"sheet":"Assets","index":1,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[11,1,12,1],[13,1,14,1],[13,2,13,4],[13,6,13,8],[23,2,23,4],[23,6,23,8]]}
[]
[null,"ASSETS",{"$nulls":5},"NET WORTH SUMMARY",null," "]
[]
[null,null," ","CASH","VALUE",null," ","PERSONAL","VALUE"]
[{"$nulls":3},"CASH ON HAND",{"v":2000,"d":"2,000"},null,null,"PRINCIPAL RESIDENCE",{"v":233000,"d":"233,000"}]
[{"$nulls":3},"CHECKING ACCOUNTS",{"v":2500,"d":"2,500"},null,null,"SECOND RESIDENCE"]
[{"$nulls":3},"SAVINGS ACCOUNTS",{"v":4000,"d":"4,000"},null,null,"COLLECTIBLES"]
[{"$nulls":3},"MONEY MARKET ACCOUNTS",{"v":3300,"d":"3,300"},null,null,"AUTOMOBILES",{"v":32000,"d":"32,000"}]
[{"$nulls":3},"MONEY MARKET FUND ACCOUNTS",{"v":7000,"d":"7,000"},null,null,"HOME FURNISHINGS",{"v":10000,"d":"10,000"}]
[{"$nulls":3},"CERTIFICATES OF DEPOSIT",{"$nulls":3},"FURS & JEWELRY"]
[{"$nulls":3},"U.S. TREASURY BILLS",{"$nulls":3},"OTHER ASSETS",{"v":1500,"d":"1,500"}]
[null,{"$f":"TotalAssets","v":{"v":380800,"d":"$380,800"}},null,"CASH VALUE OF LIFE INSURANCE",{"v":24500,"d":"24,500"}]
[{"$nulls":3},"SUBTOTAL",{"$f":"SUBTOTAL(109,tblCash[VALUE])","v":{"v":43300,"d":"43,300"}},null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,tblPersonal[VALUE])","v":{"v":276500,"d":"276,500"}}]
[null,"TOTAL ASSETS"]
[]
[null,null," ","INVESTMENTS","VALUE",null," ","RETIREMENT","VALUE"]
[{"$nulls":3},"STOCKS",{"v":15000,"d":"15,000"},null,null,"PENSION"]
[{"$nulls":3},"BONDS",{"$nulls":3},"IRA ACCOUNTS"]
[{"$nulls":3},"MUTUAL FUND INVESTMENTS",{"$nulls":3},"KEOGH ACCOUNTS"]
[{"$nulls":3},"PARTNERSHIP INTERESTS",{"$nulls":3},"401K",{"v":46000,"d":"46,000"}]
[{"$nulls":3},"OTHER INVESTMENTS",{"$nulls":3},"SEP"]
[{"$nulls":7},"ESOP"]
[{"$nulls":3},"SUBTOTAL",{"$f":"SUBTOTAL(109,tblInvestments[VALUE])","v":{"v":15000,"d":"15,000"}},null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,tblRetirement[VALUE])","v":{"v":46000,"d":"46,000"}}]

{"sheet":"Liabilities","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"LIABILITIES",{"$nulls":5},"NET WORTH SUMMARY",null," "]
[]
[null,null," ","UNSECURED","OWE",null," ","SECURED","OWE"]
[{"$nulls":3},"CREDIT CARDS",{"v":1200,"d":"1,200"},null,null,"Auto Loans",{"v":14500,"d":"14,500"}]
[{"$nulls":3},"CHARGE ACCOUNTS",{"v":3000,"d":"3,000"},null,null,"Rec. Vehicle Loans"]
[{"$nulls":3},"STUDENT LOANS",{"v":17500,"d":"17,500"},null,null,"Appliance Loans"]
[{"$nulls":3},"ALIMONY",{"$nulls":3},"Home Mortgages",{"v":144000,"d":"144,000"}]
[{"$nulls":3},"CHILD SUPPORT",{"$nulls":3},"Home Equity Loans",{"v":21000,"d":"21,000"}]
[{"$nulls":3},"TAX LIABILITY",{"v":8000,"d":"8,000"},null,null,"Other Loans"]
[{"$nulls":3},"OTHER",{"v":6000,"d":"6,000"},null,null,"Tax Liability",{"v":4000,"d":"4,000"}]
[null,{"$f":"TotalLiabilites","v":{"v":221200,"d":"$221,200"}},{"$nulls":5},"Other",{"v":2000,"d":"2,000"}]
[{"$nulls":3},"SUBTOTAL",{"$f":"SUBTOTAL(109,tblUnsecured[OWE])","v":{"v":35700,"d":"35,700"}},null,null,"SUBTOTAL",{"$f":"SUBTOTAL(109,tblSecured[OWE])","v":{"v":185500,"d":"185,500"}}]
[null,"TOTAL LIABILITIES"]

{"sheet":"calculations","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"hidden":true}
[]
[null,"*** This sheet should remain hidden ***"]
{"$rows_empty":8}
[null,{"$f":"tblCash[[#Headers],[CASH]]","v":"CASH"},{"$f":"SUM(tblCash[VALUE])","v":{"v":43300,"d":"$43,300"}}]
[null,{"$f":"tblInvestments[[#Headers],[INVESTMENTS]]","v":"INVESTMENTS"},{"$f":"SUM(tblInvestments[VALUE])","v":{"v":15000,"d":"$15,000"}}]
[null,{"$f":"tblRetirement[[#Headers],[RETIREMENT]]","v":"RETIREMENT"},{"$f":"SUM(tblRetirement[VALUE])","v":{"v":46000,"d":"$46,000"}}]
[null,{"$f":"tblPersonal[[#Headers],[PERSONAL]]","v":"PERSONAL"},{"$f":"SUM(tblPersonal[VALUE])","v":{"v":276500,"d":"$276,500"}}]
[null,"Total Assets",{"$f":"SUM(tblCash[VALUE],tblInvestments[VALUE],tblRetirement[VALUE],tblPersonal[VALUE])","v":{"v":380800,"d":"$380,800"}}]
[]
[]
[null,{"$f":"tblUnsecured[[#Headers],[UNSECURED]]","v":"UNSECURED"},{"$f":"SUM(tblUnsecured[OWE])","v":{"v":35700,"d":"$35,700"}}]
[null,{"$f":"tblSecured[[#Headers],[SECURED]]","v":"SECURED"},{"$f":"SUM(tblSecured[OWE])","v":{"v":185500,"d":"$185,500"}}]
[null,"Total Liabilities",{"$f":"SUM(tblUnsecured[OWE],tblSecured[OWE])","v":{"v":221200,"d":"$221,200"}}]
[]
[]
[null,"Net Worth",{"$f":"C15-C20","v":{"v":159600,"d":"$159,600"}}]