Automation Project: Australia Traffic

Input as directed.

1. Input file directory:

Input the directory (or, address) of the folder where the raw traffic volume data is saved. For example,

C:\Users\Faysal\OneDrive\Desktop\Learning for project AUS\Traffic volume

2. Input year & month (Ex: 202301--> year=2023 & month=01):

Input the year and month of the traffic volume data you like to summarise. For example,

202306

3. input date (two digits):

Input the date in two digits of the traffic volume data you like to summarise. For example,

15

4. Input Site Number:

Input signal site number. For example,

190

5. Input Site Name (Ex:Lonsdale Street/Foster St):

Input the name of the Traffic Control Signal site. For example,

Lonsdale Street/Foster St

6. Output file directory:

Input the folder directory where you like to save the traffic volume summary. For example,

C:\Users\Faysal\OneDrive\Desktop\Pandas

7. Output file name:

Write the Traffic volume summary file. For example,

Traffic volume summary, TCS0196, 7 - 9AM

8. Input approaches(eg: North,South...):

Input the approaches of the intersection. You can add 8 approaches (North, South, East, West, NorthEast, NorthWest, SouthEast, SouthWest) For example,

North, South, SouthWest, East

9. North approach specific turns (e.g. LT, TH, RT, UT…..):

Input one allowable turn on the north approach. For example,

TH

10. 'Detectors' Nos. for this turn:

Input detector numbers for the TH turn For example,

6, 7

11. Any specific turns and detector numbers left(y/n):

If there is more turn on the north approach, write y and enter. It's not case sensitivity.

9, 10 and 11 number input will repeat according to your test cases.

12. Input the Start time(ex:HHMM-->0330 or 1515):

The starting time for the summary. It should be coefficients of 15.

1515

13. Input the Finish time(ex:HHMM-->0330 or 1515):

The ending time for the summary. It should be coefficients of 15.

1345

14. Input the time interval(in minutes):

It should be multiplier of 15. for example. 15, 30, 45 or 60

Input.as.directed.mp4

Output:

In the output excel file the output will look like this.