ny92mike Posted January 17, 2020 Author Share Posted January 17, 2020 If any of you are interested, @Deadpulse I'm tagging you because you seem to have had some interest in pending contracts being calculated automatically into the top 51. https://docs.google.com/spreadsheets/d/1w5o5yz1VP4w0zS7W428Redied02khSIVhu_a0etghy4/edit?usp=sharing This one is for the Giants, but it's set up so that anyone with the link can edit, so feel free to play around with it. Adding in the Trade Value Calc was more extensive than I thought so I'm going to have to create new copies of the private team rosters. Hoping this will be the last major update, but anything that you guys would like added to these workbooks let me know after I make copies for all 32 it'll be too late. How the trade value calc. sheet works. Cells colored light yellow are designed to edit. Cell S2 you can edit to change the team you are looking to trade with. It will take a minute to update the new team information once you do this so be patient. Use checkboxes to include draft picks in column D (your team) and Z (trading partner team). Use drop down cells in column E27:E32 and same range in column AA to select players to include in the trade. Selecting player names will populate their contract information. Doing all of this will calculate the cap automatically for your team, this will not work for your opponents team. Opponent cap info is fixed. Also worth noting is that the draft pick changes will not adjust the available cap but it will give you the estimated rookie pool change. Wish it was better but for a couple hours of work it ain't bad. 1 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 17, 2020 Author Share Posted January 17, 2020 @Deadpulse Any chance of getting a new TCMD sig? Same image but 2020 for the year? Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 17, 2020 Author Share Posted January 17, 2020 4 minutes ago, ny92mike said: @Deadpulse Any chance of getting a new TCMD sig? Same image but 2020 for the year? Please With sugar on top. Quote Link to comment Share on other sites More sharing options...
Deadpulse Posted January 17, 2020 Share Posted January 17, 2020 8 minutes ago, ny92mike said: @Deadpulse Any chance of getting a new TCMD sig? Same image but 2020 for the year? I still have the PS file, changing the text is no problem. Any other alterations? Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 17, 2020 Author Share Posted January 17, 2020 1 minute ago, Deadpulse said: I still have the PS file, changing the text is no problem. Any other alterations? I don't know anything about how much time or trouble it is to do this stuff so if I'm talking crazy tell me. Was thinking it might be cool to open it up to others to get one but here is what I'm thinking if we could include "member since 'XX" Quote Link to comment Share on other sites More sharing options...
Deadpulse Posted January 17, 2020 Share Posted January 17, 2020 1 Quote Link to comment Share on other sites More sharing options...
VigilantZombie Posted January 17, 2020 Share Posted January 17, 2020 Just now, Deadpulse said: That looks amazing! 1 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 17, 2020 Author Share Posted January 17, 2020 (edited) 1 minute ago, Deadpulse said: Love it...lol. But how about blood red rather than pink...haha Edited January 17, 2020 by ny92mike Quote Link to comment Share on other sites More sharing options...
BowserBroncos Posted January 17, 2020 Share Posted January 17, 2020 1 minute ago, ny92mike said: But how about blood red rather than pink I like the pink. Looks amazing Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 17, 2020 Author Share Posted January 17, 2020 Baby blue would be cool as it kinda ties into the color blue cells for editing in the sheets. Quote Link to comment Share on other sites More sharing options...
Deadpulse Posted January 17, 2020 Share Posted January 17, 2020 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 17, 2020 Author Share Posted January 17, 2020 Just now, ny92mike said: Baby blue would be cool as it kinda ties into the color blue cells for editing in the sheets. @Deadpulse can we see that? Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 17, 2020 Author Share Posted January 17, 2020 Just now, Deadpulse said: I like that. Not to much to ask to check out baby blue and we can pick the best one....im excited. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted January 17, 2020 Author Share Posted January 17, 2020 5 minutes ago, BowserBroncos said: I like the pink. Looks amazing It does look pretty cool. 1 Quote Link to comment Share on other sites More sharing options...
Deadpulse Posted January 17, 2020 Share Posted January 17, 2020 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.