I found the issue with the initial calculations.  I didn't exclude the Opponent in the OWP and OOWP.  That accounts for the +-.5 points in most rankings.   

3 minutes ago, JUGGSPORTS said:

I found the issue with the initial calculations.  I didn't exclude the Opponent in the OWP and OOWP.  That accounts for the +-.5 points in most rankings.   

So if you run them again, I am not asking you to, do they come out as a match?  Perfect match?

I'm all in now.  Getting the server involved.  Will let you know shortly.

Ok, I've got it sorted.  KHSAA doesn't apply the "Play Down" exemption on OWP and OOWP.  Then they Group teams WP together for average as OWP vs taking average of all opponents WP.  That's a difference in .00536 in one example.  

KHSAA also penalizes teams playing down more that twice against a team withdrawn from District Play.  Phelps is weighted at 1.15 versus a team like Holmes who is still weighted as 4A.  1A weight is 1.323 for reference.  Really weird exercise to figure out their complete logic and math.  

Great work!

Also, let’s find something better than this to seed teams for the playoffs! Most everyone would agree that the current RPI formula has some things in it that make it NOT the best (OOS comp a big one)

59 minutes ago, JUGGSPORTS said:

Ok, I've got it sorted.  KHSAA doesn't apply the "Play Down" exemption on OWP and OOWP.  Then they Group teams WP together for average as OWP vs taking average of all opponents WP.  That's a difference in .00536 in one example.  

KHSAA also penalizes teams playing down more that twice against a team withdrawn from District Play.  Phelps is weighted at 1.15 versus a team like Holmes who is still weighted as 4A.  1A weight is 1.323 for reference.  Really weird exercise to figure out their complete logic and math.  

Poster of the week for the work you have been doing!

2 hours ago, ATLCat said:

Poster of the week for the work you have been doing!

Poster of the month!  We will celebrate @JUGGSPORTS all September but once October hits it is back to normal. ?

2 hours ago, theguru said:

Poster of the month!  We will celebrate @JUGGSPORTS all September but once October hits it is back to normal. ?

I can't wait for RPI after week 1 next year now that it's figured out!!!  LOL

Completed and fully validated.  I have it down to 100 hundred thousandths of a point on some team's OOWP (I.e. 0.00001).  This will be cool to have for simulating potential playoff matchups or pondering what ifs (I.e. Ryle beating Highlands). 

The example of "If Ryle did beat Highlands":
Highlands would be #10, not #8 in 4A.
Ryle would be #6, not #10 in 6A.
Frederick Douglass would be #13, not #9 in 6A.
Covington Catholic would be #9, not #10 in 4A.
Cooper RPI would drop 0.00799 and stay #13 in 5A.
 

Everything is housed in my SQL server and can run the query in under 4 seconds.  I haven't set indexes for those nerds critiquing my query writing.  As I said earlier today, it was a cool exercise.  Now we can mock RPI in 2026 Week 3 or 4 just for fun.