Premium Solver Platform, created by Frontline Systems, developers of the Solver in Microsoft Excel, is a compatible upgrade of the Excel Solver that greatly extends its speed and problem solving capacity. If you ve run up against the size limits of the standard Solver (200 variables) or found it too slow, the Premium Solver Platform is for you.

Is definitely next 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, 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”. Kartochki shemi provedeniya eksperimentov v dou.

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.

With the Premium Solver App, created by Frontline Systems, developers of the Solver in Microsoft Excel, you can define and solve optimization problems in your Excel workbook, using Excel Online in Office 365, the Excel Web App in SharePoint 2013, or desktop Excel 2013. You can create and solve models on tablets, phones, or anywhere a web browser can be used. Your model will be solved in the cloud. The Premium Solver App is a powerful, upward compatible upgrade for the Solver in desktop Excel, and for the free Solver App, also created by Frontline Systems.

You can solve linear models up to 2,000 decision variables -- 10 times the size of the standard Solver or Solver App -- and nonlinear models up to 500 variables, and get better solutions faster. If you have a license for our desktop Premium Solver Platform, you can do much more with the Premium Solver App -- see below. Solver models that you may already have, created in old or new versions of Microsoft Excel, or in the free Solver App, are automatically recognized by the Premium Solver App. You can also define a completely new Solver model using this App (however, models created with this App won’t be automatically recognized by the desktop Excel Solver).

You can use the Premium Solver App to find better ways to allocate scarce resources, maximize profits or minimize costs or risks, in a wide range of applications in finance and investment, marketing, manufacturing and production, distribution and logistics, purchasing, and human resources, as well as science and engineering. To see examples, open the SolvSamp.xlsx workbook included in Microsoft Excel, or register at www.solver.com and click on Examples to download dozens more example models. Many management science textbooks also include examples and discussions of Solver models – see Support – Recommended Books on Solver.com. Basic Capabilities for All Subscribers All solving methods and options available in desktop Premium Solver Pro and the Excel Solver can be used: -- Simplex LP Solver -- up to 2,000 decision variables -- GRG Nonlinear Solver -- up to 500 decision variables -- Evolutionary Solver -- up to 500 decision variables -- Integer and binary constraints Since VBA is not available in the Excel Web App, Solver VBA macros cannot be used to control the App. The Answer, Sensitivity, and Limits reports are not available.