Shallistra

I am getting 1891 Average TPS with exorcism when I plug in the stats of a BE Paladin in BT/Hyjal gear.

With Lightbringer Armor bonuses it comes out to 1943 Average TPS and 1033 DPS.

Out of curiousity, what are your calculated effects for weapon skill in terms of dodge/parry reduction? You're also missing the Sacred Duty talent, which is making your HP display seem lower than it is. There is something else missing that is making my calculations not match yours for HP, but I haven't been able to find it yet.

 

Evolve

For weapon skill, I assume 0.24% more chance to hit per weapon skill (from miss, dodge, parry & block) but that should really be 0.16% after I just checked (correct me if i'm wrong), about Sacred Duty, I just added it and also fixed weapon skill. But I'm at work at the moment so can only upload it tonight

 

Shallistra

- MP5 cell is not being factored into calculations.
- Lightbringer bonuses missing.
- MotW missing from Stamina Calculations
- Divine Intellect Missing from int calculations
- Total HP calculation missing Commanding Shout
- Justicar 2 Piece set bonus not being calculated
- Justicar 4 Piece set bonus not being calculated
- Autoattack calculations look just plain wrong.
- Judgement timer does not change when you remove Improved Judgement.

Would be nice to have consumables to choose from as well. Specifically defensive and spell damage consumables.

 

Terregor

The agi that the dodge % calculation is using is not the total(after buffs) rating, but instead the base rating. This doesn't reflect things like kings affecting your dodge %. I caught this because I've heavily tuned my gear to make me uncrushable with just kings as a buff, so when it showed that I could still be crushed I just tracked through the calcs until I found the problem.

Change B:135 to:

=F83%/21.8

takes care of it.


edit: oh, also there's something not quite right with the way it calculates total HP. Not sure what the problem is, but it doesn't match my unbuffed HP that the game reports.

 

◊ Oggie

For some odd reason, changing weapon speed is changing my TPS. I'm not perfectly clear on changing no other stat but going from 2.7 to 1.6 gives a 40ish TPS increase, and I'm not certain as to why- more SoR hits per cycle?

In addition, it doesn't seem to be factoring HS resists in. It's a pretty common misconnception that it's unresistable, because it's misreported in the combat log:
You can see it on any WWS with a pally tank, if you Browse Log, filter to Target and click 'resisted' and it'll show the HS resists.

Really should bug the author of that great tool to allow that possiblity in the parser until Bliz gets around to fixing the bugged logging.

 

bopz

since the coefficient of your spell damage applied to SoR depends on your weapon speed, then a faster weapon will hit more times with the inital value of SoR than a slower weapon.

 

◊ Oggie

I was under the impression that both the base per swing and coefficent per swing changed with weapon speed.

 

◊ Cathela

According to Wowhead, the damage for SoR with a one-hander is:

0.85 * (2610.43*(weapon speed)/100) + 0.03*(average weapon damage) - 1

which is equal to:

22.189*(weapon speed) + 0.03*(weapon speed)*(weapon dps) - 1

So, damage per second should be (above divided by weapon speed):

22.189 + 0.03*(weapon dps) - 1/(weapon speed)

Using that formula, a weapon with 41 white dps and 2.7 speed will give 23.048 dps from SoR, and a 41 dps weapon with 1.6 speed will give 22.794 dps from SoR.

So there's a slight dependence on weapon speed, but nowhere near 40 tps worth. (Assuming of course I'm reading the equation correctly on Wowhead.)

My comrades are my weapons, and I am their shield.

 

◊ zeidrich

Why is SoR and SoV power gain threat set at 45? Are you assuming use of libram of saints departed? If that is the case, it should allow it to be disabled, because many don't use that.

Secondly, if that's the case the threat attributed to the libram is too high. It should not be 45 threat per judgement, it would be 45*.25*1.9=~21.4 threat I believe.

Also, your threat gained from spiritual attunement is set at healing*.5, Does anyone have testing to show that this is the case? It would be intuitive to me that it would clock in at healing*.25*1.9 or healing*0.475 as well.

 

Evolve

Gaining the buff itself gives 45 power gain threat.

about spiritual attunement, it is healing/10*0.5 (aka, mana returned * 0.5) if it was healing *0.5 u'd get over 500 TPS from that only

also, I'll look into the speed and all the other issues. I have been quite busy lately :p

Everything fixed, I'll probably add consumables soon.

Could you please suggest a better autoattack calculation then please ?

Going from 2.7 to 1.6 weapon speed will double your white DPS, which also adds quite a bit of threat as white DPS = white TPS

Before I can that in, whats the resist rate of HS ? does it respect regular spell resistance ? (the fact that it is misreported in the combat log might be a pointer it doesn't)

Dodge fixed, thank you

 

◊ Oggie

I'm a braindamaged rodent, I completely neglected that rather than weapon dps and weapon speed you ask for weapon speed, min damage, and max damage (actually, can I suggest a move to the former with options to current implementation?). When I plug in normal values it looks fine, I just forgot how the SS handled damage overall.

Well, tonight, using this WWS:
Capricorn - WWS
and filtering it thusly:
Wow Web Stats

it's pretty easy to pull out a 19% resist rate. Leaving aside the concept that they may have tossed out a whole new hit table system, I think it's within reason that HS handles the normal spell mechanics and the random number generator hates me, so it's a normal 17% resist on a 73 mob.

 

Evolve

The SoR damage formulas require Minimum & Maximum weapon damage for the calculation, so I'm pretty much forced to ask for them (I'd rather not take averages out of the dps value)

Ok, added. On a side note, I removed all %-scaling talents from the spreadsheet. As they are included into the character tab if specced for them it will lead to them being doublecalculated if I include them.

edit: I really need to figure whats wrong with the HP calculation

 

Shallistra

Errors and Omissions:

- MPS generated from BoW is calculated wrong
- Spritual attunement gains are being calculated as 0 if Lightbringer bonus is not toggled.
- Sacred Duty not being factored into stamina calculations. Once this is corrected, the HP values should be accurate.
- Downranking Consecrate still gives full coefficient.

Autoattack calculations after the attack speed fixes look ok now.

 

Evolve

Fixed
Fixed
I have removed all procentual increases of stats as when you have the talent they are factored into your character sheet, so they will be included in your unbuffed stats automaticly.
Nice catch, what are the downranked coefficients ?
Autoattack calculations after the attack speed fixes look ok now.[/quote]

 

Shallistra

Both Sacred Duty and Divine Intellect factor into stat totals. This includes increases from buffs. For this reason, they should both be included in talents.

1 - (((Level at which next higher rank of Spell is Learned) + 5) / (Player's Level)) = Penalty Mod

For spells under level 20...

(20 - Level Spell is Learned) * .0375 = Penalty Mod

Also, spell crit rating is not being calculated on the spreadsheet in the spell crit section.

 

kronchev

Paladins in meh gear do a lot better tanking in 5 mans just because they can balls out AOE tank a few mobs at once. I was doing this in heroic SP no problem. In Kara however I noticed my threat was relativly low, and I could NEVER pull off the warrior MT even if I flipped out, 99% of this is because most of a paladin's threat is caused by getting hit (Holy Shield of course). Also that means that magic casting mobs are a dick to tank, I could not hold the mana worm trash before Curator worth a damn.


Thank you for this, though I notice the sheet is a few hundred points off on my stam, it gets everything else right. Wish I had a lot more block and spell damage :/

Elitist Jerks forum: Now work safe, because you don't want to get caught wasting your company's time!

It was a question of how the abilities of the fight are handled. I did not know the answer so I come to the place where I expect to see well formulated, concise and correct answers. Not snotty comments. - eclectic778

Vent is only necessary because of bad players. - ebbv

 

Aett

This is probably because they aren't really tankable; they de-aggro often and drain mana.

 

kronchev

Yeh but we lost at least 2 healers every pull. There has never been an issue with them ever before.

Elitist Jerks forum: Now work safe, because you don't want to get caught wasting your company's time!

It was a question of how the abilities of the fight are handled. I did not know the answer so I come to the place where I expect to see well formulated, concise and correct answers. Not snotty comments. - eclectic778

Vent is only necessary because of bad players. - ebbv

 

Evolve

You're right, I included them again, but it will be the user's task to calculate the stamina, strength, intellect & spelldamage values without his talents to input them into the stats sheet.

Thank you, added

Fixed

 

• Chicken

I think you're confusing them with the ones after Curator. Both do Drain Mana, but only the ones after Curator clear aggro all the time (And also happen to be immune to magic). I've personally never had trouble holding those against healing though (DPS is a different matter due to the mana drain), I just make a point of trying to generate as much threat as possible while I still have mana, and the only people ever attacked by them is either me or DPS.

And as much threat as possible on those is basically a combination of Consecration and Holy Shield and a few SoR hits. I will add that Arcane Torrent is fairly helpful here for me, but it's only available every other pull.

 

Shallistra

Now that most of the basic stuff is out of the way, here is a list of things to possibly add since you want it as accurate as possible without seeming unlikely in terms of group configuraion:

- Blood Frenzy
- Expose Weakness
- Hunters Mark
- Imp. Faerie Fire
- Bloodlust
- Power Infusion
- Insect Swarm
- Scorpid Sting

- Armor calculations
- Armor debuffs

You can probably start adding an equipment sheet + associated sheets, but that would take a little bit longer to do. Looking good so far.

 

Evolve

Good ideas, I'd love an equipment sheet, but that'd probably take macros to make, could anyone link me to a tutorial on excel macros ?

 

Rhî

If this really nice tps sheet will be continued, could you add a working function to the talent Crusade? It improves your damage done by 1/2/3% against demons, undeads, humanoids and elementals, but the sheet isn't calculating it.

 

Rhî

There seems to be an error in the calculating of JoC.

If you turn on JoC with improved talent 3/3 it increases only your auto-attack dmg. Can't figure it out why it increase the auto-attack damage, but, and that is the second error, it isn't increasing your spelldamage correctly.

The formula for JoC on sheet "Stats" at "F81" should look like (replace "wenn" with "if"):
And changed the formula for Imp. Joc at "F87" to:

 

Rhî

I have done several changes by myself. You can see the sheet here: RapidShare: 1-Click Webhosting

If you find any errors, please let me know. And maybe the originally author could forgive me for changing his really nice work.