Medical Equipment Risk Scoring Workbook: Rolling Up the Fleet

When the Score Only Lives on One Row

A surveyor asks how the shop decided which infusion pumps get quarterly PM and which get annual. The technician pulls up a spreadsheet with 900 rows, each one scored individually — but nobody can say, at a glance, what the fleet looks like as a whole. Is the client's high-risk equipment concentrated in one department? Did last year's new ventilator purchase shift the whole risk profile up? The per-asset scores exist. The roll-up doesn't.

That gap is common. Most shops that build a risk classification method get as far as scoring individual assets, then stop. The scores sit in a column, unused past the moment they're assigned. Nobody rolls them into a distribution that answers a manager's actual questions: which client site carries the most risk-weighted equipment, which modality is trending upward, where should the next PM-hour budget go.

A medical equipment risk scoring workbook is built to close that gap — not just score one pump, but roll hundreds of scored assets into a picture you can act on, sorted by client, department, or modality. This article walks through the mechanism: what a roll-up actually does with per-asset scores, how to set your own weights, and a worked example showing the arithmetic end to end.

What a Risk Scoring Workbook Actually Rolls Up

A single asset's risk score is usually built from a handful of factors: its clinical function, the physical risk if it fails, its maintenance requirement, and sometimes its incident or recall history. Score each factor, weight them, sum or multiply them, and you get one number per asset. That part is covered in detail here and in the companion assessment template.

The roll-up is the second step, and it's the part most templates skip. Instead of stopping at 900 individual numbers, a workbook groups them: by client hospital, by department, by modality (infusion, imaging, patient monitoring), or by any tag you've applied to the inventory. Each group gets a distribution — how many assets fall into each risk band, and what share of the group's total risk-weighted score that represents.

That distribution is what turns a scoring exercise into a planning tool. A flat list of 900 scored rows tells you nothing about where risk concentrates. A roll-up by department tells you the ICU carries three times the risk-weighted load of general medical-surgical, which is useful information whether you're budgeting PM hours or explaining a maintenance plan to an auditor.

Picking the Factors and Weights — This Part Is Yours

There is no universal weighting formula for medical equipment risk classification, and this article does not assert one. ANSI/AAMI EQ56 describes a recommended practice for a medical equipment management program and applies to any entity managing medical equipment used in routine patient care — including independent service organizations — but it does not hand you a fixed numeric weighting table to copy. The factors and their relative weight are a program decision, documented and defensible, not a number to import from an article.

That means the workbook's job is to make your chosen weights transparent and consistent, not to supply them. A typical structure assigns a function score (how critical the equipment is to patient care), a physical-risk score (consequence of failure — electrical, mechanical, or otherwise), and a maintenance-requirement score (frequency and complexity of required service), each on a small numeric scale you define, then combined by weights you set.

Whatever weights a shop chooses, the discipline that matters to a surveyor is that the method is written down, applied consistently across the fleet, and revisited on a set schedule — not that the weights match some external benchmark. This is a documentation aid, not legal, regulatory, or accreditation advice; verify current expectations for your accrediting body and your own facility's documented program against CMS, the Joint Commission, or AAMI directly.

A Worked Example: Three Assets, One Method

Here is a simple worked example, using round numbers to show the method — not asserted as an industry standard.

Suppose a shop scores three factors on a 1–5 scale: function (F), physical risk (R), and maintenance requirement (M), then weights them 40% / 40% / 20% and sums.

• Infusion pump: F=4, R=4, M=3 → (4×0.4)+(4×0.4)+(3×0.2) = 1.6+1.6+0.6 = 3.8
• Patient monitor: F=5, R=3, M=2 → (5×0.4)+(3×0.4)+(2×0.2) = 2.0+1.2+0.4 = 3.6
• Exam table: F=1, R=1, M=1 → (1×0.4)+(1×0.4)+(1×0.2) = 0.4+0.4+0.2 = 1.0

Those three numbers, on their own, are just scores. The roll-up step averages or sums them across a group — say, every asset tagged "infusion" across all client sites — and shows where that group sits relative to the rest of the fleet. Change the weighting to 50/30/20 and the ranking can shift; that's why the workbook keeps the weights in one visible, editable place rather than buried in a formula nobody remembers writing.

For a leakage-current pass/fail check feeding into the physical-risk factor, NFPA 99 documents chassis leakage-current limits of 300 microamps for general-care areas and 100 microamps for critical-care areas under normal conditions — a concrete, testable input a shop can fold into its own risk-factor scoring where relevant.

From One Fleet to Many: Rolling Up by Client

For an independent service organization running PM and calibration across several hospital clients, a single flat roll-up isn't enough — the question isn't just "what's the fleet's risk profile," it's "what's this client's risk profile, and how does it compare to the next one." A workbook built for multi-client work groups the same per-asset scores by client tag first, then by department or modality within that client, so a shop can hand each hospital its own risk distribution without re-scoring anything.

That's the same structural idea behind HTM Compliance Manager's multi-client dashboard: one technician roster, one set of scored assets, but a distribution that can be sliced per client site for that client's own audit binder — without maintaining separate spreadsheets per contract.

Where the Score Feeds the PM Schedule

A risk score isn't the end goal. It's an input into PM interval determination — higher-risk equipment generally gets a shorter interval, subject to manufacturer recommendations, or a documented Alternate Equipment Maintenance approach where CMS allows one. The roll-up view is what lets a manager check that intervals actually track the risk distribution, rather than trusting that each asset was scored correctly in isolation.

This workbook is a documentation aid, not legal, regulatory, or accreditation advice — it organizes the scoring and PM-interval logic a program has already decided on. It does not touch clinical or patient data; the scope is equipment service records only, with no PHI, EHR integration, or device telemetry involved.

Before building a roll-up from scratch, it helps to start from a clean asset list. The equipment inventory template is the foundation most shops are missing.

Download the Workbook

The Equipment Risk-Classification & PM-Interval Scoring Workbook includes the per-asset scoring tabs, editable weight fields, and the client/department/modality roll-up views described above — ready to load with your own fleet the same day.