PLD Stats Weight for an Excel Solver

Hi,

As mentioned above, I am looking for PLD stats weight to input them into my PLD Solver.
My current Solver is based on an updated version of Zigkid3 by ChocBuckle - which is originally a DRG solver [my main is DRG].

I've had to change the whole Gear list (add Shield list too), add new parameters (parry and defense) to be taken into account by the solver, and other minor changes...

I am not really good at using Excel, but so far the Solver seems to be working after all the changes.

So the last main data I need is the Stats Weight.. and once it is complete.. if you wish, I could share it with everyone.

Current stats weights are based on PixelShader's guide.. now taken over by Griever2003

"Accuracy to 475 -> Item Quality -> Item Level -> Defense (If armor)/DPS (If weapon) -> VIT -> STR -> Resistance -> (Determination = Parry) -> Skill Speed -> Crit"

and Here are my current numbers:

Defense 2
Weapon Damage 1
Vitality 1
Strength 0.605
Parry 0.565
Critical Hit Rate 0.055
Determination 0.205
Skill Speed 0.105

These probably look ridiculous, there are meant to be.. I just picked random numbers relative to what it was said in the guide above.

So if anyone can help, it would really be awesome ^_^
It could be use to create any BiS based on current loot / accuracy needed / plan myth expenses . etc.

Thanks!

I also have another question.
As mentioned above, I dont know how to use Excel that well..
What I did for the [Heavy Darklight Armor], [Heavy Darksteel Armor], [Heavy Darklight Flanchard], and [Heavy Darksteel Flanchard] , since these are 2in1 pieces, I had to create Helm pieces and Cuisses, give these new pieces Stats by deducting the main pieces stats accordingly.

If you dont understand what I mean.. here is an example:
Heavy Darklight Armor Stats are : Def 262 / Str +33 / Vit +36 / Parry +43 / Crit +30

But in my table, that is what I got:
Heavy Darklight Helm : Def 109 / Str +12 / Vit +14 / Parry +16 / Crit +11
Heavy Darklight Armor : Def 153 / Str + 21 / Vit +22 / Parry +27 / Crit +19
Note: for other classes.. Head / Gloves / Boots have the same amount of Def.. so I based the newly created Helms / Flanchards on the Gloves Stats.

My QUESTION is.. I am looking for a way to create a constraint so that whenever the Solver picks the Heavy Darklight Armor [for example].. it would be forced to pick the Heavy Darklight Helm as the Head piece.

I think I may need to upload the Spreadsheet so I can actually get help for this ... tho gotta figure out how to ... I shall be back later with a link…

Thanks!

I have just look at how dragoon set solver work. Is it that u test 0/1 on the Decision Variable and check whichever yield highest total objective?

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

If so, why not just put DL Head = empty stat, and DL Body = full stats.
When you put 1 for DL Body, set all 0 as decision value for head slot.

Edit: I just found out i need solver add-in

Really, strength has that much weight in your calculations?

Also, what is the BiS themed toward? Damage mitigation? DPS?

Please upload the file, wanna run some testing.

But anyway in tank perspective, the objective should base on EHP score. The current PLD Equipment Planner give 7821 EHP on BIS.

Quote:

---

Originally Posted by WowSuchName

Please upload the file, wanna run some testing.

But anyway in tank perspective, the objective should base on EHP score. The current PLD Equipment Planner give 7821 EHP on BIS.

---

EHP... Equivalent HP?

Is that calculating the Shield Oath +20% damage resist as +20% hp?

Weighting defensive stats versus offensive stats is a non-starter. Their relative value is too complex and depends too much on encounter and strategy.

There is no choice to be made on equipment regarding VIT and defense, either. Increasing item level increases VIT and defense both. You might consider that the Parry stat could make up for one or the other, but that is difficult to do; magical attacks cannot be parried. This means that as you go up in item level, it's nearly impossible, even with the complete omission of parry, for a piece of armor not to be better defensively with increasing item level.

Quote:

---

Originally Posted by Duuude007

EHP... Equivalent HP?

Is that calculating the Shield Oath +20% damage resist as +20% hp?

---

Effective HP, and Shield Oath is a 25% increase in eHP (1/0.8=1.25). And no, it's not the end-all-be-all target. Going from 7000 to 9000 HP in Ifrit HM is totally useless.

EHP as Effective Hit Point from Block & Parry
- Calculate before shield oath, so EHP after shield oath should be EHP (7821)/0.8 = 9776.25

Quote:

---

Originally Posted by WowSuchName

I have just look at how dragoon set solver work. Is it that u test 0/1 on the Decision Variable and check whichever yield highest total objective?

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

If so, why not just put DL Head = empty stat, and DL Body = full stats.
When you put 1 for DL Body, set all 0 as decision value for head slot.

Edit: I just found out i need solver add-in

---

Hello! Thanks for your reply! .. I actually did not expect these many replies in such a short time.

About the link you found, that is actually an older version Zigkid3 had released ^_^

Here is the link to his latest in which you can find DRG / MNK / BRD with the 2.1 updates.

https://drive.google.com/folderview?...XM&usp=sharing

About your suggestion:
"If so, why not just put DL Head = empty stat, and DL Body = full stats.
When you put 1 for DL Body, set all 0 as decision value for head slot."

It is just that it won't open all the possible solutions for the solver to work with.
Your suggestion is still valid.. though the user would need to run the solver several times to check what his best current BiS is at X level of Accuracy / Parry.

1st Step : 1 for DL Body > 0 for all head slot > Run Solver > Save the Total Set Score
2nd Step: Choose another Body Piece > 1 to any desirable head slot > Save the Total Set Score
3rd Step: Compare the total set scores to see which one is best.

If the user were to consider the DL Bottom piece too.. he/she would need to run solvers a few more times.
I just wish to make life easier for anyone, and I don't think it is difficult to set it up.. I just dont know how to do it >_<

About my file, I am about to upload it, shall let you know soon enough!

Quote:

---

Originally Posted by Duuude007

Really, strength has that much weight in your calculations?

Also, what is the BiS themed toward? Damage mitigation? DPS?

---

Like I said, I picked random numbers .. not 100% random.. but based on what Pixelshader's guide mentioned which is the following:
""Accuracy to 475 -> Item Quality -> Item Level -> Defense (If armor)/DPS (If weapon) -> VIT -> STR -> Resistance -> (Determination = Parry) -> Skill Speed -> Crit"

As you can see STR is between VIT and Parry .. So I put it in between.. but the STR's weight I picked is still very close to Parry's weight.
What I am looking for from the forums is the better stats weights.. not my random numbers.

And PixelShader's BiS list.. also based on that
"Accuracy to 475 -> Item Quality -> Item Level -> Defense (If armor)/DPS (If weapon) -> VIT -> STR -> Resistance -> (Determination = Parry) -> Skill Speed -> Crit"

I am quoting again .. his aim was to find the "best in slot (set) if you are focusing on maximizing parry while still satisfying the 475 accuracy requirement"
Tho my solver would help to make Gear Set for any accuracy requirements [or none].

If you wonder why STR is placed this high, my assumptionis probably because the higher the STR .. the more threat you generate when you hit a target.
But I think it is true.. it's like when you have a fresh 50.. using AF1 gear.. running a dungeon with (for example) a full i90 DRG .. the poor PLD will have trouble keeping threat on himself.

Thanks!

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

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! >_<

Quote:

---

Originally Posted by WowSuchName

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.