Looking for "Pirate" Prefix in Tships
Moderators: Moderators for English X Forum, Scripting / Modding Moderators
-
- Posts: 64
- Joined: Wed, 6. Nov 02, 20:31
Looking for "Pirate" Prefix in Tships
I'm making a Tships Xcel spreadsheet to get all details about ships. I've looked and looked and cant find the Prefix "Pirate" used in-game. Does anyone know how X games know which are Busters and Pirate Busters for example.
-
- Posts: 64
- Joined: Wed, 6. Nov 02, 20:31
- DrBullwinkle
- Posts: 5715
- Joined: Sat, 17. Dec 11, 01:44
Peace through superior firepower
Bullwinkle's List | Marine Repairs and Training | Mobile Mining Mk2 | Drone Carrier Software 2 (DCS2) | Ship Tricks: Mini-Guides (with Video)
Bullwinkle's List | Marine Repairs and Training | Mobile Mining Mk2 | Drone Carrier Software 2 (DCS2) | Ship Tricks: Mini-Guides (with Video)
-
- Posts: 64
- Joined: Wed, 6. Nov 02, 20:31
Many thanks DrBullwinkle The number is the Skin Index.
Just an update the little 1 just before the ship ID marks not just the pirate ships but also some Yaki ships as well .
Just a little tweek and now i have it. Thanks for all that looked and helped.
For all interested parties.
Had to make a bit of vba code to read the last but one entry for each ship then in my concatenate statement i had to have a couple of ifs but seems to work for the current tships.
Just an update the little 1 just before the ship ID marks not just the pirate ships but also some Yaki ships as well .
Just a little tweek and now i have it. Thanks for all that looked and helped.
For all interested parties.
Had to make a bit of vba code to read the last but one entry for each ship then in my concatenate statement i had to have a couple of ifs but seems to work for the current tships.
Last edited by Simon Prater on Sat, 8. Mar 14, 19:28, edited 1 time in total.
- DrBullwinkle
- Posts: 5715
- Joined: Sat, 17. Dec 11, 01:44
Types files are delimited by ";". You can import them directly into most spreadsheet programs. Then all you have to do is add a header row.
Peace through superior firepower
Bullwinkle's List | Marine Repairs and Training | Mobile Mining Mk2 | Drone Carrier Software 2 (DCS2) | Ship Tricks: Mini-Guides (with Video)
Bullwinkle's List | Marine Repairs and Training | Mobile Mining Mk2 | Drone Carrier Software 2 (DCS2) | Ship Tricks: Mini-Guides (with Video)
-
- Posts: 64
- Joined: Wed, 6. Nov 02, 20:31
Yep DrBullwinkle. I imported the CSV into excel.
I am using vlookup & concatenate to translate the NameID and the variation index into the in game name of each ship.
Only trouble was it did not treat the Pirate Buster any different to the Buster. I found that using a simple macro to move the Skin ID to the 1st column a simple vlookup and an If statement to illiminate the Yaki ships worked.
It is a clumsy way of doing it but Excel programming is just somthing I play with when i get a few minutes away from work/real life.
I am using vlookup & concatenate to translate the NameID and the variation index into the in game name of each ship.
Only trouble was it did not treat the Pirate Buster any different to the Buster. I found that using a simple macro to move the Skin ID to the 1st column a simple vlookup and an If statement to illiminate the Yaki ships worked.
It is a clumsy way of doing it but Excel programming is just somthing I play with when i get a few minutes away from work/real life.