Excel Traveller Trade

Arkathan

Cosmic Mongoose
Here's an early (mostly) working concept version of a Trade generator for Traveller.
I'm hoping to get other sectors added, and allow custom sectors, but right now it only does the Spinward Marches.
One big problem is that every time you enter anything into a field, it rerolls everything. For now, screen shots and pasting into a word processor will be your friend if you wanted to keep the generated list.

Hopefully someone finds this useful.

Update
2022.09.01 - Fixed issues with some planets. Added Freight lots for transport.
2022.09.02 - Added Passengers, Added Mail
2022.12.02 - Corrected Common Raw Materials base price.

Get it here


Screenshot1.pngScreenshot2.png
 
Last edited:

MyndkryM

Banded Mongoose
Dude...you keep on making REALLY good tools!!!!

I do hope that the powers that be recognize your work.
 

Arkathan

Cosmic Mongoose
Thanks!
Well, I make them for me. If someone else can use them, that's just gravy.
I started on this when my characters first rolled up a merchant ship in CharGen...
I put it aside when they decides they were NOT hauling cargo.
I slapped it together the rest of the way when they wanted to do escort duty and ran into that 800 ton patrol vessel in the custom ship section... and decided maybe they need some secure shipment contracts for extra cash.
 

Arkathan

Cosmic Mongoose
Used this in game last night. The players found a few bugs.
Those are fixed.
Added Freight

Screenshot3.png
 
Last edited:

JNJ

Banded Mongoose
Thanks for the tool ! Trying it...

I see that Aramis (the planet) is "Ni" in your Xls file. In Spinward Marches book it is "He Ni"
"He" is for HellWorld and doesn't seem to exist in the Trade codes in the Mgt2 Core rules on page 260, so it should probably be replaced by "De" for a final "De Ni"

Best,

Edited for clarity...
 
Last edited:

Arkathan

Cosmic Mongoose
I used the MgT2 Core U2022 trade codes to calculate the trade codes. none of the trade codes are manually entered.
So it only shows the ones listed in that book, and only if they meet the listed criteria.
Thanks for trying it. Let me know if it helps or if you find any errors.
 

JNJ

Banded Mongoose
I understand. What I mean is that Aramis is a desert planet and misses the "De" trade code which is in MgT2 Core U2022.

That said, it definitely helps !
 

Arkathan

Cosmic Mongoose
Desert is ATM 2-9.
Aramis is A(10), Exotic. It just also does not have water.
I'm chalking the De in the book up to the same sort of error that fits a TL 12 Power Plant on a TL 10 Shuttle for two iterations of HG. ;)

Glad you are finding it useful!
 
Last edited:

Arkathan

Cosmic Mongoose
Added Passengers. RAW indicates passengers are for one jump, so no passengers are calculated if your listed jump drive is lower than the destination distance. If you WANT multi-week passengers, calculated at the listed rate, just change your J-Drive to match distance in the form, and it will enable passengers.
Unless you find errors, this will be the last update until I add additional sectors.

2022.09.02



Screenshot4.png
 
Last edited:

Arkathan

Cosmic Mongoose
Excel Tip: You can stop the automatic random calculator each time you enter a number.
In the Ribbon, click Review and unprotect the Trade Goods sheet.
Next go to Formula on the Ribbon and look right until you see Calculation Options. Set it to Manual.
Now the numbers will not calculate until you want them to.
To roll the dice, Either go to the Formula/Calculation/ and click Calculate Sheet
-OR-
Press [Shift]-F9
 

agroschim

Mongoose
Amazing work, thanks for sharing!

Now to diminish what I just said by pointing out a potential typo: I think the base price for Common Manufactured Goods is set 200k cr instead of the 20k cr listed in the Core Rules.
 
Top