WotLK DPS spreadsheet - Page 24

samfisher · 10/16/08, 8:52 PM

I found that when you put TSA up in the buff section, everything goes #NA# and some other symbols until I turn it off. Just to let you know =)

alienangel · 10/17/08, 1:52 AM

Originally Posted by Shandara

This is a legacy of the old sheet, I've been meaning to do something about it, but the problem is that it merges 2 lists (one for 1-handed weapons and one for 2-handed weapons), which makes sorting on the fly impossible. They are both pregenerated.

I could merge them both and sort them alphabetically, if you think that's better. But you'd have a very long list to search through. I could also try to sort both lists alphabetically before merging them and add some sort of divider halfway between 1-handers and 2-handers.

Have one gear slot for "2 Handler", and two for "1 Hander", feed the two types different dropdowns, and when one type is set, blank out the other?

Also, since we're asking for stuff, filtering out all the random gems we don't care about, or sorting gems like other gear in the dropdowns would be great

Khallas · 10/17/08, 5:38 AM

Originally Posted by Kamaa

On a side note. [Quick Lionseye] is missing from the gem list.

Just to reiterate, [Quick Lionseye] & [Forceful Seaspray Emerald] are not able to be selected in the gem list.

Shandara · 10/17/08, 7:12 AM

Update:

- Added a setting to use 1 mana potion during the fight
- Wolverine Bite now is properly mitigated by armor
- Time sub-20% on the setting stab can now have decimals
- TSA buff on hunter/pet works again
- Implemented Upcoming AotV change
- Added Kill Shot low HP calculations. Kill Shot will replace only Steady Shots at the moment
- added Quick Lionseye/Forceful Seaspray Emerald
- Orc Blood Fury racial now has to be put in the shot rotation to have effect
- Sorted weapons list alphabetically
- Draenei Racial and Animal Handler also affect pet spellhit now
- Scrolls don't stack anymore.

Thelegend · 10/17/08, 8:01 AM

Heya Shandara

Not entirely sure what has happened, but I ported the old versions stats into the new version and my DPS appears to have gone up by roughly 155,000. After my initial moment of pleasure at what could be my new DPS figures, I realised that there may in fact be a problem.

I havn't been able to fix it via settings as of yet, however, there does appear to be a problem with the pre-loading of buff profiles (Warp Burger gets thrown into the 2nd weapon buff spot for example). Did you add additional hidden lines in there somewhere?

Either way - great work on the spreadsheet, I'm very happy to see it working so well.

Side note: Have you considered getting together with the RAWR guys to add all of this invaluable information to their files for accuracy? The modelling and what not within RAWR doesn't quite compare to that of the spreadsheet, however, for a general gear upgrade tool it is really quite something, which may benefit greatly from your input.

EDIT: Seem to be having a problem getting Serpent Sting working in the rotation tests too.

EDIT 2: Helm DPS contribution seems to be far higher than expected.

Shandara · 10/17/08, 10:48 AM

Originally Posted by Thelegend

Heya Shandara

Not entirely sure what has happened, but I ported the old versions stats into the new version and my DPS appears to have gone up by roughly 155,000. After my initial moment of pleasure at what could be my new DPS figures, I realised that there may in fact be a problem.

I havn't been able to fix it via settings as of yet, however, there does appear to be a problem with the pre-loading of buff profiles (Warp Burger gets thrown into the 2nd weapon buff spot for example). Did you add additional hidden lines in there somewhere?

Either way - great work on the spreadsheet, I'm very happy to see it working so well.

Side note: Have you considered getting together with the RAWR guys to add all of this invaluable information to their files for accuracy? The modelling and what not within RAWR doesn't quite compare to that of the spreadsheet, however, for a general gear upgrade tool it is really quite something, which may benefit greatly from your input.

EDIT: Seem to be having a problem getting Serpent Sting working in the rotation tests too.

EDIT 2: Helm DPS contribution seems to be far higher than expected.

Possibility: Did you import your settings from a previous version? I did make some changes along the way in version 74. If you load a buff profile then it will bug out.

Lactose · 10/17/08, 11:01 AM

Would it be possible to add a check to the import, testing whether or not the data is valid/not from an outdated export?
For example adding a ID at the start of the exported file. Every time you add something to break the export/import, you update the ID. If the imported ID doesn't match what the spreadsheet is set to export, abort the import --> prompt message.
Would something like that work?

Shandara · 10/17/08, 11:05 AM

Originally Posted by Lactose

Would it be possible to add a check to the import, testing whether or not the data is valid/not from an outdated export?
For example adding a ID at the start of the exported file. Every time you add something to break the export/import, you update the ID. If the imported ID doesn't match what the spreadsheet is set to export, abort the import --> prompt message.
Would something like that work?

Yes, I had something like that in, but for some reason I disabled it at some point.

Ebonleaf · 10/17/08, 11:27 AM

Hey bud, once again nice work on the sheet.

Just wanted to let you know, in case you didn't, the Surefooted enchant has changed. It's now 10crit / 10hit rating.

Ravenfire · 10/17/08, 6:04 PM

A heads up for you Shandara.

Stuff from the newest Beta build (taken from MMO-champion)

Beast Mastery

* Aspect of the Viper changed to - The hunter takes on the aspect of the viper, causing ranged and melee attacks to regenerate mana but reducing your total damage done by 50%. In addition, you gain 4% of maximum mana every 3 sec. Mana gained is based on the speed of your ranged weapon. Only one Aspect can be active at a time.

Survival

* Disengage mana cost has been lowered from 14% of base mana to 5% of base mana.

Talent
Beast Mastery

* Ferocious Inspiration now affects your raid.
* Animal Handler now increase your pet's expertise by 5/10. (Old - Increased the chance to hit by 2/4%)

Marksmanship

* Improved Barrage now affects Aimed Shot.
* Barrage now affects Aimed Shot.

Pet Skills

* Swipe (Bear) focus cost reduced from 25 to to 20. Damage increased (60-84 to 90-126 for Rank 6)
* Snatch (Bird of Prey) focus cost reduced from 40 to 20.
* Gore (Boar) focus cost reduced from 25 to 20. Damage increased. (122-164 for Rank 6)
* Rake (Cat) focus cost reduced from 25 to 20. Damage lowered. (From 59-83 + 21-27 over 9 sec to 24-34 + 22-28 over 9 sec)
* Fire Breath (Dragonhawk) now has a 20 yards range.
* Froststorm Breath (Chimaera) focus cost reduced from 25 to 20. Damage increased. (64-86 to 128-172 for Rank 6)
* Lava Breath (Core Hound) focus cost reduced from 25 to 20. Damage increased. (64-86 to 128-172 for Rank 6)
* Monstrous Bite (Devilsaur) focus cost reduced from 25 to 20.
* Stamped (Rhino) damage increased (from 91-123 to 182-246 for Rank 6). Knockback reduced from 15 yards to 10 yards.
* Spirit Strike (Spirit Beast) damage increased. (from 43-47 + 43-47 over 10 sec to 85-115 + 85-115 over 10 sec)
* Acid Spit (Worm) damage increased. (62-88 to 124-176 for Rank 6)
* Thunderstomp (Gorilla) focus cost reduced from 25 to 20.
* Tendon Rip (Hyena) focus cost reduced from 25 to 20.
* Savage Rend (Raptor) focus cost reduced from 25 to 20.
* Ravage (Ravager) damage increased. (89-125 to 106-150 for Rank 6)
* Scorpid Poison (Scorpid) focus cost reduced from 25 to 20. Damage lowered. (From 85 to 45 for Rank 6)
* Poison Spit (Serpent) focus cost reduced from 25 to 20.
* Spore Cloud (Sporebat) focus cost reduced from 25 to 20.
* Lightning Breath (Wind Serpent) focus cost reduced from 25 to 20.
* Sting (Wasp) focus cost reduced from 25 to 20.

Mackenz · 10/17/08, 6:43 PM

I was wondering if a small change might be useful for people to 'calibrate' the latency for themselves. When I ran some Level 70 Dummy tests, I noticed my DPS was much lower than the spreadsheet, but I also noticed that the spreadsheet's time to Out-Of-Mana (OOM) was lower than the couple of times I ran from full to OOM and stopped.

I hand adjusted the latency until the spreadsheet's time to OOM approximated my tests, and the numbers came in much closer to my real tests. Would this be a valid way of calibrating the latency on the spreadsheet? If so, is it possible to setup a cell to enter in the real time to OOM, which would calculate that back to a latency value? I suspect that would have to be an iterative calculation though.

Note that having Haste or Critical Strike On Use trinkets can skew things a little because of varying mana regeneration or usage. I used Bloodlust Brooch (which would have no OOM effect), but the caveat with Haste/Critical Strike apply.

Azurei · 10/18/08, 3:04 AM

I'm running into this error when I try to load my gear, Kragus | Windrunner | US:

Run Time Error '91': Object variable or With block variable not set

I just downloaded v75 and it works fine with Shandara's default settings. I saw this post and tried those suggestions but it still doesn't work. It's failing in getTooltipValue() where url="http://www.wowarmory.com/item-tooltip.xml?i=33206&r=Windrunner&n=Kragus&lang=en_us" and search="enchant". ThisComponent=Empty and Node ends up set to Nothing so it fails setting value = Node.Text. It's failing on my shoulder enchant.

Another thing I noticed, which may not be related...
I'm using Office 2007 and when I try to save the file from Excel, I get a compatibility error, "Some formulas in this workbook are linked to other workbooks that are closed... Location: Defined Names."

Let me know if you need more info.

BTW, this is the first time I've tried to use this spreadsheet but I've been using the last rev of Cheeky's for sometime with no issues. The sheet looks awesome BTW... I'm eager to get it working. Thanks.

Shandara · 10/18/08, 4:50 AM

Originally Posted by Azurei

I'm running into this error when I try to load my gear, Kragus | Windrunner | US:

Run Time Error '91': Object variable or With block variable not set

I just downloaded v75 and it works fine with Shandara's default settings. I saw this post and tried those suggestions but it still doesn't work. It's failing in getTooltipValue() where url="http://www.wowarmory.com/item-tooltip.xml?i=33206&r=Windrunner&n=Kragus&lang=en_us" and search="enchant". ThisComponent=Empty and Node ends up set to Nothing so it fails setting value = Node.Text. It's failing on my shoulder enchant.

Another thing I noticed, which may not be related...
I'm using Office 2007 and when I try to save the file from Excel, I get a compatibility error, "Some formulas in this workbook are linked to other workbooks that are closed... Location: Defined Names."

Let me know if you need more info.

BTW, this is the first time I've tried to use this spreadsheet but I've been using the last rev of Cheeky's for sometime with no issues. The sheet looks awesome BTW... I'm eager to get it working. Thanks.

Blizzard seems to have updated the Armory to the new patch. This has broken armory scraping. I'm not an XML wizard so I'll have to find some time to delve into it. If anyone can look at it and find the magic fix please PM me.

Update:

- Added a version check to importing/exporting
- Animal Handler now gives 5/10 Expertise to your pet (1,25/2,5% dodge reduction)
- Most family special skills now cost 20 focus, adjusted damage to published figures (not all ranks are known so far)
- Surefooted is now +10 hit/crit
- Glyph of Trueshot Aura now gives 10% aimed shot crit chance
- Armory talent Scrape working again
- Barrage and Improved Barrage now affect Aimed Shot

Also added a bug check to the armory import. For some reason it's working for EU armory but some US items do not report the enchant properly. It should properly catch that and continue now, but you have to manually adjust the enchant.

Jander · 10/18/08, 9:10 AM

Barrage/Improved Barrage are affecting Chimera Damage in the 75a.

Shandara · 10/18/08, 10:12 AM

Originally Posted by Jander

Barrage/Improved Barrage are affecting Chimera Damage in the 75a.

Yes, a result of my laziness in reusing the Aimed Shot calculations. Fixed next version.

Update:
Quick fix for Chimera Shot.