Hunter Spreadsheets -- In development - Page 77

Ufthak · 04/28/08, 9:01 AM

I would like to echo Slunter's point on the additional filters for ranking.
One of my favourite item ranking sites has a nice set of options for what to show in the comparisons. I assume you are aware of it but incase you aren't:Loot Rank.

Would it be feasible for the currently selected item in the spreadsheet to be shown for ease of comparison in the results? Or have a Delta DPS column comparing with the current item?

Zearon · 04/28/08, 9:08 AM

Can some1 explain me why some hunters (including Ahoq of Nihilum) are using [Crossbow of Relentless Strikes] as it decreasing dps if you using 3/2 rotaion?
Even this 2.8 X-bow with 1/1 rotation are weaker than [Black Bow of the Betrayer] with 3/2.
So what's the trick????

Cheeky · 04/28/08, 9:22 AM

Originally Posted by 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?

I could do that, but I am assuming everyone has access to those areas. I did qualify location by Crafting, Quest, Honor, Arena, and Dungeon. I did not separate out BoP crafting from BoE crafting.

I am going to only put 10 items in the list. To do more for all the different gear types makes the page unworkable. You can always turn off higher end content to eliminate items.

The next release will only have the rings done. It's a lot of work to change an item class over, and I want to get more feedback before I jump in and spent 10 hours converting everything. Also, ranged weapons are not going to be supported for this. Weapon speed plays too much of a role in DPS, and can't be statically analyzed like other stats can.

Originally Posted by 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.

Is this new in 2.4? I can't imagine where that many people would choose one over a mana oil, but I could add them.

Originally Posted by 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, but you might have left out the 45 second inner cooldown and for the hard khorium ring to have more dps by that big of a margin looks silly.

Things that would be nice to be added would be Fericous Inspiration by other BM hunters in the group and Blood Frenzy (warrior 4% more physical damage debuff) aswell as the weapon coating which I'm figuring is going to be out next version already. Though personally I really don't mind the FI/blood frenzy though since I can just do the math by myself.

Thanks for the hard work.

The DPS is based on the DPS per stat for my character fully raid buffed. At those levels I compute:

[Hard Khorium Band] works out to:
30 * 0.674 + 28 * .879 + 58 * .306 = 20.22 + 24.61 + 17.75 = 62.58

It not exact, and it's not based on a relative value to your currently equipped rings. It also doesn't factor in a haste cap, or the fact that your stat valuations will change slightly as you change gear. But it is very fast, and moderately effective at pointing out potential upgrades. The [Band of the Eternal Champion] is modeled with a 45 second internal cooldown and a 10% chance on hit to proc. It's really an incredibly nice ring.

karvin · 04/28/08, 9:35 AM

Hi@ All,

To Connect via Proxy try that it works for me:

Function GetData(url, searchterm)
Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.4.0")
objXMLHTTP.Open "GET", url, False
objXMLHTTP.SetRequestHeader "User-Agent", "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-GB; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4"
objXMLHTTP.SetRequestHeader "Content-Type", "text/xml"
objXMLHTTP.SetRequestHeader "Accept-Language", "en"
objXMLHTTP.SetProxy 2, "proxy.lol.de:8080" ' <- Your Proxy!
objXMLHTTP.Send ""
Set xmlPG = objXMLHTTP.responseXML 'Get the XML in xmlPg
If xmlPG Is Nothing Or xmlPG.documentElement Is Nothing Then
Set GetData = Nothing
Else
Set GetData = xmlPG.documentElement.selectNodes(searchterm)
End If
Set objXMLHTTP = Nothing
Set xmlPG = Nothing
End Function

Have Fun.

Ashi · 04/28/08, 9:40 AM

Originally Posted by Cheeky

Is this new in 2.4? I can't imagine where that many people would choose one over a mana oil, but I could add them.

Yeah, seems like the same mechanic that gave ferals the benefit affected us too. It's worth just above 20ap per stone if you have a 2.8 speed weapon and auto-shot-damage amounts to about 35% of your ap-gain. (12/0.2 * 0.35 = 21), so not really comparable to oils, but there are a bunch of plausible situations where you are not starved for mana.

peterk0 · 04/28/08, 10:25 AM

Originally Posted by Cheeky

It not exact, and it's not based on a relative value to your currently equipped rings. It also doesn't factor in a haste cap, or the fact that your stat valuations will change slightly as you change gear. But it is very fast, and moderately effective at pointing out potential upgrades. The [Band of the Eternal Champion] is modeled with a 45 second internal cooldown and a 10% chance on hit to proc. It's really an incredibly nice ring.

Cheeky, I do believe internal cooldown is 60 seconds. I did just checked all the old combat logs, from brutallus trying, and it never proced less then 60 sec from the previous buff. It's true also according to Proc Rate Determination thread, here on EJ forums.

Cheeky · 04/28/08, 11:59 AM

Originally Posted by karvin

Hi@ All,

To Connect via Proxy try that it works for me:

Function GetData(url, searchterm)
Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.4.0")
objXMLHTTP.Open "GET", url, False
objXMLHTTP.SetRequestHeader "User-Agent", "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-GB; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4"
objXMLHTTP.SetRequestHeader "Content-Type", "text/xml"
objXMLHTTP.SetRequestHeader "Accept-Language", "en"
objXMLHTTP.SetProxy 2, "proxy.lol.de:8080" ' <- Your Proxy!
objXMLHTTP.Send ""
Set xmlPG = objXMLHTTP.responseXML 'Get the XML in xmlPg
If xmlPG Is Nothing Or xmlPG.documentElement Is Nothing Then
Set GetData = Nothing
Else
Set GetData = xmlPG.documentElement.selectNodes(searchterm)
End If
Set objXMLHTTP = Nothing
Set xmlPG = Nothing
End Function

Have Fun.

Thanks, I'll use this and provide a place to supply a proxy server.

Originally Posted by peterk0

Cheeky, I do believe internal cooldown is 60 seconds. I did just checked all the old combat logs, from brutallus trying, and it never proced less then 60 sec from the previous buff. It's true also according to Proc Rate Determination thread, here on EJ forums.

My version here at work has a 60 second cooldown, with 10% chance on proc. I may have been looking at the wrong item when I posted above. I'm seeing a proc every 70.5s and an average benefit just under 20 AP.

• Glaurong · 04/28/08, 1:34 PM

Originally Posted by Cheeky

Thanks, I'll use this and provide a place to supply a proxy server.

You don't need to modify the spreadsheet to get things to work with a proxy. I posted this a while back:

Originally Posted by Glaurong

It is a problem with your work internet set up.

Most times you don't have a DNS server that can resolve external addresses (turns Google into an IP address). Your browser just forwards the request on to your proxy and the proxy figures it all out.

The solution to your work day boredom lies within: You may need to run the Proxycfg tool for ServerXMLHTTP to work

Cranch · 04/28/08, 1:35 PM

As mentioned above, lootrank.com already allows putting in various weights for stats and will rank all items in wowhead; it also has a gems optimizer that maximizes the weight added by gems. lootrank doesn't work with item bonuses, nor items that are more complicated (i.e., dragonspine trophy.) Your spreadsheet works with bonuses and complicated items, but doesn't have a gems optimizer.

I'd actually use the gems optimizer more than an item comparison feature, especially when switching items around in the spreadsheet looking for an ideal upgrade path. Right now, I have to constantly correct the gems.

Regarding how to handle +hit, what I did in my separate item spreadsheet (done before lootrank) was list the dps gained both hit capped and not hit capped.

Thanks again for all your efforts on the spreadsheet!

Zearon · 04/29/08, 6:26 PM

errmm... any opinions about my question several replies above?

shaq · 04/29/08, 11:12 PM

Well, as a survival hunter with only 3 tier 6 pieces, the Relentless is my best DPS. With my current gear, it is better than either Archi's or Illidan's bow. This is with a 1:1.5 rotation with Hard Khorium Band as my only haste. More haste ruins it. Once I get my other T6, and one of the 3.0 bows, I can get a little better, but I have to take IAS, losing my readiness. The difference may not be worth it for me to do without the utility of Readiness.

Cranch · 04/30/08, 2:42 AM

Originally Posted by Zearon

Can some1 explain me why some hunters (including Ahoq of Nihilum) are using [Crossbow of Relentless Strikes] as it decreasing dps if you using 3/2 rotaion?
Even this 2.8 X-bow with 1/1 rotation are weaker than [Black Bow of the Betrayer] with 3/2.
So what's the trick????

It's all about latency. Try changing it in the Shot Rotation page.

Boovo · 04/30/08, 3:55 AM

Hi there

New poster here expecting flames for posting in wrong section

spent a good couple of hours this morning "playing" with Cheeky's spreadsheet and am having problems loading it in Excel 2003.

Once i've lowered security to get macros enabled, any time i hover over a button like Save profile, i get a macro debug screen with the error "Active X component can't create Object"

Putting security back up to disable macros means i can no longer click the save profile button, they are hard, not clickable.

I cant save the document at all, when i do i get the error "document not saved".

All this means that i've no way of persisting my own information, and have to say im now frustrated out of using a great tool, that seems to work for everyone else - have googled this a lot and trawled hundreds of forum pages

On another note when i initially open the document, excel shouts "File error: data may have been lost"

Help!

Thanks

Zearon · 04/30/08, 9:44 AM

Originally Posted by Cranch

It's all about latency. Try changing it in the Shot Rotation page.

I don't think Ahoq have latensy worst than mine (200-300).
So the question still actual.

◊ Estala · 04/30/08, 9:53 AM

I get an error using Excel 2003 when trying to load my gear from armory. I can load another hunter (Jehjeh) in my guild just fine but something about mine is causing a problem.

I get

Run-time error '1004':

Application-defined or object-defined error

It seems to happen somewhere between my two rings.

Regdar · 04/30/08, 10:02 AM

My Hard Khorium Band with +4 all stats enchant is causing a bug in the spreadsheet when loaded from my armory.

HgizmO · 04/30/08, 10:24 AM

Nice thx for update. When loading armory have error:

"Run-time error 1004:

aplication defined or object-defined error"

I set server name and char name corectly and its starting loading my gear and when is on about i think 80% this error showing up

Tukela · 04/30/08, 11:30 AM

Originally Posted by Estala

I get an error using Excel 2003 when trying to load my gear from armory. I can load another hunter (Jehjeh) in my guild just fine but something about mine is causing a problem.

I get

Run-time error '1004':

Application-defined or object-defined error

It seems to happen somewhere between my two rings.

I believe it has been reported there is a problem loading ring enchants.

I think Cheeky is currently trying to find a way to fix that.

Prvtdonut · 04/30/08, 2:18 PM

Is [Righteous Weapon Coating] in the works for the spreadsheet? I know it only works in Sunwell but it would be handy to have it availible for my Brutallus calculations.

Cheeky · 04/30/08, 6:00 PM

Originally Posted by Prvtdonut

Is [Righteous Weapon Coating] in the works for the spreadsheet? I know it only works in Sunwell but it would be handy to have it availible for my Brutallus calculations.

Get me a model (or PPM rates, chance on hit, internal cooldown, etc.) and I'll get it added.

Nakari · 04/30/08, 7:15 PM

Originally Posted by Cheeky

Get me a model (or PPM rates, chance on hit, internal cooldown, etc.) and I'll get it added.

From my oberservations, the AP buff has a ~45 sec internal cooldown and 10-15% proc chance. "Dual coatings" don't double-proc and share the internal cooldown, so putting two coatings on your weapons at best increases the proc's uptime slightly. Still, you're probably better of using Weapon Coating + Mana Oil. I'll try to get some more hard data from Brutallus tomorrow.

Cranch · 04/30/08, 11:56 PM

Originally Posted by Zearon

I don't think Ahoq have latensy worst than mine (200-300).
So the question still actual.

Perhaps he has better latency than you? Remember, you were asking why Ahoq used the badge crossbow.

Zearon · 05/01/08, 8:15 PM

Originally Posted by Cranch

Perhaps he has better latency than you? Remember, you were asking why Ahoq used the badge crossbow.

yes i remember... but dun ask why he's dps is higher than mine.. i asked why he used gimpy bage x-bow instead of BBB
even with 0 latency 3/2 BBB beats bage x-bow with ANY rotation...