Parsing Spell Damage Mod.

[Cielli]

Your math is much better than mine, thank you Pota. I had a question... /request...

Can you show/explain how Blast of sand & of Many would be calculated using this formula? I assumed since theyre equal cast time, Of many would be Blast of sand's benefit x 5... & used that for my calculations. But that doesnt line up with what I'm seeing here.

My Spear vs. Rain spell dmg benefit add up with what you have here if you multiply the rain benefit x 3, but Of many does not ... Here's the post I'm referring to where i was parsing spell damage.

these were the numbers i worked with

Using broiling sands ( 0.8 cast time ) I get a benefit of 26 more damage ( from a 37 spell damage item )

Using Rain ( 2.0 cast time ) I get a benefit of 85 more damage x 3 ( from the same 37 spell damage item )
Level 92 Rain gains exactly the same benefit as the lvl 99 rain, despite having half the base damage, so it is only based on cast time.

Using Spear ( 1.8 cast time ) I get a benefit of of 66 damage .

So you can actually calculate the difference here...

Using my parse with a weave of

Rain = 255
Rain = 255
Spear = 66
Spear = 66

Vs. a weave of

Of Many = 130
Rain = 255
Rain = 255
Spear = 66

My Parse weave = 642
Of Many weave = 706

a 10% difference ( 10 % of 3% = .03% )

[Potawatomi]

When doing this you also use the base cast times, not the hasted cast times.

Blast of sand
Recast = 2.35
Cast = 1.25
GCD = 1.5

Since the Recast is greater than the cool down, you would add 2.35 and 1.25, the cast time, together. Then use .167*(3.6-1) to find out x. X= .4342. Multiple X x Spell damage, 744. So .4342 x 744 = 323 added damage.

For Salvo its the following
Recast = 9
Cast time = .8
GCD = 1.5

So its 1*(Recast + Cast time)/7, 1*9.8/7 = 1.4
Then 1.4*744 = 1041

[Fleiss]

I didn't say 5x, I sad 5 hits, but I can see where that could be confusing.

Anyhow, while all this math is great and you could get a fair idea of how it works out, it really comes down to how much you cast (spells, clicks, procs). Each cast will get the benefit of spell damage. So if you are a light caster your benefits on DPS will be less. If you cast like mad (which your connection and ping will come into play) you will gt more benefit. You can't really just apply raw math to it, though it might give you some ball park areas. Way too many other factors come into play thus why people parse. But like i said to each there own.

[Blastnastie]

I've used my Spell damage and Cielli's in this. They can also still be modified by crits but I don't feel like finding all the info to do it at the moment, if I get free time I may. Or if some enterprising individual has the time go for it.

At 744 Spell Damage

Bolten of Molten Steel – 1*9/7 = 1.285714285714286
1.285714285714286 * 744 = 956 Damage

Savlo of Many – 1*9.8/7 = 1.4
1.4*744 = 1041.6 – 1041 Damage

Rain of Blistersteel – 1*16/7 = 2.285714285714286
2.285714285714286 * 744 = 1700 Damage

Rain of Scythes - 1*16/7 = 2.285714285714286
2.285714285714286 * 744 = 1700 Damage

Spear of Blistersteel – 1*12.5/7 = 1.785714285714286
1.785714285714286 * 744 = 1328 Damage

Spear of Molten Magma - 1*12.5/7 = 1.785714285714286
1.785714285714286 * 744 = 1328 Damage

Fickle Magma - .167*(6.75 – 1) = .96025
.96025 * 744 = 714.426 – 714 Damage


At 570 Spell Damage

Bolten of Molten Steel – 1*9/7 = 1.285714285714286
1.285714285714286 * 570 = 732

Savlo of Many – 1*9.8/7 = 1.4
1.4*570 = 1041.6 – 798

Rain of Blistersteel – 1*16/7 = 2.285714285714286
2.285714285714286 * 570 = 1302

Rain of Scythes - 1*16/7 = 2.285714285714286
22.285714285714286 * 570 = 1302

Spear of Blistersteel – 1*12.5/7 = 1.785714285714286
1.785714285714286 * 570 = 1017

Spear of Molten Magma - 1*12.5/7 = 1.785714285714286
1.785714285714286 * 570 = 1017

Fickle Magma - .167*(6.75 – 1) = .96025
.96025 * 570 = 547

I found this to be exceptionally insightful. I wish I would have wandered across this thread earlier before I began my own research this week.

Attached are my current results parsing out Iron Bolt Rk. III utilizing the CoTF T1 Raid Focus (47%-100%) in all instances, on a Model Paza (Level 95) dummy. It gives more variability (resists, focus variance, etc), however it also gives me a more accurate representation of how it will impact me in situations. My setup is very simple. No buffs - at all.

The formulas quoted above were exceptionally relevant. The formula for spell damage given by the above poster for Bolt of Molten Steel is identical to the Spell Damage formula I derived for Iron Bolt Rk. III through trial and backwards calculation. I also have the critical damage coefficient as well (4.3684) that seems to predict max crit values as they scale with spell damage for Iron Bolt Rk. III.

I also have a decent statistical breakdown included with each parse, including a 95% Confidence Interval on the Mean. One large problem i'm having here is that even with 3000-4000 data points, my confidence interval for population mean is not going below a variance of almost 1,000. That partially explains why my Mean % increase PPSD (Per Point of Spell Damage) is fluctuating.

The questions that i'm still wondering here is, does spell damage scale the same with and without focuses? I can parse that easily enough. Also, why would the non-crit PPSD coefficient be 1.286ish, but the critical coefficient is 4.368? Is there a comparable ratio that will work across all spells for crits? Also, given that my base crit chance unbuffed is 58% (12,000 data points), shouldn't we be calculating in critical percentages as well when evaluating spell damage? Such as, (Non-Crit % * 1.2857)+(Crit % * 4.3684)? This gives me a valuation of 3.07 consistently per point of spell damage in actual testing.

Any thoughts on how to proceed, or data you would like? I'm kind of working my way through the beginning of this process, so any insights you mages may have would be quite valuable.

v/r

[Potawatomi]

The questions that i'm still wondering here is, does spell damage scale the same with and without focuses? I can parse that easily enough. Also, why would the non-crit PPSD coefficient be 1.286ish, but the critical coefficient is 4.368? Is there a comparable ratio that will work across all spells for crits? Also, given that my base crit chance unbuffed is 58% (12,000 data points), shouldn't we be calculating in critical percentages as well when evaluating spell damage? Such as, (Non-Crit % * 1.2857)+(Crit % * 4.3684)? This gives me a valuation of 3.07 consistently per point of spell damage in actual testing.


For this, I suggest strolling over to the eq forums https://forums.station.sony.com/eq/index.php and holler at beimeith. He'll have an answer for ya.