Featured Case StudyThe Norsea Gas Terminal in Northern Germany plays a vital role in the connection of pipeline systems coming from the North Sea to the natural gas distribution network throughout Germany. Built in...Stay
- ANSYS Software
Featured Case StudyRelying on ANSYS Composite PrepPost helped EADS Innovation Works to develop lightweight composites in aircraft design. ANSYS Composite PrepPost provided simple pre- and post-processing of composite...Stay
- Resource Library
- News &
ANSYS Automation using Excel
IBM desired a quick and user-friendly method for designing and analyzing their rack cabinets. Traditional methods took too long and required an experienced ANSYS user to properly build the models. Instead, they wanted to provide input in Microsoft Excel and have it automatically build and analyze the cabinet in ANSYS. IBM chose CAE Associates based on their expertise with the ANSYS software as well as their many years of experience in developing customized, automated ANSYS routines and processes.
CAE Associates developed a detailed Excel spreadsheet system in which IBM could easily enter all of the relevant data for the general design of a rack cabinet. Information like number of vertical and horizontal members, cross section shape, height, length, etc. is entered into the spreadsheet. The components in the rack are included by specifying the location and mass of each component and how it is mounted in the rack. Several different analyses are available: modal, harmonic, random vibration, and transient impulse loading.
Figure 1 - Example Excel Spreadsheet to Drive ANSYS
The data entered into Excel is formatted and written to an ANSYS input file using Visual Basic scripts. ANSYS is called in batch mode to run the input file from within Excel . Automated postprocessing is performed, including the generation of appropriate results plots for each analysis case. The output can be quickly reviewed to determine if the design will meet the environmental criteria.
Figure 2 - Example Model Built Using Excel Inputs
Using Excel to drive ANSYS allows designers who are unfamiliar with FEA to get a quick assessment of their design. This approach also allows for many different designs and configurations to be built and analyzed quickly, leading to a better final product along with a large savings in man-time and costs.
- Engineering Consulting
- ANSYS Software & Support
- ANSYS Training
- About Us
- News & Insights
1579 Straits Turnpike Suite 2B
Middlebury, CT 06762
- ANSYS Software