Guide: AP Penetration Calculator

[Cross]

Originally Posted by Lt. Ketch

Cross,

I took the liberty of formating the spread sheet so it's a little easier to read. (Colored every other row, added a meter to hex converter and generally put some color in it.) I'm anal like that. Attached is a 97-03 excel versions. Nice work. This will come in handy. When you crack the HEAT code for MBT let me know and I'll help you put the table together. Kudos to your son for hammering the forumla. My wife has to do all of my calculations.

Thanks Lt Ketch. Some good improvements.

I updated my spreadsheet, using your shading idea, and I also added Hexes above the ranges, for those who 'think' in hexes rather than metres/meters.

Thanks also to Imp for his suggested improvements.

I do think wargamers tend to be a bit more anal than the average guy.

I'll upload version 3.0 to my orignal post.

cheers,
Simon