Using the Excel solver to model experimental data

Поділитися
Вставка
  • Опубліковано 5 вер 2024
  • There are a number of videos demonstrating how to use the Excel solver already on the web. Here I focus on an example of modeling scientific data using the add in.

КОМЕНТАРІ • 15

  • @ilhanbey47
    @ilhanbey47 10 місяців тому

    allah razı olsun hiçbir yerde yoktu çok işime yaradı

  • @goldminutes
    @goldminutes 6 років тому +1

    Thank you very much! This was exactly the explanation I was looking for. Very well set out and easy to follow!

    • @carlleon9849
      @carlleon9849 3 роки тому

      You all probably dont care at all but does anybody know a trick to log back into an instagram account??
      I stupidly forgot the password. I would appreciate any tips you can give me!

    • @davionfabian5178
      @davionfabian5178 3 роки тому

      @Carl Leon instablaster =)

    • @carlleon9849
      @carlleon9849 3 роки тому

      @Davion Fabian thanks so much for your reply. I got to the site on google and I'm waiting for the hacking stuff atm.
      Looks like it's gonna take quite some time so I will reply here later with my results.

    • @carlleon9849
      @carlleon9849 3 роки тому

      @Davion Fabian it did the trick and I finally got access to my account again. I'm so happy!
      Thank you so much you saved my account!

    • @davionfabian5178
      @davionfabian5178 3 роки тому

      @Carl Leon Glad I could help :D

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

    Very helpful
    Thanks mate

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

    Great video! Very explanatory. My van Deemter plot is not coming out right at all though. My experimental H values do not descend and ascend like your data.

  • @burnsm2012
    @burnsm2012 2 місяці тому

    Would u please show how to enter the formula

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

    Thanks. Can you tell or make a video on how to set-up the changing value cells?

  • @dnb3800
    @dnb3800 3 роки тому

    Isn't the model that you used here the reduced van Deemter equation?
    What if I want to calculate the diffusion coefficient of my analyte?

    • @bobthechemist
      @bobthechemist  3 роки тому

      The B terms is 2DL where D is the diffusion coefficient in the mobile phase and L is the length of the column. That assumes Gaussian peak shapes and I have never tried to assess diff. coefficients from chromatography so I cannot attest to the precision and accuracy of this approach.

  • @abdallahbouguettoucha4784
    @abdallahbouguettoucha4784 5 років тому

    Thnaks and hapy new year2019

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

    The question would be: how to find the correct equation to fit raw data.