Book1 |
---|
|
---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y |
---|
1 | Event ID | A/C | Date | Station | Flight No | Type | Delay Minutes | Total Event Delay Minutes | Total Event Average Minutes | Event ID Occurences | Total Active Days of Event | IR Code | | | | Event ID | A/C | Date | Station | Delay Minutes | Total Event Delay Minutes | Total Event Average Minutes | Event ID Occurences | Total Active Days of Event | IR Code |
---|
2 | 207649 | G-EZUK | 02/10/2018 | MAN | EZY1919 | D | 5 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A2),[Date])-INDEX([Date],MATCH(A2,[Event ID],0)) | 41 | 2 | | | 207649 | G-EZUK | 02/10/2018 | MAN | 5 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A2),[Date])-INDEX([Date],MATCH(A2,[Event ID],0)) | 41 |
---|
3 | 210491 | OE-LKJ | 03/10/2018 | MXP | EZY2785 | D | 5 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A3),[Date])-INDEX([Date],MATCH(A3,[Event ID],0)) | 43 | 1 | | | 210491 | OE-LKJ | 03/10/2018 | MXP | 5 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A3),[Date])-INDEX([Date],MATCH(A3,[Event ID],0)) | 43 |
---|
4 | 211359 | G-EZIV | 02/10/2018 | NTE | EZY1708 | D | 10 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A4),[Date])-INDEX([Date],MATCH(A4,[Event ID],0)) | 43 | 1 | | | 211359 | G-EZIV | 02/10/2018 | NTE | 10 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A4),[Date])-INDEX([Date],MATCH(A4,[Event ID],0)) | 43 |
---|
5 | 211680 | OE-IZB | 02/10/2018 | LGW | EZY8113 | D | 10 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A5),[Date])-INDEX([Date],MATCH(A5,[Event ID],0)) | 41 | 2 | | | 211680 | OE-IZB | 01/10/2018 | LGW | 10 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A5),[Date])-INDEX([Date],MATCH(A5,[Event ID],0)) | AOG |
---|
6 | 211680 | OE-IZB | 01/10/2018 | ZRH | EZY8114 | D | 10 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A6),[Date])-INDEX([Date],MATCH(A6,[Event ID],0)) | 41 | 2 | | | 211816 | OE-LKO | 01/10/2018 | SEN | 690 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A8),[Date])-INDEX([Date],MATCH(A8,[Event ID],0)) | AOG |
---|
7 | 211680 | OE-IZB | 03/10/2018 | BFS | EZY842 | D | 10 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A7),[Date])-INDEX([Date],MATCH(A7,[Event ID],0)) | AOG | 3 | | | 211818 | G-EZBC | 01/10/2018 | LGW | 735 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A10),[Date])-INDEX([Date],MATCH(A10,[Event ID],0)) | AOG |
---|
8 | 211816 | OE-LKO | 02/10/2018 | SEN | OOS | D | 690 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A8),[Date])-INDEX([Date],MATCH(A8,[Event ID],0)) | AOG | 3 | | | 211819 | G-EZDA | 01/10/2018 | LGW | 540 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A11),[Date])-INDEX([Date],MATCH(A11,[Event ID],0)) | AOG |
---|
9 | 211816 | OE-LKO | 01/10/2018 | SEN | EZY7381 | D | 0 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A9),[Date])-INDEX([Date],MATCH(A9,[Event ID],0)) | 41 | 2 | | | 211820 | G-EZWJ | 01/10/2018 | LGW | 270 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A14),[Date])-INDEX([Date],MATCH(A14,[Event ID],0)) | AOG |
---|
10 | 211818 | G-EZBC | 01/10/2018 | LGW | | D | 735 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A10),[Date])-INDEX([Date],MATCH(A10,[Event ID],0)) | AOG | 3 | | | 211821 | G-EZAI | 01/10/2018 | TLS | 660 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A16),[Date])-INDEX([Date],MATCH(A16,[Event ID],0)) | AOG |
---|
11 | 211819 | G-EZDA | 01/10/2018 | LGW | OOS | D | 540 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A11),[Date])-INDEX([Date],MATCH(A11,[Event ID],0)) | AOG | 3 | | | 211825 | OE-LQV | 01/08/2018 | LGW | 1080 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A17),[Date])-INDEX([Date],MATCH(A17,[Event ID],0)) | AOG |
---|
12 | 211819 | G-EZDA | 01/10/2018 | LGW | EZY807 | D | 0 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A12),[Date])-INDEX([Date],MATCH(A12,[Event ID],0)) | 41 | 2 | | | 211826 | OE-IVO | 01/10/2018 | BCN | 20 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A21),[Date])-INDEX([Date],MATCH(A21,[Event ID],0)) | 41 |
---|
13 | 211819 | G-EZDA | 01/10/2018 | LGW | EZY865 | D | 0 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A13),[Date])-INDEX([Date],MATCH(A13,[Event ID],0)) | 41 | 2 | | | 211827 | G-EZWC | 01/10/2018 | STR | 144 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A22),[Date])-INDEX([Date],MATCH(A22,[Event ID],0)) | 41 |
---|
14 | 211820 | G-EZWJ | 01/10/2018 | LGW | OOS | D | 270 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A14),[Date])-INDEX([Date],MATCH(A14,[Event ID],0)) | AOG | 3 | | | 211829 | G-EZEY | 01/10/2018 | LGW | 9 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A23),[Date])-INDEX([Date],MATCH(A23,[Event ID],0)) | 41 |
---|
15 | 211820 | G-EZWJ | 01/10/2018 | LGW | EZY8717 | D | 0 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A15),[Date])-INDEX([Date],MATCH(A15,[Event ID],0)) | 41 | 2 | | | 211831 | G-EZAL | 01/10/2018 | LGW | 13 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A24),[Date])-INDEX([Date],MATCH(A24,[Event ID],0)) | 41 |
---|
16 | 211821 | G-EZAI | 01/10/2018 | TLS | | D | 660 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A16),[Date])-INDEX([Date],MATCH(A16,[Event ID],0)) | AOG | 3 | | | 211833 | G-EZGE | 01/10/2018 | SXF | 150 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A25),[Date])-INDEX([Date],MATCH(A25,[Event ID],0)) | LOM |
---|
17 | 211825 | OE-LQV | 01/10/2018 | LGW | OOS | D | 1080 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A17),[Date])-INDEX([Date],MATCH(A17,[Event ID],0)) | AOG | 3 | | | 211834 | OE-LKE | 01/10/2018 | MAN | 4 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A26),[Date])-INDEX([Date],MATCH(A26,[Event ID],0)) | 41 |
---|
18 | 211825 | OE-LQV | 01/08/2018 | LGW | OOS | D | 0 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A18),[Date])-INDEX([Date],MATCH(A18,[Event ID],0)) | AOG | 3 | | | 211837 | G-EZAI | 01/10/2018 | LIL | 8 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A27),[Date])-INDEX([Date],MATCH(A27,[Event ID],0)) | 41 |
---|
19 | 211825 | OE-LQV | 02/10/2018 | LGW | AOG | D | 1080 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A19),[Date])-INDEX([Date],MATCH(A19,[Event ID],0)) | AOG | 3 | | | 211840 | G-EZDD | 01/10/2018 | LGW | 255 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A28),[Date])-INDEX([Date],MATCH(A28,[Event ID],0)) | DAM2 |
---|
20 | 211825 | OE-LQV | 03/10/2018 | LGW | OOS | D | 1080 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A20),[Date])-INDEX([Date],MATCH(A20,[Event ID],0)) | AOG | 3 | | | 211843 | OE-ICF | 01/09/2018 | OPO | 300 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A30),[Date])-INDEX([Date],MATCH(A30,[Event ID],0)) | DAM2 |
---|
21 | 211826 | OE-IVO | 01/10/2018 | BCN | EZY1076 | D | 20 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A21),[Date])-INDEX([Date],MATCH(A21,[Event ID],0)) | 41 | 2 | | | 211844 | OE-LKG | 01/10/2018 | PMI | 810 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A32),[Date])-INDEX([Date],MATCH(A32,[Event ID],0)) | DAM1 |
---|
22 | 211827 | G-EZWC | 01/10/2018 | STR | ` | D | 144 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A22),[Date])-INDEX([Date],MATCH(A22,[Event ID],0)) | 41 | 2 | | | 211848 | OE-INE | 01/10/2018 | ATH | 48 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A33),[Date])-INDEX([Date],MATCH(A33,[Event ID],0)) | 41 |
---|
23 | 211829 | G-EZEY | 01/10/2018 | LGW | EZY8869 | D | 9 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A23),[Date])-INDEX([Date],MATCH(A23,[Event ID],0)) | 41 | 2 | | | 211851 | G-EZGF | 01/10/2018 | LGW | 9 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A34),[Date])-INDEX([Date],MATCH(A34,[Event ID],0)) | 41 |
---|
24 | 211831 | G-EZAL | 01/10/2018 | LGW | EZY8243 | D | 13 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A24),[Date])-INDEX([Date],MATCH(A24,[Event ID],0)) | 41 | 2 | | | 211854 | OE-ICW | 01/10/2018 | BRS | 12 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A35),[Date])-INDEX([Date],MATCH(A35,[Event ID],0)) | 43 |
---|
25 | 211833 | G-EZGE | 01/10/2018 | SXF | OOS | D | 150 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A25),[Date])-INDEX([Date],MATCH(A25,[Event ID],0)) | LOM | 6 | | | 211855 | OE-LQI | 01/10/2018 | TLS | 840 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A36),[Date])-INDEX([Date],MATCH(A36,[Event ID],0)) | AOG |
---|
26 | 211834 | OE-LKE | 01/10/2018 | MAN | EZY1985 | D | 4 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A26),[Date])-INDEX([Date],MATCH(A26,[Event ID],0)) | 41 | 2 | | | | | | | | | | | | |
---|
27 | 211837 | G-EZAI | 01/10/2018 | LIL | EZY1702 | D | 8 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A27),[Date])-INDEX([Date],MATCH(A27,[Event ID],0)) | 41 | 2 | | | | | | | | | | | | |
---|
28 | 211840 | G-EZDD | 01/10/2018 | LGW | OOS | D | 255 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A28),[Date])-INDEX([Date],MATCH(A28,[Event ID],0)) | DAM2 | 5 | | | | | | | | | | | | |
---|
29 | 211840 | G-EZDD | 01/10/2018 | LGW | EZY8981 | D | 0 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A29),[Date])-INDEX([Date],MATCH(A29,[Event ID],0)) | 41 | 2 | | | | | | | | | | | | |
---|
30 | 211843 | OE-ICF | 01/09/2018 | OPO | OOS | D | 300 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A30),[Date])-INDEX([Date],MATCH(A30,[Event ID],0)) | DAM2 | 5 | | | | | | | | | | | | |
---|
31 | 211843 | OE-ICF | 01/10/2018 | OPO | EZY3772 | D | 0 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A31),[Date])-INDEX([Date],MATCH(A31,[Event ID],0)) | 52 | 0 | | | | | | | | | | | | |
---|
32 | 211844 | OE-LKG | 01/10/2018 | PMI | OOS | D | 810 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A32),[Date])-INDEX([Date],MATCH(A32,[Event ID],0)) | DAM1 | 4 | | | | | | | | | | | | |
---|
33 | 211848 | OE-INE | 01/10/2018 | ATH | EZY6062 | D | 48 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A33),[Date])-INDEX([Date],MATCH(A33,[Event ID],0)) | 41 | 2 | | | | | | | | | | | | |
---|
34 | 211851 | G-EZGF | 01/10/2018 | LGW | EZY8189 | D | 9 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A34),[Date])-INDEX([Date],MATCH(A34,[Event ID],0)) | 41 | 2 | | | | | | | | | | | | |
---|
35 | 211854 | OE-ICW | 01/10/2018 | BRS | EZY443 | D | 12 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A35),[Date])-INDEX([Date],MATCH(A35,[Event ID],0)) | 43 | 1 | | | | | | | | | | | | |
---|
36 | 211855 | OE-LQI | 01/10/2018 | TLS | OOS | D | 840 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A36),[Date])-INDEX([Date],MATCH(A36,[Event ID],0)) | AOG | 3 | | | | | | | | | | | | |
---|
37 | 211855 | OE-LQI | 02/10/2018 | TLS | OOS | D | 540 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A37),[Date])-INDEX([Date],MATCH(A37,[Event ID],0)) | AOG | 3 | | | | | | | | | | | | |
---|
38 | 211855 | OE-LQI | 02/10/2018 | TLS | EZY1474 | D | 0 | =SUMIFS($G:$G,$A:$A,[@[Event ID]])+(360*[@[Total Active Days of Event]])*(AND(COUNTIFS($A:$A,[@[Event ID]],G:G,">"&60),SUM(COUNTIFS($A:$A,[@[Event ID]],L:L,{"AOG","AOG4","DAM1","DAM2"})))) | =[@[Total Event Delay Minutes]]/[@[Event ID Occurences]] | =COUNTIF(A:A,[@[Event ID]]) | =LOOKUP(2,1/([Event ID]=A38),[Date])-INDEX([Date],MATCH(A38,[Event ID],0)) | 41 | 2 | | | | | | | | | | | | |
---|
|
---|