Home  |  About  | Last |  Submit  |  Contact
AllQuests.com



Previous Question:  Password Protect VBA Code  Excel QuestionsNext Question:  Returning rows by matching keyword on repeating data set  Excel Questions
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
=

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

Previous Question:  Password Protect VBA Code  MrExcel Message Board  Excel QuestionsNext Question:  Returning rows by matching keyword on repeating data set  MrExcel Message Board  Excel Questions

- 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