Re: GURPS Spaceships Design Spreadsheet
 

"Maneuver Enhancements?" What do you mean by that?
EDIT: Never mind - Ship System from Spaceships 7. I'd forgotten all about Maneuver Enhancement system and hadn't included the bonus in the Air Handling rating. Fixed for the next release.
EDIT 2: Looks like I never plugged in "base" Handling (from p. 9 of Spaceships), though I did use "base" SR. So all Handling numbers are wonky.

Re: GURPS Spaceships Design Spreadsheet
 

Ok, cool. I just thought I was missing something obvious again. Thanks for responding so fast as well.

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 6

-Fixed several issues with ship Handling statistic
-Fixed some minor issues with Magical/Psionic Powered systems
-Probably some other stuff.

Excel 2000
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (1.86MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (771KB)

Excel 2007
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (2.30MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (2.23MB)

OpenOffice 3.3.0
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (1.61MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (1.37MB)

Re: GURPS Spaceships Design Spreadsheet
 

Awesome, you are a machine! ;)

Re: GURPS Spaceships Design Spreadsheet
 

Hmm, the Open Office .7z link doesn't seem to be working...

Re: GURPS Spaceships Design Spreadsheet
 

You are the king of bad timing. I was literally in the middle of uploading the Beta 7 just a few minutes ago :-)

Version 2.00 Beta 7

-More bug fixes
-Added some Narrow/Normal/Wide Width buttons to the Excel sheets
-Improved functionality of the Disable Core Macro in the Excel sheets
-Added a Disable Core Macro checkbox to the OpenOffice sheet

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 9
-Fixed issue with Spinal Mounts not being counted (in OpenOffice) and with Power not being defined properly (in all sheets)
-Added capability to Excel sheets to import ships from previous versions. Note the Copy Ships button along the top/right of the Design Table

You should be able to import ships from the last several Betas*. You should also be able to import ships from v1.40c, and back to at least v1.37 as that's the last time I moved the Options checkboxes around. You may be able to import from earlier sheets, but some of the Ship options may be hit or miss.

You need to open both sheets in the same instance of Excel then click Copy Ships and fill out the form with the correct file and worksheet names. The rest should be automatic. I'd really appreciate it if anyone with ships done up in v1.37-1.40c could import them and look for differences/problems between the older sheet and the newer Beta.


* I did a format change somewhere along the line which means the import won't work with all previous Betas. Unfortunately I haven't been archiving the previous Betas as I go along, so I don't know where I made the change.

Note also that I have no plans to do a similar import function for OpenOffice at this time. This was a much larger project for Excel than I had expected, and I know the macro language much better than I do for OpenOffice.

Excel 2000
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (1.86MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (771KB)

Excel 2007
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (2.30MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (2.23MB)

OpenOffice 3.3.0
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (1.61MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (1.37MB)

Re: GURPS Spaceships Design Spreadsheet
 

Oh sweet jesus, you are my hero! I can't wait to open this and poke at it with a stick!

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 10
This will probably be the last Beta posting for a little while; I'm starting to feel a little burned out. I've also manage to clear out pretty much all my my major concerns, so unless people start noticing some bugs to quash I'm good for now.

-Cleaned up the Copy Ship import code a little more. You can now import different sections of the ship selectively, leaving the existing ship intact. So you could import the Campaign Options and nothing else, or the Ship Systems but not the Ship Options. By skipping the Campaign Options and Ship Options I was able to successfully import several ships from v1.30

-Fixed a few more bugs - Ammunition cost was off, as was Occupancy. sAcc on the weapons table was thoroughly messed up, and MPS was incorrect as well.
-Factories were incorrectly rated as Tons of production instead of $ of production.


Excel 2000
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (1.86MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (755KB)

Excel 2007
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (2.30MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (2.23MB)

OpenOffice 3.3.0
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (1.7MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (1.47MB)

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 11
- Added output sheet with support for Plain Text, HTML, and BBCode (forum posting)
A Sample BBCode output provided in next post.

Excel 2000
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip (1.86MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z (755KB)

Excel 2007
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.zip (2.30MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-2007.7z (2.23MB)

OpenOffice 3.3.0
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.zip (1.7MB)
http://gurpsland.no-ip.org/zip/SpaceshipsV2-Ooo.7z (1.47MB)