GM Excel Spreadsheet
 

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

Re: GM Excel Spreadsheet
 

I'd prefer to sit here and force a psychic connection where you attempt to guess the moves I make via telepathy Doc. Is that too much to ask for?

Re: GM Excel Spreadsheet
 

Trade Brady and a first round pick for Rex Grossman?

Re: GM Excel Spreadsheet
 

Update: I can't sleep, so I went back and added 'Dead money', 'cap rollover', and filled in all the cap hit numbers except free agents (obviously), Jake Ballard, and Jason Vega, whose numbers I could not find.

Enjoy

Re: GM Excel Spreadsheet
 

Nice Job! Its usefully to see entire roster laid out like that. I'm surprised Gronk only has a 2.7 mil cap hit this year. Is that number going to explode next year? Other surprises - Gostkowski at 3.4 mil - is an extension in order? Best value to the team - Ninko at 2 mil and change.

Re: GM Excel Spreadsheet
 

This is a very nice piece of work and an appreciated contribution.

Re: GM Excel Spreadsheet
 

Seconded! Cheers and thanks for the hard work (and insomnia!) :peace:

Re: GM Excel Spreadsheet
 

We will all be well served by your efforts, Doc. Thanks

In fact if there are any moderators "listening", this should probably be a candidate for becoming a sticky, so more will take advantage of it when we are doing our "speculations" this LOOOOONNNNNNGGGGG off season.

Re: GM Excel Spreadsheet
 

Updated again. This version is much more resilient to modification (equations would mess up when you would cut and paste things).

I also filled in Ballard's cap numbers, but still can't find Vega's.

Enjoy

Re: GM Excel Spreadsheet
 

Another update.

Version 1.3

Changes:

Reworked some of the counting equations to make them even more resilient to cutting and pasting. Should be good now. Also added a spot on the LBs.

Jason Vega's numbers were added, and some other players had their ages and positions fixed. Eg Ninko moved to LB but his role listed as LB/DE.