Please fill all required fields
CALCULATOR FOR DETERMINING INGREDIENTS AND SWEETNESS AND HARDNESS INDICATORS FOR ICE CREAM AND GELATO MIXES USING WHOLE-MILK, CREAM, SMP, SWEETENERS, EGG YOLK, INULIN, CHOCOLATE, AND FLAVOURING. DEMONSTRATION ONLY. SOME INPUTS LOCKED.
MIX COMPOSITION (% SOLIDS) ADJUST DEFAULT VALUES IN "SET VALUES" WORKBOOK BEFORE DOING CALCULATIONS Fat (%)* MSNF (%)* Sucrose (%)* Dextrose (%)* Fructose or Invert Sugar (%) Select source of glucose solids, (%) Egg yolk solids(%)* Flavour (%)* E.g. Blueberry Emulsifier / Stabiliser (%)* Inulin Cocoa powder (%)  
7 8
INGREDIENT COMPOSITION, %
Cream* Whole milk* Skim powder* Is ice cream suitable for hard freezing and storage?
MSNF
MILK FAT 0 Maximum MNSF recommended
SET BATCH SIZE IN GRAMS OR KILOGRAMS
INGREDIENTS WEIGHTS AND CALCULATION CHECK
Grams Kilograms
Weight (kg) Fat (kg) MSNF (kg) PAC FPDF POD RS Ingredient
SMP
0.00 0.00 SMP Hardness at -12° C
Cream 0.00 0.00 Cream
Whole-milk 0.00 0.00 Whole-milk
Sucrose
Sucrose
Dextrose
Dextrose
Fructose / Invert Sugar     Fructose Hardness at -18° C  
CSS, glucose solids     CSS, glucose solids   77
Egg yolk
Egg yolk
Flavour
Flavour
Emulsifier / Stabiliser             Emulsifier / Stabiliser  
Inulin     Vegetable fibre      
Cocoa powder             Cocoa powder      
Totals Totals
Target values 100.0
NOTES
Data input cells Values can be changed. *Adjust values to target mix composition. Default solids values set in "Set Values" work book.
Locked for demonstration
These are set but can be changed by editing the formulae used in the spreadsheet.
Calculated The MSNF is automatically calculated from the fat concentration of the cream used.
For advice on balancing MSNF, fat and sugar concentrations click here.
MSNF= milk solids not fat . Download Excel spreadsheet. PAC= "Potere Anti Congelante" a measure of antifreezing activity that includes the freezing point depression contribution from lactose. FPDF= Freezing point depression factor
SMP= skimmed milk powder POD= "Potere Dolcificante" a measure of sweetness that includes the sweetness contribution from lactose. RS=Relative sweetness compared to sucrose
© Dr Michael Mullan, 2013. This spreadsheet is not a substitute for using a qualified food technologist.
Users use this spreadsheet at their own risk. Dairy Science and Food Technology
Data input tables
Users can modify the tabulated values to reflect information from suppliers.
  Glucose powders / syrups % solids POD or RS PAC or FPDF  
  DE25   Flavour % solids POD or RS PAC or FPDF  
DE28
Blueberry*
DE36
  DE42   Inulin* % solids POD or RS PAC or FPDF  
DE52
DE62
Notes
* POD and PAC values from suppliers will vary.
  Sugars powders / syrups % solids POD or RS PAC or FPDF              
Sucrose
Dextrose
Fructose
Lactose N/A
Terms of use
Can I customise a spreadsheet for my personal use?
Yes but you are advised make backup copies first!
Can I make multiple copies for use in my college or institution?
No. You should only do this if you buy a licence to do this!
Can I sell these spreadsheets to users?
Only if you buy the rights to do this!
I need a customised Excel solution. Do Dairy Science and Food Technology undertake customised development work and consultancy?
Possibly! Contact me and let me have details of your requirements.
What happens if I find calculation errors in a spreadsheet?
These spreadsheets have been tested extensively and it is unlikely you will find any errors. However if you use low solids ingredients you may finf negative values for SMP. This is not a calculation error and can be corrected by increasing the solids levels or changing target values for MSNF. If you do find an error I will correct the error and send you an amended spreadsheet. Under certain circumstances e.g. low fat mixes using two or more sources of MSNF, the MSNF balance may not balance exactly. This is not an error created by the spreadsheet and is a consequence of the approximations used in the serum point model. If donors Email me after the spreadsheets have been received I will also provide some advice on how to virtually eliminate this MSNF error using the Serum Point method.
Note if an ice cream formulation does not use a source of concentrated milk solids it may not be possible to achieve target MSNF concentrations. Use of special stabilisers or short storage times may be required.
If you are unhappy with the spreadsheet after it has been corrected I will be happy to refund your donation minus anyPayPal processing fees.
Do you provide technical support?
Generally no! But if if you have a problem I will try to help.
Are the spreadsheets warranted? Note the NO LIABILITY statement
No. You use at your own risk. I am providing education products intended to help users understand how to apply the principles of the Serum Point method in the formulation of mixes for use in ice cream manufacture. They are not being sold as quality assurance instruments for use in commercial production environments and should not be used commercially.
The spreadsheets require a registered copy of Microsoft Office or equivalent "Open Office" software to run. No spreadsheet application software is provided with the spreadsheets.
You should not donate with the intention of using these spreadsheets unless you intend to use them for your personal non-commercial use and accept that
• IN NO EVENT SHALL DAIRY SCIENCE AND FOOD TECHNOLOGY AND ITS OWNER Dr MICHAEL MULLAN BE LIABLE TO YOU, FOR ANY DAMAGES, INCLUDING ANY LOST PROFITS,
• LOST SAVINGS, OR ANY OTHER DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES ARISING FROM THE USE OR THE INABILITY TO USE THE SOFTWARE
• OR ANY MISTAKES AND NEGLIGENCE IN DEVELOPING THIS SOFTWARE, OR FOR ANY CLAIM BY ANY OTHER PARTY.
• YOU THE PERSON USING THIS SOFTWARE BEARS ALL RISKS AND RESPONSIBILITY FOR THE QUALITY AND PERFORMANCE OF THIS SOFTWARE.
 
Powered By SpreadsheetConverter