---
title: "Excel and VBA support in preparing the April 2021 template"
ocid: "ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5"
canonical_url: "https://d3tenders.com/contract/?ocid=ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5"
markdown_url: "https://d3tenders.com/contract/ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5.md"
json_url: "https://d3tenders.com/contract/ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5.json"
source: "Contracts Finder"
current_stage: "Award"
buyer: "WATER SERVICES REGULATION AUTHORITY (OFWAT)"
published: "2021-11-15"
---

# Excel and VBA support in preparing the April 2021 template

Buyer: WATER SERVICES REGULATION AUTHORITY (OFWAT)  
Current stage: Award  
OCID: ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5

[View canonical contract page](https://d3tenders.com/contract/?ocid=ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5)  
[Download OCDS JSON](https://d3tenders.com/contract/ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5.json)

## Summary

The Water Services Regulation Authority (Ofwat) has engaged in a procurement process titled "Excel and VBA support in preparing the April 2021 template." This contract, classified under general management consultancy services (CPV code: 79411000), is primarily located in the West Midlands and London, United Kingdom. The awarding process for this direct procurement method, executed through a single tender action below the threshold, is currently in the award stage. The contract value is £23,520 and is set to begin on 11 March 2021, concluding on 31 March 2021. The tender period ended on 26 February 2021.

This contract presents significant growth opportunities for small and medium-sized enterprises (SMEs) specialising in consultancy services, particularly those with expertise in Excel and VBA programming. Businesses that can provide technical support for data management processes and have experience in creating and testing Excel-based templates will be well-suited to compete for future contracts of a similar nature within the public sector.

## Notice

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

## Key Details

| Field | Value |
| --- | --- |
| Publication source | Contracts Finder |
| Latest notice | https://www.contractsfinder.service.gov.uk/Notice/29d4e352-585e-4b29-8478-cf6fd7d23e66 |
| Notice type | Award Notice |
| Procurement type | Standard |
| Procurement category | Services |
| Procurement method | Direct |
| Procurement method details | Single tender action (below threshold) |
| Tender suitability | SME |
| Awardee scale | SME |
| All stages | Award |

## Dates

| Field | Value |
| --- | --- |
| Publication date | 15 Nov 2021 |
| Submission deadline | 26 Feb 2021 |
| Future notice date | Not specified |
| Award date | 10 Mar 2021 |
| Contract period | 11 Mar 2021 - 31 Mar 2021 |
| Recurrence | Not specified |

## Values

| Field | Value |
| --- | --- |
| Tender value | £23,520 |
| Lots value | Not specified |
| Awards value | £23,520 |
| Contracts value | Not specified |

## Status

| Field | Value |
| --- | --- |
| Tender status | Complete |
| Lots status | Not specified |
| Awards status | Active |
| Contracts status | Not specified |

## Buyer

| Field | Value |
| --- | --- |
| Main buyer | WATER SERVICES REGULATION AUTHORITY (OFWAT) |
| Locality | BIRMINGHAM |
| Post town | Birmingham |
| Postcode | B5 4UA |
| Country | England |
| ITL 1 | TLG West Midlands (England) |
| ITL 2 | TLG3 West Midlands |
| ITL 3 | TLG31 Birmingham |
| Local authority | Birmingham |
| Electoral ward | Ladywood |
| Westminster constituency | Birmingham Ladywood |
| Delivery location | TLG West Midlands (England), TLI London |

## Supplier

| Field | Value |
| --- | --- |
| Number of suppliers | 1 |
| Supplier names | PRICE WATERHOUSE COOPERS |

## CPV Codes

### Divisions

- 79 - Business services: law, marketing, consulting, recruitment, printing and security

### Codes

- 79411000 - General management consultancy services

## Release History

- 15 Nov 2021 at 18:41 - Award - Award Notice - https://www.contractsfinder.service.gov.uk/Notice/29d4e352-585e-4b29-8478-cf6fd7d23e66

## Documents

- https://www.contractsfinder.service.gov.uk/Notice/29d4e352-585e-4b29-8478-cf6fd7d23e66
  15th November 2021 - Awarded contract notice on Contracts Finder

## Provenance

This Markdown file is an alternate public rendering of the D3 Tenders contract record. The canonical page is https://d3tenders.com/contract/?ocid=ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5. The underlying structured data is available as OCDS JSON at https://d3tenders.com/contract/ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5.json.