Steve Jackson Games Forums
Page 26 of 103 « First 1622232425 26 272829303676 Last »
Show 80 post(s) from this thread on one page

Steve Jackson Games Forums (https://forums.sjgames.com/index.php)
-   GURPS (https://forums.sjgames.com/forumdisplay.php?f=13)
-   -   GURPS Spaceships Design Spreadsheet (https://forums.sjgames.com/showthread.php?t=62539)

vierasmarius 09-05-2011 02:45 AM
Re: GURPS Spaceships Design Spreadsheet
 
Oh, there seems to be a bug where a couple other design/display options cause errors in certain fields. At least for ships with large HP totals (>1000) selecting "Use Shortened Numbers" changes the dST/dHP to #VALUE! Additionally, the Self-Healing / Regeneration switch changes the entire Notes field to #VALUE! when activated. (If you couldn't tell, I'm building a Borg Cube)

ericbsmith 09-05-2011 10:24 AM
Re: GURPS Spaceships Design Spreadsheet
 
Version 1.35
-Fixed bug where Cost Multipliers in the Campaign Options weren't working for Ship Systems
-Fixed bug where Use Shortened Numbers would cause a #Value error in dHP/dST and Notes
-Added Burn Points and Thrust Rating to Space Performance profiles
-Added Torpedo Tubes to the Weapon mount choices; added Torpedoes as 'missile' option

See my first post for download links.

Adelus 09-06-2011 05:15 PM
Re: GURPS Spaceships Design Spreadsheet
 
Another minor bug: Uninstalled Weapon Batteries do not seem affected by cost modifier. Using a modifier of x0.15, an uninstalled Secondary battery at SM7 still subtracted -$150k from the price instead of the more expected $22500.

ericbsmith 09-06-2011 08:23 PM
Re: GURPS Spaceships Design Spreadsheet
 
Quote:
Originally Posted by Adelus (Post 1243607)
Another minor bug: Uninstalled Weapon Batteries do not seem affected by cost modifier. Using a modifier of x0.15, an uninstalled Secondary battery at SM7 still subtracted -$150k from the price instead of the more expected $22500.
You're using OpenOffice, aren't you? I'm guessing this is a case of OO and Excel doing things differently.

Adelus 09-07-2011 05:38 AM
Re: GURPS Spaceships Design Spreadsheet
 
Yeah, I am. Other than that I haven't found any new issues, though I'm still trying to put it through its paces.

Adina 09-08-2011 02:23 PM
Re: GURPS Spaceships Design Spreadsheet
 
Couple of questions (on things I can't seem to find):

How do I reduce the number of control stations in a control room? I see a box for this but I can't get it to actually do anything.

Is the option to replace a system with three sytems of the next smallest SM exist? If it does, how do I access it?

Jeff

vierasmarius 09-08-2011 04:22 PM
Re: GURPS Spaceships Design Spreadsheet
 
Quote:
Originally Posted by jmurrell (Post 1244653)
Couple of questions (on things I can't seem to find):

How do I reduce the number of control stations in a control room? I see a box for this but I can't get it to actually do anything.
When you enter a positive integer in that box, it's subtracted from the number of control stations. So for example, to reduce the number of stations in a SM +10 ship from 10 to 7, enter '3' in the box. It will read 'Reduced Control Stations: 3', and the Control Room system will list 7 stations instead of 10. It also automatically adjusts the cost.

Quote:
Is the option to replace a system with three sytems of the next smallest SM exist? If it does, how do I access it?

Jeff
Sadly, at this time that isn't an option. I look forward to when Eric figures out a fix for that, along with reconfigurable systems.

Adina 09-08-2011 10:36 PM
Re: GURPS Spaceships Design Spreadsheet
 
Quote:
Originally Posted by vierasmarius (Post 1244698)
When you enter a positive integer in that box, it's subtracted from the number of control stations. So for example, to reduce the number of stations in a SM +10 ship from 10 to 7, enter '3' in the box. It will read 'Reduced Control Stations: 3', and the Control Room system will list 7 stations instead of 10. It also automatically adjusts the cost.
Ah, I was doing it wrong then. I kept trying to find the checkbox or dropdown menu. Got it now.


Quote:
Sadly, at this time that isn't an option. I look forward to when Eric figures out a fix for that, along with reconfigurable systems.
That makes (at least) two of us.

Jeff

Daigoro 09-09-2011 02:51 AM
Re: GURPS Spaceships Design Spreadsheet
 
Quote:
Originally Posted by ericbsmith (Post 1242667)
There's not really a way to do it, no. I'm not sure how I could implement such a thing easily, as every time I make changes, especially to the options checkboxes, things get moved around such that it would be very difficult to track what goes where.
Have one sheet as an echo of input variables? Is it a feature that could be worked into the 2.0?

ericbsmith 09-09-2011 03:56 PM
Re: GURPS Spaceships Design Spreadsheet
 
Quote:
Originally Posted by Adelus (Post 1243607)
Another minor bug: Uninstalled Weapon Batteries do not seem affected by cost modifier. Using a modifier of x0.15, an uninstalled Secondary battery at SM7 still subtracted -$150k from the price instead of the more expected $22500.
Quote:
Originally Posted by ericbsmith (Post 1243677)
You're using OpenOffice, aren't you? I'm guessing this is a case of OO and Excel doing things differently.
Quote:
Originally Posted by Adelus (Post 1243857)
Yeah, I am. Other than that I haven't found any new issues, though I'm still trying to put it through its paces.
OK, I've updated the OpenOffice version of the sheet which should fix this bug.


All times are GMT -6. The time now is 05:57 PM.
Page 26 of 103 « First 1622232425 26 272829303676 Last »
Show 80 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.