Prax: I can't tell anything from the screenshot you have up. I can go double check the item stats, but I think your problem revolves around the gems/enchants selected. Also, for proc or use effects, I've turned those into average values so we can compare them better.
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
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).
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
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
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.
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):
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.
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
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.
Originally Posted by 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):
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.
T58 should be looking at column AA, not Z, and X58 & Y58 should be AE & AF rather than AD & AE.
Fixed.
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
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
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.
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.
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.
Ah, I see where that went wrong. Didn't update the enchant information correctly. Fixed.
Originally Posted by 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.
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.
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.
Originally Posted by Eleven
Is there a way to convert those values to damage, dps, seconds?
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.
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.
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.
If you can find a coder that could add it in, sure. I kinda suck at the coding required to do things like that
So there appears to be a problem with Eye of Magtheridon on the Trinket page. I'll see if I can diagnose.
*Edit
Ok, the Trinket page is bunged up. It's use a copy of the equations for DP and EP from the singularly equipped items (like helmets) instead of the formula for doubly equipped items (like rings). The columns on the trinket page don't match what the formula is trying to do.
I grabbed a copy of your sheet off filefront to take a look. Nice work so far.
I noticed you Model Skycall Totem as a straight 60 Haste. I've done extensive modeling of this Totem since I stack Haste, and it scales. The model that I've run gives me data points that are most easily modeled with a Natural Log.
I have my own ugly spreadsheet that just takes in item diff's (Damage +/-, Crit +/-, etc) to give me stats -> dps conversion. The formula I use for Skycall modeling is:
MAX(60;43.61+5.3*LN(M2))
M2 is current Haste on my sheet.
It doesn't model it well at lower Haste values (like below 20), but scales appropriately with Haste from there, so I use 60 as the minimum value it will return. The exact formula is the most accurate I found when running stat regression tests on the points I received in my modeling.
It should increase your accuracy if you want to use it, but I'm not sure how to get around a circular formulation in Excel.
04/28/08, 8:27 PM
but it's fixed now.
Similar Threads
