Find Equation Roots with Excel

Поділитися
Вставка
  • Опубліковано 14 лис 2024

КОМЕНТАРІ • 19

  • @greciamanrique9909
    @greciamanrique9909 4 роки тому +3

    just wanted to thank you for going in-depth with this. I learned a lot and just what i was looking for.

    • @apm
      @apm  4 роки тому +1

      I'm glad it helped.

    • @greciamanrique9909
      @greciamanrique9909 4 роки тому +1

      @@apm I was wondering if there was a way you could go over solving Peng Robinson equations in excel using a scope of different molar volumes

  • @mouradyousfi221
    @mouradyousfi221 Рік тому +1

    Thank you very much, that's great. Finally I was able to find the roots of any equation

  • @RealLoveDragon
    @RealLoveDragon 5 років тому +5

    god bless this man

  • @muhammadirfan8035
    @muhammadirfan8035 6 років тому +2

    Sir why you took the square of the difference before using solver function? And how do we know that what should we use initial guess for volume of liquid and vapors?

    • @apm
      @apm  6 років тому

      The solver function minimizes the result. We use the square to make the objective equal to zero at the minimum value. If you didn't take the square it would go to negative Infinity. The best initial guess for a vapor is an ideal gas approximation. For liquid, you could use the density of water as a starting point.

    • @muhammadirfan8035
      @muhammadirfan8035 6 років тому

      @@apm Thanks a lot for your kind and timely response!

  • @giftt.kmzembe7626
    @giftt.kmzembe7626 2 роки тому +1

    Good day can you please help on how you do the quadratic equations roots ....using iteration say of energy conservation equation equal to a constant and solve for flow per unit length

    • @apm
      @apm  2 роки тому

      You can set it up as a root finding problem. More information is at APMonitor.com/che263

  • @sum1sw
    @sum1sw 4 роки тому +1

    Nice work Sir.

  • @sujay8212
    @sujay8212 2 роки тому

    Thank you it was very helpful

  • @madhurendramadhukar280
    @madhurendramadhukar280 4 роки тому +1

    How can I solve this equation using solver:
    0.66 u3 -4.77u =-12.06

    • @apm
      @apm  4 роки тому

      In Excel, you can follow the same method but include your coefficients. Here it is in Excel: apmonitor.com/che263/index.php/Main/ExcelSolveEquations or Python: apmonitor.com/che263/index.php/Main/PythonSolveEquations

    • @madhurendramadhukar280
      @madhurendramadhukar280 4 роки тому

      I tried to solve this just after writing this question and I did it successfully.
      Thanks

  • @craniumkracked8189
    @craniumkracked8189 3 роки тому +1

    Thanks mate

  • @gopalverma1067
    @gopalverma1067 4 роки тому +1

    Thanks

  • @gabrielaurrego391
    @gabrielaurrego391 7 років тому +1

    Hello! How do you know 1.1*b is a good approximation for the liquid root? is that just a fact? :)

    • @apm
      @apm  7 років тому

      Volume can't get below "b". A value about 10% higher than the lower bound is a good place to start with an initial guess.