RPG Forums

Go Back   RPG Forums > Role Playing Game Section > Morrow Project/ Project Phoenix Forum

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #25  
Old 04-13-2014, 03:43 AM
kato13's Avatar
kato13 kato13 is online now
Administrator
 
Join Date: May 2007
Location: Chicago, Il USA
Posts: 3,647
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, 85 views)

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


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 05:08 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.