Healthcare & Clinical Formulas
Berg Balance Scale: Summing 14 Items in a Spreadsheet
Sum fourteen fictional Berg Balance Scale item scores with checks for completeness and valid integers, and understand why the total is not a stand-alone mobility decision.
Fourteen scored balance tasks
The Berg Balance Scale contains 14 functional balance tasks, each rated from 0 to 4. A complete total ranges from 0 to 56. The individual tasks have their own scoring criteria and should be assessed using the original instrument by a suitably trained professional.
Berg and colleagues studied balance and falls in older adults and functional performance after stroke. Some studies use a total below 45 as a marker of greater fall risk, but cutoffs and predictive performance vary by population and setting. A score of 45 or higher does not guarantee safety or independent walking, and the total alone cannot prescribe a wheelchair, walking aid, or discharge.
| Fictional 14-item total | Arithmetic interpretation |
|---|---|
| 0 | All 14 item scores are 0 |
| 35 | Sum of the 14 example item scores |
| 56 | All 14 item scores are 4 |
Validate and sum complete item scores
Enter one numeric integer from 0 to 4 for every item. Text, blanks, fractions and values outside the permitted range are rejected. This spreadsheet illustrates adding already scored values and is not a substitute for administering the balance assessment.
A change in total should be interpreted in the context of the person, measurement uncertainty and the population; one universal change value does not verify motor recovery.
=IF(COUNT(B2:B15)<>14,"Enter all 14 numeric scores",IF(OR(MIN(B2:B15)<0,MAX(B2:B15)>4,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0,MOD(B6,1)<>0,MOD(B7,1)<>0,MOD(B8,1)<>0,MOD(B9,1)<>0,MOD(B10,1)<>0,MOD(B11,1)<>0,MOD(B12,1)<>0,MOD(B13,1)<>0,MOD(B14,1)<>0,MOD(B15,1)<>0),"Each score must be an integer from 0 to 4",SUM(B2:B15)))Try the example
Use the original values or change them to test your understanding.