{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["RAND","RABNDBETWEEN","RANDARRAY","RAND_RANK","ROUND_RAND","Toolpak","VBA_S","VBA_list","RANK.EQ_COUNTIF"],"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":"RAND","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of RAND Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Random Numbers",null,null,null,null,null,null,null,null,"Random Numbers"]
[null,0.73025937143632202]
[null,0.36839623125899246]
[null,0.15332538120874295]
[null,0.64187268910871065]
[null,2.3802099851496505E-2]
[null,9.0194632730814073E-2]
[]
[]
[null,"Random Numbers"]
[null,{"$f":"RAND()*5+1","v":5.5850362396731708}]
[null,{"$f":" RAND()*5+1","v":5.9383683075011664}]
[null,1.8934583933333777]
[null,3.8089913712725734]
[null,1.3055325495448791]

{"sheet":"RABNDBETWEEN","index":1,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of RANDBETWEEN Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Random Numbers",null,null,null,null,null,null,null,null,"Random Numbers"]
[null,{"$f":"RANDBETWEEN(10,50)","v":41}]
[null,{"$f":"RANDBETWEEN(10,50)","v":17}]
[null,32]
[null,43]
[null,26]
[null,21]
[null,22]
[null,23]

{"sheet":"RANDARRAY","index":2,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,10,3,11],[3,1,3,2],[1,10,1,11]]}
[]
[null,"Use of RANDARRAY Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Random Numbers",null,null,null,null,null,null,null,null,"Random Numbers"]
[null,{"$f":"_xlfn.RANDARRAY(5,2,10,20,TRUE)","v":17},19]
[null,12,15]
[null,17,17]
[null,15,13]
[null,18,18]

{"sheet":"RAND_RANK","index":3,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,10,1,11]]}
[]
[null,"RAND & RANK.EQ Functions",null,null,null,{"$f":"_xlfn.RANK.EQ(B5,$B$5:$B$13)","v":5},null,null,null,null,"Try Yourself"]
[]
[null,"Random Numbers","Rank",null,null,null,null,null,null,null,"Random Numbers","Rank"]
[null,0.415248910559748,{"$f":"_xlfn.RANK.EQ(B5,$B$5:$B$13)","v":5}]
[null,0.6473029018079981,{"$f":"_xlfn.RANK.EQ(B6,$B$5:$B$13)","v":2}]
[null,0.14450065453927297,6]
[null,1.0756461552857921E-2,9]
[null,0.91543497756295578,1]
[null,2.9881532944476707E-2,8]
[null,0.51701934647871661,3]
[null,0.51701934647871661,3]
[null,9.6264540086950956E-2,7]

{"sheet":"ROUND_RAND","index":4,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ROUND & RAND Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Random Numbers",null,null,null,null,null,null,null,null,"Random Numbers"]
[null,{"$f":"ROUND(RAND()*19+1,0)","v":20},null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*19+1,0)","v":9}]
[null,{"$f":" ROUND( RAND()*19+1,0 )","v":13},null,null,null,null,null,null,null,null,{"$f":" ROUND( RAND()*19+1,0 )","v":18}]
[null,1,null,null,null,null,null,null,null,null,13]
[null,8,null,null,null,null,null,null,null,null,11]
[null,12,null,null,null,null,null,null,null,null,5]
[null,1,null,null,null,null,null,null,null,null,11]
[null,8,null,null,null,null,null,null,null,null,2]
[null,15,null,null,null,null,null,null,null,null,1]
[null,4,null,null,null,null,null,null,null,null,18]

{"sheet":"Toolpak","index":5,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2],[1,10,1,11],[3,10,3,11]]}
[]
[null,"Use of Analysis Toolpak",null,null,null,null,null,null,null,null,"Try yourself"]
[]
[null,"Random Numbers",null,null,null,null,null,null,null,null,"Random Numbers"]
[null,26.426282540360727,33.872798852504047]
[null,34.353770561845764,34.752952665791803]
[null,37.149266029847105,11.816461684011353]
[null,24.32782982879116,30.978423413800471]
[null,17.291482284005248,43.130893887142548]

{"sheet":"VBA_S","index":6,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of VBA (Message Box)"]
[]
[null,"Random Numbers"]

{"sheet":"VBA_list","index":7,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of VBA (Result as List)"]
[]
[null,"Random Numbers"]
[null,7]
[null,7]
[null,5]
[null,5]
[null,8]

{"sheet":"RANK.EQ_COUNTIF","index":8,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2],[1,10,1,11],[3,10,3,11]]}
[]
[null,"RANDBETWEEN, RANK.EQ & COUNTIF Functions",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Random Numbers",null,null,null,null,null,null,null,null,"Random Numbers"]
[null,{"$f":"RANDBETWEEN(1,10)","v":9},{"$f":"_xlfn.RANK.EQ(B5,$B$5:$B$13)+COUNTIF($B$5:B5,B5)-1","v":3}]
[null,{"$f":"RANDBETWEEN(1,10)","v":3},{"$f":"_xlfn.RANK.EQ(B6,$B$5:$B$13)+COUNTIF($B$5:B6,B6)-1","v":6}]
[null,3,{"$f":"_xlfn.RANK.EQ(B7,$B$5:$B$13)+COUNTIF($B$5:B7,B7)-1","v":7}]
[null,5,{"$f":"_xlfn.RANK.EQ(B8,$B$5:$B$13)+COUNTIF($B$5:B8,B8)-1","v":5}]
[null,3,{"$f":"_xlfn.RANK.EQ(B9,$B$5:$B$13)+COUNTIF($B$5:B9,B9)-1","v":8}]
[null,9,{"$f":"_xlfn.RANK.EQ(B10,$B$5:$B$13)+COUNTIF($B$5:B10,B10)-1","v":4}]
[null,10,{"$f":"_xlfn.RANK.EQ(B11,$B$5:$B$13)+COUNTIF($B$5:B11,B11)-1","v":1}]
[null,2,{"$f":"_xlfn.RANK.EQ(B12,$B$5:$B$13)+COUNTIF($B$5:B12,B12)-1","v":9}]
[null,10,{"$f":"_xlfn.RANK.EQ(B13,$B$5:$B$13)+COUNTIF($B$5:B13,B13)-1","v":2}]