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 calculations 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 personal educational use. Only donate 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.