30-03-2007 21:04

Astronouth7303

Re: paper: Midwest Regional Strength of Schedule and RPI

Care to outline some of the theory behind this?

30-03-2007 21:29

CJV648

Re: paper: Midwest Regional Strength of Schedule and RPI

It is inspired by the RPI used to rank NCAA football/basketball teams that tries to correct for the differing schedules of teams. Their approach is to use a combination of own winning pct, opponents winning pct. and opponents' opponents' winning pct. FRC's alliance setup means that we should take into account the strength of alliance partners as well.

To implement this, the spreadsheet calculated a strength of match (SOM) for each team in each match. This is based on the won-loss record of alliance partners less the won loss record of alliance opponents normalized to zero for a nuetral strength match.

Technical considerations: The 1/6 in the cell arithmetic amounts to a dummy 50 pct winning term to replace the team's own record in calculating the SOM. Appropriate subtractions are made from each alliance's win-loss records to avoid bias based on the effect on the teams' records of the outcome of the match being studied.

A team's strength of schedule (SOS) is just their average SOM.

I got lazy with my RPI and just used a weighted sum of winning pct. and SOS

30-03-2007 22:01

Astronouth7303

Re: paper: Midwest Regional Strength of Schedule and RPI

Ok.

Did you do all this by hand? Redoing the sheet for the West Michigan Regional is taking a while.

30-03-2007 22:27

CJV648

Re: paper: Midwest Regional Strength of Schedule and RPI

I'm a wiz at cut & paste, but formatting the results to fit the formulas is a pain. Give me a little bit and I'll put one up for WMR

31-03-2007 19:17

Astronouth7303

Re: paper: Midwest Regional Strength of Schedule and RPI

Seems like you ought to be able to do almost all of it in a script. (Then you could compile numbers using results from every regional!)

Last night, I did all but the last 20 matches in OpenOffice (the last 20 I put in 0's for everything). It's a little nicer, but I lost the sorting (since it can't be done automatically).

This looks like a useful tool for scouting, with some work.

31-03-2007 23:51

Jeremiah Johnson

Re: paper: Midwest Regional Strength of Schedule and RPI

Quote:

Originally Posted by Astronouth7303 Seems like you ought to be able to do almost all of it in a script. (Then you could compile numbers using results from every regional!) Last night, I did all but the last 20 matches in OpenOffice (the last 20 I put in 0's for everything). It's a little nicer, but I lost the sorting (since it can't be done automatically). This looks like a useful tool for scouting, with some work.