{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["【Ａタイプ】入力シート ","【Ａタイプ】被保険者控作成","【Ｂタイプ】入力シート ","【Bタイプ】被保険者控作成","保険料表"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":67,"n_cols":25,"rows_kept":67,"cut":false,"hidden":false,"merged":[[64,0,67,1],[64,2,67,2],[64,3,67,3],[64,4,67,5],[64,6,67,6],[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,4,63,5],[62,6,63,6],[60,1,61,1],[60,2,61,2],[60,3,61,3],[60,4,61,5],[60,6,61,6],[58,1,59,1],[58,2,59,2],[58,3,59,3],[58,4,59,5],[58,6,59,6],[55,1,55,13],[56,1,57,1],[56,2,57,2],[56,3,57,3],[56,4,57,5],[56,6,57,6],[53,4,53,6],[53,8,53,9],[54,4,54,6],[54,8,54,9],[48,4,48,6],[48,8,48,9],[45,4,45,6],[45,8,45,9],[46,4,46,6],[46,8,46,9],[51,4,51,6],[51,8,51,9],[52,4,52,6],[52,8,52,9],[49,4,49,6],[49,8,49,9],[50,4,50,6],[50,8,50,9],[44,4,44,6],[44,8,44,9],[41,4,41,6],[41,8,41,9],[42,4,42,6],[42,8,42,9],[46,12,46,14],[47,4,47,6],[47,8,47,9],[39,4,39,6],[39,8,39,9],[40,4,40,6],[40,8,40,9],[37,4,37,6],[37,8,37,9],[38,4,38,6],[38,8,38,9],[43,4,43,6],[43,8,43,9],[32,4,32,6],[32,8,32,9],[29,4,29,6],[29,8,29,9],[30,4,30,6],[30,8,30,9],[35,4,35,6],[35,8,35,9],[36,4,36,6],[36,8,36,9],[33,4,33,6],[33,8,33,9],[34,4,34,6],[34,8,34,9],[27,4,27,6],[27,8,27,9],[28,4,28,6],[28,8,28,9],[25,4,25,6],[25,8,25,9],[26,4,26,6],[26,8,26,9],[31,4,31,6],[31,8,31,9],[22,15,24,39],[23,4,23,6],[23,8,23,9],[24,4,24,6],[24,8,24,9],[21,4,21,6],[21,8,21,9],[22,4,22,6],[22,8,22,9],[13,15,13,39],[14,4,14,6],[14,8,14,9],[14,15,14,39],[19,4,19,6],[19,8,19,9],[20,4,20,6],[20,8,20,9],[15,15,15,16],[16,4,16,6],[16,8,16,9],[16,15,16,16],[15,4,15,6],[15,8,15,9],[2,1,2,3],[2,4,2,9],[2,11,2,12],[4,1,5,2],[4,3,5,8],[4,9,5,10],[4,11,4,13],[5,11,5,13],[8,1,9,2],[8,3,9,13],[58,9,59,10],[58,12,59,13],[59,7,59,8],[60,9,60,13],[6,1,7,2],[6,3,7,4],[6,5,7,6],[6,7,7,9],[6,10,7,11],[6,12,7,13],[10,8,10,10],[10,11,10,13],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,6],[12,7,13,7],[17,4,17,6],[17,8,17,9],[18,4,18,6],[18,8,18,9],[12,8,12,9],[12,10,13,10],[13,8,13,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"黄色部分をもれなくご入力ください（※保険料等は自動計算されます。）"]
[]
[null,"Ａタイプ用",null,null,"被保険者一覧表は必ず【アライブ】に【郵送】にてご提出ください。\n書類をご提出いただけませんと、ご加入のお手続きが完了しません。",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,"電話：03-3479-4334",null,null,null,null,null,"FAX:03-3479-5322"]
[]
[null,"郵便番号",null,null,null,"電話番号",null,null,null,null,"FAX番号",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,"〒107-0062　東京都港区南青山2-2-6-901"]
[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,null,null,"合計",null,null,null,null,null,null,"級別欄には、職員の方で自動車運転者（送迎等）専門の方はＢと入力ください。"]
[null,"例","2022-05-01","Ａ1","損保　一郎",null,null,"A",5000,null,null,null,null,null,null,"それ以外の職員・利用者の方はＡと入力ください。"]
[null,1,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C16,保険料表!$G$2:$K$14,MATCH(D16,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,2,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C17,保険料表!$G$2:$K$14,MATCH(D17,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,3,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C18,保険料表!$G$2:$K$14,MATCH(D18,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,4,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C19,保険料表!$G$2:$K$14,MATCH(D19,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,5,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C20,保険料表!$G$2:$K$14,MATCH(D20,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,6,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C21,保険料表!$G$2:$K$14,MATCH(D21,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,7,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C22,保険料表!$G$2:$K$14,MATCH(D22,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,8,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C23,保険料表!$G$2:$K$14,MATCH(D23,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"あんしん利用総合補償制度被保険者一覧表の使用方法について"]
[null,9,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C24,保険料表!$G$2:$K$14,MATCH(D24,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,10,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C25,保険料表!$G$2:$K$14,MATCH(D25,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,11,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C26,保険料表!$G$2:$K$14,MATCH(D26,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,12,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C27,保険料表!$G$2:$K$14,MATCH(D27,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"◆新規・継続でお申し込みいただく場合"]
[null,13,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C28,保険料表!$G$2:$K$14,MATCH(D28,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"被保険者一覧表に必要事項をご入力のうえ、印刷をしてください。"]
[null,14,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C29,保険料表!$G$2:$K$14,MATCH(D29,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"被保険者一覧表の原本は、同封の返信用封筒にて代理店アライブにお送りください。"]
[null,15,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C30,保険料表!$G$2:$K$14,MATCH(D30,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"控えがありませんので、原本を必ずコピーして事業所様控えとして保管ください。"]
[null,16,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C31,保険料表!$G$2:$K$14,MATCH(D31,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,17,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C32,保険料表!$G$2:$K$14,MATCH(D32,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"印刷後、提出前に記入誤りに気付いた場合は、その行を波線で削除し、次の行に記入してください。訂正印は不要です。"]
[null,18,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C33,保険料表!$G$2:$K$14,MATCH(D33,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"被保険者一覧表の行が足りない場合は、新しいシートをコピーして入力をしてください。"]
[null,19,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C34,保険料表!$G$2:$K$14,MATCH(D34,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"枝番はシートごとに管理をしますので、新しいシートを追加した場合もそのままにしてください。"]
[null,20,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C35,保険料表!$G$2:$K$14,MATCH(D35,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,21,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C36,保険料表!$G$2:$K$14,MATCH(D36,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"◆中途加入をする場合（入力シートに入力ください。）"]
[null,22,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C37,保険料表!$G$2:$K$14,MATCH(D37,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"ご加入時に作成いただいたエクセル版の「被保険者一覧表」に新しくご加入される方の開始日・タイプ・お名前・級別を入力のうえ、"]
[null,23,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C38,保険料表!$G$2:$K$14,MATCH(D38,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"プリントしていただきアライブへＦＡＸをお願いいたします。"]
[null,24,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C39,保険料表!$G$2:$K$14,MATCH(D39,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,25,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C40,保険料表!$G$2:$K$14,MATCH(D40,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"◆中途脱退をする場合（入力シートにご入力ください。）"]
[null,26,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C41,保険料表!$G$2:$K$14,MATCH(D41,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"ご加入時に作成いただいたエクセル版の「被保険者一覧表」に脱退される方の解約日を入力のうえ、プリントしていただき"]
[null,27,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C42,保険料表!$G$2:$K$14,MATCH(D42,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"アライブへＦＡＸをお願いいたします。"]
[null,28,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C43,保険料表!$G$2:$K$14,MATCH(D43,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,29,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C44,保険料表!$G$2:$K$14,MATCH(D44,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"※中途加入・中途脱退の詳しい内容は「あんしん利用総合補償制度のご案内」の7ページ〈2〉をご覧ください。"]
[null,30,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C45,保険料表!$G$2:$K$14,MATCH(D45,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,31,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C46,保険料表!$G$2:$K$14,MATCH(D46,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,32,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C47,保険料表!$G$2:$K$14,MATCH(D47,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"【注意事項】"]
[null,33,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C48,保険料表!$G$2:$K$14,MATCH(D48,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"・本被保険者一覧表は速やかに、取扱代理店アライブへ郵送してください。"]
[null,34,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C49,保険料表!$G$2:$K$14,MATCH(D49,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,35,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C50,保険料表!$G$2:$K$14,MATCH(D50,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"・お申込み内容に変更があった場合は速やかにアライブまでご連絡ください。"]
[null,36,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C51,保険料表!$G$2:$K$14,MATCH(D51,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"　詳細につきましては、全国精神障害者福祉事業者協会のホームページを必ずご確認ください。"]
[null,37,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C52,保険料表!$G$2:$K$14,MATCH(D52,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,38,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C53,保険料表!$G$2:$K$14,MATCH(D53,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,39,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C54,保険料表!$G$2:$K$14,MATCH(D54,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,40,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C55,保険料表!$G$2:$K$14,MATCH(D55,保険料表!$G$2:$K$2,0),FALSE),\"\")","v":""}]
[null,"※申込人（加入者）および被保険者は、募集文書または損保ジャパン公式ウェブサイト（https://www.sompo-japan.co.jp/)に掲載の個人情報の取扱に同意します。"]
[null,"A1",{"$f":"COUNTIF($D$16:$D$55,B57)","v":0},"名",{"$f":"SUMIF($D$16:$D$55,B57,$I$16:$I$55)","v":0},null,"円"]
[]
[null,"A2",{"$f":"COUNTIF($D$16:$D$55,B59)","v":0},"名",{"$f":"SUMIF($D$16:$D$55,B59,$I$16:$I$55)","v":0},null,"円"]
[null,null,null,null,null,null,null,"[代理店使用欄]"]
[null,"A3",{"$f":"COUNTIF($D$16:$D$55,B61)","v":0},"名",{"$f":"SUMIF($D$16:$D$55,B61,$I$16:$I$55)","v":0},null,"円","事業所総合計　：",null,"　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　 円"]
[null,null,null,null,null,null,null,"傷害合計　：　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　  　　　　　　　円"]
[]
[null,null,null,null,null,null,null,"賠責（F）：□17,800　　□23,800　　□29,700　　□32,700　　□37,200"]
["合計",null,{"$f":"SUM(C57:C62)","v":0},"名",{"$f":"SUM(E57:F62)","v":0},null,"円","賠責（G）：　　ａ　　　　ｂ　　　　ｃ　　　　ｄ　　　　　　　　　　　　　　　　　　　　　　　　円"]
[]
[null,null,null,null,null,null,null,"動総　　　　：□20,000　　　　　　□27,000"]

{"sheet":"【Ａタイプ】被保険者控作成","index":1,"n_rows":34,"n_cols":22,"rows_kept":34,"cut":false,"hidden":false,"merged":[[27,4,27,10],[16,1,18,10],[19,1,21,9],[19,10,21,10],[24,4,26,6],[24,7,26,9],[24,10,26,10],[9,1,11,2],[9,3,11,4],[9,6,11,7],[9,8,11,10],[12,6,13,10],[6,1,7,3],[6,4,7,10],[7,13,7,20],[1,1,4,10],[1,13,1,20],[2,13,3,20],[4,13,4,20],[5,13,5,20]]}
[]
[null,"２０２６年度　あんしん利用総合補償制度 \n＜被保険者控＞",null,null,null,null,null,null,null,null,null,null,null,"Ａタイプ用"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"被保険者一覧表のお控えを被保険者の方にお渡しする場合、\n以下で印刷を行ってください。"]
[]
[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,"印刷したい方の入力シートB列の枝番を入力して印刷してください。",null,null,null,null,null,null,null,"参考"]
[null,"事業所名",null,null,{"$f":"'【Ａタイプ】入力シート '!D5","v":0},null,null,null,null,null,null,null,null,null,"枝番",1]
[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,"印刷はじめ",1,"印刷おわり",2]
[null,"タイプ",null,{"$f":"(VLOOKUP($P$7,'【Ａタイプ】入力シート '!B16:M55,3,0))","v":0},null,null,"加入日\n保険始期",null,{"$f":"(VLOOKUP($P$7,'【Ａタイプ】入力シート '!B16:M55,2,0))","v":0}]
[]
[]
[null,null,null,null,null,null,"保険終期：2027/5/1"]
[]
[]
[]
[null,"利用者・職員ご本人"]
[]
[]
[null,{"$f":"VLOOKUP($P$7,'【Ａタイプ】入力シート '!B16:M55,4,0)","v":0},null,null,null,null,null,null,null,null,"様"]
[]
[]
[]
[]
[null,null,null,null,"保険料",null,null,{"$f":"VLOOKUP($P$7,'【Ａタイプ】入力シート '!B16:J55,8,0)","v":""},null,null,"円"]
[]
[]
[null,null,null,null,"※プラン詳細はパンフレットをご確認ください。"]
[]
[]
[]
["取扱代理店　　：株式会社　アライブ"]
[]
["引受保険会社：損害保険ジャパン株式会社"]

{"sheet":"【Ｂタイプ】入力シート ","index":2,"n_rows":67,"n_cols":25,"rows_kept":67,"cut":false,"hidden":false,"merged":[[62,1,63,1],[62,2,63,2],[62,3,63,3],[62,4,63,5],[62,6,63,6],[64,0,67,1],[64,2,67,2],[64,3,67,3],[64,4,67,5],[64,6,67,6],[58,12,59,13],[59,7,59,8],[60,1,61,1],[60,2,61,2],[60,3,61,3],[60,4,61,5],[60,6,61,6],[60,9,60,13],[58,1,59,1],[58,2,59,2],[58,3,59,3],[58,4,59,5],[58,6,59,6],[58,9,59,10],[53,4,53,6],[54,4,54,6],[55,1,55,13],[56,1,57,1],[56,2,57,2],[56,3,57,3],[56,4,57,5],[56,6,57,6],[50,4,50,6],[51,4,51,6],[52,4,52,6],[46,12,46,14],[47,4,47,6],[48,4,48,6],[49,4,49,6],[44,4,44,6],[45,4,45,6],[46,4,46,6],[41,4,41,6],[42,4,42,6],[43,4,43,6],[38,4,38,6],[39,4,39,6],[40,4,40,6],[35,4,35,6],[36,4,36,6],[37,4,37,6],[32,4,32,6],[33,4,33,6],[34,4,34,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[22,15,24,39],[23,4,23,6],[24,4,24,6],[25,4,25,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[15,4,15,6],[15,15,15,16],[16,4,16,6],[16,15,16,16],[12,10,13,10],[13,15,13,39],[14,4,14,6],[14,15,14,39],[8,1,9,2],[8,3,9,13],[10,8,10,10],[10,11,10,13],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[6,1,7,2],[6,3,7,4],[6,5,7,6],[6,7,7,9],[6,10,7,11],[6,12,7,13],[2,1,2,3],[2,4,2,9],[2,11,2,12],[4,1,5,2],[4,3,5,8],[4,9,5,10],[4,11,4,13],[5,11,5,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"黄色部分をもれなくご入力ください（※保険料等は自動計算されます。）"]
[]
[null,"Bタイプ用",null,null,"被保険者一覧表は必ず【アライブ】に【郵送】にてご提出ください。\n書類をご提出いただけませんと、ご加入のお手続きが完了しません。",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,"電話：03-3479-4334",null,null,null,null,null,"FAX:03-3479-5322"]
[]
[null,"郵便番号",null,null,null,"電話番号",null,null,null,null,"FAX番号",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,"〒107-0062　東京都港区南青山2-2-6-901"]
[null,"住所",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"株式会社　アライブ"]
[]
[]
[]
[null,"枝番","開始日","タイプ","本　人",null,null,"級別","利用者、\n職員の区分","合計","解約日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"級別欄には、職員の方で自動車運転者（送迎等）専門の方はＢと入力ください。"]
[null,"例","2022-05-01","B1","損保　一郎",null,null,"A","利用者",5000,null,null,null,null,null,"それ以外の職員・利用者の方はＡと入力ください。"]
[null,1,"　　　",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C16,保険料表!$M$2:$Q$14,MATCH(D16,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,2,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C17,保険料表!$M$2:$Q$14,MATCH(D17,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,3,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C18,保険料表!$M$2:$Q$14,MATCH(D18,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,4,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C19,保険料表!$M$2:$Q$14,MATCH(D19,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,5,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C20,保険料表!$M$2:$Q$14,MATCH(D20,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,6,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C21,保険料表!$M$2:$Q$14,MATCH(D21,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,7,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C22,保険料表!$M$2:$Q$14,MATCH(D22,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,8,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C23,保険料表!$M$2:$Q$14,MATCH(D23,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"あんしん利用総合補償制度被保険者一覧表の使用方法について"]
[null,9,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C24,保険料表!$M$2:$Q$14,MATCH(D24,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,10,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C25,保険料表!$M$2:$Q$14,MATCH(D25,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,11,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C26,保険料表!$M$2:$Q$14,MATCH(D26,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,12,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C27,保険料表!$M$2:$Q$14,MATCH(D27,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"◆新規・継続でお申し込みいただく場合"]
[null,13,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C28,保険料表!$M$2:$Q$14,MATCH(D28,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"被保険者一覧表に必要事項をご入力のうえ、印刷をしてください。"]
[null,14,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C29,保険料表!$M$2:$Q$14,MATCH(D29,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"被保険者一覧表の原本は、同封の返信用封筒にて代理店アライブにお送りください。"]
[null,15,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C30,保険料表!$M$2:$Q$14,MATCH(D30,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"控えがありませんので、原本を必ずコピーして事業所様控えとして保管ください。"]
[null,16,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C31,保険料表!$M$2:$Q$14,MATCH(D31,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,17,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C32,保険料表!$M$2:$Q$14,MATCH(D32,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"印刷後、提出前に記入誤りに気付いた場合は、その行を波線で削除し、次の行に記入してください。訂正印は不要です。"]
[null,18,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C33,保険料表!$M$2:$Q$14,MATCH(D33,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"被保険者一覧表の行が足りない場合は、新しいシートをコピーして入力をしてください。"]
[null,19,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C34,保険料表!$M$2:$Q$14,MATCH(D34,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"枝番はシートごとに管理をしますので、新しいシートを追加した場合もそのままにしてください。"]
[null,20,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C35,保険料表!$M$2:$Q$14,MATCH(D35,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,21,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C36,保険料表!$M$2:$Q$14,MATCH(D36,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"◆中途加入をする場合（入力シートに入力ください。）"]
[null,22,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C37,保険料表!$M$2:$Q$14,MATCH(D37,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"ご加入時に作成いただいたエクセル版の「被保険者一覧表」に新しくご加入される方の開始日・タイプ・お名前・級別を入力のうえ、"]
[null,23,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C38,保険料表!$M$2:$Q$14,MATCH(D38,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"プリントしていただきアライブへＦＡＸをお願いいたします。"]
[null,24,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C39,保険料表!$M$2:$Q$14,MATCH(D39,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,25,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C40,保険料表!$M$2:$Q$14,MATCH(D40,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"◆中途脱退をする場合（入力シートにご入力ください。）"]
[null,26,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C41,保険料表!$M$2:$Q$14,MATCH(D41,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"ご加入時に作成いただいたエクセル版の「被保険者一覧表」に脱退される方の解約日を入力のうえ、プリントしていただき"]
[null,27,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C42,保険料表!$M$2:$Q$14,MATCH(D42,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"アライブへＦＡＸをお願いいたします。"]
[null,28,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C43,保険料表!$M$2:$Q$14,MATCH(D43,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,29,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C44,保険料表!$M$2:$Q$14,MATCH(D44,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"※中途加入・中途脱退の詳しい内容は「あんしん利用総合補償制度のご案内」の7ページ〈2〉をご覧ください。"]
[null,30,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C45,保険料表!$M$2:$Q$14,MATCH(D45,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,31,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C46,保険料表!$M$2:$Q$14,MATCH(D46,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,32,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C47,保険料表!$M$2:$Q$14,MATCH(D47,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"【注意事項】"]
[null,33,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C48,保険料表!$M$2:$Q$14,MATCH(D48,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"・本被保険者一覧表は速やかに、取扱代理店アライブへ郵送してください。"]
[null,34,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C49,保険料表!$M$2:$Q$14,MATCH(D49,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,35,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C50,保険料表!$M$2:$Q$14,MATCH(D50,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"・お申込み内容に変更があった場合は速やかにアライブまでご連絡ください。"]
[null,36,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C51,保険料表!$M$2:$Q$14,MATCH(D51,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""},null,null,null,null,null,"　詳細につきましては、全国精神障害者福祉事業者協会のホームページを必ずご確認ください。"]
[null,37,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C52,保険料表!$M$2:$Q$14,MATCH(D52,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,38,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C53,保険料表!$M$2:$Q$14,MATCH(D53,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,39,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C54,保険料表!$M$2:$Q$14,MATCH(D54,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,40,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C55,保険料表!$M$2:$Q$14,MATCH(D55,保険料表!$M$2:$Q$2,0),FALSE),\"\")","v":""}]
[null,"※申込人（加入者）および被保険者は、募集文書または損保ジャパン公式ウェブサイト（https://www.sompo-japan.co.jp/)に掲載の個人情報の取扱に同意します。"]
[null,"B1",{"$f":"COUNTIF($D$16:$D$55,B57)","v":0},"名",{"$f":"SUMIF($D$16:$D$55,B57,$J$16:$J$55)","v":0},null,"円"]
[]
[null,"B2",{"$f":"COUNTIF($D$16:$D$55,B59)","v":0},"名",{"$f":"SUMIF($D$16:$D$55,B59,$J$16:$J$55)","v":0},null,"円"]
[null,null,null,null,null,null,null,"[代理店使用欄]"]
[null,"B3",{"$f":"COUNTIF($D$16:$D$55,B61)","v":0},"名",{"$f":"SUMIF($D$16:$D$55,B61,$J$16:$J$55)","v":0},null,"円","事業所総合計　：",null,"　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　 円"]
[null,null,null,null,null,null,null,"傷害合計　：　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　  　　　　　　　円"]
[]
[null,null,null,null,null,null,null,"賠責（F）：□17,800　　□23,800　　□29,700　　□32,700　　□37,200"]
["合計",null,{"$f":"SUM(C57:C64)","v":0},"名",{"$f":"SUM(E57:F62)","v":0},null,"円","賠責（G）：　　ａ　　　　ｂ　　　　ｃ　　　　ｄ　　　　　　　　　　　　　　　　　　　　　　　　円"]
[]
[null,null,null,null,null,null,null,"動総　　　　：□20,000　　　　　　□27,000"]

{"sheet":"【Bタイプ】被保険者控作成","index":3,"n_rows":34,"n_cols":22,"rows_kept":34,"cut":false,"hidden":false,"merged":[[27,4,27,10],[9,1,11,2],[9,3,11,4],[9,6,11,7],[9,8,11,10],[12,6,13,10],[16,1,18,10],[19,1,21,9],[19,10,21,10],[24,4,26,6],[24,7,26,9],[24,10,26,10],[6,1,7,3],[6,4,7,10],[7,13,7,20],[1,1,4,10],[1,13,1,20],[2,13,3,20],[4,13,4,20],[5,13,5,20]]}
[]
[null,"２０２６年度　あんしん利用総合補償制度 \n＜被保険者控＞",null,null,null,null,null,null,null,null,null,null,null,"Bタイプ用"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"被保険者一覧表のお控えを被保険者の方にお渡しする場合、\n以下で印刷を行ってください。"]
[]
[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,"印刷したい方の入力シートB列の枝番を入力して印刷してください。",null,null,null,null,null,null,null,"参考"]
[null,"事業所名",null,null,{"$f":"'【Ｂタイプ】入力シート '!D5","v":0},null,null,null,null,null,null,null,null,null,"枝番",1]
[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,"印刷はじめ",1,"印刷おわり",40]
[null,"タイプ",null,{"$f":"(VLOOKUP($P$7,'【Ｂタイプ】入力シート '!B16:M55,3,0))","v":0},null,null,"加入日\n保険始期",null,{"$f":"(VLOOKUP($P$7,'【Ｂタイプ】入力シート '!B16:M55,2,0))","v":"　　　"}]
[]
[]
[null,null,null,null,null,null,"保険終期：2027/5/1"]
[]
[]
[]
[null,"利用者・職員ご本人"]
[]
[]
[null,{"$f":"VLOOKUP($P$7,'【Ｂタイプ】入力シート '!B16:M55,4,0)","v":0},null,null,null,null,null,null,null,null,"様"]
[]
[]
[]
[]
[null,null,null,null,"保険料",null,null,{"$f":"VLOOKUP($P$7,'【Ｂタイプ】入力シート '!B16:J55,9,0)","v":""},null,null,"円"]
[]
[]
[null,null,null,null,"※プラン詳細はパンフレットをご確認ください。"]
[]
[]
[]
["取扱代理店　　：株式会社　アライブ"]
[]
["引受保険会社：損害保険ジャパン株式会社"]

{"sheet":"保険料表","index":4,"n_rows":14,"n_cols":18,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,7,0,9],[0,13,0,15]]}
[null,null,null,null,null,null,"Ａタイプ","合計",null,null,null,null,"Ｂタイプ","合計",null,null,null,"区分"]
["級別",null,null,null,null,null,"　　　","A1","A2","A3",null,null,"　　　","B1","B2","B3",null,"利用者"]
["A",null,null,null,null,null,"5/1",5000,7000,9000,null,null,"5/1",5000,7000,9000,null,"職員"]
["B",null,null,null,null,null,"6/1",4590,6420,8250,null,null,"6/1",4580,6420,8250]
[null,null,null,null,null,null,"7/1",4170,5830,7500,null,null,"7/1",4170,5830,7500]
[null,null,null,null,null,null,"8/1",3760,5260,6750,null,null,"8/1",3750,5260,6760]
[null,null,null,null,null,null,"9/1",3330,4670,6000,null,null,"9/1",3330,4670,6000]
[null,null,null,null,null,null,"10/1",2920,4090,5250,null,null,"10/1",2910,4090,5260]
[null,null,null,null,null,null,"11/1",2510,3500,4510,null,null,"11/1",2510,3500,4500]
[null,null,null,null,null,null,"12/1",2090,2920,3750,null,null,"12/1",2090,2920,3750]
[null,null,null,null,null,null,"1/1",1670,2330,3000,null,null,"1/1",1670,2330,3000]
[null,null,null,null,null,null,"2/1",1250,1760,2250,null,null,"2/1",1260,1760,2260]
[null,null,null,null,null,null,"3/1",840,1170,1500,null,null,"3/1",830,1170,1500]
[null,null,null,null,null,null,"4/1",420,590,750,null,null,"4/1",420,590,760]