Course brings SolidWorks and Excel together
A
Professional Education International product story
Edited by the Engineeringtalk editorial team
Aug 31, 2006
Three-day course addresses the development of computer aided design automation and application linkages.
Professional Education International's "SolidWorks/Excel integration using VBA-API" course will be held in Encino, California from 13th to 15th November 2006.
The course will be taught by leading expert Chris Stimson.
This three-day course addresses the development of computer aided design automation and application linkages.
The course will explain the process of creating data linkages between SolidWorks and Excel.
An understanding of this process will enable the development of customised SolidWorks tools.
"For example, a point cloud tool can be developed for importing data points into SolidWorks from Excel or any text file", says Stimson.
There will be a key discussion on SolidWorks automation as it relates to SolidWorks parts, assembly and drawing documents.
This will facilitate a design engineer to develop sub procedures to implement tedious processes such as transferring a solid model to a drawing format.
This hands-on workshop is designed to have an immediate impact on the way that SolidWorks CAD users can integrate their CAD models with systems level analysis, trade studies, and system level optimisation.
Excel Spreadsheets are utilised as the system level tool integration platform.
The underlying key to implementing this process is for the user to gain experience and knowledge on the use of Visual Basic for Applications (VBA) in both Excel and SolidWorks.
Extensive use of VBA is the key to unlocking all the features of SolidWorks and reducing the amount of tedious work.
This provides the ability to move away from the CAD interface to the more familiar Excel application.
Those who attend this intensive hands-on workshop experience a dramatic change in their use of SolidWorks in the design integration process.
Benefits include increased productivity, automation of tedious tasks, SolidWorks' part and assembly automation, development functions, forms and templates, improved documentation and configuration management, and improved team interaction and parameter sharing.
This workshop requires knowledge of SolidWorks and Excel/VBA.
Design engineers using CAD programs will find this course immediately useful, practical and eye-opening.
Participants should have a computer background including basic keyboard and Excel skills.
The instructor, Chris Stimson, received his Master's Degree in mechanical engineering from California State University, Northridge (CSUN) and is currently employed as a Project Engineer at Moog in Chatsworth, California.
He is a SolidWorks/Excel Applications Specialist for SpreadsheetWorld and is an instructor at CSUN.
Stimson is a pioneer in the integration of Excel and SolidWorks using the VBA Application Programming Interface (API).
At Moog, he oversees the development of their space components product line.
He teaches an advanced design integration graduate course at CSUN which includes topics taught this workshop.
His master's project at CSUN focused on "Automation of the CAD design of a positive displacement pump" using the integration of SolidWorks and Excel.
In his project, he developed the concept of using the Excel platform to command, control and communicate design parameters to Excel.
Not what you're looking for? Search the site.
Google Ads
Contact Professional Education International
Related Stories
- Parker opens new store in Gillingham
- National Instruments - latest company news
- Our new lead generation service!
- Schaeffler - latest company news
- Leuze Electronic - latest company news
Articles by product category
- Consultancy and Services (903)
- Machine Building (4,517)
-
Engineering Design Software (6,179)
- Engineering Design Software (12)
- 2D CAD software (200)
- 3D CAD software (1,157)
- FEA and structural analysis software (369)
- Fluid, thermal, noise, vibration software (334)
- Simulation, modelling, validation software (914)
- Rendering, visualisation, styling software (196)
- Materials design and moulding design software (151)
- Process, instrumentation, automation software (258)
- Electrical design software (164)
- Publishing and documentation software (229)
- Maths, charting, statistics, QA software (317)
- Data, document management software (310)
- CAM, CNC, production management software (568)
- File conversion software, data capture (351)
- PLM and collaboration software (649)
-
Drives, Motors and Controls (3,361)
- Drives, Motors and Controls (1)
- Precision Motors and Gears (411)
- Industrial Drives/Controls (1,276)
- Linear Drives and Motors (114)
- Industrial Motors (497)
- Stepper and Servo Drives, Motors, Controls (1,060)
- Small Mechanical Components, Joining, Tools (1,975)
-
Control and Instrumentation (5,028)
- Plantwide control (1,324)
- Plant- and Machine-Wide Communications (1,174)
- Smaller-Sized PLCs (387)
- CNC and Motion Controllers (184)
- Mid-range and Large PLCs (201)
- Power Supplies, Uninterruptible Power (562)
- HMIs/Operator Interfaces (294)
- Logic Controllers, Timers and Relays (96)
- Cabling, Conduit, Signal Conditioning (806)
-
Monitoring, Measurement and Quality (5,459)
- Monitoring, Measurement and Quality (1)
- Data acquisition Software and Communications (494)
- Data Acquisition Hardware and PC I/O Boards (472)
- Electrical and Electronic Testing, PAT Equipment (630)
- Form/co-ordinate, optical, vision instruments (703)
- Gauges, Indicators and Instruments (440)
- Data loggers (422)
- Materials testing equipment (421)
- Telecomms/network test equipment, software etc (154)
- Testing and Calibration Services and Information (500)
- Testing, analysing and monitoring equipment (1,222)
-
Electrical and Electronic Equipment Design (4,160)
- Batteries, chargers and circuit protection (555)
- Connectors, Terminals, Busbars, Slip Rings (679)
- Enclosures and Equipment Cooling Fans (709)
- Knobs, Handles and Enclosure Hardware (420)
- PCs and Embedded Systems (798)
- Electrical and Electronic Subassemblies (369)
- Electrical and Electronic Components (630)
-
Materials and Processing (2,963)
- Materials and Processing (5)
- Materials and components (2,215)
- Rapid Prototyping (458)
- Materials processing and testing (285)
-
Engineering Industry News, Resources (6,093)
- Engineering Industry News, Resources (4)
- Engineering Business News, Views (388)
- Engineering Exhibitions, Events (562)
- Engineering Conferences (425)
- Engineering Seminars (400)
- Engineering Industry Developments, Awards (633)
- Engineering Guides, Newsletters (349)
- Engineering Recruitment, Employment (219)
- Engineering Training Courses (433)
- Engineering Education, Resources, Standards (838)
- Engineering Industry Reports, Surveys (597)
- Electronic Resources for Engineers (278)
- Health and Safety Legislation (402)
- Health and Safety Strategy, Risk Assessment (113)
- Health and Safety Consultancy, Software (175)
- Health and Safety Events, Training, News (277)
-
Powertrain Design (3,598)
- Powertrain Design (2)
- Bearings (939)
- Chains and belts (326)
- Gears, brakes, couplings and engines (1,441)
- Hydraulic Components (471)
- Lubricants (418)
-
Capital Equipment (3,387)
- Capital Equipment (1)
- Manufacturing Machinery and Plant Equipment (468)
- Production line blowers and fans (62)
- Compressors and Air Treatment (510)
- Electronics Manufacturing, Tools, Instruments (192)
- Electrical hardware (131)
- Machinery and Production Equipment (1,093)
- Robotics, Handling and Storage (930)
-
Sensors (7,080)
- Sensors (8)
- Accelerometers and Vibration Sensors (427)
- Loadcells, Force Sensors, Torque Sensors (699)
- Pressure sensors (621)
- Flowmeters and Flow Sensors (618)
- Level Sensors and Leak Detectors (527)
- Linear Position Sensors (399)
- Rotary Position, Tilt and Angular Sensors (546)
- Proximity Sensors (700)
- Gas, Chemical, Radiation, Magnetic Sensors (284)
- Humidity and Environmental Sensors (152)
- Temperature sensors (612)
- Vision and Colour Sensors (1,384)
- Barcode Sensors (103)
- Valves, Pumps, Process Hardware (3,623)
