Jump to content



Photo
- - - - -

Biab Beer Designer Spreadsheet


  • Please log in to reply
139 replies to this topic

#1 ianh

ianh

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 661 posts
  • Joined 24-October 08
  • Location:Wynyard Tassie

Posted 27 June 2011 - 08:19 PM

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
Attached File  BIAB_Beer_Designer_v1.3.xls   1.18MB   3292 downloads

#2 Big Nath

Big Nath

    "Grains don't grow up to be chips, son"

  • Pro
  • 2,654 posts
  • Joined 03-November 08
  • Location:Mt Gambier, SA

Posted 27 June 2011 - 08:33 PM

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!

#3 ianh

ianh

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 661 posts
  • Joined 24-October 08
  • Location:Wynyard Tassie

Posted 27 June 2011 - 08:39 PM

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).

#4 sama

sama

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 371 posts
  • Joined 27-September 07
  • Location:GOSFORD

Posted 27 June 2011 - 08:57 PM

Thanks, one of the advantages of being retired (old Bastard).

good luck to ya mate :icon_cheers:

#5 Johnnyh_18

Johnnyh_18

    Kit Master

  • Members
  • PipPip
  • 41 posts
  • Joined 07-November 10
  • Location:Adelaide

Posted 27 June 2011 - 09:52 PM

Looks the goods mate. I've only been using Brewmate recently, but this looks like it's in much more detail.

Cheers! :icon_cheers:

#6 kelbygreen

kelbygreen

    Crazy Clown

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 2,871 posts
  • Joined 28-November 09
  • Location:newcastle

Posted 27 June 2011 - 11:10 PM

looks great will try it out for sure the K&E one was great this one looks good to

#7 ianh

ianh

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 661 posts
  • Joined 24-October 08
  • Location:Wynyard Tassie

Posted 30 June 2011 - 11:54 AM

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

#8 Bretto77

Bretto77

    Krausen

  • Members
  • PipPipPip
  • 51 posts
  • Joined 29-June 08
  • Location:Boonah QLD

Posted 30 June 2011 - 12:03 PM

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



#9 Nick R

Nick R

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 1,011 posts
  • Joined 12-May 09
  • Location:Sydney

Posted 30 June 2011 - 12:34 PM

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.

#10 keifer33

keifer33

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 1,543 posts
  • Joined 22-March 09
  • Location:Perth

Posted 30 June 2011 - 12:53 PM

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.

#11 Nick JD

Nick JD

    Blah Blah Blah

  • Banned
  • PipPipPipPipPipPipPipPipPip
  • 7,586 posts
  • Joined 04-November 08
  • Location:Burleigh

Posted 30 June 2011 - 12:54 PM

It's easier to learn how to brew beer than to learn how to use Beersmith.

Edited by Nick JD, 30 June 2011 - 01:00 PM.


#12 Lord Raja Goomba I

Lord Raja Goomba I

    Prisoner of Sobriety

  • Moderators
  • 4,960 posts
  • Joined 21-May 10
  • Location:Paroled and not in exile

Posted 30 June 2011 - 01:01 PM

It's easier to learn how to brew beer than to learn how to use Beersmith.


+1

#13 ianh

ianh

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 661 posts
  • Joined 24-October 08
  • Location:Wynyard Tassie

Posted 01 July 2011 - 07:28 AM

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

#14 AaronP

AaronP

    Brew Master

  • Members
  • PipPipPipPipPipPipPipPip
  • 291 posts
  • Joined 08-January 10
  • Location:Reservoir, VIC

Posted 01 July 2011 - 09:01 AM

Ian, you deserve a medal or a Knighthood or something. All rise for Sir Ian :icon_cheers:

#15 joshuahardie

joshuahardie

    Beer, so much more than a breakfast drink

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 1,042 posts
  • Joined 08-May 07
  • Location:Central Coast - NSW

Posted 01 July 2011 - 09:17 AM

Very impressive work mate.

Well Done

#16 LagerBomb

LagerBomb

    Move Along - Nuthin To See Here

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 772 posts
  • Joined 11-August 09
  • Location:Burnie

Posted 01 July 2011 - 09:32 AM

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

#17 Bang

Bang

    Amateur Brewer

  • Members
  • Pip
  • 2 posts
  • Joined 06-August 10
  • Location:canteen

Posted 20 July 2011 - 11:01 PM

thanks ianh for adding this to the site this will come in handy

#18 Lodan

Lodan

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 399 posts
  • Joined 18-May 10
  • Location:South Australia

Posted 20 July 2011 - 11:35 PM

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

#19 Tanga

Tanga

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 873 posts
  • Joined 25-August 08
  • Location:Outback SA

Posted 21 July 2011 - 08:35 AM

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.

#20 Silo Ted

Silo Ted

    Suspended in an Aspic Consomm

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 1,700 posts
  • Joined 17-June 10

Posted 21 July 2011 - 12:17 PM

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.