Random DB for OOTP11

[Bristolduke]

I can't redo the title but this is for any version of OOTP


I'm not sure if this is the correct board as random DB appears in several. I have created the ability to build a random DB. It will re-build the relevant csv files. There are no .odb files produced and you will have to be sure that are not in the folder you use to create the leagues.

I am willing to create files for folks if they want. I am not on the forum all the time, so e-mail is best (you can PM me but I still need to know an e-mail where to send the file).

Basically all I need to know is

1) The year you want to start (1871-2010)
2) How many teams you are starting with.
3) How many rounds of the ammy draft you want.
4) It is set to start with a 40 round draft, let me know if you want that changed. (I don't recommend using less than 40)
5) I can handle expansion (it's optional), just let me know how many teams in what years.

I can also do special builds (e.g. eliminate some players, combination of historical and fictional, franchise based). I can do the game's DB, Gambo/Spritze, or Spritze DB. I may be able to do others if you ask.

I'll create an entire set of .csv files, zip them up and send them to you. You will simply need unzip and put the folder in your /stats folder and point your new game to that master.csv.

[Bristolduke]

With patch 4 it is now possible to have random DB again.

I can randomize the OOTP files, Gambo/Spritze v3 DB or the Spritze HS v33 DB.

PM me if you are interested.

[Kobeck]

so would not be using the odb file???

[pbar25]

Originally Posted by Kobeck

so would not be using the odb file???

correct, you'd have to delete your odb file as it won't be used

[OutS|der]

is this possible with OOTP 12?

[jonpfl]

Originally Posted by OutS|der

is this possible with OOTP 12?

Yeah, I would LOVE to have this feature!! Any chance of it working for 12?

[bimper]

That would be very kind of you. I have OOTP 11 and OOTP 12

1) The year you want to start (1871-2009) 1871
2) How many teams you are starting with. 20-30
3) How many rounds of the ammy draft you want. 15 but your call
4) It is set to start with a 40 round draft, let me know if you want that changed. (I don't recommend using less than 40)
5) I can handle expansion (it's optional), just let me know how many teams in what years. your call

[Spritze]

Here is what I do....To make a random db simply create a spreadsheet with all the Player ID's you wish to use (which is the key field). A copy of the master is a good choice for this. Add a random number column and populate it with whatever constrained random number you wish. You need to constrain it to be between 1871 and 2011. That becomes your players new random debut date. Add another column that is the difference between the real and the random debuts. Then apply this difference to each players YearID field in the batting, pitching, and fielding files. Then go to the master and do the same to the birthyear and debut fields. Then delete the historical data odb file.

Once the Batting, Pitching, Fielding and Master files have been updated.....Play Ball!!!!!

Constraining the random number is covered on the Microsoft Support site if you use most versions of Excel, it is also covered on various "fancy things you can do with spreadsheets" sites. If you use something other than Excel it is probably covered somewhere else.

For my spreadsheet version one would use this formula.......... =RANDBETWEEN(1871,2011)

Oh yeah, this works with ANY version of OOTP and with the Spritze and Gambo db's and all the rest. It works with the neutered files (But you need to update both the std and the 2 files) as well.

When you get practiced at this and have a template that includes an update query based on the PlayerID and Year Difference you can make a new random db in under 10 minutes. Longer if you have a baby to change in the middle or a super-model on your lap. Just depends on your particular circumstance.

[jonpfl]

Originally Posted by Spritze

Here is what I do....To make a random db simply create a spreadsheet with all the Player ID's you wish to use (which is the key field). A copy of the master is a good choice for this. Add a random number column and populate it with whatever constrained random number you wish. You need to constrain it to be between 1871 and 2011. That becomes your players new random debut date. Add another column that is the difference between the real and the random debuts. Then apply this difference to each players YearID field in the batting, pitching, and fielding files. Then go to the master and do the same to the birthyear and debut fields. Then delete the historical data odb file.

Once the Batting, Pitching, Fielding and Master files have been updated.....Play Ball!!!!!

Constraining the random number is covered on the Microsoft Support site if you use most versions of Excel, it is also covered on various "fancy things you can do with spreadsheets" sites. If you use something other than Excel it is probably covered somewhere else.

For my spreadsheet version one would use this formula.......... =RANDBETWEEN(1871,2011)

Oh yeah, this works with ANY version of OOTP and with the Spritze and Gambo db's and all the rest. It works with the neutered files (But you need to update both the std and the 2 files) as well.

When you get practiced at this and have a template that includes an update query based on the PlayerID and Year Difference you can make a new random db in under 10 minutes. Longer if you have a baby to change in the middle or a super-model on your lap. Just depends on your particular circumstance.

Does that stop the situation where a certain date might not have enough players assigned to it?

Thx
jonpfl

[Spritze]

You'll have a similar number of players available every year whether you have 8 teams or 32. You could even them out by adding any number you choose to the generated number.
OR
You can always re-randomize in smaller groups, group the years with 8 teams, 16, etc.

You can control this yourself.

Imagination is one of the keys to success. As is a comfy chair, hot fudge and a girlfriend who actually likes you.

[Spritze]

Here it is

[bimper]

Can someone send me a file to use?

Pleeeease. Thanks

[molarmite]

How do you do the difference between debut and random year? Debut years have month and day while my random years is only the year. Do I have to find it manually? If I do =random column - debut column it gives me a #VALUE error.

[Spritze]

OOTP does not use the day or month to determine anything so I personally just strip the out. Right(Debut,4) or something similar should do it depending on the version/publisher of your spreadsheet.

Also make sure your columns are in a Integer Number format.

[Spritze]

I'll attach a small example xls file here so you can see what is what this evening in the evening after I get home in the evening. Specifically this evening. Well, maybe tomorrow morning. One never knows what the day may bring does one?

[bimper]

Thanks, Spritze. Might you hae ac ompleted DB for 2012 that you could send me? I am not great at Excel.

Thank you

[Spritze]

Randon db for OOTP12 available. PM me for the ftp link.

I made 20 different ones but only put up one. If it plays OK I'll put up the rest.

[MLHFFYP]

Originally Posted by Spritze

Randon db for OOTP12 available. PM me for the ftp link.

I made 20 different ones but only put up one. If it plays OK I'll put up the rest.

Spritze,

I sent you a pm for the link. Thanks much for your work and expertise. A couple of question regarding setup.

What year do you start with when you do the setup file at the creation of the game?

How many years does it run?

How many draft rounds are there for the initial draft?

Was it made for a 30 team league or is that flexible?

Do you recommend neutralized stats? Recalc on? Career play for basing potential ratings?

After the first year initial draft how many rounds will there be in subsequent drafts?

Thanks again,

Bob

[Spritze]

Originally Posted by MLHFFYP

What year do you start with when you do the setup file at the creation of the game?

Start whenever you wish (1871-2010)

Originally Posted by MLHFFYP

How many years does it run?

1871-2010

Originally Posted by MLHFFYP

How many draft rounds are there for the initial draft?

Depends when you start I suppose

Originally Posted by MLHFFYP

Was it made for a 30 team league or is that flexible?

Uses OOTP defaults so it depends on the year

Originally Posted by MLHFFYP

Do you recommend neutralized stats? Recalc on? Career play for basing potential ratings?

It is based on neutralized stats, nothing else works as well for cross-era play

Originally Posted by MLHFFYP

After the first year initial draft how many rounds will there be in subsequent drafts?

I have no idea, perhaps you can set them?

[MLHFFYP]

Spritze,


I have downloaded and am setting up my league with your random database.
I want to run my settings by you so that I can get the right configuration.
Here are my steps. Please let me know when I make a mistake. Hopefully, this can help some others as well.

• • • I start off by using the historical league creation wizard from New Custom Game.
    • I am starting at 1910. Should I import complete history up to 1910?
    • I choose advanced settings.

Step One

• • • After selecting the path to the database, Master.csv, I make the following selections:
      • Base current ratings on Neutralized Stats
      • Base potential ratings on Remaining Years of Career
      • Based Fielding Ratings on 3-Year Period
      • Base Pitcher Stamina on 3-Year Period

I check generate L/R splits and leave the rest of the page as is.


Step Two


1. I leave the step two screen as is.

Step Three

1. I leave everything unchecked.

Step Four
1. On this screen I do the following:

Player Development Recalculate Player Ratings Before Each Season

I check both Automatically Expand League and Hold Expansion Draft

I uncheck Financials as I don’t use this option.


Step Five I do not change anything on this screen

Step Six


On this screen I check the box to be in commissioner mode and to pick my team.
I then go into advanced mode.


I make selections under Game Options and then select my game from in the create game tab.


Structure – No change.


Names – Change only award names.


Rules – Only thing I do is uncheck 10/5 rule and Advanced Draftee Signing
Options – I check Hold Draft, Uncheck Ghost Players, set min. age to 18 and max to 35. I then keep everything else the same.


Financials – I uncheck Enable Financials.


Historical Settings – I keep everything as is except that I do check Double Weight of Current Year Stats.


Strategy – Not sure here. Should I choose the 1910 settings to import. Will this negatively impact the realism of the stats? I leave Automatically adjust league totals modifiers and Automatically import historical player boxes checked but am not sure if I should.


What suggestions would you make to make the random game more realistic?


Thanks.