Hunter Spreadsheets -- In development - Page 81

Iod · 12/19/07, 10:09 AM

Originally Posted by Tsook

Since the spreadsheet models a perfect rotation on a totally stationary target, I think it's a given it will provide somewhat inflated numbers. The question is, how much inflated?

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=- · 12/19/07, 7:43 PM

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 · 12/19/07, 9:17 PM

Originally Posted by Sympa

Actually - Inputting all the information for a fight like say teron (excluding the chance you get a ghost) has given me a perfect prediction every time. Within about 5-6 dps.

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 · 12/19/07, 9:20 PM

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

vith · 12/21/07, 1:44 AM

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

Kamaa · 12/21/07, 3:25 PM

Originally Posted by Sympa

Actually - Inputting all the information for a fight like say teron (excluding the chance you get a ghost) has given me a perfect prediction every time. Within about 5-6 dps.

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.

RareBeast · 12/21/07, 10:15 PM

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 · 12/22/07, 9:44 AM

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 · 12/24/07, 5:29 PM

Originally Posted by 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.

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

joca · 12/26/07, 8:17 PM

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 · 12/26/07, 8:30 PM

Originally Posted by 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

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.

Cheeky · 12/27/07, 11:10 AM

Originally Posted by 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...

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

joca · 12/27/07, 7:13 PM

Originally Posted by Cheeky

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

/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 · 12/28/07, 5:06 PM

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 · 12/29/07, 1:24 PM

Originally Posted by 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. :/

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