Kamaa

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.

 

Talrunya

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?

http://sigs.guildlaunch.net/wsig.php/1938497mSwpZ.png

 

Amiyuy

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.

 

Thorongil

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.

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

 

Farbar

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.

 

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.

 

Cheeky

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.

Cheeky of Havoc

 

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.

 

Cheeky

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.

Cheeky of Havoc

 

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

 

-rusty-

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...

 

Jaimaster

* 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.

 

• Tsook

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.

 

Daemous

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.

 

infamy

FYI, there's an Eicked Flame Spessarite in the gem list.

 

turbo012

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

 

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?

 

Enova

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.

Guilty as charged ^

 

Hunterlin

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.

 

Bikiniwax

The new S3 helm but It looks like from your version updates that it might now be fixed.

 

Toushiro_Uldum

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

 

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.

But when it comes time for me to remove your wings, and you, you must try to fly...

Click Here to see what makes me tic(k).

What Are You Going to Roll for Warhammer Online?

 

Cheeky

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.

Cheeky of Havoc

 

• Tsook

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?

 

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.

My blog, about wow and the like.