Healthcare & Clinical
Revised Trauma Score: Weighted and Unweighted Arithmetic
Convert three fully documented physiological values into coded categories and compare weighted RTS with the unweighted sum, without automatic transport decisions.
Two related scores with different purposes
Champion and colleagues’ 1989 revision uses Glasgow Coma Scale (GCS), systolic blood pressure and respiratory rate, each converted to a code from 0 to 4. The weighted Revised Trauma Score (RTS) combines these codes for outcome evaluation. A separate unweighted T-RTS adds the same codes and ranges from 0 to 12.
Weighted RTS = 0.9368 × GCS code + 0.7326 × blood-pressure code + 0.2908 × respiratory-rate code. Its maximum is 7.8408. The weights apply to the coded categories, not directly to the measured values.
Require complete values before assigning codes
The educational example accepts a fully testable integer GCS from 3 to 15, and nonnegative whole-number values for systolic pressure in mmHg and breaths per minute. Zero is a category in the published table; a missing or not-testable measurement must not be entered as zero. If any value is missing or invalid, the code cells and both totals show a message.
| Code | GCS | Systolic pressure, mmHg | Respiratory rate, breaths/min |
|---|---|---|---|
| 4 | 13–15 | 90 or more | 10–29 |
| 3 | 9–12 | 76–89 | 30 or more |
| 2 | 6–8 | 50–75 | 6–9 |
| 1 | 4–5 | 1–49 | 1–5 |
| 0 | 3 | 0 | 0 |
=IF(COUNT(B2:B4)<>3,"Enter all three numeric values",IF(OR(B2<3,B2>15,B2<>INT(B2),B3<0,B3<>INT(B3),B4<0,B4<>INT(B4)),"Enter valid whole-number values","OK"))Weighted score example
GCS 7, systolic pressure 68 mmHg and respiratory rate 32/min give codes 2, 2 and 3. The weighted total is 4.2112. This example requires the separate code cells to be calculated from the validated inputs.
=IF(B5<>"OK",B5,ROUND(0.9368*B6+0.7326*B7+0.2908*B8,4))Unweighted sum and clinical context
The same fictional values have an unweighted total of 7. It is a different quantity from weighted RTS and is not itself a predicted survival percentage.
A trauma score is not a substitute for clinical judgment or an instruction to select a transport destination. The 2021 National Guideline for Field Triage considers injury patterns, physiology, mechanism and EMS judgment; systems and local protocols determine actual care. This spreadsheet does not provide a triage or transport recommendation.
=IF(B5<>"OK",B5,SUM(B6:B8))Try the example
Use the original values or change them to test your understanding.