[top]Y67*1/X55+IF(IF(ISNA(VLOOKUP(C16,MainLookup,15,FALSE)),0,VLOOKUP(C16,MainLookup,15,FALSE))

IggyMac · 09/02/09, 3:12 PM

Originally Posted by Moozhe

I'm noticing the same thing as earle117. I'm below the Expertise cap but the SEP is only 0.24.

Are we talking about the arms sheet or the fury sheet? I tried the fury sheet last night and it looked to be about right.

StaxRexx · 09/02/09, 3:20 PM

Originally Posted by Jarheaded

Appreciate the help Rexx, unfortunately the Loot Gods of Ulduar 10 and Naxx 25 do not want me to get a ArP trinket so I QQ everyday.

So ideally, I get a Mjolnir, sub out BoV and gem 4 +20 ArP gems?

I think it was less than 4 when I looked. When I tried to fetch your gear just now it was popping up prot gear so I can't double check. Mainly in the SeP chart get the "from ArP" number as close to 0 as possible, the same goes for expertise after that the usual stregth stacking applies. If either of those numbers goes negative by more than 10 you can probably gain more DpS by switching to a Strength Gem or if its a yellow socket even a crit gem if it'll get you a noteworthy bonus(ArP,Str,Crit). The main thing is play with the sheet before changing your gems to see what goes up and doesn't.

halton · 09/02/09, 3:56 PM

Has anyone adapted the new spreadsheet to take the upcoming sword spec change into consideration? I made a change in the old one but I'm having trouble figuring out how to alter this one similarly. Just about the only place I can find cell a015 (sword spec cell) referenced is y68:

[top]Y67*1/X55+IF(IF(ISNA(VLOOKUP(C16,MainLookup,15,FALSE)),0,VLOOKUP(C16,MainLookup,15,FALSE))

"Sword",IF(AO15=0,0,1/(6+1/(AO15/100*Y174))),0)

Megalith · 09/02/09, 4:02 PM

In the talent trees. Should one be able to change the talent points there or are they static and set for the best build? If one for example would like to switch from poleaxe to sword specc. Right now i can't seem to interact with them.

Mordenthal · 09/02/09, 4:16 PM

Originally Posted by Megalith

In the talent trees. Should one be able to change the talent points there or are they static and set for the best build? If one for example would like to switch from poleaxe to sword specc. Right now i can't seem to interact with them.

As it is now, you'll have to move the pictures to select the talents. Had some headache with that aswell.

Shundroth · 09/02/09, 4:31 PM

Page: Fury, Arms
Type: Format
The "Fetch Armory" text is showing up in the 3rd belt socket area, and clicking it causes an Armory lookup.

Machinator · 09/02/09, 6:36 PM

Good job on the sheet. I especially like seeing all the calculations and rotation clean and expanded and that the rotation doesn't have static times for swings.

Minor issues:
-Rating Cap for Exp showed I was 0 from cap with 213 rating, but the hit table was showing .004% dodge still.
-You might want to specify the ArP cap changes with trinkets.
-Nitro Boosts do not work from armory import and are 24 crit, sheet has 16.
-The arp trinkets have low value on the lookup sheet, probably just due to how arp is calculated.

Questions:
-It looks like execute is on the sheet but not completed/working yet, correct?
-Could you explain the rage slip calculations please?

callion · 09/02/09, 8:06 PM

Originally Posted by Valisen

I am getting an "Excel found unreadable content" error when trying to open the file with Excel 07. Then it asks if I want to recover the contents of this workbook. If I hit "yes" it opens the spreadsheet but no macros work. I am a complete noob at Excel any help or ideas would be great.

EDIT: Trip to windows update fixed my problem >.<

Got the same problem, updated windows but still can't get it to work :<
I found this on google though, maybe it can help landsoul fix this issue (I don't know anything about excel)

Mouse2k4 · 09/02/09, 10:27 PM

Wont allow me to select dual Aesir's edges.

brandorf · 09/03/09, 12:35 AM

I like the changes to the Spreadsheet overall, there were a few text alignment issues and font size issues that were easily corrected. No other issues found that haven't already been mentioned.

Is there anyone who would care to explain to me how the weapon DPS -> SEP conversion is handled? I just can't deduce the formula from that mess of excel.

b0mbsquad · 09/03/09, 1:14 AM

Page: Lookup
Type: Typo
Legguards/leggings of Lurking Threat (non-heroic): Has a red gem-slot instead of yellow.

(thanks for all your work!)

earle117 · 09/03/09, 2:08 AM

Originally Posted by IggyMac

Are we talking about the arms sheet or the fury sheet? I tried the fury sheet last night and it looked to be about right.

Arms. The only reason I can see would only apply to Arms anyways, as I believe the sheet now allows OP procs off of dodges, which only applies to Arms spec. That's the only reason I can see that EXP would not be worth any significant value (outside of something just plain wrong, that is.)

Phyton · 09/03/09, 4:08 AM

I'm also experiencing some issues here, when i try to open spreadsheet i got this message for unreadable content and ask me if i want to recover. I say yes and everything seems to be fine, all Landsoul's gear and values look correct. I also import fine from EU armory, but the minute my gear is loaded into the sheet, i got those #VALUE errors about everywhere. Any tips?

Croaker · 09/03/09, 4:33 AM

Originally Posted by Shundroth

Page: Fury, Arms
Type: Format
The "Fetch Armory" text is showing up in the 3rd belt socket area, and clicking it causes an Armory lookup.

If you're just looking for a quick fix for that, you can right click on the text, select Assign Macro, enter

'WarriorDPS2.500Excel07.xlsm'!ArmoryLookup

into the box (or if you've changed the name of the file, you specify the new filename)

Then right click the text to select it, and you can left click and drag it into the correct place on top of it's button.

Croaker · 09/03/09, 4:38 AM

:EDIT: Sorry for the double post, the forums timed out and I didn't realize the first one went through.