In my infinite boredom being deployed to Afghanistan I sat at my computer for a good 10 straight hours and made a simple-to-use brewing spreadsheet. If you find any issues that need to be changed give me a heads up via email(its listed on bottom of the post), or simply reply to the thread. Anyway, here are the caveats to the spreadsheet.
It uses the tensith formula to calculate IBUs for PELLET HOPS. Check rooftop brew calculator if you don't believe me
. Adjust for whole cone if thats what you use.
The sheet assumes 1 oz PELLET HOPS soaks up 4oz water(this was a guess on my part). It also assumes 1LB of grain absorbs 16oz water, so 8 lbs grain absorbs 1 gal. And finally it assumes a half gallon lost per 20 minutes of the boil. I can adjust all of these.
This is for BIAB assuming you want 5.25 gallons of wort when the boil is COMPLETE. The extra .25 is for grub, if you are a trub dumper.
The efficiency calculator is based of an extraction yield of 35ppg for ALL GRAINS. Yes I know different grains have different yields, but I haven't got that far yet. That will take a lot more work. But for now the efficiency box should be accurate to within 2-3%
Finally, I know the sliders can be a pain, but they are much easier to create than drop down menus. Unfortunatly there is no way to make them bigger for enhanced precision.
PLEASE send me comments on how to improve/adjust the sheet, I can also adjust it to different size batches. HELP ME HELP YOU! Any excel users out there----Is this sheet compatible on your computer?
Post your email address if you want the sheet, the forum won't let me attach it