Jump to content

TCMD 2021 - League Office (Open)


ny92mike

Recommended Posts

1 minute ago, bcb1213 said:

Keep getting the data you entered in cell f4 violates data validation rules set on this cell 

 

2 minutes ago, ny92mike said:

What was the value you put in the signing bonus?

I've tried numbers ranging from five dollars to five million.  Won't let me put anything in it 

Link to comment
Share on other sites

Just now, bcb1213 said:

 

I've tried numbers ranging from five dollars to five million.  Won't let me put anything in it 

Oh yeah you have to enter a value equal or greater than the expected SB amount in this case it would be $16,814,998.  Once entered it prorates it based on the number of years you are offering.

Player's Contract Terms  
Min APY Value $16,615,611
Min SB Value $16,814,998
Contract Length 5
Link to comment
Share on other sites

8 minutes ago, ny92mike said:

Oh yeah you have to enter a value equal or greater than the expected SB amount in this case it would be $16,814,998.  Once entered it prorates it based on the number of years you are offering.

 

Player's Contract Terms  
Min APY Value $16,615,611
Min SB Value $16,814,998
Contract Length 5

Oh nvm then. Just wipe that whole section out. My bad. I'm a spreadsheet idiot 

  • Like 1
Link to comment
Share on other sites

GB Packers announce the contract extension for All Pro WR Davante Adams

0663 - Davante Adams - WR

0663 - Davante Adams - WR
Enter Signing Bonus Amount $26,759,845
Select Contract Length 5
   
Player's Contract Terms  
Min APY Value $18,911,551
Min SB Value $26,759,845
Contract Length 5
   
Contract APY Amount $18,911,969
Contract APY Difference $418
   
   
SB Proration Amount $5,351,969
Total Proration Amount: $5,351,969
2021 Savings: $6,818,031
2022 Savings: -$13,681,969
2021 Salary Cap

$9,524,956

 

Current Contract
Year Status Pos. Sort Player Identifier NFL Team 4 Digit ID Player Name Pos Exp Grade Vet. Min. Base Salary Base Gtd. Signing Bonus Roster Bonus Workout Bonus Cap Number Contract Terms
2021 Active D 0663 - Davante Adams - WR GB 0663 Davante Adams WR 7 99.3% $1,080,000 $12,250,000   $3,600,000 $500,000 $500,000 $16,850,000 1yr / $16,850,000
2022                                  
                    Sum $12,250,000 $0 $3,600,000 $500,000 $500,000 $16,850,000  
CONTRACT EXTENSION PASSES VALIDATION
    Avg. $12,250,000   $3,600,000 $500,000 $500,000 $16,850,000  
                   
                   
                                   
Extended Contract
Year Status Pos. Sort Player Identifier NFL Team 4 Digit ID Player Name Pos Exp Grade Vet. Min. Base Salary Base Gtd. Signing Bonus Roster Bonus Workout Bonus Cap Number Contract Terms
2021 Active D 0663 - Davante Adams - WR GB 0663 Davante Adams WR 7 99.3% $1,080,000 $1,080,000   $8,951,969     $10,031,969 5 yr / $94,559,845
2022 Active D 0663 - Davante Adams - WR GB 0663 Davante Adams WR 8 99.3% $1,120,000 $8,330,000   $5,351,969     $13,681,969  
2023 Active D 0663 - Davante Adams - WR GB 0663 Davante Adams WR 9 99.3% $1,170,000 $12,430,000   $5,351,969     $17,781,969  
2024 Active D 0663 - Davante Adams - WR GB 0663 Davante Adams WR 10 99.3% $1,210,000 $17,750,000   $5,351,969     $23,101,969  
2025 Active D 0663 - Davante Adams - WR GB 0663 Davante Adams WR 11 99.3% $1,260,000 $24,610,000   $5,351,969     $29,961,969  
2026                                  
2027                                  
                    Sum $64,200,000 $0 $30,359,845 $0 $0 $94,559,845  
                    Avg. $12,840,000   $6,071,969     $18,911,969  
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...