Dairy Science and Food Technology

Scientific, information & consultancy services for the food industry














Copyright Protected

Content copyright protected

Science Services

DSFT has been providing science based consultancy services globally since 2002.
Click to learn more.

Download thermal processing spread sheets

Technologists must be able to calculate the cumulative lethality of a heat process normally referred to as F. This is done by defining a reference temperature, e.g. 121.1 °C for a F0 calculation using a low acid food or e.g. 93.3 °C for an acid product, at which the equivalent lethal effects experienced during heating and cooling at lower temperatures are calculated.

The area under the lethality curve is normally calculated using numerical integration. The most commonly used method is the trapezium or trapezoid method. An alternative, more accurate, but slightly more complicated method, is to use Simpson's rule or to be more correct Simpson's rules.

 Site users can choose to download:

1) an Excel spreadsheet based-lethal rate calculator programmed using the trapezoid rule; 

2) a more accurate and easier to use Excel workbook using both of Simpson's rules and also offering the option of using the trapezoid rule. This download also contains a spreadsheet to convert Z-values in Fahrenheit or Celsius to the desired measurement system and a PDF document listing D, F, Z values and reference temperatures for the major spoilage organisms of significance to processing low acid and acid foods. A link to a free On Line resource that details thermal resistance data for many spoilage and pathogenic organisms significant to the food and pharmaceutical industries is also provided;

3) all the spreadsheets above and the author's Ebook "Thermal processing of acid fruit and vegetable products. Significant microorganisms, recommended processing time / temperatures, and public health significance of spoilage."

Options 1 to 3 are available as immediate downloads.



We use cookies to improve our website and your experience when using it. To find out more about the cookies we use, see our Privacy and Cookie Policy.

'Learn more about managing cookies'