• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1845
  • Last Modified:

Excel formula for NFL passer rating

I've got columns for completions / attempts / TDs / interceptions --

I need a formula for passer rating.  I can't seem to get an accurate one that matches NFL stats.

Presume Completions is C2, Attempts is A2, TDs is T2, and Interceptions is I2

Thanks.
0
blakogre
Asked:
blakogre
  • 4
  • 2
1 Solution
 
barry houdiniCommented:
According to Wikipedia you also need Passing Yards for the NFL version - do you have that?

regards, barry
0
 
blakogreAuthor Commented:
Ah, yes: P2.  Sorry :-)
0
 
barry houdiniCommented:
Try this formula for the rating

=(MEDIAN(0,2.375,(C2*100/A2-30)/20)+MEDIAN(0,2.375,T2*100/A2/5)+MEDIAN(0,2.375,T2*100/A2/5)+MEDIAN(0,2.375,(P2/A2-3)/4))/0.06

regards, barry
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
barry houdiniCommented:
Sorry, that was wrong, I repeated the touchdown calculation and missed out the interceptions - should be like this

=(MEDIAN(0,2.375,(C2*100/A2-30)/20)+MEDIAN(0,2.375,2.375-I2*25/A2)+MEDIAN(0,2.375,T2*100/A2/5)+MEDIAN(0,2.375,(P2/A2-3)/4))/0.06

regards, barry
0
 
barry houdiniCommented:
..and here's an example using that last formula

I checked with an online calculator and it appears to give the correct results

regards, barry
27400456.xls
0
 
blakogreAuthor Commented:
That seems to work, thanks :-)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now