Writers of Pro Football Prospectus 2008

01 Aug 2012

How difficult to add in a couple other standard scoring categories

I would really prefer separate Yards per fantasy point for TE vs WR, similar to how the receptions are set up for TE vs WR in KUBIAK. Has anyone had any success in changing the white cells in the spreadsheet to factor something like this in?

Our league decided since TEs are more possession driven to award 2 pts per reception, but less points per yard. Whereas WRs get 1 pt per reception but more points per yard (stretch the field, YAC players etc). It seems a little strange that KUBIAK recognizes the points difference per reception, but considers all yards equal.

Any past success with this would be appreciated. I can kinda see where I might change the formulas in the white cells, but I just didnt know if there was something going on behind the scenes that would make this crash.

Posted by: stgandone on 01 Aug 2012

6 replies , Last at 07 Aug 2012, 6:05pm by ratay1

1
Would just need a little
by alien1rock :: Thu, 08/02/2012 - 9:24am

Would just need a little coding in column W (the Rec points column). I'm 99% sure any changes that you make there would be incorporated when you re-generate the listings, and won't be reset. You can see that there are already if/then statements to reflect that the TE can have different points per reception and yardage bonuses, so it would just be a matter of turning this segment: "+(TRUNC(Y2/nrRcYDPer,0)*(nrRcYD))" into another if/then statement.

2
Re: How difficult to add in a couple other standard scoring
by Zac :: Thu, 08/02/2012 - 10:43am

You might be able to do it a little easier by modifying TE receiving yards directly (column Y). Let's say WRs get 1 pt per 10 yards, and TEs get 1 pt per 15 yards. Then you'd just have to multiply receiving yards by TEs by 2/3 (or 10/15) to get the equivalent number.

3
Re: How difficult to add in a couple other standard scoring
by wickerman :: Fri, 08/03/2012 - 1:56pm

Genius, thanks guys, exactly what I was looking for.

4
Re: How difficult to add in a couple other...
by wickerman :: Tue, 08/07/2012 - 12:27pm

In case anyone is interested, this is the change I made to column W of my spreadsheet:

=(TRUNC(IF(D3="RB",(TRUNC(X3*nrRcRbAtt)),IF(D3="TE",(TRUNC(X3*nrRcTeAtt)),IF(D3="WR",(TRUNC(X3*nrRcWrAtt)))))))+(TRUNC(IF(D3="TE",(TRUNC(Y3/nrRcYDPer*2/3,0)),(TRUNC(Y3/nrRcYDPer,0)))*(nrRcYD)))+(TRUNC(Z3*nrRcTD))+(TRUNC(IF(D3="RB",(TRUNC(AB3*nrRcRb100)),IF(D3="TE",(TRUNC(AB3*nrRcTe100)),IF(D3="WR",(TRUNC(AB3*nrRcWr100)),0)))))

My league is 1pt/10rec yards but 1pt/15rec yards for TE's...

5
Re: How difficult to add in a couple other...
by bird jam :: Tue, 08/07/2012 - 12:55pm

Holy cow. KUBIAK is easily worth $20/year for me not to need to understand that.

6
Re: How difficult to add in a couple other...
by ratay1 :: Tue, 08/07/2012 - 6:05pm

lol

Login or register to post comments