MgT2 Ship Design Speadsheet Walk-through

Discuss the Traveller RPG and its many settings
Linwood
Lesser Spotted Mongoose
Posts: 718
Joined: Thu Jun 29, 2017 12:41 am

Re: MgT2 Ship Design Speadsheet Walk-through

Postby Linwood » Sat Sep 08, 2018 5:18 pm

I’m playing w/ building a space station this AM - nothing fancy, just a small orbital facility for traffic control and monitoring nearby space. I’m trying to add some docking clamps to store extra cutter modules but the spreadsheet doesn’t seem to account for the tonnage correctly - it seems to be subtracting the tonnage for the module as a whole (which makes sense for sizing jump drives and such) instead of just the tonnage for the clamps themselves.

Otherwise it’s pretty handy - nice job!
AnotherDilbert
Cosmic Mongoose
Posts: 4271
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: MgT2 Ship Design Speadsheet Walk-through

Postby AnotherDilbert » Sat Sep 08, 2018 6:35 pm

I think it is correct...

Image
In clamp: Only the clamp is deducted from interior space.
In hangar: lots of space deducted from interior space.
Cost is added either way.


Vessels held in clamps are not inside the hull, they are outside the hull and hence does not consume space inside the hull.

On the other hand drives have to be bigger.
HG, p43 wrote:Docking Clamp
A docking clamp allows a spacecraft to carry another vessel on the exterior of its hull, typically a small craft such as a ship’s boat or fighter. This permits a ship to carry auxiliary craft without consuming valuable interior space.

A ship’s Thrust and jump capability must be recalculated when another ship occupies its docking clamp, using the combined tonnage of both ships. This will likely mean the manoeuvre drive will be operating at a lower Thrust and the jump capability may be reduced.
HalC
Mongoose
Posts: 182
Joined: Wed Jan 10, 2018 3:42 pm

Re: MgT2 Ship Design Speadsheet Walk-through

Postby HalC » Sun Sep 09, 2018 1:07 am

I just downloaded the spreadsheet - and learned a few tricks that I'd not bothered to learn or lacked exposure to. The "custom" formating that you used in Cell A2 was an eye opener for me. Took a bit for me to realize that it was a less than zero, greater than zero, and equal to zero formating structure, but it works. NICE!

the other stuff with boolean logic, that was also nice. Multiplying by use of "If" statements where something had to be >= a value, and less than or equal to another (ie a range of numbers between low and high value) was also spiffy. A false result on either of the conditions results in a zero. Anything multiplied by zero is zero - which is a nice way around the =and(condition 1, condition 2) function in excel.

NICELY done.
AnotherDilbert
Cosmic Mongoose
Posts: 4271
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: MgT2 Ship Design Speadsheet Walk-through

Postby AnotherDilbert » Sun Sep 09, 2018 8:12 am

Thanks!

I generally find it easier to multiply by condition, rather than insert functions into the middle of formulas.
Jackstar
Weasel
Posts: 27
Joined: Sat Dec 29, 2018 11:42 am

Re: MgT2 Ship Design Speadsheet Walk-through

Postby Jackstar » Sun Jul 07, 2019 8:57 am

AnotherDilbert wrote:
Sat Sep 08, 2018 4:01 pm
New version:

Spreadsheet (same URL): https://www.dropbox.com/s/tidv4xqelrw2b ... .xlsx?dl=1


New functionality:
Each component has its own TL (by default ship's TL) to support refitted ships and user upgrades.
Pop-up turrets.




TL 12 ship with a TL 15 computer:
Image
Higher TLs marked in red to avoid mistakes...


Pop-up turrets are specified with a negative number in the #Wpn column, e.g. -2 for a pop-up double turret:
Image
Works for turrets and fixed mounts.
Hi AnotherDilbert,
when you posted a design for the special-operations ship, I realised that I don't have the latest version (I have v1.19). Is the quoted link still good for the latest?
AnotherDilbert
Cosmic Mongoose
Posts: 4271
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: MgT2 Ship Design Speadsheet Walk-through

Postby AnotherDilbert » Sun Jul 07, 2019 1:01 pm

Now it is...

There is no big difference, mostly bugfixes.
Jackstar
Weasel
Posts: 27
Joined: Sat Dec 29, 2018 11:42 am

Re: MgT2 Ship Design Speadsheet Walk-through

Postby Jackstar » Sun Jul 07, 2019 1:46 pm

AnotherDilbert wrote:
Sun Jul 07, 2019 1:01 pm
Now it is...

There is no big difference, mostly bugfixes.
Thanks. I find this extremely useful.

Do you have a guide to the advanced technolgy advantage options? For example, i am trying to get a Jump Drive with Stealth and Early Jump (for the Harrier from Pirates of Drinax). What numbers go in O33 and O44? (When I look at the formula, I can't see Early Jump anywhere.)
AnotherDilbert
Cosmic Mongoose
Posts: 4271
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: MgT2 Ship Design Speadsheet Walk-through

Postby AnotherDilbert » Sun Jul 07, 2019 2:17 pm

Sorry, I haven't implemented Early Jump.

Change the formula in cell H33 to

= G33*MAX( 10*(F33>0); OM( $K33=Tables!$A$84; Hull; DriveCapacity )*X33+5*(F33>0) )*( 1 + AD33 - 0 * 10%*(MAX(0;AH33)*(O33=0)) )
[change underlined and in red].

Then the size of the jump drive will not be changed, so you can allocate the advantages to anything else. Cell N33 is just informative, so you can type in anything there.


Default advantage for jump drive is Reduced Size. A positive value in cell O33 changes the advantage to Decreased Fuel. A positive value in cell P33 adds Stealth Jump (if there are enough advantages available).
Jackstar
Weasel
Posts: 27
Joined: Sat Dec 29, 2018 11:42 am

Re: MgT2 Ship Design Speadsheet Walk-through

Postby Jackstar » Sun Jul 07, 2019 3:45 pm

AnotherDilbert wrote:
Sun Jul 07, 2019 2:17 pm
Sorry, I haven't implemented Early Jump.

Change the formula in cell H33 to

= G33*MAX( 10*(F33>0); OM( $K33=Tables!$A$84; Hull; DriveCapacity )*X33+5*(F33>0) )*( 1 + AD33 - 0 * 10%*(MAX(0;AH33)*(O33=0)) )
[change underlined and in red].

Then the size of the jump drive will not be changed, so you can allocate the advantages to anything else. Cell N33 is just informative, so you can type in anything there.


Default advantage for jump drive is Reduced Size. A positive value in cell O33 changes the advantage to Decreased Fuel. A positive value in cell P33 adds Stealth Jump (if there are enough advantages available).
Thanks, Ii is a bit clearer now - you have automated some of the options that affect other things but not the other ones, like Early Jump, that are just functional.
ChalkLine
Weasel
Posts: 33
Joined: Sat Mar 23, 2019 5:41 pm

Re: MgT2 Ship Design Speadsheet Walk-through

Postby ChalkLine » Wed Jul 10, 2019 4:30 am

May I post a suggestion?:

I design some ships for players on the basis that not all the features are fitted at sale, and thus the price is different.

If you wish to implement this I suggest you have a 'Retrofit?' button on item. The button only charges 5% of the item's price but allots its tonnage.

(PS: thank you for having the standard air-lock on the spreadsheet. So many systems forget to allot its tonnage.)
AnotherDilbert
Cosmic Mongoose
Posts: 4271
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: MgT2 Ship Design Speadsheet Walk-through

Postby AnotherDilbert » Thu Jul 25, 2019 4:40 pm

Improved handling of Tech Advantages for drives and weapons:
Image

Any repeatable advantage/disadvantage can be specified as default to be applied as many times as allowed by current tech stage. A single additional advantage or disadvantage can be specified in the "Once" column and will be applied first it the current tech stage allows.

If you specify a negative value in column E you can specify prototype drives, but if a lower tech drive is selected you get as good a tech stage as the TL allows.
Examples:
Image
At TL-12 we have specified Tech Stage -9 and Jump-2. We get as good a Tech Stage as possible, which is Advanced with 1 advantage.

If we instead specify Jump-4 (which requires TL-13) we get stage Prototype with 1 disadvantage:
Image

If we specify a positive number in column E no prototype drives are used, but only drives allowed at the current TL.

If 0 (as it is by default) is specified no tech stage is used.
AnotherDilbert
Cosmic Mongoose
Posts: 4271
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: MgT2 Ship Design Speadsheet Walk-through

Postby AnotherDilbert » Thu Jul 25, 2019 4:50 pm

Weapons advantages are handled more simply:
Image

By specifying a positive number in columns O or P that many advantages/disadvantages are applied as Increased/Reduced Size or Energy Efficient/Inefficient respectively.

By default advantages are unspecified, e.g. Long Range or Accurate. Disadvantages are taken as Energy Inefficient.

Missiles and Torpedo weapons use Reduced or Increased Size instead.


Download link as usual: https://www.dropbox.com/s/tidv4xqelrw2b ... .xlsx?dl=1
Linwood
Lesser Spotted Mongoose
Posts: 718
Joined: Thu Jun 29, 2017 12:41 am

Re: MgT2 Ship Design Speadsheet Walk-through

Postby Linwood » Sat Jul 27, 2019 1:55 am

Oh good! I’ave been waiting / hoping for this improvement.... :)
AnotherDilbert
Cosmic Mongoose
Posts: 4271
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: MgT2 Ship Design Speadsheet Walk-through

Postby AnotherDilbert » Mon Apr 20, 2020 2:59 pm

Bridges simplified; types selectable from menu, number of bridges as desired:
Image
A reasonable bridge is defaulted. Copy and insert new rows if you need more types.


Residential and Commercial Zones removed as separate rows and added as generic accommodation options:
Image


Concealed compartments removed as separate rows and added as cargo options:
Image


By default a computer big enough for the most demanding software is dimensioned:
More software, bigger computer:
Image


Description enhanced to handle options better (or at all...):
Using a 100 Dton partially streamlined hull, it has performance of jump-2 and 2 g acceleration. There is fuel tankage of 21 Dton, enough for 4 weeks and jump-2.
The ship has a bridge with holographic controls. Adjacent to the bridge are a m/15 and a m/10 computer. The sensor suite include a civilian sensor.
There are three staterooms and three tons of common areas. There are six escape capsules, two briefing rooms, three libraries, and four tons of commercial zone.
Cargo capacity is 10 Dton. The ship requires a crew of three: a pilot, an astrogator, and an engineer. The ship costs MCr 52,5.

Bugfixes.


Download link as usual: https://www.dropbox.com/s/tidv4xqelrw2b ... .xlsx?dl=1
or more permanently at CotI.
User avatar
FreeTrav
Lesser Spotted Mongoose
Posts: 673
Joined: Wed Jun 18, 2008 3:46 am
Location: Greater NYC
Contact:

Re: MgT2 Ship Design Speadsheet Walk-through

Postby FreeTrav » Mon Apr 20, 2020 3:34 pm

Do me a favor, please... check out the short descriptions I use in Freelance Traveller's Computer Connection software lists. Write a similar short description of this spreadsheet, and email me (editor@freelancetraveller.com) the description and a permalink to the sheet. I'll add it to the software list...
Jeff Zeitlin
Editor, Freelance Traveller
The Electronic Fan-Supported Traveller® Magazine and Resource
User avatar
qstor
Banded Mongoose
Posts: 337
Joined: Fri Dec 26, 2003 10:54 pm
Location: Maryland
Contact:

Re: MgT2 Ship Design Speadsheet Walk-through

Postby qstor » Tue Apr 28, 2020 4:11 pm

have you done anymore ships? I'm looking for the 1000 Qasar scout ship from the t20 EPIC adventure 5?
"Hate is baggage. Life's too short to go around pissed off all the time" Edward Furlong - American History X
User avatar
paltrysum
Greater Spotted Mongoose
Posts: 828
Joined: Mon Mar 20, 2017 11:16 pm
Contact:

Re: MgT2 Ship Design Speadsheet Walk-through

Postby paltrysum » Mon Jul 06, 2020 4:11 am

AnotherDilbert wrote:
Thu Sep 06, 2018 2:14 pm
New version:

Spreadsheet: https://www.dropbox.com/s/tidv4xqelrw2b ... .xlsx?dl=1
Thank you for sharing it, AnotherDilbert. This will be very useful!
My published Traveller adventures on DriveThruRPG:
https://www.drivethrurpg.com/browse.php ... %20Griffen

Who is online

Users browsing this forum: No registered users and 34 guests