Spreadsheet: 675004d1588103317-multiple-layered-formula-uber-report-2020-practice
Sheet: Results (2020)

Name | Date | Cost (USD) | Distance (M) | Source | Key | ANOM |  | Results for | Source: | *
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 |  |  |  | Period | Total Cost | Average Cost | Average Distance | $ W/O ANOM | AV$ W/O ANOM | [NAME]/O ANOM
ZW | 2020-01-03 00:00:00 | 26.65 | 14.58 | INT SM |  |  |  | P1
ZW | 2020-01-04 00:00:00 | 27.92 | 13.68 | INT SM |  |  |  | P2
ZW | 2020-01-05 00:00:00 | 26.85 | 14.65 | INT SM |  |  |  | P3
ZW | 2020-01-05 00:00:00 | 28.09 | 13.69 | INT SM |  |  |  | P4
ZW | 2020-01-06 00:00:00 | 28.12 | 14.59 | INT SM |  |  |  | P5
ZW | 2020-01-07 00:00:00 | 26.87 | 17.72 | INT SM |  |  |  | P6
ZW | 2020-01-07 00:00:00 | 27.49 | 19.05 | INT SM |  |  |  | P7
ZW | 2020-01-08 00:00:00 | 29.08 | 15.5 | INT SM |  |  |  | P8
ZW | 2020-01-08 00:00:00 | 28.17 | 14.49 | INT SM |  |  |  | P9
ZW | 2020-01-09 00:00:00 | 28.2 | 13.69 | INT SM |  |  |  | P10
ZW | 2020-01-09 00:00:00 | 26.76 | 14.51 | INT SM |  |  |  | P11
ZW | 2020-01-09 00:00:00 | 28.22 | 13.68 | INT SM |  |  |  | P12
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 |  |  |  |  | Start | End |  | User | KH
ZW | 2020-01-12 00:00:00 | 26.29 | 14.59 | INT SM |  |  |  | P1 | 2020-01-01 00:00:00 | 2020-02-04 00:00:00 |  | Unique Travel Days
ZW | 2020-01-12 00:00:00 | 28.05 | 13.69 | INT SM |  |  |  | P2 | 2020-02-05 00:00:00 | 2020-03-03 00:00:00 |  | Total Trips
ZW | 2020-01-13 00:00:00 | 26.2 | 14.68 | INT SM |  |  |  | P3 | 2020-03-04 00:00:00 | 2020-03-31 00:00:00 |  | Average Trips Per Day
ZW | 2020-01-13 00:00:00 | 28.99 | 13.7 | INT SM |  |  |  | P4 | 2020-04-01 00:00:00 | 2020-05-05 00:00:00
BR | 2020-01-14 00:00:00 | 13.17 | 5.57 | EXT SM |  |  |  | P5 | 2020-05-06 00:00:00 | 2020-06-02 00:00:00 |  | ZW
BR | 2020-01-16 00:00:00 | 15.29 | 7.67 | EXT SM |  |  |  | P6 | 2020-06-03 00:00:00 | 2020-06-30 00:00:00 |  | AL
BR | 2020-01-16 00:00:00 | 12.24 | 5.31 | EXT SM |  |  |  | P7 | 2020-07-01 00:00:00 | 2020-08-04 00:00:00 |  | BR
BR | 2020-01-17 00:00:00 | 14.61 | 5.36 | EXT SM |  |  |  | P8 | 2020-08-05 00:00:00 | 2020-09-01 00:00:00 |  | KH
BR | 2020-01-18 00:00:00 | 13.72 | 5.41 | EXT SM |  |  |  | P9 | 2020-09-02 00:00:00 | 2020-09-29 00:00:00
BR | 2020-01-18 00:00:00 | 13.77 | 5.82 | EXT SM |  |  |  | P10 | 2020-09-30 00:00:00 | 2020-11-03 00:00:00
BR | 2020-01-18 00:00:00 | 25.33 | 15.08 | EXT SM |  |  |  | P11 | 2020-11-04 00:00:00 | 2020-12-01 00:00:00
BR | 2020-01-18 00:00:00 | 110.23 | 63.33 | EXT SM |  | 1 |  | P12 | 2020-12-02 00:00:00 | 2020-12-29 00:00:00
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 |  |  |  |  | True Number of Uber Trips
BR | 2020-01-22 00:00:00 | 12.4 | 5.32 | EXT SM |  |  |  | Source | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | Source Total
BR | 2020-01-22 00:00:00 | 12.3 | 5.12 | EXT SM |  |  |  | INT SM
BR | 2020-01-23 00:00:00 | 13.78 | 7.57 | EXT SM |  |  |  | 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 |  |  |  |  | Number of Uber Trips Without Anomalies
BR | 2020-01-26 00:00:00 | 40.49 | 23.79 | EXT SM |  |  |  | Source | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | Source Total
BR | 2020-01-26 00:00:00 | 25.27 | 9.23 | EXT SM |  |  |  | INT SM
AL | 2020-01-28 00:00:00 | 12.62 | 7.24 | EXT SM |  |  |  | EXT SM
AL | 2020-01-28 00:00:00 | 6.54 | 2.21 | EXT SM |  |  |  | *
AL | 2020-01-28 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-01-31 00:00:00 | 14.64 | 7.66 | EXT SM
AL | 2020-01-31 00:00:00 | 6.54 | 1.03 | EXT SM
AL | 2020-01-31 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-01 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-02 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-10 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-12 00:00:00 | 12.17 | 5.32 | EXT SM
BR | 2020-02-13 00:00:00 | 14 | 5.56 | EXT SM
BR | 2020-02-13 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-18 00:00:00 | 10.31 | 1.11 | EXT SM
AL | 2020-02-18 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-19 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-20 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-21 00:00:00 | 41.15 | 23.86 | EXT SM
KH | 2020-02-21 00:00:00 | 7.17 | 2.56 | INT SM
BR | 2020-02-21 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-26 00:00:00 | 7.17 | 2.56 | INT SM
KH | 2020-02-26 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-02-29 00:00:00 | 7.17 | 2.57 | INT SM
KH | 2020-02-29 00:00:00 | 7.42 | 0.99 | INT SM
KH | 2020-02-29 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-04 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-05 00:00:00 | 8.01 | 2.49 | INT SM
AL | 2020-03-05 00:00:00 | 9.73 | 4.68 | EXT SM
AL | 2020-03-05 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