# Excel and VBA support in preparing the April 2021 template

> A sourced UK public-sector contract award published by Water Services Regulation Authority \(Ofwat\).

## Key facts

- Public buyer: [Water Services Regulation Authority \(Ofwat\)](/buyers/water-services-regulation-authority-ofwat/contract-awards)
- Contract winner: [Price Waterhouse Coopers Llp](/contract-winners/price-waterhouse-coopers/public-sector-contract-awards)
- Award value: £23,520
- Tender value: £23,520
- Award date: 10 March 2021
- Published: 15 November 2021
- Contract start: 11 March 2021
- Contract end: 31 March 2021
- Stage: awarded
- Procurement category: services
- Notice ID: 29d4e352-585e-4b29-8478-cf6fd7d23e66-485845
- OCID: ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5

## Description

The Supplier shall provide the following services to Ofwat: Excel and VBA support in the creation, and testing, of the Annual Performance Review \(APR\) 2021 Excel based data collection template\. This includes; 1\. Building data tables in Excel based on the data collection requirements of the APR 2021 process, these requirements will be defined by Ofwat; 2\. Populating data tables with the required formulas\. The formulas will be defined, and reviewed, by Ofwat; 3\. Where applicable, implementing data validation rules e\.g\. enforcing data types, or ensuring answers are consistent across data tables; 4\. Where applicable, protecting sheets and ranges to reduce the end user's ability to edit the format of the data tables\. Ofwat will be provided with any passwords used to protect the template; 5\. Creating a worksheet that pulls data from the underlying tables\. This worksheet, referred to as an F Output by Ofwat, is the mechanism used to push data into Ofwat's SQLDatabase 'Fountain'; 6\. Complete data upload test runs to ensure the F-output worksheet is compatible with Fountain Additional information: For further information, please contact procurement@ofwat\.gov\.uk

## Related contract awards

- [Ofwat Innovation Fund delivery partner 2025-30](/contracts/ocds-b5fd17-f5b314d0-3c71-4af5-8083-8484cbde4dbd): Water Services Regulation Authority \(Ofwat\)
- [Ofwat Innovation Fund delivery partner 2025-30](/contracts/ocds-b5fd17-89ef2b9b-452e-4076-8da0-c1b3d718a44d): Water Services Regulation Authority \(Ofwat\)
- [Delivery Partner for Price Review 2024](/contracts/ocds-b5fd17-ac353536-07a3-46e6-998c-cd4aa1eef82d): Water Services Regulation Authority \(Ofwat\)
- [Investigation Services](/contracts/ocds-b5fd17-8bb907c7-5c18-4fc4-a15f-c13c3f5ae5b9): COMPETITION AND MARKETS AUTHORITY
- [Innovation pilot 1](/contracts/ocds-b5fd17-ac6ae0f5-ec37-4f23-aa0c-6e59c73eb690): West Northamptonshire Council
- [Strategy & Policy Services](/contracts/ocds-b5fd17-01808905-502d-42d0-bc31-4b08b902d52b): COMMUNITY HEALTH PARTNERSHIPS LIMITED

## Source

[View the original notice on Contracts Finder](https://www.contractsfinder.service.gov.uk/Notice/29d4e352-585e-4b29-8478-cf6fd7d23e66-485845)