Traveller Trade Tool

[Terry Mixon]

I found the subsector listings on the mapping tab. Thanks for pointing it out.

It still wasn't as useful for my brain in seeing where I was changing subsectors, so I made an addition that I think others might find useful. Just tables that point at the appropriate spots in the data you provided, but a quick visual of what is above/below/beside the place you are.

 

[myrmidon009]

I found the subsector listings on the mapping tab. Thanks for pointing it out.

It still wasn't as useful for my brain in seeing where I was changing subsectors, so I made an addition that I think others might find useful. Just tables that point at the appropriate spots in the data you provided, but a quick visual of what is above/below/beside the place you are.

In case didn't see them, there are actual maps on the 'Mapping' tab over in columns X and AC for the purchase sector and sale sector, respectively.

 

[Terry Mixon]

In case didn't see them, there are actual maps on the 'Mapping' tab over in columns X and AC for the purchase sector and sale sector, respectively.

I didn't see them. Too much data. That's why I made the ones I did and then relocated them under the map on the input tab. I needed the data where I wanted to enter things and not where they were at. Thanks for point them them out, though. I had no idea they were there.

On the input tab, I now have this.



And the changes you made seem to let me do what I need to on the purchase and sales tabs. Thanks.

In case these might be useful additions for others, I added a % of Buy column on the Sales tab to show which are the best deals. I used the color coded highlighting to show it more clearly.



On the Sales tab, I added three columns: One to show what the product was purchased for (yes, I know they might be holding over some cargo, but that seems to be the exception rather than the rule), % of Purchase, and Profit / Ton. Those make it much clearer what could be sold at the best profit and you can see the data on one tab.



Thanks again for the great tool and listening to me whine as I break things.

 

[Terry Mixon]

For held over cargo, on the sale tab, one could simply enter the other purchase price in the appropriate cell and the add-ons I made will still work perfectly. Same for tonnage. Problem solved and new stuff still can be used.

 

[Terry Mixon]

On the Purchases tab, I also added a Discount column to show at a glance how much is saved on a potential purchase. I think all of these tweaks add functionality, so I urge you to consider adding them for everyone. I also changed % of Buy to % of Base Price as that was what it was. Also changed % of Purchase to % of Purchase Price.

 

[mavikfelna]

Can I request some functionality additions?
I'd like a drop-down or text box option to change the standard step in price adjustment for the broker roll. Being able to choose between 1 through 5% for purchase or sale would be good. I see the regular chart has bigger jumps at the extreme ends and maybe just override those if the default value is changed?
Also, can we get the option to add things like tariffs, duties or other fees for buying and selling? Especially illegal ones, since you'll have to find a buyer and that probably includes bribes, fines and other administrative fees to move those goods?

 

[Terry Mixon]

For those that might be interested in the alterations I made.

On the Sales tab, I added three columns. First, it shows the purchase price, so you don't have to guess or switch tabs. Second, it shows the percent of purchase price so you can see how the trade would go at a glance. Lastly, it shows the profit per ton so you can get an absolute idea of how you did without a calculator.

If you've held a cargo over because you couldn't get a good price, you can change the purchase price to what you paid in that column on the Sales tab and it will get cleared out when new cargo is generated.

The additional columns on the Sales tab meant that I needed to move some things around so that they were still visible to the right. They still work exactly as before.

This version has been modified by me to add additional functionality. There is a spot on the Input tab that displays the layout of the subsectors, so you don't need to struggle when crossing a boundary.

Additionally, I added two columns to the Purchases tab to show the percentage of discount from the base price and the actual amount that would be saved.

I hope these changes enhance your experience with this tool. Enjoy!

 

[Terry Mixon]

Found a hex distance glitch. Should be 2, shows 1.

 

[Terry Mixon]

Found a bad bit of data. Going from Mallory to Orichalc:



The dropdown has it across the sector. Nothing in that hex, by the way.



Looks like it found a system by that name in the Massilia sector and used its hex number. It probably needs more robust sector validation.

 

[myrmidon009]

Can I request some functionality additions?

Right now my main goal is having a tool for the trade rules from the Core Rulebook. The two you mentioned (finetuning the price tables and tariffs) are outside of that scope. I want to stay focused on getting the core trade rules working. Of course feel free to make any mods you like!

For those that might be interested in the alterations I made.

User mods are great!

Found a hex distance glitch. Should be 2, shows 1.

Hm... I'll have to dig more into the equations. The math worked out for all of the checks I did. If anyone has any thoughts on how to improve the calculation, feel free to share them. It's stretching me a bit.

Looks like it found a system by that name in the Massilia sector and used its hex number.

Agh! There are systems with duplicate names!? I had assumed system names were unique. I wonder how many there are...

Getting this up and running took a lot of my limited free time. I've got a lot of things to get to, so it will probably be quite a while for me to get updates done. However, I will be checking this and building a list of bugs and other things to incorporate or fix. Feel free to shoot me a message or list any of them here. Happy trading!

 

[Arkathan]

Yeah, several Spinward Marches systems in the Traveller Map site ask which Sector you want, because the names do repeat.
There is an Olympia in three sectors. I would have expected more systems with that name, actually.

 

[Terry Mixon]

Right now my main goal is having a tool for the trade rules from the Core Rulebook. The two you mentioned (finetuning the price tables and tariffs) are outside of that scope. I want to stay focused on getting the core trade rules working. Of course feel free to make any mods you like!


User mods are great!


Hm... I'll have to dig more into the equations. The math worked out for all of the checks I did. If anyone has any thoughts on how to improve the calculation, feel free to share them. It's stretching me a bit.


Agh! There are systems with duplicate names!? I had assumed system names were unique. I wonder how many there are...

Getting this up and running took a lot of my limited free time. I've got a lot of things to get to, so it will probably be quite a while for me to get updates done. However, I will be checking this and building a list of bugs and other things to incorporate or fix. Feel free to shoot me a message or list any of them here. Happy trading!

I don’t have a clue about the maths. Names? Yeah, there are a number of duplicates. You almost have to verify the sector to be sure you have the right one.

 

[Terry Mixon]

A ledger designed to work in conjunction with the Trade Tool in the files area, but completely useful when used without it. It has a few non-RAW options built in (taxes and one step of improvement for off port trade to encourage ADVENTURE!) but they are controlled by checkboxes and do not need to be used.

 

[Terry Mixon]

Found another place the calculations for hex distance failed. Perhaps having more than one will help figure out the maths.

 

[Terry Mixon]

I've been wandering around the Solomani Rim, Aldeberan, and Neworld sectors. It seems to work well, but I have run into half a dozen worlds that aren't actually in the sectors and that has been problematic. If I could ask for any one thing to update, it would be sector validation for the worlds before they get added to the list. That would be a big help.