Dark Cloud's Financial Market Model Version 1.0 - Page 4

darkcloud4579 · 12-31-2007, 09:51 PM

I think the media money makes teams spend more, from what I'm seeing. If it weren't that, things would be more sensible. The budgets themselves don't seem to increase spending, it seems to be media mone. So a way to combat that, would be to smooth out the media money and divide it into the number of years that the media deal is for. That way, the teams can only spend that particular amount year after year, rather than each year..which is probably more realistic. Past versions of the spreadsheet have accounted for that, I only changed it, because I wanted the game to basically run on its own and if you never go back to the spreadsheet again.

But in retrospect, that might be the most dramatic change of all. To divide the media money up, rather than giving it as one lump sum annually.

rasnell · 12-31-2007, 10:38 PM

The mod link in your signature on page 1 does not link to the file. I'm interested in taking a look at your latest version and have followed your progress reports all along. I just haven't had a chance to download and look.

darkcloud4579 · 12-31-2007, 10:48 PM

Good times.

Version 5.7 is the newest one.

Here's a link to the change list and such alike.

dl5175 · 12-31-2007, 11:38 PM

Quote:

Originally Posted by darkcloud4579

I think the media money makes teams spend more, from what I'm seeing. If it weren't that, things would be more sensible. The budgets themselves don't seem to increase spending, it seems to be media mone. So a way to combat that, would be to smooth out the media money and divide it into the number of years that the media deal is for. That way, the teams can only spend that particular amount year after year, rather than each year..which is probably more realistic. Past versions of the spreadsheet have accounted for that, I only changed it, because I wanted the game to basically run on its own and if you never go back to the spreadsheet again.

But in retrospect, that might be the most dramatic change of all. To divide the media money up, rather than giving it as one lump sum annually.

I actually did that, I put the total in the media contract line and 1 years worth in the media revenue this year and when I finished day it change the media revenue this year line to the big number in media contract I even had 5 years int the years line.

darkcloud4579 · 01-01-2008, 01:32 AM

I think what you'll probably need to do is to divide the media revenue into however many years, put that as the media contract in both categories, because the game does it annually, rather than as an actual contract like it ought to. Perhaps because that makes too much sense, who knows.

darkcloud4579 · 01-02-2008, 12:42 AM

Provided the next iteration of this goes well, I'll release v6.0 sometime in mid-January. I've so far come up with a new ticket price mechanism, rather than the arbitrary thing we used in earlier versions, now the ticket prices are set based on MSA, records over the past two years, playoff appearances and World Series titles and your stadium rating. So it's far more realistic than before, which I like.

I'll also break the new one down so that media money is smoothed out, rather than being lumpy like we've been doing. Though I have no real evidence that it increases payrolls (I increased my current league's average salaries at the same time that I started with the new sheet), I figure it might be better safe than sorry having that much money floating around for teams to waste and I'm intrigued to see how it responds.

So it won't come out for a while, but...I just wanted to appraise of my progress.

darkcloud4579 · 01-05-2008, 02:33 AM

Here's Version 6.0.

The whole thing is tweaked. Basically, when you look at the new version, you'll notice that all of those gargantuan sums of money are no longer inputted into the game. I found a way to smooth it out, because the prior result was having computer teams spending tons because we were giving them all of their media deal annually, rather than breaking it up like it should be done.

So right now, you should input the media amount in this version over a five year period, meaning the amount that the game calculates for media money is the same for each of the five years you run that particular sim. The other numbers will adapt on their own.

What's nice about this is that teams will now lose money and be in the hole if they go too far in spending their available cash. You do have to the heavy lifting of inputting the info, but you can input it once and never have to do it again, if you smooth the media money out over a longer period. The only reason I encourage you to do the work to do it every 5-10 years is, the assumptions of the model are affected by team performance and so, lest you ignore it.

Eliminated the revenue sharing formula too and altered the way media money is spread out, though the larger media market teams have a distinct advantage.

I think this version provides the sort of realism I was attempting with v.1.

Lemme know what you think and if you use it and how.

dl5175 · 01-05-2008, 11:49 PM

I do not see Toronto and Tampa on here?

darkcloud4579 · 01-06-2008, 12:41 AM

I didn't make the new one MLB ready. It was the one I was using, so you'll have to alter it to make it reflect whatever setup you're trying to use. I just setup it using my demo league and my demo league has 32 teams and teams have moved around a bit.

But the tools that you need to do that -- or just a matter of copying and pasting from the other ones into this one -- is all you'll need to do that.

tkirch · 01-09-2008, 01:19 PM

DC, you were on track with something I was working on. The question I have is, where do you get the DMA numbers. Because I have much higher DMA numbers than you do.
I would think the DMA would be higher than the market.
My thought is the Market is city size while DMA is the area around. I can get DMA numbers and they seem higher than you have.

darkcloud4579 · 01-11-2008, 01:33 AM

Here you go..it was on Page 2.

darkcloud4579 · 01-11-2008, 01:35 AM

Quote:

Originally Posted by tkirch

DC, you were on track with something I was working on. The question I have is, where do you get the DMA numbers. Because I have much higher DMA numbers than you do.
I would think the DMA would be higher than the market.
My thought is the Market is city size while DMA is the area around. I can get DMA numbers and they seem higher than you have.

DMA is the TV Market. It's determined by Nielsen's and it's smaller than the metropolitan area. Because it's called Designated Market Area and sometimes, you can merge two smaller, co-located DMAs can be combined to make a larger.

biggerboat · 01-15-2008, 08:47 AM

Please forgive my rookie knowledge base, just trying to make sure I have a handle on what this program does. It sounds awesome. So, by inputting the data from the spreadsheet that is in orange into the game, teams will know develop more realistic spending habits based on market size? Is the data entered just once and before free agency? Are things you mentioned like Bandwagon happening behind the scenes?
Sorry for the newbie question, thank you for your help.

darkcloud4579 · 01-15-2008, 04:33 PM

No problem, glad to help.

Yes, if you put the information in orange into the game, teams will have more realistic spending habits based on their market sizes. You should do it before free agency and do it every five years, as that's how the newest sheet is set for.

Do turn off revenue sharing, though, if you're going to use it or it sorta negates all of this. And set your cash maximum to zero or to some ungodly amount so that no matter what happens, the money teams have doesn't go to some other club through revenue sharing or something weird the game tries to do.

So yeah, that's it. Bandwagon is embedded into the formula and the game does tweak the numbers like fan interest and stuff on its own, so the baseline numbers you set in Year 1, will be managed by the game from Year 1-5 and heading into season six, the spreadsheet will take account how the team has done over the previous timeframe and assess a new number to operate from.

So using this, it's better to do well when you know it's time for a new calculation because you're stuck with say, a big spending spree for the subsequent five years if you go crazy. It factors spending into account, too.

darkcloud4579 · 01-17-2008, 04:03 PM

I've created OOTPFin7. It's the simplest, sleekest and most effective version of the tool.

It's only setup for you to input for one team. But you could rinse, wash and repeat for each team in the league. Or you could use 6.5 to store critical information and then save the information generated in there each time.

I felt this was the best way to do it for people who want realistic numbers for their own team and don't want to bother with the whole league OR just to present the information and the setup in the simplest way possible for setting up your team's financial information.

Here's a screenshot of what it looks like:

That's it. You input the information in the brown area and the blue area generate the information that you input into the game.

khucke · 01-18-2008, 04:16 AM

Is stadium rating related to a ballpark`s capacity or a subjective rating of its overall quality?

darkcloud4579 · 01-18-2008, 10:24 AM

Subjective rating of its overall quality.

PlayTheKids · 01-19-2008, 06:19 PM

Holy crap! I'm thoroughly impressed with this.

I've lurked for ages, played leagues here and there, but really want to get into a full-fledged universe (and, as I love to write, dynasties as well). The amount of effort you've put into this is really remarkable. Thank you for the time and effort. I look forward to using it once I get my new universe off the ground.

darkcloud4579 · 01-19-2008, 07:57 PM

Quote:

Originally Posted by PlayTheKids

Holy crap! I'm thoroughly impressed with this.

I've lurked for ages, played leagues here and there, but really want to get into a full-fledged universe (and, as I love to write, dynasties as well). The amount of effort you've put into this is really remarkable. Thank you for the time and effort. I look forward to using it once I get my new universe off the ground.

That means a lot to me. Really, you have no idea. I embarked on this project solely for my own benefit, but if one person has benefited from it...then that's a huge bonus for me.

PlayTheKids · 01-19-2008, 08:12 PM

Financials are a tremendous component of a league. If you've come up with a way to better reflect this, that's a tremendous help.

I would always encourage people to share things they create around here. You never know who it may help, or who may be able to grab something and take it to another level.

I'll likely harass you with a bunch of questions once I get going on my universe (though I plan to start the backstory in the next couple of days). Be prepared!

12-31-2007, 10:38 PM	#62 (permalink)
rasnell Hall Of Famer Join Date: Jan 2003 Posts: 2,298	The mod link in your signature on page 1 does not link to the file. I'm interested in taking a look at your latest version and have followed your progress reports all along. I just haven't had a chance to download and look. __________________ OOTP beta tester for second year. Charlie Root, unfairly remembered for one pitch, the exaggerated "called shot" of Babe Ruth in the 1932 World Series, won more games in a Chicago Cub uniform than any pitcher in the franchise's history. "If that big, fat guy had pointed, you'd think we would have seen it." -- Daughter Della Root Arnold

01-15-2008, 08:47 AM	#73 (permalink)
biggerboat Bat Boy Join Date: Jan 2008 Posts: 1	Dark Cloud's Financial Market Model Version 1.0 Please forgive my rookie knowledge base, just trying to make sure I have a handle on what this program does. It sounds awesome. So, by inputting the data from the spreadsheet that is in orange into the game, teams will know develop more realistic spending habits based on market size? Is the data entered just once and before free agency? Are things you mentioned like Bandwagon happening behind the scenes? Sorry for the newbie question, thank you for your help.

01-17-2008, 04:03 PM	#75 (permalink)
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Location: All over the place.. Posts: 4,460	OOTPFin7 I've created OOTPFin7. It's the simplest, sleekest and most effective version of the tool. It's only setup for you to input for one team. But you could rinse, wash and repeat for each team in the league. Or you could use 6.5 to store critical information and then save the information generated in there each time. I felt this was the best way to do it for people who want realistic numbers for their own team and don't want to bother with the whole league OR just to present the information and the setup in the simplest way possible for setting up your team's financial information. Here's a screenshot of what it looks like: That's it. You input the information in the brown area and the blue area generate the information that you input into the game. Last edited by darkcloud4579 : 01-20-2008 at 01:35 PM.

01-18-2008, 10:24 AM	#77 (permalink)
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Location: All over the place.. Posts: 4,460	Subjective rating of its overall quality. __________________ FOBL: Bantam Originals Baseball Club (2028-present) FOOL: An off-season league \| 27 & Counting \| Reading, Writing & Big Ideas \| Synonym \| Tennis Polo (Toccer)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

12-31-2007, 09:51 PM	#61 (permalink)
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Location: All over the place.. Posts: 4,460	I think the media money makes teams spend more, from what I'm seeing. If it weren't that, things would be more sensible. The budgets themselves don't seem to increase spending, it seems to be media mone. So a way to combat that, would be to smooth out the media money and divide it into the number of years that the media deal is for. That way, the teams can only spend that particular amount year after year, rather than each year..which is probably more realistic. Past versions of the spreadsheet have accounted for that, I only changed it, because I wanted the game to basically run on its own and if you never go back to the spreadsheet again. But in retrospect, that might be the most dramatic change of all. To divide the media money up, rather than giving it as one lump sum annually.

12-31-2007, 10:48 PM	#63 (permalink)
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Location: All over the place.. Posts: 4,460	Good times. Version 5.7 is the newest one. Here's a link to the change list and such alike.

01-01-2008, 01:32 AM	#65 (permalink)
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Location: All over the place.. Posts: 4,460	I think what you'll probably need to do is to divide the media revenue into however many years, put that as the media contract in both categories, because the game does it annually, rather than as an actual contract like it ought to. Perhaps because that makes too much sense, who knows.

01-02-2008, 12:42 AM	#66 (permalink)
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Location: All over the place.. Posts: 4,460	Provided the next iteration of this goes well, I'll release v6.0 sometime in mid-January. I've so far come up with a new ticket price mechanism, rather than the arbitrary thing we used in earlier versions, now the ticket prices are set based on MSA, records over the past two years, playoff appearances and World Series titles and your stadium rating. So it's far more realistic than before, which I like. I'll also break the new one down so that media money is smoothed out, rather than being lumpy like we've been doing. Though I have no real evidence that it increases payrolls (I increased my current league's average salaries at the same time that I started with the new sheet), I figure it might be better safe than sorry having that much money floating around for teams to waste and I'm intrigued to see how it responds. So it won't come out for a while, but...I just wanted to appraise of my progress.

01-05-2008, 11:49 PM	#68 (permalink)
dl5175 Minors (Single A) Join Date: Mar 2006 Posts: 62	I do not see Toronto and Tampa on here?

01-06-2008, 12:41 AM	#69 (permalink)
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Location: All over the place.. Posts: 4,460	I didn't make the new one MLB ready. It was the one I was using, so you'll have to alter it to make it reflect whatever setup you're trying to use. I just setup it using my demo league and my demo league has 32 teams and teams have moved around a bit. But the tools that you need to do that -- or just a matter of copying and pasting from the other ones into this one -- is all you'll need to do that.

01-09-2008, 01:19 PM	#70 (permalink)
tkirch Minors (Double A) Join Date: Jul 2002 Posts: 153	DC, you were on track with something I was working on. The question I have is, where do you get the DMA numbers. Because I have much higher DMA numbers than you do. I would think the DMA would be higher than the market. My thought is the Market is city size while DMA is the area around. I can get DMA numbers and they seem higher than you have.

01-15-2008, 04:33 PM	#74 (permalink)
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Location: All over the place.. Posts: 4,460	No problem, glad to help. Yes, if you put the information in orange into the game, teams will have more realistic spending habits based on their market sizes. You should do it before free agency and do it every five years, as that's how the newest sheet is set for. Do turn off revenue sharing, though, if you're going to use it or it sorta negates all of this. And set your cash maximum to zero or to some ungodly amount so that no matter what happens, the money teams have doesn't go to some other club through revenue sharing or something weird the game tries to do. So yeah, that's it. Bandwagon is embedded into the formula and the game does tweak the numbers like fan interest and stuff on its own, so the baseline numbers you set in Year 1, will be managed by the game from Year 1-5 and heading into season six, the spreadsheet will take account how the team has done over the previous timeframe and assess a new number to operate from. So using this, it's better to do well when you know it's time for a new calculation because you're stuck with say, a big spending spree for the subsequent five years if you go crazy. It factors spending into account, too.

01-18-2008, 04:16 AM	#76 (permalink)
khucke Minors (Triple A) Join Date: Dec 2001 Location: Düsseldorf, Germany Posts: 239	Is stadium rating related to a ballpark`s capacity or a subjective rating of its overall quality?

01-19-2008, 06:19 PM	#78 (permalink)
PlayTheKids Banned Join Date: Oct 2007 Posts: 116	Holy crap! I'm thoroughly impressed with this. I've lurked for ages, played leagues here and there, but really want to get into a full-fledged universe (and, as I love to write, dynasties as well). The amount of effort you've put into this is really remarkable. Thank you for the time and effort. I look forward to using it once I get my new universe off the ground.

01-19-2008, 08:12 PM	#80 (permalink)
PlayTheKids Banned Join Date: Oct 2007 Posts: 116	Financials are a tremendous component of a league. If you've come up with a way to better reflect this, that's a tremendous help. I would always encourage people to share things they create around here. You never know who it may help, or who may be able to grab something and take it to another level. I'll likely harass you with a bunch of questions once I get going on my universe (though I plan to start the backstory in the next couple of days). Be prepared!