Will’s Workbooks

What was billed, less what it cost.

A custom, macro-free Excel workbook for a consulting team. It matches activity to cost by period and engagement ID, reports the margin, then lists every record it leaves out.

From the fictional October sample: $1,400 billed, less $800 cost, leaves a margin of $600.

Figures are fictional, taken from the sample workbook below.See the sheet they come from

What the workbook does

  1. Matched on two keys.

    Period and engagement ID. An activity row and a cost row meet only when both agree.

  2. Margin, stated plainly.

    Billed, cost, margin, margin rate and matched hours for the reporting month. October’s $600 is 42.86% of the $1,400 billed.

  3. Exceptions, never hidden.

    A row without its counterpart is left out of the totals and listed in an exception log, with the reason beside it.

Three sample pages

One fictional report, followed from October’s matched rows to the November refresh. Swipe, drag, or focus the row and use the arrow keys.

October client report. Matched rows total $1,400 billed, $800 cost, $600 margin and 12 hours.

October client report

$600

Two engagements match across both exports: $1,400 billed and $800 cost. See why two rows were excluded.

Matched October rows
IDBilledCostHours
E01$600$3505
E02$800$4507
Total$1,400$80012

Margin is $1,400 − $800 = $600, or 42.86% of billed.

October exception log. E03 has activity without a cost row. E04 has cost without an activity row.

October exception log

Two excluded

Each record left out of the October totals, with the reason. E03 is activity without cost; E04 is cost without activity.

E03 · Activity only. $200 billed and two hours are excluded. No cost row matches the period and engagement ID.

E04 · Cost only. $120 in costs is excluded. No activity row matches that key.

November refresh. $1,000 billed, $600 cost, $400 margin, nine hours and no exclusions.

November refresh

$400

The same workbook after both exports are replaced. $1,000 billed, $600 cost, and every row matches.

Matched November rows
IDBilledCostHours
E01$750$4006
E02$250$2003
Total$1,000$6009

Margin is $1,000 − $600 = $400, or 40.00% of billed. No rows excluded.

  1. October
  2. Exceptions
  3. November

Advanced Excel portfolio

Inside a year of consulting work.

Follow nine fictional engagements across twelve months. Investigate three held records, repair a missing cost and test the price change that clears a 54% margin target.

Take the workbook tour

See all selected work

The consulting portfolio workbook’s dashboard, built in Excel.

Scope and price

$2,000

USD, fixed price, one custom workbook.

You send
Two approved, de-identified exports that share a period and an engagement ID. Each export can contain up to 200 data rows.
You receive
One macro-free Excel workbook. It reports billed, cost, margin, margin rate and matched hours, with visible exceptions.
Refresh
Clear and paste both files, then choose the reporting month.
Also included
One handoff guide and one scoped correction.
Outside this package
Extra data sources, live dashboards and general cleanup.
Will it fit?
Check fit and calculate break-even.

Ask about a workbook

Describe one recurring report and the two exports behind it. Share column names or synthetic examples and keep client data private.