I've just wrote a quick spread sheet to help with brew calculations
It works out sparge amounts etc.
It takes the actual compared to the theory and works out the data to upgrade your theory data.
Green is data you input
Yellow is calculated for you.
The idea is to copy to a new sheet for the next brew with the updated info. If I get chance I'll get it to work out the Potential Gravity and work out efficiency from actual gravity. I can play about with working out IBU and colour for recipe calculation.
I've done it for my metric brain it's easy to change to imperial or you if you want. (Edit: I've put som in to imperial and us as well)
Please feel free to have butchers, let me know if you spot any errors or update suggestions.
You're all welcome to use it.
http://www.ushould.co.uk/brew/brew.xls
It works out sparge amounts etc.
It takes the actual compared to the theory and works out the data to upgrade your theory data.
Green is data you input
Yellow is calculated for you.
The idea is to copy to a new sheet for the next brew with the updated info. If I get chance I'll get it to work out the Potential Gravity and work out efficiency from actual gravity. I can play about with working out IBU and colour for recipe calculation.
I've done it for my metric brain it's easy to change to imperial or you if you want. (Edit: I've put som in to imperial and us as well)
Please feel free to have butchers, let me know if you spot any errors or update suggestions.
You're all welcome to use it.
http://www.ushould.co.uk/brew/brew.xls