Traveller Trade Tool

[Terry Mixon]

Another one.

 

[Terry Mixon]

Another one.

 

[Terry Mixon]

Another one.

 

[myrmidon009]

Here is v1.4.1. The major changes are as follows:

• Added a subsector map on the 'Input' tab. This shows all subsectors adjacent to the purchase sector, as well as all adjacent subsectors and their corresponding sectors.
• Updated lookups on 'Input' tab to filter system info based on system name and hex ID; updated lookups on 'Mapping' tab to filter system info based on subsector name and system name. (This should fix problems if there are multiple systems with the same name.)
• Updated jump distance calculations. (This should fix problems with the jump distance calculations.)

Thanks, as always, for the feedback!

 

[Terry Mixon]

I'll be giving this a test drive soon, but I want to suggest a minor tweak. The freight section on the Purchases tab has the Tons in Lots section overrunning the input area of the Tons Taken area. Perhaps swap them around?

 

[Terry Mixon]

I'll be giving this a test drive soon, but I want to suggest a minor tweak. The freight section on the Purchases tab has the Tons in Lots section overrunning the input area of the Tons Taken area. Perhaps swap them around?

View attachment 6585

In fact, all three of these might benefit from the third and fourth columns being switched.

 

[Terry Mixon]

Working a lot better but I did find one glitch. The tool shows Marilithe in the Diaspora Sector, but it doesn't exist there. It's in the Massilia Sector.

 

[Terry Mixon]

Found a second phantom system. Nobody isn't in the Diaspora Sector. Neither is Wawarbinner. However, it looks like ICA, Nape, and Mana are, though they don't show on the map. There are a lot of discrepancies and that's only on the course I selected. Diaspora has some real issues. I'm stopping my testing as I can't be sure what is really there.

 

[Terry Mixon]

Found a second phantom system. Nobody isn't in the Diaspora Sector. Neither is Wawarbinner. However, it looks like ICA, Nape, and Mana are, though they don't show on the map. There are a lot of discrepancies and that's only on the course I selected. Diaspora has some real issues. I'm stopping my testing as I can't be sure what is really there.

View attachment 6701View attachment 6702

It's been more than a month, so I thought I would poke this to see if you have any insight into this and maybe a fix for it somewhere in the pipeline. I appreciate the sheet, but Diaspora is unusable this way. It has the correct data listed for the systems, but the map in the sheet doesn't reflect that. I'd wager there are other sectors with the same issue that the fix for this could correct. Help!