Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Public Discussion » Class Mechanics

 
 
LinkBack Thread Tools
Old 04/09/08, 9:27 AM   #1
Koroshiya
Von Kaiser
 
Koroshiya's Avatar
 
Human Death Knight
 
Ysondre
[Priest] - Shadow Priest Spreadsheet

Big Thanks to Tymir for all the updates! He's been keeping on top of it. Lately I am just a host of the file!

Current Version: 0.9.4 (14 May 2008)
Excel: http://www.altoholic.com/wow/spreads...Calculator.xls
Open Office: No support at this time.

Previous three versions: 0.9.3, 0.9.2, 0.9.1

Features:
  1. Gear Selection
  2. Talent Selection
  3. Buffs & Consumables
  4. Spell Rotation Priority Settings
  5. and more...
Note:
If there's a bug with an item having the incorrect stats, etc, check the list below and PM me or post in this thread about it if it isn't listed!

Try keeping this thread focused on the spreadsheet development, or issues related to calculations, etc.
Other areas of discussion are usually better suited in another thread.

Last edited by Koroshiya : 05/14/08 at 6:04 PM.

Offline
Old 04/09/08, 9:29 AM   #2
Koroshiya
Von Kaiser
 
Koroshiya's Avatar
 
Human Death Knight
 
Ysondre
Planned Updates:
None.

Known Issues:
The spell simulation is getting thrown out of whack when changing spell priorities.
To use the Skull of Gul'dan turn on iterative calculation and turn maximum iterations to 1.
There's some bug in between Shadow damage and regular damage. Orb of the Soul Eater is shown as a huge dps decrease over Khagdar's Knapsack, which is impossible.
All races use Starshards. (Should auto turn off when not selecting Night Elf.)
When I have 6.59% spell hit in gear and 5/5 Shadow Focus, it lists 1 hit rating as a .03 DPS increase. It should be zero, I'm already over the hit cap (but who knows, that could be Starshards).
The crit % on Final Results doesn't match my character sheet.

Last edited by Koroshiya : 05/14/08 at 5:47 PM.

Offline
Old 04/09/08, 1:14 PM   #3
Buanna
Piston Honda
 
Troll Shaman
 
Hellscream
Blessing of Wisdom isn't in the list of buffs.

1 Haste rating should be added to the list of Effect of Stat Increases.

There's some bug in between Shadow damage and regular damage. Orb of the Soul Eater is shown as a huge dps decrease over Khagdar's Knapsack, which is impossible.


Offline
Old 04/09/08, 4:23 PM   #4
Tymir
Von Kaiser
 
Tymir's Avatar
 
Draenei Priest
 
The Forgotten Coast
Originally Posted by Buanna View Post
Blessing of Wisdom isn't in the list of buffs.

1 Haste rating should be added to the list of Effect of Stat Increases.

There's some bug in between Shadow damage and regular damage. Orb of the Soul Eater is shown as a huge dps decrease over Khagdar's Knapsack, which is impossible.
I don't plan on including a 1 haste rating section until a wait system is introduced, without one it has the potential to be very misleading. Thanks for the other two points though.

Offline
Old 04/09/08, 5:13 PM   #5
Buanna
Piston Honda
 
Troll Shaman
 
Hellscream
All races use Starshards.

When I have 6.59% spell hit in gear and 5/5 Shadow Focus, it lists 1 hit rating as a .03 DPS increase. It should be zero, I'm already over the hit cap (but who knows, that could be Starshards).

The crit % on Final Results doesn't match my character sheet.

Last edited by Buanna : 04/09/08 at 5:23 PM.


Offline
Old 04/09/08, 8:01 PM   #6
Koroshiya
Von Kaiser
 
Koroshiya's Avatar
 
Human Death Knight
 
Ysondre
Awesome feeback Buanna keep it coming!

Updated the 2nd post to list the issues found.

Offline
Old 04/15/08, 12:15 AM   #7
Tymir
Von Kaiser
 
Tymir's Avatar
 
Draenei Priest
 
The Forgotten Coast
New version linked up top.

Change List:
-Corrected errors with calculation of total shadow damage
-Added Devouring Plague
-Added Judgement of Wisdom
-Added Blessing of Wisdom
-Distinguished between Divine Spirit and Improved Divine Spirit
-Added Improved MotW
-Added 2pt4 Elemental bonus to Wrath of Air Totem
-Corrected the amount of MP5 gained from Mana Spring Totem
-Added Improved Mana spring
-Fixed some inaccuracies with calculating time remaining on some procs and special abilities
-Added base stats for all races, need testers to verify these.
-Corrected the spell critical hit rate displayed on several tabs (although the dps simulator was using the correct value all along), need testers to verify that spreadsheet values equal character sheet values.

Offline
Old 05/01/08, 7:10 PM   #8
bol
Glass Joe
 
Dwarf Priest
 
Arathor (EU)
Nice work

Can confirm Dwarf stats are correct

Offline
Old 05/10/08, 12:37 AM   #9
Tymir
Von Kaiser
 
Tymir's Avatar
 
Draenei Priest
 
The Forgotten Coast
New version:
RapidShare: 1-Click Webhosting

Changes:
-Added Timbal's Focusing Crystal
-Added new M'uru drops
-Added S3 and S4 items including Vindicator's and Guardian's

Offline
Old 05/10/08, 4:51 AM   #10
Pitbuller
King Hippo
 
Tauren Shaman
 
Wildhammer (EU)
Shaman's Mana Pool for Mana Tide.
Should be priest mana pool.

Mana Tide Totem:
Summons a Mana Tide Totem with 5 health at the feet of the caster for (13 sec-1) sec that restores 6% of total mana every 3 seconds to group members within 20 yards.

Edit: Also can you add [Bracing Earthstorm Diamond]

Slow, slower, shaman weapon.

Offline
Old 05/11/08, 7:11 PM   #11
Tymir
Von Kaiser
 
Tymir's Avatar
 
Draenei Priest
 
The Forgotten Coast
New minor update:
RapidShare: 1-Click Webhosting

-Removed the unnecessary "Shaman's mana pool for Mana Tide" field, just to be clear even before this revision it was using the Priest's mana pool, not the Shamans.
-Added Cudgel of Consecration and Bracing Earthstorm Diamond
-Fixed a bug with Improved Blessing of Wisdom.
-Fixed stats on Malefic Girdle, 21 crit instead of hit.

Offline
Old 05/13/08, 7:11 PM   #12
Koroshiya
Von Kaiser
 
Koroshiya's Avatar
 
Human Death Knight
 
Ysondre
Sorry I was out of town on vacation but I am back now. I have updated the main thread and posted the latest version by Tymir. Tymir I have merged my changes into yours so make sure you grab the latest from my site before extending it again.

Offline
Old 06/10/08, 4:30 AM   #13
Tymir
Von Kaiser
 
Tymir's Avatar
 
Draenei Priest
 
The Forgotten Coast
0.9.4 by Helinut

* Formatting changes
* Fixed error with Battle Elixirs
* Changed Season 2 Set bonus to follow the function of the rest of the Season Set bonuses
* Added missing ranks of Starshards
* Added Symbol of Hope
* Modified Inner Focus to prioritize Devouring Plague over Shadow Word: Pain if DP is being used. Also changed it to check that IF will be ready on the current simulation step rather than the one before it as it was only casting it on every other DP due to the original behaviour

Download Link

0.9.5 by Tymir

*Fixed the issue where final DPS would go very low ~180 (wasn't Halinut's fault, thanks for the better look + other changes)
*Added some Kil'jaeden items
*Fixed major underestimation of on use spell damage trinkets
*Fixed typos in T4 Helm and Chest stats

Download Link


Planned Features
*"1 Haste Increases DPS By:" field
*Wait Values
*MF Clipping
*Inner Focus with MB
*Troll Berserking racial
*Taking Suggestions

Last edited by Tymir : 06/12/08 at 3:33 AM. Reason: Typo

Offline
Old 06/10/08, 1:37 PM   #14
ildon
Collateral Damage
 
ildon's Avatar
 
Undead Priest
 
Whisperwind
Every time I change a piece of gear (even changing something like cloak enchant which shouldn't affect DPS) there seems to be a random fluctuation of the "total DPS" number. As much as +/- 50 DPS, although normally it just seems to drop by ~1-3 DPS. Is this due to a randomization factor in the simulator? It just seems to make the spreadsheet not very helpful for most gear decisions, especially very close ones, when there's always a +/-50 DPS margin of error due to randomization.

Is this actually what's going on? Or is it a bug? Or am I doing something wrong?

Offline
Old 06/10/08, 9:52 PM   #15
Tymir
Von Kaiser
 
Tymir's Avatar
 
Draenei Priest
 
The Forgotten Coast
For best results make sure iterative calculations are enabled and the maximum iterations are set to 1 in the Excel options. After this you mash F9 until the final DPS stops changing. This happens since the simulation timeline is just all the cast times up until that point added together, of course haste affects total cast time and thus the entire timeline which in turn affects all procs, trinkets, and other temporary effects.

Offline
 

Go Back   Elitist Jerks » Public Discussion » Class Mechanics

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Priest] Holy Priest Healing/Gear Spreadsheet Jayde Class Mechanics 94 06/16/08 3:02 PM
[Priest] Shadow Spreadsheet Joetest Class Mechanics 23 04/09/08 1:05 PM
[Priest] Shadow Priest Damage and Spell Rotation Ilmater Class Mechanics 146 09/07/07 6:56 PM
Shadow Priest DPS Spreadsheet Pungent Class Mechanics 83 09/05/07 5:48 AM
PRIEST SHADOW/HOLY COMPARISON SPREADSHEET Chairman The Dung Heap 18 11/02/06 11:04 AM