Better Work AppsInstall free

Free public beta · Google Sheets add-on

100+ tools and functions. One Google Sheets add-on.

Replace a patchwork of point add-ons with one workspace for ToolPak-style statistics, Solver, Goal Seek, Data Tables, Monte Carlo simulation, data preparation and workbook review.

The Marketplace install link will appear here when the public listing is approved.

Inside the app

Interface preview based on Sheet Analyst v3.3.0. The visible sheet context changes with your workbook.

Inside the workflows

Move from question to answer without changing tools.

Each workflow uses focused inputs, safe defaults and reviewable output. Long-running Solver and Monte Carlo tasks include visible progress and a safe stop control.

Decision Making

Solver

Optimize an objective while respecting changing cells and business constraints.
Sheet Analyst · Solver
Objective cellModel!$D$12
MaximizeMinimizeValue of
Changing cellsInputs!$B$4:$B$8
Model!$F$8:$F$12≤Limits!$B$2:$B$6
Linear model detectionStop safely

What-If Analysis

Goal Seek

Work backward from a target result to the input value that achieves it.
Sheet Analyst · Goal Seek
Set cellForecast!$D$12
To value250,000
By changing cellAssumptions!$B$6
Target reachedChanging value: 18.42% · Residual: 0.00003

Sensitivity

Data Tables

See how one or two inputs change the result across a decision grid.
Sheet Analyst · Data Tables
Row input: B6Column input: B7
Margin8%10%12%1,0001842052261,5002612923232,000338379420

Simulation

Monte Carlo

Model uncertainty with probability distributions, percentiles and charts.
Sheet Analyst · Monte Carlo
P10
182kMedian
247kP90
329k
10,000 iterations completeFast Local

Statistics

Regression

Generate model statistics, ANOVA output and coefficient estimates.
Sheet Analyst · Regression
Regression statisticsObservations: 240
VariableCoefficientP-value
Intercept12.4820.002
Price-1.9300.018
Campaign4.2160.006
R² 0.84Results written to a new sheet

Faithful interface previews based on Sheet Analyst v3.3.0. Example ranges and values are fictional.

Included workflows

From raw data to a decision-ready workbook.

Analyze

Descriptive statistics, regression, correlation, ANOVA, hypothesis tests, histograms, sampling and time-series tools.

Model

Goal Seek, Solver, scenarios and one- or two-variable sensitivity tables for decision models.

Simulate

Monte Carlo simulation, distribution fitting, bootstrap analysis and forecasting tools.

Audit

Find formula errors, hardcodes, inconsistencies, risky references and workbook structure problems.

Prepare

Clean, reshape, split, combine, join, consolidate, compare and format spreadsheet data.

Work with formulas

Inspect formulas, trace relationships, save snippets and check Excel compatibility.

Available functions

See what is included.

Open a category to browse the current capability set. You do not need separate add-ons for each category.

100+ listed capabilitiesGrouped by the job you need to do
Included in beta
Statistical analysisAnalysis ToolPak-style methods for exploring data, relationships and hypotheses.22
  • Descriptive statistics
  • Histogram
  • Rank and percentile
  • Correlation matrix
  • Covariance matrix
  • Multiple linear regression
  • Logistic regression
  • ANOVA: single factor
  • ANOVA: two-factor with replication
  • ANOVA: two-factor without replication
  • F-test for variances
  • Paired t-test
  • Two-sample t-test: equal variances
  • Two-sample t-test: unequal variances
  • Two-sample z-test
  • Moving average
  • Exponential smoothing
  • Fourier analysis
  • Random and periodic sampling
  • Random number generation
  • Outlier detection
  • Bootstrap confidence interval
What-if and optimizationDecision tools for targets, constraints, scenarios and sensitivity.17
  • Goal Seek
  • Linear Solver
  • Mixed-integer Solver
  • Nonlinear Solver
  • Evolutionary Solver
  • Solver constraints
  • Non-negative decision variables
  • Solver answer report
  • Solver sensitivity analysis
  • Restore original model values
  • One-variable Data Table
  • Two-variable Data Table
  • Scenario setup
  • Save scenario values
  • Apply scenario
  • Scenario summary
  • Stop long-running optimization safely
Simulation and forecastingRisk, probability and time-series workflows for uncertain decisions.16
  • Monte Carlo simulation
  • Automatic simulation engine
  • Fast local simulation engine
  • Workbook simulation engine
  • Reproducible random seed
  • Multiple uncertain inputs
  • Multiple result cells
  • Correlated inputs
  • Simulation histogram
  • Cumulative S-curve
  • Percentile summary
  • Raw simulation export
  • Distribution fitting
  • Seasonal forecast
  • Simulation safety limits
  • Stop and restore model inputs
Clean and prepareRepeatable, spreadsheet-native preparation for messy operational data.30
  • Trim whitespace
  • Remove non-printing characters
  • Collapse repeated spaces
  • Remove blank rows
  • Convert numbers stored as text
  • Remove duplicate rows
  • Change text case
  • Replace or remove line breaks
  • Fuzzy match
  • Find and replace values
  • Find and replace formulas
  • Regular-expression search
  • Fuzzy search
  • Select formulas
  • Select constants
  • Select blanks
  • Select errors
  • Select numbers
  • Select text
  • Select dates
  • Split names
  • Split date and time
  • Unmerge and fill
  • Sort by fill color
  • Sort by font color
  • Generate random data
  • Filter and extract
  • Reshape rows and columns
  • Remove empty rows and columns
  • Save transformation recipe
Combine and reconcileBring tables together without building fragile lookup scaffolding.17
  • Append ranges
  • Deduplicate appended data
  • Exact table join
  • Left join
  • Right join
  • Inner join
  • Full join
  • Multi-key join
  • Fuzzy table join
  • Combine duplicate rows
  • Consolidate ranges
  • Pivot summary
  • Split data into sheets
  • Compare two ranges
  • Identify added rows
  • Identify removed rows
  • Identify changed rows
Workbook and model qualityUnderstand and maintain the workbook behind the result.22
  • Workbook audit
  • Formula error scan
  • Hardcoded-value scan
  • Copied-formula consistency scan
  • Volatile-formula scan
  • Full-column reference scan
  • External-dependency scan
  • Direct precedent trace
  • Direct dependent trace
  • Multi-level dependency explorer
  • Workbook sheet inventory
  • Named-range inventory
  • Sheet activation
  • Sheet visibility controls
  • Sheet tab colors
  • Alphabetical sheet sorting
  • Table styles
  • Model input and output colors
  • Number-format tools
  • Formula diagnostics
  • Excel compatibility scan
  • Formula translation guidance
Formula workbenchInspect formulas and use Sheet Analyst’s owned SA_ function namespace.15
  • Formula pretty-printing
  • Formula reference list
  • Jump to referenced cell
  • Apply edited formula
  • Save formula snippet
  • SA_TEXTBEFORE
  • SA_TEXTAFTER
  • SA_TEXTBETWEEN
  • SA_TEXTSPLIT
  • SA_TAKE
  • SA_DROP
  • SA_EXPAND
  • SA_TRIMRANGE
  • SA_SORTBY
  • SA_PERCENTOF

The catalog describes the current v3.3.0 feature set. Some workflows combine several related actions in one guided screen.

01

Select

Choose the cells you want to analyze or transform.

02

Configure

Pick a focused workflow and review the safe defaults.

03

Review

Write results to a new sheet or a location you choose.

Public beta

Your review makes the toolkit better.

Tell us which workflow saved time, what felt unclear, or what you need next. Please use sanitized examples only.

Leave feedback