Homebrewers Association | AHA Forum

General Category => All Grain Brewing => Topic started by: a10t2 on October 08, 2013, 06:21:13 PM

Title: Quick and Dirty Batch Sparging Calculator
Post by: a10t2 on October 08, 2013, 06:21:13 PM
I finally got tired of googling my own forum posts to find my formulas, so I put together a pretty basic calculator for estimating batch-sparging efficiency. It really only does one thing, but it should do it pretty well. Reality checks are always appreciated. Any feedback or requests, let me know.

http://seanterrill.com/2013/10/05/batch-sparging-calculator/
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: redbeerman on October 08, 2013, 06:37:12 PM
Cool! Thanks Sean!  I'll give it a shot this weekend.
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: denny on October 08, 2013, 07:01:16 PM
Any way to take mash efficiency into account?  You assume 100%, I'm usually around 96-98%.
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: Three on October 08, 2013, 07:08:38 PM
Very nice Sean!

Thanks!
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: a10t2 on October 08, 2013, 07:28:47 PM
Any way to take mash efficiency into account?  You assume 100%, I'm usually around 96-98%.

You could just knock a bit off the potential extract field, to 74% or so. I typically plug in 73% (~94% conversion efficiency) to give myself some wiggle room, then dilute in the kettle if I'm more than a few points off.
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: denny on October 08, 2013, 08:02:31 PM
Any way to take mash efficiency into account?  You assume 100%, I'm usually around 96-98%.

You could just knock a bit off the potential extract field, to 74% or so. I typically plug in 73% (~94% conversion efficiency) to give myself some wiggle room, then dilute in the kettle if I'm more than a few points off.

Cool.  I'll try that.
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: denny on October 08, 2013, 08:04:44 PM
Putting in my numbers from yesterday's brew, I can't get the post boil gravity from your calculator to match what mine really was. 
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: ynotbrusum on October 08, 2013, 08:23:30 PM
Nice.  I am going to have to actually measure the fluid left in the grist (not absorbed) after run off to get a reliable figure for the lauter dead space, otherwise it looks like a ready addition to the brewing arsenal.  Can't wait to give it a try!  Thanks, Sean.
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: a10t2 on October 08, 2013, 09:13:06 PM
Putting in my numbers from yesterday's brew, I can't get the post boil gravity from your calculator to match what mine really was.

That's really weird, assuming the pre-boil gravity was right. Those two numbers are just the same amount of extract divided by the two different volumes.

Do your pre- and post-boil gravity/volumes work out? SG1*V1 = SG2*V2?
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: denny on October 09, 2013, 03:40:31 PM
Putting in my numbers from yesterday's brew, I can't get the post boil gravity from your calculator to match what mine really was.

That's really weird, assuming the pre-boil gravity was right. Those two numbers are just the same amount of extract divided by the two different volumes.

Do your pre- and post-boil gravity/volumes work out? SG1*V1 = SG2*V2?

I'll check and let ya know.
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: majorvices on October 09, 2013, 11:13:20 PM
Putting in my numbers from yesterday's brew, I can't get the post boil gravity from your calculator to match what mine really was.

That's because you don't really need a batch sparging calculator.  ;D ;)
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: a10t2 on October 09, 2013, 11:41:43 PM
That's because you don't really need a batch sparging calculator.  ;D ;)

Don't you have something you should be doing in the brewery? ;)
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: a10t2 on October 10, 2013, 11:19:17 PM
I brewed a low-gravity Belgian Blonde against the calculator today. All volumes were spot-on and gravities within 0.4°P. I guess I knew that it would work for my numbers, though...
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: denny on October 11, 2013, 03:13:06 PM
I'll double check my numbers.  I also plan to brew within the next few days (hey, I'm not working for a few months, why not?) and try it again.
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: bluesman on October 11, 2013, 04:47:27 PM
I'll give it a whirl on Sunday during my brew session. :)
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: ynotbrusum on October 15, 2013, 02:23:01 AM
Just tried it out yesterday and it worked great!
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: morticaixavier on October 15, 2013, 02:35:20 PM
looks good. I'll give it a try this weekend. I did notice one thing which is it appears in the calculated area the Liter/Gallon choice isn't totally working on the First and Second runnings fields. The tag changes to L when I set it to liters but the actual volumes remain in Gallons.

Results

Pre-Boil: 48.99 L at 10.1°P (1.04) First Runnings: 6.34 L at 17.2°P (1.07)
Post-Boil: 40 L at 12.3°P (1.05) Second Runnings: 6.6 L at 4.4°P (1.017)
Boiloff: 8.99 L (18.3%)   
Lauter Efficiency: 83.4% 
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: bluesman on October 15, 2013, 04:41:34 PM
I'll double check my numbers.  I also plan to brew within the next few days (hey, I'm not working for a few months, why not?) and try it again.

What's up Denny...did you get a work furlough?

I completely forgot to try this calculator during my brewday Sunday...Sorry Sean.

I'll give it a try sooner than later.
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: denny on October 15, 2013, 05:41:45 PM
I'll double check my numbers.  I also plan to brew within the next few days (hey, I'm not working for a few months, why not?) and try it again.

What's up Denny...did you get a work furlough?

I completely forgot to try this calculator during my brewday Sunday...Sorry Sean.

I'll give it a try sooner than later.

Long story, Ron, but I'm on "paid administrative leave".  I may just retire rather than go back.

I forgot to enter my numbers, too, but I've got the info so I'll try it later.
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: a10t2 on October 15, 2013, 05:52:40 PM
The tag changes to L when I set it to liters but the actual volumes remain in Gallons.

Thanks for catching that. It should be fixed now.

Long story, Ron, but I'm on "paid administrative leave".  I may just retire rather than go back.

I dunno, Denny... paid leave sounds like just about the ideal situation to me... ;)

Hope everything works out for you.
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: morticaixavier on October 15, 2013, 08:06:46 PM
I'll double check my numbers.  I also plan to brew within the next few days (hey, I'm not working for a few months, why not?) and try it again.

What's up Denny...did you get a work furlough?

I completely forgot to try this calculator during my brewday Sunday...Sorry Sean.

I'll give it a try sooner than later.

Long story, Ron, but I'm on "paid administrative leave".  I may just retire rather than go back.

I forgot to enter my numbers, too, but I've got the info so I'll try it later.

Did you go all loose cannon and violate someone's civil rights?  Did the captain say "I hate to do this but I need your badge Denny" while shaking his head sadly?
Title: Re: Quick and Dirty Batch Sparging Calculator
Post by: denny on October 15, 2013, 08:17:21 PM
I dunno, Denny... paid leave sounds like just about the ideal situation to me... ;)

Hope everything works out for you.

It would be ideal if it was permanent!  I'll know by the end of the month if I'm going to go back to work or just call it.  Having not worked in 2 months, it's kinda hard to think about going back.