Mad_Scientist wrote:I think you did a good job with detective mode.
Yep, top job
At the beginning of the book Gordon addresses many of the issues we cover here on interpreting recipes. As MS asked, he defines his recipes pretty well at the beginning of Section II, although there are some ambiguities.
Batch Size: He defines this as the volume at teh end of the boil although we don't know if he means at boiling temperature or at ambient.
IBU's: He defines these as Tinseth which is great. The only problem is that we don't know what software he is using and lots of software misinterprets or misapplies the formula. (For example, some software uses VIF or VFO instead of VAW. Some software even uses an average of VFO and VIB!*)
Anyway, your spreadsheet is great. You copied the "efficiency" mentioned in the book into Section X. You also set the VFL there to 0 which effectively turns VIF in Section B into VAW. Nice!
You then must have fiddled things until the grain bill on the left of Section C equalled the grain bill on the right. Great! What I wanted to do was find the logic in that and here is what you find...
6.5 US Gal = 24.6 L (rounded to 25 in the book but let's work on 24.6L). If we typed this into Section B as VIF, we'd find the grain bill on the right of Section B is 7475 grams versus 7147 grams on the left. Let's see though how it looks if we take Gordon's definition of Batch Siz as being VFO (Volume at Flame Out). On the second sheet of The BIABacus, under Water/Wort Expansion, if you type in 24.6 on the bottom line, it will tell you that is the equivalent of 23.65L at ambient. Or you can simply type in the VIF field "=24.6/1.04". Let's type 23.65 into Section B...
Now we end up with 7187 on the right versus 7147 on the left which we can treat as being identical.
All that needs to be done now is type in 23.65 into the first line of Section D and then get rid of the 70% and the 0 in Section X. Change the VIF in Section B to what
you want and you are right to go!
Let us know how you go
,
PP
*NOTE: Book IBU's say 56 IBU's versus the BIABacus 52.6. This leads me to believe that the software he's using is apllying Tinseth to VIF instead of VAW. I can't say for sure though as I don't know the VFL.
If you have found
the above or anything else of value on BIABrewer.info, consider supporting us by
getting some BIPs!