{"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":25,"n_cols":17,"rows_kept":25,"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,null,"Monday"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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":"I.Edgar"},"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":"S.Pearce"},"2PM",null,null,null,null,null,null,null,"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":"M.Kochowski"},"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":"N.Lukasevicius"},"2PM",null,null,null,null,null,null,null,"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":"T.Doyle"},"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":"E.Mullally"},"2PM",null,null,null,null,null,null,null,"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":"M.Flanagan"},"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":"R.Rozniak"},"4PM",null,null,null,null,null,null,null,"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":"R.Pembroke"},"4PM",null,null,null,null,null,null,null,"Saturday 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sunday"]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[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":"M.Kumar"},"2PM"]
[null,null,null,null,null,null,null,"Bread Pickers"]
[null,null,null,"OPPS",null,null,1]
[null,null,1,null,"2PM",null,2]
[null,null,2,null,"2PM",null,3]
[null,null,null,"COVER",null,null,4]
[null,null,1,null,"2PM",null,5]
[null,null,null,"SPONSOR",null,null,6]
[null,null,1,null,"4PM",null,7]
[null,null,null,"HYGIENE",null,null,8]
[null,null,1,null,"2PM",null,9]

{"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,"B.Golubkov","2PM",null,1,"I.Edgar","2PM"]
[null,null,2,"E.Mullally","2PM",null,2,"R.Pembroke","2PM"]
[null,null,3,"R.Rozniak","2PM",null,3,"E.Selickis","2PM"]
[null,null,4,"D.Hickmott","2PM",null,4,"S.Pearce","4PM"]
[null,null,5,"T.Doyle","4PM",null,5,"N.Lukasevicius","4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[null,null,1,"M.Kumar","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:D99)","v":0.16176470588235295},{"$f":"AVERAGE(E3:E99)","v":0.16176470588235295},{"$f":"AVERAGE(F3:F99)","v":2.9411764705882353E-2},{"$f":"AVERAGE(G3:G99)","v":0},{"$f":"AVERAGE(H3:H99)","v":0.35294117647058826},null,null,"A.Nicholls",null,"B.Ratcliffe","S.Stretton"]
[null,1,"A.Bradbury",{"$f":"COUNTIF($K$2:$K$60000,C3)","v":0},{"$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":0},null,null,"H.Mohamed",null,"D.Magill","M.Flanagan"]
[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,"B.Ratcliffe",null,"S.Stretton"]
[null,3,"A.McFarlane",0,0,0,0,0,null,null,"V.Ilott",null,"J.Hough"]
[null,4,"A.Nicholls",1,0,0,0,1,null,null,"D.Magill",null,"K.Pape"]
[null,5,"B.Ratcliffe",1,1,0,0,2,null,null,"E.Lindo",null,"E.Lindo"]
[null,6,"A.Wall",0,0,0,0,0,null,null,"C.Boateng",null,"C.Boateng"]
[null,7,"A.Walton",0,0,0,0,0,null,null,"T.Harman",null,"T.Harman"]
[null,8,"B.Golubkov",0,0,0,0,0,null,null,"B.Sutton",null,"B.Sutton"]
[null,9,"B.Ratcliffe",1,1,0,0,2,null,null,"S.Pearce",null,"S.Pearce"]
[null,10,"B.Sutton",1,1,0,0,2]
[null,11,"C.Boateng",1,1,0,0,2]
[null,12,"C.Keegan",0,0,0,0,0]
[null,13,"D.Caffell",0,0,0,0,0]
[null,14,"D.Cooke",0,0,0,0,0]
[null,15,"D.Hickmott",0,0,0,0,0]
[null,16,"D.Magill",1,1,0,0,2]
[null,17,"D.Roczniak",0,0,0,0,0]
[null,18,"E.Lindo",1,1,0,0,2]
[null,19,"E.Mooney",0,0,0,0,0]
[null,20,"E.Mullally",0,0,0,0,0]
[null,21,"E.Selickis",0,0,0,0,0]
[null,22,"G.Franklin",{"$f":"COUNTIF($K$2:$K$60000,C24)","v":0},{"$f":"COUNTIF($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":0}]
[null,23,"G.Hawkins",{"$f":"COUNTIF($K$2:$K$60000,C25)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C25)","v":0},{"$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":0}]
[null,24,"H.Mohamed",1,0,0,0,1]
[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,1,0,0,1]
[null,29,"J.Pyke",0,0,0,0,0]
[null,30,"J.Reynolds",0,0,0,0,0]
[null,31,"K.Pape",0,1,0,0,1]
[null,32,"K.Verdi",0,0,0,0,0]
[null,33,"L.R.Browne",0,0,0,{"$f":"COUNTIF($L$2:$L$60000,C35)","v":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,1,0,1]
[null,37,"M.Kochowski",0,0,0,0,0]
[null,38,"M.Kumar",0,0,0,0,0]
[null,39,"M.Lawson",0,0,0,0,0]
[null,40,"M.Pushotam",0,0,0,0,0]
[null,41,"N.Lukasevicius",0,0,0,0,0]
[null,42,"P.Chapman",0,0,0,0,0]
[null,43,"P.Green",{"$f":"COUNTIF($K$2:$K$60000,C45)","v":0},{"$f":"COUNTIF($M$2:$M$60000,C45)","v":0},{"$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":0}]
[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",0,0,0,0,0]
[null,47,"P.Regan",0,0,0,0,0]
[null,48,"R.Diprose",0,0,0,0,0]
[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($M$2:$M$60000,C54)","v":0},{"$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":0}]
[null,53,"S.Abraham",0,0,0,0,0]
[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",1,1,0,0,2]
[null,59,"S.Stretton",0,1,1,0,2]
[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",1,1,0,0,2]
[null,64,"T.Watkins",0,0,0,0,0]
[null,65,"T.Winter",0,0,0,0,0]
[null,66,"V.Ilott",1,0,0,0,1]
[null,67,"T.Underwood",0,0,0,0,0]
[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":41},{"$f":"COUNTIF(K3:K99,1)","v":47},48,55,49,14,15,29,{"$f":" SUM(R$3:R$99) / SUM(F$3:F$99)","v":0.19230769230769232},{"$f":" SUM(S$3:S$99) / SUM(G$3:G$99)","v":0.15384615384615385},{"$f":" SUM(T$3:T$99) / SUM(H$3:H$99)","v":0.1111111111111111}]
["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":96927.002999999997},{"$f":"RANK($A3,$A$3:$A$69)+COUNTIF(B$2:B2,B2)-1","v":61},"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":0},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}]
[712469.00399999996,{"$f":"RANK($A4,$A$3:$A$69)+COUNTIF(B$2:B3,B3)-1","v":15},"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}]
[132123.005,{"$f":"RANK($A5,$A$3:$A$69)+COUNTIF(B$2:B4,B4)-1","v":56},"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":1},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}]
[95100.005999999994,{"$f":"RANK($A6,$A$3:$A$69)+COUNTIF(B$2:B5,B5)-1","v":62},"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},0,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}]
[137293.00700000001,{"$f":"RANK($A7,$A$3:$A$69)+COUNTIF(B$2:B6,B6)-1","v":55},"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":0},0,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}]
[148791.008,{"$f":"RANK($A8,$A$3:$A$69)+COUNTIF(B$2:B7,B7)-1","v":52},"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":0},0,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}]
[607821.00899999996,{"$f":"RANK($A9,$A$3:$A$69)+COUNTIF(B$2:B8,B8)-1","v":22},"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}]
[925121.01,{"$f":"RANK($A10,$A$3:$A$69)+COUNTIF(B$2:B9,B9)-1","v":4},"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":1},1,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}]
[202023.011,{"$f":"RANK($A11,$A$3:$A$69)+COUNTIF(B$2:B10,B10)-1","v":50},"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":1},1,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}]
[707685.01199999999,{"$f":"RANK($A12,$A$3:$A$69)+COUNTIF(B$2:B11,B11)-1","v":16},"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":1},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}]
[894434.01300000004,{"$f":"RANK($A13,$A$3:$A$69)+COUNTIF(B$2:B12,B12)-1","v":6},"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":0},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}]
[145507.014,{"$f":"RANK($A14,$A$3:$A$69)+COUNTIF(B$2:B13,B13)-1","v":53},"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}]
[141479.01500000001,{"$f":"RANK($A15,$A$3:$A$69)+COUNTIF(B$2:B14,B14)-1","v":54},"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}]
[60207.016000000003,{"$f":"RANK($A16,$A$3:$A$69)+COUNTIF(B$2:B15,B15)-1","v":63},"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":0},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}]
[331245.01699999999,{"$f":"RANK($A17,$A$3:$A$69)+COUNTIF(B$2:B16,B16)-1","v":40},"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},1,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}]
[591321.01800000004,{"$f":"RANK($A18,$A$3:$A$69)+COUNTIF(B$2:B17,B17)-1","v":24},"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}]
[707216.01899999997,{"$f":"RANK($A19,$A$3:$A$69)+COUNTIF(B$2:B18,B18)-1","v":17},"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},1,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}]
[215292.02,{"$f":"RANK($A20,$A$3:$A$69)+COUNTIF(B$2:B19,B19)-1","v":49},"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}]
[305074.02100000001,{"$f":"RANK($A21,$A$3:$A$69)+COUNTIF(B$2:B20,B20)-1","v":42},"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":1},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":0},0,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}]
[55539.021999999997,{"$f":"RANK($A22,$A$3:$A$69)+COUNTIF(B$2:B21,B21)-1","v":64},"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":1},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}]
[551367.02300000004,{"$f":"RANK($A23,$A$3:$A$69)+COUNTIF(B$2:B22,B22)-1","v":26},"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":0},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}]
[675468.02399999998,{"$f":"RANK($A24,$A$3:$A$69)+COUNTIF(B$2:B23,B23)-1","v":19},"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},0,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}]
[739711.02500000002,{"$f":"RANK($A25,$A$3:$A$69)+COUNTIF(B$2:B24,B24)-1","v":13},"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":1},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}]
[923051.02599999995,{"$f":"RANK($A26,$A$3:$A$69)+COUNTIF(B$2:B25,B25)-1","v":5},"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":0},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}]
[940520.027,{"$f":"RANK($A27,$A$3:$A$69)+COUNTIF(B$2:B26,B26)-1","v":1},"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":0},0,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}]
[727746.02800000005,{"$f":"RANK($A28,$A$3:$A$69)+COUNTIF(B$2:B27,B27)-1","v":14},"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":0},0,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}]
[344583.02899999998,{"$f":"RANK($A29,$A$3:$A$69)+COUNTIF(B$2:B28,B28)-1","v":38},"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},1,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}]
[232776.03,{"$f":"RANK($A30,$A$3:$A$69)+COUNTIF(B$2:B29,B29)-1","v":45},"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":0},0,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}]
[422612.03100000002,{"$f":"RANK($A31,$A$3:$A$69)+COUNTIF(B$2:B30,B30)-1","v":32},"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}]
[231152.03200000001,{"$f":"RANK($A32,$A$3:$A$69)+COUNTIF(B$2:B31,B31)-1","v":46},"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":0},1,0,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}]
[877117.03300000005,{"$f":"RANK($A33,$A$3:$A$69)+COUNTIF(B$2:B32,B32)-1","v":8},"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}]
[371903.03399999999,{"$f":"RANK($A34,$A$3:$A$69)+COUNTIF(B$2:B33,B33)-1","v":33},"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":0},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}]
[602985.03500000003,{"$f":"RANK($A35,$A$3:$A$69)+COUNTIF(B$2:B34,B34)-1","v":23},"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":0},0,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}]
[703003.03599999996,{"$f":"RANK($A36,$A$3:$A$69)+COUNTIF(B$2:B35,B35)-1","v":18},"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}]
[626310.03700000001,{"$f":"RANK($A37,$A$3:$A$69)+COUNTIF(B$2:B36,B36)-1","v":20},"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":1},{"$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":0},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":0},0,1,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}]
[882007.03799999994,{"$f":"RANK($A38,$A$3:$A$69)+COUNTIF(B$2:B37,B37)-1","v":7},"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":0},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}]
[933164.03899999999,{"$f":"RANK($A39,$A$3:$A$69)+COUNTIF(B$2:B38,B38)-1","v":3},"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":0},{"$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":0},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":0},0,0,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}]
[458782.04,{"$f":"RANK($A40,$A$3:$A$69)+COUNTIF(B$2:B39,B39)-1","v":31},"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":0},0,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}]
[751420.04099999997,{"$f":"RANK($A41,$A$3:$A$69)+COUNTIF(B$2:B40,B40)-1","v":12},"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}]
[313598.04200000002,{"$f":"RANK($A42,$A$3:$A$69)+COUNTIF(B$2:B41,B41)-1","v":41},"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}]
[221067.04300000001,{"$f":"RANK($A43,$A$3:$A$69)+COUNTIF(B$2:B42,B42)-1","v":48},"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":0},0,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}]
[824856.04399999999,{"$f":"RANK($A44,$A$3:$A$69)+COUNTIF(B$2:B43,B43)-1","v":10},"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":0},0,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}]
[618741.04500000004,{"$f":"RANK($A45,$A$3:$A$69)+COUNTIF(B$2:B44,B44)-1","v":21},"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}]
[247863.046,{"$f":"RANK($A46,$A$3:$A$69)+COUNTIF(B$2:B45,B45)-1","v":44},"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}]
[27303.046999999999,{"$f":"RANK($A47,$A$3:$A$69)+COUNTIF(B$2:B46,B46)-1","v":67},"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":0},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}]
[350313.04800000001,{"$f":"RANK($A48,$A$3:$A$69)+COUNTIF(B$2:B47,B47)-1","v":35},"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":0},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}]
[584503.049,{"$f":"RANK($A49,$A$3:$A$69)+COUNTIF(B$2:B48,B48)-1","v":25},"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":0},0,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}]
[121208.05,{"$f":"RANK($A50,$A$3:$A$69)+COUNTIF(B$2:B49,B49)-1","v":58},"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":0},0,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}]
[488770.05099999998,{"$f":"RANK($A51,$A$3:$A$69)+COUNTIF(B$2:B50,B50)-1","v":29},"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}]
[152225.052,{"$f":"RANK($A52,$A$3:$A$69)+COUNTIF(B$2:B51,B51)-1","v":51},"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":0},0,0]
[225214.05300000001,{"$f":"RANK($A53,$A$3:$A$69)+COUNTIF(B$2:B52,B52)-1","v":47},"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},0,0]
[344728.054,{"$f":"RANK($A54,$A$3:$A$69)+COUNTIF(B$2:B53,B53)-1","v":37},"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":0},0,0]
[127180.05499999999,{"$f":"RANK($A55,$A$3:$A$69)+COUNTIF(B$2:B54,B54)-1","v":57},"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]
[359475.05599999998,{"$f":"RANK($A56,$A$3:$A$69)+COUNTIF(B$2:B55,B55)-1","v":34},"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":0},0,0]
[28086.057000000001,{"$f":"RANK($A57,$A$3:$A$69)+COUNTIF(B$2:B56,B56)-1","v":66},"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]
[331788.05800000002,{"$f":"RANK($A58,$A$3:$A$69)+COUNTIF(B$2:B57,B57)-1","v":39},"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]
[466034.05900000001,{"$f":"RANK($A59,$A$3:$A$69)+COUNTIF(B$2:B58,B58)-1","v":30},"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":1},{"$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":1},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]
[97001.06,{"$f":"RANK($A60,$A$3:$A$69)+COUNTIF(B$2:B59,B59)-1","v":60},"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":0},1,1]
[506144.06099999999,{"$f":"RANK($A61,$A$3:$A$69)+COUNTIF(B$2:B60,B60)-1","v":28},"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,0,0,0,0,0,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C61, 'Job History'!$C$3:$C$99, 0),)","v":0},0,0]
[291449.06199999998,{"$f":"RANK($A62,$A$3:$A$69)+COUNTIF(B$2:B61,B61)-1","v":43},"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":0},0,0]
[815693.06299999997,{"$f":"RANK($A63,$A$3:$A$69)+COUNTIF(B$2:B62,B62)-1","v":11},"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},0,0]
[29105.063999999998,{"$f":"RANK($A64,$A$3:$A$69)+COUNTIF(B$2:B63,B63)-1","v":65},"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},1,0]
[832698.06499999994,{"$f":"RANK($A65,$A$3:$A$69)+COUNTIF(B$2:B64,B64)-1","v":9},"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]
[526116.06599999999,{"$f":"RANK($A66,$A$3:$A$69)+COUNTIF(B$2:B65,B65)-1","v":27},"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":0},0,0]
[{"$f":" INT(1000000*RAND()) + ROW()/1000","v":350110.06699999998},{"$f":"RANK($A67,$A$3:$A$69)+COUNTIF(B$2:B66,B66)-1","v":36},"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]
[100483.068,{"$f":"RANK($A68,$A$3:$A$69)+COUNTIF(B$2:B67,B67)-1","v":59},"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":0},{"$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,0,0,0,0,0,0,0,{"$f":" INDEX('Job History'!$D$3:$F$99, MATCH($C68, 'Job History'!$C$3:$C$99, 0),)","v":0},0,0]
[937839.06900000002,{"$f":"RANK($A69,$A$3:$A$69)+COUNTIF(B$2:B68,B68)-1","v":2},"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":0},0,0]

{"sheet":"ALL NAMES","index":4,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":true,"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},49,50,57,51,15,16,29]