Answer - Part 1*
Thanks for you outstanding patience @BMWFan
. Nothing worse than having to wait days and days for an answer (sorry about that). I've just finished a big job so I should be more reliable from now on. Mind you, I might need some practice as I was half-way through writing my answer to you and lost the lot! (Not the forum's fault.) Let's see if I can remember what I wrote...
Okay, always save your files as .xls even when using LibreOffice or OpenOffice. The reason for this is that lots of people only have Excel and if you save your BIABacus as an .ods, they will, unfortunately, get a message saying that your file is corrupt. It won't open. If they do have LibreOffice installed they'll be able to open the file but heaps of people don't so best to play it safe and stick with .xls. (In hindsight, I wish we'd written the BIABacus in LibreOffice. Maybe later.)
Anyway, before we even go looking at BIABacus files, the thing to look at closely is the recipe you are trying to copy. If the original recipe says, "Chuck a pinch of salt in here and a couple of buckets of flour in here and then two handfuls of hops," you're not going to have much chance of copying that recipe. Unfortunately, there are many recipes floating about that can't be copied. In this thread
, you'll find a recipe for a gold medal beer published in a respected magazine. But, it's impossible to copy as the recipe lacks critical definitions resulting in a recipe of no integrity. Yikes! But, it happens all too often. Let's have a look...
The Original Recipe - Dragonmead Final Absolution Triple Clone
I've deleted non-critical info below. Full original recipe can be found here though.
Batch Size (Gal): 5.00 Wort Size (Gal): 5.00 This line tells us we are going to have to do some work.
Total Grain (Lbs): 16.00 Should be 14.4 as Candy Sugar is not a grain.
Anticipated OG: 1.094
Anticipated SRM: 5.4
Anticipated IBU: 35.3 Garetz, Tinseth or Rager is not specified so, it rally has no relevance.
Brewhouse Efficiency: 75% This line also tells us we are going to have to do some work.
One good thing is that the original recipe contains a lot of info about each grain, sugar and hop addition....
% Amount Name Origin Extract SRM
80.0 12.80 lbs. Pilsener Belgium 1.071 2
10.0 1.60 lbs. Munich Malt(2-row) America 1.008 6
10.0 1.60 lbs. Candy Sugar 1.015 0
Amount Name Form Alpha IBU Boil Time
1.80 oz. Hallertauer Mittelfruh Whole 4.50 29.7 60 min
0.40 oz. Styrian Goldings Whole 5.25 3.9 30 min
0.80 oz. Czech Saaz Whole 3.50 1.7 3 min
So, I think we can sort this.
Let's get The BIABacus to Help Us Fill in the Grey Areas
First we need to correct some typos. (I'm not happy with that 60 mins in Section B and in Section E by the way but we can talk about that later
). The 1.084 at the start of Section C should be 1.094 if we want to copy the original recipe.
In Section C, I have also typed a B beside Candy Sugar as it goes only in the boil. What you have done in Section Y for Candy Sugar I thought was correct but I have changed it to Beersmith defaults. Research that though as I think you are right
That gets the fermentables sorted, sort of....
Section X is out of control. You've over-ridden the BIABacus default adjustments and you've typed in totally unrealistic scenarios. For example, you won't get only 1.9 litres of Kettle to Fermenter trub when you are brewing 44 litres into the fermenter of a hugely high gravity brew (any gravity brew as a matter of fact) so...
Don't over-ride the BIABacus defaults. The defaults prevent you from trying to do impossible brews which is exactly what I'm seeing here.
So, I'm going to remove the 1.9 KFL and the 0.7 from Section X. I'll leave the 1.9 evap rate as I know you have the exhaust set-up.
A Quick Look at Efficiencies
We have the fermentables sorted now and this is nearly always straight-forward. One thing you might note now though is that in Section P, we have three efficiency figures with the highest being 67.2%. If you look at your original recipe, they have something called 'Brewhouse Efficiency," at 75%. What you'll find if you look for any other recipes published by this person, they will have the same Brewhouse Efficiency whether they are brewing a beer with an OG of 1.094 or 1.034. And, that, is the major problem with all brewing software (BIABacus excepted), they assume that "efficiency" which is set by the program user, is a constant on every brew and that, is totally incorrect.
That's taken a few hours to write and I've been working all day (and it's a Sunday) and I think I am getting old. In reality, I suspect I am getting wiser because I know how long the next part of the answer will take to write. I'll come back in a day or two with Part Two. Make sure you research on why I am unhappy with the 60 min boil and 60 min mash and I'll research on why I keep losing what I type. So annoying!
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!