Last week to Enter the Spike Brewing 20 Gallon Sight Glass Kettle Giveaway!



Home Brew Forums > Home Brewing Beer > All Grain & Partial Mash Brewing > Spread sheets.
Reply
 
LinkBack Thread Tools
Old 12-04-2006, 01:55 PM   #1
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Orfy's Avatar
Recipes 
 
Join Date: Sep 2005
Location: Cheshire, England
Posts: 11,853
Liked 71 Times on 53 Posts
Likes Given: 30

Default Spread sheets.

=Batch_Size-((total_wort)-Kettle_Loss-((Boil_Loss/60)*Boil_Time))

My formulae are getting longer and my heads battered.

Orfy is offline
 
Reply With Quote Quick reply to this message
Old 12-04-2006, 04:23 PM   #2
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Orfy's Avatar
Recipes 
 
Join Date: Sep 2005
Location: Cheshire, England
Posts: 11,853
Liked 71 Times on 53 Posts
Likes Given: 30

Default

Now my head is hurting.

What the formula for effieciency?


Say I know that the predicted SG is 1050 @ 70% effieciency on 30l run off.

I have 1045. How do I work out my effieciency?

Orfy is offline
 
Reply With Quote Quick reply to this message
Old 12-04-2006, 07:12 PM   #3
jcarson83
Feedback Score: 0 reviews
 
jcarson83's Avatar
Recipes 
 
Join Date: Jun 2006
Location: Springfield, MO
Posts: 942
Liked 15 Times on 10 Posts

Default

It would be your 1045 divided by the predicted gravity, before your efficiency correction.

.0714 * y = .045

But you efficiency looks different than mine. I may be over simplifying it.

=((Gravity_per_lb_per_gallon-1)*LBS_added/Gallons)*Estimated_Efficiency

__________________

jcarson83 is offline
 
Reply With Quote Quick reply to this message
Old 12-04-2006, 07:36 PM   #4
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Orfy's Avatar
Recipes 
 
Join Date: Sep 2005
Location: Cheshire, England
Posts: 11,853
Liked 71 Times on 53 Posts
Likes Given: 30

Default

Quote:
Originally Posted by jcarson83
It would be your 1045 divided by the predicted gravity, before your efficiency correction.

.0714 * y = .045
45/50*70

0.9*70

63%

Is that what you mean?


Not sure how that relates to .0714 * y = .045
Orfy is offline
 
Reply With Quote Quick reply to this message
Old 12-04-2006, 07:44 PM   #5
jcarson83
Feedback Score: 0 reviews
 
jcarson83's Avatar
Recipes 
 
Join Date: Jun 2006
Location: Springfield, MO
Posts: 942
Liked 15 Times on 10 Posts

Default

No.

y = .045/.0715 = .6294 or 63%

__________________
jcarson83 is offline
 
Reply With Quote Quick reply to this message
Old 12-04-2006, 08:08 PM   #6
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Orfy's Avatar
Recipes 
 
Join Date: Sep 2005
Location: Cheshire, England
Posts: 11,853
Liked 71 Times on 53 Posts
Likes Given: 30

Default

Quote:
Originally Posted by jcarson83
No.

y = .045/.0715 = .6294 or 63%
Where does the .0715 come from.

Doing it my way I got 63% same as you.
__________________
GET THE GOBLIN
Have a beer on me.
Orfy is offline
 
Reply With Quote Quick reply to this message
Old 12-04-2006, 09:03 PM   #7
jcarson83
Feedback Score: 0 reviews
 
jcarson83's Avatar
Recipes 
 
Join Date: Jun 2006
Location: Springfield, MO
Posts: 942
Liked 15 Times on 10 Posts

Default

Thats 100% efficiency. Most of the stuff I've found on different malts and grains gives you the gravity at 100% then you reduce it.

__________________
jcarson83 is offline
 
Reply With Quote Quick reply to this message
Old 12-05-2006, 02:29 AM   #8
Dude
Will work for beer
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Dude's Avatar
Recipes 
 
Join Date: Jan 2005
Location: Knob Noster, Missouri
Posts: 8,843
Liked 73 Times on 63 Posts
Likes Given: 6

Default

Take the formula from my spreadsheet. I can't seem to find the original spreadsheet link from BYO where I got mine, but mine came right from that.

Brew Spreadsheet

__________________
On Tap: Lake Walk Pale Ale -- Eternity (Raspberry Stout) -- Nutrocker -- Donnybrook Dark
Primary: Lake Walk Pale Ale
Secondary: Summit IPA
Up Next: Smoked Porter -- Pub Ale -- Watermelon Wheat
Planning:
Gone But Not Forgotten:

www.IronOrrBrewery.com
Dude 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
Three Sheets returning to the air nealf General Chit Chat 6 07-01-2010 05:22 PM
Three Sheets FireNightFly General Chit Chat 19 10-10-2009 04:54 AM
Three Sheets Returns on 7/20 Beernip General Chit Chat 16 08-05-2009 12:21 AM
Three Sheets Displaced MassHole General Chit Chat 10 06-25-2009 10:56 PM
Save Three Sheets! Quikfeet509 General Chit Chat 5 10-27-2008 05:16 PM



Newest Threads

LATEST SPONSOR DEALS