IPB

Welcome Guest ( Log In | Register )

> 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

Posts in this topic
jjarmoc   Mead/Melomel Calculator Spreadsheet   Aug 19 2005, 05:46 PM
Hop Mania   sweet. I'll have to try it out on my next mea...   Aug 19 2005, 10:14 PM
HighTest   Nice spreadsheet. Yestereday I wanted to attach a...   Aug 20 2005, 07:32 AM
Hop Mania   It's the battle of the spreadsheets!!   Aug 20 2005, 10:29 AM
JoeFleischman   Man, that's fantastic! Thanks for taking ...   Aug 24 2005, 12:19 PM
ze'ev   Wow! Thanks! I was just struggling throug...   Aug 24 2005, 01:46 PM
HighTest   QUOTE(ze'ev @ Aug 24 2005, 02:47 PM)...is...   Aug 24 2005, 02:08 PM
JrKegBuster   I must say that both of those are extremely helpfu...   Aug 30 2005, 08:17 AM
HighTest   You're welcome...   Aug 30 2005, 08:21 AM
ze'ev   this has become such a consistant tool for me, may...   Sep 6 2005, 12:01 PM
HighTest   Done...   Sep 6 2005, 12:48 PM
jjarmoc   FYI - I updated my spreadsheet after it was p...   Sep 6 2005, 02:01 PM
Matt the Mead Maker   In about a week I'll be making a cider that wi...   Sep 15 2005, 03:50 PM
jjarmoc   QUOTE(Matt the Mead Maker @ Sep 15 2005, 03:5...   Sep 15 2005, 04:23 PM
Braindead   QUOTE(Matt the Mead Maker @ Sep 15 2005, 04:5...   Sep 15 2005, 04:59 PM
Matt the Mead Maker   QUOTE(Braindead @ Sep 15 2005, 05:00 PM)Matt,...   Sep 15 2005, 07:40 PM
Braindead   QUOTE(Matt the Mead Maker @ Sep 15 2005, 08:4...   Sep 15 2005, 07:54 PM
CooManChu   Very cool! Thanks alot.   Apr 4 2006, 11:23 AM
HighTest   Although I have never bought (or used) this type o...   Sep 16 2005, 06:09 AM
Thomas   HighTest, I made a calculator to go with the Mead ...   Oct 8 2005, 10:53 AM
HighTest   Thomas, I moved your calculator post to this threa...   Oct 8 2005, 11:12 AM
Thomas   Well I made it as both an excercise and because I ...   Oct 9 2005, 10:20 AM
HighTest   QUOTE(Thomas @ Oct 9 2005, 11:21 AM)Well I ma...   Oct 9 2005, 11:34 AM
HighTest   My Basic Honey OG & NAS add point speadsheet h...   Nov 6 2005, 10:42 AM
jjarmoc   Did this get unpinned as a result of the recent ha...   May 23 2006, 05:22 PM
knightlord9   QUOTE(jjarmoc @ May 23 2006, 03:22 PM) Di...   May 23 2006, 05:29 PM
ze'ev   QUOTE(knightlord9 @ May 23 2006, 05:29 PM...   Jun 14 2006, 05:18 PM
JonnyP   Very nice, thanks for the effort guys, I will put ...   Jun 5 2006, 03:22 PM
ScottS   Re-pinned.   Jun 15 2006, 07:43 AM
MtnBrewer   I noticed the other day there is a bug in this spr...   Dec 2 2006, 11:28 AM
Matt the Mead Maker   QUOTE(MtnBrewer @ Dec 2 2006, 11:28 AM) I...   Dec 2 2006, 12:26 PM
MtnBrewer   You're right, it is H3, not H4. I'll edit ...   Dec 2 2006, 02:14 PM
Matt the Mead Maker   I've put together a beta version of a spreadsh...   Jan 18 2007, 03:00 PM
armagh   One question: What is the basis for the assumption...   Jan 18 2007, 03:24 PM
Matt the Mead Maker   QUOTE(armagh @ Jan 18 2007, 03:24 PM) One...   Jan 18 2007, 04:39 PM
hiddendragonet   Excellent! That's a great idea, Matt. I ...   Jan 18 2007, 03:38 PM
Matt the Mead Maker   QUOTE(hiddendragonet @ Jan 18 2007, 03:38...   Jan 18 2007, 04:52 PM
hiddendragonet   QUOTE(Matt the Mead Maker @ Jan 18 2007, 03...   Jan 18 2007, 05:02 PM
Matt the Mead Maker   QUOTE(hiddendragonet @ Jan 18 2007, 05:02...   Jan 18 2007, 05:23 PM
hiddendragonet   Ahhh, love it! It would be reasonably easy to...   Jan 18 2007, 05:31 PM
armagh   As you seem to be alluding, water content will be ...   Jan 19 2007, 08:11 AM
MtnBrewer   Great job, Matt! One comment: this spreadshee...   Jan 19 2007, 03:33 PM
Matt the Mead Maker   Good catch, MtnBrewer! I've updated the s...   Jan 19 2007, 04:08 PM
Matt the Mead Maker   I've put together a new version of the spreads...   Feb 7 2007, 12:19 AM
jjarmoc   QUOTE(Matt the Mead Maker @ Feb 7 2007, 01...   Apr 9 2007, 06:24 PM
MtnBrewer   QUOTE(jjarmoc @ Apr 9 2007, 05:24 PM) Any...   Apr 9 2007, 07:22 PM
Matt the Mead Maker   QUOTE(jjarmoc @ Apr 9 2007, 06:24 PM) Awe...   Apr 10 2007, 09:08 PM
Matt the Mead Maker   There was a problem with the formula used for calc...   Apr 27 2007, 04:38 PM
MtnBrewer   QUOTE(Matt the Mead Maker @ Apr 27 2007, 03...   Apr 27 2007, 04:45 PM
Matt the Mead Maker   QUOTE(MtnBrewer @ Apr 27 2007, 04:45 PM) ...   Apr 27 2007, 05:08 PM
MtnBrewer   QUOTE(Matt the Mead Maker @ Apr 27 2007, 04...   Apr 27 2007, 05:18 PM
Matt the Mead Maker   QUOTE(MtnBrewer @ Apr 27 2007, 05:18 PM) ...   Apr 27 2007, 05:27 PM
MtnBrewer   Cool! Would you mind if I sent you some format...   Apr 27 2007, 05:31 PM
Matt the Mead Maker   That sounds great. There's certainly room for...   Apr 27 2007, 05:40 PM
MtnBrewer   I added a couple of new features to the spreadshee...   May 27 2007, 01:56 PM
mohoghead   Is there any other way to download this without mi...   Oct 19 2007, 03:19 PM
Matt the Mead Maker   QUOTE(mohoghead @ Oct 19 2007, 03:19 PM) ...   Oct 19 2007, 04:12 PM
mohoghead   [Itried that and it won't open without microso...   Oct 19 2007, 08:23 PM
friedrich   Actually, it can be opened by other programs once ...   Oct 20 2007, 06:20 AM
MtnBrewer   QUOTE(mohoghead @ Oct 19 2007, 07:23 PM) ...   Oct 20 2007, 10:41 AM
mohoghead   QUOTE(MtnBrewer @ Oct 20 2007, 10:41 AM) ...   Apr 4 2008, 03:25 PM
Matt the Mead Maker   Great job, MtnBrewer! Thanks for the updates...   May 29 2007, 12:42 PM
Sandman   I have been trying to follow all of the conversati...   Jan 29 2008, 07:32 PM
Sandman   QUOTE(Sandman @ Jan 29 2008, 07:32 PM) I ...   Jan 29 2008, 07:55 PM
MtnBrewer   QUOTE(Sandman @ Jan 29 2008, 06:32 PM) I ...   Feb 5 2008, 12:00 PM
MtnBrewer   Good deal, mogo. If you have any questions about t...   Apr 4 2008, 04:56 PM
Mookie   So, I'm trying to follow all this and see if I...   Sep 10 2008, 02:12 PM
MtnBrewer   I think the one on the front page is up to date. I...   Sep 10 2008, 02:24 PM
psolio   QUOTE(Matt the Mead Maker @ Jan 18 2007, 04...   Sep 21 2008, 11:51 AM
MicCullen   QUOTE(psolio @ Sep 21 2008, 09:51 AM) I...   Sep 21 2008, 12:39 PM
Matt the Mead Maker   QUOTE(psolio @ Sep 21 2008, 11:51 AM) I...   Sep 26 2008, 05:29 PM
psolio   QUOTE(Matt the Mead Maker @ Sep 26 2008, 04...   Sep 26 2008, 06:17 PM
Matt the Mead Maker   QUOTE(psolio @ Sep 26 2008, 06:17 PM) ......   Sep 27 2008, 03:41 PM
psolio   QUOTE(Matt the Mead Maker @ Sep 27 2008, 02...   Sep 28 2008, 12:52 AM
MtnBrewer   QUOTE(psolio @ Sep 26 2008, 05:17 PM) Mat...   Sep 28 2008, 12:44 AM
psolio   HighTest sent me a message with the following form...   Sep 28 2008, 11:48 AM
Meadmagick   is there something I am doing wrong? I click on t...   Feb 15 2010, 09:37 PM


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: 26th May 2022 - 09:43 PM