Thread: Warhead data
View Single Post
  #32  
Old 04-13-2014, 07:06 AM
nuke11 nuke11 is offline
Registered User
 
Join Date: Jul 2009
Posts: 306
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.
When I click on the attachment is downloads attachment.php, but if I rename it to "morrow_ex.xlsx" it works fine.

I'll go thru the formula to see how it stands up.

Thank you.
Reply With Quote