Open Office doesn't support VBA macros... so you won't be able to click the Generate Cheatsheets button...

On Version O, each position tab had extra players added to the bottom of the page (below the "ZZ - Add Player" rows). These players were not listed on versions before and after. Will these players, specifically James Jones, be added again to future versions? How come these players were not just incorporated into the overall position lists (blue cells)? Thanks.

Internally, we keep two spreadsheets. One that is released each week with the basic players that get drafted in typical drafts... and another one that goes a little deeper that is used as the basis for the DD Player Pool. Version O was released by accident. If the players down there, become more likely to start, they will get moved up though into the blue cells.

Thanks for the response Bruce. I usually print out the overall lists on the "input" tab. I want the projected stats for every player I can get. Some of the added players in Version O had better projected stats than some of the other players at their position. Hopefully some of these guys will be added soon. Thanks again.

note 1 - sorry if this has been covered, i couldnt find anything on it
note 2 - i posted this on the general board as well, as a new topic, then realized it probably should have been posted here. sorry for the duplication....


first time using this tool (my auction is 2 days before season starts)....

if i have the setting for 10 teams, 2 QB... thats a total of 20 QB to be selected. The 20th QB is listed with a value of $7. shouldnt he be $1? there are currently 27 QB with a value over $1. the same is true of some other positions.

also, if i add up the values of all the players who will be selected (top 20 qb, top 10 kickers, etc...) it comes to a total of $2094 being spent, when there will, in actuality be $3000 spent.

hope someone can explain to me! if this tool works out for my auction, i think itll really give me an edge. i'll post my league settings below in case you were wondering....

note: i dont think it should matter for this, but on the individual pages for QB, RB, etc. i have deleted the value in the "fantasy points" column and replaced it with my own projections in some cases, then re-generated cheetsheet.

10 teams, $300 cap. 2 QB, 2 RB, 3 WR, 1 flex RB/WR, 1 TE, 1 K, 2 DEF (team).
i have the following settings on the "input tab"
auction on, team cap $300, fudge 0.00, min bid $1
rounds of draft 0, teams 10, qb 2, rb 2, wr 3, te 1, pk 1, def 2, db 0, lb 0, dl 0
flex 2.7, 3.3, 1

See my reply on your other post.