GURPS Spaceships Design Spreadsheet

[Adelus]

Possible bug found - it seems some Reactionless drive systems and particularly the Ether propulsion methods don't list their move as their mps when the boost drive switch is on - they just show their acceleration. Using the latest sheet.

[ericbsmith]

Originally Posted by Yami Fowl

EDIT2:
What about what I said about turning off the Cosmic Power?
This #Value only happens when the Cosmic Power is checked on the checkbox.

Well, Cosmic Power and really, stupendiously large SM beam weapons - which would have been a useful tidbit to know, because when I saw it was only happening to the top couple SM's I knew exactly what the problem was - I only coded beam weapon output to 300 yota joules, and when you combine SM+40 with Cosmic Power you wind up with beam power in excess of 300 YJ. Knowing that I added code to handle up to 1x10^30 J of energy.

Originally Posted by Yami Fowl

I think I found it, the problem seem to be the SM and the table.
It works perfectly fine until SM+32.

I've no idea what's going on there, and it's working just fine for me. Beam weapons use a simple equation to extrapolate damage beyond 3 PJ of power; there is nothing special about the ZJ of energy compared to the PJ, EJ, or YJ.

Originally Posted by Adelus

Possible bug found - it seems some Reactionless drive systems and particularly the Ether propulsion methods don't list their move as their mps when the boost drive switch is on - they just show their acceleration. Using the latest sheet.

That would be because I didn't treat Ether propulsion systems as Reactionless drives, so Boost (or other Reactionless options) never got applied to them.

[ericbsmith]

Originally Posted by vicky_molokh

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

Design Table, second column of checkboxes (you may have to scroll right), 4th checkbox down.

Originally Posted by vicky_molokh

Is there a way to customize the price of wings?

Campaign Options. Third set of columns over, on the top is Weapons, below that are missile Warheads, then below that I snuck in a bunch of ship systems including wings. Simply apply an appropriate cost multiplier, which can be a decimal value (i.e. 0.001) to reduce cost.

[ericbsmith]

Version 1.34
-Fixed bug where damage of Really Freakin' Huge beam weapons would error out
-Ether drives are now treated as Reactionless for purpose of Boost option

See my first post for download links.

[Yami Fowl]

Originally Posted by ericbsmith

Well, Cosmic Power and really, stupendiously large SM beam weapons - which would have been a useful tidbit to know, because when I saw it was only happening to the top couple SM's I knew exactly what the problem was - I only coded beam weapon output to 300 yota joules, and when you combine SM+40 with Cosmic Power you wind up with beam power in excess of 300 YJ. Knowing that I added code to handle up to 1x10^30 J of energy.

Sorry for that, I should have informed...
Anyway it seems to be working fine now, I don't want to be annoying or anything, but Beam Damage for SMs +39 and +40 are still broken even without Cosmic Power.

But, up to there, it's working perfectly!

If I may, I'd like to point out also that Control Rooms of SM+40 ships do not show data underneath the System: Control Room.

[Adelus]

Another problem discovered: The campaign-wide cost multiplier seems to have no effect whatsoever in the 1.34 version for OpenOffice. Nor do the other cost multiplier options.

[vierasmarius]

Not a bug, but a question - is there a way to make reconfigurable systems? I was trying to write up an Ether Dragon, with wings that function as Ornithopter Wings in an atmosphere, and Powered Ether Sails in space.

[Daigoro]

I like that there are all these updates to the spreadsheet, but they're not very useful for a ship that I built on an older version. Is there an easy way to update an old sheet, rather than having to remake the ship each time there's an update?

It might involve some kind of variables export macro, but I have never tried anything like that with Excel.

[ericbsmith]

Originally Posted by Adelus

Another problem discovered: The campaign-wide cost multiplier seems to have no effect whatsoever in the 1.34 version for OpenOffice. Nor do the other cost multiplier options.

Actually, none of the Cost multipliers seem to be working for Ship Systems... that's annoying because I'm sure I had those working at some point.

Originally Posted by vierasmarius

Not a bug, but a question - is there a way to make reconfigurable systems?

No, there's not. Doing so proved too difficult to implement in the current sheet. I started a redesign of the sheet last January, and got Reconfigurable systems working but broke enough other stuff that I never got it finished off. Someday I'll get back to it.

Originally Posted by Daigoro

I like that there are all these updates to the spreadsheet, but they're not very useful for a ship that I built on an older version. Is there an easy way to update an old sheet, rather than having to remake the ship each time there's an update?

It might involve some kind of variables export macro, but I have never tried anything like that with Excel.

There's not really a way to do it, no. I'm not sure how I could implement such a thing easily, as every time I make changes, especially to the options checkboxes, things get moved around such that it would be very difficult to track what goes where.

[vierasmarius]

Originally Posted by ericbsmith

No, there's not. Doing so proved too difficult to implement in the current sheet. I started a redesign of the sheet last January, and got Reconfigurable systems working but broke enough other stuff that I never got it finished off. Someday I'll get back to it.

Fair enough. It should be relatively easy for me to just write up the ship in both configurations (using the handy extra ship entries provided) and use the Cost Modifiers to get the price right. Thanks for all your hard work! It's really an amazing tool.