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)
Subjects
- listeriosis
- http://aims.fao.org/aos/agrovoc/c_24119
- Listeria monocytogenes
- http://aims.fao.org/aos/agrovoc/c_26553
- risk assessment
- http://aims.fao.org/aos/agrovoc/c_37932