{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["実行","データ選択","マスタ","エラー発生源"],"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":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"取り込み設定"]
[]
[null,"下記太枠内の設定を行ってください。"]
[]
[null,"1. 学校種別を選択してください。"]
[null,"「小学校」「中学校」「小中一貫校、義務教育学校」から選択してください。"]
[null,"選択してください"]
[]
[null,"2. デジタル教科書のユーザーIDを取り込むための設定をしてください。"]
[null,"①まなびポケットに登録されている「外部認証ID」をデジタル教科書でも利用しますか。"]
[null,"選択してください"]
[]
[null,"②まなびポケットに登録されているユーザーIDをデジタル教科書でも利用しますか。"]
[null,"選択してください"]
[]
[null,"3. 学年の対比表を入力してください。"]
[null,"学年","まなびポケットに登録している学年名"]
[null,"小学1年"]
[null,"小学2年"]
[null,"小学3年"]
[null,"小学4年"]
[null,"小学5年"]
[null,"小学6年"]
[null,"中学1年"]
[null,"中学2年"]
[null,"中学3年"]
[null,"※利用しない学年は空欄にしてください。"]
[null,"※入力の際にクラス名は不要です。入力した場合正常に入学年の判定ができなくなりますのでご注意ください。"]
[null,"※学年と1:1で紐づけできない場合は、空欄のまま実行してください。一致するものがない場合は入学年が空欄で出力されます。"]
[]
[null,"3. 設定が完了したら下記のボタンをクリックしてください。"]
[null,"※ボタンを押すとファイル選択画面が表示されます。まなびポケットで現在年度のファイルをダウンロードして選択してください。"]
[]
[]
[]
[]
[]
[null,"※パスワード作成設定（データ変換後シートでパスワード作成を行うと、自動で反映されます）"]
[null,"作成対象"]
[null,"桁数（生徒）"]
[null,"桁数（先生）"]
[null,"利用文字種（生徒）"]
[null,"利用文字種（先生）"]
[null,"記号利用文字"]

{"sheet":"データ選択","index":1,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"まなびポケットの登録人数：0人（出力対象ユーザー数：0人、出力非対象ユーザー数：0人、入学年度未決定ユーザー数：0人"]
[]
["選択","外部認証ID","ユーザ種別\n1：生徒\n2：先生","学年","入学年","ユーザーID","表示名","パスワード"]

{"sheet":"マスタ","index":2,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["学校種別","外部連携ID利用","ユーザーID利用","教科書会社"]
["選択してください","選択してください","選択してください","選択してください"]
["小学校","利用する","利用する","Lentrance Reader"]
["中学校","利用しない","利用しない","まなビューア"]
["小中一貫校、義務教育学校",null,null,"みらいスクールプラットフォーム"]
[null,null,null,"超教科書"]
[null,null,null,"エスビューア"]
[null,null,null,"つばさブック"]

{"sheet":"エラー発生源","index":3,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["SelecteTargetModule","ShowSelectGradeForm",1008,{"$f":"IF(C1<>\"\",COUNTIF(C:C,C1),\"\")","v":1}]
[null,"SelectAll",1013,1]
[null,"ClearAll",1014,1]
[null,"ReflectUserCount",9003,1]
[null,"RunProcess",1031,1]
["ImportManapokeModule","ShowConversionForm",1001,1]
[null,"SelectFile",1004,1]
[null,"ConversionData",1003,1]
[null,"GetColumnIndexes",1006,1]
[null,"CheckRequiredCol",1007,1]
[null,"GetGradeDic",1005,1]
[null,"ToggleEmptyFilter",1028,1]
["ExportCsvFileModule","ShowExportForm",1023,1]
[null,"ExportCsvWithoutBom",1025,1]
[null,"WriteCsvByStream",1027,1]
[null,"CreatePasswordStr",1026,1]
["CreatePasswordModule","ShowPasswordForm",1015,1]
[null,"CreatePassword",1018,1]
[null,"GetPoolForPassword",1019,1]
[null,"GeneratePassword",1020,1]
[null,"RandChar",1021,1]
[null,"Shuffle",1022,1]
["ConstModule","ResetEvents",null,""]
[null,"StartFunc",null,""]
[null,"EndFunc",null,""]
[null,"GetLastRow",9001,1]
[null,"GetLastColumn",9002,1]
[null,"ShowErrorMsg",null,""]
[null,"ProtectSelectSht",null,""]
["SelectGradeForm","UserForm_Initialize",1009,1]
[null,"CheckedButton_Click",1011,1]
[null,"GetUniqueGradeList",1010,1]
[null,"GetSelctedDic",1012,1]
["PasswordForm","UserForm_Initialize",null,""]
[null,"ReflectPasswordSettingToForm",1032,1]
[null,"StuCheckBox_Click",null,""]
[null,"TchCheckBox_Click",null,""]
[null,"StuSymbol_Click",null,""]
[null,"TchSymbol_Click",null,""]
[null,"CreatePasswordButton_Click",1016,1]
[null,"ReflectPasswordSetting",1017,1]
["ExportForm","ExportButton_Click",1024,1]
[null,"UserForm_Initialize",null,""]
["ConversionForm","UserForm_Initialize",null,""]
[null,"UserForm_QueryClose",null,""]
[null,"ConversionDataButton_Click",1002,1]
["SelectSheet","Worksheet_BeforeDoubleClick",1029,1]
[null,"Worksheet_Change",1030,1]