Traveller Trade Tool

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!
 

Attachments

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?

1763249615323.png
 
Last edited:
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.

1763843379821.png1763843448185.png
 
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.

1763865263214.png1763865290313.png
 
Terry Mixon said:
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
Click to expand...
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!
 
Sorry, no. I haven't had any time to work on it. In the meantime, I would recommend using travellermap.com as the source for your map. There is a link to that site in cell C35 on the 'Input' tab. It opens directly to the purchase system you have selected.

If I continue having difficulties, I may end up just removing the Excel map. The purpose of the file is to automate the trading process presented in the core rules. This it does (as far as I can tell). The Excel map is nice to have; however, it is not necessary to achieve the goal of the file. We already have an excellent and far better map at travellermap.com. Also, the Excel map has also made the file unstable and has been causing crashes recently, at least on my end. (Although my computer has been having other instability issues, so the file may not be the sole cause of the crashing.) If I figure out how to remove all the bugs, I will keep it; otherwise I may remove it to keep the tool as functional and focused as possible.
 
myrmidon009 said:
Sorry, no. I haven't had any time to work on it. In the meantime, I would recommend using travellermap.com as the source for your map. There is a link to that site in cell C35 on the 'Input' tab. It opens directly to the purchase system you have selected.

If I continue having difficulties, I may end up just removing the Excel map. The purpose of the file is to automate the trading process presented in the core rules. This it does (as far as I can tell). The Excel map is nice to have; however, it is not necessary to achieve the goal of the file. We already have an excellent and far better map at travellermap.com. Also, the Excel map has also made the file unstable and has been causing crashes recently, at least on my end. (Although my computer has been having other instability issues, so the file may not be the sole cause of the crashing.) If I figure out how to remove all the bugs, I will keep it; otherwise I may remove it to keep the tool as functional and focused as possible.
Click to expand...
Understood. Thanks. As long as the right systems show up as selectable, that would work
 
myrmidon009 said:
Sorry, no. I haven't had any time to work on it. In the meantime, I would recommend using travellermap.com as the source for your map. There is a link to that site in cell C35 on the 'Input' tab. It opens directly to the purchase system you have selected.

If I continue having difficulties, I may end up just removing the Excel map. The purpose of the file is to automate the trading process presented in the core rules. This it does (as far as I can tell). The Excel map is nice to have; however, it is not necessary to achieve the goal of the file. We already have an excellent and far better map at travellermap.com. Also, the Excel map has also made the file unstable and has been causing crashes recently, at least on my end. (Although my computer has been having other instability issues, so the file may not be the sole cause of the crashing.) If I figure out how to remove all the bugs, I will keep it; otherwise I may remove it to keep the tool as functional and focused as possible.
Click to expand...

The map is a fun little tool though.
 
hopsnbaer said:
That's kind of fun. Where is that tool to be found?
Click to expand...
Here on this very forum.

C

Thread 'Auto-Jimmy v0.9.4: X-Boat Routing Release'

I thought it was about time I got my ass in gear and pulled together another release of Auto-Jimmy. Not many new features this time around, most of my time since the last release has been spent reworking existing code to allow for some of the future features I have planned.

Release Highlights:
  • X-Boat Routing
    • The jump route planner can now plot paths that follow X-Boat routes between systems
    • X-Boat (Strict) will find the shortest-time route while following the official point-to-point X-Boat routes between systems
    • X-Boat (Loose) will find the shortest-time route but can...
  • Like
 
Terry Mixon said:
Here on this very forum.

C

Thread 'Auto-Jimmy v0.9.4: X-Boat Routing Release'

I thought it was about time I got my ass in gear and pulled together another release of Auto-Jimmy. Not many new features this time around, most of my time since the last release has been spent reworking existing code to allow for some of the future features I have planned.

Release Highlights:
  • X-Boat Routing
    • The jump route planner can now plot paths that follow X-Boat routes between systems
    • X-Boat (Strict) will find the shortest-time route while following the official point-to-point X-Boat routes between systems
    • X-Boat (Loose) will find the shortest-time route but can...
  • Like
Click to expand...
Thanks!
 
You must log in or register to reply here.

Similar threads

T
Borderland and the Traveller Map breaks Pirates of Drinax
Replies
6
Views
328
hopsnbaer
H
Coryphon
Roll20 - Traveller 2e Official Character Sheet - Updates
5 6 7
Replies
137
Views
12K
Coryphon
Coryphon
M
Digital Trade Map Generator
2
Replies
37
Views
4K
MasterGwydion
M
M
Traveller Map: API Data Interpretation
Replies
12
Views
896
Terry Mixon
Terry Mixon
Terry Mixon
An Expanded Speculative Trade Process that Uses Broker Like a Skill
Replies
19
Views
801
MasterGwydion
M
Back
Top