Static, copyable worksheet for the analyst and person who uses a maintenance KPI. It prepares a draft for review. Keep real records in an environment accepted by their data owner.
What this sheet needs and produces
Audience: maintenance analysts, planners and supervisors preparing an agreed KPI review.
Inputs: a versioned definition; complete population/identifier list; relevant scope and status history; checked evidence with dates; target; reviewer roles and authority; the question the meeting needs to answer.
Output: a reproducible calculation, an ID reconciliation, record-linked draft wording, unanswered questions and an acceptance record. Supplying a complete field does not establish the truth of the underlying observation.
Assumptions: the stated scope, population and evidence are accepted as the trial input; the people checking it can consult the underlying records and ask someone who knows the work. The brief cannot establish source completeness, operational risk, suitability for a particular service or authority to act.
Human acceptance: the analyst checks IDs, dates and arithmetic. The maintenance supervisor checks operational meaning and accepts wording within their authority. Named action owners must agree any task and date. An assistant cannot supply their agreement.
Copy and complete the brief
Prepare a draft for [named person]'s [review]. Use only evidence pack [version/date] and controlled KPI definition [version]. The decision to support is [question].
Count [unit] from [population]. Apply [numerator/denominator rules], [scope/tests], [date/time-zone/cut-off rules], [cancellations/deferrals/reopenings/additions rules], [missing-evidence rule], [zero-denominator rule] and [target/rounding rule].
Return the calculation and an order-by-order reconciliation. Put record references beside factual statements. Separate supplied observations, unknowns and proposed questions. Retain qualifications, conflicting evidence and missing records. Do not invent a cause, blame, impact, agreement or future benefit. Suggest people who could answer questions; do not present suggested assignments as accepted actions.
The draft has no authority to change records, rules, schedules or work instructions. [Analyst] checks coverage/calculation; [supervisor] accepts meaning; operational actions use [normal authority]. Stop and identify what is missing if a defensible calculation cannot be made.
Before the run
| Check | Record your answer |
|---|---|
| Exact task, decision owner, definition and evidence-pack versions | |
| Complete population and any additional-work list | |
| Scope/tests, dates, exceptions and target accepted by whom? | |
| Reference answer calculated separately before asking AI | |
| Environment and data use accepted by the data owner | |
| Model/configuration/date actually used, exact submitted prompt retained |
Beside the returned draft
- Reconcile every supplied ID, including additions and missing-evidence exceptions.
- Recalculate both parts, percentage and target comparison using the written definition.
- Open the awkward records: late closure, reopening, cancellation and deferral.
- Trace each explanation to evidence. Preserve what remains unknown.
- Distinguish suggested reviewers/questions from agreed actions.
- Record who accepts the wording and who owns the next evidence check. Keep unaccepted claims visible.
Completed acceptance example: entirely fictional
This is an authored extension of article 017, not a record of real people accepting the model experiment. The actual experiment is retained separately in the exact prompt and response.
| Field | Fictional entry |
|---|---|
| Definition and input | Article 009's fictional frozen weekly schedule completion v1; WO-901–913, exact trial prompt |
| Reference and model draft | 8 supported completions / 12 frozen orders = 66.7%; WO-913 separate |
| Analyst role | Alex checks the IDs and arithmetic; all 13 IDs reconcile as 8 + 4 + 1 |
| Supervisor role | Helen checks scope/evidence treatment, including WO-908 and WO-909, and accepts the result for this review |
| Correction | No calculation or cause claim required correction; accepted wording retains open questions |
| Follow-up decision | Helen takes responsibility for checking the WO-909 status/test handover by Friday 16 October 2026 at 14:00 Europe/London, an hour before the next freeze |
| Evidence sought | Original-scope test requirement, status-history entries and the explanation from people involved; underlying cause still open |
| Closure criterion | Helen compares the records with the account from the people involved; she records what is established and any remaining gap |
| Limit | No work release, blame, changed target or improved result established; investigation outcome not supplied |
Blank acceptance record
| Field | Reviewer entry |
|---|---|
| Exact draft/version/model date retained | |
| Calculation and IDs checked by/date | |
| Record claims accepted; claims rejected and reasons | |
| Unanswered question/evidence needed | |
| Interpretation accepted by/date | |
| Proposed follow-up; authority; action owner's agreement | |
| Owner, due date, evidence needed to close, person accepting closure | |
| Next review/date and remaining limits |
The sheet is supplied now as a static worksheet. A calculator or connected review app is a separate proposal requiring its own scope and checks. No integration, measured time saving or operational acceptance is claimed.