Summary
Where you stand
- Measures
- 0
- Met
- 0
- Progressing
- 0
- Off track
- 0
- Average progress
- --
- Weakest measure
- --
Calculator Library / Public Service
Public Service Scorecard Builder
List your service measures with baselines, targets, and actuals, and see progress toward target, status, and the weakest measures at a glance.
Tool
List your measures, targets, and actuals
Progress: (actual − baseline) / (target − baseline). Met at 100% or more; Progressing at 60% or more; otherwise Off track.
| Measure | Type | Better is | Baseline | Target | Actual | Progress | Status |
|---|
Your work saves in this browser only. Nothing is sent to a server.
Progress
Progress toward target
Instructions
How to use this app
- List a small set of measures that reflect the service's purpose, mixing efficiency, quality, and outcome measures.
- Record the baseline before the improvement started, the target, and the latest actual.
- Set whether a higher or lower value is better. The progress formula handles both.
- Look at the weakest measures first, and check that no measure is improving at the expense of another.
- Update actuals regularly and export to CSV for reporting.
What This Public Service Scorecard Builder Helps You Decide
This builder helps a service team decide whether it is actually improving. You list a handful of measures, record where each started (the baseline), where it should get to (the target), and where it is now, and the tool calculates progress toward the target and flags which measures are met, progressing, or off track.
Use it for monthly service reviews, for reporting to leadership, and to check that a set of measures is balanced across efficiency, quality, and outcomes.
How Progress Is Calculated
| Item | Formula | Meaning |
|---|---|---|
| Progress | (Actual − Baseline) / (Target − Baseline) | How far along the way from baseline to target the measure is. It works for both higher-is-better and lower-is-better measures. |
| Met | Progress of 100% or more | The target has been reached or passed. |
| Progressing | Progress of 60% to under 100% | Meaningful improvement, but not there yet. |
| Off track | Progress under 60% (including negative) | Little improvement, or worse than baseline. |
Worked Example: A Permit Office
The pre-loaded scorecard has six measures. Days from application to permit moves from a baseline of 26.5 to an actual of 21 against a target of 16, so progress is (21 − 26.5) / (16 − 26.5) = 52%, which is off track. Inspections on time moves from 80% to 96% against a target of 95%, so progress is 107%, and it is met.
Read as a set, the scorecard shows that the office is on target for inspections and close on satisfaction, while cost per permit, the backlog, and first-time-complete are the weakest. Because first-time-complete drives both cost and backlog, it is the natural place to focus.
Limits and Good Practice
- Progress is a summary. Look at trends over several periods, not one period's number.
- Choose measures that reflect the service's purpose, and pair speed with quality. Fast but wrong is not improvement.
- Thresholds of 100% and 60% are simple defaults; use your agency's own reporting rules where they exist.
- Data stays in your browser. Do not enter personal information about residents.
Public Service Scorecard Builder Frequently Asked Questions
How is progress toward target calculated?
Progress is actual minus baseline, divided by target minus baseline. It measures how far a measure has moved along the path from where it started to where it should be, and it works for measures where lower is better because the signs cancel.
How many measures should a scorecard have?
A small set, often five to ten, chosen to reflect the service's purpose and mixing efficiency, quality, and outcome measures. Too many dilute attention, and too few can hide trade-offs between speed, quality, and cost.
Is my data stored anywhere?
No. The scorecard saves in your own browser using local storage and nothing is sent to a server. Clear your browser data or use Clear all to remove it, and do not enter personal information about residents.