Spreadsheet: 36572d1234453394-more-than-7-if-excel-example
Sheet: input data 

TEAM STATS 2009 | JAN |  |  |  | FEB |  |  |  | MAR |  |  |  | APR |  |  |  | MAY |  |  |  | JUN |  |  |  | JUL |  |  |  | AUG |  |  |  | SEP |  |  |  | OCT |  |  |  | NOV |  |  |  | DEC |  |  |  | Total for Year
 | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads | Average calls | Average Availability | Number Calls | CCT leads
Persons name 1 | 58 | 0.83 | 101 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 | 0.83 | 101 | 1
Persons name 2 | 40 | 0.87 | 39 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 0.87 | 39 | 0
Persons name 3 | 26 | 0.84 | 15 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 0.84 | 15 | 0
Persons name 4 | 89 | 0.91 | 8 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89 | 0.91 | 8 | 0
Persons name 5 | 35 | 0.88 | 576 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 0.88 | 576 | 6
Persons name 6 | 39 | 0.8 | 331 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 0.8 | 331 | 2
Persons name 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - | - | 0 | 0
Persons name 8 | 38 | 0.89 | 641 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 0.89 | 641 | 0
Persons name 9 | 45 | 0.82 | 433 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 0.82 | 433 | 19
Persons name 10 | 38 | 0.92 | 567 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 0.92 | 567 | 4
Persons name 11 | 37 | 0.87 | 264 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | 0.87 | 264 | 2
TOTAL | 44.5 | 0.8629999999999999 | 2975 | 34 | - | - | 0 | 0 | - | - | 0 | 0 | - | - | 0 | 0 | - | - | 0 | 0 | - | - | 0 | 0 | - | - | 0 | 0 | - | - | 0 | 0 | - | - | 0 | 0 | - | - | 0 | 0 | - | - | 0 | 0 | - | - | 0 | 0 | 44.5 | 0.8629999999999999 | 2975 | 34
 | Coaching |  |  |  | Coaching |  |  |  | Coaching |  |  |  | Coaching |  |  |  | Coaching |  |  |  | Coaching |  |  |  | Coaching |  |  |  | Coaching |  |  |  | Coaching |  |  |  | Coaching |  |  |  | Coaching |  |  |  | Coaching |  |  |  | Coaching
 | CALL 1 | CALL 2 | CALL 3 | Average % | CALL 1 | CALL 2 | CALL 3 | Average % | CALL 1 | CALL 2 | CALL 3 | Average % | CALL 1 | CALL 2 | CALL 3 | Average % | CALL 1 | CALL 2 | CALL 3 | Average % | CALL 1 | CALL 2 | CALL 3 | Average % | CALL 1 | CALL 2 | CALL 3 | Average % | CALL 1 | CALL 2 | CALL 3 | Average % | CALL 1 | CALL 2 | CALL 3 | Average % | CALL 1 | CALL 2 | CALL 3 | Average % | CALL 1 | CALL 2 | CALL 3 | Average % | CALL 1 | CALL 2 | CALL 3 | Average % |  | CALL 1 | CALL 2 | CALL 3 | Average %
Persons name 1 | P | P | P | 1 | P |  |  | 0.74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB | P | 0 | 0 | 0.74
Persons name 2 | P | P | P | 1 | P |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB | P | 0 | 0 | 1
Persons name 3 | P | P | P | 1 | P |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB | P | 0 | 0 | 1
Persons name 4 | P | P | P | 1 | P |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB | P | 0 | 0 | 1
Persons name 5 | P | P | P | 0.98 | P |  |  | 0.78 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB | P | 0 | 0 | 0.78
Persons name 6 | P | P | C4 | 0.75 | P |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB | P | 0 | 0 | 1
Persons name 7 | P | P | P | 1 | P |  |  | 0.89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB | P | 0 | 0 | 0.89
Persons name 8 | P | P | P | 0.98 | P |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB | P | 0 | 0 | 1
Persons name 9 | P | P | P | 0.85 | A2 |  |  | 0.89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB | A2 | 0 | 0 | 0.89
Persons name 10 | P | C1 | P | 0.87 | A1 |  |  | 0.87 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB | A1 | 0 | 0 | 0.87
Persons name 11 | P | P | P | 1 | P |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB | P | 0 | 0 | 1
AVERAGE |  |  |  | 0.9481818181818181 |  |  |  | 0.9245454545454546 |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  | - |  |  |  |  | 0.9245454545454546
 | Coaching Error Types
 | Legislation Error
 | A1 | NO DPA CHECK
 | A2 | INSUFFICIENT NUMBER OF DPA CHECKS
 | A3 | DATA GIVEN TO UNAUTHORISED PERSON
 | B1 | ADVICE GIVEN TO CALLER
 | B2 | [NAME] CALLER
 | B3 | INCORRECT REPORTING PROCEDURE
 | [NAME]
 | C1 | INACCURATE RESPONSE
 | D1 | OPTIONS NOT GIVEN
 | E1 | N2 NOT IDENTIFIED AND RESOLVED
 | E2 | N2 NOT LOGGED
 | E3 | CALLER NOT OFFERED VERBAL COMPLAINT OPTION
 | F2 | AGREED REQUEST NOT ACTIONED
 | [NAME] | SURRENDER VALUE WORDING NOT GIVEN FULLY/CORRECTLY
 | G2 | CURRENT VALUE WORDING NOT GIVEN
 | G3 | COMPLAINT WORDING NOT GIVEN
 | G4 | EMV WORDING NOT GIVEN
 | G5 | MANDATORY CCT WORDINGS NOT GIVEN
 | JAN
 | FEB
 | MAR
 | APR
 | MAY
 | JUN
 | JUL
 | AUG
 | SEP
 | OCT
 | NOV
 | DEC