Hunter Spreadsheets -- In development - Page 61

Belzi.ET · 10/19/07, 12:30 PM

Originally Posted by Sumpfmolch

in the spreadsheet shot rotation:
steady casttime with quiver is 1,3s but the next shot starts after 1,5s because of gcd = 1,5s

wowwiki states:
Global Cooldown is refreshed when the spell ends, for spells with a casting time less than 1.5 seconds, and greater than 0.5 seconds.

shouldn't the next shot start at 1,3s instead of 1,5s ?

With a 1:1 auto-steady rotation, the next steady shot should come after 1.8s (1.3s steady-casttime an 0.5s for the internal auto-casttime) or later (depends on weapon speed).

A little off topic, but still about Hunters:
When I think about it. Is it possible, that this internal auto-casttime is affected by quiver and/or serpents swiftness (or even by IAotH)?
Have there been any tests about?

Glaurong · 10/20/07, 3:22 PM

Originally Posted by Belzi.ET

With a 1:1 auto-steady rotation, the next steady shot should come after 1.8s (1.3s steady-casttime an 0.5s for the internal auto-casttime) or later (depends on weapon speed).

A little off topic, but still about Hunters:
When I think about it. Is it possible, that this internal auto-casttime is affected by quiver and/or serpents swiftness (or even by IAotH)?
Have there been any tests about?

With the amount of jitter introduced into the combat log by latency it is pretty much impossible to determine. We still don't have an exact number for the hidden auto shot cast but a half second has worked as a good estimate for a while.

Baalrock · 10/21/07, 12:29 AM

ok I'm not sure whats going I'll click on the link for the spreadsheet it'll load, but when I try to input data a popup tells me I need to change the protection through the tool menu but that asks for a password... :S
any help is appreciated

Cheeky · 10/21/07, 1:21 AM

Originally Posted by Baalrock

ok I'm not sure whats going I'll click on the link for the spreadsheet it'll load, but when I try to input data a popup tells me I need to change the protection through the tool menu but that asks for a password... :S
any help is appreciated

Where are you trying to input data? All yellow fields are meant to be user-set. Everything else is protected.

Plague · 10/21/07, 1:26 AM

Found another bug for you Lactose/Cheeky.

Forest Prowler's Helm is giving a socket bonus of 2 resilience rating instead of 2MP5.

Thanks for keeping this spreadsheet so up to date, it is highly appreciated.

Cheeky · 10/21/07, 1:37 AM

Originally Posted by Plague

Found another bug for you Lactose/Cheeky.

Forest Prowler's Helm is giving a socket bonus of 2 resilience rating instead of 2MP5.

Thanks for keeping this spreadsheet so up to date, it is highly appreciated.

Thanks. It will be fixed in the next release.

Osse · 10/21/07, 10:47 AM

Has Gronnstalkers 4 hit rating socket bonus been changed to 4 crit yet?

Edit: Oct 18: [Gronnstalker's Helmet] - currently listed with +4 Hit Rating, should be +4 Crit Rating

Nvm.

Lactose · 10/21/07, 2:50 PM

Removing Elixir of Demonslaying from bug report. Tested, does not affect Ranged Attack Power.

Bismarck · 10/21/07, 7:50 PM

You maybe have already been made aware of this, but I'm noticing that in the "gear" tab, socket bonuses for Merciless Gladiator's Chain Spaulders (+3 res) and Veteran's Chain Bracers (+2 res) are not displaying or being factored into the totals.

Cheeky · 10/22/07, 9:54 AM

This version incorporates a few new big features. I have less faith in this being bug-free than any recent version, so don't delete your current version just yet. I'm going to need a lot of feedback to get the new Armory stuff just right.

If it works out, I'll add scraping talents specs as well. And expanding it to EU Armories. There is little error handling done yet, so if you specify invalid character names or realms all bets are off.

No new Open Office version yet. I anticipate a bunch of quick fixes this week.

Change Log:
- Added Sunder Armor and Faerie Fire to target debuff list.
- Cleaned up some validation lists to remove spaces. This was causing Open Office to fail a bunch of string comparisons.
- Updated the VLOOKUPs in the Gear page. This should remove any issues with alphabetizing the gear sets. (So yes, I was an idiot when I did it the first time.)
- Corrected math behind the effects of special pet attacks on frenzy uptime. This will result in a lower % time spent in Frenzy than previous versions.
- Fixed problem where Custom Bracers were not using the supplied values for Resilience and Armor Penetration.
- Corrected the description of the Unstable Citrine to be correct (8 AP, 4 Crit).
- Corrected a bug in the Pet Special Attacks table that resulted in negative rates of use for low focus regeneration.
- Fixed all issues with Resilience, Haste, and Armor Penetration on Custom Gear.
- Added new gear from 2.3 PTR.
- Consolidated all Arena gear set names to "Gladiator's Pursuit".
- Removed Weapon skill.
- Added in Troll/Dwarf racials
- Provide for a drop down choice of different raid Bosses to get armor values. These values have no been verified, and anything with a value of "9999" is still unknown. Custom target (armor supplied by user) is still available. These can be selected by choosing your Target on the 'Settings and Results' tab. I would like to thank Lactose of Talinvarr (EU) and Dayve of Gorgonnash for providing the values so far.
- Corrected some spelling mistakes in item names.
- Added ability to load gear from Armory for a character. This is still in initial development, and will probably be very buggy for a while. Each item/gem is validated. Sometimes there are spelling mistakes in this spreadsheet and the item will not be loaded properly. Please contact Cheeky with those mistakes and I will correct them as soon as I can. Item enchants are not currently supported. These still need to be updated manually. I would like to thank Mikla of Burning Legion for providing me examples and modules to make this feature possible.

Osse · 10/22/07, 10:22 AM

Curse of Recklessness?

Fendryl · 10/22/07, 10:28 AM

Originally Posted by Cheeky

- Added ability to load gear from Armory for a character. This is still in initial development, and will probably be very buggy for a while. Each item/gem is validated. Sometimes there are spelling mistakes in this spreadsheet and the item will not be loaded properly. Please contact Cheeky with those mistakes and I will correct them as soon as I can. Item enchants are not currently supported. These still need to be updated manually. I would like to thank Mikla of Burning Legion for providing me examples and modules to make this feature possible.

Wow, that's impressive & amazingly handy.

Beast-tamer's Shoulders generates an armory import error, as does the Band of Eternity. I'm not sure of a good solution for the rep rings, unless there's a way you can map from stats to the spreadsheet's db.

Also I noticed loading my v34 profile had a problem with an infused nightseye that's in my belt; reselecting the gem from the drop down fixed it though.

Cheeky · 10/22/07, 10:35 AM

Originally Posted by Osse

Curse of Recklessness?

Yeah, I'll add that to the list of things to add.

Just plain forgot about it.

Originally Posted by Fendryl

Wow, that's impressive & amazingly handy.

Beast-tamer's Shoulders generates an armory import error, as does the Band of Eternity. I'm not sure of a good solution for the rep rings, unless there's a way you can map from stats to the spreadsheet's db.

Also I noticed loading my v34 profile had a problem with an infused nightseye that's in my belt; reselecting the gem from the drop down fixed it though.

The rep rings are going to be a royal pain in the ass. I'll see about how hard it is to compare stats. They may just have to be a special case.

In all cases, drop down menus should work fine. The enchants not working is a limitation to my understanding of Armory's interfaces. I can get a number for the enchant, but no way to turn that into a name. (The idea of my researching the mapping myself is a non-starter, I don't have the time. If someone else wants to do it, I can map from those numbers to the enchant's name.)

I'm using all of you as my test team on this one. There are just too many things that need testing for me to do it myself. Keep the information coming. I'm provide updates every couple of days, I think. If you find spelling problems, please use the item tags feature in your response, so we guarantee the proper spelling.

Osse · 10/22/07, 10:39 AM

Gronnstalker's leggings arent giving set bonus.

Also, things to do list could do with the new 20 str pet food thats coming in 2.3. :-)

Hand adjustment is always there but having things listed is always nice.

Vilyah · 10/22/07, 10:51 AM

- Added in Troll/Dwarf racials

2.3 or pre-2.3 racials? My "ranged hit chance" is showing up as 96.2% and should be 99.2% with the current troll racial.