GURPS Spaceships Design Spreadsheet

[vierasmarius]

Oh, there seems to be a bug where a couple other design/display options cause errors in certain fields. At least for ships with large HP totals (>1000) selecting "Use Shortened Numbers" changes the dST/dHP to #VALUE! Additionally, the Self-Healing / Regeneration switch changes the entire Notes field to #VALUE! when activated. (If you couldn't tell, I'm building a Borg Cube)

[ericbsmith]

Version 1.35
-Fixed bug where Cost Multipliers in the Campaign Options weren't working for Ship Systems
-Fixed bug where Use Shortened Numbers would cause a #Value error in dHP/dST and Notes
-Added Burn Points and Thrust Rating to Space Performance profiles
-Added Torpedo Tubes to the Weapon mount choices; added Torpedoes as 'missile' option

See my first post for download links.

[Adelus]

Another minor bug: Uninstalled Weapon Batteries do not seem affected by cost modifier. Using a modifier of x0.15, an uninstalled Secondary battery at SM7 still subtracted -$150k from the price instead of the more expected $22500.

[ericbsmith]

Originally Posted by Adelus

Another minor bug: Uninstalled Weapon Batteries do not seem affected by cost modifier. Using a modifier of x0.15, an uninstalled Secondary battery at SM7 still subtracted -$150k from the price instead of the more expected $22500.

You're using OpenOffice, aren't you? I'm guessing this is a case of OO and Excel doing things differently.

[Adelus]

Yeah, I am. Other than that I haven't found any new issues, though I'm still trying to put it through its paces.

[Adina]

Couple of questions (on things I can't seem to find):

How do I reduce the number of control stations in a control room? I see a box for this but I can't get it to actually do anything.

Is the option to replace a system with three sytems of the next smallest SM exist? If it does, how do I access it?

Jeff

[vierasmarius]

Originally Posted by jmurrell

Couple of questions (on things I can't seem to find):

How do I reduce the number of control stations in a control room? I see a box for this but I can't get it to actually do anything.

When you enter a positive integer in that box, it's subtracted from the number of control stations. So for example, to reduce the number of stations in a SM +10 ship from 10 to 7, enter '3' in the box. It will read 'Reduced Control Stations: 3', and the Control Room system will list 7 stations instead of 10. It also automatically adjusts the cost.

Is the option to replace a system with three sytems of the next smallest SM exist? If it does, how do I access it?

Jeff

Sadly, at this time that isn't an option. I look forward to when Eric figures out a fix for that, along with reconfigurable systems.

[Adina]

Originally Posted by vierasmarius

When you enter a positive integer in that box, it's subtracted from the number of control stations. So for example, to reduce the number of stations in a SM +10 ship from 10 to 7, enter '3' in the box. It will read 'Reduced Control Stations: 3', and the Control Room system will list 7 stations instead of 10. It also automatically adjusts the cost.

Ah, I was doing it wrong then. I kept trying to find the checkbox or dropdown menu. Got it now.

Sadly, at this time that isn't an option. I look forward to when Eric figures out a fix for that, along with reconfigurable systems.

That makes (at least) two of us.

Jeff

[Daigoro]

Originally Posted by ericbsmith

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.

Have one sheet as an echo of input variables? Is it a feature that could be worked into the 2.0?

[ericbsmith]

Originally Posted by Adelus

Another minor bug: Uninstalled Weapon Batteries do not seem affected by cost modifier. Using a modifier of x0.15, an uninstalled Secondary battery at SM7 still subtracted -$150k from the price instead of the more expected $22500.

Originally Posted by ericbsmith

You're using OpenOffice, aren't you? I'm guessing this is a case of OO and Excel doing things differently.

Originally Posted by Adelus

Yeah, I am. Other than that I haven't found any new issues, though I'm still trying to put it through its paces.

OK, I've updated the OpenOffice version of the sheet which should fix this bug.