{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["日立調査書","選択","印刷設定","日立印刷","日立調査書原本","書式設定"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":17,"comments":1,"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":57,"n_cols":105,"rows_kept":57,"cut":false,"hidden":false,"merged":[[4,101,4,102],[1,16,2,104],[3,97,3,102],[3,103,5,103],[3,104,5,104],[4,34,4,36],[4,37,4,39],[4,40,4,42],[4,93,4,94],[4,95,4,96],[4,97,4,98],[4,43,4,45],[4,46,4,48],[4,58,4,60],[4,91,4,92],[4,99,4,100],[3,5,5,5],[3,6,5,6],[3,7,4,15],[3,16,4,24],[3,25,4,33],[3,34,3,60],[3,61,4,70],[3,71,4,80],[3,81,4,90],[3,91,3,96],[4,49,4,51],[4,52,4,54],[4,55,4,57],[3,0,5,0],[3,1,5,1],[3,2,5,2],[3,3,5,3],[3,4,5,4],[1,0,2,2],[0,0,0,2],[0,6,0,104],[1,4,1,5],[2,4,2,5],[1,6,1,7],[2,6,2,7],[1,8,1,10],[1,11,1,12],[1,13,1,15],[2,8,2,10],[2,11,2,12],[2,13,2,15]]}
["　【調査書用便利エクセル】\n※日立手入力用※",null,null,null,null,null,"確認用のCSVファイルを出力する。※確認用CSVファイルをアップロードしないようにご注意ください。"]
["紙に印刷する場合は、\n印刷スイッチを押下ください",null,null,"学校名",null,null,"校長名",null,null,null,null,"電話番号"]
[null,null,null,"Eメールアドレス",null,null,"記入日",null,{"$f":"TODAY()","v":"2023-10-30"},null,null,"記入者名"]
["No","組","番号","氏名","ふりがな","性別","生年月日","評定（1年）",null,null,null,null,null,null,null,null,"評定（2年）",null,null,null,null,null,null,null,null,"評定（3年）",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,"行動の記録（1年）",null,null,null,null,null,null,null,null,null,"行動の記録（2年）",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,"総合所見及び指導上参考となる諸事項、その他生徒についての連絡事項","直近の\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,"国語","社会","数学","理科","音楽","美術","保健\n体育","技術\n家庭","外国語","国語","社会","数学","理科","音楽","美術","保健\n体育","技術\n家庭","外国語","国語","社会","数学","理科","音楽","美術","保健\n体育","技術\n家庭","外国語","知識・技能","思考・判断・表現","主体的に学習\nに取り組む態度","知識・技能","思考・判断・表現","主体的に学習\nに取り組む態度","知識・技能","思考・判断・表現","主体的に学習\nに取り組む態度","知識・技能","思考・判断・表現","主体的に学習\nに取り組む態度","知識・技能","思考・判断・表現","主体的に学習\nに取り組む態度","知識・技能","思考・判断・表現","主体的に学習\nに取り組む態度","知識・技能","思考・判断・表現","主体的に学習\nに取り組む態度","知識・技能","思考・判断・表現","主体的に学習\nに取り組む態度","知識・技能","思考・判断・表現","主体的に学習\nに取り組む態度","基本的な\n生活習慣","健康・体力\nの向上","自主\n・\n自立","責任感","創意工夫","思いやり\n・\n協力","生命尊重\n・\n自然愛護","勤労\n・\n奉仕","公正\n・\n公平","公共心\n・\n公徳心","基本的な\n生活習慣","健康・体力\nの向上","自主\n・\n自立","責任感","創意工夫","思いやり\n・\n協力","生命尊重\n・\n自然愛護","勤労\n・\n奉仕","公正\n・\n公平","公共心\n・\n公徳心","基本的な\n生活習慣","健康・体力\nの向上","自主\n・\n自立","責任感","創意工夫","思いやり\n・\n協力","生命尊重\n・\n自然愛護","勤労\n・\n奉仕","公正\n・\n公平","公共心\n・\n公徳心","内容","部活動名","内容","部活動名","内容","部活動名","欠席\n日数","遅早\n回数","欠席\n日数","遅早\n回数","欠席\n日数","遅早\n回数"]
["記載例",1,1,"アット　太郎","あっと　たろう","男","2010/3/3",5,4,3,2,1,"N",5,4,3,5,4,3,2,1,"N",5,4,3,5,4,3,2,1,"N",5,4,3,"A","B","C","N","A","B","C","N","A","B","C","N","A","B","C","N","A","B","C","N","A","B","C","N","A","B","C","〇",null,"〇",null,"〇",null,"〇",null,"〇",null,"〇",null,"〇",null,"〇",null,"〇",null,"〇",null,"〇",null,"〇",null,"〇",null,"〇",null,"〇",null,"新人戦地区大会出場","サッカー","県北地区総体ベスト４","サッカー","県北地区大会優勝、県大会出場","サッカー",1,2,3,4,5,6,"明るく、あらゆることに一生懸命に取り組める生徒。サッカー部では副キャプテンとして活動し、県北地区のトレセンにも選出された。合唱祭においては指揮者を務め、合唱が苦手な生徒にも寄り添いながら学級をまとめた。２年生の秋ごろより貴校への進学を希望している。貴校に進学し、将来は技能五輪国際大会へ出場する夢を持っている。","A"]
[{"$f":"ROW()-7","v":1}]
[{"$f":"ROW()-7","v":2}]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]

{"sheet":"選択","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["男女"]
[]
["男"]
["女"]

{"sheet":"印刷設定","index":2,"n_rows":109,"n_cols":16,"rows_kept":109,"cut":false,"hidden":true,"merged":[]}
["日立印刷",null,null,null,null,null,null,null,null,"■印刷設定説明"]
[3,4,null,4,null,"氏名",null,null,null,null,"①","②","③","④","⑤","⑥"]
[2,4,null,5,null,"ふりがな"]
[3,8,null,6,null,"性別"]
[3,9,null,7,"BIRTH2","生年月日"]
[7,6,null,8,null,"1年評定　国語"]
[10,6,null,9,null,"1年評定　社会"]
[13,6,null,10,null,"1年評定　数学",null,null,null,null,"①差し込み先の行"]
[16,6,null,11,null,"1年評定　理科",null,null,null,null,"②差し込み先の列"]
[19,6,null,12,null,"1年評定　音楽",null,null,null,null,"③取得元の行、設定されている場合は固定となる"]
[22,6,null,13,null,"1年評定　美術",null,null,null,null,"④取得元の列"]
[25,6,null,14,null,"1年評定　保健体育",null,null,null,null,"⑤取得元を変換する場合に設定"]
[28,6,null,15,null,"1年評定　技術家庭"]
[31,6,null,16,null,"1年評定　外国語"]
[7,7,null,17,null,"2年評定　国語",null,null,null,null,"⑥未使用、ラベルとして利用"]
[10,7,null,18,null,"2年評定　社会"]
[13,7,null,19,null,"2年評定　数学"]
[16,7,null,20,null,"2年評定　理科"]
[19,7,null,21,null,"2年評定　音楽"]
[22,7,null,22,null,"2年評定　美術"]
[25,7,null,23,null,"2年評定　保健体育"]
[28,7,null,24,null,"2年評定　技術家庭"]
[31,7,null,25,null,"2年評定　外国語"]
[7,8,null,26,null,"3年評定　国語"]
[10,8,null,27,null,"3年評定　社会"]
[13,8,null,28,null,"3年評定　数学"]
[16,8,null,29,null,"3年評定　理科"]
[19,8,null,30,null,"3年評定　音楽"]
[22,8,null,31,null,"3年評定　美術"]
[25,8,null,32,null,"3年評定　保健体育"]
[28,8,null,33,null,"3年評定　技術家庭"]
[31,8,null,34,null,"3年評定　外国語"]
[7,5,null,35,null,"観点別学習状況（3年）　国語　知識・技能"]
[8,5,null,36,null,"観点別学習状況（3年）　国語　思考・判断・表現"]
[9,5,null,37,null,"観点別学習状況（3年）　国語　主体的に学習に取り組む態度"]
[10,5,null,38,null,"観点別学習状況（3年）　社会　知識・技能"]
[11,5,null,39,null,"観点別学習状況（3年）　社会　思考・判断・表現"]
[12,5,null,40,null,"観点別学習状況（3年）　社会　主体的に学習に取り組む態度"]
[13,5,null,41,null,"観点別学習状況（3年）　数学　知識・技能"]
[14,5,null,42,null,"観点別学習状況（3年）　数学　思考・判断・表現"]
[15,5,null,43,null,"観点別学習状況（3年）　数学　主体的に学習に取り組む態度"]
[16,5,null,44,null,"観点別学習状況（3年）　理科　知識・技能"]
[17,5,null,45,null,"観点別学習状況（3年）　理科　思考・判断・表現"]
[18,5,null,46,null,"観点別学習状況（3年）　理科　主体的に学習に取り組む態度"]
[19,5,null,47,null,"観点別学習状況（3年）　音楽　知識・技能"]
[20,5,null,48,null,"観点別学習状況（3年）　音楽　思考・判断・表現"]
[21,5,null,49,null,"観点別学習状況（3年）　音楽　主体的に学習に取り組む態度"]
[22,5,null,50,null,"観点別学習状況（3年）　美術　知識・技能"]
[23,5,null,51,null,"観点別学習状況（3年）　美術　思考・判断・表現"]
[24,5,null,52,null,"観点別学習状況（3年）　美術　主体的に学習に取り組む態度"]
[25,5,null,53,null,"観点別学習状況（3年）　保健・体育　知識・技能"]
[26,5,null,54,null,"観点別学習状況（3年）　保健・体育　思考・判断・表現"]
[27,5,null,55,null,"観点別学習状況（3年）　保健・体育　主体的に学習に取り組む態度"]
[28,5,null,56,null,"観点別学習状況（3年）　技術・家庭　知識・技能"]
[29,5,null,57,null,"観点別学習状況（3年）　技術・家庭　思考・判断・表現"]
[30,5,null,58,null,"観点別学習状況（3年）　技術・家庭　主体的に学習に取り組む態度"]
[31,5,null,59,null,"観点別学習状況（3年）　外国語　知識・技能"]
[32,5,null,60,null,"観点別学習状況（3年）　外国語　思考・判断・表現"]
[33,5,null,61,null,"観点別学習状況（3年）　外国語　主体的に学習に取り組む態度"]
[6,10,null,62,null,"1年行動　基本的な生活習慣"]
[7,10,null,63,null,"1年行動　健康・体力の向上"]
[8,10,null,64,null,"1年行動　自主・自立"]
[9,10,null,65,null,"1年行動　責任感"]
[10,10,null,66,null,"1年行動　創意工夫"]
[11,10,null,67,null,"1年行動　思いやり・協力"]
[12,10,null,68,null,"1年行動　生命尊重・自然愛護"]
[13,10,null,69,null,"1年行動　勤労・奉仕"]
[14,10,null,70,null,"1年行動　公正・公平"]
[15,10,null,71,null,"1年行動　公共心・公徳心"]
[6,11,null,72,null,"2年行動　基本的な生活習慣"]
[7,11,null,73,null,"2年行動　健康・体力の向上"]
[8,11,null,74,null,"2年行動　自主・自立"]
[9,11,null,75,null,"2年行動　責任感"]
[10,11,null,76,null,"2年行動　創意工夫"]
[11,11,null,77,null,"2年行動　思いやり・協力"]
[12,11,null,78,null,"2年行動　生命尊重・自然愛護"]
[13,11,null,79,null,"2年行動　勤労・奉仕"]
[14,11,null,80,null,"2年行動　公正・公平"]
[15,11,null,81,null,"2年行動　公共心・公徳心"]
[6,12,null,82,null,"3年行動　基本的な生活習慣"]
[7,12,null,83,null,"3年行動　健康・体力の向上"]
[8,12,null,84,null,"3年行動　自主・自立"]
[9,12,null,85,null,"3年行動　責任感"]
[10,12,null,86,null,"3年行動　創意工夫"]
[11,12,null,87,null,"3年行動　思いやり・協力"]
[12,12,null,88,null,"3年行動　生命尊重・自然愛護"]
[13,12,null,89,null,"3年行動　勤労・奉仕"]
[14,12,null,90,null,"3年行動　公正・公平"]
[15,12,null,91,null,"3年行動　公共心・公徳心"]
[18,11,null,92,null,"部活動・特技等の記録（1年）"]
[17,11,null,93,null,"部活動・特技等の記録（1年）部活動名"]
[22,11,null,94,null,"部活動・特技等の記録（2年）"]
[21,11,null,95,null,"部活動・特技等の記録（2年）部活動名"]
[26,11,null,96,null,"部活動・特技等の記録（3年）"]
[25,11,null,97,null,"部活動・特技等の記録（3年）部活動名"]
[30,11,null,98,null,"1年出欠　欠席日数"]
[30,12,null,99,null,"1年出欠　遅早回数"]
[31,11,null,100,null,"2年出欠　欠席日数"]
[31,12,null,101,null,"2年出欠　遅早回数"]
[32,11,null,102,null,"3年出欠　欠席日数"]
[32,12,null,103,null,"3年出欠　遅早回数"]
[35,2,null,104,null,"総合所見等"]
[33,11,null,105,null,"体力テスト"]
[38,5,2,5,null,"中学校名"]
[39,5,2,9,null,"校長名"]
[40,5,2,14,null,"電話番号"]
[41,5,3,5,null,"学校Eメールアドレス"]
[42,5,3,9,null,"記入日"]
[42,11,3,14,null,"記入者"]

{"sheet":"日立印刷","index":3,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":true,"merged":[[41,4,41,7],[41,10,41,11],[40,1,40,3],[40,4,40,11],[34,1,34,11],[37,1,37,3],[37,4,37,11],[38,1,38,3],[38,4,38,11],[39,1,39,3],[39,4,39,11],[31,2,31,3],[31,8,31,9],[32,2,32,3],[32,8,32,9],[32,10,32,11],[33,1,33,11],[28,2,28,3],[28,8,28,9],[29,2,29,3],[29,8,29,9],[30,1,32,1],[30,2,30,3],[30,5,32,5],[30,6,32,6],[30,7,32,7],[30,8,30,9],[27,1,29,1],[27,2,27,3],[27,5,29,5],[27,6,29,6],[27,7,29,7],[24,1,26,1],[24,2,24,3],[24,5,26,5],[24,6,26,6],[24,7,26,7],[21,6,23,6],[21,7,23,7],[21,9,23,9],[21,10,23,11],[22,2,22,3],[23,2,23,3],[24,10,24,11],[25,2,25,3],[25,9,27,9],[25,10,27,11],[26,2,26,3],[24,8,27,8],[17,9,19,9],[17,10,19,11],[18,1,20,1],[18,2,18,3],[18,5,20,5],[18,6,20,6],[18,7,20,7],[19,2,19,3],[20,2,20,3],[20,8,23,8],[15,1,17,1],[15,2,15,3],[15,5,17,5],[15,6,17,6],[15,7,17,7],[15,8,15,11],[16,2,16,3],[16,8,19,8],[16,10,16,11],[17,2,17,3],[20,10,20,11],[21,1,23,1],[21,2,21,3],[21,5,23,5],[12,1,14,1],[12,2,12,3],[12,5,14,5],[12,6,14,6],[12,7,14,7],[13,2,13,3],[14,2,14,3],[9,1,11,1],[9,2,9,3],[9,5,11,5],[9,6,11,6],[9,7,11,7],[10,2,10,3],[11,2,11,3],[1,1,1,2],[1,3,1,6],[1,8,1,9],[1,10,2,11],[2,1,2,2],[2,3,2,6],[2,8,2,9],[6,1,8,1],[6,2,6,3],[6,5,8,5],[6,6,8,6],[6,7,8,7],[7,2,7,3],[8,2,8,3],[3,1,3,7],[3,8,3,11],[4,1,5,1],[4,2,4,4],[4,5,4,7],[5,2,5,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,"創意工夫"]
[null,null,"思考・判断・表現",null,null,null,null,null,"思いやり・協力"]
[null,null,"主体的に学習に取り組む態度",null,null,null,null,null,"生命尊重・自然愛護"]
[null,"数　学","知識・技能",null,null,null,null,null,"勤労・奉仕"]
[null,null,"思考・判断・表現",null,null,null,null,null,"公正・公平"]
[null,null,"主体的に学習に取り組む態度",null,null,null,null,null,"公共心・公徳心"]
[null,"理　科","知識・技能",null,null,null,null,null,"特別活動･部活動･特技等の記録（具体的な大会の成績等も記入して下さい）"]
[null,null,"思考・判断・表現",null,null,null,null,null,"１年","所属部活動名"]
[null,null,"主体的に学習に取り組む態度",null,null,null,null,null,null,"記録"]
[null,"音　楽","知識・技能"]
[null,null,"思考・判断・表現"]
[null,null,"主体的に学習に取り組む態度",null,null,null,null,null,"２年","所属部活動名"]
[null,"美　術","知識・技能",null,null,null,null,null,null,"記録"]
[null,null,"思考・判断・表現"]
[null,null,"主体的に学習に取り組む態度"]
[null,"保健体育","知識・技能",null,null,null,null,null,"３年","所属部活動名"]
[null,null,"思考・判断・表現",null,null,null,null,null,null,"記録"]
[null,null,"主体的に学習に取り組む態度"]
[null,"技術・家庭","知識・技能"]
[null,null,"思考・判断・表現",null,null,null,null,null,"欠席・遅刻・早退について",null,"欠席日数","遅早回数"]
[null,null,"主体的に学習に取り組む態度",null,null,null,null,null,"１年"]
[null,"外国語","知識・技能",null,null,null,null,null,"２年"]
[null,null,"思考・判断・表現",null,null,null,null,null,"３年"]
[null,null,"主体的に学習に取り組む態度",null,null,null,null,null,"体力テスト"]
[null,"総合所見及び指導上参考となる諸事項、その他生徒についての連絡事項"]
[]
[null,"上記の者は2024年3月本校第3学年の課程を卒業見込者であり、その教育的発達記録に関し上記のとおり報告します。"]
[]
[null,"中学校名（義務教育学校名）"]
[null,"校長名"]
[null,"電話番号"]
[null,"学校Eメールアドレス"]
[null,"入力日付（記入日）",null,null,null,null,null,null,"入力者名（記入者名）"]
[null,"個人情報の取扱いについて",null,null,null,null,null,null,null,null,null,"高等課程 2024年度生用"]
[null,"※受験申し込みに際し、提供された個人情報は、入学試験実施に伴う業務のみに使用し、他の目的には使用致しません"]
[null,"※提供された個人情報は、当校が定める個人情報管理規則に基づき管理致します"]

{"sheet":"日立調査書原本","index":4,"n_rows":2,"n_cols":110,"rows_kept":2,"cut":false,"hidden":true,"merged":[[0,5,0,109]]}
[null,null,null,null,null,"確認用のCSVファイルを出力する。※確認用CSVファイルをアップロードしないようにご注意ください。"]
["組","番号","氏名","ふりがな","性別","生年月日","1年評定　国語","1年評定　社会","1年評定　数学","1年評定　理科","1年評定　音楽","1年評定　美術","1年評定　保健体育","1年評定　技術家庭","1年評定　外国語","2年評定　国語","2年評定　社会","2年評定　数学","2年評定　理科","2年評定　音楽","2年評定　美術","2年評定　保健体育","2年評定　技術家庭","2年評定　外国語","3年評定　国語","3年評定　社会","3年評定　数学","3年評定　理科","3年評定　音楽","3年評定　美術","3年評定　保健体育","3年評定　技術家庭","3年評定　外国語","観点別学習状況（3年）　国語　知識・技能","観点別学習状況（3年）　国語　思考・判断・表現","観点別学習状況（3年）　国語　主体的に学習に取り組む態度","観点別学習状況（3年）　社会　知識・技能","観点別学習状況（3年）　社会　思考・判断・表現","観点別学習状況（3年）　社会　主体的に学習に取り組む態度","観点別学習状況（3年）　数学　知識・技能","観点別学習状況（3年）　数学　思考・判断・表現","観点別学習状況（3年）　数学　主体的に学習に取り組む態度","観点別学習状況（3年）　理科　知識・技能","観点別学習状況（3年）　理科　思考・判断・表現","観点別学習状況（3年）　理科　主体的に学習に取り組む態度","観点別学習状況（3年）　音楽　知識・技能","観点別学習状況（3年）　音楽　思考・判断・表現","観点別学習状況（3年）　音楽　主体的に学習に取り組む態度","観点別学習状況（3年）　美術　知識・技能","観点別学習状況（3年）　美術　思考・判断・表現","観点別学習状況（3年）　美術　主体的に学習に取り組む態度","観点別学習状況（3年）　保健・体育　知識・技能","観点別学習状況（3年）　保健・体育　思考・判断・表現","観点別学習状況（3年）　保健・体育　主体的に学習に取り組む態度","観点別学習状況（3年）　技術・家庭　知識・技能","観点別学習状況（3年）　技術・家庭　思考・判断・表現","観点別学習状況（3年）　技術・家庭　主体的に学習に取り組む態度","観点別学習状況（3年）　外国語　知識・技能","観点別学習状況（3年）　外国語　思考・判断・表現","観点別学習状況（3年）　外国語　主体的に学習に取り組む態度","1年行動　基本的な生活習慣","1年行動　健康・体力の向上","1年行動　自主・自立","1年行動　責任感","1年行動　創意工夫","1年行動　思いやり・協力","1年行動　生命尊重・自然愛護","1年行動　勤労・奉仕","1年行動　公正・公平","1年行動　公共心・公徳心","2年行動　基本的な生活習慣","2年行動　健康・体力の向上","2年行動　自主・自立","2年行動　責任感","2年行動　創意工夫","2年行動　思いやり・協力","2年行動　生命尊重・自然愛護","2年行動　勤労・奉仕","2年行動　公正・公平","2年行動　公共心・公徳心","3年行動　基本的な生活習慣","3年行動　健康・体力の向上","3年行動　自主・自立","3年行動　責任感","3年行動　創意工夫","3年行動　思いやり・協力","3年行動　生命尊重・自然愛護","3年行動　勤労・奉仕","3年行動　公正・公平","3年行動　公共心・公徳心","部活動・特技等の記録（1年）","部活動・特技等の記録（1年）部活動名","部活動・特技等の記録（2年）","部活動・特技等の記録（2年）部活動名","部活動・特技等の記録（3年）","部活動・特技等の記録（3年）部活動名","1年出欠　欠席日数","1年出欠　遅早回数","2年出欠　欠席日数","2年出欠　遅早回数","3年出欠　欠席日数","3年出欠　遅早回数","総合所見等","体力テスト","中学校名","校長名","電話番号","学校Eメールアドレス","記入日","記入者"]

{"sheet":"書式設定","index":5,"n_rows":111,"n_cols":12,"rows_kept":111,"cut":false,"hidden":true,"merged":[]}
["日立調査書原本"]
["組","COPY","2"]
["番号","COPY","3",null,null,null,null,"■書式設定説明"]
["氏名","COPY","4",null,null,null,null,null,"書式識別文字列","書式説明","引数渡し方","例"]
["ふりがな","COPY","5",null,null,null,null,null,"CLASS","指定列の頭0埋め2桁を結合する","該当列【カンマ区切りの数値配列】","1,2"]
["性別","COPY","6",null,null,null,null,null,"CLASS_REPLACE_BLANK","削除文字列を空白に置換してから、頭0埋め2桁を結合する","削除文字列【カンマ区切りの文字列配列】\n該当列【カンマ区切りの数値配列】","組,番\n1,2"]
["生年月日","BIRTH","7",null,null,null,null,null,"RIGHT_CLASS","指定列の値の右側よりlength分取得し、左端（先頭）にpaddingを結合する","該当列番号【数値】,length【数値】,padding【文字列】","1,3,0"]
["1年評定　国語","COPY","8",null,null,null,null,null,"SUM","指定列の値をすべて加算","該当列【カンマ区切りの数値配列】","70,71,72,73,74,75,76,77,78"]
["1年評定　社会","COPY","9",null,null,null,null,null,"BLANK_SUM","合計欄が空白の時のみ合計計算変換","合計記載列【数値】,【合計換算用カンマ区切りの数値配列】","53,35,44"]
["1年評定　数学","COPY","10",null,null,null,null,null,"BIRTH","指定列の値を西暦→和暦変換\n【出力形式】\nge.m.d形式でH17.1.1のような形","該当列番号【数値】",6]
["1年評定　理科","COPY","11",null,null,null,null,null,"BIRTH3","年（元号）、月、日に分かれている指定列の値を和暦変換\n【出力形式】\nH17.1.1のような形","年（元号）【数値】,月【数値】,日【数値】","7,8,9"]
["1年評定　音楽","COPY","12",null,null,null,null,null,"C4TH_JOIN","半角スペースを挟んで結合する","該当列【カンマ区切りの数値配列】","65,66"]
["1年評定　美術","COPY","13",null,null,null,null,null,"COPY","該当列の値を取得する","該当列番号【数値】",6]
["1年評定　保健体育","COPY","14",null,null,null,null,null,"GRADUATION","既卒判定シートの生年月日（西暦）をもとに、卒業見込みと既卒を判定する","該当列番号【数値】",6]
["1年評定　技術家庭","COPY","15",null,null,null,null,null,"GRADUATION3","年（元号）、月、日が分かれている場合の既卒・卒業見込みを判定する","年（元号）【数値】,月【数値】,日【数値】","7,8,9"]
["1年評定　外国語","COPY","16",null,null,null,null,null,"COURSE","志望先に応じて取得元を変更する","複数行可能：志望先の列番号【数値】,入力列番号【数値】","41,43\n48,50\n55,57\n62,64"]
["2年評定　国語","COPY","17",null,null,null,null,null,"COURSE_EXTRA","HYPHEN\n志望先に応じて取得元を変更する\n科-コースという形をハイフンで分割し、出力順序の指定で最初か最後のどちらを取得するか決定する","複数行可能：志望先の列番号【数値】,入力列番号【数値】\n最終行：HYPHEN,出力順序【文字列,FIRSTまたはLAST】","120,121\n129,130\n138,139\n147,148\n156,157\n165,166\n174,175\n183,184\n190,191\nHYPHEN,FIRST"]
["2年評定　社会","COPY","18",null,null,null,null,null,"COURSE_EXTRA","PARENTHESES\n志望先に応じて取得元を変更する\n志望先(一般)という形のかっこ内部を取得する","複数行可能：志望先の列番号【数値】,入力列番号【数値】\n最終行：PARENTHESES","16,16\n17,17\n23,23\n27,27\n31,31\n35,35\nPARENTHESES"]
["2年評定　数学","COPY","19",null,null,null,null,null,"HEALTH","該当列の値を取得するが、もし空文字列だった際に、良好を取得する","該当列番号【数値】",66]
["2年評定　理科","COPY","20",null,null,null,null,null,"INSERT_STR","任意の文字列を挿入する\nもし、挿入する文字列にフォントを指定したい場合は、setFonts関数、「フォント設定」シートを使用する","任意文字列【文字列】","ご入力ください"]
["2年評定　音楽","COPY","21",null,null,null,null,null,"RADIO","指定列の値を確認し、検索文字列と合致した場合は、該当時出力文字列を出力する。もし、どの列とも合致しなかった場合は、その他の出力を出力する","先頭行：検索文字列【カンマ区切りの文字列配列】\n複数行可能：該当列番号【数値】,該当時出力文字列【文字列】\n最終行（省略可能）：ELSE,その他の出力【文字列、デフォルトは空文字列】","〇,○,◯\n2,男\n3,女\nELSE,入力無し"]
["2年評定　美術","COPY","22",null,null,null,null,null,"NOT_NULL_SELECT","指定列内で一番最初に値があった箇所を戻す\n指定列で左ほど、優先する","該当列【カンマ区切りの数値配列】","69,35"]
["2年評定　保健体育","COPY","23",null,null,null,null,null,"BLANK","空文字列を出力する","なし"]
["2年評定　技術家庭","COPY","24",null,null,null,null,null,"ROWCOPY","行固定として該当列の値を取得する","固定行番号,該当列番号【数値】","2,5"]
["2年評定　外国語","COPY","25"]
["3年評定　国語","COPY","26"]
["3年評定　社会","COPY","27"]
["3年評定　数学","COPY","28"]
["3年評定　理科","COPY","29"]
["3年評定　音楽","COPY","30"]
["3年評定　美術","COPY","31"]
["3年評定　保健体育","COPY","32"]
["3年評定　技術家庭","COPY","33"]
["3年評定　外国語","COPY","34"]
["観点別学習状況（3年）　国語　知識・技能","COPY","35"]
["観点別学習状況（3年）　国語　思考・判断・表現","COPY","36"]
["観点別学習状況（3年）　国語　主体的に学習に取り組む態度","COPY","37"]
["観点別学習状況（3年）　社会　知識・技能","COPY","38"]
["観点別学習状況（3年）　社会　思考・判断・表現","COPY","39"]
["観点別学習状況（3年）　社会　主体的に学習に取り組む態度","COPY","40"]
["観点別学習状況（3年）　数学　知識・技能","COPY","41"]
["観点別学習状況（3年）　数学　思考・判断・表現","COPY","42"]
["観点別学習状況（3年）　数学　主体的に学習に取り組む態度","COPY","43"]
["観点別学習状況（3年）　理科　知識・技能","COPY","44"]
["観点別学習状況（3年）　理科　思考・判断・表現","COPY","45"]
["観点別学習状況（3年）　理科　主体的に学習に取り組む態度","COPY","46"]
["観点別学習状況（3年）　音楽　知識・技能","COPY","47"]
["観点別学習状況（3年）　音楽　思考・判断・表現","COPY","48"]
["観点別学習状況（3年）　音楽　主体的に学習に取り組む態度","COPY","49"]
["観点別学習状況（3年）　美術　知識・技能","COPY","50"]
["観点別学習状況（3年）　美術　思考・判断・表現","COPY","51"]
["観点別学習状況（3年）　美術　主体的に学習に取り組む態度","COPY","52"]
["観点別学習状況（3年）　保健・体育　知識・技能","COPY","53"]
["観点別学習状況（3年）　保健・体育　思考・判断・表現","COPY","54"]
["観点別学習状況（3年）　保健・体育　主体的に学習に取り組む態度","COPY","55"]
["観点別学習状況（3年）　技術・家庭　知識・技能","COPY","56"]
["観点別学習状況（3年）　技術・家庭　思考・判断・表現","COPY","57"]
["観点別学習状況（3年）　技術・家庭　主体的に学習に取り組む態度","COPY","58"]
["観点別学習状況（3年）　外国語　知識・技能","COPY","59"]
["観点別学習状況（3年）　外国語　思考・判断・表現","COPY","60"]
["観点別学習状況（3年）　外国語　主体的に学習に取り組む態度","COPY","61"]
["1年行動　基本的な生活習慣","COPY","62"]
["1年行動　健康・体力の向上","COPY","63"]
["1年行動　自主・自立","COPY","64"]
["1年行動　責任感","COPY","65"]
["1年行動　創意工夫","COPY","66"]
["1年行動　思いやり・協力","COPY","67"]
["1年行動　生命尊重・自然愛護","COPY","68"]
["1年行動　勤労・奉仕","COPY","69"]
["1年行動　公正・公平","COPY","70"]
["1年行動　公共心・公徳心","COPY","71"]
["2年行動　基本的な生活習慣","COPY","72"]
["2年行動　健康・体力の向上","COPY","73"]
["2年行動　自主・自立","COPY","74"]
["2年行動　責任感","COPY","75"]
["2年行動　創意工夫","COPY","76"]
["2年行動　思いやり・協力","COPY","77"]
["2年行動　生命尊重・自然愛護","COPY","78"]
["2年行動　勤労・奉仕","COPY","79"]
["2年行動　公正・公平","COPY","80"]
["2年行動　公共心・公徳心","COPY","81"]
["3年行動　基本的な生活習慣","COPY","82"]
["3年行動　健康・体力の向上","COPY","83"]
["3年行動　自主・自立","COPY","84"]
["3年行動　責任感","COPY","85"]
["3年行動　創意工夫","COPY","86"]
["3年行動　思いやり・協力","COPY","87"]
["3年行動　生命尊重・自然愛護","COPY","88"]
["3年行動　勤労・奉仕","COPY","89"]
["3年行動　公正・公平","COPY","90"]
["3年行動　公共心・公徳心","COPY","91"]
["部活動・特技等の記録（1年）","COPY","92"]
["部活動・特技等の記録（1年）部活動名","COPY","93"]
["部活動・特技等の記録（2年）","COPY","94"]
["部活動・特技等の記録（2年）部活動名","COPY","95"]
["部活動・特技等の記録（3年）","COPY","96"]
["部活動・特技等の記録（3年）部活動名","COPY","97"]
["1年出欠　欠席日数","COPY","98"]
["1年出欠　遅早回数","COPY","99"]
["2年出欠　欠席日数","COPY","100"]
["2年出欠　遅早回数","COPY","101"]
["3年出欠　欠席日数","COPY","102"]
["3年出欠　遅早回数","COPY","103"]
["総合所見等","COPY","104"]
["体力テスト","COPY","105"]
["中学校名","ROWCOPY","2,5"]
["校長名","ROWCOPY","2,9"]
["電話番号","ROWCOPY","2,14"]
["学校Eメールアドレス","ROWCOPY","3,5"]
["記入日","ROWCOPY","3,9"]
["記入者","ROWCOPY","3,14"]