That sure sounds odd :o

Was thinking if it could be something with the encounter, but I'v done RoS quite many times myself and dont remember ever getting partial resists... Maybe I should check some of our old WWS files if they are still hosted

( Oh and welcome back Bellator, sure have missed you and your spreadsheet <3 )

Edit: Just went through the WWS reports and didint encounter any resists or partial resists on RoS encounter, though the reports are old, since our WWS guy stopped logging a while back, so I dunno, new mechanic? :P

1) No
2) Yes
3) No
4) No
5) Yes
6) Yes
7), 8), 9), 10) I believe JoB uses melee hit and crit, but works like a spell otherwise, i.e. it can be fully or partially resisted.

11) According to WoWWiki:
Calculation:
sLvl = Level that the rank of this spell can first be learned
cLvl = Caster's Current Level
Downranking Multiplier = Min(1, (sLvL + 11) / cLvl)

So for ranks 5 and 6 the coef is the normal 95%, rank 4 is 0.83%, rank 3 is 0.69%, and rank 2 is 0.56%.

Man, it's good to be back and see the community in full flow as usual

Avitus,

Regarding the weird behavoiur of JotC. I mentioned it briefly in my PM, but for the community I briefly mentioned the weird behaviour, though in far less detail a while ago.

The weird thing was that whilst the bonus damage from JotC was not getting any % modifier effects when used with Consecration, it was getting % modifiers applied to it for SoR. Some further investigation is definately needed here.

However for the time being, since SoR got the bonus damage, my model will assume that this applies to SoC. This is however an important issue as as you mentioned it is a loss of 89.5 spelldamage.

Rasputin, Anarkii, Habaka, Valeys

Thanks for the information on SoB/JoB

JoB seems to have bought about some differing opinion. I find it hard to imagine any damagin ability that doesnt suffer from either a resistance effect or a melee miss etc effect. For the time being i will treat it as resistable / partially resistable (as my general rule of thumb is its better to slightly underestimate the dps than overestimate it)

Again, with SoB, whilst the consensus seems that it can be missed dodged, parried but not partially resisted, the one example of the partial resist by Anarkii does bring doubt on this. For the time being i will make it partially resistable but not resistable.

I do ask, when you are raiding etc keep an eye on your combat log. And any screenshots, logs of these abilities you can get showining "S/JoB has been parried/blocked/resisted" etc etc would be great so we can get some conclusive evidence to on which to model.

Thanks though to all you (evil scum of the earth horde) paladins. Will do my upmost to get the latest version of the spreadsheet with SoB out today, with lots of extra goodies that have been suggested in my pms via Avitus and others.

Have a good day.

Just to make sure I wasn't the only one seeing a partial resist on SoB, I just went through logs of SoB use on Reliquary of Souls. Grant from Blood Legion was the first name that came to my mind, so this is a random pick :

Grant's Seal of Blood crits Essence of Anger for 2210 Holy damage (1021 resisted)

Grant - WWS

I then went and checked my logs for other encounters. There were other encounters where it definitely has partial resists, so it's not limited to RoS.

Is it something to do with hit rating? My current values are 93 hit rating + precision. That's 2 hit rating below the cap. (I can get capped, but this was the best balance I found).

Valerys,

Avitus did some testing on live which he pmed me. He found the coef to be:-

Consecration:

Rank 6: 64, 90 - 94%
Rank 5: 48, 74 - 94%
Rank 4: 35, 61 - 94%
Rank 3: 24, 45 - 76%
Rank 2: 15, 32 - 61%
Rank 1: 8, 21 - 47%

Thus i am a little uncertain of the wowwiki formula as it doesnt match.

I do however also need coefficients for the Ranks of Exorcism. For the time being i will use this formula as a close approximation, but if anyone happens to know / has time to test them out, please let me know.

Hey Guys,

Just to let you know I have uploaded the latest version of the paladin DPS model at it's new home at filefront. It can be found:-

[Replaced with version 28. See post 1363]

There are a number of big and small changes:-

Big Changes

1) SoB is now fully catered for. At the top of the character screen is a drop down box which you can select SoB/SoC from. Selecting SoB will change the skills in the skill overview section. The Graph at the bottom of the page and the "Strength Equivalency Points" calculation will both be based on SoB, and the item analysis page will run using SoB. (NOTE: If you run an item analysis with SoC, then switch to SoB you have to re-run the item analysis. It does not automatically get updated.

As a couple of examples to see the differences., take a look at the graph output. You will notice that Haste is far more valuabel when run with SoB as opposed to SoC. Also on the item analysis, you will see that when run with SoB that Cataclysm's edge beats Torch of the Damned

2) The way Consecration & Exorcism is modelled has changed. Previously they were tacked on as an extra being utilised by the 'spare mana' to give an extra dps boost. Now they have been integrated into the "Dps and Skill Overview" and their usage directly effects the "Time to OOM calculation".

If you look towards the bottom of the sheet you can see a section "Consecration / Exorcism Usage". Here you can change the Rank of the spells used (or turn it off). The dps time till OOM by default assume they are cast on cooldown, however there is also the option to override the cooldown and enter your own CD for these abilities.

As a result you can now play around with the different levels of the spells on a CD of your choosing and see how it effects your dps and time till OOM and adjust them to best bit your gear playstyle.

Small Changes

Added Furious Gizmatic Goggles
Added Mana Spring Totem and Mana Tide Totem
Added Dark / Demonic Rune
Added Drums of War & Drums of Battle
Added the Draenei trails Heroic Prescence and Inspirin Presence.


Anyway, enjoy the new model, and please tell me if there are bugs / errors that occur as there has been a lot of changes and little time to fully test everything.

Shalymar, is the dropdown box set to "All" when you ran it. As not been able to replicate this bug

One more bug: When I set Exorcism usage to OFF, it doesn't calc dps for consecration too.

Re: Belators New Sheet

Tytyty for putting out a new version! A couple changes I made which I made that some people may be interested in:

Added Shapeshifter's Signet: If you have way too much hit this ring is a cheap way to get some expertise
Added Sundered Chrysoprase: I have one in my Twinblade and its a good gem if you are already using a Shifting Tanzanite in some of your gear

Cheers!

4 is wrong, Sob can be partially resisted.

7) yes
8) yes
9) no
10) yes

If this is any help, here is my Recount of the night for SoB and JoB:

SoB:


JoB:


Additionally, here is our WWS of that night(please don't mind the terrible performance). I'm not overly familiar with WWS, but the dropdown menu does seem to show partial resists. So, for better than I:

Jayhanez WWS

Edit: As WWS treats SoB backlash identically with a hit, could backlashes on me which were partially absorbed by a PW:S or some other effect be skewing these results? In any case I'll try to watch my results and combat log more carefully next week.

This latest version of the dps sheet fixed the problem I was having. Yes, I had the dropdown box set to "All" when I ran it.

Say Bellator, does your Spreadsheet work with OpenOffice? If not, are you planning to create one compatible with O.Office in the futur?

Thanks!

Wow, great work on the new version, I'm on my way out atm, but I'll definitely dig into it as soon as I'm back!

I can confirm from previous tests that JotC is bugged for Consecration as well as Exorcism and does indeed not gain from multipliers.

I'll be doing some more tests for SoR, JoR, SoC and JoC later to see if it's the same here too.

jwhalley Profile, jwhalley Details - FileFront.com

Hi Guys,

I'm testing a new feature which i may try and incorporate into later versions and would like those of you familiar with the sheet to test it out. The file can be found:-

jwhalley Profile, jwhalley Details - FileFront.com

It is Called Version 29 Beta. (If you are not testing the new feature, its best to stick to version 28)

It is exactly the same as version 28, but had one extra sheet tab called "Insert Item". From here you can select a type of item to add, enter all the relevant details for the item (there are a couple of comments explaining things). Then click add item and it should be placed in the item database and be accessible from the character tab drop down menus.

What do you think. Is it worth pursuing?

---------------------------

Shalymer, glad to hear the bugs gone

Agonar, unfortunately my knowledge about open office and how to make an excel file with macros etc compatible with it is next to none. So unfortunately I dont have any short version of making and open office version sorry

Avitus, thanks for the info on jotc, and filefront

Ohhh nice!

Good job getting the SoB option in there

Only thing I noticed was Libram of Divine Judgement is a upgrade with a sob build... yet its a Soc libram... nothing major though

I'm pretty sure Exorcism can trigger JoW.

Bellator, about the beta. Just entered all my items, went to item calc and when it went through everything there came a "Type Mismatch" error. All items were calced, the current weapon is set to ---User Added----.

For the time being just ignore this libram when using SoB. In v29, this will be fixed and Libram of Divine Judgement won't give any benefit in a SoB build.

Hi Carpathia, I will include this as an option to turn on/off in v 29

Note that the "cost" of a skill in the "skills overview" section at the top of the character sheet is the base cost of the ability. It does not show reduction of cost from benedition / JoW etc here. However JoW is still been counted. This is shown in the "Judement of Wisdom" Line in the "Buffs / Debuffs" Section under Mp5. This is showing the mana gained from Jow through using all the abilities that can trigger it.

However, Exorcism and Consecration currently do not proc JoW in the spreadsheet. They will in v29

is there any way to lock hit rating? I mean that if your hit caped, items with + hit is less dps but the spread sheet still gives the dps increase.

would really help when trying to see if haste items are usefull, because atm they are all worse for me.

Deac, just to clarify, are you saying that when hit capped, if you selected another item that has +hit on it, you want the hit on the item to be taken into account in the dps value as if the hit was beneficial even though there will not be a gain based on this extra hit?

If this is the case, unfortunately there is no way to do this. All +hit is doing is reducing the change to miss statistic (which all dps calculations are driven from). Once miss reaches 0% it is impossible to get it go go lower, and the only way for extra +hit to have an effect would be to increase the miss % which would scew all the data.

What exactly is it you want to find out from the model? Maybe there is another way around it that i can help with.

What I think he means is: He thinks he's hit capped and the spreadsheet says he isn't, therefore giving high dps on +hit items.