QuiggyB

The sheet doesnt seem to be calculating anything for that card. You can set the trinket slot to none, set your off-hand to custom and put 120 atk power in the custom offhand slot. When I do that I get a 4.5 dps upgrade which isnt even remotely worth the cost of the card. Bloodlust broach shows the same dps upgrade over hourglass.

 

Cheeky

A couple quick fixes that I found annoying:
- Fixed averaging out The Beast Within for Open Office.
- Removed potential rounding errors that I may have had in the "+1 Attribute yield X DPS" Feature.
- Expanded the "+1 Attribute = X DPS" feature to include Intellect, Haste, and Armor Penetration.
- Have [Darkmoon Card: Crusade] operate fully stacked for modeling purposes.
- Fixed cell locking preventing some of the save sets being used.

Cheeky of Havoc

 

◊ vank

Using Open Office version and none of the gems can be selected from the drop down lists.

 

Cheeky

Using OO version 2.2.1 from Sun it is working fine. What version are you using (and which gem locations)?

Cheeky of Havoc

 

SiRk

I have the version 30 of the spreadsheet, but changing the Haste Rating setting doesn't seem to influence the shot timer at all. (I manually added 400 haste rating to check for this)

Keep up the good work for the rest!

edit: using excel 2007 if that's any help

 

Cheeky

Could it be that 400 haste rating at 2.1 (~38%) and 2.2 (~25%) both have you bumped up against the GCD in your rotation? I am seeing the values change. Check cell H19 on the 'Calculations' tab to see the effect of the haste rating -> haste % conversion.

Cheeky of Havoc

 

SiRk

Using my current gear (no haste), and adding 400 static haste rating in R89 on 'Gear' tab (steady shot rotation all the way, bm 41/20 build):
- 2.1 setting: H19 = 138%
- 2.2 setting: H19 = 138%

I see the 'Calculating...' message appearing in the status bar when changing the setting, but nothing seems to be changing for some odd reason.

 

Cheeky

Hmm. That's odd. If you change the haste rating after changing the setting does it update cell H19? I've tested with Excel 2000 and 2003 (all I have access to.) I also tested in Sun's Open Office and it's working there too.

Cheeky of Havoc

 

◊ vank

I am using OO 2.2. I guess I'll update to 2.2.1 when I get home and check it out.

 

SiRk

Yes it does, but it keeps calculating using the 2.1 haste rating no matter what setting I choose.

 

SiRk

Something strange I noticed tho: when I first opened the freshly downloaded version 30, the setting was at '2,2', while in the list the only allowed values are '2.1' and '2.2', so with point instead of comma. If I manually change it to '2,2', it does show a different value in M3 on the Settings tab, but it gives an error saying I can only enter a value from the list.

 

◊ Fola

Selecting:
Midnight Chestguard (The Leather Chest)

brings up the stats for:
Merciless Gladiator's Chain Armor


Is it possible that the Midnight Chestguard is not in the lookup array and it is just finding the closest match? I just made the adjustments in the hand adjustments, thought you might like to know though.

 

SiRk

I reproduced the problem I posted earlier on a Office 2002 environment. The first time I open the spreadsheet, the setting is at 2,2 (with comma), and the haste rating uses the correct modifier. But whenever I change the setting, I can only choose from 2.1 and 2.2 (with a point instead of a comma), and then whatever I choose, it keeps using the 2.1 haste rating modifier.

 

Cheeky

Is this a European version of Excel? I am positive I store the result as 2.2, but if the number gets converted to display as non-U.S. it might show up as 2,2 - which means that Excel isn't treating the list values I provide for validation as numbers (and converting them too) but as text strings.

I'll convert the whole thing to text strings later tonight. That should solve the problem.

Cheeky of Havoc

 

Trohck

Repeating this post from page 23, assuming it got lost in the shuffle.

 

SiRk

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

 

◊ Lactose

If your regional settings are set to Belgian, I think Excel still uses the Belgian format for decimals, which is with a comma, instead of a period.

Look, Lactose, we'd rather you didn't eradicate the whole human race.
- Sam & Max

 

Cranch

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.

 

◊ Kaubel

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

 

intrepidos

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.

 

◊ Lactose

Main posts updated.

In addition to links to the spreadsheet and previous versions of it, as well as change logs, there is now a list of bugged items. Please PM me or post in this thread if you know of any more, and I'll keep it updated.

This has been done to help bug fixing.

Look, Lactose, we'd rather you didn't eradicate the whole human race.
- Sam & Max

 

Fuulish

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

 

Cheeky

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 of Havoc

 

tict

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.

 

◊ Belac_K

STOP SIGNING YOUR POSTS

-T