Transit Matrix

Internal Table Name: TransportationPaths

You can optionally define overrides to the calculated travel time or distance or both between pairs of locations. Additionally, you can define a Cost to override the cost calculated based on the defined Rate records.

Source

Technology: All

Table: TransportationPaths

Internal Name: SourceName

Type: Short Text (100)

The identifier of the source location. You can also enter a site or customer group.

Destination

Technology: All

Table: TransportationPaths

Internal Name: DestinationName

Type: Short Text (100)

The identifier of the destination location. You can also enter a site or customer group.

Mode

Technology: NO IO S

Table: TransportationPaths

Internal Name: ModeName

Type: Short Text (100)

Select the mode used on the transportation path.

Asset

Technology: All

Table: TransportationPaths

Internal Name: AssetName

Type: Short Text (100)

The specific asset type to which the override applies.

Override Cost

Technology: TO

Table: TransportationPaths

Internal Name: Cost

Type: Currency

The cost to travel from the origin to the destination location. This value overrides the cost calculated based on the Rate table.

Default: 0

Additive Cost

Technology: TO

Table: TransportationPaths

Internal Name: AdditiveCost

Type: Currency

A cost to be added to the cost calculated based on the Rate table for travel from the origin to the destination location. This cost can be used to model tolls on specific route segments. The resulting cost will be reflected in the Route Summary and Segments output tables.

Default: 0

Travel Time

Technology: All

Table: TransportationPaths

Internal Name: TravelTime

Type: Short Text (50)

The time, in days, required to travel from the origin to the destination location. This value overrides the calculated travel time. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Default: 0

Travel Time Factor

Technology: All

Table: TransportationPaths

Internal Name: TravelTimeFactor

Type: Number (Float)

Enter the factor by which the Travel Time should be adjusted for use in calculating times on routes. In this way, you can adjust the times returned by the Distance Matrix Calculator as required.

For example, if you set the Travel Time to 0.5 DAY (or 12 hours), and you set the Travel Time Factor to 1.2, the calculated travel time is .5 DAY x 1.2 = .6 DAY (or 14.4 hours).

Distance

Technology: All

Table: TransportationPaths

Internal Name: Distance

Type: Short Text (100)

The distance from the origin location to the destination location. Enter a value, then optionally select a distance unit of measure. If you do not select a unit of measure, the default Distance Unit Of Measure from Model Settings is used. This value overrides the calculated distance. By default, the calculated distance is the straightline distance multiplied by the Distance Circuity Factor as defined in the Transportation Optimization Options. The default for this factor is 17%.

Default: 0

Is Symmetric

Technology: All

Table: TransportationPaths

Internal Name: IsSymmetric

Type: Bit

One of Yes, No. (Actual database values are 1,0.)

Set this to Yes if travel time, distance, cost from origin to destination are all the same as from destination to origin.

Default: Yes

Status

Technology: All

Table: TransportationPaths

Internal Name: Status

Type: Short Text (50)

One of Include, Exclude.

Use this field to determine if Transportation Optimization should consider the Transit Matrix record.

Default: Include