Solver is definitely next What’sBest! The most popular tool for solving optimization models using Microsoft Excel as a platform. In fact the free version of Solver we use is developed by Frontline Systems Inc., which provides a number of tools and resolution engines that are very useful when addressing problems of real life situations that are applied in the industry.
In the following article we will show you how to download and install the trial version of Premium Solver which is available for free for a period of 15 days, which allows us to solve significantly higher operational research models when it comes to the number of decision variables and constraints than those which can be solved with the traditional version of Solver. Additionally, by having improved resolution algorithms reliability of the solutions found and the processing times are more reliable. Here are the detailed instructions on how to download and install the trial version of Premium Solver Pro on a computer with an Excel 2010 version.
Step 1: Sign in Frontline Systems Inc, fill out the information required in the subscription form.
Step 2: Download the trial version compatible with the version of Excel that you have. In this tutorial the 64-bit version installation is shown. Once you are sure of our choice select “Download Now”.
If you have Excel 2010 and want to know how many bits you use to run your version of Excel, go to menu and select the Help option. In the lower right corner the number of bits of your version is displayed under “About Microsoft Excel”.
Step 3: Check your email account (which you provided in the subscription form from Step 1) and write down the 2 passwords that you have been assigned (pictured below, these have been protected with blue and red).
Step 4: Once the download is complete run the “SolverSetup64.exe” file (or the name that corresponds to the version of Excel you are using).
Then select “Next”.
Now we enter the password that we have received by email (Step 3) to continue the program activation:
Then we must accept the license agreements of the program and select “Next”.
At the moment, the program license has been activated and we must continue the installation process by selecting “OK”.
You must select the folder where the program will be installed and you can at this point simply select the folder that the program has selected by default.
It’s time to select the product you wish to activate. In this case we selected “Premium Solver Pro” which corresponds to the improved version of Solver which is generally used for academic purposes.
The installation wizard will ask us to confirm that we have selected the installation (Press “Install”).
Finally we have completed the installation of the Premium Solver Pro program and we are in a position to use it to solve optimization models using Microsoft Excel as a platform.