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 (21h) : Jets taking calls for Davante Adams. That $38m cap number hurting lol

Zero2Cool (2-Mar) : Guess it's not official until the 12th

Zero2Cool (2-Mar) : Deebo went for a 5th to Commanders?

Martha Careful (1-Mar) : Just like my late husband!!

Zero2Cool (1-Mar) : Once fired up, it should be good

Zero2Cool (1-Mar) : Sometimes, the first page load will be slow. it's firing up the site.

Martha Careful (1-Mar) : The site is operating much faster...tyvm

Mucky Tundra (28-Feb) : It's the offseason and the draft is still nearly 2 months away, what can ya do?🤷‍♂️

Zero2Cool (27-Feb) : NFL teams were notified today that the 2025 salary cap has been set at $279,200,000 per club.

Zero2Cool (27-Feb) : sssllllooooow

Martha Careful (27-Feb) : is it just me, or has the website been slow the last couple of days?

buckeyepackfan (26-Feb) : Damnit 2026 2nd rnd pick!

buckeyepackfan (26-Feb) : Packers get Myles Garret and Browns 2926 2nd rnd pick.

buckeyepackfan (26-Feb) : Browns get Jaire, + Packers #1 2025 pick and 2026 3rd rnd pick.

beast (26-Feb) : Rams trying to trade Stafford and Kupp, then signing Rodgers and Adams? Just speculation, but interesting

Zero2Cool (26-Feb) : Packers shopping Jaire Alexander per Ian Rapoport

Zero2Cool (25-Feb) : Gutekunst and Jaire Alexander’s agent, John Thornton, are meeting this week in Indianapolis to determine the future of the Packers’ 28-year-

Zero2Cool (25-Feb) : Gutekunst says Mark Murphy told him he can trade their first-round pick despite the draft being in Green Bay.

Zero2Cool (24-Feb) : Packers. 🤦

Zero2Cool (24-Feb) : One team.

Zero2Cool (24-Feb) : One team petition NFL to ban Brotherly Shove.

beast (23-Feb) : Seems like he was just pissed because he was no longer the starter

beast (23-Feb) : Campbell is right, he's rich and he doesn't have to explain sh!t... but that attitude gives teams reasons to never sign him again.

dfosterf (22-Feb) : I have some doubt about all that

dfosterf (22-Feb) : I read De'Vondre Campbell's tweet this morning (via the New York Post) Florio says that if he invested his earnings wisely, he will be good

beast (20-Feb) : I haven't followed, but I believe he's good when healthy, just hasn't been able to stay healthy.

dfosterf (20-Feb) : Hasn"t Bosa missed more games than he has played in the last 3 years?

Mucky Tundra (19-Feb) : He hasn't been too bad when healthy but I don't feel like I ever heard much about when he is

Zero2Cool (19-Feb) : Felt like he was more interested in his body, than football. He flashed more than I expected

Zero2Cool (19-Feb) : When he was coming out, I thought he'd be flash in pan.

Mucky Tundra (19-Feb) : Joey seems so forgettable compared to his brother for some reason

Zero2Cool (19-Feb) : NFL informed teams today that the 2025 salary cap will be roughly $277.5M-$281.5M

Zero2Cool (19-Feb) : Los Angeles Chargers are likely to release DE Joey Bosa this off-season as a cap casualty, per league source.

Zero2Cool (18-Feb) : If the exploit is not fixed, we'll see tons of "50 top free agents, 50 perfect NFL team fits: We picked where each should sign in March" lo

Zero2Cool (18-Feb) : Issue should be solved, database cleaned and held strong working / meeting. Boom!

Zero2Cool (18-Feb) : It should be halted now.

Mucky Tundra (18-Feb) : usually spambots are trying to get traffic to shady websites filled with spyware; the two links being spammed were to the Packers website

Mucky Tundra (18-Feb) : you know when you put it that way combined with the links it was spamming (to the official Packers website)

Zero2Cool (18-Feb) : Yep. You can do that with holding down ENTER on a command in Console of browser

Mucky Tundra (18-Feb) : even with the rapid fire posts?

Zero2Cool (18-Feb) : I'm not certain it's a bot.

Mucky Tundra (18-Feb) : I've got to go to work soon which is a pity because I'm enthralled by this battle between the bot and Zero

Zero2Cool (18-Feb) : Yeah, I see what that did. Kind of funny.

Mucky Tundra (18-Feb) : now it's a link to Wes Hodkiezwicz mailbag

Mucky Tundra (18-Feb) : Now they're back with another topic

Mucky Tundra (18-Feb) : oh lol

Zero2Cool (18-Feb) : I have a script that purges them now.

Zero2Cool (18-Feb) : 118 Topics with Message.

Mucky Tundra (18-Feb) : what's 118 (besides a number)?

Zero2Cool (18-Feb) : They got 118 slapped in there.

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