Newest Threads

**ghoti** · 11-15-2012, 09:07 PM

Quote:

Originally Posted by dbrewski

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.

TheBreweryUnderground · 11-15-2012, 09:13 PM

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.

**ghoti** · 11-15-2012, 09:23 PM

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.

**dbrewski** · 11-15-2012, 09:35 PM

Quote:

Originally Posted by ghoti

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?

hopplease · 11-15-2012, 09:43 PM

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?

**ghoti** · 11-15-2012, 09:44 PM

Yes those are the number of 11 pounds ordered

**sudsmcgee** · 11-15-2012, 09:48 PM

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?

**ghoti** · 11-15-2012, 09:53 PM

Yes we are currently over by a couple of pounds

Brewenstein · 11-15-2012, 09:53 PM

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?

**dbrewski** · 11-15-2012, 09:57 PM

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.