Q: I see this cheatsheet is made for Microsoft Excel 2007. What about other spreadsheet programs?
- A: I'd love to make it accessible for other programs such as OpenOffice or something for Mac computers but OpenOffice is not powerful enough to handle the complexity of the cheatsheet and I don't have access to any other spreadsheet programs to work with. If someone wants to send me a free Macbook to try to build the spreadsheet onto, go for it!
Ideally, I'd like to make the logic of this spreadsheet into a web app for the future but I have no experience in that area so if you'd like to help, send me an e-mail.
Q: Why does Excel ask me if I want to enable macros when I open this? What kind of trickiness is this?
- A: Macros make the spreadsheet able to do neat things beyond the normal capabilities of Excel and these spreadsheets definitely go beyond the normal capabilities of Excel. So enable macros so my spreadsheet can run little lines of code behind the scenes in order to make your experience super awesome.
- A: Despite my best efforts, there might be a player drafted that is not included on these spreadsheets. When these players are drafted, feel free to mark that a player has been drafted by choosing Non-Ranked Player from the bottom of the sheet. This will keep the 'Current Pick' notation in line with the draft.
- A: Some of the projections systems did not project for a particular player (in Marcel's projections, for example, they rely on past track record so a lot of rookies are not projected). In order to keep the spreadsheet working, those players have their projections blanked out. You can still mark them as drafted but they will have no effect on the Live Results sheet.
- A: That's our WERTH point system. The WERTH values represent an estimation of how many points in the standings you would gain by owning a player over an average fantasy starter. An average fantasy started is defined as the player that would have your team perform perfectly middle-of-the-road in every category. High draft picks generally generate more positive fantasy points than average while most lower players negatively affect your team (your goal in a draft is obviously to minimize that effect). Also, generally catchers will score you less points or cost you points while first basemen generally award you a good amount of points. More information found here.