Award

Excel and VBA support in preparing the April 2021 template

WATER SERVICES REGULATION AUTHORITY (OFWAT)

This public procurement record has 1 release in its history.

Award

15 Nov 2021 at 18:41

Award Notice
Summary of the contracting process

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.

Find more tenders on our Open Data Platform.
How relevant is this notice?

D3 Tenders Premium

Win More Public Sector Contracts

AI-powered tender discovery, pipeline management, and market intelligence — everything you need to grow your public sector business.

Start Free Trial Book a Demo
All Features Pricing

Notice Information

Notice Title

Excel and VBA support in preparing the April 2021 template

Notice 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

Notice Details

Publication & Lifecycle

Open Contracting ID
ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5
Publication Source
Contracts Finder
Latest Notice
https://www.contractsfinder.service.gov.uk/Notice/29d4e352-585e-4b29-8478-cf6fd7d23e66
Current Stage
Award
All Stages
Award

Procurement Classification

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

Common Procurement Vocabulary (CPV)

CPV Divisions

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

CPV Codes

79411000 - General management consultancy services

Notice Value(s)

Tender Value
£23,520 Under £100K
Lots Value
Not specified
Awards Value
£23,520 Under £100K
Contracts Value
Not specified

Notice Dates

Publication Date
15 Nov 20214 years ago
Submission Deadline
26 Feb 2021Expired
Future Notice Date
Not specified
Award Date
10 Mar 20214 years ago
Contract Period
11 Mar 2021 - 31 Mar 2021 30 days
Recurrence
Not specified

Notice Status

Tender Status
Complete
Lots Status
Not Specified
Awards Status
Active
Contracts Status
Not Specified

Buyer & Supplier

Contracting Authority (Buyer)

Main Buyer
WATER SERVICES REGULATION AUTHORITY (OFWAT)
Contact Name
Available with D3 Tenders Premium →
Contact Email
Available with D3 Tenders Premium →
Contact Phone
Available with D3 Tenders Premium →

Buyer Location

Locality
BIRMINGHAM
Postcode
B5 4UA
Post Town
Birmingham
Country
England
Major Region (ITL 1)
TLG West Midlands (England)
Basic Region (ITL 2)
TLG3 West Midlands
Small Region (ITL 3)
TLG31 Birmingham
Delivery Location
TLG West Midlands (England), TLI London
Local Authority
Birmingham
Electoral Ward
Ladywood
Westminster Constituency
Birmingham Ladywood

Supplier Information

Number of Suppliers
1
Supplier Name

PRICE WATERHOUSE COOPERS

Further Information

Notice Documents

Open Contracting Data Standard (OCDS)

View full OCDS Record for this contracting process

Download

The Open Contracting Data Standard (OCDS) is a framework designed to increase transparency and access to public procurement data in the public sector. It is widely used by governments and organisations worldwide to report on procurement processes and contracts. 

{
    "tag": [
        "compiled"
    ],
    "id": "ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5-2021-11-15T18:41:19Z",
    "date": "2021-11-15T18:41:19Z",
    "ocid": "ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5",
    "language": "en",
    "initiationType": "tender",
    "tender": {
        "id": "PROC.01.0683",
        "title": "Excel and VBA support in preparing the April 2021 template",
        "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",
        "status": "complete",
        "classification": {
            "scheme": "CPV",
            "id": "79411000",
            "description": "General management consultancy services"
        },
        "items": [
            {
                "id": "1",
                "deliveryAddresses": [
                    {
                        "region": "West Midlands",
                        "countryName": "United Kingdom"
                    },
                    {
                        "region": "London",
                        "countryName": "United Kingdom"
                    }
                ]
            }
        ],
        "value": {
            "amount": 23520,
            "currency": "GBP"
        },
        "procurementMethod": "direct",
        "procurementMethodDetails": "Single tender action (below threshold)",
        "tenderPeriod": {
            "endDate": "2021-02-26T17:00:00Z"
        },
        "contractPeriod": {
            "startDate": "2021-03-11T00:00:00Z",
            "endDate": "2021-03-31T23:59:59+01:00"
        },
        "suitability": {
            "sme": true,
            "vcse": false
        },
        "mainProcurementCategory": "services"
    },
    "parties": [
        {
            "id": "GB-SRS-supplierregistration.cabinetoffice.gov.uk/Entf38w5",
            "name": "Water Services Regulation Authority (Ofwat)",
            "identifier": {
                "legalName": "Water Services Regulation Authority (Ofwat)",
                "scheme": "GB-SRS",
                "id": "supplierregistration.cabinetoffice.gov.uk/Entf38w5"
            },
            "address": {
                "streetAddress": "Birmingham",
                "locality": "Birmingham",
                "postalCode": "B54UA",
                "countryName": "England"
            },
            "contactPoint": {
                "email": "mailbox@ofwat.gov.uk"
            },
            "roles": [
                "buyer"
            ]
        },
        {
            "id": "GB-COH-OC309347",
            "name": "Price Waterhouse Coopers Llp",
            "identifier": {
                "legalName": "Price Waterhouse Coopers Llp",
                "scheme": "GB-COH",
                "id": "OC309347"
            },
            "address": {
                "streetAddress": "1 Embankment Place WC2N 6RH GB"
            },
            "details": {
                "scale": "sme",
                "vcse": false
            },
            "roles": [
                "supplier"
            ]
        }
    ],
    "buyer": {
        "id": "GB-SRS-supplierregistration.cabinetoffice.gov.uk/Entf38w5",
        "name": "Water Services Regulation Authority (Ofwat)"
    },
    "awards": [
        {
            "id": "ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5-1",
            "status": "active",
            "date": "2021-03-10T00:00:00Z",
            "datePublished": "2021-11-15T18:41:19Z",
            "value": {
                "amount": 23520,
                "currency": "GBP"
            },
            "suppliers": [
                {
                    "id": "GB-COH-OC309347",
                    "name": "Price Waterhouse Coopers Llp"
                }
            ],
            "contractPeriod": {
                "startDate": "2021-03-11T00:00:00Z",
                "endDate": "2021-03-31T23:59:59+01:00"
            },
            "documents": [
                {
                    "id": "1",
                    "documentType": "awardNotice",
                    "description": "Awarded contract notice on Contracts Finder",
                    "url": "https://www.contractsfinder.service.gov.uk/Notice/29d4e352-585e-4b29-8478-cf6fd7d23e66",
                    "datePublished": "2021-11-15T18:41:19Z",
                    "format": "text/html",
                    "language": "en"
                }
            ]
        }
    ]
}