Source: https://tendernation.io/opportunities/01a13c66-f28d-72a4-bc32-efc7fdcee4d9/excel-and-vba-support-in-preparing-the-april-2021-template awarded GB direct award procedure Suitable for SMEs # Excel and VBA support in preparing the April 2021 template [Water Services Regulation Authority (Ofwat)](https://tendernation.io/buyers/water-services-regulation-authority-ofwat) Estimated value £23,520 Published 15 Nov 2021 Deadline Closed 26 Feb 2021 ## Who can bid - Buyer says suitable for SMEs The buyer ticked “suitable for SMEs” on the notice. Anyone can still bid. - Small contract value Valued under £135,018 including VAT, the lowest Procurement Act threshold for goods and services. [More contracts for small businesses and VCSEs](https://tendernation.io/opportunities/for-small-businesses) ## About this tender 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 ## CPV classification General management consultancy services Source Contracts Finder (UK) [View official notice](https://www.contractsfinder.service.gov.uk/notice/14774160-a4ea-4760-9fa6-f545befa84c5) Never miss a tender like this again Get AI summaries, deadline alerts and a bid pipeline for tenders matched to your business. Free to start. [Track tenders free](https://tendernation.io/register) [Buyer profile Water Services Regulation Authority (Ofwat): past awards and live tenders](https://tendernation.io/buyers/water-services-regulation-authority-ofwat) [Sector More Business services tenders](https://tendernation.io/sectors/business-services) ## More tenders like this [Social Housing Emerging Disrupters 6 · Procurement for Housing · 29 days left · 17 Nov 2026](https://tendernation.io/opportunities/01a154e4-4909-7303-a67f-9c3bff3eb4d8/social-housing-emerging-disrupters-6) [Business travel services – Rahmenvertrag Bearbeitung von Reisekostenabrechnungen nach BRKG · GSI Helmholtzzentrum für Schwerionenforschung GmbH · 29 days left · 17 Nov 2026](https://tendernation.io/opportunities/01a15183-cd6e-73e4-b6e8-3954e5689021/germany-business-travel-services-rahmenvertrag-bearbeitung-von-reisekostenab) [Photocopying services – Externe printdiensten · VZW Sint-Paulusschool · 36 days left · 24 Nov 2026](https://tendernation.io/opportunities/01a15183-34d8-71be-840d-38bf2a8bcc92/belgium-photocopying-services-externe-printdiensten) [Supply services of personnel including temporary staff – Diák- és nyugdíjas munkaerő biztosítása NTH (376) · NTH Nemzeti Tőkeholding Zrt. · 11 days left · 30 Oct 2026](https://tendernation.io/opportunities/01a15183-76f6-70c4-823e-7b614dada7b3/hungary-supply-services-of-personnel-including-temporary-staff-diak-es-nyug) [Interpretation services – Tolktjänster · Stockholms läns sjukvårdsområde · 31 days left · 18 Nov 2026](https://tendernation.io/opportunities/01a15183-4e9a-70dc-8b27-e3d274e53dc5/sweden-interpretation-services-tolktjanster) [Printing and distribution services – SGCD53\_MARCHE\_ELECTIONS\_BRGE · Préfecture de la Mayenne · 28 days left · 16 Nov 2026](https://tendernation.io/opportunities/01a15183-7726-73f4-bb67-b3121363d6bf/france-printing-and-distribution-services-sgcd53-marche-elections-brge)