{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":81,"n_cols":22,"rows_kept":81,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"AP Penetration Calculator & Guide for Steel Panthers WW2   by Cross"]
["Calculator"]
[null,"Enter"]
["Max Pen",24]
["Max Range",4500]
["Warhead size",5,null,"Extended Penetration Results"]
["Target Range",100,null,"range",100,200,300,400,500,600,700,800,900,1000,1250,1500,1750,2000,2500,3000,3500,4000]
["Pen result",24,null,"pen",24,23,23,23,22,22,22,21,21,20,20,19,18,17,15,13,12,10]
[]
["Guide",null,null,"hexes",2,4,6,8,10,12,14,16,18,20,25,30,35,40,50,60,70,80]
["German","Pen","Range","Warhd","100m",200,300,400,500,600,700,800,900,1000,1250,1500,1750,2000,2500,3000,3500,4000]
["2cm KwK38",4,1500,2,4,4,3,3,3,3,2,2,2,2,1,1]
["5cm L42",7,2500,3,7,7,6,6,6,6,5,5,5,5,4,4,3,3,1]
["5cm L42 sabot",12,1000,3,11,10,9,8,7,6,5,4,3,2]
["5cm L60",9,2500,3,9,8,8,8,8,7,7,7,6,6,5,5,4,3,2]
["5cm L60 sabot",15,1000,3,14,13,11,10,9,8,7,5,4,3]
["7.5 L24",5,3000,4,5,5,5,5,4,4,4,4,4,4,3,3,3,3,2,1]
["7.5 L43",12,3500,4,12,11,11,11,11,10,10,10,10,9,9,8,8,7,6,4,3]
["7.5 L43 sabot",16,2500,4,16,15,15,14,14,13,13,12,12,11,10,9,8,6,4]
["7.5 L48",13,3500,4,13,12,12,12,12,11,11,11,10,10,10,9,8,7,6,5,3]
["7.5 L48 sabot",17,2500,4,16,16,15,15,14,14,13,13,12,12,11,9,8,7,4]
["7.5 L70",16,4000,4,16,15,15,15,15,14,14,14,13,13,12,12,11,10,9,7,6,4]
["7.5 L70 sabot",23,3000,4,22,22,21,21,20,20,19,18,18,17,16,14,13,12,9,6]
["8.8 L56",15,4500,5,15,15,14,14,14,14,13,13,13,13,12,12,11,11,9,8,7,6]
["8.8 L56 sabot",21,3500,5,21,20,20,19,19,19,18,18,17,17,16,15,14,13,11,9,7]
["8.8 L71",24,4500,5,24,23,23,23,22,22,22,21,21,20,20,19,18,17,15,13,12,10]
[]
["British","Pen","Range","Warhd","100m",200,300,400,500,600,700,800,900,1000,1250,1500,1750,2000,2500,3000,3500,4000]
["2Pdr",7,2250,3,7,7,6,6,6,6,5,5,5,5,4,3,3,2]
["6Pdr",11,2500,3,11,10,10,10,9,9,9,8,8,7,7,6,5,4,2]
["6Pdr sabot",17,3000,3,17,16,16,15,15,14,14,13,13,12,11,10,9,8,6,3]
["75mm Mk V",8,3000,4,8,8,7,7,7,7,7,6,6,6,6,5,5,4,3,2]
["17Pdr",16,3500,4,16,15,15,15,14,14,14,13,13,13,12,11,10,9,7,6,4]
["17Pdr sabot",24,3500,4,23,23,22,22,21,21,20,20,19,19,18,16,15,14,11,9,6]
["25Pdr sabot",10,1200,5,9,9,8,8,7,7,6,6,5,4]
[]
["Russian","Pen","Range","Warhd","100m",200,300,400,500,600,700,800,900,1000,1250,1500,1750,2000,2500,3000,3500,4000]
["45mm L46",6,2250,3,6,6,5,5,5,5,5,4,4,4,3,3,2,2]
["57mm L73",11,2500,3,11,10,10,10,9,9,9,8,8,7,7,6,5,4,2]
["76mm L30",8,3000,4,8,8,7,7,7,7,7,6,6,6,6,5,5,4,3,2]
["76.2mm L41",10,3000,4,10,10,9,9,9,9,8,8,8,8,7,6,6,5,4,3]
["76.2mm L51",12,3000,4,12,11,11,11,11,10,10,10,9,9,8,8,7,6,5,3]
["85mm",12,4000,5,12,12,11,11,11,11,11,10,10,10,10,9,9,8,7,6,5,4]
[]
["US","Pen","Range","Warhd","100m",200,300,400,500,600,700,800,900,1000,1250,1500,1750,2000,2500,3000,3500,4000]
["37mm L53/L57  ",6,2000,2,6,6,5,5,5,5,4,4,4,4,3,2,2,1]
["57mm ",11,2500,3,11,10,10,10,9,9,9,8,8,7,7,6,5,4,2]
["75mm L37/L40",10,3000,4,10,10,9,9,9,9,8,8,8,8,7,6,6,5,4,3]
["76mm L53/L55",12,3500,4,12,11,11,11,11,10,10,10,10,9,9,8,8,7,6,4,3]
["76mm L55 sab",17,2500,4,16,16,15,15,14,14,13,13,12,12,11,9,8,7,4]
["90mm L52",15,4000,5,15,15,14,14,14,14,13,13,13,13,12,11,11,10,9,8,6,5]
["90mm L52 sab",23,2500,5,22,22,21,21,20,19,19,18,17,17,15,14,12,11,8]
[]
[]
[]
[]
[]
[]
["Important calculator notes:"]
[]
[null,"This is NOT an official SP release. Penetration tables cannot/have not been provided by the game designers."]
[null,"This is a reverse engineered estimate of how the game engine calculates AP pen. It is usually accurate to within 1cm."]
[]
[1,"Enter Max Pen, Max Range, Warhead Size and Target Range, to get a specific Penetration Result and Extended Results. "]
[2,"Only need to enter Max Pen, Max Range and Warhead Size to get the Extended Penetration Results. "]
[3,"Caution: Extended Penetration Results will give Pen values beyond the weapons max range."]
[4,"If you change the 'green' Extended ranges, the calculator will adjust the Pen for the new range."]
[]
[5,"The result is an estimate of the base penetration, so actual Pen will often be off by 1, occasionally by 2, rarely more. "]
[]
[6,"This calculator is only designed to be used with AP & sabot projectiles of warhead size 2,3,4,5."]
[]
[7,"NB. Gunners may fire HE ammo if it's likely to get better Pen and they may fire HEAT ammo if available."]
[]
[8,"Please note that British sabots have longer range, other nations shorter; this is not an error.  "]
[null,"The British WW2 sabot was the only 'true' sabot, and more effective than other nations."]
[]
[9,"I encourage you to change the example weapons in the Guide to ones you often use or come across.  "]
[]
[null,"by Cross"]
[null,"Credit: Thank you to my eldest son Jeremy, who wrote the Excel formula for me. "]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}