Thread: Warhead data
View Single Post
  #50  
Old 12-02-2014, 01:26 PM
ArmySGT.'s Avatar
ArmySGT. ArmySGT. is offline
Internet Intellectual
 
Join Date: Jun 2011
Location: Colorado
Posts: 2,412
Default

Quote:
Originally Posted by kato13 View Post
I made an excel 2010 file with a selection list and RE lookup for DPW. I think it needed to be 2007 or above (xlsx) in order to do the lookup.

I also did a E-Factor formula if you enter the mm or penetration
= 48 * 2.5^(3.322*(LOG(B13) - 1.4049))

You can use this if you have a prior version of excel where B13 is the pen value in mm.

I have never really used these formulas (my gaming system uses Guns, Guns, Guns), so if there are errors let me know.

For the excel file enter/select the data in the yellow fields and the results are in the green fields.
Is there a version with the Explosives listed in alphabetical or grouped by type?

Also can A5 (98.5 to 99% RDX) be added?

Thanks!
Reply With Quote