GURPS Spaceships Design Spreadsheet

[ericbsmith]

Just posted Version 1.19c with even more bug fixes. Still in the beta stage, still with the beta links:

http://gurpsland.no-ip.org/zip/Spaceships119.zip

http://gurpsland.no-ip.org/zip/Spaceships119.7z

[Mgellis]

Originally Posted by ericbsmith

Just posted Version 1.19c with even more bug fixes. Still in the beta stage, still with the beta links:

http://gurpsland.no-ip.org/zip/Spaceships119.zip

http://gurpsland.no-ip.org/zip/Spaceships119.7z

Eric, I think I may have spotted an error. It looks like some of the systems like Power Plants that do not normally have crew requirements are being listed with crew requirements. I think the Normal ("some automation") setting for crew requirements just isn't working anymore...the spreadsheet is either setting it as "Lacks Automation" or "Total Automation." It may show it as "No Automation" but it is treating it as "Lacks Automation." I don't know how to turn the switches "off" and get back to the "normal" setting.

The error does not occur in my copy of earlier versions of the spreadsheet.

I hope this helps.

Mark

[ericbsmith]

Yup, looks like I jumbled up the Workspace requirements when I added the Lacks Automation code in. I'll post an update at some point later today.

Originally Posted by Mgellis

I hope this helps.

Very much so, thanks. Let me know if you spot anything else.

[Mgellis]

Originally Posted by ericbsmith

Yup, looks like I jumbled up the Workspace requirements when I added the Lacks Automation code in. I'll post an update at some point later today.

Very much so, thanks. Let me know if you spot anything else.

Will do. Thanks again for putting this spreadsheet together; it's lots and lots of fun.

[Mgellis]

Quick question...should a damage multiplier OR an MPS statistic be listed for electromagnetic guns (2 MPS = 2 x listed damage) and grav guns (5 MPS = 5 x listed damage)?

[ericbsmith]

Originally Posted by Mgellis

Quick question...should a damage multiplier OR an MPS statistic be listed for electromagnetic guns (2 MPS = 2 x listed damage) and grav guns (5 MPS = 5 x listed damage)?

Umm, I'm not sure. Can you give me the page reference for that?



Also, just uploaded Version 1.19d. Even more bug fixes, and a couple more minor additions.

http://gurpsland.no-ip.org/zip/Spaceships119.zip

http://gurpsland.no-ip.org/zip/Spaceships119.7z

[Langy]

Quick question...should a damage multiplier OR an MPS statistic be listed for electromagnetic guns (2 MPS = 2 x listed damage) and grav guns (5 MPS = 5 x listed damage)?

An MPS statistic should be listed for all ballistic weapons. Conventional guns are 1 MPS, electromagnetic guns 2 MPS, and grav guns 5 MPS. This is the minimum relative velocity, page 59 of Spaceships.

[Mgellis]

I keep getting an error message when I use the first system of the central hull on the new spreadsheet. It happens for some systems (armor, etc.) but not all. The debugger points to this code...

'HideRows

For HiddenRow = 1 To 206

If ActiveSheet.Cells(HiddenRow, 1) = 0 Then
Rows(HiddenRow).EntireRow.Hidden = True
Else
Rows(HiddenRow).EntireRow.Hidden = False
End If

Next HiddenRow

Range("B5").Select

ActiveSheet.Unprotect
End If

I have no idea what any of this means, but the line that keeps getting highlighted as a troublemaker is...

If ActiveSheet.Cells(HiddenRow, 1) = 0 Then

Anyway, I hope this helps.

Mark

[Mgellis]

Quick question...will you be able to add the design switches for Spaceships 8: Transhuman Space any time soon? I think there are only a couple of them; the one that's really important is the advanced computer one. Thanks.

[ericbsmith]

Originally Posted by Mgellis

I keep getting an error message when I use the first system of the central hull on the new spreadsheet. It happens for some systems (armor, etc.) but not all. The debugger points to this code...

That's part of the Core Macro, which I have written and rewritten about a dozen times now trying to tweak it. I've made another significant change to it for the next release, which may alleviate the error message you're seeing.

Originally Posted by Mgellis

Quick question...will you be able to add the design switches for Spaceships 8: Transhuman Space any time soon? I think there are only a couple of them; the one that's really important is the advanced computer one. Thanks.

I don't know. I haven't even read Spaceships 8 yet, so I don't know how the design switches affects anything.