Unless someone jumps in before, I'll answer your question fully tomorrow (within 12 hours) Homebrewjp.
Haven't had time to answer a question like this in ages so will look forward to it. I can also see you've already done some reading (recipe detective mode  ) so good on you.
More later,
PP

I think you did a good job with detective mode.  Is the IBU recipe close to BIABacus 53 IBU?

My best guess is that Gordon would have the recipe defaults declared at the beginning of the book.

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. 

Hi Fellow BIABrewers,

I just received a copy of Modern Homebrew Recipes as a gift. From page 27 on Key Points About My Process: "My recipes, measure the volume of wort left in the kettle at the end of the boil, not the amount of beer in a keg when packaged". His recipe size is 6.5 gallons (US) so that he can get 5 gallons of quality beer. So can I assume that he is using VAW for recipe size and, therefore, his recipes will have good integrity?

Thanks,

Steve

That would be VFO.

His recipes in Brewing Better Beer does not have integrity against the BIABacus. Nothing matches up.

Have you entered one of the recipes in BIABacus?

Can you screen shot a recipe from the book for us to shoot into the BIABacus?

MS

Mad_Scientist wrote: ↑

5 years ago

That would be VFO.

His recipes in Brewing Better Beer does not have integrity against the BIABacus. Nothing matches up.

Have you entered one of the recipes in BIABacus?

Can you screen shot a recipe from the book for us to shoot into the BIABacus?

MS

Yeah, I wasn't sure if it was VFO or VAW. Do you know for a fact that it is VFO? If not then I'll write to Gordon and see what he says. I have not tried entering a recipe into BIABacus. I attached his version of a recipe familiar to us all.

Yeah, it's VAW. Running just the grain bill into BIABacus at 70% efficiency matches almost perfectly. BIABacus has it at 13# of grain. So his "final volume" is VAW.

MS

Forgot to say, I entered 21 L for VIF. His "kettle volume" doesn't match up at all. I should say this was done in detective mode.

Mad_Scientist wrote: ↑

5 years ago

Yeah, it's VAW. Running just the grain bill into BIABacus at 70% efficiency matches almost perfectly. BIABacus has it at 13# of grain. So his "final volume" is VAW.

MS

So this is good, right?

Mad_Scientist wrote: ↑

5 years ago

Yeah, it's VAW. Running just the grain bill into BIABacus at 70% efficiency matches almost perfectly. BIABacus has it at 13# of grain. So his "final volume" is VAW.

MS

So MS, do I need to enter Strong's 70% efficiency into the BIABacus when using one of his recipes?

No. Remove the 70% from the BIABacus. That was only for detective mode. Removing the 70% efficiency allows the spreadsheet to determine the efficiency.

Mad_Scientist wrote: ↑

5 years ago

No. Remove the 70% from the BIABacus. That was only for detective mode. Removing the 70% efficiency allows the spreadsheet to determine the efficiency.

Awesome - thx MS!