OOTP Data Generator

kq76 · 05-16-2004, 09:51 AM

This excel workbook allows you an easy way to generate data that can then be imported into OOTP (e.g. names, ratings, origins, uniform numbers, heights, weights, etc). For example, want 90% American names and 10% Latin names? Well with this utility you can do just that, easily.

You can download the 10KB (very small) zip file at:

Smelson · 05-16-2004, 01:18 PM

This looks great, but I am a microsoft excel illiterate. I just don't know how to get things to do what I want. Can someone please explain to me exactly what to do, and how to get the data in the game?

kq76 · 05-16-2004, 04:36 PM

There's a pretty detailed list of directions visible once you open the file. I'll copy it below. It might look intimidating because of the length, but it shouldn't be that difficult. I'm sure many people won't even need to read it. I just like to make directions as detailed as possible for those who might need that. That said, if I can make it better, I will.

***
-Enter the possible data and the frequency you want each to occur at in columns A & B. For example, if you want to generate Canadian cities, type Toronto into cell A2, Montreal into cell A3, etc. Then say you want Toronto to occur 75% of the time, type 75 into cell B2, and Montreal to occur 25% of the time, type 25 into cell B3, etc.
-Press the "Generate Data" button.
-Follow the directions in the windows that appear.
-Press the "Copy Data" button.
-Go to the setup screen in OOTP and export the CSV that contains the data you want to change (e.g. players_general.csv).
-Open the exported CSV in Excel and click on the cell in the second row of the column that contains the data you want to replace.
-Right-click, select "Paste Special", select "Values", and press ok.
-Repeat with any other data you want to change.
-Select the "Height" column, right-click and select "Format Cells", select "Custom" and in the field under "Type" type "M-D", or depending on your configuration, "D-M". This is needed because the format OOTP uses for heights tells Excel that they are dates.
-Save the file. If it asks if you want to keep the format, click "Yes".
-Go back to the setup screen in OOTP and this time import the CSV that contains the data you want to change (e.g. players_general.csv).
***

Smelson · 05-16-2004, 05:11 PM

thanks a lot...this should help

Tyke · 05-18-2004, 12:22 PM

This seemed to be exactly what I was looking for, as I want to be able to change the origins of my players to suit my solo league [all home-grown talent from Yorkshire in the UK!]. As far as I am aware, I followed the instructions to the letter, but when I try to reimport the csv file, it crashes the game. Anyone seen this, or got any suggestions as to what I might be doing wrong?

satchel · 05-18-2004, 12:39 PM

Your Excel settings might be interfering with the validity of the CSV file. I had to change some of my personal Excel settings to stop it from messing up the CSV files I was using it to manipulate.

Tyke · 05-18-2004, 05:23 PM

Which settings would be likely to cause the problem? I use Excel a little at work so I'm not completely computer illiterate, but I'm no expert either! Suggestions would be reatly appreciated.

kq76 · 05-18-2004, 05:29 PM

Thanks satchel. If you let us know which settings are probably causing the problem, I'll add a note about it in the file.

05-16-2004, 09:51 AM	#1
kq76 Global Moderator Join Date: Nov 2002 Posts: 12,006	OOTP Data Generator This excel workbook allows you an easy way to generate data that can then be imported into OOTP (e.g. names, ratings, origins, uniform numbers, heights, weights, etc). For example, want 90% American names and 10% Latin names? Well with this utility you can do just that, easily. You can download the 10KB (very small) zip file at: __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project) For Beta/Devs: Full screen (1920x1080) Last edited by kq76; 08-10-2025 at 11:32 PM.

05-16-2004, 04:36 PM	#3
kq76 Global Moderator Join Date: Nov 2002 Posts: 12,006	There's a pretty detailed list of directions visible once you open the file. I'll copy it below. It might look intimidating because of the length, but it shouldn't be that difficult. I'm sure many people won't even need to read it. I just like to make directions as detailed as possible for those who might need that. That said, if I can make it better, I will. * -Enter the possible data and the frequency you want each to occur at in columns A & B. For example, if you want to generate Canadian cities, type Toronto into cell A2, Montreal into cell A3, etc. Then say you want Toronto to occur 75% of the time, type 75 into cell B2, and Montreal to occur 25% of the time, type 25 into cell B3, etc. -Press the "Generate Data" button. -Follow the directions in the windows that appear. -Press the "Copy Data" button. -Go to the setup screen in OOTP and export the CSV that contains the data you want to change (e.g. players_general.csv). -Open the exported CSV in Excel and click on the cell in the second row of the column that contains the data you want to replace. -Right-click, select "Paste Special", select "Values", and press ok. -Repeat with any other data you want to change. -Select the "Height" column, right-click and select "Format Cells", select "Custom" and in the field under "Type" type "M-D", or depending on your configuration, "D-M". This is needed because the format OOTP uses for heights tells Excel that they are dates. -Save the file. If it asks if you want to keep the format, click "Yes". -Go back to the setup screen in OOTP and this time import the CSV that contains the data you want to change (e.g. players_general.csv). * __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project) For Beta/Devs: Full screen (1920x1080)

05-18-2004, 12:39 PM	#6
satchel Hall Of Famer Join Date: Apr 2002 Location: Ft Smith Ark. USA Posts: 2,681	Your Excel settings might be interfering with the validity of the CSV file. I had to change some of my personal Excel settings to stop it from messing up the CSV files I was using it to manipulate. __________________ JL Commish NPBL Rhode Island Reds ’33 ’34 ’35 TCBA San Francisco Railbornes ’74 ’76 ’77 ’78 FL New Orleans Black Sox ’56 ’57 ’58 ’59

05-18-2004, 05:29 PM	#8
kq76 Global Moderator Join Date: Nov 2002 Posts: 12,006	Thanks satchel. If you let us know which settings are probably causing the problem, I'll add a note about it in the file. __________________ My OOTP Wishlist \| My FAQ List OOTP Wiki \| Your Recommended Team Nicknames, By City (A Crowdsourced Project) For Beta/Devs: Full screen (1920x1080)

05-16-2004, 01:18 PM	#2
Smelson Minors (Single A) Join Date: Mar 2004 Posts: 57	This looks great, but I am a microsoft excel illiterate. I just don't know how to get things to do what I want. Can someone please explain to me exactly what to do, and how to get the data in the game?

05-16-2004, 05:11 PM	#4
Smelson Minors (Single A) Join Date: Mar 2004 Posts: 57	thanks a lot...this should help

05-18-2004, 12:22 PM	#5
Tyke All Star Starter Join Date: Apr 2002 Location: Cleckheaton, West Yorkshire, U.K. Posts: 1,138	This seemed to be exactly what I was looking for, as I want to be able to change the origins of my players to suit my solo league [all home-grown talent from Yorkshire in the UK!]. As far as I am aware, I followed the instructions to the letter, but when I try to reimport the csv file, it crashes the game. Anyone seen this, or got any suggestions as to what I might be doing wrong?

05-18-2004, 05:23 PM	#7
Tyke All Star Starter Join Date: Apr 2002 Location: Cleckheaton, West Yorkshire, U.K. Posts: 1,138	Which settings would be likely to cause the problem? I use Excel a little at work so I'm not completely computer illiterate, but I'm no expert either! Suggestions would be reatly appreciated.