Career Win %

User avatar
hong57
PostsCOLON 7106
JoinedCOLON Mon May 03, 2010 7:38 pm

Re: Career Win %

Post by hong57 »

Thanks Dave, love you!
Image
#91 - John Tavares
User avatar
hong57
PostsCOLON 7106
JoinedCOLON Mon May 03, 2010 7:38 pm

Re: Career Win %

Post by hong57 »

im actually trending downwards haha..
and surprised paul didn't have a season with winning% <0.2 =P
Image
#91 - John Tavares
CAM
PostsCOLON 3734
JoinedCOLON Fri May 24, 2013 5:42 pm

Re: Career Win %

Post by CAM »

Neat stuff. Question though, is it wrong to take the average of the total win % each year? Im just thinking the switch to playing 4 matches potentially skews the out put. If a team was super good the year we switched it would weight the totals.
CAM
PostsCOLON 3734
JoinedCOLON Fri May 24, 2013 5:42 pm

Re: Career Win %

Post by CAM »

For example, the average for me would be 0.574% and Matt would be 0.541%. i just used closest team in list to mine.

Statistically, i would assume taking the average of the win % since inception is more realistic to account for the matchup changes. Maybe it doesnt even matter? What if all those colums were just divided by 4…?
User avatar
Da_Hawks
PostsCOLON 2706
JoinedCOLON Mon Dec 18, 2017 9:27 am
LocationCOLON Ottawa

Re: Career Win %

Post by Da_Hawks »

My win% is going to be really bad for a long time haha. Nice spreadsheet!
Image
User avatar
Matthew
PostsCOLON 13682
JoinedCOLON Wed Oct 08, 2014 3:29 pm

Re: Career Win %

Post by Matthew »

Seems wrong when only 7 teams over .500 and that many teams below .400 with only 2 teams over .600
ANAHEIM DUCKS | FANTRAX |
User avatar
dave1959
PostsCOLON 5138
JoinedCOLON Wed Oct 02, 2013 8:43 pm
LocationCOLON Ontario

Re: Career Win %

Post by dave1959 »

should I exclude ties?
User avatar
Arian The Insider
PostsCOLON 7304
JoinedCOLON Mon May 03, 2010 7:05 pm

Re: Career Win %

Post by Arian The Insider »

Matthew wroteCOLONSeems wrong when only 7 teams over .500 and that many teams below .400 with only 2 teams over .600
Includes ties so it can't be compared to a .500 record we see in real life sports (e.g. 35-35-12)
Click Oilers image below for full team roster
Image
User avatar
dave1959
PostsCOLON 5138
JoinedCOLON Wed Oct 02, 2013 8:43 pm
LocationCOLON Ontario

Re: Career Win %

Post by dave1959 »

So, I have added all current GMs to the TAB

including Final Conference Standings each year, and playoff record


(there are 7 of us that have never made the playoffs)
User avatar
thom54
PostsCOLON 7459
JoinedCOLON Mon Mar 12, 2012 4:00 pm
LocationCOLON Kingston, ON

Re: Career Win %

Post by thom54 »

dave1959 wroteCOLONSo, I have added all current GMs to the TAB

including Final Conference Standings each year, and playoff record


(there are 7 of us that have never made the playoffs)
Paul’s ears are burning
User avatar
Matthew
PostsCOLON 13682
JoinedCOLON Wed Oct 08, 2014 3:29 pm

Re: Career Win %

Post by Matthew »

Arian The Insider wroteCOLON
Matthew wroteCOLONSeems wrong when only 7 teams over .500 and that many teams below .400 with only 2 teams over .600
Includes ties so it can't be compared to a .500 record we see in real life sports (e.g. 35-35-12)
Ties in our format added or bot added still does not affect the .500
ANAHEIM DUCKS | FANTRAX |
User avatar
dave1959
PostsCOLON 5138
JoinedCOLON Wed Oct 02, 2013 8:43 pm
LocationCOLON Ontario

Re: Career Win %

Post by dave1959 »

of course it does

the way I did it

Wins divided by Wins+Losses+Ties
so say 10W 11L 3T = 10/24 = .416 win %

if you take out ties

it would be 10/21 = .476 win %
User avatar
thom54
PostsCOLON 7459
JoinedCOLON Mon Mar 12, 2012 4:00 pm
LocationCOLON Kingston, ON

Re: Career Win %

Post by thom54 »

well then a tie is counted as a loss, where it should be a 50% of a win , no?
User avatar
dave1959
PostsCOLON 5138
JoinedCOLON Wed Oct 02, 2013 8:43 pm
LocationCOLON Ontario

Re: Career Win %

Post by dave1959 »

ok

so I changed the formula to add 1/2 ties

changed the initial thread post to GMs instead of Team
User avatar
Matthew
PostsCOLON 13682
JoinedCOLON Wed Oct 08, 2014 3:29 pm

Re: Career Win %

Post by Matthew »

If you add up every teams record it should equal to .500, since in every matchup there are 32 points awarded between 2 teams. Being equally over and under .500 no matter if there are ties or not.
ANAHEIM DUCKS | FANTRAX |
User avatar
The BBKL Insider
PostsCOLON 22628
JoinedCOLON Mon May 03, 2010 8:46 pm
LocationCOLON San Juan, Puerto Rico

Re: Career Win %

Post by The BBKL Insider »

That's an incredible amount of work Dave! Thanks!
Image
User avatar
Arian The Insider
PostsCOLON 7304
JoinedCOLON Mon May 03, 2010 7:05 pm

Re: Career Win %

Post by Arian The Insider »

Matthew wroteCOLONIf you add up every teams record it should equal to .500, since in every matchup there are 32 points awarded between 2 teams. Being equally over and under .500 no matter if there are ties or not.
Are you looking at the GM records? It doesn't have every year for every team.
Click Oilers image below for full team roster
Image
User avatar
dave1959
PostsCOLON 5138
JoinedCOLON Wed Oct 02, 2013 8:43 pm
LocationCOLON Ontario

Re: Career Win %

Post by dave1959 »

Arian The Insider wroteCOLON
Matthew wroteCOLONIf you add up every teams record it should equal to .500, since in every matchup there are 32 points awarded between 2 teams. Being equally over and under .500 no matter if there are ties or not.
Are you looking at the GM records? It doesn't have every year for every team.

Right.... I only did current GMs.

I don't give a fuck about the quitters :D :D
User avatar
hong57
PostsCOLON 7106
JoinedCOLON Mon May 03, 2010 7:38 pm

Re: Career Win %

Post by hong57 »

dave1959 wroteCOLONby GM

(for total scoring category W-L-T)

4 David-Minnesota (Hong)-2010 0.632
I should be 2009 too I'm one of the very few original Gms like steve mike billy arian and whoever i left out
Image
#91 - John Tavares
User avatar
hong57
PostsCOLON 7106
JoinedCOLON Mon May 03, 2010 7:38 pm

Re: Career Win %

Post by hong57 »

hong57 wroteCOLON
dave1959 wroteCOLONby GM

(for total scoring category W-L-T)

4 David-Minnesota (Hong)-2010 0.632
I should be 2009 too I'm one of the very few original Gms like steve mike billy luke and whoever i left out
Image
#91 - John Tavares
BUTTON_POST_REPLY

Return to