Spike Brewing 12.5 Conical Fermenter Giveaway - Enter Now!

Home Brew Forums > Home Brewing Beer > Brew Science > Speise Calculator

Reply
 
LinkBack Thread Tools
Old 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

Default 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?title=Accurately_Calculating_Sugar_Addit ions_for_Carbonation#Speise

speise-calculator-formulae.jpg   speise-calculator-numerical.jpg  
__________________
Pommy is offline
 
Reply With Quote Quick reply to this message
Old 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

Default

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

speise-calculator-formulae.jpg  
__________________
Pommy is offline
 
Reply With Quote Quick reply to this message
Old 09-23-2012, 08:14 AM   #3
GilSwillBasementBrews
HBT_SUPPORTER.png
Feedback Score: 1 reviews
 
GilSwillBasementBrews's Avatar
Recipes 
 
Join Date: Jul 2012
Location: Eagleville, Pennsylvania
Posts: 1,992
Liked 131 Times on 113 Posts
Likes Given: 19

Default

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

GilSwillBasementBrews is offline
 
Reply With Quote Quick reply to this message
Old 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

Default

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?

__________________
Pommy is offline
 
Reply With Quote Quick reply to this message
Old 09-23-2012, 11:50 AM   #5
TNGabe
Feedback Score: 16 reviews
Recipes 
 
Join Date: Aug 2012
Posts: 6,450
Liked 2156 Times on 1459 Posts
Likes Given: 2128

Default

Quote:
Originally Posted by GilSwillBasementBrews View Post
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!
__________________
TNGabe is offline
 
Reply With Quote Quick reply to this message
Old 09-23-2012, 08:01 PM   #6
GilSwillBasementBrews
HBT_SUPPORTER.png
Feedback Score: 1 reviews
 
GilSwillBasementBrews's Avatar
Recipes 
 
Join Date: Jul 2012
Location: Eagleville, Pennsylvania
Posts: 1,992
Liked 131 Times on 113 Posts
Likes Given: 19

Default

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

GilSwillBasementBrews is offline
 
Reply With Quote Quick reply to this message
Old 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

Default

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

__________________
Pommy is offline
 
Reply With Quote Quick reply to this message
Old 09-23-2012, 10:44 PM   #8
GilSwillBasementBrews
HBT_SUPPORTER.png
Feedback Score: 1 reviews
 
GilSwillBasementBrews's Avatar
Recipes 
 
Join Date: Jul 2012
Location: Eagleville, Pennsylvania
Posts: 1,992
Liked 131 Times on 113 Posts
Likes Given: 19

Default

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

__________________

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

GilSwillBasementBrews is offline
 
Reply With Quote Quick reply to this message
Old 09-24-2012, 12:29 AM   #9
Kaiser
Feedback Score: 0 reviews
 
Kaiser's Avatar
Recipes 
 
Join Date: Nov 2005
Location: Pepperell, MA
Posts: 3,904
Liked 114 Times on 71 Posts
Likes Given: 4

Default

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
Kaiser is offline
 
Reply With Quote Quick reply to this message
Old 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

Default

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.

__________________
Pommy 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
EZ Water Calculator 2.0 -TH- Brew Science 159 03-21-2014 01:57 PM
EZ Water Calculator 3.0 -TH- Brew Science 386 03-15-2014 07:27 PM
Water Calculator: Does it look right? Jewrican Brew Science 21 12-29-2011 11:20 PM
iPhone ABV calculator bheliker Brew Science 3 11-24-2011 04:48 PM
Ibu Calculator Additions fromhereon Brew Science 1 04-30-2011 08:32 PM