For those of you who care, here is the Powershell 2.0 code that gets you all vehicles between 40 and 121 combined city/hwy MPG:
(1) Download:
www.fueleconomy.gov/feg/EPAGreenGuide/txt/all_alpha_13.txt
(2) Run this Powershell 2.0 code:
$All13= import-csv -Delim `t .\all_alpha_13.txt
$OverMPG=foreach ($i in 40..121) { $All13 | ? {$_."Cmb MPG" -match $i}}
$OverMPG | Select Model, '* MPG','Stnd Description' | ft -auto
Model City MPG Hwy MPG Cmb MPG Stnd Description
----- -------- ------- ------- ----------------
LEXUS ES 300h 40 39 40 Federal Tier 2 Bin 3
LEXUS ES 300h 40 39 40 California LEV-II SULEV
TOYOTA Avalon Hybrid 40 39 40 Federal Tier 2 Bin 3
TOYOTA Avalon Hybrid 40 39 40 California LEV-II SULEV
TOYOTA Camry Hybrid XLE 40 38 40 Federal Tier 2 Bin 3
TOYOTA Camry Hybrid XLE 40 38 40 California PZEV
TOYOTA Camry Hybrid LE 43 39 41 Federal Tier 2 Bin 3
TOYOTA Camry Hybrid LE 43 39 41 California PZEV
HONDA Insight 41 44 42 Federal Tier 2 Bin 3
HONDA Insight 41 44 42 Federal Tier 2 Bin 2
HONDA Insight 41 44 42 California PZEV
HONDA Insight 41 44 42 Federal Tier 2 Bin 3
HONDA Insight 41 44 42 Federal Tier 2 Bin 2
HONDA Insight 41 44 42 California PZEV
LEXUS CT 200h 43 40 42 Federal Tier 2 Bin 3
LEXUS CT 200h 43 40 42 California LEV-II SULEV
TOYOTA Prius v 44 40 42 Federal Tier 2 Bin 3
TOYOTA Prius v 44 40 42 California LEV-II SULEV
FORD C-MAX PHEV 44/108 41/92 43/100 Federal Tier 2 Bin 3
FORD C-MAX PHEV 44/108 41/92 43/100 California PZEV
FORD Fusion PHEV 44/108 41/92 43/100 Federal Tier 2 Bin 3
FORD Fusion PHEV 44/108 41/92 43/100 California PZEV
LINCOLN MKZ Hybrid 45 45 45 Federal Tier 2 Bin 3
VOLKSWAGEN Jetta Hybrid 42 48 45 Federal Tier 2 Bin 3
VOLKSWAGEN Jetta Hybrid 42 48 45 California PZEV
FORD C-MAX Hybrid 47 47 47 Federal Tier 2 Bin 3
FORD Fusion Hybrid 47 47 47 Federal Tier 2 Bin 3
TOYOTA Prius 51 48 50 Federal Tier 2 Bin 3
TOYOTA Prius 51 48 50 California PZEV
TOYOTA Prius Plug-in Hybrid 51/90 49/102 50/95 Federal Tier 2 Bin 3
TOYOTA Prius Plug-in Hybrid 51/90 49/102 50/95 California PZEV
TOYOTA Prius c 53 46 50 Federal Tier 2 Bin 3
TOYOTA Prius c 53 46 50 California LEV-II SULEV
CODA Coda 77 68 73 Federal Tier 2 Bin 1
CODA Coda 77 68 73 California ZEV
TOYOTA RAV4 EV 78 74 76 Federal Tier 2 Bin 1
TESLA Model S 88 90 89 Federal Tier 2 Bin 1
TESLA Model S 94 97 95 Federal Tier 2 Bin 1
TOYOTA Prius Plug-in Hybrid 51/90 49/102 50/95 Federal Tier 2 Bin 3
TOYOTA Prius Plug-in Hybrid 51/90 49/102 50/95 California PZEV
CHEVROLET Volt 35/101 40/93 37/98 Federal Tier 2 Bin 4
CHEVROLET Volt 35/101 40/93 37/98 Federal Tier 2 Bin 2
CHEVROLET Volt 35/101 40/93 37/98 California PZEV
FORD C-MAX PHEV 44/108 41/92 43/100 Federal Tier 2 Bin 3
FORD C-MAX PHEV 44/108 41/92 43/100 California PZEV
FORD Fusion PHEV 44/108 41/92 43/100 Federal Tier 2 Bin 3
FORD Fusion PHEV 44/108 41/92 43/100 California PZEV
FORD Focus BEV 110 99 105 Federal Tier 2 Bin 1
FORD Focus BEV 110 99 105 California ZEV
SMART ForTwo Cabriolet 122 93 107 Federal Tier 2 Bin 1
SMART ForTwo Cabriolet 122 93 107 California ZEV
SMART ForTwo Coupe 122 93 107 Federal Tier 2 Bin 1
SMART ForTwo Coupe 122 93 107 California ZEV
MITSUBISHI i-MiEV 126 99 112 Federal Tier 2 Bin 1
MITSUBISHI i-MiEV 126 99 112 California ZEV
FIAT 500e 122 108 116 Federal Tier 2 Bin 1
FIAT 500e 122 108 116 California ZEV
NISSAN Leaf 130 102 116 Federal Tier 2 Bin 1
NISSAN Leaf 130 102 116 California ZEV
HONDA Fit 132 105 118 Federal Tier 2 Bin 1
HONDA Fit 132 105 118 California ZEV
SCION iQ EV 138 105 121 Federal Tier 2 Bin 1
SCION iQ EV 138 105 121 California ZEV
