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)

Re: GURPS Spaceships Design Spreadsheet
 

LIGHT FRIGATE
Length: 30 yd. (90 ft.) Crush Depth: 3,333 ft.
Power Points: +8 / -10
Space Performance: sAccel: 4 Gs Hnd/SR: -1 / 5 FTL Rating: FTL-2
Air Performance: aAccel: 4 Gs aSpeed: 500 mph Hnd/SR: -1 / 5


SHIP SYSTEMS
User Notes: The Light Frigate's main duty is to escourt small convoys and squadrons for short durations. Typical crew is two shifts of 1 Pilot, 1 Comm/Sensor Operator, 1 Gunner, and 1 Engineer.
Design Switches, Features, & Notes: 3 Airlocks (Capacity: 3 people each), SHIP OPTIONS: Artificial Gravity, Gravitic Compensators, Stealth Hull, Dynamic Chameleon, [1] Load includes: 0.8 tons of Crew & Passengers, 5 tons of Steerage Cargo, [2] Crew Requirement: 3 Control Stations, 1 Workspaces, [3] All Armor Hardened, [4] Plus dDR 50 Force Screen (dDR 100 if reinforced with second Power Point), [5] FORCE SCREEN OPTIONS: Hardened, ENGINE OPTIONS: FUEL USED: [6] Hydrogen Isotopes, TROOP STRENGTH (TS): 89,400 Classes: Air, Space Features: Night, Sealed


HABITATS
WEAPONS TABLE
[1] Includes +2 for Fixed Mount, [2] Already multiplied by number of mounts
Created using GURPS Spaceship Design Spreadsheet. GURPS Spaceships Design Spreadsheet is copyright © 2009-2012 Eric B. Smith. This spreadsheet is based on information contained in the GURPS Spaceships series of books.

Re: GURPS Spaceships Design Spreadsheet
 

This... is... amazing! One of the biggest challenges I've found with ship design is how to format it for posting on the forums. And you've gone and fixed it for us. Can't wait to try it out!

Re: GURPS Spaceships Design Spreadsheet
 

Okay, not sure if I did something wrong, or what's going on, but I'm getting some bugs in the latest build. Troop Strength is displaying as 0 (despite the vessel having armor, weapons, maneuvering capability, etc); Projectile weapons are displaying Err:502 in their Accel stat; and every line on the Output page is also displaying Err:502. I'm using Open Office 3.3.0.

EDIT: Oh, and the Conventional Gun is also incorrectly getting the "Improved" option, x2 RoF, despite that only being available to energy weapons.

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 12

-Fixed issue with Missile Weapon Accel stat which caused the Output Sheet to error out in OpenOffice
-Corrected Troop Strength, which wasn't taking into account dDR or dHP (only Force Field dDR was being used).
-Corrected weapon RoF to increase with Space Combat Turn Length setting.

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)

I don't see where Improved is limited to energy weapons. In fact, the description of Improved specifically says that this could represent a Multi-Barrel weapon, which could easily be used in the design of a Conventional gun. In fact, the note on the RoF table on p. 58 specifically mentions Improved guns.

Re: GURPS Spaceships Design Spreadsheet
 

Thanks! I'll give it a try again.

Well, it's listed specifically under the Options for Beam Weapons. Rapid Fire and Very Rapid Fire are listed separately for both Beams and Conventional guns. It thus implies that Improved is an option exclusively for energy weapons. Not a big deal though; your argument makes sense too.

Re: GURPS Spaceships Design Spreadsheet
 

See my edit. I also just re-updated because I noticed RoF wasn't taking into account Space Combat Turn Length.

Re: GURPS Spaceships Design Spreadsheet
 

Hmm. I'm still getting both of these errors. All projectiles are still displaying an Error in their Accel stat (and thus spoiling the Output page), and TS is still displaying 0 (unless a Force Screen is present).

EDIT: The fact that having effectively 0 DR causes the TS calculation to return 0 indicates that it may not be including HP correctly in the formula. TS is based on dHP + Avg dDR, multiplied by number of combat systems (weapons + defensive ECM) and factors derived from Hnd and TL.

Re: GURPS Spaceships Design Spreadsheet
 

I should have this fixed now. In fact, I fixed it several times, and something odd is going on with my system because it wasn't saving the changes for some reason.

Re: GURPS Spaceships Design Spreadsheet
 

Nice, looks like it's working now. Thanks for being so patient. =P

EDIT: And as proof, here's the design I was using to test it:

PATROL GUNBOAT
Length: 20 yd. (60 ft.) Crush Depth: 4,000 ft.
Power Points: +4 / -4
Space Performance: sAccel: 2 Gs Hnd/SR: +0 / 4 FTL Rating: FTL-1
Air Performance: aAccel: 2 Gs aSpeed: 354 mph Hnd/SR: +0 / 4


SHIP SYSTEMS
User Notes:
Design Switches, Features, & Notes: 2 Airlocks (Capacity: 2 people each), CAMPAIGN OPTIONS: Armor/Volume Rules (Pyramid 3-34), SHIP OPTIONS: Artificial Gravity, Gravitic Compensators, [1] Load includes: 0.6 tons of Crew & Passengers, 8 tons of Refrigerated Cargo, [2] Crew Requirement: 2 Control Stations, 1 Workspaces, ENGINE OPTIONS: FUEL USED: [3] Hydrogen Isotopes, PERFORMANCE PROFILES: TROOP STRENGTH (TS): 9,200 Classes: Air, C3I, Space Features: Night, Sealed


HABITATS
WEAPONS TABLE
[1] Includes +2 for Fixed Mount, [2] Already multiplied by number of mounts
Created using GURPS Spaceship Design Spreadsheet. GURPS Spaceships Design Spreadsheet is copyright © 2009-2012 Eric B. Smith. This spreadsheet is based on information contained in the GURPS Spaceships series of books.

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 14

-Added descriptive Error messages to the Ship Option checkboxes
-Hooked in campaign option for Stardrive (Reactionless)
-Corrected cost for individually selected Stardrive (Reactionless) engines
-Corrected some Engine Options a little bit better (NMP, Pseudo Velocity, Singularity Drive, and Boost Drive)
-Corrected ship stats for Boost Drive option
-Cleaned up the display of Design Switches, Features, & Notes:
(note: Plan on revamping this one for the final release, when I plan on moving a lot of things around a bit)
-Probably other bug fixes & adjustments


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
 

A late thanks for doing this (I've been away). I can't wait to fiddle with it.

Re: GURPS Spaceships Design Spreadsheet
 

Okay, I see where you added on the design table entries for 1/2 & 1/3 sized systems, but I can't seem to find where you enter exactly what those systems are. It's probably right in front of me, but I can't see it.
BTW, I'm running Open Office 3.3 and I'm pretty sure that I turned on the Macros per your instructions.

Re: GURPS Spaceships Design Spreadsheet
 

I got hung up on that too. After you select the Small Systems module, hit "Refresh Rows" up at the top of the sheet, and the extra rows should appear.

Re: GURPS Spaceships Design Spreadsheet
 

In the current version of the sheet they should pop up automatically, directly beneath the Smaller SM Systems entry. If Macros are working you should be able to hit Refresh Rows to get them to show up.

If you just enabled Macros you may need to close and re-open the sheet to get the automated sheet to work. If Macros aren't working you can still make them show up manually by unhiding the rows.
Tools -> Protect Document -> Sheet... (uncheck)
View -> Column & Row Headers
Then you can select the hidden rows, Right Click and select Show

Re: GURPS Spaceships Design Spreadsheet
 

Nothing seems to be happening. Do the extra rows appear on the design table?

Re: GURPS Spaceships Design Spreadsheet
 

Yes, on the Design Table. Directly below where you'd enter the Smaller SM Systems.

If you click the Optional Rules/Design Table/Campaign Options buttons in the upper-left corner of the sheets does that flip you between the three sheets? If not then Macros probably aren't enabled. You can follow my instructions for manually unhiding the rows or try to get Macros working.

Re: GURPS Spaceships Design Spreadsheet
 

Okay, it seems to be working now. Thanks.

Re: GURPS Spaceships Design Spreadsheet
 

I just uploaded a minor update, so no version increase.
There are two things that changed here:
In Excel:
-The Copy Ship button has been renamed to Import Ship
-The Import Ship window has had a few minor tweaks in appearance and function
In OpenOffice:
-The spreadsheet now has a Security Certificate. If you are not running the sheet from a trusted folder you will be given the option to accept the certificate and enable Macros.

Re: GURPS Spaceships Design Spreadsheet
 

Unless I'm doing it wrong, the ram-rocket option is not affecting the price. I've only tried it with the NTR engine.

Re: GURPS Spaceships Design Spreadsheet
 

It looks like Ionizable Reaction Mass has the same cost as HEDM Rocket Fuel, which it shouldn't.

It also looks like there's a bit of wonkiness with counting up Power Points from smaller subsystems, and counting mps from smaller Fuel Tanks.

Aside from that, the new version 2 looks great! Is there a way to import a version 2 from one sheet to another in Open Office?

Re: GURPS Spaceships Design Spreadsheet
 

It's possible I didn't hook up the cost increase. I'm away from home for a few days, so I'll check it out when I get back.



Reaction Mass has never been included in the cost of the Fuel Tank or ship. I can probably work something up for it though.

I've not seen anything wrong there. Do you have some examples? Note that with Fuel Tanks a smaller Tank is always counted as 1/3 of a larger one, even if the listed tonnage is not actually 1/3 of a larger one.

As I said, at this point I don't have any plans to. I'm not familiar enough with the OpenOffice macro language to make it work.

Re: GURPS Spaceships Design Spreadsheet
 

Thanks. It would be nice to see a fuel-cost-per-voyage stat.

I'll PM you with the location of an example.

Ah, too bad. The excel files don't come out right on my mac.

Re: GURPS Spaceships Design Spreadsheet
 

After some heavy fiddling, I think I've stumbled on a couple more bugs.

• Inconsistencies between crew complement and number of control stations when using a Control Room with reduced stations. It displays the reduced stations correctly on the Control Room system, but in the notes it seems to double the reduction in crew.
• Total Automation not reducing Workspace crew requirement.
• Contragravity system not providing ships with Underwater Performance stats.
• Small Power Points not being properly tallied. Counted as both Normal and Small PP, effectively increasing total by 1.33 per Small PP.
• Power tally includes all powered systems within Reconfigurable systems, instead of just the most draining one.
• Small-sized Defensive ECM and Weapon Mounts not being counted for Troop Strength.
• Cosmic Power and Cosmic Armor not multiplying Force Screen and Armor DR.
• Follow-up damage of Gravitic Focus Conversion Beam not displaying correctly. It gives an error on the design sheet, but seems to display correctly in the Output.
• Force Wings option does not register in the Air Performance stats.
• Extra Zeroes showing up between some lines on the Output.

Here's the test design on which I managed to squeeze in all these bugs:

TEST SPACECRAFT
Length: 100 yd. (300 ft.) Lift: 10 Gs Crush Depth: 10,000 ft.
Power Points: +10 / -14 Small Power Points: -0 / -2
Space Performance: sAccel: 50 Gs / 20,000 mps Hnd/SR: -1 / 5
Air Performance: aAccel: 50 Gs aSpeed: 1,765 mph Hnd/SR: +1 / 5
Water Surface Performance: wSpeed: 20 mph (10 yps) wAccel: 4 mph/s (2 yps/s) Hnd/SR: -2/5


SHIP SYSTEMS
0
Design Switches, Features, & Notes: 6 Airlocks (Capacity: 6 people each), CAMPAIGN OPTIONS: Cosmic Power, Cosmic Armor, Multiscanner Array, SHIP OPTIONS: Total Life Support, Total Automation, [1] Near-C with Ramscoop, [2] Load includes: 2 tons of Crew & Passengers, 500 tons of Cargo Hold, 300 tons of Hangar Bay, [3] Crew Requirement: 6 Control Stations, 13 Workspaces (1 per Full system, 0.0 per Smaller system), 4 Lab Worker, [4] Plus dDR 200 Force Screen (dDR 400 if reinforced with second Power Point), [5] Reduced Control Stations by 2, [6] Multiscanner Array, [7] FORCE SCREEN OPTIONS: Force Wings, CAMPAIGN FORCE SCREEN OPTIONS: Adjustable, FUEL USED: [8] Any Fuel, TROOP STRENGTH (TS): 3,600,000 Classes: Air, C3I, Space Features: Night, Sealed
0
0
HABITATS
0
WEAPONS TABLE
Created using GURPS Spaceship Design Spreadsheet. GURPS Spaceships Design Spreadsheet is copyright © 2009-2012 Eric B. Smith. This spreadsheet is based on information contained in the GURPS Spaceships series of books.

Re: GURPS Spaceships Design Spreadsheet
 

Okay, just a few more bugs:
•Boost Drive option gives incorrect velocity (a flat X mps per engine instead of X * Accel mps).
•Nautical Lines not reducing Air Speed (should be 1/5 of normal Streamlined speed).
•Underwater Performance registers as equal to Water Performance, despite them being different in most cases.
EDIT: •NPC Filters Only, No Life Support and Magical Life Support aren't multiplying number of Cabins in Habitat.

Overall it's working very well! I just built a massive psionic soul-eating space lobster-squid. Because I can (thanks to your excellent spreadsheet).

Re: GURPS Spaceships Design Spreadsheet
 

If you find any more issues then keep them coming. I've managed to correct a few of these tonight, but it's time for some sleep. I'll pick up tomorrow and see if I can get all these issues taken care of.

Re: GURPS Spaceships Design Spreadsheet
 

Another small batch, which I'll just tack on the end here:
•Cargo Hold in Weapon Mounts displays an error in the Acc column and on the Output page
•Reactionless Stardrives don't count their Thrust towards Air Performance
•Sapient Brain (Psionic) doesn't provide a Psi Power Point
•Super-Soldier option doesn't double TS

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 15

-Added Drop Capsule Launcher system
-Added Garage w/Vehicle to Habitat Modules

(See the Optional Rules page for descriptions of both)

-Addressed the following errors:
• Power tally includes all powered systems within Reconfigurable systems, instead of just the most draining one.
• Small-sized Defensive ECM and Weapon Mounts not being counted for Troop Strength.
• Cosmic Power and Cosmic Armor not multiplying Force Screen and Armor DR.
• Small Power Points not being properly tallied. Counted as both Normal and Small PP, effectively increasing total by 1.33 per Small PP.
• Follow-up damage of Gravitic Focus Conversion Beam not displaying correctly. It gives an error on the design sheet, but seems to display correctly in the Output.
• Reactionless Stardrives don't count their Thrust towards Air Performance
• Sapient Brain (Psionic) doesn't provide a Psi Power Point
• Cargo Hold in Weapon Mounts displays an error in the Acc column and on the Output page
• NPC Filters Only, No Life Support and Magical Life Support aren't multiplying number of Cabins in Habitat.
• Force Wings option does not register in the Air Performance stats.
• Super-Soldier option doesn't double TS
• Total Automation not reducing Workspace crew requirement.
• Inconsistencies between crew complement and number of control stations when using a Control Room with reduced stations. It displays the reduced stations correctly on the Control Room system, but in the notes it seems to double the reduction in crew.
• Nautical Lines not reducing Air Speed (should be 1/5 of normal Streamlined speed).
• Boost Drive option gives incorrect velocity (a flat X mps per engine instead of X * Accel mps).
• Contragravity system not providing ships with Underwater Performance stats.
• Underwater Performance registers as equal to Water Performance, despite them being different in most cases.
• Extra Zeroes showing up between some lines on the Output.
• Ram Rocket cost multiplier not counted



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

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

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

Re: GURPS Spaceships Design Spreadsheet
 

Note that while I should have addressed all of these errors, a double-check to make sure that I actually did, and did so correctly, would be appreciated.

Re: GURPS Spaceships Design Spreadsheet
 

Awesome! I'll take a look at it soon.

Re: GURPS Spaceships Design Spreadsheet
 

Sweet. I was kvetching for some kind of drop capsule before, so nice to see an inclusion.

Would it be uncouth to offer suggestions for other optional systems and rules?
Ones I'd come up with before were Armoury, Shooting Range and Danger Room habitats.

Re: GURPS Spaceships Design Spreadsheet
 

I've found a couple bugs that have persisted:
• Power tally includes all powered systems within Reconfigurable systems, instead of just the most draining one.
• Reactionless Stardrives don't count their Thrust towards Air Performance.

And a new one:
• Troop Strength includes all weapons in Reconfigurable Systems, rather than max one per set.

Re: GURPS Spaceships Design Spreadsheet
 

I should be able to fix this, but it's going to wind up with an issue that I just don't care enough to worry about.

If you leave uninstalled weapons in a reconfigurable battery it's going to seriously mess up troop strength, because the sum of all uninstalled mounts is subtracted from total batteries. e.g. if you put two Medium Batteries in a Reconfigurable system, then mount one weapon each in them you will wind up with 2 (total number of batteries) - 1.3333 (for having four uninstalled medium mounts) -1 (number of redundant reconfigurable) = -0.3333 weapon batteries.

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 16


Fixed with the above caveat:
• Troop Strength includes all weapons in Reconfigurable Systems, rather than max one per set.
Fixed:
• Power tally includes all powered systems within Reconfigurable systems, instead of just the most draining one.
• Reactionless Stardrives don't count their Thrust towards Air Performance.

Thought I got the Reactionless Stardrive last time; forgot about the Campaign Reactionless option.

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 17

-Added section just below the Ship Options to list the Fuel onboard the ship, cost of the fuel, and cost to refuel ship.
-Cleaned up fuel used of some systems; added a few new Fuel Tank types. In particular, Hydrogen, Antimatter-Catalyzed Hydrogen, and Antimatter-Boosted Hydrogen have been listed separately.

-In Excel improved performance of core macro. Sheet changes should cause less recalculation time; in particular setting or changing ship TL and SM will be significantly faster.
-In OpenOffice modified the row show/hide for Reconfigurable & Smaller SM systems. Selecting one of those systems will now cause the [a] rows to show; making further sheet changes will make [b] & [c] rows show.

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 18

-Further improvements in the Core Macro in both Excel and OpenOffice. I believe I eked out something like a 20% speed improvement in the responsiveness after making a selection in both sheets by making what was, really, a simple modification to the code.

-In Excel added ability to save the current ship into a storage sheet, then reload any ship from the storage sheet back into the main Design Table. Ships in the storage sheet are shown on the Saved Ships table, where you can browse the saved ships presented on a standard GURPS Spaceships/Vehicles table. The table can be sorted by ship Name, SM, or TL. Currently I have saved into the sheet two ships from Spaceships 1 - the Midnight Sun Orbiter and Star Flower tramp freighter.
You can also import all saved ships from an existing sheet, so future compatibility is ensured. When importing ships, the ships are added to the existing ones, only overwriting if the ship names are identical and you tell it to overwrite.


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

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

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

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 19

-No update for the OpenOffice sheet. All the work here was to the various Excel Macros.

-Continued development of the 'Save Ship to Sheet' in Excel. Finished work on the import functions, including complete error trapping (typing incorrect values into the various dialogs should now produce informative message boxes rather than causing debugging errors).
-You can now copy the 'Saved Ships' sheet and save ships into each sheet separately. Useful to do things like have one sheet to save ships from different campaigns, TL's, or empires into.
-Added a second Saved Ships sheet called 'Official Ships'. This contains the three ships from Spaceships 1 and the first half-dozen ships from Spaceships 2.

Re: GURPS Spaceships Design Spreadsheet
 

Ornithopters again. Apparently the latest OpenOffice sheet does not set a speed limit for ornithopters at all. Though it inspired me to allow superscience TL10^ wings that don't have a speed limit.
Is it possible to get a field or a checkbox that brings back a speed limit? Could come in handy for some versions of reactionless drives (e.g. Star Wars).

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.00 Beta 20

-Many minor bug fixes
-Added intermediate SM's. A ship of intermediate SM has twice the mass of the previous SM ship, but is treated as the next higher SM for purposes of being targeted or detected. So a SM+8.5 ship has a Loaded Weight of 2,000 tons (twice that of a SM+8 ship) but is considered SM+9 for purposes of attack and detection. All other statistics are extrapolated from the existing systems.


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

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

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

Re: GURPS Spaceships Design Spreadsheet
 

Possible Bug:
I'm not getting all available armor above Advanced Metallic Laminate on SM +4/4.5 ships when TL is set to 9(^) or 10(^). (Using 2.00 Beta 20)

Overall, the spreadsheet is amazing. I especially like the new 1/2 SM feature- it helps a lot for statting ships from fiction. Thanks!

Re: GURPS Spaceships Design Spreadsheet
 

It does look like a couple of the Armors were incorrectly labeled as unavailable below SM+5. I've just uploaded a fixed version of the Excel sheets (which also fix numerous other minor errors); the OpenOffice sheet will get updated eventually. In the meantime you can always check the "Don't Filter available systems by SM" checkbox in the upper-left of the Design Table.

Re: GURPS Spaceships Design Spreadsheet
 

Am I the only one who gets a directory/folder out of unzipping the OOO version of the spreadsheet? Is it just my Mac being overzealous? It's like it unpacks the ODS file into a directory...

Re: GURPS Spaceships Design Spreadsheet
 

I get the same with the .zip file, but the .7z works fine.

Re: GURPS Spaceships Design Spreadsheet
 

ODS file are really just renamed ZIP files containing a bunch of XML data file inside. So really what you have is a collection of XML files inside a ZIP file inside a ZIP file. If your unzipping program is being overzealous it might be recognizing the ODS file as having the header of a ZIP file so it decides to continue to decompress that as well. The real answer here is to either change setting in your unzipping program or find a better program.

Re: GURPS Spaceships Design Spreadsheet
 

I figured that must be the case - but unfortunately, I'm not sure it's a program that I added, but rather the default, built in uncompress tool that comes with Mac OS X 10.6. I'll see about getting a 7z program instead, as that'll likey be better behaved.

Also, a note - the Excel 2007 version is far from successful in Excel 2011 for Mac - slow and riddled with macro execution errors. I blame this version of Excel. I always wind up using the ODS instead.

Re: GURPS Spaceships Design Spreadsheet
 

That's too bad. I write the sheet in Excel 2000, saving in Excel 97-2003 format (which is the old standard). I then update and test it in Excel 2007 (which I do, basically, by opening the sheet in Excel 2007 then Saving as Excel 2007 format). If it's breaking down in Excel 2011 (Mac or otherwise) it's definitely a case of Microsoft not ensuring backwards compatibility.

You might try opening the Excel 2000 version in Excel 2011, that may work a little better assuming MS maintained compatibility. At any rate, because of the Macros the Excel version is functionally superior to the OpenOffice version because of it's ability to Save/Load ships into the Save Sheets and to Load ships from another spreadsheet. I don't know when, or if, I'll attempt create similar Macros for OpenOffice.

I'm currently in the process of importing all the ships from the books; I've got about 100 done and 150 to go - the reason for this is two-fold; first it's nice to have the ships available to quickly load (at least in Excel). Second, and probably more importantly, I keep finding errors because of the varied designs as I input them. I've also found more than a few cases of the book being wrong (and am beginning to regret not keeping a log of errata; I especially love the designs that either omit a core section or double-load one of the other sections).

Re: GURPS Spaceships Design Spreadsheet
 

That's a great addition! Thanks, it'll give me a lot more flexibility. Personally, I'd love to see rules for SM+3 (WW2 fighter) sized ships, but I don't know how viable that is.

Re: GURPS Spaceships Design Spreadsheet
 

I've worked on these a bit (all the way down to SM+1, really), and they're relatively viable. You just need to change a few things around so they work properly. Never did get around to writing up the rules for 'em, though:/

Re: GURPS Spaceships Design Spreadsheet
 

Understandably you'd not be able to do much with Habitats at those sizes, but honestly, that's realistic. Are there other components (other than scaled down weapons) that need to have rules written for them to define what happens at SM+3 and lower? If we can have convincing SM+1 and even +0 "ships" we could be on our way to statting up missiles themselves as separate ships that we keep in a special hangar...

Re: GURPS Spaceships Design Spreadsheet
 

Damage and DR would need to switch from decade scale to normal, but that's not a big deal. More challenging would be the Control Room, for which the computer and sensors will continue to scale down, but the crew station will not. For very small craft a single crew or passenger seat will exceed 1 system slot. I suppose one way to handle this is to make a "Control System", which is basically a Control Room without the seat, and scales normally with the craft, then add stations as (pricier) Passenger Seats. An SM+4 Passenger Seat system carries a single occupant, so a single SM+3 seat would take up 3 slots, and an SM+2 one takes up half the craft. They could probably be made more compact, at the cost of comfort and life support. An SM+1 seat might even be external, making the vehicle a motorcycle or similar.

Re: GURPS Spaceships Design Spreadsheet
 

SM+4 Habitats are already 0.1 slots; at SM+3 they'd be 0.03 slots, far too small to do anything. A 1/2 habitat module would take up 17 out of 20 ship system slots.

Weapons would scale alright. We already have stats for guns down to 2cm and beams down to 3kJ, even though the only way to hit those sizes is to use Rapid Fire and VRF weapons. So if you assume that no VRF isn't available we don't fall below that floor; even with VRF we usually don't hit the floor on many weapon types.

To go below SM+3, yeah probably. At SM+3 you might be able to get away with keeping the decade-Scale damage and dDR, but choices of weapons and armor are artificially limited because values drop below the decade-Scale resolution.

This. Actually, there's only so far the computer and sensors can scale down and still be useful. A SM+3 ship would be 3 tons; each system is 300lbs, which you can easily fit a basic seat and person into (without the fancy things like G-cushions and life support).

The real problem is that Spaceships was designed to scale from SM+5 to SM+15. It scaled to SM+4 pretty well; it scales above SM+15 alright (although stats for really large ships get funky). I'm just not sure that it can go much smaller.

Re: GURPS Spaceships Design Spreadsheet
 

Is there a way to make specific systems available or unavailable as an exception to overall TL? E.g. Ether Furnace is normally unavailable in TL9^ campaigns, and only available in TL5+2^, AFAIK. Can I somehow re-enable it for a given campaign (in the campaign options, I assume).

Re: GURPS Spaceships Design Spreadsheet
 

No, not for a specific system you cannot. You have to check "Don't filter by TL" to see it on the list. Note that, in most cases, you can add the system then turn the filtering back on and the system will continue to work fine, with the statistics of the appropriate TL (either the lowest TL it can normally be or the TL of the ship).

Re: GURPS Spaceships Design Spreadsheet
 

Yeah, at SM+2 or less, you'd be looking at control spaces that were just 100 pounds or less. But like you did with Habitats, you could put three spaces together to get back to the 300lbs "single seat with a HUD" style of control room you have in the SM+3. And leave SM+1 and SM+0 for full automation - drones, remotes or missiles of some manner, maybe?

Re: GURPS Spaceships Design Spreadsheet
 

Don't forget that not all Gurps characters are SM 0.

Re: GURPS Spaceships Design Spreadsheet
 

Currently, there are no rules in Spaceships for scaling anything away from SM 0 occupants.

Re: GURPS Spaceships Design Spreadsheet
 

Habitats are counted as SM larger or smaller based on the SM of the inhabitant.
For SM +3 race SM + 7 habitat counts like a SM + 4 ship.

Re: GURPS Spaceships Design Spreadsheet
 

I figured for SM+3 ships, maybe you could require three spaces for a control room or passenger seat & only allow spinal mounted weapons as a way to avoid scaling those things down.

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.0 Release Candidate 1

-Again, many minor bug fixes
-Incorporation of most of the Transhuman Space specific rules from Spaceships 8.
-Loaded all ships through Spaceships 1-4 into the Official Ships save sheet.
-Addition of recording area to track Open Spaces in the Design Table


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

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

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

Re: GURPS Spaceships Design Spreadsheet
 

Hi, sorry if this is explained elsewhere, but does this work well with open office now? I saw some posts early on that it doesnt, then later it does somewhat. Im just very confused when I try to do anything. Some fields have drop down boxes with info, others are blank and wont let me type anything in. Not sure if the intent is to just print it out and write everything by hand.

Re: GURPS Spaceships Design Spreadsheet
 

The latest version of the sheet is fully compatible with Open Office; earlier versions had issues. You do need to enable Macros in Open Office to get the most out of the sheet though. Macros can be enabled either by accepting my Self Signed Digital Signature or by creating an exception for the folder you save the sheets in:
Tools -> Options -> Security -> Macro Security (button) -> Trusted Sources (tab) -> Trusted file locations (Add button)


Any field which has a light-grey background can be modified by the user. Any field which has a white or dark-grey background will automatically be filled by the sheet. Some fields become "active," that is they turn grey, based on information you've already added to the sheet (most don't become active until after you've filled in TL and SM; after that Habitat Modules and Weapon Systems won't become active until after you've added Habitat systems or Weapons Batteries to the Ship Systems).

There should be no need to hand-write anything in -- the whole point of the sheet is that it automatically fills in all the relevant details for you.

Re: GURPS Spaceships Design Spreadsheet
 

Ahh! It was the SM. Soon as I picked one lots of options opened up, I think that was holding me back. Thanks alot, Im not terribly familiar with OO so I thought it was me. Also, a million thanks for making this, a great tool.

Actually one last question, any way to change the length after SM is picked? I want the ship streamlined but its doubling the length, which is too much for my purposes.'

thanks again

Re: GURPS Spaceships Design Spreadsheet
 

No, not currently, though you could note the difference in the User Notes section.

Re: GURPS Spaceships Design Spreadsheet
 

Ya, I was worried it might come back to bite me somewhere down the line but I guess nothing else is really dependent on that number. Ill go muck about now, maybe come back confused later. Thanks

Re: GURPS Spaceships Design Spreadsheet
 

Hi,
In version 2, candidate one I've found that when I try to choose the type of fuel that I have in a fuel tank a bunch of #VALUE things show up in various cells. If I just take fuel tank it's fine. BTW I'm using Open Office.

Re: GURPS Spaceships Design Spreadsheet
 

Yup, and it's a bug that only affects the OpenOffice version. I've fixed it and re-uploaded the sheet. (Stupid differences between OO and Excel)

Re: GURPS Spaceships Design Spreadsheet
 

Cool. Thanks a lot.

Update: Just letting you know that the bug is gone.

Re: GURPS Spaceships Design Spreadsheet
 

Version 2.0 Release Candidate 2

-More bug fixes than I can count. Mostly minor, or specific circumstances.
-Added more options/features for handling Transhuman Spaceships
-Finished loading all ships from all 8 Spaceships books into the Official Ships sheet. 245 ships, plus another dozen example ships in the Saved Ships sheet. Now I just need to figure out how to load these ships into the Design Table in OpenOffice...


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

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

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

Re: GURPS Spaceships Design Spreadsheet
 

I'm getting a weird Drop Shadow from some boxes on the locked upper bar.
Specifically on the options:
Show Design Switches&Features
Show Ship System Options
Disable Core Macro
Use Shortened Numbers

Any idea how to fix it?
(Btw, last time we had problems regarding my Portuguese Windows and Portuguese installation, everything is in English now, both my windows installation and my excel.

Thanks.

Re: GURPS Spaceships Design Spreadsheet
 

Helicopter rotors are not in the list if SM=+4. They work normally if added manually.
Also, helicopters are listed as having a top speed of (e.g.) 200, but zero acceleration. So they never reach their speed, eh?

Re: GURPS Spaceships Design Spreadsheet
 

The former is likely a minor bug in the sheet. The later is more a problem with Spaceships 7, which doesn't list an acceleration for Helicopter Rotors.

EDIT: The current version of the sheet, RC2, does list Helicopter Acceleration as 10mph/s per Rotor system installed.