LOGIN

I was never particularly motivated to use VLOOKUP (or any other function in Excel) for “professional” working purposes. I learned it a few years ago strictly to become better at fantasy baseball. By taking all of the public information that is available at your disposal, and combining fantasy valuations and projections from various industry resources (using mostly VLOOKUPs – seriously, it’s the only thing that I know how to do), you can formulate composite projections which paint an accurate picture of the fantasy landscape, and eliminate limit your individual bias when you inevitably use those projections and re-rank players by position. One resource that I find particularly helpful, and which you might not already incorporate into your own process, are the player propositions and betting over/under totals provided by sportsbooks. The betting market sets extremely reasonable expectations with regards to player floors and league leaders in statistical categories and can provide guidance as to where your projections stand relative to public perception both on an individual player basis, and against the league as a whole.  The fact that a player is listed in a category, in and of itself, can be extremely telling as to their raw skills and expectations for the upcoming season.

Please, blog, may I have some more?