Table Linked to External Data

Integrating drawing data with external data files such as Excel spreadsheets

1. Start the Table command. Select From a Data Link (1) and click (2) to launch the Data Link Manager

2. In the Select a Link dialog box, select Create a New Excel Data Link and then enter a name for the new link

3. Browse to (1) and select the Excel document for the data link (2)

4. Choose to link to the entire sheet or to a range by specifying row and column numbers

5. Click OK to return to the Insert Table dialog box. Click OK in the Insert Table dialog box and click to place the table in your drawing

Importing Tables

Use the Windows® clipboard functionality and the Paste Special command of the software to import table data

Display properties such as fill colors and justification of the source table are maintained

The formulas and equations supported by the software are maintained

Exporting Tables

Export tables in a common format that you can process in other computers

When export a table from a drawing, it is stored in a CSV (Comma Separated Values) file

The CSV format is an universal format for tabular data and can be read by most spreadsheet

applications and other applications that are designed to manipulate tabular data

Style-related formatting, such as colors and text styles of the table, is lost because the CSV format is universal and is essentially an ASCII text file

All formulas are also removed, and only the resulting values for each formula are exported

Data Extraction Table Update

To update a table created from block attributes, need to perform a manual update

Select the table - Right-click - Update Table Data Links

Extract Attributes to Table

Data Extraction
Create schedules and tables by extracting data from blocks

1. Create a new Extraction

2. Data Source Definition

3. Object Selection

4. Select Properties

5. Data Refinement

6. Output Specification

7.Table Title and Style Selection

8. Data Extraction Templates

Block in Table

Include blocks within table cells

1. Formatting toolbar - Insert Block

2. Select the appropriate block

Adjust the properties

Field in Table

1. Formatting toolbar - Insert Field

Select the appropriate Field category

Select the Field in the Field Names list

Select the appropriate field property and formatting options

Table & Cell Properties

Table Properties

1. Changing the table style

2. Adjusting the direction

3. Adjusting the cell margins

4. Adjust Table Width & Height

Cell Properties

Change Background color

Summing Multiple Table Cells

1. Select the cell want to enter the Sum equation

2. Formatting toolbar - Formula - Sum

3. Define a window around the cells that want to include in the sum formula

Average: =AVERAGE(A1:A5)

Count: =COUNT(A1:B5)

Cell: =Table(2130477568).A5

Returns value of cell in another table

The number in parentheses is the object identifier for the other table

Equation: = A1*A5

Breaking a Table

1. Click the table gridline to select the table

2. Right-click the table - Properties. On the Properties palette, adjust the properties of the table break, as required

3. Click the triangular grip at the bottom center gridline of the table

4. Drag the grip vertically to the row where you want to break the table

5. The triangular grip points upwards and new rows are added to a second table part to the location you specified in the table properties palette

Auto-Fitting Cells

1. Select the cell

2. Click the grip in the lower-right corner of the cell

3. Drag the grip through the cells that you want to auto fill

Merging Cells

1. Define a selection window to select the cells that need to be merged

2. Click Merge Cells - by row on the Formatting toolbar

Add Column

1. Click any cell on the right end column

2. The Ribbon toolbar now change to Formatting toolbar

3. Select Add Column

Resize Move Table

Resize and move tables by using grips

1. Click & Move entire table

2. Adjust width of column

3. Adjust width of table

4. Adjust height of table

5. Click & drag to Break the table in multiple parts

6. Adjust width & height of table

Navigating and Entering Table Data

1. Double-click a cell in a table to start the In-Place Text Editor and enter the required values in a cell

2. To navigate to other cells in a table, use the TAB key to move to the right, SHIFT+TAB to move to the left, or the ARROW keys to navigate in any direction

3. Enter standard spreadsheet-style formulas in cells to reference other cells in a table

4. Can also select multiple cells using standard window selection methods

NOTE: Need to click and hold the left mouse button when define the selection window

After the cells are selected, paste a value from a copied cell into each selected cell

5. To finish editing a table, close the In-Place Text Editor or click any point in the drawing

Insert Table

1. Table Style: Select the table style

2. Insertion Behavior:

Specify insertion point

Specify window

3. Column & Row Settings:

Specify number of column, Column width

Specify number of row, row height

4. Set Cell Styles: Specify First row, Second row & All other row Cell Styles

Table Style

A table is a rectangular array of rows and columns that can contain annotation and text objects

A table contains title, column headers, and data cells

Table cells can contain formulas for performing calculations

1. Standard Table Style

2. Custom Table Style

A table style is a collection of properties and settings that use to control the appearance of tables

Archiving Sheet Sets

Packaging the drawings referenced in a sheet set into a single archival file

Drawings and other support files such as the font map file, plot style tables, and plotter configuration file are included in the archival file

eTransmit

Quickly and easily prepare an entire sheet set, sheet subsets, or individual sheets for transmitting to the members of the design team involved in the project

1. Sheets: Display the Sheet Set structural
2. Files Tree: Displays the individual files and their supporting files
3. Files Table: Displays the details about each file, such as the file path, type, version, size, and date
4. Select a Transmittal Setup
5. Transmittal Setups: Manages the available transmittal setups or creates new ones
6. View Report: Displays the transmittal package report

Sheet Set Publishing Options

Publish sheet set elements by using the options in the Publish list

Publish to DWF

Publish to Plotter

Publish using Page Setup Override:

Publishes all the sheets to the same device by over-riding the page setup configuration specified within each sheet

Sheet List Table

A dynamic list of all sheets contained in the sheet set

If sheets are added, removed, renamed, or renumbered, can easily update the sheet list table accordingly

The sheet numbers and the sheet titles are generated when the table is placed on the title sheet

Hyperlink: Ctrl + Click a sheet title in the table to open the corresponding drawing

Automating Label and Callout Data

Most drawing sets contain inter-related information

e.g. A view on one sheet may refer to a view on another sheet

Improve productivity and drawing accuracy by updating existing callout and view label blocks to include fields

Field-enabled callouts and view labels dynamically update the textual data when changes in sheet number, view number, and view title occur

Field-enabled callouts and view labels also facilitate the use of hyperlinks to open the referenced sheet and take you to the appropriate location

Adding Sheet Set Fields to Title Blocks

Edit title blocks that use sheet set fields is to temporarily include the title block as a sheet in the sheet set

Create a new sheet on the basis of the standard template file from a Sheet Set

Use New Sheet to Modify Title Block Attributes

1. Using New Sheet to Modify Title Block Attributes Access the properties of a sheet set in the Sheet Set Manager.

2. In the Sheet Set Properties dialog box, specify the sheet creation template file (DWG, DWT, or DWS) and layout containing the title block. You also need to specify the custom sheet set properties

3. In the Sheet Set Manager, create a new sheet

4. In the New Sheet dialog box, specify values for the sheet number and title

Adding Fields to Title Blocks

1. Explode the Title Block

2. Double-click a nonfield attribute

3. Edit Attribute Definition - Right-click Default Field - Insert Field

4. Field - Field Category - Field Name

Replacing Old Title Blocks

1. Block panel - Create

2. Select "Title Block" from the Name list

3. Base Point set to 0,0,0 - Select

4. Select the Title Block - OK

5. Redefined block dialog box - OK

Verifying Title Block Functionality

Create a new sheet to verify