bmason1623
Well-Known Member
ghoti said:This is available to admins only.
Is it something that my neophyte self can do?
ghoti said:This is available to admins only.
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?
dbrewski said: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.
dbrewski said: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.
Brewenstein said: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?
ghoti said:Yes we are currently over by a couple of pounds
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?
Where's the spreadsheet?
Someone please help close cascade and centennial! I can't store any more hops properly!
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.
We are over on Cascade, so if you are in the active split it will be removed unless we get another 37 pounds.
ok. the database has a link for a google docs link that shows who has ordered what, and a waiting list for hops contracts.
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
How do I get on the hop contract waiting list for next year?
If you so not see your items then you have nothing ordered. I know centennial was pulled maybe peeled was as well.
I do see it as ordered, but I see no spread sheet, so I was / am confused. I just want to make sure that I actually have an order so that I am not sending money for something I will not be getting.
Enter your email address to join: