Pick'em Percentage · PACKERSHOME

Zero2Cool
Elite Member Topic Starter

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%

Wanna join the discussion?! Login to your PACKERSHOME forum account or Register a new forum account

wpr
Preferred Member

11 years ago

boy do I stink when it comes to picking. I will stay out of Vegas.

Pack93z
Select Member

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
Elite Member Topic Starter

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.

Pack93z
Select 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

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
Elite Member Topic Starter

11 years ago

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.

Pack93z
Select Member

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
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?)

Zero2Cool
Elite Member Topic Starter

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.

wpr
Preferred Member

11 years ago

#10

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.

Important Information:

The PACKERSHOME uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Fan Shout

dfosterf (18-Aug) : We do have good depth at running back imo. Still so frustrating. Bitching about it is a futile excercise, which I plan to do anyway.

Mucky Tundra (17-Aug) : Whoops, I thought Zero was saying it was a surprise the Brewers lost and not Lloyd being hurt

Mucky Tundra (17-Aug) : Not a surprise; inevitable

Zero2Cool (17-Aug) : Brewers streak ends at 14

Zero2Cool (17-Aug) : SURPRISE

Mucky Tundra (17-Aug) : @mattschneidman Matt LaFleur on MarShawn Lloyd: “He’s gonna miss some time.”

Mucky Tundra (16-Aug) : CLIFFORD WITH THE TD WITH UNDER 2 TO GO!!!!!

Zero2Cool (16-Aug) : 90 MINUTES UNTIL FAKE KICKOFF!!

Martha Careful (16-Aug) : I think Ruven is a bot, but regardless should be stricken from the site.

Zero2Cool (14-Aug) : Packers RB Josh Jacobs ranked No. 33 in NFL 'Top 100'

dfosterf (13-Aug) : The LVN Musgrave collision- Andy Herman said Musgrave seemed to be the one most impacted injury-wise

dfosterf (13-Aug) : a lower back injury

dfosterf (13-Aug) : Doubs says he's "fine" after injury scare. Some reported it as z

Mucky Tundra (13-Aug) : With LVN that is; need to see what happens in the next practice

Mucky Tundra (13-Aug) : beast, reading about what happened, it sounded like one of those "two guys collide and are moving slow afterwards" type of deals

beast (12-Aug) : I believe Musgrave has been injured every single season since at least a Sophomore in highschool

packerfanoutwest (12-Aug) : Matt LaFleur: “Highly unlikely” Jordan Love plays more this preseason

dfosterf (12-Aug) : Doubs, Savion Williams, LVN, Musgrave all banged up to one degree or another, missing one here I forget

Zero2Cool (12-Aug) : RB Tyrion Davis-Price is signing with the Green Bay Packers.

Zero2Cool (12-Aug) : zero help, dominated. preseason

beast (12-Aug) : QB Jordan Love has surgery

beast (12-Aug) : Martha said Morgan had a lot of help, I didn't watch the OL so I can't say.

Zero2Cool (10-Aug) : Packers LT Jordan Morgan did not allow a single pressure across 23 pass-blocking snaps vs. Jets last night, per PFF

Mucky Tundra (10-Aug) : With buckeye and the reasonable couple, we're currently sitting at 10

buckeyepackfan (10-Aug) : Just posted to re-up on our FFL.

Zero2Cool (10-Aug) : If healthy after, then thats all I care. Well, no drops would be nice

wpr (10-Aug) : I made it through the 1st Q.

dfosterf (10-Aug) : Just gotta figure out how.

dfosterf (10-Aug) : Could have been a worse start, so there is that.

beast (10-Aug) : Yeah, someone tell the Packers football season has started, seems like they weren't ready for it

Mucky Tundra (10-Aug) : Sooooooo many penalties

Mucky Tundra (10-Aug) : It may only be preseason, but this game is a trip to the dentist

Zero2Cool (10-Aug) : Packers do bad -- FREAK OUT!!!!!!

Zero2Cool (10-Aug) : Packers do good -- eh only preseason

dfosterf (10-Aug) : Well that half was fun

Zero2Cool (10-Aug) : Great, zayne is down

Zero2Cool (9-Aug) : 13 minutes away from kickkkkkkkkkkkkkkkkoffff

Zero2Cool (9-Aug) : Had Celebration of Life for my uncle up north. wicked rain hope it dont come south

Mucky Tundra (9-Aug) : THE GREEN BAY PACKERS ARE PLAYING FOOTBALL TONIGHT!!!!!! THIS IS NOT A DRILL!!!!

Zero2Cool (9-Aug) : Woo-hoo

TheKanataThrilla (9-Aug) : NFL Network is broadcasting the game tonight, but not in Canada. Not sure why as no local television is showing the game.

beast (8-Aug) : But the Return from IR designations had to be applied by the 53 man cutdown.

beast (8-Aug) : It's a new rule, so it's not clear, but my understanding was that they could be IR'd at any time

Mucky Tundra (8-Aug) : *had to be IRed at 53

Mucky Tundra (8-Aug) : beast, I thought the designate return from IR players had to be IR at cutdowns to 53, not before

beast (8-Aug) : It's a brand new rule, either last season or this season, prior, all pre-season IRs were done for the season

beast (8-Aug) : But the Packers would have to use one for their return from IR spots on him, when they cut down to 53.

beast (8-Aug) : I think the NFL recently changed the IR rules, so maybe the season might not be over for OL Glover.

Zero2Cool (8-Aug) : Packers star Howton, first NFLPA prez, dies at 95 😔

dfosterf (8-Aug) : Apparently it is too complicated for several to follow your simple instructions, but I digress

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