PLD Stats Weight for an Excel Solver

[MDraGc]

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!

[MDraGc]

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!

[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.

[Duuude007]

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?

[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

[MDraGc]

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!

[Duuude007]

Really, strength has that much weight in your calculations?

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

[MDraGc]

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!

[Gamemako]

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.

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.

[WowSuchName]

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