{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["一覧","選択肢_H","ピボット","ピボット_H","グラフ","選択肢設定","1日あたり件数"],"not_rendered":{"charts":11,"images":0,"macros":1,"external_links":0,"defined_names":28,"comments":0,"pivot_tables":12},"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":2,"n_cols":25,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["発生年","発生月","発生日","発生年月日","曜日","学年","組","児童生徒","指導担当者","場所","場所の詳細","時間帯","時間帯の詳細","指導対象の行動","行動の詳細","指導内容","指導内容の詳細","共有・報告先","報告先の詳細","家庭連絡","連絡方法","連絡方法の詳細","連絡相手","連絡相手の詳細","その他詳細"]
["2024年","1月","1日","2024-01-01","月曜日","1年","1組","テスト　生徒","テスト　教師","教室",null,"始業前",null,"暴力(対生徒)",null,"その場で注意・やり直し",null,"担任",null,"連絡なし"]

{"sheet":"選択肢_H","index":1,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["児童生徒","指導担当者","西暦","月","日","学年","組","場所","時間帯","指導対象の行動","指導内容","共有・報告","家庭連絡","連絡方法","連絡相手"]
[{"$f":"IFERROR(_xlfn.UNIQUE(_xlfn._xlws.FILTER(一覧[児童生徒],(一覧[児童生徒]<>\"\")*(一覧[児童生徒]<>0))),\"\")","v":"テスト　生徒"},{"$f":"IFERROR(_xlfn.UNIQUE(_xlfn._xlws.FILTER(一覧[指導担当者],(一覧[指導担当者]<>\"\")*(一覧[指導担当者]<>0))),\"\")","v":"テスト　教師"},{"$f":"YEAR(NOW())-1&\"年\"","v":"2023年"},"1月","1日",{"$f":"_xlfn._xlws.FILTER(テーブル_選択肢[学年],テーブル_選択肢[学年]<>0)","v":"1年"},{"$f":"_xlfn._xlws.FILTER(テーブル_選択肢[組],テーブル_選択肢[組]<>0)","v":"1組"},{"$f":"_xlfn._xlws.FILTER(テーブル_選択肢[場所],テーブル_選択肢[場所]<>0)","v":"教室"},{"$f":"_xlfn._xlws.FILTER(テーブル_選択肢[時間帯],テーブル_選択肢[時間帯]<>0)","v":"始業前"},{"$f":"_xlfn._xlws.FILTER(テーブル_選択肢[指導対象の行動],テーブル_選択肢[指導対象の行動]<>0)","v":"暴力(対生徒)"},{"$f":"_xlfn._xlws.FILTER(テーブル_選択肢[指導内容],テーブル_選択肢[指導内容]<>0)","v":"その場で注意・やり直し"},{"$f":"_xlfn._xlws.FILTER(テーブル_選択肢[共有・報告先],テーブル_選択肢[共有・報告先]<>0)","v":"担任"},"連絡なし",{"$f":"_xlfn._xlws.FILTER(テーブル_選択肢[連絡方法],テーブル_選択肢[連絡方法]<>0)","v":"家庭訪問"},{"$f":"_xlfn._xlws.FILTER(テーブル_選択肢[連絡相手],テーブル_選択肢[連絡相手]<>0)","v":"父"}]
[null,null,{"$f":"YEAR(NOW())&\"年\"","v":"2024年"},"2月","2日","2年","2組","ろうか","1時間目","暴力(対教師)","別室での個別指導","学年","連絡あり","電話連絡","母"]
[null,null,null,"3月","3日","3年","3組","トイレ","休み時間（１限後）","けんか","奉仕活動","生徒指導部長",null,"その他※要入力","その他"]
[null,null,null,"4月","4日","4年","4組","運動場","2時間目","暴言","自己を振り返る活動","生徒指導主事"]
[null,null,null,"5月","5日","5年","5組","体育館","休み時間（２限後）","いじめ・嫌がらせ","適切な行動の再指導","教頭"]
[null,null,null,"6月","6日","6年","6組","校外","3時間目","授業妨害","その他※要入力","校長"]
[null,null,null,"7月","7日",null,"7組","その他※要入力","休み時間（３限後）","器物損壊",null,"その他※要入力"]
[null,null,null,"8月","8日",null,"8組",null,"4時間目","他者私物隠蔽破損等"]
[null,null,null,"9月","9日",null,null,null,"給食","不服従"]
[null,null,null,"10月","10日",null,null,null,"昼休み","徘徊／さぼり"]
[null,null,null,"11月","11日",null,null,null,"5時間目","不適切な場所への立入"]
[null,null,null,"12月","12日",null,null,null,"休み時間（５限後）","その他※要入力"]
[null,null,null,null,"13日",null,null,null,"6時間目"]
[null,null,null,null,"14日",null,null,null,"掃除"]
[null,null,null,null,"15日",null,null,null,"放課後（校内）"]
[null,null,null,null,"16日",null,null,null,"放課後（校外）"]
[null,null,null,null,"17日",null,null,null,"その他※要入力"]
[null,null,null,null,"18日"]
[null,null,null,null,"19日"]
[null,null,null,null,"20日"]
[null,null,null,null,"21日"]
[null,null,null,null,"22日"]
[null,null,null,null,"23日"]
[null,null,null,null,"24日"]
[null,null,null,null,"25日"]
[null,null,null,null,"26日"]
[null,null,null,null,"27日"]
[null,null,null,null,"28日"]
[null,null,null,null,"29日"]
[null,null,null,null,"30日"]
[null,null,null,null,"31日"]

{"sheet":"ピボット","index":2,"n_rows":14,"n_cols":28,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["行ラベル","個数 / 月",null,"行ラベル","個数 / 児童生徒",null,"行ラベル","個数 / 場所",null,"行ラベル","個数 / 時間帯",null,"行ラベル","個数 / 指導対象の行動",null,"行ラベル","個数 / 指導内容",null,"行ラベル","個数 / 曜日",null,"行ラベル","合計 / 1日あたり件数",null,"個数 / 児童生徒","列ラベル"]
["2024年",1,null,"テスト　生徒",1,null,"教室",1,null,"始業前",1,null,"暴力(対生徒)",1,null,"その場で注意・やり直し",1,null,"月曜日",1,null,"4月",0,null,"行ラベル","暴力(対生徒)","(空白)","総計"]
["1月",1,null,"総計",1,null,"総計",1,null,"総計",1,null,"総計",1,null,"総計",1,null,"総計",1,null,"5月",0,null,"(空白)"]
["総計",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6月",0,null,"(空白)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7月",0,null,"2024年",1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8月",0,null,"1月",1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9月",0,null,"総計",1,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10月",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11月",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12月",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1月",0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2月",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3月",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総計",0.04]

{"sheet":"ピボット_H","index":3,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["個数 / 児童生徒","列ラベル"]
["行ラベル","その場で注意・やり直し","総計"]
["暴力(対生徒)",1,1]
["総計",1,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["個数 / 児童生徒","列ラベル"]
["行ラベル","始業前","総計"]
["教室",1,1]
["総計",1,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["行ラベル","個数 / 児童生徒"]
["1年",1]
["1組",1]
["総計",1]

{"sheet":"グラフ","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"選択肢設定","index":5,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["学年","組","場所","時間帯","指導対象の行動","指導内容","共有・報告先","連絡方法","連絡相手",null,"月","授業日数"]
["1年","1組","教室","始業前","暴力(対生徒)","その場で注意・やり直し","担任","家庭訪問","父",null,"4月",20]
["2年","2組","ろうか","1時間目","暴力(対教師)","別室での個別指導","学年","電話連絡","母",null,"5月",23]
["3年","3組","トイレ","休み時間（１限後）","けんか","奉仕活動","生徒指導部長","その他※要入力","その他",null,"6月",22]
["4年","4組","運動場","2時間目","暴言","自己を振り返る活動","生徒指導主事",null,null,null,"7月",21]
["5年","5組","体育館","休み時間（２限後）","いじめ・嫌がらせ","適切な行動の再指導","教頭",null,null,null,"8月",23]
["6年","6組","校外","3時間目","授業妨害","その他※要入力","校長",null,null,null,"9月",21]
[null,"7組","その他※要入力","休み時間（３限後）","器物損壊",null,"その他※要入力",null,null,null,"10月",22]
[null,"8組",null,"4時間目","他者私物隠蔽破損等",null,null,null,null,null,"11月",22]
[null,null,null,"給食","不服従",null,null,null,null,null,"12月",21]
[null,null,null,"昼休み","徘徊／さぼり",null,null,null,null,null,"1月",23]
[null,null,null,"5時間目","不適切な場所への立入",null,null,null,null,null,"2月",21]
[null,null,null,"休み時間（５限後）","その他※要入力",null,null,null,null,null,"3月",21]
[null,null,null,"6時間目"]
[null,null,null,"掃除"]
[null,null,null,"放課後（校内）"]
[null,null,null,"放課後（校外）"]
[null,null,null,"その他※要入力"]

{"sheet":"1日あたり件数","index":6,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["月","授業日数","件数","1日あたり件数"]
["4月",20,0,0]
["5月",23,0,0]
["6月",22,0,0]
["7月",21,0,0]
["8月",23,0,0]
["9月",21,0,0]
["10月",22,0,0]
["11月",22,0,0]
["12月",21,0,0]
["1月",23,1,0.04]
["2月",21,0,0]
["3月",21,0,0]