{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["仪表板","资产","负债","计算"],"not_rendered":{"charts":4,"images":6,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"仪表板","index":0,"n_rows":18,"n_cols":8,"rows_kept":18}
[]
[null,"仪表板",{"$nulls":4},"净值摘要"," "]
{"$rows_empty":8}
[null,{"$f":"净资产","v":{"v":166600,"d":"¥166,600"}},null,{"$f":"总资产","v":{"v":387800,"d":"¥387,800"}},null,null,{"$f":"总负债","v":{"v":221200,"d":"¥221,200"}}]
[null,"净值",null,"资产总额",null,null,"总债务"]
[{"$nulls":3}," 现金",null,null," 无抵押"]
[{"$nulls":3}," 投资",null,null," 有抵押"]
[{"$nulls":3}," 养老金"]
[{"$nulls":3}," 个人"]
[]
[{"$nulls":3},"查看资产>",null,null,"查看负债>"]

{"sheet":"资产","index":1,"n_rows":23,"n_cols":11,"rows_kept":23,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"资产",{"$nulls":6},"净值摘要",null," "]
[]
[{"$nulls":3}," ","现金","价值",null," ","个人","价值"]
[{"$nulls":4},"库存现金",{"v":2000,"d":"2,000"},null,null,"主要居住地",{"v":233000,"d":"233,000"}]
[{"$nulls":4},"支票帐户",{"v":2500,"d":"2,500"},null,null,"第二居住地"]
[{"$nulls":4},"储蓄帐户",{"v":4000,"d":"4,000"},null,null,"收藏品"]
[{"$nulls":4},"货币市场帐户",{"v":3300,"d":"3,300"},null,null,"汽车",{"v":32000,"d":"32,000"}]
[{"$nulls":4},"存款单",{"v":14000,"d":"14,000"},null,null,"家居装饰",{"v":10000,"d":"10,000"}]
[{"$nulls":4},"美国国债",{"$nulls":3},"皮草及珠宝"]
[{"$nulls":4},"人寿保险现金价值",{"v":24500,"d":"24,500"},null,null,"其他资产 1",{"v":1500,"d":"1,500"}]
[null,{"$f":"总资产","v":{"v":387800,"d":"¥387,800"}},null,null,"其他现金",{"$nulls":3},"其他资产 2"]
[{"$nulls":4},"小计",{"$f":"SUBTOTAL(109,tblCash[价值])","v":{"v":50300,"d":"50,300"}},null,null,"小计",{"$f":"SUBTOTAL(109,tblPersonal[价值])","v":{"v":276500,"d":"276,500"}}]
[null,"资产总额"]
[]
[{"$nulls":3}," ","投资","价值",null," ","养老金","价值"]
[null,"查看负债>",null,null,"股票",{"v":15000,"d":"15,000"},null,null,"养老金"]
[null,"<视图仪表板",null,null,"债券",{"$nulls":3},"IRA 帐户"]
[{"$nulls":4},"共同基金投资",{"$nulls":3},"KEOGH 帐户"]
[{"$nulls":4},"合作伙伴权益",{"$nulls":3},"401K",{"v":46000,"d":"46,000"}]
[{"$nulls":4},"其他投资 1",{"$nulls":3},"9 月"]
[{"$nulls":4},"其他投资 2",{"$nulls":3},"其他养老金"]
[{"$nulls":4},"小计",{"$f":"SUBTOTAL(109,tblInvestments[价值])","v":{"v":15000,"d":"15,000"}},null,null,"小计",{"$f":"SUBTOTAL(109,tblRetirement[价值])","v":{"v":46000,"d":"46,000"}}]

{"sheet":"负债","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[11,1,12,1],[13,1,14,1]]}
[]
[null,"负债",{"$nulls":6},"净值摘要",null," "]
[]
[{"$nulls":3}," ","无抵押","欠债",null," ","有抵押","欠债"]
[{"$nulls":4},"信用卡",{"v":1200,"d":"1,200"},null,null,"自动贷款",{"v":14500,"d":"14,500"}]
[{"$nulls":4},"收费帐户",{"v":3000,"d":"3,000"},null,null,"车辆贷款"]
[{"$nulls":4},"学生贷款",{"v":17500,"d":"17,500"},null,null,"设备贷款"]
[{"$nulls":4},"赡养费",{"$nulls":3},"家庭抵押贷款",{"v":144000,"d":"144,000"}]
[{"$nulls":4},"子女支持",{"$nulls":3},"房屋净值贷款",{"v":21000,"d":"21,000"}]
[{"$nulls":4},"税务负债",{"v":8000,"d":"8,000"},null,null,"税务负债"]
[{"$nulls":4},"其他无担保 1",{"v":6000,"d":"6,000"},null,null,"其他担保 1",{"v":4000,"d":"4,000"}]
[null,{"$f":"总负债","v":{"v":221200,"d":"¥221,200"}},null,null,"其他无担保 2",{"$nulls":3},"其他担保 2",{"v":2000,"d":"2,000"}]
[{"$nulls":4},"小计",{"$f":"SUBTOTAL(109,tblUnsecured[欠债])","v":{"v":35700,"d":"35,700"}},null,null,"小计",{"$f":"SUBTOTAL(109,tblSecured[欠债])","v":{"v":185500,"d":"185,500"}}]
[null,"总债务"]
[]
[]
[null,"<查看资产"]
[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":50300,"d":"¥50,300"}}]
[null,{"$f":"tblInvestments[[#Headers],[投资]]","v":"投资"},{"$f":"SUM(tblInvestments[价值])","v":{"v":15000,"d":"¥15,000"}}]
[null,{"$f":"tblRetirement[[#Headers],[养老金]]","v":"养老金"},{"$f":"SUM(tblRetirement[价值])","v":{"v":46000,"d":"¥46,000"}}]
[null,{"$f":"tblPersonal[[#Headers],[个人]]","v":"个人"},{"$f":"SUM(tblPersonal[价值])","v":{"v":276500,"d":"¥276,500"}}]
[null,"总资产",{"$f":"SUM(tblCash[价值],tblInvestments[价值],tblRetirement[价值],tblPersonal[价值])","v":{"v":387800,"d":"¥387,800"}}]
[]
[]
[null,{"$f":"tblUnsecured[[#Headers],[无抵押]]","v":"无抵押"},{"$f":"SUM(tblUnsecured[欠债])","v":{"v":35700,"d":"¥35,700"}}]
[null,{"$f":"tblSecured[[#Headers],[有抵押]]","v":"有抵押"},{"$f":"SUM(tblSecured[欠债])","v":{"v":185500,"d":"¥185,500"}}]
[null,"总债务",{"$f":"SUM(tblUnsecured[欠债],tblSecured[欠债])","v":{"v":221200,"d":"¥221,200"}}]
[]
[]
[null,"净值",{"$f":"C15-C20","v":{"v":166600,"d":"¥166,600"}}]