Quick glance, The threshold values are too high on the spreadsheet. They need to be divided by an additional 4.
AS:C pg 95
"This Threshold value equals the unit’s Alpha Strike armor value, divided by 3, and
then divided by the number of firing arcs (1 for aerospace, 4 for
others), rounding up."