Published May 13, 2019 | Version 1.0
Software Open

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

  • 1. Finnish Food Authority, Risk Assessment Research Unit

Description

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.

Notes

FI; xlsm; juha.tuomola@foodauthority.fi

Files

User_manual_for_the_FinnPRIO_GUI.pdf

Files (16.8 MB)

Name Size Download all
md5:148a247db1976cdf41dec6dbbebc8519
16.7 MB Download
md5:4e99293b9012cdaffb60cc22fbac9425
145.0 kB Preview Download

Additional details

Related works

References

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