Spreadsheet calculators and planning tools
Free calculators and planning helpers for founders and finance teams who live in Google Sheets and Excel. When you need full statements, jump to our templates.
Explore spreadsheet templates for full workbooks, or open the Lexicon for clear definitions of the terms behind the math.
Built for real spreadsheet work
Search or filter to match the job in front of you—percentages and growth, descriptive stats, loan schedules, time and hours, retirement checks, currency reference rates, and more. Most tools include copy-ready Google Sheets and Excel snippets; finance results are illustrations, not advice.
- PlanningLiveOvertime calculatorStraight hourly rate, weekly hours cap (often 40), total hours worked, and overtime multiplier—regular pay, OT pay, and gross total; Sheets/Excel patterns; not payroll software.Open tool
- PlanningLivePay stub calculatorGross pay for one period, deduction rows you label (pre-tax, tax, post-tax), optional illustrative 7.65% FICA on gross, net pay reconciliation. SUM patterns for Sheets/Excel—not payroll software or tax tables.Open tool
- PlanningLiveHourly to salary calculatorHourly pay or annual salary anchor with hours per week and weeks per year—gross annual, monthly, weekly, and five-day daily illustration; Sheets/Excel formulas; not payroll or tax software.Open tool
- StatisticsLiveStandard deviation calculatorMean, variance, and standard deviation from pasted numbers—sample (n−1) or population (n); optional steps; STDEV.S / STDEV.P for Sheets and Excel.Open tool
- StatisticsLiveVariance calculatorVariance first from pasted numbers—sample (n−1) or population (n); SD, mean, sum, and sum of squared deviations; optional steps; VAR.S / VAR.P for Sheets and Excel.Open tool
- StatisticsLiveZ-score calculatorRaw score, mean, and SD → z plus standard-normal tail probabilities; STANDARDIZE / NORM.S.DIST patterns for Sheets and Excel—not growth-chart z-scores.Open tool
- StatisticsLiveNormal distribution calculatorN(μ, σ²) left/right/between probabilities and inverse left-tail p → x; NORM.DIST / NORM.INV patterns for Sheets and Excel—educational, not normality-test software.Open tool
- StatisticsLiveInverse normal distribution calculatorLeft-tail p, μ, and σ → cutoff x and z for N(μ,σ²); NORM.INV / NORM.S.INV for Google Sheets and Excel—InvNorm-style homework helper, not a full probability suite.Open tool
- StatisticsLiveBinomial distribution calculatorBinomial(n, p): exactly P(X=k), at most, at least, and inclusive between; mean, variance, SD; BINOM.DIST / BINOM.DIST.RANGE patterns for Sheets and Excel—not inverse binomial or Poisson.Open tool
- StatisticsLiveCohen's kappa calculatorSquare confusion matrix (2–6 categories) for two raters: unweighted Cohen's κ with
p_oandp_e, plusSUM/SUMPRODUCTpatterns—not weighted κ, Fleiss κ, or standard errors and confidence intervals.Open tool - StatisticsLiveChi-square p-value calculatorPearson chi-square test statistic and whole-number degrees of freedom: right-tail p and CDF;
CHISQ.DIST/CHISQ.DIST.RTfor Sheets and Excel—enter the statistic and df, not a full contingency table from raw counts.Open tool - StatisticsLivet-test calculatorSummary stats (n, mean, sample SD) → t, df, and two-sided p-value for one-sample, paired, or two-sample (pooled or Welch); T.TEST / T.DIST patterns for Sheets and Excel—not clinical software.Open tool
- StatisticsLiveLinear regression calculator (least squares, line of best fit)Paired x and y → least squares line of best fit (OLS ŷ = b₀ + b₁x), slope, intercept, Pearson r, and R²; optional ŷ; LINEST / SLOPE / INTERCEPT / RSQ / FORECAST.LINEAR for Sheets and Excel—not multiple regression.Open tool
- StatisticsLiveConfidence interval calculatorTwo-sided mean intervals (z with known σ, t with unknown σ or pasted raw data), Wald proportion, margin of error and standard error; CONFIDENCE.NORM / CONFIDENCE.T patterns for Sheets and Excel—not survey software.Open tool
- StatisticsLiveSample size calculatorMinimum completes n for one proportion under a simple random sample: confidence level, margin of error, planning p, optional finite N—or read margin from completed n. NORM.S.INV patterns for Sheets and Excel—ballpark planning, not full survey methodology.Open tool
- StatisticsLiveMargin of error calculator±% half-width for one survey proportion from n, p, confidence, optional finite N (Wald + FPC)—not pricing margin. NORM.S.INV patterns for Sheets and Excel; pair with the sample size tool to plan n.Open tool
- StatisticsLiveMean median mode range calculatorMean, median, mode(s), range, count, sum, min, and max from a pasted list; optional sorted view; AVERAGE, MEDIAN, MODE for Sheets and Excel.Open tool
- StatisticsLiveQuartile calculatorQ1, Q2, Q3, and IQR from a pasted list; min, max, and range; inclusive spreadsheet-style percentiles—QUARTILE.INC / PERCENTILE.INC patterns for Sheets and Excel.Open tool
- StatisticsLiveSignificant figures calculatorCount, round, or two-operand + − × ÷ with standard decimal and sig-fig rules; E-notation; round half up; spreadsheet heuristics—not a metrology or GUM engine.Open tool
- Spreadsheet mathLiveLeast to greatest calculatorPaste decimals and negatives; sort smallest to largest or largest to smallest with stable ties; SORT patterns for Google Sheets and Excel.Open tool