Written by Michael Mullan
MICROSOFT EXCEL PEARSON SQUARE CALCULATOR
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.
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.
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
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.