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

packerfanoutwest (3h) : from a head left turn?

packerfanoutwest (3h) : someone drunk?

Zero2Cool (5h) : Unlikely.

dfosterf (21h) : How long until Jeff Sperbeck's family sues John Elway ?

Zero2Cool (23h) : Packers are exercising the fifth-year option on DT Devonte Wyatt, locking in a guaranteed $12.9M for the 2026 season.

beast (30-Apr) : Sounds like P Luke Elzinga has a rookie try out opportunity from the Titans

dfosterf (30-Apr) : Luke Elzinga Punter Oklahoma stil unsigned. Green Bay has been mentioned as good fit

beast (30-Apr) : The Packers re-signed three exclusive rights free agents WR Melton, P Whelan and RB Wilson.

Zero2Cool (29-Apr) : February 5, 2002 (age 23) ok no. packers.com is wrong

Zero2Cool (29-Apr) : Micah Robinson is only 19??

Zero2Cool (29-Apr) : 6 first rounders on Packers defense now

Zero2Cool (29-Apr) : LB Isaiah Simmons. Signed. Called it!!! Oh yeah!

Martha Careful (29-Apr) : ty bboystyle...fat fingers

bboystyle (29-Apr) : Tom*

Martha Careful (28-Apr) : RIP Packer Safety Tim Brown

beast (27-Apr) : Yeah, but also some of the wording suggestions Jax only pranked called the QB, not the others... and if he had an open spreadsheet & 3 calls

beast (27-Apr) : Thank goodness he's not leaving the Turtle in the Red Tide

Mucky Tundra (27-Apr) : Cowboys 1st round pick Tyler Booker will indeed be bringing his pet turtle to Dallas with him

Mucky Tundra (27-Apr) : that contained all prospects info and contact

Mucky Tundra (27-Apr) : beast, according the Falcons statement Jax came across it on an ipad. If I had to guess, probably an open spread sheet or something

Zero2Cool (27-Apr) : Simmons put up an emoji with cheese.

beast (27-Apr) : Not sure anyone is interested in Isaiah Simmons... Collin Oliver might of taken his potential slot

beast (27-Apr) : I'm going with Jax Ulbrich is not telling the whole truth... he accidentally came across it? Why would a defensive coordinator have a QB #?

Zero2Cool (27-Apr) : He's not that great, but final piece of the script.\

Zero2Cool (27-Apr) : If we add Isaiah Simmons, book your Super Bowl tickets

Mucky Tundra (27-Apr) : Colts 1st round TE Tyler Warren also got prank called, was that Jax Ulbrich as well?

Zero2Cool (27-Apr) : Jax Ulbrich, Jeff Ulbrich’s son, released an apology for his role in the Shedeur Sanders prank call.

Martha Careful (27-Apr) : apparently he did not participate in practice or play on the east west shrine game nor the NFL combine. The kid was a mediocre spoiled brat

Mucky Tundra (27-Apr) : Yeah that one that was a super wounded duck that Sanders supporters are highlighting to prove a point

Zero2Cool (27-Apr) : Shough is the guy who missed guys at combine isn't he?

beast (27-Apr) : It's not official until I'm dead! I have a chance still! (Not really)

Mucky Tundra (27-Apr) : I could feel my body decomposing in real time when I read that

Mucky Tundra (27-Apr) : @MIKEYSAINRISTIL Tyler Shough will officially be the last person drafted to the NFL born in the 1900’s

Mucky Tundra (26-Apr) : saw the tweet, he meant the city

Mucky Tundra (26-Apr) : Was that for the team or the city?

Zero2Cool (26-Apr) : Adam Schefter @AdamSchefter · 3m Draft grade is in: Green Bay gets an A. The people, the city, the venue were all superb. NFL Draft’s next

Zero2Cool (26-Apr) : Matt LaFleur says Jaire Alexander is participating in #Packers offseason program, which has been conducted virtually during this first week

Zero2Cool (26-Apr) : ✅ ...

buckeyepackfan (26-Apr) : Check

Zero2Cool (26-Apr) : Matthew Golden cahanged 81 to 22??

TheKanataThrilla (26-Apr) : Sam Howell to Vikings...guess no Aaron

Martha Careful (26-Apr) : 1 round 7 min, with one extra minute if there is a trade. 2nd round 4 minutes, 3rd -3, 2 thereafter IMO

Martha Careful (26-Apr) : Agree

dfosterf (26-Apr) : Great idea imo

dfosterf (26-Apr) : 1st round to 7 minutes with one extension

dfosterf (26-Apr) : NFL comissioner wants to shorten the 2st

Mucky Tundra (26-Apr) : @jalenreagors They’re discussing if Sheduer can go back to college on NFL Network LMFAOOOOO

beast (26-Apr) : Great point Martha

beast (26-Apr) : Buddy Ryan used to say if a candy bar goes missing, there are two to blame, Rex and Rob 🤪 jk 😁

Martha Careful (26-Apr) : Bum Phillips used to say there are two ways to get better. Get better players or get players to play better. We have a new DL coach

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