Latest News: OOTP PATCH 9.1.6 released! - OOTP 9 RELEASED! - Title Bout Championship Boxing 2.5 released! - OOTP 2007 receives Editors Choice Award from PC Gamer - Inside the Park Baseball Patch 1.03 released, DEMO now available

Click here to download Out of the Park Baseball 9!

Go Back   OOTP Developments Forums > OUT OF THE PARK BASEBALL 9 > OOTP 9 - Mods > Database Tools
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 06-23-2008, 03:52 PM   #1 (permalink)
Hall Of Famer
 
darkcloud4579's Avatar
 
Join Date: Jun 2003
Location: All over the place..
Posts: 4,649
Market Size Calculator for OOTP9

Howdy folks.

This is the newest version of my market size calculator that began last year.

If you used it last year, it was way more ambitious then. Because of the changes made to the financials in this year's game, I decided to focus on the main area of what the tool was supposed to do -- help you figure out market sizes.



Here's a screenshot.

In the top right-hand corner in Red, you'll see a year. Replace that year for whatever year you're inputting it in. Conversely, it's not going to matter much, because of the way it's configured. But it's a modest change through history. The old model did a much better job of incorporating financial data into it, but with this version, you'll just get a rough approximation of the market size.

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 MSAs, 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 (in blue) 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. You should be good in-game for a decade or so, after which time if you want your market sizes to remain the same as the way they're in the sheet, then you'll want to input the information again.

The population are circa 2000-2006 and the DMA numbers are from 2008. The historical version of this tool, located here will give you a much more in-depth and historically accurate market size, based on a bevy of factors such as team performance, population size and more.

This tool was intended to be a low-fat version, meant for quick input of market size data. I've also uploaded MarketCalc Custom, in case you're running a fictional league and want to simply input your own DMA/population numbers without using RL information.

Feel free to ask questions if you have 'em.

Enjoy!
Attached Files
File Type: xls MarketCalc9.2.xls (236.0 KB, 257 views)
File Type: xls marketcalc_custom.xls (189.5 KB, 117 views)
darkcloud4579 is offline   Reply With Quote
Old 06-23-2008, 04:20 PM   #2 (permalink)
Hall Of Famer
 
1998 Yankees's Avatar
 
Join Date: Aug 2006
Location: Yankee Stadium
Posts: 5,888
First to download!

Thanks for this, dc.

(Actually, I posted on the wrong thread like an idiot - I was responding to the General Discussion thread, or so I thought - but the sentiment's the same. )
__________________
The 1998 Yankees are considered to be among the The Best Major League Baseball Teams Ever From 1902-2005 by Baseball Almanac. They were 68-20 at home that year (including playoffs and World Series) in the original Yankee Stadium (1923-2008), "Where Players Became Legends."

Last edited by 1998 Yankees : 06-23-2008 at 04:28 PM.
1998 Yankees is offline   Reply With Quote
Old 06-23-2008, 04:50 PM   #3 (permalink)
Major Leagues
 
neojonas's Avatar
 
Join Date: Aug 2006
Posts: 428
Thank you for your work on this!
neojonas is offline   Reply With Quote
Old 06-23-2008, 07:12 PM   #4 (permalink)
Hall Of Famer
 
darkcloud4579's Avatar
 
Join Date: Jun 2003
Location: All over the place..
Posts: 4,649
Glad you all are liking it!
darkcloud4579 is offline   Reply With Quote
Old 06-26-2008, 05:52 PM   #5 (permalink)
All Star Starter
 
SittingDuck's Avatar
 
Join Date: Apr 2007
Location: Richmond, VA
Posts: 1,805
Definitely a fine work. Be open to adjustments, because for instance the O's have one of the larger markets in the game, and it used to be MUCH larger than it currently is, especially in their hey-day.
SittingDuck is offline   Reply With Quote
Old 06-27-2008, 08:01 AM   #6 (permalink)
Major Leagues
 
CalvinHobbes's Avatar
 
Join Date: Jan 2004
Location: Calgary
Posts: 332
Did the post in the General threads get closed then? I was looking for DarkCloud's player modifiers, like aging, developing. I found the numbers interesting and wanted to play with them on my own. He had posted them in his original thread in the general discussions.

DarkCloud, if you see this, can you re post them? Or is there somewhere else I should look? Thanks very much.
__________________
In my opinion, we don't devote nearly enough scientific research to finding a cure for jerks.
CalvinHobbes is offline   Reply With Quote
Old 06-27-2008, 03:11 PM   #7 (permalink)
Hall Of Famer
 
darkcloud4579's Avatar
 
Join Date: Jun 2003
Location: All over the place..
Posts: 4,649
Here they are:

Dark Cloud's Market Size Calculator and Feeder Settings
darkcloud4579 is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 01:37 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 Out of the Park Developments