Writers of Pro Football Prospectus 2008

11 Aug 2011

Bugs/Issues Thread

When you play with team defenses, they have their sacks projected as both defensive stats and offensive passing stats! Therefore, if your league penalizes sacks on passing plays, your defense gets penalized for the very same sacks that it produces!

Posted by: Yaguar on 11 Aug 2011

72 replies , Last at 13 Sep 2011, 10:49am by tally

1
Re: Bugs/Issues Thread
by Aaron Schatz :: Thu, 08/11/2011 - 6:54pm

Grrr. We'll get that fixed.

2
Re: Bugs/Issues Thread
by fdctrumpet :: Thu, 08/11/2011 - 7:01pm

Can't figure out how to have lists of each position individually....there's the master list of everyone, but difficult to break it down by position. Couldn't find help in the instructions... is sorting the position column the only way?

3
Re: Bugs/Issues Thread
by Aaron Schatz :: Thu, 08/11/2011 - 7:02pm

Yaguar, I just uploaded a fix for your issue.

fdctrumpet, use the filters on the top of each column in Excel.

4
Re: Bugs/Issues Thread
by Lomn :: Thu, 08/11/2011 - 7:16pm

Kick/Punt return yardage is absent.

Let me note, though, how much I appreciate the per-position PPR settings. Much better than manually doubling TE reception stats each update.

6
Re: Bugs/Issues Thread
by CheeseHead :: Thu, 08/11/2011 - 8:23pm

yes, return yards aren't showing up in the special teams column

5
Re: Bugs/Issues Thread
by jluhrsen :: Thu, 08/11/2011 - 8:17pm

Shouldn't my players be color coded by position? They were in last years
spreadsheet, but it's not showing up that way now.

7
Tight Ends
by bcolt44 :: Thu, 08/11/2011 - 8:24pm

Not sure if I'm using it correctly. But when I look at tight ends, it has only one tight end scoring positively over the baseline. When I go the 'Scoring' sheet, I put in '1' under the tight end option. Shouldn't the 12th (in my case) rated tight end be at zero?

19
Re: Tight Ends
by Zac :: Fri, 08/12/2011 - 8:50am

Check what you have "Waiver Adjustment" at. If it's set at 2, then TE (and also K, DEF, IDP) get lowered down, because the idea is that you aren't going to draft a backup at that position, so they get lowered down so the 12th starter gets lowered to what your last backup RB/WR/QB is.

8
Re: Bugs/Issues Thread
by Aaron Schatz :: Thu, 08/11/2011 - 8:32pm

Yeah, we didn't get the kick/punt yardage in, or the colors done. We'll have that tomorrow night. We figured you wouldn't want to wait for it.

There's actually a note on the UPDATE page that explains.

9
Re: Bugs/Issues Thread
by CheeseHead :: Thu, 08/11/2011 - 10:10pm

Steve Smith went from NYG --> PHI, but I can't find him in KUBIAK
Jerricho Cotchery went from NYJ --> PIT, but I can't find him in KUBIAK

Thanks for the great product!!!

10
Re: Bugs/Issues Thread
by qckendall :: Thu, 08/11/2011 - 10:14pm

Man, this is better than Christmas

One note--the 100 yd games for most WRs were not captured in the spreadsheet

11
Re: Bugs/Issues Thread
by jluhrsen :: Thu, 08/11/2011 - 10:51pm

Thanks for the quick reply Aaron. I missed the update sheet. my bad.

As another has said, great product.

Thanks!

12
Re: Bugs/Issues Thread
by Nickorton86 :: Fri, 08/12/2011 - 12:09am

I switched to Mac last year and just found out that the Macros will not work with Excel 2007 for Mac. Will the macros work with Excel 2010? Is there any way to get functionality with another program? I play in two very unconventional leagues and the basic Kubiak is not so much help.

16
Re: Bugs/Issues Thread
by DRoemelt :: Fri, 08/12/2011 - 7:17am

Office 2011 for MAC or you need to use VM Ware or Parallels (perhaps others) and install windows; provided you have an intel based mac

22
Re: Bugs/Issues Thread
by Nickorton86 :: Fri, 08/12/2011 - 11:40am

Thanks D Roemeit, I do run Parallels to play Strat-o-Matic but I don't have Office on my Parallels machine. I got the 30-day trial of Excel 2011 which should hold me over til draft day if I can figure out how to get it installed.

13
Re: Bugs/Issues Thread
by Mr. Housebroken :: Fri, 08/12/2011 - 12:14am

I remember last year feeling like the playoff adjustment considered the weakness of the week 17 opponents for some reason even though it says it doesn't in the instructions. For instance last year the Steelers got a bump but one of their opponents during the fantasy playoffs had a good defense as projected. Anyhow, not sure if that was or is an issue this year but it felt pretty odd to me last year when looking at the DVOAs leading up to the playoffs ahead of time. Anyhow, I still went far and won at least half if not 2/3 of my leagues. I made it to the championship in all of them thanks to KUBIAK.

You going to turn the names of the players into links to go to the appropriate FO webpage so we can see the comparables quicker?

O and Matt Roth is missing... he signed with the Jaguars.

30
Re: Bugs/Issues Thread
by Key19 :: Fri, 08/12/2011 - 6:26pm

For some reason, I cannot re-sort the Fantasy Points Over Baseline column when I tweak various numbers like I could in the 2010 version. For example, if I change Andre Johnson's TDs to 0, his FPOB value plummets. Last year, I'd just right click any box in the FPOB column and hit "Sort Largest to Smallest" and Andre would get properly re-slotted in accordance with his new FPOB value. This year, that doesn't seem to work at all. The players no longer move when the Sort function re-slots their FPOB value, and as a result the numbers get really screwed up. Not sure why this would be broken, but it's a major problem for a guy like me who likes to tinker with a bunch of the projections. Any insight on how to fix this would be helpful. Thanks, and I love the projections as always! Nice work.

EDIT: The problem seems to be in the Sort function's auto-calibrated selection window. In 2010, the program "selects all" cells while performing the Sort function. In 2011, it only selects cell columns CM-CZ. This seems to be why the players don't move; their column (along with everything else to the left of CM) doesn't get automatically selected for some reason. Anyone know how to fix this?

EDIT 2: The BO-CC columns seem to be the cause of the problem. If you "select all" on any cell to the left of that region, it will only select all of the cells to the left of the BO-CC region. If you "select all" on any cell in the BO-CC range, it will only select all the cells in that range. And of course, if you do the same with any cell to the right of the BO-CC range, it'll only select all the cells to the right of the BO-CC range. I hope this helps diagnose the problem.

EDIT 3 - PROBLEM RESOLVED: The problem turned out to be the "Intentionally Left Blank" columns. Not sure why they are new in this year's version of KUBIAK, but I deleted them and things are working fine without them and my problem is also resolved now. I'll leave this post here just in case anyone else has this problem.

14
Re: Bugs/Issues Thread
by frievalt :: Fri, 08/12/2011 - 2:38am

FFPOB for TEs seems to set default baseline = 4

15
Re: Bugs/Issues Thread
by trojandave2006 :: Fri, 08/12/2011 - 2:55am

Auction values for the version I downloaded earlier today are wildly off from the version I just downloaded - even with the same settings. Under "baseline" the auction adjustment went from .3899 this morning to .6421 tonight. I triple checked my scoring settings and both sheets are identical.

17
Re: Bugs/Issues Thread
by Yaguar :: Fri, 08/12/2011 - 7:58am

Cosmetic: In the QB battles tab, it acts as if Roethlisberger is still suspended, as he was last year.

18
Re: Bugs/Issues Thread
by widderslainte :: Fri, 08/12/2011 - 8:24am

KUBIAK really likes all of my keepers. There must be a bug :)

20
Re: Bugs/Issues Thread
by spitz10 :: Fri, 08/12/2011 - 9:34am

I'm looking at the auction value column (DA) - I am in a 14 team league with an $82.50 cap. Am I missing something, or should the sum of that column not be $1155? Kubiak is currently showing $1120 (so $35 off).

Anyone see a similar problem, or can explain this to me?

25
Re: Bugs/Issues Thread
by bird jam :: Fri, 08/12/2011 - 1:04pm

Similarly, I am in a 12-team ($200 cap) league so my total auction values should be $2400. I currently get $2392.40. It's close, I suppose, but it still seems like that should be $2400 or something like $2399.99. That's about seven and a half bucks unaccounted for.

26
Re: Bugs/Issues Thread
by bird jam :: Fri, 08/12/2011 - 3:47pm

The most recent update has a total for all players of $2384.53 . The problem seems to be getting worse.

28
Re: Bugs/Issues Thread
by Zac :: Fri, 08/12/2011 - 4:41pm

This sounds like the same bug I found last year. When I get home I'll figure out where the mistake in the formula was, and then maybe one of these years someone will actually fix that so that we don't have to do it ourselves.

29
Re: Bugs/Issues Thread
by bird jam :: Fri, 08/12/2011 - 5:11pm

Cool. If you find it, let me know.

31
Re: Bugs/Issues Thread
by Zac :: Fri, 08/12/2011 - 6:54pm

Alright, change the formula in C40 of the baselines tab to
=((nrAuctionBudget*nrPlayers)-(nrAuctionMin*nrAuctionPopulation))/SUM(OFFSET($'2011 KUBIAK Projections'.CZ2,0,0,nrAuctionPopulation-nrAuctionBenchCount,1))

And change the formula in C41 to
=((nrAuctionBudget*nrPlayers)-(nrAuctionMin*C36)-nrSalarySpent)/(SUM(OFFSET($'2011 KUBIAK Projections'.CZ2,0,0,nrAuctionPopulation-nrAuctionBenchCount,1))-C34)

Add up everything in column DA of the 2011 Projections Tab. If it worked it should be within a few dollars of your total salary cap. I have a total league salary of $2400, and I'm getting a total of $2403 now. The extra $3 isn't because of this calculation, it's because there are 207 players listed with an auction value, even though only 204 are getting drafted.

If this ends up being correct, then maybe we can make sure that someone in charge sees this so that I don't have to figure this out again next year :)

32
Re: Bugs/Issues Thread
by bigdumbjay :: Fri, 08/12/2011 - 7:47pm

Zac,

Thanks for the formula - I'm getting a formula error in Office 2007 with the first reference in the OFFSET function. It doesn't seem to like $'2011 KUBIAK Projections'.CZ2

I'm wondering if that's a unique issue to my software, or if anyone else is getting that?

33
Re: Bugs/Issues Thread
by spitz10 :: Sat, 08/13/2011 - 11:31am

That period before CZ2 just needs to be changed to an exclamation mark.

34
Re: Bugs/Issues Thread
by Zac :: Sat, 08/13/2011 - 11:37am

Ah sorry. As I wrote earlier I use go-oo and not Excel, and that must be a difference in how they define certain functions.

35
Re: Bugs/Issues Thread
by spitz10 :: Sat, 08/13/2011 - 11:40am

Dang, that formula - while putting me closer to the value - still leaves me about $11 off or so.

36
Re: Bugs/Issues Thread
by spitz10 :: Sat, 08/13/2011 - 11:41am

Thanks for the help though Zac - good stuff.

37
Re: Bugs/Issues Thread
by Zac :: Sat, 08/13/2011 - 5:00pm

How many people get drafted in your league, and how many have a value of $1 or more?

38
Re: Bugs/Issues Thread
by spitz10 :: Sat, 08/13/2011 - 5:13pm

Hmmmm, kinda tricky. Technically its a dynasty league - 14 teams, each team has 25 roster spots, cap of $82.50, and minimum salary of $0.75.

Presumably though, you could just assume it was a standard draft league, in which case 350 players would be drafted. We also have 5-IDP flex spots though.

42
Re: Bugs/Issues Thread
by bird jam :: Tue, 08/16/2011 - 9:08am

And now $2382.61. Definitely getting worse. Aaron and Sean? Little help?

43
Re: Bugs/Issues Thread
by Aaron Schatz :: Tue, 08/16/2011 - 10:28am

The answer is that we've never been able to work out a formula that both:

1) Makes the total add up to the actual total of dollars spent in the league
2) Forces prices on a specific number of bench players to be league minimum in order to simulate the way auction drafts actually work out in fantasy football

If you can figure out how to make it work, please feel free to contact us, but we figure 2 is more important than 1. Values are supposed to be approximate anyway. Just as the projections don't actually mean that we believe that players are guaranteed to hit those numbers, dollar values don't actually mean that players are guaranteed to be worth that amount.

44
Re: Bugs/Issues Thread
by bird jam :: Tue, 08/16/2011 - 2:11pm

I understand that it is difficult to create an auction values spreadsheet and my technical know-how is depressingly wanting. So I can't offer any help on formulas and such, especially at the level of Excel mastery KUBIAK seems to be. But back when I was doing a spreadsheet the old-fashioned way (calculating FPOB by position, generating an "x" number, then multiplying it all out for dollar values,) the number always added up to the total dollar figure. That seemed like the easy part. Again, I could be wrong - incorporating #2 may make #1 impossible. (Although I wonder if there might be a way that we could input the number of $1 players we anticipate will be drafted, and then split up the rest of the money among the remaining players. The # of $1 players in my league is fairly constant...)

I also understand that these dollar figures are, for lack of a better word, "estimates" just as projections are estimates. But I think you are making the best the enemy of the better there. The figures may be estimates, but I assume you want the estimates to be as good as possible, no? And I can't tell you with any certainty what any single player will do on the field this year, but I can tell you one thing with certainty: every team in my league will spend every dollar they have at the auction. I would think - despite the obvious impossibility of getting any of this stuff exactly right - you would aim to be as close to perfect as possible.

46
Re: Bugs/Issues Thread
by Aaron Schatz :: Tue, 08/16/2011 - 2:42pm

Who says we don't? I said we couldn't get there, not that we haven't tried.

47
Re: Bugs/Issues Thread
by bird jam :: Tue, 08/16/2011 - 2:53pm

Oh, I know you do, and you do the best job of anybody out there. "These are just estimates anyway" just sounded like a cop-out.

21
Re: Bugs/Issues Thread
by dryheat :: Fri, 08/12/2011 - 10:01am

Just like last year, I get a basic scripting error when I generate using OpenOffice. Last year I got around it be e-mailing the spreadsheet to my office computer, which has Excel, and hope I didn't get caught. I was hoping not to have to do that this year.

Is there a fix, or a compatible version of KUBIAK for OpenOffice or Works (curse my rotten luck to have purchased both computers during the ill-fated Works days)?

23
Re: Bugs/Issues Thread
by jabrch :: Fri, 08/12/2011 - 12:30pm

I saw a note somewhere that it is not compatible with Open Office. You can move files from a PC to another PC without emailing it. I know "disks" have gone the way of the dodo bird, but you can use a USB memory stick or any other device to move that file.

"peripherlaly" un/related note - I was cleaning out my basement and found an assortment of the following...

8 inch floppy diskettes
5.25 in floppy diskettes (double density I might add)
Iomega ZIP disks
3.5 in disks
A Bernoulli Box
A Jaz drive

and my crown jewel - my old Compaq "portable" computer. For anyone who believes that was actually "portable", I'd like to see them carry arond a stack of 10 laptops with a handle - and try and "work" on a 9 inch green screen... Sorry - I digress...

24
Re: Bugs/Issues Thread
by dryheat :: Fri, 08/12/2011 - 12:59pm

Thanks. I ended up e-mailing it. Sticking an unauthorized flash drive in my work computer is going to end up with me in handcuffs.

27
Re: Bugs/Issues Thread
by Zac :: Fri, 08/12/2011 - 4:39pm

I use go-oo ( http://go-oo.org/ ) which is a flavor of open-office that is more Excel compatible. The scripts compile at least, but the flex baseline didn't update at all. I had to change it in the baselines tab manually and then manually sort by the points over baseline column.

A couple things people should know if they try this (I would not recommend it unless you are pretty good with spreadsheets and can figure out whether the numbers it's showing are correct).

1. You have to do a Find/Replace on the cheatsheets tab. Make sure you're searching in formulas (probably have to click the more options button to get that to show up), do a find for FALSE() and replace it with FALSE . You need to do that because open-office considers FALSE a constant, whereas in Excel false is defined by a function.

2. For some reason, some TEs get their position changed to AA. I'm pretty sure this happened to me last year as well. I think it's a bug in the script, and I'll look it up and see if I can find where it happens. You have manually change them all back to TE.

54
Re: Bugs/Issues Thread
by joel.schopp :: Thu, 08/18/2011 - 3:35pm

Instead of go-oo you should switch to libreoffice. I can't get the auction values to work in it, but otherwise most of the spreadsheet seems functional.

60
Re: Bugs/Issues Thread
by Zac :: Sat, 08/20/2011 - 8:02pm

Well I had a bunch of errors due to capitalization differences. Once I fixed them in the macro to match the defined names that part was fine. However I can't get the flex baseline to work right now.

39
Re: Bugs/Issues Thread
by dlorenw :: Tue, 08/16/2011 - 12:24am

Just downloaded the 8/15/ update. The auction values for QBs are all haywire and I'm not sure why. In the 8/14 version the qb values are in line. That is the auction values seem to track the values for other players. Vick's value is right between the value of the RB above him and the RB beneath him. In the 8/15/ QB auction values are way out of line, somewhere in the nature of 60% of the auction values of the 8/14 update and way lower than, in Vick's case, the RB above him and the RB below him. I've triple checked my settings and I genuinely don't think I've screwed up scoring in any way (I'm trying to approximate a standard ESPN scoring league as closely as possible -- can't quite make that happen with team defense points surrenderred defaults in KUBIAK). have I screwed something up or did something in the 8/15 update go haywire? Ideas??

40
Re: Bugs/Issues Thread
by dlorenw :: Tue, 08/16/2011 - 1:34am

apparently I'm a moron because it's fixed now and I have no idea how it got fixed. Awkward silence. . . Ummm, I'll go back to making my bar graphs now . . .

41
Re: Bugs/Issues Thread
by DRoemelt :: Tue, 08/16/2011 - 2:11am

Soooo many numbers, I'm confused.

I can't sleep tonight and it has nothing to do with fantasy football - but this post brightened my night without sleep - thank you.

Seriously wish I had my FOA 2011 to pass the time with until dawn . . . . .

45
Re: Bugs/Issues Thread
by toccony :: Tue, 08/16/2011 - 2:26pm

Is there somewhere that all the headings are explained. I 'm talking about the headings on the columns

48
Re: Bugs/Issues Thread
by tobin.marcus :: Tue, 08/16/2011 - 5:52pm

Are the playoff strength-of-schedule adjustments right? The big negative adjustment for Minnesota was surprising to me given who they're playing in weeks 14-16, and then when I looked at the instruction page, it still had this specific reference to strong defenses at the end of Minnesota's *2010* schedule:

"For example, Minnesota players have an adjustment below 100% because the Vikings play strong defenses in Weeks 14-16 (Giants, Bears, Eagles) and a weak defense in Week 17 (Lions)."

It's possible that this is just a cosmetic error on the instruction page, and the explanation for the numbers is that KUBIAK thinks the Lions, Saints, and Redskins (Minnesota's actual 2011 Week 14-16 opponents) have much better defenses than I expect. But given the surprising number and erroneous text, I wanted to make sure the adjustments were correct and updated for 2011.

Thanks!

49
Re: Bugs/Issues Thread
by Aaron Schatz :: Tue, 08/16/2011 - 6:11pm

Sorry. Cosmetic error. I'll fix that.

50
Re: Bugs/Issues Thread
by t2green2 :: Wed, 08/17/2011 - 9:48pm

just downloaded 8.17 and cannot import or save my kubiak settings. I can generate but nothing more....Yes Macros enabled excel 2007

51
Re: Bugs/Issues Thread
by jayhawkco :: Wed, 08/17/2011 - 9:52pm

Had that happen yesterday for a second. Closed and reopened and it worked fine. Does it give you a little crosshair for moving the buttons as it did me?

Chris

52
Re: Bugs/Issues Thread
by TruFloridaGator :: Thu, 08/18/2011 - 8:54am

Same issue, cannot import settings with 8.17

53
Re: Bugs/Issues Thread
by mcbrown :: Thu, 08/18/2011 - 10:45am

Another person with "import settings" issues:

1. In the latest file the Save/Import buttons are actually unclickable (Generate/Print work fine). Macros enabled, Excel 2010.

2. I *can* run the Save/Import macro directly. When I do so, the settings file doesn't save to C:\temp, but to the last folder I opened a file from. And it looks to import from the same folder (did an experiment to confirm that a different set of settings in C:\temp were not loaded).

55
Re: Bugs/Issues Thread
by apollos :: Fri, 08/19/2011 - 10:31am

Cannot generate, save or import settings with 8/17 using 2003. It crashes the program upon initial open and then uses a repaired version after that.

56
Re: Bugs/Issues Thread
by spujr :: Fri, 08/19/2011 - 10:53am

Besides the save/import functions listed above I noticed a couple of other (small things):

Some league score settings are not taken into account. I don't know if they are too random to predict or not included because they are not important. I will just add them as a FYI:

1. 2 point conversion scoring
2. Field goals missed based on yardage (ie. -2 for missing a 0-19 yard kick)
3. Defense/special teams block kick points (ie 2 points for team block kick)

Lastly, this is more cosmetic, but I thought I would point it out:

Shouldn't cells C40, C44, and C50-52 on the "Scoring" sheet be written with a formula like:
="Receiving Game Bonus WR ("&E50&" yard)"

Again, it's very minor. Otherwise everything looks very well done and awesome. Thanks!

57
Re: Bugs/Issues Thread
by Aaron Schatz :: Fri, 08/19/2011 - 11:02am

OK, it looks like there's some kind of problem with the Active X controls that handle saving and importing score settings. We're trying to fix it.

We don't do two-point conversions, FG missed based on yardage, or blocked kicks because they are too random to predict.

58
Re: Bugs/Issues Thread
by Aaron Schatz :: Fri, 08/19/2011 - 11:48am

OK, hopefully problem with Active X controls is now fixed.

59
Re: Bugs/Issues Thread
by lloyd :: Sat, 08/20/2011 - 10:25am

Still no joy for me. The Save and Import buttons are not clickable on the latest download (...0819)

Edit: Works on Excel 2010 Windows, but not 2011 Mac.

61
Re: Bugs/Issues Thread
by jabrch :: Mon, 08/22/2011 - 3:54pm

Just downloaded the new updates and ran them - got a Runtime error "Type mismatch"

Anyone else?

Ignore this - Stupid User...

62
Re: Bugs/Issues Thread
by CheeseHead :: Mon, 08/22/2011 - 11:45pm

Lee Evans still has BUF in Column F

63
Re: Bugs/Issues Thread
by Zac :: Tue, 08/23/2011 - 10:56am

I think the Current Auction Value column assumes that $1 is your league minimum, even if you've entered something else in the settings. I have a dynasty league with a $450 salary cap and a $5 minimum, and all the min value players showed up at $1.

64
Re: Bugs/Issues Thread
by CheeseHead :: Mon, 08/29/2011 - 11:32pm

On the Schedule/Bye Tab for QBs week 8 byes, it says NYG v. NE. It should say NYG v. MIA

65
Re: Bugs/Issues Thread
by lloyd :: Wed, 08/31/2011 - 4:29pm

Anyone else get the following error when doing "Save my KUBIAK"?

Run-time error '1004':

PasteSpecial method of Range class failed.

(Office 2010)

Also, the QB Job Battles tab says "Each team (except Pittsburgh) has one prospective starting quarterback ranked." Unintentional holdover from last season?

67
Re: Bugs/Issues Thread
by Aaron Schatz :: Sat, 09/03/2011 - 3:38pm

I've fixed the Pittsburgh thing. I would recommend re-downloading and trying that. If you still have a problem, send the messed-up spreadsheet to us at mailbag-at-footballoutsiders.com.

66
Re: Bugs/Issues Thread
by atwilson0328 :: Wed, 08/31/2011 - 7:13pm

I changed the Flex count to 0 but I can't make KUBIAK update and use the non-Flexed baselines. (I can find the baselines manually, but it ignores them.) Thoughts?

68
Re: Bugs/Issues Thread
by bigdumbjay :: Mon, 09/05/2011 - 1:16pm

There's no IDP projection for Darnell Dockett as of KUBIAK 9/4/2011. Is there a reason for that? As far as I can tell, he's projected to start.

69
Re: Bugs/Issues Thread
by bird jam :: Fri, 09/09/2011 - 9:55am

Aaron, this is about as minor a cosmetic quibble as can possibly exist, but I just noticed that when I print my KUBIAK rankings it still says "2010 Football Outsiders KUBIAK" at the top of every page. Thought you might want to know.

70
Re: Bugs/Issues Thread
by lechrus2@yahoo com :: Fri, 09/09/2011 - 11:40am

I made several posts in the Experts League Results article discussing the weird anomaly that went down in my auction draft. I'd really like someone from FO to weigh in on the subject. I'll re-post the jist of it here.

In my auction draft the following results occurred:
Top 15 QB's went for 166% of the KUBIAC auction values on average
Top 30 RB's went for 75% of the KUBIAC auction values on average
Top 30 WR's went for 100% of the KUBIAC auction values on average

I have spent quite some time deliberating on the cause of this systematic anomaly. I struggle accepting that this was dynamic of our particular auction/league because the results were too consistent. I think it may have something to do with how FO ranks the relative values of QB's to RB's in my scoring system. I have triple checked the entries for our scoring system and manually checked the value for several QBs and RBs to be sure that KUBIAC was accurately calculating the values and found the projections were accurate.

Might there a problem with the algorithm that ranks the relative importance of QB contribution versus RB contribution in my scoring sytem? I believe this is a value based approach. FO noted that QB's in their expert auction draft were consistently undervalued indicating perhaps a similar issue with the relative rankings of QB's versus other positions.

Puzzling.

71
Re: Bugs/Issues Thread
by bird jam :: Sat, 09/10/2011 - 2:12pm

I think you're confusing the value of those players with what they are expected to go for. KUBIAK doesn't tell you what players will go for in your league. It can't possibly account for the personalities of the people in your league. It merely tells you, based upon the projected stats of players (and what those stats will yield using the scoring system you put into it,) what those players are WORTH. Not what they will go for at the auction.

In my league, the top QBs rarely go for what KUBIAK says they are worth, and most WRs go for a lot more. When I run my KUBIAK projections, I have to take that into account. If it says Larry Fitzgerald is "worth" $40, I have to realize that in my league it is going to cost me a lot more than that to get him. (On the flipside, when it tells me that Phillip Rivers will be worth $70, I know I probably won't have to spend that to get him.)

I think an option that might be useful to auction drafters would be a place on the scoring page to input league history stats and spit out values that way. For instance, if I could put in that my league drafts on average 24 QBs and spends, say, $350 on them. Do that across all positions and then adjust the values accordingly.

That may be too complicated for Aaron and Sean to accomplish but if it's not I think it would be helpful.

72
Re: Bugs/Issues Thread
by tally :: Tue, 09/13/2011 - 10:49am

What birdjam said. The auction values do not predict average auction values in the wild any more than snake draft KUBIAK rankings predict ADP.

If you want average auction values, you can look those up very easily on the web or on your league homepage, then use KUBIAK to compare and pinpoint undervalued players.

Login or register to post comments