Thread: Warhead data
View Single Post
  #31  
Old 04-13-2014, 03:43 AM
kato13's Avatar
kato13 kato13 is offline
Administrator
 
Join Date: May 2007
Location: Chicago, Il USA
Posts: 3,714
Send a message via ICQ to kato13
Default

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.
Attached Files
File Type: xlsx morrow_ex.xlsx (12.8 KB, 88 views)

Last edited by kato13; 04-13-2014 at 03:48 AM.
Reply With Quote