Hops Group Buy in Chicago #1 - Page 24 - Home Brew Forums
Register Now For Free!

Home Brew Forums > Home Brew Market > Group Buys > Hops Group Buy in Chicago #1

Closed Thread
 
Thread Tools
Old 11-15-2012, 10:07 PM   #231
ghoti
 
ghoti's Avatar
Recipes 
 
Dec 2010
Naperville, Illinois
Posts: 306
iTrader: (1)
Liked 20 Times on 15 Posts


Quote:
Originally Posted by dbrewski View Post
Cover your eyes, SQL follows!

select variety, SUM(lb_ordered) from hops group by variety

this is what would be nice to see in real time.
This is available to admins only.

 
Old 11-15-2012, 10:13 PM   #232
TheBreweryUnderground
Recipes 
 
Dec 2011
Nelsonville, Ohio
Posts: 335
iTrader: (0)
Liked 18 Times on 14 Posts


It would be nice to see who's getting bumped beforehand to see if I should adjust my purchase to other hops and maybe people buying up a lot would let others in for a pound.
__________________
“… Besides, the Word is the principal part of baptism. If in an emergency there’s no water at hand, it doesn’t matter whether water or beer is used.” ~Martin Luther

 
Old 11-15-2012, 10:23 PM   #233
ghoti
 
ghoti's Avatar
Recipes 
 
Dec 2010
Naperville, Illinois
Posts: 306
iTrader: (1)
Liked 20 Times on 15 Posts


I can send out a list of all the bumps tonight based on where we currently stand with Cascade, Hallertau, Saaz, and Simcoe. I think the only one that is going to be a big surprise is the Simcoe. If you are open on any of the Cascade, you will not be making the cut unless folks order 42 pounds. If you ordered Hallertau, you need to 18 more pounds or all get bumped. If you ordered Saaz, you need 26 pounds to be ordered or you get bumped.

 
Old 11-15-2012, 10:35 PM   #234
dbrewski
 
dbrewski's Avatar
Recipes 
 
Oct 2011
Indeterminate
Posts: 1,011
iTrader: (0)
Liked 52 Times on 46 Posts


Quote:
Originally Posted by ghoti View Post
I was updating the data as there was more that 11 people on a couple of splits which would have caused some problems.

Also he is the updated totals pounds per type. Be aware these totals include outstanding splits, so for those that require 44 we need them to be 4 or 8 complete orders to purchase. If over then we will remove those splits over the 44 lb limit.

AHTANUM 2
AU TOPAZ 3
CASCADE 5
CENTENNIAL TYPE 4
COLUMBUS 2
GR HALLERTAU 2
GR MAGNUM 2
HALLERTAU 3
NZ MOTUEKA 3
PERLE 2
SAAZ 2
SIMCOE 7
STYRIAN GOLDING 2
TETTNANG 2
UK EAST KENT GOLDING 2
UK FUGGLE 3
WARRIOR 2
WILLAMETTE 2
ZYTHOS 5
I'm not quite following...the earlier spreadsheet showed 52lbs of Simcoe, this shows 7?

[EDIT] oh is this 11lb groupings?

 
Old 11-15-2012, 10:43 PM   #235
hopplease
Recipes 
 
Jan 2011
, Indiana
Posts: 78
iTrader: (0)

I still couldn't log in last night when I tried. I thought I recorded my password correctly to my memory besides that, not sure what else I could be doing wrong?

 
Old 11-15-2012, 10:44 PM   #236
ghoti
 
ghoti's Avatar
Recipes 
 
Dec 2010
Naperville, Illinois
Posts: 306
iTrader: (1)
Liked 20 Times on 15 Posts


Yes those are the number of 11 pounds ordered

 
Old 11-15-2012, 10:48 PM   #237
sudsmcgee
 
sudsmcgee's Avatar
Recipes 
 
May 2010
Western Chicago Burbs, IL
Posts: 1,515
iTrader: (0)
Liked 50 Times on 42 Posts


I added 2 more lbs of cascades to help us meet the 44 minimum. I'll sell them to a friend who's not on the buy.

We do need a 44 lb minimum order for cascade, right?
__________________
"If you're here for the premature ejaculators meeting, you've come too soon."

 
Old 11-15-2012, 10:53 PM   #238
ghoti
 
ghoti's Avatar
Recipes 
 
Dec 2010
Naperville, Illinois
Posts: 306
iTrader: (1)
Liked 20 Times on 15 Posts


Yes we are currently over by a couple of pounds

 
Old 11-15-2012, 10:53 PM   #239
Brewenstein
Recipes 
 
Apr 2009
West Suburbs of Chicago
Posts: 676
iTrader: (1)
Liked 104 Times on 75 Posts


Think I ordered 2 pounds cascade, 1 pound centennial, 1 pound perle, but I really can't tell. All I can see is the available splits. Am I missing something?

 
Old 11-15-2012, 10:57 PM   #240
dbrewski
 
dbrewski's Avatar
Recipes 
 
Oct 2011
Indeterminate
Posts: 1,011
iTrader: (0)
Liked 52 Times on 46 Posts


Somebody closed out the warrior, good deal. I just added a pound of Simcoe to close out a split...hopefully that gets us to 8 11lb splits?

I am getting more simcoe than I need to do this, but I don't want to end up with zero because we didn't make 88 lbs.

 
Closed Thread
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Group Buy in Chicago #6 bmason1623 Group Buys 1380 03-16-2014 12:44 AM
Group Buy in Chicago #5 bmason1623 Group Buys 1068 03-16-2014 12:44 AM
Group Buy in Chicago #3 bmason1623 Group Buys 338 03-16-2014 12:42 AM
Group buy in Chicago #2? bmason1623 Group Buys 268 03-16-2014 12:42 AM
Group buy in Chicago? bmason1623 Group Buys 421 03-16-2014 12:41 AM


Forum Jump