Jump to content



Photo
- - - - -

Biab Beer Designer Spreadsheet


  • Please log in to reply
136 replies to this topic

#21 ianh

ianh

    Beer God

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

Posted 21 July 2011 - 02:41 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.


Thanks

Had a look at doing this, some people only change the flavour and aroma hop times rather than all, could add an option that would add say 15 minutes to all calcs on selecting NC.

I do BIAB with NC but partly get around the problem by using hop bags which I remove at end of boil, then add any aroma hops to the fermenter.

cheers

Ian

#22 Tanga

Tanga

    Beer God

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

Posted 21 July 2011 - 03:04 PM

+1 to a no chill option. That'd be great. I can't look atm because I'm on my phone. Can someone tell me if we can do smaller batches? My urn is only 20L.

EDIT: Oops, sorry Ian. Didn't see your last post. This is so great. I can't wait to get home and check it out.

Edited by Tanga, 21 July 2011 - 03:18 PM.


#23 bus680

bus680

    Amateur Brewer

  • Members
  • Pip
  • 14 posts
  • Joined 30-May 10
  • Location:Townsville

Posted 21 July 2011 - 03:59 PM

I am moving to BIAB with an urn soon. This looks great. I cant wait to see the finished product.

#24 Shed101

Shed101

    Beer Dog

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 1,024 posts
  • Joined 09-April 10
  • Location:Shed 101, Sunny Coast

Posted 13 September 2011 - 01:56 PM

Love this too. Wish I could get the ultimate functionality running it on a Mac ... so may have to install BootCamp or somesuch workaround.

I'm an utterly sad bastard and reckon it would be useful to have a pricing column too ... shouldn't be too difficult :icon_vomit:

#25 going down a hill

going down a hill

    Beer Cod

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 744 posts
  • Joined 11-December 10
  • Location:Preston, Vic

Posted 13 September 2011 - 05:50 PM

Great work Ian. Your KandE version really helped me get my head around how the brewing process worked. Then you go and make a BIAB version with me recently converting to BIAB. Your a good man, thanks.

#26 no-grey nomad

no-grey nomad

    Amateur Brewer

  • Members
  • Pip
  • 16 posts
  • Joined 29-September 11

Posted 05 October 2011 - 01:48 PM

Hi Ian, this thing is awesome.

Just a quick question... How do you save recepies? I have a mac at home and use the work computer as least I can so macros are a bit beyond me. So if you could, a little walk through would be very much appreciated for the windows based PC at work.

Cheers mate, top job.

#27 ianh

ianh

    Beer God

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

Posted 07 October 2011 - 07:17 PM

Hi Ian, this thing is awesome.

Just a quick question... How do you save recepies? I have a mac at home and use the work computer as least I can so macros are a bit beyond me. So if you could, a little walk through would be very much appreciated for the windows based PC at work.

Cheers mate, top job.


Sorry for delay in replying just back from 4 days bushwalking.

Some people have got a project libary error when trying to save recipes, not sure what error you get. Not sure about the Mac but this may help for the work computer.


If you open the spreadsheet. Hit ALT & F11 should bring up visual basic.

In the visual basic Window go to the Tools Menu and select References I have ticked

Visual Basic for Applications
MS Excel 12.0 Object Library
OLE Automation
MS Office 12.0 Object Library
MS Forms 2.0 Object Library
MS Word 12.0 Object Library

I am using Excel 2007 so if using a different version will get a number other than 12.0, hope that fixes the problem.

Hopefully will have updated vesion shortly, time is the problem.

cheers

Ian

#28 Amber Fluid

Amber Fluid

    Beer Snob

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 1,403 posts
  • Joined 03-January 11
  • Location:Tasmania

Posted 19 October 2011 - 11:08 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


Is this still required to be done with the current download?
Cheers

#29 Lord Raja Goomba I

Lord Raja Goomba I

    Prisoner of Sobriety

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

Posted 19 October 2011 - 12:05 PM

Ian, have you thought of converting this to ODS format, given both excel is capable of using it, and it's an open standard (ISO) and fully compatible with my programs and operating systems?

Well done.

Goomba

#30 ianh

ianh

    Beer God

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

Posted 19 October 2011 - 12:10 PM

Is this still required to be done with the current download?
Cheers


Presume that was for the previous version, attached is the lastest version that I been promising for awhile. Fixed some calculations, added a factor for ibu's when no chilling (though I No Chill I remove the hop bags at the end of boil so I don't use the factor) also added a factor which changes the FG based on mash temperature. Changed the Hop worksheet so now everything is in the comments. Can't think what else.

Attached File  BIAB_Beer_Designer1.2.xls   1.15MB   450 downloads

cheers

Ian

#31 ianh

ianh

    Beer God

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

Posted 19 October 2011 - 12:33 PM

Ian, have you thought of converting this to ODS format, given both excel is capable of using it, and it's an open standard (ISO) and fully compatible with my programs and operating systems?

Well done.

Goomba


Thanks. No I had not thought of doing this. I tend to find that the there are problems running the macros whenever you try to put the spreadsheet in another format. For example take the Make Recipe macro, one of the things it does is to copy the Brewday worksheet and paste it as a comment on the Brews worksheet. To do this (and it's the only way I found) the macro opens MS Word in the background copies the info to Word then copies it from MS Word into the comment on the Brews Worksheet, the macro then closes MS Word.

One of the reasons the spreadsheet is unprotected is so other people may use it in whatever applications they want.

cheers

Ian

#32 Amber Fluid

Amber Fluid

    Beer Snob

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 1,403 posts
  • Joined 03-January 11
  • Location:Tasmania

Posted 19 October 2011 - 12:45 PM

Thanks for the new version.

Great work mate!!

#33 Muscovy

Muscovy

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 667 posts
  • Joined 28-June 11
  • Location:Mornington Peninsula Vicco

Posted 20 October 2011 - 07:34 AM

Great spreadsheet.
Hats off for the efforts.
This is how you take ownwership of the art!

#34 datamike

datamike

    Kit Master

  • Members
  • PipPip
  • 24 posts
  • Joined 26-May 07
  • Location:Elk Grove California

Posted 20 October 2011 - 08:29 AM

Thanks. No I had not thought of doing this. I tend to find that the there are problems running the macros whenever you try to put the spreadsheet in another format. For example take the Make Recipe macro, one of the things it does is to copy the Brewday worksheet and paste it as a comment on the Brews worksheet. To do this (and it's the only way I found) the macro opens MS Word in the background copies the info to Word then copies it from MS Word into the comment on the Brews Worksheet, the macro then closes MS Word.

One of the reasons the spreadsheet is unprotected is so other people may use it in whatever applications they want.

cheers

Ian


Yes, macros rarely work from app to app. But designing in .ods would allow anyone to use it, instead of just those who purchase Microsoft Office.

OpenOffice is free for everyone - just download and go.

It's very popular here in the US. Maybe not so much in Australia...

Anyway, it looks great!

Michael

#35 Lord Raja Goomba I

Lord Raja Goomba I

    Prisoner of Sobriety

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

Posted 20 October 2011 - 09:00 AM

Yes, macros rarely work from app to app. But designing in .ods would allow anyone to use it, instead of just those who purchase Microsoft Office.

OpenOffice is free for everyone - just download and go.

It's very popular here in the US. Maybe not so much in Australia...

Anyway, it looks great!

Michael


Popular here too. I run it on my windows 7 computer at work, my linux machines at home and can recommend it to anyone that owns a mac (rather than Office for Mac or that stupid Mac program Numbers, which isn't compatible with anything, unless you "export" to excel and it never renders right). It allows me to share documents with anyone - it works in office, but if someone doesn't have office (or a legal copy of it), I recommend them to d/l open office.

That's why I asked the question - as the macros don't all work. I can do what I need to do manually, but it's a shame to have all those macros not working across all platforms.

Good job, nonetheless.

Goomba

#36 nala

nala

    Mash Maestro

  • Members
  • PipPipPipPipPipPipPip
  • 240 posts
  • Joined 16-February 10
  • Location:Mandurah WA

Posted 20 October 2011 - 05:59 PM

Presume that was for the previous version, attached is the lastest version that I been promising for awhile. Fixed some calculations, added a factor for ibu's when no chilling (though I No Chill I remove the hop bags at the end of boil so I don't use the factor) also added a factor which changes the FG based on mash temperature. Changed the Hop worksheet so now everything is in the comments. Can't think what else.

Attached File  BIAB_Beer_Designer1.2.xls   1.15MB   450 downloads

cheers

Ian


Ian, I have just downloaded the latest version.
On the main page -- Row H5, I have a note in Red which says ADJUST THE VOLUMES OF CO2.
Should this be there ?
Love the programme and the new version. Well done.
Attached File  BIAB_screen.png   131.63KB   83 downloads

#37 Shifter

Shifter

    Brew Master

  • Members
  • PipPipPipPipPipPipPipPip
  • 252 posts
  • Joined 21-December 10
  • Location:Hobart

Posted 20 October 2011 - 06:31 PM

Looks like I'll have to get Open Office as my Mac won't allow it to work very well at all. Never the less, huge amount of work for which we thanks kindly.

#38 ianh

ianh

    Beer God

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

Posted 21 October 2011 - 06:39 AM

Ian, I have just downloaded the latest version.
On the main page -- Row H5, I have a note in Red which says ADJUST THE VOLUMES OF CO2.
Should this be there ?
Love the programme and the new version. Well done.
Attached File  BIAB_screen.png   131.63KB   83 downloads


Hi Nala

Thanks. Just means the CO2 volumes cell M18 are not within the style range CO2 range.

cheers

Ian

#39 ianh

ianh

    Beer God

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

Posted 21 October 2011 - 06:42 AM

Looks like I'll have to get Open Office as my Mac won't allow it to work very well at all. Never the less, huge amount of work for which we thanks kindly.


Sorry Shifter but I understand the macros will not run in OO.

cheers

Ian

#40 Lord Raja Goomba I

Lord Raja Goomba I

    Prisoner of Sobriety

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

Posted 21 October 2011 - 08:11 AM

It doesn't work - the macros that is - all that well, but the sheet itself, drop downs, etc work great.

Goomba