{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["注意事項","項目説明_更新方法","様式①春季登録","様式②■移籍届(春)","様式③■振込明細書(春)","様式④クラブ名変更届","ここから秋用→","様式①秋季登録","様式③■振込明細書(秋)"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":5,"comments":2,"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":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["■注意事項【1】：日本バドミントン協会の会員登録について"]
[]
[null,"連盟規約：",null,"http://ksbad.com/?page_id=11"]
[]
[null,"●同年度内で日本バドミントン協会登録を神奈川県以外からされた方で、"]
[null,"　移籍(県外へ転出/県外からの転入)をしたい場合は、下記リンクをご確認頂き、"]
[null,"　ご本人で手続きをお願いします。"]
[null,"　神奈川県バドミントン協会「会員登録について」"]
[null,"　https://www.badminton-kk.org/toroku.htm#id01"]
[null,"　"]
[null,"●日本バドミントン協会の会員証(プラスチックカード)は電子化により、２０２１年度より新規会員への発行が"]
[null,"　 無くなりました。また、全ての会員番号は、パソコンやスマートフォンから確認でき、会員番号通知カードを"]
[null,"　 印刷することも可能となります。　　　　　　　　　　　"]
[]
[null,"●社会人連盟では春と秋の２回の申請期間を設けています。"]
[null,"　　・春申請：～3月ころ"]
[null,"　　・秋申請：～８月ころ"]
[null,"●氏名等の文字は正確に記入してください。（高・髙、沢・澤など区別されます）"]
[null,"　　改姓の場合は、備考欄に旧姓もご記入ください。"]
[null,"●前回、間違えて申請した場合は、備考欄に訂正の内容を記述してください。"]
[null,"　　訂正の記載がなく、二重申請となった場合には登録料が返金できません。"]
[null,"　　また、２０２１年度より、登録用紙の誤記の修正は１度のみの受付とさせていただきます。"]
[null,"　　これ以降、記載内容の間違いにより日本および神奈川県バドミントン協会への登録不可の場合は、"]
[null,"　　各クラブまたは個人での登録手続きをお願いいたします。\n"]

{"sheet":"項目説明_更新方法","index":1,"n_rows":102,"n_cols":4,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[null,"※シートの削除をしないでください"]
["様式①記入項目説明"]
[null,"連盟登録\n区分","説明","補足"]
[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,"パスワードはファイル名のチーム順位数字2桁でお願いします。"]
[null,"ファイル名：11_チーム名_申請日_ver.5.xlsm"]

{"sheet":"様式①春季登録","index":2,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,17,3,20],[2,17,2,20],[0,1,0,2],[3,11,3,12],[2,11,2,12],[3,8,3,9],[2,8,2,9]]}
["申請日",null,null,null,null,"回目","ver.7"]
[]
[null,{"$f":"TEXT(B1,\"yyyy\")","v":"1900"},"年 神奈川県社会人クラブバドミントン連盟",null,null,null,"代表者名",null,null,null,"連絡先LINE",null,null,"連絡先電話",null,"メールアドレス"]
[null,{"$f":"LEFT(RIGHT(RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))),4),2)","v":"春季"},"クラブリーグ戦申込用紙",null,null,null,"連絡先責任者名",null,null,null,"連絡先LINE",null,null,"連絡先電話",null,"メールアドレス"]
[null,"部","クラブ名"]
[null,"位","略名"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"前年度登録情報",null,"日本バドミントン協会情報"]
["部+順位","NO.","前回情報から変更有無","連盟登録区分","所属団体名","リーグ戦参加区分","姓","名","姓カナ","名カナ","性別","生年月日\n(yyyy/mm/dd)","郵便番号","住所（改行しない）","在勤登録時　記入\n会社名・住所","都道府県","所属団体名","登録状況","番号（10桁）","審判資格","審判資格有効期限","備考"]
[{"$f":"$A$5&$A$6","v":""},1,null,null,{"$f":"IF(F9=\"\",\"\",$D$5)","v":""}]
["",{"$f":"B9+1","v":2},null,null,{"$f":"IF(F10=\"\",\"\",$D$5)","v":""}]
["",{"$f":"B10+1","v":3},null,null,""]
["",4,null,null,""]
["",5,null,null,""]
["",6,null,null,""]
["",7,null,null,""]
["",8,null,null,""]
["",9,null,null,""]
["",10,null,null,""]
["",11,null,null,""]
["",12,null,null,""]
[{"$f":"$A$5&$A$6","v":""},13,null,null,""]
[{"$f":"$A$9","v":""},14,null,null,""]
["",15,null,null,""]
["",16,null,null,""]
["",17,null,null,""]
["",18,null,null,""]
["",19,null,null,""]
["",20,null,null,""]
["",21,null,null,""]
["",22,null,null,""]
["",23,null,null,""]
["",24,null,null,""]
["",25,null,null,""]
["",26,null,null,""]
["",27,null,null,""]
["",28,null,null,""]
["",29,null,null,""]
["",30,null,null,""]

{"sheet":"様式②■移籍届(春)","index":3,"n_rows":27,"n_cols":33,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,4,2,12],[2,21,2,29],[26,24,26,32],[24,21,24,32],[22,24,22,32],[26,7,26,15],[24,4,24,15],[22,7,22,15],[9,8,9,12],[9,25,9,29]]}
[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,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,null,null,null,null,null,null,null,null,null,"　　理事長　　柿 沼 隆 馬 殿"]
[]
[null,null,null,null,null,null,null,null,{"$f":"様式①春季登録!B1","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"様式①春季登録!B1","v":"00:00:00"}]
[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,{"$f":"様式①春季登録!D5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"新所属クラブ名",null,null,{"$f":"様式①春季登録!D5","v":0}]
[]
[null,null,null,null,null,null,null,null,"代表者氏名　",null,null,{"$f":"様式①春季登録!I3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"代表者氏名　",null,null,{"$f":"様式①春季登録!I3","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,null,null,null,null,null,null,null,"記"]
[]
[null,"●",{"$f":"様式①春季登録!B3-1","v":1899},"年度所属クラブ団体名：",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"●",{"$f":"様式①春季登録!B3-1","v":1899},"年度所属クラブ団体名："]
[]
[null,"●","選手名：",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"●","選手名："]
[]
[null,"●",{"$f":"C23","v":1899},"年度所属クラブ代表者名：",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"●",{"$f":"T23","v":1899},"年度所属クラブ代表者名："]

{"sheet":"様式③■振込明細書(春)","index":4,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[12,11,12,14],[23,7,23,9],[7,5,7,10],[14,3,14,7],[16,7,16,9],[18,7,18,9],[20,7,20,9]]}
[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,"記入日：",{"$f":"様式①春季登録!B1","v":"00:00:00"}]
[]
[null,"クラブ名",null,{"$f":"様式①春季登録!D5","v":0}]
[]
[null,null,"年会費",null,null,null,null,5000,null,null,"円"]
[]
[null,null,"春季参加料",null,null,null,null,30000,null,null,"円"]
[]
[null,null,"登録料",null,null,null,null,{"$f":"2100*O21","v":0},null,null,"円","（１名　2,100円×",null,null,{"$f":"COUNTA(様式①春季登録!G9:G38)-S21","v":0},"名分）",null,"脱退",{"$f":"COUNTIF(様式①春季登録!D9:D38,R21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"様式①から自動計上┘"]
[]
[null,null,"合計",null,null,null,null,{"$f":"SUM(H17,H19,H21)","v":35000},null,null,"円"]
[null,null,"振込日：",null,{"$f":"様式①春季登録!B3","v":"1900"},"年",null,"月",null,"日"]

{"sheet":"様式④クラブ名変更届","index":5,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[32,3,33,15],[31,3,31,15],[5,3,5,13],[18,11,18,15],[18,8,18,10],[20,8,20,10],[20,11,20,15]]}
[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":"様式①春季登録!B3","v":"1900"},"年",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,"新クラブ名"]

{"sheet":"ここから秋用→","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"様式①秋季登録","index":7,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["申請日",null,null,null,null,"回目","ver.7"]
[]
[null,{"$f":"TEXT(B1,\"yyyy\")","v":"1900"},"神奈川県社会人クラブバドミントン連盟",null,null,null,"代表者名",null,{"$f":"様式①春季登録!I3","v":0},null,"連絡先LINE",{"$f":"様式①春季登録!L3","v":0},null,"連絡先電話",{"$f":"様式①春季登録!O3","v":0},"メールアドレス",null,{"$f":"様式①春季登録!R3","v":0}]
[null,{"$f":"LEFT(RIGHT(RIGHT(CELL(\"filename\",A3),LEN(CELL(\"filename\",A3))-FIND(\"]\",CELL(\"filename\",A3))),4),2)","v":"秋季"},"クラブリーグ戦申込用紙",null,null,null,"連絡先責任者名",null,{"$f":"様式①春季登録!I4","v":0},null,"連絡先LINE",{"$f":"様式①春季登録!L4","v":0},null,"連絡先電話",{"$f":"様式①春季登録!O4","v":0},"メールアドレス",null,{"$f":"様式①春季登録!R4","v":0}]
[null,"部","クラブ名",{"$f":"様式①春季登録!D5","v":0}]
[null,"位","略名",{"$f":"様式①春季登録!D6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"前年度登録情報",null,"日本バドミントン協会情報"]
["部+順位","NO.","前回情報から変更有無","連盟登録区分","所属団体名","リーグ戦参加区分","姓","名","姓カナ","名カナ","性別","生年月日\n(yyyy/mm/dd)","郵便番号","住所（改行しない）","在勤登録時　記入\n会社名・住所","都道府県","所属団体名","登録状況","番号（10桁）","審判資格","審判資格有効期限","備考"]
[{"$f":"$A$5&$A$6","v":""},1,null,null,{"$f":"IF(F9=\"\",\"\",$D$5)","v":""}]
["",{"$f":"B9+1","v":2},null,null,{"$f":"IF(F10=\"\",\"\",$D$5)","v":""}]
["",{"$f":"B10+1","v":3},null,null,""]
["",4,null,null,""]
["",5,null,null,""]
["",6,null,null,""]
["",7,null,null,""]
["",8,null,null,""]
["",9,null,null,""]
["",10,null,null,""]
["",11,null,null,""]
["",12,null,null,""]
[{"$f":"$A$5&$A$6","v":""},13,null,null,""]
[{"$f":"$A$9","v":""},14,null,null,""]
["",15,null,null,""]
["",16,null,null,""]
["",17,null,null,""]
["",18,null,null,""]
["",19,null,null,""]
["",20,null,null,""]
["",21,null,null,""]
["",22,null,null,""]
["",23,null,null,""]
["",24,null,null,""]
["",25,null,null,""]
["",26,null,null,""]
["",27,null,null,""]
["",28,null,null,""]
["",29,null,null,""]
["",30,null,null,""]

{"sheet":"様式③■振込明細書(秋)","index":8,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,7,23,9],[12,11,12,14],[7,5,7,10],[14,3,14,7],[18,7,18,9],[20,7,20,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"様式　３"]
[]
["※このシートは　日付、クラブ名、振込者名のみを記入してください。"]
["　 参加費等の費用は様式1の記入内容から引用しています。"]
["　金額に相違がある場合は様式1の記入内容を確認して下さい。"]
[]
[]
[null,null,null,null,null,"《振込明細書》"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"記入日：",{"$f":"様式①秋季登録!B1","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"新規（県内移籍）",{"$f":"COUNTIF(様式①秋季登録!D9:D38,'様式③■振込明細書(秋)'!T14)","v":0}]
[null,"クラブ名",null,{"$f":"様式①秋季登録!D5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"新規（県外転入）",{"$f":"COUNTIF(様式①秋季登録!D9:D38,'様式③■振込明細書(秋)'!T15)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"新規（その他）",{"$f":"COUNTIF(様式①秋季登録!D9:D38,'様式③■振込明細書(秋)'!T16)","v":0}]
[]
[]
[null,null,"秋季参加料",null,null,null,null,30000,null,null,"円"]
[]
[null,null,"追加登録料",null,null,null,null,{"$f":"2100*O21","v":0},null,null,"円","（１名　2,100円×",null,null,{"$f":"U14+U15+U16","v":0},"名分）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"様式①から自動計上┘"]
[]
[null,null,"合計",null,null,null,null,{"$f":"SUM(H17,H19,H21)","v":30000},null,null,"円"]
[null,null,"振込日：",null,{"$f":"様式①春季登録!B3","v":"1900"},"年",null,"月",null,"日"]