Arte SheetsLearn. Try. Understand.

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 totalArithmetic interpretation
0All 14 item scores are 0
35Sum of the 14 example item scores
56All 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.

Further reading