Writers of Pro Football Prospectus 2008

28 Aug 2012

Overflow error when generating kubiak with my custom league settings

Anybody seen this? "Runtime error 6: overflow" when trying to generate kubiak after inserting my league settings. If I don't put in my custom settings, it generates fine. So something about my league's settings.
This is using today's download (20120828).

Here are my league settings if relevant:

Application Settings
RB Baseline method 1
Tight End method 1
Risk Adjustment 1
Playoff Adjustment 2
Waiver Adjustment 2
Auction method 2

League Settings Start
Number of League Participants 12
How many QB? 1
How many RB? 2
How many WR? 3
How many TE? 1
How many RB/WR flex? 0
How many K? 1
How many Team Defenses? 1
How many IDP-DB? 0
How many IDP-CB? 0
How many IDP-SAF? 0
How many IDP-DL? 0
How many IDP-DE? 0
How many IDP-DT? 0
How many IDP-LB? 0
How many IDP Flex?* 0
How many Bench? ** 3
* NOTE: Flex calculations will not include DL, as in most IDP leagues DL do not receive enough points to be worth an IDP flex position.
** NOTE: Please do not include any bench positions which are required to be TE, K, or IDP.
Offensive Skill Player Points Per
Passing Attempts 0
Passing Completions 0
Passing Yards 1 50
Passing TDs 6
Passing Interceptions -1
Passing Game Bonus (300 yard) 3
Rushing Attempts 0
Rushing Yards 1 15
Rushing TDs 6
Rushing Game Bonus (100 yard) 1
Receptions WR 0
Receptions TE 0
Receptions RB 0
Receiving Yards 1 15
Receiving TDs 6
Receiving Game Bonus WR (100 yard) 1
Receiving Game Bonus TE (100 yard) 1
Receiving Game Bonus RB (100 yard) 1
Fumbles Lost -1
Quarterback Sacks -1
Punt Return Yards 100 1
Kick Return Yards 100 1
Special Teams TDs 6
NOTE: Long Touchdowns are too random to project

Kicker Points
PAT 1
PAT Missed
FG (0-39) 3
FG (40-49) 4
FG (50+) 5
FG Missed 0

Team Defense / Special Teams Points Per
Interceptions 2
Forced Fumbles 0
Recovered Fumbles 2
Safeties 2
Sacks 1
Defensive TD 6
Punt Return Yards 50 1
Kick Return Yards 50 1
Special Teams TD 6
Shutouts 5
Points Allowed (1 to 6) 10
Points Allowed (7 to 13) 7
Points Allowed (14 to 20) 4
Points Allowed (21 to 27) 0
Points Allowed (28 to 34) -1
Points Allowed (35+) -3
Net Yards Allowed (0-199) 0
Net Yards Allowed (200-249) 0
Net Yards Allowed (250-299) 0
Net Yards Allowed (300-349) 0
Net Yards Allowed (350-399) 0
Net Yards Allowed (400-449) 0
Net Yards Allowed (450-499) 0
Net Yards Allowed (500+) 0
Three-and-outs 0

Individual Defense (IDP) Points Per
Tackles (total) 0
Tackles (unassisted / solo) 1
Tackles (assists) 0.5
Pass Defended 1
Interceptions 3
Forced Fumbles 1
Recovered Fumbles 1
Safeties
Sacks 3
Defensive TDs 6
Punt Return Yards 0 0
Kick Return Yards 0 0
Special Teams TDs 6

Auction Details
Budget $100
Minimum Bid $1.00
Bench TE/K/D 0
Aggressiveness 3

Posted by: jbrians on 28 Aug 2012

1 reply , Last at 28 Aug 2012, 5:09pm by jbrians

1
Re: Overflow error when generating kubiak with my custom leagu
by jbrians :: Tue, 08/28/2012 - 5:09pm

FYI – it looks like the TEAM DEFENSE/Special teams punt & return yardage point values were the problem. I had it reversed so it was 50 points per yard instead of 50 yards per point. Apparently this results in unreasonably large point values. :)

It would be nice if the spreadsheet handled this more gracefully and said something like "50 points per yard is unreasonable!" rather than carrying along merrily until it runs into an overflow error.

Login or register to post comments