New Eastern Conference Playoff Tracker

by RickyRage on Mar 1, 2010 10:29 PM EST

Hey folks, I've updated the Eastern Conference Playoff tracker. I've made a couple of updates which are listed after the jump. The link to download the file is here:

Link from Sendspace

If you find any errors, let me know.

So here are the features:

Head to head comparison

Making predictions (or entering actual results) updates the head to head comparison

Fixed a couple of bugs in regards to the magic number tracking

The magic numbers still don't take tiebreakers into account, but oh well.

If this FanPost is written by someone other than one of the blog's editors, the opinions expressed in it do not necessarily reflect those of this blog or SB Nation.

Tweet Comment 19 comments | 9 recs |

Do you like this story?

Comments

Holy. Crap. You RULE.

by sixsevenfiftysix on Mar 1, 2010 11:03 PM EST reply actions

Hey, btw, where specifically do I find the Western Conference version on that site? I’m probably missing something obvious

by sixsevenfiftysix on Mar 1, 2010 11:07 PM EST up reply actions

The guy who made the original (it was a REALLY bare bones version of the above) made it two years ago. I’m not sure there’s a new version of the Western Conference one.

It won’t take me THAT much effort to make it… do you really want one?

by RickyRage on Mar 1, 2010 11:31 PM EST up reply actions

Ah, ok. I wouldn’t want you to do it just for me—I’d feel bad if I were the only one who actually used it, haha. I figured that if it already existed I might as well keep that one around as well, but if no one else here wants it don’t worry about it.

Back on topic, this is definitely one of the best pieces of user-created content on the site, up there with the Japers’ Rink Glossary. Well done, sir.

by sixsevenfiftysix on Mar 2, 2010 12:06 AM EST up reply actions

I’m a sucker for an Excel challenge. I put it together, though there may be errors, I really didn’t check this one closely at all.

Here ya go

by RickyRage on Mar 2, 2010 12:10 AM EST up reply actions 1 recs

Ha. You ROCK. I won’t even be upset if I tell all my friends that the Sharks’ magic number is 22 and it’s really 23 ;)

Btw: am I correct in assuming that this doesn’t need macros to function properly? Office for Mac doesn’t support macros so I’ve never really understood what they are in this context, but everything looks to be working fine (i.e. I can put in results on the left and everything updates properly and what not)

by sixsevenfiftysix on Mar 2, 2010 12:34 AM EST up reply actions

Correct, there are no macros within. Everything updates automatically given you haven’t disabled automatic calculations.

by RickyRage on Mar 2, 2010 5:41 AM EST via mobile up reply actions

Just curious – I consider myself pretty good with Excel, but this is beyond my skill. How are you doing the calculations, and how do you get the rows to switch based on standings changes?

No Alex, no ratings. Know Alex, know ratings.

by gotsparkly on Mar 2, 2010 7:50 AM EST up reply actions

Sheer awesomeness.

Everyone wants to kill the king. But the prince, he just sails along telling all the ladies, "One day I'm gonna be king."

I'm on that bird thingy.

by Steck It Out on Mar 2, 2010 12:23 AM EST reply actions

Well done Rage.

DC Landing Strip - Waxed and Ready to Go

by Alex Reed on Mar 2, 2010 1:41 AM EST reply actions

Great stuff. I wish work Excel spreadsheets were this awesome.

"You ever use smelling salts, every time you type a bad blog?" Brooks Laich

by Carl Putnam on Mar 2, 2010 7:42 AM EST reply actions

Nice, thank you!

No Alex, no ratings. Know Alex, know ratings.

by gotsparkly on Mar 2, 2010 7:49 AM EST reply actions

Dude, you are the MAN!!! i have been counting in my head and fingers for the past 3 weeks…That thing is awesome!!! Love it!! ask me how i really feel??

by lifetime caps fan on Mar 2, 2010 10:33 AM EST reply actions

I look forward to the day this comes out every year b/c it signals that playoffs are just around the corner.

by J.B on Mar 2, 2010 5:03 PM EST reply actions

Wow.

I’d love to get ahold of this, but I can’t download it at work; the site’s blocked. pout

I need a snappy signature...

by IRockTheRed on Mar 3, 2010 10:31 AM EST reply actions

One thing that would be cool to see is some sort of indicator for how close teams are from being eliminated from playoff contention.

by sixsevenfiftysix on Mar 4, 2010 5:21 PM EST reply actions

Once teams are eliminated their names get crossed out. But its easy enough to add tragic numbers in another table.

by RickyRage on Mar 5, 2010 6:18 AM EST via mobile up reply actions

Ah, nice. I should’ve figured you would have that in there already :)

by sixsevenfiftysix on Mar 5, 2010 4:50 PM EST up reply actions

Wow, this is awesome! However, I am not sure what all the abbreviations mean…could someone give me a rundown if it isn’t too much trouble. I have been a major fan since I was born (thanks to my parents), but I haven’t really gotten into stats until recently. I know this is like the 4th obvious (or should be) question I have asked since I joined like a week ago.

by RockinRed4Life on Mar 7, 2010 5:35 AM EST reply actions

Comments For This Post Are Closed

FanShots

Quick hits of video, photos, quotes, chats, links and lists that you find around the web.

Southeast Standings

	GP	W	L	OTL	PT
Florida Litter Box Cats	55	27	17	11	65
Washington Japers' Rink	55	28	22	5	61
Winnipeg Arctic Ice Hockey	57	26	25	6	58
Tampa Bay Raw Charge	55	24	25	6	54
Carolina Canes Country	56	20	25	11	51