Clinical Medicine & Physiology
Original ADO Index: An Educational Spreadsheet Example
Reproduce the 2009 ADO point arithmetic using illustrative inputs, and distinguish the original score from the later updated index.
Two different versions of a research score
Puhan and colleagues published an ADO index based on age, dyspnoea and airflow obstruction in 2009. Its original point table ranges from 0 to 10. An international study published in 2012 updated the points and calibration, producing a different 0–14 index. Do not mix point values or risk equations from the two versions.
This page is a spreadsheet exercise using invented values and the original 2009 point table. It does not calculate an individual mortality probability or recommend care. COPD evaluation and prognosis require clinical context and a qualified clinician.
Illustrative point table from the original 2009 ADO index
The original table assigns age points by decade, dyspnoea points from the specified MRC grades, and FEV1 points by percent predicted. This worksheet uses whole-number percentages, as in the displayed bands, to avoid assuming how a fractional value should be classified.
| Component | 0 points | 1 point | 2 points | 3–5 points |
|---|---|---|---|---|
| Age (years) | 40–49 | 50–59 | 60–69 | 70–79: 3; 80–89: 4; 90+: 5 |
| MRC dyspnoea grade | 0–1 | 2 | 3 | 4: 3 |
| FEV1 (% predicted) | 65 or above | 36–64 | 35 or below | — |
Calculate the illustrative original ADO point sum
Enter whole-number age 40–120, MRC grade 0–4, and whole-number FEV1 percent predicted from 1 to 150. These are limits for this example, not a validation of clinical inputs. For age 72, grade 3, and FEV1 42%, the sum is 3 + 2 + 1 = 6.
=IF(COUNT(B2:B4)<>3,"Enter numeric ADO inputs",IF(OR(B2<40,B2>120,B2<>INT(B2),B3<0,B3>4,B3<>INT(B3),B4<=0,B4>150,B4<>INT(B4)),"Invalid illustrative inputs",MIN(5,INT((B2-40)/10))+IF(B3<=1,0,B3-1)+IF(B4>=65,0,IF(B4>=36,1,2))))Interpretation
The output is only a numerical reproduction of the original table, not a prediction. The later updated ADO index uses different point weights; neither numeric input validation nor this page verifies the clinical measurements or establishes applicability to a person.
Try the example
Use the original values or change them to test your understanding.