Files you need:
http://www.rogepost.com/n/4550886187
To add a leader to the database:
Start with the file [font="Courier New"]Models_BOA43Mod.xls[/font]
Load the file with MS Excel or any other spreadsheet (e.g. Open Office).
The first row contain the description for every column. If you move the mouse pointer over one of the fields a popup should appear with further descriptions (They are saved as notes connected to the fields.)
I added one (not really historically) leader at the very end as an example for a unit which is not in the database.
After you added the entries for your new units/leaders save the file.
Export the sheet as a csv-file ([font="Courier New"]Units.csv[/font]). For Open Office: 'File' -> 'Save As' -> choose CSV as file type -> activate the checkbox 'Edit filter settings' -> 'Save' -> Field delimiter: semicolon, Text delimiter: none.
Open the file [font="Courier New"]Units_BOA43Mod.xls[/font]
Again the fields are described in the first line.
The field: 'Model Type' is your connection to the model file. You link there to the alias you specified in 'Models_BOA43Mod.xls'.
If you are finished save the file and export it as csv-file ([font="Courier New"]Models.csv[/font]).
Now you need to add the strings for 'ldr_txt...' and 'ArmyName...' to the [font="Courier New"]LocalStrings_BOA42.xls[/font] (I did this already.)
After you added the leaders to the database you can use them in a scenario.
Open [font="Courier New"]Setup75_AlternateCampaignMod.xls[/font]
You have 3 sheets in this file. For the start setup you need only the first. The sheet 'Reinforcements' contains the events.
What I changed here:
Line 3: I changed the scenario name so that the original scenario will not be overwritten.
Line 26: I changed the name of the scenario which is displayed in the scenario list if you start a new game in BoA. You have to add an corresponding entry to [font="Courier New"]LocalStrings_BOAMod.xls[/font] (I did this already.).
Line 171: I added the new leader to the army besieging Boston. The leader is part of the group 'Ward Command'. Of course you can also create new groups. The alias (column C) is the link to the new created unit.
In the sheet 'Reinforcements', line 3, I changed the name of the event file according to the new name of the scenario file.
Save the sheet 'Setup at start' as [font="Courier New"]Setup.csv[/font]
Save the sheet 'Reinforcements' as [font="Courier New"]Events.csv[/font]
Save the modified [font="Courier New"]LocalStrings_BOAMod.xls[/font] as [font="Courier New"]LocalStrings_BOA.csv[/font]
Now you can use the CSV-Splitter program to convert the files.
Units:
1. Open the CSV splitter
2. Input CSV file: 'Units.csv'
3. Select first tab 'Convert Data'
4. First field 'Output ext.': select 'uni'
5. Press 'Convert'
--> A lot of new files appeared.
6. Move all (or only the new one) unit files to [font="Courier New"]...\BoA\GameData\Units\[/font]
7. Move the file 'uni_Alias.ini' to [font="Courier New"]...\BoA\Aliases\[/font]
Models:
1. Open the CSV splitter
2. Input CSV file: 'Models.csv'
3. Select first tab 'Convert Data'
4. First field 'Output ext.': select 'mdl'
5. Press 'Convert'
--> A lot of new files appeared.
6. Move all (or only the new one) model files to [font="Courier New"]...\BoA\GameData\Models\[/font]
7. Move the file 'mdl_Alias.ini' to [font="Courier New"]...\BoA\Aliases\[/font]
Scenario:
1. Open the CSV splitter
2. Input CSV file: 'Setup.csv'
3. Select the tab 'Setup, Events'
4. Press 'Make Script'
--> A file 'script.ini' is created.
5. Copy the file to [font="Courier New"]...\BoA\Scripts\[/font]
Events:
1. Open the CSV splitter
2. Input CSV file: 'Events.csv'
3. Select the tab 'Setup, Events'
4. Press 'Make Script'
--> A file '1775 (alt) CampaignMod.sct' is created.
5. Copy the file to [font="Courier New"]...\BoA\Events\
[/font]
String file:
Copy the modified 'LocalStrings_BOA.csv' to [font="Courier New"]...\BoA\Settings\[/font]
Copy the new pictures for the leader to
[font="Courier New"]...\BoA\Graphics\Armies&Fleets\
...\BoA\Graphics\Units\[/font]
Start BoA. As the load screen is displayed press 'F9'. In the upper right corner 'Edit Mode ON' appear.
The game menu will open. Do nothing. The game will automatically start the new scenario. If you get an error message something went wrong.
Press the save button to save the scenario. Quit BoA and start it again, this time not in the edit mode.
Choose 'New Game'. The modified scenario should be listed there.
If anything is not clear don't hesitate to ask. I tested it on my system but perhaps I screwed something up.
The siege of Boston.