Excel Formula for Avg. Dam Calc

[Dank]

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

[Austinpowers]

I guess I should'nt change it huh? LOL

[Ash]

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?

[Dank]

yeah i think all +'s are applied after a successful hit .. i'm just calculating base average.