GURPS Spaceships Design Spreadsheet

[ericbsmith]

Originally Posted by vicky_molokh

[*]Is it me, or are the Boost Drives absent?

Yes, it's absent. However, I've been slowly working on another release and it's something I'll be adding now.

Originally Posted by vicky_molokh

[*]Is there a way to dedicate cargo (or at least cargo in the Weapon Batteries) to ammo?

Not currently. I'm not sure if I'll be adding this or not, however I have added a spot for User Notes where this could be specified.

Originally Posted by vicky_molokh

[*]The No Computer variant is absent too, right?

Page reference?

[vicky_molokh]

Originally Posted by ericbsmith

Page reference?

SS7-24, left column. Notable effects: penalized accuracy of weapons fire, and either total impossibility or -5 on PD fire. Some other bits too.

[ericbsmith]

Version 1.21
-Fixed a bug where ship systems weren't correctly shown in the drop down menus if the first and second ship in the sheet had different SM's

Version 1.22
-Fixed some bugs in the Cargo weight calculations
-Fixed the cost of Super FTL drives
-Fixed some bugs which prevented the 'Design Table' from being copied correctly ('Design Table' was supposed to be able to be copied allowing you to create all the ships for your campaign in a single spreadsheet).
-Changed the macros to hide the checkboxes when the row they reside in is hidden. This looks cleaner when using 'Hide Unused Rows.'
-Added buttons to hide either the top or bottom ship.
-When a ship system exceeds the TL of the ship a note is generated listing the items actual TL.
-Added Boost Drive option from SS7.
-Added No Computer option from SS7.
-Added User Notes section, where users may add notes or a short description of the ship.

See my First Post for more information.

[vicky_molokh]

When I build a plane with Jets and Turbofans, I get a top speed of 2k mph even if I use a profile with the turbofan turned off. Same trouble with Ornithopter wings.

Also, the smaller-/larger-sized system don't work and won't work, right?

[ericbsmith]

Originally Posted by vicky_molokh

When I build a plane with Jets and Turbofans, I get a top speed of 2k mph even if I use a profile with the turbofan turned off. Same trouble with Ornithopter wings.

Hmm, yeah, I'm not sure how I can fix that right now but I'll take a look at it.

Originally Posted by vicky_molokh

Also, the smaller-/larger-sized system don't work and won't work, right?

Unfortunately, yes. And without gutting the sheet and starting from scratch I can't think of how I can properly implement any smaller/larger systems, reconfigurable systems, or user created systems. I've got too much specialized code in the sheet to properly implement it, and I'm afraid that if I start tugging at the strings it'll unravel on me.

[vicky_molokh]

Originally Posted by ericbsmith

Hmm, yeah, I'm not sure how I can fix that right now but I'll take a look at it.

Is it possible to make the limit apply to specific performance profiles, and not to the global speed limit?

[ericbsmith]

Originally Posted by vicky_molokh

Is it possible to make the limit apply to specific performance profiles, and not to the global speed limit?

More than likely, yes. Shouldn't be too hard to do that once I get a chance to sit down and do it.

[vicky_molokh]

Originally Posted by ericbsmith

More than likely, yes. Shouldn't be too hard to do that once I get a chance to sit down and do it.

And as for custom systems, they can be implemented similarly to the way you did Boost Drives:
have (separate sheet) with cells named like this:

Custom Fuel-consuming Power Plant 1, cusom_price, custom_powerpoints, custom_endurance_base, custom_endurance_per_fueltank, custom_accel, custom_accel_air, custom_max_speed_air

Custom Reaction Drive, custom_price, custom_powerusage (defaults to 0, can be set to negative to produce PPs), custom_endurance_per_fueltank.

Custom Armor 1, custom_price, custom_dDR, custom_powerusage (default 0).

ETC.

And finally
Custom Miscellaneous System for those special cases

I suppose the big problem is making them have custom names - that seems like too much bother.

[ericbsmith]

The problem is, the way I've written the sheet a lot of the statistics for existing systems rely on looking at the name of the system. e.g. to count the number of Robot Legs a ship has it literally counts all systems named Robot Leg. This works fine for the standard system, but if you want to create a "Reconfigurable Robot Leg/Jet Engine" the sheet will squark and not count it as a Robot Leg. I've done this all over the place, for many different systems, and undoing it will be a mess. I hadn't planned on this becoming as big and complex as it is now when I started it or I'd have designed it differently; now I'm stuck with legacy issues. I may try to undo it at some point, but right now I have over 200 cells with complex formulas, many of which do this.

[vicky_molokh]

Top Deck seems to be missing - another option that seems simple to do unless legacy prevents it (just limit top speed).

Is there a way to customize the price of wings?