Rural transport administration

Rural Transport Administration System

The system for rural transport passenger barcoding and administration.

The system automates the RTP data gathering and reporting (required by Pobal).

It has the following features:
• Provides an alerts dashboard for licences, DOE’s, H&S, Midas, MEPS etc.
• Produces passenger barcode lists per route for drivers.
• Collects passenger activity using driver barcode readers and email.
• Produces and tabulates detailed reports on each passenger trip per route.
• Produces sign off sheets for Operators.
• Produces complete summary sheets for Pobal PMS.
• The summary sheets can be scanned straight into the PMS system.
• Options are available for GPS route mapping directly from Google maps.
• Options are available for passenger pickup / itinerary planning.

It is designed to be simple to use with a “do everything” /autopilot button. It runs on standard Excel 2007 or higher. Help files are available on the internet. The system is in use with 5 Rural Transport groups.

System requirements are Windows PC / Network with MS Excel 2007 or higher.

Shown below are some screenshots:

The Control Panel

The user enters the date parameters under review and presses the "Do everyting" button.
The Control panel may also be used for opening associated files and running parts of the program manually.
This can be very useful if the user wants to make corrections.

Part of Decoded Passenger List with 59606 records

An automatic report from one of the routes

These reports generated in pdf are used as "sign off" sheets to confirm the operation.

An automatic route report from HSE disability transport

This information is even more critical as it lets the HSE administrator confirm the well being of a passenger at a glance. (The fact that the passenger is attending the center on a regular bassis.)

The mapping Option

Much of the route mapping can be done without having to leave the office.
Points along a route can be added straight from Google maps as latitude and longitude.
A polynomial regression line joins the points entered.
The more points added the more accurate the curve is to the route.
Each point can represent a pickup location.
The lat long can be fed directly into a GPS Sat Nav.
(Note replace the "minus" longitude with E or East.)
It is recommended to drive the actual route with the driver as a cross check.

The booking Option

Making bookings for a route.
The route number can be entered in the top left cell.
This will bring up a list of the passengers and their phone numbers in pickup order.
Each passenger can either be called or sms texted to confirm their travel plans.
As replies come in you can make the an entry on the sheet under the date / passenger matrix.
1 represents a one way trip inbound.
2 represents a 2 way return trip....usual.
3 represents a one way trip homebound.
When completed the sheet can be saved as a pdf and emailed to the driver.
The driver can either print or view on a smartphone.