| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Gasoline Car | |||||||||||||||
| 2 | ||||||||||||||||
| 3 | ||||||||||||||||
| 4 | Vehicle Information | Avg. Vehicle Costs | Avg. Cumlative Costs | Cumalitve Cost + Mitigation | ||||||||||||
| 5 | Avg. Economy (MPG) | 20 | Avg. Annual Repairs | $800.00 | 2 year cost | $23,800.00 | 2 year cost | $24,073.59 | ||||||||
| 6 | Weight (Lbs) | 3000 | Avg. Purchase Price | $18,000.00 | 5 year cost | $32,500.00 | 5 year cost | $33,050.08 | ||||||||
| 7 | Seatbelts | 5 | Avg. Annual Fuel Cost | $2,100.00 | 10 year cost | $47,000.00 | 10 year cost | $48,010.89 | ||||||||
| 8 | ||||||||||||||||
| 9 | Green Car Score | Driving Emissions | Avg. CO2 Production (lbs) | Green Tags | Mitagation Cost | |||||||||||
| 10 | Commuter | -111 | CO2 | 614 | g/mile | Annual | 20321.9 | 9.2 | $92.16 | |||||||
| 11 | Average | -47 | Nox | 0.09 | g/mile | Manufacturing | 19682.9 | 8.9 | $89.26 | |||||||
| 12 | Carpooler | 30 | PM | 0.03 | g/mile | 2 year Total | 60326.7 | 27.4 | $273.59 | |||||||
| 13 | Custom Driver | -14 | VOC | 0.30 | g/mile | 5 year Total | 121292.4 | 55.0 | $550.08 | |||||||
| 14 | Fuel Cost ($/mile) | $0.14 | SOX | 0.01 | g/mile | 10 year Total | 222902.0 | 101.1 | $1,010.89 | |||||||
| 15 | ||||||||||||||||
| 16 | ||||||||||||||||
| 17 | Green Car Score Break Down | Commuter | Average | Carpooler | Custom Driver | Calculations Based On | ||||||||||
| 18 | Environmental Impact | Base Score | 100 | 100 | 100 | 100 | Miles/Year | 15000 | ||||||||
| 19 | Oil | -63.5 | -43.7 | -19.6 | -33.3 | Gasoline | $2.80 | |||||||||
| 20 | Global Warming | Carbon Dioxide | -85.7 | -60.1 | -28.9 | -46.7 | Biodiesel | $3.29 | ||||||||
| 21 | Acid Rain/Smog | Nitrous Oxide | -23.2 | -16.1 | -7.3 | -12.3 | Electric | $0.08 | ||||||||
| 22 | Respiratory | Particulate Matter | -12.7 | -9.0 | -4.5 | -7.1 | Diesel | $2.90 | ||||||||
| 23 | Smog/Cancer | Volitile Ogranic Compounds | -11.2 | -7.7 | -3.5 | -5.9 | WVO | $0.70 | ||||||||
| 24 | Asthma | Sulfur Dioxide | -14.4 | -10.6 | -6.1 | -8.7 | ||||||||||
| 25 | Green Car Score | -110.7 | -47.2 | 30.1 | -13.9 | |||||||||||
| 26 | ||||||||||||||||
| 27 | ||||||||||||||||
| 28 | See Complete Calculations Below | |||||||||||||||
| 29 | ||||||||||||||||
| 30 | ||||||||||||||||
| 31 | Commuter | Average | Goal | 20000 | Person Miles/ Year | |||||||||||
| 32 | Person Miles Per Gallon | % Use | Avg PMPG | Person Miles Per Gallon | % Use | Avg PMPG | Average | Commuter | Carpooler | Custom | ||||||
| 33 | 1 | 20.0 | 0.95 | 19.0 | 1.0 | 20.0 | 0.65 | 13.0 | 655.7 | 952.38095 | 294.11765 | 500 | ||||
| 34 | 2 | 40.0 | 0.05 | 2.0 | 2.0 | 40.0 | 0.22 | 8.8 | Gallons Consumed | |||||||
| 35 | 3 | 60.0 | 0.00 | 0.0 | 3.0 | 60.0 | 0.08 | 4.8 | ||||||||
| 36 | 4 | 80.0 | 0.00 | 0.0 | 4.0 | 80.0 | 0.02 | 1.6 | ||||||||
| 37 | 5 | 100.0 | 0.00 | 0.0 | 5.0 | 100.0 | 0.01 | 1.0 | Driving Emissions g/gallon | Average | Commuter | Carpooler | Custom | |||
| 38 | 6 | 60.0 | 0.00 | 0.0 | 6.0 | 60.0 | 0.01 | 0.6 | CO2 | 12287.3 | 8057245.9 | 11702190.5 | 3613911.8 | 6143650.0 | ||
| 39 | 7 | 70.0 | 0.00 | 0.0 | 7.0 | 70.0 | 0.01 | 0.7 | Nox | 1.74 | 1141.0 | 1657.1 | 511.8 | 870.0 | ||
| 40 | 1 | 21.0 | 1.00 | 30.5 | PM | 0.667 | 437.4 | 635.2 | 196.2 | 333.5 | ||||||
| 41 | VOC | 5.9 | 3868.9 | 5619.0 | 1735.3 | 2950.0 | ||||||||||
| 42 | Carpooler | Custom | SOX | 0.232 | 152.1 | 221.0 | 68.2 | 116.0 | ||||||||
| 43 | Person Miles Per Gallon | % Use | Avg PMPG | Person Miles Per Gallon | % Use | Avg PMPG | Emissions g/year | |||||||||
| 44 | 1 | 20.0 | 0.00 | 0.0 | 1.0 | 20.0 | 0.10 | 2.0 | ||||||||
| 45 | 2 | 40.0 | 0.00 | 0.0 | 2.0 | 40.0 | 0.80 | 32.0 | Upstream Fuel Emissions | |||||||
| 46 | 3 | 60.0 | 0.00 | 0.0 | 3.0 | 60.0 | 0.10 | 6.0 | g/gallon | Average | Commuter | Carpooler | Custom | |||
| 47 | 4 | 80.0 | 0.00 | 0.0 | 4.0 | 80.0 | 0.00 | 0.0 | CO2 | 2388.7 | 1566360.65574 | 2274952.38095 | 702558.82353 | 1194350 | ||
| 48 | 5 | 100.0 | 0.10 | 10.0 | 5.0 | 100.0 | 0.00 | 0.0 | Nox | 0.0685 | 44.91803 | 65.23810 | 20.14706 | 34.25 | ||
| 49 | 6 | 60.0 | 0.50 | 30.0 | 6.0 | 60.0 | 0.00 | 0.0 | PM | 0.2625 | 172.13115 | 250.0 | 77.20588 | 131.25 | ||
| 50 | 7 | 70.0 | 0.40 | 28.0 | 7.0 | 70.0 | 0.00 | 0.0 | Sox | 6.0375 | 3959.01639 | 5750 | 1775.73529 | 3018.75 | ||
| 51 | 1 | 68.0 | 1.00 | 40.0 | Emissions g/year | |||||||||||
| 52 | ||||||||||||||||
| 53 | Average | Commuter | Carpooler | Custom | ||||||||||||
| 54 | EPA Fuel Economy | MPG | 30.5 | 21.0 | 68.0 | 40.0 | Manufacturing Grams | 15k year life | ||||||||
| 55 | City | 24 | CO2 | 10218806.6 | 14572342.9 | 4911670.6 | 7933200.0 | CO2 | 8928000.0 | 595200.0 | g/year | |||||
| 56 | Highway | 31 | Nox | 1203.9 | 1740.4 | 549.9 | 922.3 | Nox | 270.0 | 18.0 | g/year | |||||
| 57 | PM | 673.5 | 949.2 | 337.4 | 528.8 | PM | 960.0 | 64.0 | g/year | |||||||
| 58 | VOC | 3868.9 | 5619.0 | 1735.3 | 2950.0 | Sulfur | 18120.0 | 1208.0 | g/year | |||||||
| 59 | Sox | 5319.1 | 7179.0 | 3052.0 | 4342.8 | |||||||||||
| 60 | ||||||||||||||||
| 61 | Factor | Annual Impact | Average | Commuter | Carpooler | Custom | Total Emissions g/year | |||||||||
| 62 | Fossil Fuel Depletion | 15 | Gallons | -43.7 | -63.5 | -19.6 | -33.3 | Average | Commuter | Carpooler | Custom | |||||
| 63 | Global Warming | 170000 | CO2 | -60.1 | -85.7 | -28.9 | -46.7 | CO2 | 10218806.6 | 14572342.9 | 4911670.6 | 7933200.0 | ||||
| 64 | Acid Rain/Smog | 75 | Nox | -16.1 | -23.2 | -7.3 | -12.3 | Nox | 1203.9 | 1740.4 | 549.9 | 922.3 | ||||
| 65 | Respiratory | 75 | PM | -9.0 | -12.7 | -4.5 | -7.1 | PM | 673.5 | 949.2 | 337.4 | 528.8 | ||||
| 66 | Smog/Cancer | 500 | VOC | -7.7 | -11.2 | -3.5 | -5.9 | VOC | 3868.9 | 5619.0 | 1735.3 | 2950.0 | ||||
| 67 | Asthma | 500 | Sox | -10.6 | -14.4 | -6.1 | -8.7 | SOX | 5319.1 | 7179.0 | 3052.0 | 4342.8 | ||||
| 68 | Total Impact | -147.2 | -210.7 | -69.9 | -113.9 | |||||||||||
| 69 | Base Score | 100.0 | ||||||||||||||
| 70 | Green Car Score | -47.2 | -110.7 | 30.1 | -13.9 | |||||||||||
| 71 | ||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Biodiesel Car | |||||||||||||||
| 2 | ||||||||||||||||
| 3 | ||||||||||||||||
| 4 | Vehicle Information | Avg. Vehicle Costs | Avg. Cumlative Costs | Cumalitve Cost + Mitigation | ||||||||||||
| 5 | Avg. Economy (MPG) | 30 | Avg. Annual Repairs | $800.00 | 2 year cost | $22,890.00 | 2 year cost | $23,005.66 | ||||||||
| 6 | Weight (Lbs) | 3000 | Avg. Purchase Price | $18,000.00 | 5 year cost | $30,225.00 | 5 year cost | $30,380.24 | ||||||||
| 7 | Seatbelts | 5 | Avg. Annual Fuel Cost | $1,645.00 | 10 year cost | $42,450.00 | 10 year cost | $42,671.22 | ||||||||
| 8 | ||||||||||||||||
| 9 | Green Car Score | Driving Emissions | Avg. CO2 Production (lbs) | Green Tags | Mitagation Cost | |||||||||||
| 10 | Commuter | 34 | CO2 | 88 | g/mile | Annual | 2909.6 | 1.3 | $13.20 | |||||||
| 11 | Average | 52 | NOx | 0.08 | g/mile | Manufacturing | 19682.9 | 8.9 | $89.26 | |||||||
| 12 | Carpooler | 75 | PM | 0.03 | g/mile | 2 year Total | 25502.2 | 11.6 | $115.66 | |||||||
| 13 | Custom Driver | 62 | VOC | 0.05 | g/mile | 5 year Total | 34231.1 | 15.5 | $155.24 | |||||||
| 14 | Fuel Cost ($/mile) | $0.11 | SOx | 0.00 | g/mile | 10 year Total | 48779.4 | 22.1 | $221.22 | |||||||
| 15 | ||||||||||||||||
| 16 | ||||||||||||||||
| 17 | Green Car Score Break Down | Commuter | Average | Carpooler | Custom Driver | Calculations Based On | ||||||||||
| 18 | Environmental Impact | Base Score | 100 | 100 | 100 | 100 | Miles/Year | 15000 | ||||||||
| 19 | Oil | -14.1 | -9.7 | -4.4 | -7.4 | Gasoline | $2.80 | |||||||||
| 20 | Global Warming | Carbon Dioxide | -14.9 | -11.4 | -7.0 | -9.5 | Biodiesel | $3.29 | ||||||||
| 21 | Acid Rain/Smog | Nitrous Oxide | -20.9 | -14.5 | -6.6 | -11.1 | Electric | $0.08 | ||||||||
| 22 | Respiratory | Particulate Matter | -10.9 | -7.8 | -4.0 | -6.1 | Diesel | $2.90 | ||||||||
| 23 | Smog/Cancer | Volitile Ogranic Compounds | -1.9 | -1.3 | -0.6 | -1.0 | WVO | $0.70 | ||||||||
| 24 | Asthma | Sulfur Dioxide | -3.1 | -2.9 | -2.6 | -2.8 | ||||||||||
| 25 | Green Car Score | 34.1 | 52.4 | 74.8 | 62.1 | |||||||||||
| 26 | ||||||||||||||||
| 27 | ||||||||||||||||
| 28 | See Complete Calculations Below | |||||||||||||||
| 29 | ||||||||||||||||
| 30 | ||||||||||||||||
| 31 | Commuter | Average | Goal | 20000 | Person Miles/ Year | |||||||||||
| 32 | Person Miles Per Gallon | % Use | Avg PMPG | Person Miles Per Gallon | % Use | Avg PMPG | Average | Commuter | Carpooler | Custom | ||||||
| 33 | 1 | 30.0 | 0.95 | 28.5 | 1.0 | 30.0 | 0.65 | 19.5 | 437.2 | 634.92063 | 196.07843 | 333.33333 | ||||
| 34 | 2 | 60.0 | 0.05 | 3.0 | 2.0 | 60.0 | 0.22 | 13.2 | Gallons Consumed | |||||||
| 35 | 3 | 90.0 | 0.00 | 0.0 | 3.0 | 90.0 | 0.08 | 7.2 | ||||||||
| 36 | 4 | 120.0 | 0.00 | 0.0 | 4.0 | 120.0 | 0.02 | 2.4 | ||||||||
| 37 | 5 | 150.0 | 0.00 | 0.0 | 5.0 | 150.0 | 0.01 | 1.5 | Driving Emissions g/gallon | Average | Commuter | Carpooler | Custom | |||
| 38 | 6 | 90.0 | 0.00 | 0.0 | 6.0 | 90.0 | 0.01 | 0.9 | CO2 | 2638.75 | 1153551.9 | 1675396.8 | 517402.0 | 879583.3 | ||
| 39 | 7 | 105.0 | 0.00 | 0.0 | 7.0 | 105.0 | 0.01 | 1.1 | Nox | 2.3142 | 1011.7 | 1469.3 | 453.8 | 771.4 | ||
| 40 | 1 | 31.5 | 1.00 | 45.8 | PM | 1.03 | 450.3 | 654.0 | 202.0 | 343.3 | ||||||
| 41 | VOC | 1.5 | 655.7 | 952.4 | 294.1 | 500.0 | ||||||||||
| 42 | Carpooler | Custom | SOX | 0 | 0.0 | 0.0 | 0.0 | 0.0 | ||||||||
| 43 | Person Miles Per Gallon | % Use | Avg PMPG | Person Miles Per Gallon | % Use | Avg PMPG | Emissions g/year | |||||||||
| 44 | 1 | 30.0 | 0.00 | 0.0 | 1.0 | 30.0 | 0.10 | 3.0 | ||||||||
| 45 | 2 | 60.0 | 0.00 | 0.0 | 2.0 | 60.0 | 0.80 | 48.0 | Upstream Fuel Emissions | |||||||
| 46 | 3 | 90.0 | 0.00 | 0.0 | 3.0 | 90.0 | 0.10 | 9.0 | g/gallon | Average | Commuter | Carpooler | Custom | |||
| 47 | 4 | 120.0 | 0.00 | 0.0 | 4.0 | 120.0 | 0.00 | 0.0 | CO2 | 418.78 | 183073.22404 | 265892.06349 | 82113.72549 | 139593.33333 | ||
| 48 | 5 | 150.0 | 0.10 | 15.0 | 5.0 | 150.0 | 0.00 | 0.0 | Nox | 0.1313 | 57.39891 | 83.36508 | 25.74510 | 43.76667 | ||
| 49 | 6 | 90.0 | 0.50 | 45.0 | 6.0 | 90.0 | 0.00 | 0.0 | PM | 0.15846 | 69.27213 | 100.60952 | 31.07059 | 52.82 | ||
| 50 | 7 | 105.0 | 0.40 | 42.0 | 7.0 | 105.0 | 0.00 | 0.0 | Sox | 0.546 | 238.68852 | 346.66667 | 107.05882 | 182 | ||
| 51 | 1 | 102.0 | 1.00 | 60.0 | Emissions g/year | |||||||||||
| 52 | ||||||||||||||||
| 53 | Biodiesel | Average | Commuter | Carpooler | Custom | |||||||||||
| 54 | Net Enegy Profit Ratio | MPG | 45.8 | 31.5 | 102.0 | 60.0 | Manufacturing Grams | 15k year life | 1336625.1 | |||||||
| 55 | 3 | CO2 | 1931825.1 | 2536488.9 | 1194715.7 | 1614376.7 | CO2 | 8928000.0 | 595200.0 | g/year | ||||||
| 56 | Nox | 1087.1 | 1570.7 | 497.5 | 833.2 | Nox | 270.0 | 18.0 | g/year | |||||||
| 57 | EPA Fuel Economy | PM | 583.5 | 818.6 | 297.0 | 460.2 | PM | 960.0 | 64.0 | g/year | ||||||
| 58 | City | 34 | VOC | 655.7 | 952.4 | 294.1 | 500.0 | Sulfur | 18120.0 | 1208.0 | g/year | |||||
| 59 | Highway | 45 | Sox | 1446.7 | 1554.7 | 1315.1 | 1390.0 | |||||||||
| 60 | ||||||||||||||||
| 61 | Factor | Annual Impact | Average | Commuter | Carpooler | Custom | Total Emissions g/year | |||||||||
| 62 | Fossil Fuel Depletion | 15 | Gallons | -9.7 | -14.1 | -4.4 | -7.4 | Average | Commuter | Carpooler | Custom | |||||
| 63 | Global Warming | 170000 | CO2 | -11.4 | -14.9 | -7.0 | -9.5 | CO2 | 1931825.1 | 2536488.9 | 1194715.7 | 1614376.7 | ||||
| 64 | Acid Rain/Smog | 75 | Nox | -14.5 | -20.9 | -6.6 | -11.1 | Nox | 1087.1 | 1570.7 | 497.5 | 833.2 | ||||
| 65 | Respiratory | 75 | PM | -7.8 | -10.9 | -4.0 | -6.1 | PM | 583.5 | 818.6 | 297.0 | 460.2 | ||||
| 66 | Smog/Cancer | 500 | VOC | -1.3 | -1.9 | -0.6 | -1.0 | VOC | 655.7 | 952.4 | 294.1 | 500.0 | ||||
| 67 | Asthma | 500 | Sox | -2.9 | -3.1 | -2.6 | -2.8 | SOX | 1446.7 | 1554.7 | 1315.1 | 1390.0 | ||||
| 68 | Total Impact | -47.6 | -65.9 | -25.2 | -37.9 | |||||||||||
| 69 | Base Score | 100.0 | ||||||||||||||
| 70 | Green Car Score | 52.4 | 34.1 | 74.8 | 62.1 | |||||||||||
| 71 | ||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Gasoline Powered Hybrid | |||||||||||||||
| 2 | ||||||||||||||||
| 3 | ||||||||||||||||
| 4 | Vehicle Information | Avg. Vehicle Costs | Avg. Cumlative Costs | Cumalitve Cost + Mitigation | ||||||||||||
| 5 | Avg. Economy (MPG) | 35 | Avg. Annual Repairs | $500.00 | 2 year cost | $28,400.00 | 2 year cost | $28,595.21 | ||||||||
| 6 | Weight (Lbs) | 3000 | Avg. Purchase Price | $25,000.00 | 5 year cost | $33,500.00 | 5 year cost | $33,853.23 | ||||||||
| 7 | Seatbelts | 5 | Avg. Annual Fuel Cost | $1,200.00 | 10 year cost | $42,000.00 | 10 year cost | $42,616.61 | ||||||||
| 8 | Battery Weight | 100 | ||||||||||||||
| 9 | ||||||||||||||||
| 10 | Green Car Score | Driving Emissions | Avg. CO2 Production (lbs) | Green Tags | Mitagation Cost | |||||||||||
| 11 | Commuter | -26 | CO2 | 351 | g/mile | Annual | 11614.8 | 5.3 | $52.67 | |||||||
| 12 | Average | 10 | Nox | 0.05 | g/mile | Manufacturing | 19814.1 | 9.0 | $89.86 | |||||||
| 13 | Carpooler | 55 | PM | 0.02 | g/mile | 2 year Total | 43043.7 | 19.5 | $195.21 | |||||||
| 14 | Custom Driver | 29 | VOC | 0.17 | g/mile | 5 year Total | 77888.0 | 35.3 | $353.23 | |||||||
| 15 | Fuel Cost ($/mile) | $0.08 | SOX | 0.01 | g/mile | 10 year Total | 135961.9 | 61.7 | $616.61 | |||||||
| 16 | ||||||||||||||||
| 17 | ||||||||||||||||
| 18 | Green Car Score Break Down | Commuter | Average | Carpooler | Custom Driver | Calculations Based On | ||||||||||
| 19 | Environmental Impact | Base Score | 100 | 100 | 100 | 100 | Miles/Year | 15000 | ||||||||