{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Team Generator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Team Generator","index":0,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Names","Unique","Rank",null,"Number of teams",null,{"$f":"IF(COLUMNS($G$1:G1)>$E$2,\"\",COLUMNS($G$1:G1))","v":1},{"$f":"IF(COLUMNS($G$1:H1)>$E$2,\"\",COLUMNS($G$1:H1))","v":2},{"$f":"IF(COLUMNS($G$1:I1)>$E$2,\"\",COLUMNS($G$1:I1))","v":3},{"$f":"IF(COLUMNS($G$1:J1)>$E$2,\"\",COLUMNS($G$1:J1))","v":4},{"$f":"IF(COLUMNS($G$1:K1)>$E$2,\"\",COLUMNS($G$1:K1))","v":""},{"$f":"IF(COLUMNS($G$1:L1)>$E$2,\"\",COLUMNS($G$1:L1))","v":""},{"$f":"IF(COLUMNS($G$1:M1)>$E$2,\"\",COLUMNS($G$1:M1))","v":""},{"$f":"IF(COLUMNS($G$1:N1)>$E$2,\"\",COLUMNS($G$1:N1))","v":""},{"$f":"IF(COLUMNS($G$1:O1)>$E$2,\"\",COLUMNS($G$1:O1))","v":""},{"$f":"IF(COLUMNS($G$1:P1)>$E$2,\"\",COLUMNS($G$1:P1))","v":""}]
["Anna",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":7.02},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":12},null,4,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F2)-1))),\"\"),\"\")","v":"Martin"},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G2)-1))),\"\"),\"\")","v":"Josh"},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H2)-1))),\"\"),\"\")","v":"Jake"},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I2)-1))),\"\"),\"\")","v":"Bob"},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J2)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K2)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L2)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M2)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N2)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O2)-1))),\"\"),\"\")","v":""}]
["Bob",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":10.029999999999999},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":10},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F3)-1))),\"\"),\"\")","v":"Harry"},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G3)-1))),\"\"),\"\")","v":"Caleb"},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H3)-1))),\"\"),\"\")","v":"Greg"},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I3)-1))),\"\"),\"\")","v":"Anna"},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J3)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K3)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L3)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M3)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N3)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O3)-1))),\"\"),\"\")","v":""}]
["Bruce",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":11.04},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":8},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F4)-1))),\"\"),\"\")","v":"Mark"},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G4)-1))),\"\"),\"\")","v":"Tom"},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H4)-1))),\"\"),\"\")","v":"John"},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I4)-1))),\"\"),\"\")","v":"Richard"},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J4)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K4)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L4)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M4)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N4)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O4)-1))),\"\"),\"\")","v":""}]
["Caleb",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":15.05},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":2},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F5)-1))),\"\"),\"\")","v":"Sally"},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G5)-1))),\"\"),\"\")","v":"Hanna"},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H5)-1))),\"\"),\"\")","v":"Matt"},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I5)-1))),\"\"),\"\")","v":"Bruce"},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J5)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K5)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L5)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M5)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N5)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O5)-1))),\"\"),\"\")","v":""}]
["Greg",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":11.06},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":7},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F6)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G6)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H6)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I6)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J6)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K6)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L6)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M6)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N6)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O6)-1))),\"\"),\"\")","v":""}]
["Hanna",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":13.07},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":4},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F7)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G7)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H7)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I7)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J7)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K7)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L7)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M7)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N7)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O7)-1))),\"\"),\"\")","v":""}]
["Harry",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":12.08},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":5},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F8)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G8)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H8)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I8)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J8)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K8)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L8)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M8)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N8)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O8)-1))),\"\"),\"\")","v":""}]
["Jake",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":16.09},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":1},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F9)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G9)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H9)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I9)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J9)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K9)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L9)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M9)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N9)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O9)-1))),\"\"),\"\")","v":""}]
["John",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":9.1},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":11},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F10)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G10)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H10)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I10)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J10)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K10)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L10)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M10)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N10)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O10)-1))),\"\"),\"\")","v":""}]
["Josh",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":1.1100000000000001},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":16},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F11)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G11)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H11)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I11)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J11)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K11)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L11)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M11)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N11)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O11)-1))),\"\"),\"\")","v":""}]
["Mark",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":10.119999999999999},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":9},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F12)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G12)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H12)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I12)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J12)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K12)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L12)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M12)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N12)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O12)-1))),\"\"),\"\")","v":""}]
["Martin",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":3.13},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":14},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F13)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G13)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H13)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I13)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J13)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K13)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L13)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M13)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N13)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O13)-1))),\"\"),\"\")","v":""}]
["Matt",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":1.1400000000000001},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":15},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F14)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G14)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H14)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I14)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J14)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K14)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L14)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M14)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N14)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O14)-1))),\"\"),\"\")","v":""}]
["Richard",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":11.15},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":6},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F15)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G15)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H15)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I15)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J15)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K15)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L15)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M15)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N15)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O15)-1))),\"\"),\"\")","v":""}]
["Sally",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":5.16},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":13},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F16)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G16)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H16)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I16)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J16)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K16)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L16)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M16)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N16)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O16)-1))),\"\"),\"\")","v":""}]
["Tom",{"$f":"RANDBETWEEN(1,COUNTA(Table1[Names])) + ROW()/100","v":14.17},{"$f":"RANK(Table1[[#This Row],[Unique]],Table1[Unique])","v":3},null,null,null,{"$f":"IFERROR(IF(G$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],G$1+$E$2*(ROWS($F$2:F17)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(H$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],H$1+$E$2*(ROWS($F$2:G17)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(I$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],I$1+$E$2*(ROWS($F$2:H17)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(J$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],J$1+$E$2*(ROWS($F$2:I17)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(K$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],K$1+$E$2*(ROWS($F$2:J17)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(L$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],L$1+$E$2*(ROWS($F$2:K17)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(M$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],M$1+$E$2*(ROWS($F$2:L17)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(N$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],N$1+$E$2*(ROWS($F$2:M17)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(O$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],O$1+$E$2*(ROWS($F$2:N17)-1))),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(P$1<>\"\",INDEX(Table1[Names],INDEX(Table1[Rank],P$1+$E$2*(ROWS($F$2:O17)-1))),\"\"),\"\")","v":""}]