Traveller Trade Tool

[myrmidon009]

Some replies to Terry Mixon:

• I figured out what the strikethrough is. It's an Excel setting, not the tool. When calculations are set to manual, the strikethrough indicates that the formula in the cell is no longer up-to-date. That is okay in this case, as we want to control when the workbook recalculates formulas. If you want to recalculate a sheet or workbook, you can just use those commands on the 'Formulas' tab at the top.
• Great catch on the 'Sale Mod' formula! I've got that fixed for the next version.
• Also good catch on the starport data. I will get that updated. That may take a day or two. I'll have to write some code to do that.

Also, that's a pretty cool use of ChatGPT.

 

[Terry Mixon]

Some replies to Terry Mixon:

• I figured out what the strikethrough is. It's an Excel setting, not the tool. When calculations are set to manual, the strikethrough indicates that the formula in the cell is no longer up-to-date. That is okay in this case, as we want to control when the workbook recalculates formulas. If you want to recalculate a sheet or workbook, you can just use those commands on the 'Formulas' tab at the top.
• Great catch on the 'Sale Mod' formula! I've got that fixed for the next version.
• Also good catch on the starport data. I will get that updated. That may take a day or two. I'll have to write some code to do that.

Also, that's a pretty cool use of ChatGPT.

Thanks. I’ll hold off on further poking about until the next iteration comes out. It’s pretty cool. I feel the stirrings of a few suggestions but nothing firm enough to express yet.

 

[myrmidon009]

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

• Added some clarifications to the 'Instructions' tab.
• Moved the modding instructions to the 'Modding Instructions' tab, which is hidden. Added details and illustrations for clarity.
• Fixed the labels for freight on the 'Sales' tab.
• Corrected the formulas for the sale price mod on the 'Trade Goods' tab.
• Corrected the starport data on the 'System Info' tab.
• Added formulas and an example on the 'System Process' tab. The formulas were missing in v1.0.

Thanks to Terry Mixon for finding the errors and his suggestions.

 

[Terry Mixon]

Most excellent. I’ll look at it once I get back home.

 

[Terry Mixon]

On the Input tab, in the selling phase, it should say Sell on Black Market, not purchase.

 

[Terry Mixon]

On the Trade Goods tab, the sale DM includes the PC broker skill as an add but does not subtract the NPC broker skill. The same is true for purchases. Shouldn't it?

Also, illegals reference the broker skill rather than streetwise.

 

[Terry Mixon]

For the purchase DMs, you have this:



That is ORG Sell DM - ORG Buy DM - PC Broker Skill.

What it should be, I believe, is ORG Sell DM - ORG Buy DM + PC Broker skill - NPC Broker Skill.

The same for illegals but use streetwise.

Sell DMs need similar updating.