WotLK DPS spreadsheet - Page 25

Xoran · 10/18/08, 11:06 AM

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, 11:16 AM

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, 11:38 AM

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, 11:48 AM

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, 1: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, 3:40 AM

A trinket to add: [Empty Mug of Direbrew]

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

[Bloodlust Brooch]

Niouk · 10/19/08, 7: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, 4: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, 5: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, 10: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, 1: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, 1:43 AM

it doesnt

Uglychick · 10/21/08, 6: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, 6: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?