2018 Team Roster and Salary Cap

Yep

 

Only if it's opposite day.

 

Are you also a gm of another team or nah? Cause I swear I remember ur username

 

Nope. I'm late to this party and in way over my head as it is!

I've been around for a while.

 

How do I edit my spreadsheet anyway?

 

I can't figure that out either. I've just been copying my numbers directly off the Sportrac sight and pasting them on my spreadsheet page.

 

Open the spreadsheet in Google Drive link that Tim sent you. From there make all ur corrections and it will automatically update on L4SN. Tim made it very user friendly and simple.

 

Once your spreadsheet is done loading up, click on the box you wish to edit/change, it will be highlighted in blue... you can then hit backspace and the box will clear allowing you to type in a new amount. All changes are automatically updated to 'Drive'. You can also grab and drag the highlighted box left or right to make a larger area to type data in.

Be careful... I suggest you start with 1 particular box (preferable a small one) and practice the technique there. The work done on the spreadsheet will eventually show on this site.

 

The spreadsheets are great but they don't have formulas. So you either have to enter the formulas yourself or just keep changing the figures yourself.

 

Really upset I didn't get a phugh you from the old man on this one.

 

Don't forget that you need to pay your drafted players and that you need around $1.5M minimum to pay your practice squad for the entire season.
Below is a link to each team's rookie costs. Remember that if you made trades with draft picks then the numbers will change so use the table provided to add and subtract draft selections to help you.

https://overthecap.com/draft

The Spread Sheets say Draft Pool already so they just need to be edited when you make a trade.

 

Phuque You, Beach!

Feel better now?

 

Ok, I figured out how to access my sheet. I noticed that on the first page, the rows that detail contract totals have seven columns that add up to the total amount in the last column. There are no labels. So, what are those seven numbers?

Thanks,

 

Base Salary - Prorated salary - Roster Bonus - Workout Bonus - Dead Money, etc.

But that really isn't important. What is important is the far right column and you'll have to do some work on that to get it right.