Excel Add-In
An Excel tool (and add-in) is provided with TIAH for those users who want to store volume data in Excel worksheets for use with TIAH. The main purpose and advantage of using this simple add-in is easy, automatic creation of the basic headings and blocks of the volume worksheet that TIAH will look for when reading the volume data.
Installing the TIAH Add-In for Excel
The add-in file is named "TIAHmacros.xla" and should be placed in the AddIns directory for Microsoft applications. The full path to that directory is typically:
C:\Documents and Settings\YourName\Application Data\Microsoft\AddIns
Once the .xla file has been placed in the appropriate directory, you will need to tell Excel about it. Depending on the version of Excel that you are using, this may go something like this:
a) Start Excel
b) Click on the Tools menu near the top of the screen
c) In the dialog box that opens after you click on Add-Ins, Browse for the file named TIAHmacros.xla that should have been placed in your AddIns directory described above. Once the file is found, your Add-Ins menu should include the "TIAH addin for Excel":
d) After installing the add-in, your Excel menus will be expanded to include a new toolbar and a drop-down (pull-down) menu named "TIAH", as illustrated below:
The pull-down TIAH menu expands to show these menu items⁄commands, essentially replicating the functionality of the new toolbar (see above):
Using the Excel Add-In
a) Place your cursor in a convenient location within the Excel worksheet and click on the AM Start button
b) Move the cursor a few cells below the previous cell and press the AM End button
c) Place the cursor directly under the "TIAH AM START" label and press the Direction Vectors button
d) Move the cursor elsewhere in the worksheet and repeat steps (a) - (c) with the "PM" buttons, if adding PM volumes to the worksheet
e) Click on the Rename button to name the worksheet according to the TIAH convention described here
The basic worksheet thus created would like similar to the one shown below:
At this point the Excel worksheet can be used to enter the intersection volumes.