BUS- Application Exercises.

profileStudent555
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

Sheet2

Sheet3