Microsoft Excel 2011 Mac Solver

Nov 08, 2014  In Excel, go to the Tools menu and choose Add-Ins Make sure Solver is shown in the list and has its checkbox checked. If Solver is not in the list, click the Add button and choose it in the resulting Finder dialog. I am an unpaid volunteer and do not work for Microsoft. Solver for Excel 2011 for Mac downloads and installs directly onto the Excel program without any problems or user input required. After opening Excel, the user must go to the add-in area.

Analytic Solver is Frontline Systems’ new analytics platform for Excel. It is both evolutionary – a 100% compatible upgrade for users of all of Frontline’s previous Solver products (including Solver in Excel) – and revolutionary – a “cloud-first” platform rewritten from the ground up using JavaScript, new Microsoft APIs, and Frontline’s RASON cloud service.

Analytic Solver now comes in two versions: Analytic Solver Desktop, which runs on Excel for Windows (only) and solves models entirely on your PC, and Analytic Solver Cloud, which runs on Excel for Windows, Excel for Macintosh, and Excel for the Web, and solves models “in the cloud” – using Frontline’s RASON server on Microsoft Azure (or if desired on your company’s own RASON server).

Analytic Solver Desktop must be installed on your Windows PC by running our SolverSetup program. Analytic Solver Cloud needs no Setup program – you simply “insert” it once into your copy of Excel, a process that takes just a few seconds. You could walk up to a business center PC or borrow a friend’s Macintosh, login to Office 365 and Analytic Solver, immediately start working on your models (using desktop Excel or Excel Online), and finish with no files or programs left on that computer. Analytic Solver Cloud does require a constant Internet connection and an Office 365 subscription.

One license, for one price, gives you full access to both versions. The Ribbon and Task Pane user interface is nearly identical in both versions, and your models work the same way in both versions. Analytic Solver Cloud includes each of our “licensed subset” products: Analytic Solver Basic, Analytic Solver Upgrade, Analytic Solver Optimization, Analytic Solver Simulation, Analytic Solver Data Mining, and Analytic Solver Comprehensive. Your license gives you the same feature set and capacities in both Analytic Solver Desktop and Analytic Solver Cloud.

Our pricing for Analytic Solver Desktop + Cloud is the same as before – you get Analytic Solver Cloud at no extra cost! But solving large/complex models in Analytic Solver Cloud has CPU time limits, so you may well want to use Analytic Solver Desktop for long-running models.

Mac

Capability

Analytic Solver Desktop

Analytic Solver Cloud

Operating System required

Windows only

Windows, MacOS, others via browser and Excel Online

Office version required

Office 2010-2019, Office 365

Office 365 (Win, Mac, browser)

Analytic Solver Ribbon, Task Pane

Yes

Yes

Data Mining Ribbon, Task Pane

Yes

Yes

160+ Psi functions (e.g. PsiNormal)

Yes

Yes

120+ Example models/datasets

Yes

Yes

Optimization – Solver upgrade

Yes

Yes

Monte Carlo simulation

Yes

Yes except some chart controls

Data/text mining, forecasting

Yes

Yes

Data/text mining, forecasting

Yes

Yes

Simulation optimization, robust
optimization, stochastic LPs

Yes

Yes

5 Built-in Solver Engines

Yes

Yes

8 Large-Scale Solver Engines

Yes

Yes

Data Mining Workflows

Yes

Yes

Guided Mode, Wizards

Yes

Yes except Constraint Wizard

Frequently Asked Questions

Do I need an Office 365 subscription to use Analytic Solver Cloud?

Yes – Analytic Solver Cloud relies on recently-added capabilities and JavaScript APIs that are present in the latest subscription versions of Excel – but not in older, non-subscription versions. Even Office 2019, which was finalized in mid to late 2018, does not have the necessary capabilities and JavaScript APIs.

I have a license for Analytic Solver from last year. Can I use Analytic Solver Cloud?

Yes – your license entitles you to use Analytic Solver current version, both Analytic Solver Desktop and Analytic Solver Cloud, at no extra charge. If you have less than Analytic Solver Comprehensive power in your current license, talk to us about an optional upgrade for optimization, simulation, or data mining!

Will Analytic Solver Cloud work in Excel for Macintosh, running under MacOS?

Yes – as long as you have the latest Excel version on an Office 365 subscription. Macs are “first-class citizens” for Analytic Solver Cloud. You can also use Analytic Solver Cloud in Excel Online through Safari.

Can Analytic Solver Cloud be used on a Linux computer?

Yes – using Excel Online through a web browser such as Chrome or Firefox. And Excel workbook models you create this way are fully usable in Analytic Solver Desktop and Cloud on Windows and Mac PCs.

Will my model created in Excel’s Solver work in Analytic Solver Cloud?

Yes – Analytic Solver Cloud will automatically recognize your Solver model when you click the Analytic Solver Ribbon tab and the Model button – just click the Optimize button! Note that since VBA is not available in the cloud, VBA macros like SolverOK and SolverSolve won’t work in Analytic Solver Cloud.

Can I create a model in Analytic Solver Cloud, then use in it Analytic Solver Desktop?

Microsoft excel solver tool

Yes – you can do this, and vice versa (create a model in Analytic Solver Desktop and use it in Analytic Solver Cloud). Both versions are equally capable, and models are fully inter-operable between them.

Can I use Analytic Solver Desktop and Analytic Solver Cloud on a Windows PC?

Yes – in this case, Analytic Solver Cloud will “defer to” Analytic Solver Desktop. You’ll see the Analytic Solver and Data Mining Ribbon tabs from Analytic Solver Desktop, and models will be solved on your PC.

My company restricts us from “using the cloud”. Is there a way I can use Analytic Solver Cloud?

Stay in touch with us – if/when Microsoft enhances Office add-ins for 'offline use', your company can license our RASON Standalone Server, and run it on an on-premise Windows Server.

What are your future plans for Analytic Solver Desktop and Analytic Solver Cloud?

Microsoft Excel 2011 Windows

We plan to keep enhancing both versions for the foreseeable future. But like Microsoft, we’ve adopted a “cloud-first” strategy: Analytic Solver Cloud is likely to get more rapid enhancements than Analytic Solver Desktop. There may be “cloud-only features” that don’t apply to Analytic Solver Desktop.