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 (2-Apr) : WR who said he'd break Xavier Worthy 40 time...and ran slower than you

Mucky Tundra (2-Apr) : Who?

Zero2Cool (2-Apr) : Texas’ WR Isaiah Bond is scheduled to visit the Bills, Browns, Chiefs, Falcons, Packers and Titans starting next week.

Zero2Cool (2-Apr) : Spotting ball isn't changing, only measuring distance is, Which wasn't the issue.

Zero2Cool (2-Apr) : The spotting of the ball IS the issue. Not the chain gang.

Mucky Tundra (2-Apr) : Will there be a tracker on the ball or something?

Zero2Cool (1-Apr) : uh oh

Martha Careful (1-Apr) : Too bad camera's can't spot the ball as well.

Mucky Tundra (1-Apr) : So will the chain gang be gone completely or will they still be around as a backup or whatever?

Zero2Cool (1-Apr) : The method for measuring first downs in the NFL will switch from chain gangs to camera-based technology in 2025, the league announced.

Martha Careful (1-Apr) : A big step in the right direction. Just put in the college system is very very good.

Zero2Cool (1-Apr) : NFL has passed a rule that allows both teams to possess the ball in OT during the regular season

Zero2Cool (1-Apr) : Touchbacks on kickoffs will now bring the ball to the 35-yard line.

beast (31-Mar) : It might of gotten more popular recently, but braiding hair (even men) in certain cultures goes back for centuries.

Martha Careful (30-Mar) : Is men braiding their hair a new style thing? Watching the NCAA men's tournament many players have done

Zero2Cool (29-Mar) : Ha. Well, it'd be nice for folks to reset their own password. Via validated email 😏

beast (29-Mar) : Monopoly was supposed to be an educational game, that show how evil capitalism was and how we should avoid it

beast (29-Mar) : Lol, I was thinking username would be better, as then I wouldn't have to keep an email up to date lol 😂

beast (29-Mar) : Zero2Cool (25-Mar) : I was thinking email because I think it'll make folks keep it up todate lol

wpr (29-Mar) : sure is

Zero2Cool (29-Mar) : Monopoly is a rip off of The Landlord's Game

wpr (27-Mar) : 28 days until the draft

earthquake (27-Mar) : Which seemed strange to my 9 year old self, that you could be a fan for a team other than the one you play for

earthquake (27-Mar) : Nothing eventful happened, other than it being clear that he was a bengals fan

earthquake (27-Mar) : And we went and hung out with him one afternoon, I must have been 9 or so

earthquake (27-Mar) : That’s wild, when I was a kid my friend lived in the same apartment complex in De Pere

Mucky Tundra (27-Mar) : Only career highspot was a 200 yard rushing game while playing for the Cardinals

Mucky Tundra (27-Mar) : He is a former Packer. Drafted out of Northern Illinois. Didn't do much in GB.

dfosterf (26-Mar) : Despicable

Zero2Cool (26-Mar) : Former NFL. I think Packers too

Zero2Cool (26-Mar) : NFL RB Leshon Johnson has been charged in a massive dog fighting operation, with the FBI seizing over 190 Pit Bulls

Mucky Tundra (26-Mar) : Some real irony of a QB as short as Wilson playing for the Giants

Mucky Tundra (26-Mar) : Giants country, let's be the tall beings of lore!

Mucky Tundra (26-Mar) : Russell Wilson signs with the Giants.

Zero2Cool (25-Mar) : I was thinking email because I think it'll make folks keep it up todate lol

wpr (25-Mar) : I don't think there is a significant difference. I use a user name for many. Others email.

Martha Careful (25-Mar) : email

Zero2Cool (25-Mar) : would it be better to use EMAIL or USERNAME to log into a site?

wpr (25-Mar) : Thanks Zero

Zero2Cool (24-Mar) : New forum has the ability to Thank a post now.

beast (24-Mar) : And the only time they have won the Championship in an even year, was the first time they did, in 2006.

beast (24-Mar) : Since 2007, there have been 10 odd numbered years, Wisconsin Women have won the Championship in 7 of those 10 odd numbered years.

buckeyepackfan (24-Mar) : Congratulations Lady Badger Hockey Team. NATIONAL CHAMPIONS!!

Zero2Cool (23-Mar) : I don't think it's completed yet. it was just announced last month, right?

dhazer (23-Mar) : did netflix ever release the Packers documentary

Zero2Cool (21-Mar) : And it is glorious!

beast (21-Mar) : Unsigned FA QB Rodgers is supposedly in the Steelers building

Martha Careful (19-Mar) : But I don't own a car! So can I still use it in my apartment?

Zero2Cool (19-Mar) : btw, new site auto updates

Zero2Cool (19-Mar) : Woohoo!

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