Gearknight

Overwrite the cell that says "improved 3/3" with the amount of AP provided for you by EW. The spreadsheet assumes 100% uptime here, so you may want to multiply your SV hunter's agi by something like 0.23 instead of 0.25 to account for imperfect uptime.

 

Indora

I've just found the error in Kaama's algorithm!
I think I'll have it ready (and written in visual basics) in one hour.
(It's already tested with Beast Mastery Bible )

edit:
Grrr... it's still not perfect. -.-

 

Jander

Madness of the Betrayer isn't getting it's average penetration benefit added.

Mana spring totem was never updated to 50 MP/5

 

◊ Lactose

It seems to be in version 47, at least:
1) With [Madness of the Betrayer] as one of your trinkets, note your listed DPS.
2) Set the trinket slot to 'None'.
3) In the 'Hand Adjust' fields, add 20 Hit Rating and 84 Attack Power.
4) Compare your current listed DPS with the DPS listed in 1).
5) In the 'Hand Adjust' field, add ~170 Armor Penetration. This is roughly the averaged out armor penetration benefit from [Madness of the Betrayer] -- exact value will vary somewhat based on user settings.
6) Compare listed DPS with DPS listed in 1).

Look, Lactose, we'd rather you didn't eradicate the whole human race.
- Sam & Max

 

Jander

Yes thats how I confirmed the error.

 

Cheeky

I've started work on an item comparison feature, I'm looking for feedback on appearance. It sorts items 2 ways. First based on your valuations per stat (gems included based on defaults) and valued again as if you had 0 +hit gear equipped. (For comparing items when you are above the hit cap because of current item.)



Please let me know if the appearance can use work.

Oh, you can filter gear based on your progression level too.

Cheeky of Havoc

 

Obellix

hi cheeky, i think i might be misunderstanding something but if you value gear based on 0 hit rating, a ring with plus hit would rank higher then a ring without hit rating on it even if it has less agility/AP. wouldn't it be better to set the hit value actually above the hit cap so that +hit on gear isn't taken into account?

 

◊ Lactose

I cannot verify your results.

Using my gear and some buffs as baseline:
In 1) ([Madness of the Betrayer] equipped as one of my trinkets -- trinket slot 1), I have a listed DPS of 2258.02.
In 4) (setting trinket slot to 'None', and adding 84 AP and 20 Hit Rating in the 'Hand Adjust' fields), I have a listed DPS of 2238.25. Comparing this to 1), I've seen a DPS loss. If the the Armor Penetration proc was not in some way added to my listed DPS, this would not have been the case.
In 5) (adding 170 Armor Penetration in the 'Hand Adjust' fields), I have a listed DPS of 2258.31. Comparing this to 1), my listed DPS is basically identical, with the small discrepancy most likely caused by not accurate enough +Armor Penetration value added in the 'Hand Adjust' field.

I also tested to see whether or not the trinket slot had anything to do with the reported issue. Swapping my trinkets around (so [Madness of the Betrayer] was in trinket slot 2), my listed DPS was identical in 1), 4) and 5).

Do you have any more details regarding this issue?

Look, Lactose, we'd rather you didn't eradicate the whole human race.
- Sam & Max

 

PrayForDeath

I seem to be having the same issue as Jander. Madness isn't getting the armor pen benefit. When I first started using the latest spreadsheet (ver 47) I noticed that the value of Madness suddenly got much lower than it used to in previousi spreadsheets.

I applied all those steps that you mentioned, Lactose, and the DPS from step 3 was indeed similar to the one from step 1.

 

Cheeky

I'm actually going to provide the ability to check versus your current hit or none.

Here is what that same setup looks like based off my current hit (143 - so over cap):



And resorting the list of top 10 based on that:



Does that answer your concerns?

Cheeky of Havoc

 

Cheeky

There is a bug with [Madness of the Betrayer]. Cell Calculations!Q14 is actually checking for [Black Bow of the Betrayer], because I'm an idiot and didn't fully test the changes to +ArmPen procs logic I put in.

Will be corrected shortly. Work around is to change the hand-adjust field to equal the value in cell Calculations!Q104. Sorry about that.

Cheeky of Havoc

 

Attumen

password protected spreadsheet? i cant input the 20 haste to wep from blacksmithing, will not let me modify the cells

 

Cheeky

Yep.

Cheeky of Havoc

 

Attumen

any way i can change a cell, or could the 20 haste be added? for wep enchants

 

Cheeky

There is a "hand adjust" area on the gear sheet. It's in blue. You can add any additional stats you'd like to it. Which enchant is missing? I should be able to get it added for you.

Cheeky of Havoc

 

Attumen

the enchant is from blacksmithing , a low level +20 haste rating for wep cant remember if its 1h or 2h but i have it on my waraxe

also since your on, i have a question, im not the most math inclined person in the world lol , most formulae just go in my eyes and get lost somewhere back in head.. what % of haste in your opinion would benefit the new SSO xbow the most?

 

Cheeky

There are full theads on that sort of topic (see the Help Me thread). Try and keep this one about the spreadsheet please.

Cheeky of Havoc

 

Attumen

sure thing, one other q about the sheet, i get a runtime error when trying to load my profile on 47, runtime error 1004but 46 works fine

 

Obellix

Yes i think so. thank you. I can't wait to try it out! Great work!

 

Byuu

Hm, on your list, the Band of the Eternal Champion ranks second, but on the spreadsheet both Signet of Primal Wrath and Angelistas Revenge seem to be better for me, even without sunder, cor and other apen gear.... strange!

 

Cattiebrie

Ah, was misreading. I was trying to input my Surv guy's Agi total, assuming it would get factored to the proper amount by the SS.

 

Thrug

Hey Cheeky,

Thanks again for all your hard work!

Regarding item comparisons, how about an option that takes into account swapping food buffs? One of the comparisons I constantly do with your spreadsheet is to see if it's good value to drop a +hit item and use +20 hit food instead of +20 agi food.

One example of this is dropping ye olde [Garona's Signet Ring] for [Angelista's Revenge], and swapping to +hit food gives me about an 11dps increase.

So the suggestion is as follows:

Add an option (in addition to the 2 you have) that allows a conversion of any +hit on the gear into +agi as a 1:1, and let people figure out where they are making the tradeoff (gems / item swaps etc).

 

Slunter

The comparison example looks fine mate and I cannot wait to see the final version.

A few questions/suggestions though:
- Are you planning on limiting the list to 10 items or is that only for the beta version?
- Would it be worth it making a filter for say, PvP, Vendor, Badges, Quested, Crafted BoP and BoE items?

 

Ashi

As first noted by RPZip in the DPS Warrior Compendium thread, the weapon damage part from [Adamantite Sharpening Stone] and [Adamantite Weightstone] now affects ranged damage:

After some testing, it seems it affects Auto-Shot and Multi-Shot, but (perhaps unsurprisingly - compare with ammo) not Steady Shot (and obviously not Arcane Shot).

Perhaps something to add to the spreadsheet.

 

Sniper

Hmm Cheeky, the ring dps list you posted just seems to be wrong. As said earlier compared with your spreadsheet hard khorium and certainly hyjal exalted ring give less dps then badge/za/twin ring. Why would the hyjal exalted ring be higher? I dont know, b