Optiseek: Statistics, Solver & Goal Seek

Statistics, Solver and Goal Seek for Google Sheets

Optiseek gives Google Sheets the analysis tools you used in Excel: regression, t-tests and ANOVA written as Excel-style tables, a Solver for linear, integer and nonlinear models, and a Goal Seek that lands in a few recalculations.

Coming soon to Google Workspace Marketplace See pricing
Optiseek Solver sidebar after solving an integer production plan: 60 chairs, 59 tables, 8 desks and 1 shelf for a profit of 8,338, with labor and wood constraints satisfied

What it does

Data analysis, Excel layout

Descriptive statistics, histogram, correlation, covariance, rank and percentile, t, z, F and chi-square tests, ANOVA, regression, logistic regression, moving average, exponential smoothing, Fourier, sampling and random numbers.

Solver

Maximize, minimize or hit a value by changing cells, subject to constraints. Linear models get the exact global optimum; integer and binary cells use branch and bound; nonlinear models use SQP.

Goal Seek

Pick the formula, the target and the input. It usually lands in under 10 recalculations, to full precision, with Undo. Seek every row handles a whole table.

Reports

Answer and Sensitivity reports: final values, binding constraints, slack, shadow prices, reduced costs, allowable increase and decrease.

Any formula

SUM, SUMPRODUCT, lookups, other tabs. Sheets calculates the model; Optiseek never rewrites your formulas.

Your data stays put

Works only in the spreadsheet you open it in. Statistics run in Google Apps Script, the Solver in your browser.

Numbers you can check

Every statistic is tested against reference software. From our test suite:

WhatChecked againstAgreement
t, F, chi-square and normal p-values, including far tailsSciPy10 or more significant digits
Regression coefficients, standard errors, p-valuesstatsmodels13 or more digits
Longley regression (a classic accuracy test for spreadsheets)NIST certified values10 or more digits
t-tests, ANOVA, chi-square, logistic regressionSciPy, statsmodels13 or more digits
Linear and integer optimum, shadow pricesHiGHSto the last digit
Nonlinear test problems (Hock-Schittkowski 35 and 71, portfolio)published optima10 or more digits

Where Optiseek differs from Excel on purpose, the output tells you: Welch's t-test uses the exact degrees of freedom (as T.TEST, R and SciPy do), and standardized residuals account for leverage.

Regression output in a new tab: regression statistics, ANOVA table and coefficients with standard errors, t statistics, p-values and 95% intervals

How the Solver decides

  1. Automatic first checks whether your model is linear, by evaluating it at several points. If it is, the simplex method finds the global optimum (branch and bound adds integer and binary constraints), and you can write a Sensitivity report.
  2. If it isn't linear, it switches to Smooth nonlinear (sequential quadratic programming, the same family as Excel's GRG). It says Solved only after checking the optimality conditions; otherwise it says Converged and why.
  3. Nonsmooth handles IF, MAX, ABS and lookup-shaped models. Extra starting points search more widely when a model has several local optima.
  4. Every answer is checked on your sheet before it's reported. Stop keeps the best point so far; Restore original values puts your numbers back.
Sensitivity report with reduced costs, objective coefficients, shadow prices and allowable increases and decreases

Get started

  1. Install Optiseek, open a spreadsheet and choose Extensions > Optiseek, then Statistics, Goal Seek or Solver.
  2. Statistics: pick an analysis, select the data (with headers if you tick Labels), click Run. Output goes to a new tab.
  3. Goal Seek: select the formula cell first and it's filled in; type the target and the input cell, click Seek.
  4. Solver: objective cell, Max, Min or Value of, cells to change, constraints like B8:B9 <= C8:C9 or B2:B5 int, then Solve.

Pricing

$129 per year

About $10.75 a month. Statistics, Solver and Goal Seek, in any spreadsheet, for one Google account.

$12.99 per month

Same features, billed monthly.

$499 per year

Team plan: everyone at your company's Google Workspace domain.

Free trial

30 days or 40 runs, whichever comes first. A run is one analysis, one goal seek or one solve. Undo, Restore and reports are free. No card needed.

No surprise charges. We never charge you unless you start a checkout yourself. The add-on shows your trial status and these prices from the first minute. When the trial ends, Run, Seek and Solve ask you to pick a plan; nothing is charged and your sheet isn't changed.

Renewal. Monthly, annual and team plans renew automatically at the same price until you cancel. Cancel any time from Plans and billing in the add-on, in one step. You keep access until the end of the period you paid for.

Right to cancel (UK and EU). If you're a consumer in the UK or EU, you can cancel within 14 days of buying and get a full refund. Email hello@greatwork.company or cancel in Plans and billing and reply to the receipt.

Mistakes. Charged twice or by accident? Email us and we'll refund it.

Prices are in US dollars and exclude any sales tax or VAT that applies where you live. Payments are processed by Stripe; we never see your card number.

Help

My results differ slightly from Excel's.

Two differences are deliberate and labeled in the output: Welch's t-test uses exact (not rounded) degrees of freedom, and standardized residuals use leverage. Excel's Goal Seek also stops at a change of 0.001, so its answers are rounder than ours. Anything else: send us the sheet and we'll look.

The Solver says my model isn't linear.

It names the cell that doesn't change in straight lines (a product of two changing cells, an IF, a lookup). Use Automatic or Smooth nonlinear, or Nonsmooth for IF and lookups.

What counts as a run?

One analysis written to the sheet, one goal seek (or one Seek every row), or one solve. Undo, Restore original values, writing reports and saving a model don't count.

Still stuck?

Email hello@greatwork.company. A person replies within one business day.

Permissions Optiseek asks for, and why

When you install Optiseek, Google asks you to allow four things. Each one has a single job:

Optiseek doesn't ask for your Drive, your other spreadsheets or your Gmail.

Privacy