Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculators

OABSS: Adding Four Symptom Subscores in a Spreadsheet

Add pre-scored items for the Overactive Bladder Symptom Score and understand why symptom thresholds alone do not establish a diagnosis.

A symptom score is one part of assessment

Homma and colleagues developed the Overactive Bladder Symptom Score (OABSS) as a four-domain measure of urinary symptoms. The item maxima are 2, 3, 5 and 5 points, for a possible total from 0 to 15. This example adds numbers already scored; it does not reproduce the questionnaire. Consult the original authors or rights holders about appropriate use of the instrument.

Japanese clinical guidance has used an urgency-item score of at least 2 together with a total of at least 3 as one set of criteria. Those values do not replace a clinical diagnosis or rule out other causes. The AUA/SUFU guidance describes clinical history, examination and urinalysis as part of initial evaluation. Symptoms can still merit evaluation when a particular score threshold is not met.

Add the four pre-scored items

Enter whole-number subscores in B2:B5 within the individual ranges shown. A blank is not the same as a score of zero. The example 1 + 2 + 4 + 2 gives 9 points.

=IF(OR(COUNT(B2:B5)<>4,AND(B2<>0,B2<>1,B2<>2),AND(B3<>0,B3<>1,B3<>2,B3<>3),AND(B4<>0,B4<>1,B4<>2,B4<>3,B4<>4,B4<>5),AND(B5<>0,B5<>1,B5<>2,B5<>3,B5<>4,B5<>5)),"Invalid or missing item scores",SUM(B2:B5))

Compare against published symptom thresholds

This illustration checks whether the urgency subscore B4 is at least 2 and the total is at least 3. The label refers only to those numerical criteria; it does not diagnose or exclude a condition.

=IF(E2="Invalid or missing item scores","Invalid or missing item scores",IF(AND(B4>=2,E2>=3),"Published thresholds met","Published thresholds not met"))

Try the example

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

Further reading