Sandy V5.0 – Perennials Template Update
We’ve introduced a major update to the Perennial Cropping template in Sandy V5.0 — making it easier to input the right data, follow required formats, and ensure carbon calculations are consistent across enterprises. This update introduces new tabs, streamlined column structures, and clearer guidance across the board.
As part of our ongoing improvements to Sandy, we’ve released a comprehensive update to the Perennial Cropping template designed to better reflect the diversity and complexity of perennial systems.
This update aligns with the latest science, enhances data structure for carbon accounting, and improves usability for farmers and advisors alike.
The breakdown below outlines all the key changes to tab names, data fields, and input expectations.
🔁 Renamed Tabs and New Structure
To support improved data alignment, we’ve renamed several tabs and introduced a new one:
-
Cropping Data → Perennial Data
-
Cropping Details → Prunning Data
-
Soil → Soil Testing
-
New tab added: Natural Capital Features
-
Biodiversity column removed from the Sandy Guide tab (under "Required tabs for each service")
📋 Updated Tab Order (for Perennials workflows):
-
Farm Setup – Required for Carbon
-
Enterprises – Required for Carbon
-
Field Setup – Required for Carbon
-
Perennial Data – Required for Carbon
-
Prunning Data – Required for Carbon
-
Residues Management – Encouraged for Carbon
-
Operational Data – Required for Carbon
-
Manufactured Fertiliser Details – Required for Carbon
-
Organic Fertiliser Details – Required for Carbon
-
Crop Protection Details – Required for Carbon
-
Soil Testing – Encouraged for Carbon
-
Fuel Machinery – Encouraged for Carbon
-
Fuel Dry and Storage – Optional for Carbon
-
Natural Capital Features – Encouraged for Carbon
🧭 Sandy Guide Enhancements
-
Expanded explanations in the "Tabs and Column Colours" table to clarify:
-
Which data is required, encouraged, or optional
-
Which columns are used as keys (crucial for data identification)
-
🧱 Tab-by-Tab Column Changes
1. Farm Setup (formerly Farms)
-
Renamed tab: Farm Setup
-
'Farm' column renamed to Farm name
-
Columns updated:
-
Post Code,Country,Latitude,Longitude: changed from Key to Required
-
2. Enterprises
-
Renamed tab: Enterprises
-
'Farm' column renamed to Farm name
-
All columns removed except: Is Perennials
3. Field Setup (formerly Fields)
-
Renamed tab: Field Setup
-
'Farm' column renamed to Farm name
-
Removed columns:
-
"Is this an Organic field?"
-
"Action"
-
-
New column added: Management Type (selectable: Conventional, Organic)
-
Renamed column: Primary Land Use → Primary Land Use Category
-
New column order:
-
Farm name
-
Field name
-
Field size (ha)
-
Soil Type
-
Management Type
-
Primary Land Use Category
-
4. Perennial Data
Key columns:
-
Farm name, Field name, Year, Crop name, Crop variety, Year planted
New or updated fields:
-
Required: Age of tree at year one, Working area (ha)
-
Encouraged: Number of trees per ha
-
Optional: Land preparation, Production cycle duration, Inter-row management, Tree mortality rate (%), Percentage discarded
5. Yield & Prunning Data
Key columns: Farm name, Field name, Year, Crop name, Crop variety, Year planted
Required: Yield harvested, Yield unit
Encouraged:
-
Pruning start year
-
Pruning amount (t/ha)
-
Pruning amount (% of woody biomass)
6. Residues Management
Key columns: Farm name, Field name, Year, Crop name, Crop variety, Year planted
Encouraged:
-
Residue type
-
Residue management method
-
Percentage managed (%)
7. Operational Data
Key columns: As above, plus Operation Group, Operation Type, Product Name
Required:
-
Quantity
-
Unit
-
Applied area (ha)
8. Manufactured Fertiliser Details
Key column: Product name
Required:
-
Form of fertiliser
-
N (%)
-
Density (kg/L)
Encouraged: -
Dry Matter (kg/t)
-
P₂O₅ (%), K₂O (%), SO₃ (%)
-
Controlled Release
-
Nitrification inhibitor
-
Incorporated in soil
9. Organic Fertiliser Details
Key column: Product name
Required:
-
Manure type
-
Total nitrogen (kg/t)
-
Density (kg/L)
Encouraged: -
Dry matter (kg/L)
-
Organic matter (kg/t)
-
Mineral nitrogen (kg/t)
-
P₂O₅ (%), K₂O (%), SO₃ (%)
10. Crop Protection Details
-
The ‘Action’ column has been removed
11. Soil Testing
Key columns: Farm name, Field name, Year
Encouraged:
-
Soil Organic Carbon (%)
-
Soil Organic Matter (%)
-
Bulk density (g/cm³)
12. Fuel Machinery
Key columns: Farm name, Field name, Year
Encouraged:
-
Usage details
-
Fuel type
-
Fuel amount
-
Unit
13. Fuel Dry and Storage
Key columns: Farm name, Crop type, Year
Required:
-
Dry on farm?
-
Fuel type (drying), amount, unit
-
Stored on farm?
-
Fuel type (refrigeration), amount, unit
14. Natural Capital Features (🆕)
Key columns: Farm name, Field name, Year
Required: Width (m)
Encouraged:
-
Primary land use
-
Land use type
-
Land use name
-
Area (ha), Length (m), Number of trees
If you're a user working with perennial systems, these changes are designed to make your Sandy experience smoother, more aligned with on-farm realities, and ready for robust carbon reporting.
📌 Tip: You can always refer to the updated Sandy Guide tab for colour coding and guidance on which columns are required or optional.
If you have questions or need support, don’t hesitate to reach out to our team via the in-platform chat or contact your Customer Success representative.