Like some of the others I get #VALUE when trying to update SEP values or compare gear. One very strange thing I noticed while trying to figure out what Tier9 piece to get first was that if I switch to Tier9 gloves (and thereby loosing 4pT8 bonus, without getting 2pT9) I gained over 500 DPS. I couldn't understand this so I tried manually disabling 4pT8 without changing gear and I gained 450 DPS by doing this.
So there's definatly something wrong with 4pT8 bonus, you shouldn't gain 450 DPS by dropping 10% crit on Mortal Strike. All of this is in the arms section.
The new sheet looks really great though, and I'm looking forward to seeing it work. Thank you for you dedication Landsoul.
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.
Sorry to add into the large amount of questions here, but I have a quick question regarding SEP values. When I run my current SEP, most of the stats make sense, except that it rates EXP extremely low (lower even than Haste), while I'm still 51 points below the EXP cap. Right now, it's telling me that ArP is the best stat to gem, which makes sense, since I have quite a bit already (no GT/MR though).
Now that your spreadsheet deals with dodges and OP, does that mean that EXP really isn't worth much anymore?
And by the way, I really like your new sheet, it's much nicer to navigate and the faction themed color change is pretty cool.
Nitro boots still show up as +16 Crit instead of +24. Also when I import my toon from the wowarmory it has 2 errors, the first being that it can't recognize my +24 crit enchant, the second being it can't recognize my bracers. However, my bracers ARE in the dropdown list. Armplates of the Netherlord.