Spreadsheet: 75042d1275564045-linking-cells-with-check-boxes-book2
Sheet: Complaints Table

 |  | TCF Metrics | Show Top 4 Complaints Categories |  |  |  |  |  | Show Complaints Graph
 |  |  | PLEASE TICK THE BOXES ABOVE THE RELEVANT MONTH IF NO COMPLAINTS ARE RECEIVED FOR THAT MONTH.
 |  | Complaint Metrics | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
 |  | Number of all complaints closed | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Number of all complaints closed | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Number of complaints not closed within 24hrs | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Number of complaints not closed within 24hrs | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | % of complaints not closed within 24hrs | 0.3333333333333333 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of complaints not closed within 24hrs | 0.3333333333333333 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Number of compensation payments made on all complaints | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Number of compensation payments made on all complaints | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total value of compensation payments made on all complaints | 2700 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total value of compensation payments made on all complaints | 2700 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | % of cases with a compensation payment from all closed complaints | 0.6666666666666666 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of cases with a compensation payment from all closed complaints | 0.6666666666666666 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | All closed complaints as % of claims received | 0.0075 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | All closed complaints as % of claims received | 0.0075 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of all closed complaints closed within 24hrs | 0.6666666666666666 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of all closed complaints closed within 24hrs | 0.6666666666666666 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Complaint average handling time on all closed complaints | 5 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | Complaint average handling time on all closed complaints | 5 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of all closed complaints that were reopened | 0.6666666666666666 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of all closed complaints that were reopened | 0.6666666666666666 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of complaints reported to Company that were closed within 24hrs | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of complaints reported to Company that were closed within 24hrs | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of complaints reported to Company that were not closed within 24hrs | 0.3333333333333333 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of complaints reported to Company that were not closed within 24hrs | 0.3333333333333333 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A