ExcelWorks LLC
ExcelWorks LLC
  • 36
  • 418 680
How to find best fitting curve for (x,y) data points in Excel and Google Sheets with NLSOLVE()
Key words: nonlinear regression, least-squares errors, curve fitting Levenberg, Marquardt, NLSOLVE
This video demonstrates how to use the function NLSOLVE() to find least-squares best fitting curve for a set of (x,y) data points in both Excel and Google Sheets. NLSOLVE is based on Levenberg, Marquardt algorithm and is included in the ExceLab calculus functions add-in which is available from excel-works.com.
มุมมอง: 1 932

วีดีโอ

How to solve a system of equations in Excel and Google Sheets with NLSOLVE()
มุมมอง 6K3 ปีที่แล้ว
Key words: nonlinear equations, Levenberg, Marquardt, NLSOLVE This video demonstrates how to use the function NLSOLVE() to solve nonlinear equation systems in both Excel and Google Sheets. Multiple examples are illustrated including a system with inequality equation and a parameterized integral problem. NLSOLVE is included in the ExceLab calculus functions add-in which is available from excel-w...
How to solve initial value ode system in Excel and Google Sheets with IVSOLVE()
มุมมอง 2.2K3 ปีที่แล้ว
Key words: ordinary differential equations, initial value problem, ODE, IVSOLVE This video demonstrates how to use the function IVSOLVE() to solve nonlinear initial value ordinary differential equations in both Excel and Google Sheets. IVSOLVE is included in the ExceLab calculus functions add-in which is available from excel-works.com.
How to solve a PDE system in Excel and Google Sheets with PDSOLVE()
มุมมอง 1.4K3 ปีที่แล้ว
Key words: partial differential equations, PDE, PDSOLVE This video demonstrates how to use the function PDSOLVE() to solve nonlinear partial differential equations in both Excel and Google Sheets. PDSOLVE is included in the ExceLab calculus functions add-in which is available from excel-works.com.
How to solve boundary value ode system in Excel and Google Sheets with BVSOLVE()
มุมมอง 5803 ปีที่แล้ว
Key words: ordinary differential equations, boundary value problem, ODE, BVSOLVE This video demonstrates how to use the function BVSOLVE() to solve higher-order nonlinear boundary-value ordinary differential equations in both Excel and Google Sheets. BVSOLVE is included in the ExceLab calculus functions add-in which is available from excel-works.com.
How to plot surface from scattered (x,y,z) data points in Excel and Google Sheets with GRIDXYZ()
มุมมอง 6K3 ปีที่แล้ว
Key words: interpolate, surface interpolation, natural neighbor algorithm, Voronoi, GRIDXYZ This video demonstrates how to use the function GRIDXYZ() to interpolate a set of scattered (x,y,z) data points onto a uniform rectilinear grid in both Excel and Google Sheets, and, how to generate a surface plot in Excel using the interpolated grid data. GRIDXYZ is based on natural neighbor algorithm an...
How to interpolate from a set of (x,y,z) points in Excel and Google Sheets with INTERPXYZ()
มุมมอง 6K3 ปีที่แล้ว
Key words: interpolate, surface interpolation, natural neighbor algorithm, Voronoi, INTERPXYZ This video demonstrates how to use the function INTERPXYZ() to interpolate from a set of discrete (x,y,z) data points in both Excel and Google Sheets. INTERPXYZ is based on natural neighbor algorithm and is included in the ExceLab calculus functions add-in which is available from excel-works.com.
How to compute accurate numerical derivatives in Excel and Google Sheets with DERIVF()
มุมมอง 4.5K3 ปีที่แล้ว
Key words: derivative, numerical differentiation, partial derivative, higher order derivatives, DERIVF This video demonstrates how to use the function DERIVF() to compute first and higher order derivatives of any function in both Excel and Google Sheets. The video also demonstrates how to nest DERIVF to compute mixed and partial derivatives of any order. DERIVF is included in the ExceLab calcul...
How to interpolate (x,y) data points in Excel and Google Sheets with INTERPXY()
มุมมอง 8K3 ปีที่แล้ว
Key words: interpolate, interpolation, graph, data set points, INTERPXY This video demonstrates how to use the function INTERPXY() to interpolate on a graph generated from discrete (x,y) data set points in both Excel and Google Sheets. INTERPXY is based on splines and is included in the ExceLab calculus functions add-in which is available from excel-works.com.
How to compute an (x,y) graph integral in Excel and Google Sheets with QUADXY()
มุมมอง 6K3 ปีที่แล้ว
Key words: integral, integration, graph, data set points, QUADXY This video demonstrates how to use the function QUADXY() to compute accurate integral of a graph generated from discrete (x,y) data set points in both Excel and Google Sheets. QUADXY is included in the ExceLab calculus functions add-in which is available from excel-works.com.
How to differentiate an (x,y) graph in Excel and Google Sheets with DERIVXY()
มุมมอง 4.7K3 ปีที่แล้ว
Key words: derivative, differentiation, data set points, DERIVXY This video demonstrates how to use the function DERIVXY() to compute first and higher order derivatives of a graph generated from discrete (x,y) data set points in both Excel and Google Sheets. DERIVXY is included in the ExceLab calculus functions add-in which is available from excel-works.com.
How to compute numerical integrals in Excel and Google Sheets with QUADF()
มุมมอง 15K3 ปีที่แล้ว
Key words: integral, numerical integration, higher-order, multiple, double, triple, volume, QUADF This video demonstrates the use of the integration functions QUADF() for computing accurate integrals in both Excel and Google Sheets. Several examples are solved including fixed limits, infinite limits and singular points. The video also demonstrates how to nest QUADF to compute multiple integrals...
Direct Method for Optimal Control Problems with Excel Solver
มุมมอง 1.5K7 ปีที่แล้ว
The Author has devised a simple yet highly effective technique for solving general optimal control problems in Excel spreadsheet. The technique employs Excel’s Solver, in conjunction with ExceLab calculus Add-in to implement a direct solution method. The technique is demonstrated on several highly nonlinear multi-variable constrained control problems with remarkable results in terms of reliabil...
Solving Partial Differential Equations in Excel - Part 3
มุมมอง 9837 ปีที่แล้ว
This 3-part video demonstrates how easy to solve and optimize virtually any PDE system in Excel with PDASOLVE() worksheet function included in ExceLab Calculus Add-in. In Part1 we introduce the solver using a simple PDE system. In Part2 we model and solve a complex 3-equation system. In Part3, we optimize the model solved in Part2 to predict experimental data. ExceLab is a unique Add-in from Ex...
Solving Partial Differential Equations in Excel - Part 2
มุมมอง 2.2K7 ปีที่แล้ว
This 3-part video demonstrates how easy to solve and optimize virtually any PDE system in Excel with PDASOLVE() worksheet function included in ExceLab Calculus Add-in. In Part1 we introduce the solver using a simple PDE system. In Part2 we model and solve a complex 3-equation system. In Part3, we optimize the model solved in Part2 to predict experimental data. ExceLab is a unique Add-in from Ex...
Solving Partial Differential Equations in Excel - Part 1
มุมมอง 11K7 ปีที่แล้ว
Solving Partial Differential Equations in Excel - Part 1
3D interpolation and Surface Plotting in Excel
มุมมอง 59K7 ปีที่แล้ว
3D interpolation and Surface Plotting in Excel
Using Excel’s Solver to Optimize an Integral of a function
มุมมอง 2K7 ปีที่แล้ว
Using Excel’s Solver to Optimize an Integral of a function
ExceLab: Patented Calculus add-in for Excel Spreadsheet
มุมมอง 4.6K8 ปีที่แล้ว
ExceLab: Patented Calculus add-in for Excel Spreadsheet
How to define and integrate a VBA user defined function in Excel with QUADF()
มุมมอง 5K8 ปีที่แล้ว
How to define and integrate a VBA user defined function in Excel with QUADF()
Solving partial differential equations in Excel
มุมมอง 13K9 ปีที่แล้ว
Solving partial differential equations in Excel
Numerical integration examples in Excel
มุมมอง 94K9 ปีที่แล้ว
Numerical integration examples in Excel
Solving and optimizing the response of a differential equations system in Excel
มุมมอง 2.6K9 ปีที่แล้ว
Solving and optimizing the response of a differential equations system in Excel
Computing optimal limits for a multiple integral example in Excel
มุมมอง 9369 ปีที่แล้ว
Computing optimal limits for a multiple integral example in Excel
Solving a nonlinear system of equations in Excel by NLSOLVE() function - Part 2
มุมมอง 6K9 ปีที่แล้ว
Solving a nonlinear system of equations in Excel by NLSOLVE() function - Part 2
Solving nonlinear system of equations and inequalities in Excel by NLSOLVE() function - Part 1
มุมมอง 7K9 ปีที่แล้ว
Solving nonlinear system of equations and inequalities in Excel by NLSOLVE() function - Part 1
Computing numerical derivative from discrete data points in Excel by DERIVXY() function
มุมมอง 35K9 ปีที่แล้ว
Computing numerical derivative from discrete data points in Excel by DERIVXY() function
Computing higher order partial derivatives in Excel by DERIVF() function
มุมมอง 6K9 ปีที่แล้ว
Computing higher order partial derivatives in Excel by DERIVF() function
Computing first and higher order numerical derivatives in Excel by DERIVF() function
มุมมอง 9K9 ปีที่แล้ว
Computing first and higher order numerical derivatives in Excel by DERIVF() function
Solving boundary value problems in Excel - Part 2
มุมมอง 9769 ปีที่แล้ว
Solving boundary value problems in Excel - Part 2

ความคิดเห็น

  • @Pejuang_fakta
    @Pejuang_fakta 25 วันที่ผ่านมา

    they need licence right?

  • @one2omg154
    @one2omg154 หลายเดือนก่อน

    Can’t believe this is the first comment. This is an excellent video that is clearly and distinctly explained. Wonderful, thank you!

  • @wilberalamiroloyolacarranz2406
    @wilberalamiroloyolacarranz2406 3 หลายเดือนก่อน

    Excellent examples

  • @Paul-zp6wx
    @Paul-zp6wx 5 หลายเดือนก่อน

    At 5:40 in the numerator parenthesis, it's supposed to be (1-6*x*x*w-6*x*v) instead of (1-6*x*x*w-6*x*x)?

  • @splendylate777
    @splendylate777 10 หลายเดือนก่อน

    Worked for me but just because i have office 365 and I have search on Google "Microsoft AppSource store". Then there I look for ExceLab. Closed all the excel tabs before installing the add-in.

  • @midhunpillai1306
    @midhunpillai1306 11 หลายเดือนก่อน

    Hi though i have completed all steps, i am getting Value error, i am using excelab 365, with office 365

    • @excelworksllc1994
      @excelworksllc1994 11 หลายเดือนก่อน

      Check out excel-works.com/support/faq to find out how to read the actual error message. Also review excel-works.com/support/installation to make sure you followed the steps to activate the account.

  • @JoachimSpange
    @JoachimSpange 11 หลายเดือนก่อน

    Search for "Calculus Functions Add-on" if you are using Google Sheets. "ExceLab" is nor found anymore.

  • @alirezabahadorbeigi3045
    @alirezabahadorbeigi3045 11 หลายเดือนก่อน

    Dear excel, first of all, thanks for teaching from you, how fix the value error for QUADF Function in excel, I have more complexity function and then can't detect error exactly is, while checked entire calculations from inputs to this error, please help me and of course I installed related add-in

  • @nicolasamaya1307
    @nicolasamaya1307 ปีที่แล้ว

    By any chance, do you know how are this functions named in spanish Excel?. I've been seeking out this for a very long time. 😭 Or do you know if there is a function that does this on Python? thanks.

  • @leemallett9364
    @leemallett9364 ปีที่แล้ว

    This function is amazing, saves me a lot of work... thanks..

  • @joyantamitra8186
    @joyantamitra8186 ปีที่แล้ว

    Where do i find INTERPXYZ.xlam file

  • @saddamzaenela6681
    @saddamzaenela6681 ปีที่แล้ว

    Hello sir, sorry my English so bad, but my excel don't have the =DERIVF😭

  • @oRawStormz
    @oRawStormz ปีที่แล้ว

    does this work with limits between 0 and PI

  • @Leo-wt9yd
    @Leo-wt9yd ปีที่แล้ว

    sorry i can't make DERIVF work... like in your video i write =DERIVF(here i select the cell with the formula, but here when i select the cell with the variable excel says: the formula contains an error.... i don't understand... the add-in is fully installed and loaded

  • @arlan72
    @arlan72 ปีที่แล้ว

    hi, is it possible to calculate the volume from the xyz data using excels?

  • @hugocheung3833
    @hugocheung3833 2 ปีที่แล้ว

    where did you define the time variable t

    • @excelworksllc1994
      @excelworksllc1994 2 ปีที่แล้ว

      The time variable is defined in the second argument of IVSOLVE. See more examples at excel-works.com/manual/ivsolve#

  • @bommalingaiahb6124
    @bommalingaiahb6124 2 ปีที่แล้ว

    Thank you sir,Its very nice explanation

  • @siyasiya4784
    @siyasiya4784 2 ปีที่แล้ว

    I have installed the add-in and I can find it now, but when I press enter I get #Value. How do I fix this?

    • @excelworksllc1994
      @excelworksllc1994 2 ปีที่แล้ว

      Please see excel-works.com/support/faq for hints about #VALUE! errors.

  • @gml3412
    @gml3412 2 ปีที่แล้ว

    When I do it only shows one result, how do I fix it

  • @wolframload4198
    @wolframload4198 2 ปีที่แล้ว

    Dear sir thanks for explanation for the methodology you applied.. I want to built a model for a tank carried out with a truck and fixed 6 points over the truck.. I wanna know the reaction forces.. Using solver Is it possible?

  • @0xbinarylol
    @0xbinarylol 2 ปีที่แล้ว

    Question is Can it solve System of PDE(nonlinear) time and space both dependent

    • @excelworksllc1994
      @excelworksllc1994 2 ปีที่แล้ว

      It can solve nonlinear systems of PDE equations in time and one spatial variable. See excel-works.com/manual/pde for more examples.

  • @matheusdinizmoro1336
    @matheusdinizmoro1336 2 ปีที่แล้ว

    What if I just have the data, but not the formula?

  • @darisplays551
    @darisplays551 2 ปีที่แล้ว

    How to solve the integration of 52dx integral from 0 to 73?

  • @VishalSingh-zs5tr
    @VishalSingh-zs5tr 2 ปีที่แล้ว

    Can we solve upto fourth order non-homogenious partial differential equations in excel

  • @andrewcole4367
    @andrewcole4367 2 ปีที่แล้ว

    Hello, I'm having trouble using this to find the point where two lines intersect: y=mx+c. I have gradient and 0 intersection for both lines in cells already.

  • @robinhughes-jones4034
    @robinhughes-jones4034 3 ปีที่แล้ว

    This does not show how to plot surface in Google Sheets.

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

      Currently Google sheets does not offer a built-in surface plotting feature. Only in Excel.

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

    I keep getting a #VALUE! error. I tried it several different ways and I still get the error

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

      If you click in the cell with #VALUE! Excel will display an error symbol next to it. Point at the error symbol to read the actual error message. Most likely you added ExceLab 365 but did not sign in to enable the add-in. From the Ribbon click Formulas->Account->Sign in.

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

    how do you do the surface graph in google sheet?

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

    Zc

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

    hi

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

    I can't get this to work. In the end I created a small test data set. If I use a formula like =INTERPXYZ(A2:B10,C2:C10,{0.2,0.5}) and press enter I get #VALUE! If I use a formula like =INTERPXYZ(A2:B10,C2:C10,D2:E4) and press Ctrl+Shift+Enter I get #NAME? I am using Office 365, downloaded the add-in from Microsoft app store, Acer laptop, Windows 10. I have been struggling with this for a couple of days now. Can anyone suggest what I might be doing wrong please?

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

      Point your cursor at the error symbol which is displayed when your click on the cell with #VALUE! and read the actual error message. A #NAME error usually means your add-in is not enabled or your data contains undefined name. For further help contact Support.

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

      @@excelworksllc1994 Thank you for the rapid response. I discovered that the #name was caused by typing interxyz, the p was missing. Hovering over the error symbol I get "Unauthorised. Please click Formulas - Calculus Functions - Account - Sign in. I will see if I can do that using my Microsoft account.

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

      OK, I followed the advice and went through the login process as per my previous comment. It now works, but says my licence expires in three days time. I am wondering if I will need to pay for a licence after that?

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

    I have been trying to get this to work for hours, I just get BUSY followed by #VALUE in the cell when I enter the formula. I am using Office 365 on an ACER laptop, I installed the add-in from the Microsoft app store. I have tried lots of different data sets. It's so frustrating. Any ideas what I might be doing wrong?

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

      Point your cursor at the error symbol which is displayed when your click on the cell with #VALUE! and read the actual error message (likely you just need to sign in). For further help, please contact support.

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

      @@excelworksllc1994 I'm running into the same issue. I'm signed into Office 365 and installed the add-in through Excel. Any help would be appreciated.

    • @tuquantran2891
      @tuquantran2891 ปีที่แล้ว

      @@arcticcat91jag92 similar problem, it seems the add-in asks to sign-in. You can go to the tab Fomulas --> Calculus Functions --> Account --> Sign-in. It works for my case. Hope it help

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

    how you compute integral? mine showed busy

  • @Said-mb5tx
    @Said-mb5tx 3 ปีที่แล้ว

    how can i insert IVsolve in the programm

    • @excelworksllc1994
      @excelworksllc1994 2 ปีที่แล้ว

      You must enable the add-in first. See excel-works.com/support/installation

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

    I used this GRIDXYZ() as stated in this video to interpolate a f(x,y) function. I started from a (6 rows x 10 columns) table of x y with known z values in each cell and then built a 60x101 table of interpolated values to fill with GRIDXYZ. I chose an increment of 0.1, so I obtained a 60x101 table to fill, but when I use the GRIDXYZ function, I get "the allocated range is too small to interpolate grid z-values" Is it possible to contact you?

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

      As described in the video, if you are using ExceLab 7.0, you must run GRIDXYZ formula as array formula by highlighting the range and pressing CTRL+SHIFT+ENTER. In ExceLab 365 and Google Sheets which support the SPILL feature you can run the formula as a standard formula by pressing ENTER. Please refer to the manual page excel-works.com/manual/gridxyz for more detail.

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

    When we type X1 or Y1 as variables, doesn't Excel consider the CELL X1 and not the variable x?

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

    Couldn't find the excelab sheet

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

    How to reversely turn the grid-form values to X,Y,Z 3 column values?

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

      Good question, I laboriously did it manually to create a huge long column.

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

      @@ericrawson2909 I really need it.

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

    Please send me excel jessicatyler0007@gmail.com

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

    I followed the exact instructions on this video, but I can't make the derivf function work for me. After a seemingly successful download, I do not see this Excel Lab program in my add-ins, nor can I find it manually by looking in C:\Program Files\ExcelWorks\ExceLab 7.0\bin or C:\Program Files (x86)\ExcelWorks\ExceLab 7.0\bin per the instructions. Any ideas on what I can try next?

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

      You need to run ExceLab 7.0 installer after downloading it to install the add-in.

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

    Hi. i have (x,y,z) data from a survey (GPS) and in trying to use the given functions and it is not working. would you know why?

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

      You could hover over the error sign which is displayed next to a cell with #VALUE! error to see the actual error message.

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

    hi, i've tried using the IVSOLVE function with ExceLab 365 but it keeps returning a #VALUE! error. However, this function works fine when i have used it in google sheets. I have used the correct syntax for each too. Any help on solving the issue in ExceLab 365 would be appreciated.

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

      In 365 you can hover over the error sign which is displayed next to the #VALUE! to read the actual error message. For product questions contact support.

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

    First

  • @عبدالرحمنمحمد-ج9ر4ض
    @عبدالرحمنمحمد-ج9ر4ض 3 ปีที่แล้ว

    I installed it, but, it said Error processing argument 3: Argument 3 reference must be a 2 column range of (x,y) interpolation data points. What should I do to fix this issue? ???

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

      The functions has been updated in ExceLab 7.0. See updated video th-cam.com/video/tbmI1lyOgd0/w-d-xo.html

  • @75hilmar
    @75hilmar 4 ปีที่แล้ว

    Are you in a hurry?

  • @matth.2922
    @matth.2922 4 ปีที่แล้ว

    This is 2D interpolation, not 3D. Probably not buying anything from a math company that cannot tell the difference.

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

    how to add thıs addition?

    • @excelworksllc1994
      @excelworksllc1994 2 ปีที่แล้ว

      See excel-works.com/support/installation

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

    it shows the argument 3 should be a 2 column x,y value, why is that??

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

      In ExceLab 7.0 the function name is GRIDXYZ

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

    If you have solved undamped Wave 1d equation, why is the amplitude decreasing after each time step?

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

    Where all my pro EFI/ ECU tuners at?