GURPS Spaceships Design Spreadsheet

[ytuarte]

I have designed a ship, but I have an issue with the weapons. The 10cm electromagnetic guns damage is calculating as 3d6x5. I am very new to the spaceship rules, but I am sure this is not correct. Also, the rate of fire is calculating as 2 for one of the Electromagnetic guns even though it should be 1. Does anyone know what the issue may be?

[ericbsmith]

Originally Posted by KeniGT

I have problem with "Output". When the sheet starts, its values are removed. With what it can be connected?

The "Output" sheet will be based on whatever ship is loaded or created in the "Design Table" sheet.

Originally Posted by Rupert

For whatever reason, ticking the 'Electromechanical Computers' box does nothing. This is in the latest Excel 2007 version (and it's been the case since forever).

This looks to be an oversight on my part, as the Control Room computers Complexity should be reduced but isn't.

Originally Posted by Rupert

I can't tell if the OpenOffice/Libre Office version doesn't do anything too, because my Libre Office 6 install doesn't like the sheet at all - it's not formatting it correctly.

An updated OpenOffice version is long overdue. Unfortunately, I just haven't had the patience to try to get it working.

Originally Posted by ytuarte

I have designed a ship, but I have an issue with the weapons. The 10cm electromagnetic guns damage is calculating as 3d6x5. I am very new to the spaceship rules, but I am sure this is not correct. Also, the rate of fire is calculating as 2 for one of the Electromagnetic guns even though it should be 1. Does anyone know what the issue may be?

Spaceships, p. 68 lists dDamage of a 10cm Conventional Warhead ad 3dx5. Keep in mind that's dDamage, meaning it's the equivalent of 30dx5 of regular damage.

As for the RoF, it looks like I'm incorrectly applying the Improved option for Beam Weapons to conventional guns.

[ericbsmith]

Originally Posted by ericbsmith

As for the RoF, it looks like I'm incorrectly applying the Improved option for Beam Weapons to conventional guns.

Having looked at it again, this isn't so much an "incorrect" application as it is a possible errata, where I had to make a choice and choose for Improved to affect guns (and thus double their RoF). On Spaceships p. 58 the table listing for RoF mentions that Beams or guns that are Improved have their RoF doubled. So while Improved is not listed explicitly as a Gun option on p. 28-29, it is implied on p. 58 and I decided to apply it.

Like with beams, there is no downside to being Improved - no extra cost or reduction in capabilities - so it is automatically applied if the weapon is +1 TL after introduction.

[ytuarte]

Originally Posted by ericbsmith

Spaceships, p. 68 lists dDamage of a 10cm Conventional Warhead ad 3dx6. Keep in mind that's dDamage, meaning it's the equivalent of 30dx6 of regular damage.

This program was made for the 4e spaceships books correct? Because unless i am crazy the damage on page 68 for a 10cm gun is listed at 6d6×25 dDam.

[Celti]

Originally Posted by ytuarte

This program was made for the 4e spaceships books correct? Because unless i am crazy the damage on page 68 for a 10cm gun is listed at 6d6×25 dDam.

It's 3d×5 in my copy of the book, freshly-reacquired from W23 to make sure. It's also 3d×5 in the errata and in the print edition, which makes me think you've still got the very first edition of the PDF and not the latest version — go hit W23 and re-download it.

[Celti]

Originally Posted by ericbsmith

Spaceships, p. 68 lists dDamage of a 10cm Conventional Warhead ad 3dx6. Keep in mind that's dDamage, meaning it's the equivalent of 30dx6 of regular damage.

Are you sure that you read that right? Mine lists 12cm at 6d×3 (equivalent to 3d×6), and 10cm at 3d×5 — and the progression above and below that indicates that, yes, it should be +3d dDam per 2cm increment.

[ytuarte]

Ahh, i do have the first edition of spaceships still. That makes a lot of sense

[ericbsmith]

Originally Posted by Celti

It's 3d×5 in my copy of the book, freshly-reacquired from W23 to make sure. It's also 3d×5 in the errata

Yup, Spaceships has had extensive errata. Where possible I try to make sure the sheet is updated to the errata.

Originally Posted by Celti

Are you sure that you read that right? Mine lists 12cm at 6d×3 (equivalent to 3d×6), and 10cm at 3d×5 — and the progression above and below that indicates that, yes, it should be +3d dDam per 2cm increment.

I believe that was a typo on my part. The sheet is showing the correct 3dx5 for a 10cm gun, but when I went to explain it I incorrectly wrote 3dx6 for some reason.

[ericbsmith]

Despite the small number of changes listed, this is actually a pretty significant update as adding the System Quality modifiers affected huge swaths of the sheet.

Version 2.0 Release Candidate 22

-Variety of bug fixes
-Fixed bug where Electromenchanical Computers option wasn't reducing Computer Complexity
-Fixed bug where Campaign Name would not be loaded correctly from a saved ship
-Added new page to the Optional Rules for applying Equipment Quality modifiers to ship systems
-Added System Quality to ship system and weapon mount options

-Updated Optional Rules PDF with new rules.

You can download the spreadsheet here:

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

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

[Rigil_Kent]

This is awesome, man. Much thanks. I use it quite frequently. :D