{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["儀表板","資產","負債","計算"],"not_rendered":{"charts":4,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"儀表板","index":0,"n_rows":16,"n_cols":8,"rows_kept":16}
[]
[null,"儀表板",{"$nulls":4},"淨值摘要"," "]
{"$rows_empty":8}
[null,{"$f":"NetWorth","v":{"v":4788000,"d":"NT$4,788,000"}},null,{"$f":"TotalAssets","v":{"v":11424000,"d":"NT$11,424,000"}},null,null,{"$f":"TotalLiabilites","v":{"v":6636000,"d":"NT$6,636,000"}}]
[null,"淨值",null,"總資產",null,null,"總負債"]
[{"$nulls":3},"現金",null,null,"無擔保"]
[{"$nulls":3},"投資",null,null,"有擔保"]
[{"$nulls":3},"退休"]
[{"$nulls":3},"個人"]

{"sheet":"資產","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,"資產",{"$nulls":5},"淨值摘要",null," "]
[]
[null,null," ","現金","價值",null," ","個人","價值"]
[{"$nulls":3},"手頭現金",{"v":60000,"d":"60,000"},null,null,"主要自用住宅",{"v":6990000,"d":"6,990,000"}]
[{"$nulls":3},"支票帳戶",{"v":75000,"d":"75,000"},null,null,"第二自用住宅"]
[{"$nulls":3},"儲蓄帳戶",{"v":120000,"d":"120,000"},null,null,"收藏品"]
[{"$nulls":3},"貨幣市場帳戶",{"v":99000,"d":"99,000"},null,null,"汽車",{"v":960000,"d":"960,000"}]
[{"$nulls":3},"貨幣市場基金帳戶",{"v":210000,"d":"210,000"},null,null,"傢俱",{"v":300000,"d":"300,000"}]
[{"$nulls":3},"定存單",{"$nulls":3},"皮草與珠寶"]
[{"$nulls":3},"美國國庫券",{"$nulls":3},"其他資產",{"v":45000,"d":"45,000"}]
[null,{"$f":"TotalAssets","v":{"v":11424000,"d":"NT$11,424,000"}},null,"壽險現金價值",{"v":735000,"d":"735,000"}]
[{"$nulls":3},"小計",{"$f":"SUBTOTAL(109,tblCash[價值])","v":{"v":1299000,"d":"1,299,000"}},null,null,"小計",{"$f":"SUBTOTAL(109,tblPersonal[價值])","v":{"v":8295000,"d":"8,295,000"}}]
[null,"總資產"]
[]
[null,null," ","投資","價值",null," ","退休","價值"]
[{"$nulls":3},"股票",{"v":450000,"d":"450,000"},null,null,"退休金"]
[{"$nulls":3},"債券",{"$nulls":3},"IRA 帳戶"]
[{"$nulls":3},"共同基金投資",{"$nulls":3},"KEOGH 帳戶"]
[{"$nulls":3},"合夥權益",{"$nulls":3},"401K",{"v":1380000,"d":"1,380,000"}]
[{"$nulls":3},"其他投資",{"$nulls":3},"SEP"]
[{"$nulls":7},"ESOP"]
[{"$nulls":3},"小計",{"$f":"SUBTOTAL(109,tblInvestments[價值])","v":{"v":450000,"d":"450,000"}},null,null,"小計",{"$f":"SUBTOTAL(109,tblRetirement[價值])","v":{"v":1380000,"d":"1,380,000"}}]

{"sheet":"負債","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"負債",{"$nulls":5},"淨值摘要",null," "]
[]
[null,null," ","無擔保","欠款",null," ","有擔保","欠款"]
[{"$nulls":3},"信用卡",{"v":36000,"d":"36,000"},null,null,"汽車貸款",{"v":435000,"d":"435,000"}]
[{"$nulls":3},"記帳帳戶",{"v":90000,"d":"90,000"},null,null,"休旅車貸款"]
[{"$nulls":3},"學生貸款",{"v":525000,"d":"525,000"},null,null,"家電設備貸款"]
[{"$nulls":3},"贍養費",{"$nulls":3},"房貸抵押貸款",{"v":4320000,"d":"4,320,000"}]
[{"$nulls":3},"子女撫養",{"$nulls":3},"房產淨值貸款",{"v":630000,"d":"630,000"}]
[{"$nulls":3},"應納稅款",{"v":240000,"d":"240,000"},null,null,"其他貸款"]
[{"$nulls":3},"其他",{"v":180000,"d":"180,000"},null,null,"應納稅款",{"v":120000,"d":"120,000"}]
[null,{"$f":"TotalLiabilites","v":{"v":6636000,"d":"NT$6,636,000"}},{"$nulls":5},"其他",{"v":60000,"d":"60,000"}]
[{"$nulls":3},"小計",{"$f":"SUBTOTAL(109,tblUnsecured[欠款])","v":{"v":1071000,"d":"1,071,000"}},null,null,"小計",{"$f":"SUBTOTAL(109,tblSecured[欠款])","v":{"v":5565000,"d":"5,565,000"}}]
[null,"總資產"]

{"sheet":"計算","index":3,"n_rows":23,"n_cols":3,"rows_kept":23,"hidden":true}
[]
[null,"*** 此工作表應保持隱藏 ***"]
{"$rows_empty":8}
[null,{"$f":"tblCash[[#Headers],[現金]]","v":"現金"},{"$f":"SUM(tblCash[價值])","v":{"v":1299000,"d":"NT$1,299,000"}}]
[null,{"$f":"tblInvestments[[#Headers],[投資]]","v":"投資"},{"$f":"SUM(tblInvestments[價值])","v":{"v":450000,"d":"NT$450,000"}}]
[null,{"$f":"tblRetirement[[#Headers],[退休]]","v":"退休"},{"$f":"SUM(tblRetirement[價值])","v":{"v":1380000,"d":"NT$1,380,000"}}]
[null,{"$f":"tblPersonal[[#Headers],[個人]]","v":"個人"},{"$f":"SUM(tblPersonal[價值])","v":{"v":8295000,"d":"NT$8,295,000"}}]
[null,"總資產",{"$f":"SUM(tblCash[價值],tblInvestments[價值],tblRetirement[價值],tblPersonal[價值])","v":{"v":11424000,"d":"NT$11,424,000"}}]
[]
[]
[null,{"$f":"tblUnsecured[[#Headers],[無擔保]]","v":"無擔保"},{"$f":"SUM(tblUnsecured[欠款])","v":{"v":1071000,"d":"NT$1,071,000"}}]
[null,{"$f":"tblSecured[[#Headers],[有擔保]]","v":"有擔保"},{"$f":"SUM(tblSecured[欠款])","v":{"v":5565000,"d":"NT$5,565,000"}}]
[null,"總負債",{"$f":"SUM(tblUnsecured[欠款],tblSecured[欠款])","v":{"v":6636000,"d":"NT$6,636,000"}}]
[]
[]
[null,"淨值",{"$f":"C15-C20","v":{"v":4788000,"d":"NT$4,788,000"}}]