Blue Mage: Best thread ever

[Byrthnoth]

Well, okay! As long as the data gets out there somehow!

I'm doing kind of the same thing for the other types of Spells. Remaking them with a new template and trying to fill in some of the holes in our mechanics knowledge for them. Mougu's work has been awesome for that.

[Darkmagi]

It isn't for me to give

I see, I thought this was just something you made and were keeping it to yourself.

[Prothescar]

I see, I thought this was just something you made and were keeping it to yourself.

Collaboration between myself and the author for the actual data, I did not make the spreadsheet itself. It's in an uncommon format anyway, so it'd be kinda hard to share.


================================================== =========================



Physical:

Spoiler: show

Foot Kick - D Cap 9, 10% STR 10% DEX, fTP 1.0

Power Attack - D Cap 11, 30% VIT, fTP 1.125

Sprout Smack - D Cap 11, 30% VIT, fTP 1.5 [Slow: 15% for 3:00]

Wild Oats - D Cap 11, 30% AGI, fTP 1.8359375

Queasyshroom - D Cap 15, 20% INT, fTP 1.75 [Poison: 3/tic for 1:30 ~ 3:00]

Battle Dance - D Cap 17, 30% STR, fTP 2.0

Head Butt - D Cap 17, 20% STR 20% INT, fTP 1.75(0) 2.125(150), 2.25(300), 2.375(350)

Feather Storm - D Cap 17, 30% AGI, fTP 2.0 [Poison: 1/tic for 1:30]

Helldive - D Cap 19, 30% AGI, fTP 1.25(0) 1.625(150) 2(300) 2.125(350)

Bludgeon - D Cap 21, 30% CHR, fTP 1.0

Claw Cyclone - D Cap 23, 30% DEX, fTP 1.4375

Screwdriver - D Cap 27, 20% STR 20% MND, fTP 1.375

Grand Slam - D Cap 33, 30% VIT, fTP 1.0

Smite of Rage - D Cap 35, 20% STR 20% DEX, fTP 1.5(0) 2.25(150) 2.5(300) 2.53125(350)

Pinecone Bomb - D Cap 37, 20% STR 20% AGI, fTP 2.25 [Sleep: 0:10 ~ 1:00]

Jet Stream - D Cap 39, 30% AGI, fTP 1.125

Uppercut - D Cap 39, 35% STR, fTP 1.5

Terror Touch - D Cap 41, 20% DEX 20% INT, fTP 1.5 [Attack Down: 15% (38/256) for 1:00]

Mandibular Bite - D Cap 45, 20% STR 20% INT, fTP 2.0

Sickle Slash - D Cap 49, 50% DEX, fTP 1.5

**SPELLS BEYOND THIS POINT HAVE NO REACHABLE D CAP**

Death Scissors - 60% STR, fTP 1.5(0) 2.75(150) 3.25(300) 3.296875(350) [+33% Attack bonus]

Dimensional Death - 50% STR, fTP 2.25 [+25% Attack bonus]

Spiral Spin - 30% AGI, fTP 2.0 [Accuracy Down: -15 for 0:45 ~ 1:00]

Seedspray - 30% DEX, fTP 0.875 [Defense Down: -8% (20/256) for 1:30 ~ 2:00]

Body Slam - 40% VIT, fTP 1.5

Spinal Cleave - 30% STR, fTP 3.0 [+25% Attack bonus]

Frenetic Rip - 20% STR 20% DEX, fTP 1.359375(0) 2.0703125(150) 2.359375(300) 2.609375(350) [+25% Attack bonus]

Frypan - 20% STR 20% MND, fTP 1.7734375

Hydro Shot - 30% AGI, fTP 1.25 [Enmity Down effect is miniscule, so small that the damage done by the spell often overtakes the decrease]

Tail Slap - 20% STR 50% VIT, fTP 1.625

Hysteric Barrage - 30% DEX, fTP 1.25(0) 1.625(150) 1.75(300) 1.875(350)

Asuran Claws - 10% STR 10% DEX, fTP 0.625

Cannonball - 50% STR 50% VIT, fTP 1.75(0) 2.125(150) 2.75(300) 2.875(350) [Uses Defense rather than Attack to calculate damage.]

Disseverment - 20% STR 20% DEX, fTP 1.5 [Poison: level/5+3 for 3:00] [+25% Attack bonus]

Sub-zero Smash - 60% VIT, fTP 2.0 [Paralyze: 10% for 3:00]

Ram Charge - 30% STR 50% MND, fTP 1.0(0) 1.375(150) 1.75(300) 1.875(350)

Vertical Cleave - 50% STR, fTP 3.0

Final Sting - fTP 1.0 [Damage varies with HP, will never deal more than 66% of a monster's HP in damage.]

Goblin Rush - 30% STR 30% DEX, fTP 1.25 [+35% Attack bonus]

Vanity Dive - 50% DEX, fTP 3.0(0) 4.0(150) 4.5(300) 4.75(350) [+33% Attack bonus]

Benthic Typhoon - 60% AGI, fTP 4.0(0) 4.5(150) 5.0(300) 5.25(350) [Defense Down: -10% (25/256) for 1:00. Magic Defense Down: -10 for 1:00]

Whirl of Rage - 30% STR 30% MND, fTP 3.0(0) 3.5(150) 4.0(300) 4.25(350)

Quad. Continuum - 32% STR 32% VIT, fTP 1.25(0) 1.5(150) 1.75(300) 2.0(350) [+25% Attack bonus]

Empty Thrash - 50% STR, fTP 2.0

Delta Thrust - 20% STR 50% VIT, fTP 1.09375 [Plague: -10TP and -6MP/tic for 0:40 ~ 1:00]

Heavy Strike - 50% STR, fTP 2.5(0) 3.5(150) 4(300) ???(350) [Scores a critical hit 100% of the time. Possesses a penalty of -60 Accuracy]

Sudden Lunge - 40% AGI, fTP 1.5(0) 2.5(150) 3.0(300) ???(350)

Quadrastrike - 30% STR, fTP 1.1875

Tourbillion - 25% STR 25% MND, fTP 4.0 [Defense Down: -33% (85/256) for 1:30 ~ 2:00]

Amorphic Spikes - 20% DEX 20% INT, fTP 1.0(0) 1.375(150) ???(300) ???(350) [+25% Attack bonus]

Barbed Crescent - 50% DEX, fTP 2.0 [Accuracy Down: -30 for 2:00 ~ 2:30]

Bilgestorm - ???% ???, fTP ??? [Defense Down: -25% (64/256) for 0:30 ~ 1:00. Attack Down: -25% (64/256) for 0:30 ~ 1:00. Accuracy Down: -??? for ???]

Magical:

Spoiler: show

**D cap can be assumed to be 101 or unreachable if not listed.**

Sandspin - D Cap 13, 1.0dINT, 20% INT, fTP 1 [Accuracy Down: -25 for 3:00]

Cursed Sphere - D Cap 30, 1.0dINT, 30% INT, fTP 1.5

Blastbomb - D Cap 30, 1.0dINT, 20% INT, fTP 1.375

Bomb Toss - D Cap 40, 1.0dINT, 20% INT, fTP 1.625

Death Ray - D Cap 51, 1.0dINT, 20% INT 10% MND, fTP 1.625

Mysterious Light - D Cap 57, 1.0dCHR, 30% CHR, fTP 0.96875 [Gravity: -10 Evasion for 0:30 ~ 2:00]

Blitzstrahl - D Cap 61, 1.0dINT, 30% INT 10% MND, fTP 1.5625

Ice Break - D Cap 67, 1.0dINT, 30% INT, fTP 2.25

Maelstrom - 1.5dINT, 30% INT 10% MND, fTP 2.375 [STR Down: -20 for 1:00.]

Eyes on Me - 1.5dCHR, 40% CHR, fTP 2.625

Corrosive Ooze - 2.0dINT, 20% INT, fTP 2.171875 [Defense Down: 5% (13/256) for 1:00 ~ 1:30. Attack Down: 5% (13/256) for 1:00 ~ 1:30.]

Firespit - 1.5dINT, 20% INT 20% MND, fTP 3

Regurgitation - 2.0dINT, 30% MND, fTP 1.875

Mind Blast - 1.5dMND, 30% MND, fTP 2.07421875 [Paralyze: 20% for 1:30]

Magic Hammer - D Cap 35, 1.0dMND, 30% MND, fTP 1 [Converts damage dealt to MP if the target has MP.]

Acrid Stream - 2.0dINT, 30% MND, fTP 2.296875 [Magic Defense Down: -10 for 2:00]

Leafstorm - 2.0dINT, 30% STR, fTP 2.75

Blazing Bound - 2.0dINT, 30% STR, fTP 3 [Uses Magic Defense Bonus in place of Magic Attack Bonus to calculate damage done.]

Thermal Pulse - 2.0dINT, 40% VIT, fTP 4 [Blind: -25 for 0:30 ~ 1:00]

Charged Whisker - 2.0dINT, 50% DEX, fTP 4.5

Everyone's Grudge - 2.0dINT, 40% MND, fTP 5

Water Bomb - 1.5dINT, 20% INT 10% MND, fTP 2 [Silence lasts 1:30 ~ 2:00]

Dark Orb - 2.0dINT, 40% INT, fTP 4.5

Thunderbolt - 2.0dINT, 30% INT 20% MND, fTP 4

Gates of Hades - 1.0dINT, 20% STR 20% DEX, fTP 5 [Burn: 21HP/tic and -47INT for 1:30]

Breaths:

Spoiler: show

Poison Breath - Level Divisor 1.25, HP Divisor 10, HP Multiplier 1 [Poison: 4/tic for 0:30]

Magnetite Cloud - Level Divisor 1.875, HP Divisor 6, HP Multiplier 1 [Gravity: -10 Evasion for 0:30 ~ 2:00]

Hecatomb Wave - Level Divisor 1.5, HP Divisor 4, HP Multiplier 1 [Blind: -30 for a random period of time, maximum being 3:00]

Radiant Breath - Level Divisor 0.75, HP Divisor 4, HP Multiplier 1 [Slow: 20% for 1:30. Silence for 1:30.]

Flying Hip Press - Level Divisor N/A, HP Divisor 3, HP Multiplier 1.0

Bad Breath - Level Divisor 3, HP Divisor 8, HP Multiplier 1 [All status effects present: 0:10 ~ 0:30 with a shared timer]

Frost Breath - Level Divisor 0.625, HP Divisor 3, HP Multiplier 1.0 [Paralyze: 12.5% for 3:00]

Heat Breath - Level Divisor N/A, HP Divisor 2, HP Multiplier 1

Vapor Spray - Level Divisor N/A, HP Divisor 2, HP Multiplier 1 [Poison: N/A]

Thunder Breath - Level Divisor N/A, HP Divisor 2, HP Multiplier 1.35

Wind Breath - Level Divisor N/A, HP Divisor 4, HP Multiplier 1

Debuffs:

Spoiler: show

Filamented Hold - 25% Slow for 1:30

Cimicine Discharge - 19.5% Slow for 1:30

Venom Shell - 6/tic Poison for 3:00

Light of Penance - -100 Accuracy Blind for 0:30, -10 TP

Sandspray - -25 Accuracy Blind for 1:00 ~ 2:00

Auroral Drape - -60 Accuracy Blind for 0:30 ~ 1:00, Silence for 0:30 ~ 1:00

Frightful Roar - -10% (25/256) Defense Down for 3:00

Enervation - -10% (26/256) Defense Down for 0:30, -8 Magic Defense for 0:30

Infrasonics - -20 Evasion for 1:00

Lowing - -5TP and -3MP/tic for 0:40 ~ 1:00

Cold Wave - 22/tic and -49 AGI for 0:30 [Level/5 + 3 for the DoT]

Awful Eye - -43 STR for 0:30 [Level dependent]

Sheep Song - Sleep for 0:40 ~ 1:00

Soporific - Sleep for 1:30

Yawn - Sleep for 1:15 ~ 1:30

Dream Flower - Sleep for 1:30 ~ 2:00

Chaotic Eye - Silence for 0:05 ~ 2:00

Mortal Ray - 60 second Doom effect

[Esvedium]

That's a fantastic chunk of data! Thanks for posting, Pro.

[Yugl]

Who was the other author?

[dasva]

Yeah that's the kind of stuff I was looking for thanks

[Prothescar]

Who was the other author?

She'd prefer not being named.

[doctorugh]

Disseverment - 20% STR 20% DEX, fTP 1.5 [Poison: level/5+3 for 3:00] [+25% Attack bonus]

Does she have solid data on the 25% att, I tested this years ago with no +attack (they could have ninja'ed it in at some point). This would make it very usable again.

Death Scissors - 60% STR, fTP 1.5(0) 2.75(150) 3.25(300) 3.296875(350) [+33% Attack bonus]

Also on this one, I got no +att when casted normally, but certainly did get some +att duing CA (again this was years ago)

[Prothescar]

I do. Disseverment most certainly has the attack bonus attached to it, Death Scissors is not 100% certain however neither of us care to go back and test low level spells again. It's a relative amount of certainty to it actually having the attack boost, however, or else I wouldn't have mentioned it.

While it's quite possible that Death Scissors does not, I included all of the information that we had.

[Vathris]

Light of Penance - -100 Accuracy Blind for 0:30, -10 TP

Whaaaat? Half the duration of Auroral drape but still, that pretty bad ass

[Prothescar]

It's got a pretty annoying resist rate unfortunately, especially for a gaze. :c

[Vathris]

Am I getting very unlucky or can you not learn Tourbillion from Assaults?

[Yugl]

The former.

[dasva]

Not sure which one you referring too but the regular assualt one seems alot better than nyzle for learn rate

[doctorugh]

Was doing some magian trials on lizards and thought I'd parse out Diss. vs other spells since I had a fair amount to do. After plugging in ftp,mods,Dvalue,capped fstr (abyssea), I'm confident that Disseverment does not have an attack bonus and wouldn't mind doing some collaberative work (same mob/level/stats ect) if need be.

The mobs were all dc or lower, and I was less concerned about getting exacting measurements and just wanted an overall impression knowing that if it got a 25% bonus that ratio would be capped or close. I did roughly 40-50 of each spell, making sure not to finish with a multi-hit spell (which would scew data with potential hits that were left off). There was no possibilty of set bonus (only legs eq) and CA/EFFLUX was never used.

Avg Ratio results:

QC = 2.02 (has known attack bonus)
AS = 1.88
GR = 1.98
ET = 2.03 (I thought this was interested and had never tested before,appear to get some attack bonus)
WOR = 1.48
DT = 1.47
Diss = 1.45 (This is way to low to have had any attack bonus and very in-line with DT and WOR which have no attack bonus)

I realize that its a small sample with some varience in level, but I am fairly certain that Diss. gets no attack bonus.

[Prothescar]

Can't do anything for a little while myself, for now it would probably just be best to abscond any sort of Attack Bonus from wiki pages etc., when I get some free time to do that sort of testing I'd be happy to collaborate tho.

[Prothescar]

Updated post, added fTP for magical spells and updated some debuffs.

[Yugl]

Just looking at the data point assumed (No data, but I assume your test is using LV99) and Calculating BLU magic page information (Assumed to be LV75), Cold Wave's DOT appears to be [LV/5]+3. Need more data points to confirm though.

[Nightfyre]

I can confirm that from personal testing.

[Prothescar]

It's equal to Disseverment poison's calculation. I'll make a note of it.