Hey everyone,

I've been working on creating a spreadsheet similar to one I had seen for rogues that allowed you to enter all of your gear and gems, and then switch between various gear items and get immediate feedback on their effect on DPS and longevity. I've been somewhat nervous about posting it because I've been worried I'd made some mistake in it, but someone asked me about it, and I decided to go ahead and give it a go - more eyes on it is better for testing anyway.

It can be downloaded from http://spriest.team-vortex.net/. I've only ever tested it in Excel 2000, but there isn't anything specific I can think of that would break it in any other version, or in OOCalc.

It currently allows you to enter your spell priority list, gear, various raid conditions (buffs that are available, shaman totems, boss debuffs), and consumable usage. It then lets you know your estimated DPS and casting time till OOM. It also has a page with a more complete breakdown on threat, mana usage, and damage/mana broken down by spell.

It should be noted that it still needs some work in the area of buffs and that it doesn't currently model spell haste. Also, almost all the gear that's selectable is raid level and above (Kara -> BT), plus the Glad/Merc Glad pvp gear - I have to enter each piece of gear by hand, and while it's easy to add a single item (I just have to type its stats to the end of a table, and it becomes fully available throughout the spreadsheet), it takes a long time to add the raw number of items available

Feedback is appreciated about any bugs or oversights you notice. I'll be working at adding lvl70 dungeon items, but if there's anything specific you'd like to see in a timely manner, just let me know, and I'll make that item a priority.

btw, major props to The_Panda and Mefadin for the creating and updating the shadow priest DPS spreadsheet over in the spellcasting forum - while I did do the spellcasting system in mine from scratch to try to make it a bit more adaptable, the manner in which it does so was very much inspired by their work

Thank you very much Firala!

Your hard work and the hard work of those before you are greatly appreciated. This is exactly the type of mod that I was hoping to find when I very first joined these forums.

I think the true key to a spreadsheet like this is community support feedback and constant updating. My rogue friends say that their uber spreadsheet like this is updated every few days with tweaks as new information is gathered.

I will gladly help in any way I can and I hope this spreads like wildfire among the shadow priests that use these forums!

P.S. Sticky would be awesome

Dantar

ty Dantar for the help. A couple things he pointed out:

1. The spreadsheet is currently by default set to Vampiric Touch rank 2 instead of 3, so you might want to change that (I'll change the default to 3 next update)
2. Hyjal rings are not present. I've got the stats entered for them, and I'm adding the proc on the Exalted version.

Just to add to what Firala said, Mindblast is also set to rank 10 instead of 11. People may want to change that for accurate dps calculations.

Having fun with this!

0.7.4 is up.

- Set more appropriate default values for several fields
- Added support for staves
- Added all 68+ weapons with spell damage (1h and 2h)
- Added Hyjal reputation rings (including Exalted ring proc)
- Now shows the value of adding 1pt to various stats on the Final Results page
- Now converts Hit, Crit, and Haste to a percent on the Gear page in addition to showing the raw points value

Wow this is very nice, looks like it took a lot of work.
I couldn't figure out how to add items, but could you please add Chronicle of Dark Secrets to offhands.
Im using this until I get my Illidan staff =X

Also I can't wait for haste to be implemented!
Thx for your work.

Missing the Gavel of Unearthed Secrets

POS weapon..... >_<

<3
Aevie

D'oh, Can't believe I missed that one after being stuck wielding one for 2 months ^_^

Ok, both items above have been added pending the next update (which should have at least a basic spell haste implementation).


As for adding items... it's not too difficult, if you know where to look. That last part is the tricky one, though ^_^ If you'd really like to try it, here's the steps to open up the gear sheets for editing (instructions are for Excel 2000):

1. Go Tools -> Macro -> Visual Basic Editor
2. In the left hand side, there will be a list of worksheets (55 separate sheets at the moment). Look for one labeled "g_[itemslot]" for the item type you want to add. Select that sheet.
3. In the Properties pane below the list, set Visible to xlSheetVisible from xlSheetHidden
4. Close the VBA window and go back into Excel itself
5. In the newly unhidden sheet, add the item to the end of the list (the format for doing so should be fairly obvious from the lines above it)

After you type in the name and rarity, it will be added to the end of the selectable list on the gear page automatically.

0.7.5 Uploaded
- Added Chronicle of Dark Secrets and Gavel of Unearthed Secrets
- Added Eye of Magtheridon proc
- Added very basic simulation of Spell Haste (it needs some tweaking still, but at present does a reasonably good job of showing how haste offsets lag)

Very nice spreadsheet and grats on the sticky! I really like the layout and all of the options you have. I assumed your spreadsheet is correct and compared it to the one I've been updating and the results were within 1% for dps(after multiplying "my" dps by .9679 to factor partial resists). Longevity isn't as close, but that's primarily due to different formulas for shadowfiend. To be honest I don't the best formula, and just went with one perun suggested in the other topic.

Good luck with spell haste and procs/bonuses. Quag's Eye was a big block for me due to circular referencing(and my solution is quite flawed at the moment), but I'm sure with your elaborate method of simulation you won't run into the same problems.

I went out and respecced after playing with the spreadsheet personally... finally put that last point in Meditation

I love this, thanks Firala!

<3
Aevie

Thanks ^_^

My Shadowfiend formula was as much a guess as anything - it's one of the many misc. little things I still need to take a look at.

0.7.6 Uploaded

- It now allows you to see how the 2.3 Meditation change will effect you by allowing you to enter up to 6 ranks of Meditation, with ranks 2, 4, and 6 corresponding to the 2.3 version ranks 1, 2, and 3
- Added simulation for the proc on Quagmirran's Eye

And yes, Mefadin, Quags was a pain in the butt ^_^ Just the proc wasn't too bad, but the internal cooldown was a bit of a pain - since the proc modifies the rate at which time passes in the simulator, and the internal cooldown starts ticking immediately after it procs... yeah, had a couple of circular references to sort out there

btw, I just realized Band of the Eternal Sage is overvalued in the spreadsheet - when looking into Quag's, I found out it has an internal cooldown, but it's not modeled yet. I'll get that for 0.7.7

Is it only me, or is this not working on OOCalc?

First thing it does is a warning of macros that might contain viruses and you get to choose disable macros or enable macros. Of course I choose enable macros and I keep getting this Error:502 on almost every macro part of the sheet.

When I get to the Gear Builder, it doesn't seem to recognise the item slot, instead it gives a list of all gear that is already put on as default gear, nothing else.

Any tips?

I don't have OOCalc installed on my computer, so I haven't tested it with anything but Excel. Now that I know there's a problem, I'll have to download it and try it out to figure out what's wrong, but that might not happen for a few days. There is a single VBA macro, but it doesn't do anything automatically - all it does is let me go in and manually run it from the VBA Immediate window to hide/show all the background sheets.