{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Mapping"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":31,"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":"Mapping","index":0,"n_rows":264,"n_cols":100,"rows_kept":264,"cut":false,"hidden":false,"merged":[[4,1,4,5],[4,6,4,9],[88,12,88,17],[102,13,102,16],[73,4,73,8],[29,4,29,15],[31,4,31,15],[86,12,86,13],[30,4,30,15],[59,4,59,15],[60,4,60,15],[13,4,13,6],[5,6,5,9],[14,2,14,3],[15,2,15,3],[87,12,87,17],[38,14,38,19],[39,14,39,19],[40,14,40,19],[33,5,33,12],[50,7,50,9],[34,4,34,12],[35,4,35,12],[36,4,36,12],[37,4,37,12],[168,5,168,6],[165,3,165,15],[58,4,58,15],[51,10,51,12],[1,1,1,15],[2,1,2,15],[3,1,3,15],[13,7,13,15],[12,4,12,6],[8,2,8,3],[8,4,8,15],[12,7,12,15],[9,4,9,15],[13,2,13,3],[5,2,5,5],[37,14,37,19]]}
[]
[null,"Welcome to \"Create Your Own Multi-Dimensional Perceptual Map\""]
[null,"Follow the Steps in Yellow"]
[null,"Only enter data/information in the Blue cells"]
[null,"The Grey cells provide additional information  ",null,null,null,null,"Or you can watch the YouTube video at ",null,null,null,"How to Use Video"]
[null,null,"For more information on Perceptual Maps visit:",null,null,null," www.perceptualmaps.com",null,null,null,"Or email: geoff@perceptualmaps.com"]
[null,""]
[]
[null,"STEP ONE","Enter the Title of Your Map",null,"Soft Drinks Year One"]
[null,null,null,null,"(This is an example only. Simply type over this map title.)"]
[]
[]
[null,null,null,null,"STEP THREE >>>",null,null,"Enter Attribute Label Across >>> (from E16 to P16)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"+AI13","v":1},{"$f":"+AJ13","v":1},{"$f":"+AK13","v":1},1,1,1,1,1,{"$f":"+AQ13","v":1},1,2,{"$f":"+AT13","v":2},2,2,2,2,2,{"$f":"+AZ13","v":2},2,2,3,{"$f":"+BD13","v":3},3,3,3,3,3,3,{"$f":"+BK13","v":3},4,4,{"$f":"+BN13","v":4},4,4,4,4,{"$f":"+BS13","v":4},5,5,{"$f":"+BV13","v":5},5,5,5,5,6,{"$f":"+CB13","v":6},6,6,6,6,7,{"$f":"+CH13","v":7},7,7,7,8,{"$f":"+CM13","v":8},8,8,9,{"$f":"+CQ13","v":9},9,10,{"$f":"+CT13","v":10},11]
[null,"STEP TWO","Enter Brands Below",null,"You may enter up to 12 attributes",null,null,"Some examples provided, simply type over the top to enter your own attributes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"+AI14+1","v":3},{"$f":"+AJ14+1","v":4},{"$f":"+AK14+1","v":5},6,7,8,9,10,{"$f":"+AQ14+1","v":11},12,3,{"$f":"+AT14+1","v":4},5,6,7,8,9,{"$f":"+AZ14+1","v":10},11,12,4,{"$f":"+BD14+1","v":5},6,7,8,9,10,11,{"$f":"+BK14+1","v":12},5,6,{"$f":"+BN14+1","v":7},8,9,10,11,{"$f":"+BS14+1","v":12},6,7,{"$f":"+BV14+1","v":8},9,10,11,12,7,{"$f":"+CB14+1","v":8},9,10,11,12,8,{"$f":"+CH14+1","v":9},10,11,12,9,{"$f":"+CM14+1","v":10},11,12,10,{"$f":"+CQ14+1","v":11},12,11,{"$f":"+CT14+1","v":12},12]
[null,null,"You may enter up to 12 brands",null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,"Some examples provided, simply type over the top to enter your own brands",null,"Sweet","For Kids","High caffeine","Modern","Low in sugar","Trusted","Clear","Tangy","Adult","Bitter","Friendy","For diets"]
[null,null,1,"Coke",6,5,7,5,3,9,1,5,7,2,5,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IFERROR(IF(AND(HLOOKUP(AI$13,brand_data,$AH17)>0.5,HLOOKUP(AI$14,brand_data,$AH17)>0.5),SQRT(((HLOOKUP(AI$13,brand_data,$AH17)-HLOOKUP(AI$14,brand_data,$AH17)))^2),\"\"),\"\")","v":1},{"$f":"IFERROR(IF(AND(HLOOKUP(AJ$13,brand_data,$AH17)>0.5,HLOOKUP(AJ$14,brand_data,$AH17)>0.5),SQRT(((HLOOKUP(AJ$13,brand_data,$AH17)-HLOOKUP(AJ$14,brand_data,$AH17)))^2),\"\"),\"\")","v":1},1,3,3,5,1,1,4,1,{"$f":"IFERROR(IF(AND(HLOOKUP(AS$13,brand_data,$AH17)>0.5,HLOOKUP(AS$14,brand_data,$AH17)>0.5),SQRT(((HLOOKUP(AS$13,brand_data,$AH17)-HLOOKUP(AS$14,brand_data,$AH17)))^2),\"\"),\"\")","v":4},2,0,2,4,4,0,2,3,0,{"$f":"IFERROR(IF(AND(HLOOKUP(BC$13,brand_data,$AH17)>0.5,HLOOKUP(BC$14,brand_data,$AH17)>0.5),SQRT(((HLOOKUP(BC$13,brand_data,$AH17)-HLOOKUP(BC$14,brand_data,$AH17)))^2),\"\"),\"\")","v":3},2,4,2,6,2,0,5,2,5,{"$f":"IFERROR(IF(AND(HLOOKUP(BM$13,brand_data,$AH17)>0.5,HLOOKUP(BM$14,brand_data,$AH17)>0.5),SQRT(((HLOOKUP(BM$13,brand_data,$AH17)-HLOOKUP(BM$14,brand_data,$AH17)))^2),\"\"),\"\")","v":2},4,4,0,2,3,0,3,6,2,{"$f":"IFERROR(IF(AND(HLOOKUP(BW$13,brand_data,$AH17)>0.5,HLOOKUP(BW$14,brand_data,$AH17)>0.5),SQRT(((HLOOKUP(BW$13,brand_data,$AH17)-HLOOKUP(BW$14,brand_data,$AH17)))^2),\"\"),\"\")","v":2},4,1,2,1,8,4,2,7,4,{"$f":"IFERROR(IF(AND(HLOOKUP(CG$13,brand_data,$AH17)>0.5,HLOOKUP(CG$14,brand_data,$AH17)>0.5),SQRT(((HLOOKUP(CG$13,brand_data,$AH17)-HLOOKUP(CG$14,brand_data,$AH17)))^2),\"\"),\"\")","v":7},4,6,1,4,1,2,3,0,3,{"$f":"IFERROR(IF(AND(HLOOKUP(CQ$13,brand_data,$AH17)>0.5,HLOOKUP(CQ$14,brand_data,$AH17)>0.5),SQRT(((HLOOKUP(CQ$13,brand_data,$AH17)-HLOOKUP(CQ$14,brand_data,$AH17)))^2),\"\"),\"\")","v":5},2,5,3,0,3]
[null,null,2,"Pepsi",9,6,7,7,1,7,1,5,6,1,6,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH17+1","v":3},3,2,2,8,2,8,4,3,8,3,8,1,1,5,1,5,1,0,5,0,5,0,6,0,6,2,1,6,1,6,6,0,6,2,1,6,1,6,6,0,4,5,0,5,0,6,2,1,6,1,6,4,5,0,5,0,1,4,1,4,5,0,5,5,0,5]
[null,null,3,"Fanta",8,9,2,3,1,5,4,7,2,1,6,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH18+1","v":4},1,6,5,7,3,4,1,6,7,2,7,7,6,8,4,5,2,7,8,3,8,1,1,3,2,5,0,1,4,1,2,2,1,4,1,2,3,2,4,3,6,1,0,5,0,1,2,3,4,1,4,3,2,3,2,3,5,6,1,6,1,4,1,5,0,5]
[null,null,4,"Sprite",4,4,1,6,6,5,7,8,5,2,6,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,3,2,2,1,3,4,1,2,2,1,3,2,2,1,3,4,1,2,2,1,5,5,4,6,7,4,1,5,2,0,1,1,2,1,4,0,3,1,1,2,1,4,0,3,2,3,0,3,1,2,1,2,5,1,4,3,6,2,5,3,1,2,4,1,3]
[null,null,5,"Pepsi Max",3,2,9,6,7,3,2,5,6,7,2,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1,6,3,4,0,1,2,3,4,1,4,7,4,5,1,0,3,4,5,0,5,3,2,6,7,4,3,2,7,2,1,3,4,1,0,1,4,1,4,5,2,1,0,5,0,1,2,3,4,1,4,3,4,5,0,5,1,2,3,2,1,4,1,5,0,5]
[null,null,6,"Coke Zero",5,4,7,8,9,5,2,4,6,5,2,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1,2,3,4,0,3,1,1,0,3,2,3,4,5,1,2,0,2,1,2,3,1,2,2,5,3,1,2,5,0,1,3,6,4,2,3,6,1,4,7,5,3,4,7,2,3,1,1,0,3,2,2,4,3,0,5,2,1,2,3,1,4,1,3,2,5]
[null,null,7,"Water",2,5,1,2,9,9,9,3,5,4,3,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,3,1,0,7,7,7,1,3,2,1,7,4,3,4,4,4,2,0,1,2,4,1,8,8,8,2,4,3,2,8,7,7,7,1,3,2,1,7,0,0,6,4,5,6,0,0,6,4,5,6,0,6,4,5,6,0,2,1,0,6,1,2,4,1,5,6]
[null,null,8,"Mt Dew",8,4,6,3,4,5,6,9,6,3,4,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,4,2,5,4,3,2,1,2,5,4,5,2,1,0,1,2,5,2,1,0,1,3,2,1,0,3,0,3,2,3,1,2,3,6,3,0,1,0,1,2,5,2,1,0,1,1,4,1,2,1,2,3,0,3,2,3,3,6,5,6,3,2,3,1,0,1]
[null,null,9,"Dr Pepper",2,1,5,4,3,4,3,6,8,9,2,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,1,3,2,1,2,1,4,6,7,0,2,4,3,2,3,2,5,7,8,1,3,1,2,1,2,1,3,4,3,1,1,0,1,2,4,5,2,0,1,0,3,5,6,1,1,1,2,4,5,2,0,3,5,6,1,1,2,3,4,2,1,6,4,7,5,2]
[null,null,10,"Diet Coke",3,2,7,4,2,7,3,5,8,7,9,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,1,4,1,1,4,0,2,5,4,6,5,5,2,0,5,1,3,6,5,7,6,3,5,0,4,2,1,0,2,1,2,3,1,1,4,3,5,4,5,1,3,6,5,7,6,4,2,1,0,2,1,2,5,4,6,5,3,2,4,3,1,1,0,2,1,1]
[null,null,11,"Pepsi Next",6,6,8,8,6,5,3,6,4,5,6,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0,2,2,0,1,3,0,2,1,0,2,2,2,0,1,3,0,2,1,0,2,0,2,3,5,2,4,3,2,4,2,3,5,2,4,3,2,4,1,3,0,2,1,0,2,2,1,1,0,1,1,3,1,2,3,1,2,1,0,2,1,2,0,1,1,2]
[null,null,12,"Lift",8,6,2,6,3,4,6,9,2,3,5,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,2,6,2,5,4,2,1,6,5,3,6,4,0,3,2,0,3,4,3,1,4,4,1,2,4,7,0,1,3,0,3,2,0,3,4,3,1,4,1,3,6,1,0,2,1,2,5,2,1,1,2,3,4,3,1,4,7,6,4,7,1,3,0,2,1,3]
[]
[null,null,null,"STEP FOUR","Enter the attribute score (using a 1-9 scale) for each brand in the above table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AI17:AI28),\"\")","v":1.5},{"$f":"IFERROR(AVERAGE(AJ17:AJ28),\"\")","v":3.1666666666666665},2.3333333333333335,3.8333333333333335,2.5,3.25,1.8333333333333333,3.25,4.083333333333333,2.1666666666666665,4.416666666666667,3.6666666666666665,2.3333333333333335,3,2.3333333333333335,2.5833333333333335,2.3333333333333335,3.0833333333333335,3.5833333333333335,1.5,3.75,2,3.3333333333333335,2.6666666666666665,4.583333333333333,3.3333333333333335,1.75,2.5833333333333335,3.1666666666666665,2.75,2.3333333333333335,2.5,3.25,2.3333333333333335,2.4166666666666665,2.9166666666666665,2.1666666666666665,2.9166666666666665,2.8333333333333335,2.25,3.6666666666666665,2.9166666666666665,2.25,3.3333333333333335,1.4166666666666667,2.5833333333333335,2.8333333333333335,1.9166666666666667,3.0833333333333335,2,2.5833333333333335,3.0833333333333335,3.5,3.3333333333333335,2.5833333333333335,2.6666666666666665,2.75,3.4166666666666665,2.1666666666666665,4.083333333333333,2,2.5833333333333335,2.1666666666666665,3.25,1.3333333333333333,{"$f":"IFERROR(AVERAGE(CV17:CV28),\"\")","v":3.4166666666666665}]
[null,null,null,null,"The higher the number = the greater association that the brand has with that attribute"]
[null,null,null,null,"For example,  1 = no association with the attribute, 5 = some association and 9 = very high association",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"+AI32","v":1},{"$f":"+AJ32","v":1},{"$f":"+AK32","v":1},1,1,1,1,1,1,1,2,{"$f":"+AT32","v":2},2,2,2,2,2,2,2,2,3,{"$f":"+BD32","v":3},3,3,3,3,3,3,3,4,{"$f":"+BM32","v":4},4,4,4,4,4,4,5,{"$f":"+BU32","v":5},5,5,5,5,5,6,{"$f":"+CB32","v":6},6,6,6,6,7,{"$f":"+CH32","v":7},7,7,7,8,{"$f":"+CM32","v":8},8,8,9,{"$f":"+CQ32","v":9},9,10,{"$f":"+CT32","v":10},11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"+AI33+1","v":3},{"$f":"+AJ33+1","v":4},{"$f":"+AK33+1","v":5},6,7,8,9,10,11,12,3,{"$f":"+AT33+1","v":4},5,6,7,8,9,10,11,12,4,{"$f":"+BD33+1","v":5},6,7,8,9,10,11,12,5,{"$f":"+BM33+1","v":6},7,8,9,10,11,12,6,{"$f":"+BU33+1","v":7},8,9,10,11,12,7,{"$f":"+CB33+1","v":8},9,10,11,12,8,{"$f":"+CH33+1","v":9},10,11,12,9,{"$f":"+CM33+1","v":10},11,12,10,{"$f":"+CQ33+1","v":11},12,11,{"$f":"+CT33+1","v":12},12]
[null,null,null,null,null,"Important Note for Apple Mac users"]
[null,null,null,"STEP FIVE","Ensure that your spreadsheet has the 'Solver add-in' loaded"]
[null,null,null,null,"In the top menu of Excel click \"File\" then select \"Options\" and then select \"Add-Ins\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IFERROR(SQRT(((HLOOKUP(AI$13,reverse_data,$AH36)-HLOOKUP(AI$14,reverse_data,$AH36)))^2),\"\")","v":3},2,2,3,1,4,2,4,3,0,{"$f":"IFERROR(SQRT(((HLOOKUP(AS$13,reverse_data,$AH36)-HLOOKUP(AS$14,reverse_data,$AH36)))^2),\"\")","v":2},1,5,6,4,7,1,7,6,3,{"$f":"IFERROR(SQRT(((HLOOKUP(BC$13,reverse_data,$AH36)-HLOOKUP(BC$14,reverse_data,$AH36)))^2),\"\")","v":1},4,5,3,6,0,6,5,2,0,{"$f":"IFERROR(SQRT(((HLOOKUP(BM$13,reverse_data,$AH36)-HLOOKUP(BM$14,reverse_data,$AH36)))^2),\"\")","v":1},1,2,4,2,1,2,4,2,1,{"$f":"IFERROR(SQRT(((HLOOKUP(BW$13,reverse_data,$AH36)-HLOOKUP(BW$14,reverse_data,$AH36)))^2),\"\")","v":5},1,0,3,5,3,3,3,2,1,{"$f":"IFERROR(SQRT(((HLOOKUP(CG$13,reverse_data,$AH36)-HLOOKUP(CG$14,reverse_data,$AH36)))^2),\"\")","v":3},6,0,1,4,6,6,5,2,0,{"$f":"IFERROR(SQRT(((HLOOKUP(CQ$13,reverse_data,$AH36)-HLOOKUP(CQ$14,reverse_data,$AH36)))^2),\"\")","v":1},4,6,3,5,2]
[null,null,null,null,"Then click 'Go' next to 'Manage Excel Add-ins' and select the 'Solver Add-in' (as shown below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH36+1","v":3},1,4,1,3,1,0,1,4,3,1,1,3,2,4,2,1,2,5,4,0,0,5,7,5,4,5,8,7,3,3,2,0,1,0,3,2,2,2,2,3,2,1,0,4,4,1,0,3,2,2,2,1,4,3,1,1,3,2,2,2,1,5,5,4,4,0]
[null,"STEP SIX",null,"Follow the sequence as shown","Please note that these options are standard with every version of Excel, including the student version",null,null,null,null,null,null,null,null,null,"ATTENTION APPLE MAC USERS!!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH37+1","v":4},0,5,6,2,0,6,1,2,0,1,5,5,6,2,0,6,1,2,0,1,5,1,7,5,1,4,3,5,6,0,8,6,0,5,4,6,7,1,2,8,3,4,2,1,7,6,1,2,0,1,5,5,4,6,7,1,1,1,2,4,2,3,3,1,5,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not follow the instructions in Step Five",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,2,2,1,1,3,3,2,1,1,3,1,4,1,1,1,5,4,3,3,1,1,3,3,5,1,0,1,1,5,3,0,2,4,3,2,2,2,0,2,4,3,2,2,2,0,6,5,4,4,0,2,1,2,2,6,4,1,1,5,3,0,4,2,4,2,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instead, select 'Tools', then 'Add-ins' and then 'Solver'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,2,2,3,4,6,6,1,0,1,3,0,0,5,6,8,8,3,2,1,5,2,5,6,8,8,3,2,1,5,2,1,3,3,2,3,4,0,3,2,2,3,4,5,1,4,0,5,6,7,3,6,5,6,7,3,6,1,2,2,1,1,3,0,4,1,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You will also need to follow Step Six below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,2,4,4,6,4,0,4,5,2,4,5,2,2,4,2,2,2,3,0,2,3,0,2,0,4,0,1,2,0,1,2,0,4,0,1,2,0,1,2,6,2,1,4,2,1,4,0,1,2,0,1,4,5,2,4,5,1,2,0,1,3,1,0,2,3,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,3,6,1,1,8,5,2,2,2,5,3,6,1,1,8,5,2,2,2,5,3,2,2,5,2,1,1,1,2,5,5,2,1,4,4,4,1,0,7,4,1,1,1,4,7,4,1,1,1,4,3,6,6,6,3,3,3,3,0,0,0,3,0,3,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,2,3,0,1,2,4,1,0,1,4,2,3,0,1,2,4,1,0,1,4,1,2,3,4,2,1,2,1,2,3,4,5,1,2,3,2,1,1,2,4,1,0,1,4,1,5,2,1,2,5,6,3,2,3,6,3,4,3,0,1,0,3,1,4,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,1,5,2,1,1,2,1,1,1,3,5,4,1,0,0,1,0,2,2,2,4,3,4,4,3,4,6,6,2,0,1,1,0,1,3,3,1,3,0,1,0,2,2,2,4,1,0,2,2,2,4,1,3,3,1,3,2,2,2,4,0,4,6,4,6,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,1,1,0,5,3,2,1,7,5,3,1,0,1,6,4,3,2,8,6,4,2,1,6,4,3,2,8,6,4,2,5,3,2,1,7,5,3,1,2,3,4,2,0,2,4,1,2,4,2,0,2,1,5,3,1,1,6,4,2,0,2,4,6,2,4,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,1,1,1,3,3,2,1,3,4,1,0,0,0,4,4,3,2,4,3,0,1,0,4,4,3,2,4,3,0,1,4,4,3,2,4,3,0,1,0,1,2,0,7,4,3,1,2,0,7,4,3,1,1,6,3,2,2,5,2,1,7,4,3,3,4,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,1,1,1,5,5,7,1,2,6,2,0,0,2,6,6,8,2,3,7,3,1,2,6,6,8,2,3,7,3,1,4,4,6,0,1,5,1,1,0,2,4,3,1,3,5,2,4,3,1,3,5,6,5,1,5,7,1,5,1,1,4,0,2,4,6,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(AI36:AI47),\"\")","v":1.1666666666666667},{"$f":"IFERROR(AVERAGE(AJ36:AJ47),\"\")","v":2.6666666666666665},2.5,2.8333333333333335,2.4166666666666665,3.5,2,2.6666666666666665,2.3333333333333335,2,2.4166666666666665,2,2.8333333333333335,3.3333333333333335,2.75,4.5,2.3333333333333335,3.5,2.8333333333333335,2,2.4166666666666665,2.3333333333333335,4.5,4.083333333333333,4.166666666666667,2.1666666666666665,3.6666666666666665,3.8333333333333335,2.6666666666666665,1.4166666666666667,3,2.75,2.6666666666666665,1.6666666666666667,3,3.3333333333333335,2,1.5833333333333333,1.25,3.3333333333333335,3,1.8333333333333333,2,2.1666666666666665,3.75,2.75,2.5833333333333335,2.5833333333333335,2.5833333333333335,1.5833333333333333,3.5,3.3333333333333335,3.6666666666666665,3.5,3.6666666666666665,3.75,2.5,3,2.1666666666666665,1.4166666666666667,1.8333333333333333,2.6666666666666665,3.25,2.6666666666666665,3.9166666666666665,{"$f":"IFERROR(AVERAGE(CV36:CV47),\"\")","v":2.25}]
[]
[null,null,null,null,null,null,null,"Part C: Select Go"]
[null,null,null,"Part A: Select Options",null,null,null,null,null,null,"Part D: Tick Solver Add-in",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH53","v":"Coke"},{"$f":"+AH54","v":"Pepsi"},{"$f":"+AH55","v":"Fanta"},{"$f":"+AH56","v":"Sprite"},{"$f":"+AH57","v":"Pepsi Max"},{"$f":"+AH58","v":"Coke Zero"},{"$f":"+AH59","v":"Water"},{"$f":"+AH60","v":"Mt Dew"},{"$f":"+AH61","v":"Dr Pepper"},{"$f":"+AH62","v":"Diet Coke"},{"$f":"+AH63","v":"Pepsi Next"},{"$f":"+AH64","v":"Lift"},{"$f":"+AH65","v":"Sweet"},{"$f":"+AH66","v":"For Kids"},{"$f":"+AH67","v":"High caffeine"},{"$f":"+AH68","v":"Modern"},{"$f":"+AH69","v":"Low in sugar"},{"$f":"+AH70","v":"Trusted"},{"$f":"+AH71","v":"Clear"},{"$f":"+AH72","v":"Tangy"},{"$f":"+AH73","v":"Adult"},{"$f":"+AH74","v":"Bitter"},{"$f":"+AH75","v":"Friendy"},{"$f":"+AH76","v":"For diets"}]
[null,null,null,null,"Part B: Select Add-ins",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,null,1,{"$f":"IF(D17=\"\",\"\",+D17)","v":"Coke"},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI54=\"\",0,+$AI54)","v":1.1666666666666667},{"$f":"IF($AI54=\"\",0,0)","v":0},null,{"$f":"+AG53+1","v":2},"Pepsi",{"$f":"+AI49","v":1.1666666666666667},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI55=\"\",0,0)","v":0},{"$f":"IF($AI55=\"\",0,+$AI55)","v":2.6666666666666665},null,{"$f":"+AG54+1","v":3},"Fanta",{"$f":"+AJ49","v":2.6666666666666665},{"$f":"+AT49","v":2},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI56=\"\",0,+$AI56)","v":2.5},{"$f":"IF($AI56=\"\",0,0)","v":0},null,4,"Sprite",{"$f":"+AK49","v":2.5},{"$f":"+AU49","v":2.8333333333333335},{"$f":"+BD49","v":2.3333333333333335},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI57=\"\",0,0)","v":0},{"$f":"IF($AI57=\"\",0,+$AI57)","v":2.8333333333333335},null,5,"Pepsi Max",{"$f":"+AL49","v":2.8333333333333335},{"$f":"+AV49","v":3.3333333333333335},{"$f":"+BE49","v":4.5},{"$f":"+BM49","v":3},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI58=\"\",0,+$AI58)","v":2.4166666666666665},{"$f":"IF($AI58=\"\",0,0)","v":0},null,6,"Coke Zero",{"$f":"+AM49","v":2.4166666666666665},{"$f":"+AW49","v":2.75},{"$f":"+BF49","v":4.083333333333333},{"$f":"+BN49","v":2.75},{"$f":"+BU49","v":1.25},0]
[null,null,null,"STEP SIX","IMPORTANT: Save the spreadsheet and exit Excel, then reopen the spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI59=\"\",0,0)","v":0},{"$f":"IF($AI59=\"\",0,+$AI59)","v":3.5},null,7,"Water",{"$f":"+AN49","v":3.5},{"$f":"+AX49","v":4.5},{"$f":"+BG49","v":4.166666666666667},{"$f":"+BO49","v":2.6666666666666665},{"$f":"+BV49","v":3.3333333333333335},{"$f":"+CB49","v":2.75},0]
[null,null,null,null,"Note: You need to save, exit and reopen Excel in order for the Solver Add-in to be loaded into the spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI60=\"\",0,+$AI60)","v":2},{"$f":"IF($AI60=\"\",0,0)","v":0},null,8,"Mt Dew",{"$f":"+AO49","v":2},{"$f":"+AY49","v":2.3333333333333335},{"$f":"+BH49","v":2.1666666666666665},{"$f":"+BP49","v":1.6666666666666667},{"$f":"+BW49","v":3},{"$f":"+CC49","v":2.5833333333333335},{"$f":"+CH49","v":3.3333333333333335},0]
[null,null,null,null,"Solver should then appear under Data in the top menu, as shown below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI61=\"\",0,0)","v":0},{"$f":"IF($AI61=\"\",0,+$AI61)","v":2.6666666666666665},null,9,"Dr Pepper",{"$f":"+AP49","v":2.6666666666666665},{"$f":"+AZ49","v":3.5},{"$f":"+BI49","v":3.6666666666666665},{"$f":"+BQ49","v":3},{"$f":"+BX49","v":1.8333333333333333},{"$f":"+CD49","v":2.5833333333333335},{"$f":"+CI49","v":3.6666666666666665},{"$f":"+CM49","v":2.5},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI62=\"\",0,+$AI62)","v":2.3333333333333335},{"$f":"IF($AI62=\"\",0,0)","v":0},null,10,"Diet Coke",{"$f":"+AQ49","v":2.3333333333333335},{"$f":"+BA49","v":2.8333333333333335},{"$f":"+BJ49","v":3.8333333333333335},{"$f":"+BR49","v":3.3333333333333335},{"$f":"+BY49","v":2},{"$f":"+CE49","v":2.5833333333333335},{"$f":"+CJ49","v":3.5},{"$f":"+CN49","v":3},{"$f":"+CQ49","v":1.8333333333333333},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI63=\"\",0,0)","v":0},{"$f":"IF($AI63=\"\",0,+$AI63)","v":2},null,11,"Pepsi Next",{"$f":"+AR49","v":2},{"$f":"+BB49","v":2},{"$f":"+BK49","v":2.6666666666666665},{"$f":"+BS49","v":2},{"$f":"+BZ49","v":2.1666666666666665},{"$f":"+CF49","v":1.5833333333333333},{"$f":"+CK49","v":3.6666666666666665},{"$f":"+CO49","v":2.1666666666666665},{"$f":"+CR49","v":2.6666666666666665},{"$f":"+CT49","v":2.6666666666666665},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI64=\"\",0,+$AI64)","v":2.4166666666666665},{"$f":"IF($AI64=\"\",0,0)","v":0},null,12,"Lift",{"$f":"+AS49","v":2.4166666666666665},{"$f":"+BC49","v":2.4166666666666665},{"$f":"+BL49","v":1.4166666666666667},{"$f":"+BT49","v":1.5833333333333333},{"$f":"+CA49","v":3.75},{"$f":"+CG49","v":3.5},{"$f":"+CL49","v":3.75},{"$f":"+CP49","v":1.4166666666666667},{"$f":"+CS49","v":3.25},{"$f":"+CU49","v":3.9166666666666665},{"$f":"+CV49","v":2.25},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI65=\"\",0,0)","v":0},{"$f":"IF($AI65=\"\",0,+$AI65)","v":2.1178359683794463},null,13,{"$f":"+IF(E16=\"\",\"\",E16)","v":"Sweet"},{"$f":"+AH253","v":2.1178359683794463},{"$f":"+AI253","v":0.5},1.039278656126482,3.1963932806324102,3.7356719367588926,2.6571146245059283,4.274950592885375,1.039278656126482,4.274950592885375,3.7356719367588926,2.1178359683794463,1.039278656126482,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI66=\"\",0,+$AI66)","v":2.6571146245059283},{"$f":"IF($AI66=\"\",0,0)","v":0},null,14,{"$f":"+IF(F16=\"\",\"\",F16)","v":"For Kids"},{"$f":"+AH254","v":2.6571146245059283},2.1178359683794463,0.5,3.1963932806324102,4.274950592885375,3.1963932806324102,2.6571146245059283,3.1963932806324102,4.8142292490118566,4.274950592885375,2.1178359683794463,2.1178359683794463,{"$f":"+AI30","v":1.5},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI67=\"\",0,0)","v":0},{"$f":"IF($AI67=\"\",0,+$AI67)","v":1.5785573122529641},null,15,{"$f":"+IF(G16=\"\",\"\",G16)","v":"High caffeine"},1.5785573122529641,1.5785573122529641,4.274950592885375,4.8142292490118566,0.5,1.5785573122529641,4.8142292490118566,2.1178359683794463,2.6571146245059283,1.5785573122529641,1.039278656126482,4.274950592885375,{"$f":"+AJ30","v":3.1666666666666665},{"$f":"+AT30","v":3.6666666666666665},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI68=\"\",0,+$AI68)","v":2.6571146245059283},{"$f":"IF($AI68=\"\",0,0)","v":0},null,16,{"$f":"+IF(H16=\"\",\"\",H16)","v":"Modern"},2.6571146245059283,1.5785573122529641,3.7356719367588926,2.1178359683794463,2.1178359683794463,1.039278656126482,4.274950592885375,3.7356719367588926,3.1963932806324102,3.1963932806324102,1.039278656126482,2.1178359683794463,{"$f":"+AK30","v":2.3333333333333335},{"$f":"+AU30","v":2.3333333333333335},{"$f":"+BD30","v":2},0]
[null,null,null,"STEP SEVEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI69=\"\",0,0)","v":0},{"$f":"IF($AI69=\"\",0,+$AI69)","v":3.7356719367588926},null,17,{"$f":"+IF(I16=\"\",\"\",I16)","v":"Low in sugar"},3.7356719367588926,4.8142292490118566,4.8142292490118566,2.1178359683794463,1.5785573122529641,0.5,0.5,3.1963932806324102,3.7356719367588926,4.274950592885375,2.1178359683794463,3.7356719367588926,{"$f":"+AL30","v":3.8333333333333335},{"$f":"+AV30","v":3},{"$f":"+BE30","v":3.3333333333333335},{"$f":"+BM30","v":2.3333333333333335},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI70=\"\",0,+$AI70)","v":0.5},{"$f":"IF($AI70=\"\",0,0)","v":0},null,18,{"$f":"+IF(J16=\"\",\"\",J16)","v":"Trusted"},0.5,1.5785573122529641,2.6571146245059283,2.6571146245059283,3.7356719367588926,2.6571146245059283,0.5,2.6571146245059283,3.1963932806324102,1.5785573122529641,2.6571146245059283,3.1963932806324102,{"$f":"+AM30","v":2.5},{"$f":"+AW30","v":2.3333333333333335},{"$f":"+BF30","v":2.6666666666666665},{"$f":"+BN30","v":2.5},{"$f":"+BU30","v":2.8333333333333335},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI71=\"\",0,0)","v":0},{"$f":"IF($AI71=\"\",0,+$AI71)","v":4.8142292490118566},null,19,{"$f":"+IF(K16=\"\",\"\",K16)","v":"Clear"},4.8142292490118566,4.8142292490118566,3.1963932806324102,1.5785573122529641,4.274950592885375,4.274950592885375,0.5,2.1178359683794463,3.7356719367588926,3.7356719367588926,3.7356719367588926,2.1178359683794463,{"$f":"+AN30","v":3.25},{"$f":"+AX30","v":2.5833333333333335},{"$f":"+BG30","v":4.583333333333333},{"$f":"+BO30","v":3.25},{"$f":"+BV30","v":2.25},{"$f":"+CB30","v":2.5833333333333335},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI72=\"\",0,+$AI72)","v":2.6571146245059283},{"$f":"IF($AI72=\"\",0,0)","v":0},null,20,{"$f":"+IF(L16=\"\",\"\",L16)","v":"Tangy"},2.6571146245059283,2.6571146245059283,1.5785573122529641,1.039278656126482,2.6571146245059283,3.1963932806324102,3.7356719367588926,0.5,2.1178359683794463,2.6571146245059283,2.1178359683794463,0.5,{"$f":"+AO30","v":1.8333333333333333},{"$f":"+AY30","v":2.3333333333333335},{"$f":"+BH30","v":3.3333333333333335},{"$f":"+BP30","v":2.3333333333333335},{"$f":"+BW30","v":3.6666666666666665},{"$f":"+CC30","v":2.8333333333333335},{"$f":"+CH30","v":3.0833333333333335},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI73=\"\",0,0)","v":0},{"$f":"IF($AI73=\"\",0,+$AI73)","v":1.5785573122529641},null,21,{"$f":"+IF(M16=\"\",\"\",M16)","v":"Adult"},1.5785573122529641,2.1178359683794463,4.274950592885375,2.6571146245059283,2.1178359683794463,2.1178359683794463,2.6571146245059283,2.1178359683794463,1.039278656126482,1.039278656126482,3.1963932806324102,4.274950592885375,{"$f":"+AP30","v":3.25},{"$f":"+AZ30","v":3.0833333333333335},{"$f":"+BI30","v":1.75},{"$f":"+BQ30","v":2.4166666666666665},{"$f":"+BX30","v":2.9166666666666665},{"$f":"+CD30","v":1.9166666666666667},{"$f":"+CI30","v":3.5},{"$f":"+CM30","v":2.75},0]
[null,null,null,null,"Note: It may take up to 15 seconds to calculate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI74=\"\",0,+$AI74)","v":4.274950592885375},{"$f":"IF($AI74=\"\",0,0)","v":0},null,22,{"$f":"+IF(N16=\"\",\"\",N16)","v":"Bitter"},4.274950592885375,4.8142292490118566,4.8142292490118566,4.274950592885375,1.5785573122529641,2.6571146245059283,3.1963932806324102,3.7356719367588926,0.5,1.5785573122529641,2.6571146245059283,3.7356719367588926,{"$f":"+AQ30","v":4.083333333333333},{"$f":"+BA30","v":3.5833333333333335},{"$f":"+BJ30","v":2.5833333333333335},{"$f":"+BR30","v":2.9166666666666665},{"$f":"+BY30","v":2.25},{"$f":"+CE30","v":3.0833333333333335},{"$f":"+CJ30","v":3.3333333333333335},{"$f":"+CN30","v":3.4166666666666665},{"$f":"+CQ30","v":2},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI75=\"\",0,0)","v":0},{"$f":"IF($AI75=\"\",0,+$AI75)","v":2.6571146245059283},null,23,{"$f":"+IF(O16=\"\",\"\",O16)","v":"Friendy"},2.6571146245059283,2.1178359683794463,2.1178359683794463,2.1178359683794463,4.274950592885375,4.274950592885375,3.7356719367588926,3.1963932806324102,4.274950592885375,0.5,2.1178359683794463,2.6571146245059283,{"$f":"+AR30","v":2.1666666666666665},{"$f":"+BB30","v":1.5},{"$f":"+BK30","v":3.1666666666666665},{"$f":"+BS30","v":2.1666666666666665},{"$f":"+BZ30","v":3.3333333333333335},{"$f":"+CF30","v":2},{"$f":"+CK30","v":2.5833333333333335},{"$f":"+CO30","v":2.1666666666666665},{"$f":"+CR30","v":2.5833333333333335},{"$f":"+CT30","v":3.25},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AI76=\"\",0,+$AI76)","v":4.274950592885375},{"$f":"IF($AI76=\"\",0,0)","v":0},null,24,{"$f":"+IF(P16=\"\",\"\",P16)","v":"For diets"},4.274950592885375,4.8142292490118566,4.8142292490118566,3.7356719367588926,1.5785573122529641,1.5785573122529641,0.5,3.7356719367588926,3.1963932806324102,1.039278656126482,3.1963932806324102,4.274950592885375,{"$f":"+AS30","v":4.416666666666667},{"$f":"+BC30","v":3.75},{"$f":"+BL30","v":2.75},{"$f":"+BT30","v":2.9166666666666665},{"$f":"+CA30","v":1.4166666666666667},{"$f":"+CG30","v":2.5833333333333335},{"$f":"+CL30","v":2.6666666666666665},{"$f":"+CP30","v":4.083333333333333},{"$f":"+CS30","v":2.1666666666666665},{"$f":"+CU30","v":1.3333333333333333},{"$f":"+CV30","v":3.4166666666666665},{"$f":"+BE250","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AI53:AI76)","v":60.003211462450587},{"$f":"SUM(AJ53:AJ76)","v":62.003211462450587},66.650774044795781,53.503211462450579,49.757987483530954,45.311594202898547,49.262763504611328,40.429430171277986,44.488883399209485,35.77231554677207,30.360424901185766,34.042490118577071,32.333333333333336,28.166666666666664,26.166666666666664,20.833333333333336,18.666666666666668,15.000000000000002,15.166666666666668,12.416666666666664,6.75,4.583333333333333,3.4166666666666665,{"$f":"SUM(BF53:BF76)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AF80","v":1},{"$f":"+AF81","v":1},{"$f":"+AF82","v":1},{"$f":"+AF83","v":1},{"$f":"+AF84","v":1},{"$f":"+AF85","v":1},{"$f":"+AF86","v":1},{"$f":"+AF87","v":1},{"$f":"+AF88","v":1},{"$f":"+AF89","v":1},{"$f":"+AF90","v":1},{"$f":"+AF91","v":1},{"$f":"+AF92","v":1},{"$f":"+AF93","v":1},{"$f":"+AF94","v":1},{"$f":"+AF95","v":1},{"$f":"+AF96","v":1},{"$f":"+AF97","v":1},{"$f":"+AF98","v":1},{"$f":"+AF99","v":1},{"$f":"+AF100","v":1},{"$f":"+AF101","v":1},{"$f":"+AF102","v":1},{"$f":"+AF103","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF($AF80=1,(AC80+$AD$107)*$AD$109,\"\")","v":3.9400356705127617},{"$f":"+IF($AF80=1,(AD80+$AD$107)*$AD$109,\"\")","v":3.9784199234132189},null,{"$f":"IF($AF80=1,AI80,\"\")","v":2.1188712479856906},{"$f":"IF($AF80=1,AJ80,\"\")","v":2.1492556284222939},null,{"$f":"IF(E17=\"\",0,1)","v":1},null,{"$f":"+AH53","v":"Coke"},2.1188712479856906,2.1492556284222939]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.0217541901695912,2.6358288570712927,null,1.3919738424534898,1.0864813226071051,null,1,null,{"$f":"+AH54","v":"Pepsi"},1.3919738424534898,1.0864813226071051,{"$f":"IFERROR(IF(OR($AF81=0,AK$79=0),\"\",SQRT(($AI$80-$AI81)^2+($AJ$80-$AJ81)^2)),\"\")","v":1.2875826432778601}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.587963079885653,2.1314761314105777,null,0.25700699356197004,0.68724351197537936,null,1,null,"Fanta",0.25700699356197004,0.68724351197537936,2.3672807037904025,{"$f":"IFERROR(IF(OR($AF82=0,AL$79=0),\"\",SQRT(($AI$81-$AI82)^2+($AJ$81-$AJ82)^2)),\"\")","v":1.203137804875551},null,null,null,null,"`"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.9841478529805094,2.2897878468978545,null,2.945374289554969,0.81256061540868441,null,1,null,"Sprite",2.945374289554969,0.81256061540868441,1.5715790898134023,1.5773666355312448,{"$f":"IFERROR(IF(OR($AF83=0,AM$79=0),\"\",SQRT(($AI$82-$AI83)^2+($AJ$82-$AJ83)^2)),\"\")","v":2.6912865129111805}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.1958880764242306,5.5367581610376488,null,4.6961536143559384,3.3828120554205823,null,1,null,"Pepsi Max",4.6961536143559384,3.3828120554205823,2.8572794498599201,4.023771713145889,5.1934682528458573,{"$f":"IFERROR(IF(OR($AF84=0,AN$79=0),\"\",SQRT(($AI$83-$AI84)^2+($AJ$83-$AJ84)^2)),\"\")","v":3.1098907873161354}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.5154372243430378,5.0857116610001372,null,4.1575192527164653,3.0257706278518581,null,1,null,"Coke Zero",4.1575192527164653,3.0257706278518581,2.2190908569542116,3.3777336226622854,4.5478242001537463,2.5234091960870115,{"$f":"IFERROR(IF(OR($AF85=0,AO$79=0),\"\",SQRT(($AI$84-$AI85)^2+($AJ$84-$AJ85)^2)),\"\")","v":0.64622407610601695}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4705334713868341,7.5156442857585057,null,0.95563605394767948,4.949267680079048,null,1,null,"Water",0.95563605394767948,4.949267680079048,3.0320263201482462,3.8873524549684841,4.3189040940399677,4.5903598535551993,4.0552749405862354,{"$f":"IFERROR(IF(OR($AF86=0,AP$79=0),\"\",SQRT(($AI$85-$AI86)^2+($AJ$85-$AJ86)^2)),\"\")","v":3.73522381236848}]
[null,null,null,null,null,null,null,null,null,null,null,null,"STEP EIGHT ",null,"Copy Your Map to Word or PP",null,null,null,null,null,null,null,null,null,null,4.21010104335934,2.7597826879148002,null,2.3326508167219582,1.184601256390645,null,1,null,"Mt Dew",2.3326508167219582,1.184601256390645,0.9880585820126454,0.94578046677046945,2.1343996829441418,0.71682933303737895,3.2277354587071549,2.5923058197473381,{"$f":"IFERROR(IF(OR($AF87=0,AQ$79=0),\"\",SQRT(($AI$86-$AI87)^2+($AJ$86-$AJ87)^2)),\"\")","v":4.0086011199101783}]
[null,null,null,null,null,null,null,null,null,null,null,null,"To maintain the formatting of the map ",null,null,null,null,null,null,null,null,null,null,null,null,5.9267424637206885,7.0058603589445463,null,3.691517592760448,4.5457306146853282,null,1,null,"Dr Pepper",3.691517592760448,4.5457306146853282,2.8664104530785215,4.1538304159317194,5.1656350798121329,3.8070051316510671,1.5367736044615052,1.5897911525280817,2.7654818671549988,{"$f":"IFERROR(IF(OR($AF88=0,AR$79=0),\"\",SQRT(($AI$87-$AI88)^2+($AJ$87-$AJ88)^2)),\"\")","v":3.6254254203074803}]
[null,null,null,null,null,null,null,null,null,null,null,null,"when you copy it:",null,null,null,null,null,null,null,null,null,null,null,null,4.2383550799143661,6.6516838894192833,null,2.3550162747076571,4.2653700037948017,null,1,null,"Diet Coke",2.3550162747076571,4.2653700037948017,2.1292497559712662,3.3215634833170471,4.1478466865632111,3.50291525136161,2.5019657422382791,2.1876068199218883,1.557556109384582,3.0808499295962286,{"$f":"IFERROR(IF(OR($AF89=0,AS$79=0),\"\",SQRT(($AI$88-$AI89)^2+($AJ$88-$AJ89)^2)),\"\")","v":1.3655906580288826}]
[null,null,null,null,null,null,null,null,null,null,null,null,1,"Click on the edge of the map",null,null,null,null,null,null,null,null,null,null,null,5.6526345132895219,3.6111421823723195,null,3.4745379821842848,1.8585242537978304,null,1,null,"Pepsi Next",3.4745379821842848,1.8585242537978304,1.3864909038301376,2.2210636379208575,3.4240917392659092,1.1722005572551792,1.9534067817385272,1.3523784653860866,3.9871746702614685,1.3259255277284137,2.6959521838118738,{"$f":"IFERROR(IF(OR($AF90=0,AT$79=0),\"\",SQRT(($AI$89-$AI90)^2+($AJ$89-$AJ90)^2)),\"\")","v":2.6544745841295727}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"to highlight it",null,null,null,null,null,null,null,null,null,null,null,3.5317873710851484,1.6065820187679669,null,1.7957082135357689,0.27174545737402339,null,1,null,"Lift",1.7957082135357689,0.27174545737402339,1.9051191010602426,0.90928321907439902,1.5938130623527869,1.2705168717925159,4.2533891075964192,3.628058161664621,4.7523610318676708,1.0590623536480919,4.6755793573923654,4.0325999708707068,{"$f":"IFERROR(IF(OR($AF91=0,AU$79=0),\"\",SQRT(($AI$90-$AI91)^2+($AJ$90-$AJ91)^2)),\"\")","v":2.3100511554683405}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.7223176182947171,2.1999886146443939,null,1.154944487210519,0.7414769331814981,null,{"$f":"IF(E17=\"\",0,1)","v":1},null,"Sweet",1.154944487210519,0.7414769331814981,1.7061640175881077,0.41858206360262773,0.89957379156773909,1.7918403296617034,4.4177837554764698,3.7727248648641014,4.2125083764007316,1.2583129040071357,4.5723680071746911,3.7226327603274321,2.574550193416461,{"$f":"IFERROR(IF(OR($AF92=0,AV$79=0),\"\",SQRT(($AI$91-$AI92)^2+($AJ$91-$AJ92)^2)),\"\")","v":0.79449720725656925}]
[null,null,null,null,null,null,null,null,null,null,null,null,2,"Select 'copy' from the above menu",null,null,null,null,null,null,null,null,null,null,null,1.4880861275723258,3.4206114164382129,null,0.17794594413092935,1.7077030487575113,null,{"$f":"IF(F17=\"\",0,1)","v":1},null,"For Kids",0.17794594413092935,1.7077030487575113,1.9905174492458795,1.3637375740760329,1.0235176186792003,2.9085975354177309,4.8187333123429692,4.1921719742236316,3.3335481346369549,2.2172930733542984,4.5165901070408552,3.3587639805689218,3.3000403181243998,2.1631294377733767,{"$f":"IFERROR(IF(OR($AF93=0,AW$79=0),\"\",SQRT(($AI$92-$AI93)^2+($AJ$92-$AJ93)^2)),\"\")","v":1.374088446789635}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0617826998407107,4.4946683136597345,null,4.5899978741029068,2.5579098630041885,null,{"$f":"IF(G17=\"\",0,1)","v":1},null,"High caffeine",4.5899978741029068,2.5579098630041885,2.5046886205169634,3.5202925526868194,4.7195553358046736,2.398130674282263,0.8317046760972564,0.63712750155692022,4.3505376735625507,2.6422702864137992,2.1814440530931329,2.8125722892085903,1.3165830778359764,3.6103465757074815,3.8857457919098501,{"$f":"IFERROR(IF(OR($AF94=0,AX$79=0),\"\",SQRT(($AI$93-$AI94)^2+($AJ$93-$AJ94)^2)),\"\")","v":4.4932231037152981}]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Go to your Word or P/Point document",null,null,null,null,null,null,null,null,null,null,null,6.2016536785098504,3.4500981801294275,null,3.9091330549684722,1.7310443144625267,null,{"$f":"IF(H17=\"\",0,1)","v":1},null,"Modern",3.9091330549684722,1.7310443144625267,1.8384607802901887,2.5983748674159122,3.7983608153619874,1.3313313874986155,1.8296824945788377,1.3183368043919712,4.3680780860738908,1.6685012026431651,2.8230861584538887,2.9728918019830042,0.45290618479021222,2.5682908158315443,2.9265676600523007,3.7312601183467393,{"$f":"IFERROR(IF(OR($AF95=0,AY$79=0),\"\",SQRT(($AI$94-$AI95)^2+($AJ$94-$AJ95)^2)),\"\")","v":1.0711132233802687}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.7374392166809782,6.2962438291166931,null,4.3332525934271171,3.9840091540043785,null,{"$f":"IF(I17=\"\",0,1)","v":1},null,"Low in sugar",4.3332525934271171,3.9840091540043785,2.8757269068315354,4.1287756326362377,5.2425606232911459,3.4618336209759986,0.70223578827681199,0.97421931824424446,3.5128361063284599,3.4407981699277248,0.85285098960497763,1.9981448547328871,2.2923954380882825,4.4966691265021748,4.5404468525814394,4.7379471118269434,1.4490263375593058,{"$f":"IFERROR(IF(OR($AF96=0,AZ$79=0),\"\",SQRT(($AI$95-$AI96)^2+($AJ$95-$AJ96)^2)),\"\")","v":2.2925374481378085}]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Select 'paste', then 'paste special'",null,null,null,null,null,null,null,null,null,null,null,2.9111873731577971,5.469494885618059,null,1.3044508615982173,3.3295674877834065,null,{"$f":"IF(J17=\"\",0,1)","v":1},null,"Trusted",1.3044508615982173,3.3295674877834065,1.4340211473726627,2.2447930453792657,2.8423607529334967,3.0046552700765718,3.3921206563221142,2.8691970612877631,1.6568344766327203,2.3786709065214819,2.679018538617715,1.4069164993684116,2.6216876829989251,3.0970323465358995,2.5924052296664906,1.9747044304540269,3.3749480975651158,3.056083386313917,{"$f":"IFERROR(IF(OR($AF97=0,BA$79=0),\"\",SQRT(($AI$96-$AI97)^2+($AJ$96-$AJ97)^2)),\"\")","v":3.0986987309539828}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"and choose 'picture'.",null,null,null,null,null,null,null,null,null,null,null,1.2632889777214806,6.428883806087252,null,0,4.0890049066070757,null,{"$f":"IF(K17=\"\",0,1)","v":1},null,"Clear",0,4.0890049066070757,2.872671688125676,3.3094922647667211,3.4114561672028478,4.4057141190615132,4.7489543178151603,4.2913207137463178,1.2858041480048126,3.7251604524025734,3.7196640318823788,2.3616109547603235,4.1288567584983618,4.2185350171497751,3.5411636931106032,2.3879412256649939,4.8386291981112306,4.5652272008689572,4.3345244429472816,{"$f":"IFERROR(IF(OR($AF98=0,BB$79=0),\"\",SQRT(($AI$97-$AI98)^2+($AJ$97-$AJ98)^2)),\"\")","v":1.509416192914959}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2957295233844182,2.2337317432813242,null,2.4004329960452679,0.76818747149221045,null,{"$f":"IF(L17=\"\",0,1)","v":1},null,"Tangy",2.4004329960452679,0.76818747149221045,1.4094773045553528,1.0574974421343044,2.1449538346322963,0.54674490328951242,3.4794532432868444,2.8607750385623807,4.4236715423425244,0.42189437551033671,3.99208362068739,3.4974774256339987,1.5305344883723695,0.782398067458556,1.2457748907793311,2.4129107351601387,2.8279498923960653,1.7897679089339054,3.7519729063172518,2.7860086910996888,{"$f":"IFERROR(IF(OR($AF99=0,BC$79=0),\"\",SQRT(($AI$98-$AI99)^2+($AJ$98-$AJ99)^2)),\"\")","v":4.0975489021933269}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.7454630648414389,6.0625055627204274,null,2.7564351059252883,3.7989855604178615,null,{"$f":"IF(M17=\"\",0,1)","v":1},null,"Adult",2.7564351059252883,3.7989855604178615,1.7686425646446835,3.0363520513366646,3.9912503635974872,2.9923956902929327,1.9838619604725896,1.6002806373672742,2.1368261933099957,2.6485087149034352,1.1966651299585647,0.6153466722751878,2.0690726964949691,3.6557378060086765,3.4515404108102525,3.3199501353284511,2.2140960484039542,2.3675078792797426,1.5876357009954294,1.5259788899882927,{"$f":"IFERROR(IF(OR($AF100=0,BC$79=0),\"\",SQRT(($AI$98-$AI100)^2+($AJ$98-$AJ100)^2)),\"\")","v":2.7716503593240933},{"$f":"IFERROR(IF(OR($AF100=0,BD$79=0),\"\",SQRT(($AI$99-$AI100)^2+($AJ$99-$AJ100)^2)),\"\")","v":3.0516347353630651}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.8289507346780445,7.7166278544193947,null,3.6141071737927906,5.1083631619563548,null,{"$f":"IF(N17=\"\",0,1)","v":1},null,"Bitter",3.6141071737927906,5.1083631619563548,3.3154257447335853,4.594933086774649,5.5512539646059889,4.3475422009897136,2.0367501370571222,2.1523216187707495,2.6632273780892781,4.1277158195115486,0.56793288002494813,1.5152383828514242,3.2528345313322102,5.1671506266938918,5.0117039471762528,4.8344279084223487,2.730782797859939,3.3901803592435207,1.3346692735575749,2.9152403555996251,{"$f":"IFERROR(IF(OR($AF101=0,BC$79=0),\"\",SQRT(($AI$98-$AI101)^2+($AJ$98-$AJ101)^2)),\"\")","v":3.7551114386139379},{"$f":"IFERROR(IF(OR($AF101=0,BD$79=0),\"\",SQRT(($AI$99-$AI101)^2+($AJ$99-$AJ101)^2)),\"\")","v":4.5066761625201153},{"$f":"IFERROR(IF(OR($AF101=0,BE$79=0),\"\",SQRT(($AI$100-$AI101)^2+($AJ$100-$AJ101)^2)),\"\")","v":1.5652702895700841}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9102532233495451,4.432774470147117,null,0.51212688231868797,2.5089156545498001,null,{"$f":"IF(O17=\"\",0,1)","v":1},null,"Friendy",0.51212688231868797,2.5089156545498001,1.6465062377642841,1.6725579517456826,1.8394497961811627,2.9661950987151098,4.2743156895411012,3.6818507027826914,2.4803262676155606,2.2512476587232264,3.7758628777373859,2.5458541186724477,3.0329669465358515,2.5792463094827758,1.8807057470404265,0.86811205447713957,4.0781653053912956,3.4849296633863225,4.095961734712259,1.1407220167643941,{"$f":"IFERROR(IF(OR($AF102=0,BC$79=0),\"\",SQRT(($AI$98-$AI102)^2+($AJ$98-$AJ102)^2)),\"\")","v":1.6610105321942965},{"$f":"IFERROR(IF(OR($AF102=0,BD$79=0),\"\",SQRT(($AI$99-$AI102)^2+($AJ$99-$AJ102)^2)),\"\")","v":2.5682356952639993},{"$f":"IFERROR(IF(OR($AF102=0,BE$79=0),\"\",SQRT(($AI$100-$AI102)^2+($AJ$100-$AJ102)^2)),\"\")","v":2.5886675654812539},{"$f":"IFERROR(IF(OR($AF102=0,BF$79=0),\"\",SQRT(($AI$101-$AI102)^2+($AJ$101-$AJ102)^2)),\"\")","v":4.0471482642047985}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.4927629854291204,7.9999999999999991,null,2.5564016346698843,5.3326761660100326,null,{"$f":"IF(P17=\"\",0,1)","v":1},null,"For diets",2.5564016346698843,5.3326761660100326,3.2133470336095704,4.402960677933379,5.1833637976440787,4.536820948311326,2.8949108076649228,2.8080937998585469,1.6460414671291814,4.1541051845549424,1.3812210319357294,1.0861392669035221,3.5934253661033204,5.1177801944370085,4.8003325438650881,4.3356062520321883,3.4401804751106955,3.847289213140149,2.2307178304099233,2.3621653445475754,{"$f":"IFERROR(IF(OR($AF103=0,BC$79=0),\"\",SQRT(($AI$98-$AI103)^2+($AJ$98-$AJ103)^2)),\"\")","v":2.8428695923675069},{"$f":"IFERROR(IF(OR($AF103=0,BD$79=0),\"\",SQRT(($AI$99-$AI103)^2+($AJ$99-$AJ103)^2)),\"\")","v":4.5671526423599449},{"$f":"IFERROR(IF(OR($AF103=0,BE$79=0),\"\",SQRT(($AI$100-$AI103)^2+($AJ$100-$AJ103)^2)),\"\")","v":1.5466804011508541},{"$f":"IFERROR(IF(OR($AF103=0,BF$79=0),\"\",SQRT(($AI$101-$AI103)^2+($AJ$101-$AJ103)^2)),\"\")","v":1.0812295460626586},{"$f":"IFERROR(IF(OR($AF103=0,BG$79=0),\"\",SQRT(($AI$102-$AI103)^2+($AJ$102-$AJ103)^2)),\"\")","v":3.4860698055521917}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"MIN(Z80:AA102)","v":1.2632889777214806},null,"Min",{"$f":"MIN(AC80:AD103)","v":0},null,null,null,null,null,null,{"$f":"IF(AK79=1,SUM(AK80:AK103),\"\")","v":49.185817355075351},{"$f":"IF(AL79=1,SUM(AL80:AL103),\"\")","v":57.969232664686238},73.864926172391037,55.384928760629087,53.585276550366338,46.243784267273092,53.141414648705556,40.025741979753882,40.995909625444789,34.580663562286432,32.475904838059677,38.250813530837732,35.250475213781669,33.096083075428268,26.024891375777869,24.79352305930432,20.434180619893702,12.239531490914535,15.128190824693162,14.693699235507124,5.7006182562021923,5.1283778102674571,3.4860698055521917]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",{"$f":"MAX(Z80:AA103)","v":7.9999999999999991},null,"Max",{"$f":"MAX(AC80:AD103)","v":5.3326761660100326}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AA105-AA104","v":6.7367110222785183},null,null,{"$f":"+AD105-AD104","v":5.3326761660100326}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Down",{"$f":"1-AD104","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Top",{"$f":"+AD107+AD105","v":6.3326761660100326}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To 9",{"$f":"8/AD108","v":1.2632889777214806}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH80","v":"Coke"},null,null,{"$f":"IFERROR(AK80^2,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi",null,null,{"$f":"IFERROR(AK81^2,\"\")","v":1.6578690632704012},{"$f":"IFERROR(AL81^2,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fanta",null,null,{"$f":"IFERROR(AK82^2,\"\")","v":5.604017930538383},1.4475405775207595,0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprite",null,null,{"$f":"IFERROR(AK83^2,\"\")","v":2.4698608355387219},2.4880855028871589,7.2430230945776213,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi Max",null,null,{"$f":"IFERROR(AK84^2,\"\")","v":8.1640458545918069},16.190738799513003,26.972112493317802,9.6714207090337734,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke Zero",null,null,{"$f":"IFERROR(AK85^2,\"\")","v":4.9243642314177771},11.409084425663286,20.682704955504061,6.3675939708964977,0.41760555653907522,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water",null,null,{"$f":"IFERROR(AK86^2,\"\")","v":9.1931836060717149},15.1115091091495,18.652932573515194,21.071403585131311,16.445254843746696,13.951896928484523,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mt Dew",null,null,{"$f":"IFERROR(AK87^2,\"\")","v":0.97625976148883953},0.89450069132456711,4.555662006552053,0.51384429270281351,10.418276191395488,6.7200494630959184,16.068882938545137,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dr Pepper",null,null,{"$f":"IFERROR(AK88^2,\"\")","v":8.2163088855178152},17.254307124319482,26.683785777785701,14.49328807241756,2.361673111369607,2.5274359086565661,7.6478899575630983,13.143709478211671,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diet Coke",null,null,{"$f":"IFERROR(AK89^2,\"\")","v":4.5337045233036966},11.032783973705275,17.20463213523341,12.270415258221771,6.2598325753339426,4.7856235985687574,2.4259810338812358,9.491636288693087,1.8648378452957566,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi Next",null,null,{"$f":"IFERROR(AK90^2,\"\")","v":1.922357026403712},4.9331236836942338,11.724404238909038,1.3740541464293528,3.81579805494207,1.8289275136400267,15.89756185117465,1.7580785050818724,7.2681581774000117,7.0462353177898676,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lift",null,null,{"$f":"IFERROR(AK91^2,\"\")","v":3.6294787892245868},0.82679597249030157,2.5402400777263683,1.6142131215094404,18.091318900619864,13.16280602442127,22.584935377214354,1.121613068914636,21.861042327273605,16.261862525066427,5.3363363408806155,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sweet",null,null,{"$f":"IFERROR(AK92^2,\"\")","v":2.9109956549123925},0.17521094396983428,0.80923300647555807,3.210691767002162,19.516813310151782,14.233452905963853,17.745226821246327,1.583351364390871,20.906549193034657,13.857994668263036,6.6283086984207369,0.63122581233848796,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Kids",null,null,{"$f":"IFERROR(AK93^2,\"\")","v":3.9621597157523225},1.8597801709467834,1.0475883157467409,8.4599396230380979,23.220190735483843,17.574305861466062,11.112543165941521,4.9163885731449497,20.399586195019324,11.281295477167188,10.89026610124659,4.6791289645617651,1.8881190596007518,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High caffeine",null,null,{"$f":"IFERROR(AK94^2,\"\")","v":6.2734650857471692},12.392459656502282,22.274202567722366,5.7510307309335014,0.69173266824204216,0.40593145324016339,18.92717804908705,6.9815922664652605,4.7586981567753952,7.9105628820240499,1.7333910008440527,13.034602396722738,15.099020359345108,20.189053859760936,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modern",null,null,{"$f":"IFERROR(AK95^2,\"\")","v":3.3799380406652095},6.7515519516186595,14.427544883677381,1.7724432633389886,3.3477380309682383,1.7380119298144345,19.080106166038945,2.7838962632216884,7.9698154580539349,8.8380856662977543,0.20512401222122587,6.5961177146846595,8.5647982688639992,13.922302070764923,1.1472835373000694,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low in sugar",null,null,{"$f":"IFERROR(AK96^2,\"\")","v":8.2698052426748703},17.046788224650765,27.484441888882849,11.984292019319794,0.4931351023367555,0.94910328004028044,12.340017509924895,11.83909204617798,0.72735481047018968,3.9925828604955105,5.2550768445679683,20.220033233237832,20.6156576211167,22.448142834469273,2.0996773269405353,5.2557279511142152,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trusted",null,null,{"$f":"IFERROR(AK97^2,\"\")","v":2.0564166511120079},5.0390958165831181,8.0790146498166742,9.0279532919989176,11.50648254704717,8.2322917765023362,2.7451004829588204,5.6580752815317288,7.1771403302573971,1.9794140361950656,6.8732463071882721,9.5916093554896609,6.7205648748021698,3.8994575876547626,11.390274661258395,9.3396456641039372,9.6019338252158235,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clear",null,null,{"$f":"IFERROR(AK98^2,\"\")","v":8.2522426277588217},10.952739050550761,11.638033180746344,19.410316898897964,22.552567112695254,18.415433468228208,1.6532923070263819,13.876820396144145,13.835900510079474,5.5772063016439661,17.047458132197598,17.796037690918855,12.539840301404727,5.7022632972304335,23.41233251681453,20.841299395553815,18.788102146507441,2.2783372434338887,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tangy",null,null,{"$f":"IFERROR(AK99^2,\"\")","v":1.9866262720566228},1.1183008401205965,4.6008269527037919,0.29892998927305831,12.10659487221934,8.1840338212615915,19.568869914531088,0.17799486408725701,15.936731634560541,12.232348342819423,2.3425358200972708,0.61214673596288316,1.5519550784962544,5.8221382158510409,7.9973005939029171,3.2032691678496441,14.077300689738726,7.7618444268830018,16.789907005865739,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adult",null,null,{"$f":"IFERROR(AK100^2,\"\")","v":3.1280965214729233},9.2194337796563719,15.930079464917073,8.9544319672837176,3.9357082782101465,2.5608981183326094,4.5660261804156868,7.0145984129194456,1.4320074332587485,0.37865152708014738,4.2810618233809627,13.364418906281131,11.913131207456207,11.022068901067401,4.9022213115580051,5.6050935584516646,2.5205871190752487,2.3286115726899017,7.6820457143413758,9.3124745580744044,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bitter",null,null,{"$f":"IFERROR(AK101^2,\"\")","v":10.992047868842249},21.113410071936404,30.816420579553711,18.901123189386482,4.1483511208022055,4.6324883506279395,7.0927800674042905,17.038037886645895,0.32254775621343212,2.2959473568661992,10.580932488227241,26.699445598943079,25.117176454142033,23.371693201732885,7.4571746890877568,11.493322868200528,1.7813420697787048,8.498626330916629,14.100861916409238,20.310130033827033,2.4500710794108147,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friendy",null,null,{"$f":"IFERROR(AK102^2,\"\")","v":2.710982790996697},2.7974501019477129,3.383575552670921,8.7983133636415403,18.269774613857219,13.556024597581398,6.1520183938237381,5.0681160209068086,14.257140471475253,6.4813731935614651,9.1988884987790076,6.6525115249805191,3.5370541069508885,0.75361853912852017,16.631432258097281,12.144734758749907,16.776902532227059,1.3012467195310267,2.75895598806038,6.5958345864281576,6.7011997645746417,16.379409072455914,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For diets",null,null,{"$f":"IFERROR(AK103^2,\"\")","v":10.325599158407426},19.386062731427561,26.867260258727246,20.582744317036479,8.3805085843351765,7.8853907888040125,2.709452511508788,17.256589884346251,1.9077715390616012,1.1796985071097206,12.912705861754782,26.191674118571704,23.04319253169027,18.797481572660597,11.83484170133285,14.801634289544547,4.9761020389087554,5.5798251149815661,8.0819075192077943,20.858883258615428,2.3922202633041669,1.1690573312788628,12.152682689182695,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AK162:BH162)","v":2577.8528801864795},null,null,{"$f":"SUM(AK138:AK161)","v":115.53982613776616},{"$f":"SUM(AL138:AL161)","v":189.44075320017839},303.61771865476192,184.52844357749322,185.97935621029592,141.34410578872996,188.31786272828606,119.70959060088356,140.62528183822931,99.313258662379837,93.285331929806333,146.06895205269333,130.5905098638691,125.92822008032078,86.872538596292344,82.68472765356826,68.522270421451751,27.748491408436013,49.413678143884525,57.077322436945018,11.543491107289622,17.548466403734778,12.152682689182695,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH138","v":"Coke"},null,null,{"$f":"IFERROR((AK80-AI53)^2,\"\")","v":0},{"$f":"IFERROR((AL80-AJ53)^2,\"\")","v":0},{"$f":"IFERROR((AM80-AK53)^2,\"\")","v":0},{"$f":"IFERROR((AN80-AL53)^2,\"\")","v":0},{"$f":"IFERROR((AO80-AM53)^2,\"\")","v":0},{"$f":"IFERROR((AP80-AN53)^2,\"\")","v":0},{"$f":"IFERROR((AQ80-AO53)^2,\"\")","v":0},{"$f":"IFERROR((AR80-AP53)^2,\"\")","v":0},{"$f":"IFERROR((AS80-AQ53)^2,\"\")","v":0},{"$f":"IFERROR((AT80-AR53)^2,\"\")","v":0},{"$f":"IFERROR((AU80-AS53)^2,\"\")","v":0},{"$f":"IFERROR((AV80-AT53)^2,\"\")","v":0},{"$f":"IFERROR((AW80-AU53)^2,\"\")","v":0},{"$f":"IFERROR((AX80-AV53)^2,\"\")","v":0},{"$f":"IFERROR((AY80-AW53)^2,\"\")","v":0},{"$f":"IFERROR((AZ80-AX53)^2,\"\")","v":0},{"$f":"IFERROR((BA80-AY53)^2,\"\")","v":0},{"$f":"IFERROR((BB80-AZ53)^2,\"\")","v":0},{"$f":"IFERROR((BC80-BA53)^2,\"\")","v":0},{"$f":"IFERROR((BD80-BB53)^2,\"\")","v":0},{"$f":"IFERROR((BE80-BC53)^2,\"\")","v":0},{"$f":"IFERROR((BF80-BD53)^2,\"\")","v":0},{"$f":"IFERROR((BG80-BE53)^2,\"\")","v":0},{"$f":"IFERROR((BH80-BF53)^2,\"\")","v":0}]
[null,null,null,"If your data is NOT in a 1-9 scale, then nominate your scale and enter your data in the following table ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi",null,null,1.4620673399838658E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fanta",null,null,8.9631954767347768E-2,0.63498935801855538,0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprite",null,null,0.8619653864717105,1.5774523459878831,0.12813047876989039,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Enter the maximum of the scale are you using?",5,"= Maximum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi Max",null,null,5.7341649670486505E-4,0.47670515631818666,0.4808982177050859,1.2075985136960114E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Minimum is fixed at one (1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke Zero",null,null,3.9036200583532195E-2,0.39404950102071651,0.21575176535957893,5.134339241793439E-2,0.36454536627403283,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water",null,null,0.21899936503399173,0.37533701443314327,2.3176234293241008E-2,3.7005954772813592,0.52119968428290331,0.97066596045788189,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mt Dew",null,null,1.0240254334382581,1.9253029575068212,1.0411582385496726E-3,0.902190960355995,5.1863439152558276E-2,8.0505512449497308E-5,0.45598658358839128,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Enter your data on your scale as you defined above",{"$f":"+E16","v":"Sweet"},"For Kids","High caffeine","Modern","Low in sugar","Trusted","Clear","Tangy","Adult","Bitter","Friendy","For diets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dr Pepper",null,null,3.9897580210144737E-2,0.42749421279744521,2.2469063036078376,0.65125728251115622,8.7947672788532147E-2,0.98712606503925571,0.81213404287088475,1.2665823766742685,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"+D17","v":"Coke"},1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diet Coke",null,null,4.1650106548898898E-2,0.23836867935311948,9.8918649359901772E-2,2.8758026922149085E-2,0.25196960638082638,0.15659947341677868,3.773088268189162,6.536711115715123E-3,0.21878321030096479,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Pepsi",2,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi Next",null,null,0.37639341108316143,4.8869132010803978E-2,0.57369274060196795,0.68525191740863578,4.5479778519563217E-2,5.3340151028530125E-2,0.10272538036832563,0.7068456627031906,8.576415144622325E-4,1.4864687659130776E-4,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Fanta",3,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lift",null,null,0.26168091187785858,2.2722048580751504,3.1380845504583435E-2,9.7854138610917643E-2,0.2534005936467193,1.6398892768922216E-2,1.0047276382068218,0.12788084468948688,2.0322765042232294,1.3440531023666536E-2,3.6061412730828014E-3,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Sprite",4,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sweet",null,null,0.16947379506834637,6.6288803672065561E-3,1.9517449181376691E-2,1.9727689920805209,0.46527653323420093,1.2445862083920207,3.8990303995150759E-3,4.7976001744643663E-2,8.8457118322542633E-2,1.7002012201075694E-4,0.20858788335116085,5.9917957710853689E-2,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Pepsi Max",5,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Kids",null,null,0.44435179406467623,0.56866438829098642,0.27407069706754061,8.2826390963672614E-2,0.29569964598069653,0.99157520661023957,0.45756229362818168,0.95863721589204165,8.8589058833233925E-2,0.83939790858789898,1.3976071245558883,2.0514983697389115E-3,1.5853719231846565E-2,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Coke Zero",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High caffeine",null,null,0.85771920014678682,3.7703357439427219,0.19767337742633553,5.8375323228103735,0.11002799214478579,0.88629008846718904,0.21500987714265929,0.27503135393215683,0.22626249250817523,1.5227929633507944,7.6897742299637126E-2,0.44169849964899377,0.51707478836050214,0.68319554362652846,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Water",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modern",null,null,0.67019411664920847,1.0400278458185326,3.9298955005135569E-3,0.61858945574653146,8.303242446335804E-2,7.7873450113363774E-2,8.6727299875770502E-3,4.2731948439845544,0.13935820746920963,4.995291095847091E-2,0.34383267514100441,0.20290956959309284,0.35192696639770638,1.9541992962579169,0.86283064377899454,0,0,0,0,0,0,0,0,0]
[null,null,null,"Mt Dew",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low in sugar",null,null,0.7395054544967633,0.46984666020241406,0.18346776619198465,1.8063296901850427,0.76793941338388583,0.22488396179603601,9.077181403596434,5.973374991145497E-2,8.310656613349396,5.1838443692840954,3.0471008465030095E-2,0.57911672279717297,0.50000952910344154,3.020460163507614,3.5506128543229418,1.6643042488864571E-3,0,0,0,0,0,0,0,0]
[null,null,null,"Dr Pepper",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trusted",null,null,0.87239550373934538,0.44387005209434055,3.4316128097403156E-2,0.1207845003236597,0.11802748228974996,4.4978959991320955E-2,1.3382660063261,7.7530904085001878E-2,0.26767662367477246,2.946056864766999E-2,1.2550681845406267E-3,9.8725952245311433E-3,8.5387264697168678E-3,0.12861468998041511,0.50166258535555486,0.30922873253435301,7.0418794254365341E-2,0,0,0,0,0,0,0]
[null,null,null,"Diet Coke",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clear",null,null,3.7696457622342949,2.2642333917551452,4.6252045180008909E-2,7.9928156102839134,0.22467953124731152,2.6798085700187481E-4,0.61748815902156939,2.5834919969402117,2.5625301853551504E-4,1.8880435822508723,0.15459430404629809,4.4129364935045645,8.4776296185805525E-2,3.8178075739076008E-2,6.5175978572694554E-2,1.7298225899055921,4.3452421532446746,1.1532980244843787,0,0,0,0,0,0]
[null,null,null,"Pepsi Next",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tangy",null,null,1.5565988821334547,2.5587751301385331,0.32080502056340127,0.242589497683669,0.67624080393850483,0.11263960441017695,0.47334345728323279,6.1004885769202905E-3,3.5128042621818385,0.7062096375198168,0.34492302841850286,7.9748668504327144E-2,0.34522492341648464,6.3325628815048152E-3,0.25541242237359324,0.29546337060253042,7.2771545233230846E-3,2.2396217625424613E-3,1.028633220118,0,0,0,0,0]
[null,null,null,"Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adult",null,null,3.6132403176823653E-2,0.84367179465107156,8.0485820098000135E-2,0.11241339307526961,1.794903479462652E-2,0.26786352065911906,0.27070005163632471,0.28161356390331377,2.4770502145296854E-2,0.17971832693209394,1.2708516994199817,0.38342447543160774,4.061853718956536E-2,5.5987510986396684E-2,0.21538514214416543,2.4165863773527902E-3,1.7663233077130212,0.15263693884589108,0.53049319907272241,9.0983513577546291E-2,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bitter",null,null,0.92068793422071515,4.8090806771967677E-2,0.54320543139661159,5.2695415671738651E-3,0.20994066470201384,0.25481597863915628,0.28426587963463268,0.15369840600377829,4.6148761884839962E-3,4.0092868205571985E-3,0.35488220738911402,2.0491312397380215,0.86187199664707959,1.5652376358171636,2.1741344589182712E-2,0.22421521705776756,0.83783033876961766,2.8255249163384972E-2,0.17789677009409666,1.1881207010506896,0.18898992113047855,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friendy",null,null,1.0213293113525488,0.1982725120972984,7.7498860871212438E-2,0.71971321402388322,4.0310225657012097E-7,0.35176747963981536,1.5758927490369199,0.8933002466140979,0.24908854741164033,4.1855190748890179,0.83746470718149901,6.0634744845449173E-3,8.1773647553484916E-2,0.39928237569710145,0.83082976839685196,1.7378173285202876,0.58160207858977553,0.73835865247345023,0.85067934950095958,0.16125768472860547,2.8454032607907404E-5,0.63544535512472311,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For diets",null,null,1.1270021170670568,0.16914183755693277,0.13626031499391439,0.64183973871144095,1.7327865248832814,1.5117599743534733,1.3134110443796065,0.17508638286115036,3.2948502924385648,2.1959168423972544E-3,0.15763447689338012,0.71036173725168517,0.14719950532643397,0.34293468241918684,0.47634908822402533,0.8660583240047891,0.66267929719175034,4.8915279263537198E-2,3.1047471025535883E-2,0.23408112378698814,0.3843829694282434,6.3556319556217558E-2,4.8167956871634976E-3,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AK189:BH189)","v":202.26065124243385},null,null,{"$f":"SUM(AK165:AK188)","v":15.15351071426147},{"$f":"SUM(AL165:AL188)","v":20.75233225920897},5.7173792000089403,26.282799528100252,6.2780065952098081,8.1535134621527288,21.784354595296339,11.893240749631989,18.459302203580346,14.604903744105952,5.1826080666191192,8.937232932259132,2.9548686358820673,8.1944225369129029,6.7799998277580054,5.1666864532515584,8.2713731242865283,2.1237037659931848,2.6187500098113148,1.6744430231438294,0.57340134459132985,0.69900167468094065,4.8167956871634976E-3,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(AH189/AH162)","v":0.28010872486997829},null,null,1,{"$f":"+AH165","v":"Coke"},{"$f":"+Z80","v":3.9400356705127617},{"$f":"+AA80","v":3.9784199234132189}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"+AH166","v":"Pepsi"},{"$f":"+Z81","v":3.0217541901695912},2.6358288570712927]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Fanta",{"$f":"+Z82","v":1.587963079885653},2.1314761314105777]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Sprite",{"$f":"+Z83","v":4.9841478529805094},2.2897878468978545]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Pepsi Max",{"$f":"+Z84","v":7.1958880764242306},5.5367581610376488]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Coke Zero",{"$f":"+Z85","v":6.5154372243430378},5.0857116610001372]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Water",{"$f":"+Z86","v":2.4705334713868341},7.5156442857585057]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Mt Dew",{"$f":"+Z87","v":4.21010104335934},2.7597826879148002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Dr Pepper",{"$f":"+Z88","v":5.9267424637206885},7.0058603589445463]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Diet Coke",{"$f":"+Z89","v":4.2383550799143661},6.6516838894192833]
[null,null,null,"Scale Recalculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Pepsi Next",{"$f":"+Z90","v":5.6526345132895219},3.6111421823723195]
[null,null,null,"Enter your data on your scale as you defined above",{"$f":"+E173","v":"Sweet"},{"$f":"+F173","v":"For Kids"},"High caffeine","Modern","Low in sugar","Trusted","Clear","Tangy","Adult","Bitter","Friendy","For diets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Lift",{"$f":"+Z91","v":3.5317873710851484},1.6065820187679669]
[null,null,null,{"$f":"+D174","v":"Coke"},{"$f":"IF((E174-1)*8/($E$169-1)+1>0.99,(E174-1)*8/($E$169-1)+1,\"\")","v":1},3,"","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"+AH177","v":"Sweet"},{"$f":"+Z92","v":2.7223176182947171},2.1999886146443939]
[null,null,null,{"$f":"+D175","v":"Pepsi"},{"$f":"IF((E175-1)*8/($E$169-1)+1>0.99,(E175-1)*8/($E$169-1)+1,\"\")","v":3},5,"","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"+AH178","v":"For Kids"},{"$f":"+Z93","v":1.4880861275723258},3.4206114164382129]
[null,null,null,"Fanta",{"$f":"IF((E176-1)*8/($E$169-1)+1>0.99,(E176-1)*8/($E$169-1)+1,\"\")","v":5},7,"","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"High caffeine",{"$f":"+Z94","v":7.0617826998407107},4.4946683136597345]
[null,null,null,"Sprite",{"$f":"IF((E177-1)*8/($E$169-1)+1>0.99,(E177-1)*8/($E$169-1)+1,\"\")","v":7},9,"","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Modern",{"$f":"+Z95","v":6.2016536785098504},3.4500981801294275]
[null,null,null,"Pepsi Max",{"$f":"IF((E178-1)*8/($E$169-1)+1>0.99,(E178-1)*8/($E$169-1)+1,\"\")","v":9},1,"","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Low in sugar",{"$f":"+Z96","v":6.7374392166809782},6.2962438291166931]
[null,null,null,"Coke Zero",{"$f":"IF((E179-1)*8/($E$169-1)+1>0.99,(E179-1)*8/($E$169-1)+1,\"\")","v":""},"","","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Trusted",{"$f":"+Z97","v":2.9111873731577971},5.469494885618059]
[null,null,null,"Water",{"$f":"IF((E180-1)*8/($E$169-1)+1>0.99,(E180-1)*8/($E$169-1)+1,\"\")","v":""},"","","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Clear",{"$f":"+Z98","v":1.2632889777214806},6.428883806087252]
[null,null,null,"Mt Dew",{"$f":"IF((E181-1)*8/($E$169-1)+1>0.99,(E181-1)*8/($E$169-1)+1,\"\")","v":""},"","","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Tangy",{"$f":"+Z99","v":4.2957295233844182},2.2337317432813242]
[null,null,null,"Dr Pepper",{"$f":"IF((E182-1)*8/($E$169-1)+1>0.99,(E182-1)*8/($E$169-1)+1,\"\")","v":""},"","","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"Adult",{"$f":"+Z100","v":4.7454630648414389},6.0625055627204274]
[null,null,null,"Diet Coke",{"$f":"IF((E183-1)*8/($E$169-1)+1>0.99,(E183-1)*8/($E$169-1)+1,\"\")","v":""},"","","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"Bitter",{"$f":"+Z101","v":5.8289507346780445},7.7166278544193947]
[null,null,null,"Pepsi Next",{"$f":"IF((E184-1)*8/($E$169-1)+1>0.99,(E184-1)*8/($E$169-1)+1,\"\")","v":""},"","","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"Friendy",{"$f":"+Z102","v":1.9102532233495451},4.432774470147117]
[null,null,null,"Lift",{"$f":"IF((E185-1)*8/($E$169-1)+1>0.99,(E185-1)*8/($E$169-1)+1,\"\")","v":""},"","","","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"For diets",{"$f":"+Z103","v":4.4927629854291204},7.9999999999999991]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"MIN(E17:P28)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max",{"$f":"MAX(E17:P28)","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH222+1","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(E17<>\"\",$AH$223-E17,\"\")","v":4},{"$f":"IF(F17<>\"\",$AH$223-F17,\"\")","v":5},{"$f":"IF(G17<>\"\",$AH$223-G17,\"\")","v":3},5,7,1,9,5,3,8,5,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(E18<>\"\",$AH$223-E18,\"\")","v":1},4,3,3,9,3,9,5,4,9,4,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,2,1,8,7,9,5,6,3,8,9,4,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,6,6,9,4,4,5,3,2,5,8,4,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,7,8,1,4,3,7,8,5,4,3,8,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,5,6,{"$f":"IF(G22<>\"\",$AH$223-G22,\"\")","v":3},{"$f":"IF(H22<>\"\",$AH$223-H22,\"\")","v":2},{"$f":"IF(I22<>\"\",$AH$223-I22,\"\")","v":1},{"$f":"IF(J22<>\"\",$AH$223-J22,\"\")","v":5},{"$f":"IF(K22<>\"\",$AH$223-K22,\"\")","v":8},{"$f":"IF(L22<>\"\",$AH$223-L22,\"\")","v":6},{"$f":"IF(M22<>\"\",$AH$223-M22,\"\")","v":4},{"$f":"IF(N22<>\"\",$AH$223-N22,\"\")","v":5},{"$f":"IF(O22<>\"\",$AH$223-O22,\"\")","v":8},{"$f":"IF(P22<>\"\",$AH$223-P22,\"\")","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8,5,9,8,1,1,1,7,5,6,7,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,2,6,4,7,6,5,4,1,4,7,6,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,8,9,5,6,7,6,7,4,2,1,8,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,7,8,3,6,8,3,7,5,2,3,1,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,4,4,2,2,4,5,7,4,6,5,4,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,2,4,8,4,7,6,4,1,8,7,5,8]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"+AH225","v":4},{"$f":"+AH226","v":1},{"$f":"+AH227","v":2},{"$f":"+AH228","v":6},{"$f":"+AH229","v":7},{"$f":"+AH230","v":5},{"$f":"+AH231","v":8},{"$f":"+AH232","v":2},{"$f":"+AH233","v":8},{"$f":"+AH234","v":7},{"$f":"+AH235","v":4},{"$f":"+AH236","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"+AI225","v":5},{"$f":"+AI226","v":4},{"$f":"+AI227","v":1},{"$f":"+AI228","v":6},{"$f":"+AI229","v":8},{"$f":"+AI230","v":6},{"$f":"+AI231","v":5},{"$f":"+AI232","v":6},{"$f":"+AI233","v":9},{"$f":"+AI234","v":8},{"$f":"+AI235","v":4},{"$f":"+AI236","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"+AJ225","v":3},{"$f":"+AJ226","v":3},{"$f":"+AJ227","v":8},{"$f":"+AJ228","v":9},{"$f":"+AJ229","v":1},{"$f":"+AJ230","v":3},{"$f":"+AJ231","v":9},{"$f":"+AJ232","v":4},{"$f":"+AJ233","v":5},{"$f":"+AJ234","v":3},{"$f":"+AJ235","v":2},{"$f":"+AJ236","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"+AK225","v":5},{"$f":"+AK226","v":3},{"$f":"+AK227","v":7},{"$f":"+AK228","v":4},{"$f":"+AK229","v":4},{"$f":"+AK230","v":2},{"$f":"+AK231","v":8},{"$f":"+AK232","v":7},{"$f":"+AK233","v":6},{"$f":"+AK234","v":6},{"$f":"+AK235","v":2},{"$f":"+AK236","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"+AL225","v":7},{"$f":"+AL226","v":9},{"$f":"+AL227","v":9},{"$f":"+AL228","v":4},{"$f":"+AL229","v":3},{"$f":"+AL230","v":1},{"$f":"+AL231","v":1},{"$f":"+AL232","v":6},{"$f":"+AL233","v":7},{"$f":"+AL234","v":8},{"$f":"+AL235","v":4},{"$f":"+AL236","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"+AM225","v":1},{"$f":"+AM226","v":3},{"$f":"+AM227","v":5},{"$f":"+AM228","v":5},{"$f":"+AM229","v":7},{"$f":"+AM230","v":5},{"$f":"+AM231","v":1},{"$f":"+AM232","v":5},{"$f":"+AM233","v":6},{"$f":"+AM234","v":3},{"$f":"+AM235","v":5},{"$f":"+AM236","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"+AN225","v":9},{"$f":"+AN226","v":9},{"$f":"+AN227","v":6},{"$f":"+AN228","v":3},{"$f":"+AN229","v":8},{"$f":"+AN230","v":8},{"$f":"+AN231","v":1},{"$f":"+AN232","v":4},{"$f":"+AN233","v":7},{"$f":"+AN234","v":7},{"$f":"+AN235","v":7},{"$f":"+AN236","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"+AO225","v":5},{"$f":"+AO226","v":5},{"$f":"+AO227","v":3},{"$f":"+AO228","v":2},{"$f":"+AO229","v":5},{"$f":"+AO230","v":6},{"$f":"+AO231","v":7},{"$f":"+AO232","v":1},{"$f":"+AO233","v":4},{"$f":"+AO234","v":5},{"$f":"+AO235","v":4},{"$f":"+AO236","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"+AP225","v":3},{"$f":"+AP226","v":4},{"$f":"+AP227","v":8},{"$f":"+AP228","v":5},{"$f":"+AP229","v":4},{"$f":"+AP230","v":4},{"$f":"+AP231","v":5},{"$f":"+AP232","v":4},{"$f":"+AP233","v":2},{"$f":"+AP234","v":2},{"$f":"+AP235","v":6},{"$f":"+AP236","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"+AQ225","v":8},{"$f":"+AQ226","v":9},{"$f":"+AQ227","v":9},{"$f":"+AQ228","v":8},{"$f":"+AQ229","v":3},{"$f":"+AQ230","v":5},{"$f":"+AQ231","v":6},{"$f":"+AQ232","v":7},{"$f":"+AQ233","v":1},{"$f":"+AQ234","v":3},{"$f":"+AQ235","v":5},{"$f":"+AQ236","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"+AR225","v":5},{"$f":"+AR226","v":4},{"$f":"+AR227","v":4},{"$f":"+AR228","v":4},{"$f":"+AR229","v":8},{"$f":"+AR230","v":8},{"$f":"+AR231","v":7},{"$f":"+AR232","v":6},{"$f":"+AR233","v":8},{"$f":"+AR234","v":1},{"$f":"+AR235","v":4},{"$f":"+AR236","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"+AS225","v":8},{"$f":"+AS226","v":9},{"$f":"+AS227","v":9},{"$f":"+AS228","v":7},{"$f":"+AS229","v":3},{"$f":"+AS230","v":3},{"$f":"+AS231","v":1},{"$f":"+AS232","v":7},{"$f":"+AS233","v":6},{"$f":"+AS234","v":2},{"$f":"+AS235","v":6},{"$f":"+AS236","v":8}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IFERROR(((AH239-1)*$AE$258+0.5),\"\")","v":2.1178359683794463},{"$f":"IFERROR(((AI239-1)*$AE$258+0.5),\"\")","v":0.5},1.039278656126482,3.1963932806324102,3.7356719367588926,2.6571146245059283,4.274950592885375,1.039278656126482,4.274950592885375,3.7356719367588926,2.1178359683794463,1.039278656126482]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AH239:AS250)","v":5.1111111111111107},null,2,{"$f":"IFERROR(((AH240-1)*$AE$258+0.5),\"\")","v":2.6571146245059283},{"$f":"IFERROR(((AI240-1)*$AE$258+0.5),\"\")","v":2.1178359683794463},0.5,3.1963932806324102,4.274950592885375,3.1963932806324102,2.6571146245059283,3.1963932806324102,4.8142292490118566,4.274950592885375,2.1178359683794463,2.1178359683794463]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGEIF(AU65:BF76,\"<>0\")","v":2.7803030303030298},null,3,1.5785573122529641,1.5785573122529641,4.274950592885375,4.8142292490118566,0.5,1.5785573122529641,4.8142292490118566,2.1178359683794463,2.6571146245059283,1.5785573122529641,1.039278656126482,4.274950592885375]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGEIF(AI53:AT64,\"<>0\")","v":2.7323232323232309},null,4,2.6571146245059283,1.5785573122529641,3.7356719367588926,2.1178359683794463,2.1178359683794463,1.039278656126482,4.274950592885375,3.7356719367588926,3.1963932806324102,3.1963932806324102,1.039278656126482,2.1178359683794463]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AE255:AE256)","v":2.7563131313131306},null,5,3.7356719367588926,4.8142292490118566,4.8142292490118566,2.1178359683794463,1.5785573122529641,0.5,0.5,3.1963932806324102,3.7356719367588926,4.274950592885375,2.1178359683794463,3.7356719367588926]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AE257/AE254","v":0.53927865612648207},null,6,0.5,1.5785573122529641,2.6571146245059283,2.6571146245059283,3.7356719367588926,2.6571146245059283,0.5,2.6571146245059283,3.1963932806324102,1.5785573122529641,2.6571146245059283,3.1963932806324102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AH253:AS264)","v":2.7170344751866495},null,7,4.8142292490118566,4.8142292490118566,3.1963932806324102,1.5785573122529641,4.274950592885375,4.274950592885375,0.5,2.1178359683794463,3.7356719367588926,3.7356719367588926,3.7356719367588926,2.1178359683794463]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,2.6571146245059283,2.6571146245059283,1.5785573122529641,1.039278656126482,2.6571146245059283,3.1963932806324102,3.7356719367588926,0.5,2.1178359683794463,2.6571146245059283,2.1178359683794463,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,1.5785573122529641,2.1178359683794463,4.274950592885375,2.6571146245059283,2.1178359683794463,2.1178359683794463,2.6571146245059283,2.1178359683794463,1.039278656126482,1.039278656126482,3.1963932806324102,4.274950592885375]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,4.274950592885375,4.8142292490118566,4.8142292490118566,4.274950592885375,1.5785573122529641,2.6571146245059283,3.1963932806324102,3.7356719367588926,0.5,1.5785573122529641,2.6571146245059283,3.7356719367588926]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,2.6571146245059283,2.1178359683794463,2.1178359683794463,2.1178359683794463,4.274950592885375,4.274950592885375,3.7356719367588926,3.1963932806324102,4.274950592885375,0.5,2.1178359683794463,2.6571146245059283]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,4.274950592885375,4.8142292490118566,4.8142292490118566,3.7356719367588926,1.5785573122529641,1.5785573122529641,0.5,3.7356719367588926,3.1963932806324102,1.039278656126482,3.1963932806324102,4.274950592885375]