{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ファイル使用にあたって","詳細説明","参考","ジュニア審判員申請データ作成シート"],"not_rendered":{"charts":0,"images":19,"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":"ファイル使用にあたって","index":0,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,1,0,2],[2,1,2,8],[4,2,6,7]]}
[null,null,null,null,null,null,null,"2024-04-17"]
[null,null,null,null,null,null,null,"（公財）日本ソフトテニス連盟"]
[null,"審判・技術等級　取得資格アップロードについて"]
[]
[null,null,"【ご注意】\nこのプログラムは、全てのパソコンに対応しているわけではありません。バージョンやマシンの状態等によってはうまくいかないケースもありますので、その場合は、従来のアップロード方法で作業くださいますようお願いいたします。"]
[]
[]
[]
[null,null,"◆令和6年度（2024年度）からの変更点"]
[null,null,"①「受講日」追加"]
[null,null,"一括登録アップロードファイル（csv）の7列目に「受講日」が追加となったため、"]
[null,null,"各データ作成シート、取得資格一括登録アップロードシートに「受講日」を追加しています。"]
[null,null,"※「受講日」は項目として入っていますが、何も入力しなくても問題はありません。"]
[null,null,"②審判資格更新の際、承認日と有効期限の期間が重複になるとエラーが出ます"]
[null,null,"㊟令和6年度に更新ができるのは、資格の有効期限が　2025/04/01(2025/03/31)　の会員様のみです。"]
[null,null,"例）　審判有効期限が　2025/04/01　の場合　→　承認日は　2025/04/02　と入力"]
[]
[null,null,"◆ファイルの使用にあたって"]
[null,null,"こちらのExcelファイルをご使用いただくにあたり、まずは以下の方法で"]
[null,null,"「マクロのブロックを解除」「マクロの有効化」を行ってください。"]
[null,null,"※ご使用のExcelのバージョンにより、画面や操作方法が若干異なる可能性があります。"]
[null,null,"＜マクロのブロック解除方法＞"]
[null,null,"下記赤枠の表示が出る場合は、マクロの実行ができないため、解除が必要です。"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"①一旦ファイルを閉じ、閉じたファイルを右クリック。"]
[null,null,"　右図が出るので、赤枠「許可する」にチェックを入れ、"]
[null,null,"　「適用」→「OK」の順にクリック。"]
[null,null,"　→これでマクロのブロックは解除されました"]
[]
[null,null,"②再度ファイルを開き、下記「コンテンツの有効化」を"]
[null,null,"　実行してください。"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"＜マクロの有効化／方法その1＞"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"＜マクロの有効化／方法その2＞"]

{"sheet":"詳細説明","index":1,"n_rows":201,"n_cols":8,"rows_kept":201,"cut":false,"hidden":false,"merged":[[195,2,195,7],[197,2,197,7],[198,2,198,7],[199,2,199,7],[0,1,0,2],[3,1,3,7],[43,2,43,7],[58,2,58,7],[62,2,62,7],[68,2,68,7]]}
[null,null,null,null,null,null,null,"2024-04-17"]
[null,null,null,null,null,null,null,"（公財）日本ソフトテニス連盟"]
[]
[null,"ジュニア審判員の「有効期限」の注意事項と計算方法"]
[]
[null,null,"審判員資格の申請の際、「有効期限」を入力する必要があります。"]
[null,null,"ジュニア審判員は「中学校卒業まで」が「有効期限」です。"]
[null,null,"旧システムでは中学校を卒業しても高校在学中は「（元Ｊr．）」が表示され、"]
[null,null,"高校在学中に２級審判員の申請を行う際、「高校新規」で申請するのか"]
[null,null,"「移行」で申請するのかが分かるようになっていました。"]
[]
[null,null,"ところが新システムでは「有効期限」に「中学校卒業」の３月３１日を入力すると、"]
[null,null,"その日をもって審判員資格が消えてしまい、高校在学中に２級審判員を申請する際に"]
[null,null,"「高校新規」なのか「移行」なのかが判別できません。"]
[]
[null,null,"そこで「有効期限」の欄に「高校卒業後の４月１日」の日付を入力することにより、"]
[null,null,"高校生の間も「ジュニア審判員」の資格が表示され続けるようにします。"]
[null,null,"※3月31日にしてしまうとシステム上は「3月31日0時0分0秒」と認識されてしまうため"]
[null,null,"　有効期限が1日短くなってしまいますので、必ず期限は「4月1日」としてください。"]
[]
[null,null,"高校在学中に２級審判員の申請を行う際に「ジュニア審判員」が表示されている人は"]
[null,null,"「移行」で申請し、表示されていなければ「高校新規」で申請してください。"]
[]
[null,null,"新システムでは資格が複数載せられるため、「移行」で２級審判員の資格を取得すると"]
[null,null,"高校在学中は「２級審判員」と「ジュニア審判員」の２つが載り続け、"]
[null,null,"卒業すると「ジュニア審判員」が消えることになります。"]
[]
[null,null,"「高校卒業の年月日」は、受講者の学年によってそれぞれ異なります。"]
[null,null,"そこで、「誕生日」を入力すると自動で「高校卒業の年月日」が表示される関数を"]
[null,null,"ご紹介します。"]
[]
[null,null,"このシートのタブの隣にある「ジュニア審判員申請データ作成シート」のタブを開く。"]
[null,null,"（「取得資格一括登録アップロード.csv」ファイルとは別のもの）"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"D15のセルに入っている関数　IFERROR(DATE(YEAR(EDATE(G15-1,-3))+19,4,1),\"\")　の意味"]
[null,"EDATE(誕生日-1,-3)　"]
[null,null,"「誕生日」は誕生日が入力されたセルのこと。例えば上の見本ではH列のセル番号（H10など）になる。以下同じ。"]
[null,null,"4月1日生まれの者は前の学年になるので「誕生日-1」で一旦4月1日から3月31日の範囲に入れる。"]
[null,null,"「－３」とすることで1月1日から12月31日の範囲に入れる。"]
[null,null,"EDATE関数でくくることで上の1月1日から12月31日のシリアル値が出る。"]
[null,null,"「シリアル値」とは1899年12月30日午前0時からの経過日数を表す整数。"]
[null,null,"1899年12月30日午前0時から1日経過した1900年1月1日が「１」となる。"]
[null,null,"例えば2014年1月1日は41730日目に当たるのでシリアル値は「41730」となる。"]
[null,"YEAR(シリアル値)"]
[null,null,"上で出たシリアル値の年号だけを取り出す。（生まれた「年度」を表す。）"]
[null,"(YEAR(EDATE(A3-1,-3))+19"]
[null,null,"上の年号に１９を足すことで18歳になった年明けの年号（高校を卒業する年の年号）が出る。"]
[null,"DATE(YEAR(EDATE(A3-1,-3))+19,4,1）"]
[null,null,"その年の4月1日が表示される。"]
[null,"IFERROR(DATE(YEAR(EDATE(A3-1,-3))+19,4,1),\"\")"]
[null,null,"誕生日の欄が空白であれば有効期限の欄も「””」によって空白になる。"]
[null,null,"最初シリアル値で計算結果が表示されるなら、「セルの書式設定」→「表示形式」→「日付」→「*2012/3/14」に変更。"]
[]
[null,null,"<関数の意味>"]
[null,"IFERROR(値、エラーの場合の値)"]
[null,null,"式がエラーの場合は、エラーの値を返します。エラーでない場合は、式の値自体を返します。"]
[null,"DATE(年,月,日)"]
[null,null,"Microsoft Excelの日付／時刻コードで指定した日付を表す数値を返します。"]
[null,"YEAR(シリアル値)"]
[null,null,"年を1900～9999の範囲の整数で返します。"]
[null,"EDATE(開始日,月）"]
[null,null,"開始日から起算して、指定した月だけ前あるいは後の日付に対応するシリアル値を計算します。"]
[]
[null,null,"≪ファイルの使用方法、資格情報登録及び申請の流れ≫"]
[null,null,"1．各シートにある表内の入力可能な箇所へデータを手入力（またはリストから選択）する"]
[null,null,"2．同じファイル内にあるCSV出力用のシートへ、入力したデータをコピーする"]
[null,null,"※必ずこのファイル内のアップロードシートに貼り付けるようにしてください。"]
[null,null,"3．CSVファイル出力（≒CSVファイル保存）を行う"]
[null,null,"4．出力したCSVファイルをシステム管理画面へアップロードする"]
[null,null,"5．アップロード後、日本連盟に申請する"]
[]
[null,null,"【各シートから自動でデータコピーする方法】"]
[null,null,"コピーしたいシートの画面右上にある「データコピー」ボタンをそれぞれクリックしてください。"]
[null,null,"ご自身で入力された分のデータが、1番右のシート「取得資格一括登録アップロード」に"]
[null,null,"反映されます。「データクリア」はご自身が入力したデータが消去されます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"【各シートから手動でデータコピーする方法】"]
[null,null,"データ入力したシートから下の赤枠の部分を選択し、右クリックで「コピー」を選びます。"]
[null,null,"「取得資格一括登録アップロード」シートに貼り付けます。"]
[null,null,"貼り付ける際は必ず「値貼り付け」を選んでください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"【データはまとめてCSV出力へ】"]
[null,null,"「ジュニア審判」「ジュニア以外の審判」「技術等級」それぞれのデータ作成シートで作業し、"]
[null,null,"「データコピー」をクリックすれば、「取得資格一括アップロード」シートに入力した"]
[null,null,"それぞれのデータが蓄積されていきます。"]
[null,null,"◆各データ作成シート"]
[null,null,"①ジュニア審判員"]
[]
[]
[]
[]
[null,null,"②ジュニア以外審判員"]
[]
[]
[null,null,"③技術等級"]
[]
[]
[]
[]
[null,null,"◆取得資格一括登録アップロードシート"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"【自動でCSV出力（保存）する方法】"]
[null,null,"貼り付け完了後、同シートの「CSV出力」ボタンをクリックし、このファイルと同じ場所に"]
[null,null,"出来上がった「取得資格一括登録アップロード.csv」※をシステムにアップロードした後、"]
[null,null,"日本連盟に申請してください。"]
[null,null,"※ファイルが重複しないよう、アップロードの文字の後に出力した日時が自動で付与されます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"【手動でCSV出力（保存）する方法】"]
[null,null,"「取得資格一括登録アップロード」シートをクリックし、「名前を付けて保存」⇒"]
[null,null,"ファイルの種類を『CSV UTF-8（コンマ区切り）』にして任意の場所へ保存してください。"]
[null,null,"保存の際にメッセージが表示されましたら「OK」をクリックしてください。"]
[]
[null,null,"【Excel2016以下を使用している場合のCSV出力（保存）方法】"]
[null,null,"①は無視していただき、②以降をご参照ください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"【各シートのデータを自動で削除する方法】"]
[null,null,"各シートのデータを削除したい場合は、各シートの「データクリア」ボタンを"]
[null,null,"それぞれクリックしてください。"]
[]
[null,null,"ジュニア審判員以外の審判員資格申請用には"]
[null,null,"「審判員申請データ作成シート（ジュニア以外）」を"]
[null,null,"使用してください。"]
[null,null,"「ジュニア」と「ジュニア以外」は流用できません。"]
[null,null,"技術等級申請用には「技術等級申請データ作成シート」を"]
[null,null,"使用してください。"]

{"sheet":"参考","index":2,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,2],[3,1,3,8],[32,1,32,8]]}
[null,null,null,null,null,null,null,"2024-04-17"]
[null,null,null,null,null,null,null,"（公財）日本ソフトテニス連盟"]
[]
[null,"【参考①】資格認定の流れについて"]
[]
[null,null,"アップロード作業～申請～認定料のお支払いについては、以下の流れとなります。"]
[null,null,"アップロード作業を実行後、内容はすぐにシステムに反映されますので、誤登録されないよう"]
[null,null,"登録内容はアップロード前に必ずご確認ください。"]
[null,null,"※アップロード作業のみ行い申請を忘れてしまうケースが見られましたので、各加盟団体様で"]
[null,null,"　作業を行う際は下記①②を実行いただき、申請漏れのないようご注意ください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"※2024年4月現在（上記の流れは変更となる場合もありますので、予めご承知おきください）"]
[]
[null,null,"◆アップロード作業は各加盟団体様で必要に応じて都度行っていただき、申請（「資格認定明細」の"]
[null,null,"　送付）は基本的に月1回、月末に日本ソフトテニス連盟事務局までお送りください。"]
[null,null,"◆日本ソフトテニス連盟事務局へお送りいただくファイルは、csvファイルではなく、"]
[null,null,"　Excelの「資格認定明細」でお願いいたします。"]
[]
[]
[]
[null,"【参考②】審判員ワッペン・技術等級バッジ・出版物等の発注について"]
[]
[null,null,"既定のファイル「【発注書】各加盟団体用_202404」の該当するシートに必要事項を記入の上、"]
[null,null,"メール（ nintei@jsta.or.jp ）またはFAXにてお申し込みください。"]

{"sheet":"ジュニア審判員申請データ作成シート","index":3,"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,""]