# Development of Spreadsheet Model QA Guidance and Training Material

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

## Key facts

- Public buyer: WATER SERVICES REGULATION AUTHORITY
- Contract winner: [Grant Thornton UK LLP](/contract-winners/grant-thornton-uk/public-sector-contract-awards)
- Award value: £38,218
- Award date: 23 February 2017
- Published: 27 March 2017
- Contract start: 28 February 2017
- Contract end: 31 March 2017
- Stage: awarded
- Procurement category: services
- Notice ID: 3c927bfc-fd2e-4dca-ac0c-96dd6c8279ca-136468
- OCID: ocds-b5fd17-364314f8-b453-465e-b7cc-501796721176

## Description

Ofwat has limited dedicated internal modelling resource, and this is currently mainly focussed on the development of the financial model for PR19\. The objective of this contract is therefore to use external support to develop detailed, Ofwat specific, guidance on model quality assurance\. The scope of the work is to develop: • QA approach - documentation describing an Ofwat-specific quality assurance approach that reflects best practice, including where relevant, guidance from the Aqua Book, IEEE 1028, academic research and industry\. • Scoring spreadsheet - an easy to use spreadsheet tool that can be used to quantitatively assess the quality of spreadsheet model\. Ofwat has a copy of a spreadsheet scoring system originally developed by DECC and has started to adapt this to our needs\. These will be shared with the successful bidder\. • Quality assurance training material - Ofwat plans to deliver some in-house training courses on quality assurance\. These are expected to be circa 3\.5 hours long\. Course material is required to that can be used to deliver these training courses\. It should be noted that the successful contractor will not be required to deliver any of the training courses - these will be delivered by Ofwat staff after the contract has finished\. The work needs to be delivered quickly so that training courses can be delivered in April to July 2017\.

## Related contract awards

- [Change Consultancy Servies](/contracts/ocds-b5fd17-4f49e249-93ca-420d-8391-fba6eb42454b): THE WATER SERVICES REGULATION AUTHORITY
- [SRN Technical Consultant](/contracts/ocds-b5fd17-9ed4fc69-ca38-465b-aef1-d7c283b21289): Water Services Regulation Authority
- [Developing the Security Operations Capability](/contracts/ocds-b5fd17-97557d50-6af3-4d7d-accb-45f4fd813f3c): Water Services Regulation Authority
- [Strategic Advice on Property Lease Hold](/contracts/ocds-b5fd17-53b7650d-d674-4c5a-9d4e-88a567067df5): Chelmsford City Council
- [Job Evaluation, Role Review Programme Consultancy Service](/contracts/ocds-b5fd17-a35f2219-79bc-4c45-9047-763999e969c2): Sheffield City Council
- [External Audit - a call-off from CPC awarded framework agreement for Audit and Financial Services CPC/RL/01/2024, Lot 17 - External Audit Yorkshire and The Humber](/contracts/ocds-b5fd17-4a18817c-dc68-4363-ae63-500f316e9f72): LEEDS TRINITY UNIVERSITY

## Source

[View the original notice on Contracts Finder](https://www.contractsfinder.service.gov.uk/Notice/3c927bfc-fd2e-4dca-ac0c-96dd6c8279ca-136468)