{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["元名簿","座席","座席可変","理科室_先生から42","理科室_子から42"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":32,"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":48,"n_cols":18,"rows_kept":48,"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,7,"年",null,"マクロ終了まで\n変化",null,null,null,null,{"$f":"RAND()","v":0.42436212904897763},"伊藤"]
[2,"伊藤　勉","男","伊藤",null,null,null,null,9,"組",null,"男人数","女人数",null,null,null,{"$f":"RAND()","v":0.30953125004884319},"石田"]
[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.39450922079113548,"上杉"]
[4,"上戸　架純","女","上戸",null,null,null,null,null,null,null,null,null,null,null,null,0.81029499087663093,"上戸"]
[5,"大石　心","男","大石",null,null,null,null,null,null,null,null,null,null,null,null,0.92503852167193445,"大石"]
[6,"大久保　太郎","男","大久保",null,null,null,null,null,null,null,null,null,null,null,null,0.46620937930237205,"菅野"]
[7,"大久保　敏夫","男","大久保",null,null,null,null,null,null,null,null,null,null,null,null,5.4356724996600159E-2,"大久保"]
[8,"織田　翼","男","織田",null,null,null,null,null,null,null,null,null,null,null,null,0.91352085017488516,"木戸"]
[9,"菅野　結菜","女","菅野",null,null,null,null,null,null,null,null,null,null,null,null,0.27052921602440072,"大久保"]
[10,"木戸　くるみ","女","木戸",null,null,null,null,null,null,null,null,null,null,null,null,0.45070775419094877,"栗山"]
[11,"木下　悠吾","男","木下",null,null,null,null,null,null,null,null,null,null,null,null,0.30271667921320011,"織田"]
[12,"国仲　海斗","男","国仲",null,null,null,null,null,null,null,null,null,null,null,null,0.21497857071820758,"小池"]
[13,"熊田　涼太","男","熊田",null,null,null,null,null,null,null,null,null,null,null,null,2.0009530815313092E-2,"木下"]
[14,"栗山　綾乃","女","栗山",null,null,null,null,null,null,null,null,null,null,null,null,0.26451590572052808,"小松"]
[15,"小池　優衣","女","小池",null,null,null,null,null,null,null,null,null,null,null,null,0.95338072314578504,"国仲"]
[16,"小松　美智子","女","小松",null,null,null,null,null,null,null,null,null,null,null,null,0.98847077552576734,"坂本"]
[17,"近藤　優輝","男","近藤",null,null,null,null,null,null,null,null,null,null,null,null,0.19511315202848933,"熊田"]
[18,"西郷　啓太","男","西郷",null,null,null,null,null,null,null,null,null,null,null,null,0.29029616239616729,"佐藤"]
[19,"坂本　愛莉","女","坂本",null,null,null,null,null,null,null,null,null,null,null,null,0.38535710652303712,"近藤"]
[20,"佐藤　琴音","女","佐藤",null,null,null,null,null,null,null,null,null,null,null,null,0.60354922810230804,"柴咲"]
[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,6.7032380189351093E-2,"西郷"]
[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,0.25550560881763795,"島田"]
[23,"島田　美優","女","島田",null,null,null,null,null,null,null,null,null,null,null,null,7.3177697955970844E-2,"篠原"]
[24,"瀬戸　真央","女","瀬戸",null,null,null,null,null,null,null,null,null,null,null,null,0.62016361267794395,"瀬戸"]
[25,"高杉　芽衣","女","高杉",null,null,null,null,null,null,null,null,null,null,null,null,0.11472407440814292,"武田"]
[26,"武田　太一","男","武田",null,null,null,null,null,null,null,null,null,null,null,null,0.91945025556527449,"高杉"]
[27,"遠山　蒼太","男","遠山",null,null,null,null,null,null,null,null,null,null,null,null,0.6748148928151082,"遠山"]
[28,"徳川　大輝","男","徳川",null,null,null,null,null,null,null,null,null,null,null,null,0.4056573904192371,"長澤"]
[29,"長澤　美緒","女","長澤",null,null,null,null,null,null,null,null,null,null,null,null,0.82430739958186683,"徳川"]
[30,"夏木　彩音","女","夏木",null,null,null,null,null,null,null,null,null,null,null,null,0.68636416388639632,"夏木"]
[31,"野田　健太","男","野田",null,null,null,null,null,null,null,null,null,null,null,null,0.89256753126893229,"野田"]
[32,"平賀　真衣","女","平賀",null,null,null,null,null,null,null,null,null,null,null,null,0.62004991174662705,"平賀"]
[33,"広末　未来","女","広末",null,null,null,null,null,null,null,null,null,null,null,null,0.61045371130829351,"深田"]
[34,"深田　雄太","男","深田",null,null,null,null,null,null,null,null,null,null,null,null,0.67540137362948438,"広末"]
[35,"福沢　陽太","男","福沢",null,null,null,null,null,null,null,null,null,null,null,null,0.11233534325420802,"福沢"]
[36,"堀北　美由紀","女","堀北",null,null,null,null,null,null,null,null,null,null,null,null,0.42011967727158661,"堀北"]
[37,"松尾　歩","男","松尾",null,null,null,null,null,null,null,null,null,null,null,null,8.5391012352956652E-2,"松尾"]
[38,"宮本　瑛大","男","宮本",null,null,null,null,null,null,null,null,null,null,null,null,0.46850950691687177,"宮本"]
[39,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,1.4137633070976596E-2]
[40,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.49572890397583202]
[41,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.65184257483601371]
[42,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.85586991567712234]
[43,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.43321121995304401]
[]
[]
[null,"眞鍋　あかり","女"]
[null,"宮﨑　遥","女"]

{"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":"7-9"},null,"先生"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"学年 & \"-\" & 組","v":"7-9"},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":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":"7-9"},"先生"]
[null,null,null,null,null,null,null,null,null,null,null,"合計"]
["人数",6,6,null,5,5,5,null,6,6,null,{"$f":"SUM(B12:K12)","v":39}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"子どもから",null,{"$f":"学年 & \"-\" & 組","v":"7-9"},null,"先生"]

{"sheet":"理科室_先生から42","index":3,"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":"7-9"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"学年 & \"-\" & 組","v":"7-9"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"先生",null,null,null,null,null,null,null,null,null,null,null,null,"先生"]

{"sheet":"理科室_子から42","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,5,1,7]]}
[]
[null,{"$f":"学年 & \"-\" & 組","v":"7-9"},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}]