Excel
Custom transformations, formulas, and reports the built-in features won't build for you. Each entry ships with the tool, a user guide, and the prompts to build a similar one yourself.
Excel Rescue
A local web app for three Excel pains that don't need a formula. Split heterogeneous columns into clean pieces. Collapse line-item rows and sum order-level fields once per key. Combine CSVs from sources with mismatched schemas. Runs entirely on your machine; data never leaves it.
Tracker Doctor
Most "simple project tracker" markets are saturated. The unmet pain is the inverse: tell me what's wrong with the tracker I already have. Tracker Doctor audits an .xlsx for the four decay patterns that quietly kill long-lived trackers — volatile functions, full-column refs, conditional-format fragmentation, sort-breaking date formulas — and writes a one-page HTML report with the fix for each.
Action Item Aging Report
Reads your Excel action log and classifies every open item by age (Fresh / Active / Aging / Stale), flags chronic offenders (items chased 3+ times, items with no owner, items 91+ days since last update), aggregates per-owner, and renders a one-page HTML report with a GREEN/AMBER/RED hygiene verdict. The artifact every PM who runs action items in Excel rebuilds every Monday — "what's stale, who hasn't picked things up, what keeps getting chased."
Risk Register Decay Audit
Reads your Excel risk register and audits every active risk against priority-tiered review cadence rules — High (score 6+) stale if reviewed >7 days ago, Medium (3-5) >14 days, Low (1-2) >30 days. Also flags unowned risks and risks with no mitigation. The predicate to a trustworthy risk report: a register updated once at kickoff and never revisited is a compliance artifact, not a management tool. One HTML page, GREEN/AMBER/RED verdict.
Excel Plan Validator
For PMs whose only planning tool is Excel. Reads your project plan xlsx and runs 8 structural integrity checks — End before Start, Parent ending before child, Milestone with non-zero duration, Duplicate task IDs, Orphaned predecessors, Missing dates, End-in-past with 0% complete, and 100%-complete-with-incomplete-predecessor. Excel doesn't catch any of these. The errors only surface when someone else notices, usually at steering committee. One HTML page, RED/AMBER/GREEN verdict. Run before every baseline change.
Plan vs Actual Variance Report
The cycle-by-cycle deliverable for Excel-only PM plans. Reads your xlsx with Baseline + Forecast date columns, computes per-task variance in working days, buckets each task (Ahead / On Track / Slipped / At Risk / Critical), surfaces project finish slip, ranks owners by total slip-days. The variance report every steering committee cycle asks for — same shape as MSP's Baseline Drift Report, no MSP needed. Pair with Excel Plan Validator (entry 05) which is the pre-baseline gate.
Claude could write this. Two reasons to prefer the script.
Some workplaces — defense, medical devices, finance, anywhere with a strict IT policy — won't let Claude or any AI tool touch production data. These tools run locally with no network calls. And even where AI is allowed, repeat workflows shouldn't cost tokens — a deterministic script runs the same way every time, for free, forever. The prompt guide on each entry shows how the tool was built with Claude; the downloads are what you run after.