{"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":[[168,5,168,6],[165,3,165,15],[55,4,55,7],[55,8,55,14],[55,15,55,19],[58,4,58,15],[1,1,1,15],[2,1,2,15],[4,1,4,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],[13,4,13,6],[5,6,5,9],[14,2,14,3],[15,2,15,3],[87,12,87,17],[88,12,88,17],[102,13,102,16],[34,4,34,15],[35,4,35,15],[73,4,73,8],[29,4,29,15],[31,4,31,15],[86,12,86,13],[36,4,36,15],[37,4,37,15],[30,4,30,15],[59,4,59,15],[60,4,60,15],[33,6,33,13],[34,16,34,21],[35,16,35,21],[36,16,36,21],[37,16,37,21]]}
[]
[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,"For more information on Perceptual Maps visit:",null,null,null," www.perceptualmaps.com",null,null,null,"Or email: geoff@perceptualmaps.com"]
[]
[]
[null,"STEP ONE","Enter the Title of Your Map",null,"Soft Drinks"]
[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,"Attribute",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,"Differences",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","Feminine","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},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,"Brand",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,"Differences",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,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,null,null,null,null,null,null,null,"ATTENTION APPLE MAC USERS!!!"]
[null,null,null,"Follow sequence below","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,"Do not follow the instructions in Step Five",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,"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,{"$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,null,"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,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,{"$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,null,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,null,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,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Main Distance Data!!!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Position",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":"Feminine"},{"$f":"+AH76","v":"For diets"}]
[null,null,null,null,null,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,"Part A: Select Options","Part B: Select Add-ins",null,null,null,"Part C: Select Go",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,{"$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":"Feminine"},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,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,"Final points",null,null,"Mapping Points",null,null,null,null,"Start Point","Calculated Points",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,0,null,0,0,null,{"$f":"+IF($AF80=1,(AC80+$AD$107)*$AD$109,\"\")","v":6.3147742965937299},{"$f":"+IF($AF80=1,(AD80+$AD$107)*$AD$109,\"\")","v":6.629604606014273},null,{"$f":"IF($AF80=1,AI80,\"\")","v":3.8757021764866537},{"$f":"IF($AF80=1,AJ80,\"\")","v":4.1187552067726809},null,{"$f":"IF(E17>0.5,1,0)","v":1},null,{"$f":"+AH53","v":"Coke"},3.8757021764866537,4.1187552067726809]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,{"$f":"+IF($AF81=1,(AC81+$AD$107)*$AD$109,\"\")","v":7.3235668792482151},{"$f":"+IF($AF81=1,(AD81+$AD$107)*$AD$109,\"\")","v":6.1661811653190188},null,{"$f":"IF($AF81=1,AI81,\"\")","v":4.6545029679210037},3.7609863764022182,null,1,null,{"$f":"+AH54","v":"Pepsi"},4.6545029679210037,3.7609863764022182,{"$f":"IFERROR(IF(OR($AF81=0,AK$79=0),\"\",SQRT(($AI$80-$AI81)^2+($AJ$80-$AJ81)^2)),\"\")","v":0.85704679494378766}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,8,3.0277644579764376,null,5.1767179988916769,1.3380884907956032,null,1,null,"Fanta",5.1767179988916769,1.3380884907956032,3.0699754975391849,{"$f":"IFERROR(IF(OR($AF82=0,AL$79=0),\"\",SQRT(($AI$81-$AI82)^2+($AJ$81-$AJ82)^2)),\"\")","v":2.4785364033333677},null,null,null,null,"`"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,4.8894792812350261,2.4376325450424861,null,2.7753561736761054,0.88249909735034915,null,1,null,"Sprite",2.7753561736761054,0.88249909735034915,3.4182034655173057,{"$f":"IFERROR(IF(OR($AF83=0,AL$79=0),\"\",SQRT(($AI$81-$AI83)^2+($AJ$81-$AJ83)^2)),\"\")","v":3.4375691542112006},{"$f":"IFERROR(IF(OR($AF83=0,AM$79=0),\"\",SQRT(($AI$82-$AI83)^2+($AJ$82-$AJ83)^2)),\"\")","v":2.4441972733440473}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,2.4674684918919043,6.5732918387832271,null,0.90553283036846599,4.0752810293833157,null,1,null,"Pepsi Max",0.90553283036846599,4.0752810293833157,2.9704874934461221,3.7621215053681083,{"$f":"IFERROR(IF(OR($AF84=0,AM$79=0),\"\",SQRT(($AI$82-$AI84)^2+($AJ$82-$AJ84)^2)),\"\")","v":5.0729917935191748},{"$f":"IFERROR(IF(OR($AF84=0,AN$79=0),\"\",SQRT(($AI$83-$AI84)^2+($AJ$83-$AJ84)^2)),\"\")","v":3.7000129460171247}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,2.8886734436194659,5.2580786897007892,null,1.2307084466466089,3.0599196369402777,null,1,null,"Coke Zero",1.2307084466466089,3.0599196369402777,2.8490567903844006,3.4948338296818,4.3053099635500347,{"$f":"IFERROR(IF(OR($AF85=0,AN$79=0),\"\",SQRT(($AI$83-$AI85)^2+($AJ$83-$AJ85)^2)),\"\")","v":2.6696623020235135},{"$f":"IFERROR(IF(OR($AF85=0,AO$79=0),\"\",SQRT(($AI$84-$AI85)^2+($AJ$84-$AJ85)^2)),\"\")","v":1.0661603719355428}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,2.1080695680453982,2.3747177530364203,null,0.62807225904289421,0.83392807229550525,null,1,null,"Water",0.62807225904289421,0.83392807229550525,4.6192195643932417,4.9779327605981925,4.5765003872202037,{"$f":"IFERROR(IF(OR($AF86=0,AN$79=0),\"\",SQRT(($AI$83-$AI86)^2+($AJ$83-$AJ86)^2)),\"\")","v":2.1478331766032031},{"$f":"IFERROR(IF(OR($AF86=0,AO$79=0),\"\",SQRT(($AI$84-$AI86)^2+($AJ$84-$AJ86)^2)),\"\")","v":3.2532066274772964},{"$f":"IFERROR(IF(OR($AF86=0,AP$79=0),\"\",SQRT(($AI$85-$AI86)^2+($AJ$85-$AJ86)^2)),\"\")","v":2.3061241988408216}]
[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,0,null,0,0,null,6.6594284693693364,4.9761242524103704,null,4.1417796111784266,2.8422472009154247,null,1,null,"Mt Dew",4.1417796111784266,2.8422472009154247,1.3039439751269315,1.0521249512883577,1.8258123922221108,2.3890846866493809,3.4631872095584177,{"$f":"IFERROR(IF(OR($AF87=0,AP$79=0),\"\",SQRT(($AI$85-$AI87)^2+($AJ$85-$AJ87)^2)),\"\")","v":2.9191979402523609},{"$f":"IFERROR(IF(OR($AF87=0,AQ$79=0),\"\",SQRT(($AI$86-$AI87)^2+($AJ$86-$AJ87)^2)),\"\")","v":4.0471576543090046}]
[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,0,null,0,0,null,3.0118399829657352,7.6292561778441579,null,1.325794592173869,4.890499020799469,null,1,null,"Dr Pepper",1.325794592173869,4.890499020799469,2.6641353574892692,3.5151242175238129,5.2392014332424202,4.2620760393187984,0.91716973454446737,1.8330472595330236,{"$f":"IFERROR(IF(OR($AF88=0,AQ$79=0),\"\",SQRT(($AI$86-$AI88)^2+($AJ$86-$AJ88)^2)),\"\")","v":4.1161370621489368},{"$f":"IFERROR(IF(OR($AF88=0,AR$79=0),\"\",SQRT(($AI$87-$AI88)^2+($AJ$87-$AJ88)^2)),\"\")","v":3.4821124543754181}]
[null,null,null,null,null,null,null,null,null,null,null,null,"when you copy it:",null,null,null,null,null,null,null,0,null,0,0,null,3.6750066362960725,6.9917010876822534,null,1.8377677404175947,4.3982983272787557,null,1,null,"Diet Coke",1.8377677404175947,4.3982983272787557,2.0570175307805201,2.8879341863326351,4.5291801765741653,3.6386695776540803,0.98661142414528047,1.4696184895767566,3.7640534629927522,{"$f":"IFERROR(IF(OR($AF89=0,AR$79=0),\"\",SQRT(($AI$87-$AI89)^2+($AJ$87-$AJ89)^2)),\"\")","v":2.7802456381520355},{"$f":"IFERROR(IF(OR($AF89=0,AS$79=0),\"\",SQRT(($AI$88-$AI89)^2+($AJ$88-$AJ89)^2)),\"\")","v":0.7101957668311345}]
[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,0,null,0,0,null,5.3267076860758076,5.5180805976074581,null,3.1129021009385447,3.2606444391779528,null,1,null,"Pepsi Next",3.1129021009385447,3.2606444391779528,1.1481367709111203,1.620763797481422,2.8205597733968428,2.4019809574323832,2.352894360305728,1.8928664502521526,3.4732307249116503,1.1106958089698227,{"$f":"IFERROR(IF(OR($AF90=0,AS$79=0),\"\",SQRT(($AI$88-$AI90)^2+($AJ$88-$AJ90)^2)),\"\")","v":2.4187143703041358},{"$f":"IFERROR(IF(OR($AF90=0,AT$79=0),\"\",SQRT(($AI$89-$AI90)^2+($AJ$89-$AJ90)^2)),\"\")","v":1.708866292748513}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"to highlight it",null,null,null,null,null,null,0,null,0,0,null,7.3218668247728376,3.5803379569971638,null,4.6531905040967541,1.7646823077630143,null,1,null,"Lift",4.6531905040967541,1.7646823077630143,2.4791424552497436,1.9963045000767619,0.67532460526851301,2.0747310643166172,4.4027042248835988,3.6593746969205583,4.1313291243262347,1.1927645200751431,4.5653360969570631,{"$f":"IFERROR(IF(OR($AF91=0,AT$79=0),\"\",SQRT(($AI$89-$AI91)^2+($AJ$89-$AJ91)^2)),\"\")","v":3.8551963213943763},{"$f":"IFERROR(IF(OR($AF91=0,AU$79=0),\"\",SQRT(($AI$90-$AI91)^2+($AJ$90-$AJ91)^2)),\"\")","v":2.1471821216494869}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,7.6910879288226823,4.6868136484474716,null,4.9382339243126721,2.6188957100234398,null,{"$f":"IF(E17>0.5,1,0)","v":1},null,"Sweet",4.9382339243126721,2.6188957100234398,1.8380838460546625,1.1768068430479375,1.3028207039550561,2.7736462212584496,4.2876259528491714,3.7336640544719764,4.6651476984654181,0.82717915918730389,4.2673058866118394,3.5747956909132546,{"$f":"IFERROR(IF(OR($AF92=0,AU$79=0),\"\",SQRT(($AI$90-$AI92)^2+($AJ$90-$AJ92)^2)),\"\")","v":1.934858572814496},{"$f":"IFERROR(IF(OR($AF92=0,AV$79=0),\"\",SQRT(($AI$91-$AI92)^2+($AJ$91-$AJ92)^2)),\"\")","v":0.90051667836288296}]
[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,0,null,0,0,null,6.6885056460887453,2.3539822558644805,null,4.1642275639400976,0.81792000295998502,null,{"$f":"IF(F17>0.5,1,0)","v":1},null,"For Kids",4.1642275639400976,0.81792000295998502,3.3134211839025776,2.983623577168383,1.1382935195307193,1.3903719639456609,4.6075473109962894,3.6921669477820385,3.5361915387371887,2.0244516578484437,4.9641315042770646,4.269838902782638,2.6593585505628643,{"$f":"IFERROR(IF(OR($AF93=0,AV$79=0),\"\",SQRT(($AI$91-$AI93)^2+($AJ$91-$AJ93)^2)),\"\")","v":1.0655719678382056},{"$f":"IFERROR(IF(OR($AF93=0,AW$79=0),\"\",SQRT(($AI$92-$AI93)^2+($AJ$92-$AJ93)^2)),\"\")","v":1.9602549179455997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,4.8124989987593123,7.6669350636307234,null,2.715926409869585,4.9195876031061774,null,{"$f":"IF(G17>0.5,1,0)","v":1},null,"High caffeine",2.715926409869585,4.9195876031061774,1.4094014175704024,2.2584144601791771,4.3454149555690655,4.0375259132458741,1.9975931775840925,2.3799658280453984,4.5882184730926143,2.5196032422301551,1.3904361244554204,1.0212272802008218,1.7057790362306209,3.7022181990485308,{"$f":"IFERROR(IF(OR($AF94=0,AW$79=0),\"\",SQRT(($AI$92-$AI94)^2+($AJ$92-$AJ94)^2)),\"\")","v":3.1987237885830098},{"$f":"IFERROR(IF(OR($AF94=0,AX$79=0),\"\",SQRT(($AI$93-$AI94)^2+($AJ$93-$AJ94)^2)),\"\")","v":4.3498567028088413}]
[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,0,null,0,0,null,4.6198650614540062,5.0363090705130045,null,2.5672105435854347,2.8887106511594056,null,{"$f":"IF(H17>0.5,1,0)","v":1},null,"Modern",2.5672105435854347,2.8887106511594056,1.795873036204497,2.2622233765781248,3.0354502538355272,2.0169802681143887,2.0418428159582724,1.3474236052311066,2.8253121478840471,1.5752544558988681,2.3554766484185965,1.6765863398539234,0.66038929309634342,2.3695468158306645,2.386326041096527,{"$f":"IFERROR(IF(OR($AF95=0,AX$79=0),\"\",SQRT(($AI$93-$AI95)^2+($AJ$93-$AJ95)^2)),\"\")","v":2.6150788271049614},{"$f":"IFERROR(IF(OR($AF95=0,AY$79=0),\"\",SQRT(($AI$94-$AI95)^2+($AJ$94-$AJ95)^2)),\"\")","v":2.0363147111468933}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,1.9118328213524582,3.3510435898456983,null,0.476574977777387,1.5876641201995139,null,{"$f":"IF(I17>0.5,1,0)","v":1},null,"Low in sugar",0.476574977777387,1.5876641201995139,4.2379815716370501,4.7093961311543424,4.7067645377394562,2.4045067469373849,2.5243301539530685,1.6541625057539961,0.76881041625409463,3.8739777633748851,3.4102627954597322,3.1229009563333965,3.1223522940251929,4.1803651387672183,4.5792836936631396,3.7671325437602259,{"$f":"IFERROR(IF(OR($AF96=0,AY$79=0),\"\",SQRT(($AI$94-$AI96)^2+($AJ$94-$AJ96)^2)),\"\")","v":4.014524745515744},{"$f":"IFERROR(IF(OR($AF96=0,AZ$79=0),\"\",SQRT(($AI$95-$AI96)^2+($AJ$95-$AJ96)^2)),\"\")","v":2.4624132765935749}]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Select 'paste', then 'paste special'",null,null,null,null,null,null,0,null,0,0,null,4.1411643638681905,3.7642743191348611,null,2.1976474752696373,1.9066835346450102,null,{"$f":"IF(J17>0.5,1,0)","v":1},null,"Trusted",2.1976474752696373,1.9066835346450102,2.7765317687550848,3.078080236238173,3.0328470961464249,1.1758831157096681,2.5243564228835309,1.5049666417271932,1.9011498208699722,2.1575284784953848,3.1085820409275953,2.5174704960393237,1.6342891913036677,2.4596454856050785,2.8316179593009339,2.2478530363621116,3.0571561915937351,{"$f":"IFERROR(IF(OR($AF97=0,AZ$79=0),\"\",SQRT(($AI$95-$AI97)^2+($AJ$95-$AJ97)^2)),\"\")","v":1.049263607980647},{"$f":"IFERROR(IF(OR($AF97=0,BA$79=0),\"\",SQRT(($AI$96-$AI97)^2+($AJ$96-$AJ97)^2)),\"\")","v":1.7503896504542524}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"and choose 'picture'.",null,null,null,null,null,null,0,null,0,0,null,3.595299901120165,1.2953153023850295,null,1.7762331202142008,6.1555860566000391E-4,null,{"$f":"IF(K17>0.5,1,0)","v":1},null,"Clear",1.7762331202142008,6.1555860566000391E-4,4.6224284180558968,4.7354858255045063,3.6540568214595317,1.3326535378214008,4.1666554565364704,3.1075615220274964,1.4186906317438361,3.6973883473999929,4.9105860283045288,4.3981132594975128,3.5234176968103128,3.3747318832996114,4.1053185060878885,2.5239857404563697,5.0079246652881029,2.9944512932949876,{"$f":"IFERROR(IF(OR($AF98=0,BA$79=0),\"\",SQRT(($AI$96-$AI98)^2+($AJ$96-$AJ98)^2)),\"\")","v":2.0513006664210467},{"$f":"IFERROR(IF(OR($AF98=0,BB$79=0),\"\",SQRT(($AI$97-$AI98)^2+($AJ$97-$AJ98)^2)),\"\")","v":1.952097637908907}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,6.5887192831851316,4.1584703118456225,null,4.0871912140105637,2.2110078887114972,null,{"$f":"IF(L17>0.5,1,0)","v":1},null,"Tangy",4.0871912140105637,2.2110078887114972,1.9194341464510911,1.6505380754253911,1.3960862760700796,1.8670422549511749,3.6876095798268032,2.9799572071639018,3.7231509189659402,0.63359526700966118,3.8477245262660356,3.1375381154973732,1.4321229569858105,0.72080629893687265,0.94374052023475252,1.3952162759364886,3.0359135745778674,1.6642182166697825,3.6640288016189708,{"$f":"IFERROR(IF(OR($AF99=0,BB$79=0),\"\",SQRT(($AI$97-$AI99)^2+($AJ$97-$AJ99)^2)),\"\")","v":1.9138936368286046},{"$f":"IFERROR(IF(OR($AF99=0,BC$79=0),\"\",SQRT(($AI$98-$AI99)^2+($AJ$98-$AJ99)^2)),\"\")","v":3.1978682843847137}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,3.8106445091223167,6.591738653771964,null,1.9424819150872659,4.0895222067667465,null,{"$f":"IF(M17>0.5,1,0)","v":1},null,"Adult",1.9424819150872659,4.0895222067667465,1.9334412707332138,2.7318480892697394,4.2462537064058319,3.3134086308438815,1.0370468723410833,1.2516800398541599,3.5109209493103419,2.5283601990723756,1.0108744288288742,0.32604869417802801,1.4341972545822015,3.5711092969173452,3.3372552185443576,3.9546851591687737,1.1345593632372057,1.3536004770039514,2.8996856785132907,2.1977020115596582,{"$f":"IFERROR(IF(OR($AF100=0,BC$79=0),\"\",SQRT(($AI$98-$AI100)^2+($AJ$98-$AJ100)^2)),\"\")","v":4.0922849655385285},{"$f":"IFERROR(IF(OR($AF100=0,BD$79=0),\"\",SQRT(($AI$99-$AI100)^2+($AJ$99-$AJ100)^2)),\"\")","v":2.8510689258638844}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,{"$f":"+IF($AF101=1,(AC101+$AD$107)*$AD$109,\"\")","v":1.5195665757460473},6.2755235768878679,null,0.1737404131859385,3.8454001182668591,null,{"$f":"IF(N17>0.5,1,0)","v":1},null,"Bitter",0.1737404131859385,3.8454001182668591,3.7120403959753143,4.4815576256176266,5.5961054600790519,3.942992141125687,0.7670497866120416,1.3168754725875773,3.0455510683333942,4.0928780646869463,1.5554615223136894,1.7534775092091406,2.996766696120917,4.9391152774468452,4.9198283995490426,5.0089543368763678,2.7598167320167923,2.5775868562647748,2.2779553574379907,2.802645498018371,4.1653752755649673,{"$f":"IFERROR(IF(OR($AF101=0,BD$79=0),\"\",SQRT(($AI$99-$AI101)^2+($AJ$99-$AJ101)^2)),\"\")","v":4.2410299610478877},{"$f":"IFERROR(IF(OR($AF101=0,BE$79=0),\"\",SQRT(($AI$100-$AI101)^2+($AJ$100-$AJ101)^2)),\"\")","v":1.7855089175475181}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,5.8044762119878364,2.8805312277649078,null,3.4817455207856867,1.2244225517455254,null,{"$f":"IF(O17>0.5,1,0)","v":1},null,"Feminine",3.4817455207856867,1.2244225517455254,2.921020945581807,2.7945511386210731,1.6987794580924558,0.7847914107426448,3.8424296852103872,2.9045167341413358,2.8802668319561455,1.7472840627506105,4.2530272845977821,3.5743741243552924,2.0693586067241734,1.2900247877063229,2.0164111333669448,0.79437148828325899,3.7736883373486867,1.8990073992413328,3.0270438433590146,1.4540934768044003,2.0991608096954248,1.1575470247729946,{"$f":"IFERROR(IF(OR($AF102=0,BE$79=0),\"\",SQRT(($AI$100-$AI102)^2+($AJ$100-$AJ102)^2)),\"\")","v":3.2524034929618471},{"$f":"IFERROR(IF(OR($AF102=0,BF$79=0),\"\",SQRT(($AI$101-$AI102)^2+($AJ$101-$AJ102)^2)),\"\")","v":4.2204764181445338}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,{"$f":"+IF($AF103=1,(AC103+$AD$107)*$AD$109,\"\")","v":1.2970499659527446},{"$f":"+IF($AF103=1,(AD103+$AD$107)*$AD$109,\"\")","v":4.5394064178845905},null,{"$f":"IF($AF103=1,AI103,\"\")","v":1.9547410923649962E-3},{"$f":"IF($AF103=1,AJ103,\"\")","v":2.505095440474038},null,{"$f":"IF(P17>0.5,1,0)","v":1},null,"For diets",1.9547410923649962E-3,2.505095440474038,4.1964052514735544,4.8190732559189087,5.3047224239226241,3.2131875760646018,1.8116114779494594,1.3482082768985266,1.7846073850427981,4.1535311801588541,2.7281316303178782,2.6371246726495912,3.201382164812006,4.709798905488638,4.9375907764864087,4.4912221063723372,3.6325493282731118,2.5937806310660783,1.0329301024230064,2.2757775356912187,3.0692805745488063,4.0958081654006708,2.5052053589990191,{"$f":"IFERROR(IF(OR($AF103=0,BF$79=0),\"\",SQRT(($AI$101-$AI103)^2+($AJ$101-$AJ103)^2)),\"\")","v":1.3512686433311323},{"$f":"IFERROR(IF(OR($AF103=0,BG$79=0),\"\",SQRT(($AI$102-$AI103)^2+($AJ$102-$AJ103)^2)),\"\")","v":3.7079734247109819}]
[null,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.2953153023850295},null,"Min",{"$f":"MIN(AC80:AD102)","v":6.1555860566000391E-4},null,null,null,null,0,1.5785573122529641,{"$f":"IF(AK79=1,SUM(AK80:AK103),\"\")","v":62.112428948176778},{"$f":"IF(AL79=1,SUM(AL80:AL103),\"\")","v":66.904843940619031},70.946673011143346,51.537040530775911,49.73763264555101,41.301377871060375,54.179925909344369,38.396850299685894,45.496246654871371,37.573558655653187,28.521454435718095,33.283450735248216,35.216350954858605,31.148356217129734,28.452447648998138,16.594321758115129,16.703334100227572,12.596209796811161,16.623969909732441,12.345454077085439,7.5431177695083846,5.5717450614756663,3.7079734247109819,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,"Max",{"$f":"MAX(Z80:AA102)","v":8},null,"Max",{"$f":"MAX(AC80:AD102)","v":5.1767179988916769},null,null,null,null,2.6571146245059283,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,{"$f":"+AA105-AA104","v":6.7046846976149705},null,null,{"$f":"+AD105-AD104","v":5.1761024402860167},null,null,null,null,0,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,"Down",{"$f":"1-AD104","v":0.99938444139434002},null,null,null,null,0.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,"Top",{"$f":"+AD107+AD105","v":6.1761024402860167},null,null,null,null,0,4.8142292490118566]
[null,null,null,null,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.2953153023850295},null,null,null,null,2.6571146245059283,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,0,1.5785573122529641]
[null,null,null,null,null,null,null,null,null,null,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.274950592885375,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,0,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,null,null,4.274950592885375,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":"+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":0.73452920872341876},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":9.4247495554909655},6.1431427026487064,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":11.684114931674518},11.816881689984308,5.9741003110224753,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.823795948719825},14.153558221153201,25.735245737112894,13.690095800694323,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":8.1171245948354631},12.213863497088356,18.535693882243201,7.1270968068454854,1.136697938685735,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":21.337189384073291},24.779814569036741,20.944355794226674,4.6131873545174065,10.583353361062205,5.3182088204792217,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":1.7002698902698237},1.1069669131235291,3.3335908915918271,5.7077256399825709,11.993665648449021,8.5217166143736272,16.379485078831966,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":7.097617203024476},12.356098264622398,27.449231658089431,18.165292164935416,0.84120032196436878,3.3600622556815281,16.942584314396079,12.125107144916399,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.2313211219383877},8.3401638645887388,20.513473071872387,13.239916295345322,0.9734021022539785,2.1597785049058675,14.168098472267731,7.7297658084634193,0.50437802722486313,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.3182180447182144},2.6268752872263996,7.9555574353044491,5.7695125198677877,5.5361118707585009,3.5829433984901851,12.063331668470308,1.2336451800631287,5.8501792051157322,2.9202240064920466,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":6.1461473134217268},3.9852316570267301,0.4560633224810729,4.3045089892403636,19.38380449180789,13.391023172462427,17.067880333506174,1.4226872003500866,20.84229367817915,14.862538676492731,4.6103910635311918,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":3.3785522251271001},1.384874345844453,1.697341786653948,7.6931133607012763,18.383736311545764,13.940247271656117,21.763603048497188,0.68422536139381507,18.209899529912057,12.779164231771974,3.7436776967937484,0.81093028800972,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":10.978759941934358},8.9020096502350583,1.2957121366056321,1.9331341981261141,21.229492223069137,13.632096770294133,12.504650598636486,4.0984045149653126,24.642601591756073,18.231524255716042,7.0721879004518184,1.135443618642586,3.8425993433299097,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":1.9864123558494597},5.1004358739464042,18.882631136083305,16.301615500131931,3.9903785031305117,5.6642373426638191,21.051748756828321,6.3484004982567095,1.9333126161906093,1.0429051578263677,2.9096821204438656,13.706419593366146,10.231833875646844,18.921253334971006,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.2251599621663587},5.117654605536532,9.2139582435101666,4.0682094019627915,4.1691220850804074,1.8155503719339929,7.9823887329811676,2.4814266008292392,5.5482702412453042,2.8109417549847753,0.43611401843628816,5.6147521124132407,5.6945519744154236,6.8386372719726607,4.1465776028332559,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":17.96048780153524},22.178411920131488,22.153632413721716,5.7816526960674048,6.3722427261567223,2.7362535954423395,0.5910694561407942,15.007703711123078,11.629892334096827,9.7525103830680422,9.7490838480043838,17.475452693420262,20.969839147049125,14.19128760225739,16.116408932358251,6.0634791447443055,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":7.7091286629062399},9.4745779407200459,9.1981615086038016,1.3827011018110766,6.3723753497533355,2.2649245927116257,3.6143706413939274,4.6549291355186098,9.6632823051775745,6.3376576984284787,2.6709011608119959,6.0498559148574422,8.018060267435585,5.0528432730823649,9.3462039797999097,1.1009541190325649,3.0638639284173599,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":21.366844480050741},22.424826003554095,13.352131254454935,1.7759654518678958,17.361017693485142,9.656938613185849,2.012683108597725,13.670680591489251,24.113855141379648,19.343400243367835,12.414472266196089,11.388815284158941,16.853640036427691,6.3705040180270887,25.079309453200956,8.9667385479160231,4.2078344240594303,3.810685187929534,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":3.6842274425624288},2.7242759384289541,1.9490568902312226,3.485846781773168,13.598464413230412,8.8801449565280812,13.861852765396925,0.40144296237704385,14.804984030029187,9.8441454261988071,2.0509761639257817,0.51956172058707217,0.89064616953296138,1.9466284566380838,9.216771232306165,2.7696222726955511,13.425107059093351,3.6629888530930224,10.226361564273633,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.7381951473744648},7.4629939828467267,18.030670539165264,10.978676754950726,1.075466215432423,1.5667029221693112,12.326565912306233,6.3926052962533033,1.0218671108601027,0.10630775097519723,2.0569217650511242,12.752821610529496,11.137272393701547,15.63953470814975,1.2872249487092138,1.8322342513453247,8.4081770341750826,4.8298941316133677,16.746796239172674,8.1285940200266431,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":13.779243901352569},20.0843587517315,31.316396320326575,15.54718702497893,0.58836537514157849,1.7341610103027552,9.2753813098266793,16.751650852395564,2.4194605473984199,3.0746833753022917,8.9806106309794753,24.394859723908827,24.204711481009294,25.089623548912574,7.6165883943198471,6.6439540015889245,5.1890806104804437,7.8548217875626429,17.350351186287927,17.986335130505847,3.1880420946417098,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,"Feminine",null,null,{"$f":"IFERROR(AK102^2,\"\")","v":8.5323633645276349},7.8095160663683361,2.8858516472368976,0.61589755837543059,14.764265885785996,8.436217458907052,8.2959370232666902,3.0530015959422796,18.088241083533184,12.776150380860663,4.282245043223412,1.6641639528967433,4.0659138587661667,0.63102606139735984,14.240723667441495,3.6062291023733306,9.162994429617715,2.1143878392851088,4.4064761049611514,1.3399151145608119,10.578128481030424,17.812421196114112,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":17.609817034594826},23.223467045912873,28.14007999486752,10.324574398975912,3.2819361470382247,1.8176655578976944,3.1848235187492939,17.251821264551804,7.4427021923408843,6.9544265390972138,10.248847765176405,22.182205730141973,24.379802676043656,20.171076008767574,13.195414622337436,6.7276979620935435,1.0669445964916024,5.1791633919567959,9.4204832453026501,16.775644527762807,6.2760538907574039,1.8259269464499588,13.749066918362887,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":2533.3581893156793},null,null,{"$f":"SUM(AK138:AK161)","v":194.56426951687149},{"$f":"SUM(AL138:AL161)","v":233.40999879175558},289.01293597540541,152.50590980115129,161.63509866383137,108.47887323008563,193.08645474009367,113.30749771888904,166.71521963443959,120.83657988058245,71.226111443025573,117.69528224293245,130.2888712233582,114.85241428417585,100.24522283330654,37.710909401789564,44.524002082334981,27.451941191440469,58.150468339998035,44.230488792856107,20.042224466429538,19.63834814256407,13.749066918362887,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 andenter 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,9.5864464965692092E-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,0.16265801305975761,0.22899708931523555,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.84309760408798995,0.36510092723194987,1.2290813194699164E-2,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,1.8811263636244448E-2,0.18385929647692364,0.32831959544032069,0.49001812459157396,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,0.18696121908863741,0.55477743383845668,4.9273624362362309E-2,6.4541457161611613E-3,3.379700884687796E-2,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,1.2526524333205977,0.22841972365300914,0.16796367850275443,0.26918819041143405,6.4202889913398892E-3,0.19702572685470243,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,0.48449398976209773,1.6414949182223046,0.11618163640712452,0.52188779559574516,0.21454239109851359,0.1128050341808728,0.50954516121637805,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","Feminine","For diets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dr Pepper",null,null,6.4075261515757992E-6,2.2874195570760854E-4,2.4728655920894598,1.5928359290226253,0.83935573974576605,0.56292919253868401,0.20202363641498847,0.96454487303930758,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"+D17","v":"Coke"},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,"Diet Coke",null,null,7.6350422740405363E-2,2.9812531482513445E-3,0.48420282924823072,9.3230222095898777E-2,1.0269564056728564,1.2403607532037366,6.9724231318464766E-2,4.8291979551206107E-2,1.2614379932884809,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Pepsi",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,"Pepsi Next",null,null,0.72567096107373308,0.14382009730071194,2.3683088299065437E-2,0.16158869013825544,3.4680753878124124E-2,9.5810750469479497E-2,3.7417463562650029E-2,1.115074452305008,6.148034127145225E-2,0.91738155627775475,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Fanta",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,"Lift",null,null,3.9032241590773492E-3,0.17670435110015875,0.54958805199806393,0.24147173001551994,0.42602280518089952,2.5400294018519808E-2,0.14541190105941293,5.013217124829214E-2,1.7301090479582406,3.7786033478945736E-3,1.057151610850092E-2,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Sprite",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,"Sweet",null,null,7.8261249945220837E-2,0.45806750279651548,6.9454410973678465E-2,0.178715076209331,0.30465323587818766,1.158958675160223,0.15225378120304328,4.4986196601852407E-2,5.8441534008635168E-5,2.5881166477386187E-2,3.3480727287732291E-2,1.9254886472865544E-2,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Pepsi Max",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,"For Kids",null,null,0.43073829990706752,0.74958818353246481,0.40741861707491278,3.2617129963269398,0.11062057689815105,0.24579152903899035,0.77277622113435485,1.3734471672135169,2.2470686133595597E-2,2.6129375706419843E-5,0.29324670701459665,1.1072595268350562,0.21183458949311071,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,2.8613716705857925E-2,0.46220574158636463,4.9652264084186735E-3,0.60326807179000452,2.2427853255464192,0.64225560918463231,5.1080870831617928E-2,0.1614169423374304,1.6044744224902043,0.31061676462724203,0.44422275667896166,0.32802239495008206,1.0276590655592943E-3,0.46674862548394608,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.74173707341997208,0.46739928750985471,0.49031040523603009,1.0171872275955146E-2,5.7749592149077657E-3,9.4953309658691712E-2,2.101451621225868,4.6674036916055739,0.70714078233382249,2.3098131372384629,0.14355714941738412,6.3358350724610435E-2,2.8082270760752324E-3,7.9380523260618438E-2,1.3187582456822987E-3,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.25231496929142788,1.0989982599727451E-2,1.1548664168860363E-2,8.2180135279014632E-2,0.89448626809749066,1.3320910896883431,7.2259039886699628E-2,0.4591207312533872,0.10589110924105696,1.3272183650795459,1.0090530484888316,0.19775204391241749,0.55644194007616754,0.58849233969603487,0.46402174003106672,1.6661631752067144E-2,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,5.1825968941511551,2.2485689995571505,0.1411748902450766,2.1940467826508456,1.4672852741551317,1.3274449742211085,1.9632208205239552,0.2495863172856681,7.7108138184964732E-3,0.88155796668783826,1.0461718668053921,0.54279731347763527,0.10997047093091582,7.3068811702882768E-3,0.15248206907776771,2.1046360791293299,1.1727670202877076,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.678755875539666E-2,6.2005267456579291E-3,0.20945591660241827,6.0468666279689165E-2,1.1727836556827848E-2,1.3627972427584214,0.84399247685388878,2.4949857180694686,1.3804231225125076,0.43882850607169266,4.5051862376149304E-2,1.5797873409429988,0.7315697468564174,3.5221367802898427E-3,0.18027779917112555,6.5305141498604447E-2,3.9481425164720162E-2,0.39845850317795933,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,0.54417248770321314,1.0131963491588831,3.329567904565555E-2,0.6851925755392072,1.0619198529417719,4.6844573898465594E-2,1.5677588657143183E-4,1.7847695367382663E-2,2.9925144227069436,0.23080673069640692,0.47020233399452854,4.8755421650199568E-2,0.79137537311664641,0.88006361337891525,8.8458512898159661E-2,0.44771503934767737,6.9583320098546261E-6,0.84536935550870795,1.3118255012342065E-2,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,0.12594262398661157,0.37701088460019594,8.2351129361978698E-4,0.43072182275512139,1.1681050701154219,0.75022609251950112,0.72898524027601985,0.16853014398602145,8.0680012837416361E-4,0.50869697862099295,3.1053348342271478,0.49539256990995573,7.613473163223603E-3,0.75925400438675539,0.37876717737899368,1.1301097236040039,2.8835395866508881E-4,7.8980865079122636E-2,0.35080148040297587,1.0214927775279358E-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.31686788978532332,0.11067040901175236,0.61133040943279338,0.11019641369468916,0.65854446417185253,1.7962409843348206,2.2753373011261433E-2,0.12759621782935301,1.1139990250847307,3.059707530318756E-2,0.11536352975235339,1.4482758742461794,0.69972399580322431,2.0323952457430483,3.1146390010864687E-2,0.11497511782218284,7.8150200948582272E-4,7.8785660893799472E-2,0.69229379363258958,0.67957484112305988,4.6006424451637405E-2,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,"Feminine",null,null,6.9646546303804804E-2,0.45794342163515389,0.1756083588139106,1.7770077926450958,0.18707433557599537,1.8780889611920772,0.73171789332259873,2.0999175253500013,4.8063144627284059E-4,9.4517762565053705,2.3500545930561275E-3,1.8689346218807716,2.257672528718379E-2,0.49791159654758294,0.36847530867759093,7.1641483438666331E-2,9.381325166872842E-2,0.29801393206750787,0.2344230326459012,1.0183224516556126,0.44765487850532465,0.94182447817464399,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,6.1693706574994728E-3,2.3464402915568569E-5,0.24058355463404477,0.27298990717012178,5.4314244148489482E-2,5.3060678088719906E-2,1.6502161337064958,0.17460634729478827,0.21926897315528909,2.5531118925187681,2.4888965357420798E-5,0.18909305497390511,0.2713619281914903,0.54941021097504439,0.77889331683532093,0.10425539198586435,0.14725375073752883,9.4590568663277488E-2,0.16209795882012815,1.5562143510827931E-4,0.11460844620609927,3.2167534471714952E-4,8.485962728228931E-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,null,null,null,null,{"$f":"SUM(AK189:BH189)","v":157.76135132760737},null,null,{"$f":"SUM(AK165:AK188)","v":11.664318684032933},{"$f":"SUM(AL165:AL188)","v":9.888248585379344},6.6003385534714996,13.043346940203229,10.749066836715023,12.923085471009989,10.054986641434271,14.217488170338259,11.208266613103476,18.990091128828251,6.7186312757099911,7.888683399976677,3.4063041290600147,5.864485177422524,2.4438410723265722,4.0552996085783963,1.4543922621588461,1.794198885390375,1.4527345205139368,1.7082678419890602,0.60826974916306131,0.94214615351936115,8.485962728228931E-2,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.2495468024787032},null,null,1,{"$f":"+AH165","v":"Coke"},{"$f":"+Z80","v":6.3147742965937299},{"$f":"+AA80","v":6.629604606014273}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":7.3235668792482151},6.1661811653190188]
[null,null,null,null,null,null,null,null,null,null,null,null,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":8},3.0277644579764376]
[null,null,null,null,null,null,null,null,null,null,null,null,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.8894792812350261},2.4376325450424861]
[null,null,null,null,null,null,null,null,null,null,null,null,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":2.4674684918919043},6.5732918387832271]
[null,null,null,null,null,null,null,null,null,null,null,null,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":2.8886734436194659},5.2580786897007892]
[null,null,null,null,null,null,null,null,null,null,null,null,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.1080695680453982},2.3747177530364203]
[null,null,null,null,null,null,null,null,null,null,null,null,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":6.6594284693693364},4.9761242524103704]
[null,null,null,null,null,null,null,null,null,null,null,null,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":3.0118399829657352},7.6292561778441579]
[null,null,null,null,null,null,null,null,null,null,null,null,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":3.6750066362960725},6.9917010876822534]
[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.3267076860758076},5.5180805976074581]
[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","Feminine","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":7.3218668247728376},3.5803379569971638]
[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},"","","","","","","","","","","",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":7.6910879288226823},4.6868136484474716]
[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},"","","","","","","","","","","",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":6.6885056460887453},2.3539822558644805]
[null,null,null,"Fanta",{"$f":"IF((E176-1)*8/($E$169-1)+1>0.99,(E176-1)*8/($E$169-1)+1,\"\")","v":5},"","","","","","","","","","","",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":4.8124989987593123},7.6669350636307234]
[null,null,null,"Sprite",{"$f":"IF((E177-1)*8/($E$169-1)+1>0.99,(E177-1)*8/($E$169-1)+1,\"\")","v":7},"","","","","","","","","","","",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":4.6198650614540062},5.0363090705130045]
[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},"","","","","","","","","","","",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":1.9118328213524582},3.3510435898456983]
[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":4.1411643638681905},3.7642743191348611]
[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":3.595299901120165},1.2953153023850295]
[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":6.5887192831851316},4.1584703118456225]
[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":3.8106445091223167},6.591738653771964]
[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":1.5195665757460473},6.2755235768878679]
[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,"Feminine",{"$f":"+Z102","v":5.8044762119878364},2.8805312277649078]
[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":1.2970499659527446},4.5394064178845905]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,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,"Difference data brand-attribute",{"$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>0.5,$AH$223-E17,\"\")","v":4},{"$f":"IF(F17>0.5,$AH$223-F17,\"\")","v":5},{"$f":"IF(G17>0.5,$AH$223-G17,\"\")","v":3},{"$f":"IF(H17>0.5,$AH$223-H17,\"\")","v":5},{"$f":"IF(I17>0.5,$AH$223-I17,\"\")","v":7},{"$f":"IF(J17>0.5,$AH$223-J17,\"\")","v":1},{"$f":"IF(K17>0.5,$AH$223-K17,\"\")","v":9},{"$f":"IF(L17>0.5,$AH$223-L17,\"\")","v":5},{"$f":"IF(M17>0.5,$AH$223-M17,\"\")","v":3},{"$f":"IF(N17>0.5,$AH$223-N17,\"\")","v":8},{"$f":"IF(O17>0.5,$AH$223-O17,\"\")","v":5},{"$f":"IF(P17>0.5,$AH$223-P17,\"\")","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,2,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,3,2,1,5,8,6,4,5,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,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,"Adjusted for scale",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},"B-A",2,{"$f":"IFERROR(((AH240-1)*$AE$258+0.5),\"\")","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]
[null,null,null,null,null,null,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},"A's",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},"B's",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},"Adjust ",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},"New",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]