{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","Approach 1","Approach 2","Approach 3","Approach 4","Approach 5","Approach 6","Approach 7","Approach 8","Auto Generate","Without Duplicates"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Dataset","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"List of Famous Brands"]
[]
[null,"Brand","Search Volume"]
[null,"Pizza Hut"]
[null,"KFC"]
[null,"McDonald's"]
[null,"Pepsi"]
[null,"Maggi"]
[null,"Subway"]
[null,"Starbucks"]
[null,"Buffalo Wild Wings"]
[null,"Taco Bell"]
[null,"Burger King"]

{"sheet":"Approach 1","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"List of Famous Brands"]
[]
[null,"Brand","Search Volume"]
[null,"Pizza Hut",{"$f":"RANDBETWEEN(1,100)","v":33}]
[null,"KFC",16]
[null,"McDonald's",84]
[null,"Pepsi",21]
[null,"Maggi",20]
[null,"Subway",85]
[null,"Starbucks",47]
[null,"Buffalo Wild Wings",42]
[null,"Taco Bell",69]
[null,"Burger King",23]

{"sheet":"Approach 2","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"List of Famous Brands"]
[]
[null,"Brand","Search Volume"]
[null,"Pizza Hut",{"$f":"ROUND(RAND()*(19+1),0)","v":4}]
[null,"KFC",8]
[null,"McDonald's",5]
[null,"Pepsi",1]
[null,"Maggi",17]
[null,"Subway",17]
[null,"Starbucks",14]
[null,"Buffalo Wild Wings",19]
[null,"Taco Bell",17]
[null,"Burger King",16]

{"sheet":"Approach 3","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"List of Famous Brands"]
[]
[null,"Brand","Search Volume","Position"]
[null,"Pizza Hut",0.11177840941950246,{"$f":"_xlfn.RANK.EQ(C6,$C$6:$C$15)","v":9}]
[null,"KFC",0.52329461099410302,4]
[null,"McDonald's",0.90027059457915826,2]
[null,"Pepsi",0.97062836796768892,1]
[null,"Maggi",0.56023155160497184,3]
[null,"Subway",1.113884485102179E-2,10]
[null,"Starbucks",0.13230713083430212,7]
[null,"Buffalo Wild Wings",0.12786848741768275,8]
[null,"Taco Bell",0.45566380664040518,5]
[null,"Burger King",0.22526811911688394,6]

{"sheet":"Approach 4","index":4,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"List of Famous Brands"]
[]
[null,"Brand","Search Volume"]
[null,"Pizza Hut",{"$f":"_xlfn.RANDARRAY(1,1,5,30,TRUE)","v":20}]
[null,"KFC",{"$f":"_xlfn.RANDARRAY(1,1,5,30,TRUE)","v":25}]
[null,"McDonald's",{"$f":"_xlfn.RANDARRAY(1,1,5,30,TRUE)","v":18}]
[null,"Pepsi",{"$f":"_xlfn.RANDARRAY(1,1,5,30,TRUE)","v":12}]
[null,"Maggi",{"$f":"_xlfn.RANDARRAY(1,1,5,30,TRUE)","v":20}]
[null,"Subway",{"$f":"_xlfn.RANDARRAY(1,1,5,30,TRUE)","v":8}]
[null,"Starbucks",{"$f":"_xlfn.RANDARRAY(1,1,5,30,TRUE)","v":6}]
[null,"Buffalo Wild Wings",{"$f":"_xlfn.RANDARRAY(1,1,5,30,TRUE)","v":23}]
[null,"Taco Bell",{"$f":"_xlfn.RANDARRAY(1,1,5,30,TRUE)","v":28}]
[null,"Burger King",{"$f":"_xlfn.RANDARRAY(1,1,5,30,TRUE)","v":19}]

{"sheet":"Approach 5","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"List of Famous Brands"]
[]
[null,"Brand Serial","Brand",null,"Arbitrary"]
[null,1,"Pizza Hut",null,{"$f":"VLOOKUP(RANDBETWEEN(1,10),Famous_Brands,2)","v":"McDonald's"}]
[null,2,"KFC",null,"Pepsi"]
[null,3,"McDonald's",null,"Subway"]
[null,4,"Pepsi",null,"Starbucks"]
[null,5,"Maggi",null,"Taco Bell"]
[null,6,"Subway",null,"Maggi"]
[null,7,"Starbucks",null,"Taco Bell"]
[null,8,"Buffalo Wild Wings",null,"Maggi"]
[null,9,"Taco Bell",null,"Taco Bell"]
[null,10,"Burger King",null,"Buffalo Wild Wings"]

{"sheet":"Approach 6","index":6,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"List of Famous Brands"]
[]
[null,"Brand","Search Volume","Position"]
[null,"Pizza Hut",13,{"$f":"_xlfn.RANK.EQ(C6,$C$6:$C$15)+COUNTIF($C$6:C6,C6)-1","v":6}]
[null,"KFC",16,{"$f":"_xlfn.RANK.EQ(C7,$C$6:$C$15)+COUNTIF($C$6:C7,C7)-1","v":3}]
[null,"McDonald's",15,{"$f":"_xlfn.RANK.EQ(C8,$C$6:$C$15)+COUNTIF($C$6:C8,C8)-1","v":4}]
[null,"Pepsi",2,{"$f":"_xlfn.RANK.EQ(C9,$C$6:$C$15)+COUNTIF($C$6:C9,C9)-1","v":10}]
[null,"Maggi",14,{"$f":"_xlfn.RANK.EQ(C10,$C$6:$C$15)+COUNTIF($C$6:C10,C10)-1","v":5}]
[null,"Subway",13,{"$f":"_xlfn.RANK.EQ(C11,$C$6:$C$15)+COUNTIF($C$6:C11,C11)-1","v":7}]
[null,"Starbucks",20,{"$f":"_xlfn.RANK.EQ(C12,$C$6:$C$15)+COUNTIF($C$6:C12,C12)-1","v":1}]
[null,"Buffalo Wild Wings",6,{"$f":"_xlfn.RANK.EQ(C13,$C$6:$C$15)+COUNTIF($C$6:C13,C13)-1","v":9}]
[null,"Taco Bell",17,{"$f":"_xlfn.RANK.EQ(C14,$C$6:$C$15)+COUNTIF($C$6:C14,C14)-1","v":2}]
[null,"Burger King",11,{"$f":"_xlfn.RANK.EQ(C15,$C$6:$C$15)+COUNTIF($C$6:C15,C15)-1","v":8}]

{"sheet":"Approach 7","index":7,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"List of Famous Brands"]
[]
[null,"Brand","Search Volume"]
[null,"Pizza Hut",4.02417065950499]
[null,"KFC",19.374248481704154]
[null,"McDonald's",9.6494644001586973]
[null,"Pepsi",6.5819269386883148]
[null,"Maggi",12.80816064943388]
[null,"Subway",26.665181432538837]
[null,"Starbucks",5.1738334299752795]
[null,"Buffalo Wild Wings",18.856501968443862]
[null,"Taco Bell",29.344187749870297]
[null,"Burger King",15.287148655659657]

{"sheet":"Approach 8","index":8,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"List of Famous Brands"]
[]
[null,"Brand","Search Volume"]
[null,"Pizza Hut",57]
[null,"KFC",55]
[null,"McDonald's",56]
[null,"Pepsi",53]
[null,"Maggi",53]
[null,"Subway",58]
[null,"Starbucks",50]
[null,"Buffalo Wild Wings",58]
[null,"Taco Bell",58]
[null,"Burger King",57]

{"sheet":"Auto Generate","index":9,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"List of Famous Brands"]
[]
[null,"Brand","Search Volume"]
[null,"Pizza Hut",1]
[null,"KFC",2]
[null,"McDonald's",3]
[null,"Pepsi",4]
[null,"Maggi",5]
[null,"Subway",6]
[null,"Starbucks",7]
[null,"Buffalo Wild Wings",8]
[null,"Taco Bell",9]
[null,"Burger King",10]

{"sheet":"Without Duplicates","index":10,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Generate Random Numbers Without Duplicates"]
[]
[null,"Brand","Serial"]
[null,"Pizza Hut",22]
[null,"KFC",17]
[null,"McDonald's",18]
[null,"Pepsi",9]
[null,"Maggi",10]
[null,"Subway",24]
[null,"Starbucks",1]
[null,"Buffalo Wild Wings",23]
[null,"Taco Bell",25]
[null,"Burger King",2]