Both of these projects stemmed from this general rule when working with data – if you are doing the same thing repeatedly, there is a cleaner way to do it (most of the time). Indeed, over the last month or two, I’ve built a spreadsheet for Chris Clegg to help automate part of the ranking process for him and one for Mike Kurland to speed up his amazing spring training tracker. Both of these examples show how spreadsheets are a powerful tool for data analysis and creation. ![]() This is clear on a simple level with Dynasty Guru’s providing early and specialized access to their rankings on a google sheet, to a more complex use with Derek Rhodes’ handy google sheets to track Best Ball drafts. The power and usefulness of spreadsheets have been shown time and time again in the Fantasy Baseball Industry. What?! Your fantasy baseball league is not using Fantrax? Inconceivable! Check out everything Fantrax has to offer, and I’m sure you’ll come around to our way of thinking. While I will not be doing that (out of respect for my work, because it’s customized to my needs, and, and most importantly, out of respect for the rankings I pulled in because many of them are behind pay-walls and those analysts should be compensated for their labor), this series will allow you to make your own sheet, that does what you want, and equips you to update and change things yourself to customize your own fantasy rankings and strategy. I even had a few people ask if I was going to share the sheet that I showed snippets of in that piece. In this, I showed and mentioned how I utilized Excel as a major tool for integrating rankings, pulling rankings from a number of experts together to utilize all of them better. ![]() In my article last week, I talked about how we as fantasy managers must re-think how we utilize experts’ rankings in our analysis and fantasy work and study.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |