[Elemental] SEIC Spreadsheet - v3 - Page 2

Binkenstein · 12/05/08, 10:56 PM

Hit was something that I threw together to get some approximate values to work with.
May put an option in to value/de-value hit, or have separate DEP values for hit/no hit.

Samou · 12/08/08, 1:37 PM

As a side note, I've begun work on the Rawr Elemental module. I'd post this in it's own thread, but I've been registered for over a year now, and have only recently begun posting, thus I haven't reached the post count to start my own threads.

Kishkegelt · 12/11/08, 1:11 PM

Does the current (3.081211) SEIC include, as the name maybe implies, the new patch changes to elemental?

Binkenstein · 12/11/08, 2:31 PM

The version number is v3.date at this stage, so it is a build from the 11th of Dec, 08. But yes, I updated it a while ago to account for what we had previously been told the changes were going to be.

Binkenstein · 12/20/08, 9:50 PM

Holy updates Batman!

Hope the new Wowhead link goes down well.

Humongus · 12/23/08, 1:51 PM

Is there a 101-guide to using this spreadsheet? There isn't a documentation tab...

I consider myself a pretty advanced .xlsx guy but this model has a pretty steep learning curve in my opinion for those who haven't been following its evolution for some time.

Regards -

ruizAw · 12/23/08, 6:08 PM

Crit
23
Haste
34
Hit
100
Int
27
mp5
0
Spell
60

int > crit ?

Binkenstein · 12/23/08, 11:07 PM

Originally Posted by Humongus

Is there a 101-guide to using this spreadsheet? There isn't a documentation tab...

I consider myself a pretty advanced .xlsx guy but this model has a pretty steep learning curve in my opinion for those who haven't been following its evolution for some time.

Regards -

You enter your stats on the first page, change glyphs/set bonuses, and set buffs/talents on the settings tab. Then you can use the EP values on a site, or click the wowhead link. It's pretty easy, so if that's too hard, maybe you should return your computer to a store, or at least stop calling yourself a "pretty advanced XLSX guy".

Originally Posted by ruizAw

Crit
23
Haste
34
Hit
100
Int
27
mp5
0
Spell
60

int > crit ?

Uh.... download the new one?

doogless · 12/24/08, 1:17 AM

How accurate is the DPS the spreadsheet lists? I'm curious if it's not completely worked out yet or if I'm just terrible (or both).

Binkenstein · 12/24/08, 1:27 AM

As accurate as I can work it for 3.0.8, although I know I haven't added resist mitigation back in yet, so you can shave another 3% off the top, roughly.

Kishkegelt · 12/24/08, 10:33 AM

Thanks! Might want to update the filename.

Chant · 12/26/08, 9:41 AM

Thank you! That should cover all my spreadsheet needs.

If you find the time, I'd be glad if you could answer a few questions:

1. Where does Call of Flame enter the damage calculation for LvB? I couldn't find anything in the corresponding cells.

2. How does one arrive at the base damage values for LvB and LB (1230 and 807), respectively? 807 corresponds to my ingame-tooltip, but that already includes Concussion, doesn't it?

3. As far as I can tell, CC-uptime is always determined with respect to rows 23-135, regardless of fight length. I believe this should be adjusted dynamically, shouldn't it?

Binkenstein · 12/26/08, 2:43 PM

1) Fixed.
2) Fixed.
3) the CC page was some "math in progress". I've changed the CC reference back to the math page where it should be.

Graze · 12/26/08, 4:04 PM

This is great, thanks a lot for your hard work.
I'm really happy it works in OpenOffice now.

Just thought I'd give you my thoughts on this;
Could you split up the "buffs" column into "buffs" and "talents"? (Mainly thinking about how it handles Call of Thunder and Misery/Imp FF. also should the user manually add 1% hit for Draenei Aura or can there be a setting?)
Can there be an option to enter the hit and haste values as ratings instead of %'ages? (Helps some if you only have access to the online armory)
Why is the Damage % modifier box green when it's feels like it's not something one should tinker with?

Also I'm not 100% certain how the DEP calculations work but it still listed hit as the #1 stat for me even when I had >17% already.

Binkenstein · 12/26/08, 9:23 PM

1) Buff/Talents - Can do, although there won't be much going into the talents column (CoT + Precision)
2) Draenei Aura - Done
3) Ratings not % - Done
4) Damage modifier - fixed.

I decided against automatically adjusting EP values based on hit %, because I could never figure out a decent way to handle it. The solution is that there are two Wowhead links, one including hit, and one that doesn't. It's up to the user to manage their own hit percentages.