05-16-2012, 06:42 PM | #401 |
Join Date: Oct 2004
|
Re: GURPS Spaceships Design Spreadsheet
Eric... this is fantastic! Thank you a million times for making this :) The SM-1 and Half-size modules make life awesome. :) Especially if you and your gaming buddies have a fondness for absurdly huge warships with lots of systems.
That said though, I'm still a bit swamped by the number of peripheral guns by the time you get to the bigger SM's .. around 17 or so. By the time you get to something like SM 24 you end up with quite literally billions of point defense guns -- which has a certain appeal, "My 33 billion point defence guns open fire, bwhahaha!" but its a bit tricky to actually manage. :) Would it be possible to have another 'layer' of guns, say, between tertiary and peripheral? Say, "quarternary" that are a SM-minus-whatever that show up past a certain SM size that will have maybe around 10,000-100,000 guns? Thats an idea/suggestion anyway. Thanks again Eric! Very awesome. |
05-16-2012, 06:58 PM | #402 |
Join Date: Nov 2009
Location: Oregon
|
Re: GURPS Spaceships Design Spreadsheet
A small suggestion: to have a larger number of small-sized systems on a truly massive ship, you could make "equipment pods" which are basically ships in their own right, carried in Vehicle Bays. 2 adjacent bays can fit one "ship" of SM X-2, while a single bay can hold 5 ships of SM X-4. Each carried ship would be a simple armored pod, loaded with whatever equipment is desired, but lacking propulsion or a control room. One advantage of this is that it could allow equipment pods to be easily swapped out. You could alternately declare that they are permanently installed, but are fully protected by the larger ship's armor.
So if you have a SM 24 (ginormous) Battle Ship, it could carry 5 SM 20 pods (each armed with a dozen or more SM 20 Tertiary batteries) instead of a single SM 24 battery. The only difficulty here is that you'd need a separate sheet for the pods themselves. It works best if the bigger ship carries a large number of identical pods. Basic stats for the pods can be recorded in the Notes section of the mothership. |
05-17-2012, 06:48 PM | #403 | |||
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Quote:
Quote:
I've thought about it. In fact, I started adding another size of weapon but realized it was going to take a lot of work to do it correctly so I wound up dropping it. It's still something I would like to do, and when I do get around to it I'll probably add several smaller sizes of weapon mount, but it's not something I'm likely to get around to too soon.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. |
|||
05-17-2012, 06:50 PM | #404 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
I forgot to post this the other day when I uploaded the sheet.
Version 2.0 Release Candidate 3 -Fixed issue where weapon stats were not correct for certain sizes of weapon -Many other minor bug fixes. 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)
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. Last edited by ericbsmith; 05-06-2013 at 09:48 PM. |
05-19-2012, 09:23 AM | #405 | |
Join Date: Oct 2004
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
EDIT: Actually a thought occured to me, there is an option to use Cargo for reaction mass, which really can be helpful on the more realistic sort of fuel burning designs... would it be possible to have an option to use Steerage cargo from habitates or unused turrets as reaction mass as well? It would make some of that unused space more useful. Awesome if possible :) Thanks Eric! Last edited by SalsaDoom; 05-19-2012 at 09:45 AM. Reason: Adding a suggestion :) |
|
05-26-2012, 08:58 AM | #406 |
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
|
Re: GURPS Spaceships Design Spreadsheet
Just finished playing around with Candidate 3. Looks good. Just a few suggestions. Could you please
Dalton "adding his 2 bits to the wishlist" Spence
Last edited by DaltonS; 05-26-2012 at 01:26 PM. Reason: Added a *few* more bits. :) |
05-26-2012, 02:08 PM | #407 | |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
2) I'll think on that. I'll probably add an "atmospheres" listing along with the depth. 3) Already assumes "streamlining" if you have Force Wings for Air Performance 1 & 2, not streamlined for 3 & 4 (unless the ship actually has the streamlining option, in which case all profiles naturally assume streamlining). 4) What numbered items, specifically, are you seeing show up or not show up. Remember that each number does not get it's own line; some similar items are grouped together (such as all Armor/DR/Force Screen options being on the same line, or all Fuel Used being on a single line) (p.s. if you're using Excel and can give me an example ship from the ones saved that would be useful) 5)<tr> is missing, I can fix that. I think it's only missing in the top table - do you see anywhere else I missed something like that? While NOWRAP is not needed in most cells, it is needed for some of the cells. And I didn't want to make the coding any more difficult by having to test whether it is necessary for all of them or not so I just used NOWRAP in all cells. HTML doesn't care about superfluous tags like that, and frankly I'm not too worried about them so long as it's properly formatted.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. Last edited by ericbsmith; 05-26-2012 at 04:39 PM. |
|
05-29-2012, 09:25 PM | #408 |
Untagged
Join Date: Oct 2004
Location: Forest Grove, Beaverton, Oregon
|
Re: GURPS Spaceships Design Spreadsheet
I checked Don't filter available systems by SM and it still goes black with error about SMs when I put in a Plasma Sail.
It's because I'm making a ship larger than SM+12.
__________________
Beware, poor communication skills. No offense intended. If offended, it just means that I failed my writing skill check. Last edited by Flyndaran; 05-29-2012 at 09:29 PM. |
05-29-2012, 10:30 PM | #409 |
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
|
Re: GURPS Spaceships Design Spreadsheet
Yup, and Plasma Sails are limited to SM+12. While the "Don't Filter" can make some items available at SM or TL in the drop down menu, it doesn't make up stats for them. If an item is unavailable at SM+13 then it's unavailable at SM+13.
__________________
Eric B. Smith GURPS Data File Coordinator GURPSLand I shall pull the pin from this healing grenade and... Kaboom-baya. Last edited by ericbsmith; 05-29-2012 at 10:37 PM. |
05-30-2012, 09:38 AM | #410 | |
Untagged
Join Date: Oct 2004
Location: Forest Grove, Beaverton, Oregon
|
Re: GURPS Spaceships Design Spreadsheet
Quote:
Edit: I'm tired, and not sure if the above sentence makes sense.
__________________
Beware, poor communication skills. No offense intended. If offended, it just means that I failed my writing skill check. Last edited by Flyndaran; 05-30-2012 at 09:46 AM. |
|
Tags |
design, game aids, gurpsland, program, sheet, spaceships, spreadsheet |
|
|