主办：陕西省汽车工程学会
ISSN 1671-7988  CN 61-1394/TH
创刊：1976年
汽车实用技术

汽车实用技术 ›› 2022, Vol. 48 ›› Issue (7): 92-97.DOI: 10.16638/j.cnki.1671-7988.2023.07.019

• 设计研究 • 上一篇    

基于 Excel 的后背门气弹簧设计计算

李伟，陈巍巍   

  1. 1.浙江智马达智能科技有限公司； 2.宁波吉利汽车研究开发有限公司
  • 出版日期:2023-04-15 发布日期:2023-04-15
  • 通讯作者: 李伟
  • 作者简介:李伟（1985—），男，硕士，工程师，研究方向为车身附件等产品开发设计，E-mail:liwei5687@163.com。

Design Calculation of Tailgate Gas Spring Based on Excel

LI Wei, CHEN Weiwei   

  1. 1.Zhejiang Smart Intelligent Technology Company Limited; 2.Ningbo Geely Automobile Research&Development Company Limited
  • Online:2023-04-15 Published:2023-04-15
  • Contact: LI Wei

PDF

摘要： 针对运动型多用途汽车（SUV）车型后背门气弹簧布置过程中计算调整量大且准确性 差的问题，对后背门开闭系统建立了结构力学模型，通过理论公式推导将后背门相关作用力 矩表示为后背门开闭角度为单一变量的参数，利用 Excel 表格的公式编辑功能实现了后背门 全开闭角度的开闭力计算，简化了计算调整过程，提高了设计准确性。提供了后背门开闭力 与开启可靠性的优化方法。

关键词: 后背门；气弹簧；Excel；设计计算

Abstract: In order to solve the problem of large amount of data and poor accuracy of forward design in the design of gas spring for suburban utility vehicle (SUV) vehicle tailgate, a structural mechanical model was built for the tailgate. The relevant torques about the tailgate were expressed as parameters with a single variable about the opening and closing angle of the tailgate through the theoretical formula. The calculation of the opening and closing force of the tailgate was realized through the formula editing function of Excel. The calculation process was simplified and the accuracy was also improved. The optimization method for the opening/closing force and the opening reliability of tailgate was provided.

Key words: Tailgate; Gas spring; Excel; Design calculation