Coldbreak Brewing Giveaway - Open to All!

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
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
dbrewski's Avatar
Recipes 
 
Join Date: Oct 2011
Location: Indeterminate
Posts: 1,028
iTrader: (0)
Liked 52 Times on 46 Posts
Likes Given: 39

Default

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


dbrewski is offline
 
Old 11-15-2012, 09:44 PM   #222
itrider
Feedback Score: 0 reviews
Recipes 
 
Join Date: Dec 2011
Location: Plainfield, IL
Posts: 26
iTrader: (0)
Default

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.


itrider is offline
 
Old 11-15-2012, 09:46 PM   #223
bmason1623
HBT_SUPPORTER.png
Feedback Score: 2 reviews
 
bmason1623's Avatar
Recipes 
 
Join Date: Sep 2010
Location: Chicago, IL
Posts: 2,832
iTrader: (2)
Liked 151 Times on 118 Posts
Likes Given: 165

Default

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
bmason1623 is offline
 
Old 11-15-2012, 09:57 PM   #224
sudsmcgee
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
sudsmcgee's Avatar
Recipes 
 
Join Date: May 2010
Location: Western Chicago Burbs, IL
Posts: 1,521
iTrader: (0)
Liked 49 Times on 41 Posts
Likes Given: 52

Default

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."
sudsmcgee is offline
 
Old 11-15-2012, 09:59 PM   #225
ghoti
Feedback Score: 1 reviews
Recipes 
 
Join Date: Dec 2010
Location: Naperville, Illinois
Posts: 307
iTrader: (1)
Liked 20 Times on 15 Posts
Likes Given: 2

Default

there is an open simcoe for 1 lb
ghoti is offline
 
Old 11-15-2012, 10:01 PM   #226
dbrewski
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
dbrewski's Avatar
Recipes 
 
Join Date: Oct 2011
Location: Indeterminate
Posts: 1,028
iTrader: (0)
Liked 52 Times on 46 Posts
Likes Given: 39

Default

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
dbrewski is offline
 
Old 11-15-2012, 10:01 PM   #227
sudsmcgee
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
sudsmcgee's Avatar
Recipes 
 
Join Date: May 2010
Location: Western Chicago Burbs, IL
Posts: 1,521
iTrader: (0)
Liked 49 Times on 41 Posts
Likes Given: 52

Default

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."
sudsmcgee is offline
 
Old 11-15-2012, 10:05 PM   #228
sudsmcgee
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
sudsmcgee's Avatar
Recipes 
 
Join Date: May 2010
Location: Western Chicago Burbs, IL
Posts: 1,521
iTrader: (0)
Liked 49 Times on 41 Posts
Likes Given: 52

Default

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."
sudsmcgee is offline
 
Old 11-15-2012, 10:05 PM   #229
dbrewski
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
dbrewski's Avatar
Recipes 
 
Join Date: Oct 2011
Location: Indeterminate
Posts: 1,028
iTrader: (0)
Liked 52 Times on 46 Posts
Likes Given: 39

Default

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.
dbrewski is offline
 
Old 11-15-2012, 10:06 PM   #230
ghoti
Feedback Score: 1 reviews
Recipes 
 
Join Date: Dec 2010
Location: Naperville, Illinois
Posts: 307
iTrader: (1)
Liked 20 Times on 15 Posts
Likes Given: 2

Default

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


ghoti is offline
 
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

Newest Threads

LATEST SPONSOR DEALS