Read this authenticated review Analytic Solver Scorecard Summary Likelihood to Recommend (3) 8.9 Data Sharing and Collaboration (1) 8.0 Data Sources (1) 7.0 About Analytic Solver Frontline Systems Analytic Solver is an Excel add-on for performing data mining, and predictive analytics from within Microsoft Excel.This type of models as well as others like the WinQsb are basically used by the department that is under my supervision, and are not commonly used in the organization.The last situation in which it was implemented was to try to model part of the hydrographic network of the Peruvian Amazon where the nodes of the network were possible locations of fuel supply sites, rotation of personnel and raw material proper to the activity that it was modeling, trying to optimize (minimize) the total costs associated with this activity, which were a function of the relative location existing between the potential nodes.Pros and Cons Without the program being my favorite it is necessary to recognize that handling in the Excel application environment provides it with a feature with a high added value, compared to other softwares that do not have those characteristics, which makes the handling of data from external sources is easier.
In addition to its inherent quality of general data analysis, I can also highlight the areas in which I have used it (field of linear optimization, simplex method and non-linear optimization, network models) where it has allowed me to model, simulate and analyze different situations with great success. I could say that the limitations are not the program but mine as a user of it. Unlike other software that I have used (WinQsb and Lingo, for example), it presents an acceptable customer service. Edit On the few occasions when I have used it to deal with problems of optimization of relatively large parameters (with a large number of restrictions and decision variables), the program has been slower, not substantially but slower, than programs such as the WinQsb, even when the latter runs on 32-bit machines and not 64. That has caught my attention, even though it is not a real problem for the uses I give to the program. Frontline Solver License Associated WithGiven my partial function as a university professor, it has been much more effective and practical to use other software, due to the limited options that the educational license associated with the software has. Likelihood to Recommend Based on my limited experience and use, and therefore limited global knowledge of the software, I would recommend it especially if the data that will be used as inputs to the model has previously worked on a spreadsheet such as Excel. I would also recommend it to analyze problems of medium and small size. Given the experience I have had when I have used it with large problems, there have been noticeable decreases in the speed of response (which are not associated with the size of the system of equations involved in the calculation). Frontline Solver Full Review OctoberRead Rafael Becembergs full review October 27, 2017 Simple Easy Solver for optimization Verified User Analyst in Engineering Mining Metals Company, 1001-5000 employees Score 8 out of 10 Vetted Review Verified User Review Source Use Cases and Deployment Scope My organisation is using it for optimization problems related to raw material and finished goods for their shipments and production planning purposes. It is used only in my function- sales and operations planning. This tool is useful for the company who wants to build the optimization model in Excel for quick strategic and tactical decisions. My company is using Solver for product optimization, manufacturing plan and raw material planning. It helps busineses to understand the financial estimates across the distribution network. It helps to provide the feasible solution for production to produce what product at what location in an optimized manner. Strong optimization platform for business and supply chain problems which can be modeled in Excel It can handle multiple objectives and more than 8000 decision variables in a problem. Lots of tutorial and examples are available to solve the problem Edit Can not handle stochastic modelling Difficult to work on the non-linear program Managing the data is difficult using the big models in the tool Likelihood to Recommend 1. It is good tool for a mathematical model which is a single period and deterministic model 2. Frontline Solver Upgrade The ExcelIt is good for the users who are comfortable in handling the Excel Solver and needs to upgrade the Excel Solver for more than 200 variables 3. It works well for the multiple objective problems. Difficult to manage the big model as 100 constraints and 2000 variables can limit the use of the tools efficiency. Its limitation is that a model designer can not make a big and complex model.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |