{"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":"ANDY"}]
[null,null,1,{"$f":"VLOOKUP(Names!$F$1,Names!$B$2:$C$22,2,FALSE)","v":"EDWIN"},"2PM",null,1,{"$f":"VLOOKUP(Names!$K$1,Names!$B$2:$C$22,2,FALSE)","v":"ERIK"},"2PM",null,null,null,null,null,2,{"$f":"VLOOKUP(Names!$Q$1,Names!$B$2:$C$22,2,FALSE)","v":"ROBERT"}]
[null,null,2,{"$f":"VLOOKUP(Names!$G$1,Names!$B$2:$C$22,2,FALSE)","v":"JOHN"},"2PM",null,2,{"$f":"VLOOKUP(Names!$L$1,Names!$B$2:$C$22,2,FALSE)","v":"CARL"},"2PM",null,null,null,null,null,3,{"$f":"VLOOKUP(Names!$R$1,Names!$B$2:$C$22,2,FALSE)","v":"MARTIN"}]
[null,null,3,{"$f":"VLOOKUP(Names!$H$1,Names!$B$2:$C$22,2,FALSE)","v":"ABU"},"2PM",null,3,{"$f":"VLOOKUP(Names!$M$1,Names!$B$2:$C$22,2,FALSE)","v":"ROY"},"2PM",null,null,null,null,null,4,{"$f":"VLOOKUP(Names!$S$1,Names!$B$2:$C$22,2,FALSE)","v":"SHAUN "}]
[null,null,4,{"$f":"VLOOKUP(Names!$I$1,Names!$B$2:$C$22,2,FALSE)","v":"SUNNY"},"2PM",null,4,{"$f":"VLOOKUP(Names!$N$1,Names!$B$2:$C$22,2,FALSE)","v":"GARY"},"4PM",null,null,null,null,null,5,{"$f":"VLOOKUP(Names!$T$1,Names!$B$2:$C$22,2,FALSE)","v":"ALEX"}]
[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":"MAX"},"4PM",null,null,null,null,null,6,{"$f":"VLOOKUP(Names!$U$1,Names!$B$2:$C$22,2,FALSE)","v":"STUART"}]
[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":"DAVID"}]
[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":"MIKE"}]
[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":"EDWARD"}]
[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":"STEVEN"}]
[null,null,1,{"$f":"VLOOKUP(Names!$W$1,Names!$B$2:$C$22,2,FALSE)","v":"JOSE"},"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,"Секретная цифра",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[{"$f":"RAND()*E2","v":0.97336845448350306},{"$f":"RANK($A2,$A$2:$A$22)+COUNTIF(B$1:B1,B1)-1","v":2},"JOHN",null,1.5]
[{"$f":"RAND()*E3","v":0.16764470803891474},{"$f":"RANK($A3,$A$2:$A$22)+COUNTIF(B$1:B2,B2)-1","v":19},"MIKE",null,1]
[0.39197486922307367,{"$f":"RANK($A4,$A$2:$A$22)+COUNTIF(B$1:B3,B3)-1","v":14},"SHAUN ",null,1.5]
[0.90376968597017715,{"$f":"RANK($A5,$A$2:$A$22)+COUNTIF(B$1:B4,B4)-1","v":5},"IAN",null,1]
[0.20162244203282587,{"$f":"RANK($A6,$A$2:$A$22)+COUNTIF(B$1:B5,B5)-1","v":16},"STUART",null,1]
[6.8433489218644894E-2,{"$f":"RANK($A7,$A$2:$A$22)+COUNTIF(B$1:B6,B6)-1","v":20},"EDWARD",null,1]
[0.19373150222153779,{"$f":"RANK($A8,$A$2:$A$22)+COUNTIF(B$1:B7,B7)-1","v":17},"DAVID",null,1]
[0.49715752345686881,{"$f":"RANK($A9,$A$2:$A$22)+COUNTIF(B$1:B8,B8)-1","v":12},"ROBERT",null,1]
[0.95588435061330546,{"$f":"RANK($A10,$A$2:$A$22)+COUNTIF(B$1:B9,B9)-1","v":3},"ABU",null,1]
[2.7316076268181E-2,{"$f":"RANK($A11,$A$2:$A$22)+COUNTIF(B$1:B10,B10)-1","v":21},"STEVEN",null,1]
[0.37750938812774315,{"$f":"RANK($A12,$A$2:$A$22)+COUNTIF(B$1:B11,B11)-1","v":15},"ALEX",null,1]
[0.86333747778215741,{"$f":"RANK($A13,$A$2:$A$22)+COUNTIF(B$1:B12,B12)-1","v":7},"CARL",null,1]
[0.86979534169325134,{"$f":"RANK($A14,$A$2:$A$22)+COUNTIF(B$1:B13,B13)-1","v":6},"ERIK",null,1]
[0.9869753426701271,{"$f":"RANK($A15,$A$2:$A$22)+COUNTIF(B$1:B14,B14)-1","v":1},"EDWIN",null,1]
[0.95151824215295555,{"$f":"RANK($A16,$A$2:$A$22)+COUNTIF(B$1:B15,B15)-1","v":4},"SUNNY",null,1]
[0.49923792594340943,{"$f":"RANK($A17,$A$2:$A$22)+COUNTIF(B$1:B16,B16)-1","v":11},"ANDY",null,1.5]
[0.72457053522808135,{"$f":"RANK($A18,$A$2:$A$22)+COUNTIF(B$1:B17,B17)-1","v":8},"ROY",null,1]
[0.72402436181342567,{"$f":"RANK($A19,$A$2:$A$22)+COUNTIF(B$1:B18,B18)-1","v":9},"GARY",null,1]
[0.49141581713556848,{"$f":"RANK($A20,$A$2:$A$22)+COUNTIF(B$1:B19,B19)-1","v":13},"MARTIN",null,1]
[0.18573410826207581,{"$f":"RANK($A21,$A$2:$A$22)+COUNTIF(B$1:B20,B20)-1","v":18},"JOSE",null,1]
[0.58154876603938299,{"$f":"RANK($A22,$A$2:$A$22)+COUNTIF(B$1:B21,B21)-1","v":10},"MAX",null,1]

{"sheet":"Job History","index":2,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Goods in","Picking","Floor team","Forks"]
[null,null,"Name","Goods in(Days)","Pick. (Days)","Fl.Team(Days)","Forks(Days)"]
[null,1,{"$f":"IF(Names!C2=\"\",\"\",Names!C2)","v":"JOHN"},{"$f":"COUNTIF($K$2:$K$200,C3)","v":0},{"$f":"COUNTIF($L$2:$L$200,C3)","v":0},{"$f":"COUNTIF($M$2:$M$200,C3)","v":0},{"$f":"COUNTIF($N$2:$N$200,C3)","v":0}]
[null,2,{"$f":"IF(Names!C3=\"\",\"\",Names!C3)","v":"MIKE"},{"$f":"COUNTIF($K$2:$K$200,C4)","v":0},{"$f":"COUNTIF($L$2:$L$200,C4)","v":0},{"$f":"COUNTIF($M$2:$M$200,C4)","v":0},{"$f":"COUNTIF($N$2:$N$200,C4)","v":0}]
[null,3,{"$f":"IF(Names!C4=\"\",\"\",Names!C4)","v":"SHAUN "},0,0,0,0]
[null,4,{"$f":"IF(Names!C5=\"\",\"\",Names!C5)","v":"IAN"},0,0,0,0]
[null,5,{"$f":"IF(Names!C6=\"\",\"\",Names!C6)","v":"STUART"},0,0,0,0]
[null,6,{"$f":"IF(Names!C7=\"\",\"\",Names!C7)","v":"EDWARD"},0,0,0,0]
[null,7,{"$f":"IF(Names!C8=\"\",\"\",Names!C8)","v":"DAVID"},0,0,0,0]
[null,8,{"$f":"IF(Names!C9=\"\",\"\",Names!C9)","v":"ROBERT"},0,0,0,0]
[null,9,{"$f":"IF(Names!C10=\"\",\"\",Names!C10)","v":"ABU"},0,0,0,0]
[null,10,{"$f":"IF(Names!C11=\"\",\"\",Names!C11)","v":"STEVEN"},0,0,0,0]
[null,11,{"$f":"IF(Names!C12=\"\",\"\",Names!C12)","v":"ALEX"},0,0,0,0]
[null,12,{"$f":"IF(Names!C13=\"\",\"\",Names!C13)","v":"CARL"},0,0,0,0]
[null,13,{"$f":"IF(Names!C14=\"\",\"\",Names!C14)","v":"ERIK"},0,0,0,0]
[null,14,{"$f":"IF(Names!C15=\"\",\"\",Names!C15)","v":"EDWIN"},0,0,0,0]
[null,15,{"$f":"IF(Names!C16=\"\",\"\",Names!C16)","v":"SUNNY"},0,0,0,0]
[null,16,{"$f":"IF(Names!C17=\"\",\"\",Names!C17)","v":"ANDY"},0,0,0,0]
[null,17,{"$f":"IF(Names!C18=\"\",\"\",Names!C18)","v":"ROY"},0,0,0,0]
[null,18,{"$f":"IF(Names!C19=\"\",\"\",Names!C19)","v":"GARY"},0,0,0,0]
[null,19,{"$f":"IF(Names!C20=\"\",\"\",Names!C20)","v":"MARTIN"},0,0,0,0]
[null,20,{"$f":"IF(Names!C21=\"\",\"\",Names!C21)","v":"JOSE"},0,0,0,0]
[null,21,{"$f":"IF(Names!C22=\"\",\"\",Names!C22)","v":"MAX"},0,0,0,0]