{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Mapping"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":73,"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":225,"n_cols":62,"rows_kept":225,"cut":false,"hidden":false,"merged":[[50,45,54,53],[178,5,178,6],[175,3,175,15],[68,4,68,15],[61,10,61,12],[98,12,98,17],[112,13,112,16],[83,4,83,8],[36,2,36,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[1,1,1,15],[2,1,2,15],[5,1,5,15],[4,1,4,15],[9,2,9,3],[9,4,9,15],[40,4,40,15],[69,4,69,15],[43,5,43,12],[37,2,37,3],[38,2,38,3],[41,4,41,15],[96,12,96,13],[97,12,97,17],[70,4,70,15],[47,14,47,19],[48,14,48,19],[49,14,49,19],[50,14,50,19],[60,7,60,9],[44,4,44,12],[45,4,45,12],[46,4,46,12],[47,4,47,12],[14,4,14,5],[14,6,14,13],[3,1,3,15],[31,2,31,3],[32,2,32,3],[6,6,6,9],[15,2,15,3],[16,2,16,3],[10,4,10,15],[14,2,14,3],[6,2,6,5],[16,5,16,13],[15,5,15,13],[29,2,29,3],[30,2,30,3]]}
[]
[null,"Welcome to \"Create Your Own Overall Similarities (OS) Perceptual Map\""]
[null,"Follow the Steps in Yellow",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(D$18<>\"\",D$18,\"\")","v":"Coke"},{"$f":"IF(D19<>\"\",D19,\"\")","v":"Pepsi"},{"$f":"IF(Z3<>\"\",1,0)","v":1},{"$f":"IF(AA3<>\"\",1,0)","v":1},{"$f":"+AC3+AB3","v":2},{"$f":"IF(D$20<>\"\",D$20,\"\")","v":"Sprite"},{"$f":"IF(D22<>\"\",D22,\"\")","v":"Pepsi Max"},{"$f":"IF(AE3<>\"\",1,0)","v":1},{"$f":"IF(AF3<>\"\",1,0)","v":1},{"$f":"+AH3+AG3","v":2},{"$f":"IF(D$22<>\"\",D$22,\"\")","v":"Pepsi Max"},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},{"$f":"IF(AJ3<>\"\",1,0)","v":1},{"$f":"IF(AK3<>\"\",1,0)","v":0},{"$f":"+AM3+AL3","v":1}]
[null,"Please note that there is a YouTube video available on How to Use this Template",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke","Sprite",{"$f":"IF(Z4<>\"\",1,0)","v":1},{"$f":"IF(AA4<>\"\",1,0)","v":1},{"$f":"+AC4+AB4","v":2},"Sprite","PM2",{"$f":"IF(AE4<>\"\",1,0)","v":1},{"$f":"IF(AF4<>\"\",1,0)","v":1},{"$f":"+AH4+AG4","v":2},{"$f":"IF(D$23<>\"\",D$23,\"\")","v":"PM2"},{"$f":"IF(D24<>\"\",D24,\"\")","v":""},{"$f":"IF(AJ4<>\"\",1,0)","v":1},{"$f":"IF(AK4<>\"\",1,0)","v":0},{"$f":"+AM4+AL4","v":1}]
[null,"Only enter data/information in the Blue cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke","Diet Coke",1,1,2,"Sprite","",1,0,1,"PM2","",1,0,1]
[null,"The Grey cells provide additional information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke","Pepsi Max",1,1,2,"Sprite","",1,0,1,"PM2","",1,0,1]
[null,null,"For more information on Perceptual Maps visit:",null,null,null," www.perceptualmaps.com",null,null,null,"Or email: geoff@perceptualmaps.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke","PM2",1,1,2,"Sprite","",1,0,1,"PM2","",1,0,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,"Coke","",1,0,1,"Sprite","",1,0,1,"PM2","",1,0,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,"Coke","",1,0,1,"Sprite","",1,0,1,"PM2","",1,0,1]
[null,"STEP ONE","Enter the Title of Your Map",null,"Soft Drink Year 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke","",1,0,1,"Sprite","",1,0,1,{"$f":"IF(D$24<>\"\",D$24,\"\")","v":""},{"$f":"IF(D25<>\"\",D25,\"\")","v":""},0,0,0]
[null,null,null,null,"(This is an example only. Simply type over this map title.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coke","",1,0,1,{"$f":"IF(D$21<>\"\",D$21,\"\")","v":"Diet Coke"},{"$f":"IF(D22<>\"\",D22,\"\")","v":"Pepsi Max"},1,1,2,{"$f":"IF(D$24<>\"\",D$24,\"\")","v":""},{"$f":"IF(D26<>\"\",D26,\"\")","v":""},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,"Coke","",1,0,1,"Diet Coke","PM2",1,1,2,{"$f":"IF(D$24<>\"\",D$24,\"\")","v":""},{"$f":"IF(D27<>\"\",D27,\"\")","v":""},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,"Coke","",1,0,1,"Diet Coke","",1,0,1,{"$f":"IF(D$24<>\"\",D$24,\"\")","v":""},{"$f":"IF(D28<>\"\",D28,\"\")","v":""},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,{"$f":"IF(D$19<>\"\",D$19,\"\")","v":"Pepsi"},{"$f":"IF(D20<>\"\",D20,\"\")","v":"Sprite"},1,1,2,"Diet Coke","",1,0,1,{"$f":"IF(D$24<>\"\",D$24,\"\")","v":""},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},0,0,0]
[null,"STEP TWO","Enter Brands Below",null,"STEP THREE ==>",null,"Compare EACH pair of brands below    Note: If you have less than 12 brands some blanks cells will appear - only enter the data for the pairs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi","Diet Coke",1,1,2,"Diet Coke","",1,0,1,{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},{"$f":"IF(D26<>\"\",D26,\"\")","v":""},0,0,0]
[null,null,"You may enter up to 12 brands",null,null,"Compare using a 1-9 scale, where 1= Virtually the Same and 9 = Virtually Opposites",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi","Pepsi Max",1,1,2,"Diet Coke","",1,0,1,{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},{"$f":"IF(D27<>\"\",D27,\"\")","v":""},0,0,0]
[null,null,"Some examples provided, simply type over the top to enter your own brands",null,null,"Please note that the brand pair sets below should update automatically when you enter the brands in                  Step Two (left).  If not, press F9 at the top of your keyboard to recalculate the spreadsheet. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi","PM2",1,1,2,"Diet Coke","",1,0,1,{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},{"$f":"IF(D28<>\"\",D28,\"\")","v":""},0,0,0]
[null,null,1,"Coke",null,{"$f":"IF(AD3=2,Z3,\"\")","v":"Coke"},{"$f":"IF(AD3=2,AA3,\"\")","v":"Pepsi"},1,{"$f":"IF(AI3=2,AE3,\"\")","v":"Sprite"},{"$f":"IF(AI3=2,AF3,\"\")","v":"Pepsi Max"},6,{"$f":"IF(AN3=2,AJ3,\"\")","v":""},{"$f":"IF(AN3=2,AK3,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi","",1,0,1,"Diet Coke","",1,0,1,{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},0,0,0]
[null,null,2,"Pepsi",null,{"$f":"IF(AD4=2,Z4,\"\")","v":"Coke"},{"$f":"IF(AD4=2,AA4,\"\")","v":"Sprite"},9,{"$f":"IF(AI4=2,AE4,\"\")","v":"Sprite"},{"$f":"IF(AI4=2,AF4,\"\")","v":"PM2"},6,{"$f":"IF(AN4=2,AJ4,\"\")","v":""},{"$f":"IF(AN4=2,AK4,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi","",1,0,1,{"$f":"IF(D$22<>\"\",D$22,\"\")","v":"Pepsi Max"},{"$f":"IF(D23<>\"\",D23,\"\")","v":"PM2"},1,1,2,{"$f":"IF(D$26<>\"\",D$26,\"\")","v":""},{"$f":"IF(D27<>\"\",D27,\"\")","v":""},0,0,0]
[null,null,3,"Sprite",null,"Coke","Diet Coke",3,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi","",1,0,1,"Pepsi Max","",1,0,1,{"$f":"IF(D$26<>\"\",D$26,\"\")","v":""},{"$f":"IF(D28<>\"\",D28,\"\")","v":""},0,0,0]
[null,null,4,"Diet Coke",null,"Coke","Pepsi Max",4,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi","",1,0,1,"Pepsi Max","",1,0,1,{"$f":"IF(D$26<>\"\",D$26,\"\")","v":""},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},0,0,0]
[null,null,5,"Pepsi Max",null,"Coke","PM2",4,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi","",1,0,1,"Pepsi Max","",1,0,1,{"$f":"IF(D$27<>\"\",D$27,\"\")","v":""},{"$f":"IF(D28<>\"\",D28,\"\")","v":""},0,0,0]
[null,null,6,"PM2",null,"","",null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,"Pepsi","",1,0,1,"Pepsi Max","",1,0,1,{"$f":"IF(D$27<>\"\",D$27,\"\")","v":""},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},0,0,0]
[null,null,7,null,null,"","",null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D$20<>\"\",D$20,\"\")","v":"Sprite"},{"$f":"IF(D21<>\"\",D21,\"\")","v":"Diet Coke"},1,1,2,"Pepsi Max","",1,0,1,{"$f":"IF(D$28<>\"\",D$28,\"\")","v":""},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},0,0,0]
[null,null,8,null,null,"","",null,"","",null,"",""]
[null,null,9,null,null,"","",null,"Diet Coke","Pepsi Max",1.25,"",""]
[null,null,10,null,null,"","",null,"Diet Coke","PM2",1.3,"",""]
[null,null,11,null,null,"","",null,"","",null,"",""]
[null,null,12,null,null,"Pepsi","Sprite",7,"","",null,"",""]
[null,null,"Compare using a 1-9 scale",null,null,"Pepsi","Diet Coke",5,"","",null,"",""]
[null,null,"1 = Virtually the same",null,null,"Pepsi","Pepsi Max",2.5,"","",null,"",""]
[null,null,"2 = Quite similar",null,null,"Pepsi","PM2",2.5,"","",null,"",""]
[null,null,"3 = Reasonably similar",null,null,"","",null,"","",null,"",""]
[null,null,"4 = Somewhat similar",null,null,"","",null,"Pepsi Max","PM2",1,"",""]
[null,null,"5 = Neither (or unsure)",null,null,"","",null,"","",null,"",""]
[null,null,"6 = Somewhat dissimilar",null,null,"","",null,"","",null,"",""]
[null,null,"7 = Reasonably dissimilar",null,null,"","",null,"","",null,"",""]
[null,null,"8 = Quite dissimilar",null,null,"","",null,"","",null,"",""]
[null,null,"9 = Virtually opposites",null,null,"Sprite","Diet Coke",5,"","",null,"",""]
[]
[]
[]
[]
[null,null,null,null,null,"Important Note for Apple Mac users"]
[null,null,null,"STEP FOUR","Ensure that your spreadsheet has the 'Solver add-in' loaded"]
[null,null,null,null,"In the top menu of Excel click \"File\" then select \"Options\" and then select \"Add-Ins\""]
[null,null,null,null,"Then click 'Go' next to 'Manage Excel Add-ins' and select the 'Solver Add-in' (as shown below)"]
[null,"STEP FIVE",null,"Follow the sequence as shown","Please note that these options are standard with every version of Excel, including the student version",null,null,null,null,null,null,null,null,null,"ATTENTION APPLE MAC USERS!!!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not follow the instructions in Step Four"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instead, select 'Tools', then 'Add-ins' and then 'Solver'"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You will also need to follow Step Six below",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculating your perceptual map. This may take several minutes."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Part C: Select Go"]
[null,null,null,"Part A: Select Options",null,null,null,null,null,null,"Part D: Tick Solver Add-in",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH63","v":"Coke"},{"$f":"+AH64","v":"Pepsi"},{"$f":"+AH65","v":"Sprite"},{"$f":"+AH66","v":"Diet Coke"},{"$f":"+AH67","v":"Pepsi Max"},{"$f":"+AH68","v":"PM2"},{"$f":"+AH69","v":""},{"$f":"+AH70","v":""},{"$f":"+AH71","v":""},{"$f":"+AH72","v":""},{"$f":"+AH73","v":""},{"$f":"+AH74","v":""},null,null,null,null,{"$f":"+AI62","v":"Coke"},{"$f":"+AJ62","v":"Pepsi"},"Sprite","Diet Coke","Pepsi Max","PM2",{"$f":"+AO62","v":""},{"$f":"+AP62","v":""},{"$f":"+AQ62","v":""},{"$f":"+AR62","v":""},{"$f":"+AS62","v":""},{"$f":"+AT62","v":""}]
[null,null,null,null,"Part B: Select Add-ins",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,null,1,{"$f":"IF(D18=\"\",\"\",+D18)","v":"Coke"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH63","v":"Coke"},{"$f":"IFERROR((AI63-AI90)^2,\"\")","v":0},{"$f":"IFERROR((AJ63-AJ90)^2,\"\")","v":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,{"$f":"IF($AI64=\"\",0,+$AI64)","v":1},{"$f":"IF($AI64=\"\",0,0)","v":0},null,{"$f":"+AG63+1","v":2},"Pepsi",{"$f":"+H18","v":1},0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH64","v":"Pepsi"},{"$f":"IFERROR((AI64-AI91)^2,\"\")","v":0.890660221930762},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,{"$f":"IF($AI65=\"\",0,0)","v":0},{"$f":"IF($AI65=\"\",0,+$AI65)","v":9},null,{"$f":"+AG64+1","v":3},"Sprite",{"$f":"+H19","v":9},{"$f":"+H29","v":7},0,null,null,null,null,null,null,null,null,null,null,null,null,"Sprite",7.66324812902009,3.1684758257658072,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,{"$f":"IF($AI66=\"\",0,+$AI66)","v":3},{"$f":"IF($AI66=\"\",0,0)","v":0},null,4,"Diet Coke",3,{"$f":"+H30","v":5},{"$f":"+H39","v":5},0,null,null,null,null,null,null,null,null,null,null,null,"Diet Coke",7.0885498231937016E-2,3.6581839081724552,2.1952104454280086,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,{"$f":"IF($AI67=\"\",0,0)","v":0},{"$f":"IF($AI67=\"\",0,+$AI67)","v":4},null,5,"Pepsi Max",4,2.5,{"$f":"+K18","v":6},{"$f":"+K26","v":1.25},0,null,null,null,null,null,null,null,null,null,null,"Pepsi Max",2.6839531520009685,2.6563115284879407E-2,2.1557341790299791,1.2099333107845973,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,{"$f":"IF($AI68=\"\",0,+$AI68)","v":4},{"$f":"IF($AI68=\"\",0,0)","v":0},null,6,"PM2",4,2.5,{"$f":"+K19","v":6},{"$f":"+K27","v":1.3},{"$f":"+K34","v":1},0,null,null,null,null,null,null,null,null,null,"PM2",2.787655897252928,3.7326671199610542E-2,2.1527527275965332,1.3089342777920567,0.99978737416963359,0,0,0,0,0,0,0]
[null,null,null,"STEP FIVE","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($AI69=\"\",0,0)","v":0},{"$f":"IF($AI69=\"\",0,+$AI69)","v":0},null,7,"",0,0,0,0,{"$f":"+K35","v":0},{"$f":"+N19","v":0},0,null,null,null,null,null,null,null,null,"",2.0067199535733038,1.1883972406686452,4.5305995059879569,0.7080381277419675,0.68906056442812791,0.67264509522125815,0,0,0,0,0,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($AI70=\"\",0,+$AI70)","v":0},{"$f":"IF($AI70=\"\",0,0)","v":0},null,8,"",0,0,0,0,0,{"$f":"+N20","v":0},{"$f":"+N25","v":0},0,null,null,null,null,null,null,null,"",2.0239885808240841,1.2017097473473166,4.5248088849144894,0.69796717798337171,0.68153074048304396,0.66531959076985137,1.4694605546076638E-10,0,0,0,0,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($AI71=\"\",0,0)","v":0},{"$f":"IF($AI71=\"\",0,+$AI71)","v":0},null,9,"",0,0,0,0,0,0,{"$f":"+N26","v":0},{"$f":"+N30","v":0},0,null,null,null,null,null,null,"",2.0202448493273653,1.2006129781584185,4.5445853684862572,0.69381161566632987,0.67615897630326638,0.66002590813184392,4.6595912667711752E-10,1.3290274081949081E-11,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,{"$f":"IF($AI72=\"\",0,+$AI72)","v":0},{"$f":"IF($AI72=\"\",0,0)","v":0},null,10,"",0,0,0,0,0,0,0,{"$f":"+N31","v":0},{"$f":"+N34","v":0},0,null,null,null,null,null,"",2.0252338958177525,1.1998198849283856,4.4950875037988816,0.70740258104103459,0.69222336660237249,0.67583121913675448,7.8998286567008287E-11,1.6090740550676635E-10,8.7191847255190578E-10,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,{"$f":"IF($AI73=\"\",0,0)","v":0},{"$f":"IF($AI73=\"\",0,+$AI73)","v":0},null,11,"",0,0,0,0,0,0,0,0,{"$f":"+N35","v":0},{"$f":"+N37","v":0},0,null,null,null,null,"",2.0226820771309795,1.2009511158629775,4.5278143901400822,0.69784076664041172,0.68112037430776895,0.66491089582175045,1.414452735212515E-10,3.4471877833412589E-15,8.7235142790556103E-12,1.9206660580022364E-10,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,{"$f":"IF($AI74=\"\",0,+$AI74)","v":0},{"$f":"IF($AI74=\"\",0,0)","v":0},null,12,"",0,0,0,0,{"$f":"+N18","v":0},0,0,0,0,{"$f":"+N38","v":0},{"$f":"+N39","v":0},0,null,null,null,"",2.0356242254426822,1.2110163120109976,4.5243627347051216,0.69014996538537987,0.67527275262855435,0.65921939843189159,1.3914846736567758E-9,4.8315048590782596E-11,2.6523741953886226E-11,1.1095531723407019E-9,5.008368858539747E-11,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduce",{"$f":"SQRT(SUM(AY63:BJ74))","v":9.4753413186131255}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 one"]
[]
[null,null,null,"STEP SIX"]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AI63:AI86)","v":21},{"$f":"SUM(AJ63:AJ86)","v":17},17,2.5499999999999998,1,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,"Final points",null,null,null,null,null,null,null,null,null,null,{"$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":0},{"$f":"+AF97","v":0},{"$f":"+AF98","v":0},{"$f":"+AF99","v":0},{"$f":"+AF100","v":0},{"$f":"+AF101","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,{"$f":"+IF($AF90=1,(AC90+$AD$117)*$AD$119,\"\")","v":2.0957904291504326},{"$f":"+IF($AF90=1,(AD90+$AD$117)*$AD$119,\"\")","v":5.4800211180625453},null,3.0037724028754775,4.6185477362488498,null,{"$f":"IF(D18=\"\",0,1)","v":1},null,{"$f":"+AH63","v":"Coke"},{"$f":"IFERROR(SUMXMY2(AC$90:AD$90,AC90:AD90),\"\")","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,{"$f":"+IF($AF91=1,(AC91+$AD$117)*$AD$119,\"\")","v":2.3852805175298037},{"$f":"+IF($AF91=1,(AD91+$AD$117)*$AD$119,\"\")","v":5.8840921658535406},null,3.1419017140665404,4.8113490021439294,null,{"$f":"IF(D19=\"\",0,1)","v":1},null,{"$f":"+AH64","v":"Pepsi"},{"$f":"IFERROR(SUMXMY2(AC$90:AD$90,AC91:AD91),\"\")","v":5.6252034740862634E-2},{"$f":"IFERROR(SUMXMY2(AC$91:AD$91,AC91:AD91),\"\")","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,6.6807248896011648,8,null,5.1914598723279077,5.8209479604730703,null,1,null,"Sprite",6.2317427632136333,{"$f":"IFERROR(SUMXMY2(AC$91:AD$91,AC92:AD92),\"\")","v":5.2199787007550142},{"$f":"IFERROR(SUMXMY2(AC$92:AD$92,AC92:AD92),\"\")","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,5.6617677742375454,4.2032092257902107,null,4.7052675979521377,4.0093208428948639,null,1,null,"Diet Coke",3.2662433064547107,3.0873620551258387,{"$f":"IFERROR(SUMXMY2(AC$92:AD$92,AC93:AD93),\"\")","v":3.5183757408074041},{"$f":"IFERROR(SUMXMY2(AC$93:AD$93,AC93:AD93),\"\")","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,4.9061096735265215,3.9066209400164351,null,4.3447076439602954,3.8678046485041859,null,1,null,"Pepsi Max",2.3617225045795909,2.337018052273022,4.5317581333343,{"$f":"IFERROR(SUMXMY2(AC$93:AD$93,AC94:AD94),\"\")","v":0.15003031369741957},{"$f":"IFERROR(SUMXMY2(AC$94:AD$94,AC94:AD94),\"\")","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,4.8861090552681965,3.9148039896014439,null,4.3351644100662305,3.8717091656119988,null,1,null,"PM2",2.3303725274023166,2.3067988840622018,4.532773798081382,0.15591334340791446,{"$f":"IFERROR(SUMXMY2(AC$94:AD$94,AC95:AD95),\"\")","v":1.0631856700203217E-4},{"$f":"IFERROR(SUMXMY2(AC$95:AD$95,AC95:AD95),\"\")","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,4.1849589061314036,4.7647868449193664,null,0,null,"",1.4165874323787091,1.0901363404036419,2.1285204969621403,0.84145001499908922,0.83009671992372547,{"$f":"IFERROR(SUMXMY2(AC$95:AD$95,AC96:AD96),\"\")","v":0.82014943468934864},{"$f":"IFERROR(SUMXMY2(AC$96:AD$96,AC96:AD96),\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"STEP SEVEN ",null,"Copy Your Map to Word or PP",null,null,null,null,null,null,null,null,null,null,"","",null,4.1877808282752973,4.7627475101681913,null,0,null,"",1.4226695262161497,1.0962252265603618,2.1271598164958103,0.83544429974916445,0.82554875112439241,0.81567125165096466,{"$f":"IFERROR(SUMXMY2(AC$96:AD$96,AC97:AD97),\"\")","v":1.2122130813547855E-5},{"$f":"IFERROR(SUMXMY2(AC$97:AD$97,AC97:AD97),\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"To maintain the formatting of the map ",null,null,null,null,null,null,null,null,null,null,null,null,"","",null,4.1874524745977428,4.7608666149876173,null,0,null,"",1.4213531754378872,1.0957248642603756,2.1318033137431458,0.83295354952501999,0.82228886427049852,0.81241978566000217,2.1586086414102893E-5,{"$f":"IFERROR(SUMXMY2(AC$97:AD$97,AC98:AD98),\"\")","v":3.6455828178700152E-6},{"$f":"IFERROR(SUMXMY2(AC$98:AD$98,AC98:AD98),\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"when you copy it:",null,null,null,null,null,null,null,null,null,null,null,null,"","",null,4.1875276014145228,4.766300087322664,null,0,null,"",1.4231071273160543,1.0953629010188293,2.1201621409219817,0.84107228050925242,0.83199961935230027,0.82208954447599836,8.8880980286565409E-6,1.2684928281498731E-5,{"$f":"IFERROR(SUMXMY2(AC$98:AD$98,AC99:AD99),\"\")","v":2.9528265654316811E-5},{"$f":"IFERROR(SUMXMY2(AC$99:AD$99,AC99:AD99),\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,1,"Click on the edge of the map",null,null,null,null,null,null,null,null,null,null,null,"","",null,4.1876074858380141,4.7625782022947751,null,0,null,"",1.4222102788023223,1.0958791520340998,2.127866158887838,0.83536864116413401,0.82530017224508623,0.81542068640778942,1.1893076705430412E-5,5.8712756563980701E-8,2.953559594634178E-6,{"$f":"IFERROR(SUMXMY2(AC$99:AD$99,AC100:AD100),\"\")","v":1.3858809681939631E-5},{"$f":"IFERROR(SUMXMY2(AC$100:AD$100,AC100:AD100),\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"to highlight it",null,null,null,null,null,null,null,null,null,null,null,"","",null,4.1897198907753008,4.7609611901132265,null,0,null,"",1.4267530358974823,1.1004618630425125,2.1270549439789095,0.83075264994183429,0.82174981145635462,0.81192327127130159,3.7302609475166424E-5,6.9509027176894512E-6,5.1501205766356797E-6,3.3309956054319583E-5,{"$f":"IFERROR(SUMXMY2(AC$100:AD$100,AC101:AD101),\"\")","v":7.0769830143499336E-6},{"$f":"IFERROR(SUMXMY2(AC$101:AD$101,AC101:AD101),\"\")","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,{"$f":"IF($AF102=1,AI102,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR($AF102=0,AV$89=0),\"\",SQRT(($AI$101-$AI102)^2+($AJ$101-$AJ102)^2)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,2,"Select 'copy' from the above menu",null,null,null,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR($AF103=0,AV$89=0),\"\",SQRT(($AI$101-$AI103)^2+($AJ$101-$AJ103)^2)),\"\")","v":""},{"$f":"IFERROR(IF(OR($AF103=0,AW$89=0),\"\",SQRT(($AI$102-$AI103)^2+($AJ$102-$AJ103)^2)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(IF(OR($AF104=0,AW$89=0),\"\",SQRT(($AI$102-$AI104)^2+($AJ$102-$AJ104)^2)),\"\")","v":""},{"$f":"IFERROR(IF(OR($AF104=0,AX$89=0),\"\",SQRT(($AI$103-$AI104)^2+($AJ$103-$AJ104)^2)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Go to your Word or P/Point document",null,null,null,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",{"$f":"IFERROR(IF(OR($AF105=0,AX$89=0),\"\",SQRT(($AI$103-$AI105)^2+($AJ$103-$AJ105)^2)),\"\")","v":""},{"$f":"IFERROR(IF(OR($AF105=0,AY$89=0),\"\",SQRT(($AI$104-$AI105)^2+($AJ$104-$AJ105)^2)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(IF(OR($AF106=0,AY$89=0),\"\",SQRT(($AI$104-$AI106)^2+($AJ$104-$AJ106)^2)),\"\")","v":""},{"$f":"IFERROR(IF(OR($AF106=0,AZ$89=0),\"\",SQRT(($AI$105-$AI106)^2+($AJ$105-$AJ106)^2)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Select 'paste', then 'paste special'",null,null,null,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IFERROR(IF(OR($AF107=0,AZ$89=0),\"\",SQRT(($AI$105-$AI107)^2+($AJ$105-$AJ107)^2)),\"\")","v":""},{"$f":"IFERROR(IF(OR($AF107=0,BA$89=0),\"\",SQRT(($AI$106-$AI107)^2+($AJ$106-$AJ107)^2)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"and choose 'picture'.",null,null,null,null,null,null,null,null,null,null,null,"","",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","",{"$f":"IFERROR(IF(OR($AF108=0,BA$89=0),\"\",SQRT(($AI$106-$AI108)^2+($AJ$106-$AJ108)^2)),\"\")","v":""},{"$f":"IFERROR(IF(OR($AF108=0,BB$89=0),\"\",SQRT(($AI$107-$AI108)^2+($AJ$107-$AJ108)^2)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(IF(OR($AF109=0,BB$89=0),\"\",SQRT(($AI$107-$AI109)^2+($AJ$107-$AJ109)^2)),\"\")","v":""},{"$f":"IFERROR(IF(OR($AF109=0,BC$89=0),\"\",SQRT(($AI$108-$AI109)^2+($AJ$108-$AJ109)^2)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(IF(OR($AF110=0,BC$89=0),\"\",SQRT(($AI$108-$AI110)^2+($AJ$108-$AJ110)^2)),\"\")","v":""},{"$f":"IFERROR(IF(OR($AF110=0,BD$89=0),\"\",SQRT(($AI$109-$AI110)^2+($AJ$109-$AJ110)^2)),\"\")","v":""}]
[null,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($AF111=1,(AC111+$AD$117)*$AD$119,\"\")","v":""},"",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",{"$f":"IFERROR(IF(OR($AF111=0,BD$89=0),\"\",SQRT(($AI$109-$AI111)^2+($AJ$109-$AJ111)^2)),\"\")","v":""},{"$f":"IFERROR(IF(OR($AF111=0,BE$89=0),\"\",SQRT(($AI$110-$AI111)^2+($AJ$110-$AJ111)^2)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(IF(OR($AF112=0,BE$89=0),\"\",SQRT(($AI$110-$AI112)^2+($AJ$110-$AJ112)^2)),\"\")","v":""},{"$f":"IFERROR(IF(OR($AF112=0,BF$89=0),\"\",SQRT(($AI$111-$AI112)^2+($AJ$111-$AJ112)^2)),\"\")","v":""}]
[null,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($AF113=1,(AC113+$AD$117)*$AD$119,\"\")","v":""},{"$f":"+IF($AF113=1,(AD113+$AD$117)*$AD$119,\"\")","v":""},null,{"$f":"IF($AF113=1,AI113,\"\")","v":""},{"$f":"IF($AF113=1,AJ113,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",{"$f":"IFERROR(IF(OR($AF113=0,BF$89=0),\"\",SQRT(($AI$111-$AI113)^2+($AJ$111-$AJ113)^2)),\"\")","v":""},{"$f":"IFERROR(IF(OR($AF113=0,BG$89=0),\"\",SQRT(($AI$112-$AI113)^2+($AJ$112-$AJ113)^2)),\"\")","v":""}]
[null,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(Z90:AA112)","v":2.0957904291504326},null,"Min",{"$f":"MIN(AC90:AD112)","v":3.0037724028754775},null,null,null,null,null,null,{"$f":"IF(AK89=1,SUM(AK90:AK113),\"\")","v":25.345474543212909},{"$f":"IF(AL89=1,SUM(AL90:AL113),\"\")","v":5.3229850929938278},4.9570902569393596,4.8976739741554054,9.1792001436904122E-5,2.3340126573622179E-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,"Max",{"$f":"MAX(Z90:AA112)","v":8},null,"Max",{"$f":"MAX(AC90:AD112)","v":5.8209479604730703}]
[null,null,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":"+AA115-AA114","v":5.9042095708495674},null,null,{"$f":"+AD115-AD114","v":2.8171755575975927}]
[null,null,null,null,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-AD114","v":-2.0037724028754775}]
[null,null,null,null,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":"+AD117+AD115","v":3.8171755575975927}]
[null,null,null,null,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/AD118","v":2.0957904291504326}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,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":"+AH90","v":"Coke"},null,null,{"$f":"IFERROR(AK90^2,\"\")","v":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(AK91^2,\"\")","v":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(AK92^2,\"\")","v":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(AK93^2,\"\")","v":12.378967853502049},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(AK94^2,\"\")","v":20.536831779041581},2.2509095028146121E-2,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,"PM2",null,null,{"$f":"IFERROR(AK95^2,\"\")","v":20.546038304573116},2.4308970652634265E-2,1.1303637689365602E-8,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,"",null,null,{"$f":"IFERROR(AK96^2,\"\")","v":4.5305995059879569},0.7080381277419675,0.68906056442812791,0.67264509522125815,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,"",null,null,{"$f":"IFERROR(AK97^2,\"\")","v":4.5248088849144894},0.69796717798337171,0.68153074048304396,0.66531959076985137,1.4694605546076638E-10,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,"",null,null,{"$f":"IFERROR(AK98^2,\"\")","v":4.5445853684862572},0.69381161566632987,0.67615897630326638,0.66002590813184392,4.6595912667711752E-10,1.3290274081949081E-11,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,"",null,null,{"$f":"IFERROR(AK99^2,\"\")","v":4.4950875037988816},0.70740258104103459,0.69222336660237249,0.67583121913675448,7.8998286567008287E-11,1.6090740550676635E-10,8.7191847255190578E-10,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,"",null,null,{"$f":"IFERROR(AK100^2,\"\")","v":4.5278143901400822},0.69784076664041172,0.68112037430776895,0.66491089582175045,1.414452735212515E-10,3.4471877833412589E-15,8.7235142790556103E-12,1.9206660580022364E-10,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,"",null,null,{"$f":"IFERROR(AK101^2,\"\")","v":4.5243627347051216},0.69014996538537987,0.67527275262855435,0.65921939843189159,1.3914846736567758E-9,4.8315048590782596E-11,2.6523741953886226E-11,1.1095531723407019E-9,5.008368858539747E-11,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,{"$f":"SUM(AK172:AU172)","v":92.944443523565155},null,null,{"$f":"SUM(AK148:AK171)","v":80.609096325149537},{"$f":"SUM(AL148:AL171)","v":4.2420283001392756},4.095366786056772,3.9979521075133504,2.2248334158829194E-9,2.2251617536728137E-10,9.0716572878484768E-10,1.3016197781409256E-9,5.008368858539747E-11,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,{"$f":"+AH148","v":"Coke"},null,null,{"$f":"IFERROR((AK90-AI63)^2,\"\")","v":0},{"$f":"IFERROR((AL90-AJ63)^2,\"\")","v":0},{"$f":"IFERROR((AM90-AK63)^2,\"\")","v":0},{"$f":"IFERROR((AN90-AL63)^2,\"\")","v":0},{"$f":"IFERROR((AO90-AM63)^2,\"\")","v":0},{"$f":"IFERROR((AP90-AN63)^2,\"\")","v":0},{"$f":"IFERROR((AQ90-AO63)^2,\"\")","v":0},{"$f":"IFERROR((AR90-AP63)^2,\"\")","v":0},{"$f":"IFERROR((AS90-AQ63)^2,\"\")","v":0},{"$f":"IFERROR((AT90-AR63)^2,\"\")","v":0},{"$f":"IFERROR((AU90-AS63)^2,\"\")","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,"Pepsi",null,null,{"$f":"IFERROR((AK91-AI64)^2,\"\")","v":1},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,81,49,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,0.268713408657625,25,25,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,0.28276671236717915,5.5223575265410476,36,1.5625,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,"PM2",null,null,0.28384791992206121,5.4947422536130617,35.998724188499615,1.6900000000000002,1,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,"",null,null,4.5305995059879569,0.7080381277419675,0.68906056442812791,0.67264509522125815,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,"",null,null,4.5248088849144894,0.69796717798337171,0.68153074048304396,0.66531959076985137,1.4694605546076638E-10,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,"",null,null,4.5445853684862572,0.69381161566632987,0.67615897630326638,0.66002590813184392,4.6595912667711752E-10,1.3290274081949081E-11,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,"",null,null,4.4950875037988816,0.70740258104103459,0.69222336660237249,0.67583121913675448,7.8998286567008287E-11,1.6090740550676635E-10,8.7191847255190578E-10,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,"",null,null,4.5278143901400822,0.69784076664041172,0.68112037430776895,0.66491089582175045,1.414452735212515E-10,3.4471877833412589E-15,8.7235142790556103E-12,1.9206660580022364E-10,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,"",null,null,4.5243627347051216,0.69014996538537987,0.67527275262855435,0.65921939843189159,1.3914846736567758E-9,4.8315048590782596E-11,2.6523741953886226E-11,1.1095531723407019E-9,5.008368858539747E-11,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,{"$f":"SUM(AK199:BH199)","v":308.53943951906462},null,null,{"$f":"SUM(AK175:AK198)","v":109.98258642897964},{"$f":"SUM(AL175:AL198)","v":89.212310014612598},101.09409096325275,7.2504521075133495,1.0000000022248334,2.2251617536728137E-10,9.0716572878484768E-10,1.3016197781409256E-9,5.008368858539747E-11,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,{"$f":"SQRT(AH199/AH172)","v":1.8219800921764184},null,null,1,{"$f":"+AH175","v":"Coke"},{"$f":"+Z90","v":2.0957904291504326},{"$f":"+AA90","v":5.4800211180625453}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"+AH176","v":"Pepsi"},{"$f":"+Z91","v":2.3852805175298037},5.8840921658535406]
[null,null,null,null,null,null,null,null,null,null,null,null,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,"Sprite",{"$f":"+Z92","v":6.6807248896011648},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,null,null,null,4,"Diet Coke",{"$f":"+Z93","v":5.6617677742375454},4.2032092257902107]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"+Z94","v":4.9061096735265215},3.9066209400164351]
[null,null,null,null,null,null,null,null,null,null,null,null,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,"PM2",{"$f":"+Z95","v":4.8861090552681965},3.9148039896014439]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"+Z96","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"+Z97","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"+Z98","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"+Z99","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"+Z100","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"+Z101","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+AA102","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+AA103","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+AA104","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+AA106","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+AA107","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+AA108","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+AA109","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+AA110","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+AA111","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+AA112","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+AA113","v":""}]