{"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":2,"comments":1,"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,"GOODS IN TEAM ",null,null,null,"FLOOR TEAM",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( LARGE(Names!$A$2:$A$44*Names!$F$2:$F$44, C6), Names!$A$2:$C$44, 3, 0)","v":"D.Hickmott"},"2PM",null,1,{"$f":" VLOOKUP( LARGE(Names!$A$2:$A$44*Names!$G$2:$G$44, G6+5), Names!$A$2:$C$44, 3, 0)","v":"E.Mullally"},"2PM",null,null,null,null,null,null,"K.Pape"]
[null,null,2,{"$f":" VLOOKUP( LARGE(Names!$A$2:$A$44*Names!$F$2:$F$44, C7), Names!$A$2:$C$44, 3, 0)","v":"S.Stretton"},"2PM",null,2,{"$f":" VLOOKUP( LARGE(Names!$A$2:$A$44*Names!$G$2:$G$44, G7+5), Names!$A$2:$C$44, 3, 0)","v":"T.Underwood"},"2PM",null,null,null,null,null,null,"M.Abu"]
[null,null,3,{"$f":" VLOOKUP( LARGE(Names!$A$2:$A$44*Names!$F$2:$F$44, C8), Names!$A$2:$C$44, 3, 0)","v":"R.Hallgally"},"2PM",null,3,{"$f":" VLOOKUP( LARGE(Names!$A$2:$A$44*Names!$G$2:$G$44, G8+5), Names!$A$2:$C$44, 3, 0)","v":"P.McArthur"},"2PM",null,null,null,null,null,null,"M.Flanagan"]
[null,null,4,{"$f":" VLOOKUP( LARGE(Names!$A$2:$A$44*Names!$F$2:$F$44, C9), Names!$A$2:$C$44, 3, 0)","v":"A.Wall"},"2PM",null,4,{"$f":" VLOOKUP( LARGE(Names!$A$2:$A$44*Names!$G$2:$G$44, G9+5), Names!$A$2:$C$44, 3, 0)","v":"A.Bradbury"},"4PM",null,null,null,null,null,null,"M.Kumar"]
[null,null,5,{"$f":" VLOOKUP( LARGE(Names!$A$2:$A$44*Names!$F$2:$F$44, C10), Names!$A$2:$C$44, 3, 0)","v":"M.Kumar"},"4PM",null,5,{"$f":" VLOOKUP( LARGE(Names!$A$2:$A$44*Names!$G$2:$G$44, G10+5), Names!$A$2:$C$44, 3, 0)","v":"M.Lawson"},"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,"FORKS",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-11>=0,Names!$B$2:$B$14,FALSE)),IF(Names!$B$2:$B$14-11>=0,Names!$B$2:$B$14,FALSE),0))","v":{"$error":"#VALUE!"}},"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,"GOODS IN TEAM ",null,null,null,"FLOOR TEAM"]
[]
[null,null,1,{"$error":"#N/A"},"2PM",null,1,{"$error":"#N/A"},"2PM"]
[null,null,2,"D.Hickmott","2PM",null,2,"M.Flanagan","2PM"]
[null,null,3,{"$error":"#N/A"},"2PM",null,3,{"$error":"#N/A"},"2PM"]
[null,null,4,"T.Bryan","2PM",null,4,"S.Pearce","4PM"]
[null,null,5,"M.Abu","4PM",null,5,{"$error":"#N/A"},"4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[null,null,1,"S.Stretton","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":[]}
[null,"Nº","Name","Goods in(Days)","Pick. (Days)","Fl.Team(Days)","Forks(Days)","Non.Productive",null,null,"Goods in","Picking","Floor team","Forks"]
[null,"Job History!",null,{"$f":"AVERAGE(D3:D999)","v":0.1044776119402985},0,0.14925373134328357,2.9850746268656716E-2,0.28358208955223879,null,null,"T.Underwood",null,"A.Wall","M.Kumar"]
[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,null,"R.Diprose",null,"P.Green","S.Abraham"]
[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,null,"A.Nicholls",null,"E.Mullally"]
[null,3,"A.McFarlane",0,0,0,0,0,null,null,"C.Keegan",null,"R.Rozniak"]
[null,4,"A.Nicholls",1,0,0,0,1,null,null,"P.McArthur",null,"P.Chapman"]
[null,5,"B.Ratcliffe",0,0,0,0,0,null,null,{"$error":"#N/A"},null,"G.Hawkins"]
[null,6,"A.Wall",0,0,1,0,1,null,null,"J.Pyke",null,"K.Pape"]
[null,7,"A.Walton",1,0,0,0,1,null,null,{"$error":"#N/A"},null,"C.Boateng"]
[null,8,"B.Golubkov",0,0,0,0,0,null,null,"A.Walton",null,"B.Sutton"]
[null,9,"B.Ratcliffe",0,0,0,0,0,null,null,{"$error":"#N/A"},null,"M.Lawson"]
[null,10,"B.Sutton",0,0,1,0,1]
[null,11,"C.Boateng",0,0,1,0,1]
[null,12,"C.Keegan",1,0,0,0,1]
[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,1,0,1]
[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":1},{"$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":1}]
[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",1,0,0,0,1]
[null,30,"J.Reynolds",0,0,0,0,0]
[null,31,"K.Pape",0,0,1,0,1]
[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,1,1]
[null,39,"M.Lawson",0,0,1,0,1]
[null,40,"M.Pushotam",0,0,0,0,0]
[null,41,"N.Lukasevicius",0,0,0,0,0]
[null,42,"P.Chapman",0,0,1,0,1]
[null,43,"P.Green",{"$f":"COUNTIF($K$2:$K$60000,C45)","v":0},{"$f":"COUNTIF($L$2:$L$60000,C45)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C45)","v":1},{"$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":1}]
[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,0,0,0]
[null,46,"P.McArthur",1,0,0,0,1]
[null,47,"P.Regan",0,0,0,0,0]
[null,48,"R.Diprose",1,0,0,0,1]
[null,49,"R.Hallgally",0,0,0,0,0]
[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,0,1,1]
[null,54,"S.Brookman",0,0,0,0,0]
[null,55,"S.Chow",0,0,0,0,0]
[null,56,"S.Harrison",0,0,0,0,0]
[null,57,"S.Monk",0,0,0,0,0]
[null,58,"S.Pearce",0,0,0,0,0]
[null,59,"S.Stretton",0,0,0,0,0]
[null,60,"S.Tariq",0,0,0,0,0]
[null,61,"T.Bryan",0,0,0,0,0]
[null,62,"T.Doyle",0,0,0,0,0]
[null,63,"T.Harman",0,0,0,0,0]
[null,64,"T.Watkins",0,0,0,0,0]
[null,65,"T.Winter",0,0,0,0,0]
[null,66,"V.Ilott",0,0,0,0,0]
[null,67,"T.Underwood",1,0,0,0,1]

{"sheet":"Names","index":3,"n_rows":50,"n_cols":30,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Rand","Rank","Name",null,"умножатели","Фильтр (Goods in)","Фильтр (Fl.Team)","Goods in(Days)","Fl.Team(Days)","Pick. (Days)","Forks(Days)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rand","Rank"]
[{"$f":" INT(1000000*RAND()) + ROW()/1000","v":478205.00199999998},{"$f":"RANK($A2,$A$2:$A$44)+COUNTIF(B$1:B1,B1)-1","v":18},"E.Lindo",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C2, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C2, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RAND()*AG2","v":0},{"$f":"RANK($AC2,$AC$2:$AC$50)+COUNTIF(AD$1:AD1,AD1)-1","v":1}]
[46556.002999999997,{"$f":"RANK($A3,$A$2:$A$44)+COUNTIF(B$1:B2,B2)-1","v":42},"J.Gorrell",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C3, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C3, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC3,$AC$2:$AC$50)+COUNTIF(AD$1:AD2,AD2)-1","v":1}]
[575498.00399999996,{"$f":"RANK($A4,$A$2:$A$44)+COUNTIF(B$1:B3,B3)-1","v":16},"K.Pape",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C4, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C4, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC4,$AC$2:$AC$50)+COUNTIF(AD$1:AD3,AD3)-1","v":2}]
[329310.005,{"$f":"RANK($A5,$A$2:$A$44)+COUNTIF(B$1:B4,B4)-1","v":27},"M.Abu",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C5, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C5, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC5,$AC$2:$AC$50)+COUNTIF(AD$1:AD4,AD4)-1","v":1}]
[596714.00600000005,{"$f":"RANK($A6,$A$2:$A$44)+COUNTIF(B$1:B5,B5)-1","v":14},"M.Flanagan",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C6, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C6, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC6,$AC$2:$AC$50)+COUNTIF(AD$1:AD5,AD5)-1","v":3}]
[895789.00699999998,{"$f":"RANK($A7,$A$2:$A$44)+COUNTIF(B$1:B6,B6)-1","v":5},"M.Kumar",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C7, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C7, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC7,$AC$2:$AC$50)+COUNTIF(AD$1:AD6,AD6)-1","v":1}]
[688399.00800000003,{"$f":"RANK($A8,$A$2:$A$44)+COUNTIF(B$1:B7,B7)-1","v":10},"M.Lawson",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C8, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C8, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC8,$AC$2:$AC$50)+COUNTIF(AD$1:AD7,AD7)-1","v":4}]
[125460.00900000001,{"$f":"RANK($A9,$A$2:$A$44)+COUNTIF(B$1:B8,B8)-1","v":39},"P.Chapman",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C9, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C9, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC9,$AC$2:$AC$50)+COUNTIF(AD$1:AD8,AD8)-1","v":1}]
[973237.01,{"$f":"RANK($A10,$A$2:$A$44)+COUNTIF(B$1:B9,B9)-1","v":3},"R.Hallgally",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C10, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C10, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC10,$AC$2:$AC$50)+COUNTIF(AD$1:AD9,AD9)-1","v":5}]
[1487.011,{"$f":"RANK($A11,$A$2:$A$44)+COUNTIF(B$1:B10,B10)-1","v":43},"S.Abraham",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C11, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C11, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC11,$AC$2:$AC$50)+COUNTIF(AD$1:AD10,AD10)-1","v":1}]
[147032.01199999999,{"$f":"RANK($A12,$A$2:$A$44)+COUNTIF(B$1:B11,B11)-1","v":37},"S.Pearce",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C12, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C12, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC12,$AC$2:$AC$50)+COUNTIF(AD$1:AD11,AD11)-1","v":6}]
[977724.01300000004,{"$f":"RANK($A13,$A$2:$A$44)+COUNTIF(B$1:B12,B12)-1","v":2},"S.Stretton",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C13, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C13, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC13,$AC$2:$AC$50)+COUNTIF(AD$1:AD12,AD12)-1","v":1}]
[264238.01400000002,{"$f":"RANK($A14,$A$2:$A$44)+COUNTIF(B$1:B13,B13)-1","v":31},"T.Bryan",null,1.5,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C14, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C14, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC14,$AC$2:$AC$50)+COUNTIF(AD$1:AD13,AD13)-1","v":7}]
[735472.01500000001,{"$f":"RANK($A15,$A$2:$A$44)+COUNTIF(B$1:B14,B14)-1","v":9},"A.Bradbury",null,1,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C15, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C15, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC15,$AC$2:$AC$50)+COUNTIF(AD$1:AD14,AD14)-1","v":1}]
[306038.016,{"$f":"RANK($A16,$A$2:$A$44)+COUNTIF(B$1:B15,B15)-1","v":28},"A.Nicholls",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C16, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":0},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C16, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC16,$AC$2:$AC$50)+COUNTIF(AD$1:AD15,AD15)-1","v":8}]
[933880.01699999999,{"$f":"RANK($A17,$A$2:$A$44)+COUNTIF(B$1:B16,B16)-1","v":4},"A.Wall",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C17, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C17, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC17,$AC$2:$AC$50)+COUNTIF(AD$1:AD16,AD16)-1","v":1}]
[174012.01800000001,{"$f":"RANK($A18,$A$2:$A$44)+COUNTIF(B$1:B17,B17)-1","v":35},"A.Walton",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C18, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":0},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C18, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC18,$AC$2:$AC$50)+COUNTIF(AD$1:AD17,AD17)-1","v":9}]
[579388.01899999997,{"$f":"RANK($A19,$A$2:$A$44)+COUNTIF(B$1:B18,B18)-1","v":15},"B.Sutton",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C19, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C19, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC19,$AC$2:$AC$50)+COUNTIF(AD$1:AD18,AD18)-1","v":1}]
[249098.02,{"$f":"RANK($A20,$A$2:$A$44)+COUNTIF(B$1:B19,B19)-1","v":32},"C.Boateng",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C20, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C20, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC20,$AC$2:$AC$50)+COUNTIF(AD$1:AD19,AD19)-1","v":10}]
[75987.020999999993,{"$f":"RANK($A21,$A$2:$A$44)+COUNTIF(B$1:B20,B20)-1","v":40},"C.Keegan",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C21, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":0},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C21, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC21,$AC$2:$AC$50)+COUNTIF(AD$1:AD20,AD20)-1","v":1}]
[985729.022,{"$f":"RANK($A22,$A$2:$A$44)+COUNTIF(B$1:B21,B21)-1","v":1},"D.Hickmott",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C22, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C22, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC22,$AC$2:$AC$50)+COUNTIF(AD$1:AD21,AD21)-1","v":11}]
[145832.02299999999,{"$f":"RANK($A23,$A$2:$A$44)+COUNTIF(B$1:B22,B22)-1","v":38},"D.Magill",null,1,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C23, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C23, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC23,$AC$2:$AC$50)+COUNTIF(AD$1:AD22,AD22)-1","v":1}]
[893862.02399999998,{"$f":"RANK($A24,$A$2:$A$44)+COUNTIF(B$1:B23,B23)-1","v":6},"E.Mullally",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C24, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C24, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC24,$AC$2:$AC$50)+COUNTIF(AD$1:AD23,AD23)-1","v":12}]
[176194.02499999999,{"$f":"RANK($A25,$A$2:$A$44)+COUNTIF(B$1:B24,B24)-1","v":34},"G.Franklin",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C25, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C25, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC25,$AC$2:$AC$50)+COUNTIF(AD$1:AD24,AD24)-1","v":1}]
[411910.02600000001,{"$f":"RANK($A26,$A$2:$A$44)+COUNTIF(B$1:B25,B25)-1","v":25},"G.Hawkins",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C26, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C26, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC26,$AC$2:$AC$50)+COUNTIF(AD$1:AD25,AD25)-1","v":13}]
[242006.027,{"$f":"RANK($A27,$A$2:$A$44)+COUNTIF(B$1:B26,B26)-1","v":33},"I.Edgar",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C27, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C27, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC27,$AC$2:$AC$50)+COUNTIF(AD$1:AD26,AD26)-1","v":1}]
[462517.02799999999,{"$f":"RANK($A28,$A$2:$A$44)+COUNTIF(B$1:B27,B27)-1","v":20},"J.Allen",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C28, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C28, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC28,$AC$2:$AC$50)+COUNTIF(AD$1:AD27,AD27)-1","v":14}]
[394631.02899999998,{"$f":"RANK($A29,$A$2:$A$44)+COUNTIF(B$1:B28,B28)-1","v":26},"J.Pyke",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C29, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":0},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C29, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC29,$AC$2:$AC$50)+COUNTIF(AD$1:AD28,AD28)-1","v":1}]
[75380.03,{"$f":"RANK($A30,$A$2:$A$44)+COUNTIF(B$1:B29,B29)-1","v":41},"J.Reynolds",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C30, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C30, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC30,$AC$2:$AC$50)+COUNTIF(AD$1:AD29,AD29)-1","v":15}]
[446784.03100000002,{"$f":"RANK($A31,$A$2:$A$44)+COUNTIF(B$1:B30,B30)-1","v":22},"L.R.Browne",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C31, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C31, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC31,$AC$2:$AC$50)+COUNTIF(AD$1:AD30,AD30)-1","v":1}]
[565097.03200000001,{"$f":"RANK($A32,$A$2:$A$44)+COUNTIF(B$1:B31,B31)-1","v":17},"P.Green",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C32, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C32, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC32,$AC$2:$AC$50)+COUNTIF(AD$1:AD31,AD31)-1","v":16}]
[777582.03300000005,{"$f":"RANK($A33,$A$2:$A$44)+COUNTIF(B$1:B32,B32)-1","v":8},"P.McArthur",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C33, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":0},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C33, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC33,$AC$2:$AC$50)+COUNTIF(AD$1:AD32,AD32)-1","v":1}]
[169591.03400000001,{"$f":"RANK($A34,$A$2:$A$44)+COUNTIF(B$1:B33,B33)-1","v":36},"P.Regan",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C34, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C34, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RAND()*AG34","v":0},{"$f":"RANK($AC34,$AC$2:$AC$50)+COUNTIF(AD$1:AD33,AD33)-1","v":17}]
[602606.03500000003,{"$f":"RANK($A35,$A$2:$A$44)+COUNTIF(B$1:B34,B34)-1","v":13},"R.Diprose",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C35, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":0},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C35, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC35,$AC$2:$AC$50)+COUNTIF(AD$1:AD34,AD34)-1","v":1}]
[304953.03600000002,{"$f":"RANK($A36,$A$2:$A$44)+COUNTIF(B$1:B35,B35)-1","v":29},"R.Pembroke",null,1,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C36, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C36, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC36,$AC$2:$AC$50)+COUNTIF(AD$1:AD35,AD35)-1","v":18}]
[419247.03700000001,{"$f":"RANK($A37,$A$2:$A$44)+COUNTIF(B$1:B36,B36)-1","v":24},"R.Rozniak",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C37, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C37, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC37,$AC$2:$AC$50)+COUNTIF(AD$1:AD36,AD36)-1","v":1}]
[633598.03799999994,{"$f":"RANK($A38,$A$2:$A$44)+COUNTIF(B$1:B37,B37)-1","v":11},"S.Chow",null,1,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C38, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C38, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC38,$AC$2:$AC$50)+COUNTIF(AD$1:AD37,AD37)-1","v":19}]
[475742.03899999999,{"$f":"RANK($A39,$A$2:$A$44)+COUNTIF(B$1:B38,B38)-1","v":19},"S.Tariq",null,1E-8,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C39, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C39, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC39,$AC$2:$AC$50)+COUNTIF(AD$1:AD38,AD38)-1","v":1}]
[431707.04,{"$f":"RANK($A40,$A$2:$A$44)+COUNTIF(B$1:B39,B39)-1","v":23},"T.Doyle",null,1,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C40, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C40, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC40,$AC$2:$AC$50)+COUNTIF(AD$1:AD39,AD39)-1","v":20}]
[287288.04100000003,{"$f":"RANK($A41,$A$2:$A$44)+COUNTIF(B$1:B40,B40)-1","v":30},"T.Harman",null,1,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C41, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C41, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC41,$AC$2:$AC$50)+COUNTIF(AD$1:AD40,AD40)-1","v":1}]
[837968.04200000002,{"$f":"RANK($A42,$A$2:$A$44)+COUNTIF(B$1:B41,B41)-1","v":7},"T.Underwood",null,10000000,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C42, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":0},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C42, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC42,$AC$2:$AC$50)+COUNTIF(AD$1:AD41,AD41)-1","v":21}]
[450054.04300000001,{"$f":"RANK($A43,$A$2:$A$44)+COUNTIF(B$1:B42,B42)-1","v":21},"T.Winter",null,1,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C43, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C43, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},0,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC43,$AC$2:$AC$50)+COUNTIF(AD$1:AD42,AD42)-1","v":1}]
[606846.04399999999,{"$f":"RANK($A44,$A$2:$A$44)+COUNTIF(B$1:B43,B43)-1","v":12},"V.Ilott",null,2,{"$f":" IF( 'Job History'!$D$2 > 0, IF( 1.2*'Job History'!$D$2 < VLOOKUP($C44, 'Job History'!$C:$H, 2, 0), 0, 1 ), 1 )","v":1},{"$f":" IF( 'Job History'!$D$3 > 0, IF( 1.2*'Job History'!$D$3 < VLOOKUP($C44, 'Job History'!$C:$H, 3, 0), 0, 1 ), 1 )","v":1},1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC44,$AC$2:$AC$50)+COUNTIF(AD$1:AD43,AD43)-1","v":22}]
[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,null,0,{"$f":"RANK($AC45,$AC$2:$AC$50)+COUNTIF(AD$1:AD44,AD44)-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,null,0,{"$f":"RANK($AC46,$AC$2:$AC$50)+COUNTIF(AD$1:AD45,AD45)-1","v":23}]
[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,null,0,{"$f":"RANK($AC47,$AC$2:$AC$50)+COUNTIF(AD$1:AD46,AD46)-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,null,0,{"$f":"RANK($AC48,$AC$2:$AC$50)+COUNTIF(AD$1:AD47,AD47)-1","v":24}]
[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,null,0,{"$f":"RANK($AC49,$AC$2:$AC$50)+COUNTIF(AD$1:AD48,AD48)-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,null,0,{"$f":"RANK($AC50,$AC$2:$AC$50)+COUNTIF(AD$1:AD49,AD49)-1","v":25}]

{"sheet":"ALL NAMES","index":4,"n_rows":67,"n_cols":2,"rows_kept":67,"cut":false,"hidden":false,"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"]