Hunter Spreadsheets -- In development - Page 94

Rødefar · 07/25/08, 3:38 AM

Originally Posted by Voldan

hmm the new Sheet can´t read from the european Armory. Is it a bug or a feature?

The EU armory works for my GF (yes she is a hunter too) she have no problem with the 50.

@Gistum
Thanks the function solved my ø problem in my name. Realy easy to do.

kenth · 07/25/08, 1:17 PM

Looks like reverting the code back to read the armory made it so proxy servers didn't work anymore. They did in 50 but don't in 51 again. Back to not reading the armory from work again and entering things by hand.

Cheeky · 07/25/08, 1:35 PM

Originally Posted by kenth

Looks like reverting the code back to read the armory made it so proxy servers didn't work anymore. They did in 50 but don't in 51 again. Back to not reading the armory from work again and entering things by hand.

Gah, I can't win...

If I had to pick, I'd open up Armory to the funny-named Europeans over proxy servers. Sorry those of you with fascist work regimes.

Indora · 07/25/08, 3:41 PM

Here are a few things I've noticed:

-The highest possible frequency for Multi shot is 10.5 instead of 10 (Just like 6 instead of 5 for arcane shot).
-Master Tactican's "Shots in 8 Seconds" is multiplied with 0 (Cell D51).
-Invigorate is calculated with normal critchance, instead of special attack's critchance (It's more than twice as effective as calculated now!)
-Frenzy uses base critchance for KC, white- & special attacks. (+20% for KC per Talent, ~ +30% for special attacks because of cobra strikes)
-same for FI
-roar of recovery uses GCD/focus even if it isn't skilled.
-Pet ability ranks aren't linked properly.

DreamScaper · 07/25/08, 11:45 PM

v50 and v51 im not able to import from 49. The file is accurate in my documents. deleted it and re-exported from v49. I can import into 47 but when i try v50 or v51 it freezes up for 15 mins and reverts to the last saved version. For example, if i changed cheeky of havoc to testing new name, when i import it goes back to cheeky of havoc.. The saved file is supposed to be DremScaper of Eldre-Thalas.

Xoran · 07/26/08, 5:43 AM

I found the saved data directly under C: with the new versions!

Gistum · 07/26/08, 7:09 AM

I made some tests to know why the v50 didn't work with special chars.

I made it work with manually entering the right value, so the issue is with the char encoding of the new v50 function.

Exemple with my servername :
Excel value : Confrérie du Thorium
Working value : Confr%C3%A9rie+du+Thorium

The solution would be to encode the realm variable to look like the example, though I didn't find any vba function doing that exactly.

Gistum

Gistum · 07/26/08, 8:50 AM

Well, with the use of an external free ActiveX to encode the needed url parts, I managed to load EU characters from the armory with the v50.

Here the way to do it.
1) You need to get the free activeX from here and load it in vba (unzip it, and load the .dll in the vba references)
2) Add the lines in red

Sub ScrapeItems(character As String, realm As String)
    Dim url, character_data
    Dim item_id As String
    Dim race As String
    Dim slot, sName As String, gem1 As String, gem2 As String, gem3 As String, enchant As String
    Dim sheet
    Dim slot_name
    Dim range
    Dim lastCalcValue
    Dim cks
    
    'Build URL for gear
    server = Worksheets("Realms").range("UrlStart").value
    
    'Encode the realm and the character name
    Set cks = CreateObject("CkString.CkString")
    cks.Str = realm
    realm = cks.GetEncoded("url", "utf-8")
    cks.Str = character
    character = cks.GetEncoded("url", "utf-8")
    
    url = "http://" & server & "/character-sheet.xml?r=" & realm & "&n=" & character & "&lang=en_us"
...

Sub scrapeTalents(character As String, realm As String)
    Dim url
    Dim talents As String
    Dim server As String
    Dim cks
    
    'Check Servers
    server = Worksheets("Realms").range("UrlStart").value
    
    'Encode the realm and the character name
    Set cks = CreateObject("CkString.CkString")
    cks.Str = realm
    realm = cks.GetEncoded("url", "utf-8")
    cks.Str = character
    character = cks.GetEncoded("url", "utf-8")
    
    url = "http://" & server & "/character-talents.xml?r=" & realm & "&n=" & character & "&lang=en_us"
...

Because of the external library (I didn't find functions

), I'm not sure if Cheeky can add it, but in the meantime, it can help some of you.

MasterKazoom · 07/27/08, 2:13 PM

Hi,

I cannot seem to get the various macro buttons to work. I lowered my macro security (down to low) like a previous poster said, but that didn't help. Clicking buttons like the recalc button in the Gear section does nothing, clicking buttons like read from armory for talent build opens the vb editor. I use Microsoft Excel 2003 SP2. Any help is appreciated.

Cranch · 07/27/08, 3:13 PM

Cheeky, thanks for v51! It's so snappy scraping the armory, I thought it was broken!

I did find a few minor bugs. The WotLK talents: Killer Instinct, Lightning Reflexes, Expose Weakness, and Master Tactician don't appear to work as planned.

Killer Instinct doesn't work because 'WotLK Calculations'!C35 references cell I168 instead of I16.

Lightning reflexes (in 'WotLK Calculations'!C4) doesn't work since that's using Gear!E93, which is updated only by the non-WotLK talent page (that's a workaround.)

Expose Weakness is actually working; the minor bug is that saying "No" in Buffs!B54 has no effect. Instead, you have to explicitly set the modifier to zero to turn off somebody else's EW.

For Master Tactician, 'WotLK Calculations'!C35 is just looking at 'WotLK Calculations'!H92, which has nothing in it.

Hope that helps!

coltofhonor · 07/30/08, 3:49 AM

I do still miss something in the spreadsheet (even if its possible to do it manually). I myself do swap weapon when I get some kind of hasteproc / cooldown which allows me to continue to use the 1:1 steady/auto rotation without clipping (or atleast less clipping) of autoshots. This may not be a great dpsincrease, but it is an increase. So my suggestion is that in a future release make it possible to assign a weapon to a proc or cooldown.

An example would be using a lower dps weapon like the merciless x-bow (88.2 dps - 3.0 speed) during DST proc instead of the badge x-bow (93.0 dps - 2.8 speed).

I did try to find anything at all about this in the elitistjerks forum (and on the internet as a whole). Perhaps its not something that other hunters do, or its just not thought of until now.

Faerdael · 07/30/08, 2:51 PM

This is probably because it is not a good idea.

Unless I am completely missing something, this would in fact be a decrease in net DPS. What you are talking about would incurr 2 global cooldowns on swaps. This is 3 seconds of lost dps time compared to swap in a weapon which does not need the extra .2 seconds of faster cast time.

Napkin math: Improved aspect of the hawk procs last for 12 seconds, so assuming you were in a position were a proc would bring you below a 1.3s auto shot, this would benefit roughly 8 shots at best, or 1.6 seconds of non-wasted bow speed in exchange for a harder hitting weapon, more or less.

To do this to swap in from the [Crossbow of Relentless Strikes] to the [Merciless Gladiator's Crossbow of the Phoenix] is especially a bad idea as top end weapon damage on Merciless is 318, while the Chickenator has a top end of 339, as well as superior stats.

Cheeky · 07/30/08, 3:53 PM

Originally Posted by coltofhonor

I do still miss something in the spreadsheet (even if its possible to do it manually). I myself do swap weapon when I get some kind of hasteproc / cooldown which allows me to continue to use the 1:1 steady/auto rotation without clipping (or atleast less clipping) of autoshots. This may not be a great dpsincrease, but it is an increase. So my suggestion is that in a future release make it possible to assign a weapon to a proc or cooldown.

An example would be using a lower dps weapon like the merciless x-bow (88.2 dps - 3.0 speed) during DST proc instead of the badge x-bow (93.0 dps - 2.8 speed).

I did try to find anything at all about this in the elitistjerks forum (and on the internet as a whole). Perhaps its not something that other hunters do, or its just not thought of until now.

That would be very difficult to implement, and of little value in general. Swapping weapons resets your shot timer to the unhasted shot time. You'd lose quite a bit of Autoshot DPS each time you did this.

But, since I am getting out of the spreadsheeting business, perhaps whoever decides to continue this little project may want to tackle the problem!

coltofhonor · 07/30/08, 10:15 PM

Perhaps the value of itemswaping is limited to longer sessions of extra haste. That is if you can sync rapid fire > haste potion > blood lust. This is indeed a limited use, still it would be fun to see the math behind it. I suppose I will have to give the calculations a shot myself.

The reason that I used the merciless x-bow in the example is becouse of the fact that it is a lower dps bow that still outperformes the badge bow at high rates of haste.

Stinkerbelle · 07/31/08, 3:14 AM

I suppose swapping would have a good chance to net marginal dps on bosses which require regular dps stops--Lurker, Naj'entus, ROS, Archimonde, Illidian... Most of these are not dps races though (with the exception of ROS).

Barradin · 07/31/08, 5:51 AM

Sorry to divert a bit here...

I'll admit up front that I never truly trusted the numbers out of cheeky's spreadsheet. But that being said, I wanted to try and see how accurately the spreadsheet could model an actual dr. boom test.

hear me out and please comment on what's missing/unmodellable in my setup here:

test setup:

aspect = viper.
1. using cast sequence macro (1:1).
2. Stable latency.
3. No items equipped that have random procs (dst, TT, hyjal rings, hourglass, etc).
4. Hunter's Mark: Not sure to test with this on/off... how exactly is this modelled in the spreadsheet? is it also 'averaged out'?

Spreadsheet modelling:

1. Booms armor reduced from 7700 to ____ (not sure). I heard 37% damage reduction which puts armor at about 6400
2. shot rotation tab: set aspect to viper. select 1:1 steady only. latency set to my typical latency. "macro?" set to "cast sequence"
3. Level of mob: only goes down to 70! (Can’t go lower than 70 but note that our crit chance and, thus, average shot damage should be higher than reported as a result).
4. All averaging out of trinkets, TBW, BW, etc. disabled.
5. All raid buffs removed. (do I need to enable/disable Hunter’s Mark somewhere? see above)

My idea, given the randomness of crits, is to check the core variables that add up to the final dps number including:
1. Shots per second
2. Damage per type of shot (in shot rotations tab)

I figure that under these conditions, I should (with multiple attempts of course) be able to achieve the identical number of shots per second as well as the damage per shot (though not always necessarily at the same time). I realize that the shot damage values listed in the shot rotation tab is a weighted average between your hits and your crits, but they still come up about 40 damage short of their averages (801 and 845 for auto and steady respectively). This is on top of the fact that I’m shooting at a target 2 levels below me.

I know that in the actual game, based on chance, you might get only the weaker hitting shots to crit and the harder shots to hit normally making your actual average shot damage lower than it’s theoretical average. But this should then lead to an even distribution of actual average shot damage values around the one predicted by cheeky. I’m consistently getting lower values.

I’ll do some more testing to clear up some of the randomness, but do other people also think that cheeky’s spreadsheet simply overestimates how hard you hit a mob for, thus giving a higher final dps readout than you should?

P.S. In checking the above out... is there any reason why the spreadsheet's reported 'crit chance vs lvl 70 mob' value changes when you change the value of the mob in the settings tab? I thought that so long as YOUR stats didn't change, the crit chance vs a lvl 70 mob should stay constant?

Quilde · 07/31/08, 8:39 AM

Is it just me or is lightning breath for Windserpents not giving any dps in the newest version of the spreadsheet?

Uthane · 07/31/08, 4:29 PM

[Golden Bow of Quel'Thalas] still not implemented.

Cranch · 07/31/08, 7:58 PM

Originally Posted by Cheeky

I am getting out of the spreadsheeting business

Sounds like a volunteer is needed! Thanks for all of your work so far! At least the shot rotation stuff will be a lot simpler in 3.0, so we can focus on the pet rotations.

Cheeky · 08/01/08, 12:45 AM

Final Version.

I am no longer going to be supporting the DPS Spreadsheet. It's been a fun 18 months, and I hope someone else feels the drive to continue this project.

There are no functional changes.

Change Log:
- Unlocked spreadsheet. This will be the final version supported by Cheeky.

Midnight · 08/01/08, 3:51 AM

That´s sad news indeed. Thanks for putting so much hard work into the spreadsheet. I salute to your mathematical knowledge and patience in answering the "lvl-73-target-mob-critrate" question.

It´s been a vital tool to me since I first found it on this pages. I really hope someone else will pick it up or makes some (more) rawr modules on par to the quality of your spreadsheet.

Londrai · 08/01/08, 3:59 AM

Yes sad news that's right.
This spreadsheet is such a great tool and /salute to your work!

I hope someone else will pick up this sheet and devolpe it at the same high standard as you did.

(sry for my bad englisch)

So long and thank you.

greetz Londrai

• Kamaa · 08/01/08, 7:41 AM

Don't be a stranger Cheeky. Your opinion is always be valued here.

◊ Lactose · 08/01/08, 9:03 AM

I will no longer be maintaining this thread.
Please do not send me any more PMs regarding bugs or feature requests regarding the spreadsheet.

Sealgair · 08/01/08, 11:16 AM

Thanks for all the time you put into this. It's been an amazing help for raiding. Wish you the best.