Solve Nonlinear Equations with Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 10 ธ.ค. 2024

ความคิดเห็น • 27

  • @nikosgeorgiou8137
    @nikosgeorgiou8137 4 ปีที่แล้ว +3

    Hi ! Why do you set objective cell E4 and not E6 ? Isn't sum of E3 and E4 (Cell E6) the function that we want to minimaze ?
    Thanks for the upload

    • @apm
      @apm  4 ปีที่แล้ว +2

      Yes, you are correct. Excel guessed that my objective was $E$4 and I didn't change it from the default. In this case, it doesn't matter if the objective is set correctly (it could be any random cell) because I added conditions that the equations had to be equal to zero. This creates a unique solution with equal number of equations and variables (zero degrees of freedom). An objective is important when there are multiple possible solutions that satisfy the equations. The objective is used to pick the best one. Here is an optimization problem: apmonitor.com/che263/index.php/Main/ExcelSolver Thanks for the great comment!

  • @AJ-et3vf
    @AJ-et3vf 3 ปีที่แล้ว +1

    Very helpful educational videos sir! Thank you! I learned a lot from your videos.

  • @jgonsalk
    @jgonsalk 7 ปีที่แล้ว +2

    Is it just me or did that example minimize E4, which is a constraint rather than the objective function? Either way, I did appreciate this tutorial. Thanks!

    • @apm
      @apm  7 ปีที่แล้ว

      +Jehan Music, you can either minimize the sum of the squared errors (E6 or E7, later) or add the constraints individually. I added the constraints individually so it didn't really matter what I included as the objective because there were two equations and two unknowns (or 3 eqns / 3 vars later). For some nonlinear problems with multiple potential solutions, the objective function can give guidance on which feasible solution is best.

  • @phones-boloniak3443
    @phones-boloniak3443 3 ปีที่แล้ว +2

    Thank you for the video! When I try this I get an error in model, please verify that all cells and constraints are valid. This same error comes up with any equation I try to use solver on. Is there something I need to change in my settings?

    • @apm
      @apm  3 ปีที่แล้ว

      Maybe try it again, exactly copying what I had?

  • @smk_18
    @smk_18 5 ปีที่แล้ว +2

    helped me to solve my assignments! Thank you!!

    • @apm
      @apm  5 ปีที่แล้ว

      I'm glad that it helped. Check out apmonitor.com/che263 for more content.

  • @pedroviegas6276
    @pedroviegas6276 4 ปีที่แล้ว +1

    Helped me so much! Thanks, bro!

    • @apm
      @apm  4 ปีที่แล้ว

      Glad it helped!

  • @mehistoire6367
    @mehistoire6367 7 ปีที่แล้ว +1

    Thank you, really helped!

  • @laxmidevkota4385
    @laxmidevkota4385 4 ปีที่แล้ว +1

    Thank you so much

  • @bim_engineer_structural
    @bim_engineer_structural 7 ปีที่แล้ว +1

    Thank you

  • @diogooliveira2708
    @diogooliveira2708 7 ปีที่แล้ว

    great, I need minimize this function " sum( ( ( VR - VM ) .* QI ./ ( VM + eps ) ) .^2 ) " where VR is a value that I want to find and VM is a value that I have and QI I have too. The constraints are the mass balance. Is possible ? could you help me please ?

    • @apm
      @apm  7 ปีที่แล้ว +1

      +Diogo Oliveira, you can add the constraints in the solver dialog box. You'll want to pose it as an optimization problem like I've shown here apmonitor.com/che263/index.php/Main/ExcelSolver You will want to use Matlab or Python if you have more than 50 variables.

    • @diogooliveira2708
      @diogooliveira2708 7 ปีที่แล้ว

      Thanks a lot. I am studying chemical engineering in brazil. I like studying optimization problems. I use your videos to learn more. In my internship I'm trying to optimize this function. Sorry for my english I am learning too.
      do you have an email for contact?
      Thanks

  • @DenmarkSigne
    @DenmarkSigne 8 ปีที่แล้ว +1

    Thank you!

  • @MohamedHassan-bz7km
    @MohamedHassan-bz7km 7 ปีที่แล้ว

    how can i show the 2 possible answers not 1 answer ?

    • @apm
      @apm  7 ปีที่แล้ว +1

      +mohamed hassan, the Excel solver produces a local solution so you'll need to solve two instances with different initial guesses or constraints that will give the two local answers.

  • @canseckiner
    @canseckiner 5 ปีที่แล้ว +1

    Thank you :)

    • @apm
      @apm  5 ปีที่แล้ว

      You're welcome, Can.

  • @ruancabralexatas6370
    @ruancabralexatas6370 7 ปีที่แล้ว

    How to do it when x 0

    • @apm
      @apm  7 ปีที่แล้ว +1

      Entendendo a Engenharia, at 6:30 you can add additional constraints such as your inequality constraints.

    • @ruancabralexatas6370
      @ruancabralexatas6370 7 ปีที่แล้ว

      The solver returns the limit value, in this case 1 or 0 when I actually wanted it to be between 0 and 1. I need this solution. I need this solution, but thank you in advance.

    • @apm
      @apm  7 ปีที่แล้ว

      Entendendo a Engenharia, if the solver report says that it converged then it is likely the correct solution or at least a local optimum. You can try to change the value of x to see if you get a better solution. With continuous variables, x>0 and x>=0 are the same because of machine precision in storing values.

    • @ruancabralexatas6370
      @ruancabralexatas6370 7 ปีที่แล้ว +1

      I will do this. Thank you for your help