Arte SheetsLearn. Try. Understand.

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.

Component0 points1 point2 points3–5 points
Age (years)40–4950–5960–6970–79: 3; 80–89: 4; 90+: 5
MRC dyspnoea grade0–1234: 3
FEV1 (% predicted)65 or above36–6435 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.

Further reading