{
    "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"
                }
            ]
        }
    ]
}