Tigers spreadsheet updates

[johnbosma]

I've only reviewed a few players on the Tigers spreadsheet. I'll post what I have found so far and will keep reviewing as I have time. The most common thing I'm finding is that the new spreadsheet appears to be often giving me one extra year of arb/team control. I should add that I'm comparing it to the previous spreadsheet.

Updates that I've found so far:
- Logan O?Hoppe will be a free agent in 2029
- Sean Bouchard will be a free agent in 2028
- Tristan Casas will be a free agent in 2029
- Nick Gordon will be a free agent in 2027
- Isaac Paredes will be a free agent in 2028
- Bryan Bello has three arb years left and will be an FA in 2028

[TheProfessor]

Thanks for your feedback @johnbosma .

The issue you're seeing is because of the way that arb values were input into the new SS. The contract values listed on the old SS are for the year 2024, whereas the new SS starts for 2025.

For finite contracts (i.e. FA), the end dates are correct. For flexible contracts (i.e. arb), the code has to treat it a different way, due to all of the variability.

The arb values that were copied over from the old SS to the new SS were the 2024 values. Once owners post their updated arb contracts for 2025, those "extra" years will all go away.

If you already DID post your arb decisions, and the years still don't add up, then please let me know and I will hunt down the issue.