MHB How Can You Calculate Bus Arrival Times Using Excel?

[ramonjosegn2014]

Hello dears

I need help with the following:

I want to have a schedule for the time arrvial of the public transport buses in my city

I would use a formula prediction buses and put in Microsoft Excel, but I have no knowledge to something so complex, so I'm asking for help

Since the transport system is new I do not have many details or statistics but I can get some information about the public bus transport:

- I have - The formula used by the company to send a number of buses depending on the miles you have the full path of each bus route

- I have - The time it would take to perform bus full route

- I have - Total kilometers (roundtrip) having each route

- I have - The average distance between bus-stops

- I have - The data with the real frequency for every route (the company generally does not meet the frequencies)

Could anyone help me?

I do not really need something very complex, since transport generally does not meet the data officially established, but I'd like something to start

I appreciate if you can help me

 

[lofgran]

Thank you for reaching out for help with creating a schedule for public transport buses in your city. I understand the importance of efficient and reliable transportation for a city's residents.

Based on the information you have provided, I would suggest using a predictive analysis approach to create a schedule for the arrival of public transport buses. This involves using historical data and mathematical models to make predictions about future events.

To start, you can input the data you have into a spreadsheet program like Microsoft Excel. From there, you can use the formula provided by the company to calculate the number of buses needed for each route based on the distance and time it takes to complete the full route.

Next, you can use the average distance between bus-stops and the total kilometers for each route to estimate the time it takes for a bus to travel between stops. This will help you determine the frequency of buses along each route.

However, since you mentioned that the company does not always meet the established frequencies, it may be helpful to also consider additional factors such as peak hours and traffic conditions. This will allow for more accurate predictions and adjustments to the schedule as needed.

I understand that this may seem complex, but with the right tools and data, it is possible to create a schedule that is reliable and efficient. If you need further assistance, I would recommend consulting with a transportation expert or using specialized software designed for scheduling public transport.

I hope this helps get you started on creating a schedule for public transport buses in your city. Good luck!