WotLK DPS spreadsheet - Page 154

Dch48 · 05/03/09, 6:44 PM

The Silithid is still classed as ferocity when according to every other reference, they are cunning.

sihyunie · 05/03/09, 10:17 PM

Originally Posted by Chasim

I'm sorry if this has been asked before (tried searching...) but why does the Hunter Hit +1 value always stay so high? For example, I'm currently 278 Hit (15 over the cap) and the Hunter Hit +1 value is still 1.583 - shouldn't it now be 0?

One other thing - with 87c, "For Pet" hit (on the Overview tab) does not seem to correctly calculate. At 278 hit, it shows 0. Shouldn't that be -14?

I believe pet inherits your hit rounded down to the one's digit. So that means if you have 7.xx%, your pet only gains 7% hit. So if you are 8.xx%, you are over hit cap, but pet is exactly at 8%.

tyrindor · 05/04/09, 3:12 AM

Blood of the Old God isn't in the spreadsheet, please add

[Blood of the Old God]

Shandara · 05/04/09, 8:21 AM

Update:

- Armory Import now also sets level correctly
- added validation to pet talent trees (visual notifier when the spec is incorrect/impossible)
- fixed spelling error on Berserking racial in the rotation test that made readiness reset it.
- Gathering Skill now linked to gear load/save on Gear tab
- Made extensive changes to the data underlying the gear tab and Gear Planner, removing the RAP/health/mana columns and sorting all individual gear tabs the same way
- LnL 2/4/6% chance to proc again.
- On Armory gear loading, it now prompts you to try and load stats from unknown items into the Custom Gear tab. Does not work for Trinkets, but should work for all other slots.
- Re-did some of the base stat calculations to more closely match in-game (see the Gear tab)
- Silithids now Cunning pets
- Added some more gear
- Removed all NYI gems and added an option to filter out all (un)common quality gems (on by default)
- Gear Planner now shows rings, trinkets and 1h weapons separate for both slots
- Gear string import fixed

Compared to the previous version you might notice some slight DPS decrease because I fixed some rounding errors along the way while trying to get my numbers to match in-game character tab more. Also changed the fact that 2t7 seemed to boost pet AP by 5% on the PTR but seems to have been fixed on Live.
EDIT: Also changed the rating conversions to use greater precision up to 6 decimals (from the Combat Ratings at 80 thread), which seemed to fix some rounding errors as well.

For the Armory import new feature, I had to guess at how some stats are handled (esp Mp5 and Resilience) so if you are wearing any unrecognized item with those stats on them and the import fails, let me know. This feature is still a bit experimental since the sheet seems to have most gear in it by now.

For the Gear planner change: When comparing a currently 2-hander versus a dual-wield combo, the dps of the 2-hander is split into 2 over both Main-hand and Off-hand comparisons. For the purposes of +hit calculations and hit-cap the 2-hander's hit is also split.

Aieda · 05/04/09, 9:32 AM

Before the update Giants showed as more dps for me than Siren's. Now after your update Siren's shows as biggest dps upgrade.

I'm a dwarf and wondering if the Giants gun is not supposed to be the best ranged weapon for me? How (or where) can I see if the spreadsheet is calculating my racial gun bonus into the dps numbers?

Shandara · 05/04/09, 9:47 AM

Originally Posted by Aieda

Before the update Giants showed as more dps for me than Siren's. Now after your update Siren's shows as biggest dps upgrade.

I'm a dwarf and wondering if the Giants gun is not supposed to be the best ranged weapon for me? How (or where) can I see if the spreadsheet is calculating my racial gun bonus into the dps numbers?

Ah drat, this had slipped my mind to check. It has indeed been bugged for a while now. I've re-uploaded v88 with a quick fix for this.

Seoman · 05/04/09, 10:49 AM

With regard to focus starvation, I see a decent DPS boost on the spreadsheet to taking a second point in GftT (with MM and SV builds). Is the spreadsheet modeling the current situation where Explosive Shot ticks don't proc GftT?

If it is, then it's possible that once the announced changes occur in the coming patch, that 1/2 GftT will be enough for SV. If not, then it seems like the base Focus regen change from 24.5/4 sec to 20/4 sec essentially necessitate 2/2 GftT regardless of the ES fix.

Shandara · 05/04/09, 11:25 AM

I've re-uploaded v88 fixing a small bug with trinkets with on-use procs not adding dps properly and a toggle on the Shot Rotation for ES to proc stuff on crits.

Argg0 · 05/04/09, 1:52 PM

I think you forgot the troll racial (Bow Specialization) as well.

Snaile · 05/04/09, 2:11 PM

Possible v88 issues.

Mammoth Cutter ammo seems missing and I see a person can still select a quiver even though the 15% speed increase is now built into Auto Shot (I assume this might be for testing)

nvm. on loading a pre saved profile all ammo appeared.

btw. Thank You for this sheet it really is a great help

Shandara · 05/04/09, 2:30 PM

Originally Posted by Snaile

Possible v88 issues.

Mammoth Cutter ammo seems missing and I see a person can still select a quiver even though the 15% speed increase is now built into Auto Shot (I assume this might be for testing)

nvm. on loading a pre saved profile all ammo appeared.

btw. Thank You for this sheet it really is a great help

Selecting quivers is purely cosmetic at the moment. I've been meaning to remove it..

EDIT:
Uploaded v88a which fixes the Troll racial (and puts in the changelog the several ninja-changes I did today).

Grimmarg · 05/04/09, 4:05 PM

Question in regards to the frequent updates of the spreadsheet...

Is it possible to transfer your settings from one version to another, or do I have to set everything up from scratch everytime a new version is out?

Kargos · 05/04/09, 4:14 PM

In the Overview tab under where you insert your character name and realm there is a button that says Export to File.

Clicky clicky.

Kathucka · 05/04/09, 4:44 PM

Some small bugs:

Pendant of the Outcast Hero is showing as an Emblem of Valor purchase. It's purchased with Emblems of Heroism.

Obsidian Sanctum hard-mode items are showing up on the gear planner when the "hard mode" checkbox is not checked.

The shot priority box on the shot rotation tab shows Serpent Sting with a "cooldown" of 15 seconds when it is glyphed. It's correct at 21 on the reference table and shot rotation tester, though.

Shoulders of Misfortune show up on the gear planner as from Ulduar-25, when the 25-man box is not checked.

Shandara · 05/04/09, 5:00 PM

Originally Posted by Kathucka

Some small bugs:

Pendant of the Outcast Hero is showing as an Emblem of Valor purchase. It's purchased with Emblems of Heroism.

Obsidian Sanctum hard-mode items are showing up on the gear planner when the "hard mode" checkbox is not checked.

The shot priority box on the shot rotation tab shows Serpent Sting with a "cooldown" of 15 seconds when it is glyphed. It's correct at 21 on the reference table and shot rotation tester, though.

Shoulders of Misfortune show up on the gear planner as from Ulduar-25, when the 25-man box is not checked.

Thanks. The Serpent Sting is a relic that I've been meaning to clean up. Serpent Sting obviously doesn't have a 'cooldown', but for ease of use was always treated by the spreadsheet as having a 15sec Cooldown.