GURPS Spaceships Design Spreadsheet

[ericbsmith]

Originally Posted by sayke

ericbsmith - i'm sorry to say that i'm getting the same errors! no idea why...

OK, finally sat down to look into it and I did find a couple compile errors in the current version of both Excel sheets. I've corrected these errors and re-uploaded the sheets. I'd appreciate it if the two of you, or anyone else using Excel 2011, would give it a try.

[DemiBenson]

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

[Doctor Thantos]

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?

[Snoman314]

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.

[Joseph Paul]

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?

[ericbsmith]

Originally Posted by Joseph Paul

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

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.

Originally Posted by Joseph Paul

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.

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.

[Dark_Daemon]

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?

[ericbsmith]

Originally Posted by Dark_Daemon

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?

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

[Doctor Thantos]

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?