Spreadsheet: 711279d1609588727-countif-with-data-validation-workbook
Sheet: Interruptions

 |  |  |  |  | 2020-12-01 00:00:00 |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
 | DECEMBER |  |  |  | INTERRUPTION COUNT |  |  |  |  |  |  |  |  | NO OF HRS LOST DUE TO
 | NAME OF [NAME] | STATUS | MAX. LOAD | AVER. LOAD | EF | OC | IMB | EMG | LS | LSG | SG | NS | TOTAL | EF | OC | IMB | EMG | LS | LSG | SG | NS | TOTAL
 | IGI | ACTIVE | 14.3 | 10.86666666666667 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 15
 | AGMA | ACTIVE | 14.4 | 10.71428571428571 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 4
 | OLO | ACTIVE | 11.2 | 10.5 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 10
 | ASA | ACTIVE | 1.8 | 1.6 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0
 | TBO | ACTIVE | 1.7 | 1.246666666666666 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0
 | [NAME] | ACTIVE | 1.7 | 1.125 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0
 | GIN | ACTIVE | 0 | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 24
 | TOTAL |  | 45.10000000000001 | 36.05261904761905 |  |  |  |  |  |  |  |  |  | 6 | 0 | 0 | 24 | 23 | 0 | 0 | 0 | 53
 | ANEMA | ACTIVE | 1.1 | 1.05 |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BMA | ACTIVE | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ISPO | ACTIVE | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 24
 | AHA | ACTIVE | 9.4 | 7.431818181818183 |  |  |  |  |  |  |  |  | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6
 | EUA | ACTIVE | 10.7 | 7.653333333333334 |  |  |  |  |  |  |  |  | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 9
 | TOTAL |  | 21.2 | 16.13515151515152 |  |  |  |  |  |  |  |  | 0 | 6 | 9 | 0 | 0 | 0 | 0 | 0 | 24 | 39
 | EZ1 | ACTIVE | 18 | 6.0625 |  |  |  |  |  |  |  |  | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8
 | AKA | ACTIVE | 4.4 | 1.588235294117647 |  |  |  |  |  |  |  |  | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 7
 | EP2 | ACTIVE | 9.6 | 5.64736842105263 |  |  |  |  |  |  |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | FLL | ACTIVE | 9.4 | 6.869444444444444 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SNG | ACTIVE | 18 | 6.0625 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | NLS | ACTIVE | 1.7 | 0.8416666666666668 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | UEM | ACTIVE | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | DLS | ACTIVE | 4.5 | 1.920833333333334 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | WRD | ACTIVE | 1 | 0.7374999999999999 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AMA | ACTIVE | 15 | 7.972727272727272 |  |  |  |  |  |  |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | TOTAL |  | 81.6 | 37.70277543234199 |  |  |  |  |  |  |  |  |  | 0 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 19
 | IDI | ACTIVE | 2.5 | 1.604545454545455 |  |  |  |  |  |  |  |  | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | YHE | ACTIVE | 1.9 | 1.275 |  |  |  |  |  |  |  |  | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8
 | KATSINA ALA | ACTIVE |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL |  | 4.4 | 2.879545454545455 |  |  |  |  |  |  |  |  | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10
 | ITRIAL | INACTIVE |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0
 | AUDIENANCE | INACTIVE |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0
 | STADIUM | INACTIVE |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0
 | NNG | ACTIVE | 1.26 | 1.02 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RLA | ACTIVE | 14.9 | 11.65238095238095 |  |  |  |  |  |  |  |  | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 | RF2 | ACTIVE | 13.05 | 8.327499999999999 |  |  |  |  |  |  |  |  | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 4
 | ROW | ACTIVE | 13.2 | 9.113157894736839 |  |  |  |  |  |  |  |  | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5
 | ECL | ACTIVE | 0.2 | 0.2000000000000001 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ANI | ACTIVE | 14 | 9.591666666666669 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TDI | ACTIVE | 14.95 | 12.94473684210526 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 5
 | TOTAL |  | 71.56 | 52.84944235588973 |  |  |  |  |  |  |  |  | 0 | 7 | 5 | 0 | 0 | 0 | 0 | 5 | 0 | 17
 | ABA | ACTIVE | 10.5 | 5.404166666666666 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RB1 | ACTIVE | 9.4 | 6.842499999999999 |  |  |  |  |  |  |  |  | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4
 | SAT | ACTIVE | 11.6 | 6.273913043478259 |  |  |  |  |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 | BOI | ACTIVE | 8.4 | 4.147222222222222 |  |  |  |  |  |  |  |  | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6
 | TOTAL |  | 39.9 | 22.66780193236715 |  |  |  |  |  |  |  |  | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11
 | ONE | ACTIVE | 9.7 | 8.28125 |  |  |  |  |  |  |  |  | 0 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 16
 | NKI | ACTIVE | 2.5695 | 1.992791666666667 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | KMK | ACTIVE | 18.2 | 10.21136363636363 |  |  |  |  |  |  |  |  | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | TER | ACTIVE | 8.7 | 5.252272727272727 |  |  |  |  |  |  |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2
 | OYO | ACTIVE | 8.5 | 3.715909090909092 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2
 | TOTAL |  | 47.6695 | 29.45358712121212 |  |  |  |  |  |  |  |  | 0 | 2 | 18 | 0 | 0 | 0 | 0 | 2 | 0 | 22
 | RTV | ACTIVE | 9 | 4 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BRI | ACTIVE | 5 | 4.038235294117647 |  |  |  |  |  |  |  |  | 0 | 3 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 7
 | IGE | ACTIVE | 13 | 9.861111111111112 |  |  |  |  |  |  |  |  | 0 | 2 | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 6
 | RYA | ACTIVE | 21.75 | 15.95714285714286 |  |  |  |  |  |  |  |  | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 | TOTAL |  | 48.75 | 33.85648926237162 |  |  |  |  |  |  |  |  | 0 | 6 | 7 | 0 | 3 | 0 | 0 | 0 | 0 | 16
 | NTA | ACTIVE | 13.6 | 10.40714285714286 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 17 | 0 | 0 | 0 | 17
 | ROM | ACTIVE | 8 | 8.1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | UST | ACTIVE | 16.7 | 11.45416666666667 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SID | ACTIVE | 10.8 | 5.152380952380953 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RNI | ACTIVE | 12.6 | 7.877083333333335 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | UTC | ACTIVE | 6.8 | 4.222916666666666 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | T1B | ACTIVE | 10.9 | 6.772916666666668 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL |  | 79.4 | 53.98660714285715 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 17 | 0 | 0 | 0 | 17
 | ART | ACTIVE | 17.85 | 14.28214285714286 |  |  |  |  |  |  |  |  | 0 | 0 | 2 | 0 | 8 | 0 | 0 | 0 | 0 | 10
 | RF1 | ACTIVE | 7.5 | 6.141666666666667 |  |  |  |  |  |  |  |  | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12
 | UTH | ACTIVE | 12.5 | 11.11666666666667 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 15 | 0 | 0 | 0 | 15
 | RWU | ACTIVE | 12.7 | 9.6375 |  |  |  |  |  |  |  |  | 0 | 3 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 8
 | GPH | ACTIVE | 3.8 | 3.6 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2
 | TOTAL |  | 54.34999999999999 | 44.77797619047619 |  |  |  |  |  |  |  |  | 0 | 15 | 2 | 0 | 8 | 20 | 0 | 2 | 0 | 47
 | IAM | ACTIVE | 2.5 | 1.804545454545455 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2
 | CES | ACTIVE | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 | LAN | ACTIVE | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | FNE | ACTIVE | 15 | 8.916666666666666 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | IPO | ACTIVE | 13 | 6.333333333333333 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | OAD | ACTIVE | 6 | 2.125 |  |  |  |  |  |  |  |  | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8
 | ABE | ACTIVE | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24
 | TOTAL |  | 38.5 | 21.17954545454545 |  |  |  |  |  |  |  |  | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 13
 | OUU | ACTIVE | 0.8 | 0.661111111111111 |  |  |  |  |  |  |  |  | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 2 | 14
 | BAK | ACTIVE | 73 | 15.55555555555556 |  |  |  |  |  |  |  |  | 0 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15
 | KNE | ACTIVE | 9 | 4.470588235294118 |  |  |  |  |  |  |  |  | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
 | ORA | ACTIVE | 8 | 6.428571428571429 |  |  |  |  |  |  |  |  | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16
 | TOTAL |  | 90.8 | 27.11582633053222 |  |  |  |  |  |  |  |  | 0 | 38 | 12 | 0 | 0 | 0 | 0 | 0 | 2 | 52
 | EKT | ACTIVE | 9 | 5.131578947368421 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ETN | ACTIVE | 4.5 | 4.125 |  |  |  |  |  |  |  |  | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10
 | EKPA | ACTIVE | 5 | 1.875 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | MBO | ACTIVE | 6 | 5.333333333333333 |  |  |  |  |  |  |  |  | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7
 | ONA | ACTIVE | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ITRIAL | ACTIVE | 0.7 | 0.5729166666666666 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ISI | ACTIVE | 0 | 0 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | EKM | ACTIVE | 5.7 | 4.983333333333333 |  |  |  |  |  |  |  |  | 0 | 0 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 18