« October 2007 | Main | January 2008 »

Tuesday, November 20, 2007

The "Power" Of Excel and AutoCAD Electrical©


Recently I have spent quite a bit of time working on AutoCAD Electrical data mastering. What this means is I am taking legacy AutoCAD (or other CAD systems) drawings (possibly even only hard printed copy) then completing them in AutoCAD Electrical as a complete set of data. How far we take it really depends on the project and the client requirements are. There are some very powerful workflows that can be used when trying to work on mastering this data set.


The two main tools in this workflow is AutoCAD Electrical and Microsoft Excel. There are several tools in AutoCAD Electrical that allow the "Export" of AutoCAD Electrical to several different formats including Microsoft Excel. Microsoft Excel is a great tool for performing find / replace of data, copying of data, comparisons etc… Some things you might want to change could be a description from "Hydraulic" to "Pneumatic" or even update location / installation codes from an old location to a new one.


After manipulating the data to obtain the results you require, you can use the AutoCAD Electrical Update from Spreadsheet tool. Now AutoCAD Electrical will read that information from the Excel spreadsheet and start working on updating your data.


More to Come…..

OneNote Blogging???

Tuesday, November 20, 2007

5:18 PM

I am sitting at the kitchen table using Microsoft OneNote for some normal note taking tasks with some other projects when I stumbled upon a "Blog This" option in the right click menu of OneNote. This got me to thinking how much easier it will be to post blogs. I take notes all of the time in Microsoft OneNote and have it organized pretty well for work projects, home projects, hobbies, and soon to be blogs.


We will see how this helps.



Rob Stein


Saturday, November 17, 2007

The new look.....

Recently I took part in the whole Simpsonize trend. I think it looks pretty cool and I decided to put it on this site.

See you at Autodesk University.

Monday, November 12, 2007

Back from Chicago..... Finally...

Last week I had probably one of the craziest experiences traveling to Chicago from Detroit, then back to Detroit from Chicago. Anyone who knows me probably already knows my horrible track record with traveling to Chicago or home from Chicago. Weather it is by Air, or by Car something always seems to make the travel portion of the trip so much longer.

This trip flying into Chicago O'Hare, we were grounded in Detroit, because O'Hare closed down 1 of their 3 runways because of some cross wind on that runway. This delayed me getting in by 1.5 hours, which also messed up my ride from the airport to the hotel. OK, not a huge deal, better safe and late with the high winds. Cool, I am over it.

During the week I had to take a cab to and from the client which was defiantly interesting to say the least.  We had everything from the driver who would slow way down because they were trying to drive up the fare costs, all the way to the cab driver that was trying to keep the fare low, but make a good tip for getting us there fast. The latter of the two reminded me of that game Crazy Taxi. (http://www.sega.com/gamesite/crazytaxifarewars/minigame/index.html).

So now it comes to Friday. Awesome, I get to go home and see my wife and kids. I leave the client site at about 3pm like they recommended to catch my 7pm flight. I already had the Shuttle scheduled to pick me up at the hotel at 3:40 which would have given me plenty of time to get to the airport, through security and catch my flight. Well they never showed up, my back up plan of taking a cab would have cost my first born child, and the cab drivers all said they weren't driving to O'Hare during rush hour. I ended up taking the train back from Chicago to Royal Oak.

After taking the train in such a last minute situation and having that work out so nice I think i am going to use that as my method of travel to and from Chicago from now on. I mean the train station is 13 miles away from my house in Michigan. No long security lines, more room in the seats, power plugs for each seat on the train, a snack car with food and alcohol and it left on time and arrived on time.

Keep the train in mind when traveling from Michigan to Chicago or Chicago to Michigan.

Friday, November 09, 2007

New Funniest Street Beggar Pick Up Line.....

I have been in Chicago all week doing the walk to lunch, catching cabs, etc... Well today Tiffany and I went to Union Station at lunch to grab something quick and take back to the client site.  We got approached by a street beggar with a Styrofoam cup saying "Can I have my allowance?".

I thought that was the best ever line.