{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["M1","M2","M3","M4","M5","M6"],"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":"M1","index":0,"n_rows":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,12,1,18]]}
[]
[null,"Using RAND Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Quantity","Delivery Date","Price",null,"Name","Rand Value",null,null,null,null,"Name","Quantity","Delivery Date","Price",null,"Name","Rand Value"]
[null,"Apples",5,"2022-09-05",2500,null,"Eggplant",{"$f":"RAND()","v":0.20359097584807295},null,null,null,null,"Apples",5,"2022-09-05",2500,null,"Eggplant"]
[null,"Butter ",6,"2022-08-10",600,null,"Milk",0.82861694981237366,null,null,null,null,"Butter ",6,"2022-08-10",600,null,"Milk"]
[null,"Cauliflower",81,"2022-12-15",1200,null,"Butter ",0.1128592804088947,null,null,null,null,"Cauliflower",81,"2022-12-15",1200,null,"Butter "]
[null,"Cheese",9,"2022-05-12",3500,null,"Pineapple",0.15028224951165725,null,null,null,null,"Cheese",9,"2022-05-12",3500,null,"Pineapple"]
[null,"Eggplant",10,"2022-10-06",150,null,"Orange",0.68732990367226721,null,null,null,null,"Eggplant",10,"2022-10-06",150,null,"Orange"]
[null,"Grapes ",25,"2022-12-08",4000,null,"Mango",0.78810310181061249,null,null,null,null,"Grapes ",25,"2022-12-08",4000,null,"Mango"]
[null,"Mango",15,"2022-01-09",2700,null,"Cauliflower",0.75631862692171448,null,null,null,null,"Mango",15,"2022-01-09",2700,null,"Cauliflower"]
[null,"Milk",8,"2022-09-11",5000,null,"Cheese",0.67041590460842071,null,null,null,null,"Milk",8,"2022-09-11",5000,null,"Cheese"]
[null,"Orange",10,"2022-09-13",2600,null,"Grapes ",0.96656401424667071,null,null,null,null,"Orange",10,"2022-09-13",2600,null,"Grapes "]
[null,"Pineapple",20,"2022-09-16",2200,null,"Apples",0.2121889743258456,null,null,null,null,"Pineapple",20,"2022-09-16",2200,null,"Apples"]

{"sheet":"M2","index":1,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Using RAND Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Quantity","Delivery Date","Price","Sort Order",null,null,null,"Name","Quantity","Delivery Date","Price","Sort Order"]
[null,"Apples",9,"2022-05-12",3500,{"$f":"RAND()","v":0.86112262730718525},null,null,null,"Apples",9,"2022-05-12",3500]
[null,"Butter ",8,"2022-09-11",5000,0.2573616766118747,null,null,null,"Butter ",8,"2022-09-11",5000]
[null,"Cauliflower",20,"2022-09-16",2200,3.1134405793204145E-2,null,null,null,"Cauliflower",20,"2022-09-16",2200]
[null,"Cheese",81,"2022-12-15",1200,0.91165691446099362,null,null,null,"Cheese",81,"2022-12-15",1200]
[null,"Eggplant",5,"2022-09-05",2500,0.31800024013000949,null,null,null,"Eggplant",5,"2022-09-05",2500]
[null,"Grapes ",15,"2022-01-09",2700,0.28742379349207203,null,null,null,"Grapes ",15,"2022-01-09",2700]
[null,"Mango",10,"2022-10-06",150,0.81322647406288273,null,null,null,"Mango",10,"2022-10-06",150]
[null,"Milk",10,"2022-09-13",2600,0.39936191142023081,null,null,null,"Milk",10,"2022-09-13",2600]
[null,"Orange",6,"2022-08-10",600,0.23052590938480921,null,null,null,"Orange",6,"2022-08-10",600]
[null,"Pineapple",25,"2022-12-08",4000,3.6934280451375368E-2,null,null,null,"Pineapple",25,"2022-12-08",4000]

{"sheet":"M3","index":2,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,5],[1,11,1,15]]}
[]
[null,"Using RAND & SORT Functions",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Quantity","Delivery Date","Price","Sort Order",null,null,null,null,null,"Name","Quantity","Delivery Date","Price","Sort Order"]
[null,"Apples",5,"2022-09-05",2500,{"$f":"RAND()","v":0.62157678333405819},null,null,null,null,null,"Apples",5,"2022-09-05",2500]
[null,"Butter ",6,"2022-08-10",600,{"$f":"RAND()","v":0.2291421294942102},null,null,null,null,null,"Butter ",6,"2022-08-10",600]
[null,"Cauliflower",81,"2022-12-15",1200,0.25280288048978194,null,null,null,null,null,"Cauliflower",81,"2022-12-15",1200]
[null,"Cheese",9,"2022-05-12",3500,0.97048478750095113,null,null,null,null,null,"Cheese",9,"2022-05-12",3500]
[null,"Eggplant",10,"2022-10-06",150,0.71041882694631964,null,null,null,null,null,"Eggplant",10,"2022-10-06",150]
[null,"Grapes ",25,"2022-12-08",4000,6.9356341991286929E-2,null,null,null,null,null,"Grapes ",25,"2022-12-08",4000]
[null,"Mango",15,"2022-01-09",2700,{"$f":"RAND()","v":0.80545408997891588},null,null,null,null,null,"Mango",15,"2022-01-09",2700]
[null,"Milk",8,"2022-09-11",5000,0.35133346929536224,null,null,null,null,null,"Milk",8,"2022-09-11",5000]
[null,"Orange",10,"2022-09-13",2600,8.4070629349671799E-3,null,null,null,null,null,"Orange",10,"2022-09-13",2600]
[null,"Pineapple",20,"2022-09-16",2200,0.89719246040860345,null,null,null,null,null,"Pineapple",20,"2022-09-16",2200]
[]
[null,"After Sorting"]
[]
[null,"Name","Quantity","Delivery Date","Price","Sort Order"]
[null,{"$f":"_xlfn._xlws.SORT(B5:F14,5)","v":"Orange"},10,"2022-09-13",2600,8.4070629349671799E-3]
[null,"Grapes ",25,"2022-12-08",4000,6.9356341991286929E-2]
[null,"Butter ",6,"2022-08-10",600,0.2291421294942102]
[null,"Cauliflower",81,"2022-12-15",1200,0.25280288048978194]
[null,"Milk",8,"2022-09-11",5000,0.35133346929536224]
[null,"Apples",5,"2022-09-05",2500,0.62157678333405819]
[null,"Eggplant",10,"2022-10-06",150,0.71041882694631964]
[null,"Mango",15,"2022-01-09",2700,0.80545408997891588]
[null,"Pineapple",20,"2022-09-16",2200,0.89719246040860345]
[null,"Cheese",9,"2022-05-12",3500,0.97048478750095113]

{"sheet":"M4","index":3,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,5],[1,9,1,13]]}
[]
[null,"Inserting SORTBY, RANDARRAY & ROWS Functions",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Quantity","Delivery Date","Price","Sort Order",null,null,null,"Name","Quantity","Delivery Date","Price","Sort Order"]
[null,"Apples",5,"2022-09-05",2500,{"$f":"RAND()","v":0.61456082401848156},null,null,null,"Apples",5,"2022-09-05",2500]
[null,"Butter ",6,"2022-08-10",600,{"$f":"RAND()","v":8.2140474692292464E-2},null,null,null,"Butter ",6,"2022-08-10",600]
[null,"Cauliflower",81,"2022-12-15",1200,0.19337859446187566,null,null,null,"Cauliflower",81,"2022-12-15",1200]
[null,"Cheese",9,"2022-05-12",3500,0.11294234538573578,null,null,null,"Cheese",9,"2022-05-12",3500]
[null,"Eggplant",10,"2022-10-06",150,0.43531537232567685,null,null,null,"Eggplant",10,"2022-10-06",150]
[null,"Grapes ",25,"2022-12-08",4000,0.86966765247487399,null,null,null,"Grapes ",25,"2022-12-08",4000]
[null,"Mango",15,"2022-01-09",2700,{"$f":"RAND()","v":0.27204461134229641},null,null,null,"Mango",15,"2022-01-09",2700]
[null,"Milk",8,"2022-09-11",5000,0.42956831896874681,null,null,null,"Milk",8,"2022-09-11",5000]
[null,"Orange",10,"2022-09-13",2600,0.52249716356927212,null,null,null,"Orange",10,"2022-09-13",2600]
[null,"Pineapple",20,"2022-09-16",2200,7.8572417847337706E-2,null,null,null,"Pineapple",20,"2022-09-16",2200]
[]
[null,"After Sorting"]
[]
[null,"Name","Quantity","Delivery Date","Price","Sort Order"]
[null,{"$f":"_xlfn.SORTBY(B5:F14,_xlfn.RANDARRAY(ROWS(B5:B14)))","v":"Cauliflower"},81,"2022-12-15",1200,0.19337859446187566]
[null,"Pineapple",20,"2022-09-16",2200,7.8572417847337706E-2]
[null,"Grapes ",25,"2022-12-08",4000,0.86966765247487399]
[null,"Eggplant",10,"2022-10-06",150,0.43531537232567685]
[null,"Butter ",6,"2022-08-10",600,8.2140474692292464E-2]
[null,"Cheese",9,"2022-05-12",3500,0.11294234538573578]
[null,"Orange",10,"2022-09-13",2600,0.52249716356927212]
[null,"Apples",5,"2022-09-05",2500,0.61456082401848156]
[null,"Milk",8,"2022-09-11",5000,0.42956831896874681]
[null,"Mango",15,"2022-01-09",2700,0.27204461134229641]

{"sheet":"M5","index":4,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,5],[1,9,1,13]]}
[]
[null,"Utilizing SORTBY, RANDARRAY & COUNTA Functions",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Quantity","Delivery Date","Price","Sort Order",null,null,null,"Name","Quantity","Delivery Date","Price","Sort Order"]
[null,"Apples",5,"2022-09-05",2500,{"$f":"RAND()","v":0.91043240288587679},null,null,null,"Apples",5,"2022-09-05",2500]
[null,"Butter ",6,"2022-08-10",600,{"$f":"RAND()","v":0.44873380071327307},null,null,null,"Butter ",6,"2022-08-10",600]
[null,"Cauliflower",81,"2022-12-15",1200,0.86851052172342558,null,null,null,"Cauliflower",81,"2022-12-15",1200]
[null,"Cheese",9,"2022-05-12",3500,0.12823479386444292,null,null,null,"Cheese",9,"2022-05-12",3500]
[null,"Eggplant",10,"2022-10-06",150,0.17272509205503228,null,null,null,"Eggplant",10,"2022-10-06",150]
[null,"Grapes ",25,"2022-12-08",4000,0.29959296476606834,null,null,null,"Grapes ",25,"2022-12-08",4000]
[null,"Mango",15,"2022-01-09",2700,{"$f":"RAND()","v":0.94475009645264418},null,null,null,"Mango",15,"2022-01-09",2700]
[null,"Milk",8,"2022-09-11",5000,0.860064389084507,null,null,null,"Milk",8,"2022-09-11",5000]
[null,"Orange",10,"2022-09-13",2600,0.19083325130478934,null,null,null,"Orange",10,"2022-09-13",2600]
[null,"Pineapple",20,"2022-09-16",2200,0.8918791012669629,null,null,null,"Pineapple",20,"2022-09-16",2200]
[]
[null,"After Sorting"]
[]
[null,"Name","Quantity","Delivery Date","Price","Sort Order"]
[null,{"$f":"_xlfn.SORTBY(B5:F14,_xlfn.RANDARRAY(COUNTA(B5:B14)))","v":"Orange"},10,"2022-09-13",2600,0.19083325130478934]
[null,"Grapes ",25,"2022-12-08",4000,0.29959296476606834]
[null,"Butter ",6,"2022-08-10",600,0.44873380071327307]
[null,"Cauliflower",81,"2022-12-15",1200,0.86851052172342558]
[null,"Cheese",9,"2022-05-12",3500,0.12823479386444292]
[null,"Mango",15,"2022-01-09",2700,0.94475009645264418]
[null,"Milk",8,"2022-09-11",5000,0.860064389084507]
[null,"Apples",5,"2022-09-05",2500,0.91043240288587679]
[null,"Pineapple",20,"2022-09-16",2200,0.8918791012669629]
[null,"Eggplant",10,"2022-10-06",150,0.17272509205503228]

{"sheet":"M6","index":5,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Using VBA",null,null,null,null,null,"Try Yourself"]
[null," ",null,null,null,null,null," "]
[null,"Name","Rand Value",null,null,null,null,"Name","Rand Value"]
[null,"Milk",16,null,null,null,null,"Milk"]
[null,"Cheese",32,null,null,null,null,"Cheese"]
[null,"Butter ",33,null,null,null,null,"Butter "]
[null,"Eggplant",36,null,null,null,null,"Eggplant"]
[null,"Mango",50,null,null,null,null,"Mango"]
[null,"Grapes ",69,null,null,null,null,"Grapes "]
[null,"Cauliflower",76,null,null,null,null,"Cauliflower"]
[null,"Orange",77,null,null,null,null,"Orange"]
[null,"Apples",83,null,null,null,null,"Apples"]
[null,"Pineapple",88,null,null,null,null,"Pineapple"]