IFTA Troubleshooting Report (NEW).xlsx

	A	B	C	D	E	F	G	H	I
1	Created	Apr 21, 2017
2	From	Dec 01, 2016		Variance Percentage (GPS vs. Odometer)
3	To	Feb 28, 2017		Less than	1.00%
4	Measurements	miles		Less than	3.00%
5				Less than	7.00%
6				Greater than or equal	7.00%
7
8	Vehicle	Jurisdiction	Enter Time	Exit Time	Enter Odometer	Exit Odometer	Variance	Distance	GPS Distance

9	Truck A5968	NY	Dec 26, 2016 1:48:02 PM	Dec 26, 2016 8:54:18 PM	16,474	16,510	0.01	36.34	36.81
10			Jan 21, 2017 12:12:32 PM	Jan 21, 2017 8:19:47 PM	17,237	17,291	0.01	54.15	54.64
11		NY Total						90.48	91.45
12		ON	Dec 21, 2016 10:37:21 AM	Dec 26, 2016 1:48:02 PM	16,131	16,474	0.01	343.11	338.37
13			Dec 26, 2016 8:54:18 PM	Jan 21, 2017 12:12:32 PM	16,510	17,237	0.28	726.29	524.62
14			Jan 21, 2017 8:19:47 PM	Feb 16, 2017 10:18:55 AM	17,291	17,651	0.04	360.63	374.61
15		ON Total						1430.02	1237.60
16	Truck A5968 Total							1520.51	1329.05
17	Grand Total							1520.51	1329.05
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100