201 free Excel templates
Every one has working formulas, realistic sample data and a Start here sheet that explains the method — not just which cells to fill in. Open any page below to see a real slice of the sheet before you decide.
Free account · 3 templates free and yours forever · unlimited on Pro
Finance 29
12-Month Cash Flow Forecast TemplateProject inflows and outflows month by month with best/base/worst scenarios and a running balance.3 sheets · 74 formulas · 14 KB
3-Statement Financial Model TemplateA lightweight linked P&L, balance sheet and cash flow for quick scenario work.5 sheets · 337 formulas · 18 KB
Accounts Receivable Aging TemplateBucket unpaid invoices by age (30/60/90+) and flag overdue accounts to chase.4 sheets · 140 formulas · 18 KB
Annual Budget Builder TemplateTwelve-month budget from department inputs, with four phasing shapes.4 sheets · 202 formulas · 16 KB
Balance Sheet Template with RatiosTwo-period balance sheet with subtotals, a must-be-zero check, movements and a ratios sheet with RAG bands.3 sheets · 124 formulas · 16 KB
Break-Even Analysis TemplateFind the units and revenue where you cover costs, with a contribution-margin breakdown.3 sheets · 117 formulas · 13 KB
Budget vs Actual TemplateVariance by line with the favourable/adverse rule applied and material gaps flagged.5 sheets · 398 formulas · 21 KB
Business Expense Tracker TemplateLog spend, auto-categorise it, and see totals by category and month.4 sheets · 367 formulas · 19 KB
Cash Flow Statement Template (Indirect Method)Indirect-method cash flow built from a P&L and two balance sheets, reconciling closing cash with a check cell and free cash flow.3 sheets · 86 formulas · 15 KB
DCF Valuation Model with WACC & SensitivityFive-year unlevered free cash flow DCF with a CAPM-built WACC, Gordon and exit-multiple terminal values and a WACC x growth grid.4 sheets · 165 formulas · 16 KB
Discount & Margin Calculator TemplateWhat a discount costs in margin, and the volume needed to stand still.3 sheets · 65 formulas · 11 KB
Financial Ratio Analysis TemplateThree years of P&L and balance sheet turned into 24 liquidity, profitability, leverage, efficiency and DuPont ratios against benchmarks.3 sheets · 173 formulas · 17 KB
Fixed Asset & Depreciation TemplateStraight-line and reducing-balance side by side, with net book value.4 sheets · 76 formulas · 14 KB
Fixed Asset Register & Depreciation ScheduleAsset register with straight-line or reducing-balance depreciation to an as-at date, NBV, disposals and a by-class summary.3 sheets · 248 formulas · 18 KB
Holt-Winters Forecasting TemplateTriple exponential smoothing with trend and seasonality, plus 95% confidence bands.3 sheets · 231 formulas · 15 KB
Invoice Template & Payment LogPrintable invoice fed by a Settings sheet, plus a log that works out status, days overdue and what each client owes.4 sheets · 207 formulas · 18 KB
Invoice Tracker TemplateInvoices from raised to paid, with each customer's real days-to-pay.4 sheets · 180 formulas · 16 KB
Loan & Amortisation Schedule TemplateEvery payment split into interest and principal, with overpayment modelling.3 sheets · 608 formulas · 18 KB
Monte Carlo Simulation TemplateGive each assumption a worst/likely/best range and see P10–P90 outcomes across thousands of trials.5 sheets · 5,025 formulas · 52 KB
NPV & IRR Appraisal TemplateNPV, IRR, payback and a rate sensitivity table — with Excel's year-zero trap shown.3 sheets · 45 formulas · 12 KB
Payroll Cost Model TemplateTurns salaries into the fully-loaded cost that actually leaves the bank.5 sheets · 144 formulas · 17 KB
Product Pricing Calculator (Cost-Plus & Target Margin)Per-product cost build-up with waste, labour and overhead, priced by markup and by target margin, with VAT and a volume sheet.4 sheets · 190 formulas · 20 KB
Profit & Loss TemplateA month-by-month income statement with gross, operating and net margin on every line.4 sheets · 319 formulas · 19 KB
Quote & Estimate Builder TemplatePriced quote with VAT and contingency, showing job margin before you send.2 sheets · 30 formulas · 11 KB
SaaS P&L Statement TemplateSaaS P&L with gross margin, Rule of 40 and the magic number.3 sheets · 70 formulas · 13 KB
Sales Commission Calculator TemplateTiered commission on every deal without nested IF formulas.5 sheets · 141 formulas · 15 KB
Startup Costs & Funding Requirement CalculatorOne-off and monthly startup costs turned into a funding requirement with contingency, sources vs uses and a 12-month cash curve.4 sheets · 226 formulas · 20 KB
Startup Runway and Burn Rate TemplateTrack monthly burn and cash balance to see exactly how many months of runway remain.4 sheets · 83 formulas · 15 KB
Unit Economics (CAC, LTV, Payback) TemplateCAC, LTV and payback — with LTV on gross profit, not revenue.4 sheets · 46 formulas · 12 KB
Data 14
Anomaly Detection TemplateFlags values sitting outside the normal range using IQR and standard-deviation rules.3 sheets · 157 formulas · 14 KB
Correlation Matrix TemplateSee which columns move together in a colour-coded matrix.3 sheets · 29 formulas · 13 KB
Data Cleaning Checklist TemplateEleven checks over a column, including the non-breaking space TRIM cannot remove.4 sheets · 116 formulas · 12 KB
Descriptive Statistics TemplateSixteen summary statistics and a histogram, with mean-vs-median guidance.4 sheets · 48 formulas · 15 KB
Heat Map TemplateA colour-scaled grid for spotting concentration in any two-dimensional table.5 sheets · 46 formulas · 17 KB
Linear Regression TemplateFit a line to two columns and read the slope, intercept and R².3 sheets · 189 formulas · 14 KB
Pareto (80/20) Analysis TemplateRanks categories and overlays the cumulative percentage to find the vital few.3 sheets · 80 formulas · 13 KB
Pivot Table Starter TemplatePivot-ready data plus the same summary built with SUMIFS, so you can check the pivot.3 sheets · 20 formulas · 18 KB
Remove Duplicates and Clean Data TemplateStrip duplicates, fix casing and trim whitespace in one pass.3 sheets · 45 formulas · 11 KB
Running Total TemplateAdd a cumulative column with an optional reset per group.2 sheets · 151 formulas · 13 KB
Scenario Planner TemplateBest, base and worst run together, with the lowest cash point in each.5 sheets · 170 formulas · 17 KB
Sensitivity Analysis TemplateFlex one or two inputs and watch the output move in a data table.6 sheets · 92 formulas · 16 KB
Two-Way Lookup (INDEX/MATCH) TemplateFinds the value where a row and a column meet — the lookup VLOOKUP cannot do.3 sheets · 5 formulas · 11 KB
VLOOKUP to XLOOKUP TemplateThe same five lookups written both ways, so you can see exactly what XLOOKUP fixes.3 sheets · 26 formulas · 11 KB
Sales 14
A/B Test Significance Templatez-test p-value plus the sample size to fix before you start.4 sheets · 26 formulas · 12 KB
CRM Contact Tracker & Follow-Up LogContact and deal list with overdue follow-up flags, stage-weighted pipeline value and conversion between stages.5 sheets · 235 formulas · 21 KB
Campaign Tracking Template with UTMRoll up clicks, spend and conversions by campaign and channel.4 sheets · 163 formulas · 16 KB
Cohort Retention TemplateA retention triangle by joining month, with a conditional-format heatmap.6 sheets · 3,422 formulas · 49 KB
Content Calendar TemplatePlan posts by date, channel and status in one editable grid.4 sheets · 78 formulas · 14 KB
Customer Churn Analysis TemplateChurn rate by month and segment, with the revenue attached to each churned account.4 sheets · 227 formulas · 18 KB
Funnel Chart TemplateStep-by-step drop-off from first touch to purchase, with conversion at every stage.3 sheets · 31 formulas · 13 KB
Lead Scoring TemplateScore inbound leads on fit and intent so sales works the best ones first.5 sheets · 62 formulas · 15 KB
MRR Movements Bridge TemplateNew, expansion, contraction, churn and reactivation as a bridge.4 sheets · 87 formulas · 15 KB
Marketing Budget TemplatePlan vs spend by channel with pacing and remaining budget.5 sheets · 59 formulas · 17 KB
Merge Two Spreadsheets TemplateJoins two lists on a shared key and counts the rows that did not match.5 sheets · 78 formulas · 15 KB
RFM Segmentation TemplateScores every customer on recency, frequency and monetary value into named segments.6 sheets · 1,128 formulas · 41 KB
Sales Forecast TemplateWeighted pipeline, run-rate and committed forecasts side by side.4 sheets · 15 formulas · 14 KB
Sales Pipeline TemplateWeight deals by stage to a forecast and see where the quarter lands.5 sheets · 116 formulas · 17 KB
Projects 19
Attendance & Absence TemplateDaily attendance codes with holiday totals and the Bradford Factor.4 sheets · 53 formulas · 14 KB
Capacity Planning TemplateHours available against hours demanded, flagging who is over-committed.5 sheets · 45 formulas · 17 KB
Gantt Chart TemplateTurn a task list with start, due and %-complete into a live timeline that colours by schedule health.3 sheets · 128 formulas · 14 KB
Inventory Management TemplateReorder points, safety stock and ABC classification from a stock-and-sales file.3 sheets · 66 formulas · 14 KB
Meeting Actions & Decisions TemplateActions and decisions logged separately, with overdue by owner.5 sheets · 45 formulas · 16 KB
OKR Tracker TemplateObjectives and key results with progress bars that roll up to a score.4 sheets · 42 formulas · 14 KB
Product Launch Checklist TemplateEvery pre-launch task with owner, due date and done state in one view.4 sheets · 89 formulas · 15 KB
Product Roadmap TemplatePlot initiatives across quarters with owners and status in one shareable timeline.4 sheets · 45 formulas · 14 KB
Project Budget Tracker with Forecast at CompletionWBS budget with an actuals and commitments log, forecast at completion, % spent vs % complete and overrun flags by line and phase.5 sheets · 446 formulas · 24 KB
Project Tracker TemplateTasks with owner, status and percent complete, rolled up to project health.5 sheets · 214 formulas · 20 KB
Purchase Order Tracker TemplatePOs from raised to invoiced, with committed spend and a three-way match.4 sheets · 128 formulas · 15 KB
RAID Log (Risks, Assumptions, Issues & Dependencies)One RAID log with type-specific rules, counts by type and status, a ranked top five open risks and a 5x5 heat map.4 sheets · 265 formulas · 23 KB
Risk Register TemplateLog risks with likelihood, impact and a RAG status, sorted by exposure.4 sheets · 53 formulas · 14 KB
Shift Rota Template with Cover & CostWeekly rota grid using shift codes that resolve to hours and premiums, with hours vs contracted, daily cost and cover shortfalls.5 sheets · 296 formulas · 21 KB
Sprint Burndown Chart & Velocity TrackerTen-day burndown with ideal, actual and scope-adjusted lines and a projected finish, plus six-sprint velocity and backlog forecast.4 sheets · 129 formulas · 19 KB
Staff Leave Tracker & Holiday PlannerEntitlements, a requests log with working days via NETWORKDAYS, balances by person and a monthly days-off heat grid.6 sheets · 396 formulas · 24 KB
Supplier Scorecard TemplateWeighted scoring on price, quality, delivery and responsiveness.4 sheets · 22 formulas · 13 KB
Timesheet & Utilisation TemplateBillable utilisation and effective hourly rate by person and client.5 sheets · 135 formulas · 20 KB
Weekly Timesheet & Overtime CalculatorWeekly in/out/break times per employee with daily and weekly overtime, pay at base and 1.5x rates, and a payroll summary.4 sheets · 260 formulas · 19 KB
Reporting 9
Board Report TemplateThe charts and tables a board expects, ready to drop into slides.4 sheets · 45 formulas · 16 KB
Client Report TemplateThe monthly agency report — results against target, hours against retainer.2 sheets · 13 formulas · 10 KB
Goal Tracker TemplateTrack progress to a target with pace and projected finish.2 sheets · 30 formulas · 10 KB
KPI Dashboard TemplateA one-page board of headline metrics with sparklines and period-on-period deltas.5 sheets · 181 formulas · 19 KB
Month-Over-Month Growth TemplateMonth-over-month and year-over-year growth with a clean trend line.4 sheets · 115 formulas · 14 KB
Sales Dashboard TemplateRevenue, pipeline and rep performance on a single sheet.5 sheets · 285 formulas · 24 KB
Variance Analysis TemplateVariance by line with written commentary explaining why each moved.2 sheets · 43 formulas · 12 KB
Waterfall Chart TemplateShow how you get from last period to this one, step by step.3 sheets · 62 formulas · 14 KB
Weekly Business Report TemplateA one-page summary of the week’s numbers, written from your data.4 sheets · 42 formulas · 14 KB
Advanced techniques 29
ABC / XYZ Inventory ClassificationValue concentration crossed with demand predictability into a nine-box, each cell with its own stocking policy.6 sheets · 593 formulas · 25 KB
Bank Reconciliation with Auto-MatchTwo matching passes — exact key, then amount within a date window — with the reconciliation identity proved to the penny.6 sheets · 466 formulas · 24 KB
Cap Table & Exit WaterfallA liquidation preference stack resolved across ten exit values, including where each preferred class converts to ordinary.3 sheets · 125 formulas · 13 KB
Capital Appraisal: NPV, IRR, MIRR, PaybackAll six appraisal measures from dated cash flows, including MIRR and discounted payback, with a warning when IRR has multiple answers.4 sheets · 52 formulas · 14 KB
Contribution Margin & Operating LeverageContribution by line, fixed cost kept as a period cost, and the degree of operating leverage that turns a 10% revenue miss into a 40% profit miss.4 sheets · 77 formulas · 16 KB
Critical Path Method (CPM)Forward and backward pass, total and free float, the critical path listed, and which task is actually worth crashing.5 sheets · 364 formulas · 21 KB
Customer LTV from a Retention CurveLTV built from a fitted survival curve and discounted, and how far the ARPU-over-churn shortcut is out.4 sheets · 221 formulas · 17 KB
Data Validation Rulebook & Quality ScoreTwelve explicit rules, severity-weighted, scored per row and per field, with a fix-first ranking by damage rather than by count.6 sheets · 984 formulas · 31 KB
Driver Tree Rolling ForecastRevenue decomposed into traffic, conversion, order value and repeat rate, each forecast separately — plus what compounding optimism does to the total.6 sheets · 129 formulas · 20 KB
Dynamic Array Reporting (no pivot table)A whole pivot rebuilt with FILTER, UNIQUE, SORT, LET and BYROW, so it can never be stale — plus a cookbook of the ten patterns.4 sheets · 248 formulas · 21 KB
EOQ, Safety Stock & Reorder PointOrder quantity, buffer and reorder point including lead-time variability — the term almost every spreadsheet leaves out.6 sheets · 329 formulas · 22 KB
Earned Value ManagementPV, EV, AC, CPI, SPI, three estimates at completion, and the TCPI that says whether the recovery plan is arithmetically possible.5 sheets · 249 formulas · 20 KB
Erlang C Contact-Centre StaffingThe Erlang B recursion in a column, so a real staffing model runs in plain Excel — service level, ASA, occupancy and shrinkage.6 sheets · 690 formulas · 26 KB
Fuzzy Name Matching Between Two ListsMatches misspelt company names with a letter-frequency cosine computed in formulas, and a runner-up gap that says when not to trust it.5 sheets · 4,165 formulas · 44 KB
Lease vs BuyAfter-tax present-value comparison including capital allowances and residual value, with a sensitivity on the residual that usually decides it.6 sheets · 112 formulas · 16 KB
Loan Overpayment & Offset ComparisonTwo amortisation schedules side by side. Interest saved, months removed from the term, and why an offset beats an overpayment.5 sheets · 2,719 formulas · 39 KB
Monte Carlo Cash Runway500 simulated cash paths over 18 months. Runway as a P5/P50/P95 distribution, and the probability of running out inside 12 months.5 sheets · 10,550 formulas · 106 KB
Pocket Price Waterfall — Discount LeakageEvery deduction between list price and the money that reaches the bank, including the off-invoice leaks nobody manages.5 sheets · 257 formulas · 21 KB
Portfolio Efficient FrontierTwo-asset mean-variance with the correlation term, 21 portfolios, and the minimum-variance and maximum-Sharpe points marked.4 sheets · 116 formulas · 15 KB
Price Elasticity & Profit-Optimal PriceElasticity estimated by log-log regression from your own price history, then the price that maximises profit rather than revenue.4 sheets · 174 formulas · 18 KB
Resource Levelling & Over-AllocationEvery assignment against real capacity week by week, so over-allocation is visible before the plan is committed rather than after it fails.6 sheets · 820 formulas · 27 KB
Rolling 13-Week Cash FlowThe treasury standard. Receipts and payments by week, the low point, facility and covenant headroom, and a forecast-accuracy score.4 sheets · 168 formulas · 17 KB
Rolling Z-Score & MAD Outlier DetectionA robust MAD score that finds the outliers an ordinary z-score hides inside its own standard deviation, and separates level shifts from errors.6 sheets · 1,428 formulas · 31 KB
SPC Control Chart (X-bar & R)Real statistical process control: subgroup means and ranges, the standard constants, Cp/Cpk, and all four Western Electric run rules.5 sheets · 412 formulas · 22 KB
Shift Rota Coverage & FairnessDemand hour by hour against who is rostered, plus the distribution of unsociable hours that predicts who resigns.6 sheets · 358 formulas · 23 KB
Tornado Sensitivity AnalysisSeven drivers flexed one at a time by their own plausible range, ranked by swing. The widest bar is the assumption worth arguing about.3 sheets · 92 formulas · 14 KB
Variance Bridge: Price, Volume, MixBudget to actual decomposed three ways per product, reconciling to the penny. Mix is the effect everyone omits and the one that explains margin.4 sheets · 111 formulas · 16 KB
Weighted Decision Matrix (AHP)Criteria weights derived from pairwise comparisons, with the consistency ratio that tells you when your judgements contradict each other.4 sheets · 99 formulas · 15 KB
Win-Rate AttributionA change in win rate decomposed into the stage conversions that caused it, multiplicatively, reconciling exactly to the total.4 sheets · 57 formulas · 16 KB
Agency 3
Retainer ProfitabilityWhat each retainer earns once hours are costed, ranked by effective hourly rate rather than by fee — which reverses the list.4 sheets · 137 formulas · 16 KB
Scope Creep & Change ControlEvery change request priced whether or not it was charged, and the absorbed total that turns a 45% project into a 12% one.4 sheets · 83 formulas · 16 KB
Utilisation & Rate CardDerives a defensible day rate from salary, utilisation and target margin, then prices every point of the utilisation gap.4 sheets · 85 formulas · 15 KB
Construction 5
Construction Project Cost TrackerBudget, committed, actual, forecast to complete and EAC per cost code from PO and invoice logs, % spent against % complete flags and retention held.4 sheets · 476 formulas · 24 KB
Cost Value Reconciliation (CVR) TemplateEarned value against cost to complete, with retention shown separately.4 sheets · 63 formulas · 15 KB
Plant & Equipment Utilisation TemplateUtilisation per machine and the break-even days that decide own or hire.4 sheets · 72 formulas · 14 KB
Subcontractor Payment & Retention TemplateApplied vs certified per trade, with retention release dates.4 sheets · 115 formulas · 15 KB
Tender & Bid Tracker TemplateWin rate, cost per win, and the gap to the winning price.4 sheets · 73 formulas · 15 KB
Customer support 4
CSAT & NPS Analysis TemplateClassifies survey responses into promoters, passives and detractors and reports NPS and CSAT overall, by segment, channel and month.5 sheets · 249 formulas · 21 KB
Support Agent Productivity TemplateTracks tickets per hour, reopen rate and a quality-adjusted throughput per agent per week, with rankings and team averages.5 sheets · 299 formulas · 22 KB
Support Backlog Ageing Report TemplateAges open tickets into buckets by priority, flags stale and over-target tickets, and lists the ten oldest with an owner breakdown.5 sheets · 409 formulas · 22 KB
Support Ticket SLA Tracker TemplateMeasures first-response and resolution hours against per-priority SLA targets, flags breaches including open tickets, and reports attainment.5 sheets · 436 formulas · 24 KB
E-commerce 6
Ad ROAS & ACoS by SKU TrackerROAS, ACoS and CPA per campaign against each SKU's own break-even ROAS from its margin, with Scale/Hold/Cut flags and a budget reallocation view by SKU.5 sheets · 499 formulas · 24 KB
Amazon FBA Fee & Profit CalculatorFinds the FBA size tier from weight and dimensions, builds the fee stack with VAT removed, and shows net profit, margin, ROI, break-even and five price points.5 sheets · 100 formulas · 18 KB
Marketplace Fee ReconciliationRebuilds what the marketplace should have paid you, line by line, and flags every settlement line that does not match.5 sheets · 464 formulas · 20 KB
Returns & Refund AnalysisCosts returns properly by SKU, reason and channel — postage both ways, handling, and the units that come back unsellable.5 sheets · 428 formulas · 23 KB
SKU Profitability & Contribution Margin AnalysisContribution per unit and per SKU after shipping, marketplace fees, ad spend and returns, with loss-maker flags and a Pareto ranking of profit.3 sheets · 546 formulas · 21 KB
Stock Cover & Sell-ThroughWeeks of cover on recent rate of sale crossed with sell-through, so the buy list separates a stockout from dead money.5 sheets · 386 formulas · 21 KB
Education 4
Attainment & Progress Gap TemplateProgress against baseline by group, with small cohorts flagged.4 sheets · 201 formulas · 20 KB
Attendance & Persistent Absence TemplatePersistent and severe absence, and the authorised/unauthorised split.4 sheets · 388 formulas · 19 KB
Budget per Pupil TemplateCost per pupil by category, with staffing % and a falling-roll model.3 sheets · 58 formulas · 14 KB
Gradebook & Weighted Grade CalculatorRaw marks across six weighted assessments turned into a final percentage and grade, with class statistics, at-risk flags, rank, z-score outliers and groups.5 sheets · 589 formulas · 27 KB
Fitness 2
Class Schedule & Utilisation TemplateAttendance against capacity and contribution per class, not just how full it looks.4 sheets · 249 formulas · 18 KB
Membership Churn & Retention TemplateChurn, average member life, and what one point of churn is worth.4 sheets · 160 formulas · 16 KB
HR & People 11
9-Box Talent Grid & Succession PlannerPlaces employees on the performance x potential grid from two scores, counts each box, compares departments and lists the succession slate.5 sheets · 380 formulas · 24 KB
Absence & Bradford FactorAbsence rate for reporting and the Bradford factor for managing, with trigger points that fire automatically.5 sheets · 192 formulas · 20 KB
Employee Engagement Survey & eNPS AnalysisAverage and favourable percentage per survey question, a department heat grid, strongest and weakest questions and the employee net promoter score.5 sheets · 229 formulas · 22 KB
Employee Turnover & Attrition Rate TrackerMonthly and rolling 12-month turnover from a leavers log and headcount, split by department, regretted share, tenure of leavers and attrition cost.5 sheets · 334 formulas · 24 KB
Headcount Plan & Attrition ForecastTwelve months of headcount from today's team, expected leavers and planned hires — including the replacement hiring nobody budgets.4 sheets · 108 formulas · 16 KB
Onboarding & Time to ProductivityTracks new starters to productive, not just to onboarded, and prices the ramp — which usually exceeds the agency fee.5 sheets · 94 formulas · 19 KB
Overtime Tracker & Cost vs Extra Hire CalculatorWeekly hours against contracted hours per person, overtime priced at each premium rate, department totals and a comparison with hiring an extra person.6 sheets · 486 formulas · 26 KB
Recruitment Funnel & Cost per Hire TrackerStage-reached funnel and conversion rates from a candidate log, time to offer and start, and applicants, hires and cost per hire by source.4 sheets · 283 formulas · 21 KB
Salary Benchmarking & Pay Gap AnalysisCompa-ratios against grade benchmarks, mean and median gaps, and the split between a pay gap and a structure gap.5 sheets · 239 formulas · 19 KB
Skills Matrix & Training GapScores the team against the skills the work needs and names every capability with a bus factor of one.6 sheets · 106 formulas · 20 KB
Training Compliance & Certification Expiry TrackerExpiry dates and Current/Expiring/Expired/Missing status per course record, a compliance matrix of people against mandatory courses and a 60-day expiry list.5 sheets · 380 formulas · 22 KB
Healthcare 3
Appointment No-Show (DNA) Rate & Overbooking CalculatorDNA rate by clinic, weekday, booking lead time, age band and reminder from an appointment list, the cost of wasted slots and an overbooking factor per clinic.4 sheets · 579 formulas · 26 KB
Clinic Utilisation & DNA TemplateAttended against offered, DNA rate, and the value of empty chairs.4 sheets · 133 formulas · 16 KB
Payer Mix & Treatment Profitability TemplateContribution per clinical hour by treatment and payer.4 sheets · 143 formulas · 17 KB
Hospitality 4
Food & Beverage Cost Control TemplateTheoretical against actual food cost, and the gap wastage cannot explain.5 sheets · 153 formulas · 19 KB
Hotel Occupancy, ADR & RevPAR CalculatorDaily occupancy, ADR, RevPAR and TRevPAR for a month, weekday averages, month KPIs and a same-month-last-year comparison with an occupancy/rate bridge.5 sheets · 338 formulas · 23 KB
Labour Scheduling vs Covers TemplateCovers per labour hour and labour % by shift, not by week.4 sheets · 208 formulas · 18 KB
Menu Engineering TemplateStars, plough-horses, puzzles and dogs — ranked on cash, not GP%.4 sheets · 150 formulas · 17 KB
Legal 4
Billing & Collection Realisation TemplateStandard value from hours and rate per fee earner per month, billing and collection realisation, effective rate, write-offs and a ranking.5 sheets · 638 formulas · 26 KB
Contract Expiry & Renewal Register TemplateDays to expiry and to the notice deadline for every contract from an As-at date, RAG status, auto-renew actions and renewals due in 90 days by type and owner.3 sheets · 319 formulas · 20 KB
Legal Matter Budget & WIP Tracker TemplatePhase budgets per matter against time recorded at a rates lookup, with % of budget consumed, 80%/100% overrun alerts and unbilled WIP ageing.6 sheets · 401 formulas · 24 KB
Legal Time Recording & Utilisation TemplateSix-minute unit entries per fee earner rolled to billable and non-billable hours by week, utilisation against target, chargeable % and missing-time flags.6 sheets · 602 formulas · 27 KB
Logistics 4
Fleet Cost per Mile TemplateStanding and running costs split — why an idle vehicle costs so much per mile.4 sheets · 88 formulas · 16 KB
Fleet Maintenance & MOT Tracker TemplateMiles to next service, days to MOT and insurance and overdue flags per vehicle from an As-at date, plus a costs log rolled to cost per vehicle and per mile.3 sheets · 274 formulas · 21 KB
Route & Job Profitability TemplateProfit per hour and per mile, with the return leg counted.4 sheets · 170 formulas · 16 KB
Warehouse Pick Productivity TemplatePicks per hour scored against accuracy, not speed alone.4 sheets · 288 formulas · 19 KB
Manufacturing 6
BOM Cost Roll-Up & Unit Cost TemplateRolls a multi-level bill of materials with scrap into sub-assembly and unit cost, adds labour routing and overhead, and shows margin at list price.6 sheets · 96 formulas · 20 KB
Capacity Utilisation & Bottleneck TemplateDemand hours per work centre from an orders list against available hours and efficiency, with utilisation, overload flags, the bottleneck and overtime needed.3 sheets · 144 formulas · 17 KB
Machine Downtime Log & MTBF/MTTR TemplateLogs downtime events with minutes lost, works out MTBF and MTTR per machine and ranks unplanned minutes by reason on a Pareto sheet.5 sheets · 284 formulas · 23 KB
OEE Calculator & Six Big Losses TemplateAvailability, performance, quality and OEE per shift and machine, with the six big losses split out and an 85% world-class benchmark RAG.5 sheets · 300 formulas · 23 KB
Production Schedule & Machine Loading TemplateSequences orders per machine from run and setup hours, gives each a start and finish day, flags late jobs and shows machine load by week.5 sheets · 1,070 formulas · 27 KB
Scrap & Yield Analysis Template (FPY, RTY)First-pass yield per step, rolled throughput yield across the line, scrap cost at unit cost and a Pareto of scrap by reason with cumulative %.5 sheets · 302 formulas · 24 KB
Marketing 7
CAC by Channel Calculator TemplateCalculates monthly, blended and three-month rolling CAC for five channels, with payback months and LTV:CAC against a gross profit per customer.4 sheets · 263 formulas · 19 KB
Competitor Analysis Matrix TemplateScores six companies on weighted criteria with a rank, a yes/no feature matrix with coverage, and a formula-built list of positioning gaps.5 sheets · 195 formulas · 20 KB
Content Performance Tracker TemplateNormalises sessions and conversions by months live, flags decaying content from 30-day traffic, and summarises by type with a top ten.5 sheets · 375 formulas · 24 KB
Email Campaign Performance TrackerLogs every send and computes delivery, open, CTR, CTOR and unsubscribe rates against benchmarks, with a monthly rollup on summed counts.4 sheets · 378 formulas · 22 KB
Paid Ads ROAS Calculator TemplateComputes CPM, CPC, CTR, CVR, CPA and ROAS per campaign, derives break-even ROAS from gross margin, and suggests spend reallocation by channel.4 sheets · 492 formulas · 21 KB
SEO Keyword Rank Tracker TemplateTracks keyword ranks over eight weeks, converts position to estimated clicks via a CTR curve, and counts top-3/10/20 terms with risers and fallers.4 sheets · 255 formulas · 20 KB
Social Media Analytics Tracker TemplateRecords posts by channel and format, computes engagement rate and CTR, names the best format per channel and plots twelve weeks of trend.5 sheets · 364 formulas · 23 KB
Nonprofit 5
Donor Retention & Lapse TemplateRetention, lapse and donor lifetime value against cost to recruit.4 sheets · 320 formulas · 19 KB
Fund Accounting TemplateRestricted, unrestricted and designated kept apart, with a breach check.4 sheets · 40 formulas · 15 KB
Fundraising Event Budget & Break-Even CalculatorIncome and cost lines budget versus actual for a fundraising event, net proceeds, cost per pound raised, break-even attendance and an attendance-by-price grid.5 sheets · 246 formulas · 24 KB
Grant Tracker & Conditions TemplateGrants from application to final report, with the deadlines that end relationships.4 sheets · 129 formulas · 15 KB
Volunteer Hours Log & Retention TrackerVolunteer hours by programme and month from a session log, their value at an hourly rate, active volunteers in a 90-day window, retention and top contributors.5 sheets · 500 formulas · 25 KB
Professional services 2
Engagement Profitability TemplateEffective rate and grade mix against the fee that was quoted.3 sheets · 134 formulas · 14 KB
WIP & Lock-Up Days TemplateWIP days plus debtor days — the cash a profitable firm cannot spend.4 sheets · 108 formulas · 15 KB
Property 6
Buy-to-Let Rental Yield & Cash Flow CalculatorGross and net yield, monthly cash flow after the mortgage, cash-on-cash return, a rate-rise stress test and a ten-year projection of equity and total return.4 sheets · 202 formulas · 18 KB
Development Appraisal TemplateResidual land value, with the sensitivity grid that is the real appraisal.3 sheets · 45 formulas · 11 KB
Property Maintenance Log & Repair Cost TrackerRepair jobs measured against response targets by urgency, cost per unit per year against rent, category and contractor totals, and open jobs by age.5 sheets · 471 formulas · 26 KB
Rent Roll & Arrears TemplateRent due against collected, arrears aged, and the lease events nobody diarises.5 sheets · 365 formulas · 18 KB
Service Charge Apportionment TemplateCosts apportioned per tenant, with a check that the schedule totals 100%.3 sheets · 63 formulas · 13 KB
Void & Letting Performance TemplateWhat each empty unit costs, split into refurb, marketing and legal days.4 sheets · 117 formulas · 16 KB
Recruitment 2
Placement Margin & Consultant TemplateContract margin after employer on-costs, annualised against permanent fees.4 sheets · 131 formulas · 16 KB
Time to Fill & Candidate Funnel TemplateTime to fill versus time to hire, and which stage is the bottleneck.4 sheets · 114 formulas · 17 KB
Retail 5
Basket & Transaction Analysis TemplateRevenue split into transactions, units per transaction and price.4 sheets · 313 formulas · 18 KB
Footfall & Conversion Rate TrackerDaily conversion, ATV, UPT, sales per labour hour and footfall per staff hour from counter and till data, with weekday averages and best/worst days.4 sheets · 456 formulas · 23 KB
Markdown Planner TemplateWhat each markdown step costs, and the one with the best net outcome.3 sheets · 69 formulas · 13 KB
Retail Store P&L & Contribution TemplateOne P&L row per store with gross margin, contribution, sales per sq ft and per FTE, rankings, region totals and a vertical group P&L for the board pack.4 sheets · 453 formulas · 20 KB
Sell-Through & Open-to-Buy TemplateSell-through, weeks cover, and an open-to-buy that stops over-committing.5 sheets · 117 formulas · 16 KB
SaaS 4
Customer Health Score TemplateScores accounts 0-100 on seven banded factors with weights, assigns RAG and churn-risk rank, sums ARR at risk and lists renewals due in 90 days.6 sheets · 583 formulas · 29 KB
Deferred Revenue Waterfall TemplateRecognises contract value evenly across the term month by month, schedules billings, and rolls the deferred balance forward with checks.5 sheets · 760 formulas · 26 KB
Net Revenue Retention (NRR) CalculatorSplits customer MRR movement into churn, contraction and expansion to compute GRR and NRR by start-month cohort with a reconciling bridge.5 sheets · 333 formulas · 23 KB
Sales Capacity Plan TemplateBuilds monthly bookings capacity from rep start dates, ramp and attainment, adds planned hires, and sizes the gap to a bookings target.4 sheets · 372 formulas · 21 KB
Or bring your own spreadsheet
Upload a file and DataHub Pro runs 50+ analyses on your own numbers, free and unlimited.
Analyse your own file free →