GURPS Spaceships Design Spreadsheet

[DaltonS]

I've been thinking about applying the "Compact" option to Reactionless Engines and Stardrives. They would use twice the power to get twice the thrust for twice the price (at least) in exchange to being "volatile" while in operation. (Normal power could be used for normal thrust, but the system would still be "volatile" due to design compromises.) A "Compact" drive would also be more difficult to repair or maintain due to reduced access space. This would be in addition to any Afterburner or Super-Stardrive options, which could be applied to either normal or double power mode.

Dalton “who loves more system options” Spence

[Krasudreal]

I am sorry to say, but the downloads don't seem to be currently working.

[ericbsmith]

Originally Posted by Krasudreal

I am sorry to say, but the downloads don't seem to be currently working.

I got home from work and the backup battery for my server was sounding an alarm, probably because the battery is dead. I'm gonna eat dinner and then see about getting the server back up.

[Krasudreal]

Originally Posted by ericbsmith

I got home from work and the backup battery for my server was sounding an alarm, probably because the battery is dead. I'm gonna eat dinner and then see about getting the server back up.

Downloads are now working as it should, but it seems that I am having consistent problems with certain areas of the sheet, including the SM in the design table.
It is giving me Error:502 on that cell, and on nearly of all cells of the unofficial ships
It is also giving me Error:504 on nearly of all cells of the official ships.

I have tried using the LibreOffice and the Microsoft Office Excel, nothing seems to work, I have habilitated macros, of course, and I don't know how all of this would even work without them. Since I have habilitated them every time.

It asks me to update links in the files, but either way, it doesn't seem to make a difference, especially because it seems like it Fails to update the links.

If you could provide me with some guidance, it would be greatly appreciated.

[loofou]

Originally Posted by Krasudreal

It is giving me Error:502 on that cell, and on nearly of all cells of the unofficial ships
It is also giving me Error:504 on nearly of all cells of the official ships.

Yup, same problem. Basically every single macro button throws errors. As far as I've seen most of the sheet still works, but some parts of the sheet simply say #Value! all over. Output Sheet doesn't work, neither do the (Un-)Official Ships sheets.

My main guess would be that the 2007 macros simply are not compatible with Excel 2016, which I use. Even the non-macro version has a lot of issues.

[ericbsmith]

Originally Posted by Krasudreal

I have tried using the LibreOffice and the Microsoft Office Excel, nothing seems to work, I have habilitated macros, of course, and I don't know how all of this would even work without them. Since I have habilitated them every time.

LiberOffice (or any other version of OpenOffice) isn't going to work on the Excel version of the sheet. If it were as easy as opening the file and habilitating the Macros I'd have provided updates to the OpenOffice version a while ago. There are significant differences in how the Macros are handled, and even differences in how some cell formulas work, which require a lot of work fixing for a conversion.

Originally Posted by loofou

My main guess would be that the 2007 macros simply are not compatible with Excel 2016, which I use. Even the non-macro version has a lot of issues.

Have you tried both excel versions in Excel 2016?

I don't have access to Excel 2016. Only thing I can request is that you open the file, save it, and then zip and e-mail me a copy. I should be able to open it without recalculating, which may allow me to suss out why it's giving these errors. May.

I'm also going to post a 7zip archive of older Releases Candidate versions of the sheet. I'm curious if you two have any luck with any of the RCs.

http://gurpsland.no-ip.org/zip/OlderSpaceships.7z.001 (8MB, download both archives)
http://gurpsland.no-ip.org/zip/OlderSpaceships.7z.002 (8MB)

[Krasudreal]

I couldn't extract the 002, no matter what I tried. Now, about what I managed to extract...

Well, the release candidate 16 didn't go much far either. Still same problems, with an addendum, however. the Error:502 and Error:504 has been replaced with #Value!

The others aren't looking very hot either, I got run-time error 1004 on the 15, 14. 12, 11 didn't have run-time error, but the problems are back...

10 still has the #Value! error, but I can now set the SM on the ship on the design table.

I stopped there for the time being, because I am a lazy person.