Spreadsheet: 525317d1498665618-use-multiple-levels-of-dropdown-to-populate-a-worksheet-vehicle-sort
Sheet: Data (2)

Design Parent | Program | Production Nameplate | Production Plant | CY 2016 | CY 2017 | Jan 2017 | Feb 2017 | Mar 2017 | Apr 2017 | May 2017 | Jun 2017 | Jul 2017 | Aug 2017 | Sep 2017 | Oct 2017 | Nov 2017 | Dec 2017
FCA | DJ | 2500/3500 | [NAME] | 198677 | 201046 | 18106 | 18066 | 19091 | 16226 | 17604 | 18306 | 18306 | 19011 | 9859 | 18306 | 15491 | 12674
FCA | DS | 1500 | [NAME] | 83863 | 80410 | 6874 | 6685 | 7301 | 6627 | 7190 | 7479 | 7479 | 7766 | 4026 | 7479 | 6327 | 5177
FCA | DS | 1500 | [NAME] | 340868 | 342070 | 23712 | 28462 | 32657 | 28710 | 32155 | 32155 | 29858 | 24116 | 29858 | 32155 | 26413 | 21819
FCA | FF | 500 | Toluca | 12576 | 11868 | 1773 | 1072 | 1061 | 1068 | 1015 | 1023 | 2559 | 2297 | 0 | 0 | 0 | 0
FCA | JC49 | Journey | Toluca | 120139 | 81349 | 17209 | 14425 | 12756 | 4880 | 1269 | 1280 | 2844 | 3937 | 5906 | 6562 | 5687 | 4594
FCA | JK72 | [NAME] | Toledo Supplier Park | 59638 | 59125 | 4788 | 4983 | 5702 | 4508 | 5124 | 5329 | 5124 | 5533 | 4713 | 5123 | 4304 | 3894
FCA | JK74 | [NAME] | Toledo Supplier Park | 178912 | 177363 | 14363 | 14948 | 17107 | 13525 | 15369 | 15983 | 15369 | 16599 | 14140 | 15370 | 12910 | 11680
FCA | JL74 | [NAME] | Toledo North | 0 | 12028 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2716 | 9312
FCA | KL | Cherokee | Belvidere | 0 | 143153 | 0 | 0 | 0 | 0 | 1843 | 9984 | 15360 | 21772 | 23040 | 27206 | 23020 | 20928
FCA | KL | Cherokee | Toledo North | 241784 | 63595 | 17150 | 18925 | 25410 | 2110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FCA | LA | Challenger | Brampton | 75705 | 74844 | 4421 | 6421 | 7668 | 5117 | 6984 | 6984 | 3201 | 7566 | 6693 | 6693 | 7566 | 5530
FCA | LD | Charger | Brampton | 104493 | 100521 | 7061 | 7601 | 8401 | 7037 | 9603 | 9602 | 4402 | 10403 | 9204 | 9203 | 10402 | 7602
FCA | LX | 300 | Brampton | 57169 | 56357 | 4179 | 4685 | 5242 | 3839 | 5238 | 5237 | 2401 | 5675 | 5020 | 5020 | 5674 | 4147
FCA | MK49 | Compass | Belvidere | 104915 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FCA | MK74 | [NAME] | Belvidere | 146598 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FCA | MP | Compass | Toluca | 0 | 202009 | 83 | 794 | 4850 | 9302 | 23089 | 23290 | 23032 | 26576 | 23624 | 26248 | 22748 | 18373
FCA | PF | Dart | Belvidere | 30086 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FCA | RT | [NAME] | Windsor | 174061 | 165393 | 13233 | 15666 | 17983 | 16114 | 18374 | 18607 | 7437 | 20853 | 9187 | 6562 | 6999 | 14378
FCA | RT | Town & Country | Windsor | 36302 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FCA | RU | [NAME] | Windsor | 98100 | 127199 | 8767 | 10216 | 10910 | 8676 | 12249 | 13474 | 7145 | 11228 | 11228 | 15311 | 7583 | 10412
FCA | UF | 200 | Sterling Heights | 42805 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FCA | WD75 | Durango | [NAME] | 77536 | 74492 | 6729 | 6539 | 7437 | 6057 | 6542 | 6784 | 4603 | 6784 | 6299 | 6542 | 5331 | 4845
FCA | WK74 | Grand Cherokee | [NAME] | 282615 | 282408 | 22870 | 24341 | 26612 | 23490 | 25368 | 26308 | 17852 | 26308 | 24429 | 25368 | 20670 | 18792
FCA | ZD | Viper | Conner Avenue | 649 | 496 | 69 | 69 | 78 | 54 | 66 | 63 | 60 | 37 | 0 | 0 | 0 | 0
Ford | B299N | [NAME] | Cuautitlan #1 | 69090 | 77828 | 6893 | 6581 | 7496 | 5600 | 8316 | 7394 | 4989 | 5613 | 6548 | 6860 | 5925 | 5613
Ford | C344 | C-Max | Michigan Assembly | 18801 | 20402 | 2159 | 965 | 1543 | 2233 | 2372 | 2647 | 1186 | 2048 | 1258 | 1078 | 1616 | 1297
Ford | C346 | Focus | Michigan Assembly | 162426 | 190038 | 17016 | 8643 | 14832 | 15712 | 19190 | 17717 | 9593 | 20712 | 16711 | 20484 | 16351 | 13077
Ford | C489 | MKC | Louisville | 41781 | 53252 | 3532 | 4330 | 5870 | 4934 | 4892 | 5269 | 3935 | 5312 | 5621 | 3654 | 3092 | 2811
Ford | C520 | [NAME] | Louisville | 346657 | 362943 | 31221 | 31238 | 34251 | 28807 | 32742 | 32365 | 24171 | 32631 | 29512 | 32885 | 27825 | 25295
Ford | CD391 | Fusion | Flat Rock | 7864 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ford | CD391 | Fusion | Hermosillo | 279159 | 238308 | 18848 | 11676 | 30927 | 19368 | 22369 | 19174 | 17042 | 22369 | 17042 | 19450 | 21738 | 18305
Ford | CD533 | MKZ | Hermosillo | 42287 | 44523 | 2323 | 1662 | 4752 | 3909 | 5247 | 4498 | 3998 | 5247 | 3998 | 2906 | 3248 | 2735
Ford | CD539 | Edge | Oakville | 191998 | 183090 | 17191 | 14789 | 17705 | 13978 | 16870 | 16625 | 8964 | 17929 | 15042 | 15892 | 15706 | 12399
Ford | D258(2) | Taurus | Chicago | 59125 | 54541 | 4824 | 4550 | 5508 | 4755 | 5406 | 4054 | 2547 | 5614 | 4223 | 5068 | 4288 | 3704
Ford | D385 | MKS | Chicago | 3114 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ford | D471 | Flex | Oakville | 27131 | 24783 | 1421 | 1993 | 1606 | 2030 | 2445 | 2445 | 1423 | 2561 | 2212 | 2689 | 2212 | 1746
Ford | D472 | MKT | Oakville | 3564 | 2796 | 233 | 246 | 169 | 259 | 244 | 244 | 284 | 256 | 221 | 244 | 221 | 175
Ford | D544 | Continental | Flat Rock | 14586 | 34162 | 3193 | 3142 | 3589 | 2910 | 3450 | 2932 | 1811 | 3246 | 4234 | 1961 | 1847 | 1847
Ford | P473 | F-250/350 Super Duty | [NAME] | 167071 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ford | P552 | [NAME] | Dearborn Truck | 92925 | 72286 | 4961 | 5607 | 5967 | 4864 | 6901 | 5867 | 4472 | 8281 | 7987 | 6645 | 5623 | 5111
Ford | P552 | [NAME] | Kansas City #2 | 99494 | 98845 | 6743 | 8523 | 9599 | 8119 | 8973 | 8973 | 4832 | 10251 | 8916 | 9871 | 7212 | 6833
Ford | P552 | F-150 SuperCrew | Dearborn Truck | 279367 | 295602 | 26044 | 25541 | 29126 | 25533 | 27602 | 28637 | 13418 | 26222 | 23961 | 26580 | 22491 | 20447
Ford | P552 | F-150 SuperCrew | Kansas City #2 | 222769 | 216014 | 15008 | 17303 | 22399 | 18943 | 20937 | 20937 | 11273 | 20811 | 19844 | 20040 | 14645 | 13874
Ford | P558 | F-250/350 Super Duty | [NAME] | 128894 | 316931 | 29924 | 29845 | 31430 | 24967 | 30251 | 31227 | 7220 | 25605 | 29567 | 32405 | 23145 | 21345
Ford | S550 | Mustang | Flat Rock | 142382 | 135184 | 13860 | 13760 | 14185 | 10364 | 13799 | 10396 | 6812 | 10869 | 11447 | 10300 | 9696 | 9696
Ford | S922 | GT | [NAME] | 2 | 143 | 2 | 5 | 2 | 6 | 10 | 12 | 15 | 17 | 19 | 21 | 19 | 15
Ford | U222(2) | Expedition | [NAME] | 57017 | 34161 | 5421 | 5082 | 5744 | 4886 | 6471 | 6483 | 74 | 0 | 0 | 0 | 0 | 0
Ford | U228(2) | Navigator | [NAME] | 8697 | 6213 | 640 | 1163 | 1030 | 1221 | 958 | 1186 | 15 | 0 | 0 | 0 | 0 | 0
Ford | U354 | Expedition EL | [NAME] | 18797 | 5348 | 934 | 941 | 1436 | 862 | 574 | 593 | 8 | 0 | 0 | 0 | 0 | 0
Ford | U418 | Navigator L | [NAME] | 2865 | 960 | 214 | 167 | 258 | 243 | 38 | 39 | 1 | 0 | 0 | 0 | 0 | 0
Ford | U502 | Explorer | Chicago | 323300 | 314946 | 26487 | 27194 | 30038 | 25731 | 28380 | 29732 | 15645 | 29471 | 28264 | 28718 | 24300 | 20986
Ford | U540 | MKX | Oakville | 48801 | 50930 | 3120 | 3933 | 4018 | 4018 | 4890 | 5134 | 3557 | 4866 | 4645 | 5623 | 3982 | 3144
Ford | U553 | Expedition | [NAME] | 0 | 6660 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 457 | 1233 | 2370 | 2600
Ford | U553 | Expedition Max | [NAME] | 0 | 4206 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 152 | 881 | 1394 | 1779
Ford | U554 | Navigator | [NAME] | 0 | 2366 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 183 | 528 | 697 | 958
Ford | U554 | Navigator L | [NAME] | 0 | 1261 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 122 | 176 | 279 | 684
Ford | V363 | Transit | Kansas City #1 | 152886 | 144530 | 9631 | 13573 | 15415 | 12441 | 15566 | 14747 | 6554 | 13704 | 9533 | 13108 | 10725 | 9533
Ford | [NAME] | E-Series | Ohio Assembly | 55275 | 58509 | 4581 | 3808 | 6241 | 5321 | 6317 | 6063 | 2874 | 5652 | 4265 | 5355 | 4462 | 3570