Guide: AP Penetration Calculator

[Cross]

I've attached an AP Penetration Calculator in Excel format.

So you'll need a read/write version of MS Excel to use it.

EDIT:

The game designers have now provided an official penetration calculator in the 4.0 game update.
Go into your WinSPWW2 folder, and you will see a file called WW2_APCalc.exe



I've attached the Penetration Calculator to this post in letter and A4 size.

Be sure to read the notes:

Important calculator notes:

This is NOT an official SP release. Penetration tables cannot/have not been provided by the game designers.
This is a reverse engineered estimate of how the game engine calculates AP pen. It is usually accurate to within 1cm.

• Enter Max Pen, Max Range, Warhead Size and Target Range, to get a specific Penetration Result and 'Matrix'.
• Only need to enter Max Pen, Max Range and Warhead Size to get the Matrix results.
• Caution: Matrix results will give Pen values beyond the weapons max range.
• If you change the 'green' Matrix ranges, the calculator will adjust the Pen for the new range.
  
• The result is an estimate of the base penetration, so actual Pen will often be off by 1, occasionally by 2, rarely more.
  
• This calculator is only designed to be used with AP & sabot projectiles of warhead size 2,3,4,5.
  
• NB. Gunners may fire HE ammo if it's likely to get better Pen and they may fire HEAT ammo if available.
  
• Please note that British sabots have longer range, other nations shorter; this is not an error. The British WW2 sabot was the only 'true' sabot, and more effective than other nations.
  
• I encourage you to change the example weapons in the Guide to ones you often use or come across.

Credit: Thank you to my eldest son Jeremy, who wrote the Excel formula for me.


.