I have created this new thread to link to my newest version of my ret dps calculator. I would like the thread to remain about spreadsheets and simulators, modelling of fights and mechanics. Please use the other threads in this forum for questions about rotations, glyphs, or complaints/questions about ret in general.

Please use this thread for discussion of how to improve modelling, possible errors or needed improvements for any spreadsheet or discussion on the possible differences of opinion between the various ways of modelling ret damage available. This should be a forum for spreadsheet designers and users, not just a second ret questions thread.

That said, if you do have anything to contribute or suggestions for improvement for my spreadsheet please do step up and post. Also, feel free to discuss other spreadsheets or modelling programs here, this isn't meant to be exclusive to my sheet in any way.

New hosting! Thanks to psychosomatic for hosting my sheet now.

The two documents are 2.5 (last version compatible with Open Office) and 3.3 (Current best version)

Redcape's Spreadsheet

Some notes about the new version:

Changed modeling for Berserk based on new data, assumed uptime: 75%.

Added option on Talents and Buffs page to enable or disable Heroism modelling.

Removed SoB/SoM modelling, made the front page assume SoV use.

Currently modelling JoR as proccing seals, and JoC/JoV as not doing so.

Added support for tier 9 set bonuses, new glyph and new librams.

Added the ability to save and load gearsets in the Gear section.

Added additional information on overall performance to back pages to reduce clicking around.

Updated for increased profession perks in 3.2.

Changed CS, Judgement and Seal information to match 3.2 models.

Changed default delays to match new rotation styles.

Enjoy!

It looks like there is a bug with the weapon speed option for test gear. Alterations to speed on the main page seem to be functioning correctly. Slower weapons with the exact same stat allocation are showing a significant DPS loss, while fast weapons are showing a massive DPS boost. I also occasionally get a "division by zero" error when I input the weapon speed as 1.

Here's am example of what I'm getting: http://img23.imageshack.us/img23/8121/bugxyi.png

For reference, the stats are for the Furious Gladiator weapons. When using the proper 3.6 speed it's showing a loss of 285 DPS, where in v2.5 of the spreadsheet it was ranked around -0.8 DPS.

I would suggest using the 2.5 version. Aside from the ArPen changes it works fine, and you can pretty easily approximate those changes by lowering the value of ArPen by 3% or so.

Edit: I found the bug, some of the DPS calculations were referencing the test gear stat list instead of standard, which causes no issues unless you have a different speed entered in the test gear section. Bug squashed, 3.01 posted now and should work fine.

Edit2: Putting in speed of 1 still generates an error in 3.01. I fixed that internally and will release it with the next update. No real need update the download yet since there really isn't any reason we need to model a speed 1 weapon. Other speeds all work fine.

Just to know why you used the Microsoft office support of macro instead of the Open Office one who can use all people whit out hassle ?

Would it be possible to have it download from the Armory, and potentially even separate gear/gems/enchants better? Sort of like drop down menus to show each item, enchant, gem?

I'm going to guess this was mentioned earlier.. It's probably impractical to apply. I find it faster to manually put in the stats anyways instead of picking through a huge list of items to find the right one anyways.

I first built my sheet in open office, but since I acquired Excel I find I like Excel hugely more. While I am usually the sort of person who is against the evil empire I find that Excel is really a product that is superior to its competition. The old versions continue to work, and although there is the possibility I will update them at some point I just don't have the spare time that I used to. Excel and its macros have decreased development time so much I can't really imagine going back unless I suddenly become unemployed.

This was a similar bug to the previous weapon speed one. I have fixed it too and will be pushing out a new version today with all (I hope) corrections made. Also, the new version will have proper support for librams instead of the hacked together mess I had before.

Possible, but honestly I find searching through all the gear on Rawr to be tedious in most cases. I doubt I will implement any kind of gear system that searches through all available gear from a web source.

Yes. I have some ideas for improving the gear interface like saving equipment and having drop downs for enchants and such, but since enchants are almost completely static (barring icewalker/AP to boots based on hit rating cap) there really isn't a big incentive to change that chunk of the sheet. An improved gear interface is likely going to be my focus over the next while, but don't expect anything soon.

I didn't mean checking for upgrades through the armory... I meant to download your current gear from the armory. Since there's a few other spreadsheets with that function that you can just click a button and get your current gear set from armory, instead of going through the work of actually putting in each item, separating the gems and enchants from it and putting them in a section section.

One of the things that pushes me away from using this sheet is the information set for importing your gear isn't easily laid out. Yes, you have a section for "Main Gear Sets" and a section for "Enchants and Belt Gem". Where do you find out the information for each trinket, where do you put your gems at (I assume in the enchant section)? If you're comparing two items, do you put the enchant and gem numbers in the test section as well, because that's also not clearly defined.

There just seems to be no documentation on how to use this, which could push newer people away from using this one and more towards using another one. Or just staying with Rawr (which I dislike, personally).

I just added up all the enchants/gems on each item. Trinkets you just approx. the value. Sure the sheet isn't that user friendly, but once you enter your current item's stats in the fields it isn't too bad.

The functionality to download your gear from armory is missing largely because I don't know how to code it! I am just teaching myself spreadsheets and VBA as I go, so while that sort of thing is certainly possible to build, I have not gotten far enough along to do it.

I think adding in a gems section is something I may do, but I don't think it is nearly as complicated right now as you are making it out to be. There is a section labelled "Enchants and Belt Gem" where enchants obviously go. You just add the gems and set bonuses in to your item stats and enter them into each item slot as appropriate. Setting the gem bonuses aside for each piece of gear is something I could implement but it isn't going to save you any time.

As far as generating numbers for each trinket goes, I really do expect people to do that on their own. For any trinket you can easily look up its stats on wowhead and figure out what expected uptime is on procs to generate a good approximation.

Trying to make the gear section a little more readable and intuitive is something I will definitely be working on for my next patch, though I just don't know what form it will come in. I will probably build something in to allow you to more easily swap out gear and save pieces of gear.

I greatly appreciate your hard work, Redcape. It makes it vastly easier to decide on rolling on an item or not when it drops. Now you'll have to excuse me for a bit if this sounds dumb. To me, it feels 'right' to have stat values normalized to strength, which I've implemented in all revisions of your spreadsheet. In the latest revision though (3.1) there seems to be something off. Something was changed as far as the stat value goes for Hit rating. I'm assuming the large value is while you are not melee hit capped, and the small number (to me it is small since I'm melee hit capped) is spell hit capped.

I'm assuming this has something to do with macros or something, because I can't determine where this value is coming from. I traced it to I9 on Ability Use Information, and that cell just has a number, no references to other cells for calculations. I don't suppose you can help me pulling out the calculations for both of those numbers? I have no clue if macros are enabled on my computer. I use OpenOffice 3.0.1 (build 9379)