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.
Just came here today looking for a spreadsheet to compare the relative value of Agility enchants vs savagery in PVP. I suspect that resilience will impact the value of the agility enchant.
I see you added target resilience to your spreadsheet but I can't find a way to select a target that has resilience as none in the drop down have resilience.
Am I missing something? (oh and on the change log you have it dated 2009 not 2008)
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.
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.
Just came here today looking for a spreadsheet to compare the relative value of Agility enchants vs savagery in PVP. I suspect that resilience will impact the value of the agility enchant.
I see you added target resilience to your spreadsheet but I can't find a way to select a target that has resilience as none in the drop down have resilience.
Am I missing something? (oh and on the change log you have it dated 2009 not 2008)
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.
Originally Posted by 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.
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.
Yeah.. uh.. you'd have to be crazy to have all that stuff in your bank just because the equip bonuses are unique. What kind of loser hunter would do that? >.>
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.
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).
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).
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?
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.
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!
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.
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 =)
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?
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?
Originally Posted by 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.
This is the second request recently I've gotten for this, so I can add it easily enough.
Originally Posted by Fendryl
btw, the note about the reasoning to change the default level to 70 made me lol, quite literally =)
Dude, you have no idea.... (Although I've gotten at least 5 messages already about hit% changes. So I just can't win.)
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.
Confirmed. The T4 shoulders are not in the list.
Originally Posted by DeeNogger
Every time I bite into an oatmeal raisin cookie mistaken for a chocolate-chip an angle loses its wings. Fucking trani's of the cookie world!
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?
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.
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?
Dude, you have no idea.... (Although I've gotten at least 5 messages already about hit% changes. So I just can't win.)
Originally Posted by Koroshiya
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.
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?
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?
"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)
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.
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.
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
01/22/08, 4:13 PM
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.
Similar Threads
