Steve Jackson Games - Site Navigation
Home General Info Follow Us Search Illuminator Store Forums What's New Other Games Ogre GURPS Munchkin Our Games: Home

Go Back   Steve Jackson Games Forums > Roleplaying > GURPS

Reply
 
Thread Tools Display Modes
Old 09-28-2020, 12:12 AM   #981
ericbsmith
 
ericbsmith's Avatar
 
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
Default Re: GURPS Spaceships Design Spreadsheet

Version 2.0 Release Candidate 32
-Fixed another bug preventing the Calculate Troop Strength from being turned off on the output.

Version 2.0 Release Candidate 31
-Fixed critical error where Output sheets would error out and be unusable when certain ship systems under certain circumstances (Mixed Weapon Battery, Equipment Packs, possibly Reconfigurable system). This had to do with incorrectly counting total number of ship systems for calculating Protection Factor (PF) which could then cause the PF note to error out.
-Fixed a couple other minor bugs.

You can download the spreadsheet here:

Excel 2000 (RC32)
http://gurpsland.no-ip.org/zip/SpaceshipsV2.zip
http://gurpsland.no-ip.org/zip/SpaceshipsV2.7z

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

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

Spaceships Optional Rules (RC29)
http://gurpsland.no-ip.org/pdf/Space...ionalRules.pdf
__________________
Eric B. Smith GURPS Data File Coordinator
GURPSLand
The future keeps telling us what the past was about. You make the past mean different things by what you do with the time that comes after.

Last edited by ericbsmith; 09-28-2020 at 03:59 PM.
ericbsmith is offline   Reply With Quote
Old 09-28-2020, 09:38 AM   #982
DaltonS
 
DaltonS's Avatar
 
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
Default Re: GURPS Spaceships Design Spreadsheet

I noticed the most recent release contained an updated version of the SpaceshipsOptionalRules.pdf file but when I looked it was still labeled RC29. Have you actually made any changes to the Optional Rules sheet since then (aside from the version number I mean)? This isn't just an idle question. I recently (because I was bored I'll admit) manually created a .docx file from the text of that sheet. The only things I directly copied were the data tables; the rest I filtered through one of my text editors (to unwrap paragraphs mainly) and copied into the appropriate heading and paragraph styles (which I altered on the .docx file to match the fonts and alignments on the sheet) making sure any bold and italic text matched. It's not an exact copy I admit (sometimes I couldn't align the tables with the text the same way and I corrected any spelling errors and comma issues that Word found) but it is as close as I could make it. I will send you a copy if you want and you can do with it what you will.
Dalton “who is most creative when he's bored” Spence
DaltonS is offline   Reply With Quote
Old 09-28-2020, 11:35 AM   #983
DaltonS
 
DaltonS's Avatar
 
Join Date: Aug 2004
Location: Hamilton, Ont. CANADA
Default Re: GURPS Spaceships Design Spreadsheet

Quote:
Originally Posted by ericbsmith View Post
I'm not seeing that on a ship I just saved & reloaded. I don't think that should have been an issue with previously saved ships, either, since the issue I fixed was with the Design Table not respecting the state of the button in regards to displaying the results. (note that Troop Strength is always calculated, regardless of the checkbox; technically the checkbox only affects whether or not that information will be displayed on the ship and the output sheets).
Oh, this is weird. When I imported my saved ships to the "Unofficial Ships" sheet of the RC31 version and loaded my Martian “Gas” Station the "Calculate Troop Strength" option was off as it should be, but when I clicked the "Hide Unused Rows" checkbox it was turned on. Huh?
Quote:
Originally Posted by ericbsmith View Post
Any time you reset the design table, save, or reload a ship there are a series of checkboxes on the right-side of the dialog box where you can choose which sections to save, load, or reset. What you want to do is create a "dummy" ship - name it Mars Campaign Settings or something - and save just the Campaign Options (this is the information from the same-named tab) and the Ship Options (this is the information from the Design Table from the Ship Options, Features, etc section of the sheet). Then you can reload this before you start a new ship.
So basically create a template ship (not a dummy, we have to be smart about this ;) ) with all the Design Switches & Features and Campaign Settings preset but no systems or size defined (setting the TL and the name should be okay) and save it? Makes sense. I was thinking that the Campaign Setting was an independent entity from the ship but I guess it doesn't have to be if a template can be used. Just have to remember to save the template with the focus on the Design Table so that will appear when I reload it and change the name and SM immediately after that.
Dalton “Good Idea! Why can't I have more of those?” Spence

Last edited by DaltonS; 09-28-2020 at 11:41 AM.
DaltonS is offline   Reply With Quote
Old 09-28-2020, 03:58 PM   #984
ericbsmith
 
ericbsmith's Avatar
 
Join Date: Aug 2004
Location: Binghamton, NY, USA. Near the river Styx in the 5th Circle.
Default Re: GURPS Spaceships Design Spreadsheet

Quote:
Originally Posted by DaltonS View Post
I noticed the most recent release contained an updated version of the SpaceshipsOptionalRules.pdf file but when I looked it was still labeled RC29.
If I update the rules I'll update the cover sheet and the RC on the cover. So, no, I haven't actually updated the Optional Rules PDF since the RC29 version of it.

Quote:
Originally Posted by DaltonS View Post
Oh, this is weird. When I imported my saved ships to the "Unofficial Ships" sheet of the RC31 version and loaded my Martian “Gas” Station the "Calculate Troop Strength" option was off as it should be, but when I clicked the "Hide Unused Rows" checkbox it was turned on. Huh?
Ugh, not necessarily weird. I just found another bug with the Troop Strength that would hose my last fix if you Reset the Design Table. Meaning when I prepped the ship for release, and it Reset the Design Table, it undid my fix. Which is probably why it was bugged in the first place, because it undid what I thought I had fixed way back when.

Quote:
Originally Posted by DaltonS View Post
So basically create a template ship (not a dummy, we have to be smart about this ;) ) with all the Design Switches & Features and Campaign Settings preset but no systems or size defined (setting the TL and the name should be okay) and save it? Makes sense. I was thinking that the Campaign Setting was an independent entity from the ship but I guess it doesn't have to be if a template can be used. Just have to remember to save the template with the focus on the Design Table so that will appear when I reload it and change the name and SM immediately after that.
Campaign Settings can be shared between multiple Design Tables (which you can copy off by hitting the Add Design Table button in the top right of the Design Table). This can allow you to have multiple ships open sharing the same Campaign Options. Ultimately, though, the Campaign Options must be saved with the ship so that the ship can reload them when it is loaded. This means that, technically, any ship can be used as a "Campaign Template" by loading it and deselecting everything except the Campaign Options. You wanted to set some of the Ship Options, Design Features & Switches, though, which makes it more practical to create an entirely separate ship with the Campaign Options & Ship Options preset.


So I've just pushed RC32 to fix the other bug with Troop Strength. I'm not going to post a new Release message though, instead I'm just going to go back and edit the RC31 message since this is a relatively minor change.
__________________
Eric B. Smith GURPS Data File Coordinator
GURPSLand
The future keeps telling us what the past was about. You make the past mean different things by what you do with the time that comes after.
ericbsmith is offline   Reply With Quote
Old 12-07-2020, 05:08 PM   #985
davester65
 
davester65's Avatar
 
Join Date: May 2009
Default Re: GURPS Spaceships Design Spreadsheet

Hi, I've noticed a minor glitch. On some of the ships I've designed and saved, on the saved ship tab on the column for dST/dHP instead of the correct value it sometimes just shows a 1. It always seems to be on ships that I installed Structural Reinforcement on when it does happen, but some of the designs it shows the correct split value for having structural reinforcement. If I open the saved ship it always shows the correct dST/dHP on the design table. Figured you'd want to know.
davester65 is offline   Reply With Quote
Reply

Tags
design, game aids, gurpsland, program, sheet, spaceships, spreadsheet

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Fnords are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 04:09 AM.


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