Suggestion: Excel Style Solver add-in

Topics: Retired
May 27, 2008 at 10:01 PM
Just something I would like to see.  While one piece of gear may appear to be superior to another, it may cause some other drawbacks.

For example, Maximize Armor subject to Hit rating [XXX], and/or Defense rating [YYY] and/or ???

This would in turn not generate just a list of superior gear, but a cohesive set of gear that meets certain criteria.

May 27, 2008 at 11:16 PM
Can you clarify this more? As far as I can tell, everything that you're asking for is already implemented. Did you miss the Additional Requirements section of the Optimizer?
May 28, 2008 at 5:00 PM
It may be that he is asking to add something like the constraints, but in the comparison graph.  Something like:

In Rawr.Bear, if you set the constraint % chance to be crit <= 0, then any item that would make the condition false would be filtered out/moved to the bottom. 

I have found on occasion that something like that might be useful, but overall, I don't see a problem keeping that in the optimizer.
May 28, 2008 at 5:15 PM
Yeah, that's really a job for the optimizer, because you commonly want to swap a few pieces of gear around to maintain uncrittability, or whatever requirement.
May 28, 2008 at 9:59 PM
I stand mildly corrected.  I DL'd a version a couple of weeks ago and the optimizer then lacked some functionality.

Currently it looks to be better, but apparently im having some operator error issues :-P.

I ran this scenerio 5-6 times with similar outcomes.

Optimize for :  Hit Rating or Overall Rating

Subject to:  Hit Rating: >= 142
Subject to:  % Chance to be Crit <= 0
Subject to:  Mitigation % from Armor >= 50

Run the optimizer and get varying results for gear each time, and all with Hit ratings under 80.

I did include the Season 3 and 4 gear which has a substantial amount of hit on it for ferals, and all the top tier gems/and enchants with +hit rating.

Two Examples I can give from the last test I ran:  (force socket or metagem reqs are not checked. Only known gem combinations run)
    Season 3/4 Helm Included; Optimizer chose Cowl of Beastly Rage with 5agi/4hit (only the 5agi/5hit gem made available for optimizer) and 12agi/3% crit.
    Both Belt of Natural Power and Waistguard of the Great Beast are available for the optimizer, which chose the Belt of Natural Power (no +hit) and then socketed it with 2x 5agi/7stam gems (were made available.)

Its been a couple of years since I did excel solver set-up in collage but then general gist was maximize X subject to certain critera.  Im sure this is what your going for with your optimizer, which will be great when working. 

In the long term I would like to see the solver maximize (for ferals) agility subject to 142 hit rating, and be uncrittable (either through Def or Resil or a combination of the two (which is low w/ SotF)); or maximize Armor subject to XXX (which conseqently would take AGI into account). 

How this is implemented is probably the most difficult matter.  Can the system value the trade off between (purely example) bracers that have 6 hit rating and a yellow socket (+10 hit rating gem) vs. picking up the head enchant (ignoring the 34AP), and recalculating the most effective piece of armor to now wear in the wrist slot given that the +hit requirement has been met; possibly moving on to meeting the next constraint.

If this is unclear or if I'm just asking for the impossible let me know.  Im a reasonable person, and would certainly understand if you said that my request is unreasonable, or if I just need to put the crack pipe down. :-)
May 28, 2008 at 10:49 PM
Everything you're asking for is possible. Sounds like you're having some trouble properly using it though. If you provide the character file in question, and the exact optimizer settings you're using, I can provide more help. But at first glance, it sounds like you're mixing up all gemmings and known gemmings. You mention using known gemmings, yet you also mention which gems are provided, which is backwards. Known gemmings uses gemmings that are known. All Gemmings uses all gemmings that are available.
May 29, 2008 at 7:28 PM

Astrylian wrote:
Known gemmings uses gemmings that are known. All Gemmings uses all gemmings that are available.

Your saying that known gemming's uses the CURRENT gems that are in the item cache as they are displayed ONLY; and that all gemming's uses the item with all possible gemming combinations correct irregardless of how they are  listed in the item cache. I was going off that basis but maybe I am wrong somewhere?
May 29, 2008 at 9:00 PM
Correct, except All Gemmings will only use gems that you mark as Available.