2019 Custom Power Ranking Challenge

[clintec]

Custom Power Ranking Challenge, create your Power Ranking TODAY!

This year I am starting up a new challenge. This event allows each participant to create their very own Power Ranking score and compete against other individuals scoring system. For those who are interested, I have released the Custom Power Ranking Tab within the D2 Statistics Spreadsheet. If you are interested in participating in this challenge and seeing how awesome of a Power Ranking algorithm you personally can create, this event is for you. I will make my Power Ranking algorithm available for all to see as an example to the group.

To participate, you can either add your Custom Power Ranking as a followup to this group, or you can PM it to me.

Rules

1. Each participant can only have 1 Custom Power Ranking.
2. The Custom Power Ranking must be built leveraging the available statistical fields defined below.
3. Your Custom Power Ranking cannot simply be Winning Percentage only.
4. Each entry must be able to be automatically calculated.
5. The Custom Power Ranking can be tweaking through Week 8.
6. I will work with you to perform any mathematical calculation (within limits of my time).
7. The participant can select to have their Custom Power Ranking algorithm marked as private. This means that only the value will be shown to others. The actual algorithm will not.
8. Public algorithms will be will be documented in this topic.
9. The winning Power Ranking will be leveraged next year as the de-facto standard that will be used. Next years challenge will be compared against the winning entry.
10. The winning participant will receive bragging rights of just being awesome.
11. All Custom Power Rankings logic will be made available at the end of the season in a public GitHub repo. This will encourage others to participate next season.

My Algorithm
Description
The concept is to average the average percents and weight them. So the Winning Percentage counts for 1/3 of the overall Power Ranking Percentage. The offense gets 25% of the overall based on various statistics. The defense gets 25% of the overall based on various statistics. Special Teams (and Penalties) account for 1/6 of the overall percentage.

Calculation Methods
Average method is the sum of these statistic percentages divided by the number of statistics being averaged.
Percent_Of_Max method is calculated as: (statistic / max_statistic_across_all_schools)
Reverse_Percent_Of_Max method is calculated as: ((max_statistic_across_all_schools - statistic) / max_statistic_across_all_schools)

Algorithm

Offense Score = Average(
    '3rd Down Conversion Pct_Pct'    
    '4th Down Conversion Pct_Pct'
    'Completion Percentage_Pct'
    'Red Zone Offense_Pct'
    Percent_Of_Max(
        'First Downs Offense_FD'
        'Passing Offense_Pass Com'
        'Passing Offense_Yds/Comp'
        'Passing Offense_YPG'
        'Passing Offense_Pass TD'
        'Rushing Offense_Yds/Rush'
        'Rushing Offense_YPG'
        'Rushing Offense_Rush TD'
        'Scoring Offense_PPG'
        'Team Passing Efficiency_Pass Eff'
        'Total Offense_YPG'
        'Total Offense_Yds/Play'
    )
    Reverse_Percent_Of_Max(
        'Fumbles Lost_Fum Lost'
        'Sacks Allowed_Avg'
        'Tackles for Loss Allowed_Avg'
        'Turnovers Lost_Turn Lost'
    )
    (1.0 - ('Passes Had Intercepted_Int' / 'Passes Had Intercepted_Pass Att'))
)

Defense Score = Average(
    '3rd Down Conversion Pct Defense_Pct'
    '4th Down Conversion Pct Defense_Pct'
    'Red Zone Defense_Pct'
    Percent_Of_Max(
        'Defensive TDs_TDs'
        'Fumbles Recovered_Fum Rec'
        'Passes Intercepted_Opp Int'
        'Scoring Defense_Avg'
        'Team Passing Efficiency Defense_Pass Eff'
        'Team Sacks_Avg'
        'Team Tackles for Loss_TFLPG'
        'Turnover Margin_Avg'
        'Turnovers Gained_Turn Gain'
    )
    Reverse_Percent_Of_Max(
        'First Downs Defense_Opp FD'
        'Passing Yards Allowed_Opp Cpl'
        'Passing Yards Allowed_Yds/Comp'
        'Passing Yards Allowed_YPG'
        'Rushing Defense_Yds/Rush'
        'Rushing Defense_YPG'
        'Rushing Defense_Opp Rush TDs'
        'Total Defense_YPG'
        'Total Defense_Yds/Play'
    )
)

Special Team Score = Average(
    Percent_Of_Max(
        'Blocked Kicks_Blkd'
        'Blocked Punts_Blkd Punts'
        'Kickoff Returns_Avg'
        'Net Punting_Net Yds'
        'Punt Returns_Avg'
    )
    Reverse_Percent_Of_Max(
        'Blocked Kicks Allowed_Blkd'
        'Fewest Penalties_Penalties'
        'Fewest Penalties Per Game_PenPerGame'
        'Fewest Penalty Yards_PYards'
        'Fewest Penalty Yards Per Game_YPG'
        'Kickoff Return Defense_Avg'
        'Punt Return Defense_Avg'
    )
    ('Blocked Punts Allowed_Blkd Punts' / Blocked Punts Allowed_Punts)
)

ClinTec Power Ranking = ('Winning Percentage_Pct' * 33.3%) + (Offense Score * 25%) +
                        (Defense Score * 25%) + (Special Team Score * 16.7%)

Available Statistical Fields

'3rd Down Conversion Pct_Rank'
'3rd Down Conversion Pct_3rd Att'
'3rd Down Conversion Pct_3rd Conv'
'3rd Down Conversion Pct_Pct'
'3rd Down Conversion Pct Defense_Rank'
'3rd Down Conversion Pct Defense_Opp 3rd Conv'
'3rd Down Conversion Pct Defense_Opp 3rd Att'
'3rd Down Conversion Pct Defense_Pct'
'4th Down Conversion Pct_Rank'
'4th Down Conversion Pct_4th Conv'
'4th Down Conversion Pct_4th Att'
'4th Down Conversion Pct_Pct'
'4th Down Conversion Pct Defense_Rank'
'4th Down Conversion Pct Defense_Opp 4th Conv'
'4th Down Conversion Pct Defense_Opp 4th Att'
'4th Down Conversion Pct Defense_Pct'
'Blocked Kicks_Rank'
'Blocked Kicks_Blkd'
'Blocked Kicks Allowed_Rank'
'Blocked Kicks Allowed_Blkd'
'Blocked Punts_Rank'
'Blocked Punts_Opp Punts'
'Blocked Punts_Blkd Punts'
'Blocked Punts Allowed_Rank'
'Blocked Punts Allowed_Punts'
'Blocked Punts Allowed_Blkd Punts'
'Completion Percentage_Rank'
'Completion Percentage_Pass Com'
'Completion Percentage_Pass Att'
'Completion Percentage_Pct'
'Defensive TDs_Rank'
'Defensive TDs_Fum Ret TDs'
'Defensive TDs_Int Ret TDs'
'Defensive TDs_TDs'
'Fewest Penalties_Rank'
'Fewest Penalties_Penalties'
'Fewest Penalties_PYards'
'Fewest Penalties Per Game_Rank'
'Fewest Penalties Per Game_Penalties'
'Fewest Penalties Per Game_PenPerGame'
'Fewest Penalty Yards_Rank'
'Fewest Penalty Yards_Penalties'
'Fewest Penalty Yards_PYards'
'Fewest Penalty Yards Per Game_Rank'
'Fewest Penalty Yards Per Game_Penalties'
'Fewest Penalty Yards Per Game_PYards'
'Fewest Penalty Yards Per Game_YPG'
'First Downs Defense_Rank'
'First Downs Defense_Opp Rush 1st'
'First Downs Defense_Opp Pass 1st'
'First Downs Defense_Opp Pen 1st'
'First Downs Defense_Opp FD'
'First Downs Offense_Rank'
'First Downs Offense_RuFD'
'First Downs Offense_PaFD'
'First Downs Offense_PnFD'
'First Downs Offense_FD'
'Fumbles Lost_Rank'
'Fumbles Lost_Fum Lost'
'Fumbles Recovered_Rank'
'Fumbles Recovered_Fum Rec'
'Kickoff Return Defense_Rank'
'Kickoff Return Defense_Opp KO Ret'
'Kickoff Return Defense_KO TB'
'Kickoff Return Defense_Opp KO Ret Yds'
'Kickoff Return Defense_Opp Kick Ret TDs'
'Kickoff Return Defense_Avg'
'Kickoff Returns_Rank'
'Kickoff Returns_KO Ret'
'Kickoff Returns_KO Ret Yds'
'Kickoff Returns_Kick Ret TDs'
'Kickoff Returns_Avg'
'Net Punting_Rank'
'Net Punting_Punt Yds'
'Net Punting_Opp Punt Ret Yds'
'Net Punting_Punts'
'Net Punting_TB'
'Net Punting_Net Yds'
'Passes Had Intercepted_Rank'
'Passes Had Intercepted_Pass Att'
'Passes Had Intercepted_Int'
'Passes Intercepted_Rank'
'Passes Intercepted_Opp Pass'
'Passes Intercepted_Opp Int'
'Passes Intercepted_Int Ret Yds'
'Passes Intercepted_Int Ret TDs'
'Passing Offense_Rank'
'Passing Offense_Pass Att'
'Passing Offense_Pass Com'
'Passing Offense_Int'
'Passing Offense_Pass Yds'
'Passing Offense_Yds/Att'
'Passing Offense_Yds/Comp'
'Passing Offense_Pass TD'
'Passing Offense_YPG'
'Passing Yards Allowed_Rank'
'Passing Yards Allowed_Opp Cpl'
'Passing Yards Allowed_Opp Pass'
'Passing Yards Allowed_Opp Pass Yds'
'Passing Yards Allowed_Opp Pass TDs'
'Passing Yards Allowed_Yds/Att'
'Passing Yards Allowed_Yds/Comp'
'Passing Yards Allowed_YPG'
'Passing Yards per Completion_Rank'
'Passing Yards per Completion_Pass Com'
'Passing Yards per Completion_Pass Att'
'Passing Yards per Completion_Pass Yds'
'Passing Yards per Completion_Avg'
'Punt Return Defense_Rank'
'Punt Return Defense_Opp Punt Ret'
'Punt Return Defense_Opp Punt Ret Yds'
'Punt Return Defense_Opp Punt Ret TDs'
'Punt Return Defense_Avg'
'Punt Returns_Rank'
'Punt Returns_Punt Ret'
'Punt Returns_Punt Ret Yds'
'Punt Returns_Punt Ret TDs'
'Punt Returns_Avg'
'Red Zone Defense_Rank'
'Red Zone Defense_Opp RZAtt'
'Red Zone Defense_Opp RZ Rush TD'
'Red Zone Defense_Opp RZ Pass TD'
'Red Zone Defense_Opp RZ FG Made'
'Red Zone Defense_Opp RZScores'
'Red Zone Defense_Pct'
'Red Zone Offense_Rank'
'Red Zone Offense_RZAtt'
'Red Zone Offense_RZ Rush TD'
'Red Zone Offense_RZ Pass TD'
'Red Zone Offense_RZ FG Made'
'Red Zone Offense_RZScores'
'Red Zone Offense_Pct'
'Rushing Defense_Rank'
'Rushing Defense_Opp Rush'
'Rushing Defense_Opp Rush Yds'
'Rushing Defense_Yds/Rush'
'Rushing Defense_Opp Rush TDs'
'Rushing Defense_YPG'
'Rushing Offense_Rank'
'Rushing Offense_Rush'
'Rushing Offense_Rush Yds'
'Rushing Offense_Yds/Rush'
'Rushing Offense_Rush TD'
'Rushing Offense_YPG'
'Sacks Allowed_Rank'
'Sacks Allowed_Opp Sacks'
'Sacks Allowed_Opp Sack Yds'
'Sacks Allowed_Avg'
'Scoring Defense_Rank'
'Scoring Defense_TDs'
'Scoring Defense_Opp XP'
'Scoring Defense_2PT'
'Scoring Defense_Opp DXP'
'Scoring Defense_Opp FGM'
'Scoring Defense_Opp Saf'
'Scoring Defense_Pts'
'Scoring Defense_Avg'
'Scoring Offense_Rank'
'Scoring Offense_TDs'
'Scoring Offense_PAT'
'Scoring Offense_2PT'
'Scoring Offense_Def Pts'
'Scoring Offense_FG'
'Scoring Offense_Saf'
'Scoring Offense_Pts'
'Scoring Offense_PPG'
'Tackles for Loss Allowed_Rank'
'Tackles for Loss Allowed_Opp STFL'
'Tackles for Loss Allowed_Opp ATFL'
'Tackles for Loss Allowed_Opp TFL'
'Tackles for Loss Allowed_Opp Tackle Yds'
'Tackles for Loss Allowed_Avg'
'Team Passing Efficiency_Rank'
'Team Passing Efficiency_Pass Att'
'Team Passing Efficiency_Pass Com'
'Team Passing Efficiency_Int'
'Team Passing Efficiency_Pass Yds'
'Team Passing Efficiency_Pass TD'
'Team Passing Efficiency_Pass Eff'
'Team Passing Efficiency Defense_Rank'
'Team Passing Efficiency Defense_Opp Pass'
'Team Passing Efficiency Defense_Opp Cpl'
'Team Passing Efficiency Defense_Opp Int'
'Team Passing Efficiency Defense_Opp Pass Yds'
'Team Passing Efficiency Defense_Opp Pass TDs'
'Team Passing Efficiency Defense_Pass Eff'
'Team Sacks_Rank'
'Team Sacks_Sacks'
'Team Sacks_Sack Yds'
'Team Sacks_Avg'
'Team Tackles for Loss_Rank'
'Team Tackles for Loss_STFL'
'Team Tackles for Loss_ATFL'
'Team Tackles for Loss_Tackle Yds'
'Team Tackles for Loss_TTFL'
'Team Tackles for Loss_TFLPG'
'Time of Possession_Rank'
'Time of Possession_TOP'
'Time of Possession_AvgTOP'
'Total Defense_Rank'
'Total Defense_Plays'
'Total Defense_YDS'
'Total Defense_Yds/Play'
'Total Defense_Off TDs'
'Total Defense_Opp TDs'
'Total Defense_YPG'
'Total Offense_Rank'
'Total Offense_Plays'
'Total Offense_YDS'
'Total Offense_Yds/Play'
'Total Offense_Off TDs'
'Total Offense_YPG'
'Turnover Margin_Rank'
'Turnover Margin_Fum Rec'
'Turnover Margin_Opp Int'
'Turnover Margin_Turn Gain'
'Turnover Margin_Fum Lost'
'Turnover Margin_Int'
'Turnover Margin_Turn Lost'
'Turnover Margin_Margin'
'Turnover Margin_Avg'
'Turnovers Gained_Rank'
'Turnovers Gained_Fum Rec'
'Turnovers Gained_Opp Int'
'Turnovers Gained_Turn Gain'
'Turnovers Lost_Rank'
'Turnovers Lost_Fum Lost'
'Turnovers Lost_Int'
'Turnovers Lost_Turn Lost'
'Winning Percentage_Rank'
'Winning Percentage_W'
'Winning Percentage_L'
'Winning Percentage_T'
'Winning Percentage_Pct'

[GrifFan]

Maybe I missed it, but how is the winning algorithm determined?

[clintec]

That's an excellent question... and I would absolutely take suggestions...
It could be:

• Highest Ranking for the National Champion.
• Earliest Ranking of the National Champion.
• Closest Final 4

This is why I'm cutting off the "adjustment" period a few weeks early so that it becomes fair the last few weeks and through the post season. Again, I'm up for suggestions on "exact" specifics on how to score (or in this case rank) the algorithms.

Once we land the judging criteria, I'll update the "rules"...
But here are my thoughts:

Scoring Algorithms
1 point / week for each Conference Champ being listed as #1.
2 points / week for each Super Region Champ being listed in top 5 for SR.
3 points / week for National Championship Contender being listed in top 5 overall.
4 points / week for each Super Region Champ for being listed #1 in SR.
5 points / week for National Champion being listed #1 overall.

Thoughts / Suggestions?