Spreadsheet: 109420d1306279271-pivot-table-calcualted-formula-fltstatus
Sheet: Sheet1

DAY_OF_MONTH | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_ABR | Status
1 | [NAME] | New York, NY | NY | On Time |  |  | ORIGIN_STATE_ABR | CA
2 | [NAME] | New York, NY | NY | On Time
3 | [NAME] | New York, NY | NY | Early |  |  | Count of Status | Column Labels
4 | [NAME] | New York, NY | NY | Early |  |  | Row Labels | Early | Late | On Time | Grand Total
5 | [NAME] | New York, NY | NY | Early |  |  | 1 | 0.5 | 0.3333333333333333 | 0.1666666666666667 | 1
6 | [NAME] | New York, NY | NY | Early |  |  | 2 | 0.5714285714285714 | 0.1428571428571428 | 0.2857142857142857 | 1
7 | [NAME] | New York, NY | NY | Early |  |  | 3 | 0.2857142857142857 | 0.1428571428571428 | 0.5714285714285714 | 1
8 | [NAME] | New York, NY | NY | Early |  |  | 4 | 0 | 0.5 | 0.5 | 1
9 | [NAME] | New York, NY | NY | Late |  |  | 5 | 0.3333333333333333 | 0.3333333333333333 | 0.3333333333333333 | 1
10 | [NAME] | New York, NY | NY | On Time |  |  | 6 | 0.1428571428571428 | 0.2857142857142857 | 0.5714285714285714 | 1
11 | [NAME] | New York, NY | NY | Early |  |  | 7 | 0.2857142857142857 | 0.2857142857142857 | 0.4285714285714285 | 1
12 | [NAME] | New York, NY | NY | Early |  |  | 8 | 0.5714285714285714 | 0.1428571428571428 | 0.2857142857142857 | 1
13 | [NAME] | New York, NY | NY | Early |  |  | 9 | 0.4285714285714285 | 0.4285714285714285 | 0.1428571428571428 | 1
14 | [NAME] | New York, NY | NY | Early |  |  | 10 | 0.4285714285714285 | 0.2857142857142857 | 0.2857142857142857 | 1
15 | [NAME] | New York, NY | NY | On Time |  |  | 11 | 0.75 | 0.25 | 0 | 1
16 | [NAME] | New York, NY | NY | Late |  |  | 12 | 0.2857142857142857 | 0 | 0.7142857142857143 | 1
17 | [NAME] | New York, NY | NY | On Time |  |  | 13 | 0.2857142857142857 | 0.4285714285714285 | 0.2857142857142857 | 1
18 | [NAME] | New York, NY | NY | On Time |  |  | 14 | 0 | 0.7142857142857143 | 0.2857142857142857 | 1
19 | [NAME] | New York, NY | NY | Early |  |  | 15 | 0.5714285714285714 | 0.1428571428571428 | 0.2857142857142857 | 1
20 | [NAME] | New York, NY | NY | On Time |  |  | 16 | 0.7142857142857143 | 0.1428571428571428 | 0.1428571428571428 | 1
21 | [NAME] | New York, NY | NY | On Time |  |  | 17 | 0.5714285714285714 | 0.1428571428571428 | 0.2857142857142857 | 1
22 | [NAME] | New York, NY | NY | Early |  |  | 18 | 0.5 | 0 | 0.5 | 1
23 | [NAME] | New York, NY | NY | On Time |  |  | 19 | 0.3333333333333333 | 0 | 0.6666666666666666 | 1
24 | [NAME] | New York, NY | NY | On Time |  |  | 20 | 0.1428571428571428 | 0.2857142857142857 | 0.5714285714285714 | 1
25 | [NAME] | New York, NY | NY | Late |  |  | 21 | 0.2857142857142857 | 0.4285714285714285 | 0.2857142857142857 | 1
26 | [NAME] | New York, NY | NY | Early |  |  | 22 | 0.4285714285714285 | 0.1428571428571428 | 0.4285714285714285 | 1
27 | [NAME] | New York, NY | NY | Early |  |  | 23 | 0 | 0.2857142857142857 | 0.7142857142857143 | 1
28 | [NAME] | New York, NY | NY | On Time |  |  | 24 | 0.1428571428571428 | 0.2857142857142857 | 0.5714285714285714 | 1
29 | [NAME] | New York, NY | NY | Early |  |  | 25 | 0.25 | 0 | 0.75 | 1
30 | [NAME] | New York, NY | NY | Early |  |  | 26 | 0.1428571428571428 | 0.5714285714285714 | 0.2857142857142857 | 1
31 | [NAME] | New York, NY | NY | Early |  |  | 27 | 0.1428571428571428 | 0 | 0.8571428571428571 | 1
1 | LAX | Los Angeles, CA | CA | On Time |  |  | 28 | 0.2857142857142857 | 0.4285714285714285 | 0.2857142857142857 | 1
2 | LAX | Los Angeles, CA | CA | On Time |  |  | 29 | 0.2857142857142857 | 0.1428571428571428 | 0.5714285714285714 | 1
3 | LAX | Los Angeles, CA | CA | On Time |  |  | 30 | 0.3333333333333333 | 0.5 | 0.1666666666666667 | 1
4 | LAX | Los Angeles, CA | CA | On Time |  |  | 31 | 0 | 0.3333333333333333 | 0.6666666666666666 | 1
6 | LAX | Los Angeles, CA | CA | On Time |  |  | Grand Total | 0.32 | 0.265 | 0.415 | 1
7 | LAX | Los Angeles, CA | CA | Early
8 | LAX | Los Angeles, CA | CA | On Time
9 | LAX | Los Angeles, CA | CA | On Time
10 | LAX | Los Angeles, CA | CA | Early
11 | LAX | Los Angeles, CA | CA | Early
12 | LAX | Los Angeles, CA | CA | Early
13 | LAX | Los Angeles, CA | CA | Late
14 | LAX | Los Angeles, CA | CA | On Time
15 | LAX | Los Angeles, CA | CA | On Time
16 | LAX | Los Angeles, CA | CA | Early
17 | LAX | Los Angeles, CA | CA | Late
18 | LAX | Los Angeles, CA | CA | Early
19 | LAX | Los Angeles, CA | CA | On Time
20 | LAX | Los Angeles, CA | CA | On Time
21 | LAX | Los Angeles, CA | CA | Late
22 | LAX | Los Angeles, CA | CA | Early
23 | LAX | Los Angeles, CA | CA | On Time
24 | LAX | Los Angeles, CA | CA | On Time
25 | LAX | Los Angeles, CA | CA | Early
26 | LAX | Los Angeles, CA | CA | Early
27 | LAX | Los Angeles, CA | CA | On Time
28 | LAX | Los Angeles, CA | CA | Late
29 | LAX | Los Angeles, CA | CA | Late
30 | LAX | Los Angeles, CA | CA | Late
31 | LAX | Los Angeles, CA | CA | On Time
1 | [NAME] | New York, NY | NY | Late
2 | [NAME] | New York, NY | NY | Late
3 | [NAME] | New York, NY | NY | On Time
4 | [NAME] | New York, NY | NY | Early
5 | [NAME] | New York, NY | NY | On Time
6 | [NAME] | New York, NY | NY | Late
7 | [NAME] | New York, NY | NY | Late
8 | [NAME] | New York, NY | NY | Late
9 | [NAME] | New York, NY | NY | Late
10 | [NAME] | New York, NY | NY | Late
11 | [NAME] | New York, NY | NY | Late
12 | [NAME] | New York, NY | NY | Early
13 | [NAME] | New York, NY | NY | Early
14 | [NAME] | New York, NY | NY | On Time
15 | [NAME] | New York, NY | NY | Early
16 | [NAME] | New York, NY | NY | Late
17 | [NAME] | New York, NY | NY | On Time
18 | [NAME] | New York, NY | NY | Late
19 | [NAME] | New York, NY | NY | Late
20 | [NAME] | New York, NY | NY | On Time
21 | [NAME] | New York, NY | NY | On Time
22 | [NAME] | New York, NY | NY | On Time
23 | [NAME] | New York, NY | NY | Late
24 | [NAME] | New York, NY | NY | Late
25 | [NAME] | New York, NY | NY | On Time
26 | [NAME] | New York, NY | NY | Early
27 | [NAME] | New York, NY | NY | Early
28 | [NAME] | New York, NY | NY | Early
29 | [NAME] | New York, NY | NY | Early
30 | [NAME] | New York, NY | NY | On Time
31 | [NAME] | New York, NY | NY | Early
1 | LAX | Los Angeles, CA | CA | Early
2 | LAX | Los Angeles, CA | CA | Early
3 | LAX | Los Angeles, CA | CA | On Time
5 | LAX | Los Angeles, CA | CA | Late
6 | LAX | Los Angeles, CA | CA | On Time
7 | LAX | Los Angeles, CA | CA | Late
8 | LAX | Los Angeles, CA | CA | Early
9 | LAX | Los Angeles, CA | CA | Early
10 | LAX | Los Angeles, CA | CA | Late
12 | LAX | Los Angeles, CA | CA | Early
13 | LAX | Los Angeles, CA | CA | Late
14 | LAX | Los Angeles, CA | CA | Late
15 | LAX | Los Angeles, CA | CA | Late
16 | LAX | Los Angeles, CA | CA | Early
17 | LAX | Los Angeles, CA | CA | Early
19 | LAX | Los Angeles, CA | CA | Early
20 | LAX | Los Angeles, CA | CA | On Time
21 | LAX | Los Angeles, CA | CA | Late
22 | LAX | Los Angeles, CA | CA | Early
23 | LAX | Los Angeles, CA | CA | Late
24 | LAX | Los Angeles, CA | CA | Early
26 | LAX | Los Angeles, CA | CA | Late
27 | LAX | Los Angeles, CA | CA | On Time
28 | LAX | Los Angeles, CA | CA | Early
29 | LAX | Los Angeles, CA | CA | Early
30 | LAX | Los Angeles, CA | CA | Late
31 | LAX | Los Angeles, CA | CA | On Time
2 | LAX | Los Angeles, CA | CA | Late
3 | LAX | Los Angeles, CA | CA | Early
4 | LAX | Los Angeles, CA | CA | Late
5 | LAX | Los Angeles, CA | CA | On Time
6 | LAX | Los Angeles, CA | CA | Late
7 | LAX | Los Angeles, CA | CA | Early
8 | LAX | Los Angeles, CA | CA | Early
9 | LAX | Los Angeles, CA | CA | Early
10 | LAX | Los Angeles, CA | CA | Early
11 | LAX | Los Angeles, CA | CA | Early
12 | LAX | Los Angeles, CA | CA | On Time
13 | LAX | Los Angeles, CA | CA | Early
14 | LAX | Los Angeles, CA | CA | Late
15 | LAX | Los Angeles, CA | CA | Early
16 | LAX | Los Angeles, CA | CA | Early
17 | LAX | Los Angeles, CA | CA | Early
18 | LAX | Los Angeles, CA | CA | Early
20 | LAX | Los Angeles, CA | CA | Late
21 | LAX | Los Angeles, CA | CA | Early
22 | LAX | Los Angeles, CA | CA | On Time
23 | LAX | Los Angeles, CA | CA | Late
24 | LAX | Los Angeles, CA | CA | On Time
25 | LAX | Los Angeles, CA | CA | On Time
26 | LAX | Los Angeles, CA | CA | Late
27 | LAX | Los Angeles, CA | CA | On Time
28 | LAX | Los Angeles, CA | CA | On Time
29 | LAX | Los Angeles, CA | CA | On Time
30 | LAX | Los Angeles, CA | CA | On Time
31 | LAX | Los Angeles, CA | CA | Late
1 | LAX | Los Angeles, CA | CA | Early
2 | LAX | Los Angeles, CA | CA | Early
3 | LAX | Los Angeles, CA | CA | On Time
5 | LAX | Los Angeles, CA | CA | Early
6 | LAX | Los Angeles, CA | CA | On Time
7 | LAX | Los Angeles, CA | CA | Late
8 | LAX | Los Angeles, CA | CA | Early
9 | LAX | Los Angeles, CA | CA | Early
10 | LAX | Los Angeles, CA | CA | On Time
12 | LAX | Los Angeles, CA | CA | On Time
13 | LAX | Los Angeles, CA | CA | On Time
14 | LAX | Los Angeles, CA | CA | Late
15 | LAX | Los Angeles, CA | CA | Early
16 | LAX | Los Angeles, CA | CA | Early
17 | LAX | Los Angeles, CA | CA | Early
19 | LAX | Los Angeles, CA | CA | On Time
20 | LAX | Los Angeles, CA | CA | On Time
21 | LAX | Los Angeles, CA | CA | On Time
22 | LAX | Los Angeles, CA | CA | Late
23 | LAX | Los Angeles, CA | CA | On Time
24 | LAX | Los Angeles, CA | CA | On Time
26 | LAX | Los Angeles, CA | CA | On Time
27 | LAX | Los Angeles, CA | CA | On Time
28 | LAX | Los Angeles, CA | CA | Late
29 | LAX | Los Angeles, CA | CA | Early
30 | LAX | Los Angeles, CA | CA | Early
31 | LAX | Los Angeles, CA | CA | Late
1 | OGG | [NAME], HI | HI | On Time
2 | OGG | [NAME], HI | HI | Early
3 | OGG | [NAME], HI | HI | Early
4 | OGG | [NAME], HI | HI | Early
5 | OGG | [NAME], HI | HI | Early
6 | OGG | [NAME], HI | HI | Early
7 | OGG | [NAME], HI | HI | On Time
8 | OGG | [NAME], HI | HI | Early
9 | OGG | [NAME], HI | HI | Early
10 | OGG | [NAME], HI | HI | Early
11 | OGG | [NAME], HI | HI | Early
12 | OGG | [NAME], HI | HI | On Time
13 | OGG | [NAME], HI | HI | On Time
15 | OGG | [NAME], HI | HI | Early
16 | OGG | [NAME], HI | HI | Early
17 | OGG | [NAME], HI | HI | Early
18 | OGG | [NAME], HI | HI | Early
19 | OGG | [NAME], HI | HI | On Time
20 | OGG | [NAME], HI | HI | On Time
22 | OGG | [NAME], HI | HI | On Time
23 | OGG | [NAME], HI | HI | Early
24 | OGG | [NAME], HI | HI | Early
25 | OGG | [NAME], HI | HI | Early
26 | OGG | [NAME], HI | HI | Early
27 | OGG | [NAME], HI | HI | On Time
29 | OGG | [NAME], HI | HI | Late
30 | OGG | [NAME], HI | HI | Early
31 | OGG | [NAME], HI | HI | Early
1 | [NAME] | New York, NY | NY | Late
2 | [NAME] | New York, NY | NY | On Time
3 | [NAME] | New York, NY | NY | On Time
5 | [NAME] | New York, NY | NY | On Time
6 | [NAME] | New York, NY | NY | On Time
7 | [NAME] | New York, NY | NY | Late
8 | [NAME] | New York, NY | NY | Late
9 | [NAME] | New York, NY | NY | On Time
10 | [NAME] | New York, NY | NY | Early
12 | [NAME] | New York, NY | NY | Early
13 | [NAME] | New York, NY | NY | Early
14 | [NAME] | New York, NY | NY | On Time
15 | [NAME] | New York, NY | NY | Early
16 | [NAME] | New York, NY | NY | Early
17 | [NAME] | New York, NY | NY | Early
19 | [NAME] | New York, NY | NY | On Time
20 | [NAME] | New York, NY | NY | Late
21 | [NAME] | New York, NY | NY | On Time
22 | [NAME] | New York, NY | NY | On Time
23 | [NAME] | New York, NY | NY | Early
24 | [NAME] | New York, NY | NY | Early
26 | [NAME] | New York, NY | NY | Early
27 | [NAME] | New York, NY | NY | On Time
28 | [NAME] | New York, NY | NY | Early
29 | [NAME] | New York, NY | NY | On Time
30 | [NAME] | New York, NY | NY | On Time
31 | [NAME] | New York, NY | NY | Early
1 | SFO | San Francisco, CA | CA | Early
2 | SFO | San Francisco, CA | CA | On Time
3 | SFO | San Francisco, CA | CA | On Time
4 | SFO | San Francisco, CA | CA | Late
5 | SFO | San Francisco, CA | CA | Early
6 | SFO | San Francisco, CA | CA | Early
7 | SFO | San Francisco, CA | CA | On Time
8 | SFO | San Francisco, CA | CA | Early
9 | SFO | San Francisco, CA | CA | Late
10 | SFO | San Francisco, CA | CA | Early
11 | SFO | San Francisco, CA | CA | Early
12 | SFO | San Francisco, CA | CA | On Time
13 | SFO | San Francisco, CA | CA | Late
14 | SFO | San Francisco, CA | CA | Late
15 | SFO | San Francisco, CA | CA | Early
16 | SFO | San Francisco, CA | CA | Early
17 | SFO | San Francisco, CA | CA | On Time
18 | SFO | San Francisco, CA | CA | On Time
19 | SFO | San Francisco, CA | CA | Early
20 | SFO | San Francisco, CA | CA | Early
21 | SFO | San Francisco, CA | CA | Early
22 | SFO | San Francisco, CA | CA | Early
23 | SFO | San Francisco, CA | CA | On Time
24 | SFO | San Francisco, CA | CA | Late
25 | SFO | San Francisco, CA | CA | On Time
26 | SFO | San Francisco, CA | CA | Late
27 | SFO | San Francisco, CA | CA | On Time
28 | SFO | San Francisco, CA | CA | Early
29 | SFO | San Francisco, CA | CA | On Time
30 | SFO | San Francisco, CA | CA | Early
31 | SFO | San Francisco, CA | CA | On Time
1 | SFO | San Francisco, CA | CA | Late
2 | SFO | San Francisco, CA | CA | Early
3 | SFO | San Francisco, CA | CA | Early
4 | SFO | San Francisco, CA | CA | On Time
5 | SFO | San Francisco, CA | CA | On Time
6 | SFO | San Francisco, CA | CA | Late
7 | SFO | San Francisco, CA | CA | On Time
8 | SFO | San Francisco, CA | CA | Late
9 | SFO | San Francisco, CA | CA | Late
10 | SFO | San Francisco, CA | CA | Late
11 | SFO | San Francisco, CA | CA | Late
12 | SFO | San Francisco, CA | CA | On Time
13 | SFO | San Francisco, CA | CA | Early
14 | SFO | San Francisco, CA | CA | Late
15 | SFO | San Francisco, CA | CA | Early
16 | SFO | San Francisco, CA | CA | Late
17 | SFO | San Francisco, CA | CA | Early
18 | SFO | San Francisco, CA | CA | On Time
19 | SFO | San Francisco, CA | CA | On Time
20 | SFO | San Francisco, CA | CA | Late
21 | SFO | San Francisco, CA | CA | Late
22 | SFO | San Francisco, CA | CA | On Time
23 | SFO | San Francisco, CA | CA | On Time
24 | SFO | San Francisco, CA | CA | Late
25 | SFO | San Francisco, CA | CA | On Time
26 | SFO | San Francisco, CA | CA | Late
27 | SFO | San Francisco, CA | CA | Early
28 | SFO | San Francisco, CA | CA | Late
29 | SFO | San Francisco, CA | CA | On Time
30 | SFO | San Francisco, CA | CA | Late
31 | SFO | San Francisco, CA | CA | On Time
1 | [NAME] | New York, NY | NY | Cancelled
2 | [NAME] | New York, NY | NY | On Time
3 | [NAME] | New York, NY | NY | Early
4 | [NAME] | New York, NY | NY | Late
5 | [NAME] | New York, NY | NY | Early
6 | [NAME] | New York, NY | NY | Late
7 | [NAME] | New York, NY | NY | Early
8 | [NAME] | New York, NY | NY | Late
9 | [NAME] | New York, NY | NY | On Time
10 | [NAME] | New York, NY | NY | Early
11 | [NAME] | New York, NY | NY | Early
12 | [NAME] | New York, NY | NY | Early
13 | [NAME] | New York, NY | NY | Late
14 | [NAME] | New York, NY | NY | Late
15 | [NAME] | New York, NY | NY | Early
16 | [NAME] | New York, NY | NY | Early
17 | [NAME] | New York, NY | NY | Late
18 | [NAME] | New York, NY | NY | Early
19 | [NAME] | New York, NY | NY | On Time
20 | [NAME] | New York, NY | NY | Early
21 | [NAME] | New York, NY | NY | On Time
22 | [NAME] | New York, NY | NY | On Time
23 | [NAME] | New York, NY | NY | On Time
24 | [NAME] | New York, NY | NY | Late
25 | [NAME] | New York, NY | NY | On Time
26 | [NAME] | New York, NY | NY | Late
27 | [NAME] | New York, NY | NY | Late
28 | [NAME] | New York, NY | NY | On Time
29 | [NAME] | New York, NY | NY | Early
30 | [NAME] | New York, NY | NY | On Time
31 | [NAME] | New York, NY | NY | Late
1 | SFO | San Francisco, CA | CA | Late
2 | SFO | San Francisco, CA | CA | Early
3 | SFO | San Francisco, CA | CA | Late
5 | SFO | San Francisco, CA | CA | Late
6 | SFO | San Francisco, CA | CA | On Time
7 | SFO | San Francisco, CA | CA | On Time
8 | SFO | San Francisco, CA | CA | On Time
9 | SFO | San Francisco, CA | CA | Late
10 | SFO | San Francisco, CA | CA | On Time
12 | SFO | San Francisco, CA | CA | On Time
13 | SFO | San Francisco, CA | CA | On Time
14 | SFO | San Francisco, CA | CA | On Time
15 | SFO | San Francisco, CA | CA | On Time
16 | SFO | San Francisco, CA | CA | On Time
17 | SFO | San Francisco, CA | CA | On Time
19 | SFO | San Francisco, CA | CA | On Time
20 | SFO | San Francisco, CA | CA | On Time
21 | SFO | San Francisco, CA | CA | On Time
22 | SFO | San Francisco, CA | CA | On Time
23 | SFO | San Francisco, CA | CA | On Time
24 | SFO | San Francisco, CA | CA | On Time
26 | SFO | San Francisco, CA | CA | On Time
27 | SFO | San Francisco, CA | CA | On Time
28 | SFO | San Francisco, CA | CA | On Time
29 | SFO | San Francisco, CA | CA | On Time