GiantsFan14 wrote:Version 9 on it's way. Some projections updated, full snake draft tracker implemented that you can adjust for # of teams (only up to 14), auction draft tracker only works for your own team but you can adjust for # of teams, % spent on hitters, and how many hitters your league starts. This won't have an affect on pitcher values yet.
Draft tracker issues: Players are not sorted by position (this is incredibly hard to do automatically) Drafted bench players are treated as full value Pitcher values are not automated yet
If you change any hitter projections, dollar values will automatically update. The changes must be made in the individual position tabs for this to work. Pitcher values are not automated yet.
If you have any questions about how anything works, please let me know. This will probably be my last update as we're getting close to the season, so good luck everyone. I hope I've been able to somewhat fill the void left by the absence of J35J's sheet this year.
Love this spreadsheet GF.
My league is 12 teams as opposed to 14. When using the snake draft tracker, I can't seem to figure out how to remove teams 13 and 14 from the standings. Deleting them from the snake draft on the left of the screen as per your instructions is simple enough, but both teams still show under the standings on the right of the screen, taking up part of the point percentage of the league. Is there a way to fix this and base the standings 1-12 instead of 1-14? Thanks man.
GiantsFan14 wrote:Version 9 on it's way. Some projections updated, full snake draft tracker implemented that you can adjust for # of teams (only up to 14), auction draft tracker only works for your own team but you can adjust for # of teams, % spent on hitters, and how many hitters your league starts. This won't have an affect on pitcher values yet.
Draft tracker issues: Players are not sorted by position (this is incredibly hard to do automatically) Drafted bench players are treated as full value Pitcher values are not automated yet
If you change any hitter projections, dollar values will automatically update. The changes must be made in the individual position tabs for this to work. Pitcher values are not automated yet.
If you have any questions about how anything works, please let me know. This will probably be my last update as we're getting close to the season, so good luck everyone. I hope I've been able to somewhat fill the void left by the absence of J35J's sheet this year.
Love this spreadsheet GF.
My league is 12 teams as opposed to 14. When using the snake draft tracker, I can't seem to figure out how to remove teams 13 and 14 from the standings. Deleting them from the snake draft on the left of the screen as per your instructions is simple enough, but both teams still show under the standings on the right of the screen, taking up part of the point percentage of the league. Is there a way to fix this and base the standings 1-12 instead of 1-14? Thanks man.
I should have put this in the instructions. You have to go to the "Draft Results" page and delete A41-AW42 (Do not shift cells). The replace all the "14"s in the equations in cells Z44-AI44 with "12"s. Team 13 and 14 will just turn into a bunch of # signs which you can just delete (again don't shift cells). Let me know if you have any problems. I'll have have to figure out an easier way to customize it for next year.
GiantsFan14 wrote:Version 9 on it's way. Some projections updated, full snake draft tracker implemented that you can adjust for # of teams (only up to 14), auction draft tracker only works for your own team but you can adjust for # of teams, % spent on hitters, and how many hitters your league starts. This won't have an affect on pitcher values yet.
Draft tracker issues: Players are not sorted by position (this is incredibly hard to do automatically) Drafted bench players are treated as full value Pitcher values are not automated yet
If you change any hitter projections, dollar values will automatically update. The changes must be made in the individual position tabs for this to work. Pitcher values are not automated yet.
If you have any questions about how anything works, please let me know. This will probably be my last update as we're getting close to the season, so good luck everyone. I hope I've been able to somewhat fill the void left by the absence of J35J's sheet this year.
Love this spreadsheet GF.
My league is 12 teams as opposed to 14. When using the snake draft tracker, I can't seem to figure out how to remove teams 13 and 14 from the standings. Deleting them from the snake draft on the left of the screen as per your instructions is simple enough, but both teams still show under the standings on the right of the screen, taking up part of the point percentage of the league. Is there a way to fix this and base the standings 1-12 instead of 1-14? Thanks man.
I should have put this in the instructions. You have to go to the "Draft Results" page and delete A41-AW42 (Do not shift cells). The replace all the "14"s in the equations in cells Z44-AI44 with "12"s. Team 13 and 14 will just turn into a bunch of # signs which you can just delete (again don't shift cells). Let me know if you have any problems. I'll have have to figure out an easier way to customize it for next year.
Cafe Home
Fantasy Football
Fantasy Basketball
Fantasy Hockey
by wingman3110 » Fri Mar 15, 2013 9:05 am 
can't wait to get my hands on this bad boy!
