T5 Starship Design Spreadsheet V0.1

[Widda_AW]

T5 Starship Design Spreadsheet V0.2

My first attempt at a Starship Design Spreadsheet.

It is a work in progress and far from a finished product

The sheet is based on Falkayn's work from years ago, however it is a complete redo as I have been learning T5 over the last 4 weeks or so... Enjoy.
The ACS page has a Type A Free Trader as an example and Errata from V0.71 in integrated into the sheet.
Regards

Widda


T5_Starship_Sheet_V0.2.xlsx

 

[savage]

My first attempt at a Starship Design Spreadsheet.

Appreciated work. Thanks.
Did you include any potential errata changes or is it straight out of the book?

 

[Widda_AW]

Errata

I tried to incorporate the errata as I was going

A few bugs smashed and Ammo added.
T5_Starship_Sheet_V0.21.xlsx

Releasing it to the wild will certainly draw out all the bugs.
Ta.

Widda

 

[Ulsyus]

Design spreadsheet

Nice work, this seems to have the elements from the book.

I tried to design a ship with a lifting hull, but it didn't seem to like that as an option - have you noticed that before?

Additionally, I saw in the book a lack of detail about the number of crew required. I was planning on using the calculations from MT - your thoughts?

 

[Widda_AW]

Design spreadsheet

It has most of the elements from the book... I still have not added Pods and i'm not happy with the ships vehicles / hangar section yet...

The lifting hull limits your choices considerably however. As shown in the tables on pg-334 the only hull structure you can have is "Shell" and my sheet was incorrectly showing that the floatation hull upgrade was not possible rather than adding no benefit (fixed in new version below).

I have also added a Officer Stateroom - 3dt, 0.15Mcr and single occupancy. Helps with comfort levels
Also playing with ammunitions for missile and sand casters - missiles based on AIM-120 AMRAAM missiles at 152kg - 6 missiles per dt/ magazine.

As to crew, that is relative to the ship and its mission, whether it is private or military (funded), and what its max crew could be and still remain profitable, ie: A privately funded freighter may want armaments with crew to man them, plus armed guards - that would take away from cargo space for crew quarters, plus life support... which lowers profit.
On the other hand a govt/Corp funded ship could have access a whole lot more.
Hope that helps? makes sense?

Widda


T5_Starship_Sheet_V0.22.xlsx

 

[Widda_AW]

T5 Starship Design Sheet V0.30

I have added a Small Craft sheet to this version.
Adding Firmpoints to both SC and ACS, with a few bug fixes as well.

Firmpoints seem a bit over powered however: if you are going to fit a sandcaster turret to any ship you are better off swapping out 1 hardpoint for 3 firmpoints, ( quad turrets ) instead - that way you get 3x the defence using only 0.5dt extra space. Same for mining lasers. Also std ( turret mounted ) missiles ( thou range -1, S=6 ).

Some points to consider with cmbt - between vehicles, small craft and ships.
- Starship Fusion and Plasma require Barbette or bigger, where Small craft can't use them and vehicles can mount them in turrets.
- Starship Lasers can be mounted on Small craft in 0.5dt firmpoints 5km range ( R=6 ), but don't exist in vehicles?
- fighters are listed as range S=2, but considering they are small craft using firmpoints with a range mod -1 - should be S=1. Range increase bumps turret size back to 1.0dt - hardpoint.

Just some inconsistencies I have come across digging into the rules.

Consider a 10-20dt M-Carrier with quad firmpoint turret 0.5dt, lots of free armor, 4-6G M-Drive capable of self powered in system travel carrying 10-20 troops? At less than 20MCr.

Or 250 of them in an Armoured/Mech Inf division shooting at a ship?

T5_Starship_Sheet_V0.30.xlsx

 

[Reban]

I have added a Small Craft sheet to this version.
Adding Firmpoints to both SC and ACS, with a few bug fixes as well.

Firmpoints seem a bit over powered however: if you are going to fit a sandcaster turret to any ship you are better off swapping out 1 hardpoint for 3 firmpoints, ( quad turrets ) instead - that way you get 3x the defence using only 0.5dt extra space. Same for mining lasers. Also std ( turret mounted ) missiles ( thou range -1, S=6 ).

Some points to consider with cmbt - between vehicles, small craft and ships.
- Starship Fusion and Plasma require Barbette or bigger, where Small craft can't use them and vehicles can mount them in turrets.
- Starship Lasers can be mounted on Small craft in 0.5dt firmpoints 5km range ( R=6 ), but don't exist in vehicles?
- fighters are listed as range S=2, but considering they are small craft using firmpoints with a range mod -1 - should be S=1. Range increase bumps turret size back to 1.0dt - hardpoint.

Just some inconsistencies I have come across digging into the rules.

Consider a 10-20dt M-Carrier with quad firmpoint turret 0.5dt, lots of free armor, 4-6G M-Drive capable of self powered in system travel carrying 10-20 troops? At less than 20MCr.

Or 250 of them in an Armoured/Mech Inf division shooting at a ship?

T5_Starship_Sheet_V0.30.xlsx

As I understand it from an early draft of T5 the intention was to allow you to drop a 1dton ACS turret into a 1dton VehicleMaker weapons mount. I'd even allow smaller vehicles to mount barbettes by using multiple weapons mounts to accommodate them.

The balance to this is that the vehicle or smallcraft should require sensors to acquire a target at the range of the weapons system.

Overall you're right though the interaction between ACS weapons and GunMaker weapons and their various mounting options needs a little clarification.

 

[Ulsyus]

Great stuff Widda. v3.0 works well, but I had to add drop-down menus for the turret and other weapon mounts, they seem to have dropped off from the earlier versions.

 

[Widda_AW]

Bizarre

Great stuff Widda. v3.0 works well, but I had to add drop-down menus for the turret and other weapon mounts, they seem to have dropped off from the earlier versions.

Strange? I'm only using data validation lists which should be excel version friendly.
the turret list should change relative to the weapon choice thou.

I downloaded the file and tested it and the lists worked fine! What version of excel are you using?

Widda

 

[Ulsyus]

Oh, I tried it out at work while I was having a cuppa , and we only run 97-2003 there. I just had to re-designate the array in the data validation and it worked fine again.

 

[Ulsyus]

Widda, on your spreadsheet in the Life Support section rows 93-97, when you refer to "days life support", is that man-days (or if you really want person-days or we could go so far as sophont-days) or some other measurement?

 

[Widda_AW]

Life support.

Widda, on your spreadsheet in the Life Support section rows 93-97, when you refer to "days life support", is that man-days (or if you really want person-days or we could go so far as sophont-days) or some other measurement?

Following the BBB it is for 10 people - 1t = standard life support for 10 people for 30 days (pg 344 ).

I have been scratching my head to a better way of doing it - was thinking of adding the crew and formulating the number of days relative to a full crew / passenger or separating into crew and passenger or a separate box for total people ( humans ) onboard to calculate from! Unfortunately I haven't liked the options that I have tried any better than the default - let me know if you have any better ideas?

Widda

 

[Ulsyus]

Following the BBB it is for 10 people - 1t = standard life support for 10 people for 30 days (pg 344 ).

I have been scratching my head to a better way of doing it - was thinking of adding the crew and formulating the number of days relative to a full crew / passenger or separating into crew and passenger or a separate box for total people ( humans ) onboard to calculate from! Unfortunately I haven't liked the options that I have tried any better than the default - let me know if you have any better ideas?

Widda

Thanks, got it. I've modified the spreadsheet so that it gives a number of days of life support based on the number of pers the ship can carry, both crew and passengers. You could work it out all the ways you mentioned, but a vessel would more likely be rated for a number of days based on a full complement. Let me know what you think...