Hops Group Buy in Chicago #1

[bmason1623]

This is available to admins only.

Is it something that my neophyte self can do?

 

[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.

Is it something that my neophyte self can do?

I know this is an admin function, I was just expressing what I felt we needed to see, using shorthand. Total pounds ordered of each variety.

 

[ghoti]

I know this is an admin function, I was just expressing what I felt we needed to see, using shorthand. Total pounds ordered of each variety.

It is only needed in this case because of the limits. I just am not going to spend my time doing one off functionality versus building out features that will be needed on going.

 

[dbrewski]

The data you posted filled my request quite well, no further work needed. Great job on all the development so far.

 

[ghoti]

I know this is an admin function, I was just expressing what I felt we needed to see, using shorthand. Total pounds ordered of each variety.

Also this is only needed for the 4 varieties which by my post above will let you know where we stand. I do not mean to come off short but a lot I work has been spent in the past few days getting things working so this can be done. Rebuilding functionality is just not high on my list.

 

[ghoti]

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?

If you so not see your items then you have nothing ordered. I know centennial was pulled maybe peeled was as well.

 

[Face Eater]

Yes we are currently over by a couple of pounds

If we're over on cascade I can cut a few pounds. I ordered extra to help us meet the requirement. With simcoe as well so let me know.

I don't need nearly as much as I ordered haha. Just trying to help out.

 

[bmason1623]

spreadsheet updated

 

[TheBreweryUnderground]

So it looks like we need another 11# of Simcoe, who is in on that goofy Simcoe split 3 ways? It would be nice if they fixed it and then hopefully we could get an even 88# ordered.

 

[ghoti]

I updated the 2/3 to split of 11 so that is fixed.

 

[Neopol]

I just added11# simcoe..that'll help

 

[ghoti]

OK, nobody open any more Simcoe. We just need to fill out the remaining outstanding.

 

[mikescooling]

I'm heading to northern Wi deer hunting this weekend. I'm going to be out in the sticks (no internet). I can pay now or on my way out of town Friday, or when I come back monday night. Or I can drive into a town to get wi-fi, if we know when this thing is going to end?
Where is the spread sheat? How do I see my name? I can loge onto the add hops link. I can add hops, but it only show my closed/open shares, is there another spread sheet that I can see?

 

[bmason1623]

I'm heading to northern Wi deer hunting this weekend. I'm going to be out in the sticks (no internet). I can pay now or on my way out of town Friday, or when I come back monday night. Or I can drive into a town to get wi-fi, if we know when this thing is going to end?
Where is the spread sheat? How do I see my name? I can loge onto the add hops link. I can add hops, but it only show my closed/open shares, is there another spread sheet that I can see?

check your PM for the spreadsheet link

 

[dbrewski]

From the spreadsheet...total pounds per variety, this is not splits:

AHTANUM 9
CASCADE 39
CENTENNIAL TYPE 31
COLUMBUS 2
CZ SAAZ 1
GR HALLERTAU 1
GR MAGNUM 1
HALLERTAU 4
Hop Vareity 0
NZ MOTUEKA 12
PERLE 3
SAAZ 7
SIMCOE 71
STYRIAN GOLDING 3
SUMMIT 4
TETTNANG 4
UK EAST KENT GOLDING 11
UK FUGGLE 11
WARRIOR 11
WILLAMETTE 6
ZYTHOS 33

 

[mux]

Where's the spreadsheet?

 

[FourSeasonAngler]

Where's the spreadsheet?

* I just popped for the last LB of Centennial Type, so it's closed out.

 

[sudsmcgee]

Someone please help close cascade and centennial! I can't store any more hops properly!

 

[bmason1623]

link address removed


* I just popped for the last LB of Centennial Type, so it's closed out.

please remove this from public sight. thanks

 

[itrider]

Someone please help close cascade and centennial! I can't store any more hops properly!

Centennial is not showing any longer in the list dashboard; but I added another cascade to help

 

[bmason1623]

please do not post my links in public.

 

[bmason1623]

i am going to have to make a new spreadsheet since the link was publicly posted. the sheet has price sensitive information that is meant for group buy participants. please do not post the link publicly.

 

[PseudoChef]

I'm so ****ing confused right now.

 

[dbrewski]

Someone please help close cascade and centennial! I can't store any more hops properly!

It looks like 4 more pounds of cascade would close it. 2 more pounds of Ahtanum, anyone? I already have 2. And if Neopol added 11lbs of Simcoe after the spreadsheet it looks like (?) this split would take us to 88. That's 7 more lbs to close it.

Unfortunately if we don't close that Simcoe split we will lose 44lbs.

 

[bmason1623]

New spreadsheet and new link is in the database notes section. Please do not post anything with pricing information in public. thanks.

 

[ghoti]

We are over on Cascade, so if you are in the active split it will be removed unless we get another 37 pounds.

 

[dbrewski]

ok I will update this with the latest spreadsheet, but this is current as of spreadsheet #2. These are pounds ordered on that spreadsheet, followed by my notes showing what I think needs to happen to close the splits. This is most likely not 100% accurate! But it might clear up the picture a bit. The pounds ordered and the pounds needed don't always match...people are adding and dropping pounds, so my notes are off the current splits website.

AHTANUM 9 needs 2 to close
CASCADE 39 needs 4 to close
CENTENNIAL TYPE 31 closed
COLUMBUS 2 needs 9 to close
CZ SAAZ 1 ? if a split is 11lbs, needs 4 more
GR HALLERTAU 1 ? if a split is 11lbs, needs 2 more
GR MAGNUM 1 need 9 more to close
HALLERTAU 4 this is a 44lb minimum, right?
NZ MOTUEKA 12 looks closed but why 12 instead of 11?
PERLE 3 needs 8 more
SAAZ 7 this is a 44lb minimum, may not close?
SIMCOE 71 if Neopol added 11, this sits at 82, need 88
STYRIAN GOLDING 3 need roughly 9 more to close (someone drop one?)
SUMMIT 4 need 6 more to close
TETTNANG 4 need 7 more to close
UK EAST KENT GOLD 11 closed
UK FUGGLE 11 closed
WARRIOR 11 closed
WILLAMETTE 6 need 6 to close
ZYTHOS 33 closed

 

[sudsmcgee]

It looks like 4 more pounds of cascade would close it. 2 more pounds of Ahtanum, anyone? I already have 2. And if Neopol added 11lbs of Simcoe after the spreadsheet it looks like (?) this split would take us to 88. That's 7 more lbs to close it.

Unfortunately if we don't close that Simcoe split we will lose 44lbs.

Wait, 88 lbs is two full 44 lb splits, no? Why do we need 7 more lbs. I too am so confused right now.

 

[sudsmcgee]

We are over on Cascade, so if you are in the active split it will be removed unless we get another 37 pounds.

Can you please clarify this? Some say we're short and you're saying we're over.

 

[sudsmcgee]

ok. the database has a link for a google docs link that shows who has ordered what, and a waiting list for hops contracts.

How do I get on the hop contract waiting list for next year?