cleowin Posted December 30, 2011 Share Posted December 30, 2011 Magic Number Chart 2011-2012: Welcome back to an exciting year of Playoff countdown! I have changed my direction for this year's Magic Number Thread and it's going to reflect some changes in the way I do this chart. First off, I am now using Microsoft Excel to do the chart as it works easier, and is good with table shuffling, even though I'm not using an actual table.The colour options aren't as extensive as in Word, but I can manage with what I have. Some of the new columns I added this year include: PTSP (Maximum Points Possible), PYOFF (Changed from % to just a Playoff Status), X (As in Points needed to clinch a playoff spot), Y (PTS needed to clinch division), Z (Points needed to clinch Conference), and P (Points needed to clinch Presidents Trophy). As well, I have removed the playoff% as it's a pain to figure out the numbers all the time. The Formula used for the Magic # is as follows: Team A (Ex: CHI)'s Maximum Points Subtract Vancouver's Current Points Divided by two plus 0.5. Till March, I will only be updating the Western Conference Chart, as the numbers are a bit high to show the entire league. I hope you enjoy this year's countdown! I will be doing updates based on phases: Phase 1: (January) Chart Updating with what western teams dropped. Phase 2: (February) Chart Updating with clinching Records for Vancouver. Phase 3: (March/April) Will add League Table. As well, the colour coding for this chart is: Green (Means Obtainable), Red (Means Unattainable). Western Conference Magic Number Chart: Uploaded with ImageShack.us Eastern Conference Magic Number Chart: Uploaded with ImageShack.us Link to comment Share on other sites More sharing options...
Sixteen W's Posted December 30, 2011 Share Posted December 30, 2011 All the way to the top of the standings! Link to comment Share on other sites More sharing options...
Edler's Mind Tricks Posted December 30, 2011 Share Posted December 30, 2011 I love this thread every year! Props to you for putting in all the effort. I think the Canucks are going to reach their magic number a bit later this season to be honest but not by much. Go Canucks! Link to comment Share on other sites More sharing options...
cleowin Posted December 30, 2011 Author Share Posted December 30, 2011 Now here's some suggestions for you: Would you like to see a league wide table.. a Conference Table, a Division Table, or a mixture? Please be advised that the more tables I gotta make, the more time it'll take me to update each day! Link to comment Share on other sites More sharing options...
pwnstar Posted December 30, 2011 Share Posted December 30, 2011 always liked this thread Link to comment Share on other sites More sharing options...
jmd_canauckfan Posted December 30, 2011 Share Posted December 30, 2011 Those numbers are going to be so high on January 1st; it's going to be pretty awesome watching them slowly tick down and hopefully go to zero. Link to comment Share on other sites More sharing options...
Thrill-House Posted December 30, 2011 Share Posted December 30, 2011 I think you should just include the vital stats. like regulation win, points, magic #, games remaining. The past few magic number charts had goals against, differential +/-, etc, which we can find on nhl.com I remember the 06/07 had some nice simple graphics to it. Like team icons instead of (VAN, DET, CAL) Although it's probably way easier to just type it out. The % of making playoffs is pretty pointless as well. If you have it, maybe do it with 10 games left. Link to comment Share on other sites More sharing options...
canucksfan97 Posted December 30, 2011 Share Posted December 30, 2011 I would like it to be the best it can possibly be. I don't mind if I takes you until PM even to upload, as long as it has all the stats, and information. I followed this religiously, and I would like to thank you so much for all your hard work. Link to comment Share on other sites More sharing options...
cleowin Posted December 30, 2011 Author Share Posted December 30, 2011 Team Icons was something I pondered this year, and they are pretty simple to move around. But they are a pain with Microsoft Word.. and It's the easiest program for me to use considering tables and all that are incorporated into Word 2010. I planned on trying to use something similar to NHL.com's standings table.. but I dont know if I'm allowed to do so that way, or if I can find the graphics for it. Link to comment Share on other sites More sharing options...
-Vintage Canuck- Posted December 30, 2011 Share Posted December 30, 2011 Thanks for doing this again! Link to comment Share on other sites More sharing options...
canuckschick1234 Posted December 30, 2011 Share Posted December 30, 2011 Love this thread, thanks! Link to comment Share on other sites More sharing options...
pianoman13 Posted December 30, 2011 Share Posted December 30, 2011 Yes the magic number thread is back! My favorite annual thread! I don't think we need a division table, with a conference table we can see where we fit in the division as well. If you are up to it a league wide one would be awesome too! Link to comment Share on other sites More sharing options...
Nucks fan555555 Posted December 31, 2011 Share Posted December 31, 2011 One of my fav threads. I know it will be good Link to comment Share on other sites More sharing options...
cleowin Posted December 31, 2011 Author Share Posted December 31, 2011 Update: I will have the following rows in my table: TEAM (Possibly with Graphic) GP W L SOL/OTL ROW PTS PTS MAX MAGIC # PYOFF: (Playoff Contention Status (E, X, Y, Z, P) X (Points needed to clinch a playoff spot) Y (Points needed to clinch a division spot) Z (Points needed to clinch a conference spot) P (Points needed to clinch Presidents Trophy) I am still deciding on rather or not I will function with just a league table, or two separate conference tables. Link to comment Share on other sites More sharing options...
cleowin Posted January 1, 2012 Author Share Posted January 1, 2012 New Years Day (January 1st, 2012): This year's 2011-2012 NHL Magic Number Chart has been added. Let the playoff countdown begin! Link to comment Share on other sites More sharing options...
canucksfan97 Posted January 1, 2012 Share Posted January 1, 2012 May I just suggest one thing for the new chart? A games remaining column would be spectacular, thanks. :D Link to comment Share on other sites More sharing options...
cleowin Posted January 2, 2012 Author Share Posted January 2, 2012 January 1st, 2012: Western Conference Magic Number Chart has been updated! CGY has fallen 1 magic point. Link to comment Share on other sites More sharing options...
cleowin Posted January 3, 2012 Author Share Posted January 3, 2012 Monday, January 2nd, 2012: Western Conference Magic Number Chart has been updated! EDM dropped 1.5 Magic Points! COL dropped 1.0 Magic Points! All other teams dropped 0.5 Magic Points! Link to comment Share on other sites More sharing options...
cleowin Posted January 4, 2012 Author Share Posted January 4, 2012 Tuesday, January 3rd, 2012: Western Conference Magic Number Chart has been updated! CGY, EDM, DAL and PHX dropped 1 Magic Point! Link to comment Share on other sites More sharing options...
*vInTaGe* Posted January 4, 2012 Share Posted January 4, 2012 Thanks for all the work you do on these charts. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.