Published July 6, 2017 | Version v1
Software Open

Listeria monocytogenes risk assessment model for three ready-to-eat food categories in the EU

  • 1. Departamento de Bromatología y Tecnología de los Alimentos, University of Cordoba (UCO), Córdoba, Spain
  • 2. Institut de Recerca i Tecnologia Agroalimentàries (IRTA), Food Safety Programme, Monells, Spain

Description

The Listeria monocytogenes risk assessment model allows the estimation of the number of listeriosis cases per year in the EU population as well as predicted risk for listeriosis per million servings from consumption of a meal containing each of the three ready-to-eat (RTE) food categories: heat-treated meat, gravad and smoked fish and soft and semi-soft cheese. For each food category, a specific risk model spreadsheet was built, in Excel (Microsoft, Redmond), using functions from @Risk software (Palisade ©, NY). The risk model Excel files for the above-mentioned RTE food categories were named as “Listeria_RiskModel_meat_v1.xlsm”, “Listeria_RiskModel_fish_v1.xlsm” and “Listeria_RiskModel_cheese_v1.xlsm”, respectively. In addition, an Excel Add-in, called Lis-RA, was developed with Visual Basic for Applications (VBA) based a customized Ribbon interface that allows users to load risk models, select scenarios and define model inputs and simulation settings. The software tool, contained in the file named as “Listeria_App_LisRA_v1.xlsm, is an easy and intuitive way for introducing, selecting data and options for listeriosis risk assessment model simulation. The application requires @Risk software installed and is optimized for Excel 2016 and @Risk 7.0 and 7.5. The user manual explains the structure and use of the spreadsheets developed in Excel and the main features of the Add-in Lis-RA.

Files

Listeria_RiskModel_user-manual_v1.pdf

Files (2.6 MB)

Name Size Download all
md5:d8e6a83f9f918b3bf9af9612df6f7210
92.2 kB Download
md5:ff76c94cce7fc5acd0fc7987f81670d1
388.5 kB Download
md5:5ade46574ade71f3f8d14ec43f95f5f0
298.4 kB Download
md5:b11acb43a70aae7d11eaf18eddad2dfb
354.8 kB Download
md5:80a8ec939fff97e04d9d8b44fd79bbae
1.4 MB Preview Download

Additional details

Related works

Is supplement to
10.2903/sp.efsa.2017.EN-1252 (DOI)