CHANGES
Quote:
-Superstar negotiator to simulate a more competitive market environment
- New sheet added for Trade Value Calculator
- A host of formula tweaks for better performance
- Removed five-year budget projections (I need to tweak that concept before reimplementing it...)
|
Version 4.0 of the spreadsheet is focused on its gradual process of trying to create a tool that will make the game not only more realistic in its financial processes, but more difficult for solo players by creating one-stop shopping in terms of competitiveness models (augmenting the AI) rather than forcing you to use your imagination entirely.
The new
TRADE VALUE CALCULATOR is the most dramatic of these tools. It gives you a model to assess a trade from 1-5 players to you and the computer (I don't attempt to account for three-team deals, since the game doesn't support them..but you can still cultivate them more fairly using this tool..)
Basically, it takes VORP and player overall rating (on a 20-80 scale) and assigns a value to the player and if the scales are tipped too far in your favour, it tells you by how much (in a cash amount) the deal is off by. You could attempt to add that much cash to cover the deal, but...realistically, it just means you ought to add a player of closer value to close the gap on the deal and that amount is just to give you an idea of how much of a value you're getting.
It doesn't take into account payrolls and such alike, because it figures that's something for you and your league to worry about. And that way, it allows you to use the tool with any era and with any generation of players, which I thought would be handy.
DC'S SUPERSTAR NEGOTIATOR
is something that I'm trying to cultivate as a separate tool like the trade value calculator, but for now it relies on values from the spreadsheet to make it work. The assumptions are in modern-day dollars, so it wouldn't be useful for a past-era unless you changed all of the formulas.
The idea is to simulate other GMs bidding on a favourite player of yours each off-season. We're talking a star player that you're trying to sign. The notion is, if a team isn't doing as well, they're going to be more likely to consider making a splash to sign said player, providing that they have a need for them.
So how you'd use it, is find 1-5 other teams that are interesting the same player you are, then input the values from their part of the spreadsheet and then it will come up with a contract amount that those teams would pay said player.
Then in the game once the player signs, you give him that deal that the negotiator decided on. If it's one of the other teams, same situation, you follow the negotiator.
The idea is to take some of the mystery out of things and yet, adding some sort of realism that I think the game seems to flub up a bit related to contracts for stars in the game and the lack of real bidding wars except on occasion.
That's pretty much it. Well, I need to explain some other stuff. But I'm still not convinced anyone even uses this. So...I won't go there yet. But I might, provided there is a desire by people to have me do that.