Tuesday, 6 May 2014

Industrial Robotics & Solid Edge 3

Step 7 :

Next you will link the Excel values to the variables in Solid Edge and control the parameters from the spreadsheet.

Switch to Excel and right click on the cell with the value for Length.

Select Copy from the menu.

clip_image002

Step 8 :

Switch to Solid Edge and Right click on the extreme left side of the row for the Length variable.

See figure below :

clip_image004

From the menu that appears, select Paste Link.

Step 9 :

The Excel cell and the Solid Edge variable are now permanently linked.

Similarly, Copy-Paste Link other variables – Width and Height.

Save both Excel and Solid Edge files.

Step 10 :

Right click on the windows taskbar and select Tile Vertically.

clip_image006

Step 11 :

This will arrange Solid Edge and Excel to occupy the screen equally and vertically. See figure below :

clip_image008

This helps you to visualize the changes that take place in the model as you change the values in Excel.

Go ahead and modify the Length parameter in Excel.

As soon as you press enter in Excel, the model updates to reflect the new value.

Along similar lines, you can modify the values of constraints in a Solid Edge assembly. For eg. the value of Mate offset, Align Offset and the angle value of an Angle constrain. This exercise will taken up in the next Workshop.

Summary of Workshop 1

In this workshop you have learnt :

  1. About the Variable table in Solid Edge.
  2. How an Excel spreadsheet can be linked to a Solid Edge model.
  3. That a Solid Edge model and assembly can be controlled from a Excel file with real time feedback.