cleowin Posted January 5, 2012 Author Share Posted January 5, 2012 Wednesday, January 4th, 2012: Western Conference Magic Number Chart has been updated! Vancouver is now 1st in the League! MIN and ANA drop 2 magic points! All other teams drop 1 magic point! ADMIN, please pin this topic! Link to comment Share on other sites More sharing options...
Bertuzzipunch Posted January 5, 2012 Share Posted January 5, 2012 Link to comment Share on other sites More sharing options...
Tocinetaloco Posted January 5, 2012 Share Posted January 5, 2012 This should be pinned! Link to comment Share on other sites More sharing options...
cleowin Posted January 6, 2012 Author Share Posted January 6, 2012 Thursday, January 5th, 2012: Western Conference Magic Number Chart has been updated! DIV Column has been added! CGY, CHI, EDM, NSH and CBJ drop 1 Magic Point! PHX Drops 0.5 Magic Points! Link to comment Share on other sites More sharing options...
Forsy Posted January 6, 2012 Share Posted January 6, 2012 Great job as always - but posting every update may be a nuisance for you in the long run - I'm sure everyone will check the original post daily anyway Link to comment Share on other sites More sharing options...
cleowin Posted January 6, 2012 Author Share Posted January 6, 2012 Great job as always - but posting every update may be a nuisance for you in the long run - I'm sure everyone will check the original post daily anyway Link to comment Share on other sites More sharing options...
nucks all the way Posted January 7, 2012 Share Posted January 7, 2012 Friday, January 6th, 2012: Chicago's Magic Number is now 41.0 Anaheim's Magic Number is 31.0 Colorado's Magic Number is 37.5 I thought since you're putting your time and effort to do this I might as well help. It'd be nice if once in a while others could do it as well. And again thank you for your hard work. Link to comment Share on other sites More sharing options...
cleowin Posted January 7, 2012 Author Share Posted January 7, 2012 Friday, January 6th, 2012: I apologize for the late post! Western Conference Magic Number Chart has been updated! (Please Pin this topic please!) CHI and ANA drop 1 Point! Link to comment Share on other sites More sharing options...
Saved_by_Jesus Posted January 7, 2012 Share Posted January 7, 2012 I love this thread. One thing that I think is valuable and could be added is "points pace"... I think you had one last year. It's a good way to see how teams compare when there is a significant difference in games played. Link to comment Share on other sites More sharing options...
cleowin Posted January 7, 2012 Author Share Posted January 7, 2012 I love this thread. One thing that I think is valuable and could be added is "points pace"... I think you had one last year. It's a good way to see how teams compare when there is a significant difference in games played. Link to comment Share on other sites More sharing options...
cleowin Posted January 8, 2012 Author Share Posted January 8, 2012 Saturday, January 7th, 2012: SORRY FOR THE LATE POST ONCE AGAIN!! Western Conference Magic Number Chart has been updated! A CHANGE Column has been added which represents the change in Magic Number after the day's updated action! DET, MIN, LAK, COL, and EDM drop 2 Magic Points! All other teams drop 1 Magic Point! Link to comment Share on other sites More sharing options...
kchengc Posted January 8, 2012 Share Posted January 8, 2012 holy crap... already???? soon we will get this thread at the start of the season! Link to comment Share on other sites More sharing options...
silverpig Posted January 8, 2012 Share Posted January 8, 2012 I'm sure there's a way with scripting to have the table auto-generate. Link to comment Share on other sites More sharing options...
Saved_by_Jesus Posted January 8, 2012 Share Posted January 8, 2012 <br />I forgot I had that! But I think it'll be more valuable near the end of the season. I had Playoff % and Points Pace before, and it would take awhile to update.<br /> Link to comment Share on other sites More sharing options...
cleowin Posted January 9, 2012 Author Share Posted January 9, 2012 Sunday, January 8th, 2012: Western Conference Magic Number Chart has been updated! CBJ drops 1.0 Magic Point! CHI drops 0.5 Magic Points! Link to comment Share on other sites More sharing options...
cleowin Posted January 9, 2012 Author Share Posted January 9, 2012 I now have formula's that operate the GR, PTPC (Points Pace), PTPS (Points Possible). This will make updating even easier. Link to comment Share on other sites More sharing options...
Forsy Posted January 9, 2012 Share Posted January 9, 2012 True. I appreciate the hard work, and the following can be a bit complicated if you aren't familiar with the functions of Excel, but if you do feel like trying this you can automatically have the points pace by entering the following equation. 1) Pick the cell (box) which you want to have the points pace in. 2) Click the "fx" (function) button right above the table. 3) Select "sum" 4) Enter: ("the cell with points for that team"/"the cell with games played for that team")*82 It will look something like this (depending on where you table is situated): (I3/D3)*82 If there are too many decimal points, you can "format cells" by right clicking on the cell an selecting "number" and then changing the "decimal places" option to "0". Again, you're doing a great job, I just thought I'd lay that out for you in case you're interested since you seem like a stats-happy guy. Link to comment Share on other sites More sharing options...
cammy Posted January 9, 2012 Share Posted January 9, 2012 if you are doing on excellcan you selectthe removegridlins option and just break the tex with the borders option, it looks so much better then. also can you colour filter by division so rather than having to do a conferance and division table at a quick glace we can pick them out of the one Link to comment Share on other sites More sharing options...
cleowin Posted January 10, 2012 Author Share Posted January 10, 2012 Monday, January 9th, 2012: Western Conference Magic Number Chart has been updated! Link to comment Share on other sites More sharing options...
cleowin Posted January 10, 2012 Author Share Posted January 10, 2012 if you are doing on excellcan you selectthe removegridlins option and just break the tex with the borders option, it looks so much better then. also can you colour filter by division so rather than having to do a conferance and division table at a quick glace we can pick them out of the one Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.