Healthcare & Clinical
MEWS: Comparing a Published Five-Parameter Example
Calculate a five-parameter MEWS example using one explicitly identified published scoring table, with complete-input checks and version limits.
Early warning scores have multiple versions
A Modified Early Warning Score (MEWS) combines points from physiological observations. This educational example reproduces the five-parameter table printed by Jiang and colleagues in a 2019 trauma study: systolic blood pressure, heart rate, respiratory rate, temperature and an assessed AVPU level. It is not a real-time monitor or an escalation system.
Published MEWS tables differ. In the 2019 table used here, a systolic pressure of 70 scores 2 and heart rate 40 scores 1. Other implementations assign different points at these exact boundaries, and some versions include additional observations such as urine output. Do not combine this example’s thresholds with another institution’s protocol.
Subbe and colleagues’ 2001 single-center medical-admissions study found an association between higher scores and adverse outcomes, not a universal prediction for every patient or setting. Clinical concern, a single abnormal observation, or local escalation policy may require action regardless of a computed total. This worksheet does not notify staff, replace assessment or decide a response.
| Five parameters in this example | Selected boundary examples | Points in the cited 2019 table |
|---|---|---|
| Systolic pressure | 69 / 70 / 81 / 200 mmHg | 3 / 2 / 1 / 2 |
| Heart rate | 39 / 40 / 51 / 130 per minute | 2 / 1 / 0 / 3 |
| Respiratory rate | 8 / 9 / 15 / 21 / 30 per minute | 2 / 0 / 1 / 2 / 3 |
| Temperature | 34.9 / 35.0 / 38.5 °C | 2 / 0 / 2 |
| AVPU | Alert / voice / pain / unresponsive | 0 / 1 / 2 / 3 |
Sum the five parameter points
B2:B4 use positive whole-number pressure and rates; B5 is positive temperature in °C entered to one decimal place; B6 is an already-assessed numeric AVPU score 0–3. All five values are required.
=IF(COUNT(B2:B6)<>5,"Missing or nonnumeric input",IF(OR(B2<=0,B3<=0,B4<=0,B5<=0,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,ROUND(B5,1)<>B5,B6<0,B6>3,MOD(B6,1)<>0),"Invalid input",IF(B2<70,3,IF(B2<=80,2,IF(B2<=100,1,IF(B2<200,0,2))))+IF(B3<40,2,IF(B3<=50,1,IF(B3<=100,0,IF(B3<=110,1,IF(B3<=129,2,3)))))+IF(B4<9,2,IF(B4<=14,0,IF(B4<=20,1,IF(B4<=29,2,3))))+IF(B5<35,2,IF(B5<38.5,0,2))+B6))Try the example
Use the original values or change them to test your understanding.