DDO information project/Magic

=The DDO numbers project=

Turbine has not released the detailed numerical effects of all spells (well, now they have, but many are wrong). One major goal is to find them out by ourselves. I suggest the following: try to use a spell as many times as you think necessary, each time writing down any numerical effect you can measure (e.g. the damage, the duration, etc.). Then come back to this very same page and copy your numbers here, with any relevant information that would be necessary to interpret them. Once we have enough numbers, we can deduce the exact formulas used by Turbine. For offensive spells, I suggest to stick to the normal difficulty and to standard monsters, in order to make comparisons easier (another solution is to study the effect of the spell when it is cast on you by an opponent). For distances, see the talk page of this topic for a suggestion I made earlier. Among the relevant information related to a spell's effect, don't forget to mention for instance your casting ability, your potential enhancements that may change the results, etc.

Just add below a new subsection for each spell, in alphabetical order. Don't worry if you cannot find out how to interpret the results, all we need is raw data.

A similar project for arcane spells can be found here: http://www.ddo.com/forums/showthread.php?t=4356  The wiki section for the wizard and sorcerer spells is being updated as information becomes available.

Acid Splash

 * Caster: Kobold Shaman CR1 (normal) on 4 HD character
 * Effect: 1,1,1 Acid damage

Aid

 * Cleric L5, Wis 18: +13 HP and bless effect for 5 mins
 * Cleric L6, Wis 18: +14 HPs and bless effect for 6 mins
 * Cleric L7, Wis 18: +15 HPs, bless effect for 7 mins

All L1 cleric spells

 * Have 2s cooldown, except Summon monster I (60s)

All L2 cleric spells

 * Have 4s cooldown, except Summon monster II (120s)

All L3 cleric spells

 * Have 6s cooldown, except Summon monster III (180s), Blindness and Remove blindness (4s)

Bless
Current belief: +1 luck attack bonus, 1 min/level, need to figure out the save vs. fear bonus


 * Cleric L1, Wis 14: +1 attack bonus, 1 min
 * Most likely a mistake (a L2 cleric should double-check): Cleric L2, Wis 14: +2 attack bonus, 2 min, cooldown 2s
 * Cleric L3, Wis 14: +1 attack bonus, 3 min
 * Cleric L5: +1 luck attack bonus, 5 min

Cause fear

 * Note: read on the ddo forums that the effect may disminish when cast more than once, but this does not appear to be true
 * You must face your target in order to cast the spell, also attacking the feared target will not dispel the fear effect
 * Caster: Kobold Shaman CR1 (normal) on 4 HD character
 * Effect on successful will save: Shaken for 5 seconds. Multiple castings reset the duration to 5 sec but don't increase it further
 * Shaken effect: -2 Attack, -2 on saves, -2 skills


 * Cleric L5, Wis 18
 * on Kobold rogue in Sewer rescue: (very) approximate duration of Fear is (in seconds): 6, save, 6, 9, >0, 49 (with extend spell), >0, 20
 * on Kobold in Sewer rescue: 6, 12, save, save, 18 (extend), 48 (extend), 50 (extend), 12, 24, 12, 14, save, 20, 26, 14, 23, 25, 6, 7, >0, save, 24, 18

Chill touch
Current belief: 1d3+3/level (max=?), half damage on suc. refl save, -1 STR on failed fort save
 * Caster: Gertis Apprenctice (Missing Ward) CR1 (normal) on 4 HD character
 * Effect: 2,3,2,2,3,3,2,2,3,2,3,2,2 negative Energy Damage on suc. reflex save
 * Effect: 5,6 negative Energy Damage on failed reflex save
 * Effect: -1 Str on failed fort save


 * Caster: Gertis Apprenctice (Missing Ward) CR1 (hard) on 4 HD character
 * Effect: 2,2,2,2,2,3,2,2,2,3,3,2,2,2,2 negative Energy Damage on suc. reflex save
 * Effect: 4,5 negative Energy Damage on failed reflex save
 * Effect: -1 Str on failed fort save


 * Caster: Necromancer Gerti (Missing Ward) CR2 (normal) on 4 HD character
 * Effect: 6,5,4,5,5,5,4,5,4,5,5,5,6,5 negative Energy Damage on suc. reflex save
 * Effect: 10,10 negative Energy Damage on failed reflex save
 * Effect: -1 Str on failed fort save

Command

 * Cleric L5, Wis 18, on Kobold in Sewer rescue: duration of stun is approximately (in seconds) 5, 6, 6, 5, save, 6, save, 6, 13 (extend spell), 6

Cure light wounds
Current belief: 1d6 + 2 + min(caster level, 5), needs more experiments as damage spell to assess its efficiency against undead.

Analysis: 4(0.16) 6(0.16) 7(0.18) 8(0.14) 9(0.22) 10(0.13) compared to expected: 4(0.17) 6(0.17) 7(0.17) 8(0.17) 9(0.17) 10(0.16) => hypothesis confirmed Analysis: seems coherent with expected 10(0.17) 11(0.17) 13(0.17) 14(0.17) 15(0.17) 16(0.16) Analysis: 10(0.10) 11(0.21) 13(0.16) 14(0.12) 15(0.14) 16(0.28) compared to expected: 10(0.17) 11(0.17) 13(0.17) 14(0.17) 15(0.17) 16(0.16) => weird proportion of 16, more data are needed Analysis: 10(0.13) 11(0.15) 13(0.15) 14(0.23) 15(0.23) 16(0.11) mean=13.32 compared to expected 10(0.17) 11(0.17) 13(0.17) 14(0.17) 15(0.17) 16(0.16) mean=13.15 (note: simulation has shown such variance compared to expected is normal) Analysis: 13(0.21) 15(0.24) 17(0.03) 18(0.14) 20(0.14) 22(0.24) mean=17.45 compared to expected 13(0.17) 15(0.17) 17(0.17) 18(0.17) 20(0.17) 22(0.16) mean=17.48
 * Cleric L1, Wis 14 on non warforged: 9,7,7,5,8,9,9,6,8,5,7,9,9,6,8,9,7
 * Same with devotion 1: 7,7,6,9,9,6,6,8,6,8,9,9,8,8,6,7,4,4,7,8,9,4,9,6,7,9,9,9,8,9,7,10,7,8,10,10,10,4,8,8,7,9,9,7,4,10,7, 4,6,4,9,9,9,6,6,8,10,10,7,7,4,6,10,9,10,9,8,6,6,9,4,6,6,7,8,7,7,9,4,4,4,10,10,9,7,8,9,7,6,6,10,4,8,4,10,4,4
 * Same on warforged: 6,3,4,4,5,5
 * Did further experiments at L2 and L3 that confirmed the above formula
 * Cleric L5, Wis 18, Improved Devotion II: 16,10,14,15,10,14,13,11,13,16, 11, 14, 11, 16, 14, 16, 13, 13, 10,14,11,16,15,11,10,14,11,11, 10,15
 * Cleric L1, Wis 14, damage on skeleton in newbie area: 2,3,6,5
 * Cleric L6, Wis 18, Improved Devotion II, Tihocan 14:02, April 7, 2006 (EDT): 16, 10. Next batch (Tihocan 14:00, April 11, 2006 (EDT)): 10,15, 16,11, 16, 15,15,14,14,16,11, 16,14,11, 11,13,16,13,13,11, 16,11,15,11,15,13,16,16, 13,10,11,15, 16,16,16,16, 16, 15,10,13,14, 16,14,11, 13,14, 10,14,13, 16,15, 11,11, 10,11, 13
 * Cleric L6, Wis 18, Imp Dev II (April 2006): 10,16,15,14,14, 16,15,13,14,15,15,15, 13,14, 15,11, 15, 10, 13,13,14, 10,11,14,10,13,14,16, 11,13,14,10,13,14,13, 11, 10, 15,13,10,14,14,16, 14,16,15, 13,11, 16,14, 14,15,15, 16, 10,15,13, 16,11,14,14, 11,13, 16,10,15,13,15,11, 15,15, 11,15,15, 14,13,14,14,15, 14,10,15,14,16,13, 11,15, 15,15,15, 11,11, 10, 11,11,13,16, 15,11, 14,10, 15,11, 10, 10,13, 10, 11,16,14,14,14, 15,14, 13, 16,10,14,11, 15
 * Cleric L7, Wis 18, Great Dev II, Ring of Imp. Dev II (total * 1.7 effect on CLW) (April 2006): 13,22, 18,18,20,17,15,20,22, 22,18,22,13,13,13, 20,13,15,15,13,22,20, 15,22,15,22,18,15,15

Comments
Two comments:
 * First note the results of each roll with an enhancement modifier are truncated not rounded so 11.9 heals 11 not 12.
 * Yes I know about that. This is taken into account in the expected numbers above. Tihocan 10:59, April 5, 2006 (EDT)


 * Second, weapon enhancement adds to the taken enhancement. Thus, CLW with a character with devotion (+20%) and a crossbow with greater devotion (+40%) imporves by 60%.  The complete equation including enhancements is:

(1d6 + 2 + 1/level) x (1 + taken enhancement + weapon enhancement)

100 rolls with Devotion II plus Greater Devotion I weapon is: 12(0.15) 14(0.15) 16(0.16) 17(0.17) 19(0.17) 20(0.20) 58 rolls with Greater Devotion I plus Greater Devotion I weapon is:14(0.17) 16(0.16) 18(0.16) 19(0.14) 21(0.16) 23(0.19) 


 * I assume you are level 5? Your numbers are indeed close to the expected value, which (simulated on 100000 rolls), would be respectively 12(0.17) 14(0.17) 16(0.17) 17(0.17) 19(0.17) 20(0.16) and 14(0.17) 16(0.17) 18(0.17) 19(0.17) 21(0.17) 23(0.16). Tihocan 10:59, April 5, 2006 (EDT)


 * Yes, the above data taken with the Greater Devotion crossbow are from level 5 cleric 


 * Thanks, then it's coherent. Note that, even if you're not logged in, you can sign your posts with ~ Tihocan 10:41, April 6, 2006 (EDT)

Cure moderate wounds
Current belief: 2d6 + 4 + 1/level (max +x, x>=7), needs experiments at levels higher than 7

Analysis: (0.04) 10(0.02) 11(0.08) 12(0.14) 13(0.18) 14(0.16) 15(0.19) 16(0.13) 17(0.02) 18(0.03) 19(0.01) compared to expected: 9(0.03) 10(0.06) 11(0.08) 12(0.11) 13(0.14) 14(0.17) 15(0.14) 16(0.11) 17(0.08) 18(0.05) 19(0.03) => hypothesis confirmed (would just need a larger sample to get closer to expected)
 * Cleric L3, Wis 14: 16,16,14,16,9,15,14,18,15,16,12, 14,15,12,14,14,13,15,9,14,16, 13,17,13,16,15,15,13, 11,15,11,14,15,14,13,12, 14,11,9,11,15,13,19,13,15,14, 16,11, 15,13,15,18,9,13,11, 16,13,15,15,12,12,13, 12,12,11,17,16,15,12,13,14,13,12, 13,12,15,14,16,14,13, 11, 15,15,14,13,18,12,13,12,12, 10, 16,16, 14,10

Analysis: coherent with expected 14(0.03) 15(0.06) 16(0.08) 18(0.11) 19(0.14) 20(0.17) 22(0.14) 23(0.11) 24(0.08) 26(0.05) 27(0.03)
 * Cleric L5, Wis 18, Imp. Dev. II: 16,18,19,15, 16,22, 15,26,18,23,26,19,20,15, 23,16,16,18, 20, 23, 23, 22, 22, 22, 16, 26, 26, 22


 * Cleric L5, Wis 18, Imp. Dev. II (Tihocan 14:02, April 7, 2006 (EDT)): 22, 18, 26, 23

Analysis: 22(0.04) 23(0.04) 25(0.04) 27(0.20) 28(0.12) 30(0.16) 32(0.12) 34(0.12) 35(0.04) 37(0.04) 39(0.08) mean=30.28 compared to expected 22(0.03) 23(0.06) 25(0.08) 27(0.11) 28(0.14) 30(0.17) 32(0.14) 34(0.11) 35(0.08) 37(0.05) 39(0.03) mean=30.13
 * Cleric L7, Wis 18, Greater Dev II and Ring of Improved Dev II (total * 1.7 CMW) (April 2006): 32, 27, 27,27, 39,30,39, 22,32, 25,30,34,27, 30,28,28,35, 23,28,34,37, 27,32, 30,34

Cure serious wounds
Current belief: 3d6 + 6 + 1/level (max +x, x>=5), needs experiments at levels higher than 5

Analysis: coherent with expected 14(0.00) 15(0.01) 16(0.03) 17(0.05) 18(0.07) 19(0.10) 20(0.12) 21(0.13) 22(0.13) 23(0.11) 24(0.10) 25(0.07) 26(0.05) 27(0.03) 28(0.01) 29(0.00)
 * Cleric L5, Wis 18: 15,18,21,21,23,22,24, 19,19,19, 23, 22,23,17,22, 26,24,18,28,23,21, 23

Death ward

 * Cleric L7, Wis 18 (April 2006): lasts 3 min 24s (extend spell might have been activated)

Divine favor

 * Cleric L3, Wis 14: +2 attack bonus for 1 min
 * Cleric L5, Wis 18: +2 attack bonus for 1 min
 * Str 10, attacking Kobold rogue with fists in Sewer rescue without Divine favor => damage 2,2,2,1,2,1, 2,2,1,1,1,1, 1,2,1, 1,2,1 1,1,1, 2, 2,1, 2
 * Same but with Divine favor => 3,4,4,4, 3,4, 3
 * Cleric L6, Wis 18 (April 2006): +3 attack and +3 damage for 1 min
 * Cleric L7, Wis 18 (April 2006): +3 attack and +3 damage for 2 mins (note: I might have activated the extend spell feat)

Divine Power

 * Cleric L7, Wis 18 (April 2006): lasts 42s (might have activated the extend spell feat), gives +2 Str and +2 HPs

Find traps

 * Cleric L7, Wis 18 (April 2006): lasts 7 mins

Hold person

 * Cleric L5, Wis 18, on Kobold rogue in Sewer Rescue, lasts approximately (in seconds): 30, 8, 28, 30, 7, save, 22 (note: probably ends with a successful save)
 * Same context: critical hit on every hit while the target was held (even a 3 was hitting, but a 1 was a miss)

Inflict light wounds

 * Cleric L5, Wis 18
 * Kobold in Sewer rescue: 11,4,9,5,5,8,8, 10,11,6,11,10,8, 8,9,4, 9,9,10,13,13, 11,11, 10
 * Kobold rogue in Sewer rescue: 6,13,9,8,11, 8,5,5,13, 11, 4,5,6, 9, 10, 8, 13,11
 * Yrassil in Sewer rescue: 12, 9,6,12

Lesser restoration
Current belief: According to the PnP rules, should restore 1d4 temporary stat damage. Needs a lot more experiments with various kinds of stat damage to see exactly how much it restores, and what other beneficial effects it has.


 * Cleric L3, Wis 14: restoring stat damage due to poison: 1
 * Cleric L5, Wis 18: restoring stat damage due to poison: 2
 * Cleric L5, Wis 18: dispells Ray of enfeeblement
 * Cleric L6, Wis 18 (Tihocan 13:53, April 11, 2006 (EDT)): restores stat damage for: 3, 6
 * FvS L5, Wis ?: dispells Touch of Idiocy

Magic missile

 * Caster: Kobold Shaman CR1 (normal) on 4 HD character
 * Effect: 4,5,5,5,5,5 Damage, no save


 * Caster: Shaman Shiress (Garrison's Missing Pack) (normal) on 4 HD character
 * Effect: 4,5,5,5,5,4

Protection from Energy

 * Cleric L5, Wis 18: 1 min 30

Protection from evil

 * Cleric L1, Wis 14: 1 min
 * Cleric L5, Wis 18: 5 mins

Ray of enfeeblement

 * Caster: Gertis Apprenctice (Missing Ward) CR1 (normal) on 4 HD character
 * Effect: -6 Str, no save, duration: 1 minute


 * Caster: Necromancer Gerti (Missing Ward) CR2 (normal) on 4 HD character
 * Effect: -6 Str, no save, duration: 2 minutes

Remove Fear

 * Cleric L5, Wis 18: 10 mins, dispells fear, dispells doom, extend spell does not affect it
 * (Tihocan 13:53, April 11, 2006 (EDT)) As of now Remove fear is now properly extended by the extend spell metamagic feat

Resist energy

 * Cleric L3: lasts 3 mins
 * Cleric L5: lasts 5 mins

Searing light

 * Cleric L5, Wis 18
 * Kobold in Sewer rescue: 13, 12, 11, 13
 * Kobold rogue in Sewer rescue: 12, 12, 14,13,14,11,15,14
 * Hobgobelin guard in Sewer rescue: 11, 14

Shield of Faith
Current belief: (2 + 1/6 levels) deflection bonus to AC for 1 min/level (max probably like in PnP, +5 at L18)


 * Cleric L1, Wis 14: +2 deflection bonus to AC, 1 min
 * Cleric L2, Wis 14: +2 deflection bonus to AC, 2 min
 * Cleric L3, Wis 14: +2 deflection bonus to AC, 3 min
 * From a dev on DDO forums: "Once the character reaches level 6, the deflection bonus from the Shield of Faith spell increases to 3"
 * Cleric L5, Wis 18, extend spell feat: +2 deflection bonus to AC, 10 min
 * Cleric L6, Wis 18, extend spell active (April 2006): +3 deflection bonus to AC for 12 mins

Summon monster I

 * Cleric L1, Wis 14: 1 min
 * Cleric L2, Wis 14: 1 min
 * Cleric L5, Wis 18, AC 16+2(blocking)
 * Duration = 1 min
 * Attacks from celestial dog missed 14+11+14+15 = 54 times and hit 8+9+8+7 = 32 times (note that I was blocking in order to avoid falling to the ground)
 * Attacking it => damage 4+2, 1+7, 6+1 => HP is between 15 and 21
 * Cleric L5, Wis 16, AC 16+2 (blocking) (Tihocan 14:08, April 7, 2006 (EDT))
 * Attacks missed 10+7+9+10+9+7+7 = 59 times and hit 13+14+13+6+9+18+13 = 86 times => huge change in miss / hit ratio compared to previously => either there is some randomness in the dog's stats, or they buffed it in the latest patch

Summon monster II

 * Wiz L4, Int 21 : 2 mins over 20 casts.

Summon monster III
Current belief: The Summon Monster line as a duration of 1 min/spell level.


 * Wiz L5, Int 21 : 3 mins over 8 casts
 * Cleric L5, Wis 18, Con 10, Dex 14, AC 26
 * Attacks from Hellhound missed 53 times, got hit by Fiery bite (fire damage + pierce damage) for 3+3, 2+9, 6+3, 6+5, 5+3, got hit by breath (fire damage + slash damage) for 10 (save 2 + 5 = fail) + 3, 6 (save 5 + 5 = fail) + 2, got hit by simple fire damage for 3, 5
 * Attacking Hellhound => 5,5,6,2,2,2,6,9,8,8 => HP is between 46 and 53

Touch of Idiocy

 * Caster: Troglodyte Shaman on 4 HD character
 * Effect:-3 Int, -4 Wis, -4 Cha, no save

Water breathing

 * Cleric L5, Wis 18: lasts 1 min 30s
 * Cleric L7, Wis 18 (April 2006): lasts 3 mins 24s with extend spell activated

Bear's endurance
Current belief: +4 Con for 1 min / caster level


 * Cleric L5: +4 Con for 5 minutes

Bull's strength
Current belief: +4 strength for 1 min/level


 * Cleric L3, 14 Wis: +4 strength for 3 min

Eagle's splendor
Current belief: +4 Cha for 1 min / caster level


 * Cleric L5: +4 charisma for 5 minutes

Owl's wisdom
Current belief: +4 Wis for 1 min / caster level


 * Cleric L5: +4 wisdom for 5 minutes