Heh, sunbursts...Yeah.  I have a fleet of 150 1 hull ships that each have 2 sunbursts and a cloaking device.  Sunbursting things to death doesn't get old, though we eventually started using the house rule that they give a -1 to firing instead of being impenetrable, due to the massive walls of them that we were making.

Awesome, thanks for the help!

I was misreading the entry on repeating, and not registering that it is the same die that "repeats".  The "correct" way, however, makes it a lot harder to program into a spreadsheet to do my firing for me...:) ah well, the joys of excel...

shift

PS why so many vlookups in sxcafighters?  It makes it very confusing to reverse engineer.

Beowulf - In fact I can, and did.  I thought I broke the system for a while, but there is something in the Starmada X rules that states that rolls always fail on a 1.  Thus, the only thing doubled range mods does for short range fire is make one heck of an anti-fighter weapon (it allows fighters to be attacked at 2+ To-Hit).

Thanks for the house rules ideas though.  We may try some of them.

googleplex - According to the rules, and all logic, there would be nothing there, in terms of the usefulness of the shockwave.  There is nothing in the rules, however, stating that a useless shockwave cannot be installed.  It generates a Q box on the spreadsheet, and via the rules.  It probably should be played as if it doesn't, but I'm just looking at what the rules say.

The same goes for Re-Rolls applying to only the first roll.  It says (once), but that seems to be applying to individual dice.  It says I can do it for any of them, but it is unclear if it also means all of them.  Repeating seems to indicate that if a To-Hit dice hits, it is re-rolled.  Would that then count as the one reroll?  I guess I'm just confused by the wording.

As for the hyperdrive, I'd be curious to know the rationale behind not making it take up space, but have it give you extra space if you remove it.  The specific way it works is that if you have a hyperdrive, you get the standard SU allotment for the ship.  If you don't, you get a 10% bonus to SUs.  This would indicate to me that it is expected that the default is for a ship to have a hyperdrive.  Most of the wording in the sections on hyperdrive use, however, seem to lean in the direction of something that can be added to a ship.  It confused me to no end when I was redesigning the spreadsheet and doing the statistical analysis.

All that aside, thanks for the help.

shift

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