Table 1. The simulation model and formulas in a Microsoft Excel® spreadsheet used to calculate the risk of illness of Escherichia coli in natural cheese by means of the @RISK software

Input Model Unit Code Formula References
PRODUCT
Product
Pathogen Contamination
level
Non-EHEC E. coli PR =RiskBeta(1,91) Vose (1998)
prevalence
Concentration CFU/g C =RiskUniform(0,2) Vose (1998)
Initial contamination level CFU/g IC =PR×C Vose (1998)
Log CFU/g log(IC) =log(PR×C)
TRANSPORTATION
Transportation time h timetrans =RiskPert(1,3,6) Personal communicationa
Food temperature °C temptrans =RiskPert(0,4,10) Personal communicationa
during transportation