New Giveaway - Wort Monster Conical Fermeneter!

Home Brew Forums > Home Brewing Beer > General Beer Discussion > I Propose a Little Game




Reply
 
LinkBack Thread Tools Display Modes
Old 12-12-2012, 06:25 PM   #41
nutty_gnome
Feedback Score: 0 reviews
 
nutty_gnome's Avatar
Recipes 
 
Join Date: Jan 2009
Location: NJ
Posts: 1,031
Liked 43 Times on 36 Posts
Likes Given: 12

Default

BUG FIX: I went back through the logic and fixed an issue where you get a SMASH 50% of the time. It is much, much less likely now.

The basic logic is that the spreadsheet decides how many malts will be in the beer with a max of 7. At least one malt MUST be a basemalt and basemalts make up at least 75 percent of the grist. You can change that value if you like. There could be up to 7 basemalts in a beer though from the random number generator.

If there are less than 7 basemalts, it checks to see if crystal malts made their saving through. If so, it decides how many Crystals malts will go in (up to 6 from the long list) and then Roasted Malts get a chance to make a saving throw and if so, it adds them. (up to 6 from the long list). Then it figures how many hop varieties go into the beer (5 max) and picks the names. Its a little more complex than that, but you can noodle through it.

To make this work, you need to enable macros for this worksheet and you need to turn your calculation setting to manual. F9 is the default recalculation key if you need to use it.

If you know much about excel its pretty easy to go in and add and subtract ingredients, but if you change the number of each you need to futz with the calculations which should be self evident. The 'main' sheet is only a condensed print-out of the 'background' sheet which has all the data tables, IF statements and the VLOOKUP statements. If I had to do it again, I would vastly simplify the data tables to allow user additions and provide the ability to specify upper RANDBETWEEN values on the fly. Maybe I'll do it later.

Here is a dropbox link to the Excel Macro-Enabled file: https://dl.dropbox.com/u/76184517/Random%20Beer%20generator.xlsm



__________________

N_G
It could be worse.

nutty_gnome is offline
 
Reply With Quote Quick reply to this message
Old 12-12-2012, 09:21 PM   #42
Seedly
Feedback Score: 0 reviews
Recipes 
 
Join Date: Mar 2012
Location: Broomfield, CO
Posts: 86
Liked 13 Times on 10 Posts
Likes Given: 6

Default

I REALLY REALLY want to laugh at this, but then I remember that I have more than a few d'n' dice in a lovely box labeled "Battletech" somewhere in my mom's basement and I actually went looking for it over Thanksgiving....hey, theres a tech readout 2750 in there!

Anyway, I am so much on board with this and think I might just be taking nutty gnome's sheet and going to another level. A little randbetween() here and some if(if(if(if(if()))) there...

...yes, this could shape up nicely...

__________________
Seedly is offline
 
Reply With Quote Quick reply to this message
Old 12-13-2012, 12:51 AM   #43
nutty_gnome
Feedback Score: 0 reviews
 
nutty_gnome's Avatar
Recipes 
 
Join Date: Jan 2009
Location: NJ
Posts: 1,031
Liked 43 Times on 36 Posts
Likes Given: 12

Default

There is surely a lot that could be done. Have fun and share what you create!

I was hitting the recalculate button a few hundred times today and looking at the output. It was amusing to see that some of the beers looked worthy of a brew day.

__________________

N_G
It could be worse.

nutty_gnome is offline
 
Reply With Quote Quick reply to this message
Reply


Quick Reply
Message:
Options
Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Propose Orange Blossom Honey Wheat MizooBrew Recipes/Ingredients 5 05-11-2012 10:30 AM
New to the game Forestgrover Wine Making Forum 3 08-16-2007 09:49 PM
new to the game Oakwood Wine Making Forum 5 05-29-2007 08:56 PM