Pick'em Percentage · PACKERSHOME

Zero2Cool
Elite Member Topic Starter

10 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

10 years ago

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

Pack93z
Select Member

10 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

10 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

10 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

10 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

10 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

10 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

10 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

10 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 (14-Apr) : Packers DT Kenny Clark: New defensive coordinator Jeff Hafley will 'allow us to be way more disruptive'

Zero2Cool (12-Apr) : Saints have agreed to terms on a contract with former Packers wide receiver Equanimeous St. Brown.

beast (12-Apr) : No, but of it's for legislation, then half of the country will find it evil, not good, whatever it says....

Mucky Tundra (12-Apr) : Draft is still 2 weeks away. UGH

dhazer (11-Apr) : Does anyone know of a good AI generator to create letters of Support for legislation?

Zero2Cool (11-Apr) : Gordon "Red" Batty retires as equipment manager

Zero2Cool (10-Apr) : Sounds like that's pretty certain now.

Zero2Cool (10-Apr) : Packers "at" Eagles in Brazil. Week One

dfosterf (10-Apr) : Va' Fazer As Malas Va' !

Zero2Cool (9-Apr) : Mark Murphy tipping us off?

Zero2Cool (9-Apr) : “We’re either the first- or second-most popular team in Brazil.”

Zero2Cool (9-Apr) : Christian Watson got married. Wife better be careful with those hamstrings!! 😂😂

dfosterf (9-Apr) : Those poor bastards

Zero2Cool (8-Apr) : Falcons have signed former Packers CB Kevin King, who has been out of football since 2021.

dfosterf (8-Apr) : Collectively, we need to spend more time in what we have, when analyzing ostendible needs and historical proclivities

dfosterf (8-Apr) : I say he is better than so many of these draft picks

dfosterf (8-Apr) : Question of the week for me: Has anyone besides me done any deep dive into the potential of Alex McGough, our 3rd string qb?

Zero2Cool (8-Apr) : Or in Tunsil's case, something gets released day of draft or day before lol

Zero2Cool (8-Apr) : Seems every year someone does something pre-draft.

dfosterf (8-Apr) : Falling down drunk. The draft board

dfosterf (8-Apr) : Allright! Potential character guy/f#×k up pickup in D'Vondre Sweat!

Zero2Cool (7-Apr) : Go Badgers!!!

Martha Careful (6-Apr) : Go Boilermakers!!!

Martha Careful (5-Apr) : Diggs has not stepped up in the playoffs and has a high cost

beast (5-Apr) : Probably not going to let Diggs walk away unless he's horrible... but according to reports he also might not be as good as he used to be.

beast (5-Apr) : The 25th pick in the draft has been an offensive player since 2017, 2 TE, 2 WR, 1 RB, 1 OC

Mucky Tundra (5-Apr) : Odd, why give up a 2025 2nd Rounder for him if you're just gonna let him walk?

Zero2Cool (4-Apr) : Texans to let Diggs be free agent in '25

buckeyepackfan (4-Apr) : 49r's aign RB Patrick Taylor.

Martha Careful (4-Apr) : Reversion to the mean would indicate we will keep it

Zero2Cool (4-Apr) : It's also been utilized in a trade in 14 of the past 20 years

Zero2Cool (4-Apr) : The 25th pick in the draft hasn't been made by it's original holder since 2016.

Mucky Tundra (4-Apr) : Gotta imagine that Green Bay vs Houston will be a primetime game this upcoming season

Zero2Cool (3-Apr) : No. Kill QB. No worries. 😁

Mucky Tundra (3-Apr) : Diggs, Collins, Dell and Schultz is gonna be tough to cover

Zero2Cool (3-Apr) : Stefon Diggs' trade will not be processed as a post-June 1 designation, so that is just over $31 million in dead cap this year.

Zero2Cool (3-Apr) : Bills trading WR Stefon Diggs to the Texans in exchange for a 2025 2nd-round pick. (via @rapsheet)

beast (3-Apr) : Using Patterson as RB and RB/WR tweener... so I think they also signed Patterson as a 3rd down RB, not just a kick returner as articles are

beast (3-Apr) : I think PFT missed the real Steelers/Patterson connection, Steelers new OC Arthur Smith has been Patterson's head coach the last 3 years

wpr (2-Apr) : It has Martha. I was stunned when I was in HS to learn Iowa was still playing half court BB in the 70's.

Martha Careful (2-Apr) : Caitlin Clark, Angel Reese...women's sports has come a long way. GREAT TO SEE!!

Martha Careful (31-Mar) : Happy Easter everyone. I hope you all have a great day.

dfosterf (28-Mar) : Maybe

Mucky Tundra (28-Mar) : Yes

Zero2Cool (28-Mar) : No.

Mucky Tundra (28-Mar) : End of a Degu-era

dhazer (28-Mar) : Steelers sign Patterson because of new kickoff rule interesting

Zero2Cool (28-Mar) : Former #Packers TE Josiah Deguara is signing a 1-year deal with the Jaguars, per source.

Zero2Cool (28-Mar) : They do not do it for "content sake".

dfosterf (28-Mar) : For the record, I enjoy Beast and Mucky drafts

Please sign in to use Fan Shout

2023 Packers Schedule

Sunday, Sep 10 @ 3:25 PM

Bears

38 - 20

Sunday, Sep 17 @ 12:00 PM

Falcons

24 - 25

Sunday, Sep 24 @ 12:00 PM

SAINTS

18 - 17

Thursday, Sep 28 @ 7:15 PM

LIONS

20 - 34

Monday, Oct 9 @ 7:15 PM

Raiders

13 - 17

Sunday, Oct 22 @ 3:25 PM

Broncos

17 - 19

Sunday, Oct 29 @ 12:00 PM

VIKINGS

10 - 24

Sunday, Nov 5 @ 12:00 PM

RAMS

20 - 3

Sunday, Nov 12 @ 12:00 PM

Steelers

19 - 23

Sunday, Nov 19 @ 12:00 PM

CHARGERS

23 - 20

Thursday, Nov 23 @ 11:30 AM

Lions

29 - 22

Sunday, Dec 3 @ 7:20 PM

CHIEFS

27 - 19

Monday, Dec 11 @ 7:15 PM

Giants

22 - 24

Sunday, Dec 17 @ 12:00 PM

BUCCANEERS

20 - 34

Sunday, Dec 24 @ 12:00 PM

Panthers

33 - 30

Sunday, Dec 31 @ 7:20 PM

Vikings

33 - 10

Sunday, Jan 7 @ 3:25 PM

BEARS

17 - 9

Sunday, Jan 14 @ 3:30 PM

Cowboys

48 - 32

Saturday, Jan 20 @ 7:15 PM

49ers

21 - 24