Weighted Average Scoring Algorithm in Google Sheets

Google sheet: https://docs.google.com/spreadsheets/d/1y24Rb4JMqBgwv1Nn77jPymwUBPiZDe8n_yMhcmzyQ6k/edit#gid=0
Explore more of smarthelping’s models: http://www.smarthelping.com/p/excel.html

This is a free template download for use by anyone. It shows the logic and thought process behind how you might setup a way to score various things. This specific one was built to give salesmen a grade from A to F based on their weighted average scores for various performance metrics. This allows certain metrics to have more weight in the final score than others.

Twitter: https://twitter.com/smarthelping