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:

FI; xlsm;
Files (16.8 MB)
Name Size
16.7 MB Download
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.

  • 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.

All versions This version
Views 375377
Downloads 134134
Data volume 201.4 MB201.4 MB
Unique views 283285
Unique downloads 110110


Cite as