Environmental fate models: Excel calculator tools

When you are applying for registration of a pesticide in Great Britain or Northern Ireland, you must calculate predicted environmental concentrations (PECs) for each environmental compartment. There are several computer models available for applicants to use when calculating PECs. Further information on computer models is available on the relevant environmental compartment pages. 

This page lists the Excel calculator tools for calculating PECs for soil and surface water exposure.  All the Excel calculators calculate PEC values based on single or multiple applications. Similarly, links to the current versions of the FOCUS groundwater modelling tools currently used in GB and NI are also provided.

This page also includes information on a tool for correcting soil degradation rates for temperature or field moisture.

All calculators are Microsoft Excel files that need Microsoft Excel 2007 or later.

Each Excel file includes instructions on how to use the calculators.

Soil

Calculator/ tool Use Related pages
PECsoil calculator
Version 1.0 (October 2015)
Use this to calculate initial and time weighted average (TWA) PEC values for soil (PECsoil). The spreadsheet also calculates the accumulation of a substance in soil (PECsoil accumulation) Soil assessment for pesticide registration in Great Britain and Northern Ireland
Arrhenius and Walker converter
Version 1.0 (2014)
Use this to calculate degradation rates corrected for temperature or field moisture. The Arrhenius equations are used to convert degradation rates based on temperature and can convert based on Q10 values of 2.2 and 2.58. The Walker equation is used to correct for field moisture content. Soil assessment for pesticide registration in Great Britain and Northern Ireland

Surface water

Calculator/ tool Use Related pages
PECsw spray drift (multiple buffer zone) calculator
Version 1.0 (October 2015)
Use this to calculate initial PEC values for surface water (PECsw) due to contamination from spray drift for a range of spray buffer zones Spray drift surface water exposure assessments for pesticide registration in Great Britain and Northern Ireland
PECsw-sed spray drift calculator
Version 1.0 (October 2015)
Use this to calculate initial and TWA PECsw and sediment (PECsed) values due to contamination from spray drift Spray drift surface water exposure assessments for pesticide registration in Great Britain and Northern Ireland
PECsw spray drift (drift reduction) calculator
Version 1.0 (October 2015)
Use this to calculate PECsw values due to contamination from spray drift using the drift reduction technology (DRT) refinement. The spreadsheet calculates initial PECsw values for three spray buffer zones for field crops only Spray drift surface water exposure assessments for pesticide registration in Great Britain and Northern Ireland
PECsw-sed drainflow (tier 1) calculator
Version 1.0 (October 2015)
Use this to calculate first tier PECsw and PECsed values due to contamination from drainflow. The spreadsheet calculates initial PEC values based on applications during and outside of the UK drainflow period First tier drainflow calculation for pesticide registration in Great Britain and Northern Ireland
MACRO 4 PECsw drainflow (higher tier MACRO) tool
(.zip) Version 1.1 (April 2019)
Use this to calculate higher tier PECsw values due to contamination from drainflow. Works on a Windows 7 operating system. Do not use this spreadsheet for the first-tier assessment MACRO higher tier drainflow modelling for pesticides registration in Great Britain and Northern Ireland
MACRO 5 PECsw drainflow (higher tier MACRO) tool
(.zip) Version 2.1 (April 2023)
Use this to calculate higher tier PECsw values due to contamination from drainflow. Works on a Windows 10 operating system. Do not use this spreadsheet for the first-tier assessment MACRO higher tier drainflow modelling for pesticides registration in Great Britain and Northern Ireland
STP PEC calculator A simple Excel calculation tool to implement the equations from the ECHA guidance along with information on fate within the sewage treatment plants (STP) derived from the SimpleTreat model. Use this when considering post harvest treatments for PPPs Post-harvest treatments

Groundwater

The following table lists the current versions of the FOCUS groundwater modelling tools currently used in GB and NI.

Calculator/tool Use Related pages
FOCUS_PEARL_5.5.5 Use this to calculate 1st tier PECgw values Groundwater assessment for pesticide registration in GB and NI. Please also consult the FOCUS website for model installation instructions.
FOCUS_PELMO_6.6.4 Use this to calculate 1st tier PECgw values Groundwater assessment for pesticide registration in GB and NI. Please also consult the FOCUS website for model installation instructions.
FOCUS_MACRO_5.5.4 Use this to calculate 1st tier PECgw values Groundwater assessment for pesticide registration in GB and NI. Please also consult the FOCUS website for model installation instructions.
FOCUS_PRZM_4.6.2 Use this to calculate 1st tier PECgw values Groundwater assessment for pesticide registration in GB and NI. Please also consult the FOCUS website for model installation instructions.

Refer to the Groundwater assessment for pesticide registration in GB and NI page for more information on how these models should be used.

The current version of guidance for First Tier groundwater assessment in GB and NI is Generic Guidance for Tier 1 FOCUS GroundWater Assessments” Version 2.3

Is this page useful?

Updated 2024-02-07