The Pearson Square or Rectangle calculator used on this site was validated using a Microsoft Excel spreadsheet. Two spreadsheets are now available for download subject to a small donation (£9.99) to contribute towards the running costs of the Dairy Science and Food Technology website. Both spreadsheets perform the same calculation but one (figure 1) is configured so that data inputs and the output calculation sare shown. The second, figure 2, is configured in a similar way to the calculator on this website. 

Screenshot of Microsoft Excel spreadsheet for standardizing two component mixtures

Figure 1. Screenshot of a Microsoft Excel spreadsheet for undertaking standardisation calculations using the Pearson Square Method

The unhide command can be used to see hidden cells and study the calculations. All formulas are unlocked and donors are free to customise the spreadsheets. So they can easily be adapted, for example, to standardise the sugar concentration in wine or jam, the alcohol concentration in wine or the meat content of sausages.

The download contains two Microsoft Excel spreadsheets and a document in PDF form. The PDF file explains the basis of Pearson Square calculations.

Microsoft Excel standardization spreadsheet

Figure 2. Screenshot of the second  Microsoft Excel spreadsheet for undertaking standardisation calculations using the Pearson Square Method included in the download

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