Title: A CAD/CAE integration method based on Excel

Authors: Xiujuan Liu; Fuyun Liu; Lu Han; Renshun Liu; Kuan Li

Addresses: Mechanic and Electronic Engineering, Guilin University of Electronic Technology, Guilin 541004, China ' Mechanic and Electronic Engineering, Guilin University of Electronic Technology, Guilin 541004, China ' Mechanic and Electronic Engineering, Guilin University of Electronic Technology, Guilin 541004, China ' Mechanic and Electronic Engineering, Guilin University of Electronic Technology, Guilin 541004, China ' Mechanic and Electronic Engineering, Guilin University of Electronic Technology, Guilin 541004, China

Abstract: The parametric design technology, parametric CAE analysis technology and Excel unique functions were analysed, and a CAD/CAE integration method based on Excel was proposed. The proposed method can implement CAD/CAE integration automatically and efficiently. In the whole design analysis process, it needs no manual processing. As an example, an output shaft part was used to verify the accuracy and efficiency of the method. Results show that the proposed method has the characteristics of high universality and strong practicability. The proposed method will provide key technology support for us to realise product design efficiently, and to realise variant designs can satisfy engineering constraints.

Keywords: parametric design; Excel; CAD-CAE integration; CAD; CAE; spreadsheets; computer aided design; computer aided engineering; product design.

DOI: 10.1504/IJMSI.2016.082122

International Journal of Materials and Structural Integrity, 2016 Vol.10 No.4, pp.181 - 194

Received: 22 Oct 2016
Accepted: 22 Oct 2016
Published online: 07 Feb 2017 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article