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

Zero2Cool (10h) : Tua’s old DC won a Super Bowl Year 1 with Tua’s former backup

Mucky Tundra (12h) : *winning MVP

Mucky Tundra (12h) : Funny observation I've heard: Carson Wentz was on the sideline for both Eagles Super Bowl wins w/guys supposed to be his back up winning

Zero2Cool (18h) : NFL thought it would get more attention week preceding Super Bowl.

Zero2Cool (18h) : Yes, the Pro Bowl. It was played Sunday before Super Bowl from 2010-2022

packerfanoutwest (18h) : pro bowl

Zero2Cool (18h) : From 2010 to 2022, it was played on the Sunday before the Super Bowl

Zero2Cool (18h) : They moved it to the BYE week before Super Bowl several years ago.

packerfanoutwest (18h) : it was always after the SB.....

beast (10-Feb) : Though I stop following pro bowl years ago

beast (10-Feb) : I thought the pro game was before the Super Bowl?

packerfanoutwest (10-Feb) : ok now for the Pro Bowl Game in Hawaii

TheKanataThrilla (10-Feb) : If I was Philly I would try to end it instead of punting it

Mucky Tundra (10-Feb) : VICTORY! We have (moral) victory!

TheKanataThrilla (10-Feb) : Hey they mentioned that we 3-peted

Mucky Tundra (10-Feb) : seems to me the 49ers should have traded Aiyuk when they had the chance

Mucky Tundra (10-Feb) : if the Eagles get it down to the 1, do they Tush Push or give it to Barkley?

TheKanataThrilla (10-Feb) : 49ers have a money problem if they want to sign their QB

Mucky Tundra (10-Feb) : Wait for real? Didn't he just get an extension two years ago?

Zero2Cool (10-Feb) : 49ers gonna trade Deebo. Interesting

TheKanataThrilla (10-Feb) : Replays always never seem to show the holdings

TheKanataThrilla (10-Feb) : Great throw by Hurts

Mucky Tundra (10-Feb) : Where Carter falls prey to bad off the field influences (to be clear, not saying he'd clip someone though)

Mucky Tundra (10-Feb) : Had Carter not gone to Philly were they already had a lot of old college friends, he ends up in a similar spot to Aaron Hernandez

Mucky Tundra (10-Feb) : I think some of his coaches told scouts to stay away

Mucky Tundra (10-Feb) : the street racing incident+conditioning and motivation problems

beast (10-Feb) : Then Carter was street racing, where the other car crashed and people died... and other teams were scared to pick Carter for some reason

beast (10-Feb) : I think the Saints traded up, giving their next year 1st to the Eagles, and then they sucked and Eagles got the 10th overall pick

packerfanoutwest (10-Feb) : wtf Barkley?

TheKanataThrilla (10-Feb) : Getting Carter and Nolan Smith in the first round in 2023 was pretty darn good

Mucky Tundra (10-Feb) : for some reason i'm thinking of a draft where the Eagles where in the mid 20s and a top player fell all the way to them

TheKanataThrilla (10-Feb) : I think so. I would need to look it up. Think it may have been Carolina's pick.

Mucky Tundra (10-Feb) : i'm not sure who i'm thinking of now

Mucky Tundra (10-Feb) : oh fuck me i messed that up

Zero2Cool (10-Feb) : Jordan Davis was 13th overall

Zero2Cool (10-Feb) : Carter was 9th overall

Zero2Cool (10-Feb) : Eagles had 15th and 10th selections, moved to 13 and 9 to get Davis and Carter back to back

Zero2Cool (10-Feb) : Eagles traded up for Carter, didn't they?

Mucky Tundra (10-Feb) : Obviously he was a huge risk but getting a top 5 talent on the dline in the mid 20s is fortuitous

Mucky Tundra (10-Feb) : Jalen Carter falling into their lap certainly helps

TheKanataThrilla (10-Feb) : And we could only wish to have this type of D

TheKanataThrilla (10-Feb) : It's not like Philly has had low draft picks, but has managed to get themselves a top notch pass rush. We spend so much draft capital of D

packerfanoutwest (10-Feb) : another crap halftime show

TheKanataThrilla (10-Feb) : I think it is over, but then I think of Atlanta and want Philly to go in with the same intensity in the second half

Mucky Tundra (10-Feb) : And with a Pass Rush that might as well be on a milk cartoon and no Jaire

Martha Careful (10-Feb) : I cant help but feel good about how well the Packers D played in Philly during the playoffs

Mucky Tundra (10-Feb) : this game is over

Mucky Tundra (10-Feb) : This might be the kill shot here

Mucky Tundra (10-Feb) : oh that's such a bad penalty for KC after getting the 3rd down stop

TheKanataThrilla (10-Feb) : Philly DL has come to play

Please sign in to use Fan Shout

2024 Packers Schedule

Friday, Sep 6 @ 7:15 PM

Eagles

29 - 34

Sunday, Sep 15 @ 12:00 PM

COLTS

16 - 10

Sunday, Sep 22 @ 12:00 PM

Titans

30 - 14

Sunday, Sep 29 @ 12:00 PM

VIKINGS

29 - 31

Sunday, Oct 6 @ 3:25 PM

Rams

24 - 19

Sunday, Oct 13 @ 12:00 PM

CARDINALS

34 - 13

Sunday, Oct 20 @ 12:00 PM

TEXANS

24 - 22

Sunday, Oct 27 @ 12:00 PM

Jaguars

30 - 27

Sunday, Nov 3 @ 3:25 PM

LIONS

14 - 24

Sunday, Nov 17 @ 12:00 PM

Bears

20 - 19

Sunday, Nov 24 @ 3:25 PM

49ERS

38 - 10

Thursday, Nov 28 @ 7:20 PM

DOLPHINS

30 - 17

Thursday, Dec 5 @ 7:15 PM

Lions

31 - 34

Sunday, Dec 15 @ 7:20 PM

Seahawks

30 - 13

Monday, Dec 23 @ 7:15 PM

SAINTS

34 - 0

Sunday, Dec 29 @ 3:25 PM

Vikings

25 - 27

Sunday, Jan 5 @ 12:00 PM

BEARS

22 - 24

Sunday, Jan 12 @ 3:30 PM

Eagles

10 - 22