Sure there's already a spreadsheet somewhere for this, but my list has something special.
I don't know if this is already common knowledge, but in my games I realised that because weapon shot costs are rounded down, at certain TU values for a soldier, a weapon will get more (or less) shots than it usually does.
Specifically, the laser rifle can fire only 2 auto shots with a trooper with 50 + (any multiple of 3) TUs.
So, a trooper with 52 TUs can fire 3 auto shots and have 1 TU left (17.68 rounded down. 17x3 = 51).
A trooper with 53 TUs can only fire 2 auto shots and will have 17 TUs left (18.02 per shot. 18x3 = 54, which is 1 more than the trooper's TUs).
In the attached excel workbook, there's a sheet to calculate the exact number of shots for a trooper with any TU value for a weapon requiring any % of TUs to fire.
The weapon fire modes that have anomalies are marked with comments. Namely, the pistol snap fire and the laser rifle's auto fire.
In a nutshell, when using Laser Rifles, don't give the trooper 80 TUs, give him 79.
This can be viewed as a bug, it can be taken as strategy. It wouldn't take much to change the weapons so that these anomalies do not exist (make the laser rifle take 33% TUs to autofire), but depending on your perspective, that may be removing a valid strategy for the game.
My point of view is that since players can easily rig soldier health so that shooting them leaves a tiny fraction of health left (Power suit trooper with 61 health will take 2 plasma rifle shots and have 1 hp left), it is a valid strategy and should be left in.
EDIT: Oops, this probably should go to the other forum
Edited again: Updated file to have a column with auto fire hit chance (chance to score at least one hit with an auto shot). Note: All columns will update dynamically when any value is changed, but the auto fire hit chance value was generated using a macro. You will have to run the "thinger" macro again if you wish to have updated numbers.
Update 12Dec: Added a # of shots required to kill XX hp soldier column and a % of TUs required for kill. This column shows how many shots it'll take to kill a soldier with any given amount of HP. Also modified the weighted efficiency column to make more sense. From these stats you can see that at point blank range against power suits, the laser rifle is the most effective weapon, cutting down the target in only 34% TUs. Corrected an error in the plasma pistol stats, cost is lower now.
Edited by th15, 12 December 2004 - 12:06 AM.