Just to report what I think is an issue with the OpenOffice version of the spreadsheet.
I use both Excel and OpenOffice spreadsheets, as I have Excel in my laptop at work and OpenOffice on my computer at home.
When the 18.104.22.168.a got out, I plugged my equipment and my buffs and got a value of 1624 dps. That's with Microsoft Excel.
Now, if I open the same spreadsheet with OpenOffice, I have a boot that takes me to 1785 dps ! So, I thought that the compatibility between the two applications was the cause of the boost and I downloaded the OpenOffice one (no macro buttons) and plugged in my equipement and my buffs, ending up with the same result : 1785 dps.
What's with the OpenOffice spreadsheet ?
EDIT : sorry, I found why by looking a few pages back in this thread (post 548). It's working ok now.
Going back through this thread as I now have time...
I recently removed Adrenaline Rush from the energy cycles and assigned it's damage separately. Previously it was adding the energy to your cycles and the cycles were calculated accordingly. This works with Haste potions as 40 energy can usually just get added to your cycle. 150 energy isn't able to be absorbed that way though because your energy would cap out if you maintain the same cycle. The result for Combat Swords builds looks to be cycles 1/2 a step higher, so 4s/5r cut from 3s/5r. These should be truer cycles. The previously suggested cycles (for builds with Adrenaline Rush) were probably a touch energy starved based upon the 150 energy that couldn't really be properly absorbed into your regular cycle. I may readdress AR more in the future (as most people probably add a full 5e to their cycle and "borrow" extra energy), but this should be much closer (and probably close enough that the prior mentioned tweak probably won't change the suggested cycle).
Hourglass vs. Crusade
Well, every version we learn more about the game mechanics or find ways to improve the modeling. My gut says that for most raiding rogues, Hourglass will be slightly better than Crusade but they are rather close. We'll see after the next version comes out as there is a little more find-tuning.
As mentioned many times throughout the thread, the spreadsheet defaults to including an estimate for the hemo contribution to raid DPS. If you look at the FAQ (first page) it discusses this more in depth.
I'm hoping to get this out today, but this time I'm going to test it a little more thoroughly. It will include the recently learned Slayer 4-pc changes, more tweaking to Extra Attacks, the correct crit damage formula is implemented (in fact, part of the sheet used Aldriana's crit formula, but I found this wasn't added to the cycle sheets yet). And the one thing I want to implement today is the Windfury buff AP "carryover".
That is not a bug. I moved Blade Flurry and merged it with permanent haste (as that's how it's used in the spreadsheet anyway). Essentially, that cell has been obsoleted. In previous versions that was SnD x Blade Flurry in that cell.
I actually expected people would type the actual name of the item where it now reads (Unmodeled). I will change that to Unmodeled MH Mace, etc. But as an FYI, you should be able to type the item name in the cell. It should still show up at the bottom of the list (not in alphabetical order).
I decided to go with the bare bones changes this time. The Windfury "buff" that sometimes adds extra attack power to additional attacks will go in later. This version is mostly bug fixes and the application of new theorycraft.
The Metagem require change should help with Upgrade checks. Essentially, during upgrade checks, the Metagem requirement is no longer being considered at all. Thus, changing out gear with a blue gem won't disable the bonus anymore and make it appear that much worse items are upgrades.
There might still be issues involving set bonus gains or losses, but its one less thing to worry about.
And for "unmodeled" items, feel free to type over (unmodeled). It was intended that you might want to type in the item name in that location. The new item will appear at the bottom of the list.
Glancing rates fixed for 70-72; 73 is now a 25% reduction at a 24% rate (from 24%/25%)
Meta Require is now automatically turned off during Upgrade checks to more accurately compare items.
(Although one will still need to adjust gems to meet the requirements for the suggested item to actually be such an upgrade)
Hemo/Backstab formulas (broke in 22.214.171.124)
Slayer 4-pc bonus is now additive with Surprise Attacks, Aggression and Opportunity
Sword Spec can proc from specials
I'm seeing an 80 DPS increase going from 05a to 06, of which 73 DPS is white DPS. This seems quite hefty, is this the result of the sword specs proccing off specials or did you change something else as well?
Just noticed while searching for updates, for the first time DST has been pushed from being #1 trinket. For me, Shard of Contempt is now a slightly better upgrade than DST (yeah, I still don't have it...).
Here is a followup to my last post on a new method of Mutilate modeling. I've been in conversation w/ Todemax via PM's and he has explained to me more or less how the current Seal Fate modeling works in the current non-Mutilate cycles. (This is the new Seal Fate modeling, after it has been fixed to actually make sense.) What's there right now for the non-Mutilate cycles, as implemented by Todemax and DMM, is more or less what I was thinking of for updating the Mutilate cycles.
Basically, the current implementation is a X+/Y+ cycle, where the damage output is weighted by if you get additional combo points or not from your Seal Fate talent. The reason it hasn't been implemented for Mutilate is the difficulty of determining the percentage of the time that you would get the extra CP. I'm hoping to help fix that issue.
As a start, here is an updated set of state/path diagrams for Mutilate: Savefile.com
EDIT: Updated the URL to a new file with the error that Drumbum caught corrected.
EDIT #2: In the above file "Relentless Strikes" should read "Ruthlessness"... (I always get those two mixed up. However, it's not worth it to upload another file... the formulas don't change.)
(By the way, anyone know how to attach a file directly to your post? Do you need special privileges to do that? I would assume so.)
The last page of that set shows a table of the probabilities of different outcomes based on the parameters specified. The table separates out probabilities for numbers of combo points and numbers of instant attacks used. In practice, a spreadsheet would likely implement this a little differently. I'm going to try to put together a spreadsheet soon which demonstrates the concept I'm getting at.