Warrior DPS Calculation Spreadsheet - Page 71

Dragonspear · 09/22/09, 5:42 PM

I was trying today to find some place in the arms spreadsheet to update the Swordspec proc chance to compensate for the new change and I could not manage to find it. If someone would be kind enough to point me in the right direction so I can double check some things, it would be much appreciated.

Fedelis · 09/22/09, 6:29 PM

Originally Posted by Dragonspear

I was trying today to find some place in the arms spreadsheet to update the Swordspec proc chance to compensate for the new change and I could not manage to find it. If someone would be kind enough to point me in the right direction so I can double check some things, it would be much appreciated.

There's a few cells that need modifying. Hit CTRL+F and search for

"Sword",0.01*AO15

every time you find it change the 0.01 to 0.02

Also search for

AO15/100

and change it to AO15/50

brewskay · 09/22/09, 7:43 PM

Was wondering if there was a way to change the armor penetration rating on the spreadsheet to make it possible to check with the new ArP nerf.

Rauch · 09/22/09, 7:56 PM

Adjusting for the new ARP conversion rate was addressed a few weeks ago here in this thread:

Warrior DPS Calculation Spreadsheet

hungrymoo · 09/22/09, 8:59 PM

Ok I checked the link u posted but there isn't a real answer, so let's solve this problem once for all:

ArP Nerf is live, on the first page of this Thread we have a BiS List provided by Landsoul (ty m8 u are gr8

,
The question is:

We have better result using ArP gems or STR gems with the items provided in that list?

Plz give a separete answer for fury and for arms spec (to avoid any possbile trubble).

Tnx to all

xtreat · 09/22/09, 9:32 PM

The thread he linked you to is the thread you are posting in. That's because the answer on how to change the ss to accommodate the live patch is in this thread. Once you have changed the ss, then you can use it to determine for yourself what would be best to gem for.

Fedelis · 09/22/09, 11:11 PM

Originally Posted by hungrymoo

Ok I checked the link u posted but there isn't a real answer, so let's solve this problem once for all:

ArP Nerf is live, on the first page of this Thread we have a BiS List provided by Landsoul (ty m8 u are gr8

,
The question is:

We have better result using ArP gems or STR gems with the items provided in that list?

Plz give a separete answer for fury and for arms spec (to avoid any possbile trubble).

Tnx to all

Change cell E86 to read

=4.69512177*((82/52)*(131/63)^((AI1-70)/10))/1.1

Edit: I'm wondering with this spreadsheet, why is expertise undervalued as arms? If I set it up so I have 60 exp under cap it still doesn't value EXP very high. 2.4 had expertise valued much higher when under softcap. Anyone know if these values are true and I really don't need expertise, or is it a bug?

Galthra · 09/23/09, 2:29 AM

Page: LOOKUP
Error Type: TYPO

For Horde: Dual-Blade Butcher should have 147 strength and not 144

Jordybe · 09/23/09, 3:12 AM

Originally Posted by Fedelis

There's a few cells that need modifying. Hit CTRL+F and search for

"Sword",0.01*AO15

every time you find it change the 0.01 to 0.02

Im in the EU and Can't find this.
First thing that I found was:

=MAX(MIN(0,5;((1/X55+ALS(ALS(ISNB(VERT.ZOEKEN(C16;MainLookup;15;ONWAAR));0;VERT.ZOEKEN(C16;MainLookup;15;ONWAAR))="Sword";ALS(AO15=0;0;1/(6+1/(AO15/100*Y174)));0))*(Y59*AE57+AE58*(1-F52-F56-Y59)+F56*AE61)-AE69-AE70-AE71-AE72-AE74)/(15-AO4-AR15+AI57)*X55/2)+J34/AC52-W73;0)

How must I change it then??

Also search for

AO15/100

and change it to AO15/50

I can find this in the EU.

Originally Posted by Fedelis

Change cell E86 to read
Edit: I'm wondering with this spreadsheet, why is expertise undervalued as arms? If I set it up so I have 60 exp under cap it still doesn't value EXP very high. 2.4 had expertise valued much higher when under softcap. Anyone know if these values are true and I really don't need expertise, or is it a bug?

Originally Posted by landsoul

I'll repeat again as it's already been said. For arms, overpower is a good portion of your damage and is not affected by expertise at all. In fact when you dodge, you can recover some of that damage by replacing a weaker ability with a non-TFB overpower, which is on average the strongest strike in the Arms arsenal. This further reduces the penalty of not having enough expertise.

Kurtov · 09/23/09, 4:23 AM

The proc chance for Sword Spec isn't the only thing that changed. It's not in the patch notes, but if you check logs from pre 3.2.2 and post patch, the extra swings from sword spec no longer glance. Who knows if it still grants rage based on the white dmg formula, or we're back to the very brief 2.1 period where it was yellow dmg and rage granted was only based on swing speed.

I don't even have Excel '07 so I can't check, but it's probably a bit more difficult than changing the proc rate. I also don't know if the spreadsheet has the internal CD, but it's even more important now that the proc rate is doubled.

Fedelis · 09/23/09, 5:22 AM

Originally Posted by Jordybe

Im in the EU and Can't find this.
First thing that I found was:

=MAX(MIN(0,5;((1/X55+ALS(ALS(ISNB(VERT.ZOEKEN(C16;MainLookup;15;ONWAAR));0;VERT.ZOEKEN(C16;MainLookup;15;ONWAAR))="Sword";ALS(AO15=0;0;1/(6+1/(AO15/100*Y174)));0))*(Y59*AE57+AE58*(1-F52-F56-Y59)+F56*AE61)-AE69-AE70-AE71-AE72-AE74)/(15-AO4-AR15+AI57)*X55/2)+J34/AC52-W73;0)

How must I change it then??

Change that cell to read

=MAX(MIN(0,5;((1/X55+ALS(ALS(ISNB(VERT.ZOEKEN(C16;MainLookup;15;ONWAAR));0;VERT.ZOEKEN(C16;MainLookup;15;ONWAAR))="Sword";ALS(AO15=0;0;1/(6+1/(AO15/50*Y174)));0))*(Y59*AE57+AE58*(1-F52-F56-Y59)+F56*AE61)-AE69-AE70-AE71-AE72-AE74)/(15-AO4-AR15+AI57)*X55/2)+J34/AC52-W73;0)

I believe.

Dairack · 09/23/09, 6:37 AM

Originally Posted by Fedelis

Change cell E86 to read

=4.69512177*((82/52)*(131/63)^((AI1-70)/10))/1.1

Edit: I'm wondering with this spreadsheet, why is expertise undervalued as arms? If I set it up so I have 60 exp under cap it still doesn't value EXP very high. 2.4 had expertise valued much higher when under softcap. Anyone know if these values are true and I really don't need expertise, or is it a bug?

I would imagine it has to do with how Overpower works.

EDIT: I look up again and see that what I said here is pretty much redundant, I fail.

Hellstromen · 09/23/09, 6:47 AM

Originally Posted by Goatsey

Go to cell E86, the armor penetration rating required for 1% cell. Simply change the 1.25 at the end for 1.1.

Basically the cell reads before:

=4.69512177*((82/52)*(131/63)^((AI1-70)/10))/1.25

and after the change:

=4.69512177*((82/52)*(131/63)^((AI1-70)/10))/1.1

Since iam not too pro at Exel stuff i would apriciate alot if someone please could help me to fix the Arp issue with the new patch. id love a "How to do for stupid people!" since that don't tell me much basicly!

And there is still a problem when i import my armory profile using Carnavarious band, it says "carnivarious band is not a suported ring 2"

Fedelis · 09/23/09, 8:06 AM

Originally Posted by angeldd

How i can activeted SEP console, cose when i click on it give me a mesage "Cannot run the macro 'Warriordps2.501Excel07.xlsm!SEP'.The macro may not be available in this workbook or all marcos may be disabled."Tnx.

I'm going to start by asking... do you have macros enabled?

Jordybe · 09/23/09, 8:32 AM

Originally Posted by Hellstromen

Since iam not too pro at Exel stuff i would apriciate alot if someone please could help me to fix the Arp issue with the new patch. id love a "How to do for stupid people!" since that don't tell me much basicly!

Open up the spreadsheet.
Go to the appropriate Cell E86.
Then in the aboven bar is that line of text. At the and there is 1.25 change it in 1.1
If you are in the EU it is 1,25 change it to 1,1

angeldd · 09/23/09, 8:43 AM

Originally Posted by Fedelis

I'm going to start by asking... do you have macros enabled?

Yes enabled them but now cant see a dps value.Maybe i do somthing wrong pls tell me i'm not that good with exel or any other office programs.

Bushidou · 09/23/09, 9:41 AM

Page: LOOKUP
Error Type: TYPO

Drape of the Faceless General now has 53 agi 55 stam instead of 69 agi 31 stam.

Console · 09/23/09, 10:27 AM

Originally Posted by Flukeworld

I get EU armory just fine, check later (as it gets down occasionaly) or you are behind firewall/proxy.
As for the second, most of the people get errors there (anyone manage to get them work?)

I've managed to change the macros slightly in-order to get them to work via a corporate proxy server. Here is the code before and after for the GetDataXLS() function.

Before:

Function GetDataXLS(url, searchterm)
    Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.3.0")
    objXMLHTTP.Open "GET", url, False
    objXMLHTTP.SetRequestHeader "User-Agent", "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-GB; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4"
    objXMLHTTP.SetRequestHeader "Content-Type", "text/xml"
    objXMLHTTP.SetRequestHeader "Accept-Language", "en"
    objXMLHTTP.Send ""
    Set xmlPG = objXMLHTTP.responseXML  'Get the XML in xmlPg
    If xmlPG Is Nothing Or xmlPG.DocumentElement Is Nothing Then
        Set GetDataXLS = Nothing
    Else
        Set GetDataXLS = xmlPG.DocumentElement.SelectNodes(searchterm)
    End If
    Set objXMLHTTP = Nothing
    Set xmlPG = Nothing
End Function

After:

Function GetDataXLS(url, searchterm)
    Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.6.0")
    objXMLHTTP.Open "GET", url, False
    objXMLHTTP.setProxy 2, "XXXXXXXX"
    objXMLHTTP.SetRequestHeader "User-Agent", "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-GB; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4"
    objXMLHTTP.SetRequestHeader "Content-Type", "text/xml"
    objXMLHTTP.SetRequestHeader "Accept-Language", "en"
    objXMLHTTP.Send ""
    Set xmlPG = objXMLHTTP.responseXML  'Get the XML in xmlPg
    If xmlPG Is Nothing Or xmlPG.DocumentElement Is Nothing Then
        Set GetDataXLS = Nothing
    Else
        Set GetDataXLS = xmlPG.DocumentElement.SelectNodes(searchterm)
    End If
    Set objXMLHTTP = Nothing
    Set xmlPG = Nothing
End Function

All that changes is the version of MSXML from version 3 to version 6 (look in system32 folder for a file called msxml6.dll if you're not sure if you have it installed) and the addition of the setProxy statement. Just replace the "XXXXXXXX" with the name of your proxy server.

If your proxy server uses basic authentication (prompts you for a username and password everytime you connect to the internet) you may need to specify a username and password, this is shown in the code below:

Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.6.0")
    objXMLHTTP.Open "GET", url, False
    objXMLHTTP.setProxy 2, "XXXXXXXXXXX"
    objXMLHTTP.setProxyCredentials "USERNAME", "PASSWORD"
    objXMLHTTP.SetRequestHeader "User-Agent", "Mozilla/5.0 (Windows; U; Windows NT 5.0; en-GB; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4"
    objXMLHTTP.SetRequestHeader "Content-Type", "text/xml"
    objXMLHTTP.SetRequestHeader "Accept-Language", "en"
    objXMLHTTP.Send ""
    Set xmlPG = objXMLHTTP.responseXML  'Get the XML in xmlPg
    If xmlPG Is Nothing Or xmlPG.DocumentElement Is Nothing Then
        Set GetDataXLS = Nothing
    Else
        Set GetDataXLS = xmlPG.DocumentElement.SelectNodes(searchterm)
    End If
    Set objXMLHTTP = Nothing
    Set xmlPG = Nothing

Just change USERNAME and PASSWORD with your credentials.

Source: setProxy Method (ServerXMLHTTP/IServerXMLHTTPRequest)

Download location for MSXML6.0 (1.5mb): Download details: Microsoft Core XML Services (MSXML) 6.0

Coeus · 09/23/09, 1:04 PM

Page: Lookup
Type: Typo
The armor value for Wrynn's/Hellscream's Battleplate of Conquest is listed as 2348, but it should be 2369.

landsoul · 09/23/09, 1:14 PM

keep the 3.2.2 item changes coming, please. I'd like to get most of them in before an update if I missed any. Probably put the update up tomorrow. In the meantime just mod your sheet according to the previous threads' suggestions.

dageny · 09/23/09, 2:31 PM

Fury tab: when I change my T8 2pc bonus from "1" to a "0" (in other words, i did not change any gear) i would have expected a decrease in dps. Instead the dps number did not change at all......

Sprockette · 09/23/09, 2:42 PM

I've seen a few people say that the T8 4 piece bonus was bugged. It appears that one is fixed in this version but the 2 piece bonus doesn't do anything at all. Is there a way I can change this manually?

<edit> I see I'm not alone on that one.

Slamfist · 09/23/09, 2:47 PM

In the patch notes it says "The amount of armor penetration gained per point of this rating has been reduced by 12%."
Does this mean that the value in E86 should be changed from 1.25 to 1.13, instead of 1.1?

Bushidou · 09/23/09, 3:06 PM

Page: lookup
Error Type: typo

Twirling Blades now provide 28 stamina instead of 25.

nomopofomo · 09/23/09, 3:07 PM

Originally Posted by Slamfist

In the patch notes it says "The amount of armor penetration gained per point of this rating has been reduced by 12%."
Does this mean that the value in E86 should be changed from 1.25 to 1.13, instead of 1.1?

No, 12% of 1.25 is 0.15.