Biab Beer Designer Spreadsheet

Australia & New Zealand Homebrewing Forum

Help Support Australia & New Zealand Homebrewing Forum:

ianh

Well-Known Member
Joined
24/10/08
Messages
693
Reaction score
104
Location
Wynyard Tassie
Hi

As some of you may be aware I have moved on from Kits & Extracts to BIAB, so in the process of doing so I developed a spreadsheet.

I specifically use a 40 litre Crown urn for brewing but the spreadsheet gives the option to chose a crown urn or a pot.

The spreadsheet is still in it's development stage but I feel it can certainly be a guide to BIAB brewers.

Please read the notes worksheet before using.

The original version 1.0 was posted on BIABrewer and changes since include

Changed the IBU calculation so it includes the fermenter volume plus the trub.

Changed the dropdown lists so The ingredients are on their worksheets.

Changed how FG is calculated, Adjuncts now have a fermentabilty factor.

Changed how the brewhouse efficiency is calculated.

Added a water temp factor for those who use hot water to fill their urn or pot.

The spreadsheet is unprotected so be careful what you delete but you can change what you will, for example on the BREWS worksheet if you use a hydrometer only, just hide the Refractometer columns.

Comments,criticisms & suggestions appreciated.

cheers

Ian
View attachment BIAB_Beer_Designer_v1.3.xls
 

bignath

"Grains don't grow up to be chips, son"
Joined
3/11/08
Messages
2,611
Reaction score
40
IanH, i'm not a biab'er, but seriously mate, do you sleep at all? The amount of work you put in to these spreadsheets of yours is incredible. I used the K&K sheet when i was kits and it was awesome.

If it was anything to go by, i am sure the other BIAB'ers out there will love your work!
 

ianh

Well-Known Member
Joined
24/10/08
Messages
693
Reaction score
104
Location
Wynyard Tassie
IanH, i'm not a biab'er, but seriously mate, do you sleep at all? The amount of work you put in to these spreadsheets of yours is incredible. I used the K&K sheet when i was kits and it was awesome.

If it was anything to go by, i am sure the other BIAB'ers out there will love your work!
Thanks, one of the advantages of being retired (old Bastard).
 

Hinji

Active Member
Joined
7/11/10
Messages
41
Reaction score
0
Looks the goods mate. I've only been using Brewmate recently, but this looks like it's in much more detail.

Cheers! :icon_cheers:
 

kelbygreen

Crazy Clown
Joined
28/11/09
Messages
2,850
Reaction score
21
looks great will try it out for sure the K&E one was great this one looks good to
 

ianh

Well-Known Member
Joined
24/10/08
Messages
693
Reaction score
104
Location
Wynyard Tassie
Found an error on the BIAB worksheet the Start of Boil Volume calc is incorrect.

On the BIAB worksheet Copy cell M15 to cell M13 should fix the problem.

cheers

Ian
 

Bretto77

Well-Known Member
Joined
29/6/08
Messages
51
Reaction score
0
Save yourself some trouble and get Beersmith2. Brad has included full support for BIAB as well as heaps of other features that I'm guessing would take you ages to develop yourself. Considering the support Brad gives to acknowledge Aussie brewers and this forum in particular, we should all get in behind him and support his excelent software product.

Brett

Hi

As some of you may be aware I have moved on from Kits & Extracts to BIAB, so in the process of doing so I developed a spreadsheet.

I specifically use a 40 litre Crown urn for brewing but the spreadsheet gives the option to chose a crown urn or a pot.

The spreadsheet is still in it's development stage but I feel it can certainly be a guide to BIAB brewers.

Please read the notes worksheet before using.

The original version 1.0 was posted on BIABrewer and changes since include

Changed the IBU calculation so it includes the fermenter volume plus the trub.

Changed the dropdown lists so The ingredients are on their worksheets.

Changed how FG is calculated, Adjuncts now have a fermentabilty factor.

Changed how the brewhouse efficiency is calculated.

Added a water temp factor for those who use hot water to fill their urn or pot.

The spreadsheet is unprotected so be careful what you delete but you can change what you will, for example on the BREWS worksheet if you use a hydrometer only, just hide the Refractometer columns.

Comments,criticisms & suggestions appreciated.

cheers

Ian
 

vykuza

Well-Known Member
Joined
12/5/09
Messages
1,024
Reaction score
237
There's room for more than one project Bretto. I can't believe how rude your reply is after all the effort ianh has put in to this.

Ianh - thanks for putting in the yards for making this spreadsheet for BIAB brewers.
 

keifer33

Well-Known Member
Joined
22/3/09
Messages
1,501
Reaction score
110
I agree what a useless comment. The more projects on the go the better. Its only going to benefit the community by having a diverse selection of programs.

Good work on the spreadsheet ianh will be handy to have at work to fiddle around with.
 

ianh

Well-Known Member
Joined
24/10/08
Messages
693
Reaction score
104
Location
Wynyard Tassie
Save yourself some trouble and get Beersmith2. Brad has included full support for BIAB as well as heaps of other features that I'm guessing would take you ages to develop yourself. Considering the support Brad gives to acknowledge Aussie brewers and this forum in particular, we should all get in behind him and support his excelent software product.

Brett
It's no trouble Brett, I enjoy doing it and can adapt it the way I want plus I have it tweaked for my Crown urn. Whilst I have not played with Beersmith 2 the previous version left a lot to be desired, put a kilo of sugar in a recipe then try a kilo af lactose, look at the FG, not sure whether this has been fixed in version 2.

cheers

Ian
 

aaronpetersen

Well-Known Member
Joined
8/1/10
Messages
290
Reaction score
12
Ian, you deserve a medal or a Knighthood or something. All rise for Sir Ian :icon_cheers:
 

joshuahardie

Beer, so much more than a breakfast drink
Joined
8/5/07
Messages
1,038
Reaction score
38
Very impressive work mate.

Well Done
 

dago001

Move Along - Nuthin To See Here
Joined
11/8/09
Messages
766
Reaction score
165
Well done IanH on getting this up and going. Your other spreadsheet was great, and having seen this in the development stage, I know this will be as good as the K & K version. It's good that you have the time on your hands to be able to do this. I hope the garden hasn't suffered too much.
Cheers
LagerBomb
 

Bang

New Member
Joined
6/8/10
Messages
3
Reaction score
1
thanks ianh for adding this to the site this will come in handy
 

Lodan

Well-Known Member
Joined
18/5/10
Messages
403
Reaction score
68
More man love for you ianh :wub:
The K&E spreadsheet helped me greatly, look forward to following the development of the new spreadsheet as i move into BIAB
 

Tanga

Well-Known Member
Joined
25/8/08
Messages
865
Reaction score
5
Yoink!

Thanks. I'm not BIAB yet but might play around with this to see how it works. It's great to see some software that works with Linux.
 

Silo Ted

Suspended in an Aspic Consomm
Joined
17/6/10
Messages
1,576
Reaction score
4
Excellent initiative, will take a closer look when I am not on my netbook. Had a quick squizz, and maybe I culd offer a suggestion? For many people the BIAB concept is great for brewing in small spaces and with less gear. I suspect a lot of BIAB'ers also no-chill, so how about a tick box option for NC?

My pet peeve with software is that I cant have the recipe on file looking the same as the process (ie my 45 addition is 60, my in-cube is 15 etc).

Just a thought, but regardless it's great to see people doing things for the community. If it's as good as what people say about your kits worksheet, then BIAB brewers will hve an excellent tool t their disposal, for free.
 

Latest posts

Top