{"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":4,"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":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[{"$f":" INDEX($Q$4:$Q$11, B1)","v":"Saturday 2"},7]
[]
[]
[null,null,null,"GOODS IN TEAM ",null,null,null,"FLOOR TEAM",null,null,null,null,null,null,null,"E.Lindo","Monday"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J.Gorrell","Tuesday"]
[null,null,1,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$99*Names!$D$3:$D$99, C6), Names!$A$3:$C$99, 3, 0)","v":"A.McFarlane"},"2PM",null,1,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$99*Names!$E$3:$E$99, G6), Names!$A$3:$C$99, 3, 0)","v":"N.Lukasevicius"},"2PM",null,null,null,null,null,null,"K.Pape","Wednesday"]
[null,null,2,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$99*Names!$D$3:$D$99, C7), Names!$A$3:$C$99, 3, 0)","v":"I.Edgar"},"2PM",null,2,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$99*Names!$E$3:$E$99, G7), Names!$A$3:$C$99, 3, 0)","v":"R.Pembroke"},"2PM",null,null,null,null,null,null,"M.Abu","Thursday"]
[null,null,3,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$99*Names!$D$3:$D$99, C8), Names!$A$3:$C$99, 3, 0)","v":"A.Goodman"},"2PM",null,3,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$99*Names!$E$3:$E$99, G8), Names!$A$3:$C$99, 3, 0)","v":"M.Kochowski"},"2PM",null,null,null,null,null,null,"M.Flanagan","Friday"]
[null,null,4,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$99*Names!$D$3:$D$99, C9), Names!$A$3:$C$99, 3, 0)","v":"E.Selickis"},"2PM",null,4,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$99*Names!$E$3:$E$99, G9), Names!$A$3:$C$99, 3, 0)","v":"T.Harman"},"4PM",null,null,null,null,null,null,"M.Kumar","Saturday 1"]
[null,null,5,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$99*Names!$D$3:$D$99, C10), Names!$A$3:$C$99, 3, 0)","v":"B.Golubkov"},"4PM",null,5,{"$f":" VLOOKUP( LARGE(Names!$A$3:$A$99*Names!$E$3:$E$99, G10), Names!$A$3:$C$99, 3, 0)","v":"M.Flanagan"},"4PM",null,null,null,null,null,null,"M.Lawson","Saturday 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P.Chapman","Sunday"]
[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$99 * Names!$H$3:$H$99 * INDEX(Names!$J$3:$Q$99,,$B$1)), Names!$A$3:$C$99, 3, 0)","v":"S.Pearce"},"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,"M.Abu","2PM",null,1,"M.Abu","2PM"]
[null,null,2,"R.Diprose","2PM",null,2,"R.Diprose","2PM"]
[null,null,3,"M.Flanagan","2PM",null,3,"M.Flanagan","2PM"]
[null,null,4,"R.Hallgally","2PM",null,4,"T.Winter","4PM"]
[null,null,5,"T.Winter","4PM",null,5,"B.Sutton","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":70,"n_cols":14,"rows_kept":70,"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.61764705882352944},{"$f":"AVERAGE(E3:E999)","v":0.66176470588235292},{"$f":"AVERAGE(F3:F999)","v":0.13235294117647059},{"$f":"AVERAGE(G3:G999)","v":0},{"$f":"AVERAGE(H3:H999)","v":1.411764705882353},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","S.Stretton"]
[null,9,"B.Ratcliffe",0,0,0,0,0,null,null,{"$error":"#N/A"},null,"M.Lawson"]
[null,10,"B.Sutton",0,2,0,0,2,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",2,2,0,0,4,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",2,1,0,0,3,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,null,"M.Abu",null,"M.Abu"]
[null,41,"N.Lukasevicius",0,0,0,0,0,null,null,"R.Diprose",null,"R.Diprose"]
[null,42,"P.Chapman",1,1,0,0,2,null,null,"M.Flanagan",null,"M.Flanagan"]
[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,null,"R.Hallgally",null,"T.Winter"]
[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,null,"T.Winter",null,"B.Sutton"]
[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",2,1,0,0,3]
[null,49,"R.Hallgally",2,3,0,0,5]
[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,4,0,6]
[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",2,3,0,0,5]
[null,66,"V.Ilott",1,0,0,0,1]
[null,67,"T.Underwood",1,1,0,0,2]
[null,68,"A.Goodman",0,0,0,0,0]

{"sheet":"Names","index":3,"n_rows":69,"n_cols":36,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,{"$f":" SUM(F$3:F$99)","v":52},{"$f":" SUM(G$3:G$99)","v":65},{"$f":" SUM(H$3:H$99)","v":18},{"$f":" SUM(I$3:I$99)","v":65},{"$f":"COUNTIF(J3:J99,1)","v":42},{"$f":"COUNTIF(K3:K99,1)","v":49},50,57,51,15,16,29,{"$f":" SUM(R$3:R$99) / SUM(F$3:F$99)","v":0.80769230769230771},{"$f":" SUM(S$3:S$99) / SUM(G$3:G$99)","v":0.69230769230769229},{"$f":" SUM(T$3:T$99) / SUM(H$3:H$99)","v":0.5}]
["Rand","Rank","Name","Фильтр (Goods in)","Фильтр (Fl.Team)","Goods in (Capability)","Fl.Team (Capability)","Forks (Capability)","Pick. (Capability)","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday 1","Saturday 2","Sunday","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":313650.00300000003},null,"A.Bradbury",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R3, 0, INDEX($J3:$Q3, Monday!$B$1) * NOT($C3 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S3, 0, INDEX($J3:$Q3, Monday!$B$1) * ISNA(MATCH($C3, Monday!$D$6:$D$13, 0)) * NOT($C3 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,0,0,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()*AM3","v":0},{"$f":"RANK($AI3,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ2,AJ2)-1","v":1}]
[708346.00399999996,null,"A.Hussey",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R4, 0, INDEX($J4:$Q4, Monday!$B$1) * NOT($C4 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S4, 0, INDEX($J4:$Q4, Monday!$B$1) * ISNA(MATCH($C4, Monday!$D$6:$D$13, 0)) * NOT($C4 = Monday!$D$15)  )","v":0},1,1,0,1,0,0,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C4, '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($AI4,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ3,AJ3)-1","v":1}]
[984195.005,null,"A.McFarlane",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R5, 0, INDEX($J5:$Q5, Monday!$B$1) * NOT($C5 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S5, 0, INDEX($J5:$Q5, Monday!$B$1) * ISNA(MATCH($C5, Monday!$D$6:$D$13, 0)) * NOT($C5 = Monday!$D$15)  )","v":0},1,1,0,1,0,1,1,1,1,1,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C5, '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($AI5,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ4,AJ4)-1","v":2}]
[633203.00600000005,null,"A.Nicholls",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R6, 0, INDEX($J6:$Q6, Monday!$B$1) * NOT($C6 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S6, 0, INDEX($J6:$Q6, Monday!$B$1) * ISNA(MATCH($C6, Monday!$D$6:$D$13, 0)) * NOT($C6 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,0,0,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($AI6,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ5,AJ5)-1","v":1}]
[717991.00699999998,null,"A.Wall",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R7, 0, INDEX($J7:$Q7, Monday!$B$1) * NOT($C7 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S7, 0, INDEX($J7:$Q7, Monday!$B$1) * ISNA(MATCH($C7, Monday!$D$6:$D$13, 0)) * NOT($C7 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C7, '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($AI7,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ6,AJ6)-1","v":3}]
[14617.008,null,"A.Walton",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R8, 0, INDEX($J8:$Q8, Monday!$B$1) * NOT($C8 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S8, 0, INDEX($J8:$Q8, Monday!$B$1) * ISNA(MATCH($C8, Monday!$D$6:$D$13, 0)) * NOT($C8 = Monday!$D$15)  )","v":0},0,1,0,1,1,0,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C8, '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($AI8,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ7,AJ7)-1","v":1}]
[878508.00899999996,null,"B.Golubkov",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R9, 0, INDEX($J9:$Q9, Monday!$B$1) * NOT($C9 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S9, 0, INDEX($J9:$Q9, Monday!$B$1) * ISNA(MATCH($C9, Monday!$D$6:$D$13, 0)) * NOT($C9 = Monday!$D$15)  )","v":0},1,1,0,1,0,1,1,1,1,1,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C9, '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($AI9,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ8,AJ8)-1","v":4}]
[180401.01,null,"B.Ratcliffe",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R10, 0, INDEX($J10:$Q10, Monday!$B$1) * NOT($C10 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S10, 0, INDEX($J10:$Q10, Monday!$B$1) * ISNA(MATCH($C10, Monday!$D$6:$D$13, 0)) * NOT($C10 = Monday!$D$15)  )","v":0},0,1,0,1,0,0,0,1,1,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C10, '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($AI10,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ9,AJ9)-1","v":1}]
[734821.01100000006,null,"B.Sutton",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R11, 0, INDEX($J11:$Q11, Monday!$B$1) * NOT($C11 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S11, 0, INDEX($J11:$Q11, Monday!$B$1) * ISNA(MATCH($C11, Monday!$D$6:$D$13, 0)) * NOT($C11 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,0,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C11, '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($AI11,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ10,AJ10)-1","v":5}]
[15784.012000000001,null,"C.Boateng",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R12, 0, INDEX($J12:$Q12, Monday!$B$1) * NOT($C12 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S12, 0, INDEX($J12:$Q12, Monday!$B$1) * ISNA(MATCH($C12, Monday!$D$6:$D$13, 0)) * NOT($C12 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C12, '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($AI12,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ11,AJ11)-1","v":1}]
[527806.01300000004,null,"C.Keegan",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R13, 0, INDEX($J13:$Q13, Monday!$B$1) * NOT($C13 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S13, 0, INDEX($J13:$Q13, Monday!$B$1) * ISNA(MATCH($C13, Monday!$D$6:$D$13, 0)) * NOT($C13 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,1,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C13, '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($AI13,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ12,AJ12)-1","v":6}]
[860825.01399999997,null,"D.Caffell",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R14, 0, INDEX($J14:$Q14, Monday!$B$1) * NOT($C14 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S14, 0, INDEX($J14:$Q14, Monday!$B$1) * ISNA(MATCH($C14, Monday!$D$6:$D$13, 0)) * NOT($C14 = Monday!$D$15)  )","v":0},1,1,1,1,0,1,1,0,0,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C14, '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($AI14,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ13,AJ13)-1","v":1}]
[51027.014999999999,null,"D.Cooke",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R15, 0, INDEX($J15:$Q15, Monday!$B$1) * NOT($C15 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S15, 0, INDEX($J15:$Q15, Monday!$B$1) * ISNA(MATCH($C15, Monday!$D$6:$D$13, 0)) * NOT($C15 = Monday!$D$15)  )","v":0},1,1,1,1,0,0,0,1,1,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C15, '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($AI15,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ14,AJ14)-1","v":7}]
[164768.016,null,"D.Hickmott",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R16, 0, INDEX($J16:$Q16, Monday!$B$1) * NOT($C16 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S16, 0, INDEX($J16:$Q16, Monday!$B$1) * ISNA(MATCH($C16, Monday!$D$6:$D$13, 0)) * NOT($C16 = Monday!$D$15)  )","v":1},1,1,0,1,1,1,1,1,1,1,1,0,{"$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($AI16,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ15,AJ15)-1","v":1}]
[635377.01699999999,null,"D.Magill",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R17, 0, INDEX($J17:$Q17, Monday!$B$1) * NOT($C17 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S17, 0, INDEX($J17:$Q17, Monday!$B$1) * ISNA(MATCH($C17, Monday!$D$6:$D$13, 0)) * NOT($C17 = Monday!$D$15)  )","v":0},0,1,0,1,1,0,1,1,1,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C17, '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($AI17,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ16,AJ16)-1","v":8}]
[396277.01799999998,null,"D.Roczniak",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R18, 0, INDEX($J18:$Q18, Monday!$B$1) * NOT($C18 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S18, 0, INDEX($J18:$Q18, Monday!$B$1) * ISNA(MATCH($C18, Monday!$D$6:$D$13, 0)) * NOT($C18 = Monday!$D$15)  )","v":0},1,1,0,1,0,1,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C18, '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($AI18,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ17,AJ17)-1","v":1}]
[473306.01899999997,null,"E.Lindo",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R19, 0, INDEX($J19:$Q19, Monday!$B$1) * NOT($C19 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S19, 0, INDEX($J19:$Q19, Monday!$B$1) * ISNA(MATCH($C19, Monday!$D$6:$D$13, 0)) * NOT($C19 = Monday!$D$15)  )","v":0},1,1,1,1,1,1,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C19, '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($AI19,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ18,AJ18)-1","v":9}]
[634227.02,null,"E.Mooney",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R20, 0, INDEX($J20:$Q20, Monday!$B$1) * NOT($C20 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S20, 0, INDEX($J20:$Q20, Monday!$B$1) * ISNA(MATCH($C20, Monday!$D$6:$D$13, 0)) * NOT($C20 = Monday!$D$15)  )","v":0},0,1,0,1,0,1,0,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C20, '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($AI20,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ19,AJ19)-1","v":1}]
[12119.021000000001,null,"E.Mullally",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R21, 0, INDEX($J21:$Q21, Monday!$B$1) * NOT($C21 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S21, 0, INDEX($J21:$Q21, Monday!$B$1) * ISNA(MATCH($C21, Monday!$D$6:$D$13, 0)) * NOT($C21 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,0,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C21, '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($AI21,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ20,AJ20)-1","v":10}]
[882832.022,null,"E.Selickis",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R22, 0, INDEX($J22:$Q22, Monday!$B$1) * NOT($C22 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S22, 0, INDEX($J22:$Q22, Monday!$B$1) * ISNA(MATCH($C22, Monday!$D$6:$D$13, 0)) * NOT($C22 = Monday!$D$15)  )","v":0},1,1,0,1,0,1,1,1,1,1,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C22, '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($AI22,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ21,AJ21)-1","v":1}]
[596899.02300000004,null,"G.Franklin",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R23, 0, INDEX($J23:$Q23, Monday!$B$1) * NOT($C23 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S23, 0, INDEX($J23:$Q23, Monday!$B$1) * ISNA(MATCH($C23, Monday!$D$6:$D$13, 0)) * NOT($C23 = Monday!$D$15)  )","v":0},1,0,1,1,1,1,1,1,1,0,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($AI23,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ22,AJ22)-1","v":11}]
[464007.02399999998,null,"G.Hawkins",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R24, 0, INDEX($J24:$Q24, Monday!$B$1) * NOT($C24 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S24, 0, INDEX($J24:$Q24, Monday!$B$1) * ISNA(MATCH($C24, Monday!$D$6:$D$13, 0)) * NOT($C24 = Monday!$D$15)  )","v":0},1,1,0,1,1,0,0,0,1,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C24, '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($AI24,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ23,AJ23)-1","v":1}]
[445452.02500000002,null,"H.Mohamed",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R25, 0, INDEX($J25:$Q25, Monday!$B$1) * NOT($C25 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S25, 0, INDEX($J25:$Q25, Monday!$B$1) * ISNA(MATCH($C25, Monday!$D$6:$D$13, 0)) * NOT($C25 = Monday!$D$15)  )","v":0},0,1,0,1,0,1,1,0,0,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C25, '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($AI25,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ24,AJ24)-1","v":12}]
[945293.02599999995,null,"I.Edgar",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R26, 0, INDEX($J26:$Q26, Monday!$B$1) * NOT($C26 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S26, 0, INDEX($J26:$Q26, Monday!$B$1) * ISNA(MATCH($C26, Monday!$D$6:$D$13, 0)) * NOT($C26 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,0,1,0,{"$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($AI26,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ25,AJ25)-1","v":1}]
[419768.027,null,"J.Allen",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R27, 0, INDEX($J27:$Q27, Monday!$B$1) * NOT($C27 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S27, 0, INDEX($J27:$Q27, Monday!$B$1) * ISNA(MATCH($C27, Monday!$D$6:$D$13, 0)) * NOT($C27 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C27, '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($AI27,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ26,AJ26)-1","v":13}]
[901490.02800000005,null,"J.Gorrell",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R28, 0, INDEX($J28:$Q28, Monday!$B$1) * NOT($C28 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S28, 0, INDEX($J28:$Q28, Monday!$B$1) * ISNA(MATCH($C28, Monday!$D$6:$D$13, 0)) * NOT($C28 = Monday!$D$15)  )","v":0},1,1,1,1,1,1,0,1,0,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C28, '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($AI28,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ27,AJ27)-1","v":1}]
[330949.02899999998,null,"J.Hough",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R29, 0, INDEX($J29:$Q29, Monday!$B$1) * NOT($C29 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S29, 0, INDEX($J29:$Q29, Monday!$B$1) * ISNA(MATCH($C29, Monday!$D$6:$D$13, 0)) * NOT($C29 = Monday!$D$15)  )","v":0},0,1,0,1,0,1,0,1,0,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C29, '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($AI29,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ28,AJ28)-1","v":14}]
[221397.03,null,"J.Pyke",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R30, 0, INDEX($J30:$Q30, Monday!$B$1) * NOT($C30 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S30, 0, INDEX($J30:$Q30, Monday!$B$1) * ISNA(MATCH($C30, Monday!$D$6:$D$13, 0)) * NOT($C30 = Monday!$D$15)  )","v":0},1,1,0,1,1,0,1,0,0,0,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($AI30,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ29,AJ29)-1","v":1}]
[393679.03100000002,null,"J.Reynolds",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R31, 0, INDEX($J31:$Q31, Monday!$B$1) * NOT($C31 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S31, 0, INDEX($J31:$Q31, Monday!$B$1) * ISNA(MATCH($C31, Monday!$D$6:$D$13, 0)) * NOT($C31 = Monday!$D$15)  )","v":0},1,1,0,1,1,0,0,1,0,0,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($AI31,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ30,AJ30)-1","v":15}]
[541079.03200000001,null,"K.Pape",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R32, 0, INDEX($J32:$Q32, Monday!$B$1) * NOT($C32 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S32, 0, INDEX($J32:$Q32, Monday!$B$1) * ISNA(MATCH($C32, Monday!$D$6:$D$13, 0)) * NOT($C32 = Monday!$D$15)  )","v":0},1,1,1,1,1,0,0,0,0,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C32, '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($AI32,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ31,AJ31)-1","v":1}]
[30962.032999999999,null,"K.Verdi",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R33, 0, INDEX($J33:$Q33, Monday!$B$1) * NOT($C33 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S33, 0, INDEX($J33:$Q33, Monday!$B$1) * ISNA(MATCH($C33, Monday!$D$6:$D$13, 0)) * NOT($C33 = Monday!$D$15)  )","v":0},1,1,0,1,0,1,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C33, '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($AI33,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ32,AJ32)-1","v":16}]
[705758.03399999999,null,"L.R.Browne",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R34, 0, INDEX($J34:$Q34, Monday!$B$1) * NOT($C34 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S34, 0, INDEX($J34:$Q34, Monday!$B$1) * ISNA(MATCH($C34, Monday!$D$6:$D$13, 0)) * NOT($C34 = Monday!$D$15)  )","v":0},1,1,0,1,0,1,0,1,1,1,0,0,{"$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($AI34,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ33,AJ33)-1","v":1}]
[924972.03500000003,null,"M.Abu",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R35, 0, INDEX($J35:$Q35, Monday!$B$1) * NOT($C35 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S35, 0, INDEX($J35:$Q35, Monday!$B$1) * ISNA(MATCH($C35, Monday!$D$6:$D$13, 0)) * NOT($C35 = Monday!$D$15)  )","v":0},1,1,1,1,1,1,1,1,1,1,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C35, 'Job History'!$C$3:$C$99, 0),)","v":2},2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RAND()*AM35","v":0},{"$f":"RANK($AI35,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ34,AJ34)-1","v":17}]
[437000.03600000002,null,"M.Borek",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R36, 0, INDEX($J36:$Q36, Monday!$B$1) * NOT($C36 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S36, 0, INDEX($J36:$Q36, Monday!$B$1) * ISNA(MATCH($C36, Monday!$D$6:$D$13, 0)) * NOT($C36 = Monday!$D$15)  )","v":0},1,1,0,1,0,1,1,0,0,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C36, '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($AI36,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ35,AJ35)-1","v":1}]
[211822.03700000001,null,"M.Flanagan",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R37, 0, INDEX($J37:$Q37, Monday!$B$1) * NOT($C37 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S37, 0, INDEX($J37:$Q37, Monday!$B$1) * ISNA(MATCH($C37, Monday!$D$6:$D$13, 0)) * NOT($C37 = Monday!$D$15)  )","v":1},1,1,1,1,1,1,1,1,1,0,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C37, 'Job History'!$C$3:$C$99, 0),)","v":2},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AI37,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ36,AJ36)-1","v":18}]
[431663.038,null,"M.Kochowski",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R38, 0, INDEX($J38:$Q38, Monday!$B$1) * NOT($C38 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S38, 0, INDEX($J38:$Q38, Monday!$B$1) * ISNA(MATCH($C38, Monday!$D$6:$D$13, 0)) * NOT($C38 = Monday!$D$15)  )","v":1},1,1,0,1,0,1,1,1,1,1,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C38, '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($AI38,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ37,AJ37)-1","v":1}]
[40378.038999999997,null,"M.Kumar",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R39, 0, INDEX($J39:$Q39, Monday!$B$1) * NOT($C39 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S39, 0, INDEX($J39:$Q39, Monday!$B$1) * ISNA(MATCH($C39, Monday!$D$6:$D$13, 0)) * NOT($C39 = Monday!$D$15)  )","v":1},1,1,1,1,1,1,1,1,1,0,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C39, '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($AI39,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ38,AJ38)-1","v":19}]
[2081.04,null,"M.Lawson",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R40, 0, INDEX($J40:$Q40, Monday!$B$1) * NOT($C40 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S40, 0, INDEX($J40:$Q40, Monday!$B$1) * ISNA(MATCH($C40, Monday!$D$6:$D$13, 0)) * NOT($C40 = Monday!$D$15)  )","v":0},1,1,1,1,1,1,1,1,1,1,0,0,{"$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($AI40,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ39,AJ39)-1","v":1}]
[630576.04099999997,null,"M.Pushotam",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R41, 0, INDEX($J41:$Q41, Monday!$B$1) * NOT($C41 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S41, 0, INDEX($J41:$Q41, Monday!$B$1) * ISNA(MATCH($C41, Monday!$D$6:$D$13, 0)) * NOT($C41 = Monday!$D$15)  )","v":0},1,1,0,1,0,1,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C41, '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($AI41,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ40,AJ40)-1","v":20}]
[740295.04200000002,null,"N.Lukasevicius",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R42, 0, INDEX($J42:$Q42, Monday!$B$1) * NOT($C42 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S42, 0, INDEX($J42:$Q42, Monday!$B$1) * ISNA(MATCH($C42, Monday!$D$6:$D$13, 0)) * NOT($C42 = Monday!$D$15)  )","v":1},1,1,0,1,0,1,1,1,1,1,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C42, '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($AI42,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ41,AJ41)-1","v":1}]
[439837.04300000001,null,"P.Chapman",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R43, 0, INDEX($J43:$Q43, Monday!$B$1) * NOT($C43 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S43, 0, INDEX($J43:$Q43, Monday!$B$1) * ISNA(MATCH($C43, Monday!$D$6:$D$13, 0)) * NOT($C43 = Monday!$D$15)  )","v":0},1,1,1,0,1,1,1,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($AI43,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ42,AJ42)-1","v":21}]
[210331.04399999999,null,"P.Green",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R44, 0, INDEX($J44:$Q44, Monday!$B$1) * NOT($C44 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S44, 0, INDEX($J44:$Q44, Monday!$B$1) * ISNA(MATCH($C44, Monday!$D$6:$D$13, 0)) * NOT($C44 = Monday!$D$15)  )","v":0},1,1,0,1,1,0,0,0,0,0,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($AI44,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ43,AJ43)-1","v":1}]
[493020.04499999998,null,"P.Johnson",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R45, 0, INDEX($J45:$Q45, Monday!$B$1) * NOT($C45 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S45, 0, INDEX($J45:$Q45, Monday!$B$1) * ISNA(MATCH($C45, Monday!$D$6:$D$13, 0)) * NOT($C45 = Monday!$D$15)  )","v":0},0,1,0,1,0,0,0,1,1,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C45, '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($AI45,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ44,AJ44)-1","v":22}]
[460724.04599999997,null,"P.Lavender",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R46, 0, INDEX($J46:$Q46, Monday!$B$1) * NOT($C46 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S46, 0, INDEX($J46:$Q46, Monday!$B$1) * ISNA(MATCH($C46, Monday!$D$6:$D$13, 0)) * NOT($C46 = Monday!$D$15)  )","v":0},1,1,1,1,0,1,1,0,0,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C46, '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($AI46,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ45,AJ45)-1","v":1}]
[734253.04700000002,null,"P.McArthur",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R47, 0, INDEX($J47:$Q47, Monday!$B$1) * NOT($C47 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S47, 0, INDEX($J47:$Q47, Monday!$B$1) * ISNA(MATCH($C47, Monday!$D$6:$D$13, 0)) * NOT($C47 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C47, '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($AI47,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ46,AJ46)-1","v":23}]
[382265.04800000001,null,"P.Regan",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R48, 0, INDEX($J48:$Q48, Monday!$B$1) * NOT($C48 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S48, 0, INDEX($J48:$Q48, Monday!$B$1) * ISNA(MATCH($C48, Monday!$D$6:$D$13, 0)) * NOT($C48 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C48, '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($AI48,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ47,AJ47)-1","v":1}]
[131403.049,null,"R.Diprose",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R49, 0, INDEX($J49:$Q49, Monday!$B$1) * NOT($C49 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S49, 0, INDEX($J49:$Q49, Monday!$B$1) * ISNA(MATCH($C49, Monday!$D$6:$D$13, 0)) * NOT($C49 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,0,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C49, 'Job History'!$C$3:$C$99, 0),)","v":2},1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AI49,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ48,AJ48)-1","v":24}]
[555660.05000000005,null,"R.Hallgally",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R50, 0, INDEX($J50:$Q50, Monday!$B$1) * NOT($C50 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S50, 0, INDEX($J50:$Q50, Monday!$B$1) * ISNA(MATCH($C50, Monday!$D$6:$D$13, 0)) * NOT($C50 = Monday!$D$15)  )","v":0},1,1,1,1,1,1,0,1,0,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C50, 'Job History'!$C$3:$C$99, 0),)","v":2},3,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"RANK($AI50,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ49,AJ49)-1","v":1}]
[363183.05099999998,null,"R.O’Meara",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R51, 0, INDEX($J51:$Q51, Monday!$B$1) * NOT($C51 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S51, 0, INDEX($J51:$Q51, Monday!$B$1) * ISNA(MATCH($C51, Monday!$D$6:$D$13, 0)) * NOT($C51 = Monday!$D$15)  )","v":0},0,1,0,1,0,1,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C51, '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($AI51,$AI$3:$AI$51)+COUNTIF(AJ$2:AJ50,AJ50)-1","v":25}]
[437254.05200000003,null,"R.Pembroke",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R52, 0, INDEX($J52:$Q52, Monday!$B$1) * NOT($C52 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S52, 0, INDEX($J52:$Q52, Monday!$B$1) * ISNA(MATCH($C52, Monday!$D$6:$D$13, 0)) * NOT($C52 = Monday!$D$15)  )","v":1},0,1,0,1,1,1,0,1,1,1,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C52, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0]
[75810.053,null,"R.Rozniak",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R53, 0, INDEX($J53:$Q53, Monday!$B$1) * NOT($C53 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S53, 0, INDEX($J53:$Q53, Monday!$B$1) * ISNA(MATCH($C53, Monday!$D$6:$D$13, 0)) * NOT($C53 = Monday!$D$15)  )","v":1},1,1,0,1,1,1,0,1,1,0,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C53, 'Job History'!$C$3:$C$99, 0),)","v":0},1,0]
[718628.054,null,"S.Abraham",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R54, 0, INDEX($J54:$Q54, Monday!$B$1) * NOT($C54 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S54, 0, INDEX($J54:$Q54, Monday!$B$1) * ISNA(MATCH($C54, Monday!$D$6:$D$13, 0)) * NOT($C54 = Monday!$D$15)  )","v":0},1,1,1,1,1,1,1,1,1,1,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C54, 'Job History'!$C$3:$C$99, 0),)","v":1},1,1]
[4357.0550000000003,null,"S.Brookman",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R55, 0, INDEX($J55:$Q55, Monday!$B$1) * NOT($C55 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S55, 0, INDEX($J55:$Q55, Monday!$B$1) * ISNA(MATCH($C55, Monday!$D$6:$D$13, 0)) * NOT($C55 = Monday!$D$15)  )","v":0},1,1,0,1,0,0,0,1,1,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C55, 'Job History'!$C$3:$C$99, 0),)","v":0},0,0]
[312144.05599999998,null,"S.Chow",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R56, 0, INDEX($J56:$Q56, Monday!$B$1) * NOT($C56 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S56, 0, INDEX($J56:$Q56, Monday!$B$1) * ISNA(MATCH($C56, Monday!$D$6:$D$13, 0)) * NOT($C56 = Monday!$D$15)  )","v":0},0,1,0,1,1,0,1,0,0,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C56, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0]
[262868.05699999997,null,"S.Harrison",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R57, 0, INDEX($J57:$Q57, Monday!$B$1) * NOT($C57 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S57, 0, INDEX($J57:$Q57, Monday!$B$1) * ISNA(MATCH($C57, Monday!$D$6:$D$13, 0)) * NOT($C57 = Monday!$D$15)  )","v":0},1,1,0,1,0,0,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C57, 'Job History'!$C$3:$C$99, 0),)","v":0},0,0]
[132986.05799999999,null,"S.Monk",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R58, 0, INDEX($J58:$Q58, Monday!$B$1) * NOT($C58 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S58, 0, INDEX($J58:$Q58, Monday!$B$1) * ISNA(MATCH($C58, Monday!$D$6:$D$13, 0)) * NOT($C58 = Monday!$D$15)  )","v":0},0,1,1,1,0,1,0,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C58, 'Job History'!$C$3:$C$99, 0),)","v":0},0,0]
[860936.05900000001,null,"S.Pearce",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R59, 0, INDEX($J59:$Q59, Monday!$B$1) * NOT($C59 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S59, 0, INDEX($J59:$Q59, Monday!$B$1) * ISNA(MATCH($C59, Monday!$D$6:$D$13, 0)) * NOT($C59 = Monday!$D$15)  )","v":0},1,1,1,1,1,1,1,1,1,0,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C59, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0]
[882686.06,null,"S.Stretton",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R60, 0, INDEX($J60:$Q60, Monday!$B$1) * NOT($C60 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S60, 0, INDEX($J60:$Q60, Monday!$B$1) * ISNA(MATCH($C60, Monday!$D$6:$D$13, 0)) * NOT($C60 = Monday!$D$15)  )","v":0},1,1,1,1,1,0,1,0,0,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C60, 'Job History'!$C$3:$C$99, 0),)","v":1},1,4]
[837466.06099999999,null,"S.Tariq",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R61, 0, INDEX($J61:$Q61, Monday!$B$1) * NOT($C61 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S61, 0, INDEX($J61:$Q61, Monday!$B$1) * ISNA(MATCH($C61, Monday!$D$6:$D$13, 0)) * NOT($C61 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C61, 'Job History'!$C$3:$C$99, 0),)","v":1},2,0]
[87314.062000000005,null,"T.Bryan",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R62, 0, INDEX($J62:$Q62, Monday!$B$1) * NOT($C62 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S62, 0, INDEX($J62:$Q62, Monday!$B$1) * ISNA(MATCH($C62, Monday!$D$6:$D$13, 0)) * NOT($C62 = Monday!$D$15)  )","v":0},1,1,1,1,1,1,1,1,1,1,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C62, 'Job History'!$C$3:$C$99, 0),)","v":1},1,1]
[185223.06299999999,null,"T.Doyle",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R63, 0, INDEX($J63:$Q63, Monday!$B$1) * NOT($C63 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S63, 0, INDEX($J63:$Q63, Monday!$B$1) * ISNA(MATCH($C63, Monday!$D$6:$D$13, 0)) * NOT($C63 = Monday!$D$15)  )","v":0},0,1,0,1,1,0,1,1,1,1,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C63, 'Job History'!$C$3:$C$99, 0),)","v":0},2,0]
[225543.06400000001,null,"T.Harman",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R64, 0, INDEX($J64:$Q64, Monday!$B$1) * NOT($C64 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S64, 0, INDEX($J64:$Q64, Monday!$B$1) * ISNA(MATCH($C64, Monday!$D$6:$D$13, 0)) * NOT($C64 = Monday!$D$15)  )","v":1},0,1,0,1,1,1,1,1,1,0,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C64, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0]
[632778.06499999994,null,"T.Watkins",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R65, 0, INDEX($J65:$Q65, Monday!$B$1) * NOT($C65 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S65, 0, INDEX($J65:$Q65, Monday!$B$1) * ISNA(MATCH($C65, Monday!$D$6:$D$13, 0)) * NOT($C65 = Monday!$D$15)  )","v":0},0,1,0,1,0,0,1,1,1,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C65, 'Job History'!$C$3:$C$99, 0),)","v":0},0,0]
[848135.06599999999,null,"T.Winter",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R66, 0, INDEX($J66:$Q66, Monday!$B$1) * NOT($C66 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S66, 0, INDEX($J66:$Q66, Monday!$B$1) * ISNA(MATCH($C66, Monday!$D$6:$D$13, 0)) * NOT($C66 = Monday!$D$15)  )","v":0},0,1,0,1,1,0,0,1,0,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C66, 'Job History'!$C$3:$C$99, 0),)","v":2},3,0]
[{"$f":" INT(1000000*RAND()) + ROW()/1000","v":541264.06700000004},null,"V.Ilott",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R67, 0, INDEX($J67:$Q67, Monday!$B$1) * NOT($C67 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S67, 0, INDEX($J67:$Q67, Monday!$B$1) * ISNA(MATCH($C67, Monday!$D$6:$D$13, 0)) * NOT($C67 = Monday!$D$15)  )","v":0},1,1,0,1,1,1,1,1,1,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C67, 'Job History'!$C$3:$C$99, 0),)","v":1},0,0]
[934573.06799999997,null,"A.Goodman",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R68, 0, INDEX($J68:$Q68, Monday!$B$1) * NOT($C68 = Monday!$D$15) )","v":1},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S68, 0, INDEX($J68:$Q68, Monday!$B$1) * ISNA(MATCH($C68, Monday!$D$6:$D$13, 0)) * NOT($C68 = Monday!$D$15)  )","v":0},1,1,0,1,0,1,1,1,1,1,1,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C68, 'Job History'!$C$3:$C$99, 0),)","v":0},0,0]
[670602.06900000002,null,"T.Underwood",{"$f":" IF( 1.2 * MAX(0.5, R$1) + 1 < R69, 0, INDEX($J69:$Q69, Monday!$B$1) * NOT($C69 = Monday!$D$15) )","v":0},{"$f":" IF( 1.2 * MAX(0.5, S$1) + 1 < S69, 0, INDEX($J69:$Q69, Monday!$B$1) * ISNA(MATCH($C69, Monday!$D$6:$D$13, 0)) * NOT($C69 = Monday!$D$15)  )","v":0},1,0,0,0,1,1,1,1,1,0,0,1,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C69, 'Job History'!$C$3:$C$99, 0),)","v":1},1,0]

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