Writers of Pro Football Prospectus 2008

25 Aug 2011

How to account for Recieving yds/tds by RB and Rushing for recievers?

My league has a couple rules that i'm finding difficult to integrate into kubiak.

The primary one is that Rushing tds by QBs and WRs are worth 12 instead of 6

and receiving tds by RBs count as 12

For certains qbs and RBs this can be a huge deal.

Also, rushing yards by WRs and QBs are scored at 1.5 per 10 yards vs 1 for 10 yards

and again for RBs it's 1.5 pts for 10 yards receiving.

I also have an odd quirk for QB passing yards.

here's our league's rules verbatim:

4.0 bonus point(s) for 150 to 199 total yards.
6.0 bonus point(s) for 200 to 249 total yards.
8.0 bonus point(s) for 250 to 299 total yards.
10.0 bonus point(s) for 300 to 349 total yards.
12.0 bonus point(s) for 350 to 399 total yards.
16.0 bonus point(s) for 400 to 449 total yards.
20.0 bonus point(s) for 450 to 499 total yards.
24.0 bonus point(s) for 500 to 549 total yards.
28.0 bonus point(s) for 550 to 599 total yards.

I decided to average it out at 2 pts per 50 yards. Is there a better approximation I could use? or maybe change the passing yards bonus from 300 to something else?

My first time using KUBIAK after two years not pulling the trigger. Love it so far.

Posted by: maskdmirag on 25 Aug 2011

3 replies , Last at 27 Aug 2011, 12:18am by maskdmirag

1
Re: How to account for...
by elgato7664 :: Fri, 08/26/2011 - 1:23am

Goal: QB & WR -- 1.5 pts per 10 Rush Yd & 12 pts per Rush TD
Step 1: Filter the projections to only show QB & WR
Step 2: In column Q change this part of the formula (nrRuYD)) to (nrRuYD*1.5))
Step 3: In column Q change this part of the formula (TRUNC(T_*nrRuTD)) to (TRUNC(T_*nrRuTD*2))
Step 4: Fill the column with this new formula

Goal: RB -- 1.5 pts per 10 Rec Yd & 12 pts per Rush TD
Step 1: Filter the projections to only show RB
Step 2: In column W change this part of the formula (nrReYD)) to (nrReYD*1.5))
Step 3: In column W change this part of the formula (TRUNC(Z2*nrRcTD*2)) to (TRUNC(Z2*nrRcTD*2)))
Step 4: Fill the column with this new formula

Goal: QB - Bonus Scoring System
Step 1: Filter the projections to only show QB
Step 2: In column I add this to the very end of the equation: +(L16-2800)/23.5+60
Step 3: Fill the column with this new formula

Then Generate KUBIAK Projections and you should have your results.

-------

NOTE: The QB Bonus formula is very accurate, here are actual bonuses for some QBs in 2010 & what the estimate would be using this formula

Phillip Rivers: 142 Actual, 141 Estimated
Tom Brady: 106 Actual, 107 Estimated
Joe Flacco: 96 Actual, 95 Estimated
Josh Freeman: 88 Actual, 88 Estimated

----------

Assuming the Bonus are the points awarded for passing yards & 4 pts per Passing TD, here are some examples to reference to see if you got the formulas correct:

QB Michael Vick 324 (182 passing, 160 rushing)
QB Matthew Stafford 176 (134 & 52)
RB LeSean McCoy 276 (154 Rush & 138 Rec)
RB Michael Bush 106 (78 & 29)
WR Miles Austin 163 (3 Rush & 169 Rec)
WR Brad Smith 47 (3 Pass, 41 Rush, 2 Rec, 2 Spec Team [Return TDs])

2
RE
by maskdmirag :: Sat, 08/27/2011 - 12:17am

Hmm, it all seems to be working except for the QB projections.

What should i be putting in on the scoring page for qbs to get those numbers?

3
Re: RE
by maskdmirag :: Sat, 08/27/2011 - 12:18am

never mind. I figured out my problem. Our scoring system doesn't subtract for interceptions, if i put interceptions and fumbles back in the numbers match up perfectly. thanks!

Login or register to post comments