Notice Information
Notice Title
Update of Slurry Wizard Excel Tool
Notice Description
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
Notice Details
Publication & Lifecycle
- Open Contracting ID
- ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c
- Publication Source
- Contracts Finder
- Latest Notice
- https://www.contractsfinder.service.gov.uk/Notice/5e74bbd7-7b17-4aa6-9ab9-733ca3597ebe
- Current Stage
- Award
- All Stages
- Award
Procurement Classification
- 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
Common Procurement Vocabulary (CPV)
- CPV Divisions
73 - Research and development services and related consultancy services
-
- CPV Codes
73200000 - Research and development consultancy services
Notice Value(s)
- Tender Value
- £12,688 Under £100K
- Lots Value
- Not specified
- Awards Value
- £12,688 Under £100K
- Contracts Value
- Not specified
Notice Dates
- Publication Date
- 25 Apr 20232 years ago
- Submission Deadline
- 28 Feb 2023Expired
- Future Notice Date
- Not specified
- Award Date
- 3 Mar 20232 years ago
- Contract Period
- 1 Mar 2023 - 31 Mar 2023 30 days
- Recurrence
- Not specified
Notice Status
- Tender Status
- Complete
- Lots Status
- Not Specified
- Awards Status
- Active
- Contracts Status
- Not Specified
Buyer & Supplier
Contracting Authority (Buyer)
- Main Buyer
- DEFRA
- Contact Name
- Defra Commercial, Felicity Jowett
- Contact Email
- felicity.jowett@defra.gov.uk, procurement@defra.gov.uk
- Contact Phone
- Not specified
Buyer Location
- Locality
- BRISTOL
- Postcode
- BS1 5AH
- Post Town
- Bristol
- Country
- England
-
- Major Region (ITL 1)
- TLK South West (England)
- Basic Region (ITL 2)
- TLK5 West of England
- Small Region (ITL 3)
- TLK51 Bristol, City of
- Delivery Location
- Not specified
-
- Local Authority
- Bristol, City of
- Electoral Ward
- Hotwells and Harbourside
- Westminster Constituency
- Bristol Central
Further Information
Notice 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
Open Contracting Data Standard (OCDS)
View full OCDS Record for this contracting process
The Open Contracting Data Standard (OCDS) is a framework designed to increase transparency and access to public procurement data in the public sector. It is widely used by governments and organisations worldwide to report on procurement processes and contracts.
{
"tag": [
"compiled"
],
"id": "ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c-2023-04-25T15:32:51+01:00",
"date": "2023-04-25T15:32:51+01:00",
"ocid": "ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c",
"language": "en",
"initiationType": "tender",
"tender": {
"id": "CF-0057000D8d000003VQwdEAG",
"title": "Update of Slurry Wizard Excel Tool",
"description": "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",
"status": "complete",
"classification": {
"scheme": "CPV",
"id": "73200000",
"description": "Research and development consultancy services"
},
"items": [
{
"id": "1",
"deliveryAddresses": [
{
"postalCode": "SW1P 3JR"
},
{
"countryName": "British Oversea Territories"
},
{
"countryName": "Channel Islands"
},
{
"countryName": "Europe"
},
{
"countryName": "Isle of Man"
},
{
"countryName": "Rest of the World"
},
{
"countryName": "United Kingdom"
},
{
"postalCode": "SW1P 3JR"
},
{
"countryName": "British Oversea Territories"
},
{
"countryName": "Channel Islands"
},
{
"countryName": "Europe"
},
{
"countryName": "Isle of Man"
},
{
"countryName": "Rest of the World"
},
{
"countryName": "United Kingdom"
},
{
"postalCode": "SW1P 3JR"
},
{
"countryName": "British Oversea Territories"
},
{
"countryName": "Channel Islands"
},
{
"countryName": "Europe"
},
{
"countryName": "Isle of Man"
},
{
"countryName": "Rest of the World"
},
{
"countryName": "United Kingdom"
},
{
"postalCode": "SW1P 3JR"
},
{
"countryName": "British Oversea Territories"
},
{
"countryName": "Channel Islands"
},
{
"countryName": "Europe"
},
{
"countryName": "Isle of Man"
},
{
"countryName": "Rest of the World"
},
{
"countryName": "United Kingdom"
}
]
}
],
"value": {
"amount": 12688,
"currency": "GBP"
},
"procurementMethod": "selective",
"procurementMethodDetails": "Call-off from a framework agreement",
"tenderPeriod": {
"endDate": "2023-02-28T23:59:00Z"
},
"contractPeriod": {
"startDate": "2023-03-01T00:00:00Z",
"endDate": "2023-03-31T23:59:59+01:00"
},
"suitability": {
"sme": true,
"vcse": true
}
},
"parties": [
{
"id": "GB-CFS-240413",
"name": "Defra",
"identifier": {
"legalName": "Defra"
},
"address": {
"streetAddress": "https://www.gov.uk/government/organisations/department-for-environment-food-rural-affairs",
"locality": "Bristol",
"postalCode": "BS1 5AH",
"countryName": "UK"
},
"contactPoint": {
"name": "Felicity Jowett",
"email": "felicity.jowett@defra.gov.uk"
},
"roles": [
"buyer"
]
},
{
"id": "GB-CFS-240439",
"name": "Ricardo-AEA Ltd",
"identifier": {
"legalName": "Ricardo-AEA Ltd"
},
"address": {
"streetAddress": "The Gemini Building, Harwell, Oxfordshire OX11 0QR"
},
"roles": [
"supplier"
]
},
{
"id": "GB-CFS-240559",
"name": "Defra",
"identifier": {
"legalName": "Defra"
},
"address": {
"streetAddress": "Horizon House Deanery Road",
"locality": "Bristol",
"postalCode": "BS1 5AH",
"countryName": "UK"
},
"contactPoint": {
"name": "Defra Commercial",
"email": "procurement@defra.gov.uk"
},
"roles": [
"buyer"
]
}
],
"buyer": {
"id": "GB-CFS-240559",
"name": "Defra"
},
"awards": [
{
"id": "ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c-1",
"status": "active",
"date": "2023-03-03T00:00:00Z",
"datePublished": "2023-03-29T13:29:04+01:00",
"value": {
"amount": 12688,
"currency": "GBP"
},
"suppliers": [
{
"id": "GB-CFS-240439",
"name": "Ricardo-AEA Ltd"
}
],
"contractPeriod": {
"startDate": "2023-03-01T00:00:00Z",
"endDate": "2023-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/027544dc-bd91-41cc-b479-47ea81152291",
"datePublished": "2023-03-29T13:29:04+01:00",
"format": "text/html",
"language": "en"
}
]
},
{
"id": "ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c-2",
"status": "active",
"date": "2023-03-03T00:00:00Z",
"datePublished": "2023-03-29T14:16:26+01:00",
"value": {
"amount": 12688,
"currency": "GBP"
},
"suppliers": [
{
"id": "GB-CFS-240439",
"name": "Ricardo-AEA Ltd"
}
],
"contractPeriod": {
"startDate": "2023-03-01T00:00:00Z",
"endDate": "2023-03-31T23:59:59+01:00"
},
"documents": [
{
"id": "2",
"documentType": "awardNotice",
"description": "Awarded contract notice on Contracts Finder",
"url": "https://www.contractsfinder.service.gov.uk/Notice/b3a52f4c-0dc4-4853-9f80-4e1a52b33738",
"datePublished": "2023-03-29T14:16:26+01:00",
"format": "text/html",
"language": "en"
}
]
},
{
"id": "ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c-3",
"status": "active",
"date": "2023-03-03T00:00:00Z",
"datePublished": "2023-03-30T09:00:28+01:00",
"value": {
"amount": 12688,
"currency": "GBP"
},
"suppliers": [
{
"id": "GB-CFS-240439",
"name": "Ricardo-AEA Ltd"
}
],
"contractPeriod": {
"startDate": "2023-03-01T00:00:00Z",
"endDate": "2023-03-31T23:59:59+01:00"
},
"documents": [
{
"id": "3",
"documentType": "awardNotice",
"description": "Awarded contract notice on Contracts Finder",
"url": "https://www.contractsfinder.service.gov.uk/Notice/c8378881-20fe-4562-99ea-5ce47efdbef1",
"datePublished": "2023-03-30T09:00:28+01:00",
"format": "text/html",
"language": "en"
}
]
},
{
"id": "ocds-b5fd17-e44304bc-633d-4be1-8525-c39fe8b6078c-4",
"status": "active",
"date": "2023-03-03T00:00:00Z",
"datePublished": "2023-04-25T15:32:51+01:00",
"value": {
"amount": 12688,
"currency": "GBP"
},
"suppliers": [
{
"id": "GB-CFS-240439",
"name": "Ricardo-AEA Ltd"
}
],
"contractPeriod": {
"startDate": "2023-03-01T00:00:00Z",
"endDate": "2023-03-31T23:59:59+01:00"
},
"documents": [
{
"id": "4",
"documentType": "awardNotice",
"description": "Awarded contract notice on Contracts Finder",
"url": "https://www.contractsfinder.service.gov.uk/Notice/5e74bbd7-7b17-4aa6-9ab9-733ca3597ebe",
"datePublished": "2023-04-25T15:32:51+01:00",
"format": "text/html",
"language": "en"
}
]
}
]
}