Hey Bill
,
There's a few questions etc to deal with so I'll jump straight in.
Firstly, your file has come up as unprotected. In other words, you can click on any cell in the sheet. I think this happen s in OpenOffice if you save it under something other than an .xls file. Just be really careful as lots of formulas are hidden in cells so it is easy to accidentally wipe them.
For the purpose of this exercise, I am going to quickly re-write your BIABacus into PR1.3K so as we can use the same terminology so open the file attached here. Hopefully it will also stay protected for you.
...
That's great re the
OG thing. Putting the 1.058 on the right of Section C to make it less strong is the correct thing to do. Nice work!
...
I worked out that the
recipe report comes from BeerSmith and that the original brewer's 'VAW - Volume of Ambient Wort' was 6 gallons. Remember above, how you wrote that you believed that batch size usually means 'VIF - Volume into Fermentor'? Well, that is not right. Some brewers mean that and otehr brewers mean VAW. These are two different numbers and the problem is, for a successful recipe duplication, we really need to know VAW and that can be difficult or impossible to find in most recipe reports.
Please stop here now and have a really good read of
this thread. Make sure you understand the difference between VAW and VIF.
...
Knowing the VIF of a recipe is useless without also knowing the 'KFL - Kettle to Fermentor Loss'. If with your equipment, you have a VIF of 23 L and a KFL of 6 L, you will need more hops than the brewer who gets 23 L VIF and 2 L of KFL.
Only knowing VIF is useless.
Now, we got lucky with this recipe as I was able to do some advanced calcs and discover that when this brewer said "Batch Size: 6.00 gal" they meant VAW. Lucky for us. We'll come back to this next.
...
You'll have read in the other thread I linked above the problems with using IBU numbers from another program. These are almost always meaningless so I have deleted the 33.2 you had written on the second line of
Section D. THe second line of Section D should only be used when designing a recipe. When copying a recipe, it should be used as a very last resort. What do we need?
We need the VAW, the AA% of the hops, the weight of the hops and time added so we are good to go there. The BIABacus calculates your IBU's as 27.9. This will often not agree with the original recipe report dur to either or both of the following. The other program uses an incorrect formula and/or uses a different estimate formula than Tinseth.
...
When mashing with BIAB,you want to do a 90 minute mash. So, you'll want to do 45 mins at 156 F and 45 mins at 159 F. I have done this in
Section E.
...
Removing
the red volume warning. There are many ways to reduce the chances of getting a red volume warning....
1. Reduce the desired VIF in section B (try the things below first.)
2. Reduce the boil time (not recommended for most styles but here we can knock it down to 75 mins - I've done this.)
3. Go to Section G and H and use some advanced trub management methods.
4. Go to Section W and type a figure beside 'Water Added Before the Boil'. I have typed in 3L. In your file, try deleting it and adding it back in. Watch what happens to the amount of grin you will use in Section C and the Mash Volume in Section K.
5. In Section W, you can also use some other dilutions but adding before the boil is best for quality.
6. In Section K you can also use some for the water in a sparge. As we have discussed this is more work for no gain if your pot can handle full=0volume but it's also a lot of work in a port that is too small. Try removing the 3L we had in "Water Added Before the Boil" and instead move it to 'Water Used in a Sparge'. See how it does not affect the grain bill? You might save a few cents in grain but create a lot of work. It's your decision though when it comes to a kettle being too small.
...
I think that is enough for now but come back with any questions Bill.
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!