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.
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).
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.
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