I. Overview

This add-on from ExcelWorks extends Google Sheets® with a powerful superset of advanced calculus functions. These functions are used directly in standard spreadsheet formulas—similar to built-in Google Sheets functions—to solve a wide range of calculus problems.

For example, to compute the integral of a formula stored in cell A1 with respect to X1 between 1 and 2, simply use the QUADF function:

=QUADF(A1, X1, 1, 2)


Likewise, to solve a system of coupled equations defined by formulas in Y1, Y2, and Y3 with respect to variables X1, X2, and X3, use the NLSOLVE function:

=NLSOLVE(Y1:Y3, X1:X3)


It really is that simple. Yet behind this simplicity lies a suite of state-of-the-art, proven numerical algorithms delivering exceptional performance and precision. These functions are protected by U.S. Patents 10,628,634; 10,114,812; 9,892,108; and 9,286,286, and have been used globally since 2015.

By installing this add-on, you can solve a wide variety of calculus problems, including:

Computing single and multiple integrals of any order (with finite or infinite limits)

Computing first- and higher-order derivatives of functions

Computing integrals and derivatives of discrete (x, y) data using spline techniques

Interpolating and gridding scattered 2D and 3D data points

Solving nonlinear equations and inequalities

Solving least-squares curve-fitting problems

Solving ODE and DAE initial- and boundary-value problems

Solving PDE problems

Solving parametric optimization problems

In practice, these calculus functions can be combined to solve complex parametric optimization problems with remarkable ease. Examples include computing limits of an integral given a target value, finding points where a derivative attains a specified value, and many other advanced scenarios.

The add-on also includes powerful 2D and 3D interpolation functions based on spline and natural-neighbor algorithms. For example, GRIDXYZ allows you to interpolate scattered (x, y, z) data points onto a uniform rectilinear grid for convenient surface plotting.

No specialized programming skills are required beyond basic familiarity with spreadsheet concepts. Each function includes detailed help pages with multiple examples. We recommend reviewing these examples and becoming familiar with the required and optional parameters for each function.

If you are interested in a desktop version of this software, ExcelWorks also offers an Excel® add-in that includes additional advanced ODE/PDE solvers and dynamic optimization capabilities. Visit excel-works.com for publications and examples.

II. Important Technical Limitations
Support for Non-English Locales

You may keep your preferred locale and language settings; however, English function names must be used in formulas. If your default language is not English, follow these steps:

Click File → Spreadsheet settings

Under Display language, enable Always use English function names

Click Save settings

III. Do Your Part to Keep This Add-On Free

Our goal is to make these powerful calculus functions accessible to every student. Achieving this requires sustainable funding to offset the cost of providing the service.

When you install the add-on, you receive a free account with a preset daily evaluation quota, currently set to approximately 100 solver evaluations per day (subject to change). For uninterrupted use, you may purchase a daily, weekly, or monthly unlimited access pass.

You can help make these calculus functions freely available without imposed quotas by taking the following actions:

Rate the add-on — Your review is important to users, Google, and our team.

Send feedback to Google requesting that advanced calculus capabilities be supported directly within spreadsheet products.

For questions or comments, please contact us at support@excel-works.com
.

Trademark Notice

Google Sheets® and Google® are trademarks of Google LLC.
This add-on is developed by ExcelWorks and is not affiliated with or endorsed by Google LLC.