View Single Post
Old
01-14-2013, 10:06 AM
  #213
Kane One
Global Moderator
🚨🚨🚨🚨🚨🚨🚨🚨
 
Kane One's Avatar
 
Join Date: Feb 2010
Location: Brooklyn, New NY
Country: United States
Posts: 27,717
vCash: 2940
Quote:
Originally Posted by tomcatNYR View Post
I started playin around with Excel a bit and came up with a Rangers schedule + player stats + game logs. Just for my own amusement.

http://www.dropbox.com/s/whdpbq6sp0q...2012.01.31.jpg

It counts the record and points automatically and links to each game:

http://www.dropbox.com/s/l4lhoshn9me...2012.01.33.jpg
In the end it adds the stats from each game to a stats sheet:

http://www.dropbox.com/s/omn309tqkgj...2012.01.41.jpg

It's just purely stats based and very simplified: goals, assists, points, save% and so on.

Anyone wanna cross-check if I messed up something?
I think it would be easier for you to find players quicker if you put them in ABC order by last name or by jersey number. Nice work!

Coincidentally, last night I made a spreadsheet keeping track of the salary cap.

__________________
Kane One is offline