Rpa Test File.xlsx

route_id 570

route_name days_of_week direction_id 570

first_trip_start first_trip_end last_trip_start 5:00 AM 8:00 PM

last_trip_end frequency trip_duration start_stop end_stop num_buses 5_00AM,5_20AM,6_00AM,6_15AM,6_30AM,6_50AM, trip_times 32 per day

5AM,6_30AM,6_50AM,7_30AM,8_15AM,8_40AM,9_00AM,9_40AM,10_00AM,10_25AM,10_40AM,11_20AM,12_20PM,12_45PM,1_00PM

AM,12_20PM,12_45PM,1_00PM,1_40PM,2_00PM,2_20PM,2_50PM,3_30PM,4_15PM,4_50PM,5_00PM,5_40PM,6_00PM,6_20PM,6_50P

_40PM,6_00PM,6_20PM,6_50PM,7_20PM,8_00PM_x000D_

route_id direction stop_sequence stop_name 570 0 1 C.M.B.T 570 0 2 M.M.D.A. 570 0 3 Thirunagar 570 0 4 Vadapalani 570 0 5 Kasi Theatre 570 0 6 Kalaimagal Nagar 570 0 7 Ekkattuthangal 570 0 8 C.I.P.E.T. (Techno Park) 570 0 9 Saidapet Court / Taluka Office Road 570 0 10 Chinna Malai 570 0 11 Raj Bhawan 570 0 12 Kannagipuram (SAF Aquatic Complex) 570 0 13 Velachery 570 0 14 Velachery 570 0 15 Tansi Nagar 570 0 16 Baby Nagar 570 0 17 Bharathi Nagar 570 0 18 Pillaiyar Koil 570 0 19 Taramani 100 Feet Road 570 0 20 S.R.P. Tool 570 0 21 I.G.P. 570 0 22 Kandanchavadi 570 0 23 Perungudi 570 0 24 Seevaram 570 0 25 Jain College 570 0 26 Rattha Tech Tower 570 0 27 T.C.S. 570 0 28 Karapakkam 570 0 29 Accenture 570 0 30 Sholinganallur 570 0 31 Satyabhama Dental College and Hospital 570 0 32 Semmancheri 570 0 33 Navallur 570 0 34 Siruseri (Muttukadu) 570 0 35 Sirucheri IT Park

stop_id stop_lat stop_lon stage 5:00 AM 45.8993 6.7108 5:03 AM 13.0629 80.2136 5:05 AM 9.88128 78.0475 5:10 AM 13.0526 80.2115 5:17 AM -5.0704 12.7742 5:19 AM 13.0528 80.1105 5:21 AM 13.0242 80.2066 5:23 AM -33.925 18.5473 5:31 AM 11.2527 75.7907 5:32 AM 13.1656 80.2531 5:33 AM 5:36 AM 5:39 AM 5:48 AM 5:50 AM 5:53 AM 5:54 AM 5:56 AM 5:57 AM 6:01 AM 6:04 AM 6:07 AM 6:09 AM 6:12 AM 6:15 AM 6:16 AM 6:26 AM 6:28 AM 6:31 AM 6:34 AM 6:45 AM 6:50 AM 6:55 AM 7:00 AM 7:06 AM

arrival_time departure_time last_arrival_time last_departure_time