Schedule Edit

[KJDelaney]

Is there a way to do a mass edit of a schedule? For some reason my schedule shows correct for GMT. I would like the schedule to reflect Eastern/Central

[Ike348]

Your teams probably don't have any cities listed, so they don't have any time zones, hence the GMT times. Check under team options and see if the team has a city listed for it.

[KJDelaney]

All of the teams have names. When I select under manager options GMT, the times are correct, however when I select Central Time (live in Texas), i get some games starting at 8am.

I am using NABA.

[HuachucaThunder]

Are you managing a team? I believe it depends on the location of the team that you are managing or GMing. Pick an eastern team and it will show Eastern Time Zone under manager settings, central team = central time zone, etc. I may be wrong, but this is something that drove me crazy when I first started playing OOTP a few moons ago.

[KJDelaney]

Nope.

Still wrong.

[bwburke94]

Go into the team settings and check to see if any teams are listed as having cities, i.e. "Houston, Texas" - this is NOT the City field in the team name!

[KJDelaney]

All have regular city names. All cities correspond with their exact city names.

[Bigrod]

Originally Posted by KJDelaney

All have regular city names. All cities correspond with their exact city names.

Are you using a modded world_default.xml file???

[KJDelaney]

Yes, I was able to load the NABA league from a few years ago.

[KJDelaney]

Should i get/use a different one?

[KJDelaney]

When looking at my other leagues. They all work fine.

[Ike348]

Originally Posted by bwburke94

Go into the team settings and check to see if any teams are listed as having cities, i.e. "Houston, Texas" - this is NOT the City field in the team name!

This is what I was referring to.

[KJDelaney]

All teams look fine.

[Honorable_Pawn]

Originally Posted by KJDelaney

Is there a way to do a mass edit of a schedule? For some reason my schedule shows correct for GMT. I would like the schedule to reflect Eastern/Central

Yes, a mass edit should be pretty easy to do in excel.

do this:

Export the schedule

Open with Note pad

Copy paste to Excel

Delete rows 1-4 then delete the last two rows

Highlight column C-->click on the data tab-->click on Text to Columns-->Use delimited-->click next-->check mark other-->insert a " in the blank box-->click next-->click finish

Let's say you want all times to be listed as 1 hour later.

In cell N1 type this without the quotes "=f1+100" -->Now drag this formula all the way down.--->copy column N and paste special values to column F.

Delete column N

Now all you have to do is remerge. In order to do that you have to put back the quotes that you removed while using text to columns.

Now add a columns like shown on the screenshot below:



Please note that columns G,L,Q & V actually have a space in them.

Now type the formula you see in cell Y1. Drag this formula all the way down.

Now open that text file back up. Delete every row except for the first 4 and the last 2. This is the opposite of what you did in Excel. Now paste special values from excel to the Text file.

Save.

Re-import the schedule during the off-season.

[david limbaugh]

Excellent suggestion! Instead of Excel. I export to a text file, open the .lsdl file, leave the header and footer info, but I use quick basic code to write my schedule's <game day = ... > lines and paste those into the .lsdl and import back in.

I wish Markus would not let folks have night games until 1935, Baseball Almanac Famous First Night Games

[txranger]

Notepad ++ is a good free text editor... It has a Find and replace feature... Just select Search, Replace and tell it what to Find and what to replace it with and bingo your done... Save it and re-import it into the game... I use it all the time to change game times from night to day games... Works great...

[Honorable_Pawn]

Originally Posted by txranger

Notepad ++ is a good free text editor... It has a Find and replace feature... Just select Search, Replace and tell it what to Find and what to replace it with and bingo your done... Save it and re-import it into the game... I use it all the time to change game times from night to day games... Works great...

I was unaware that Noepad ++ has a replace feature. The only problem with that I guess is what if all game times are not the same? Can you do a find and replace with a mathematical function such as +100?

[Le Grande Orange]

Originally Posted by Honorable_Pawn

I was unaware that Noepad ++ has a replace feature. The only problem with that I guess is what if all game times are not the same? Can you do a find and replace with a mathematical function such as +100?

I don't think so. In such cases copying the schedule data into a spreadsheet app like Excel and doing those sorts of changes in there then copying the results back to your text file is easier.