TRN 964/01/2015 - Quality Assurance of Excel Based Energy Model
key details
| Value | £20,000 |
|---|---|
| Status | complete |
| Category (CPV) | 73000000 |
| Region | London |
| Deadline | 28 Jan 2015 |
| Contract start | 9 Feb 2015 |
| Contract end | 10 Apr 2015 |
| SME suitable | Yes |
| OCID | ocds-b5fd17-e4ea8e2e-adc8-11e6-9901-0019b9f3037b |
Award
| Supplier | Value | Date | Status |
|---|---|---|---|
| Hartley McMaster Ltd | £10,000 | 28 Jan 2015 | active |
description
The purpose of this contract is to hire in an experienced analyst to use the DECC QA guidance to review the UK TIMES analytical model and help improve our confidence in them. This will involve four stages.
| 1) | Reading and understanding our guidance and tools we use to review Microsoft Excel Spreadsheets. |
| 2) | Working through the UK TIMES files systematically, identifying issues with them. |
| 3) | Communicating these issues to the DECC project team and agreeing the corrective actions that need to be taken. |
| 4) | Implementing the agreed changes within the Spreadsheets. |
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.
There will not be a requirement to review the methodology of each sector within the model, as this has already been done as part of the development of the model.
The profile of a likely candidate will be someone with an Operational Research, or similar technical background, and who has experience of developing, maintaining or quality assuring complex excel based models. Advanced excel skills are essential.
The successful candidate will need to demonstrate that they are able to self-direct their work, and get to grips with the scale of the task, budgeting sufficient time to review all the spreadsheets they're given. They will also need to be able to communicate their findings succinctly and effectively to the DECC project team, and work closely with them to agree changes to the files
notice history
1 notice published against this procurement.
| Published | Type | Regime | Notice |
|---|---|---|---|
| 19 Oct 2015 | Award (award) | · | ocds-b5fd17-e4ea8e2e-adc8-11e6-9901-0019b9f3037b-77174-trn-964-01-2015 |
more from DEPARTMENT OF ENERGY AND CLIMATE CHANGE
- Assessing the cost reduction potential and competiveness of novel (next generation) UK carbon capture technology (contract extension) · £75,000 · 27 Mar 2017
- Project to produce an overview document and assist a Quality Assurance (QA) scoping study for the National Atmospheric Emissions Inventory (NAEI) models · £20,000 · 14 Feb 2017
- Technical expertise in social research application to low cost, low carbon homes research project · £21,700 · 14 Feb 2017
- CONTRACT FOR THE PROVISION OF EMERGENCY RESPONSE TRAINING TO THE DEPARTMENT FOR BUSINESS, ENERGY AND INDUSTRIAL STRATEGY · £282,924 · 23 Jan 2017
- CO2 transport and storage: Review of business models (Phase 1) · £20,000 · 19 Dec 2016
- Cavity Party Wall Insulation: Measuring U-values · £291,913 · 19 Dec 2016
- Additional Verification of the NAEI shipping model · £10,920 · 30 Nov 2016
- Heat Network Electricity Revenue Guidance · £50,000 · 22 Nov 2016
all contracts from this buyer →
similar contracts awarded
Other awarded contracts in the same category. Useful for seeing who normally wins this kind of work, and at what value.
- ACAS27482 - MH Good Practice tender · UK SHARED BUSINESS SERVICES LIMITED · £69,730
- PS26168 - Audit of internet services · UK SHARED BUSINESS SERVICES LIMITED · £200,000
- Provision of Value of a Life Year Research (VOLY): Lot 4 Peer Review · DfTc - Department for Transport · £74,008
- Award of Effective ventilation guidance and practice to mitigate the indoor airborne transmission... · Scottish Government · £9,826
- Evaluation of Growth Gateway and Manufacturing Africa · Foreign Commonwealth and Development Office · £449,112
- PR 07 2026 Consultation and Engagement Research · Exeter City Council · £175,200
- Annual Awareness Survey and Stakeholder Sentiment Survey · Care Quality Commission · £62,188
- Provision of Accelerating AI-Enablement at the GCA · GOVERNMENT COMMERCIAL AGENCY · £98,000
source
Published on Contracts Finder. Contact details for named individuals are not reproduced on this site.