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 (5h) : Thomas Davis Jr is OLB, not WR. Oops.

Zero2Cool (5h) : Larry Fitzgeral and Thomas Davis sons too. WR's as well.

Mucky Tundra (20h) : Kaydon Finley, son of Jermichael Finley, commits to Notre Dame

dfosterf (3-Jul) : Make sure to send my props to him! A plus move!

Zero2Cool (3-Jul) : My cousin, yes.

dfosterf (3-Jul) : That was your brother the GB press gazette referenced with the red cross draft props thing, yes?

Zero2Cool (2-Jul) : Packers gonna unveil new throwback helmet in few weeks.

Mucky Tundra (2-Jul) : I know it's Kleiman but this stuff writes itself

Mucky Tundra (2-Jul) : "Make sure she signs the NDA before asking for a Happy Ending!"

Mucky Tundra (2-Jul) : @NFL_DovKleiman Powerful: Deshaun Watson is taking Shedeur Sanders 'under his wing' as a mentor to the Browns QBs

Zero2Cool (30-Jun) : Dolphins get (back) Minkah Fitzpatrick in trade

Zero2Cool (30-Jun) : Steelers land Jalen Ramsey via Trade

dfosterf (26-Jun) : I think it would be great to have someone like Tom Grossi or Andy Herman on the Board of Directors so he/they could inform us

dfosterf (26-Jun) : Fair enough, WPR. Thing is, I have been a long time advocate to at least have some inkling of the dynamics within the board.

wpr (26-Jun) : 1st world owners/stockholders problems dfosterf.

Martha Careful (25-Jun) : I would have otherwise admirably served

dfosterf (25-Jun) : Also, no more provision for a write-in candidate, so Martha is off the table at least for this year

dfosterf (25-Jun) : You do have to interpret the boring fine print, but all stockholders all see he is on the ballot

dfosterf (25-Jun) : It also says he is subject to another ballot in 2028. I recall nothing of this nature with Murphy

dfosterf (25-Jun) : Ed Policy is on my ballot subject to me penciling him in as a no.

dfosterf (25-Jun) : I thought it used to be we voted for the whatever they called the 45, and then they voted for the seven, and then they voted for Mark Murphy

dfosterf (25-Jun) : Because I was too lazy to change my address, I haven't voted fot years until this year

dfosterf (25-Jun) : of the folks that run this team. I do not recall Mark Murphy being subject to our vote.

dfosterf (25-Jun) : Ed Policy yay or nay is on the pre-approved ballot that we always approve because we are uninformed and lazy, along with all the rest

dfosterf (25-Jun) : Weird question. Very esoteric. For stockholders. Also lengthy. Sorry. Offseason.

Zero2Cool (25-Jun) : Maybe wicked wind chill made it worse?

Mucky Tundra (25-Jun) : And then he signs with Cleveland in the offseason

Mucky Tundra (25-Jun) : @SharpFootball WR Diontae Johnson just admitted he refused to enter a game in 41° weather last year in Baltimore because he felt “ice cold”

Zero2Cool (24-Jun) : Yawn. Rodgers says he is "pretty sure" this be final season.

Zero2Cool (23-Jun) : PFT claims Packers are having extension talks with Zach Tom, Quay Walker.

Mucky Tundra (20-Jun) : GB-Minnesota 2004 Wild Card game popped up on my YouTube page....UGH

beast (20-Jun) : Hmm 🤔 re-signing Walker before Tom? Sounds highly questionable to me.

Mucky Tundra (19-Jun) : One person on Twitter=cannon law

Zero2Cool (19-Jun) : Well, to ONE person on Tweeter

Zero2Cool (19-Jun) : According to Tweeter

Zero2Cool (19-Jun) : Packers are working on extension for LT Walker they hope to have done before camp

dfosterf (18-Jun) : E4B landed at Andrews last night

dfosterf (18-Jun) : 101 in a 60

dfosterf (18-Jun) : FAFO

Zero2Cool (18-Jun) : one year $4m with incentives to make it up to $6m

dfosterf (18-Jun) : Or Lions

dfosterf (18-Jun) : Beats the hell out of a Vikings signing

Zero2Cool (18-Jun) : Baltimore Ravens now have signed former Packers CB Jaire Alexander.

dfosterf (14-Jun) : TWO magnificent strikes for touchdowns. Lose the pennstate semigeezer non nfl backup

dfosterf (14-Jun) : There was minicamp Thursday. My man Taylor Engersma threw

dfosterf (11-Jun) : There will be a mini camp practice Thursday.

Zero2Cool (11-Jun) : He's been sporting a ring for a while now. It's probably Madonna.

Martha Careful (10-Jun) : We only do the tea before whoopee, it relaxes me.

wpr (10-Jun) : That's awesome Martha.

Mucky Tundra (10-Jun) : How's the ayahuasca tea he makes, Martha?

Please sign in to use Fan Shout

2025 Packers Schedule

Sunday, Sep 7 @ 3:25 PM

LIONS

Thursday, Sep 11 @ 7:15 PM

COMMANDERS

Sunday, Sep 21 @ 12:00 PM

Browns

Sunday, Sep 28 @ 7:20 PM

Cowboys

Sunday, Oct 12 @ 3:25 PM

BENGALS

Sunday, Oct 19 @ 3:25 PM

Cardinals

Sunday, Oct 26 @ 7:20 PM

Steelers

Sunday, Nov 2 @ 12:00 PM

PANTHERS

Monday, Nov 10 @ 7:15 PM

EAGLES

Sunday, Nov 16 @ 12:00 PM

Giants

Sunday, Nov 23 @ 12:00 PM

VIKINGS

Thursday, Nov 27 @ 12:00 PM

Lions

Sunday, Dec 7 @ 12:00 PM

BEARS

Sunday, Dec 14 @ 3:25 PM

Broncos

Friday, Dec 19 @ 11:00 PM

Bears

Friday, Dec 26 @ 11:00 PM

RAVENS

Saturday, Jan 3 @ 11:00 PM

Vikings