{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["元名簿","座席","理科室_先生から42","理科室_子から42"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"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,7,"年",null,"マクロ終了まで\n変化",null,null,null,null,{"$f":"RAND()","v":0.70040218596770853}]
[2,"伊藤　勉","男","伊藤",null,null,null,null,7,"組",null,"男人数","女人数",null,null,null,{"$f":"RAND()","v":3.0640723272951642E-2}]
[3,"上杉　工","男","上杉",null,null,null,null,{"$f":"COUNTA($B$2:$B$46)","v":40},"人",null,{"$f":"COUNTIF(F$2:F$25,\"*?\")","v":0},{"$f":"COUNTIF(G$2:G$25,\"*?\")","v":0},null,null,null,0.91290948171514286]
[4,"上戸　架純","女","上戸",null,null,null,null,null,null,null,null,null,null,null,null,0.42046678099997392]
[5,"大石　心","男","大石",null,null,null,null,null,null,null,null,null,null,null,null,0.52548856875359728]
[6,"大久保　征悦","男","大久保",null,null,null,null,null,null,null,null,null,null,null,null,0.64065803811745192]
[7,"大久保　太郎","男","大久保",null,null,null,null,null,null,null,null,null,null,null,null,0.35748161446468463]
[8,"織田　翼","男","織田",null,null,null,null,null,null,null,null,null,null,null,null,0.32055517391768595]
[9,"菅野　結菜","女","菅野",null,null,null,null,null,null,null,null,null,null,null,null,0.25058666611470282]
[10,"木戸　くるみ","女","木戸",null,null,null,null,null,null,null,null,null,null,null,null,0.34912857645042028]
[11,"木下　悠吾","男","木下",null,null,null,null,null,null,null,null,null,null,null,null,0.942707702732129]
[12,"国仲　海斗","男","国仲",null,null,null,null,null,null,null,null,null,null,null,null,0.35790525287013686]
[13,"熊田　涼太","男","熊田",null,null,null,null,null,null,null,null,null,null,null,null,0.15045455527246743]
[14,"栗山　綾乃","女","栗山",null,null,null,null,null,null,null,null,null,null,null,null,0.70411892557044498]
[15,"小池　優衣","女","小池",null,null,null,null,null,null,null,null,null,null,null,null,0.10961996647953154]
[16,"小松　美智子","女","小松",null,null,null,null,null,null,null,null,null,null,null,null,0.12531903567659841]
[17,"近藤　優輝","男","近藤",null,null,null,null,null,null,null,null,null,null,null,null,0.53116156813943505]
[18,"西郷　啓太","男","西郷",null,null,null,null,null,null,null,null,null,null,null,null,0.32352927788058727]
[19,"坂本　愛莉","女","坂本",null,null,null,null,null,null,null,null,null,null,null,null,0.96200772991832895]
[20,"佐藤　琴音","女","佐藤",null,null,null,null,null,null,null,null,null,null,null,null,9.4983921765753321E-2]
[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.88052149022449089]
[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.1668857564594195]
[23,"島田　美優","女","島田",null,null,null,null,null,null,null,null,null,null,null,null,0.73174795349992772]
[24,"瀬戸　真央","女","瀬戸",null,null,null,null,null,null,null,null,null,null,null,null,0.20879115407710369]
[25,"高杉　芽衣","女","高杉",null,null,null,null,null,null,null,null,null,null,null,null,0.77817114088982997]
[26,"武田　太一","男","武田",null,null,null,null,null,null,null,null,null,null,null,null,0.84103751933961146]
[27,"遠山　蒼太","男","遠山",null,null,null,null,null,null,null,null,null,null,null,null,0.10004220827417776]
[28,"徳川　大輝","男","徳川",null,null,null,null,null,null,null,null,null,null,null,null,0.97173649391671457]
[29,"長澤　美緒","女","長澤",null,null,null,null,null,null,null,null,null,null,null,null,0.81109893230221586]
[30,"夏木　彩音","女","夏木",null,null,null,null,null,null,null,null,null,null,null,null,0.84111509441650489]
[31,"野田　健太","男","野田",null,null,null,null,null,null,null,null,null,null,null,null,0.59857607155851911]
[32,"平賀　真衣","女","平賀",null,null,null,null,null,null,null,null,null,null,null,null,0.66937109034447118]
[33,"広末　未来","女","広末",null,null,null,null,null,null,null,null,null,null,null,null,0.99247658973306352]
[34,"深田　雄太","男","深田",null,null,null,null,null,null,null,null,null,null,null,null,0.56421410611322409]
[35,"福沢　陽太","男","福沢",null,null,null,null,null,null,null,null,null,null,null,null,0.24007925492279303]
[36,"堀北　美由紀","女","堀北",null,null,null,null,null,null,null,null,null,null,null,null,0.73127919328010427]
[37,"松尾　歩","男","松尾",null,null,null,null,null,null,null,null,null,null,null,null,0.87354851982301485]
[38,"眞鍋　あかり","女","眞鍋",null,null,null,null,null,null,null,null,null,null,null,null,0.95651807265975608]
[39,"宮﨑　遥","女","宮﨑",null,null,null,null,null,null,null,null,null,null,null,null,0.18858836312097849]
[40,"宮本　瑛大","男","宮本","",null,null,null,null,null,null,null,null,null,null,null,0.79636975512194441]
[41,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.98702087501474278]
[42,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.63950258624077183]
[43,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.42347326763517956]

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

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