PBSL Finance Tracker S51

[AngryBanana]

Hey all, please see the attached google sheets documents to help you track your books and finances for this season. I am very bad at numbers, numbers are hard. K100 has made several gifs about my terrible counting in the past so I wanted to make something to help me with keeping my books straight. I also know we have some newer members who could also benefit from this. This should be able to help you track your roster and predict what your cap amount will be with potential signings, trades, cuts, and even your potential tax bill!

Artest:https://docs.google.com/spreadsheets/d/ ... sp=sharing

Wiggins: https://docs.google.com/spreadsheets/d/ ... sp=sharing

Randolph: https://docs.google.com/spreadsheets/d/ ... sp=sharing

Williams: https://docs.google.com/spreadsheets/d/ ... sp=sharing

DESCRIPTION:
The first table is the roster as of post RFA signings. If you add contracts to your roster table the totals at the bottom will automatically update. I did not include the MLE amount since it is optional to use and does not actively count against your cap. Underneath the Roster table, there are two salary tables. One is space to the cap (or how much you are over) with the second being the space to the tax cap or how much you are over.

Underneath the cap numbers is the projected point total and the projected point table (I am not sure how the points are projected so I ad libbed a bit here and guessed.) If the "space to taxable cap" is a negative number, then you find on the table which number is the first that is higher than that number and then go over to what year in the tax you are to get the amount of points you currently owe. The point total does not update, im not that save with excel.

Next to the roster table, there is the vet min table to tell you how much a vet min contract is in S51, based on the years of service for the player.

The table next to the vet min table is to help you figure out how much dead money you would take if you cut a player who had more than the vet min. You simply put in the information about the player into the table, then once you figure out what the difference between the current payment with the vet min , you put that number in the last column. The table will automatically sum it up and then input the total into the "Cut salary" in your roster table.

As always, let me know if yall like it or not. Also, if you can think of anyways to improve I am always open to listening. Also... with this being a living document, be nice.

[greepleairport]

+3 via consultation with previous media coordinator(s)