Nice spreadsheet.
One small fault which I found after downloading it some time ago. It may be fixed by now.
The hydrometer units (SG or Plato) incorrectly referenced the price cell. I changed the cell reference from D7 to D9 in column G to correct that.
A couple of documentation errors.
- Item 4 in the instructions reads "If you don’t have unfermented wort on hand, create a wort solution that is roughly 20 °P / 1.083." What exactly does this mean?
Item 4.3 states "Measure the solution with the hydrometer", but fails to mention applying a temperature correction.
You recommend taking 5 samples of the same wort and averaging the results. While this will not hurt, I find multiple samples of the same wort always give identical readings. It may be worth mentioning that multiple samples are usually only necessary if you have a defective refractometer.
You say that the WCF is specific to the instrument. This would be true if different instruments introduced inaccuracies, but it is also dependent on the grain bill. If I make a beer with 95% M.O, and 5% Crystal 60, I get a WCF of 1.020 to 1.024. If I make a beer with 90% MO, 5% crystal 60, and 5% Torrified wheat, I get a WCF of 0.985 to 0.987.
To get around this problem, I maintain a different copy of the spreadsheet for different recipes, and apply the WCF that is specific to that recipe.
-a.