WotLK DPS spreadsheet - Page 125

arlen · 07/22/09, 8:39 PM

Did you disable the Improved Hunters Mark in the debuffs section of the buffs tab?

Tanials · 07/22/09, 9:35 PM

I see, thank you. I guess the spreadsheet assumes another hunter with 3/3 points in improved huntersmark and glyphs brings the hunter's mark. DPS indeed does increase when I don't use glyphed and improved as modifier.

Korghal · 07/23/09, 10:48 AM

*EDIT*
Didn't realise that there was another page, delete please.

Shandara · 07/23/09, 12:34 PM

New version (91):

- Added gear optimizer to find an optimal gear set
- Added an automatic re-gemmer on the gear tab
- changed Gear Planner to be actually try out all the items instead of calculating how much DPS they are.
- prepared sheet for 3.2 changes, especially multiple different item IDs for the same item name (tier9)
- Added most 3.2 mail gear, weapons and trinkets/necklaces/rings

Thanks to all the people who beta-tested, your efforts are appreciated!

Things to do still:
- add leather gear (might skip all the pieces with expertise this patch, they are subpar usually)
- add pvp gear (although with the massive amounts of stamina and lack of other stats on most pvp gear they are unlikely to be competitive for PvE dps.
- improve gear optimizer UI

Speed is good on my computer (E8500 3.16 ghz dual-core). The Gear Planner takes 85ms per item now, let me know if anyone with a modern computer (modern defined as anything more recent than mine) suffers from bad performance. I'm not sure what caused some testers to suffer from bad performance, but I hope the many fixes/optimizations I've done have fixed that.

People with older computers, sorry! Although even at 2-3 times slower it should still be interactively usable.

Tsook · 07/23/09, 1:00 PM

"Load Gear from Armory" appears to just clear all of my items. The Armory isn't down, though -- it comes up fine in my browser.

EDIT: Delta on the Gear Planner from offhand item when you have a 2H equipped appears to be off, as well. It's showing a 400 DPS delta for everything in the list. I'm guessing it's not de-equipping the 2H when it tries the offhand?

Shandara · 07/23/09, 1:37 PM

Originally Posted by Tsook

"Load Gear from Armory" appears to just clear all of my items. The Armory isn't down, though -- it comes up fine in my browser.

EDIT: Delta on the Gear Planner from offhand item when you have a 2H equipped appears to be off, as well. It's showing a 400 DPS delta for everything in the list. I'm guessing it's not de-equipping the 2H when it tries the offhand?

Strange, your Armory profile loads normally in my sheet. Are you using a proxy or something to connect to the internet?

I've re-uploaded v91 fixing your 2-hander problem. It was on my list, but I'd forgotten to fix that today. Comparisons between 2h and 1h combos are always a bit iffy, because your dps increase depends on both 1-handers.

Bikiniwax · 07/23/09, 1:52 PM

Originally Posted by Shandara

Do you have buffs enabled that give IHM Mark?

Originally Posted by Tsook

"Load Gear from Armory" appears to just clear all of my items. The Armory isn't down, though -- it comes up fine in my browser.

EDIT: Delta on the Gear Planner from offhand item when you have a 2H equipped appears to be off, as well. It's showing a 400 DPS delta for everything in the list. I'm guessing it's not de-equipping the 2H when it tries the offhand?

Also seeing Rune Edge now having 5.41 delta better than Lotrafen, which goes against every version of the spreadsheet prior to this one (with no changes in gear or spec).

Shandara · 07/23/09, 1:58 PM

Originally Posted by Bikiniwax

Also seeing Rune Edge now having 5.41 delta better than Lotrafen, which goes against every version of the spreadsheet prior to this one (with no changes in gear or spec).

Loading your profile and talents with standard buffs in the sheet I see Rune Edge as a 10 dps downgrade from Lotrafen.

Bikiniwax · 07/23/09, 2:02 PM

Weird. I did use an export of the previous version and imported it. I will create a new one from scratch and see if that fixes it.

Edit: Much better now. I was worried seeing Slime Stream Bands being an upgrade over Frost-Bound Chain Bracers. Not the first time the spreadsheet seemed really off after an export/import. I plan to stop using the import/export feature for now.

Thanks Shandara!

Tsook · 07/23/09, 2:22 PM

Originally Posted by Shandara

Strange, your Armory profile loads normally in my sheet. Are you using a proxy or something to connect to the internet?

No, everything's standard and it's always worked before. I must have mistyped my name or something. I'll check when I get home and let you know if I can still reproduce.

Kurianna · 07/23/09, 2:35 PM

Did you make any changes between the last beta and this version that would affect autoshots? My autoshot damage is lower, and speed is lower, causing about 150 dps drop from beta.

Edit: Also, if you use the import fuction from the last beta, it breaks the gear import some how. I had the same issue as the above poster, but didn't save it. I closed it and started from scratch with the gear import, and it worked fine. Try it with a clean sheet (don't import settings) and see if that fixes it.

Shandara · 07/23/09, 2:44 PM

Originally Posted by Kurianna

Did you make any changes between the last beta and this version that would affect autoshots? My autoshot damage is lower, and speed is lower, causing about 150 dps drop from beta.

Edit: Also, if you use the import fuction from the last beta, it breaks the gear import some how. I had the same issue as the above poster, but didn't save it. I closed it and started from scratch with the gear import, and it worked fine. Try it with a clean sheet (don't import settings) and see if that fixes it.

I'd left a debug function in somewhere which messed up some haste calculations. I've re-uploaded v91 fixing that.

EDIT:
Did you have custom gems defined on the settings tab for auto-fill default gems? I have a feeling that might be causing problems somewhere.

Kurianna · 07/23/09, 3:11 PM

I didn't change anything in the settings tab. Not sure what the difference is, but loading the export file saved from the previous version into the newest causes it to just blank out your gear when hitting update from armory, just like Kikiwax stated.

Shandara · 07/23/09, 3:17 PM

Originally Posted by Kurianna

I didn't change anything in the settings tab. Not sure what the difference is, but loading the export file saved from the previous version into the newest causes it to just blank out your gear when hitting update from armory, just like Kikiwax stated.

Previous as in v91beta6?

I tried it with beta6, but ran into no problems.

Kurianna · 07/23/09, 3:22 PM

Originally Posted by Shandara

Previous as in v91beta6?

I tried it with beta6, but ran into no problems.

Yes, beta6. It's entirly possible I did something to cause it. I Just found it odd that it happened to someone else, so I wanted you to be aware of it.

Shandara · 07/23/09, 3:30 PM

Originally Posted by Kurianna

Yes, beta6. It's entirly possible I did something to cause it. I Just found it odd that it happened to someone else, so I wanted you to be aware of it.

I'm very well believing people have problems, but I'm having trouble reproducing it myself. Could you possibly upload yours somewhere to see where it goes wrong? Possibly just your export file so I can import it.

Seoman · 07/23/09, 3:36 PM

I'm noticing Wrathstone falling out of the second tier of top trinkets. Is this correct?

Shandara · 07/23/09, 3:44 PM

Originally Posted by Seoman

I'm noticing Wrathstone falling out of the second tier of top trinkets. Is this correct?

Trinkets with 'on-use' effects are broken a bit (not correctly adding their averaged out stat). I'll have it fixed soon. Thanks for the report.

EDIT:
Re-uploaded v91 fixing this. As always, if you have trouble redownloading, clear your browser/DNS resolver cache and see if it fixes it.

Kurianna · 07/23/09, 4:09 PM

I can't upload it at work. I can't even download the newest one until I get home. I'll try to do it after work, but I can't promise you anything (wife aggro).

Rathenel · 07/23/09, 4:39 PM

The link to 89g seems to be broken at the moment.

Sjanny · 07/23/09, 4:48 PM

Did you consider removing silencng shot from "waited" in the rotation test? I dont think it makes sense to wait for a shot that is off gcd?

Also when I try to sort the gems it goes to debugging with an error message "Compile error: argument is not optional",
pointing at Call SortItemsA function.

Shandara · 07/23/09, 5:22 PM

Originally Posted by Sjanny

Also when I try to sort the gems it goes to debugging with an error message "Compile error: argument is not optional", pointing at Call SortItemsA function.

Thanks, I've fixed this. Re-download if you can't miss that functionality.

Sjanny · 07/23/09, 6:05 PM

Thank you and awesome work

Spamurai · 07/23/09, 7:39 PM

Using your latest incantation of v91 - I'm currently wearing Broach of the Wailing Night and the Gear Planner is telling me that Favor of the Dragon Queen is an upgrade, but when equipping it and putting any kind of gem in it, it still comes out lower than my current.

Here's a link to my spreadsheet so you can duplicate: Free File Hosting Made Simple - MediaFire

Shandara · 07/23/09, 7:43 PM

Originally Posted by Spamurai

Using your latest incantation of v91 - I'm currently wearing Broach of the Wailing Night and the Gear Planner is telling me that Favor of the Dragon Queen is an upgrade, but when equipping it and putting any kind of gem in it, it still comes out lower than my current.

Here's a link to my spreadsheet so you can duplicate: Free File Hosting Made Simple - MediaFire

The Gear Planner assumes you re-gem completely. Hit the re-gem button to see what the spreadsheet comes up (the gear planner also uses this during the calculations).

There is a problem when people start with a sub-optimal (from the spreadsheet view) gemming, because during the gear planning process it has to re-gem when it equips a new item..