Results 1 to 10 of 6139

Hybrid View

  1. #1
    Player
    Zerosix's Avatar
    Join Date
    Aug 2013
    Posts
    61
    Character
    Zero Six
    World
    Behemoth
    Main Class
    Thaumaturge Lv 50
    Quote Originally Posted by Ferboten View Post
    It's basically a type of optimization problem where the variables are binary valued, everything is linear, and there are certain constraints that need to be met (like high enough accuracy, and only 1 piece of equipment per slot).

    Here's the spreadsheet: https://mega.co.nz/#!ecUDSDZB!LBH82A...bJ5BvC98sq6Z18

    The solver can be accessed from Data -> Solver. From there you can see that our goal is to maximize the total weight by changing the selection cells for the items, subject to the above constraints, and as well constrained so that the variables are binary. After that, make sure the solving method is set to "Simplex LP", hit solve, and it will find the best solution.
    Yo Ferboten from rift? The one who made the spreads and calcs? Welcome on board to drg if that is you, my man.
    (0)

  2. #2
    Player
    Ferboten's Avatar
    Join Date
    Oct 2013
    Posts
    4
    Character
    Ferboten Lothbrok
    World
    Sargatanas
    Main Class
    Lancer Lv 50
    Quote Originally Posted by Zerosix View Post
    Yo Ferboten from rift? The one who made the spreads and calcs? Welcome on board to drg if that is you, my man.
    Yep, that's me
    (0)

Tags for this Thread