# Quality Assurance and Redevelopment of UK TIMES Industry Input Spreadsheets

> Contract award record from UK public-sector procurement sources.

## Key facts

- Public buyer: Department of Energy and Climate Change \(DECC\)
- Contract winner: Cambridge Energy
- Award value: £265,150
- Tender value: £270,000
- Award date: 12 January 2016
- Published: 18 November 2016
- Contract start: 18 January 2016
- Contract end: 31 March 2016
- Stage: awarded
- Procurement category: services
- Notice ID: 18499f13-4c1d-46f7-bb9e-93b9a2a6cbd9-87586
- OCID: ocds-b5fd17-501bb683-adc9-11e6-9901-0019b9f3037b

## Description

DECC is looking for a contractor or contractors to: •carry out a partial formula audit; and, •reconstruct a set of Microsoft Excel work books using DECC standard model quality assurance guidance and spreadsheet template https://www\.gov\.uk/government/collections/quality-assurance-tools-and-guidance-in-decc\. The workbooks are known as “backing sheets”\. They calculate a set of input parameters for eight sectors of a whole system energy model built in the TIMES software\. N\.B there is no requirement for the contractor to be familiar with this software\. The final output of the project will be a set of reconfigured work books that: •are structured according to agreed best-practice, following key principles such as high levels of transparency and easy traceability; •contain as few workbooks and worksheets as possible but no fewer; •are well documented, with: oin-model documentation \(N\.B\. high level documentation describing the structure of the model will be supplied\) of each of the calculations and assumptions \(with sources\) in the input work books; oinput variables identified and referenced; and, •include the facility for ranges for the most “important” variables - for uncertainty analysis\. The existing work book structure is complex for each sector there are many interlinked work books\. There are approximately 285 work books\. The complexity of each sector varies\. The table below shows approximate numbers of equations in each of the sectorial models\. Agriculture324 Electricity1899 Industry5513 Processes1634 Residential4115 Resources733 Services2814 Transport6406 For background information, the full specification and further information on this project please see the ITT\. The successful bidder will need project management expertise to deliver the evaluation, in particular because a significant proportion of the core funding for this project is allocated to the financial year 2014-15\. Break points will be built into the contract\.

## Related contract awards

- [Support for Development and Delivery of the Industrial Energy Efficiency Innovation Programme \(IEEA\)](/contracts/ocds-b5fd17-284d3a53-5ec0-4b9a-b5ed-59a300f788dd): Department of Energy and Climate Change \(DECC\)
- [Annual Fuel Poverty Modelling for England](/contracts/ocds-b5fd17-aaf81c7a-adc9-11e6-9901-0019b9f3037b): Department of Energy and Climate Change \(DECC\)
- [Specialist offshore environmental and decommissioning services](/contracts/ocds-b5fd17-3b4275a0-adca-11e6-9901-0019b9f3037b): Department of Energy and Climate Change \(DECC\)
- [Energy Quality Assurance Service for Marston Paddock Development - AWARD](/contracts/ocds-b5fd17-9e49e3ae-dae2-42db-a810-f371e82d0696): Oxford City Council
- [Energy Quality Assurance service for Railway Lane Development \(Keepers Place\) - AWARD](/contracts/ocds-b5fd17-feda0c31-f002-4889-80e3-f1a06b256ad9): Oxford City Council
- [Provision of Energy Quality Assurance for Princes Street and Collins Street Developments](/contracts/ocds-b5fd17-3c15624e-c737-4d4c-812f-8f57bfb203b5): Oxford City Council

## Source

[View the original notice on Contracts Finder](https://www.contractsfinder.service.gov.uk/Notice/18499f13-4c1d-46f7-bb9e-93b9a2a6cbd9-87586)