Hey all,
Every year I create an Excel spreadsheet to help out my buddies & I prepare for the Playoff pool. And for the past 7 or 8 years or so, I've been happy to share it with all of you. Amaze your friends with your prognasticative powers! Be the first on your block to truly be a know it all (or whatever).
It's a simple spreadsheet. Just put in how far each team will go and it will "predict" the number of points each player will get, based on each player's regular season stats. It's not rocket science, it simply looks at the player's points per game and multiplies it by the number of games/rounds YOU figure his team will play. It simply assumes 7 games played per round.
The instructions are in the first tab of the spreadsheet, where you predict the winners of each round. Start with the 1st round (of course) and the teams in the later rounds will be updated automatically. Keep going to predict the winners of those later rounds. After you're done, go to the next tab, which shows the regular season stats plus expected Playoff stats (it looks at goals & assists only). Sort this by descending points, and voila, you've got your list of players to pick!
NOTE THAT, as attached, it is just set so that the higher seeded team goes on to the next round - i.e. #1 in the West, VAN, goes all the way through to meet #1 in the East, NYR. NOTE this does not necessarily reflect my own personal opinions, predictions, or suggestions, it's just put in that way as an example.
And always keep in mind to look for injured players elsewhere (links are in the spreadsheet), and also for players that have not played a lot of games but might have a high pts/gm ratio. For example, you'll see that PIT D Carl Sneep got 1 Point Per game, but in only 1 game played. So if you predict PIT to go 4 rounds (28 games), it will "predict" him to get 28 points (and if he does, you really WILL be a know it all!!). Note also a warning message will appear for all players with < 40 games.
Anyway, hope you enjoy it. If you do use it and you don't win, hey, it wasn't my fault, don't blame me. But if you do & you win, I get 10%!
PLEASE post any comments or suggestions, I'll be glad to read them. Thanks to the many of you who have PM'ed me recently asking when this would be available. It's good to know you find it useful. I'd also like to know how you did in your pool if you did use it at all.
Also, I've had many comments in the past on making it look "cooler" - dropdowns for the teams, allow entry of # gms per series, etc.. Well, that's all nice but I've decided to keep it basic. Feel free to add any "UI enhancements" and post them in this thread.
Enjoy!
tm
For your reference, here's last year's version, which had a lot of good comments:
http://hfboards.hockeysfuture.com/sh...d.php?t=902582
