Print Page | Close Window

Calculate D value

Printed From: Dairy Science and Food Technology
Category: Thermal processing
Forum Name: Thermal processing
Forum Description: Effects of heat on food, enzymes and microorganisms
Printed Date: 02 Dec 2020 at 3:30am
Software Version: Web Wiz Forums 12.03 -

Topic: Calculate D value
Posted By: mstrange
Subject: Calculate D value
Date Posted: 11 Feb 2012 at 5:09pm
Hi again!
Cry Got table of time (mins) and nos of survivors at 200F. Pl can you tell how to calculate D at 200F?

Posted By: Admin
Date Posted: 11 Feb 2012 at 11:37pm

Welcome back.

I am going to explain how to do this by calculating the slope of the thermal death curve for the organism you have studied using an Excel function called "slope". The D-value is then obtained by obtaining the negative reciprocal of the slope.

1. I presume that you have these values in an Excel spreadsheet? If not create a workbook with 3 columns, Time (minutes), Colony forming units/ml, and Log10 colony forming units/ml.

2. Convert your colony forming units (CFU)/ml values to their log10 equivalents.

3. Excel 2010 has a useful slope function to calculate the slope of the linear regression line for x and y values and I will explain how to use this function.

4. Lets assume that your time values (x values) are in column A and range from A2 to say A15 and the corresponding log10 colony forming units/ml are in column C and range from C2 to C15. The slope can then be calculated using =slope(C2:C15, A2:A15).

5. The D-value is obtained by obtaining the reciprocal of the slope and multpling this value by -1.

6. I suggest that you produce a figure showing the relationship between time and the reduction in Log10 CFU/ml. Show the experimental values and add a trendline. Use Excel to calculate the linear regression equation and show the r2 value. If this is less than 0.9 consider your error sources and look for "tailing" of your data points.


Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -