Version 4.0 for 10, 12, 14, 16 Team Leagues

We are apparently having issues with the file sharing site we were using, Ufile.io, so if  you want a 10, 12, 14 or 16-team spreadsheet,  drop me a note at the email address posted at the bottom of this page and I'll attach the file requested to my reply. I will never sell, give away, or make public your email address. However, if you include your league name and general location and want me to mention that publicly, I will do that. I am always interested in how many and the locations of the leagues that are using the OMFPR.

V4.0 EXPLAINED:

The Oberon Mt. Fantasy Power Rating is designed to measure the level of success of fantasy football owners by means other than win/loss record alone. It is comprised of four elements: average points scored per game; wins vs. the rest of the league year-to-date; scoring trend over the most recent three weeks; and winning trend over the most recent three weeks against the rest of the league.

A value for these elements is determined each week, weighted, and averaged together to determine the power rating for that week. The weights for each element were determined by plugging in actual scores taken from 2024 leagues and seeing which produced fair results according to our power rating philosophy, in what we refer to overall as logic testing.

A quick note about the Trend elements - We tried extending the trend period from the 3 weeks we used for Scoring Trend in version 3 to four weeks, but after many tests we found it unfairly rewarded poor teams that had one exceptionally good week, and unfairly punished good teams that had one unusually bad week.

Official power ratings cannot be produced until after the Week 4 games for various reasons, including the need for accurate trend data, as well as “division by zero” problems which appear as #DIV/0! in a cell.

ELEMENTS:

Average Points Scored per Game (PPG)-

Total points for scored for the season is a basic power rating used by most leagues as a playoff seeding tie-breaker. We convert this into a per game average and give it a weight of 30%.

Wins vs. the Rest of the League -

Our power rating is designed to compare owners beyond simply by win/loss record. A great way to do this is by comparing a team's score for the week not only against their head-to-head opponent, but also with every other team in the league. The To-date Win's vs. the Rest of the League element does this, and keeps a running winning percentage. This is multiplied by 200 which gives us a number that has provided a fair and accurate comparative score. This element is a very telling way of comparing the success of an owner over the course of the season, so this is given a weight slightly over that of the points scored average, 32%.

Scoring Trend -

Sometimes teams have a very good first few games of the season and then run out of steam after the midway point, or start out poorly and get their act together later in the season. Because a team's early start is a constant component of their PPG average, good or bad, the Scoring Trend element compares their scoring in the most recent 3 games with that same element from the previous week. For instance, after week #8 games we average a team's score from weeks 6-8 and divide that number by that team's average score for weeks 5-7. This produces a ratio which we then multiply with the post-week 8 average points per game (element one above) to give us their Scoring trend. If the scoring trend is up, the ratio will be over 1 and the resulting trend value will be more than the value from week 7. If the trend is down, the value will be less. The weight given to this element is 18%.

Wins vs. the Rest of the League Trend -

This element compares a team's average wins vs. the rest of the league for the current and most recent previous 2 weeks with this element reported after the previous week (the average of the number in the “overall wins for the season” column for those weeks). The ratio is determined by dividing the current week's average by the previous week's average to get the Trend Ratio. We then multiply that ratio by the Wins vs. the League value. The weight given to this element is 20%.

POWER RATING:

(PPG x 30) + (Scoring Trend x 18) + (Wins vs Rest of League Trend x 20) + (Wins vs. Rest of League value x 32)

100

Points per Game value times weight of 30

Scoring Trend value times weight of 18

Wins vs the rest of the League value times weight of 20

Wins vs. the Rest of the League value times weight of 32

The Spreadsheet -

Columns A through AG are used to determine the power ratings. Commissioners only need to enter Owners and/or Team names in column B and the scores each week in column C. Column AF will auto-fill as you enter information into column B.

Columns AH through AZ are included for commissioner's who like to provide their owner's with some sort of report each week. We've chosen the information that most owners would be interested in, but you can change this to suite your league. As it is set now, all of these columns will auto-fill. You can delete these columns AH through AZ if are distracting.

Feel free to contact me with any errors you find, or with questions, comments and/or suggestions. Email oberonmtffl@gmail.com