{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Brand Map","How to Add Solver"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":77,"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":"Brand Map","index":0,"n_rows":233,"n_cols":62,"rows_kept":233,"cut":false,"hidden":false,"merged":[[58,15,58,18],[55,4,55,8],[55,2,56,3],[43,5,43,12],[50,14,50,19],[38,2,38,3],[47,14,47,19],[48,14,48,19],[49,14,49,19],[42,4,42,11],[14,2,14,3],[14,4,14,5],[14,6,14,13],[60,7,60,9],[40,4,40,11],[41,4,41,11],[33,2,33,3],[34,2,34,3],[35,2,35,3],[53,9,53,11],[54,9,54,11],[55,9,55,11],[56,9,56,11],[54,4,54,8],[56,4,56,8],[37,2,37,3],[15,5,15,13],[29,2,29,3],[30,2,30,3],[15,2,15,3],[16,2,16,3],[1,1,1,15],[2,1,2,15],[5,1,5,15],[4,1,4,15],[3,1,3,15],[32,2,32,3],[6,6,6,9],[50,45,54,53],[178,5,178,6],[175,3,175,15],[61,10,61,12],[60,13,60,18],[112,13,112,16],[58,13,58,14],[59,13,59,18],[36,2,36,3],[10,1,10,4],[9,2,9,4],[9,7,9,10],[10,6,10,10],[6,2,6,5],[31,2,31,3],[25,14,25,15],[16,14,16,15],[17,14,17,15],[18,14,18,15],[19,14,19,15],[20,14,20,15],[16,5,16,13],[15,14,15,15],[21,14,21,15],[22,14,22,15],[23,14,23,15],[24,14,24,15]]}
[]
[null,"Welcome to \"Create Your Own Brand Association 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":"Enter in Step 2"},{"$f":"IF(D19<>\"\",D19,\"\")","v":""},{"$f":"IF(Z3<>\"\",1,0)","v":1},{"$f":"IF(AA3<>\"\",1,0)","v":0},{"$f":"+AC3+AB3","v":1},{"$f":"IF(D$20<>\"\",D$20,\"\")","v":""},{"$f":"IF(D22<>\"\",D22,\"\")","v":""},{"$f":"IF(AE3<>\"\",1,0)","v":0},{"$f":"IF(AF3<>\"\",1,0)","v":0},{"$f":"+AH3+AG3","v":0},{"$f":"IF(D$22<>\"\",D$22,\"\")","v":""},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},{"$f":"IF(AJ3<>\"\",1,0)","v":0},{"$f":"IF(AK3<>\"\",1,0)","v":0},{"$f":"+AM3+AL3","v":0}]
[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,"Enter in Step 2","",{"$f":"IF(Z4<>\"\",1,0)","v":1},{"$f":"IF(AA4<>\"\",1,0)","v":0},{"$f":"+AC4+AB4","v":1},"","",{"$f":"IF(AE4<>\"\",1,0)","v":0},{"$f":"IF(AF4<>\"\",1,0)","v":0},{"$f":"+AH4+AG4","v":0},{"$f":"IF(D$23<>\"\",D$23,\"\")","v":""},{"$f":"IF(D24<>\"\",D24,\"\")","v":""},{"$f":"IF(AJ4<>\"\",1,0)","v":0},{"$f":"IF(AK4<>\"\",1,0)","v":0},{"$f":"+AM4+AL4","v":0}]
[null,"Only enter data/information in the Blue cells - type over any example data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter in Step 2","",1,0,1,"","",0,0,0,"","",0,0,0]
[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,"Enter in Step 2","",1,0,1,"","",0,0,0,"","",0,0,0]
[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,"Enter in Step 2","",1,0,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,"Enter in Step 2","",1,0,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,"Enter in Step 2","",1,0,1,"","",0,0,0,"","",0,0,0]
[null,"STEP 1","Enter the Title of Your Map",null,null,null,"STEP 2","Enter Your Brand Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter in Step 2","",1,0,1,"","",0,0,0,{"$f":"IF(D$24<>\"\",D$24,\"\")","v":""},{"$f":"IF(D25<>\"\",D25,\"\")","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,"Enter in Step 2","",1,0,1,{"$f":"IF(D$21<>\"\",D$21,\"\")","v":""},{"$f":"IF(D22<>\"\",D22,\"\")","v":""},0,0,0,{"$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,"Enter in Step 2","",1,0,1,"","",0,0,0,{"$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,"Enter in Step 2","",1,0,1,"","",0,0,0,{"$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":""},{"$f":"IF(D20<>\"\",D20,\"\")","v":""},0,0,0,"","",0,0,0,{"$f":"IF(D$24<>\"\",D$24,\"\")","v":""},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},0,0,0]
[null,"STEP 3","Enter List of Associations and Attributes Below",null,"STEP 4 ==>",null,"Compare EACH pair below    Note: If you have less than 12 listed in Step 3. then some blanks cells will appear - only enter the data for the listed pairs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",0,0,0,"","",0,0,0,{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},{"$f":"IF(D26<>\"\",D26,\"\")","v":""},0,0,0]
[null,null,"You may enter up to 11 brands, associations, attitudes, segments, and/or differences",null,null,"Compare using a 1-9 scale, where 1= Virtually the Same and 9 = Virtual Opposites",null,null,null,null,null,null,null,null,"IMPORTANT",null,null,null,null,null,null,null,null,null,null,"","",0,0,0,"","",0,0,0,{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},{"$f":"IF(D27<>\"\",D27,\"\")","v":""},0,0,0]
[null,null,"Some examples provided, simply type over",null,null,"Please note that the pair sets below will update automatically when you enter the list of associations in Step 3.      If not, your spreadsheet may be set to manual recalculation.",null,null,null,null,null,null,null,null,"Compare using a 1-9 scale",null,null,null,null,null,null,null,null,null,null,"","",0,0,0,"","",0,0,0,{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},{"$f":"IF(D28<>\"\",D28,\"\")","v":""},0,0,0]
[null,"Enter brand in Step 2",1,{"$f":"IF(G11<>\"\",G11,\"Enter in Step 2\")","v":"Enter in Step 2"},null,{"$f":"IF(AD3=2,Z3,\"\")","v":""},{"$f":"IF(AD3=2,AA3,\"\")","v":""},null,{"$f":"IF(AI3=2,AE3,\"\")","v":""},{"$f":"IF(AI3=2,AF3,\"\")","v":""},null,{"$f":"IF(AN3=2,AJ3,\"\")","v":""},{"$f":"IF(AN3=2,AK3,\"\")","v":""},null,"1 = Virtually the same",null,null,null,null,null,null,null,null,null,null,"","",0,0,0,"","",0,0,0,{"$f":"IF(D$25<>\"\",D$25,\"\")","v":""},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},0,0,0]
[null,null,2,null,null,{"$f":"IF(AD4=2,Z4,\"\")","v":""},{"$f":"IF(AD4=2,AA4,\"\")","v":""},null,{"$f":"IF(AI4=2,AE4,\"\")","v":""},{"$f":"IF(AI4=2,AF4,\"\")","v":""},null,{"$f":"IF(AN4=2,AJ4,\"\")","v":""},{"$f":"IF(AN4=2,AK4,\"\")","v":""},null,"2 = Quite similar",null,null,null,null,null,null,null,null,null,null,"","",0,0,0,{"$f":"IF(D$22<>\"\",D$22,\"\")","v":""},{"$f":"IF(D23<>\"\",D23,\"\")","v":""},0,0,0,{"$f":"IF(D$26<>\"\",D$26,\"\")","v":""},{"$f":"IF(D27<>\"\",D27,\"\")","v":""},0,0,0]
[null,null,3,null,null,"","",null,"","",null,"","",null,"3 = Reasonably similar",null,null,null,null,null,null,null,null,null,null,"","",0,0,0,"","",0,0,0,{"$f":"IF(D$26<>\"\",D$26,\"\")","v":""},{"$f":"IF(D28<>\"\",D28,\"\")","v":""},0,0,0]
[null,null,4,null,null,"","",null,"","",null,"","",null,"4 = Somewhat similar",null,null,null,null,null,null,null,null,null,null,"","",0,0,0,"","",0,0,0,{"$f":"IF(D$26<>\"\",D$26,\"\")","v":""},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},0,0,0]
[null,null,5,null,null,"","",null,"","",null,"","",null,"5 = Neither (or unsure)",null,null,null,null,null,null,null,null,null,null,"","",0,0,0,"","",0,0,0,{"$f":"IF(D$27<>\"\",D$27,\"\")","v":""},{"$f":"IF(D28<>\"\",D28,\"\")","v":""},0,0,0]
[null,null,6,null,null,"","",null,"","",null,"","",null,"6 = Somewhat dissimilar",null,null,null,null,null,null,null,null,null,null,"","",0,0,0,"","",0,0,0,{"$f":"IF(D$27<>\"\",D$27,\"\")","v":""},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},0,0,0]
[null,null,7,null,null,"","",null,"","",null,"","",null,"7 = Reasonably dissimilar",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D$20<>\"\",D$20,\"\")","v":""},{"$f":"IF(D21<>\"\",D21,\"\")","v":""},0,0,0,"","",0,0,0,{"$f":"IF(D$28<>\"\",D$28,\"\")","v":""},{"$f":"IF(D29<>\"\",D29,\"\")","v":""},0,0,0]
[null,null,8,null,null,"","",null,"","",null,"","",null,"8 = Quite dissimilar"]
[null,null,9,null,null,"","",null,"","",null,"","",null,"9 = Virtually opposites"]
[null,null,10,null,null,"","",null,"","",null,"",""]
[null,null,11,null,null,"","",null,"","",null,"",""]
[null,null,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,"",""]
[null,null,null,null,null,"","",null,"","",null,"",""]
[null,null,null,null,null,"","",null,"","",null,"",""]
[null,null,null,null,null,"","",null,"","",null,"",""]
[null,null,null,null,null,"","",null,"","",null,"",""]
[null,null,null,null,null,"","",null,"","",null,"",""]
[null,null,null,null,null,"","",null,"","",null,"",""]
[]
[null,null,null,"OPTIONAL STEP","Ensure that your spreadsheet has the 'Solver add-in' loaded"]
[null,null,null,null,"Please refer to \"How to Add Solver\" tab below - Solver is included with Excel, but needs to be turned on"]
[null,null,null,null,"Note: Solver is standard with every version of Excel, including the student version"]
[]
[]
[]
[]
[]
[]
[null,null,null,"STEP 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,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,null,null,"NOTE: This spreadsheet uses multi"]
[null,null,null,null,"Your map will be automatically  generated in 60 seconds or less",null,null,null,null,"dimensional scaling - so running the"]
[null,null,"Cursor will return when the brand association map is ready",null,"Remember to re-rerun your map if you change the data",null,null,null,null,"same data more than once will"]
[null,null,null,null,"If a dialog box should open when running the map, just click \"continue\"",null,null,null,null,"fine-tune the visual results"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"STEP 6 ",null,"Copy Your Map to Word or PP"]
[null,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,"when you copy it:"]
[null,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,null,null,null,null,null,null,"DATA",{"$f":"+AH63","v":"Enter in Step 2"},{"$f":"+AH64","v":""},{"$f":"+AH65","v":""},{"$f":"+AH66","v":""},{"$f":"+AH67","v":""},{"$f":"+AH68","v":""},{"$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":"Enter in Step 2"},{"$f":"+AJ62","v":""},"","","","",{"$f":"+AO62","v":""},{"$f":"+AP62","v":""},{"$f":"+AQ62","v":""},{"$f":"+AR62","v":""},{"$f":"+AS62","v":""},{"$f":"+AT62","v":""}]
[null,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,null,null,4,4,null,1,{"$f":"IF(D18=\"\",\"\",+D18)","v":"Enter in Step 2"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH63","v":"Enter in Step 2"},{"$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":0},{"$f":"IF($AI64=\"\",0,0)","v":0},null,{"$f":"+AG63+1","v":2},"",{"$f":"+H18","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH64","v":""},{"$f":"IFERROR((AI64-AI91)^2,\"\")","v":106.3617108641338},0,0,0,0,0,0,0,0,0,0,0]
[null,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,{"$f":"IF($AI65=\"\",0,0)","v":0},{"$f":"IF($AI65=\"\",0,+$AI65)","v":0},null,{"$f":"+AG64+1","v":3},"",{"$f":"+H19","v":0},{"$f":"+H29","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR((AI65-AI92)^2,\"\")","v":23.35347127659314},766.35870868804761,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":0},{"$f":"IF($AI66=\"\",0,0)","v":0},null,4,"",0,{"$f":"+H30","v":0},{"$f":"+H39","v":0},0,null,null,null,null,null,null,null,null,null,null,null,"",227.6921969092389,1716.0454361769405,17.322080060017992,0,0,0,0,0,0,0,0,0]
[null,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,{"$f":"IF($AI67=\"\",0,0)","v":0},{"$f":"IF($AI67=\"\",0,+$AI67)","v":0},null,5,"",0,0,{"$f":"+K18","v":0},{"$f":"+K26","v":0},0,null,null,null,null,null,null,null,null,null,null,"",1.0013135015874357,80.998880355249668,28.651215756045936,152.03083748818199,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":0},{"$f":"IF($AI68=\"\",0,0)","v":0},null,6,"",0,0,{"$f":"+K19","v":0},{"$f":"+K27","v":0},{"$f":"+K34","v":0},0,null,null,null,null,null,null,null,null,null,"",671.7687238885519,65.28737127231804,1816.9599391433007,2251.7719498918214,358.24469962380562,0,0,0,0,0,0,0]
[null,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,{"$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,"",9.4757796934907468,282.51271855126402,6.018883303277093,30.879970943505064,1.8002836965402103,624.99736072305893,0,0,0,0,0,0]
[null,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,{"$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,"",386.50647928486421,617.77846529602095,352.81580159305491,162.54477936606074,142.69511407984891,256.02468100668688,81.015064600342015,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($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,"",94.771675641422377,1295.9364023311507,1.1085596271298379,1.4059883772386876,80.998170877534392,2269.6270935607326,14.864219524090741,284.79284809417595,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,"",1269.5470951414159,305.88787063006282,2467.0558197517867,2400.9095684103877,674.58083713569249,3.9690879030602937,902.71285806360333,177.73599837802522,2730.8854970072393,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,"",491.97010006695842,2400.9993155910352,80.990541884921882,0.89221822373849458,312.11589165237399,2518.5581992572274,87.005737562214421,132.42280673729761,17.995749974826349,2401.4663198819358,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,"",625.26903000979723,393.31454338924448,923.72369267978706,677.85007792819749,258.9629000534926,50.35406547785972,256.00416229776545,6.7935536159913381,910.08410684097066,17.817521624752615,625.00062211546344,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":198.50766903158791}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,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":0},{"$f":"SUM(AJ63:AJ86)","v":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,"Final points",null,null,null,null,null,null,null,"MAP DIST",null,null,{"$f":"+AF90","v":1},{"$f":"+AF91","v":0},{"$f":"+AF92","v":0},{"$f":"+AF93","v":0},{"$f":"+AF94","v":0},{"$f":"+AF95","v":0},{"$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":4.0439320118547535},{"$f":"+IF($AF90=1,(AD90+$AD$117)*$AD$119,\"\")","v":6.1293734010442664},null,4.5523754550683373,6.8871173629142923,null,{"$f":"IF(D18=\"\",0,1)","v":1},null,{"$f":"+AH63","v":"Enter in Step 2"},{"$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":""},{"$f":"+IF($AF91=1,(AD91+$AD$117)*$AD$119,\"\")","v":""},null,1.9893155453790952,4.9521999712234015,null,{"$f":"IF(D19=\"\",0,1)","v":0},null,{"$f":"+AH64","v":""},{"$f":"IFERROR(SUMXMY2(AC$90:AD$90,AC91:AD91),\"\")","v":10.313181413324106},{"$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,"","",null,6.7194547182591107,7.2563197573362421,null,0,null,"",{"$f":"IFERROR(SUMXMY2(AC$90:AD$90,AC92:AD92),\"\")","v":4.8325429409983665},{"$f":"IFERROR(SUMXMY2(AC$91:AD$91,AC92:AD92),\"\")","v":27.683184583570721},{"$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,"","",null,8.3374213996214284,6.0136757523618769,null,0,null,"",{"$f":"IFERROR(SUMXMY2(AC$90:AD$90,AC93:AD93),\"\")","v":15.0894730494222},41.425178770609314,{"$f":"IFERROR(SUMXMY2(AC$92:AD$92,AC93:AD93),\"\")","v":4.1619803050973214},{"$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,"","",null,4.8271136237488212,5.925256939596788,null,0,null,"",1.0006565352744345,8.9999377972989159,5.352683042740896,{"$f":"IFERROR(SUMXMY2(AC$93:AD$93,AC94:AD94),\"\")","v":12.330078567802477},{"$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,"","",null,2.6146325192790174,2.1792883632895799,null,0,null,"",25.918501574908838,8.0800601032614878,42.625813061375155,47.452839218447416,{"$f":"IFERROR(SUMXMY2(AC$94:AD$94,AC95:AD95),\"\")","v":18.927353212316973},{"$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,5.9842836352767748,5.8732562260166663,null,0,null,"",3.0782754414591862,16.808114663794509,2.4533412529195959,5.5569749813639673,1.3417465097924459,{"$f":"IFERROR(SUMXMY2(AC$95:AD$95,AC96:AD96),\"\")","v":24.999947214405452},{"$f":"IFERROR(SUMXMY2(AC$96:AD$96,AC96:AD96),\"\")","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,6.5444392938558718,2.9258739091983355,null,0,null,"",19.659768037412451,24.855149673579135,18.78339164243388,12.749305054239652,11.945506020250834,16.000771262870014,{"$f":"IFERROR(SUMXMY2(AC$96:AD$96,AC97:AD97),\"\")","v":9.0008368833315728},{"$f":"IFERROR(SUMXMY2(AC$97:AD$97,AC97:AD97),\"\")","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,7.6724636827229835,6.8759837265378581,null,0,null,"",9.7350745062080737,35.999116688207096,1.0528815826719726,1.1857438075902769,8.9998983815115601,47.64060341306282,3.8554143128969605,{"$f":"IFERROR(SUMXMY2(AC$97:AD$97,AC98:AD98),\"\")","v":16.875806590921098},{"$f":"IFERROR(SUMXMY2(AC$98:AD$98,AC98:AD98),\"\")","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,3.4269859590202132,1.0250185178271212,null,0,null,"",35.630704387387794,17.489650386158747,49.669465668072036,48.999077219988415,25.97269406772606,1.9922569872032809,30.045180280098226,13.331766513782981,{"$f":"IFERROR(SUMXMY2(AC$98:AD$98,AC99:AD99),\"\")","v":52.257874975999925},{"$f":"IFERROR(SUMXMY2(AC$99:AD$99,AC99:AD99),\"\")","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,8.9813648143905773,5.2857266357504695,null,0,null,"",22.180399006035902,48.999993016234555,8.999474533822621,0.94457303779988055,17.666801964486215,50.185238858226306,9.3276866136365459,11.507510883648887,4.2421397872802764,{"$f":"IFERROR(SUMXMY2(AC$99:AD$99,AC100:AD100),\"\")","v":49.004758135123325},{"$f":"IFERROR(SUMXMY2(AC$100:AD$100,AC100:AD100),\"\")","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,5.2675235801397289,1.937981763588867,null,0,null,"",25.00538002130336,19.832159322404721,30.392823045577504,26.035554112178936,16.092324258897239,7.0960598558537908,16.000130071276466,2.6064446312920859,30.167600283101251,4.2210806228681079,{"$f":"IFERROR(SUMXMY2(AC$100:AD$100,AC101:AD101),\"\")","v":25.000012442306172},{"$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,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,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,null,null,null,null,null,null,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":4.0439320118547535},null,"Min",{"$f":"MIN(AC90:AD112)","v":1.0250185178271212},null,null,null,null,null,null,{"$f":"IF(AK89=1,SUM(AK90:AK113),\"\")","v":163.49185413471096},{"$f":"IF(AL89=1,SUM(AL90:AL113),\"\")","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,"Max",{"$f":"MAX(Z90:AA112)","v":6.1293734010442664},null,"Max",{"$f":"MAX(AC90:AD112)","v":8.9813648143905773}]
[null,null,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":2.0854413891895129},null,null,{"$f":"+AD115-AD114","v":7.9563462965634564}]
[null,null,null,null,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.5018517827121167E-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,"Top",{"$f":"+AD117+AD115","v":8.9563462965634564}]
[null,null,null,null,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":0.89322138013685271}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,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":"Enter in Step 2"},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,"",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,"",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,"",null,null,{"$f":"IFERROR(AK93^2,\"\")","v":17.322080060017992},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,"",null,null,{"$f":"IFERROR(AK94^2,\"\")","v":28.651215756045936},152.03083748818199,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,"",null,null,{"$f":"IFERROR(AK95^2,\"\")","v":1816.9599391433007},2251.7719498918214,358.24469962380562,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":6.018883303277093},30.879970943505064,1.8002836965402103,624.99736072305893,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":352.81580159305491},162.54477936606074,142.69511407984891,256.02468100668688,81.015064600342015,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":1.1085596271298379},1.4059883772386876,80.998170877534392,2269.6270935607326,14.864219524090741,284.79284809417595,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":2467.0558197517867},2400.9095684103877,674.58083713569249,3.9690879030602937,902.71285806360333,177.73599837802522,2730.8854970072393,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":80.990541884921882},0.89221822373849458,312.11589165237399,2518.5581992572274,87.005737562214421,132.42280673729761,17.995749974826349,2401.4663198819358,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":923.72369267978706},677.85007792819749,258.9629000534926,50.35406547785972,256.00416229776545,6.7935536159913381,910.08410684097066,17.817521624752615,625.00062211546344,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":27572.457375795057},null,null,{"$f":"SUM(AK148:AK171)","v":5694.6465337993222},{"$f":"SUM(AL148:AL171)","v":5678.2853906291321},1829.397897119288,5723.5304879286259,1341.6020420480158,601.74520682549007,3658.9653538230359,2419.2838415066885,625.00062211546344,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":"Enter in Step 2"},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,"",null,null,{"$f":"IFERROR((AK91-AI64)^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,"",null,null,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,"",null,null,17.322080060017992,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,"",null,null,28.651215756045936,152.03083748818199,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,"",null,null,1816.9599391433007,2251.7719498918214,358.24469962380562,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,6.018883303277093,30.879970943505064,1.8002836965402103,624.99736072305893,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,352.81580159305491,162.54477936606074,142.69511407984891,256.02468100668688,81.015064600342015,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,1.1085596271298379,1.4059883772386876,80.998170877534392,2269.6270935607326,14.864219524090741,284.79284809417595,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,2467.0558197517867,2400.9095684103877,674.58083713569249,3.9690879030602937,902.71285806360333,177.73599837802522,2730.8854970072393,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,80.990541884921882,0.89221822373849458,312.11589165237399,2518.5581992572274,87.005737562214421,132.42280673729761,17.995749974826349,2401.4663198819358,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,923.72369267978706,677.85007792819749,258.9629000534926,50.35406547785972,256.00416229776545,6.7935536159913381,910.08410684097066,17.817521624752615,625.00062211546344,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":27572.457375795057},null,null,{"$f":"SUM(AK175:AK198)","v":5694.6465337993222},{"$f":"SUM(AL175:AL198)","v":5678.2853906291321},1829.397897119288,5723.5304879286259,1341.6020420480158,601.74520682549007,3658.9653538230359,2419.2838415066885,625.00062211546344,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},null,null,1,{"$f":"+AH175","v":"Enter in Step 2"},{"$f":"IF($AF90=1,AC90,\"\")","v":4.5523754550683373},{"$f":"IF($AF90=1,AD90,\"\")","v":6.8871173629142923},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,null,null,null,2,{"$f":"+AH176","v":""},{"$f":"IF($AF91=1,AC91,\"\")","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,null,null,null,null,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,null,null,null,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,null,null,null,5,"","","",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"","","",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,null,null,null,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,null,null,null,null,8,"","","",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,null,null,null,9,"","","",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,null,null,null,10,"","","",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,null,null,null,11,"","","",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,null,null,null,12,"","","",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,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,{"$f":"ABS(AI64^2-AI91)","v":10.313181413324106}]
[null,null,null,null,null,null,null,null,null,null,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":"ABS(AI65^2-AI92)","v":4.8325429409983665},{"$f":"ABS(AJ65^2-AJ92)","v":27.683184583570721}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.0894730494222,{"$f":"ABS(AJ66^2-AJ93)","v":41.425178770609314},4.1619803050973214]
[null,null,null,null,null,null,null,null,null,null,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.0006565352744345,{"$f":"ABS(AJ67^2-AJ94)","v":8.9999377972989159},5.352683042740896,12.330078567802477]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.918501574908838,{"$f":"ABS(AJ68^2-AJ95)","v":8.0800601032614878},42.625813061375155,47.452839218447416,18.927353212316973]
[null,null,null,null,null,null,null,null,null,null,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.0782754414591862,{"$f":"ABS(AJ69^2-AJ96)","v":16.808114663794509},2.4533412529195959,5.5569749813639673,1.3417465097924459,24.999947214405452]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.659768037412451,{"$f":"ABS(AJ70^2-AJ97)","v":24.855149673579135},18.78339164243388,12.749305054239652,11.945506020250834,16.000771262870014,9.0008368833315728]
[null,null,null,null,null,null,null,null,null,null,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.7350745062080737,{"$f":"ABS(AJ71^2-AJ98)","v":35.999116688207096},1.0528815826719726,1.1857438075902769,8.9998983815115601,47.64060341306282,3.8554143128969605,16.875806590921098]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35.630704387387794,{"$f":"ABS(AJ72^2-AJ99)","v":17.489650386158747},49.669465668072036,48.999077219988415,25.97269406772606,1.9922569872032809,30.045180280098226,13.331766513782981,52.257874975999925]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.180399006035902,{"$f":"ABS(AJ73^2-AJ100)","v":48.999993016234555},8.999474533822621,0.94457303779988055,17.666801964486215,50.185238858226306,9.3276866136365459,11.507510883648887,4.2421397872802764,49.004758135123325]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.00538002130336,{"$f":"ABS(AJ74^2-AJ101)","v":19.832159322404721},30.392823045577504,26.035554112178936,16.092324258897239,7.0960598558537908,16.000130071276466,2.6064446312920859,30.167600283101251,4.2210806228681079,25.000012442306172]
[null,null,null,null,null,null,null,null,null,null,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(AI221:AS231)","v":1267.6679470871429}]
[null,null,null,null,null,null,null,null,null,null,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 Goal"]

{"sheet":"How to Add Solver","index":1,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[9,11,9,16],[23,2,23,10],[24,2,24,10],[25,2,25,10],[1,3,1,10],[2,2,2,10],[3,2,3,10],[4,2,4,10],[5,2,5,10],[10,11,10,16],[11,11,11,16],[12,11,12,16],[18,5,18,7],[19,8,19,10]]}
[]
[null,"OPTIONAL STEPS",null,"Important Note for Apple Mac users"]
[null,"SOLVER ADD-IN","Ensure that your spreadsheet has the 'Solver add-in' loaded"]
[null,null,"In the top menu of Excel click \"File\" then select \"Options\" and then select \"Add-Ins\""]
[null,null,"Then click 'Go' next to 'Manage Excel Add-ins' and select the 'Solver Add-in' (as shown below)"]
[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,null,null,"ATTENTION APPLE MAC USERS!!!"]
[null,null,null,null,null,null,null,null,null,null,null,"Do not follow the instructions in Step 5"]
[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,"You will also need to follow Step 6"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Part C: Select Go"]
[null,"Part A: Select Options",null,null,null,null,null,null,"Part D: Tick Solver Add-in"]
[null,null,"Part B: Select Add-ins"]
[]
[]
[null,"SAVE/REOPEN","IMPORTANT: Save the spreadsheet and exit Excel, then reopen the spreadsheet"]
[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,"Solver should then appear under Data in the top menu, as shown below"]