{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["元名簿","座席","座席ナンバー","座席可変","理科室_先生から42","理科室_子から42"],"not_rendered":{"charts":0,"images":1,"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,5,"年",null,"マクロ終了まで\n変化",null,null,null,null,{"$f":"RAND()","v":0.99962271335018094},"伊藤"]
[2,"伊藤　勉","男","伊藤","伊藤","上杉","上戸",null,3,"組",null,"男人数","女人数",null,null,null,{"$f":"RAND()","v":0.59677394483060764},"石田"]
[3,"上杉　工","男","上杉","上杉","大石","菅野",null,{"$f":"COUNTA($B$2:$B$46)","v":32},"人",null,{"$f":"COUNTIF(F$2:F$25,\"*?\")","v":16},{"$f":"COUNTIF(G$2:G$25,\"*?\")","v":16},null,null,null,0.82910270237471351,"上杉"]
[4,"上戸　架純","女","上戸","上戸","大久保","木戸",null,null,null,null,null,null,null,null,null,0.58738101920570529,"上戸"]
[5,"大石　心","男","大石","大石","大久保","栗山",null,null,null,null,null,null,null,null,null,0.15196441407876116,"大石"]
[6,"大久保　太郎","男",{"$f":"IFERROR(TRIM(LEFT($B7,FIND(\" \",$B7))),IFERROR(TRIM(LEFT($B7,FIND(\"　\",$B7))),\"\"))","v":"大久保"},"大久保た","織田","小池",null,null,null,null,null,null,null,null,null,0.31891976731570648,"菅野"]
[7,"大久保　敏夫","男","大久保","大久保と","木下","小松",null,null,null,null,null,null,null,null,null,0.73326232574009864,"大久保"]
[8,"織田　翼","男","織田","織田","国仲","坂本",null,null,null,null,null,null,null,null,null,0.27198168648282672,"木戸"]
[9,"菅野　結菜","女","菅野","菅野","熊田","佐藤",null,null,null,null,null,null,null,null,null,0.13285763593248445,"大久保"]
[10,"木戸　くるみ","女","木戸","木戸","近藤","柴咲",null,null,null,null,null,null,null,null,null,0.57445472451500723,"栗山"]
[11,"木下　悠吾","男","木下","木下","西郷","島田",null,null,null,null,null,null,null,null,null,0.74730422001102659,"織田"]
[12,"国仲　海斗","男","国仲","国仲","篠原","瀬戸",null,null,null,null,null,null,null,null,null,0.29435161205328975,"小池"]
[13,"熊田　涼太","男","熊田","熊田","武田","高杉",null,null,null,null,null,null,null,null,null,0.27313581913365248,"木下"]
[14,"栗山　綾乃","女","栗山","栗山","遠山","長澤",null,null,null,null,null,null,null,null,null,0.27193079027569422,"小松"]
[15,"小池　優衣","女","小池","小池","徳川","夏木",null,null,null,null,null,null,null,null,null,8.6423902607210779E-2,"国仲"]
[16,"小松　美智子","女","小松","小松","野田","平賀",null,null,null,null,null,null,null,null,null,0.31497386978849085,"坂本"]
[17,"近藤　優輝","男","近藤","近藤","",null,null,null,null,null,null,null,null,null,null,0.55177385640424259,"熊田"]
[18,"西郷　啓太","男","西郷","西郷",null,null,null,null,null,null,null,null,null,null,null,0.15626410362678289,"佐藤"]
[19,"坂本　愛莉","女","坂本","坂本",null,null,null,null,null,null,null,null,null,null,null,0.71331577927515977,"近藤"]
[20,"佐藤　琴音","女","佐藤","佐藤",null,null,null,null,null,null,null,null,null,null,null,0.3154726556660834,"柴咲"]
[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,0.35947280628481193,"西郷"]
[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,0.29785697955243495,"島田"]
[23,"島田　美優","女","島田","島田",null,null,null,null,null,null,null,null,null,null,null,0.34558351612729332,"篠原"]
[24,"瀬戸　真央","女","瀬戸","瀬戸",null,null,null,null,null,null,null,null,null,null,null,0.79789019087119861,"瀬戸"]
[25,"高杉　芽衣","女","高杉","高杉",null,null,null,null,null,null,null,null,null,null,null,5.1044265330068783E-2,"武田"]
[26,"武田　太一","男","武田","武田",null,null,null,null,null,null,null,null,null,null,null,0.58193317292541158,"高杉"]
[27,"遠山　蒼太","男","遠山","遠山",null,null,null,null,null,null,null,null,null,null,null,0.69034702052861063,"遠山"]
[28,"徳川　大輝","男","徳川","徳川",null,null,null,null,null,null,null,null,null,null,null,0.39598495055526972,"長澤"]
[29,"長澤　美緒","女","長澤","長澤",null,null,null,null,null,null,null,null,null,null,null,0.36347587763898404,"徳川"]
[30,"夏木　彩音","女","夏木","夏木",null,null,null,null,null,null,null,null,null,null,null,0.47340920851370605,"夏木"]
[31,"野田　健太","男","野田","野田",null,null,null,null,null,null,null,null,null,null,null,0.73946006889564597,"野田"]
[32,"平賀　真衣","女","平賀","平賀",null,null,null,null,null,null,null,null,null,null,null,0.21794621236650824,"平賀"]
[33,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.34812563915862516,"深田"]
[34,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.2800961518046412,"広末"]
[35,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.59552257777784201,"福沢"]
[36,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.82854040549482688,"堀北"]
[37,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.48662035417901395,"松尾"]
[38,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.58475532641715844,"宮本"]
[39,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.38245708230899955]
[40,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.24194258709274019]
[41,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.82111756143236492]
[42,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.8476889486634297]
[43,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,0.90076358203011875]

{"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":76,"n_cols":15,"rows_kept":76,"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]]}
[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,名列,5,FALSE),\"\")","v":""},"","","","","",""]
[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,null,"まず黄色いセルに"]
[null,16,29,null,null,null,null,null,null,"数字を入力"]
[null,32,13,26,8,21,3,null,"前半"]
[null,15,28,10,23,5,18,null,16,"まで"]
[null,31,12,25,7,20,2,null,"後半"]
[null,14,27,9,22,4,17,null,{"$f":"前半ここまで+1","v":17},"から"]
[null,30,11,24,6,19,1,null,null,null,null,null,"順番抜かす",null,"順番を抜かす番号の児童が座る席は\n「予約」の文字を入力"]
[null,"↓　ここにそれぞれのを人数してください　↓",null,null,null,null,null,null,null,"合計"]
[null,6,6,5,5,5,5,null,null,{"$f":"SUM(B28:H28)","v":32},{"$f":"\"←\" & クラス人数 & \"以上\"","v":"←32以上"}]
[null,null,null,null,null,null,null,null,null,"↑クラス人数以上"]
[null,null,null,"先生"]
[]
[]
[]
[null,"乱数関数","値","順位関数","値"]
[1,{"$f":"RAND()","v":0.64272098857489302},0.85417160691198357,{"$f":"RANK(C35,$C$35:$C$50)","v":3},3,null,"前半範囲",{"$f":"\"$C$35:$C$\"  & 35+前半ここまで-1","v":"$C$35:$C$50"}]
[2,{"$f":"RAND()","v":0.10151930642594709},0.14187334410808461,14,14,null,"後半範囲",{"$f":"\"$C$\" & 35+前半ここまで & \":$C$\"  & 34+クラス人数","v":"$C$51:$C$66"}]
[3,0.24759668475937124,4.6515821305892935E-2,16,16]
[4,0.64652907042349383,0.67017864492113477,5,5]
[5,0.68541641298745204,0.64010799548633501,7,7]
[6,0.45063084163442613,0.17031172228498348,13,13]
[7,0.29645548915615028,7.8780064350337797E-2,15,15]
[8,0.41474134071782476,0.84470158764475289,4,4]
[9,0.44445968916937351,0.51117314787099222,8,8]
[10,0.32870325436283321,0.64887694626991543,6,6]
[11,0.62267354600039748,0.4037480855879032,11,11]
[12,0.76061024758916373,0.36222506250774322,12,12]
[13,0.82967539056657669,0.97002067231972255,1,1]
[14,0.19399943644005901,0.87833792876550643,2,2]
[15,0.74686790475103404,0.4511411896172941,10,10]
[16,0.51943663609332391,0.4784393159656084,9,9]
[17,0.35304039360054207,8.7724732730863675E-2,{"$f":"RANK(C51,$C$51:$C$66)","v":15},31]
[18,0.15062818828986968,0.18984711156219813,13,29]
[19,0.9295861067225123,0.88623847167995262,2,18]
[20,0.96841017022826936,0.33548969619177194,12,28]
[21,0.87709624195090807,0.34741497376588082,11,27]
[22,0.20667595109313586,0.13875376924011851,14,30]
[23,0.47572654298478612,0.46406672633753721,10,26]
[24,0.48678986647291278,0.69215597292430819,5,21]
[25,0.29869867090419699,0.54485734420772813,9,25]
[26,0.97890911466730168,0.56183388112012422,8,24]
[27,0.6119383746053727,0.77153094851811854,3,19]
[28,0.76530026966211395,0.6834727962670798,6,22]
[29,0.3266514908659115,0.59829273506106162,7,23]
[30,0.75698570324235015,4.1643407084049677E-2,16,32]
[31,0.70174035120868494,0.69406034111266091,4,20]
[32,0.30446104940785401,0.9120943653413871,1,17]
[33,0.87174957348322002]
[34,7.4903871421323376E-2]
[35,0.41397339519109433]
[36,0.52351784940094548]
[37,0.14336853299905217]
[38,0.52609873735185275]
[39,0.24353354564284901]
[40,0.50174053949615172]
[41,0.85510057832546715]
[42,0.3473161390980346]

{"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}]