Zero2Cool
11 years ago
Some have asked to see a percentage. This is not feasible to have a sort by this because someone could easily pick the 'locks' and get a high percentage. But for fun, I threw together a query and got something to show for kicks.


Name	Picks	Correct	
OSOGRANDE	16	12	75.00%
OlHoss1884	90	61	67.78%
dhazer	93	63	67.74%
Maverick	93	61	65.59%
gbguy20	63	41	65.08%
Wade	62	40	64.52%
steveishere	64	41	64.06%
buckeyepackfan	93	59	63.44%
wpr	93	59	63.44%
Zero2Cool	93	59	63.44%
Tezzy	90	57	63.33%
Gaycandybacon	32	20	62.50%
gbpfan	16	10	62.50%
Pack93z	93	58	62.37%
yooperfan	92	57	61.96%
macbob	76	47	61.84%
rlyon	44	27	61.36%
porky88	75	46	61.33%
The_Green_Ninja	15	9	60.00%
hardrocker950	93	55	59.14%
GoPack1984	93	54	58.06%
GermanGilbert	75	43	57.33%
beast	93	53	56.99%
SINCITYCHEEZE	93	50	53.76%
DoddPower	16	8	50.00%


UserPostedImage
wpr
  • wpr
  • Preferred Member
11 years ago
boy do I stink when it comes to picking. I will stay out of Vegas.
UserPostedImage
Pack93z
11 years ago
Might want to check that query... Wayne has made over 200 picks? [grin1]
"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
Zero2Cool
11 years ago

Might want to check that query... Wayne has made over 200 picks? [grin1]

Originally Posted by: Pack93z 



When you make 214 picks on September 10th, 2013, that'll be the case. The query takes all picks made and doesn't use a parameter for 'up to' the current week.
UserPostedImage
Pack93z
11 years ago

When you make 214 picks on September 10th, 2013, that'll be the case. The query takes all picks made and doesn't use a parameter for 'up to' the current week.

Originally Posted by: Zero2Cool 



Ahh... so he has filled in his picks for the year already forward.. makes sense.. but it also highlights a problem as well.. the picks for this week are going to be misses as there is no result yet.

Can it be queried if the winning/correct team is not null?
"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
Zero2Cool
11 years ago

Ahh... so he has filled in his picks for the year already forward.. makes sense.. but it also highlights a problem as well.. the picks for this week are going to be misses as there is no result yet.

Can it be queried if the winning/correct team is not null?

Originally Posted by: Pack93z 



Yes sir. It's more so just a glimpse that it can be done. I had a stumbling block on a work project and my mind went awry. šŸ™‚

The structure of the database tables ... has room for improvement, but still offers a lot of flexibility to do as you suggest.

Easiest addition would be to add a condition that

AND GameDateTime < GetDate()

I think that would ensure the game has to be played or ... my mind just went blank. Lost my thought. I'll come back later if it comes back.
UserPostedImage
Pack93z
11 years ago
LOL.. know the blank mind feeling.. people at times walk in here and I am probably zombie like.. lost in thought.. code or something.. lol.
"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"
wpr
  • wpr
  • Preferred Member
11 years ago

When you make 214 picks on September 10th, 2013, that'll be the case. The query takes all picks made and doesn't use a parameter for 'up to' the current week.

Originally Posted by: Zero2Cool 



swell now everyone will want to pick early.

BTW- does it change the data above when I come back and revise my picks later? (That is not counted as selecting twice?)


UserPostedImage
Zero2Cool
11 years ago

swell now everyone will want to pick early.

BTW- does it change the data above when I come back and revise my picks later? (That is not counted as selecting twice?)

Originally Posted by: wpr 



Yes.
UserPostedImage
wpr
  • wpr
  • Preferred Member
11 years ago

Yes.

Originally Posted by: Zero2Cool 



Since I have voted early, over the course of the season I have changed my vote on a few games each week.
UserPostedImage
Fan Shout
beast (4h) : Wow, 95% drop in investment revenue? Would be interesting to hear the details of why...
dfosterf (25-Jul) : It's my one day deal complaint dept. on shareholder meeting day
dfosterf (25-Jul) : Probably a homer access credential intimidation kinda thing
dfosterf (25-Jul) : Meathead "journalists" skip this, concentrating on operational revenue when convenient. They switch when net revenue is more favorable.
dfosterf (25-Jul) : Resulting in an actual drop of net revenue of 12.5%. She is from Minnesota. Just sayin'
dfosterf (25-Jul) : Any plans to hold Maureen Smith (CFO) accountable for a 95% drop in investment revenue?
Mucky Tundra (25-Jul) : In your face, HBO!
Mucky Tundra (25-Jul) : @ByRyanWood Mark Murphy: ā€œA great source of pride of mine is that we were never on Hard Knocks.ā€
Mucky Tundra (25-Jul) : *years
Mucky Tundra (25-Jul) : @mattschneidman Mark Murphy says he anticipates ā€œmany Packers gamesā€ being played in Germany, Ireland and/or the U.K. over the next 5-10 yea
dfosterf (25-Jul) : *cafeteria* I have hit my head also, so I sympathize
dfosterf (25-Jul) : Possibly hit his head leaning into the glass protecting the food in the cafateria
dfosterf (25-Jul) : Maybe a low flying drone
dfosterf (25-Jul) : Did Savion Williams run into a goalpost or something?
Mucky Tundra (25-Jul) : also, no bueno when a guy starts getting concussions right off the bat in his career
Zero2Cool (25-Jul) : Concussion is worse. Banks probably vet off day via back booboo claim
Mucky Tundra (25-Jul) : @AndyHermanNFL Jordy Nelson out at camp today. No word if he’s in play for one of the two open roster spots ; )
dfosterf (25-Jul) : Is that better or worse than Banks bad back?
Zero2Cool (25-Jul) : Savion concussion ... not good.
packerfanoutwest (24-Jul) : Aaron Rodgers’s first pass of first team period was picked off
Mucky Tundra (24-Jul) : tbh I didn't hear of his passing
Zero2Cool (24-Jul) : Cosby Show. Malcom Jamal Warner I think is real name
Mucky Tundra (24-Jul) : I was thinking of Ozzy and Hulk
Mucky Tundra (24-Jul) : Who's Theo?
Zero2Cool (24-Jul) : How is Theo alliteration?
Mucky Tundra (24-Jul) : Bad week for people whose names are alliterations
Zero2Cool (24-Jul) : Hulk Hogan gone too.
Zero2Cool (24-Jul) : Oh, it's toe injury
Zero2Cool (24-Jul) : Hope it's not serious. that would stink
dfosterf (24-Jul) : Sounds like an ankle not a knee for Fields
dfosterf (24-Jul) : Ya Flaccp on Browns
Zero2Cool (24-Jul) : Maybe Tyrod Taylor instead
Zero2Cool (24-Jul) : He's on Browns, right?
dfosterf (24-Jul) : They would probably go with Flacco is my guess if Fields out
dfosterf (24-Jul) : Fleece 'em again!
Zero2Cool (24-Jul) : Malik Willis might be someone Jets come after
packerfanoutwest (24-Jul) : Packers introduce 1923-inspired classic uniform, leather-look helmet
Zero2Cool (23-Jul) : Both LB Quay Walker and Rookie DB Micah Robinson have passed their physicals
Zero2Cool (23-Jul) : Happy to see site feels more snappy snappy
Zero2Cool (23-Jul) : No sir. I did not.
dfosterf (23-Jul) : You didn't get free childcare when you were at work?
wpr (23-Jul) : These guys make hundreds of thousands of dollars a year. Pay for their own childcare.
dfosterf (23-Jul) : 2nd issue. Number 1 issue was no gameday childcare. 1 of 3 teams not providing it
Zero2Cool (23-Jul) : Suppose if locker room is main issue, we sitting pretty
wpr (23-Jul) : I thought so Mucky. In those useless player polls GB always rates high overall. Locker is a part of it.
Mucky Tundra (23-Jul) : Wasn't the locker room just updated like 6 or 7 years ago?
Zero2Cool (23-Jul) : I have forum updated on different site. We'll see how this one goes before going to that
Zero2Cool (23-Jul) : Elgton Jenkins has a back injury, is expect to end contract dispute
wpr (23-Jul) : It's funny the PA complained about the locker room. It wasn't that long ago it was top shelf. Things change in a hurry.
wpr (23-Jul) : The site is much more better.
Please sign in to use Fan Shout
2025 Packers Schedule
Sunday, Sep 7 @ 3:25 PM
LIONS
Thursday, Sep 11 @ 7:15 PM
COMMANDERS
Sunday, Sep 21 @ 12:00 PM
Browns
Sunday, Sep 28 @ 7:20 PM
Cowboys
Sunday, Oct 12 @ 3:25 PM
BENGALS
Sunday, Oct 19 @ 3:25 PM
Cardinals
Sunday, Oct 26 @ 7:20 PM
Steelers
Sunday, Nov 2 @ 12:00 PM
PANTHERS
Monday, Nov 10 @ 7:15 PM
EAGLES
Sunday, Nov 16 @ 12:00 PM
Giants
Sunday, Nov 23 @ 12:00 PM
VIKINGS
Thursday, Nov 27 @ 12:00 PM
Lions
Sunday, Dec 7 @ 12:00 PM
BEARS
Sunday, Dec 14 @ 3:25 PM
Broncos
Friday, Dec 19 @ 11:00 PM
Bears
Friday, Dec 26 @ 11:00 PM
RAVENS
Saturday, Jan 3 @ 11:00 PM
Vikings
Recent Topics
4h / Green Bay Packers Talk / beast

4h / Green Bay Packers Talk / beast

25-Jul / Around The NFL / Mucky Tundra

25-Jul / Green Bay Packers Talk / Mucky Tundra

25-Jul / Green Bay Packers Talk / TheKanataThrilla

25-Jul / Green Bay Packers Talk / dfosterf

25-Jul / Around The NFL / beast

24-Jul / Green Bay Packers Talk / Martha Careful

24-Jul / Around The NFL / beast

24-Jul / Green Bay Packers Talk / Mucky Tundra

23-Jul / Green Bay Packers Talk / beast

23-Jul / Green Bay Packers Talk / wpr

22-Jul / Random Babble / Zero2Cool

22-Jul / Green Bay Packers Talk / Zero2Cool

22-Jul / Green Bay Packers Talk / Zero2Cool

Headlines
Copyright Ā© 2006 - 2025 PackersHome.comā„¢. All Rights Reserved.