Paul Neuhaus
09-25-2006, 09:59 AM
For all you footbal fans, here's an interesting little fact I found on the Chicago Bears website. It's an explanation of how the NFL QB rating system is calculated. Some people just have WAY too much time on their hands to invent formulas like this!
The following was copied and pasted right from the website.
The following is the formula which works when entered into Microsoft Excel. There are 196 characters which must be typed perfectly, without any spaces to calculate it correctly. The formula uses five factors: attempts (a1), completions (b1), gross yards (c1), touchdowns (d1) and interceptions (e1). Here it is: =(round(((((max(min(2.375,(((b1*100)/a1)–30)*(0.05)),0))+(max (min(2.375,((d1*100)/a1)*(0.2)),0))+(max(min(2.375,(((e1*100)/a1) –9.5)*(–0.25)),0))+(max(min(2.375,((c1/a1)-3)*(0.25)),0)))*100)/6),1)).
The following was copied and pasted right from the website.
The following is the formula which works when entered into Microsoft Excel. There are 196 characters which must be typed perfectly, without any spaces to calculate it correctly. The formula uses five factors: attempts (a1), completions (b1), gross yards (c1), touchdowns (d1) and interceptions (e1). Here it is: =(round(((((max(min(2.375,(((b1*100)/a1)–30)*(0.05)),0))+(max (min(2.375,((d1*100)/a1)*(0.2)),0))+(max(min(2.375,(((e1*100)/a1) –9.5)*(–0.25)),0))+(max(min(2.375,((c1/a1)-3)*(0.25)),0)))*100)/6),1)).