{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Names","Job History","Copy Names"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Monday","index":0,"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,{"$f":"VLOOKUP(Names!$F$1,Names!$B$2:$C$22,2,FALSE)","v":"ABU"},"2PM",null,1,{"$f":"VLOOKUP(Names!$K$1,Names!$B$2:$C$22,2,FALSE)","v":"SUNNY"},"2PM"]
[null,null,2,{"$f":"VLOOKUP(Names!$G$1,Names!$B$2:$C$22,2,FALSE)","v":"ROBERT"},"2PM",null,2,{"$f":"VLOOKUP(Names!$L$1,Names!$B$2:$C$22,2,FALSE)","v":"ROY"},"2PM"]
[null,null,3,{"$f":"VLOOKUP(Names!$H$1,Names!$B$2:$C$22,2,FALSE)","v":"CARL"},"2PM",null,3,{"$f":"VLOOKUP(Names!$M$1,Names!$B$2:$C$22,2,FALSE)","v":"JOHN"},"2PM"]
[null,null,4,{"$f":"VLOOKUP(Names!$I$1,Names!$B$2:$C$22,2,FALSE)","v":"MIKE"},"2PM",null,4,{"$f":"VLOOKUP(Names!$N$1,Names!$B$2:$C$22,2,FALSE)","v":"EDWARD"},"4PM"]
[null,null,5,{"$f":"VLOOKUP(Names!$J$1,Names!$B$2:$C$22,2,FALSE)","v":"DAVID"},"4PM",null,5,{"$f":"VLOOKUP(Names!$O$1,Names!$B$2:$C$22,2,FALSE)","v":"STEVEN"},"4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[null,null,1,{"$f":"VLOOKUP(Names!$P$1,Names!$B$2:$C$8,2,FALSE)","v":{"$error":"#N/A"}},"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":"Tuesday","index":1,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,"GOODS IN TEAM ",null,null,null,"FLOOR TEAM"]
[]
[null,null,1,null,"2PM",null,1,null,"2PM"]
[null,null,2,null,"2PM",null,2,null,"2PM"]
[null,null,3,null,"2PM",null,3,null,"2PM"]
[null,null,4,null,"2PM",null,4,null,"4PM"]
[null,null,5,null,"4PM",null,5,null,"4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[null,null,1,null,"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":"Wednesday","index":2,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,"GOODS IN TEAM ",null,null,null,"FLOOR TEAM"]
[]
[null,null,1,null,"2PM",null,1,null,"2PM"]
[null,null,2,null,"2PM",null,2,null,"2PM"]
[null,null,3,null,"2PM",null,3,null,"2PM"]
[null,null,4,null,"2PM",null,4,null,"4PM"]
[null,null,5,null,"4PM",null,5,null,"4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[null,null,1,null,"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]

{"sheet":"Thursday","index":3,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,"GOODS IN TEAM ",null,null,null,"FLOOR TEAM"]
[]
[null,null,1,null,"2PM",null,1,null,"2PM"]
[null,null,2,null,"2PM",null,2,null,"2PM"]
[null,null,3,null,"2PM",null,3,null,"2PM"]
[null,null,4,null,"2PM",null,4,null,"4PM"]
[null,null,5,null,"4PM",null,5,null,"4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[null,null,1,null,"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]

{"sheet":"Friday","index":4,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,"GOODS IN TEAM ",null,null,null,"FLOOR TEAM"]
[]
[null,null,1,null,"2PM",null,1,null,"2PM"]
[null,null,2,null,"2PM",null,2,null,"2PM"]
[null,null,3,null,"2PM",null,3,null,"2PM"]
[null,null,4,null,"2PM",null,4,null,"4PM"]
[null,null,5,null,"4PM",null,5,null,"4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[null,null,1,null,"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]

{"sheet":"Saturday","index":5,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,"GOODS IN TEAM ",null,null,null,"FLOOR TEAM"]
[]
[null,null,1,null,"2PM",null,1,null,"2PM"]
[null,null,2,null,"2PM",null,2,null,"2PM"]
[null,null,3,null,"2PM",null,3,null,"2PM"]
[null,null,4,null,"2PM",null,4,null,"4PM"]
[null,null,5,null,"4PM",null,5,null,"4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[null,null,1,null,"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]

{"sheet":"Sunday","index":6,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,"GOODS IN TEAM ",null,null,null,"FLOOR TEAM"]
[]
[null,null,1,null,"2PM",null,1,null,"2PM"]
[null,null,2,null,"2PM",null,2,null,"2PM"]
[null,null,3,null,"2PM",null,3,null,"2PM"]
[null,null,4,null,"2PM",null,4,null,"4PM"]
[null,null,5,null,"4PM",null,5,null,"4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[null,null,1,null,"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]

{"sheet":"Names","index":7,"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":1.4221912522112206},{"$f":"RANK($A2,$A$2:$A$22)+COUNTIF(B$1:B1,B1)-1","v":8},"JOHN",null,2.5]
[{"$f":"RAND()*E3","v":1.855966587235601},{"$f":"RANK($A3,$A$2:$A$22)+COUNTIF(B$1:B2,B2)-1","v":4},"MIKE",null,2]
[0.6924737670719594,{"$f":"RANK($A4,$A$2:$A$22)+COUNTIF(B$1:B3,B3)-1","v":16},"SHAUN ",null,2.5]
[0.61797053423371118,{"$f":"RANK($A5,$A$2:$A$22)+COUNTIF(B$1:B4,B4)-1","v":17},"IAN",null,2]
[1.1186658217919678,{"$f":"RANK($A6,$A$2:$A$22)+COUNTIF(B$1:B5,B5)-1","v":12},"STUART",null,2]
[1.379529570412299,{"$f":"RANK($A7,$A$2:$A$22)+COUNTIF(B$1:B6,B6)-1","v":9},"EDWARD",null,2.5]
[1.8343383538140259,{"$f":"RANK($A8,$A$2:$A$22)+COUNTIF(B$1:B7,B7)-1","v":5},"DAVID",null,2]
[2.377318235458874,{"$f":"RANK($A9,$A$2:$A$22)+COUNTIF(B$1:B8,B8)-1","v":2},"ROBERT",null,2.5]
[2.4888509964444649,{"$f":"RANK($A10,$A$2:$A$22)+COUNTIF(B$1:B9,B9)-1","v":1},"ABU",null,2.5]
[1.3153865963899865,{"$f":"RANK($A11,$A$2:$A$22)+COUNTIF(B$1:B10,B10)-1","v":10},"STEVEN",null,2]
[0.96366451343898518,{"$f":"RANK($A12,$A$2:$A$22)+COUNTIF(B$1:B11,B11)-1","v":15},"ALEX",null,2]
[1.8755575610518833,{"$f":"RANK($A13,$A$2:$A$22)+COUNTIF(B$1:B12,B12)-1","v":3},"CARL",null,2]
[0.23560206792869831,{"$f":"RANK($A14,$A$2:$A$22)+COUNTIF(B$1:B13,B13)-1","v":19},"ERIK",null,2]
[1.033903928746708,{"$f":"RANK($A15,$A$2:$A$22)+COUNTIF(B$1:B14,B14)-1","v":14},"EDWIN",null,2]
[1.7759134387139692,{"$f":"RANK($A16,$A$2:$A$22)+COUNTIF(B$1:B15,B15)-1","v":6},"SUNNY",null,2]
[3.4062514515814657E-2,{"$f":"RANK($A17,$A$2:$A$22)+COUNTIF(B$1:B16,B16)-1","v":21},"ANDY",null,2.5]
[1.5426730223110181,{"$f":"RANK($A18,$A$2:$A$22)+COUNTIF(B$1:B17,B17)-1","v":7},"ROY",null,2]
[0.28745624592241459,{"$f":"RANK($A19,$A$2:$A$22)+COUNTIF(B$1:B18,B18)-1","v":18},"GARY",null,2]
[3.4188912167369079E-2,{"$f":"RANK($A20,$A$2:$A$22)+COUNTIF(B$1:B19,B19)-1","v":20},"MARTIN",null,2]
[1.0545896305225249,{"$f":"RANK($A21,$A$2:$A$22)+COUNTIF(B$1:B20,B20)-1","v":13},"JOSE",null,2]
[1.241875336482396,{"$f":"RANK($A22,$A$2:$A$22)+COUNTIF(B$1:B21,B21)-1","v":11},"MAX",null,2]

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

{"sheet":"Copy Names","index":9,"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,null,"2PM",null,1,null,"2PM"]
[null,null,2,null,"2PM",null,2,null,"2PM"]
[null,null,3,null,"2PM",null,3,null,"2PM"]
[null,null,4,null,"2PM",null,4,null,"4PM"]
[null,null,5,null,"4PM",null,5,null,"4PM"]
[]
[]
[null,null,null,null,"2 to 4"]
[null,null,null,"FORKS"]
[null,null,1,null,"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]