Elitist Jerks Hunter Spreadsheets -- In development

09/19/07, 12:18 PM   #766
SiRk
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 Lactose Don Lactose     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 Cranch Don Flamenco   Cranch Dwarf Hunter   Perenolde 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
Kaubel
Sledgehammer Emeritus

Tauren Druid

Mal'Ganis
 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 intrepidos Von Kaiser     Separhate Blood Elf Priest   Eredar 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 Lactose Don Lactose     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 Fuulish Glass Joe   Dagnutz Orc Shaman   Hyjal 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
Cheeky
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 tict Von Kaiser   Tict 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 • Belac_K Evil Nazi Archeologist     Tamahagane Undead Priest   Mal'Ganis
09/23/07, 1:13 AM   #776
Fuulish
Glass Joe

Orc Shaman

Hyjal
 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
Cheeky
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 mickeyknox Glass Joe   ihasabubble 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
Cheeky
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 mickeyknox Glass Joe   ihasabubble 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.

 Elitist Jerks Hunter Spreadsheets -- In development