Excel Ship Designer

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

Re: Excel Ship Designer

Postby AnotherDilbert » Tue Jul 27, 2021 3:40 pm

Drive tab: Error message if check tonnage is smaller than hull tonnage:
Image

#SAKNAS means nothing found in VLOOKUP statement.
AnotherDilbert
Cosmic Mongoose
Posts: 4591
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Excel Ship Designer

Postby AnotherDilbert » Tue Jul 27, 2021 4:09 pm

I don't understand the power unused calculation?

The ship produces 440 000 Power, uses 400 000 Power, so -160 000 Power is unused?

Image
AnotherDilbert
Cosmic Mongoose
Posts: 4591
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Excel Ship Designer

Postby AnotherDilbert » Tue Jul 27, 2021 4:15 pm

If I add a backup M-drive unused power decreases further:
Image

Presumably we don't use the backup drive and the main drive at the same time?
AnotherDilbert
Cosmic Mongoose
Posts: 4591
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Excel Ship Designer

Postby AnotherDilbert » Tue Jul 27, 2021 4:23 pm

Power plant fuel not configurable:
4 weeks:
Image

20 weeks:
Image

Should be 2200 Dt for 4 weeks and 11000 Dt for 20 weeks.
AnotherDilbert
Cosmic Mongoose
Posts: 4591
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Excel Ship Designer

Postby AnotherDilbert » Tue Jul 27, 2021 4:26 pm

Varying format for tonnage, sometimes includes decimals, sometimes not:
Image
User avatar
Arkathan
Mongoose
Posts: 132
Joined: Wed Jun 30, 2021 9:39 pm

Re: Excel Ship Designer

Postby Arkathan » Tue Jul 27, 2021 4:39 pm

AnotherDilbert wrote:
Tue Jul 27, 2021 3:16 pm
Arkathan wrote: What size bay requires ten workers? This is similar to the problem I have with Cannonades.
Yes, it's completely undefined how you unload ships, and how long it takes. Presumably we are not using stevedores carrying sacks on their backs, hence the description of the loading belt doesn't help much.

But it has to be somehow related to the size of the cargo hold? I can't even suggest any specific number of loading belts, so I'm suggesting a configurable quantity of loading belts.
And that's why I suggest 10x 8000 ton bays, linked by partitions in the notes, representing as massive bay that can be broken up and has multiple hatches. Much like the hangars on modern aircraft carriers. When bad things are happening, there are three separate bays, otherwise there is one big one.

This is more an issue of fluff than game mechanics.
User avatar
Arkathan
Mongoose
Posts: 132
Joined: Wed Jun 30, 2021 9:39 pm

Re: Excel Ship Designer

Postby Arkathan » Tue Jul 27, 2021 4:40 pm

AnotherDilbert wrote:
Tue Jul 27, 2021 4:23 pm
Power plant fuel not configurable:
4 weeks:
Image

20 weeks:
Image

Should be 2200 Dt for 4 weeks and 11000 Dt for 20 weeks.
Well that's a WTH... it was working before and I don't think I touched it.
User avatar
Arkathan
Mongoose
Posts: 132
Joined: Wed Jun 30, 2021 9:39 pm

Re: Excel Ship Designer

Postby Arkathan » Tue Jul 27, 2021 4:44 pm

AnotherDilbert wrote:
Tue Jul 27, 2021 4:09 pm
I don't understand the power unused calculation?

The ship produces 440 000 Power, uses 400 000 Power, so -160 000 Power is unused?

Image
Unused is based off Max Load, which is 600K. The yellow just means you cannot power everything. Battle Load shows you can power what you need to use. But if you take one critical on power, you have to power down 4445 points of something.
User avatar
Arkathan
Mongoose
Posts: 132
Joined: Wed Jun 30, 2021 9:39 pm

Re: Excel Ship Designer

Postby Arkathan » Tue Jul 27, 2021 6:33 pm

Contrast:
Image

Better?

Power warning. Changed color. Tied one to Max Load and one to Battle Load.
Image
Found and fixed the weeks of fuel problem.

Found and fixed the out of range on B/U M-Drive
AnotherDilbert
Cosmic Mongoose
Posts: 4591
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Excel Ship Designer

Postby AnotherDilbert » Tue Jul 27, 2021 7:04 pm

Arkathan wrote: Contrast:

Better?
Certainly.
AnotherDilbert
Cosmic Mongoose
Posts: 4591
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Excel Ship Designer

Postby AnotherDilbert » Tue Jul 27, 2021 7:18 pm

Arkathan wrote: Unused is based off Max Load, which is 600K. The yellow just means you cannot power everything. Battle Load shows you can power what you need to use. But if you take one critical on power, you have to power down 4445 points of something.
I'm veering into opinion again, but civilian ships rarely need to power all drives at the same time, e.g. M- and J-drive. Normally you only need to power one drive at a time.

In extreme circumstances, e.g. battle, you can reduce Basic Ops power (hull) to half, saving a bit of power plant.

So, here:
Image
Normal load should be 400 000 Power, so unused 40 000 Power?
Combat load should be 350 000 Power?
AnotherDilbert
Cosmic Mongoose
Posts: 4591
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Excel Ship Designer

Postby AnotherDilbert » Tue Jul 27, 2021 7:44 pm

Tigress:
Image

Can't have three sensor systems:
Image

Can't have, say, an Advanced sensor (w arrays) and a backup Military sensor (w arrays), since the arrays are all based on the primary sensor.

If you added a quantity to the sensor and backup sensor, and added separate arrays for primary and backup sensors it would cover almost all cases?
AnotherDilbert
Cosmic Mongoose
Posts: 4591
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Excel Ship Designer

Postby AnotherDilbert » Tue Jul 27, 2021 7:58 pm

Array cost not multiplied by quantity:
Image

Compare:
Image
User avatar
Arkathan
Mongoose
Posts: 132
Joined: Wed Jun 30, 2021 9:39 pm

Re: Excel Ship Designer

Postby Arkathan » Tue Jul 27, 2021 8:16 pm

AnotherDilbert wrote:
Tue Jul 27, 2021 9:44 am
Crew calculation not appropriate for a small craft:

Hence accomodation listed as a problem:
Got over being crotchety and fixed it. Only the pilot should appear in the normal slots now for small craft. Use Custom for any other crew.
Round Down for Admin
Marines typed in Custom populate Civ and military, so you do not have to switch modes just for troops.
Also subtracting bridge seats from crew total on small craft.
1 for cockpit
2 for dual cockpit and small bridge
3 for standard and detachable
Note that this does not allow for scheduled passengers in an empty bridge chair, although in RP there is nothing to stop that... besides common sense...
Last edited by Arkathan on Tue Jul 27, 2021 8:58 pm, edited 3 times in total.
User avatar
Arkathan
Mongoose
Posts: 132
Joined: Wed Jun 30, 2021 9:39 pm

Re: Excel Ship Designer

Postby Arkathan » Tue Jul 27, 2021 8:19 pm

AnotherDilbert wrote:
Tue Jul 27, 2021 7:58 pm
Array cost not multiplied by quantity:
Fixed. Thanks.
User avatar
Arkathan
Mongoose
Posts: 132
Joined: Wed Jun 30, 2021 9:39 pm

Re: Excel Ship Designer

Postby Arkathan » Tue Jul 27, 2021 8:33 pm

I'm veering into opinion again, but civilian ships rarely need to power all drives at the same time, e.g. M- and J-drive. Normally you only need to power one drive at a time.
I use conservative numbers. I am from the school that has me freaking out when design capacity is less than 150% of what's needed.
Since those don't do anything but put color on the page, it's just an annoyance if you don't like nag warnings.
But it is more info.
I'll look into reducing the Basic part of the Battle Load, though... edit: done now, actually

Later, once the main sheet... works... I can, perhaps, look into figuring out how to set a dropdown to configure what setpoints the user wants on power warnings.
User avatar
Arkathan
Mongoose
Posts: 132
Joined: Wed Jun 30, 2021 9:39 pm

Re: Excel Ship Designer

Postby Arkathan » Tue Jul 27, 2021 9:30 pm

Tigress

Sensor QTY - Done, and you cannot put more than one free, no mass Basic Sensor on the ship.


Small craft partical barbette and any other weapon is back to .75x power again.
Will take some work to add in a pop-up turret, because forced dynamic validation tables... so maybe tomorrow.
User avatar
Arkathan
Mongoose
Posts: 132
Joined: Wed Jun 30, 2021 9:39 pm

Re: Excel Ship Designer

Postby Arkathan » Wed Jul 28, 2021 3:14 am

Working on fixing the small weapons turrets.

The smaller small weapons cost 1000 Cr per space to mount. I'm going with that for the larger ones.
The user will have to determine how many turrets they need and the number of spaces the weapons take up.
User avatar
Arkathan
Mongoose
Posts: 132
Joined: Wed Jun 30, 2021 9:39 pm

Re: Excel Ship Designer

Postby Arkathan » Wed Jul 28, 2021 4:46 am

Image

That one appears to be sorted now.
AnotherDilbert
Cosmic Mongoose
Posts: 4591
Joined: Wed Dec 23, 2015 2:49 pm
Location: Sweden

Re: Excel Ship Designer

Postby AnotherDilbert » Wed Jul 28, 2021 2:50 pm

Arkathan wrote: Also subtracting bridge seats from crew total on small craft.
1 for cockpit
2 for dual cockpit and small bridge
3 for standard and detachable
Seating for bridges are not defined, and I leave it undefined in my spreadsheet, but I assume two seats for a 3 Dt bridge. It's barely larger than a dual cockpit but contains room to move and better life-support.

A 6 Dt bridge should have "sufficient" seating for a small craft, perhaps four or so...

Who is online

Users browsing this forum: Google [Bot] and 57 guests