Warrior DPS Calculation Spreadsheet - Page 19

nomopofomo · 01/28/09, 6: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, 6: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, 6: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, 6: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, 4: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 ?

iwt2001 · 01/29/09, 2:37 PM

Is it possible to request a checkbox for unlimited rage or unlimited heroic strikes for certain fights like sapphiron or thaddius where pretty much every single MH swing will be a heroic strike? It'll be helpful for determining the amount of TPS tanks will have to keep up with as well as seeing how well damage scales with more rage.

Megalith · 01/30/09, 8:49 AM

It's possible to see total hit, which is important to se how much above the hit cap one hoovers. Wouldn't it be possible to show total expertise for the same reason? Now it is some testing back and fourth with gems and gear to nail the cap since one just can see that one is capped, but not how much the overcap is.

A row with buffed stats right above the unbuffed ones would give a better overview. Thanks for a great spreadsheet!

Gotrage · 01/30/09, 9:15 AM

Hey,

I was looking through the replys and find that someone already sugested an upgrade column but it really never got into the spreadsheet. I was thinking about the same thing for some time and was trying to figure out how exactly the SEP sorting works to calculate the best upgrade for a slot.

It just takes the value calculated by the SEP macro and sorts? If so, is there a possibility to make the sorting take in consideration the amount of SEP you lost by removing the piece of gear you are wearing.

For example: I'm wearing some piece of gear that makes me exp capped. SEP macro values exp to 0. If i take off that piece of gear exp should be valued higher and in some cases contribute to ranking an item higher than others during SEP sorting.

Or is this the way the items are already sorted?

MildCorma · 01/30/09, 10:46 AM

Just wondering if anyone else is having trouble getting the spreadsheet downloaded, and if so if there is an alternative location? I've tried changing browsers, but it seems to be an FF issue.

Mordenthal · 01/30/09, 10:59 AM

Is exp bugged? I'm at 125 exp rating, yet exp is valued at 0 on SEP calculations. As far as I know the cap is still 148 with 2/2 WMastery.

Saizul · 01/30/09, 11:04 AM

Originally Posted by Mordenthal

Is exp bugged? I'm at 125 exp rating, yet exp is valued at 0 on SEP calculations. As far as I know the cap is still 148 with 2/2 WMastery.

Any chance your race is set to something with a weapon specialization that would bump you above the cap?

Pogues · 01/30/09, 12:31 PM

Originally Posted by Saizul

Any chance your race is set to something with a weapon specialization that would bump you above the cap?

I am having the same problem with EXP being returned as a zero value while I am still below the cap. I am positive that I turned off the racials because at first it was reporting my EXP as 23. I will doub check when I get home tonight and see if I remove all my EXP gear if it updates the SEP. I am using the current version of the spreadsheet and Excel 2007. All other SEP scores change when the macro is run.

landsoul · 01/30/09, 12:37 PM

A lot of people don't recognize that the default race/settings change sometimes from my own testing and they don't set them back.

About expertise: Basically, if dodge rate says 0%, your SEP for expertise will most obviously be zero... If your unbuffed EXP stat is 18 or greater, then your SEP will be zero...

I try to make it as simple as possible but since its not dummy proof. Maybe I should make a video tutorial?

Ynox · 01/30/09, 1:10 PM

As for the SEP order from Items just enable the Boxes that Hit and Expertise are always worth 1 SEP. Why that? if you are not Exp/Hit capped you change your 16 Strength points into what you need.

16 Strengh is 16 SEP so if you get enough Expertise from gear you are forced to take 16 Strengh gems.
But if you are not capped on Expertise/Hit then you should change your Gems to what you need.

Expertise Cap for Furry Warriors is at:

107 Expertise Rating (5 Expertise Racial)
132 Expertise Rating (3 Expertise Racial)
148 Expertise Rating (No Expertise Racial)

Mightybeast · 01/30/09, 4:03 PM

I do not think you should make this spreadsheet 'dummy proof'. I think if a dummy opens up your spreadsheet (I was a dummy when I did), then the dummy should have to figure it out. It should be part of the learning process, it will give users a better appreciation and understanding for what the spreadsheet actually does. Maybe you could make a readme file or something that gives just the basic explanations so people don't continually have this problem.

I do have a question though, assuming I have enough expertise to get rid of weapon mastery, where should those 2 talent points be going? Enrage? That seems to be the only place that would really add damage to my spec. Even then is it worth it? Shouldn't I just get rid of the expertise and swap out for strength and keep the talent points?