Steve Jackson Games Forums

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)

Daigoro 08-26-2019 11:54 AM

Re: GURPS Spaceships Design Spreadsheet
 
Quote:

Originally Posted by Darkholme (Post 2281215)
I was hoping to make it public with my group and allow the players to manage the ship together and add in upgrades to it as they go, using the worksheet.

Have you tried using Excel Online? You can get to it from a Hotmail account, and it has the usual sharing options. And you can also edit it from a webpage well enough, so it should work on your Chromebook.

ETA: Ahh... I just tried that. It won't work because it's bigger than the 5MB limit. You could try with one of the older versions of the sheet though, if they're still on Eric's website.

Celti 08-26-2019 01:24 PM

Re: GURPS Spaceships Design Spreadsheet
 
Quote:

Originally Posted by Daigoro (Post 2281264)
Have you tried using Excel Online? You can get to it from a Hotmail account, and it has the usual sharing options. And you can also edit it from a webpage well enough, so it should work on your Chromebook.

A major problem with that is Excel Online flat-out does not (and will never) support macros, and currently does not support form controls. You lose most of the sheet that way.

Daigoro 08-26-2019 02:10 PM

Re: GURPS Spaceships Design Spreadsheet
 
Quote:

Originally Posted by Celti (Post 2281292)
A major problem with that is Excel Online flat-out does not (and will never) support macros, and currently does not support form controls. You lose most of the sheet that way.

Is that only for the browser-based app? As you can open a shared sheet on your PC, which should give back those functions.

Celti 08-26-2019 02:14 PM

Re: GURPS Spaceships Design Spreadsheet
 
Quote:

Originally Posted by Daigoro (Post 2281310)
Is that only for the browser-based app? As you can open a shared sheet on your PC, which should give back those functions.

Sure, but as far as I'm aware you need to buy Excel to run it on your PC, while various services can give you limited shared access to the browser-based version.

davester65 03-26-2020 11:23 AM

Re: GURPS Spaceships Design Spreadsheet
 
Hi, I was doing some fiddling with the spreadsheet and noticed a couple of very minor problems. While you have both sensor drones and sensor probes listed as options for missiles, you don't seem to include the (-4) penalty to hit as well as the loss of the (2) armor divisor for when the drone is used as a missile. Also on the sensor probes the acceleration and delta-V is still included even though the sensor probes have no engines as per Spaceships 5 on page 27. Also you don't seem to include proximity detonation as an option for missiles or electromag' weapons.
As I said it's a minor thing, but I figured you'd want it pointed out for whenever you have the time to update the spreadsheet again.

ericbsmith 03-26-2020 06:42 PM

Re: GURPS Spaceships Design Spreadsheet
 
Quote:

Originally Posted by davester65 (Post 2316107)
Hi, I was doing some fiddling with the spreadsheet and noticed a couple of very minor problems. While you have both sensor drones and sensor probes listed as options for missiles, you don't seem to include the (-4) penalty to hit as well as the loss of the (2) armor divisor for when the drone is used as a missile.

The -4 to hit is included in sAcc, and has a footnote at the bottom of the weapon table stating that. The removal of the armor divisor is an oversight I'll have to correct though.

Quote:

Originally Posted by davester65 (Post 2316107)
Also you don't seem to include proximity detonation as an option for missiles or electromag' weapons.

Proximity Detonation is more of a combat option than a separate way of using the weapon though, don't you think? The total effect of a proximity detonation is a -4 to hit, removal of the armor divisor (for conventional) or dividing the damage by 100 (for Nuke/AM); it can be done with any conventional or Nuke/AM warhead.

davester65 03-26-2020 07:43 PM

Re: GURPS Spaceships Design Spreadsheet
 
Quote:

Originally Posted by ericbsmith (Post 2316172)
The -4 to hit is included in sAcc, and has a footnote at the bottom of the weapon table stating that. The removal of the armor divisor is an oversight I'll have to correct though.

Proximity Detonation is more of a combat option than a separate way of using the weapon though, don't you think? The total effect of a proximity detonation is a -4 to hit, removal of the armor divisor (for conventional) or dividing the damage by 100 (for Nuke/AM); it can be done with any conventional or Nuke/AM warhead.

Okay, fair enough. I hadn't noticed the change in sAcc.

ericbsmith 03-28-2020 12:17 AM

Re: GURPS Spaceships Design Spreadsheet
 
Version 2.0 Release Candidate 29
-Fixed error in displaying damage for "natural" weaponry - tails, robot arms, etc. (this has existed since RC22)
-On the Combat Table:
--Added more notes with information on Proximity Explosions for warheads
--Removed acceleration, range, & burn point info for Sensor Probes
--Removed armor divisor for Sensor Drones

You can download the spreadsheet here:

Excel 2000 (RC29)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (~5.3 MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (~2.7 MB)

Excel 2007 (RC29)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (~6.6 MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (~6.5 MB)

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

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

Kale 03-30-2020 12:43 AM

Re: GURPS Spaceships Design Spreadsheet
 
Thanks! The Optional Rules compendium was also extremely helpful.

DangerousThing 03-30-2020 01:34 AM

Re: GURPS Spaceships Design Spreadsheet
 
Will this work with libreOffice? I can try it out tomorrow if nobody has already.


All times are GMT -6. The time now is 04:43 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.