|
Post by Dank on Jul 22, 2011 15:52:03 GMT -5
Just thought I'd pass this along to those of you with your own Jedi Equipment worksheets:
AVG DAM CALC
You can get this info from the game via identifies and info, but it's nice to have in your own sheet.
I have a column (L) that provides the dam dice descriptor, say, 5D5, 10D1 or 1D10.
The next column calculates the average damage per round of melee:
=VALUE(LEFT(L17,(VALUE(FIND("D",L17,1))-1)))*(VALUE(RIGHT(L17,(LEN(L17)-VALUE(FIND("D",L17,1)))))+1)/2
Cheers
|
|
|
Post by Austinpowers on Jul 23, 2011 15:22:33 GMT -5
I guess I should'nt change it huh? LOL
|
|
Ash
New Member
Posts: 14
|
Post by Ash on Aug 8, 2011 9:23:46 GMT -5
Do you know when the damroll bonus from the weapon is added into the calculations? Here are some specific questions about this: Are all damroll mods (from items, spells, str stat etc.) added in before any of the following multiplierss/reducers: 1) Sanctuary 2) Backstab or circle multiplier 3) Sitting/Sleeping position modifier (multiplier?) 4) Any others that I can't think of right now? If so, if your weapon also has a damroll modifier, wouldn't you add that into your calculation? For example, a 5d5 weapon with no damroll mod is going to have a 15 average while a 5d5 weapon with a 2 damroll mod is actually going to have a 17 average right?
|
|
|
Post by Dank on Aug 8, 2011 16:33:04 GMT -5
yeah i think all +'s are applied after a successful hit .. i'm just calculating base average.
|
|