{"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":3,"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$3:$A$45*Names!$F$3:$F$45, C6+1), Names!$A$3:$C$45, 3, 0)","v":"D.Hickmott"},"2PM",null,1,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$45*Names!$G$3:$G$45, G6+1), Names!$A$3:$C$45, 3, 0)","v":"S.Stretton"},"2PM",null,null,null,null,null,null,"K.Pape"]
[null,null,2,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$45*Names!$F$3:$F$45, C7+1), Names!$A$3:$C$45, 3, 0)","v":"J.Gorrell"},"2PM",null,2,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$45*Names!$G$3:$G$45, G7+1), Names!$A$3:$C$45, 3, 0)","v":"T.Bryan"},"2PM",null,null,null,null,null,null,"M.Abu"]
[null,null,3,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$45*Names!$F$3:$F$45, C8+1), Names!$A$3:$C$45, 3, 0)","v":"R.Hallgally"},"2PM",null,3,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$45*Names!$G$3:$G$45, G8+1), Names!$A$3:$C$45, 3, 0)","v":"R.Pembroke"},"2PM",null,null,null,null,null,null,"M.Flanagan"]
[null,null,4,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$45*Names!$F$3:$F$45, C9+1), Names!$A$3:$C$45, 3, 0)","v":"G.Hawkins"},"2PM",null,4,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$45*Names!$G$3:$G$45, G9+1), Names!$A$3:$C$45, 3, 0)","v":"E.Lindo"},"4PM",null,null,null,null,null,null,"M.Kumar"]
[null,null,5,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$45*Names!$F$3:$F$45, C10+1), Names!$A$3:$C$45, 3, 0)","v":"C.Boateng"},"4PM",null,5,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$45*Names!$G$3:$G$45, G10+1), Names!$A$3:$C$45, 3, 0)","v":"R.Diprose"},"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":" VLOOKUP( MAX(Names!$A$3:$A$45*Names!$J$3:$J$45), Names!$A$3:$C$45, 3, 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,"GOODS IN TEAM ",null,null,null,"FLOOR TEAM"]
[]
[null,null,1,"P.Regan","2PM",null,1,"A.Walton","2PM"]
[null,null,2,"M.Flanagan","2PM",null,2,"J.Gorrell","2PM"]
[null,null,3,"A.Wall","2PM",null,3,"M.Abu","2PM"]
[null,null,4,{"$error":"#NUM!"},"2PM",null,4,"E.Lindo","4PM"]
[null,null,5,"T.Winter","4PM",null,5,"G.Hawkins","4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[null,null,1,"S.Abraham","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)","Fl.Team(Days)","Forks(Days)","Pick. (Days)","Non.Productive",null,null,"Goods in","Picking","Floor team","Forks"]
[null,"Job History!",null,{"$f":"AVERAGE(D3:D999)","v":0.55223880597014929},{"$f":"AVERAGE(E3:E999)","v":0.59701492537313428},{"$f":"AVERAGE(F3:F999)","v":0.11940298507462686},{"$f":"AVERAGE(G3:G999)","v":0},{"$f":"AVERAGE(H3:H999)","v":1.2686567164179106},null,null,"T.Underwood",null,"A.Wall","M.Kumar"]
[null,1,"A.Bradbury",{"$f":"COUNTIF($K$2:$K$60000,C3)","v":1},{"$f":"COUNTIF($M$2:$M$60000,C3)","v":0},{"$f":"COUNTIF($N$2:$N$60000,C3)","v":0},{"$f":"COUNTIF($L$2:$L$60000,C3)","v":0},{"$f":"COUNTIF($K$2:$K$60000,C3)+COUNTIF($M$2:$M$60000,C3)+COUNTIF($N$2:$N$60000,C3)","v":1},null,null,"R.Diprose",null,"P.Green","S.Abraham"]
[null,2,"A.Hussey",{"$f":"COUNTIF($K$2:$K$60000,C4)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C4)","v":0},{"$f":"COUNTIF($N$2:$N$60000,C4)","v":0},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","S.Stretton"]
[null,3,"A.McFarlane",0,0,0,0,0,null,null,"C.Keegan",null,"R.Rozniak","K.Pape"]
[null,4,"A.Nicholls",1,1,0,0,2,null,null,"P.McArthur",null,"P.Chapman","T.Bryan"]
[null,5,"B.Ratcliffe",0,0,0,0,0,null,null,{"$error":"#N/A"},null,"G.Hawkins","S.Stretton"]
[null,6,"A.Wall",1,2,0,0,3,null,null,"J.Pyke",null,"K.Pape","S.Stretton"]
[null,7,"A.Walton",1,2,0,0,3,null,null,{"$error":"#N/A"},null,"C.Boateng","M.Kumar"]
[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,1,0,0,1,null,null,"M.Kumar",null,"A.Walton"]
[null,11,"C.Boateng",0,1,0,0,1,null,null,"K.Pape",null,"S.Pearce"]
[null,12,"C.Keegan",1,0,0,0,1,null,null,"A.Bradbury",null,"M.Lawson"]
[null,13,"D.Caffell",0,0,0,0,0,null,null,"A.Wall",null,"P.Green"]
[null,14,"D.Cooke",0,0,0,0,0,null,null,"S.Pearce",null,"T.Doyle"]
[null,15,"D.Hickmott",1,0,0,0,1,null,null,"G.Franklin",null,"R.Hallgally"]
[null,16,"D.Magill",1,0,0,0,1,null,null,"I.Edgar",null,"J.Pyke"]
[null,17,"D.Roczniak",0,0,0,0,0,null,null,"P.Chapman",null,"S.Chow"]
[null,18,"E.Lindo",1,0,0,0,1,null,null,"S.Abraham",null,"T.Underwood"]
[null,19,"E.Mooney",0,0,0,0,0,null,null,"S.Stretton",null,"M.Kumar"]
[null,20,"E.Mullally",1,2,0,0,3,null,null,"S.Chow",null,"S.Tariq"]
[null,21,"E.Selickis",0,0,0,0,0,null,null,"S.Tariq",null,"R.Pembroke"]
[null,22,"G.Franklin",{"$f":"COUNTIF($K$2:$K$60000,C24)","v":1},{"$f":"COUNTIF($M$2:$M$60000,C24)","v":0},{"$f":"COUNTIF($N$2:$N$60000,C24)","v":0},0,{"$f":"COUNTIF($K$2:$K$60000,C24)+COUNTIF($M$2:$M$60000,C24)+COUNTIF($N$2:$N$60000,C24)","v":1},null,null,"R.Pembroke",null,"J.Gorrell"]
[null,23,"G.Hawkins",{"$f":"COUNTIF($K$2:$K$60000,C25)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C25)","v":1},{"$f":"COUNTIF($N$2:$N$60000,C25)","v":0},0,{"$f":"COUNTIF($K$2:$K$60000,C25)+COUNTIF($M$2:$M$60000,C25)+COUNTIF($N$2:$N$60000,C25)","v":1},null,null,"J.Gorrell",null,"S.Stretton"]
[null,24,"H.Mohamed",0,0,0,0,0,null,null,"T.Bryan",null,"A.Nicholls"]
[null,25,"I.Edgar",1,0,0,0,1,null,null,"T.Harman",null,"R.Hallgally"]
[null,26,"J.Allen",1,1,0,0,2,null,null,"E.Lindo",null,"T.Winter"]
[null,27,"J.Gorrell",1,2,0,0,3,null,null,"P.Regan",null,"T.Bryan"]
[null,28,"J.Hough",0,0,0,0,0,null,null,"V.Ilott",null,"T.Doyle"]
[null,29,"J.Pyke",1,1,0,0,2,null,null,"R.Hallgally",null,"E.Mullally"]
[null,30,"J.Reynolds",0,0,0,0,0,null,null,"M.Lawson",null,"A.Walton"]
[null,31,"K.Pape",1,2,1,0,4,null,null,"P.Green",null,"J.Allen"]
[null,32,"K.Verdi",0,0,0,0,0,null,null,"J.Allen",null,"K.Pape"]
[null,33,"L.R.Browne",1,0,0,{"$f":"COUNTIF($L$2:$L$60000,C35)","v":0},1,null,null,"M.Abu",null,"J.Gorrell"]
[null,34,"M.Abu",1,1,0,0,2,null,null,"M.Flanagan",null,"M.Abu"]
[null,35,"M.Borek",0,0,0,0,0,null,null,"D.Magill",null,"T.Winter"]
[null,36,"M.Flanagan",1,0,0,0,1,null,null,"L.R.Browne",null,"R.Hallgally"]
[null,37,"M.Kochowski",0,0,0,0,0,null,null,"D.Hickmott",null,"S.Abraham"]
[null,38,"M.Kumar",1,1,2,0,4,null,null,"T.Winter",null,"A.Wall"]
[null,39,"M.Lawson",1,2,0,0,3,null,null,"E.Mullally",null,"S.Tariq"]
[null,40,"M.Pushotam",0,0,0,0,0]
[null,41,"N.Lukasevicius",0,0,0,0,0]
[null,42,"P.Chapman",1,1,0,0,2]
[null,43,"P.Green",{"$f":"COUNTIF($K$2:$K$60000,C45)","v":1},{"$f":"COUNTIF($M$2:$M$60000,C45)","v":2},{"$f":"COUNTIF($N$2:$N$60000,C45)","v":0},0,{"$f":"COUNTIF($K$2:$K$60000,C45)+COUNTIF($M$2:$M$60000,C45)+COUNTIF($N$2:$N$60000,C45)","v":3}]
[null,44,"P.Johnson",{"$f":"COUNTIF($K$2:$K$60000,C46)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C46)","v":0},{"$f":"COUNTIF($N$2:$N$60000,C46)","v":0},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",1,0,0,0,1]
[null,48,"R.Diprose",1,0,0,0,1]
[null,49,"R.Hallgally",1,3,0,0,4]
[null,50,"R.O’Meara",0,0,0,0,0]
[null,51,"R.Pembroke",1,1,0,0,2]
[null,52,"R.Rozniak",{"$f":"COUNTIF($K$2:$K$60000,C54)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C54)","v":1},{"$f":"COUNTIF($N$2:$N$60000,C54)","v":0},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",1,1,1,0,3]
[null,54,"S.Brookman",0,0,0,0,0]
[null,55,"S.Chow",1,1,0,0,2]
[null,56,"S.Harrison",0,0,0,0,0]
[null,57,"S.Monk",0,0,0,0,0]
[null,58,"S.Pearce",1,1,0,0,2]
[null,59,"S.Stretton",1,1,3,0,5]
[null,60,"S.Tariq",1,2,0,0,3]
[null,61,"T.Bryan",1,1,1,0,3]
[null,62,"T.Doyle",0,2,0,0,2]
[null,63,"T.Harman",1,0,0,0,1]
[null,64,"T.Watkins",0,0,0,0,0]
[null,65,"T.Winter",1,2,0,0,3]
[null,66,"V.Ilott",1,0,0,0,1]
[null,67,"T.Underwood",1,1,0,0,2]

{"sheet":"Names","index":3,"n_rows":51,"n_cols":30,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,{"$f":" SUM(H$3:H$99)","v":35},{"$f":" SUM(I$3:I$99)","v":42},{"$f":" SUM(J$3:J$99)","v":13},{"$f":" SUM(K$3:K$99)","v":42},{"$f":" SUM(L$3:L$99) / SUM(H$3:H$99)","v":1.0571428571428572},{"$f":" SUM(M$3:M$99) / SUM(I$3:I$99)","v":0.95238095238095233},{"$f":" SUM(N$3:N$99) / SUM(J$3:J$99)","v":0.61538461538461542}]
["Rand","Rank","Name",null,"умножатели","Фильтр (Goods in)","Фильтр (Fl.Team)","Goods in (Capability)","Fl.Team (Capability)","Forks (Capability)","Pick. (Capability)","Goods in(Days)","Fl.Team(Days)","Forks(Days)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rand","Rank"]
[{"$f":" INT(1000000*RAND()) + ROW()/1000","v":799904.00300000003},{"$f":"RANK($A3,$A$3:$A$45)+COUNTIF(B$2:B2,B2)-1","v":11},"E.Lindo",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L3, 0, --NOT($C3 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M3, 0, ISNA( MATCH($C3, Monday!$D$6:$D$13, 0) )* NOT($C3 = Monday!$D$15)  )","v":1},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C3, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RAND()*AG3","v":0},{"$f":"RANK($AC3,$AC$3:$AC$51)+COUNTIF(AD$2:AD2,AD2)-1","v":1}]
[941036.00399999996,{"$f":"RANK($A4,$A$3:$A$45)+COUNTIF(B$2:B3,B3)-1","v":4},"J.Gorrell",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L4, 0, --NOT($C4 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M4, 0, ISNA( MATCH($C4, Monday!$D$6:$D$13, 0) )* NOT($C4 = Monday!$D$15)  )","v":0},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C4, 'Job History'!$C$3:$C$99, 0),)","v":1},2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC4,$AC$3:$AC$51)+COUNTIF(AD$2:AD3,AD3)-1","v":1}]
[741499.005,{"$f":"RANK($A5,$A$3:$A$45)+COUNTIF(B$2:B4,B4)-1","v":17},"K.Pape",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L5, 0, --NOT($C5 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M5, 0, ISNA( MATCH($C5, Monday!$D$6:$D$13, 0) )* NOT($C5 = Monday!$D$15)  )","v":1},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C5, 'Job History'!$C$3:$C$99, 0),)","v":1},2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC5,$AC$3:$AC$51)+COUNTIF(AD$2:AD4,AD4)-1","v":2}]
[302407.00599999999,{"$f":"RANK($A6,$A$3:$A$45)+COUNTIF(B$2:B5,B5)-1","v":33},"M.Abu",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L6, 0, --NOT($C6 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M6, 0, ISNA( MATCH($C6, Monday!$D$6:$D$13, 0) )* NOT($C6 = Monday!$D$15)  )","v":1},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C6, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC6,$AC$3:$AC$51)+COUNTIF(AD$2:AD5,AD5)-1","v":1}]
[382622.00699999998,{"$f":"RANK($A7,$A$3:$A$45)+COUNTIF(B$2:B6,B6)-1","v":30},"M.Flanagan",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L7, 0, --NOT($C7 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M7, 0, ISNA( MATCH($C7, Monday!$D$6:$D$13, 0) )* NOT($C7 = Monday!$D$15)  )","v":1},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C7, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC7,$AC$3:$AC$51)+COUNTIF(AD$2:AD6,AD6)-1","v":3}]
[984398.00800000003,{"$f":"RANK($A8,$A$3:$A$45)+COUNTIF(B$2:B7,B7)-1","v":2},"M.Kumar",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L8, 0, --NOT($C8 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M8, 0, ISNA( MATCH($C8, Monday!$D$6:$D$13, 0) )* NOT($C8 = Monday!$D$15)  )","v":1},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C8, 'Job History'!$C$3:$C$99, 0),)","v":1},1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC8,$AC$3:$AC$51)+COUNTIF(AD$2:AD7,AD7)-1","v":1}]
[124457.00900000001,{"$f":"RANK($A9,$A$3:$A$45)+COUNTIF(B$2:B8,B8)-1","v":38},"M.Lawson",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L9, 0, --NOT($C9 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M9, 0, ISNA( MATCH($C9, Monday!$D$6:$D$13, 0) )* NOT($C9 = Monday!$D$15)  )","v":1},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C9, 'Job History'!$C$3:$C$99, 0),)","v":1},2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC9,$AC$3:$AC$51)+COUNTIF(AD$2:AD8,AD8)-1","v":4}]
[987446.01,{"$f":"RANK($A10,$A$3:$A$45)+COUNTIF(B$2:B9,B9)-1","v":1},"P.Chapman",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L10, 0, --NOT($C10 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M10, 0, ISNA( MATCH($C10, Monday!$D$6:$D$13, 0) )* NOT($C10 = Monday!$D$15)  )","v":0},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C10, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC10,$AC$3:$AC$51)+COUNTIF(AD$2:AD9,AD9)-1","v":1}]
[940098.01100000006,{"$f":"RANK($A11,$A$3:$A$45)+COUNTIF(B$2:B10,B10)-1","v":5},"R.Hallgally",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L11, 0, --NOT($C11 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M11, 0, ISNA( MATCH($C11, Monday!$D$6:$D$13, 0) )* NOT($C11 = Monday!$D$15)  )","v":0},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C11, 'Job History'!$C$3:$C$99, 0),)","v":1},3,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC11,$AC$3:$AC$51)+COUNTIF(AD$2:AD10,AD10)-1","v":5}]
[461645.01199999999,{"$f":"RANK($A12,$A$3:$A$45)+COUNTIF(B$2:B11,B11)-1","v":25},"S.Abraham",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L12, 0, --NOT($C12 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M12, 0, ISNA( MATCH($C12, Monday!$D$6:$D$13, 0) )* NOT($C12 = Monday!$D$15)  )","v":1},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C12, 'Job History'!$C$3:$C$99, 0),)","v":1},1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC12,$AC$3:$AC$51)+COUNTIF(AD$2:AD11,AD11)-1","v":1}]
[209453.01300000001,{"$f":"RANK($A13,$A$3:$A$45)+COUNTIF(B$2:B12,B12)-1","v":37},"S.Pearce",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L13, 0, --NOT($C13 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M13, 0, ISNA( MATCH($C13, Monday!$D$6:$D$13, 0) )* NOT($C13 = Monday!$D$15)  )","v":1},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C13, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC13,$AC$3:$AC$51)+COUNTIF(AD$2:AD12,AD12)-1","v":6}]
[884080.01399999997,{"$f":"RANK($A14,$A$3:$A$45)+COUNTIF(B$2:B13,B13)-1","v":8},"S.Stretton",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L14, 0, --NOT($C14 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M14, 0, ISNA( MATCH($C14, Monday!$D$6:$D$13, 0) )* NOT($C14 = Monday!$D$15)  )","v":1},1,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C14, 'Job History'!$C$3:$C$99, 0),)","v":1},1,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC14,$AC$3:$AC$51)+COUNTIF(AD$2:AD13,AD13)-1","v":1}]
[849083.01500000001,{"$f":"RANK($A15,$A$3:$A$45)+COUNTIF(B$2:B14,B14)-1","v":9},"T.Bryan",null,1.5,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L15, 0, --NOT($C15 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M15, 0, ISNA( MATCH($C15, Monday!$D$6:$D$13, 0) )* NOT($C15 = Monday!$D$15)  )","v":1},0,1,1,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C15, 'Job History'!$C$3:$C$99, 0),)","v":1},1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC15,$AC$3:$AC$51)+COUNTIF(AD$2:AD14,AD14)-1","v":7}]
[505499.016,{"$f":"RANK($A16,$A$3:$A$45)+COUNTIF(B$2:B15,B15)-1","v":22},"A.Bradbury",null,1,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L16, 0, --NOT($C16 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M16, 0, ISNA( MATCH($C16, Monday!$D$6:$D$13, 0) )* NOT($C16 = Monday!$D$15)  )","v":1},0,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C16, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC16,$AC$3:$AC$51)+COUNTIF(AD$2:AD15,AD15)-1","v":1}]
[765310.01699999999,{"$f":"RANK($A17,$A$3:$A$45)+COUNTIF(B$2:B16,B16)-1","v":14},"A.Nicholls",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L17, 0, --NOT($C17 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M17, 0, ISNA( MATCH($C17, Monday!$D$6:$D$13, 0) )* NOT($C17 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C17, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC17,$AC$3:$AC$51)+COUNTIF(AD$2:AD16,AD16)-1","v":8}]
[772345.01800000004,{"$f":"RANK($A18,$A$3:$A$45)+COUNTIF(B$2:B17,B17)-1","v":13},"A.Wall",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L18, 0, --NOT($C18 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M18, 0, ISNA( MATCH($C18, Monday!$D$6:$D$13, 0) )* NOT($C18 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C18, 'Job History'!$C$3:$C$99, 0),)","v":1},2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC18,$AC$3:$AC$51)+COUNTIF(AD$2:AD17,AD17)-1","v":1}]
[641223.01899999997,{"$f":"RANK($A19,$A$3:$A$45)+COUNTIF(B$2:B18,B18)-1","v":19},"A.Walton",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L19, 0, --NOT($C19 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M19, 0, ISNA( MATCH($C19, Monday!$D$6:$D$13, 0) )* NOT($C19 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C19, 'Job History'!$C$3:$C$99, 0),)","v":1},2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC19,$AC$3:$AC$51)+COUNTIF(AD$2:AD18,AD18)-1","v":9}]
[464904.02,{"$f":"RANK($A20,$A$3:$A$45)+COUNTIF(B$2:B19,B19)-1","v":24},"B.Sutton",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L20, 0, --NOT($C20 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M20, 0, ISNA( MATCH($C20, Monday!$D$6:$D$13, 0) )* NOT($C20 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C20, 'Job History'!$C$3:$C$99, 0),)","v":0},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC20,$AC$3:$AC$51)+COUNTIF(AD$2:AD19,AD19)-1","v":1}]
[907517.02099999995,{"$f":"RANK($A21,$A$3:$A$45)+COUNTIF(B$2:B20,B20)-1","v":7},"C.Boateng",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L21, 0, --NOT($C21 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M21, 0, ISNA( MATCH($C21, Monday!$D$6:$D$13, 0) )* NOT($C21 = Monday!$D$15)  )","v":0},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C21, 'Job History'!$C$3:$C$99, 0),)","v":0},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC21,$AC$3:$AC$51)+COUNTIF(AD$2:AD20,AD20)-1","v":10}]
[411491.022,{"$f":"RANK($A22,$A$3:$A$45)+COUNTIF(B$2:B21,B21)-1","v":28},"C.Keegan",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L22, 0, --NOT($C22 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M22, 0, ISNA( MATCH($C22, Monday!$D$6:$D$13, 0) )* NOT($C22 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C22, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC22,$AC$3:$AC$51)+COUNTIF(AD$2:AD21,AD21)-1","v":1}]
[971453.02300000004,{"$f":"RANK($A23,$A$3:$A$45)+COUNTIF(B$2:B22,B22)-1","v":3},"D.Hickmott",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L23, 0, --NOT($C23 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M23, 0, ISNA( MATCH($C23, Monday!$D$6:$D$13, 0) )* NOT($C23 = Monday!$D$15)  )","v":0},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C23, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC23,$AC$3:$AC$51)+COUNTIF(AD$2:AD22,AD22)-1","v":11}]
[77626.024000000005,{"$f":"RANK($A24,$A$3:$A$45)+COUNTIF(B$2:B23,B23)-1","v":39},"D.Magill",null,1,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L24, 0, --NOT($C24 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M24, 0, ISNA( MATCH($C24, Monday!$D$6:$D$13, 0) )* NOT($C24 = Monday!$D$15)  )","v":1},0,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C24, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC24,$AC$3:$AC$51)+COUNTIF(AD$2:AD23,AD23)-1","v":1}]
[354098.02500000002,{"$f":"RANK($A25,$A$3:$A$45)+COUNTIF(B$2:B24,B24)-1","v":32},"E.Mullally",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L25, 0, --NOT($C25 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M25, 0, ISNA( MATCH($C25, Monday!$D$6:$D$13, 0) )* NOT($C25 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C25, 'Job History'!$C$3:$C$99, 0),)","v":1},2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC25,$AC$3:$AC$51)+COUNTIF(AD$2:AD24,AD24)-1","v":12}]
[404116.02600000001,{"$f":"RANK($A26,$A$3:$A$45)+COUNTIF(B$2:B25,B25)-1","v":29},"G.Franklin",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L26, 0, --NOT($C26 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M26, 0, ISNA( MATCH($C26, Monday!$D$6:$D$13, 0) )* NOT($C26 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C26, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC26,$AC$3:$AC$51)+COUNTIF(AD$2:AD25,AD25)-1","v":1}]
[919485.027,{"$f":"RANK($A27,$A$3:$A$45)+COUNTIF(B$2:B26,B26)-1","v":6},"G.Hawkins",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L27, 0, --NOT($C27 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M27, 0, ISNA( MATCH($C27, Monday!$D$6:$D$13, 0) )* NOT($C27 = Monday!$D$15)  )","v":0},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C27, 'Job History'!$C$3:$C$99, 0),)","v":0},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC27,$AC$3:$AC$51)+COUNTIF(AD$2:AD26,AD26)-1","v":13}]
[218114.02799999999,{"$f":"RANK($A28,$A$3:$A$45)+COUNTIF(B$2:B27,B27)-1","v":36},"I.Edgar",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L28, 0, --NOT($C28 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M28, 0, ISNA( MATCH($C28, Monday!$D$6:$D$13, 0) )* NOT($C28 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C28, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC28,$AC$3:$AC$51)+COUNTIF(AD$2:AD27,AD27)-1","v":1}]
[52728.029000000002,{"$f":"RANK($A29,$A$3:$A$45)+COUNTIF(B$2:B28,B28)-1","v":41},"J.Allen",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L29, 0, --NOT($C29 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M29, 0, ISNA( MATCH($C29, Monday!$D$6:$D$13, 0) )* NOT($C29 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C29, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC29,$AC$3:$AC$51)+COUNTIF(AD$2:AD28,AD28)-1","v":14}]
[15951.03,{"$f":"RANK($A30,$A$3:$A$45)+COUNTIF(B$2:B29,B29)-1","v":42},"J.Pyke",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L30, 0, --NOT($C30 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M30, 0, ISNA( MATCH($C30, Monday!$D$6:$D$13, 0) )* NOT($C30 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C30, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC30,$AC$3:$AC$51)+COUNTIF(AD$2:AD29,AD29)-1","v":1}]
[239269.03099999999,{"$f":"RANK($A31,$A$3:$A$45)+COUNTIF(B$2:B30,B30)-1","v":35},"J.Reynolds",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L31, 0, --NOT($C31 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M31, 0, ISNA( MATCH($C31, Monday!$D$6:$D$13, 0) )* NOT($C31 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C31, 'Job History'!$C$3:$C$99, 0),)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC31,$AC$3:$AC$51)+COUNTIF(AD$2:AD30,AD30)-1","v":15}]
[574500.03200000001,{"$f":"RANK($A32,$A$3:$A$45)+COUNTIF(B$2:B31,B31)-1","v":21},"L.R.Browne",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L32, 0, --NOT($C32 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M32, 0, ISNA( MATCH($C32, Monday!$D$6:$D$13, 0) )* NOT($C32 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C32, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC32,$AC$3:$AC$51)+COUNTIF(AD$2:AD31,AD31)-1","v":1}]
[646794.03300000005,{"$f":"RANK($A33,$A$3:$A$45)+COUNTIF(B$2:B32,B32)-1","v":18},"P.Green",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L33, 0, --NOT($C33 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M33, 0, ISNA( MATCH($C33, Monday!$D$6:$D$13, 0) )* NOT($C33 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C33, 'Job History'!$C$3:$C$99, 0),)","v":1},2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC33,$AC$3:$AC$51)+COUNTIF(AD$2:AD32,AD32)-1","v":16}]
[460021.03399999999,{"$f":"RANK($A34,$A$3:$A$45)+COUNTIF(B$2:B33,B33)-1","v":26},"P.McArthur",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L34, 0, --NOT($C34 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M34, 0, ISNA( MATCH($C34, Monday!$D$6:$D$13, 0) )* NOT($C34 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C34, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC34,$AC$3:$AC$51)+COUNTIF(AD$2:AD33,AD33)-1","v":1}]
[496889.03499999997,{"$f":"RANK($A35,$A$3:$A$45)+COUNTIF(B$2:B34,B34)-1","v":23},"P.Regan",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L35, 0, --NOT($C35 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M35, 0, ISNA( MATCH($C35, Monday!$D$6:$D$13, 0) )* NOT($C35 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C35, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RAND()*AG35","v":0},{"$f":"RANK($AC35,$AC$3:$AC$51)+COUNTIF(AD$2:AD34,AD34)-1","v":17}]
[796241.03599999996,{"$f":"RANK($A36,$A$3:$A$45)+COUNTIF(B$2:B35,B35)-1","v":12},"R.Diprose",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L36, 0, --NOT($C36 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M36, 0, ISNA( MATCH($C36, Monday!$D$6:$D$13, 0) )* NOT($C36 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C36, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC36,$AC$3:$AC$51)+COUNTIF(AD$2:AD35,AD35)-1","v":1}]
[837487.03700000001,{"$f":"RANK($A37,$A$3:$A$45)+COUNTIF(B$2:B36,B36)-1","v":10},"R.Pembroke",null,1,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L37, 0, --NOT($C37 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M37, 0, ISNA( MATCH($C37, Monday!$D$6:$D$13, 0) )* NOT($C37 = Monday!$D$15)  )","v":1},0,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C37, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC37,$AC$3:$AC$51)+COUNTIF(AD$2:AD36,AD36)-1","v":18}]
[588138.03799999994,{"$f":"RANK($A38,$A$3:$A$45)+COUNTIF(B$2:B37,B37)-1","v":20},"R.Rozniak",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L38, 0, --NOT($C38 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M38, 0, ISNA( MATCH($C38, Monday!$D$6:$D$13, 0) )* NOT($C38 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C38, 'Job History'!$C$3:$C$99, 0),)","v":0},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC38,$AC$3:$AC$51)+COUNTIF(AD$2:AD37,AD37)-1","v":1}]
[2871.0390000000002,{"$f":"RANK($A39,$A$3:$A$45)+COUNTIF(B$2:B38,B38)-1","v":43},"S.Chow",null,1,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L39, 0, --NOT($C39 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M39, 0, ISNA( MATCH($C39, Monday!$D$6:$D$13, 0) )* NOT($C39 = Monday!$D$15)  )","v":1},0,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C39, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC39,$AC$3:$AC$51)+COUNTIF(AD$2:AD38,AD38)-1","v":19}]
[286670.03999999998,{"$f":"RANK($A40,$A$3:$A$45)+COUNTIF(B$2:B39,B39)-1","v":34},"S.Tariq",null,0,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L40, 0, --NOT($C40 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M40, 0, ISNA( MATCH($C40, Monday!$D$6:$D$13, 0) )* NOT($C40 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C40, 'Job History'!$C$3:$C$99, 0),)","v":1},2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC40,$AC$3:$AC$51)+COUNTIF(AD$2:AD39,AD39)-1","v":1}]
[756214.04099999997,{"$f":"RANK($A41,$A$3:$A$45)+COUNTIF(B$2:B40,B40)-1","v":15},"T.Doyle",null,1,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L41, 0, --NOT($C41 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M41, 0, ISNA( MATCH($C41, Monday!$D$6:$D$13, 0) )* NOT($C41 = Monday!$D$15)  )","v":1},0,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C41, 'Job History'!$C$3:$C$99, 0),)","v":0},2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC41,$AC$3:$AC$51)+COUNTIF(AD$2:AD40,AD40)-1","v":20}]
[369647.04200000002,{"$f":"RANK($A42,$A$3:$A$45)+COUNTIF(B$2:B41,B41)-1","v":31},"T.Harman",null,1,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L42, 0, --NOT($C42 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M42, 0, ISNA( MATCH($C42, Monday!$D$6:$D$13, 0) )* NOT($C42 = Monday!$D$15)  )","v":1},0,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C42, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC42,$AC$3:$AC$51)+COUNTIF(AD$2:AD41,AD41)-1","v":1}]
[745293.04299999995,{"$f":"RANK($A43,$A$3:$A$45)+COUNTIF(B$2:B42,B42)-1","v":16},"T.Underwood",null,10000000,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L43, 0, --NOT($C43 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M43, 0, ISNA( MATCH($C43, Monday!$D$6:$D$13, 0) )* NOT($C43 = Monday!$D$15)  )","v":1},1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C43, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC43,$AC$3:$AC$51)+COUNTIF(AD$2:AD42,AD42)-1","v":21}]
[70427.043999999994,{"$f":"RANK($A44,$A$3:$A$45)+COUNTIF(B$2:B43,B43)-1","v":40},"T.Winter",null,1,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L44, 0, --NOT($C44 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M44, 0, ISNA( MATCH($C44, Monday!$D$6:$D$13, 0) )* NOT($C44 = Monday!$D$15)  )","v":1},0,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C44, 'Job History'!$C$3:$C$99, 0),)","v":1},2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC44,$AC$3:$AC$51)+COUNTIF(AD$2:AD43,AD43)-1","v":1}]
[444883.04499999998,{"$f":"RANK($A45,$A$3:$A$45)+COUNTIF(B$2:B44,B44)-1","v":27},"V.Ilott",null,2,{"$f":" IF( 1.2 * MAX(0.5, L$1) + 1 < L45, 0, --NOT($C45 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, M$1) + 1 < M45, 0, ISNA( MATCH($C45, Monday!$D$6:$D$13, 0) )* NOT($C45 = Monday!$D$15)  )","v":1},1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C45, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AC45,$AC$3:$AC$51)+COUNTIF(AD$2:AD44,AD44)-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($AC46,$AC$3:$AC$51)+COUNTIF(AD$2:AD45,AD45)-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($AC47,$AC$3:$AC$51)+COUNTIF(AD$2:AD46,AD46)-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($AC48,$AC$3:$AC$51)+COUNTIF(AD$2:AD47,AD47)-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($AC49,$AC$3:$AC$51)+COUNTIF(AD$2:AD48,AD48)-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($AC50,$AC$3:$AC$51)+COUNTIF(AD$2:AD49,AD49)-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($AC51,$AC$3:$AC$51)+COUNTIF(AD$2:AD50,AD50)-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"]