{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DiscountPct","data"],"not_rendered":{"charts":9,"images":1,"macros":1,"external_links":0,"defined_names":98,"comments":1,"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":"DiscountPct","index":0,"n_rows":86,"n_cols":14,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Source: Edmunds.com"]
["© Edmunds.com, Inc."]
[]
["Discount Percent by Manufacturer"]
["Manufacturer","2012-06-01","2012-07-01","2012-08-01","2012-09-01","2012-10-01","2012-11-01","2012-12-01","2013-01-01","2013-02-01","2013-03-01","2013-04-01","2013-05-01","2013-06-01"]
["Audi",6.5799999999999997E-2,6.3E-2,6.4000000000000001E-2,6.5600000000000006E-2,7.1400000000000005E-2,6.5500000000000003E-2,6.9800000000000001E-2,7.5800000000000006E-2,7.7700000000000005E-2,7.8700000000000006E-2,6.83E-2,7.1900000000000006E-2,8.1199999999999994E-2]
["BMW",8.7300000000000003E-2,8.6699999999999999E-2,7.1999999999999995E-2,7.46E-2,8.1000000000000003E-2,9.5000000000000001E-2,0.1004,8.9399999999999993E-2,0.1002,0.1011,0.1002,0.1004,0.107]
["Chrysler Group",0.12920000000000001,0.1391,0.13700000000000001,0.1409,0.13320000000000001,0.13159999999999999,0.12770000000000001,0.15240000000000001,0.1492,0.1583,0.1484,0.151,0.1396]
["Ford",0.1384,0.13950000000000001,0.13869999999999999,0.13139999999999999,0.13400000000000001,0.1366,0.1318,0.12659999999999999,0.13189999999999999,0.14369999999999999,0.1331,0.1434,0.14299999999999999]
["Geely",9.7500000000000003E-2,0.108,0.1124,8.8200000000000001E-2,8.48E-2,8.5099999999999995E-2,9.3799999999999994E-2,0.1067,0.11600000000000001,0.1069,0.10059999999999999,9.3399999999999997E-2,0.10050000000000001]
["GM",0.13339999999999999,0.12670000000000001,0.12770000000000001,0.13059999999999999,0.129,0.12670000000000001,0.13420000000000001,0.1389,0.14380000000000001,0.13650000000000001,0.13239999999999999,0.13420000000000001,0.13800000000000001]
["Honda",0.106,9.6100000000000005E-2,0.1077,0.1163,9.1600000000000001E-2,8.77E-2,8.3699999999999997E-2,7.85E-2,7.7100000000000002E-2,8.9599999999999999E-2,7.9699999999999993E-2,8.8400000000000006E-2,9.7500000000000003E-2]
["Hyundai",7.5499999999999998E-2,8.2000000000000003E-2,8.2299999999999998E-2,7.4899999999999994E-2,7.7200000000000005E-2,9.2999999999999999E-2,9.3399999999999997E-2,9.7799999999999998E-2,0.1014,0.1086,0.1071,0.1177,0.1211]
["Kia",8.5800000000000001E-2,7.46E-2,9.01E-2,9.2799999999999994E-2,0.1042,0.11219999999999999,0.1166,0.11219999999999999,0.1075,0.1057,9.9199999999999997E-2,9.74E-2,0.1147]
["Mazda",8.5300000000000001E-2,8.6300000000000002E-2,0.1075,0.10100000000000001,9.8000000000000004E-2,0.11269999999999999,9.6600000000000005E-2,7.2499999999999995E-2,8.0399999999999999E-2,9.2799999999999994E-2,7.7799999999999994E-2,9.2299999999999993E-2,7.9899999999999999E-2]
["Mercedes-Benz",0.12820000000000001,0.12790000000000001,0.12280000000000001,7.2700000000000001E-2,9.8500000000000004E-2,0.1104,0.106,0.1439,0.1341,0.12670000000000001,0.1245,0.1288,0.13619999999999999]
["Mitsubishi",0.11070000000000001,0.1053,0.1125,0.109,0.1115,0.1179,0.1072,0.12909999999999999,0.12540000000000001,0.1193,0.1074,0.1283,0.121]
["Nissan",0.13900000000000001,0.1522,0.14119999999999999,0.13270000000000001,0.13120000000000001,0.15129999999999999,0.13270000000000001,0.1348,0.1396,0.1552,0.14050000000000001,0.1532,0.14699999999999999]
["Subaru",7.0999999999999994E-2,7.2700000000000001E-2,6.1800000000000001E-2,6.1100000000000002E-2,7.0900000000000005E-2,6.7799999999999999E-2,6.7500000000000004E-2,8.3400000000000002E-2,8.1000000000000003E-2,7.9100000000000004E-2,6.9699999999999998E-2,7.9500000000000001E-2,8.0699999999999994E-2]
["Suzuki",0.1303,0.14630000000000001,0.1293,0.1326,0.12239999999999999,0.1027,0.13639999999999999,0.1234,7.8299999999999995E-2,0.14929999999999999,9.1200000000000003E-2,9.3700000000000006E-2,9.5299999999999996E-2]
["Toyota",8.6599999999999996E-2,9.1499999999999998E-2,9.4899999999999998E-2,9.7500000000000003E-2,9.6799999999999997E-2,9.9199999999999997E-2,0.1016,0.1023,9.1200000000000003E-2,0.1057,9.2899999999999996E-2,0.1021,0.10440000000000001]
["Volkswagen",8.2699999999999996E-2,9.0499999999999997E-2,8.7999999999999995E-2,7.4300000000000005E-2,9.8400000000000001E-2,0.1013,0.1031,9.2999999999999999E-2,0.09,0.10489999999999999,9.35E-2,0.12809999999999999,0.1221]
["Industry",0.114,0.1142,0.1157,0.11360000000000001,0.1123,0.1153,0.1142,0.1179,0.1186,0.12540000000000001,0.1158,0.1234,0.12429999999999999]
[]
["Discount Percent by Make"]
["Make",{"$f":"B$8","v":"2012-06-01"},{"$f":"C$8","v":"2012-07-01"},"2012-08-01","2012-09-01","2012-10-01","2012-11-01","2012-12-01","2013-01-01","2013-02-01","2013-03-01","2013-04-01","2013-05-01","2013-06-01"]
["Acura",9.9400000000000002E-2,8.8800000000000004E-2,0.10340000000000001,0.1138,0.11600000000000001,9.5899999999999999E-2,9.1200000000000003E-2,9.7500000000000003E-2,0.1038,0.1051,8.4599999999999995E-2,0.10249999999999999,0.1031]
["Audi",6.5799999999999997E-2,6.3E-2,6.4000000000000001E-2,6.5600000000000006E-2,7.1400000000000005E-2,6.5500000000000003E-2,6.9800000000000001E-2,7.5800000000000006E-2,7.7700000000000005E-2,7.8700000000000006E-2,6.83E-2,7.1900000000000006E-2,8.1199999999999994E-2]
["BMW",9.7000000000000003E-2,9.7199999999999995E-2,8.0399999999999999E-2,8.1799999999999998E-2,8.8999999999999996E-2,0.1014,0.10680000000000001,9.7600000000000006E-2,0.1114,0.1132,0.1138,0.1103,0.1201]
["Buick",0.1095,0.1368,0.13439999999999999,0.12740000000000001,0.123,0.123,0.1215,0.1245,0.1217,0.1211,0.11,0.123,0.12790000000000001]
["Cadillac",0.10009999999999999,0.1196,0.12520000000000001,0.1038,8.8300000000000003E-2,0.1016,9.9400000000000002E-2,0.1045,0.1052,0.1033,9.1300000000000006E-2,0.1037,0.11219999999999999]
["Chevrolet",0.1396,0.12670000000000001,0.12759999999999999,0.13389999999999999,0.13320000000000001,0.12989999999999999,0.1381,0.14199999999999999,0.14940000000000001,0.14000000000000001,0.1366,0.1371,0.1404]
["Chrysler",0.14749999999999999,0.15870000000000001,0.16389999999999999,0.1734,0.1547,0.1487,0.1457,0.18099999999999999,0.18190000000000001,0.19919999999999999,0.19989999999999999,0.21360000000000001,0.19420000000000001]
["Dodge",0.12620000000000001,0.13439999999999999,0.12790000000000001,0.13,0.1239,0.122,0.11899999999999999,0.1515,0.14399999999999999,0.15640000000000001,0.1575,0.1578,0.1434]
["Ford",0.13819999999999999,0.13930000000000001,0.13819999999999999,0.1308,0.1338,0.1361,0.13150000000000001,0.1265,0.13289999999999999,0.14460000000000001,0.1338,0.1439,0.14330000000000001]
["GMC",0.1268,0.12540000000000001,0.12609999999999999,0.12790000000000001,0.13150000000000001,0.1273,0.13880000000000001,0.1469,0.1447,0.14219999999999999,0.13830000000000001,0.13700000000000001,0.14050000000000001]
["Honda",0.1069,9.7000000000000003E-2,0.10829999999999999,0.1167,8.8499999999999995E-2,8.6800000000000002E-2,8.2699999999999996E-2,7.6399999999999996E-2,7.3999999999999996E-2,8.7800000000000003E-2,7.9200000000000007E-2,8.6699999999999999E-2,9.69E-2]
["Hyundai",7.5499999999999998E-2,8.2000000000000003E-2,8.2299999999999998E-2,7.4899999999999994E-2,7.7200000000000005E-2,9.2999999999999999E-2,9.3399999999999997E-2,9.7799999999999998E-2,0.1014,0.1086,0.1071,0.1177,0.1211]
["Infiniti",0.1198,0.15709999999999999,0.15010000000000001,0.12670000000000001,0.10780000000000001,0.1236,0.1426,0.15,0.1804,0.18110000000000001,0.15,0.14940000000000001,0.1807]
["Jeep",0.1017,0.11409999999999999,0.11310000000000001,0.1065,9.1399999999999995E-2,9.6699999999999994E-2,9.0800000000000006E-2,0.1206,0.11799999999999999,0.10780000000000001,8.3500000000000005E-2,9.2700000000000005E-2,8.9200000000000002E-2]
["Kia",8.5800000000000001E-2,7.46E-2,9.01E-2,9.2799999999999994E-2,0.1042,0.11219999999999999,0.1166,0.11219999999999999,0.1075,0.1057,9.9199999999999997E-2,9.74E-2,0.1147]
["Lexus",8.5099999999999995E-2,8.4599999999999995E-2,7.8E-2,7.6899999999999996E-2,8.48E-2,9.0999999999999998E-2,9.35E-2,8.5199999999999998E-2,9.1600000000000001E-2,0.105,9.2200000000000004E-2,0.10009999999999999,0.1104]
["Lincoln",0.14380000000000001,0.14330000000000001,0.15290000000000001,0.1469,0.14380000000000001,0.152,0.14130000000000001,0.1298,9.1899999999999996E-2,0.11459999999999999,0.1094,0.12529999999999999,0.13150000000000001]
["Mazda",8.5300000000000001E-2,8.6300000000000002E-2,0.1075,0.10100000000000001,9.8000000000000004E-2,0.11269999999999999,9.6600000000000005E-2,7.2499999999999995E-2,8.0399999999999999E-2,9.2799999999999994E-2,7.7799999999999994E-2,9.2299999999999993E-2,7.9899999999999999E-2]
["Mercedes-Benz",0.1288,0.12870000000000001,0.12379999999999999,7.1499999999999994E-2,0.1002,0.1103,0.1056,0.14249999999999999,0.1328,0.1255,0.122,0.1265,0.1343]
["MINI",5.2699999999999997E-2,4.8599999999999997E-2,4.8300000000000003E-2,4.2599999999999999E-2,4.4999999999999998E-2,5.7000000000000002E-2,6.3200000000000006E-2,5.2900000000000003E-2,4.4400000000000002E-2,4.7E-2,4.5600000000000002E-2,5.8200000000000002E-2,5.2999999999999999E-2]
["Mitsubishi",0.11070000000000001,0.1053,0.1125,0.109,0.1115,0.1179,0.1072,0.12909999999999999,0.12540000000000001,0.1193,0.1074,0.1283,0.121]
["Nissan",0.1414,0.1515,0.1401,0.13339999999999999,0.1341,0.1552,0.1313,0.1333,0.13550000000000001,0.15290000000000001,0.1396,0.1535,0.14369999999999999]
["Ram",0.17180000000000001,0.18110000000000001,0.1726,0.18659999999999999,0.1888,0.18629999999999999,0.18060000000000001,0.1807,0.17630000000000001,0.1837,0.1764,0.16950000000000001,0.16689999999999999]
["Scion",1.2500000000000001E-2,1.6299999999999999E-2,1.8800000000000001E-2,2.3800000000000002E-2,3.2099999999999997E-2,2.98E-2,3.09E-2,2.1000000000000001E-2,1.4500000000000001E-2,1.84E-2,1.7600000000000001E-2,2.3400000000000001E-2,2.2800000000000001E-2]
["smart"]
["Subaru",7.0999999999999994E-2,7.2700000000000001E-2,6.1800000000000001E-2,6.1100000000000002E-2,7.0900000000000005E-2,6.7799999999999999E-2,6.7500000000000004E-2,8.3400000000000002E-2,8.1000000000000003E-2,7.9100000000000004E-2,6.9699999999999998E-2,7.9500000000000001E-2,8.0699999999999994E-2]
["Suzuki",0.1303,0.14630000000000001,0.1293,0.1326,0.12239999999999999,0.1027,0.13639999999999999,0.1234,7.8299999999999995E-2,0.14929999999999999,9.1200000000000003E-2,9.3700000000000006E-2,9.5299999999999996E-2]
["Toyota",9.0999999999999998E-2,9.6199999999999994E-2,0.1013,0.10390000000000001,0.10150000000000001,0.10349999999999999,0.1056,0.1072,9.3899999999999997E-2,0.109,9.5799999999999996E-2,0.1053,0.10680000000000001]
["Volkswagen",8.2699999999999996E-2,9.0499999999999997E-2,8.7999999999999995E-2,7.4300000000000005E-2,9.8400000000000001E-2,0.1013,0.1031,9.2999999999999999E-2,0.09,0.10489999999999999,9.35E-2,0.12809999999999999,0.1221]
["Volvo",9.7500000000000003E-2,0.108,0.1124,8.8200000000000001E-2,8.48E-2,8.5099999999999995E-2,9.3799999999999994E-2,0.1067,0.11600000000000001,0.1069,0.10059999999999999,9.3399999999999997E-2,0.10050000000000001]
[{"$f":"A$26","v":"Industry"},{"$f":"B26","v":0.114},0.1142,0.1157,0.11360000000000001,0.1123,0.1153,0.1142,0.1179,0.1186,0.12540000000000001,0.1158,0.1234,{"$f":"N26","v":0.12429999999999999}]
[]
["Discount Percent by Vehicle Segment"]
["Segment",{"$f":"B29","v":"2012-06-01"},"2012-07-01","2012-08-01","2012-09-01","2012-10-01","2012-11-01","2012-12-01","2013-01-01","2013-02-01","2013-03-01","2013-04-01","2013-05-01",{"$f":"N29","v":"2013-06-01"}]
["Compact Car",8.5599999999999996E-2,8.7599999999999997E-2,9.3100000000000002E-2,8.9099999999999999E-2,9.4299999999999995E-2,0.1023,0.1013,0.1,0.10009999999999999,0.1114,0.106,0.11210000000000001,0.1138]
["Compact Crossover SUV",0.10580000000000001,0.1056,9.8900000000000002E-2,0.09,8.8700000000000001E-2,9.4799999999999995E-2,9.2399999999999996E-2,9.9400000000000002E-2,9.6299999999999997E-2,0.10249999999999999,8.7499999999999994E-2,0.1013,9.9099999999999994E-2]
["Compact Truck",9.8500000000000004E-2,9.8900000000000002E-2,9.5699999999999993E-2,9.06E-2,6.83E-2,8.2199999999999995E-2,8.4599999999999995E-2,7.7100000000000002E-2,7.5499999999999998E-2,8.6699999999999999E-2,6.2899999999999998E-2,6.8699999999999997E-2,6.5299999999999997E-2]
["Entry Luxury Car",0.122,0.13089999999999999,0.1288,0.10680000000000001,0.108,0.1186,0.1205,0.13450000000000001,0.13850000000000001,0.14149999999999999,0.1288,0.13689999999999999,0.14910000000000001]
["Entry Luxury SUV",7.7600000000000002E-2,8.2400000000000001E-2,9.0300000000000005E-2,7.8899999999999998E-2,8.0699999999999994E-2,8.8099999999999998E-2,8.9499999999999996E-2,9.0300000000000005E-2,9.0200000000000002E-2,9.0200000000000002E-2,8.1500000000000003E-2,8.3000000000000004E-2,9.1200000000000003E-2]
["Entry Sport Car",7.2499999999999995E-2,7.6399999999999996E-2,7.46E-2,6.8199999999999997E-2,6.8400000000000002E-2,7.7899999999999997E-2,7.6899999999999996E-2,7.9200000000000007E-2,8.6099999999999996E-2,9.1200000000000003E-2,8.4099999999999994E-2,9.64E-2,0.1003]
["Large Car",0.17019999999999999,0.16070000000000001,0.17219999999999999,0.18770000000000001,0.17460000000000001,0.16839999999999999,0.14699999999999999,0.15229999999999999,0.1583,0.15529999999999999,0.14879999999999999,0.15090000000000001,0.15090000000000001]
["Large Crossover SUV",0.1331,0.14000000000000001,0.14649999999999999,0.1434,0.15,0.15329999999999999,0.1147,0.1239,0.1242,0.13489999999999999,0.1196,0.12859999999999999,0.12859999999999999]
["Large Traditional SUV",0.12,0.11650000000000001,0.1144,0.1142,0.12180000000000001,0.13780000000000001,0.13569999999999999,0.13109999999999999,0.128,0.1303,0.1212,0.12509999999999999,0.12659999999999999]
["Large Truck",0.1542,0.161,0.15939999999999999,0.17050000000000001,0.1699,0.16850000000000001,0.16739999999999999,0.1699,0.17780000000000001,0.17929999999999999,0.17130000000000001,0.17710000000000001,0.17230000000000001]
["Midrange Luxury Car",0.1177,0.1071,8.8599999999999998E-2,8.2299999999999998E-2,9.6100000000000005E-2,0.1128,0.12,0.13139999999999999,0.1353,0.13139999999999999,0.12130000000000001,0.1196,0.13780000000000001]
["Midrange Luxury SUV",8.5099999999999995E-2,8.7800000000000003E-2,8.43E-2,7.5200000000000003E-2,8.0100000000000005E-2,6.9699999999999998E-2,7.1900000000000006E-2,7.0400000000000004E-2,7.0800000000000002E-2,7.4399999999999994E-2,6.7799999999999999E-2,7.85E-2,8.4500000000000006E-2]
["Midrange Sport Car",8.3199999999999996E-2,7.4999999999999997E-2,7.1400000000000005E-2,7.8299999999999995E-2,7.4700000000000003E-2,7.1300000000000002E-2,8.0699999999999994E-2,8.3400000000000002E-2,8.5199999999999998E-2,8.7400000000000005E-2,7.8799999999999995E-2,8.1000000000000003E-2,8.1799999999999998E-2]
["Midsize Car",0.14530000000000001,0.1391,0.1404,0.1371,0.1232,0.1188,0.1183,0.13009999999999999,0.12740000000000001,0.14199999999999999,0.1303,0.13830000000000001,0.13880000000000001]
["Midsize Crossover SUV",0.1045,0.1084,0.1079,0.10680000000000001,0.1043,0.1147,0.1134,0.1201,0.1197,0.11890000000000001,0.1069,0.1132,0.1215]
["Midsize Traditional SUV",8.0399999999999999E-2,8.8999999999999996E-2,9.4799999999999995E-2,9.6000000000000002E-2,9.0700000000000003E-2,0.1106,9.1600000000000001E-2,0.1065,0.1062,0.1091,8.9300000000000004E-2,9.74E-2,9.4E-2]
["Minivan",0.1305,0.1336,0.13569999999999999,0.1404,0.13730000000000001,0.1193,0.11700000000000001,0.13300000000000001,0.13020000000000001,0.1482,0.15140000000000001,0.15629999999999999,0.1469]
["Premium Luxury Car",0.1028,0.107,9.6299999999999997E-2,8.4699999999999998E-2,9.9900000000000003E-2,0.10349999999999999,8.9099999999999999E-2,9.5000000000000001E-2,0.1002,0.1111,9.9400000000000002E-2,0.1069,0.1076]
["Premium Luxury SUV",7.7799999999999994E-2,9.5299999999999996E-2,0.1007,9.2100000000000001E-2,8.6300000000000002E-2,0.10879999999999999,8.2100000000000006E-2,7.1300000000000002E-2,6.7599999999999993E-2,6.3299999999999995E-2,5.5199999999999999E-2,5.8999999999999997E-2,6.6799999999999998E-2]
["Premium Sport Car",5.7200000000000001E-2,5.8200000000000002E-2,4.8599999999999997E-2,5.5399999999999998E-2,6.8400000000000002E-2,7.4300000000000005E-2,7.9600000000000004E-2,8.5999999999999993E-2,6.3500000000000001E-2,6.2899999999999998E-2,7.6799999999999993E-2,7.5399999999999995E-2,7.0800000000000002E-2]
["Subcompact Car",4.4900000000000002E-2,4.7300000000000002E-2,4.9200000000000001E-2,5.0700000000000002E-2,5.8200000000000002E-2,6.25E-2,6.3399999999999998E-2,5.8400000000000001E-2,5.9700000000000003E-2,7.1599999999999997E-2,6.4899999999999999E-2,7.3200000000000001E-2,8.0399999999999999E-2]
["Van",0.12509999999999999,0.12130000000000001,0.1215,0.1201,0.12540000000000001,0.1411,0.14599999999999999,0.12509999999999999,0.1172,0.1255,0.12479999999999999,0.13739999999999999,0.13039999999999999]
[{"$f":"A$26","v":"Industry"},{"$f":"B60","v":0.114},0.1142,0.1157,0.11360000000000001,0.1123,0.1153,0.1142,{"$f":"I60","v":0.1179},0.1186,0.12540000000000001,0.1158,0.1234,{"$f":"N60","v":0.12429999999999999}]

{"sheet":"data","index":1,"n_rows":182,"n_cols":15,"rows_kept":182,"cut":false,"hidden":true,"merged":[]}
[]
[]
["MANUFACTURERS","Active","sales",null,null,"Defaults"]
["Compare1",6,{"$f":"INDEX(ManuSales,B4,1)","v":"GM"},null,null,{"$f":"MATCH(G4,ManuSales,0)","v":6},"GM"]
["Compare2",4,"Ford",null,null,3,"Chrysler Group"]
["Compare3",16,"Toyota",null,null,4,"Ford"]
["Compare4",7,"Honda",null,null,7,"Honda"]
["Compare5",3,"Chrysler Group",null,null,13,"Nissan"]
["Compare6",13,"Nissan",null,null,16,"Toyota"]
[null,null,null,null,null,null,null,null,"SEGMENTS","Active","Active","Defaults"]
[null,null,null,null,null,null,null,null,"Compare1",9,{"$f":"INDEX(SgmtSales,J11,1)","v":"Large Traditional SUV"},{"$f":"MATCH(M11,SgmtSales,0)","v":1},"compact car"]
[null,null,null,null,null,null,null,null,"Compare2",1,"Compact Car",2,"compact crossover suv"]
["ManuTitle","REF",{"$f":"\"Manufacturer Discount Percent:\"&CHAR(10)&TEXT(DiscountPct!B8, \"MMM YYYY\")&\" vs. \"&TEXT(DiscountPct!N8, \"MMM YYYY\")","v":"Manufacturer Discount Percent:\nJun 2012 vs. Jun 2013"},null,null,null,null,null,"Compare3",10,"Large Truck",10,"large truck"]
["MakeTitle","REF",{"$f":"\"Make Discount Percent:\"&CHAR(10)&TEXT(DiscountPct!B8, \"MMM YYYY\")&\" vs. \"&TEXT(DiscountPct!N8, \"MMM YYYY\")","v":"Make Discount Percent:\nJun 2012 vs. Jun 2013"},null,null,null,null,null,"Compare4",6,"Entry Sport Car",14,"midsize car"]
["SegmentTitle",null,{"$f":"\"Vehicle Segment Discount Percent:\"&CHAR(10)&TEXT(DiscountPct!B8, \"MMM YYYY\")&\" vs. \"&TEXT(DiscountPct!N8, \"MMM YYYY\")","v":"Vehicle Segment Discount Percent:\nJun 2012 vs. Jun 2013"},null,null,null,null,null,"Compare5",7,"Large Car",15,"midsize crossover suv"]
[null,null,null,null,null,null,null,null,"Compare6",2,"Compact Crossover SUV",21,"subcompact car"]
["MAKES","Active","Active",null,null,"Defaults"]
["Compare1",6,{"$f":"INDEX(MakeSales,B18,1)","v":"Chevrolet"},null,null,{"$f":"MATCH(G18,MakeSales,0)","v":6},"Chevrolet"]
["Compare2",8,"Dodge",null,null,8,"Dodge"]
["Compare3",9,"Ford",null,null,9,"Ford"]
["Compare4",11,"Honda",null,null,11,"Honda"]
["Compare5",23,"Ram",null,null,22,"Nissan"]
["Compare6",28,"Toyota",null,null,28,"Toyota"]
[]
[null,null,null,null,null,"Defaults"]
["Manu to show",10,null,null,null,10]
["Make to show",10,null,null,null,10]
["ActiveMonth",12,{"$f":"OFFSET(E30,B28,0)","v":"2013-05-01"},null,null,13]
["Sgmt to show",10,null,null,null,10]
["CalendarMonths_MktShr",null,null,null,"CalendarMonths_Sales"]
["REF",null,null,null,{"$f":"DiscountPct!B8","v":"2012-06-01"}]
["REF",null,null,null,{"$f":"DiscountPct!C8","v":"2012-07-01"}]
["REF",null,null,null,{"$f":"DiscountPct!D8","v":"2012-08-01"}]
["REF",null,null,null,{"$f":"DiscountPct!E8","v":"2012-09-01"}]
["REF",null,null,null,{"$f":"DiscountPct!F8","v":"2012-10-01"}]
["REF",null,null,null,{"$f":"DiscountPct!G8","v":"2012-11-01"}]
["REF",null,null,null,{"$f":"DiscountPct!H8","v":"2012-12-01"}]
["REF",null,null,null,{"$f":"DiscountPct!I8","v":"2013-01-01"}]
["REF",null,null,null,{"$f":"DiscountPct!J8","v":"2013-02-01"}]
["REF",null,null,null,{"$f":"DiscountPct!K8","v":"2013-03-01"}]
["REF",null,null,null,{"$f":"DiscountPct!L8","v":"2013-04-01"}]
["REF",null,null,null,{"$f":"DiscountPct!M8","v":"2013-05-01"}]
["REF",null,null,null,{"$f":"DiscountPct!N8","v":"2013-06-01"}]
["REF",null,null,null,{"$f":"DiscountPct!#REF!&\" Percent Change\"","v":{"$error":"#REF!"}},"<-- excluded percentage point change b/c it's very confusing"]
["REF","REF",null,null,{"$f":"DiscountPct!#REF!&\" Percent Change\"","v":{"$error":"#REF!"}},"<-- can't implement Percent Change because there's no way to change the chart axis format from numbers to %"]
[]
[]
[]
[]
["Number of manufacturers",{"$f":"COUNTA(ManuMktShr)","v":1},null,null,null,"Number of makes",{"$f":"COUNTA(MakeMktShr)","v":1}]
["TITLE",null,null,null,null,"TITLE"]
[1,"REF","REF",null,null,1,"REF","REF"]
[2,"REF","REF",null,null,2,"REF","REF"]
[3,"REF","REF",null,null,3,"REF","REF"]
[4,"REF","REF",null,null,4,"REF","REF"]
[5,"REF","REF",null,null,5,"REF","REF"]
[6,"REF","REF",null,null,6,"REF","REF"]
[7,"REF","REF",null,null,7,"REF","REF"]
[8,"REF","REF",null,null,8,"REF","REF"]
[9,"REF","REF",null,null,9,"REF","REF"]
[10,"REF","REF",null,null,10,"REF","REF"]
[11,"REF","REF",null,null,11,"REF","REF"]
[12,"REF","REF",null,null,12,"REF","REF"]
[13,"REF","REF",null,null,13,"REF","REF"]
[14,"REF","REF",null,null,14,"REF","REF"]
[15,"REF","REF",null,null,15,"REF","REF"]
[16,"REF","REF",null,null,16,"REF","REF"]
[17,"REF","REF",null,null,17,"REF","REF"]
[18,"REF","REF",null,null,18,"REF","REF"]
[19,"REF","REF",null,null,19,"REF","REF"]
[20,"REF","REF",null,null,20,"REF","REF"]
[21,"REF","REF",null,null,21,"REF","REF"]
[22,"REF","REF",null,null,22,"REF","REF"]
[null,null,null,null,null,23,"REF","REF"]
[null,null,null,null,null,24,"REF","REF"]
[null,null,null,null,null,25,"REF","REF"]
[null,null,null,null,null,26,"REF","REF"]
[null,null,null,null,null,27,"REF","REF"]
[null,null,null,null,null,28,"REF","REF"]
[null,null,null,null,null,29,"REF","REF"]
[null,null,null,null,null,30,"REF","REF"]
[null,null,null,null,null,31,"REF","REF"]
[null,null,null,null,null,32,"REF","REF"]
[null,null,null,null,null,33,"REF","REF"]
[null,null,null,null,null,34,"REF","REF"]
[null,null,null,null,null,35,"REF","REF"]
[null,null,null,null,null,36,"REF","REF"]
[null,null,null,null,null,37,"REF","REF"]
[null,null,null,null,null,38,"REF","REF"]
[null,null,null,null,null,39,"REF","REF"]
[null,null,null,null,null,40,"REF","REF"]
[null,null,null,"Defaults"]
["ActiveSort:",2,null,2,null,"Include Industry in rank chart",true,{"$f":"IF(G93,0,1)","v":0},{"$f":"IF(Rankind,IF(MATCH(DiscountPct!$A$26,B99:B138,0)<=data!B26,1,0),0)","v":0},{"$f":"IF(Rankind,IF(MATCH(DiscountPct!$A$60,G99:G138,0)<=data!B27,1,0),0)","v":0},{"$f":"IF(Rankind,IF(MATCH(DiscountPct!$A$86,L99:L138,0)<=data!B29,1,0),0)","v":0}]
["Highest Discount %",null,null,null,null,"Defaults",true,null,"Manu","Make","Sgmt"]
["Lowest Discount %"]
[]
["Number of manufacturers",{"$f":"COUNTA(ManuSales)-H93","v":18},"Number in Chart",{"$f":"COUNT(C99:C138)-COUNT(E99:E138)","v":17},null,"Number of makes",{"$f":"COUNTA(MakeSales)-H93","v":31},"Number in Chart",{"$f":"COUNT(H99:H138)-COUNT(J99:J138)","v":29},null,"Number of segments",{"$f":"COUNTA(SgmtSales)-H93","v":23},"Number in Chart",{"$f":"COUNT(M99:M138)-COUNT(O99:O138)","v":22}]
[{"$f":"\"Top \"&$B$26&\" Manufacturers with \"&OFFSET($A$93,ActiveSort,0)&\":\"&CHAR(10)&TEXT($C$28, \"MMMM YYYY\")","v":"Top 10 Manufacturers with Lowest Discount %:\nMay 2013"},"manu","discount%","discount% ranked","Industry",{"$f":"\"Top \"&$B$27&\" Makes with \"&OFFSET($A$93,ActiveSort,0)&\":\"&CHAR(10)&TEXT($C$28, \"MMMM YYYY\")","v":"Top 10 Makes with Lowest Discount %:\nMay 2013"},"make","discount%","discount% ranked","Industry",{"$f":"\"Top \"&$B$29&\" Vehicle Segments with \"&OFFSET($A$93,ActiveSort,0)&\":\"&CHAR(10)&TEXT($C$28, \"MMMM YYYY\")","v":"Top 10 Vehicle Segments with Lowest Discount %:\nMay 2013"},"sgmt","discount%","discount% ranked","Industry"]
[1,{"$f":"OFFSET($B$142,MATCH(D99,$D$143:$D$165,0),0)","v":"Audi"},{"$f":"OFFSET($B$142,MATCH(D99,$D$143:$D$165,0),1)","v":7.1900000000000006E-2},{"$f":"IF(ActiveSort=1,LARGE(OFFSET($B$142,1,2,$B$97),A99),SMALL(OFFSET($B$142,1,2,$B$97),A99))","v":7.1910000000000002E-2},{"$f":"IF(B99=DiscountPct!$A$26,C99,\"\")","v":""},null,{"$f":"OFFSET($G$142,MATCH(I99,$I$143:$I$183,0),0)","v":"Scion"},{"$f":"OFFSET($G$142,MATCH(I99,$I$143:$I$183,0),1)","v":2.3400000000000001E-2},{"$f":"IF(ActiveSort=1,LARGE(OFFSET($G$142,1,2,$G$97),A99),SMALL(OFFSET($G$142,1,2,$G$97),A99))","v":2.3640000000000001E-2},{"$f":"IF(G99=DiscountPct!$A$26,H99,\"\")","v":""},null,{"$f":"OFFSET($L$142,MATCH(N99,$N$143:$N$165,0),0)","v":"Premium Luxury SUV"},{"$f":"OFFSET($L$142,MATCH(N99,$N$143:$N$165,0),1)","v":5.8999999999999997E-2},{"$f":"IF(ActiveSort=1,LARGE(OFFSET($L$142,1,2,$L$97),A99),SMALL(OFFSET($L$142,1,2,$L$97),A99))","v":5.919E-2},{"$f":"IF(L99=DiscountPct!$A$26,M99,\"\")","v":""}]
[2,"Subaru",7.9500000000000001E-2,7.9640000000000002E-2,{"$f":"IF(B100=DiscountPct!$A$26,C100,\"\")","v":""},null,"MINI",5.8200000000000002E-2,5.8400000000000001E-2,{"$f":"IF(G100=DiscountPct!$A$26,H100,\"\")","v":""},null,"Compact Truck",6.8699999999999997E-2,6.8729999999999999E-2,{"$f":"IF(L100=DiscountPct!$A$26,M100,\"\")","v":""}]
[3,"Honda",8.8400000000000006E-2,8.8470000000000007E-2,{"$f":"IF(B101=DiscountPct!$A$26,C101,\"\")","v":""},null,"Audi",7.1900000000000006E-2,7.1920000000000012E-2,{"$f":"IF(G101=DiscountPct!$A$26,H101,\"\")","v":""},null,"Subcompact Car",7.3200000000000001E-2,7.3410000000000003E-2,{"$f":"IF(L101=DiscountPct!$A$26,M101,\"\")","v":""}]
[4,"Mazda",9.2299999999999993E-2,9.2399999999999996E-2,{"$f":"IF(B102=DiscountPct!$A$26,C102,\"\")","v":""},null,"Subaru",7.9500000000000001E-2,7.9759999999999998E-2,{"$f":"IF(G102=DiscountPct!$A$26,H102,\"\")","v":""},null,"Premium Sport Car",7.5399999999999995E-2,7.5600000000000001E-2,{"$f":"IF(L102=DiscountPct!$A$26,M102,\"\")","v":""}]
[5,"Geely",9.3399999999999997E-2,9.3449999999999991E-2,{"$f":"IF(B103=DiscountPct!$A$26,C103,\"\")","v":""},null,"Honda",8.6699999999999999E-2,8.6809999999999998E-2,{"$f":"IF(G103=DiscountPct!$A$26,H103,\"\")","v":""},null,"Midrange Luxury SUV",7.85E-2,7.8619999999999995E-2,{"$f":"IF(L103=DiscountPct!$A$26,M103,\"\")","v":""}]
[6,"Suzuki",9.3700000000000006E-2,9.3850000000000003E-2,{"$f":"IF(B104=DiscountPct!$A$26,C104,\"\")","v":""},null,"Mazda",9.2299999999999993E-2,9.2479999999999993E-2,{"$f":"IF(G104=DiscountPct!$A$26,H104,\"\")","v":""},null,"Midrange Sport Car",8.1000000000000003E-2,8.1130000000000008E-2,{"$f":"IF(L104=DiscountPct!$A$26,M104,\"\")","v":""}]
[7,"Kia",9.74E-2,9.7490000000000007E-2,{"$f":"IF(B105=DiscountPct!$A$26,C105,\"\")","v":""},null,"Jeep",9.2700000000000005E-2,9.2840000000000006E-2,{"$f":"IF(G105=DiscountPct!$A$26,H105,\"\")","v":""},null,"Entry Luxury SUV",8.3000000000000004E-2,8.3049999999999999E-2,{"$f":"IF(L105=DiscountPct!$A$26,M105,\"\")","v":""}]
[8,"BMW",0.1004,0.10042000000000001,{"$f":"IF(B106=DiscountPct!$A$26,C106,\"\")","v":""},null,"Volvo",9.3399999999999997E-2,9.3699999999999992E-2,{"$f":"IF(G106=DiscountPct!$A$26,H106,\"\")","v":""},null,"Entry Sport Car",9.64E-2,9.6460000000000004E-2,{"$f":"IF(L106=DiscountPct!$A$26,M106,\"\")","v":""}]
[9,"Toyota",0.1021,0.10225999999999999,{"$f":"IF(B107=DiscountPct!$A$26,C107,\"\")","v":""},null,"Suzuki",9.3700000000000006E-2,9.3970000000000012E-2,{"$f":"IF(G107=DiscountPct!$A$26,H107,\"\")","v":""},null,"Midsize Traditional SUV",9.74E-2,9.7559999999999994E-2,{"$f":"IF(L107=DiscountPct!$A$26,M107,\"\")","v":""}]
[10,"Hyundai",0.1177,0.11778,{"$f":"IF(B108=DiscountPct!$A$26,C108,\"\")","v":""},null,"Kia",9.74E-2,9.7549999999999998E-2,{"$f":"IF(G108=DiscountPct!$A$26,H108,\"\")","v":""},null,"Compact Crossover SUV",0.1013,0.10132000000000001,{"$f":"IF(L108=DiscountPct!$A$26,M108,\"\")","v":""}]
[11,"Industry",0.1234,0.12358,{"$f":"IF(B109=DiscountPct!$A$26,C109,\"\")","v":0.1234},null,"Lexus",0.10009999999999999,0.10025999999999999,{"$f":"IF(G109=DiscountPct!$A$26,H109,\"\")","v":""},null,"Premium Luxury Car",0.1069,0.10707999999999999,{"$f":"IF(L109=DiscountPct!$A$26,M109,\"\")","v":""}]
[12,"Volkswagen",0.12809999999999999,0.12827,{"$f":"IF(B110=DiscountPct!$A$26,C110,\"\")","v":""},null,"Acura",0.10249999999999999,0.10250999999999999,{"$f":"IF(G110=DiscountPct!$A$26,H110,\"\")","v":""},null,"Compact Car",0.11210000000000001,0.11211,{"$f":"IF(L110=DiscountPct!$A$26,M110,\"\")","v":""}]
[13,"Mitsubishi",0.1283,0.12842000000000001,{"$f":"IF(B111=DiscountPct!$A$26,C111,\"\")","v":""},null,"Cadillac",0.1037,0.10375,{"$f":"IF(G111=DiscountPct!$A$26,H111,\"\")","v":""},null,"Midsize Crossover SUV",0.1132,0.11334999999999999,{"$f":"IF(L111=DiscountPct!$A$26,M111,\"\")","v":""}]
[14,"Mercedes-Benz",0.1288,0.12891,{"$f":"IF(B112=DiscountPct!$A$26,C112,\"\")","v":""},null,"Toyota",0.1053,0.10558000000000001,{"$f":"IF(G112=DiscountPct!$A$26,H112,\"\")","v":""},null,"Midrange Luxury Car",0.1196,0.11971,{"$f":"IF(L112=DiscountPct!$A$26,M112,\"\")","v":""}]
[15,"GM",0.13420000000000001,0.13426000000000002,{"$f":"IF(B113=DiscountPct!$A$26,C113,\"\")","v":""},null,"BMW",0.1103,0.11033,{"$f":"IF(G113=DiscountPct!$A$26,H113,\"\")","v":""},null,"Industry",0.1234,0.12362999999999999,{"$f":"IF(L113=DiscountPct!$A$26,M113,\"\")","v":0.1234}]
[16,"Ford",0.1434,0.14344000000000001,{"$f":"IF(B114=DiscountPct!$A$26,C114,\"\")","v":""},null,"Hyundai",0.1177,0.11781999999999999,{"$f":"IF(G114=DiscountPct!$A$26,H114,\"\")","v":""},null,"Large Traditional SUV",0.12509999999999999,0.12519,{"$f":"IF(L114=DiscountPct!$A$26,M114,\"\")","v":""}]
[17,"Chrysler Group",0.151,0.15103,{"$f":"IF(B115=DiscountPct!$A$26,C115,\"\")","v":""},null,"Buick",0.123,0.12304,{"$f":"IF(G115=DiscountPct!$A$26,H115,\"\")","v":""},null,"Large Crossover SUV",0.12859999999999999,0.12867999999999999,{"$f":"IF(L115=DiscountPct!$A$26,M115,\"\")","v":""}]
[18,"Nissan",0.1532,0.15332999999999999,{"$f":"IF(B116=DiscountPct!$A$26,C116,\"\")","v":""},null,"Industry",0.1234,0.12371,{"$f":"IF(G116=DiscountPct!$A$26,H116,\"\")","v":0.1234},null,"Entry Luxury Car",0.13689999999999999,0.13694000000000001,{"$f":"IF(L116=DiscountPct!$A$26,M116,\"\")","v":""}]
[19,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(B117=DiscountPct!$A$26,C117,\"\")","v":{"$error":"#NUM!"}},null,"Lincoln",0.12529999999999999,0.12547,{"$f":"IF(G117=DiscountPct!$A$26,H117,\"\")","v":""},null,"Van",0.13739999999999999,0.13761999999999999,{"$f":"IF(L117=DiscountPct!$A$26,M117,\"\")","v":""}]
[20,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(B118=DiscountPct!$A$26,C118,\"\")","v":{"$error":"#NUM!"}},null,"Mercedes-Benz",0.1265,0.12669,{"$f":"IF(G118=DiscountPct!$A$26,H118,\"\")","v":""},null,"Midsize Car",0.13830000000000001,0.13844000000000001,{"$f":"IF(L118=DiscountPct!$A$26,M118,\"\")","v":""}]
[21,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(B119=DiscountPct!$A$26,C119,\"\")","v":{"$error":"#NUM!"}},null,"Volkswagen",0.12809999999999999,0.12839,{"$f":"IF(G119=DiscountPct!$A$26,H119,\"\")","v":""},null,"Large Car",0.15090000000000001,0.15096999999999999,{"$f":"IF(L119=DiscountPct!$A$26,M119,\"\")","v":""}]
[22,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(B120=DiscountPct!$A$26,C120,\"\")","v":{"$error":"#NUM!"}},null,"Mitsubishi",0.1283,0.12850999999999999,{"$f":"IF(G120=DiscountPct!$A$26,H120,\"\")","v":""},null,"Minivan",0.15629999999999999,0.15647,{"$f":"IF(L120=DiscountPct!$A$26,M120,\"\")","v":""}]
[23,null,null,null,null,null,"GMC",0.13700000000000001,0.1371,null,null,{"$f":"OFFSET($L$142,MATCH(N121,$N$143:$N$165,0),0)","v":"Large Truck"},{"$f":"OFFSET($L$142,MATCH(N121,$N$143:$N$165,0),1)","v":0.17710000000000001},{"$f":"IF(ActiveSort=1,LARGE(OFFSET($L$142,1,2,$L$97),A121),SMALL(OFFSET($L$142,1,2,$L$97),A121))","v":0.1772},{"$f":"IF(L121=DiscountPct!$A$26,M121,\"\")","v":""}]
[24,null,null,null,null,null,"Chevrolet",0.1371,0.13716,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L122=DiscountPct!$A$26,M122,\"\")","v":{"$error":"#NUM!"}}]
[25,null,null,null,null,null,"Ford",0.1439,0.14399000000000001,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L123=DiscountPct!$A$26,M123,\"\")","v":{"$error":"#NUM!"}}]
[26,null,null,null,null,null,"Infiniti",0.14940000000000001,0.14953,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L124=DiscountPct!$A$26,M124,\"\")","v":{"$error":"#NUM!"}}]
[27,null,null,null,null,null,"Nissan",0.1535,0.15372,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L125=DiscountPct!$A$26,M125,\"\")","v":{"$error":"#NUM!"}}]
[28,null,null,null,null,null,"Dodge",0.1578,0.15787999999999999,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L126=DiscountPct!$A$26,M126,\"\")","v":{"$error":"#NUM!"}}]
[29,null,null,null,null,null,"Ram",0.16950000000000001,0.16973000000000002,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L127=DiscountPct!$A$26,M127,\"\")","v":{"$error":"#NUM!"}}]
[30,null,null,null,null,null,"Chrysler",0.21360000000000001,0.21367,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L128=DiscountPct!$A$26,M128,\"\")","v":{"$error":"#NUM!"}}]
[31,null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L129=DiscountPct!$A$26,M129,\"\")","v":{"$error":"#NUM!"}}]
[32,null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L130=DiscountPct!$A$26,M130,\"\")","v":{"$error":"#NUM!"}}]
[33,null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L131=DiscountPct!$A$26,M131,\"\")","v":{"$error":"#NUM!"}}]
[34,null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L132=DiscountPct!$A$26,M132,\"\")","v":{"$error":"#NUM!"}}]
[35,null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L133=DiscountPct!$A$26,M133,\"\")","v":{"$error":"#NUM!"}}]
[36,null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L134=DiscountPct!$A$26,M134,\"\")","v":{"$error":"#NUM!"}}]
[37,null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L135=DiscountPct!$A$26,M135,\"\")","v":{"$error":"#NUM!"}}]
[38,null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L136=DiscountPct!$A$26,M136,\"\")","v":{"$error":"#NUM!"}}]
[39,null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L137=DiscountPct!$A$26,M137,\"\")","v":{"$error":"#NUM!"}}]
[40,null,null,null,null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"IF(L138=DiscountPct!$A$26,M138,\"\")","v":{"$error":"#NUM!"}}]
[]
[]
[null,"UNSORTED",null,null,null,null,"UNSORTED",null,null,null,null,"UNSORTED"]
[null,"MANUFACTURERS",null,null,null,null,"MAKES",null,null,null,null,"SEGMENTS"]
[1,{"$f":"OFFSET(DiscountPct!$A$8,A143,0)","v":"Audi"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B143,ManuSales,0),$B$28)","v":7.1900000000000006E-2},{"$f":"IF(OR(C143=0,C143=\"\"),\"\",C143+A143/100000)","v":7.1910000000000002E-2},null,null,{"$f":"OFFSET(DiscountPct!$A$29,A143,0)","v":"Acura"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G143,MakeSales,0),$B$28)","v":0.10249999999999999},{"$f":"IF(OR(H143=0,H143=\"\"),\"\",H143+A143/100000)","v":0.10250999999999999},null,null,{"$f":"OFFSET(DiscountPct!$A$63,A143,0)","v":"Compact Car"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L143,SgmtSales,0),$B$28)","v":0.11210000000000001},{"$f":"IF(OR(M143=0,M143=\"\"),\"\",M143+A143/100000)","v":0.11211}]
[2,{"$f":"OFFSET(DiscountPct!$A$8,A144,0)","v":"BMW"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B144,ManuSales,0),$B$28)","v":0.1004},{"$f":"IF(OR(C144=0,C144=\"\"),\"\",C144+A144/100000)","v":0.10042000000000001},null,null,{"$f":"OFFSET(DiscountPct!$A$29,A144,0)","v":"Audi"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G144,MakeSales,0),$B$28)","v":7.1900000000000006E-2},{"$f":"IF(OR(H144=0,H144=\"\"),\"\",H144+A144/100000)","v":7.1920000000000012E-2},null,null,{"$f":"OFFSET(DiscountPct!$A$63,A144,0)","v":"Compact Crossover SUV"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L144,SgmtSales,0),$B$28)","v":0.1013},{"$f":"IF(OR(M144=0,M144=\"\"),\"\",M144+A144/100000)","v":0.10132000000000001}]
[3,{"$f":"OFFSET(DiscountPct!$A$8,A145,0)","v":"Chrysler Group"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B145,ManuSales,0),$B$28)","v":0.151},0.15103,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A145,0)","v":"BMW"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G145,MakeSales,0),$B$28)","v":0.1103},0.11033,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A145,0)","v":"Compact Truck"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L145,SgmtSales,0),$B$28)","v":6.8699999999999997E-2},6.8729999999999999E-2]
[4,{"$f":"OFFSET(DiscountPct!$A$8,A146,0)","v":"Ford"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B146,ManuSales,0),$B$28)","v":0.1434},0.14344000000000001,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A146,0)","v":"Buick"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G146,MakeSales,0),$B$28)","v":0.123},0.12304,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A146,0)","v":"Entry Luxury Car"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L146,SgmtSales,0),$B$28)","v":0.13689999999999999},0.13694000000000001]
[5,{"$f":"OFFSET(DiscountPct!$A$8,A147,0)","v":"Geely"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B147,ManuSales,0),$B$28)","v":9.3399999999999997E-2},9.3449999999999991E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A147,0)","v":"Cadillac"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G147,MakeSales,0),$B$28)","v":0.1037},0.10375,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A147,0)","v":"Entry Luxury SUV"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L147,SgmtSales,0),$B$28)","v":8.3000000000000004E-2},8.3049999999999999E-2]
[6,{"$f":"OFFSET(DiscountPct!$A$8,A148,0)","v":"GM"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B148,ManuSales,0),$B$28)","v":0.13420000000000001},0.13426000000000002,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A148,0)","v":"Chevrolet"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G148,MakeSales,0),$B$28)","v":0.1371},0.13716,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A148,0)","v":"Entry Sport Car"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L148,SgmtSales,0),$B$28)","v":9.64E-2},9.6460000000000004E-2]
[7,{"$f":"OFFSET(DiscountPct!$A$8,A149,0)","v":"Honda"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B149,ManuSales,0),$B$28)","v":8.8400000000000006E-2},8.8470000000000007E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A149,0)","v":"Chrysler"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G149,MakeSales,0),$B$28)","v":0.21360000000000001},0.21367,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A149,0)","v":"Large Car"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L149,SgmtSales,0),$B$28)","v":0.15090000000000001},0.15096999999999999]
[8,{"$f":"OFFSET(DiscountPct!$A$8,A150,0)","v":"Hyundai"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B150,ManuSales,0),$B$28)","v":0.1177},0.11778,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A150,0)","v":"Dodge"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G150,MakeSales,0),$B$28)","v":0.1578},0.15787999999999999,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A150,0)","v":"Large Crossover SUV"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L150,SgmtSales,0),$B$28)","v":0.12859999999999999},0.12867999999999999]
[9,{"$f":"OFFSET(DiscountPct!$A$8,A151,0)","v":"Kia"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B151,ManuSales,0),$B$28)","v":9.74E-2},9.7490000000000007E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A151,0)","v":"Ford"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G151,MakeSales,0),$B$28)","v":0.1439},0.14399000000000001,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A151,0)","v":"Large Traditional SUV"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L151,SgmtSales,0),$B$28)","v":0.12509999999999999},0.12519]
[10,{"$f":"OFFSET(DiscountPct!$A$8,A152,0)","v":"Mazda"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B152,ManuSales,0),$B$28)","v":9.2299999999999993E-2},9.2399999999999996E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A152,0)","v":"GMC"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G152,MakeSales,0),$B$28)","v":0.13700000000000001},0.1371,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A152,0)","v":"Large Truck"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L152,SgmtSales,0),$B$28)","v":0.17710000000000001},0.1772]
[11,{"$f":"OFFSET(DiscountPct!$A$8,A153,0)","v":"Mercedes-Benz"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B153,ManuSales,0),$B$28)","v":0.1288},0.12891,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A153,0)","v":"Honda"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G153,MakeSales,0),$B$28)","v":8.6699999999999999E-2},8.6809999999999998E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A153,0)","v":"Midrange Luxury Car"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L153,SgmtSales,0),$B$28)","v":0.1196},0.11971]
[12,{"$f":"OFFSET(DiscountPct!$A$8,A154,0)","v":"Mitsubishi"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B154,ManuSales,0),$B$28)","v":0.1283},0.12842000000000001,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A154,0)","v":"Hyundai"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G154,MakeSales,0),$B$28)","v":0.1177},0.11781999999999999,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A154,0)","v":"Midrange Luxury SUV"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L154,SgmtSales,0),$B$28)","v":7.85E-2},7.8619999999999995E-2]
[13,{"$f":"OFFSET(DiscountPct!$A$8,A155,0)","v":"Nissan"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B155,ManuSales,0),$B$28)","v":0.1532},0.15332999999999999,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A155,0)","v":"Infiniti"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G155,MakeSales,0),$B$28)","v":0.14940000000000001},0.14953,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A155,0)","v":"Midrange Sport Car"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L155,SgmtSales,0),$B$28)","v":8.1000000000000003E-2},8.1130000000000008E-2]
[14,{"$f":"OFFSET(DiscountPct!$A$8,A156,0)","v":"Subaru"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B156,ManuSales,0),$B$28)","v":7.9500000000000001E-2},7.9640000000000002E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A156,0)","v":"Jeep"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G156,MakeSales,0),$B$28)","v":9.2700000000000005E-2},9.2840000000000006E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A156,0)","v":"Midsize Car"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L156,SgmtSales,0),$B$28)","v":0.13830000000000001},0.13844000000000001]
[15,{"$f":"OFFSET(DiscountPct!$A$8,A157,0)","v":"Suzuki"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B157,ManuSales,0),$B$28)","v":9.3700000000000006E-2},9.3850000000000003E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A157,0)","v":"Kia"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G157,MakeSales,0),$B$28)","v":9.74E-2},9.7549999999999998E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A157,0)","v":"Midsize Crossover SUV"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L157,SgmtSales,0),$B$28)","v":0.1132},0.11334999999999999]
[16,{"$f":"OFFSET(DiscountPct!$A$8,A158,0)","v":"Toyota"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B158,ManuSales,0),$B$28)","v":0.1021},0.10225999999999999,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A158,0)","v":"Lexus"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G158,MakeSales,0),$B$28)","v":0.10009999999999999},0.10025999999999999,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A158,0)","v":"Midsize Traditional SUV"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L158,SgmtSales,0),$B$28)","v":9.74E-2},9.7559999999999994E-2]
[17,{"$f":"OFFSET(DiscountPct!$A$8,A159,0)","v":"Volkswagen"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B159,ManuSales,0),$B$28)","v":0.12809999999999999},0.12827,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A159,0)","v":"Lincoln"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G159,MakeSales,0),$B$28)","v":0.12529999999999999},0.12547,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A159,0)","v":"Minivan"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L159,SgmtSales,0),$B$28)","v":0.15629999999999999},0.15647]
[18,{"$f":"OFFSET(DiscountPct!$A$8,A160,0)","v":"Industry"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B160,ManuSales,0),$B$28)","v":0.1234},0.12358,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A160,0)","v":"Mazda"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G160,MakeSales,0),$B$28)","v":9.2299999999999993E-2},9.2479999999999993E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A160,0)","v":"Premium Luxury Car"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L160,SgmtSales,0),$B$28)","v":0.1069},0.10707999999999999]
[19,{"$f":"OFFSET(DiscountPct!$A$8,A161,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B161,ManuSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$29,A161,0)","v":"Mercedes-Benz"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G161,MakeSales,0),$B$28)","v":0.1265},0.12669,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A161,0)","v":"Premium Luxury SUV"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L161,SgmtSales,0),$B$28)","v":5.8999999999999997E-2},5.919E-2]
[20,{"$f":"OFFSET(DiscountPct!$A$8,A162,0)","v":"Discount Percent by Make"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B162,ManuSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$29,A162,0)","v":"MINI"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G162,MakeSales,0),$B$28)","v":5.8200000000000002E-2},5.8400000000000001E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A162,0)","v":"Premium Sport Car"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L162,SgmtSales,0),$B$28)","v":7.5399999999999995E-2},7.5600000000000001E-2]
[21,{"$f":"OFFSET(DiscountPct!$A$8,A163,0)","v":"Make"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B163,ManuSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$29,A163,0)","v":"Mitsubishi"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G163,MakeSales,0),$B$28)","v":0.1283},0.12850999999999999,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A163,0)","v":"Subcompact Car"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L163,SgmtSales,0),$B$28)","v":7.3200000000000001E-2},7.3410000000000003E-2]
[22,{"$f":"OFFSET(DiscountPct!$A$8,A164,0)","v":"Acura"},{"$f":"OFFSET(DiscountPct!$A$8,MATCH(B164,ManuSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$29,A164,0)","v":"Nissan"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G164,MakeSales,0),$B$28)","v":0.1535},0.15372,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A164,0)","v":"Van"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L164,SgmtSales,0),$B$28)","v":0.13739999999999999},0.13761999999999999]
[23,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A165,0)","v":"Ram"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G165,MakeSales,0),$B$28)","v":0.16950000000000001},0.16973000000000002,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A165,0)","v":"Industry"},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L165,SgmtSales,0),$B$28)","v":0.1234},{"$f":"IF(OR(M165=0,M165=\"\"),\"\",M165+A165/100000)","v":0.12362999999999999}]
[24,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A166,0)","v":"Scion"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G166,MakeSales,0),$B$28)","v":2.3400000000000001E-2},2.3640000000000001E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A166,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L166,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[25,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A167,0)","v":"smart"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G167,MakeSales,0),$B$28)","v":0},"",null,null,{"$f":"OFFSET(DiscountPct!$A$63,A167,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L167,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[26,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A168,0)","v":"Subaru"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G168,MakeSales,0),$B$28)","v":7.9500000000000001E-2},7.9759999999999998E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A168,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L168,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[27,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A169,0)","v":"Suzuki"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G169,MakeSales,0),$B$28)","v":9.3700000000000006E-2},9.3970000000000012E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A169,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L169,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[28,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A170,0)","v":"Toyota"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G170,MakeSales,0),$B$28)","v":0.1053},0.10558000000000001,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A170,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L170,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[29,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A171,0)","v":"Volkswagen"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G171,MakeSales,0),$B$28)","v":0.12809999999999999},0.12839,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A171,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L171,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[30,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A172,0)","v":"Volvo"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G172,MakeSales,0),$B$28)","v":9.3399999999999997E-2},9.3699999999999992E-2,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A172,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L172,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[31,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A173,0)","v":"Industry"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G173,MakeSales,0),$B$28)","v":0.1234},0.12371,null,null,{"$f":"OFFSET(DiscountPct!$A$63,A173,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L173,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[32,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A174,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G174,MakeSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$63,A174,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L174,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[33,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A175,0)","v":"Discount Percent by Vehicle Segment"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G175,MakeSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$63,A175,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L175,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[34,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A176,0)","v":"Segment"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G176,MakeSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$63,A176,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L176,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[35,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A177,0)","v":"Compact Car"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G177,MakeSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$63,A177,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L177,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[36,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A178,0)","v":"Compact Crossover SUV"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G178,MakeSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$63,A178,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L178,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[37,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A179,0)","v":"Compact Truck"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G179,MakeSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$63,A179,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L179,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[38,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A180,0)","v":"Entry Luxury Car"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G180,MakeSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$63,A180,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L180,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[39,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A181,0)","v":"Entry Luxury SUV"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G181,MakeSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$63,A181,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L181,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[40,null,null,null,null,null,{"$f":"OFFSET(DiscountPct!$A$29,A182,0)","v":"Entry Sport Car"},{"$f":"OFFSET(DiscountPct!$A$29,MATCH(G182,MakeSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,{"$f":"OFFSET(DiscountPct!$A$63,A182,0)","v":0},{"$f":"OFFSET(DiscountPct!$A$63,MATCH(L182,SgmtSales,0),$B$28)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]