{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset Overview","RANDBETWEEN","ROUND & RAND","RANDARRAY","RANK.EQ & COUNTIF","RAND","Analysis Tool Pak","VBA"],"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":"Dataset Overview","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Team Leader Selection"]
[]
[null,"Employee","Group "]
[null,"Tom"]
[null,"Sam"]
[null,"Paul"]
[null,"Andrew"]
[null,"Rob"]
[null,"Tris"]

{"sheet":"RANDBETWEEN","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Team Leader Selection"]
[]
[null,"Employee","Group "]
[null,"Tom",{"$f":"RANDBETWEEN(10,20)","v":17}]
[null,"Sam",{"$f":"RANDBETWEEN(10,20)","v":17}]
[null,"Paul",12]
[null,"Andrew",10]
[null,"Rob",20]
[null,"Tris",17]

{"sheet":"ROUND & RAND","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Team Leader Selection"]
[]
[null,"Employee","Group "]
[null,"Tom",{"$f":"ROUND(RAND()*10+5,0)","v":10}]
[null,"Sam",{"$f":"ROUND(RAND()*10+5,0)","v":7}]
[null,"Paul",6]
[null,"Andrew",8]
[null,"Rob",9]
[null,"Tris",10]

{"sheet":"RANDARRAY","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Team Leader Selection"]
[]
[null,"Employee","Group 1","Group 2"]
[null,"Tom",{"$f":"_xlfn.RANDARRAY(6,2,10,20,TRUE)","v":11},16]
[null,"Sam",19,13]
[null,"Paul",10,10]
[null,"Andrew",10,17]
[null,"Rob",16,15]
[null,"Tris",10,14]

{"sheet":"RANK.EQ & COUNTIF","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Team Leader Selection"]
[]
[null,"Employee","Group 1","Group 2"]
[null,"Tom",10,{"$f":"_xlfn.RANK.EQ(C6,$C$6:$C$11)+\nCOUNTIF($C$6:C6,C6)-1","v":5}]
[null,"Sam",19,{"$f":"_xlfn.RANK.EQ(C7,$C$6:$C$11)+\nCOUNTIF($C$6:C7,C7)-1","v":1}]
[null,"Paul",19,{"$f":"_xlfn.RANK.EQ(C8,$C$6:$C$11)+\nCOUNTIF($C$6:C8,C8)-1","v":2}]
[null,"Andrew",15,{"$f":"_xlfn.RANK.EQ(C9,$C$6:$C$11)+\nCOUNTIF($C$6:C9,C9)-1","v":3}]
[null,"Rob",11,{"$f":"_xlfn.RANK.EQ(C10,$C$6:$C$11)+\nCOUNTIF($C$6:C10,C10)-1","v":4}]
[null,"Tris",10,{"$f":"_xlfn.RANK.EQ(C11,$C$6:$C$11)+\nCOUNTIF($C$6:C11,C11)-1","v":6}]

{"sheet":"RAND","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Team Leader Selection"]
[]
[null,"Employee","Group"]
[null,"Tom",{"$f":"RAND()","v":0.34644349770543093}]
[null,"Sam",{"$f":"RAND()","v":0.43948429413505108}]
[null,"Paul",0.50887385877165003]
[null,"Andrew",0.2676150008847078]
[null,"Rob",0.50053842222156431]
[null,"Tris",9.4714147473243693E-2]

{"sheet":"Analysis Tool Pak","index":6,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Team Leader Selection"]
[]
[null,"Employee","Group 1"]
[null,"Tom",15.247657704397717]
[null,"Sam",12.101809747611927]
[null,"Paul",10.360423596911527]
[null,"Andrew",16.322824793237096]
[null,"Rob",19.613940855128636]
[null,"Tris",11.026947843867305]

{"sheet":"VBA","index":7,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Team Leader Selection"]
[]
[null,"Employee","Group 1"]
[null,"Tom",{"$f":"RandNumber(10,20,0)","v":10}]
[null,"Sam",{"$f":"RandNumber(10,20,0)","v":15}]
[null,"Paul",{"$f":"RandNumber(10,20,0)","v":12}]
[null,"Andrew",{"$f":"RandNumber(10,20,0)","v":14}]
[null,"Rob",{"$f":"RandNumber(10,20,0)","v":16}]
[null,"Tris",{"$f":"RandNumber(10,20,0)","v":11}]