Re: GURPS Spaceships Design Spreadsheet
 

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

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

Re: GURPS Spaceships Design Spreadsheet
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

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?

Re: GURPS Spaceships Design Spreadsheet
 

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.


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)

Re: GURPS Spaceships Design Spreadsheet
 

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)

Re: GURPS Spaceships Design Spreadsheet
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

The drop down menu is empty.

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

Re: GURPS Spaceships Design Spreadsheet
 

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