Download Microsoft Excel standardisation calculator for whole milk powder manufacture

The calculator used on this web site for producing milk powder to a target fat concentration was validated using a Microsoft Excel spreadsheet. This spreadsheet is available for download subject to a small donation (£4.99, < €6 or <US $10, conversions based on the exchange rate at March 2012) to contribute towards the running costs of the Dairy Science and Food Technology website.

The download contains one Microsoft Excel spreadsheet and a document in PDF form. The PDF file explains the basis of the calculations. A screenshot of the spreadsheet is shown in figure 1.

 Image of Excel spreadsheet for producing whole milk powder to fat target

Figure 1. Screenshot of the Microsoft Excel spreadsheet for undertaking calculations to determine the fat concentration required to produce a milk powder to a defined fat concentration.

All the cell formulas are unlocked. The spreadsheet is for your own personal educational use. Only make a donation if you accept the Terms and Conditions for the use of Spreadsheets from this site.

Pay with PayPal, PayPal Credit or any major credit card



Following secure payment you will shortly receive an Email with a download link. The link is valid for 7-days and during this time you can download the spreadsheet 4-times.


We use cookies to improve our website and your experience when using it. Cookies used for the essential operation of the site have already been set. To find out more about the cookies we use and how to delete them, see our Privacy Policy.

I accept cookies from this site