Freezing point depression spreadsheets

This page provides access to 3 spreadsheet packages which can be downloaded for a fee which will enable me to cover the hosting, domain and software upgrade costs associated with running this website.

The requirement of gelato and ice cream development technologists to construct freezing curves for ice cream or gelato mixes has been discussed. In particular knowledge of the concentration of frozen water at serving temperatures can be used to ensure that batches have acceptable hardness or scoopability.  Additionally, the mass of frozen ice present can be used to calculate the resistance to heat shock, storage stability and susceptibility of packaging to deformation during storage and distribution.

The calculation of a freezing curve is fairly straightforward and has been summarised on this website and by Goff and Hartel (2013). The curve can readily be calculated using a spreadsheet. 

Please read the Frequently Asked Questions (FAQ) about the Microsoft Excel Ice Cream Mix spreadsheets supplied by the Dairy Science and Food Technology website before making a donation to obtain these spreadsheets. 

The formulas used to calculate FPD are locked in package 2 and there is no sucrose FPD calibration curve.

Details of the spreadsheet for calculating the freezing point of gelato/ice cream mixes are shown in Figure 1.

Excel work book for constructing freezing point curves for ice cream

Figure 1. Spreadsheet for calculating the freezing point of gelato/ice cream mixes.

Users can investigate the effects of sucrose, high fructose corn syrup, monosaccharides (dextrose, fructose), maltodextrins, glucose syrups, high maltose corn syrups, MSNF, whey solids and the initial moisture concentration of mixes on FPD.

Ideally, whey solids should be entered separately from MSNF. If so, their contribution to MSNF should not be included in the figure for MSNF.

Options have been provided to investigate the use of maltodextrins ranging from DE5 to DE18 (figure 2).

 Selection options for maltodextrin

Figure 2. Options for maltodextrin inclusion.

Glucose solids ranging in DE from 10 to 62 can also be used (figure 3).

 Selection options for DE glucose syrupss

Figure 3 Options for using glucose syrups

 A facility to investigate the use of high maltose corn syrup of DE42 and DE50 has also been added (figure 4).

 High maltose corn syrup selection options 
Figure 4 Options for high maltose corn syrup inclusion.

 The spreadsheet also provides users with two warning messages if the sucrose equivalent concentration in the frozen mix at a particular temperature exceeds 180 g per 100 g water. Pickering (1891) only investigated the effects of sucrose concentrations up to 180 g of sugar per 100 g of water so caution is required if users attempt to work with higher sucrose equivalent concentrations. Additionally, cells giving the high values are coloured yellow or red depending on the magnitude of the calibration discrepancy.

Download Excel freezing point curve spreadsheet packages for ice cream or gelato

Package 1

Note package 1 is unlocked and also contains an Excel workbook listing sucrose concentrations and the corresponding freezing point depressions (FPDs). The spreadsheet shows the Excel trend line with the corresponding fourth-order polynomial regression equation and R2 value. Again all values are unlocked. The data used to construct the freezing point curve were extrapolated from Leighton (1927) by Goff and Hartel (2013). Leighton (1927) obtained this data from the earlier work of Pickering (1891).

These 2 unlocked Excel spreadsheets cost £50, one for calculating the freezing point depression curve for an ice cream or gelato mix and the other for calculating the regression equation relating sucrose concentration to freezing point depression can be downloaded. The regression equation uses sucrose equivalent values of mix components to determine FPD. Note the freezing point depression curve is not required for the calculator to work, the regression equation from the curve is already integrated into the calculator and can be accessed in the unlocked spreadsheet cells. 

Subscribers to the DSFT On-Line Subscription Calculator can access a fully working version of this spreadsheet and high value premium resources for a nominal cost.

Note this spreadsheet package is available as a free download to users who purchased the complete set of ice cream mix spreadsheets (pack 9). 

Please make a donation of £50.00 to obtain these spreadsheets. 

 


Pay with PayPal, PayPal Credit or any major credit card
  

Package 2

This pack contains one locked Excel spreadsheet, cost £15, for calculating the freezing point depression curve for an ice cream or gelato mix.

Note this spreadsheet is now available as a free download to users signing up for any of the subscriptions for the Dairy Science and Food Technology ice cream mix calculator. Current subscribers can download the package using the Resource tab on the Calculator.

Please make a donation of £15.00 to obtain this spreadsheet.

This spreadsheet is similar to the package above except that the formulae used to perform the calculations cannot be accessed and the calibration curve used to relate sucrose concentration to FPD has not been provided. The spreadsheet uses the regression equation to do the calculation but users cannot access the equation because the cells are locked.

  


Pay with PayPal, PayPal Credit or any major credit card
   

Package 3

This is an extensively customised version of package 1 and contains a modified version of the workbook for generating the curve (Figure 3) and also package 1.

Cost £100. This also includes 1-year's free access to the On Line Ice Cream Mix Subscription Calculator. The latter must be requested to webmaster at dairyscience.info to activate your account.

 Figure 3. Customised spreadsheet for calculating the freezing curve of ice cream, gelato and similar products.

 

Additional sweeteners including polyols are included, as are a range of additional milk sources, salt and sugared egg yolks.

A "values workbook" giving default ingredient values is also provided. These can be modified or added to by the user. A warning is provided if the linear relationship between sucrose equivalence and FPD is exceeded. 


Pay with PayPal, PayPal Credit or any major credit card

Literature cited

Goff, H. D. and Hartel, R. W. (2013). Ice Cream. 7th Edn.  Springer: New York.
Leighton, A. (1927). On the calculation of the freezing point of ice cream mixes and of quantities of ice separated during the freezing process. J. Dairy. Sci., 10, 300-308.
Pickering, S. V. (1891). The freezing point relationship of cane sugar. Berichte Deutsch. Chem. Gensellschaft, 24:333.