WotLK DPS spreadsheet - Page 30

Cranch · 10/27/08, 2:39 PM

Looks like the Armory is still bugged. For "Cranch" "Perenolde" "U.S." I get Run-time error '91': Object variable or With block variable not set. (version 76b, Excel 2003.)

Shandara · 10/27/08, 5:58 PM

Originally Posted by Cranch

Looks like the Armory is still bugged. For "Cranch" "Perenolde" "U.S." I get Run-time error '91': Object variable or With block variable not set. (version 76b, Excel 2003.)

The Armory appears to be broken or being maintenanced. If I load your armory page a number of slots are not loading, which is causing the error for the spreadsheet.

Flouyd · 10/27/08, 11:19 PM

I tryed the new sheet and somehow no Item was showing a socked bonus. Anyone else noticed this?

samfisher · 10/28/08, 1:15 AM

As stated by Shandara, Armory may be bugged and/or the Spreadsheet isn't reading it right at the moment. Next release should fix it, unless Blizz plays with their Armory code some more.

Difool · 10/28/08, 8:02 AM

I can confirm the armory isn't updating. My talents and items listed there are well over a week old. Other services that access armory, such as WOWJutsu, and this sheet, will of course pick up only what armory is showing.

Archaus · 10/28/08, 9:34 AM

There appears to be a problem with the Talents tab of the latest version of the spreadsheet. Without doing anything with the Armory, just selecting the "Level 70 50/11 BM spec" and pressing Load Spec I end up with 2 points in Thick Hide and 0 points in Focused Fire. I was curious if it was just a display bug but manually changing the points showed up as a DPS increase. All the other points for that spec seemed to be allocated appropriately.

Shandara · 10/28/08, 1:32 PM

It's a typo on my part probably. I copied the spec from a linked talent build.

Update:

- Chimera-Shot Serpent effect now affected by Mortal Shots
- Corrected spelling error on Biznicks Accurascope
- Socket Bonuses work again
- Fixed issue with Jin'rohk not working

drpachinko · 10/28/08, 3:59 PM

Hi it seems the pet armor is not calculating correctly on the spread sheet.

This may only effect tenacity pets I didn't do to much testing trying out other pet branches

Basically with all the armor talents and the tree bonus of 10% your pets armor should increase by at least 150%

I might be wrong about the tree bonus though im not sure. So for safety i tried just 140 percent. My pet 6724 my bonus armor 3116 * 1.40 = 13.7k

The sheet calculated as 12.5k

I wrote a much larger post with more attempts to calculate but the page timed out and I lost it

I hope this helps... I know this is such a minor thing
I didn't know the right formula or the password to the sheet so I didn't try and fix it.

Archaus · 10/28/08, 4:29 PM

Originally Posted by Shandara

It's a typo on my part probably. I copied the spec from a linked talent build.

Actually I think there is something more fundamental going on because importing my current spec from the armory was accurate everywhere except Thick Hide/Focused Fire. I'm guessing those two are getting mixed up in parsing somewhere.

Shandara · 10/28/08, 4:51 PM

Originally Posted by Archaus

Actually I think there is something more fundamental going on because importing my current spec from the armory was accurate everywhere except Thick Hide/Focused Fire. I'm guessing those two are getting mixed up in parsing somewhere.

You're right. I've ninja-uploaded a quick fix for this.

baldeagle · 10/29/08, 9:42 AM

I just downloaded v76c, updated profile, manually made sure all values are correct, and it seems hit calculation are off. It is calculating 100% chance to hit lvl 73 boss with only 127 hit, not 142. Is this a bug? Did I miss something regarding patch 3.0 lowering our hit cap?

Kathris · 10/29/08, 10:26 AM

Originally Posted by baldeagle

I just downloaded v76c, updated profile, manually made sure all values are correct, and it seems hit calculation are off. It is calculating 100% chance to hit lvl 73 boss with only 127 hit, not 142. Is this a bug? Did I miss something regarding patch 3.0 lowering our hit cap?

Did you check to see if you had Draenei Racial box in your buff tab set to yes? Would account for your 1% hit.

Shandara · 10/29/08, 10:29 AM

Originally Posted by baldeagle

I just downloaded v76c, updated profile, manually made sure all values are correct, and it seems hit calculation are off. It is calculating 100% chance to hit lvl 73 boss with only 127 hit, not 142. Is this a bug? Did I miss something regarding patch 3.0 lowering our hit cap?

If you're not using points in Focused Aim and/or +hit food can you upload the sheet somewhere for me to look at?

baldeagle · 10/29/08, 10:50 AM

Originally Posted by Shandara

If you're not using points in Focused Aim and/or +hit food can you upload the sheet somewhere for me to look at?

Not using hit food, and my hit is actually 145 unbuffed. Here is my armory page: The World of Warcraft Armory

I would be glad to upload the sheet somewhere that you can access it, just not sure where that would be. I can email it as an attachment if you want to do it that way. If that works for you, I would be very greatful for the help. Or let me know how else I can get it to you.

Originally Posted by Kathris

Did you check to see if you had Draenei Racial box in your buff tab set to yes? Would account for your 1% hit.

Yes, I cleared all buffs after loading my profile from armory, then manually added warp burger and major agi potion buffs.

Jack The Pumpkin King · 10/29/08, 9:12 PM

I just installed the spreadsheet recently, and input all of my gear/spec. My Marksmanship spec was showing around 1516 DPS, with me contributing 1100 and my pet contributing 400 or so. After going the spec that I built on the spreadsheet, I went to a target dummy in Silvermoon to try it out, but found a large difference between the approximate DPS (according to the spreadsheet) and the DPS I was actually doing.

I'd like to know if anyone has any ideas as to why the spreadsheet may not be accurate for me. (No raid buffs are enabled on the spreadsheet or in-game). If anyone could toss around some ideas as to why i'm pulling 1000-1300 in-game, but the spreadsheet shows ~1500 DPS, I would very much appreciate it. Thanks in advance.