Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Excel Solver Password: what is it and where can it be acquired/bought?

I've been exploring VBA and excel and I've been writing a few basic codes around the Excel Solver. However robust the Excel Solver may appear, it's just not fast enough for my optimization problem (one iteration takes 20 minutes).

I've been looking around and speaking with more experienced programmers, and the consensus is that VBA is simply not fast and that C++, C#, and especially CUDA languages are much faster.

Looking at the VBA modules in Excel, the Solver module is locked by a password. I've been searching for that password and where it can be acquired for weeks to no avail.

Questions: Can this password be acquired? If so, how? Can it be bought from Microsoft? How much?

Objective: To get the Solver VBA to be able to potentially convert it to C# or C++ to make the optimization process faster.

P.S. I've looked at Microsoft Solver Foundation but it wasn't helpful.

Thank you.

like image 282
Gian Avatar asked Feb 20 '17 12:02

Gian


People also ask

Is Solver free in Excel?

For free use by everyone, problem size limits in this Solver add-in are the same as in the Excel Solver (200 decision variables and 100 constraints in addition to bounds on the variables).

Does Solver come with Excel?

Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet.


1 Answers

You can use this password to unlock the SOLVER.XLAM project;

Wildebeest!!

like image 181
Old Nick Avatar answered Oct 14 '22 02:10

Old Nick