ny92mike Posted June 28, 2023 Author Share Posted June 28, 2023 21 hours ago, sparky151 said: I'm interested in further suggestions for TCMD. Appreciate it. First thing I've got to do is clean up the issues from the last one. I've already started working on fixing the APY values as that was a nightmare last time around especially with IDL and other defensive positions. I'll post that data once I'm finished for you guys to look over and see if anything else can be done to make it better. The other major issue with last years mock were some formulas that made it very difficult to extend a players contract so I'll get that fixed as well. I'd love to be able to work in the "SIM" at the tail end of the mock if possible. My mock always seems to end so abruptly I think it would be nice to add a simulated season to open it up for more discussion. I'm always open to suggestions and to constructive criticism. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted June 29, 2023 Author Share Posted June 29, 2023 So I'm close to having the APY value formulas finished up but I've still got to create the grading system to see how it looks. The new values drop more aggressively than previous. Offense Pos. Grade QB RB FB TE WR LT LG C RG RT 100.0% $51,164,600 $13,949,500 $3,615,300 $15,359,900 $27,542,200 $22,507,600 $16,960,700 $13,526,500 $15,834,500 $19,649,800 96.0% $48,606,400 $13,252,000 $3,434,500 $14,591,900 $26,165,100 $21,382,200 $16,112,700 $12,850,200 $15,042,800 $18,667,300 92.0% $43,867,300 $11,959,900 $3,099,600 $13,169,200 $23,614,000 $19,297,400 $14,541,700 $11,597,300 $13,576,100 $16,847,200 88.0% $37,610,700 $10,254,100 $2,657,500 $11,290,900 $20,246,100 $16,545,100 $12,467,700 $9,943,200 $11,639,800 $14,444,400 84.0% $30,634,200 $8,352,000 $2,164,600 $9,196,500 $16,490,600 $13,476,100 $10,155,000 $8,098,800 $9,480,700 $11,765,100 80.0% $23,704,200 $6,462,600 $1,674,900 $7,116,100 $12,760,100 $10,427,500 $7,857,700 $6,266,700 $7,336,000 $9,103,600 76.0% $17,424,800 $4,750,600 $1,231,200 $5,231,000 $9,379,800 $7,665,200 $5,776,100 $4,606,600 $5,392,600 $6,692,000 72.0% $12,168,400 $3,317,500 $859,800 $3,653,000 $6,550,300 $5,352,900 $4,033,700 $3,217,000 $3,765,900 $4,673,300 68.0% $8,072,800 $2,200,900 $750,000 $2,423,500 $4,345,600 $3,551,200 $2,676,000 $2,134,200 $2,498,400 $3,100,400 64.0% $5,087,900 $1,387,100 $750,000 $1,527,400 $2,738,800 $2,238,100 $1,686,500 $1,345,100 $1,574,600 $1,954,000 60.0% $3,046,300 $830,500 $750,000 $914,500 $1,639,800 $1,340,000 $1,009,800 $805,400 $942,800 $1,169,900 56.0% $1,732,700 $750,000 $750,000 $750,000 $932,700 $762,200 $750,000 $750,000 $750,000 $750,000 52.0% $936,300 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 48.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 44.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 40.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 36.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 32.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 28.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 24.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 20.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted June 29, 2023 Author Share Posted June 29, 2023 Defense & Special Teams Pos. Grade EDGE IDL LB CB S K P LS 100.0% $26,162,600 $24,960,300 $19,311,500 $20,600,000 $17,870,900 $5,562,000 $3,394,600 $1,497,900 96.0% $24,854,500 $23,712,300 $18,345,900 $19,570,000 $16,977,400 $5,283,900 $3,224,900 $1,423,000 92.0% $22,431,200 $21,400,400 $16,557,200 $17,661,900 $15,322,100 $4,768,700 $2,910,500 $1,284,300 88.0% $19,232,000 $18,348,200 $14,195,700 $15,142,900 $13,136,800 $4,088,600 $2,495,400 $1,101,100 84.0% $15,664,600 $14,944,700 $11,562,500 $12,334,000 $10,700,000 $3,330,200 $2,032,500 $896,900 80.0% $12,121,000 $11,563,900 $8,946,800 $9,543,800 $8,279,500 $2,576,800 $1,572,700 $750,000 76.0% $8,910,000 $8,500,500 $6,576,700 $7,015,600 $6,086,200 $1,894,200 $1,156,100 $750,000 72.0% $6,222,200 $5,936,200 $4,592,800 $4,899,300 $4,250,200 $1,322,800 $807,300 $750,000 68.0% $4,127,900 $3,938,200 $3,047,000 $3,250,300 $2,819,700 $877,600 $750,000 $750,000 64.0% $2,601,600 $2,482,000 $1,920,400 $2,048,500 $1,777,100 $750,000 $750,000 $750,000 60.0% $1,557,700 $1,486,100 $1,149,800 $1,226,500 $1,064,000 $750,000 $750,000 $750,000 56.0% $886,000 $845,300 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 52.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 48.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 44.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 40.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 36.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 32.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 28.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 24.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 20.0% $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted June 29, 2023 Author Share Posted June 29, 2023 I'm also searching for a Commish, typically I've always had a mod fill this role but I'm opening it up to non-mods. So if interested please let me know. Commish helps me keep the discussion thread involved as well as works with me in managing the workbooks, mainly the draft board and trade approvals. Quote Link to comment Share on other sites More sharing options...
sparky151 Posted July 3, 2023 Share Posted July 3, 2023 In the early rounds of free agency bidding, signing bonus should be a bigger % of the overall contract value. The signing bonus should probably be in the 25-40% range for the top guys. Quote Link to comment Share on other sites More sharing options...
sparky151 Posted July 3, 2023 Share Posted July 3, 2023 In the early rounds of free agency bidding, signing bonus should be a bigger % of the overall contract value. The signing bonus should probably be in the 25-40% range for the top guys. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 4, 2023 Author Share Posted July 4, 2023 2 hours ago, sparky151 said: In the early rounds of free agency bidding, signing bonus should be a bigger % of the overall contract value. The signing bonus should probably be in the 25-40% range for the top guys. Agreed. What I've done in the past is take the average GTD % by position which do seem a bit on the low end. Position Signing Bonus % QB Quarterback 38.6% RB Running Back 20.5% FB Running Back 22.5% TE Tight End 19.6% WR Wide Receiver 23.8% LT Offensive Lineman 32.9% LG Offensive Lineman 21.9% C Offensive Lineman 22.8% RG Offensive Lineman 26.9% RT Offensive Lineman 26.8% EDGE Defensive End 31.9% IDL Defensive Tackle 23.0% LB Linebacker 20.6% CB Cornerback 21.2% S Safety 23.9% K Kicker 25.4% P Punter 19.4% LS Offensive Lineman 14.0% I'll see if I can't get a better % value for SB. If the values below seem too high let me know, I can rework it. I got this data from OTC contract listing. We could also adjust these values based on the APY values, higher the APY value the greater the SB %. Position Current New QB 38.6% 73.6% RB 20.5% 51.0% FB 22.5% 49.0% TE 19.6% 52.5% WR 23.8% 62.7% LT 32.9% 62.3% LG 21.9% 57.8% C 22.8% 45.9% RG 26.9% 59.6% RT 26.8% 66.9% EDGE 31.9% 69.2% IDL 23.0% 63.5% LB 20.6% 59.0% CB 21.2% 56.1% S 23.9% 56.6% K 25.4% 47.8% P 19.4% 45.9% LS 14.0% 39.7% Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 4, 2023 Author Share Posted July 4, 2023 If the SB % value is based on the player grade it would look like this. Pos. Grade QB RB FB TE WR LT LG C RG RT 100.0% 73.6% 59.0% 47.8% 69.2% 49.0% 62.7% 45.9% 56.1% 63.5% 59.6% 95.0% 68.4% 54.9% 44.4% 64.4% 45.6% 58.3% 42.7% 52.2% 59.0% 55.4% 90.0% 63.3% 50.8% 41.1% 59.5% 42.1% 53.9% 39.5% 48.3% 54.6% 51.2% 85.0% 58.1% 46.6% 37.7% 54.7% 38.7% 49.5% 36.3% 44.3% 50.1% 47.1% 80.0% 53.0% 42.5% 34.4% 49.8% 35.3% 45.1% 33.0% 40.4% 45.7% 42.9% 75.0% 47.8% 38.4% 31.1% 45.0% 31.8% 40.7% 29.8% 36.5% 41.2% 38.7% 70.0% 42.7% 34.2% 27.7% 40.2% 28.4% 36.4% 26.6% 32.6% 36.8% 34.5% 65.0% 37.5% 30.1% 24.4% 35.3% 25.0% 32.0% 23.4% 28.6% 32.4% 30.4% 60.0% 32.4% 26.0% 21.0% 30.5% 21.6% 27.6% 20.2% 24.7% 27.9% 26.2% 55.0% 27.2% 21.8% 17.7% 25.6% 18.1% 23.2% 17.0% 20.8% 23.5% 22.0% 50.0% 22.1% 17.7% 14.3% 20.8% 14.7% 18.8% 13.8% 16.8% 19.0% 17.9% 45.0% 16.9% 13.6% 11.0% 15.9% 11.3% 14.4% 10.6% 12.9% 14.6% 13.7% 40.0% 11.8% 9.4% 7.6% 11.1% 7.8% 10.0% 7.3% 9.0% 10.2% 9.5% 35.0% 6.6% 5.3% 4.3% 6.2% 4.4% 5.6% 4.1% 5.1% 5.7% 5.4% 30.0% 1.5% 1.2% 1.0% 1.4% 1.0% 1.3% 0.9% 1.1% 1.3% 1.2% 25.0% 0.7% 0.6% 0.5% 0.7% 0.5% 0.6% 0.5% 0.6% 0.6% 0.6% 20.0% 0.7% 0.6% 0.5% 0.7% 0.5% 0.6% 0.5% 0.6% 0.6% 0.6% 15.0% 0.7% 0.6% 0.5% 0.7% 0.5% 0.6% 0.5% 0.6% 0.6% 0.6% 10.0% 0.7% 0.6% 0.5% 0.7% 0.5% 0.6% 0.5% 0.6% 0.6% 0.6% 5.0% 0.7% 0.6% 0.5% 0.7% 0.5% 0.6% 0.5% 0.6% 0.6% 0.6% 0.0% 0.7% 0.6% 0.5% 0.7% 0.5% 0.6% 0.5% 0.6% 0.6% 0.6% EDGE IDL LB CB S K P LS 52.5% 51.0% 57.8% 62.3% 66.9% 56.6% 45.9% 39.7% 48.9% 47.4% 53.8% 57.9% 62.2% 52.6% 42.6% 36.9% 45.2% 43.8% 49.7% 53.6% 57.5% 48.7% 39.4% 34.1% 41.5% 40.3% 45.7% 49.2% 52.8% 44.7% 36.2% 31.4% 37.8% 36.7% 41.6% 44.9% 48.1% 40.8% 33.0% 28.6% 34.2% 33.1% 37.6% 40.5% 43.5% 36.8% 29.8% 25.8% 30.5% 29.6% 33.5% 36.1% 38.8% 32.8% 26.6% 23.0% 26.8% 26.0% 29.5% 31.8% 34.1% 28.9% 23.4% 20.2% 23.1% 22.4% 25.4% 27.4% 29.4% 24.9% 20.2% 17.5% 19.4% 18.9% 21.4% 23.1% 24.7% 20.9% 17.0% 14.7% 15.8% 15.3% 17.3% 18.7% 20.1% 17.0% 13.8% 11.9% 12.1% 11.7% 13.3% 14.3% 15.4% 13.0% 10.5% 9.1% 8.4% 8.2% 9.2% 10.0% 10.7% 9.1% 7.3% 6.4% 4.7% 4.6% 5.2% 5.6% 6.0% 5.1% 4.1% 3.6% 1.1% 1.0% 1.2% 1.2% 1.3% 1.1% 0.9% 0.8% 0.5% 0.5% 0.6% 0.6% 0.7% 0.6% 0.5% 0.4% 0.5% 0.5% 0.6% 0.6% 0.7% 0.6% 0.5% 0.4% 0.5% 0.5% 0.6% 0.6% 0.7% 0.6% 0.5% 0.4% 0.5% 0.5% 0.6% 0.6% 0.7% 0.6% 0.5% 0.4% 0.5% 0.5% 0.6% 0.6% 0.7% 0.6% 0.5% 0.4% 0.5% 0.5% 0.6% 0.6% 0.7% 0.6% 0.5% 0.4% Quote Link to comment Share on other sites More sharing options...
sparky151 Posted July 5, 2023 Share Posted July 5, 2023 What QB's get 73% of their total contract value as SB? Are you combining signing bonus and guaranteed money? In the NFL, it's uncommon for players to have guaranteed money past year 2 at signing. They usually get rolling guarantees with an early exercise date so they will be back on the market if the team chooses not to keep them. In TCMD, our GMs are a lot more willing than real life GMs to guarantee salary in years 3 and beyond. DeShaun Watson and Kirk Cousins got guaranteed year 3 salaries at signing but they are the outliers. My suggestion is that free agents, at least in the first couple of rounds, ask for more signing bonus since that is money in hand. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 5, 2023 Author Share Posted July 5, 2023 3 hours ago, sparky151 said: What QB's get 73% of their total contract value as SB? Are you combining signing bonus and guaranteed money? In the NFL, it's uncommon for players to have guaranteed money past year 2 at signing. They usually get rolling guarantees with an early exercise date so they will be back on the market if the team chooses not to keep them. Those values are calculated averages using real contracts. You know I don't like using personal data, that said I can figure out a different formula to get the numbers. Good eye, totally overllooked this, but yes, these percentages are based on guaranteed money using this site link, https://overthecap.com/contracts , but now that you pointed it out it probably is accounting for all guarantees as well so I'll rework these numbers to account for SB only, that should produce values more in line which what you are thinking. 3 hours ago, sparky151 said: In TCMD, our GMs are a lot more willing than real life GMs to guarantee salary in years 3 and beyond. DeShaun Watson and Kirk Cousins got guaranteed year 3 salaries at signing but they are the outliers. My suggestion is that free agents, at least in the first couple of rounds, ask for more signing bonus since that is money in hand. Let me rework these numbers and get you SB values. As for the guarantee money outside of SB I'm not worried about since the only two values we are using to create a contract is base salary and SB. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 5, 2023 Author Share Posted July 5, 2023 4 hours ago, sparky151 said: My suggestion is that free agents, at least in the first couple of rounds, ask for more signing bonus since that is money in hand. Agreed, it's currently set up to drop after each round of bidding just like APY values. Quote Link to comment Share on other sites More sharing options...
RedGold Posted July 9, 2023 Share Posted July 9, 2023 I don’t really have the energy/time to talk improvements. But you should know I’m always there to help with maintaining the books when it starts up. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted July 11, 2023 Author Share Posted July 11, 2023 On 7/9/2023 at 11:19 AM, RedGold said: I don’t really have the energy/time to talk improvements. But you should know I’m always there to help with maintaining the books when it starts up. Much appreciated. I could definitely use some help with updating the data for trades, extensions and restructures. These type of transactions take the most time to update and have yet to find a faster easier way to do it. Quote Link to comment Share on other sites More sharing options...
JetsandI Posted August 16, 2023 Share Posted August 16, 2023 Ah man! I hope you guys make some productive progression for TCMD. I have been in an unhealthy hostile situation and I think there is very good chance that I will become senile some point in near future. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted December 9, 2023 Author Share Posted December 9, 2023 Haven't been on much this season, but just wanted to let everyone know that I'm still planning on running my mock draft, tcmd again this year. Looking for help if anyone is willing. Let me know by sending me a message. Thanks 4 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.