GURPS Spaceships Design Spreadsheet

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