FanPost

2013-14 Team Comparison Spreadsheet

For those who may remember, during the 2010-11 and 2011-12 season I had developed a team comparison spread sheet. It allows you to quickly see the big team stats, compare them to another team and also see the head-head results of those two teams.

I have brought it back and have added to it and groomed other aspects of it.

Download it here

https://skydrive.live.com/redir?resid=649D663783FB9377%214035

Here is an explanation of its various parts.

This is how it looks upon opening it in Excel 2013.

11272694116_e99094d212_medium

How to choose the teams you want

11272653295_fdc61ce95e_medium

Each team has a section to display W-L, and GF-GA data. This image is using only one of the teams

11272718104_0f0cde93f6_medium

This area is team Head-Head play. It shows Home-Away-Total records. (*Note, OTL does NOT include both OTL and SOL it is strictly Over Time Losses.)11272717374_c800b49773_medium

This is the actual team comparison area. Here you can quickly compare the two teams in many statistical team areas, and see where their rank is compared to the rest of the NHL. I am working on adding an NHL AVG column as well, but that mat take time to incorporate since space is limited and the amount of calculations is already extensive.

11272652655_35cfac785d_medium

Here is an explanation to what the stats mean to those who may be unfamiliar.11272693006_3628f7f7b5_medium


You can also download the Power Point explanation here if you desire.

https://skydrive.live.com/redir?resid=649D663783FB9377%214041

If you have any questions, problems or suggestions to improve this, please leave a comment or just tell me it sucks works too!

Download spreadsheet here

https://skydrive.live.com/redir?resid=649D663783FB9377%214035

X
Log In Sign Up

forgot?
Log In Sign Up

Forgot password?

We'll email you a reset link.

If you signed up using a 3rd party account like Facebook or Twitter, please login with it instead.

Forgot password?

Try another email?

Almost done,

Join Second City Hockey

You must be a member of Second City Hockey to participate.

We have our own Community Guidelines at Second City Hockey. You should read them.

Join Second City Hockey

You must be a member of Second City Hockey to participate.

We have our own Community Guidelines at Second City Hockey. You should read them.

Spinner

Authenticating

Great!

Choose an available username to complete sign up.

In order to provide our users with a better overall experience, we ask for more information from Facebook when using it to login so that we can learn more about our audience and provide you with the best possible experience. We do not store specific user data and the sharing of it is not required to login with Facebook.

tracking_pixel_9355_tracker