7 Replies Latest reply on Oct 25, 2017 3:04 PM by Edwin Straver

# Excel Solver Equivalent or Optimal Solution

Hello, I have a tool in Excel that based on two parameters calculates the optimal solution via Solver add-in. I really want this simple tool to live on our Tableau Server. Does such a feature/function exist within Tableau?

• ###### 1. Re: Excel Solver Equivalent or Optimal Solution

Hi there Nick,

I am not familiar with the Solver add-in, can you direct me where to get it and I will look at the VBA to see if I can replicate it in Tableau for you

Thanks Paul

• ###### 2. Re: Excel Solver Equivalent or Optimal Solution

I am not familiar with the Solver add-in, can you direct me where to get it

Paul, Solver is an Excel plug in for 'what if' and other mathematical analysis such as shortest path analysis..

and

I would suggest, its not really the domain of Tableau, Solver is more likely to be used in Tableau as source only.

Best of luck though, if you can do it, patent it!

Cheers

Mark

• ###### 3. Re: Excel Solver Equivalent or Optimal Solution

This is the kind of thing I have used Solver for >>

It was actually one about tomatoes in varying grades but cant find it now, hopefully you get the idea

1 of 1 people found this helpful
• ###### 4. Re: Excel Solver Equivalent or Optimal Solution

Hi Nick,

Okay, now I understand more of what you are after I can see exactly what you mean!

Whilst it might be possible to create a solution to one problem via calculated fields, I see what you are asking is for something a lot more powerful than that

Kind regards,

Paul

• ###### 5. Re: Excel Solver Equivalent or Optimal Solution

I have a need for Tableau to do some optimizations like the one mentioned in this Excel Article. "An introduction to optimization with the Excel Solver tool" I know if Excel can do it, Tableau can do it better. It sounds like having a dynamic field that will trigger recalculations.

Anyone have a solution for something like this?

• ###### 6. Re: Excel Solver Equivalent or Optimal Solution

Hi. A possible solution might be to pass data to R https://cran.r-project.org/doc/manuals/R-intro.html#Top   (install Rserver locally on your desktop)  and load and use the "lpsolve" library. see https://cran.r-project.org/web/packages/lpSolve/index.html

You can pass values from Tableau to R (using "script" calculations)see http://public.tableau.com/views/Irisdata/PetalDimensions?:embed=y&:showVizHome=no&:display_count=y&:display_static_image=y&:bootstrapWhenNotified=true  ) and run various stats packages in R, so there may be a similar way of passing the value to lpsolve . I have a similar requirement to yourself to run a solver package so I am currently exploring this as an option, but I am still learning baby steps with R.

• ###### 7. Re: Excel Solver Equivalent or Optimal Solution

Starting in Tableau 10.5, you'll be able to use Analytic Solver to export your model from Excel to Tableau, This will require you to have a license to Analytic Solver in order to build the custom extension with your model in it. See www.solver.com/export-tableau for more information.