{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["記入例１","団体申込フォーム","設定"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,2,4,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[15,2,15,4],[16,2,16,4]]}
[null,"【記入例】　2020年度通関士養成各種講座申込フォーム　"]
[null,"【記入例】ファイル送信先アドレス → jtas_seminar@kanzei.or.jp"]
[]
[null,"〈 講　座　情　報 〉","A10",{"$f":"OFFSET(#REF!,(MATCH(記入例１!C5,#REF!,0)-1),2)","v":{"$error":"#REF!"}},{"$f":"OFFSET(#REF!,(MATCH(記入例１!C5,#REF!,0)-1),4)","v":{"$error":"#REF!"}}]
[null,"講座名称 ▼","通信教育講座　一般申込 "]
[]
[null,"〈 会 社 情 報 〉"]
[null,"社名","株式会社○○貿易"]
[null,"部署名","トレード部門"]
[null,"社名部署名カナ","ﾏﾙﾏﾙﾎﾞｳｴｷﾄﾚｰﾄﾞﾌﾞﾓﾝ"]
[null,"申込統括者","関税　太郎","申込統括者フリガナ","カンゼイ　タロウ"]
[null,"TEL","03-9999-9991","FAX","03-9999-9992"]
[]
[null,"郵便番号","101-xxxx","都道府県 ▼","東京都"]
[null,"市区町村","千代田区神田駿河台","番地","X-X-X"]
[null,"ビル名等","○○貿易ビル"]
[null,"E-Mail","to@marumaru.com"]
[null,"模試実施希望日"]
[null,"申込年月日","2020-03-10","入金予定日","2020-03-20"]
[null,"送金方法 ▼","銀行振込","受講料（自動計算）",198000]
[null,"請求書 ▼","必要","通信欄"]
[]
[null,"〈 受 験 者 情 報 〉",{"$f":"SUM($A$25:$A$27)","v":3}]
[null,"番号","受講者名","受講者フリガナ","年齢 ▼","性別 ▼","受験科目数 ▼"," 受験会場 ▼","送付先 ▼","社名","部署名","郵便番号","都道府県 ▼","市区町村","番地","ビル名等","TEL","FAX","E-Mail"]
[{"$f":"IF(C25=\"\",0,1)","v":1},1,"関税　一郎","カンゼイ　イチロウ","35","男性","２科目","東京","会社情報と同じ"]
[{"$f":"IF(C26=\"\",0,1)","v":1},2,"関税　二郎","カンゼイ　ジロウ","30","男性","３科目","東京","会社情報と同じ"]
[1,3,"関税　花子","カンゼイ　ハナコ","25","女性","３科目","横浜","別途指定","株式会社○○貿易","横浜支店","231-XXXX","神奈川県","横浜市中区新港","X-X-X",null,"045-9999-9991","045-9999-9992","yo@marumaru.com"]
[0,4,null,null,null,"　",null,null,"会社情報と同じ"]
[0,5,null,null,null,"　",null,null,"会社情報と同じ"]
[1,null,"～"]
[0,69,null,null,null,"　",null,null,"会社情報と同じ"]
[0,70,null,null,null,"　",null,null,"会社情報と同じ"]
[]
[]
[null,"※セキリュティの警告表示がされた場合は、マクロを有効にしてから使用してください。"]
[]
[null,"＜入力方法＞"]
[null,null,"左の色で表示された欄は必須項目となりますので、漏れなく入力してください。"]
[null,"・この「記入例」シートではなく、必ず「団体申込フォーム」シートに入力してください。"]
[null,"・団体申込を行う講座名称を選択します。"]
[null,"・以下のセルはプルダウンメニューになっていますので、入力ではなく選択してください。"]
[null,"都道府県"]
[null,"送金方法"]
[null,"請求書"]
[null,"年齢"]
[null,"性別"]
[null,"送付先"]
[null,"・送付先は、各受講者に対して以下の通り個別に選択、入力してください。"]
[null,"会社情報と同じ場合は「会社情報と同じ」を選択します。"]
[null,"会社情報と異なる場合は「別途指定」を選択の上、送付先の「社名」から「E-Mail」までを入力します。送付先が個人宅の場合は社名をプランクにしてください。"]
[null,"・受講料は自動計算されますので、入力は不要です。"]

{"sheet":"団体申込フォーム","index":1,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":false,"merged":[[4,2,4,4],[15,2,15,4],[16,2,16,4],[7,2,7,4],[9,2,9,4],[8,2,8,4]]}
[null,"入力いただく前に、「記入例1」シートにより入力方法をご確認ください。"]
[null,"ピンク色で表示された項目は全て必須項目となりますので、漏れなく入力してください。"]
[null,"ファイル送信先アドレス → jtas_seminar@kanzei.or.jp"]
[{"$f":"\"A1\"","v":"A1"},"〈 講　座　情　報 〉",{"$f":"IF(C5=\"\",\"\",OFFSET(設定!A4,(MATCH(団体申込フォーム!C5,設定!B4:B20,0)-1),0))","v":"A10"},{"$f":"OFFSET(設定!A4,(MATCH(団体申込フォーム!C5,設定!B4:B20,0)-1),3)","v":"無"},{"$f":"OFFSET(設定!A4,(MATCH(団体申込フォーム!C5,設定!B4:B20,0)-1),5)","v":"無"},{"$f":"OFFSET(設定!A4,(MATCH(団体申込フォーム!C5,設定!B4:B20,0)-1),6)","v":"無"}]
[{"$f":"\"A2\"","v":"A2"},"講座名称 ▼","通信教育講座　一般申込 ",null,null,{"$f":"OFFSET(設定!A4,(MATCH(団体申込フォーム!C5,設定!B4:B20,0)-1),2)","v":"会場受験"}]
[]
[null,"〈 会 社 情 報 〉"]
[{"$f":"\"B\"","v":"B"},"社名"]
[{"$f":"\"C\"","v":"C"},"部署名"]
[{"$f":"\"D\"","v":"D"},"社名部署名カナ"]
[{"$f":"\"E\"","v":"E"},"申込統括者",null,"申込統括者フリガナ"]
[{"$f":"\"F\"","v":"F"},"TEL",null,"FAX"]
[]
[{"$f":"\"G\"","v":"G"},"郵便番号",null,"都道府県 ▼"]
[{"$f":"\"H\"","v":"H"},"市区町村",null,"番地"]
[{"$f":"\"I\"","v":"I"},"ビル名等"]
[{"$f":"\"J\"","v":"J"},"E-Mail"]
[{"$f":"\"O\"","v":"O"},"模試実施希望日"]
[{"$f":"\"K\"","v":"K"},"申込年月日",null,"入金予定日"]
[{"$f":"\"L\"","v":"L"},"送金方法 ▼",null,"受講料（自動計算）",{"$f":"IF(C5=\"\",\"\",VLOOKUP(C5,設定!B4:G20,4,FALSE)*C23)","v":0}]
[{"$f":"\"M\"","v":"M"},"請求書 ▼",null,"通信欄"]
[]
[{"$f":"\"N\"","v":"N"},"〈 受 験 者 情 報 〉",{"$f":"SUM($A$25:$A$94)","v":0},{"$f":"SUM($A$25:$A$94)","v":0}]
[null,"番号","受講者名","受講者フリガナ","年齢 ▼","性別 ▼","受験科目数 ▼"," 受験会場 ▼","送付先 ▼","社名","部署名","郵便番号","都道府県 ▼","市区町村","番地","ビル名等","TEL","FAX","E-Mail"]
[{"$f":"IF(C25=\"\",0,1)","v":0},1,null,null,null,null,null,null,"別途指定"]
[{"$f":"IF(C26=\"\",0,1)","v":0},2,null,null,null,null,null,null,"会社情報と同じ"]
[0,3,null,null,null,null,null,null,"会社情報と同じ"]
[0,4,null,null,null,null,null,null,"会社情報と同じ"]
[0,5,null,null,null,null,null,null,"会社情報と同じ"]
[0,6,null,null,null,null,null,null,"会社情報と同じ"]
[0,7,null,null,null,null,null,null,"会社情報と同じ"]
[0,8,null,null,null,null,null,null,"会社情報と同じ"]
[0,9,null,null,null,null,null,null,"会社情報と同じ"]
[0,10,null,null,null,null,null,null,"会社情報と同じ"]
[0,11,null,null,null,null,null,null,"会社情報と同じ"]
[0,12,null,null,null,null,null,null,"会社情報と同じ"]
[0,13,null,null,null,null,null,null,"会社情報と同じ"]
[0,14,null,null,null,null,null,null,"会社情報と同じ"]
[0,15,null,null,null,null,null,null,"会社情報と同じ"]
[0,16,null,null,null,null,null,null,"会社情報と同じ"]
[0,17,null,null,null,null,null,null,"会社情報と同じ"]
[0,18,null,null,null,null,null,null,"会社情報と同じ"]
[0,19,null,null,null,null,null,null,"会社情報と同じ"]
[0,20,null,null,null,null,null,null,"会社情報と同じ"]
[{"$f":"IF(C45=\"\",0,1)","v":0},21,null,null,null,null,null,null,"会社情報と同じ"]
[0,22,null,null,null,null,null,null,"会社情報と同じ"]
[0,23,null,null,null,null,null,null,"会社情報と同じ"]
[0,24,null,null,null,null,null,null,"会社情報と同じ"]
[0,25,null,null,null,null,null,null,"会社情報と同じ"]
[0,26,null,null,null,null,null,null,"会社情報と同じ"]
[0,27,null,null,null,null,null,null,"会社情報と同じ"]
[0,28,null,null,null,null,null,null,"会社情報と同じ"]
[0,29,null,null,null,null,null,null,"会社情報と同じ"]
[0,30,null,null,null,null,null,null,"会社情報と同じ"]
[0,31,null,null,null,null,null,null,"会社情報と同じ"]
[0,32,null,null,null,null,null,null,"会社情報と同じ"]
[0,33,null,null,null,null,null,null,"会社情報と同じ"]
[0,34,null,null,null,null,null,null,"会社情報と同じ"]
[0,35,null,null,null,null,null,null,"会社情報と同じ"]
[0,36,null,null,null,null,null,null,"会社情報と同じ"]
[0,37,null,null,null,null,null,null,"会社情報と同じ"]
[0,38,null,null,null,null,null,null,"会社情報と同じ"]
[0,39,null,null,null,null,null,null,"会社情報と同じ"]
[0,40,null,null,null,null,null,null,"会社情報と同じ"]
[{"$f":"IF(C65=\"\",0,1)","v":0},41,null,null,null,null,null,null,"会社情報と同じ"]
[0,42,null,null,null,null,null,null,"会社情報と同じ"]
[0,43,null,null,null,null,null,null,"会社情報と同じ"]
[0,44,null,null,null,null,null,null,"会社情報と同じ"]
[0,45,null,null,null,null,null,null,"会社情報と同じ"]
[0,46,null,null,null,null,null,null,"会社情報と同じ"]
[0,47,null,null,null,null,null,null,"会社情報と同じ"]
[0,48,null,null,null,null,null,null,"会社情報と同じ"]
[0,49,null,null,null,null,null,null,"会社情報と同じ"]
[0,50,null,null,null,null,null,null,"会社情報と同じ"]
[0,51,null,null,null,null,null,null,"会社情報と同じ"]
[0,52,null,null,null,null,null,null,"会社情報と同じ"]
[0,53,null,null,null,null,null,null,"会社情報と同じ"]
[0,54,null,null,null,null,null,null,"会社情報と同じ"]
[0,55,null,null,null,null,null,null,"会社情報と同じ"]
[{"$f":"IF(C80=\"\",0,1)","v":0},56,null,null,null,null,null,null,"会社情報と同じ"]
[0,57,null,null,null,null,null,null,"会社情報と同じ"]
[0,58,null,null,null,null,null,null,"会社情報と同じ"]
[0,59,null,null,null,null,null,null,"会社情報と同じ"]
[0,60,null,null,null,null,null,null,"会社情報と同じ"]
[0,61,null,null,null,null,null,null,"会社情報と同じ"]
[0,62,null,null,null,null,null,null,"会社情報と同じ"]
[0,63,null,null,null,null,null,null,"会社情報と同じ"]
[0,64,null,null,null,null,null,null,"会社情報と同じ"]
[0,65,null,null,null,null,null,null,"会社情報と同じ"]
[0,66,null,null,null,null,null,null,"会社情報と同じ"]
[0,67,null,null,null,null,null,null,"会社情報と同じ"]
[0,68,null,null,null,null,null,null,"会社情報と同じ"]
[0,69,null,null,null,null,null,null,"会社情報と同じ"]
[0,70,null,null,null,null,null,null,"会社情報と同じ"]

{"sheet":"設定","index":2,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,null,"※受験場所が「会社受験」の時は、会場＝「無」にしてください。"]
["講座名称",null,"※受験場所が「オンライン受験」の時は、会場＝「無」、受験科目＝「無」にしてください。",null,null,null,null,null,"会場名",null,null,null,"受験科目数"]
["受講ﾊﾟﾀｰﾝ","受講名","受験場所","会場","単価","受験科目","模試実施希望日",null,"会場１","会場２","会場３",null,"受験科目数"]
["A10","通信教育講座　一般申込 ","会場受験","無",66000,"無","無",null,"札幌",null,"　",null,"１科目"]
["A11","通信教育講座　一般申込＋スクーリング","会場受験","無",75900,"無","無",null,"仙台",null,null,null,"２科目"]
["A12","通信教育講座　一般申込＋特別答練","会場受験","無",80520,"無","無",null,"横浜",null,null,null,"３科目"]
["A14","通信教育講座　一般申込＋スクーリング＋特別答練","会場受験","無",90420,"無","無",null,"静岡"]
["C10","講習会　","会場受験","無",168960,"無","無",null,"名古屋"]
[null,null,null,null,null,null,null,null,"阪神地区"]
[null,null,null,null,null,null,null,null,"広島"]
[null,null,null,null,null,null,null,null,"福岡"]
[null,null,null,null,null,null,null,null,"那覇"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"※受験場所は、会社受験、会場受験、オンライン受験の３種類を設定してください。"]