Spreadsheet explanation (expert use only)


MobilityLabel delivers a lot of data to its clients in the mobility analyses. Apart from the interactive analyses in the MobilityAnalyst dashboard, users can make very specific custom analyses using the raw source data in the supplied Excel format. In order to make optimal use of this data, we have created this reading guide.

The data is offered at employee level in the form of the following columns:

  • person: The employee number, as provided by the employer.
  • postcode: Postcode of the (residential) address of the employee, as provided by the employer.
  • street: Street name of the (residential) address of the employee, as provided by the employer.
  • city: Place of residence of the employee’s (home) address, as provided by the employer.
  • country: Country of the (residential) address of the employee, as provided by the employer.
  • organisation filter: Extra column for an organization to provide additional information about the employee, as provided by the employer. The data provided in this columns can be used to filter specific target groups in the analysis.
  • additional info 1 and 2: Extra columns for an organization to provide additional information about the employee, as provided by the employer. These columns are not used in the MobilityLabel calculations, but can be useful for additional analyses. For example, to specify a business unit or job group, to distinguish between different groups in an organization in your own analyses.
  • destination: The address of the employee’s current work location, as provided by the employer.
  • current transport mode: The current modality as specified by the employer or modelled
  • transport mode modelled: This indicates whether calculations have been made using a modality specified by the employer (value ‘f’, for ‘false’, or whether statistical assumptions have been made about the current travel method (‘t’ for ‘true’).
  • fastest transport mode: The fastest modality based on the calculations, taking into account the transport mode fixed-input. If transport mode fixed=yes, then the current transport mode is shown here, regardless whether there is a faster modality.
  • fastest return time: Travel time for a return trip with the modality from the ‘fastest transport mode’ column.
  • fastest return distance: Travel distance for a return trip with the modality from the ‘fastest transport mode’ column.
  • car single time AM: Travel time in the morning rush hour (one way) by car.
  • car single time PM: Travel time in the evening rush hour (one way) by car.
  • car return time AM+PM: Travel time for a return trip by car, is equal to the sum of car single time AM and car single time PM.
  • car return distance AM+PM: Travel distance for a return trip by car.
  • public transport return time – wPTw: Travel time for a return trip by public transport (walking first and last mile).
  • public transport return distance – wPTw: Travel distance for a return trip by public transport (walking first and last mile).
  • public transport return time – bicycle pretransport – bPTw: Travel time for a return trip by public transport (cycling first mile, walking last mile).
  • public transport return distance – bicycle pretransport – bPTw: Travel distance for a return trip by public transport (cycling first mile, walking last mile).
  • public transport return time – bicycle pretransport and posttransport – bPTb: Travel time for a return trip by public transport (cycling first and last mile). Available in certain regions only.
  • public transport return distance – bicycle pretransport and posttransport – bPTb: Travel distance for a return trip by public transport (cycling first and last mile). Available in certain regions only.
  • bicycle return time: Travel time for a return trip by bicycle (cycling first and last mile). For cycling distances up to 5 km one way, we calculate with an average speed of a normal (city) bicycle, for longer distances, we assume the use of an e-bike or (more than 15 km) a speed pedelec.
  • bicycle return distance: Travel distance for a return trip by bicycle. Note: The cycling distance is measured on cycle paths / roads on which you can cycle. This is usually a different result from the car distance.
  • car return time freeflow: Travel time without rush hour (return trip) by car.
  • car return distance freeflow: Travel distance without rush hour (return trip) by car.
  • public transport return time – P+R pretransport – cPTw: Travel time for a return trip by public transport (using car and an official Park & Ride facility near the departure point).
  • public transport return distance – P+R pretransport – cPTw: Travel distance for a return trip by public transport (using car and an official Park & Ride facility near the departure point)

The data in the above columns can support employers in making additional policy analyses. The data after the column FOLLOWING_DATA_FOR_TECHNICAL_REASONS_ONLY is of a more technical nature and is used by the MobilityAnalyst tool to display complex employee and trip data. Exceptions to this are the following two columns that can be useful when exporting data from MobilityAnalyst:

  • affected by policy. This column indicates whether an employee has been affected by the policy set in MobilityAnalyst. This column only appears after making an export in MobilityAnalyst.
  • policy based transportmode: The modality in accordance with the measures from the MobilityAnalyst dashboard. This column only appears after making an export in MobilityAnalyst.

For further questions about the data supplied, you can always contact us at support@mobilitylabel.com

Over ons

MobilityAnalyst is een dienst van MobilityLabel, leverancier van tools voor mobiliteitsbeleid.

Contact
Support
Mail
MobilityLabel BV

Nieuwegracht 1
3512LB Utrecht – Nederland
KvK: 85840513
BTW: NL863762207B01

Launch login modal Launch register modal