A Guide to the Spreadsheet
Jan 16, 2018 17:49:47 GMT -8
Nationals GM (Preston - Old), Rays GM (Donavan), and 1 more like this
Post by Pirates GM (Hollar) on Jan 16, 2018 17:49:47 GMT -8
For those of you who haven't spent something like 8000 hours working on the White Sox page of the league spreadsheet, it's probably a bit impenetrable at points. So, here's a brief guide to how I denote things.
First, a player's position. This is not a thing I worry about too much. I update things if I notice them, but I make no guarantees here. If you have a player who should be listed at a different position and you care about that sort of thing, message me. I'll change it.
Most importantly, the money parts. This is what the spreadsheet is here for. Free agent contracts are listed as defined values for each year of the signed contract, followed by the notation FA. This says that the player will be a free agent that year. Then there are the minor league contracts. These have a salary listed for the current season, followed by an asterisk. This is to mark players whose salary will simply roll over to the same amount next year, barring their promotion to the majors or non-tendering by you. Then there are the protected players. These are the players designated on your team page as PP X/5. These players make their real-life salary. They are listed with their salary for the current year, and the designation PROT for future controlled seasons. Which seasons these are may change due to playing time (Consult the league rules for more info on this if you want it. You should), so please do not take them as some sort of static gospel. This is why players in the last year of protection (PP 5/5) do not have the designation FA after the season. They may not be free agents if they do not play in enough games. This PP 5/5 designation is the hardest to see at a glance on the spreadsheet, but it's there and important.
As I just mentioned, protected players are payed their real-life salary. This can be tricky during the off-season, when these often haven't been announced yet. Salaries that are estimates (Taken from MLBTR where applicable) are highlighted in yellow. This signifies that these are not finalized, and will likely change. If you know the contract details for a player on your team who I haven't finalized yet, let me know and I'll update him.
Rows 43 through 52 are for your exempt roster, and are not added into your total salary, even though the salaries for the players are listed. Promise. Below that are released players, with their full salary listed. This is divided by 2 when it's calculated all the way at the bottom of the sheet.
That's about it, really. I hope this helps make a big ol' mess of numbers more approachable and understandable. If you have questions about anything not covered here, post away. And if I can figure out how to sticky things, I'll probably wind up doing that. My life is exciting.
First, a player's position. This is not a thing I worry about too much. I update things if I notice them, but I make no guarantees here. If you have a player who should be listed at a different position and you care about that sort of thing, message me. I'll change it.
Most importantly, the money parts. This is what the spreadsheet is here for. Free agent contracts are listed as defined values for each year of the signed contract, followed by the notation FA. This says that the player will be a free agent that year. Then there are the minor league contracts. These have a salary listed for the current season, followed by an asterisk. This is to mark players whose salary will simply roll over to the same amount next year, barring their promotion to the majors or non-tendering by you. Then there are the protected players. These are the players designated on your team page as PP X/5. These players make their real-life salary. They are listed with their salary for the current year, and the designation PROT for future controlled seasons. Which seasons these are may change due to playing time (Consult the league rules for more info on this if you want it. You should), so please do not take them as some sort of static gospel. This is why players in the last year of protection (PP 5/5) do not have the designation FA after the season. They may not be free agents if they do not play in enough games. This PP 5/5 designation is the hardest to see at a glance on the spreadsheet, but it's there and important.
As I just mentioned, protected players are payed their real-life salary. This can be tricky during the off-season, when these often haven't been announced yet. Salaries that are estimates (Taken from MLBTR where applicable) are highlighted in yellow. This signifies that these are not finalized, and will likely change. If you know the contract details for a player on your team who I haven't finalized yet, let me know and I'll update him.
Rows 43 through 52 are for your exempt roster, and are not added into your total salary, even though the salaries for the players are listed. Promise. Below that are released players, with their full salary listed. This is divided by 2 when it's calculated all the way at the bottom of the sheet.
That's about it, really. I hope this helps make a big ol' mess of numbers more approachable and understandable. If you have questions about anything not covered here, post away. And if I can figure out how to sticky things, I'll probably wind up doing that. My life is exciting.
