TSO DPS Efficiency - Page 6

dakkota · 06-07-2009, 01:58 PM

I think the fact we all managed to navigate our way to the Wizard class forum for Everquest 2 and actually know what were talking about, means were all nerds.

Stonestrong · 06-07-2009, 04:00 PM

Quote:

Originally Posted by Dextera

Thanks Eskio for performing those tests and creating a larger sample, it really helped clean things up.

So, in light of all these tests, it seems that SOE's crit system does as follows;

1. Roll = RNG(Min to Max)
1a. (Possible Crit Check)
2. Dmg = Roll * CritMultiplier
3. If Dmg < Max+1 then Dmg = Max+1

From all of this I've modified my spreadsheet's AvgDmg to;

Let:
Mi = Min Dmg
Ma = Max Dmg
CM = Critical Multiplier

Average Crit = if(Mi*CM < Ma+1, [(Ma+1)+(Ma*CM)]/2, [(Mi*CM)+(Ma*CM)]/2
*if(condition, if true, if false)

Therefore, Average Damage =

Or, in Layman's terms:

For people using Excel, I'm currently using;

=((((Max/CritMult)-(Max-Min))/(Max-Min))*(Max+1))+(((Max-Min)-((Max/CritMult)-(Max-Min)))/(Max-Min))*AvgCrit

Just Edit -> Replace each cell with your own spell's cell.

Side Note: Flames of Velious does not follow this method, since every hit will be larger than its Max+1 dmg value. So its AverageDmg = AverageCrit.

As always, I'm completely open to constructive criticism and evidence!

^^^^

Quote:

Originally Posted by Stonestrong

You guys are fucking nerds......

QFE

Dextera · 06-07-2009, 04:14 PM

Quote:

Originally Posted by Dextera

"If you can't raid at least 6 out of 7 days of the week, don't waste your time applying. Our start time is 7:00 PM - 8:00 PM eastern on weekdays and 4:00 PM eastern on weekends." -Jaraxx

You're raiding 6 days of the week. You're the fucking nerd. lol.

QFE.

I know simple math is hard for you. Stay in school.

Stonestrong · 06-07-2009, 05:00 PM

Quote:

Originally Posted by Dextera

QFE.

I know simple math is hard for you. Stay in school.

What are all those formulas doing for your dps, I'm going to go out on a limb and say you most probably still suck, am I right?

Slippery · 06-07-2009, 06:22 PM

If you are in a raiding guild I bet Stonestrong raids less then you.

Stonestrong · 06-07-2009, 10:16 PM

Quote:

Originally Posted by Slippery

If you are in a raiding guild I bet Stonestrong raids less then you.

Pretty much man, you know how it goes when you have everything on farm it only takes a couple hours to clear lockouts/contested. That shit that was quoted from our website is pretty old and outdated, and its mainly to deter any slackers.

The only time we actually spend time on anything is when we are learning new content or trying to get a ranking kill.

Shaydu · 06-12-2009, 04:57 PM

Quote:

Originally Posted by Dextera

Therefore, Average Damage =

Or, in Layman's terms:

For people using Excel, I'm currently using;

=((((Max/CritMult)-(Max-Min))/(Max-Min))*(Max+1))+(((Max-Min)-((Max/CritMult)-(Max-Min)))/(Max-Min))*AvgCrit

Just Edit -> Replace each cell with your own spell's cell.

Either I'm applying the information wrong, or there's a problem somewhere with your Average Damage equation--if I plug your equations into Excel, I get a higher Average Damage result the greater the difference is between Min Damage and Max Damage.

Thus:

A spell with a range of 4641 to 5556 with Crit Multiplier of 1.35 results in an Average Crit value of 6882.975 but an Average Damage number of 2244.88.

Changing the range to between 1 and 5556 results in an Average Crit of 6528.8 and an Average Damage of 6780.619.

I've quadruple-checked what I entered into Excel and it seems to match up with your equations, but I could be missing something somewhere. Can you recreate my results in your Excel setup? IOW, have I discovered a problem or am I just smoking crack?

Eskio · 06-12-2009, 05:15 PM

Your excel kungfu is weak my son.

Shaydu · 06-12-2009, 05:59 PM

Quote:

Originally Posted by Eskio

Your excel kungfu is weak my son.

Gah. Thanks. I was afraid of that.

Stupid crack.

Dextera · 06-12-2009, 06:45 PM

Working on it now.

But I see what's going on.