Skip to main content

Posts

Showing posts with the label Excel Integration

Featured Post

Why I Wrote The Sheet Mechanic (And Why Calculations Aren’t Enough)

For engineers who already know the math—but still lose projects. For the last few years, I’ve been sharing technical guides here on Mechanical Design Handbook —how to size a motor, how to calculate fits, and (as you recently read) how to choose between timing belts and ball screws. But after 25 years in industrial automation, I realized something uncomfortable: Projects rarely fail because the math was wrong. They fail because: The client changed the scope three times in one week. A critical vendor lied about a shipping date (and no one verified it). The installation technician couldn’t fit a wrench into the gap we designed. University taught us the physics. It didn’t teach us the reality. That gap is why I wrote my new book, The Sheet Mechanic . This is not a textbook. It is a field manual for the messy, political, and chaotic space between the CAD model and the factory floor. It captures the systems I’ve used to survive industrial projec...
NEW RELEASE: Stop trying to be a Hero. Start being a Mechanic. Get "The Sheet Mechanic" on Amazon »
Disclosure: As an Amazon Associate, I earn from qualifying purchases.

NX Motion Simulation Part 4: Spreadsheet Run & Final Animation

In [ Part 3 of this series ], we set up the kinematic joints for our machine. However, the drivers are currently set to "Constant Velocity," which does not reflect reality. Advertisement Now, we execute the most powerful part of the Digital Twin workflow: injecting our precise timing diagram data from Excel directly into the 3D simulation. Step 1: Exporting Joint Data to Excel 1. Select the "Graphing" command. This tool is typically used to view results, but we will use it to open the data channel. 2. Select "Spreadsheet" . This tells NX to bridge the data into Microsoft Excel. 3. Click OK. NX will automatically launch Excel. You will see columns for "drv J_Mill" and "drv J_Die" with linear values. These are the default placeholders we created earlier. We must replace these with our optimized curves. Step 2: Preparing the Data ...

NX Motion Simulation: Integrating Excel Timing Diagrams - Part 1

During the process of timing diagram design , I normally start with detailed calculations in an Excel spreadsheet to minimize acceleration while satisfying the required process cycle time. Advertisement Once I can visualize the preferred displacement, velocity, and acceleration profiles of the mechanisms in Excel, the question becomes: What's next? Shall I start manufacturing immediately? The answer is NO. In modern engineering, we use Digital Twin Technology to verify the design first. From Excel to 3D Simulation Currently, I use Unigraphics (UG) NX4 (now Siemens NX) to design the mechanical parts. When the assembly modeling is done, I use the assembly model to simulate the movement of mechanisms with the Motion Simulation Module . This step is critical for Virtual Commissioning . It helps confirm the timing diagram before releasing the design for manufacturing. It is especially useful when movements are combined in ...

Solid Edge Sketch Motion Simulation using Excel VBA - Part 2

To link Solid Edge variables to Microsoft Excel, we can do so by entering a formula in the variables table or by using VBA code. Advertisement In this post, I would like to show how easy it is to make it using the variables table. You can use the Variable Table to define and edit functional relationships between the dimensions of a design in a familiar spreadsheet format. The Variable Table is accessed with the Variables command on the Tools menu (or the Tools tab > Variables group in modern versions). There are two types of variables: dimensions displayed in the design and variables you create directly in the Variable Table. Dimension variables directly control elements of a design. Variables that you create cannot directly control the design but can drive dimension variables. A user variable must be set equal to a value or mathematical expression; for example, PI = 3.14159. Let's begin... 1. Create the Mechanism Sketch ...