WotLK DPS spreadsheet - Page 120

• VRoscioli · 07/04/09, 4:01 AM

[BUG] On the Melee tab, there is an off-by-one error in the enchantment calculation section (A159:G162 in v90). The delta Agi is appearing (and being calculated as) the delta Int column. The delta AP is appearing (and being calculated as) the delta AP column, and so on.

[BUG] Also, on the Pet tab, in the focus starvation calculations in column S, I think that the second conditional should be "if(R##>0,..." instead of "if(Q##>0,..." ...Not that I see this making a huge difference anywhere, but I'm just saying.

Rhy · 07/04/09, 5:31 AM

Originally Posted by Rivkah

My web based adaptation of Shandara's spreadsheet is now in public beta for anyone who'd like to try it out (should be especially useful to those without Excel).

It's at Zeherah's Hunter DPS Analyzer

I just gave it a go. The first problem that I noticed is that it won't load gear/talents from the EU Armory. I am pretty sure it is because the EU armory still doesn't support the pet talents. The US armory works fine.
Now, the other thing that I saw is that for my gear, there is some 600 dps difference between the Excel spreadsheet and your adaptation. I checked everything a few times, and the only thing I noticed is that the stat values are a bit lower than the spreadsheet and also each shot has lower dps. The biggest difference is for Chimera shot - 1510,42 vs 1366,06.

On the bright side, I find it really easy to work with, especially the gem sorting and shot rotation are so nice. You have done quite a good job so far. Would be quite interesting to see further development.

Anindor · 07/04/09, 6:01 AM

Originally Posted by Rhy

I just gave it a go. The first problem that I noticed is that it won't load gear/talents from the EU Armory. I am pretty sure it is because the EU armory still doesn't support the pet talents. The US armory works fine.
Now, the other thing that I saw is that for my gear, there is some 600 dps difference between the Excel spreadsheet and your adaptation. I checked everything a few times, and the only thing I noticed is that the stat values are a bit lower than the spreadsheet and also each shot has lower dps. The biggest difference is for Chimera shot - 1510,42 vs 1366,06.

On the bright side, I find it really easy to work with, especially the gem sorting and shot rotation are so nice. You have done quite a good job so far. Would be quite interesting to see further development.

another bright side, even though overall DPS at the end seems to be lower, it seems to be in proportion to the excel spreadsheet (e.g.if something raises or lowers your DPS on the spreadsheet, it will have the same affect on the web version)

P.S.

I wonder what Shandara thinks about this....

elandriel · 07/04/09, 8:21 AM

Excellent work on the web version. As a poster before me already mentioned, there are some problems when attempting to import from European Servers. Other than that I believe the whole web project merits its own thread so we can beta test it and report errors, discuss additional features etc. without cluttering this one.

Kharthus · 07/04/09, 8:26 AM

Just tried v90 and I'm getting an Run-time error when trying to read my talents from the Armory. This is using the US armory which just added Pet Talents in case that affected something.

Also, finally figured out why MPE is always ranked below Giant's Bane in the Gear Planner. At least for weapons, the gear planner isn't factoring in sockets or using the new excess hit to agi calculations. Just adding a 16agi gem to MPE pushes it above Giant's Bane even without accounting for all the +hit.

Shandara · 07/04/09, 10:28 AM

Originally Posted by Kharthus

Just tried v90 and I'm getting an Run-time error when trying to read my talents from the Armory. This is using the US armory which just added Pet Talents in case that affected something.

Also, finally figured out why MPE is always ranked below Giant's Bane in the Gear Planner. At least for weapons, the gear planner isn't factoring in sockets or using the new excess hit to agi calculations. Just adding a 16agi gem to MPE pushes it above Giant's Bane even without accounting for all the +hit.

The changes to the Armory broke the import. I haven't had time to look at it yet.

Rivkah · 07/04/09, 4:01 PM

Thanks guys, I've fixed the EU armory import, hopefully EU will get their own pet talent support soon. Hellraza, if you save your settings and send me a PM of which they are I can try to track down the problem- I did make some bug fixes last night for chimera so doublecheck if they fixed your problem.

Shandara has been a great help with this project, sending me unlocked versions of the spreadsheet and answering my dumb questions about how calculations worked. I'm trying to keep it roughly in line with the spreadsheet version although there are bound to be some differences (such as I don't think Shandara has implemented pet expertise yet, I put an estimated version of it in my 3.2 settings).

I wasn't sure if I should start another thread since this is based off of the spreadsheet, but since there were multiple requests for it I went ahead and did so.

Aciara · 07/05/09, 4:12 AM

Sorry, found the Problem myself and omg do I feel stupid right now

Shandara · 07/05/09, 7:30 AM

Originally Posted by Rivkah

It looks like this latest PTR version added in support for the pet expertise inheriting from hit. I did some tests and it seemed to be working although I'm not sure of the scaling, but for now probably an estimated 3.25 expertise per 1% hit is probably a reasonable figure to work with if you want to include it in the spreadsheet.

My tests weren't very long but they indicated it's possible that they may have also fixed the pet hit rounding down issue that currently exists- I'll try to find some time to run tests for a longer period to see if it's really changed.

Does this include +hit gained from talents as well?

EDIT:
Update

- Nitro Boosts now +24 Crit Rating
- Talent import works with US Armory again
- You can swap between active/alternate specs more easily. Also moved glyphs to talents tab and made them swap at the same time.
- Fixed enchant calculations Melee tab
- small logic fix to pet starvation
- Pet inherit expertise for the hunter's +hit at 3.25 expertise for each 1% hit the hunter has (not counting talents as yet, NEEDS testing).
- Added setting to disable use of Kill Command
- Kill Command now consumes mana

Spamurai · 07/05/09, 11:42 AM

I noticed you didn't include the updated JC only gems when you made the updates to the other profession benefits. Here's the list, in case you just happened to forget them:

dragon's eye - Wowhead Search

alienangel · 07/05/09, 2:28 PM

I notice that the spreadsheet seems to consider Readiness as having no GCD - it generates sequences like this in the shot rotation tab:

Start Cast		Shot			Time Used		Cast End	on CD until
1.58			Chimera Shot	1.58			3.16		11.66
3.16			Readiness		0.00			3.16		183.24
3.16			Silencing Shot	0.00			3.16		23.16
3.16			Chimera Shot	1.58			4.74		13.24
4.74			Aimed Shot		1.58			6.32		14.82

However as far as I can tell, Readiness causes a normal GCD and can't be cast while inside a GCD. Am I missing some macro wizardry to cast Readiness without sacrificing some other shot, is the spreadsheet compensating for this somewhere else, or are we getting extra shots in the shot rotation tab because of readiness?

Shandara · 07/05/09, 2:37 PM

I believe this is what we call a bug. Thanks. The next version should have this corrected as well as the epic JC-only gems.

Rivkah · 07/05/09, 5:39 PM

Originally Posted by Shandara

Does this include +hit gained from talents as well?

I got some strange results testing the pet expertise with focused aim:
0 hit rating (0% + 3%) 45/1000, 24/413 (4.9% dodge)
33 hit rating (1% + 3%), 74/1313, 30/658 (5.3% dodge)
177 hit rating (5.4% + 3%), 9/1000, 4/558 (.8% dodge)
197 hit rating (6.01% + 3%), 7/1000, 3/558 (.6% dodge)
230 hit rating (7.01% + 3%), 0/607, 0/340 (0% dodge)

So it looks like focused aim does apply some sort of effect to pet expertise, but it doesn't seem to be fully effective or else I wouldn't be getting dodges with the 5 and 6% hit tests. I had to abort the 7% hit test a little early, but at least one dodge should have surfaced if it was following the pattern of the other two.

Gladdy · 07/06/09, 4:33 AM

I am very surprised at the gear planners calculation of trinket dps values. With my gear in survival Mirror of Truth are a better trinket than Fury of the Five Flights. This surprises me as the basic knowledge spurting from forums has been FotFF > MoT for hunters...

The bossfight has to be longer than 42 minutes before FotFF is worth it (again tested on my gear/spec in the spreadsheet).

Anindor · 07/06/09, 4:41 AM

The spreadsheet has shown this for a long time. MoT is better because of the amount of crit available on equip in addition to a decent proc that activates on any type of damage.

Nyutu · 07/06/09, 10:59 AM

I am getting this error whenever I change a glyph or spec or gear. With 90a

If Worksheets("Settings").Range("KilLShotMode").value = "Never" Then

KraxisSingular · 07/06/09, 1:47 PM

Originally Posted by Anindor

The spreadsheet has shown this for a long time. MoT is better because of the amount of crit available on equip in addition to a decent proc that activates on any type of damage.

Indeed. FotFF was clearly better back when BM was best for the solid and continual AP boost. For BM that was/is the most powerful boost you can get. But AP boosts for Survival is of course very nice, but not the most important. MoT is a better balanced trinket really. As Survival a proc will cover the better part of two 6 second periods. That means you won't really miss anything really important on it. For BM the reverse is true. Not having MoT for BW can be a considerable comparable loss.

Btw, MoT is better than FotFF for MM too.

dangerbird · 07/06/09, 7:17 PM

Originally Posted by KraxisSingular

Indeed. FotFF was clearly better back when BM was best for the solid and continual AP boost. For BM that was/is the most powerful boost you can get. But AP boosts for Survival is of course very nice, but not the most important. MoT is a better balanced trinket really. As Survival a proc will cover the better part of two 6 second periods. That means you won't really miss anything really important on it. For BM the reverse is true. Not having MoT for BW can be a considerable comparable loss.

Btw, MoT is better than FotFF for MM too.

I was reluctant to give up my FotFF for MoT (which i probably would have vendored back in the day if it was sellable), but not only is it showing up as more dps on the spreadsheet (for all specs) but, practically speaking it has to be even better than the spreadsheet shows based on how Fury works - for a sustained single target fight (what the spreadsheet models) fury is slightly worse than MoT while you can keep Fury's stack up on the boss. Now consider Ulduar fights - freya, hodir, yogg, etc - you are constantly switching targets in all these fights and will almost never get even a 1/2 stack up - FotFF will continously be going to waste, making it much much worse than MoT, which doesn't punish you for switching targets.

I do use FoFF on FL though

• VRoscioli · 07/07/09, 9:43 AM

Originally Posted by dangerbird

I was reluctant to give up my FotFF for MoT (which i probably would have vendored back in the day if it was sellable), but not only is it showing up as more dps on the spreadsheet (for all specs) but, practically speaking it has to be even better than the spreadsheet shows based on how Fury works - for a sustained single target fight (what the spreadsheet models) fury is slightly worse than MoT while you can keep Fury's stack up on the boss. Now consider Ulduar fights - freya, hodir, yogg, etc - you are constantly switching targets in all these fights and will almost never get even a 1/2 stack up - FotFF will continously be going to waste, making it much much worse than MoT, which doesn't punish you for switching targets.

I do use FoFF on FL though

FotFF is a buff on you, not a debuff on your target. Unless it takes you 10 seconds to switch targets, your stack should not drop. The thing that kills FotFF sometimes in Ulduar is the need to move, but stutter-stepping and firing instant shots should alleviate this problem as well.

That being sad, MoT is still better. But FotFF certainly isn't bad (and I'm am actually using both for now, until I come upon something better).

Seoman · 07/07/09, 6:52 PM

I'm sorry but I cannot download the 90a version.

No matter what I do (clear cache, use a fresh Firefox, use a fresh IE, etc.) I get 90.

Shandara · 07/07/09, 7:04 PM

Originally Posted by Seoman

I'm sorry but I cannot download the 90a version.

No matter what I do (clear cache, use a fresh Firefox, use a fresh IE, etc.) I get 90.

I get this sometimes myself too. I'm not sure what causes it, but the most likely culprit beyond local caching is your ISP or some intermediary caching it for you.

Heuristic · 07/07/09, 8:48 PM

[BUG] After changing the default gems in the Settings tab (specifically 16ArP instead of 16Agi), the Gear Planner calculates the DPS value of items as if they are ungemmed, leading incorrect delta DPS values in cases of similar gear with and without sockets (Belt of the Betrayed vs Belt of Dragons, Boots of the Renewed Flight vs Boots of Living Scale). When I change the default gem value to Fractured Scarlet Ruby, all gemmed items in the gear planner loose a DPS value equal to 16*(#of gems)*(+1 Agi DPS value). Not sure what gems this affects, but changing the default to 27Agi does behave as it should.

Tested in 89g, 90-ptr, and 90a-ptr, on the character Heuristic of Firetree (US), as 7/57/7.

prime311 · 07/08/09, 12:15 PM

Not sure why, but MPE is still ranked below Envoy for me on the gear planner. I havent changed any default gems. Anyone else have this issue?

Gozardina · 07/08/09, 12:27 PM

Originally Posted by prime311

Not sure why, but MPE is still ranked below Envoy for me on the gear planner. I havent changed any default gems. Anyone else have this issue?

You either use the hit on the MPE or you don't. If you are hit capped it makes perfect sense to show a higher delta on the Envoy. This is a strange request asking others if they have the same issue because the spreadsheet is unique for each individual based on their current gear setup.

Shandara · 07/08/09, 12:32 PM

The Crit on the Envoy and the hit on the MPE (which you may or may not be able to use) make the difference.

Also, the Gear Planner doesn't regem for hit/agility for ranged weapons so for most setups where you'd use the Envoy you'd waste all the hit.