Post #77 made 13 years ago
PistolPatch wrote:iijakii: Great to hear it was fantastic! Good on you. Just worked out what 62 quarts means :D - 60 L (The Converter doesn't seem to like quarts or qt :?:). You should be fine doing what you propose though you'll have to add some top-up water. I do 11 kg in a 70 L pot regularly. I just add the extra when I can after I pull the bag and during the boil. Go for it!
pkearney wrote:Hi I would appreciate some help with this conversion ,it is a dry stout from Jamils book .I have made it as Partial .Want to try BIAB
OG 1.042
ADF 75%
IBU 41
60 min Boil
Boiler is 40 l
Dia 35.5cm
3170 g British pale ale Malt
900g flaked Barley
450 g Black roasted barley
Hops Kent Goldings 5% AA 60 min 57 g
Pre boil Vol 26.5 l
Thanks Phill
Welcome to BIABrewer Phill!

Jamil's and John's "Brewing Classic Styles" book is great and deserves a place on every brewer's shelf.

I have done your recipe conversion but there are some explanations that I'm not happy with. (For a start, it's way too long :)). Will try and post it up better in a day or two. If you want the long, not well-written answer, PM me and I'll send it through :).

Converting recipes is sort of easy once you know how. Using software and spreadsheets and explaining their nuances to a third party sometimes gets a little mind-boggling! There's actually something not adding up in my answer to you that I can't put my finger on now - it's either an error in The Calculator I haven't noticed before or an error in me. Let me give my brain a rest and get back to you.

Cheers,
PP
Hey Phill

PP rang me with a concern about the recipe here. :geek:
I'm a little suss about the 12.5% Black Roasted Barley. Roasted barley is the single quantifiable difference between a stout and a porter. Even then there is not much in it, and a 'porter' can still (carefully) contain some roasted barley. This recipe seems though, a little two dimensional. Without knowing volumes/IBUs I'm still pretty sure that that's not a stout I'd like to drink.
BLACK anything malt is BURNT. Imagine the burnt taste that takes over a soup or nap sauce that's cought and burnt on the bottom. :o
I'd be really careful adding 12 percent of anything that wasn't a 'base' type malt to anything I'm making. A stout of any kind has it's roots in a "Stout Porter", having said that, later porters were pale malt and burnt sugar! :lol:. But I'm still really suss about 12% Black stuff in a beer.
Dry or not, my gut call would be to build a well structured grain bill (porter) with anything and everything from pale to brown to chocolate to even some darker types crystals. Then I'd use the mash and/or yeast to organise body type issues. You can't make a good pizza on a crap base, as you can't make a good APA on a crap malt profile ;) .
Mash it low (dry), and use a London type yeast (dry), and you'll have a drier stout with plenty of character (forgiving).
Hope that helps Phill, give us a PM for a chat if you like (phone beer). :lol:
Cheers Lloydie
Last edited by LloydieP on 07 Oct 2010, 22:33, edited 9 times in total.
[center]"Eat my sugar, man[/center]

Post #78 made 13 years ago
Hi All,
Would really appreciate some help in converting/adapting a couple of recipes.
I still don’t understand most of the terminology and methods (mashes and sparges etc.) used.
I have only done 1 brew on this set-up, which was a bit of a fumbling experience but still made tasty beer.
Have two brews (two different styles) planned to start as soon as, so I shall submit two posts.
Many thanks in advance…….
BREW “A”
I am using a new 40lt. Birko Urn (inside height-40cm, ID-34.3cm). It has an exposed element,
rated at 2400w I think. I also have a wire rack on a stand that clears the element by 25-30mm
so I can apply heat during mash etc. if required. The outside is lagged with 1cm thick camping mat.
I have a sparge bucket and access to various stock pots.
Have n.c. cubes , 5,15,20 & 25lt sizes.
I use 30lt. carboys for fermenters.
I prefer to brew on day one and n.c. and usually transfer and pitch next afternoon.
I like to get 25-27lt into the fermenter.

DUNKELWEIZEN XTRA
Amount Item Type % or IBU
3.25 kg Wheat Malt Dark (Weyermann®) EBC 14 - 18 Grain 50.00 %
1.90 kg Pilsner (Bohemian) - Floor Malted) Malt (Weyermann®) EBC 3 - 5 Grain 29.23 %
0.45 kg Wheat Caramel Malt (Weyermann®) EBC 100 - 130 Grain 6.92 %
0.30 kg Wheat Chocolate Malt (Weyermann®) EBC 800 - 1200 Grain 4.62 %
0.30 kg Smoked Malt (Weyermann®) EBC 3 - 6 Grain 4.62 %
0.15 kg Carafa® Special T2 Malt (Weyermann®) EBC 1100 - 1200 Grain 2.31 %
0.15 kg Caramunich® II Malt (Weyermann®) EBC 110 – 130 Grain 2.31 %
48.00 gm Tettnang [4.50 %] (45 min) Hops 17.8 IBU
13.00 gm Tettnang [4.50 %] (5 min) Hops 1.0 IBU
1 Pkgs Bavarian Wheat (Wyeast Labs #3638) Yeast Wheat
Est Original Gravity: 1.061 SG
Est Final Gravity: 1.016 SG
Estimated Alcohol by Vol: 5.85 %
Bitterness: 18.8 IBU
Est Color: 60.2 EBC
Original Brewers Notes
15 min 52 deg protein rest and mash at 65 deg. Fermented at around 19 deg with 3068. This beer is wonderful. The dark wheat is like munich wheat and adds a great malty finnish to the beer. Aroma is of smooth chocolate and malty wheat. Yeast character is subtle but clove and a touch of bubblegum stand out...... but thats my fermentation, not the recipe. I always used pale wheat and munich malt but this is so much better.

His process:
Mash in at 2.5 l/kg at 52 deg and immediatly pull amount required for next temp step when boiling. Promash works thes out for you in the complex mash scheduler. Raise the temp of the pulled thick mash (mostly grain with enough liquid to keep it fluid) to 66 deg. Hold there for 15 min to convert and then slowly raise it to boiling. Gently simmer for 10 to 15 min and pour back in the main mash and mix like hell.
Rest it at the desired temp........ for a wheat i use 63 to 64 for 30 min and pull a thin decoction (liquid only) and bring strait to the boil. Add this back in to acheive 71 deg and rest for 10 to 20 min and then mash out at this temp.
Sparge as normal.
*I usually use a double decoction with mash in at 52, then 63 for 40 min then pull again and decoct to 71 for 20 min while I run it to the kettle
My Notes:-CRIKEY!!

Post #79 made 13 years ago
Hi All,
This is BREW “B”
Repeat:- I am using a new 40lt. Birko Urn (inside height-40cm, ID-34.3cm). It has an exposed element,
rated at 2400w I think. I also have a wire rack on a stand that clears the element by 25-30mm
so I can apply heat during mash etc. if required. The outside is lagged with 1cm thick camping mat.
I have a sparge bucket and access to various stock pots.
Have n.c. cubes , 5,15,20 & 25lt sizes.
I use 30lt. carboys for fermenters.
I prefer to brew on day one and n.c. and usually transfer and pitch next afternoon.
I like to get 25-27lt into the fermenter

I have no original mash profiles for this recipe, only ingredients.
With oats I read on another forum, quote:-
“I would always mash in at 400C if there was anything over a couple of percent Oats in the grist, even if they were pre-gelatinised getting the Glucan soluble.”
How does one account for this?
Once again, many thanks in advance.

CASCADE STOUT COPY
Batch Size: 25.00 L
Amount Item Type % or IBU
0.52 kg Maize Flaked (Bairds) EBC 1 -3
Adjunct 7.17 %
5.23 kg Pilsner Pale Malt (Barrett Burston) EBC 3 – 4
Grain 71.71 %
0.76 kg Oats - Rolled/Flaked & toasted Grain 10.36 %
0.29 kg Chocolate Malt Pale (Thomas Fawcett) EBC 500 – 800
Grain 3.98 %
0.26 kg Barley Roasted - Unmalted (Bairds) EBC 1300 – 1500
Grain 3.59 %
0.23 kg Crystal Malt Medium (Bairds) EBC 140 – 160
Grain 3.19 %
22.00 gm Chinook [13.00 %] (60 min) Hops 24.5 IBU
10.00 gm Goldings, East Kent [5.00 %] (20 min) Hops 2.6 IBU
8.00 gm Fuggles [4.50 %] (5 min) Hops 0.6 IBU
1 Pkgs Irish Ale (Wyeast Labs #1084) Yeast-Ale




Beer Profile
Est Original Gravity: 1.066 SG
Est Final Gravity: 1.017 SG
Estimated Alcohol by Vol: 6.42 %
Bitterness: 27.7 IBU
Est Color: 54.3 EBC ????? I estimate it should be higher!

Post #80 made 13 years ago
Hi there smilinggilroy and welcome to BIABrewer.info,

Congratulations on your first brew. Great to hear it was a tasty one. A good all-grain recipe with an accurate thermometer will nearly always give tasty beer even with a few fumbles :).

What I think I'll do here is convert your first recipe and then let you have a crack at the the second one as the same process will apply. You'll almost certainly have some questions though so feel free to post them - recipe conversions are always a bit tricky. For example...

Your original recipes have no volume figures provided. They do however provide an original gravity figure. As I mentioned in this thread earlier, all software gives different original gravity figures so unless we have the original software program, we just have to use the figure provided. In your first recipe, 1.061 is this figure.

So...

The first thing I'm going to do is plug the following figures into The Calculator.

On Sheet 1 (Volumes etc.) I'm putting Brew Length = 25 L (you'll see that this will give you 27 L into the fermenter which you'd like), Original Gravity = 1.061 and Diameter of Kettle = 34.3 cm.

On Sheet 2 (Grain Bill) I am going to type in all the original recipe's grain weights which The Calculator automatically converts to suit the volume and gravity we desire in column G. The total in cell G5 says 7923 g and this will be automatically copied back to Sheet 1. (Make sure you delete any percent figures that appear in Column B.) The amounts of grain you need can now be seen Cells G5 to G12.

On Sheet 3 I am going to type in all the orignal recipe's hop weights, AA percentages and times in columns, B, C and G. I'm also going to type in 4.5 in column J. Column I will now tell you the weight of hops you need assuming the hops you have are also 4.5% AA. If not, change the values in J* and J9.

Your recipe is now converted but....

If you go back to Sheet 1 in Cell B21 you will see your Approximate Mash Volume is 50.97 L but you only have a 40 L urn!

What should you do?

I'm going to start another post on this otherwise the above is going to be way too hard to read etc.

In the meantime, I have attached The Calculator file for your first recipe.
You do not have the required permissions to view the files attached to this post.
Last edited by PistolPatch on 13 Oct 2010, 19:01, edited 9 times 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 #81 made 13 years ago
Okay, as mentioned, the results in The Calculator file at the end of the last post show that your urn is not big enough to full volume mash this recipe.

The first thing I am going to do is play around with the Brew Length figure (Cell B5) on Sheet 1 until the Approximate Mash Volume cell (B21) comes out at about 35 L.... 17.5 L gets pretty close. When I look at the Water Required is (Cell B20) it says 31.46 L. Now I am going to change the Brew Length figure back to 27 L. Water required now says 45.33 L. 45.33 L - 31.46 L = 13.87 L so...

You have about 14 L you can't include in your mash. There are many ways to deal with this. Here's a couple...

1. The easiest way is to add the 14L after you pull your bag and during the boil when and as you can. If you do this, your efficiency will be a bit lower as you are "washing" the grain with less liquid. If you decide on this then change the efficiency figure on the spreadsheet from 79% to say 72%. This will mean you'll have to use 9388 g of grain rather than 8557. I am of course guessing a bit here but it is not a bad way to go.

2. You can dump your bag into your food-grade bucket and add 14 L of water that you have just boiled into the bucket. The high temp should cause no problems if pH is right and will probably only raise the grain temp to that of mash out temps if you are lucky I reckon. Give it a stir and then hang your bag so it drains. Add what you get into this "sparge bucket" as and when you can during the boil. Try to make sure these runnings get boiled for at least 60 minutes - you may have to do some of it on your stove or something :(.

Hope the above helps a bit. As I said, recipe conversion is not easy. I've been trying to work out a simple, "how to," in this thread but every time someone posts a recipe there seems to be one bit of info missing from the original recipe that throws something new at my latest "how to" template :).

I think we're getting close :). People asking questions here speeds up the process so don't hesitate to ask them smilinggilroy.

Cheers mate,
PP
Last edited by PistolPatch on 13 Oct 2010, 20:07, edited 9 times 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 #82 made 13 years ago
Hi Pat,
Thanks for the reply, will try and nut out the calculator.
The one thing that has me "scratchin' me 'ed" is that the original recipe had a 6.1kg grain bill for a 28lt batch and from what I can gather the brewer uses a 3v system. The calculator tells us that 7.923kg grain is needed for a 27lt batch, 1.823kg extra grain required, this seems to be a big difference. I can't understand why at this stage.
On the other point I can do a "Dunk Sparge" (I think it's called that) with water from stove top using a stock pot and a huge megga squeeze of the bag.
Cheers,
Smilinggilroy

Post #83 made 13 years ago
Sorry about the slow reply sg - busy weekend...

I'm getting a 1.423 k difference as the original is adding up to 6500 g rather than 6100 g. I also couldn't find any volume or efficiency figures in the original recipe so had to work off the original gravity figure supplied. There's definitely two, possibly three, things happening here assuming that there are no errors in the original recipe...

Batch Size: The original recipe's batch size I am now assuming to be 28 L and I am assuming that the original brewer means their volume at the end of the boil. Our converted recipe has an end of boil volume of 31.5 L. I made this higher as I knew you wanted to get 27 L into your fermenter. If I reduce the converted recipe so it matches the volume of the original, the grain bill required drops to about 7000 g.

This still leaves a 500 g discrepancy so...

Original Gravity Calculation: The calculation for this varies from software to software. The Calculator uses a standard gravity formula but often reads 2 - 3 points lower than Beersmith. If I knock 3 points off the original gravity, we now need about 6700 g to give an end of boil volume of 28 L of wort at 1.058.

So we are now down to a 200 g discrepancy...

Efficiency: As the original brewer did not provide any volume or efficiency figures, we had to guess these. If there efficiency was 81% (two points higher than ours) then this would drop our grain bill to 6500 g.

In cases like this, if you can't correspond with the
original brewer, you have to make some educated guesses. It could be even something as simple as a typo in the figures they provided you.

Don't worry about it too much. The Calculator will get you in the ballpark and with enough info from the original recipe, will often get you spot on.

I'll attach another spreadsheet with the changes mentioned above but I would still work off the first one I posted.

Cheers mate,
PP
The Calculator - smilingroy Dunkelweizen with guesses.xls
You do not have the required permissions to view the files attached to this post.
Last edited by PistolPatch on 18 Oct 2010, 05:50, edited 9 times 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 #84 made 13 years ago
smilinggilroy wrote:Hi Pat,
I can do a "Dunk Sparge" (I think it's called that) with water from stove top using a stock pot and a huge megga squeeze of the bag.
The problem with the first "dunk" sparge you do is not knowing if you will be able to fit your bag into the "dunk" vessel without it overflowing. If I ever do a sparge, this is what I do...

1. Heat required volume up (in your case 14 L) to about 80 C. (If I am not doing a mash out in the main pot, then I would bring this water up to boiling point and then let it cool off a little.)

2. Dump bag in a bucket - preferably a wide one especially if you are double batching - then open the bag.

3. Pour as much as you can in of the 14 L. Hopefully you will get all of it in but you'll need probably a 30 L bucket to do this comfortably. If not, just pour what you can't fit in straight into the main kettle.

4. Give the grain a good mix up and then hang it as your main kettle approaches the boil. When the main kettle starts boiling, give the bag a bit of a squeeze, (you don't have to do much, just enough so as it isn't dripping everywhere) and then dump the bag.

5. Add your yield to the main kettle and then bring it back to the boil.

If, as in your case, your equipment is not large enough to do a full-volume mash, try and make sure you have a bucket big enough to do the above. If you have a pot big enough, then you can of course skip the bucket and do a "dunk" sparge i.e. drop the bag straight into the 14 L of hot sparge water.

So, that's todays' reading for you sg :). Hope it makes some sense - fingers crossed!
PP
Last edited by PistolPatch on 18 Oct 2010, 06:05, edited 9 times 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 #85 made 13 years ago
I have a confession: I abandoned BIAB for awhile. I got a mashtun when I moved up to 8 gallon batches and a 62 L boil kettle since I was skeptical of wielding around 25 lbs of grain and what not. But, I'm missing the BIAB way, so this coming weekend I am planning on trying out big-size BIAB.

This recipe (American IPA right on the edge of IIPA territory) will have 21.25 lbs of grain and I'm aiming for about 8 gallons into my fermenters. I still have my old 5 gallon pot from my stovetopBIAB days, thinking I'll try to dunk sparge. Will I see a noticeable increase in efficiency doing that vs just a really thin mash?

Post #86 made 13 years ago
Good to see you are questioning your ways iijakii ;)...

(I used The Converter to read your post and it worked perfectly so I will talk in metric below and assume this ease is reciprocated - don't use it in Internet Explorer though :argh:)

I have a 70 L pot/kettle and nearly always now brew double batches. A 62 L pot/kettle will do a 30 L batch (volume at end of boil - not into fermenter) easily if I am reading your figures correctly. (Straight away we are stepping into terminology problems!)

My advice is that if you can mash your grain with all the volume of water required then you should do so. This is the primary purpose of BIAB - it is a single vessel, full-volume brewing method that will produce quality all-grain beer. BIAB has produced gold medals in this format so why change the formula?

There are two reasons to sparge I can readily see, one is valid and one is not when we are talking about quality ingredients...

1. If you cannot fit all your liquor (mash plus sparge water) into your pot with your crushed grain then you might consider sparging but not for a while*.

2. If you want to, "record," high efficiency figures into the 90's plus more, then you can easily do this by a variety of, "tricks." I am a bit worn out tonight so describing the tricks let alone the fallacies of extremely high efficiency figures is not something I want to get into.

The expression. "dunk-sparging," should not be readily used for reasons I mentioned in my last post to this thread as there are several ways to sparge with, "dunk-sparging," being the least practical and the least efficient though there may be situations where I am incorrect on this.

* The only time I would recommend a new brewer to experiment/investigate or use sparging is if their kettle was significantly small. New brewers who have this dilemma should read the Mini and Maxi BIAB Guides that Ralph has written. Studying these will serve those brewers well but there is more 'work' involved in some ways.

So, iijakii, I reckon full-volume brew the beer if you can and forget the sparging! Why? Because it is the easiest, most uncomplicated, and proven advice I can offer and it yields higher in efficiency than most other methods without complicating a thing.

If I have misread your volume figures then let me know otherwise I think my advice is sensible.

:salute: iijakii,
PP
Last edited by PistolPatch on 01 Nov 2010, 22:57, edited 11 times 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 #87 made 13 years ago
Great, exactly what I was looking for, cheers PistolPatch.

I'll just load everything in the big pot and not worry about sparging. Now I need to just figure out my hop timings with the nochill :p

Post #88 made 13 years ago
You de man!

You replied before I even finished my edits - hope I haven't made too many errors. It was a bit of a ramble ;)

It's a great subject and I will ramble on it more I'm sure, here and there :smoke:
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 #89 made 13 years ago
Yeah, PP's quite right, only consider sparging if you can't do full- volume BIAB in your kettle, it makes MaxiBIAB possible with reasonable efficiency.

Efficiency shouldn't be the aim of novice brewers though, it is only something to be concerned about after the first decade of brewing... :whistle:
[center]Give me a beer and I will move the world. Archimedes[/center]

Post #90 made 13 years ago
Not hard to tell when I am having a few beers while posting. I sound like a bloody know it all lecturer :lol:

Hashie has started a thread Mythbusters which I'm sure will end up being a good one to subscribe to.

I should also say that when I mentioned above that there are tricks to get your efficiency into the 90's, this comment has some truth in it but not as much as I implied. Whilst tricks can be applied to get an extra few points in efficiency all through the mashing, sparging and kettle draining process, there are only a few that can be done to affect "mash" efficiency in BIAB and they are pretty ridiculous :roll:. For example, you could increase your boil time as this means you will have more liquor to mash with. Another is to keep draining your bag throughout the entire boil. These, of course, are silly things that I hope no one would even consider.

Adding a heap of trub to your fermenter is a way of significantly, "fudging," your, "into fermenter," efficiency. You get the idea...

The point I probably should have made is that when it comes to reading figures from other brewers, you should not treat them as being accurate. Some know it all lecturer has made a post here and a poll here that might help explain why.

:whistle:
PP
Last edited by PistolPatch on 03 Nov 2010, 21:23, edited 9 times 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 #91 made 13 years ago
I'll take another reading tomorrow when transferring from cubes - primary, but unless I botched my hydrometer adjust temperature calculations, which is entirely possible since I was a bit toasty from some homebrew :drink: , I hit over my SG and well into the 80s efficiency wise.

...now to find someone that has a sewing machine to replace my nylon bag with a proper voile :cool:

Post #92 made 13 years ago
iijakii wrote:I'll take another reading tomorrow when transferring from cubes but unless I botched my hydrometer adjust temperature calculations, which is entirely possible since I was a bit toasty from some homebrew :drink: , I hit over my SG and well into the 80s efficiency wise.
NME came over here the other day and we did a double batch and scored an efficiency into the kettle well in the 90's. I can't remember the exact figure - NME might. This is certainly not the first time. I once scored an efficiency of well over 100 but put this down to some sort of error though I was fully confident of my measurements.

I get really confused on this whole subject. I keep advising people to work on averages. I think this is good advice. But, the reality is that even when I have had two or three brewers checking everything, I have often had wildly varying efficiencies.

I have done well over 100 AG brews - probably closer to 200. The fact that on the brews where I make a conscious decision to measure well and double -check (usually with another brewer) my yields vary so wildly is probably the most fascinating and disturbing thing I find in brewing.

We probably should talk about it more to make sure it is not just me :),
PP
Last edited by PistolPatch on 08 Nov 2010, 22:35, edited 9 times 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 #93 made 13 years ago
It's one of those things Siggi.

My average is 83% But I only take one reading and one measurement. I measure the end of boil volume and the OG of the wort once it has cooled. These are the figures I use to calculate end of boil efficiency. I do it this way because I feel it removes ambiguity, as well as confusion from multiple measurements/readings.

Don't start PP on efficiency, he loves talking and he loves talking on efficiency most :lol:
Last edited by hashie on 09 Nov 2010, 12:54, edited 9 times in total.
"It's beer Jim, but not as we know it."

Post #94 made 13 years ago
Those figures are probably correct sig so good on you.
hashie wrote:Don't start PP on efficiency, he loves talking and he loves talking on efficiency most :lol:
Especially after a few beers. At these times, I tend to exagerrate things a little as well :whistle:
Last edited by PistolPatch on 09 Nov 2010, 20:29, edited 9 times 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 #95 made 13 years ago
Hello all. I'm just thinking of making the jump to all-grain, and am intrigued by this BIAB method. I have followed through several of PistolPatch's recipe conversions (thanks!) and think I have the hang of it.

One thing, though, that I'm lost on is these "actuals" from "B" and "C" of the "Volumes" part of the calculator. Has anybody seen a dumbed down explanation of them around here? Promise I've looked, forgive me if I missed it.

Thanks again for the great site, tons of useful stuff here.

Post #96 made 13 years ago
G'day woopig and welcome to the forum, :salute:
Without having the spreadsheet in front of me, from memory the actuals columns are spaces to enter in your results, so you can keep track of your figures and it gives you an average so you can refine your brewday for any given recipe.
I know PistolPatch will correct me if I'm wrong :? :lol: . If I'm correct I hope it helps.
Cheers :drink:
[center]"All right, brain. You don't like me and I don't like you, but let's just do this and I can get back to killing you with beer."
[/center]

[center]Homer Simpson[/center]
[center]K.I.S.S., B.I.A.B.[/center]

Post #97 made 13 years ago
Hi there and welcome woopig ;). Very good of you to wade through this thread and then still have enough energy to make such a positive post - good on you!

wiz, you did a lot better than I could have without having the spreadsheet in front of me. I saw woopig's post this morning before leaving for work and would have posted exactly the same as you. Now I have it up in front of me, I can see that woopig is asking about the bottom parts of The Calculator. I haven't had a good look at these sections for a while so Woopig's brief and nicely worded question gives me a good excuse to examine these parts of the spreadsheet in detail while I am having a beer. This will, unfortunately for him, mean a long post so my apologies in advance woopig :roll:.

Okay firstly woopig, Section B and C on the first sheet, 'Volumes,' of The Calculator, will only work for straight-sided kettles - i.e. stock pots. You probably knew this but I thought I better make sure.

So, what these sections assume is that you will use a long metal ruler to measure your volumes in such a pot. Let's have a look at Section B...

Section B

Kettle Calibration Figure: The figure in cell D26 tells you how many cms of water you should add to your straight-sided kettle to add 1 litre. In the case of a pot with a diameter of 45cms, if you wanted to add 1 litre of cold water to your pot, you would fill it until your ruler said 6.3 mm (0.63 cm). The figure in D26, the kettle calibration figure, is used for most of the other calculations in sections B and C. The forumula is a bit hard to back-track follow but is based simply on the mathematical formula for the volume of a cylinder.

End of Boil Volume: This figure tells you how many cms of water should be in your kettle at the end of the boil. It allows for approximatley 4% 'swelling' of near boiling wort. Near boiling wort takes up more space than cold water and this formula saves you having to get out your calculator and adjust for this.

Start of Boil Volume: This figure tells you how many cms of water should be in your kettle at the start of the boil and the formula makes the same allowances for 'swelling' as described immediately above.

Water Required is...: This tells you how many cms of cold water you should add to your kettle before you mash in.

Water Required (at mash temp): Water doesn't just suddenly 'swell' at boiling point, it expands exponentially as the temperature increases. The cms listed in cell D30 allows for this and will tell you how many cms your ruler should read at around 65 C. This is a handy figure for brewers who add water slowly to their kettle while still applying heat. For example, you might add water to your kettle by bucket but like to start warming your water as soon as the first bucket is in to save a bit more time. I use this figure all the time as I have an instantaneous hot water system so can add water to my pot at about 50C. In these latter two cases, using the figure in cell D29 would be incorrect.

Section C - the bit wiz mentioned

This section is based on the same logic/formulae as section B but here, you can type in the cms you really got on your brew. There are really only two figures to ever fill in here. They are F27 (how many cms you had in your kettle at the end of your brew) and F28 (how many cms you had in your kettle at the beginning of the boil. F29 and F30 would, in all brews that I can envision, be unnecessary as these are totally controllable.

F28 you should fill in as that will then tell you in cell G28 how many litres you have left in the kettle after pulling the grain bag. In other words, this figure can be used to determine your liquor loss due to grain absorption.

F27 you should fill in as that will tell you in cell G28 how many litres you have left in the kettle after boiling. In other words, this figure can be used to determine your wort loss due to evaporation.

The results you get in G27 and G28 should then be manually copied to the section below...

The Actuals Section (top right)

As any single figure on any single brew should not be trusted, this section allows you to build up some averages over 5 brews. All the figures in this green area, not just those from G27 and G28, need to be typed in manually. Cells J5 to J21 will tell you the average figures of the brews you have typed in so far.

Once you have done five brews, you can look for any big discrepancies and determine if they were measurement errors etc. You might like to, after five brews, transfer your averages to say cells L5-L21 and then do another 5 brews and see how the 'new' average compares with the old. You could even create new parts of the spreadsheet to store info on double batches or heavy beers. Spreadsheets are good like this as they are flexible/adapatble.

I hope the above is not too long-winded woopig or, should I say, 'guinea pig,' :lol:. You asked for a 'dumbed down' explanation. A lot of brewing stuff isn't easy or clear especially when you are starting out. As you get a few brews under your belt you actually realise that many areas of brewing lack clarity - a lot of advice is anecdotal, very rarely measured or tested so, like you, I love dumbed down (clear) explanations.

The above is probably more long than clear though :roll:. So, make sure you keep asking questions. One day we might actually come up with something brief and clear that covers all situations. That'd be nice!

Cheers and welcome woopig,
PP
Last edited by PistolPatch on 25 Nov 2010, 19:56, edited 9 times 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 #98 made 13 years ago
Wow, what a helpful bunch of people you are.

I started to not admit it because it's a bit embarrassing, but I'll tell you anyway.

See, I'm and idiot with Excel. So when I looked at that part, it never occurred to me that it was bringing my kettle diameter into the equation and using a constant to translate that to volumes. Makes sense, of course, since it does so with so many other variables on the spreadsheet, but that one eluded me.

Anyway, thanks so much for all the help. What a great site, can't wait to delve into this method.

Post #99 made 13 years ago
PistolPatch wrote:Hi there lespaul and welcome to the forum,

It gets very confusing working between different software programs and the way they can or need to be set up. Some brewers will use the term batch size as what goes into their fermenter while other brewer's, "recipe reports," mean the post-boil volume. It is often difficult to know which one they mean unless you know the software they are using and even knowing this sometimes means you still have to do some figuring or guessing to work out how they have set their software up!

And, it gets worse...

When converting recipes, every program will give you different gravity and bitterness results which is a PITA. The Calculator (or BIAB spreadsheet) uses a standard gravity formula but usually reads about 3 points different from Beersmith etc. The formula used for bitterness comes from John Palmer but reads far lower than other brewing software. As mentioned here recently, a recipe I plugged in the other day came up with...

ProMash = 41 IBU's
BeerSmith = 35 IBUs
Beer Alchemy = 43 IBUs
The Calculator = 31 IBUs

My goodness!!!

When communicating recipes, end of boil figures are the easiest to work. They are the common denominator of gravity and bitterness as these two things do not change from this point on. The best way of communicating recipes though is to take the time to explain the set-up your figures are based on such as Jamil and John do on Page 41 of, "Brewing Classic Styles," or in the manner of The Calculator where all volumes, gravities etc are described explicitly. This makes it easy for others.

What You Should Worry About/Do when Converting

The way I convert a recipe is...

1. Try to determine the original brewer's end of boil volume. (This can be difficult if the original brewer has used volume into fermenter as their batch size as you will have to guess at their losses after the boil or play around in the program they used until you establish their post-boil volume.)

2. Now set your software or spreadsheet so as the end of boil volume matches the above.

3. Now set your efficiency figure to the original brewers efficiency figure (based on post-boil efficiency.)

3. Type into your software the original weights and times of ingredients.

4. Now take a note (write down) what OG and bitterness your software / spreadsheet reads.

5. Now type in your desired end of boil volume (this will be what you want to get in your fermenter plus what you lose when transferring from the kettle/cube etc.) and your efficiency figure.

6. Now adjust the grain weights until you "score" the OG you wrote down above. (Make sure you keep the ratios between grains the same.) Often their is a scaling function on the software, including The Calculator that will do this for you.

7. Finally adjust your hops until you score the bitterness level you wrote down above. (Make sure you keep the ratios between hops the same.) Once again most software or The Calculator will do this for you.

Good recipes will take a lot of punishment so don't be panicked about making a stuff-up as you'll end up with a great beer anyway.

Jamil and John's recipes work on 75% efficiency and a post-boil volume of 22.7 L. The average end of boil efficiency on BIAB figures I have collected is a bit over 79%. I think a new brewer could happily copy any recipe in J & J's book exactly without worrying about the efficiency difference and end up with 19 L of splendid beer in their bottles or keg. It's a great book to have on your shelf.

So, if you were wondering why converting recipes can be a little bit demanding on your brain, hopefully the above shows why .

Cheers,
PP

[Admin Note: You are now free to distribute your recipes in The Calculator format providing you follow the copyright instruction explained here. The name will also soon be changed to BIAB-Calculator to make it easier to find.]
I'm trying to understand something. In the book it has the following grain bill in pounds for the dry stout:

British Pale - 7 lbs
Flaked Barley - 2 lbs
Black Roasted Barley - 1 lbs

Total - 10 lbs

Your conversion for BIAB:
British Pale - 5.40 lbs
Flaked Barley - 2.16 lbs
Black Roasted Barley - 1.08 lbs

Total - 8.64 lbs

I thought, if anything, with BIAB you would typically have to increase the grain bill? The calculator is decreasing the base malt quite a bit and increasing the specialty malts a little bit. I've had the same thing happen when trying to convert their oatmeal stout recipe, I'm short almost 2 pounds with that recipe. I can post more details, but maybe a simple explanation will help me to understand this.
Last edited by natept on 29 Nov 2010, 10:32, edited 9 times in total.

Post #100 made 13 years ago
G'day natept and welcome to the forum ;),

I'm a bit short on time today to look up where the above figures come from but they are definitely incorrect. The Calculator will increase or decrease all the grains equally percentage-wise. It's quite possible I made a mistake or typo in the base malt figure.

When I get time, I'll try and find the post that has the figures you are referring to.

BIAB will have a slightly reduced grain bill given the same end of boil volume as BIAB gets around 79% efficiency as compared to the 75% J & J work on in their book. The Calculator is set up though to allow quite large losses to trub so as to give beginners a bit more leeway. Because of this, often a recipe will require more grain as we will be ending up with more volume to give that leeway. Does that make any sense :).

Cheers mate,
PP
Last edited by PistolPatch on 29 Nov 2010, 11:27, edited 9 times 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

Return to “BIABrewer.info and BIAB for New Members”

Brewers Online

Brewers browsing this forum: No members and 66 guests

cron