Elogger Logbook Sample.xlsx

	A	B	C	D	E	F	G	H	I
1	Start date of trip (DDMMYY)	Start time of trip (hhmmss)	End date of trip (DDMMYY)	End time of trip (hhmmss)	Business kilometers	Private kilometers	Odometer reading	GPS Co-ordinates	End Destination
2							0.000		GIS Street Addresses
3	070521	102903	070521	105401	5.992		5.992	33.8057446,S,18.4800816,E	1 Compass Cl, Blouberg Sands, Cape Town, 7441, South Africa
4	070521	110003	070521	114503	28.500		34.492	33.9750040,S,18.5767283,E	488 Ny 111 St, KTC, Cape Town, 7750, South Africa
5	070521	154940	070521	163535		30.769	65.261	33.8156343,S,18.4979200,E	22 Ravenscourt Rd, Parklands, Cape Town, 7441, South Africa
6	070521	165034	070521	172146	4.546		69.807	33.8157263,S,18.5109066,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
7	070521	173641	070521	174421	2.087		71.894	33.8156578,S,18.4962716,E	81 Ravenscourt Rd, Parklands, Cape Town, 7441, South Africa
8	070521	181851	070521	182451	2.274		74.168	33.8157310,S,18.5108366,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
9	080521	095610	080521	100034		2.191	76.359	33.8155210,S,18.4939650,E	2 Garden Dr, Sunningdale, Cape Town, 7441, South Africa
10	080521	104106	080521	104426	0.761		77.120	33.8159115,S,18.4962983,E	81 Ravenscourt Rd, Parklands, Cape Town, 7441, South Africa
11	080521	104911	080521	105226	1.540		78.660	33.8157226,S,18.5108766,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
12	080521	111922	080521	114104	7.589		86.249	33.8150856,S,18.4872100,E	1 Waterford Rd, Blouberg Rise, Cape Town, 7441, South Africa
13	080521	130040	080521	130456	1.514		87.763	33.8156156,S,18.4966633,E	81 Ravenscourt Rd, Parklands, Cape Town, 7441, South Africa
14	080521	131503	080521	132133	2.162		89.925	33.8157246,S,18.5108250,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
15	100521	084408	100521	091013	16.564		106.489	33.7357348,S,18.4530383,E	1 Fairway Dr, Melkbosstrand, Cape Town, 7441, South Africa
16	100521	092656	100521	095018	16.007		122.496	33.8157236,S,18.5108683,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
17	100521	102207	100521	104847	7.874		130.370	33.7951771,S,18.4565400,E	26 Verkouteren St, Bloubergstrand, Cape Town, 7441, South Africa
18	100521	111647	100521	112927	8.800		139.170	33.8554651,S,18.4957433,E	4 Ocean Way, Sunset Beach, Cape Town, 7441, South Africa
19	100521	113327	100521	115719	13.011		152.181	33.9352546,S,18.4662083,E	17 Scott Rd, Observatory, Cape Town, 7925, South Africa
20	100521	122210	100521	123312	2.465		154.646	33.9354048,S,18.4600466,E	352 Victoria Rd, Salt River, Cape Town, 7925, South Africa
21	100521	133748	100521	135734	13.703		168.349	33.8653976,S,18.5174400,E	28a Marconi Cres, Montague Gardens, Cape Town, 7441, South Africa
22	100521	140950	100521	142540		7.727	176.076	33.8157241,S,18.5109066,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
23	100521	144454	100521	145331	2.225		178.301	33.8056938,S,18.5028200,E	55 Avonlea Cl, Parklands, Cape Town, 7441, South Africa
24	100521	150753	100521	152147		1.490	179.791	33.8059180,S,18.5073633,E	90 Dorchester Dr, Bloubergstrand, Cape Town, 7441, South Africa
25	100521	154303	100521	154811		1.604	181.395	33.8157276,S,18.5108700,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
26	100521	164908	100521	170106	2.700		184.095	33.8052623,S,18.5019516,E	8 Marlborough Way, Parklands, Cape Town, 7441, South Africa
27	100521	182328	100521	182837	2.612		186.707	33.8157263,S,18.5108916,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
28	110521	083215	110521	085809		9.543	196.250	33.8651575,S,18.5053950,E	20 Oleander St, Milnerton, Cape Town, 7441, South Africa
29	110521	085858	110521	090001		0.239	196.489	33.8653275,S,18.5065050,E	Helipad Hospital, 0B Racecourse Rd, Milnerton, Cape Town, 7441, South Africa
30	110521	091305	110521	094917		9.139	205.628	33.8357961,S,18.5040866,E	5 Bosduif Cres, Flamingo Vlei, Cape Town, 7441, South Africa
31	110521	095537	110521	095638	0.366		205.994	33.8356628,S,18.5012416,E	84 Pentz Dr, Flamingo Vlei, Cape Town, 7441, South Africa
32	110521	101456	110521	102558		6.046	212.040	33.8056790,S,18.4720883,E	ERF27048 Rochester Rd, West Beach, Cape Town, 7441, South Africa
33	110521	105651	110521	110525	2.918		214.958	33.8054525,S,18.4914666,E	7 San Rogue St, Milnerton Rural, Cape Town, 7441, South Africa
34	110521	110845	110521	111515		3.196	218.154	33.8157250,S,18.5109266,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
35	110521	112443	110521	113839		7.177	225.331	33.7857328,S,18.4768000,E	Maple Creek Dr, Cape Farms, Cape Town, South Africa
36	110521	123647	110521	124929	5.744		231.075	33.8158365,S,18.4901350,E	25 Park Drive, Table View, Cape Town, 7441, South Africa
37	110521	130302	110521	132044	4.923		235.998	33.8055950,S,18.4819150,E	42 Compass Cl, Blouberg Sands, Cape Town, 7441, South Africa
38	110521	134256	110521	142555	9.069		245.067	33.7355243,S,18.4526150,E	1 Fairway Drive, Melkbosstrand, Cape Town, 7441, South Africa
39	110521	142911	110521	144830	1.853		246.920	33.7450621,S,18.4472900,E	3 Abalone Cl, Atlantic Beach Golf Estate, Cape Town, 7441, South Africa
40	110521	145912	110521	151248		10.658	257.578	33.8055015,S,18.4848200,E	10111 Sandown Rd E, Milnerton, Cape Town, 7741, South Africa
41	110521	154025	110521	160118	2.427		260.005	33.8151210,S,18.4828300,E	5 Wessels Rd, Blouberg Rise, Cape Town, 7441, South Africa
42	110521	162913	110521	172726	31.706		291.711	33.9751243,S,18.5963866,E	15 Michigan St, Boquinar Industrial Area, Cape Town, 7490, South Africa
43	110521	173012	110521	180522	23.717		315.428	33.8157213,S,18.5107950,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
44	120521	081238	120521	090555	52.444		367.872	33.9356853,S,18.8631550,E	Sasol Art Museum, 52 Ryneveld St, Stellenbosch Central, Stellenbosch, 7600, South Africa
45	120521	094634	120521	095920		1.682	369.554	33.9358358,S,18.8600983,E	7 Beyers St, Stellenbosch Central, Stellenbosch, 7600, South Africa
46	120521	101359	120521	105200	34.696		404.250	33.9659960,S,18.5768300,E	30 Sierra Rd, Montevideo, Cape Town, 7490, South Africa
47	120521	141229	120521	145301	27.755		432.005	33.8051055,S,18.5200350,E	41 Willenhall Cl, Cape Farms, Cape Town, 7441, South Africa
48	120521	145729	120521	150201	1.282		433.287	33.7959465,S,18.5290483,E	37 Columbus Cres, Parklands, Cape Town, South Africa
49	120521	151522	120521	153210	14.004		447.291	33.8858081,S,18.5129733,E	11 Ocean Spirit Ave, Sanddrift, Cape Town, 7441, South Africa
50	120521	153639	120521	153917		0.581	447.872	33.8859895,S,18.5109966,E	51 Disa Cres, Sanddrift, Cape Town, 7441, South Africa
51	120521	163346	120521	170227	11.164		459.036	33.8157245,S,18.5109150,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
52	120521	172741	120521	173033	0.927		459.963	33.8153121,S,18.5078450,E	14 Newbury Cl, Parklands, Cape Town, 7441, South Africa
53	120521	173900	120521	174454	2.008		461.971	33.7959353,S,18.5022233,E	Sagewood Estate, Sandown, Milnerton Rural, Cape Town, 7441, South Africa
54	120521	180252	120521	181041	2.625		464.596	33.8157230,S,18.5108666,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
55	130521	082358	130521	083114		1.748	466.344	33.8055470,S,18.5027950,E	55 Avonlea Cl, Parklands, Cape Town, 7441, South Africa
56	130521	083757	130521	084202	1.841		468.185	33.8157261,S,18.5108433,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
57	130521	084558	130521	090445		8.628	476.813	33.8752756,S,18.5210850,E	1 Drill Ave, Montague Gardens, Cape Town, 7441, South Africa
58	130521	093011	130521	095923	16.574		493.387	33.9158280,S,18.4210183,E	10 Hospital St, Cape Town, 8001, South Africa
59	130521	102503	130521	104144	4.916		498.303	33.9351473,S,18.4220833,E	94 Upper Mill St, Vredehoek, Cape Town, 8001, South Africa
60	130521	115327	130521	120611		0.461	498.764	33.9351538,S,18.4209116,E	6A Virginia Ave, Vredehoek, Cape Town, 8001, South Africa
61	130521	132019	130521	132912	2.431		501.195	33.9258853,S,18.4115133,E	78 Bryant St, Schotsche Kloof, Cape Town, 8001, South Africa
62	130521	140824	130521	141612		2.597	503.792	33.9153170,S,18.4159416,E	106 De Smit St, Green Point, Cape Town, 8051, South Africa
63	130521	142756	130521	150613		22.334	526.126	33.7857238,S,18.4769683,E	Maple Creek Dr, Cape Farms, Cape Town, South Africa
64	130521	151759	130521	153255	6.312		532.438	33.8157250,S,18.5108716,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
65	140521	092832	140521	093548		3.885	536.323	33.8154511,S,18.4794466,E	22 Watsonia Rd, Table View, Cape Town, 7441, South Africa
66	140521	101602	140521	103522		9.836	546.159	33.8156881,S,18.5345516,E	2 benetton road racing park, Milnerton Rural, Cape Town, 7441, South Africa
67	140521	110720	140521	114417	25.007		571.166	33.9750011,S,18.5767750,E	488 Ny 111 St, KTC, Cape Town, 7750, South Africa
68	140521	152410	140521	155347	19.587		590.753	33.8759168,S,18.4989633,E	17A Yarrow Rd, Milnerton, Cape Town, 7441, South Africa
69	140521	160354	140521	163709	9.349		600.102	33.8157266,S,18.5109050,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
70	140521	170030	140521	173501	12.105		612.207	33.7953488,S,18.4578266,E	26 Verkouteren St, Bloubergstrand, Cape Town, 7441, South Africa
71	140521	203214	140521	204333		7.449	619.656	33.8157263,S,18.5108916,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
72	140521	210303	140521	210605		1.313	620.969	33.8252501,S,18.5051683,E	4 Sultana Rd, Table View, Cape Town, 7441, South Africa
73	140521	222422	140521	222911	2.005		622.974	33.8157253,S,18.5108583,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
74	150521	080440	150521	081035		3.974	626.948	33.7951871,S,18.4919466,E	11 Dulwich Cres, Milnerton Rural, Cape Town, 7441, South Africa
75	150521	102729	150521	103354	3.022		629.970	33.8054295,S,18.4862483,E	Shop 19 Westcoast Village, Sandown Rd, Sunningdale, Cape Town, 7441, South Africa
76	150521	112839	150521	113626	3.096		633.066	33.7857115,S,18.4803600,E	203 Sunningdale Dr, Cape Farms, Cape Town, South Africa
77	150521	123349	150521	124425		5.288	638.354	33.8153516,S,18.5078150,E	14 Newbury Cl, Parklands, Cape Town, 7441, South Africa
78	150521	125817	150521	130130	0.819		639.173	33.8157246,S,18.5108650,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
79	160521	112458	160521	113118		2.790	641.963	33.8156010,S,18.4955933,E	Link Rd, Parklands, Cape Town, 7441, South Africa
80	160521	113923	160521	114349	2.155		644.118	33.8157256,S,18.5107916,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
81	160521	115345	160521	121103		7.401	651.519	33.8054475,S,18.4858533,E	PO Box 485, West Coast Village, 7433, South Africa
82	160521	141458	160521	144235		14.315	665.834	33.8252361,S,18.5044866,E	1b Chardonnay Rd, Table View, Cape Town, 7441, South Africa
83	160521	144633	160521	145256	1.326		667.160	33.8157238,S,18.5108700,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
84	160521	171105	160521	171604	4.133		671.293	33.8054658,S,18.4851283,E	PO Box 485, West Coast Village, 7433, South Africa
85	160521	172106	160521	172613		2.556	673.849	33.7857151,S,18.4803633,E	203 Sunningdale Dr, Cape Farms, Cape Town, South Africa
86	160521	174514	160521	175336	5.327		679.176	33.8153116,S,18.5081233,E	0A Queens Cl, Parklands, Cape Town, 7441, South Africa
87	160521	175824	160521	180107	0.877		680.053	33.8157296,S,18.5109016,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
88	170521	083240	170521	090742	20.725		700.778	33.9150145,S,18.4211000,E	10 Hospital St, Cape Town, 8001, South Africa
89	170521	091420	170521	094125		2.439	703.217	33.9153318,S,18.4217500,E	10 Hospital St, Cape Town, 8001, South Africa
90	170521	105441	170521	110958		9.789	713.006	33.9351168,S,18.4228316,E	94 Upper Mill St, Vredehoek, Cape Town, 8001, South Africa
91	170521	111954	170521	113335		6.366	719.372	33.9352615,S,18.4662016,E	17 Scott Rd, Observatory, Cape Town, 7925, South Africa
92	170521	114303	170521	121326	14.668		734.040	33.8558973,S,18.5216066,E	12b Stella Rd, Montague Gardens, Cape Town, 7441, South Africa
93	170521	124844	170521	130308	6.585		740.625	33.8157265,S,18.5107950,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
94	170521	130752	170521	131733		3.893	744.518	33.8252905,S,18.4830616,E	23 Birkenhead Rd, Table View, Cape Town, 7441, South Africa
95	170521	134647	170521	140733	14.666		759.184	33.7550318,S,18.4517750,E	7 Abalone Cl, Atlantic Beach Golf Estate, Cape Town, 7441, South Africa
96	170521	144234	170521	145807	10.206		769.390	33.7857350,S,18.4765116,E	Maple Creek Dr, Cape Farms, Cape Town, South Africa
97	170521	145928	170521	151541		6.654	776.044	33.8157248,S,18.5108983,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
98	170521	152323	170521	152748	2.006		778.050	33.8156281,S,18.4961333,E	81 Ravenscourt Rd, Parklands, Cape Town, 7441, South Africa
99	170521	154325	170521	154901	2.223		780.273	33.8157251,S,18.5109133,E	2 Dorchester Dr, Parklands, Cape Town, 7441, South Africa
100	180521	085911	180521	090245	2.213		782.486	33.8053585,S,18.5003533,E	19 Chesterfield Way, Parklands, Cape Town, 7441, South Africa