OECD 106 Calculation tool V2

This spreadsheet has been designed to process the raw data generated from a study conducted according to OECD guideline 106. It should be used alongside the general recommendations the OECD 106 Evaluators checklist (doi.org/10.2903/sp.efsa.2017.EN-1326)
It is principally designed for use with data from studies conducted using the INDIRECT METHOD i.e. where concentrations in the supernatant only have been measured and concentrations in the soil are calculated by the difference. It can also be used for studies using the DIRECT METHOD, with the measured data for both phases inputted into the 'Raw data' sheet. In this case the user should not make use of interpretation in the 'Initial analysis' sheet, since this includes analysis only relevant for the INDIRECT METHOD. This version 2 has the additional functionality that it can handle studies with up to 3 replicates. Mistakes identified in some cell cross references in the first version have been corrected.