• topojijo

Are there any known issues with your current spreadsheet Cheeky? I ask because I filled in the sheet with my exact current talents, and items and a few of the calculations are off.

It lists my crit as being slightly lower than what it stats in game, same with armor, and health.

 

Hunterlin

Have you changed your race to Tauren? With target level set to 70 crit/hit should be about same. You may try to compare spreadsheet numbers for items to your armory numbers.

 

Bouboulou

Congratulations for the great work !

I have some questions, hope they are not too dumb :

1) I have troubles choosing my gems using OpenOffice. Is it normal?

2) I originally downloaded this to compare the khorium scope and the eternium stabilised scope. I was nearly certain the khorium scope was better. However your steady shot formula does not seem to take a +damage scope into account. Is it also true in the game ?

 

Cheeky

Yes, Open Office doesn't support indirect list validation.

Testing has shown that +damage scopes do not effect Steady Shot.

Cheeky of Havoc

 

Corinthian

IIRC, Steady Shot is affected by AP and Crit, and weapon damage has no bearing on it. Therefore, the scope doesn't affect SS damage.

 

Bouboulou

Actually, weapon damage does affect SS damage (the tooltip formula in the game is wrong).

 

Cheeky

He's correct, weapon damage is normalized to 2.8s speed and added to RAP*0.2 (this is 2.8s normalization too) and 150.

The tooltip always has been incorrect.

Cheeky of Havoc

 

Kaber

edit: nm, the DPS spreadsheet does account for glancing blows on pets.

But I see you still have them set to a 40% chance. Blizzard reduced them to 25%, which is the reason rogues have been reclaiming their place at the top of the DPS meters.

 

vith

Cheeky, I have a few requests for the next version of your spreadsheet. Most important, the socket bonus on [Belt of Deep Shadow] is not set. And some nitpicky things: Outlands versions of the [Ancient Sinew Wrapped Lamina]: [Clefthoof Hide Quiver] and [Worg Hide Quiver]. Alliance version of [Talbuk Hide Spaulders]: [Blackened Leather Spaulders]. Thanks!

edit: Oh, and one more thing. The Upgrade Search on the rogue dps spreadsheet makes me envious! I won't hold my breath, but consider my wish recorded. Great work on the DST modeling!

 

Cheeky

If you know the equations to use with them (so that I can generate numbers for more than just level 73 targets) I would greatly appreciate it.

Cheeky of Havoc

 

• Glaurong

25% glancing blow chance, 25% reduced damage last I read anything about it.

Edit: Went at looked at the rogue dps spreadsheet.

Glancing blow chance is set to 25% and glancing blow factor is set to 0.76. So it looks like 25% chance to glance with a 24% damage reduction.

Log Parser for BM Hunters (Right click, save as) - Updated 10/11/2007

 

Cheeky

Posted Version 27. I rushed this to fix the Master Marksman bug, since it was making a significant difference in MM build DPS estimations. Other requested changes will be added shortly.

Change Log:
- Fixed a Bug in calculating effects of Master Marksman for on-proc +AP.
- Corrected some item stats (Shoulderpads of the Stranger)
- Added mana regen to Black Grasp of the Destroyer

Cheeky of Havoc

 

Uthilas

I just recently recieved the Dragonspine Trophy. I plugged it into the spreadsheet and saw a DPS increase of about 160+. The numbers have got to be wrong here. I mean an 160 DPS increase is insane from one trinket. Maybe im just an idiot but i was curious if this is actually true and the calculatiosn are correct?

 

Zedd

assuming your reaction time can keep up going from 2.2 to 1.6speed(in my case, as bm) allows me to shoot alot more arrows, thus generating dps.
the only problem is that it might proc with quick shots, and if you notice to late you lose some dps. but if you adjust it is a monster

 

tict

As BM I also just picked up a DST. From the last two weeks Gruul attempts (per WWS) I have gone up 120ish+ DPS. So I would say the spreadsheet is right on. Keep in mind slower weapons (for BM) are now an advantage when you have IAOTH and a DST.

 

Fuulish

Cheeky, could you add [Mantle of Perenolde] as well?

 

Tilethryn

Quick question Cheeky: Does your spreadsheet take into account gem requirements for meta gems? I won Maulgar's Warhelm the other night, and was curious how T4 would compare if socketed. I threw in a Relentless Earthstorm Diamons (12agi 3%crit dmg bonus) and immediately saw a healthy 25 dps gain ^.^ At the time, however, I didn't have the second of the two blue gems (2yellow, 2red, 2blue) so I assume that it does not?

By the by, is this massive increase due solely to the 3%crit dmg bonus? It does seem to be the only physical dps raiding meta gem atm, so I assume this is why its so much greater than the 12crit/x and 24ap/x gems.

 

Cheeky

I do not yet count metagem requirements. It's something I am looking into.

Cheeky of Havoc

 

Kaber

I sort of took a short hiatus from posting, but I believe the numbers posted from the rogue spread sheets are going to be the most accurate. I was under the impression that a glancing blow cause a 50% damage reduction, but the rogues are going to be our best source here so I would go with whatever numbers they have on it.

edit: also, I do believe that glancing blows only apply to level 73 elites. I could be mistaken, but the rogue that told me about them said they only apply to elite raid bosses. The goal was to reduce the insane DPS rogues/warriors were putting out in a raid setting (because of how well they scale with group compositions and buffing), while their DPS in a 5man or solo setting was fine. I will pick our rogue class leader's brain later for more information.

 

senior toasted bread

A request for Cheeky, would it be possible to add in searching the drop down menus? What I mean by this is open the drop Down menu for lets say a gem slot, and hit D on my keyboard, the highlight in the drop down list would jump to the beginning of the D section, it would make selecting gems/gear much faster. If I totally suck at describing this here is an example http://elitistjerks.com/register.php?do=register selecting a class drop down menu.

 

sasukekun

Cheeky, [Boneweave Girdle] is set to 26 stam on the spreadsheet. It's supposed to be 26 int, 0 stam

www.ropetown.com

 

Cheeky

Any idea on how to enable that for Excel? I couldn't find anything in the Help utility.

Cheeky of Havoc

 

• Leica

This may be helpful:

Excel misc Navigate to an item in pulldown by typing first couple of letters

I must say, I've found myself trying to type the first letter of items/gems a great many times. If this isn't too much work to implement, it would be a great feature.

 

Jezele

Just a quick "feature" request, although it might require a bit of recoding.

One of the things I've always strived for in my own spreadsheets is to allow multiple gear comparisons at a glance. While it's near impossible to show all the various combinations, it'd be nice to look at the list of 10-20 helms, for example, and say "taking this one will increase my DPS by X, this one by Y, and this one is inferior to what I have now." Even simple comparisons between two items is fairly clunky with your system if there's a need to reset gems for each of the two.

Any chance you could add in a direct item comparison, either for a class of armor, or just a side by side comparison of 2 items?

 

Cheeky

Because shot rotations figure so prominitely in the calculations it would require me replicating the work for each place I wanted a new DPS value for. There are a lot of calculations involved. This is the same reasoning why I don't provide a +1 <insert stat here> number. It makes maintenance a real pain.

If you use Excel, you can "Save" a gear set for quick comparisons. It's not really elegant, but it's much easier for me to manage.

Cheeky of Havoc