Nice to see improvements still coming. Two suggestions:
1) Agility assumes you're using whichever drive needs the most power. That's fine if the M-drive is the same or bigger than the J-drive. but if the J-drive is bigger, the sheet may not give you the real agility of the ship while running the m-drive.
For example, I have a 100-ton ship, J-5, 3G, with a Model 5 computer and no other energy-using systems. The ship has 8 EPs from the power plant, which is enough to power the J-drive and the computer. With only the M-drive and computer in use, I've got 2 EP left, which should give me Agility 2, but the spreadsheet says Agility 0.
This happens because the sheet is using the EP total at K148 to figure agility. that number is good for making sure you have enough power for either jump or maneuver, but it always uses the bigger number, even if it's the J-drive, which won't be running most of the time the ship needs to maneuver.
Here's what I'd do. In cell C152, replace "K148" with "SUM(K26,K38:K146)" That gives you agility based on the surplus power available while the M-drive is running, regardless of how much power tthe J-drive will need.
2) For mixed turrets, how about just having a couple of lookup tables with the possible combinations? First you chose double or triple turret, which determines which table to look on. Then you enter a number that corresponds to the combination you want. The spreadsheet gets the total cost, EPs, and the text description all from the lookup table. You won't even need the separate lines for each weapon, just one for the right combo.
Even if you mix pulse and beam lasers in the same turrets, I think these are all the possible options:
Doubles:
1 P-laser, 1 B-laser
1 P-laser, 1 Missile
1 P-laser, 1 Sand
1 B-laser, 1 Missile
1 B-laser, 1 Sand
1 Missile, 1 Sand
Triples:
2 P-laser, 1 B-laser
2 P-laser, 1 Missile
2 P-laser, 1 Sand
2 B-laser, 1 P-laser
2 B-laser, 1 Missile
2 B-Laser, 1 Sand
2 Missile, 1 P-laser
2 Missile, 1 B-laser
2 Missile, 1 Sand
2 Sand, 1 P-laser
2 Sand, 1 B-laser
2 Sand, 1 Missile
1 P-laser, 1 Missile, 1 Sand
1 B-laser, 1 missile, 1 sand