IPB

Welcome Guest ( Log In | Register )

6 Pages V   1 2 3 > »   
Reply to this topicStart new topic
> Mead/Melomel Calculator Spreadsheet, and log/graph tool
jjarmoc
post Aug 19 2005, 05:46 PM
Post #1


Brewer
****

Group: Members
Posts: 462
Joined: 23-December 03
From: Hanover Park, IL (Chicago suburbs)
Member No.: 1,493



I put together a spreadsheet with a few handy mead-related functions, and thought I'd post it for anyone else who might find it useful.

There's three tabs.

- Calculator
This tab has a few calculator tools. In each, the green cells are input fields, the rest will be calculated automatically.
* The OG Calculator can help figure out the OG. There's room for 4 ingredients, so it can be used for cysers and braggots in addition to straight meads.
* The Brix to SG convertor is self explanatory..
* Staggered Nutrients Add point calculator is designed to give the proper SG levels for each nutrient, according to Hightest's staggered nutrient system given an OG and Target FG.

The Staggered Nutrient calculator may not be working completely right. The 2nd addition looks to give the right numbers, but I'm not sure about the first. The faq says it should be done when the gravity drops 'between 2-3 brix.' I used .004 SG for each brix, so it just subtracts .008 and .012 to generate the two numbers. These seem different than example values Hightest has provided though, so there may be something wrong here I'm hoping someone can help correct.

- Log
The log tab is for recording dates and gravity readings. It also has a notes column

- Fermentation rate chart
Using the data on the log tab, this tab generates a chart showing the rate of fermentation over time.

Anyhow, I hope someone finds this useful. If anyone has any addition or enhancement ideas, I'd be anxious to hear about them.

EDIT BY Matt the Mead Maker:
I've made some pretty significant additions to jjarmoc's excellent spreadsheet. It now does a variety of computations associated with fruit additions and creating melomels. Enjoy!

Spreadsheet
Go to the top of the page
 
+Quote Post
Hop Mania
post Aug 19 2005, 10:14 PM
Post #2


Brewmaster
*****

Group: Members
Posts: 675
Joined: 25-August 04
From: Haverhill, MA
Member No.: 2,590



sweet. I'll have to try it out on my next mead.
Go to the top of the page
 
+Quote Post
HighTest
post Aug 20 2005, 07:32 AM
Post #3


Brewmaster
*****

Group: Members
Posts: 3,962
Joined: 22-March 02
Member No.: 589



Nice spreadsheet. Yestereday I wanted to attach an edited version of my personal Excel calculations, but there was a problem with the board allowing .XLS files. Now that has been corrected. So here's my Basic Honey OG & NAS add point speadsheet for comparsion. Enjoy (IMG:style_emoticons/brewboard/smile.gif) 11/06/05 Spreadsheet revised.
Go to the top of the page
 
+Quote Post
Hop Mania
post Aug 20 2005, 10:29 AM
Post #4


Brewmaster
*****

Group: Members
Posts: 675
Joined: 25-August 04
From: Haverhill, MA
Member No.: 2,590



It's the battle of the spreadsheets!!
Go to the top of the page
 
+Quote Post
JoeFleischman
post Aug 24 2005, 12:19 PM
Post #5


Assistant Brewer
***

Group: Members
Posts: 65
Joined: 10-May 05
From: Tampa, Fl
Member No.: 3,829



Man, that's fantastic! Thanks for taking the time(both of you) for providing the Excel downloads. Excel freakin' kills me. (IMG:style_emoticons/brewboard/tongue.gif)
Go to the top of the page
 
+Quote Post
ze'ev
post Aug 24 2005, 01:46 PM
Post #6


Homebrewer
**

Group: Members
Posts: 47
Joined: 26-July 05
Member No.: 4,113



Wow! Thanks! I was just struggling through the calculations to figure out how to make a medium mead with Eau de Vie yeast (21% tollerance) and that was a huge help!

Question: is there a way I can calculate how fruit sugars will change my gravity as well?

This post has been edited by ze'ev: Aug 24 2005, 01:47 PM
Go to the top of the page
 
+Quote Post
HighTest
post Aug 24 2005, 02:08 PM
Post #7


Brewmaster
*****

Group: Members
Posts: 3,962
Joined: 22-March 02
Member No.: 589



QUOTE(ze'ev @ Aug 24 2005, 02:47 PM)
...is there a way I can calculate how fruit sugars will change my gravity as well?
Yes, you need to get a copy (or do a web search) for BYO magazine V8N4 (Jul-Aug 2002), pg 48. There's an article there that can be adpated to using fruit in beverages other than beer... (IMG:style_emoticons/brewboard/wink.gif)
Go to the top of the page
 
+Quote Post
JrKegBuster
post Aug 30 2005, 08:17 AM
Post #8


Homebrewer
**

Group: Members
Posts: 25
Joined: 6-August 04
From: west of charolette NC
Member No.: 2,515



I must say that both of those are extremely helpful.
i like the break down of the fg for dry sweet and such thats
a huge help thank you both for the tool.
Go to the top of the page
 
+Quote Post
HighTest
post Aug 30 2005, 08:21 AM
Post #9


Brewmaster
*****

Group: Members
Posts: 3,962
Joined: 22-March 02
Member No.: 589



You're welcome... (IMG:style_emoticons/brewboard/smile.gif)
Go to the top of the page
 
+Quote Post
ze'ev
post Sep 6 2005, 12:01 PM
Post #10


Homebrewer
**

Group: Members
Posts: 47
Joined: 26-July 05
Member No.: 4,113



this has become such a consistant tool for me, maybe it should get pinned so it doesnt get lost on the board.
Go to the top of the page
 
+Quote Post
HighTest
post Sep 6 2005, 12:48 PM
Post #11


Brewmaster
*****

Group: Members
Posts: 3,962
Joined: 22-March 02
Member No.: 589



Done... (IMG:style_emoticons/brewboard/smile.gif)
Go to the top of the page
 
+Quote Post
jjarmoc
post Sep 6 2005, 02:01 PM
Post #12


Brewer
****

Group: Members
Posts: 462
Joined: 23-December 03
From: Hanover Park, IL (Chicago suburbs)
Member No.: 1,493



FYI -
I updated my spreadsheet after it was pointed out in another thread that the brix to SG formula may not have been very accurate at the high gravities that are common in Meads and Ciders.

I scoured the net looking for the 'best' formula I could find, but there are so many out there it's really difficult to tell which is most accurate. So, in the new sheet I've included four different formulas and noted the sources of each. In most cases they only vary a small degree, but I'll leave it up to everyone to decide which formula/source they're most comfortable with.

The link in my original post now points to the updated version of the sheet. It also has some 'sample' data from my current batch of mead which shows how the log and chart will look with actual data in them.
Go to the top of the page
 
+Quote Post
Matt the Mead Ma...
post Sep 15 2005, 03:50 PM
Post #13


Brewmaster
*****

Group: Members
Posts: 45,736
Joined: 2-May 04
From: Pendleton, OR
Member No.: 2,119



In about a week I'll be making a cider that will have a few pounds of muscovado sugar in it. I'd like to estimate the gravity in advance so that I don't have too high/low of a final gravity. Will any of these calculators help?

I don't have excel on this pc, so I can't find out right now.

If the calculators can't do it, does anyone have any tips for me? Thanks!!
Go to the top of the page
 
+Quote Post
jjarmoc
post Sep 15 2005, 04:23 PM
Post #14


Brewer
****

Group: Members
Posts: 462
Joined: 23-December 03
From: Hanover Park, IL (Chicago suburbs)
Member No.: 1,493



QUOTE(Matt the Mead Maker @ Sep 15 2005, 03:51 PM)
In about a week I'll be making a cider that will have a few pounds of muscovado sugar in it.  I'd like to estimate the gravity in advance so that I don't have too high/low of a final gravity.  Will any of these calculators help? 

I don't have excel on this pc, so I can't find out right now.

If the calculators can't do it, does anyone have any tips for me?  Thanks!!
*


Either of them should work, if you can find info on how much gravity muscavado will contribute per pound.. that'll be the hard part.

On my sheet, you can just add muscavado in place of one of the ingredients on the left side, with it's gravity contibution just to the right and fill in the quantities..
Go to the top of the page
 
+Quote Post
Braindead
post Sep 15 2005, 04:59 PM
Post #15


Brewmaster
*****

Group: Members
Posts: 1,611
Joined: 5-December 04
From: Lancaster, PA
Member No.: 3,116



QUOTE(Matt the Mead Maker @ Sep 15 2005, 04:51 PM)
In about a week I'll be making a cider that will have a few pounds of muscovado sugar in it.  I'd like to estimate the gravity in advance so that I don't have too high/low of a final gravity.  Will any of these calculators help? 

I don't have excel on this pc, so I can't find out right now.

If the calculators can't do it, does anyone have any tips for me?  Thanks!!
*

Matt, Found this info, second post. Muscovado Sugar
It's some really good stuff. I use it in my steel cut oats. Yummy

This post has been edited by Braindead: Sep 15 2005, 05:00 PM
Go to the top of the page
 
+Quote Post

6 Pages V   1 2 3 > » 
Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 22nd October 2018 - 08:43 PM