Home > Resources > Model Downloads
Here you can find the last three major model updates to GHGenius. To access you must be registered and logged into the forums. The files are zipped, any OS newer than Windows XP should be able to unzip natively; otherwise you will need a utility such as 7-zip or WinZip to unzip the files. The model requires Lotus 123 until version 2.6, or Excel after version 3.0. The Excel versions will always require medium or low security selected to run macros.
The tags under each model description will take you to reports related to that keyword.
This work introduces and develops a new functional unit to GHGenius so that the tool can be applied to freight transportation systems that are employed to move goods. This function unit is a tonne-km, being the movement of one tonne of goods one kilometre. Previously only a unit of energy or the distance travelled were used as functional units in GHGenius. This new measure provides a reference for very different systems that are commonly used to move freight.
This work includes a new output sheet for the results. The emissions are presented for all of the GHG and CAC emissions in the model.
The modes of freight that have been included are truck, rail, marine and some preliminary information for airfreight. Multiple classes for marine transportation are presented, as there is a difference in emissions according to vessel type and size.
The fuels that have been included are marine/rail fuel oil, ultra low sulphur diesel fuel, gasoline, biodiesel, hydrotreated renewable diesel, and CNG and LNG. Not all fuels are used for all modes of transportation. It has been necessary to split the existing combined CNG/LNG column on the Upstream Results sheet into two columns so that LNG data is always available. The capacity to model these additional fuels provides considerable additional information for the user.
Prepared February 2010
Tags: Freight GHGenius 3.17
This work includes a new output sheet for the results. The emissions are presented for all of the GHG and CAC emissions in the model.
The modes of freight that have been included are truck, rail, marine and some preliminary information for airfreight. Multiple classes for marine transportation are presented, as there is a difference in emissions according to vessel type and size.
The fuels that have been included are marine/rail fuel oil, ultra low sulphur diesel fuel, gasoline, biodiesel, hydrotreated renewable diesel, and CNG and LNG. Not all fuels are used for all modes of transportation. It has been necessary to split the existing combined CNG/LNG column on the Upstream Results sheet into two columns so that LNG data is always available. The capacity to model these additional fuels provides considerable additional information for the user.
Prepared February 2010
Tags: Freight GHGenius 3.17
This new version of the model includes the addition of Algae and jatropha as feedstocks for biodiesel production. In addition all biodiesel feedstocks can also now be hydrotreated to produce a HRD product. The reference to SuperCetane in the model has now been replaced by the more generic term HRD.
This version of the model also includes an update of the following data in GHGenius. In some cases the structure of the model has been slightly changed to accommodate the time series but any difference in the results is due to the new input data and not due to any structural changes in the way that the model handles the new data.
1. International crude oil energy and emissions. Several new data sources have recently been identified. These include the International Oil and Gas Association (a time series from 2002 of the energy and GHG emissions of crude oil production for various regions of the world), data from the Alberta Energy Research Institute studies (some specific useful information for countries such as Mexico, Venezuela, Iraq, and Saudi Arabia), and the World Bank flaring study.
2. Canadian electricity. A time series of electric power production on a regional basis in Canada from 2000 has been be developed from Statistics Canada data. Regional generation efficiencies and proportions of power types have been extracted from the data.
3. Rail energy. Statistics Canada has a time series data for freight movement on Class 1 railways. This data has been compared to similar information from the United States and incorporated in the model.
4. Potash mining. Statistics Canada, CIEEDAC, and NRCan Comprehensive Energy Use Database provide a time series for energy consumption, quantity and type. This has been compared to the NRCan CIPEC report that was used as a data source in the model. The new information has been incorporated into the model.
5. Nitrogen fertilizer. Statistics Canada, CIEEDAC, and NRCan Comprehensive Energy Use Database all have a time series for information on this sector. These data sets do not include process energy consumption but that can be calculated. The data sets have been compared to the NRCan CIPEC report that was the base of data in the model.
6. Corn and Soybeans. Fertilizer and yield time series available from the USDA. Some Statistics Canada yield data on these crops and other Canadian crops is available as well. This time series data has been incorporated into the model.
7. Ethanol and Biodiesel energy requirements. New data from the United States is available for both these alternative fuels. An update and development of a time series for ethanol has been incorporated into the model.
8. Some users have identified a number of enhancements for the functioning of the EV macro in GHGenius. These modifications have been incorporated into GHGenius. They provide more functionality and having them in the public model will allow them to be continually updated as model enhancements are undertaken.
9. Natural gas update. The Canadian Gas Association has provided some recent information on distribution emissions. Unfortunately the report did not provide activity data but that that has been developed from other sources. In addition Statistics Canada has data on the natural gas sector and this will be reviewed to see if it can be worked into the model.
A change in two of the macros has been made. The Run Program button on the Input Sheet no longer runs the EV macro. There is now a separate button for that. The EV macro can also be accessed through the GHGenius drop down menu on the tool bar.
Prepared September 2009
Tags: Algae Biodiesel Biodiesel C rude Oil Corn Electricity Ethanol Fertilizer GHGenius 3.16 HRD Jatropha Natural Gas Soybeans SupeCetane
This version of the model also includes an update of the following data in GHGenius. In some cases the structure of the model has been slightly changed to accommodate the time series but any difference in the results is due to the new input data and not due to any structural changes in the way that the model handles the new data.
1. International crude oil energy and emissions. Several new data sources have recently been identified. These include the International Oil and Gas Association (a time series from 2002 of the energy and GHG emissions of crude oil production for various regions of the world), data from the Alberta Energy Research Institute studies (some specific useful information for countries such as Mexico, Venezuela, Iraq, and Saudi Arabia), and the World Bank flaring study.
2. Canadian electricity. A time series of electric power production on a regional basis in Canada from 2000 has been be developed from Statistics Canada data. Regional generation efficiencies and proportions of power types have been extracted from the data.
3. Rail energy. Statistics Canada has a time series data for freight movement on Class 1 railways. This data has been compared to similar information from the United States and incorporated in the model.
4. Potash mining. Statistics Canada, CIEEDAC, and NRCan Comprehensive Energy Use Database provide a time series for energy consumption, quantity and type. This has been compared to the NRCan CIPEC report that was used as a data source in the model. The new information has been incorporated into the model.
5. Nitrogen fertilizer. Statistics Canada, CIEEDAC, and NRCan Comprehensive Energy Use Database all have a time series for information on this sector. These data sets do not include process energy consumption but that can be calculated. The data sets have been compared to the NRCan CIPEC report that was the base of data in the model.
6. Corn and Soybeans. Fertilizer and yield time series available from the USDA. Some Statistics Canada yield data on these crops and other Canadian crops is available as well. This time series data has been incorporated into the model.
7. Ethanol and Biodiesel energy requirements. New data from the United States is available for both these alternative fuels. An update and development of a time series for ethanol has been incorporated into the model.
8. Some users have identified a number of enhancements for the functioning of the EV macro in GHGenius. These modifications have been incorporated into GHGenius. They provide more functionality and having them in the public model will allow them to be continually updated as model enhancements are undertaken.
9. Natural gas update. The Canadian Gas Association has provided some recent information on distribution emissions. Unfortunately the report did not provide activity data but that that has been developed from other sources. In addition Statistics Canada has data on the natural gas sector and this will be reviewed to see if it can be worked into the model.
A change in two of the macros has been made. The Run Program button on the Input Sheet no longer runs the EV macro. There is now a separate button for that. The EV macro can also be accessed through the GHGenius drop down menu on the tool bar.
Prepared September 2009
Tags: Algae Biodiesel Biodiesel C rude Oil Corn Electricity Ethanol Fertilizer GHGenius 3.16 HRD Jatropha Natural Gas Soybeans SupeCetane
There have been two changes to the model as part of version 3.15. The first was to develop “Provincial” versions of the model.
This has been accomplished by the addition of a series of default buttons on the Input Sheet. These buttons change the model to the appropriate region, the correct provincial power mix, the appropriate crude oil slate, and the correct petroleum product distribution patterns. Like other default values in the model the user can still overwrite the cells so that no functionality is lost. There are default values developed for BC, Alberta, Saskatchewan, Manitoba, Ontario, Quebec, and Atlantic Canada.
The second change was the addition of two biomethane pathways for transportation fuels. There is increased interest in biomethane in the transportation sector. This term means different things to different people but would typically include landfill gas and the output from anaerobic digestion. The production of landfill gas is already included in GHGenius as a feedstock for methanol production but for this work its use is expanded to compress the gas and use it as CNG or liquefy it to produce LNG.
Anaerobic digestion of biological waste and agricultural residues is a rapidly expanding industry in Europe. Part of the drive there is a result of significant government incentives but there will be situations in Canada where environmental requirements drive the application of this technology and we will likely see some further expansion of the availability of bio-methane in Canada.
Anaerobic digestion (AD) is applied using mostly waste materials (manure, food and beverage wastes, etc.) rather then AD involving feedstocks grown specifically to produce biogas. It is unlikely that this later option will be adopted in North America unless the value of the biogas approaches that in the very heavily subsidized European markets. Hay, as a substitute for silage, as a feedstock for the AD process is modelled so that some sensitivity to non-waste products can be accessed. The structure of the model has been set so that any of the four agricultural residues can be used as a feedstock, either alone or in combination with manure.
The gas from the landfill or the digester will be cleaned up and either compressed or liquefied so that it can be used as a transportation fuel for light and heavy-duty applications.
Tags: Anaerobic Digestion Biomethane GHGenius 3.15 LFG Manure Municipal Solid Waste Natural Gas
This has been accomplished by the addition of a series of default buttons on the Input Sheet. These buttons change the model to the appropriate region, the correct provincial power mix, the appropriate crude oil slate, and the correct petroleum product distribution patterns. Like other default values in the model the user can still overwrite the cells so that no functionality is lost. There are default values developed for BC, Alberta, Saskatchewan, Manitoba, Ontario, Quebec, and Atlantic Canada.
The second change was the addition of two biomethane pathways for transportation fuels. There is increased interest in biomethane in the transportation sector. This term means different things to different people but would typically include landfill gas and the output from anaerobic digestion. The production of landfill gas is already included in GHGenius as a feedstock for methanol production but for this work its use is expanded to compress the gas and use it as CNG or liquefy it to produce LNG.
Anaerobic digestion of biological waste and agricultural residues is a rapidly expanding industry in Europe. Part of the drive there is a result of significant government incentives but there will be situations in Canada where environmental requirements drive the application of this technology and we will likely see some further expansion of the availability of bio-methane in Canada.
Anaerobic digestion (AD) is applied using mostly waste materials (manure, food and beverage wastes, etc.) rather then AD involving feedstocks grown specifically to produce biogas. It is unlikely that this later option will be adopted in North America unless the value of the biogas approaches that in the very heavily subsidized European markets. Hay, as a substitute for silage, as a feedstock for the AD process is modelled so that some sensitivity to non-waste products can be accessed. The structure of the model has been set so that any of the four agricultural residues can be used as a feedstock, either alone or in combination with manure.
The gas from the landfill or the digester will be cleaned up and either compressed or liquefied so that it can be used as a transportation fuel for light and heavy-duty applications.
Tags: Anaerobic Digestion Biomethane GHGenius 3.15 LFG Manure Municipal Solid Waste Natural Gas