HFBoards

Go Back   HFBoards > General Hockey Discussion > National Hockey League Talk
Mobile Hockey's Future Become a Sponsor Site Rules Support Forum vBookie Page 2
National Hockey League Talk Discuss NHL players, teams, games, and the Stanley Cup Playoffs.

2012 NHL Playoff pool CHEAT SHEET! Win your pool!!

Reply
 
Thread Tools
Old
04-09-2012, 12:23 AM
  #1
tm
Registered User
 
tm's Avatar
 
Join Date: Jul 2002
Location: Toronto
Country: Macedonia
Posts: 345
vCash: 500
2012 NHL Playoff pool CHEAT SHEET! Win your pool!!

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
Attached Files
File Type: zip NHLPlayerPoolStats.zip‎ (73.4 KB, 335 views)

tm is offline   Reply With Quote
Old
04-09-2012, 02:43 AM
  #2
MooseDupont
Registered User
 
MooseDupont's Avatar
 
Join Date: Sep 2006
Posts: 161
vCash: 500
Thanks. Kind of you to share.

MooseDupont is offline   Reply With Quote
Old
04-09-2012, 03:08 AM
  #3
Hank4Hart
Registered User
 
Join Date: Apr 2007
Posts: 1,084
vCash: 500
thanks!

Hank4Hart is offline   Reply With Quote
Old
04-09-2012, 08:24 AM
  #4
tony d
Honey Nut Cheerios
 
tony d's Avatar
 
Join Date: Jun 2007
Location: Behind A Tree
Country: Canada
Posts: 37,047
vCash: 500
Thanks for this, always look forward to this every year.

__________________
tony d is offline   Reply With Quote
Old
04-09-2012, 09:09 AM
  #5
MrFunnyWobbl
Why?
 
MrFunnyWobbl's Avatar
 
Join Date: Jan 2012
Location: Unlocated
Country: Umm al-Qaiwan
Posts: 19,809
vCash: 100
Send a message via AIM to MrFunnyWobbl
thanks alot!

MrFunnyWobbl is online now   Reply With Quote
Old
04-09-2012, 10:16 AM
  #6
y2jf
Registered User
 
Join Date: Apr 2008
Posts: 1
vCash: 500
Thank you !!!

y2jf is offline   Reply With Quote
Old
04-09-2012, 10:21 AM
  #7
Brewin
Registered User
 
Brewin's Avatar
 
Join Date: Nov 2006
Location: Calgary, AB
Country: Canada
Posts: 388
vCash: 500
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?

Brewin is offline   Reply With Quote
Old
04-09-2012, 12:27 PM
  #8
Bobby G
Registered User
 
Bobby G's Avatar
 
Join Date: Jul 2008
Country: Canada
Posts: 8,739
vCash: 500
It's a great idea, I always play around with it every year. Thanks !

Bobby G is offline   Reply With Quote
Old
04-09-2012, 12:52 PM
  #9
jigglysquishy
Registered User
 
jigglysquishy's Avatar
 
Join Date: Jun 2011
Location: Regina, Saskatchewan
Country: Canada
Posts: 3,480
vCash: 500
My playoff pool is picking 5 players total points.

I'm nervous about going Malkin or Giroux. I'm not confident about who wins at all.

jigglysquishy is online now   Reply With Quote
Old
04-09-2012, 03:07 PM
  #10
Canadian91
Registered User
 
Canadian91's Avatar
 
Join Date: May 2009
Location: Ottawa
Country: Canada
Posts: 2,045
vCash: 500
Yesssss! Thank you!

Canadian91 is offline   Reply With Quote
Old
04-09-2012, 03:12 PM
  #11
Yammer
Registered User
 
Join Date: Oct 2002
Location: Republic of East Van
Posts: 2,290
vCash: 500
very nice idea and gift to the community, thanks

Yammer is offline   Reply With Quote
Old
04-09-2012, 03:18 PM
  #12
NaChOs
Registered User
 
NaChOs's Avatar
 
Join Date: Mar 2004
Posts: 589
vCash: 500
can you post it on another link? its not working for me

NaChOs is offline   Reply With Quote
Old
04-09-2012, 03:28 PM
  #13
NaChOs
Registered User
 
NaChOs's Avatar
 
Join Date: Mar 2004
Posts: 589
vCash: 500
fixed

NaChOs is offline   Reply With Quote
Old
04-09-2012, 06:30 PM
  #14
CaptainCamaro
Registered User
 
CaptainCamaro's Avatar
 
Join Date: Apr 2012
Posts: 225
vCash: 500
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


Last edited by CaptainCamaro: 04-09-2012 at 06:52 PM.
CaptainCamaro is offline   Reply With Quote
Old
04-10-2012, 12:01 AM
  #15
Oil Gauge
Registered User
 
Oil Gauge's Avatar
 
Join Date: Apr 2009
Posts: 4,512
vCash: 500
Bump, got scared when I was looking for this and it wasn't on the first page!!!!

Thanks for putting this together. Its a huge help.

Oil Gauge is offline   Reply With Quote
Old
04-10-2012, 12:08 AM
  #16
brtriad
Registered User
 
brtriad's Avatar
 
Join Date: Jan 2009
Location: The Loop
Country: United States
Posts: 13,028
vCash: 500
Send a message via AIM to brtriad
San Jose is on there twice instead of Detroit. Cool concept though.

brtriad is offline   Reply With Quote
Old
04-10-2012, 12:18 AM
  #17
thefeebster
Registered User
 
thefeebster's Avatar
 
Join Date: Mar 2009
Location: Vancouver, BC
Posts: 5,634
vCash: 500
Thank you good sir.

thefeebster is offline   Reply With Quote
Old
04-10-2012, 12:20 AM
  #18
Oil Gauge
Registered User
 
Oil Gauge's Avatar
 
Join Date: Apr 2009
Posts: 4,512
vCash: 500
Quote:
Originally Posted by CaptainCamaro View Post
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
You have to go to the second tab and sort the list.

Oil Gauge is offline   Reply With Quote
Old
04-10-2012, 02:52 AM
  #19
5RingsAndABeer
John MacKinnon Fan
 
5RingsAndABeer's Avatar
 
Join Date: May 2011
Posts: 11,511
vCash: 50
Crap, I wish I had seen this before making my picks in the Oilers forum pool. Thanks a lot for sharing!

5RingsAndABeer is offline   Reply With Quote
Old
04-10-2012, 10:27 AM
  #20
usualsuspect434
Registered User
 
usualsuspect434's Avatar
 
Join Date: May 2010
Location: Saskatoon, SK
Country: Canada
Posts: 91
vCash: 500
Very nice resource!! Thanks for sharing.

usualsuspect434 is offline   Reply With Quote
Old
04-10-2012, 12:37 PM
  #21
MTnetter
Registered User
 
Join Date: Apr 2010
Posts: 1
vCash: 500
2012 NHL Playoff pool Cheat Sheat

Simply the best!! Thank you

MTnetter is offline   Reply With Quote
Old
04-10-2012, 01:17 PM
  #22
kovacro
"Jazz Hands" by Alec
 
kovacro's Avatar
 
Join Date: Nov 2008
Location: Hamilton, ON
Country: Croatia
Posts: 2,321
vCash: 500
Very nice, thanks!

kovacro is offline   Reply With Quote
Old
04-11-2012, 08:55 AM
  #23
tm
Registered User
 
tm's Avatar
 
Join Date: Jul 2002
Location: Toronto
Country: Macedonia
Posts: 345
vCash: 500
Thank you all for your kind comments! Hope it helps you all out, good luck!
Re:
Quote:
Originally Posted by CaptainCamaro View Post
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):
Pts Player
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

Quote:
Originally Posted by brtriad View Post
San Jose is on there twice instead of Detroit.
??? I don't see what you're saying. SJ is there once.

tm is offline   Reply With Quote
Old
04-11-2012, 09:47 AM
  #24
Hurt
Registered User
 
Hurt's Avatar
 
Join Date: Apr 2009
Country: Canada
Posts: 23,484
vCash: 500
Great tool. Thanks!

__________________
Shoot me a PM with your concerns. Also, come visit us in the Science Forum!
Hurt is offline   Reply With Quote
Old
04-11-2012, 12:05 PM
  #25
L12
Registered User
 
Join Date: Aug 2011
Posts: 9
vCash: 500
Link not working?

I can't open the 2012 zip file, when I click on it it just directs me to login into HF even though I'm already logged in. The 2011 link works fine for me.

I won my 2011 pool using the spreadsheet, was hoping to use the 2012 as well. Might have to just wing it this year.

L12 is offline   Reply With Quote
Reply

Forum Jump


Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -5. The time now is 08:33 PM.

monitoring_string = "e4251c93e2ba248d29da988d93bf5144"
Contact Us - HFBoards - Archive - Privacy Statement - Terms of Use - Advertise - Top - AdChoices

vBulletin Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
HFBoards.com is a property of CraveOnline Media, LLC, an Evolve Media, LLC company. 2014 All Rights Reserved.