GURPS Spaceships Design Spreadsheet

[Humabout]

Just wanted to mention that I unprotected this sheet to look at its guts and see if I could tweak it to my weirder campaign needs (added in TL progressions for some superscience stuff, changed some power outputs/requirements, etc.) and I gotta say wow!

I knew this sheet had to be pretty complicated to do what it does but holy cow! Truly amazing work, Eric. Thank you so much for going through all of that trouble.

[davester65]

Originally Posted by ericbsmith

I'm not seeing this at all, so aside from the possibility of this being a regional setting issue I can't even guess why this would be happening without a lot more specifics.

Unfortunately I'm going to be out of town for a couple days, so I won't get back to this for a while.

If it's any help the message shows up when I select the designs SM and after that none of the other usual info shows up in that field.
BTW, I'm using Open Office. I'll check an earlier version of the spreadsheet to see if it has the problem. If it does, it's probably a problem with open office.

[Humabout]

I've got a question about the newest (I think) version. Is the Defensive ECM (Missile Repulsor) system you have available RAW, and if so, where is it, because I can't find it for the life of me.

[ericbsmith]

Originally Posted by Humabout

I've got a question about the newest (I think) version. Is the Defensive ECM (Missile Repulsor) system you have available RAW, and if so, where is it, because I can't find it for the life of me.

That system is part of Rev. Pee Kitty's Traveller Rules, and only show sup if you click the option to use RPK's rules.

[Humabout]

Ah, cool. Thanks.

[Yami Fowl]

Hi,

I'd like to know if this was pointed out:

Whenever I put a hangar bay on any ship SM+17 or more, it gives out "ERROR" and pops up a "Run-time error 13: Type mismatch"

Thanks for the support!

[ericbsmith]

Originally Posted by Yami Fowl

I'd like to know if this was pointed out:

Whenever I put a hangar bay on any ship SM+17 or more, it gives out "ERROR" and pops up a "Run-time error 13: Type mismatch"

Not only am I unable to reproduce that error, but the Run-time error itself suggests a problem with the program, not the spreadsheet. That is, I think there may be a problem with your install of Excel (or OpenOffice); you may want to do a Repair install or Uninstall then Reinstall to see if the error can be fixed.

And this is where I give my standard disclaimer that this could possibly being caused by incompatibilities with your Windows Regional Settings.

[Yami Fowl]

Originally Posted by ericbsmith

And this is where I give my standard disclaimer that this could possibly being caused by incompatibilities with your Windows Regional Settings.

Precisely.

I just changed the overall setting of my Windows to English (USA) and it worked perfectly fine. Thanks!

[Tzeentch]

The sheet does not appear to be handling the altered steerage cargo values for the life support options - it uses 5 tons no matter what?

[ericbsmith]

Originally Posted by Tzeentch

The sheet does not appear to be handling the altered steerage cargo values for the life support options - it uses 5 tons no matter what?

I believe I did that on purpose; rather than providing less cargo capacity they take up more slots. If you want smaller steerage cargo you can take the 'Steerage Cargo: Partial' component instead.