Video · 0:45
Metricvalley: what the templates do
Transcript
The video has no sound. This is what it shows, in order: each caption, then what is on screen.
- See which clients pay for the work they take. Driftwood Fitness did not. Client Profitability Tracker, Summary sheet, By client, Aug 2026, with eight fictional clients. Driftwood Fitness is outlined: net fees 1,950.00, delivery cost 2,160.00, contribution before overhead -210.00 USD.
- Type one row per client project a month. Clients are fictional. Work Log, row 21: the Aurora Dental row for August is being typed. Cost currency USD, external costs 850.00 and delivery hours 28.0 go in, one cell at a time.
- Complete the row: Aurora Dental's contribution now reads 2,410.00. Summary, By client: before the last cell, Aurora Dental shows 0.00 with one row in review. After the hourly cost is typed, it shows net fees 4,800.00, delivery cost 2,390.00 and contribution 2,410.00, outlined.
- See which retainers will run out of hours. Aurora Dental runs out on 24 August. Retainer Burn & Capacity Planner, Dashboard: the retainers with the least projected hours left in Aug 2026: Harbor Retail -28.5 (Over); Aurora Dental -10.2 (Runs out early, 24 Aug 2026); Greenfield SaaS -1.1 (Runs out early, 27 Aug 2026); Sample Studio 1.7 (Close to limit); Beacon Legal 4.3 (On track); Copper & Co 11.6 (Under-used). Aurora Dental is outlined: 36.0 hours available, 22.0 used to date, -10.2 projected hours left at month end, runs out early on 24 Aug 2026.
- See how many months the cash covers. Losing one client cuts 9 months covered to 5. Cash & Runway Planner, Dashboard: Plan: Oct 2026 to Sep 2027. Currency: USD. Change them on Setup. Outlined: months covered of 12, base case 9; Client leaves 5, fewer than the base case.
- Price a project so it still pays. The quote clears walk-away by 6,063.32. Project Quote Calculator, Dashboard, Key figures for quote EX-Q0142 for Harbor Retail: Website rebuild: quote price 25,500.00 USD, delivery cost 13,919.00, contribution before overhead 11,581.00, quoted margin 45.4%, markup on delivery cost 83.2%, headroom over walk-away price 6,063.32. The headroom figure is outlined.
- Yellow cells: you type. Leave the rest to the workbook. Client Profitability Tracker, Start Here, row 3: the color key. The key sentence and the yellow swatch are outlined; the white and grey swatches sit beside it.
- Ten checks, each with a fix if it reads CHECK. Client Profitability Tracker, Dashboard Checks block: ten named checks, each with a count, a result (nine read OK; check 10, Sample data, reads SAMPLE) and what to do if it reads CHECK.
- All four tools are on sale: profit, quotes, retainers, cash. Card, "Templates by decision": Price & quote, Project Quote Calculator, on sale. Client profitability, Client Profitability Tracker, on sale. Capacity & utilization, Retainer Burn & Capacity Planner, on sale. Cash & runway, Cash & Runway Planner, on sale. Each tool goes on sale only after it passes our release checks in desktop Excel. On sale now: all four tools.
- Spreadsheet tools for small agencies. Live demo: metricvalley.com. End card: Spreadsheet tools for small agencies. On sale: the Client Profitability Tracker, the Project Quote Calculator, the Retainer Burn & Capacity Planner and the Cash & Runway Planner. No macros, one-time purchase. Excel 365 · Google Sheets edition when it ships. metricvalley.com. Note: every sheet shown is the worked-example file in Excel 365 (the tracker v2.1.0, the three planners v1.1.0), every client is fictional, and one Work Log row was removed before the video, then typed back in.