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 factor | Value | Points |
|---|---|---|
| Albumin | 2.7 g/dL | 1 |
| INR | 1.8 | 1 |
| Altered mental status | No | 0 |
| Systolic pressure | 108 mmHg | 0 |
| Age | 72 years | 1 |
| Total | Arithmetic only | 3 |
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.