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 group | Hypothetical cap | Raw amount | Capped amount |
|---|---|---|---|
| A | 3 | 5 | 3 |
| B | 6 | 8 | 6 |
| C | 9 | 4 | 4 |
| 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.