GURPS Spaceships Design Spreadsheet

[vierasmarius]

Originally Posted by ericbsmith

There's actually hidden rows in there with room for 5 lines/10 Performance values. Refresh the Rows and they should show up.

Ah, I see, that makes sense. I'll need to remember to hit that "Refresh" button as often as I do on Facebook...

The Jet, of course, is an annoyance. If you manually assign Air and Space Profiles then that won't happen; I'll have to see about correcting the automated behavior though.

Oh, so that's what that extra table is for. =P

[ericbsmith]

Originally Posted by vierasmarius

Ah, I see, that makes sense. I'll need to remember to hit that "Refresh" button as often as I do on Facebook...

Alternatively, you can check the "Show All Rows" box while you're designing the ship then uncheck it, and check "Hide Unused Rows" if desired, when done.

I am looking into getting that Macro to behave automatically in OpenOffice - has something to do with creating a Listener and Events Macros, but so far my attempts have been unsuccessful.

[vierasmarius]

Originally Posted by ericbsmith

Alternatively, you can check the "Show All Rows" box while you're designing the ship then uncheck it, and check "Hide Unused Rows" if desired, when done.

I am looking into getting that Macro to behave automatically in OpenOffice - has something to do with creating a Listener and Events Macros, but so far my attempts have been unsuccessful.

Ah, I see.

Oh, one more thing (not sure if it's a "bug" per se). If a Robot Arm is placed in one slot of a Reconfigurable System, you don't get the option to designate a Major Weapon Battery as Handheld.

[Daigoro]

I've had a quick fiddle, and things seem to run smoothly, as you already well know.

There are a couple of bugs and tweaks for you though-
1) Bug: Umm... no, nevermind, my fault.
2) Tweak: An invalid action turns the cell black, which is ok, although it can take some guesswork to figure out the problem, but could the text be displayed as white so we can still read the cell?

And have you figured out how to implement carrying a ship design across updates of the spreadsheet? Would a "ship data" tab which just outputs all the input variables for a copy and paste work?

I was going to ask about user-made items, but I see there's a Custom Systems tab, so I'll have to play with that later. Can it handle custom Habitats though? Or do they have to be put in the Habitats tab?

[ericbsmith]

Originally Posted by Daigoro

And have you figured out how to implement carrying a ship design across updates of the spreadsheet? Would a "ship data" tab which just outputs all the input variables for a copy and paste work?

Not really. This would essentially have to be carried out with a Macro, which would have to be tailored one for Excel and another for OpenOffice.

Originally Posted by Daigoro

I was going to ask about user-made items, but I see there's a Custom Systems tab, so I'll have to play with that later. Can it handle custom Habitats though? Or do they have to be put in the Habitats tab?

Not implemented yet, although it's something I'm planning on doing eventually. There are a lot of things I'd like to do eventually though...


P.S. uploaded Beta 3, which adds Square Root of Destruction and a working Core Macro to the OpenOffice sheet (which doesn't work quite the way I want - sometimes it seems the Macro gets ahead of the sheet calculations, so all the rows don't always show when they should, but they will the next time you change the sheet)

[ericbsmith]

Version 2.00 Beta 5

Continuing bug fixes, too many to mention.




Excel 2000
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (1.86MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (771KB)

Excel 2007
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (2.30MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (2.23MB)

OpenOffice 3.3.0
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (1.61MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (1.37MB)

[Flyndaran]

Love the program.
Is there some way to use the rule that mana/psionic engine only powered high energy modules get the 50% cost reduction? I can't find it if it's already in the awesome program.

[vierasmarius]

Originally Posted by Flyndaran

Love the program.
Is there some way to use the rule that mana/psionic engine only powered high energy modules get the 50% cost reduction? I can't find it if it's already in the awesome program.

It's there! On the table where you can select various options for your ships systems (modular, open-frame armor, performance profiles, etc) you can set the Power Source.

[Flyndaran]

Originally Posted by vierasmarius

It's there! On the table where you can select various options for your ships systems (modular, open-frame armor, performance profiles, etc) you can set the Power Source.

The drop down menu is empty.

Edit: whoops my mistake. I see it now. Thanks very much.

[Flyndaran]

Oh poop. Now I can't figure out how to get maneuver enhancement to register on the stat lines.