Tool Input_Decision for selecting the entry parameters for calculations with the FOCUS-PELMO model
The Input_Decision tool was developed for selecting the entry parameters for calculations with the FOCUS-PELMO model and complements the "Recommendations for simulations to predict PECgw". Input_Decision 3.3 can be retrieved as an Excel file with macros from the right-hand column.
General information on the program Input_Decision 3.3
- In contrast to previous versions this tool in version 3.3 no longer requires RExcel which is subject to licence for commercial purposes. Therefore the respecting installation procedures are dropped.
- Regarding the execution of the Kendall-Test the R-Code has been translated into 'visual basic' (VBA).
- The program runs on Excel 2007 and higher without requiring special installation measures.
- Comparative calculations between the previous version 3.2 (invoking RExcel) and the current version 3.3 (invoking VBA) on realistic and synthetic pH- and Kf-relevant values of 35 substances / metabolites revealed no differences. The individual data sets comprised 3 to 28 values.
- Additionally the limit of the number of input values has been increased from 10 to 30.
- After starting the program and entering of respective data the button 'Kendall-Test' produces the Kendall-Tau value and the p-value. In case of significant correlations (p < 0.05) the field is shown in green.
- The program is faster and more stable than the previous versions.
- The statement of significance by means of the Kendall test is mathematically meaningful only with 5 values or more.
- In order to generate diagrams below the table 'Koc' the 'Solver' must be enabled in Excel.