
1. Re: Excel Solver Equivalent or Optimal Solution
Paul Sherras Mar 2, 2016 1:51 AM (in response to nick.cook.0)Hi there Nick,
I am not familiar with the Solver addin, 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
Mark Fraser Mar 2, 2016 2:02 AM (in response to Paul Sherras)I am not familiar with the Solver addin, 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..
Define and solve a problem by using Solver  Excel
and
3 Easy Ways to Use Solver in Microsoft Excel  wikiHow
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
Mark Fraser Mar 2, 2016 2:08 AM (in response to Paul Sherras)1 of 1 people found this helpfulThis 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

4. Re: Excel Solver Equivalent or Optimal Solution
Paul Sherras Mar 2, 2016 3:38 AM (in response to nick.cook.0)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
Hope someone else can help you out!
Kind regards,
Paul

5. Re: Excel Solver Equivalent or Optimal Solution
Maxanne Durkee Oct 5, 2017 4:28 PM (in response to nick.cook.0)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
Paul Denton Oct 23, 2017 11:54 PM (in response to nick.cook.0)Hi. A possible solution might be to pass data to R https://cran.rproject.org/doc/manuals/Rintro.html#Top (install Rserver locally on your desktop) and load and use the "lpsolve" library. see https://cran.rproject.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
Edwin Straver Oct 25, 2017 3:04 PM (in response to Maxanne Durkee)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/exporttableau for more information.