United Nations Environment Programme

Print Version

Tool 18: Inventory and Options Tool

Tool 18 is designed to help you develop your own clean fleet strategy by assessing your fleet's emissions alongside available technology and policy options. Click here to launch [in English, Polish, Hungarian or Spanish] and use the step-by-step spreadsheet that works with your specific fleet's characteristics. Tool 18 is designed to be user-friendly, but if you experience difficulty launching the Excel spreadsheet, or saving your work, then consult the easy user's manual.

Tool 18 is divided into four steps:


1. Fill in your basic fleet data.

You can also review the results for the 'Example Fleet' already available in the Tool to get an idea of how the Tool will use your fleet's data and the options that it provides. When you're ready to start using your own data, just replace the example for your tailored results and recommendations.

2. Review your impacts, including your fleet's air pollutant and carbon dioxide emissions

3.View and summarize your options - calculate fuel and emissions savings from basic to more advanced solutions

4. Develop indicators to monitor your progress

For the latest updates, support and case studies log on to http://www.unep.org/tnt-unep/toolkit/

The information in most sheets is calculated based on the input in the sheet Fleet Inventory. Therefore, only three sheets are collected in this textbook.

Fleet Inventory


Sheet: Emission Factors

This page includes information about the emission factors used in this tool. The emission factors provide the amount of pollutant emitted per kilometre. For example, at the sheet called "Impacts - Your Emissions" you will note that the cells contain formulas like the next one: (53*E11/1000000). Here "53" is the emission factor indicating that per kilometre driven 53 grams will be emitted of this specific pollutant. If you have the emission factors for your specific situation you can change the spreadsheet and include your own emissions factors. To do so go to the "Impacts - Your Emissions" sheet, unprotect it, and change the emissions factors.

emissionfactorsemissionfactorsB What do these emission factors tell you ?
The emission factors (average emissions per km measured in g/km) used in this tool represent emissions from real-life driving conditions in Nairobi, Kenya.

The emission factors are calculated using the IVE model 1.1.1a, based on a Nairobi study by California University at Riverside and UNEP.

How were these emission factors calculated in the IVE model ?
The emission factors in the IVE model are dependent on (i) driving patterns, (ii) vehicle standards, (iii) fuel quality and (iv) road conditions (incl. geographical setting). The emission factors used in this tool are calculated assuming that driving patterns and road conditions are similar to those in Nairobi. These conditions are similar to most cities in developing countries.

The different vehicle types and standards in the list above and the fuel quality (5000 ppm used as default) were selected in the model. The IVE model emissions factors are quite high, higher than those used for legislated purposes like the EU or US standards, because they are based on real life driving conditions rather than an ideal and predefined "regulatory" driving pattern.

Why do we use these emission factors?
There are two major reasons we did not use existing regulatory emissions standards like Euro 1- 5 or US Tier 1 and Tier II.

    1. The "Nairobi Overall Driving Cycle" used in the IVE model resembles real life driving conditions that are similar in most developing country cities.

    2. The IVE model provides us with have a solid baseline because it includes all types of vehicles found on the road, from very clean to very old and dirty. This minimises the risk of the emission factors being biased in any particular way.

For more information about these emissions factors and the model used to develop them, please visit the following website: http://www.gssr.net/ive/index.html

Sheet: Fuel to km converter