This help page describes the gap-to-target (GTT) spreadsheet model which is downloadable from the ‘Review performance’ screen in the M&R system. The model contains energy and emissions data for your organisation. The GTT can be used to model the impact of implementing additional energy reduction and decarbonisation measures on your organisation's gap to the 2030 emissions and energy efficiency targets.
There is additional step-by-step guidance on how to model additional energy reduction and decarbonisation measures using the GTT at GTT model - modelling a 2030 scenario.
The GTT model is available from the ‘Review performance’ screen within the M&R system, i.e. you must be logged in to the M&R system to download the model.
The worksheet tabs are colour-coded as follows:
- Dark green worksheets contain introductory and explanatory text.
- Pale green worksheets are the only worksheets in which you can enter data into the GTT.
- Pale blue worksheets display your 2023 energy & CO2 data.
- Mid blue worksheets present your 2030 targets and gap to targets.
- Dark blue worksheets show your energy and CO2 data over time, from the start of your organisation's energy efficiency baseline to 2050.
- Purple worksheets list the energy projects reported by your organisation via M&R.
- Grey worksheets show conversion and emission factors for different energy types.
- Orange worksheets (hidden) contain 'raw' data downloaded from the M&R system.
- Red worksheets (hidden) are for SEAI use only.
The data status of the data downloaded with the GTT model is shown in the ‘GTT model’ section of the ‘Intro’ worksheet. The status depends on when you download the model:
- If you download the model between the post-DVA deadline and the subsequent provisional scorecard date, it will contain the final data as of the post-DVA deadline.
- If you download the model between the provisional scorecard date and the subsequent post-DVA deadline, it will contain provisional data as of the provisional scorecard date.
- Only enter data in the pale green cells. Some cells change to pale green when you enter values in other cells.
- All rows in which you can enter data have bright green formatting on the extreme left. On these rows, you may need to scroll off-screen to the right to find all of the pale green cell(s) in which you should enter data.
- Some pale green cells are prepopulated with data using formulae. You can overwrite these values if you believe you have a better value.
- Some rows are grouped together (hidden) to make it easier to review the data. You can expand (unhide) these rows by clicking on the ‘+’ buttons immediately to the left of the row numbers.
- All the worksheets are protected to reduce the risk of inadvertently deleting or editing formulae. However, the worksheets can be unprotected without a password.
The ‘Model’ worksheet is for modelling the impact of additional energy reduction and decarbonisation initiatives on your organisation.
This sunburst chart shows a breakdown of your organisation's 2023 final energy consumption by energy type.
This sunburst chart shows a breakdown of your organisation's 2023 CO2 emissions by energy type.
This chart shows your organisation’s 2030 fossil CO2 target.
- The first stacked bar shows your organisation's fossil CO2 at its GHG baseline.
- The second stacked bar shows your organisation's fossil CO2 for the most recent year.
- A staked bar labelled ‘2030 (modelled)’ may also be displayed. This shows the fossil CO2 emissions you have modelled for your organisation for 2030.
- The right-most stacked bar shows your organisation's 2030 fossil CO2 target.
This chart shows your organisation’s 2030 total CO2 target.
- The first stacked bar shows your organisation's total CO2 at its GHG baseline.
- The second stacked bar shows your organisation's total CO2 for the most recent year.
- A stacked bar labelled ‘2030 (modelled)’ may also be displayed. This shows the total CO2 emissions you have modelled for your organisation for 2030.
- The right-most stacked bar shows your organisation's 2030 total CO2 target.
This worksheet comprises a table, two waterfall charts and a sunburst chart. Together, they illustrate the impact of your modelled scenario on closing the gap to the 2030 CO2 targets.
- The table summarises the two CO2 targets for your organisation
- Row 5 shows your CO2 emissions at the GHG baseline
- Row 6 shows any change in CO2 emissions since the baseline
- Row 7 shows your CO2 emissions for the most recent year
- Rows 9-19 show the future changes in CO2 arising from the additional energy reduction and decarbonisation measures that you have modelled in the ‘Model’ worksheet.
- Row 21 shows the modelled CO2 emissions for 2030, accounting for the additional energy reduction and decarbonisation measures that you have incorporated into the model
- Row 22 shows any outstanding gap to the 2030 targets, i.e. the gap between the modelled emissions for 2030 (row 21) and the 2030 targets (row 23).
- The first waterfall chart shows data for the fossil CO2 target:
- The first bar shows fossil CO2 at the GHG baseline
- The second bar shows changes in fossil CO2 since the baseline
- The third bar shows fossil CO2 for the most recent year.
- The fourth bar (blue outline) shows the impact of anticipated supply-side changes (biofuels) between the most recent reporting year and 2030.
- The eight green bars show the impact of additional energy reduction and decarbonisation measures that you have incorporated into the model.
- A red bar ('increased energy use (fossil)') shows the impact of any increased consumption that you have incorporated into the model.
- The third-from-right bar (grey) shows the modelled fossil CO2 for 2030, accounting for the additional measures that you have modelled.
- The outstanding gap to the 2030 target (if any) is shown in orange in the second-from-right bar.
- The 2030 fossil CO2 target is shown in the right-most bar (purple).
- The second waterfall chart shows equivalent data for the total CO2 target:
- The first bar shows total CO2 at the GHG baseline
- The second bar shows changes in total CO2 since the baseline
- The third bar shows total CO2 for the most recent year.
- The fourth bar (blue outline) shows the impact of anticipated supply-side changes (electricity & biofuels) between the most recent reporting year and 2030.
- The eight green bars show the impact of additional energy reduction and decarbonisation measures that you have incorporated into the model.
- A red bar ('increased energy use') shows the impact of any increased consumption that you have incorporated into the model.
- The third-from-right bar (grey) shows the modelled total CO2 for 2030, accounting for the additional measures that you have modelled.
- The outstanding gap to the 2030 target (if any) is shown in orange in the second-from-right bar.
- The 2030 total CO2 target is shown in the right-most bar (purple).
- The sunburst chart shows a breakdown of the modelled CO2 emissions for your organisation in 2030.
This chart shows your organisation's fossil CO2 emissions over time, including its progress towards the 2030 fossil CO2 target and beyond to 2050.
- The stacked bars shown for the years up to 2023 show your organisation's actual fossil emissions, broken down between thermal (brown) and transport (orange).
- The baseline fossil CO2 emissions are indicated with a dashed grey line.
- The fossil CO2 target is shown with a purple bar.
- The dashed purple line from the GHG baseline to the 2030 target is a trajectory to the target based on a constant reduction in fossil CO2 from baseline to the target.
- The dashed red line shows the business-as-usual (BAU) emissions pathway, which is calculated on the basis that your organisation’s final energy consumption remains unchanged from 2023 onward. The changes to fossil CO2 over this period are those arising from anticipated supply-side changes (biofuels).
- The stacked bars shown for the years 2024 onwards indicate a fossil CO2 emissions pathway incorporating the additional energy reduction and decarbonisation measures that you have modelled in the GTT.
This chart shows your organisation's total CO2 emissions over time, including its progress towards the 2030 total CO2 target and beyond to 2050.
- The stacked bars shown for the years up to 2023 show your organisation's actual CO2 emissions, broken down between thermal (brown), transport (orange) and electricity (blue).
- The baseline total CO2 emissions are indicated with a dashed grey line.
- The fossil CO2 target is shown with a stacked purple bar.
- The dashed purple line from the GHG baseline to the 2030 target is a trajectory to the target that accounts for anticipated changes to the CO2 intensity of Ireland's electricity grid.
- The dashed red line shows the business-as-usual (BAU) emissions pathway, which is calculated on the basis that your organisation’s final energy consumption remains unchanged from 2023 onward. The changes to total CO2 over this period are those arising from anticipated supply-side changes (electricity and biofuels).
- The stacked bars shown for the years 2024 onward indicate a total CO2 emissions pathway incorporating the additional energy reduction and decarbonisation measures that you have modelled in the GTT.
This chart shows your organisation's electricity CO2 emissions over time.
- The bars shown for the years up to 2023 show your organisation's actual CO2 emissions from electricity.
- The dashed red line shows the business-as-usual (BAU) emissions pathway, which is calculated on the basis that your organisation’s final energy consumption of electricity remains unchanged from 2023 onward. The changes over this period are those arising from anticipated supply-side changes.
- The bars shown for the years 2024 onward indicate an electricity CO2 emissions pathway incorporating the additional energy reduction and decarbonisation measures that you have modelled in the GTT.
This chart shows how your organisation's energy performance, as tracked using an organisation-level energy performance indicator (EnPI), has changed over time.
- The purple bars shown for the years up to 2023 indicate your organisation's EnPI, expressed on a normalised basis.
- The navy line from the energy efficiency baseline to the 2030 target is a trajectory based on a constant improvement in energy performance over time.
- The dashed red line shows the business-as-usual (BAU) energy performance pathway, which is calculated on the basis that your organisation’s final energy consumption remains unchanged from 2023 onward. The changes over this period are those arising from anticipated supply-side changes.
- The pink bars shown for the years 2024 onward indicate an energy performance pathway incorporating the additional energy reduction measures that you have modelled in the GTT.
- This chart shows your organisation's total final energy consumption over time.
- The stacked bars shown for the years up to 2023 show your organisation's final energy consumption, broken down between thermal (brown), transport (orange) and electricity (blue).
- A short horizontal navy line indicates the total final energy consumption in 2021.
- The dashed navy line indicates an energy-reduction trajectory based on an annual reduction of 1.9% from the 2021 level from 2025 onwards.
- The dashed red line shows the business-as-usual (BAU) energy consumption pathway, which is calculated on the basis that your organisation’s final energy consumption remains unchanged from 2023 onward.
- The stacked bars shown for the years 2024 onward indicate a total final consumption pathway incorporating the additional energy reduction measures that you have modelled in the GTT.
The projects reported by your organisation via the M&R system are listed in two purple worksheets:
- ‘M&R projects - future’ lists all projects for which you have assigned project status ‘planned’, ‘tentative’ or ‘potential opportunity’ in the M&R system.
- ‘M&R projects - implemented’ lists all projects for which you have assigned project status ‘implemented’ in the M&R system.
Please note:
- The project data presented in the two purple worksheets is not linked to any calculations in any other worksheets in the GTT.
- It is not possible to upload energy projects from the GTT to the M&R system. If you wish to upload projects to the M&R system, you should use the designated M&R template (which is different to the GTT) and use the upload functionality.
This worksheet contains the conversion and emission factors used for the calculations in the GTT.
This chart displays the emission factor for grid electricity, which is used for the calculations in the GTT.
- Like all calculation models, the results (outputs) generated by the GTT are entirely dependent on the inputs entered by the user. It also incorporates several simplifying assumptions.
- Several key calculations, including the target configuration calculations for GHGs and the gap-to-target calculations are very sensitive to forecasts for future values of the primary energy conversion factor and the CO2 emission factor for Ireland’s electricity system. SEAI prepares forecasts for both these factors, which are refined continually. The forecasts incorporate a large number of variables and assumptions. You should carefully consider their appropriateness for use in your particular circumstances, particularly if using the forecast values for making investment decisions.
- The GHG and energy efficiency targets for every public sector organisation are calculated and presented in SEAI's M&R software. Every organisation's progress towards these targets, and its gap to the targets, are also calculated and presented in the M&R system. In any instance where values in the GTT spreadsheet differ from those presented in the M&R software, then the values and results shown in the M&R software are deemed to take precedence.
- Several of the worksheets in the GTT are protected. However, they can be unprotected without the requirement for a password.
- GTT model - modelling a 2030 scenario
- 2030 GHG emissions targets
- 2030 energy efficiency target