Ship Design Spreadsheet

Discuss the Traveller RPG and its many settings
AnotherDilbert
Cosmic Mongoose
Posts: 3281
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Ship Design Spreadsheet

Postby AnotherDilbert » Tue Mar 06, 2018 5:18 pm

Only change values in grey cells. Start with TL top left. Columns are added together at the top, green good and red bad. Empty space is allocated to Cargo.

Tech Advantages are input as numbers between -2 to +3 with 0 being Standard, -0.5 Budget. You get as good a advantage as can be achieved at the given TL, so you might not get exactly what you asked for. Only a few advantages are supported.

You should be able to get more Weapon and Screen rows by copying an entire row and inserting a new row. You can get more Mixed Turrets by inserting 4 new rows and copying the existing 4 rows.

If you need more rows insert entire rows, not just a few cells.

Red numbers means something is wrong...

Link:
https://www.dropbox.com/s/tidv4xqelrw2b ... .xlsx?dl=0
arcador
Banded Mongoose
Posts: 368
Joined: Sun Oct 11, 2015 10:34 pm

Re: Ship Design Spreadsheet

Postby arcador » Tue Mar 06, 2018 8:59 pm

It looks useful!

If I enter 6 armour, the HULL type changes from Light to Standard?
AnotherDilbert
Cosmic Mongoose
Posts: 3281
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Ship Design Spreadsheet

Postby AnotherDilbert » Tue Mar 06, 2018 9:31 pm

I assume that if you want Armour 6+ you want the hull points to survive combat. You can override this in cell C6; 1=Light, 2=Standard, 3=Reinforced.
arcador
Banded Mongoose
Posts: 368
Joined: Sun Oct 11, 2015 10:34 pm

Re: Ship Design Spreadsheet

Postby arcador » Wed Mar 07, 2018 9:33 am

You should allow bad designs :D

Thanks for the override info!
AnotherDilbert
Cosmic Mongoose
Posts: 3281
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Ship Design Spreadsheet

Postby AnotherDilbert » Wed Mar 07, 2018 6:39 pm

arcador wrote: You should allow bad designs :D
It's not a question of allowing, it's just a default...
AnotherDilbert
Cosmic Mongoose
Posts: 3281
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Ship Design Spreadsheet

Postby AnotherDilbert » Mon Apr 30, 2018 8:47 pm

Updated version with Fuel/Cargo Containers and Sub-Command Centres.

Same link:
https://www.dropbox.com/s/tidv4xqelrw2b ... .xlsx?dl=0
[/quote]

Who is online

Users browsing this forum: Moppy and 20 guests