RPI Tool

[rackem12]

Was wondering if anyone could help me out with an Rating Percentage Index (RPI) tool.

There used to be one at https://techgraphs.fangraphs.com/an-rpi-spreadsheet-for-you-yes-you/ but it seems it has been taken down.

I am trying to calculate RPI for a sports project I am working on and the WP is the easy part, but getting the OWP and OOWP seems to baffle my mind on how to attack it.

For those who do not know the RPI formula you can find it at https://www.google.com/url?sa=t&rct...entage_index&usg=AOvVaw0Em8UOvIavFDYq7GEDLE7T

Thanks in advance!

 

[rackem12]

Just to add a little more clarification...

I am trying to create a spreadsheet in which as I input games played for a certain sport, the sheet will automatically calculate my winning percentage, my opponents combined winning percentage, and my opponents opponents combined winning percentage. This would be based on the games they have played, necessarily every other team (some teams won't play each other during the season).