Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

PERC and Revised Geneva: Educational Flag and Point Sums

Practice two separate sums using fictional pulmonary-embolism assessment inputs. This worksheet does not rule out PE or decide diagnostic testing.

Neither sum rules out pulmonary embolism

Pulmonary embolism (PE) can be life-threatening. Suspected PE requires prompt medical assessment. This page contains two educational arithmetic exercises; it cannot assess clinical probability, diagnose or exclude PE, or determine whether a D-dimer or imaging test is needed.

PERC was studied in a specifically selected emergency-department population with low clinical suspicion. The revised Geneva score is a separate prediction rule. Their use depends on complete clinical information, applicable definitions, population and current guidance—not a spreadsheet total alone.

Count eight illustrative PERC flags

Enter eight numeric flags in B2:B9. All zeros sum to 0; setting one to 1 gives 1. A zero count is not a diagnosis, a rule-out statement or a recommendation to skip a test. Missing, text, and non-binary values are rejected.

=IF(COUNT(B2:B9)<>8,"Enter eight numeric flags",IF(SUMPRODUCT((B2:B9<>0)*(B2:B9<>1))>0,"Each flag must be 0 or 1",SUM(B2:B9)))

Add illustrative revised Geneva points

Enter age and heart rate as positive whole numbers in D2:D3 and six preassigned binary factors in D4:D9. For invented values of age 45, heart rate 105, prior DVT/PE flag 1, and palpation-pain-plus-edema flag 1 with the other flags 0, the sum is 5 + 3 + 4 = 12.

The worksheet does not verify clinical findings, distinguish versions of the rules, assign a probability, or give diagnostic or treatment instructions.

=IF(COUNT(D2:D9)<>8,"Enter eight numeric Geneva inputs",IF(OR(D2<=0,D2<>INT(D2),D3<=0,D3<>INT(D3),SUMPRODUCT((D4:D9<>0)*(D4:D9<>1))>0),"Invalid illustrative Geneva inputs",IF(D2>65,1,0)+IF(D3>=95,5,IF(D3>=75,3,0))+3*D4+2*D5+2*D6+3*D7+2*D8+4*D9))

Try the example

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

Further reading