 |
| Welcome to Elitist Jerks |
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!
If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.
|
12/10/07, 4:20 PM
|
#1176
|
|
Free Arrows For Life
Tauren Death Knight
Mal'Ganis
|
Originally Posted by Talrunya
Okay, i know this the debate between the Wolfslayer and Sunfury has been going on for a while now, and i honestly don't tant to add to it, i just want some feedback.
Checking the armory i've seen where the Wolfslayer i rated 9th overall and the sunfury is rated 5th overall (over TK, Hyjal and BT ranged weapons), the Vengeful gladiator weapons being next and Lady Vaj's bow at the top. Now i've been working the spreadsheet's shot rotations, etc.. and found that Wolfslayer still gives me a better overal dps even tho i'm Surv/MM so my question is simply this.. should i bother to try and get Sunfury or the bow from ZA? My guild is past Kara now, doing ZA and gruuls/SSC so if i want Sunfury i'm gonna have to get it on my own time. Is it worth the effort or just try and get to Vaj and squeeze her till her bow drops?
|
Statistically your chances of getting Sunfury are far greater than Vashj bow. The gun from TK or ZA are not bad either. It's up to you to decide what/where you want to farm. As for the Armory ratings, I can assure you that the Illidan bow (among others) is better DPS for MM/Surv so take the armory with a grain of salt. Last but certainly not least, as a Surv/MM hunter you should not be seeing higher DPS from Wolfslayer over Sunfury. You may need to reconsider your shot rotations.
|
|
|
|
|
|
12/10/07, 5:44 PM
|
#1177
|
|
Glass Joe
Night Elf Hunter
Cenarius
|
Thanks for the feedback Kamaa... i reworked the shot rotations and realized the error in my thinking. Looking through the season 2 gear i realized the Merciless crossbow gives me a significant boost over Sunfury and Wolfslayer, so i guess i'll work on that for the time being until something better drops. Thanks again.
Cheeky, with so much time being put into your spreadsheet, when do you find time to play... lol
Edit
Was playing around again and found that my Wrathtide (which has been parked in my bank for months) does more effective dps than the Wolfslayer. Made sure to rework the shot rotations and all... what gives?
Last edited by Talrunya : 12/10/07 at 7:51 PM.
|
|
|
|
|
12/10/07, 8:06 PM
|
#1178
|
|
Glass Joe
|
Version 39:
Every time I switch Gear profiles the pet tab resets to the default Ravager. It doesn't save even if I save the spreadsheet or the gear profile.
|
|
|
|
|
|
12/11/07, 3:31 AM
|
#1179
|
|
Piston Honda
Human Priest
Alexstrasza (EU)
|
Originally Posted by Talrunya
Okay, i know this the debate between the Wolfslayer and Sunfury has been going on for a while now, and i honestly don't tant to add to it, i just want some feedback.
Checking the armory i've seen where the Wolfslayer i rated 9th overall and the sunfury is rated 5th overall (over TK, Hyjal and BT ranged weapons), the Vengeful gladiator weapons being next and Lady Vaj's bow at the top. Now i've been working the spreadsheet's shot rotations, etc.. and found that Wolfslayer still gives me a better overal dps even tho i'm Surv/MM so my question is simply this.. should i bother to try and get Sunfury or the bow from ZA? My guild is past Kara now, doing ZA and gruuls/SSC so if i want Sunfury i'm gonna have to get it on my own time. Is it worth the effort or just try and get to Vaj and squeeze her till her bow drops?
|
You could wait for Vashj´s bow, but keep in mind that it might be quite a long time until you get there if you´re only starting SSC these days.
|
|
|
|
|
12/11/07, 8:20 AM
|
#1180
|
|
Glass Joe
|
The Vashj bow is pretty darned rare though.
I wouldn't count on having your guild killing Vashj much more than it takes to get everyone their vial. As soon as you start killing her you're not far off farming easymode Supremus for the Legionkiller, or even having a go at Archimonde.
|
|
|
|
|
|
12/11/07, 11:53 AM
|
#1181
|
|
Glass Joe
|
How does the spreadsheet calculate the "Attribute + 1" figures? They seem to point to cells that just contain numbers, not formula. And they don't appear to be accurate. I've created custom pieces of gear that have the exact same stats as my current gear, but + 1 point of this or that, to test the "Attribute + 1" numbers. + 1 agi gives me 0.43 dps, 1 RAP gives me 0.22 dps, and 1 crit gives me 0.38 dps. The listed "Attribute + 1" values are 0.523, 0.267, and 0.462 dps for agi, crit rating, and RAP respectively.
|
|
|
|
|
|
12/11/07, 12:09 PM
|
#1182
|
|
Bastard
Cheeky
Troll Hunter
No WoW Account
|
Originally Posted by Yoj
How does the spreadsheet calculate the "Attribute + 1" figures? They seem to point to cells that just contain numbers, not formula. And they don't appear to be accurate. I've created custom pieces of gear that have the exact same stats as my current gear, but + 1 point of this or that, to test the "Attribute + 1" numbers. + 1 agi gives me 0.43 dps, 1 RAP gives me 0.22 dps, and 1 crit gives me 0.38 dps. The listed "Attribute + 1" values are 0.523, 0.267, and 0.462 dps for agi, crit rating, and RAP respectively.
|
Any time a gear item is swapped (besides Armory loading) it will run through adding one more of each attribute temporarily, and save the delta. I'll test and see if it is still working accurately, I haven't used it in a while.
You can also hit the RecalcAttributes button on the 'Gear' tab to force a new set of computations.
|
|
|
|
|
12/11/07, 1:06 PM
|
#1183
|
|
Free Arrows For Life
Tauren Death Knight
Mal'Ganis
|
I've got a suggestion that may or may not be worth the effort. Similar to multi/arcane priority functions that allow us to switch all the shot rotations in one go, I was thinking of similar buttons for equipment. It would be nice for the purposes of experimenting to be able to choose a setting that automatically put on all the gear with the highest haste, armor penetration, ap, crit, agi and such. There could be a button that changed all gear and maybe an option for each of the individual slots too in the pull down menu.
ie. I choose "Haste", and it auto equips the best haste item for each gear slot available in the game. Then I realize I'm way low on hit rating, so for the remaining slots with no haste availale I choose from that item slots pull down menu "Hit" so that it equips for that slot the item with the most hit rating.
With an option like this you might want the ability to lock individual items too, that way they don't change while you're experimenting.
ie. While you want to experiment with haste or armor penetration gear, you know that you'll want to use your Illidan bow no matter what.
I know this is just a lazy addition and can be done manually with a hint of time invested, but let's face it, that's what the whole spreadsheet is for.
|
|
|
|
|
|
12/11/07, 1:42 PM
|
#1184
|
|
Bastard
Cheeky
Troll Hunter
No WoW Account
|

Originally Posted by Kamaa
I've got a suggestion that may or may not be worth the effort. Similar to multi/arcane priority functions that allow us to switch all the shot rotations in one go, I was thinking of similar buttons for equipment. It would be nice for the purposes of experimenting to be able to choose a setting that automatically put on all the gear with the highest haste, armor penetration, ap, crit, agi and such. There could be a button that changed all gear and maybe an option for each of the individual slots too in the pull down menu.
ie. I choose "Haste", and it auto equips the best haste item for each gear slot available in the game. Then I realize I'm way low on hit rating, so for the remaining slots with no haste availale I choose from that item slots pull down menu "Hit" so that it equips for that slot the item with the most hit rating.
With an option like this you might want the ability to lock individual items too, that way they don't change while you're experimenting.
ie. While you want to experiment with haste or armor penetration gear, you know that you'll want to use your Illidan bow no matter what.
I know this is just a lazy addition and can be done manually with a hint of time invested, but let's face it, that's what the whole spreadsheet is for.
|
Yeah, nice idea, but I don't think I'm going to spend the hours it will take to put something like this into place.
|
|
|
|
|
12/12/07, 10:26 PM
|
#1185
|
|
Glass Joe
Night Elf Hunter
Barthilas
|
Cheeky, the Lightning Breath code needs some work when youve got some time to waste on a niche pet talent.
Using the following Kael night WWS as a resource -
Wow Web Stats
The chance to miss is not allowing for AH (which I believe affects LB in much the same way Ferocity affects it, which is to say, pet chance to hit and crit talents are not spell or physical exclusive); spreadsheet says 17% chance to miss, pet is missing consistently closer through the boss attempts (apart from attempt 12, where 20% misrate was observed) to 13%;
Additionally, spreadsheet says average damage should be 133.25 with my 2344 rap. Full log average was 206, Kael attempt averages were consistently all over 200. The 4% hit and TBW use is not enough to cover this 133 vs 200+ differential, leading me to believe that the RAP -> LB damage factor is inaccurate.
Further supporting this theory was simple grinding on the eleganku plateau last night, where combat log normal LB hits (no TBW) were landing consistently between 160 and 190. This was without raid buffs and using AOTV - resulting in a RAP of just 1750, and an expected (non crit, no resist) hit of -
93.59 (average dmg generated by the sheet, pre mods at 1784 rap - I cant pin down why my ingame rap and gear-sheet-rap are different atm) times
1.2 (UF)
1.25 (mood)
1.07 (family)
1.03 (FI)
or an average non crit of 154, nearly 20 dmg average less than actually observed (recount average normal hit 172).
edit - another WWS which supports the AH = spellhit theory, and again shows average LBs consistently over 200 - Wow Web Stats
Last edited by Jaimaster : 12/12/07 at 10:33 PM.
|
|
|
|
|
|
12/13/07, 12:28 PM
|
#1186
|
|
Glass Joe
Troll Hunter
Dentarg (EU)
|

Originally Posted by Jaimaster
Cheeky, the Lightning Breath code needs some work when youve got some time to waste on a niche pet talent.
Using the following Kael night WWS as a resource -
Wow Web Stats
The chance to miss is not allowing for AH (which I believe affects LB in much the same way Ferocity affects it, which is to say, pet chance to hit and crit talents are not spell or physical exclusive); spreadsheet says 17% chance to miss, pet is missing consistently closer through the boss attempts (apart from attempt 12, where 20% misrate was observed) to 13%;
Additionally, spreadsheet says average damage should be 133.25 with my 2344 rap. Full log average was 206, Kael attempt averages were consistently all over 200. The 4% hit and TBW use is not enough to cover this 133 vs 200+ differential, leading me to believe that the RAP -> LB damage factor is inaccurate.
Further supporting this theory was simple grinding on the eleganku plateau last night, where combat log normal LB hits (no TBW) were landing consistently between 160 and 190. This was without raid buffs and using AOTV - resulting in a RAP of just 1750, and an expected (non crit, no resist) hit of -
93.59 (average dmg generated by the sheet, pre mods at 1784 rap - I cant pin down why my ingame rap and gear-sheet-rap are different atm) times
1.2 (UF)
1.25 (mood)
1.07 (family)
1.03 (FI)
or an average non crit of 154, nearly 20 dmg average less than actually observed (recount average normal hit 172).
edit - another WWS which supports the AH = spellhit theory, and again shows average LBs consistently over 200 - Wow Web Stats
|
dont forget that kael'thas has 25% magical dmg taken increase from [Infinity Blade], so i dont think kaelthas is the right encounter to make theories about LB and you only linked WWS's with 15 and 9 hits of the breath...
|
|
|
|
|
|
12/13/07, 8:32 PM
|
#1187
|
|
Glass Joe
Night Elf Hunter
Barthilas
|
* There is access to many other attempts through those WWS's and they consistently support the data (click the "split" link and select other attempts);
* Your overestimating our prowess in assuming we are progressing far enough to get the infinity blade debuff onto mobs for substantial periods of time... Maybe next week
Jaimaster - WWS
SSC / TE as survival spec, still with the serpent, with an average blow of 156, times miss rate (@ 17% miss) 129.5. Spreadsheet expected damage, with better gear plugged in than I had back on the 2nd (im pretty sure thats the run I picked up my T5 helm), gives an expected average of 102.5. AFAIK there is no special magic or nature vulnerability to be had across Leo, Vash (x2), Alar and VR, yet the actual damage being markedly higher than spreadsheet-crafted damage is consistent across all fights.
Last edited by Jaimaster : 12/13/07 at 8:37 PM.
|
|
|
|
|
|
12/13/07, 10:15 PM
|
#1188
|
|
chiefly comprised of water
|
Wind Serpents' LB in raids will do more damage than the spreadsheet says for a few definite reasons:
* Misery - +5% magic damage debuff. If you have a spriest, this is up 100% of the time.
* Improved Divine Spirit - Most disc priests who take Divine Spirit also take Improved. Wind serpents don't have a ton of base spirit, but it does increase their +dam a bit.
* Totem of Wrath / Wrath of Air totem - +3% spell crit and +101 dam, respectively. If you're in a elemental or some resto shaman group you likely have at least Wrath of Air.
* Stormstrike - increases next direct nature damage spell by 20%. If you have an enh shaman, two stacks of this are up every 10 seconds.
I listed a bunch of debuffs and buffs that aren't currently modeled in this post, which is linked from Lactose's "to do" post at the beginning of the thread.
|
|
|
|
|
|
12/14/07, 9:45 PM
|
#1189
|
|
Von Kaiser
|
Spreadsheets Error
Tried using Open Office w/ Open Office versions 38 & 39. I get "Read Error: password protected". I'll try upgrading to a newer version of Open Office . org in the meanwhile.
|
|
|
|
|
|
12/16/07, 10:35 AM
|
#1190
|
|
Glass Joe
|
FYI, there's an Eicked Flame Spessarite in the gem list.
|
|
|
|
|
|
12/16/07, 8:46 PM
|
#1191
|
|
Banned
|
1. i don't mind getting rid of level 60 items but is there a reason to? does it take up space?
2. i use the import feature, mainly cause if it works it's faster and more accurate
|
|
|
|
|
|
12/17/07, 3:36 AM
|
#1192
|
|
Glass Joe
Orc Hunter
Thorium Brotherhood
|
I'm not sure if this has been addressed, but I'm still getting this problem when I try to plug in different ranged weapons on the spreadsheet. According the little "Hunter DPS/Total DPS" window on the gear page of the spreadsheet, Wolfslayer Sniper Rifle outdoes everything by a lot. For example, with Wolfslayer Sniper Rifle plugged in, I get 820.31 in Hunter DPS. If I plug in anything else, it goes way down. I plug in Vengeful Gladiator's Rifle and it goes down to 802.61, or 801.39 with Arcanite Steam Pistol. Of course, I have the correct ammunition and ammo bags set. Is this just an error on the stats for the sniper rifle? Are all of the other weapon's calculations accurate?
|
|
|
|
|
|
12/17/07, 5:18 AM
|
#1193
|
|
King Hippo
Night Elf Hunter
Moonglade (EU)
|
Originally Posted by Bismarck
I'm not sure if this has been addressed, but I'm still getting this problem when I try to plug in different ranged weapons on the spreadsheet. According the little "Hunter DPS/Total DPS" window on the gear page of the spreadsheet, Wolfslayer Sniper Rifle outdoes everything by a lot. For example, with Wolfslayer Sniper Rifle plugged in, I get 820.31 in Hunter DPS. If I plug in anything else, it goes way down. I plug in Vengeful Gladiator's Rifle and it goes down to 802.61, or 801.39 with Arcanite Steam Pistol. Of course, I have the correct ammunition and ammo bags set. Is this just an error on the stats for the sniper rifle? Are all of the other weapon's calculations accurate?
|
I'm guessing you're a beast master, and you used a 1:1 rotation. The results are then rather normal; Wolfslayer is just that good because it's a 2.7 speed. So, the wasted time between a steady and the subsequent autoshot is at a minimum.
Get a good few haste items and plug the data in; Wolfslayer should now clip your autoshots, and Arcanite or Vengeful gladiator should outdps it constantly.
EDIT: Wolfslayer is indeed 2.7 speed. Side effect of typing late at night. I'm editing my post accordingly. However, compared to 2.9 or 3.0 weapons, everything I stated still remains valid.
Last edited by Enova : 12/17/07 at 12:00 PM.
|
Originally Posted by XI-
In summary, TBC raiding is easy. 9/10 encounters can be summarized with 1 phrase. Stay out of the fucking fire. If this is too difficult BWL was still there last I checked, so go have at it for some practice.
|
Originally Posted by Kaubel
You people are idiots
|
Guilty as charged ^
|
|
|
|
12/17/07, 6:31 AM
|
#1194
|
|
Von Kaiser
Dwarf Hunter
Draenor (EU)
|
Wolfslayer is 2.7 speed, so I think haste makes it even better for BM(unlike Barrel-Blade Longrifle).
May be Vengeful gladiator can outdps it if you add arcane shots for 1:1.3 rotation and to compensate for lower speed, but until I can prove it in spreadsheet, Wolfslayer is top DPS weapon for BM.
Edit: Did tested Vengeful Gladiator weapons, they are downgrade for BM for any rotations.
Wolfslayer is still DPS king.
Last edited by Hunterlin : 12/17/07 at 6:41 AM.
|
|
|
|
|
|
12/17/07, 2:42 PM
|
#1195
|
|
Piston Honda
Night Elf Hunter
Laughing Skull
|
Originally Posted by Bikiniwax
Cheeky,
Noticed an error on the ver 39 (38 too) of the spreadsheet when importing.
On the Gear tab,
Cell A22 shows Red Socket 1, however my Meta gem (Relentless Earthstorm Diamond) loads next to it in B22
Cell A23 shows Meta Socket 2, however my Delicate Living Ruby (+8 AGI) loads next to it in B23
|
Originally Posted by Cheeky
What helm are you using?
|
The new S3 helm but It looks like from your version updates that it might now be fixed. 
|
|
|
|
|
|
12/17/07, 4:43 PM
|
#1196
|
|
Glass Joe
|
I just downloaded this spreadsheet and i noticed something that i believe to be a bug. First off, I'm a Draenei Hunter. When you select Dwarf, it shows the crit you gain from the racial on the Race row of the Gear tab. When you select Draenei, it doesn't show the + 1% hit gained from herioc presence, so i'm curious to know if you've added this extra hit in elsewhere, or if it was left out. If it was left out, can you please add it in for future builds?
Herioc Presence: "Increased chance to hit by 1% for you and all party members within 30 yards."
Thanks,
Toushiro
|
|
|
|
|
|
12/17/07, 6:26 PM
|
#1197
|
|
Huntard Extraordinaire
|
Didn't see this when I looked through the search of the thread. But would it be possible at all to choose when you would use Rapid Fire in relation to other spells? Lets say that you chose to use it after a DST buff finished to guarantee that the two wouldn't be up at the same time ending up in lost DPS.
|
|
|
|
|
12/17/07, 6:37 PM
|
#1198
|
|
Bastard
Cheeky
Troll Hunter
No WoW Account
|
Originally Posted by Grogzor
Didn't see this when I looked through the search of the thread. But would it be possible at all to choose when you would use Rapid Fire in relation to other spells? Lets say that you chose to use it after a DST buff finished to guarantee that the two wouldn't be up at the same time ending up in lost DPS.
|
You can do stuff like that, but it's not easy. You can choose Rapid Fire in any of the shot rotations. Use it in the regular one to model how it effects your un-hasted DPS.
|
|
|
|
|
12/18/07, 9:49 PM
|
#1199
|
|
chiefly comprised of water
|
So.. here's a question for heavy users of the spreadsheet, and perhaps Cheeky himself.
How closely does your spreadsheet predicted DPS correspond to your real-world (WWS) DPS?
I've been using the spreadsheet forever and mostly considering it a 'relative' measure -- X item is better than Y item, Z rotation is better than A rotation, etc. It works great for that and I've checked over the math enough myself that I believe it when it tells me what's better.
However, very consistently, the actual dps numbers have always been significantly above anything I've actually achieved. Obviously part of this is fights with movement, or adds and target switching, or any of the other various things that make boss fights more interesting than the situation modeled by the sheet. However, the latest series of updates have added a lot of things aimed at making the simulation more accurate (target armor, extra debuffs, etc), and the discrepancy still stands.
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? In my current gear and with minimum raid buffs, the sheet pegs me at 1600 DPS against a 7700 armor boss. While in a few groups with awesome synergy I have topped 1400 or 1500 DPS, my typical dps is much more commonly around 1000-1200. I'm well aware of the deficiencies of my cursed human hands and their faulty adherence to the ideal rotation and timing -- but is that enough to explain a 30% gap between expected and observed?
So: a lot of excess verbiage aside, how closely does the spreadsheet model your actual DPS?
|
|
|
|
|
|
12/19/07, 2:29 AM
|
#1200
|
|
UI Whore
Blood Elf Hunter
Mal'Ganis
|
Originally Posted by Tsook
How closely does your spreadsheet predicted DPS correspond to your real-world (WWS) DPS?
|
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.
|
|
|
|
|
|