![excel frontline solver examples excel frontline solver examples](https://images-na.ssl-images-amazon.com/images/I/51KdgGNp8sL._SY445_SX342_QL70_ML2_.jpg)
Granted I could see the addon had an incredible depth to it and that the course did not even scratch the surface of what is possible, but the course did its job to show how to actually do these analyses.įinally in the section before the ASP add-on was required, I really enjoyed seeing how to use stock Excel (with Micosoft's Solver enabled) to perform cluster analyses- now I can do this myself with my stock Excel installation! Amazing and very cool. Overall despite these issues, I was able to learn quite a bit of what is possible, and drove in the fact that it is relatively easy to perform these analyses using the ASP addon, even if I am a beginner. It would've been nice to have a little bit more in-depth review and consolidation for how to build some of these cells (e.g., uncertain distributions) ourselves. 4) The provided Excel files were generally already completely set up. Argonne National Laboratories solver PCx is also downloadable from the web and has a very good implementation of Newton Barrier. LPSolve is a free solver with support for mixed integer programming that is downloadable from the web. 3) Instructional video did not go through some of the setup problems and alternate dialog windows that occur when using the temporary 15-day license. FrontLine is from FrontLine Systems, the same company that provides solvers for Microsoft Excel. I removed one star for these reasons: 1) the ***Monte Carlo function DID NOT WORK***on my 15-day license, so I was stuck guessing answers on the quizzes for this topic 2) Cells with distributions (e.g., Poisson) did not show up. There were a few early examples that used Microsoft's built-in Solver add-on, but as the course progressed, you need to have
![excel frontline solver examples excel frontline solver examples](https://www.solver.com/sites/all/themes/hitron/images/products-overviews/b16a4878160c669c79ccce86745550e6.png)
Note that you will need to download a proprietary (Frontline) "Analytics Solver" add-on for Excel that has a temporary 15-day license, so if your corporate network doesn't allow this, then you may need to do this on your personal computer. Excellent because this is a hands-on class where you download Excel files and do the analyses yourself.