QB Score Formula

F

footballstatsfan

New Member
Joined
Aug 31, 2009
Messages
15
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=...v=onepage&q=yards per passing attempt&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.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Sort by date Sort by votes
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.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
Try this I did this a while ago.


QB Passer Rating Formula.xls
ABCDEFG
1CompAttemptsYardsTD'sIntPasser Rating
232446139693510112.8
3266741493312423210796.8
4202539012798921221070.9
531247840093411105.5
6243034021122.2
726401992272.8
819322712194.7
920362170161.9
104136355069341796.2
11321476365319797.4
124015984583301496.9
1315291690240.7
1422402171258.0
15222440040158.3
162894793238211086.4
Sheet1



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
 
Upvote 0
I got it to work using the median function.
 
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Question
Excel 2007 - Bi-annualy bonus pool formula
Replies
5
Views
1K
fchachar
F

Forum statistics

Threads
1,215,020
Messages
6,122,709
Members
449,093
Latest member
Mnur

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top