{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Monday","Copy Names","Job History","Names","ALL NAMES"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Monday","index":0,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["MONDAY"]
[]
[]
[null,null,null,"Приём",null,null,null,"Грузчики",null,null,null,null,null,null,null,"E.Lindo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J.Gorrell"]
[null,null,1,{"$f":"VLOOKUP(Names!$F$1,Names!$B$2:$C$44,2,FALSE)","v":"T.Underwood"},"2PM",null,1,{"$f":"VLOOKUP(Names!$K$1,Names!$B$2:$C$44,2,FALSE)","v":"C.Boateng"},"2PM",null,null,null,null,null,null,"K.Pape"]
[null,null,2,{"$f":"VLOOKUP(Names!$G$1,Names!$B$2:$C$44,2,FALSE)","v":"L.R.Brown"},"2PM",null,2,{"$f":"VLOOKUP(Names!$L$1,Names!$B$2:$C$44,2,FALSE)","v":"E.Mullally"},"2PM",null,null,null,null,null,null,"M.Abu"]
[null,null,3,{"$f":"VLOOKUP(Names!$H$1,Names!$B$2:$C$44,2,FALSE)","v":"C.Keegan"},"2PM",null,3,{"$f":"VLOOKUP(Names!$M$1,Names!$B$2:$C$44,2,FALSE)","v":"J.Pyke"},"2PM",null,null,null,null,null,null,"M.Flanagan"]
[null,null,4,{"$f":"VLOOKUP(Names!$I$1,Names!$B$2:$C$44,2,FALSE)","v":"R.Diprose"},"2PM",null,4,{"$f":"VLOOKUP(Names!$N$1,Names!$B$2:$C$44,2,FALSE)","v":"G.Franklin"},"4PM",null,null,null,null,null,null,"M.Kumar"]
[null,null,5,{"$f":"VLOOKUP(Names!$J$1,Names!$B$2:$C$44,2,FALSE)","v":"P.Regan"},"4PM",null,5,{"$f":"VLOOKUP(Names!$O$1,Names!$B$2:$C$44,2,FALSE)","v":"T.Bryan"},"4PM",null,null,null,null,null,null,"M.Lawson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P.Chapman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R.Hallgally"]
[null,null,null,null,"2 to 4",null,null,null,null,null,null,null,null,null,null,"S.Abraham"]
[null,null,null,"Кар",null,null,null,null,null,null,null,null,null,null,null,"S.Pearce"]
[null,null,1,{"$f":"INDEX(Names!$C$2:$C$14,MATCH(MIN(IF(Names!$B$2:$B$14-Names!P1>=0,Names!$B$2:$B$14,FALSE)),IF(Names!$B$2:$B$14-Names!P1>=0,Names!$B$2:$B$14,FALSE),0))","v":"P.Chapman"},"2PM",null,null,null,null,null,null,null,null,null,null,"S.Stretton"]
[null,null,null,null,null,null,null,"Bread Pickers",null,null,null,null,null,null,null,"T.Bryan"]
[null,null,null,"OPPS",null,null,1,null,null,null,null,null,null,null,null,"A.Bradbury"]
[null,null,1,null,"2PM",null,2,null,null,null,null,null,null,null,null,"A.Nicholls"]
[null,null,2,null,"2PM",null,3,null,null,null,null,null,null,null,null,"A.Wall"]
[null,null,null,"COVER",null,null,4,null,null,null,null,null,null,null,null,"A.Walton"]
[null,null,1,null,"2PM",null,5,null,null,null,null,null,null,null,null,"B.Sutton"]
[null,null,null,"SPONSOR",null,null,6,null,null,null,null,null,null,null,null,"C.Boateng"]
[null,null,1,null,"4PM",null,7,null,null,null,null,null,null,null,null,"C.Keegan"]
[null,null,null,"HYGIENE",null,null,8,null,null,null,null,null,null,null,null,"D.Hickmott"]
[null,null,1,null,"2PM",null,9,null,null,null,null,null,null,null,null,"D.Magill"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E.Mullally"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G.Franklin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G.Hawkins"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I.Edgar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J.Allen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J.Pyke"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J.Reynolds"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L.R.Brown"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P.Green"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P.McArthur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P.Regan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R.Diprose"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R.Pembroke"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R.Rozniak"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S.Chow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S.Tariq"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T.Doyle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T.Harman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T.Underwood"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T.Winter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V.Ilott"]

{"sheet":"Copy Names","index":1,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Приём",null,null,null,"Грузчики"]
[]
[null,null,1,"T.Underwood","2PM",null,1,"C.Boateng","2PM"]
[null,null,2,"L.R.Brown","2PM",null,2,"E.Mullally","2PM"]
[null,null,3,"C.Keegan","2PM",null,3,"J.Pyke","2PM"]
[null,null,4,"R.Diprose","2PM",null,4,"G.Franklin","4PM"]
[null,null,5,"P.Regan","4PM",null,5,"T.Bryan","4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"Кар"]
[null,null,1,"P.Chapman","2PM"]
[null,null,null,null,null,null,null,"Bread Pickers"]
[null,null,null,"OPPS",null,null,1]
[null,null,1,null,null,null,2]
[null,null,2,null,null,null,3]
[null,null,null,"COVER",null,null,4]
[null,null,1,null,null,null,5]
[null,null,null,"SPONSOR",null,null,6]
[null,null,1,null,null,null,7]
[null,null,null,"HYGIENE",null,null,8]
[null,null,1,null,null,null,9]

{"sheet":"Job History","index":2,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[null,"Nº","Name","Приём","Pick. (Days)","Грузчики","Кар","Сумма",null,null,"Приём",null,"Грузчики","Кар"]
[null,"Job History!"]
[null,1,"A.Bradbury",{"$f":"COUNTIF($K$2:$K$60000,C3)","v":0},{"$f":"COUNTIF($L$2:$L$60000,C3)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C3)","v":0},{"$f":"COUNTIF($N$2:$N$60000,C3)","v":0},{"$f":"COUNTIF($K$2:$K$60000,C3)+COUNTIF($M$2:$M$60000,C3)+COUNTIF($N$2:$N$60000,C3)","v":0}]
[null,2,"A.Hussey",{"$f":"COUNTIF($K$2:$K$60000,C4)","v":0},{"$f":"COUNTIF($L$2:$L$60000,C4)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C4)","v":0},{"$f":"COUNTIF($N$2:$N$60000,C4)","v":0},{"$f":"COUNTIF($K$2:$K$60000,C4)+COUNTIF($M$2:$M$60000,C4)+COUNTIF($N$2:$N$60000,C4)","v":0}]
[null,3,"A.McFarlane",0,0,0,0,0]
[null,4,"A.Nicholls",0,0,0,0,0]
[null,5,"B.Ratcliffe",0,0,0,0,0]
[null,6,"A.Wall",0,0,0,0,0]
[null,7,"A.Walton",0,0,0,0,0]
[null,8,"B.Golubkov",0,0,0,0,0]
[null,9,"B.Ratcliffe",0,0,0,0,0]
[null,10,"B.Sutton",0,0,0,0,0]
[null,11,"C.Boateng",0,0,0,0,0]
[null,12,"C.Keegan",0,0,0,0,0]
[null,13,"D.Caffell",0,0,0,0,0]
[null,14,"D.Cooke",0,0,0,0,0]
[null,15,"D.Hickmott",0,0,0,0,0]
[null,16,"D.Magill",0,0,0,0,0]
[null,17,"D.Roczniak",0,0,0,0,0]
[null,18,"E.Lindo",0,0,0,0,0]
[null,19,"E.Mooney",0,0,0,0,0]
[null,20,"E.Mullally",0,0,0,0,0]
[null,21,"E.Selickis",0,0,0,0,0]
[null,22,"G.Franklin",{"$f":"COUNTIF($K$2:$K$60000,C24)","v":0},{"$f":"COUNTIF($L$2:$L$60000,C24)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C24)","v":0},{"$f":"COUNTIF($N$2:$N$60000,C24)","v":0},{"$f":"COUNTIF($K$2:$K$60000,C24)+COUNTIF($M$2:$M$60000,C24)+COUNTIF($N$2:$N$60000,C24)","v":0}]
[null,23,"G.Hawkins",{"$f":"COUNTIF($K$2:$K$60000,C25)","v":0},{"$f":"COUNTIF($L$2:$L$60000,C25)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C25)","v":0},{"$f":"COUNTIF($N$2:$N$60000,C25)","v":0},{"$f":"COUNTIF($K$2:$K$60000,C25)+COUNTIF($M$2:$M$60000,C25)+COUNTIF($N$2:$N$60000,C25)","v":0}]
[null,24,"H.Mohamed",0,0,0,0,0]
[null,25,"I.Edgar",0,0,0,0,0]
[null,26,"J.Allen",0,0,0,0,0]
[null,27,"J.Gorrell",0,0,0,0,0]
[null,28,"J.Hough",0,0,0,0,0]
[null,29,"J.Pyke",0,0,0,0,0]
[null,30,"J.Reynolds",0,0,0,0,0]
[null,31,"K.Pape",0,0,0,0,0]
[null,32,"K.Verdi",0,0,0,0,0]
[null,33,"L.R.Browne",0,0,0,0,0]
[null,34,"M.Abu",0,0,0,0,0]
[null,35,"M.Borek",0,0,0,0,0]
[null,36,"M.Flanagan",0,0,0,0,0]
[null,37,"M.Kochowski",0,0,0,0,0]
[null,38,"M.Kumar",0,0,0,0,0]
[null,39,"M.Lawson",0,0,0,0,0]
[null,40,"M.Pushotam",0,0,0,0,0]
[null,41,"N.Lukasevicius",0,0,0,0,0]
[null,42,"P.Chapman",0,0,0,0,0]
[null,43,"P.Green",{"$f":"COUNTIF($K$2:$K$60000,C45)","v":2},{"$f":"COUNTIF($L$2:$L$60000,C45)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C45)","v":3},{"$f":"COUNTIF($N$2:$N$60000,C45)","v":0},{"$f":"COUNTIF($K$2:$K$60000,C45)+COUNTIF($M$2:$M$60000,C45)+COUNTIF($N$2:$N$60000,C45)","v":5}]
[null,44,"P.Johnson",{"$f":"COUNTIF($K$2:$K$60000,C46)","v":0},{"$f":"COUNTIF($L$2:$L$60000,C46)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C46)","v":0},{"$f":"COUNTIF($N$2:$N$60000,C46)","v":0},{"$f":"COUNTIF($K$2:$K$60000,C46)+COUNTIF($M$2:$M$60000,C46)+COUNTIF($N$2:$N$60000,C46)","v":0}]
[null,45,"P.Lavender",0,0,1,2,3]
[null,46,"P.McArthur",2,0,8,0,10]
[null,47,"P.Regan",1,0,7,0,8]
[null,48,"R.Diprose",8,0,3,0,11]
[null,49,"R.Hallgally",0,0,0,3,3]
[null,50,"R.O’Meara",0,0,0,0,0]
[null,51,"R.Pembroke",0,0,0,0,0]
[null,52,"R.Rozniak",{"$f":"COUNTIF($K$2:$K$60000,C54)","v":0},{"$f":"COUNTIF($L$2:$L$60000,C54)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C54)","v":1},{"$f":"COUNTIF($N$2:$N$60000,C54)","v":0},{"$f":"COUNTIF($K$2:$K$60000,C54)+COUNTIF($M$2:$M$60000,C54)+COUNTIF($N$2:$N$60000,C54)","v":1}]
[null,53,"S.Abraham",0,0,3,1,4]
[null,54,"S.Brookman",4,0,4,0,8]
[null,55,"S.Chow",0,0,0,0,0]
[null,56,"S.Harrison",0,0,0,0,0]
[null,57,"S.Monk",0,0,1,0,1]
[null,58,"S.Pearce",2,0,0,2,4]
[null,59,"S.Stretton",0,0,0,2,2]
[null,60,"S.Tariq",0,0,0,0,0]
[null,61,"T.Bryan",0,0,2,5,7]
[null,62,"T.Doyle",0,0,0,0,0]
[null,63,"T.Harman",0,0,0,0,0]
[null,64,"T.Watkins",2,0,1,0,3]
[null,65,"T.Winter",0,0,0,0,0]
[null,66,"V.Ilott",4,0,3,0,7]
[null,67]

{"sheet":"Names","index":3,"n_rows":50,"n_cols":29,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Rand","Rank","Name",null,"умножатели",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,null,"Rand","Rank"]
[{"$f":"RAND()*E2","v":1.0316542548596299},{"$f":"RANK($A2,$A$2:$A$44)+COUNTIF(B$1:B1,B1)-1","v":19},"E.Lindo",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RAND()*AF2","v":6.5866468551164514E-2},{"$f":"RANK($AB2,$AB$2:$AB$50)+COUNTIF(AC$1:AC1,AC1)-1","v":40}]
[{"$f":"RAND()*E3","v":1.3324505721439857},{"$f":"RANK($A3,$A$2:$A$44)+COUNTIF(B$1:B2,B2)-1","v":12},"J.Gorrell",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RAND()*AF3","v":1.4165343799090055},{"$f":"RANK($AB3,$AB$2:$AB$50)+COUNTIF(AC$1:AC2,AC2)-1","v":8}]
[0.99348505074724347,{"$f":"RANK($A4,$A$2:$A$44)+COUNTIF(B$1:B3,B3)-1","v":20},"K.Pape",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73116605127377587,{"$f":"RANK($AB4,$AB$2:$AB$50)+COUNTIF(AC$1:AC3,AC3)-1","v":19}]
[1.0528604852505179,{"$f":"RANK($A5,$A$2:$A$44)+COUNTIF(B$1:B4,B4)-1","v":18},"M.Abu",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.50937239541836199,{"$f":"RANK($AB5,$AB$2:$AB$50)+COUNTIF(AC$1:AC4,AC4)-1","v":25}]
[6.5256992910838862E-2,{"$f":"RANK($A6,$A$2:$A$44)+COUNTIF(B$1:B5,B5)-1","v":42},"M.Flanagan",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2296551404397227E-2,{"$f":"RANK($AB6,$AB$2:$AB$50)+COUNTIF(AC$1:AC5,AC5)-1","v":44}]
[0.63312471678327031,{"$f":"RANK($A7,$A$2:$A$44)+COUNTIF(B$1:B6,B6)-1","v":28},"M.Kumar",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.106532995503271,{"$f":"RANK($AB7,$AB$2:$AB$50)+COUNTIF(AC$1:AC6,AC6)-1","v":15}]
[0.1438284051571449,{"$f":"RANK($A8,$A$2:$A$44)+COUNTIF(B$1:B7,B7)-1","v":39},"M.Lawson",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.30270378829057853,{"$f":"RANK($AB8,$AB$2:$AB$50)+COUNTIF(AC$1:AC7,AC7)-1","v":31}]
[1.3744410116551071,{"$f":"RANK($A9,$A$2:$A$44)+COUNTIF(B$1:B8,B8)-1","v":11},"P.Chapman",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2006786892308563,{"$f":"RANK($AB9,$AB$2:$AB$50)+COUNTIF(AC$1:AC8,AC8)-1","v":13}]
[0.5591977572093465,{"$f":"RANK($A10,$A$2:$A$44)+COUNTIF(B$1:B9,B9)-1","v":32},"R.Hallgally",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49481781668725699,{"$f":"RANK($AB10,$AB$2:$AB$50)+COUNTIF(AC$1:AC9,AC9)-1","v":26}]
[0.77992869141591681,{"$f":"RANK($A11,$A$2:$A$44)+COUNTIF(B$1:B10,B10)-1","v":24},"S.Abraham",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.89642260585069655,{"$f":"RANK($AB11,$AB$2:$AB$50)+COUNTIF(AC$1:AC10,AC10)-1","v":17}]
[0.76917635464422052,{"$f":"RANK($A12,$A$2:$A$44)+COUNTIF(B$1:B11,B11)-1","v":25},"S.Pearce",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72324771683909428,{"$f":"RANK($AB12,$AB$2:$AB$50)+COUNTIF(AC$1:AC11,AC11)-1","v":20}]
[0.95549101273715376,{"$f":"RANK($A13,$A$2:$A$44)+COUNTIF(B$1:B12,B12)-1","v":22},"S.Stretton",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.59964065306699899,{"$f":"RANK($AB13,$AB$2:$AB$50)+COUNTIF(AC$1:AC12,AC12)-1","v":23}]
[1.3818831729888559,{"$f":"RANK($A14,$A$2:$A$44)+COUNTIF(B$1:B13,B13)-1","v":10},"T.Bryan",null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5553710976004291E-2,{"$f":"RANK($AB14,$AB$2:$AB$50)+COUNTIF(AC$1:AC13,AC13)-1","v":38}]
[0.94794095208493978,{"$f":"RANK($A15,$A$2:$A$44)+COUNTIF(B$1:B14,B14)-1","v":23},"A.Bradbury",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.10959459000109439,{"$f":"RANK($AB15,$AB$2:$AB$50)+COUNTIF(AC$1:AC14,AC14)-1","v":37}]
[1.3183130113379797,{"$f":"RANK($A16,$A$2:$A$44)+COUNTIF(B$1:B15,B15)-1","v":13},"A.Nicholls",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25136318468106,{"$f":"RANK($AB16,$AB$2:$AB$50)+COUNTIF(AC$1:AC15,AC15)-1","v":32}]
[0.31752237358388236,{"$f":"RANK($A17,$A$2:$A$44)+COUNTIF(B$1:B16,B16)-1","v":35},"A.Wall",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1211235113829356E-9,{"$f":"RANK($AB17,$AB$2:$AB$50)+COUNTIF(AC$1:AC16,AC16)-1","v":48}]
[0.4317343849950781,{"$f":"RANK($A18,$A$2:$A$44)+COUNTIF(B$1:B17,B17)-1","v":34},"A.Walton",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6372545597858004,{"$f":"RANK($AB18,$AB$2:$AB$50)+COUNTIF(AC$1:AC17,AC17)-1","v":5}]
[0.64769435970014122,{"$f":"RANK($A19,$A$2:$A$44)+COUNTIF(B$1:B18,B18)-1","v":27},"B.Sutton",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3509239161278277,{"$f":"RANK($AB19,$AB$2:$AB$50)+COUNTIF(AC$1:AC18,AC18)-1","v":28}]
[1.5248877045396654,{"$f":"RANK($A20,$A$2:$A$44)+COUNTIF(B$1:B19,B19)-1","v":6},"C.Boateng",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.566427623546641,{"$f":"RANK($AB20,$AB$2:$AB$50)+COUNTIF(AC$1:AC19,AC19)-1","v":6}]
[1.7012124563711861,{"$f":"RANK($A21,$A$2:$A$44)+COUNTIF(B$1:B20,B20)-1","v":3},"C.Keegan",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8561679683061958,{"$f":"RANK($AB21,$AB$2:$AB$50)+COUNTIF(AC$1:AC20,AC20)-1","v":4}]
[0.61571389174207924,{"$f":"RANK($A22,$A$2:$A$44)+COUNTIF(B$1:B21,B21)-1","v":30},"D.Hickmott",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2876868353564412,{"$f":"RANK($AB22,$AB$2:$AB$50)+COUNTIF(AC$1:AC21,AC21)-1","v":11}]
[{"$f":"RAND()*E23","v":0.98043107717199862},{"$f":"RANK($A23,$A$2:$A$44)+COUNTIF(B$1:B22,B22)-1","v":21},"D.Magill",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2575292199892694,{"$f":"RANK($AB23,$AB$2:$AB$50)+COUNTIF(AC$1:AC22,AC22)-1","v":12}]
[1.4831243854102336,{"$f":"RANK($A24,$A$2:$A$44)+COUNTIF(B$1:B23,B23)-1","v":7},"E.Mullally",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0615850642372173E-2,{"$f":"RANK($AB24,$AB$2:$AB$50)+COUNTIF(AC$1:AC23,AC23)-1","v":41}]
[1.383335242657989,{"$f":"RANK($A25,$A$2:$A$44)+COUNTIF(B$1:B24,B24)-1","v":9},"G.Franklin",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.18848183771165772,{"$f":"RANK($AB25,$AB$2:$AB$50)+COUNTIF(AC$1:AC24,AC24)-1","v":34}]
[1.2044821086715984,{"$f":"RANK($A26,$A$2:$A$44)+COUNTIF(B$1:B25,B25)-1","v":15},"G.Hawkins",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.78598787507622481,{"$f":"RANK($AB26,$AB$2:$AB$50)+COUNTIF(AC$1:AC25,AC25)-1","v":18}]
[1.1256593577853007,{"$f":"RANK($A27,$A$2:$A$44)+COUNTIF(B$1:B26,B26)-1","v":16},"I.Edgar",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.22138601606712172,{"$f":"RANK($AB27,$AB$2:$AB$50)+COUNTIF(AC$1:AC26,AC26)-1","v":33}]
[0.16492877332047273,{"$f":"RANK($A28,$A$2:$A$44)+COUNTIF(B$1:B27,B27)-1","v":38},"J.Allen",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12653479080854702,{"$f":"RANK($AB28,$AB$2:$AB$50)+COUNTIF(AC$1:AC27,AC27)-1","v":35}]
[1.3840341211361507,{"$f":"RANK($A29,$A$2:$A$44)+COUNTIF(B$1:B28,B28)-1","v":8},"J.Pyke",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3160983073765906,{"$f":"RANK($AB29,$AB$2:$AB$50)+COUNTIF(AC$1:AC28,AC28)-1","v":10}]
[0.59194071684928495,{"$f":"RANK($A30,$A$2:$A$44)+COUNTIF(B$1:B29,B29)-1","v":31},"J.Reynolds",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.7249757714750609E-9,{"$f":"RANK($AB30,$AB$2:$AB$50)+COUNTIF(AC$1:AC29,AC29)-1","v":47}]
[1.7268419641548878,{"$f":"RANK($A31,$A$2:$A$44)+COUNTIF(B$1:B30,B30)-1","v":2},"L.R.Brown",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0477158393537493E-2,{"$f":"RANK($AB31,$AB$2:$AB$50)+COUNTIF(AC$1:AC30,AC30)-1","v":42}]
[1.2510177792016179,{"$f":"RANK($A32,$A$2:$A$44)+COUNTIF(B$1:B31,B31)-1","v":14},"P.Green",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4685237419811088,{"$f":"RANK($AB32,$AB$2:$AB$50)+COUNTIF(AC$1:AC31,AC31)-1","v":27}]
[0.30672119499647543,{"$f":"RANK($A33,$A$2:$A$44)+COUNTIF(B$1:B32,B32)-1","v":36},"P.McArthur",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.70672765645049318,{"$f":"RANK($AB33,$AB$2:$AB$50)+COUNTIF(AC$1:AC32,AC32)-1","v":21}]
[1.5432742112431477,{"$f":"RANK($A34,$A$2:$A$44)+COUNTIF(B$1:B33,B33)-1","v":5},"P.Regan",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34617586509896947,{"$f":"RANK($AB34,$AB$2:$AB$50)+COUNTIF(AC$1:AC33,AC33)-1","v":29}]
[1.6829896112457257,{"$f":"RANK($A35,$A$2:$A$44)+COUNTIF(B$1:B34,B34)-1","v":4},"R.Diprose",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5181662474132169,{"$f":"RANK($AB35,$AB$2:$AB$50)+COUNTIF(AC$1:AC34,AC34)-1","v":7}]
[0.19633066320335102,{"$f":"RANK($A36,$A$2:$A$44)+COUNTIF(B$1:B35,B35)-1","v":37},"R.Pembroke",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9747051561660092,{"$f":"RANK($AB36,$AB$2:$AB$50)+COUNTIF(AC$1:AC35,AC35)-1","v":3}]
[0.70280797611244061,{"$f":"RANK($A37,$A$2:$A$44)+COUNTIF(B$1:B36,B36)-1","v":26},"R.Rozniak",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.58168947105795521,{"$f":"RANK($AB37,$AB$2:$AB$50)+COUNTIF(AC$1:AC36,AC36)-1","v":24}]
[0.46502519752274929,{"$f":"RANK($A38,$A$2:$A$44)+COUNTIF(B$1:B37,B37)-1","v":33},"S.Chow",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12227428348632863,{"$f":"RANK($AB38,$AB$2:$AB$50)+COUNTIF(AC$1:AC37,AC37)-1","v":36}]
[7.2377243980603076E-9,{"$f":"RANK($A39,$A$2:$A$44)+COUNTIF(B$1:B38,B38)-1","v":43},"S.Tariq",null,1E-8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9889482168584127,{"$f":"RANK($AB39,$AB$2:$AB$50)+COUNTIF(AC$1:AC38,AC38)-1","v":2}]
[9.8637277827930525E-2,{"$f":"RANK($A40,$A$2:$A$44)+COUNTIF(B$1:B39,B39)-1","v":41},"T.Doyle",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.30446700555111228,{"$f":"RANK($AB40,$AB$2:$AB$50)+COUNTIF(AC$1:AC39,AC39)-1","v":30}]
[0.62012912420031441,{"$f":"RANK($A41,$A$2:$A$44)+COUNTIF(B$1:B40,B40)-1","v":29},"T.Harman",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.620777332252743E-2,{"$f":"RANK($AB41,$AB$2:$AB$50)+COUNTIF(AC$1:AC40,AC40)-1","v":43}]
[2788118.9330470501,{"$f":"RANK($A42,$A$2:$A$44)+COUNTIF(B$1:B41,B41)-1","v":1},"T.Underwood",null,10000000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.94901580510187244,{"$f":"RANK($AB42,$AB$2:$AB$50)+COUNTIF(AC$1:AC41,AC41)-1","v":16}]
[0.10246385224548349,{"$f":"RANK($A43,$A$2:$A$44)+COUNTIF(B$1:B42,B42)-1","v":40},"T.Winter",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.64427677905512493,{"$f":"RANK($AB43,$AB$2:$AB$50)+COUNTIF(AC$1:AC42,AC42)-1","v":22}]
[{"$f":"RAND()*E44","v":1.0876400971230149},{"$f":"RANK($A44,$A$2:$A$44)+COUNTIF(B$1:B43,B43)-1","v":17},"V.Ilott",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.1138923045777052E-3,{"$f":"RANK($AB44,$AB$2:$AB$50)+COUNTIF(AC$1:AC43,AC43)-1","v":46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1341268842354815,{"$f":"RANK($AB45,$AB$2:$AB$50)+COUNTIF(AC$1:AC44,AC44)-1","v":14}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.8927636954236888E-3,{"$f":"RANK($AB46,$AB$2:$AB$50)+COUNTIF(AC$1:AC45,AC45)-1","v":45}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.063830356462086E-9,{"$f":"RANK($AB47,$AB$2:$AB$50)+COUNTIF(AC$1:AC46,AC46)-1","v":49}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.7951770747641147E-2,{"$f":"RANK($AB48,$AB$2:$AB$50)+COUNTIF(AC$1:AC47,AC47)-1","v":39}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5377723.7056112196,{"$f":"RANK($AB49,$AB$2:$AB$50)+COUNTIF(AC$1:AC48,AC48)-1","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3457144466761211,{"$f":"RANK($AB50,$AB$2:$AB$50)+COUNTIF(AC$1:AC49,AC49)-1","v":9}]

{"sheet":"ALL NAMES","index":4,"n_rows":67,"n_cols":2,"rows_kept":67,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["All Names!"]
[1,"A.Bradbury"]
[2,"A.Hussey"]
[3,"A.McFarlane"]
[4,"A.Nicholls"]
[5,"B.Ratcliffe"]
[6,"A.Wall"]
[7,"A.Walton"]
[8,"B.Golubkov"]
[9,"B.Ratcliffe"]
[10,"B.Sutton"]
[11,"C.Boateng"]
[12,"C.Keegan"]
[13,"D.Caffell"]
[14,"D.Cooke"]
[15,"D.Hickmott"]
[16,"D.Magill"]
[17,"D.Roczniak"]
[18,"E.Lindo"]
[19,"E.Mooney"]
[20,"E.Mullally"]
[21,"E.Selickis"]
[22,"G.Franklin"]
[23,"G.Hawkins"]
[24,"H.Mohamed"]
[25,"I.Edgar"]
[26,"J.Allen"]
[27,"J.Gorrell"]
[28,"J.Hough"]
[29,"J.Pyke"]
[30,"J.Reynolds"]
[31,"K.Pape"]
[32,"K.Verdi"]
[33,"L.R.Browne"]
[34,"M.Abu"]
[35,"M.Borek"]
[36,"M.Flanagan"]
[37,"M.Kochowski"]
[38,"M.Kumar"]
[39,"M.Lawson"]
[40,"M.Pushotam"]
[41,"N.Lukasevicius"]
[42,"P.Chapman"]
[43,"P.Green"]
[44,"P.Johnson"]
[45,"P.Lavender"]
[46,"P.McArthur"]
[47,"P.Regan"]
[48,"R.Diprose"]
[49,"R.Hallgally"]
[50,"R.O’Meara"]
[51,"R.Pembroke"]
[52,"R.Rozniak"]
[53,"S.Abraham"]
[54,"S.Brookman"]
[55,"S.Chow"]
[56,"S.Harrison"]
[57,"S.Monk"]
[58,"S.Pearce"]
[59,"S.Stretton"]
[60,"S.Tariq"]
[61,"T.Bryan"]
[62,"T.Doyle"]
[63,"T.Harman"]
[64,"T.Watkins"]
[65,"T.Winter"]
[66,"V.Ilott"]