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?