GURPS Spaceships Design Spreadsheet

[davester65]

Hi, I've been using the user systems option to create custom reactionless drives (to reflect some stuff I've heard about EM Drives). It lets me create them fine except there is no "afterburner" option on the drive I created. Is this a fixable thing or just a limitation of the user systems option? Still using Excel 2007 btw.

Thanks.

[ericbsmith]

Originally Posted by davester65

Hi, I've been using the user systems option to create custom reactionless drives (to reflect some stuff I've heard about EM Drives). It lets me create them fine except there is no "afterburner" option on the drive I created. Is this a fixable thing or just a limitation of the user systems option? Still using Excel 2007 btw.

The "afterburner" option is a result of two factors; first, the "Unofficial Rules" campaign option is set (since it's an optional rule from my Unofficial Rules set) and two the name starts with "Reactionless Engine". So if you rename your drives to be Reactionless Engine - EM Drive they should have the Afterburner option available.

Incidentally, I have thought about changing the way that System Options work to allow user systems to be set up to be allowed to use the predefined options (in this case, it would allow you to use the Afterburner option without having to stick to the Reactionless Engine naming convention). It'd just take a bit of a rewrite and I haven't gotten around to devoting that much time to it.

In checking this out it looks like there is a bug in the Read User Systems function that causes it to read the Performance 1 column twice and then read Performance 3 instead of reading them 1, 2, then 3. This affects every time the sheet would read the data, including when it goes to save a ship to one of the save sheets. I'm going to have to push an Excel update shortly to fix that.

[ericbsmith]

Version 2.0 Release Candidate 16
-Fixed a bug that caused the sheet to incorrectly read any User Systems from the User Systems worksheet. This would cause User Systems to be incorrectly saved in the save sheet. The bug was causing the Performance 1 column to be copied twice and Performance 2 wasn't read at all. This bug appears to have been introduced in RC12.

You can download the spreadsheet here:

Excel 2000 (RC16)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (4.9 MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (~2.4 MB)

Excel 2007 (RC16)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (~6.1 MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (~6.0 MB)

OpenOffice 3.3.0 (RC9)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (~2.1 MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (~1.9 MB)

[davester65]

Thanks a lot. Keep up the good work. I look forward to the updates.

[Yami Fowl]

I am currently using Office 2010 and can only open the 2007 version.
But since the RC16, I can't change the SM cells, the drop menu doesn't work.

Any ideas as to why?

Thanks in advance!

[ericbsmith]

Originally Posted by Yami Fowl

I am currently using Office 2010 and can only open the 2007 version.

I started having trouble opening the Office 2000 version in 2007 a while ago; it has to do with the certificate I sign the sheet with. For some reason if I open the sheet in a folder other than one I've already designated as a Trusted Location the sheet crashes for me. So I started removing the self-signed certificate from the Office 2007 version.

Originally Posted by Yami Fowl

But since the RC16, I can't change the SM cells, the drop menu doesn't work.

I have no ideas. The cell isn't locked, and isn't generating an error that would prevent the cell from working. In fact, I haven't changed the code for the SM in a very long time. Is this affecting the SM in the System Options section of the sheet, the Design Table section of the sheet, or both?

[DaltonS]

I waited until I could check out the "Optional Rules" in RC16, but I still didn't see any rules for recharging Energy Banks. As I said before

Originally Posted by DaltonS

Waiting for a recharge can be more important to the game play than the actual discharge of energy, so I really need this information.

Dalton “Expiring minds STILL want to kn....” Spence

P.S. Lithium-ion batteries in cell phones, e-cigs and laptops are in the news for catching fire or blowing up when over-charged, fast-charged or crushed. Similar problems for Energy Banks should be noted.

[Yami Fowl]

Originally Posted by ericbsmith

I have no ideas. The cell isn't locked, and isn't generating an error that would prevent the cell from working. In fact, I haven't changed the code for the SM in a very long time. Is this affecting the SM in the System Options section of the sheet, the Design Table section of the sheet, or both?

Both of them.

[DaltonS]

Possible bug:

Tracked drivetrains are only available for vehicles of SM +10 or smaller. They must go in the central hull.

Pyramid 3/34,"Alternate Spaceships" page 7

On the spreadsheet, you can put them in any hull section.

Dalton “BTW, has anyone built a tank?” Spence

[DaltonS]

The "FUEL USED" for a NEMA reactor is listed as "Hydrogen/Helium Isotopes" when according to GURPS Technomancer

Necronium is used in nuclear-enhanced mana area (NEMA) reactors, which create very high-mana areas in their cores.

Technomancer, p.43

Also, NEMA reactors seem to have "Compact" and "Unshielded" options. What magical effects do these options mean (ie. mana levels in the hull section of an "unshielded" reactor, "hellgate" events for damaged "volatile" ones)?

Dalton “who still thinks his mini-Trailblazer is a better design” Spence