{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["【Aタイプ】入力シート ","【Ａタイプ】被保険者控作成","【Ｂ・Ｄタイプ】入力シート ","【Ｂ・Ｄタイプ】被保険者控作成","【Ｃタイプ】入力シート ","【Ｃタイプ】被保険者控作成 ","保険料表"],"not_rendered":{"charts":0,"images":1,"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":"【Aタイプ】入力シート ","index":0,"n_rows":66,"n_cols":25,"rows_kept":66,"cut":false,"hidden":false,"merged":[[4,1,5,2],[6,1,7,2],[8,1,9,2],[6,3,7,4],[8,3,9,13],[6,5,7,6],[6,7,7,9],[6,10,7,11],[6,12,7,13],[4,3,5,8],[4,9,5,10],[27,7,27,9],[49,7,49,9],[50,4,50,6],[50,7,50,9],[48,4,48,6],[48,7,48,9],[55,1,55,13],[56,1,57,1],[56,2,57,2],[37,4,37,6],[37,7,37,9],[38,4,38,6],[38,7,38,9],[39,4,39,6],[46,4,46,6],[56,3,57,3],[50,11,50,12],[51,11,51,12],[52,11,52,12],[53,11,53,12],[54,11,54,12],[49,11,49,12],[54,4,54,6],[54,7,54,9],[60,1,61,1],[60,2,61,2],[60,3,61,3],[60,4,61,5],[60,6,61,6],[62,0,65,1],[62,2,65,2],[62,3,65,3],[62,4,65,5],[62,6,65,6],[14,18,14,42],[56,4,57,5],[56,6,57,6],[58,4,59,5],[58,6,59,6],[31,11,31,12],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[43,7,43,9],[44,4,44,6],[16,18,16,19],[15,20,15,42],[2,1,2,3],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,11,46,12],[47,11,47,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[40,11,40,12],[27,4,27,6],[28,4,28,6],[28,7,28,9],[46,7,46,9],[47,4,47,6],[47,7,47,9],[16,4,16,6],[16,7,16,9],[15,18,15,19],[19,18,19,42],[17,18,18,19],[17,20,18,42],[16,20,16,42],[22,18,24,42],[45,4,45,6],[45,7,45,9],[40,7,40,9],[41,4,41,6],[41,7,41,9],[42,4,42,6],[42,7,42,9],[25,4,25,6],[25,7,25,9],[26,4,26,6],[31,4,31,6],[31,7,31,9],[43,4,43,6],[22,4,22,6],[22,7,22,9],[15,7,15,9],[17,4,17,6],[21,4,21,6],[36,4,36,6],[58,9,58,13],[51,4,51,6],[51,7,51,9],[52,4,52,6],[52,7,52,9],[53,4,53,6],[53,7,53,9],[49,4,49,6],[44,7,44,9],[48,11,48,12],[24,4,24,6],[24,7,24,9],[13,18,13,42],[12,1,13,1],[12,3,13,3],[12,2,13,2],[12,13,13,13],[13,7,13,9],[58,1,59,1],[58,2,59,2],[58,3,59,3],[46,15,46,17],[32,4,32,6],[32,7,32,9],[29,4,29,6],[29,7,29,9],[30,4,30,6],[30,7,30,9],[33,4,33,6],[33,7,33,9],[34,4,34,6],[34,7,34,9],[35,4,35,6],[35,7,35,9],[22,11,22,12],[21,11,21,12],[2,4,2,9],[2,11,2,12],[56,9,57,10],[56,12,57,13],[57,7,57,8],[39,7,39,9],[40,4,40,6],[39,11,39,12],[17,7,17,9],[18,4,18,6],[18,7,18,9],[14,4,14,6],[14,7,14,9],[26,7,26,9],[23,4,23,6],[23,7,23,9],[19,4,19,6],[19,7,19,9],[20,4,20,6],[20,7,20,9],[15,4,15,6],[36,7,36,9],[13,4,13,6],[12,4,12,6],[12,11,13,12],[21,7,21,9],[5,11,5,13],[4,11,4,13],[10,11,10,13],[12,7,12,9],[12,10,13,10],[10,8,10,10],[20,11,20,12]]}
[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,"電話：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,"級別\n右の職種級別を参照","合計",null,"解約日"]
[null,null,null,null,"本　人",null,null,"本人の配偶者または本人と生計を共にする同居の親族",null,null,null,null,null,null,null,null,null,null,"保護者の級別欄は、下表を参照の上、AまたはBを必ずご入力ください。"]
[null,"例","2024-05-01","A1","損保　一郎",null,null,"損保　太郎",null,null,"A",5000,null,null,null,null,null,null,"※職種級別がB級の職業・職種の方は、パンフレット記載の保険金額と異なりますので、詳しくは取扱代理店アライブまでお問い合わせください。"]
[null,1,"　　　",null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C16,保険料表!$B$2:$E$14,MATCH(D16,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"職種級別",null,"職　業・職　種"]
[null,2,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C17,保険料表!$B$2:$E$14,MATCH(D17,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"A　",null,"下記以外"]
[null,3,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C18,保険料表!$B$2:$E$14,MATCH(D18,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"B　",null,"木・竹・草・つる製品製造作業者、漁業作業者、建設作業者（高所作業の有無を問いません。）、採鉱・採石作業者、自動車運転者（バス・タクシー運転者、貨物自動車運転者等を含むすべての自動車運転者）、農林漁作業者"]
[null,4,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C19,保険料表!$B$2:$E$14,MATCH(D19,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,5,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C20,保険料表!$B$2:$E$14,MATCH(D20,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"※1　オートテスター、オートバイ競争選手、自転車競走選手、自動車競走選手、猛獣取扱者（動物園の飼育係を含みます。）、モーターボート競争選手の方等は上表の分類と保険料が異なります。"]
[null,6,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C21,保険料表!$B$2:$E$14,MATCH(D21,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"※2　プロボクサー、プロレスラー、力士、ローラーゲーム選手（レフリーを含みます。）の方等についてはお引き受けできません。"]
[null,7,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C22,保険料表!$B$2:$E$14,MATCH(D22,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,8,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C23,保険料表!$B$2:$E$14,MATCH(D23,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"きょうされん総合補償制度「利用者・職員のおケガの補償」加入者一覧表の使用方法について"]
[null,9,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C24,保険料表!$B$2:$E$14,MATCH(D24,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,10,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C25,保険料表!$B$2:$E$14,MATCH(D25,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,11,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C26,保険料表!$B$2:$E$14,MATCH(D26,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,12,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C27,保険料表!$B$2:$E$14,MATCH(D27,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"◆新規・継続でお申し込みいただく場合"]
[null,13,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C28,保険料表!$B$2:$E$14,MATCH(D28,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"加入者一覧表に必要事項をご入力のうえ、印刷をしてください。"]
[null,14,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C29,保険料表!$B$2:$E$14,MATCH(D29,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"加入者一覧表の原本は、同封の返信用封筒にて代理店アライブにお送りください。"]
[null,15,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C30,保険料表!$B$2:$E$14,MATCH(D30,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"控えがありませんので、原本を必ずコピーして事業所様控えとして保管ください。"]
[null,16,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C31,保険料表!$B$2:$E$14,MATCH(D31,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,17,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C32,保険料表!$B$2:$E$14,MATCH(D32,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"印刷後、提出前に記入誤りに気付いた場合は、その行を波線で削除し、次の行に記入してください。訂正印は不要です。"]
[null,18,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C33,保険料表!$B$2:$E$14,MATCH(D33,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"加入者一覧表の行が足りない場合は、新しいシートをコピーして入力をしてください。"]
[null,19,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C34,保険料表!$B$2:$E$14,MATCH(D34,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"枝番はシートごとに管理をしますので、新しいシートを追加した場合もそのままにしてください。"]
[null,20,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C35,保険料表!$B$2:$E$14,MATCH(D35,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,21,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C36,保険料表!$B$2:$E$14,MATCH(D36,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"◆中途加入をする場合（入力シートに入力ください。）"]
[null,22,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C37,保険料表!$B$2:$E$14,MATCH(D37,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"ご加入時に作成いただいたエクセル版の「加入者一覧表」に新しくご加入される方の開始日・タイプ・お名前・級別を入力の上、"]
[null,23,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C38,保険料表!$B$2:$E$14,MATCH(D38,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"プリントしていただきアライブへＦＡＸをお願いいたします。。"]
[null,24,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C39,保険料表!$B$2:$E$14,MATCH(D39,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,25,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C40,保険料表!$B$2:$E$14,MATCH(D40,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"◆中途脱退をする場合（入力シートにご入力ください。）"]
[null,26,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C41,保険料表!$B$2:$E$14,MATCH(D41,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"ご加入時に作成いただいたエクセル版の「加入者一覧表」に脱退される方の解約日を入力のうえ、プリントしていただき"]
[null,27,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C42,保険料表!$B$2:$E$14,MATCH(D42,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"アライブへＦＡＸをお願いいたします。"]
[null,28,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C43,保険料表!$B$2:$E$14,MATCH(D43,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,29,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C44,保険料表!$B$2:$E$14,MATCH(D44,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"※中途加入・中途脱退の詳しい内容は「きょうされん総合補償制度のご案内（手引書）」の12ページ〈5〉をご覧ください。"]
[null,30,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C45,保険料表!$B$2:$E$14,MATCH(D45,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,31,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C46,保険料表!$B$2:$E$14,MATCH(D46,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,32,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C47,保険料表!$B$2:$E$14,MATCH(D47,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"【注意事項】"]
[null,33,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C48,保険料表!$B$2:$E$14,MATCH(D48,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"・本加入者一覧表は速やかに、取扱代理店アライブへ郵送してください。"]
[null,34,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C49,保険料表!$B$2:$E$14,MATCH(D49,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,35,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C50,保険料表!$B$2:$E$14,MATCH(D50,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"・お申込み内容に変更があった場合は速やかにアライブまでご連絡ください。"]
[null,36,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C51,保険料表!$B$2:$E$14,MATCH(D51,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"　　詳細につきましては、『きょうされん総合補償制度のご案内（手引書）』を必ずご確認ください。"]
[null,37,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C52,保険料表!$B$2:$E$14,MATCH(D52,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,38,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C53,保険料表!$B$2:$E$14,MATCH(D53,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,39,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C54,保険料表!$B$2:$E$14,MATCH(D54,保険料表!$B$2:$E$2,0),FALSE),\"\")","v":""}]
[null,40,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C55,保険料表!$B$2:$E$14,MATCH(D55,保険料表!$B$2:$E$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,$L$16:$L$55)","v":0},null,"円"]
[null,null,null,null,null,null,null,"[代理店使用欄]"]
[null,"A2",{"$f":"COUNTIF($D$16:$D$55,B59)","v":0},"名",{"$f":"SUMIF($D$16:$D$55,B59,$L$16:$L$55)","v":0},null,"円","事業所総合計　：",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,$L$16:$L$55)","v":0},null,"円"]
[null,null,null,null,null,null,null,"賠責（E）：□13,000　　　　　□15,000　　　　　　□17,000　　　　　　□19,000"]
["合計",null,{"$f":"SUM(C57:C62)","v":0},"名",{"$f":"SUM(E57:F62)","v":0},null,"円","賠責（F）：　　ａ　　　　ｂ　　　　ｃ　　　　ｄ　　　　　　　　　　　　　　　　　　　　　　　　円"]
[]
[null,null,null,null,null,null,null,"設備・什器　：□7,000　　□10,000",null,null,null,"事業用現金：□22,000　□26,000"]
[null,null,null,null,null,null,null,"情報漏えい　：　　　　　　　　　　　　　円",null,null,null,"役員賠：　　　　　　　　　　　　　　　円"]

{"sheet":"【Ａタイプ】被保険者控作成","index":1,"n_rows":34,"n_cols":22,"rows_kept":34,"cut":false,"hidden":false,"merged":[[9,1,11,2],[9,3,11,4],[9,6,11,7],[9,8,11,10],[7,13,7,20],[4,13,4,20],[5,13,5,20],[6,1,7,3],[6,4,7,10],[1,1,4,10],[2,13,3,20],[1,13,1,20],[24,4,26,6],[24,7,26,9],[24,10,26,10],[27,4,27,10],[12,6,13,10],[19,1,21,4],[19,5,21,5],[19,6,21,9],[19,10,21,10],[16,1,18,5],[16,6,18,10]]}
[]
[null,"２０２6年　きょうされん補償制度　\n利用者・職員のおケガの補償 \n＜被保険者控＞",null,null,null,null,null,null,null,null,null,null,null,"Aタイプ用"]
[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":"'【Aタイプ】入力シート '!D5","v":"あらいぶ"},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,"印刷おわり",4]
[null,"タイプ",null,{"$f":"(VLOOKUP($P$7,'【Aタイプ】入力シート '!B16:M55,3,0))","v":0},null,null,"加入日\n保険始期",null,{"$f":"(VLOOKUP($P$7,'【Aタイプ】入力シート '!B16:M55,2,0))","v":"　　　"}]
[]
[]
[null,null,null,null,null,null,"保険終期：2027/5/1"]
[]
[]
[]
[null,"利用者ご本人",null,null,null,null,"保護者"]
[]
[]
[null,{"$f":"VLOOKUP($P$7,'【Aタイプ】入力シート '!B16:M55,4,0)","v":0},null,null,null,"様",{"$f":"VLOOKUP($P$7,'【Aタイプ】入力シート '!B16:M55,7,0)","v":0},null,null,null,"様"]
[]
[]
[]
[]
[null,null,null,null,"保険料",null,null,{"$f":"VLOOKUP($P$7,'【Aタイプ】入力シート '!B16:M55,11,0)","v":""},null,null,"円"]
[]
[]
[null,null,null,null,"※プラン詳細はチラシ・パンフレットをご確認ください。"]
[]
[]
[]
["取扱代理店　　：株式会社　アライブ"]
[]
["引受保険会社：損害保険ジャパン株式会社"]

{"sheet":"【Ｂ・Ｄタイプ】入力シート ","index":2,"n_rows":68,"n_cols":25,"rows_kept":68,"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,"級別\n利用者\nの方はA",null,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,"それ以外の職員・利用者の方はＡと入力ください。"]
[null,1,"　　　",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,{"$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,"※中途加入・中途脱退の詳しい内容は「きょうされん総合補償制度のご案内（手引書）」の12ページ〈5〉をご覧ください。"]
[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,"B1",{"$f":"COUNTIF($D$16:$D$55,B57)","v":0},"名",{"$f":"SUMIF($D$16:$D$55,B57,$I$16:$I$55)","v":0},null,"円"]
[]
[null,"B2",{"$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,"B3",{"$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,"D",{"$f":"COUNTIF($D$16:$D$55,B63)","v":0},"名",{"$f":"SUMIF($D$16:$D$55,B63,$I$16:$I$55)","v":0},null,"円"]
[null,null,null,null,null,null,null,"賠責（E）：□13,000　　　　　□15,000　　　　　　□17,000　　　　　　□19,000"]
["合計",null,{"$f":"SUM(C57:C64)","v":0},"名",{"$f":"SUM(E57:F64)","v":0},null,"円","賠責（F）：　　ａ　　　　ｂ　　　　ｃ　　　　ｄ　　　　　　　　　　　　　　　　　　　　　　　　円"]
[]
[null,null,null,null,null,null,null,"設備・什器：□7,000　　　　　　□10,000",null,null,null,"事業用現金：□22,000　□26,000"]
[null,null,null,null,null,null,null,"情報漏えい：　　　　　　　　　　　　　円",null,null,null,"役員賠：　　　　　　　　　　　　　　　円"]

{"sheet":"【Ｂ・Ｄタイプ】被保険者控作成","index":3,"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,"２０２6年　きょうされん補償制度　\n利用者・職員のおケガの補償 \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,"印刷おわり",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,8,0)","v":""},null,null,"円"]
[]
[]
[null,null,null,null,"※プラン詳細はチラシ・パンフレットをご確認ください。"]
[]
[]
[]
["取扱代理店　　：株式会社　アライブ"]
[]
["引受保険会社：損害保険ジャパン株式会社"]

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

{"sheet":"【Ｃタイプ】被保険者控作成 ","index":5,"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,"２０２6年　きょうされん補償制度　\n利用者・職員のおケガの補償 \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,"印刷おわり",10]
[null,"タイプ",null,{"$f":"(VLOOKUP($P$7,'【Ｃタイプ】入力シート '!B16:J55,3,0))","v":0},null,null,"加入日\n保険始期",null,{"$f":"(VLOOKUP($P$7,'【Ｃタイプ】入力シート '!B16:J55,2,0))","v":0}]
[]
[]
[null,null,null,null,null,null,"保険終期：2027/5/1"]
[]
[]
[]
[null,"利用者ご本人"]
[]
[]
[null,{"$f":"VLOOKUP($P$7,'【Ｃタイプ】入力シート '!$B$16:$J$55,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":6,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":true,"merged":[[0,2,0,4],[0,7,0,9]]}
[null,"Ａタイプ","合計",null,null,null,"Ｂタイプ","合計",null,null,"Ｄタイプ",null,"Ｃタイプ","合計"]
["級別","　　　","A1","A2","A3",null,"　　　","B1","B2","B3","D",null,"　　　","C"]
["A","5/1",5000,7000,9000,null,"5/1",5000,7000,9000,11000,null,"5/1",7000]
["B","6/1",4580,6420,8250,null,"6/1",4590,6410,8250,10090,null,"6/1",6420]
[null,"7/1",4170,5840,7510,null,"7/1",4170,5840,7500,9170,null,"7/1",5840]
[null,"8/1",3750,5250,6760,null,"8/1",3750,5250,6760,8260,null,"8/1",5260]
[null,"9/1",3330,4660,5990,null,"9/1",3330,4670,6000,7330,null,"9/1",4660]
[null,"10/1",2910,4080,5250,null,"10/1",2920,4080,5260,6410,null,"10/1",4080]
[null,"11/1",2510,3510,4500,null,"11/1",2510,3510,4500,5500,null,"11/1",3500]
[null,"12/1",2090,2920,3750,null,"12/1",2090,2920,3750,4590,null,"12/1",2920]
[null,"1/1",1670,2340,3010,null,"1/1",1670,2330,3000,3670,null,"1/1",2340]
[null,"2/1",1260,1760,2260,null,"2/1",1260,1760,2260,2760,null,"2/1",1760]
[null,"3/1",830,1170,1490,null,"3/1",840,1160,1500,1830,null,"3/1",1160]
[null,"4/1",420,580,750,null,"4/1",420,590,760,910,null,"4/1",580]