Walrusface

Ok, perhaps there is a thread already and I have not found it.....but im looking for gear rankings much like the ones done for enhancement shamans Shaman: Enhancement My DPS is way low for a BM hunter, and I think its my gear but I'm not sure what I really should be looking for.

 

Kilrage

The Gear Planner tab on the hunter spreadsheet works ok, so does maxdps.com website.

 

◊ Sarutobi

It's a 10% chance for the trinket to proc. Once the trinket procs, every shot for the next 20 seconds adds to the buff stack, up to a maximum of 10.

EDIT: Now that I think about it, when the trinket procs and you go into the 'battle trance', I'm guessing you start off with 1 stack of the buff (anyone with the trinket c/d?), and if that's the case, then it would only take 9 shots after the proc to get to the max stack. I realize that it would only make a difference of ~1 second in the time it takes to get to the max stack, but we want to make this as accurate as possible.

 

Lawled

Ahh, well ignore that bit them

 

Indora

You're misreading it.
It's Shots per Seconds, not Seconds per Shot!

Two exmaples:
1. 0,5 Shots per Seconds (2 Seconds per Shot):
10 / 0.5 = 20 seconds until maxed

2. 2 Shots per Second (0,5 Second per Shot):
10 / 2 = 5 seconds until maxed

No, it starts with 0 stacks.
Reference: Rogue Gear Spreadsheet

@Cheeky
As far as I can see your calculations are correct (If 0.90 is rounded).



Btw, I have a question about your Hourglass of the Unraveller / Tsunami Talismus calculations...

Doesn't the internal cooldown start immideatly with the procc?
Your calculation implies it begins with the end of the procc.

 

bimmian

Equip: Chance on hit to enter a Battle Trance, during which your melee or ranged attacks will each grant 44 attack power, stacking up to 10 times. Expires after 20 sec.


Its a 1/10 chance to enter the battle trance state. Once you are in each shot will give you the stacking AP bonus.

 

Cheeky

I calculate uptime as 10/(45 seconds + time to trigger) - So I am not counting the proc duration in the space between the procs. (Otherwise the denominator would be 45 + 10 + time to trigger.)

Time to trigger is:
Looking at that now, I think I should be using Seconds per Shot as the operand, which yields a higher uptime for BM Hunters (which makes sense, as you shot faster you have a better chance of getting a critical hit sooner.)

I will fix that in the next release as well.

Cheeky of Havoc

 

Indora

Actually, you are using 45 + 10 + time to trigger as denominator.
Well, Time between proccs + 10, where Time between procs is 45 + time to trigger.

 

Cheeky

Whoops! I missed that I add that in on the cell below.

Removing that does make a noticeable difference in uptime, of 2-3%.

It actually makes the [Tsunami Talisman] a top-3 trinket for me. (Mostly because I do not model the interaction of the [Berserker's Call] with The Beast Within.)

Model is updated for next release (which may be lat tonight, I got all the gear added from Lactose's bug thread, and a good chunk of the requests.)

Cheeky of Havoc

 

Indora

What about adding an option to increase [Berserker's Call] and [Bloodlust Brooch]'s effect by ((HunterDps / TotalDps) * 8,5% {10% - the average of 1,5%} + (PetDps / TotalDps) * 42,5% {50% - the average of 7,5%}) * 18 / 20 {because only 18 of 20 seconds overlap with TBW}

 

Dafeaz

Since Cheeky is discontinuing the OO version...

...anyone know where I can get a free copy of Excel?

Some people think they can outsmart me. Maybe.

Maybe.

I've yet to meet one who can outsmart bullet.

 

Cheeky

Not so much discontinuing, as not supporting. I'm going to contact the individual who did the v49 OO version and see if he is interested in doing the v50 port. If not, I'm willing to work with anyone else who wants to take a stab at it. From what I understand it's mostly a matter of just rebinding the buttons to the VB scripts, and making minor changes where necessary.

You can combine the trinket with TBW by building a custom rotation with both effects active at once. As to how it interacts on pet DPS (which is far more significant) I'll give it some more thought. It will probably have to wait until the WotLK mechanics changes. Once I can get rid of shot rotations a lot more is able to be done easily.

Cheeky of Havoc

 

SpartanKillian

How can I set up my rotation to overlap TBW and Brooch/Call? Under the Shot Rotation tab I tried to add it to the Action column (having tried the average ability option on both yes and no), but it killed my dps, which makes me believe I must be doing something wrong.

 

Cheeky

Only build a rotation as long as the proc, and make your first shot Auto Shot or "None" (the rotation loops, so if you use a 2 minute cooldown ability first, it loops as 2 minutes.)

Cheeky of Havoc

 

Cheeky

Or, the WotLK preview version.

I imagine this will get updated quickly as I process more of the information coming out of Beta (which I should be in too.)

Change log:
- Gear Planner feature can now be filtered on Leather items, PvP items, and items that require you to have the requisite crafting skill to equip them.
- On advice from Cole of the ElitistJerks forums, I had discovered ways to significantly improve performance of most buttons.
- Fixed an error where the item set for Chest/Hands items was incorrect.
- Removed item set names/support for melee weapons.
- Added new gear (Sun-forged Cleaver, Vicious Hawkstrider Hauberk, Thalassian Ranger Gauntlets, Coif of Alleria, Cloak of Unforgivable Sin, Crux of the Apocolypse, Hand of the Deceiver, Brutal Gladiator's Chain Armor, Brutal Gladiator's Chain Gauntlets, Brutal Gladiator's Chain Helm, Brutal Gladiator's Chain Leggings, Brutal Gladiator's Chain Spaulders)
- Corrected some item stats (Thori'dal, the Stars' Fury, Ancient Amani Longbow, Darkmoon Card:Wrath)
- Corrected some spelling errors (Stalker's Chain Gauntlets, Blackened Naaru Sliver, Insignia of the Mag'hari Hero)
- Corrected expected DPS gain for Dragonspine Trophy
- Corrected a bug where expected DPS for Trinkets was always judging +hit on current values, regardless of setting on Gear Planner tab.
- Modeled the proc on the Blackened Naaru Sliver.
- When selecting a Scroll buff for pets, "Both" can be selected which adds +20 Strength and +20 Agility.
- Elixir of Demonslaying added as a Battle Elixir (only works if target type selected is Demon.)
- Corrected bugs in calculating the uptime of the Hourglass of the Unraveller and Tsunami Talisman procs.
- Model for multiple Wrath of the Lich King abilities. These are all preliminary models as feedback is returned from Beta testing. See the WotLK tabs for specifics.
- Removed the Intro tab, and combined it with the Change Log tab, added a link to a wonderful how-to on using this spreadsheet

Cheeky of Havoc

 

tappi

Golden bow of Quel'Thelas isn't recognized when loading from armory. Manually selecting/equipping still works.

 

Keltarrant

Sorry for the really late response, but i get that error whenever i try to open the program. I think its because I'm using microsoft works lol.
Gonna download Open office.

 

RSkillz

Hi Cheeky,

Thanks for making version 50, it's so much faster now!

But I have a weird bug, everytime I press on one of the buttons it gets smaller?
And one button actually groes bigger everytime I press on it.

Anyone else also having this problem?

 

Indora

I'm afraid this question is stupid, but where is the downloadlink for version 50?
(It isn't on the first side / in your post).

edit: Thank you Shandara.
To give this post any sense at all, here's my assumption for calculation Cobra Strike's effect:

It's just as easy as calculating MT uptime.

1-downtime
1-chance not to procc ^ attacks while up
1-(1-critchance*0.2*Cobra Strike) ^ (3 * Seconds per pet-special / Seconds per hunter-special)

Example:
-30% Critchance
-3 points in Cobra Strikes
-1.5 Seconds per pet-special
-1.5 Seconds per hunter-special

1-(1-0.3*0.6)^(3*1.5/1.5)
1-(1-18)^3
1-0.82^3
1-0.55
0.45

45% of the time, your pet will have 100% critchance.
55% of the time, your pet will have it's normal critchance (ie 20%).

effective critrate = Cobra Strike's uptime * 100% + (1- Cobra Strike's uptime) * Critchance
Example:
effective critrate = 0.45 + (1-0.45)*0.2 = 0.45 + 0.55 * 0.2 = 56%

edit2:
-imp. Aspekt of the Hawk provides 100% uptime.
-Invigorate only proccs on pet's special attacks (not white hits / KC)
-Assuming steady shot has a 2 second cast (btw, what's your source for this?), it still dosn't need to reduce your dps. It's possible to shoot with an 1.5 frequency. The next GCD can start already when the previous cast is at <0.5 seconds.
Using a Rotation like steady-arcane-steady-multi... would allow you to shoot without any delay (However, the cooldown of arcane-/multi shot prevents such a rotation.)

 

Shandara

The first post has v50, it's just not been updated to reflect that.

 

Hunterlin

PvP offset items of this season may need to be included:

[Guardian's Chain Bracers]
[Guardian's Chain Girdle]
[Guardian's Chain Sabatons]

[Guardian's Band of Triumph]
[Guardian's Pendant of Triumph].

And new epic versions (45 resiliece) of
Medallion of the Alliance
Medallion of the Horde.
They have same name as blue trinket, that why I link them without tags.

 

mike_rochannel

First: There is a typo in "Shoudler 2". I'm not sure if you use that Text to reference the line ..

Second: I look forward to meet "Mother Shahraz". But getting to 365 SR is not just a matter of slipping into the crafted mail items 'cause using all items together will give you 490SR. So it's more about combining the items that you have with those that you need to get to 295SR (= 365SR-70SR from the Buff). In deciding what to wear i noticed that the SR Items are missing from the pre-set Item-DB. I now used the "Custom Gear"-Tab, but actually that i had already used for other purposes. Can I talk you into adding the SR Items into your Item-DB?

It's the 4 crafted mail items

[Waistguard of Shackled Souls]
[Boots of Shackled Souls]
[Bracers of Shackled Souls]
[Greaves of Shackled Souls]

the neck

[Medallion of Karabor]
[Blessed Medallion of Karabor]

the back

[Night's End]

the armor kit

[Shadow Armor Kit]

the ring (in the +agility and +ap variant)

[Dark Band]

the enchantment for the cape

[Formula: Enchant Cloak - Greater Shadow Resistance]

the glyph for the head

[Arcanum of Shadow Warding]

Using your spreadsheet i was already able to optimize my equipment in a way that i lost only around 200DPS with full SR. Already thanx a lot to you But adding the items to the item-db would free the custom gear slots and made the process a lot easier.

Mike

 

mike_rochannel

Did you change the way the armory is accessed between 49 and 50? My Char has a funny Ã* in it (cause the version with just i was already taken) and while 49 had no problem reading gear and talents from the armory, version 50 complains about "not existing character" ...

Mike

 

groma

Your spreadsheet is the best thing (next to chocolate cake) there is, but I found a typo in v50:

[Crux of the Apocalypse]
is called
[Crux of the Apocolypse]
in the spreadsheet thus it's not found in Armory import.

edit:
Found some other few small things:
"Expose Weakness (not you)" does not work in the Target Debuff section. Setting it to "Yes" replaces the value in the AP field with "Improved 3/3" and nothing else changes.
And in the Target Debuff Section "(Improved) Expose Armor" (can be used on certain bosses like Kil'jaeden instead of Sunder Armor for higher Armor Reduction) is missing.

 

Cheeky

I'll see how that model works out for Cobra Strike. Thanks.

As to the rest:
1) I don't understand what you are saying? I think my model of IAotH is working accurately (~49.5% uptime for me.)
2) Ah, I missed that. It's not an uber-talent anymore then. It becomes ~150 Mp5, instead of 400+ for a raid buffed pet.
3) I think you are misunderstanding cast times and cool downs. Steady takes 2.0 seconds to cast (pre haste) and the GCD is 1.5s. Most Hunters will have <1.5s Steady Shot casts due to Quiver, Quick Shots, Windfury, and +haste gear.

I can look into adding some filtering for the new trinkets, and add the rest of the items easily enough.

What do you mean by "Shoulder 2"?

I'm not going to add the SR pieces, because they are equivalent to "None" in DPS. Just use "None" for your Mother set.

Not that I am aware of. It should be exactly the same, but I will verify to make sure. I know Drakier made some script changes in order for Open Office macros to work, I'll see what changes might have been made to the scraping code.

Will be corrected next version. Thank you.

Cheeky of Havoc