2012 NHL Playoff pool CHEAT SHEET! Win your pool!!
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.
Thanks for this, always look forward to this every year.
People got to learn how to use punctuation. On our radio ads the other day a black man's wallet was reported as missing. Instead of a man's wallet black in colour missing a black man's wallet is missing.
I always like tinkering with this each year, but curious if you've compiled any #'s regarding results. For people who pick all the series winners correct, what kind of success are they having with the players suggested?
Thank you all for your kind comments! Hope it helps you all out, good luck!
Originally Posted by CaptainCamaro
i think there is something wrong with nashville, no matter how far i send them in the playoffs no one shows up on the top 20
people with less points in the season on other teams show up before any NSH people do
EDIT: actually it looks like the top 20 just doesnt update properly
As mentioned above by Oil Gauge, you do have to sort the second tab, as per the included instructions. If you did pick NSH to go all the way, after sorting it will show these top Preds in order (where they are in the final list will depend on your other choices):
22.9 Martin Erat
21.8 Alexander Radulov
19.8 Mike Fisher
19.0 David Legwand
17.6 Shea Weber
16.3 Ryan Suter
16.1 Sergei Kostitsyn
Originally Posted by brtriad
San Jose is on there twice instead of Detroit.
??? I don't see what you're saying. SJ is there once.