ch05ex02.xlsx
Sheet1
| | Before GPS | | | | | | After GPS |
| Date | Driver | Delivery Address Zone | Time | Price | | Date | Driver | Delivery Address Zone | Time | Price |
| 6/1/14 | Green | D | 9 | 8.54 | | 7/1/14 | Knight | A | 6 | 7.54 |
| 6/1/14 | Smith | A | 10 | 12.76 | | 7/1/14 | Green | B | 7 | 8.78 |
| 6/1/14 | Knight | A | 13 | 20.15 | | 7/1/14 | Smith | C | 13 | 16.87 |
| 6/1/14 | Heppard | C | 18 | 8.95 | | 7/1/14 | Smith | C | 20 | 16.54 |
| 6/1/14 | Green | B | 13 | 5.48 | | 7/1/14 | Heppard | B | 16 | 19.76 |
| 6/1/14 | Smith | D | 18 | 13.67 | | 7/1/14 | Green | A | 7 | 7.98 |
| 6/1/14 | Green | D | 16 | 22.15 | | 7/2/14 | Green | A | 9 | 8.54 |
| 6/1/14 | Knight | A | 8 | 7.56 | | 7/2/14 | Smith | D | 22 | 23.54 |
| 6/1/14 | Smith | A | 7 | 8.43 | | 7/2/14 | Smith | B | 13 | 13.32 |
| 6/2/14 | Smith | C | 6 | 4.15 | | 7/2/14 | Knight | B | 16 | 18.54 |
| 6/2/14 | Green | C | 15 | 19.56 | | 7/2/14 | Smith | D | 20 | 19.43 |
| 6/2/14 | Knight | B | 24 | 22.12 | | 7/3/14 | Green | C | 23 | 12.45 |
| 6/2/14 | Smith | C | 17 | 12.45 | | 7/3/14 | Knight | B | 22 | 21.78 |
| 6/2/14 | Knight | C | 23 | 14.23 | | 7/3/14 | Green | D | 23 | 28.65 |
| 6/2/14 | Green | A | 10 | 12.32 | | 7/3/14 | Smith | C | 25 | 23.13 |
| 6/2/14 | Heppard | B | 20 | 31.65 | | 7/3/14 | Heppard | B | 24 | 16.00 |
| 6/2/14 | Smith | B | 23 | 22.56 | | 7/3/14 | Knight | D | 26 | 14.12 |
| 6/2/14 | Smith | C | 16 | 24.47 | | 7/3/14 | Green | A | 8 | 22.43 |
| 6/2/14 | Heppard | C | 18 | 26.43 | | 7/3/14 | Smith | B | 12 | 15.65 |
| 6/2/14 | Heppard | A | 12 | 23.34 | | 7/5/14 | Green | B | 12 | 17.54 |
| 6/3/14 | Smith | B | 30 | 28.65 | | 7/5/14 | Smith | D | 32 | 16.32 |
| 6/3/14 | Heppard | B | 22 | 21.32 | | 7/5/14 | Heppard | A | 13 | 21.87 |
| 6/3/14 | Knight | B | 21 | 25.32 | | 7/5/14 | Smith | D | 24 | 19.32 |
| 6/3/14 | Green | C | 17 | 17.88 | | 7/5/14 | Knight | B | 13 | 12.43 |
| 6/3/14 | Heppard | C | 14 | 21.34 | | 7/5/14 | Green | C | 16 | 11.54 |
| 6/4/14 | Smith | A | 10 | 7.45 | | 7/5/14 | Green | C | 14 | 13.45 |
| 6/4/14 | Smith | A | 15 | 8.54 | | 7/5/14 | Green | D | 22 | 15.32 |
| 6/4/14 | Heppard | A | 13 | 20.16 | | 7/5/14 | Smith | D | 20 | 10.32 |
| 6/4/14 | Heppard | C | 19 | 33 | | 7/6/14 | Smith | B | 11 | 11.49 |
| 6/4/14 | Smith | C | 13 | 21 | | 7/6/14 | Heppard | C | 12 | 11.59 |
| 6/4/14 | Heppard | B | 22 | 21.76 | | 7/6/14 | Heppard | A | 11 | 22.17 |
| 6/4/14 | Green | C | 17 | 21.11 | | 7/6/14 | Smith | A | 10 | 21.54 |
| 6/4/14 | Heppard | C | 30 | 17.12 | | 7/6/14 | Smith | A | 8 | 19.32 |
| 6/5/14 | Smith | A | 13 | 11.82 | | 7/6/14 | Smith | D | 18 | 13.43 |
| 6/5/14 | Smith | B | 34 | 14.23 | | 7/6/14 | Green | C | 14 | 15.32 |
| 6/5/14 | Smith | B | 36 | 19.34 | | 7/6/14 | Green | B | 13 | 15.42 |
| 6/5/14 | Smith | D | 13 | 12.21 | | 7/6/14 | Knight | D | 30 | 12.21 |
| 6/5/14 | Green | D | 13 | 32.75 | | 7/7/14 | Knight | B | 13 | 11.87 |
| 6/5/14 | Green | C | 19 | 18.43 | | 7/7/14 | Green | A | 7 | 9.76 |
| 6/5/14 | Knight | A | 13 | 10.87 | | 7/7/14 | Green | A | 7 | 10.76 |
| 6/5/14 | Smith | A | 15 | 12.45 | | 7/7/14 | Knight | D | 32 | 19.32 |
| 6/5/14 | Smith | A | 12 | 13.24 | | 7/7/14 | Smith | C | 16 | 21.54 |
| 6/5/14 | Green | C | 19 | 22.43 | | 7/8/14 | Green | B | 14 | 23.21 |
| 6/6/14 | Smith | A | 13 | 29.71 | | 7/8/14 | Knight | D | 28 | 22.32 |
| 6/6/14 | Smith | C | 14 | 12.61 | | 7/8/14 | Knight | A | 9 | 11.43 |
| 6/6/14 | Heppard | B | 19 | 12.81 | | 7/8/14 | Heppard | C | 17 | 19.21 |
| 6/6/14 | Smith | D | 24 | 18.43 | | 7/8/14 | Smith | A | 6 | 12.43 |
| 6/6/14 | Smith | D | 22 | 29.03 | | 7/8/14 | Knight | C | 15 | 12.23 |
| 6/6/14 | Heppard | D | 17 | 38.17 | | 7/8/14 | Smith | B | 16 | 28.14 |
| 6/6/14 | Green | D | 17 | 16.34 | | 7/8/14 | Green | A | 4 | 10.32 |