{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Sheet1","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["#","Names ","Team","Teams","Members"]
[1,"R. Taylor",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C1,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C1,Teams)<>Members))))),\"\")","v":"Team C"},"Team A",4]
[2,"O. Johnson",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C2,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C2,Teams)<>Members))))),\"\")","v":0},"Team B",6]
[3,"R. Williams",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C3,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C3,Teams)<>Members))))),\"\")","v":0},"Team C",3]
[4,"Z. Jones",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C4,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C4,Teams)<>Members))))),\"\")","v":"Team B"},null,{"$f":"ROWS(Names)-SUM($E$2:$E$4)","v":7}]
[5,"T. Brown",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C5,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C5,Teams)<>Members))))),\"\")","v":0},null,null,{"$f":"IF(E6=\"\",\"\",SUM($E$2:E6))","v":""},"Press F9 to recalculate"]
[6,"V. Davis",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C6,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C6,Teams)<>Members))))),\"\")","v":"Team A"},null,null,{"$f":"IF(E7=\"\",\"\",SUM($E$2:E7))","v":""}]
[7,"O. Miller",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C7,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C7,Teams)<>Members))))),\"\")","v":"Team A"},null,null,{"$f":"IF(E8=\"\",\"\",SUM($E$2:E8))","v":""}]
[8,"F. Wilson",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C8,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C8,Teams)<>Members))))),\"\")","v":0},null,null,{"$f":"IF(E9=\"\",\"\",SUM($E$2:E9))","v":""}]
[9,"D. Moore",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C9,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C9,Teams)<>Members))))),\"\")","v":"Team B"},null,null,{"$f":"IF(E10=\"\",\"\",SUM($E$2:E10))","v":""}]
[10,"G. Taylor",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C10,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C10,Teams)<>Members))))),\"\")","v":"Team B"},null,null,{"$f":"IF(E11=\"\",\"\",SUM($E$2:E11))","v":""}]
[11,"J. Thomas",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C11,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C11,Teams)<>Members))))),\"\")","v":"Team C"},null,null,{"$f":"IF(E12=\"\",\"\",SUM($E$2:E12))","v":""}]
[12,"F. Jackson",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C12,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C12,Teams)<>Members))))),\"\")","v":"Team B"},null,null,{"$f":"IF(E13=\"\",\"\",SUM($E$2:E13))","v":""}]
[13,"P. White",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C13,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C13,Teams)<>Members))))),\"\")","v":"Team C"},null,null,{"$f":"IF(E14=\"\",\"\",SUM($E$2:E14))","v":""}]
[14,"E. Harris",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C14,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C14,Teams)<>Members))))),\"\")","v":"Team B"},null,null,{"$f":"IF(E15=\"\",\"\",SUM($E$2:E15))","v":""}]
[15,"U. Martin",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C15,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C15,Teams)<>Members))))),\"\")","v":"Team A"},null,null,{"$f":"IF(E16=\"\",\"\",SUM($E$2:E16))","v":""}]
[16,"A. Thompson",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C16,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C16,Teams)<>Members))))),\"\")","v":0},null,null,{"$f":"IF(E17=\"\",\"\",SUM($E$2:E17))","v":""}]
[17,"S. Garcia",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C17,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C17,Teams)<>Members))))),\"\")","v":"Team B"},null,null,{"$f":"IF(E18=\"\",\"\",SUM($E$2:E18))","v":""}]
[18,"A. Martinez",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C18,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C18,Teams)<>Members))))),\"\")","v":0},null,null,{"$f":"IF(E19=\"\",\"\",SUM($E$2:E19))","v":""}]
[19,"Z. Robinson",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C19,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C19,Teams)<>Members))))),\"\")","v":"Team A"},null,null,{"$f":"IF(E20=\"\",\"\",SUM($E$2:E20))","v":""}]
[20,"E. Rodriguez",{"$f":"IFERROR(INDEX($D$2:$D$18,LARGE((COUNTIF($C$1:C20,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($C$1:C20,Teams)<>Members))))),\"\")","v":0},null,null,{"$f":"IF(E21=\"\",\"\",SUM($E$2:E21))","v":""}]
[null,null,null,null,null,{"$f":"IF(E22=\"\",IF(E21<>\"\",SUM(Members),\"\"),SUM($E$2:E21))","v":""}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}