基于Excel的行李箱盖扭杆弹簧计算研究

Calculation Of Torsion Bar Spring Of Trunk Lid Based On Excel

针对三厢车行李箱盖用扭杆弹簧布置过程中计算数据量大且正向设计准确性差的问题,对行李箱系统建立了力学模型,通过公式推导将行李箱盖相关作用力矩表示为以行李箱盖开闭角度为单一变量的参数,利用Excel的公式编辑功能,实现了行李箱全开闭角度的开闭力计算,简化了计算过程,提高了设计准确性。同时,通过理论分析提供了行李箱盖开闭力与平衡角度的设计优化方法。

In order to solve the problem of large amount of data and poor accuracy of forward design in the design of torsion bar spring for three compartment car trunk lid,a mechanical model was built for the trunk lid.The torques about the trunk lid were expressed as parameters with a single variable about the opening and closing angle of the trunk lid by the formula deduction.The calculation of the opening and closing force of the trunk lid was realized by applying the formula editing function of Excel.The calculation process was simplified and the design accuracy was improved.At the same time,the design optimization method for the opening/closing force and balance angle of trunk lid was provided by theoretical analysis.