• Registered: 2005-10-26
  • Posts: 9

Topic: Technical question about PDS in sxcafighters

Hello.  I have been looking at the copy of the sxca spreadsheet I have, and noticed that in cell AF31 (AH42 in the VBAM version, if you care) the defensive rating modifier for Point Defense System is a positive 2.  This entails, from what I gather about how the spreadsheet works, that 2 would be treated as an additive modifier for the Defensive rating, and not a multiplicative modifier, as it states the 2 is in the Starmada X rules.  I was wondering whether this was a typo, or if there was something I was missing.

Thanks

shift

  • From: Denver, CO
  • Registered: 2005-03-27
  • Posts: 3,578

Re: Technical question about PDS in sxcafighters

shift_shaper wrote:

Hello.  I have been looking at the copy of the sxca spreadsheet I have, and noticed that in cell AF31 (AH42 in the VBAM version, if you care) the defensive rating modifier for Point Defense System is a positive 2.  This entails, from what I gather about how the spreadsheet works, that 2 would be treated as an additive modifier for the Defensive rating, and not a multiplicative modifier, as it states the 2 is in the Starmada X rules.  I was wondering whether this was a typo, or if there was something I was missing.

Nope. You're not missing anything.

The spreadsheet treats any number in that column as a multiplier, unless it is 10 or more, in which case it "knows" that it is an additive.

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

mj12games's Website

  • Registered: 2005-10-26
  • Posts: 9

Re: Technical question about PDS in sxcafighters

Really?  That doesn't make sense to me for a couple of reasons...  In that column (the Dmod column, AF), all of the multipliers seem to have a negative value, and additive modifiers a positive value. (Except PDS's 2)  Then in the area of the spreadsheet where it calculates special equipment for the ship, it would seem to treat it as multiplicative if it is <0, not <10, and additive otherwise.  This doesn't hold with the PDS's multiplier in cell AF31 being a positive 2.  In addition, if the inequality were <10, then the additive modifier for as single sunburst (2), would be treated as a multiplier instead.  When I add a PDS to a ship design in the GUI of the spreadsheet, the column which I take to be the active defensive rating modifier for special equiment goes up by a factor of +2, not *2.  Am I just confused about what you said before, or does the 2 in cell AF31 need to be a -2 instead?  If it helps at all, I have version "2.5g" as displayed in cell Q30.  Sorry to be such a bother, but I just want to make sure my spreadsheet calculates cost properly, and I am confused.

Thanks again,

shift

  • From: Denver, CO
  • Registered: 2005-03-27
  • Posts: 3,578

Re: Technical question about PDS in sxcafighters

shift_shaper wrote:

Really?  That doesn't make sense to me for a couple of reasons...
[...]
Sorry to be such a bother, but I just want to make sure my spreadsheet calculates cost properly, and I am confused.

Well, it's easy to get confused when the Great and Powerful Dan turns out to be wrong... smile

It should indeed be "-2" instead of "2" in that cell. I have changed the official SXCA on the web site to reflect this.

Good catch. You get a gold star.

Daniel Kast
Majestic Twelve Games
cricket@mj12games.com

mj12games's Website