Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Warriors

Closed Thread
 
LinkBack Thread Tools
Old 06/26/09, 6:21 PM   #1226
StaxRexx
Glass Joe
 
StaxRexx's Avatar
 
Night Elf Warrior
 
Rexxar
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.

Offline
Old 06/26/09, 7:25 PM   #1227
Wymorence
Glass Joe
 
Human Warrior
 
Norgannon
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.

Offline
Old 06/26/09, 8:06 PM   #1228
StaxRexx
Glass Joe
 
StaxRexx's Avatar
 
Night Elf Warrior
 
Rexxar
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.

Offline
Old 06/26/09, 8:34 PM   #1229
Wymorence
Glass Joe
 
Human Warrior
 
Norgannon
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.

Offline
Old 06/27/09, 8:59 PM   #1230
Ehtheratti
Glass Joe
 
Night Elf Warrior
 
Kel'Thuzad
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.

Offline
Old 06/27/09, 9:33 PM   #1231
Cireena
is about to die
 
Cireena's Avatar
 
Orc Death Knight
 
Mal'Ganis
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.

Originally Posted by Zyla View Post
Plus, my anus is painfree and still virginal!
Originally Posted by madsushi View Post
Honestly, if you're any good, then you know about the changes as soon as they happen and you adjust. If you're not any good, Blacksen's already benched you by now, and so who cares.

Offline
Old 06/28/09, 4:07 AM   #1232
landsoul
Myrmidon Champion
 
landsoul's Avatar
 
Worgen Warrior
 
Alterac Mountains
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?

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

Offline
Old 06/28/09, 8:18 AM   #1233
Shha
King Hippo
 
Night Elf Warrior
 
Scilla
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.

Offline
Old 06/28/09, 3:41 PM   #1234
Cireena
is about to die
 
Cireena's Avatar
 
Orc Death Knight
 
Mal'Ganis
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.

Originally Posted by Zyla View Post
Plus, my anus is painfree and still virginal!
Originally Posted by madsushi View Post
Honestly, if you're any good, then you know about the changes as soon as they happen and you adjust. If you're not any good, Blacksen's already benched you by now, and so who cares.

Offline
Old 06/28/09, 4:19 PM   #1235
ZorbaTHut
Von Kaiser
 
ZorbaTHut's Avatar
 
Troll Warrior
 
Mal'Ganis
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.

Offline
Old 06/29/09, 1:24 AM   #1236
landsoul
Myrmidon Champion
 
landsoul's Avatar
 
Worgen Warrior
 
Alterac Mountains
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.

Last edited by landsoul : 06/29/09 at 1:57 AM.

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

Offline
Old 06/29/09, 7:52 AM   #1237
xavier2k3
Von Kaiser
 
Human Warrior
 
Kor'gall (EU)
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.

Offline
Old 06/30/09, 9:34 AM   #1238
Ryo Saeba
Glass Joe
 
Tauren Warrior
 
Darkspear (EU)
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

Offline
Old 06/30/09, 7:41 PM   #1239
Murderizer
Von Kaiser
 
Orc Warrior
 
Kel'Thuzad
I was wondering why Fluxing Energy Coils aren't in the Arms BIS list? They have a considerably higher SEP value than the Decimators.

Offline
Old 07/01/09, 12:53 AM   #1240
Machinator
Don Flamenco
 
Troll Warrior
 
Aggramar
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."

Offline
Old 07/02/09, 4:34 PM   #1241
StaxRexx
Glass Joe
 
StaxRexx's Avatar
 
Night Elf Warrior
 
Rexxar
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.

Offline
Old 07/03/09, 3:53 AM   #1242
danyson
Glass Joe
 
Orc Warrior
 
Madmortem (EU)
@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.

Offline
Old 07/03/09, 5:38 AM   #1243
StaxRexx
Glass Joe
 
StaxRexx's Avatar
 
Night Elf Warrior
 
Rexxar
That's why I maintain my own list like I said in my post.

Offline
Old 07/03/09, 3:36 PM   #1244
Machinator
Don Flamenco
 
Troll Warrior
 
Aggramar
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."

Offline
Old 07/06/09, 3:58 AM   #1245
NobleHelium
Von Kaiser
 
Night Elf Warrior
 
Uther
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.

Offline
Old 07/06/09, 8:37 PM   #1246
markabey
Glass Joe
 
Orc Warrior
 
Frostwhisper (EU)
[Voldrethar, Dark Blade of Oblivion] has different stats on the sheet, it was upgraded to 130 str (live) from 112 str (sheet).

Offline
Old 07/07/09, 1:21 PM   #1247
Tentonaxe
Glass Joe
 
Orc Warrior
 
Frostmane
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.

Last edited by Tentonaxe : 07/07/09 at 1:56 PM. Reason: clarification

Offline
Old 07/07/09, 2:10 PM   #1248
IggyMac
Glass Joe
 
Tauren Warrior
 
Eldre'Thalas
Bug Report

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.

Offline
Old 07/08/09, 8:30 AM   #1249
landsoul
Myrmidon Champion
 
landsoul's Avatar
 
Worgen Warrior
 
Alterac Mountains
New fixes for 3.1.3 are up, please look at it where it normally is! The front post.

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

Offline
Old 07/08/09, 9:05 AM   #1250
Legedi
Von Kaiser
 
Human Warrior
 
Stormrage
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.

Offline
Closed Thread

Go Back   Elitist Jerks » Warriors

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mongoose calculation or simulation? sag_ich_nicht Public Discussion 1 08/05/08 10:59 AM
[Rogue] Backstab damage calculation Karmon Class Mechanics 5 11/04/07 6:22 PM
Range Calculation Nite_Moogle Theorycrafting Think Tank 0 09/21/07 1:02 PM
Ilvl calculation Drauk Public Discussion 9 03/24/06 5:30 PM