{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ジュニア審判員申請データ作成シート"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":501,"n_cols":11,"rows_kept":501,"cut":false,"hidden":false,"merged":[]}
["ジュニア審判員申請データ作成シート",null,null,null,null,null,null,null,null,"（公財）日本ソフトテニス連盟"]
["下の黄色の項目（会員番号、…、認定団体）を「取得資格一括登録アップロード」シートに貼り付けます。"]
["「誕生日」は計算上必須です。「姓名」は支部での確認用です。この二つは「取得資格一括登録アップロード」シートには貼り付けません。"]
["会員番号の「JSTA」、資格IDの「S」は半角大文字です。資格IDは会員番号を入れると「S_07」が自動入力されます。変更・削除はしないでください。"]
["「承認日」は申請をする日を入力。月と日が一桁の場合はサンプル（2023/03/09)のようにゼロを付けて二桁にしてください。"]
["「有効期限」は「誕生日」が入力されれば関数で自動計算されます。関数と書式は変更しないでください。"]
["「認定団体」は北海道が「01000000」で始まる８桁の数字を右を参考にリストから選びます。最初を入力したら以下コピーOKです。"]
["「受講日」は講習会等を行った日を入力。月日が一桁の場合はサンプル（2023/03/09)のようにゼロを付けて二桁にしてください。※入力しなくてもOKです。"]
["「備考」は備考欄は自由に使えます。データ入力時のチェックのために名前を入力すると便利です。"]
["「誕生日」は普通に入力するかシステムのデータを貼り付けてください。"]
["下の16行目から19行目は4月1日と4月2日生まれの有効期限の違いを示すサンプルです。削除しないでください。"]
["「取得資格一括登録アップロード」シートへの貼り付けは「説明用」タブの３ページを参照してください。"]
["「取得資格一括登録アップロード」シートに貼り付けるときは、ご自身で作成された部分のみを貼り付けてください。"]
[null,"変更不可",null,"自動入力"]
["会員番号","資格ID","承認日","有効期限","認定団体","受講日","氏名","生年月日",null,"コード","審判員資格"]
["JSTA12345678",{"$f":"IF(A16=\"\",\"\",\"S_07\")","v":"S_07"},"2024/04/02",{"$f":"IFERROR(TEXT(DATE(YEAR(EDATE(H16-1,-3))+19,4,1),\"yyyy/mm/dd\"),\"\")","v":"2033/04/01"},"06000000","2024/01/09","ヤマガタ　ハナコ","2014-06-07",null,"S_01","１級審判員（新規）"]
[null,null,null,null,null,null,null,null,null,"S_02","１級審判員（更新）"]
[null,null,null,null,null,null,null,null,null,"S_03","２級審判員（新規一般）"]
[null,"",null,{"$f":"IFERROR(TEXT(DATE(YEAR(EDATE(H19-1,-3))+19,4,1),\"yyyy/mm/dd\"),\"\")","v":""},null,null,null,null,null,"S_04","２級審判員（新規高校）"]
[null,"",null,{"$f":"IFERROR(TEXT(DATE(YEAR(EDATE(H20-1,-3))+19,4,1),\"yyyy/mm/dd\"),\"\")","v":""},null,null,null,null,null,"S_05","２級審判員（更新）"]
[null,"",null,"",null,null,null,null,null,"S_06","２級審判員（ジュニアからの移行）"]
[null,"",null,"",null,null,null,null,null,"S_07","ジュニア審判員"]
[null,"",null,"",null,null,null,null,null,"S_11","マスターレフェリー"]
[null,"",null,"",null,null,null,null,null,"S_12","マスターアンパイヤー"]
[null,"",null,"",null,null,null,null,null,"S_99","受講日"]
[null,"",null,"",null,null,null,null,null,"01000000","北海道ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"02000000","青森県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"03000000","岩手県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"04000000","宮城県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"05000000","秋田県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"06000000","山形県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"07000000","福島県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"08000000","茨城県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"09000000","栃木県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"10000000","群馬県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"11000000","埼玉県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"12000000","千葉県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"13000000","東京都ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"14000000","神奈川県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"15000000","山梨県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"16000000","新潟県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"17000000","長野県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"18000000","富山県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"19000000","石川県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"20000000","福井県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"21000000","静岡県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"22000000","愛知県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"23000000","三重県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"24000000","岐阜県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"25000000","滋賀県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"26000000","京都府ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"27000000","大阪府ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"28000000","兵庫県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"29000000","奈良県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"30000000","和歌山県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"31000000","鳥取県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"32000000","島根県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"33000000","岡山県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"34000000","広島県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"35000000","山口県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"36000000","徳島県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"37000000","香川県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"38000000","愛媛県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"39000000","高知県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"40000000","福岡県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"41000000","佐賀県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"42000000","長崎県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"43000000","熊本県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"44000000","大分県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"45000000","宮崎県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"46000000","鹿児島県ソフトテニス連盟"]
[null,"",null,"",null,null,null,null,null,"47000000","沖縄県ソフトテニス連盟"]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,{"$f":"IF(A80=\"\",\"\",\"S_07\")","v":""},null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,{"$f":"IFERROR(TEXT(DATE(YEAR(EDATE(H84-1,-3))+19,4,1),\"yyyy/mm/dd\"),\"\")","v":""}]
[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,"",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":"IF(A144=\"\",\"\",\"S_07\")","v":""},null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,{"$f":"IFERROR(TEXT(DATE(YEAR(EDATE(H148-1,-3))+19,4,1),\"yyyy/mm/dd\"),\"\")","v":""}]
[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,"",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":"IF(A208=\"\",\"\",\"S_07\")","v":""},null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,{"$f":"IFERROR(TEXT(DATE(YEAR(EDATE(H212-1,-3))+19,4,1),\"yyyy/mm/dd\"),\"\")","v":""}]
[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,"",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":"IF(A272=\"\",\"\",\"S_07\")","v":""},null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,{"$f":"IFERROR(TEXT(DATE(YEAR(EDATE(H276-1,-3))+19,4,1),\"yyyy/mm/dd\"),\"\")","v":""}]
[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,"",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":"IF(A336=\"\",\"\",\"S_07\")","v":""},null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,{"$f":"IFERROR(TEXT(DATE(YEAR(EDATE(H340-1,-3))+19,4,1),\"yyyy/mm/dd\"),\"\")","v":""}]
[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,"",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":"IF(A400=\"\",\"\",\"S_07\")","v":""},null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,{"$f":"IFERROR(TEXT(DATE(YEAR(EDATE(H404-1,-3))+19,4,1),\"yyyy/mm/dd\"),\"\")","v":""}]
[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,"",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":"IF(A464=\"\",\"\",\"S_07\")","v":""},null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,{"$f":"IFERROR(TEXT(DATE(YEAR(EDATE(H468-1,-3))+19,4,1),\"yyyy/mm/dd\"),\"\")","v":""}]
[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,""]