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

Mucky Tundra (20h) : Agreed; you stinks

Zero2Cool (20h) : I'm not beating anyone. I stinks.

Mucky Tundra (21h) : rough injury for tank dell. guy can't catch abreak

beast (22h) : So far the college playoffs have sucked... One team absolutely dominates the other

beast (21-Dec) : Well even if you weren't positive towards a guy, you wouldn't nessarily want to tell the media that (if they don't know about it)

Martha Careful (21-Dec) : I think MLF want Love to look past the end half issues, and feel good about his play. Our coaches generally keep a very positive tone.

beast (21-Dec) : I think a great running game will do that for most QBs

packerfanoutwest (21-Dec) : Coach Matt LaFleur has said quarterback Jordan Love is playing the best football of his career.

beast (21-Dec) : Oh, that's how you keep beating buckeye, with cheating

Zero2Cool (20-Dec) : There is a rule that if your name starts with 'b' you lose 15 points. Hey, I don't make the rules, I just enforce them!

wpr (20-Dec) : and then there is Beast. Running away with it all.

beast (20-Dec) : As of tonight, 3 way tie for 2nd in Pick'em, that battle is interesting!

beast (20-Dec) : Lions vs Vikings could be the main last game as it could determine division winners or #1 vs #2 seed

Mucky Tundra (20-Dec) : Or if KC needs to win for the #1 seed

Mucky Tundra (20-Dec) : Right now it looks like the only prime worthy games are Det-Minny and KC-Denver (if Denver can clinch a wild card spot)

Mucky Tundra (20-Dec) : The entirety of week 18 being listed as flex is weird

Zero2Cool (19-Dec) : Matt LaFleur today says unequivocally "Ted Thompson had nothing to do with the drafting of Jordan Love."

Zero2Cool (19-Dec) : Apparently, the editing is what pieces comments together. That Ted thing ... fake news.

Zero2Cool (19-Dec) : LaFleur "opportunity that Ted Thompson thought was too good to pass up"

Zero2Cool (19-Dec) : Jordan Love pick was Ted Thompson's idea.

Mucky Tundra (19-Dec) : Kyle Shanahan on signing De'Vondre Campbell as a FA last offseason: “We obviously made a mistake.”

packerfanoutwest (19-Dec) : Alexander’s last season with GB

Martha Careful (18-Dec) : if I were a professional athlete, I would probably look to see who the agent is for Kirk Cousins and then use him

beast (18-Dec) : $100 million fully guaranteed Kirk Cousins gets benched for rookie

Mucky Tundra (18-Dec) : a lower case b

Mucky Tundra (18-Dec) : The real lie is how beast capitalized his name in his message while it's normally spelled with

packerfanoutwest (18-Dec) : haha that's a lie

beast (17-Dec) : Despite what lies other might tell, Beast didn't hate the Winter Warnings, it felt refreshing to Beast for some reason.

Zero2Cool (17-Dec) : whiteout uniforms in general are pretty lame and weak. NFL greed at it's worst

Martha Careful (17-Dec) : The Viking uniforms, the whiteout uniforms specifically absolutely suck

beast (17-Dec) : Thanks Zero2Cool, looks a lot better now

beast (17-Dec) : Seems like someone has a crush on me, can't stop talking about me

Zero2Cool (17-Dec) : Should be gooder now. The forum default theme went to goofy land.

Zero2Cool (17-Dec) : What the hell

packerfanoutwest (17-Dec) : yeah beast hates the Winter Warning Unies

Mucky Tundra (16-Dec) : Okay I'm glad to know it's not just something happening to me lol

Mucky Tundra (16-Dec) : Zero, did you copy the Packers uniforms from last night and white out the board?

beast (16-Dec) : Oh crap, is the board going to the Winter Warning Uniforms too?!? It's all white on white right now!

Zero2Cool (16-Dec) : WR Odell Beckham Jr is officially a free agent after clearing waivers.

Zero2Cool (16-Dec) : Packers are 6th in sacks.

Zero2Cool (16-Dec) : RB David Montgomery will undergo season-ending knee surgery.

Mucky Tundra (16-Dec) : Dan Campbell on onside kick with 12 minutes left: In hindsight, wish I didn’t do that

Zero2Cool (16-Dec) : They have that whole 12th man thing so ...

Zero2Cool (16-Dec) : Of the times we've played there, I just can't recall hearing our fans.

wpr (16-Dec) : Well done jdlax. Well done.

wpr (16-Dec) : I think more likely to be Pack fans that live in the area.

wpr (16-Dec) : Pack fans represent. I pointed it out early in the game to my wife. Announcers said Packers travel well.

Zero2Cool (16-Dec) : That was crazy to hear go pack go in Seattle of all plays. That 12 man thing an all

Mucky Tundra (16-Dec) : jdlax, good man!

jdlax (16-Dec) : Mucky, there were too many of us there to credit any single one but for sure i was 60% responsible.

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

Sunday, Dec 29 @ 12:00 PM

Vikings

Saturday, Jan 4 @ 11:00 PM

BEARS