Source: https://tendernation.io/opportunities/01a13bf8-c7c8-70fd-af20-5d37b1bb92f1/quality-assurance-of-excel-based-energy-and-emissions-projections-model

closed GB open procedure Suitable for SMEs

# Quality Assurance of Excel based Energy and Emissions Projections Model

[Department of Energy and Climate Change](https://tendernation.io/buyers/department-of-energy-and-climate-change)

Incumbent usually keeps it

Estimated value

£15,000 to £20,000

Published

22 May 2015

Deadline

Closed

12 Jun 2015

## Who can bid

- Buyer says suitable for SMEs

    The buyer ticked “suitable for SMEs” on the notice. Anyone can still bid.
- Small contract value

    Valued under £135,018 including VAT, the lowest Procurement Act threshold for goods and services.
- Open procedure

    Anyone can submit a full tender; there is no shortlisting stage.

[More contracts for small businesses and VCSEs](https://tendernation.io/opportunities/for-small-businesses)

## About this tender

Quality Assurance of Excel based Energy and Emissions Projections Model.

Full details of the contract requirements are given in the attached ITT.

The Energy and Emissions Projections (EEP) is an annual DECC publication involving complex modelling. The modelling analyses and projects future energy use and greenhouse gas emissions in the UK. These projections allow us to monitor progress towards meeting the UKâ&#128;&#153;s carbon budgets and are used to inform energy policy and associated analytical work across government departments. It is one of DECCâ&#128;&#153;s business critical models, as the projections are used extensively to inform policy and analysis, and provide consistency in analysis and valuation of policy across Whitehall.

The modelling is done in Excel using 38 different workbooks, which individually model different sectors and fuels. Work has recently been carried out to update these workbooks.The purpose of this work is to use the DECC QA guidance (available to view at [gov.uk](https://www.gov.uk/government/organisations/department-of-energy-climate-change/about/procurement#analytical-modelling)) to review all 38 spreadsheets and help improve our confidence in them. Further detail on the spreadsheets is given in the attached ITT.

The work will involve three stages.

- Reading and understanding our guidance (link above) and the tools we use to review Microsoft Excel Spreadsheets.
- Working through the EEP files systematically, identifying issues within them.
- Communicating these issues and their degree of seriousness to the DECC project team, agreeing the corrective actions that need to be taken, and summarising the status of the model in the DECC QA log format

The type of issues that will need to be identified and corrected will range from errors within formulae, to poor best-practice, such as units not being included in tables or formulae containing hard-coded numbers. If time is limited, actual errors will need to be prioritised over best practice issues.

There is no requirement to review the methodology within the model, as this has already been done as part of the development.

Read full description

## CPV classification

Software package and information systems

Source

Contracts Finder (UK)

[View official notice](https://www.contractsfinder.service.gov.uk/notice/6c2cd394-adc8-11e6-9901-0019b9f3037b)

Never miss a tender like this again

Get AI summaries, deadline alerts and a bid pipeline for tenders matched to your business. Free to start.

[Track tenders free](https://tendernation.io/register)

[Buyer profile Department of Energy and Climate Change: past awards and live tenders](https://tendernation.io/buyers/department-of-energy-and-climate-change) [Sector More Software packages & information systems tenders](https://tendernation.io/sectors/software-information-systems)

## More tenders like this

[Software package and information systems – Smart život a služby v meste Liptovský Mikuláš · Mesto Liptovský Mikuláš · 22 days left · 10 Nov 2026](https://tendernation.io/opportunities/01a156a9-8b56-73a0-8eb6-a47a2de359b0/slovakia-software-package-and-information-systems-smart-zivot-a-sluzby-v-mes) [Servers – Dodávka Cisco Catalyst Center · Ústav organické chemie a biochemie AV ČR, v. v. i. · 32 days left · 20 Nov 2026](https://tendernation.io/opportunities/01a156a9-9f50-7023-a3e7-14aa2b5fbe03/czechia-servers-dodavka-cisco-catalyst-center) [Software package and information systems – System wykrywania anomalii w ruchu SMTP w oparciu o Self-Learning AI · Narodowy Bank Polski · 31 days left · 19 Nov 2026](https://tendernation.io/opportunities/01a156a9-6291-7294-b080-d589aa9cf0c0/poland-software-package-and-information-systems-system-wykrywania-anomalii-w) [Software package and information systems – AutoDesk Lizenzen · Hamburger Energienetze GmbH · 25 days left · 13 Nov 2026](https://tendernation.io/opportunities/01a156a9-63e1-72f3-8854-0907e37f21fa/germany-software-package-and-information-systems-autodesk-lizenzen) [IT software package – Dostawa pakietów subskrypcji Microsoft albo pakietów równoważnych · Państwowa Inspekcja Pracy Główny Inspektorat Pracy · 36 days left · 24 Nov 2026](https://tendernation.io/opportunities/01a156a9-98e4-702f-a918-9b94f1198862/poland-it-software-package-dostawa-pakietow-subskrypcji-microsoft-albo-pakie) [Servers – Ausschreibung CITRIX Wartungsverlängerung ab 2027 · Hannoversche Informationstechnologien AöR / hannIT · 4 days left · 23 Oct 2026](https://tendernation.io/opportunities/01a156a9-615c-713f-93e6-da09a76b2c98/germany-servers-ausschreibung-citrix-wartungsverlangerung-ab-2027)
