GM Excel Spreadsheet

Discussion in ' - Patriots Fan Forum' started by DocHoliday, Feb 26, 2013.

Thread Status:
Not open for further replies.
  1. DocHoliday

    DocHoliday In the Starting Line-Up

    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

    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.


    It's attached as a zip file. Extract and open with Excel or OpenOffice Calc

    Attached Files:

  2. ausbacker

    ausbacker Brady > Manning. Supporter

    #87 Jersey

    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?
  3. DocHoliday

    DocHoliday In the Starting Line-Up

    Trade Brady and a first round pick for Rex Grossman?
  4. DocHoliday

    DocHoliday In the Starting Line-Up

    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.

  5. kurtinelson

    kurtinelson In the Starting Line-Up

    #37 Jersey

    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.
  6. betterthanthealternative

    betterthanthealternative In the Starting Line-Up

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

    ForThoseAboutToRock Third String But Playing on Special Teams

    #50 Jersey

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

    patfanken Experienced Starter w/First Big Contract

    #91 Jersey

    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.
  9. DocHoliday

    DocHoliday In the Starting Line-Up

    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.


    Attached Files:

  10. DocHoliday

    DocHoliday In the Starting Line-Up

    Another update.

    Version 1.3


    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.

    Attached Files:

  11. Aßßynormal

    Aßßynormal Supporter Supporter

    Thanks for the schedule.

    Minor note: I think we still have rights to Pryor.
  12. DocHoliday

    DocHoliday In the Starting Line-Up

    That we do - his contract was tolled I believe because he was ineligible for the season. He should be in there, I listed him as DT right after Forston.

    Thanks for downloading!
  13. murphysbuddylove

    murphysbuddylove On the Roster

    Awesome work. I've made a copy and can play now.
  14. DocHoliday

    DocHoliday In the Starting Line-Up

    Update time!

    Version 1.32

    Minor update. Reflects the release of Kyle Hix and Spencer Larson, and takes into account their dead money hits.

    If you want to update your own version rather than start all over, just replace the dead money number with $4,637,525.00

    Attached Files:

  15. Miguel

    Miguel Patriots Salary Cap Guru Supporter

    #75 Jersey

  16. DocHoliday

    DocHoliday In the Starting Line-Up

    Thank you for the estimates, I just winged them for my draft picks.

    The existing numbers were taken from Sportrac. For the missing (Quarles and Miller) would you just multiply 6000 * 52 weeks for the year?
  17. Miguel

    Miguel Patriots Salary Cap Guru Supporter

    #75 Jersey

    6000 X 17 weeks of the regular season. I would not use any players' current salary for their Practice Squad Salary as most PS players are signed for the minimum. You may want to add a fudge factor for a couple of them as most teams pay a couple of their PS players more than minimum.
    Last edited: Mar 2, 2013
  18. DocHoliday

    DocHoliday In the Starting Line-Up

    They're not paid in preseason? Or do those numbers not count for cap?
  19. mgteich

    mgteich Veteran Supporter

    I don't sweat the late costs. There are many more the the Practice Squad. There are the two players not included in the cap. There the rookies. There is an in-season injury fund. There is paying for players put on IR during camp, and the cost of their replacements. I may have forgotten one or two.

    If you must include these costs, I would suggest including the savings from a Mankins restructure. This saves $3.75M and is a no-brainer at any time. This would approximately pay for the above costs. For example, the net draft costs are negligible except for the net cost of our first pick.

    We have $24M - $25M available now, if we choose. Of course, we should make sure that we include the JAG's needed to fill out the roster (I usually allocate $2M - $3M for that. This year, this might include a corner (Cole equivalent or two), backup WR's, backup LB, and a backup DE.

    To me, this exercise is straightforward. We need to re-sign or replace


    We will go into the draft with no "holes" as such. Of course, posters have already decided what positions will be drafted. I'm sure Belichick (or his staff) laughs at such nonsense.

    If we (on balance) replace with equal players, our team will be a bit stronger next year due to the expectation of net improvement among the youngsters. I do NOT predict no or few injuries. I think it to be unreasonable to do so. I expect about the same as last year or a bit more.
  20. DocHoliday

    DocHoliday In the Starting Line-Up

    Care to share a rough number for the sum of the costs you wrote in your first paragraph? I'll just lump them into one Miscellaneous box.
Thread Status:
Not open for further replies.

Share This Page