Please use the comments below to ask me any questions you might have about Part 9, “Converting SGPs into Pitcher Dollar Values”.
Please post your questions or suggestions to improve the rankings system in the comments here.
Have you found a good way to combine the hitter and pitcher tables to create a draft “cheat sheet”? I can kind of get it to work by manually entering in the player list and using VLOOKUP (looking up the hitter/pitcher table based on the farthest right character in the name box – P or not P) to copy in the stats and ranks, but I keep running into problems where I can’t get the “cheat sheet” to get past 450ish players before I just get errors.
I personally do not combine hitters and pitchers onto one tab, but I don’t see any reason why you could not. I think the process you describe should work and I don’t see any reason why after a certain number of records it goes to all errors. My first guess would be that you might need to add the “$” references to your cell references in the formula, so that the lookup doesn’t move as you start copying the formula down to subsequent rows.
Subscribe to RSS Feed
Analysis Books Daily Fantasy FAQ Glossary How To Listenings Readings Points Leagues Projections Site Smart Elsewhere Strategy Tools
ADP Aggregate Projections Ben Zobrist Buster Posey Case Study Clayton Kershaw Create Your Own Rankings CSV Derek Carty DFS Dollar Values Draft Draft Kings Excel FanDuel Fangraphs Google Sheets Hitters In Season Analysis Jose Abreu Martin Prado Mike Trout NFBC Ottoneu Pitchers PITCH f/x Player ID Points Leagues Power Query Prince Fielder Projecting X Projections Razzball Replacement Level Ryan Braun SGP Spreadsheet Standings Gain Points Steamer Strategy Todd Zola Trading Video VLOOKUP Web Query