Software Open Access
Marinova-Todorova, Mariela; Tuomola, Juha; Heikkilä, Jaakko; Hannunen, Salla
FinnPRIO is a model for carrying out quick, well structured, semiquantitative expert assessments on the risk that invasive pest species pose to plant health. The model has been published by Heikkilä et al. (2016) and a full description of it can be found in the article. This release provides a graphical user interface (GUI) for the FinnPRIO model and a user manual for the GUI. The FinnPRIO GUI has been designed for carrying out and storing FinnPRIO assessments
The FinnPRIO GUI is run in Microsoft Excel. The GUI was created with VBA in Microsoft Excel 2013 on Windows 7 Enterprise (32-bit) and some modifications were done in Excel 365 on Windows 10. The functionality of the FinnPRIO GUI in previous versions of Microsoft Excel hasn’t been tested.
Before using the FinnPRIO GUI in Excel, BERT (Basic Excel R Toolkit) needs to be downloaded and installed. This is because the simulation of the assessment scores in FinnPRIO GUI is partly carried out in statistics language R (R Core Team 2015) using the package "mc2d" (Tools for Two-Dimensional Monte-Carlo Simulations) (Pouillot & Delignette-Muller 2010) and BERT is used to connect Excel with R.
BERT can be freely downloaded from: https://bert-toolkit.com/download-bert.
Heikkilä J., Tuomola J., Pouta E. ja Hannunen S. (2016). FinnPRIO: a model for ranking invasive plant pests based on risk. Biological Invasions 18: 1827-1842. http://link.springer.com/article/10.1007/s10530-016-1123-4
Pouillot R. & Delignette-Muller M.-L. (2010). Evaluating variability and uncertainty in microbial quantitative risk assessment using two R packages. International Journal of Food Microbiology 142(3): 330-340
R Core Team. (2015) R: A language and environment for statistical computing. R Foundation for Statistical Computing, Vienna, Austria. http://www.R-project.org/