PLD Stats Weight for an Excel Solver

[WowSuchName]

This sound like a fun project to do but I will adjust it for calculation as OT DPS setup solver as the objective score is based on offensive stats, while MTing setup raw HP/EHP is simply good enough for the score.

Primary, just to support this thread

http://forum.square-enix.com/ffxiv/t...ing-DPS-Output

[MDraGc]

https://docs.google.com/spreadsheet/...rive_web#gid=0

Here the link to my spreadsheet. Not sure if it works.
If it doesn't, let me know.

To work on it on your personal Excel, you can click File > Download as > etc.

Note: I am not sure how to implement EHP and other things you suggested ^_^
Lets just say I only give you the ingredients to work with. I leave it to you to work your magic ^_^
Hopefully the spreadsheet will help.. so we dont need to start from scratch!

1 more thing to add.. I didn't input Darksteel gear with materia.
What would be nice to add is to know the best materias for each, and update the Darksteel pieces.

There is still a lot to be done! >_<

[Gamemako]

EHP as Effective Hit Point from Block & Parry

You never consider block and parry in eHP. They are random effects which are only valuable over a time interval where the limiting factor in your survival is the healer's output rather than the tank's reserve. eHP is the total minimum amount of damage required to kill you. You can calculate it on the basis of any defense score. Since there are two tanks with the same defense scores, we usually ignore the impact of defense and just go by the number you read on the screen; however, you may wish to include it by using a basis of zero-defense eHP to accommodate varying types of equipment. According to Valk's testing, each point of defense is worth roughly 0.044% damage reduction. Thus, your zero-defense eHP is

eHP = HP * hpmodifier / [(1-def*0.00044) * (1 - reductionmodifier)]

hpmodifier would the multiplicative result of any HP bonuses, like Defiance and Thrill of Battle. Value would be 1.25 for Defiance, 1.2 for Thrill of Battle, and 1.5 for both. reductionmodifier would be the multiplicative result of any percentage damage reductions. Shield Oath would be 0.2, Rampart would be 0.2, Sentinel would be 0.4, and the three together would be 0.616.

The point of eHP is to say whether or not you can survive mechanics, and if you don't survive passively, what level of mitigation you need to make it through and with how much wiggle room. It is always a pass-fail check for a certain condition. You need some eHP amount to survive Mountain Buster, or MB + autoattack, or MB + AA crit + rock buster + tumult. How much you actually need depends on content, strategy, and to some extent, the skill of your healers.

You can also consider total mitigation, which is the healing need reduced over time by your abilities and equipment. This does include block and parry as well as passive regen from VIT. Nobody has good data on the value of various stats. No conclusion on parry formula or whether there are STR or DEX tiers involved.

Then you weight all that uncertainty against the value of damage. How much is it worth? Well, that depends on content as well. This is why people pretty much throw their hands up and go with VIT > parry > whatever.