All system data spreadsheet

[RainOfSteel]

Oh! I'm sorry, and I'd already looked at your "from" locating at the bottom of your post, too.

I was only commenting, not attacking. It was easy to find and replace " " for existing "," and ";" for "," and load into Excel.


Note: Malenfant already has a set of rules for generating stars, somewhere there is mention of it already being done in Javascript.


The data source I used was: http://traveller.geekoids.com/software/mainpage.html.

Be forwarned, though. This claims to be a CT-era file, but it's mostly MegaTraveller.

In fact, at the time I was going through the net looking for CT-era UWPs, everything I found that claimed to be CT actually had MT-era data it. I found this to be enormously frustrating.

Which is why I was so happy when I saw your note that there was now an all CT-era database. Although I've found some discrepencies, these are microscopic when compared to what I've found elsewhere.


I've not yet checked the viewer program.

 

[RainOfSteel]

Is there any chance subsector names and/or subsector letters are retained in the original data somewhere?

 

[TheEngineer]

Every comment os welcome....

I will add them in the next "release" as a seperate column

Perhaps I could get them from the Cp tag included in the trade codes.......

 

[Falkayn]

Originally posted by TheEngineer:
Every comment os welcome....

I will add them in the next "release" as a seperate column

Perhaps I could get them from the Cp tag included in the trade codes.......

Das is sehr gut! (there, that's my German exhausted, unless you want me to count to 20 ...)

I noticed that the sector data for Glimmerdrift Reaches is probably there, but unnamed. Any chance of getting the names updated - and does the data match QLI's sector data for 990?

 

[RainOfSteel]

Originally posted by TheEngineer:
Every comment os welcome....

I will add them in the next "release" as a seperate column

Perhaps I could get them from the Cp tag included in the trade codes.......

Many of my database queries group information by subsector, and having the subsector name is critical.

Now, I can match sector and system and hex numbers between the old table and the new table, and copy subsector names over, but this will only work for the approx. 18,000+ worlds I have info for. The new database has 27,000+ rows!

If subsector names are not available, then something like, "SubSec A, SubSec B, SubSec C," would be appreciated.

 

[TheEngineer]

Will be done !