Contents - Index - Previous - Next

Data Fields

Data fields specify the EMME/2 database attributes for each type of table and must be contained in a named range, as described in the Template formats section.

Each table requires a named list range, which is used by M2Assistant to create the spreadsheet. The sample templates all have named list ranges, with the name of the range depending on the type of table as follows:

Table Named Range
Centroids Centroids
Nodes Nodes 
Links Links
Turns Turns
Transit Lines (defines the range for transit lines)
Segments (defines the range for segments for each line)
Screenlines Screen
Matrices Matrix

Note that the transit table has two named ranges, with the segments nested within the transit line range. 

The data fields are placed within each named list range using the syntax xlData_DataField where DataField defines the network attribute as follows:

Centroids and Nodes
  • I - Node number
  • X - X coordinate
  • Y - Y coordinate
  • UI1 - User attribute 1
  • UI2 - User attribute 2
  • UI3 - User attribute 3
  • INBOAI - Boardings
  • FIALII - Alightings
  • LBI - Node label
     
    Links
  • I - From node
  • J - To node
  • Len - Link length
  • Mode - Modes on the link
  • Type - Link type
  • Lanes - Number of lanes
  • VDF - Volume-delay function
  • UL1 - User attribute 1
  • UL2 - User attribute 2
  • UL3 - User attribute 3
  • TimAU - Auto time
  • VolAU - Auto volume
  • VolAX - Auxiliary volume
  • VolAD - Additional volume
     
    Turns
  • I - From node
  • J - At node
  • K - To Node
  • TPF - Turn penalty
  • UP1 - User attribute 1
  • UP2 - User attribute 2
  • UP3 - User attribute 3
  • PTimAU - Auto time
  • PVolAU - Auto volume
  • PVolAD - Additional volume
     
    Transit Lines
  • LName - From node
  • Mode - Mode for this transit line
  • LDesc - Line description
  • Vehicle - Vehicle for this line
  • HDWY - Headway
  • Speed - Line speed
  • Layover1 - First layover
  • Layover2 - Second layover
  • UT1 - User attribute 1
  • UT2 - User attribute 2
  • UT3 - User attribute 3
  • NSegT - Total segments
     
    Transit Segments
  • I - From node
  • J - To node
  • TTF - Transit link function
  • TTFT - Transit turn function
  • DWT - Dwell time
  • DWFAC - Dwell time factor
  • STOP - Stop setting
  • US1 - User attribute 1
  • US2 - User attribute 2
  • US3 - User attribute 3
  • VolTR - Transit volume
  • TimTR - Transit time
  • Board - Boardings
     
    Matrices
  • 0 - Zone or group number
  • 1 - Matrix value in column 1
  • 2 - Matrix value in column 2
  • ... and so on
     
    Screenlines
  • Description - Link description / name
  • I - From node
  • J - To node
  • IJ - I -> J link volume
  • JI - J-> I link volume
     
    If any of the tables have extra attributes, an extra attribute data field can be included in the named list range. For example, if extra attribute @vol is defined for the links table, then the data field would be named xlData_extravol.