Google sheet:
Explore more of smarthelping’s models:

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.