Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Calculating the overall length of multiple entities

From: AutoCAD: Tips, Tricks, and Industry Secrets

Video: Calculating the overall length of multiple entities

AutoCAD isn't just used for creating and editing linework. AutoCAD is also capable of helping you calculate the quantities associated with construction. For instance, calculating the linear feet of a specific improvement is a pay item that's used frequently in production work. In this lesson, we'll learn a quick way to find the total linear feet of any geometry in our drawing. On my screen I have a civil engineering example. This drawing represents a site plan for a proposed restaurant and parking lot. To help calculate the construction costs, I need to provide the total linear feet of the curb and gutter used in this project.

Calculating the overall length of multiple entities

AutoCAD isn't just used for creating and editing linework. AutoCAD is also capable of helping you calculate the quantities associated with construction. For instance, calculating the linear feet of a specific improvement is a pay item that's used frequently in production work. In this lesson, we'll learn a quick way to find the total linear feet of any geometry in our drawing. On my screen I have a civil engineering example. This drawing represents a site plan for a proposed restaurant and parking lot. To help calculate the construction costs, I need to provide the total linear feet of the curb and gutter used in this project.

If I zoom in over here, we can see that this geometry represents the curb and gutter. I have a line that represents the back of curb. one that represents the flow line of curb, and I have a line that represents the edge of pavement. I'm going to be using the geometry on the back of curb layer to do my calculation. So we'll start by isolating this geometry on screen. To do that, I'll open the Layer Properties Manager. I will select the back of curb layer. I will then right-click and I'll come down and choose Invert Selection.

This selects every layer except for the back of curb layer. I will then click the lightbulb to turn all of those layers off. I'll move my cursor back into model space and I'll let that palette collapse. Now some of the geometry that we see on screen are polylines, some of these are line segments, and some of these are arcs. Imagine for a second if I could extract the Length property of each of these entities into a Microsoft Excel spreadsheet. Then I could simply find the sum of all the lengths to find the total length of curb and gutter in this project.

That's exactly what we're going to do. I'll start by selecting the Insert tab and then I'll come down to the Linking & Extraction panel and I'll choose Extract Data. This brings up the Data Extraction tool. This is a wizard that allows us to extract data from the entities in a drawing. I would like to create a new data extraction. So I'll make sure that option is selected and I'll click Next. Then I can give my data extraction a name. I'm saving mine to the desktop. I'm going to call this CGlinear, and I'll be saving this to my desktop.

Now before I click Save, notice I'm saving this as a DXE file. This is a data extraction file. The only reason I save this, let me drag this down, that's because the Data Extraction Wizard is an eight page dialog box and what I'm actually saving are the selections that I make on each of the pages of this wizard. This way if I run the same extraction again in the future, I can simply reuse my previous extraction file or edit an existing extraction file. Let's click Save.

Now AutoCAD is saying, where do you want me to look to find the object data? I'm going to choose Select objects in the current drawing and then I'll click the Select objects icon. I would like AutoCAD to look at these objects, and I'll press Enter and then I'll click Next. Now AutoCAD is saying based on what you told me to look at, this is what I found. I would like to extract the data from each of these object types. So I will leave all of these selected and I'll click Next.

Now AutoCAD wants to know the data I'd like to extract from those objects. I am going to grab this slider and I'll drag this down and just for a second, look at all the properties that I could extract if I wanted to. But right now, I'm going to right-click in the column area and select Uncheck All. And then I'll scroll up and select the Length property, because that's the only data that I'm interested in right now. Let's click Next. AutoCAD is now showing me a preview of how my data will look in Excel.

If I drag this slider down, you can see that AutoCAD has grouped some of these similar entities together. You can see that it found four line segments with a length of two units. Now this grouping is nice, but it would be much easier to add the lengths together if each object was represented as a single entity in this list. So I'm going to come over and remove the check from Combine identical rows. Now each object shows up as a single entry. Let's click Next.

I will select Output data to external file and I'll click the ellipsis button. I'm going to save this file to my Desktop. I'll keep the default name and notice that AutoCAD is going to save this as a Microsoft Excel file. Let me mention that if you do not have Microsoft Excel installed on your machine, you will not be able to save to the Excel file format. If I open up files of type, you can see that there are other file types available. For this example we'll be using the Excel file format. Let's click Save.

I'll click Next and then I'll click Finish to complete my extraction. All right, let's take a look at the Excel file that we just created. Notice the entries in the Length column. Each has a green icon in the corner. If I click in one of these cells, we can see that AutoCAD added an apostrophe when it exported the value. To strip all of these apostrophes, I'm going to click and hold in this top cell. I'll drag down to select all of the cells and I'll click this exclamation point icon and choose Convert to Number.

I will then click in the cell beneath the column. I'll select AutoSum and I'll press Enter and as you can see this project contains nearly 1434 linear feet of proposed curb and gutter. Let's return to AutoCAD. I'm going to click the Home tab and then I'll select Layer Previous to put our layers back the way they were when we started. So the next time you need to calculate construction quantities for your project, don't do the calculations by hand. Instead, use the Data Extraction tool and let AutoCAD do all the work for you.

Show transcript

This video is part of

Image for AutoCAD: Tips, Tricks, and Industry Secrets
AutoCAD: Tips, Tricks, and Industry Secrets

66 video lessons · 8126 viewers

Jeff Bartels
Author

 
Expand all | Collapse all
  1. 1m 28s
    1. Welcome
      53s
    2. Using the exercise files
      35s
  2. 47m 11s
    1. Adding relevant data to Quick Properties and tooltips
      5m 38s
    2. Creating custom ribbon tabs and panels
      8m 55s
    3. Creating macro-enabled tools
      10m 29s
    4. Increasing speed with command aliases
      4m 44s
    5. Finding commands and system variables using Auto Complete
      2m 35s
    6. Optimizing the size of palettes
      3m 17s
    7. Accessing drawings using Favorites
      2m 25s
    8. Controlling notification bubbles
      2m 24s
    9. Restoring hidden messages
      3m 53s
    10. Following a blog from within AutoCAD
      2m 51s
  3. 1h 0m
    1. Disabling mode settings on the fly
      3m 28s
    2. Finding hatch boundaries in busy drawings
      3m 32s
    3. Generating boundaries from difficult shapes
      2m 20s
    4. Calculating the overall length of multiple entities
      6m 16s
    5. Calculating the area of multiple shapes
      4m 42s
    6. Flattening geometry to a single elevation
      4m 0s
    7. Trimming all entities to one side of an object
      2m 42s
    8. Eliminating duplicated geometry
      5m 10s
    9. Creating true offsets
      3m 44s
    10. Finding errors when joining multiple entities
      6m 48s
    11. Moving and copying entities using Windows shortcuts
      2m 24s
    12. Solving expressions using the command prompt calculator
      5m 1s
    13. Using the Calculator palette
      10m 25s
  4. 21m 17s
    1. Bringing all text objects to the front
      1m 20s
    2. Underlining single-line text
      1m 21s
    3. Managing numbered and lettered lists
      3m 36s
    4. Creating superscript and subscript text
      3m 18s
    5. Removing formatting from MTEXT
      3m 26s
    6. Using fields to identify who revised a drawing
      3m 10s
    7. Squeezing text into tight spaces
      3m 5s
    8. Hiding extra annotative scales
      2m 1s
  5. 16m 55s
    1. Creating "one-click" dimensions
      1m 52s
    2. Dimensioning angles greater than 180 degrees
      1m 40s
    3. Creating dynamic dimension breaks
      2m 20s
    4. Making linear dimensions act like aligned dimensions
      2m 44s
    5. Finding dimensions with false values
      1m 38s
    6. Creating parent/child dimension styles
      4m 45s
    7. Making dimensions easier to read
      1m 56s
  6. 14m 40s
    1. Making global edits to attribute data
      4m 1s
    2. Clipping references using curved geometry
      2m 21s
    3. Exchanging one block symbol for another
      3m 3s
    4. Using drag-and-drop to insert content
      3m 17s
    5. Creating a block library in two clicks
      1m 58s
  7. 10m 42s
    1. Making global changes to layer names
      3m 19s
    2. Converting all object properties to BYLAYER
      1m 43s
    3. Navigating layer lists using the keyboard
      2m 5s
    4. Producing a hard copy of the layer settings
      1m 34s
    5. Removing stubborn layers
      2m 1s
  8. 25m 1s
    1. Accessing viewports within viewports
      3m 21s
    2. Creating viewports with islands
      6m 5s
    3. Creating legends using the Change Space tool
      3m 55s
    4. Rotating viewport content to match layout
      4m 55s
    5. Importing layouts from template files
      2m 3s
    6. Visualizing multiple design alternates
      4m 42s
  9. 30m 18s
    1. Consolidating backup files into a single folder
      2m 48s
    2. Launching applications from within AutoCAD
      3m 53s
    3. Creating custom linetypes
      5m 9s
    4. Incorporating symbols into custom linetypes
      2m 48s
    5. Salvaging data from a corrupt drawing
      3m 57s
    6. Applying hyperlinks to drawing objects
      3m 34s
    7. Converting drawings from name-based to color-based plot styles
      2m 0s
    8. Identifying the owner of a drawing
      1m 18s
    9. Incorporating drawings into PowerPoint presentations
      4m 51s
  10. 31s
    1. Goodbye
      31s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now "Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed AutoCAD: Tips, Tricks, and Industry Secrets.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.