But this now leads one to wonder, what do we know? How much will starting with a FF of 1 rather than 9 cost me? How fast will my FF grow? Will my winnings at some point cut off or at what rate do I need to retire players to keep my winnings coming? Growing out of a discussion on the merits of high ff here a few weeks ago, below is a link to an excel file I created to help answer these and other questions by showing how a team will grow over time based upon the choices and assumptions you make:
http://www.geocities.com/ttocont/Excel/index2.html
It is all based upon the idea that a team's development is governed by four things, fan factor, team rating, gate, and winnings. And overall, what a team is trying maximize (other than just wins) are their per game winnings in the future. That is, a team wants to make sure that 6/10/20 games from now, they will still be making not only sufficient money to cover any unexpected deaths or needed retirements, but to hopefully have money left to spend on freebooting wizards and star players for key games.
For those wishing to punish themselves, we do know how to calculate each of these four fundamental parts:
Total Fan Factor=Starting FF + FF gained/lost over time
TR=SUM(Players, Rerolls, Coaches)+SPPs/5+FF+Cash
Gate=Your FF*d6 + Opponents FF*d6
Winnings=d6 + (1 if you win) + winnings table modifier
Looking at these, we can see that they are interrelated, which is a good sign that we can subsititute things and simplify the problem. For example, the winnings table modifier is simply a function of your team rating and the gate, the gate is a function of you and your opponents fan factor, and fan factor is just a function of what you start with and how well you play (win%, percent of games with 2+TDs or Cas, etc.).
I can provide more detail to anyone who wants to know how I dealt with a specific part, but if you take a look at the file, let me know what you think. It started as something small to just look at long-term trends, but as I fiddled more and more, I thought of other ways to bring the short-term management aspects into the development.
And in case you couldn't tell, yes I'm color-blind so I was never any good in art class so you can suffer with the obnoxious colors chosen in the file because they look just fine to me.
