Thursday, February 25, 2010

Why You Should Turn Off Your Computer At Night

1.) It's one of the easiest things you can do to be green and save energy. The power required to run all one billion (estimated) of the world's PCs for just one night is enough to power the Empire State Building inside and out for 30 years. (PC World)

2.) Turning your computer off gives your Random Access Memory (RAM) a chance to defragment and increases your computer's speed the next day. Sleep and Hibernate do not do this.

3.) It's good for your computer, because it gives the components a chance to cool down. This should decrease the wear and tear on the computer when they were turned off.

....and the fourth and final reason is

4.) You are supposed too, it's an office standard.

Tuesday, February 16, 2010

Xrefs - Overlay vs. Attachment

The Difference Between "Overlay" and "Attachment"

"Overlay"
Using the "Overlay" method means that the referenced drawing you are inserting will be viewed in the current drawing only. It will not follow the current drawing to the next drawing. It is the simplest form of reference file and as a result it is the most used method of inserting a xref into a drawing. This is a nice method to use when handling a drawing or two from a consultant or in house drawings. Notice in the example below that Drawings A, B, and C are inserted using the "Overlay" method into drawing D. Then D is inserted into drawing E and notice that A, B, and C do not follow drawing D when inserted into drawing E.



"Attachment"
Using the "Attachment" method means that the drawing you are inserting can be viewed the current drawing and all other drawings you insert the current drawing into. This a good method when you have complex drawings that have many other referenced files. A good example is an architect's drawing that has three or more drawings referenced into it (like difference floors). Notice in the example below that Drawings A, B, and C are "Attached" into drawing D. Then D is inserted into drawing E (also like above), but he difference is that A, B, and C now follow drawing D when inserted into drawing E.



How Can I Make My External References Overlay or Attached?

Method #1
Choose either "Overlay" or "Attach" from the xref dialog box when inserting the drawing. (As shown below for AutoCAD 2008 and 2010). The option will lie in the "Reference Type" frame.





Method #2
Use the xref palette to change "Type" of xref (shown below) if they are already inserted into your drawing. You will not be able to change nested xrefs. This option will be grayed out if this is the case.

Wednesday, February 3, 2010

How To Import Excel Spreadsheets Into AutoCAD

I have had a lot of questions lately about how to import excel spreadsheets into an AutoCAD drawing. Here is the method that Autodesk suggests. They highly discourage copying and pasting as an OLE object, and using the insert OLE object due to it's inconsistencies.



A. Open the Spreadsheet
B. Select the area to copy
C. Copy the Selection (CTRL+C)



D. Open the CAD Drawing and to the Pulldown Edit->Paste Special (or Ribbon Home->Clipboard->Paste->Paste Special)



E. In the Paste Special Dialog box select "AutoCAD Entities".



Note: you can select "Paste Link" and then select AutoCAD Entities if you want to link the file.



F. Select the Insert point, then the excel spread sheet will become a table. You can then create a table style for your Excel documents that will customize the look with the table style or you can leave the table with the same formatting as the Excel spreadsheet.

FAQ'S ABOUT INSERTING EXCEL SPREADSHEETS

1. Can I change the look of the spreadsheet?
- Yes you can change the look of the spreadsheet by using the "TABLESTYLE" command. This will bring up a dialog to create a table style that can be applied to the excel spreadsheet. Otherwise the table will have all the same properties as the excel spreadsheet including color, fonts, background fill, and cell lines.

2. What does the padlock and chain link icon mean when I am working with a table?
- The padlock means that the spreadsheet is locked and to edit the data in the spreadsheet you will need to update the data in the excel version and it will be updated in the AutoCAD table version.
- The chain link means that it is linked to a file. When a file is linked, the table is locked. However, you can lock a table without it being linked.

3. What should I name my Tables?
- They should start with "TBG-" and then a description. This will help differentiate your table with other consultant's tables.

4. How do I know when there is an update for my table and how do I update it?
- There will be a link in the lower right hand corner of drawing. If you right click on that link there will be an option to "Update Links". This will update all linked data in your drawing. Right now there is no way to update individual linked objects.

5. What is a quick way to edit the linked spreadsheet without having to browse to the file?
- Go to the reference palette and right click on the spreadsheet. There should be an option to open the linked file. (When finished you can also right click and update links as well).

Tuesday, February 2, 2010

Color and Linetype Standards

Linetype Standards
We don't have many office standards governing linetypes, just three really.

1. All Colors for objects (except for details) should be "ByLayer".
1. All Linetypes for objects (except for details) should be "ByLayer".
2. All Linetypes (except for details) should have a scale of 1. (Variable "celtscale" or current element linetype scale.)

That's not too hard.

Why can I not match properties to a linetype?
There are a few reasons:
1.) Either the MatchProp settings do not include Linetype
2.) We do not have that linetype in our library and will not match properties to it.

Why are details exempt from being ByLayer?
The main reason that object colors and linetypes are exempt from being ByLayer in details is because details are not externally referenced into other types of drawings. Details are drawn as what you see is what you get. 

Why can I not see my linetype correctly?
There can be several reasons.
1.) You are drawing a line while CELTSCALE =1 the properties palette and looking at the linetype scale.
2.) Make sure the linetype is ByLayer..
3.) Make sure it is a linetype we have. Just because a linetype appears in a drawing does not mean we have it.
4.) Choose a smaller or larger linetype, and do not change the LTSCALE.
6.) Use the layer dialog and make sure it is assigned the correct linetype.

Why will the colors not stay when I apply them to an xref?
The variable "visretain" is set to 0. It needs to be set to 1.

Why can I not change the color of the object in my xref using the layer dialog?
Because the object in the referenced drawing is not set to ByLayer?

Two Minute Training Blog Updates

There have been a few changes to the Two Minute Training Blog.

- The labels have been reorganized according to topic such as, Program Type, How To Articles, Commands, and Standards.

- This will end up being our CAD Manual organized by topic and searchable.

- Now, would be a good time to brush up and refresh your knowledge of the office standards as these are published.

- If you would like to know more about a topic, problem, need a standard, or don't like a standard (maybe it's something we need to revisit) please send your CAD Manger an email or just leave a comment on the blog. (They are moderated so they do not appear immediately).

Multiple e-mail issue:
Sorry for the technical issue contributing to the multiple e-mails that was not meant to happen.

Monday, February 1, 2010

Using Make Single Project Directory - "SPJ"

Where to find the SPJ command:
1. Pulldown menu: File->New Single Project
2. Ribbon menu: Title->New Projects->Single Project
3. Command Line: "SPJ"

What does New Single Project do exactly?
- Creates the primary folder with the project name and the job number.
- Creates all the sub-folders that are needed for a project
- Creates all the blank CAD drawings with the correct job numbers
- Creates the sheet set needed for the project with the job number.
- Will include folder updates that have been approved by the CAD Steering Committee.

FAQ's
Why do we use the SPJ command?
- Because there is a lot to remember when making a new project folder, the SPJ command will create all the necessary folders and start up files you will need for the project.

Why do we have to use AutoCAD to make the new project directory? I don't start a project using AutoCAD.
- Right now, this is the only way to ask for input and apply that to information to new project folders, files, and other information.

Why can't I just make a folder to copy over and over again for new projects?
- We could do it that way, but what the SPJ command does for you is rename all the folders and files based that project number. This saves you a lot of time.

What if someone made the job folder, but didn't include all right folders and files information?
- Run SPJ and use the exact same project name. It will create the correct folder structure and will not overwrite or delete existing information. This will also give you all your standard folder and file names with the job number.

What if the project does not have a job number?

- Every project should have a job number. If the folder does not have the project number and has work in it, then when it gets a job number add the job number to the folder and repath all the linked files. The sooner you do this the better.