Stwa's BoA Modding Tips - Find and Replace

[Stwa]

When using the excel workbooks for modifying BoA scenario data, I have found that it is better to consolidate all the scenario workbooks into a single workbook containing all worksheets. I have also included into this workbook, the local string sheets for BOA and AGE.

In so doing, I can now search and replace data across all worksheets at once. This method is particulary useful when tyring to figure out what scenarios are using a particular event, or finding out if an event is used at all by the scenarios.

Also, you can use this technique to globally replace data names, for example you could change all instances of "Art " to "Artillery" etc..

Excel will keep track of each data location, and allow you to jump to each worksheet for further examination. Plus if you do make changes, you will have a list of each sheet that was changed, so you can save these to their CSV file equivalent for splitting.

[Pocus]

if you are alone on earth, yes, it is better to aggregate everything... But teamwork demands that files are split, so that it is more handy when several peoples work on different things. As a tester, you know that I'm sure

[Stwa]

Ah yes, but since you seem to have some programming experience (just kidding), then I am sure you are aware of the law that states:

The duration of a software project is DIRECTLY proportional to the size of the development team.

In our example,

The more scripters you have, the longer it will take to complete the project.

Follow this link for a real world example ---> http://www.ageod-forum.com/showthread.php?t=10202

[Pocus]

I prefer to think it is a logarithmic function.