Warrior DPS Calculation Spreadsheet - Page 103

Moozhe · 09/02/09, 2:33 AM

I'm confused by the spreadsheet and I'm wondering if I've encountered a bug.

Currently I am not quite hit capped and the SEP on Hit Rating is higher than ArP. When I switch between ArP food and Hit Rating food, it correctly shows my DPS is higher using Hit Rating food. If I switch the gem in my T8.5 gloves from ArP to Hit Rating, my DPS goes down.

I especially don't get it because the socket bonus on the gloves is +4 Hit Rating.

So if 40 Hit Rating > 40 ArP Rating (according to the spreadsheet), why is 20 ArP Rating > 24 Hit Rating (also according to the spreadsheet).

The other bugs I found were that I can't manually change my talents, the macro to fetch talents from the armory does not work, and my Nitro Boosts (+24 Crit Rating) enchant is not recognized.

EDIT: I think I figured out why. Even though switching the gem gives me 24 Hit Rating, I am less than that from the cap. So when it says the SEP is higher, it means for how ever many points until I reach the cap.

Lifthrasil · 09/02/09, 3:29 AM

Finaly! Thanks!

But Aesir's Edge seems to be missing in fury offhand...

Bigboss_hr · 09/02/09, 3:43 AM

I have some problems with new sheet.
If I change race from night elf (Landsoul) to orc many things gets red ("doll" column-J22; "DPS breakdown"; & all tables below "Orientation & buffs")
Dps calculation says "change lookup"
Also on lookup tab the "DPSdiff" coulmn says "#DIV/0!
Do we need to import charr from armory to make it work?
It wasn't the case with previous sheets...
I'm kinda lost here

Lifthrasil · 09/02/09, 3:47 AM

Originally Posted by landsoul

Changes this version:
[...]

-Added a reddish text color scheme for horde, and blueish text color scheme for alliance, changes when you update your race.

[...]

It's not a bug, it's a feature

Bigboss_hr · 09/02/09, 4:14 AM

Originally Posted by Lifthrasil

It's not a bug, it's a feature

Ok..but calculations doesn't work...macros are turned on btw.
And what is "change lookup"?? I also tried switching fury to arms & back on lookup tab but with no results

Speeder · 09/02/09, 4:31 AM

I can confirm that calculations dont work for me either. macros are running, iterative calculations are turned on.

Changing single item keeps giving me calculations error.

patched my office with SP1 and SP2 - SEP doesnt work stil.

Graul · 09/02/09, 4:35 AM

Nevermind, reinstalling office differently fixed the issue. Everything seems to work fine so far except the "DPS difference" for off hand weapons, the column is filled with NA after an armory import. The trace reports a circular reference error.

rejdakon · 09/02/09, 5:15 AM

I get #WERT! (german office 2007, this should be #vlaue in english) in most of the calculated cells. Sheet loads just fine, armory import is working. Errors occur only after using the SEP macro. I tried following the error-paths but with hundreds of cells showing this error and references (including circle references) across the sheet I finally quit trying.

If there is any way I can find out specifics without following every single reference, please let me know.

bo5r5osh · 09/02/09, 7:01 AM

Page: MS Visual Basic, Module 11
Type: Typo
Typo path: "//talentGroups/talentGroup[@active=""1""]/talentSpec"
Correct path: "//talents/talentGroup[@active=""1""]/talentSpec"

myno · 09/02/09, 7:01 AM

Originally Posted by Liar

I have a problem getting the sheet to work and I am not sure if it just a problem on my end. When I open the sheet, it tells me it found unreadable content in the sheet and if I would like to restore it, to which I press Yes. I realize I my network card is somewhat wonky so I sometimes get corrupted files when downloading (large) files so just making sure it's not that. Am I the only one who gets that? (I downloaded the sheet 5 times now and it always give me the same message)

If not:
The sheet breaks down after I let it run SEP calculations without changing anything in the sheet at all. It gives the error message you'd get when you would not have iterative calculations set as instructed in the first page of the sheet (which I have done).

You're not alone. Same problem here. Rest of the sheet really looks great, thanks for your hard work Landsoul!

And to all people having problems with setting talent points: Click in the cell of the talent and write the number of rank in there. It's faster then moving all the picture away

Flukeworld · 09/02/09, 8:47 AM

Seems as common problem people have:
I open the the file, enable macros, I set options->formulas->Maximum iterations:100, Maximum Change:0.000001

I do not change anything, i keep the Landsoul char data, i click "Click to" for SEP calculations => some values, as trinkets, wep enchants and so on get errors (#VALUE!). If i click ti again, all values get errors.

Speeder · 09/02/09, 8:55 AM

Originally Posted by Flukeworld

Seems as common problem people have:
I open the the file, enable macros, I set options->formulas->Maximum iterations:100, Maximum Change:0.000001

I do not change anything, i keep the Landsoul char data, i click "Click to" for SEP calculations => some values, as trinkets, wep enchants and so on get errors (#VALUE!). If i click ti again, all values get errors.

Exactly this is what I am experiencing as well. Hope it will help Landsoul to find and kill bug.

Dragonspear · 09/02/09, 9:01 AM

Under professions I noticed that you did not have engineering listed at all. Not a big worry since you have most of the engineering items in there. One thing you do not have however is the Nitro Boosts enchant which provide 24 Crit rating.

Also like a previous poster mentioned, it won't load my Off-hand Aesir's Edge.

StaxRexx · 09/02/09, 9:02 AM

Problems I've noticed... the gloves bonus isnt showing up on the Fury page. The comparisons for many items seem to be off a tad, some more than others. Trinkets... yah no ideas there... however slot changes that would break tier bonuses seem to be including the previous tier bonus that they would actually break(I could be wrong but that's what it looks like to me). The new etched kirin torn rings are missing.

As always I love the sheet it's still the best and it just keeps getting better.

To: Jarheaded

ArP has been discussed at length around here. Arp has a sort of soft bottom and then is greater than Str until it hits 100%. Using the sheet I swapped out all your +20 str gems and couldnt get even close to 100% so your best option to hit 100% would be to use one of the ArP trinkets Mjolnir Runestone or Grim Toll and then swap out a couple gems. Looking at your gear I'm guessing you could farm up these items in a short period of time or with any luck you have one of them sitting in your bank itching to be used. Replacing Banner of Victory will give the greatest gains.

Jarheaded · 09/02/09, 9:26 AM

Originally Posted by StaxRexx

To: Jarheaded

ArP has been discussed at length around here. Arp has a sort of soft bottom and then is greater than Str until it hits 100%. Using the sheet I swapped out all your +20 str gems and couldnt get even close to 100% so your best option to hit 100% would be to use one of the ArP trinkets Mjolnir Runestone or Grim Toll and then swap out a couple gems. Looking at your gear I'm guessing you could farm up these items in a short period of time or with any luck you have one of them sitting in your bank itching to be used. Replacing Banner of Victory will give the greatest gains.

Appreciate the help Rexx, unfortunately the Loot Gods of Ulduar 10 and Naxx 25 do not want me to get a ArP trinket so I QQ everyday.

So ideally, I get a Mjolnir, sub out BoV and gem 4 +20 ArP gems?