Python for Excel templates

Examples and feature-rich Toolboxes for analytical and operational work in Excel with Python.

Choose between focused Examples and deeper Toolboxes. Examples solve a specific analytical or operational job; Toolboxes are broader, feature-rich workbenches designed to support multiple methods, diagnostics, and related workflows.

Examples

Focused workbooks for a specific analytical or operational job. Use them to learn a technique quickly or start from a practical workflow.

Browse Examples

Toolboxes

Feature-rich analytical workbenches that cover a broad capability domain through multiple model types, diagnostics, comparisons, and reusable workflows.

Browse Toolboxes

Toolboxes

Toolboxes are substantially deeper than Examples. Each is designed as an analytical workbench with multiple modules, a capability map, richer diagnostics, and room to expand over time.

Curve Fitting Toolbox

Fit parametric, nonlinear, and polynomial curves to spreadsheet observations, evaluate goodness-of-fit statistics, compute parameter confidence intervals, and generate dense…

Econometrics Toolbox

Fit Box-Jenkins ARIMA and SARIMAX models, estimate Vector Autoregressions, test for unit roots and cointegration, evaluate residual diagnostics, and generate multi-step…

Financial and Risk Management Toolbox

Construct efficient portfolios, calculate historical and parametric Value-at-Risk and Expected Shortfall, attribute portfolio risk, and evaluate tradeoffs directly in Excel.

Optimization Toolbox

Build, solve, compare, and diagnose linear, mixed-integer, quadratic, nonlinear, least-squares, equation, multiobjective, and bounded global optimization models directly…

Statistics and Machine Learning Toolbox

Train, evaluate, and diagnose classification, regression, clustering, and dimension reduction models directly on spreadsheet data tables.

Text Analytics Toolbox

Extract n-grams, calculate TF-IDF features, perform lexicon-based sentiment analysis with negation handling, discover latent topics with LDA, and compute cosine similarity…

Examples

Examples remain the fastest way to explore a focused business or analytical workflow. Use the catalog search field to narrow the collection by workflow, method, or business problem; category labels remain visible on the individual cards without occupying a separate page rail.

Bank Reconciliation Exception Review

Match bank transactions to general-ledger activity in Excel with deterministic exact/tolerance rules, confidence thresholds, and a reviewable exception queue.

Cash Flow Forecast & Liquidity Outlook

Forecast weekly cash receipts, payments, and liquidity in Excel with trend models, scenario assumptions, uncertainty bands, and threshold diagnostics.

Clean Data

Standardize messy customer or transaction exports with automated whitespace, casing, date, number, and mapping rules in Excel.

Custom Functions

Write custom business logic in Python and call it directly from worksheet cells with BF.FUNCTION formulas.

Customer Details

Click a customer in your Excel table and see their orders, invoices, tickets and revenue in one place.

Demand & Inventory Planner

Optimize case-pack replenishment orders in Excel with safety stock, demand forecasts, and a shared purchasing budget using SciPy MILP.

Demand Forecast & Backtest Explorer

Compare portable demand-forecast baselines in Excel with full-horizon rolling-origin backtests, empirical forecast-error bands, model selection, and worksheet-controlled…

Forecast Accuracy & Bias Monitor

Monitor forecast-vintage accuracy in Excel with horizon-aligned WAPE, signed bias, MASE, heatmaps, and worst-series exception review.

Fuzzy Match

Match messy customer or vendor records against a master reference list with text similarity scoring, review bands, and threshold controls in Excel.

Intermittent Demand Forecast for Spare Parts

Forecast sparse spare-parts demand in Excel with Croston-style methods, event-aware backtests, empirical lead-time safety stock, and planner model overrides.

Monte Carlo Profit Risk Simulator

Simulate uncertain sales and cost drivers in Excel with reproducible NumPy Monte Carlo trials, profit percentiles, downside probability, and sensitivity ranking.

Nonlinear Curve Fitting

Fit enzyme-kinetics data in Excel with SciPy, compare nonlinear models, inspect covariance and residual diagnostics, and predict new responses.

Predator-Prey Population Dynamics

Simulate Lotka-Volterra predator-prey population cycles in Excel with SciPy solve_ivp, visualize phase space portraits, and publish live metrics.

Product Details

Click a product to see its stock, demand, open purchase orders and a suggested reorder quantity in Python for Excel.

Regression

Identify store sales drivers and quantify unit effects with multiple linear regression in Python for Excel.

Revenue Operations Command Center

Turn an Excel sales pipeline into a sophisticated marimo command center with sidebar filters, tabbed analysis, scenario controls, deal inspection, and published workbook…

SIR Epidemic Model

Simulate Susceptible-Infectious-Recovered (SIR) epidemic dynamics in Excel with SciPy solve_ivp, calculate R0 and herd immunity, and visualize trajectories.

Sales Scenario Analysis

Compare baseline and discounted revenue in Excel with pandas using worksheet inputs with a Python for Excel notebook.

Three-Way Match

Check vendor invoices against purchase orders and goods receipts in Excel, route only the exceptions to a review queue, and record Approve, Reject, or Hold decisions in the…

Workforce Volume Forecast

Forecast daily operational workload in Excel with weekday seasonality, trend, and worksheet-controlled staffing productivity, shrinkage, and service assumptions.