{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["入力シート","保存データ","ロジック"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[22,5,22,10],[6,5,6,10],[6,1,7,2],[6,11,7,12],[1,1,2,1],[1,2,2,2],[1,5,1,10],[1,11,2,11],[19,1,19,12]]}
[]
[null,"担当者名","お客様名",null,null,"相続人",null,null,null,null,null,"相続人数"]
[null,null,null,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(F4:K4)","v":0}]
[]
[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,{"$f":"IF(F4=\"\",\"\",F4)","v":""},{"$f":"IF(G4=\"\",\"\",G4)","v":""},"","","",""]
[null,"現金・預貯金",null,{"$f":"C9/SUM($C$9:$C$14)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D9*100,0)*3","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"借入金",null,{"$f":"M9/SUM($M$9:$M$15)","v":{"$error":"#DIV/0!"}},{"$f":"N9*$E$15","v":{"$error":"#DIV/0!"}}]
[null,"有価証券",null,{"$f":"C10/SUM($C$9:$C$14)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D10*100,0)*3","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,{"$f":"M10/SUM($M$9:$M$15)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(N10*100,0)*2","v":{"$error":"#DIV/0!"}}]
[null,"生命保険",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"自社株",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"不動産",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"その他",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$f":"N14*$E$15","v":{"$error":"#DIV/0!"}}]
[null,"資産合計",{"$f":"SUM(C9:C14)","v":0},null,{"$f":"SUM(E9:E14)","v":{"$error":"#DIV/0!"}},{"$f":"IF(COUNTBLANK(F9:F14)=6,\"\",SUM(F9:F14))","v":""},{"$f":"IF(COUNTBLANK(G9:G14)=6,\"\",SUM(G9:G14))","v":""},"","","","","純資産",{"$f":"C15-M9","v":0},{"$error":"#DIV/0!"},{"$f":"N15*$E$15","v":{"$error":"#DIV/0!"}}]
[]
[null,"金額を入力後、【実行】ボタンを押してください"]
[]
[null,{"$f":"IF($A$19=\"\",\"\",VLOOKUP($A$19,判定,2,FALSE))","v":""}]
[{"$f":"ロジック!F8","v":{"$error":"#DIV/0!"}},{"$f":"IF($A$19=\"\",\"\",VLOOKUP($A$19,判定,3,FALSE))","v":""}]
[]
[]
[null,"資産",null,null,null,"承継者"]
[null,null,"資産",null,null,{"$f":"IF(F4=\"\",\"\",F4)","v":""},{"$f":"IF(G4=\"\",\"\",G4)","v":""},"","","",""]
[null,"流動資産","流動資産",null,null,{"$f":"SUM(F9:F11)","v":0},{"$f":"SUM(G9:G11)","v":0},0,0,0,0]
[null,"固定資産","固定資産",null,null,{"$f":"SUM(F12:F14)","v":0},{"$f":"SUM(G12:G14)","v":0},0,0,0,0]
[null,"その他","資産合計",null,null,{"$f":"F15","v":""},"","","","",""]

{"sheet":"保存データ","index":1,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["No.","担当者","お客様氏名","相続人数","現金・預貯金","有価証券","生命保険","自社株","不動産","その他","借入金","純資産","Code"]

{"sheet":"ロジック","index":2,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,1,4,1],[1,3,2,3],[3,3,4,3]]}
["Code","条件１","状況","条件２","状況",null,"判定","判定（詳細）"]
[1,"流動性<50","YES","自社株割合>40","YES",{"$f":"IF($B$14<50%,IF($C$11>40%,\"〇\",\"\"),\"\")","v":{"$error":"#DIV/0!"}},"相続税納税資金の準備、相続時の遺産分割について、対策のご検討をお勧めします。","後継者に自社株をまとめて承継すると、後継者の相続税の納税資金が不足する可能性があります。また、後継者以外の相続人への遺産分割についても課題があると思われます。これを機会に具体的に対策のご検討を始められることをお勧めします。また、遺言の作成がまだの方は、遺言を作成することをお勧めします。すでに遺言を作成されている方も、この機会に遺言の内容をご確認いただくことをお進めします。"]
[2,null,"YES",null,"NO",{"$f":"IF($B$14<50%,IF($C$11>40%,\"\",\"〇\"),\"\")","v":{"$error":"#DIV/0!"}},"相続時の遺産分割のご希望をふまえて、相続税の納税資金と遺産分割に課題がないかご確認ください。","流動性資産の比率が低いため、遺産分割と相続税の納税に課題があるかもしれません。この機会にご確認いただくことをお勧めします。後継者に自社株をまとめて承継することで、後継者の納税資金は不足しないか、ご確認ください。相続時、誰がいくらの生命保険金を受取ることになっているかもご確認ください。また、遺言の作成がまだの方は、遺言を作成することをお勧めします。すでに遺言を作成されている方も、この機会に遺言の内容をご確認いただくことをお進めします。"]
[3,null,"NO\n(流動性>=50)"," (流動性-保険)<50","YES",{"$f":"IF($B$14<50%,\"\",IF($C$10<50%,\"〇\",\"\"))","v":{"$error":"#DIV/0!"}},"流動性資産の割合が高いです。生命保険金の額が多いので、保険金受取人について確認しておきましょう","この簡易診断では、相続税の納税と遺産分割のための流動性資金は確保できていると思われます。しかし、生命保険金受取人の指定次第では、課題が生じる可能性もありますので、これを機会にご確認いただくことをお勧めします。遺言の作成がまだの方は、遺言を作成することをお勧めします。すでに遺言を作成されている方も、この機会に遺言の内容をご確認いただくことをお勧めします。"]
[4,null,"NO\n(流動性>=50)",null,"NO",{"$f":"IF($B$14<50%,\"\",IF($C$10<50%,\"\",\"〇\"))","v":{"$error":"#DIV/0!"}},"流動資産の比率が高いです。","この簡易診断では、相続税の納税と遺産分割のための流動性資金は確保できていると思われます。万全を期すためにも、この機会に生命保険金受取人を確認し、遺言の作成がまだの方は、遺言を作成することをお勧めします。すでに遺言を作成されている方も、この機会に遺言の内容をご確認いただくことをお勧めします。"]
[]
["流動資産",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!"}}]