ExceLabTM 4.0
Excel Calculus Powerhouse Add-in

Patented Library of Calculus Spreadsheet Functions

Solve complex calculus problems with simple formulas

  • Expand Excel native math function with a super set of powerful solvers.

  • Use the solvers in standard formulas exactly like native math functions.

  • Runs on all Localized-Windows versions.

  • No coding. No learning curves. Just basic Excel spreadsheet skills.

  • Lightweight add in with superfast 20-sec installation and you are up and running.

  • State of the art proven algorithms that work with superior performance.

  • Share your results workbook easily with your co-workers.

  • Evaluate free to your satisfaction.

  • Get prompt support and answers to questions from our experienced team.

What our users say

See full reviews

".. the ability to share models and results in a highly familiar platform..with near-zero learning-curve in using the program, have compelled me to break from the past and put in the effort to move our models to ExceLab."
"It is easy to learn and support provided by the admin staff is very nice. If anyone working on multi PDEs equation problems, just try this one you will love this solver"
"I found excel-works derivative functions quite useful. I was particularly pleased with the prompt response for assistance when I required some technical issues to be resolved....."
What can you solve with ExceLab

ExceLab is a unique add-in which extends Excel native math functions with a super set of powerful calculus functions. You use these functions in standard or array formulas just like native functions to solve elementary and advanced calculus problems including:

The functions offer you state of the art algorithms to effortlessly and accurately solve calculus problems with just basic spreadsheet skills and no programming. Navigate the Tabs above for quick examples.

Compute numerical integrals

  • Use QUADF to integrate formulas and user defined VBA functions

  • Use QUADXY to integrate (x,y) data points

  • Nest QUADF to compute multiple integrals of any order

  • Highly accurate adaptive algorithms

  • Finite and infinite limits

  • Singular integrands

Quick Example

0 1 ln x x d x =   ?

Solution

A
1=LN(X1)/SQRT(X1)
2=QUADF(A1,X1,0,1)
A
1#NUM!
2-4

Compute numerical derivatives

  • Use DERIVF to compute derivatives of formulas and VBA functions

  • Use DERIVXY to compute derivatives from (x,y) data points

  • Nest DERIVF to compute partial derivatives of any order

  • First and higher-order derivatives

  • Highly-accurate adaptive algorithm

Quick Example

f(x) = x sin(x2) +1 (π) =   ?

Solution

A
1=X1*SIN(X1^2)+1
2=DERIVF(A1,X1,PI())
A
11
2-18.248596

Interpolate 2D and 3D data points

  • Use INTERPXY to interpolate scattered 2D (x,y) points

  • Use INTERPXYZ to interpolate scattered 3D (x,y,z) points

  • Map your scattered (x,y) and (x,y,z) onto uniform grids and plot the curve or surface in Excel

  • Best known Natural Neighbour Algorithm

Quick Example: gridding and plotting 3D Scattered points

Scattered (x,y,z) data points
ABC
1xyz
20.1241620.0111090.124162
30.4687300.2297400.747031
..
510.2222740.0491640.635259
Evaluate INTERPXYZ array formula in yellow range
EFG..P
100.11
20=INTERPXYZ(A2:B51, z, grid_x, grid_y)
30.1
..
121
Highlight and insert Excel Surface plot

Find exact or best solution

  • Use NLSOLVE to solve a system of nonlinear equations

  • Find least error solution to coupled equations and inequalities constraints

  • Find Roots of non-linear equations

  • Proven Levenberg-Marquardt Algorithm

Quick Example

104x1x2-1=0 e-x1+e-x2-1.0001=0 x1,x2 = ?

Solution

Define equations
AX
1=10^4*X1*X2-11
2=EXP(-X1)+EXP(-X2)-1.00011
Solve with NLSOLVE function
AB
4=NLSOLVE(A1:A2,X1:X2)
5
Result
AB
4X19.10614674
5X21.09816E-05

Solve ordinary differential equations

  • Use IVSOLVE to solve an initial value problem ODE system

  • Use BVSOLVE to solve a boundary value problem ODE system

  • Highly-staple highly-accurate fully-implicit adaptive algorithms

  • Formatted output ready for plotting in Excel

Quick initial value ode example

dxdt=v,    x0=1,  v0=0 dvdt=-2ζωv-ω2x t ∈ [0, 12]

Solution

Define ODE variables and equations
ABCD
2tw1
3x1zeta0.25
4v0
6dx/dt=v
7dv/dt=-2*zeta*w*v-w^2*x
Solve with IVSOLVE function
IJK
1=IVSOLVE(B6:B7,(t,x,v),{0,12})
..
32
Plot results

Solve partial differential equations

  • Use PDSOLVE or to solve partial differential equations

  • Use PDASOLVE to solve partial differential algebraic equations

  • Robust Method of Lines with adaptive time step

  • Multiple regions with discontinuous properties

  • General boundary conditions

  • Flexible output formats for plotting transient and snapshot views

Quick Example: heat equation

ut=k2ux2,  
u0,t= 100
ux(1,t)=0
ux,0= 100x=00else
t ∈ [0,1], x ∈ [0,1]

Solution

Define PDE variables and equations
ABCD
1tk1
2x
3u=IF(x=0,100,0)
4ux
5uxxLeft BcRight Bc
6du/dt=k*uxx=u-100=ux
Solve with PDSOLVE function
ABCD
8=PDSOLVE(B6,B1:B5,C6,D6,{0,1},{0,1})
..
30
Plot results

Solve dynamical optimization and parameter estimation problems

Numerous Applications

  • Optimize your model parameters for best fit with experimental data

  • Estimate differential equations parameters

  • Maximize or minimize an objective formula subject to dynamic constraints with Excel Solver

See related journal publication Rapid Modeling and Parameter Estimation of Partial Differential Algebraic Equations by a Functional Spreadsheet Paradigm.Math. Comput. Appl. 2018, 23, 39.

Quick Example: compute unknown integral limits

f x a b = a b 1 - x2 + b d x

Find a,b such that

f x a b = 8.333333

Solution

Define variables, integral and constraint equations
AB
1a0
2b1
3integrand=1-x1^2+b
4integral=QUADF(B3,X1,a,b)
5constraint=B4-8.333333
Solve constraint equation for a, b with NLSOLVE function
AB
7=NLSOLVE(B5,(a,b))
8
Results
AB
7a-2
8b3

Solve optimal control problems

A typical optimal control problem has the form:

FInd u(t) and x(t) to maximize (or minimize) a cost index J

J=HxT,T+0TGxt,ut,tdt

Subject to

dxdt=fxt,ut,t x0=x0 xT=xT u(t)umax
  • Obtain rapid solutions with minimal effort and simple formulas. No programming.

  • Novel structured direct solution procedure combining Excel Solver with the calculus functions.

  • Method applicable to general (non standard) forms of optimal control problems .

  • Remarkable convergence and performance illustrated by several examples.

  • Consistent and sometime better results than complex methods.

Why should you work with us

Our product is engineered with over two-decades experience in computational calculus. ExceLab add-in is based on an innovative patented technology that represents a breakthrough in the utilization of the spreadsheet application with natural extension of native math functions to calculus. ExceLab functions are unique and have no parallels in the history of the spreadsheet application since its inception in the seventies.

ExceLab the simpler alternative to heavy-weight tools

About Us

  • We stand behind our product which stands on its own merits.

  • We help you with fast and effective support from our expert staff.

  • We deliver timely fixes to your issues.

  • We listen to your needs. Get involved in shaping the next release with features that matter to you.

About ExceLab

  • lightweight efficient library with one click installation and you are up and running.

  • State of the art proven algorithms that work. Best default settings yet you have full control with optional arguments.

  • Get rapid solutions to elementary and advanced calculus problems effortlessly with simple formulas in familiar Excel. Leave tedious coding and expensive complex tools behind

  • Flexible licensing plans that suit your needs.

We invite you to explore the solved problems in the manual and evaluate freely to experience the difference for yourself.

Teach your class with ExceLab
  • Excel is virtually on every computer. Very easy to learn the basics and use.

  • Help your students spend their time solving problems, not figuring out how to use complex tools.

  • Intutive yet powerful differential equations solvers and integrated optimization.

  • Simplified effective approach to optimal control problems for Engineering and Social Studies.

Contact us for practical arrangements that suit your requirements.

ExceLab functions at a glance
Question or Comment? Email us:
support @ excel-works.com
ExceLab: Transforming Excel into a Calculus Power House
ExceLab functions and methods are protected by USA Patents 9286286, 9892108, 10114812 and pending.
© 2015-2019, ExcelWorks LLC
Boston, USA