Hi again Yetti,
Good on you for getting through all that reading. It's a shame that it is not in a nice, easy to find structure but I think that is going to take a massive amount of work and, as you have noticed, even some tricky terminology issues have only recently been solved.
Before we get back to the recipe...
Yettiman wrote:...I tried to edit the Hyperlink, but it seems locked.
That's an annoying thing in spreadsheets. In Excel, you right click on the cell and hit 'Clear Contents'. Not sure what you have to do in other spreadsheets.
Now to the recipe...
The Original Recipe has no Integrity
From your PM, I gather you have done some more reading on recipe integrity so what I write here might be superfluous. Probably the best thread for explaining this in detail is the thread called,
Does this recipe have integrity? Can I copy it?. This
cup of tea analogy might also help explain why this recipe has no integrity.
The basic problem with the recipe is that we have no idea what volume of ambient wort it makes. It says 23 litres but there is no way to know what this 23 litres refers to. If the person meant volume into fermentor, this does not help us because unless he also tells us his kettle to fermentor loss, we will won't know the key volume figure - Volume of Ambient Wort (VAW). Note that VAW is identical to the end of boil volume once cooled to ambient temps (EOBV-A).
The BIABacus has some pretty crafty ways of guessing the Volume of Ambient Wort but with this recipe, even this is impossible so the recipe remains impossible to scale accurately.
The BIABacus does the Scaling for You
Above you wrote, "The reason the quantities are lower is that I reduced them to 3/5th as I only wanted to create 3 gallons..." I was worried that this might have been what you had done. The BIABacus actually does all scaling for you provided the original recipe has integrity.
Let's pretend that in this case, the original author had said, "This recipe will give you 23 L of ambient wort." The recipe would now have integrity and can be used. Here's all you have to do...
Do everything you did (really nice work too) with the exception of the following...
See how Sections C and D have a left and right hand side? On the left you type in what weights etc were used in the original recipe. The right hand side then tells you what weights you will need to use to get the Desired Volume into Fermentor you typed into Section B and the same bitterness as the original recipe.
Here is how your file would look...
BIABacus PR1.3 - BrainsDark - Master.xls
You'll see you will need 983 grams of grain and 6.7 grams of hops.
On the left hand side of Section C, you could have also typed in the grain percentages if you knew them because that is the only info needed. It is best though if you input the original weights if you do know them.
Anyone can Now use the Recipe
If you sent me that file, all I need to do to scale it is type in my kettle dimensions and Desired Volume into Fermentor into Section B. That's it! (Well, you do have a dilution written in Section W so I would remove that for my set-up as well.)
Will the Recipe turn out Okay?
In the file, we have VAW set to 23 litres. In reality it could have been more or less. It is very likely though that we are within 10% so you will be fine brewing this recipe. This is true in most cases but it is important that you, as a brewer, are aware that you could be some way off from the original recipe.
As a general rule though, if you want a recipe with integrity, they are very hard to find. A book like 'Brewing Classic Styles' will serve you well and is one of the few books that actually does give you the VAW. Recipes on this site by the experienced brewers should serve you well although even some of the experienced brewers here are not fully aware of the integrity problem. Just ask then though if their VAW is not clear. If you have fellow brewers in your area and like the beers they brew, that is also a great recipe source as you actually know what the beer should taste like.
PP
You do not have the required permissions to view the files attached to this post.
If you have found
the above or anything else of value on BIABrewer.info, consider supporting us by
getting some BIPs!