The excel 2007 on my machine is American, but the excel 2002 I used is a belgian version.

It's interesting that equipping a DST increases my nominal dps from 1813 to 1827, but applying the mean haste (300 * 30% uptime = 90 haste) increases my nominal dps to 1851. (v29 of the sheet.)

for DST/QS, the uptimes and dps are:

- - 33% 1277
QS 35% 1448
DST 15% 1449
DST & QS 16% 1453

for 90 haste/QS

- 51% 1363
QS 49% 1465

The implication is that we cannot model variable haste items by multiplying their uptime * haste. For my gear, the DST ends up equivalent to an item with a haste rating of 34 (rather than 90 as one might expect.)

Time to fix my item spreadsheet and to figure out what haste rating to apply to the Abacus of Violent Odds.

Abacus uptime is effectively 8%. Haste is 260 which is over my haste cap, so I can use the DST figures above. So it should be approximately

-- 1289
QS 1463
Ab 1464
Ab & QS 1468

using the calculations already present. just need to adjust for uptime. observing that QS == Abacus == DST for dps close enough, we can compute the dps as 1289*(no qs or ab) + 1465*(1-that). Now the percentage of the time there's no qs AND no ab, given they are independent events at 50% and 8% probabilities is (1-.5)*(1-.08) = .46. So, finally, the true abacus dps is 1289*.46+1465*.54 = 1384, a gain of 8.5 over the 1375.5. That works out to a 21 haste rating equivalent.

DST Haste Rating Equivalent 34
Abacus of Violent Odds HRE 21

There you go. I hope this is helpful (note your numbers may vary with your gear.)

But wait!

LOL, I just noticed that 260*10/120 = 22, close enough to the 21 above I got through a different calculation chain to put my statement above to a lie.

Hmm.

That's interesting. My haste cap dropped to 210 in v29 from 310 in v27. I.e., my dps stops increasing at 310 haste in v27 but at 210 in v29 (same shot rotation and weapon and build.)

Aha. Latency in v27 is 0.0 seconds and 0.2 seconds in v29. It is the LATENCY that screws you over with the haste items.

There's still a discrepancy, 210 * .3 = 62 haste rating for DST but the results above show 34. I'll see if I can track the reason for that down. (I'm not claiming there's a bug other than in my understanding.)

For now, the HRE's above are for my gear and 0.2 secs latency.

Just in case you were wondering, I've emphasized what you need to stop posting here.

nice spreadsheet.. i think i'm done filling out everything i could. i must be missing something because it's reporting that my crit is 32.87% yet my paper doll is saying 33.45%... I don't know what I missed.. :{

edit: figured it out.

Cheeky,

I'm currently using v30 of your spreadsheet and it's great. I love the multiple gear sets, but I would like to request some additional features if that's alright.

1) On the gear page, is it possible to add a small comment area for the gear set?

2) On the Settings and Results page, I see you have a summary of the saved dps figures for the various sets. Would it be possible to copy over a brief summary of the major stats for each set as well? (i.e., stam/hp, int/mp, agi, rap, hit, crit, mp5)

Thanks very much

1) you can name the sets, is that not enough? Adding comments could be pretty easy.

2) That sounds reasonable, It's just a question of managing all the data in a readable format.

Cheeky, as usual love the sheet. Just wondering if it would be too much work to add in the thundering skyfire diamond (with a setup like DST). The PPM appears to be .9-1, but if that could be user settable.

ANyways, with the haste nerf, but the BIG increases BM get with slow weapons when hasted I am wondering if this will in fact be a good meta to have. Slow bows/guns and BM sem to work well with haste. Less time in "unhasted" mode FTW.

Oh I didn't realize you could already name the sets. Sorry about that. Could you tell me how?

On the 'Settings and Results' tab, just click on the set name and change it to whatever you want. Next time you select the drop down menu on the 'Gear' tabs it will have your names.

I think the whole feature breaks if you use the same name twice, so try and keep them different.

Error in loading DLL occurs when I try to open the 2 newest files in Excel:Mac 04. Haven't tried the older ones.

It goes through "converting" a bunch of Metafiles, and then asks me if I want to enable/disable macros or not open the file. If I try to enable or disable them, I get the "Error in loading DLL" message.