Today I'm releasing an updated version of
MarketCalc for OOTPX. I haven't made any real improvements to it since last year, but there might be some to come later, as I can think of a few things I'd like to do with it, integrating some of the things from MarketCalc8 into the new version to allow people running fictional leagues to do more.
In any case, here's what it does:
Quote:
On the first line you'll see a year. Replace that year for whatever year you're playing in starting in 1901 and going onto well past 2020 (I think it goes up to 2050, but I don't recall offhand.)
I've taken the liberty of inputting MLB teams for you. But you can put any team you want in the TEAM section of the tool.
In the CITY NAME section, use the drop-down menus to pick the city you're looking for. You'll have to scroll, but they're there. Or at least, the metropolitan or micropolitan place name of the place you're looking for. I took it straight from Census data. (If you're looking for Canadian metro areas, you'll need to scroll all the way to the bottom. I put those in last.)
Once you click on a city, it'll automatically populate the City Pop area.
Do the same thing for DMA Name. DMA is the TV market for the area you've selected. You choose the DMA from the drop down and again, Canadian DMAs are at the bottom. It'll give you the DMA Size.
With that information and modifiers, it'll automatically generate a MARKET SIZE number, that you can input into the game. That'll work for a decade and the game will alter that up or down based on its mechanisms, but you can leave it alone and won't need to change it again until ten years after you did it.
|
MarketCalc originated with OOTP2007, when I was annoyed that I couldn't get OOTP to model finances like real life.
What I mean by "real life" is, I wanted to be able to play in New York and see the modern day, non-revenue sharing effects of that largess versus say, playing in Portland, Maine or Winnemucca, Nevada. OOTP doesn't do this naturally, you have to tweak it to make it work.
It's for use in Excel, but OpenOffice also opens .xls files.
BUT WAIT, THERE'S MORE!
Included in GMEXcel is a little tool called Fire MGR X. It's basically a tool for solo players to determine owner confidence. Want to find out when you're not doing well enough and need to fire yourself and get a new job? This tool does just that.
It comes with instructions and is easy to use. Basically, you get awarded points for regular season performance and post-season appearances. But the better you get, the more challenging it is to keep your job if you start to slack over a period of time.
Future improvements for this will eventually allow you to figure what sort of teams you can take over and other house rule calculations to make solo play more immersive.
Let me know if you have questions and enjoy!
EDIT HERE'S THE LATEST VERSION OF GMEXCEL[/B]
Here's
GMExcel 10.75