BIAB spreadsheet for MAC users. - Home Brew Forums
Register Now For Free!

Home Brew Forums > Home Brewing Beer > All Grain & Partial Mash Brewing > BIAB spreadsheet for MAC users.

Thread Tools
Old 02-13-2012, 08:52 PM   #1
May 2010
Posts: 135
Liked 16 Times on 8 Posts

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



Reply With Quote
Old 07-07-2012, 09:41 PM   #2
originalben's Avatar
Mar 2010
Norfolk, VA
Posts: 208
Liked 4 Times on 4 Posts

Sometimes, I doubt your commitment to Sparkle Motion!

Reply With Quote
Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
A nice Podcast on BIAB from one of the Pioneers of BIAB gunner65 All Grain & Partial Mash Brewing 0 02-26-2011 01:24 AM
Yet Another Brewing Spreadsheet Walker All Grain & Partial Mash Brewing 19 12-12-2009 01:31 AM
Efficiency analysis spreadsheet Kaiser All Grain & Partial Mash Brewing 52 11-04-2009 09:29 PM
AG spreadsheet? Does it exist? perkins98 All Grain & Partial Mash Brewing 7 03-31-2009 08:22 PM
Help with Palmer's RA Spreadsheet BigNastyBrew All Grain & Partial Mash Brewing 2 02-09-2009 09:44 PM

Forum Jump