 |
09/19/07, 12:18 PM
|
#766
|
|
Glass Joe
Orc Death Knight
Frostmane (EU)
|
Originally Posted by Cheeky
Is this a European version of Excel?.
|
The excel 2007 on my machine is American, but the excel 2002 I used is a belgian version.
|
|
|
|
|
09/19/07, 2:31 PM
|
#767
|
|
Don Lactose
Tauren Hunter
Talnivarr (EU)
|
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
|
|
|
09/19/07, 8:35 PM
|
#768
|
|
Don Flamenco
|
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.
Last edited by Cranch : 09/19/07 at 8:52 PM.
|
|
|
|
|
09/19/07, 10:03 PM
|
#769
|
|
Sledgehammer Emeritus
|
Originally Posted by Cranch
stuff
LOL
stuff
|
Just in case you were wondering, I've emphasized what you need to stop posting here.
|
|
|
|
|
09/20/07, 9:47 AM
|
#770
|
|
Von Kaiser
|
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.
|
|
|
|
|
09/20/07, 2:30 PM
|
#771
|
|
Don Lactose
Tauren Hunter
Talnivarr (EU)
|
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
|
|
|
09/20/07, 9:20 PM
|
#772
|
|
Glass Joe
|
re: v30 of Cheeky's
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
|
|
|
|
|
09/20/07, 9:38 PM
|
#773
|
|
Great Tiger
Cheeky
Troll Hunter
No WoW Account
|
Originally Posted by 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
|
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.
|
|
|
|
09/21/07, 7:51 PM
|
#774
|
|
Von Kaiser
Night Elf Hunter
Moonrunner
|
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.
Last edited by tict : 09/22/07 at 8:00 PM.
|
|
|
|
|
09/22/07, 6:34 AM
|
#775
|
|
Evil Nazi Archeologist
|
|
|
|
|
|
09/23/07, 1:13 AM
|
#776
|
|
Glass Joe
|
Originally Posted by 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.
|
Oh I didn't realize you could already name the sets. Sorry about that. Could you tell me how?
|
|
|
|
|
09/23/07, 2:21 AM
|
#777
|
|
Great Tiger
Cheeky
Troll Hunter
No WoW Account
|
Originally Posted by Fuulish
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.
|
|
|
|
09/24/07, 7:39 AM
|
#778
|
|
Glass Joe
Blood Elf Paladin
Nathrezim
|
Error in loading DLL occurs when I try to open the 2 newest files in Excel:Mac 04. Haven't tried the older ones.
Last edited by mickeyknox : 09/24/07 at 7:44 AM.
|
|
|
|
|
09/24/07, 10:03 AM
|
#779
|
|
Great Tiger
Cheeky
Troll Hunter
No WoW Account
|
Originally Posted by mickeyknox
Error in loading DLL occurs when I try to open the 2 newest files in Excel:Mac 04. Haven't tried the older ones.
|
Not sure what I can do to help with that. I don't have access to a Mac, so I can't even try to reproduce this problem. Any other Mac users having trouble?
|
|
|
|
09/24/07, 10:14 AM
|
#780
|
|
Glass Joe
Blood Elf Paladin
Nathrezim
|
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.
|
|
|
|
|
|