Roster Management Tool (Excel)

omjo · 12-31-2018, 02:07 PM

I saw in this thread some were asking for Tzar to share his file.

I enjoy playing around with Excel, so I went ahead and made my own last night which has room for more info. You can hide whatever columns you don't need. All it will require is you enter in your own information, so there's that. The ratings cells are programmed to change colour depending on the number entered in and will match the colours that you see on FHM. You change it however you see fit of course. I also included a lineup sheet which some might find useful.

Personally I like having all of this information available on the same screen, and decided to share it with others.

(Can't upload Excel files so I just compressed it)

Edit 1: forgot a second group of goalie stats in the template. Fixed.

omjo · 12-31-2018, 05:40 PM

If anybody downloaded this template, I forgot some goalie ratings so please use the new version. Sorry!

maikgianino · 01-08-2019, 10:23 PM

This is awesome! I was working on something very similar as I read that lines are all removed when the season is over. Thank you very much!

12-31-2018, 05:40 PM	#2
omjo Minors (Triple A) Join Date: Nov 2013 Posts: 288	If anybody downloaded this template, I forgot some goalie ratings so please use the new version. Sorry!

01-08-2019, 10:23 PM	#3
maikgianino Minors (Double A) Join Date: Mar 2018 Posts: 147	This is awesome! I was working on something very similar as I read that lines are all removed when the season is over. Thank you very much!