StaxRexx

Try running your Sep with all your gear and just leave the slot empty and see if you can recreate the error without it... I would do further testing myself but I'm attempting to strip some grease stains off of my patio and the patio is winning.

 

Wymorence

It won't let me leave the slot blank since there's no option for that on the trinkets, but with every single trinket I tried (the Runestone, Greatness, Incisor, even went down as low as Tsunami Talisman) the second I kill Windfury and have it calculate the SEP values it shoots the #DIV/0 error up.

 

StaxRexx

I downloaded your gear and sat down looking at mine Mirror was literally the only item that i've had resently that you have now so I'm fresh out of guesses. The next step would be to grab my gear run the sep on settings that breaks the sheet for you and if it doesn't break input your items 1 at a time, run sep if it works save and then move onto the next item... but thats time consuming and gets annoying. I basically did the same thing to track down the windfury issue in the 406 version.

 

Wymorence

I just imported your gear to my spreadsheet copy (you happened to be wearing a fishing pole and red felt hat at the time), and once again the second I killed Windfury it popped up the #DIV/0 error.

 

Ehtheratti

I'm getting "error 429 activex can't create object" when I try to import my Armory. Using a Macbook Pro with the 2003 compatible version of the spreadsheet, and Excel 2004.

 

◊ Cireena

I am getting the same results as Wyrm. Anytime I do not have IV or WF set I get a Div/0. I am using the '07 version curently.

 

• landsoul

So when you take out windfury, and run SEP you get #div/0? or only when you kill windfury regardless of running SEP? Does it happen when you have (none) in a gearslot?

Visit my Youtube Channel for an increasing selection of warrior videos, including Undermanning, PvP, and LK Raids:
http://www.youtube.com/user/LandsoulWoW

 

Shha

My WF works correctly, so it might be something else. On a side note, no matter what setup I use, DMC:G shows as better then Dark Matter (which isnt in top two trinkets). Worth to note though, that with 3.2 loot slowly being visible Dark Matter might gain in value - as it seems that with new inflow of extra stats, Mjolnir Runestone will lose to ArP stacking + no ArP trinket setup.

 

◊ Cireena

I have something in all slots amd yes it is after I run SEP. It hasn't been a huge problem as it is pretty much asured that I will have pne of them so I don't turn it off much, but it does happen if I play around and forget to recheck it.

 

ZorbaTHut

I also get errors constantly, though it's usually #N/A, not #DIV/0. Things that can trigger 'em:

* Mistyping an item or enchant. Go to cloak enchant, type "asd", hit enter. Boom! Now go fix the cloak enchant. It doesn't help, everything is permanently broken.
* Pulling from an armory with an item or enchant the spreadsheet doesn't recognize, such as the Flexweave Underlay I currently have on my cloak. "Zorba/Shattered Halls" if you want to try it out.
* Deleting the contents of a gem. Again, this throws the system into some kind of infinite error state.

I've uploaded a "before" and "after" here. All you have to do to turn "before" into "after" is write "asdf" in the cloak enchant field, then hit "cancel" when it complains. I've tried this both with macros enabled and disabled (since it starts out disabled and I always forget to re-enable it.)

If you go into the "before" sheet, open up Arms, and load Zorba/Shattered Halls, pressing OK when it complains about my cloak enchant, you'll get a #DIV/0 error.

 

• landsoul

About Dark Matter, it's pretty close to DMC:G which really all depends on how much crit you are wearing. If you don't have some of the amazing AGI/Crit pieces then it will beat the Card.

Then there's also the subject of the white crit cap when it is active, which I have failed to consider until now.

Conclusion: While it's a nicely designed trinket, due to sometimes being at the white crit cap with this trinket and some better crit chance gear, some of the proc gets wasted. While it does provide a slight boost over DMC:G at mid to high gear levels, I don't think it's worth rolling/bidding against another class in which the trinket is clearly best in slot. Since the white crit cap also affects other dual-wield physical classes, mainly rogues, it may be worth it to ask them about it if they are gonna roll on it also.

Visit my Youtube Channel for an increasing selection of warrior videos, including Undermanning, PvP, and LK Raids:
http://www.youtube.com/user/LandsoulWoW

 

xavier2k3

One thing with the spreadsheet i've noticed is that you have a piece of gear equipped that the armory can't load such as algalon loot/quest items, the armory import feature will just not work at all rather than importing everything else and leaving that field blank. So you're better off not equipping that piece of gear and importing then adding it manually through the spreadsheet.

 

Ryo Saeba

Regarding the Belt of the Titans, the socket order on the item is red > blue, not blue > red: I just noticed it importing my armory profile and not getting the socket bonus due to misplaced gems

 

Murderizer

I was wondering why Fluxing Energy Coils aren't in the Arms BIS list? They have a considerably higher SEP value than the Decimators.

 

Machinator

I think that BiS slot lists probably should just be handled in the arms or fury threads if at all. There are many ways to get different SEP with different gear sets and it will change every time a fix is made to the sheet or new gear comes out. People that don't realize this will just keep posting different items and lists.

"Information is ammunition."

 

StaxRexx

Mach I'm pretty sure the BiS list is is more of a Best in Game list assuming you have access to those items they would be the ones to push to get. As far as the lists location the only posts in the Fury and Arms threads that would be practical are the first posts and at current they've never been updated and dont contain any data unlike Landsould's first post that's always being updated with information its just easier to have 1 person doing this type of update rather than 2.

Personally I maintain an upgrades list and I use the spreadsheet to get dps change figures for each item on my list and recalculate those numbers each time I get an upgrade. On one side of my sheet I have equipment in groups by slot and then I list them by location/boss. I rearrange the by slot list to show me the best possible item for each slot. If by chance I make it further and something drops that I dont have listed I'll often ask for a second to check in the spreadsheet so I'm not rolling blindly.

 

danyson

@StaxRexx

Best in Game not equal Best in Slot since it does not count setbonuses and as long as there does not exist ilvl 239 item for each of the Set slots Setbonus is for Fury always better than just picking the best item.

 

StaxRexx

That's why I maintain my own list like I said in my post.

 

Machinator

My point was that the lists have little meaning outside of the sheet, which is constantly changing, and generates a lot of posts. The reason I mentioned it was because trying to find or reply to certain things in the thread required me to go over many posts that were unrelated. Its really up to landsoul if he wants to keep up with it, but just wanted to state my opinion that it shouldn't be in this thread.

Back on topic, any chance of other realistic rotations getting added to the sheet?

"Information is ammunition."

 

NobleHelium

The new Armory talent page changes seem to have broken the talents part of the import on the sheet. Or at least it's giving me an error.

 

markabey

[Voldrethar, Dark Blade of Oblivion] has different stats on the sheet, it was upgraded to 130 str (live) from 112 str (sheet).

 

Tentonaxe

how can i tell what rotation the sheet is using? ive searched this thread and haven't been able to come across anything solid. I do see the information on the spreadsheet to the right below the item area outlined in purple noted as Needs formatting, it seems to have information about different priorities but I don't understand it.

To clarify this a bit, Im looking for the priority, as far as BT > WW > Slam, BT > Slam > WW, WW > BT > Slam, etc.

 

IggyMac

I just hought I'd stop by to report a few bugs with the sheet.

#1) It doesn't register "Enchanted Tear" as +6 All Stats gem. It says that it's not recognized, when loading from the Armory.

#2) On the Arms spreadsheet the second (middle) glyph doesn't give a drop down list.

#3) I still get a div by 0 error on the arms spreadsheet sometimes. I haven't figured out what's causing it yet though. I'll get back to you on this one.

 

• landsoul

New fixes for 3.1.3 are up, please look at it where it normally is! The front post.

Visit my Youtube Channel for an increasing selection of warrior videos, including Undermanning, PvP, and LK Raids:
http://www.youtube.com/user/LandsoulWoW

 

Legedi

When do you think you'll include the execute changes in the spreadsheet? Are you going to make new cycles using the new execute for <20% health and just average that into the total DPS, or have some kind of switch that lets you know your DPS at >20% and <20%?

I'm interested to see how much the execute change will actually increase DPS. Testing out the latest update right now.