+/- TR gap from a stats junkie

Cervidal · Post by **Cervidal** » Sun Jan 19, 2003 11:36 pm

http://www.geocities.com/budbeumel/LeagueSheet.xls

I just put this together for the league I currently play in and I'll be updating it every week or so.

We use a coach reputation ranking in our league to determine which is the best and worst in our league. The math is kinda messy but, in short, the better your team is than your opponent (both in Rep and TR) you gain fewer Rep points for winning and lose more for losing. The inverse is also true; if you are the underdog, you get more for winning but you risk fewer points.

I put together that spreadsheet for two reasons. One, I like having hard evidence for labelling certain coaches 'baby seal clubbers'. Two, I wanted to see if the best and worst teams got to where they are because of the TR differences in their games, an important topic regarding open leagues.

It appears that coaches get to the top both ways. Some by playing tough opposition and winning a few more than they lose and some because they play exclusively against cupcakes. The teams that play cupcakes, though, tend to take much bigger nosedives when they finally do lose/tie those lesser teams, whereas the teams who play the tougher opposition are much more resiliant to a loss or three.

Sixpack595 · Post by **Sixpack595** » Mon Jan 20, 2003 6:06 am

With my record I expect them to beat down my door for a game.

I'm of the opinion that you should beat on the best opponant possible. The more losses you deliver to the front runners, the farther you pull away.

Marcus · Post by **Marcus** » Mon Jan 20, 2003 8:31 am

Cervidal: that link doesn't work. I'd be interested in looking at your ranking algorithm. We're starting a new ECBBL season soon and we have a large number of coaches. So much so that our usual scheduled fixtures may have to go out the window. We've been considering a "team index" style of open league setup and I'd be interested in seeing how yours compared.

Indigo · Post by **Indigo** » Mon Jan 20, 2003 9:01 am

me too - I'll check it out and get back to you with how I felt it worked out

Cervidal · Post by **Cervidal** » Mon Jan 20, 2003 10:19 am

Grr... it's because I'm trying to host it on GeoCities. Apparently linking the site to a message board violates their terms of agreement.

I'll post more shortly.

Sixpack595 · Post by **Sixpack595** » Tue Jan 21, 2003 6:06 pm

Just cut and paste. It will work

Anthony_TBBF · Post by **Anthony_TBBF** » Tue Jan 21, 2003 6:42 pm

Right click and hit "Save Target As..." works too.