I'm struggling to get my head around the "what you will use section". I have done a search on this site but can't find anything in the last 1/2 hour so was hoping someone could post a link to a thread that explains this for me. Or better just explain it - appologise if this is a noob question.
I've done a few (maybe 6) biab now. I have been following Graham Wheelers recipes from brew your own book. Been using the grain bills, hops bills and batch sizes he states, so why when i put them in the biabacus does it have a column saying what I should use for the grain bill? I can understand if scaling and I get if using different AA% hops, but not the difference in grain.
Thanks in advance
Post #2 made 12 years ago
A great question Andy.
Mad_Scientist, Yeasty, mally? Are you guys up for this? Maybe take it on as a group challenge?
PP
I have my hands full atm. The answer isn't hard but can take a while to write.I have been following Graham Wheelers recipes from brew your own book. Been using the grain bills, hops bills and batch sizes he states, so why when i put them in the biabacus does it have a column saying what I should use for the grain bill?
Mad_Scientist, Yeasty, mally? Are you guys up for this? Maybe take it on as a group challenge?
PP
Last edited by PistolPatch on 12 May 2014, 20:52, edited 1 time in total.
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 #3 made 12 years ago
Hello Andy. Welcome to the forum.
You can post GW recipe and your BIABacus PR1.3K over on this thread and we'll take a look at it. http://biabrewer.info/viewtopic.php?f=5&t=286#p1747
GW recipe is based on VFO (end of boil).

MS
You can post GW recipe and your BIABacus PR1.3K over on this thread and we'll take a look at it. http://biabrewer.info/viewtopic.php?f=5&t=286#p1747
GW recipe is based on VFO (end of boil).
MS
-
- SVA Brewer With Over 100 Brews From United States of America
-
Post #4 made 12 years ago
Andy, I think I might have just answered your question in the first two paragraphs of this post. Sorry I didn't answer last night but my brain was worn out
.
In nosco's thread, one of his questions was pretty much the same as yours. He was wondering why he needed less grain than the book he was copying from. Here's what I replied...
Also do as MS suggested as it is great to have your file double-checked there before you brew.
PP
In nosco's thread, one of his questions was pretty much the same as yours. He was wondering why he needed less grain than the book he was copying from. Here's what I replied...
Does that solve your problem?Firstly, if my system is more efficient than yours then I will need less grain than you to produce the same amount of beer. BCS recipes are all based on a fixed kettle efficiency of 70%. The BIABacus has calculated your kettle efficiency will be 86.2% therefore you will need less grain than BCS.
Another brewer's kettle efficiency is irrelevant to you. All you need to know from them are the grain percentages and the OG.
Also do as MS suggested as it is great to have your file double-checked there before you brew.
PP
Last edited by PistolPatch on 13 May 2014, 05:30, edited 1 time in total.
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 #5 made 12 years ago
Andy
The difference in the left and right grain columns has to do with efficiencies. The Biabacus calculates an efficiency based partly on your desired OG which probably differs from the original recipe's efficiency. I the original recipe it would call for grains A,B and C to get an OG of X; and that would assume you are getting the same efficiency as the author. Lets say that the author was getting an efficiency of 80% but the Biabacus calculated you would only get 75% then it corrects the grain bill to reach your desired OG. If you play around and adjust the auto efficiency in section X you can get the left and the right to match.
If you really want to use the exact amount of grains from the recipe you can adjust the OG numbers in section C until the right side grain bill is where you want it to be.
The difference in the left and right grain columns has to do with efficiencies. The Biabacus calculates an efficiency based partly on your desired OG which probably differs from the original recipe's efficiency. I the original recipe it would call for grains A,B and C to get an OG of X; and that would assume you are getting the same efficiency as the author. Lets say that the author was getting an efficiency of 80% but the Biabacus calculated you would only get 75% then it corrects the grain bill to reach your desired OG. If you play around and adjust the auto efficiency in section X you can get the left and the right to match.
If you really want to use the exact amount of grains from the recipe you can adjust the OG numbers in section C until the right side grain bill is where you want it to be.
Some people are like slinkies. Not good for much, but bring a smile to your face when pushed down the stairs.
Weehoosebrewing.ga
Weehoosebrewing.ga
-
- SVA Brewer With Over 20 Brews From Canada
-
Post #6 made 12 years ago
Hi andyisavinit.
Hopefully your questions have been answered OK?
It would still be worth you adding your BIABacus as Mad Scientist suggested, that way we can check for anything else at the same time.
Yeasty and myself have the graham wheeler book so we can check your recipe against that as well (as long as you put the correct title so we know which one you are brewing)!
Hopefully your questions have been answered OK?
It would still be worth you adding your BIABacus as Mad Scientist suggested, that way we can check for anything else at the same time.
Yeasty and myself have the graham wheeler book so we can check your recipe against that as well (as long as you put the correct title so we know which one you are brewing)!
G B
I spent lots of money on booze, birds and fast cars. The rest I squandered
I've stopped drinking, but only when I'm asleep
I ONCE gave up women and alcohol - it was the worst 20 minutes of my life
I spent lots of money on booze, birds and fast cars. The rest I squandered
I've stopped drinking, but only when I'm asleep
I ONCE gave up women and alcohol - it was the worst 20 minutes of my life
-
- SVA Brewer With Over 100 Brews From Great Britain
-
Post #7 made 12 years ago
To everyone who replied - thank you for your time - very much appreciated. No need to apologise about not replying sooner, it's not urgent - I think we're in different time zones anyway (I'm uk).
I've just had a play around with a couple of my spread sheets, and it all makes sense to me now. So yes you've answered my question well.
I'll post a couple of my biabacus' when i get back from work tonight as one is nearly a match (grain bills that is) and the other out slightly.
GW doesn't state hop AA% in his recipes so that brings me onto the "what i should use..." hop column question? Why are these different? I'm assuming AA utilisation....but can this be altered to match? Or is this section only needed when you are substituting a hop for a different hop with different AA%. But not sure that makes sense as why does the "what i should use.." hop column differ if i leave the 'substitute with' blank?
Again, I really appreciate your time replying and sorry if you're covering old ground.
A
I've just had a play around with a couple of my spread sheets, and it all makes sense to me now. So yes you've answered my question well.
I'll post a couple of my biabacus' when i get back from work tonight as one is nearly a match (grain bills that is) and the other out slightly.
GW doesn't state hop AA% in his recipes so that brings me onto the "what i should use..." hop column question? Why are these different? I'm assuming AA utilisation....but can this be altered to match? Or is this section only needed when you are substituting a hop for a different hop with different AA%. But not sure that makes sense as why does the "what i should use.." hop column differ if i leave the 'substitute with' blank?
Again, I really appreciate your time replying and sorry if you're covering old ground.
A
Post #8 made 12 years ago
Hi there Andy,
I do know what you are asking but post your BIABaci as your questions will be much easier to answer and the answers will be easier to understand as well.
Also read this. Recipes should have AA% for their hops but many don't
.
Anyway, post your files and one of us will help you out.

PP
I do know what you are asking but post your BIABaci as your questions will be much easier to answer and the answers will be easier to understand as well.
Also read this. Recipes should have AA% for their hops but many don't
Anyway, post your files and one of us will help you out.
PP
Last edited by PistolPatch on 15 May 2014, 17:12, edited 1 time in total.
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 #9 made 12 years ago
Well PP, yeasty, mally, mad sc and lumpy sorry for deserting this thread for quite a while – brewing has been off my mind for a bit with boring stuff like work – anyway I'm back on it with a free weekend ahead and a fresh order of grain arriving tomorrow.
Please cast your eyes over these 2 spread sheets - they are saved as .ods files (which is an open office file, I'm on a mac and for some reason the biabacus runs really slowly on excel. Hopefully you can still open them.) I would appreciate your comments.
The Hook Norton attachment is a batch I did and took notes on - it has very close matching 'what i should use' grain bills but differing 'what i should use' hops
The other is Batemans XXXB which i did brew but didn't take notes (don't tell me off
) - both the 'what i should use' sections are a bit out from Graham wheelers grain and hop bills.
Both these are in GW 3rd edition book.
I have read Yeasty's post about GW BYORA VFO = VAW here and think I may have made an error in my spread sheet. And may also explain how the hop section works too, as yeaty points out, the AA% are in GW book on pg 21.
And once again very much appreciate everyones time -
Hand claps to this site and forum and the biabacus, so much time and dedication

Please cast your eyes over these 2 spread sheets - they are saved as .ods files (which is an open office file, I'm on a mac and for some reason the biabacus runs really slowly on excel. Hopefully you can still open them.) I would appreciate your comments.
The Hook Norton attachment is a batch I did and took notes on - it has very close matching 'what i should use' grain bills but differing 'what i should use' hops
The other is Batemans XXXB which i did brew but didn't take notes (don't tell me off
Both these are in GW 3rd edition book.
I have read Yeasty's post about GW BYORA VFO = VAW here and think I may have made an error in my spread sheet. And may also explain how the hop section works too, as yeaty points out, the AA% are in GW book on pg 21.
And once again very much appreciate everyones time -
You do not have the required permissions to view the files attached to this post.
Last edited by andyisavinit on 30 May 2014, 07:04, edited 1 time in total.
Post #10 made 12 years ago
Sorry Andy, but the files should be saved in an .xls format. Please note that it is recommended for Mac users to use Libre Office.
Can you save them in Open Office as an .xls format?
Can you save them in Open Office as an .xls format?
-
- SVA Brewer With Over 100 Brews From United States of America
-
Post #12 made 12 years ago
ok try these - i did a save as and it gave me the option for .xls from Open office - Hope the formatting is still ok.
You do not have the required permissions to view the files attached to this post.
Post #13 made 12 years ago
Hey Andy.
Are you brewing this weekend? Is it one of these two recipes you brewed already?
Maybe Yeasty or mally can help you with the GW recipe, if you have a last minute question.
As far as moving forward on using the BIABacus, you need to download a fresh file from my post #3 above, it is PR1.3K, and be careful to always save it as an .xls format every time. Those two files are corrupted.
You should post your files over on this thread next time, thanks...; http://www.biabrewer.info/viewtopic.php?f=5&t=286#p1747

MS
Are you brewing this weekend? Is it one of these two recipes you brewed already?
Maybe Yeasty or mally can help you with the GW recipe, if you have a last minute question.
As far as moving forward on using the BIABacus, you need to download a fresh file from my post #3 above, it is PR1.3K, and be careful to always save it as an .xls format every time. Those two files are corrupted.
You should post your files over on this thread next time, thanks...; http://www.biabrewer.info/viewtopic.php?f=5&t=286#p1747
MS
-
- SVA Brewer With Over 100 Brews From United States of America
-
Post #14 made 12 years ago
Hi Andy,
Just had a quick look (sorry if it's too late).
The BIABacus looks good except for a couple of things.
Which version are you using? It looks like PR1.3 (whereas the latest is PR1.3K). This could be due to your open office though?
Also, as I suspect you may already know, you need to change the EOBV-A in section D (which is now called VAW) to match what yeasty posted in that thread (i.e. 23L VAW in the book should be entered as 22.11, & 25L as 24.04).
Check your hop AA% as well you have challenger at 8% & 8.5% (should be 7.6%), fuggles 5% (should be 4.9%). You enter these as you have done in section D "original hop bill design".
If your hops are of a different AA%, you add this info to the right hand side "substitutions", and then for your brew day you will use the values in the right hand column "what you will use". The BIABacus will automatically scale the amount of hops you need to replicate the brew based on how much beer you want as well as differences in hop "bitterness strength".
Just had a quick look (sorry if it's too late).
The BIABacus looks good except for a couple of things.
Which version are you using? It looks like PR1.3 (whereas the latest is PR1.3K). This could be due to your open office though?
Also, as I suspect you may already know, you need to change the EOBV-A in section D (which is now called VAW) to match what yeasty posted in that thread (i.e. 23L VAW in the book should be entered as 22.11, & 25L as 24.04).
Check your hop AA% as well you have challenger at 8% & 8.5% (should be 7.6%), fuggles 5% (should be 4.9%). You enter these as you have done in section D "original hop bill design".
If your hops are of a different AA%, you add this info to the right hand side "substitutions", and then for your brew day you will use the values in the right hand column "what you will use". The BIABacus will automatically scale the amount of hops you need to replicate the brew based on how much beer you want as well as differences in hop "bitterness strength".
G B
I spent lots of money on booze, birds and fast cars. The rest I squandered
I've stopped drinking, but only when I'm asleep
I ONCE gave up women and alcohol - it was the worst 20 minutes of my life
I spent lots of money on booze, birds and fast cars. The rest I squandered
I've stopped drinking, but only when I'm asleep
I ONCE gave up women and alcohol - it was the worst 20 minutes of my life
-
- SVA Brewer With Over 100 Brews From Great Britain
-
Post #15 made 12 years ago
Thx for the reply Mally. I actually read your post mid-boil on sunday. I was reassured that I had done as you suggested and adjusted the (EOBV-A) and put in GW's AA%.
You say eobv-a is now VAW - that must be in the latest biabacus - can you post a link so i can download it, for some reason I'm struggling to find it myself.
Anyway after posting the two spreads sheet earlier in this thread for XXXB and Old Hooky I ended up brewing the Black Sheep recipe. (I had brewed the Old Hooky before.)
I took good measurements this time and thought i'd post it to see what you make of it.
My queries/comments would be : The colour discrepancy is -13%, GW's book says 27, biabacus 17.3, is that to do with the volume of liquor or my ebc's a bit out?
GW's bitternes says EBU 36 - Biabacus IBU (tins) 46.4 I've not searched for any conversion so not sure how that matches up. But will do.
I have this new ish method of not clogging the syphon with hops ( i have no tap on my kettle), I sanitise a sieve by boiling it in the kettle for the last 10 mins then at flame out, scoop all the hops out. It only takes 5 or 6 mins and works extremely well. Literally all that is left is the break. This time i just syphoned everything apart from the very last 0.5Ltrs, where it got really sludgy. So my next biabacus session pre brew, I will adjust the KFL to 0.5.
My efficiency would appear to be pretty good too. Is over 90% not uncommon? Just I read a lot of people saying 75-85% etc not above 90? I'll up that next time anyway too and see if i hit the OG as it is a bit high.
I'm really looking forward to seeing how this one turns out. Currently fermenting nicely at a cool 17-18%.
Thanks again. Sorry about the excel files not working for you MS and hope it's ok to post a file here as I've brewed this one. Or should I use the other thread?
You say eobv-a is now VAW - that must be in the latest biabacus - can you post a link so i can download it, for some reason I'm struggling to find it myself.
Anyway after posting the two spreads sheet earlier in this thread for XXXB and Old Hooky I ended up brewing the Black Sheep recipe. (I had brewed the Old Hooky before.)
I took good measurements this time and thought i'd post it to see what you make of it.
My queries/comments would be : The colour discrepancy is -13%, GW's book says 27, biabacus 17.3, is that to do with the volume of liquor or my ebc's a bit out?
GW's bitternes says EBU 36 - Biabacus IBU (tins) 46.4 I've not searched for any conversion so not sure how that matches up. But will do.
I have this new ish method of not clogging the syphon with hops ( i have no tap on my kettle), I sanitise a sieve by boiling it in the kettle for the last 10 mins then at flame out, scoop all the hops out. It only takes 5 or 6 mins and works extremely well. Literally all that is left is the break. This time i just syphoned everything apart from the very last 0.5Ltrs, where it got really sludgy. So my next biabacus session pre brew, I will adjust the KFL to 0.5.
My efficiency would appear to be pretty good too. Is over 90% not uncommon? Just I read a lot of people saying 75-85% etc not above 90? I'll up that next time anyway too and see if i hit the OG as it is a bit high.
I'm really looking forward to seeing how this one turns out. Currently fermenting nicely at a cool 17-18%.
Thanks again. Sorry about the excel files not working for you MS and hope it's ok to post a file here as I've brewed this one. Or should I use the other thread?
You do not have the required permissions to view the files attached to this post.