{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["案内","奨学生願書","GPA計算","履歴書(1)","履歴書(2)","家計状況調書","出願者の収支説明書","研究テーマ(大学院生)","学生入力画面","SMILEアップロード","システム管理","システム管理2","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,31,8]]}
["　　 奨学生出願のための書類はこのＥＸＣＥＬファイルを使って作成することができます。下記の注意をよく読んで作成してください。\n\n●当ＥＸＣＥＬファイルの使い方\n\n（１）Windows7.0、EXCEL2010以降のバージョンでの使用を推奨します。\nこのファイルが使えない場合は、当財団ホームページから奨学生願書用紙（PDFファイル）をダウンロードし手書きで願書一式を作成し提出してください。\n\n（２）当ファイルを開くと「セキュリティの警告」というメッセージが表示されることがあります。「コンテンツの有効化」をクリックして作業を続けてください。\n\n（３）当ＥＸＣＥＬファイルは７つのシートから構成されています。それぞれのシートで提出書類を作成してください。各シートは画面下部に表示されています。クリックして選択してください。\n\n（４）入力が必要なセルは水色で表示されています。黄色の枠に記された注意をよく読んで入力してください。\n\n（５）灰色のセルは入力不要です。\n\n（６）「奨学生願書」と「履歴書（１）」シートには画面右側に入力が正しく行われたことを確認する入力確認欄があります。エラーメッセージがないことを確認してください。\n\n（７）入力が完了したら、各シートを印刷して大学の担当部署に提出してください。このEXCELファイルは大学からの推薦が得られた場合、再度使用しますので削除せずに保存しておいてください。\n　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　以上"]

{"sheet":"奨学生願書","index":1,"n_rows":61,"n_cols":45,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,35,0,38],[11,41,11,44],[25,35,25,38],[15,35,15,38],[26,35,27,38],[5,35,5,38],[12,35,12,38],[17,35,17,38],[13,35,14,38],[18,39,19,40],[8,35,9,38],[20,35,21,38],[24,15,24,16],[25,1,25,6],[25,7,25,10],[25,12,25,13],[25,15,25,16],[29,1,29,4],[14,23,14,24],[14,25,14,28],[14,29,14,30],[25,21,25,22],[20,20,20,33],[21,20,21,33],[14,18,14,22],[17,11,17,33],[15,1,15,5],[15,6,15,10],[19,1,19,10],[19,11,19,33],[17,6,17,10],[23,1,23,6],[23,7,23,10],[23,12,23,13],[23,15,23,16],[20,1,20,4],[20,5,20,15],[20,16,20,19],[22,1,22,6],[22,7,22,10],[22,12,22,13],[22,15,22,16],[21,1,21,4],[21,5,21,15],[21,16,21,19],[13,9,13,16],[13,17,13,18],[14,1,14,5],[14,6,14,8],[14,9,14,14],[14,15,14,17],[12,27,12,28],[12,29,12,31],[12,32,12,33],[13,19,13,28],[13,29,13,30],[12,25,12,26],[13,32,13,33],[14,32,14,33],[24,7,24,10],[24,12,24,13],[15,11,15,15],[15,16,15,20],[18,35,18,38],[19,35,19,38],[0,23,0,24],[0,25,0,26],[0,28,0,29],[0,31,0,32],[2,0,2,18],[8,18,8,21],[8,22,8,33],[9,18,9,21],[9,22,9,33],[11,0,11,33],[12,1,12,6],[12,7,12,10],[12,12,12,13],[12,15,12,16],[12,18,12,24],[13,0,14,0],[13,1,13,6],[13,7,13,8],[4,0,10,5],[37,0,38,33],[30,1,35,4],[31,35,35,38],[29,35,30,38],[29,5,29,8],[29,9,29,17],[30,5,35,33],[29,18,29,33],[16,0,19,0],[16,35,16,38],[18,1,18,10],[18,11,18,33],[16,1,16,5],[16,6,16,10],[16,11,16,33],[17,1,17,5],[20,0,21,0],[22,0,23,0],[26,0,28,0],[26,1,28,33],[29,0,35,0],[24,0,25,0],[24,1,24,6]]}
[null,null,null,null,null,null,null,null,null,null,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(+ISBLANK(Z1),\"年月日を入力してください\",\n IF(+ISBLANK(AC1),\"年月日を入力してください\",\nIF(+ISBLANK(AF1),\"年月日を入力してください\",\"OK\")))","v":"年月日を入力してください"}]
[]
["公益財団法人　三菱UFJ信託奨学財団 理事長　殿"]
[]
["写真貼付欄\n\nデジタル画像(鮮明な\nもの)を貼付、もしくは\n郵送時に現物写真を\n貼り付けてください)"]
[null,null,null,null,null,null,null,null,"奨　　学　　生　　願　　書",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※水色の枠に入力してください。"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"入力確認"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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(+ISBLANK(W9),\"氏名を入力してください\",\"OK\")","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,{"$f":"IF(+ISBLANK(W10),\"フリガナを入力してください\",\"OK\")","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,"日","年齢(4月1日現在)：",null,null,null,null,null,null,null,null,"歳",null,"性別：",null,null,null,null,null,"性別はプルダウンメニューで入力してください。",null,null,null,{"$f":"IF(+ISBLANK(H13),\"生年月日を入力してください\",\nIF(+ISBLANK(M13),\"生年月日を入力してください\",\nIF(+ISBLANK(P13),\"生年月日を入力してください\",\n IF(+ISBLANK(Z13),\"年齢を入力してください\",\nIF(+ISBLANK(AG13),\"性別を入力してください\",\"OK\")))))","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,{"$f":"IF(AND(+ISBLANK(B14),+ISBLANK(B15)),\"大学名または大学院名を入力してください\",\nIF(AND(+ISBLANK(J14),+ISBLANK(J15)),\"学部または研究科名を入力してください\",\nIF(AND(+ISBLANK(T14),+ISBLANK(S15)),\"学科または専攻を入力してください\",\nIF(AND(+ISBLANK(AF14),+ISBLANK(AF15)),\"学年を入力してください\",\nIF(+ISBLANK(AG14),\"性別を入力してください\",\"OK\")))))","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,{"$f":"IF(AND(+ISBLANK(B14),+ISBLANK(B15)),\"大学名または大学院名を入力してください\",\nIF(AND(+ISBLANK(J14),+ISBLANK(J15)),\"学部または研究科名を入力してください\",\nIF(AND(+ISBLANK(T14),+ISBLANK(S15)),\"学科または専攻を入力してください\",\nIF(AND(+ISBLANK(AF14),+ISBLANK(AF15)),\"学年を入力してください\",\nIF(AND(+ISBLANK(B14),+ISBLANK(Z15)),\"課程を入力してください\",\"OK\")))))","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,{"$f":"IF(+ISBLANK(G16),\"GPAを入力してください\",\n IF(+ISBLANK(Q16),\"取得単位数を入力してください\",\"OK\"))","v":"GPAを入力してください"},null,null,"アパート","博士課程","大阪"]
["現住所","住居種類",null,null,null,null,null,null,null,null,null,null,null,null,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(+ISBLANK(G17),\"住居種類を入力してください\",\"OK\")","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,{"$f":"IF(+ISBLANK(G18),\"住所1を入力してください\",\"OK\")","v":"住所1を入力してください"},null,null,"その他",null,"小樽商科"]
[null,"住所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,null,null,"都道府県から記入してください。",null,null,null,{"$f":"IF(+ISBLANK(L19),\"住所2を入力してください\n住所1で記入済の場合、このメッセージは無視してください\",\"OK\")","v":"住所2を入力してください\n住所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,null,null,null,null,null,null,null,"部屋番号、様方まで記入してください。",null,null,null,null,null,null,null,null,"学習院"]
["電話・\nメール","固定電話：",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E-mail：",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"電話番号は全角文字、局番号間は\"-\"を記入してください。",null,null,null,{"$f":"IF(+ISBLANK(F21),\"固定電話番号を入力してください\",\n IF(+ISBLANK(U21),\"E-mailを入力してください\",\"OK\"))","v":"固定電話番号を入力してください"},null,null,null,null,"鹿児島"]
[null,"携帯電話：",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"携帯mail：",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(+ISBLANK(F22),\"携帯電話番号を入力してください\",\n IF(+ISBLANK(U22),\"携帯mailを入力してください\",\"OK\"))","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,{"$f":"IF(+ISBLANK(H23),\"入学年月日を入力してください\",\n IF(+ISBLANK(M23),\"入学年月日を入力してください\",\nIF(+ISBLANK(P23),\"入学年月日を入力してください\",\"OK\")))","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,{"$f":"IF(+ISBLANK(H24),\"卒業予定年月日を入力してください\",\n IF(+ISBLANK(M24),\"卒業予定年月日を入力してください\",\nIF(+ISBLANK(P24),\"入学年月日を入力してください\",\"OK\")))","v":"卒業予定年月日を入力してください"},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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(+ISBLANK(H25),\"年月日を入力してください\",\n IF(+ISBLANK(M25),\"年月日を入力してください\",\nIF(+ISBLANK(P25),\"入学年月日を入力してください\",\"OK\")))","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,{"$f":"IF(+ISBLANK(H26),\"卒業予定年月日を入力してください\",\n IF(+ISBLANK(M26),\"卒業予定年月日を入力してください\",\nIF(+ISBLANK(P26),\"入学年月日を入力してください\",\"OK\")))","v":"卒業予定年月日を入力してください"},null,null,null,null,"京都"]
["家族住所",{"$f":"CONCATENATE(\"〒\"&G18&\" \",L19&\" \",L20)","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,{"$f":"IF(LEN(SUBSTITUTE(SUBSTITUTE(+RIGHT(B27,LEN(B27)-1),\"　\",\"\"),\" \",\"\"))=0,\"家族住所を入力してください\",\"OK\")","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,"神戸"]
["卒業後の\n希望進路\n","就職/進学",null,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,null,null,null,"就職/進学はプルダウンメニューで選択。進路希望先は業種、会社、大学院（修士/博士・専門課程）などを入力。",null,null,null,{"$f":"IF(+ISBLANK(B30),\"就職/進学を選択してください\",\n IF(+ISBLANK(S30),\"進路希望先入力してください\",\"OK\"))","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,{"$f":"IF(+ISBLANK(F31),\"進路希望の理由を入力してください\",\"OK\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"成蹊"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"西南学院"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"創価"]
["※改行する場合、Windows を使用の場合は \"Alt + Enter\" を、Mackintosh を使用の場合はCommand + Option + Return キーを押してください。 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"千葉"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"中央"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"筑波"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"東京"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"東京外国語"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"東京工業"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"東京理科"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"同志社"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"東北"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"獨協"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"長崎"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"名古屋"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"南山"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"一橋"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"広島"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"福島"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"法政"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"北海道"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"明治"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"山梨"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"横浜国立"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"立教"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"立命館"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"GPA計算","index":2,"n_rows":25,"n_cols":23,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,3,24,5],[24,19,24,21],[2,19,2,22],[1,19,1,22],[3,19,3,22],[4,19,4,22],[0,0,9,16],[13,16,13,19],[19,8,19,11],[19,16,19,19],[24,11,24,13],[13,0,13,3],[20,0,20,3],[13,8,13,11]]}
["（注意．このシートへの入力は大学の成績表を元に行ってください。）\n・大学ごと、または学年次によって評価段階（５，４，３段階）が異なります。対応する評価枠（水色セル）に1年次から通算の取得単位数（取得科目数ではなく、単位数です）を入力してください。\n・大学ごとに評価評号が異なります。対応する評価枠に取得単位数を入力してください。大学の成績表の単位数合計と当シートの取得単位数合計（赤いセル）が合っていることを確認してください。\n・成績結果が合格または認定で評価が無い場合は評価評号を「合」としてカウントしてください。\n・黄色いセルの「標準化GPA」の値を、奨学生願書シートの「標準化GPA」に入力してください。\n・赤いセルの「取得単位数」合計値を、奨学生願書シートの「取得単位数」に入力してください。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"学生入力画面!D6","v":"大学大学院"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"学生入力画面!D8","v":"研究科"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"学生入力画面!D4","v":""}]
[]
[]
[]
[]
[]
[]
[]
["5段階評価",null,null,null,null,null,null,null,"4段階評価",null,null,null,null,null,null,null,"3段階評価"]
[]
["評価評号",null,null,null,"Point","取得単位数","Quality　Point",null,"評価評号",null,null,null,"Point","取得単位数","Quality　Point",null,"評価評号",null,null,null,"Point","取得単位数","Quality　Point"]
["秀","AA","S","A",5,null,{"$f":"+E15*F15","v":0},null,"秀","AA","S","A",4,null,{"$f":"+M15*N15","v":0},null,"優","A","S","A",3,null,{"$f":"+U15*V15","v":0}]
["優","A","A","B",4,null,0,null,"優","A","A","B",3,null,{"$f":"+M16*N16","v":0},null,"良","B","A","B",2,null,{"$f":"+U16*V16","v":0}]
["良","B","B","C",3,null,0,null,"良","B","B","C",2,null,{"$f":"+M17*N17","v":0},null,"可","C","B","C",1,null,{"$f":"+U17*V17","v":0}]
["可","C","C","D",2,null,0,null,"可","C","C","D",1,null,{"$f":"+M18*N18","v":0},null,"合","P","P","P",0,null,{"$f":"+U18*V18","v":0}]
["合","D","D","D",1,null,0,null,"合","P","P","P",0,null,{"$f":"+M19*N19","v":0},null,"合計",null,null,null,null,{"$f":"SUM(V15:V18)","v":0},{"$f":"SUM(W15:W18)","v":0}]
["合","P","P","P",0,null,0,null,"合計",null,null,null,null,{"$f":"SUM(N15:N19)","v":0},{"$f":"SUM(O15:O19)","v":0}]
["合計",null,null,null,null,{"$f":"SUM(F15:F20)","v":0},{"$f":"SUM(G15:G20)","v":0}]
[]
[null,null,null,null,null,"GPA",{"$f":"+SUM(G15:G20)/SUM(F15:F19)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"GPA",{"$f":"+SUM(O15:O18)/SUM(N15:N18)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"GPA",{"$f":"+SUM(W15:W17)/SUM(V15:V17)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"標準化GPA",null,null,{"$f":"+G23/5*4","v":{"$error":"#DIV/0!"}},null,null,null,null,"標準化GPA",null,null,{"$f":"+O23","v":{"$error":"#DIV/0!"}},null,null,null,null,"標準化GPA",null,null,{"$f":"+W23/3*4","v":{"$error":"#DIV/0!"}}]

{"sheet":"履歴書(1)","index":3,"n_rows":57,"n_cols":51,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,39,6,41],[11,42,12,42],[11,24,11,37],[12,0,12,3],[32,4,32,7],[32,8,32,9],[32,10,32,37],[26,4,26,7],[26,8,26,9],[26,10,26,37],[27,8,27,9],[27,10,27,37],[26,0,30,3],[23,10,23,13],[23,14,23,15],[23,16,23,19],[23,20,23,37],[31,4,31,7],[31,8,31,9],[31,10,31,37],[12,14,12,15],[12,16,12,19],[12,20,12,37],[13,10,13,13],[6,22,6,28],[6,29,6,30],[6,31,6,32],[6,33,6,35],[6,36,6,37],[11,0,11,3],[10,0,10,3],[10,4,10,7],[10,8,10,11],[10,12,10,17],[11,4,11,11],[11,12,11,23],[10,18,10,37],[0,0,0,37],[3,22,3,25],[3,26,3,37],[4,22,4,25],[4,26,4,37],[5,22,5,26],[5,27,5,30],[5,32,5,33],[5,35,5,36],[10,39,10,41],[11,39,11,41],[35,4,35,7],[35,8,35,9],[35,10,35,37],[33,4,33,7],[33,8,33,9],[33,10,33,37],[34,4,34,7],[34,8,34,9],[34,10,34,37],[30,4,30,7],[28,4,28,7],[28,8,28,9],[28,10,28,37],[29,4,29,7],[29,8,29,9],[29,10,29,37],[30,8,30,9],[30,10,30,37],[27,4,27,7],[12,39,13,41],[12,4,12,9],[12,10,12,13],[13,20,13,37],[14,10,14,13],[14,14,14,15],[14,16,14,19],[14,20,14,37],[15,10,15,13],[15,14,15,15],[15,16,15,19],[15,20,15,37],[13,14,13,15],[13,16,13,19],[16,10,16,13],[16,14,16,15],[16,16,16,19],[16,20,16,37],[17,10,17,13],[17,14,17,15],[17,16,17,19],[17,20,17,37],[18,10,18,13],[18,14,18,15],[18,16,18,19],[18,20,18,37],[22,4,22,9],[19,10,19,13],[19,14,19,15],[19,16,19,19],[19,20,19,37],[23,4,23,9],[20,10,20,13],[20,14,20,15],[20,16,20,19],[20,20,20,37],[21,10,21,13],[21,14,21,15],[21,16,21,19],[21,20,21,37],[22,10,22,13],[22,14,22,15],[22,16,22,19],[22,20,22,37],[37,0,38,37],[31,0,35,3],[18,42,25,42],[27,42,30,42],[27,39,30,41],[32,39,35,41],[32,42,35,42],[14,39,14,41],[16,39,16,41],[17,39,17,41],[18,39,25,41],[24,10,25,37],[24,4,25,9],[13,0,25,3],[15,39,15,41],[13,4,13,9],[14,4,14,9],[15,4,15,9],[16,4,16,9],[17,4,17,9],[18,4,18,9],[19,4,19,9],[20,4,20,9],[21,4,21,9]]}
["履 歴 書 (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,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!W9),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!AX8),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!BB8),\" \",\"　\")))","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,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!W10),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!AX9),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!BB9),\" \",\"　\")))","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,{"$f":"IF(+TEXT(奨学生願書!H13,\"標準\")=\"0\",\"\",+TEXT(奨学生願書!H13,\"標準\"))","v":""},{"$f":"IF(AK6=\"0\",\"\",AK6)","v":0},{"$f":"IF(AL6=\"0\",\"\",AL6)","v":"日"},{"$f":"IF(AM6=\"0\",\"\",AM6)","v":0},"年",{"$f":"奨学生願書!M13","v":0},{"$f":"奨学生願書!AP4","v":0},"月",{"$f":"奨学生願書!P13","v":0},{"$f":"奨学生願書!AS4","v":0},"日"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年齢(4月1日現在)：",null,null,null,null,null,null,{"$f":"IF(+TEXT(奨学生願書!Z13,\"標準\")=\"0\",\"\",+TEXT(奨学生願書!Z13,\"標準\"))","v":""},{"$f":"IF(AJ7=\"0\",\"\",AJ7)","v":0},"歳",null,"性別：",null,null,{"$f":"IF(+TEXT(奨学生願書!AG13,\"標準\")=\"0\",\"\",+TEXT(奨学生願書!AG13,\"標準\"))","v":""},{"$f":"IF(AQ7=\"0\",\"\",AQ7)","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,null,"入力確認"]
["学生区分",null,null,null,null,null,null,null,"奨学生区分",null,null,null,null,null,null,null,null,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(+ISBLANK(E11),\"学生区分を入力してください\",\n IF(+ISBLANK(M11),\"奨学生区分を入力してください\",\"OK\"))","v":"学生区分を入力してください"},"奨学生区分","学生区分","コード 国籍 検索用索引",null,"国籍番号（入力チェック用）"]
["国籍",null,null,null,"000 日本",null,null,null,null,null,null,null,"国籍が「999　その他」の場合の国籍",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"国籍はプルダウンで入力。国籍が「999　その他」の場合は国籍をキーボード入力。",null,null,{"$f":"IF(+ISBLANK(E12),\"国籍を入力してください\",\n IF(AND(+AV12=999,+ISBLANK(Y12)),\"国籍が「その他」です。国籍をキーボード入力してください\",\"OK\"))","v":"OK"},"一般","学部生","000 日本",null,{"$f":"VALUE(LEFT(E12,3))","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,"留学生","修士課程","001 アイルランド",null,null,null,null,"私立"]
["学歴",null,null,null,"中学卒業",null,null,null,null,null,null,null,null,null,null,null,null,null,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(+ISBLANK(K14),\"年(西暦）を入力してください\",\nIF(+ISBLANK(O14),\"月を入力してください\",\nIF(+ISBLANK(Q14),\"国・公・私立を入力してください\",\nIF(+ISBLANK(U14),\"学校名を入力してください\",\"OK\"))))","v":"年(西暦）を入力してください"},null,"博士課程","002 アメリカ ",null,null,null,null,"国立"]
[null,null,null,null,"高校/高専入学",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"入力必須です。\n大検の場合は大検と記入してください。",null,null,{"$f":"IF(+ISBLANK(K15),\"年(西暦）を入力してください\",\nIF(+ISBLANK(O15),\"月を入力してください\",\nIF(+ISBLANK(Q15),\"国・公・私立を入力してください\",\nIF(+ISBLANK(U15),\"学校名を入力してください\",\"OK\"))))","v":"年(西暦）を入力してください"},null,"その他（専門職）","003 イギリス",null,null,null,null,"その他"]
[null,null,null,null,"高校留学",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"該当がある場合記入してください。\n（例：米国　ワシントン高校）",null,null,"入力チェック対象外",null,null,"004 イラン "]
[null,null,null,null,"高校/高専卒業",null,null,null,null,null,null,null,null,null,null,null,null,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(+ISBLANK(K17),\"年(西暦）を入力してください\",\nIF(+ISBLANK(O17),\"月を入力してください\",\nIF(+ISBLANK(Q17),\"国・公・私立を入力してください\",\nIF(+ISBLANK(U17),\"学校名を入力してください\",\"OK\"))))","v":"年(西暦）を入力してください"},null,null,"005 インド "]
[null,null,null,null,"大学入学",null,null,null,null,null,null,null,null,null,null,null,null,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(+ISBLANK(K18),\"年(西暦）を入力してください\",\nIF(+ISBLANK(O18),\"月を入力して下さい\",\nIF(+ISBLANK(Q18),\"国・公・私立を入力してください\",\nIF(+ISBLANK(U18),\"学校名を入力してください\",\"OK\"))))","v":"年(西暦）を入力してください"},null,null,"006 インドネシア "]
[null,null,null,null,"大学留学",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"該当がある場合記入してください。\n海外の学校の場合は国名、学校名を記入してください。\n（例　米国　コロンビア大学）",null,null,"入力チェック対象外",null,null,"007 オーストラリア "]
[null,null,null,null,"大学編入学",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"008 オーストリア "]
[null,null,null,null,"大学卒業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"009 カザフスタン "]
[null,null,null,null,"大学院修士入学",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"010 カナダ"]
[null,null,null,null,"大学院修士卒業",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"011 韓国 "]
[null,null,null,null,"大学院博士進学",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"012 カンボジア"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"013 ギリシャ "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"014 コートジボワール"]
["職  歴",null,null,null,"年(西暦)",null,null,null,"月",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"015 コロンビア "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"該当がある場合記入してください。\nアルバイトは入力不要です",null,null,"入力チェック対象外",null,null,"016 コンゴ民主共和国 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"017 シンガポール"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"018 ジンバブエ共和国 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"019 スペイン "]
["賞　罰",null,null,null,"年(西暦)",null,null,null,"月",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"020 スリランカ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"該当がある場合記入してください。\n",null,null,"入力チェック対象外",null,null,"021 タイ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"022 台湾"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"023 中国 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"024 チリ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"025 ドイツ"]
["※改行する場合、Windows を使用の場合は \"Alt + Enter\" を、Mackintosh を使用の場合はCommand + Option + Return キーを押してください。 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"026 ニュージーランド "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"027 ネパール"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"028 ブラジル "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"029 ベトナム "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"030 ペルー "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"031 ベルギー "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"032 ポルトガル"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"033 マレーシア "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"034 ミャンマー"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"035 メキシコ "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"036 モンゴル"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"037 ラオス"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"038 ロシア"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"039 フランス"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"040 ウクライナ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"041 ウズベキスタン"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"042 フィリピン"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"043 南アフリカ共和国"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"044 ジョージア"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"999 その他"]

{"sheet":"履歴書(2)","index":4,"n_rows":62,"n_cols":3,"rows_kept":62,"cut":false,"hidden":false,"merged":[[13,0,16,6],[13,7,16,36],[0,0,0,36],[3,0,7,6],[3,7,7,36],[8,0,12,6],[8,7,12,36],[61,0,62,36],[50,0,59,6],[50,7,59,36],[17,0,21,6],[17,7,21,36],[22,0,29,1],[22,2,25,6],[22,7,25,36],[26,2,29,6],[26,7,29,36],[30,0,33,6],[30,7,33,36],[34,0,39,6],[34,7,39,36],[40,0,49,6],[40,7,49,36]]}
["履 歴 書 (2)"]
[]
[]
["得意な学科"]
[]
[]
[]
[]
["趣　　味\n娯　　楽\n運　　動"]
[]
[]
[]
[]
["愛読書、雑誌など"]
[]
[]
[]
["日常生活における\n信条、座右の銘\nなど"]
[]
[]
[]
[]
["性\n\n格",null,"長　所"]
[]
[]
[]
[null,null,"短　所"]
[]
[]
[]
["委員・役員\n経験等"]
[]
[]
[]
["所有する資格、\n免許、検定など"]
[]
[]
[]
[]
[]
["課外活動の状況\n（部、サークルに所属していればその名称、活動内容、団体での自分の役割などを記入。学外での活動の記載も可）"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["アルバイトの状況\n（現在、従事しているアルバイトがあれば、その種類、勤務時間、平均的な月収など）"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["※改行する場合、Windows を使用の場合は \"Alt + Enter\" を、Mackintosh を使用の場合はCommand + Option + Return キーを押してください。 "]

{"sheet":"家計状況調書","index":5,"n_rows":42,"n_cols":36,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,35,4,37],[31,0,31,33],[23,10,23,17],[23,18,23,25],[14,3,14,11],[7,18,7,26],[23,2,23,9],[22,2,22,9],[22,10,22,17],[22,18,22,25],[22,26,22,33],[21,10,21,17],[21,18,21,25],[21,26,21,33],[18,0,18,33],[24,2,24,9],[24,10,24,17],[24,18,24,25],[15,3,15,11],[15,12,15,14],[15,15,15,17],[10,27,10,33],[12,27,12,33],[12,12,12,14],[11,18,11,26],[16,25,16,26],[13,15,13,17],[13,18,13,26],[16,27,16,31],[0,23,0,24],[0,25,0,26],[0,28,0,29],[0,31,0,32],[1,0,1,33],[2,0,2,19],[7,27,7,33],[8,3,8,11],[8,12,8,14],[8,15,8,17],[8,18,8,26],[8,27,8,33],[3,19,3,22],[3,23,3,33],[4,19,4,22],[4,23,4,33],[5,0,5,33],[7,0,15,0],[7,3,7,11],[7,12,7,14],[7,15,7,17],[4,0,4,1],[6,0,6,33],[13,3,13,11],[12,15,12,17],[12,18,12,26],[13,27,13,33],[9,3,9,11],[9,12,9,14],[11,3,11,11],[11,12,11,14],[11,15,11,17],[11,27,11,33],[9,15,9,17],[9,18,9,26],[9,27,9,33],[10,3,10,11],[32,0,39,33],[7,35,7,37],[8,35,15,37],[19,35,19,37],[20,35,29,37],[19,26,19,33],[20,2,20,9],[20,10,20,17],[20,18,20,25],[20,26,20,33],[15,18,15,26],[14,12,14,14],[14,15,14,17],[10,12,10,14],[10,15,10,17],[10,18,10,26],[41,0,42,33],[15,27,15,33],[14,18,14,26],[14,27,14,33],[12,3,12,11],[13,12,13,14],[23,32,23,33],[23,26,24,31],[24,32,24,33],[19,0,24,0],[19,2,19,9],[19,10,19,17],[19,18,19,25],[21,2,21,9],[25,0,29,0],[25,1,29,33]]}
[]
["家　計　状　況　調　書　及び　応　募　理　由　書"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(ﾌﾘｶﾞﾅ)",null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!W9),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!AU8),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!AY8),\" \",\"　\")))","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,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!W10),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!AU9),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!AY9),\" \",\"　\")))","v":""}]
["下記表１、表２及び応募理由について相違ありません。"]
["表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,"『留学生』の方は、表1の「前年の収入」と「家計」は記入不要です。空欄のままにしてください。"]
[null,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,null,"●入力上の注意\n①年長者順に記入します。\n②出願者本人も含めて記入します。\n　 続柄は「本人」とします。\n③氏名欄には全て姓名を記入。姓と名の\n　　間は全角一文字を入れます。\n④家計欄は生計費を同一にする者は○を\n   選択します。\n⑤続柄は、出願者本人との続柄を記入しま\n   す。\n⑥就学者は、国・公・私立の別を明記しま\n　 す。\n⑦前年の収入は、税込額を記入します。"]
[null,2]
[null,3]
[null,4,"　"]
[null,5,"　"]
[null,6,"　"]
[null,7,"　"]
[null,8,"　"]
[null,null,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":"SUM(AB9:AB16)","v":0},null,null,null,null,"千","円"]
[]
["表2　（※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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"●入力上の注意\n①収入額は、税込額を記入します。\n②定年、退職、病気療養費など特記される\n   事由があれば記載してください（今後の\n   予定も記入可）。\n●大学への提出書類の注意\n表２記載の収入額の根拠となるものとして、市区町村の発行する所得証明書（前年度の所得が反映されたもの）を添付してください。前年度の証明が間に合わない場合は、前々年度のものでも構いません。ただし、その場合は勤務先の発行する前年の収入に対する源泉徴収票または前年の確定申告書の写しを添付してください。収入の有無に関わらず必須です。\nなお、マイナンバーが記載されている場合は、黒塗りするなど判読できないようにしてください。"]
[null,"母"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"税込年収合計"]
[null,null,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":"SUM(C21:AH22)","v":0},{"$f":"SUM(D22:K23)","v":0},0,0,0,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,{"$f":"SUM(C23:J24)","v":0},0,0,0,0,0,"千円"]
["特記事項\n"]
[]
[]
[]
[]
[]
["●奨学金応募理由\n(選考上、重要な項目となりますので、経済的な面など、奨学金が必要な理由を詳しく記載してください。)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["※改行する場合、Windows を使用の場合は \"Alt + Enter\" を、Mackintosh を使用の場合はCommand + Option + Return キーを押してください。 "]

{"sheet":"出願者の収支説明書","index":6,"n_rows":32,"n_cols":36,"rows_kept":32,"cut":false,"hidden":false,"merged":[[28,11,28,19],[21,35,21,37],[5,0,5,33],[7,0,7,1],[8,0,8,14],[8,15,8,33],[9,0,9,7],[9,8,9,14],[9,15,9,26],[9,27,9,33],[21,32,21,33],[20,27,20,33],[12,15,12,26],[5,35,5,37],[3,35,4,37],[25,1,25,10],[25,11,25,19],[19,27,19,33],[10,8,10,14],[10,15,10,26],[10,27,10,33],[15,27,15,33],[16,27,16,33],[17,27,17,33],[13,0,13,7],[13,8,13,14],[13,15,13,26],[13,27,13,33],[11,0,11,7],[24,35,31,37],[1,0,1,33],[3,19,3,22],[3,23,3,33],[4,19,4,22],[4,23,4,33],[12,0,12,7],[12,8,12,14],[10,0,10,7],[11,27,11,33],[14,0,20,14],[15,15,15,26],[16,15,16,26],[17,15,17,26],[11,8,11,14],[11,15,11,26],[21,0,21,7],[21,8,21,12],[21,15,21,26],[21,13,21,14],[18,15,18,26],[19,15,19,26],[20,15,20,26],[31,1,31,10],[31,11,31,17],[31,20,31,27],[26,1,26,10],[26,11,26,19],[27,1,27,10],[27,11,27,19],[30,11,30,19],[29,20,29,24],[30,1,30,10],[28,20,28,24],[26,20,26,24],[29,1,29,10],[29,11,29,19],[28,25,28,27],[28,1,28,10],[11,39,12,41],[9,35,19,37],[30,20,30,24],[30,25,30,27],[26,25,26,27],[27,25,27,27],[25,20,25,24],[27,20,27,24],[25,25,25,27],[21,27,21,31],[14,15,14,26],[14,27,14,33],[12,27,12,33],[29,25,29,27],[18,27,18,33],[24,0,24,18]]}
[]
["出　願　者　の　収　支　説　明　書"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(ﾌﾘｶﾞﾅ)",null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!W9),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!AU8),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!AY8),\" \",\"　\")))","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,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!W10),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!AU9),\" \",\"　\")))","v":""},null,null,null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(奨学生願書!AY9),\" \",\"　\")))","v":""}]
["表1では、出願者個人の1年間の収支見込を作成してください。前年度の実績等を参考にして、1年間の生活にかかる収入と支出を算出してください。表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,null,null,null,"４月入学生の場合は４月～３月、１０月入学生の場合は１０月～９月の収支見込みを記入してください。"]
[]
["表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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"●入力上の注意\n①表2の奨学金と授業料減免の合計が表1\n　 に反映されます。\n②授業料減免については、正規の授業料\n　 を表1の「支出」の「授業料等（正規料\n　 金）」の欄に、減免額を表2に半額・全額\n　 を含めて記入します。\n③出願者が家族と同居している場合、衣\n　 食住は出願者個人が実際に支出する\n　 予定額を記入してください。\n\n"]
["アルバイト等",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"参考書等"]
["奨学金・授業料減免　　注①",null,null,null,null,null,null,null,{"$f":"L32","v":1200},null,null,null,null,null,null,"通学費"]
["預貯金引出",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"食費　　　　　　　注③"]
["その他",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住居費　　　　　　注③"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"衣料費　　　　　　注③"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"教育娯楽・通信費"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"日常小遣い"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"借入返済"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"家族等への仕送り"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"その他"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"預貯金預入れ"]
["収　入　合　計\n（支出合計と一致）",null,null,null,null,null,null,null,{"$f":"SUM(I10:I15)","v":1200},null,null,null,null,"千円",null,"支　出　合　計\n（収入合計と一致）",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB10:AB21)","v":0},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,null,null,null,"●記入上の注意\n①表2には、現在受給中のもの・当財団を\n   含めた出願中のもの全てを記入します。\n   授業料減免については半額、全額など\n   を明記して入力します。\n②当財団については自動入力されます。\n   金額は日本人の学部生は420、大学院\n   生は660、留学生の学部生は 840、大\n   学院生は1200になります。\n③給付・貸与をプルダウンメニューから選\n   択する。ただし、授業料減免は「給付」と\n　 します。\n④確定・申請中をプルダウンメニューから\n   選択します。"]
[null,"団　体　名",null,null,null,null,null,null,null,null,null,"奨学金額等（千円/年）",null,null,null,null,null,null,null,null,"給付・貸与",null,null,null,null,"確定・申請中"]
[1,"（公財）三菱UFJ信託奨学財団",null,null,null,null,null,null,null,null,null,{"$f":"IF('履歴書(1)'!E11=\"学部生\",IF('履歴書(1)'!M11=\"一般\",420,840),IF('履歴書(1)'!M11=\"一般\",660,1200))","v":1200},null,null,null,null,null,null,null,null,"給付",null,null,null,null,"申請中"]
[2]
[3]
[4]
[5,null,null,null,null,null,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":"SUM(L27:L31)","v":1200},null,null,null,null,null,null,"千","円"]

{"sheet":"研究テーマ(大学院生)","index":7,"n_rows":87,"n_cols":31,"rows_kept":87,"cut":false,"hidden":false,"merged":[[70,0,84,36],[86,0,89,36],[0,0,0,36],[7,0,7,36],[8,0,22,36],[24,0,24,36],[25,0,39,36],[55,0,69,36],[40,0,54,36],[1,30,1,36],[2,30,2,36],[3,30,3,36],[2,1,5,28]]}
["(本シートは大学院生のみ記入してください。)"]
[null,null,null,null,null,null,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(奨学生願書!$B$15=\"\",\"\",学生入力画面!D6)","v":""}]
[null,"※記載に当たっての注意事項\n１.改行する場合、Windows を使用の場合は \"Alt + Enter\" を、Mackintosh を使用の場合は \n\"Command + Option + Return\" キーを押してください。\n２.研究の概要の入力は４つの範囲に分割されています。上の範囲から順に記入してください。",null,null,null,null,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(奨学生願書!$B$15=\"\",\"\",学生入力画面!D8)","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,{"$f":"IF(奨学生願書!$B$15=\"\",\"\",学生入力画面!D4)","v":""}]
[]
[]
[]
["研究テーマ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["研究の概要"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\n１.改行する場合、Windows を使用の場合は \"Alt + Enter\" を、Mackintosh を使用の場合は \"Command + Option + Return\" キーを押してください。\n２.研究の概要の入力は４つの範囲に分割されています。上の範囲から順に記入してください。"]

{"sheet":"学生入力画面","index":8,"n_rows":59,"n_cols":26,"rows_kept":59,"cut":false,"hidden":true,"merged":[[45,7,46,9],[28,7,28,9],[45,3,45,6],[7,3,7,6],[12,5,12,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[23,3,23,6],[24,3,24,6],[25,3,25,6],[26,3,26,6],[27,3,27,6],[29,3,29,6],[22,3,22,6],[28,3,28,6],[8,3,8,6],[20,3,20,6],[0,0,0,9],[4,3,4,6],[6,3,6,6],[3,3,3,6],[5,3,5,6],[19,3,19,4],[21,3,21,6],[32,7,38,9],[31,5,31,6],[35,5,35,6],[36,5,36,6],[37,5,37,6],[38,5,38,6],[30,7,31,9],[44,3,44,6],[41,3,41,6],[40,3,40,6],[42,3,42,6],[43,3,43,6]]}
["（注）\n１．このシートへの入力は大学推薦を受けられることになった応募者が対象です。\n２．水色のセルに対象項目を入力してください。\n３．緑色のセルに既に表示されている情報は、「奨学生願書」「家計状況調書」「出願者の収支説明書」\n　　のシートで入力した情報が表示されています。訂正が必要な場合は、それぞれのシートへの入力\n　　で訂正して下さい。\n４．入力が完了したら、当EXCELワークシート全体を事務局へＥmailして下さい。\n　　Emailの件名は「大学名　学部　本人氏名」として下さい。\n　　事務局のＥmailアドレスはoffice@scholarship.or.jpです。"]
[]
[null,null,null,null,null,null,null,null,null,null,"入力確認",null,null,null,{"$f":"PHONETIC(O4)","v":""}]
[1,"氏名",null,{"$f":"+T(+SUBSTITUTE(+TRIM(奨学生願書!W10),\" \",\"　\"))","v":""},null,null,null,"（姓名の間は全角一文字空ける）",null,null,{"$f":"IF(+T(TEXT(D4,\"標準\"))=\"\",\"「奨学生願書」シートで氏名を入力してください\",\"OK\")","v":"「奨学生願書」シートで氏名を入力してください"},null,null,{"$f":"+奨学生願書!B14","v":0},{"$f":"PHONETIC(O7)","v":""}]
[2,"氏名ﾌﾘｶﾞﾅ",null,{"$f":"+T(+ASC(+SUBSTITUTE(+TRIM(PHONETIC(奨学生願書!W9)),\" \",\"　\")))","v":""},null,null,null,"（半角カタカナ、姓名の間一文字空白）",null,null,{"$f":"IF(+ISBLANK(D5),\"氏名ﾌﾘｶﾞﾅを入力してください\",\"OK\")","v":"OK"},"学科/専攻判定","学部/研究科判定","大学/大学院判定",null,null,null,"大学名称"]
[3,"大学名/大学院",null,{"$f":"IF(+T(奨学生願書!B14)=\"\",\n+T(+CONCATENATE(奨学生願書!B15,\"大学\",N6)),\n+T(奨学生願書!B14&N6))","v":"大学大学院"},null,null,null,"（「～大学」「大学院」まで表記）",null,null,{"$f":"IF(+T(D6)=\"\",\"「奨学生願書」シートで大学名を入力してください\",\"OK\")","v":"OK"},{"$f":"IF(+T(奨学生願書!T14)=\"\",\"専攻\",\"学科\")","v":"専攻"},{"$f":"IF(+T(奨学生願書!J14)=\"\",\"研究科\",\"学部\")","v":"研究科"},{"$f":"IF(+T(奨学生願書!B14)=\"\",\"大学院\",\"大学\")","v":"大学院"},"大学カナ入力一時文列",null,null,{"$f":"IF(+T(奨学生願書!B14:G14)=\"\",+T(奨学生願書!B15:F15)&\"大学\",+T(奨学生願書!B14:G14)&\"大学\")","v":"大学"}]
[4,"大学名ﾌﾘｶﾞﾅ",null,{"$f":"+O7","v":""},{"$f":"IF(+T(#REF!)=\"\",+ASC(+PHONETIC(#REF!)),+ASC(+PHONETIC(#REF!)))","v":{"$error":"#REF!"}},{"$f":"IF(+T(#REF!)=\"\",+ASC(+PHONETIC(#REF!)),+ASC(+PHONETIC(#REF!)))","v":{"$error":"#REF!"}},{"$f":"IF(+T(#REF!)=\"\",+ASC(+PHONETIC(#REF!)),+ASC(+PHONETIC(#REF!)))","v":{"$error":"#REF!"}},"（半角ｶﾀｶﾅ、ﾀﾞｲｶﾞｸは入力不要）",null,null,{"$f":"IF(+T(D7)=\"\",\"大学ﾌﾘｶﾞﾅを入力してください\",\"OK\")","v":"大学ﾌﾘｶﾞﾅを入力してください"},null,null,null,{"$f":"IF(+T(奨学生願書!B14:G14)=\"\",+ASC(+PHONETIC(奨学生願書!B15:F15)),+ASC(+PHONETIC(奨学生願書!B14:G14)))","v":""}]
[5,"学部名/研究科",null,{"$f":"IF(+T(奨学生願書!J14:Q14)=\"\",+T(奨学生願書!J15:O15)&M6,+T(奨学生願書!J14:Q14)&M6)","v":"研究科"},null,null,null,"（「～学部/～研究科」まで表記）",null,null,{"$f":"IF(+T(D8)=\"\",\"「奨学生願書」シートで学部名を入力してください\",\"OK\")","v":"OK"},null,null,null,null,null,null,"保管するフォルダー名","フォルダー名参照テーブル"]
[6,"学科名/専攻",null,{"$f":"IF(+T(奨学生願書!T14:AC14)=\"\",+T(奨学生願書!S15:W15)&L6,+T(奨学生願書!T14:AC14)&L6)","v":"専攻"},null,null,null,"（「～学科、～専攻」まで表記）",null,null,{"$f":"IF(+T(D9)=\"\",\"「奨学生願書」シートで学部名を入力してください\",\"OK\")","v":"OK"},"学年一時入用セル",null,"奨学生区分","学生区分","コード 国籍 検索用索引",null,{"$f":"TEXT(+VLOOKUP(R6,S9:T60,2,0),1)","v":{"$error":"#N/A"}},"青山学院大学","01　青山学院大学"]
[7,"学年",null,{"$f":"IF(M10=\"\",\"\",ASC(M10))","v":"0"},null,"　",null,null," ",null,{"$f":"IF(+N(D10)=0, \"「奨学生願書」シートで学年を入力してください\",\n                                                          \"OK\" )","v":"「奨学生願書」シートで学年を入力してください"},null,{"$f":"IF(+ISBLANK(奨学生願書!AF14),\n奨学生願書!AF15,\n奨学生願書!AF14)","v":0},"一般","学部生","001 アイルランド",null,null,"岩手大学","02　岩手大学"]
[8,"区分",null,"学生区分",{"$f":"IF(+TEXT('履歴書(1)'!E11,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!E11,\"標準\"))","v":""},"奨学生区分",{"$f":"IF(+TEXT('履歴書(1)'!M11,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!M11,\"標準\"))","v":""},null,null,null,{"$f":"IF(+T(E11)=\"\",\"「履歴書（1）」シートで学生区分を入力してください\",\n  IF(+T(G11)=\"\",\"「履歴書（1）」シートで奨学生区分を入力してください\",\"OK\"))","v":"「履歴書（1）」シートで学生区分を入力してください"},null,null,"留学生","修士課程","002 アメリカ ",null,null,"大阪大学","03　大阪大学"]
[9,"性別",null,null,null,null,{"$f":"IF(+TEXT(奨学生願書!AG13,\"標準\")=\"0\",\"\",+TEXT(奨学生願書!AG13,\"標準\"))","v":""},null,null,null,{"$f":"IF(+T(G12)=\"\",\"性別を「奨学生願書」シートで入力ください\",\"OK\")","v":"性別を「奨学生願書」シートで入力ください"},null,null,null,"博士課程","003 イギリス",null,null,"岡山大学","04　岡山大学"]
[10,"国籍",null,null,null,{"$f":"IF(+TEXT('履歴書(1)'!E12,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!E12,\"標準\"))","v":"000 日本"},{"$f":"IF(+TEXT('履歴書(1)'!E13,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!E13,\"標準\"))","v":""},null,null,null,{"$f":"IF(+ISBLANK(F13)=\"\",\"学生区分をプルダウンメニューから入力してください\",\"OK\")","v":"OK"},null,null,null,"その他（専門職）","004 イラン ",null,null,"小樽商科大学","05　小樽商科大学"]
[null,null,null,"西暦","月","日",null,null,null,null,null,"入力チェック用一時文字列",null,null,null,"005 インド ",null,null,"香川大学","06　香川大学"]
[11,"生年月日",null,{"$f":"IF(L15=\"0\",\"\",L15)","v":""},{"$f":"ASC(奨学生願書!M13)","v":""},{"$f":"ASC(奨学生願書!P13)","v":""},"年齢",{"$f":"IF(M15=\"0\",\"\",ASC(M15))","v":""},null,null,{"$f":"IF(+TEXT(D15,\"標準\")=\"\",\"「奨学生願書」シートで生年月日を入力してください\",IF(+TEXT(H15,\"標準\")=\"\",\"年齢を入力してください\",\"OK\"))","v":"「奨学生願書」シートで生年月日を入力してください"},{"$f":"+TEXT(奨学生願書!H13,\"標準\")","v":"0"},{"$f":"+TEXT(奨学生願書!Z13,\"標準\")","v":"0"},null,null,"006 インドネシア ",null,null,"学習院大学","07　学習院大学"]
[12,"支給開始予定日",null,{"$f":"IF(L16=\"0\",\"\",L16)","v":""},{"$f":"ASC(奨学生願書!M25)","v":""},{"$f":"ASC(奨学生願書!P25)","v":""},null,null,null,null,{"$f":"IF(+TEXT(D16,\"標準\")=\"\",\"「奨学生願書」シートで支給開始予定日を入力してください\",\"OK\")","v":"「奨学生願書」シートで支給開始予定日を入力してください"},{"$f":"+TEXT(奨学生願書!H25,\"標準\")","v":"0"},"（注）入力チェックは西暦のみ",null,null,"007 オーストラリア ",null,null,"鹿児島大学","08　鹿児島大学"]
[13,"支給終了予定日",null,{"$f":"IF(L17=\"0\",\"\",L17)","v":""},{"$f":"ASC(奨学生願書!M26)","v":""},{"$f":"ASC(奨学生願書!P26)","v":""},null,null,null,null,{"$f":"IF(+TEXT(D17,\"標準\")=\"\",\"「奨学生願書」シートで生年月日を入力してください\",\"OK\")","v":"「奨学生願書」シートで生年月日を入力してください"},{"$f":"+TEXT(奨学生願書!H26,\"標準\")","v":"0"},null,null,null,"008 オーストリア ",null,null,"金沢大学","09　金沢大学"]
[14,"入学年月日",null,{"$f":"IF(L18=\"0\",\"\",L18)","v":""},{"$f":"ASC(奨学生願書!M23)","v":""},{"$f":"ASC(奨学生願書!P23)","v":""},null,null,null,null,{"$f":"IF(+TEXT(D18,\"標準\")=\"\",\"「奨学生願書」シートで生年月日を入力してください\",\"OK\")","v":"「奨学生願書」シートで生年月日を入力してください"},{"$f":"+TEXT(奨学生願書!H23,\"標準\")","v":"0"},null,null,null,"009 カザフスタン ",null,null,"関西大学","10　関西大学"]
[15,"卒業予定年月日",null,{"$f":"IF(L19=\"0\",\"\",L19)","v":""},{"$f":"ASC(奨学生願書!M24)","v":""},{"$f":"ASC(奨学生願書!P24)","v":""},null,null,null,null,{"$f":"IF(+TEXT(D19,\"標準\")=\"\",\"「奨学生願書」シートで生年月日を入力してください\",\"OK\")","v":"「奨学生願書」シートで生年月日を入力してください"},{"$f":"+TEXT(奨学生願書!H24,\"標準\")","v":"0"},null,null,null,"010 カナダ",null,null,"関西学院大学","11　関西学院大学"]
[16,"住所（郵便番号）",null,{"$f":"ASC(奨学生願書!G18)","v":""},null,null,null,null,null,null,{"$f":"IF(+T(D20)=\"\",\"「奨学生願書」シートで郵便番号を入力してください\",\"OK\")","v":"「奨学生願書」シートで郵便番号を入力してください"},null,null,null,null,"011 韓国 ",null,null,"九州大学","12　九州大学"]
[17,"住所（１）",null,{"$f":"ASC(IF(+TEXT(奨学生願書!L19,\"標準\")=\"0\",\"\",+TEXT(奨学生願書!L19,\"標準\")))","v":""},null,null,null,"（市区町村番地まで入力）",null,null,{"$f":"IF(+TEXT(D17,\"標準\")=\"\",\"「奨学生願書」シートで住所を入力してください\",\"OK\")","v":"「奨学生願書」シートで住所を入力してください"},null,null,null,null,"012 カンボジア",null,null,"京都大学","13　京都大学"]
[18,"住所（２）",null,{"$f":"ASC(IF(+TEXT(奨学生願書!L20,\"標準\")=\"0\",\"\",+TEXT(奨学生願書!L20,\"標準\")))","v":""},null,null,null,"（アパート名、室番号まで入力）",null,null,{"$f":"IF(+TEXT(D22,\"標準\")=\"\",\"住所2を入力してください。住所1で記入済の場合、このメッセージは無視してください。\",\"OK\")","v":"住所2を入力してください。住所1で記入済の場合、このメッセージは無視してください。"},null,null,null,null,"013 ギリシャ ",null,null,"慶應義塾大学","14　慶應義塾大学"]
[19,"住所（３）",null,null,null,null,null,"（住所３は入力しない）",null,null,null,null,null,null,null,"014 コートジボワール",null,null,"工学院大学","15　工学院大学"]
[20,"自宅電話番号",null,{"$f":"ASC(IF(+TEXT(奨学生願書!F21,\"標準\")=\"0\",\"\",+TEXT(奨学生願書!F21,\"標準\")))","v":""},null,null,null,null,null,null,{"$f":"IF(+TEXT(D24,\"標準\")=\"\",\"「奨学生願書」シートで電話番号を入力してください\",\"OK\")","v":"「奨学生願書」シートで電話番号を入力してください"},null,null,null,null,"015 コロンビア ｺﾛﾝﾋﾞｱ",null,null,"神戸大学","16　神戸大学"]
[21,"本人携帯番号",null,{"$f":"ASC(IF(+TEXT(奨学生願書!F22,\"標準\")=\"0\",\"\",+TEXT(奨学生願書!F22,\"標準\")))","v":""},null,null,null,null,"連絡先希望",null,{"$f":"IF(+TEXT(D25,\"標準\")=\"\",\"「奨学生願書」シートで本人携帯番号を入力してください\",\"OK\")","v":"「奨学生願書」シートで本人携帯番号を入力してください"},null,null,null,null,"016 コンゴ民主共和国 ",null,null,"国際大学","17　国際大学"]
[22,"PCメールアドレス",null,{"$f":"IF(+TEXT(奨学生願書!U21,\"標準\")=\"0\",\"\",+TEXT(奨学生願書!U21,\"標準\"))","v":""},null,null,null,null,{"$f":"IF(D26=\"\",IF(D27=\"\",3,2),1)","v":3},null,{"$f":"IF(+TEXT(D26,\"標準\")=\"\",\"「奨学生願書」シートでPCメールアドレスを入力してください\",\"OK\")","v":"「奨学生願書」シートでPCメールアドレスを入力してください"},null,null,null,null,"015 コロンビア",null,null,"国際基督教大学","18　国際基督教大学"]
[23,"携帯メールアドレス",null,{"$f":"IF(+TEXT(奨学生願書!U22,\"標準\")=\"0\",\"\",+TEXT(奨学生願書!U22,\"標準\"))","v":""},null,null,null,null,null,null,{"$f":"IF(+TEXT(D27,\"標準\")=\"\",\"「奨学生願書」シートで携帯メールアドレスを入力してください\",\"OK\")","v":"「奨学生願書」シートで携帯メールアドレスを入力してください"},null,null,null,null,"016 コンゴ民主共和国 ",null,null,"静岡大学","19　静岡大学"]
[24,"出身校（高校）",null,{"$f":"IF(+TEXT('履歴書(1)'!U17,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!U17,\"標準\"))","v":""},{"$f":"IF(+TEXT('履歴書(1)'!E28,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!E28,\"標準\"))","v":""},{"$f":"IF(+TEXT('履歴書(1)'!F28,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!F28,\"標準\"))","v":""},{"$f":"IF(+TEXT('履歴書(1)'!G28,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!G28,\"標準\"))","v":""},null,null,null,{"$f":"IF(+ISBLANK(D28),\"「奨学生願書」シートで出身高校名を入力してください\",\"OK\")","v":"OK"},null,null,null,null,"017 シンガポール",null,null,"上智大学","20　上智大学"]
[25,"出身校（高校時留学先）",null,{"$f":"IF(+TEXT('履歴書(1)'!U16,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!U16,\"標準\"))","v":""},{"$f":"IF(+TEXT('履歴書(1)'!E29,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!E29,\"標準\"))","v":""},{"$f":"IF(+TEXT('履歴書(1)'!F29,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!F29,\"標準\"))","v":""},{"$f":"IF(+TEXT('履歴書(1)'!G29,\"標準\")=\"0\",\"\",+TEXT('履歴書(1)'!G29,\"標準\"))","v":""},"（高校時、留学経験がある場合。国　高校名）",null,null,"入力チェック対象外","出身校大学",null,null,null,"018 ジンバブエ共和国 ",null,null,"信州大学","21　信州大学"]
[26,"出身校（大学、学部）",null,{"$f":"IF(L30=\"\",\"\",L30)","v":0},null,null,null,"（学部編入者、修士、博士課程のみ）",null,null,{"$f":"IF('履歴書(1)'!E11=\"学部生\",\"OK\",\nIF(+ISBLANK(D30),\"「奨学生願書」シートで出身大学、学部名を入力してください\",\"OK\"))","v":"OK"},{"$f":"IF('履歴書(1)'!E11=\"学部生\",\"\",'履歴書(1)'!U21)","v":0},null,null,null,"019 スペイン ",null,null,"成蹊大学","22　成蹊"]
[27,"学業成績",null,"GPA",{"$f":"+奨学生願書!G16","v":0},"取得済み単位数",{"$f":"+奨学生願書!Q16","v":0},"（GPAは計算シートで計算し入力。学部生は前年までの成績及び取得単位。修士、博士専門は前課程の成績）",null,null,{"$f":"IF(N(E31)=0,\"GPAを入力して下さい\",IF(N(G31)=0,\"単位数を入力してください\",\n                                                          \"OK\" ))","v":"GPAを入力して下さい"},null,null,null,null,"020 スリランカ",null,null,"西南学院大学","23　西南学院大学"]
[28,"家族情報",null,"続柄","年齢","勤務先/学校",null,null,null,null,null,null,null,"家族続柄",null,"021 タイ",null,null,"創価大学","24　創価大学"]
[29,null,null,{"$f":"IF(+TEXT(家計状況調書!M9,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!M9,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!P9,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!P9,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!S9,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!S9,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!R9,\"標準\")=\"\",\"\",+TEXT(家計状況調書!R9,\"標準\"))","v":"0"},"・勤務先は会社名、自営、なし等\n・祖父母は年金、会社名、自営等\n・学校名、大学は学部まで",null,null,"入力チェック対象外",null,null,"祖父",null,"022 台湾",null,null,"千葉大学","25　千葉大学"]
[30,null,null,{"$f":"IF(+TEXT(家計状況調書!M10,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!M10,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!P10,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!P10,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!S10,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!S10,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!R10,\"標準\")=\"\",\"\",+TEXT(家計状況調書!R10,\"標準\"))","v":"0"},null,null,null,"入力チェック対象外",null,null,"祖母",null,"023 中国 ",null,null,"中央大学","26　中央大学"]
[31,null,null,{"$f":"IF(+TEXT(家計状況調書!M11,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!M11,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!P11,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!P11,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!S11,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!S11,\"標準\"))","v":""},null,null,null,null,"入力チェック対象外",null,null,"父",null,"024 チリ",null,null,"筑波大学","27　筑波大学"]
[32,null,null,{"$f":"IF(+TEXT(家計状況調書!M12,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!M12,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!P12,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!P12,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!S12,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!S12,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!R12,\"標準\")=\"\",\"\",+TEXT(家計状況調書!R12,\"標準\"))","v":"0"},null,null,null,"入力チェック対象外",null,null,"母",null,"025 ドイツ",null,null,"東京大学","28　東京大学"]
[33,null,null,{"$f":"IF(+TEXT(家計状況調書!M13,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!M13,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!P13,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!P13,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!S13,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!S13,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!R13,\"標準\")=\"\",\"\",+TEXT(家計状況調書!R13,\"標準\"))","v":"0"},null,null,null,"入力チェック対象外",null,null,"兄",null,"026 ニュージーランド ",null,null,"東京外国語大学","29　東京外国語大学"]
[34,null,null,{"$f":"IF(+TEXT(家計状況調書!M14,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!M14,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!P14,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!P14,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!S14,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!S14,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!R14,\"標準\")=\"\",\"\",+TEXT(家計状況調書!R14,\"標準\"))","v":"0"},null,null,null,"入力チェック対象外",null,null,"姉",null,"027 ネパール",null,null,"東京工業大学","30　東京工業大学"]
[35,null,null,{"$f":"IF(+TEXT(家計状況調書!M15,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!M15,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!P15,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!P15,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!S15,\"標準\")=\"0\",\"\",+TEXT(家計状況調書!S15,\"標準\"))","v":""},{"$f":"IF(+TEXT(家計状況調書!R15,\"標準\")=\"\",\"\",+TEXT(家計状況調書!R15,\"標準\"))","v":"0"},null,null,null,"入力チェック対象外",null,null,"弟",null,"028 ブラジル ",null,null,"東京理科大学","31　東京理科大学"]
[36,"家族情報（年収）",null,{"$f":"+家計状況調書!AA24/10","v":0},"万円",null,null,"（,家計状況調書の年収を入力）",null,null,{"$f":"IF(+N(D40)=0, \"「出願者の収支説明書」シートで年収を入力してください\",\n                                                          \"OK\" )","v":"「出願者の収支説明書」シートで年収を入力してください"},null,null,"妹",null,"029 ベトナム ",null,null,"同志社大学","32　同志社大学",null,"当財団奨学金を除外する作業域"]
[37,"奨学金受給状況",null,"奨学金名称",null,null,null,"確定/申請中","貸与/給付","金額（万円/年）",null,null,null,null,null,"030 ペルー ",null,null,"東北大学","33　東北大学",null,"名前の存在確認０なし、実数あり","奨学金名","確定/申請中","貸与/給付","金額"]
[38,null,null,{"$f":"+T(出願者の収支説明書!B27)","v":"（公財）三菱UFJ信託奨学財団"},null,null,null,{"$f":"IF(+TEXT(出願者の収支説明書!Z27,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!Z27,\"標準\"))","v":"申請中"},{"$f":"IF(+TEXT(出願者の収支説明書!U27,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!U27,\"標準\"))","v":"給付"},{"$f":"IF(+TEXT(出願者の収支説明書!L27,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!L27,\"標準\"))","v":"1200"},"入力チェック対象外",null,null,null,null,"031 ベルギー ",null,null,"獨協大学","34　獨協大学",null,{"$f":"IFERROR(FINDB(\"三菱UFJ信託\",D42,1),0)","v":9},{"$f":"T(IF(OR($V42<>0,$H42=\"申請中\"),\"\",D42))","v":""},{"$f":"T(IF(OR($V42<>0,$H42=\"申請中\"),\"\",H42))","v":""},"",""]
[39,null,null,{"$f":"+T(出願者の収支説明書!B28)","v":""},null,null,null,{"$f":"IF(+TEXT(出願者の収支説明書!Z28,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!Z28,\"標準\"))","v":""},{"$f":"IF(+TEXT(出願者の収支説明書!U28,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!U28,\"標準\"))","v":""},{"$f":"IF(+TEXT(出願者の収支説明書!L28,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!L28,\"標準\"))","v":""},"入力チェック対象外",null,null,null,null,"032 ポルトガル",null,null,"長崎大学","35　長崎大学",null,{"$f":"IFERROR(FINDB(\"三菱UFJ信託\",D43,1),0)","v":0},{"$f":"T(IF(OR($V43<>0,$H43=\"申請中\"),\"\",D43))","v":""},"","",""]
[40,null,null,{"$f":"+T(出願者の収支説明書!B29)","v":""},null,null,null,{"$f":"IF(+TEXT(出願者の収支説明書!Z29,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!Z29,\"標準\"))","v":""},{"$f":"IF(+TEXT(出願者の収支説明書!U29,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!U29,\"標準\"))","v":""},{"$f":"IF(+TEXT(出願者の収支説明書!L29,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!L29,\"標準\"))","v":""},"入力チェック対象外",null,null,null,null,"033 マレーシア ",null,null,"名古屋大学","36　名古屋大学",null,{"$f":"IFERROR(FINDB(\"三菱UFJ信託\",D44,1),0)","v":0},{"$f":"T(IF(OR($V44<>0,$H44=\"申請中\"),\"\",D44))","v":""},{"$f":"T(IF(OR($V44<>0,$H44=\"申請中\"),\"\",H44))","v":""},"",""]
[41,null,null,{"$f":"+T(出願者の収支説明書!B30)","v":""},null,null,null,{"$f":"IF(+TEXT(出願者の収支説明書!Z30,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!Z30,\"標準\"))","v":""},{"$f":"IF(+TEXT(出願者の収支説明書!U30,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!U30,\"標準\"))","v":""},{"$f":"IF(+TEXT(出願者の収支説明書!L30,\"標準\")=\"0\",\"\",+TEXT(出願者の収支説明書!L30,\"標準\"))","v":""},"入力チェック対象外",null,null,null,null,"034 ミャンマー",null,null,"南山大学","37　南山大学",null,{"$f":"IFERROR(FINDB(\"三菱UFJ信託\",D45,1),0)","v":0},{"$f":"T(IF(OR($V45<>0,$H45=\"申請中\"),\"\",D45))","v":""},"","",""]
[42,"進路希望",null,{"$f":"IF(N46=\"0\",\"\",N46)","v":" "},{"$f":"IF(M46=\"0\",\"\",M46)","v":0},{"$f":"IF(N46=\"0\",\"\",N46)","v":" "},{"$f":"IF(O46=\"0\",\"\",O46)","v":0},"進路希望を記入、「就職　業界」、「進学　大学名」など。\n（例：就職　金融、保険/進学　法科大学院）",null,null,{"$f":"IF(+TEXT(D46,\"標準\")=\"\",\"進路希望を入力してください\",\"OK\")","v":"OK"},null,null,{"$f":"奨学生願書!F30&\" \"&奨学生願書!S30","v":" "},null,"035 メキシコ ",null,null,"一橋大学","38　一橋大学",null,null,{"$f":"IF(H44=\"申請中\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"036 モンゴル",null,null,"広島大学","39　広島大学",null,"奨学金情報文字列を連結する"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"037 ラオス",null,null,"福島大学","40　福島大学",null,{"$f":"CONCATENATE(Y42&\" \",W42&\" \",X42&\" \",Z42&  IF(W42=\"\",\"\",Z42&\"千円/年\"),X42&\"*\",\nY43&\" \",W43&\" \", IF(W43=\"\",\"\",Z43&\"千円/年\"),X43&\"*\",\nY44&\" \",W44&\" \", IF(W44=\"\",\"\",Z44&\"千円/年\"),X44&\"*\",\nY45&\" \",W45&\" \", IF(W45=\"\",\"\",Z45&\"千円/年\"),X45&\"*\",)","v":"   *  *  *  *"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"038 ロシア",null,null,"法政大学","41　法政大学",null,"1セル目に当財団名がるとき左端の3文字「  *]を削除する（１列目に当財団名があるとき改行しない）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"039 フランス",null,null,"北海道大学","42　北海道大学",null,{"$f":"IF(V42=0,V48,+RIGHT(V48,LEN(V48)-4))","v":"  *  *  *"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"040 ウクライナ",null,null,"明治大学","43　明治大学",null,"途中のセルに当財団名があるとき*  *を*に変換する。（２行改行を避ける）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"041 ウズベキスタン",null,null,"山梨大学","44　山梨大学",null,{"$f":"+SUBSTITUTE(V50,\"*  *\",\"*\")","v":"  *  *"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"042 フィリピン"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"043 南アフリカ共和国"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"044 ジョージア"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"999 その他",null,null,"横浜国立大学","45　横浜国立大学",null,"申請中/確定で確定を空白に変換する。（確定の表記を消す）この情報がアップロードシートに参照される。"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"立教大学","46　立教大学",null,{"$f":"+SUBSTITUTE(V52,\"確定\",\"\")","v":"  *  *"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"立命館大学","47　立命館大学",null,"途中のセルに当財団名があるとき*  *を*に変換する。（２行改行を避ける）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"早稲田大学","48　早稲田大学",null,{"$f":"+SUBSTITUTE(V57,\"*  *\",\"*\")","v":"  *"}]

{"sheet":"SMILEアップロード","index":9,"n_rows":18,"n_cols":62,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["管理番号","ﾌﾘｶﾞﾅ","個人ｺｰﾄﾞ","氏名","登録日","生年月日","性別","連絡先希望","自宅郵便番号","自宅住所１","自宅住所２","自宅住所３","自宅ｶｽﾀﾏﾊﾞｰｺｰﾄﾞ","自宅電話番号","自宅携帯番号","奨学金振込履歴","年報原稿執筆年","会社名","所属","役職","会社郵便番号","会社住所１","会社住所２","会社住所３","会社ｶｽﾀﾏﾊﾞｰｺｰﾄﾞ","会社電話番号","会社FAX番号","ﾒｰﾙｱﾄﾞﾚｽ１","ﾒｰﾙｱﾄﾞﾚｽ２","携帯ﾒｰﾙｱﾄﾞﾚｽ","画像情報","奨学金継続","現役生・OG/OB","奨学生区分","学生区分","国籍","次回振込休止等(チェック)","採用辞退(チェック)","（未使用）(チェック)","備考","大学名","学部","大学名ﾌﾘｶﾞﾅ","銀行名","支店名","口座番号","金額（３ヶ月）","学年","GPA","OB会入会金","在学期間【入学】","在学期間【卒業】","給費開始","給費終了","給費停止開始日","支給停止終了日","RIDOCﾃﾞｰﾀ","個別ﾌｫﾙﾀﾞ","出身校","家族情報(構成･住所)","学業成績"]
[null,{"$f":"+LEFTB(学生入力画面!D5,20)","v":""},null,{"$f":"LEFTB(学生入力画面!D4,20)","v":""},null,{"$f":"T(+LEFTB(CONCATENATE(学生入力画面!D15&\"/\",+RIGHT(\"0\"&学生入力画面!E15,2)&\"/\",+RIGHT(\"0\"&学生入力画面!F15,2)),10))","v":"/0/0"},{"$f":"IF(学生入力画面!G12=\"男\",1,2)","v":2},{"$f":"+学生入力画面!I26","v":3},{"$f":"+LEFTB(学生入力画面!D20,10)","v":""},{"$f":"+LEFTB(学生入力画面!D21,32)","v":""},{"$f":"+LEFTB(学生入力画面!D22,32)","v":""},{"$f":"+LEFTB(学生入力画面!D23,32)","v":""},null,{"$f":"+LEFTB(学生入力画面!D24,32)","v":""},{"$f":"LEFTB(学生入力画面!D25,20)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+LEFTB(学生入力画面!D26,64)","v":""},null,{"$f":"+LEFTB(学生入力画面!D27,64)","v":""},{"$f":"+LEFTB(CONCATENATE(\"\\\\Ridoc-srv\\顧客管理\\顔写真\\\"&学生入力画面!D16&\" \",学生入力画面!D4&\".jpg\"),64)","v":"\\\\Ridoc-srv\\顧客管理\\顔写真\\ .jpg"},null,1,{"$f":"IF(学生入力画面!G11=\"一般\",\"001\",\"002\")","v":"002"},{"$f":"IF(学生入力画面!E11=\"学部生\",\"001\",+IF(学生入力画面!E11=\"修士課程\",\"002\",+IF(学生入力画面!E11=\"博士課程\",\"003\",\"004\")))","v":"004"},{"$f":"+LEFT(+学生入力画面!F13,3)","v":"000"},null,null,null,{"$f":"+LEFTB(CONCATENATE(学生入力画面!D6&\" \",学生入力画面!D8&\" \",学生入力画面!D9,\n +IF(学生入力画面!E11=\"学部生\",\" \"&+学生入力画面!D10,\n +IF(学生入力画面!E11=\"修士課程\",\" 修士\"&+学生入力画面!D10,\n +IF(学生入力画面!E11=\"博士課程\",\" 博士\"&+学生入力画面!D10,\" 専門職\"&+学生入力画面!D10)))),499)","v":"大学大学院 研究科 専攻 専門職0"},{"$f":"+LEFTB(学生入力画面!R6,30)","v":"大学"},{"$f":"+LEFTB(学生入力画面!D8,30)","v":"研究科"},{"$f":"+LEFTB(学生入力画面!D7,30)","v":""},"三菱UFJ信託","本",null,{"$f":"IF(学生入力画面!G11=\"一般\",IF(学生入力画面!E11=\"学部生\",\"105000\",\"165000\"),IF(学生入力画面!G11=\"留学生\",IF(学生入力画面!E11=\"学部生\",\"210000\",\"300000\"),\"300000\"))","v":"300000"},{"$f":"学生入力画面!D10","v":"0"},{"$f":"学生入力画面!E31","v":0},null,{"$f":"+LEFTB(CONCATENATE(学生入力画面!D18&\"/\",+RIGHT(\"0\"&学生入力画面!E18,2)&\"/\",+RIGHT(\"0\"&学生入力画面!F18,2)),10)","v":"/0/0"},{"$f":"+LEFTB(CONCATENATE(学生入力画面!D19&\"/\",+RIGHT(\"0\"&学生入力画面!E19,2)&\"/\",+RIGHT(\"0\"&学生入力画面!F19,2)),10)","v":"/0/0"},{"$f":"+LEFTB(CONCATENATE(学生入力画面!D16&\"/\",+RIGHT(\"0\"&学生入力画面!E16,2)&\"/\",+RIGHT(\"0\"&学生入力画面!F16,2)),10)","v":"/0/0"},{"$f":"+LEFTB(CONCATENATE(学生入力画面!D17&\"/\",+RIGHT(\"0\"&学生入力画面!E17,2)&\"/\",+RIGHT(\"0\"&学生入力画面!F17,2)),10)","v":"/0/0"},null,null,{"$f":"PROPER(IF(AJ2=\"000\",+SUBSTITUTE(学生入力画面!D4,\" \",\"　\"),+SUBSTITUTE(学生入力画面!D4,\"　\",\" \")))","v":""},null,{"$f":"+LEFTB(IF(+T(学生入力画面!D29)=\"\",\n          学生入力画面!D28&\"*\"&学生入力画面!D30,+CONCATENATE(学生入力画面!D29&\"（留学)　*\",学生入力画面!D28&\"*\"&学生入力画面!D30)),200)","v":"*0"},{"$f":"ASC(LEFTB(\nIF('履歴書(1)'!M11=\"一般\",+CONCATENATE(BG18&\"　*年収　\",学生入力画面!D40&\"万円\"),\nBG18),400))","v":"〒*  *  *"},{"$f":"LEFTB(IF(学生入力画面!E11=\"学部生\",+CONCATENATE(\"応募時成績　\"&学生入力画面!E31,\"　\"&学生入力画面!G31&\"　*大2　*大3　*大4　*\"&BJ12&学生入力画面!D46),\n\nIF(学生入力画面!E11=\"修士課程\",+CONCATENATE(\"応募時成績　\"&学生入力画面!E31,\" \"&学生入力画面!G31&\"　*修1　*修2　*\"&BJ12&学生入力画面!D46),\n\nIF(学生入力画面!E11=\"その他（専門職）\",+CONCATENATE(\"応募時成績　\"&学生入力画面!E31,\"　\"&学生入力画面!G31&\"　*専1　*専2　*専3　*\"&BJ12&学生入力画面!D46),\n\"応募時成績　\"&+CONCATENATE(学生入力画面!E31,\"　\"&学生入力画面!G31&\"　*博1　*博2　*博3　*\"&BJ12&学生入力画面!D46)))),400)","v":"応募時成績　0　0　*博1　*博2　*博3　*  * "}]
[{"$f":"IF(A2=\"\",\"\",A2)","v":""},"","","","","/0/0",2,3,"","","","","","","","","","","","","","","","","","","","","","","\\\\Ridoc-srv\\顧客管理\\顔写真\\ .jpg","",{"$f":"IF(AG2=\"\",\"\",AG2)","v":1},"002","004","000","","","","大学大学院 研究科 専攻 専門職0","大学","研究科","","三菱UFJ信託","本","","300000","0",0,"","/0/0","/0/0","/0/0","/0/0","","","",null,{"$f":"IF(BG2=\"\",\"\",BG2)","v":"*0"},{"$f":"IF(BH2=\"\",\"\",BH2)","v":"〒*  *  *"},{"$f":"IF(BI2=\"\",\"\",BI2)","v":"応募時成績　0　0　*博1　*博2　*博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,null,"注：固定値",null,null,null,null,null,null,null,null,null,null,"注：固定値","注：固定値",null,null,null,null,null,null,null,null,null,null,null,"（注：H28年度から読込み開始）",null,null,"注：家族住所は奨学生願書ｼｰﾄから直接リンク。改行(alt+enter)は除外、スペースは１文字スペースに圧縮"]
[null,null,null,null,null,null,null,null,null,null,"入力文字数確認",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"注：家族が５人以内の場合は５行につめる。５人未満の場合は５行に表記する。"]
["コピー済 2015/03/17 10:18:36",null,null,null,null,null,null,null,null,null,"家族情報",{"$f":"IF(LENB(BH2)>=400,\"家族情報が２００文字を超えています。\",\"OK\")","v":"OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"学業成績",{"$f":"IF(LENB(BI2)>=400,\"学業成績が２００文字を超えています。\",\"OK\")","v":"OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(+RIGHT(BH8,2)=\"　*\",+LEFT(BH8,(+LEN(+T(BH8))-3)),BH8)","v":"〒*　　*　　*　　*　　*　　*"},{"$f":"+LEFTB(CONCATENATE(BH12&\"*\",学生入力画面!D33&\"　\",学生入力画面!E33&\"　\",学生入力画面!F33&\"*\",学生入力画面!D34&\"　\",学生入力画面!E34&\"　\",学生入力画面!F34&\"*\",学生入力画面!D35&\"　\",学生入力画面!E35&\"　\",学生入力画面!F35&\"*\",学生入力画面!D36&\"　\",学生入力画面!E36&\"　\",学生入力画面!F36&\"*\",学生入力画面!D37&\"　\",学生入力画面!E37&\"　\",学生入力画面!F37&\"*\",学生入力画面!D38&\"　\",学生入力画面!E38&\"　\",学生入力画面!F38&\"*\",IF(学生入力画面!D39=\"\",\"\",学生入力画面!D39&\"　\"&学生入力画面!E39&\"　\"&学生入力画面!F39)),400)","v":"〒*　　*　　*　　*　　*　　*　　*"},{"$f":"IF(+T(学生入力画面!D42)=\"\",\"\",\nIF(+T(学生入力画面!D43)=\"\",学生入力画面!I42&\" \"&学生入力画面!D42&\" \"&学生入力画面!J42&\"千円/年\"& IF(学生入力画面!H42=\"確定\",\"*\",\" (申請中)*\"),\n\nIF(+T(学生入力画面!D44)=\"\",学生入力画面!I42&\" \"&学生入力画面!D42&\" \"&学生入力画面!J42&\"千円/年\"& IF(学生入力画面!H42=\"確定\",\"*\",\" (申請中)*\")\n&学生入力画面!I43&\" \"&学生入力画面!D43&\" \"&学生入力画面!J43&\"千円/年\"& IF(学生入力画面!H43=\"確定\",\"*\",\"(申請中)*\"),\n\n学生入力画面!I42&\" \"&学生入力画面!D42&\" \"&学生入力画面!J42&\"千円/年 \"& IF(学生入力画面!H42=\"確定\",\"*\",\" (申請中)*\")\n&学生入力画面!I43&\" \"&学生入力画面!D43&\" \"&学生入力画面!J43&\"千円/年　\"& IF(学生入力画面!H43=\"確定\",\"*\",\" (申請中)*\")\n&学生入力画面!I44&\" \"&学生入力画面!D44&\" \"&学生入力画面!J44&\"千円/年\"& IF(学生入力画面!H44=\"確定\",\"*\",\" (申請中)*\"))))","v":"給付 （公財）三菱UFJ信託奨学財団 1200千円/年 (申請中)*"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"奨学金情報一次サマリー（4行目まで）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(+RIGHT(BG8,2)=\"　*\",+LEFT(BG8,(+LEN(+T(BG8))-3)),BG8)","v":"〒*　　*　　*　　*　　*"},{"$f":"TRIM(CLEAN(奨学生願書!B27))","v":"〒"},null,{"$f":"+学生入力画面!V59","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,"家族第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,null,null,null,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(+RIGHT(BG12,2)=\"　*\",+LEFT(BG12,(+LEN(+T(BG12))-3)),BG12)","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,{"$f":"+IF(+RIGHT(BG15,2)=\"　*\",+LEFT(BG15,(+LEN(+T(BG15))-3)),BG15)","v":"〒*　　*　　*"}]

{"sheet":"システム管理","index":10,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["保管先ディレクトリ：","C:\\Users\\NPC4\\奨学生推薦書類"]
["大学フォルダ名：",{"$f":"+TEXT(学生入力画面!R9,1)","v":{"$error":"#N/A"}}]
["ファイル名：",{"$f":"+TEXT(学生入力画面!D4,1)","v":""}]
["SMILEアップロードファイ名","SMILEｱｯﾌﾟﾛｰﾄﾞﾌｧｲﾙ"]

{"sheet":"システム管理2","index":11,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["保管先ディレクトリ：","C:\\Users\\NPC5\\奨学生推薦書類"]
["大学フォルダ名：",{"$f":"+TEXT(学生入力画面!R9,1)","v":{"$error":"#N/A"}}]
["ファイル名：",{"$f":"+TEXT(学生入力画面!D4,1)","v":""}]
["SMILEアップロードファイ名","SMILEｱｯﾌﾟﾛｰﾄﾞﾌｧｲﾙ"]

{"sheet":"Sheet1","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet2","index":13,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["更新履歴"]
[20150316,"使用者2用のSIMILEアップロードファイル書き込みマクロ（表のCOPY2）のバグ修正：CALLしているサブマクロ名が使用者1と同じ名前だった。"]
[null,"リボンから｛開発」を削除"]