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
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
Available Statistical Fields
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
- Each participant can only have 1 Custom Power Ranking.
- The Custom Power Ranking must be built leveraging the available statistical fields defined below.
- Your Custom Power Ranking cannot simply be Winning Percentage only.
- Each entry must be able to be automatically calculated.
- The Custom Power Ranking can be tweaking through Week 8.
- I will work with you to perform any mathematical calculation (within limits of my time).
- 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.
- Public algorithms will be will be documented in this topic.
- 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.
- The winning participant will receive bragging rights of just being awesome.
- 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.
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
Code:
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%)
Code:
'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'
Comment