{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Title","Goal","CouldNotSolve","DoNotLike","Method1","WhyNotThis","Method2","Wrap Up"],"not_rendered":{"charts":0,"images":12,"macros":0,"external_links":0,"defined_names":12,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2155]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: carufrannco / Pixabay"]

{"sheet":"Goal","index":1,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Goal is to create fake product data, separated by ;",null,null,null,null,null,null,2097,null,null,null,null,null,2035]
["Anywhere from 2 to 12 products in one cell"]
["Apple;Banana;Dill;Eggplant;Fig;Guava;Jicama;Kale;Mango;Radish"]
["Banana;Cherry;Dill;Eggplant;Fig;Guava;Kale;Lettuce;Mango;Radish"]
["Apple;Cherry;Dill;Fig;Guava;Jicama;Kale;Mango"]
["Apple;Banana;Dill;Guava;Kale;Lettuce;Mango;Radish"]
["Apple;Banana;Cherry;Dill;Jicama;Lettuce;Radish"]
["Apple;Banana;Cherry;Dill;Guava;Kale;Radish",null,null,null,null,null,null,1961]
["Apple;Cherry;Eggplant;Fig;Jicama;Kale;Lettuce;Mango;Radish"]
["Banana;Dill;Fig;Guava;Jicama;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,null,null,null,2138]
["Apple;Banana;Cherry;Dill;Eggplant;Fig;Guava;Jicama;Kale;Mango"]
["Apple;Cherry;Fig;Jicama;Kale;Lettuce;Mango"]
["Banana;Dill;Eggplant;Guava;Jicama;Kale;Lettuce;Mango;Radish"]
["Apple;Cherry;Dill;Fig;Jicama;Kale;Lettuce;Mango;Radish"]
["Apple;Banana;Fig;Kale;Lettuce;Mango;Radish"]
["Apple;Cherry;Dill;Jicama;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,1978]
["Apple;Eggplant;Fig;Jicama;Lettuce;Mango"]
["Apple;Banana;Dill;Eggplant;Fig;Kale;Lettuce;Mango"]
["Apple;Jicama;Kale;Radish"]
["Apple;Dill;Eggplant;Jicama;Kale;Mango"]
["Apple;Cherry;Dill;Eggplant;Fig;Jicama;Lettuce;Mango"]
["Banana;Dill;Eggplant;Guava;Kale;Lettuce;Radish"]
["Apple;Fig;Guava;Lettuce;Radish"]

{"sheet":"CouldNotSolve","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["=TEXTJOIN(\";\",TRUE,IF({RAND()<0.6;RAND()<0.6;RAND()<0.6;RAND()<0.6;RAND()<0.6;RAND()<0.6;RAND()<0.6;RAND()<0.6;RAND()<0.6;RAND()<0.6;RAND()<0.6;RAND()<0.6;},{\"Apple\";\"Banana\";\"Cherry\";\"Date\";\"Elderberry\";\"Fig\";\"Guava\";\"Honeydew\";\"Iceberg\";\"Jackfruit\";\"Kiwi\";\"Lime\"},\"\"))"]

{"sheet":"DoNotLike","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Apple"]
["Banana",null,null,null,{"$f":"INDEX($A$1:$A$12,RANDBETWEEN(1,12))","v":"Honeydew"},{"$f":"_xlfn.FORMULATEXT(E2)","v":"=INDEX($A$1:$A$12,RANDBETWEEN(1,12))"}]
["Cherry",null,null,null,{"$f":"INDEX($A$1:$A$12,RANDBETWEEN(1,12))","v":"Iceberg"}]
["Date",null,null,null,"Cherry"]
["Elderberry",null,null,null,"Date"]
["Fig",null,null,null,"Fig"]
["Guava",null,null,null,"Honeydew"]
["Honeydew",null,null,null,"Guava"]
["Iceberg",null,null,null,"Kiwi"]
["Jackfruit",null,null,null,"Iceberg"]
["Kiwi",null,null,null,"Lime"]
["Lime",null,null,null,"Apple"]
[]
[null,null,null,null,{"$f":"RANDBETWEEN(2,7)","v":3},{"$f":"_xlfn.FORMULATEXT(E14)","v":"=RANDBETWEEN(2,7)"}]
[null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\";\",TRUE,E2:INDEX(E2:E12,E14))","v":"Honeydew;Iceberg;Cherry"}]
[null,null,null,null,{"$f":"_xlfn.FORMULATEXT(E15)","v":"=TEXTJOIN(\";\",TRUE,E2:INDEX(E2:E12,E14))"}]

{"sheet":"Method1","index":4,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Apple",{"$f":"IF(RAND()<0.6,A1,\"\")","v":""},null,null,null,null,null,"Goal is to create fake data like this:"]
["Banana",{"$f":"IF(RAND()<0.6,A2,\"\")","v":""},null,null,null,null,null,"Banana;Cherry;Eggplant;Fig;Mango"]
["Cherry","",null,null,null,null,null,"Cherry;Dill;Eggplant;Guava;Lettuce;Mango"]
["Date","Date",null,null,null,null,null,"Apple;Banana;Dill;Eggplant;Fig;Guava;Jicama;Kale;Mango;Radish"]
["Elderberry","Elderberry",null,null,null,null,null,"Banana;Cherry;Dill;Eggplant;Fig;Guava;Kale;Lettuce;Mango;Radish"]
["Fig","Fig",null,null,null,null,null,"Apple;Cherry;Dill;Fig;Guava;Jicama;Kale;Mango"]
["Guava","Guava",null,null,null,null,null,"Apple;Banana;Dill;Guava;Kale;Lettuce;Mango;Radish"]
["Honeydew","",null,null,null,null,null,"Apple;Banana;Cherry;Dill;Jicama;Lettuce;Radish"]
["Iceberg","Iceberg"]
["Jackfruit","Jackfruit"]
["Kiwi","Kiwi"]
["Lime","Lime"]
[]
[null,null,{"$f":"_xlfn.TEXTJOIN(\";\",TRUE,B1:B12)","v":"Date;Elderberry;Fig;Guava;Iceberg;Jackfruit;Kiwi;Lime"}]
[null,null,"Cherry;Date;Elderberry;Fig;Guava;Iceberg;Jackfruit;Kiwi"]
[null,null,"Apple;Cherry;Fig;Guava;Jackfruit;Kiwi;Lime"]
[null,null,"Apple;Banana;Date;Fig;Iceberg;Jackfruit"]
[null,null,"Banana;Date;Elderberry;Lime"]
[null,null,"Banana;Date;Fig;Guava;Honeydew;Iceberg;Jackfruit;Kiwi"]
[null,null,"Apple;Banana;Cherry;Date;Elderberry;Guava;Honeydew;Iceberg;Jackfruit;Kiwi"]
[null,null,"Banana;Date;Elderberry;Fig;Honeydew;Iceberg;Jackfruit;Lime"]
[null,null,"Apple;Cherry;Fig;Guava;Honeydew"]
[null,null,"Cherry;Date;Elderberry;Fig;Guava;Honeydew;Jackfruit;Lime"]
[null,null,"Apple;Banana;Cherry;Date;Iceberg;Kiwi;Lime"]
[null,null,"Apple;Banana;Date;Fig;Guava;Iceberg;Jackfruit;Kiwi;Lime"]
[null,null,"Apple;Date;Fig;Guava;Iceberg;Kiwi;Lime"]
[null,null,"Cherry;Date;Elderberry;Fig;Guava;Honeydew;Iceberg;Jackfruit"]
[null,null,"Apple;Cherry;Elderberry;Fig;Guava;Honeydew;Kiwi;Lime"]
[null,null,"Cherry;Elderberry;Guava;Honeydew;Iceberg;Jackfruit;Lime"]
[null,null,"Apple;Banana;Cherry;Date;Elderberry;Honeydew;Jackfruit"]
[null,null,"Banana;Cherry;Guava;Iceberg;Jackfruit;Kiwi"]
[null,null,"Cherry;Date;Fig;Guava;Iceberg;Kiwi;Lime"]
[null,null,"Apple;Banana;Cherry;Date;Honeydew;Jackfruit;Kiwi"]
[null,null,"Apple;Cherry;Elderberry;Fig;Guava;Honeydew;Jackfruit;Kiwi;Lime"]
[null,null,"Apple;Cherry;Date;Elderberry;Guava;Kiwi;Lime"]
[null,null,"Banana;Cherry;Date;Fig;Guava;Iceberg"]
[null,null,"Apple;Banana;Cherry;Fig;Iceberg"]
[null,null,"Banana;Cherry;Elderberry;Fig"]

{"sheet":"WhyNotThis","index":5,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Apple",{"$f":"IF(RAND()<0.6,A1,\"\")","v":"Apple"}]
["Banana","Banana"]
["Cherry","Cherry"]
["Dill","Dill"]
["Eggplant","Eggplant"]
["Fig",""]
["Guava","Guava"]
["Jicama",""]
["Kale","Kale"]
["Lettuce",""]
["Mango",""]
["Radish","Radish"]
[]
[null,null,{"$f":"_xlfn.TEXTJOIN(\";\",TRUE,$B$1:$B$12)","v":"Apple;Banana;Cherry;Dill;Eggplant;Guava;Kale;Radish"}]
[null,null,{"$f":"_xlfn.TEXTJOIN(\";\",TRUE,$B$1:$B$12)","v":"Apple;Banana;Cherry;Dill;Eggplant;Guava;Kale;Radish"}]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Guava;Kale;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Guava;Kale;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Guava;Kale;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Guava;Kale;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Guava;Kale;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Guava;Kale;Radish"]

{"sheet":"Method2","index":6,"n_rows":146,"n_cols":13,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
["Apple",{"$f":"IF(RAND()<0.6,A1,\"\")","v":""}]
["Banana","Banana"]
["Cherry",""]
["Dill","Dill"]
["Eggplant",""]
["Fig",""]
["Guava","Guava"]
["Jicama",""]
["Kale",""]
["Lettuce","Lettuce"]
["Mango","Mango"]
["Radish",""]
[]
[null,null,{"$f":"_xlfn.TEXTJOIN(\";\",TRUE,B1:B12)","v":"Banana;Dill;Guava;Lettuce;Mango"}]
[null,null,"Banana;Cherry;Dill;Fig;Guava;Jicama;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Fig;Guava;Jicama"]
[null,null,"Cherry;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Banana;Fig;Guava;Jicama;Kale;Mango"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Fig;Guava;Jicama;Kale"]
[null,null,"Banana;Cherry;Eggplant;Fig;Kale;Mango",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Eggplant;Fig;Kale;Lettuce"]
[null,null,"Apple;Banana;Cherry;Fig;Guava;Jicama;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Dill;Fig;Guava;Kale;Mango"]
[null,null,"Guava;Kale;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Fig;Guava;Jicama;Kale;Mango"]
[null,null,"Apple;Dill;Guava;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Eggplant;Mango;Radish"]
[null,null,"Apple;Banana;Dill;Fig;Guava;Jicama;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Fig;Guava;Jicama;Lettuce;Radish"]
[null,null,"Apple;Dill;Fig;Guava;Jicama;Kale;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Eggplant;Guava;Kale;Mango"]
[null,null,"Apple;Banana;Eggplant;Fig;Jicama;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Dill;Guava;Jicama;Kale;Mango;Radish"]
[null,null,"Banana;Cherry;Dill;Fig;Kale;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Guava;Lettuce"]
[null,null,"Apple;Cherry;Dill;Eggplant;Fig;Guava;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Dill;Eggplant;Mango;Radish"]
[null,null,"Dill;Eggplant;Fig;Jicama;Kale",null,null,null,null,null,null,null,null,null,"Dill;Eggplant;Fig;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Cherry;Dill;Fig;Guava;Jicama;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Banana;Dill;Jicama;Lettuce"]
[null,null,"Apple;Banana;Cherry;Eggplant;Guava;Kale;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Dill;Eggplant;Guava;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Cherry;Eggplant;Fig;Jicama;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Fig;Guava;Jicama;Kale;Mango"]
[null,null,"Banana;Dill;Eggplant;Guava;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Eggplant;Guava;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Cherry;Eggplant;Guava;Jicama;Lettuce",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Fig;Guava;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Cherry;Dill;Eggplant;Fig;Guava;Jicama;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Eggplant;Fig;Kale"]
[null,null,"Apple;Cherry;Eggplant;Fig;Jicama;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Banana;Guava;Kale;Lettuce;Mango"]
[null,null,"Apple;Banana;Cherry;Eggplant;Fig;Jicama;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Fig;Jicama;Lettuce;Mango;Radish"]
[null,null,"Apple;Cherry;Dill;Jicama;Kale;Mango",null,null,null,null,null,null,null,null,null,"Dill;Fig;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Cherry;Fig;Jicama;Mango",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Fig;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Eggplant;Fig;Guava;Jicama;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Cherry;Dill;Fig;Jicama;Kale;Lettuce;Mango"]
[null,null,"Cherry;Dill;Eggplant;Fig;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Fig;Jicama;Mango"]
[null,null,"Apple;Banana;Cherry;Fig;Radish",null,null,null,null,null,null,null,null,null,"Eggplant;Fig;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Cherry;Eggplant;Guava;Jicama;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Dill;Eggplant;Fig;Radish"]
[null,null,"Apple;Banana;Cherry;Eggplant;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Cherry;Eggplant;Fig;Guava;Lettuce;Mango;Radish"]
[null,null,"Eggplant;Lettuce",null,null,null,null,null,null,null,null,null,"Banana;Dill;Eggplant;Fig;Guava;Jicama;Lettuce;Mango;Radish"]
[null,null,"Banana;Cherry;Dill;Eggplant;Fig;Guava;Jicama;Kale;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Fig;Guava;Jicama;Radish"]
[null,null,"Apple;Eggplant;Fig;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Fig;Jicama;Kale;Mango;Radish"]
[null,null,"Banana;Cherry;Fig;Jicama;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Eggplant;Fig;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Banana;Eggplant;Fig;Guava;Jicama;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Cherry;Fig;Guava;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Cherry;Guava;Jicama;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Cherry;Dill;Eggplant;Guava;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Eggplant;Guava;Jicama;Kale;Mango",null,null,null,null,null,null,null,null,null,"Eggplant;Guava;Kale;Radish"]
[null,null,"Apple;Dill;Guava;Kale;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Guava;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Dill;Eggplant;Guava;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Eggplant;Fig;Jicama;Kale;Lettuce;Mango"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Fig;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Eggplant;Fig;Guava;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Cherry;Fig;Guava;Jicama;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Banana;Eggplant;Fig;Guava;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Fig;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Fig;Jicama;Kale;Mango;Radish"]
[null,null,"Apple;Cherry;Dill;Eggplant;Fig;Guava;Jicama;Kale;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Dill;Eggplant;Fig;Jicama;Kale;Lettuce;Mango"]
[null,null,"Banana;Dill;Guava;Kale",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Fig;Jicama"]
[null,null,"Apple;Banana;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Fig;Guava;Jicama;Kale;Radish"]
[null,null,"Banana;Cherry;Dill;Eggplant;Fig;Guava;Jicama;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Guava;Kale;Lettuce"]
[null,null,"Apple;Banana;Cherry;Eggplant;Fig;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Dill;Jicama;Kale;Lettuce"]
[null,null,"Banana;Cherry;Dill;Eggplant;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Dill;Guava;Jicama;Kale;Lettuce;Radish"]
[null,null,"Apple;Cherry;Dill;Fig;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Eggplant;Fig;Guava;Jicama;Kale;Mango;Radish"]
[null,null,"Apple;Dill;Jicama;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Dill;Fig;Jicama;Lettuce;Radish"]
[null,null,"Apple;Cherry;Dill;Eggplant;Guava;Jicama;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Fig;Guava;Lettuce;Mango"]
[null,null,"Apple;Dill;Eggplant;Fig;Kale;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Eggplant;Guava;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Fig;Guava;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Fig;Jicama;Kale;Mango"]
[null,null,"Apple;Cherry;Eggplant;Fig;Guava;Jicama;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Eggplant;Fig;Guava;Jicama;Kale;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Eggplant;Fig;Guava;Jicama;Kale;Lettuce;Mango"]
[null,null,"Cherry;Eggplant;Fig;Guava;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Fig;Guava;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Banana;Eggplant;Jicama;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Banana;Dill;Eggplant;Guava;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Fig;Guava;Jicama;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Dill;Eggplant;Fig;Guava;Jicama;Mango;Radish"]
[null,null,"Dill;Eggplant;Fig;Guava;Jicama;Kale;Mango;Radish",null,null,null,null,null,null,null,null,null,"Dill;Kale;Lettuce;Mango"]
[null,null,"Apple;Cherry;Dill;Eggplant;Fig;Guava;Jicama;Kale;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Guava;Jicama;Kale;Lettuce"]
[null,null,"Banana;Dill;Guava;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Lettuce;Mango;Radish"]
[null,null,"Apple;Cherry;Dill;Guava;Jicama;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Eggplant;Fig;Jicama;Kale;Lettuce;Mango"]
[null,null,"Apple;Banana;Cherry;Eggplant;Guava;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Fig;Jicama;Kale;Mango;Radish"]
[null,null,"Banana;Cherry;Dill;Jicama;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Guava;Kale;Lettuce"]
[null,null,"Apple;Cherry;Dill;Eggplant;Fig;Guava;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Fig;Kale"]
[null,null,"Cherry;Dill;Eggplant;Fig;Guava;Jicama;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Dill;Eggplant;Jicama;Kale;Mango;Radish"]
[null,null,"Apple;Cherry;Dill;Eggplant;Fig;Jicama;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Fig;Kale;Mango;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Kale;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Dill;Eggplant;Jicama;Kale;Lettuce"]
[null,null,"Apple;Dill;Jicama;Kale;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Fig;Guava;Jicama;Kale;Mango"]
[null,null,"Apple;Dill;Guava;Jicama",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Dill;Eggplant;Fig;Guava;Kale;Mango;Radish"]
[null,null,"Cherry;Fig;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Banana;Fig;Guava;Kale;Mango;Radish"]
[null,null,"Apple;Banana;Dill;Eggplant;Guava;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Fig;Guava;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Fig;Guava;Jicama;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Eggplant;Fig;Lettuce;Radish"]
[null,null,"Banana;Dill;Fig;Guava;Jicama;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Guava;Mango"]
[null,null,"Cherry;Dill;Guava;Jicama;Kale;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Fig;Jicama;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Fig;Jicama;Kale",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Fig;Guava;Jicama;Kale;Radish"]
[null,null,"Dill;Jicama;Kale;Lettuce",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Fig;Guava;Jicama;Kale;Mango"]
[null,null,"Apple;Banana;Cherry;Dill;Fig;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Dill;Eggplant;Fig;Guava;Kale;Mango"]
[null,null,"Banana;Dill;Guava;Jicama;Kale;Mango",null,null,null,null,null,null,null,null,null,"Apple;Banana;Dill;Fig;Guava;Radish"]
[null,null,"Apple;Banana;Cherry;Eggplant;Guava;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Eggplant;Fig;Guava;Mango"]
[null,null,"Cherry;Eggplant;Guava;Kale;Mango",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Eggplant;Guava;Jicama;Kale"]
[null,null,"Apple;Cherry;Dill;Eggplant;Fig;Guava;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Fig;Guava;Jicama;Radish"]
[null,null,"Banana;Cherry;Dill;Eggplant;Guava;Jicama;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Dill;Fig;Guava;Radish"]
[null,null,"Banana;Cherry;Eggplant;Fig;Guava;Jicama;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Banana;Dill;Eggplant;Fig;Jicama;Radish"]
[null,null,"Banana;Cherry;Dill;Eggplant;Fig;Jicama;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Dill;Eggplant;Guava;Kale;Lettuce;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Guava;Jicama;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Jicama;Kale"]
[null,null,"Apple;Banana;Cherry;Eggplant;Guava;Kale;Radish",null,null,null,null,null,null,null,null,null,"Eggplant;Fig;Guava;Jicama;Lettuce"]
[null,null,"Apple;Dill;Eggplant;Jicama;Lettuce",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Fig;Guava;Jicama;Lettuce;Mango;Radish"]
[null,null,"Banana;Cherry;Dill;Fig;Guava;Jicama",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Eggplant;Guava;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Eggplant;Fig;Guava;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Fig;Jicama;Lettuce;Mango;Radish"]
[null,null,"Banana;Cherry;Eggplant;Fig;Guava;Jicama;Mango",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Eggplant;Fig;Jicama;Mango;Radish"]
[null,null,"Apple;Banana;Dill;Fig;Guava;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Fig;Jicama;Mango"]
[null,null,"Banana;Eggplant;Guava;Jicama;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Fig;Guava;Jicama;Lettuce;Mango;Radish"]
[null,null,"Apple;Cherry;Eggplant;Fig;Guava;Jicama;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Cherry;Eggplant"]
[null,null,"Banana;Fig;Guava;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Jicama;Kale;Lettuce;Radish"]
[null,null,"Cherry;Eggplant;Fig;Guava;Jicama;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Dill;Guava;Kale"]
[null,null,"Apple;Banana;Cherry;Dill;Eggplant;Fig;Jicama;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Cherry;Eggplant;Guava;Kale;Mango;Radish"]
[null,null,"Banana;Fig;Guava;Jicama;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Dill;Eggplant;Fig;Jicama;Kale;Lettuce;Radish"]
[null,null,"Banana;Cherry;Dill;Eggplant;Fig;Guava;Jicama;Kale;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Eggplant;Fig;Guava;Jicama;Mango;Radish"]
[null,null,"Cherry;Eggplant;Fig;Guava;Jicama;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Fig;Guava;Mango;Radish"]
[null,null,"Dill;Eggplant;Guava;Jicama;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Banana;Dill;Fig;Guava;Kale;Mango;Radish"]
[null,null,"Banana;Cherry;Dill;Fig;Guava;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Fig;Guava;Kale;Mango;Radish"]
[null,null,"Apple;Banana;Cherry;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Eggplant;Guava;Jicama;Kale;Mango;Radish"]
[null,null,"Cherry;Fig;Guava;Jicama;Kale",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Eggplant;Fig;Guava;Jicama;Lettuce;Mango;Radish"]
[null,null,"Apple;Cherry;Dill;Eggplant;Fig;Lettuce",null,null,null,null,null,null,null,null,null,"Cherry;Dill;Eggplant;Jicama;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Eggplant;Fig;Guava;Mango",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Fig;Guava;Mango;Radish"]
[null,null,"Apple;Banana;Dill;Fig;Guava;Jicama;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Cherry;Fig;Guava;Kale;Lettuce;Mango"]
[null,null,"Banana;Fig;Guava;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Fig;Mango"]
[null,null,"Apple;Banana;Cherry;Guava;Jicama;Kale;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Eggplant;Fig;Guava;Radish"]
[null,null,"Dill;Eggplant;Fig;Guava;Kale;Lettuce",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Eggplant;Guava;Lettuce;Radish"]
[null,null,"Apple;Banana;Eggplant;Fig;Jicama;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Eggplant;Fig;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Dill;Fig;Guava",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Radish"]
[null,null,"Apple;Banana;Cherry;Fig;Kale;Lettuce",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Eggplant;Jicama;Kale;Mango;Radish"]
[null,null,"Apple;Banana;Guava;Kale;Radish",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Guava;Kale;Lettuce"]
[null,null,"Eggplant;Guava;Jicama",null,null,null,null,null,null,null,null,null,"Banana;Dill;Eggplant;Fig;Guava;Jicama;Lettuce;Mango"]
[null,null,"Apple;Eggplant;Fig;Kale;Lettuce",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Fig;Jicama;Kale;Radish"]
[null,null,"Apple;Dill;Eggplant;Fig;Guava;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Dill;Eggplant;Guava;Jicama;Lettuce"]
[null,null,"Apple;Cherry;Dill;Eggplant;Guava;Jicama;Kale",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Dill;Eggplant;Fig;Jicama;Kale;Lettuce"]
[null,null,"Banana;Dill;Eggplant;Guava;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Cherry;Fig;Jicama;Kale;Lettuce;Radish"]
[null,null,"Apple;Banana;Eggplant;Guava;Mango;Radish",null,null,null,null,null,null,null,null,null,"Apple;Dill;Fig;Jicama;Kale;Lettuce;Radish"]
[null,null,"Dill;Jicama;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Banana;Cherry;Eggplant;Guava;Lettuce;Mango;Radish"]
[null,null,"Apple;Banana;Eggplant;Fig;Guava;Kale;Mango",null,null,null,null,null,null,null,null,null,"Apple;Dill;Eggplant;Jicama;Radish"]
[null,null,"Banana;Cherry;Eggplant;Fig;Guava;Kale;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Eggplant;Guava;Jicama;Lettuce;Mango"]
[null,null,"Banana;Dill;Kale;Radish",null,null,null,null,null,null,null,null,null,"Apple;Cherry;Dill;Eggplant;Fig;Guava;Jicama;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Cherry;Dill;Eggplant;Guava;Jicama;Kale;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Cherry;Dill;Guava;Kale;Lettuce"]
[null,null,"Cherry;Dill;Mango",null,null,null,null,null,null,null,null,null,"Banana;Dill;Eggplant;Fig;Jicama;Kale;Mango;Radish"]
[null,null,"Cherry;Dill;Fig;Jicama;Kale;Lettuce;Radish",null,null,null,null,null,null,null,null,null,"Apple;Eggplant;Fig;Jicama;Kale;Lettuce;Mango"]
[null,null,"Apple;Cherry;Dill;Eggplant;Guava;Mango",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Kale"]
[null,null,"Apple;Cherry;Eggplant;Fig;Jicama;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Fig;Kale;Mango;Radish"]
[null,null,"Apple;Banana;Cherry;Dill;Fig;Jicama;Kale;Mango",null,null,null,null,null,null,null,null,null,"Apple;Banana;Cherry;Eggplant;Kale"]
[null,null,"Cherry;Eggplant;Fig;Guava;Lettuce;Mango;Radish",null,null,null,null,null,null,null,null,null,"Banana;Dill;Kale;Lettuce;Mango"]
[null,null,"Banana;Cherry;Guava;Jicama;Kale;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Apple;Fig;Guava;Jicama;Kale;Lettuce;Mango"]
[null,null,"Banana;Dill;Eggplant;Fig;Kale;Radish",null,null,null,null,null,null,null,null,null,"Cherry;Dill;Fig;Guava;Kale;Lettuce;Mango;Radish"]
[null,null,"Apple;Cherry;Dill;Fig;Jicama;Lettuce;Mango",null,null,null,null,null,null,null,null,null,"Cherry;Dill;Eggplant;Fig;Guava;Lettuce;Radish"]

{"sheet":"Wrap Up","index":7,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Goal is to create sample data with product;product;product;product"]
[null,"Goal is to always have 2 or more products, up to a max of 12"]
[null,"Store a list of products in a custom list so you can easily generate a column of single products"]
[null,"Using RANDBETWEEN() might return duplicate items in the list"]
[null,"Use RAND() function to decide if this product is included or not"]
[null,"Use TEXTJOIN() to concatenate the non-blanks with semi-colons in between"]
[null,"Now that you have one result, how do you make many results"]
[null,"Surprising that one Copy and multiple Paste Values will paste the current result of the formula"]
[null,"Speed the Paste Values by using F4 to Re do"]
[null,"But - a super fast way: Use What-If Tools and a Data Table with an empty cell as the Column Input Cell"]
[null,"Thanks to Professor Simon Benninga for this method"]