Warrior DPS Calculation Spreadsheet - Page 113

Kamero · 09/14/09, 1:40 PM

Page: Arms

Error Type: Calculation

when I gain the 4 piece set bonus for t8 it makes me lose dps. Even if I didn't have an item in the slot equipped before in that slot putting the fourth piece on results in losing dps. I just seems to me that the t8 set bonus 4 piece is resulting in a dps loss for no reason.

Swamplord · 09/14/09, 2:11 PM

Originally Posted by Kamero

Page: Arms

Error Type: Calculation

when I gain the 4 piece set bonus for t8 it makes me lose dps. Even if I didn't have an item in the slot equipped before in that slot putting the fourth piece on results in losing dps. I just seems to me that the t8 set bonus 4 piece is resulting in a dps loss for no reason.

I can confirm this. I made a set with only the 2 piece bonus, then manually set the cell with the 4pT8 flag to 1. This resulted in a ~300 dps loss.

Shuichi · 09/14/09, 2:28 PM

Page: Lookup
Error: Calculation (I think)

All 3 armor pen proc trinkets (Mjolnir Runestone, Grim Toll, Incisor Fragment) are reporting negative ProcSEP values, making them seem worthless in comparison to many other trinkets.
Let me know if I am just mistaken though.

Edit: This is with version 2.501 of the spreadsheet

foopeemoa · 09/14/09, 3:10 PM

(false assumption about stacking trinkets deleted)

Good to know that the trinkets stack, I had read previously that the rings didn't, but that info must've been bogus.

landsoul · 09/14/09, 3:11 PM

Check the update see if it works better for you.

deathblow · 09/14/09, 3:34 PM

Originally Posted by foopeemoa

I thought Death's Verdict shared its Unique attribute among both versions, therefore you could not equip the 245 and 258 versions simultaneously as shown in the BiS List on the first page of this thread. At least the rings seem to be that way, so I assume it would apply to trinkets.

http://img21.imageshack.us/img21/9683/dualproc.jpg

Shuichi · 09/14/09, 3:35 PM

I read lots of reports of people using both normal and heroic versions of at least the trinkets, and possibly rings, which is why I assume the BoS list changed.

Wisey · 09/14/09, 5:22 PM

First of all, spreadsheet is ace thanks for all the hard work writing it.

Page: LOOKUP / ARMS, FURY
Error Type: REFERENCE
Some Horde names not changing properly (only noticed thse two)

Ring - Carnivorous Band --> Gormok's Band (normal version only, worked ok in 500 but not 501) FP14 in LOOKUP

Trinket - Victor's Call --> Vengeance of the Forsaken for horde (normal and heroic version)
from what I can tell in the trinket the lookup is right, but in the ARMS/FURY pages cell T210 & T211 are not showing the right text

callion · 09/14/09, 6:43 PM

Still getting unreadable content bug, I cannot believe I'm the only one with this problem?

Galthra · 09/14/09, 8:06 PM

Page: LOOKUP
Error Type: TYPO

Marrowstrike is still displaying its previous ilvl213 stats and missing yellow socket and socket bonus

i know you fixed the ToC armor but you may have missed the weapons

akane · 09/14/09, 8:21 PM

First of all , thanks for your work and effort.
Im trying to get the sheet to work, but always get some error.
Imageshack - sheeterror
I dont know if its somekind of options problem, always used excel 97 and never had any kind of problem.
What could be causing this?

Thorhammar · 09/15/09, 12:03 AM

Hi all!
First of all, thanks landsoul for your work!

I've downloaded the 501 version of the spreadsheet and first time I've used it the armory import option and worked, the second time failed, throwing an error message and also when I've did my gear setup manually when trying to get the sep values all the cells appeared as #VALOR! I tried some of the fixes posted previously on the thread but I'm still getting that :S

Any clues about how to solve it?

Thanks a lot!

galvin · 09/15/09, 2:06 AM

Sheet Version 2.501

When downloading Armory.
Error: Gormok's Band is not a supported ring 1 please use custom gear for it.

This is the heroic version which is already in the lookup.

Jordybe · 09/15/09, 2:25 AM

Im a alliance and can't get to find:
[Legplates of the Silver Hand]
or
[Legplates of Redeemed Blood]
Don't know which one is an alliance version.

Scyne · 09/15/09, 2:54 AM

Originally Posted by Jordybe

Im a alliance and can't get to find:
[Legplates of the Silver Hand]
or
[Legplates of Redeemed Blood]
Don't know which one is an alliance version.

Legplates of the Silver Hand is the Alliance version.

Legplates of Redeemed Blood is the non-heroic version of the Horde legs.

The Heroic version of the Horde legs is called Legplates of Redeemed Blood Knight.

In the sheet, both the the non-heroic and heroic is called Legplates of Redeemed Blood Knight, giving an error when importing a character with the non-heroic version of the legs. I do not have any trouble finding them manually though.