Today instead of playing the videogame I chose to play with spreadsheets.

I wanted to compare infantry squad based on how much damage they do. Damage is hard to quantify since squads have mixed loadouts, different weapons do different things at different ranges and all sorts of other factors and so on. I chose to abstract damage output as the combined raw DPS of all of a squad's small arms combined at a given range pre-mitigation and assuming 100% accuracy, and called this value "Firepower" or FP. Penetration was ignored here because it's really just too complicated but also because it has a surprisingly marginal affect on small arms damage output, so in practice it wouldn't change much. This is necessarily an imperfect abstraction but it gives a general gist of how much a squad pays for its killing power relative to others.

The chart is ordered by Peak Firepower per Point, or essentially how cost-effective a squad's damage output is at 200m, when all possible small arms can fire. Firepower per Point at 400m range (the average range of most small arms) and at greater than 400m range (for squads that want to outrange you) are included for comparison's sake.
Cells are colour-coded for readability:
>Green
Best-in-slot for that faction
>Blue
Above average
>Uncoloured
Average
>Orange
Below Average
>Red
Bad or absent
>Yellow
Unique

Some other factors aren't covered by Firepower but still factor into the value of a squad like grenade launchers or AT, so I included them on the side for completion's sake. I grouped grenade and anti-infantry launchers into rough tiers and quantities just to show that they aren't all equal and coloured AT loosely based on how good or bad they are.