The Ultimate Black Mage Resources with Damage Calculator

So, I figured out last week that FF14 ARR's endgame is actually theorycrafting :O

Here's the spreadsheet. Have at it.

Last Update: 1/1/2015

Clicky Here for Puro Strider's Sexy Spreadsheet

Clicky Here for Puro Strider's Sexy Spreadsheet (Backup)


Latest Calculator version = v6.1


Other Resources:
1. Main Reddit Thread
2. BLM Stat Weights Discussion Part 1
3. BLM Stat Weights Discussion Part 2
4. Thunder I vs Thunder II Discussion
5. BLM BiS Gear Comparison Graph (2.0)
6. BLM BiS Gear Comparison Graph (2.1)
7. BLM BiS Gear Comparison Graph (2.25)
8. Spell Rotation Discussion

Cheers.

wow just wow.

You sir have done an awesome job. Best google DOC I have ever seen for a game, everything is neat, clean and easy to read :).

Will comment more later once I have a chance to go through it all :)

In FFXI endgame I knew some people who used DPS spreadsheets to calculate their average DPS for a particular boss/monster. You pretty much had columns to enter your gear/stats and that would be matched using a proxy RNG and the approx lvl/stats of the boss you picked or something. After playing with different gear sets you'd know what would be the best investment in terms of stats (e.g. needing higher accuracy for coil content etc)

Here's what I'm talking about:
https://docs.google.com/folderview?i...&usp=drive_web

Question,

are you using HQ deviled eggs? or NQ in the spreadsheet?

Edit: Another question why are you listing Allagan wrist as BiS when the Hero bracelet offers DET instead of SS.

Edit 2: About the 429 Acc, you say 99.99% chance, in T4 & T5 I have 427 Acc using HQ stuffed food, yet I still miss a lot :(.

Quote:

---

Originally Posted by NeoAmon

wow just wow.

You sir have done an awesome job. Best google DOC I have ever seen for a game, everything is neat, clean and easy to read :).

Will comment more later once I have a chance to go through it all :)

---

Thanks m8. Take your time. I can pretty much answer any question you have about the spreadsheet.

Quote:

---

Originally Posted by NovaUltimatum

snip

---

Never knew that exist. I'll check it out.

I just use my raw data and make my own calculator out of the blue. I don't even know who I am anymore. D:

Quote:

---

Originally Posted by NeoAmon

Question,

are you using HQ deviled eggs? or NQ in the spreadsheet?

Edit: Another question why are you listing Allagan wrist as BiS when the Hero bracelet offers DET instead of SS.

Edit 2: About the 429 Acc, you say 99.99% chance, in T4 & T5 I have 427 Acc using HQ stuffed food, yet I still miss like a nub

---

HQ,

Yea the bracelet was a miss on my part. I was too excited to finally finish this damn ting (for now). Thanks for pointing that out.

As for the Acc, I tested 428 Acc a while back and missed 2 out of 900 casts. Tested 430 and 434 and have not missed once out of 2k+ casts.

Between the 2 BiS sets which one are you aiming for? and why?

Personally I'm going with BiS 1 since I loath the looks of BLM Relic AF. It is also easier to switch T5 BiS once I have the shield and WP.

The crit adjusted values in the calculator tab don't seem to be correct, unless I'm missing something. My Fire spell typically crits in the 990s and occasionally over 1000 without Raging Strikes or food. Fire 3 is usually in the 1400s. This is with Relic +1, Sorcerer Boots, Demagogue Ring, everything else Darklight.

Were you trying to convey that based on my crit value that that is what my Fire spell's damage is actually worth with crit factored in?

@NeoAmon

I'm going for Set A myself. I've gotten everything except for Head, Body, Belt, and Earrings from Coil >.<

But yea, Allagan chest looks 1000x better than Sorc unless they decided remodel the Sorc coat, which is unlikely. Saving 825 myth tomes is a big plus also.


@Orophin

The calculator calculates "Average Damage per 100 Casts" with and without spell speed and/or crit factored in.

So, those crit values are not your individual crit for each cast. It combines both non-crit and crit damage in 100 casts and take the average of that.

If you want to know you crit range, all you have to do is multiple the "True Damage" by 1.5 and vola!

Hope that helps.

Quote:

---

Originally Posted by PuroStrider

The calculator calculates "Average Damage per 100 Casts" with and without spell speed and/or crit factored in.

So, those crit values are not your individual crit for each cast. It combines both non-crit and crit damage in 100 casts and take the average of that.

---

Ok, after looking at it again after my post that's what I figured.

Thanks for the spreadsheet by the way, it's very detailed. :)

Just a quick suggestion,

Could/would you please add the total stats gain + base stats under each BiS set? It would provide hard numbers on why each set is BiS, some baddies still thinks HQ crafted gear is better than ilvl90 gear. I even once had a crafter challenge me to 500k DPS bet in AK cause he has full melded crafted gear and my gear is no match to his (lel), he still owes me dat 500k.

Is there a reason why set A over set B? Looks like the most logical pick would be set B because you cap Acc and it does more damage overall.

Awesome, thank you!!

Awesome results. My theorized BiS before Allagan Scepter was actually Set A, since my tests in current gear favor Determination; shame to see that testing has shown more DPS on an AF2 set, but nice to see more Allagan in an ultimate BiS list.

Are you sure the Allagan head's accuracy and Determination aren't worth more than AF2 head's CHR and SS? I feel like you could use better DPS food if you meet the accuracy stat cap. If the math is sound though, I guess it's time to pick up the AF2 head.

Quote:

---

Originally Posted by rwarr

Is there a reason why set A over set B? Looks like the most logical pick would be set B because you cap Acc and it does more damage overall.

---

If the final results are correct, two reasons:

1. You won't want AF2 chest in your final BiS list, and thus you'll have wasted mythology tomes when you get there (luck and situation dependent).
2. Allagan coat's looks over AF2 armor are worth the .1% loss in DPS and slight accuracy loss (YMMV).

@NeoAmon - Just finished updating the gear page, let me know if there's anything else ^^

@rwarr - There are very minute differences between the two set (check out the updated gear page). Sleigh is pretty much spot on as well.

@Sleigh - There is no food better than HQ Deviled Eggs at the moment (+24 Crit) even if you've already capped your ACC. As for Head piece, AF2 is worth +6.6 INT while Allagan is worth only +3 INT (Assuming you've already capped your ACC with or without food), theoretically speaking.

Big thank for this amazing work.
Thanks a lot !

Quote:

---

Originally Posted by PuroStrider

@NeoAmon - Just finished updating the gear page, let me know if there's anything else ^^

---

One little addition would complete the gear page, VIT comparison between the 3 sets ^^. Looking at the 3 sets stats, they look to be almost equal with SET B having a very small edge over them. I guess it is worth the sacrifice so we don't look like clowns.

This is very interesting indeed. so far i had no luck with drops compared to the summoner in our group XD

Quote:

---

Originally Posted by Shadowzanon

This is very interesting indeed. so far i had no luck with drops compared to the summoner in our group XD

---

eh you guys need on every drop? We just do normal loot system, you get a drop, u pass on the next one for the other mage ^^.

Quote:

---

Originally Posted by NeoAmon

eh you guys need on every drop? We just do normal loot system, you get a drop, u pass on the next one for the other mage ^^.

---

ya we do that, i only got the boots cuz he had em, its my turn next but he got the chest n pants T.T

Quote:

---

Originally Posted by Shadowzanon

ya we do that, i only got the boots cuz he had em, its my turn next but he got the chest n pants T.T

---

wow I have yet to see the pants :(

Quote:

---

Originally Posted by NeoAmon

wow I have yet to see the pants :(

---

They dropped on our victory on turn 4 this past monday i was sad cuz i got the ring (which he already had) now trying to get the crafted ring n earrings for more hp for turn 5 but i highly doubt we are rdy for it. I just wanna get free of this crafted gear XD. Seeing the bis list makes me cringe that i purchased the heroes belt.

Great work! I was relly delighted today when a friend of mine found this and sent it to me :)

But I miss one important thing ... didn't you consider to get 251 piety for a proper rotation with 5 fireballs? This is the reason why I'd put one or two 2 star items (astral ring, rosegold earrings) into the build :)

Quote:

---

Originally Posted by Primm

Great work! I was relly delighted today when a friend of mine found this and sent it to me :)

But I miss one important thing ... didn't you consider to get 251 piety for a proper rotation with 5 fireballs? This is the reason why I'd put one or two 2 star items (astral ring, rosegold earrings) into the build :)

---

Be a Lalafell and party with a scholar, and that should be enough for all the instances that actually matters.

I don't wanna depend on a scholar and still less being a Lalafell ;) We don't need to optimize any gear if we just want to be "enough" ;)

meh I would not bother with piety at all. The best theoretical dmg increase under ideal conditions is not more than 2.3%~ give or take. Personally I will not give 1 point of INT for anything except WP DMG.

2% is massively more than you're getting for 1 INT, btw.

Quote:

---

Originally Posted by PuroStrider

@Sleigh - There is no food better than HQ Deviled Eggs at the moment (+24 Crit) even if you've already capped your ACC. As for Head piece, AF2 is worth +6.6 INT while Allagan is worth only +3 INT (Assuming you've already capped your ACC with or without food), theoretically speaking.

---

HQ Apkallu Omelette?

@NeoAmon - VIT is the same for all 3 sets, which is +158. 184 is base w/o race stats, so VIT with BiS gear w/o race stats = 342

@Primm - I'll look into factoring in piety to the whole mess ^^


@Fukujin - You cannot get max bonus from HQ Apkallu Omelette even with current BiS gears due to low scaling percentage.

So, at 491 crit, you end up with +20 crit (27 max), 11 vit (19 max), 9 acc (11 max)

You can get almost max bonus from HQ deviled eggs: +24 crit, +14 vit, +9 acc (10 max)

No other food can compare to +24 crit when Acc is capped.

Quote:

---

Originally Posted by Fukujin

HQ Apkallu Omelette?

---

You would need 550+ crit to get 22 points out of the Apkallu Omelette HQ plus they are damn expensive to make or buy...not worth it ^^. Deviled eggs on the other hand is easy to cap, easy to make & cheap mats.

Quote:

---

Originally Posted by PessimiStick

2% is massively more than you're getting for 1 INT, btw.

---

Not really, you see BLM scale exponentially with INT since we are a burst DD and not sustained DPS. My opinion anyway, I like to have my Fire 1 do more dmg than actually casting an extra one :)

Quote:

---

Originally Posted by NeoAmon

Not really, you see BLM scale exponentially with INT since we are a burst DD and not sustained DPS. My opinion anyway, I like to have my Fire 1 do more dmg than actually casting an extra one :)

---

Yes really. Math is pretty straightforward. Exchanging 1 INT for 1 PIE if it puts you at 251 is a no-brainer.

Quote:

---

Originally Posted by NeoAmon

You would need 550+ crit to get 22 points out of the Apkallu Omelette HQ plus they are damn expensive to make or buy...not worth it ^^. Deviled eggs on the other hand is easy to cap, easy to make & cheap mats.

---

Quote:

---

Originally Posted by PuroStrider

@Fukujin - You cannot get max bonus from HQ Apkallu Omelette even with current BiS gears due to low scaling percentage.

So, at 491 crit, you end up with +20 crit (27 max), 11 vit (19 max), 9 acc (11 max)

You can get almost max bonus from HQ deviled eggs: +24 crit, +14 vit, +9 acc (10 max)

No other food can compare to +24 crit when Acc is capped.

---

Ah yeah thanks guys lol I dont know too much about this stuff so its great when i learn new things
New to the MMO community and i suck at math xD

Awesome guide!

This looks amazing. Thanks for posting this up. Now I can finally continue pimpin my BLM... there is one thing i dont understand in all these posts.. what is BiS?

best in slot

Big update incoming in a day or two.. (lots of new data)

It will end thunder I vs thunder II rotation debate, hopefully.

Also will be updating current damage calculator and adding a DPS calculator.

Stay tuned!

Ive been doing some potency simulations on various rotations using MATLAB, namely F3 - 5F1, F3 - Quick F3 - 4 F1, F3 - 4 F1, and F3 - Quick F3 - 3 F1... all using Thunder 2. I have my program designed to easily change the number of total casts, to better simulate the equal/over 251 vs under 251 piety issue.

What I have found is that generally, if we go fairly indepth and simulate spamcasting Fire1, causing us to catch only up to every other Firestarter proc, and estimating the total effect of Thunder 2 over the course of a complete rotation including firestarter rng... all on a 2.5s gcd... Well... I end up having a simple question...

As a Highlander, I need 12 piety to have 251. My simulation tells me that the F3-5 F1 rotation is 105.69 potency per second. And the F3-4 F1 rotation, being under 251 piety, is 103.05 potency per second.
This is a 2.5% loss in potency/sec from NOT having 251 piety.

Now, using your calc, by moving 12 points from Pie to Int and using a relic, my spell (Fire) damage goes up by 2.48% for F1 and 2.37% for F3. And with a relic+1, F1 goes up by 2.41% and F3 by 2.42%

So... This is pretty much the old question of "is 251 Pie worth it?"
As a Highlander, I can move around 12 points to make my Fires, likely all my spells, hit ~2.5% harder... or I can make my overall rotation hit 2.5% harder...

So... tossup, not worth considering, stick to pure int and have a scholar handy... Or did SE do their math AMAZINGLY well such that all variations are moot. =)

The truth is that some races are just better BLMs. Dust Lalas, for example, get over 251 just from having a Scholar around.

Added 'Thunder I vs Thunder II' page.

Enjoy! :)


@Kenji1134 - Nice analysis, m8. I try to use my own raw data as much as possible from my own testing. That's just how I do things, and I believe it's more accurate to use numbers and variable from real-time rather than throwing around some theoretical numbers.

My calculator will be updated by tonight or tomorrow, so look forward to that. ^^

I could use a bit more info (i am not a math guru which is why i love these informitive threads) to understand more the thunder 1 vs 2. Well i finished coil this week no upgrades were awarded for me but i did get my myth ring. the cool thing is the allegan helm, leggings and earrings (they dropped but it was not my turn for caster loot) are garanteed for me, leaving me to use myths for either chest (3 weeks after this week) or gloves (two weeks after this week) I now sit at 491 crit my acc is capped at 434. Since i am dunesfolk i will be adding 2 piety 3 materia to my helm (had to redo them due to ring upgrade.) which puts me at 251 piety. I am deciding that over 2 spell speed materias. My earrings will prob get 2 determination materias to put me at 283 det.

I currently use buttons in a blanket due to me being capped with acc. Would this be just better for me over deviled eggs since i am capped with acc. or is the eggs just better over all. Also before i do add piety to my helm, would i just benefit more from spell speed?

http://na.finalfantasyxiv.com/lodest...acter/2187183/

@Shadowzanon - Keep in mind that you get additional 7* PIE as a BLM for having a SCH in your party. (*Stats bonus from party is varied either by race or base stats. I'll try to get definite answer next time around).

Food-wise, HQ Deviled eggs will be your best food if you have BiS gears.

With your current gear and damage output, you will be getting +4.7 INT from HQ Buttons (+14 DET, +10 Crit) and +4.6 INT from Deviled Egg (+24 Crit)