Re: GURPS Spaceships Design Spreadsheet
 

I found a mention in Magic (M11) - area spells are four yards high as the default, and 'wall' spell descriptions all back this up. So the default hex is four yards high for standard magic. This is also mentioned in Characters (B239).

Re: GURPS Spaceships Design Spreadsheet
 

Magic! I should have known. I knew about Area spells of course, but since my space station was a hard science project I didn't consider it. Better keep wizards off the station then. If the support structure for a deck lies beneath it, an Area spell might ruin someone else's day. (If it even stuck to the deck of a rotating and orbiting space station at all. ;) )

Re: GURPS Spaceships Design Spreadsheet
 

The specific reference i was remembering was p. B101, which i'll admit doesn't explicitly say hex, but as Rupert specified, Magic does; i'm pretty sure other references could be dug up as well.

(Emphasis added.)

Re: GURPS Spaceships Design Spreadsheet
 

I guess I'd better not let any supers with enhanced advantages on board either. :D

Re: GURPS Spaceships Design Spreadsheet
 

I was browsing some of my older posts recently when I came across some ship designs I was (and am) rather proud of. Unfortunately when I checked my "Unofficial Ships" sheet I had apparently not saved them there. In the process of reconstructing them I noticed a couple of things I hadn't before. I won't call them errors but they did surprise me.

1. Whether the "Calculate Troop Strength" checkbox is checked or not, Troop Strength is still listed in the generated notes (and calculated for all auxiliary vessels).
2. "Spin Tethers" can be selected as a option but won't be listed unless the "Spin Gravity" option is checked. This actually makes sense structurally but the "Spin Tether" option should be zeroed and locked down if "Spin Gravity" is unchecked. Also the Spin Tether G value in the notes should go to 2 decimal places (or 3 significant digits).

Re: GURPS Spaceships Design Spreadsheet
 

Another thing I just noticed: the IR signature of a "Reconfigurable System" is the total of the signatures of all the components. That makes no sense since only one component can be active at any given time. Instead the signature should be the highest one of any of the components. I have a Fission Reactor/NTR (Ram Rocket) combo (which makes a little sense, right) which can power a VASMIR Electric Rocket in space once the NTR has got them there. I'm adding Exposed Radiators for the reactor which will be retracted the the NTR mode is being used.

Re: GURPS Spaceships Design Spreadsheet
 

I just started designing my Mars Base (okay, my starting point was "The Warren" from Pyramid 3/71, page 11 but I made extensive changes) and came across a couple of features that don't seem to work.

1. Solar Power Options - I set the Stellar Distance to 1.5 AU like I should but even with 3 Solar Panel Systems I didn't get a single power point. Don't you add partial Solar Power points together?
2. When I selected the "Optimized for [Craft]" option for my hangar bay there was no list of auxiliary vehicles to choose from in the Option 4 column.

Re: GURPS Spaceships Design Spreadsheet
 

It should, yes, but apparently is not on the system itself. However, the Power Points do seem to be showing up in the Power Points Note that appears above the Ship Systems.

That field allows you to type in a value, since it's basically informational for the system note.

Re: GURPS Spaceships Design Spreadsheet
 

Nope, still a total of 0 power points for all three Solar Panel Arrays. (The original "Warren" design never adjusted the Solar Power Options.) Should be a total of 1 regular and 1 small power point if it worked. There is a nice note explaining "[8] Power Points ×0.444 for Stellar Luminosity 1.0 L and Distance 1.5 AU, [9] Optimized for Mars Trans-Orbital Taxi (L)"

Okay, I was just hoping that if a drop down list of vehicles could be used as a "Vehicle Docks" option it could generated here.

Re: GURPS Spaceships Design Spreadsheet
 

Yeah, there are some issues with the way it's handling it. I'm going to look into it when I get some time.

I'm not sure why I never set it up like the Vehicle Dock with the dropdown. Maybe I'll go back and revisit that.

Re: GURPS Spaceships Design Spreadsheet
 

FWIW: Just noticed the Kobold Work Bug (SS6:12) has a Troop Strength of 583 on the spreadsheet. Must be kind of crowded at SM+5. ;) (Seems hard coded since I can't change it.)

Re: GURPS Spaceships Design Spreadsheet
 

Kobolds are very very smol.

Re: GURPS Spaceships Design Spreadsheet
 

Troop Strength is based on a formula that includes Weapon and dDR (plus some other combat systems). The Work Bug has a large mining laser and is fairly well armored, making it attack capable. At TS 583 it is well below any of the other attack-capable SM+5 ships. For full details see the rules for calculating Spaceship TS from Pyramid #3/30.

If you want to zero out the TS get rid of the Weapon Battery then create a User System called "Mining Laser" that uses 1 PP and has the cost of a Major Weapon Battery.

Re: GURPS Spaceships Design Spreadsheet
 

How small? Are they smurfs (this would actually be possible in TransHuman Space, IIRC)?

Re: GURPS Spaceships Design Spreadsheet
 

Okay, that's doable. Thank you. I'd still like a switch that could suppress displaying troop strength altogether. I prefer to design non-fighting vessels and structures and it's not appropriate there.

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.0 Release Candidate 30
-Fixed bug where Troop Strength was always calculated and shown on the output, regardless of the state of the "Calculate Troop Strength" button.
-Fixed a few bugs with regards to Spin Tethers
-Fixed issues with Solar Panels where the Solar Luminosity & Distance has been set and partial power points are generated. The sheet will now track all power produced for all panels grouped together, rounding down Power Points generated to 1/3. The sheet will also track total power points generated from all panels and add them together, rounding that total down to the nearest whole Power Point (or 1/3 Power Point if Combine Large & Small PP is selected). This does mean that total Power Generated may be slightly more than that displayed by each set of panels; for instance, if Lum is set to 1.2 then each panel will produce 1.2 PP; five panels would thus produce 6 PP, but depending on how those 5 panels are installed on the sheet they may show as little as 1 PP generated each.
-Hangar Bay option Optimized for [Craft] now allows you to select the craft from a drop-down menu of craft from the Save Sheets. However, for both this field and the craft selection field in Vehicle Dock you may also type in the name of a craft in addition to using the drop-down menu.

You can download the spreadsheet here:

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

Excel 2007 (RC30)
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
http://gurpsland.no-ip.org/pdf/Space...ionalRules.pdf

Re: GURPS Spaceships Design Spreadsheet
 

You need to update the RC numbers next to the links.

Re: GURPS Spaceships Design Spreadsheet
 

Selective Automation
I seem to remember that in a earlier edition of the spreadsheet it was possible to automate individual systems. I understand if it can no longer be possible but I would like to be able to automate a single hull section. Why? So I can put an unshielded reactor or drive there without endangering maintenance crews. I keep remembering the Discovery in "2001: A Space Odyssey" where the nuclear engines were kept a long way from the habitat module. I'm sure HAL took care of that system (before he took care of the crew).

Re: GURPS Spaceships Design Spreadsheet
 

I've noticed that whenever I reload one of my saved ships the "Calculate Troop Strength" option is set on even if it was off when I last saved it. Is this a glitch? Also is there any way to save multiple campaign settings so I can use specific ones with multiple ship designs? If so, maybe you could add "Solar Power Options" to the campaign setting.

Re: GURPS Spaceships Design Spreadsheet
 

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).


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.

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.

Re: GURPS Spaceships Design Spreadsheet
 

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?
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.

Re: GURPS Spaceships Design Spreadsheet
 

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.

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.

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
 

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

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
 

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
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

Open both the old spreadsheet and the new version in Excel at the same time (e.g. you might open both RC 30 and RC 33 together).

Older versions of Excel had some memory issues with doing this with large sheets (which this is). So what you can do is delete all of the sheets from the older spreadsheet except for the Saved Ships Sheet before opening it (I recommend saving it to a new file at this point, closing it, then reopening it).

Once you've opened both spreadsheets you will need a Saved Ships sheet with enough room to import all of the ships; you can either create a new Saved Ships sheet or delete all of the ships from within the Official or Unofficial Ships sheets. Once you have that, you can click the Import Saved Ships button in the Saved Ships sheet, and it will ask you which file you're importing from, which Saved Ships sheet in that file you're importing from, and which Saved Ships sheet in the current spreadsheet you're importing to.

Let me think on that.

Re: GURPS Spaceships Design Spreadsheet
 

You might want to consider adding this explanation to the "Optional Rules" sheet as it is something every user will want to do when they open a new edition of the spreadsheet.

Re: GURPS Spaceships Design Spreadsheet
 

RC 33 bug report:
Fabricator, Robofac and nanofactories have the same output.
The exact same

Re: GURPS Spaceships Design Spreadsheet
 

How well do these work with LibreOffice?

Re: GURPS Spaceships Design Spreadsheet
 

So I've tried to use the thing with Google Sheets and

First of all, it hogs all my computing power up. I have to wait sometimes minutes for a single dropdown list.

But second, and more annoyingly, is that I can't input a SM because I keep getting a data validation error

Re: GURPS Spaceships Design Spreadsheet
 

I haven't had much luck with the OpenOffice version of the spreadsheet in LibreOffice on my Macbook. In many cases multiple lines of text are jumbled together on a single line. Haven't tried it in LibreOffice on a Windows PC, so the issue might be limited to my own system.

Re: GURPS Spaceships Design Spreadsheet
 

This thing is almost completely incompatible with Google Sheets. It's not going to work properly and it will cause you pain the entire time you try to make it work.

Re: GURPS Spaceships Design Spreadsheet
 

Ah, thanks for the knowledge. Was worried that I did something wrong.

So can we get a google sheets version?

Re: GURPS Spaceships Design Spreadsheet
 

Not likely. The sheet was written exclusively in Excel. The fact that I got it to work in an older version of OpenOffice was almost a miracle. I have no desire to try to get it working with Google Sheets.



I haven't even looked at the OpenOffice versions in a long time, but there were some serious issues which I remember identifying with the newer versions of OpenOffice/LibreOffice and started to address in the Excel Macros. If I had ever ported it back over to OpenOffice/LibreOffice again it would have run much better in newer versions of those suites. Unfortunately, the amount of work that would have taken got to be more and more as time went on and I never got around to doing another port. My best advice is to try to get your hands on an older version of OpenOffice, specifically v3.2 which is what I developed the port for. It worked on OpenOffice v3.4.x and LibreOffice v4, but was slow. On newer versions than those I believe it had some serious issues with the Macros that caused it to be very slow.

Re: GURPS Spaceships Design Spreadsheet
 

No worries, I wouldn't expect you to support every office suite. Your spreadsheet works perfectly for me in Excel, and was easy for a relative GURPS noob like me to figure out (used it to design mecha for a recent one-shot adventure).

Re: GURPS Spaceships Design Spreadsheet
 

In Excel v2109 Build 16.0.14430.20256 64bit

"The following user defined functions, created in an older version of Excel, have the same name as build-in Excel functions. When these function names are used, the new built-in functions will be used. which may give different results. To avoid this conflict, rename the user-defined functions and change the associated formulae to use the new name."

This is for function Phi.

I'm not sure if this impacts the use of the spreadsheet, but I'm about to find out.

Re: GURPS Spaceships Design Spreadsheet
 

Is there a way to apply Campaign Options to an entire Saved Ships sheet? Or do I have to do it one ship at a time?

Re: GURPS Spaceships Design Spreadsheet
 

And another request.

Some of my ships are refitted later in their careers with a different weapons loadout.

Would it be possible to add an option for alternate weapons in the weapons systems block?

Re: GURPS Spaceships Design Spreadsheet
 

Anything is possible but not everything is practical. It would be easier to just make the refit changes to the original ship design and save it under a slightly different name (perhaps adding a version letter/number to the end of the name).

Re: GURPS Spaceships Design Spreadsheet
 

IMO that's really the best way. If these ships are following a standard upgrade path, and more than one variant is going to show up in the gameworld, then save each variant as a seperate ship. If you're talking about one specific Hero Ship (such as the PCs ship) then change it for any upgrades it has been given and save it under a unique name. If you want to record the changes either add that in the Notes or save it under a unique name every time it's upgraded.

Re: GURPS Spaceships Design Spreadsheet
 

Oh, I understand if its not practical but it doesn't hurt to ask. I've been either putting the changes in the notes (but then I don't have the stats available) or saving a variant sheet as mentioned.

It's a minor issue I know, just would prefer to have it all on one sheet. I guess I can always do some cut-n-paste of the print out.

Anyway, thank you eric for doing this.

Re: GURPS Spaceships Design Spreadsheet
 

If all you want is the stats available for the older/variant weapons systems then just add them to the ship at no quantity listed. In order to add extra "dummy" weapons you'll first need to reduce the quantity of the installed weapons so that the sheet will allow you to install the extra, then set the quantity of the installed weapon back to where you want it and the extra weapons will be saved with the ship and show in the Weapons section. This is particularly useful for Missile Launchers where a ship might carry a number of different warheads, changing them out as needed or as they're used up and replaced (or not) with other missiles.

Re: GURPS Spaceships Design Spreadsheet
 

Perfect! That's exactly what I wanted. Thanks again.

Re: GURPS Spaceships Design Spreadsheet
 

Is there a way to create custom user habitat modules like we can create user systems? It would make it easier to convert GT ship designs if I could translate their modular components into cabin equivalents. Sometimes even smaller systems are larger than I want.

Re: GURPS Spaceships Design Spreadsheet
 

I just got back into making interesting ships using this spreadsheet. It’s even more awesome than I remember! So thank you Eric!

I do have two requests for future additions

• A check-box or option-drop-down for vectored thrust on engines, which (I imagine) would multiply engine thrust times 2/3
• A check-box or drop-down to take into account hot-bunking, a common practice on smaller modern warships

Re: GURPS Spaceships Design Spreadsheet
 

Thanks for making this Eric. It is really great.

I am trying to make a missile. SM+3. Is there a weapon or self destruct module that I can use for warheads?

What module would I use to make a launcher on the mothership?

Right now I have it with 6 missile launchers (12cm) and only enough ammo for one round of launches to simulate a mirv warhead, that launches at range 10.

Any suggestions?

Re: GURPS Spaceships Design Spreadsheet
 

Obligatory comments on what an amazing piece of work this spreadsheet it. But actually though. It's such a fantastic resource.

I'm messing around with Ornithopter wings (SS7:12). The description there is pretty brief, but it does seem to say that each ornithopter system adds +1 to Handling, which I read as being in addition to the Handling bonus from having wings.

"Each system provides 0.25G acceleration in atmosphere only, and adds +1 to Handling in the air."

Currently that +1 Hnd is not being applied in the spreadsheet.

I tried creating a user system that copies from the Ornithopter and Manoeuvre Enhancement systems, but while it then says '+1 Handling' in the System notes, it's not added to the Hnd/SR stats. I poked around in the hidden cells, trying to to decipher things, and the best I could do is it seems like it's hardcoded to look for the "Manoeuvre Enhancement" system? But I'm not confident about that, and couldn't get it to add up correctly without breaking everything.

For now I can just make a note to use the 'actual' Hnd rating, but it'd be nice if it it'd add this value itself.

Re: GURPS Spaceships Design Spreadsheet
 

I am running into a problem with the Spaceships spreadsheet and more recent Excel editions.

"Some cells in this workbook contain data validation rules, which refer to values on other worksheets. These rules won't be saved." A whole raft of values are called out.

Excel will also tell me that there is a user-defined function that has the same name as an already defined function and that the already defined function will be used which will cause changes. The function 'phi' is indicated as the problem.

Edit: This is the same problem jbalsle reports up thread in post #1001. He has the exact text in his report/

I am using Microsoft® Excel® 2021 MSO (Version 2303 Build 16.0.16227.20202) 32-bit

Anyone else ever encounter this?

Re: GURPS Spaceships Design Spreadsheet
 

I have no idea why this would be happening. Cell Validation is used to create the drop down menus, and in Excel 2000 (which I use to create the original sheet) they CANNOT directly reference ranges in other worksheets. As I don't have a current version of Excel, and I don't know what the error even is talking about.

According to the MS Support site this may even be an erroneous warning.

This one, at least, is a non-issue. Phi is numerical constant approximately equal to 1.618. At one point I defined some things like that in the sheet when I was first working on the functions and promptly forgot about them. It appears that the newer version of excel just added a function to define it much as it has long had a function to define pi and e (euler's constant). Not using the version in my sheet shouldn't hurt anything, as I don't believe the value is even used.

Re: GURPS Spaceships Design Spreadsheet
 

Having trouble running it in LibreOffice. There's a lot of errors showing, half-size systems don't change the design table, that sort of thing. I've got the macros enabled. Anything I'm missing?

Error in the macro pops up: ScrubArray already defined?

Re: GURPS Spaceships Design Spreadsheet
 

I have not done any real work on the sheet in a while, and no work on the OpenOffice version in a very long time. It is likely that it is incompatible with newer versions of the suites and you'll need to go back to one of the versions I mention in the first post as being compatible. Also make sure you're downloading the OpenOffice version, as the Excel version won't work with any version of LibreOffice/OpenOffice without a lot of updates (the reason I haven't tried porting it over again).

Re: GURPS Spaceships Design Spreadsheet
 

Have I maxed out the spreadsheet?

I am running into an issue with it telling me it can't save anymore ships. No Empty Slots? How do I make more? Can I just delete all the Utility Vehicles I don't need?

My file is 132,292 KB. When I make a ship, I typically copy an existing table and rename it the name of my ship. I have about 45+ tabs.

I have noticed that my excel is super slow so I started saving my ships and then deleting the tabs but I got a message No More empty Slots. Is the proper way to use to only have one design table and just load / Save others?

I also have an issue with the checkboxes being out of alignment with their text.

Do I have to start over? Can I import the ships I made to a new version of the spreadsheet?

Re: GURPS Spaceships Design Spreadsheet
 

Note most of what I say here applies to the Excel version of the sheet. The OpenOffice/Libre Office version supports some of this, but not in the exact same way and/or not completely.

Excel gets touchy if you create duplicate Design Table tabs. This sheet has a lot of buttons and eats up a lot of memory. It also does a lot of calculations and slows down calculations in general if you have multiple duplicates of the tab. I'd recommend against having more than two or three Design Tables duplicated, as it can hit memory limits, especially in older versions of Excel.

However, you can create duplicates of the ship Save Sheets, and these have fewer calculations and buttons so they don't slow down the entire spreadsheet to nearly the same degree. Each Save Sheet is capable of storing 256 ships. If you go to one of the Save Sheets or the Design Table there is a button in the upper-right corner called "Add Save Sheet." This will add a duplicate Save Sheet and delete all of the ships in the duplicate; or you can just right click on the tab on the bottom and select "Move or Copy" to make a duplicate tab, but then you'll have to delete the ships from it yourself.

Yes, it supports importing ships from older versions of the sheet. Open both spreadsheets in Excel, go to the newer spreadsheet doc you want to import ships into, go to one of Save Sheets, and click the Import Ships button. One of the drop-down menus allows you to specify the spreadsheet file name to import ships from, another allows you to specify which Save Sheet in that file.

Re: GURPS Spaceships Design Spreadsheet
 

Thanks Eric, I got my file down to about 8MB from 170MB by saving all the design tables to a New tab Saved Ships 1 that was created by the macro button (I maxed out Unofficial Ships) and then deleting the extra tabs.

At some point my design table got jumbled and all the check boxes don't align with the words.

I am trying to import the Saved Ship 1 Sheet into the new download of the file but I keep getting a Runtime Error 9 Subscript out of range.

Any idea on how to fix it?

EDIT: I was trying to import from 2.0 V33 to 2.0 V20. It's not backward compatible.

Re: GURPS Spaceships Design Spreadsheet
 

Yeah, no, I've never checked for backwards compatibility since there's no real reason to import to an older sheet and, best case, would result in lost information. Also, if something didn't work I'd have to update the older sheet, which is pointless...

Anyway, I take it that you've now managed to import your ships into a current version of the sheet?

Re: GURPS Spaceships Design Spreadsheet
 

So I am trying to make a long range missile as a SM+3 spaceship.
How do you do warheads?
Does spaceships have self destruct module?

Re: GURPS Spaceships Design Spreadsheet
 

Does anyone have an issue with the excel file checkboxes slowly creeping up and too the right?

https://www.dropbox.com/scl/fi/31tf1...fmr1q2rsd&dl=0

Re: GURPS Spaceships Design Spreadsheet
 

Hey, my group and I have been trying to get this to work, and we are running into a number of issues:

1. The links to download the spreadsheet on the first page of the discussion seem to not work? Nothing downloads when you click them.

2. When we do manage to get the sheet to work(I had an old download of this, V2 for Open Office) a lot of the checkbox options under Ship Options and Divergent/Paranormal Tech and all those other boxes at the top of the sheet, those checkbox options all seem "smushed" into a single row, which I assume is not how it's meant to be?

Is there some tutorial or a step-by-step guide as to how to get this to work? We are using Open Office, is Excel the intended software for the sheet? Should we use that instead? Are there better links to the spreadsheet somewhere else?

Thanks for any help anyone can give.

Re: GURPS Spaceships Design Spreadsheet
 

I had the flu this last week, had me down. My website went down for a while, but it's back up now and the download links should be working again.

I have not revisited the OpenOffice versions of the sheet in a long time. The one thing I know for sure is that they only worked particularly well on the ancient versions of OpenOffice v3.3.0 or v3.2 Portable. I highly recommend you download one of those version of the program to see if that corrects the issues you've seen.