Menu Content/Inhalt
Home arrow TIAH and Excel
TIAH and Excel
Using TIAH with Excel Data

TIAH can read volume data saved by Traffix, Synchro, HCS200, SITE/TEAPAC, as well as volumes stored in Excel. TIAH can read Excel-stored volumes directly (see TIAH Help). Alternativley, one can export volume data from Excel to Traffix format and then use the resultig files as Traffix volume files (see example below). 

1. In Excel, format your data columns like in the example below:

 tiah-excel

2. Select and Copy the area shown above in blue to a temporary worksheet:

3. Save the TEMP worksheet as a .PRN file:

4. Repeat steps 2 and 3 for the PM peak data file (if applicable)

5. (Optional) - rename the saved files to .TXT (from .PRN) and you are ready to use your volume data in TIAH.

Note that in this method you'd need to tell TIAH that the source files are in Traffix format (TIAH 3 and higher)..