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
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.
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.
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!
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.
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.
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?
Last edited by constantius : 02/06/09 at 10:02 AM.
Reason: Back-to-back posts.