Hockey "Magic Number"

[dotcanada]

Good day hockey fans.

I created a massive NHL excel file where the standings and playoff picture updates itself after inputting the daily scores. My standings table is in the regular format (GP, W, L, OT, ROW, GF, GA, Diff, Pts, as well as Games Remaining).

I would like to do three things. Calculating the magic number on:
-clinching a playoff spot
-clinching a division
-when a team is out of the playoff run.

Any help is great appreciated.
<!-- / message --><!-- added 12/15/11 -->

​

 

[DRSteele]

Are you still interested in a solution?

 

[dotcanada]

Actually, I was able to figure it out. Thanks though.