{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["情報入力シート","（印刷用）願書シート","（印刷用）履歴書シート ","【取り込み用】採用者データ用","西暦和暦変換用","（元）願書","（元）履歴書"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":69,"n_cols":18,"rows_kept":69,"cut":false,"hidden":false,"merged":[[64,2,64,5],[53,2,53,3],[54,2,54,3],[61,4,61,5],[60,4,60,5],[59,4,59,5],[55,2,55,3],[57,2,57,5],[63,2,63,5],[61,2,61,3],[66,2,66,5],[2,2,2,5],[34,2,34,5],[13,3,13,5],[59,2,59,3],[60,2,60,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[52,2,52,3],[5,3,5,5],[7,3,7,5],[9,3,9,5],[20,3,20,5],[12,3,12,5],[65,4,65,5],[16,3,16,5],[26,4,26,5],[22,2,22,5],[11,3,11,5],[32,2,32,3],[29,2,29,5],[19,3,19,5],[27,4,27,5],[14,3,14,5],[17,3,17,5],[18,3,18,5],[50,2,50,3],[51,2,51,3],[24,3,24,5],[45,2,45,5],[31,2,31,3],[25,4,25,5],[39,2,39,5],[41,2,41,5],[15,3,15,5],[10,3,10,5],[4,3,4,5],[6,3,6,5],[8,3,8,5]]}
[]
[null,null,"●採用時情報入力用シート（このシートに入力すると印刷用シートに反映されます）　【保存はシート最下部の保存ボタンでお願いします】"]
[null,null,"基本情報"]
[null,null,null,null,null,null,"↓↓　入力例　↓↓"]
[null,null,"入力日",null,null,null,"2022-11-01"]
[null,null,"苗字(漢字)",null,null,null,"医大"]
[null,null,"名前(漢字)",null,null,null,"太郎"]
[null,null,"苗字(全角カタカナ)",null,null,null,"イダイ",{"$f":"PHONETIC(D8)","v":""},{"$f":"(D8=PHONETIC(D8))","v":true}]
[null,null,"名前(全角カタカナ)",null,null,null,"タロウ",{"$f":"PHONETIC(D9)","v":""},{"$f":"(D9=PHONETIC(D9))","v":true}]
[null,null,"生年月日（西暦）",null,null,null,"1981-05-09"]
[null,null,"年齢（採用日現在）",null,null,null,41,"↓リスト選択用（後ほど非表示にします）"]
[null,null,"性別",null,null,null,"【選択式】","男","女"]
[null,null,"【外国籍の場合のみ】国籍",null,null,null,"韓国　アメリカ　等"]
[null,null,"【外国籍の場合のみ】就労制限の有無",null,null,null,"【選択式】　別途確認書類が必要となります。","有","無"]
[null,null,"【現住所】郵便番号（ハイフンあり）",null,null,null,"634-8521"]
[null,null,"【現住所】住所1（市区町村名まで）",null,null,null,"奈良県橿原市四条町"]
[null,null,"【現住所】住所２（番地・マンション名等）\n　※全角入力",null,null,null,"１２３－４５６さくらハイツ２０３"]
[null,null,"【住民票】郵便番号（ハイフンあり）",null,null,null,"現住所と同じであれば「同上」と入力してください"]
[null,null,"【住民票】住所",null,null,null,"現住所と同じであれば「同上」と入力してください"]
[null,null,"電話番号（ハイフンあり）",null,null,null,"090-1122-1111"]
[null,null,"希望診療科",null,null,null,"消化器内科"]
[]
[null,null,"資格情報"]
[]
[null,null,"国家試験合格年月日（西暦）※該当年度末日",null,null,null,"2011-03-31",null,null,"↓採用者データ用（後ほど非表示にします）"]
[null,null,"医籍番号（登録年月日）/（番号）",null,null,null,null,null,null,{"$f":"YEAR(D26)","v":1900},{"$f":"MONTH(D26)","v":"1900-01-01"},{"$f":"DAY(D26)","v":"00:00:00"},{"$f":"IF(D26>43585,\"5\",IF(D26>32515,\"4\",IF(D26>9855,\"3\",\"2\")))","v":"2"},{"$f":"TEXT(D26,\"ee\")","v":"33"},{"$f":"TEXT(K26,\"00\")","v":"01"},"00",{"$f":"CONCATENATE(M26,N26,O26,P26)","v":"2330100"},"医師"]
[null,null,"保険医登録（登録年月日）/（番号）",null,null,null,"　例）奈医第〇〇号",null,null,{"$f":"YEAR(D27)","v":1900},{"$f":"MONTH(D27)","v":"1900-01-01"},{"$f":"DAY(D27)","v":"00:00:00"},{"$f":"IF(D27>43585,\"5\",IF(D27>32515,\"4\",IF(D27>9855,\"3\",\"2\")))","v":"2"},{"$f":"TEXT(D27,\"ee\")","v":"33"},"01","00",{"$f":"CONCATENATE(M27,N27,O27,P27)","v":"2330100"},"保険医"]
[null,null,"臨床研修修了登録証（登録年月日）/（番号）",null,null,null,null,null,null,{"$f":"YEAR(D28)","v":1900},{"$f":"MONTH(D28)","v":"1900-01-01"},{"$f":"DAY(D28)","v":"00:00:00"},{"$f":"IF(D28>43585,\"5\",IF(D28>32515,\"4\",IF(D28>9855,\"3\",\"2\")))","v":"2"},{"$f":"TEXT(D28,\"ee\")","v":"33"},"01","00",{"$f":"CONCATENATE(M28,N28,O28,P28)","v":"2330100"},"臨床研修修了"]
[]
[null,null,"臨床研修情報"]
[]
[null,null,"病院名",null,"開始年月日","修了年月日\n（見込）"]
[]
[]
[null,null,"学歴情報　（日付の古いものから順に入力してください）"]
[]
[null,null,"学校名","学部（または学科）","入学年月日","卒業年月日"]
[null,"（1）",null,null,null,null,"※1 高等学校は入力不要",null,null,"↓採用者データ用（後ほど非表示にします）"]
[null,"（2）",null,null,null,null,"※2 最終学歴は(1)(2)欄には入力しないでください"]
[null,null,"↓　最終学歴は以下に入力",null,null,null,null,"↓願書フラグ用"]
[null,"（3）",null,null,null,null,null,{"$f":"IF(C41=\"\",\"0\",\"1\")","v":"0"},null,{"$f":"YEAR(E41)","v":1900},{"$f":"MONTH(E41)","v":"1900-01-01"},{"$f":"DAY(E41)","v":"00:00:00"},{"$f":"IF(E41>43585,\"5\",IF(E41>32515,\"4\",IF(E41>9855,\"3\",\"2\")))","v":"2"},{"$f":"TEXT(E41,\"ee\")","v":"33"},{"$f":"TEXT(K41,\"00\")","v":"01"},{"$f":"TEXT(L41,\"00\")","v":"00"},{"$f":"CONCATENATE(M41,N41,O41,P41)","v":"2330100"},"開始日(和暦)"]
[null,null,"↓　現在、在籍中の場合は以下に入力",null,null,null,null,null,null,{"$f":"YEAR(F41)","v":1900},{"$f":"MONTH(F41)","v":1},{"$f":"DAY(F41)","v":0},{"$f":"IF(F41>43585,\"5\",IF(F41>32515,\"4\",IF(F41>9855,\"3\",\"2\")))","v":"2"},{"$f":"TEXT(F41,\"ee\")","v":"33"},{"$f":"TEXT(K42,\"00\")","v":"01"},{"$f":"TEXT(L42,\"00\")","v":"00"},{"$f":"CONCATENATE(M42,N42,O42,P42)","v":"2330100"},"終了日(和暦)"]
[null,null,"学校名","学部（または学科）","入学年月日","卒業見込\n年月日",null,"↓願書フラグ用"]
[null,"(4)",null,null,null,null,null,{"$f":"IF(C44=\"\",\"0\",\"1\")","v":"0"},{"$f":"H41+H44","v":0},{"$f":"YEAR(E44)","v":1900},{"$f":"MONTH(E44)","v":"1900-01-01"},{"$f":"DAY(E44)","v":"00:00:00"},{"$f":"IF(E44>43585,\"5\",IF(E44>32515,\"4\",IF(E44>9855,\"3\",\"2\")))","v":"2"},{"$f":"TEXT(E44,\"ee\")","v":"33"},{"$f":"TEXT(K44,\"00\")","v":"01"},{"$f":"TEXT(L44,\"00\")","v":"00"},{"$f":"CONCATENATE(M44,N44,O44,P44)","v":"2330100"},"開始日(和暦)"]
[null,null,null,null,null,null,null,null,null,{"$f":"YEAR(F44)","v":1900},{"$f":"MONTH(F44)","v":1},{"$f":"DAY(F44)","v":0},{"$f":"IF(F44>43585,\"5\",IF(F44>32515,\"4\",IF(F44>9855,\"3\",\"2\")))","v":"2"},{"$f":"TEXT(F44,\"ee\")","v":"33"},{"$f":"TEXT(K45,\"00\")","v":"01"},{"$f":"TEXT(L45,\"00\")","v":"00"},{"$f":"CONCATENATE(M45,N45,O45,P45)","v":"2330100"},"終了日(和暦)"]
[null,null,"職歴情報"]
[]
[null,null,"勤務先名",null,"入職年月日","退職年月日"]
[null,null,null,null,null,null,"※入力欄が不足する場合は、別紙等でご対応願います。"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"賞罰情報"]
[]
[null,null,"賞罰内容",null,"年月日"]
[]
[]
[]
[null,null,"【　入力項目に間違いがないか確認の上、以下の作業を行ってください　】"]
[null,null,"①「願書シート」と「履歴書シート」を印刷し、押印・写真貼付のうえ採用後所属する予定の講座へ提出\n\n②　入力が終わったデータを 採用後所属する予定の講座 と 人事課（※） へ送信\n　　データの保存は下部の「保存」ボタンより行ってください。。\n　　（入力された情報を元に、自動的に診療科と名字が入った保存画面が表示されます）"]
[null,null,"（※）送信先メールアドレス：","jinji@naramed-u.ac.jp","←コピー&ペーストできます。"]
[null,null,"（メールの件名は「専門医養成コース（講座名）」としてください）"]
[]
[null,null,{"$f":"\"専門医養成コース願書_\"&D21&\"_\"&D6&D7","v":"専門医養成コース願書__"}]

{"sheet":"（印刷用）願書シート","index":1,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,3,7,4],[8,3,8,4],[10,3,10,4],[0,1,0,3],[1,1,1,4],[9,3,9,4],[3,3,4,3],[3,4,4,4],[3,0,17,0],[3,1,4,2],[5,1,5,2],[6,1,6,2],[8,1,9,2],[10,1,11,2],[14,1,14,2],[12,1,12,2],[13,1,13,2],[7,1,7,2],[24,1,24,3],[25,3,25,4],[19,1,20,4],[21,2,21,3],[23,1,23,3],[12,3,12,4],[14,3,14,4],[16,3,16,4],[17,3,17,4],[15,1,16,1],[17,1,17,2]]}
[]
[null,"奈良県立医科大学附属病院専門医養成コース医員願書"]
[]
[null,"フ　リ　ガ　ナ",null,{"$f":"IF(情報入力シート!D8=\"\",\"\",情報入力シート!D8)","v":""},{"$f":"IF(情報入力シート!D9=\"\",\"\",情報入力シート!D9)","v":""}]
[]
[null,"  氏　　　　　名",null,{"$f":"IF(情報入力シート!D6=\"\",\"\",情報入力シート!D6)","v":""},{"$f":"IF(情報入力シート!D7=\"\",\"\",情報入力シート!D7)","v":""}]
[null,"  生  年  月  日",null,{"$f":"IF(情報入力シート!D10=\"\",\"\",情報入力シート!D10)","v":""},{"$f":"\" （ \"&情報入力シート!D11&\" 歳 ） \"","v":" （  歳 ） "}]
[null,"（外国籍の場合）\n国籍",null,{"$f":"IF(情報入力シート!D13=\"\",\"\",情報入力シート!D13)","v":""}]
[null,"  住　　　　　　　所",null,{"$f":"\"　〒　\"&情報入力シート!D15","v":"　〒　"}]
[null,null,null,{"$f":"情報入力シート!D16&情報入力シート!D17","v":""}]
[null,"  最　終　学　歴\n卒業年月日",null,{"$f":"IF(情報入力シート!C41=\"\",\"\",情報入力シート!C41&情報入力シート!D41)","v":""}]
[null,null,null,{"$f":"IF(情報入力シート!D41=\"\",\"\",情報入力シート!F41)","v":""},"卒業（見込）"]
[null,"国家試験合格",null,{"$f":"IF(情報入力シート!D25=\"\",\"\",情報入力シート!D25)","v":""}]
[null,"  医　籍　登　録",null,{"$f":"IF(情報入力シート!D26=\"\",\"\",情報入力シート!D26)","v":""},{"$f":"\"第\"&情報入力シート!E26&\"号\"","v":"第号"}]
[null,"  保険医登録番号",null,{"$f":"IF(情報入力シート!E27=\"\",\"\",情報入力シート!E27)","v":""}]
[null," 臨床研修"," 期　間\n（自/至）",{"$f":"IF(情報入力シート!E33=\"\",\"\",情報入力シート!E33)","v":""},{"$f":"IF(情報入力シート!F33=\"\",\"\",情報入力シート!F33)","v":""}]
[null,null," 病院名",{"$f":"IF(情報入力シート!C33=\"\",\"\",情報入力シート!C33)","v":""}]
[null,"希望診療科",null,{"$f":"IF(情報入力シート!D21=\"\",\"\",情報入力シート!D21)","v":""}]
[]
[null,"　貴法人において、医員として従事したいので、許可くださるよう関係書類を添えて申し込みます。"]
[]
[null,null,{"$f":"情報入力シート!D5","v":"00:00:00"}]
[]
[null,"公立大学法人"]
[null,"奈良県立医科大学　理事長　殿"]
[null,null,null,{"$f":"IF(情報入力シート!D6=\"\",\"出願者氏名：　　　　　　　　　　　　　　　　印\",\"出願者氏名：　　　　\"&情報入力シート!D6&\"　　\"&情報入力シート!D7&\"　　　印\")","v":"出願者氏名：　　　　　　　　　　　　　　　　印"}]

{"sheet":"（印刷用）履歴書シート ","index":2,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,5,4,8],[24,2,24,3],[19,4,19,7],[20,4,20,7],[23,4,23,7],[24,4,24,7],[15,5,15,8],[19,2,19,3],[20,2,20,3],[23,2,23,3],[5,3,6,8],[21,2,21,3],[22,2,22,3],[17,5,17,8],[7,5,7,8],[8,3,8,8],[10,5,10,6],[10,7,10,8],[11,5,11,6],[11,7,11,8],[25,2,25,3],[25,4,25,7],[21,4,21,7],[22,4,22,7],[13,5,13,8],[2,1,2,8],[43,5,43,6],[43,7,43,8],[41,1,41,3],[37,4,37,9],[30,3,30,5],[36,2,36,3],[37,2,37,3],[31,3,31,5],[32,3,32,5],[33,3,33,5],[34,3,34,5],[36,4,36,9],[27,3,27,5],[28,3,28,5],[29,3,29,5]]}
[null,"（　専門医養成コース　）"]
[]
[null," 履　　歴　　書"]
[]
[null,"                         ","　　　　　　現住所：　　　　〒",null,null,{"$f":"IF(情報入力シート!D15=\"\",\"\",情報入力シート!D15)","v":""}]
[null,null,null,{"$f":"情報入力シート!D16&情報入力シート!D17","v":""}]
[]
[null,null,"　　　　　　住民票住所：　　〒",null,null,{"$f":"IF(情報入力シート!D18=\"\",\"\",情報入力シート!D18)","v":""}]
[null,null,null,{"$f":"IF(情報入力シート!D19=\"\",\"\",情報入力シート!D19)","v":""}]
[]
[null,null,"　　　　　　フリガナ　：",null,null,{"$f":"IF(情報入力シート!D8=\"\",\"\",情報入力シート!D8)","v":""},null,{"$f":"IF(情報入力シート!D9=\"\",\"\",情報入力シート!D9)","v":""}]
[null,null,"　　　　　　氏　　名　：",null,null,{"$f":"IF(情報入力シート!D6=\"\",\"\",情報入力シート!D6)","v":""},null,{"$f":"IF(情報入力シート!D7=\"\",\"\",情報入力シート!D7)","v":""}]
[]
[null,null,"　　　　　　性　　別 　：",null,null,{"$f":"IF(情報入力シート!D12=\"\",\"\",情報入力シート!D12)","v":""}]
[]
[null,null,"　　　　　　生年月日　：",null,null,{"$f":"IF(情報入力シート!D10=\"\",\"\",情報入力シート!D10)","v":""}]
[]
[null,null,"　　　　　　電話番号　：",null,null,{"$f":"IF(情報入力シート!D20=\"\",\"\",情報入力シート!D20)","v":""}]
[]
[null,"  学歴",{"$f":"IF(情報入力シート!E38=0,\"\",情報入力シート!E38)","v":""},null,{"$f":"IF(情報入力シート!C38=0,\"\",情報入力シート!C38&情報入力シート!D38)","v":""},null,null,null,{"$f":"IF(E20=\"\",\"\",\"入学\")","v":""}]
[null,"                  年　　月　　日                              　卒業",{"$f":"IF(情報入力シート!F38=0,\"\",情報入力シート!F38)","v":""},null,{"$f":"IF(情報入力シート!C38=0,\"\",情報入力シート!C38&情報入力シート!D38)","v":""},null,null,null,{"$f":"IF(E21=\"\",\"\",\"卒業\")","v":""}]
[null,null,{"$f":"IF(情報入力シート!E39=0,\"\",情報入力シート!E39)","v":""},null,{"$f":"IF(情報入力シート!C39=0,\"\",情報入力シート!C39&情報入力シート!D39)","v":""},null,null,null,{"$f":"IF(E22=\"\",\"\",\"入学\")","v":""}]
[null,null,{"$f":"IF(情報入力シート!F39=0,\"\",情報入力シート!F39)","v":""},null,{"$f":"IF(情報入力シート!C39=0,\"\",情報入力シート!C39&情報入力シート!D39)","v":""},null,null,null,{"$f":"IF(E23=\"\",\"\",\"卒業\")","v":""}]
[null,null,{"$f":"IF(情報入力シート!E41=0,\"\",情報入力シート!E41)","v":""},null,{"$f":"IF(情報入力シート!C41=0,\"\",情報入力シート!C41&情報入力シート!D41)","v":""},null,null,null,{"$f":"IF(E24=\"\",\"\",\"入学\")","v":""}]
[null,null,{"$f":"IF(情報入力シート!F41=0,\"\",情報入力シート!F41)","v":""},null,{"$f":"IF(情報入力シート!C41=0,\"\",情報入力シート!C41&情報入力シート!D41)","v":""},null,null,null,{"$f":"IF(E25=\"\",\"\",\"卒業\")","v":""}]
[null,null,{"$f":"IF(情報入力シート!E44=0,\"\",情報入力シート!E44)","v":""},null,{"$f":"IF(情報入力シート!C44=0,\"\",情報入力シート!C44&情報入力シート!D44)","v":""},null,null,null,{"$f":"IF(E26=\"\",\"\",\"入学\")","v":""}]
[]
[null,"  職歴",{"$f":"IF(情報入力シート!E49=0,\"\",情報入力シート!E49)","v":""},{"$f":"IF(情報入力シート!C49=0,\"\",情報入力シート!C49)","v":""},null,null,{"$f":"IF(D28=\"\",\"\",\"入職\")","v":""},{"$f":"IF(I28=\"\",\"\",\"（退職日：\")","v":""},{"$f":"IF(情報入力シート!F49=0,\"\",情報入力シート!F49)","v":""},{"$f":"IF(I28=\"\",\"\",\"）\")","v":""}]
[null,null,{"$f":"IF(情報入力シート!E50=0,\"\",情報入力シート!E50)","v":""},{"$f":"IF(情報入力シート!C50=0,\"\",情報入力シート!C50)","v":""},null,null,{"$f":"IF(D29=\"\",\"\",\"入職\")","v":""},{"$f":"IF(I29=\"\",\"\",\"（退職日：\")","v":""},{"$f":"IF(情報入力シート!F50=0,\"\",情報入力シート!F50)","v":""},{"$f":"IF(I29=\"\",\"\",\"）\")","v":""}]
[null,null,{"$f":"IF(情報入力シート!E51=0,\"\",情報入力シート!E51)","v":""},{"$f":"IF(情報入力シート!C51=0,\"\",情報入力シート!C51)","v":""},null,null,"","",{"$f":"IF(情報入力シート!F51=0,\"\",情報入力シート!F51)","v":""},""]
[null,null,{"$f":"IF(情報入力シート!E52=0,\"\",情報入力シート!E52)","v":""},{"$f":"IF(情報入力シート!C52=0,\"\",情報入力シート!C52)","v":""},null,null,"","",{"$f":"IF(情報入力シート!F52=0,\"\",情報入力シート!F52)","v":""},""]
[null,null,{"$f":"IF(情報入力シート!E53=0,\"\",情報入力シート!E53)","v":""},{"$f":"IF(情報入力シート!C53=0,\"\",情報入力シート!C53)","v":""},null,null,"","",{"$f":"IF(情報入力シート!F53=0,\"\",情報入力シート!F53)","v":""},""]
[null,null,{"$f":"IF(情報入力シート!E54=0,\"\",情報入力シート!E54)","v":""},{"$f":"IF(情報入力シート!C54=0,\"\",情報入力シート!C54)","v":""},null,null,"","",{"$f":"IF(情報入力シート!F54=0,\"\",情報入力シート!F54)","v":""},""]
[null,null,{"$f":"IF(情報入力シート!E55=0,\"\",情報入力シート!E55)","v":""},{"$f":"IF(情報入力シート!C55=0,\"\",情報入力シート!C55)","v":""},null,null,"","",{"$f":"IF(情報入力シート!F55=0,\"\",情報入力シート!F55)","v":""},""]
[null,null,{"$f":"IF(情報入力シート!E56=0,\"\",情報入力シート!E56)","v":""},{"$f":"IF(情報入力シート!C56=0,\"\",情報入力シート!C56)","v":""},null,null,"","",{"$f":"IF(情報入力シート!F56=0,\"\",情報入力シート!F56)","v":""},""]
[]
[null,"  賞罰",{"$f":"IF(情報入力シート!E61=0,\"\",情報入力シート!E61)","v":""},null,{"$f":"IF(情報入力シート!C61=0,\"\",情報入力シート!C61)","v":""}]
[null,null,{"$f":"IF(情報入力シート!E62=0,\"\",情報入力シート!E62)","v":""},null,{"$f":"IF(情報入力シート!C62=0,\"\",情報入力シート!C62)","v":""}]
[]
[null,"    上記のとおり相違ありません。"]
[]
[null,{"$f":"情報入力シート!D5","v":"00:00:00"}]
[]
[null,null,null,null,"氏名",{"$f":"IF(情報入力シート!D6=\"\",\"\",情報入力シート!D6)","v":""},null,{"$f":"IF(情報入力シート!D7=\"\",\"\",情報入力シート!D7)","v":""},null,"印"]

{"sheet":"【取り込み用】採用者データ用","index":3,"n_rows":2,"n_cols":114,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["職員コード","氏名","カナ氏名","性別","生年月日(西暦)","採用年月日(西暦)","採用区分","採用職種コード","職種コード","職種発令日","職員区分","郵便番号","都道府県コード","市区町村コード","地区コード","住所１","住所２","カナ住所１","カナ住所２","電話番号","メールアドレス","基準学歴コード","前歴月数","調整月数","定年","血液型","血液型ＲＨ","本籍","基礎年金番号１","基礎年金番号２","開始日(和暦)","終了日(和暦)","学歴コード","学校区分コード","学校コード","学校名称","学部コード","学部名称","学科コード","学科名称","専攻コード","専攻名称","修学コード","最終学歴フラグ","発令日","発令区分１","発令区分２","文章番号","任命権者コード","組織コード","職名コード１","職名コード２","補職コード","職務コード","階級コード","担当コード","業務分野コード","あて職コード","給料表コード","等級","号給","月額","調整額","報酬区分","報酬額","年月日１","年月日２","任意文１","任意文２","在課年数通算フラグ","チェック","業務","本姓","生年月日","取得日(和暦)1","資格免許名称1","資格免許交付番号1","基本簿記載対象フラグ1","取得日(和暦)1","資格免許名称1","資格免許交付番号1","基本簿記載対象フラグ1","取得日(和暦)1","資格免許名称1","資格免許交付番号1","基本簿記載対象フラグ1","取得日(和暦)1","資格免許名称1","資格免許交付番号1","基本簿記載対象フラグ1","取得日(和暦)1","資格免許名称1","資格免許交付番号1","基本簿記載対象フラグ1","取得日(和暦)1","資格免許名称1","資格免許交付番号1","基本簿記載対象フラグ1","取得日(和暦)1","資格免許名称1","資格免許交付番号1","基本簿記載対象フラグ1","取得日(和暦)1","資格免許名称1","資格免許交付番号1","基本簿記載対象フラグ1","取得日(和暦)1","資格免許名称1","資格免許交付番号1","基本簿記載対象フラグ1","取得日(和暦)1","資格免許名称1","資格免許交付番号1","基本簿記載対象フラグ1"]
[null,{"$f":"情報入力シート!D6&\"　\"&情報入力シート!D7","v":"　"},{"$f":"情報入力シート!D8&\"　\"&情報入力シート!D9","v":"　"},{"$f":"IF(情報入力シート!D12=\"男\",\"1\",\"2\")","v":"2"},{"$f":"TEXT(情報入力シート!D10,\"YYYYmmdd\")","v":"19000100"},null,null,null,null,null,null,{"$f":"SUBSTITUTE( 情報入力シート!D15, \"-\", \"\" )","v":""},null,null,null,{"$f":"情報入力シート!D16","v":0},{"$f":"情報入力シート!D17","v":0},null,null,{"$f":"情報入力シート!D20","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(情報入力シート!C41=\"\",情報入力シート!Q44,情報入力シート!Q41)","v":"2330100"},{"$f":"IF(情報入力シート!C41=\"\",情報入力シート!Q45,情報入力シート!Q42)","v":"2330100"},null,null,null,{"$f":"情報入力シート!C41","v":0},null,{"$f":"情報入力シート!D41","v":"00:00:00"},null,{"$f":"IF(【取り込み用】採用者データ用!AL2=\"\",情報入力シート!D44,\"\")","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,false,null,null,null,{"$f":"情報入力シート!Q26","v":"2330100"},{"$f":"情報入力シート!R26","v":"医師"},{"$f":"情報入力シート!E26","v":0},null,{"$f":"情報入力シート!Q27","v":"2330100"},{"$f":"情報入力シート!R27","v":"保険医"},{"$f":"情報入力シート!E27","v":0},null,{"$f":"情報入力シート!Q28","v":"2330100"},{"$f":"情報入力シート!R28","v":"臨床研修修了"},{"$f":"情報入力シート!E28","v":0}]

{"sheet":"西暦和暦変換用","index":4,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"2019-04-30","←西暦を入力",{"$f":"C2","v":43585},"日付の\nシリアル値"]
[]
[null,null,"年","月","日"]
[null,"年月日\n取り出し",{"$f":"YEAR(C2)","v":2019},{"$f":"MONTH(C2)","v":"1900-01-04"},{"$f":"DAY(C2)","v":"1900-01-30"}]
[null,"テキスト\n変換",{"$f":"TEXT(C2,\"ee\")","v":"31"},{"$f":"TEXT(D5,\"00\")","v":"04"},{"$f":"TEXT(E5,\"00\")","v":"30"},"↓ＬＡＰＩＳ取り込みデータ用"]
[null,"和暦→数字\n置き換え",{"$f":"IF(C2>43585,\"5\",IF(C2>32515,\"4\",IF(C2>9855,\"3\",\"2\")))","v":"4"},null,null,{"$f":"CONCATENATE(C7,C6,D6,E6)","v":"4310430"}]
[null,null,"令和：5　平成：4　昭和：3"]
[]
[null,null,"参考：年号切り替わり日付のシリアル値"]
[]
[null,null,"西暦","シリアル値","和暦"]
[null,null,"1926-12-25",{"$f":"C13","v":9856},"1926-12-25"]
[null,null,"1989-01-07",32515,"1989-01-07"]
[null,null,"1989-01-08",32516,"1989-01-08"]
[null,null,"2019-04-30",43585,"2019-04-30"]
[null,null,"2019-05-01",43586,"2019-05-01"]

{"sheet":"（元）願書","index":5,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":true,"merged":[[3,4,18,4],[6,1,6,2],[13,1,13,2],[14,1,14,2],[3,0,18,0],[5,1,5,2],[3,3,4,3],[0,1,0,3],[7,1,8,2],[9,1,10,2],[11,1,12,2],[3,1,4,2],[20,1,20,3],[22,2,22,3],[24,1,24,3],[16,1,17,1],[15,1,15,2],[18,1,18,2]]}
[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,"希望診療科"]
[]
[null,"　貴大学附属病院において、医員として従事したいので、許可くださるよう関係書類を添えてお願いします。"]
[]
[null,null,"令和　　　　年　　　　月　　　　日"]
[]
[null,"  奈良県立医科大学　理事長　殿"]
[]
[null,null,null,"                                 出願者氏名                                                              印"]

{"sheet":"（元）履歴書","index":6,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":true,"merged":[[15,2,15,8],[2,1,2,7],[16,2,16,8],[33,4,33,8],[25,2,25,8],[26,2,26,8],[17,2,17,8],[18,2,18,8],[20,2,20,8],[21,2,21,8],[22,2,22,8],[23,2,23,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,"     氏名                                                              印"]