Re: GURPS Spaceships Design Spreadsheet
 

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

Re: GURPS Spaceships Design Spreadsheet
 

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

Re: GURPS Spaceships Design Spreadsheet
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

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

Re: GURPS Spaceships Design Spreadsheet
 

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

Re: GURPS Spaceships Design Spreadsheet
 

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

Re: GURPS Spaceships Design Spreadsheet
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

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

Re: GURPS Spaceships Design Spreadsheet
 

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.

Re: GURPS Spaceships Design Spreadsheet
 

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.

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