Sumquill: Data Analysis, Solver and Goal Seek for Google Sheets™

The Excel Analysis ToolPak, Solver and Goal Seek, rebuilt for Google Sheets. Results are written to your sheet as ordinary cells.

What it does

• Data analysis tools: descriptive statistics, histogram, correlation, covariance, regression, ANOVA (one-way and two-way), t-tests, z-test, F-test, moving average, exponential smoothing, rank and percentile, sampling and random numbers.
• Solver: Simplex LP (with integer and binary constraints) and a Nonlinear method, with constraints on any cells.
• Goal Seek: find the input that makes a formula hit a target value.

How it works

1. In Google Sheets, open Extensions > Sumquill.
2. Pick Data analysis tools, Solver or Goal Seek. In the sidebar, select cells and click ← to fill in a range.
3. Results go to a new sheet or a range you choose.

Free and Pro

Descriptive Statistics, Histogram, Correlation, Goal Seek, and Solver up to 10 variable cells are free. Sumquill Pro unlocks every other tool and larger Solver models for $29 a year, or $15 for a semester pass. Pro is bought from inside the add-on.

Private by design

Sumquill can only see the spreadsheet you're using it in, and your data never leaves Google Sheets. The only outside request it makes is checking a Pro license key with Gumroad. Read the privacy policy and terms.

Questions: hello@frontporchpuzzlepress.com

Google Sheets™ is a trademark of Google LLC. Sumquill is not affiliated with or endorsed by Google.