stufflife's Stats Spreadsheet

by stufflife on Dec 6, 2009 9:42 PM PST

I've been working on this since game one, waiting for the right time to unveil. It all started when I tried to help mymclife create a new metric for power play effectiveness, but was unable to find the stats I wanted. I realized I was probably going to have to keep my own statistics for the players and their games.

Yeah, I'm a math geek.

This started as one page and eventually grew to five. It might see more iterations as time progresses, as I'm interested in what you think would be interesting to know. Here's my short list of things that could be added, in time...

1. Scoring first vs. Game outcome

2. Team plus/minus

3. Scoring streaks and other trends

As you'll no doubt notice, I've spent an enormous amount of time working on this. To appreciate it all, you'd have to see the Excel file from which this was created (with most column headers as vertical, not horizontal), but Google Docs won't let me upload that.

It's massive. It's bigger than a burrito that's bigger than your head. It floats, but it's not a witch. Without further ado...

stufflife's Sharks 31

stufflife's Sharks 35

(opens in a new window as a Google Doc)

This item was created by a member of this blog's community and is not necessarily endorsed by Fear The Fin.

Tweet Comment 11 comments | 3 recs |

Do you like this story?

Comments

Holy ballz, dude.

Fear the Fin: Sharing Joe Thornton's love of wooly mammoths since 2009.

by Matthew_Taylor on Dec 6, 2009 9:58 PM PST reply actions

Wow awesome stuff.

Very cool.

-The dude responsible for this mess

by idunno723 on Dec 6, 2009 10:17 PM PST reply actions

I forgot to mention that I found a couple of weird things. Maybe someone with more hockey knowledge than me can figure this out.

On 11/20/2009, Derek Joslin got a second assist on an even strength goal, but not a plus, because he was apparently not on the ice against the Flyers at the exact time of the goal. This also happened to Ryane Clowe, but I can’t remember which game it was, off the top of my head.

I also learned that Dany Heatley’s penalty shot goal counted as an even strength goal, so he got a plus, though no one else did, because they weren’t on the ice. In my opinion, it should still be credited as a plus for those Sharks on the ice at the time of the incident and minus for the Blue Jackets.

/end rant

Jon Casey fan since '84

by stufflife on Dec 6, 2009 10:38 PM PST reply actions

There it is— I was waiting for you to drop this after you sent it to me in an email awhile back.

Great stuff.

Fear The Fin: Where Selling Your Soul Is The Likely Solution

by Mr. Plank on Dec 7, 2009 12:52 AM PST reply actions

E.....

GAD.

Fear the Fin: "I'm gonna fuckin' kill you, lake!" - ZeroIndulgence, 11/15/09 in Chicago

by Conico do Mayo Miracle on Dec 8, 2009 10:49 PM PST reply actions

Woah, now how did I miss this?

This is amazing. It’s like, a stat geek’s wet dream or something. Also, I think my mind just exploded.

"I think I realized after the second or third punch, I should have taken his helmet off sooner." - Ryane Clowe
Proud member of the "Re-Sign Marleau" Club
Fools and Sages

by mymclife on Dec 8, 2009 11:01 PM PST reply actions

My wife can attest that I spent a LOT of time doing this. I didn’t mean to make anyone’s head explode – I just wanted to give back.

Wet dreams? Really? We’re not all pre-pubescent boys, you know.

Actually, if you have time, can you look through and make sure the number of times shorthanded is correct? Here’s my dilemma…
If the Sharks get overlapping penalties so they go from 4 on 5 to 3 on 5 to 4 on 5, I only counted that as one time being shorthanded. It was only one period of shorthandedness, after all. Having the wrong numbers here may affect the stats for goals and shots / short handed time.

Jon Casey fan since '84

by stufflife on Dec 9, 2009 12:07 PM PST up reply actions

hahaha

MeThinksSports where the only semi-good thing is the poll...

by serrapadre716 on Dec 9, 2009 3:33 PM PST up reply actions

holy shit

MeThinksSports where the only semi-good thing is the poll...

by serrapadre716 on Dec 9, 2009 8:25 AM PST reply actions

Newly updated, through the first 35. I would really like to have more comments than days old, even if I am responsible for the majority of the comments.

I tried to create a couple of interesting stats. In skater stats, Goals For when on the ice per 60 minutes, in even strength, man advantage, and shorthanded. In team stats, you can find shots and goals per power play opportunity and shots and goals per power play minute, which I thought was the more interesting statistic for determining efficacy.

Jon Casey fan since '84

by stufflife on Dec 20, 2009 9:13 PM PST reply actions

you’re the man. thank you for bestowing upon us your godly awesomeness.

Petey and Fresh always dunking on Spartans,
Biscuits in baskets from Heatley and Thornton,
Bam-Bam and Gore on the way to some rings,
These are a few of my favorite things.

by beat_la_25 on Dec 21, 2009 4:16 PM PST reply actions