Hi,
I'm converting a recipe from Charlie Papazian's book "Microbrewed Adventures". The only guidance on volumes is: "I've adapted nearly all of the recipes to fit a 5-gallon (19 l) batch format.". He assumes 85% "grain conversion efficiency".
I'm wondering what folks have used for the hop bill section for VAW ? My calculation using the BIABacus indicates that the 19 l batch format equates to VIF, so have set VAW to 20 l.
The recipe lists all hop additions as whole hops, so the original hop bill gets "FL". I plan on using pellets, so the substituted hop bill has 'blank' entries for Form, and I'm not convinced that the BIABacus is making the necessary adjustment for pellets over whole hops. Thoughts?
Thanks,
BDP
Post #2 made 10 years ago
BDP, could you Post the .XLS???
I have checked a few of My Recipes, in version "T" and the is a 10-12% difference in the Weight(grams) between FL and "space" not Del Blank.
I mean enter a "Space" instead of "Delete the Cell".
I have checked a few of My Recipes, in version "T" and the is a 10-12% difference in the Weight(grams) between FL and "space" not Del Blank.
I mean enter a "Space" instead of "Delete the Cell".
Honest Officer, I swear to Drunk, I am Not God.
-
- SVA Brewer With Over 100 Brews From United States of America
-
Post #3 made 10 years ago
Hey joshua 
The attached file is the one I fudged to calculate the VAW:
Note the hop bill amounts are the same as the original hop bill, even though the substitution 'Form' field has a 'space' character. By comparison, if you blank the original and FL the substitution hop, the substitution weight does increase as expected. I'm sure I'm doing something wrong, but for the life of me can't put my finger on it.
Cheers
The attached file is the one I fudged to calculate the VAW:
- Auto kettle efficiency = 85%
KFL = 0 l
FPL = 0 l
Note the hop bill amounts are the same as the original hop bill, even though the substitution 'Form' field has a 'space' character. By comparison, if you blank the original and FL the substitution hop, the substitution weight does increase as expected. I'm sure I'm doing something wrong, but for the life of me can't put my finger on it.
Cheers
You do not have the required permissions to view the files attached to this post.
Last edited by BDP on 19 Jan 2015, 07:07, edited 1 time in total.
-
- From Canada
-
Post #4 made 10 years ago
BDP, you are correct. At present, if the original recipe has flowers and you will be using pellets, you have to type PE on the right hand side. If left as blank, it assumes you will be using whatever is on the left hand side.
Of course, there is no way that you could know this with the current set-up. I'm a bit stuck atm on how to get around this design problem but I'm sure we'll come up with something.
Pat
Note: The only solution so far is to change the bottom line of Section D to Hop Forms: Blank/PE = Pellets. Not great but it will do the job.
Of course, there is no way that you could know this with the current set-up. I'm a bit stuck atm on how to get around this design problem but I'm sure we'll come up with something.
Pat
Note: The only solution so far is to change the bottom line of Section D to Hop Forms: Blank/PE = Pellets. Not great but it will do the job.
Last edited by Pat on 19 Jan 2015, 07:11, edited 1 time in total.
Are you a "Goodwill Brewer?" Pay forward and Buy Some BIPs 
Post #6 made 10 years ago
Any consensus on VAW for these recipes from "Microbrewed Adventures" ? Alternatively, I could use the recipes's IBU rating of 32 in Section D, but then there's the whole Rager vs. Tinseth question, and I don't know which one these recipes use to measure IBU.
Cheers
Cheers
-
- From Canada
-
Post #7 made 10 years ago
Your logic/process in post #3 is perfect BDP 
. So set your VAW to 19 L.
Not sure where the VAW of 20 L in post #1 came from.
Is it clear to you now why 19 L is the best guess?
...
Colour can be another way of deducing/detecting/making an educated guess at VAW.
PP
. So set your VAW to 19 L.Not sure where the VAW of 20 L in post #1 came from.
Is it clear to you now why 19 L is the best guess?
...
Colour can be another way of deducing/detecting/making an educated guess at VAW.
PP
If you have found the above or anything else of value on BIABrewer.info, consider supporting us by getting some BIPs!
-
- SVA Brewer With Over 100 Brews From Australia
-
Post #8 made 10 years ago
Now that you made me think about it, yes it is . I'm going to blame my lapse in reasoning on the 9% ABV (homebrewed) stout I was sipping on at the time 
Thanks!
. I'm going to blame my lapse in reasoning on the 9% ABV (homebrewed) stout I was sipping on at the time Thanks!
-
- From Canada
-
