working on a page that uses various foci and aa to determine spell stats.

http://home.comcast.net/~aelfin/downloads/spellData.html

no where near done, just putting it out there atm to get any feedback

will have heals and dots shortly, then other classes for comparison

i'll work GoM in at some point

it's all javascript atm. it ain't pretty yet, working on functionality first

works on IE, don't know about other browsers

your avg dmg is off a little. remember the absolute minimum dmg you can do on a nuke or dot with an enhancing focus effect is base + 1%.

so instead of avg = (base + max)/2
it should calculate ((base + base * .01) + max)/2

this does not apply to heals, you can have a base heal even with an enhancing focus effect.

I have no idea about mana preservation, but I suspect that'd take some pretty intense legwork to figure out.

i tried to fire it up in firefox 1.5 and the drop-downs didn't work. I pasted the link in IE and it worked fine. now to crunch some numbers!!


input
- rearrange chromatic nuke focus as first and have the specific nuke foci under it. i'd rather input the generic foci, fury of solusek, once rather than fill out ice/fire/magic THEN stumble across the chromatic one. doh!


- somehow create linebreaks or a visible line to separate the foci. my preference is to keep major effects bundled together.
spell haste
- general
- detrimental
- beneficial

i.e. group by mana preservation, spell haste, nuke foci, dot foci

- worth it to code for single-spell focus effects? i.e. sylvan anger, sylvan fire.

- would love to be able to sort results

- try to squeeze the input fields on top-half of page and have the results on the bottom so that you can get a one-page feel.

tenielle, ok, damage calculated that way
left mana as is, tho i think it prolly is similar

heals added.

tuppet: chromatic is for chromatic spells. akaik, only clerics have em(DoDh). i do not believe the focus does jack for druids. that and some of the other foci are there for when i add other classes spells... it's like the poison and disease foci... they don't do squat for us.

general foci are listed in with specific foci to make it easier for the code to just calculate. it does not look to see if you have generic plus specific and then use the greater. detrimental uses what you say you have for detrimental, etc.

i don't really intend to code for sylvan anger/fire. i may try to slip chloro in there but.... not atm.

sorting... not planned atm

squeezing info... yeah, once i get most the DATA in i'll go back and rearrange things, add a style sheet and generally make it prettier/easier to read

gotcha. i was thinking that a chromatic focus was a general focus, i.e. mana pres V versus a beneficial-only focus, or imp dmg V versus a fire-only focus.

any details on how you are calculating the numbers?

thanks for the info!!

umm, yeah. click view source and look at the calcs ;)

dots added.
power of the keepers/dark reign added.
spot for gom and abundant healing but not working yet.
will add other classes over next couple days.
will add some way to mod for stances.
it is a bit cleaner now, putting off the "make-it-pretty" as long as i can because i hate doing css.

Is it supposed to be Gift of Mana where it says Gift of Magic?

Btw, the drop down Foci menus do not work on Firefox.

thanks nim, changed it.

added cleric heals, wizard, mage, cleric nukes

added an option to see spells pre-"balance", just click "show old"

sorry bout firefox, if they implemented the dom properly it'd work :)

Be a developer! Put the druid in a stance!

Good stuff .. was working on something like that a while ago in excel but ended up putting it aside after laying down all the mod / aa info and not being able to decide a format for the spells.


For affliction haste you omitted anuek/dentri spell hastes which should effect all dots.

For Extended Affliction Wurine guard should be zombie malaise now.

Fire Improve Dmg and Fire burning affliction is missing vampiric fire (unless it was just ommited b/c it hasn't been found yet?)

Other than that might want to consider listing the max limit or have a drop down for the aa info maybe incase ppl can't remember how many lvls there are offhand.

Thanks Mellen, funny enough, I started with an excel sheet, too. But most people don't seem to want to d/l such a file. I figured a web page might be a bit more accessable.

Anyway: Foci. I have a database with spell info and item info. The item info comes from EQItems, the spell stuff comes from a join against dbstr_us.txt and Lucy spell info. Lucy hasn't updated their Live file since 11/18. That's why Wurin/Zombie are still swapped. Vamp fire is not listed because, indeed, no gear has it yet (found, that is). The foci I am currently listing *only* come from gear that druids can wear.

You have a full name on the anuek spell haste you mean? I may have something wrong in my db. I have a set of tables I join through that categorize the foci and score it for other stuff I do(Druid Focus Gear (http://home.comcast.net/~aelfin/downloads/DruidFocusList.txt) and General Druid Gear (http://home.comcast.net/~aelfin/downloads/DruidGear.txt)), I may not have that foci properly categorized.

Thanks for the idea on the AAs. I'll probably turn those into drop downs sometime tomorrow, as well as working GoM in.

Trying to figure out what class I want to put in next. I am thinking Necro and then Shaman.

An excellent page :)

How about catering for specilisation ? I would imagine that could be a nightmare.

Great page!

Magic Improve Damage is missing Discordant Energy

Description
1: Increase Spell Damage by 45%
2: Limit: Max Level(68) (lose 10% per level over cap)
3: Limit: Effect(Hitpoints allowed)
4: Limit: Min Duration(30.00 sec)
5: Limit: Spell Type(Detrimental only)
6: Limit: Target(AE PC v1 excluded)
7: Limit: Target(PB AE excluded)
8: Limit: Target(Targeted AE excluded)
9: Limit: Target(Uber Giants excluded)
10: Limit: Target(Uber Dragons excluded)
11: Limit: Resist(Magic allowed)
12: Limit: Combat Skills Not Allowed

Items with Discordant Energy wearable by Druids

Cloak of the Penumbra
Gaelin's Tunic of Woodlands
Serpent's Girdle

An excellent page :)

How about catering for specilisation ? I would imagine that could be a nightmare.

not particularly. but i would lock it to 200 for the main, 100 for the 2ndary, and 50 for the rest. the only reason i have not put it in there is, well, i am not really sure what it does.

can someone fill me in on exactly what they do? i thought just fizzle rate and maybe small mana savings... not sure what %s and or what else.

Great page!

Magic Improve Damage is missing Discordant Energy

Description
1: Increase Spell Damage by 45%
2: Limit: Max Level(68) (lose 10% per level over cap)
3: Limit: Effect(Hitpoints allowed)
4: Limit: Min Duration(30.00 sec)
5: Limit: Spell Type(Detrimental only)
6: Limit: Target(AE PC v1 excluded)
7: Limit: Target(PB AE excluded)
8: Limit: Target(Targeted AE excluded)
9: Limit: Target(Uber Giants excluded)
10: Limit: Target(Uber Dragons excluded)
11: Limit: Resist(Magic allowed)
12: Limit: Combat Skills Not Allowed

Items with Discordant Energy wearable by Druids

Cloak of the Penumbra
Gaelin's Tunic of Woodlands
Serpent's Girdle

Taeyn, I do not think that affects magic-based direct damage. i bolded the line i believe makes it good for DOTs only. it *is* available in magic-based burning affliction.

if i am wrong, lemme know.

Taeyn, I do not think that affects magic-based direct damage. i bolded the line i believe makes it good for DOTs only. it *is* available in magic-based burning affliction.

if i am wrong, lemme know.
Ah, I missed the min duration limit. Definitely sounds like bug DoTs.

yeah, that's part of the reason GoD tunic has never been appealing to me :/

anyway, GoM working now. it should be absolutely correct for nukes and heals... that is, it recalcs total time in a loop in case more GoMs can proc. DoTs... due to the nature of their mps vs mana regen, well... I took the lazy way out.

also, used mellen's suggestion for dropdowns for AAs

With Pyrilen Rage (35% foxus) you have max Crit for Vengeance of the Sun listed as 968. The max should be around 1.1k.

I think you are applying the crit against base damege only i.e. like our nukes. For DoTs the crit applies after any focus effect is taken into account.

wow. i didn't know that. thanks, seeker. fixed.

Specialization:
Skill of 50 = 2% mana savings (2.5 maybe?)
Skill of 100 = 5% mana savings
Skill of 200 = 10% mana savings

These are constants. They don't vary like mana pres does.

Alacrity of the Aneuk (http://lucy.allakhazam.com/spell.html?id=6477&source=Test)
Quickening of the Aneuk (http://lucy.allakhazam.com/spell.html?id=6463&source=Test)
Hastening of the Aneuk (http://lucy.allakhazam.com/spell.html?id=6449&source=Test)
Speed of the Aneuk (http://lucy.allakhazam.com/spell.html?id=6435&source=Test)

Should all work on dots for haste


Specialization:
Skill of 50 = 2% mana savings (2.5 maybe?)
Skill of 100 = 5% mana savings
Skill of 200 = 10% mana savings

I believe it's actually 3, 6, and 11 respectively. Don't have the sheet with the notes I used to confirm those numbers but the exceel sheet I was working on has them at those numbers. SCM3 was marked as 10 though, if it's actually 11 then 2/5/10 would be correct.

I've always thought of it as 3, 6, 11% for spec as well.

Should be fairly easy to confirm. I know that KR costs me 504 mana with spec 100 & SCM3 (10% I believe), which seems to back up the 6% figure.

just got back from xmas travel. gimme a day or two and i'll have a new version out with updated foci and look into specialization.

problem with specialization is i'll have to add a field to every spell. may take a bit, i'll think on it.

Alacrity of the Aneuk (http://lucy.allakhazam.com/spell.html?id=6477&source=Test)
Quickening of the Aneuk (http://lucy.allakhazam.com/spell.html?id=6463&source=Test)
Hastening of the Aneuk (http://lucy.allakhazam.com/spell.html?id=6449&source=Test)
Speed of the Aneuk (http://lucy.allakhazam.com/spell.html?id=6435&source=Test)

Should all work on dots for haste


ok, added these. threw Quickening of the Dead in there, too.
vampiric fire and zombie malaise added

been too lazy and sick to rework all the spells to add a skill field (for alt/evo/conj/abj/etc)

ok, did some reworking.

tuppet, you can now sort on any column of any table. it is indeed nice to be able to sort, thanks for the suggestion, sorry it took me a while to add.

spells are reworked and now hold range and skill information. i just haven't done anything with it yet. i'll add range foci eventually and then calc range.

for skills, thanks spiritis and mellen. lemme confirm with ranges. if a specialized skill is between:
0-49 = 0% mp
50-99 = 3% mp
100-199 = 6% mp
200 = 11% mp

lemme know if that is correct and i'll see what i can do.

i also added Necro DoTs. i'm not too familiar with the necro line and i was interrupted frequently while entering that data. if someone finds errors, lemme know.

added ability to copy html to clipboard. hadn't noticed vBulletin allowed tables until seeing Cassea posts some. now you can paste info directly here!

i bet the admins/mods will just love this :texla:

example, nukes with max mods and aa:

<table border = '1' class = 'sortable' id = 'druidNeutralNukes'><tr><th>level<th>spell<th>cast<th>adj cast<th>recast<th>total cast<th>mana<th>min mana<th>avg mana<th>base dmg<th>max dmg<th>avg dmg<th>max crit<th>avg crit<th>mps<th>dpm<th>dps<th>d/m/s<th><th>time<th>casts<th>crits<th>dmg<th>mps<th>dpm<th>dps<th>d/m/s</tr><tr><td>70</td><td nowrap bgcolor='#6080f0'>A. Glacier Frost</td><td>6.35</td><td>4.25</td><td>2.25<td>6.50</td><td>405</td><td>284</td><td>324</td><td>2042</td><td>3267</td><td>2660</td><td>5819</td><td>5213</td><td style='color: blue'>49.81</td><td style='color: purple'>8.21</td><td style='color: red'>408.95</td><td style='color: green'>126.22%</td><td bgcolor='black'>&nbsp;</td><td>351.24</td><td>54</td><td>10</td><td>169170</td><td style='color: blue'>45.20</td><td style='color: purple'>10.66</td><td style='color: red'>481.63</td><td style='color: green'>163.82%</td></tr><tr><td>70</td><td nowrap bgcolor='#f08060'>Dawnstrike</td><td>7.00</td><td>4.69</td><td>2.25<td>6.94</td><td>482</td><td>338</td><td>386</td><td>2125</td><td>3400</td><td>2768</td><td>6056</td><td>5425</td><td style='color: blue'>55.62</td><td style='color: purple'>7.17</td><td style='color: red'>398.85</td><td style='color: green'>103.33%</td><td bgcolor='black'>&nbsp;</td><td>298.42</td><td>43</td><td>8</td><td>140280</td><td style='color: blue'>50.45</td><td style='color: purple'>9.32</td><td style='color: red'>470.08</td><td style='color: green'>134.27%</td></tr><tr><td>70</td><td nowrap bgcolor='#6080f0'>Glitterfrost</td><td>6.35</td><td>4.25</td><td>2.25<td>6.50</td><td>381</td><td>267</td><td>305</td><td>1892</td><td>3027</td><td>2465</td><td>5392</td><td>4830</td><td style='color: blue'>46.89</td><td style='color: purple'>8.08</td><td style='color: red'>378.97</td><td style='color: green'>124.25%</td><td bgcolor='black'>&nbsp;</td><td>390.27</td><td>60</td><td>11</td><td>173915</td><td style='color: blue'>42.20</td><td style='color: purple'>10.56</td><td style='color: red'>445.63</td><td style='color: green'>162.34%</td></tr><tr><td>69</td><td nowrap bgcolor='#f08060'>Solstice Strike</td><td>6.25</td><td>4.19</td><td>2.25<td>6.44</td><td>494</td><td>346</td><td>396</td><td>2201</td><td>3521</td><td>2867</td><td>6272</td><td>5619</td><td style='color: blue'>61.51</td><td style='color: purple'>7.24</td><td style='color: red'>445.36</td><td style='color: green'>112.46%</td><td bgcolor='black'>&nbsp;</td><td>263.94</td><td>41</td><td>8</td><td>139563</td><td style='color: blue'>55.51</td><td style='color: purple'>9.53</td><td style='color: red'>528.77</td><td style='color: green'>147.96%</td></tr><tr><td>68</td><td nowrap bgcolor='#f060f0'>Desolate Summoned</td><td>5.00</td><td>3.35</td><td>2.25<td>5.60</td><td>357</td><td>250</td><td>286</td><td>1857</td><td>2971</td><td>2419</td><td>5292</td><td>4740</td><td style='color: blue'>51.07</td><td style='color: purple'>8.46</td><td style='color: red'>431.96</td><td style='color: green'>151.04%</td><td bgcolor='black'>&nbsp;</td><td>341.60</td><td>61</td><td>12</td><td>175411</td><td style='color: blue'>46.05</td><td style='color: purple'>11.15</td><td style='color: red'>513.50</td><td style='color: green'>199.13%</td></tr><tr><td>65</td><td nowrap bgcolor='#6080f0'>A. Chaos Frost</td><td>6.35</td><td>4.25</td><td>2.25<td>6.50</td><td>290</td><td>203</td><td>232</td><td>1450</td><td>2320</td><td>1889</td><td>4132</td><td>3701</td><td style='color: blue'>35.67</td><td style='color: purple'>8.14</td><td style='color: red'>290.41</td><td style='color: green'>125.18%</td><td bgcolor='black'>&nbsp;</td><td>591.91</td><td>91</td><td>17</td><td>202703</td><td style='color: blue'>32.14</td><td style='color: purple'>10.66</td><td style='color: red'>342.46</td><td style='color: green'>163.81%</td></tr><tr><td>65</td><td nowrap bgcolor='#f060f0'>Destroy Summoned</td><td>5.00</td><td>3.35</td><td>2.25<td>5.60</td><td>286</td><td>201</td><td>229</td><td>1350</td><td>2160</td><td>1759</td><td>3847</td><td>3446</td><td style='color: blue'>40.89</td><td style='color: purple'>7.68</td><td style='color: red'>314.11</td><td style='color: green'>137.16%</td><td bgcolor='black'>&nbsp;</td><td>481.60</td><td>86</td><td>16</td><td>178266</td><td style='color: blue'>36.61</td><td style='color: purple'>10.11</td><td style='color: red'>370.15</td><td style='color: green'>180.53%</td></tr><tr><td>65</td><td nowrap bgcolor='#f08060'>Sylvan Fire</td><td>6.25</td><td>4.19</td><td>2.25<td>6.44</td><td>435</td><td>305</td><td>348</td><td>1761</td><td>2817</td><td>2294</td><td>5018</td><td>4495</td><td style='color: blue'>54.06</td><td style='color: purple'>6.59</td><td style='color: red'>356.35</td><td style='color: green'>102.40%</td><td bgcolor='black'>&nbsp;</td><td>315.44</td><td>49</td><td>9</td><td>132215</td><td style='color: blue'>48.54</td><td style='color: purple'>8.63</td><td style='color: red'>419.15</td><td style='color: green'>134.13%</td></tr><tr><td>65</td><td nowrap bgcolor='#6080f0'>Winter's Frost</td><td>6.35</td><td>4.25</td><td>2.25<td>6.50</td><td>305</td><td>214</td><td>244</td><td>1357</td><td>2171</td><td>1768</td><td>3867</td><td>3464</td><td style='color: blue'>37.51</td><td style='color: purple'>7.25</td><td style='color: red'>271.81</td><td style='color: green'>111.40%</td><td bgcolor='black'>&nbsp;</td><td>546.38</td><td>84</td><td>16</td><td>175648</td><td style='color: blue'>33.94</td><td style='color: purple'>9.47</td><td style='color: red'>321.48</td><td style='color: green'>145.62%</td></tr><tr><td>64</td><td nowrap bgcolor='#f08060'>Summer's Flame</td><td>6.25</td><td>4.19</td><td>2.25<td>6.44</td><td>395</td><td>277</td><td>316</td><td>1600</td><td>2560</td><td>2084</td><td>4560</td><td>4084</td><td style='color: blue'>49.09</td><td style='color: purple'>6.59</td><td style='color: red'>323.73</td><td style='color: green'>102.45%</td><td bgcolor='black'>&nbsp;</td><td>315.44</td><td>49</td><td>9</td><td>120116</td><td style='color: blue'>49.09</td><td style='color: purple'>7.76</td><td style='color: red'>380.79</td><td style='color: green'>120.50%</td></tr><tr><td>60</td><td nowrap bgcolor='#f08060'>A. Starfire of Ro</td><td>6.25</td><td>4.19</td><td>2.25<td>6.44</td><td>300</td><td>210</td><td>240</td><td>1350</td><td>2160</td><td>1759</td><td>3847</td><td>3446</td><td style='color: blue'>37.28</td><td style='color: purple'>7.33</td><td style='color: red'>273.24</td><td style='color: green'>113.85%</td><td bgcolor='black'>&nbsp;</td><td>469.94</td><td>73</td><td>14</td><td>152025</td><td style='color: blue'>37.28</td><td style='color: purple'>8.68</td><td style='color: red'>323.50</td><td style='color: green'>134.79%</td></tr><tr><td>60</td><td nowrap bgcolor='#6080f0'>Moonfire</td><td>6.35</td><td>4.25</td><td>2.25<td>6.50</td><td>263</td><td>185</td><td>211</td><td>1132</td><td>1811</td><td>1474</td><td>3226</td><td>2889</td><td style='color: blue'>32.44</td><td style='color: purple'>6.99</td><td style='color: red'>226.61</td><td style='color: green'>107.40%</td><td bgcolor='black'>&nbsp;</td><td>585.41</td><td>90</td><td>17</td><td>156715</td><td style='color: blue'>32.44</td><td style='color: purple'>8.25</td><td style='color: red'>267.70</td><td style='color: green'>126.87%</td></tr><tr><td>59</td><td nowrap bgcolor='#f08060'>Wildfire</td><td>6.25</td><td>4.19</td><td>2.25<td>6.44</td><td>335</td><td>235</td><td>268</td><td>1294</td><td>2070</td><td>1686</td><td>3687</td><td>3303</td><td style='color: blue'>41.63</td><td style='color: purple'>6.29</td><td style='color: red'>261.90</td><td style='color: green'>97.72%</td><td bgcolor='black'>&nbsp;</td><td>399.13</td><td>62</td><td>12</td><td>123936</td><td style='color: blue'>41.63</td><td style='color: purple'>7.46</td><td style='color: red'>310.52</td><td style='color: green'>115.87%</td></tr></table>

ok, skill specialization is in. hope it's right. necro nukes added. more necro dots. few more druid nukes and dots.

some shaman data is in. heals/nukes/dots. damn their ch sucks.

your avg dmg is off a little. remember the absolute minimum dmg you can do on a nuke or dot with an enhancing focus effect is base + 1%.

Maybe I'm crazy, but every so often, I'll have my DoTs not register with the Glowing Stone of Expulsion for a tick. At this time they only do the base damage (or double if it is a crit).

Im assumeing that this doesnt account for dawnstrikes double damage proc, because im fairly sure that there is no way soltice strike or a:Glacierfrost could out dps it.

yes, the proc is accounted for. and yes, SS and GF can out dps dawnstrike frequently.

was a while back when this was discussed, but it goes something like this: you have a 20% chance to proc, and the result is 1-100% damage (average of 50%). basically, over time, this amounts to a 10-12% percent increase of dawnstrike dps if you are chain casting it.

Thanks for the calculator and the effort put into this ;)

Calculations for Healing Foci (mine for this example is Discordant Healing - 45% up to lvl 68, -10% per lvl) seem to bit a bit off however, especially the Crits.

I entered Power of the Keepers, Healing Gift 9 and Healing Adept 9, and Discordant Healing (Qvic Arms) as Focus.

Chlorotrope as an example: the avg. normal heal seems to be just about right with 4.2k, but I definately had higher max heals then 4861 (was very close to 5k iirc, like 4980).

Crits should be double the healpower then, but in the table the max crit shows up with 7671 (at least for me), where it should be over 9.5k, close to 10k.

The other spells show the same behaviour: normal heals just a tad weaker then in the game, crits way too low.

Did I enter something wrong?

no, you are not wrong. bug somewhere in the crit logic for heals.
i currently have:
maxCrit = Math.floor(heal * 2 + (ha * heal) + (ih * heal));
i am thinking the *2 multiplier is in the wrong place. anyone know for sure?

cleric max ch crit is also wrong, not sure what limits it to 19200.

edit:
i've changed maxcrit and avgcrit to be:
maxCrit = Math.floor(heal + (ha * heal) + (ih * heal)) * 2;
avgCrit = Math.floor(heal + (ha * heal) + (ih * heal / 2)) * 2;
the numbers look more correct and in-line with what i have seen.
anyone feel free to correct my math if it's still wrong.

edit 2:
as far as your specific example, max heal no crit should indeed be:
2810 + (2810 * .28) + (2810 * .45) = 4861.3

Looks like the math fits now, many thanks ;)

As for my max heal, my guess is I had a paladin with Aura in group when I landed it, 4861 is most likely the standard max heal.