Arte SheetsLearn. Try. Understand.

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 studyPoints when present
Age criterion1
Cancer history1
Chronic cardiopulmonary disease1
Heart-rate criterion1
Systolic blood-pressure criterion1
Oxygen-saturation criterion1

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.

Further reading