{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["育英会送付用ファイルの作成","マクロ要求事項","候補値一覧","確認用データ","入力チェック内容"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":37,"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":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[45,6,45,8],[46,6,46,8],[52,6,52,8],[51,6,51,8],[4,2,4,3],[7,2,7,3],[4,4,4,6],[7,4,7,6],[32,6,32,8],[41,6,41,8],[35,6,35,8],[36,6,36,8],[37,6,37,8],[38,6,38,8],[39,6,39,8],[44,6,44,8],[1,1,1,9],[30,2,31,2],[30,3,30,4],[10,5,11,5],[30,5,31,5],[10,3,10,4],[10,2,11,2],[30,6,31,8],[10,8,11,8],[10,6,11,6],[10,7,11,7],[28,7,28,8],[42,6,42,8],[43,6,43,8],[33,6,33,8],[34,6,34,8],[40,6,40,8]]}
[null,"（様式１1）",null,null,"送付書類の一括チェックと送付ファイル作成専用シート（外国人留学生）",null,null,null,null,"2019年度"]
[null,"応募書類(願書・推薦書・小論文)の記載内容チェック／公益財団法人飯塚毅育英会への送付用ファイルの作成"]
[]
[null,null,"１．応募書類（願書・推薦書・小論文）を格納するフォルダを選択してください。"]
[null,null,"格納フォルダ"]
[]
[null,null,"２．貴校の大学名を入力してください。"]
[null,null,"大　学　名"]
[]
[null,null,"３．応募者名を入力してください。(注：｢願書｣･｢推薦書｣に入力した姓名と同じ姓名を入力してください。姓のみの応募者の場合は、名に空白を入力してください。)"]
[null,null,"行","応募者名",null,"No","願書ファイル名","推薦書ファイル名","小論文ファイル名"]
[null,null,null,"姓","名"]
[null,null,1,null,null,null,{"$f":"IF(AND(ISBLANK(D13)=FALSE,ISBLANK(E13)=FALSE),\"願書\"&TRIM(D13)&TRIM(E13)&F13&\".xlsx\",\"\")","v":""},{"$f":"IF(AND(ISBLANK(D13)=FALSE,ISBLANK(E13)=FALSE),\"推薦書\"&TRIM(D13)&TRIM(E13)&F13&\".xlsx\",\"\")","v":""},{"$f":"IF(AND(ISBLANK(D13)=FALSE,ISBLANK(E13)=FALSE),\"小論文\"&TRIM(D13)&TRIM(E13)&F13&\".docx\",\"\")","v":""}]
[null,null,2,null,null,null,{"$f":"IF(AND(ISBLANK(D14)=FALSE,ISBLANK(E14)=FALSE),\"願書\"&TRIM(D14)&TRIM(E14)&F14&\".xlsx\",\"\")","v":""},{"$f":"IF(AND(ISBLANK(D14)=FALSE,ISBLANK(E14)=FALSE),\"推薦書\"&TRIM(D14)&TRIM(E14)&F14&\".xlsx\",\"\")","v":""},{"$f":"IF(AND(ISBLANK(D14)=FALSE,ISBLANK(E14)=FALSE),\"小論文\"&TRIM(D14)&TRIM(E14)&F14&\".docx\",\"\")","v":""}]
[null,null,3,null,null,null,"","",""]
[null,null,4,null,null,null,"","",""]
[null,null,5,null,null,null,"","",""]
[null,null,6,null,null,null,"","",""]
[null,null,7,null,null,null,"","",""]
[null,null,8,null,null,null,"","",""]
[null,null,9,null,null,null,"","",""]
[null,null,10,null,null,null,"","",""]
[null,null,11,null,null,null,"","",""]
[null,null,12,null,null,null,{"$f":"IF(AND(ISBLANK(D24)=FALSE,ISBLANK(E24)=FALSE),\"願書\"&TRIM(D24)&TRIM(E24)&F24&\".xlsx\",\"\")","v":""},{"$f":"IF(AND(ISBLANK(D24)=FALSE,ISBLANK(E24)=FALSE),\"推薦書\"&TRIM(D24)&TRIM(E24)&F24&\".xlsx\",\"\")","v":""},{"$f":"IF(AND(ISBLANK(D24)=FALSE,ISBLANK(E24)=FALSE),\"小論文\"&TRIM(D24)&TRIM(E24)&F24&\".docx\",\"\")","v":""}]
[null,null,13,null,null,null,{"$f":"IF(AND(ISBLANK(D25)=FALSE,ISBLANK(E25)=FALSE),\"願書\"&TRIM(D25)&TRIM(E25)&F25&\".xlsx\",\"\")","v":""},{"$f":"IF(AND(ISBLANK(D25)=FALSE,ISBLANK(E25)=FALSE),\"推薦書\"&TRIM(D25)&TRIM(E25)&F25&\".xlsx\",\"\")","v":""},{"$f":"IF(AND(ISBLANK(D25)=FALSE,ISBLANK(E25)=FALSE),\"小論文\"&TRIM(D25)&TRIM(E25)&F25&\".docx\",\"\")","v":""}]
[null,null,14,null,null,null,{"$f":"IF(AND(ISBLANK(D26)=FALSE,ISBLANK(E26)=FALSE),\"願書\"&TRIM(D26)&TRIM(E26)&F26&\".xlsx\",\"\")","v":""},{"$f":"IF(AND(ISBLANK(D26)=FALSE,ISBLANK(E26)=FALSE),\"推薦書\"&TRIM(D26)&TRIM(E26)&F26&\".xlsx\",\"\")","v":""},{"$f":"IF(AND(ISBLANK(D26)=FALSE,ISBLANK(E26)=FALSE),\"小論文\"&TRIM(D26)&TRIM(E26)&F26&\".docx\",\"\")","v":""}]
[null,null,15,null,null,null,"","",""]
[]
[null,null,null,null,null,null,null,"①応募書類記載内容のチェック"]
[null,null,"４．応募書類記載内容のチェック結果を確認してください。"]
[null,null,"行","応募者名",null,"No","応募書類記載内容のチェック結果"]
[null,null,null,"姓","名"]
[null,null,1]
[null,null,2]
[null,null,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,13]
[null,null,14]
[null,null,15]
[]
[null,null,"５．育英会送付用ファイルを作成してください。"]
[]
[]
[null,null,"\n",null,null,null,"育英会送付用ファイル\n応募書類格納フォルダ内に｢送付用ファイル｣フォルダが作成され下のファイル名で格納されます。\n(ご注意：作成された育英会送付用ファイルのファイル名は変更しないでください。)"]
[null,null,null,null,null,null,"　・願書：　　　　 ｢貴校名願書2019｣ 　(例：○○○大学願書2019)\n　・推薦書：　　　 ｢貴校名推薦書2019｣ (例：○○○大学推薦書2019)\n　・課題小論文：   ｢貴校名小論文2019｣ (例：○○○大学小論文2019)"]

{"sheet":"マクロ要求事項","index":1,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":true,"merged":[[3,1,3,2],[3,3,3,5],[6,1,6,2],[6,3,6,5],[9,1,10,1],[9,2,9,3],[9,4,9,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[26,1,27,1],[26,2,26,3],[26,4,26,5],[26,6,27,6],[9,9,10,9],[37,7,37,9],[26,7,27,9],[28,7,28,9],[29,7,29,9],[30,7,30,9],[31,7,31,9],[32,7,32,9],[33,7,33,9],[34,7,34,9],[35,7,35,9],[36,7,36,9]]}
[null,"応募書類（送付用ファイル）の作成"]
[]
[null,"１．作業フォルダの設定"]
[null,"作業フォルダ",null,"C:\\indata\\飯塚毅育英会提出書類"]
[]
[null,"２．学校の選択"]
[null,"学校名"]
[]
[null,"３．応募者の入力"]
[null,"行","応募者名",null,"応募者名フリガナ",null,"生年月日（西暦）","願書ファイル名","推薦書ファイル名","小論文ファイル名"]
[null,null,"姓","名","姓","名"]
[null,1,"堤","敬子","テイ","ケイコ","2001-11-02","願書_堤敬子","推薦書_堤敬子","小論文_堤敬子"]
[null,2,"宇都宮","太郎","ウツノミヤ","タロウ","2002-03-20","願書_宇都宮太郎","推薦書_宇都宮太郎","小論文_宇都宮太郎"]
[null,3,"栃木","次郎","トチギ","ジロウ","2001-08-07","願書_栃木次郎","推薦書_栃木次郎","小論文_栃木次郎"]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[]
[]
[null,null,null,null,null,null,null,null,null,"①願書・推薦書入力内容のチェック"]
[]
[null,"４．送付ファイルの作成状況"]
[null,"行","応募者名",null,"応募者名フリガナ",null,"生年月日（西暦）","入力内容チェック結果"]
[null,null,"姓","名","姓","名"]
[null,1,"堤","敬子","テイ","ケイコ","2001-11-02","【願書】ファイルが存在しません。"]
[null,2,"宇都宮","太郎","ウツノミヤ","タロウ","2002-03-20","OK"]
[null,3,"栃木","次郎","トチギ","ジロウ","2001-08-07","【推薦書】評定平均値が未入力です。"]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[]
[null,null,null,null,null,null,null,null,null,"②育英会送付用ファイルの作成"]

{"sheet":"候補値一覧","index":2,"n_rows":103,"n_cols":1,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
["候補値一覧"]
[]
["Ⅰ　学校名一覧"]
[]
["学校名一覧"]
["＜以下、県立高校＞"]
["栃木県立宇都宮高等学校"]
["栃木県立宇都宮東高等学校"]
["栃木県立宇都宮南高等学校"]
["栃木県立宇都宮北高等学校"]
["栃木県立宇都宮清陵高等学校"]
["栃木県立宇都宮女子高等学校"]
["栃木県立宇都宮中央女子高等学校"]
["栃木県立宇都宮白楊高等学校"]
["栃木県立宇都宮工業高等学校"]
["栃木県立宇都宮商業高等学校"]
["栃木県立鹿沼高等学校"]
["栃木県立鹿沼東高等学校"]
["栃木県立鹿沼南高等学校"]
["栃木県立鹿沼商工高等学校"]
["栃木県立今市高等学校"]
["栃木県立今市工業高等学校"]
["栃木県立日光明峰高等学校"]
["栃木県立上三川高等学校"]
["栃木県立石橋高等学校"]
["栃木県立小山高等学校"]
["栃木県立小山南高等学校"]
["栃木県立小山西高等学校"]
["栃木県立小山北桜高等学校"]
["栃木県立小山城南高等学校"]
["栃木県立栃木高等学校"]
["栃木県立栃木女子高等学校"]
["栃木県立栃木農業高等学校"]
["栃木県立栃木工業高等学校"]
["栃木県立栃木商業高等学校"]
["栃木県立学悠館高等学校"]
["栃木県立栃木翔南高等学校"]
["栃木県立壬生高等学校"]
["栃木県立佐野高等学校"]
["栃木県立佐野東高等学校"]
["栃木県立佐野松桜高等学校"]
["栃木県立足利高等学校"]
["栃木県立足利南高等学校"]
["栃木県立足利女子高等学校"]
["栃木県立足利清風高等学校"]
["栃木県立足利工業高等学校"]
["栃木県立真岡高等学校"]
["栃木県立真岡女子高等学校"]
["栃木県立真岡北陵高等学校"]
["栃木県立真岡工業高等学校"]
["栃木県立益子芳星高等学校"]
["栃木県立茂木高等学校"]
["栃木県立烏山高等学校"]
["栃木県立馬頭高等学校"]
["栃木県立矢板高等学校"]
["栃木県立矢板東高等学校"]
["栃木県立高根沢高等学校"]
["栃木県立さくら清修高等学校"]
["栃木県立大田原高等学校"]
["栃木県立大田原女子高等学校"]
["栃木県立大田原東高等学校"]
["栃木県立黒羽高等学校"]
["栃木県立那須拓陽高等学校"]
["栃木県立那須清峰高等学校"]
["栃木県立那須高等学校"]
["栃木県立黒磯高等学校"]
["栃木県立黒磯南高等学校"]
["＜以下、私立高校＞"]
["作新学院高等学校"]
["文星芸術大学附属高等学校"]
["宇都宮文星女子高等学校"]
["宇都宮短期大学附属高等学校"]
["足利短期大学附属高等学校"]
["佐野清澄高等学校"]
["青藍泰斗高等学校"]
["白鴎大学足利高等学校"]
["宇都宮海星女子学院高等学校"]
["國學院大學栃木高等学校"]
["矢板中央高等学校"]
["佐野日本大学高等学校"]
["足利大学附属高等学校"]
["幸福の科学学園高等学校"]
["日々輝学園高等学校"]
["佐野日本大学中等教育学校"]
["＜以下、高等専門学校＞"]
["小山工業高等専門学校"]
["＜以下、特別支援学校＞"]
["栃木県立盲学校"]
["栃木県立聾学校"]
["富屋特別支援学校"]
["宇都宮青葉高等学園"]
["宇都宮大学教育学部付属特別支援学校"]
["今市特別支援学校 "]
["国分寺特別支援学校 "]
["栃木特別支援学校 "]
["足利中央特別支援学校 "]
["益子特別支援学校 "]
["那須特別支援学校 "]
["南那須特別支援学校 "]
["のざわ特別支援学校"]
["わかくさ特別支援学校"]
["岡本特別支援学校 "]
["足利特別支援学校 "]

{"sheet":"確認用データ","index":3,"n_rows":123,"n_cols":116,"rows_kept":123,"cut":false,"hidden":true,"merged":[]}
["確認用データ"]
[]
["Ⅰ　ファイルの存在チェック"]
[]
["１.ファイルの有無（所定のファイル名のファイルが格納フォルダにあるか？）"]
[" (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,"-"]
[null,null,"-"]
[null,null,"-"]
[]
[" (2) 推薦書（「応募者名推薦書」）"]
[null,"ファイル名","ファイルの有無"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[]
[" (3) 小論文（「応募者名小論文」）"]
[null,"ファイル名","ファイルの有無"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[null,null,"-"]
[]
["2．同姓同名の場合、「No」に入力有無"]
["　　マクロに実装済"]
[]
[]
["Ⅱ　願書（外国人留学生）についてのチェック内容"]
["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,"-","-","-"]
[null,null,"-","-","-"]
[null,null,"-","-","-"]
[]
["2．入力値の属性"]
["　入力用ファイルの値"]
[null,"ファイル名","フリガナ_姓","フリガナ_名","氏名_姓","氏名_名","生年月日_年","生年月日_月","生年月日_日","性別","国籍","本人_郵便番号1","本人_郵便番号2","本人_住所1","本人_住所2","本人_電話番号1","本人_電話番号2","本人_電話番号3","家族_郵便番号1","家族_郵便番号2","家族_住所1","家族_住所2","家族_電話番号1","家族_電話番号2","家族_電話番号3","大学名","学部","学科","大学_学年","課程","研究科","専攻","大学院_学年","入学年月_年","入学年月_月","卒業年月_年","卒業年月_月","略歴_年1","略歴_月1","略歴_学歴等1","略歴_年2","略歴_月2","略歴_学歴等2","略歴_年3","略歴_月3","略歴_学歴等3","略歴_年4","略歴_月4","略歴_学歴等4","略歴_年5","略歴_月5","略歴_学歴等5","略歴_年6","略歴_月6","略歴_学歴等6","略歴_年7","略歴_月7","略歴_学歴等7","略歴_年8","略歴_月8","略歴_学歴等8","略歴_年9","略歴_月9","略歴_学歴等9","略歴_年10","略歴_月10","略歴_学歴等10","略歴_年11","略歴_月11","略歴_学歴等11","略歴_年12","略歴_月12","略歴_学歴等12","家族_氏名1","家族_続柄1","家族_年齢1","家族_氏名2","家族_続柄2","家族_年齢2","家族_氏名3","家族_続柄3","家族_年齢3","家族_氏名4","家族_続柄4","家族_年齢4","家族_氏名5","家族_続柄5","家族_年齢5","家族_氏名6","家族_続柄6","家族_年齢6","家族_氏名7","家族_続柄7","家族_年齢7","家族_氏名8","家族_続柄8","家族_年齢8","家族_氏名9","家族_続柄9","家族_年齢9","家族_氏名10","家族_続柄10","家族_年齢10","家族_氏名11","家族_続柄11","家族_年齢11","家族_氏名12","家族_続柄12","家族_年齢12","留学形態","留学動機","卒業後進路希望","給付希望理由","入力年月日_年","入力年月日_月","入力年月日_日"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ⅱ　推薦書（外国人留学生）についてのチェック内容"]
["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,"-","-","-"]
[null,null,"-","-","-"]
[null,null,"-","-","-"]
[]
["2．入力値の属性"]
["　入力用ファイルの値"]
[null,"ファイル名","氏名","性別","生年月日_年","生年月日_月","生年月日_日","大学名","学部","学科","大学_学年","課程","研究科","専攻","大学院_学年","卒業年月_年","卒業年月_月","卒業修了区分","推薦所見","推薦書作成者名","日付_年","日付_月","日付_日","学長氏名"]

{"sheet":"入力チェック内容","index":4,"n_rows":210,"n_cols":14,"rows_kept":210,"cut":false,"hidden":true,"merged":[[6,4,8,4]]}
["入力チェック内容"]
[]
["Ⅰ　入力チェック結果を表示する警告文の内容"]
["１．ファイルの有無"]
["　　＊警告文_1~_3をつなげて表示します。"]
[null,"行","ファイルの種類","警告文_1","警告文_２","警告文_3"]
[null,1,"願書","願書ファイルがありません。格納フォルダに「","＊この箇所にはファイル名が自動で入ります。＊","」があるか、確認してください。"]
[null,2,"推薦書","推薦書ファイルがありません。格納フォルダに「",null,"」があるか、確認してください。"]
[null,3,"小論文","小論文ファイルがありません。格納フォルダに「",null,"」があるか、確認してください。"]
[]
["２．同姓同名の場合、「No」に入力有無"]
[null,"行","警告文"]
[null,1,"同姓同名の応募者がいる場合、該当応募者の「No」に数字を入力（選択）してください。"]
[]
["３．ファイルの年度"]
[null,"行","ファイルの種類","警告文"]
[null,1,"願書","応募書類（願書）が最新版ではありません。公益財団法人飯塚毅育英会のHPより最新の応募書類ファイルをダウンロードして、入力してください。"]
[null,2,"推薦書","応募書類（推薦書）が最新版ではありません。公益財団法人飯塚毅育英会のHPより最新の応募書類ファイルをダウンロードして、入力してください。"]
[]
["４．必須入力チェック"]
["　　＊警告文_1~_2をつなげて表示します。"]
[null,"行","警告文_1","警告文_2"]
[null,1,"＊この箇所には列名｢項目名_入力チェック結果表示用｣の値が自動で入ります。＊","を入力してください。"]
[]
["５．文字数チェック"]
["　　＊警告文_1~_4をつなげて表示します。"]
[null,"行","警告文_1","警告文_2","警告文_3","警告文_4"]
[null,1,"＊この箇所には列名｢項目名_入力チェック結果表示用｣の値が自動で入ります。＊","は","＊この箇所には列名｢入力可能文字数｣の値が自動で入ります。＊","文字以内で入力してください。"]
[]
["６．日付チェック"]
["　　＊警告文_1~_2をつなげて表示します。"]
[null,"行","警告文_1","警告文_2"]
[null,1,"＊この箇所には列名｢項目名_入力チェック結果表示用｣の値が自動で入ります。＊","の日付の入力に誤りがあります。正しい日付を入力してください。"]
[]
["７．半角数字のみ入力可能チェック"]
["　　＊警告文_1~_2をつなげて表示します。"]
[null,"行","警告文_1","警告文_2"]
[null,1,"＊この箇所には列名｢項目名_入力チェック結果表示用｣の値が自動で入ります。＊","の入力に誤りがあります。数字で入力してください。"]
[]
["８．　「入力チェック／送付用ファイル作成シート」の入力内容と、願書の入力内容に相違がある。"]
["　　＊警告文_1~_4をつなげて表示します。"]
[null,"行","警告文_1","警告文_2","警告文_3","警告文_4"]
[null,1,"＊この箇所には列名｢項目名_入力チェック結果表示用｣の値が自動で入ります。＊","の入力に誤りがあります。正しい","＊この箇所には列名｢項目名_入力チェック結果表示用｣の値が自動で入ります。＊","を入力してください。"]
[]
["Ⅱ　願書ファイル入力チェック"]
["１．入力チェック項目"]
["　　テーブル名｢テーブル_入力チェック項目_願書ファイル｣"]
[null,null,null,null,null,null,null,"【入力可能文字数を制限する場合】\n当列に正の数字を入力\n【入力可能文字数を制限しない場合】\n当列に｢制限しない｣と入力","0:入力必須でない\n　(必須チェックをしない)\n1:入力必須である\n　(必須チェックをする)\n2:条件付で入力必須である\n　(必須チェックをする)\n　＊列名｢入力必須条件Excel\n　　定義名｣の項目の値に入力\n　　がある場合にのみ入力必須\n　　とする。",null,"0:日付ではない\n　(日付チェックをしない)\n1:日付である\n　(日付チェックをする)",null,null,"0:半角数字以外も入力して良い\n　(半角数字のみかどうかの\n　 チェックをしない)\n1:半角数字以外入力しては\n　いけない\n　(半角数字のみかどうかの 　\n　 チェックをする)"]
[null,"行","大分類","小分類","項目名","項目名_入力チェック結果表示用","Excel定義名","入力可能文字数","入力必須区分","入力必須条件Excel定義名","日付チェック区分","日付項目グループ番号","日付属性","半角数字のみ入力可能区分"]
[null,1,"１．出願者情報","-","フリガナ（姓）","【願書】フリガナ_姓","フリガナ_姓",20,1,"-",0,"-","-",0]
[null,2,"１．出願者情報","-","フリガナ（名）","【願書】フリガナ_名","フリガナ_名",20,0,"-",0,"-","-",0]
[null,3,"１．出願者情報","-","氏名（姓）","【願書】氏名_姓","氏名_姓",20,1,"-",0,"-","-",0]
[null,4,"１．出願者情報","-","氏名（名）","【願書】氏名_名","氏名_名",20,0,"-",0,"-","-",0]
[null,5,"１．出願者情報","-","生年月日（年）","【願書】生年月日_年","生年月日_年",4,1,"-",0,1,"年",0]
[null,6,"１．出願者情報","-","生年月日（月）","【願書】生年月日_月","生年月日_月",2,1,"-",0,1,"月",0]
[null,7,"１．出願者情報","-","生年月日（日）","【願書】生年月日_日","生年月日_日",2,1,"-",1,1,"日",0]
[null,8,"１．出願者情報","-","性別","【願書】性別","性別","制限しない",1,"-",0,"-","-",0]
[null,9,"１．出願者情報","-","国籍","【願書】国籍","国籍",40,1,"-",0,"-","-",0]
[null,10,"１．出願者情報","-","本人住所－郵便番号","【願書】本人_郵便番号1","本人_郵便番号1",3,1,"-",0,"-","-",1]
[null,11,"１．出願者情報","-","本人住所－郵便番号","【願書】本人_郵便番号2","本人_郵便番号2",4,1,"-",0,"-","-",1]
[null,12,"１．出願者情報","-","本人住所－住所1","【願書】本人_住所1","本人_住所1",40,1,"-",0,"-","-",0]
[null,13,"１．出願者情報","-","本人住所－住所2","【願書】本人_住所2","本人_住所2",40,0,"-",0,"-","-",0]
[null,14,"１．出願者情報","-","本人住所－TEL","【願書】本人_電話番号1","本人_電話番号1",5,1,"-",0,"-","-",1]
[null,15,"１．出願者情報","-","本人住所－TEL","【願書】本人_電話番号2","本人_電話番号2",5,1,"-",0,"-","-",1]
[null,16,"１．出願者情報","-","本人住所－TEL","【願書】本人_電話番号3","本人_電話番号3",5,1,"-",0,"-","-",1]
[null,17,"１．出願者情報","-","家族住所－郵便番号","【願書】家族_郵便番号1","家族_郵便番号1",3,0,"-",0,"-","-",1]
[null,18,"１．出願者情報","-","家族住所－郵便番号","【願書】家族_郵便番号2","家族_郵便番号2",4,0,"-",0,"-","-",1]
[null,19,"１．出願者情報","-","家族住所－住所1","【願書】家族_住所1","家族_住所1",40,0,"-",0,"-","-",0]
[null,20,"１．出願者情報","-","家族住所－住所2","【願書】家族_住所2","家族_住所2",40,0,"-",0,"-","-",0]
[null,21,"１．出願者情報","-","家族住所－TEL","【願書】家族_電話番号1","家族_電話番号1",10,0,"-",0,"-","-",1]
[null,22,"１．出願者情報","-","家族住所－TEL","【願書】家族_電話番号2","家族_電話番号2",10,0,"-",0,"-","-",1]
[null,23,"１．出願者情報","-","家族住所－TEL","【願書】家族_電話番号3","家族_電話番号3",10,0,"-",0,"-","-",1]
[null,24,"２．在籍大学","-","大学名","【願書】大学名","大学名",60,1,"-",0,"-","-",0]
[null,25,"２．在籍大学","-","学部","【願書】学部","学部",40,0,"-",0,"-","-",0]
[null,26,"２．在籍大学","-","学科","【願書】学科","学科",40,2,"学部",0,"-","-",0]
[null,27,"２．在籍大学","-","学年","【願書】大学_学年","大学_学年",1,2,"学部",0,"-","-",0]
[null,28,"２．在籍大学","-","課程","【願書】課程","課程",40,0,"-",0,"-","-",0]
[null,29,"２．在籍大学","-","研究科","【願書】研究科","研究科",40,2,"課程",0,"-","-",0]
[null,30,"２．在籍大学","-","専攻","【願書】専攻","専攻",40,2,"課程",0,"-","-",0]
[null,31,"２．在籍大学","-","学年","【願書】大学院_学年","大学院_学年",1,2,"課程",0,"-","-",0]
[null,32,"２．在籍大学","-","入学年月（年）","【願書】入学年月_年","入学年月_年",4,1,"-",0,"-","-",0]
[null,33,"２．在籍大学","-","入学年月（月）","【願書】入学年月_月","入学年月_月",2,1,"-",0,"-","-",0]
[null,34,"２．在籍大学","-","卒業（修了）年月（年）","【願書】卒業年月_年","卒業年月_年",4,1,"-",0,"-","-",0]
[null,35,"２．在籍大学","-","卒業（修了）年月（月）","【願書】卒業年月_月","卒業年月_月",2,1,"-",0,"-","-",0]
[null,36,"３．略歴","-","年","【願書】略歴1_年","略歴_年1",4,0,"-",0,"-","-",0]
[null,37,"３．略歴","-","月","【願書】略歴1_月","略歴_月1",2,0,"-",0,"-","-",0]
[null,38,"３．略歴","-","学歴","【願書】略歴1_学歴等","略歴_学歴等1",100,0,"-",0,"-","-",0]
[null,39,"３．略歴","-","年","【願書】略歴2_年","略歴_年2",4,0,"-",0,"-","-",0]
[null,40,"３．略歴","-","月","【願書】略歴2_月","略歴_月2",2,0,"-",0,"-","-",0]
[null,41,"３．略歴","-","学歴","【願書】略歴2_学歴等","略歴_学歴等2",100,0,"-",0,"-","-",0]
[null,42,"３．略歴","-","年","【願書】略歴3_年","略歴_年3",4,0,"-",0,"-","-",0]
[null,43,"３．略歴","-","月","【願書】略歴3_月","略歴_月3",2,0,"-",0,"-","-",0]
[null,44,"３．略歴","-","学歴","【願書】略歴3_学歴等","略歴_学歴等3",100,0,"-",0,"-","-",0]
[null,45,"３．略歴","-","年","【願書】略歴4_年","略歴_年4",4,0,"-",0,"-","-",0]
[null,46,"３．略歴","-","月","【願書】略歴4_月","略歴_月4",2,0,"-",0,"-","-",0]
[null,47,"３．略歴","-","学歴","【願書】略歴4_学歴等","略歴_学歴等4",100,0,"-",0,"-","-",0]
[null,48,"３．略歴","-","年","【願書】略歴5_年","略歴_年5",4,0,"-",0,"-","-",0]
[null,49,"３．略歴","-","月","【願書】略歴5_月","略歴_月5",2,0,"-",0,"-","-",0]
[null,50,"３．略歴","-","学歴","【願書】略歴5_学歴等","略歴_学歴等5",100,0,"-",0,"-","-",0]
[null,51,"３．略歴","-","年","【願書】略歴6_年","略歴_年6",4,0,"-",0,"-","-",0]
[null,52,"３．略歴","-","月","【願書】略歴6_月","略歴_月6",2,0,"-",0,"-","-",0]
[null,53,"３．略歴","-","学歴","【願書】略歴6_学歴等","略歴_学歴等6",100,0,"-",0,"-","-",0]
[null,54,"３．略歴","-","年","【願書】略歴7_年","略歴_年7",4,0,"-",0,"-","-",0]
[null,55,"３．略歴","-","月","【願書】略歴7_月","略歴_月7",2,0,"-",0,"-","-",0]
[null,56,"３．略歴","-","学歴","【願書】略歴7_学歴等","略歴_学歴等7",100,0,"-",0,"-","-",0]
[null,57,"３．略歴","-","年","【願書】略歴8_年","略歴_年8",4,0,"-",0,"-","-",0]
[null,58,"３．略歴","-","月","【願書】略歴8_月","略歴_月8",2,0,"-",0,"-","-",0]
[null,59,"３．略歴","-","学歴","【願書】略歴8_学歴等","略歴_学歴等8",100,0,"-",0,"-","-",0]
[null,60,"３．略歴","-","年","【願書】略歴9_年","略歴_年9",4,0,"-",0,"-","-",0]
[null,61,"３．略歴","-","月","【願書】略歴9_月","略歴_月9",2,0,"-",0,"-","-",0]
[null,62,"３．略歴","-","学歴","【願書】略歴9_学歴等","略歴_学歴等9",100,0,"-",0,"-","-",0]
[null,63,"３．略歴","-","年","【願書】略歴10_年","略歴_年10",4,0,"-",0,"-","-",0]
[null,64,"３．略歴","-","月","【願書】略歴10_月","略歴_月10",2,0,"-",0,"-","-",0]
[null,65,"３．略歴","-","学歴","【願書】略歴10_学歴等","略歴_学歴等10",100,0,"-",0,"-","-",0]
[null,66,"３．略歴","-","年","【願書】略歴11_年","略歴_年11",4,0,"-",0,"-","-",0]
[null,67,"３．略歴","-","月","【願書】略歴11_月","略歴_月11",2,0,"-",0,"-","-",0]
[null,68,"３．略歴","-","学歴","【願書】略歴11_学歴等","略歴_学歴等11",100,0,"-",0,"-","-",0]
[null,69,"３．略歴","-","年","【願書】略歴12_年","略歴_年12",4,0,"-",0,"-","-",0]
[null,70,"３．略歴","-","月","【願書】略歴12_月","略歴_月12",2,0,"-",0,"-","-",0]
[null,71,"３．略歴","-","学歴","【願書】略歴12_学歴等","略歴_学歴等12",100,0,"-",0,"-","-",0]
[null,72,"４．家族","-","氏名","【願書】家族1_氏名","家族_氏名1",40,0,"-",0,"-","-",0]
[null,73,"４．家族","-","続柄","【願書】家族1_続柄","家族_続柄1","制限しない",2,"家族_氏名1",0,"-","-",0]
[null,74,"４．家族","-","年齢","【願書】家族1_年齢","家族_年齢1",3,2,"家族_氏名1",0,"-","-",0]
[null,75,"４．家族","-","氏名","【願書】家族2_氏名","家族_氏名2",40,0,"-",0,"-","-",0]
[null,76,"４．家族","-","続柄","【願書】家族2_続柄","家族_続柄2","制限しない",2,"家族_氏名2",0,"-","-",0]
[null,77,"４．家族","-","年齢","【願書】家族2_年齢","家族_年齢2",3,2,"家族_氏名2",0,"-","-",0]
[null,78,"４．家族","-","氏名","【願書】家族3_氏名","家族_氏名3",40,0,"-",0,"-","-",0]
[null,79,"４．家族","-","続柄","【願書】家族3_続柄","家族_続柄3","制限しない",2,"家族_氏名3",0,"-","-",0]
[null,80,"４．家族","-","年齢","【願書】家族3_年齢","家族_年齢3",3,2,"家族_氏名3",0,"-","-",0]
[null,81,"４．家族","-","氏名","【願書】家族4_氏名","家族_氏名4",40,0,"-",0,"-","-",0]
[null,82,"４．家族","-","続柄","【願書】家族4_続柄","家族_続柄4","制限しない",2,"家族_氏名4",0,"-","-",0]
[null,83,"４．家族","-","年齢","【願書】家族4_年齢","家族_年齢4",3,2,"家族_氏名4",0,"-","-",0]
[null,84,"４．家族","-","氏名","【願書】家族5_氏名","家族_氏名5",40,0,"-",0,"-","-",0]
[null,85,"４．家族","-","続柄","【願書】家族5_続柄","家族_続柄5","制限しない",2,"家族_氏名5",0,"-","-",0]
[null,86,"４．家族","-","年齢","【願書】家族5_年齢","家族_年齢5",3,2,"家族_氏名5",0,"-","-",0]
[null,87,"４．家族","-","氏名","【願書】家族6_氏名","家族_氏名6",40,0,"-",0,"-","-",0]
[null,88,"４．家族","-","続柄","【願書】家族6_続柄","家族_続柄6","制限しない",2,"家族_氏名6",0,"-","-",0]
[null,89,"４．家族","-","年齢","【願書】家族6_年齢","家族_年齢6",3,2,"家族_氏名6",0,"-","-",0]
[null,90,"４．家族","-","氏名","【願書】家族7_氏名","家族_氏名7",40,0,"-",0,"-","-",0]
[null,91,"４．家族","-","続柄","【願書】家族7_続柄","家族_続柄7","制限しない",2,"家族_氏名7",0,"-","-",0]
[null,92,"４．家族","-","年齢","【願書】家族7_年齢","家族_年齢7",3,2,"家族_氏名7",0,"-","-",0]
[null,93,"４．家族","-","氏名","【願書】家族8_氏名","家族_氏名8",40,0,"-",0,"-","-",0]
[null,94,"４．家族","-","続柄","【願書】家族8_続柄","家族_続柄8","制限しない",2,"家族_氏名8",0,"-","-",0]
[null,95,"４．家族","-","年齢","【願書】家族8_年齢","家族_年齢8",3,2,"家族_氏名8",0,"-","-",0]
[null,96,"４．家族","-","氏名","【願書】家族9_氏名","家族_氏名9",40,0,"-",0,"-","-",0]
[null,97,"４．家族","-","続柄","【願書】家族9_続柄","家族_続柄9","制限しない",2,"家族_氏名9",0,"-","-",0]
[null,98,"４．家族","-","年齢","【願書】家族9_年齢","家族_年齢9",3,2,"家族_氏名9",0,"-","-",0]
[null,99,"４．家族","-","氏名","【願書】家族10_氏名","家族_氏名10",40,0,"-",0,"-","-",0]
[null,100,"４．家族","-","続柄","【願書】家族10_続柄","家族_続柄10","制限しない",2,"家族_氏名10",0,"-","-",0]
[null,101,"４．家族","-","年齢","【願書】家族10_年齢","家族_年齢10",3,2,"家族_氏名10",0,"-","-",0]
[null,102,"４．家族","-","氏名","【願書】家族11_氏名","家族_氏名11",40,0,"-",0,"-","-",0]
[null,103,"４．家族","-","続柄","【願書】家族11_続柄","家族_続柄11","制限しない",2,"家族_氏名11",0,"-","-",0]
[null,104,"４．家族","-","年齢","【願書】家族11_年齢","家族_年齢11",3,2,"家族_氏名11",0,"-","-",0]
[null,105,"４．家族","-","氏名","【願書】家族12_氏名","家族_氏名12",40,0,"-",0,"-","-",0]
[null,106,"４．家族","-","続柄","【願書】家族12_続柄","家族_続柄12","制限しない",2,"家族_氏名12",0,"-","-",0]
[null,107,"４．家族","-","年齢","【願書】家族12_年齢","家族_年齢12",3,2,"家族_氏名12",0,"-","-",0]
[null,108,"５．留学の形態","-","留学の形態","【願書】留学の形態","留学形態",200,1,"-",0,"-","-",0]
[null,109,"６．留学の動機","-","留学の動機","【願書】留学の動機","留学動機",200,1,"-",0,"-","-",0]
[null,110,"７．卒業後の進路希望","-","卒業後の進路希望","【願書】卒業後の進路希望","卒業後進路希望",200,1,"-",0,"-","-",0]
[null,111,"８．奨学金の給付を希望する理由","-","奨学金の給付を希望する理由","【願書】奨学金の給付を希望する理由","給付希望理由",400,1,"-",0,"-","-",0]
[null,112,"８．奨学金の給付を希望する理由","-","（願書作成日）年","【願書】入力年月日_年","入力年月日_年",4,1,"-",0,2,"年",0]
[null,113,"８．奨学金の給付を希望する理由","-","（願書作成日）月","【願書】入力年月日_月","入力年月日_月",2,1,"-",0,2,"月",0]
[null,114,"８．奨学金の給付を希望する理由","-","（願書作成日）日","【願書】入力年月日_日","入力年月日_日",2,1,"-",1,2,"日",0]
[]
["２．　「入力チェック／送付用ファイル作成シート」の入力内容と、願書の入力内容に相違がある。"]
["　テーブル名｢テーブル_入力内容相違チェック項目_願書ファイル｣"]
[null,"行","項目名","項目名_入力チェック結果表示用","送付用ファイル作成シート_Excel定義名_1","送付用ファイル作成シート_Excel定義名_2","入力ファイル_Excel定義名_1","入力ファイル_Excel定義名_2"]
[null,1,"学校名","【願書】大学名","入力欄_学校名","-","大学名","-"]
[null,2,"氏名（姓）","【願書】氏名（姓）","入力欄_氏名_姓","-","氏名_姓","-"]
[null,3,"氏名（名）","【願書】氏名（名）","入力欄_氏名_名","-","氏名_名","-"]
[]
[]
[]
[]
[]
[]
[]
["Ⅲ　推薦書ファイル入力チェック"]
["１．入力チェック項目"]
["　　テーブル名｢テーブル_入力チェック項目_推薦書ファイル｣"]
[null,null,null,null,null,null,null,"【入力可能文字数を制限する場合】\n当列に正の数字を入力\n【入力可能文字数を制限しない場合】\n当列に｢制限しない｣と入力","0:入力必須でない\n　(必須チェックをしない)\n1:入力必須である\n　(必須チェックをする)\n2:条件付で入力必須である\n　(必須チェックをする)\n　＊列名｢入力必須条件Excel\n　　定義名｣の項目の値に入力\n　　がある場合にのみ入力必須\n　　とする。",null,"0:日付ではない\n　(日付チェックをしない)\n1:日付である\n　(日付チェックをする)",null,null,"0:半角数字以外も入力して良い\n　(半角数字のみかどうかの\n　 チェックをしない)\n1:半角数字以外入力しては\n　いけない\n　(半角数字のみかどうかの 　\n　 チェックをする)"]
[null,"行","大分類","小分類","項目名","項目名_入力チェック結果表示用","Excel定義名","入力可能文字数","入力必須区分","入力必須条件Excel定義名","日付チェック区分","日付項目グループ番号","日付属性","半角数字のみ入力可能区分"]
[null,1,"-","-","氏名","【推薦書】氏名","氏名",40,1,"-",0,"-",null,0]
[null,2,"-","-","性別","【推薦書】性別","性別","制限しない",1,"-",0,"-",null,0]
[null,3,"-","-","生年月日（年）","【推薦書】生年月日_年","生年月日_年",4,1,"-",0,1,"年",0]
[null,4,"-","-","生年月日（月）","【推薦書】生年月日_月","生年月日_月",2,1,"-",0,1,"月",0]
[null,5,"-","-","生年月日（日）","【推薦書】生年月日_日","生年月日_日",2,1,"-",1,1,"日",0]
[null,6,"-","-","大学名","【推薦書】大学名","大学名",60,1,"-",0,"-",null,0]
[null,7,"-","-","学部","【推薦書】学部","学部",40,0,"-",0,"-",null,0]
[null,8,"-","-","学科","【推薦書】学科","学科",40,2,"学部",0,"-",null,0]
[null,9,"-","-","学年","【推薦書】大学_学年","大学_学年",1,2,"学部",0,"-",null,0]
[null,10,"-","-","課程","【推薦書】課程","課程",40,0,"-",0,"-",null,0]
[null,11,"-","-","研究科","【推薦書】研究科","研究科",40,2,"課程",0,"-",null,0]
[null,12,"-","-","専攻","【推薦書】専攻","専攻",40,2,"課程",0,"-",null,0]
[null,13,"-","-","学年","【推薦書】大学院_学年","大学院_学年",1,2,"課程",0,"-",null,0]
[null,14,"-","-","卒業（修了）年月（年）","【推薦書】卒業年月_年","卒業年月_年",4,1,"-",0,"-",null,0]
[null,15,"-","-","卒業（修了）年月（月）","【推薦書】卒業年月_月","卒業年月_月",2,1,"-",0,"-",null,0]
[null,16,"-","-","卒業修了区分","【推薦書】卒業修了区分","卒業修了区分","制限しない",1,"-",0,"-",null,0]
[null,17,"-","-","推薦所見","【推薦書】推薦所見","推薦所見",800,1,"-",0,"-",null,0]
[null,18,"-","-","推薦書作成者　職・氏名","【推薦書】推薦書作成者名","推薦書作成者名",60,1,"-",0,"-",null,0]
[null,19,"-","-","（推薦書作成日）年","【推薦書】日付_年","日付_年",4,1,"-",0,2,"年",0]
[null,20,"-","-","（推薦書作成日）月","【推薦書】日付_月","日付_月",2,1,"-",0,2,"月",0]
[null,21,"-","-","（推薦書作成日）日","【推薦書】日付_日","日付_日",2,1,"-",1,2,"日",0]
[null,22,"-","-","学長氏名","【推薦書】学長氏名","学長氏名",40,1,"-",0,"-",null,0]
[]
["２．　「入力チェック／送付用ファイル作成シート」の入力内容と、願書の入力内容に相違がある。"]
["　テーブル名｢テーブル_入力内容相違チェック項目_推薦書ファイル｣"]
[null,"行","項目名","項目名_入力チェック結果表示用","送付用ファイル作成シート_Excel定義名_1","送付用ファイル作成シート_Excel定義名_2","入力ファイル_Excel定義名_1","入力ファイル_Excel定義名_2"]
[null,1,"学校名","【推薦書】大学名","入力欄_学校名","-","大学名","-"]
[null,2,"氏名","【推薦書】氏名","入力欄_氏名_姓","入力欄_氏名_名","氏名","-"]