Use of Spreadsheets in Plan Sets

Purpose:  Detail the use of spreadsheets in plan sets for either:

Tables Within MicroStation

Use linked spreadsheets in MicroStation to display "smart" tables on plan sheets.

Create the table in Excel with the desired appearance. See sample spreadsheet for typical formatting and sizes.

Select the area to be included within MicroStation and name the area.

Location of named range in Excel

NOTE: There are some rules in naming ranges. The first character of a name must be a letter, an underscore character (_), or a backslash (\). Remaining characters in the name can be letters, numbers, periods, and underscore characters (no spaces). Also anything that could be interpreted as a cell reference cannot be used.

Select the named range in Excel and Copy (use <CTRL+C>, select from right-click menu, or select from the ribbon).

Go into MicroStation and Paste (use <CTRL+V>, select from right-click menu, or select from Edit menu). The following dialog should appear. Make sure the settings match. Use a scale of 1000 for a sheet drawn to 1"=100' (default).

MicroStation Paste settings

Check that the named range is being linked. From the MicroStation Edit menu select Links... and check the source. If the named range is correctly set then when the links are updated (Edit > Update Links) the whole table will update including added and deleted rows and columns.

MicroStation Links dialog

Stand-alone Plan Sheets

See the templates for spreadsheets designed to be used as final plan sheets. Preset spreadsheets are available for the following:

  • Tabulation of Quantities
  • Drainage Summary
  • Control Points

WFLHD Plans  |  Top