HBT 2015 Big Giveaway - Enter Now

Huge Supporting Membership Discounts - 20% Off

 Home Brew Forums > I Propose a Little Game
12-12-2012, 06:25 PM   #41
nutty_gnome
Feedback Score: 0 reviews

Recipes

Join Date: Jan 2009
Location: Princeton, Nj
Posts: 1,194
Liked 70 Times on 57 Posts
Likes Given: 20

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/Ra...generator.xlsm

__________________

N_G
It could be worse.

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

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

__________________

12-13-2012, 12:51 AM   #43
nutty_gnome
Feedback Score: 0 reviews

Recipes

Join Date: Jan 2009
Location: Princeton, Nj
Posts: 1,194
Liked 70 Times on 57 Posts
Likes Given: 20

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.