This page shows the interface from the spreadsheet (download October 2020). The following additonal text is taken from that spreadsheet.
This is Version 2 of "Risk Ranger", software developed at the Australian Food Safety Centre of Excellence, to assist understanding of the process of microbial food safety risk assessment. The software has been peer-reviewed and has been published in: Ross, T. and Sumner, J.L. (2002)."A simple, spreadsheet-based, food safety risk assessment tool". International Journal of Food Microbiology, 77:39-53. This paper fully describes the logic behind the system as well as its limitations.
This version has been modified from the original described in the above publication by reducing the "weight" given to "Moderate", "Mild" and "Minor" hazard severity classifications (Question 1) by a factor of 10. This preserves the risk rank scaling (0 - 100) and its original interpretation but better reflects the severity of fatal disease compared to non-life threatening hazards. Question 3 has also been slightly modified to enable better discrimination of serving frequency.
The software is useful for teaching the principles of risk assessment in relation to food safety, and highlighting factors contributing to food safety risk. It has also been used in ranking the risk of various product/pathogen combinations.
As with any such software the outputs are only as reliable as the data entered, and users are urged to remain aware of the intended uses and limitations of the program.