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.
Last edited by kato13; 04-13-2014 at 03:48 AM.
|