{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Overview","RAND_0&1","RAND_50","RAND_5&25","RAND_whole","RANDBETWEEN","RANDBETWEEN_1decimal","RANDARRAY","Analysis ToolPak","VBA","RANK.EQ_COUNTIF","VBANoRepeat","SEQUENCE_SORTBY_RANDARRAY","RandomDates","RandomTimes","RandomLetters"],"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":"Overview","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Overview of Random Number Generator"]
[]
[null,"Random Numbers\n Between 0 & 1",{"$f":"RAND()","v":0.30415925866181925},{"$f":"_xlfn.FORMULATEXT(C4)","v":"=RAND()"}]
[null,"Random Numbers Within 50",{"$f":"RAND()*50","v":31.50561807244322},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=RAND()*50"}]
[null,"Random Numbers Between 5 & 25",{"$f":"RAND()*(25-5)+5","v":16.531268928082692},"=RAND()*(25-5)+5"]
[null,"Random Numbers \nBetween 5 & 25",{"$f":"RANDBETWEEN(5, 25)","v":25},"=RANDBETWEEN(5, 25)"]
[null,"Random Numbers Between 10 & 50",{"$f":"_xlfn.RANDARRAY(1, 1, 10, 50, TRUE)","v":31},"=RANDARRAY(1, 1, 10, 50, TRUE)"]

{"sheet":"RAND_0&1","index":1,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using RAND Function",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Numbers\nBetween 0 & 1",null,null,null,null,null,null,null,"Random Numbers\nBetween 0 & 1"]
[null,{"$f":"RAND()","v":0.64468712733338207}]
[null,{"$f":"RAND()","v":0.88079610699025346}]
[null,0.81617572309375797]
[null,0.9417096342195197]
[null,0.68161072370801512]
[null,0.96687752117193537]
[null,0.58692092406206464]
[null,0.60097459631957939]
[null,0.10789789948762374]
[null,0.41573629793610167]

{"sheet":"RAND_50","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using RAND Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Numbers\nWithin 50",null,null,null,null,null,null,"Random Numbers\nWithin 50"]
[null,{"$f":"RAND()*50","v":40.376035541374698}]
[null,{"$f":"RAND()*50","v":40.877460872605624}]
[null,5.1425706361091672]
[null,41.174387453304476]
[null,42.295563357593558]
[null,18.89342946437209]
[null,18.678424897009144]
[null,41.153931073384669]
[null,13.757790458432961]
[null,42.000105816023989]

{"sheet":"RAND_5&25","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using RAND Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Numbers\nBetween 5 & 25",null,null,null,null,null,null,"Random Numbers\nBetween 5 & 25"]
[null,{"$f":"RAND()*(25-5)+5","v":15.730221708770436}]
[null,{"$f":"RAND()*(25-5)+5","v":13.209303172211584}]
[null,10.302732391984389]
[null,16.687269664999171]
[null,5.1371048077343628]
[null,11.920450369181999]
[null,6.893362353927774]
[null,9.5930230438334547]
[null,8.3372882428634085]
[null,18.43744294593052]

{"sheet":"RAND_whole","index":4,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using RAND Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Integers\nBetween 5 & 25",null,null,null,null,null,null,null,null,"Random Integers\nBetween 5 & 25"]
[null,{"$f":"ROUND(RAND()*(25-5)+5,0)","v":14}]
[null,{"$f":"ROUND(RAND()*(25-5)+5,0)","v":8}]
[null,9]
[null,9]
[null,22]
[null,13]
[null,17]
[null,8]
[null,9]
[null,21]

{"sheet":"RANDBETWEEN","index":5,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using RANDBETWEEN Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Numbers \nBetween 5 & 25",null,null,null,null,null,null,"Random Numbers \nBetween 5 & 25"]
[null,{"$f":"RANDBETWEEN(5, 25)","v":24}]
[null,{"$f":"RANDBETWEEN(5, 25)","v":6}]
[null,21]
[null,7]
[null,21]
[null,23]
[null,21]
[null,9]
[null,20]
[null,11]

{"sheet":"RANDBETWEEN_1decimal","index":6,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using RANDBETWEEN Function",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Numbers\nup to 1 Decimal Place",null,null,null,null,null,null,null,"Random Numbers\nup to 1 Decimal Place"]
[null,{"$f":"RANDBETWEEN(5*10, 50*10)/10","v":40.299999999999997}]
[null,{"$f":"RANDBETWEEN(5*10, 50*10)/10","v":9.3000000000000007}]
[null,31.9]
[null,19.5]
[null,8.6999999999999993]
[null,35.6]
[null,15.6]
[null,42]
[null,18.2]
[null,18.8]

{"sheet":"RANDARRAY","index":7,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,1,3,2],[1,1,1,2],[3,10,3,11],[1,10,1,11]]}
[]
[null,"Using RANDARRAY Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Numbers\nBetween 10 & 50",null,null,null,null,null,null,null,null,"Random Numbers\nBetween 10 & 50"]
[null,{"$f":"_xlfn.RANDARRAY(6, 2, 10, 50,TRUE )","v":14},37]
[null,13,30]
[null,17,30]
[null,38,20]
[null,38,15]
[null,32,37]

{"sheet":"Analysis ToolPak","index":8,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Data Analysis",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Numbers\nBetween 5 & 25",null,null,null,null,null,null,null,null,"Random Numbers\nBetween 5 & 25"]
[null,23.274483474227118]
[null,14.163487655262918]
[null,18.527634510330515]
[null,18.431806390575886]
[null,17.454603717154455]
[null,21.007568590350047]
[null,8.0060731833857233]
[null,5.4742576372569962]
[null,13.366344187749871]
[null,11.722006897183142]

{"sheet":"VBA","index":9,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Excel VBA",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Numbers\nBetween 20 & 50",null,null,null,null,null,null,null,"Random Numbers\nBetween 20 & 50"]
[null,41]
[null,36]
[null,37]
[null,29]
[null,29]
[null,43]
[null,20]
[null,43]
[null,44]
[null,41]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]

{"sheet":"RANK.EQ_COUNTIF","index":10,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combining RANK.EQ and COUNTIF Functions",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Numbers \nBetween 5 & 25","Random Numbers\nWithout Duplicates",null,null,null,null,null,null,"Random Numbers\nWithout Duplicates"]
[null,24,{"$f":" _xlfn.RANK.EQ(B5, $B$5:$B$14 ) +\n COUNTIF($B$5:B5, B5) - 1","v":1}]
[null,10,{"$f":" _xlfn.RANK.EQ(B6, $B$5:$B$14 ) + COUNTIF($B$5:B6, B6) - 1","v":6}]
[null,11,{"$f":" _xlfn.RANK.EQ(B7, $B$5:$B$14 ) + COUNTIF($B$5:B7, B7) - 1","v":4}]
[null,24,{"$f":" _xlfn.RANK.EQ(B8, $B$5:$B$14 ) + COUNTIF($B$5:B8, B8) - 1","v":2}]
[null,5,{"$f":" _xlfn.RANK.EQ(B9, $B$5:$B$14 ) + COUNTIF($B$5:B9, B9) - 1","v":10}]
[null,8,{"$f":" _xlfn.RANK.EQ(B10, $B$5:$B$14 ) + COUNTIF($B$5:B10, B10) - 1","v":8}]
[null,9,{"$f":" _xlfn.RANK.EQ(B11, $B$5:$B$14 ) + COUNTIF($B$5:B11, B11) - 1","v":7}]
[null,11,{"$f":" _xlfn.RANK.EQ(B12, $B$5:$B$14 ) + COUNTIF($B$5:B12, B12) - 1","v":5}]
[null,8,{"$f":" _xlfn.RANK.EQ(B13, $B$5:$B$14 ) + COUNTIF($B$5:B13, B13) - 1","v":9}]
[null,15,{"$f":" _xlfn.RANK.EQ(B14, $B$5:$B$14 ) + COUNTIF($B$5:B14, B14) - 1","v":3}]

{"sheet":"VBANoRepeat","index":11,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Excel VBA",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Numbers Between\n1 & 10 Without Repetition",null,null,null,null,null,null,null,null,"Random Numbers Between\n1 & 10 Without Repetition"]
[null,7]
[null,6]
[null,4]
[null,8]
[null,1]
[null,5]
[null,9]
[null,10]
[null,2]
[null,3]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]

{"sheet":"SEQUENCE_SORTBY_RANDARRAY","index":12,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Combining SEQUENCE, SORTBY, RANDARRAY, and INDEX Functions",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Numbers Between\n1 & 15 Without Repetition",null,null,null,null,null,null,null,null,"Random Numbers Between\n1 & 15 Without Repetition"]
[null,{"$f":"INDEX(_xlfn.SORTBY(_xlfn.SEQUENCE(15),\n_xlfn.RANDARRAY(15)), _xlfn.SEQUENCE(10))","v":1}]
[null,12]
[null,9]
[null,8]
[null,2]
[null,7]
[null,3]
[null,4]
[null,13]
[null,10]

{"sheet":"RandomDates","index":13,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Generate Random Dates",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Dates in March, 2023",null,null,null,null,null,null,null,null,"Random Dates in March, 2023"]
[null,{"$f":"RANDBETWEEN(\nDATEVALUE(\"1-Mar-2023\"),\nDATEVALUE(\"30- Mar-2023\"))","v":"2023-03-19"}]
[null,{"$f":"RANDBETWEEN(DATEVALUE(\"1-Mar-2023\"),DATEVALUE(\"30- Mar-2023\"))","v":"2023-03-16"}]
[null,"2023-03-16"]
[null,"2023-03-02"]
[null,"2023-03-19"]
[null,"2023-03-07"]
[null,"2023-03-29"]
[null,"2023-03-20"]
[null,"2023-03-14"]
[null,"2023-03-17"]

{"sheet":"RandomTimes","index":14,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Generate Random Time",null,null,null,null,"Practice Yourself"]
[]
[null,"Random Time",null,null,null,null,"Random Time"]
[null,{"$f":"RAND()","v":"23:55:37.049"}]
[null,{"$f":"RAND()","v":"11:49:22.884"}]
[null,"05:22:08.260"]
[null,"00:52:50.245"]
[null,"23:18:54.036"]
[null,"12:27:45.127"]
[null,"05:14:48.480"]
[null,"18:21:31.387"]
[null,"10:55:46.798"]
[null,"22:50:04.592"]

{"sheet":"RandomLetters","index":15,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Generate Random Letters",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Random Letters",null,null,null,null,null,null,null,"Random Letters"]
[null,{"$f":"CHAR(RANDBETWEEN(\nCODE(\"A\"),CODE(\"Z\")))","v":"E"}]
[null,{"$f":"CHAR(RANDBETWEEN(CODE(\"A\"),CODE(\"Z\")))","v":"S"}]
[null,"T"]
[null,"P"]
[null,"T"]
[null,"D"]
[null,"P"]
[null,"N"]
[null,"T"]
[null,"H"]