GURPS Spaceships Design Spreadsheet

[Mateus]

Great job! Looks very nice!

[TheScrivener]

I hope I'm not overlooking anything obvious, but I've fiddled about with this sheet (which is quite thorough and well laid out btw) and can't seem to figure out why it won't let me actually choose systems! The dropdowns for the individual system slots just show an endless series of #VALUE! entries and typing in names of systems manually results in the information below (armor dDR, cargo capacity, etc) autopopulating, but the "value you entered is not valid" box comes up every time! Actually copying the cell from the Campaign Options page onto the Design Table seems to do it, but this can't be what's intended. I'm using Excel '10, running macros enabled, trying to build a TL10^ SM +8 ship. Has anyone else had problems of this nature?

[TheScrivener]

And whaddaya know, saving and restoring the sheet a couple times seems to have fixed it! Macros working great, this is going to save me so much time...

[ericbsmith]

Originally Posted by TheScrivener

And whaddaya know, saving and restoring the sheet a couple times seems to have fixed it! Macros working great, this is going to save me so much time...

Huh... I'm not sure why it would have errored, or come back, but I'm glad it worked itself out for you.

[ericbsmith]

Originally Posted by TheScrivener

The dropdowns for the individual system slots just show an endless series of #VALUE! entries

Just found what was causing this. Turns out that if you uncheck the 'Use Rules from Spaceships 7' option the menu's will error.

Version 1.29
-Fixed bug where unchecking the 'Use Rules from Spaceships 7' option caused the menu's for ship systems to error out.

See my first post for download links.

[Democritus]

I'm having trouble accessing the files and your website.

[ericbsmith]

Originally Posted by Democritus

I'm having trouble accessing the files and your website.

My webserver seems to have crashed out for some reason. I'll see if I can get it working shortly.

[Democritus]

Originally Posted by ericbsmith

My webserver seems to have crashed out for some reason. I'll see if I can get it working shortly.

It works now. Thanks!

The spreadsheet looks nice. I'll have fun playing with it today. :)

[Democritus]

Where did you get information for SM+4 hulls? That size isn't listed in any of the charts in GURPS Spaceships.

EDIT: Nevermind. I see the rules listed in GURPS Spaceships 4, p. 38.

[congo]

When i open this document i choose TL (f.e. 9), SM (f.e. +10) and the first thing i do, i add habitats. I get an error message. In e2010 everything crashes, in open office version i get en error 502 in habitat modules (and i can't choose location of modules (all the locations are called error).