GURPS Spaceships Design Spreadsheet

[vierasmarius]

Originally Posted by ericbsmith

Version 2.00 Beta 1
This version represents a considerable overhaul of the spreadsheet. One of the primary goals of this overhaul was to make it feasible to incorporate Smaller SM Systems and Reconfigurable Systems. Other goals were to redesign the GUI streamlining the Design Table to do away with the Vertical Scrolling. A side effect of this was to eliminate the second ship.

YES YES YES! Oh, you have made me so happy... Hopefully the macros will work with my Open Office.

[ericbsmith]

Originally Posted by vierasmarius

YES YES YES! Oh, you have made me so happy... Hopefully the macros will work with my Open Office.

The Refresh Rows button should work, as I've tested it and it works fine. You'll probably have to adjust security settings to allow Macros in your save folder (which is true for Office 2007 as well)

If not you can manually unhide rows, but that gets annoying, which is why I like macros :-)

[vierasmarius]

Originally Posted by ericbsmith

The Refresh Rows button should work, as I've tested it and it works fine. You'll probably have to adjust security settings to allow Macros in your save folder (which is true for Office 2007 as well)

If not you can manually unhide rows, but that gets annoying, which is why I like macros :-)

Yeah, I remember with the prior version that the Macros didn't seem to work. Where do I find the security settings, and is there a particular setting that works best?

[ericbsmith]

Originally Posted by vierasmarius

Yeah, I remember with the prior version that the Macros didn't seem to work.

That's because Excel Macros don't work in OpenOffice, and in the previous version I hadn't bothered to convert/rewrite the Macros over. I may be adding a few more Macros in the future, but right now I'm most worried about getting things working before I worry about getting them tweaked out.

Originally Posted by vierasmarius

Where do I find the security settings, and is there a particular setting that works best?

Tools -> Options -> OpenOffice.org (left pane menu section) -> Security (menu sub-section) -> Macro Security (Button) -> Trusted Sources (Tab)
In the bottom section click Add... and add the folder in which you've saved the Spreadsheet to the Trusted Locations.

[ericbsmith]

Just uploaded Version 2.0 beta 2, which addressed at least 4 different errors I found. Still need some feedback...

[vierasmarius]

Originally Posted by ericbsmith

Tools -> Options -> OpenOffice.org (left pane menu section) -> Security (menu sub-section) -> Macro Security (Button) -> Trusted Sources (Tab)
In the bottom section click Add... and add the folder in which you've saved the Spreadsheet to the Trusted Locations.

Ah, thanks a bunch, that worked.

Originally Posted by ericbsmith

Just uploaded Version 2.0 beta 2, which addressed at least 4 different errors I found. Still need some feedback...

I'm trying out a build I've had in mind for a while (a transformable Mecha). I'll let you know how it goes.

Oh, quick question. How easy is it for a user to go in and adjust tables? For example, I've got alternative missile stats I'm toying with for Space Opera settings. Is it possible to just alter the projectile table? Likewise for folks using the Square-Root based Beam damage or dHP tables from Pyramid 3/34.

[ericbsmith]

Originally Posted by vierasmarius

Oh, quick question. How easy is it for a user to go in and adjust tables? For example, I've got alternative missile stats I'm toying with for Space Opera settings. Is it possible to just alter the projectile table?

It all depends on what you're adjusting, and how many special rules exist about that system, but in theory most Systems and Weapons can be altered witout too much trouble. The biggest problem is in dealing with future sheet updates. The Weapons are stored in a hidden sheet called Weapons, and systems in one called SystemsV2.

Originally Posted by vierasmarius

Likewise for folks using the Square-Root based Beam damage or dHP tables from Pyramid 3/34.

This I will probably incorporate into the sheet at some point in the future as it's an official "unofficial" rule.

[vierasmarius]

Originally Posted by ericbsmith

This I will probably incorporate into the sheet at some point in the future as it's an official "unofficial" rule.

Oh, excellent! So all I have to do is get my houserules published in Pyramid or in their own book, and you'll do the work for me. ;)

[vierasmarius]

Okay, I think I found a bug. When a ship has both ground and air/space propulsion, it's not showing its ground perfomance on the stat line. Remove the aerospace drive and the Ground performance displays correctly. At first I thought this was an issue with the Reconfigurable Systems (ie, having different propulsion types in both slots of a RecSys) but it does the same when they are in different system slots. It seems to do it with any ground propulsion (legs, tracked, wheeled, etc) and any space-capable drive. It's not doing it with air-only drives, such as Helicopter rotors. There, it displays both Air and Ground performance. So I suspect it has to do with displaying 3+ performance types. For example, Flexibody propulsion correctly displays ground and water performance; add a Helicopter rotor and the water stats are replaced by air.

Oh, this also led me to notice another bug. Jet propulsion is incorrectly being added to Space performance.

Hope this helps!

[ericbsmith]

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

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.