IntroductionWelcome| 00:04 |
Welcome to the AutoCAD 2013 Data
Management Workshop, with me, Scott Onstott.
| | 00:09 |
I was educated as an architect, and began
using AutoCAD over 22 years ago.
| | 00:15 |
I decide early in my career to focus on
education, and I've taught many classes,
| | 00:18 |
and also written and edited numerous
books on AutoCAD, and many of the other
| | 00:22 |
programs technical and creative people
use.
| | 00:26 |
The data management workshop is for those
wanting to build intelligence into
| | 00:30 |
drawing objects, so that the symbols used
in your drawings carry meaning beyond
| | 00:34 |
simple geometric representations.
You'll learn how to embed manufacturer
| | 00:39 |
model and pricing data into commonly used
blocks so that your drawings become
| | 00:43 |
intelligent databases of relevant
non-graphical information.
| | 00:49 |
This process begins by designing
attribute definitions to store whatever
| | 00:53 |
types of information you wish, from
numerical to text-based data.
| | 00:58 |
You will then create invisible attributes
that embed data and geometry without it
| | 01:01 |
appearing in the drawing area.
This invisible data can ultimately appear
| | 01:06 |
in tables and other documentation
associated with the drawing.
| | 01:10 |
Next you will learn to utilize field
codes to display information from
| | 01:14 |
AutoCAD's database inside text objects.
So that this nongraphical data can be
| | 01:19 |
made visible.
Finally you will format, edit and extract
| | 01:23 |
attribute data.
For use in external spreadsheets, and/or
| | 01:27 |
display within tables in AutoCAD
drawings.
| | 01:32 |
So if you want to harness the database
capabilities of AutoCAD to create
| | 01:35 |
intelligent drawings that record more
than lines, rectangles, and circles, this
| | 01:38 |
course is for you.
You don't need to know anything about
| | 01:43 |
databases or programming.
Everything is accomplished from the
| | 01:46 |
convenience of the AutoCAD environment.
| | 01:48 |
| | 59:59 |
(music playing)
| | Collapse this transcript |
|
|
1. Getting StartedWhy data management is important in AutoCAD| 00:02 |
Managing non-graphical text and numeric
data in AutoCAD incorporates many
| | 00:06 |
disparate elements, including text
styles, attributes, blocks, fields, and tables.
| | 00:12 |
By learning how data is passed between
these elements, you'll be able to
| | 00:16 |
structure your drawings to link both
graphical data, such as lines, arcs,
| | 00:20 |
rectangles and so on, with associated
non-graphical data, such as text and numbers.
| | 00:27 |
Open the completed project file which is
called Office 14 and take a look at it.
| | 00:32 |
This is but a fragment of a larger
hypothetical office furniture plan.
| | 00:36 |
But it contains everything you will need
in order to learn how to manage data in AutoCAD.
| | 00:41 |
You'll begin the process of creating this
project by designing a textile and
| | 00:46 |
attribute definitions, which will
ultimately be used to store relevant data
| | 00:51 |
when they are inserted with furniture and
room tag blocks.
| | 00:57 |
For example, each piece of furniture has
hidden attributes.
| | 01:01 |
(audio playing) I'll double-click on this
armchair (audio playing) and you can see these
| | 01:05 |
two attributes (audio playing) price and
manufacturer.
| | 01:10 |
They store this non-graphical information
within the block.
| | 01:14 |
There's also a room tag block right here
which shows the room number and the last
| | 01:18 |
name of the employee who works in the
room.
| | 01:24 |
By double-clicking on the block, you can
access its attribute values, which can be
| | 01:28 |
easily changed.
(audio playing) Underneath the room tag block,
| | 01:34 |
there's a floor area which is displayed
as a field.
| | 01:39 |
This is linked to a hidden boundary
object.
| | 01:42 |
You will finally extract link and present
both visible and hidden data in a
| | 01:46 |
furniture schedule (audio playing) using
AutoCAD's spreadsheet like table
| | 01:50 |
functionality on the drawing.
Thus, you will learn how embedded
| | 01:56 |
non-graphical information follows a
circuitous path as it flows from one data
| | 02:00 |
structure to another.
In the end, you will create a project
| | 02:05 |
managing the complexity of interlinked
graphical and non-graphical data.
| | 02:10 |
| | Collapse this transcript |
| How to use the project files| 00:02 |
Every chapter in this workshop comes with
a set of project files.
| | 00:06 |
These are organized in folders
corresponding with the chapter names.
| | 00:10 |
So, for example, I'll open Designing
Attributes and Storing Attribute Data.
| | 00:15 |
This chapter contains a number of AutoCAD
drawings which are numbered sequentially.
| | 00:20 |
It also contains a My Files subfolder.
This is where you'll be saving your own work.
| | 00:27 |
Take special care not to overwrite any of
the existing files in the chapter
| | 00:31 |
folders, and always save your work in the
My Files subfolders.
| | 00:36 |
Double-click on Office 1 to see where the
project begins.
| | 00:43 |
If you'd like to take a look at where the
project ends up, at the end of all three
| | 00:48 |
chapters, go ahead and Open, go up a
level, and go into the Extracting,
| | 00:52 |
Linking And Presenting Data In Tables
folder.
| | 01:00 |
And then open the highest-numbered file,
which is Office 14.
| | 01:06 |
Let's go back to the open dialog box.
I recommend saving the project files
| | 01:13 |
folder over here on the left.
To do that, go up a level, and then go up
| | 01:19 |
another level, until you can see the
project files folder.
| | 01:24 |
Drag it over here onto the left, and
drop.
| | 01:28 |
Then you'll have a link which will take
you directly to the chapter folders.
| | 01:34 |
So let's get started.
| | 01:35 |
| | Collapse this transcript |
|
|
2. Designing Attributes and Storing Attribute DataChapter overview and exploring how attributes function| 00:02 |
In this chapter, you'll create a number
of blocks containing attribute
| | 00:05 |
definitions that each stores specific
pieces of data relevant to the block in question.
| | 00:11 |
For example, you'll create price and
manufacturer attributes that hold these
| | 00:15 |
pieces of non-graphical information
related to that specific piece of furniture.
| | 00:22 |
This is what it looks like when I
double-click on this piece of furniture.
| | 00:25 |
(audio playing)
It opens the Enhanced Attribute Editor,
| | 00:28 |
and I can see that it has two (audio playing)
editable attributes, price, and manufacturer.
| | 00:34 |
Each of these attributes store a specific
value related to that piece of furniture.
| | 00:41 |
In addition, you will create room tag
blocks, that display the room number and
| | 00:44 |
employee name who works in that room.
These pieces of data can be altered by
| | 00:50 |
editing the block's attribute values,
either when the block is inserted into
| | 00:53 |
the drawing initially or later in the
design process when this specific
| | 00:56 |
information is known.
For example, I'll insert a room tag block
| | 01:03 |
into this office over here.
(audio playing)
| | 01:09 |
Because it's designed with attributes, we
are prompted to enter the room number
| | 01:14 |
(audio playing) which in this case is Room 103.
And the employee's last name.
| | 01:25 |
(audio playing) Once that data is input, it
appears in the room tag block.
| | 01:30 |
If you don't know the employee's name or
if that changes, later in the design
| | 01:35 |
process, you can double-click on the
attributed block (audio playing) and then edit
| | 01:40 |
the information.
(audio playing) I can change this (audio playing) to a
| | 01:46 |
different last name for example (audio playing)
and the information is updated.
| | 01:51 |
You will begin this chapter by creating a
text style to control the appearance of
| | 01:55 |
attribute text.
You will continue defining attributes,
| | 01:59 |
including them in blocks, inserting the
blocks, arranging the furniture in the
| | 02:03 |
offices, and finally, entering attribute
values.
| | 02:07 |
| | Collapse this transcript |
| Configuring a text style for attributes| 00:02 |
Attributes are text or numerical data
associate with the geometry of blocks.
| | 00:07 |
Attributes can appear as visible text in
a drawing or invisible data that can
| | 00:11 |
later be extracted into a spreadsheet or
table.
| | 00:15 |
Before we get started in defining
Attributes, we will create a text style
| | 00:19 |
to control the appearance of the
Attribute data we anticipate creating.
| | 00:24 |
This text style is the first step in data
management, because it will set us up for
| | 00:28 |
creating attribute definitions.
Which will ultimately be included in
| | 00:32 |
blocks and filled with values, which in
turn, will be extracted and presented in tables.
| | 00:39 |
Go ahead and open the Office 1 project
file to begin.
| | 00:43 |
Switch to the Drafting and Annotation
workspace if it's not already current.
| | 00:47 |
Then go to the Annotation panel and
expand the slide out.
| | 00:54 |
Click this first icon to open the Text
Style Dialog Box.
| | 01:00 |
And create a new Text Style.
Give it the name Attributes.
| | 01:07 |
And click OK.
Select a font name from the list.
| | 01:14 |
Scroll down and choose Simplex.
It's an AutoCAD shape font and it's very
| | 01:23 |
simple and clean.
Change the height to 3 inches and also
| | 01:29 |
specify a narrower width factor.
Highlight the value and change it to 0.9.
| | 01:38 |
Click Apply and Close.
Click the Save As icon on the Quick
| | 01:45 |
Access toolbar and save your work in My
Files subfolder.
| | 01:52 |
Take care not to overwrite the existing
sample files and save your work as Office 2.
| | 02:03 |
In this lesson, you've created a textile
to configure the appearance of attribute data.
| | 02:08 |
You specified a font, text type, and
width factor, to create clear and
| | 02:12 |
readable attribute data.
| | 02:14 |
| | Collapse this transcript |
| Drawing block geometry and testing it with text| 00:02 |
Every room in the typical office project
that we are working on will have a room
| | 00:05 |
number and the name of an employee who
works in that room.
| | 00:09 |
We will design a block that displays
these two key pieces of text inside two
| | 00:13 |
rectangles, so that the eye has a common
visual element with which to associate
| | 00:17 |
this information.
Before we define the attributes
| | 00:22 |
themselves, we will test how their values
will look with single line text.
| | 00:27 |
In this lesson you will write some text
using the attributes text style, and then
| | 00:31 |
fit it into a rectangle.
Open the office two project file, and
| | 00:36 |
zoom in to this office that already
contains some furniture.
| | 00:44 |
Go up to the Annotation panel, and open
the Text fly out.
| | 00:47 |
Select Single Line Text, and click some
arbitrary point over here on the side of
| | 00:53 |
the desk.
Press Enter to accept the default
| | 00:58 |
rotation angle of the text, and type in
the word ROOM in capital letters, space, 100.
| | 01:07 |
Enter Enter to end the text command.
Now I'd like to place a rectangle around
| | 01:13 |
this text.
Let's measure how large it is.
| | 01:19 |
Click the Measure tool on the Utilities
panel.
| | 01:23 |
And then click a point over here
somewhere.
| | 01:25 |
Turn on Ortho on the status bar.
And as you move the cursor over here,
| | 01:30 |
you'll see the tooltip reads that it's
about two feet.
| | 01:37 |
If we go up, we'll see that the height is
about six inches or so.
| | 01:43 |
So let's create a rectangle that's two
feet wide and six inches high.
| | 01:48 |
Press Esc to cancel out of the measure
geometry command, and click the Rectangle
| | 01:52 |
tool here on the Draw panel.
Click some arbitrary point down here.
| | 02:00 |
And then specify the other end of the
rectangle by inputting relative Cartesian
| | 02:05 |
coordinates on the keyboard.
That is, type the @ symbol, to indicate
| | 02:11 |
relative coordinates, and then type two
feet, comma six.
| | 02:18 |
To specify the x, comma y coordinate
values.
| | 02:23 |
Press Enter.
Next, I'd like to move the text inside
| | 02:26 |
the rectangle so it's centered.
Select the text object.
| | 02:31 |
Type pr to open the Properties palate.
And change the justify option from left,
| | 02:41 |
to middle center.
Press Esc to deselect.
| | 02:48 |
Then move, select the text, press Enter.
And we want to move it from its
| | 02:56 |
justification point, which is known as
the insert snap.
| | 03:01 |
So hold down the Shift key, right-click,
and choose Insert from the Snap context menu.
| | 03:08 |
Then click on the text, turn off Ortho.
Turn on object snap, right-click, and
| | 03:16 |
choose Midpoint, to make sure that's on.
And also, turn on object snap tracking on
| | 03:24 |
the status bar.
Position the cursor over this midpoint,
| | 03:32 |
and move it horizontally, to acquire a
tracking line.
| | 03:38 |
Then position the cursor over this
midpoint, and move it upward, to acquire
| | 03:42 |
a vertical tracking line.
You keep moving it up, eventually you'll
| | 03:46 |
find the point where they intersect.
It's at that moment that you should
| | 03:51 |
click, and complete the move command.
So now the text is perfectly centered in
| | 03:57 |
the rectangle.
Thinking this through, I'd like the
| | 04:00 |
attribute to just be the number.
But I want the text object to always say
| | 04:03 |
ROOM, so that when we see this symbol, we
know we are looking at a room number.
| | 04:08 |
If I double-click on it, I can edit the
text, and I can select the space and the 100.
| | 04:19 |
Press Delete and get rid of it.
And then click outside, to end the
| | 04:24 |
editing operation.
However, the text becomes centered again,
| | 04:29 |
and there's no space for the room number.
So that's not what I want to do.
| | 04:34 |
Undo.
What I really want to do is change the
| | 04:37 |
justify option on this text.
Let's try that next.
| | 04:44 |
Select the text.
Change justify to middle left.
| | 04:48 |
But do you see what happens?
The insertion point stays the same, and
| | 04:58 |
then the text moved over.
So this isn't what I want either.
| | 05:02 |
Escape, and undo.
Instead, there is a way to do this,
| | 05:08 |
without having to guess at the position
of the text.
| | 05:13 |
Go to the Express tools tab.
And select the Modify Text fly out.
| | 05:21 |
And choose Justify.
Select the text, press Enter, and choose
| | 05:28 |
ML, for middle left.
That's all there is to it.
| | 05:33 |
The justification point was moved over,
while the text remained in the same position.
| | 05:39 |
Double-click to edit the text.
And then get rid of space 100, then click
| | 05:46 |
outside, then press Enter.
Our room tag will have two rectangles,
| | 05:53 |
above and below, to represent not only
the room number, but also the employee's
| | 05:57 |
last name.
In this way, the symbol will display both
| | 06:02 |
the room number and the employee's last
name.
| | 06:05 |
Two key pieces of information relevant
for every office.
| | 06:08 |
This will make managing room data easier
an more efficient, by displaying two key
| | 06:12 |
pieces of information in one symbol.
So let's go ahead, click on the Home tab,
| | 06:17 |
click the Copy command on the Modify
panel, copy this rectangle, press Enter.
| | 06:26 |
Grab it from this end point, and snap it
down here.
| | 06:31 |
Press Enter, to complete the command.
So now we've completed the layout of this
| | 06:37 |
particular room tag block.
By creating placeholder text, you are
| | 06:42 |
able to design the geometry surrounding
two planned attribute definitions.
| | 06:48 |
So that they will fit properly within the
available space.
| | 06:50 |
| | Collapse this transcript |
| Defining a series of attributes with different modes| 00:02 |
You can create attributes to store any
type of text or numerical data that you
| | 00:05 |
want to attach to blocks.
By storing these types of information,
| | 00:10 |
attributes allow you to manage
non-graphical data in your drawings.
| | 00:15 |
In this lesson, you'll define a series of
attributes to hold specific pieces of
| | 00:19 |
data using a variety of modes, which
determine whether the attributes are
| | 00:23 |
visible or invisible, constant, preset,
or require user verification.
| | 00:29 |
Open the Office 3 project file and click
the Insert Tab on the ribbon.
| | 00:36 |
In the Block Definition panel, click
Define Attributes.
| | 00:42 |
I'll drag this dialog box out of the way.
And let's first define an attribute that
| | 00:47 |
stores the employee's last name, and it
will go inside this rectangle down here.
| | 00:53 |
Every attribute has to have a tag and a
prompt.
| | 00:57 |
The tag is the programming name, and it
must appear in all capital letters with
| | 01:01 |
no spaces.
So, in this case, I'll type LName.
| | 01:09 |
The prompt describes what we're asking
for.
| | 01:12 |
So, I'll type employee's last name.
The default value is optional.
| | 01:23 |
In this case, I will leave it black
because everyone will likely have a
| | 01:26 |
different last name.
Justification will be centered here in
| | 01:31 |
the middle of this rectangle, so let's
select middle center.
| | 01:37 |
We will use the attributes text style,
and specify the insertion point on screen.
| | 01:46 |
Okay, zoom in here.
Make sure object snap tracking is on, and
| | 01:53 |
midpoint object snap is running.
Position the mouse over this midpoint and
| | 01:59 |
move it up to get a vertical tracking
line.
| | 02:04 |
Then position the mouse over this
midpoint and move it back horizontally
| | 02:07 |
until you see the intersection point of
the tracking lines appear.
| | 02:13 |
Then click and you've completed the
process.
| | 02:18 |
You've created an attribute definition.
Let's make another one up here, to store
| | 02:23 |
the room number.
Click define Attributes, an type the tag
| | 02:28 |
name, room N O.
Press the Tab key to move to the next
| | 02:34 |
text box, and type room number.
This time, let's enter a default value of 100.
| | 02:48 |
The text should be justified, so that it
will fit here and let's go ahead and
| | 02:54 |
chose Middle Left.
Click OK and track both midpoints to
| | 03:03 |
where they intersect.
Now, we need to move this over.
| | 03:09 |
Type M, Enter, select the attribute
definition, click some arbitrary point,
| | 03:16 |
and then turn on Ortho, so you can slide
it horizontally.
| | 03:24 |
Click a point about here to slide it
over.
| | 03:28 |
Now, it doesn't matter that the tag name
spills out of the rectangle, because
| | 03:33 |
ultimately this attribute will display
the value of three digits, and it should
| | 03:37 |
fit perfectly inside this rectangle.
Let's zoom out, and design some more
| | 03:45 |
attributes, this time for this piece of
furniture.
| | 03:51 |
Click Define Attributes, and type price
in all caps for the tag name.
| | 03:58 |
Press Tab, and type that in title case.
The default value will be $1,000, but we
| | 04:05 |
won't use the dollar symbol we'll just
use a number.
| | 04:11 |
Justification can remain left, but this
attribute should be invisible, so check
| | 04:17 |
that mode.
It's also an important attribute, so lets
| | 04:22 |
ask to verify that attribute value.
Click OK, and then place it right next to
| | 04:28 |
the chair.
Press Enter to create another attribute.
| | 04:33 |
This time, type MANUF, press Tab, and
then type Manufacturer.
| | 04:44 |
The default value, in this case, let's
say that this project is going to be
| | 04:48 |
purchase most of the furniture from this
hypothetical company called FurnCo.
| | 04:54 |
This time I will choose to align below
the previous attribute definition, so
| | 04:59 |
that I don't have to pick its location
onscreen.
| | 05:06 |
I want this to be an invisible attribute,
but I don't want to verify it.
| | 05:11 |
Instead, I want this to be a preset
attribute, so that we won't be prompted
| | 05:15 |
on the command line for this particular
piece of data.
| | 05:19 |
I'll click OK, and it's created.
Press Enter again, and type model as the
| | 05:28 |
tag name, and then model as the prompt as
well.
| | 05:36 |
Let's say that this particular armchair
has a certain model number, which I'm
| | 05:39 |
just going to make up.
Let's call it A321, and because this is
| | 05:44 |
going to remain the same, I'm going to
deselect Preset and check Constant.
| | 05:53 |
It will also be invisible and it will
align below the previous attribute definition.
| | 06:00 |
Okay, now I'd like these three pieces of
data to go with every piece of furniture
| | 06:05 |
that I have in this project.
So, I'll go ahead and copy by typing CO Enter.
| | 06:15 |
I'll copy these three attribute
definitions, and I'll turn off Ortho, and
| | 06:21 |
just copy these down here for the desk
and for these two chairs as well.
| | 06:29 |
Now, that saved us a lot of time from
creating these all over again, but let's
| | 06:33 |
say that the model numbers are going to
be different.
| | 06:38 |
I'll double-click on model to Edit this
attribute definition and let's change the
| | 06:45 |
default value, I'll call this D444.
Okay, and down here, we're going to have
| | 06:56 |
this chair have a default model number of
C456.
| | 07:03 |
Okay, this one should be the same, so
let's go ahead and edit that as well,
| | 07:10 |
that'll be C456.
Okay, in this lesson, you created five
| | 07:16 |
separate attribute definitions to store
specific pieces of data relevant to the
| | 07:21 |
sample project.
You also copied attribute definitions
| | 07:26 |
onto each piece of furniture in
preparation for their inclusion in block definitions.
| | 07:31 |
| | Collapse this transcript |
| Defining blocks containing attribute definitions| 00:02 |
In this lesson you will define blocks
containing geometry and attribute definitions.
| | 00:07 |
The room tag block will display the
visible attributes containing the room
| | 00:10 |
number and the last name of the employee
that works in the room.
| | 00:15 |
The furniture blocks will each contain
attributes describing the price,
| | 00:19 |
manufacturer name and model number.
As the purpose of this lesson is to
| | 00:25 |
define blocks, which become permanently
part of the drawing's database, you will
| | 00:29 |
delete the unneeded source geometry and
attribute definitions as you define the blocks.
| | 00:36 |
Let's first define the room tag as a
block.
| | 00:38 |
So type the name Room, space, tag.
Click Pick Point to specify the base
| | 00:47 |
point of this particular block.
And snap to the mid point here.
| | 00:55 |
Then click Select Objects, select the
rectangles, and the room text object and
| | 01:00 |
then you're going to go ahead and select
the attribute definitions.
| | 01:07 |
But the order that you select them in is
significant.
| | 01:11 |
You'll be prompted to enter attribute
values on the command line in the same
| | 01:15 |
order that you select the attribute
definitions here in the block definition.
| | 01:21 |
So let's click room number first.
And then L name.
| | 01:25 |
Press Enter, and then choose Delete.
Set the block unit to inches, and make
| | 01:32 |
sure this is not selected.
Click OK, and the source objects are
| | 01:38 |
deleted, but the block is now part of the
drawing database.
| | 01:45 |
Let's repeat this command by pressing
Enter.
| | 01:49 |
And now, let's address this armchair.
I'll type armchair as the block name.
| | 01:56 |
Click Pick Point, and click this midpoint
on the front of the chair.
| | 02:01 |
Click select objects.
And then select the geometry of the chair.
| | 02:08 |
And then select the attribute definitions
in order from top to bottom.
| | 02:12 |
Press Enter and OK.
Again, press Enter to repeat the block command.
| | 02:19 |
Type desk.
Pick a base point for the desk right here.
| | 02:28 |
Click Select Objects and select the
geometry of the desk with a couple of
| | 02:32 |
crossing windows.
Be careful not to select the wall.
| | 02:40 |
And then go ahead and select the
attribute definitions in order.
| | 02:44 |
Press Enter and OK.
Down here we don't want to define two
| | 02:50 |
identical chair blocks.
Instead, we will define only one chair block.
| | 02:56 |
We will ultimately insert two chair
references of this block, so we'll have a
| | 03:00 |
pair of chairs in each office.
Go ahead and erase, by typing E enter.
| | 03:08 |
All of this information.
Then type b enter for the block command
| | 03:14 |
and type chair, select the base point
right here and then select the objects of
| | 03:22 |
the geometry and then the attributes in
order Enter and OK.
| | 03:32 |
In this lesson you defined the room tag
and three furniture block which each
| | 03:35 |
contain a number of attribute
definitions.
| | 03:39 |
No values have yet been stored in these
data structures that you have designed
| | 03:42 |
and implemented.
| | 03:44 |
| | Collapse this transcript |
| Inserting attributed blocks and entering attribute values| 00:02 |
In this lesson you will insert furniture
block and room tags into vacant offices.
| | 00:07 |
As you do so, you will be prompted to
enter attribute values on the command line.
| | 00:11 |
Entering these values fulfills the
purpose of attributes, which is to store
| | 00:15 |
this non graphical information.
These values represent the so-called
| | 00:19 |
intelligence you are building into the
drawing.
| | 00:22 |
In other words, not only do you have
geometric representations of furniture,
| | 00:26 |
but you will also have relevant furniture
data stored as well, recording the
| | 00:29 |
manufacturer, model number and price.
Before we insert furniture blocks, let's
| | 00:36 |
set the furniture layer current.
Do so by opening the layer drop down and
| | 00:41 |
clicking on the word furniture.
Then use the Insert tool on the Block
| | 00:47 |
panel, and select the Desk Block.
Make sure Specify On Screen is selected
| | 00:55 |
here for Insertion Point, but deselected
for Scale and Rotation, because we'll use
| | 01:00 |
the default scale and angle values that
are set in the dialog box.
| | 01:06 |
Verify that explode in unchecked and
click okay.
| | 01:09 |
Click a point here in this office to
locate the desk and then notice on the
| | 01:14 |
command line it says price, with the
suggested value of 1000.
| | 01:20 |
I'll type 1500 and press enter.
It says verify attribute values, because
| | 01:28 |
the attribute definition had the verify
mode selected.
| | 01:32 |
This time, however the default value has
been changed to the value that is just
| | 01:37 |
typed, so all I have to do is press enter
to verify that value.
| | 01:43 |
Let's insert another block.
This time select armchair, click Okay,
| | 01:49 |
and place it up here, right above the
desk.
| | 01:53 |
Let's type a different price this time.
Let's say the armchair is $800.
| | 02:00 |
Type 800, Enter, Enter.
I'll press enter again to repeat the
| | 02:08 |
insert command, and select the chair
block, Okay.
| | 02:14 |
Click a point down here somewhere, to
locate that chair, then let's type 650
| | 02:19 |
for the price of this chair.
Enter, and Enter again to verify that value.
| | 02:23 |
I could insert another chair over here,
but it may be quicker just to copy the
| | 02:24 |
existing block, and its attribute values
are copied with it.
| | 02:27 |
I'll use Ortho so I can copy this over
horizontally, and I'll click a point over
| | 02:39 |
here somewhere.
Press Enter to end the command.
| | 02:49 |
Now, it will be easier to manipulate
these objects as I want to copy them into
| | 02:54 |
the adjacent offices, if we group these
blocks together.
| | 02:59 |
So, click the group tool, and then select
the four blocks, and press Enter.
| | 03:07 |
Then use the Copy command, then copy this
group.
| | 03:12 |
Turn off Ortho.
Then go ahead and copy it into each office.
| | 03:21 |
Then go back and select this group, click
its singular grip, press the Spacebar
| | 03:27 |
twice to cycle to the rotate command.
Move the mouse so that you rotate more or
| | 03:36 |
less parallel to the wall and then click
the grip and stretch it over so its
| | 03:40 |
closer to the wall.
Press Escape, and repeat that process, in
| | 03:47 |
each office.
Press the Spacebar twice, to cycle to
| | 03:52 |
rotate, and then just click the grip and
stretch it over.
| | 04:00 |
Again, And 1 more time over here.
This time, however, I think I will rotate
| | 04:11 |
it a bit differently, because this office
is larger.
| | 04:18 |
Press escape to deselect.
Now, this office could have another
| | 04:22 |
chair, perhaps.
I'll toggle off Group Selection and then
| | 04:27 |
copy one of these chairs over to the
side, and then move them so that the
| | 04:33 |
spacing more or less looks equal.
I'll toggle Group Selection back on and
| | 04:49 |
then click the desk.
(audio playing) So this new chair isn't part of
| | 04:53 |
the existing group.
I can add to the group very easily by
| | 04:57 |
clicking this button.
Group edit.
| | 05:01 |
Click the "Add Objects" option, and
select the chair and press Enter.
| | 05:07 |
Now, all of those pieces of furniture
belong to that group.
| | 05:10 |
Press Escape.
Our next task is to insert the room tag
| | 05:16 |
in each room.
I'll zoom out and go over here to this
| | 05:23 |
top left office.
Let's change the current layer to tags.
| | 05:29 |
Insert, the room tag, and click okay.
Click a point in the office to locate the tag.
| | 05:42 |
And then on the command line it says room
number 100.
| | 05:46 |
I'll press Enter to accept that default
value, and I'll type, in capital letters,
| | 05:51 |
SMITH as the employee's last name, and
Enter.
| | 05:56 |
So the values that I just entered on the
command line appear here as attribute values.
| | 06:05 |
Let's try that again.
I enter for insert, press enter to repeat
| | 06:10 |
the last black which is ruin tag, click,
type 101, enter, and then we'll type
| | 06:16 |
Johnson as the last name.
Enter.
| | 06:23 |
Now let's change a system variable called
"ATTDIA." It stands for attribute
| | 06:29 |
dialog box.
Let's change that to a value of one,
| | 06:33 |
which means this feature is on.
Now insert the same block in the next room.
| | 06:42 |
The difference is, instead of being
prompted for the attributes on the
| | 06:46 |
command line, you're prompted in a
duologue box interface.
| | 06:50 |
So this might be more convenient for you.
It's really a matter of personal preference.
| | 06:55 |
So the next room will be 102.
I'll just change that value.
| | 06:59 |
Press Tab to go to the next text box and
type Williams.
| | 07:05 |
Okay, go down here and continue the
process for the last two rooms.
| | 07:13 |
This will be room 103.
I'll press the right arrow to go to the
| | 07:19 |
end of the selected field back space 103
tab.
| | 07:26 |
This will be Jones, okay.
And once more Enter, Enter, click, Right
| | 07:36 |
arrow, Backspace 4, Tab, and Brown.
Okay.
| | 07:42 |
In this lesson you populated a vacant
office with room tags and office furniture.
| | 07:48 |
In the process you have built an
intelligent drawing that not only
| | 07:52 |
displays the correct geometry, but also
acts as a data base of relevant visible
| | 07:56 |
and invisible data.
| | 07:59 |
| | Collapse this transcript |
| Editing existing attribute references and definitions| 00:02 |
In this lesson, you'll learn how to
change existing attribute values and how
| | 00:05 |
to alter attribute definitions, without
exploding their blocks.
| | 00:10 |
Open the Office 6 project file.
Suppose we want to change the employee
| | 00:15 |
who works in Room 104 and we want to
update their last name in this room tag.
| | 00:22 |
You can do that by going up here, to the
Edit Attribute command in the block
| | 00:26 |
panel, which is on the Insert tab of the
ribbon.
| | 00:31 |
This launches the command eatedit, which
stands for Enhanced Attribute Editor.
| | 00:38 |
Click anywhere on the room tag block to
open this dialog box.
| | 00:44 |
It shows you both of the tags which are
part of this particular block.
| | 00:49 |
Click on Lname, and you'll see its value
appear down here.
| | 00:54 |
Highlight that and just type in the new
employee name, which is Montgomery.
| | 01:00 |
(audio playing)
Type it all in capital letters like all
| | 01:03 |
the other employee last names and click
OK.
| | 01:06 |
(audio playing)
Now we've successfully changed the value
| | 01:10 |
but this particular last name is too long
to fit within the rectangle that was
| | 01:14 |
designed for this particular block.
We can fix that by narrowing the width of
| | 01:22 |
this particular attribute.
To do that let's go back into the
| | 01:27 |
enhanced attribute editor, but this time
instead of going up here an selecting it,
| | 01:31 |
we'll just double-click on the block
itself.
| | 01:35 |
(audio playing)
This automatically opens the dialog box.
| | 01:39 |
Select Lname, and then go to the Text
Options tab.
| | 01:46 |
Here you can change the width factor,
(audio playing) highlight the value and type 0.7.
| | 01:53 |
Click OK (audio playing) and this singular block
reference has been updated.
| | 02:02 |
If you look at the other room tags,
you'll see that they're just the same
| | 02:05 |
width as they were before.
The text width is defined by the text
| | 02:12 |
style used in the attribute definitions.
Suppose you wanted to update all the room
| | 02:18 |
tags now to use the narrower width that
you see in Room 104.
| | 02:25 |
That's possible with the Block Attribute
Manager.
| | 02:29 |
You can open that here by clicking Manage
Attributes on the Block Definition panel.
| | 02:36 |
The command is Batman.
(audio playing)
| | 02:38 |
Select Room Tag from this drop-down menu.
Notice that we don't see any employee
| | 02:46 |
last names here.
That's because the Block Attribute
| | 02:50 |
Manager allows you to edit the attribute
definitions.
| | 02:55 |
Double-click on Lname to open a secondary
dialog box.
| | 02:59 |
Then go to it's text options tab and
change the Width factor to 0.7.
| | 03:08 |
Click OK and all the existing room tags
are updated because we've changed the way
| | 03:15 |
the attribute definitions appear.
Click OK.
| | 03:23 |
Now suppose you want to edit (audio playing) some
of these furniture blocks.
| | 03:28 |
I'll double-click on this armchair
(audio playing) and we see that the Enhanced
| | 03:33 |
Attribute Editor opens up.
I could edit the price or manufacturer
| | 03:39 |
values down here.
There's also a third invisible attribute
| | 03:45 |
that was defined within this block.
model.
| | 03:49 |
We don't see it here because it used a
constant mode.
| | 03:53 |
So we're not able to edit that.
When we insert the arm chair, we're asked
| | 03:58 |
to verify the price.
But we're not asked about the
| | 04:03 |
manufacturer and that's because the
manufacturer was set to the preset mode.
| | 04:10 |
However, you can edit that here (audio playing)
in the Enhanced Attribute Editor.
| | 04:16 |
If you want to edit the model, you have
to do that in the Block Attribute Manager.
| | 04:23 |
Suppose we do want to change the model
number, we'll cancel out of here, go to
| | 04:29 |
Manage Attributes, select Armchair
(audio playing) and double-click on model.
| | 04:40 |
(audio playing)
Let's change the default model number
| | 04:46 |
(audio playing) to A333.
OK and OK.
| | 04:51 |
(audio playing)
All of the armchair blocks in this
| | 04:53 |
drawing had been updated with that
invisible default value.
| | 04:58 |
So in this video, you'll learn how to
edit attribute values and attribute
| | 05:02 |
definitions using the eatedit and batman
commands.
| | 05:07 |
You now have the skills to design,
implement, and modify attributes.
| | 05:12 |
| | Collapse this transcript |
|
|
3. Using Fields to Display Object PropertiesCreating closed objects to store room areas| 00:02 |
In order to find the area of each room in
this plan, you will create closed objects
| | 00:05 |
tracing the boundaries of each space.
It is helpful to display the room areas
| | 00:10 |
on the plan, so that one can manage this
information.
| | 00:14 |
For example, the client might choose to
assign employees to rooms according to
| | 00:17 |
how large the offices are.
More senior workers might get offices
| | 00:21 |
with larger floor areas for example.
The program is able to calculate the area
| | 00:26 |
of any closed polyline or region object,
and this information is available through
| | 00:30 |
object properties.
In this video you will create these
| | 00:35 |
objects efficiently with the Boundary
command.
| | 00:38 |
Open the layer properties manager and set
Layer Area Current, then toggle off the
| | 00:46 |
door, furniture, and tags layers, toggle
on the header layer.
| | 00:56 |
Now we can focus on the shape of each
room.
| | 01:00 |
We have some complex geometry in this
plan, so its not just a matter of
| | 01:04 |
creating a rectangle and tracing the
room.
| | 01:08 |
Instead I am going to show you a more
robust approach for creating the
| | 01:12 |
boundaries of any space.
You have to ensure that there are no gaps
| | 01:18 |
in you line work, or this technique won't
work.
| | 01:23 |
If there are gaps, seal them up, either
by extending objects or creating new ones
| | 01:28 |
to close up any potential gaps in the
boundary.
| | 01:35 |
Then use the boundary command here on the
bottom of the hatch flyout.
| | 01:40 |
Click pick points, and click inside the
room.
| | 01:46 |
Press enter, and you're left with a poly
line.
| | 01:50 |
Now, we can't see it right now, because
it's coincident with all of the other
| | 01:54 |
objects in this room.
Let's turn off the header layer temporarily.
| | 01:59 |
And you can see the magenta area polyline
down here.
| | 02:00 |
I'll click it to select this object.
In object properties, you can see that it
| | 02:07 |
has an area property which lists this
value in square inches by default press
| | 02:18 |
escape to desselect.
Now let's turn the header layer back on.
| | 02:31 |
I'm going to zoom out a little bit here
because the way that the boundary command
| | 02:35 |
works, is it analyzes the content that is
on the screen So you need to actually see
| | 02:39 |
the entire boundary that your trying to
make prior to using the command.
| | 02:45 |
So click boundry, click pick points, and
click inside this space.
| | 02:52 |
Press enter, it warns you that is can't
make a poly line, it asks you "create
| | 02:58 |
reigon" say yes.
The region also has an area property.
| | 03:04 |
Let's just verify that.
Here it is.
| | 03:08 |
Incidentally, regions are defined inside
their area as well as along their edge.
| | 03:16 |
Whereas polylines are defined really only
along the edge.
| | 03:22 |
Let me just demonstrate that here.
I'll create a rectangle and a circle.
| | 03:28 |
Then I'll convert them both to regions
by typing region, Enter, select these two
| | 03:35 |
objects and then press Enter.
So it says two regions created.
| | 03:44 |
They look the same.
The thing about regions is you can use
| | 03:48 |
boolean operations on them.
I'll type subtract, Enter.
| | 03:54 |
I'll select the circle, and press Enter.
And then select this rectangle, and press Enter.
| | 04:02 |
You see, I was able to subtract the shape
of that rectangle from that circle, such
| | 04:07 |
as the power of regions.
I'll just go ahead and erase this.
| | 04:13 |
And let's go back to creating some other
shapes here in these additional offices.
| | 04:21 |
I'll click Boundary, and as a shortcut
you can just press Enter, and that means pickpoints.
| | 04:29 |
I'll click in here and press Enter.
Again, we have to say Yes.
| | 04:34 |
The shape of these offices is a bit too
complicated to create a polyline because.
| | 04:42 |
It's based on an ellipse.
Let's go ahead and go Enter, Enter,
| | 04:49 |
click, Enter, yes.
Finally down here, Enter, Enter, click,
| | 04:56 |
Enter, yes.
In this video you created a closed object
| | 05:00 |
in each space because closed object have
area properties.
| | 05:07 |
In one space you created a closed
polyline, an in the others polylines were
| | 05:10 |
not possible, because the boundaries had
complex curvature, so regions were
| | 05:14 |
created instead.
| | 05:17 |
| | Collapse this transcript |
| Creating and formatting fields in text| 00:02 |
Fields can be inserted anywhere you have
text.
| | 00:05 |
They allow you to display different types
of information which are part of the
| | 00:08 |
drawings non-graphical database.
In this lesson you will create fields to
| | 00:13 |
display the floor area of each room in
the sample office drawing.
| | 00:17 |
Go ahead and open the Office 8 project
file.
| | 00:21 |
And then open the Layer properties
manager.
| | 00:24 |
Turn on all the layers, and then turn off
the header layer.
| | 00:29 |
So that you can see the area line in each
door opening.
| | 00:34 |
Set Layer tags current.
And close the Layer properties manager.
| | 00:42 |
I'd like to design a field that appears
right underneath the room tag displaying
| | 00:46 |
the area of each room.
To do so, open the Text flyout and select
| | 00:53 |
Single Line Text.
Click a point underneath the room tag.
| | 01:00 |
And press Enter to accept the default
rotation.
| | 01:04 |
Instead of actually typing text, I'm
going to right-click and choose Insert
| | 01:09 |
Field from this shortcut menu.
This is a listing of all the different
| | 01:16 |
types of fields that you can use.
There's lots of different types of information.
| | 01:21 |
Such as Plot Date, Save Date, and so on.
But I'm interested in object data.
| | 01:28 |
So I'll click Object, and then click this
button to select the object.
| | 01:33 |
Click right here, to select this closed
polyline.
| | 01:41 |
And its list of properties is listed
here.
| | 01:44 |
Area happens to be at the top of the
list, so it's selected by default.
| | 01:49 |
You can set the precision right here.
Let's say we're happy with 0.0 precision,
| | 01:55 |
so that our value looks like this.
Now right now, this is showing us the
| | 02:01 |
area of this room in square inches.
I'm interested in knowing the number of
| | 02:07 |
square feet, so I'll click the Additional
Format button and enter a conversion factor.
| | 02:13 |
Thinking this through, there are 12
inches in a foot.
| | 02:17 |
So 1 square foot is equal to 12 times 12
inches, or 144 square inches.
| | 02:25 |
If we want to convert from square inches
to square feet, we need to divide by this factor.
| | 02:32 |
So the conversion factor should read,
1/144.
| | 02:36 |
This means 1 divided by 144, and it gives
us a value of 81.3 square feet.
| | 02:46 |
I'll click OK, and OK again.
We see the value appear here in the field.
| | 02:53 |
But it just says 81.3.
Let's type a space, because we are, after
| | 02:59 |
all, inside the Text command.
Don't forget.
| | 03:03 |
Go ahead and type sq.ft.
For square feet, and then press Enter,
| | 03:09 |
Enter to end the Text command.
(NOISE) The field has a gray background
| | 03:19 |
around it.
And this is merely to identify it as a
| | 03:23 |
field to you visually on screen, but this
background will not plot.
| | 03:29 |
Let's just go ahead and move this over to
visually center it underneath the tag.
| | 03:38 |
Let's create another field over here.
Again, Text, click a point, Enter,
| | 03:45 |
right-click, Insert Field, click this
button and this time select.
| | 03:55 |
This object, which is a region, in this
case.
| | 03:57 |
It says Region.
But it also has an area property.
| | 04:04 |
The precision stays the same.
But we do need to go back under
| | 04:09 |
Additional Format, and type in 1 over
144.
| | 04:13 |
Okay?
Okay again, space, square feet, Enter, Enter.
| | 04:23 |
I'll just move this over, right about
like that.
| | 04:28 |
And we might save some time if we simply
copy this text object.
| | 04:34 |
From this corner to this corner.
And while I'm at it, I'll go ahead and
| | 04:40 |
add it here and down here.
But I have to remember that I need to
| | 04:46 |
update these three.
I don't want to leave it like that,
| | 04:52 |
because these reference this particular
object.
| | 04:58 |
Let's go ahead and double-click to edit
the text.
| | 05:02 |
Double-click on the field to edit it.
Click here and select this object.
| | 05:09 |
Additional Format, 1 over 144, OK and OK.
Click outside, and then click on this one.
| | 05:20 |
Again, select the right object.
Change the format conversion factor.
| | 05:32 |
And complete them all.
This should be a larger square footage.
| | 05:43 |
It is a larger office.
It's 120 square feet, that's about right.
| | 05:55 |
Perhaps this one needs to be moved over
because it has an extra digit.
| | 06:03 |
Finally, we can zoom out and turn off the
Area layer.
| | 06:08 |
The field codes remain.
In this lesson, you created text objects
| | 06:15 |
and filled them with fields, displaying
the area property of the closed objects
| | 06:19 |
found in each room.
| | 06:21 |
| | Collapse this transcript |
| Updating fields| 00:02 |
Fields are connected to the drawing
database.
| | 00:04 |
So, whenever the database changes, the
fields have the potential to be updated.
| | 00:09 |
You will change shape of two rooms and
learn the methods for updating fields
| | 00:12 |
displaying floor areas.
Open the Office 9 project file.
| | 00:18 |
Note that Room 100 has an 81.3 square
foot area.
| | 00:23 |
Let's enlarge this room and see what
happens to the field.
| | 00:28 |
Toggle on the area layer.
(audio playing)
| | 00:31 |
Use the Stretch command (audio playing) and click
a crossing window down here.
| | 00:37 |
(audio playing)
So that you select the boundaries of this
| | 00:40 |
edge of the room.
(audio playing)
| | 00:42 |
Part of the desk is selected but it won't
be stretched because it's part of this group.
| | 00:51 |
Click an arbitrary point to begin the
stretch.
| | 00:55 |
Turn on Ortho, move the mouse to the
left, and type 3 feet enter.
| | 01:01 |
The field hasn't updated yet.
The reason is the drawing needs to be regenerated.
| | 01:09 |
Type (audio playing) regen (audio playing) and press
Enter.
| | 01:13 |
That's all there is to it.
The field shows a new value because the
| | 01:18 |
magenta polyline is larger now and it's
getting that value right off of the
| | 01:24 |
object properties of this particular
object.
| | 01:31 |
(audio playing)
Let's go over here to the opposite side of
| | 01:34 |
the office.
Let's say we want to stretch this as well.
| | 01:38 |
Stretch, make a crossing window like
this.
| | 01:43 |
Enter.
Click some arbitrary point and toggle off Ortho.
| | 01:50 |
Stretch it down some arbitrary distance
and you'll see that this behaves differently.
| | 01:58 |
(audio playing) This magenta outline didn't
follow the shape of the existing walls.
| | 02:05 |
And that's because it's a region and
regions cannot be stretched.
| | 02:11 |
Let's delete this.
And then, zoom in here and regen.
| | 02:20 |
This field's association has been broken
because the object that it was referring
| | 02:23 |
to has been deleted.
Let's go ahead and create a new region in
| | 02:30 |
this space.
To do so we need to turn on the header layer.
| | 02:37 |
(audio playing)
We need to also turn off the furniture
| | 02:39 |
(audio playing) and the door layer.
(audio playing)
| | 02:43 |
Let's set the area layer current and turn
off the tags layer.
| | 02:50 |
(audio playing)
It looks like we also have some work to
| | 02:53 |
do down here by fixing the header.
I'll erase that (audio playing)
| | 03:02 |
Make the header layer current.
(audio playing)
| | 03:05 |
And then draw a line from the center of
this circle to the center of this circle.
| | 03:13 |
I'll then trim and press Enter to select
all of the edges as cutting edges.
| | 03:20 |
And then click this point (audio playing) and
this point to trim the line away.
| | 03:27 |
(audio playing)
Now the room is closed and we should be
| | 03:29 |
able to recreate a region object here
with a boundary command.
| | 03:34 |
Select the area layer and make it
current.
| | 03:38 |
Use the boundary command.
Press Enter and click inside the room.
| | 03:43 |
(audio playing)
Press Enter and yes, we do want to create
| | 03:47 |
a region.
(audio playing)
| | 03:49 |
Okay.
Let's turn on all the layers.
| | 03:52 |
Click the layer slide out and click this
tool to turn all layers on (audio playing) and
| | 03:57 |
then lets turn off (audio playing) the header
layer (audio playing) so that this object (audio playing)
| | 04:02 |
is the region.
Okay.
| | 04:07 |
Zoom in here.
Double-click on this text, double-click
| | 04:13 |
on (audio playing) the field.
And we get warned, the object referenced
| | 04:20 |
by the field has been erased.
Well, we know that.
| | 04:23 |
Click OK.
And then, scroll down (audio playing) and click
| | 04:27 |
(audio playing) object.
Reacquire (audio playing) the object by clicking
| | 04:32 |
this magenta region (audio playing)
Go to Additional Format (audio playing) and
| | 04:37 |
change the conversion factor to 1 over
144.
| | 04:42 |
OK and OK.
In this lesson, you learned how to update
| | 04:46 |
a field by changing the shape of a room
and regenerating the drawing.
| | 04:53 |
You also learned how associate a new
object's properties with an existing field.
| | 05:01 |
| | Collapse this transcript |
|
|
4. Extracting, Linking, and Presenting DataExtracting data from AutoCAD to Excel| 00:02 |
In this lesson, you'll extract attribute
data from AutoCad and import it into
| | 00:05 |
Microsoft Excel.
You'll then edit the data in Excel.
| | 00:10 |
It can be useful to extract data from
AutoCad to Excel, so that one can add up
| | 00:14 |
the number of items used in drawings and
create list of materials for price
| | 00:17 |
estimation or product ordering purposes.
It is also possible to extract attribute
| | 00:24 |
data from AutoCad and display it in
tables, all without leaving auto cad.
| | 00:29 |
The data links to and from Excel are
provided because of the popularity of
| | 00:33 |
this spreadsheet program.
You can also link to data from other
| | 00:38 |
spreadsheet programs that support the
common separated values, or csv format,
| | 00:43 |
such as OpenOffice.
Open the Office 10 project file, and then
| | 00:49 |
on the Insert tab in the linking and
extraction panel, click this button,
| | 00:53 |
Extract Data.
(audio playing) This launches a wizard interface
| | 00:58 |
that will take you step by step through
the process.
| | 01:02 |
Choose the Default Option to create a New
Data Extraction and click Next.
| | 01:09 |
You're immediately prompted to save a
data extraction as.
| | 01:12 |
Go into the My Files sub-folder and type
the file name Furniture, click Save.
| | 01:24 |
Accept the default option here to define
a data source, and click Next.
| | 01:31 |
This is a list of all of the objects you
could potentially extract data from,
| | 01:37 |
right-click and choose Uncheck All, and
then select armchair, chair, and desk,
| | 01:43 |
click Next.
This a list of the properties that can be
| | 01:50 |
extracted from those selected objects.
Deselect all of the different categories
| | 01:59 |
except for attribute, then click Next.
This is a preview of the spreadsheet that
| | 02:07 |
you are extracting.
You have an opportunity here to sort the
| | 02:11 |
columns by clicking on their headers.
Click on Name to sort in forward
| | 02:17 |
alphabetical order, click Next.
Here lets output the data to an external
| | 02:24 |
file, check this option.
And then click this Ellipsis button to
| | 02:31 |
specify the path, go into your Chapter
folder and My Files sub-folder, and
| | 02:40 |
select the name office10.xls, Save and
Next.
| | 02:48 |
Finally, click Finish, the data was
extracted.
| | 02:53 |
Now, we need to open that in Excel.
Browse to the My Files sub-folder, and
| | 02:58 |
double-click Office 10.
Here we have all of the data here in the
| | 03:05 |
cells of this spreadsheet.
Notice, that these cells have little tabs
| | 03:11 |
in the corner, there's a warning on these
cells, the number in the cell is
| | 03:15 |
formatted as text.
Let's change that, convert to number, do
| | 03:21 |
the same thing in each one of these
cells.
| | 03:28 |
Excel will then be able to add up the
numbers, once it understands what this
| | 03:32 |
type of data is.
Right click on the E column header and
| | 03:38 |
choose Insert, Select these cells and
Copy them to the Clipboard.
| | 03:48 |
Target this cell and then Paste the
information in there.
| | 03:54 |
Right click on A and chose Delete.
That way we have account next to the price.
| | 04:01 |
Over here, let's type equals.
Click on this Cell, type the Asterisks to
| | 04:09 |
mean multiply by, and then click this
Cell and press Enter.
| | 04:17 |
Select this cell and drag it down from
this corner to copy that information into
| | 04:25 |
the next two cells.
Down here, let's create a sum and press Enter.
| | 04:35 |
Let's Rename this tag name to the full
word Manufacturer, Rename this in title
| | 04:42 |
case and type model Number.
Change this price in all caps to price in
| | 04:52 |
title case, and then let's call this one
Totals.
| | 05:03 |
We'll just drag these column headers to
reveal the full titles.
| | 05:11 |
Okay, I think the data is formatted well
enough, let's click Save.
| | 05:17 |
In this video, you went through the steps
of AutoCad's data extraction wizard to
| | 05:21 |
select and format specific data for
export to Excel.
| | 05:26 |
You also opened the extracted file in
Excel and edited the data.
| | 05:30 |
| | Collapse this transcript |
| Creating a table in AutoCAD by linking to an Excel spreadsheet| 00:02 |
In this lesson, you will create what is
called a data link to establish a
| | 00:05 |
connection between AutoCAD and a specific
Excel spreadsheet file.
| | 00:10 |
Then you'll use this data link to create
a table in AutoCAD.
| | 00:14 |
Open the Office 10 project file, then go
to the Insert tab.
| | 00:19 |
And in the Linking and Extraction panel,
click the Data Link tool.
| | 00:23 |
(audio playing)
Click Create a New Excel data (audio playing)
| | 00:29 |
link and title this, furniture.
(audio playing) Click OK.
| | 00:35 |
An then, right here it says browse for a
file.
| | 00:40 |
Click this Ellipsis button (audio playing) to
browse for the file Office 10 (audio playing) in
| | 00:47 |
the My Files subfolder.
(audio playing) Click OK (audio playing) and the data
| | 00:53 |
link is established.
You can see that here with this Link icon.
| | 00:59 |
(audio playing)
Click OK (audio playing) and then go to the Home tab.
| | 01:09 |
In the Annotation panel, click this tool,
table.
| | 01:14 |
(audio playing)
This launches this Insert Table dialog box.
| | 01:18 |
And you could start an empty table here
and specify the number of columns and rows.
| | 01:23 |
But in this case, we're going to create
the table from the data link.
| | 01:27 |
So, select this radio button.
(audio playing)
| | 01:29 |
Open the drop-down and select the
furniture data link.
| | 01:33 |
Notice these are grayed out now, because
the number of columns and rows are
| | 01:38 |
specified in the excel spreadsheet file.
Click OK (audio playing) and a very small table
| | 01:46 |
appears by the cursor.
Click any point to insert that table and
| | 01:52 |
then zoom in.
We need to scale this up according to the
| | 01:56 |
annotation scale here.
This drawing is scaled to one half inch
| | 02:02 |
equals 1 foot.
Another way of thinking of that is 1 inch
| | 02:08 |
equals 2 feet or 1 inch is scaled up 24
times because there are 24 inches in 2 feet.
| | 02:17 |
So what we need to do is scale this table
up by a factor of 24.
| | 02:23 |
Choose Scale (audio playing), select the table,
Enter.
| | 02:27 |
Choose a base point (audio playing) and type 24,
Enter.
| | 02:32 |
Then zoom out.
And you'll see that the table text
| | 02:36 |
matches the height of the text in the
Room text.
| | 02:41 |
In this lesson, you have learned how to
create a data link in AutoCAD to an Excel
| | 02:45 |
spreadsheet, and use it to generate a
table in AutoCAD.
| | 02:49 |
In the example you linked to an Excel
spreadsheet that was extracted from AutoCAD.
| | 02:56 |
But this technique works equally well for
any Excel spreadsheet created
| | 03:00 |
independently of AutoCAD.
| | 03:03 |
| | Collapse this transcript |
| Creating a table directly from object data| 00:02 |
In this lesson, you will create a table
displaying some of the current drawings
| | 00:05 |
attribute data without having to go
through the intermediary of Microsoft Excel.
| | 00:11 |
Instead, we will begin by creating a
table directly in AutoCAD.
| | 00:15 |
Open the Office 11 project file.
And then, on the Home tab, in the
| | 00:20 |
Annotation panel, click the Table tool.
(audio playing)
| | 00:24 |
Select this third radio button in the
Insert options area from object data in
| | 00:30 |
the drawing.
This will launch the data extraction wizard.
| | 00:36 |
Click OK.
(audio playing)
| | 00:40 |
And then create a new data extraction.
Click Next.
| | 00:45 |
(audio playing)
You're prompted to save a filename, let's
| | 00:49 |
call this (audio playing) furniture 2.
Click Save.
| | 00:54 |
And then use the default option here
which is to use the current drawing or
| | 00:58 |
sheet set as the data source.
Click Next.
| | 01:05 |
(audio playing)
Here you have a list of all of the object
| | 01:07 |
types in the drawing from which you can
extract data.
| | 01:11 |
Right-click and choose Uncheck All
(audio playing) and then select armchair, chair,
| | 01:17 |
and desk.
Click Next.
| | 01:22 |
This is a list of all of the properties
that could be extracted from the selected objects.
| | 01:27 |
Deselect (audio playing) all the categories
except for attribute.
| | 01:33 |
(audio playing)
Here is a list of these tag names of
| | 01:35 |
these attributes.
Click Next.
| | 01:39 |
(audio playing)
And this is a preview of the actual table.
| | 01:44 |
Let's sort the list by name, by clicking
on the name header.
| | 01:50 |
(audio playing)
Then click Next.
| | 01:52 |
(audio playing)
Check the first option, Insert Data
| | 01:55 |
Extraction table into drawing and make
sure the second option in unchecked.
| | 02:01 |
Click next.
Here we have an opportunity to configure
| | 02:05 |
the table style.
Make sure that this option is selected.
| | 02:09 |
If it's not (audio playing) you won't have header
cells.
| | 02:12 |
(audio playing)
Click Next (audio playing) and click Finish.
| | 02:17 |
(audio playing)
Click a point to insert the table over
| | 02:20 |
here somewhere.
(audio playing)
| | 02:23 |
It's very small by default.
Zoom in.
| | 02:31 |
(audio playing)
Now we need to scale the table up
| | 02:33 |
according to the scale at which we intend
to depict this drawing.
| | 02:37 |
The annotation scale tells us that this
drawing is meant to be displayed at half
| | 02:43 |
inch scale.
That is half inch in the drawing equals 1
| | 02:47 |
foot in the real world.
Another way of thinking of this is that 1
| | 02:52 |
inch in the drawing equals 2 feet in the
real world.
| | 02:57 |
Or 1 inch in the drawing equals 24 inches
in the real world.
| | 03:02 |
In other words, we're taking 1 inch here
and we're scaling it up 24 times, in the
| | 03:07 |
real world.
So what we need to do is scale this table
| | 03:12 |
up by a factor of 24.
Click Scale, (audio playing) select the table, Enter.
| | 03:22 |
Select this endpoint up here and type 24,
Enter.
| | 03:26 |
Then zoom out.
And you'll see that the size of the
| | 03:32 |
lettering more or less matches the size
of the text in these room tags.
| | 03:37 |
It's different than the spreadsheet here
that was linked to an Excel spreadsheet.
| | 03:45 |
The text type in this table is controlled
by the table style.
| | 03:49 |
And you can see that here by opening the
annotations slide out and clicking the
| | 03:54 |
Table Style tool.
(audio playing)
| | 03:57 |
You can then configure this by going into
Modify and Adjusting the text type here
| | 04:03 |
and the text style.
You could change the text type and text
| | 04:09 |
style here for the different sales
styles, data, header, (audio playing) and title.
| | 04:16 |
(audio playing)
But I'm satisfied with the standard table
| | 04:19 |
style so I'm going to cancel out and
close.
| | 04:22 |
(audio playing)
So in this lesson, you learned how to
| | 04:24 |
extract attribute data from AutoCAD's
drawing database and you fed this data
| | 04:28 |
into a table within the same drawing.
| | 04:32 |
| | Collapse this transcript |
| Formatting table cells and styles| 00:02 |
In this lesson, you will learn how to
unlock table cells and edit table cell data.
| | 00:07 |
You will also resize table columns and
add a new column.
| | 00:11 |
Open the Office 12 project file and Zoom
In to this upper table which was
| | 00:15 |
extracted directly from attribute beta.
Click on this cell and you'll see a tiny
| | 00:23 |
padlock appear next to the cursor, that
means this cell comes directly from the
| | 00:28 |
data extraction.
This is the attribute tag name.
| | 00:36 |
So, we can't change it, by default.
However, I'd to change this to the full
| | 00:41 |
word manufacturer.
And I don't want it to appear in all caps either.
| | 00:47 |
So, in order to edit this information.
I need to right-click and choose Locking
| | 00:54 |
> Unlocked.
Then I can go a head and double-click in
| | 00:58 |
the Cell to edit that data.
Highlight, the remainder of the word, and
| | 01:06 |
in lowercase type the rest of the word,
Manufacturer, press Enter.
| | 01:12 |
And it's input however, the word is too
long to fit in the cell, so the row
| | 01:18 |
automatically got taller.
We'll fix that in a minute.
| | 01:25 |
Next, let's change model and Price to
title case.
| | 01:28 |
Double-click on the model Cell, and
you'll see that it too is locked.
| | 01:34 |
Hold down Shift and click on the Adjacent
Cell, so that you select both of them at
| | 01:39 |
the same time.
Then right-click and choose Locking > Unlocked.
| | 01:49 |
Double-click on cell D2, Highlight this
part of the word, and then type that
| | 01:55 |
again in lowercase, double-click on the
Adjacent Cell, and fix it as well.
| | 02:04 |
Now, I'm going to click on the table, but
instead of clicking in a cell, I'm going
| | 02:09 |
to be careful to click directly on one of
its lines.
| | 02:15 |
This puts you in a different editing
mode.
| | 02:19 |
Here I can click this grip and drag the
column and make it wider.
| | 02:25 |
However, I don't want to snap to the next
grip, so I need to be careful and come
| | 02:28 |
down to here and Turn Off running object
snap.
| | 02:34 |
And then I'll click over here someplace
to make that particular cell wider.
| | 02:38 |
But I did that unfortunately at the
expense of this adjacent column.
| | 02:43 |
I'm going to change the column width with
this script, and make the whole table a
| | 02:48 |
bit wider.
Then I have some more space to play with.
| | 02:53 |
I can then move this over and make
everything fit.
| | 03:00 |
Double-click on this Top Cell and type
Furniture Schedule, Enter.
| | 03:07 |
I also notice that the information in the
cells is at the top, let's see if we can
| | 03:13 |
change that.
I'll select this cell, hold down Shift
| | 03:20 |
then select this cell that selects this
whole area from cell A3 all the way down
| | 03:26 |
to cell E5.
Then up here, on the Cell Styles panel,
| | 03:33 |
let's change this from top center to
middle center and then press the Esc key.
| | 03:44 |
Let's also create a New Column over here,
click cell E2.
| | 03:50 |
Right click, and choose Columns > Insert
Right.
| | 03:59 |
Double-click on this cell F2, and type
Totals.
| | 04:08 |
Let's add another row as well, but to do
so I'm going to move the whole table up a bit.
| | 04:15 |
Use the Move Command, select the Table,
Enter, and then just move it up an
| | 04:19 |
arbitrary distance.
Select this cell, right-click on the Five
| | 04:28 |
Header, and choose Insert Row below, and
then click outside the table.
| | 04:38 |
So in this lesson, you learned how to
edit a table generated automatically from
| | 04:41 |
extracted data.
By unlocking selected cells, you were
| | 04:45 |
able to edit their contents.
In addition, you learned how to resize
| | 04:50 |
columns, and added a new column, and a
new row.
| | 04:53 |
| | Collapse this transcript |
| Editing table cells and using formulas| 00:02 |
In this lesson, you will use simple
mathematical formulas to multiply
| | 00:06 |
subtotals and add up the grand total of
the price of the furniture depicted in
| | 00:10 |
the schedule.
Open the Office 13 project file and then
| | 00:15 |
click on this blank cell here in the
Totals column.
| | 00:19 |
Notice that there's a lock symbol next to
the cursor.
| | 00:22 |
(audio playing)
This cell is also locked.
| | 00:24 |
In fact, all four of these Total cells
are locked.
| | 00:27 |
So before we can edit the contents of
these cells, we need to unlock them.
| | 00:32 |
Select cell F3, hold down Shift, and then
select cell F6.
| | 00:38 |
This makes a selection of the four
contiguous cells.
| | 00:43 |
Right-click and then choose locking,
unlocked.
| | 00:49 |
(audio playing)
Then click on cell F3.
| | 00:52 |
In order to enter a formula, you just
have to type equals.
| | 00:57 |
I'll type equals and then I want to
multiply the item count which is here in
| | 01:03 |
cell A3 times the price.
So I'll type A3 asterisk, which means
| | 01:11 |
multiply by.
And then type cell E3.
| | 01:16 |
Press Enter and there's the total.
Let's do this again.
| | 01:24 |
Equals.
This time, we're thinking of cell A4
| | 01:29 |
times E4.
So I'll just type that in.
| | 01:36 |
A4 asterisk E4, Enter.
Again, equals A5 times E5.
| | 01:43 |
Enter.
Finally, down here, I want to calculate
| | 01:47 |
the sum of these subtotals.
I'll type equals and then I'll write the
| | 01:56 |
word sum.
(audio playing) And then (audio playing) left parentheses.
| | 02:05 |
And I want to total everything in this
column so it starts at cell F3.
| | 02:10 |
I'll type in F3 (audio playing) and then colon.
This will indicate a range of cells.
| | 02:18 |
So I'll type cell F5.
(audio playing)
| | 02:21 |
And then close parenthesis and press
Enter.
| | 02:27 |
This gives us grand total of the
furniture used in this particular drawing.
| | 02:32 |
(audio playing)
So, in this lesson you learned hot add
| | 02:35 |
and multiply table cells on AutoCAD in
order to calculate the total price of the
| | 02:39 |
furniture depicted in the drawing.
You now have the skills to attach
| | 02:45 |
non-graphical information to objects and
manage its flow through attributes and
| | 02:49 |
blocks, through fields, and finally for
display and tabulation in tables.
| | 02:54 |
| | Collapse this transcript |
|
|
