Trip Summary Report Column Headers

The Trip Summary Report contains two parts. Both show details of the selected trips with the first part while the second part shows the average values per trip.

Table 1. Trip Summary Report Column Headers - First part
Heading Description
SEQN Number identifying the trip in the Trips table in the database.
Start Start time of the trip.
Tot Pass Total number of passengers who boarded during the trip.
Pass Mile/KM Total number of passenger miles/kilometers calculated for the trip.
Pass/KM

Number of passengers boarding per mile/kilometer = (TotPass)/(TripLength)
Trip/Hour Time taken to complete the trip: (Trip end time - Trip start time)
Pass/Hour

Number of passengers boarding per hour of the trip = (TotPass/Trip Hour)
Avg Pass Trip Length (Length) Average distance traveled by passengers: (Pass Mile/Km/(TotPass)
Trip Length Total distance of the trip.
Max Load Maximum load value recorded for the trip.
Veh Cap Seating capacity of the vehicle for the trip.
Load Fact Ratio of passengers carried to vehicle capacity: (MaxLoad)/(VehCap)
Max Load Point Stop where the maximum load was recorded.
% Over Cap Percent at which the seating capacity is exceeded for the trip:
[(MaxLoad - VehCap)/(VehCap)] * 100
Last Checked Date when the trip was last checked.
The following table describes the contents of each column in another format:
Table 2. Trip Summary Report Column Headers - Second part
Heading Description
First column The first column shows which values are being shown on the succeeding columns based on the selected period and the trips checked :
  • Avg Per trip - Average passenger load within that period across the number of checks that were performed
  • Counted Boarding - Total number of passengers who boarded within that period across the number of checks that were performed.
  • Factored Boarding - (CountedBoardings) * (total number of schedule trips)/(total number of survey trips)
  • Rev (Revenue) Hours - Total number of revenue hours for survey trips

The description of Avg. Per Trip, Counted Boardings, Factored Boardings, and Rev. Hours is the same for each period but applied across the total number of checks for the entire route.

The first four segments of data are broken down into periods:
  • Period AM Peak
  • Period Mid Day
  • Period PM Peak
  • Period Off Peak

(You define the periods in the Enter Parameters dialog box before you generate the report.)

The last set of values shows the total for the selected line (Route Totals):

X = Total number of survey trips across the four periods

Y = Total number of scheduled trips across the four periods
Tot Pass
(CountedBoardings)/(the number of survey trips)

Total boardings of all survey trips

(TotPassCountedBoarding) * (the total number of schedule trips)/ (the total number of survey trips)

(TotPassCountedBoarding)/(the total revenue hours of survey trips)
Pass Mile/KM
(PassMileCountedBoarding)/(the number of survey trips)

Passenger miles/kilometers of all survey trips

(PassMileCountedBoarding) * (total number of schedule trips)/(total number of survey trips)

Pass/Mile (Avg. Per Trip)
TotPass (Avg. Per Trip)/TripLength (Avg. Per Trip)
Pass/Hour (Avg. Per Trip)
(TotPassCountedBoarding)/(TotPassRevHour)
Avg Pass Trip Length (Avg. Per Trip)
PassMile (Avg. Per Trip) /TotPass (Avg. Per Trip)

Trip Length (Avg. Per Trip)
(Total schedule trip distance)/(the total number of survey trips)
Max Load (Avg. Per Trip) Average maximum load

Veh Cap (Avg. Per Trip)

Average vehicle capacity from bus stop table in the database
Load Fact (Avg. Per Trip) MaxLoad/VehCap
% Over Cap (Avg. Per Trip) [(MaxLoad – VehCap)/VehCap] * 100