GURPS Spaceships Design Spreadsheet

[ericbsmith]

Originally Posted by Yami Fowl

I wonder what could be causing it?

Hope it helps!

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.

[Langy]

Originally Posted by ericbsmith

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.

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.

[ericbsmith]

Originally Posted by Langy

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.

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

[vierasmarius]

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.

[Diomedes]

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

[Yami Fowl]

Originally Posted by ericbsmith

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.

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!

[ericbsmith]

Originally Posted by vierasmarius

I'm having some trouble with Spinal Mounts. <SNIP>.

Originally Posted by Diomedes

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

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.

Originally Posted by Yami Fowl

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...

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.

[ericbsmith]

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.

[vierasmarius]

Originally Posted by ericbsmith

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.

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

[Yami Fowl]

Originally Posted by ericbsmith

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.

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.