{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Jobs","Names","Job History"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Jobs","index":0,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"GOODS IN TEAM ",null,null,null,"FLOOR TEAM",null,null,null,null,null,null,null,"All Pickers"]
[null,null,null,null,"Man",null,null,null,"Man",null,null,null,null,null,1,{"$f":"VLOOKUP(Names!$P$1,Names!$B$2:$C$22,2,FALSE)","v":"STUART"}]
[null,null,1,{"$f":"VLOOKUP(Names!$F$1,Names!$B$2:$C$22,2,FALSE)","v":"CARL"},"2PM",null,1,{"$f":"VLOOKUP(Names!$K$1,Names!$B$2:$C$22,2,FALSE)","v":"JOSE"},"2PM",null,null,null,null,null,2,{"$f":"VLOOKUP(Names!$Q$1,Names!$B$2:$C$22,2,FALSE)","v":"JOHN"}]
[null,null,2,{"$f":"VLOOKUP(Names!$G$1,Names!$B$2:$C$22,2,FALSE)","v":"DAVID"},"2PM",null,2,{"$f":"VLOOKUP(Names!$L$1,Names!$B$2:$C$22,2,FALSE)","v":"GARY"},"2PM",null,null,null,null,null,3,{"$f":"VLOOKUP(Names!$R$1,Names!$B$2:$C$22,2,FALSE)","v":"ABU"}]
[null,null,3,{"$f":"VLOOKUP(Names!$H$1,Names!$B$2:$C$22,2,FALSE)","v":"MAX"},"2PM",null,3,{"$f":"VLOOKUP(Names!$M$1,Names!$B$2:$C$22,2,FALSE)","v":"ALEX"},"2PM",null,null,null,null,null,4,{"$f":"VLOOKUP(Names!$S$1,Names!$B$2:$C$22,2,FALSE)","v":"SUNNY"}]
[null,null,4,{"$f":"VLOOKUP(Names!$I$1,Names!$B$2:$C$22,2,FALSE)","v":"ANDY"},"2PM",null,4,{"$f":"VLOOKUP(Names!$N$1,Names!$B$2:$C$22,2,FALSE)","v":"SHAUN "},"4PM",null,null,null,null,null,5,{"$f":"VLOOKUP(Names!$T$1,Names!$B$2:$C$22,2,FALSE)","v":"EDWARD"}]
[null,null,5,{"$f":"VLOOKUP(Names!$J$1,Names!$B$2:$C$22,2,FALSE)","v":"IAN"},"4PM",null,5,{"$f":"VLOOKUP(Names!$O$1,Names!$B$2:$C$22,2,FALSE)","v":"STEVEN"},"4PM",null,null,null,null,null,6,{"$f":"VLOOKUP(Names!$U$1,Names!$B$2:$C$22,2,FALSE)","v":"MIKE"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"VLOOKUP(Names!$V$1,Names!$B$2:$C$22,2,FALSE)","v":"ROBERT"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"VLOOKUP(Names!$X$1,Names!$B$2:$C$22,2,FALSE)","v":"ERIK"}]
[null,null,null,null,"2 to 4",null,null,null,null,null,null,null,null,null,9,{"$f":"VLOOKUP(Names!$Y$1,Names!$B$2:$C$22,2,FALSE)","v":"EDWIN"}]
[null,null,null,"FORKS",null,null,null,null,null,null,null,null,null,null,10,{"$f":"VLOOKUP(Names!$Z$1,Names!$B$2:$C$22,2,FALSE)","v":"ROY"}]
[null,null,1,{"$f":"VLOOKUP(Names!$W$1,Names!$B$2:$C$22,2,FALSE)","v":"MARTIN"},"2PM",null,null,null,null,null,null,null,null,null,11]
[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":"Names","index":1,"n_rows":22,"n_cols":26,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Rand","Rank","Name",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[{"$f":"RAND()","v":0.49308976339218025},{"$f":"RANK($A2,$A$2:$A$22)+COUNTIF(B$1:B1,B1)-1","v":12},"JOHN"]
[{"$f":"RAND()","v":0.22749539831694943},{"$f":"RANK($A3,$A$2:$A$22)+COUNTIF(B$1:B2,B2)-1","v":16},"MIKE"]
[0.74801998918941726,{"$f":"RANK($A4,$A$2:$A$22)+COUNTIF(B$1:B3,B3)-1","v":9},"SHAUN "]
[0.76021792141568234,{"$f":"RANK($A5,$A$2:$A$22)+COUNTIF(B$1:B4,B4)-1","v":5},"IAN"]
[0.60781033946694496,{"$f":"RANK($A6,$A$2:$A$22)+COUNTIF(B$1:B5,B5)-1","v":11},"STUART"]
[0.36120052221005938,{"$f":"RANK($A7,$A$2:$A$22)+COUNTIF(B$1:B6,B6)-1","v":15},"EDWARD"]
[0.92277007531284738,{"$f":"RANK($A8,$A$2:$A$22)+COUNTIF(B$1:B7,B7)-1","v":2},"DAVID"]
[0.20877653289591458,{"$f":"RANK($A9,$A$2:$A$22)+COUNTIF(B$1:B8,B8)-1","v":17},"ROBERT"]
[0.48753623734649931,{"$f":"RANK($A10,$A$2:$A$22)+COUNTIF(B$1:B9,B9)-1","v":13},"ABU"]
[0.73268141506591045,{"$f":"RANK($A11,$A$2:$A$22)+COUNTIF(B$1:B10,B10)-1","v":10},"STEVEN"]
[0.74906621957292607,{"$f":"RANK($A12,$A$2:$A$22)+COUNTIF(B$1:B11,B11)-1","v":8},"ALEX"]
[0.96699978681554155,{"$f":"RANK($A13,$A$2:$A$22)+COUNTIF(B$1:B12,B12)-1","v":1},"CARL"]
[0.10499805732595502,{"$f":"RANK($A14,$A$2:$A$22)+COUNTIF(B$1:B13,B13)-1","v":19},"ERIK"]
[5.4525818790506442E-2,{"$f":"RANK($A15,$A$2:$A$22)+COUNTIF(B$1:B14,B14)-1","v":20},"EDWIN"]
[0.37211093555406505,{"$f":"RANK($A16,$A$2:$A$22)+COUNTIF(B$1:B15,B15)-1","v":14},"SUNNY"]
[0.86009629490238737,{"$f":"RANK($A17,$A$2:$A$22)+COUNTIF(B$1:B16,B16)-1","v":4},"ANDY"]
[2.0340518844200961E-2,{"$f":"RANK($A18,$A$2:$A$22)+COUNTIF(B$1:B17,B17)-1","v":21},"ROY"]
[0.75130475453484213,{"$f":"RANK($A19,$A$2:$A$22)+COUNTIF(B$1:B18,B18)-1","v":7},"GARY"]
[0.15417468189660055,{"$f":"RANK($A20,$A$2:$A$22)+COUNTIF(B$1:B19,B19)-1","v":18},"MARTIN"]
[0.75389651632937449,{"$f":"RANK($A21,$A$2:$A$22)+COUNTIF(B$1:B20,B20)-1","v":6},"JOSE"]
[0.90306118650516787,{"$f":"RANK($A22,$A$2:$A$22)+COUNTIF(B$1:B21,B21)-1","v":3},"MAX"]

{"sheet":"Job History","index":2,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Name","Non Pr. (Days)","Pick. (Days)"]
[null,1,{"$f":"IF(Names!C2=\"\",\"\",Names!C2)","v":"JOHN"},null,{"$f":"IF(Names!C2=\"\",\"\",COUNTIF(Jobs!$P:$P,'Job History'!$C3)+SUMIF(Jobs!$P:$P,Names!$C2,'Job History'!$E3))","v":1}]
[null,2,{"$f":"IF(Names!C3=\"\",\"\",Names!C3)","v":"MIKE"}]
[null,3,{"$f":"IF(Names!C4=\"\",\"\",Names!C4)","v":"SHAUN "}]
[null,4,{"$f":"IF(Names!C5=\"\",\"\",Names!C5)","v":"IAN"}]
[null,5,{"$f":"IF(Names!C6=\"\",\"\",Names!C6)","v":"STUART"}]
[null,6,{"$f":"IF(Names!C7=\"\",\"\",Names!C7)","v":"EDWARD"}]
[null,7,{"$f":"IF(Names!C8=\"\",\"\",Names!C8)","v":"DAVID"}]
[null,8,{"$f":"IF(Names!C9=\"\",\"\",Names!C9)","v":"ROBERT"}]
[null,9,{"$f":"IF(Names!C10=\"\",\"\",Names!C10)","v":"ABU"}]
[null,10,{"$f":"IF(Names!C11=\"\",\"\",Names!C11)","v":"STEVEN"}]
[null,11,{"$f":"IF(Names!C12=\"\",\"\",Names!C12)","v":"ALEX"}]
[null,12,{"$f":"IF(Names!C13=\"\",\"\",Names!C13)","v":"CARL"}]
[null,13,{"$f":"IF(Names!C14=\"\",\"\",Names!C14)","v":"ERIK"}]
[null,14,{"$f":"IF(Names!C15=\"\",\"\",Names!C15)","v":"EDWIN"}]
[null,15,{"$f":"IF(Names!C16=\"\",\"\",Names!C16)","v":"SUNNY"}]
[null,16,{"$f":"IF(Names!C17=\"\",\"\",Names!C17)","v":"ANDY"}]
[null,17,{"$f":"IF(Names!C18=\"\",\"\",Names!C18)","v":"ROY"}]
[null,18,{"$f":"IF(Names!C19=\"\",\"\",Names!C19)","v":"GARY"}]
[null,19,{"$f":"IF(Names!C20=\"\",\"\",Names!C20)","v":"MARTIN"}]
[null,20,{"$f":"IF(Names!C21=\"\",\"\",Names!C21)","v":"JOSE"}]
[null,21,{"$f":"IF(Names!C22=\"\",\"\",Names!C22)","v":"MAX"}]
[null,22,{"$f":"IF(Names!C22=\"\",\"\",Names!C22)","v":"MAX"}]