{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"#","Names ","Team",null,"Teams","Members"]
[null,1,"R. Taylor",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D2,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D2,Teams)<>Members))))),\"\")","v":"Team C"},null,"Team A",4,null,"Website:","Get Digital Help"]
[null,2,"O. Johnson",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D3,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D3,Teams)<>Members))))),\"\")","v":"Team B"},null,"Team B",6,null,"Webpage:","Team Generator"]
[null,3,"R. Williams",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D4,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D4,Teams)<>Members))))),\"\")","v":"Team A"},null,"Team C",3]
[null,4,"Z. Jones",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D5,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D5,Teams)<>Members))))),\"\")","v":"Team B"},null,"Team D",{"$f":"ROWS(Names)-SUM($G$3:$G$5)","v":7}]
[null,5,"T. Brown",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D6,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D6,Teams)<>Members))))),\"\")","v":"Team D"},null,null,null,{"$f":"IF(G7=\"\",\"\",SUM($G$3:G7))","v":""},"Press F9 to recalculate"]
[null,6,"V. Davis",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D7,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D7,Teams)<>Members))))),\"\")","v":"Team C"},null,null,null,{"$f":"IF(G8=\"\",\"\",SUM($G$3:G8))","v":""}]
[null,7,"O. Miller",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D8,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D8,Teams)<>Members))))),\"\")","v":"Team A"},null,null,null,{"$f":"IF(G9=\"\",\"\",SUM($G$3:G9))","v":""}]
[null,8,"F. Wilson",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D9,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D9,Teams)<>Members))))),\"\")","v":"Team A"},null,null,null,{"$f":"IF(G10=\"\",\"\",SUM($G$3:G10))","v":""}]
[null,9,"D. Moore",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D10,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D10,Teams)<>Members))))),\"\")","v":"Team A"},null,null,null,{"$f":"IF(G11=\"\",\"\",SUM($G$3:G11))","v":""}]
[null,10,"G. Taylor",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D11,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D11,Teams)<>Members))))),\"\")","v":"Team D"},null,null,null,{"$f":"IF(G12=\"\",\"\",SUM($G$3:G12))","v":""}]
[null,11,"J. Thomas",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D12,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D12,Teams)<>Members))))),\"\")","v":"Team D"},null,null,null,{"$f":"IF(G13=\"\",\"\",SUM($G$3:G13))","v":""}]
[null,12,"F. Jackson",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D13,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D13,Teams)<>Members))))),\"\")","v":"Team B"},null,null,null,{"$f":"IF(G14=\"\",\"\",SUM($G$3:G14))","v":""}]
[null,13,"P. White",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D14,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D14,Teams)<>Members))))),\"\")","v":"Team B"},null,null,null,{"$f":"IF(G15=\"\",\"\",SUM($G$3:G15))","v":""}]
[null,14,"E. Harris",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D15,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D15,Teams)<>Members))))),\"\")","v":"Team B"},null,null,null,{"$f":"IF(G16=\"\",\"\",SUM($G$3:G16))","v":""}]
[null,15,"U. Martin",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D16,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D16,Teams)<>Members))))),\"\")","v":"Team D"},null,null,null,{"$f":"IF(G17=\"\",\"\",SUM($G$3:G17))","v":""}]
[null,16,"A. Thompson",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D17,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D17,Teams)<>Members))))),\"\")","v":"Team D"},null,null,null,{"$f":"IF(G18=\"\",\"\",SUM($G$3:G18))","v":""}]
[null,17,"S. Garcia",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D18,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D18,Teams)<>Members))))),\"\")","v":"Team B"},null,null,null,{"$f":"IF(G19=\"\",\"\",SUM($G$3:G19))","v":""}]
[null,18,"A. Martinez",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D19,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D19,Teams)<>Members))))),\"\")","v":"Team D"},null,null,null,{"$f":"IF(G20=\"\",\"\",SUM($G$3:G20))","v":""}]
[null,19,"Z. Robinson",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D20,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D20,Teams)<>Members))))),\"\")","v":"Team C"},null,null,null,{"$f":"IF(G21=\"\",\"\",SUM($G$3:G21))","v":""}]
[null,20,"E. Rodriguez",{"$f":"IFERROR(INDEX(Teams,LARGE((COUNTIF($D$2:D21,Teams)<>Members)*MATCH(ROW(Teams),ROW(Teams)),RANDBETWEEN(1,SUM(--(COUNTIF($D$2:D21,Teams)<>Members))))),\"\")","v":"Team D"},null,null,null,{"$f":"IF(G22=\"\",\"\",SUM($G$3:G22))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(G23=\"\",IF(G22<>\"\",SUM(Members),\"\"),SUM($G$3:G22))","v":""}]