Index of Sheets
1. Download the Index of Sheets Import Creator File
1.1 Download the "Index_of_Sheets_Import_Creator.xlsm" workbook file.
[Note: Once you select the link listed above, you will be redirected to the page for the workbook. To download the workbook, select the "Index_of_Sheets_Import_Creator.xlsm" text from that page to download the file.]
2. Completing the Index of Sheets Import Creator File
2.1. Open the "Index_of_Sheets_Import_Creator.xlsm" workbook file and select the appropriate worksheet tab from the bottom of the workbook.
[Note: If prompted with a "Macro-Enabled" message, enable the macros feature for this file.]
2.1.1. Road_IS is to be used for Highway projects.
2.1.2. Road_IS_Import gets populated after running the "Road_IS_Import_Creator" macro.
2.1.3. Bridge_IS is to be used for Bridge projects.
2.1.4. Bridge_IS_Import gets populated after running the "Bridge_IS_Import_Creator" macro.
2.2. Place a lowercase "x" in the "Display" column to indicate the sheet(s) you want to include in the Index of Sheets Table.
2.3. Add the appropriate sheet numbers in the "Sheet No(s)" column for each sheet type that is to be included in the Index of Sheets Table.
2.4. Select the "Road_IS_Import_Creator" or "Bridge_IS_Import_Creator" macro button, to populate the "Road_IS_Import" or "Bridge_IS_Import" worksheet tabs.
2.5. Save this file and exit the Microsoft Excel application.
3. Placing the Index of Sheets Table Inside of MicroStation
3.1. Open the appropriately named "Index of Sheets" design file in MicroStation Connect Edition (MSCE).
3.2. Select the "Place Table" command found under the Drawing > Annotate > Tables ribbon group.
3.3. In the "Place Table" dialog, choose the following selections:
3.3.1. Select the "From File" icon, which is the last one on right.
3.3.2. Seed - select the "All DelDOT - Index of Sheets" option.
3.3.3. Ensure that the "Annotation Lock" is enabled.
3.3.4. Active Angle - leave set to 0.0000 degrees, unless you have a rotated sheet border.
3.3.5. File Name - select the ellipsis button (...), and browse to the file you created in step 5 above.
3.3.6. In the Select Cells" dialog that appears, be sure to select the appropriate worksheet (Road_IS_Import or Bridge_IS_Import), and verify that Range is set to Automatic.
3.3.7. Contains Title Row - toggled off.
3.3.8. Contains Header Row - toggled off.
3.3.9. Retain Association - toggled on.
3.4. Place the table that gets generated in the appropriate location on the Index of Sheets sheet.