Basic tools for deriving photolysis endpoints for soil photo-transformation products in groundwater

This spreadsheet has been designed to determine input parameters for consideration of the photolysis pathway in FOCUS-PELMO 5.5.3 and subsequent versions. It should be used alongside the EFSA scientific guidance on “Soil phototransformation products in groundwater – consideration, parameterisation and simulation in the exposure assessment of plant protection products”.

The tools in the spreadsheet allow to identify the relevant grid points in the solar database 'AGRI4CAST', to retrieve irradiance values for the relevant grid points and for the period of the study from the 'AGRI4CAST' database via a spatial interpolation of the irradiance values (this can also be used for other solar databases besides 'AGRI4CAST'). Furthermore, the tools enable to convert the irradiance from kWh/m², kJ/m² or J/cm² into W/m², to perform a time-step normalisation for field studies, and to compare the normalised kfast values from different field studies.