Iod

Also consider that the spreadsheet assumes that you've already fully stacked the damage bonus (440 AP) of Hunter's Mark. In practice this doesn't always happen (perhaps if there's an Improved HM hunter in charge of keeping it up, and fails to do so).

Though really, it's the 'human hands' thing.

 

-=Wolverine=-

First off Fantastic tool!

Having some difficulty in bringing in my Character using the spreadsheet to gather my characters information.

I've changed the info on the Settings tab, which I thought was what you needed to do to tell the spreadsheet to gather that data from the armory. I could be mistaken.

I'll also appologize if this is already covered somewhere in the 48 pages of messages, I may have missed it.

Or do I have to first create the profile with my current gear and save it and then it will go to the armory? just a guess.

Any tips would be appreciated.

Wolf

 

• Tsook

That's.. impressive. Hmm. I notice you have imp AotH but are not using a Dragonspine. Maybe the spreadsheet's modeling of Dragonspine (or else my own issues with continuing to weave properly during random proc hastes) is to blame.

I suppose the thing to do is test vs. a known target, e.g. Dr. Boom, where I can actually maintain the full rotation I have modeled in the sheet and see how close it gets. If I really am pissing away 400+ DPS through inaccurate weaving that's something I need to look at.

 

Fuulish

The S1 [Gladiator's Chain Helm] is missing a +4 resilience socket bonus.

 

vith

Minor Haste on gloves is more effective than 10 haste rating added manually. Probably still being counted as 1%? v39

 

Kamaa

This was posted a while back, but it's been nagging at the back of my mind. I don't believe you. Can you show a WWS to confirm this? I suspect if you even came close to the DPS theorized based on Cheeky's spreadsheet then it's due to things you didn't addd to the spreadsheet, ie blood lust and drums of battle.

EDIT: My apologies if my doubt seems hostile, but the spreadsheet says I am capable of 1800 DPS and I'm hitting about 1600 tops. I haven't fought gorefiend, but I have had fights where I didn't have to take a single step against Rage Winterchill because he never targeted me once. I had to mend pet a couple times, but nothing serious. If you're able to be within 6 DPS of you spreadsheet, then I am doing something terribly wrong.

Omegatron has arrived.

 

RareBeast

Just thought i'd point out that [Lohn'goron, Bow of the Torn-heart] does not import properly from armory. Possibly for the same reason my link isn't pointing to the working bow.

Thanks for all your work

 

tarsen

Hi there,

I've found the spreadsheet quite useful but I'd like some clarifications about it, hence this is why I'm posting. Hope somebody can help me out with this and maybe the OP can take some suggestions in consideration for the next versions of this nice tool:

1) Rapid Fire: Am I wrong or rapid fire isn't accounted for in any way in the spreadsheet? I believe there should be a switch to consider its dps potential and to average out its power.
2) Readiness: same as before, is it accounted in any way for dps potential? Ok, it doesn't do much, more or less 1 more rapid fire over five mins, but once you enable rapid fire calculations in the spreadsheet (which basically are already there), putting a switch for readiness shouldn't be that difficult
3) Ferocious Inspiration: If I'm BM and I do have this talent it's dps potential is fully considered. Problem is if I'm surv and grouped with BM hunter (which is always the case for me), I believe there should be a switch in the hunter and pet buffs to account for it (and maybe for multiple stacks, ie in case of 3 bm hunters in same party)
4) Heroism or Bloodlust: I believe it should be included in the buffs framework. Probably here you should consider switches to average out its potential, and maybe consider a further switch to average it out on a period inferior to its cooldown
5) Improved Judgement of the Crusader: I don't see many retribution paladins around but maybe it should be considered to include as target debuff. Just to realize its dps potential or lack of
6) Unleashed Rage: same as before, consider putting it under pet buffs
7) Blood frenzy: same as before, consider putting it under hunter and pet buffs
8) Curse of Shadows: I see there is no switch for 10% vs 13%; under calculations tab it is at 105% for arcane shot, is it that for real?

If anybody knows more about this please let me know, thanks for reading anyway
C ya
Tarsen

 

Glaurong

I do quite a bit more DPS on gorefiend than I do on winterchill. I actually beat what the spreadsheet says I will do on him by a fair amount. 2100 seems to be my max right now. That is sustained through the entire fight if I do nothing but stand and unload and don't get ghosted.

Wow Web Stats

Log Parser for BM Hunters (Right click, save as) - Updated 10/11/2007

 

joca

Awesome work on that spreadsheet. Just wanted to point out an item that I ran into a couple days and believe is not being properly modeled (at least it only has a value in the +crit column and absolutely nothing else in the other columns and is even marked as "No" in the "Proc?" column).

The item is [Hourglass of the Unraveller].

EDIT: How do I make it show with the proper item color? Tried searching the FAQ but couldn't find out how...

EDIT 2: Actually, just noticed that you guys aren't using the simpler wowhead.js script. How does one add item popup links here?

EDIT 3: Thanks to Hunterlin for telling me how to do item links. I had even tried the ITEM tag but tried it uppercase (like the URL tag that is inserted with the proper button), and it didn't work: it appears it HAS to be lowercase to work...

 

Kamaa

As I suspected, you got a bloodlust there and two drums of battle. You're not working within the constraints of the spreadsheet. I don't suggest you NOT use these buffs, but don't say that are are beating what the spreadsheet says when you're using buffs that are not accounted for on the spread sheet.

Omegatron has arrived.

 

Cheeky

Check the calculations tab, the proc is accounted for. The proc? column is in regards to user-triggerable procs.

Cheeky of Havoc

 

joca

/cast [target=self] Smack

Doh! Missed that Q section of the calculations tab somehow! In all honesty, I had not checked this version thoroughly: I did a check on a previous version (don't remember which one), that I got of somewhere else...

Still, blame's on me for not properly checking and following the formulas!

Great job there! Keep it up!

 

Indora

I think I've found one thing, because of which the spreadsheet calculates more than the real dps...

Imp. Hunters Mark gives my pet 335 AP. ^^

Pet Calculations!c20 seems to be wrong...

It calculates the AP the pet gets from my imp. Hunters Mark and checks whether its higher than the AP my pet gains out of all buffs it has (Buffs!E55)...

This doesn't makes any sense. ^^
You may change E55 to E48.

Edit: Changed wheather to whether.
Btw, I'm really sure that petdamage isn't calculated accurate.
I don't think my pet does 600 and more dps.

A few things that aren't calculated perfect: (Yes, high standart is recommend
Go for the Throat (Murphy's law)
KC frequency
Base DPS (I don't know why, but 440 dps (In my case) seems way to much.)

I'm sorry that this is only Criticism, without any ideas how to calculate it instead. :/

 

Cheeky

Thanks for catching that, I'll have it fixed shortly.

Cheeky of Havoc

 

Wunlastri

Just a small note that bothered me as I was using it. Is there a way to segregate gems by color? Since I probably will only SS at work, I can't check what gems I have excactly.

 

Cheeky

I haven't yet come up with a solution to that problem I really like yet. But I'll listen to any ideas on how to do it you have.

Cheeky of Havoc

 

Berkut

I've asked this before, without any luck with an answer.

Does anyone else have trouble with getting any of the buttons to work? The RESERT and Read from Armory buttons don't do anything for me - in fact, they do not even appear to activate.

Same with Save profile, Load Profile, Load Gear from Armory, etc. I suspect this is a setting issue of some kind, but no idea how to fix it. Any help?

 

Cheeky

This question has been answered over a dozen times in this thread:

1 - Are you using Excel? Open Office doesn't support Visual Basic.
2 - Are your security settings for Excel allowing Macros to execute? The buttons are macros.

Cheeky of Havoc

 

Berkut

Perhaps it has, but none of the answers have helped me yet, unfortunately.

1. Yes.
2 - I have all macro support turned on, still doesn't work. Maybe there is some hard coded security or something in the work version of excel.

If this question keeps coming up, perhaps a note in the Intro tab might be a good idea?

 

Kirrina

Exactly what version of excel are you using?

What do you mean by "work version of excel"?

Do you get an alert when you open the spreadsheet saying:

In the menu item Tools > Options > Security (tab) > Macro Security (button), what level do you have it set to? (Mine is Medium).

 

Cocopop

I would like to confirm this happens with my 2007 Excel, but no matter, I'll just use the old one.

And also, for me the buttons do not change or look clickable when I try with 2007 Excel. I suspect this is a compatability issue with the versions.

I can see now that this spreadsheet will be very handy for me, once I can use it fully.

Thanks,

Coco.

 

Berkut

Yeah, at work I have Excel AnnoyaingAsHell2007 version, where they took the intuitive and easy to use interface and messed it al up so you cannot find anything anymore.

Spreadsheet works fine at home, so that is where I shall use it. Thanks for the work Cheeky!

 

Xenoborg

Is the proc from [Band of the Eternal Champion] not current modeled in any form in the spreadsheet?

Intuition tells me its going to be better than anything other than devastation, but its scoring 10 dps lower then deceitful intent. If its only that amount lower and the proc isnt even counted thats likely a substantial increase.

 

Ishmaael

I was talking to rogue guildies about the [Band of the Eternal Champion] and they shared (along with their spreadsheets at the time) the opinion that it was more or less crap, and that the proc worked out to be something like 16 AP passive. Although I did hear that theirs still debate about its proc and that it might work out to more like 35 passive AP, making it indeed a nice ring.