Create a custom table combining extracted and linked data

00:04

Now you are ready to create a table containing the extracted piping system data

00:10

on the insert ribbon

00:12

in the linking and extraction panel, click extract data

00:16

to start the data extraction wizard

00:20

on the first page of the wizard

00:22

ensure that create a new data extraction is selected

00:26

and then click next

00:30

in the save data extraction as dialogue,

00:33

navigate to the folder in which you want to save the extraction file,

00:37

the data extraction template

00:40

in the name field type cost underscore est

00:46

and click save

00:49

on the defined data source page.

00:52

Since the data is actually coming from an external reference

00:56

clear the include current drawing checkbox,

00:60

then click add drawings,

01:03

navigate to the folder containing the exercise files,

01:07

select civil lines dot DWG

01:11

and click open

01:14

then back in the wizard. Click next

01:18

on the select objects page,

01:21

right? Click in the objects list and choose uncheck all

01:26

then select the check boxes adjacent to arc

01:30

line

01:31

and polyline.

01:32

Since these are the only types of objects you are concerned with in the drawing

01:38

in the display name column, right, click arc,

01:42

choose edit display name

01:44

and change the display name to pipe.

01:49

Repeat this to change the display name for line and polyline also

01:54

because all the arcs lines and poly lines in the silver lines,

01:58

drawing represent pipes

02:01

rather than right clicking. You can simply click the display name cell and then type

02:07

once you have changed all three display names, click next

02:13

on the select properties page,

02:15

right. Click in the properties list and choose uncheck all

02:21

then scroll down and select the check boxes adjacent to layer and length

02:27

since each type of pipe was drawn on its own layer

02:31

and all you care about is the length of those objects.

02:35

Then click next.

02:38

If you see a warning informing you that

02:40

non uniformly scale blocks cannot be extracted.

02:43

Click OK.

02:45

Since you are not extracting any block data

02:49

on the refined data page,

02:52

make sure that combine identical rows and show name column are selected

02:58

and that show count column is not selected.

03:03

Then

03:04

click link external data to open the link external data dialogue

03:10

in the data link group box, expand the drop down and select cost underscore data

03:18

in the data matching group box, expand the drawing data column,

03:22

drop down and select layer

03:25

then expand the external data column, drop down and select piping systems

03:32

to match the layer information in the drawing with the piping system data.

03:36

In the spreadsheet,

03:38

click check match,

03:41

you should see a dialogue verifying that the key pairing was successful.

03:45

Click OK? To close that dialogue

03:50

back in the link external data dialogue

03:53

in the additional columns for data table group box under select

03:57

external data columns to include clear the piping systems check box

04:03

because the only information you need to get from the spreadsheet is the cost.

04:09

Then

04:09

click OK. To close the dialogue

04:14

back on the refined data page of the wizard, right?

04:17

Click in the cost column and choose insert formula column

04:21

to open the insert formula column, dialogue

04:26

in the column name field type sum.

04:29

Then in the columns list

04:31

double click cost to add it to the formula field

04:36

below this field, click the asterisk button.

04:40

Then in the columns list double click length,

04:44

you have just created a formula that multiplies the cost by the length,

04:48

click validate.

04:51

You should see a dialogue confirming that the equation you entered is valid.

04:55

Click OK to close that dialogue

04:58

and then click OK to close the insert formula column, dialogue

05:04

back in the wizard.

05:05

The sum column now displays a formula symbol

05:08

indicating that this is now a formula column,

05:13

right? Click the length column header and choose combine record mode some values.

05:20

This group's similar layer values based on the display name

05:25

and list the sum of the columns.

05:27

So that rather than seeing the length for each individual section of pipe,

05:31

you see only the sum of the lengths of pipe on each layer,

05:37

right, click the sum column header and choose insert totals footer

05:42

sum.

05:44

The total cost now appears at the bottom of the sum column.

05:49

Click next

05:52

on the choose output page, select insert data extraction table into drawing

05:58

and then click next

06:01

on the table style page.

06:04

In the table style group box,

06:06

you can select an existing table style or define a new one

06:10

for this exercise. Leave the table style set to standard

06:15

in the formatting and structure group box under enter

06:19

a title for your table type cost estimate.

06:25

Then click next

06:28

on the finish page, click finish

06:32

the program prompts you to specify the insertion point for the table.

06:36

And as you move the cursor, you see a preview,

06:40

click to insert the table.

06:43

The drawing now contains a table that shows the

06:45

price quantity and cost for each type of pipe

06:49

as well as the total cost for all the pipes.