On behalf of the Swedish Environmental Protection Agency (Naturvårdsverket), SMED has updated and further developed an Excel tool that can be used by government agencies to calculate emission of carbon dioxide and climate gasesfrom business travel and other use of vehicles and machinery.
The purpose of this task was to meet the requirements of the Regulation (2009:907) on Environmental Management in Government Agencies, as well as to be used as a general tool to calculate the climate emissions of agency transportation/vehicle and machinery use. The tool in its early form included only carbon dioxide emissions, not other greenhouse gases, during transportation/use and did not account for related indirect emissions, such as emissions during the production of fuel or the vehicle. In 2018, the tool was further developed, including changes in categories and interfaces to better describe the current transportation situation. More climate gases were included (methane and nitrous oxide), and emission values to produce fuels were added. Additionally, the high-altitude effect for aviation was included in the climate impact value. From 2019 to 2022, a simpler update and minor development of the tool took place.
In the 2023 version of the tool, some new categories for emission calculations have been added, such as diesel trains in Europe, as well as the flight routes Stockholm-Visby and Stockholm-Umeå.
In the 2023 version of the tool, most emission values for road traffic are significantly lower (about 2-20 %) than in the 2022 version, reflecting continued electrification and an increased share of biofuels in diesel and gasoline. For taxis, values have decreased by 10-20% per kilometer, explained by an increased number of electric cars in the fleet. At the same time, emissions per unit of currency increase in Stockholm, attributed to lower prices in the city center.
For buses in public transportation, emissions per passenger-kilometer decreased significantly, on average for the whole of Sweden by 38 %. This reflects a rapid change towards increasing fossil-free fuels and electrification. In a few counties, emissions increase, especially in Gothenburg (+42 %), due to a return to fossil diesel and decreased use of HVO. For public transportation buses, emission values can change significantly between two years, reflecting rapid changes in bus fleets, fuel combinations, and occupancy rates in each region.
For rail traffic, emissions are generally lower than the previous year (about 20 %), but the differences vary by about +/- 60 %. Changes can be attributed to changes in energy use and occupancy, especially for trams, after the pandemic has subsided. For aviation, emissions decrease relatively significantly for most flight routes (0-40 %) based on data from ICAO's tool and previous calculations. This can be explained by higher occupancy after the pandemic. The exception is Malmö – Östersund, which increases significantly for unknown reasons.
SMED refrains from providing specific recommendations for the tool's future improvement and development as the Regulation (2009:907) on Environmental Management in Government Agencies is under review. SMED intends to return with suggestions on how the tool can be developed once any new regulation is decided.
The updates made in this work are considered sufficient for the tool to maintain a generally good quality for emission calculations in the year 2023.