{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["記入例","志願者一覧","志願者一覧 (1ページ目)","志願者一覧 (2ページ目)","志願者一覧 (3ページ目)","計算用","ソート"],"not_rendered":{"macros":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"記入例","index":0,"n_rows":45,"n_cols":19,"rows_kept":45,"merged":[[0,7,0,9],[1,2,2,10],[2,15,2,16],[4,0,5,2],[4,3,5,3],[4,7,5,10],[7,3,7,7],[7,15,26,16],[7,18,8,18],[8,3,8,7],[8,10,8,12],[9,0,9,1],[9,3,9,7],[9,18,11,18],[10,0,11,1],[10,2,10,5],[10,6,10,9],[10,10,11,13],[12,10,12,13],[13,10,13,13],[14,10,14,13],[15,10,15,13],[16,10,16,13],[17,10,17,13],[18,10,18,13],[19,10,19,13],[20,10,20,13],[21,10,21,13],[22,10,22,13],[23,10,23,13],[24,10,24,13],[25,10,25,13],[26,10,26,13],[27,10,27,13],[28,10,28,13],[29,10,29,13],[30,10,30,13],[31,10,31,13],[32,10,32,13],[33,10,33,13],[34,10,34,13],[35,10,35,13],[36,10,36,13],[37,10,37,13],[38,10,38,13],[39,10,39,13],[40,10,40,13],[41,10,41,13]]}
["岡山理科大学附属高等学校",{"$nulls":6},"令和2年",null,null,1,"月",10,"日",null,"中学校の先生方へ"]
[null,null,"入学志願者一覧表",{"$nulls":14},"会場リスト"]
[{"$nulls":15},"選抜１期入試の出願に際しましては、願書受付を円滑に進めるため、本校所定の「入学志願者一覧表」の作成に",null,"①本校"]
[{"$nulls":7},"入力担当者",{"$nulls":7},"ご協力いただきますよう、お願い申し上げます。",null,"②倉敷"]
["岡山市立○○",null,null,"中学校",{"$nulls":3},"理大　太郎",{"$nulls":7},"なお、様式については、本校ホームページ上から、ダウンロードしていただけるよう準備いたしますのでご利用",null,"③玉野"]
[{"$nulls":11},"印",{"$nulls":3},"下さい。（１１月下旬掲載予定）",null,"④高梁"]
[{"$nulls":3},{"$f":"IF(SUM(計算用!K3:K17,計算用!L3:L17,計算用!M3:M17,計算用!N3:N17)>0,\"エラー内容\",\"\")","v":""},{"$nulls":13},"科・コースリスト"]
[{"$nulls":3},{"$f":"IF(SUM(計算用!K3:K32)>0,\"インターナショナルコースは本校会場のみでの受験となっております。\",\"\")","v":""},{"$nulls":11},"【記入方法について】\n※太枠内のみ入力してください。\n※志願者1名につき1行で入力してください。\n\n　　\n①入試会場、出願コースの順序\n志願者の内容を入力後、「印刷確認」ボタンをクリックすると、新しいシートが作成され自動的に並べ替えられます。\n\n②「入試会場」 「出願するコース」「推薦/一般」「専願」は該当項目を選択して下さい。各入力セルでクリックすると▼が表示され、入力候補リストが表示されますので選択してください。\n\n③専願\n専願で出願する場合、○を選択してください。両日受験の場合、専願はどちらか１日のみになります。\n\n④受験料\n受験料は自動計算されます。専願で受験される方は、受験料免除となっています。両日受験の場合は、2日目の受験料が免除になります。なお、両日受験でどちらかが専願の場合は、両日とも受験料免除となります。\n\n⑤エラーチェック\nエラーがある場合は、エラー箇所が塗り潰されます。エラー内容をご確認いただき、訂正をお願いします。\n\n⑥印刷\n「印刷確認」ボタンをクリックしてください。新しいシートが作成され自動的に並べ替えられます。印刷範囲を設定してありますが、プリンターによって印刷サイズが異なることがあるため、必ず印刷プレビューで確認してください。\n\n⑦願書の並び順\n印刷されたリストの順に、1日目の願書、２日目の願書に分けて並べてください。",null,"グローバルサイエンス（特進）","１日目"]
[{"$nulls":3},{"$f":"IF(SUM(計算用!L3:L32,計算用!M3:M32)>0,\"推薦(面接のみ)で受験される場合は、本校会場のみでの受験となっております。\",\"\")","v":""},{"$nulls":4},{"$f":"COUNTA(D13:D42,H13:H42)","v":22},"通",{"$f":"SUM(K12:N42)","v":{"v":65000,"d":"65,000 "}},null,null,"円",{"$nulls":3},"総合進学"]
["選抜1期のみ",null,null,{"$f":"IF(SUM(計算用!N3:N32)>0,\"専願はどちらか1日のみとなります。\",\"\")","v":""},{"$nulls":13},"グローバルサイエンス（進学）","２日目"]
["志願者氏名",null,"１日目の第１希望",{"$nulls":3},"2日目の第１希望",{"$nulls":3},"受験料\n（自動計算）",{"$nulls":6},"スポーツサイエンス"]
[null,null,"入試会場","出願するコース","推薦/一般","専願","入試会場","出願するコース","推薦/一般","専願",{"$nulls":7},"国際バカロレア"]
[1,"岡山　Ａ郎","①本校","グローバルサイエンス（特進）","推薦(筆記も受ける)",{"$nulls":5},{"$f":"IF(B13=\"\",\"\",(IF(COUNTA(D13,H13)>0,1,0)-IF(COUNTIF(F13:J13,\"○\")=0,0,1))*13000)","v":{"v":13000,"d":"13,000 "}},{"$nulls":6},"推薦/一般"]
[2,"岡山　Ｂ郎","③玉野","総合進学","国際生・帰国生",{"$nulls":5},{"v":13000,"d":"13,000 "},{"$nulls":6},"推薦(面接のみ)"]
[3,"岡山　Ｃ子",{"$nulls":4},"①本校","グローバルサイエンス（進学）","推薦(面接のみ)","○",{"v":0,"d":"0 "},{"$nulls":6},"推薦(筆記も受ける)"]
[4,"岡山　Ｄ郎",{"$nulls":4},"①本校","スポーツサイエンス","推薦(筆記も受ける)","○",{"v":0,"d":"0 "},{"$nulls":6},"一般"]
[5,"岡山　Ｅ郎","①本校","グローバルサイエンス（特進）","一般",null,"③玉野","グローバルサイエンス（進学）","一般","○",{"v":0,"d":"0 "},{"$nulls":6},"国際生・帰国生"]
[6,"岡山　Ｆ郎","①本校","総合進学","推薦(面接のみ)",null,"①本校","国際バカロレア","国際生・帰国生","○",{"v":0,"d":"0 "},{"$nulls":6},"専願リスト"]
[7,"岡山　Ｇ子","①本校","総合進学","推薦(筆記も受ける)","○","①本校","グローバルサイエンス（進学）","推薦(筆記も受ける)",null,{"v":0,"d":"0 "},{"$nulls":6},"○"]
[8,"岡山　Ｈ郎","②倉敷","グローバルサイエンス（特進）","一般",null,"①本校","国際バカロレア","一般",null,{"v":13000,"d":"13,000 "}]
[9,"岡山　Ｉ郎","①本校","グローバルサイエンス（特進）","推薦(面接のみ)","○","①本校","グローバルサイエンス（進学）","国際生・帰国生",null,{"v":0,"d":"0 "}]
[10,"岡山　Ｊ郎","③玉野","総合進学","一般",null,"③玉野","グローバルサイエンス（進学）","国際生・帰国生",null,{"v":13000,"d":"13,000 "}]
[11,"岡山　Ｋ郎","④高梁","総合進学","推薦(筆記も受ける)",{"$nulls":5},{"v":13000,"d":"13,000 "}]
[12,"岡山　Ｌ郎",{"$nulls":4},"②倉敷","スポーツサイエンス","一般","○",{"v":0,"d":"0 "}]
[13,"岡山　Ｍ郎",{"$nulls":4},"①本校","国際バカロレア","推薦(面接のみ)","○",{"v":0,"d":"0 "}]
[14,"岡山　Ｎ郎","②倉敷","グローバルサイエンス（特進）","一般","○",{"$nulls":4},{"v":0,"d":"0 "}]
[15,"岡山　Ｏ郎","①本校","総合進学","国際生・帰国生",null,"④高梁","グローバルサイエンス（進学）","国際生・帰国生","○",{"v":0,"d":"0 "}]
[16,{"$nulls":9},{"$f":"IF(B28=\"\",\"\",(IF(COUNTA(D28,H28)>0,1,0)-IF(COUNTIF(F28:J28,\"〇\")=0,0,1))*13000)","v":""}]
[17,{"$nulls":9},""]
[18,{"$nulls":9},""]
[19,{"$nulls":9},""]
[20,{"$nulls":9},""]
[21,{"$nulls":9},""]
[22,{"$nulls":9},""]
[23,{"$nulls":9},""]
[24,{"$nulls":9},""]
[25,{"$nulls":9},""]
[26,{"$nulls":9},""]
[27,{"$nulls":9},""]
[28,{"$nulls":9},""]
[29,{"$nulls":9},""]
[30,{"$nulls":9},""]
[]
["※","志願者全員をご記入下さい。"]
["※","この表は選抜１期入試のみ提出下さい。"]

{"sheet":"志願者一覧","index":1,"n_rows":62,"n_cols":20,"rows_kept":62,"merged":[[0,7,0,9],[1,2,2,10],[2,15,2,16],[4,0,5,2],[4,3,5,3],[4,7,5,10],[7,3,7,7],[7,19,8,19],[8,3,8,7],[8,15,28,16],[9,3,9,7],[9,19,11,19],[10,3,10,7],[10,10,10,12],[11,0,11,1],[11,3,11,7],[12,0,13,1],[12,2,12,5],[12,6,12,9],[12,10,13,13],[14,10,14,13],[15,10,15,13],[16,10,16,13],[17,10,17,13],[18,10,18,13],[19,10,19,13],[20,10,20,13],[21,10,21,13],[22,10,22,13],[23,10,23,13],[24,10,24,13],[25,10,25,13],[26,10,26,13],[27,10,27,13],[28,10,28,13],[29,10,29,13],[30,10,30,13],[31,10,31,13],[32,10,32,13],[33,10,33,13],[34,10,34,13],[35,10,35,13],[36,10,36,13],[37,10,37,13],[38,10,38,13],[39,10,39,13],[40,10,40,13],[41,10,41,13],[42,10,42,13],[43,10,43,13],[44,10,44,13],[45,10,45,13],[46,10,46,13],[47,10,47,13],[48,10,48,13],[49,10,49,13],[50,10,50,13],[51,10,51,13],[52,10,52,13],[53,10,53,13],[54,10,54,13],[55,10,55,13],[56,10,56,13],[57,10,57,13],[58,10,58,13]]}
["岡山理科大学附属高等学校",{"$nulls":6},"令和2年",{"$nulls":3},"月",null,"日",null,"中学校の先生方へ"]
[null,null,"入学志願者一覧表",{"$nulls":15},"会場リスト"]
[{"$nulls":15},"選抜１期入試の出願に際しましては、願書受付を円滑に進めるため、本校所定の「入学志願者一覧表」の作成に",null,null,"①本校"]
[{"$nulls":7},"入力担当者",{"$nulls":7},"ご協力いただきますよう、お願い申し上げます。",null,null,"②倉敷"]
[{"$nulls":3},"中学校",{"$nulls":11},"なお、様式については、本校ホームページ上から、ダウンロードしていただけるよう準備いたしますのでご利用",null,null,"③玉野"]
[{"$nulls":11},"印",{"$nulls":3},"ください。（１１月下旬掲載予定）",null,null,"④高梁"]
[{"$nulls":3},{"$f":"IF(SUM(計算用!K3:Q32)>0,\"エラー内容\",\"\")","v":""},{"$nulls":14},"科・コースリスト"]
[{"$nulls":3},{"$f":"IF(SUM(計算用!O3:P47)>0,\"推薦（面接のみ)は本校会場のみでの受験となっております。\",\"\")","v":""},{"$nulls":14},"グローバルサイエンス（特進）","１日目"]
[{"$nulls":3},{"$f":"IF(SUM(計算用!K3:K47)>0,\"国際バカロレアコースは本校会場のみでの受験となっております。\",\"\")","v":""},{"$nulls":11},"【記入方法について】\n※太枠内のみ入力してください。\n※志願者1名につき1行で入力してください。\n\n　　\n①入試会場、出願コースの順序\n志願者の内容を入力後、「印刷確認」ボタンをクリックすると、新しいシートが作成され自動的に並べ替えられます。\n\n②「入試会場」 「出願するコース」「推薦/一般」「専願」は該当項目を選択して下さい。各入力セルでクリックすると▼が表示され、入力候補リストが表示されますので選択してください。\n\n③専願\n専願で出願する場合、○を選択してください。両日受験の場合、専願はどちらか１日のみになります。\n\n④受験料\n受験料は自動計算されます。専願で受験される方は、受験料免除となっています。両日受験の場合は、2日目の受験料が免除になります。なお、両日受験でどちらかが専願の場合は、両日とも受験料免除となります。\n\n⑤エラーチェック\nエラーがある場合は、エラー箇所が塗り潰されます。エラー内容をご確認いただき、訂正をお願いします。\n\n⑥印刷\n「印刷確認」ボタンをクリックしてください。新しいシートが作成され自動的に並べ替えられます。印刷範囲を設定してありますが、プリンターによって印刷サイズが異なることがあるため、必ず印刷プレビューで確認してください。\n\n⑦願書の並び順\n印刷されたリストの順に、1日目の願書、２日目の願書に分けて並べてください。",null,null,"総合進学"]
[{"$nulls":3},{"$f":"IF(SUM(計算用!Q3:Q47)>0,\"国際生・帰国生入試はグローバルサイエンス(特進)は出願できません。\",\"\")","v":""},{"$nulls":14},"グローバルサイエンス（進学）","２日目"]
[{"$nulls":3},{"$f":"IF(SUM(計算用!N3:N47)>0,\"専願はどちらか1日のみとなります。\",\"\")","v":""},{"$nulls":4},{"$f":"COUNTA(志願者一覧!D15:D59,志願者一覧!H15:H59)","v":0},"通",{"$f":"SUM(K14:N44)","v":{"v":0,"d":"0 "}},null,null,"円",{"$nulls":4},"スポーツサイエンス"]
["選抜1期のみ",null,null,{"$f":"IF(SUM(計算用!L3:L47,計算用!M3:M47)>0,\"国際生・帰国生入試は本校会場のみでの受験となっております。\",\"\")","v":""},{"$nulls":14},"国際バカロレア"]
["志願者氏名",null,"１日目の第１希望",{"$nulls":3},"2日目の第１希望",{"$nulls":3},"受験料\n（自動計算）",{"$nulls":7},"推薦/一般"]
[null,null,"入試会場","出願するコース","推薦/一般","専願","入試会場","出願するコース","推薦/一般","専願",{"$nulls":8},"推薦(面接のみ)"]
[1,{"$nulls":9},{"$f":"IF(B15=\"\",\"\",(IF(COUNTA(D15,H15)>0,1,0)-IF(COUNTIF(F15:J15,\"○\")=0,0,1))*13000)","v":""},{"$nulls":7},"推薦(筆記も受ける)"]
[2,{"$nulls":9},"",{"$nulls":7},"一般"]
[3,{"$nulls":9},"",{"$nulls":7},"国際生・帰国生"]
[4,{"$nulls":9},"",{"$nulls":7},"専願リスト"]
[5,{"$nulls":9},"",{"$nulls":7},"○"]
[6,{"$nulls":9},""]
[7,{"$nulls":9},{"$f":"IF(B21=\"\",\"\",(IF(COUNTA(D21,H21)>0,1,0)-IF(COUNTIF(F21:J21,\"○\")=0,0,1))*13000)","v":""}]
[8,{"$nulls":9},""]
[9,{"$nulls":9},""]
[10,{"$nulls":9},""]
[11,{"$nulls":9},""]
[12,{"$nulls":9},""]
[13,{"$nulls":9},{"$f":"IF(B27=\"\",\"\",(IF(COUNTA(D27,H27)>0,1,0)-IF(COUNTIF(F27:J27,\"○\")=0,0,1))*13000)","v":""}]
[14,{"$nulls":9},""]
[15,{"$nulls":9},""]
[16,{"$nulls":9},""]
[17,{"$nulls":9},""]
[18,{"$nulls":9},""]
[19,{"$nulls":9},""]
[20,{"$nulls":9},""]
[21,{"$nulls":9},""]
[22,{"$nulls":9},""]
[23,{"$nulls":9},""]
[24,{"$nulls":9},""]
[25,{"$nulls":9},""]
[26,{"$nulls":9},""]
[27,{"$nulls":9},""]
[28,{"$nulls":9},""]
[29,{"$nulls":9},""]
[30,{"$nulls":9},""]
[31,{"$nulls":9},""]
[32,{"$nulls":9},""]
[33,{"$nulls":9},""]
[34,{"$nulls":9},""]
[35,{"$nulls":9},""]
[36,{"$nulls":9},""]
[37,{"$nulls":9},""]
[38,{"$nulls":9},""]
[39,{"$nulls":9},""]
[40,{"$nulls":9},""]
[41,{"$nulls":9},""]
[42,{"$nulls":9},""]
[43,{"$nulls":9},""]
[44,{"$nulls":9},""]
[45,{"$nulls":9},""]
[]
["※","志願者全員をご記入下さい。"]
["※","この表は選抜１期入試のみ提出下さい。"]

{"sheet":"志願者一覧 (1ページ目)","index":2,"n_rows":30,"n_cols":15,"rows_kept":30,"hidden":true,"merged":[[0,7,0,9],[1,2,2,10],[4,0,5,2],[4,3,5,3],[4,7,5,10],[9,10,9,12],[10,0,10,1],[11,0,12,1],[11,2,11,5],[11,6,11,9],[11,10,12,13],[13,10,13,13],[14,10,14,13],[15,10,15,13],[16,10,16,13],[17,10,17,13],[18,10,18,13],[19,10,19,13],[20,10,20,13],[21,10,21,13],[22,10,22,13],[23,10,23,13],[24,10,24,13],[25,10,25,13],[26,10,26,13],[27,10,27,13]]}
["岡山理科大学附属高等学校",{"$nulls":6},"令和2年",null,null,{"$f":"志願者一覧!K1","v":0},"月",{"$f":"志願者一覧!M1","v":0},"日"]
[null,null,"入学志願者一覧表"]
[]
[{"$nulls":7},"入力担当者"]
[{"$f":"志願者一覧!A5","v":0},null,null,"中学校",{"$nulls":3},{"$f":"志願者一覧!H5","v":0}]
[{"$nulls":11},"印"]
[]
[]
[]
[{"$nulls":8},{"$f":"COUNTA(志願者一覧!D15:D59,志願者一覧!H15:H59)","v":0},"通",{"$f":"SUM(K14:N28,'志願者一覧 (2ページ目)'!K14:N28,'志願者一覧 (3ページ目)'!K14:N28)","v":{"v":143000,"d":"143,000 "}},null,null,"円"]
["選抜1期のみ",{"$nulls":9},{"v":1,"d":"1 "},"枚目",{"$f":"IF(COUNTA(志願者一覧!B15:B59)>30,3,IF(COUNTA(志願者一覧!B15:B59)>15,2,1))","v":{"v":1,"d":"1 "}},"枚中",{"$f":"IF(M11=2,\"2ページ目もあります。\",\"\")","v":""}]
["志願者氏名",null,"１日目の第１希望",{"$nulls":3},"2日目の第１希望",{"$nulls":3},"受験料\n（自動計算）",{"$nulls":3},"「印刷プレビュー」で確認後、印刷してください。"]
[null,null,"入試会場","出願するコース","推薦/一般","専願","入試会場","出願するコース","推薦/一般","専願"]
[1,"l","①本校","グローバルサイエンス（特進）","推薦(筆記も受ける)",null,"①本校","グローバルサイエンス（進学）","一般","○",{"$f":"IF(B14=\"\",\"\",(IF(COUNTA(D14,H14)>0,1,0)-IF(COUNTIF(F14:J14,\"○\")=0,0,1))*13000)","v":{"v":0,"d":"0 "}},{"$nulls":3},"修正が必要な場合は、「志願者一覧」のシートで修正後、"]
[2,"h","①本校","グローバルサイエンス（特進）","推薦(筆記も受ける)",null,"②倉敷","グローバルサイエンス（進学）","一般",null,{"$f":"IF(B15=\"\",\"\",(IF(COUNTA(D15,H15)>0,1,0)-IF(COUNTIF(F15:J15,\"○\")=0,0,1))*13000)","v":{"v":13000,"d":"13,000 "}},{"$nulls":3},"再度赤い「印刷確認」ボタンをクリックしてください。"]
[3,"j","①本校","グローバルサイエンス（特進）","推薦(筆記も受ける)",null,"②倉敷","グローバルサイエンス（進学）","推薦(筆記も受ける)",null,{"v":13000,"d":"13,000 "}]
[4,"h","①本校","総合進学","一般",null,"①本校","グローバルサイエンス（進学）","一般",null,{"v":13000,"d":"13,000 "}]
[5,"e","①本校","総合進学","推薦(筆記も受ける)",null,"①本校","グローバルサイエンス（進学）","一般",null,{"v":13000,"d":"13,000 "}]
[6,"s","①本校","総合進学","推薦(筆記も受ける)","○","①本校","スポーツサイエンス","推薦(面接のみ)",null,{"v":0,"d":"0 "}]
[7,"uy","①本校","総合進学","推薦(面接のみ)","○","②倉敷","グローバルサイエンス（進学）","推薦(筆記も受ける)",null,{"v":0,"d":"0 "}]
[8,"a","①本校","総合進学","国際生・帰国生",{"$nulls":5},{"v":13000,"d":"13,000 "}]
[9,"d","②倉敷","グローバルサイエンス（特進）","一般",null,"①本校","グローバルサイエンス（進学）","一般",null,{"v":13000,"d":"13,000 "}]
[10,"u","②倉敷","グローバルサイエンス（特進）","推薦(筆記も受ける)","○","①本校","グローバルサイエンス（進学）","推薦(筆記も受ける)",null,{"v":0,"d":"0 "}]
[11,"d","②倉敷","グローバルサイエンス（特進）","一般","○","①本校","スポーツサイエンス","一般",null,{"v":0,"d":"0 "}]
[12,"h","②倉敷","グローバルサイエンス（特進）","一般",null,"①本校","スポーツサイエンス","推薦(面接のみ)",null,{"v":13000,"d":"13,000 "}]
[13,"g","②倉敷","グローバルサイエンス（特進）","一般",null,"①本校","スポーツサイエンス","一般",null,{"v":13000,"d":"13,000 "}]
[14,"r","②倉敷","グローバルサイエンス（特進）","一般","○","①本校","スポーツサイエンス","一般",null,{"v":0,"d":"0 "}]
[15,"k","②倉敷","グローバルサイエンス（特進）","一般",null,"①本校","スポーツサイエンス","推薦(筆記も受ける)",null,{"v":13000,"d":"13,000 "}]
["※","志願者全員をご記入下さい。"]
["※","この表は選抜１期入試のみ提出下さい。"]

{"sheet":"志願者一覧 (2ページ目)","index":3,"n_rows":30,"n_cols":15,"rows_kept":30,"hidden":true,"merged":[[0,7,0,9],[1,2,2,10],[4,0,5,2],[4,3,5,3],[4,7,5,10],[7,3,7,7],[8,3,8,7],[9,3,9,7],[9,10,9,12],[10,0,10,1],[10,3,10,7],[11,0,12,1],[11,2,11,5],[11,6,11,9],[11,10,12,13],[13,10,13,13],[14,10,14,13],[15,10,15,13],[16,10,16,13],[17,10,17,13],[18,10,18,13],[19,10,19,13],[20,10,20,13],[21,10,21,13],[22,10,22,13],[23,10,23,13],[24,10,24,13],[25,10,25,13],[26,10,26,13],[27,10,27,13]]}
["岡山理科大学附属高等学校",{"$nulls":6},"令和2年",null,null,{"$f":"志願者一覧!K1","v":0},"月",{"$f":"志願者一覧!M1","v":0},"日"]
[null,null,"入学志願者一覧表"]
[]
[{"$nulls":7},"入力担当者"]
[{"$f":"志願者一覧!A5","v":0},null,null,"中学校",{"$nulls":3},{"$f":"志願者一覧!H5","v":0}]
[{"$nulls":11},"印"]
[]
[]
[]
[]
["選抜1期のみ",{"$nulls":9},{"v":2,"d":"2 "},"枚目",{"$f":"IF(COUNTA(志願者一覧!B15:B59)>30,3,IF(COUNTA(志願者一覧!B15:B59)>15,2,1))","v":{"v":1,"d":"1 "}},"枚中"]
["志願者氏名",null,"１日目の第１希望",{"$nulls":3},"2日目の第１希望",{"$nulls":3},"受験料\n（自動計算）",{"$nulls":3},"「印刷プレビュー」で確認後、印刷してください。"]
[null,null,"入試会場","出願するコース","推薦/一般","専願","入試会場","出願するコース","推薦/一般","専願"]
[1,"d","②倉敷","グローバルサイエンス（特進）","推薦(筆記も受ける)","○","②倉敷","グローバルサイエンス（進学）","一般",null,{"$f":"IF(B14=\"\",\"\",(IF(COUNTA(D14,H14)>0,1,0)-IF(COUNTIF(F14:J14,\"○\")=0,0,1))*13000)","v":{"v":0,"d":"0 "}},{"$nulls":3},"修正が必要な場合は、「志願者一覧」のシートで修正後、"]
[2,"e","②倉敷","グローバルサイエンス（特進）","推薦(筆記も受ける)",null,"②倉敷","グローバルサイエンス（進学）","一般","○",{"v":0,"d":"0 "},{"$nulls":3},"再度赤い「印刷確認」ボタンをクリックしてください。"]
[3,"o","②倉敷","グローバルサイエンス（特進）","一般",null,"②倉敷","スポーツサイエンス","一般","○",{"v":0,"d":"0 "}]
[4,"a","②倉敷","グローバルサイエンス（特進）","推薦(筆記も受ける)",null,"②倉敷","スポーツサイエンス","一般",null,{"v":13000,"d":"13,000 "}]
[5,"d","②倉敷","グローバルサイエンス（特進）","一般",null,"②倉敷","スポーツサイエンス","推薦(筆記も受ける)","○",{"v":0,"d":"0 "}]
[6,"h","②倉敷","グローバルサイエンス（特進）","一般",null,"②倉敷","スポーツサイエンス","一般",null,{"v":13000,"d":"13,000 "}]
[7,{"$nulls":9},""]
[8,{"$nulls":9},""]
[9,{"$nulls":9},""]
[10,{"$nulls":9},""]
[11,{"$nulls":9},""]
[12,{"$nulls":9},""]
[13,{"$nulls":9},""]
[14,{"$nulls":9},""]
[15,{"$nulls":9},""]
["※","志願者全員をご記入下さい。"]
["※","この表は選抜１期入試のみ提出下さい。"]

{"sheet":"志願者一覧 (3ページ目)","index":4,"n_rows":30,"n_cols":15,"rows_kept":30,"hidden":true,"merged":[[0,7,0,9],[1,2,2,10],[4,0,5,2],[4,3,5,3],[4,7,5,10],[7,3,7,7],[8,3,8,7],[9,3,9,7],[9,10,9,12],[10,0,10,1],[10,3,10,7],[11,0,12,1],[11,2,11,5],[11,6,11,9],[11,10,12,13],[13,10,13,13],[14,10,14,13],[15,10,15,13],[16,10,16,13],[17,10,17,13],[18,10,18,13],[19,10,19,13],[20,10,20,13],[21,10,21,13],[22,10,22,13],[23,10,23,13],[24,10,24,13],[25,10,25,13],[26,10,26,13],[27,10,27,13]]}
["岡山理科大学附属高等学校",{"$nulls":6},"令和2年",null,null,{"$f":"志願者一覧!K1","v":0},"月",{"$f":"志願者一覧!M1","v":0},"日"]
[null,null,"入学志願者一覧表"]
[]
[{"$nulls":7},"入力担当者"]
[{"$f":"志願者一覧!A5","v":0},null,null,"中学校",{"$nulls":3},{"$f":"志願者一覧!H5","v":0}]
[{"$nulls":11},"印"]
[]
[]
[]
[]
["選抜1期のみ",{"$nulls":9},{"v":3,"d":"3 "},"枚目",{"$f":"IF(COUNTA(志願者一覧!B15:B59)>30,3,IF(COUNTA(志願者一覧!B15:B59)>15,2,1))","v":{"v":1,"d":"1 "}},"枚中"]
["志願者氏名",null,"１日目の第１希望",{"$nulls":3},"2日目の第１希望",{"$nulls":3},"受験料\n（自動計算）",{"$nulls":3},"「印刷プレビュー」で確認後、印刷してください。"]
[null,null,"入試会場","出願するコース","推薦/一般","専願","入試会場","出願するコース","推薦/一般","専願"]
[1,{"$nulls":9},{"$f":"IF(B14=\"\",\"\",(IF(COUNTA(D14,H14)>0,1,0)-IF(COUNTIF(F14:J14,\"○\")=0,0,1))*13000)","v":""},{"$nulls":3},"修正が必要な場合は、「志願者一覧」のシートで修正後、"]
[2,{"$nulls":9},"",{"$nulls":3},"再度赤い「印刷確認」ボタンをクリックしてください。"]
[3,{"$nulls":9},""]
[4,{"$nulls":9},""]
[5,{"$nulls":9},""]
[6,{"$nulls":9},""]
[7,{"$nulls":9},""]
[8,{"$nulls":9},""]
[9,{"$nulls":9},""]
[10,{"$nulls":9},""]
[11,{"$nulls":9},""]
[12,{"$nulls":9},""]
[13,{"$nulls":9},""]
[14,{"$nulls":9},""]
[15,{"$nulls":9},""]
["※","志願者全員をご記入下さい。"]
["※","この表は選抜１期入試のみ提出下さい。"]

{"sheet":"計算用","index":5,"n_rows":47,"n_cols":17,"rows_kept":47,"hidden":true,"merged":[[0,0,1,1],[0,2,0,5],[0,6,0,9]]}
["志願者氏名",null,"１日目の第１希望",{"$nulls":3},"2日目の第１希望"]
[null,null,"入試会場","出願するコース","推薦/一般","専願","入試会場","出願するコース","推薦/一般","専願","①本校国際バカロレア","①本校国際生・帰国生","①本校国際生・帰国生","専願専願","①本校推薦(面接のみ)","①本校推薦(面接のみ)","グローバルサイエンス（特進）国際生・帰国生"]
[1,{"$f":"志願者一覧!B15","v":0},{"$f":"志願者一覧!C15","v":0},{"$f":"志願者一覧!D15","v":0},{"$f":"志願者一覧!E15","v":0},{"$f":"志願者一覧!F15","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G15","v":0},{"$f":"志願者一覧!H15","v":0},{"$f":"志願者一覧!I15","v":0},{"$f":"志願者一覧!J15","v":{"v":0,"d":"0 "}},{"$f":"IF(H3=\"国際バカロレア\",IF(CONCATENATE(G3,H3)=K$2,\"\",3),\"\")","v":""},{"$f":"IF(E3=\"国際生・帰国生\",IF(CONCATENATE(C3,E3)=L$2,\"\",5),\"\")","v":""},{"$f":"IF(I3=\"国際生・帰国生\",IF(CONCATENATE(G3,I3)=M$2,\"\",5),\"\")","v":""},{"$f":"IF(CONCATENATE(F3,J3)=\"○○\",7,\"\")","v":""},{"$f":"IF(E3=\"推薦(面接のみ)\",IF(CONCATENATE(C3,E3)=O$2,\"\",9),\"\")","v":""},{"$f":"IF(I3=\"推薦(面接のみ)\",IF(CONCATENATE(G3,I3)=P$2,\"\",9),\"\")","v":""},{"$f":"IF(D3=\"グローバルサイエンス（特進）\",IF(CONCATENATE(D3,E3)=Q$2,11,\"\"),\"\")","v":""}]
[2,{"$f":"志願者一覧!B16","v":0},{"$f":"志願者一覧!C16","v":0},{"$f":"志願者一覧!D16","v":0},{"$f":"志願者一覧!E16","v":0},{"$f":"志願者一覧!F16","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G16","v":0},{"$f":"志願者一覧!H16","v":0},{"$f":"志願者一覧!I16","v":0},{"$f":"志願者一覧!J16","v":{"v":0,"d":"0 "}},{"$f":"IF(H4=\"国際バカロレア\",IF(CONCATENATE(G4,H4)=K$2,\"\",3),\"\")","v":""},{"$f":"IF(E4=\"国際生・帰国生\",IF(CONCATENATE(C4,E4)=L$2,\"\",5),\"\")","v":""},{"$f":"IF(I4=\"国際生・帰国生\",IF(CONCATENATE(G4,I4)=M$2,\"\",5),\"\")","v":""},{"$f":"IF(CONCATENATE(F4,J4)=\"○○\",7,\"\")","v":""},{"$f":"IF(E4=\"推薦(面接のみ)\",IF(CONCATENATE(C4,E4)=O$2,\"\",9),\"\")","v":""},{"$f":"IF(I4=\"推薦(面接のみ)\",IF(CONCATENATE(G4,I4)=P$2,\"\",9),\"\")","v":""},{"$f":"IF(D4=\"グローバルサイエンス（特進）\",IF(CONCATENATE(D4,E4)=Q$2,11,\"\"),\"\")","v":""}]
[3,{"$f":"志願者一覧!B17","v":0},{"$f":"志願者一覧!C17","v":0},{"$f":"志願者一覧!D17","v":0},{"$f":"志願者一覧!E17","v":0},{"$f":"志願者一覧!F17","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G17","v":0},{"$f":"志願者一覧!H17","v":0},{"$f":"志願者一覧!I17","v":0},{"$f":"志願者一覧!J17","v":{"v":0,"d":"0 "}},"","","",{"$f":"IF(CONCATENATE(F5,J5)=\"○○\",7,\"\")","v":""},{"$f":"IF(E5=\"推薦(面接のみ)\",IF(CONCATENATE(C5,E5)=O$2,\"\",9),\"\")","v":""},{"$f":"IF(I5=\"推薦(面接のみ)\",IF(CONCATENATE(G5,I5)=P$2,\"\",9),\"\")","v":""},{"$f":"IF(D5=\"グローバルサイエンス（特進）\",IF(CONCATENATE(D5,E5)=Q$2,11,\"\"),\"\")","v":""}]
[4,{"$f":"志願者一覧!B18","v":0},{"$f":"志願者一覧!C18","v":0},{"$f":"志願者一覧!D18","v":0},{"$f":"志願者一覧!E18","v":0},{"$f":"志願者一覧!F18","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G18","v":0},{"$f":"志願者一覧!H18","v":0},{"$f":"志願者一覧!I18","v":0},{"$f":"志願者一覧!J18","v":{"v":0,"d":"0 "}},"","","","","",{"$f":"IF(I6=\"推薦(面接のみ)\",IF(CONCATENATE(G6,I6)=P$2,\"\",9),\"\")","v":""},""]
[5,{"$f":"志願者一覧!B19","v":0},{"$f":"志願者一覧!C19","v":0},{"$f":"志願者一覧!D19","v":0},{"$f":"志願者一覧!E19","v":0},{"$f":"志願者一覧!F19","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G19","v":0},{"$f":"志願者一覧!H19","v":0},{"$f":"志願者一覧!I19","v":0},{"$f":"志願者一覧!J19","v":{"v":0,"d":"0 "}},"","","","","","",""]
[6,{"$f":"志願者一覧!B20","v":0},{"$f":"志願者一覧!C20","v":0},{"$f":"志願者一覧!D20","v":0},{"$f":"志願者一覧!E20","v":0},{"$f":"志願者一覧!F20","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G20","v":0},{"$f":"志願者一覧!H20","v":0},{"$f":"志願者一覧!I20","v":0},{"$f":"志願者一覧!J20","v":{"v":0,"d":"0 "}},"","","","",{"$f":"IF(E8=\"推薦(面接のみ)\",IF(CONCATENATE(C8,E8)=O$2,\"\",9),\"\")","v":""},"",""]
[7,{"$f":"志願者一覧!B21","v":0},{"$f":"志願者一覧!C21","v":0},{"$f":"志願者一覧!D21","v":0},{"$f":"志願者一覧!E21","v":0},{"$f":"志願者一覧!F21","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G21","v":0},{"$f":"志願者一覧!H21","v":0},{"$f":"志願者一覧!I21","v":0},{"$f":"志願者一覧!J21","v":{"v":0,"d":"0 "}},"","","","","","",""]
[8,{"$f":"志願者一覧!B22","v":0},{"$f":"志願者一覧!C22","v":0},{"$f":"志願者一覧!D22","v":0},{"$f":"志願者一覧!E22","v":0},{"$f":"志願者一覧!F22","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G22","v":0},{"$f":"志願者一覧!H22","v":0},{"$f":"志願者一覧!I22","v":0},{"$f":"志願者一覧!J22","v":{"v":0,"d":"0 "}},"","","","","","",""]
[9,{"$f":"志願者一覧!B23","v":0},{"$f":"志願者一覧!C23","v":0},{"$f":"志願者一覧!D23","v":0},{"$f":"志願者一覧!E23","v":0},{"$f":"志願者一覧!F23","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G23","v":0},{"$f":"志願者一覧!H23","v":0},{"$f":"志願者一覧!I23","v":0},{"$f":"志願者一覧!J23","v":{"v":0,"d":"0 "}},"","","","","","",""]
[10,{"$f":"志願者一覧!B24","v":0},{"$f":"志願者一覧!C24","v":0},{"$f":"志願者一覧!D24","v":0},{"$f":"志願者一覧!E24","v":0},{"$f":"志願者一覧!F24","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G24","v":0},{"$f":"志願者一覧!H24","v":0},{"$f":"志願者一覧!I24","v":0},{"$f":"志願者一覧!J24","v":{"v":0,"d":"0 "}},"","","","","","",""]
[11,{"$f":"志願者一覧!B25","v":0},{"$f":"志願者一覧!C25","v":0},{"$f":"志願者一覧!D25","v":0},{"$f":"志願者一覧!E25","v":0},{"$f":"志願者一覧!F25","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G25","v":0},{"$f":"志願者一覧!H25","v":0},{"$f":"志願者一覧!I25","v":0},{"$f":"志願者一覧!J25","v":{"v":0,"d":"0 "}},"","","","","","",""]
[12,{"$f":"志願者一覧!B26","v":0},{"$f":"志願者一覧!C26","v":0},{"$f":"志願者一覧!D26","v":0},{"$f":"志願者一覧!E26","v":0},{"$f":"志願者一覧!F26","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G26","v":0},{"$f":"志願者一覧!H26","v":0},{"$f":"志願者一覧!I26","v":0},{"$f":"志願者一覧!J26","v":{"v":0,"d":"0 "}},"","","","","","",""]
[13,{"$f":"志願者一覧!B27","v":0},{"$f":"志願者一覧!C27","v":0},{"$f":"志願者一覧!D27","v":0},{"$f":"志願者一覧!E27","v":0},{"$f":"志願者一覧!F27","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G27","v":0},{"$f":"志願者一覧!H27","v":0},{"$f":"志願者一覧!I27","v":0},{"$f":"志願者一覧!J27","v":{"v":0,"d":"0 "}},"","","","","","",""]
[14,{"$f":"志願者一覧!B28","v":0},{"$f":"志願者一覧!C28","v":0},{"$f":"志願者一覧!D28","v":0},{"$f":"志願者一覧!E28","v":0},{"$f":"志願者一覧!F28","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G28","v":0},{"$f":"志願者一覧!H28","v":0},{"$f":"志願者一覧!I28","v":0},{"$f":"志願者一覧!J28","v":{"v":0,"d":"0 "}},"","","","","","",""]
[15,{"$f":"志願者一覧!B29","v":0},{"$f":"志願者一覧!C29","v":0},{"$f":"志願者一覧!D29","v":0},{"$f":"志願者一覧!E29","v":0},{"$f":"志願者一覧!F29","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G29","v":0},{"$f":"志願者一覧!H29","v":0},{"$f":"志願者一覧!I29","v":0},{"$f":"志願者一覧!J29","v":{"v":0,"d":"0 "}},"","","","","","",""]
[16,{"$f":"志願者一覧!B30","v":0},{"$f":"志願者一覧!C30","v":0},{"$f":"志願者一覧!D30","v":0},{"$f":"志願者一覧!E30","v":0},{"$f":"志願者一覧!F30","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G30","v":0},{"$f":"志願者一覧!H30","v":0},{"$f":"志願者一覧!I30","v":0},{"$f":"志願者一覧!J30","v":{"v":0,"d":"0 "}},"","","","","","",""]
[17,{"$f":"志願者一覧!B31","v":0},{"$f":"志願者一覧!C31","v":0},{"$f":"志願者一覧!D31","v":0},{"$f":"志願者一覧!E31","v":0},{"$f":"志願者一覧!F31","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G31","v":0},{"$f":"志願者一覧!H31","v":0},{"$f":"志願者一覧!I31","v":0},{"$f":"志願者一覧!J31","v":{"v":0,"d":"0 "}},"","","","","","",""]
[18,{"$f":"志願者一覧!B32","v":0},{"$f":"志願者一覧!C32","v":0},{"$f":"志願者一覧!D32","v":0},{"$f":"志願者一覧!E32","v":0},{"$f":"志願者一覧!F32","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G32","v":0},{"$f":"志願者一覧!H32","v":0},{"$f":"志願者一覧!I32","v":0},{"$f":"志願者一覧!J32","v":{"v":0,"d":"0 "}},"","","","","","",""]
[19,{"$f":"志願者一覧!B33","v":0},{"$f":"志願者一覧!C33","v":0},{"$f":"志願者一覧!D33","v":0},{"$f":"志願者一覧!E33","v":0},{"$f":"志願者一覧!F33","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G33","v":0},{"$f":"志願者一覧!H33","v":0},{"$f":"志願者一覧!I33","v":0},{"$f":"志願者一覧!J33","v":{"v":0,"d":"0 "}},"","","","","","",""]
[20,{"$f":"志願者一覧!B34","v":0},{"$f":"志願者一覧!C34","v":0},{"$f":"志願者一覧!D34","v":0},{"$f":"志願者一覧!E34","v":0},{"$f":"志願者一覧!F34","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G34","v":0},{"$f":"志願者一覧!H34","v":0},{"$f":"志願者一覧!I34","v":0},{"$f":"志願者一覧!J34","v":{"v":0,"d":"0 "}},"","","","","","",""]
[21,{"$f":"志願者一覧!B35","v":0},{"$f":"志願者一覧!C35","v":0},{"$f":"志願者一覧!D35","v":0},{"$f":"志願者一覧!E35","v":0},{"$f":"志願者一覧!F35","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G35","v":0},{"$f":"志願者一覧!H35","v":0},{"$f":"志願者一覧!I35","v":0},{"$f":"志願者一覧!J35","v":{"v":0,"d":"0 "}},"","","","","","",""]
[22,{"$f":"志願者一覧!B36","v":0},{"$f":"志願者一覧!C36","v":0},{"$f":"志願者一覧!D36","v":0},{"$f":"志願者一覧!E36","v":0},{"$f":"志願者一覧!F36","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G36","v":0},{"$f":"志願者一覧!H36","v":0},{"$f":"志願者一覧!I36","v":0},{"$f":"志願者一覧!J36","v":{"v":0,"d":"0 "}},"","","","","","",""]
[23,{"$f":"志願者一覧!B37","v":0},{"$f":"志願者一覧!C37","v":0},{"$f":"志願者一覧!D37","v":0},{"$f":"志願者一覧!E37","v":0},{"$f":"志願者一覧!F37","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G37","v":0},{"$f":"志願者一覧!H37","v":0},{"$f":"志願者一覧!I37","v":0},{"$f":"志願者一覧!J37","v":{"v":0,"d":"0 "}},"","","","","","",""]
[24,{"$f":"志願者一覧!B38","v":0},{"$f":"志願者一覧!C38","v":0},{"$f":"志願者一覧!D38","v":0},{"$f":"志願者一覧!E38","v":0},{"$f":"志願者一覧!F38","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G38","v":0},{"$f":"志願者一覧!H38","v":0},{"$f":"志願者一覧!I38","v":0},{"$f":"志願者一覧!J38","v":{"v":0,"d":"0 "}},"","","","","","",""]
[25,{"$f":"志願者一覧!B39","v":0},{"$f":"志願者一覧!C39","v":0},{"$f":"志願者一覧!D39","v":0},{"$f":"志願者一覧!E39","v":0},{"$f":"志願者一覧!F39","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G39","v":0},{"$f":"志願者一覧!H39","v":0},{"$f":"志願者一覧!I39","v":0},{"$f":"志願者一覧!J39","v":{"v":0,"d":"0 "}},"","","","","","",""]
[26,{"$f":"志願者一覧!B40","v":0},{"$f":"志願者一覧!C40","v":0},{"$f":"志願者一覧!D40","v":0},{"$f":"志願者一覧!E40","v":0},{"$f":"志願者一覧!F40","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G40","v":0},{"$f":"志願者一覧!H40","v":0},{"$f":"志願者一覧!I40","v":0},{"$f":"志願者一覧!J40","v":{"v":0,"d":"0 "}},"","","","","","",""]
[27,{"$f":"志願者一覧!B41","v":0},{"$f":"志願者一覧!C41","v":0},{"$f":"志願者一覧!D41","v":0},{"$f":"志願者一覧!E41","v":0},{"$f":"志願者一覧!F41","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G41","v":0},{"$f":"志願者一覧!H41","v":0},{"$f":"志願者一覧!I41","v":0},{"$f":"志願者一覧!J41","v":{"v":0,"d":"0 "}},"","","","","","",""]
[28,{"$f":"志願者一覧!B42","v":0},{"$f":"志願者一覧!C42","v":0},{"$f":"志願者一覧!D42","v":0},{"$f":"志願者一覧!E42","v":0},{"$f":"志願者一覧!F42","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G42","v":0},{"$f":"志願者一覧!H42","v":0},{"$f":"志願者一覧!I42","v":0},{"$f":"志願者一覧!J42","v":{"v":0,"d":"0 "}},"","","","","","",""]
[29,{"$f":"志願者一覧!B43","v":0},{"$f":"志願者一覧!C43","v":0},{"$f":"志願者一覧!D43","v":0},{"$f":"志願者一覧!E43","v":0},{"$f":"志願者一覧!F43","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G43","v":0},{"$f":"志願者一覧!H43","v":0},{"$f":"志願者一覧!I43","v":0},{"$f":"志願者一覧!J43","v":{"v":0,"d":"0 "}},{"$f":"IF(H31=\"国際バカロレア\",IF(CONCATENATE(G31,H31)=K$2,\"\",3),\"\")","v":""},"","",{"$f":"IF(CONCATENATE(F31,J31)=\"○○\",7,\"\")","v":""},"","",""]
[30,{"$f":"志願者一覧!B44","v":0},{"$f":"志願者一覧!C44","v":0},{"$f":"志願者一覧!D44","v":0},{"$f":"志願者一覧!E44","v":0},{"$f":"志願者一覧!F44","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G44","v":0},{"$f":"志願者一覧!H44","v":0},{"$f":"志願者一覧!I44","v":0},{"$f":"志願者一覧!J44","v":{"v":0,"d":"0 "}},"","","","","","",""]
[31,{"$f":"志願者一覧!B45","v":0},{"$f":"志願者一覧!C45","v":0},{"$f":"志願者一覧!D45","v":0},{"$f":"志願者一覧!E45","v":0},{"$f":"志願者一覧!F45","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G45","v":0},{"$f":"志願者一覧!H45","v":0},{"$f":"志願者一覧!I45","v":0},{"$f":"志願者一覧!J45","v":{"v":0,"d":"0 "}},"",{"$f":"IF(E33=\"国際生・帰国生\",IF(CONCATENATE(C33,E33)=L$2,\"\",5),\"\")","v":""},{"$f":"IF(I33=\"国際生・帰国生\",IF(CONCATENATE(G33,I33)=M$2,\"\",5),\"\")","v":""},"",{"$f":"IF(E33=\"推薦(面接のみ)\",IF(CONCATENATE(C33,E33)=O$2,\"\",9),\"\")","v":""},{"$f":"IF(I33=\"推薦(面接のみ)\",IF(CONCATENATE(G33,I33)=P$2,\"\",9),\"\")","v":""},{"$f":"IF(D33=\"グローバルサイエンス（特進）\",IF(CONCATENATE(D33,E33)=Q$2,11,\"\"),\"\")","v":""}]
[32,{"$f":"志願者一覧!B46","v":0},{"$f":"志願者一覧!C46","v":0},{"$f":"志願者一覧!D46","v":0},{"$f":"志願者一覧!E46","v":0},{"$f":"志願者一覧!F46","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G46","v":0},{"$f":"志願者一覧!H46","v":0},{"$f":"志願者一覧!I46","v":0},{"$f":"志願者一覧!J46","v":{"v":0,"d":"0 "}},"","","","","","",""]
[33,{"$f":"志願者一覧!B47","v":0},{"$f":"志願者一覧!C47","v":0},{"$f":"志願者一覧!D47","v":0},{"$f":"志願者一覧!E47","v":0},{"$f":"志願者一覧!F47","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G47","v":0},{"$f":"志願者一覧!H47","v":0},{"$f":"志願者一覧!I47","v":0},{"$f":"志願者一覧!J47","v":{"v":0,"d":"0 "}},"","","","","","",""]
[34,{"$f":"志願者一覧!B48","v":0},{"$f":"志願者一覧!C48","v":0},{"$f":"志願者一覧!D48","v":0},{"$f":"志願者一覧!E48","v":0},{"$f":"志願者一覧!F48","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G48","v":0},{"$f":"志願者一覧!H48","v":0},{"$f":"志願者一覧!I48","v":0},{"$f":"志願者一覧!J48","v":{"v":0,"d":"0 "}},"","","","","","",""]
[35,{"$f":"志願者一覧!B49","v":0},{"$f":"志願者一覧!C49","v":0},{"$f":"志願者一覧!D49","v":0},{"$f":"志願者一覧!E49","v":0},{"$f":"志願者一覧!F49","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G49","v":0},{"$f":"志願者一覧!H49","v":0},{"$f":"志願者一覧!I49","v":0},{"$f":"志願者一覧!J49","v":{"v":0,"d":"0 "}},"","","","","","",""]
[36,{"$f":"志願者一覧!B50","v":0},{"$f":"志願者一覧!C50","v":0},{"$f":"志願者一覧!D50","v":0},{"$f":"志願者一覧!E50","v":0},{"$f":"志願者一覧!F50","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G50","v":0},{"$f":"志願者一覧!H50","v":0},{"$f":"志願者一覧!I50","v":0},{"$f":"志願者一覧!J50","v":{"v":0,"d":"0 "}},"","","","","","",""]
[37,{"$f":"志願者一覧!B51","v":0},{"$f":"志願者一覧!C51","v":0},{"$f":"志願者一覧!D51","v":0},{"$f":"志願者一覧!E51","v":0},{"$f":"志願者一覧!F51","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G51","v":0},{"$f":"志願者一覧!H51","v":0},{"$f":"志願者一覧!I51","v":0},{"$f":"志願者一覧!J51","v":{"v":0,"d":"0 "}},"","","","","","",""]
[38,{"$f":"志願者一覧!B52","v":0},{"$f":"志願者一覧!C52","v":0},{"$f":"志願者一覧!D52","v":0},{"$f":"志願者一覧!E52","v":0},{"$f":"志願者一覧!F52","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G52","v":0},{"$f":"志願者一覧!H52","v":0},{"$f":"志願者一覧!I52","v":0},{"$f":"志願者一覧!J52","v":{"v":0,"d":"0 "}},"","","","","","",""]
[39,{"$f":"志願者一覧!B53","v":0},{"$f":"志願者一覧!C53","v":0},{"$f":"志願者一覧!D53","v":0},{"$f":"志願者一覧!E53","v":0},{"$f":"志願者一覧!F53","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G53","v":0},{"$f":"志願者一覧!H53","v":0},{"$f":"志願者一覧!I53","v":0},{"$f":"志願者一覧!J53","v":{"v":0,"d":"0 "}},{"$f":"IF(H41=\"国際バカロレア\",IF(CONCATENATE(G41,H41)=K$2,\"\",3),\"\")","v":""},"","",{"$f":"IF(CONCATENATE(F41,J41)=\"○○\",7,\"\")","v":""},"","",""]
[40,{"$f":"志願者一覧!B54","v":0},{"$f":"志願者一覧!C54","v":0},{"$f":"志願者一覧!D54","v":0},{"$f":"志願者一覧!E54","v":0},{"$f":"志願者一覧!F54","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G54","v":0},{"$f":"志願者一覧!H54","v":0},{"$f":"志願者一覧!I54","v":0},{"$f":"志願者一覧!J54","v":{"v":0,"d":"0 "}},"","","","","","",""]
[41,{"$f":"志願者一覧!B55","v":0},{"$f":"志願者一覧!C55","v":0},{"$f":"志願者一覧!D55","v":0},{"$f":"志願者一覧!E55","v":0},{"$f":"志願者一覧!F55","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G55","v":0},{"$f":"志願者一覧!H55","v":0},{"$f":"志願者一覧!I55","v":0},{"$f":"志願者一覧!J55","v":{"v":0,"d":"0 "}},"",{"$f":"IF(E43=\"国際生・帰国生\",IF(CONCATENATE(C43,E43)=L$2,\"\",5),\"\")","v":""},{"$f":"IF(I43=\"国際生・帰国生\",IF(CONCATENATE(G43,I43)=M$2,\"\",5),\"\")","v":""},"",{"$f":"IF(E43=\"推薦(面接のみ)\",IF(CONCATENATE(C43,E43)=O$2,\"\",9),\"\")","v":""},{"$f":"IF(I43=\"推薦(面接のみ)\",IF(CONCATENATE(G43,I43)=P$2,\"\",9),\"\")","v":""},{"$f":"IF(D43=\"グローバルサイエンス（特進）\",IF(CONCATENATE(D43,E43)=Q$2,11,\"\"),\"\")","v":""}]
[42,{"$f":"志願者一覧!B56","v":0},{"$f":"志願者一覧!C56","v":0},{"$f":"志願者一覧!D56","v":0},{"$f":"志願者一覧!E56","v":0},{"$f":"志願者一覧!F56","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G56","v":0},{"$f":"志願者一覧!H56","v":0},{"$f":"志願者一覧!I56","v":0},{"$f":"志願者一覧!J56","v":{"v":0,"d":"0 "}},"","","","","","",""]
[43,{"$f":"志願者一覧!B57","v":0},{"$f":"志願者一覧!C57","v":0},{"$f":"志願者一覧!D57","v":0},{"$f":"志願者一覧!E57","v":0},{"$f":"志願者一覧!F57","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G57","v":0},{"$f":"志願者一覧!H57","v":0},{"$f":"志願者一覧!I57","v":0},{"$f":"志願者一覧!J57","v":{"v":0,"d":"0 "}},{"$f":"IF(H45=\"国際バカロレア\",IF(CONCATENATE(G45,H45)=K$2,\"\",3),\"\")","v":""},"","",{"$f":"IF(CONCATENATE(F45,J45)=\"○○\",7,\"\")","v":""},"","",""]
[44,{"$f":"志願者一覧!B58","v":0},{"$f":"志願者一覧!C58","v":0},{"$f":"志願者一覧!D58","v":0},{"$f":"志願者一覧!E58","v":0},{"$f":"志願者一覧!F58","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G58","v":0},{"$f":"志願者一覧!H58","v":0},{"$f":"志願者一覧!I58","v":0},{"$f":"志願者一覧!J58","v":{"v":0,"d":"0 "}},"","","","","","",""]
[45,{"$f":"志願者一覧!B59","v":0},{"$f":"志願者一覧!C59","v":0},{"$f":"志願者一覧!D59","v":0},{"$f":"志願者一覧!E59","v":0},{"$f":"志願者一覧!F59","v":{"v":0,"d":"0 "}},{"$f":"志願者一覧!G59","v":0},{"$f":"志願者一覧!H59","v":0},{"$f":"志願者一覧!I59","v":0},{"$f":"志願者一覧!J59","v":{"v":0,"d":"0 "}},"","","","","","",""]

{"sheet":"ソート","index":6,"n_rows":22,"n_cols":9,"rows_kept":22,"hidden":true}
["志願者名","第1-会場","第1-コース","第1-推一","第1-専願","第2-会場","第2-コース","第2-推一","第2-専願"]
["l","①本校","グローバルサイエンス（特進）","推薦(筆記も受ける)",null,"①本校","グローバルサイエンス（進学）","一般","○"]
["h","①本校","グローバルサイエンス（特進）","推薦(筆記も受ける)",null,"②倉敷","グローバルサイエンス（進学）","一般"]
["j","①本校","グローバルサイエンス（特進）","推薦(筆記も受ける)",null,"②倉敷","グローバルサイエンス（進学）","推薦(筆記も受ける)"]
["h","①本校","総合進学","一般",null,"①本校","グローバルサイエンス（進学）","一般"]
["e","①本校","総合進学","推薦(筆記も受ける)",null,"①本校","グローバルサイエンス（進学）","一般"]
["s","①本校","総合進学","推薦(筆記も受ける)","○","①本校","スポーツサイエンス","推薦(面接のみ)"]
["uy","①本校","総合進学","推薦(面接のみ)","○","②倉敷","グローバルサイエンス（進学）","推薦(筆記も受ける)"]
["a","①本校","総合進学","国際生・帰国生"]
["d","②倉敷","グローバルサイエンス（特進）","一般",null,"①本校","グローバルサイエンス（進学）","一般"]
["u","②倉敷","グローバルサイエンス（特進）","推薦(筆記も受ける)","○","①本校","グローバルサイエンス（進学）","推薦(筆記も受ける)"]
["d","②倉敷","グローバルサイエンス（特進）","一般","○","①本校","スポーツサイエンス","一般"]
["h","②倉敷","グローバルサイエンス（特進）","一般",null,"①本校","スポーツサイエンス","推薦(面接のみ)"]
["g","②倉敷","グローバルサイエンス（特進）","一般",null,"①本校","スポーツサイエンス","一般"]
["r","②倉敷","グローバルサイエンス（特進）","一般","○","①本校","スポーツサイエンス","一般"]
["k","②倉敷","グローバルサイエンス（特進）","一般",null,"①本校","スポーツサイエンス","推薦(筆記も受ける)"]
["d","②倉敷","グローバルサイエンス（特進）","推薦(筆記も受ける)","○","②倉敷","グローバルサイエンス（進学）","一般"]
["e","②倉敷","グローバルサイエンス（特進）","推薦(筆記も受ける)",null,"②倉敷","グローバルサイエンス（進学）","一般","○"]
["o","②倉敷","グローバルサイエンス（特進）","一般",null,"②倉敷","スポーツサイエンス","一般","○"]
["a","②倉敷","グローバルサイエンス（特進）","推薦(筆記も受ける)",null,"②倉敷","スポーツサイエンス","一般"]
["d","②倉敷","グローバルサイエンス（特進）","一般",null,"②倉敷","スポーツサイエンス","推薦(筆記も受ける)","○"]
["h","②倉敷","グローバルサイエンス（特進）","一般",null,"②倉敷","スポーツサイエンス","一般"]