{"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":"ROBERT"}]
[null,null,1,{"$f":"VLOOKUP(Names!$F$1,Names!$B$2:$C$22,2,FALSE)","v":"JOHN"},"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":"CARL"}]
[null,null,2,{"$f":"VLOOKUP(Names!$G$1,Names!$B$2:$C$22,2,FALSE)","v":"SHAUN "},"2PM",null,2,{"$f":"VLOOKUP(Names!$L$1,Names!$B$2:$C$22,2,FALSE)","v":"MAX"},"2PM",null,null,null,null,null,3,{"$f":"VLOOKUP(Names!$R$1,Names!$B$2:$C$22,2,FALSE)","v":"DAVID"}]
[null,null,3,{"$f":"VLOOKUP(Names!$H$1,Names!$B$2:$C$22,2,FALSE)","v":"MIKE"},"2PM",null,3,{"$f":"VLOOKUP(Names!$M$1,Names!$B$2:$C$22,2,FALSE)","v":"ANDY"},"2PM",null,null,null,null,null,4,{"$f":"VLOOKUP(Names!$S$1,Names!$B$2:$C$22,2,FALSE)","v":"ERIK"}]
[null,null,4,{"$f":"VLOOKUP(Names!$I$1,Names!$B$2:$C$22,2,FALSE)","v":"STUART"},"2PM",null,4,{"$f":"VLOOKUP(Names!$N$1,Names!$B$2:$C$22,2,FALSE)","v":"MARTIN"},"4PM",null,null,null,null,null,5,{"$f":"VLOOKUP(Names!$T$1,Names!$B$2:$C$22,2,FALSE)","v":"SUNNY"}]
[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":"EDWIN"},"4PM",null,null,null,null,null,6,{"$f":"VLOOKUP(Names!$U$1,Names!$B$2:$C$22,2,FALSE)","v":"ROY"}]
[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":"STEVEN"}]
[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":"GARY"}]
[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":"ABU"}]
[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":"ALEX"}]
[null,null,1,{"$f":"VLOOKUP(Names!$W$1,Names!$B$2:$C$22,2,FALSE)","v":"EDWARD"},"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":5.0105521754759259},{"$f":"RANK($A2,$A$2:$A$22)+COUNTIF(B$1:B1,B1)-1","v":1},"JOHN",null,6]
[{"$f":"RAND()*E3","v":2.1443629192209244},{"$f":"RANK($A3,$A$2:$A$22)+COUNTIF(B$1:B2,B2)-1","v":3},"MIKE",null,5]
[2.806433350148442,{"$f":"RANK($A4,$A$2:$A$22)+COUNTIF(B$1:B3,B3)-1","v":2},"SHAUN ",null,4]
[1.2456110018954654,{"$f":"RANK($A5,$A$2:$A$22)+COUNTIF(B$1:B4,B4)-1","v":5},"IAN",null,3]
[1.4826187510810773,{"$f":"RANK($A6,$A$2:$A$22)+COUNTIF(B$1:B5,B5)-1","v":4},"STUART",null,2]
[0.14298211503420699,{"$f":"RANK($A7,$A$2:$A$22)+COUNTIF(B$1:B6,B6)-1","v":18},"EDWARD",null,1]
[0.42943120007917424,{"$f":"RANK($A8,$A$2:$A$22)+COUNTIF(B$1:B7,B7)-1","v":13},"DAVID",null,1]
[0.48914195079517064,{"$f":"RANK($A9,$A$2:$A$22)+COUNTIF(B$1:B8,B8)-1","v":11},"ROBERT",null,1]
[0.10440368924009036,{"$f":"RANK($A10,$A$2:$A$22)+COUNTIF(B$1:B9,B9)-1","v":20},"ABU",null,1]
[0.15508704573799381,{"$f":"RANK($A11,$A$2:$A$22)+COUNTIF(B$1:B10,B10)-1","v":17},"STEVEN",null,1]
[3.610238706316693E-2,{"$f":"RANK($A12,$A$2:$A$22)+COUNTIF(B$1:B11,B11)-1","v":21},"ALEX",null,1]
[0.44364546812294514,{"$f":"RANK($A13,$A$2:$A$22)+COUNTIF(B$1:B12,B12)-1","v":12},"CARL",null,1]
[0.42100159869756038,{"$f":"RANK($A14,$A$2:$A$22)+COUNTIF(B$1:B13,B13)-1","v":14},"ERIK",null,1]
[0.52858173678828502,{"$f":"RANK($A15,$A$2:$A$22)+COUNTIF(B$1:B14,B14)-1","v":10},"EDWIN",null,1]
[0.32723093278677062,{"$f":"RANK($A16,$A$2:$A$22)+COUNTIF(B$1:B15,B15)-1","v":15},"SUNNY",null,1]
[0.9176024586960434,{"$f":"RANK($A17,$A$2:$A$22)+COUNTIF(B$1:B16,B16)-1","v":8},"ANDY",null,1]
[0.26369868481636605,{"$f":"RANK($A18,$A$2:$A$22)+COUNTIF(B$1:B17,B17)-1","v":16},"ROY",null,1]
[0.12113689733600186,{"$f":"RANK($A19,$A$2:$A$22)+COUNTIF(B$1:B18,B18)-1","v":19},"GARY",null,1]
[0.79364206709068252,{"$f":"RANK($A20,$A$2:$A$22)+COUNTIF(B$1:B19,B19)-1","v":9},"MARTIN",null,1]
[0.94683365734925951,{"$f":"RANK($A21,$A$2:$A$22)+COUNTIF(B$1:B20,B20)-1","v":6},"JOSE",null,1]
[0.92255063370375212,{"$f":"RANK($A22,$A$2:$A$22)+COUNTIF(B$1:B21,B21)-1","v":7},"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]