Page 2 of 3

Re: Career Win %

PostedCOLON Mon Mar 19, 2018 10:10 pm
by hong57
Thanks Dave, love you!

Re: Career Win %

PostedCOLON Mon Mar 19, 2018 10:14 pm
by hong57
im actually trending downwards haha..
and surprised paul didn't have a season with winning% <0.2 =P

Re: Career Win %

PostedCOLON Mon Mar 19, 2018 10:26 pm
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.

Re: Career Win %

PostedCOLON Mon Mar 19, 2018 10:31 pm
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…?

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 8:38 am
by Da_Hawks
My win% is going to be really bad for a long time haha. Nice spreadsheet!

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 8:50 am
by Matthew
Seems wrong when only 7 teams over .500 and that many teams below .400 with only 2 teams over .600

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 10:50 am
by dave1959
should I exclude ties?

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 12:20 pm
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)

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 1:57 pm
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)

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 2:09 pm
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

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 2:40 pm
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

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 2:53 pm
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 %

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 3:18 pm
by thom54
well then a tie is counted as a loss, where it should be a 50% of a win , no?

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 3:32 pm
by dave1959
ok

so I changed the formula to add 1/2 ties

changed the initial thread post to GMs instead of Team

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 3:59 pm
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.

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 5:27 pm
by The BBKL Insider
That's an incredible amount of work Dave! Thanks!

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 7:04 pm
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.

Re: Career Win %

PostedCOLON Tue Mar 20, 2018 7:33 pm
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

Re: Career Win %

PostedCOLON Wed May 09, 2018 1:16 am
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

Re: Career Win %

PostedCOLON Wed May 09, 2018 1:17 am
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