基于ExcelVBA的压铸模具浇注系统开发及实现

王引卫; 周美丽; 林东; 刘守法

doi:10.15980/j.tzzz.2018.05.007

计算机应用技术 | 浏览量 : 0 下载量: 68 CSCD: 0

导出
分享
收藏
专辑

基于ExcelVBA的压铸模具浇注系统开发及实现
High Efficiency Development and Realization of Gating System for Die Cast Mould based on Excel VBA
2018年38卷第5期页码：490-492
纸质出版日期： 2018 ，
DOI： 10.15980/j.tzzz.2018.05.007

扫描看全文

[1]王引卫,周美丽,林东,刘守法.基于ExcelVBA的压铸模具浇注系统开发及实现[J].特种铸造及有色合金,2018,38(05):490-492.

Wang Yinwei, Zhou Meili, Lin Dong, et al. High Efficiency Development and Realization of Gating System for Die Cast Mould based on Excel VBA[J]. Special Casting & Nonferrous Alloys, 2018,38(5):490-492.
[1]王引卫,周美丽,林东,刘守法.基于ExcelVBA的压铸模具浇注系统开发及实现[J].特种铸造及有色合金,2018,38(05):490-492. DOI： 10.15980/j.tzzz.2018.05.007.

Wang Yinwei, Zhou Meili, Lin Dong, et al. High Efficiency Development and Realization of Gating System for Die Cast Mould based on Excel VBA[J]. Special Casting & Nonferrous Alloys, 2018,38(5):490-492. DOI： 10.15980/j.tzzz.2018.05.007.

摘要

针对压铸模具开发周期长、浇注系统设计复杂的问题

提出了基于Excel VBA的压铸模具浇注系统高效开发系统。系统集成了模具经验设计公式、常用压铸材料参数、压铸机参数和p-Q

图、常见给料设计方案、常见浇口设计和流道设计参数。利用该系统对某型号PDA外壳浇注系统进行了设计

可高效调用系统中已集成的各类参数

从而完成浇注系统开发

有效避免传统经验法和试错法在模具设计中的不足。

Abstract

Aiming at the long development cycle of die casting die and the complicated design of the gating system

a high efficient development system for gating system of die cast die based on the Excel VBA was put forward.The system includes mold experience design formula

commonly used die casting material parameters

die casting machine parameters and p-Q

diagram

common feeding design plan

common gate design and runner design parameters.Gating system of a PDA shell was designed by the developed system

in which the integrated parameters can be invoked efficiently to complete the development of the gating system

and finally avoid effectively the negative effects of traditional experience and trial and error method on the innovation of die design industry.