- 36
- 418 680
ExcelWorks LLC
United States
เข้าร่วมเมื่อ 13 ก.ย. 2015
ExcelWorks LLC was founded by Dr. Chahid K. Ghaddar the inventor of ExceLab calculus add-in for Excel. ExceLab reaps the computational power of Excel in a new dimension. It introduces an innovative functional computing paradigm based on pure worksheet functions, which expand the class of problems that can be solved in Excel.
ExceLab derives from two decades of scientific computing and professional software development. Its patented design eliminates the burden of programming, and greatly simplifies the solution of complex problems in calculus, differential systems and optimization with state of the art algorithms and competitive performance.
You can learn more about ExceLab Add-in as well as download your free evaluation license at excel-works.com.
ExceLab derives from two decades of scientific computing and professional software development. Its patented design eliminates the burden of programming, and greatly simplifies the solution of complex problems in calculus, differential systems and optimization with state of the art algorithms and competitive performance.
You can learn more about ExceLab Add-in as well as download your free evaluation license at excel-works.com.
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.
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
they need licence right?
Can’t believe this is the first comment. This is an excellent video that is clearly and distinctly explained. Wonderful, thank you!
Excellent examples
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)?
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.
Hi though i have completed all steps, i am getting Value error, i am using excelab 365, with office 365
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.
Search for "Calculus Functions Add-on" if you are using Google Sheets. "ExceLab" is nor found anymore.
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
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.
This function is amazing, saves me a lot of work... thanks..
Where do i find INTERPXYZ.xlam file
Hello sir, sorry my English so bad, but my excel don't have the =DERIVF😭
does this work with limits between 0 and PI
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
hi, is it possible to calculate the volume from the xyz data using excels?
where did you define the time variable t
The time variable is defined in the second argument of IVSOLVE. See more examples at excel-works.com/manual/ivsolve#
Thank you sir,Its very nice explanation
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?
Please see excel-works.com/support/faq for hints about #VALUE! errors.
When I do it only shows one result, how do I fix it
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?
Question is Can it solve System of PDE(nonlinear) time and space both dependent
It can solve nonlinear systems of PDE equations in time and one spatial variable. See excel-works.com/manual/pde for more examples.
What if I just have the data, but not the formula?
How to solve the integration of 52dx integral from 0 to 73?
Can we solve upto fourth order non-homogenious partial differential equations in excel
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.
For help contact product support.
This does not show how to plot surface in Google Sheets.
Currently Google sheets does not offer a built-in surface plotting feature. Only in Excel.
I keep getting a #VALUE! error. I tried it several different ways and I still get the error
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.
how do you do the surface graph in google sheet?
Zc
hi
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?
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.
@@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.
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?
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?
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.
@@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.
@@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
how you compute integral? mine showed busy
how can i insert IVsolve in the programm
You must enable the add-in first. See excel-works.com/support/installation
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?
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.
When we type X1 or Y1 as variables, doesn't Excel consider the CELL X1 and not the variable x?
Couldn't find the excelab sheet
How to reversely turn the grid-form values to X,Y,Z 3 column values?
Good question, I laboriously did it manually to create a huge long column.
@@ericrawson2909 I really need it.
Please send me excel jessicatyler0007@gmail.com
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?
You need to run ExceLab 7.0 installer after downloading it to install the add-in.
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?
You could hover over the error sign which is displayed next to a cell with #VALUE! error to see the actual error message.
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.
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.
First
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? ???
The functions has been updated in ExceLab 7.0. See updated video th-cam.com/video/tbmI1lyOgd0/w-d-xo.html
Are you in a hurry?
This is 2D interpolation, not 3D. Probably not buying anything from a math company that cannot tell the difference.
how to add thıs addition?
See excel-works.com/support/installation
it shows the argument 3 should be a 2 column x,y value, why is that??
In ExceLab 7.0 the function name is GRIDXYZ
If you have solved undamped Wave 1d equation, why is the amplitude decreasing after each time step?
Where all my pro EFI/ ECU tuners at?