The road transport department is constantly battling with the problem of poor routing and scheduling; random criminal acts that destroy public transport vehicles - resulting in higher maintenance costs. The department is also faced with the problem of having very little data available at its disposal to track and optimize the current fleet’s performance.
The complexity of the problem further enhances when public transport vehicles start and return from multiple depots, and many of these routes are return journeys to the original depot.
Automation
Here is another Free Google App script from Zyxware. This is a simple Google Spreadsheet based Google App which we had developed in-house to manage tasks that are coordinated closely by our Project Management Office. We are releasing this utility as Free Software under a GPL license. We use Redmine as our project management system and manage all the project related tasks through redmine. However there would still have to have management / supervision effort put in to manage and review the execution of these tasks, groups of tasks and the project as a whole. This app helps us in taking care of that.