Below is the Excel spreadsheet I created to calculate my ice cream mix. It’s based on the calculations in Ice Cream (7th Ed) by Professor Doug Goff and Professor Richard Hartel, which I highly recommend reading. There are no restrictions on the use of this spreadsheet so feel free to download and use it as you see fit. It comes populated with what I’ve found to be the optimum mix composition for 900 ml (0.95 quart) of homemade ice cream mix.
You might also like to read:
The best ice cream maker 2020 – A comprehensive guide
Lello 4080 Musso Lussino Ice Cream Maker – A Comprehensive Review
Sugar in Ice Cream
Why are stabilizers used in ice cream?
Cuisinart ICE-100 Ice Cream Maker – A Comprehensive Review
Vanilla Ice Cream – Recipe
Table of Contents
- 1. Download
- 2. Ingredients
- 3. Instructions
1. Download
You can download the spreadsheet here. This spreadsheet is, and will remain, free to download and use as you see fit. If you’d like to say thanks and support my work, you’re welcome to make a donation through PayPal.
2. Ingredients
2.1 Mandatory Ingredients
To use this spreadsheet, the 3 ingredients that you have to use are cream, milk, and sugar. You can use either full-fat, semi-skimmed, or skimmed (fat-free) milk, as well as single, light, whipping, heavy, heavy whipping, or double cream. You can use any sugar that is composed of 100% solids (i.e. no water), which includes granulated (table), cane, demerara, turbinado, muscovado, light-brown, or dark-brown sugar, as well as fructose, lactose, and maltose, but excludes liquid sugar or sugar syrup, dextrose, honey, invert sugar, corn syrup solids (CSS), and maltodextrins, which contain some water.
2.2 Optional Ingredients
You can choose whether to use skimmed milk powder, stabilisers, and emulsifiers when composing your mix.
2.3 Ingredients you can’t use
I haven’t included water, butter, whey powder, or concentrated milk, as well as the sugars mentioned above, in this spreadsheet. I may create a second spreadsheet with these ingredients if there is enough interest.
3. Instructions
Step 1. How To Enter The Cream And Milk Fat
It’s important that you only enter data in the cells coloured in yellow. To start, in cell C3 enter the fat percentage of the cream that you’ll be using. I use fresh double cream comprising 47.5g of fat per 100 ml, or 47.5% fat. In cell C5, enter the fat percentage of the milk that you’ll be using. I use fresh fat-free milk comprising 0g fat per 100 ml, or 0% fat.
Step 2. How To Enter The Mix Weight Pre and Post Heating
2.1 If You Are Not Using My Method of Heating
If you’re not planning on using my method of heating the mix at 72°C (161.6°F) for 25 minutes to pasteurise and promote reversible protein denaturation, which I’ve found has a significant effect on texture, or are using a closed pasteuriser, the weight of your mix pre and post heating will remain constant. In cell C18 enter the weight in grams of the batch that you want to make; about 997g produces 900 ml (0.95 quart) of mix, 890g about 800 ml (0.85 quart), and 760g about 700 ml (0.74 quart). In cell G18, enter the same value that you entered in cell C18.
2.2 If You Are Using My Method Of Heating
If you intend to use my method of heating the mix at 72°C (161.6°F) for 25 minutes, you’ll need to account for the reduction of water through evaporation, which will increase the solids percentages of the mix after heating (displayed in cells D30 to D36). When I heat my mix, I use a pan with a 24 cm (9.45″) diameter and have found that 10% of the water in my 1150g starting mix evaporates, leaving 1035g of mix after 25 minutes of heating. Determining the amount of water that’s evaporated from your mix will take some trial and error and will depend on factors including the size of your pan, the heating temperature, elevation, and ambient temperature.
I recommend starting with 1150g in cell C18 and 1035g in cell G18. Cells C20 to C26 display the weight of each ingredient needed for your mix. Use these values to combine all of your ingredients in your pan. Once combined, place your pan on some kitchen scales and record the combined weight of the mix and the pan. My starting weight is 2488g (1150g starting mix weight + 1338g weight of pan). On a medium heat, bring your mix to 72°C (161.6°F), which will take between 10 and 16 minutes, whilst continuously stirring. Once your mix reaches 72°C (161.6°F), keep it as close to this temperature as you can for 25 minutes whilst stirring. After 25 minutes, place the pan back on the scales and record the combined weight of the pan and the reduced mix. Subtract the weight of the pan from the total weight of the pan plus the reduced mix to get the weight of the mix after heating; mine is 1035g (2373g total weight of pan and mix after heating – 1338g pan weight). Enter the weight of the mix after heating in cell G18. Use Steps 3-7 below to adjust the data so that cells D30 to D36 display the following optimum mix composition:
- Total Solids – 55.3%
- Not Fat Milk Solids – 10.8%
- Fat – 24%
- Sugar – 16.2%
- Egg Yolk – 4.3%
- Stabiliser – 0%
- Emulsifier – 0%
Step 3. How To Enter The Mix Fat
The percentage of fat in your mix after heating is displayed in cell D32. For homemade ice cream, I’ve found a mix comprising 24% milk fat optimum for the promotion of smooth and creamy texture. If you’d like to change this, change the value in cell C4.
Step 4. How To Enter The Milk Fat-Not-Solids
The percentage of not fat-milk-solids in your mix after heating is displayed in cell D31. I’ve found the optimum milk fat-not-solids percentage in homemade ice cream to be 10.8%. You can change this by entering a different value in cell C6. If you don’t want to use skimmed milk powder, decrease the value in cell C6 so that cell D31 displays 0.
Step 5. How To Enter The Stabiliser and Emulsifier
The percentage of stabiliser in your mix after heating is displayed in cell D35 and the percentage of emulsifier in cell D36. I don’t use stabilisers or emulsifiers in my mix but If you’ d like to use either of these two ingredients, enter the amount of stabiliser in cell C12 and emulsifier in cell C13. Usually, 0.2-0.5% of a stabiliser/emulsifier blend is used in ice cream.
Step 6. How To Enter The Sugar
The percentage of sugar in your mix after heating is displayed in cell D33. I’ve found that around 16.2% sugar in homemade ice cream works well. To change this, you can increase or decrease the data in cell C14.
Step 7. How To Enter The Egg Yolk
The percentage of egg yolks in your mix after heating is displayed in cell D34. To increase or decrease this, change the value in cell C15. I’ve found that around 4.3% egg yolk solids works well in homemade ice cream.
Related Posts
Egg-free Vanilla Bean Ice Cream – Recipe
Why is corn syrup used in ice cream?
Cuisinart ICE-30 Ice Cream Maker – A Comprehensive Review
Cuisinart ICE-100 Compressor Ice Cream and Gelato Maker – A Comprehensive Review
Partial coalescence of the ice cream fat emulsion
Coffee Ice Cream – Recipe
Roasted Banana Ice Cream – Recipe
Homemade Lemon Curd Ice Cream – Recipe
Hello Ruben,
Thanks a lot for your posts, very interesting to read! There are, however, a couple things that I would like to confirm with you if it’s not too much trouble.
1) I’m not using skimmed milk. If I remove it from the spreadsheet the total solids ratio drops to 44%. The only way to increase it will be using more yolks or sugar, but then their respective percentages will be higher than those indicated in the optimum mix composition. Which of these percentages should I prioritize? Total solids ratio, I guess?
2) This one is related to the previous question. If I try to aim for 55% solids without skimmed milk, with the rest of spreadsheet values set to default, I end up with 25 grams of yolk per 100 grams mix. That’s 16 yolks for 1 liter, which sounds a bit extreme to me. Am I miscalculating something?
3) I’ve tried the 72 degrees method (previously have been using 65 degrees). I think my thermometer is a bit off, as the custard lost around 30% of volume and a small amount of egg near the bottom seemed cooked (though the custard was not entirely ruined). The resulting ice cream, while very smooth, dense and creamy, was way too sweet (apparently, due to too much water having evaporated).
Assuming I’ll be losing 30% every time, this means I just need to decrease the amount of ingredients in per 100 grams section correspondingly, so that I end up with proper post-heating percentages?
Thanks!
1) I think because it’s in skim milk’s nature not to contain fat + water, using it in the mix is help us easily control “Not Fat Milk Solids” and “Total Solids”.
Is there any reason you can’t use skim milk?
Would you be able to show us how to do formulate vegan ice-creams, from say almond milk, coconut milk or soy milk?
Ps- Some great info on here 🙂
Hello! I am at the very beginning of my ice cream maker’s journey and hope to have good news reports soon! So so much to learn!
Hello Ruben. I’m trying out your calculator. The recipe that I am using requires both evaporated and sweetened condensed milk (in addition to heavy cream). How do I calculate the milk fat percentages of these? How do I calculate the sugar percentage each contributes to the recipe? Or does your calculator not allow for that? Thank you in advance.
hi Ruben, I have a problem. When I download it, it’s only on reading mode. I can’t use it.
Can you help me please?
Ola Sandra,
I have updated this post and you should now be able to download the spreadsheet and change the data in the yellow cells. Please let me know if it doens’t work.
All the best,
Ruben
Thanks a lot Ruben
Thanks for icecream calculator. I intend to use it with powder milk, which can be easily converted liquid milk by assuming mixing ratio with water at a rate of 1:7. As for butter, would be possible to apply in the model, by assuming the cream has fat ratio of 82 percent?
Hi Ruben,
Thank you… this very helpful for me, currently im using the cuisinart ice-100, so I will try to have smaller size of the ice cream. can you share me the input if I wa
Thanks Ruben
Can I get a C program for ice cream mix calculation
Hi Ruben
I’ve just purchased the Cusinart ICE100 Ice Cream Maker and want to experiment with different recipes. What is the smallest portion size you would recommend for trial of recipes? Thanks.
Hi Betty,
Thanks for getting in touch. Good to hear you went with the ICE-100. 500ml of mix is the smallest size I’ve churned. I’m pretty sure (although not certain) that I tried a 400ml batch before but this didn’t freeze properly because the mix just clumped in the middle of the bowl. You can’t go wrong with 500ml for testing 😀
I hope that helps.
All the best,
Ruben
Hi Ruben
Thanks for the reply. That’s really useful. I have tried a smaller amount & like you said it didn’t churn properly. Will try the 500ml. Trying your stem ginger recipe today. Loving your website. Best wishes Betty
Hope the stem ginger goes well.
All the best,
Ruben
Hi Ruben,
I have a Taylor Soft Serve Machine and am trying to figure out a recipe for it. I have had it a while and never used it, but am ready to start playing.
I would really like to try to make Soft Serve Ice Cream, as well as Frozen Custard.
Are there any major differences in a recipe for a machine vs your recipe above?
Hey David,
Thanks for getting in touch. That’s a good question. Yes there are quite a few differences between a commercial soft-serve mix and hard serve mix (lower fat and sugar, higher MFNS and higher stabiliser and emulsifier; balancing the emulsifier will be a little tricky because of the higher MSNF so will require a bit of trial and error). I don’t think my recipe is likely to work in your Taylor machine but I’d recommend giving it a go.
I hope that helps.
All the best,
Ruben
Hi Ruben
Thanks for the informative Blog. I have tried to download your Calculator several times but it just gives me the Read Only copy.
Pls send me the Calculator by email
Regards
Steve
Can you tell me how much 3.5% butterfat whole milk to add to one gallon of 14% butterfat ice cream mix to reduce the total butterfat content to 10%?
Hi Ruben,
Thanks for your work on this calculator. It’s been quite helpful.
Question regarding the heating process: why not just perform the heating with a lid on the pan so evaporation is minimized the post-heating values aren’t subject to so much error? Is there a benefit to allowing evaporation, such as reduced water content?
Yes, less water means less large crystals formihg.
If you use 24% fat mix, you will make the butter not the ice cream, . . And you will have to eat them in 2 days because they will change tha taste and it will taste as rotten butter.
I’m getting best results with 12% fat mix
Hi Ruben, thanks for sharing your ice cream calculations!
I’m just curious if you adjust the sugar content in your recipe for fruity ice creams (strawberry, blueberry, mango etc.) I’ve found that my fruity ice creams scoop much softer than the classics.
I’m also curious if you’ve tried making a brown-butter ice cream base, and how you would adjust for the fat content in the butter.
Thanks!
Laura
Hi, Ruben. I hope you’re doing well. There’s no word to tell you how much I appreciate the work you put in your website. I hope you can visit the Philippines some time so we can appreciate your ice cream too.
I have a question: in your spreadsheet you have the desired milk fat in c4. What does it mean, and how do you come up with a number to put there? It significantly affects the amount of ingredients in other cells, so I’d like to understand more about it. I’m not sure, though, if I’m asking the right question.
Thank you in advance for your answer!
I think it’s the percentage of total milk fats from the cream and milk. If you want more fat in your mix (by increasing the number in C4) itll change the amount of cream and milk to reach that percentage in C4.
The amount of fat from cream is displayed in D9, and the amount of fat in milk is displayed in D10.
D16 adds D9 and D10 (the amount of fat from cream and milk respectively), which you will notice will parallel what you input in C4.
Ultimately, increasing the number in C4 changes the ratio of cream/milk/ and skim milk powder, which in turn will raise the fat content in your ice cream mix post heating seen in D32.
I THINK.
I had to spend some times understanding the chart myself heh
Hi! I’m so happy to have found your site, however, feeling very confused. My cream is 33.3% fat, milk is 3.3% fat. My confusion is, once I enter these figures in and reduce for 25 min and then enter that post-heating weight in, the post heating summary changes of course. What do you do after that? I guess I’m not understandingt what you mean when you say to use Steps 3-7 to adjust the data so that cells D30 to D36 display the optimum mix composition. If I adjust values,what will that do to my mix? Am I supposed to then add more cream, milk and sugar, egg ? I’m sorry, I’m so lost. Must be old age. I just don’t understand the purpose of adjusting the values 🙁
Hey thanks so much for posting this spreadheet! I do have a couple of questions.
For one, since this spreadsheet bases all ingredient values by weight, how can I easily convert this to rough volume so I can target the volume of my ice cream maker when crafting a recipe?
Two, regarding ice cream with the addition of fruit puree (in my case persimmon), how can I account for the additional liquid, sugar, and fiber that comes with the fruit? Thanks again for the great tools and info here!
Trial and error maybe? Unless you have specific details on how much over run your ice cream maker does, you wont really know how much volume is added to your ice cream mix.
Compare the weight of the ice cream before and after and use the percentage of weight gained to gauge your maximum capacity.
I want to know ,if I mix in 100 Ltr water ,then how many 1- smp, 2- sugar ,3- vegetable fat ,4 – stabilizer required.
Hi Ruben,
I hope you are doing well.
I am a die heart ice cream fan and your blog is like the bible for it!!!
I just love the perfection in measures that you take.
I have been making ice creams for a while here in India.
The issue here is the milk fat in packed creams is 20-25% . Hence the cream qty goes up and the milk qty goes into minus..
What do you suggest I can do?
Hi Mustafa!
Thanks for getting in touch. That’s a very good question. If you use cream at 25% milk fat, I’d recommend a mix that consists of the following after heating:
Total solids: 53%
Not fat milk solids: 12%
Fat: 21%
Sugar: 16%
Egg yolk: 4%
Play around with the spreadsheet until you get the above figures. Heat your mix to 77°C, instead of 72°C, and keep it there fore 30 minutes. You should be able to produce ice cream with creamy texture. You should also be able to use wither full-fat, semi-skimmed, or skimmed milk.
Hope that helps. Let me know if you need help.
All the best,
Ruben
Hello Buddy.
I have gone through your sheet and have a doubt.
In the skimmed milk powder section you have taken 88 as a multiplication factor.
How did you derive this factor?
And i would also appreciate if you can formulate a sheet for water base as well.
Thanks
Hey thanks for the make up of this spreadsheet! I was just wondering if you have ever tired with with a non-dairy ice cream?
Hi there Clubannie!
I haven’t yet tried making vegan or non-dairy ice cream but it is number 1 on my research list as I keep getting asked about this. I’ll post my findings and recipe when I finish my research.
Until then, let me know if you need a hand with anything else.
All the best,
Ruben
Hey Ruben.
Any updates on vegan ice cream? Would love to have some guidance if you have any tips. Thanks!
Hi Ruben, thanks for posting this, it is very useful. I’ve made a lot of homemade ice cream that was pretty good but the texture was not as rich. Thanks to your blog and this spreadsheet, I now know it helps to add skim milk powder and how much of it to use. Interestingly enough, even though a lot of milk powder is produced in the Netherlands, it is quite difficult to purchase it here. Supermarkets do not carry it. Probably because fresh milk is so easily available.
Hey again Stefan,
Hope the spreadsheet helps. How are you getting on with it? Did you manage to get hold of some skim milk powder?
All the best,
Ruben
I know this is old, but I was also looking for it myself.
We actually do have it in the supermarket in the Netherlands, try
‘Campina Elk magere melkpoeder’
Link to spreadsheet is not working
Seems like a momentary problem with OneDrive…
Hi there Itay,
Microsoft One Drive seems to be down. It will hopefully be back up and running tomorrow. Let me know if you still have trouble getting the spreadsheet and I’ll send it through to you via e-mail.
All the best,
Ruben
Hi Ruben, thanks for providing this. This precision is exactly what I’ve been looking for. However, I notice the spreadsheet doesn’t account for the fat and water content of flavor ingredients. How do we calculate the right balance of fat and water content of our flavors? For instance I am making sour cream ice cream and I can never get the right texture when its finished. Fruit flavors are also challenging. Thanks for your help!
Hi there Heather!
Thanks for getting in touch. That’s a very good question. So I started out just using the same base recipe for all of my recipes, regardless of the flavour added. I’m now starting to account for the solids in added flavours, especially those high in fat, i.e. nuts, and am just basically testing different compositions of my base mix until I’m happy with the results. I might try and add another column in the spreadsheet to account for the solids and fat provided by added flavours.
Yes fruit flavours will probably be the most challenging because of the varying amounts of sugar and water in fruits, which vary greatly depending on time of harvesting etc. I haven’t yet done much research into fruit flavours so don’t know how much help I can be there.
I hope that answers your questions. Let me know if you need a hand with anything else.
All the best,
Ruben
Hello, Ruben!
Thanks for your great work – this table is brilliant! I’m making my first steps in gelato making and it’s really helpful. With your recipes and technics my gelato became silky smooth.
However I have a notice – your table does not count fats from yolks at all (about 27%). If you are interested – I’ve made some fixes and modifications to your table. You can find it here:
https://docs.google.com/spreadsheets/d/1SuA1WMLVmAg7MpRpzm4hlZK6w5EEN6crNyLecukk4qw/edit?usp=sharing
Have a nice day,
Mikhail
PS Hello from Russia 🙂
Hi there Mikhail!
Thanks for getting in touch. Glad the spreadsheet is helping. Yes the spreadsheet doesn’t count for the fat in the yolks because the calculations from Ice Cream by Goff and Hartel that the spreadsheet is based on also don’t take account of the yolk fat. I think this is because it is primarily the milkfat that contributes to smooth and creamy texture.
Thank you for sending the modified spreadsheet, I’m sure there will be plenty of people that will be interested in this!
All the best to you in Russia,
Ruben
In these spread sheet what is the meaning of reduction percentage please elaborate the meaning and use in this sheet … if we increase or decrease the percentage so what will be effect on the final product ?
Thanks from India
Milan
Hi Ruben. Thank you for your generosity with your knowledge and experience. You are one of the people who make the internet a great thing. We bought a Cuisinart Ice 100 based on your review and the it makes has been a big it with everyone. Going to use your basic recipe tonight for the first time as I finally found dried skimmed milk powder in the supermarket.
Hi there Paul,
Thank you for the kind words. Great to hear the ICE-100 went down well. How did you get on with my recipe?
All the best,
Ruben
Ruben do you have a gelato spreadsheet after the style of the ice cream one?
Regards
Stephen
Hi there Stephen,
Thanks for getting in touch. I don’t have a spreadsheet specifically for gelato but you can use this one. Ice cream and gelato both use the same ingredients, just at different quantities. You can adjust the quantities in this spreadsheet to create a gelato recipe, as long as you know the composition you are aiming for. I haven’t tried making gelato myself so may not the best person to ask for a gelato mix composition.
Let me know if you need a hand.
All the best,
Ruben
Ruben
Have been following your website for a while and really enjoy it. I make lots of ice cream and find your method of cooking by weight very intriguing. Having said that, your spreadsheet makes my eyes glaze over. I have tried to follow it but need some help to simplify. Instead of “per 100 grams” can you tell me approximately, how much cream, milk, sugar and eggs are in a 900 ml (1 quart) batch when expressed as the number of extra large eggs & cups (or mls) for milk cream & sugar. I use 35% cream and 2% milk. For example; in a vanilla recipe my relevant ingredients are 2 cups cream, 6 large yolks, 1 cup milk, 3/4 cup of sugar. To follow your recipe I would also add skim milk powder.
I particularly enjoy your reviews on ice cream makers and only wish they would make a good one for home use I could afford. Until then, I will stick with my freezer tubs.
Thanks for any help.
Marc W
Lakeshore Ontario
Canada
Hi there Marc!
Thanks for getting in touch. That’s a very good suggestion, thank you for letting me know. Are you using the weights in cells C20 to C28 for your recipe? You don’t need to use the weights in the ‘per 100g’ column to measure out your ingredients. I will have a think about incorporating a row to display ingredient amounts either in cups or ml. My only reservation is that this may not be as accurate as using grams but we shall see. Egg yolks will probably remain in grams because egg yolks size/weight is difficult to standardise.
All the best,
Ruben
Thanks for sharing the spreadsheet. It’s much cleaner than my messy spreadsheet. A couple questions: I’m assuming you are using 9% as the NFMS percent of cream and skim milk for simplicity? Using the USDA Food Composition Databases, my calculations on 37% cream vs. skim milk indicate the NFMS to be 9% in skim milk and 5% in 37% fat cream.
Also in cell C11, what is the the /88*100?
Hi there Jeff!
Apologies for the delay, I’ve only just realised that this comment was here. Yes a 9% constant content of milk solids not fat is assumed in milk and cream. You can change this in the spreadsheet if you want to have more accurate figures for your cream. I can’t remember off the top of my head which formula will need to be changed for this but let me know if you need a hand with this and I’ll have a look.
The /88 in cell C11 is the 97% milk solids not fat in skimmed milk powder – 9, which gives 88.
I hope that makes sense. Let me know if you need a hand with anything else.
All the best,
Ruben
Thanks Ruben. This is helpful. I have difficulties making ice cream as I have HFI (Hereditary Fructose Intolerance) so not only is sugar out of the question, but I have a strong aversion to anything tasting sweet. Through trial and (a lot of) error I now make a reasonable ice cream from cream, evaporated milk and dried skimmed milk. Looking at your information the dried milk probably gives the sugar content from lactose. I will try working with the spreadsheet proportions (using lactose) and see how I get on.
Hi there Carolyn,
Apologies I’ve only just seen your comment. How are you getting on with the spreadsheet proportions? Yes the dried skimmed milk will contain some sweet lactose. I would recommend using a lot of cream, or cream with a high fat percentage. The higher the fat content, the lower the milk solids not fat in the milk and dried skimmed milk you will need and, consequently, the lower the lactose you will have.
Let me know if you need a hand.
All the best,
Ruben
Hi Ruben and Carolyn,
I’ve been using a lot of Lactose powder in my ice creams in the last 6 months and have the following findings:
1. Lactose is approximately 16% as sweet as standard table sugar (sucrose), but it has the same amount of softening power. So you may find that if you exchange 1 for 1 it might not seem sweet, but it holds about the same texture.
2. The mixture will be good for about a week or two, but will for some reason form a weird coarse sandy texture. So you’ll want to consume in short time. This tends to matchup with what you can find googling lactose in ice cream.
Carolyn, have you tried other sugars, like dextrose or glucose (there’s a bunch more). Does that result in issues? Dextrose is about 70% as sweet, but has 190% the softening power as sucrose.
BTW, keep up the good work Ruben!
David
Very helpful message there David, thank you for that 🙂
Congratulations from Greg, Quebec, Canada
Thank you Greg! 🙂