Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

AIMS65: An Educational Point-Counting Spreadsheet Example

Practice the five-factor AIMS65 point arithmetic with invented inputs; the worksheet does not determine mortality risk, admission, or treatment.

A research score is not a home triage tool

The AIMS65 score was developed using hospitalized adults with acute upper gastrointestinal bleeding. This page demonstrates its point arithmetic with invented values; it does not diagnose bleeding, predict an individual outcome, or choose a ward, intensive care, discharge, endoscopy, or treatment.

Gastrointestinal bleeding can be an emergency. Vomiting blood or passing black tarry stool warrants urgent medical attention; seek emergency care when indicated rather than using a spreadsheet to decide what to do. Clinical decisions require professional assessment.

The five admission factors in the original score

The original study assigned one point each for albumin below 3.0 g/dL, INR above 1.5, altered mental status, systolic blood pressure at or below 90 mmHg, and age older than 65 years. The result is a sum from 0 to 5, not an individualized outcome estimate.

For the invented example below, 2.7 g/dL albumin, INR 1.8, no altered mental status, systolic pressure 108 mmHg and age 72 give 1 + 1 + 0 + 0 + 1 = 3.

Illustrative factorValuePoints
Albumin2.7 g/dL1
INR1.81
Altered mental statusNo0
Systolic pressure108 mmHg0
Age72 years1
TotalArithmetic only3

Calculate the illustrative point sum

Enter albumin, INR and systolic pressure as positive numeric values, altered mental status as 0 or 1, and age in completed whole years of at least 18. The example checks numeric encoding, not whether the data, units, patient population, or clinical interpretation are appropriate.

=IF(COUNT(B2:B6)<>5,"Enter numeric AIMS65 inputs",IF(OR(B2<=0,B3<=0,AND(B4<>0,B4<>1),B5<=0,B6<18,B6<>INT(B6)),"Invalid illustrative inputs",IF(B2<3,1,0)+IF(B3>1.5,1,0)+B4+IF(B5<=90,1,0)+IF(B6>65,1,0)))

Limits

Published estimates vary by population and context. A consensus guideline cautions against using AIMS65 alone to identify patients for safe early discharge. This example provides no mortality percentages or automated care decisions.

Try the example

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

Further reading