=Batch_Size-((total_wort)-Kettle_Loss-((Boil_Loss/60)*Boil_Time))
My formulae are getting longer and my heads battered.
My formulae are getting longer and my heads battered.
Spread sheets.
- Thread starter Orfy
- Start date
Help Support Homebrew Talk - Beer, Wine, Mead, & Cider Brewing Discussion Forum:
OP
OP
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?
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?
jcarson83
Well-Known Member
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
.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
OP
OP
jcarson83 said:
45/50*70
0.9*70
63%
Is that what you mean?
Not sure how that relates to .0714 * y = .045
jcarson83
Well-Known Member
No.
y = .045/.0715 = .6294 or 63%
y = .045/.0715 = .6294 or 63%
OP
OP
jcarson83 said:
Where does the .0715 come from.
Doing it my way I got 63% same as you.
jcarson83
Well-Known Member
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.
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
Brew Spreadsheet
