PDA

View Full Version : NFL MVP - Formula


21C
12-06-2005, 05:17 AM
I've made a formula to rate QBs, RBs, WRs and TEs and come up with a score per game. I haven't come up with a way of rating defensive players yet.

I'm sure that it's like the BCS computer rankings - it would cause more disagreement than anything else. It's not meant to be perfect but at least it separates a guy with a 900 from someone with a 700. Actually I can't see anyone outside of my top 5 with a chance.

Updated for end of regular season - actual number of votes included.

<table x:str="" style="border-collapse: collapse; width: 295pt;" border="0" cellpadding="0" cellspacing="0" width="393"> <col style="width: 103pt;" width="137"> <col span="4" style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 103pt;" x:str="Name " height="17" width="137">Name </td> <td class="xl24" style="width: 48pt;" width="64">Pos</td> <td class="xl24" style="width: 48pt;" x:str="Team " width="64">Team </td> <td class="xl24" style="width: 48pt;" width="64">Total</td> <td class="xl24" style="width: 48pt;" width="64">Actual Votes</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Shaun Alexander " height="17"> Shaun Alexander </td> <td class="xl24" x:str="SEA ">SEA </td> <td class="xl24">RB</td> <td class="xl24" x:num="">1320</td> <td x:num="" align="right">19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Larry Johnson " height="17"> Larry Johnson </td> <td class="xl24" x:str="KAN ">KAN </td> <td class="xl24">RB</td> <td class="xl24" x:num="">1176</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Tiki Barber " height="17"> Tiki Barber </td> <td class="xl24" x:str="NYG ">NYG </td> <td class="xl24">RB</td> <td class="xl24" x:num="">1156</td> <td x:num="" align="right">6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" LaDainian Tomlinson " height="17"> LaDainian Tomlinson </td> <td class="xl24" x:str="SDG ">SDG </td> <td class="xl24">RB</td> <td class="xl24" x:num="">1112</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Carson Palmer " height="17"> Carson Palmer </td> <td class="xl24" x:str="CIN ">CIN </td> <td class="xl24">QB</td> <td class="xl24" x:num="">1109</td> <td x:num="" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Steve Smith " height="17"> Steve Smith </td> <td class="xl24" x:str="CAR ">CAR </td> <td class="xl24">WR</td> <td class="xl24" x:num="">1104</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Peyton Manning " height="17"> Peyton Manning </td> <td class="xl24" x:str="IND ">IND </td> <td class="xl24">QB</td> <td class="xl24" x:num="">1016</td> <td x:num="" align="right">13</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Tom Brady " height="17"> Tom Brady </td> <td class="xl24" x:str="NWE ">NWE </td> <td class="xl24">QB</td> <td class="xl24" x:num="">1003</td> <td x:num="" align="right">10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Edgerrin James " height="17"> Edgerrin James </td> <td class="xl24" x:str="IND ">IND </td> <td class="xl24">RB</td> <td class="xl24" x:num="">996</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Larry Fitzgerald " height="17"> Larry Fitzgerald </td> <td class="xl24" x:str="ARI ">ARI </td> <td class="xl24">WR</td> <td class="xl24" x:num="">960</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Marvin Harrison " height="17"> Marvin Harrison </td> <td class="xl24" x:str="IND ">IND </td> <td class="xl24">WR</td> <td class="xl24" x:num="">936</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Chad Johnson " height="17"> Chad Johnson </td> <td class="xl24" x:str="CIN ">CIN </td> <td class="xl24">WR</td> <td class="xl24" x:num="">932</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Matt Hasselbeck " height="17"> Matt Hasselbeck </td> <td class="xl24" x:str="SEA ">SEA </td> <td class="xl24">QB</td> <td class="xl24" x:num="">928</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Drew Brees " height="17"> Drew Brees </td> <td class="xl24" x:str="SDG ">SDG </td> <td class="xl24">QB</td> <td class="xl24" x:num="">916</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Trent Green " height="17"> Trent Green </td> <td class="xl24" x:str="KAN ">KAN </td> <td class="xl24">QB</td> <td class="xl24" x:num="">915</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Santana Moss " height="17"> Santana Moss </td> <td class="xl24" x:str="WAS ">WAS </td> <td class="xl24">WR</td> <td class="xl24" x:num="">912</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" x:str=" Joey Galloway " height="17"> Joey Galloway </td> <td class="xl24" x:str="TAM ">TAM </td> <td class="xl24">WR</td> <td class="xl24" x:num="">912</td> <td>
</td> </tr></tbody> </table>

cthomer5000
12-06-2005, 05:32 AM
I would say your top 3 are probably the clear-cut top 3 contenders in real life... so at least it passes the eyeball test.

gottimd
12-06-2005, 05:47 AM
What is your formula? I wanted to do something like this for the NAFL and determine who the front runners are for the MVP in the league.

wade moore
12-06-2005, 06:35 AM
I would say your top 3 are probably the clear-cut top 3 contenders in real life... so at least it passes the eyeball test.
I think you would be relatively safe to say his top 5 are arguably the top 5 in real life also.. so that also passes the eyeball test...

Raiders Army
12-06-2005, 06:57 AM
I see problems lower on the list...for instance, I know LaMont Jordan is the man on offense for the Raiders (leads them in rushing and catches), but he's on a losing team...as is Collins. I wouldn't rank either of them before Hasselbeck or Bledsoe. Also, Steve Smith should be higher. As was said before, I don't have a problem with your top 5.

wade moore
12-06-2005, 07:22 AM
Based on the list, I'm guessing that team record may not be a large part of his formula... for instance, I wouldn't expect Fitzgerald to even make a list this long because his team is so bad...

gottimd
12-06-2005, 07:36 AM
I was just curious because I need a starting point to develop the formula. I tried and it didn't work out, so I gave up on the formula.

wade moore
12-06-2005, 07:45 AM
I was just curious because I need a starting point to develop the formula. I tried and it didn't work out, so I gave up on the formula.
Would be pretty cool to have this for MP Leagues...

gottimd
12-06-2005, 07:52 AM
Would be pretty cool to have this for MP Leagues...
That is what I am trying to do. Rather than have a voting system where not all GM's participate, have a formula driven MVP calculation which shows you the front runners as the season progresses.

21C
12-06-2005, 06:09 PM
Like I said, the formulas are not perfect but they are a starting point. Actually I did something similar for an online baseball league. I came up with some rankings to give owners an idea of the frontrunners for the MVP, Cy Young, Rookie and Reliever of the Year. It was never definitive but got people talking. So yes, I think these formulas could be used for online football leagues as well. The formulas can also be used to determine a Game Score to help to decide a Player of the Game award.

It all started as a way of simplifying the QB rating system

Formulas:

QB = 2*Completions - Incompletions + Yards/10 + 10*TD - 10*Int
Note that the [2*Completions - Incompletions] part can be done using [3*Completions - Attempts]
I also round the Yards down so that 153/10 = 15 and 157/10 = 15 as well. Just helps when working things out in my head when there's no spreadsheet around.

RB = Yards/10 + 10*TD - 10*Fumbles Lost
The result is doubled to get it comparable to QB.
Note that rushing and receiving stats are used for Yards and TDs.

WR/TE = Same as RB ( except no rushing stats used ) except result is multiplied by 4

Actually I discovered a couple of mistakes in my original formulas. I originally used straight up fumbles instead of lost fumbles and I had a bracket in the wrong spot on the receivers.

Corrected values:
Name Team Pos Total
Shaun Alexander SEA RB 1016
LaDainian Tomlinson SDG RB 964
Carson Palmer CIN QB 927
Steve Smith CAR WR 888
Edgerrin James IND RB 872
Peyton Manning IND QB 843
Tom Brady NWE QB 778
Joey Galloway TAM WR 748
Tiki Barber NYG RB 740
Marvin Harrison IND WR 740
LaMont Jordan OAK RB 732
Chad Johnson CIN WR 732
Larry Fitzgerald ARI WR 728
Drew Brees SDG QB 723

gottimd
12-06-2005, 06:29 PM
Thanks 21c. I am going to try and toy around with this and get something going for the NAFL to use through excel outputs. I agree, the one thing missing is team ranks, in which a player on a better team gets a higher adjustment.

EDIT: Should there also be something to adjust for the position itself. The chances of a TE getting league MVP over a QB/RB/WR are slim and none.

21C
12-06-2005, 08:25 PM
Feel free to adjust it yourselves. My formulas have no scientific validity to them except they come out as reasonable numbers that can be easily compared.

gottimd
12-06-2005, 08:28 PM
Sorry, I wasn't knocking your formula at all, just opening up to discussion on how to add to it.

gstelmack
12-06-2005, 08:38 PM
EDIT: Should there also be something to adjust for the position itself. The chances of a TE getting league MVP over a QB/RB/WR are slim and none.
On the other hand, for a fictional league you have the opportunity to correct this gross injustice ;)

21C
12-06-2005, 09:16 PM
Don't worry, I didn't see that you were knocking it. I just thought that anyone could use my initial formulas to build on for themselves.

gottimd
12-08-2005, 07:34 AM
Does anyone have an idea as to how the game figures out who the MVP's are? There has to be some sort of code written to determine it, or does it just take the league leaders?

gottimd
12-08-2005, 03:22 PM
I'll give anyone a buffalo nickel if they can figure the in game MVP formula out.

cthomer5000
12-08-2005, 03:24 PM
It has to be a formula. I think running a formula like this on the past season of an FOF league would go a long way to figuring it out. However i think player of games and player of weeks also might be a factor in FOF (and that makes a lot of sense).

21C
12-19-2005, 06:08 PM
Updated as of Week 15 pre-MNF.

21C
01-02-2006, 05:44 AM
Updated for end of regular season.