{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["入力シート","保存データ","ロジック","令和２年簡易生命表（男）","令和２年簡易生命表（女）"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"入力シート","index":0,"n_rows":29,"n_cols":19,"rows_kept":29,"cut":false,"hidden":false,"merged":[[11,15,14,27],[9,15,10,27],[15,15,15,27],[8,15,8,16],[24,5,24,10],[20,1,20,14],[21,1,21,14],[22,1,22,14],[6,1,7,2],[6,5,7,6],[1,1,2,1],[1,2,2,2],[1,5,2,5],[1,6,2,6]]}
[]
[null,"担当者名","お客様名",null,null,"性別","年齢"]
[]
[]
[]
[null,null,null,null,null,null,"(単位：万円）"]
[null,"資産",null,null,null,"負債"]
[]
[null,"現金・預貯金",null,{"$f":"C9/SUM($C$9:$C$16)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D9*100,0)*4","v":{"$error":"#DIV/0!"}},"借入金",null,{"$f":"G9/SUM($G$9:$G$17)","v":{"$error":"#DIV/0!"}},{"$f":"H9*$E$17","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"平均余命",null,{"$f":"IF($A$21=\"\",\"\",IF($F$4=\"男\",VLOOKUP($G$4,男性余命,13),IF($F$4=\"女\",VLOOKUP($G$4,女性余命,13),\"\")))","v":""},"令和2年簡易生命表（厚生労働省）より引用"]
[null,"有価証券",null,{"$f":"C10/SUM($C$9:$C$16)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D10*100,0)*4","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,{"$f":"IF($A$21=\"\",\"\",VLOOKUP($A$21,判定,2,FALSE))","v":""}]
[null,"生命保険\n(死亡保険金額)",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"自社株",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,{"$f":"IF($A$21=\"\",\"\",VLOOKUP($A$21,判定,4,FALSE))","v":""}]
[null,"不動産",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"事業用不動産",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"会社への貸付金",null,{"$f":"C15/SUM($C$9:$C$16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"その他",null,{"$f":"C16/SUM($C$9:$C$16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,{"$f":"G16/SUM($G$9:$G$17)","v":{"$error":"#DIV/0!"}},{"$f":"H16*$E$17","v":{"$error":"#DIV/0!"}}]
[null,"資産合計",{"$f":"SUM(C9:C16)","v":0},null,{"$f":"SUM(E9:E16)","v":{"$error":"#DIV/0!"}},"純資産",{"$f":"C17-G9","v":0},{"$f":"G17/SUM($G$9:$G$17)","v":{"$error":"#DIV/0!"}},{"$f":"H17*$E$17","v":{"$error":"#DIV/0!"}}]
[]
[null,"金額を入力後、【実行】ボタンを押してください"]
[null,"平均余命",{"$f":"IF($A$21=\"\",\"\",IF($F$4=\"男\",VLOOKUP($G$4,男性余命,13),IF($F$4=\"女\",VLOOKUP($G$4,女性余命,13),\"\")))","v":""},null,null,"令和2年簡易生命表（厚生労働省）より引用"]
[null,{"$f":"IF($A$21=\"\",\"\",VLOOKUP($A$21,判定,2,FALSE))","v":""}]
[{"$f":"ロジック!F8","v":{"$error":"#DIV/0!"}},{"$f":"IF($A$21=\"\",\"\",VLOOKUP($A$21,判定,4,FALSE))","v":""}]
[]
[]
[null,"資産",null,null,null,"承継者"]
[null,null,"資産",null,null,{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}}]
[null,"流動資産","流動資産",null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,"固定資産","固定資産",null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,"その他","資産合計",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"保存データ","index":1,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","担当者","お客様氏名","性別","年齢","現金・預貯金","有価証券","生命保険（死亡保険金額）","自社株","不動産","事業用不動産","会社への貸付金","その他","借入金","純資産","Code"]

{"sheet":"ロジック","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,1,4,1],[1,3,2,3],[3,3,4,3]]}
["Code","条件１","状況","条件２","状況",null,"判定","判定（詳細）","New判定","URL"]
[1,"流動性<50","YES","自社株割合>40","YES",{"$f":"IF($B$14<50%,IF($C$11>40%,\"〇\",\"\"),\"\")","v":{"$error":"#DIV/0!"}},"相続税納税資金の準備、相続時の遺産分割について、対策のご検討をお勧めします。","後継者に自社株をまとめて承継すると、後継者の相続税の納税資金が不足する可能性があります。また、後継者以外の相続人への遺産分割についても課題があると思われます。これを機会に具体的に対策のご検討を始められることをお勧めします。また、遺言の作成がまだの方は、遺言を作成することをお勧めします。すでに遺言を作成されている方も、この機会に遺言の内容をご確認いただくことをお進めします。","相続税の納税が困難となる可能性が高いです。\n5つの質問にお答えいただくだけで、お客様ごとの『納税資金確保ToDoリスト』が取得できます。\n併せて、相続で失敗しないために必要な情報を定期的にお渡ししておりますので、以下のURLからご確認ください。","https://keishisha.typeform.com/to/oHQ1wK1i"]
[2,null,"YES",null,"NO",{"$f":"IF($B$14<50%,IF($C$11>40%,\"\",\"〇\"),\"\")","v":{"$error":"#DIV/0!"}},"相続時の遺産分割のご希望をふまえて、相続税の納税資金と遺産分割に課題がないかご確認ください。","流動性資産の比率が低いため、遺産分割と相続税の納税に課題があるかもしれません。この機会にご確認いただくことをお勧めします。後継者に自社株をまとめて承継することで、後継者の納税資金は不足しないか、ご確認ください。相続時、誰がいくらの生命保険金を受取ることになっているかもご確認ください。また、遺言の作成がまだの方は、遺言を作成することをお勧めします。すでに遺言を作成されている方も、この機会に遺言の内容をご確認いただくことをお進めします。","相続税の納税が困難となる可能性が高いです。\n5つの質問にお答えいただくだけで、お客様ごとの『納税資金確保ToDoリスト』が取得できます。\n併せて、相続で失敗しないために必要な情報を定期的にお渡ししておりますので、以下のURLからご確認ください。","https://keishisha.typeform.com/to/oHQ1wK1i"]
[3,null,"NO\n(流動性>=50)"," (流動性-保険)<50","YES",{"$f":"IF($B$14<50%,\"\",IF($C$10<50%,\"〇\",\"\"))","v":{"$error":"#DIV/0!"}},"流動性資産の割合が高いです。\n生命保険金の額が多いので、保険金受取人について確認しておきましょう。","この簡易診断では、相続税の納税と遺産分割のための流動性資金は確保できていると思われます。しかし、生命保険金受取人の指定次第では、課題が生じる可能性もありますので、これを機会にご確認いただくことをお勧めします。遺言の作成がまだの方は、遺言を作成することをお勧めします。すでに遺言を作成されている方も、この機会に遺言の内容をご確認いただくことをお勧めします。","現時点では相続税の納税と遺産分割のための流動性資金は確保できていると思われます。\n今後、資産の状況が変化すると、相続への備えが必要となります。\n“相続で失敗しないために必要な情報”をLINE公式アカウントより定期的にお渡ししておりますので、ぜひこちらからご登録ください。","http://go.pardot.com/l/932253/2022-06-23/3t7xy"]
[4,null,"NO\n(流動性>=50)",null,"NO",{"$f":"IF($B$14<50%,\"\",IF($C$10<50%,\"\",\"〇\"))","v":{"$error":"#DIV/0!"}},"流動資産の比率が高いです。","この簡易診断では、相続税の納税と遺産分割のための流動性資金は確保できていると思われます。万全を期すためにも、この機会に生命保険金受取人を確認し、遺言の作成がまだの方は、遺言を作成することをお勧めします。すでに遺言を作成されている方も、この機会に遺言の内容をご確認いただくことをお勧めします。","現時点では相続税の納税と遺産分割のための流動性資金は確保できていると思われます。\n今後、資産の状況が変化すると、相続への備えが必要となります。\n“相続で失敗しないために必要な情報”をLINE公式アカウントより定期的にお渡ししておりますので、ぜひこちらからご登録ください。","http://go.pardot.com/l/932253/2022-06-23/3t7xy"]
[]
["流動資産",null,null,null,null,"判定コード"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"入力シート!D9","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(F2=\"〇\",A2,IF(F3=\"〇\",A3,IF(F4=\"〇\",A4,IF(F5=\"〇\",A5,\"\"))))","v":{"$error":"#DIV/0!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"入力シート!D10","v":{"$error":"#DIV/0!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"入力シート!D11","v":{"$error":"#DIV/0!"}},{"$f":"入力シート!D11","v":{"$error":"#DIV/0!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"入力シート!D12","v":{"$error":"#DIV/0!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
["合計",{"$f":"SUM(B8:B13)","v":{"$error":"#DIV/0!"}},{"$f":"IF(B14=0,3000,IF(B14<50%,\"1000\",\"2000\"))","v":{"$error":"#DIV/0!"}}]

{"sheet":"令和２年簡易生命表（男）","index":3,"n_rows":63,"n_cols":29,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
[null,"令和２年簡易生命表（男）　"]
[null," "]
[null,"年齢",null,"死亡率",null,"生存数",null,"死亡数",null,"定常人口",null,null,null,"平均余命",null,null,"年齢",null,"死亡率",null,"生存数",null,"死亡数",null,"定常人口",null,null,null,"平均余命"]
[]
[null,"x",null,"nqx",null,"lx",null,"ndx",null,"nLx",null,"Tx",null,"ex",null,null,"x",null,"nqx",null,"lx",null,"ndx",null,"nLx",null,"Tx",null,"ex"]
[null,0,"（週）",6.7000000000000002E-4,null,100000,null,67,null,1917,null,8163602,null,81.64,null,null,50,null,2.4499999999999999E-3,null,96936,null,237,null,96820,null,3211009,null,33.119999999999997]
[null,1,null,5.0000000000000002E-5,null,99933,null,5,null,1916,null,8161685,null,81.67,null,null,51,null,2.6900000000000001E-3,null,96699,null,260,null,96571,null,3114189,null,32.200000000000003]
[null,2,null,8.0000000000000007E-5,null,99928,null,8,null,1916,null,8159768,null,81.66,null,null,52,null,2.9399999999999999E-3,null,96440,null,283,null,96300,null,3017617,null,31.29]
[null,3,null,4.0000000000000003E-5,null,99920,null,4,null,1916,null,8157852,null,81.64,null,null,53,null,3.2200000000000002E-3,null,96156,null,310,null,96004,null,2921317,null,30.38]
[null,4,null,2.0000000000000001E-4,null,99916,null,20,null,8987,null,8155936,null,81.63,null,null,54,null,3.5599999999999998E-3,null,95846,null,341,null,95679,null,2825313,null,29.48]
[null,2,"（月）",1.2999999999999999E-4,null,99896,null,13,null,8324,null,8146949,null,81.55,null,null,55,null,3.9399999999999999E-3,null,95505,null,376,null,95320,null,2729635,null,28.58]
[null,3,null,2.9999999999999997E-4,null,99883,null,30,null,24967,null,8138625,null,81.48,null,null,56,null,4.3499999999999997E-3,null,95129,null,414,null,94925,null,2634315,null,27.69]
[null,6,null,3.6000000000000002E-4,null,99852,null,36,null,49916,null,8113658,null,81.260000000000005,null,null,57,null,4.7499999999999999E-3,null,94715,null,450,null,94493,null,2539390,null,26.81]
[null,0,"（年）",1.8400000000000001E-3,null,100000,null,184,null,99860,null,8163602,null,81.64,null,null,58,null,5.1700000000000001E-3,null,94266,null,487,null,94025,null,2444896,null,25.94]
[null,1,null,2.3000000000000001E-4,null,99816,null,23,null,99802,null,8063742,null,80.790000000000006,null,null,59,null,5.6499999999999996E-3,null,93778,null,530,null,93517,null,2350871,null,25.07]
[null,2,null,1.6000000000000001E-4,null,99793,null,16,null,99785,null,7963940,null,79.8,null,null,60,null,6.2300000000000003E-3,null,93248,null,581,null,92962,null,2257354,null,24.21]
[null,3,null,1.1E-4,null,99777,null,11,null,99771,null,7864155,null,78.819999999999993,null,null,61,null,6.8999999999999999E-3,null,92668,null,639,null,92353,null,2164391,null,23.36]
[null,4,null,8.0000000000000007E-5,null,99766,null,8,null,99762,null,7764384,null,77.83,null,null,62,null,7.6400000000000001E-3,null,92028,null,703,null,91682,null,2072038,null,22.52]
[null,5,null,6.0000000000000002E-5,null,99758,null,6,null,99755,null,7664622,null,76.83,null,null,63,null,8.4100000000000008E-3,null,91326,null,768,null,90947,null,1980356,null,21.68]
[null,6,null,6.0000000000000002E-5,null,99751,null,6,null,99749,null,7564868,null,75.84,null,null,64,null,9.2300000000000004E-3,null,90558,null,836,null,90145,null,1889409,null,20.86]
[null,7,null,6.0000000000000002E-5,null,99746,null,6,null,99743,null,7465119,null,74.84,null,null,65,null,1.0109999999999999E-2,null,89722,null,907,null,89274,null,1799263,null,20.05]
[null,8,null,5.0000000000000002E-5,null,99740,null,5,null,99737,null,7365376,null,73.849999999999994,null,null,66,null,1.1129999999999999E-2,null,88815,null,988,null,88328,null,1709989,null,19.25]
[null,9,null,5.0000000000000002E-5,null,99735,null,5,null,99732,null,7265639,null,72.849999999999994,null,null,67,null,1.2330000000000001E-2,null,87826,null,1083,null,87293,null,1621661,null,18.46]
[null,10,null,6.0000000000000002E-5,null,99729,null,6,null,99726,null,7165907,null,71.849999999999994,null,null,68,null,1.3690000000000001E-2,null,86743,null,1187,null,86158,null,1534368,null,17.690000000000001]
[null,11,null,6.9999999999999994E-5,null,99723,null,7,null,99720,null,7066181,null,70.86,null,null,69,null,1.5180000000000001E-2,null,85556,null,1299,null,84916,null,1448210,null,16.93]
[null,12,null,9.0000000000000006E-5,null,99716,null,9,null,99712,null,6966461,null,69.86,null,null,70,null,1.6760000000000001E-2,null,84257,null,1412,null,83560,null,1363294,null,16.18]
[null,13,null,1.1E-4,null,99707,null,11,null,99702,null,6866749,null,68.87,null,null,71,null,1.83E-2,null,82845,null,1516,null,82095,null,1279734,null,15.45]
[null,14,null,1.3999999999999999E-4,null,99697,null,14,null,99690,null,6767047,null,67.88,null,null,72,null,1.9900000000000001E-2,null,81329,null,1618,null,80528,null,1197639,null,14.73]
[null,15,null,1.8000000000000001E-4,null,99683,null,18,null,99675,null,6667356,null,66.89,null,null,73,null,2.1749999999999999E-2,null,79710,null,1734,null,78854,null,1117111,null,14.01]
[null,16,null,2.3000000000000001E-4,null,99665,null,23,null,99654,null,6567682,null,65.900000000000006,null,null,74,null,2.393E-2,null,77976,null,1866,null,77055,null,1038257,null,13.32]
[null,17,null,2.7999999999999998E-4,null,99643,null,28,null,99629,null,6468027,null,64.91,null,null,75,null,2.6419999999999999E-2,null,76110,null,2011,null,75117,null,961202,null,12.63]
[null,18,null,3.3E-4,null,99615,null,33,null,99599,null,6368398,null,63.93,null,null,76,null,2.913E-2,null,74100,null,2158,null,73033,null,886085,null,11.96]
[null,19,null,3.8000000000000002E-4,null,99582,null,38,null,99564,null,6268799,null,62.95,null,null,77,null,3.2070000000000001E-2,null,71941,null,2307,null,70800,null,813052,null,11.3]
[null,20,null,4.2999999999999999E-4,null,99545,null,43,null,99524,null,6169235,null,61.97,null,null,78,null,3.5209999999999998E-2,null,69634,null,2452,null,68421,null,742252,null,10.66]
[null,21,null,4.8000000000000001E-4,null,99502,null,48,null,99478,null,6069712,null,61,null,null,79,null,3.8940000000000002E-2,null,67183,null,2616,null,65889,null,673831,null,10.029999999999999]
[null,22,null,5.1000000000000004E-4,null,99454,null,51,null,99429,null,5970234,null,60.03,null,null,80,null,4.3439999999999999E-2,null,64567,null,2805,null,63181,null,607942,null,9.42]
[null,23,null,5.1000000000000004E-4,null,99403,null,51,null,99377,null,5870805,null,59.06,null,null,81,null,4.8710000000000003E-2,null,61762,null,3009,null,60275,null,544761,null,8.82]
[null,24,null,5.0000000000000001E-4,null,99352,null,50,null,99327,null,5771428,null,58.09,null,null,82,null,5.4809999999999998E-2,null,58753,null,3220,null,57161,null,484486,null,8.25]
[null,25,null,4.8999999999999998E-4,null,99302,null,49,null,99278,null,5672101,null,57.12,null,null,83,null,6.1679999999999999E-2,null,55533,null,3425,null,53837,null,427326,null,7.69]
[null,26,null,4.8999999999999998E-4,null,99253,null,48,null,99229,null,5572823,null,56.15,null,null,84,null,6.9550000000000001E-2,null,52108,null,3624,null,50312,null,373488,null,7.17]
[null,27,null,4.8999999999999998E-4,null,99205,null,49,null,99181,null,5473594,null,55.17,null,null,85,null,7.8560000000000005E-2,null,48484,null,3809,null,46594,null,323177,null,6.67]
[null,28,null,5.0000000000000001E-4,null,99156,null,49,null,99132,null,5374414,null,54.2,null,null,86,null,8.8849999999999998E-2,null,44675,null,3969,null,42702,null,276583,null,6.19]
[null,29,null,5.0000000000000001E-4,null,99107,null,50,null,99082,null,5275282,null,53.23,null,null,87,null,0.10034,null,40706,null,4084,null,38671,null,233881,null,5.75]
[null,30,null,5.1999999999999995E-4,null,99057,null,52,null,99031,null,5176200,null,52.25,null,null,88,null,0.11305999999999999,null,36621,null,4140,null,34553,null,195210,null,5.33]
[null,31,null,5.5999999999999995E-4,null,99005,null,55,null,98978,null,5077169,null,51.28,null,null,89,null,0.12676999999999999,null,32481,null,4118,null,30416,null,160658,null,4.95]
[null,32,null,5.9999999999999995E-4,null,98950,null,60,null,98920,null,4978191,null,50.31,null,null,90,null,0.14104,null,28363,null,4000,null,26348,null,130241,null,4.59]
[null,33,null,6.4999999999999997E-4,null,98890,null,64,null,98858,null,4879271,null,49.34,null,null,91,null,0.15353,null,24363,null,3740,null,22469,null,103893,null,4.26]
[null,34,null,6.8000000000000005E-4,null,98826,null,67,null,98793,null,4780413,null,48.37,null,null,92,null,0.16869999999999999,null,20622,null,3479,null,18860,null,81425,null,3.95]
[null,35,null,7.1000000000000002E-4,null,98759,null,70,null,98724,null,4681620,null,47.4,null,null,93,null,0.18531,null,17143,null,3177,null,15528,null,62565,null,3.65]
[null,36,null,7.2000000000000005E-4,null,98689,null,71,null,98654,null,4582896,null,46.44,null,null,94,null,0.20344999999999999,null,13966,null,2842,null,12517,null,47037,null,3.37]
[null,37,null,7.3999999999999999E-4,null,98618,null,73,null,98582,null,4484242,null,45.47,null,null,95,null,0.22320999999999999,null,11125,null,2483,null,9853,null,34520,null,3.1]
[null,38,null,7.7999999999999999E-4,null,98545,null,77,null,98507,null,4385661,null,44.5,null,null,96,null,0.24467,null,8642,null,2114,null,7554,null,24667,null,2.85]
[null,39,null,8.4999999999999995E-4,null,98468,null,83,null,98427,null,4287154,null,43.54,null,null,97,null,0.26790999999999998,null,6527,null,1749,null,5623,null,17114,null,2.62]
[null,40,null,9.3000000000000005E-4,null,98385,null,92,null,98340,null,4188726,null,42.57,null,null,98,null,0.29299999999999998,null,4779,null,1400,null,4050,null,11491,null,2.4]
[null,41,null,1.0300000000000001E-3,null,98293,null,101,null,98243,null,4090387,null,41.61,null,null,99,null,0.31996999999999998,null,3378,null,1081,null,2813,null,7440,null,2.2000000000000002]
[null,42,null,1.1299999999999999E-3,null,98192,null,111,null,98137,null,3992143,null,40.659999999999997,null,null,100,null,0.34883999999999998,null,2297,null,801,null,1875,null,4627,null,2.0099999999999998]
[null,43,null,1.24E-3,null,98081,null,121,null,98021,null,3894006,null,39.700000000000003,null,null,101,null,0.37959999999999999,null,1496,null,568,null,1195,null,2752,null,1.84]
[null,44,null,1.3600000000000001E-3,null,97959,null,133,null,97894,null,3795986,null,38.75,null,null,102,null,0.41220000000000001,null,928,null,383,null,723,null,1557,null,1.68]
[null,45,null,1.49E-3,null,97826,null,146,null,97754,null,3698092,null,37.799999999999997,null,null,103,null,0.44656000000000001,null,546,null,244,null,414,null,834,null,1.53]
[null,46,null,1.64E-3,null,97680,null,160,null,97601,null,3600338,null,36.86,null,null,104,null,0.48250999999999999,null,302,null,146,null,222,null,420,null,1.39]
[null,47,null,1.8E-3,null,97520,null,176,null,97433,null,3502737,null,35.92,null,null,105,"～",1,null,156,null,156,null,198,null,198,null,1.26]
[null,48,null,1.98E-3,null,97344,null,193,null,97249,null,3405303,null,34.979999999999997]
[null,49,null,2.2100000000000002E-3,null,97151,null,215,null,97046,null,3308054,null,34.049999999999997]

{"sheet":"令和２年簡易生命表（女）","index":4,"n_rows":65,"n_cols":29,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[null,"令和２年簡易生命表（女）　"]
[null," "]
[null,"年齢",null,"死亡率",null,"生存数",null,"死亡数",null,"定常人口",null,null,null,"平均余命",null,null,"年齢",null,"死亡率",null,"生存数",null,"死亡数",null,"定常人口",null,null,null,"平均余命"]
[]
[null,"x",null,"nqx",null,"lx",null,"ndx",null,"nLx",null,"Tx",null,"ex",null,null,"x",null,"nqx",null,"lx",null,"ndx",null,"nLx",null,"Tx",null,"ex"]
[null,0,"（週）",6.4000000000000005E-4,null,100000,null,64,null,1917,null,8774406,null,87.74,null,null,50,null,1.4499999999999999E-3,null,98124,null,143,null,98054,null,3805652,null,38.78]
[null,1,null,8.0000000000000007E-5,null,99936,null,8,null,1916,null,8772489,null,87.78,null,null,51,null,1.5900000000000001E-3,null,97981,null,155,null,97905,null,3707598,null,37.840000000000003]
[null,2,null,5.0000000000000002E-5,null,99927,null,5,null,1916,null,8770573,null,87.77,null,null,52,null,1.6999999999999999E-3,null,97826,null,167,null,97744,null,3609693,null,36.9]
[null,3,null,6.0000000000000002E-5,null,99923,null,6,null,1916,null,8768657,null,87.75,null,null,53,null,1.81E-3,null,97660,null,177,null,97572,null,3511949,null,35.96]
[null,4,null,1.6000000000000001E-4,null,99917,null,16,null,8987,null,8766740,null,87.74,null,null,54,null,1.9300000000000001E-3,null,97483,null,188,null,97390,null,3414377,null,35.03]
[null,2,"（月）",1.2E-4,null,99901,null,12,null,8325,null,8757753,null,87.66,null,null,55,null,2.0500000000000002E-3,null,97295,null,200,null,97196,null,3316987,null,34.090000000000003]
[null,3,null,2.7999999999999998E-4,null,99889,null,28,null,24969,null,8749429,null,87.59,null,null,56,null,2.1900000000000001E-3,null,97095,null,213,null,96990,null,3219791,null,33.159999999999997]
[null,6,null,3.3E-4,null,99861,null,33,null,49921,null,8724460,null,87.37,null,null,57,null,2.3400000000000001E-3,null,96882,null,226,null,96770,null,3122801,null,32.229999999999997]
[null,0,"（年）",1.72E-3,null,100000,null,172,null,99868,null,8774406,null,87.74,null,null,58,null,2.48E-3,null,96656,null,239,null,96537,null,3026030,null,31.31]
[null,1,null,1.6000000000000001E-4,null,99828,null,16,null,99817,null,8674539,null,86.89,null,null,59,null,2.63E-3,null,96417,null,253,null,96291,null,2929493,null,30.38]
[null,2,null,1.2E-4,null,99812,null,12,null,99807,null,8574722,null,85.91,null,null,60,null,2.81E-3,null,96163,null,270,null,96030,null,2833202,null,29.46]
[null,3,null,9.0000000000000006E-5,null,99800,null,9,null,99796,null,8474915,null,84.92,null,null,61,null,3.0500000000000002E-3,null,95893,null,292,null,95749,null,2737172,null,28.54]
[null,4,null,6.9999999999999994E-5,null,99792,null,7,null,99788,null,8375119,null,83.93,null,null,62,null,3.3300000000000001E-3,null,95600,null,318,null,95444,null,2641423,null,27.63]
[null,5,null,6.9999999999999994E-5,null,99785,null,7,null,99781,null,8275331,null,82.93,null,null,63,null,3.5999999999999999E-3,null,95282,null,343,null,95113,null,2545980,null,26.72]
[null,6,null,6.9999999999999994E-5,null,99778,null,7,null,99775,null,8175549,null,81.94,null,null,64,null,3.8999999999999998E-3,null,94939,null,370,null,94756,null,2450867,null,25.82]
[null,7,null,6.0000000000000002E-5,null,99771,null,6,null,99768,null,8075775,null,80.94,null,null,65,null,4.2199999999999998E-3,null,94569,null,399,null,94372,null,2356111,null,24.91]
[null,8,null,6.0000000000000002E-5,null,99765,null,6,null,99762,null,7976006,null,79.95,null,null,66,null,4.5900000000000003E-3,null,94170,null,432,null,93957,null,2261738,null,24.02]
[null,9,null,5.0000000000000002E-5,null,99759,null,5,null,99756,null,7876244,null,78.95,null,null,67,null,5.0299999999999997E-3,null,93738,null,471,null,93506,null,2167781,null,23.13]
[null,10,null,5.0000000000000002E-5,null,99754,null,5,null,99751,null,7776488,null,77.959999999999994,null,null,68,null,5.5399999999999998E-3,null,93267,null,516,null,93013,null,2074275,null,22.24]
[null,11,null,6.0000000000000002E-5,null,99748,null,6,null,99745,null,7676737,null,76.959999999999994,null,null,69,null,6.1199999999999996E-3,null,92751,null,568,null,92471,null,1981262,null,21.36]
[null,12,null,6.9999999999999994E-5,null,99742,null,7,null,99739,null,7576992,null,75.97,null,null,70,null,6.79E-3,null,92183,null,626,null,91875,null,1888791,null,20.49]
[null,13,null,8.0000000000000007E-5,null,99736,null,8,null,99732,null,7477253,null,74.97,null,null,71,null,7.4999999999999997E-3,null,91557,null,686,null,91219,null,1796916,null,19.63]
[null,14,null,9.0000000000000006E-5,null,99728,null,9,null,99723,null,7377521,null,73.98,null,null,72,null,8.2500000000000004E-3,null,90871,null,749,null,90501,null,1705697,null,18.77]
[null,15,null,1.1E-4,null,99719,null,11,null,99713,null,7277798,null,72.98,null,null,73,null,9.1000000000000004E-3,null,90121,null,820,null,89717,null,1615196,null,17.920000000000002]
[null,16,null,1.3999999999999999E-4,null,99707,null,14,null,99701,null,7178084,null,71.989999999999995,null,null,74,null,1.0070000000000001E-2,null,89301,null,900,null,88858,null,1525479,null,17.079999999999998]
[null,17,null,1.7000000000000001E-4,null,99693,null,17,null,99685,null,7078384,null,71,null,null,75,null,1.1220000000000001E-2,null,88401,null,992,null,87914,null,1436621,null,16.25]
[null,18,null,1.9000000000000001E-4,null,99676,null,19,null,99667,null,6978699,null,70.010000000000005,null,null,76,null,1.2579999999999999E-2,null,87410,null,1100,null,86870,null,1348707,null,15.43]
[null,19,null,2.0000000000000001E-4,null,99657,null,20,null,99647,null,6879032,null,69.03,null,null,77,null,1.4239999999999999E-2,null,86310,null,1229,null,85707,null,1261838,null,14.62]
[null,20,null,2.2000000000000001E-4,null,99637,null,21,null,99626,null,6779385,null,68.040000000000006,null,null,78,null,1.618E-2,null,85081,null,1376,null,84406,null,1176130,null,13.82]
[null,21,null,2.3000000000000001E-4,null,99615,null,23,null,99604,null,6679759,null,67.06,null,null,79,null,1.8489999999999999E-2,null,83705,null,1548,null,82946,null,1091725,null,13.04]
[null,22,null,2.4000000000000001E-4,null,99593,null,24,null,99581,null,6580155,null,66.069999999999993,null,null,80,null,2.1170000000000001E-2,null,82156,null,1739,null,81304,null,1008779,null,12.28]
[null,23,null,2.5000000000000001E-4,null,99569,null,25,null,99556,null,6480574,null,65.09,null,null,81,null,2.4240000000000001E-2,null,80417,null,1949,null,79461,null,927475,null,11.53]
[null,24,null,2.5000000000000001E-4,null,99544,null,25,null,99532,null,6381017,null,64.099999999999994,null,null,82,null,2.7859999999999999E-2,null,78468,null,2186,null,77395,null,848014,null,10.81]
[null,25,null,2.5000000000000001E-4,null,99519,null,25,null,99507,null,6281486,null,63.12,null,null,83,null,3.2129999999999999E-2,null,76282,null,2451,null,75079,null,770619,null,10.1]
[null,26,null,2.5999999999999998E-4,null,99494,null,26,null,99481,null,6181979,null,62.13,null,null,84,null,3.7130000000000003E-2,null,73831,null,2741,null,72485,null,695540,null,9.42]
[null,27,null,2.5999999999999998E-4,null,99468,null,26,null,99455,null,6082498,null,61.15,null,null,85,null,4.2950000000000002E-2,null,71090,null,3053,null,69590,null,623054,null,8.76]
[null,28,null,2.7E-4,null,99442,null,27,null,99429,null,5983042,null,60.17,null,null,86,null,4.9680000000000002E-2,null,68036,null,3380,null,66374,null,553465,null,8.1300000000000008]
[null,29,null,2.7999999999999998E-4,null,99416,null,27,null,99402,null,5883613,null,59.18,null,null,87,null,5.747E-2,null,64657,null,3716,null,62827,null,487090,null,7.53]
[null,30,null,2.7999999999999998E-4,null,99388,null,27,null,99374,null,5784212,null,58.2,null,null,88,null,6.6689999999999999E-2,null,60941,null,4064,null,58938,null,424263,null,6.96]
[null,31,null,2.7999999999999998E-4,null,99361,null,28,null,99347,null,5684837,null,57.21,null,null,89,null,7.7259999999999995E-2,null,56877,null,4395,null,54705,null,365326,null,6.42]
[null,32,null,2.9E-4,null,99333,null,29,null,99319,null,5585490,null,56.23,null,null,90,null,8.8800000000000004E-2,null,52482,null,4660,null,50171,null,310620,null,5.92]
[null,33,null,3.1E-4,null,99305,null,31,null,99289,null,5486171,null,55.25,null,null,91,null,0.10113,null,47822,null,4836,null,45415,null,260449,null,5.45]
[null,34,null,3.5E-4,null,99274,null,35,null,99257,null,5386881,null,54.26,null,null,92,null,0.11446000000000001,null,42986,null,4920,null,40529,null,215034,null,5]
[null,35,null,3.8999999999999999E-4,null,99239,null,39,null,99220,null,5287625,null,53.28,null,null,93,null,0.12914,null,38066,null,4916,null,35603,null,174505,null,4.58]
[null,36,null,4.2999999999999999E-4,null,99200,null,43,null,99179,null,5188405,null,52.3,null,null,94,null,0.14480999999999999,null,33150,null,4801,null,30739,null,138902,null,4.1900000000000004]
[null,37,null,4.6999999999999999E-4,null,99157,null,46,null,99134,null,5089226,null,51.32,null,null,95,null,0.16607,null,28349,null,4708,null,25983,null,108163,null,3.82]
[null,38,null,5.0000000000000001E-4,null,99111,null,50,null,99086,null,4990092,null,50.35,null,null,96,null,0.18745000000000001,null,23642,null,4432,null,21397,null,82179,null,3.48]
[null,39,null,5.4000000000000001E-4,null,99061,null,54,null,99035,null,4891006,null,49.37,null,null,97,null,0.21063999999999999,null,19210,null,4046,null,17151,null,60782,null,3.16]
[null,40,null,5.8E-4,null,99007,null,58,null,98979,null,4791971,null,48.4,null,null,98,null,0.23573,null,15164,null,3574,null,13334,null,43632,null,2.88]
[null,41,null,6.3000000000000003E-4,null,98949,null,62,null,98919,null,4692993,null,47.43,null,null,99,null,0.26275999999999999,null,11589,null,3045,null,10021,null,30297,null,2.61]
[null,42,null,6.8000000000000005E-4,null,98887,null,67,null,98854,null,4594074,null,46.46,null,null,100,null,0.29176999999999997,null,8544,null,2493,null,7251,null,20276,null,2.37]
[null,43,null,7.3999999999999999E-4,null,98820,null,73,null,98784,null,4495220,null,45.49,null,null,101,null,0.32278000000000001,null,6051,null,1953,null,5031,null,13025,null,2.15]
[null,44,null,8.1999999999999998E-4,null,98747,null,81,null,98707,null,4396436,null,44.52,null,null,102,null,0.35576000000000002,null,4098,null,1458,null,3330,null,7994,null,1.95]
[null,45,null,9.1E-4,null,98666,null,90,null,98622,null,4297729,null,43.56,null,null,103,null,0.39063999999999999,null,2640,null,1031,null,2092,null,4664,null,1.77]
[null,46,null,1E-3,null,98576,null,98,null,98528,null,4199108,null,42.6,null,null,104,null,0.42731999999999998,null,1609,null,687,null,1240,null,2572,null,1.6]
[null,47,null,1.09E-3,null,98478,null,107,null,98425,null,4100580,null,41.64,null,null,105,"～",1,null,921,null,921,null,1332,null,1332,null,1.45]
[null,48,null,1.1900000000000001E-3,null,98371,null,117,null,98313,null,4002155,null,40.68]
[null,49,null,1.32E-3,null,98254,null,130,null,98190,null,3903842,null,39.729999999999997]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（２－２）"]