Example of Dynamic Data Assessment Spreadsheet
Enter scores (1-5) to calculate weighted average • Max: 310 pts • Scaled to 5-point system
| Criteria | Weight | L1 | L2 | L3 | L4 | L5 | W | Max | Score | Critical | High |
|---|---|---|---|---|---|---|---|---|---|---|---|
| WEIGHTED AVG | Min((∑Scores×Weights)/310×5, Critical Avg, High Avg) = 3.00 | 3.00 | 3.00 | ||||||||
Calculation
Formula: Min(Weighted Avg, Critical Avg, High Avg)
Max: 310 points
Scale: 0-5 points
Score Guide
5:Exceptional
4:Strong
3:Satisfactory
2:Limited
1:Emerging
3.00
Satisfactory