{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["遗嘱认证清单","遗嘱认证资产","遗嘱认证负债"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"遗嘱认证清单","index":0,"n_rows":45,"n_cols":35,"rows_kept":45,"merged":[[0,1,0,30],[0,31,0,39],[1,1,5,39],[6,1,6,6],[6,7,6,39],[7,1,7,6],[7,7,7,39],[9,1,9,6],[9,7,9,39],[10,1,10,6],[10,7,10,39],[11,1,11,6],[11,7,11,20],[11,21,11,26],[11,27,11,30],[11,31,11,33],[11,34,11,39],[12,1,12,6],[12,7,12,20],[12,21,12,26],[13,1,13,6],[13,7,13,20],[13,21,13,26],[14,1,14,6],[14,7,14,20],[14,21,14,26],[15,1,15,6],[17,1,17,39],[18,1,18,6],[18,7,18,12],[18,13,18,15],[18,16,18,18],[18,19,18,26],[18,27,18,31],[18,32,18,39],[19,1,19,6],[19,7,19,12],[19,13,19,15],[19,16,19,18],[19,19,19,26],[19,27,19,31],[19,32,19,39],[20,1,20,6],[20,7,20,12],[20,13,20,15],[20,16,20,18],[20,19,20,26],[20,27,20,31],[20,32,20,39],[21,1,21,6],[21,7,21,12],[21,13,21,15],[21,16,21,18],[21,19,21,26],[21,27,21,31],[21,32,21,39],[22,1,22,6],[22,7,22,12],[22,13,22,15],[22,16,22,18],[22,19,22,26],[22,27,22,31],[22,32,22,39],[23,1,23,6],[23,7,23,12],[23,13,23,15],[23,16,23,18],[23,19,23,26],[23,27,23,31],[23,32,23,39],[25,1,25,39],[26,1,26,6],[26,7,26,12],[26,13,26,18],[26,19,26,26],[26,27,26,31],[26,32,26,39],[27,1,27,6],[27,7,27,12],[27,13,27,18],[27,19,27,26],[27,27,27,31],[27,32,27,39],[28,1,28,6],[28,7,28,12],[28,13,28,18],[28,19,28,26],[28,27,28,31],[28,32,28,39],[29,1,29,6],[29,7,29,12],[29,13,29,18],[29,19,29,26],[29,27,29,31],[29,32,29,39],[30,1,30,6],[30,7,30,12],[30,13,30,18],[30,19,30,26],[30,27,30,31],[30,32,30,39],[31,1,31,6],[31,7,31,12],[31,13,31,18],[31,19,31,26],[31,27,31,31],[31,32,31,39],[33,1,33,12],[33,14,33,39],[34,1,34,12],[34,14,34,21],[34,22,34,25],[34,26,34,33],[34,34,34,39],[35,2,35,12],[35,14,35,21],[35,22,35,25],[35,26,35,33],[35,34,35,39],[36,2,36,12],[36,14,36,21],[36,22,36,25],[36,26,36,33],[36,34,36,39],[37,2,37,12],[37,14,37,21],[37,22,37,25],[37,26,37,33],[37,34,37,39],[38,2,38,12],[38,14,38,21],[38,22,38,25],[38,26,38,33],[38,34,38,39],[39,2,39,12],[39,14,39,21],[39,22,39,25],[39,26,39,33],[39,34,39,39],[40,2,40,12],[40,14,40,21],[40,22,40,25],[40,26,40,33],[40,34,40,39],[41,2,41,12],[41,14,41,21],[41,22,41,25],[41,26,41,33],[41,34,41,39],[42,2,42,12],[42,14,42,21],[42,22,42,25],[42,26,42,33],[42,34,42,38],[43,2,43,12],[43,14,43,21],[43,22,43,25],[43,26,43,33],[43,34,43,39],[44,2,44,12],[44,14,44,21],[44,22,44,25],[44,26,44,33],[44,34,44,39]]}
[]
[null,"遗嘱认证清单"]
[]
[]
[]
[]
[null,"遗嘱执行人姓名",{"$nulls":5},"Allan Mattsson"]
[null,"联系信息",{"$nulls":5},"4567 Main St, Buffalo, NY 98052"]
[]
[null,"死者姓名",{"$nulls":5},"August Bergquist"]
[null,"街道地址",{"$nulls":5},"6789 Main St"]
[null,"市/县",{"$nulls":5},"Buffalo",{"$nulls":13},"省/市/自治区",{"$nulls":5},"纽约",{"$nulls":3},"邮政编码",null,null,98052]
[null,"SSN",{"$nulls":5},"AAA-GG-SSSS",{"$nulls":13},"职业",{"$nulls":5},"牙医"]
[null,"出生日期",{"$nulls":5},"1965-12-08",{"$nulls":13},"出生地",{"$nulls":5},"纽约"]
[null,"死亡日期",{"$nulls":5},{"$f":"TODAY()-3","v":"2022-05-13"},{"$nulls":13},"死亡地",{"$nulls":5},"纽约"]
[null,"其他信息"]
[]
[null,"  配偶、子女和其他家属"]
[null,"姓名",{"$nulls":5},"关系",{"$nulls":5},"家属",null,null,"年龄",null,null,"地址",{"$nulls":7},"电话号码",{"$nulls":4},"电子邮件"]
[null,"林媚卉",{"$nulls":5},"遗产代理人",{"$nulls":5},"否",null,null,30]
[null,"潘蕾",{"$nulls":5},"配偶",{"$nulls":5},"是",null,null,35]
[null,"Alexander Martensson",{"$nulls":5},"子女",{"$nulls":5},"是",null,null,12]
[]
[]
[]
[null,"专业顾问"]
[null,"顾问类型",{"$nulls":5},"联系人",{"$nulls":5},"公司",{"$nulls":5},"地址",{"$nulls":7},"电话号码",{"$nulls":4},"电子邮件"]
[null,"会计师"]
[null,"律师/公证员"]
[null,"其他"]
[]
[]
[]
[null,"  遗嘱认证清单",{"$nulls":12},"  遗嘱认证清单"]
[null,"    清单物品",{"$nulls":12},"遗嘱认证资产",{"$nulls":7},"价值(¥)",{"$nulls":3},"遗嘱认证负债",{"$nulls":7},"价值(¥)"]
[null,"✔","临终遗嘱、遗嘱或任何其他文件",{"$nulls":11},{"$f":"遗嘱认证资产!B12","v":"银行账户"},{"$nulls":7},{"$f":"遗嘱认证资产!G20","v":{"v":0,"d":"¥0.00"}},{"$nulls":3},{"$f":"遗嘱认证负债!B11","v":"抵押"},{"$nulls":7},{"$f":"遗嘱认证负债!G18","v":{"v":0,"d":"¥0.00"}}]
[null,"✔","保险箱租赁协议和钥匙",{"$nulls":11},{"$f":"遗嘱认证资产!B22","v":"个人投资"},{"$nulls":7},{"$f":"遗嘱认证资产!G30","v":{"v":0,"d":"¥0.00"}},{"$nulls":3},{"$f":"遗嘱认证负债!B21","v":"个人贷款和信贷额度"},{"$nulls":7},{"$f":"遗嘱认证负债!G28","v":{"v":0,"d":"¥0.00"}}]
[null,"✖","电脑和联机帐户的密码",{"$nulls":11},{"$f":"遗嘱认证资产!B32","v":"商业利益"},{"$nulls":7},{"$f":"遗嘱认证资产!G40","v":{"v":0,"d":"¥0.00"}},{"$nulls":3},{"$f":"遗嘱认证负债!B31","v":"商业利益"},{"$nulls":7},{"$f":"遗嘱认证负债!G38","v":{"v":0,"d":"¥0.00"}}]
[null,"✔","生前信托协议",{"$nulls":11},{"$f":"遗嘱认证资产!B42","v":"房地产"},{"$nulls":7},{"$f":"遗嘱认证资产!G50","v":{"v":0,"d":"¥0.00"}},{"$nulls":3},{"$f":"遗嘱认证负债!B41","v":"信用卡"},{"$nulls":7},{"$f":"遗嘱认证负债!G48","v":{"v":0,"d":"¥0.00"}}]
[null,"✔","人寿保险、健康/意外保险单",{"$nulls":11},{"$f":"遗嘱认证资产!B52","v":"退休金计划"},{"$nulls":7},{"$f":"遗嘱认证资产!G60","v":{"v":0,"d":"¥0.00"}},{"$nulls":3},{"$f":"遗嘱认证负债!B51","v":"其他负债"},{"$nulls":7},{"$f":"遗嘱认证负债!G58","v":{"v":0,"d":"¥0.00"}}]
[null,"✔","财务报表",{"$nulls":11},{"$f":"遗嘱认证资产!B62","v":"保险"},{"$nulls":7},{"$f":"遗嘱认证资产!G70","v":{"v":0,"d":"¥0.00"}}]
[null,"✔","过去三年的收入税单",{"$nulls":11},{"$f":"遗嘱认证资产!B72","v":"私人贷款和抵押贷款"},{"$nulls":7},{"$f":"遗嘱认证资产!G80","v":{"v":0,"d":"¥0.00"}}]
[null,"✔","出生证明和死亡证明",{"$nulls":11},{"$f":"遗嘱认证资产!B82","v":"其他遗产和信托中的权益"},{"$nulls":7},{"$f":"遗嘱认证资产!G90","v":{"v":0,"d":"¥0.00"}}]
[null,"✖","契约、抵押和租赁报表",{"$nulls":11},{"$f":"遗嘱认证资产!B92","v":"个人财物和其他资产"},{"$nulls":7},{"$f":"遗嘱认证资产!G100","v":{"v":0,"d":"¥0.00"}}]
[null,"☐","未付帐单和票据",{"$nulls":11},"总资产",{"$nulls":7},{"$f":"遗嘱认证资产!G10","v":{"v":0,"d":"¥0.00"}},{"$nulls":3},"总负债",{"$nulls":7},{"$f":"SUM(AI36:AN44)","v":{"v":0,"d":"¥0.00"}}]

{"sheet":"遗嘱认证资产","index":1,"n_rows":100,"n_cols":8,"rows_kept":100,"merged":[[0,1,0,7],[1,1,5,7],[6,1,7,7],[11,1,11,7],[12,1,12,7],[21,1,21,7],[22,1,22,7],[31,1,31,7],[32,1,32,7],[41,1,41,7],[42,1,42,7],[51,1,51,7],[52,1,52,7],[61,1,61,7],[62,1,62,7],[71,1,71,7],[72,1,72,7],[81,1,81,7],[82,1,82,7],[91,1,91,7],[92,1,92,7]]}
[]
[null,"遗嘱认证资产"]
[]
[]
[]
[]
[null,"使用此工作表创建遗嘱认证资产清单。需要确定每项遗产资产在死亡日的市场价值。查看所有记录，包括财务报表、保险单和税单，从而确定市场价值。可能还需要对个人物品(即艺术品、收藏品、古董等)进行估价。请务必同时在清单中包含所有国外资产，例如房地产、证券或海外商业利益。可能希望获得专业协助，从而确定国外资产的准确市场价值。"]
[]
[]
[null,"总资产",{"$nulls":4},{"$f":"tblBankAccounts[[#Totals],[余额 ]]+tblPersonalInvestments[[#Totals],[市场价值]]+tblBusinessInterests[[#Totals],[价值 ]]+tblRealEstate[[#Totals],[市场价格]]+tblPensionPlans[[#Totals],[价值 ]]+tblInsurance[[#Totals],[现金价值 ]]+tblMortgages[[#Totals],[所欠余额 ]]+tblTrusts[[#Totals],[分配金额]]+tblOtherAssets[[#Totals],[价值 ]]","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"银行账户"]
[null,"列出所有银行账户，包括现金、旅行支票、汇票，以及商业银行、储蓄银行、信用社等中的账户。包含账户上列出的所有姓名和实际现金价值，即死亡时的确切美元和涨跌额。"]
[null,"金融机构 ","地址","电话","帐号","帐户类型","余额 ","票据"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":4},{"$f":"SUBTOTAL(109,tblBankAccounts[[余额 ]])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"个人投资"]
[null,"列出现金账户、保证金账户、免税储蓄账户、注册退休储蓄计划(RRSP)、注册退休收入基金(RRIF)、锁定 RRIF、锁定 RRSP、终身入息基金、规定退休收入基金、注册教育储蓄计划、养老金等。"]
[null,"公司","地址","电话","帐号","受益人","市场价值","备注"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":4},{"$f":"SUBTOTAL(109,tblPersonalInvestments[市场价值])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"商业利益"]
[null,"列出所有商业利益，包括独资企业、专业实践、企业、合伙企业、有限责任公司和合伙企业、合资企业以及其他非公开交易的商业实体。 "]
[null,"公司名称","地址","电话","联系人","类型","价值 ","备注"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":4},{"$f":"SUBTOTAL(109,tblBusinessInterests[[价值 ]])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"房地产"]
[null,"列出任何死者和/或死者的未亡配偶/伴侣为所有者、共同所有者或以任何方式享有权益的不动产，包括娱乐开发和分时度假中购买的财产。获取契约副本。提供包含物理地址的房地产说明。根据估税员的最新评估列出财产的公平市场价值。"]
[null,"地址","所有权持有者","电话","联系人","购买价格","市场价格","备注"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":3},{"$f":"SUBTOTAL(109,tblRealEstate[购买价格])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,tblRealEstate[市场价格])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"退休金计划"]
[null,"列出固定收益、货币购买或设定提存、DPSP 或公司 RRSP 等。"]
[null,"公司","电话","计划类型","受益人","电子邮件","价值 ","备注"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":4},{"$f":"SUBTOTAL(109,tblPensionPlans[[价值 ]])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"保险"]
[null,"包含生前信托、具有指定受益人的人寿保险单和死亡时转移的投资账户(作为非遗嘱认证资产)。如果法院询问这些资产，则遗嘱执行人可以轻松参考非遗嘱认证资产清单，并解释遗嘱认证清单中不包含这些资产的原因。"]
[null,"发行机构","保单号","电话","受益人","面值 ","现金价值 ","备注"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":3},{"$f":"SUBTOTAL(109,tblInsurance[[面值 ]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,tblInsurance[[现金价值 ]])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"私人贷款和抵押贷款"]
[null,"列出死者为出借人的私人贷款和抵押贷款。"]
[null,"借款人姓名","地址","电话","类型","原交易金额","所欠余额 ","备注"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":3},{"$f":"SUBTOTAL(109,tblMortgages[原交易金额])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,tblMortgages[[所欠余额 ]])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"其他遗产和信托中的权益"]
[null,"列出以死者名义登记的代他人持有的资产(例如死者作为受托人持有的资产或根据授权书持有的资产)。"]
[null,"遗产/信托名称","遗嘱执行人/受托人姓名","电话","地址","电子邮件","分配金额","备注"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":4},{"$f":"SUBTOTAL(109,tblTrusts[分配金额])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"个人财物和其他资产"]
[null,"列出所有个人物品，例如汽车、珠宝、艺术品、古董、家具。包含可能存放在保险箱中或安全保管的物品。"]
[null,"物品说明","地点","电话","联系人","受益人","价值 ","票据"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":4},{"$f":"SUBTOTAL(109,tblOtherAssets[[价值 ]])","v":{"v":0,"d":"¥0.00"}}]

{"sheet":"遗嘱认证负债","index":2,"n_rows":58,"n_cols":8,"rows_kept":58,"merged":[[0,1,0,7],[1,1,5,7],[6,1,6,7],[10,1,10,7],[20,1,20,7],[30,1,30,7],[40,1,40,7],[50,1,50,7]]}
[]
[null,"遗嘱认证负债"]
[]
[]
[]
[]
[null,"使用此工作表捕获国内、外遗产负债的详细信息。将需要估算每项负债在死亡日的价值。"]
[]
[null,"总资产",{"$nulls":4},{"$f":"SUM(G18,G28,G38,G48,G58)","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"抵押"]
[null,"金融机构 ","地址","电话","所有权持有者","帐号","余额 ","票据"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":4},{"$f":"SUBTOTAL(109,tblBankAccounts2[[余额 ]])","v":{"v":0,"d":"¥0.00"}}]
[]
[]
[null,"个人贷款和信贷额度"]
[null,"金融机构","地址","电话"," 帐号","类型","余额 ","备注"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":4},{"$f":"SUBTOTAL(109,tblPersonalInvestments3[[余额 ]])","v":{"v":0,"d":"¥0.00"}}]
[]
[]
[null,"商业利益"]
[null,"公司名称","地址"," 电话"," 联系人","类型","价值 ","备注"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":4},{"$f":"SUBTOTAL(109,tblBusinessInterests4[[价值 ]])","v":{"v":0,"d":"¥0.00"}}]
[]
[]
[null,"信用卡"]
[null,"信用卡公司","公司地址","电话","卡号","有效期 ","余额 ","备注"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":3},{"$f":"SUBTOTAL(109,tblRealEstate5[[有效期 ]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,tblRealEstate5[[余额 ]])","v":{"v":0,"d":"¥0.00"}}]
[]
[]
[null,"其他负债"]
[null,"物品说明","地点","电话","联系人","受益人","价值 ","票据"]
[]
[]
[]
[]
[]
[null,"总计",{"$nulls":4},{"$f":"SUBTOTAL(109,tblPensionPlans6[[价值 ]])","v":{"v":0,"d":"¥0.00"}}]