Tool for editing and importing the ship list to stbof.res

Tool for editing and importing the ship list to stbof.res; support/discussion/questions

Moderator: thunderchero

Post Reply
User avatar
adi
Commander
Commander
Posts: 442
Joined: Sun Aug 12, 2012 6:53 pm
Location: US East Coast

Tool for editing and importing the ship list to stbof.res

Post by adi » Wed May 15, 2013 2:01 pm

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
csv2sst.rar
(516.49 KiB) Downloaded 111 times
Ship_List_Modifier2.1.rar
(443.93 KiB) Downloaded 118 times
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.

User avatar
Flocke
BORG Trouble Maker
BORG Trouble Maker
Posts: 2582
Joined: Sun Apr 27, 2008 2:00 am
Location: Hamburg, Germany
Contact:

Re: Tool for importing the ship list to UE

Post by Flocke » Wed May 15, 2013 2:14 pm

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

User avatar
adi
Commander
Commander
Posts: 442
Joined: Sun Aug 12, 2012 6:53 pm
Location: US East Coast

Re: Tool for importing the ship list to UE

Post by adi » Wed May 15, 2013 4:25 pm

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.

User avatar
Flocke
BORG Trouble Maker
BORG Trouble Maker
Posts: 2582
Joined: Sun Apr 27, 2008 2:00 am
Location: Hamburg, Germany
Contact:

Re: Tool for importing the ship list to UE

Post by Flocke » Wed May 15, 2013 8:29 pm

what about giving java a go? :)

User avatar
adi
Commander
Commander
Posts: 442
Joined: Sun Aug 12, 2012 6:53 pm
Location: US East Coast

Re: Tool for importing the ship list to UE

Post by adi » Thu May 16, 2013 9:12 am

Hard to teach an old dog new tricks

User avatar
adi
Commander
Commander
Posts: 442
Joined: Sun Aug 12, 2012 6:53 pm
Location: US East Coast

Re: Tool for importing the ship list to UE

Post by adi » Thu Nov 21, 2013 4:55 pm

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.

User avatar
AlexMcpherson79
Commander
Commander
Posts: 325
Joined: Thu Sep 04, 2008 2:00 am

Re: Tool for editing and importing the ship list to stbof.re

Post by AlexMcpherson79 » Sat Nov 22, 2014 8:40 am

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.)

User avatar
thunderchero
Site Administrator aka Fleet Admiral
Site  Administrator aka Fleet Admiral
Posts: 6431
Joined: Fri Apr 25, 2008 2:00 am
Location: On a three month training mission, in command of the USS Valiant.
Contact:

Re: Tool for editing and importing the ship list to stbof.re

Post by thunderchero » Sat Nov 22, 2014 10:02 am

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

User avatar
Mr_Sloan
Ensign
Ensign
Posts: 49
Joined: Sun Mar 29, 2020 11:43 am

Re: Tool for editing and importing the ship list to stbof.res

Post by Mr_Sloan » Sat Jun 13, 2020 9:22 am

adi wrote:
Wed May 15, 2013 2:01 pm

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
that link is not working. is the file still availalbe to export/import ship data?

User avatar
thunderchero
Site Administrator aka Fleet Admiral
Site  Administrator aka Fleet Admiral
Posts: 6431
Joined: Fri Apr 25, 2008 2:00 am
Location: On a three month training mission, in command of the USS Valiant.
Contact:

Re: Tool for editing and importing the ship list to stbof.res

Post by thunderchero » Sat Jun 13, 2020 9:56 am

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

Post Reply

Return to “Tool for editing and importing the ship list to stbof.res”

Who is online

Users browsing this forum: No registered users