Post by Pirates GM (Hollar) on Apr 25, 2013 19:23:30 GMT -8
The spreadsheet has been officially locked for editing. From here on out I will be handling updating it as teams make roster moves. This will allow the league to have an official record of the contracts on a team, making roster and salary cap checks significantly easier. Hopefully it will not make my life too much harder. If you believe there is an issue with your team's spreadsheet, please let me know so I can look into it. All teams still have the ability to view the spreadsheet.
In addition, I will be making two changes to the spreadsheet that I stole from various team's pages while I was doing the recent spreadsheet checks/updates (If you were one of these teams, thanks for the intellectual property). Any contract signing a player for a specific length of time is being marked with a red 'FA' in the year after the last year the player is signed for. This will make it easier to separate the expiring contracts from the players who are still under team protection. Secondly, I will be changing the releases section to simply display the contract the player was signed to. The formula at the bottom of the sheet will then divide this by two. This will making checking the salary owed for released players easier, and involve less math. Win. Players released and then signed by other teams will have their salaries properly adjusted. Click on the proper box if you want to see the formula that is involved. Again, let me know if you believe there is an error, or if you just have a question.
Finally, if I go on a three-week meth jag or something and am not replying to your frantic entreaties to update your spreadsheet, there are other people who have the ability to do so. PB, Mac and Pat also have the edit capability. Contact me first though, as none of them were masochistic enough to ask to do this. In return, I promise to try to not do meth, though of course there are situations where this is difficult (Living in Indiana, for example).
I also promise to try not to move to Indiana.
In addition, I will be making two changes to the spreadsheet that I stole from various team's pages while I was doing the recent spreadsheet checks/updates (If you were one of these teams, thanks for the intellectual property). Any contract signing a player for a specific length of time is being marked with a red 'FA' in the year after the last year the player is signed for. This will make it easier to separate the expiring contracts from the players who are still under team protection. Secondly, I will be changing the releases section to simply display the contract the player was signed to. The formula at the bottom of the sheet will then divide this by two. This will making checking the salary owed for released players easier, and involve less math. Win. Players released and then signed by other teams will have their salaries properly adjusted. Click on the proper box if you want to see the formula that is involved. Again, let me know if you believe there is an error, or if you just have a question.
Finally, if I go on a three-week meth jag or something and am not replying to your frantic entreaties to update your spreadsheet, there are other people who have the ability to do so. PB, Mac and Pat also have the edit capability. Contact me first though, as none of them were masochistic enough to ask to do this. In return, I promise to try to not do meth, though of course there are situations where this is difficult (Living in Indiana, for example).
I also promise to try not to move to Indiana.