Warrior DPS Calculation Spreadsheet - Page 11

Azhag · 01/23/09, 11:12 AM

Originally Posted by Mace

Landsoul, the items you have selected in the spreadsheet is to show the highest DPS possible?
If so, equiping [Surge Needle Ring] instead of [Ruthlessness] and change 1x 16STR gem to a 16Exp gem gives a slight DPS increase (around 15 with the buffs selected)

I think it's just Landsouls own equipment and not a selection of the best to have.

Originally Posted by bimmy

I get higher DPS from the spreadsheet equipping instead: [Blue Aspect Helm], [Chestguard of the Recluse], [Sinner's Bindings], [Surge Needle Ring] (over [Ruthlessness]) and [Grim Toll] (over [Mirror of Truth]).

The sense of a spreadsheet like this is to find out INDIVIDUALLY which ITEM COMPOSITION is the best to go. Of course there are differences for each character because of the equipment varietes, thats the point of using a spreadsheet and not only a dps item list.

Vitalstatistix · 01/23/09, 11:18 AM

Originally Posted by landsoul

...If you want a different item in any slot you go to Set1 and change what item you wear if its different than what I am wearing...

Pretty sure its his own gear. If he wanted to show highest DPS I'm sure he could do that.

Beardstorm · 01/24/09, 6:11 AM

Got the following error log just bow using Excel 2007 and Vista64. In a nutshell it gives an error message saying "Excel has found unreadable content in this document, would you like to try and repair/recover data?". After accepting it then says: "Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))",

I'm assuming this is what causes the "SEP calc" button to not work in the "repaired" version.

- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error031960_01.xml</logFileName>
<summary>Errors were detected in file "FuryDPS2.302Excel07(3).xlsm"</summary>
- <removedParts summary="Following is a list of removed parts:">
<removedPart>Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))</removedPart>
</removedParts>
</recoveryLog>

edit: Fixed it myself, didn't have VB for Applications installed.
nitpicking: "Girdle of Razuviuos" typo in the gear set drop-down menu.

Armaul · 01/24/09, 5:53 PM

Hi Landsoul, thanks for doing this and good luck with employ!
I downloaded today and I like the new look and ran into a few problems. All of these related to the excel 2003 version:
1. My glorious new 8str/8crit gems are missing (likely other 3.0.8 gems too, maybe you're waiting on confirmation).
2. Runtime error 1004 "This operation requires the merged cells to be identically sized" is caused by clicking the green SEP button (macro). I re-downloaded the file and clicked button from fresh sheet to make sure I didn't screw something up in my personal file before I clicked the SEP button. Iterations and minimum change are set to what you recommend and I have tried opening the sheet with both low security and normal security (clicking Enable Macros. Same result as expected, but figured I should try that).
3. (minor) Initial talents enable Sword Spec, which isn't possible for the 18/53 that is so popular.

You can PM me if there's anything I left out that you need to know. Thanks!

iwt2001 · 01/25/09, 9:14 AM

Fantastic work on the spreadsheet. Is there any chance you could add in execute damage/dps? This would of course include the value of the execute glyph and the value of improved execute. It would help to see when you should execute (I don't believe the skill itself scales very well), where its priorities lie, as well as seeing if Imp execute is worth a point or two.

xtreat · 01/25/09, 9:50 AM

When I try to calculate SEP on the newest SS I get runtime error 2004. I am sure it has something to do with my macros security settings or my options but i don't know exactly what i am supposed to change. I don't quite understand the directions on the main page. Little help please.

• landsoul · 01/25/09, 3:19 PM

It's purely due to an error in the macro for '97. I'm trying to get this fixed.

Yes I am adding Execute values into the mix a little at a time.

Ynox · 01/25/09, 7:56 PM

2. Runtime error 1004 "This operation requires the merged cells to be identically sized"

the merged cells are perfectly identical but does not work.

until Landsoul got a proper Solution just demerge the Zells Z41 and AM29-AM44 hit SEP 2x then it worked for me

Krogg · 01/26/09, 3:49 AM

There seems to be some odd issues with expertise. When I am at the expertise cap without talents and select 0 for Weapon Mastery, my DPS goes up by a couple hundred, though I would expect it to stay the same. Also, depending on which gem I choose to change to expertise/stam, it will either increase my DPS by 5-10, as expected, or decrease it by 200 or more. Further, if I change my Valorous Dreadnaught Battleplate blue slot from 6 exp/9 stam to 7 exp/11 stam, I drop by 234 DPS.

I have been playing with various combinations of gemming and talents that would put me right at the expertise cap, or just below, and it has been extremely inconsistent. It's something you may care to look into. I don't believe I have changed anything except the gear, gems, racial expertise, and the one talent Weapon Mastery.

• landsoul · 01/26/09, 1:31 PM

Krogg, I'm going to need to see a screenshot. I can't reproduce the error with your description. Screenshot me or give me more details.

vredz · 01/26/09, 4:46 PM

First i got errors telling me macros was disabled, i think I enabled them and now Im getting this error,any solutions?

king_darius · 01/26/09, 5:26 PM

landsoul, your work on the spreadsheet is appreciated. One thing I noticed today in the latest version is that the [Charged Titanium Specs] are set with a Blue socket on the lookup page.

Gurlock · 01/27/09, 2:38 AM

...and of course as soon as I post my question I find my answer in the spreadsheet.

In other news, thanks Landsoul, I've been using your stuff for quite a while. Keep it up.

• landsoul · 01/27/09, 2:51 PM

Sent an update in. Please check the '97 SEP macro now.

nomopofomo · 01/27/09, 6:27 PM

there's a bug with the spreadsheet where when the race is set to orc, and you change to another race, the expertise bonus won't go away

edit: okay i see you can change mh/oh expertise bonus but it's still a little bit confusing. maybe you shouldn't use orc as the starting race?

edit2: and even though i've changed that the spreadsheet still seems to think i'm exp capped because after i recalculate the SEP, even with 12 expertise, it's still showing 0 SEP

edit3: i've been thinking it would be nice to be able to leave a gear slot blank so that we can more easily determine upgrades in the lookup chart

edit4: also appears skinning is broke

Daeid · 01/28/09, 9:32 AM

I noticed an issue with the racial expertise bonuses the other day, too (I'm not that great with Excel, so please bear with me):
(Cell AH39, '97 Version)

 =IF((AH38-0.0025*(AE24+2*AL14+AR11+INT((R136+C52+IF(A30="Food: EXP",C30,0))/AL55))-AO12/100)<0,0,(AH38-0.0025*(3*AE24+2*AL14+AR11+INT((R136+C52+IF(A30="EXP",C30,0))/AL55))-AO12/100))

The above calculates the dodge chance remaining on the main hand, setting the value to zero if someone is over the cap. Everything works correctly if the person using the sheet is over the cap, or is not benefiting from the bonus.

The second half of the formula recalculates the dodge chance if someone is under the expertise cap. The problem with this is that it seems to multiply the racial expertise bonus by 3 when this happens. If someone has an expertise rating of 17 - including the racial bonus (and assuming points in Weapon Mastery) - because the expertise isn't quite capped it will recalculate and return a rating of 23, which gives a negative dodge chance value and distorts the SEP rating.

I found removing the section highlighted in red in the formula made things work properly. The off-hand formula has the same problem.

Alexsiss · 01/28/09, 1:23 PM

Btw in the default gear set you have 2pc t7 turned on when you actually aren't wearing 2pc. Just informing in case someone is wondering why numbers were so high.

Edit: Also Heroic presence is turned on by default for orc

• landsoul · 01/28/09, 1:36 PM

If you are going to report an error, please make sure you have downloaded the latest version. Reporting errors tha happened a week ago that's already been fixed is getting really damn old and annoying.

Yeah oops I put 2t7 in default gear when its only wearing 1 piece.

Kaoz · 01/28/09, 5:40 PM

Originally Posted by landsoul

If you are going to report an error, please make sure you have downloaded the latest version. Reporting errors tha happened a week ago that's already been fixed is getting really damn old and annoying.

Yeah oops I put 2t7 in default gear when its only wearing 1 piece.

Your setup is pretty optimal. Your only hard choice is 2pc T7 (Shoulders + Legs) with your current setup or go Obsidian helm and Legs of the honored. I think both nearly break even.

Btw you have racial expertise on too.

Ynox · 01/28/09, 6:40 PM

I think Landsoul himself knows how he could calculate his best gear aviable.
Everyone else who is posting about the "Best" gear here or what buffs are inconsistent like orc as race and heroic presence or what ever is just flooding this thread and therefore he leaves the ones who want to help Landsoul with solutions, reading 20 Posts for nothing but stupidity.
Everyone who wants to use this great sheet should take his time to get the Cells where to activate the buffs he has in raid, his race, his racial expertise, his food buffs an so on, don't post about something is not possible, there are thousands of Warriors out there and there will only be a handfull of warriors who wont need to change anything if Landsoul updates a possible configuration.

So just take your time and use it for your issues, as long as you dont find solutions to bugs or find wrong calculations, dont spam this thread, this thread is not about the usage or best gear in the sheet it is about making the sheet better.

So again take you time to understand how you can adjust the sheet for your individual issues, Landsoul knows how to do for him.
And report Bugs or wrong Formulas, if you find them. But before you do it read the last 2 Pages maybe someone else got the same problem and someone has a fast Solution in here already.

Thanks Landsoul for your GREAT work and it is amazing how awesome excel can look like.

nomopofomo · 01/28/09, 7:07 PM

Originally Posted by landsoul

If you are going to report an error, please make sure you have downloaded the latest version. Reporting errors tha happened a week ago that's already been fixed is getting really damn old and annoying.

Yeah oops I put 2t7 in default gear when its only wearing 1 piece.

not sure if you're talking to me but i'm talking about the LATEST version

• landsoul · 01/28/09, 7:16 PM

=IF((AH38-0.0025*(AE24+2*AL14+AR11+INT((R136+C52+IF(A30="Food: EXP",C30,0))/AL62))-AO13/100)<0,0,(AH38-0.0025*(AE24+2*AL14+AR11+INT((R136+C52+IF(A30="Food: EXP",C30,0))/AL62))-AO13/100))

=IF((AH38-0.0025*(AE25+2*AL14+AR11+INT((R136+C52+IF(A30="Food: EXP",C30,0))/AL62))-AO13/100)<0,0,(AH38-0.0025*(AE25+2*AL14+AR11+INT((R136+C52+IF(A30="Food: EXP",C30,0))/AL62))-AO13/100))

There's not a single 3 here. I'm not sure what version you have. Anyone know if 2.303 fixed the excel97 SEP macro

Ynox · 01/28/09, 7:22 PM

Nomoprofomo thanks for the next spam did help really well, sorry about my spam my self on this.

To make the post valid again:

Landsoul i suggest you use Bold Size 6 Text to signalize updates.

NobleHelium · 01/28/09, 7:52 PM

Originally Posted by Ariakis_Uther

I fixed the runtime error in 2003 and I'm looking a little further into making it faster.

To fix the error select AM29:AN29 through AM44:AN44 and click format cells, make sure the merge cells checkbox is unchecked and then select "Center Across Selection" in the Horizontal text alignment drop down box. Click OK and your SEP should calculate.

Landsoul, the newest version of the spreadsheet fixes the .xls SEP macro error, but this alternative solution posted earlier also fixes it. If you can, I'd suggest using this solution in the next version because right now the numbers aren't visible due to the cell size being too small, although the macro definitely works.

NinJOu · 01/29/09, 5:57 AM

Hey Land,

I got something for you :

I'm an orc, got 2 Death's Bite and 2 points in Weapon Mastery.

I should have 13 EXP from stuff to get dodge capped. But in your xls, while i'm 13 EXP, i got still some % dodge from both hands on bosses.
However, when i recalc SEP values, EXP gives me 0.

Is it intended ?