ww2steel Posted December 21, 2007 Share Posted December 21, 2007 Hello everyone! I have been working on a project for a while and have decided to release it to everyone. I have designed an Excel Spreadsheet and entered all of the data for armor thickness and angle and all of the gun data for all guns in the game (not small arms). It's complicated to program, but fairly straight forward to understand. (refer to the attached image - this is the user page) These graphs show a simplified ratio of relative gun performance to armor thickness. It interpolates the gun performance for losses in penetration over range AND armor angle. (It does frontal engagements only, for now.) For example 100mm of penetration on an armor plate that is 100mm thick is 100%. 50mm penetration is 50%... and so on. Thousands of trials that I have done show that with a % less than 90% very few penetrations (including partial) occur, such as weak points. The worst you normally get is some spall. Above 110% there is over 90% chance of penetration. At 125% there is over 90% chance of full penetration, with either full penetration or complete ricochet. If you look at the included and highly unfair example... On the left we have selected the Ferdinand with APCBC ammo, on the right a T-34M43 with APBC. On the Ferdinand, the turret and upper hull are at only 40%. THIS IS NOT A 40% CHANCE OF PENETRATION! This is a 0% chance of penetration! (There is of course a 5% chance of damage to external drive gear or primary weapons system.) You can see that the more heavily sloped lower hull is much more resistant to penetration versus this ammo type. As for the T-34, you can see that up to 2km in range there is a very good chance that a hit to any part of the front of this vehicle will penetrate. There is an irrelevant, but lower percentage for the highly sloped hull. This gives you a quick and easy visual reference of which frontal surface are vulnerable and at what range. Remember of course that there are many other variables such as accuracy and rate of fire that determine the outcome, but it's great for figuring out safety & danger envelopes and determining shot for shot who has an advantage. It does show the numerical figures on another part of the screen if you want to view them as well. The program is complete. I am just entering all of my data which is taking a long time, but I am nearly done. All I request is a $5 donation to my website. I will email the file to you. If you have already made a donation to my website, remind me and I will gladly send you the file right away. As new data gets entered I will send out new versions of the file as soon as they are complete. If interested, shoot me an email: mdows@ww2steel.com My website: www.ww2steel.com Thanks! Mike 0 Quote Link to comment Share on other sites More sharing options...
thewood Posted December 21, 2007 Share Posted December 21, 2007 I hereby apologize for no one thanking you for this tool within 1 minute of it going up. Thanks for all the work. 0 Quote Link to comment Share on other sites More sharing options...
ww2steel Posted December 22, 2007 Author Share Posted December 22, 2007 No problem! I just changed around a bunch of formulas to incorporate max range of the smaller weapons. ...still adding data.... 0 Quote Link to comment Share on other sites More sharing options...
CMFDR Posted July 11, 2008 Share Posted July 11, 2008 Donation sent Keep up the good job! 0 Quote Link to comment Share on other sites More sharing options...
tankibanki Posted July 11, 2008 Share Posted July 11, 2008 Another Donation on the way. I hope you didn't copy the data all by hand. Did you know that there are excel sheets with all the penetration data? In fact I'm more interested in a CMAK version of this programme. Any chance of using the CMAK Excel sheets to get the CMAK data in? 0 Quote Link to comment Share on other sites More sharing options...
ww2steel Posted July 11, 2008 Author Share Posted July 11, 2008 Hello, Glad you guys like it. Somebody dug up the old post. Now I have to figure out how to edit my post on this new forum because the new version pic doesn't match the text. As far as CMAK/CMBO data. Yes, it can be added... with maybe between a few days and a week of straight work. I will do it though, maybe when I am away at work. As far as the spreadsheets that are our there- they are a different format than I had to use for this program. I can type fast and have my own spreadsheets. The maker of those spreadsheets would not release them to me (since they are kind of copyrighted), even when this was a free project. That's cool, it's his choice. I have spent a tremendous amount of time on this game, what is on my website is maybe only about 2%, literally, of the work I have done. The maker of the spreadsheets did an awesome job, don't get me wrong, but there are mistakes. (There are certainly mistakes in mine too, probably some that are the same as his, because I checked my work with his!) BIG REVISION UNDER WAY. Those who get it today or later will get this new version. Please be patient while I plug in all of the equations! Mike 0 Quote Link to comment Share on other sites More sharing options...
ww2steel Posted July 11, 2008 Author Share Posted July 11, 2008 Oh, it won't let me edit the old post, but at least I get the big picture that you can't upload anymore! Bear with me folks, no T-34/ Ferdinand battle anymore! Mike 0 Quote Link to comment Share on other sites More sharing options...
Joachim Posted July 11, 2008 Share Posted July 11, 2008 Uploads are still possible... "Go advanced" under the quick reply box Then click the "Manage Attachments" button... and figure out the rest by yourself Gruß Joachim 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.