NEWS/UPDATES     LOGIN     SITE MAP

Your success; there is no compromise.
September 6, 2010          
BLOG  

Archive for the ‘Design Automation’ Category

CADmech presentation at the University of Western Ontario

Friday, October 31st, 2008

 

Last Monday, October 27, CADmech was pleased to make a presentation for the Mechanical Engineering class of 2011 at the University of Western Ontario. Representing CADmech, Joseph Vera, provided an informative discussion regarding Knowledge Based Engineering (KBE). This presentation included case studies where Excel and DriveWorksXpress (design automation software for SolidWorks) were utilized to streamline the design process for several of CADmech customers. It was our pleasure to bring a taste of real life engineering into the classroom. We would like to extend our thanks to professor Paul Kurowski for his kind invitation. Incidentally, last year we also had the honour of presenting in his class, here is a picture of that event.

  

- by Jason MacFarlane

 

Presentation at UOW

Design Automation at Cancoil Thermal

Thursday, September 4th, 2008

  

In a recent project we had the pleasure of working with Cancoil Thermal in a very interesting Design Automation project. Cancoil is one of the fastest growing manufacturers of commercial refrigeration products in North America. The team at Cancoil prides itself in its ability to design and manufacture products specific to its customers needs. In this project we helped Cancoil Thermal reduce the product development times of their finned tube coils by automating key areas of their design process. Here are some interesting notes about this project.

 

The project began with a customer’s needs analysis. This is a very important step that is done to gain an understanding of the customer’s business. Interviews were held with Cancoil’s team members in order to identify their requirements and to outline their design process. In addition to this, some of Cancoil’s previous designs were reviewed in detail. The needs analysis was instrumental in helping us develop a design automation solution as well as a comprehensive implementation plan.

 

Here is a list of Cancoil’s requirements:

 

·    Consistent and repeatable design approach by all designers

·    Solution must capture design rules and generate new designs

·    Solution must be implemented in a relatively short period of time

·    Use existing software (in this case, SolidWorks and DriveWorksXpress)

·    Avoid custom programming and code maintenance

 

 

Three (3) possible solutions were considered to automate the design process:

 

1.   To create a custom VB.Net program that uses the SolidWorks API

2.   To create an Excel Design Table in SolidWorks

3.   To develop a rules-based solution using DriveWorksXpress

 

Option 1 was discarded since the customer wanted to avoid the additional costs and maintenance that come with a customized programming solution. Option 2 was also discarded since Design Tables are used to create new configurations and the customer needed to create new independent models for each new design. We chose Option 3 since it met all of the customer’s requirements (e.g. it did not require additional software and did not require programming). In addition to this DriveWorksXpress gave the customer an upgrade path (i.e. they could in the future upgrade to the full version of DriveWorks for additional automation and functionality).

 

The next step was to develop the new design process. During the interviews we found out that the design of the End Plates followed very clear rules. This prompted us to decide to use DriveWorksXpress to automate the design of the End Plates. We then decided to use standard SolidWorks tools to semi-automate the design of the tubing and other components, since they had rules that required more flexibility. The following new design process was completed:

 

1.   Create a new Coil assembly

2.   Generate new End Plate design using DriveWorksXpress

3.   Add Library components such as tubing using SolidWorks Smart Mates to the Coil assembly

4.   Create Header Subassembly using the Library

5.   Generate Manufacturing drawings

 

Here is a flow diagram of the process:

 

 

Once the process was developed the next step was to test it in order to ensure that the new designs were generated quickly and accurately. To do this we re-engineered several existing designs to see how much faster we could generate them with the new process and also to ensure that there were no errors. All of our tests showed that the new process was not only faster but that it greatly reduced the chances of making mistakes.

 

After the testing was concluded the new process was officially implemented at Cancoil. This new automated design process resulted in several benefits to Cancoil such as:

 

·    Design tasks that previously were very time consuming are now streamlined via a Rules-Based System (e.g. the End Plate Design)

·    Designers can quickly generate and release Manufacturing Drawings for production

·    Previously the design process took 2 days; now with the Design Automation Solution it takes 4 hours to complete a design. A 75% reduction in time.

 

To see how your company could also benefit from design automation please feel free to contact us.

  

- by Joseph Vera 

 

Automate Repetitive Tasks

Friday, August 1st, 2008

 

Imagine that you are working on a rather long design project. When you first started the project the customer said that the units should be in inches, but near the end of the project the customer calls to tell you that they now need to be in millimeters. So now your job is to change the units from inches to millimeters in every single one of the CAD files used in the project. What are you going to do? There are hundreds of files and you can’t open every one of them manually and then change the units. One solution would be to use the CAD system’s Application Programming Interface (API) to automate this operation. A CAD system’s API allows programming languages, such as VB.Net, to access specific CAD functions in order to automate repetitive tasks, such as: changing the units, exporting files, and other batch operations.

 

How would you use the API to automate this particular operation? In this case you could create a program that loops through all the files in a folder and changes the units of each CAD file. What code would you use? One way would be to use the Dir function (which is available in Visual Basic, VB.Net and VBA).  Here is what the code would look like:

 

fn = Dir(”C:\folder\*.CAD file extension”)   ‘sets the folder to loop

Do While fn <> “”   ‘keeps looping until it has gone through all the files

‘Open the CAD file *

‘Change the units *

‘Save the CAD file *

‘Close the CAD file *

fn = Dir    ‘goes to the next CAD file in the folder

Loop

 

* Refer to your CAD system’s API for the code to do these steps

 

Note that this routine works in: SolidWorks, CATIA, NX and Pro/E. Of course the API code for opening the file, changing the units, saving the file and closing the file is different in each CAD system. However, the Dir function and the Do While Loop work for all these systems since they are actual VB functions and are completely independent of the CAD system you are using.

 

This is only one example. There are an infinite number of tasks that can be automated using your CAD systems API in combination with Visual Basic, .NET or VBA. For more information please feel free to contact us.

 

- by Joseph Vera

Excel Tips

Friday, June 13th, 2008

 

Excel has become an indispensable tool for many designers and engineers for a number of reasons. For starters, it can handle many complex design and engineering calculations. Also, it is very good for creating and managing tables of data. And finally, Excel can be linked to almost any CAD system. Note that this can help you automate your design process.

 

So if you are a designer or an engineer chances are you will end up using Excel. We at CADmech have been using Excel for many applications and would like to share some tips with you.

 

Data Validation and Drop Down Lists

 

Data Validation is a tool that helps you ensure that the data that is being entered is correct. For example if you don’t want to allow negative numbers in a cell, you can set up a limit range so that only positive numbers are allowed. This is very useful for CAD, since many CAD tools don’t allow negative values for lengths.

 

Another way to ensure the data you enter is valid is to add a Drop Down List so that your choices are limited to the items in the list. For example, let’s say you had to enter a voltage then your choices may be limited to 120V or 347V as per the picture below.

 

 

Look Up Tables

 

In mechanical design when you change one parameter usually you need to change several other parameters that are affected. For example if you make a structure higher you may need to have additional supports. One way to handle these changes is by using IF statements. However, IF statements specially long ones can become cumbersome to manage. A better way to manage several design parameters is via Look Up Tables.

 

Look Up Tables allow you to store information in table format and then pull the information when needed.  For example, let’s look at the design of a combustion burner. Note that there are two types of fuel you could select: Natural Gas or Oil. The one you choose will affect several other parameters such as: the ignition system, the type of refractory, and the weight of the combustion chamber etc. If you select Oil then you will need an Oil Igniter (which is more powerful than a Gas Igniter), also you can’t use Ceramic refractory since oil can soak up in the Ceramic, so you will need a Brick refractory. Note that Brick refractory requires the installation of anchors (Ceramic refractory does not), so you will need to install anchors. Also Brick refractory is heavier and therefore heavy-duty lifting lugs are required. All this would make for a very long and complicated IF statement. Or you could use a simple Look Up Table like the one below to get the job done:

 


Functions

 

Part of an engineer’s job is to size equipment. Many times calculations are used to select equipment. But what happens when your calculations tell you that you need one and a half pumps? Well you would round up and use 2 pumps. Note that you can round a number with Excel, since Excel has functions that force you to select whole numbers, such as: TRUNC, ROUNDUP, and ROUNDDOWN.

 

Conclusion

 

Data Validation, Drop Down Lists, Look Up Tables and Functions are very helpful to designers and engineers. These Excel tips combined with CAD can become very powerful design automation tools in your collection.

 

- by Joseph Vera