Birth of the Federation

UE allows us to export the ship list in html format; from that to excel is easy; and there are a few ways out there to generate a ship list based on some base values, ship race, ship type, tech level ...
But then one needs to manually put all those values back in UE. And there are about 5000 values.

Now there is a way to export the ship list data from stbof.res to excel, there you can change the values and import the ship data back to stbof.res; thanks to QD.

http://www.4shared.com/folder/E92l7mSg/BOTF.html
you'll need QD's csv2sst.exe and Ship_List_Modifier2.1.xlsm Steps:
1. - use QD's csv2sst.exe to export the ship data from stbof.res to a .csv file
2. - use Ship_List_Modifier2.1.xlsm to import the the .csv, change the values, inspect and verify them in a friendlier view and then export them back to the .csv
3. - use csv2sst.exe to import the .csv file back to stbof.res

!!!!! One more thing: changing ship stats will make your saved game crash; so change stats only if you plan on not continuing your game.

Ship_List_Modifier2.1.xlsm release notes:
Jan 13 2014:
- added flags to select what ships have their stats generated, by ship type;
- added flags to have upgraded ships and outposts cost the same as the version they upgrade from;

well, no...
but would be a nice add I agree

I have made a tool in excel that uses some base values and generates the stats for the ships based on race, ship type and tech levels (like Mentat's, but simpler and friendlier ). The tool can also import the htlm ship list from UE on a different page and compare the UE values with the generated values and flags the differences so one can go back to UE and fix the mistype.

If one of you Java guys can add the import feature and state the list format for input, it will save the moder days.

what about giving java a go?

Hard to teach an old dog new tricks

Added some new functionality to the excel pages so you can skip generating stats for some ship types.
If you need it, see the links on the top post.

Cant download from 4shared - I dont do facebook/twitter/etcetera, and my antivirus prevents me using their own downloader program... (damn almost said app, stoopid apple.)

AlexMcpherson79 wrote:Cant download from 4shared

all you need to do is create an account, but I also added files as attachments in first post

thunderchero

that link is not working.

that file was adi personal changes the files required to export/import are below "csv2sst.rar" and "Ship_List_Modifier2.1.rar"