Happy HolidaySs Giveaway - Winners Re-Re-Re-Drawn - 24 hours to Claim!

Get your HBT Growlers, Shirts and Membership before the Rush!


Home Brew Forums > Home Brewing Beer > All Grain & Partial Mash Brewing > BIAB spreadsheet for MAC users.
Reply
 
LinkBack Thread Tools
Old 02-13-2012, 08:52 PM   #1
beng
Feedback Score: 0 reviews
Recipes 
 
Join Date: May 2010
Location: manhattan
Posts: 122
Liked 8 Times on 5 Posts
Likes Given: 8

Default BIAB spreadsheet for MAC users.

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

Enjoy!

-Ben

Ben_g_85@hotmail.com

__________________
beng is offline
 
Reply With Quote Quick reply to this message
Old 07-07-2012, 10:41 PM   #2
originalben
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2010
Location: Norfolk, VA
Posts: 274
Liked 4 Times on 4 Posts
Likes Given: 8

Default

Appreciated.

ben.g.rainey@gmail.com

__________________

Sometimes, I doubt your commitment to Sparkle Motion!

originalben is offline
 
Reply With Quote Quick reply to this message
Reply



Quick Reply
Message:
Options
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 09:22 PM
Help with Palmer's RA Spreadsheet BigNastyBrew All Grain & Partial Mash Brewing 2 02-09-2009 09:44 PM



Newest Threads

LATEST SPONSOR DEALS