{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["RAND","U-limit","Range-RAND","Integer","Integer-Ulimit","RANDBETWEEN-Dec","RANDBETWEEN-INT","Letter","DAte","TIMAVALUE","TIME","Time-Date","Unique","Ranking","Largest","RAND-INDEX","VBA"],"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":"RAND","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null," Using RAND Function"]
[]
[null,"Name","Numbers"]
[null,"Mike",{"$f":"RAND()","v":0.97768748991087739}]
[null,"Adam",{"$f":"RAND()","v":0.14627069510337087}]
[null,"Steve",0.78857713611898617]
[null,"Hopper",0.27920258302451784]
[null,"Bob",0.31675532275326423]
[null,"John",0.12662280350927579]
[null,"David",0.33518167077657823]

{"sheet":"U-limit","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Specifying Upper Limit in RAND() Function"]
[]
[null,"Name","Numbers"]
[null,"Mike",{"$f":"RAND()*25","v":2.3513832538147597}]
[null,"Adam",{"$f":"RAND()*25","v":17.373791702099009}]
[null,"Steve",0.76795657958177721]
[null,"Hopper",10.97963784351996]
[null,"Bob",20.994495651607455]
[null,"John",7.8826731913352432]
[null,"David",17.292219445407177]

{"sheet":"Range-RAND","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Changing Range in RAND() Function"]
[]
[null,"Name","Numbers"]
[null,"Mike",{"$f":"RAND()*(100-50)+50","v":63.835850284559662}]
[null,"Adam",{"$f":"RAND()*(100-50)+50","v":92.707495652735616}]
[null,"Steve",81.469286642475652]
[null,"Hopper",93.442444298523867]
[null,"Bob",86.255050089251768]
[null,"John",64.672388918512425]
[null,"David",58.572722025811039]

{"sheet":"Integer","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Random Integer with Changed Range"]
[]
[null,"Name","Numbers"]
[null,"Mike",{"$f":"INT(RAND()*(100-50)+50)","v":83}]
[null,"Adam",{"$f":"INT(RAND()*(100-50)+50)","v":51}]
[null,"Steve",68]
[null,"Hopper",53]
[null,"Bob",89]
[null,"John",94]
[null,"David",58]

{"sheet":"Integer-Ulimit","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Random Integer with Specified Upper Limit"]
[]
[null,"Name","Numbers"]
[null,"Mike",{"$f":"INT(RAND()*25)","v":4}]
[null,"Adam",{"$f":"INT(RAND()*25)","v":1}]
[null,"Steve",23]
[null,"Hopper",3]
[null,"Bob",19]
[null,"John",23]
[null,"David",0]

{"sheet":"RANDBETWEEN-Dec","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using RANDBETWEEN() Function with Decimal Places"]
[]
[null,"Name","Numbers"]
[null,"Mike",{"$f":"RANDBETWEEN(15*10,30*10)/10","v":28.2}]
[null,"Adam",{"$f":"RANDBETWEEN(15*10,30*10)/10","v":19.899999999999999}]
[null,"Steve",19.5]
[null,"Hopper",16.399999999999999]
[null,"Bob",15.6]
[null,"John",28.8]
[null,"David",24]

{"sheet":"RANDBETWEEN-INT","index":6,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using RANDBETWEEN() Function"]
[]
[null,"Name","Numbers"]
[null,"Mike",{"$f":"RANDBETWEEN(15,30)","v":23}]
[null,"Adam",{"$f":"RANDBETWEEN(15,30)","v":18}]
[null,"Steve",29]
[null,"Hopper",18]
[null,"Bob",26]
[null,"John",18]
[null,"David",17]

{"sheet":"Letter","index":7,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Generating Random Letter"]
[]
[null,"Name","Random Letter"]
[null,"Mike",{"$f":"CHAR(RANDBETWEEN(CODE(\"A\"),CODE(\"Z\")))","v":"R"}]
[null,"Adam",{"$f":"CHAR(RANDBETWEEN(CODE(\"A\"),CODE(\"Z\")))","v":"S"}]
[null,"Steve","Q"]
[null,"Hopper","D"]
[null,"Bob","X"]
[null,"John","Q"]
[null,"David","K"]

{"sheet":"DAte","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Generating Random Date"]
[]
[null,"Name","Random Date"]
[null,"Mike",{"$f":"RANDBETWEEN(DATEVALUE(\"1-Mar-2022\"),DATEVALUE(\"17-Mar-2022\"))","v":"2022-03-04"}]
[null,"Adam",{"$f":"RANDBETWEEN(DATEVALUE(\"1-Mar-2022\"),DATEVALUE(\"17-Mar-2022\"))","v":"2022-03-01"}]
[null,"Steve","2022-03-02"]
[null,"Hopper","2022-03-02"]
[null,"Bob","2022-03-05"]
[null,"John","2022-03-17"]
[null,"David","2022-03-05"]

{"sheet":"TIMAVALUE","index":9,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Generating Random Time"]
[]
[null,"Name","Random Time"]
[null,"Mike",{"$f":"TIMEVALUE(\"12:00 AM\") + RAND() * (TIMEVALUE(\"6:00 PM\") - TIMEVALUE(\"12:00 AM\"))","v":"05:08:59.282"}]
[null,"Adam",{"$f":"TIMEVALUE(\"12:00 AM\") + RAND() * (TIMEVALUE(\"6:00 PM\") - TIMEVALUE(\"12:00 AM\"))","v":"08:29:04.247"}]
[null,"Steve","13:54:25.801"]
[null,"Hopper","06:36:15.267"]
[null,"Bob","00:58:18.658"]
[null,"John","04:50:24.212"]
[null,"David","14:35:39.333"]

{"sheet":"TIME","index":10,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Generating Random Time"]
[]
[null,"Name","Random Time"]
[null,"Mike",{"$f":"TIME(12,0,0) + RAND() * (TIME(18,0,0) - TIME(12,0,0))","v":"14:41:27.356"}]
[null,"Adam",{"$f":"TIME(12,0,0) + RAND() * (TIME(18,0,0) - TIME(12,0,0))","v":"15:09:17.364"}]
[null,"Steve","13:19:30.940"]
[null,"Hopper","17:52:17.411"]
[null,"Bob","12:38:55.375"]
[null,"John","14:32:53.825"]
[null,"David","15:28:30.606"]

{"sheet":"Time-Date","index":11,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Generating Random Time and Date"]
[]
[null,"Name","Time and Date"]
[null,"Mike",{"$f":"RANDBETWEEN(DATEVALUE(\"1-Mar-2022\"),DATEVALUE(\"17-Mar-2022\"))+RANDBETWEEN(TIMEVALUE(\"8:00 AM\")*10000,TIMEVALUE(\"8:00 PM\")*10000)/10000","v":"2022-03-03T09:04:27.840"}]
[null,"Adam",{"$f":"RANDBETWEEN(DATEVALUE(\"1-Mar-2022\"),DATEVALUE(\"17-Mar-2022\"))+RANDBETWEEN(TIMEVALUE(\"8:00 AM\")*10000,TIMEVALUE(\"8:00 PM\")*10000)/10000","v":"2022-03-12T10:50:52.800"}]
[null,"Steve","2022-03-17T17:30:54.720"]
[null,"Hopper","2022-03-02T10:45:50.400"]
[null,"Bob","2022-03-15T19:14:00.960"]
[null,"John","2022-03-15T16:06:48.960"]
[null,"David","2022-03-16T15:59:54.240"]

{"sheet":"Unique","index":12,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sorting Unique Numbers"]
[]
[null,"Number","Random"]
[null,2,{"$f":"RAND()","v":0.44953920987798002}]
[null,1,0.72312250741630169]
[null,4,3.276284141746244E-2]
[null,14,0.14824380004474913]
[null,13,0.62177565639842924]
[null,3,0.84455808524621434]
[null,11,0.67820326119181484]
[null,12,0.1609267356585693]
[null,5,2.6863466880389542E-2]
[null,15,0.22761063333037801]
[null,10,0.92382839080988943]
[null,7,0.21432770262290313]
[null,6,0.36933412874784732]
[null,9,0.40084517119151364]
[null,8,0.32856352188868099]

{"sheet":"Ranking","index":13,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Ranking Random Numbers"]
[]
[null,"Random","Rank"]
[null,{"$f":"RAND()","v":4.3156299853337687E-2},{"$f":"RANK(B5,B$5:B$20)","v":16}]
[null,0.65885036447619816,{"$f":"RANK(B6,B$5:B$20)","v":8}]
[null,0.79401033738026017,6]
[null,0.91045443838775575,2]
[null,0.32622883365895472,12]
[null,0.86774252536341134,3]
[null,0.91257543860906087,1]
[null,0.31788921403135728,13]
[null,0.6907765007962926,7]
[null,0.53526517913262806,9]
[null,0.44744937498556803,11]
[null,0.47614259589076258,10]
[null,0.15241389741800138,14]
[null,6.6351816960987575E-2,15]
[null,0.85093862224725825,4]
[null,0.84406272391919701,5]

{"sheet":"Largest","index":14,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Largest Value and MATCH function"]
[]
[null,"Random","Rank"]
[null,{"$f":"RAND()","v":0.65839446998272733},{"$f":"MATCH(LARGE($B$5:$B$14, ROW(C5)-4), $B$5:$B$14, 0)","v":6}]
[null,{"$f":"RAND()","v":0.77741953927947682},{"$f":"MATCH(LARGE($B$5:$B$14, ROW(C6)-4), $B$5:$B$14, 0)","v":3}]
[null,0.98384121349671649,7]
[null,6.1295047735909769E-3,2]
[null,0.22918622907209485,1]
[null,0.98739541423125088,9]
[null,0.83525573625720073,10]
[null,0.1281279281193336,5]
[null,0.49691367869038994,8]
[null,0.30387456540579461,4]

{"sheet":"RAND-INDEX","index":15,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using RAND and INDEX function"]
[]
[null,"Integer","Random","Rank"]
[null,1,0.65239710932895256,{"$f":"INDEX(B$5:B$14, RANK(C5, C$5:C$14))","v":4}]
[null,2,0.47238351822147839,{"$f":"INDEX(B$5:B$14, RANK(C6, C$5:C$14))","v":7}]
[null,3,0.91401897376896246,1]
[null,4,0.42643578909957314,8]
[null,5,0.81490585878127186,2]
[null,6,0.50016500721483348,6]
[null,7,0.23145272553469598,9]
[null,8,0.18246972945686668,10]
[null,9,0.54246737344671458,5]
[null,10,0.78966602339247605,{"$f":"INDEX(B$5:B$14, RANK(C14, C$5:C$14))","v":3}]

{"sheet":"VBA","index":16,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using VBA Code"]
[null,9]
[null,14]
[null,4]
[null,13]
[null,2]
[null,7]
[null,12]
[null,6]
[null,8]
[null,5]
[null,10]
[null,15]
[null,3]
[null,11]
[null,1]