Will’s Workbooks

Advanced Excel portfolio

What changed
in December?

Nine engagements. Twelve months. A $96,581 matched contribution margin, with three December engagements still on hold. Open the workbook to trace the numbers, then see what a rate change would buy.

All client names and records are fictional. This portfolio demonstrates a larger commission. The $2,000 fixed-price workbook has its own published scope.

Executive worksheet showing the selected month, five matched metrics and portfolio trends.
Executive worksheet · December 2026

Executive · Period selector C5

Read the month before judging the change.

Open a fresh copy in desktop Excel with calculation set to Automatic. On Executive, choose 2026-12 in C5. Exactly one valid activity row and one valid cost row for the same period and engagement ID enter the reported totals.

December matched results
Billed$186,663
Direct cost$90,082
Contribution margin$96,581
Margin rate51.74%
Delivery hours701

Switch to 2026-11. November shows $140,845 in matched margin and no held engagement keys. December excludes $57,911 in billed activity, so the difference alone cannot establish that delivery performance declined. Switch back to December.

Executive dashboard with a warning for three held December engagement keys.
Open the image at full size to inspect the report.

Reconciliation · Engagement

Find what the headline leaves out.

Choose Review held records or open the Reconciliation tab. Start with the first three entries. E07 is missing cost, E08 is missing activity, and E09 has a duplicate key. A held key can represent several source rows.

December’s bridge from source to report
SourceMatchedHeldExport total
Billed$186,663$57,911$244,574
Cost$90,082$35,692$125,774

On Engagement, select E07 in C5. Halcyon Museum’s November row shows $24,300 billed and $11,900 cost. December’s financial fields are blank while the cost record is missing. Use Open row on the reconciliation sheet to inspect the available source.

Reconciliation control totals and the three held engagement keys.
Source totals, exclusions and direct links to the exports.

Scenario · Driver D7

Try a higher rate without rewriting history.

Keep December as the base and open Scenario. Leave hours growth at 2%, vendor inflation at 6%, and vendor cost share at 35%. Read the Month 2 contribution margin in D24.

One input changes
Rate uplift in D7Month 2 margin
4% · starting case$105,370
8% · alternative$112,986

Enter 8% in D7. Projected Month 2 margin rises about $7,616. Return to Executive to verify that December’s recorded margin is still $96,581. The forecast uses matched portfolio activity and the stated assumptions.

Across all three periods, the 4% case returns $316,110 at 53.2%, below the 54% target in I7. The 8% case returns $338,957 at 54.9%, clearing that target. The sensitivity grid in C35:G39 shows how Month 1 responds to other rate and hours combinations. Restore D7 to 4% before the next exercise.

Scenario worksheet with editable assumptions, three projected periods and a rate-versus-hours sensitivity grid.
Change the assumptions in the colored input cells.

Cost Export · Optional exercise

Watch a missing cost rejoin the report.

Use a separate copy of the original download. Enter the following fictional, verified cost record into the reserved cells on Cost Export. For the period in C113, type '2026-12. The leading apostrophe makes Excel store the period as text.

Enter a single source row
B113 · Record IDCST-12-E07
C113 · Period2026-12
D113 · EngagementE07
E113 · Cost9800
F113 · CategoryDirect delivery

On Executive, December now has two held keys. Matched billed becomes $210,234, cost $99,882, margin $110,352, and hours 798. E08 and E09 still need their own source checks. In a real engagement, confirm a correction against the approved source before entering it.

Halcyon Museum engagement history. The original December row shows Cost missing.
Engagement view before the synthetic repair.