Website Name - an official New Hampshire Government website
Smaller text size Reset text size Larger text size
link to website translation page
CAD/D HomeMicroStationMXOpenRoadsDownloadsSearchNHDOT Homelink to website translation page

Right-of-Way Plan Sheet Summaries

Right-of-way summaries for individual plan sheets are cells that are added to the MicroStation drawing.

Copy copy two cells onto each cut sheet:

  1. ROWSUM which contains the outline for the right-of-way information.
  2. ROWSUMTXT which contains placeholders for the text that will go on the summary cell. The text is already formatted for use within the ROWSUM cell. Make a copy of this cell for each individual parcel on the drawing.

Edit the text in the ROWSUMTXT cell to add property information.

Procedure In Excel

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

move or copy dialog boxCopy the Excel seed file into the project directory. Seed files are found under the \standards\seed\ folder of the MicroStation workspace. Rename it so the name includes the project number.

  • Imperial: row_tables_f.xls
  • Metric: 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.

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.

New Hampshire Department of Transportation
PO Box 483  |  7 Hazen Drive  |  
Concord, NH  |  03302-0483
Tel: 603.271.3734  |  Fax: 603.271.3914