Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculations

BARD Score in a Spreadsheet: BMI, AST/ALT, and Diabetes

Explore the original 0–4 point BARD research score for advanced fibrosis in NAFLD using fictional inputs, with checks for missing or invalid values.

What the original research score represents

Harrison and colleagues studied BARD in 827 people with NAFLD at two specialist centers. The score combines BMI at least 28 (+1), AST/ALT ratio at least 0.8 (+2), and diabetes (+1). Later validation studies examined it in other groups; performance can vary by population.

In the original research, a score of 2–4 was associated with advanced fibrosis, and the reported negative predictive value was 96%. That is a group-level finding dependent on disease prevalence and study setting, not an individual guarantee that fibrosis is absent. The score does not diagnose fibrosis or determine follow-up or treatment.

Fictional inputArithmetic contribution
BMI below 28 / at least 280 / 1
AST/ALT below 0.8 / at least 0.80 / 2
Diabetes flag 0 / 10 / 1

Calculate the research score from complete numeric inputs

Enter positive BMI, nonnegative AST, positive ALT in the same units, and a diabetes flag of 0 or 1. The boundaries BMI = 28 and AST/ALT = 0.8 receive points. This example illustrates arithmetic on fictional data; it does not establish whether a model is appropriate for a particular person.

The 2023 American Gastroenterological Association guidance describes FIB-4 and other noninvasive tests in contemporary NAFLD/MASLD assessment; it should not be substituted with an automatic BARD-based referral or follow-up rule.

=IF(COUNT(B2:B5)<>4,"Enter four numeric values",IF(OR(B2<=0,B3<0,B4<=0,AND(B5<>0,B5<>1)),"Check BMI, AST, ALT and diabetes flag",IF(B2>=28,1,0)+IF(B3/B4>=0.8,2,0)+B5))

Try the example

Use the original values or change them to test your understanding.

Further reading