@TJJ: As I understand it, the armor you're going up against is the combination of several adjacent cells, such that a ship with a listed armor strength of 1500 will - when undamaged - actually be using that 1500 in the resulting damage calculations.
That's not how I interpreted the wiki:
"Armor is divided into cells, distributed around the ship. Each cell has an armor rating equal to 1/8th the ship's armor rating. When the armor takes a hit, the cell at the point of impact and 20 surrounding cells[1] combine their armor values, with weighted average used to calculate the amount of armor that defends against the attack."
Thus a 4000 armour ship has armour cells of strength 500.
When an armour cell is hit, its strength is averaged* with the surrounding 20 cells, which still gives an armour rating in the range 0 - 500 (shipArmourRating/8).
*(weighed in some way, probably to favour the cells closest to the impact point)
I'm not sure I'm right, but Aeson's spreadsheet doesn't match up with the actual in-game experience.
So either:
1) Aeson's numbers are wrong.
2) My unscientific observations of actual combat are wrong.
3) Neither are wrong, we're just misinterpreting the meaning of the numbers.
It required least effort from me to tend towards opinion 3).