# Analogue package for SOLVER in excel? Other solution?

**URL:** <https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633>\
**Category:** General Usage\
**Created:** [March 10, 2018, 3:33pm UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633 "2018-03-10T15:33:35Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![programista](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/programista/32/5372_2.png) [@programista](https://discourse.julialang.org/u/programista)\
**Post date:** [March 10, 2018, 3:33pm UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/1 "2018-03-10T15:33:35Z")

</div>

What is the analogue package for SOLVER in excel?  
I have a function with 3 parameters a, b, c and a data vector DATA, the output is a scalar, I need to find a combiner a, b, c to make the result \> minimum ?  
Is analogue package for SOLVER in excel? Other solution ?  
Any hint ?  
Paul

---

<div class="post-metadata">

**Author:** ![pkofod](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pkofod/32/2179_2.png) [@pkofod](https://discourse.julialang.org/u/pkofod)\
**Post date:** [March 10, 2018, 3:40pm UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/2 "2018-03-10T15:40:03Z")

</div>

Are you solving a linear programming problem? Smooth nonlinear? Nonsmooth nonlinear?

---

<div class="post-metadata">

**Author:** ![programista](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/programista/32/5372_2.png) [@programista](https://discourse.julialang.org/u/programista)\
**Post date:** [March 10, 2018, 3:43pm UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/3 "2018-03-10T15:43:27Z")

</div>

Smooth nonlinear.  
Paul

---

<div class="post-metadata">

**Author:** ![programista](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/programista/32/5372_2.png) [@programista](https://discourse.julialang.org/u/programista)\
**Post date:** [March 11, 2018, 10:47am UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/4 "2018-03-11T10:47:54Z")

</div>

Some help ?  
Paul

---

<div class="post-metadata">

**Author:** ![xiaodai](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/xiaodai/32/15937_2.png) [@xiaodai](https://discourse.julialang.org/u/xiaodai)\
**Post date:** [March 11, 2018, 11:10am UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/5 "2018-03-11T11:10:12Z")

</div>

Optim.jl and JuMP.jl

---

<div class="post-metadata">

**Author:** ![pkofod](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pkofod/32/2179_2.png) [@pkofod](https://discourse.julialang.org/u/pkofod)\
**Post date:** [March 12, 2018, 10:56am UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/6 "2018-03-12T10:56:11Z")

</div>

I obviously have a special interest in promoting Optim.jl, but you can also look to BlackBoxOptim.jl and NLopt.jl depending on your problem type and setup in general (do you want to pass in generic AbstractArrays? Then NLopt.jl won’t work out of the box, etc)

---

<div class="post-metadata">

**Author:** ![programista](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/programista/32/5372_2.png) [@programista](https://discourse.julialang.org/u/programista)\
**Post date:** [March 12, 2018, 6:16pm UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/7 "2018-03-12T18:16:15Z")

</div>

Big thanks, I am traying 🙂 but is no easy to me:/

i have my\_function(a,b,c), it return x. How (and which package) to find  
a ,b, c for the lowest x ? my\_function is non linear .

Paul

W dniu 2018-03-12 o 12:01, Patrick Kofod Mogensen pisze:

---

<div class="post-metadata">

**Author:** ![pkofod](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pkofod/32/2179_2.png) [@pkofod](https://discourse.julialang.org/u/pkofod)\
**Post date:** [March 12, 2018, 7:03pm UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/8 "2018-03-12T19:03:19Z")

</div>

You can try Optim or any of the other packages mentioned. Do you know more about your problem? Is it continuous? Differentiable?

In Optim you would do something like the following (the absolute minimal example)

```julia
x0 = fill(0.0, 3) # use three 0's as starting values for a,b,c
my_vector_function(x) = my_function(a,b,c)
optimize(my_vector_function, x0)

```

---

<div class="post-metadata">

**Author:** ![programista](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/programista/32/5372_2.png) [@programista](https://discourse.julialang.org/u/programista)\
**Post date:** [March 13, 2018, 9:04am UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/9 "2018-03-13T09:04:51Z")

</div>

Thanks It is working !

---

<div class="post-metadata">

**Author:** ![programista](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/programista/32/5372_2.png) [@programista](https://discourse.julialang.org/u/programista)\
**Post date:** [March 16, 2018, 11:15am UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/10 "2018-03-16T11:15:53Z")

</div>

I have multivariate optimization:

> x0 = fill(0.5, 3) (makes x0.1, x0.2 x0.3) Is posible |enter the limit  
> separatly for each other ? like this : |1 \> x0.1 \>0 |||1 \> x0.2 \>0| |||2 \> x0.3 \>0 or one for all ? | Paul |

> >

W dniu 2018-03-12 o 20:08, Patrick Kofod Mogensen pisze:

---

<div class="post-metadata">

**Author:** ![pkofod](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pkofod/32/2179_2.png) [@pkofod](https://discourse.julialang.org/u/pkofod)\
**Post date:** [March 16, 2018, 12:19pm UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/11 "2018-03-16T12:19:42Z")

</div>

Sorry, I don’t understand the question.

---

<div class="post-metadata">

**Author:** ![programista](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/programista/32/5372_2.png) [@programista](https://discourse.julialang.org/u/programista)\
**Post date:** [March 16, 2018, 12:32pm UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/12 "2018-03-16T12:32:55Z")

</div>

I hope it is ok ,  
x0 = fill(0.5, 3)  
optimize(my\_fun,x0)

How to write the bounds? Lik thise is ok ? :

optimize(my\_fun,x0.|1 \> x0[1] \>0 |||1 \> x0[2] \>0| |||2 \> x0[3] \>0)

?

Paul

W dniu 2018-03-16 o 13:24, Patrick Kofod Mogensen pisze:

---

<div class="post-metadata">

**Author:** ![kristoffer.carlsson](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/kristoffer.carlsson/32/22_2.png) [@kristoffer.carlsson](https://discourse.julialang.org/u/kristoffer.carlsson)\
**Post date:** [March 16, 2018, 12:53pm UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/13 "2018-03-16T12:53:05Z")

</div>

[http://julianlsolvers.github.io/Optim.jl/latest/user/minimization/#box-minimization](http://julianlsolvers.github.io/Optim.jl/latest/user/minimization/#box-minimization)

---

<div class="post-metadata">

**Author:** ![programista](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/programista/32/5372_2.png) [@programista](https://discourse.julialang.org/u/programista)\
**Post date:** [March 16, 2018, 1:13pm UTC](https://discourse.julialang.org/t/analogue-package-for-solver-in-excel-other-solution/9633/14 "2018-03-16T13:13:28Z")

</div>

Thanks ,  
works, but wihout Newton algoritm  
Paul

W dniu 2018-03-16 o 13:58, kristoffer.carlsson pisze: