Jump to content



Photo
- - - - -

Biab Beer Designer Spreadsheet


  • Please log in to reply
139 replies to this topic

#121 ianh

ianh

    Beer God

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

Posted 15 April 2016 - 06:53 AM

Hi Ian, My spreadsheet won't allow me to save new recipes. I get an error: "can't find project or library". appreciate any advice

Hi, see post 27 of this thread, hope that helps.

 

Cheers



#122 Waratah67

Waratah67

    Kit Master

  • Members
  • PipPip
  • 49 posts
  • Joined 22-April 14
  • Location:Blue Mountains, NSW

Posted 15 April 2016 - 09:19 AM

Thanks Ian. It did,

 

The last one on the list read  "MISSING-Microsoft Word. 16".

 

I unchecked it. It seems to save again ok.



#123 ianh

ianh

    Beer God

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

Posted 16 April 2016 - 08:03 AM

The spreadsheet uses MS Word in the background to copy the information on the Brewday worksheet onto the Brews worksheet as a comment, just in case you are wondering why you need MS Word. It was the only way I could find of doing it.



#124 beef

beef

    Amateur Brewer

  • Members
  • Pip
  • 4 posts
  • Joined 27-May 13
  • Location:victoria

Posted 15 August 2016 - 06:23 PM

as someone new to allgrain that completely blows my mind how any of that works, would the calculations work on the 35l robobrew? again sorry if this has already been covered 



#125 Mat B

Mat B

    Partial Man

  • Members
  • PipPipPipPipPip
  • 125 posts
  • Joined 22-April 10
  • Location:Melbourne

Posted 15 August 2016 - 09:25 PM

as someone new to allgrain that completely blows my mind how any of that works, would the calculations work on the 35l robobrew? again sorry if this has already been covered 

 

Yep. All you need to do it enter your robobrew's parameters on the BIAB tab and you should be good to go. I think you'd need to set the type to crown urn in cell E4. Robobrew is just a fancy urn as far as I can see. 

 

Once you've done that you can enter your recipe details and volume on the first tab and try and get it close to a style on the chart on the right. Select your style from cell H3. 



#126 ianh

ianh

    Beer God

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

Posted 16 August 2016 - 08:22 AM

Just be aware that selecting Crown urn includes a factor for the volume of the raised concealed element and this is probably different for the Robobrew.



#127 beef

beef

    Amateur Brewer

  • Members
  • Pip
  • 4 posts
  • Joined 27-May 13
  • Location:victoria

Posted 17 August 2016 - 09:11 AM

Thanks guys ill have a look over the next couple of days

#128 beef

beef

    Amateur Brewer

  • Members
  • Pip
  • 4 posts
  • Joined 27-May 13
  • Location:victoria

Posted 18 August 2016 - 07:26 PM

Just be aware that selecting Crown urn includes a factor for the volume of the raised concealed element and this is probably different for the Robobrew.

ok so i have had a play and all seemed to be pretty accurate to what i got on brew day, how do i go about saving the recipe? it says something about macros? if i save it will it do anything to the program?



#129 ianh

ianh

    Beer God

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

Posted 19 August 2016 - 01:08 PM

Just hit the "Save Recipe" button on the Main worksheet and it should save to the Recipes worksheet. If you have added stuff to the Inventory worksheet and hit the "Make Recipe" button it should put the info on the Brews worksheet.

 

Note I think that the macros only work with Excel, not with Libre or Open Office.



#130 elvey

elvey

    Amateur Brewer

  • Members
  • Pip
  • 1 posts
  • Joined 20-October 16
  • Location:Darwin

Posted 22 October 2016 - 10:42 AM

Hey Mate. A brew buddy got me onto the spreadsheet. Great work, thanks a lot. I'm writing a web based recipe calculator and wonder if you'd mind me using your ingredient lists? Also wondering what formula you've used for the hop calculations? I'm using Tinseth (http://realbeer.com/hops/research.html) and was thinking I'd just add some time for the chube but wondered if you'd found anything better?

 

Source is up at https://github.com/m...tree/master/src if you want to have a play



#131 ianh

ianh

    Beer God

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

Posted 23 October 2016 - 11:48 AM

Hi elvey

 

Welcome to the forum.That's what I used for the hop calculations plus a time factor for No Chill. Feel free to use what bits you want, that's why it is not protected.

 

Cheers

 

Ian



#132 Stouter

Stouter

    Beer God

  • Members
  • PipPipPipPipPipPipPipPipPip
  • 393 posts
  • Joined 10-August 16

Posted 24 October 2016 - 04:53 PM

Ian seriously, bugger Bob Dylan, I reckon you should be the recipient of a Noble Prize, or a bloody knighthood or something such at least.

Your selfless contribution and willingness to help people is a combination which is a rare trait in today's society.

Surely you're aware of how much time and energy you've saved brewers!?  From someone with very bad math, measurements skills, and computer skills, thank you.

 

Sir Ian :)  Respect.



#133 mattyg8

mattyg8

    Brew Master

  • Members
  • PipPipPipPipPipPipPipPip
  • 258 posts
  • Joined 03-December 13
  • Location:Mooroolbark

Posted 13 December 2016 - 01:11 PM

Started using the no chill to play around with the IBU's what value would you put in for flame out without whirlpool or with whirlpool? Also cube hop?



#134 Mat B

Mat B

    Partial Man

  • Members
  • PipPipPipPipPip
  • 125 posts
  • Joined 22-April 10
  • Location:Melbourne

Posted 17 February 2017 - 11:11 AM

I’m going to do a brew over the next week that will feature home grown hops heavily. What’s the rule for adding these to the recipe builder? I’m going to dry my flowers for storage. I know there’s a pellet / flower field. Do I select flowers only when using wet hops and leave it as pellet if I’m using dry hops?

 

Cheers!



#135 ianh

ianh

    Beer God

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

Posted 17 February 2017 - 01:04 PM

If I remember right the difference between pellets and flowers is in the IBU calculation, pellets are 110% flowers 100%. I assume moisture is a large part of the difference. So I would go flowers for wet and pellets for dry.



#136 Mat B

Mat B

    Partial Man

  • Members
  • PipPipPipPipPip
  • 125 posts
  • Joined 22-April 10
  • Location:Melbourne

Posted 17 February 2017 - 01:06 PM

Thanks mate!



#137 LagerBomb

LagerBomb

    Move Along - Nuthin To See Here

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

Posted 17 February 2017 - 02:14 PM

Good to see you're still plugging away at this. I have just started brewing again after a shortish period of inactivity. We must catch up for a beer soon.

Cheers

David



#138 dave_hl

dave_hl

    Amateur Brewer

  • Members
  • Pip
  • 8 posts
  • Joined 22-February 13
  • Location:Geelong

Posted 23 March 2017 - 01:43 PM

Making good use of the spreed sheet - thanks very much for designing it! I was initially trying to find a really basic spreed sheet which just logged beers I had brewed but this is next level!

I am wondering if it is an easy edit for me to make the Hop schedule longer when creating a recipe. The APA (averagely perfect American) IPA I'm entering has a list about 14 long for hop additions!

I can see that to get the total IBU it's a simple SUM function that I can extend, but when I click and drag the hop list to make it longer, the buttons don't work anymore, and the huge IF statement to calculate the IBU for that hop addition also doesn't work.

Cheers.



#139 ianh

ianh

    Beer God

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

Posted 24 March 2017 - 07:04 AM

You should be able to extend the Hop schedule, you need to copy columns A to H (H is where the calcs are done) down to the rows required.

 

Need to change the Sum formula in Cell K14.

 

The buttons won't work as each one requires a separate small macro, but you can enter weights and times manually.

 

I think that should work. Another possible option is if you are adding a number of hops at a particular time you can add a new hop to the Hop page that is a combination of the hop IBUs.

 

Cheers



#140 dave_hl

dave_hl

    Amateur Brewer

  • Members
  • Pip
  • 8 posts
  • Joined 22-February 13
  • Location:Geelong

Posted 24 March 2017 - 11:50 AM

Ah, great stuff. Yes I didn't copy all the way from A to H. Thanks for the tech support! I love that this is fully open source - being able to ad grains and hops.

 

Thanks

Dave