Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculations

Lille Model: Day-7 Alcohol-Associated Hepatitis Example

Explore the original Lille model’s variables, units and limitations using fictional data; the example does not prescribe treatment.

What the model was developed to study

Louvet and colleagues developed the Lille model in patients with severe alcohol-associated hepatitis receiving corticosteroids. It combines age, baseline albumin, bilirubin at baseline and day 7, renal insufficiency and prothrombin time. The score relates to outcomes in the study population and is not a guarantee of an individual’s survival or response.

The 2007 study examined a cutoff of 0.45 in its cohorts. Different analyses have used additional response groupings; do not treat one cutoff or grouping as an automatic treatment instruction. Decisions about steroids and transplantation require specialist assessment and the full clinical context. Do not start, stop or change prescribed treatment based on this spreadsheet.

Model inputs and units

Enter age in years (B2), baseline albumin in g/L (B3), baseline and day-7 bilirubin in µmol/L (B4 and B5), a previously assessed renal-insufficiency flag 0 or 1 (B6), and baseline prothrombin time in seconds (B7). The change in bilirubin is baseline minus day 7. The original paper also describes a separate INR-based variant; do not enter INR in this PT-seconds example.

For the original study definition, renal insufficiency included serum creatinine above 1.3 mg/dL (about 115 µmol/L) OR creatinine clearance below 40 mL/min. A creatinine value alone therefore does not represent the complete definition. This workbook cannot assess kidney function or determine the flag.

Calculate the historical day-7 expression

This formula illustrates the published PT-seconds expression, rounded to four decimals. It requires all inputs, rejects nonpositive measurements and a nonbinary renal flag, and limits the internal linear predictor to −100 through 100 to avoid overflow. Those checks do not validate the data, patient eligibility or clinical use.

=IF(COUNT(B2:B7)<>6,"Enter all six valid numeric model inputs; renal flag must be 0 or 1",IF(OR(B2<=0,B3<=0,B4<=0,B5<=0,AND(B6<>0,B6<>1),B7<=0),"Enter all six valid numeric model inputs; renal flag must be 0 or 1",IF(ABS((3.19-0.101*B2+0.147*B3+0.0165*(B4-B5)-0.206*B6-0.0065*B4-0.0096*B7))>100,"Inputs outside the example numerical range",ROUND(1/(1+EXP((3.19-0.101*B2+0.147*B3+0.0165*(B4-B5)-0.206*B6-0.0065*B4-0.0096*B7))),4))))

Two fictional calculations

With age 52, albumin 26 g/L, baseline bilirubin 310 µmol/L, renal flag 0 and PT 19.5 seconds, day-7 bilirubin 285 µmol/L gives approximately 0.5074. Changing only day-7 bilirubin to 140 µmol/L gives 0.0861. These figures illustrate arithmetic, not individual prognosis or medication instructions.

Try the example

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

Further reading