基于VBA语言的Excel二次开发在静态病害数据处理中的应用  

Application of Excel secondary development based on VBA language in static disease data processing

作　　者：潘洋 王章骏 PAN Yang;WANG Zhang-jun

机构地区：[1]广州地铁设计研究院股份有限公司,广东广州510000 [2]中国铁路上海局集团有限公司杭州工务段,浙江衢州310000

出　　处：《智能城市》2023年第6期5-8,共4页Intelligent City

摘　　要：编制生产计划是车间的一项重要工作,利用Excel对静态病害数据库进行分析处理是编制生产计划的重要依据之一。文章利用VBA语言对Excel进行了二次开发。通过循环识别病害数据库中临时补修以及更高级别的病害及其道岔位置、病害是否位于转辙部位等信息,依据车站、岔道号、病害是否位于转辙部分等属性对病害信息进行多条件排序,实现了道岔扣分情况的自动统计。基于VBA语言的二次开发实现了车间病害库数据的自动分析处理,提高了车间的工作效率,探索了车间自动化办公的新途径。The preparation of production plan is an important work in the workshop,and the analysis and processing of static disease database by using Excel is one of the important bases for the preparation of production plan.In the paper,the secondary development of Excel is carried out by using VBA language.Firstly,the information of temporary repair and above grade of disease and its turnout location,whether the disease is located in the rutting part,etc.in the disease database is identified by circulation,and then the disease information is sorted by multiple conditions based on the attributes of station,turnout number,whether the disease is located in the rutting part,etc.,and the automatic statistics of turnout deduction is realized.The secondary development based on VBA language realizes the automatic analysis and processing of the workshop's disease database data,which greatly improves the workshop's working efficiency and explores a new way of the workshop's automated Office.

关 键 词：EXCEL VBA 数据处理 

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