Driver Summary

Internal Table Name: DriverSummary

The Driver Summary table provides information about each of the drivers used by the scheduling algorithm. This information includes cost, number of routes, and total distance incurred by the driver.

Scenario

Table: DriverSummary

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the output data was generated.

Driver ID

Table: DriverSummary

Internal Name: DriverId

The unique identifier of the specific driver. This value is a combination of the driver class, site and a unique number.

Site Name

Table: DriverSummary

Internal Name: SiteName

The site where the driver is located. The driver is assigned to sites using the Driver Availability table.

Cost

Table: DriverSummary

Internal Name: Cost

The total cost incurred for the routes assigned to this driver. This value is calculated using the costs as defined in the Drivers table.

Each driver has a schedule consisting of one or more routes. The Fixed Cost is incurred per driver, the Fixed Cost Per Route is incurred for each route per driver, and the Variable Cost Per Hour is incurred for each hour per route per driver. The Total Cost is the sum of these three cost sources.

Total Routes

Table: DriverSummary

Internal Name: TotalRoutes

The total number of routes that have been assigned to this driver.

Start Date Time

Table: DriverSummary

Internal Name: StartDateTime

The earliest date and time that a route schedule for this driver started.

End Date Time

Table: DriverSummary

Internal Name: EndDateTime

The latest date and time that a route schedule for this driver ended.

Total Duration

Table: DriverSummary

Internal Name: TotalDuration

The duration from the earliest scheduled route start time to the latest scheduled route end time.

Busy Duration

Table: DriverSummary

Internal Name: BusyDuration

The sum of all route work times in the driver’s schedule, where the work time of a route is the duration from the route’s start time to its end time.

Idle Duration

Table: DriverSummary

Internal Name: IdleDuration

The difference between the driver’s Total Duration and their Busy Duration. This is equivalent to the sum of all the time spent in between all consecutive routes in the driver’s schedule. This includes mid-shift and off-shift time. The off-shift time between routes is considered rest time. Rest time is scheduled if the time between routes can fit the rest time. For example, if the minimum rest time is 45 minutes and the time between routes is 30 minutes, no rest can be scheduled. However, if the time between routes is 60 minutes, then a 60 minute rest time is designated.

Drive Duration

Table: DriverSummary

Internal Name: DriveDuration

The sum of the drive times incurred on routes scheduled for the driver.

Duty Duration

Table: DriverSummary

Internal Name: DutyDuration

The total duration of on-duty time in the driver’s schedule. This is equivalent to the driver’s Total Duration less the duration of all scheduled rests.

Number Of Shifts

Table: DriverSummary

Internal Name: NumberOfShifts

The sum of the duty shifts required for the driver to complete the scheduled routes.

Total Distance

Table: DriverSummary

Internal Name: TotalDistance

The total distance traveled on all routes scheduled for this driver.

Scenario ID

Table: DriverSummary

Internal Name: ScenarioID

The identifier of the scenario for which the output data was generated.

Sub-Scenario ID

Table: DriverSummary

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the output data was generated.