I've been looking over the weapons spreadsheet you sent me and it's looking pretty good overall.
Some brief suggestions though:
Modifiers should be in at least blocks of 5% to make any difference. I've noticed a few 1% increments and such for some weapons. I guess increases/decreases in steps of 3 for increasing tech levels would be fine too for a specific weapon.
Some of the weapons that go from doing 0.25x damage to shields to 4x damage to shields, may be too effective at max tech - i.e. they are rated greater than 7 (on the spreadsheet) for a first strike against shields which is extremely high. Another note, what are the operation principles behind these weapons? I've noticed them for most races, but I'm not sure if it is reasonable for them to do pitiful damage against shields at low tech and crush them at high tech. Might it be better for them to either be a less effective weapon against shields at all levels, or a more effective weapon against shields rather than having this dual personality?
I'd think Klingon disruptors would be more of a high damage, less accurate weapon when compared against phasers. In general, I'd tend to make "bolt" or "pulse" weapons more damaging and less accurate for all races, while making "beam" weapons more accurate but less damaging.
Anyway, I'm hoping you've found that weapon calculator handy.
