Pick'em Percentage · PACKERSHOME

Announcement PH Beta → Check it out! Click Me! (you might be see "unsafe", but it is safe)

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

beast (1h) : I want to them chant some songs for Daniel Whelan

beast (1h) : Let's win one! Also, hopefully the Irish will stand with Daniel Whelan

Mucky Tundra (3h) : After London and Brazil, I could go without an overseas game for a while

Zero2Cool (4h) : Packers. Steelers. Ireland. 2025. Reports say.

Zero2Cool (30-Dec) : Matt Lafleur on if Jaire will play again this season. "Yeah I don't know... he's been dealing with swelling."

Mucky Tundra (30-Dec) : After the way they played for most of the game yesterday, I don't see how you can sit anyone for the whole game

Zero2Cool (30-Dec) : I'd say play everyone. Going into playoffs at 7th seed on two game lose streak - yucky

Zero2Cool (30-Dec) : Do the Packers have any best players?

beast (30-Dec) : Play or Rest*

beast (30-Dec) : Should the Packers play or free their best players vs the Bears?

Zero2Cool (30-Dec) : Packers should be 3 - 2 in the Division. Bonkers being swept by both Lions and Vikings. yikes

go.pack.go. (30-Dec) : All crazy stuff…and good point beast

beast (30-Dec) : Packers should be 0-5 in the division, can't say I saw that coming, even 1-4

Zero2Cool (30-Dec) : Sam Darnold 35 TD's ... another one

Zero2Cool (30-Dec) : Baker Mayfield, 39 TD's ... can't say I saw that one

Zero2Cool (30-Dec) : No matter who is playing as 7th, I think we want them to win. Get rid of 2nd seed haha

go.pack.go. (30-Dec) : That would be dhazer who was rooting for Minnesota

beast (30-Dec) : Well, Commanders are currently the 6th seed and Packers the 7th

beast (30-Dec) : Who was it in Chat, that wanted the Vikings to win (because Lions fans upset them) because Packers could not lose the 6th seed?

beast (30-Dec) : If Falcons win, Packers stay as the 6th seed and Falcons lead the NFCS, if they lose, Commanders 6th and Bucs take NFCS lead

beast (30-Dec) : Win or Loss, the NFCS is going down to week 18

Mucky Tundra (30-Dec) : if the Falcons win, how does that affect the overall NFC playoff picture? Does it mean that the NFC South comes down to week 18?

beast (30-Dec) : If Commanders win, the Packers drop to the 7th seed

beast (29-Dec) : Taylor still at it!

beast (29-Dec) : Colts get the ball and fumble turn over

packerfanoutwest (29-Dec) : Jets pull Aaron Rodgers for Tyrod Taylor

Mucky Tundra (29-Dec) : Colts-Giants now a tight one

beast (29-Dec) : Still early, but Giants 14 to 3 over Colts

beast (29-Dec) : With Broncos losing to the Bengals, Colts got to control their destiny for the 7th seed... looks like they're about to give it up

Mucky Tundra (29-Dec) : I believe Pickett is starting for Philly

beast (29-Dec) : Is the Eagles QB Hurts playing? I forgot to check

Zero2Cool (29-Dec) : Watson unlikely to play today.

Mucky Tundra (29-Dec) : Good job gpg!

go.pack.go. (29-Dec) : I figured out the signature thing. I had to find a different hosting website

Zero2Cool (28-Dec) : Packers elevated S Omar Brown.

go.pack.go. (28-Dec) : I tried the [img][/img] but that didn’t work

go.pack.go. (28-Dec) : How do I upload a picture to change my signature? I haven’t done it in years lol. I have the picture but can’t get it to work

Mucky Tundra (28-Dec) : Saturday NFL games=the season is about to get serious

Mucky Tundra (28-Dec) : Greg Gumbel passed away today after bout with cancer.

buckeyepackfan (27-Dec) : 1 NFC South @ NFC West @ AFC West other 3 games,

buckeyepackfan (27-Dec) : Packers play NFC East and AFC North in 2025, plus 2 other games

Mucky Tundra (27-Dec) : Geeze Zero get it right!😋

Zero2Cool (27-Dec) : I guess 3 games. Whatever

Zero2Cool (27-Dec) : Bleh, that only impacts two games.

Zero2Cool (27-Dec) : Packers are gonna get 3rd place division schedule next year.

Mucky Tundra (27-Dec) : Kanata, seek help! lol

beast (27-Dec) : I was rooting for the Bears to win and hurt their draft pick status

Zero2Cool (27-Dec) : Forgot there was even a game last night haha

TheKanataThrilla (27-Dec) : That was terrible.

TheKanataThrilla (27-Dec) : Watching that game in its entirety yesterday is proof positive that I am a football addict.

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