Help us to improve the website - give your feedback.

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
(.xlsx)
[1]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[2]
Arrhenius and Walker converter
(.xls)
[3]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[4]

Surface water

Calculator/ tool Use Related pages
PECsw spray drift (multiple buffer zone) calculator
(.xlsx)
[5]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[6]
PECsw-sed spray drift calculator
(.xlsx)
[7]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 [8]
PECsw spray drift (drift reduction) calculator
(.xlsx)
[9]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[10]
PECsw-sed drainflow (tier 1) calculator
(.xlsx)
[11]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[12]
MACRO 4 PECsw drainflow (higher tier MACRO) tool (.zip) [13]
(.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[14]
MACRO 5 PECsw drainflow (higher tier MACRO) tool (.zip) [15]
(.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[16]
STP PEC calculator (.xlsx) [17] 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[18]

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 (.zip) [19] Use this to calculate 1st tier PECgw values Groundwater assessment for pesticide registration in GB and NI[20]. Please also consult the FOCUS website[21] for model installation instructions.
FOCUS_PELMO_6.6.4 (.zip) [22] Use this to calculate 1st tier PECgw values Groundwater assessment for pesticide registration in GB and NI[23]. Please also consult the FOCUS website[24] for model installation instructions.
FOCUS_MACRO_5.5.4 (.zip) [25] Use this to calculate 1st tier PECgw values Groundwater assessment for pesticide registration in GB and NI[26]. Please also consult the FOCUS website[27] for model installation instructions.
FOCUS_PRZM_4.6.2[28] Use this to calculate 1st tier PECgw values Groundwater assessment for pesticide registration in GB and NI[29]. Please also consult the FOCUS website[30] for model installation instructions.

Refer to the Groundwater assessment for pesticide registration in GB and NI[31] 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 (PDF) [32]

Link URLs in this page

  1. PECsoil calculator https://www.hse.gov.uk/pesticides/assets/docs/PEC%20Soil.xlsx
  2. Soil assessment for pesticide registration in Great Britain and Northern Irelandhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/soil.htm
  3. Arrhenius and Walker converter https://www.hse.gov.uk/pesticides/assets/docs/arrhenius-and-walker-converter-2014.xls
  4. Soil assessment for pesticide registration in Great Britain and Northern Irelandhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/soil.htm
  5. PECsw spray drift (multiple buffer zone) calculator https://www.hse.gov.uk/pesticides/assets/docs/PEC%20sw%20Multiple%20Buffer%20Zones.xlsx
  6. Spray drift surface water exposure assessments for pesticide registration in Great Britain and Northern Irelandhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/uk-surface-water.htm
  7. PECsw-sed spray drift calculator https://www.hse.gov.uk/pesticides/assets/docs/PEC%20sw-sed%20(spraydrift).xlsx
  8. Spray drift surface water exposure assessments for pesticide registration in Great Britain and Northern Ireland https://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/uk-surface-water.htm
  9. PECsw spray drift (drift reduction) calculator https://www.hse.gov.uk/pesticides/assets/docs/PEC%20sw%20Drift%20Reduction.xlsx
  10. Spray drift surface water exposure assessments for pesticide registration in Great Britain and Northern Irelandhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/uk-surface-water.htm
  11. PECsw-sed drainflow (tier 1) calculator https://www.hse.gov.uk/pesticides/assets/docs/pec-sw-sed-drainage.xlsx
  12. First tier drainflow calculation for pesticide registration in Great Britain and Northern Irelandhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/pecsw-sed-via-drainflow.htm
  13. MACRO 4 PECsw drainflow (higher tier MACRO) toolhttps://www.hse.gov.uk/pesticides/assets/docs/macro-4-drainflow.zip
  14. MACRO higher tier drainflow modelling for pesticides registration in Great Britain and Northern Irelandhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/macro.htm
  15. MACRO 5 PECsw drainflow (higher tier MACRO) toolhttps://www.hse.gov.uk/pesticides/assets/docs/macro-5-drainflow.zip
  16. MACRO higher tier drainflow modelling for pesticides registration in Great Britain and Northern Irelandhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/macro.htm
  17. STP PEC calculatorhttps://www.hse.gov.uk/pesticides/assets/docs/stp-pec-calculator.xlsx
  18. Post-harvest treatmentshttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/post-harvest-treatments.htm
  19. FOCUS_PEARL_5.5.5https://esdac.jrc.ec.europa.eu/public_path/projects_data/focus/gw/models/pearl/FOCUSPEARL_5.5.5_September2021.zip
  20. Groundwater assessment for pesticide registration in GB and NIhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/groundwater.htm
  21. websitehttps://esdac.jrc.ec.europa.eu/projects/pearl
  22. FOCUS_PELMO_6.6.4https://esdac.jrc.ec.europa.eu/public_path/projects_data/focus/gw/models/pelmo/FOCUSPELMO_6.6.4_September2021.zip
  23. Groundwater assessment for pesticide registration in GB and NIhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/groundwater.htm
  24. websitehttps://esdac.jrc.ec.europa.eu/projects/pelmo
  25. FOCUS_MACRO_5.5.4https://esdac.jrc.ec.europa.eu/public_path/projects_data/focus/sw/models/macro/Setup%20MACROinFOCUS_5_5_4.zip
  26. Groundwater assessment for pesticide registration in GB and NIhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/groundwater.htm
  27. websitehttps://esdac.jrc.ec.europa.eu/projects/macro
  28. FOCUS_PRZM_4.6.2https://esdac.jrc.ec.europa.eu/public_path/projects_data/focus/gw/models/przm/Latest/FOCUS_PRZM_4.6.2.exe
  29. Groundwater assessment for pesticide registration in GB and NIhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/groundwater.htm
  30. websitehttps://esdac.jrc.ec.europa.eu/projects/przmgw
  31. Groundwater assessment for pesticide registration in GB and NIhttps://www.hse.gov.uk/pesticides/data-requirements-handbook/fate/groundwater.htm
  32. Generic Guidance for Tier 1 FOCUS GroundWater Assessments” Version 2.3https://esdac.jrc.ec.europa.eu/public_path/projects_data/focus/gw/docs/Generic_guidance_FOCUS_GW_V2-3final.pdf
  33. Codes of Practicehttps://www.hse.gov.uk/pesticides/using-pesticides/codes-of-practice/index.htm
  34. Pesticide/Plant Protection Product Databaseshttps://www.hse.gov.uk/pesticides/databases/index.htm
  35. Application formshttps://www.hse.gov.uk/pesticides/applicant-guide/what-to-include-in-an-application.htm#application-form

Is this page useful?

Updated 2025-01-08