XLOPTIM

Be it that you’re addressing logistical challenges, and are in need of optimization, or, seek a way to increase the efficiency of a particular process, there’s a high chance that you’ve heard of, and probably even used LocalSolver and its exploits. Transferring its capabilities and numerous useful procedures to a tabular environment, such as Microsoft Office Excel, can be done using XLOPTIM.

Designed in order to offer users a solution for operational problems, it will provide the efficiency of LocalSolver’s optimization engine into an Excel environment, regardless if users’ intended scope is increasing productivity, shortening the amount of time for problem-solving, or, enhancing overall efficiency.

Using the add-on, one will be able to perform data selections by range, but working is restricted to a single file, multiple selections being unavailable, as well as variables from multiple Excel files. There is a list of available functions that are still unavailable for use with the add-on.

Last but not least, users can rely on the add-on and its included, step-by-step process for creating their own optimization models, which involve posing the problem, setting the goal, adding the decision variables, dialog boxes, constraints, as well as other relevant parameters.