WotLK DPS spreadsheet - Page 15

Shandara · 10/17/08, 11: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, 12:01 PM

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, 12:05 PM

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, 12:27 PM

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, 7: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, 7: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, 4: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, 5: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, 10:10 AM

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

Shandara · 10/18/08, 11: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.

Xoran · 10/18/08, 12:06 PM

With version 75b everytime I try to import data, I get a Run Time Error '458'.

Also there must be something wrong with your calculations of the new animal handler, because putting a point there increases my pets dps by 1000+ =)

Shandara · 10/18/08, 12:16 PM

Originally Posted by Xoran

With version 75b everytime I try to import data, I get a Run Time Error '458'.

Also there must be something wrong with your calculations of the new animal handler, because putting a point there increases my pets dps by 1000+ =)

I've reuploaded it, since I forgot to change a comma in there. I've had no problems with the exporting/importing myself. As always, it's better not to use it too much if it breaks at this stage. Once we're fully in WotLK and I don't have to change things every few days it won't be such an issue.

EDIT:
I think I know why the import is giving problems. Since I added a version check again, any old(er) exported settings file won't have that version. It still tries to get it from the file so it bugs out.

grim4o4 · 10/18/08, 12:38 PM

Something strange is happening when I import my character from Armory. An error pops up and says "Enchant is empty" then assigns my items a random enchant. Everything is normal when I go to my armory.

I also wanted to say how much I appreciate the work you're doing on this, I can only imagine how much it is to debug excel and simultaneously add every change blizzard is making, so, Thank You.

Shandara · 10/18/08, 12:48 PM

Originally Posted by grim4o4

Something strange is happening when I import my character from Armory. An error pops up and says "Enchant is empty" then assigns my items a random enchant. Everything is normal when I go to my armory.

I also wanted to say how much I appreciate the work you're doing on this, I can only imagine how much it is to debug excel and simultaneously add every change blizzard is making, so, Thank You.

Yes, that's the bug-catcher I put in for the Armory problems that people have been having. For some reason the XML it downloads from the armory signifies there's an enchant on an item, but then when it tries to _get_ the enchant it's empty.

I put in some checks and the message box that pops up to prevent it from totally crashing. You'll have to assign the enchant manually for the time being until I can figure out what's wrong.

EDIT:
After some trial and error and comparing EU and US it seems the US armory server just isn't giving the right data. It's not passing on the gems/enchants on items at the moment at least not in the XML objects the armory scrape code uses (and which work for EU).

If there's any XML wizard around who has an idea or a solution, PM me.

Compare:
http://armory.wow-europe.com/item-to...ara&lang=en_gb (my Bow-stitched leggings)
and
http://www.wowarmory.com/item-toolti...eaf&lang=en_us (Ebonleaf's Leggings of the Pursuit)

Both enchanted/gemmed.

skunkone · 10/18/08, 2:40 PM

How do you change the shot rotation to whatever I want, such as in the previous versions where one could select by just clicking the button and it would update?

Also why is the predicted/corrected dps different than the gear tab?

Thanks

Azurei · 10/19/08, 4:40 AM

A trinket to add: [Empty Mug of Direbrew]

Osse · 10/19/08, 5:02 AM

[Bloodlust Brooch]

Niouk · 10/19/08, 8:24 AM

Aimed shot still has a 3,00 Base Cast Time and a 12,00 Cooldown in the spreadsheet : (
(Should be instant, and 10 seconds CD)

Thanks for your work Shandara.

edit : cast time is just a display issue in calculations tab.

Devastor · 10/19/08, 5:41 PM

TBW and longevity seem to be twisted in talents-sheet (import from armory = 3 points in TBW instead of longevity)

Shandara · 10/19/08, 6:20 PM

Originally Posted by Devastor

TBW and longevity seem to be twisted in talents-sheet (import from armory = 3 points in TBW instead of longevity)

Correct, they have the wrong order in the sheet so the import ends up in the wrong spot. Fixed next release.

EDIT:
Update

- Madness of the Betrayer proc is now 42 arm penetration rating
- Greater Assault bracer enchant is now +50 AP
- Fixed US armory import
- Armory talent scrape puts points correctly in TBW/Longevity now

Devastor · 10/20/08, 11:00 PM

question: Rotation Test tab, there is Predicted and Corrected DPS
What is this about^^?
Throughout the Spreadsheet, you use Predicted DPS (but "corrected dps" sounds more like "true DPS" and should therefore be listed?)

Keep up the good work! The spreadsheet rocks..

/e: oh, one thing regarding the pre-set Pet tree: as i understand it, Spiked Collar always yields more DPS than Spiders Bite, therefore should be 3/3 and Spiders bite 1/3 (or 2/3 with 1/3Bloodthirsty?)

/e2:

- Armory talent scrape puts points correctly in TBW/Longevity now

this is NOT fixed in 75c, TBW is still listed first, Longevity second (must be the other way around)

Shandara · 10/21/08, 2:41 AM

Originally Posted by Devastor

/e2:
this is NOT fixed in 75c, TBW is still listed first, Longevity second (must be the other way around)

Yes, but it does put the points in the correct spot (I didn't swap them around as that would involve a lot more work than merely redirecting the points taken from the Armory).

Devastor · 10/21/08, 2:43 AM

it doesnt

Uglychick · 10/21/08, 7:41 AM

Jin'rohk, The Great Apocalypse is missing,so that u know.

And THANK YOU THANK YOU THANK YOU for taking your time to do this.I was really sad thinking that there wont be spreadsheet anymore...

Uglychick · 10/21/08, 7:45 AM

I can't seem to write on tkasomething, I hope this will get to you Shandara.
I'm having problems with shot rotation adjustment. It wont allow me to change shot priority (saying it's read only), furthermore, is reference table linked to settings sheet? Or how do I change reference table? maybe I'm n00b, but need help here...
Is it somewhere posted new "how to use" the spreadsheet due to changes since you've updated it?