Steve Jackson Games Forums - GURPS Spaceships Design Spreadsheet

Steve Jackson Games Forums (https://forums.sjgames.com/index.php)

- GURPS (https://forums.sjgames.com/forumdisplay.php?f=13)

- - GURPS Spaceships Design Spreadsheet (https://forums.sjgames.com/showthread.php?t=62539)

Re: GURPS Spaceships Design Spreadsheet

Version 2.0 Release Candidate 32
-Fixed another bug preventing the Calculate Troop Strength from being turned off on the output.

Version 2.0 Release Candidate 31
-Fixed critical error where Output sheets would error out and be unusable when certain ship systems under certain circumstances (Mixed Weapon Battery, Equipment Packs, possibly Reconfigurable system). This had to do with incorrectly counting total number of ship systems for calculating Protection Factor (PF) which could then cause the PF note to error out.
-Fixed a couple other minor bugs.

You can download the spreadsheet here:

Excel 2000 (RC32)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z

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

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

Spaceships Optional Rules (RC29)
http://gurpsland.no-ip.org/pdf/Space...ionalRules.pdf

Re: GURPS Spaceships Design Spreadsheet

I noticed the most recent release contained an updated version of the SpaceshipsOptionalRules.pdf file but when I looked it was still labeled RC29. Have you actually made any changes to the Optional Rules sheet since then (aside from the version number I mean)? This isn't just an idle question. I recently (because I was bored I'll admit) manually created a .docx file from the text of that sheet. The only things I directly copied were the data tables; the rest I filtered through one of my text editors (to unwrap paragraphs mainly) and copied into the appropriate heading and paragraph styles (which I altered on the .docx file to match the fonts and alignments on the sheet) making sure any bold and italic text matched. It's not an exact copy I admit (sometimes I couldn't align the tables with the text the same way and I corrected any spelling errors and comma issues that Word found) but it is as close as I could make it. I will send you a copy if you want and you can do with it what you will.

Dalton “who is most creative when he's bored” Spence

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by ericbsmith (Post 2345820)

I'm not seeing that on a ship I just saved & reloaded. I don't think that should have been an issue with previously saved ships, either, since the issue I fixed was with the Design Table not respecting the state of the button in regards to displaying the results. (note that Troop Strength is always calculated, regardless of the checkbox; technically the checkbox only affects whether or not that information will be displayed on the ship and the output sheets).

Oh, this is weird. When I imported my saved ships to the "Unofficial Ships" sheet of the RC31 version and loaded my Martian “Gas” Station the "Calculate Troop Strength" option was off as it should be, but when I clicked the "Hide Unused Rows" checkbox it was turned on. Huh?

Quote:

Originally Posted by ericbsmith (Post 2345820)

Any time you reset the design table, save, or reload a ship there are a series of checkboxes on the right-side of the dialog box where you can choose which sections to save, load, or reset. What you want to do is create a "dummy" ship - name it Mars Campaign Settings or something - and save just the Campaign Options (this is the information from the same-named tab) and the Ship Options (this is the information from the Design Table from the Ship Options, Features, etc section of the sheet). Then you can reload this before you start a new ship.

So basically create a template ship (not a dummy, we have to be smart about this ;) ) with all the Design Switches & Features and Campaign Settings preset but no systems or size defined (setting the TL and the name should be okay) and save it? Makes sense. I was thinking that the Campaign Setting was an independent entity from the ship but I guess it doesn't have to be if a template can be used. Just have to remember to save the template with the focus on the Design Table so that will appear when I reload it and change the name and SM immediately after that.

Dalton “Good Idea! Why can't I have more of those?” Spence

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by DaltonS (Post 2345876)

I noticed the most recent release contained an updated version of the SpaceshipsOptionalRules.pdf file but when I looked it was still labeled RC29.

If I update the rules I'll update the cover sheet and the RC on the cover. So, no, I haven't actually updated the Optional Rules PDF since the RC29 version of it.

Quote:

Originally Posted by DaltonS (Post 2345903)

Ugh, not necessarily weird. I just found another bug with the Troop Strength that would hose my last fix if you Reset the Design Table. Meaning when I prepped the ship for release, and it Reset the Design Table, it undid my fix. Which is probably why it was bugged in the first place, because it undid what I thought I had fixed way back when.

Quote:

Originally Posted by DaltonS (Post 2345903)

Campaign Settings can be shared between multiple Design Tables (which you can copy off by hitting the Add Design Table button in the top right of the Design Table). This can allow you to have multiple ships open sharing the same Campaign Options. Ultimately, though, the Campaign Options must be saved with the ship so that the ship can reload them when it is loaded. This means that, technically, any ship can be used as a "Campaign Template" by loading it and deselecting everything except the Campaign Options. You wanted to set some of the Ship Options, Design Features & Switches, though, which makes it more practical to create an entirely separate ship with the Campaign Options & Ship Options preset.

So I've just pushed RC32 to fix the other bug with Troop Strength. I'm not going to post a new Release message though, instead I'm just going to go back and edit the RC31 message since this is a relatively minor change.

Re: GURPS Spaceships Design Spreadsheet

Hi, I've noticed a minor glitch. On some of the ships I've designed and saved, on the saved ship tab on the column for dST/dHP instead of the correct value it sometimes just shows a 1. It always seems to be on ships that I installed Structural Reinforcement on when it does happen, but some of the designs it shows the correct split value for having structural reinforcement. If I open the saved ship it always shows the correct dST/dHP on the design table. Figured you'd want to know.

Re: GURPS Spaceships Design Spreadsheet

Help! having an issue with cost multipliers in the ship systems section. The costs do not change in the design table and the cost multipliers disappear when I save a ship even when I check the save ship systems box.

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by jmurrell (Post 2378949)

The costs do not change in the design table

I am not seeing this issue. You will have to give me a specific example.

Quote:

Originally Posted by jmurrell (Post 2378949)

and the cost multipliers disappear when I save a ship even when I check the save ship systems box.

This, OTOH, does appear to be a bug. I'm not 100% sure why it's doing it but will look into it.

Re: GURPS Spaceships Design Spreadsheet

Version 2.0 Release 33
-Fixed issue where System and Habitat cost multipliers were not being saved with the ship.

You can download the spreadsheet here:

Excel 2000 (RC32)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z

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

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

Spaceships Optional Rules (RC29)
http://gurpsland.no-ip.org/pdf/Space...ionalRules.pdf

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by ericbsmith (Post 2378954)

I am not seeing this issue. You will have to give me a specific example.

SM+4 craft with Fusion torch thruster and a 0.3 cost multiplier. Cost doesn't change with or without the multiplier.

Re: GURPS Spaceships Design Spreadsheet

Quote:

Originally Posted by ericbsmith (Post 2378957)

Version 2.0 Release 33
-Fixed issue where System and Habitat cost multipliers were not being saved with the ship.

A question and a request.

The question is how can I move saved ships from on older version to a newer one. Preferably moving a whole saved ships sheet at once.

The request is a way to name habitat modules. Admirals cabin, marine gym, 2nd class passenger cabins, etc.