I was thinking of Interdictor ships being mostly generator with engines, a self defence flight and a few close in self defence weapons.
Ships that need defending.

It would be possible to make Interdictor Fields 10% SU as in the Compendium and then apply Tech Levels to it.

Uncle_Joe,
OK, I think that I have figured the solution with the Shockwave and Stutterdrive.
This should work with Excel as well as OpenOffice.
On the Template sheet:-
1) Merge cells Y44 with Z44, AA44 with AB44, Y54 with Z54 and AA54 with AB54.
2) Enter in Cell Y44    "ESU"
    Enter in Cell AA44   "=+$AR$6"
    Enter in Cell Y54       "HS(E+1)"
    Enter in Cell AA54    "=+$AM$5*($AM$6+1)*$AM$7"
(without the ")
3) Using Find & Replace,
    Find all  $Y$39:$AB$43   Replace with   $Y$39:$AB$44
    Find all  $Y$46:$AB$53   Replace with   $Y$46:$AB$54

That should do it.

WarpFlame,
I'm no expert but I found this solution.
On the Tables sheet, Unprotect the sheet in Tools/Protect Document/Sheet as you would on the Nations sheet.

Put B1 in Name Box and go to Format/Column/Width. Tick Default Value.
You should now be able to see Column B

Do the same for Column C

In the To Hit array, In Column B delete the + signs.
The To Hit Column on the Nations sheet just had the number, no +.
This should work now.

I use Open Office 2.0

The "sheet Protect" can stop the drop down menu working properly, so can not allowing the macros when opening the sheet.

Try going to "Tools/Protect Document/Sheet" on the first (Nation) sheet. if there is a tick against "sheet" select it to remove the protection.

I had to do this when I first tried using this spreadsheet.