revelator

I'm hesitant to post this as I can't imagine it's not there, but it appears that the T4 shoulders, Demon Stalker Shoulderguards, are not in the gear list. Perhaps I'm missing something, but I'm just not sure where else to look. Thanks for the time.

 

Thorongil

I´d favor agility for pvp. Firstly, the dps-boost is higher, secondly it gives you a higher burst-probability and last but not least more agility means more mitigation against melee-classes.

http://sig.gamerdna.com/quizzes/INFL...erks/Idril.png

 

Shandara

The "Settings and results" tab lists the spec under the rotation for each saved hunter profile instead of the actual rotation. Except Kaelvanas for some reason (he must be special).

If you have a Wind Serpent as a pet, the text on the same tab doesn't quite fit in the cell, cutting off a portion of the 'W' at the start and letting the 't' at the end dangle out into the next tab.

I'm using Excel 2000 though, so it might related to that.

 

Cheeky

You can set Custom target resilience on the 'Settings and Results' tab cell C34. Then select the Custom Target in cell A43. If you select a special target you get a raid boss who has 0 resilience. And because I'm extra nice, I brought you next year's version today. Be happy.

Whoops. That's a bug from my changing the layout of the 'Settings and Results' tab. I'll have that corrected in the next version. Kaelvanas is special because I didn't update him; the Armory said he hadn't been active in a while. I'll also change the layout to fit "Wind Serpent" in the pet name cell.


More feedback about layout and ease-of-use is appreciated.

Cheeky of Havoc

 

ontwou

I have the whole T1 set sitting in the bank. Granted I will never use the stuff again but I can't bring myself to destroy them.

 

Kaber

Hey Cheeky, I do not know if there was ever any consensus on what was going on with the bug messages I kept getting, but I finally found a way to get the error messages to show up in a useful and informative way. Apparently you programmed this in Excel 2004 (according to the message I got), and the way it handles macros for some of your features is vastly different than Excel 2003 for some reason. So the Shot Rotation, DST, and another page or two become completely disabled. I was able to enter rotations by hand, but I do not know if it actually changed any of the calculations within the spread sheet. I do not believe there is anything you will ever be able to do to make your spread sheet work in 2003, short of reprogramming it entirely which would probably force you to lose features that '03 does not support. As such I wonder if it would be beneficial to add a note that the sheet does not work for that version of Excel just to squash any further issues.

I should note that the time where I began running into problems with the spread sheet was about the time where the Dragon Spine Trophy feature was fully enabled and fleshed out (not the first push, but one of the following).

 

Cheeky

Hmmm. MY home version of Excel (where I've done 90+% of the development) is Microsoft Excel 2002 (10.6834.6830) SP3. Everything works in that version. When I first converted from Open Office to Excel a year ago I used my work version which might have been 2004, I'm not entirely sure.

Anyone with more experience with Excel (or better yet, a Microsoft Developer) able to shed additional light on this?

Cheeky of Havoc

 

Fuulish

Cheeky, a few quick bugs that are still in v40.

Season 1 [Gladiator's Chain Helm] socket bonus of +4 resilience doesn't seem to be registering on v40 (dl'ed 1/23 @ 11am EST)

Cell H18 on Settings/Results is not referencing the correct cell. Listed as Profiles!I374 but should Profiles!J374

 

Opostrophe

It seems like the Target Defense value of the Hit Chance calculations is using the Custom Target Level setting even if the selected target is not 'Custom'.

Noticed that my hit chance was much too high considering my hit rating, and digging a bit showed the error. Wouldn't have noticed if the new default wasn't 70 instead of 73.

 

Danrith

First of all, wonderful work Cheeky, as always. Your spreadsheet is an invaluable tool to hunters everywhere.

Two things I noticed in the most recent spreadsheet, both minor.

Under shoulders, the leather Sun-Gilded Shouldercaps are there with correct stats, but there is a typo in the name. You have them as "Sun-Gilded ShouDLercaps" so when loading gear from the armory they are not recognized. Not a big deal to manually select, but thought I'd mention it since it's a very simple fix.

Also, as a poster noted above, Demon Stalker Shoulderguards seem to have disappeared from the list.

Thanks again for all the work you do on this great tool!

 

Groznar

Nevermind. > <

 

Cuul

Hi,

This spreadsheet has helped me tons in developing my hunter, thanks!

One question, can someone verify the values for wrathtide longbow in the spreadsheet? I have both the steelhawk crossbow and wrathtide and in game the wrathtide gives me more dps but in the spreadsheet the numbers show lower.

Perhaps I am reading it incorrectly?

 

Fendryl

Would it be worthwhile to include a "Total DPS done" which is Time to OOM * Total DPS? (Ideally on the gear page since that's where I'm typically looking at the total dps when swapping around gear)

For example when looking at a gear set with a Barrel-bladed, I'll get 1375.96 * 69.74s = 95959.45 vs the same set with a Black Bow of the Betrayer, where I'll get get 1347.92 * 87.59 = 118064.31. So despite a 28dps loss by using the Black Bow, the overall damage done (in a full oom cycle) is still significantly higher. Course this may bring the whole potions/gcd/rotations issues into play and greatly complicate matters.

btw, the note about the reasoning to change the default level to 70 made me lol, quite literally =)

 

Cheeky

Please repeat after me : Character sheet DPS is meaningless. Character sheet DPS is meaningless. Character sheet DPS is meaningless. Character sheet DPS is meaningless.

There, don't you feel better now?

This is the second request recently I've gotten for this, so I can add it easily enough.

Dude, you have no idea.... (Although I've gotten at least 5 messages already about hit% changes. So I just can't win.)

Cheeky of Havoc

 

◊ Sarutobi

Confirmed. The T4 shoulders are not in the list.

 

Chewbak

Just a note, I noticed the set bonus cell on the Gear tab for hit rating is blank, L88 has no reference value.

 

KlaDie

I got a failure, while clicking on "calculate attributes" after filling in all I have to fill in :-/
I can only show you the german Failure, its called: "Laufzeitfehler 13 Typen unzugänglich"
When I click on debugging afterwards, the following line is in "Yellow colour":
Cells(7, 62) = (Cells(2, 3).Value - base) / 10

Well, but this line looks exactly like the other lines, and I filled them out just like the other lines.

Thanks anyway for your Spreadsheet, maybe you have an Idea for this problem?

 

Koroshiya

Hey Cheeky, I don't know the inner workings of your spreadsheet so don't take this the wrong way.. But how hard would it be to add a page that would have a button for running the calculations of multiple different shot rotations for side-by-side comparison with the currently selected gear? Even if all it did was the built-in ones. The hardest thing for me at the moment is switching weapons and clicking through all the pages to set up shot rotations; I always seem to forget.

On a side note: Now that you set the target's level to 70 you might not get 5 questions a week asking why it's off from the character sheet, but you can bet you'll get 10 asking why the spreadsheet says they are hit capped when they "aren't," Since people are so used to seeing hit cap at 142. I almost posted a bug, but before I did I checked your first release notes and saw the note.

 

tarsen

Hey Cheeky, thanks for the great tool you've provided us with, it's great to decide what to loot and how to spec

I've just a couple of questions for you:
1) Will you ever implement switches for Unleashed Rage (enhance shaman buff) and other buffs like Imp. Judgement of Crusader, Blood Frenzy and Ferocius Inspiration from other hunters? I'd especially like to see Unleashed rage to gauge how it buffs BM pets' dps.
2) I see that Curse of shadows gives only 5% additional damage to arcane shot, is that correct? Does having it improved to 13% change anything?

 

Opostrophe

The problem is not really that the default is now 70. As I posted above, the problem is that the 'Custom Target Level' value is always used in the hit% calculations, even if you have selected a non-custom target, for example Morogrim Tidewalker. This is a bug, right? I guess it should ignore all Custom Target values when you have selected a specific boss.

Could any other calculations be using the custom target data rather than the selected target data as well?

 

Cheeky

Resilience works that way too, I believe.

Cheeky of Havoc

 

Tadrann

"Embrace of the Twisting Nether" is showing the wrong stats in the spreadsheet. (Thottbot World of Warcraft: Embrace of the Twisting Nether) Apparently this has been changed somewhat recently to have increased AP, the spreadsheet shows 58 AP, but it is actually now 84 AP.

(Glad they changed that, always annoyed me that an "upgrade" requiring 2 nether vortex to craft was actually a downgrade)

 

Flyx

Could you make a list of items with procs that are not currently modeled in the spreadsheet. I find it hard to believe that Madness of the Betrayer is worse than Tsunami Talisman if the proc has been included.

 

Greenpiggy

It is included, you can check simply by adding the hand adjust values and comparing.
Don't think Band of the Eternal Champion is added yet though

 

Thorongil

From version 0.4 changelog:

"Used Vaxum's model for the [Band of the Eternal Champion] proc effect."

http://sig.gamerdna.com/quizzes/INFL...erks/Idril.png