ExceLabTM 3.0
Excel Calculus Powerhouse Add-in

Patented Library of Calculus Spreadsheet Solvers

Solve complex calculus problems with simple formulas

  • Solvers just like Built-In Math functions

  • No coding. No learning curve. Just basic Excel skills

  • Fast 20-sec installation and you are up and running

What our users say

Read 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"
What can you solve with ExceLab

Integrals

Derivatives

Interpolation

Algebraic Systems

ODEs

PDEs

Dyn. Optimization

Optimal Control

Compute numerical integrals

  • Formulas, VBA functions, and (x,y) data points

  • Multiple integrals of any order by direct nesting

  • Highly accurate adaptive algorithms

  • Finite and infinite limits

  • Singular integrands

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

Compute numerical derivatives

  • Formulas, VBA functions, and (x,y) data points

  • Mixed partial derivatives of any order by direct nesting

  • First and higher-order derivatives

  • Highly-accurate adaptive algorithm

f(x) = x sin(x2) +1 (π) =   ?
A
1=X1*SIN(X1^2)+1
2=DERIVF(A1,X1,PI())
A
11
2-18.248596

Interpolate 2D and 3D data points

  • Map your scattered (x,y) and (x,y,z) onto a uniform grid and plot the surface in Excel

  • Best known Natural Neighbour Algorithm


ABC
1xyz
20.1241620.0111090.124162
30.4687300.2297400.747031
..
510.2222740.0491640.635259
EFG..P
100.11
20=INTERPXYZ(A2:B51, z, grid_x, grid_y)
30.1
..
121

Find exact or best solution

  • Non-linear coupled equations

  • Systems with inequalities constraints

  • Roots of non-linear equations

  • Proven Levenberg-Marquardt Algorithm

104x1x2-1=0 e-x1+e-x2-1.0001=0 x1,x2 = ?
AX
1=10^4*X1*X2-11
2=EXP(-X1)+EXP(-X2)-1.00011
AB
4=NLSOLVE(A1:A2,X1:X2)
5
AB
4X19.10614674
5X21.09816E-05

Solve ordinary differential algebraic equations

  • Initial value problems

  • Boundary value problems

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

  • Formatted output ready for plotting in Excel

dxdt=v,    x0=1,  v0=0 dvdt=-2ζωv-ω2x
ABCD
2tw1
3x1zeta0.25
4v0
6dx/dt=v
7dv/dt=-2*zeta*w*v-w^2*x
IJK
1=IVSOLVE(B6:B7,(t,x,v),{0,12})
..
32

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

ut=k2ux2,  
u0,t= 100 ux(1,t)=0 ux,0= 100x=00else
ABCD
1tk1
2x
3u=IF(x=0,100,0)
4ux
5uxxLeft BcRight Bc
6du/dt=k*uxx=u-100=ux
ABCD
8=PDSOLVE(B6,B1:B5,C6,D6,{0,1},{0,1})
..
30

Solve dynamical optimization and parameter estimation problems

  • Seamless integration with Excel Solver or ExceLab Solver

  • Optimize your model parameters for best fit with experimental data

Applications

  • Estimate differential system parameters

  • Compute integrals limits

  • Maximize a constrained dynamic objective with Excel Solver

  • Dynamic curve fitting

  • Numerous possibilities

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

Find a,b such that

f x a b = 8.333333
AB
1a0
2b1
3integrand=1-x1^2+b
4integral=QUADF(B3,X1,a,b)
5constraint=B4-8.333333
AB
7=NLSOLVE(B5,(a,b))
8
AB
7a-2
8b3

Solve optimal control problems

Maximize (or Minimize)

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

Subject to

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

  • Structured direct solution procedure combining ExceLab calculus functions with Excel Solver.

  • Remarkable convergence and performance illustrated by several worked examples.

  • Consistent and sometime better results than complex methods See Publications.

Why should you work with us
  • Our product is engineered with over two-decades experience in computational calculus.

  • Highly-efficient lean solver library smaller than a picture in size!!

  • Evaluate freely to see the value and experience the difference for yourself.

ExceLab the alternative to heavy-weight coding tools

About Us

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

  • We help you with fast and effective support from 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

  • Featherlight 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 with simple formulas in familiar Excel. Leave tedious coding and expensive complex tools behind.

  • Share your results workbook with any one who has Excel. Who doesn't !

  • Flexible licensing plans that suit your needs.

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
© 2015-2018, ExcelWorks LLC
Boston, USA