Koroshiya

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.

 

Koroshiya

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.

 

Buanna

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.

Boni and Bonii are not words.
Bonuses is.

 

Tymir

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.

 

Buanna

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.

Boni and Bonii are not words.
Bonuses is.

 

Koroshiya

Awesome feeback Buanna keep it coming!

Updated the 2nd post to list the issues found.

 

Tymir

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.

 

bol

Nice work

Can confirm Dwarf stats are correct

 

Tymir

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

 

Pitbuller

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.

 

Tymir

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.

 

Koroshiya

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.

 

Tymir

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

 

ildon

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?

 

Tymir

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.

 

Tymir

I've mainly been focusing on a WotLK version of the spreadsheet for the past little while. This should be the bulk of the altered/new raid buffs, talents, and glyphs with the exception of the New Improved Moonkin Form modeling. The spells are still left at level 70 versions although I did put in the level 80 spells before the mana costs were all changed to % of base mana, if anyone knows the base mana at level 80 or how to calculate it, please contact me. My reasoning behind keeping the spells at level 70 was because I was attempting to compare whatever DPS increase we gained to DPS at level 70. Also, this spreadsheet does not include the new spell partial resist formula. Keep in mind I don't have a beta pass so if you see anything erroneous, or any omissions don't be afraid to inform me at all.

SPriestGearSim_WotLK_1.0.0

 

bol

edited to blank, no longer relevant.

 

Tymir

Added Chaotic Skyfire Meta, since it will actually be worthwhile if Mind Flay is able to crit. Added the Jimmythenumbers raid buff changes, changed the Mind Flay coefficient to 81.4% (no crit since it's not on beta realms yet), implemented the new Misery as 15% additive to the coefficient even though there have been reports of it causing MF and MB to do 15% more damage overall.

SPriestGearSim_WotLK_1.0.1