Praxagora

Thanks for the reply. Another question I have regarding your spreadsheet is the dps calculation regarding spell haste. It seems the more spell haste I gear for, the lower my dps output goes. I plugged in all of Khrome's equipment + gems in there and the estimated dps only calculated out to 805. Is the spreadsheet not integrating spell haste in the dps calculation or something because I can't see how this would be possible when Khrome is reaching 2k+ dps on fights with his gear set-up

edit: The 805 dps from Khrome's gear set-up is buffless dps and with all applicable +dmg buffs from food, flask, class buffs, etc. the dps only reaches 1613. Still think it's a bit off. I'm just a bit confused because my dps with my current gear set-up is 990+ dps (no flasks, food buffs, class buffs, etc.), but when I replace my Relentless Storms and Netherstrike belt with the badge haste gear and replace my gems with haste gems my DPS plummets to 800 something. Maybe I'm not understanding the mechanics of spell haste against crit rating

 

◊ Binkenstein

The DPS value is an estimate of the total damage you'll do over the fight, divided by the fight duration.
So it's not a "instant dps" value, but rather a WWS approach to dps calculation.

So when you replace gear for lots of haste, your mana use goes up, so you end up doing less damage over the fight (before you go on about shadow priests, make sure you have the SP option set to Yes if you have one).

<Sporks> quote of the day: "it's like the vague leading the blind directing the clueless guiding the stupid around here"
Yahtzee In short, no. In long, noooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
Nite_Moogle The correct answer here is to blame Asgorath.
Nemesis This is the BB, temporal constraints are for lesser forums.

 

Eleven

Hey guys great job on SEIC just a few things I wanted to point out/request

The SP values for feet are bugged, I think its using the neck item to calculate it

I really like the new gem feature, I think the gem from heroic SL Rune-covered Chrysophrase (5 crit 2mp5) might be worth adding as I think its one of the higher EP blue gems

As someone else mentioned I'd also like to see the return of the DPS time till OOM box

Last thing there are a few group buffs which are missing which would be awesome if they were added
-adding a shadow priest doesn't add the 5% dmg increase from misery
-bm hunter 3% dmg, imp judgement of the crusader 3% crit
- 1-4 Drums of Battle, and 1-4 Drums of Restoration for groups w/ LWs
and i guess down the road stormstrike could be added to be complete


anyway keep up the good work

 

◊ Binkenstein

SP% was referring to Necks, mostly because I tend to set the code up somewhere, and copy/paste it to other pages but it's fixed now.
Heroic gems, good point, I'd forgotten about those. I'll try to get them added in later in the week.

More buffs/debuffs. That'll be an interesting one to do. Misery would be easy to do, and I'd have it set separately so you can have it on without a shadow priest in your group. BM hunter wise, I guess I'd just have to assume an uptime figure and go from there. Imp JotC - easy. Drums will be an interesting one to handle too. I guess I could have a 0-4 value, and multiply that by the bonus of the drum/4

Stormstrike.... that's a pain to model to be perfectly honest. If it were a static debuff we'd be fine, but the charges and the fact that other people can consume them pretty much throws any model system we could make out the window.

<Sporks> quote of the day: "it's like the vague leading the blind directing the clueless guiding the stupid around here"
Yahtzee In short, no. In long, noooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
Nite_Moogle The correct answer here is to blame Asgorath.
Nemesis This is the BB, temporal constraints are for lesser forums.

 

Eleven

ah I can see how modelling SS would be a pain in the ass

but a few other things I was thinking of

I dug up a number on shadowpriest.com 4 DPS = 1 mp5 for VT, so maybe adding a box for avg SPriest dps for more accurate mana return numbers

dark/demonic runes - I kinda forgot about these things but it might be worth farming a bunch for progression bosses

and somebody else mentioned destro pots but im not sure how you would implement those w/ SMPs

I was looking at the giant BM thread here and saw a 94% FI uptime mentioned if the pet is constantly attacking

 

Treylah

The EP/DP values for TLC and the Crusade card (on the upgrades tab) are returning values of -60 when I select them to be watched. 60 is the DP/EP value of my Hex Shrunken Head. (hidden) Cells F58, G58 and H58 are returning values of zero. According to the trinket tab, TLC and the Crusade card should be based DP/EP values of 42 and 55 respectively. So I would expect DP (column D) to return values of -18 for TLC and -5 for the Crusade card.

What I am looking at in the trinket area of the upgrades tab is (columns F, G and H are unhidden):

(Row) Columns--> B--------------------C---------D--------E-------F---G---H

(56) Hex Shrunken Head---------- <blank> <blank> <blank>--60--60--0
(57) Darkmoon Card: Crusade-------(-6)------(-6)---<blank>--55--55--0
(58) Darkmoon Card: Crusade------(-60)-----(-60)---<blank>--0---0--0
(59) The Lightning Capacitor--------(-60)-----(-60)---<blank>---0---0--0
(60) Quagmirran's Eye---------------(-35)-----(-35)---<blank>--25--25--0

Quag's Eye and the Crusade card are both selected for comparison while I swap between the two trinkets (on the main tab) to get an idea of which works better for my current setup.

Please let me know if I can provide more specific details than this. I appreciate immensely your work on this spreadsheet; it has helped to take a lot of the guesswork out of my upgrading process.

 

◊ Binkenstein

SP dps -> mana conversion should be fine, dark/demonic runes would be a pain to put on the main page but easy on the math, and thanks for that FI uptime figure.

For destro pots, I'll add it in under consumables, and then do some if functions for adding the stats in.

T58 should be looking at column AA, not Z, and X58 & Y58 should be AE & AF rather than AD & AE.
Fixed.

<Sporks> quote of the day: "it's like the vague leading the blind directing the clueless guiding the stupid around here"
Yahtzee In short, no. In long, noooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
Nite_Moogle The correct answer here is to blame Asgorath.
Nemesis This is the BB, temporal constraints are for lesser forums.

 

Eleven

ok bink my last post I swear

1. tormented demonsoul robes need their dmg + crit values moved over 1 cell, the dmg value is in spirit now
2. veteran's pendant of conquest has an extra 5 mp5 erroneously tacked on

- if this is unreasonable disregard it but in my dream version of SEIC I envision a place, possibly the upgrades tab, where when I model upgrading from piece A to piece B I see the differences in total damage done, estimated dps, and time till oom all in the same place, I don't know if that would be too complicated, but I would find it immensely useful

 

◊ Binkenstein

Fixed the items.
Now, funny you should mention that. ED is total dps, DP is dps, and SP is dps via regen, so those values are kind of there already.

<Sporks> quote of the day: "it's like the vague leading the blind directing the clueless guiding the stupid around here"
Yahtzee In short, no. In long, noooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
Nite_Moogle The correct answer here is to blame Asgorath.
Nemesis This is the BB, temporal constraints are for lesser forums.

 

Zene

Hi not to nitpick but here are two items which I'm using or upgrades for me that are rather easy to obtain:

I'm just copying them from the worksheet I added to myself, obviously certain sections should have the formula copied into instead of the raw value I've copied below.

Rings:

[Band of Arcane Alacrity]
Band of Arcane Alacrity,29,29,0,121%,90%,121%,90%,0%,0%,Normal,Magister's Terrace,,None,None,None,,18,12,,,22,,,,,18,,,0,0

Neck
[Vindicator's Pendant of Subjugation]
Vindicator's Pendant of Subjugation,49,49,0,100%,100%,0%,PvP,Battleground,,None,Y,None,,31,15,,25,25,,,,,21,3 ,Stam,0,0


Apologies if these have already been covered, thanks.

EDIT: Oops had 37 spell dmg in the spreadsheet for the neckpiece, no wonder it was on top =/ haha Fixed the text string above.

 

◊ Binkenstein

Zene: added. I've yet to add in any Magister's Terrace items, so that's why the ring is missing.

<Sporks> quote of the day: "it's like the vague leading the blind directing the clueless guiding the stupid around here"
Yahtzee In short, no. In long, noooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
Nite_Moogle The correct answer here is to blame Asgorath.
Nemesis This is the BB, temporal constraints are for lesser forums.

 

Torrential

Edit: I'm an idiot. Ignore me, except the part where I say thanks.

Just wanted to say great work and thanks, though. Pretty big project and it's fantastic.

 

ruizAw

chest

 

Buanna

I can't figure out why it's occurring, but I'm constantly showing Eye of Magtheridon as an upgrade over Hex Shrunken Head.

EP and SP are calculated differently on each of the Main page, Upgrades page, and equipment pages. It makes actual comparisons by those numbers pretty inconsistent.

Boni and Bonii are not words.
Bonuses is.

 

Shkarn

What gems do you have selected in your equipped chest? I'm wondering if it's taking gems into consideration for that damage upgrade.

 

◊ Binkenstein

Ah, I see where that went wrong. Didn't update the enchant information correctly. Fixed.
Main & Upgrades should be calculating them the same, except Upgrades will look at the ideal gems while Main looks at equipped gems, and both will include enchant values. Item pages work like the Upgrades page, except not showing enchants.

<Sporks> quote of the day: "it's like the vague leading the blind directing the clueless guiding the stupid around here"
Yahtzee In short, no. In long, noooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
Nite_Moogle The correct answer here is to blame Asgorath.
Nemesis This is the BB, temporal constraints are for lesser forums.

 

Buanna

Well that explains that. What about Eye vs Head?

Boni and Bonii are not words.
Bonuses is.

 

Eleven

Is there a way to convert those values to damage, dps, seconds?

 

◊ Binkenstein

Ops. Check your total hit. I would expect that you're not hit capped, and thus get more resists, which is why the Eye values higher.
DP is already there, but I'd prefer to keep all three values as they are, with the same unit of measure, so to speak.
Adding a damage gain would be possible, but a gain in TTO would be a bit iffy at the moment.

<Sporks> quote of the day: "it's like the vague leading the blind directing the clueless guiding the stupid around here"
Yahtzee In short, no. In long, noooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
Nite_Moogle The correct answer here is to blame Asgorath.
Nemesis This is the BB, temporal constraints are for lesser forums.

 

Mirranda

This is my personal request, being as I rerolled from a hunter, I used Cheeky's spreadsheet quite a bit before I switched over and started using yours.

The one thing that was an amazing thing to have was an Armory import of your items/gems so you didn't have to spend 10 minutes updating the spreadsheet every time you open it (after d/ling the update/getting new gear, etc).

Not sure what's involved in that, and obviously no immediate rush, but it would be a really nice feature.

Pretend I typed something witty.

 

◊ Binkenstein

If you can find a coder that could add it in, sure. I kinda suck at the coding required to do things like that

<Sporks> quote of the day: "it's like the vague leading the blind directing the clueless guiding the stupid around here"
Yahtzee In short, no. In long, noooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
Nite_Moogle The correct answer here is to blame Asgorath.
Nemesis This is the BB, temporal constraints are for lesser forums.

 

Buanna

Nope, I'm past the hit cap. Eye is listed at 71 damage and Head at 88, yet Eye has about 10 higher DP (I can get the exact numbers tomorrow).

Boni and Bonii are not words.
Bonuses is.