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

Closed Thread
 
Thread Tools
Old 11-15-2012, 09:37 PM   #221
dbrewski
Recipes 
 
Oct 2011
Indeterminate
Posts: 1,014
iTrader: (0)
Liked 52 Times on 46 Posts


I know this is a moving target, and people are still adding or moving stuff around, but as of the spreadsheet we had 31lb Cascade, 8lb Saaz, 5lb Hallertau and 52lb Simcoe. All of these were 44lb only. So we are still short on Cascade and someone's going to take less simcoe since I doubt we will make it from 52 to 88 lbs. Looks like Saaz and Hallertau are a wash?

Available in 44#:
4 CASCADE – US = Available in 44# boxes only
7 HALLERTAU – US = Available in 44# boxes only
13 SAAZ – US = Available in 44# boxes only
14 SIMCOE – US = Available in 44# boxes only



 
Old 11-15-2012, 09:44 PM   #222
itrider
Recipes 
 
Dec 2011
Plainfield, IL
Posts: 26
iTrader: (0)

Quote:
Originally Posted by dbrewski View Post
I know this is a moving target, and people are still adding or moving stuff around, but as of the spreadsheet we had 31lb Cascade, 8lb Saaz, 5lb Hallertau and 52lb Simcoe. All of these were 44lb only. So we are still short on Cascade and someone's going to take less simcoe since I doubt we will make it from 52 to 88 lbs. Looks like Saaz and Hallertau are a wash?

Available in 44#:
4 CASCADE – US = Available in 44# boxes only
7 HALLERTAU – US = Available in 44# boxes only
13 SAAZ – US = Available in 44# boxes only
14 SIMCOE – US = Available in 44# boxes only

I think the spreadsheet was in the process or will be updated because of the database problem noted in a few posts earlier.



 
Old 11-15-2012, 09:46 PM   #223
bmason1623
Recipes 
 
Sep 2010
Chicago, IL
Posts: 2,838
iTrader: (2)
Liked 151 Times on 118 Posts


Quote:
Originally Posted by itrider

I think the spreadsheet was in the process or will be updated because of the database problem noted in a few posts earlier.
Yes

 
Old 11-15-2012, 09:57 PM   #224
sudsmcgee
Recipes 
 
May 2010
Western Chicago Burbs, IL
Posts: 1,519
iTrader: (0)
Liked 50 Times on 42 Posts


It looks like I got bumped out on Simcoe. Is anyone willing to part with a lb or two?
__________________
"If you're here for the premature ejaculators meeting, you've come too soon."

 
Old 11-15-2012, 09:59 PM   #225
ghoti
Recipes 
 
Dec 2010
Naperville, Illinois
Posts: 308
iTrader: (1)
Liked 20 Times on 15 Posts


there is an open simcoe for 1 lb

 
Old 11-15-2012, 10:01 PM   #226
dbrewski
Recipes 
 
Oct 2011
Indeterminate
Posts: 1,014
iTrader: (0)
Liked 52 Times on 46 Posts


This is pounds totaled from the spreadsheet...again I realize it is outdated but that doesn't mean the totals are that crazy out of whack in terms of filling 44lb splits:

variety SUM(lb_ordered)
AHTANUM 6
CASCADE 31
CENTENNIAL TYPE 24
COLUMBUS 3
CZ SAAZ 1
GR MAGNUM 1
HALLERTAU 5
NZ MOTUEKA 8
PERLE 2
SAAZ 8
SIMCOE 52
STYRIAN GOLDING 4
TETTNANG 3
UK EAST KENT GOLDING 11
UK FUGGLE 10
WARRIOR 9
WILLAMETTE 6
ZYTHOS 30

 
Old 11-15-2012, 10:01 PM   #227
sudsmcgee
Recipes 
 
May 2010
Western Chicago Burbs, IL
Posts: 1,519
iTrader: (0)
Liked 50 Times on 42 Posts


Now it's showing 2 lbs again. I'm not sure what happened, but that's what I hoped to get.
__________________
"If you're here for the premature ejaculators meeting, you've come too soon."

 
Old 11-15-2012, 10:05 PM   #228
sudsmcgee
Recipes 
 
May 2010
Western Chicago Burbs, IL
Posts: 1,519
iTrader: (0)
Liked 50 Times on 42 Posts


I'm posting this once again for reference to what's available in comparison to what we have ordered to far.

Not Available:
1 AMARILLO – US = NA, sub Zythos
2 AU GALAXY – Australia = NA, sub Zythos
5 CENTENNIAL – US = NA, sub Centennial Type
6 CHINOOK – US = NA, sub Columbus, Northern Brewer or Nugget
8 MAGNUM – US = NA, sub Columbus or Nugget
9 NZ NELSON SAUVIN - New Zealand = NA
10 NZ PACIFIC GEM - New Zealand = NA
11 NZ PACIFIC JADE - New Zealand = NA
12 NZ SOUTHERN CROSS - New Zealand = NA
16 SORACHI ACE – US = NA, sub Zythos
CITRA

Available in 11#:
3 AU TOPAZ – Australia = Available
GR Hallertau is available in 11# boxes
17 STYRIAN GOLDING – US = Available
18 UK EAST KENT GOLDING – UK = Available
19 UK FUGGLE – UK = Available
20 ZYTHOS – US = Available

Available in 44#:
4 CASCADE – US = Available in 44# boxes only
7 HALLERTAU – US = Available in 44# boxes only
13 SAAZ – US = Available in 44# boxes only
14 SIMCOE – US = Available in 44# boxes only
__________________
"If you're here for the premature ejaculators meeting, you've come too soon."

 
Old 11-15-2012, 10:05 PM   #229
dbrewski
Recipes 
 
Oct 2011
Indeterminate
Posts: 1,014
iTrader: (0)
Liked 52 Times on 46 Posts


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.

 
Old 11-15-2012, 10:06 PM   #230
ghoti
Recipes 
 
Dec 2010
Naperville, Illinois
Posts: 308
iTrader: (1)
Liked 20 Times on 15 Posts


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



 
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