{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset Overview","RANDBETWEEN","ROUND & RAND","RANDARRAY","RANK.EQ & COUNTIF","RAND","RANDARRAY2","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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset Overview"]
[]
[null,"Employee","Group 1"]
[null,"Mike"]
[null,"Chris"]
[null,"Paul"]
[null,"Andrew"]
[null,"John"]
[null,"Emily"]

{"sheet":"RANDBETWEEN","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of RANDBETWEEN Function"]
[]
[null,"Employee","Group 1"]
[null,"Mike",{"$f":"RANDBETWEEN(10,20)","v":14}]
[null,"Chris",{"$f":"RANDBETWEEN(10,20)","v":17}]
[null,"Paul",{"$f":"RANDBETWEEN(10,20)","v":19}]
[null,"Andrew",20]
[null,"John",12]
[null,"Emily",20]

{"sheet":"ROUND & RAND","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of ROUND & RAND Functions"]
[]
[null,"Employee","Group 1"]
[null,"Mike",{"$f":"ROUND(RAND()*10+5,0)","v":12}]
[null,"Chris",{"$f":"ROUND(RAND()*10+5,0)","v":6}]
[null,"Paul",{"$f":"ROUND(RAND()*10+5,0)","v":12}]
[null,"Andrew",10]
[null,"John",12]
[null,"Emily",14]

{"sheet":"RANDARRAY","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of RANDARRAY Function"]
[]
[null,"Employee","Group 1","Group 2"]
[null,"Mike",{"$f":"_xlfn.RANDARRAY(6,2,10,20,TRUE)","v":15},11]
[null,"Chris",17,16]
[null,"Paul",17,14]
[null,"Andrew",15,18]
[null,"John",17,14]
[null,"Emily",13,17]

{"sheet":"RANK.EQ & COUNTIF","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of RANK.EQ & COUNTIF Functions"]
[]
[null,"Employee","Group 1","Group 2"]
[null,"Mike",10,{"$f":"_xlfn.RANK.EQ(C5,$C$5:$C$10)+COUNTIF($C$5:C5,C5)-1","v":5}]
[null,"Chris",19,{"$f":"_xlfn.RANK.EQ(C6,$C$5:$C$10)+COUNTIF($C$5:C6,C6)-1","v":1}]
[null,"Paul",19,{"$f":"_xlfn.RANK.EQ(C7,$C$5:$C$10)+COUNTIF($C$5:C7,C7)-1","v":2}]
[null,"Andrew",15,{"$f":"_xlfn.RANK.EQ(C8,$C$5:$C$10)+COUNTIF($C$5:C8,C8)-1","v":3}]
[null,"John",11,{"$f":"_xlfn.RANK.EQ(C9,$C$5:$C$10)+COUNTIF($C$5:C9,C9)-1","v":4}]
[null,"Emily",10,{"$f":"_xlfn.RANK.EQ(C10,$C$5:$C$10)+COUNTIF($C$5:C10,C10)-1","v":6}]

{"sheet":"RAND","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of RAND Function"]
[]
[null,"Employee","Group 1"]
[null,"Mike",{"$f":"RAND()","v":0.18396908224212305}]
[null,"Chris",{"$f":"RAND()","v":0.53174629476242219}]
[null,"Paul",0.24045755235214605]
[null,"Andrew",0.25787777418538482]
[null,"John",0.75881442349573858]
[null,"Emily",0.40408900400316305]

{"sheet":"RANDARRAY2","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of RANDARRAY Function"]
[]
[null,"Employee","Group 1","Group 2"]
[null,"Mike",{"$f":"_xlfn.RANDARRAY(6,2,5,15,FALSE)","v":9.704417525937334},14.591162412581557]
[null,"Chris",6.9668878254604856,5.1342929983790633]
[null,"Paul",9.9398259761613161,13.392639959001277]
[null,"Andrew",8.2949271956505335,13.106799494516306]
[null,"John",13.82907435739317,13.193088384938941]
[null,"Emily",12.172413769290747,9.2067939607772527]

{"sheet":"Analysis Tool Pak","index":7,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Enable Analysis Tool Pak"]
[]
[null,"Employee","Group 1"]
[null,"Mike",10.921964171269876]
[null,"Chris",17.601855525376141]
[null,"Paul",16.975615710928679]
[null,"Andrew",15.082552568132572]
[null,"John",13.672292245246743]
[null,"Emily",19.381694998016297]

{"sheet":"VBA","index":8,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"With VBA"]
[]
[null,"Employee","Group 1"]
[null,"Mike",18.309999999999999]
[null,"Chris",{"$f":"RandNum(10,20,2)","v":18.809999999999999}]
[null,"Paul",{"$f":"RandNum(10,20,2)","v":14.33}]
[null,"Andrew",{"$f":"RandNum(10,20,2)","v":17.38}]
[null,"John",{"$f":"RandNum(10,20,2)","v":18.48}]
[null,"Emily",{"$f":"RandNum(10,20,2)","v":18.02}]