Home  |  About  | Last |  Submit  |  Contact

 Tweet

 Question QB Score Formula ( MrExcel Message Board Excel Questions )Updated: 2010-07-22 16:50:35 (7)
 QB Score Formula Been reading a book called "Statistical Thinking In Sports" authored by Jim Albert, Ruud H. Koning. In the book they talk about a relatively easy way to grade NFL quarterbacks using what they coined as "QB Score" where they use a players passing yards, number of passes and interceptions to come up with the score. Here's a link to an excerpt from google books (Page 253) http://books.google.co.uk/books?id=C...ttempt&f=false After trying several different times and ways can't seem to figure out the formula they have written. QB Score=Yards - 3 x Plays - 30 x Int Yards 3666 Plays 555 Int 26 Any help would be greatly appreciated.
 Answers: QB Score Formula ( MrExcel Message Board Excel Questions )
 QB Score Formula Is it? =3666-3*555-30*26 Andrew Poulsom
 QB Score Formula That's what I thought, but it doesn't computer to a small enough number as shown on page 254 of the link supplied. Seems strange. But I can't for the life of me figure it out. footballstatsfan
 QB Score Formula Well this: =3711-3*503-30*12 returns 1842, which is the same as QB Score per play in the first row of table 14.5. The QB Score in the next column is: =(3711-3*503-30*12)/503 Andrew Poulsom
 QB Score Formula Thanks, I was just fixing to type that I had figured it out. It seems the book left out a portion of the equation. footballstatsfan
 QB Score Formula Have you considered using the actual QB Rating system used by the NFL, you hear the Announcers talking about it all the time on the TV broadcasts... http://en.wikipedia.org/wiki/Passer_rating If so, I have a sheet with that all worked out if you want. It's just a few simple formulas. jonmo1
 QB Score Formula jonmo1 - Yes, I have played with the actual QB rating system, but always like to look at other ways of comparing players. As the above metric takes into account what a quarterbacks does with both his legs and arms. Rather then just his arm . It takes both interceptions and fumbles as well as yards and gives you a rating based on his total play rather then just what he did in the passing game. footballstatsfan
QB Score Formula

Try this I did this a while ago.

******** ******************** ************************************************************************>
 Microsoft Excel - QB Passer Rating Formula.xls ___Running: 14.0 : OS = Windows XP
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 G2G3G4G5G6G7G8G9G10G11G12G13G14G15G16 =

A
B
C
D
E
F
G
1
CompAttemptsYardsTD'sInt Passer Rating
2
32446139693510 112.8
3
2667414933124232107 96.8
4
2025390127989212210 70.9
5
31247840093411 105.5
6
243034021 122.2
7
264019922 72.8
8
193227121 94.7
9
203621701 61.9
10
41363550693417 96.2
11
3214763653197 97.4
12
40159845833014 96.9
13
152916902 40.7
14
224021712 58.0
15
222440040 158.3
16
28947932382110 86.4
 Sheet1

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

In G2:

=(IF((((A2/B2)*100)-30)*0.05<0,0,IF((((A2/B2)*100)-30)*0.05>2.375,2.375,((((A2/B2)*100)-30)*0.05)))+IF((((A2/B2)*100)-30)*0.05<0,0,IF(((C2/B2)-3)*0.25>2.375,2.375,((C2/B2)-3)*0.25))+IF(((D2/B2)*100)*0.2>2.375,2.375,((D2/B2)*100)*0.2)+2.375-(((E2/B2)*100)*0.25))*100/6

planetpj

 - Source: QB Score Formula MrExcel Message Board Excel Questions- Previous Question: Password Protect VBA Code MrExcel Message Board Excel Questions- Next Question: Returning rows by matching keyword on repeating data set MrExcel Message Board Excel Questions