Author Topic: Quick and Dirty Batch Sparging Calculator  (Read 1940 times)

Offline a10t2

  • Official Poobah of No Life.
  • *
  • Posts: 3171
  • Ask me why I don't like Chico!
    • View Profile
    • SeanTerrill.com
Quick and Dirty Batch Sparging Calculator
« on: October 08, 2013, 11:21:13 AM »
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/
Beer is like porn. You can buy it, but it's more fun to make your own.
http://seanterrill.com/category/brewing/

Offline redbeerman

  • Senior Brewmaster
  • ******
  • Posts: 1713
  • On the banks of the mighty Susquehanna
    • View Profile
Re: Quick and Dirty Batch Sparging Calculator
« Reply #1 on: October 08, 2013, 11:37:12 AM »
Cool! Thanks Sean!  I'll give it a shot this weekend.
CH3CH2OH - Without it, life itself would be impossible.

[441, 112.1deg] AR

Jim

Offline denny

  • Administrator
  • I must live here
  • *****
  • Posts: 11696
  • Noti OR [1991.4, 287.6deg] AR
    • View Profile
    • Dennybrew
Re: Quick and Dirty Batch Sparging Calculator
« Reply #2 on: October 08, 2013, 12:01:16 PM »
Any way to take mash efficiency into account?  You assume 100%, I'm usually around 96-98%.
Life begins at 60.....1.060, that is!

www.dennybrew.com

The best, sharpest, funniest, weirdest and most knowledgable minds in home brewing contribute on the AHA forum. - Alewyfe

Offline Three

  • Assistant Brewer
  • ***
  • Posts: 138
  • Avon, IN
    • View Profile
Re: Quick and Dirty Batch Sparging Calculator
« Reply #3 on: October 08, 2013, 12:08:38 PM »
Very nice Sean!

Thanks!
Anyone who sings a tune so sweet is passin by........

Offline a10t2

  • Official Poobah of No Life.
  • *
  • Posts: 3171
  • Ask me why I don't like Chico!
    • View Profile
    • SeanTerrill.com
Re: Quick and Dirty Batch Sparging Calculator
« Reply #4 on: October 08, 2013, 12: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.
« Last Edit: October 08, 2013, 12:30:58 PM by a10t2 »
Beer is like porn. You can buy it, but it's more fun to make your own.
http://seanterrill.com/category/brewing/

Offline denny

  • Administrator
  • I must live here
  • *****
  • Posts: 11696
  • Noti OR [1991.4, 287.6deg] AR
    • View Profile
    • Dennybrew
Re: Quick and Dirty Batch Sparging Calculator
« Reply #5 on: October 08, 2013, 01: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.
Life begins at 60.....1.060, that is!

www.dennybrew.com

The best, sharpest, funniest, weirdest and most knowledgable minds in home brewing contribute on the AHA forum. - Alewyfe

Offline denny

  • Administrator
  • I must live here
  • *****
  • Posts: 11696
  • Noti OR [1991.4, 287.6deg] AR
    • View Profile
    • Dennybrew
Re: Quick and Dirty Batch Sparging Calculator
« Reply #6 on: October 08, 2013, 01: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. 
Life begins at 60.....1.060, that is!

www.dennybrew.com

The best, sharpest, funniest, weirdest and most knowledgable minds in home brewing contribute on the AHA forum. - Alewyfe

Offline ynotbrusum

  • Senior Brewmaster
  • ******
  • Posts: 1004
  • Da mihi sis cerevisiam.
    • View Profile
Re: Quick and Dirty Batch Sparging Calculator
« Reply #7 on: October 08, 2013, 01: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.
Hodge Garage Brewing: "Brew with a glad heart!"

Offline a10t2

  • Official Poobah of No Life.
  • *
  • Posts: 3171
  • Ask me why I don't like Chico!
    • View Profile
    • SeanTerrill.com
Re: Quick and Dirty Batch Sparging Calculator
« Reply #8 on: October 08, 2013, 02: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?
Beer is like porn. You can buy it, but it's more fun to make your own.
http://seanterrill.com/category/brewing/

Offline denny

  • Administrator
  • I must live here
  • *****
  • Posts: 11696
  • Noti OR [1991.4, 287.6deg] AR
    • View Profile
    • Dennybrew
Re: Quick and Dirty Batch Sparging Calculator
« Reply #9 on: October 09, 2013, 08:40:31 AM »
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.
Life begins at 60.....1.060, that is!

www.dennybrew.com

The best, sharpest, funniest, weirdest and most knowledgable minds in home brewing contribute on the AHA forum. - Alewyfe

Offline majorvices

  • Global Moderator
  • Official Poobah of No Life.
  • *****
  • Posts: 6311
  • Polka. If its too loud you're too young.
    • View Profile
    • Yellowhammer Brewing Company
Re: Quick and Dirty Batch Sparging Calculator
« Reply #10 on: October 09, 2013, 04: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 ;)
Keith Y.
Self appointed "All Grain" section pruner

Offline a10t2

  • Official Poobah of No Life.
  • *
  • Posts: 3171
  • Ask me why I don't like Chico!
    • View Profile
    • SeanTerrill.com
Re: Quick and Dirty Batch Sparging Calculator
« Reply #11 on: October 09, 2013, 04: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? ;)
Beer is like porn. You can buy it, but it's more fun to make your own.
http://seanterrill.com/category/brewing/

Offline a10t2

  • Official Poobah of No Life.
  • *
  • Posts: 3171
  • Ask me why I don't like Chico!
    • View Profile
    • SeanTerrill.com
Re: Quick and Dirty Batch Sparging Calculator
« Reply #12 on: October 10, 2013, 04: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...
Beer is like porn. You can buy it, but it's more fun to make your own.
http://seanterrill.com/category/brewing/

Offline denny

  • Administrator
  • I must live here
  • *****
  • Posts: 11696
  • Noti OR [1991.4, 287.6deg] AR
    • View Profile
    • Dennybrew
Re: Quick and Dirty Batch Sparging Calculator
« Reply #13 on: October 11, 2013, 08:13:06 AM »
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.
Life begins at 60.....1.060, that is!

www.dennybrew.com

The best, sharpest, funniest, weirdest and most knowledgable minds in home brewing contribute on the AHA forum. - Alewyfe

Offline bluesman

  • Global Moderator
  • I must live here
  • *****
  • Posts: 8687
  • Delaware
    • View Profile
Re: Quick and Dirty Batch Sparging Calculator
« Reply #14 on: October 11, 2013, 09:47:27 AM »
I'll give it a whirl on Sunday during my brew session. :)
Ron Price