基于Excel VBA的电子元器件可靠性预计软件的研究  

Research on Reliability Prediction Software of Electronic Components Based on Excel VBA

作　　者：王超 柳力 张宝升 WANG Chao;LIU Li;ZHANG Baosheng(Avic Computing Technique Research Institute,Xi'an 710065,China;The Sixth Military Representative Office of the Air Force Equipment Department in Xi'an,Xi'an 710065,China)

机构地区：[1]航空工业计算所,陕西西安710065 [2]空军装备部驻西安地区第六军事代表室,陕西西安710065

出　　处：《电子产品可靠性与环境试验》2020年第5期80-82,共3页Electronic Product Reliability and Environmental Testing

摘　　要：可靠性预计是在设计阶段对系统的可靠性进行定量评估的方法,随着科技的发展,电子元器件的结构越来越复杂,其可靠性预计成为了一个重要问题。因此,利用Excel VBA数据查询、人机交互界面和Excel表格操作等功能,设计了电子元器件可靠性预计软件,该预计软件可以使电子元器件可靠性预计更方便,具有较强的工程应用价值。Reliability prediction is a quantitative assessment of system reliability during the design phase.With the development of technology,the structure of electronic components is becoming more and more complex,its reliability prediction has become an important issue.By using the functions of Excel VBA data check,human-computer interface and Excel table operation,the reliability prediction software for electronic components is designed.The prediction software can make the reliability prediction of electronic components more convenient,and has strong engineering application value.

关 键 词：EXCEL Visual Basic宏语言 电子元器件 可靠性预计 软件设计 

分 类 号：TP311.521[自动化与计算机技术—计算机软件与理论]