Kit And Extract Beer Spreadsheet

[unterberg]

Hi

Currently testing what I am calling version 2.0 of the spreadsheet.

It will allow you to name and save recipes to a Recipes Worksheet then retrieve them back into the Main Worksheet. The spreadsheet will come with four macro buttons for New Recipe (as it is now), Save Recipe, Get Recipe, and Delete Recipe.

I have done all the coding and I am now testing trying to find and fix any problems.

Also I changed the hop time cells so they will accept a D or d for dry Hopping. Doesn't affect the calculations but displays on the Brewday worksheet as Dry Hopping, plus can be saved in the recipes.

Hopefully Version 2 will ready in a few days.

cheers

Ian

Great job there. Looking forward to the new version.

 

[WarmBeer]

Love it but I have to boot to Windoze to run it. Can I some how convert it to open office 3.1.

Many thanks for the spread sheet. :icon_chickcheers:

Yeah running Ubuntu OS

It works just fine in OOO, only the macros dont really work well.

Linux seems fairly prevalent in the HB community. I think in the same way that we don't want some mega-corporation telling us how beer should taste, we also don't want some mega-corporation telling us how to use our computers.

 

[ianh]

Love it but I have to boot to Windoze to run it. Can I some how convert it to open office 3.1.

Many thanks for the spread sheet. :icon_chickcheers:

Yeah running Ubuntu OS

I don't think the macros will run correctly in open office especially when I add the recipe worksheet in version 2 which I will probably upload tomorrow.

I do not have a copy of Open Office to try it, I have enough trouble making sure the spreadsheet will run in Excel versions from 97 to 2007.

cheers

Ian

 

[claymen]

Could convert the whole thing to a PHP/MySQL web based type app without too much trouble. Then it'd be cross platform and people just create accounts to store their details. Then you could start doing things like sharing recipe's etc

 

[roverfj1200]

I don't think the macros will run correctly in open office especially when I add the recipe worksheet in version 2 which I will probably upload tomorrow.

I do not have a copy of Open Office to try it, I have enough trouble making sure the spreadsheet will run in Excel versions from 97 to 2007.

cheers

Ian

Thanks Mate was just asking.. To lazy to reboot and I hate Windoze will just have to if I need to run Macros.

 

[whitegoose]

Love it but I have to boot to Windoze to run it. Can I some how convert it to open office 3.1.

Many thanks for the spread sheet. :icon_chickcheers:

Yeah running Ubuntu OS

I run it using open office - you just need to edit your macro security to allow macros.
That being said most of the macros don't work in OO, but all the calculations do

 

[Stagwa]

Linux seems fairly prevalent in the HB community. I think in the same way that we don't want some mega-corporation telling us how beer should taste, we also don't want some mega-corporation telling us how to use our computers.

Either that or we are a bunch of tight arses :lol:

 

[mfdu]

I think in the same way that we don't want some mega-corporation telling us how beer should taste, we also don't want some mega-corporation telling us how to use our computers.

blah blah blah. pipe down consumerist boy. i know you drove a european car and live in a swanky suburb which hasn't got even one crack house. and i'm sure i remember you throwing away your red beret and cutting your hair off years ago.








love to SWMBO and the kids.

 

[zebba]

Linux seems fairly prevalent in the HB community. I think in the same way that we don't want some mega-corporation telling us how beer should taste, we also don't want some mega-corporation telling us how to use our computers.

OMG what a shock! Anyone who has met this guy IRL has heard a variant of this speech 1000 times



I still love ya bud

(And OT, love this spreadsheet too)

 

[ianh]

I run it using open office - you just need to edit your macro security to allow macros.
That being said most of the macros don't work in OO, but all the calculations do

Yes I did not think the macros would work. I tried OO 2 a while back and it didn't like macros then, have not tried it since.

So I assume all the numbers are OK it just doesn't update the beer colour in the glass and the New Recipe button doesn't work. As I said version 2 will have three additional macros for saving, getting and deleting recipes, which I assume unfortunately won't work either in OO.

 

[loikar]

Thanks Mate was just asking.. To lazy to reboot and I hate Windoze will just have to if I need to run Macros.

Crossover:

http://www.codeweavers.com/products/cxlinux/

Ever seen internet explorer on Linux?.....it'll bend your brain!

 

[WarmBeer]

blah blah blah. pipe down consumerist boy. i know you drove a european car and live in a swanky suburb which hasn't got even one crack house. and i'm sure i remember you throwing away your red beret and cutting your hair off years ago.

love to SWMBO and the kids.

OMG what a shock! Anyone who has met this guy IRL has heard a variant of this speech 1000 times



I still love ya bud

(And OT, love this spreadsheet too)

You two can go f%$k yourselves, I hope your hops turn to weevils, and your next 3 brews taste like VB

(Harsh, harsh words, but well deserved)

 

[zebba]

:icon_offtopic: (sorry)

You two can go f%$k yourselves, I hope your hops turn to weevils, and your next 3 brews taste like VB

(Harsh, harsh words, but well deserved)

Well, I'll be giving you some of those brews and you'll HAVE to either drink 'em or put up with me hassling you to drink them, so jokes on you buddy!

 

[ianh]

Hi

Copy of version 2.0 of the spreadsheet.

View attachment Kit___Extract_Beer_Designer_V2.0.xls

I have added the ability to save, retrieve, and delete recipes, which are saved on a Recipes Worksheet. You can add Comments to the recipes but other than that don't change the Recipes Worksheet.

I have input a few recipes as examples mainly taken from AHB with a bit of poetic licence. You can add and delete what you want but there must be a least one recipe on the worksheet.

The Main Worksheet has been changed slightly and you now have four Macro buttons at the bottom plus to save a recipe you need to give it a name and there is now cell for this.

I have also added the option to use D or d for dry hopping, doesn't affect the IBU calcs but shows up on the Brewday worksheet and the the recipe database.

Also changed the bulk prime weights for Sucrose now 9% less than dextrose rather than 15% (dextrose monohydrate contains 9% water whereas the 15% value from from a website on bulk priming).

Hope you enjoy.

cheers

Ian

 

[Interloper]

One big fat shiny gold star for you and your efforts.

THANKS!!!

 

[Philthy79]

One big fat shiny gold star for you and your efforts.

THANKS!!!

+1 :icon_cheers:

 

[shark]

Great little spreadsheet. Have been playing with it day at work. TOP EFFORT THANKS!

 

[wyethm]

Thanks Ian. Version 2 is great.

Cheers

Mark

 

[roverfj1200]

Thanks running cross over in Ubuntu and Office 2000..

 

[robbo5253]

Hey Ian,

This is fantastic! Going to make life so much easier for me.

Possible suggestion for future version:
Have a shopping list button that adds the ingredients into a list, to make ordering for a number of brews easier.

With this you can enter or get from the database your next 4 brews and hit the shopping list button and then just go and order what you need from one of the sponsors.

Thanks again

Cheers and Beers

Robbo

 

[BjornJ]

Unable to add base malt?


I am sure this is a obvious one, but I am unable to find a base malt in the drop down list of grains?

I click on "new recipe", choose a style of beer and want to add grains, starting with a base malt.
Which grain type do I choose as a base malt, thinking pale malt or pilsner malt.

Brilliant spreadsheet, sure it's just me

thanks
Bjorn

 

[robbo5253]

Bjorn,

Try under the DME section just above that

Cheers

Robbo

 

[BjornJ]

Ok, so I add the dried malt extract and the grain section is for adding some specialty grains.
I thought I could add a base malt and play with all grain recipes.

I have added a kg of dme and playing with a recipe now, great fun to see how the IBU and colour changes, how it compares with the style, etc.

thanks
Bjorn

 

[ianh]

Hey Ian,

This is fantastic! Going to make life so much easier for me.

Possible suggestion for future version:
Have a shopping list button that adds the ingredients into a list, to make ordering for a number of brews easier.

With this you can enter or get from the database your next 4 brews and hit the shopping list button and then just go and order what you need from one of the sponsors.

Thanks again

Cheers and Beers

Robbo

Could be done, some people are more organised than me. I have an idea of what I want to brew so I just buy stuff then decide what to brew. Might have to change my thinking.

I am currently planning to incorporate yeasts and a brewlog worksheet into the spreadsheet but things are at a standstill at the moment as my C drive failed and am waiting a replacement.

cheers

Ian

 

[ianh]

Unable to add base malt?


I am sure this is a obvious one, but I am unable to find a base malt in the drop down list of grains?

I click on "new recipe", choose a style of beer and want to add grains, starting with a base malt.
Which grain type do I choose as a base malt, thinking pale malt or pilsner malt.

Brilliant spreadsheet, sure it's just me

thanks
Bjorn

No base malts on the spreadsheet, only speciality malts that can be steeped.

 

[Sydneybrewer]

this is probably the best piece of information i have gained off this site so far +1 it overtook the advice that airlock bubbles mean nothing. :lol:

 

[ianh]

Hi All

I have created Version 2.1 of the spreadsheet

View attachment Kit___Extract_Beer_Designer_V2.1.xls

I have added a yeasts worksheet and incorporated yeasts into the Main worksheet, so you can specify the yeast used. It then uses an average attenuation value for that yeast in the calculations.

I have also incorporated a brews worksheet so you can record all your brews. (I have left a couple of my brews in there to show as an example, just delete these rows to enter your brews.

The info on the Brewday worksheet can be incorporated into the Brews worksheet as a Comment. To do this, on the Brews worksheet select the required cell in Column C and then press the Control and C keys. This will run a macro which will copy Brewday worksheet cells B1:I50 to the cell as a comment. It requires that you have a copy of MSWord on you computer as the macro copies the info into Word and then to the Cell Comments.

I had a couple of problems running the spreadsheet on the XP version of Excel but hopefully now fixed.

Hope you enjoy

cheers

Ian

 

[Sydneybrewer]

+1 oh patron saint of extract beer spreadsheets

 

[olde]

Nice one mate, thanks very much.

 

[damof]

Thanks Ian, top stuff.

One thing I noticed is that you can't select all the kits in the list. For example I want to select from the drop down list a black rock kit but its not there. They are shown in the Kits Sheet but not in the drop down list. Hope this makes sense.

But yeah great spreadsheet, especially for someone just starting out like me.