MikeT14 Posted November 1, 2021 Share Posted November 1, 2021 17 hours ago, ny92mike said: Appreciate it man. Can you message me your gmail address so that I can get you editing rights? It could be just me, but I don't see any FAs in there for me to test. Is it possible when you have time to throw like three different guys in there from a drop down menu. This thing is looking super clean. Nice job! Quote Link to comment Share on other sites More sharing options...
MikeT14 Posted November 1, 2021 Share Posted November 1, 2021 What is wrong with this one? Is it because I can't just do a 1 year deal with him yet? (I left it in the spreadsheet) Total $13,000,000 $2,000,000 0 0 $15,000,000 FA BIDDING ROUND 02 Reserve Offer #3 FA Bid # 3 New York Giants Contract Terms Bid Type Reserve Length of Contract: 1 Contract Validation Criteria APY Amount: $1,835,000 Valid Contract Type PASS Select Player from drop down list Yearly proration: $1,000,000 Required Contract Length PASS 2176 - Tevin Coleman - RB | GRD:58.7% - APY: $1,039,500 / CL:2 Total Contract Amount $1,835,000 Vet. Min Per year FAIL Select Contract Length: 1 Subsequent Yr % Rate PASS Enter Total Signing Bonus Amount: $500,000 Contract Structure Fails Validation Average Per Year (APY) PASS Tevin Coleman's Contract Demands 2176 Signing Bonus Amount PASS Contract Length: 2 Year ACQ'D Status Pos. Sort Player Identifier NFL Team 4 Digit ID Player Name Pos Exp Grade Vet. Min. Base Salary Base Guar. Prorated Roster Bonus W/O Bonus Cap Number Average Per Year (APY) $1,039,500 Subsequent 30% Rule Base Salary Values Signing Bonus: $250,076 1 2022 UFA ACT B 2176 - Tevin Coleman - RB NYJ 2176 Tevin Coleman RB 6 58.7% $835,000 $835,000 $1,000,000 $1,835,000 Valid Low Value High Value Low High Negotiating w/ Other Team(s) 0 2 2023 $960,000 $0 $0 Contract Structure Appraisal Calculation 3 2024 $0 $0 Base Salary NPV % Rate 10.00% 4 2025 $0 $0 Base Salary NPV $835,000 5 2026 $0 $0 Signing Bonus $1,000,000 6 2027 $0 $0 Resign Discount %. 6.00% 7 2028 $0 $0 Adj. Contract Offer Amount: $1,945,100 Avg. $835,000 $1,000,000 $1,835,000 Total $835,000 $1,000,000 0 0 $1,835,000 Quote Link to comment Share on other sites More sharing options...
MikeT14 Posted November 1, 2021 Share Posted November 1, 2021 You've changed this one some, and it looks a lot cleaner and more simple with the check boxes. That said, I can't seem to enter a new base number? Restructure Two Select Player to Restructure Current Contract Details 0509 - Corey Davis - WR Year ACQ'D Status Pos. Sort Player Identifier NFL Team 4 Digit ID Player Name Pos Exp Grade Vet. Min. Base Salary Base Guar. Prorated Roster Bonus W/O Bonus Cap Number FALSE Enter "New" Base Salary Amount 2022 Restruct ACT E 0509 - Corey Davis - WR NYJ 0509 Corey Davis WR 4 85.3% $835,000 $7,000,000 $12,000,000 $666,666 $0 $0 $7,666,666 New base salary amount must be between vet min and current base salary amount. 2023 Restruct ACT E 0509 - Corey Davis - WR NYJ 0509 Corey Davis WR 5 85.3% $850,000 $13,000,000 $13,000,000 $666,666 $0 $0 $13,666,666 2024 FALSE Convert Roster Bonus to SB $0 2025 FALSE Convert W/O Bonus to SB $0 2026 FALSE Convert B-Gtd. to SB $12,000,000 2027 Restructure Data 2028 Fixed Contract Length 2 Average: $10,000,000 $12,500,000 $666,666 $0 $0 $10,666,666 Base Salary Converted to Bonus $0 Restructured Contract Details Total: $20,000,000 $25,000,000 $1,333,332 $0 $0 $21,333,332 Proration of Converted Base Salary $0 Year ACQ'D Status Pos. Sort Player Identifier NFL Team 4 Digit ID Player Name Pos Exp Grade Vet. Min. Base Salary Base Guar. Prorated Roster Bonus W/O Bonus Cap Number Base Gtd Converted to Proration 1 2022 Restruct ACT E 0509 - Corey Davis - WR NYJ 0509 Corey Davis WR 4 85.3% $835,000 $12,000,000 $666,666 $0 $0 $666,666 Roster / Workout Bonuses $0 2 2023 Restruct ACT E 0509 - Corey Davis - WR NYJ 0509 Corey Davis WR 5 85.3% $850,000 $13,000,000 $13,000,000 $666,666 $0 $0 $13,666,666 Total amount converted to proration $0 3 2024 4 2025 Restructure Allotment Exceeded 5 2026 6 2027 7 2028 2022 Cap Savings: $7,000,000 Average: $13,000,000 $12,500,000 $666,666 $0 $0 $7,166,666 2023 Cap Savings: $0 Total: $13,000,000 $25,000,000 $1,333,332 $0 $0 $14,333,332 2024 Cap Savings: $0 Quote Link to comment Share on other sites More sharing options...
MikeT14 Posted November 1, 2021 Share Posted November 1, 2021 Ohhh I like the new trade block additions. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted November 1, 2021 Author Share Posted November 1, 2021 Thanks man. I'll be home this evening to check it out. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted November 1, 2021 Author Share Posted November 1, 2021 10 hours ago, MikeT14 said: What is wrong with this one? Is it because I can't just do a 1 year deal with him yet? (I left it in the spreadsheet) Total $13,000,000 $2,000,000 0 0 $15,000,000 FA BIDDING ROUND 02 Reserve Offer #3 FA Bid # 3 New York Giants Contract Terms Bid Type Reserve Length of Contract: 1 Contract Validation Criteria APY Amount: $1,835,000 Valid Contract Type PASS Select Player from drop down list Yearly proration: $1,000,000 Required Contract Length PASS 2176 - Tevin Coleman - RB | GRD:58.7% - APY: $1,039,500 / CL:2 Total Contract Amount $1,835,000 Vet. Min Per year FAIL Select Contract Length: 1 Subsequent Yr % Rate PASS Enter Total Signing Bonus Amount: $500,000 Contract Structure Fails Validation Average Per Year (APY) PASS Tevin Coleman's Contract Demands 2176 Signing Bonus Amount PASS Contract Length: 2 Year ACQ'D Status Pos. Sort Player Identifier NFL Team 4 Digit ID Player Name Pos Exp Grade Vet. Min. Base Salary Base Guar. Prorated Roster Bonus W/O Bonus Cap Number Average Per Year (APY) $1,039,500 Subsequent 30% Rule Base Salary Values Signing Bonus: $250,076 1 2022 UFA ACT B 2176 - Tevin Coleman - RB NYJ 2176 Tevin Coleman RB 6 58.7% $835,000 $835,000 $1,000,000 $1,835,000 Valid Low Value High Value Low High Negotiating w/ Other Team(s) 0 2 2023 $960,000 $0 $0 Contract Structure Appraisal Calculation 3 2024 $0 $0 Base Salary NPV % Rate 10.00% 4 2025 $0 $0 Base Salary NPV $835,000 5 2026 $0 $0 Signing Bonus $1,000,000 6 2027 $0 $0 Resign Discount %. 6.00% 7 2028 $0 $0 Adj. Contract Offer Amount: $1,945,100 Avg. $835,000 $1,000,000 $1,835,000 Total $835,000 $1,000,000 0 0 $1,835,000 This one is because you didn't put the contract length number in cell F93. It populates the contract section when you do. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted November 2, 2021 Author Share Posted November 2, 2021 10 hours ago, MikeT14 said: It could be just me, but I don't see any FAs in there for me to test. Is it possible when you have time to throw like three different guys in there from a drop down menu. This thing is looking super clean. Nice job! The list populates on my end. It may be that the load time it takes for the drop down takes a minute. Try it again when you get a minute and just give it a few seconds to pull up. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted November 2, 2021 Author Share Posted November 2, 2021 10 hours ago, MikeT14 said: You've changed this one some, and it looks a lot cleaner and more simple with the check boxes. That said, I can't seem to enter a new base number? Restructure Two Select Player to Restructure Current Contract Details 0509 - Corey Davis - WR Year ACQ'D Status Pos. Sort Player Identifier NFL Team 4 Digit ID Player Name Pos Exp Grade Vet. Min. Base Salary Base Guar. Prorated Roster Bonus W/O Bonus Cap Number FALSE Enter "New" Base Salary Amount 2022 Restruct ACT E 0509 - Corey Davis - WR NYJ 0509 Corey Davis WR 4 85.3% $835,000 $7,000,000 $12,000,000 $666,666 $0 $0 $7,666,666 New base salary amount must be between vet min and current base salary amount. 2023 Restruct ACT E 0509 - Corey Davis - WR NYJ 0509 Corey Davis WR 5 85.3% $850,000 $13,000,000 $13,000,000 $666,666 $0 $0 $13,666,666 2024 FALSE Convert Roster Bonus to SB $0 2025 FALSE Convert W/O Bonus to SB $0 2026 FALSE Convert B-Gtd. to SB $12,000,000 2027 Restructure Data 2028 Fixed Contract Length 2 Average: $10,000,000 $12,500,000 $666,666 $0 $0 $10,666,666 Base Salary Converted to Bonus $0 Restructured Contract Details Total: $20,000,000 $25,000,000 $1,333,332 $0 $0 $21,333,332 Proration of Converted Base Salary $0 Year ACQ'D Status Pos. Sort Player Identifier NFL Team 4 Digit ID Player Name Pos Exp Grade Vet. Min. Base Salary Base Guar. Prorated Roster Bonus W/O Bonus Cap Number Base Gtd Converted to Proration 1 2022 Restruct ACT E 0509 - Corey Davis - WR NYJ 0509 Corey Davis WR 4 85.3% $835,000 $12,000,000 $666,666 $0 $0 $666,666 Roster / Workout Bonuses $0 2 2023 Restruct ACT E 0509 - Corey Davis - WR NYJ 0509 Corey Davis WR 5 85.3% $850,000 $13,000,000 $13,000,000 $666,666 $0 $0 $13,666,666 Total amount converted to proration $0 3 2024 4 2025 Restructure Allotment Exceeded 5 2026 6 2027 7 2028 2022 Cap Savings: $7,000,000 Average: $13,000,000 $12,500,000 $666,666 $0 $0 $7,166,666 2023 Cap Savings: $0 Total: $13,000,000 $25,000,000 $1,333,332 $0 $0 $14,333,332 2024 Cap Savings: $0 Weird it should be allowing you to enter that value. Are you trying to enter it in cell C9 / C33 / C57 ? Quote Link to comment Share on other sites More sharing options...
ny92mike Posted November 2, 2021 Author Share Posted November 2, 2021 10 hours ago, MikeT14 said: Ohhh I like the new trade block additions. Thanks...I hope it works like I'm thinking. Quote Link to comment Share on other sites More sharing options...
MikeT14 Posted November 2, 2021 Share Posted November 2, 2021 I’ll check again with this info tomorrow Quote Link to comment Share on other sites More sharing options...
ny92mike Posted November 2, 2021 Author Share Posted November 2, 2021 16 minutes ago, MikeT14 said: I’ll check again with this info tomorrow Thanks man. Gonna have to start messaging some of my regulars to get some help. Tagging them isn't working...haha. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted November 2, 2021 Author Share Posted November 2, 2021 1 hour ago, MikeT14 said: I’ll check again with this info tomorrow I'm hoping the FA list pulls up for you. If not it's a good indication that I've got too much going on in one workbook and will need to separate the workbooks. Was hoping to avoid that if possible. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted November 2, 2021 Author Share Posted November 2, 2021 @MikeT14 Hey man, when you look at it tomorrow, and if you have time think about the following: Sheet for depth chart if it would be better to include this in the forum or a worksheet. Team Needs I'd like to tie this to the trade block some how, if you've got any ideas for this let me know. Scouting FA and Draftees I've done some sheets for this in the past but I'm not a fan of the design, so I don't really use it and if I'm not using it I'm sure not too many are using it. Quote Link to comment Share on other sites More sharing options...
MikeT14 Posted November 2, 2021 Share Posted November 2, 2021 12 hours ago, ny92mike said: This one is because you didn't put the contract length number in cell F93. It populates the contract section when you do. I'm under Reserve Contract Bidding. F93 is 0571 - Dan Feeney - LG | GRD:48.2% - APY: $3,988,455 / CL:5 12 hours ago, ny92mike said: The list populates on my end. It may be that the load time it takes for the drop down takes a minute. Try it again when you get a minute and just give it a few seconds to pull up. I'll leave it up and see if it eventually loads, but still no drop down menu. 12 hours ago, ny92mike said: Weird it should be allowing you to enter that value. Are you trying to enter it in cell C9 / C33 / C57 ? We're good now. Quote Link to comment Share on other sites More sharing options...
ny92mike Posted November 3, 2021 Author Share Posted November 3, 2021 As soon as @MikeT14 confirms this last test, I'll know if I'm going to have to separate this team workbook into at least 2 maybe 3 workbooks to speed up the processing. Back to the drawing board. 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.