This unique Add-on from ExcelWorks extends Google Sheets with a super set of powerful calculus functions which you use in standard formulas to solve various calculus problems.
Listing updated:February 13, 2022
Works with:
21K+
Overview
I. Overview

This unique Add-on from ExcelWorks extends Google Sheets with a super set of powerful calculus functions which you use in standard formulas just like native functions to solve various calculus problems. For example, to integrate a formula stored in A1 with respect to X1 between 1 and 2, you use the QUADF function in a formula just like this

=QUADF(A1, X1, 1, 2)

Likewise, to solve coupled equations defined by formulas in Y1, Y2 and Y3 with respect to the variables X1, X2 and X3, you use the NLSOLVE function in a formula just like this

=NLSOLVE(Y1:Y3, X1:X3)

It is that simple!  But have no doubts, these magical all new calculus functions pack state of the art proven algorithms with potent performance and precision. They are supported by US Patents 10628634, 10114812, 9892108 and 9286286, and are being utilized  around the Globe since 2015.

By installing this Add-in, you will be able to solve a variety of calculus problems including:
1.  Computing single and multiple integrals of any order (with finite and infinite limits).
2.  Computing first and higher order derivatives of functions.
3.  Computing integrals and derivatives of discrete (x,y) data points by aid of splines.
4.  Interpolating and gridding scattered 2D and 3D data points.
5.  Solving nonlinear equations and inequalities.
6.  Solving least-square curve fitting problems.
7.  Solving ODE and DAE initial and boundary value problems.
8. Solving PDE problems.
9.  Solving parametric optimization problems.

In fact, you can combine the calculus functions to solve very complex parametric optimization problems with remarkable ease. For example:  compute limits of an integral given its value; or compute a point at which a function derivative assumes a specified value; and many other possibilities. The Add-on also packs very powerful 2D and 3D interpolation functions based on splines and natural neighbor algorithms.  For example, with GRIDXYZ, you can easily interpolate scattered (x,y,z) data points onto a uniform rectilinear grid for easy surface plotting. No skills are required to use the calculus functions beyond basic familiarity with Excel spreadsheet concepts and rules. The detailed help pages for each function contain several examples to get you started. We recommend reviewing these examples and familiarizing with the required and optional parameters for a given functions.

If you are interested in a desktop version of this App, we offer an Excel add-in which packs additional very powerful ODE/PDE solver functions and dynamical optimization. Check out excel-works.com for publications and examples.

II. Important Technical Limitations

Support for Non-English Locale

You can keep your preferred locale and language settings but English function names must be used in formulas. If your default language is not English, do the following:
1.	Click File -> Spreadsheet settings.
2.	Under "Display language," check "Always use English function names" 
3.	Click Save Settings.

Google Daily Usage Quotas

Please use the functions responsibly to avoid hitting Google’s strict daily imposed quotas. For example, if you are interpolating many points, evaluate the interpolation function once by passing in the points as a vector rather than invoking the function many times.
In the unlikely event that Google’s daily quotas are reached, unfortunately Google will block the Add-on for a period of 24 hours. We have no control over this.

III. Do your part to keep this Add-on free

It is our objective to put these functions at the fingertips of every student, but this cannot be realized without sustainable funding to offset our own cost of offering the service to you.  On installing this add-on, you will be granted a free account with preset daily evaluation quota which is currently set at approximately 100 solver evaluations per day and is subject to change. For uninterrupted use, you are offered the option to purchase a daily, weekly, or monthly unlimited access pass. 
You can help making the calculus functions available for free without imposed quota by taking the following actions:
1.	Rate the add-on. Your review is important for the add-on, our users, Google, and us.
2.	Send feedback to Google to request that these calculus functions be made available as standard native functions without imposed daily quotas. Click Help->Report a problem to send feedback to Google.


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

Sincerely,
Chahid Ghaddar, PhD.
Author of the calculus add-on and founder of ExcelWorks LLC
excel-works.com
Additional information
PricingFree of charge with paid features
Developer
Trader status unspecified
Privacy policy
Terms of service
Calculus Functions Add-on will ask for the permissions shown below. Learn more
Calculus Functions Add-on will need access to your Google account
This will allow Calculus Functions Add-on to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Matt van Wijk
May 18, 2024
Very handy for integrations, just wished that there was no quota.
Is this review helpful?
Yes
No
Profile Picture
Maanav Doshi
May 23, 2023
Excellent ad on. Useful for solving linear programming problems
Is this review helpful?
Yes
No
Profile Picture
Ron Vynzer Devera
April 18, 2023
Used this and it was useful. Just wished that there was no quota.
Is this review helpful?
Yes
No
Profile Picture
Noah Beckish
March 14, 2023
Very useful
Is this review helpful?
Yes
No
Profile Picture
Azrin Aziz
July 27, 2023
please have it built-in in excel
Is this review helpful?
Yes
No
Profile Picture
Denis Pro
February 9, 2021
It works OK if you have no access to any more capable software, but publisher's attitude is not OK. After some unknown time or an unknown number of executions you are hit with execution throttling. It is not described anywhere. Based on trial and error it looks to be 200 executions per day. If you need to debug you calculations you can forget it. What a shame - publisher does not even have honesty to be transparent about their bait ands switch strategy. Bottom line, don't waste your time unless you plan to use it all the time - you will be lured to try and then regret when you have to redo it on another platform. And if you do need to use it all the time, the ridiculous cost of a very limited and poorly documented package may be better spent to pay a student to write script for you.
Is this review helpful?
Yes
No
Profile Picture
Pranay Pawar
November 19, 2021
Very nice function .Useful for engineering problems.
Is this review helpful?
Yes
No
Profile Picture
Bryan Heilman
April 12, 2021
I like the idea but does it support integrals without limits specified? I would like to use it for engineering problems in class but its seems like it will not let use the integration operation to find the function of, say, shear stress from integrating the function for the external force which would then be used for other calculations. Besides that it seems easy enough to use and more than accurate enough for my needs.
Is this review helpful?
Yes
No
Profile Picture
CHEAH YU KI / UPM
May 25, 2022
Very useful but the quota is so limited...
Is this review helpful?
Yes
No
Profile Picture
Giovanni Cicci
November 14, 2022
Making us pay for this... seriously?
Is this review helpful?
Yes
No
1-10 of 20
Search
Clear search
Close search
Google apps
Main menu