Spreadsheet: 675004d1588103317-multiple-layered-formula-uber-report-2020-practice
Sheet: Overall

Name | Date | Cost | Distance (M) | Source | [NAME] | ANOM |  | Names:
BH | 2019-11-30 00:00:00 | 12.89 | 9.53 | INT SM |  |  |  | ZW
BH | 2019-11-30 00:00:00 | 14.23 | 9.97 | INT SM |  |  |  | BR
BH | 2019-12-02 00:00:00 | 13.76 | 8.87 | INT SM |  |  |  | AL
BH | 2019-12-03 00:00:00 | 13.3 | 9.05 | INT SM |  |  |  | KH
BH | 2019-12-03 00:00:00 | 13.72 | 8.86 | INT SM |  |  |  | BH
BH | 2019-12-03 00:00:00 | 14.46 | 8.93 | INT SM
BH | 2019-12-04 00:00:00 | 14.24 | 9.09 | INT SM |  |  |  | Source | True Number of Uber Trips |  | Source | Number of Uber Trips Without Anomalies
BH | 2019-12-04 00:00:00 | 13.31 | 8.85 | INT SM |  |  |  | INT SM |  |  | INT SM
BH | 2019-12-05 00:00:00 | 13.89 | 9.53 | INT SM |  |  |  | EXT SM |  |  | EXT SM
BH | 2019-12-06 00:00:00 | 13.79 | 9.85 | INT SM |  |  |  | * |  |  | *
BH | 2019-12-06 00:00:00 | 13.35 | 8.9 | INT SM
BH | 2019-12-07 00:00:00 | 14.81 | 9.31 | INT SM |  |  |  | User | ZW
BH | 2019-12-07 00:00:00 | 12.94 | 9.96 | INT SM |  |  |  | Travel Days
BH | 2019-12-07 00:00:00 | 14.27 | 9.96 | INT SM |  |  |  | Total Trips
BH | 2019-12-10 00:00:00 | 13.72 | 9.51 | INT SM |  |  |  | Average Trips Per Day
BH | 2019-12-10 00:00:00 | 17.11 | 8.93 | INT SM
BH | 2019-12-11 00:00:00 | 13.12 | 9.13 | INT SM |  |  |  | Results for | Source: | *
BH | 2019-12-12 00:00:00 | 14.39 | 9.97 | INT SM |  |  |  | Total Cost | Average Cost | Average Distance | $ W/O ANOM | AV$ W/O ANOM | [NAME]/O ANOM
BH | 2019-12-12 00:00:00 | 13.63 | 9.72 | INT SM
BH | 2019-12-13 00:00:00 | 13.8 | 10.47 | INT SM
BH | 2019-12-15 00:00:00 | 13.91 | 9.06 | INT SM
ZW | 2019-12-16 00:00:00 | 26.38 | 14.47 | INT SM
BH | 2019-12-16 00:00:00 | 14.18 | 9.84 | INT SM
ZW | 2019-12-16 00:00:00 | 27.82 | 17.7 | INT SM
ZW | 2019-12-16 00:00:00 | 25.99 | 19.14 | INT SM
BH | 2019-12-16 00:00:00 | 14.29 | 10.1 | INT SM
BH | 2019-12-17 00:00:00 | 13.72 | 9.98 | INT SM
ZW | 2019-12-17 00:00:00 | 35.45 | 18.96 | INT SM
BH | 2019-12-17 00:00:00 | 13.12 | 8.87 | INT SM
ZW | 2019-12-17 00:00:00 | 25.55 | 18.27 | INT SM
BH | 2019-12-17 00:00:00 | 14.47 | 10.26 | INT SM
ZW | 2019-12-18 00:00:00 | 28.36 | 18.31 | INT SM
ZW | 2019-12-18 00:00:00 | 27.36 | 14.57 | INT SM
BH | 2019-12-18 00:00:00 | 17.02 | 8.87 | INT SM
ZW | 2019-12-18 00:00:00 | 28.57 | 13.69 | INT SM
BH | 2019-12-19 00:00:00 | 13.82 | 9.89 | INT SM
ZW | 2019-12-19 00:00:00 | 26.42 | 14.58 | INT SM
BH | 2019-12-19 00:00:00 | 13.63 | 9.11 | INT SM
ZW | 2019-12-19 00:00:00 | 28.56 | 14.87 | INT SM
BH | 2019-12-20 00:00:00 | 9.12 | 4.87 | INT SM
BH | 2019-12-20 00:00:00 | 9.12 | 4.74 | INT SM
BH | 2019-12-20 00:00:00 | 15.69 | 9.96 | INT SM
BH | 2019-12-20 00:00:00 | 13.19 | 8.88 | INT SM
ZW | 2019-12-20 00:00:00 | 26.53 | 14.54 | INT SM
BH | 2019-12-20 00:00:00 | 14.1 | 9.04 | INT SM
ZW | 2019-12-21 00:00:00 | 28.26 | 13.71 | INT SM
BH | 2019-12-21 00:00:00 | 12.96 | 9.07 | INT SM
BH | 2019-12-21 00:00:00 | 14.33 | 9.99 | INT SM
ZW | 2019-12-23 00:00:00 | 26.22 | 14.47 | INT SM
ZW | 2019-12-23 00:00:00 | 28.91 | 13.64 | INT SM
BH | 2019-12-23 00:00:00 | 19.12 | 9.71 | INT SM
BH | 2019-12-23 00:00:00 | 13.93 | 9.08 | INT SM
ZW | 2019-12-24 00:00:00 | 27.95 | 15.15 | INT SM
ZW | 2019-12-24 00:00:00 | 28.04 | 18.39 | INT SM
ZW | 2019-12-26 00:00:00 | 25.83 | 18.27 | INT SM
BH | 2019-12-26 00:00:00 | 17.76 | 8.86 | INT SM
ZW | 2019-12-26 00:00:00 | 28.53 | 13.68 | INT SM
BH | 2019-12-27 00:00:00 | 14.62 | 10.32 | INT SM
ZW | 2019-12-27 00:00:00 | 26.72 | 14.52 | INT SM
BH | 2019-12-27 00:00:00 | 13.19 | 9.31 | INT SM
ZW | 2019-12-27 00:00:00 | 28.72 | 13.69 | INT SM
BH | 2019-12-28 00:00:00 | 14.09 | 9.84 | INT SM
ZW | 2019-12-28 00:00:00 | 34.02 | 14.06 | INT SM
ZW | 2019-12-29 00:00:00 | 27.99 | 13.67 | INT SM
BH | 2019-12-29 00:00:00 | 12.88 | 8.87 | INT SM
BH | 2019-12-29 00:00:00 | 14.21 | 10 | INT SM
ZW | 2019-12-30 00:00:00 | 26.22 | 14.5 | INT SM
ZW | 2019-12-30 00:00:00 | 29.09 | 19.27 | INT SM
ZW | 2019-12-31 00:00:00 | 27.6 | 14.64 | INT SM
ZW | 2020-01-01 00:00:00 | 46.45 | 13.67 | INT SM
ZW | 2020-01-02 00:00:00 | 34.44 | 14.08 | INT SM
ZW | 2020-01-02 00:00:00 | 31.61 | 15.79 | INT SM
ZW | 2020-01-04 00:00:00 | 26.65 | 14.58 | INT SM
ZW | 2020-01-04 00:00:00 | 27.92 | 13.68 | INT SM
ZW | 2020-01-05 00:00:00 | 26.85 | 14.65 | INT SM
ZW | 2020-01-05 00:00:00 | 28.09 | 13.69 | INT SM
ZW | 2020-01-07 00:00:00 | 28.12 | 14.59 | INT SM
ZW | 2020-01-07 00:00:00 | 26.87 | 17.72 | INT SM
ZW | 2020-01-08 00:00:00 | 27.49 | 19.05 | INT SM
ZW | 2020-01-08 00:00:00 | 29.08 | 15.5 | INT SM
ZW | 2020-01-09 00:00:00 | 28.17 | 14.49 | INT SM
ZW | 2020-01-09 00:00:00 | 28.2 | 13.69 | INT SM
ZW | 2020-01-09 00:00:00 | 26.76 | 14.51 | INT SM
ZW | 2020-01-10 00:00:00 | 28.22 | 13.68 | INT SM
ZW | 2020-01-11 00:00:00 | 24.71 | 17.7 | INT SM
ZW | 2020-01-11 00:00:00 | 28.02 | 14.02 | INT SM
ZW | 2020-01-12 00:00:00 | 26.29 | 14.59 | INT SM
ZW | 2020-01-13 00:00:00 | 28.05 | 13.69 | INT SM
ZW | 2020-01-13 00:00:00 | 26.2 | 14.68 | INT SM
ZW | 2020-01-14 00:00:00 | 28.99 | 13.7 | INT SM
BR | 2020-01-14 00:00:00 | 13.17 | 5.57 | EXT SM
BR | 2020-01-16 00:00:00 | 15.29 | 7.67 | EXT SM
BR | 2020-01-17 00:00:00 | 12.24 | 5.31 | EXT SM
BR | 2020-01-17 00:00:00 | 14.61 | 5.36 | EXT SM
BR | 2020-01-18 00:00:00 | 13.72 | 5.41 | EXT SM
BR | 2020-01-18 00:00:00 | 13.77 | 5.82 | EXT SM
BR | 2020-01-19 00:00:00 | 25.33 | 15.08 | EXT SM
BR | 2020-01-19 00:00:00 | 110.23 | 63.33 | EXT SM |  | 1
BR | 2020-01-19 00:00:00 | 15.18 | 5.4 | EXT SM
BR | 2020-01-20 00:00:00 | 13.22 | 5.31 | EXT SM
BR | 2020-01-22 00:00:00 | 12.4 | 5.32 | EXT SM
BR | 2020-01-23 00:00:00 | 12.3 | 5.12 | EXT SM
BR | 2020-01-23 00:00:00 | 13.78 | 7.57 | EXT SM
BR | 2020-01-23 00:00:00 | 12.92 | 5.34 | EXT SM
BR | 2020-01-24 00:00:00 | 14.92 | 5.4 | EXT SM
BR | 2020-01-24 00:00:00 | 20.56 | 8.94 | EXT SM
BR | 2020-01-25 00:00:00 | 15.4 | 7.68 | EXT SM
BR | 2020-01-26 00:00:00 | 12.52 | 5.25 | EXT SM
BR | 2020-01-26 00:00:00 | 14.86 | 5.52 | EXT SM
BR | 2020-01-26 00:00:00 | 13.48 | 5.33 | EXT SM
BR | 2020-01-26 00:00:00 | 40.49 | 23.79 | EXT SM
BR | 2020-01-27 00:00:00 | 25.27 | 9.23 | EXT SM
AL | 2020-01-28 00:00:00 | 12.62 | 7.24 | EXT SM
AL | 2020-01-29 00:00:00 | 6.54 | 2.21 | EXT SM
AL | 2020-01-29 00:00:00 | 6.54 | 1.14 | EXT SM
BR | 2020-01-31 00:00:00 | 21.05 | 8.67 | EXT SM
BR | 2020-01-31 00:00:00 | 56.89 | 26.72 | EXT SM
BR | 2020-02-01 00:00:00 | 14.64 | 7.66 | EXT SM
AL | 2020-02-01 00:00:00 | 6.54 | 1.03 | EXT SM
AL | 2020-02-01 00:00:00 | 6.54 | 0.95 | EXT SM
BR | 2020-02-01 00:00:00 | 16.01 | 6.72 | EXT SM
BR | 2020-02-01 00:00:00 | 13.67 | 5.59 | EXT SM
BR | 2020-02-02 00:00:00 | 13.7 | 5.28 | EXT SM
BR | 2020-02-02 00:00:00 | 14.7 | 5.35 | EXT SM
BR | 2020-02-03 00:00:00 | 12.07 | 5.32 | EXT SM
BR | 2020-02-03 00:00:00 | 14.25 | 5.35 | EXT SM
BR | 2020-02-03 00:00:00 | 13.31 | 5.34 | EXT SM
BR | 2020-02-04 00:00:00 | 14.43 | 5.39 | EXT SM
BR | 2020-02-05 00:00:00 | 12.54 | 5.36 | EXT SM
BR | 2020-02-05 00:00:00 | 128.53 | 75.09 | EXT SM |  | 1
BR | 2020-02-05 00:00:00 | 13.91 | 5.54 | EXT SM
BR | 2020-02-06 00:00:00 | 13.84 | 5.32 | EXT SM
BR | 2020-02-08 00:00:00 | 14.37 | 7.65 | EXT SM
BR | 2020-02-09 00:00:00 | 11.92 | 5.41 | EXT SM
AL | 2020-02-09 00:00:00 | 19.08 | 11.61 | EXT SM
BR | 2020-02-09 00:00:00 | 18.55 | 8.06 | EXT SM
BR | 2020-02-10 00:00:00 | 18.99 | 8.49 | EXT SM
BR | 2020-02-10 00:00:00 | 13.76 | 6.85 | EXT SM
BR | 2020-02-10 00:00:00 | 12.4 | 5.58 | EXT SM
BR | 2020-02-11 00:00:00 | 128.25 | 74.96 | EXT SM |  | 1
BR | 2020-02-11 00:00:00 | 14.47 | 5.49 | EXT SM
BR | 2020-02-11 00:00:00 | 12.55 | 7.61 | EXT SM
BR | 2020-02-12 00:00:00 | 14 | 5.88 | EXT SM
BR | 2020-02-13 00:00:00 | 12.17 | 5.32 | EXT SM
BR | 2020-02-13 00:00:00 | 14 | 5.56 | EXT SM
BR | 2020-02-14 00:00:00 | 12.62 | 5.36 | EXT SM
AL | 2020-02-14 00:00:00 | 26.82 | 13.6 | EXT SM
BR | 2020-02-15 00:00:00 | 7.44 | 0.82 | EXT SM
BR | 2020-02-15 00:00:00 | 129.45 | 75.53 | EXT SM |  | 1
BR | 2020-02-16 00:00:00 | 14.07 | 7.68 | EXT SM
BR | 2020-02-17 00:00:00 | 12.06 | 5.38 | EXT SM
BR | 2020-02-17 00:00:00 | 13.81 | 5.77 | EXT SM
BR | 2020-02-18 00:00:00 | 16.5 | 5.64 | EXT SM
BR | 2020-02-18 00:00:00 | 14.17 | 5.58 | EXT SM
AL | 2020-02-18 00:00:00 | 15.4 | 8.36 | EXT SM
BR | 2020-02-18 00:00:00 | 13.48 | 5.31 | EXT SM
AL | 2020-02-19 00:00:00 | 10.31 | 1.11 | EXT SM
AL | 2020-02-19 00:00:00 | 6.54 | 1.14 | EXT SM
AL | 2020-02-19 00:00:00 | 9.5 | 5.02 | EXT SM
AL | 2020-02-19 00:00:00 | 6.54 | 1.46 | EXT SM
AL | 2020-02-19 00:00:00 | 9.16 | 4.27 | EXT SM
BR | 2020-02-20 00:00:00 | 108.08 | 62.86 | EXT SM |  | 1
BR | 2020-02-20 00:00:00 | 14.48 | 5.52 | EXT SM
BR | 2020-02-20 00:00:00 | 14.64 | 5.37 | EXT SM
KH | 2020-02-21 00:00:00 | 7.17 | 2.54 | INT SM
BR | 2020-02-21 00:00:00 | 14.03 | 7.49 | EXT SM
KH | 2020-02-21 00:00:00 | 11.45 | 7.68 | INT SM
BR | 2020-02-21 00:00:00 | 13.59 | 5.32 | EXT SM
BR | 2020-02-22 00:00:00 | 41.15 | 23.86 | EXT SM
KH | 2020-02-22 00:00:00 | 7.17 | 2.56 | INT SM
BR | 2020-02-22 00:00:00 | 39.93 | 9.76 | EXT SM
BR | 2020-02-23 00:00:00 | 5.81 | 0.49 | EXT SM
KH | 2020-02-24 00:00:00 | 8.08 | 3.02 | INT SM
KH | 2020-02-24 00:00:00 | 8.61 | 3.99 | INT SM
KH | 2020-02-25 00:00:00 | 7.17 | 2.59 | INT SM
KH | 2020-02-25 00:00:00 | 7.43 | 3.44 | INT SM
KH | 2020-02-25 00:00:00 | 10.85 | 4.93 | INT SM
KH | 2020-02-26 00:00:00 | 7.17 | 3.27 | INT SM
KH | 2020-02-27 00:00:00 | 7.17 | 2.56 | INT SM
KH | 2020-02-27 00:00:00 | 7.17 | 2.55 | INT SM
KH | 2020-02-27 00:00:00 | 7.17 | 2.36 | INT SM
KH | 2020-02-27 00:00:00 | 7.17 | 2.12 | INT SM
KH | 2020-02-28 00:00:00 | 7.17 | 2.59 | INT SM
KH | 2020-02-29 00:00:00 | 7.36 | 3.09 | INT SM
AL | 2020-02-29 00:00:00 | 16.87 | 10.77 | EXT SM
AL | 2020-02-29 00:00:00 | 13.87 | 6.2 | EXT SM
AL | 2020-02-29 00:00:00 | 14.19 | 8.19 | EXT SM
KH | 2020-03-01 00:00:00 | 7.17 | 2.57 | INT SM
KH | 2020-03-01 00:00:00 | 7.42 | 0.99 | INT SM
KH | 2020-03-01 00:00:00 | 7.17 | 0.88 | INT SM
KH | 2020-03-01 00:00:00 | 7.29 | 2.72 | INT SM
KH | 2020-03-04 00:00:00 | 7.34 | 3.06 | INT SM
KH | 2020-03-04 00:00:00 | 81.96 | 80.27 | INT SM |  | 1
KH | 2020-03-04 00:00:00 | 106.55 | 79.13 | INT SM |  | 1
KH | 2020-03-04 00:00:00 | 7.17 | 2.84 | INT SM
KH | 2020-03-05 00:00:00 | 7.45 | 2.54 | INT SM
KH | 2020-03-05 00:00:00 | 8.28 | 2.55 | INT SM
AL | 2020-03-05 00:00:00 | 21.44 | 10.47 | EXT SM
KH | 2020-03-06 00:00:00 | 8.01 | 2.49 | INT SM
AL | 2020-03-06 00:00:00 | 9.73 | 4.68 | EXT SM
AL | 2020-03-06 00:00:00 | 11.72 | 6.4 | EXT SM
AL | 2020-03-06 00:00:00 | 21.42 | 13.83 | EXT SM
KH | 2020-03-06 00:00:00 | 8.73 | 2.73 | INT SM
KH | 2020-03-08 00:00:00 | 7.62 | 3.04 | INT SM
KH | 2020-03-08 00:00:00 | 8.01 | 2.5 | INT SM
KH | 2020-03-09 00:00:00 | 7.86 | 3.06 | INT SM
KH | 2020-03-09 00:00:00 | 7.18 | 2.51 | INT SM
KH | 2020-03-13 00:00:00 | 7.17 | 2.5 | INT SM
KH | 2020-03-13 00:00:00 | 8.33 | 2.52 | INT SM
KH | 2020-03-17 00:00:00 | 7.17 | 2.26 | INT SM
KH | 2020-03-18 00:00:00 | 9.22 | 2.83 | INT SM
KH | 2020-03-18 00:00:00 | 7.22 | 2.58 | INT SM
KH | 2020-03-19 00:00:00 | 7.29 | 2.67 | INT SM
KH | 2020-03-20 00:00:00 | 8.07 | 3.12 | INT SM
KH | 2020-03-21 00:00:00 | 7.42 | 2.8 | INT SM
KH | 2020-03-22 00:00:00 | 7.17 | 2.74 | INT SM
KH | 2020-03-23 00:00:00 | 7.17 | 2.8 | INT SM
KH | 2020-03-24 00:00:00 | 8.05 | 2.78 | INT SM