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.