GURPS Spaceships Design Spreadsheet

[vierasmarius]

Originally Posted by ericbsmith

-Fixed issue with Missile Weapon Accel stat which caused the Output Sheet to error out in OpenOffice
-Corrected Troop Strength, which wasn't taking into account dDR or dHP (only Force Field dDR was being used).

Originally Posted by vierasmarius

Thanks! I'll give it a try again.

Hmm. I'm still getting both of these errors. All projectiles are still displaying an Error in their Accel stat (and thus spoiling the Output page), and TS is still displaying 0 (unless a Force Screen is present).

EDIT: The fact that having effectively 0 DR causes the TS calculation to return 0 indicates that it may not be including HP correctly in the formula. TS is based on dHP + Avg dDR, multiplied by number of combat systems (weapons + defensive ECM) and factors derived from Hnd and TL.