Upload Link:
http://s000.tinyupload.com/?file_id=00827233175939927467
So here's what I've worked on so far. I'm no excel guru, I barely know anything but I was able to put this together which works for me. I used formulas from how to brew and also some that I found online for use in the spread sheet. Overall it was a fun experience, being able to customize it and knowing that I created it is almost as rewarding as creating your own beer!
I was looking for any feed back to improve it. So here's how it works:
You input Volume, Grains, PPG, Color rating (There's a reference for grains in the last tab with this info); for hops you input type, aa% , amount (oz) and time, for utilization theres a chart I made in a separate tab that you'll see where you get utilization by entering the ranges of og and time and it does the utlization calc semi-automatically and transfers it to the recipe spread sheet and calculates ibus.
For the mash you enter your efficiency and grain temp and it calculates strike temp, pre boil volume, mash thickness, and pre boil gravity.
The yeast section is still a work in progress it already does some things but Im mostly inputing data from other software for the recipe.
http://s000.tinyupload.com/?file_id=00827233175939927467
So here's what I've worked on so far. I'm no excel guru, I barely know anything but I was able to put this together which works for me. I used formulas from how to brew and also some that I found online for use in the spread sheet. Overall it was a fun experience, being able to customize it and knowing that I created it is almost as rewarding as creating your own beer!
I was looking for any feed back to improve it. So here's how it works:
You input Volume, Grains, PPG, Color rating (There's a reference for grains in the last tab with this info); for hops you input type, aa% , amount (oz) and time, for utilization theres a chart I made in a separate tab that you'll see where you get utilization by entering the ranges of og and time and it does the utlization calc semi-automatically and transfers it to the recipe spread sheet and calculates ibus.
For the mash you enter your efficiency and grain temp and it calculates strike temp, pre boil volume, mash thickness, and pre boil gravity.
The yeast section is still a work in progress it already does some things but Im mostly inputing data from other software for the recipe.