IPB

Welcome Guest ( Log In | Register )

6 Pages V  < 1 2 3 4 > »   
Reply to this topicStart new topic
> Mead/Melomel Calculator Spreadsheet, and log/graph tool
Matt the Mead Ma...
post Sep 15 2005, 07:40 PM
Post #16


Brewmaster
*****

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



QUOTE(Braindead @ Sep 15 2005, 05:00 PM)
Matt, Found this info, second post. Muscovado Sugar
*

Thanks for the link, Braindead. So the guy at beeradvocate says:
QUOTE
about 1.042 per pound

He must be implying 1.042 per pound assuming a 1 gallon volume - right? Thanks again!
Go to the top of the page
 
+Quote Post
Braindead
post Sep 15 2005, 07:54 PM
Post #17


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, 08:41 PM)
Thanks for the link, Braindead.  So the guy at beeradvocate says:

He must be implying 1.042 per pound assuming a 1 gallon volume - right?  Thanks again!
*

That's how i took it, but it's hard to say. I have a bunch of the Muscovado here and was wondering the same thing? I just found that thread searching for info on the sugar. (IMG:style_emoticons/brewboard/sorry.gif)
Go to the top of the page
 
+Quote Post
HighTest
post Sep 16 2005, 06:09 AM
Post #18


Brewmaster
*****

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



Although I have never bought (or used) this type of sugar, if it is similar in consistency to refined white (or brown) sugar I would use 46 pppg rather than the 42 points noted in that link - unless Muscovado sugar is 'cut' with other ingredients... (IMG:style_emoticons/brewboard/sorry.gif)
Go to the top of the page
 
+Quote Post
Thomas
post Oct 8 2005, 10:53 AM
Post #19


Brewer
****

Group: Members
Posts: 488
Joined: 30-May 03
From: St Paul, MN
Member No.: 741



HighTest, I made a calculator to go with the Mead OG FAQ:

Mead OG Calculator

Edit: Just added so you can calculate with a different starting gravity (think cyser).

I still haven't gotten the 15% moisture to give 100% correct results.

This post has been edited by Thomas: Oct 8 2005, 10:55 AM
Go to the top of the page
 
+Quote Post
HighTest
post Oct 8 2005, 11:12 AM
Post #20


Brewmaster
*****

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



Thomas, I moved your calculator post to this thread as the subject matter is a better fit.

As there are already two calculators here, I'm wondering if you made your calculator as a java script excerise? Also, I think it might be better recieved if the ads were removed You may want to read the brewboard policy about commercial ads. (IMG:style_emoticons/brewboard/wink.gif)

Latstly I'm puzzled by your "(think cyser)" note. Would you clarify it? (IMG:style_emoticons/brewboard/smile.gif)
Go to the top of the page
 
+Quote Post
Thomas
post Oct 9 2005, 10:20 AM
Post #21


Brewer
****

Group: Members
Posts: 488
Joined: 30-May 03
From: St Paul, MN
Member No.: 741



Well I made it as both an excercise and because I know not everyone has access to excel all the time. Same thing with my other javascript calculators.

Think cyser was for calculating OG with the "Water" having a different starting gravity, as in cider for making cyser.
Go to the top of the page
 
+Quote Post
HighTest
post Oct 9 2005, 11:34 AM
Post #22


Brewmaster
*****

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



QUOTE(Thomas @ Oct 9 2005, 11:21 AM)
Well I made it as both an excercise and because I know not everyone has access to excel all the time. Same thing with my other javascript calculators.
Good point! (IMG:style_emoticons/brewboard/wink.gif)
Go to the top of the page
 
+Quote Post
HighTest
post Nov 6 2005, 10:42 AM
Post #23


Brewmaster
*****

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



My Basic Honey OG & NAS add point speadsheet has been revised. Members who have an older version should replace that version with this one as the Brix conversion formulae were inaccurate... (IMG:style_emoticons/brewboard/sorry.gif) 11/06/05 Spreadsheet [attachment=81:attachment]
Go to the top of the page
 
+Quote Post
CooManChu
post Apr 4 2006, 11:23 AM
Post #24


Assistant Brewer
***

Group: Members
Posts: 137
Joined: 3-April 06
From: Chicago, IL
Member No.: 5,346



Very cool! Thanks alot.
Go to the top of the page
 
+Quote Post
jjarmoc
post May 23 2006, 05:22 PM
Post #25


Brewer
****

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



Did this get unpinned as a result of the recent happenings, or is there really no value in having it pinned anymore?

I don't much care, but I made the spreadsheet in hopes that it be easily found and used by others...
Go to the top of the page
 
+Quote Post
knightlord9
post May 23 2006, 05:29 PM
Post #26


Stewart
*

Group: New Member
Posts: 11
Joined: 2-May 06
Member No.: 5,505



QUOTE(jjarmoc @ May 23 2006, 03:22 PM) *
Did this get unpinned as a result of the recent happenings, or is there really no value in having it pinned anymore?

I don't much care, but I made the spreadsheet in hopes that it be easily found and used by others...



I think the events with our missing moderator caused it to become unpinned. That spread sheet has been very helpful to me.

thanks
Go to the top of the page
 
+Quote Post
JonnyP
post Jun 5 2006, 03:22 PM
Post #27


Assistant Brewer
***

Group: Members
Posts: 95
Joined: 4-June 06
From: Portland, OR
Member No.: 5,660



Very nice, thanks for the effort guys, I will put it to use on my upcoming mead concoction!

J
Go to the top of the page
 
+Quote Post
ze'ev
post Jun 14 2006, 05:18 PM
Post #28


Homebrewer
**

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



QUOTE(knightlord9 @ May 23 2006, 05:29 PM) *
I think the events with our missing moderator caused it to become unpinned. That spread sheet has been very helpful to me.

thanks



I've been away from the boards for a bit...whats up with the missing moderator?
I noticed that all of HT's posts in the FAQ's (like staged additions, calc. your OG etc.) are missing too.
Whats going on?
Go to the top of the page
 
+Quote Post
ScottS
post Jun 15 2006, 07:43 AM
Post #29


Brewmaster
*****

Group: banned
Posts: 1,340
Joined: 6-November 03
Member No.: 1,340



Re-pinned.
Go to the top of the page
 
+Quote Post
MtnBrewer
post Dec 2 2006, 11:28 AM
Post #30


Brewmaster
*****

Group: banned
Posts: 9,637
Joined: 26-July 03
Member No.: 937



I noticed the other day there is a bug in this spreadsheet. Specifically the BYO version of the Brix-to-SG calculator is always significantly lower than the others. The bug was in the source article so it's not your fault jjarmoc. (IMG:style_emoticons/brewboard/smile.gif) Here is the correct formula:

=1.000898+0.003859118*H2+0.00001370735*H2*H2+0.00000003742517*H2*H2*H2 <---- wrong formula
=1.000019+(0.003865613*(H2)+0.00001296425*(H2*H2)+0.00000005701128*(H2*H2*H2))

That formula should go in cell H4 H3.

Now it agrees exactly with ProMash and is within a couple of points of the others.

Edit: cell H4 corrected to H3 and formula corrected.
Go to the top of the page
 
+Quote Post

6 Pages V  < 1 2 3 4 > » 
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: 23rd June 2018 - 03:27 AM