View Single Post
Old
02-08-2013, 12:35 AM
  #12
awfulwaffle
Registered User
 
awfulwaffle's Avatar
 
Join Date: Jun 2011
Location: Phoenix, Arizona
Country: United States
Posts: 6,240
vCash: 500
Quote:
Originally Posted by The Head Crusher View Post
I always used this formula:

G+1-AW-.5AOTL-BL-.5BOTL

G=Total games in a season
A= Team A (The team you are making the magic number for)
B= Team B (The team you want to eliminate)

For example, lets say Edmonton is competing with Colorado for the 8th and final playoff spot in a full 82 game season, and the team records are as follows

EDM - 37-34-7
COL - 35-33-10

To find the Magic number of wins Edmonton would need to make the playoffs we would use the formula as follows:

G+1-AW-.5AOTL-BL-.5BOTL
(82)+1-(37)-.5(7)-(33)-.5(10)= 4.5 Games or 9pts

If Edmonton can record 9 points or Colorado loses 9 points in the remaining 4 games that each team has then they eliminate Colorado and lock up the 8th spot.
This is an interesting formula. When I put this into Excel, before tonights results, it said the Coyotes magic number was 39, basing it off the Stars which held the 8th spot in the west before entering tonight's games. Do you come out to something around that using your formula after tonight's results? I'm a bit intoxicated, but want to get this to work!

awfulwaffle is offline   Reply With Quote