Excel and VBA support in preparing the April 2021 template
The Water Services Regulation Authority · West Midlands
Key facts
- Contract value
- £23,520
- Awarded
- 10 Mar 2021
- Contract starts
- 11 Mar 2021
- Contract ends
- 31 Mar 2021
- Procedure
- Single tender action (below threshold)
- Buyer type
- Central government
Awarded to
| Supplier | Value |
|---|---|
| Price Waterhouse Coopers | £23,520 |
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 [email protected]
Categories (CPV)
- 79411000 General management consultancy services
Similar open tenders
Footways Maintenance Survey (Lot 3) (2027)
Location: South EastBuyer: West Sussex County Council
Open tenderCloses 10 Nov, 20265 daysValue £60.00kSource Find a TenderWest Sussex County Council are seeking to and identify suitably qualified and interested organisations to obtain road condition data for the highway network for footways and remote cycleways during 2027.
A, B & C Road Conditions Survey (Lot 2) (2027)
Location: South EastBuyer: West Sussex County Council
Open tenderCloses 10 Nov, 20265 daysValue £90.00kSource Find a TenderWest Sussex County Council are seeking to and identify suitably qualified and interested organisations for the provision of A, B and C road condition surveys during 2027.
Unclassified Road Conditions Survey (Lot 1) (2027)
Location: South EastBuyer: West Sussex County Council
Open tenderCloses 10 Nov, 20265 daysValue £75.00kSource Find a TenderWest Sussex County Council are seeking to and identify suitably qualified and interested organisations for the provision of Unclassified Road condition surveys during 2027.
Provision of Conversion Support Services for Student Recruitment for Glasgow Caledonian University
Location: ScotlandBuyer: Glasgow Caledonian University
Open tenderCloses 4 Dec, 202629 daysValue £800.00kSource Find a TenderThe University is seeking a Contractor for the Provision of a Conversion Partner who is equipped to provide a bespoke data driven, measurable series of conversion solutions through expertise in the HE sector.
ID 6592875 - DAERA - LMC - The provision of certification services to the Northern Ireland Beef and Lamb Farm Quality Assurance Scheme (NIBLFQAS)
Location: Northern IrelandBuyer: The Livestock and Meat Commission for Northern Ireland
Open tenderCloses 8 Dec, 202633 daysValue £10.84mSource Find a TenderThe Livestock and Meat Commission (LMC) requires the continued provision of certification services for the Northern Ireland Beef and Lamb Farm Quality Assurance Scheme (FQAS). FQAS plays a critical role in providing assurance regarding animal welfare, food safety and environmental standards and supports market access f
ENQ1406 - LED Screens, Staging, PA Equipment and Lighting Equipment for Derby LIVE Events
Location: East MidlandsBuyer: Derby City Council
Open tenderCloses 11 Nov, 20266 daysValue £95.00kSource Find a TenderThis quotation is for the supply, installation and de-rig of staging, LED screens, PA and Lighting equipment for Derby LIVE Events. **Please note this procurement has been reserved to suppliers with substantive business operations within the administrative boundary of Derby City Council. The Council is committed to sup