Все публикации

How to find best fitting curve for (x,y) data points in Excel and Google Sheets with NLSOLVE()

How to solve a system of equations in Excel and Google Sheets with NLSOLVE()

How to solve initial value ode system in Excel and Google Sheets with IVSOLVE()

How to solve a PDE system in Excel and Google Sheets with PDSOLVE()

How to solve boundary value ode system in Excel and Google Sheets with BVSOLVE()

How to plot surface from scattered (x,y,z) data points in Excel and Google Sheets with GRIDXYZ()

How to interpolate from a set of (x,y,z) points in Excel and Google Sheets with INTERPXYZ()

How to compute accurate numerical derivatives in Excel and Google Sheets with DERIVF()

How to interpolate (x,y) data points in Excel and Google Sheets with INTERPXY()

How to compute an (x,y) graph integral in Excel and Google Sheets with QUADXY()

How to differentiate an (x,y) graph in Excel and Google Sheets with DERIVXY()

How to compute numerical integrals in Excel and Google Sheets with QUADF()

Direct Method for Optimal Control Problems with Excel Solver

Solving Partial Differential Equations in Excel - Part 3

Solving Partial Differential Equations in Excel - Part 2

Solving Partial Differential Equations in Excel - Part 1

3D interpolation and Surface Plotting in Excel

Using Excel’s Solver to Optimize an Integral of a function

ExceLab: Patented Calculus add-in for Excel Spreadsheet

How to define and integrate a VBA user defined function in Excel with QUADF()

Solving partial differential equations in Excel

Numerical integration examples in Excel

Solving and optimizing the response of a differential equations system in Excel

Computing optimal limits for a multiple integral example in Excel