Jump to content

ny92mike

Veteran Members
  • Content Count

    14,081
  • Joined

  • Last visited

Community Reputation

2,115 All-Pro

Favorites

  • NFL Team
    New York Giants
  • NBA Team
    Thunder
  • College Team
    Oklahoma State

Recent Profile Visitors

2,480 profile views
  1. For those interested in the progress of this project. Here is the roster template that we'll be using if and when this kicks off. Several of these sheets will be hidden once finalized, and the design along with additional information will be added once other projects for this sim is completed. https://docs.google.com/spreadsheets/d/1XneuIAQ1s5YLUayk13db0xTNN2Accs_ZAT4HbR4jr4I/edit?usp=sharing Each owner will be given their own personal workbook similar to this template. You'll use this workbook to set your depth chart, view your roster, track your salary cap, among other things. The team depth chart sheet is still a work in progress, but the general idea is that you'll select your offensive and defensive primary and secondary schemes, adjust your depth chart and once we get it worked out, pre-game plan adjustments. The current design is set up so that you can't duplicate a player within the depth chart, this makes it easier when using the drop down list to create the chart. Once a players name is added to the chart, their name will not show up in the drop down list. I used the Giants for this template and anyone that opens the link above has editing rights to test it out. I don't have the game planning sliders created in this wb yet, but I've got a version of this worked out in a different workbook for testing purposes but the concept is you can alter the number of pass/rush attempts. This in conjunction with offensive / defensive specific adjustments like whether or not you want to game plan against the pass over rush to boost stats for your players will change the outcome of the game, ultimately changing it from a pure statistic based system. I've got someone helping me out with this project. We'll do our best with it but after the first year is complete we'll have a better idea of what updates we'll need to make to the system. I've also worked out the free agency workbook that will be used in season. Very similar to what several of you already know in the shark tank. https://docs.google.com/spreadsheets/d/1nmzdfN41nPAhRYH-VbkTgjnvG7qfSG2vJM5uZ8z3OB8/edit?usp=sharing Feel free to test it out. There is a link to the form at the top left of the sheet.
  2. Well it's looking like there isn't any interest in this but I'll keep working on it and continue to post updates. See where it stands next season, appreciate those that pushed this and those that are assisting me with the build.
  3. THE BUILD Moving the build updates to this thread. Contracts To simplify current and future contract structures for tracking purposes, I've averaged the players irl contract's base salary, prorated bonus, roster bonus and workout bonus by the number of contract years containing a base salary. For example: Patrick Mahomes massive 12 year contract according to OTC. Year Age Base Salary Prorated Bonus Roster Bonus Workout Bonus Guaranteed Salary Cap Number Cap % 2020 25 $825,000 $4,521,538 $0 $0 $825,000 $5,346,538 2.40% 2021 📝 26 $990,000 $2,000,000 $21,716,905 $100,000 $22,806,905 $24,806,905 13.60% 2022 📝 27 $1,500,000 $2,000,000 $27,400,000 $550,000 $29,450,000 $31,450,000 13.80% 2023 📝 28 $5,500,000 $2,000,000 $34,400,000 $550,000 $0 $42,450,000 17.60% 2024 📝 29 $2,500,000 $2,000,000 $34,900,000 $550,000 $0 $39,950,000 15.60% 2025 📝 30 $2,500,000 $0 $38,900,000 $550,000 $0 $41,950,000 -- 2026 📝 31 $2,500,000 $0 $38,900,000 $550,000 $0 $41,950,000 -- 2027 📝 32 $10,000,000 $0 $49,400,000 $550,000 $0 $59,950,000 -- 2028 📝 33 $13,000,000 $0 $30,900,000 $550,000 $0 $44,450,000 -- 2029 📝 34 $20,500,000 $0 $23,900,000 $550,000 $0 $44,950,000 -- 2030 📝 35 $27,000,000 $0 $22,900,000 $550,000 $0 $50,450,000 -- 2031 📝 36 $38,000,000 $0 $13,900,000 $550,000 $0 $52,450,000 -- Sum $124,815,000 $12,521,538 $337,216,905 $5,600,000 $53,081,905 $480,153,443 Average $10,401,250 $1,043,462 $28,101,409 $466,667 $4,423,492 $40,012,787 With this model his cap hit would be the 40 million each year for the 12 years. We'll need to adjust the yearly cap to account for the higher prices. Using the average will help make keeping track of it all easier, it'll also help out when bidding on players in the free agency as well as trading and releasing players. Releasing a player you'd be on the hook for the total prorated amount of 12.5 million if released within the first year of the contract. The base salary, roster and workout bonuses are dissolved. If traded, the contract length, base salary, roster bonus and workout bonuses carry over to the new team but the original team is still on the hook for the prorated bonuses (signing bonus). Doing it this way makes it easier to release players without breaking the bank. Year Exp Base Salary Prorated Bonus Roster Bonus Workout Bonus Cap Number Year Cap Hit Cap Savings 2020 3 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2020 -$12,521,538 $27,491,249 2021 4 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2021 -$11,478,077 $28,534,710 2022 5 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2022 -$10,434,615 $29,578,172 2023 6 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2023 -$9,391,154 $30,621,633 2024 7 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2024 -$8,347,692 $31,665,095 2025 8 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2025 -$7,304,231 $32,708,556 2026 9 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2026 -$6,260,769 $33,752,018 2027 10 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2027 -$5,217,308 $34,795,479 2028 11 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2028 -$4,173,846 $35,838,941 2029 12 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2029 -$3,130,385 $36,882,402 2030 13 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2030 -$2,086,923 $37,925,864 2031 14 $10,401,250 $1,043,462 $28,101,409 $466,667 $40,012,787 2031 -$1,043,462 $38,969,325 Sum $124,815,000 $12,521,538 $337,216,905 $5,600,000 $480,153,443 During free agency you're basically submitting the number of years you wish to sign the player and the average per year amount. Once on your roster, it's then broken down into base salary, prorated, roster and workout bonuses based on the players position just like franchise tags have different values per position. Here is some sample amounts for the quarterback position. Position Percentage Values QB 62.8% 24.6% 12.4% 0.2% 100.0% Bid APY Amount Base Salary Prorated Bonus Roster Bonus Workout Bonus Cap Number $1,000,000 $627,698 $246,265 $123,887 $2,150 $1,000,000 $3,000,000 $1,883,093 $738,796 $371,660 $6,451 $3,000,000 $5,000,000 $3,138,489 $1,231,326 $619,434 $10,751 $5,000,000 $7,000,000 $4,393,884 $1,723,857 $867,207 $15,051 $7,000,000 $9,000,000 $5,649,280 $2,216,387 $1,114,981 $19,352 $9,000,000 $11,000,000 $6,904,675 $2,708,918 $1,362,754 $23,652 $11,000,000 $13,000,000 $8,160,071 $3,201,448 $1,610,528 $27,953 $13,000,000 $15,000,000 $9,415,466 $3,693,979 $1,858,302 $32,253 $15,000,000 $17,000,000 $10,670,862 $4,186,509 $2,106,075 $36,554 $17,000,000 $19,000,000 $11,926,257 $4,679,040 $2,353,849 $40,854 $19,000,000 $21,000,000 $13,181,653 $5,171,571 $2,601,622 $45,154 $21,000,000 $23,000,000 $14,437,049 $5,664,101 $2,849,396 $49,455 $23,000,000 $25,000,000 $15,692,444 $6,156,632 $3,097,169 $53,755 $25,000,000 $27,000,000 $16,947,840 $6,649,162 $3,344,943 $58,056 $27,000,000 $29,000,000 $18,203,235 $7,141,693 $3,592,716 $62,356 $29,000,000 $31,000,000 $19,458,631 $7,634,223 $3,840,490 $66,656 $31,000,000 $33,000,000 $20,714,026 $8,126,754 $4,088,263 $70,957 $33,000,000 $35,000,000 $21,969,422 $8,619,284 $4,336,037 $75,257 $35,000,000 $37,000,000 $23,224,817 $9,111,815 $4,583,810 $79,558 $37,000,000 $39,000,000 $24,480,213 $9,604,345 $4,831,584 $83,858 $39,000,000 $41,000,000 $25,735,608 $10,096,876 $5,079,358 $88,158 $41,000,000 All of these calculations are done automatically within the workbooks to make it easier. We'll expand the league cap to account for this as well as increase it to get more talent assigned to each team, as I don't expect to get 32 members signed up at least not in the near future.
  4. Understand...Not sure if this changes things or not for you but the design of this keeper shouldn't be too much work wise. Might be worth revisiting when I get it all ready to go.
  5. I'm still in the process of building this beast, but if you are interested in being a part of it this is the place. Post the team you'd like to manage here. I'll continue to post updates as I continue to build this. If we don't get enough signed up we can always attempt to run it next year.
  6. Building the depth chart for this requires using both offense and defensive schemes. I'm looking at using madden to achieve this list. Primarily for offense. Each scheme differs slightly with its base package and using what I'm calling FLEX positions you can include a combination of three additional players to round out your offenses depth chart. Offensive Scheme Air Raid Multiple Power Run Multiple Zone Run Pistol/Option Power Run Pistol/Option Zone Run Pistol/Option Spread Vertical Power Run Vertical Zone Run West Coast Power Run West Coast Spread West Coast Zone Run 1 QB QB QB QB QB QB QB QB QB QB QB 2 RB FB RB FB RB RB FB RB RB RB FB 3 WR RB WR RB WR WR RB WR WR WR RB 4 WR WR WR WR WR WR WR WR WR WR WR 5 WR TE TE TE TE TE TE TE TE TE TE 6 LT LT LT LT LT LT LT LT LT LT LT 7 LG LG LG LG LG LG LG LG LG LG LG 8 C C C C C C C C C C C 9 RG RG RG RG RG RG RG RG RG RG RG 10 RT RT RT RT RT RT RT RT RT RT RT 11 WR TE TE WR TE WR WR WR TE WR WR FLEX 12 13 14 FB / FB / FB FB FB FB FB / RB / FB FB RB FB FB / RB / RB FB RB RB FB / TE / FB FB TE FB FB / TE / RB FB TE RB FB / TE / TE FB TE TE FB / WR / FB FB WR FB FB / WR / RB FB WR RB FB / WR / TE FB WR TE FB / WR / WR FB WR WR RB / RB / RB RB RB RB RB / TE / RB RB TE RB RB / TE / TE RB TE TE RB / WR / RB RB WR RB RB / WR / TE RB WR TE RB / WR / WR RB WR WR TE / TE / TE TE TE TE TE / WR / TE TE WR TE TE / WR / WR TE WR WR WR / WR / WR WR WR WR For defense this is what I've laid out. Using base defensive schemes 34 and 43 with two sub categories under / cover 2 / cover 3 / man to man / quarters. With the 3rd sub being as follows; 443 - Sub Package 524 - Sub Package 425 - Sub Package 335 - Sub Package 425 (big) - Sub Package 335 (big) - Sub Package 443 - Sub Package 524 - Sub Package 425 - Sub Package 335 - Sub Package The concept is to use the sub categories as a game planning tool each week depending upon your opponents strengths and weaknesses. Using this in conjunction with the game planning sliders I think it adds another layer of planning.
  7. Most of you guys already know that I like to keep you informed as I'm building these mocks. Doing so gives you a look at where I'm at with the build but it also helps keep me on track. As always feel free to commit. The build We need to get at least 16 members to join this. Anything less just isn't worth the amount of time to manage it. So if you're interested please make me aware as soon as you can. I'd like to kick this off by the end of this week if possible. How the initial season will start is by selecting your team to start the season. You'll have the ability to conduct a short fantasy draft for all active players from franchises not selected as these other 16 teams will be dissolved. We'll make this short, no more than 4 rounds. Rather than doing a typical tcmd blind bidding free agency. I'll start this season off with an open bidding free agency, which we'll use during the season and revert back to the blind bidding style during the off season. (see below for more information) Salary Cap/ Contract Structure It would be a nightmare to track and update a contract structure like irl so I'm looking to keep it somewhat simple here. Shark Tank (open bidding) are all single season contracts. Off season (blind bidding) will use the following: Multi year contract from 1 to 5 year options. You'll only need to enter one amount (total per year amount) From this amount the base and signing bonus is collected. The SB is determined by the two factors. Position and the average per year (apy) amount offered Using the average per year amounts from irl contracts, certain positions are more valuable than others. Kinda like the franchise tags differ based on positions (QB has more value than ST) Will also include an percentage increase based on the amount being offered. Higher the amount the greater the SB required. Here is an example. Pos. QB % Increase Adj. APY Bid Amount Base Salary per Year Signing Bonus per Year Gtd. % 0.0% $1,000,000 $803,294 $196,706 24.5% 1.0% $1,500,000 $1,189,941 $310,059 26.1% 2.0% $2,250,000 $1,762,411 $487,589 27.7% 3.0% $3,375,000 $2,609,867 $765,133 29.3% 4.0% $5,062,500 $3,864,175 $1,198,325 31.0% 5.0% $7,593,750 $5,720,325 $1,873,425 32.8% 6.0% $11,390,625 $8,466,581 $2,924,044 34.5% 7.0% $17,085,938 $12,529,013 $4,556,925 36.4% 8.0% $25,628,906 $18,537,230 $7,091,677 38.3% 9.0% $38,443,359 $27,421,411 $11,021,948 40.2% 10.0% $57,665,039 $40,555,466 $17,109,573 42.2% Pos. ILB % Increase Adj. APY Bid Amount Base Salary per Year Signing Bonus per Year Gtd. % 0.0% $1,000,000 $874,184 $125,816 14.4% 1.0% $1,500,000 $1,296,276 $203,724 15.7% 2.0% $2,250,000 $1,921,914 $328,086 17.1% 3.0% $3,375,000 $2,849,121 $525,879 18.5% 4.0% $5,062,500 $4,223,057 $839,444 19.9% 5.0% $7,593,750 $6,258,647 $1,335,103 21.3% 6.0% $11,390,625 $9,274,065 $2,116,560 22.8% 7.0% $17,085,938 $13,740,238 $3,345,700 24.3% 8.0% $25,628,906 $20,354,067 $5,274,839 25.9% 9.0% $38,443,359 $30,146,667 $8,296,692 27.5% 10.0% $57,665,039 $44,643,351 $13,021,688 29.2% Open Bidding FA Use the links below to see how it works. Bidding Form Bidding Tracking Doc I'm using a workbook that I created along with the help of @TedLavie. I believe it worked out pretty well for them last year. Outside of the changes needed to make it TCMD I got rid of the need to type the exact player name and pos and switched it out with just needing to type the 4 digit player ID number. I expect fewer mistakes when placing your bids. How it works, you place your bid using the google form, once the first valid contract offer is made the 24 hour clock starts and restarts each time a greater offer is made. Completely automated and it tracks each bid. With the bdl version we assigned 4 digit owner codes out privately so someone else couldn't make an offer on a player without the code. We can do this here but I'd rather use the "collect email address" feature to identify because it also sends out an email to you for your record of which player and amounts you bid on should anything go wrong. @EaglesPeteC and @scar988 I think this would actually be a solid way to conduct a free agency for ffmd should you guys decide to go that route. Always looking for feedback and suggestions. Thanks Mike
  8. Topics that would be awesome if I could get some suggestions on. Depth Chart Design One of the major issues in creating this is how to generate a depth chart. Seems simple and maybe it is I'm just not seeing a simple solution. The current set up to generate scores is based on the total number of stats for said position. For example, if you have 4 running backs on your roster it's calculating the sum of all four of their stats to generate the positional grade. Which I think would be fine if there were 32 teams but with fewer teams you could have 2 or more exceptional running backs on the roster skewing the overall stats for that position. Meaning one team could have a RB group producing 300 yards per game. So I think a depth chart is needed just trying to figure out the best way to create it. The depth chart, imo needs to reflect the scheme. So using base schemes for both offense and defense (perhaps stealing scheme names from madden) and based on those schemes would determine the number of players required for each position. For example a vertical offense would need 3 starting receivers where a power run offense might require 2 backs and either an additional TE or a FB. From there we could include play percentages for those positions. QB Cooper Rush Alex Tanney Colt McCoy Daniel Jones 100.00% 100.00% RB Elijhaa Penny Saquon Barkley Dion Lewis Wayne Gallman 100.00% 80.00% 10.00% 10.00% TE Eric Tomlinson Garrett Dickerson Levine Toilolo Kaden Smith Evan Engram 100.00% 30.00% 70.00% WR Johnny Holton Alex Bachman Darius Slayton Sterling Shepard Corey Coleman Golden Tate C.J. Board 100.00% 0.00% 0.00% 35.00% 30.00% 0.00% 35.00% 0.00% Defense would be set up in similar fashion. Or this. Based on the scheme you select the formulas take for example if the offensive scheme requires 3 receivers, it takes the top 3 receiving stats for that week of stats regardless of the depth chart. Is there one system that you think would work better than the other or have another suggestion?
  9. Thanks man. If you or anyone could help me out with the structure of this project.
  10. Asking again if you guys would be interested in joining and/or helping with a keeper/sim league. Still a ton of work to do with this project and I could certainly benefit from assistance in getting it built. Arizona CardinalsARI@LuckyNumber11 Atlanta FalconsATL @EaglesPeteC Baltimore RavensBAL@ravens5520 Buffalo BillsBUF @squire12 Carolina PanthersCAR@PR Chicago BearsCHI @BowserBroncos Cincinnati BengalsCIN@sparky151 Cleveland BrownsCLE@cortes02 Dallas CowboysDAL@D82 Denver BroncosDEN@BowserBroncos@FRock24Detroit LionsDET@winitall Green Bay PackersGB@squire12 Houston TexansHOU@jch1911 Indianapolis ColtsIND@Counselor Jacksonville JaguarsJAC@Trojan Kansas City ChiefsKC@samsel23@TedLavieLos Angeles ChargersLAC@wwhickok Los Angeles RamsLAR@jrry32@yoinesh123Miami DolphinsMIA@mountainpd Minnesota VikingsMIN@MikeT14 New Orleans SaintsNO@whodatOL New England PatriotsNE@Deadpulse New York GiantsNYG@ny92mike @rackcsNew York JetsNYJ@KingOfTheDot Las Vegas RaidersLVR@DTMW78 Philadelphia EaglesPHI@EaglesPeteC Pittsburgh SteelersPIT@Cbrunn San Francisco 49ersSF@Justone2 Seattle SeahawksSEA@Juan7637 Tampa Bay BuccaneersTB @whodatOLTennessee TitansTEN@bcb1213 Washington RedskinsWAS @mike23md
  11. ny92mike

    Cut Day

    So how do you guys feel about the 53 man roster? Any strengths or weaknesses at positions? I still think the team is weak at receiver and while improved the offensive line just isn't there yet. Defensively, I like the upfront line. Linebacker continues to lack a real game changer and with recent news on the injury to Blake Martinez we lack quality depth. Our secondary is much improved with adding Bradberry and Ryan the injury to McKinney hurts as I view him as having the potential to be a playmaker.
  12. ny92mike

    Cut Day

    This sucks...Showed upside his rookie year. An early 5th round selection that didn't work out. Hope you're right and he's signed to the PS.
×
×
  • Create New...