{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["元名簿","座席","座席ナンバー","座席可変","理科室_先生から42","理科室_子から42"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":56,"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":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,11,1,12]]}
["No.","名前","性別","苗字（関数）","苗字（値）","男子","女子",null,null,null,null,null,null,null,"ランダムに\n男女混合","乱数(値）","乱数(式）","男女交互"]
[1,"石田　愛美","女",{"$f":"IFERROR(TRIM(LEFT($B2,FIND(\" \",$B2))),IFERROR(TRIM(LEFT($B2,FIND(\"　\",$B2))),\"\"))","v":"石田"},null,null,null,null,5,"年",null,"マクロ終了まで\n変化",null,null,null,null,{"$f":"RAND()","v":2.9282681901091734E-2},"伊藤"]
[2,"伊藤　勉","男","伊藤",null,null,null,null,3,"組",null,"男人数","女人数",null,null,null,{"$f":"RAND()","v":6.0092071114894785E-2},"石田"]
[3,"上杉　工","男","上杉",null,null,null,null,{"$f":"COUNTA($B$2:$B$46)","v":38},"人",null,{"$f":"COUNTIF(F$2:F$25,\"*?\")","v":0},{"$f":"COUNTIF(G$2:G$25,\"*?\")","v":0},null,null,null,0.54688156180119063,"上杉"]
[4,"上戸　架純","女","上戸",null,null,null,null,null,null,null,null,null,null,null,null,0.3716608041306253,"上戸"]
[5,"大石　心","男","大石",null,null,null,null,null,null,null,null,null,null,null,null,0.82128939825293745,"大石"]
[6,"大久保　太郎","男","大久保",null,null,null,null,null,null,null,null,null,null,null,null,0.37572337271367462,"菅野"]
[7,"大久保　敏夫","男","大久保",null,null,null,null,null,null,null,null,null,null,null,null,0.62310103574581277,"大久保"]
[8,"織田　翼","男","織田",null,null,null,null,null,null,null,null,null,null,null,null,0.23106456996018787,"木戸"]
[9,"菅野　結菜","女","菅野",null,null,null,null,null,null,null,null,null,null,null,null,0.20291059828695168,"大久保"]
[10,"木戸　くるみ","女","木戸",null,null,null,null,null,null,null,null,null,null,null,null,8.8841834330293579E-2,"栗山"]
[11,"木下　悠吾","男","木下",null,null,null,null,null,null,null,null,null,null,null,null,0.20798432202268213,"織田"]
[12,"国仲　海斗","男","国仲",null,null,null,null,null,null,null,null,null,null,null,null,0.60012838817550618,"小池"]
[13,"熊田　涼太","男","熊田",null,null,null,null,null,null,null,null,null,null,null,null,6.5294613006610436E-2,"木下"]
[14,"栗山　綾乃","女","栗山",null,null,null,null,null,null,null,null,null,null,null,null,0.14050950416623909,"小松"]
[15,"小池　優衣","女","小池",null,null,null,null,null,null,null,null,null,null,null,null,0.57297807800593159,"国仲"]
[16,"小松　美智子","女","小松",null,null,null,null,null,null,null,null,null,null,null,null,0.17145592980364255,"坂本"]
[17,"近藤　優輝","男","近藤",null,null,null,null,null,null,null,null,null,null,null,null,0.79829743173197232,"熊田"]
[18,"西郷　啓太","男","西郷",null,null,null,null,null,null,null,null,null,null,null,null,0.24111237968944799,"佐藤"]
[19,"坂本　愛莉","女","坂本",null,null,null,null,null,null,null,null,null,null,null,null,0.97762990555930385,"近藤"]
[20,"佐藤　琴音","女","佐藤",null,null,null,null,null,null,null,null,null,null,null,null,0.7913158645594448,"柴咲"]
[21,"篠原 翔","男",{"$f":"IFERROR(TRIM(LEFT($B22,FIND(\" \",$B22))),IFERROR(TRIM(LEFT($B22,FIND(\"　\",$B22))),\"\"))","v":"篠原"},null,null,null,null,null,null,null,null,null,null,null,null,0.30322230146728713,"西郷"]
[22,"柴咲　真理","女",{"$f":"IFERROR(TRIM(LEFT($B23,FIND(\" \",$B23))),IFERROR(TRIM(LEFT($B23,FIND(\"　\",$B23))),\"\"))","v":"柴咲"},null,null,null,null,null,null,null,null,null,null,null,null,6.4064327690854572E-2,"島田"]
[23,"島田　美優","女","島田",null,null,null,null,null,null,null,null,null,null,null,null,0.27226899094534696,"篠原"]
[24,"瀬戸　真央","女","瀬戸",null,null,null,null,null,null,null,null,null,null,null,null,0.46002340085150006,"瀬戸"]
[25,"高杉　芽衣","女","高杉",null,null,null,null,null,null,null,null,null,null,null,null,0.80558635518661326,"武田"]
[26,"武田　太一","男","武田",null,null,null,null,null,null,null,null,null,null,null,null,0.39589577951502164,"高杉"]
[27,"遠山　蒼太","男","遠山",null,null,null,null,null,null,null,null,null,null,null,null,0.32707912637369807,"遠山"]
[28,"徳川　大輝","男","徳川",null,null,null,null,null,null,null,null,null,null,null,null,0.34600006785460391,"長澤"]
[29,"長澤　美緒","女","長澤",null,null,null,null,null,null,null,null,null,null,null,null,0.50202127481392267,"徳川"]
[30,"夏木　彩音","女","夏木",null,null,null,null,null,null,null,null,null,null,null,null,0.18367966057685636,"夏木"]
[31,"野田　健太","男","野田",null,null,null,null,null,null,null,null,null,null,null,null,5.7109490146563191E-2,"野田"]
[32,"平賀　真衣","女","平賀",null,null,null,null,null,null,null,null,null,null,null,null,0.46587270998984143,"平賀"]
[33,"広末　未来","女","広末",null,null,null,null,null,null,null,null,null,null,null,null,0.27313427863437834,"深田"]
[34,"深田　雄太","男","深田",null,null,null,null,null,null,null,null,null,null,null,null,0.21541190395053866,"広末"]
[35,"福沢　陽太","男","福沢",null,null,null,null,null,null,null,null,null,null,null,null,3.6668446895156137E-2,"福沢"]
[36,"堀北　美由紀","女","堀北",null,null,null,null,null,null,null,null,null,null,null,null,6.3114184606864243E-2,"堀北"]
[37,"松尾　歩","男","松尾",null,null,null,null,null,null,null,null,null,null,null,null,0.18013954478083005,"松尾"]
[38,"宮本　瑛大","男","宮本",null,null,null,null,null,null,null,null,null,null,null,null,0.34444444839601618,"宮本"]
[39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.30047081872684156]
[40,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,0.78094272555855171]
[41,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,0.85523895122512605]
[42,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,0.99719512864618187]
[43,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,0.81614635964121707]

{"sheet":"座席","index":1,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,4,17,5],[1,14,1,15]]}
[null,"先生から",null,null,null,null,null,null,null,null,null,"子どもから"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"学年 & \"-\" & 組","v":"5-3"},null,"先生"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"学年 & \"-\" & 組","v":"5-3"},null,"先生"]
[]
["人数",{"$f":"COUNTA(B4:B16)","v":0},{"$f":"COUNTA(C4:C16)","v":0},null,0,0,null,0,{"$f":"COUNTA(I4:I16)","v":0}]

{"sheet":"座席ナンバー","index":2,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,12,1,13],[11,3,11,4],[29,3,29,4],[25,12,27,12],[25,14,27,17],[26,1,26,7],[18,8,18,11]]}
[null,"先生から",null,null,null,null,null,null,null,"子どもから"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"学年 & \"-\" & 組","v":"5-3"},null,"先生"]
[]
[null,{"$f":"IFERROR(VLOOKUP(B20,名列,4,FALSE),\"\")","v":""},"","","","","",{"$f":"IFERROR(VLOOKUP(H20,名列,4,FALSE),\"\")","v":""}]
[null,"","","","","","",{"$f":"IFERROR(VLOOKUP(H21,名列,4,FALSE),\"\")","v":""}]
[null,"","","","","","",{"$f":"IFERROR(VLOOKUP(H22,名列,4,FALSE),\"\")","v":""}]
[null,"","","","","","",{"$f":"IFERROR(VLOOKUP(H23,名列,4,FALSE),\"\")","v":""}]
[null,"","","","","","",{"$f":"IFERROR(VLOOKUP(H24,名列,4,FALSE),\"\")","v":""}]
[null,"","","","","","",{"$f":"IFERROR(VLOOKUP(H25,名列,4,FALSE),\"\")","v":""}]
[null,"","","","","","",{"$f":"IFERROR(VLOOKUP(H26,名列,4,FALSE),\"\")","v":""}]
[]
[null,null,{"$f":"学年 & \"-\" & 組","v":"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,19,"まで"]
[null,null,null,null,null,null,null,null,"後半"]
[null,null,null,null,null,null,null,null,{"$f":"前半ここまで+1","v":20},"から"]
[null,null,null,null,null,null,null,null,null,null,null,null,"順番抜かす",null,"順番を抜かす番号の児童が座る席は\n「予約」の文字を入力"]
[null,"↓　ここにそれぞれのを人数してください　↓",null,null,null,null,null,null,null,"合計"]
[null,7,6,6,6,6,7,null,null,{"$f":"SUM(B28:H28)","v":38},{"$f":"\"←\" & クラス人数 & \"以上\"","v":"←38以上"}]
[null,null,null,null,null,null,null,null,null,"↑クラス人数以上"]
[null,null,null,"先生"]

{"sheet":"座席可変","index":3,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,17,19,18],[9,5,9,6]]}
[null,"先生から　この座席表からは理科室の席は作られない。"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"学年 & \"-\" & 組","v":"5-3"},"先生"]
[null,null,null,null,null,null,null,null,null,null,null,"合計"]
["人数",6,6,null,5,5,5,null,6,6,null,{"$f":"SUM(B12:K13)","v":39}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"子どもから",null,{"$f":"学年 & \"-\" & 組","v":"5-3"},null,"先生"]

{"sheet":"理科室_先生から42","index":4,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,5,12,7],[2,23,5,23],[7,2,10,2],[7,6,10,6],[7,10,10,10],[7,15,10,15],[7,19,10,19],[7,23,10,23],[2,2,5,2],[2,6,5,6],[2,10,5,10],[2,15,5,15],[2,19,5,19],[12,18,12,20]]}
[]
[null,{"$f":"学年 & \"-\" & 組","v":"5-3"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"学年 & \"-\" & 組","v":"5-3"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"先生",null,null,null,null,null,null,null,null,null,null,null,null,"先生"]

{"sheet":"理科室_子から42","index":5,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,5,1,7]]}
[]
[null,{"$f":"学年 & \"-\" & 組","v":"5-3"},null,null,null,"先生"]
[]
[null,{"$f":"理科室_先生から42!Y11","v":0},null,{"$f":"理科室_先生から42!W11","v":0},null,{"$f":"理科室_先生から42!U11","v":0},null,{"$f":"理科室_先生から42!S11","v":0},null,{"$f":"理科室_先生から42!Q11","v":0},null,{"$f":"理科室_先生から42!O11","v":0}]
[null,{"$f":"理科室_先生から42!Y10","v":0},null,{"$f":"理科室_先生から42!W10","v":0},null,{"$f":"理科室_先生から42!U10","v":0},null,{"$f":"理科室_先生から42!S10","v":0},null,{"$f":"理科室_先生から42!Q10","v":0},null,{"$f":"理科室_先生から42!O10","v":0}]
[null,{"$f":"理科室_先生から42!Y9","v":0},null,{"$f":"理科室_先生から42!W9","v":0},null,{"$f":"理科室_先生から42!U9","v":0},null,{"$f":"理科室_先生から42!S9","v":0},null,{"$f":"理科室_先生から42!Q9","v":0},null,{"$f":"理科室_先生から42!O9","v":0}]
[null,{"$f":"理科室_先生から42!Y8","v":0},null,{"$f":"理科室_先生から42!W8","v":0},null,{"$f":"理科室_先生から42!U8","v":0},null,{"$f":"理科室_先生から42!S8","v":0},null,null,null,{"$f":"理科室_先生から42!O8","v":0}]
[]
[null,{"$f":"理科室_先生から42!Y6","v":0},null,{"$f":"理科室_先生から42!W6","v":0},null,{"$f":"理科室_先生から42!U6","v":0},null,{"$f":"理科室_先生から42!S6","v":0},null,{"$f":"理科室_先生から42!Q6","v":0},null,{"$f":"理科室_先生から42!O6","v":0}]
[null,{"$f":"理科室_先生から42!Y5","v":0},null,{"$f":"理科室_先生から42!W5","v":0},null,{"$f":"理科室_先生から42!U5","v":0},null,{"$f":"理科室_先生から42!S5","v":0},null,{"$f":"理科室_先生から42!Q5","v":0},null,{"$f":"理科室_先生から42!O5","v":0}]
[null,{"$f":"理科室_先生から42!Y4","v":0},null,{"$f":"理科室_先生から42!W4","v":0},null,{"$f":"理科室_先生から42!U4","v":0},null,{"$f":"理科室_先生から42!S4","v":0},null,{"$f":"理科室_先生から42!Q4","v":0},null,{"$f":"理科室_先生から42!O4","v":0}]
[null,{"$f":"理科室_先生から42!Y3","v":0},null,{"$f":"理科室_先生から42!W3","v":0},null,{"$f":"理科室_先生から42!U3","v":0},null,{"$f":"理科室_先生から42!S3","v":0},null,{"$f":"理科室_先生から42!Q3","v":0},null,{"$f":"理科室_先生から42!O3","v":0}]