Page 1 of 1

RAW DATA AND TIME STAMP

PostPosted: Fri Feb 26, 2016 1:47 pm
by trafficdata2000
Greg, is there a way that one can export trimmed raw data running by the second from the program after the data has been imported and used to generate a report? Also, is it possible to export only time stamps that show the times as the vehicle passes through every intersection? I have attached some samples.

Re: RAW DATA AND TIME STAMP

PostPosted: Fri Feb 26, 2016 11:44 pm
by bullock
Hi.

To export a trip log to a text file (which can be opened in, say, Excel) with second by second data, navigate to GPS View, then right-click on a trip log and choose Export: Export Trip Log..., then change the file type to either TSV or CSV

To export only time stamps that show the times as the vehicle passes through each intersection,
  1. Generate a Travel Time & Delay Report
  2. Select the desired Details tab that you want to export.
  3. Click the Save button at the top of the report.
The resulting HTML file may be opened in, say, Excel for further analysis.

If you wish, you may first prune the list of columns to show only the columns of interest. To do this, use View: Preferences...: Layout: TT&D Report: Report Columns, and uncheck the columns you don't need.