Scio

Sorry was a bit tired when I wrote this but now as I was parcing my proccwatch after tonights BT run using ashtounge I ran into my raid from yesterday witch I previosly wrote about - and it suprisingly showed that the DST procced directly AFTER the buff had ran out. I have no idea how this happened but I belive it was during heroism. Could heroism bugg the internal of trinkets? Or did it bug my proccwatch. Altho I had the distinct feeling that I was more hasted then just from the heroism.

 

sepulturian

Hi, I just downloaded your spreedsheet however it is not allowing me to click the buttons on the top ie the Clear buffs button or the Load from armory button. I am using office 2007, is there anything I need to do first in order to get them to work?

 

longjohnson

OK, I think I have gotten to the bottom of why I was getting such small gains with haste between version 47 and 49. It seems to be related to the latency field from the Shot Rotation tab. Putting a high latency has a dramtic affect upon the effect of haste.

For example, using Vengeful Gladiator's Rifle (3.0 speed) and making adjustmemnts to the "blue field" haste figures on the Gear sheet has the following results:

0.2 latency with +10 haste yields 5.50 dps gain
0.5 latency with +10 haste yields 3.00 dps gain
1.0 latency with +10 haste yields 0.08 dps gain

The latency field also has a severe impact upon the dps figures that are normally achieved.

1. Is this an accurate modelling of the effects of latency and haste? I would have thought low latency just affected the timing of shots not how the haste values scale.

2. Given the changes to client/server side made in 2.3, does latency really have that great an impact these days?

3. Does low latency really mean that haste gear is a waste?

Cheers

Longjohnson

 

Falafel

I have exactly the same problem as I posted on the previous page.

 

• Praxx

When you open the spread sheet and you receive the macro security warning make sure to select Enable Macros.

 

Runningelk

I'm trying to determine what trinkets are the best for me to use. I have Berserker's Call, Dragonspine Trophy, and the Shadowsong Panther. Using my common raid buffs (BoM, BoK, Food and Flask) I find the Berserker's call and Shadowsong Panther are the best for me right now. Does this sound correct? Here is my armory if that helps:Runningelk-Perenolde

This gets me to my second question on the use of the spreadsheet. For trinkets with a "USE" how do I ensure that "USE" is being calculated properly. I have the original settings under the "Settings and Results" tab so that AP and BW are averaged. Does this mean I do not have to select the trinkets and abilities in the "Shot Rotation" tabs?

I'm just trying to make sure I get things right before I start banking items. Thanks in advance.

 

akmenace22

Im a new user of Cheeky's spreadsheet and I was looking at the gear suggestion tab of the excel sheet. Currently, Im using 800 armor ignore roughly and some of the pieces its suggestion I replace would lower my armor ignore.

My question is does this sheet account for the amount of armor ignore a person has and how much it would drop to replace with pieces that have better base stats?

For example, it tells me I will notice a 7ish dps increase by losing my choker of serrated blades for the SSO exalted neck. Im not sure if droping 175 armor ignore for some agi and that proc would be a dps increase. Any thoughts?

 

Obellix

Theres a bug with the CalcAttributes button on the gear tab, I don't know if anyone have this behavior but when i hit it goes in a loop for about 3 minutes upping my hunter and total dps and then resets to the actual value. I'm using excel 2000 and last version of the spreadsheet i had installed was v.46 i think.

Also, does the gear planner take into account the sockets in gear? Is it leaving them as <blank> or using the <default gems> from the setting and result tab?

 

Vaxum

This is not a bug, the spreadsheet is busy computing the value of haste. If you scroll down so you can see line 89 (Hand Adjust) row R (Haste) before you press CalcAttributes, you'll see the values incrementing from +1 to +401 haste.

 

Slunter

I like the gear planner already, however I still have 1 or 2 suggestions:

Like kenth suggests it would be very usable to have the current item shown at all times. Especially when not in the listed top 10 items.
I know it is possible to limit the items available based on their sources, however I still get way to many un-interesting items listed that I would like to be able to filter out.
It would therefore be very nice to be able to filter out say BoP crafted items not obtainable due to different crafts as well as arena and PvP vendor items.

Keep up the good work!

 

Falafel

Works now, thanks for the tip

 

Obellix

Ok. Never had this behavior before.

 

Cheeky

The world's largest Multi-Quote (I love you Kaubel)

Latency can have a very bad effect, especially on /castsequence macros. If you use the 3:2 macro, or hand-time (compensating for latency) put in your reaction speed rather than latency in that location. It should be more accurate in what you see in game.

"Average out +AP on-use Trinkets" is the control to do just that for everything but the [Abacus of Violent Odds]. It computes what the average AP benefit is if you use it every cool down.

Ignore Armor does nothing for you pet, so right away you're losing 25% of it's expected value. Frequent use of Arcane Shot also minimizes what it does for you. In general it's not a great use of item budget, and the [Choker of Serrated Blades] is not a well-itemized item.

It actually goes until the value of 1 more haste is less than 0.1 DPS. I then call that value your haste cap. It builds a look up table of haste->DPS. If you ever looked at the table (you can't, I hide it) you can clearly see the cut-off where Quick Shots no longer benefits from haste. It works pretty well for estimating haste DPS.

I can add that in the future. Don't forget, this is really a beta of this feature. But keep the ideas coming!

It's new for the Gear Planner feature. I should probably provide controls to disable it...

Cheeky of Havoc

 

Kutless

Something I noticed is it appears the T6 belt is missing the hit rating in the spread sheet. The bracers also have the wrong stats showing up

 

Fuulish

@Cheeky

I really like the gear planner, kudos for putting that together. However, I seem to be getting some odd results.

I recently picked up Shadow-walker's Cord out of BT. I am currently wearing Belt of the Black Eagle. According to the gear planner, under the "based on current +hit" setting, the BT drop should be a fairly substantial increases over my crafted belt. The Shadow-walker's is listed as 76.07 vs the Black Eagle at 52.05. However, when I actually put those items into the gear tab, my overall dps drops by roughly 6 dps.

Do you know of anything I might be doing wrong to cause this? Also, I did go back to the Shot Rotation and Quick Shots tab to make sure I refreshed the rotations since there's haste on the Shadow-walker's.

Thanks much

 

Cranch

Did you check to see if you no longer met your metagem requirements with the Cord?

 

Fuulish

Yep, looked like meta was still okay.

Edit: Okay nevermind, I figured out my problem. I didn't click on "CalcAttributes" on the gear tab to recalc the values used to populate the gear planner. Once I did that with every gear change the gear planner updated as expected. I'm a nub....

 

Xenoborg

Are you sure, they both show up right to me.

 

KraxisSingular

Shifting Tanzanite isn't recognized by the spreadsheet.

 

Lib3ration

I'm trying to use the current version for cheeky's hunter calculation but I'm unable to get it to open or save it. Was it moved by chance?

 

Kapow

First off, awesome spreadsheet Cheeky, very well made and helps a LOT.

I just have 1 question though that I haven't found answers to as i read through the previous pages:

...On the buff list, I wondered how buffs that aren't available options are handled. Examples being Haste Potions, Blood Frenzy, Ferocious Inspiration from other Hunters, etc. Are they simply ignored in the spreadsheet, or given values that are used to calculate the DPS already?

Thanks for any information.

 

Gorgar (EU)

A quick question regarding Rapid Fire, is it taken into account? I saw yesterday that allowing Talent points in Rapid Killing wasn't improving my DPS on the spreadsheet (version 49).

 

Sandrielle

ok, just for next versions maybe we can add [Elixir of Demonslaying] now, since it should work for hunters now aswell.

also one thought regarding Buffs, maybe you can make 2 extra selections on top, like : have shaman / feral drood yes or no (cos that is basically the 2 classes we might be looking for) and that will basically swap all totems in or out for player and pet, same with the drood. its just an idea.

and another though is preset talent specs. like 2 or 3 you can save and load like gear and buffs.

i know it s maybe a lot to ask, just consider all that and implement if you feel like its worth and you got the time.

thx for all the work

 

Xeres

Solved


Some odd behavior in the Gear Tab

I'm wearing [Ranger-General's Chestguard]

I use the default epic gems, Shifting, Delicate and Glinting. The sum of my agility is 622 in this case.
No if i switch the Shifting or the Glinting to a Delicate so I loose the socket bonus of 4 agility, my total Agility drops by 11 points down to 611, although unless I didn't miss anything I'd should gain 1 agility.

If I switch both, the Shifting and Glinting to Delicate I'll get 616 agility and loose 6 points. Is it a bug or just me missing something?

/Edit

Same result by usinng the Custom slot

Is it possible that the sheet uses Socketbonus for each socket in this case? I'd gain +1 agility and loose 12 Agility if my assumption was right.

 

◊ Lactose

You're most likely disabling your metagem (+12 Agility).

A lot of people report problems with noticing when a metagem becomes disabled.
Do you have any suggestions which could make a disabled metagem easier to notice?

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