Software Open Access

A Graphical User Interface for the FinnPRIO model: A model for ranking plant pests based on risk

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.

FI; xlsm; juha.tuomola@foodauthority.fi
Files (16.8 MB)
Name Size
FinnPRIO_GUI_version1.xlsm
md5:148a247db1976cdf41dec6dbbebc8519
16.7 MB Download
User_manual_for_the_FinnPRIO_GUI.pdf
md5:4e99293b9012cdaffb60cc22fbac9425
145.0 kB Download
  • 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/

279
102
views
downloads
All versions This version
Views 279280
Downloads 102102
Data volume 147.2 MB147.2 MB
Unique views 215216
Unique downloads 8383

Share

Cite as