Toggle sidebar

Mead calculator - courtesy of JamesP

  • PATRONS: Did you know we've a chat function for you now? Look to the bottom of the screen, you can chat, set up rooms, talk to each other individually or in groups! Click 'Chat' at the right side of the chat window to open the chat up.
  • Love Gotmead and want to see it grow? Then consider supporting the site and becoming a Patron! If you're logged in, click on your username to the right of the menu to see how as little as $30/year can get you access to the patron areas and the patron Facebook group and to support Gotmead!
  • We now have a Patron-exclusive Facebook group! Patrons my join at The Gotmead Patron Group. You MUST answer the questions, providing your Patron membership, when you request to join so I can verify your Patron membership. If the questions aren't answered, the request will be turned down.
Barrel Char Wood Products
JamesP,

I've attatched the Excel Sheet so that you can check it out for the formulas and stuff. I hope it helps. My spreadsheet doesn't take into account the temperature difference between the temperature that I measured the S.G. at and the temperature that it is supposed to be measured at. If its possible, can you help me out with that?

Thanks and I hope I can help,

Evan

[attachment deleted by admin]
 
My source for SG temperature corrections is as follows (it is for 95F, which may be different to the calibration temperature of some hydrometers)

From http://www.brewery.org/brewery/library/HydromCorr0992.html

Posted to HBD #963, 9/7/92, by Christopher Lyons Following up on the specific gravity of water as a function of temperature.... The earlier equation was based on data for 50F-to-105F. Since the equation was from a polynomial fit, it should not be trusted for predicting SG outside this temperature range.

The data below was obtained using the "Handbook of Chemistry and Physics (CRC)", and is valid for a temperature range between 0 and 212F.


Temp (C) Temp (F) Density Correction relative to 59F
------- -------- ------- --------------------------
0 32 0.99987 -0.74
3.98 39.16 1.00000 -0.87
5 41 0.99999 -0.86
10 50 0.99973 -0.6
15 59 0.99913 0
18 64.4 0.99862 0.51
20 68 0.99823 0.9
25 77 0.99707 2.06
30 86 0.99567 3.46
35 95 0.99406 5.07
38 100.4 0.99299 6.14
40 104 0.99224 6.89
45 113 0.99025 8.88
50 122 0.98807 11.06
55 131 0.98573 13.4
60 140 0.98324 15.89
65 149 0.98059 18.54
70 158 0.97781 21.32
75 167 0.97489 24.24
80 176 0.97183 27.3
85 185 0.96865 30.48
90 194 0.96534 33.79
95 203 0.96192 37.21
100 212 0.95838 40.75


The correction term was computed relative to 15C (59F). It may be easily calculated
relative to any temperature. A third order polynomial fit to this data was also very good (R**2 = 0.999969):


Correction(@59F) =
1.313454 - 0.132674*T + 2.057793e-3*T**2 - 2.627634e-6*T**3

where T is in degrees F.


This equation should be good for the entire temperature range of interest
Click to expand...
 
Cool. Thanks a lot man. Just to clear things up though, if the temperature of the liquid that I am measuring is say 77 F, than you would actually only add .00206 to S.G., right? So if it was measured to be 1.091, then it would actually be 1.091+.00206= 1.093.

So, I was just thinking that if you assume that you measured the s.g. at the same temperatures in the beginning of the fermentation and then end, then when you go to calculate the % alcohol by volume than the correction shouldn't really matter because it will cancel out when you take the differences of he S.G.. However, if the measuring temperatures differ by more than 5 degrees F then the factor will matter.
 
Yep, that's my understanding - measure OG & FG at the same temperature.

Usually measure at room temperature, or convert to room temperature if the must is warm/cold.
 
Thanks for all your help James. I updated and attached the spread sheet to take the temperature of the liquid into account.

[attachment deleted by admin]
 
Hi all,
I came to depend on the mead calculator in planning my batches but now I find myself at a loss. Persimmons are not in the calculator! I found a nutritional page that has persimmons sugar content at 12.53 grams/ 100 grams of fruit.
Any ideas on how to use this data in the calculator?

Thanks,
Ted
 
Pick any fruit, and set the sugar content to 12.53 (%)

It is the value in the sugar content field that is used for the calculation.
 
Thank you James,
I wasn't aware that the % sugar field was modiefiable. As it turns out, the calculator came up with the same numbers I had after calculating it *the hard way*.

Thanks again,
Ted
 
Hey Sander, It would be easy as pie...

If the link lead to something other then a blank page!

Dmntd
 
Looks like this may be related to the additional security layered in for the Patrons Section. We'll get 'er fixed up wiki wiki!

Cheers,

Oskaar
 
Aroo? Not being seen? I can see it as admin, and also not logged in.

Patrons, are you getting a blank page going to the calculator?
 
Works great for me. Running it on IE 6.0.2900 SP2. View of the forum is fine as well, fitting perfectly.

Angus
 
Dmntd said:
Very odd.

It came up this time, but when I started to enter data into one of the fields, got "Document contains no data". Before it wasn't there at all.
Click to expand...

This worked fine last week.

Using the link from this thread, I get "There are no items to display"

It is loading today from the menu bar on the left.

Tony
 
MUAHAHAHAHA...you haf discover my Master Plan to drive Tony nuts!

I follow you around the site, and when I see you going for the Calculator, I switch it off!

Vicky - cackling madly...
 
I don't care what you do. I'll never go back to Windoz!

A friend once said, "You're so twisted, when you die they'll have to screw your corps into the ground"

Dmntd
 
I just posted up a sticky message in this forum containing a link to a temporary version of the mead calculator.

Click here to give it a try.

Oskaar
 
You must log in or register to reply here.
Barrel Char Wood Products

Viking Brew Vessels - Authentic Drinking Horns

Top Bottom