CAD/D Documentation | CAD/D Section | NH Department of Transportation

CAD/D Home > MicroStation > Right-of-Way Plan Summaries

Right-of-way summaries are generated from Excel spreadsheets that are linked to the MicroStation drawing.

There are three tables in this file:

ACQUISITION	Stores all data about the property owners on the project
PROPERTY OWNER	Used for the property layout sheet
SHEET 1	A template for the right-of-way summaries on each individual drawing

Procedure In Excel

Copy the Excel seed file into the project directory. Rename it so the name includes the project number.

Imperial: N:\cadd\cadd\workspace\standards\seed\row_tables_f.xls
Metric: N:\cadd\cadd\workspace\standards\seed\row_tables_m.xls

Edit the ACQUISITION sheet to add parcel data including all take and easement information. Parcel numbers on this table can be modified. If new rows are added be aware that some columns contain formulas that will need to be copied from other rows.

Edit the parcel number column of the PROPERTY OWNER sheet. All other data should be retrieved from the ACQUISITION sheet as you modify the parcel numbers.

Excel Move or Copy Shortcut Copy the "Sheet 1" table for each drawing that will have parcel data. Copy the table by right-clicking on the sheet label and select "Move or Copy Sheet..." from the popup menu. Highlight "(move to end)" to make the new sheet the last sheet. Make sure the "Create a copy" box is checked.

Label each new sheet appropriately. Edit the parcel number column of each sheet. The remaining data will be retrieved from the Acquisition table.

Putting Sheet Summary Tables Into MicroStation In MicroStation it is necessary to create the links in a dgn dedicated to that purpose and then reference the EXL dgn to the individual cut sheet drawings.

Open the project file #####EXL.DGN or create it if it doesn't already exist.
Select the "SHEET 1" spreadsheet and copy the sheet.
In the EXL dgn file select Paste Special... from the Edit menu.
Note that in MicroStation/J there is a limit to the amount of information that can be pasted. It may be necessary to copy & paste a number of smaller size sections.
Select the location for the summary table.
Repeat for each sheet.
To simplify the process of referencing the EXL dgn to the cut sheets, a saved view should be created for each sheet summary table.
- Draw an area around the individual sheet summary box.
- Save the view by using the Saved Views command on the Utilities menu. Give the view a name and description then save it.
- Repeat for each summary box.
Open each ROW cut sheet drawing and attach the appropriate saved view from the EXL dgn file.
Use the Scale option in the reference file dialog box to adjust the size of the summary box.

Procedure In Excel

Related Documents