{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["予約申込","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":false,"merged":[[42,1,42,2],[42,3,42,4],[32,4,32,11],[31,1,31,3],[37,1,37,2],[34,5,34,11],[34,1,34,2],[35,1,35,2],[37,3,37,4],[36,1,36,2],[41,5,41,11],[41,1,41,2],[41,3,41,4],[38,5,38,11],[39,5,39,11],[39,1,39,2],[20,6,20,9],[26,4,26,11],[29,4,29,11],[27,1,27,3],[27,4,27,11],[20,10,20,11],[15,10,15,11],[12,9,12,10],[13,9,13,10],[13,4,13,5],[16,6,16,9],[15,6,15,9],[12,6,12,8],[13,6,13,8],[16,10,16,11],[12,0,13,1],[15,0,20,0],[19,3,19,5],[20,3,20,5],[17,3,17,5],[16,3,16,5],[18,3,18,5],[12,4,12,5],[10,0,10,1],[11,2,11,10],[9,3,9,10],[8,3,8,10],[8,0,9,1],[10,2,10,10],[11,0,11,1],[1,0,1,11],[5,3,5,5],[5,6,5,10],[4,0,4,1],[3,0,3,1],[2,2,2,4],[2,5,2,10],[3,2,3,4],[3,5,3,10],[2,0,2,1],[5,0,7,1],[7,3,7,10],[6,3,6,10],[19,10,19,11],[18,10,18,11],[17,10,17,11],[36,3,36,4],[35,3,35,4],[34,3,34,4],[36,5,36,11],[18,6,18,9],[19,6,19,9],[17,6,17,9],[32,1,32,3],[31,4,31,11],[30,4,30,11],[30,1,30,3],[29,1,29,3],[21,0,21,3],[39,3,39,4],[38,1,38,2],[38,3,38,4],[40,1,40,2],[40,3,40,4]]}
["2020年度　教員免許状更新講習　予約申込フォーム"]
["※全て左寄せでご記入ください。（最初にスペース等は入れない）\n※説明文・記入例・吹き出し等は削除せず送信していただいて結構です。"]
["フリガナ"]
["氏　名"]
["性　別",null,"男","生年月日","昭和",null,"年",null,"月",null,"日"]
["連絡先",null,"郵便番号"]
[null,null,"住　所　１",null,null,null,null,null,null,null,null,"岡山県津山市北園町50"]
[null,null,"住　所　２",null,null,null,null,null,null,null,null,"美作大学マンション101"]
["電話番号",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,"(記入例)津山市立○○小学校　／　私立△△幼稚園　／　講師登録中など"]
["職　種\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,"※文部科学省HPにてご確認ください。"]
["●受講希望講習(希望欄に○を入れてください)"]
["<必修領域>"]
["希望","担当講師",null,null,"講 習 名",null,null,null,null,null,null,null,"開 講 日"]
[null,"中野 和光 ・ 藤根 雅之\n妻藤 真彦 ・ 渡邉 淳一",null,null,"【必修】教育の最新事情",null,null,null,null,null,null,null,"8月21日(金)"]
["<選択必修領域>",null,null,null,{"$f":"IF(AZ33>=2,BA29,\"\")","v":""}]
["希望","担当講師",null,null,"講  習  名",null,null,null,null,null,null,null,"開  講  日"]
[null,"中野 和光",null,null,"【選択必修Ａ】\n学習指導要領の改訂の動向、法令改正及び国の審議会の状況",null,null,null,null,null,null,null,"8月19日(水)",null,null,null,null,null,null,null,{"$f":"IF(A32=\"○\",\"×\",\"\")&IF(A33=\"○\",\"×\",\"\")","v":""}]
[null,"佐々木 勇",null,null,"【選択必修Ｂ】\n学校における危機管理などに対する組織的対応",null,null,null,null,null,null,null,"8月19日(水)",null,null,null,null,null,null,null,{"$f":"IF(A31=\"○\",\"×\",\"\")&IF(A33=\"○\",\"×\",\"\")","v":""}]
[null,"渡邉 淳一",null,null,"【選択必修Ｄ】\n教育相談(アンガーマネジメント・カウンセリングマインド)",null,null,null,null,null,null,null,"8月19日(水)",null,null,null,null,null,null,null,{"$f":"IF(A31=\"○\",\"×\",\"\")&IF(A32=\"○\",\"×\",\"\")","v":""}]
["<選択領域>",null,null,null,{"$f":"IF(AX40=2,AX35,IF(OR(AZ37>=2,AZ40>=2,AZ42>=2),BA29,\"\"))","v":""}]
["希望","担当講師",null,"開  講  日",null,"講  習  名",null,null,null,null,null,null,"主な対象者"]
[null,"納庄 康晴※1",null,"8月18日(火)",null,"食品の美味しさを科学する（※2と同時申込み不可）",null,null,null,null,null,null,"教諭・養護教諭・栄養教諭",null,null,null,null,null,null,null,{"$f":"IF(OR(A41=\"○\",A37=\"○\",A38=\"○\"),\"×\",\"\")","v":""}]
[null,"中田 稔※3",null,"8月18日(火)",null,"遊びの楽しさをもとにした造形活動（※4と同時申込み不可)",null,null,null,null,null,null,"幼稚園教諭",null,null,null,null,null,null,null,{"$f":"IF(OR(A42=\"○\",A36=\"○\",A38=\"○\"),\"×\",\"\")","v":""}]
[null,"桐生 和幸",null,"8月18日(火)",null,"日本語との違いから学ぶ英語",null,null,null,null,null,null,"幼小教諭、中高国語科・英語科教諭",null,null,null,null,null,null,null,{"$f":"IF(OR(A36=\"○\",A37=\"○\"),\"×\",\"\")","v":""}]
[null,"安田 純",null,"8月20日(木)",null,"発達障害の理解と支援",null,null,null,null,null,null,"全教諭、養護教諭",null,null,null,null,null,null,null,{"$f":"IF(A40=\"○\",\"×\",\"\")","v":""}]
[null,"森本 恭子",null,"8月20日(木)",null,"給食献立を教材とした食に関する指導",null,null,null,null,null,null,"教諭・養護教諭・栄養教諭",null,null,null,null,null,null,null,{"$f":"IF(A39=\"○\",\"×\",\"\")","v":""}]
[null,"納庄 康晴※2",null,"8月24日(月)",null,"食品の美味しさを科学する（※1と同時申込み不可）",null,null,null,null,null,null,"教諭・養護教諭・栄養教諭",null,null,null,null,null,null,null,{"$f":"IF(OR(A36=\"○\",A42=\"○\",A43=\"○\"),\"×\",\"\")","v":""}]
[null,"中田 稔※4",null,"8月24日(月)",null,"遊びの楽しさをもとにした造形活動（※3と同時申込み不可)",null,null,null,null,null,null,"幼稚園教諭",null,null,null,null,null,null,null,{"$f":"IF(OR(A37=\"○\",A41=\"○\",A43=\"○\"),\"×\",\"\")","v":""}]
[null,"土海 一美",null,"8月24日(月)",null,"食育の理論とその応用",null,null,null,null,null,null,"養護教諭、栄養教諭",null,null,null,null,null,null,null,{"$f":"IF(OR(A41=\"○\",A42=\"○\"),\"×\",\"\")","v":""}]
[null,"※1と2、※3と4は同じ内容です"]

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

{"sheet":"Sheet2","index":2,"n_rows":7,"n_cols":64,"rows_kept":7,"cut":false,"hidden":true,"merged":[[2,9,5,9],[2,10,5,10],[2,11,5,11],[2,4,5,4],[2,6,5,6],[2,8,5,8],[2,45,3,49],[2,62,5,62],[2,63,5,63],[2,12,3,17],[2,18,5,18],[2,19,5,19],[2,20,5,20],[2,25,3,29],[2,30,3,34],[2,35,3,39],[2,21,5,21],[2,22,5,22],[2,23,5,23],[2,40,3,44],[2,24,5,24],[2,0,5,0],[2,2,5,2],[2,3,5,3],[2,5,5,5],[2,7,5,7]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,null,"○"]
["No.",null,"受講番号","姓","名","ふりがな姓","ふりがな名","性別","生年月日_年号","生年月日_年","生年月日_月","生年月日_日","連　　絡　　先",null,null,null,null,null,"現在勤務校（園）","職　種","修了確認期限_年号","修了確認期限_年","修了確認期限_月","修了確認期限_日","有効期間延長","免許状①",null,null,null,null,"免許状②",null,null,null,null,"免許状③",null,null,null,null,"免許状④",null,null,null,null,"免許状⑤",null,null,null,null,"希　望　講　習",null,null,null,null,null,null,null,null,null,null,null,"希望講座数","受講料"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"必修","選択必修","選択必修","選択必修","選択","選択","選択","選択","選択","選択","選択","選択"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","造形3","日本語","発達障害","献立指導","食品2","造形4","食育"]
[null,null,null,null,null,null,null,null,null,null,null,null,"郵便番号","住所１","住所２","自宅電話","携帯電話","E-mail",null,null,null,null,null,null,null,"校種","種類","教科","免許状番号","授与年月",{"$f":"Z6","v":"校種"},"種類","教科","免許状番号","授与年月","校種","種類","教科","免許状番号","授与年月","校種","種類","教科","免許状番号","授与年月","校種","種類","教科","免許状番号","授与年月","中野・藤根・妻藤・渡邉","中野","佐々木","渡邉","納庄1","中田3","桐生","安田","森本","納庄2","中田4","土海"]
[null,null,null,{"$f":"TRIM(予約申込!C4)","v":""},{"$f":"TRIM(予約申込!F4)","v":""},{"$f":"TRIM(予約申込!C3)","v":""},{"$f":"TRIM(予約申込!F3)","v":""},{"$f":"TRIM(予約申込!C5)","v":"男"},{"$f":"TRIM(予約申込!E5)","v":"昭和"},{"$f":"TRIM(予約申込!F5)","v":""},{"$f":"TRIM(予約申込!H5)","v":""},{"$f":"TRIM(予約申込!J5)","v":""},{"$f":"TRIM(予約申込!D6)","v":""},{"$f":"TRIM(予約申込!D7)","v":""},{"$f":"IF(予約申込!D8=\"\",\"\",TRIM(予約申込!D8))","v":""},{"$f":"IF(予約申込!D9=\"\",\"\",TRIM(ASC(予約申込!D9)))","v":"- -"},{"$f":"IF(予約申込!D10=\"\",\"\",TRIM(ASC(予約申込!D10)))","v":"- -"},{"$f":"IF(予約申込!C11=\"\",\"\",TRIM(ASC(予約申込!C11)))","v":""},{"$f":"IF(予約申込!C12=\"\",\"\",予約申込!C12)","v":""},{"$f":"(IF(予約申込!C14=\"○\",予約申込!C13,\"\"))&(IF(予約申込!D14=\"○\",予約申込!D13,\"\"))&(IF(予約申込!E14=\"○\",予約申込!E13,\"\"))&(IF(予約申込!G14=\"○\",予約申込!G13,\"\"))","v":""},{"$f":"TRIM(予約申込!E22)","v":"平成"},{"$f":"TRIM(予約申込!F22)","v":""},{"$f":"TRIM(予約申込!H22)","v":""},{"$f":"TRIM(予約申込!J22)","v":""},{"$f":"IF(予約申込!E23=\"\",\"\",予約申込!E23)","v":""},{"$f":"IF(予約申込!C17=\"\",\"\",予約申込!C17)","v":""},{"$f":"IF(予約申込!D17=\"\",\"\",予約申込!D17)","v":""},{"$f":"IF(予約申込!G17=\"\",\"\",予約申込!G17)","v":""},{"$f":"IF(予約申込!K17=\"\",\"\",予約申込!K17)","v":""},{"$f":"IF(予約申込!M17=\"\",\"\",予約申込!M17)","v":""},{"$f":"IF(予約申込!C18=\"\",\"\",予約申込!C18)","v":""},{"$f":"IF(予約申込!D18=\"\",\"\",予約申込!D18)","v":""},{"$f":"IF(予約申込!G18=\"\",\"\",予約申込!G18)","v":""},{"$f":"IF(予約申込!K18=\"\",\"\",予約申込!K18)","v":""},{"$f":"IF(予約申込!M18=\"\",\"\",予約申込!M18)","v":""},{"$f":"IF(予約申込!C19=\"\",\"\",予約申込!C19)","v":""},{"$f":"IF(予約申込!D19=\"\",\"\",予約申込!D19)","v":""},{"$f":"IF(予約申込!G19=\"\",\"\",予約申込!G19)","v":""},{"$f":"IF(予約申込!K19=\"\",\"\",予約申込!K19)","v":""},{"$f":"IF(予約申込!M19=\"\",\"\",予約申込!M19)","v":""},{"$f":"IF(予約申込!C20=\"\",\"\",予約申込!C20)","v":""},{"$f":"IF(予約申込!D20=\"\",\"\",予約申込!D20)","v":""},{"$f":"IF(予約申込!G20=\"\",\"\",予約申込!G20)","v":""},{"$f":"IF(予約申込!K20=\"\",\"\",予約申込!K20)","v":""},{"$f":"IF(予約申込!M20=\"\",\"\",予約申込!M20)","v":""},{"$f":"IF(予約申込!C21=\"\",\"\",予約申込!C21)","v":""},{"$f":"IF(予約申込!D21=\"\",\"\",予約申込!D21)","v":""},{"$f":"IF(予約申込!G21=\"\",\"\",予約申込!G21)","v":""},{"$f":"IF(予約申込!K21=\"\",\"\",予約申込!K21)","v":""},{"$f":"IF(予約申込!M21=\"\",\"\",予約申込!M21)","v":""},{"$f":"IF(予約申込!A28=\"\",\"\",予約申込!A28)","v":""},{"$f":"IF(予約申込!A31=\"\",\"\",予約申込!A31)","v":""},{"$f":"IF(予約申込!A32=\"\",\"\",予約申込!A32)","v":""},{"$f":"IF(予約申込!A33=\"\",\"\",予約申込!A33)","v":""},{"$f":"IF(予約申込!A36=\"\",\"\",予約申込!A36)","v":""},{"$f":"IF(予約申込!A37=\"\",\"\",予約申込!A37)","v":""},{"$f":"IF(予約申込!A38=\"\",\"\",予約申込!A38)","v":""},{"$f":"IF(予約申込!A39=\"\",\"\",予約申込!A39)","v":""},{"$f":"IF(予約申込!A40=\"\",\"\",予約申込!A40)","v":""},{"$f":"IF(予約申込!A41=\"\",\"\",予約申込!A41)","v":""},{"$f":"IF(予約申込!A42=\"\",\"\",予約申込!A42)","v":""},{"$f":"IF(予約申込!A43=\"\",\"\",予約申込!A43)","v":""},{"$f":"COUNTIF(AY7:BJ7,$BL$2)","v":0},{"$f":"SUMIF($AY$7:$BJ$7,$BL$2,$AY$2:$BJ$2)","v":0}]