HBT 2015 Big Giveaway - Enter Now

Huge Supporting Membership Discounts - 20% Off

 Home Brew Forums > Speise Calculator
09-23-2012, 06:51 AM   #1
Pommy
Feedback Score: 0 reviews
Recipes

Join Date: May 2009
Location: Auckland, NZ
Posts: 727
Liked 11 Times on 10 Posts
Likes Given: 6

 Speise Calculator

A nice easy one for the members who are clearly far more intelligent than I. I was trying to put together a speise calculator but after tying myself up in circles and making things worse I thought Id get some advice from the scientists amongst us, algebra never was my strong point

I have attached a pic of the formulae as well as one using numerical data if you can look for what I have got wrong. I was working from Braukaiser's info here: http://braukaiser.com/wiki/index.php...onation#Speise

__________________

09-23-2012, 06:58 AM   #2
Pommy
Feedback Score: 0 reviews
Recipes

Join Date: May 2009
Location: Auckland, NZ
Posts: 727
Liked 11 Times on 10 Posts
Likes Given: 6

This one might be a bit easier to follow (took a screenshot to show the references)

__________________

09-23-2012, 08:14 AM   #3
GilSwillBasementBrews
Feedback Score: 1 reviews
Recipes

Join Date: Jul 2012
Location: Eagleville, Pennsylvania
Posts: 2,167
Liked 168 Times on 138 Posts
Likes Given: 27

Speise reserved for priming = 12 x gallons / ending numbers of OG before yeast pitched

This was the formula I came across when I was searching for a simple equation to figure it out.
Used it a couple times with no issues.

__________________

Beer Plus Science = .....Good!!!!! By: Adam Savage

09-23-2012, 09:13 AM   #4
Pommy
Feedback Score: 0 reviews
Recipes

Join Date: May 2009
Location: Auckland, NZ
Posts: 727
Liked 11 Times on 10 Posts
Likes Given: 6

Thanks for that Gil, I am putting together another spreadsheet at the minute using my own calculations so that it makes a bit more sense to me than following others, just how my brain works I'll use that as my guide then try to build off of it. Once I get that sorted I can add formula for temp corrections etc. Where does the 12 come in? Just an approximate for converting across measures?

__________________

09-23-2012, 11:50 AM   #5
TNGabe
Feedback Score: 17 reviews
Recipes

Join Date: Aug 2012
Posts: 6,611
Liked 2235 Times on 1510 Posts
Likes Given: 2302

Quote:
 Originally Posted by GilSwillBasementBrews Speise reserved for priming = 12 x gallons / ending numbers of OG before yeast pitched This was the formula I came across when I was searching for a simple equation to figure it out. Used it a couple times with no issues.
What do you mean by ending numbers of OG? Last two digits? Of the OG of wort?

There is a diiferent formula in 'Brewing with Wheat' with a few more inputs. I've destroyed the math brain cells over the years and like the simpler option!
__________________

09-23-2012, 08:01 PM   #6
GilSwillBasementBrews
Feedback Score: 1 reviews
Recipes

Join Date: Jul 2012
Location: Eagleville, Pennsylvania
Posts: 2,167
Liked 168 Times on 138 Posts
Likes Given: 27

I'd your OG is 1.054 you would use 54. So it would be

12 x (5/54) =spiese

12x(0.09259259) = spiese
1.111 gallons of spiese needed
Edit*. ^
Quarts not gallons

__________________

Beer Plus Science = .....Good!!!!! By: Adam Savage

09-23-2012, 08:46 PM   #7
Pommy
Feedback Score: 0 reviews
Recipes

Join Date: May 2009
Location: Auckland, NZ
Posts: 727
Liked 11 Times on 10 Posts
Likes Given: 6

1.111 gallons sounds like a lot? would it be quarts?

__________________

09-23-2012, 10:44 PM   #8
GilSwillBasementBrews
Feedback Score: 1 reviews
Recipes

Join Date: Jul 2012
Location: Eagleville, Pennsylvania
Posts: 2,167
Liked 168 Times on 138 Posts
Likes Given: 27

Yeah sorry my bad. Qt. not gallons. That would be a considerable amount.

__________________

Beer Plus Science = .....Good!!!!! By: Adam Savage

09-24-2012, 12:29 AM   #9
Kaiser
Feedback Score: 0 reviews

Recipes

Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 117 Times on 72 Posts
Likes Given: 4

Pommy,

Thanks for using my formulas. I haven't looked at them in a long time and I hope I got them right

The math is not all that complicated, but there's a lot to keep track of. As you may have noticed, I like working in metric units with Plato. This makes calculating the amount of sugar a bit easier. It's easy enough to convert from metric back to US units.

Apparently I did not get the formulae completely right.

I found an issue with the formula for AA (apparent attenuation) it should be

AA = 100 - 100 * FE/OE = 100*(OE-FE)/OE

It seems that you already corrected that.

I found another problem: In E9 you actually want to use the specific gravity (sg) of the wort and the original extract (OE) in Plato. You also need to divide by 100 to get the extract content in g. The specific gravity is needed to convert the wort volume into wort weight. I clarified this a bit in my article by referring to lower case sg. This will get you closer to the 240g extract that should be in the 2 L. Plato is the % extract in a given wort. I.e if you have 2l, which is approximately 2000g, then 12% of that is 240g.

I think that should be it.

Kai

__________________
BrauKaiser.com - brewing science blog - Twitter - water and mash chemistry calculator

09-29-2012, 09:54 PM   #10
Pommy
Feedback Score: 0 reviews
Recipes

Join Date: May 2009
Location: Auckland, NZ
Posts: 727
Liked 11 Times on 10 Posts
Likes Given: 6

Thanks for the input Kai, always great to have a read through some of your work. Does anyone have a calculation for approximate co2 remaining in a fermented wort based on temperature? It doesn't need to be exact as there are too many variables, a simlified equation would be perfect. As long as I get reasonably accurate and more importantly consistent results from the spreadsheet I will be very happy. I'm thinking that I will probably change my whole priming method to using speise if it works well.

__________________