DocHoliday
In the Starting Line-Up
- Joined
- Dec 28, 2010
- Messages
- 3,023
- Reaction score
- 113
After taking a look at the "You be the GM" thread, I decided it'd be far easier if you could do all the legwork in an excel spreadsheet.
So I made one. I'm sure some of you have your own versions, but I decided to make one for everyone else. If you have any additions or upgrades, feel free to add it on and reupload.
I added the current roster, positions, ages, and set up the spreadsheet so it automatically counts the numbers of players per position. There are two tabs - base and projected. Base is the current as of now roster and projected is exactly the same, but it allows you to change the roster around without making any changes you can't easily reverse by duplicating the base tab again.
I also instituted a 'cap hit' feature that allows you to enter in the cap hit for the year. I did it for all currently signed players barring Jake Ballard and Jason Vega, whose numbers I could not find. I copied my cap hit numbers from from spotrac.com
You can copy paste your work fairly easily, but I'm working on making it more readable to the forum. I'm eager to see what you guys come up with.
Screenshot: http://i.imgur.com/Zm6n7H2.png
It's attached as a zip file. Extract and open with Excel or OpenOffice Calc
So I made one. I'm sure some of you have your own versions, but I decided to make one for everyone else. If you have any additions or upgrades, feel free to add it on and reupload.
I added the current roster, positions, ages, and set up the spreadsheet so it automatically counts the numbers of players per position. There are two tabs - base and projected. Base is the current as of now roster and projected is exactly the same, but it allows you to change the roster around without making any changes you can't easily reverse by duplicating the base tab again.
I also instituted a 'cap hit' feature that allows you to enter in the cap hit for the year. I did it for all currently signed players barring Jake Ballard and Jason Vega, whose numbers I could not find. I copied my cap hit numbers from from spotrac.com
You can copy paste your work fairly easily, but I'm working on making it more readable to the forum. I'm eager to see what you guys come up with.
Screenshot: http://i.imgur.com/Zm6n7H2.png
It's attached as a zip file. Extract and open with Excel or OpenOffice Calc