Please use the comments below to ask me any questions you might have about Part 9, “Converting SGPs into Pitcher Dollar Values”.
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.
Hi Chris,
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.
Tanner