What the workbook is
It is a working Excel file (.xlsx) with ten tabs. One tab is instructions. One tab, Scorecard, is the page you show the board: eight numbers under five questions, each with a status, a trend, a confidence flag and a read. The other eight hold the bar you set and the data behind the page.
It is the build-it-by-hand track from the Scorecard Build Blueprint. To read what a board-level Legal Scorecard is and why it asks these five questions, start with the ebook.
What is in it
The Scorecard tab answers five questions with eight numbers.
Are we on top of the whole workload?
Is the business unblocked, and are matters moving?
Are we protected?
Are we growing capacity faster than headcount?
Is spend under control?
Each data tab is filled from a report you already pull, a list you keep, or, for Shadow demand, a reconciliation you run.
| Tab | What it holds |
|---|---|
| Start here | How the workbook works and the monthly routine |
| Scorecard | The one page. It fills itself, and you write the read. |
| Targets | What good looks like, the watch bands and last period’s values |
| Requests | Received time, first human touch and how each request resolved |
| Matters | Open and close dates, native status, last activity, category and owner |
| Status map | Each native status mapped to one of five standard statuses |
| Critical dates | One row per date, with its matter, owner and source |
| Spend | Invoiced to date and accruals per matter, and the phased department budget |
| Roster | Each lawyer, in-house or an outside provider |
| Shadow demand | The traces you reconcile each period, and the prior count |
The sample data is fictional, built for a made-up company called Northwind Industries. It is set up so every line on the Scorecard tab matches the example page in the ebook, which lets you check the workbook is calculating before you trust it with your own numbers.
How to use it
Set it up once, then run the routine each month.
Set it up
- 1Read the Start here tab. It explains how the workbook works and what to type in.
- 2Set the bar in the blue cells. The blue cells on the Targets and Spend tabs are yours: the bar, the period, and the budget.
- 3Replace the sample rows. White and light-blue rows on the data tabs are sample data. Delete them and paste your own export in their place. The formulas run to row 604 on Matters and row 404 on Requests, so you can paste more rows than the sample holds.
- 4Leave the grey italic columns alone. They are calculated. If you paste over one, copy it back down from the row above.
- 5Write the read. The read column on the Scorecard tab is typed by a person. The number reports; the read thinks, and someone owns it.
Run the monthly routine
- 1One owner, one cadence. The page is only as current as its slowest pull. Pick a rhythm, hold it, and put one person in charge of it.
- 2A written pull routine. The same reports from each source, the same day, the same steps, so it comes out the same no matter who runs it.
- 3Version control. Before you paste new data, copy this month's driver values from the Targets tab into the prior-period column. Then date this file and keep the last one.
- 4A QA pass before it ships. Check the Matters tab for anything reading "Unmapped", check the Critical dates tab for anything reading "No" under Owned, and check that every line you cannot fully feed carries a confidence flag.
Three things that make it stand up to a challenge
Identity, not labels. Every status mapping has a Map ID and an effective date, and every request carries a Dept ID from the Departments list. Names typed by hand cannot be grouped, trended, or audited. The Status map also counts the matters using each mapping and names one, so you can validate a rule instead of trusting it.
The audit trail. Keep the Map ID and Effective From columns current. When someone asks in six months why the stalled number moved, that trail is how you show a mapping changed rather than the work changing.
Declare your capacity basis. Whether outside counsel counts as capacity is a strategic decision, not a formula. Set it once on the Targets tab. The page names the assumption and shows the number both ways, so nobody reads load per lawyer without knowing what is in it.
When the monthly pull becomes the work
The workbook runs on exports and on a person who pulls them. LegalOperator produces a Legal Ops Scorecard in the app or as an emailed PDF. See how legal spend works in LegalOperator.
Common questions
What is the Legal Scorecard Workbook?
It is a free Excel file with ten tabs. You paste in exports from your intake, matter, docket and invoice sources, and the Scorecard tab calculates a one-page view of eight numbers under five questions. Sample data from a made-up company is already in it.
Is there a form, or a charge?
No. The download is a direct link to the file, with no form and no email address asked for.
Do I need LegalOperator or another system to use it?
No. Each tab is filled from a report you can already pull or a log you keep by hand. The workbook does not connect to any system.
Who writes the read on each line?
A person on your team types it. The workbook calculates the number, the status and the trend, and it does not write the read.
How do I check the workbook is calculating before I use my own data?
The sample data is built for a fictional company, Northwind Industries, and every line on the Scorecard tab matches the example page in the ebook. Compare the two, then replace the sample rows with your own export.
Where do I read what a board-level Legal Scorecard is?
In the ebook, How to Build a Board-Level Legal Scorecard. The workbook is the companion that builds the page it describes.
Want to see LegalOperator?
Book a demo and we walk through LegalOperator in the demo environment, with sample data.
Book a demo