Tool for editing and importing the ship list to stbof.res
Moderator: thunderchero
Tool for editing and importing the ship list to stbof.res
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;
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;
Last edited by adi on Mon Jan 13, 2014 3:37 pm, edited 11 times in total.
Re: Tool for importing the ship list to UE
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.
If one of you Java guys can add the import feature and state the list format for input, it will save the moder days.
Re: Tool for importing the ship list to UE
Hard to teach an old dog new tricks
Re: Tool for importing the ship list to UE
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.
If you need it, see the links on the top post.
- AlexMcpherson79
- Commander
- Posts: 332
- Joined: Thu Sep 04, 2008 2:00 am
Re: Tool for editing and importing the ship list to stbof.re
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.)
- thunderchero
- Site Administrator aka Fleet Admiral
- Posts: 7963
- Joined: Fri Apr 25, 2008 2:00 am
- Location: On a three month training mission, in command of the USS Valiant.
Re: Tool for editing and importing the ship list to stbof.re
all you need to do is create an account, but I also added files as attachments in first postAlexMcpherson79 wrote:Cant download from 4shared
thunderchero
Re: Tool for editing and importing the ship list to stbof.res
that link is not working.
Last edited by Mr_Sloan on Wed Jun 21, 2023 5:30 pm, edited 1 time in total.
- thunderchero
- Site Administrator aka Fleet Admiral
- Posts: 7963
- Joined: Fri Apr 25, 2008 2:00 am
- Location: On a three month training mission, in command of the USS Valiant.
Re: Tool for editing and importing the ship list to stbof.res
that file was adi personal changes the files required to export/import are below "csv2sst.rar" and "Ship_List_Modifier2.1.rar"