Writers of Pro Football Prospectus 2008

09 Jul 2013

Error in Defense Rankings

When the macro runs, it tries to change the formula in the FPOB column for the top defenses for whatever reason (different than last year). When it does this, a defense (or two) that isn't the highest scoring gets dumped to the top of the list. With my settings, the Bears score the most points, but a different defense is the only one with a $1 value.

Also, since I only have one defense with any monetary value, it's skewing the other values since at least $12 in my league has to be spent on defenses.

Chris

Posted by: jayhawkco on 09 Jul 2013

13 replies , Last at 22 Jul 2013, 5:04pm by jayhawkco

1
Re: Error in Defense Rankings
by bird jam :: Tue, 07/09/2013 - 4:37pm

Yeah, I just noticed that KUBIAK only has one defense getting purchased in my auction (should be at least 12).

2
Re: Error in Defense Rankings
by Aaron Schatz :: Wed, 07/10/2013 - 11:05am

We're working on fixing this.

3
Re: Error in Defense Rankings
by bird jam :: Wed, 07/10/2013 - 11:27am

Awesome, thanks Aaron.

4
Re: Error in Defense Rankings
by Aaron Schatz :: Sat, 07/13/2013 - 11:37am

We're having trouble replicating this issue. Can you please send your KUBIAK workbook to mailbag-at-footballoutsiders.com so we can take a look and figure out why you might be having this problem? Thanks.

5
Re: Error in Defense Rankings
by jayhawkco :: Sat, 07/13/2013 - 1:24pm

I'm emailing it off now Aaron. (This is with the newly downloaded update). Essentially what it looks like (from peeking at the macros) is that when it assigns the position baseline calcs to the defensive starters vs. the bench, it's not recognizing which defenses are starter worthy vs. bench worthy. I'm not sure exactly the programming logic behind doubling the baseline adjustment for "bench" defenses when determining FPOB anyway, but it's resulting in having a defense that isn't #1 (sometimes the Dolphins for me, sometimes the Rams, sometimes the Patriots) having the least negative FPOB because the baseline adjustment hasn't been doubled for them and it has been for everyone else. The Bears have the highest Dynamic Fantasy Points on my scoring system, but they're #2 every time behind a different defense because they've had the baseline calculation doubled. In turn, the random #1 defense for me is the only one with any dollar value assigned, and the other 13 defenses that would be paid for in my league all have values of $0. (Hopefully that all made sense. I'm only a wannabe programmer.)

Chris

6
Re: Error in Defense Rankings
by jayhawkco :: Sat, 07/13/2013 - 1:43pm

I might edit to add that if I change the waiver adjustment on the Scoring Tab to 1 (Regular Baseline), then it says the Bears are worth $26. I love Lance Briggs and all, but that's a bit spendy (and an indication that something isn't right with the formulae). Also, under that scenario, the Chiefs are the only defense that ISN'T worth spending at least $1 on.

Chris

7
Re: Error in Defense Rankings
by jayhawkco :: Sat, 07/13/2013 - 2:25pm

One defense gets the formula =((CNx)-nrDef)*2 applied in FPOB column, one gets =(CNx+nrWaiverAdj)-nrDef, and the rest get =((CNx+nrWaiverAdj)-nrDef)*2 (where x = row). So, one defense isn't getting the waiver adjustment taken away (which can't be right), and it's not determining which defenses are starter worthy correctly.

Chris

8
Re: Error in Defense Rankings
by Aaron Schatz :: Sat, 07/13/2013 - 6:48pm

> I'm not sure exactly the programming logic behind doubling the baseline adjustment for "bench" defenses when determining FPOB anyway

Just to answer this question: We added this wrinkle so that backup defenses would drop down the ratings and nobody would think we were telling them to take a backup defense before, say, a fifth running back. Otherwise, because defenses are so close together in projections, it would list backup defenses as the first things you should pick once your starters are done. It does the same with kickers.

9
Re: Error in Defense Rankings
by jayhawkco :: Sun, 07/14/2013 - 1:43pm

Makes sense. I'm gonna go through the macros for kicker and defense later on today to figure out why the kickers are priced correctly but the defenses aren't. Should be the exact same logic between the two.

Chris

10
Re: Error in Defense Rankings
by bird jam :: Mon, 07/15/2013 - 3:54pm

Just downloaded the 7/15/13 update and imported my league settings. It still only has one defense being purchased in the auction. (It also now has 169 players with prices for some reason - my league will draft 168 players.)

E-mailing to you now.

11
Re: Error in Defense Rankings
by Aaron Schatz :: Fri, 07/19/2013 - 12:13pm

This should now be fixed! Yay!

12
Re: Error in Defense Rankings
by bird jam :: Fri, 07/19/2013 - 1:26pm

I get 12 defenses assigned dollar values (which is good) but now I get 172 players getting assigned dollar values when only 168 players will be drafted in my league (which is bad).

13
Re: Error in Defense Rankings
by jayhawkco :: Mon, 07/22/2013 - 5:04pm

I get 12 defenses assigned dollar values as well, but there are 14 people in my league. Only 10 kickers too. Overall though, better than it was because at least the defenses are ordered correctly.

Chris