Excel and VBA support in preparing the April 2021 template
key details
| Value | £23,520 |
|---|---|
| Status | complete |
| Category (CPV) | 79411000 |
| Region | West Midlands, London |
| Deadline | 26 Feb 2021 |
| Contract start | 11 Mar 2021 |
| Contract end | 31 Mar 2021 |
| Procedure | direct |
| SME suitable | Yes |
| OCID | ocds-b5fd17-14774160-a4ea-4760-9fa6-f545befa84c5 |
Awards (2)
This procurement was awarded to 2 suppliers. Values shown are per-award; the notice total is £23,520.
| Supplier | Value | Date | Status |
|---|---|---|---|
| PricewaterhouseCoopers LLP | £19,600 | 10 Mar 2021 | active |
| Price Waterhouse Coopers Llp | £23,520 | 10 Mar 2021 | active |
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;
- Building data tables in Excel based on the data collection requirements of the APR 2021 process, these requirements will be defined by Ofwat;
- Populating data tables with the required formulas. The formulas will be defined, and reviewed, by Ofwat;
- Where applicable, implementing data validation rules e.g. enforcing data types, or ensuring answers are consistent across data tables;
- 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;
- 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';
- 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 history
2 notices published against this procurement.
| Published | Type | Regime | Notice |
|---|---|---|---|
| 15 Nov 2021 | Award (award) | · | 29d4e352-585e-4b29-8478-cf6fd7d23e66-485845 |
| 14 Mar 2022 | Award (award) | · | fb3cf253-1e9a-4b35-90fd-424ea55c491f-518180 |
more from Water Services Regulation Authority (Ofwat)
- Interim Learning and Organisation Development Partner · £60,960 · 17 Dec 2021
- Interim Head of HR Transformation & Operations · £1,366,045 · 17 Dec 2021
- Interim Finance Business Analyst · £89,073 · 17 Dec 2021
- Impact Evaluation · £73,000 · 17 Dec 2021
- Interim Principal Economist · £83,168 · 22 Nov 2021
- 2 x Interim Principal Economists · £52,000 · 18 Nov 2021
- Delivery Partner Support for in-period Outcome Delivery Incentive Assessments (ODIs) · £1,560,000 · 18 Nov 2021
- Regional co-ordination · £53,410 · 18 Nov 2021
all contracts from this buyer →
similar contracts awarded
Other awarded contracts in the same category. Useful for seeing who normally wins this kind of work, and at what value.
- nterim Strategic Leadership Support for Housing Quality and Investment Services · London Borough of Lewisham
- Security review and crisis response plan · DEFRA · £83,112
- Executive Leadership and Development Support · NHS E · £240,000
- Business Development Partner for Youth Justice Service · Liverpool City Council · £70,000
- BHNFT - Consultancy and Advisory Services for Health Framework · Barnsley Hospital NHS Foundation Trust · £126,960
- Aggregate Working Parties Secretariat · Ministry of Housing, Communities and Local Government (MCHLG) · £606,664
- Attain Consultancy · Central London Community Healthcare NHS Trust · £228,850
- Ports Readiness Fund - Continued Support (Phase 2) · DEFRA · £348,553
source
Published on Contracts Finder. Contact details for named individuals are not reproduced on this site.