Re: GURPS Spaceships Design Spreadsheet
 

Third sheet seems weird:

Changing the TL of Lightning Cannon (to 6) doesn't allow choosing it at lower TL than 7^. Checking not to care about TL doesn't allow it either.

The second listing of possible habitats, under Automed, should be Teleport Projector, but gives an error.

Re: GURPS Spaceships Design Spreadsheet
 

Version 1.23
-Added Open Frame option for Armor (near the High-Thrust/Ram Rockets options - Scroll all the way to the right).
-Added Top Deck Hull Option to the SS7 Options section.
-Maximum Air Speed (for Ornithopter Wings, Turbofan, etc.) now only applies to the Performance Profile the engine is assigned to.
-Checking the "Don't Filter Available Systems by TL" box now applies to Habitats, Weapons and Weapons Options as well as Ship Systems.
-Fixed some minor Conditional Formatting issues on the Weapons Table.
-Added Phased Array option for Laser and UV Lasers from SS7. To use this option you must repeat the weapon on 4 consecutive lines to generate the stats for the two additional increased RoF settings and then the Sensor Array Level.
-Added option in the Campaign Options to modify the price of the Habitat modules and most of the Hull/Ship options (Wings, Stealth Hull, etc.).

See my first post for download links.

I added a few of the features you were looking for vicky, and quashed a few more bugs.

Re: GURPS Spaceships Design Spreadsheet
 

Version 1.24
-Added a checkbox to the top right to Disable the Core Macro. This will speed up some calculations, but disables the row auto-hide/auto-display feature along with some other minor things.
-Fixed bug in the Tall/Short macros for auto-adjusting row height.
-Added note to Weapon Shots for "Multiplied by number of mounts"
-Fixed notes for Shots of a Phased Array/Gravitic Focus weapon to show for all weapon modes, not just the first
-Combined the Ballistic Impulse/Burn Points columns into one column, allowing Shots column to be a little wider.
-Added an Extra Wide columns option
-Added some Mixed Weapon Batteries which include Peripheral mounts.

See my first post for download links.

Again, mostly minor tweaks and additions.

Re: GURPS Spaceships Design Spreadsheet
 

I've come quite late to this sheet, but it's been Dead Handy whipping up spaceships for my new campaign (which is cinematic on the surface, but horribly hard science underneath). Thanks!

Re: GURPS Spaceships Design Spreadsheet
 

Version 1.25
-In the weapon table combined the Range column into the Ballistic Impulse/Burn Points column, freeing up some column space to readjust the weapons table.
-Added an area to adjust the amount of Ammunition weapons have assigned to them, off to the right of the Weapons Table. In this section you can add extra weapon Ammunition as cargo (subtracting from cargo capacity) or reduce the number of shots listed in the Weapon Mount.
-Corrected cost calculations for Weapon Ammunition. Ammunition is not included in the base cost of Weapon Mounts; previously ammo cost was not accounted for, though extra cost for warheads (Nukes/Sensor Probes, etc) was. Now, all ammo cost and warhead cost is accounted for and added to the cost of the ship.
-Corrected power use of Rocket Launchers (should have been 0 power use).
-After you have selected ship SM and added an Extradimensional Interface to the ship you can reselect ship SM and at the bottom of the list will be a split SM listing showing both the internal and external SM of the ship.

See my first post for download links.


The big change this time around is to add a work area to adjust the shots of weapons and store extra ammunition in lieu of cargo space.

Re: GURPS Spaceships Design Spreadsheet
 

Version 1.25a
-Corrected Ammo Weight for Bombs, Sensor Probes, and Rapid Fire/Very Rapid Fire guns of all types
-Fixed lower ship SM drop Down Menu
-Fixed bug where lower ship TL wasn't affecting available ship systems

See my first post for download links.

Re: GURPS Spaceships Design Spreadsheet
 

Amusingly, while I scoffed at this when I first read it a couple months ago I find myself working on an overhaul that's quite similar to your outline. I've been messing around with a serious overhaul of the GUI of the Design Table which involves moving most, if not all, of the data options checkboxes into a single column.

One of the reasons for this approach is that I've got a very good idea about how I can implement both Reconfigurable Systems and Smaller SM systems into the sheet, but doing what I have in mind will be somewhere between difficult and impossible on the existing Design Table. So an overhaul of the sheet, including the GUI, looks like the only real solution.

Interestingly, I'm probably going to be ditching the 2nd ship, not because I don't like having it there but because it caused a lot of coding problems for me - quite a few formulas became over-complicated by having two ships in one sheet. Eliminating the 2nd ship will make rewriting the Design Table considerably easier (and thus, take many fewer months to do).

Re: GURPS Spaceships Design Spreadsheet
 

If it makes the decision any easier for you, I don't see much point in having two ships on the sheet either.

If your campaign only has two ships, then it's useful, but for any larger number, you'll want to save each under a separate file name and that extra ship becomes wasted space.

Re: GURPS Spaceships Design Spreadsheet
 

That's why they're going to pay me the big bucks...lol Seriously, though, I've taken classes in interface design and that idea just seemed more "sane". To me the bottom ship was a waste of space because I save a file per ship (bytes are cheap) so organizing to better utilize it on an 8.5x11" or A4 page makes sense.

Re: GURPS Spaceships Design Spreadsheet
 

The thing is, though, all the options to the right really don't need to be printed. They either modify systems or generate notes which appear in the regular portion of the ship sheet. The side-scrolling is a little annoying, but not too bad.

To me, having two ships on one page was a much better use of page space. Most ships don't have enough weapons, habitats, and notes to take up a half of a page, and for those ships that do I added the capability of hiding either ship for printing.

Also, my original intention (which still holds) is to be able to copy the Design Table within the spreadsheet so you can keep all your ships for a single campaign in one file. This doesn't really save much space, but does allow you to set up a single set of campaign options and easily change them for all your ships.

Actually, since I'm looking at doing a serious revamp of the sheet I would like any suggestions on how to improve the interface or changes that would help (such as changing how options are applied).

Re: GURPS Spaceships Design Spreadsheet
 

Well I use Excel templates for it, so if I want to set campaign option I can set them, then save it as a ready-made template.

I'm probably focus the design direction on being vertical. Not everyone has a wide screen monitor and vertical scrolling is easier than side-to-side.

I'd probably also sketch out the boundaries of an 8.5x11" page and try to fit everything inside it. Either that or throw off the design notes that currently live off to side onto another page and just leave what's under it blank.

For that matter, send me an email to my personal address (it's on file) and I'll send you a "paper prototype" of an idea.

Re: GURPS Spaceships Design Spreadsheet
 

Because I'm running under OpenOffice, each ship takes up the full space anyway including all its blank lines; I have to print by highlighting the relevant cells (unless there's some setting I haven't found)... I suspect the easiest option to make it possible to print a ship sheet, rather than ship sheet plus extra data, would be to move the tickboxes and auxiliary inputs onto a separate sheet, or alternatively to have a "display page" sheet with no inputs at all, just neatly-formatted output.

Re: GURPS Spaceships Design Spreadsheet
 

I second that last idea. I'd like to have multiple output formats - one plain text, one HTML or BBCode, and one for printing.

Re: GURPS Spaceships Design Spreadsheet
 

Oh, and one for exporting to the forum, if possible!

Re: GURPS Spaceships Design Spreadsheet
 

Yeah, that's pretty much why I suggested BBCode.

Re: GURPS Spaceships Design Spreadsheet
 

Version 1.26
-Corrected cost of SM+4 Passenger Seats, Soft Landing System, & Stasis Web.
-Corrected cost reduction of Reduced Control Stations for SM+4 ships
-Modified Core Macro to eliminate all the screen flashing when changes are made (it now flashes once per change, instead of four or five times). This should speed up calculations as you make changes to the sheet

See my first post for download links.

Re: GURPS Spaceships Design Spreadsheet
 

I thought you were working on a version 2. Is that on a backburner or something?

Re: GURPS Spaceships Design Spreadsheet
 

I've been doing some work on it, but it's going to take a while. I've actually got enough done that I may do a preview release at some point in the near future to take suggestions on possible changes.

In the meantime there's no reason not to make corrective changes to v1.x as I find things to fix - and as I work on v2 I keep finding minor things to fix in V1.x

Re: GURPS Spaceships Design Spreadsheet
 

Any ideas on how you might incorporate smaller systems into the spreadsheet? The only idea I can think of is to have each system take up 3/10ths of a space and have the remaining 1/10th space be waste space (curse us humans and our base 10 math, base 12 would have been so much better).

Re: GURPS Spaceships Design Spreadsheet
 

That's a planned addition for v2.0. I tried a couple different approaches in the current version of the sheet, but they proved unworkable, so I decided that a redesign of the sheet with a new approach was necessary.

I've done a considerable amount of coding on v2.0, but there's still a bunch to go and I kind of ran out of steam on the project (real life caught up with fun & play). The good news is that Smaller Systems and Reconfigurable Systems, each with two or three sub-systems, are working just fine. The bad news is I broke some other stuff that's got to get untangled, plus I'm going to need either some help with Macros in Open Office or I'm going to have to learn the language myself as Macros are now absolutely necessary for Smaller & Reconfigurable Systems.

I hope to get back to it over the summer when I have less school and more free time, though if I have some time during spring break I may take a crack at it then.

So, anybody familiar with the coding of semi-complex Macros in Open Office?

Re: GURPS Spaceships Design Spreadsheet
 

Any thought on just coding it? Like in an actual programming language? I know it opens a can of cross-platform worms but still. I've had good luck with Java in that regard. (Java would open up Windows, Linux, Mac and Android as native platforms and other than Android it would pretty much just work.)

Re: GURPS Spaceships Design Spreadsheet
 

I don't know Java, and I don't really know enough C++ or C^ to pull it off. Maybe a couple years down the line.

Re: GURPS Spaceships Design Spreadsheet
 

Hi Eric

Your Excel Sheet is a wonderful tool to create GURPS Spaceships on the fly. I've run into a problem unterstanding your sheet though, could you please explain why there seems to be a discrepancy between the damage as per Spaceships 1 and the damage your sheet calculates?

I am sorry if this has been answered in the thread, I was not able to find it.

Thanks!

Onkl

Re: GURPS Spaceships Design Spreadsheet
 

Glad you enjoy it!

Looks like I introduced a bug, almost certainly in the last update, where the damage is calculated as if the beam is 3 "sizes" larger than it actually is and it completely messes up the damage of missile warheads. Turned out to be an easy fix, though, and I'll be uploading a fixed version shortly.

EDIT: Version 1.27
-Fixed bug where damage of all weapons is calculated as if they were 3 "sizes" larger than they actually are

See my first post for download links.

Re: GURPS Spaceships Design Spreadsheet
 

I just noticed a very minor glitch in version 1.27. When you have it open to where you have two design worksheets, on the lower one only it does not show the endurance of an MHD power plant in the appropriate place, whether or not you add extra tanks of hydrox fuel. Like I said, nothing major.

Re: GURPS Spaceships Design Spreadsheet
 

Just a quick question. Does anyone know where I can find a simple editable GURPS spaceships worksheet in pdf or some other format? Thanks. I'd like it for homebrew designs that the spreadsheet doesn't cover. Thanks.

Re: GURPS Spaceships Design Spreadsheet
 

I used to have a simple Excel sheet that was just a bunch of blanks, if that's what you mean. The limit of its automation was to add up the cells.

If that's all you're wanting it's trivial to create in Excel or OpenOffice.org.

Re: GURPS Spaceships Design Spreadsheet
 

For some reason the spreadsheet won't allow me to use the "High Thrust" and "Air Ram" options for fusion torches, etc... as well as the "Open Frame" option, the boxes are there on the right side of the worksheet, but they all have X's through them and when I check the appropriate box, nothing happens. Is this a glitch or is there some other option I need to check to get these to work? Thanks.

BTW I am using version 1.27 for open office if that makes a difference.

Re: GURPS Spaceships Design Spreadsheet
 

Version 1.28
-Fixed minor bug with engine duration and second ship
-Fixed bug in Open Office version where some option checkboxes were unusable

See my first post for download links.

This fixes the MHD Turbine bug (which might have affected other systems, actually) as well as the Options being Crossed out (which I had actually fixed and posted previously, but forgotten to comment on).

Re: GURPS Spaceships Design Spreadsheet
 

Thanks. Off to download.

Re: GURPS Spaceships Design Spreadsheet
 

Great job! Looks very nice!

Re: GURPS Spaceships Design Spreadsheet
 

I hope I'm not overlooking anything obvious, but I've fiddled about with this sheet (which is quite thorough and well laid out btw) and can't seem to figure out why it won't let me actually choose systems! The dropdowns for the individual system slots just show an endless series of #VALUE! entries and typing in names of systems manually results in the information below (armor dDR, cargo capacity, etc) autopopulating, but the "value you entered is not valid" box comes up every time! Actually copying the cell from the Campaign Options page onto the Design Table seems to do it, but this can't be what's intended. I'm using Excel '10, running macros enabled, trying to build a TL10^ SM +8 ship. Has anyone else had problems of this nature?

Re: GURPS Spaceships Design Spreadsheet
 

And whaddaya know, saving and restoring the sheet a couple times seems to have fixed it! Macros working great, this is going to save me so much time...

Re: GURPS Spaceships Design Spreadsheet
 

Huh... I'm not sure why it would have errored, or come back, but I'm glad it worked itself out for you.

Re: GURPS Spaceships Design Spreadsheet
 

Just found what was causing this. Turns out that if you uncheck the 'Use Rules from Spaceships 7' option the menu's will error.

Version 1.29
-Fixed bug where unchecking the 'Use Rules from Spaceships 7' option caused the menu's for ship systems to error out.

See my first post for download links.

Re: GURPS Spaceships Design Spreadsheet
 

I'm having trouble accessing the files and your website.

Re: GURPS Spaceships Design Spreadsheet
 

My webserver seems to have crashed out for some reason. I'll see if I can get it working shortly.

Re: GURPS Spaceships Design Spreadsheet
 

It works now. Thanks!

The spreadsheet looks nice. I'll have fun playing with it today. :)

Re: GURPS Spaceships Design Spreadsheet
 

Where did you get information for SM+4 hulls? That size isn't listed in any of the charts in GURPS Spaceships.

EDIT: Nevermind. I see the rules listed in GURPS Spaceships 4, p. 38.

Re: GURPS Spaceships Design Spreadsheet
 

When i open this document i choose TL (f.e. 9), SM (f.e. +10) and the first thing i do, i add habitats. I get an error message. In e2010 everything crashes, in open office version i get en error 502 in habitat modules (and i can't choose location of modules (all the locations are called error).

Re: GURPS Spaceships Design Spreadsheet
 

Did you add a Habitat system, or just choose from the Habitat modules table?

Re: GURPS Spaceships Design Spreadsheet
 

First, make sure you've got the latest version of the spreadsheet from my website (v1.29). Second, as ciaran_skye said, make sure you add a Habitat System to the Ship Systems before adding Habitat Modules to the ship. If you don't have a Habitat System installed the Black background error will pop up, and you wouldn't be able to select Location, but you should have no problem selecting modules themselves - there shouldn't be any spreadsheet Error Messages poping up, and certainly no lockup/crashes, merely the Black background which I use for an in-sheet error indicator.

Re: GURPS Spaceships Design Spreadsheet
 

Im using those from the first page. (f.e. http://gurpsland.no-ip.org/zip/Spaceships-Ooo.zip). You should have version number on the first page of the sheet, because i cant see what version i am using. here is a print screen:
http://imageshack.us/photo/my-images/268/31570087.jpg/

Re: GURPS Spaceships Design Spreadsheet
 

The version posted on my webpage is always the most recent version, and the version number is located in the upper right hand of the main Design Table in the spreadsheet. From the image you posted I can see that you are using v1.29.

It also looks like you're using a version of windows where the regional settings are different (comma's in place of decimal points), which could be the root cause of your problems with regards to crashing and errors. I've seen these kinds of problems crop up with GCA and regional settings; I'm afraid I'm not well versed on resolving them. Can you try changing your regional settings to US English standards to see if that clears it up?

Re: GURPS Spaceships Design Spreadsheet
 

I didn't see the version number. I looked at the wrong page :). Yes, the problem was caused by regional settings.
Thanks for help.

Edit: one more thing. im trying to build TL9 SM+6 spacecraft, and when i add control room to core section, it says that it has C6 computer. Did i miss something, or should it be C5 (C7-2 for TL9)?

Re: GURPS Spaceships Design Spreadsheet
 

Fusion rocket's high thrust option is disabled.

Adi

Re: GURPS Spaceships Design Spreadsheet
 

Just a couple of quick notes:

I can't find ornithoptor wings anywhere in the design table.

Also, how hard would it be to add dome kind of option allowing you to adjust cabins and other habitat options sizes depending on the SM of the race the cabins are designed for?

Another thought I had is how about as a way to include reduced sized systems, have an optional version of the design table that has 60 systems instead of the usual 20? Each system would be from a ship 1 SM smaller.

Just a thought.

Re: GURPS Spaceships Design Spreadsheet
 

They're in there, under Propulsion Systems. I believe they're TL5+2, meaning you either need to choose that TL or check the box Don't Filter available systems by TL.

That may be doable, though there currently aren't any official rules for it.

Not practical in the current sheet. In the Version 2.0, which I did some work on months ago, I've got both Smaller SM and Reconfigurable Systems working fine; however the rest of the sheet needs a lot of work which I haven't had time to get working (in rebuilding the sheet I broke a *LOT* of things that need fixing).

Re: GURPS Spaceships Design Spreadsheet
 

Thanks, I assumed the TL 5+2 stuff would also appear with TL 10^.
I think I read a suggested progression of x2 for SM+1, x5 for SM+2, x10 for SM+3, etc... somewhere in one of the books.
Thanks again.

Re: GURPS Spaceships Design Spreadsheet
 

Having some severe performance problems on 2010 excel. Anyone else?

Re: GURPS Spaceships Design Spreadsheet
 

Me too...

When I create a Ship, any weapon I configure crashes the Sheet.

Re: GURPS Spaceships Design Spreadsheet
 

I have no idea why you guys are having trouble with Excel 2010.

Have you tried both the Excel 2000 and Excel 2010 version of the spreadsheet in Excel 2010?

Excel 2000 version
Excel 2007 version


I've uploaded a version of the 2007 spreadsheet with Macros stripped out to test and see if it's the Macros causing the problems:
Excel 2007 No Macros version

Beyond that I don't know what could be causing problems. Unfortunately, I don't have access to Excel 2010 to even test it, and one thing I learned with Excel 2007 is that compatibility between versions of Excel can be hard to track down.

Re: GURPS Spaceships Design Spreadsheet
 

Version 1.30
-Corrected issue with High Thrust option where many drives weren't correctly allowed to have High Thrust
-Corrected display issue when Indestructible Armor was added to the Rear hull section
-Fixed Control Room computer complexity

See my first post for download links.

Amongst other things I've added an Excel 2007 No Macros version of the spreadsheet to the first page.

Re: GURPS Spaceships Design Spreadsheet
 

This worked fine. The other one had about a 5-8 second lag. Thank you!

Re: GURPS Spaceships Design Spreadsheet
 

I had noticed the lag in Excel 2007. The delay is very short in Excel 2000, but noticeably longer in Excel 2007, and is largely caused by the Core Macro calculations. If you try the Macro version again but check the "Disable Core Macro" checkbox (top row, off to the right) you should find that most calculations in the sheet are considerably faster while retaining a lot of the functionality of the spreadsheet.

Re: GURPS Spaceships Design Spreadsheet
 

My bad, though I quoted the 2010, I meant 2007.
My Excel is the 2007, I'll see if the no macro version is working fine...


EDIT:

Yep, without the Macro stuff it's working fine.
Hope it can help!

Thanks!

Re: GURPS Spaceships Design Spreadsheet
 

Version 1.31
-Changed SM+5 Habitats to provide 0.3 habitat module slots
-Added Troop Strength calculation to Notes section (from Pyramid 3-30)

See my first post for download links.

EDIT: And, immediately after I posted that I noticed a bug in the TS calculation. Fixed now.

Re: GURPS Spaceships Design Spreadsheet
 

Is that an erratum or a house rule?

Re: GURPS Spaceships Design Spreadsheet
 

One of the house rules I've implemented. If you check the "Use only Official Systems & Rules" checkbox then ships must be SM+6 to have Habitats at all. Although, it's basically like using the Larger System rules and placing a SM+6 Habitat in a SM+5 ship.

Re: GURPS Spaceships Design Spreadsheet
 

That is helpful. My only gripe is that if buy three SM+5 habitats, you end up with .9 habitat modules, not 1.00, so you can't fit a standard sized cabin. I don't know if that is even fixable, but I figured I'd point it out.

Re: GURPS Spaceships Design Spreadsheet
 

Not really. I could up it to 0.333 cabins, but then you'd get more cargo capacity out of Steerage Cargo than you'd get out of a Cargo Hold (1 habitat of Steerage Cargo yields 5 tons capacity; 3 SM+5 Cargo Holds yield 4.5 tons cargo capacity). This is more a systemic problem, as the Spaceships rules themselves cheat here (really SM+6 should only allow 0.6 habitats, but Spaceships cheats and gives it 1 habitat; that means that when I originally set SM+5 habitats as being 0.2 it was technically "more correct," as 0.2 falls within the normal x1/x3/x10 progression - 0.2/0.6/2/6/etc.).

Re: GURPS Spaceships Design Spreadsheet
 

Hey Eric any chance you plan on incorporating the new system's from Pyramid 3/34 into your sheet?

Ghostdancer

Re: GURPS Spaceships Design Spreadsheet
 

At some point. I actually already added the new systems to my copy, but got stalled out when i went to add the Ground Performance statistics. It'll get added sooner or later (but probably sooner).

Re: GURPS Spaceships Design Spreadsheet
 

Awesome! I'll be waiting for the update. BTW, thanks, I don't know if I have said it before but this thing is really useful. :)

Ghostdancer

Re: GURPS Spaceships Design Spreadsheet
 

Version 1.32
-Added modules from Pyramid 3-34 (These are disabled by default; activate them in the Campaign Options section)
-Added option to use Armor/Volume rule from Pyramid 3-34 (disabled by default)
-There is limited space to display Performance data; only the first few will be displayed if multiple Space, Air, Ground, and Water propulsion systems are added.

See my first post for download links.

Re: GURPS Spaceships Design Spreadsheet
 

You da man! ^_^ Downloading and using.

Ghostdancer

Re: GURPS Spaceships Design Spreadsheet
 

Version 1.32a
-Streamlining now doubles ship length (this affects Crush Depth)
-Corrected Spread DR option to work with Crush Depth calculation
-Set Pyramid 3-34 rules to be on by default (Armor/Volume option is still disabled by default)

See my first post for download links.

Re: GURPS Spaceships Design Spreadsheet
 

Chiller, I've been waiting for rules for wheels and tracks for a while. Thanks!

Re: GURPS Spaceships Design Spreadsheet
 

Thanks for this! :D
I may not use Spaceships (I used ISW ship rules), but this will be helpful as I'm making my ISW ship creation spreadsheet.

Re: GURPS Spaceships Design Spreadsheet
 

Hello...

I'd like to point out, that when using Office 2007 (With or Without Macros) there is a problem with selecting weapons...

It tells me it's a "Type Incompatibility" and the cells become "#VALOR"...

EDIT: It doesn't happen with Conventional Gun, Electromagnetic Gun and the projectile ones... Only the beam type is problematic...
EDIT2: Idk what is happening, now all Weapons are problematic... I wonder what could be causing it?

Hope it helps!

Re: GURPS Spaceships Design Spreadsheet
 

The only thing I can think of is that this is an internationalization issue (You're in Brazil; #Valor is a non-english #Value error message). Do your regional settings use a comma instead of a period as a decimal point? If so, then I'm not sure what can be done other than changing your regional settings.

Re: GURPS Spaceships Design Spreadsheet
 

Another problem is that whenever you do nearly anything in the no-macros Excel 2007 version, you get an error saying something about a macro that's supposed to hide rows doesn't exist.

Re: GURPS Spaceships Design Spreadsheet
 

Yeah, I forgot to run the Macro Stripper before saving. Try re-downloading it should be better now.

Re: GURPS Spaceships Design Spreadsheet
 

I'm having some trouble with Spinal Mounts. Maybe I'm overlooking something, but it isn't letting me place any Spinal systems in the Center or Core regions. If I place either the Front or Rear Spinal system, I can only select Spinal Mount (Rear) in the Weapon list lower down, and of course it displays an error because I don't have a "complete" Spinal Mount installed.

Re: GURPS Spaceships Design Spreadsheet
 

I'm having a similar problem. The central Core system menu isn't displaying anything after the lightspeed drive.

Re: GURPS Spaceships Design Spreadsheet
 

Ironically enough, I wrote #Valor mistakenly.. It displays #Value, as you said...

I use Excel 2007 in english, so this shouldn't be a problem...

EDIT:

I think I found the error...
When I turn off the "Cosmic Power" option; it works fine...
So the problem is probably around it...
Hope it helps!

Re: GURPS Spaceships Design Spreadsheet
 

These errors were my fault. I added more Systems to pick from and didn't expand the menus, so under some circumstances the last Systems on the list wouldn't be available.


That doesn't completely rule out a Regional Setting issue. It's still possible that if Windows is using a comma as the decimal separator that Excel is using it too, which could cause issues. Unfortunately I'm still not seeing the #Value error in the weapons, so haven't been able to address it.

Re: GURPS Spaceships Design Spreadsheet
 

Version 1.33
-Fixed bug where not all items would be available in the Ship Systems drop down menu
-Fixed bug where contents of the Ship Systems drop down menu could all go to a #Value error

See my first post for download links.

Re: GURPS Spaceships Design Spreadsheet
 

Thanks, works great! Now I can finally build that self-propelled howitzer =P

Re: GURPS Spaceships Design Spreadsheet
 

I see...

Is there a way to change the regional settings?
This way I can be sure of it...

Thanks...

EDIT:
I found out how, I changed the Decimal separator to period and the thousand to comma, still have to same problem...
(I changed that on both Windows and Office settings; first Windows, then Office)

EDIT2:
What about what I said about turning off the Cosmic Power?
This #Value only happens when the Cosmic Power is checked on the checkbox.

EDIT3: (Sorry for the Excessive Editing, but I just got more info that can help)
Also, beyong turning off Cosmic Power, when I place Rapid Fire or Very Rapid Fire it works fine.

EDIT4:
I think I found it, the problem seem to be the SM and the table.
It works perfectly fine until SM+32.
On the SM+33, the damage drops then it gets right again on SM+35.
(All of the below are with Cosmic Power checked)
SM+32 Major Conversion Cannon: 3dx500000,0 cor (10)
SM+33 Major Conversion Cannon: 2dx1000,0 cor (10)
SM+34 Major Conversion Cannon: 3dx1000,0 cor (10)
SM+35 Major Conversion Cannon: 4dx1000000,0 cor (10) (Seems right here)
SM+36 Major Conversion Cannon: 6dx1000000,0 cor (10) (Right as well)
SM+37 Major Conversion Cannon: 2dx5000000,0 cor (10) (Right as well)
SM+38 Major Conversion Cannon: 3dx5000000,0 cor (10) (Right as well)
SM+39 Major Conversion Cannon: #Value with Cosmic Power On; 2dx1000,0 cor (10) (Without Cosmic Power)
SM+40 Major Conversion Cannon: #Value with Cosmic Power On; 3dx1000,0 cor (10) (Without Cosmic Power)

Hope it helps.