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 (15h) : Patriots / Panthers feeling is what I got. didn't watch that one either

Zero2Cool (15h) : Easier to get a camera on her in the suite where she can't impact the game by being distraction???

TheKanataThrilla (15h) : This is the least excited I have been in a long time for a Super Bowl. Unfortunately they both can't lose.

wpr (15h) : So why don;'t they have her on the sidelines and doing the halftime fandango instead of sitting on her but in a $1,000,000 suite?

Zero2Cool (16h) : Think more eyes on Super Bowl with Swift fans pulling for her TE boyfriend?

Zero2Cool (16h) : She dating the TE of the Chiefs.

Zero2Cool (16h) : Taylor Swift has millions of fans, yeah?

Zero2Cool (17h) : They did. They are going to show the post production Sunday with plethora of ads.

wpr (5-Feb) : I thought KC already won

Zero2Cool (4-Feb) : If you wanna post about the Super Bowl, please, by all means, open a topic. They are free this month! 😁

Zero2Cool (4-Feb) : There doesn't need to be a topic. There's a playoff prediction thread.

packerfanoutwest (4-Feb) : and there no SB contest over in the other Packer forum, either

buckeyepackfan (4-Feb) : #2Officially Retires!

beast (4-Feb) : Probably no SB topic as people are wore out talking about the Chiefs, Refs and Eagles

Zero2Cool (4-Feb) : Packers reportedly have their new LB coach, promoting Sean Duggan to that role

Zero2Cool (4-Feb) : WR Cooper Kupp is being traded.

packerfanoutwest (4-Feb) : why is there no SB Prediction topic?

Zero2Cool (3-Feb) : Anthony Perkins spent 2024 as a defensive quality-control coach with the Packers.

Zero2Cool (3-Feb) : Packers lose another assistant.

Zero2Cool (3-Feb) : Defensive Player of the Year and Browns star Myles Garrett has requested a trade.

Zero2Cool (3-Feb) : deleted all my browser history and autofill and passwords. gonna be fun!

packerfanoutwest (3-Feb) : too funny

packerfanoutwest (3-Feb) : Lions QB Jared Goff was the offensive MVP

packerfanoutwest (3-Feb) : for the Pro Bowl, which is flag football

Zero2Cool (2-Feb) : Rather, the murder WAS covered up to prevent ...

Zero2Cool (2-Feb) : JFK murder was a cover-up to prevent war with Cuba/Russia.

Martha Careful (1-Feb) : I have always admired the pluck of the man

Zero2Cool (1-Feb) : I remember thinking he was going to be something good.

Mucky Tundra (1-Feb) : The Dualing Banjo!

Zero2Cool (31-Jan) : Jets have named Chris Banjo as their special teams coordinator, Former Packers player

Zero2Cool (31-Jan) : Jaguars have hired Anthony Campanile as their DC. We lose coach

Zero2Cool (30-Jan) : QB coach Sean Mannion

Zero2Cool (30-Jan) : DL Coach DeMarcus Covington

dfosterf (30-Jan) : from ft Belvoir, Quantico and points south. Somber reminder of this tragedy at Reagan Nat Airport

dfosterf (30-Jan) : So eerily quiet here in Alexandria. I live in the flight path of commercial craft coming from the south and west, plus the military craft

dfosterf (30-Jan) : So eeri

Mucky Tundra (30-Jan) : Now that's a thought, maybe they're looking at the college ranks? Maybe not head coaches but DC/assistant DCs with league experience?

beast (30-Jan) : College Coaches wouldn't want that publicly, as it would hurt recruiting and they might not get the job.

beast (30-Jan) : I thought they were supposed to publicly announce them, at least the NFL ones. Hafley was from college, so I believe different rules.

Mucky Tundra (30-Jan) : Who knows who they're interviewing? I mean, nobody knew about Hafley and then out of nowhere he was hired

beast (30-Jan) : I wonder what's taking so long with hiring a DL coach, 2 of the 3 known to interview have already been hired elsewhere.

Zero2Cool (27-Jan) : Packers coach Matt LaFleur hires Luke Getsy as senior assistant, extends Rich Bisaccia's deal

Zero2Cool (27-Jan) : Chiefs again huh? I guess another Super Bowl I'll be finding something else to do.

Mucky Tundra (27-Jan) : Chiefs Eagles...again...sigh

dfosterf (27-Jan) : Happy Birthday Dave!

Mucky Tundra (27-Jan) : happy birthday dhazer

TheKanataThrilla (26-Jan) : Exactly buck...Washington came up with the ball. It is just a shitty coincidence one week later

buckeyepackfan (26-Jan) : I forgot, they corrected the call a week later. Lol btw HAPPY BIRTHDAY dhazer!

buckeyepackfan (26-Jan) : That brings up the question, why wasn't Nixon down by contact? I think that was the point Kanata was making.

buckeyepackfan (26-Jan) : Turnovers rule, win the turnover battle, win the game.

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