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 (27-Jul) : Golden with two TDs in red zone drills today

Mucky Tundra (27-Jul) : @JacobMorley Shoutout to Quinn Ewers for allowing Matthew Golden to be available when Green Bay picked.

Zero2Cool (27-Jul) : The menu you expanded to log in, it's the first icon under "PackersHome" .. maybe i should add text to it

dfosterf (27-Jul) : Feelin' pfowish can't find the sun. No big deal, will drag a laptop out when the time comes

Zero2Cool (27-Jul) : if you're on mobile, open the menu and its the "sun" icon

dfosterf (27-Jul) : Can't find the toggle, lol

dfosterf (27-Jul) : I can find that the Microsoft lady rep for Titletown Tech is the philanthropy boss for the entire Microsoft corporation, but. .

Zero2Cool (27-Jul) : There's a toggle for light/dark theme. Super easy.

dfosterf (27-Jul) : The white background beta was hard to read, especially the quotes

dfosterf (27-Jul) : Hopefully the color scheme remains the same

dfosterf (27-Jul) : *Friday*

dfosterf (27-Jul) : 100 million would be 539 million as of Fridsy

dfosterf (27-Jul) : Heck, they could have taken a hundred milliion and invested in DAVE inc. last year (semi random, humor, but real)

dfosterf (27-Jul) : Beer brat and ticket is where the money comes from

dfosterf (27-Jul) : The 40th is Titletown Tech itself. This is a pet project of both Ed Policy and Mark Murphy

Zero2Cool (27-Jul) : New site coming along nicely. The editor is better than what we have here. Oh yeah!

dfosterf (27-Jul) : No profit that I know of. 0 for 40

dfosterf (27-Jul) : The woke reference has to do with the makeup and oftentimes objectives of the companies they invested in

packerfanoutwest (27-Jul) : beer and brats woke? say whom?

beast (27-Jul) : I don't want to get into politics, but how is, beers and brats considered to be "woke"? Food is food...

beast (27-Jul) : That being said, I'm not saying all 100% should be that way, but not surprised if majority are Wisconsin based

beast (27-Jul) : And if everyone has heard of them, then it it probably has less growth potential and less community based

beast (27-Jul) : Well isn't the investing person supposed to invest the money?

dfosterf (27-Jul) : I swear if I were to discover that one of them has invented a virtue signalling transmitter I will not be surprised, lol

dfosterf (27-Jul) : 39 companies so far that I bet no one has ever heard of.

dfosterf (27-Jul) : -Not saying woke, but should- borderline philanthopist venture capital excercise

dfosterf (27-Jul) : Well for one, they are pouring resources into Title Town Tech. Investing beer, brat, hot dog, ticket money into what is pretty much...

beast (27-Jul) : Wow, 95% drop in investment revenue? Would be interesting to hear the details of why...

dfosterf (25-Jul) : It's my one day deal complaint dept. on shareholder meeting day

dfosterf (25-Jul) : Probably a homer access credential intimidation kinda thing

dfosterf (25-Jul) : Meathead "journalists" skip this, concentrating on operational revenue when convenient. They switch when net revenue is more favorable.

dfosterf (25-Jul) : Resulting in an actual drop of net revenue of 12.5%. She is from Minnesota. Just sayin'

dfosterf (25-Jul) : Any plans to hold Maureen Smith (CFO) accountable for a 95% drop in investment revenue?

Mucky Tundra (25-Jul) : In your face, HBO!

Mucky Tundra (25-Jul) : @ByRyanWood Mark Murphy: “A great source of pride of mine is that we were never on Hard Knocks.”

Mucky Tundra (25-Jul) : *years

Mucky Tundra (25-Jul) : @mattschneidman Mark Murphy says he anticipates “many Packers games” being played in Germany, Ireland and/or the U.K. over the next 5-10 yea

dfosterf (25-Jul) : *cafeteria* I have hit my head also, so I sympathize

dfosterf (25-Jul) : Possibly hit his head leaning into the glass protecting the food in the cafateria

dfosterf (25-Jul) : Maybe a low flying drone

dfosterf (25-Jul) : Did Savion Williams run into a goalpost or something?

Mucky Tundra (25-Jul) : also, no bueno when a guy starts getting concussions right off the bat in his career

Zero2Cool (25-Jul) : Concussion is worse. Banks probably vet off day via back booboo claim

Mucky Tundra (25-Jul) : @AndyHermanNFL Jordy Nelson out at camp today. No word if he’s in play for one of the two open roster spots ; )

dfosterf (25-Jul) : Is that better or worse than Banks bad back?

Zero2Cool (25-Jul) : Savion concussion ... not good.

packerfanoutwest (24-Jul) : Aaron Rodgers’s first pass of first team period was picked off

Mucky Tundra (24-Jul) : tbh I didn't hear of his passing

Zero2Cool (24-Jul) : Cosby Show. Malcom Jamal Warner I think is real name

Mucky Tundra (24-Jul) : I was thinking of Ozzy and Hulk

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