{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample","RAND","RANDBETWEEN","SORTBY&RANDARRAY","VBA","VLOOKUP","CHOOSE&RANDBETWEEN","INDEX&RANDBETWEEN"],"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":"Sample","index":0,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Sample Data",null,null,null,"Practice Yourself"]
[]
[null,"List of Food","Quantity Sold",null,null,"List of Food","Quantity Sold"]
[null,"Cookies",1207,null,null,"Cookies",1207]
[null,"Chocolate",1305,null,null,"Chocolate",1305]
[null,"Coffee",990,null,null,"Coffee",990]
[null,"Ice cream",456,null,null,"Ice cream",456]
[null,"Yogurt",238,null,null,"Yogurt",238]
[null,"Donuts",365,null,null,"Donuts",365]
[null,"Crossiant",169,null,null,"Crossiant",169]
[null,"Waffles",388,null,null,"Waffles",388]

{"sheet":"RAND","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,1,1,3]]}
[]
[null,"Insertion of RAND Formula",null,null,null,"Practice Yourself"]
[]
[null,"List of Food","Quantity Sold","Random Numbers",null,"List of Food","Quantity Sold"]
[null,"Coffee",990,{"$f":"RAND()","v":0.15804130002581274},null,"Cookies",1207]
[null,"Crossiant",169,{"$f":"RAND()","v":0.21783634377467109},null,"Chocolate",1305]
[null,"Donuts",365,{"$f":"RAND()","v":0.27960961726127498},null,"Coffee",990]
[null,"Yogurt",238,{"$f":"RAND()","v":0.83539524792203845},null,"Ice cream",456]
[null,"Chocolate",1305,{"$f":"RAND()","v":0.59605726691264949},null,"Yogurt",238]
[null,"Ice cream",456,{"$f":"RAND()","v":0.78950711210117175},null,"Donuts",365]
[null,"Waffles",388,{"$f":"RAND()","v":0.47540670396472839},null,"Crossiant",169]
[null,"Cookies",1207,{"$f":"RAND()","v":0.25315442965601909},null,"Waffles",388]

{"sheet":"RANDBETWEEN","index":2,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,1,1,3]]}
[]
[null,"Application of RANDBETWEEN Function",null,null,null,"Practice Yourself"]
[]
[null,"List of Food","Quantity Sold","Random Numbers",null,"List of Food","Quantity Sold"]
[null,"Waffles",388,{"$f":"RANDBETWEEN(1,100)","v":39},null,"Cookies",1207]
[null,"Cookies",1207,{"$f":"RANDBETWEEN(1,100)","v":81},null,"Chocolate",1305]
[null,"Crossiant",169,{"$f":"RANDBETWEEN(1,100)","v":87},null,"Coffee",990]
[null,"Ice cream",456,{"$f":"RANDBETWEEN(1,100)","v":66},null,"Ice cream",456]
[null,"Coffee",990,{"$f":"RANDBETWEEN(1,100)","v":19},null,"Yogurt",238]
[null,"Chocolate",1305,{"$f":"RANDBETWEEN(1,100)","v":70},null,"Donuts",365]
[null,"Yogurt",238,{"$f":"RANDBETWEEN(1,100)","v":2},null,"Crossiant",169]
[null,"Donuts",365,{"$f":"RANDBETWEEN(1,100)","v":1},null,"Waffles",388]

{"sheet":"SORTBY&RANDARRAY","index":3,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,9,1,10],[1,1,1,4]]}
[]
[null,"Combination of SORTBY and RANDARRAY Functions",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"List of Food","Quantity Sold","Random Numbers","Randomized List",null,null,null,null,"List of Food","Quantity Sold"]
[null,"Cookies",1207,{"$f":"_xlfn.RANDARRAY(8,1)","v":0.90452115742110006},{"$f":"_xlfn.SORTBY(B5:B12,_xlfn.ANCHORARRAY(D5))","v":"Donuts"},null,null,null,null,"Cookies",1207]
[null,"Chocolate",1305,0.51534738222961685,"Crossiant",null,null,null,null,"Chocolate",1305]
[null,"Coffee",990,0.19828226307528385,"Coffee",null,null,null,null,"Coffee",990]
[null,"Ice cream",456,0.9735741047783717,"Yogurt",null,null,null,null,"Ice cream",456]
[null,"Yogurt",238,0.31759130740562491,"Chocolate",null,null,null,null,"Yogurt",238]
[null,"Donuts",365,8.5167705359822987E-2,"Waffles",null,null,null,null,"Donuts",365]
[null,"Crossiant",169,0.11951827663474024,"Cookies",null,null,null,null,"Crossiant",169]
[null,"Waffles",388,0.74151249049379286,"Ice cream",null,null,null,null,"Waffles",388]

{"sheet":"VBA","index":4,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Running a VBA Code",null,null,null,"Practice Yourself"]
[]
[null,"List of Food","Quantity Sold",null,null,"List of Food","Quantity Sold"]
[null,1207,"Waffles",null,null,"Cookies",1207]
[null,456,"Cookies",null,null,"Chocolate",1305]
[null,"Crossiant",169,null,null,"Coffee",990]
[null,"Yogurt",238,null,null,"Ice cream",456]
[null,388,1305,null,null,"Yogurt",238]
[null,"Ice cream","Donuts",null,null,"Donuts",365]
[null,365,990,null,null,"Crossiant",169]
[null,"Chocolate","Coffee",null,null,"Waffles",388]

{"sheet":"VLOOKUP","index":5,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,1,1,4]]}
[]
[null,"Combination of RANDBETWEEN and VLOOKUP Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Numbers","List of Food","Random Numbers","Shuffled List",null,null,null,"List of Food","Quantity Sold"]
[null,1,"Cookies",{"$f":"RANDBETWEEN(1,8)","v":2},{"$f":"VLOOKUP(D5,B$5:C$12,2,FALSE)","v":"Chocolate"},null,null,null,"Cookies",1207]
[null,2,"Chocolate",{"$f":"RANDBETWEEN(1,8)","v":3},{"$f":"VLOOKUP(D6,B$5:C$12,2,FALSE)","v":"Coffee"},null,null,null,"Chocolate",1305]
[null,3,"Coffee",7,"Crossiant",null,null,null,"Coffee",990]
[null,4,"Ice cream",3,"Coffee",null,null,null,"Ice cream",456]
[null,5,"Yogurt",7,"Crossiant",null,null,null,"Yogurt",238]
[null,6,"Donuts",6,"Donuts",null,null,null,"Donuts",365]
[null,7,"Crossiant",4,"Ice cream",null,null,null,"Crossiant",169]
[null,8,"Waffles",5,"Yogurt",null,null,null,"Waffles",388]

{"sheet":"CHOOSE&RANDBETWEEN","index":6,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,1,1,3]]}
[]
[null,"Combination of CHOOSE and RANDBETWEEN Functions",null,null,null,"Practice Yourself"]
[]
[null,"List of Food","Quantity Sold","Shuffled List",null,"List of Food","Quantity Sold"]
[null,"Cookies",1207,{"$f":"CHOOSE(RANDBETWEEN(1,8), $B$5, $B$6,\n$B$7, $B$8, $B$9, $B$10, $B$11, $B$12)","v":"Ice cream"},null,"Cookies",1207]
[null,"Chocolate",1305,{"$f":"CHOOSE(RANDBETWEEN(1,8), $B$5, $B$6,\n$B$7, $B$8, $B$9, $B$10, $B$11, $B$12)","v":"Coffee"},null,"Chocolate",1305]
[null,"Coffee",990,"Cookies",null,"Coffee",990]
[null,"Ice cream",456,"Cookies",null,"Ice cream",456]
[null,"Yogurt",238,"Ice cream",null,"Yogurt",238]
[null,"Donuts",365,"Crossiant",null,"Donuts",365]
[null,"Crossiant",169,"Crossiant",null,"Crossiant",169]
[null,"Waffles",388,"Yogurt",null,"Waffles",388]

{"sheet":"INDEX&RANDBETWEEN","index":7,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,6]]}
[]
[null,"Combination of INDEX and RANDBETWEEN Functions",null,null,null,"Practice Yourself"]
[]
[null,"List of Food","Quantity Sold","Shuffled List",null,"List of Food","Quantity Sold"]
[null,"Cookies",1207,{"$f":"INDEX($B$5:$B$12,RANDBETWEEN(1,8))","v":"Crossiant"},null,"Cookies",1207]
[null,"Chocolate",1305,{"$f":"INDEX($B$5:$B$12,RANDBETWEEN(1,8))","v":"Ice cream"},null,"Chocolate",1305]
[null,"Coffee",990,{"$f":"INDEX($B$5:$B$12,RANDBETWEEN(1,8))","v":"Donuts"},null,"Coffee",990]
[null,"Ice cream",456,{"$f":"INDEX($B$5:$B$12,RANDBETWEEN(1,8))","v":"Crossiant"},null,"Ice cream",456]
[null,"Yogurt",238,{"$f":"INDEX($B$5:$B$12,RANDBETWEEN(1,8))","v":"Cookies"},null,"Yogurt",238]
[null,"Donuts",365,{"$f":"INDEX($B$5:$B$12,RANDBETWEEN(1,8))","v":"Crossiant"},null,"Donuts",365]
[null,"Crossiant",169,{"$f":"INDEX($B$5:$B$12,RANDBETWEEN(1,8))","v":"Chocolate"},null,"Crossiant",169]
[null,"Waffles",388,{"$f":"INDEX($B$5:$B$12,RANDBETWEEN(1,8))","v":"Crossiant"},null,"Waffles",388]