Happy HolidaySs Giveaway - Last Sponsor Giveaway of the Year!

Come Enter the BrewDeals/FastFerment Giveaway!


Home Brew Forums > Home Brew Market > Group Buys > Hops Group Buy in Chicago #1
Closed Thread
 
LinkBack Thread Tools
Old 11-15-2012, 09:37 PM   #221
dbrewski
This is my User Title
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
dbrewski's Avatar
Recipes 
 
Join Date: Oct 2011
Location: Indeterminate
Posts: 1,023
iTrader: (0)
Liked 52 Times on 46 Posts
Likes Given: 36

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
 
Quick reply to this message
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
 
Quick reply to this message
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,816
iTrader: (2)
Liked 150 Times on 117 Posts
Likes Given: 164

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
 
Quick reply to this message
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,517
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
 
Quick reply to this message
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
 
Quick reply to this message
Old 11-15-2012, 10:01 PM   #226
dbrewski
This is my User Title
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
dbrewski's Avatar
Recipes 
 
Join Date: Oct 2011
Location: Indeterminate
Posts: 1,023
iTrader: (0)
Liked 52 Times on 46 Posts
Likes Given: 36

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
 
Quick reply to this message
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,517
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
 
Quick reply to this message
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,517
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
 
Quick reply to this message
Old 11-15-2012, 10:05 PM   #229
dbrewski
This is my User Title
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
dbrewski's Avatar
Recipes 
 
Join Date: Oct 2011
Location: Indeterminate
Posts: 1,023
iTrader: (0)
Liked 52 Times on 46 Posts
Likes Given: 36

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
 
Quick reply to this message
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
 
Quick reply to this message
Closed Thread



Quick Reply
Message:
Options
Thread Tools


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



Newest Threads

LATEST SPONSOR DEALS