Spreadsheet: 818975d1677152606-standardized-scoring-calculation-standardised-scoring-system
Sheet: Scoring Data

 |  |  |  |  |  |  |  |  |  |  | Account_Name | 0.5 |  | 1 |  | 2 |  | 3 |  | 3.5 |  | 5 |  | Score Type
Rep | Client | 2022 - Qtr1 | 2022 - Qtr2 | 2022 - Qtr3 | 2022 - Qtr4 | Total Raw Score | Standardised score |  |  |  | Company 1 |  |  | 1 | 2 | 2.01 | 4 | 4.01 | 6 | 6.01 |  |  |  | Mentions
Rep 1 | Company 1 | 1 |  | 1 |  | 2 |  |  |  |  | Company 2 |  |  | 1 | 5.1 | 5.11 | 10.1 | 10.11 | 15.1 | 15.11 |  |  |  | Score
Rep 2 | Company 1 | 4 |  | 4 |  | 8 |  |  |  |  | Company 3 | 0.1 | 0.99 | 1 | 3 | 3.01 | 6 | 6.01 | 9 | 9.01 | 12 | 12.01 |  | Score
Rep 3 | Company 1 |  |  | 1 |  | 1
Rep 4 | Company 1 | 2 |  | 1 |  | 3
Rep 5 | Company 1 | 3 |  | 3 |  | 6
Rep 6 | Company 1 |  |  | 1 |  | 1
Rep 7 | Company 1 | 4 |  | 3 |  | 7
Rep 8 | Company 1 | 4 |  | 4 |  | 8
Rep 9 | Company 1 | 1 |  | 1 |  | 2
Rep 10 | Company 1 | 2 |  | 1 |  | 3
Rep 11 | Company 1 | 1 |  | 1 |  | 2
Rep 12 | Company 1 |  |  | 1 |  | 1
Rep 13 | Company 1 | 2 |  | 1 |  | 3
Rep 14 | Company 1 | 3 |  | 4 |  | 7
Rep 15 | Company 1 | 1 |  | 1 |  | 2
Rep 16 | Company 1 | 1 |  |  |  | 1
Rep 17 | Company 1 |  |  | 1 |  | 1
Rep 18 | Company 1 | 1 |  |  |  | 1
Rep 19 | Company 1 |  |  | 1 |  | 1
Rep 20 | Company 1 | 1 |  |  |  | 1
Rep 21 | Company 1 | 1 |  | 1 |  | 2
Rep 22 | Company 1 | 1 |  | 1 |  | 2
Rep 23 | Company 1 | 1 |  | 1 |  | 2
Rep 24 | Company 1 | 1 |  | 1 |  | 2
Rep 25 | Company 1 | 3 |  | 2 |  | 5
Rep 26 | Company 1 | 3 |  | 3 |  | 6
Rep 27 | Company 1 | 3 |  | 4 |  | 7
Rep 28 | Company 1 | 1 |  |  |  | 1
Rep 29 | Company 1 |  |  | 1 |  | 1
Rep 30 | Company 1 | 3 |  | 4 |  | 7
Rep 31 | Company 1 | 1 |  | 1 |  | 2
Rep 32 | Company 1 | 2 |  | 2 |  | 4
Rep 33 | Company 1 | 2 |  | 2 |  | 4
Rep 34 | Company 1 | 3 |  | 4 |  | 7
Rep 35 | Company 1 | 1 |  | 1 |  | 2
Rep 36 | Company 1 | 1 |  | 2 |  | 3
Rep 37 | Company 1 | 1 |  | 1 |  | 2
Rep 38 | Company 1 | 1 |  |  |  | 1
Rep 3 | Company 2 | 1 | 1 | 1 |  | 3
Rep 55 | Company 2 | 1 | 1 |  |  | 2
Rep 4 | Company 2 | 2 | 2 | 2 |  | 6
Rep 5 | Company 2 | 2 | 2 | 2 |  | 6
Rep 56 | Company 2 | 1 | 1 | 1 |  | 3
Rep 7 | Company 2 | 2 | 2 | 2 |  | 6
Rep 40 | Company 2 |  | 1 |  |  | 1
Rep 8 | Company 2 | 2 | 2 | 2 |  | 6
Rep 9 | Company 2 |  | 1 | 1 |  | 2
Rep 11 | Company 2 | 1 |  |  |  | 1
Rep 12 | Company 2 | 1 | 1 |  |  | 2
Rep 13 | Company 2 | 1 | 1 | 1 |  | 3
Rep 57 | Company 2 | 1 | 1 | 1 |  | 3
Rep 15 | Company 2 | 1 | 1 | 1 |  | 3
Rep 44 | Company 2 | 1 | 1 |  |  | 2
Rep 19 | Company 2 |  |  | 1 |  | 1
Rep 21 | Company 2 | 2 | 2 | 2 |  | 6
Rep 22 | Company 2 | 1 | 1 |  |  | 2
Rep 58 | Company 2 | 1 | 1 | 1 |  | 3
Rep 47 | Company 2 | 1 | 1 | 1 |  | 3
Rep 25 | Company 2 | 2 | 2 | 2 |  | 6
Rep 26 | Company 2 | 1 |  |  |  | 1
Rep 27 | Company 2 | 1 | 1 | 1 |  | 3
Rep 59 | Company 2 |  | 1 | 1 |  | 2
Rep 29 | Company 2 | 1 | 1 | 1 |  | 3
Rep 60 | Company 2 |  | 1 |  |  | 1
Rep 52 | Company 2 | 1 | 1 | 1 |  | 3
Rep 30 | Company 2 | 2 | 1 | 1 |  | 4
Rep 31 | Company 2 | 1 | 1 | 1 |  | 3
Rep 32 | Company 2 |  |  | 1 |  | 1
Rep 34 | Company 2 | 1 | 1 | 1 |  | 3
Rep 61 | Company 2 | 1 | 1 | 1 |  | 3
Rep 62 | Company 2 | 1 | 1 | 1 |  | 3
Rep 38 | Company 2 | 1 |  | 1 |  | 2
Rep 63 | Company 2 | 1 | 1 | 1 |  | 3
Rep 3 | Company 3 | 3 |  | 3 |  | 6
Rep 4 | Company 3 | 4 |  | 4 |  | 8
Rep 5 | Company 3 |  |  | 4 |  | 4
Rep 7 | Company 3 |  |  | 4 |  | 4
Rep 40 | Company 3 |  |  | 2 |  | 2
Rep 8 | Company 3 | 4 |  | 3 |  | 7
Rep 11 | Company 3 | 4 |  | 3 |  | 7
Rep 43 | Company 3 | 4 |  |  |  | 4
Rep 13 | Company 3 |  |  | 4 |  | 4
Rep 57 | Company 3 |  |  | 4 |  | 4
Rep 15 | Company 3 | 5 |  |  |  | 5
Rep 44 | Company 3 | 1 |  | 2 |  | 3
Rep 21 | Company 3 |  |  | 4 |  | 4
Rep 47 | Company 3 | 4 |  | 3 |  | 7
Rep 25 | Company 3 | 4 |  | 4 |  | 8
Rep 26 | Company 3 |  |  | 4 |  | 4
Rep 64 | Company 3 | 5 |  |  |  | 5
Rep 60 | Company 3 |  |  | 3 |  | 3
Rep 65 | Company 3 | 3 |  |  |  | 3
Rep 30 | Company 3 | 5 |  | 4 |  | 9
Rep 31 | Company 3 | 3 |  | 3 |  | 6
Rep 34 | Company 3 | 4 |  | 5 |  | 9
Rep 35 | Company 3 |  |  | 2 |  | 2
Rep 66 | Company 3 |  |  | 3 |  | 3
Rep 38 | Company 3 |  |  | 3 |  | 3