Healthcare & Clinical Calculations
Simplified PESI Research: Adding Six Binary Flags
Learn the six published sPESI factor weights through fictional inputs and complete-data checks.
The simplified PESI study
Jiménez and colleagues published a simplified Pulmonary Embolism Severity Index for prognostic research in patients with acute symptomatic pulmonary embolism. It contains six factors, each assigned one point when present, under definitions in the original study.
This worksheet only sums fictional flags that have already been assigned. It cannot diagnose pulmonary embolism, assess eligibility, predict an individual outcome or recommend hospitalization or anticoagulant treatment. Such decisions require clinicians, current guidance and the full clinical and social context.
Six factors and a fictional sum
The original model considers age, cancer history, chronic cardiopulmonary disease, heart rate, systolic blood pressure and oxygen saturation. The study specifies thresholds for these factors. In the invented example, flags 0, 1, 0, 1, 0 and 0 sum to 2.
| Factor in the study | Points when present |
|---|---|
| Age criterion | 1 |
| Cancer history | 1 |
| Chronic cardiopulmonary disease | 1 |
| Heart-rate criterion | 1 |
| Systolic blood-pressure criterion | 1 |
| Oxygen-saturation criterion | 1 |
Check and add the flags
Enter six numeric flags in B2:B7, each exactly 0 or 1. The formula rejects blanks, text and other values; it does not verify clinical measurements or define disposition.
=IF(COUNT(B2:B7)<>6,"Enter six numeric flags",IF(SUMPRODUCT((B2:B7<>0)*(B2:B7<>1))>0,"Flags must be 0 or 1",SUM(B2:B7)))Try the example
Use the original values or change them to test your understanding.