updated alpha calculation, testing of the alpha calculation, and the spreadsheet calculation