WitploadAE is provided in the SCEN folder to extract and package the scenario data to and from .csv files. There a whole range of programs that can work with .csv, but I prefer Excel personally.
Are you simply changing the ammo by set parameter (ex. all x2) ? If so there is a pretty easy way of doing this.
1)Create a text file, put a number in it somewhere.
2)Open that text file with a spreadsheet program, I know this is possible in Open Office
3)Copy and paste the lines with the ammo amounts into the txt.
4)Apply the formula, creating a new row for the changed amounts
5)Save the txt. file and close it
6)Import it into excel again. Now here is the fun part, because it was saved as a .txt it only saves the values and not the formulas, so you now have a row with the original values and a row with the new values, which are no longer tied to the original values.
7)Copy and paste the row with your new values into the AE database spreadsheet, voila, thousands of changes in but a couple of minutes.
Brilliant approach, but sadly it wont work here as the changes have no relation to the original values, only on the rounds carried for each gun and its rate of fire.
John, on a related note - I mentioned the issue with Japanese DD's all carrying DP guns in stock; do you want me to correct these to what they should be (ie only Type-B and Type-D 12.7cm mounts are DP), or shall I leave them as is? On one hand changing this can really hurt your fleets AA, forcing you to rely on cruisers and BBs for AA, but on the otherhand it really makes those new DDs with proper DP weaponry invalueble.
I've got the sub changes and RN ammo down to DD's done, but I might not be able to finish everything today, sorry.
< Message edited by JuanG -- 5/2/2010 8:05:27 PM >