Dairy Science and Food Technology

Scientific, information & consultancy services for the food industry

Copyright Protected

Content copyright protected

Science Services

DSFT has been providing science based consultancy services globally since 2002.
Click to learn more.


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 output calculation are 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.



Pearson Square spreadsheets: £9.99

Visa MasterCard Discover American Express

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. To find out more about the cookies we use, see our Privacy and Cookie Policy.

'Learn more about managing cookies'