Keep in mind that these changes are minimal. There are some combinations that are radically different (e.g. Crn/Sct) but I'm really just doing this because I want to be as close to "correct" as possible.
I don't see a need to go back and redo ships that have already been created. For example, even if every single one of your weapons had the Dfs/Tls combination (one of the largest changes) the final Combat Rating would only be off by about 10%.
To change your v1.04 Drydock to compute Seeking weapons accurately, do the following:
1) Unprotect the WEAPONS tab.
2) Unhide alll rows.
3) Insert a column between BA and BB.
4) Enter the following in cell BB2:
=IFERROR(ROUND(B2*IF(B2<0,-1,1)*C2*VLOOKUP(D2,TABLES!A:B,2)*IF(E2=0,0,(E2+0.25))*IF(F2=0,0,(F2+0.6))*PRODUCT(R2:V2,AB2,AP2),1),0)
5) Enter the following into cell BC2:
=IF(B2<0,(BB2*C2*ABS(B2)*0.19)^0.5,0)
6) Enter the following into cell L2:
=BB2+BC2
7) Fill the new formulas down to row 101 in columns L, BB, and BC.
8) Hide columns M:BF.
9) Protect the tab.