Quality Assurance of Excel based Energy and Emissions Projections Model
Department of Energy & Climate Change · United Kingdom
Key facts
- Estimated value
- £20,000
- Closing date
- 12 Jun 2015
- Contract starts
- 23 Jun 2015
- Contract ends
- 08 Jul 2015
- Procedure
- Not applicable
- Buyer type
- Central government
Description
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âs carbon budgets and are used to inform energy policy and associated analytical work across government departments. It is one of DECCâ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 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. 1) Reading and understanding our guidance (link above) and the tools we use to review Microsoft Excel Spreadsheets. 2) Working through the EEP files systematically, identifying issues within them. 3) 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.
Categories (CPV)
Similar open tenders
ENQ1406 - LED Screens, Staging, PA Equipment and Lighting Equipment for Derby LIVE Events
Location: East MidlandsBuyer: Derby City Council
Open tenderCloses 11 Nov, 20266 daysValue £95.00kSource Find a TenderThis quotation is for the supply, installation and de-rig of staging, LED screens, PA and Lighting equipment for Derby LIVE Events. **Please note this procurement has been reserved to suppliers with substantive business operations within the administrative boundary of Derby City Council. The Council is committed to sup
System Adnoddau Dynol Chwaraeon Cymru / Sport Wales Human Resources System
Location: WalesBuyer: Sport Wales
Open tenderCloses 4 Dec, 202629 daysValue £225.00kSource Find a TenderMae Chwaraeon Cymru yn chwilio am blatfform Adnoddau Dynol modern, sy'n canolbwyntio ar y defnyddiwr, i gefnogi cylch bywyd llawn cyflogeion, o recriwtio hyd at gyflogaeth, datblygu a rheoli'r gweithlu. Mae Chwaraeon Cymru yn dymuno caffael datrysiadau sy'n cyflawni’r canlynol: • Darparu profiad defnyddiwr modern a gre
The Spencer Academy Trusts Microsoft Licensing & Support Services
Location: East MidlandsBuyer: THE SPENCER ACADEMIES TRUST
Open tenderCloses 23 Nov, 202618 daysValue £525.00kSource Find a TenderSpencer Academies Trust is seeking a suitably qualified supplier to provide Microsoft Licensing and Support Services. The contract will include the provision, management and support of the Trust's Microsoft licensing estate, including Microsoft 365 A3 and Microsoft 365 A5 licensing, licence administration, subscription
Global Travel, Accommodation and Venue Management Services
Location: North WestBuyer: Government Commercial Agency
Open tenderCloses 8 Dec, 202633 daysValue £36.25bnSource Find a TenderA framework providing comprehensive booking solutions for all UK Public Sector Travel needs, including air, rail, taxis, coaches, car hire, accommodation and venues for meetings, conferences and events, as well as emergency travel and accommodation solutions, including for civilian cohorts under the care of a UK Public
The Provision of Work Planning Software Application [642]
Location: IrelandBuyer: Commission for Regulation of Utilities
Open tenderCloses 30 Nov, 202625 daysValue €210.00KSource TEDThe CRU prepares a Strategic Plan on a three-year cycle and develops annual Work Plans to support delivery of its priorities, objectives and outcomes. Progress is monitored quarterly through Work Plan review reports and monthly through Focus Area Reports for selected highpriority programmes, projects and organisational
LEGO299 End-to-End Reporting, Budgeting, Forecasting and Financial Reporting Solution
Location: West MidlandsBuyer: The Office for Legal Complaints
Open tenderCloses 30 Nov, 202625 daysValue £100.00kSource Find a TenderA fit-for-purpose budgeting, forecasting and financial reporting solution that automates LeO's existing Finance processes, integrates with relevant source systems and can be operated by Finance following implementation.