Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculators

BVAS v3 and Capped Sums: A Spreadsheet Illustration

Learn how a per-group cap works in a fictional spreadsheet example, and why a partial sum is not a Birmingham Vasculitis Activity Score or a remission assessment.

How BVAS v3 uses weighted items and organ systems

The Birmingham Vasculitis Activity Score version 3 is a clinical research instrument with 56 weighted items across nine organ systems. A trained assessor records features attributable to active vasculitis, applies the appropriate new/worse or persistent weighting, and limits the contribution from each system according to the instrument. The full score may range up to 63 for new/worse disease or 33 for persistent-only activity.

A complete assessment requires all applicable systems and the official scoring instructions. BVAS-based remission definitions in clinical trials may include additional conditions: one FDA-reviewed trial also required a period without glucocorticoids. A subtotal or a few missing inputs cannot establish remission, disease severity, or treatment decisions.

Fictional groupHypothetical capRaw amountCapped amount
A353
B686
C944
Three-group arithmetic subtotal——13

Illustrate a capped subtotal using MIN

This example uses three abstract groups and invented inputs solely to demonstrate spreadsheet arithmetic; it is not a BVAS calculator or an organ assessment. For each group, MIN(cap, raw amount) limits that group’s contribution.

Enter a nonnegative integer for every cap and raw amount. Missing or invalid inputs return a message rather than an apparently meaningful subtotal. Use the complete official instrument and its training materials for any research or clinical assessment.

=IF(COUNT(B2:C4)<>6,"Enter all six numeric values",IF(OR(MIN(B2:C4)<0,MOD(B2,1)<>0,MOD(C2,1)<>0,MOD(B3,1)<>0,MOD(C3,1)<>0,MOD(B4,1)<>0,MOD(C4,1)<>0),"Use nonnegative integers",MIN(B2,C2)+MIN(B3,C3)+MIN(B4,C4)))

Try the example

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

Further reading