---
title: "Update of Slurry Wizard Excel Tool"
ocid: "ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c"
canonical_url: "https://d3tenders.com/contract/?ocid=ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c"
markdown_url: "https://d3tenders.com/contract/ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c.md"
json_url: "https://d3tenders.com/contract/ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c.json"
source: "Contracts Finder"
current_stage: "Award"
buyer: "DEFRA"
published: "2023-04-25"
---

# Update of Slurry Wizard Excel Tool

Buyer: DEFRA  
Current stage: Award  
OCID: ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c

[View canonical contract page](https://d3tenders.com/contract/?ocid=ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c)  
[Download OCDS JSON](https://d3tenders.com/contract/ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c.json)

## Summary

The Department for Environment, Food & Rural Affairs (Defra) has awarded a contract for the update of the Slurry Wizard Excel Tool. This project falls under the Research and Development Consultancy Services category. The procurement method used was a selective call-off from a framework agreement. The contract period ran from March 1, 2023, to March 31, 2023. The tender process concluded on February 28, 2023. The awarded contract value was £12,688. The project aimed to enhance the tool by updating rainfall data, expanding functionality for pig farms, and addressing formula anomalies.

This tender awarded by Defra for the update of the Slurry Wizard Excel Tool presents opportunities for small and medium-sized enterprises and voluntary, community, and social enterprise organisations. Businesses in the research and development consultancy services sector specialised in agricultural technology may find this tender particularly relevant. By participating, businesses can contribute to improving agricultural compliance and efficiency, supporting sustainable farming practices. The contract allows for innovation in addressing slurry storage requirements and facilitating more accurate calculations for farmers.

## Notice

AHDB's Slurry Wizard is an Excel tool that enables farmers to work out their slurry storage requirements and explore different storage scenarios to comply with regulations. The main aim of the Slurry Wizard is to identify whether there is adequate slurry storage and to explore different strategies to meet compliance. The Slurry Wizard has four key components: * To calculate the existing slurry capacity. * To calculate the existing slurry production. * A report to look at the monthly production compared to existing storage. * To calculate the Nitrogen produced in organic manures per hectare. To inform the slurry production calculation the tool draws on monthly rainfall data embedded within the tool, based on the farm's location using the 'Telephone STD code'. The monthly rainfall data used is 20 years old. Although the tool allows for the contribution to slurry production from some aspects of the farming system, for example, parlour washings from dairying, there is no equivalent input field to account for wash water generated on a pig farm. There are some additional input fields required to improve the user experience when inputting farm specific details into the Wizard, for example, including slurry bags as a storage type option. The purpose of this project is to update Slurry Wizard to: 1. Scope out options for updating the old rainfall data with more recent and higher resolution rainfall data 2. Widen the scope of the tool to enable pig farms to account for pig wash water production (agreed calculation factors are detailed below) 3. Add input fields to the Slurry Data Entry tab 4. Add an additional pig production type category in Livestock Data Entry tab 5. Investigate and fix an anomaly in current formula execution 6. Reformat the livestock input tabs to split out pig, cattle (retaining the cumulative calculation across livestock types) 7. Remove unnecessary legacy coding sitting within the tool 8. Testing the tool

## Key Details

| Field | Value |
| --- | --- |
| Publication source | Contracts Finder |
| Latest notice | https://www.contractsfinder.service.gov.uk/Notice/5e74bbd7-7b17-4aa6-9ab9-733ca3597ebe |
| Notice type | Award Notice |
| Procurement type | Framework |
| Procurement category | Not specified |
| Procurement method | Selective |
| Procurement method details | Call-off from a framework agreement |
| Tender suitability | SME, VCSE |
| Awardee scale | Not specified |
| All stages | Award |

## Dates

| Field | Value |
| --- | --- |
| Publication date | 25 Apr 2023 |
| Submission deadline | 28 Feb 2023 |
| Future notice date | Not specified |
| Award date | 3 Mar 2023 |
| Contract period | 1 Mar 2023 - 31 Mar 2023 |
| Recurrence | Not specified |

## Values

| Field | Value |
| --- | --- |
| Tender value | £12,688 |
| Lots value | Not specified |
| Awards value | £12,688 |
| Contracts value | Not specified |

## Status

| Field | Value |
| --- | --- |
| Tender status | Complete |
| Lots status | Not specified |
| Awards status | Active |
| Contracts status | Not specified |

## Buyer

| Field | Value |
| --- | --- |
| Main buyer | DEFRA |
| Locality | BRISTOL |
| Post town | Bristol |
| Postcode | BS1 5AH |
| Country | England |
| ITL 1 | TLK South West (England) |
| ITL 2 | TLK5 West of England |
| ITL 3 | TLK51 Bristol, City of |
| Local authority | Bristol, City of |
| Electoral ward | Hotwells and Harbourside |
| Westminster constituency | Bristol Central |
| Delivery location | Not specified |

## Supplier

| Field | Value |
| --- | --- |
| Number of suppliers | 1 |
| Supplier names | RICARDO-AEA |

## CPV Codes

### Divisions

- 73 - Research and development services and related consultancy services

### Codes

- 73200000 - Research and development consultancy services

## Release History

- 25 Apr 2023 at 14:32 - Award - Award Notice - https://www.contractsfinder.service.gov.uk/Notice/5e74bbd7-7b17-4aa6-9ab9-733ca3597ebe
- 30 Mar 2023 at 08:00 - Award - Award Notice - https://www.contractsfinder.service.gov.uk/Notice/c8378881-20fe-4562-99ea-5ce47efdbef1
- 29 Mar 2023 at 13:16 - Award - Award Notice - https://www.contractsfinder.service.gov.uk/Notice/b3a52f4c-0dc4-4853-9f80-4e1a52b33738
- 29 Mar 2023 at 12:29 - Award - Award Notice - https://www.contractsfinder.service.gov.uk/Notice/027544dc-bd91-41cc-b479-47ea81152291

## Documents

- https://www.contractsfinder.service.gov.uk/Notice/5e74bbd7-7b17-4aa6-9ab9-733ca3597ebe
  25th April 2023 - Awarded contract notice on Contracts Finder
- https://www.contractsfinder.service.gov.uk/Notice/c8378881-20fe-4562-99ea-5ce47efdbef1
  30th March 2023 - Awarded contract notice on Contracts Finder
- https://www.contractsfinder.service.gov.uk/Notice/b3a52f4c-0dc4-4853-9f80-4e1a52b33738
  29th March 2023 - Awarded contract notice on Contracts Finder
- https://www.contractsfinder.service.gov.uk/Notice/027544dc-bd91-41cc-b479-47ea81152291
  29th March 2023 - Awarded contract notice on Contracts Finder

## Notice URLs

- https://www.gov.uk/government/organisations/department-for-environment-food-rural-affairs

## Provenance

This Markdown file is an alternate public rendering of the D3 Tenders contract record. The canonical page is https://d3tenders.com/contract/?ocid=ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c. The underlying structured data is available as OCDS JSON at https://d3tenders.com/contract/ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c.json.