Big Update! Version 2.0 for 2014.
All values are taken from PatsCap as usual. I've changed around the equations - the cap hits and dead money numbers will autoupdate when Miguel updates them if you allow the macros to run.
I'm also trying to add a new feature where any real life Patriots not on your projected Roster sit in. This would include new Patriots recently signed if, for example, you made your roster and the Patriots signed Larry Fitz the next day. It's very difficult to do so, however, so we'll see. Placeholder is on the side.
As of now, all real life dead money and real life 2014 cap hits will be kept updated automatically. However, if you remove a player you must manually add to the dead money hit. This will make it so the dead money is no longer automatic. If you understand excel, what you can do is to add the dead money of the player you 'cut' to the existing equation to keep it kosher. If not, just delete the equation and keep track manually.
New players you add that the Pats don't actually have require their cap values be added manually of course - the spreadsheet will take your word for the value and add it to the calculations. If a player is signed and the cap hit doesn't automagically show, just insert the equation I provided in the notes and the spreadsheet will look it up for you. It depends on Miguel's page, so all credit goes to him.
Hope it makes sense. Happy GMing!