Yet another Golden Rule broken....again

What Golden Rule? The one that says:

"If you draw everything, then there is less surprises in store for you!"

Recently, I had to draw a simple platform next to a dust extractor. The purpose of the platform was to enable maintenance persons to get access to Stuvex bottles. These bottles are an anti-explosion device and as far as I know, sense and explosion and release some sort of dampening gas so the explosion is nullified.

Just to make life complicated, it was located up alongside an old wall, which had pipes, electrical trunking and so on either side of a corrugated iron wall. I have found out the hard way, that it is easy for a draftsman to say- "This pipe will be in the way....it will have to be moved." "Yeah, but, where to?!" Easier drawn than done it appears.

The platform ended up being on 2 levels, and the lower one looked fine in the plan view: Yes, fine until you asked yourself: How to get it in that place? Fortunately, the man on the job is highly intelligent and made it bolted so it would fit in. Except there was a brace, not drawn, apparently in the way. Not a big deal, it can be relocated, but to have noted this on the drawing would have saved drafting embarrasment.

Which highlights a problem found often in drafting: You need to bash together a concept drawing, and then go through numerous changes to the design before it solidifies. By the time that happens, you are quite convinced that your drawing is accurate and wonderful.

At this point the thing to do is kick your own butt out onto the site and site check your critical dimensions. I do this now by forcing myself to put these dimensions on the drawings and putting heavy boxes around critical dimensions.

I guess the lesson I'm slowly learning here is that the initial site measuring should be thorough and accurate and not to trust old drawings, even ones that were done by yourself.

Finally, a quote sent to me that seems on the nail:

"We moderns have managed to combine an incredible mastery of technical knowledge and information with an astonishing ignorance of the traditional wisdom once possessed by an illiterate village elder, and evident for all to see on every page of history.

Spend more than you earn and you’ll go broke.

Give someone something for nothing, and he’ll soon expect something for nothing on a regular basis.

Fail to hold people accountable for their bad behavior, and they’ll continue to act badly.

Give people an excuse to fail, and they’re more likely to fail.

Let aggression go unpunished, and you’ll get more aggression."

-Bruce S. Thornton

The guy who sent me this one made the following suggestion:

(except substitute 'we moderns' with 'dimwitted lefties')

He hates Autocad....not really...Part 2 of Excel to Autocad

I showed my PLC Excel application (see my previous post) at work , and the man said, yes, it had promise. As usual, someone else said "The address numbers are not right!" Ok.

So here I have wasted another sunny day (actually, if I go into the sun here in NZ for more than 15 minutes, I get burnt) fiddling with this stuff.

I have done a few changes, mainly the buttons that were embedded in the spreadsheet have now been transferred to a User Form, this is activated by the Quick Access menu. It just allows the user to scroll up and down and get the buttons to show only when necessary.

The range of equipment is now light, relay and solenoid valve. The silly idea of having each line drawn has been ditched in favour of block that just gets inserted.

The existing drawings like to tell the viewer that this is an "alarm light". Which seems extra work when you have a symbol that conveys that information. Same for the solenoid valve.

I did toy briefly with the idea of downloading the IEC 6017 electrical symbols. Yes, you can, but they cost. I had some doubts as to the snapping I should be using, but I figure if this all goes ahead and someone says they want 2mm snaps instead of 1.5mm, then it would not be that horrible to change.

He hates Autocad down by the sea shore...

Hate is probably too strong a word. Prefers to avoid might be better. He is an electrical person who organises motors to start, stop and so on. He will never read this, but just in case I will refer to him as "Fred" (not his real name).

This is done by means of PLC's (Programmable Logic Controllers). My knowledge of these is limited to the following:
They have cabinets, and in these cabinets are "racks" and in the racks are "cards".

The cards are where the wires from say a relay are connected to. It appears Fred is quite OK with Excel and happily puts all his stuff into a spreadsheet. If the electricians were happy with this, instead of a drawing, then life would be easy.

But no. They like drawings, done in Autocad because that has been the way of things for quite a while. Recently, he gave me some drawings to update, which involve me typing hundreds of times the same thing over and over again. Words like REMOTE and FAULT. I have now requested we get a program called "Active Words" which just stores up your keystrokes and you can allocate hot keys to them.

This all triggered an idea (no doubt not new!) to see if I could give Autocad an Excel connection.
The plan was to have a spreadsheet all set up with buttons on it to make filling it out a quick thing, then a button to generate an Autocad script file. I did this once years ago, and have no idea where all the files ended up, so thought it might be fun to do a new approach. It is summer here now in Auckland and maybe fun might be getting out to the beach.

Another wasted weekend later, I have a bare bones setup that works. It was a struggle with Microsoft Excel 2007, as I was used to the 1997 version. Little differences like: you have to have a macro enabled file type, the ribbon where things seem to be never where you think they might be. Plus, if you want VBA, you have to add the "Developer" tab to the ribbon.

Here is a screen shot of the spreadsheet:

This is a snippet of the VBA screen, showing part of the code:

This one is a shot of a typical autocad drawing of a PLC card:

This one here shows a line of script generated lines and text:

They have only got LT Autocad, so a script is the only way here. I have been down this rocky road before in a way: I tried to do the same thing, but using their existing blocks, which became a nightmare.

This time: no blocks, just lines and text, it is just simpler. Having said that, the line shown was hard coded-ie the coordinates of everything had to be specified. If this goes any further, there would have to be a lot of number adding and string converting.

That's if....

Menu Pulldowns

I have often wondered why Autocad does not ship with useful stuff as shown above. Even if it was supplied as a .mnu file, then it would be a 5 minute task to have it up and running should user want it, without cluttering up a standard installation.

The obvious answer is that Autodesk has to look after all it's 3rd party add-on sellers. Just a commercial reality I suppose.

The Flanges just come in as a block. The Fixings1 items come in as individual bits. Fixings2 - they come in as "combos" ie a set of head, flat washer, spring washer, and nut.

To make one of these for yourself is not that hard.

Just fire up Notepad (Look under Start/Programs/Accessories)

and type in something like this:

***MENUGROUP=BILRO1

***POP13
[Fixings1]

[M6 Bolt Head] -insert;"C:/cad/library/3D/fixings/bolter/m6headb";\1;1;0;

Then save it as not a text file, but with a ".mnu" on the end so the file name ends up something like Bilro1.mnu.

The syntax looks a bit arcane, but just go with the flow.... You can see where the path is, and the block name (ie just another dwg file) is, and all the ;\1;1;0; is a shorthand way of saying:

enter,pause,use a scale factor of 1 for X,enter, scale factor of 1 for Y,enter,use a rotation of zero,enter.

To sum up:

; means enter

\means pause for user input

Then you have the fun of getting it into Autocad, so just:

1. Right click on any toolbar, and choose customise.

2. See the little round button with the arrow down the bottom? Hit it.

(There is someone in Autodesk that loves to hide things....)

3. Now pick the Transfer tab up the top.

4. Hit the 2nd button from the right, one that should give a tooltip of "open customisation file".

5.When the dialog comes up look down the bottom-it will say something like "...cuix" or "cui", so change this to legacy files-mnu, and hunt for your file.

Although Autocad does not tell you this, I believe (I can always be wrong!) that it converts it to a cui or cuix file as you open it.

6. On the right panel, expand the + next to "Menus". You should see your new headings there.

7. On the left panel, do the same. You should see the standard menu headings there.

8. Go back to the right panel, pick your first item, hold down shift to select all your items, then drag and drop to the left panel in the position you would like them to occupy.

9. Hit OK.

After some humming and whirring, you should have your menu additions!

As you can see, the Fixings and Flanges are most likely foreign to you as here in NZ we use British Standard Flanges usually.

Now comes the part I had a lot of hassle with: What happens if you get the path name wrong, and need to update it? You would think it should be straight forward, but I did not find it that logical.

How to do it:

Do the same actions as above, but stop at item 7. On the left panel, right click on the items you have added previously and choose "delete". Yes, you are sure! Then from the right panel drag your headings back onto the left panel as before.

I am going to add a few more bits and pieces, and then I hope to post the whole lot as a bundle on http://bilrocad.com/

Video Postings

I have been sort of busy doing some videos of my window frame drawing lisp set.

The above is an experiment to see if video embedding works.

The other videos can be found on youtube, just type bilrocad into the search box.

We had a long weekend here in Auckland, and I have been trying to find out how to stop huffing sounds when doing a video. (Maybe I should get a life? ...or paint the fence???)

For probably equally strange reasons I started doing a test of my Autocad skills on Brainbench, but made a bit of a hash of it and got a case of the "can't be bothereds" half way through. If you are tempted to do the test, make sure you have Autocad up and running before you start!

Sort of Autocad, and who is Nate Holt anyway?

Sometimes I end up doing electrical drawings, which is quite irritating, because I'm not sure what I'm doing. I did actually get a New Zealand Certificate, Electrical in 1988, which I never ever used. I did go for the odd job, only to be told (no doubt quite rightly!), how long were you a tradesman electrician? On hearing the answer, I was told to sling my hook.

So I know what a relay is etc, but how everything hangs together and why is a bit of a mystery to me.

Recently, I tried to look for a lisp that would allow me to align some text, and in the process of looking ended up at a blog page of a man called Nate Holt. My first reaction was: "Wow! This guy can really do a good job explaining things!" Check out his blog yourself at:

http://nateholt.wordpress.com/2010/08/24/add-sounds-to-your-too-quiet-autolisp-utility/

On digging a little deeper, it turns out he is someow connected to Autocad Electrical, that is a "vertical" of Autocad, meaning it tacks on or adds to standard Autocad. Which led me to:

http://download.autodesk.com/us/autocadelectrical/adm717_build_2006-07-21a/index.html

I had a look at some the videos, and have come away quite convinced that this would be the way to go if you had to do Autocad Electrical drawings.

Last week, one of my co-workers popped his head up and asked:

"Hey, how come I have updated the file on my desktop and the other one has also updated?"

I cannot claim the high ground here, because it was about 5 years ago that I discovered that Windows Explorer loves to duplicate the display of it's folders, only to be told "Everyone knows that!" Which apparently is not true, because this man did not know either.

Whoever made Windows Explorer decided to make it "easier to use" and in the process removed it's logicality. By the way, in case you did not know, you can access Windows Explorer by right clicking the Start button.

Here is the top level of the "Desktop" shown in Windows Vista, notice the folder called Pictures:

Double click on Pictures and you get a view of the folders in there:



Then, close everything up and you get:

Next, double click on Computer and then open up Users:



Now double click on Pictures....there are the same damn folders!


Which reminds me of the Microsoft Helicopter Joke:

A helicopter was flying around above Seattle yesterday when an
electrical malfunction disabled all of the aircraft's electronic
navigation and communication equipment. Due to the clouds and haze
the pilot could not determine his position or course to steer to the
airport. The pilot saw a tall building, flew toward it, circled, drew
a handwritten sign and held it in the helicopter's window. The sign
said "WHERE AM I ?" in large letters.

People in the tall building quickly responded to the aircraft, drew a
large sign and held it in a building window. Their sign said, "YOU
ARE IN A HELICOPTER." The pilot smiled, waved, looked at his map and
determine the course to steer to SEATAC (Seattle/Tacoma) airport and
landed safely.

After they were on the ground, the co-pilot asked the pilot how the
"YOU ARE IN A HELICOPTER" sign helped determine their position. The
pilot responded, "I knew that had to be the MICROSOFT building
because they gave me a technically correct but completely useless
answer."

Blocks versus lines and things

I have been playing around with some joinery details, and it came to me that whoever drew them was thinking as he drew, with lines and so on. Once he had those lines, he saw no reason to alter them. Which is fine.

Only problem is, that he wanted to generate more sections based on them, things got a little messy, to the point where he must have said to himself:

"Funny? That dimension should have been 139mm....it is not actually that, on this model....oh well, let's just do a quickie here and alter the dimension text to read what I want instead of what it actually is".

Where's my big hammer?

The trouble is, when you are designing, it is wonderful to use lines etc, but once you have zeroed in on a particular size, make it into a block, so you don't inadvertently stretch it, plus you can reuse it, confident in knowing that it is a set piece of geometry.

I'm thinking here of a sectional view of a window sash.