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.

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.

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.

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.

PDF Drawing Diff — CAD Drawing Revision Comparison

Compare two CAD-exported PDF drawing pages from their vector geometry and text, align export drift, and produce deterministic grouped change records in Excel.

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.

Sales Scenario Analysis

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

Workforce Volume Forecast

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