GURPS Spaceships Design Spreadsheet

[vicky_molokh]

Originally Posted by ericbsmith

Mostly, yes. I see a few spots of incompatibility, which I plan on addressing once I get most of the additions I've added working in Office. The only thing I probably won't port over anytime soon is the Macros.

What Divergent and Paranormal support is missing? In the v1.19 beta's I've added all the systems from SS7, including the Divergent and Paranormal ones. I had an idea of how to improve the Divergent TL handling (right now it's simply treated as just TL7, which I don't like).

OK, will look over the beta in more detail.

[ericbsmith]

Posted Version 1.19J (still in beta)

http://gurpsland.no-ip.org/zip/Spaceships119.zip

http://gurpsland.no-ip.org/zip/Spaceships119.7z

Major updates this version include:
-Implementation of Performance Profiles. You can now assign each engine to one of two Air or two Space profiles for calculating Accel, Speed, Hnd/SR, Delta-V, and FTL rating. Scroll all the way to the Right of the High-Thrust/Ram-Rocket checkboxes to see the two columns dedicated to assigning Performance Profile status.
-Revamp of the Crew Requirement calculations.
-Ability to assign Fuel Use to Stardrives. Currently doesn't do anything but generate a note for the chosen Stardrive type, but in the future I plan to add a use over time/per jump which can be calculated and noted properly.

[ericbsmith]

Posted Version 119k
This is actually really close to me declaring it "finished" for the time being.
-Minor bug fixes
-Fixed a couple of incompatibility problems with Open Office
-Posted Open Office and Excel 2007 version of the spreadsheet

Excel 2000:
http://gurpsland.no-ip.org/zip/Spaceships119.zip
http://gurpsland.no-ip.org/zip/Spaceships119.7z

Excel 2007:
http://gurpsland.no-ip.org/zip/Spaceships119-2007.zip
http://gurpsland.no-ip.org/zip/Spaceships119-2007.7z

Open Office:
http://gurpsland.no-ip.org/zip/Spaceships119-Ooo.zip
http://gurpsland.no-ip.org/zip/Spaceships119-Ooo.7z

[Kuroshima]

Originally Posted by ericbsmith

Posted Version 119k
This is actually really close to me declaring it "finished" for the time being.
-Minor bug fixes
-Fixed a couple of incompatibility problems with Open Office
-Posted Open Office and Excel 2007 version of the spreadsheet

Excel 2000:
http://gurpsland.no-ip.org/zip/Spaceships119.zip
http://gurpsland.no-ip.org/zip/Spaceships119.7z

Excel 2007:
http://gurpsland.no-ip.org/zip/Spaceships119-2007.zip
http://gurpsland.no-ip.org/zip/Spaceships119-2007.7z

Open Office:
http://gurpsland.no-ip.org/zip/Spaceships119-Ooo.zip
http://gurpsland.no-ip.org/zip/Spaceships119-Ooo.7z

Does the Open Office version work with macros?

[ericbsmith]

Originally Posted by Kuroshima

Does the Open Office version work with macros?

No. From what I can tell Open Office uses a completely different Macro language, which would require me to completely rewrite all of the Macros from scratch. I may endeavor to do that... someday... but for now Macros simply don't work in Open Office. As I said before, Macros don't do anything that's absolutely required for the sheet to work, they just add some nice functionality.

[Kuroshima]

Originally Posted by ericbsmith

No. From what I can tell Open Office uses a completely different Macro language, which would require me to completely rewrite all of the Macros from scratch. I may endeavor to do that... someday... but for now Macros simply don't work in Open Office. As I said before, Macros don't do anything that's absolutely required for the sheet to work, they just add some nice functionality.

I know that it's more work than simply opening with Open Office and hitting save, but if the macros are not functional, could you please remove them from the file? this way we don't get messages on how our security settings blocked macros...

[ericbsmith]

Posted Version 1.19L
-Fixed RoF for low TL guns to use the updated chart from SS7
-Stripped the Macros from the Open Office version
-More bug fixes

Excel 2000:
http://gurpsland.no-ip.org/zip/Spaceships119.zip
http://gurpsland.no-ip.org/zip/Spaceships119.7z

Excel 2007:
http://gurpsland.no-ip.org/zip/Spaceships119-2007.zip
http://gurpsland.no-ip.org/zip/Spaceships119-2007.7z

Open Office:
http://gurpsland.no-ip.org/zip/Spaceships119-Ooo.zip
http://gurpsland.no-ip.org/zip/Spaceships119-Ooo.7z

[congo]

nice work as always, but when i use open office version and choose engines it always shows 0G at Move statistic

[BlackLiger]

Originally Posted by congo

nice work as always, but when i use open office version and choose engines it always shows 0G at Move statistic

Mine tends to show the correct thrust, but refuses to make systems use power points, give ranges for any weapons but lasers (I'd have assumed missiles would have a range limit by fuel, at least, with options of burst thrust), or make the ship able to fly in atmosphere at all, even with steamlined and jet engines added on.

Open Office again. Latest version.

[ericbsmith]

OpenOffice didn't like something I did when I added the ability to create Performance Profiles; the sheet is supposed to automatically use all the engines unless you start assigning some to a profile. Unfortunately in OpenOffice it's not doing that, however if you assign an engine to one of the Performance Profiles it will correctly calculate all the statistics for Air & Space performance. Look for the Performance Profile column all the way to the right, just to the right of the High-Thrust/Ram-Rockets checkboxes.

Originally Posted by BlackLiger

Mine tends to show the correct thrust, but refuses to make systems use power points, give ranges for any weapons but lasers (I'd have assumed missiles would have a range limit by fuel, at least, with options of burst thrust)

In the Basic Combat system Missiles are given a range just like any other weapon. In the Hex-Based combat system they are instead given a Delta-V, but no range per se. Theoretically they could have an infinite range; launch them in a direction and they'll keep going forever, just slowly.